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.PON_VALIDATE_PAYMENTS_INT dependencies on PON_INTERFACE_ERRORS

Line 24: l_entity_name PON_INTERFACE_ERRORS.entity_message_code%TYPE;

20: l_exp_date DATE;
21: l_interface_type VARCHAR2(15);
22: l_module CONSTANT VARCHAR2(32) := 'VALIDATE_RESPONSE';
23: l_progress varchar2(200);
24: l_entity_name PON_INTERFACE_ERRORS.entity_message_code%TYPE;
25:
26: BEGIN
27:
28: l_userid := fnd_global.user_id;

Line 45: INSERT INTO PON_INTERFACE_ERRORS

41:
42: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
43: BEGIN
44:
45: INSERT INTO PON_INTERFACE_ERRORS
46: (
47: column_name,
48: error_message_name,
49: error_value_datatype,

Line 133: INTO pon_interface_errors

129:
130: INSERT ALL
131: WHEN supplier_can_modify_payments = 'Y' AND
132: unit_of_measure IS NOT NULL AND uom_code IS NULL THEN
133: INTO pon_interface_errors
134: (
135: column_name, entity_attr_name, error_message_name, -- 1
136: error_value_datatype, error_value, error_value_date, -- 2
137: token1_name, token1_value, token2_name, -- 3

Line 165: INTO pon_interface_errors

161: s_entity_name ,
162: p_request_id
163: )
164: WHEN p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode AND bid_line_number IS NOT NULL and group_type IN ('GROUP','LOT_LINE') THEN
165: INTO pon_interface_errors
166: (
167: column_name, entity_attr_name, error_message_name, -- 1
168: error_value_datatype, error_value, error_value_date, -- 2
169: token1_name, token1_value, token2_name, -- 3

Line 191: INTO pon_interface_errors

187: l_userid, SYSDATE, l_loginid,
188: p_request_id
189: )
190: WHEN p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode AND bid_line_number IS NULL THEN
191: INTO pon_interface_errors
192: (
193: column_name, entity_attr_name, error_message_name, -- 1
194: error_value_datatype, error_value, error_value_date, -- 2
195: token1_name, token1_value, token2_name, -- 3

Line 224: INTO pon_interface_errors

220: ((line_type = 'GOODS' AND lookup_payment_type_code <> 'MILESTONE') OR
221: (payment_type IS NOT NULL AND lookup_payment_type_code IS NULL) OR
222: (lookup_payment_type_code IS NOT NULL AND lookup_payment_type_code NOT IN
223: (SELECT pay_item_type FROM PO_STYLE_ENABLED_PAY_ITEMS WHERE style_id = po_style_id))) THEN
224: INTO pon_interface_errors
225: (
226: column_name,
227: entity_attr_name, error_message_name, -- 1
228: error_value_datatype, error_value, error_value_date, -- 2

Line 257: INTO pon_interface_errors

253: s_entity_name,
254: p_request_id
255: )
256: WHEN payment_display_number < 1 OR payment_display_number<> ROUND(payment_display_number) THEN
257: INTO pon_interface_errors
258: (
259: column_name,
260: entity_attr_name, error_message_name, -- 1
261: error_value_datatype, error_value, error_value_date, -- 2

Line 291: INTO pon_interface_errors

287: p_request_id
288: )
289: WHEN supplier_can_modify_payments = 'Y' AND
290: lookup_payment_type_code = 'RATE' AND quantity < 0 THEN
291: INTO pon_interface_errors
292: (
293: column_name, entity_attr_name, error_message_name, -- 1
294: error_value_datatype, error_value_number, error_value_date, -- 2
295: token1_name, token1_value, token2_name, -- 3

Line 323: INTO pon_interface_errors

319: p_request_id
320: )
321: WHEN supplier_can_modify_payments = 'Y' AND
322: lookup_payment_type_code = 'RATE' AND unit_of_measure IS NULL THEN
323: INTO pon_interface_errors
324: (
325: column_name, entity_attr_name, error_message_name, -- 1
326: error_value_datatype, error_value, error_value_date, -- 2
327: token1_name, token1_value, token2_name, -- 3

Line 354: INTO pon_interface_errors

350: s_entity_name,
351: p_request_id
352: )
353: WHEN bid_currency_price IS NOT NULL AND bid_currency_price < 0 THEN
354: INTO pon_interface_errors
355: (
356: column_name, entity_attr_name, error_message_name, -- 1
357: error_value_datatype, error_value_number, error_value_date, -- 2
358: token1_name, token1_value, token2_name, -- 3

Line 386: INTO pon_interface_errors

382: p_request_id
383: )
384: WHEN supplier_can_modify_payments = 'Y' AND
385: lookup_payment_type_code = 'RATE' AND quantity IS NULL THEN
386: INTO pon_interface_errors
387: (
388: column_name, entity_attr_name, error_message_name, -- 1
389: error_value_datatype, error_value, error_value_date, -- 2
390: token1_name, token1_value, token2_name, -- 3

Line 417: INTO pon_interface_errors

413: s_entity_name,
414: p_request_id
415: )
416: WHEN bid_currency_price IS NULL THEN
417: INTO pon_interface_errors
418: (
419: column_name, entity_attr_name, error_message_name, -- 1
420: error_value_datatype, error_value, error_value_date, -- 2
421: token1_name, token1_value, token2_name, -- 3

Line 450: INTO pon_interface_errors

446: )
447: WHEN bid_currency_price IS NOT NULL
448: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(
449: bid_currency_price, pbh_price_precision) = 'F' THEN
450: INTO pon_interface_errors
451: (
452: column_name, entity_attr_name, error_message_name, -- 1
453: error_value_datatype, error_value_number, error_value_date, -- 2
454: token1_name, token1_value, token2_name, -- 3

Line 481: INTO pon_interface_errors

477: s_entity_name,
478: p_request_id
479: )
480: WHEN promised_date IS NOT NULL AND promised_date <= close_bidding_date THEN
481: INTO pon_interface_errors
482: (
483: column_name, entity_attr_name, error_message_name, -- 1
484: error_value_datatype, error_value_number, error_value_date, -- 2
485: token1_name, token1_value, token2_name, -- 3

Line 568: INSERT INTO PON_INTERFACE_ERRORS

564:
565:
566: -- This validation is done in a separate sql as this one needs join to
567: -- pon_auc_payments_shipments and all the other validations don't need them.
568: INSERT INTO PON_INTERFACE_ERRORS
569: (
570: column_name, entity_attr_name, error_message_name, -- 1
571: error_value_datatype, error_value_number, error_value_date, -- 2
572: token1_name, token1_value, token2_name, -- 3

Line 662: INTO pon_interface_errors

658: END IF;
659:
660: INSERT ALL
661: WHEN line_origination_code <> 'REQUISITION' AND project_number IS NOT NULL AND pro_project_id IS NULL THEN
662: INTO pon_interface_errors
663: (
664: column_name, entity_attr_name, error_message_name, -- 1
665: error_value_datatype, error_value, error_value_date, -- 2
666: token1_name, token1_value, token2_name, -- 3

Line 691: INTO pon_interface_errors

687: AND project_task_number IS NOT NULL
688: AND NOT EXISTS (SELECT 1
689: FROM PA_TASKS_EXPEND_V task
690: WHERE task.project_id = pro_project_id AND task.task_number = project_task_number) THEN
691: INTO pon_interface_errors
692: (
693: column_name, entity_attr_name, error_message_name, -- 1
694: error_value_datatype, error_value, error_value_date, -- 2
695: token1_name, token1_value, token2_name, -- 3

Line 724: INTO pon_interface_errors

720: WHERE award.project_id = pro_project_id
721: AND task.task_number = project_task_number
722: AND award.task_id = task.task_id
723: AND task.project_id = pro_project_id) THEN
724: INTO pon_interface_errors
725: (
726: column_name, entity_attr_name, error_message_name, -- 1
727: error_value_datatype, error_value, error_value_date, -- 2
728: token1_name, token1_value, token2_name, -- 3

Line 748: AND PON_NEGOTIATION_PUBLISH_PVT.IS_PROJECT_SPONSORED(pro_project_id) = 'Y' THEN INTO pon_interface_errors

744: l_userid, SYSDATE, l_loginid -- 8
745: )
746: WHEN pro_project_id IS NOT NULL
747: AND project_award_number IS NULL
748: AND PON_NEGOTIATION_PUBLISH_PVT.IS_PROJECT_SPONSORED(pro_project_id) = 'Y' THEN INTO pon_interface_errors
749: (
750: column_name, entity_attr_name, error_message_name, -- 1
751: error_value_datatype, error_value, error_value_date, -- 2
752: token1_name, token1_value, token2_name, -- 3

Line 772: INTO pon_interface_errors

768: l_userid, SYSDATE, l_loginid -- 8
769: )
770: WHEN line_origination_code <> 'REQUISITION' AND project_exp_organization_name IS NOT NULL
771: AND porg_proj_exp_organization_id IS NULL THEN
772: INTO pon_interface_errors
773: (
774: column_name, entity_attr_name, error_message_name, -- 1
775: error_value_datatype, error_value, error_value_date, -- 2
776: token1_name, token1_value, token2_name, -- 3

Line 804: INTO pon_interface_errors

800: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
801: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))
802: AND trunc(sysdate) BETWEEN nvl(exptype.sys_link_start_date_active, trunc(sysdate))
803: AND nvl(exptype.sys_link_end_date_Active, trunc(sysdate))) THEN
804: INTO pon_interface_errors
805: (
806: column_name, entity_attr_name, error_message_name, -- 1
807: error_value_datatype, error_value, error_value_date, -- 2
808: token1_name, token1_value, token2_name, -- 3

Line 831: INTO pon_interface_errors

827: (project_number IS NOT NULL OR project_task_number IS NOT NULL OR project_exp_organization_name IS NOT NULL
828: OR project_expenditure_item_date IS NOT NULL OR project_expenditure_type IS NOT NULL)
829: AND (project_number IS NULL OR project_task_number IS NULL OR project_exp_organization_name IS NULL
830: OR project_expenditure_item_date IS NULL OR project_expenditure_type IS NULL) THEN
831: INTO pon_interface_errors
832: (
833: column_name, entity_attr_name, error_message_name, -- 1
834: error_value_datatype, error_value, error_value_date, -- 2
835: token1_name, token1_value, token2_name, -- 3

Line 854: INTO pon_interface_errors

850: l_exp_date, l_userid, SYSDATE, -- 7
851: l_userid, SYSDATE, l_loginid -- 8
852: )
853: WHEN ship_to_location_code IS NOT NULL AND ship_to_location_id IS NULL THEN
854: INTO pon_interface_errors
855: (
856: column_name, entity_attr_name, error_message_name, -- 1
857: error_value_datatype, error_value, error_value_date, -- 2
858: token1_name, token1_value, token2_name, -- 3

Line 877: INTO pon_interface_errors

873: l_exp_date, l_userid, SYSDATE, -- 7
874: l_userid, SYSDATE, l_loginid -- 8
875: )
876: WHEN unit_of_measure IS NOT NULL AND uom_uom_code IS NULL THEN
877: INTO pon_interface_errors
878: (
879: column_name, entity_attr_name, error_message_name, -- 1
880: error_value_datatype, error_value, error_value_date, -- 2
881: token1_name, token1_value, token2_name, -- 3

Line 907: INTO pon_interface_errors

903: WHERE fu.user_name = work_approver_user_name
904: AND fu.employee_id = peo.person_id
905: AND SYSDATE >= nvl(fu.start_date, SYSDATE)
906: AND SYSDATE <= nvl(fu.end_date, SYSDATE) ) THEN
907: INTO pon_interface_errors
908: (
909: column_name, entity_attr_name, error_message_name, -- 1
910: error_value_datatype, error_value, error_value_date, -- 2
911: token1_name, token1_value, token2_name, -- 3

Line 937: INTO pon_interface_errors

933: WHEN ((line_type = 'GOODS' AND lookup_payment_type_code <> 'MILESTONE') OR
934: (payment_type IS NOT NULL AND lookup_payment_type_code IS NULL) OR
935: (lookup_payment_type_code IS NOT NULL AND lookup_payment_type_code NOT IN
936: (SELECT pay_item_type FROM PO_STYLE_ENABLED_PAY_ITEMS WHERE style_id = po_style_id))) THEN
937: INTO pon_interface_errors
938: (
939: column_name, entity_attr_name, error_message_name, -- 1
940: error_value_datatype, error_value, error_value_date, -- 2
941: token1_name, token1_value, token2_name, -- 3

Line 960: INTO pon_interface_errors

956: l_exp_date, l_userid, SYSDATE, -- 7
957: l_userid, SYSDATE, l_loginid -- 8
958: )
959: WHEN auction_line_number IS NULL THEN
960: INTO pon_interface_errors
961: (
962: column_name, entity_attr_name, error_message_name, -- 1
963: error_value_datatype, error_value, error_value_date, -- 2
964: token1_name, token1_value, token2_name, -- 3

Line 983: INTO pon_interface_errors

979: l_exp_date, l_userid, SYSDATE, -- 7
980: l_userid, SYSDATE, l_loginid -- 8
981: )
982: WHEN auction_line_number IS NOT NULL and group_type IN ('GROUP','LOT_LINE') THEN
983: INTO pon_interface_errors
984: (
985: column_name, entity_attr_name, error_message_name, -- 1
986: error_value_datatype, error_value, error_value_date, -- 2
987: token1_name, token1_value, token2_name, -- 3

Line 1006: INTO pon_interface_errors

1002: l_exp_date, l_userid, SYSDATE, -- 7
1003: l_userid, SYSDATE, l_loginid -- 8
1004: )
1005: WHEN lookup_payment_type_code = 'RATE' AND unit_of_measure IS NULL THEN
1006: INTO pon_interface_errors
1007: (
1008: column_name, entity_attr_name, error_message_name, -- 1
1009: error_value_datatype, error_value, error_value_date, -- 2
1010: token1_name, token1_value, token2_name, -- 3

Line 1029: INTO pon_interface_errors

1025: l_exp_date, l_userid, SYSDATE, -- 7
1026: l_userid, SYSDATE, l_loginid -- 8
1027: )
1028: WHEN payment_display_number < 1 OR payment_display_number<> ROUND(payment_display_number) THEN
1029: INTO pon_interface_errors
1030: (
1031: column_name, entity_attr_name, error_message_name, -- 1
1032: error_value_datatype, error_value, error_value_date, -- 2
1033: token1_name, token1_value, token2_name, -- 3

Line 1052: INTO pon_interface_errors

1048: l_exp_date, l_userid, SYSDATE, -- 7
1049: l_userid, SYSDATE, l_loginid -- 8
1050: )
1051: WHEN lookup_payment_type_code = 'RATE' AND quantity < 0 THEN
1052: INTO pon_interface_errors
1053: (
1054: column_name, entity_attr_name, error_message_name, -- 1
1055: error_value_datatype, error_value_number, error_value_date, -- 2
1056: token1_name, token1_value, token2_name, -- 3

Line 1075: INTO pon_interface_errors

1071: l_exp_date, l_userid, SYSDATE, -- 7
1072: l_userid, SYSDATE, l_loginid -- 8
1073: )
1074: WHEN target_price IS NOT NULL AND target_price < 0 THEN
1075: INTO pon_interface_errors
1076: (
1077: column_name, entity_attr_name, error_message_name, -- 1
1078: error_value_datatype, error_value_number, error_value_date, -- 2
1079: token1_name, token1_value, token2_name, -- 3

Line 1098: INTO pon_interface_errors

1094: l_exp_date, l_userid, SYSDATE, -- 7
1095: l_userid, SYSDATE, l_loginid -- 8
1096: )
1097: WHEN payment_display_number IS NULL THEN
1098: INTO pon_interface_errors
1099: (
1100: column_name, entity_attr_name, error_message_name, -- 1
1101: error_value_datatype, error_value, error_value_date, -- 2
1102: token1_name, token1_value, token2_name, -- 3

Line 1121: INTO pon_interface_errors

1117: l_exp_date, l_userid, SYSDATE, -- 7
1118: l_userid, SYSDATE, l_loginid -- 8
1119: )
1120: WHEN payment_type IS NULL THEN
1121: INTO pon_interface_errors
1122: (
1123: column_name, entity_attr_name, error_message_name, -- 1
1124: error_value_datatype, error_value, error_value_date, -- 2
1125: token1_name, token1_value, token2_name, -- 3

Line 1144: INTO pon_interface_errors

1140: l_exp_date, l_userid, SYSDATE, -- 7
1141: l_userid, SYSDATE, l_loginid -- 8
1142: )
1143: WHEN payment_description IS NULL THEN
1144: INTO pon_interface_errors
1145: (
1146: column_name, entity_attr_name, error_message_name, -- 1
1147: error_value_datatype, error_value, error_value_date, -- 2
1148: token1_name, token1_value, token2_name, -- 3

Line 1167: INTO pon_interface_errors

1163: l_exp_date, l_userid, SYSDATE, -- 7
1164: l_userid, SYSDATE, l_loginid -- 8
1165: )
1166: WHEN lookup_payment_type_code = 'RATE' AND quantity IS NULL THEN
1167: INTO pon_interface_errors
1168: (
1169: column_name, entity_attr_name, error_message_name, -- 1
1170: error_value_datatype, error_value, error_value_date, -- 2
1171: token1_name, token1_value, token2_name, -- 3

Line 1190: INTO pon_interface_errors

1186: l_exp_date, l_userid, SYSDATE, -- 7
1187: l_userid, SYSDATE, l_loginid -- 8
1188: )
1189: WHEN need_by_date IS NOT NULL AND need_by_date < pah_close_bidding_date THEN
1190: INTO pon_interface_errors
1191: (
1192: column_name, entity_attr_name, error_message_name, -- 1
1193: error_value_datatype, error_value_number, error_value_date, -- 2
1194: token1_name, token1_value, token2_name, -- 3