eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_LOADER_PUB dependencies on QP_INTERFACE_ERRORS

Line 413: INSERT INTO QP_INTERFACE_ERRORS

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,
416: program_id, program_update_date, entity_type, table_name, column_name,
417: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 420: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

416: program_id, program_update_date, entity_type, table_name, column_name,
417: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
418: orig_sys_pricing_attr_ref, error_message)
419: SELECT
420: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
421: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
422: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
423: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
424: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 1035: INSERT INTO QP_INTERFACE_ERRORS

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,
1038: program_id, program_update_date, entity_type, table_name, column_name,
1039: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 1042: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

1038: program_id, program_update_date, entity_type, table_name, column_name,
1039: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1040: orig_sys_pricing_attr_ref, error_message)
1041: SELECT
1042: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1043: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
1044: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
1045: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
1046: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 6129: INSERT INTO QP_INTERFACE_ERRORS

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,
6132: program_id, program_update_date, entity_type, table_name, column_name,
6133: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6136: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6132: program_id, program_update_date, entity_type, table_name, column_name,
6133: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6134: orig_sys_pricing_attr_ref,error_message)
6135: VALUES
6136: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6137: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
6138: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
6139: G_INS_LINE_REC.orig_sys_header_ref(I),G_INS_LINE_REC.orig_sys_line_ref(I),
6140: null,null,l_msg_txt);

Line 6999: INSERT INTO QP_INTERFACE_ERRORS

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,
7001: created_by, last_update_login, request_id, program_application_id,
7002: program_id, program_update_date, entity_type, table_name, column_name,
7003: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 7006: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

7002: program_id, program_update_date, entity_type, table_name, column_name,
7003: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
7004: orig_sys_pricing_attr_ref,error_message)
7005: VALUES
7006: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
7007: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
7008: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
7009: null,l_orig_sys_line_ref_tbl(I),null,null,l_msg_txt);
7010:

Line 7158: from QP_INTERFACE_ERRORS

7154: orig_sys_line_ref,
7155: orig_sys_pricing_attr_ref,
7156: orig_sys_qualifier_ref,
7157: error_message
7158: from QP_INTERFACE_ERRORS
7159: WHERE request_id = p_request_id;
7160:
7161: l_request_id NUMBER;
7162: l_ENTITY_TYPE VARCHAR2(30);