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_INTERFACE_ERRORS

Line 400: INTO PON_INTERFACE_ERRORS

396: WHEN ( sel_effective_start_date IS NOT NULL
397: AND sel_effective_end_date IS NOT NULL
398: AND sel_effective_end_date < sel_effective_start_date
399: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
400: INTO PON_INTERFACE_ERRORS
401: (
402: COLUMN_NAME ,
403: INTERFACE_TYPE ,
404: ERROR_MESSAGE_NAME,

Line 444: INTO PON_INTERFACE_ERRORS

440: l_login_id -- LAST_UPDATE_LOGIN
441: )
442: -- Validate the Line Number
443: WHEN ( sel_line_number IS NULL) THEN
444: INTO PON_INTERFACE_ERRORS
445: (
446: COLUMN_NAME ,
447: INTERFACE_TYPE ,
448: ERROR_MESSAGE_NAME,

Line 490: INTO PON_INTERFACE_ERRORS

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: (
492: COLUMN_NAME ,
493: INTERFACE_TYPE ,
494: ERROR_MESSAGE_NAME,

Line 536: INTO PON_INTERFACE_ERRORS

532: -- Validate Response Type for price breaks
533: WHEN Nvl(sel_price_break_type,'NONE') = 'NONE'
534: AND nvl(sel_clm_info_flag,'N') = 'N'
535: THEN
536: INTO PON_INTERFACE_ERRORS
537: (
538: COLUMN_NAME ,
539: INTERFACE_TYPE ,
540: ERROR_MESSAGE_NAME,

Line 595: INTO PON_INTERFACE_ERRORS

591: AND NVL(L.SHIP_TO_SITE_FLAG,'N') = 'Y'
592: AND L.LOCATION_ID = sel_ship_to_location_id
593: AND NVL (L.INVENTORY_ORGANIZATION_ID, sel_ship_to_organization_id) = sel_ship_to_organization_id
594: ) ) THEN
595: INTO PON_INTERFACE_ERRORS
596: (
597: COLUMN_NAME ,
598: INTERFACE_TYPE ,
599: ERROR_MESSAGE_NAME,

Line 643: INTO PON_INTERFACE_ERRORS

639: WHEN ( sel_ship_to_organization_id IS NULL
640: AND sel_ship_to_location_id IS NULL
641: AND sel_quantity IS NULL
642: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
643: INTO PON_INTERFACE_ERRORS
644: (
645: INTERFACE_TYPE ,
646: ERROR_MESSAGE_NAME,
647: REQUEST_ID ,

Line 688: INTO PON_INTERFACE_ERRORS

684: WHEN ( sel_quantity IS NOT NULL
685: AND sel_quantity < 0
686: AND sel_quantity <> g_null_int
687: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
688: INTO PON_INTERFACE_ERRORS
689: (
690: COLUMN_NAME ,
691: INTERFACE_TYPE ,
692: ERROR_MESSAGE_NAME,

Line 733: INTO PON_INTERFACE_ERRORS

729: )
730:
731: -- the price break price should be positive
732: WHEN ( sel_price < 0 AND nvl(sel_clm_info_flag,'N') = 'N') THEN
733: INTO PON_INTERFACE_ERRORS
734: (
735: COLUMN_NAME ,
736: INTERFACE_TYPE ,
737: ERROR_MESSAGE_NAME,

Line 780: INTO PON_INTERFACE_ERRORS

776: WHEN (
777: nvl(sel_clm_info_flag,'N') = 'N'
778: AND sel_effective_start_date IS NOT NULL
779: AND sel_effective_start_date <= NVL (sel_close_bidding_date, SYSDATE) ) THEN
780: INTO PON_INTERFACE_ERRORS
781: (
782: COLUMN_NAME ,
783: INTERFACE_TYPE ,
784: ERROR_MESSAGE_NAME,

Line 826: INTO PON_INTERFACE_ERRORS

822: -- EFFECTIVE END DATE AFTER SYSDATE OR CLOSE DATE
823: WHEN ( sel_effective_end_date IS NOT NULL
824: AND sel_effective_end_date <= NVL (sel_close_bidding_date, SYSDATE)
825: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
826: INTO PON_INTERFACE_ERRORS
827: (
828: COLUMN_NAME ,
829: INTERFACE_TYPE ,
830: ERROR_MESSAGE_NAME,

Line 872: INTO PON_INTERFACE_ERRORS

868: -- Price Breaks should not be entered for Fixed price line types
869: WHEN ( sel_price_tiers_indicator = 'PRICE_BREAKS'
870: AND sel_order_type_lookup_code in ('FIXED PRICE','AMOUNT')
871: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
872: INTO PON_INTERFACE_ERRORS
873: (
874: COLUMN_NAME ,
875: INTERFACE_TYPE ,
876: ERROR_MESSAGE_NAME,

Line 920: INTO PON_INTERFACE_ERRORS

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 ,
923: INTERFACE_TYPE ,
924: ERROR_MESSAGE_NAME,

Line 969: INTO PON_INTERFACE_ERRORS

965: WHEN ( sel_po_start_date IS NOT NULL
966: AND sel_effective_start_date IS NOT NULL
967: AND sel_effective_start_date < sel_po_start_date
968: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
969: INTO PON_INTERFACE_ERRORS
970: (
971: COLUMN_NAME ,
972: INTERFACE_TYPE ,
973: ERROR_MESSAGE_NAME,

Line 1016: INTO PON_INTERFACE_ERRORS

1012: WHEN ( sel_po_start_date IS NOT NULL
1013: AND sel_effective_end_date IS NOT NULL
1014: AND sel_effective_end_date < sel_po_start_date
1015: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1016: INTO PON_INTERFACE_ERRORS
1017: (
1018: COLUMN_NAME ,
1019: INTERFACE_TYPE ,
1020: ERROR_MESSAGE_NAME,

Line 1064: INTO PON_INTERFACE_ERRORS

1060: WHEN ( sel_po_end_date IS NOT NULL
1061: AND sel_effective_start_date IS NOT NULL
1062: AND sel_effective_start_date > sel_po_end_date
1063: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1064: INTO PON_INTERFACE_ERRORS
1065: (
1066: COLUMN_NAME ,
1067: INTERFACE_TYPE ,
1068: ERROR_MESSAGE_NAME,

Line 1111: INTO PON_INTERFACE_ERRORS

1107: WHEN ( sel_po_end_date IS NOT NULL
1108: AND sel_effective_end_date IS NOT NULL
1109: AND sel_effective_end_date > sel_po_end_date
1110: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1111: INTO PON_INTERFACE_ERRORS
1112: (
1113: COLUMN_NAME ,
1114: INTERFACE_TYPE ,
1115: ERROR_MESSAGE_NAME,

Line 1157: INTO PON_INTERFACE_ERRORS

1153: -- validating ship_to_organization
1154: WHEN ( sel_ship_to_organization IS NOT null
1155: and sel_ship_to_organization_id IS null
1156: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1157: INTO PON_INTERFACE_ERRORS
1158: (
1159: COLUMN_NAME ,
1160: INTERFACE_TYPE ,
1161: ERROR_MESSAGE_NAME,

Line 1208: INTO PON_INTERFACE_ERRORS

1204:
1205: WHEN ( sel_ship_to_location IS NOT null
1206: and sel_ship_to_location_id IS null
1207: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1208: INTO PON_INTERFACE_ERRORS
1209: (
1210: COLUMN_NAME ,
1211: INTERFACE_TYPE ,
1212: ERROR_MESSAGE_NAME,

Line 1329: INTO PON_INTERFACE_ERRORS

1325:
1326: INSERT ALL
1327: -- Validate the Line Number
1328: WHEN ( sel_line_number IS NULL) THEN
1329: INTO PON_INTERFACE_ERRORS
1330: (
1331: COLUMN_NAME ,
1332: INTERFACE_TYPE ,
1333: ERROR_MESSAGE_NAME,

Line 1376: INTO PON_INTERFACE_ERRORS

1372: WHEN ( sel_min_quantity IS NOT NULL
1373: AND sel_min_quantity < 0
1374: AND sel_min_quantity <> g_null_int
1375: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1376: INTO PON_INTERFACE_ERRORS
1377: (
1378: COLUMN_NAME ,
1379: INTERFACE_TYPE ,
1380: ERROR_MESSAGE_NAME,

Line 1423: INTO PON_INTERFACE_ERRORS

1419: WHEN ( sel_max_quantity IS NOT NULL
1420: AND sel_max_quantity < 0
1421: AND sel_max_quantity <> g_null_int
1422: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1423: INTO PON_INTERFACE_ERRORS
1424: (
1425: COLUMN_NAME ,
1426: INTERFACE_TYPE ,
1427: ERROR_MESSAGE_NAME,

Line 1471: INTO PON_INTERFACE_ERRORS

1467: WHEN ( sel_max_quantity IS NOT NULL
1468: AND sel_min_quantity IS NOT NULL
1469: AND sel_max_quantity < sel_min_quantity
1470: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1471: INTO PON_INTERFACE_ERRORS
1472: (
1473: COLUMN_NAME ,
1474: INTERFACE_TYPE ,
1475: ERROR_MESSAGE_NAME,

Line 1517: INTO PON_INTERFACE_ERRORS

1513:
1514: -- price should be positive
1515: WHEN ( sel_price < 0
1516: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1517: INTO PON_INTERFACE_ERRORS
1518: (
1519: COLUMN_NAME ,
1520: INTERFACE_TYPE ,
1521: ERROR_MESSAGE_NAME,

Line 1565: INTO PON_INTERFACE_ERRORS

1561: WHEN (
1562: NOT ((sel_PURCHASE_BASIS = 'TEMP LABOR' and sel_order_type_lookup_code = 'RATE') OR
1563: sel_PURCHASE_BASIS = 'GOODS')
1564: AND nvl(sel_clm_info_flag,'N') = 'N') THEN
1565: INTO PON_INTERFACE_ERRORS
1566: (
1567: COLUMN_NAME ,
1568: INTERFACE_TYPE ,
1569: ERROR_MESSAGE_NAME,

Line 1642: INSERT INTO PON_INTERFACE_ERRORS

1638: -- The ranges of min-max quantities should not overlap across tiers for a given line in a negotiation
1639: -- When this validation is performed at shipments level multiple error message were thrown for one particular line
1640: -- To avoid the multiple error messages this validation has to be performed at line level rather than shipments level.
1641:
1642: INSERT INTO PON_INTERFACE_ERRORS
1643: (
1644: COLUMN_NAME,INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
1645: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1646: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN