DECLARE
v_request_id NUMBER;
BEGIN
INSERT INTO qa_results_interface (
organization_code
,plan_name
,process_status
,insert_type
,collection_id
,last_update_date
,last_updated_by
,qa_last_updated_by
,transaction_date
,character1
,character2
,character3
,character4
,character5
,character6
,character7
,quantity
,ITEM_ID
,wip_entity_id
,item
,job_name
)
VALUES (
'XX' -- organization_code
,'XX_JOB COMPLETION PLAN' -- plan_name
,1 -- process_status
,1 -- insert_type = INSERT
,QA_COLLECTION_ID_S.NEXTVAL
,SYSDATE
,fnd_global.user_id
,fnd_global.user_id
,SYSDATE
,'1'
,'1'
,'1'
,'1'
,'1'
,'1'
,'1',
1,
1001,
132189,
'Test Item',
'1234'
);
COMMIT;
fnd_global.apps_initialize (user_id, resp_id, appl_id);
v_request_id :=
fnd_request.submit_request('QA',
'QLTTRAMB', -- Program short name
'', -- description (Not require)
'', -- start_time (start immediately)
FALSE, --sub_request (default FALSE)
'200',
'1',
'1133',
'YES'
);
COMMIT;
dbms_output.put_line(v_request_id);
END;
v_request_id NUMBER;
BEGIN
INSERT INTO qa_results_interface (
organization_code
,plan_name
,process_status
,insert_type
,collection_id
,last_update_date
,last_updated_by
,qa_last_updated_by
,transaction_date
,character1
,character2
,character3
,character4
,character5
,character6
,character7
,quantity
,ITEM_ID
,wip_entity_id
,item
,job_name
)
VALUES (
'XX' -- organization_code
,'XX_JOB COMPLETION PLAN' -- plan_name
,1 -- process_status
,1 -- insert_type = INSERT
,QA_COLLECTION_ID_S.NEXTVAL
,SYSDATE
,fnd_global.user_id
,fnd_global.user_id
,SYSDATE
,'1'
,'1'
,'1'
,'1'
,'1'
,'1'
,'1',
1,
1001,
132189,
'Test Item',
'1234'
);
COMMIT;
fnd_global.apps_initialize (user_id, resp_id, appl_id);
v_request_id :=
fnd_request.submit_request('QA',
'QLTTRAMB', -- Program short name
'', -- description (Not require)
'', -- start_time (start immediately)
FALSE, --sub_request (default FALSE)
'200',
'1',
'1133',
'YES'
);
COMMIT;
dbms_output.put_line(v_request_id);
END;
The above approach throwing critical error in QA_INTERFACE_ERRORS
ReplyDelete