406: THEN
407:
408: -- Bug#3604226 RAVI START
409: -- Orig_Sys_Hdr_ref has to be unique for insertion
410: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
411: l_msg_txt := FND_MESSAGE.GET;
412:
413: INSERT INTO QP_INTERFACE_ERRORS
414: (error_id,last_update_date, last_updated_by, creation_date,
407:
408: -- Bug#3604226 RAVI START
409: -- Orig_Sys_Hdr_ref has to be unique for insertion
410: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
411: l_msg_txt := FND_MESSAGE.GET;
412:
413: INSERT INTO QP_INTERFACE_ERRORS
414: (error_id,last_update_date, last_updated_by, creation_date,
415: created_by, last_update_login, request_id, program_application_id,
1028:
1029: -- Bug#3604226 RAVI START
1030: -- Orig_Sys_Hdr_ref has to be unique for insertion
1031:
1032: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
1033: l_msg_txt := FND_MESSAGE.GET;
1034:
1035: INSERT INTO QP_INTERFACE_ERRORS
1036: (error_id,last_update_date, last_updated_by, creation_date,
1029: -- Bug#3604226 RAVI START
1030: -- Orig_Sys_Hdr_ref has to be unique for insertion
1031:
1032: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
1033: l_msg_txt := FND_MESSAGE.GET;
1034:
1035: INSERT INTO QP_INTERFACE_ERRORS
1036: (error_id,last_update_date, last_updated_by, creation_date,
1037: created_by, last_update_login, request_id, program_application_id,
3507: IF l_new_request_id=0
3508: THEN
3509: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error in spawning child process');
3510: retcode := 2;
3511: err_buff := FND_MESSAGE.GET;
3512: Return;
3513: ELSE
3514: G_thread_info_table(I).request_id := l_new_request_id;
3515:
4732: retcode := 2;
4733: write_log('Unexpected error '||substr(sqlerrm,1200));
4734: write_log( ' ');
4735: oe_debug_pub.add(sqlerrm);
4736: err_buff := FND_MESSAGE.GET;
4737: WHEN OTHERS THEN
4738: retcode := 2;
4739: write_log('Unexpected error '||substr(sqlerrm,1200));
4740: write_log( ' ');
4738: retcode := 2;
4739: write_log('Unexpected error '||substr(sqlerrm,1200));
4740: write_log( ' ');
4741: oe_debug_pub.add(sqlerrm);
4742: err_buff := FND_MESSAGE.GET;
4743:
4744: END LOAD_LISTS;
4745:
4746:
6122: );
6123: EXCEPTION
6124: WHEN NO_DATA_FOUND THEN
6125: G_INS_LINE_REC.process_status_flag(I):=NULL;
6126: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PARENT_PBH_REF');
6127: l_msg_txt:= FND_MESSAGE.GET;
6128: --Insert msg
6129: INSERT INTO QP_INTERFACE_ERRORS
6130: (error_id,last_update_date, last_updated_by, creation_date,
6123: EXCEPTION
6124: WHEN NO_DATA_FOUND THEN
6125: G_INS_LINE_REC.process_status_flag(I):=NULL;
6126: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PARENT_PBH_REF');
6127: l_msg_txt:= FND_MESSAGE.GET;
6128: --Insert msg
6129: INSERT INTO QP_INTERFACE_ERRORS
6130: (error_id,last_update_date, last_updated_by, creation_date,
6131: created_by, last_update_login, request_id, program_application_id,
6991: DELETE FROM QP_RLTD_MODIFIERS
6992: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I);
6993:
6994:
6995: FND_MESSAGE.SET_NAME('QP', 'PR_LINE_REQ_PROD_ATTR');
6996: l_msg_txt := FND_MESSAGE.GET;
6997:
6998: FORALL I in l_orig_sys_line_ref_tbl.first..l_orig_sys_line_ref_tbl.last
6999: INSERT INTO QP_INTERFACE_ERRORS
6992: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I);
6993:
6994:
6995: FND_MESSAGE.SET_NAME('QP', 'PR_LINE_REQ_PROD_ATTR');
6996: l_msg_txt := FND_MESSAGE.GET;
6997:
6998: FORALL I in l_orig_sys_line_ref_tbl.first..l_orig_sys_line_ref_tbl.last
6999: INSERT INTO QP_INTERFACE_ERRORS
7000: (error_id,last_update_date, last_updated_by, creation_date,