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_SHIPMENTS_INT dependencies on PON_AUCTION_PKG

Line 423: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),

419: LAST_UPDATE_LOGIN
420: )
421: VALUES
422: (
423: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),
424: l_interface_type , --INTERFACE_TYPE
425: 'PON_AUCTS_EFFC_END_BEF_START', -- ERROR_MESSAGE_NAME
426: p_request_id , -- REQUEST_ID
427: p_batch_id , --BATCH_ID

Line 467: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),

463: LAST_UPDATE_LOGIN
464: )
465: VALUES
466: (
467: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),
468: l_interface_type , --INTERFACE_TYPE
469: 'PON_INVALID_LINE_NUM', -- ERROR_MESSAGE_NAME
470: p_request_id , -- REQUEST_ID
471: p_batch_id , --BATCH_ID

Line 487: /* WHEN ( Nvl(sel_agreement_rel_qty,'NONE') NOT IN (pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE'),pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE'))

483: sysdate , -- LAST_UPDATE_DATE
484: l_login_id -- LAST_UPDATE_LOGIN
485: )
486: -- Validate Agreement Release Quantity for price breaks
487: /* WHEN ( Nvl(sel_agreement_rel_qty,'NONE') NOT IN (pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE'),pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE'))
488: AND nvl(sel_clm_info_flag,'N') = 'N')
489: THEN
490: INTO PON_INTERFACE_ERRORS
491: (

Line 513: pon_auction_pkg.getMessage('PON_AGREEMENT_RELEASE_QUANTITY'),

509: LAST_UPDATE_LOGIN
510: )
511: VALUES
512: (
513: pon_auction_pkg.getMessage('PON_AGREEMENT_RELEASE_QUANTITY'),
514: l_interface_type , --INTERFACE_TYPE
515: 'PON_INVALID_AGR_REL_QTY', -- ERROR_MESSAGE_NAME
516: p_request_id , -- REQUEST_ID
517: p_batch_id , --BATCH_ID

Line 559: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),

555: LAST_UPDATE_LOGIN
556: )
557: VALUES
558: (
559: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),
560: l_interface_type , --INTERFACE_TYPE
561: 'PON_AUC_BAD_PBTYPE_SHIPS', -- ERROR_MESSAGE_NAME
562: p_request_id , -- REQUEST_ID
563: p_batch_id , --BATCH_ID

Line 618: pon_auction_pkg.getMessage('PON_SHIP_TO_LOCATION'),

614: LAST_UPDATE_LOGIN
615: )
616: VALUES
617: (
618: pon_auction_pkg.getMessage('PON_SHIP_TO_LOCATION'),
619: l_interface_type , --INTERFACE_TYPE
620: 'PON_AUC_SHIP_TO_MATCHING_ERR', -- ERROR_MESSAGE_NAME
621: p_request_id , -- REQUEST_ID
622: p_batch_id , --BATCH_ID

Line 711: pon_auction_pkg.getMessage('PON_AUCTS_QUANTITY'),

707: LAST_UPDATE_LOGIN
708: )
709: VALUES
710: (
711: pon_auction_pkg.getMessage('PON_AUCTS_QUANTITY'),
712: l_interface_type , --INTERFACE_TYPE
713: 'PON_AUCTS_PB_QUANTITY_POSITIVE', -- ERROR_MESSAGE_NAME
714: p_request_id , -- REQUEST_ID
715: p_batch_id , --BATCH_ID

Line 756: pon_auction_pkg.getMessage('PON_AUCTS_TARGET_PRICE'),

752: LAST_UPDATE_LOGIN
753: )
754: VALUES
755: (
756: pon_auction_pkg.getMessage('PON_AUCTS_TARGET_PRICE'),
757: l_interface_type , --INTERFACE_TYPE
758: 'PON_AUCTS_PB_RPICE_POSITIVE', -- ERROR_MESSAGE_NAME
759: p_request_id , -- REQUEST_ID
760: p_batch_id , --BATCH_ID

Line 803: pon_auction_pkg.getMessage('PON_AUC_EFFEC_FROM'),

799: LAST_UPDATE_LOGIN
800: )
801: VALUES
802: (
803: pon_auction_pkg.getMessage('PON_AUC_EFFEC_FROM'),
804: l_interface_type , --INTERFACE_TYPE
805: NVL2 (sel_close_bidding_date, 'PON_AUC_EFFC_FROM_BEF_CLOSE', 'PON_AUC_EFFC_FROM_BEF_TODAY'), -- ERROR_MESSAGE_NAME
806: p_request_id , -- REQUEST_ID
807: p_batch_id , -- BATCH_ID

Line 849: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),

845: LAST_UPDATE_LOGIN
846: )
847: VALUES
848: (
849: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),
850: l_interface_type , --INTERFACE_TYPE
851: NVL2 (sel_close_bidding_date, 'PON_AUC_EFFC_TO_BEFORE_CLOSE', 'PON_AUC_EFFC_TO_BEFORE_TODAY'), -- ERROR_MESSAGE_NAME
852: p_request_id , -- REQUEST_ID
853: p_batch_id , --BATCH_ID

Line 895: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),

891: LAST_UPDATE_LOGIN
892: )
893: VALUES
894: (
895: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),
896: l_interface_type , --INTERFACE_TYPE
897: 'PON_AUCTS_PB_FP_LINE_ERR', -- ERROR_MESSAGE_NAME
898: p_request_id , -- REQUEST_ID
899: p_batch_id , --BATCH_ID

Line 918: sel_response_type = pon_auction_pkg.getMessage('PON_AUC_CUMULATIVE')

914:
915:
916: /* -- Temp based labor cannot have cumilative response
917: WHEN ((sel_PURCHASE_BASIS = 'TEMP LABOR' and sel_order_type_lookup_code = 'RATE') and
918: sel_response_type = pon_auction_pkg.getMessage('PON_AUC_CUMULATIVE')
919: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
920: INTO PON_INTERFACE_ERRORS
921: (
922: COLUMN_NAME ,

Line 943: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),

939: LAST_UPDATE_LOGIN
940: )
941: VALUES
942: (
943: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),
944: l_interface_type , --INTERFACE_TYPE
945: 'PON_AUCTS_PB_TBL_LINE_ERR', -- ERROR_MESSAGE_NAME
946: p_request_id , -- REQUEST_ID
947: p_batch_id , --BATCH_ID

Line 992: pon_auction_pkg.getMessage('PON_AUC_EFFEC_FROM'),

988: LAST_UPDATE_LOGIN
989: )
990: VALUES
991: (
992: pon_auction_pkg.getMessage('PON_AUC_EFFEC_FROM'),
993: l_interface_type , --INTERFACE_TYPE
994: 'PON_AUC_EFFC_FROM_BEF_NEG' , -- ERROR_MESSAGE_NAME
995: p_request_id , -- REQUEST_ID
996: p_batch_id , -- BATCH_ID

Line 1040: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),

1036: )
1037: VALUES
1038: (
1039:
1040: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),
1041: l_interface_type , --INTERFACE_TYPE
1042: 'PON_AUC_EFFC_TO_BEFORE_NEG' , -- ERROR_MESSAGE_NAME
1043: p_request_id , -- REQUEST_ID
1044: p_batch_id , -- BATCH_ID

Line 1087: pon_auction_pkg.getMessage('PON_AUC_EFFEC_FROM'),

1083: LAST_UPDATE_LOGIN
1084: )
1085: VALUES
1086: (
1087: pon_auction_pkg.getMessage('PON_AUC_EFFEC_FROM'),
1088: l_interface_type , --INTERFACE_TYPE
1089: 'PON_AUC_EFFC_FROM_AFT_NEG' , -- ERROR_MESSAGE_NAME
1090: p_request_id , -- REQUEST_ID
1091: p_batch_id , -- BATCH_ID

Line 1134: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),

1130: LAST_UPDATE_LOGIN
1131: )
1132: VALUES
1133: (
1134: pon_auction_pkg.getMessage('PON_AUC_EFFEC_TO'),
1135: l_interface_type , --INTERFACE_TYPE
1136: 'PON_AUC_EFFC_TO_AFT_NEG' , -- ERROR_MESSAGE_NAME
1137: p_request_id , -- REQUEST_ID
1138: p_batch_id , -- BATCH_ID

Line 1182: pon_auction_pkg.getMessage('PON_SHIP_TO_ORGANIZATION'),

1178: LAST_UPDATE_LOGIN
1179: )
1180: VALUES
1181: (
1182: pon_auction_pkg.getMessage('PON_SHIP_TO_ORGANIZATION'),
1183: l_interface_type , --INTERFACE_TYPE
1184: 'PON_AUC_DATA_INVALID_SHIPO_REF' , -- ERROR_MESSAGE_NAME
1185: p_request_id , -- REQUEST_ID
1186: p_batch_id , -- BATCH_ID

Line 1233: pon_auction_pkg.getMessage('PON_SHIP_TO_LOCATION'),

1229: LAST_UPDATE_LOGIN
1230: )
1231: VALUES
1232: (
1233: pon_auction_pkg.getMessage('PON_SHIP_TO_LOCATION'),
1234: l_interface_type , --INTERFACE_TYPE
1235: 'PON_AUC_DATA_INVALID_SHIPL_REF' , -- ERROR_MESSAGE_NAME
1236: p_request_id , -- REQUEST_ID
1237: p_batch_id , -- BATCH_ID

Line 1352: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),

1348: LAST_UPDATE_LOGIN
1349: )
1350: VALUES
1351: (
1352: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),
1353: l_interface_type , --INTERFACE_TYPE
1354: 'PON_INVALID_LINE_NUM', -- ERROR_MESSAGE_NAME
1355: p_request_id , -- REQUEST_ID
1356: p_batch_id , --BATCH_ID

Line 1399: pon_auction_pkg.getMessage('PON_TIERS_MIN_QUANTITY'),

1395: LAST_UPDATE_LOGIN
1396: )
1397: VALUES
1398: (
1399: pon_auction_pkg.getMessage('PON_TIERS_MIN_QUANTITY'),
1400: l_interface_type , --INTERFACE_TYPE
1401: 'PON_AUCTS_PB_QUANTITY_POSITIVE', -- ERROR_MESSAGE_NAME
1402: p_request_id , -- REQUEST_ID
1403: p_batch_id , --BATCH_ID

Line 1446: pon_auction_pkg.getMessage('PON_TIERS_MAX_QUANTITY'),

1442: LAST_UPDATE_LOGIN
1443: )
1444: VALUES
1445: (
1446: pon_auction_pkg.getMessage('PON_TIERS_MAX_QUANTITY'),
1447: l_interface_type , --INTERFACE_TYPE
1448: 'PON_AUCTS_PB_QUANTITY_POSITIVE', -- ERROR_MESSAGE_NAME
1449: p_request_id , -- REQUEST_ID
1450: p_batch_id , --BATCH_ID

Line 1494: pon_auction_pkg.getMessage('PON_TIERS_MIN_QUANTITY'),

1490: LAST_UPDATE_LOGIN
1491: )
1492: VALUES
1493: (
1494: pon_auction_pkg.getMessage('PON_TIERS_MIN_QUANTITY'),
1495: l_interface_type , --INTERFACE_TYPE
1496: 'PON_QT_MAX_MIN_QTY_ERR', -- ERROR_MESSAGE_NAME
1497: p_request_id , -- REQUEST_ID
1498: p_batch_id , --BATCH_ID

Line 1540: pon_auction_pkg.getMessage('PON_AUCTS_TARGET_PRICE'),

1536: LAST_UPDATE_LOGIN
1537: )
1538: VALUES
1539: (
1540: pon_auction_pkg.getMessage('PON_AUCTS_TARGET_PRICE'),
1541: l_interface_type , --INTERFACE_TYPE
1542: 'PON_AUCTS_PB_RPICE_POSITIVE', -- ERROR_MESSAGE_NAME
1543: p_request_id , -- REQUEST_ID
1544: p_batch_id , --BATCH_ID

Line 1588: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),

1584: LAST_UPDATE_LOGIN
1585: )
1586: VALUES
1587: (
1588: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),
1589: l_interface_type , --INTERFACE_TYPE
1590: 'PON_AUCTS_QB_LINE_TYP_ERR', -- ERROR_MESSAGE_NAME
1591: p_request_id , -- REQUEST_ID
1592: p_batch_id , --BATCH_ID

Line 1650: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),

1646: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1647: )
1648: SELECT
1649: distinct
1650: pon_auction_pkg.getMessage('PON_AUCTS_LINENUMBER'),
1651: l_interface_type, --INTERFACE_TYPE
1652: 'PON_AUC_OVERLAP_RANGES_QT', -- ERROR_MESSAGE_NAME
1653: p_request_id, -- REQUEST_ID
1654: p_batch_id, --BATCH_ID