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 720: INSERT INTO QP_INTERFACE_ERRORS

716: END IF;
717:
718: l_msg_txt:=l_msg_data||' '||l_attribute;
719:
720: INSERT INTO QP_INTERFACE_ERRORS
721: (error_id,last_update_date, last_updated_by, creation_date,
722: created_by, last_update_login, request_id, program_application_id,
723: program_id, program_update_date, entity_type, table_name, column_name,
724: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

723: program_id, program_update_date, entity_type, table_name, column_name,
724: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
725: orig_sys_pricing_attr_ref,error_message)
726: VALUES
727: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
728: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
729: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
730: l_err.orig_sys_header_ref,null,null,null,l_msg_txt);
731:

Line 804: INSERT INTO QP_INTERFACE_ERRORS

800: END IF;
801:
802: l_msg_txt:=l_msg_data||' '||l_attribute;
803:
804: INSERT INTO QP_INTERFACE_ERRORS
805: (error_id,last_update_date, last_updated_by, creation_date,
806: created_by, last_update_login, request_id, program_application_id,
807: program_id, program_update_date, entity_type, table_name, column_name,
808: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

807: program_id, program_update_date, entity_type, table_name, column_name,
808: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
809: orig_sys_pricing_attr_ref, error_message)
810: VALUES
811: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
812: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
813: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
814: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
815:

Line 824: INSERT INTO QP_INTERFACE_ERRORS

820: IF l_err.attribute_status is NULL then
821: l_attribute := 'QUALIFIER_ATTRIBUTE';
822: l_msg_txt:=l_msg_data||' '||l_attribute;
823:
824: INSERT INTO QP_INTERFACE_ERRORS
825: (error_id,last_update_date, last_updated_by, creation_date,
826: created_by, last_update_login, request_id, program_application_id,
827: program_id, program_update_date, entity_type, table_name, column_name,
828: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

827: program_id, program_update_date, entity_type, table_name, column_name,
828: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
829: orig_sys_pricing_attr_ref, error_message)
830: VALUES
831: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
832: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
834: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
835: END IF;

Line 897: INSERT INTO QP_INTERFACE_ERRORS

893: IF l_err.attribute_status is NULL then
894: if l_err.pac is not NULL and l_err.pa is NULL then
895: l_attribute := 'PRODUCT_ATTRIBUTE';
896: l_msg_txt:=l_msg_data||' '||l_attribute;
897: INSERT INTO QP_INTERFACE_ERRORS
898: (error_id,last_update_date, last_updated_by, creation_date,
899: created_by, last_update_login, request_id, program_application_id,
900: program_id, program_update_date, entity_type, table_name, column_name,
901: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

900: program_id, program_update_date, entity_type, table_name, column_name,
901: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
902: orig_sys_pricing_attr_ref,error_message)
903: VALUES
904: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
905: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
906: NULL,NULL, 'PRL',l_err.table_name, NULL,
907: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
908: end if;

Line 912: INSERT INTO QP_INTERFACE_ERRORS

908: end if;
909: if l_err.pcac is not NULL and l_err.pca is NULL then
910: l_attribute := 'PRICING_ATTRIBUTE';
911: l_msg_txt:=l_msg_data||' '||l_attribute;
912: INSERT INTO QP_INTERFACE_ERRORS
913: (error_id,last_update_date, last_updated_by, creation_date,
914: created_by, last_update_login, request_id, program_application_id,
915: program_id, program_update_date, entity_type, table_name, column_name,
916: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

915: program_id, program_update_date, entity_type, table_name, column_name,
916: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
917: orig_sys_pricing_attr_ref,error_message)
918: VALUES
919: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
920: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
921: NULL,NULL, 'PRL',l_err.table_name, NULL,
922: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
923: end if;

Line 927: INSERT INTO QP_INTERFACE_ERRORS

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

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

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

Line 941: INSERT INTO QP_INTERFACE_ERRORS

937: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
938: end if;
939: if l_err.pavd is NULL and l_err.pav is NULL then
940: l_msg_txt := FND_MESSAGE.GET_STRING('QP','QP_INVALID_PROD_VALUE');
941: INSERT INTO QP_INTERFACE_ERRORS
942: (error_id,last_update_date, last_updated_by, creation_date,
943: created_by, last_update_login, request_id, program_application_id,
944: program_id, program_update_date, entity_type, table_name, column_name,
945: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

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

Line 989: INSERT INTO QP_INTERFACE_ERRORS

985: END IF;
986:
987: l_msg_txt:=l_msg_data||' '||l_attribute;
988:
989: INSERT INTO QP_INTERFACE_ERRORS
990: (error_id,last_update_date, last_updated_by, creation_date,
991: created_by, last_update_login, request_id, program_application_id,
992: program_id, program_update_date, entity_type, table_name, column_name,
993: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

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

992: program_id, program_update_date, entity_type, table_name, column_name,
993: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
994: orig_sys_pricing_attr_ref,error_message)
995: VALUES
996: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
997: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
998: NULL,NULL, 'PRL',l_err.table_name, NULL,
999: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
1000: