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.

[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_INTERFACE_ERRORS

Line 751: INSERT INTO QP_INTERFACE_ERRORS

747: END IF;
748:
749: l_msg_txt:=l_msg_data||' '||l_attribute;
750:
751: INSERT INTO QP_INTERFACE_ERRORS
752: (error_id,last_update_date, last_updated_by, creation_date,
753: created_by, last_update_login, request_id, program_application_id,
754: program_id, program_update_date, entity_type, table_name, column_name,
755: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

754: program_id, program_update_date, entity_type, table_name, column_name,
755: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
756: orig_sys_pricing_attr_ref,error_message)
757: VALUES
758: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
759: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
760: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
761: l_err.orig_sys_header_ref,null,null,null,l_msg_txt);
762:

Line 835: INSERT INTO QP_INTERFACE_ERRORS

831: END IF;
832:
833: l_msg_txt:=l_msg_data||' '||l_attribute;
834:
835: INSERT INTO QP_INTERFACE_ERRORS
836: (error_id,last_update_date, last_updated_by, creation_date,
837: created_by, last_update_login, request_id, program_application_id,
838: program_id, program_update_date, entity_type, table_name, column_name,
839: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

838: program_id, program_update_date, entity_type, table_name, column_name,
839: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
840: orig_sys_pricing_attr_ref, error_message)
841: VALUES
842: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
843: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
844: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
845: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
846:

Line 855: INSERT INTO QP_INTERFACE_ERRORS

851: IF l_err.attribute_status is NULL then
852: l_attribute := 'QUALIFIER_ATTRIBUTE';
853: l_msg_txt:=l_msg_data||' '||l_attribute;
854:
855: INSERT INTO QP_INTERFACE_ERRORS
856: (error_id,last_update_date, last_updated_by, creation_date,
857: created_by, last_update_login, request_id, program_application_id,
858: program_id, program_update_date, entity_type, table_name, column_name,
859: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

858: program_id, program_update_date, entity_type, table_name, column_name,
859: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
860: orig_sys_pricing_attr_ref, error_message)
861: VALUES
862: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
863: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
864: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
865: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
866: END IF;

Line 928: INSERT INTO QP_INTERFACE_ERRORS

924: IF l_err.attribute_status is NULL then
925: if l_err.pac is not NULL and l_err.pa is NULL then
926: l_attribute := 'PRODUCT_ATTRIBUTE';
927: l_msg_txt:=l_msg_data||' '||l_attribute;
928: INSERT INTO QP_INTERFACE_ERRORS
929: (error_id,last_update_date, last_updated_by, creation_date,
930: created_by, last_update_login, request_id, program_application_id,
931: program_id, program_update_date, entity_type, table_name, column_name,
932: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

931: program_id, program_update_date, entity_type, table_name, column_name,
932: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
933: orig_sys_pricing_attr_ref,error_message)
934: VALUES
935: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
936: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
937: NULL,NULL, 'PRL',l_err.table_name, NULL,
938: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
939: end if;

Line 943: INSERT INTO QP_INTERFACE_ERRORS

939: end if;
940: if l_err.pcac is not NULL and l_err.pca is NULL then
941: l_attribute := 'PRICING_ATTRIBUTE';
942: l_msg_txt:=l_msg_data||' '||l_attribute;
943: INSERT INTO QP_INTERFACE_ERRORS
944: (error_id,last_update_date, last_updated_by, creation_date,
945: created_by, last_update_login, request_id, program_application_id,
946: program_id, program_update_date, entity_type, table_name, column_name,
947: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

946: program_id, program_update_date, entity_type, table_name, column_name,
947: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
948: orig_sys_pricing_attr_ref,error_message)
949: VALUES
950: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
951: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
952: NULL,NULL, 'PRL',l_err.table_name, NULL,
953: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
954: end if;

Line 958: INSERT INTO QP_INTERFACE_ERRORS

954: end if;
955: if l_err.pavd is not NULL and l_err.pav is NULL then
956: l_attribute := 'PRODUCT_ATTRIBUTE_VALUE';
957: l_msg_txt:=l_msg_data||' '||l_attribute;
958: INSERT INTO QP_INTERFACE_ERRORS
959: (error_id,last_update_date, last_updated_by, creation_date,
960: created_by, last_update_login, request_id, program_application_id,
961: program_id, program_update_date, entity_type, table_name, column_name,
962: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

961: program_id, program_update_date, entity_type, table_name, column_name,
962: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
963: orig_sys_pricing_attr_ref,error_message)
964: VALUES
965: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
966: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
967: NULL,NULL, 'PRL',l_err.table_name, NULL,
968: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
969: end if;

Line 972: INSERT INTO QP_INTERFACE_ERRORS

968: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
969: end if;
970: if l_err.pavd is NULL and l_err.pav is NULL then
971: l_msg_txt := FND_MESSAGE.GET_STRING('QP','QP_INVALID_PROD_VALUE');
972: INSERT INTO QP_INTERFACE_ERRORS
973: (error_id,last_update_date, last_updated_by, creation_date,
974: created_by, last_update_login, request_id, program_application_id,
975: program_id, program_update_date, entity_type, table_name, column_name,
976: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

975: program_id, program_update_date, entity_type, table_name, column_name,
976: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
977: orig_sys_pricing_attr_ref,error_message)
978: VALUES
979: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
980: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
981: NULL,NULL, 'PRL',l_err.table_name, NULL,
982: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
983: end if;

Line 1020: INSERT INTO QP_INTERFACE_ERRORS

1016: END IF;
1017:
1018: l_msg_txt:=l_msg_data||' '||l_attribute;
1019:
1020: INSERT INTO QP_INTERFACE_ERRORS
1021: (error_id,last_update_date, last_updated_by, creation_date,
1022: created_by, last_update_login, request_id, program_application_id,
1023: program_id, program_update_date, entity_type, table_name, column_name,
1024: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

1023: program_id, program_update_date, entity_type, table_name, column_name,
1024: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1025: orig_sys_pricing_attr_ref,error_message)
1026: VALUES
1027: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1028: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1029: NULL,NULL, 'PRL',l_err.table_name, NULL,
1030: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
1031: