DBA Data[Home] [Help]

APPS.QP_BULK_LOADER_PUB dependencies on FND_MESSAGE

Line 298: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');

294: THEN
295:
296: -- Bug#3604226 RAVI START
297: -- Orig_Sys_Hdr_ref has to be unique for insertion
298: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
299: l_msg_txt := FND_MESSAGE.GET;
300:
301: INSERT INTO QP_INTERFACE_ERRORS
302: (error_id,last_update_date, last_updated_by, creation_date,

Line 299: l_msg_txt := FND_MESSAGE.GET;

295:
296: -- Bug#3604226 RAVI START
297: -- Orig_Sys_Hdr_ref has to be unique for insertion
298: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
299: l_msg_txt := FND_MESSAGE.GET;
300:
301: INSERT INTO QP_INTERFACE_ERRORS
302: (error_id,last_update_date, last_updated_by, creation_date,
303: created_by, last_update_login, request_id, program_application_id,

Line 920: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');

916:
917: -- Bug#3604226 RAVI START
918: -- Orig_Sys_Hdr_ref has to be unique for insertion
919:
920: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
921: l_msg_txt := FND_MESSAGE.GET;
922:
923: INSERT INTO QP_INTERFACE_ERRORS
924: (error_id,last_update_date, last_updated_by, creation_date,

Line 921: l_msg_txt := FND_MESSAGE.GET;

917: -- Bug#3604226 RAVI START
918: -- Orig_Sys_Hdr_ref has to be unique for insertion
919:
920: fnd_message.set_name('QP', 'QP_HDR_REF_NOT_UNIQUE');
921: l_msg_txt := FND_MESSAGE.GET;
922:
923: INSERT INTO QP_INTERFACE_ERRORS
924: (error_id,last_update_date, last_updated_by, creation_date,
925: created_by, last_update_login, request_id, program_application_id,

Line 3392: err_buff := FND_MESSAGE.GET;

3388: IF l_new_request_id=0
3389: THEN
3390: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error in spawning child process');
3391: retcode := 2;
3392: err_buff := FND_MESSAGE.GET;
3393: Return;
3394: ELSE
3395: G_thread_info_table(I).request_id := l_new_request_id;
3396:

Line 4617: err_buff := FND_MESSAGE.GET;

4613: retcode := 2;
4614: write_log('Unexpected error '||substr(sqlerrm,1200));
4615: write_log( ' ');
4616: oe_debug_pub.add(sqlerrm);
4617: err_buff := FND_MESSAGE.GET;
4618: WHEN OTHERS THEN
4619: retcode := 2;
4620: write_log('Unexpected error '||substr(sqlerrm,1200));
4621: write_log( ' ');

Line 4623: err_buff := FND_MESSAGE.GET;

4619: retcode := 2;
4620: write_log('Unexpected error '||substr(sqlerrm,1200));
4621: write_log( ' ');
4622: oe_debug_pub.add(sqlerrm);
4623: err_buff := FND_MESSAGE.GET;
4624:
4625: END LOAD_LISTS;
4626:
4627:

Line 5729: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PARENT_PBH_REF');

5725: );
5726: EXCEPTION
5727: WHEN NO_DATA_FOUND THEN
5728: G_INS_LINE_REC.process_status_flag(I):=NULL;
5729: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PARENT_PBH_REF');
5730: l_msg_txt:= FND_MESSAGE.GET;
5731: --Insert msg
5732: INSERT INTO QP_INTERFACE_ERRORS
5733: (error_id,last_update_date, last_updated_by, creation_date,

Line 5730: l_msg_txt:= FND_MESSAGE.GET;

5726: EXCEPTION
5727: WHEN NO_DATA_FOUND THEN
5728: G_INS_LINE_REC.process_status_flag(I):=NULL;
5729: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PARENT_PBH_REF');
5730: l_msg_txt:= FND_MESSAGE.GET;
5731: --Insert msg
5732: INSERT INTO QP_INTERFACE_ERRORS
5733: (error_id,last_update_date, last_updated_by, creation_date,
5734: created_by, last_update_login, request_id, program_application_id,

Line 6871: FND_MESSAGE.SET_NAME('QP', 'PR_LINE_REQ_PROD_ATTR');

6867: DELETE FROM QP_RLTD_MODIFIERS
6868: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I);
6869:
6870:
6871: FND_MESSAGE.SET_NAME('QP', 'PR_LINE_REQ_PROD_ATTR');
6872: l_msg_txt := FND_MESSAGE.GET;
6873:
6874: FORALL I in l_orig_sys_line_ref_tbl.first..l_orig_sys_line_ref_tbl.last
6875: INSERT INTO QP_INTERFACE_ERRORS

Line 6872: l_msg_txt := FND_MESSAGE.GET;

6868: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I);
6869:
6870:
6871: FND_MESSAGE.SET_NAME('QP', 'PR_LINE_REQ_PROD_ATTR');
6872: l_msg_txt := FND_MESSAGE.GET;
6873:
6874: FORALL I in l_orig_sys_line_ref_tbl.first..l_orig_sys_line_ref_tbl.last
6875: INSERT INTO QP_INTERFACE_ERRORS
6876: (error_id,last_update_date, last_updated_by, creation_date,