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_AUC_PAYMENTS_INTERFACE

Line 637: PON_AUC_PAYMENTS_INTERFACE papi

633: papi.auction_header_id, papi.payment_display_number
634: FROM PA_PROJECTS_ALL pro,
635: PA_TASKS_EXPEND_V task,
636: HR_ALL_ORGANIZATION_UNITS porg,
637: PON_AUC_PAYMENTS_INTERFACE papi
638: WHERE papi.project_number = pro.segment1
639: AND papi.project_task_number = task.task_number
640: AND pro.project_id = task.project_id
641: AND papi.project_exp_organization_name = porg.name

Line 678: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

674: (
675: fnd_message.get_string('PON','PON_AUCTS_PROJECT'), NULL, 'PON_PROJ_NUM_INVALID', -- 1
676: 'TXT', Project_number, NULL, -- 2
677: 'LINENUM', document_disp_line_number, NULL, -- 3
678: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
679: p_batch_id, interface_line_id, NULL, -- 5
680: auction_header_id, auction_line_number, NULL, -- 6
681: l_exp_date, l_userid, SYSDATE, -- 7
682: l_userid, SYSDATE, l_loginid -- 8

Line 707: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

703: (
704: fnd_message.get_string('PON','PON_AUCTS_TASK'), NULL, 'PON_PROJ_TASK_INVALID', -- 1
705: 'TXT', project_task_number, NULL, -- 2
706: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
707: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
708: p_batch_id, interface_line_id, NULL, -- 5
709: auction_header_id, auction_line_number, NULL, -- 6
710: l_exp_date, l_userid, SYSDATE, -- 7
711: l_userid, SYSDATE, l_loginid -- 8

Line 740: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

736: (
737: fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), NULL, 'PON_PROJ_AWARD_INVALID', -- 1
738: 'TXT', project_award_number, NULL, -- 2
739: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
740: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
741: p_batch_id, interface_line_id, NULL, -- 5
742: auction_header_id, auction_line_number, NULL, -- 6
743: l_exp_date, l_userid, SYSDATE, -- 7
744: l_userid, SYSDATE, l_loginid -- 8

Line 764: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

760: (
761: fnd_message.get_string('PON','PON_AUCTS_PROJECT_AWARD'), NULL, 'PON_PROJ_AWARD_NULL', -- 1
762: 'TXT', project_award_number, NULL, -- 2
763: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
764: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
765: p_batch_id, interface_line_id, NULL, -- 5
766: auction_header_id, auction_line_number, NULL, -- 6
767: l_exp_date, l_userid, SYSDATE, -- 7
768: l_userid, SYSDATE, l_loginid -- 8

Line 788: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

784: (
785: fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_ORG'), NULL, 'PON_PROJ_EXPORG_INVALID', -- 1
786: 'TXT', project_exp_organization_name,NULL, -- 2
787: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
788: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
789: p_batch_id, interface_line_id, NULL, -- 5
790: auction_header_id, auction_line_number, NULL, -- 6
791: l_exp_date, l_userid, SYSDATE, -- 7
792: l_userid, SYSDATE, l_loginid -- 8

Line 820: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

816: (
817: fnd_message.get_string('PON','PON_AUCTS_EXPENDITUE_TYPE'), NULL, 'PON_PROJ_EXPTYPE_INVALID', -- 1
818: 'TXT', project_expenditure_type,NULL, -- 2
819: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
820: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
821: p_batch_id, interface_line_id, NULL, -- 5
822: auction_header_id, auction_line_number, NULL, -- 6
823: l_exp_date, l_userid, SYSDATE, -- 7
824: l_userid, SYSDATE, l_loginid -- 8

Line 847: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

843: (
844: fnd_message.get_string('PON','PON_AUCTS_PROJECT'), NULL, 'PON_PROJ_INFO_INCOMPLETE_P', -- 1
845: 'TXT', NULL, NULL, -- 2
846: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
847: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
848: p_batch_id, interface_line_id, NULL, -- 5
849: auction_header_id, auction_line_number, NULL, -- 6
850: l_exp_date, l_userid, SYSDATE, -- 7
851: l_userid, SYSDATE, l_loginid -- 8

Line 870: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

866: (
867: fnd_message.get_string('PON','PON_AUCTS_SHIPTO'), NULL, 'PONPYMT_SHIPTO_INVALID', -- 1
868: 'TXT', ship_to_location_code, NULL, -- 2
869: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
870: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
871: p_batch_id, interface_line_id, NULL, -- 5
872: auction_header_id, auction_line_number, NULL, -- 6
873: l_exp_date, l_userid, SYSDATE, -- 7
874: l_userid, SYSDATE, l_loginid -- 8

Line 893: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

889: (
890: fnd_message.get_string('PON','PON_AUCTS_UOM'), NULL, 'PON_UOM_INVALID', -- 1
891: 'TXT', unit_of_measure, NULL, -- 2
892: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
893: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
894: p_batch_id, interface_line_id, NULL, -- 5
895: auction_header_id, auction_line_number, NULL, -- 6
896: l_exp_date, l_userid, SYSDATE, -- 7
897: l_userid, SYSDATE, l_loginid -- 8

Line 923: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

919: (
920: fnd_message.get_string('PON','PON_AUCTS_OWNER'), NULL, 'PON_PYMT_OWNER_INVALID', -- 1
921: 'TXT', work_approver_user_name, NULL, -- 2
922: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
923: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
924: p_batch_id, interface_line_id, NULL, -- 5
925: auction_header_id, auction_line_number, NULL, -- 6
926: l_exp_date, l_userid, SYSDATE, -- 7
927: l_userid, SYSDATE, l_loginid -- 8

Line 953: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

949: (
950: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_TYPE'), NULL, 'PON_PYMT_TYPE_INVALID', -- 1
951: 'TXT', payment_type, NULL, -- 2
952: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
953: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
954: p_batch_id, interface_line_id, NULL, -- 5
955: auction_header_id, auction_line_number, NULL, -- 6
956: l_exp_date, l_userid, SYSDATE, -- 7
957: l_userid, SYSDATE, l_loginid -- 8

Line 976: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

972: (
973: fnd_message.get_string('PON','PON_AUCTS_LINENUMBER'), NULL, 'PON_INVALID_LINE_NUM', -- 1
974: 'TXT', document_disp_line_number, NULL, -- 2
975: null, null, NULL, -- 3
976: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
977: p_batch_id, interface_line_id, NULL, -- 5
978: auction_header_id, auction_line_number, NULL, -- 6
979: l_exp_date, l_userid, SYSDATE, -- 7
980: l_userid, SYSDATE, l_loginid -- 8

Line 999: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

995: (
996: fnd_message.get_string('PON','PON_AUCTS_LINENUMBER'), NULL, 'PON_PYMT_NOTALLOWED', -- 1
997: 'TXT', document_disp_line_number, NULL, -- 2
998: 'LINENUM', document_disp_line_number, NULL, -- 3
999: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1000: p_batch_id, interface_line_id, NULL, -- 5
1001: auction_header_id, auction_line_number, NULL, -- 6
1002: l_exp_date, l_userid, SYSDATE, -- 7
1003: l_userid, SYSDATE, l_loginid -- 8

Line 1022: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1018: (
1019: fnd_message.get_string('PON','PON_AUCTS_UOM'), NULL, 'PON_PYMT_UOM_NULL', -- 1
1020: 'TXT', NULL, NULL, -- 2
1021: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1022: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1023: p_batch_id, interface_line_id, NULL, -- 5
1024: auction_header_id, auction_line_number, NULL, -- 6
1025: l_exp_date, l_userid, SYSDATE, -- 7
1026: l_userid, SYSDATE, l_loginid -- 8

Line 1045: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1041: (
1042: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'), NULL, 'PON_PYMT_NUM_WRONG', -- 1
1043: 'TXT', payment_display_number, NULL, -- 2
1044: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1045: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1046: p_batch_id, interface_line_id, NULL, -- 5
1047: auction_header_id, auction_line_number, NULL, -- 6
1048: l_exp_date, l_userid, SYSDATE, -- 7
1049: l_userid, SYSDATE, l_loginid -- 8

Line 1068: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1064: (
1065: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'), NULL, 'PON_PYMT_QTY_WRONG', -- 1
1066: 'NUM', quantity, NULL, -- 2
1067: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1068: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1069: p_batch_id, interface_line_id, NULL, -- 5
1070: auction_header_id, auction_line_number, NULL, -- 6
1071: l_exp_date, l_userid, SYSDATE, -- 7
1072: l_userid, SYSDATE, l_loginid -- 8

Line 1091: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1087: (
1088: fnd_message.get_string('PON','PON_AUCTS_TARGET_PRICE'), NULL, 'PON_PYMT_TPRICE_WRONG', -- 1
1089: 'NUM', target_price, NULL, -- 2
1090: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1091: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1092: p_batch_id, interface_line_id, NULL, -- 5
1093: auction_header_id, auction_line_number, NULL, -- 6
1094: l_exp_date, l_userid, SYSDATE, -- 7
1095: l_userid, SYSDATE, l_loginid -- 8

Line 1114: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1110: (
1111: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'), NULL, 'PON_PYMT_NUM_MISSING', -- 1
1112: 'TXT', payment_display_number, NULL, -- 2
1113: 'LINENUM', document_disp_line_number, null, -- 3
1114: NULL, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1115: p_batch_id, interface_line_id, NULL, -- 5
1116: auction_header_id, auction_line_number, NULL, -- 6
1117: l_exp_date, l_userid, SYSDATE, -- 7
1118: l_userid, SYSDATE, l_loginid -- 8

Line 1137: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1133: (
1134: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_TYPE'), NULL, 'PON_PYMT_TYPE_NULL', -- 1
1135: 'TXT', payment_type, NULL, -- 2
1136: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1137: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1138: p_batch_id, interface_line_id, NULL, -- 5
1139: auction_header_id, auction_line_number, NULL, -- 6
1140: l_exp_date, l_userid, SYSDATE, -- 7
1141: l_userid, SYSDATE, l_loginid -- 8

Line 1160: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1156: (
1157: fnd_message.get_string('PON','PON_AUCTS_PAYMENT_DESC'), NULL, 'PON_PYMT_DESC_NULL', -- 1
1158: 'TXT', payment_description, NULL, -- 2
1159: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1160: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1161: p_batch_id, interface_line_id, NULL, -- 5
1162: auction_header_id, auction_line_number, NULL, -- 6
1163: l_exp_date, l_userid, SYSDATE, -- 7
1164: l_userid, SYSDATE, l_loginid -- 8

Line 1183: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1179: (
1180: fnd_message.get_string('PON','PON_AUCTS_QUANTITY'), NULL, 'PON_PYMT_QTY_NULL', -- 1
1181: 'TXT', NULL, NULL, -- 2
1182: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1183: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1184: p_batch_id, interface_line_id, NULL, -- 5
1185: auction_header_id, auction_line_number, NULL, -- 6
1186: l_exp_date, l_userid, SYSDATE, -- 7
1187: l_userid, SYSDATE, l_loginid -- 8

Line 1206: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4

1202: (
1203: fnd_message.get_string('PON','PON_AUCTS_NEEDBY'), NULL, 'PON_PYMT_NDATE_LESS_CDATE', -- 1
1204: 'TIM', NULL, need_by_date, -- 2
1205: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
1206: payment_display_number, l_interface_type, 'PON_AUC_PAYMENTS_INTERFACE', -- 4
1207: p_batch_id, interface_line_id, NULL, -- 5
1208: auction_header_id, auction_line_number, NULL, -- 6
1209: l_exp_date, l_userid, SYSDATE, -- 7
1210: l_userid, SYSDATE, l_loginid -- 8

Line 1242: FROM PON_AUC_PAYMENTS_INTERFACE ppi,

1238: pro.project_id pro_project_id,
1239: porg.organization_id porg_proj_exp_organization_id,
1240: ship.location_id ship_to_location_id,
1241: fl.lookup_code lookup_payment_type_code
1242: FROM PON_AUC_PAYMENTS_INTERFACE ppi,
1243: PON_AUCTION_ITEM_PRICES_ALL pai,
1244: PON_AUCTION_HEADERS_ALL pah,
1245: PO_SHIP_TO_LOC_ORG_V ship,
1246: FINANCIALS_SYSTEM_PARAMS_ALL fsp,

Line 1298: p_table_name => 'PON_AUC_PAYMENTS_INTERFACE',

1294: p_payment_id => null,
1295: p_interface_line_id => l_proj_record.interface_line_id,
1296: p_payment_display_number => l_proj_record.payment_display_number,
1297: p_batch_id => p_batch_id,
1298: p_table_name => 'PON_AUC_PAYMENTS_INTERFACE',
1299: p_interface_type => l_interface_type,
1300: p_entity_type => null,
1301: p_called_from => 'PAYMENTS_SP');
1302: END IF;