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_NEGOTIATION_PUBLISH_PVT dependencies on PON_INTERFACE_ERRORS

Line 187: INSERT INTO pon_interface_errors

183: X_MSG_COUNT => l_msg_count,
184: X_BILLABLE_FLAG => l_billable_flag);
185:
186: IF l_msg_data IS NOT NULL AND l_msg_type = 'E' THEN
187: INSERT INTO pon_interface_errors
188: (
189: error_message_name,
190: token1_name,
191: token1_value,

Line 281: INSERT INTO PON_INTERFACE_ERRORS

277: WHERE AUCTION_HEADER_ID=p_auction_header_id
278: AND ASSOCIATED_TO_LINE IS null;
279:
280: IF(l_exhibits_links>0) then
281: INSERT INTO PON_INTERFACE_ERRORS
282: (
283: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
284: AUCTION_HEADER_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
285: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 331: INSERT INTO PON_INTERFACE_ERRORS

327: AND Nvl(is_cdrl,'N') = 'N') -- This validation is not required for cdrl exhibits.
328: WHERE IS_EXHIBIT_PRICED = IS_LINE_PRICED;
329:
330: IF(l_exhibits_links>0) then
331: INSERT INTO PON_INTERFACE_ERRORS
332: (
333: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
334: AUCTION_HEADER_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
335: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 458: THEN INTO PON_INTERFACE_ERRORS

454: (sel_group_type IN ('GROUP_LINE', 'LOT_LINE') AND sel_parent_line_number IS NULL) OR
455: (sel_group_type IN ('GROUP', 'LOT') AND sel_parent_line_number IS NOT NULL)
456: )
457:
458: THEN INTO PON_INTERFACE_ERRORS
459: (
460: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
461: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
462: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 491: THEN INTO PON_INTERFACE_ERRORS

487: g_document_type_validity_rule ('ITEM_DESCRIPTION') = 'Y' AND
488: (sel_item_description IS NULL OR trim (sel_item_description) = '')
489: )
490:
491: THEN INTO PON_INTERFACE_ERRORS
492: (
493: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
494: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
495: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 526: THEN INTO PON_INTERFACE_ERRORS

522: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
523: sel_line_type_id IS NULL
524: )
525:
526: THEN INTO PON_INTERFACE_ERRORS
527: (
528: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
529: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
530: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 560: THEN INTO PON_INTERFACE_ERRORS

556: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
557: NVL (sel_group_type, g_invalid_string) <> 'GROUP'
558: )
559:
560: THEN INTO PON_INTERFACE_ERRORS
561: (
562: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
563: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
564: LAST_UPDATE_LOGIN

Line 613: THEN INTO PON_INTERFACE_ERRORS

609: AND MCK.CATEGORY_ID = MC.CATEGORY_ID
610: AND MCK.CATEGORY_ID = sel_category_id )
611: )
612:
613: THEN INTO PON_INTERFACE_ERRORS
614: (
615: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
616: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
617: LAST_UPDATE_LOGIN

Line 647: THEN INTO PON_INTERFACE_ERRORS

643: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
644: (sel_delivery_event_code IS NOT NULL AND
645: (sel_delivery_period IS NULL OR sel_delivery_period_uom IS NULL OR sel_delivery_period_uom = '') )
646: )
647: THEN INTO PON_INTERFACE_ERRORS
648: (
649: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
650: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
651: LAST_UPDATE_LOGIN

Line 681: THEN INTO PON_INTERFACE_ERRORS

677: sel_delivery_event_code IS NOT NULL AND
678: sel_delivery_period IS not NULL AND
679: sel_delivery_period <= 0
680: )
681: THEN INTO PON_INTERFACE_ERRORS
682: (
683: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
684: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
685: LAST_UPDATE_LOGIN

Line 715: THEN INTO PON_INTERFACE_ERRORS

711: sel_delivery_event_code IS NOT NULL AND
712: sel_pop_duration IS not NULL AND
713: sel_pop_duration <= 0
714: )
715: THEN INTO PON_INTERFACE_ERRORS
716: (
717: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
718: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
719: LAST_UPDATE_LOGIN

Line 749: THEN INTO PON_INTERFACE_ERRORS

745: sel_target_price IS NOT NULL AND
746: sel_target_price <= 0
747: )
748:
749: THEN INTO PON_INTERFACE_ERRORS
750: (
751: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
752: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
753: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 785: THEN INTO PON_INTERFACE_ERRORS

781: sel_bid_start_price IS NOT NULL AND
782: sel_bid_start_price <= 0
783: )
784:
785: THEN INTO PON_INTERFACE_ERRORS
786: (
787: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
788: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
789: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 821: THEN INTO PON_INTERFACE_ERRORS

817: sel_current_price IS NOT NULL AND
818: sel_current_price <= 0
819: )
820:
821: THEN INTO PON_INTERFACE_ERRORS
822: (
823: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
824: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
825: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 856: THEN INTO PON_INTERFACE_ERRORS

852: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
853: sel_target_price >= sel_bid_start_price
854: )
855:
856: THEN INTO PON_INTERFACE_ERRORS
857: (
858: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
859: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
860: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 891: THEN INTO PON_INTERFACE_ERRORS

887: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
888: sel_target_price IS NULL AND
889: sel_display_target_price_flag = 'Y'
890: )
891: THEN INTO PON_INTERFACE_ERRORS
892: (
893: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
894: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
895: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 927: THEN INTO PON_INTERFACE_ERRORS

923: sel_po_min_rel_amount <> g_null_int AND
924: sel_po_min_rel_amount < 0
925: )
926:
927: THEN INTO PON_INTERFACE_ERRORS
928: (
929: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
930: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
931: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 962: THEN INTO PON_INTERFACE_ERRORS

958: sel_unit_target_price IS NULL AND
959: sel_unit_display_target_flag = 'Y'
960: )
961:
962: THEN INTO PON_INTERFACE_ERRORS
963: (
964: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
965: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
966: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 997: THEN INTO PON_INTERFACE_ERRORS

993: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
994: sel_target_price IS NOT NULL AND
995: ABS (sel_target_price * l_temp - TRUNC (sel_target_price * l_temp)) > 0
996: )
997: THEN INTO PON_INTERFACE_ERRORS
998: (
999: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1000: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1001: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1031: THEN INTO PON_INTERFACE_ERRORS

1027: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1028: sel_bid_start_price IS NOT NULL AND
1029: ABS (sel_bid_start_price * l_temp - TRUNC (sel_bid_start_price * l_temp)) > 0
1030: )
1031: THEN INTO PON_INTERFACE_ERRORS
1032: (
1033: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1034: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1035: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1065: THEN INTO PON_INTERFACE_ERRORS

1061: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1062: sel_current_price IS NOT NULL AND
1063: ABS (sel_current_price * l_temp - TRUNC (sel_current_price * l_temp)) > 0
1064: )
1065: THEN INTO PON_INTERFACE_ERRORS
1066: (
1067: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1068: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1069: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1100: THEN INTO PON_INTERFACE_ERRORS

1096: sel_clm_unit_price IS NOT NULL AND
1097: (sel_clm_cost_constraint NOT IN ('NC','NSP')) AND
1098: sel_clm_unit_price <= 0
1099: )
1100: THEN INTO PON_INTERFACE_ERRORS
1101: (
1102: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1103: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1104: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1135: THEN INTO PON_INTERFACE_ERRORS

1131: sel_is_info_line <> 'Y' AND
1132: sel_clm_unit_price IS NOT NULL AND
1133: ABS (sel_clm_unit_price * l_temp - TRUNC (sel_clm_unit_price * l_temp)) > 0
1134: )
1135: THEN INTO PON_INTERFACE_ERRORS
1136: (
1137: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1138: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1139: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1172: THEN INTO PON_INTERFACE_ERRORS

1168: sel_po_min_rel_amount <> g_null_int AND
1169: ABS (sel_po_min_rel_amount * l_temp_fnd - TRUNC (sel_po_min_rel_amount * l_temp_fnd)) > 0
1170: )
1171:
1172: THEN INTO PON_INTERFACE_ERRORS
1173: (
1174: INTERFACE_TYPE,
1175: ERROR_MESSAGE_NAME,
1176: REQUEST_ID,

Line 1218: THEN INTO PON_INTERFACE_ERRORS

1214: g_is_fed <> 'Y' AND
1215: sel_need_by_date < sel_need_by_start_date
1216: )
1217:
1218: THEN INTO PON_INTERFACE_ERRORS
1219: (
1220: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1221: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1222: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1255: THEN INTO PON_INTERFACE_ERRORS

1251: sel_need_by_date IS NOT NULL AND
1252: sel_need_by_date < nvl (p_close_bidding_date, SYSDATE)
1253: )
1254:
1255: THEN INTO PON_INTERFACE_ERRORS
1256: (
1257: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1258: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1259: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1288: THEN INTO PON_INTERFACE_ERRORS

1284: (
1285: sel_clm_base_line_num IS NOT NULL AND
1286: Trunc(Nvl(sel_clm_option_from_date,SYSDATE - 1)) < trunc (SYSDATE)
1287: )
1288: THEN INTO PON_INTERFACE_ERRORS
1289: (
1290: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1291: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1292: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1321: THEN INTO PON_INTERFACE_ERRORS

1317: (
1318: sel_clm_base_line_num IS NOT NULL AND
1319: sel_clm_option_to_date < nvl (sel_clm_option_from_date, SYSDATE)
1320: )
1321: THEN INTO PON_INTERFACE_ERRORS
1322: (
1323: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1324: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1325: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1391: THEN INTO PON_INTERFACE_ERRORS

1387: INSERT ALL
1388: WHEN(sel_clm_base_line_num IS NOT NULL AND
1389: sel_clm_option_to_date < nvl (clm_sol_close_date, SYSDATE)
1390: )
1391: THEN INTO PON_INTERFACE_ERRORS
1392: (
1393: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1394: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1395: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1442: THEN INTO PON_INTERFACE_ERRORS

1438: clm_need_by_date IS NOT NULL AND
1439: p_contract_type = 'STANDARD'
1440: )
1441:
1442: THEN INTO PON_INTERFACE_ERRORS
1443: (
1444: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1445: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1446: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1477: THEN INTO PON_INTERFACE_ERRORS

1473: sel_need_by_date IS NULL AND
1474: p_contract_type = 'STANDARD'
1475: )
1476:
1477: THEN INTO PON_INTERFACE_ERRORS
1478: (
1479: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1480: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1481: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1512: THEN INTO PON_INTERFACE_ERRORS

1508: sel_need_by_date IS NOT NULL AND
1509: p_contract_type = 'STANDARD'
1510: )
1511:
1512: THEN INTO PON_INTERFACE_ERRORS
1513: (
1514: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1515: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1516: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1562: THEN INTO PON_INTERFACE_ERRORS

1558: (3, 4, 7, 8, 9))
1559: )
1560: )
1561:
1562: THEN INTO PON_INTERFACE_ERRORS
1563: (
1564: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1565: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1566: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1595: THEN INTO PON_INTERFACE_ERRORS

1591: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1592: sel_need_by_date <= sel_need_by_start_date
1593: )
1594:
1595: THEN INTO PON_INTERFACE_ERRORS
1596: (
1597: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1598: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1599: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1657: THEN INTO PON_INTERFACE_ERRORS

1653: sel_need_by_start_date < nvl (p_close_bidding_date, SYSDATE) AND
1654: p_contract_type = 'STANDARD'
1655: )
1656:
1657: THEN INTO PON_INTERFACE_ERRORS
1658: (
1659: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1660: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1661: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1696: THEN INTO PON_INTERFACE_ERRORS

1692: clm_need_by_date < nvl (p_close_bidding_date, SYSDATE) AND
1693: p_contract_type = 'STANDARD'
1694: )
1695:
1696: THEN INTO PON_INTERFACE_ERRORS
1697: (
1698: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1699: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1700: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1750: THEN INTO PON_INTERFACE_ERRORS

1746: (3, 4, 7, 8, 9))
1747: )
1748: )
1749:
1750: THEN INTO PON_INTERFACE_ERRORS
1751: (
1752: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1753: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1754: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1788: THEN INTO PON_INTERFACE_ERRORS

1784: l_price_tiers_indicator = 'PRICE_BREAKS' AND
1785: sel_clm_cost_constraint NOT IN ('NC','NSP') -- CLM QA Bug : 9835426
1786: )
1787:
1788: THEN INTO PON_INTERFACE_ERRORS
1789: (
1790: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1791: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1792: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1835: THEN INTO PON_INTERFACE_ERRORS

1831: PASA.LINE_NUMBER = sel_line_number
1832: )
1833: )
1834:
1835: THEN INTO PON_INTERFACE_ERRORS
1836: (
1837: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1838: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY, CREATION_DATE,
1839: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1878: THEN INTO PON_INTERFACE_ERRORS

1874: PPD.SHIPMENT_NUMBER = -1
1875: )
1876: )
1877:
1878: THEN INTO PON_INTERFACE_ERRORS
1879: (
1880: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1881: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE,TOKEN1_NAME, TOKEN1_VALUE,
1882: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1921: THEN INTO PON_INTERFACE_ERRORS

1917: PPD.SHIPMENT_NUMBER = -1
1918: )
1919: )
1920:
1921: THEN INTO PON_INTERFACE_ERRORS
1922: (
1923: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1924: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE,TOKEN1_NAME, TOKEN1_VALUE,
1925: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1960: THEN INTO PON_INTERFACE_ERRORS

1956: PARENT_LINE_NUMBER = sel_line_number
1957: )
1958: )
1959:
1960: THEN INTO PON_INTERFACE_ERRORS
1961: (
1962: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1963: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1964: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1995: THEN INTO PON_INTERFACE_ERRORS

1991: sel_unit_target_price IS NOT NULL AND
1992: sel_unit_target_price < 0
1993: )
1994:
1995: THEN INTO PON_INTERFACE_ERRORS
1996: (
1997: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1998: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1999: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2038: THEN INTO PON_INTERFACE_ERRORS

2034: PF_TYPE='SUPPLIER'
2035: )
2036: )
2037:
2038: THEN INTO PON_INTERFACE_ERRORS
2039: (
2040: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2041: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2042: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2088: THEN INTO PON_INTERFACE_ERRORS

2084: AUCTION_HEADER_ID = p_auction_header_id
2085: AND LINE_NUMBER = sel_line_number) <> 100
2086: )
2087:
2088: THEN INTO PON_INTERFACE_ERRORS
2089: (
2090: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2091: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2092: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2123: THEN INTO PON_INTERFACE_ERRORS

2119: sel_quantity IS NOT NULL AND
2120: sel_quantity <= 0
2121: )
2122:
2123: THEN INTO PON_INTERFACE_ERRORS
2124: (
2125: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2126: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2127: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2157: THEN INTO PON_INTERFACE_ERRORS

2153: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
2154: sel_po_agreed_amount IS NOT NULL AND
2155: ABS (sel_po_agreed_amount * l_temp - TRUNC (sel_po_agreed_amount * l_temp)) > 0
2156: )
2157: THEN INTO PON_INTERFACE_ERRORS
2158: (
2159: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2160: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2161: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2195: THEN INTO PON_INTERFACE_ERRORS

2191: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
2192: nvl (sel_line_origination_code,g_invalid_string) <> 'REQUISITION' AND
2193: sel_ship_to_location_id IS NULL
2194: )
2195: THEN INTO PON_INTERFACE_ERRORS
2196: (
2197: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2198: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2199: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2232: THEN INTO PON_INTERFACE_ERRORS

2228: AUCTION_HEADER_ID = p_auction_header_id AND
2229: sel_group_type IN ('LOT', 'GROUP', 'LINE') AND
2230: LINE_NUMBER = sel_line_number) = p_invitees_count
2231: )
2232: THEN INTO PON_INTERFACE_ERRORS
2233: (
2234: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2235: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2236: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2266: THEN INTO PON_INTERFACE_ERRORS

2262: WHERE auction_header_id = p_auction_header_id
2263: AND group_line_id = sel_line_number
2264: AND Nvl(clm_info_flag,'N') = 'N')
2265: )
2266: THEN INTO PON_INTERFACE_ERRORS
2267: (
2268: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2269: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2270: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2388: THEN INTO PON_INTERFACE_ERRORS

2384: (
2385: sel_uom_code IS NULL OR TRIM (sel_uom_code) = ''
2386: )
2387: )
2388: THEN INTO PON_INTERFACE_ERRORS
2389: (
2390: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2391: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2392: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2426: THEN INTO PON_INTERFACE_ERRORS

2422: ((nvl (sel_purchase_basis,g_invalid_string) <> g_temp_labor AND
2423: g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION) OR
2424: p_contract_type = 'STANDARD')
2425: )
2426: THEN INTO PON_INTERFACE_ERRORS
2427: (
2428: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2429: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2430: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2460: THEN INTO PON_INTERFACE_ERRORS

2456: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
2457: sel_job_id IS NULL AND
2458: sel_purchase_basis = g_temp_labor
2459: )
2460: THEN INTO PON_INTERFACE_ERRORS
2461: (
2462: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2463: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2464: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2495: THEN INTO PON_INTERFACE_ERRORS

2491: sel_po_agreed_amount IS NOT NULL AND
2492: sel_purchase_basis = g_temp_labor AND
2493: sel_po_agreed_amount <= 0
2494: )
2495: THEN INTO PON_INTERFACE_ERRORS
2496: (
2497: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2498: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2499: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2531: THEN INTO PON_INTERFACE_ERRORS

2527: g_document_type_names (p_doctype_id) <> PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION AND
2528: NVL (p_global_agreement_flag, g_invalid_string) <> 'Y'
2529: )
2530:
2531: THEN INTO PON_INTERFACE_ERRORS
2532: (
2533: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2534: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY, CREATION_DATE,
2535: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2565: THEN INTO PON_INTERFACE_ERRORS

2561: sel_order_type_lookup_code = g_fixed_price AND
2562: ABS (sel_unit_target_price * l_temp_fnd - TRUNC (sel_unit_target_price * l_temp_fnd)) > 0
2563: )
2564:
2565: THEN INTO PON_INTERFACE_ERRORS
2566: (
2567: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2568: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2569: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2603: THEN INTO PON_INTERFACE_ERRORS

2599: NVL (sel_order_type_lookup_code, g_invalid_string) <> g_fixed_price AND
2600: ABS (sel_unit_target_price * l_temp - TRUNC (sel_unit_target_price * l_temp)) > 0
2601: )
2602:
2603: THEN INTO PON_INTERFACE_ERRORS
2604: (
2605: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2606: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2607: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2649: THEN INTO PON_INTERFACE_ERRORS

2645: AUCTION_HEADER_ID = p_auction_header_id AND
2646: LINE_NUMBER = sel_line_number AND
2647: PRICING_BASIS = g_fixed_amount)
2648: )
2649: THEN INTO PON_INTERFACE_ERRORS
2650: (
2651: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
2652: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
2653: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

Line 2688: THEN INTO PON_INTERFACE_ERRORS

2684: NVL (sel_order_type_lookup_code, g_invalid_string) <> g_fixed_price AND
2685: NVL (sel_purchase_basis, g_invalid_string) <> g_temp_labor AND
2686: g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION
2687: )
2688: THEN INTO PON_INTERFACE_ERRORS
2689: (
2690: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
2691: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
2692: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

Line 2775: INSERT INTO PON_INTERFACE_ERRORS

2771: IF (l_allow_other_bid_currency = 'Y') THEN --{
2772:
2773: l_doctype_suffix := PON_LARGE_AUCTION_UTIL_PKG.GET_DOCTYPE_SUFFIX (p_auction_header_id);
2774:
2775: INSERT INTO PON_INTERFACE_ERRORS
2776: (
2777: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2778: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY,
2779: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2855: THEN INTO PON_INTERFACE_ERRORS

2851: (
2852: sel_attribute_name IS NULL OR
2853: TRIM (sel_attribute_name) = ''
2854: )
2855: THEN INTO PON_INTERFACE_ERRORS
2856: (
2857: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
2858: LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2859: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2888: THEN INTO PON_INTERFACE_ERRORS

2884: sel_sequence_number > 0 and
2885: sel_value IS NULL AND
2886: sel_display_target_flag = 'Y'
2887: )
2888: THEN INTO PON_INTERFACE_ERRORS
2889: (
2890: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2891: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2892: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2919: THEN INTO PON_INTERFACE_ERRORS

2915: (
2916: sel_weight IS NOT NULL AND
2917: (sel_weight - sel_trunc_weight <> 0)
2918: )
2919: THEN INTO PON_INTERFACE_ERRORS
2920: (
2921: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2922: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2923: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,

Line 2955: THEN INTO PON_INTERFACE_ERRORS

2951: (
2952: sel_weight is not null AND
2953: sel_trunc_weight NOT BETWEEN 0 AND 100
2954: )
2955: THEN INTO PON_INTERFACE_ERRORS
2956: (
2957: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2958: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2959: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2986: THEN INTO PON_INTERFACE_ERRORS

2982: (
2983: sel_attr_max_score is not null AND
2984: (sel_attr_max_score - sel_trunc_attr_max_score <> 0)
2985: )
2986: THEN INTO PON_INTERFACE_ERRORS
2987: (
2988: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2989: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2990: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3017: THEN INTO PON_INTERFACE_ERRORS

3013: (
3014: sel_attr_max_score is not null AND
3015: (sel_trunc_attr_max_score < 0)
3016: )
3017: THEN INTO PON_INTERFACE_ERRORS
3018: (
3019: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3020: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, CREATED_BY,
3021: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3049: THEN INTO PON_INTERFACE_ERRORS

3045: sel_sequence_number = -20 AND
3046: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
3047: p_full_quantity_bid_code = 'FULL_QTY_BIDS_REQD'
3048: )
3049: THEN INTO PON_INTERFACE_ERRORS
3050: (
3051: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3052: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
3053: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3083: THEN INTO PON_INTERFACE_ERRORS

3079: sel_weight > 0 AND
3080: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
3081: NVL (sel_scoring_type, 'NONE') = 'NONE'
3082: )
3083: THEN INTO PON_INTERFACE_ERRORS
3084: (
3085: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3086: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, TOKEN1_NAME,
3087: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 3121: THEN INTO PON_INTERFACE_ERRORS

3117: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
3118: (sel_weight IS NULL OR sel_weight <= 0) AND
3119: NVL (sel_scoring_type, 'NONE') <> 'NONE'
3120: )
3121: THEN INTO PON_INTERFACE_ERRORS
3122: (
3123: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3124: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, TOKEN1_NAME,
3125: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 3203: INSERT INTO PON_INTERFACE_ERRORS

3199: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_NAME_UNIQUE'
3200: || ', p_auction_header_id = ' || p_auction_header_id);
3201: END IF; --}
3202:
3203: INSERT INTO PON_INTERFACE_ERRORS
3204: (
3205: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3206: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
3207: TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 3273: THEN INTO PON_INTERFACE_ERRORS

3269: (
3270: SCORE is not null AND
3271: sel_trunc_score NOT BETWEEN 0 and 100
3272: )
3273: THEN INTO PON_INTERFACE_ERRORS
3274: (
3275: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID,
3276: ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE,
3277: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3303: THEN INTO PON_INTERFACE_ERRORS

3299: (
3300: SCORE is not null AND
3301: (SCORE - sel_trunc_score <>0)
3302: )
3303: THEN INTO PON_INTERFACE_ERRORS
3304: (
3305: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3306: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY,
3307: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3401: THEN INTO PON_INTERFACE_ERRORS

3397: sel_effective_start_date IS NOT NULL AND
3398: sel_effective_end_date IS NOT NULL AND
3399: sel_effective_end_date < sel_effective_start_date
3400: )
3401: THEN INTO PON_INTERFACE_ERRORS
3402: (
3403: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3404: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
3405: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 3444: THEN INTO PON_INTERFACE_ERRORS

3440: NVL(L.SHIP_TO_SITE_FLAG,'N') = 'Y' AND
3441: L.LOCATION_ID = sel_ship_to_location_id AND
3442: nvl (L.INVENTORY_ORGANIZATION_ID, sel_ship_to_organization_id) = sel_ship_to_organization_id)
3443: )
3444: THEN INTO PON_INTERFACE_ERRORS
3445: (
3446: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3447: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3448: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3481: THEN INTO PON_INTERFACE_ERRORS

3477: sel_effective_start_date IS NULL AND
3478: sel_effective_end_date IS NULL AND
3479: sel_quantity IS NULL
3480: )
3481: THEN INTO PON_INTERFACE_ERRORS
3482: (
3483: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3484: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3485: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3515: THEN INTO PON_INTERFACE_ERRORS

3511: sel_quantity IS NOT NULL AND
3512: sel_quantity < 0 AND
3513: sel_quantity <> g_null_int
3514: )
3515: THEN INTO PON_INTERFACE_ERRORS
3516: (
3517: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3518: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3519: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3547: THEN INTO PON_INTERFACE_ERRORS

3543: WHEN
3544: (
3545: sel_price < 0
3546: )
3547: THEN INTO PON_INTERFACE_ERRORS
3548: (
3549: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3550: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3551: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3580: THEN INTO PON_INTERFACE_ERRORS

3576: (
3577: sel_effective_start_date IS NOT NULL AND
3578: sel_effective_start_date <= NVL (p_close_bidding_date, SYSDATE)
3579: )
3580: THEN INTO PON_INTERFACE_ERRORS
3581: (
3582: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3583: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3584: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3613: THEN INTO PON_INTERFACE_ERRORS

3609: (
3610: sel_effective_end_date IS NOT NULL AND
3611: sel_effective_end_date <= NVL (p_close_bidding_date, SYSDATE)
3612: )
3613: THEN INTO PON_INTERFACE_ERRORS
3614: (
3615: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3616: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3617: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3654: THEN INTO PON_INTERFACE_ERRORS

3650: PPD.LINE_NUMBER = sel_line_number AND
3651: PPD.SHIPMENT_NUMBER = sel_shipment_number
3652: )
3653: )
3654: THEN INTO PON_INTERFACE_ERRORS
3655: (
3656: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3657: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3658: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3694: THEN INTO PON_INTERFACE_ERRORS

3690: PPD.LINE_NUMBER = sel_line_number AND
3691: PPD.SHIPMENT_NUMBER = sel_shipment_number
3692: )
3693: )
3694: THEN INTO PON_INTERFACE_ERRORS
3695: (
3696: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3697: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3698: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3727: THEN INTO PON_INTERFACE_ERRORS

3723: (
3724: sel_price >= 0 AND
3725: ABS (sel_price * l_temp - TRUNC (sel_price * l_temp)) > 0
3726: )
3727: THEN INTO PON_INTERFACE_ERRORS
3728: (
3729: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3730: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
3731: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3761: THEN INTO PON_INTERFACE_ERRORS

3757: p_po_start_date IS NOT NULL AND
3758: sel_effective_start_date IS NOT NULL AND
3759: sel_effective_start_date < p_po_start_date
3760: )
3761: THEN INTO PON_INTERFACE_ERRORS
3762: (
3763: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE,AUCTION_HEADER_ID, LINE_NUMBER,
3764: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,CREATION_DATE, LAST_UPDATED_BY,
3765: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3795: THEN INTO PON_INTERFACE_ERRORS

3791: p_po_start_date IS NOT NULL AND
3792: sel_effective_end_date IS NOT NULL AND
3793: sel_effective_end_date < p_po_start_date
3794: )
3795: THEN INTO PON_INTERFACE_ERRORS
3796: (
3797: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE,AUCTION_HEADER_ID, LINE_NUMBER,
3798: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,CREATION_DATE, LAST_UPDATED_BY,
3799: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3829: THEN INTO PON_INTERFACE_ERRORS

3825: p_po_end_date IS NOT NULL AND
3826: sel_effective_start_date IS NOT NULL AND
3827: sel_effective_start_date > p_po_end_date
3828: )
3829: THEN INTO PON_INTERFACE_ERRORS
3830: (
3831: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3832: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3833: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3863: THEN INTO PON_INTERFACE_ERRORS

3859: p_po_end_date IS NOT NULL AND
3860: sel_effective_end_date IS NOT NULL AND
3861: sel_effective_end_date > p_po_end_date
3862: )
3863: THEN INTO PON_INTERFACE_ERRORS
3864: (
3865: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3866: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3867: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3963: THEN INTO PON_INTERFACE_ERRORS

3959: sel_min_quantity IS NULL
3960: OR
3961: sel_min_quantity = g_null_int
3962: )
3963: THEN INTO PON_INTERFACE_ERRORS
3964: (
3965: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3966: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
3967: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 3999: THEN INTO PON_INTERFACE_ERRORS

3995: sel_max_quantity IS NULL
3996: OR
3997: sel_max_quantity = g_null_int
3998: )
3999: THEN INTO PON_INTERFACE_ERRORS
4000: (
4001: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
4002: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
4003: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4033: THEN INTO PON_INTERFACE_ERRORS

4029: (sel_min_quantity IS NOT NULL AND
4030: sel_min_quantity <= 0 AND
4031: sel_min_quantity <> g_null_int)
4032: )
4033: THEN INTO PON_INTERFACE_ERRORS
4034: (
4035: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
4036: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
4037: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4067: THEN INTO PON_INTERFACE_ERRORS

4063: (sel_max_quantity IS NOT NULL AND
4064: sel_max_quantity <= 0 AND
4065: sel_max_quantity <> g_null_int)
4066: )
4067: THEN INTO PON_INTERFACE_ERRORS
4068: (
4069: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
4070: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
4071: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4099: THEN INTO PON_INTERFACE_ERRORS

4095: WHEN
4096: (
4097: sel_min_quantity > sel_max_quantity
4098: )
4099: THEN INTO PON_INTERFACE_ERRORS
4100: (
4101: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
4102: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
4103: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4133: THEN INTO PON_INTERFACE_ERRORS

4129: sel_price <> g_null_int
4130: AND
4131: sel_price <= 0
4132: )
4133: THEN INTO PON_INTERFACE_ERRORS
4134: (
4135: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
4136: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
4137: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4166: THEN INTO PON_INTERFACE_ERRORS

4162: (
4163: sel_price > 0 AND
4164: ABS (sel_price * l_temp - TRUNC (sel_price * l_temp)) > 0
4165: )
4166: THEN INTO PON_INTERFACE_ERRORS
4167: (
4168: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4169: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
4170: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4218: INSERT INTO PON_INTERFACE_ERRORS

4214: -- The ranges of min-max quantities should not overlap across tiers for a given line in a negotiation
4215: -- When this validation is performed at shipments level multiple error message were thrown for one particular line
4216: -- To avoid the multiple error messages this validation has to be performed at line level rather than shipments level.
4217:
4218: INSERT INTO PON_INTERFACE_ERRORS
4219: (
4220: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
4221: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
4222: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4276: INSERT INTO PON_INTERFACE_ERRORS

4272: END IF; --}
4273:
4274: -- For price differentials directly under the lines
4275:
4276: INSERT INTO PON_INTERFACE_ERRORS
4277: (
4278: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4279: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4280: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4317: INSERT INTO PON_INTERFACE_ERRORS

4313: COUNT(PPD.LINE_NUMBER) > 1;
4314:
4315: -- For price differentials under shipments
4316:
4317: INSERT INTO PON_INTERFACE_ERRORS
4318: (
4319: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4320: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4321: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4401: THEN INTO PON_INTERFACE_ERRORS

4397: (
4398: sel_multiplier IS NULL OR
4399: sel_multiplier <= 0
4400: )
4401: THEN INTO PON_INTERFACE_ERRORS
4402: (
4403: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4404: LINE_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4405: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 4437: THEN INTO PON_INTERFACE_ERRORS

4433: (
4434: sel_price_type = g_empty_price_type AND
4435: sel_multiplier IS NULL
4436: )
4437: THEN INTO PON_INTERFACE_ERRORS
4438: (
4439: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4440: LINE_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
4441: TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4495: THEN INTO PON_INTERFACE_ERRORS

4491: (
4492: sel_multiplier IS NULL OR
4493: sel_multiplier <= 0
4494: )
4495: THEN INTO PON_INTERFACE_ERRORS
4496: (
4497: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4498: LINE_NUMBER, SHIPMENT_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4499: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 4532: THEN INTO PON_INTERFACE_ERRORS

4528: (
4529: sel_price_type = g_empty_price_type AND
4530: sel_multiplier IS NULL
4531: )
4532: THEN INTO PON_INTERFACE_ERRORS
4533: (
4534: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4535: LINE_NUMBER, SHIPMENT_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
4536: TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4646: THEN INTO PON_INTERFACE_ERRORS

4642: sel_value IS NOT NULL AND
4643: sel_price_element_type_id = g_item_price_type_id AND
4644: sel_value <= 0
4645: )
4646: THEN INTO PON_INTERFACE_ERRORS
4647: (
4648: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4649: LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
4650: TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4682: THEN INTO PON_INTERFACE_ERRORS

4678: sel_VALUE IS NOT NULL AND
4679: sel_PRICE_ELEMENT_TYPE_ID <> g_item_price_type_id AND
4680: sel_VALUE < 0
4681: )
4682: THEN INTO PON_INTERFACE_ERRORS
4683: (
4684: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4685: LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4686: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 4718: THEN INTO PON_INTERFACE_ERRORS

4714: (
4715: sel_value IS NULL AND
4716: sel_display_target_flag = 'Y'
4717: )
4718: THEN INTO PON_INTERFACE_ERRORS
4719: (
4720: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4721: LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4722: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 4757: THEN INTO PON_INTERFACE_ERRORS

4753: sel_pricing_basis = g_per_unit AND
4754: ABS (sel_value * l_temp - TRUNC (sel_value * l_temp))> 0
4755: )
4756:
4757: THEN INTO PON_INTERFACE_ERRORS
4758: (
4759: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4760: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4761: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 4795: THEN INTO PON_INTERFACE_ERRORS

4791: sel_value IS NOT NULL AND
4792: sel_pricing_basis = g_fixed_amount AND
4793: ABS (sel_value * l_temp_fnd - TRUNC (sel_value * l_temp_fnd)) >0
4794: )
4795: THEN INTO PON_INTERFACE_ERRORS
4796: (
4797: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4798: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4799: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 4830: THEN INTO PON_INTERFACE_ERRORS

4826: WHEN
4827: (
4828: sel_enabled_flag = 'N'
4829: )
4830: THEN INTO PON_INTERFACE_ERRORS
4831: (
4832: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4833: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4834: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 4866: THEN INTO PON_INTERFACE_ERRORS

4862: WHEN
4863: (
4864: sel_pricing_basis IS NULL
4865: )
4866: THEN INTO PON_INTERFACE_ERRORS
4867: (
4868: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4869: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4870: TOKEN1_NAME, TOKEN1_VALUE,

Line 4899: THEN INTO PON_INTERFACE_ERRORS

4895: WHEN
4896: (
4897: sel_name IS NULL
4898: )
4899: THEN INTO PON_INTERFACE_ERRORS
4900: (
4901: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4902: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4903: TOKEN1_NAME, TOKEN1_VALUE,

Line 4978: INSERT INTO PON_INTERFACE_ERRORS

4974: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_PE_UNIQUE'
4975: || ', p_auction_header_id = ' || p_auction_header_id);
4976: END IF; --}
4977:
4978: INSERT INTO PON_INTERFACE_ERRORS
4979: (
4980: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4981: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4982: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 5064: INSERT INTO PON_INTERFACE_ERRORS

5060: WHERE
5061: auction_header_id = p_auction_header_id AND
5062: group_type IN ('LOT', 'GROUP', 'LINE');
5063:
5064: INSERT INTO PON_INTERFACE_ERRORS
5065: (
5066: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
5067: AUCTION_HEADER_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
5068: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5131: THEN INTO PON_INTERFACE_ERRORS

5127: NOT EXISTS (SELECT 'X'
5128: FROM PO_JOB_ASSOCIATIONS
5129: WHERE JOB_ID = SELECTED_JOB_ID)
5130: )
5131: THEN INTO PON_INTERFACE_ERRORS
5132: (
5133: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5134: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
5135: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5166: THEN INTO PON_INTERFACE_ERRORS

5162: NOT EXISTS (SELECT 'X'
5163: FROM PO_LINE_TYPES_B
5164: WHERE LINE_TYPE_ID = SELECTED_LINE_TYPE_ID)
5165: )
5166: THEN INTO PON_INTERFACE_ERRORS
5167: (
5168: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5169: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
5170: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5208: THEN INTO PON_INTERFACE_ERRORS

5204: AND NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999)
5205: AND MIC.CATEGORY_SET_ID = MDSV.CATEGORY_SET_ID
5206: AND MDSV.FUNCTIONAL_AREA_ID = 2)
5207: )
5208: THEN INTO PON_INTERFACE_ERRORS
5209: (
5210: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5211: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
5212: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5245: THEN INTO PON_INTERFACE_ERRORS

5241: FROM MTL_ITEM_REVISIONS
5242: WHERE REVISION = SELECTED_ITEM_REVISION AND
5243: INVENTORY_ITEM_ID = SELECTED_ITEM_ID)
5244: )
5245: THEN INTO PON_INTERFACE_ERRORS
5246: (
5247: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5248: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
5249: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5291: THEN INTO PON_INTERFACE_ERRORS

5287: FROM PO_LINE_TYPES_B PLT
5288: WHERE PLT.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID
5289: AND PLT.OUTSIDE_OPERATION_FLAG ='Y') ) ) )
5290: )
5291: THEN INTO PON_INTERFACE_ERRORS
5292: (
5293: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5294: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
5295: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5332: THEN INTO PON_INTERFACE_ERRORS

5328: MSI.PURCHASING_ENABLED_FLAG = 'Y' AND
5329: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND
5330: NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999))
5331: )
5332: THEN INTO PON_INTERFACE_ERRORS
5333: (
5334: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5335: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
5336: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5404: THEN INTO PON_INTERFACE_ERRORS

5400: MSI.INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID AND
5401: ((PLTB.OUTSIDE_OPERATION_FLAG = 'Y' AND
5402: MSI.OUTSIDE_OPERATION_FLAG = 'Y') OR PLTB.OUTSIDE_OPERATION_FLAG = 'N'))
5403: )
5404: THEN INTO PON_INTERFACE_ERRORS
5405: (
5406: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5407: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
5408: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 5448: THEN INTO PON_INTERFACE_ERRORS

5444: LOC.SHIP_TO_SITE_FLAG = 'Y' AND
5445: (SELECTED_SHIP_TO_ORG_ID IS NULL OR
5446: NVL(LOC.INVENTORY_ORGANIZATION_ID, NVL(SELECTED_SHIP_TO_ORG_ID,-1)) = NVL(SELECTED_SHIP_TO_ORG_ID,-1)) AND SYSDATE < NVL(LOC.INACTIVE_DATE, SYSDATE + 1))
5447: )
5448: THEN INTO PON_INTERFACE_ERRORS
5449: (
5450: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5451: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
5452: TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 5521: THEN INTO PON_INTERFACE_ERRORS

5517: MSI.PURCHASING_ENABLED_FLAG = 'Y' AND
5518: NVL(MSI.OUTSIDE_OPERATION_FLAG, 'N') =
5519: NVL(PLTB.OUTSIDE_OPERATION_FLAG, 'N'))
5520: )
5521: THEN INTO PON_INTERFACE_ERRORS
5522: (
5523: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5524: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
5525: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 5564: THEN INTO PON_INTERFACE_ERRORS

5560: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
5561: FSP.ORG_ID = SELECTED_ORG_ID AND
5562: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) )
5563: )
5564: THEN INTO PON_INTERFACE_ERRORS
5565: (
5566: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
5567: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
5568: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 5650: INSERT INTO PON_INTERFACE_ERRORS

5646: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
5647: message => 'This is a global agreement so validation for outside ops');
5648: END IF; --}
5649:
5650: INSERT INTO PON_INTERFACE_ERRORS
5651: (
5652: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
5653: AUCTION_HEADER_ID, EXPIRATION_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
5654: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 5731: INTO pon_interface_errors

5727: INSERT ALL
5728: WHEN NOT ((order_type_lookup_code = 'FIXED PRICE' AND purchase_basis = 'SERVICES') OR
5729: (order_type_lookup_code = 'QUANTITY' AND purchase_basis = 'GOODS'))
5730: OR po_outside_operation_flag = 'Y' THEN
5731: INTO pon_interface_errors
5732: (
5733: interface_type, error_message_name, batch_id, -- 1
5734: entity_type, auction_header_id, line_number, -- 2
5735: token1_name, token1_value, expiration_date, -- 3

Line 5765: INTO pon_interface_errors

5761: ELSIF l_contract_type = 'STANDARD' THEN
5762:
5763: INSERT ALL
5764: WHEN s_clm_info_flag = 'N' AND retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
5765: INTO pon_interface_errors
5766: (
5767: interface_type, error_message_name, batch_id, -- 2
5768: entity_type, auction_header_id, line_number, -- 3
5769: token1_name, token1_value, expiration_date, -- 4

Line 5783: INTO pon_interface_errors

5779: SYSDATE, p_login_id, p_request_id -- 6
5780: )
5781:
5782: WHEN s_clm_info_flag = 'N' AND max_retainage_amount IS NOT NULL AND max_retainage_amount < 0 THEN
5783: INTO pon_interface_errors
5784: (
5785: interface_type, error_message_name, batch_id, -- 2
5786: entity_type, auction_header_id, line_number, -- 3
5787: token1_name, token1_value, expiration_date, -- 4

Line 5801: INTO pon_interface_errors

5797: SYSDATE, p_login_id, p_request_id -- 6
5798: )
5799:
5800: WHEN s_clm_info_flag = 'N' AND advance_amount IS NOT NULL AND advance_amount < 0 THEN
5801: INTO pon_interface_errors
5802: (
5803: interface_type, error_message_name, batch_id, -- 2
5804: entity_type, auction_header_id, line_number, -- 3
5805: token1_name, token1_value, expiration_date, -- 4

Line 5819: INTO pon_interface_errors

5815: SYSDATE, p_login_id, p_request_id -- 6
5816: )
5817:
5818: WHEN s_clm_info_flag = 'N' AND progress_pymt_rate_percent IS NOT NULL AND (progress_pymt_rate_percent < 0 OR progress_pymt_rate_percent > 100) then
5819: INTO pon_interface_errors
5820: (
5821: interface_type, error_message_name, batch_id, -- 2
5822: entity_type, auction_header_id, line_number, -- 3
5823: token1_name, token1_value, expiration_date, -- 4

Line 5836: INTO pon_interface_errors

5832: p_user_id, SYSDATE, p_user_id, -- 5
5833: SYSDATE, p_login_id, p_request_id -- 6
5834: )
5835: WHEN s_clm_info_flag = 'N' AND recoupment_rate_percent IS NOT NULL AND (recoupment_rate_percent < 0 OR recoupment_rate_percent > 100) THEN
5836: INTO pon_interface_errors
5837: (
5838: interface_type, error_message_name, batch_id, -- 2
5839: entity_type, auction_header_id, line_number, -- 3
5840: token1_name, token1_value, expiration_date, -- 4

Line 5855: INTO pon_interface_errors

5851: )
5852:
5853: WHEN s_clm_info_flag = 'N' AND progress_pymt_rate_percent IS NOT NULL AND
5854: PON_BID_VALIDATIONS_PKG.validate_currency_precision(progress_pymt_rate_percent, 2) = 'F' THEN
5855: INTO pon_interface_errors
5856: (
5857: interface_type, error_message_name, batch_id, -- 2
5858: entity_type, auction_header_id, line_number, -- 3
5859: token1_name, token1_value, expiration_date, -- 4

Line 5876: INTO pon_interface_errors

5872: )
5873:
5874: WHEN s_clm_info_flag = 'N' AND recoupment_rate_percent IS NOT NULL AND
5875: PON_BID_VALIDATIONS_PKG.validate_currency_precision(recoupment_rate_percent, 2) = 'F' THEN
5876: INTO pon_interface_errors
5877: (
5878: interface_type, error_message_name, batch_id, -- 2
5879: entity_type, auction_header_id, line_number, -- 3
5880: token1_name, token1_value, expiration_date, -- 4

Line 5897: INTO pon_interface_errors

5893: )
5894:
5895: WHEN s_clm_info_flag = 'N' AND retainage_rate_percent IS NOT NULL AND
5896: PON_BID_VALIDATIONS_PKG.validate_currency_precision(retainage_rate_percent, 2) = 'F' THEN
5897: INTO pon_interface_errors
5898: (
5899: interface_type, error_message_name, batch_id, -- 2
5900: entity_type, auction_header_id, line_number, -- 3
5901: token1_name, token1_value, expiration_date, -- 4

Line 5918: INTO pon_interface_errors

5914: )
5915:
5916: WHEN s_clm_info_flag = 'N' AND advance_amount IS NOT NULL AND
5917: PON_BID_VALIDATIONS_PKG.validate_currency_precision(advance_amount, p_fnd_currency_precision) = 'F' THEN
5918: INTO pon_interface_errors
5919: (
5920: interface_type, error_message_name, batch_id, -- 2
5921: entity_type, auction_header_id, line_number, -- 3
5922: token1_name, token1_value, expiration_date, -- 4

Line 5939: INTO pon_interface_errors

5935: )
5936:
5937: WHEN s_clm_info_flag = 'N' AND max_retainage_amount IS NOT NULL AND
5938: PON_BID_VALIDATIONS_PKG.validate_currency_precision(max_retainage_amount, p_fnd_currency_precision) = 'F' THEN
5939: INTO pon_interface_errors
5940: (
5941: interface_type, error_message_name, batch_id, -- 2
5942: entity_type, auction_header_id, line_number, -- 3
5943: token1_name, token1_value, expiration_date, -- 4

Line 5959: INTO pon_interface_errors

5955: 'LINENUM', Decode(g_is_fed,'Y',LINE_NUM_DISPLAY,DOCUMENT_DISP_LINE_NUMBER)
5956: )
5957:
5958: WHEN s_clm_info_flag = 'N' AND l_progress_payment_type = 'FINANCE' AND progress_pymt_rate_percent IS NULL THEN
5959: INTO pon_interface_errors
5960: (
5961: interface_type, error_message_name, batch_id, -- 2
5962: entity_type, auction_header_id, line_number, -- 3
5963: token1_name, token1_value, expiration_date, -- 4

Line 5981: INTO pon_interface_errors

5977: (po_outside_operation_flag = 'Y' OR
5978: NOT ((order_type_lookup_code = 'FIXED PRICE' AND purchase_basis = 'SERVICES') OR
5979: (order_type_lookup_code = 'QUANTITY' AND purchase_basis = 'GOODS'))
5980: )) THEN
5981: INTO pon_interface_errors
5982: (
5983: interface_type, error_message_name, batch_id, -- 2
5984: entity_type, auction_header_id, line_number, -- 3
5985: token1_name, token1_value, expiration_date, -- 4

Line 6001: INTO pon_interface_errors

5997:
5998: WHEN s_clm_info_flag = 'N' AND progress_pymt_rate_percent IS NOT NULL AND
5999: recoupment_rate_percent IS NULL AND
6000: l_recoupment_negotiable_flag = 'N' THEN
6001: INTO pon_interface_errors
6002: (
6003: interface_type, error_message_name, batch_id, -- 2
6004: entity_type, auction_header_id, line_number, -- 3
6005: token1_name, token1_value, expiration_date, -- 4

Line 6020: INTO pon_interface_errors

6016: )
6017:
6018: WHEN s_clm_info_flag = 'N' AND ((advance_amount IS NOT NULL or l_advance_negotiable_flag = 'Y') AND
6019: (recoupment_rate_percent IS NULL AND l_recoupment_negotiable_flag = 'N')) THEN
6020: INTO pon_interface_errors
6021: (
6022: interface_type, error_message_name, batch_id, -- 2
6023: entity_type, auction_header_id, line_number, -- 3
6024: token1_name, token1_value, expiration_date, -- 4

Line 6039: INTO pon_interface_errors

6035: )
6036:
6037: WHEN s_clm_info_flag = 'N' AND target_price IS NOT NULL AND advance_amount IS NOT NULL
6038: AND (advance_amount > nvl(s_quantity,1) * target_price) THEN
6039: INTO pon_interface_errors
6040: (
6041: interface_type, error_message_name, batch_id, -- 2
6042: entity_type, auction_header_id, line_number, -- 3
6043: token1_name, token1_value, expiration_date, -- 4

Line 6060: INTO pon_interface_errors

6056: WHEN s_clm_info_flag = 'N' AND l_progress_payment_type = 'ACTUAL' AND recoupment_rate_percent IS NOT NULL
6057: AND target_price IS NOT NULL
6058: AND advance_amount IS NOT NULL
6059: AND (recoupment_rate_percent < (advance_amount * 100)/(nvl(s_quantity,1) * target_price)) THEN
6060: INTO pon_interface_errors
6061: (
6062: interface_type, error_message_name, batch_id, -- 2
6063: entity_type, auction_header_id, line_number, -- 3
6064: token1_name, token1_value, expiration_date, -- 4

Line 6084: INTO pon_interface_errors

6080: FROM PON_AUC_PAYMENTS_SHIPMENTS p_aps
6081: WHERE p_aps.auction_header_id=p_auction_header_id
6082: AND p_aps.line_number=s_line_number ))
6083: + NVL(advance_amount,0)) * 100)/((nvl(s_quantity, 1) * target_price))) THEN
6084: INTO pon_interface_errors
6085: (
6086: interface_type, error_message_name, batch_id, -- 2
6087: entity_type, auction_header_id, line_number, -- 3
6088: token1_name, token1_value, expiration_date, -- 4

Line 6105: INTO pon_interface_errors

6101: WHEN (pai_project_id IS NOT NULL OR pai_project_task_id IS NOT NULL OR pai_project_exp_org_id IS NOT NULL
6102: OR pai_project_exp_item_date IS NOT NULL OR pai_project_exp_type IS NOT NULL)
6103: AND (pai_project_id IS NULL OR pai_project_task_id IS NULL OR pai_project_exp_org_id IS NULL
6104: OR pai_project_exp_item_date IS NULL OR pai_project_exp_type IS NULL) THEN
6105: INTO pon_interface_errors
6106: (
6107: interface_type, error_message_name, batch_id, -- 2
6108: entity_type, auction_header_id, line_number, -- 3
6109: token1_name, token1_value, expiration_date, -- 4

Line 6164: INTO pon_interface_errors

6160: WHERE fu.user_id = work_approver_user_id
6161: AND fu.employee_id = peo.person_id
6162: AND SYSDATE >= nvl(fu.start_date, SYSDATE)
6163: AND SYSDATE <= nvl(fu.end_date, SYSDATE) ) THEN
6164: INTO pon_interface_errors
6165: (
6166: interface_type, error_message_name, batch_id, -- 2
6167: entity_type, auction_header_id, line_number, -- 3
6168: token1_name, token1_value, expiration_date, -- 4

Line 6198: INTO pon_interface_errors

6194: WHEN pai_project_id IS NOT NULL
6195: AND NOT EXISTS(SELECT 1
6196: FROM pa_projects_expend_v pro
6197: WHERE pro.project_id = pai_project_id) THEN
6198: INTO pon_interface_errors
6199: (
6200: interface_type, error_message_name, batch_id, -- 2
6201: entity_type, auction_header_id, line_number, -- 3
6202: token1_name, token1_value, expiration_date, -- 4

Line 6220: INTO pon_interface_errors

6216: AND NOT EXISTS(SELECT 1
6217: FROM pa_tasks_expend_v tas
6218: WHERE tas.project_id = pai_project_id
6219: AND tas.task_id = pai_project_task_id) THEN
6220: INTO pon_interface_errors
6221: (
6222: interface_type, error_message_name, batch_id, -- 2
6223: entity_type, auction_header_id, line_number, -- 3
6224: token1_name, token1_value, expiration_date, -- 4

Line 6245: INTO pon_interface_errors

6241: FROM GMS_AWARDS_BASIC_V award
6242: WHERE award.project_id = pai_project_id
6243: AND award.task_id = pai_project_task_id
6244: AND award.award_id = pai_project_award_id) THEN
6245: INTO pon_interface_errors
6246: (
6247: interface_type, error_message_name, batch_id, -- 2
6248: entity_type, auction_header_id, line_number, -- 3
6249: token1_name, token1_value, expiration_date, -- 4

Line 6267: INTO pon_interface_errors

6263: AND NOT EXISTS (SELECT 1
6264: FROM PA_ORGANIZATIONS_EXPEND_V porg
6265: WHERE porg.organization_id = pai_project_exp_org_id) THEN
6266:
6267: INTO pon_interface_errors
6268: (
6269: interface_type, error_message_name, batch_id, -- 2
6270: entity_type, auction_header_id, line_number, -- 3
6271: token1_name, token1_value, expiration_date, -- 4

Line 6293: INTO pon_interface_errors

6289: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
6290: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))
6291: AND trunc(sysdate) BETWEEN nvl(exptype.sys_link_start_date_active, trunc(sysdate))
6292: AND nvl(exptype.sys_link_end_date_Active, trunc(sysdate))) THEN
6293: INTO pon_interface_errors
6294: (
6295: interface_type, error_message_name, batch_id, -- 2
6296: entity_type, auction_header_id, line_number, -- 3
6297: token1_name, token1_value, expiration_date, -- 4

Line 6313: INTO pon_interface_errors

6309:
6310: WHEN pai_project_id IS NOT NULL
6311: AND pai_project_award_id IS NULL
6312: AND IS_PROJECT_SPONSORED(pai_project_id) = 'Y' THEN
6313: INTO pon_interface_errors
6314: (
6315: interface_type, error_message_name, batch_id, -- 2
6316: entity_type, auction_header_id, line_number, -- 3
6317: token1_name, token1_value, expiration_date, -- 4

Line 6374: INSERT INTO PON_INTERFACE_ERRORS

6370: END LOOP;
6371:
6372: BEGIN
6373:
6374: INSERT INTO PON_INTERFACE_ERRORS
6375: (
6376: interface_type,
6377: error_message_name,
6378: batch_id,

Line 6482: INTO pon_interface_errors

6478: END IF; --}
6479:
6480: INSERT ALL
6481: WHEN payment_display_number < 1 OR payment_display_number<> ROUND(payment_display_number) THEN
6482: INTO pon_interface_errors
6483: (
6484: column_name, entity_attr_name, error_message_name, -- 1
6485: error_value_datatype, error_value_number, error_value_date, -- 2
6486: token1_name, token1_value, token2_name, -- 3

Line 6505: INTO pon_interface_errors

6501: p_expiration_date, p_user_id, SYSDATE, -- 7
6502: p_user_id, SYSDATE, p_login_id -- 8
6503: )
6504: WHEN payment_type_code = 'RATE' AND quantity < 0 THEN
6505: INTO pon_interface_errors
6506: (
6507: column_name, entity_attr_name, error_message_name, -- 1
6508: error_value_datatype, error_value_number, error_value_date, -- 2
6509: token1_name, token1_value, token2_name, -- 3

Line 6528: INTO pon_interface_errors

6524: p_expiration_date, p_user_id, SYSDATE, -- 7
6525: p_user_id, SYSDATE, p_login_id -- 8
6526: )
6527: WHEN target_price IS NOT NULL AND target_price < 0 THEN
6528: INTO pon_interface_errors
6529: (
6530: column_name, entity_attr_name, error_message_name, -- 1
6531: error_value_datatype, error_value_number, error_value_date, -- 2
6532: token1_name, token1_value, token2_name, -- 3

Line 6552: INTO pon_interface_errors

6548: p_user_id, SYSDATE, p_login_id -- 8
6549: )
6550: WHEN target_price IS NOT NULL
6551: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(target_price, p_price_precision) = 'F' THEN
6552: INTO pon_interface_errors
6553: (
6554: column_name, entity_attr_name, error_message_name, -- 1
6555: error_value_datatype, error_value_number, error_value_date, -- 2
6556: token1_name, token1_value, token2_name, -- 3

Line 6575: INTO pon_interface_errors

6571: p_expiration_date, p_user_id, SYSDATE, -- 7
6572: p_user_id, SYSDATE, p_login_id -- 8
6573: )
6574: WHEN payment_display_number IS NULL THEN
6575: INTO pon_interface_errors
6576: (
6577: column_name, entity_attr_name, error_message_name, -- 1
6578: error_value_datatype, error_value_number, error_value_date, -- 2
6579: token1_name, token1_value, token2_name, -- 3

Line 6598: INTO pon_interface_errors

6594: p_expiration_date, p_user_id, SYSDATE, -- 7
6595: p_user_id, SYSDATE, p_login_id -- 8
6596: )
6597: WHEN payment_type_code IS NULL THEN
6598: INTO pon_interface_errors
6599: (
6600: column_name, entity_attr_name, error_message_name, -- 1
6601: error_value_datatype, error_value, error_value_date, -- 2
6602: token1_name, token1_value, token2_name, -- 3

Line 6621: INTO pon_interface_errors

6617: p_expiration_date, p_user_id, SYSDATE, -- 7
6618: p_user_id, SYSDATE, p_login_id -- 8
6619: )
6620: WHEN payment_description IS NULL THEN
6621: INTO pon_interface_errors
6622: (
6623: column_name, entity_attr_name, error_message_name, -- 1
6624: error_value_datatype, error_value, error_value_date, -- 2
6625: token1_name, token1_value, token2_name, -- 3

Line 6644: INTO pon_interface_errors

6640: p_expiration_date, p_user_id, SYSDATE, -- 7
6641: p_user_id, SYSDATE, p_login_id -- 8
6642: )
6643: WHEN payment_type_code = 'RATE' AND quantity IS NULL THEN
6644: INTO pon_interface_errors
6645: (
6646: column_name, entity_attr_name, error_message_name, -- 1
6647: error_value_datatype, error_value_number, error_value_date, -- 2
6648: token1_name, token1_value, token2_name, -- 3

Line 6667: INTO pon_interface_errors

6663: p_expiration_date, p_user_id, SYSDATE, -- 7
6664: p_user_id, SYSDATE, p_login_id -- 8
6665: )
6666: WHEN payment_type_code = 'RATE' AND uom_code IS NULL THEN
6667: INTO pon_interface_errors
6668: (
6669: column_name, entity_attr_name, error_message_name, -- 1
6670: error_value_datatype, error_value, error_value_date, -- 2
6671: token1_name, token1_value, token2_name, -- 3

Line 6690: INTO pon_interface_errors

6686: p_expiration_date, p_user_id, SYSDATE, -- 7
6687: p_user_id, SYSDATE, p_login_id -- 8
6688: )
6689: WHEN nvl(supplier_enterable_pymt_flag,'N') = 'N' AND ship_to_location_id IS NULL THEN
6690: INTO pon_interface_errors
6691: (
6692: column_name, entity_attr_name, error_message_name, -- 1
6693: error_value_datatype, error_value, error_value_date, -- 2
6694: token1_name, token1_value, token2_name, -- 3

Line 6713: INTO pon_interface_errors

6709: p_expiration_date, p_user_id, SYSDATE, -- 7
6710: p_user_id, SYSDATE, p_login_id -- 8
6711: )
6712: WHEN need_by_date IS NOT NULL AND need_by_date <= pah_close_bidding_date THEN
6713: INTO pon_interface_errors
6714: (
6715: column_name, entity_attr_name, error_message_name, -- 1
6716: error_value_datatype, error_value_number, error_value_date, -- 2
6717: token1_name, token1_value, token2_name, -- 3

Line 6743: INTO pon_interface_errors

6739: WHERE fu.user_id = work_approver_user_id
6740: AND fu.employee_id = peo.person_id
6741: AND SYSDATE >= nvl(fu.start_date, SYSDATE)
6742: AND SYSDATE <= nvl(fu.end_date, SYSDATE) ) THEN
6743: INTO pon_interface_errors
6744: (
6745: column_name, entity_attr_name, error_message_name, -- 1
6746: error_value_datatype, error_value_number, error_value_date, -- 2
6747: token1_name, token1_value, token2_name, -- 3

Line 6769: INTO pon_interface_errors

6765: WHEN (s_project_id IS NOT NULL OR s_project_task_id IS NOT NULL OR s_project_exp_org_id IS NOT NULL
6766: OR s_project_exp_item_date IS NOT NULL OR s_project_exp_type IS NOT NULL)
6767: AND (s_project_id IS NULL OR s_project_task_id IS NULL OR s_project_exp_org_id IS NULL
6768: OR s_project_exp_item_date IS NULL OR s_project_exp_type IS NULL) THEN
6769: INTO pon_interface_errors
6770: (
6771: column_name, entity_attr_name, error_message_name, -- 1
6772: error_value_datatype, error_value, error_value_date, -- 2
6773: token1_name, token1_value, token2_name, -- 3

Line 6828: INTO pon_interface_errors

6824: WHEN s_project_id IS NOT NULL
6825: AND NOT EXISTS(SELECT 1
6826: FROM pa_projects_expend_v pro
6827: WHERE pro.project_id = s_project_id) THEN
6828: INTO pon_interface_errors
6829: (
6830: column_name, entity_attr_name, error_message_name, -- 1
6831: error_value_datatype, error_value_number, error_value_date, -- 2
6832: token1_name, token1_value, token2_name, -- 3

Line 6855: INTO pon_interface_errors

6851: AND NOT EXISTS(SELECT 1
6852: FROM pa_tasks_expend_v tas
6853: WHERE tas.project_id = s_project_id
6854: AND tas.task_id = s_project_task_id) THEN
6855: INTO pon_interface_errors
6856: (
6857: column_name, entity_attr_name, error_message_name, -- 1
6858: error_value_datatype, error_value_number, error_value_date, -- 2
6859: token1_name, token1_value, token2_name, -- 3

Line 6885: INTO pon_interface_errors

6881: FROM GMS_AWARDS_BASIC_V award
6882: WHERE award.project_id = s_project_id
6883: AND award.task_id = s_project_task_id
6884: AND award.award_id = s_project_award_id) THEN
6885: INTO pon_interface_errors
6886: (
6887: column_name, entity_attr_name, error_message_name, -- 1
6888: error_value_datatype, error_value_number, error_value_date, -- 2
6889: token1_name, token1_value, token2_name, -- 3

Line 6910: INTO pon_interface_errors

6906: )
6907: WHEN s_project_id IS NOT NULL
6908: AND s_project_award_id IS NULL
6909: AND IS_PROJECT_SPONSORED(s_project_id) = 'Y' THEN
6910: INTO pon_interface_errors
6911: (
6912: column_name, entity_attr_name, error_message_name, -- 1
6913: error_value_datatype, error_value_number, error_value_date, -- 2
6914: token1_name, token1_value, token2_name, -- 3

Line 6936: INTO pon_interface_errors

6932: WHEN s_project_exp_org_id IS NOT NULL
6933: AND NOT EXISTS (SELECT 1
6934: FROM PA_ORGANIZATIONS_EXPEND_V porg
6935: WHERE porg.organization_id = s_project_exp_org_id) THEN
6936: INTO pon_interface_errors
6937: (
6938: column_name, entity_attr_name, error_message_name, -- 1
6939: error_value_datatype, error_value_number, error_value_date, -- 2
6940: token1_name, token1_value, token2_name, -- 3

Line 6967: INTO pon_interface_errors

6963: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
6964: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))
6965: AND trunc(sysdate) BETWEEN nvl(exptype.sys_link_start_date_active, trunc(sysdate))
6966: AND nvl(exptype.sys_link_end_date_Active, trunc(sysdate))) THEN
6967: INTO pon_interface_errors
6968: (
6969: column_name, entity_attr_name, error_message_name, -- 1
6970: error_value_datatype, error_value, error_value_date, -- 2
6971: token1_name, token1_value, token2_name, -- 3

Line 7628: INSERT INTO PON_INTERFACE_ERRORS

7624: p_user_id IN NUMBER
7625: ) IS
7626: BEGIN
7627:
7628: INSERT INTO PON_INTERFACE_ERRORS
7629: (
7630: INTERFACE_TYPE,
7631: ERROR_MESSAGE_NAME,
7632: TOKEN1_NAME,

Line 7682: PON_INTERFACE_ERRORS

7678: BATCH_ID
7679: INTO
7680: l_batch_id
7681: FROM
7682: PON_INTERFACE_ERRORS
7683: WHERE
7684: BATCH_ID = p_batch_id AND
7685: ROWNUM =1;
7686:

Line 7813: PON_INTERFACE_ERRORS

7809: l_token5_value,
7810: l_payment_id,
7811: l_bid_payment_id
7812: FROM
7813: PON_INTERFACE_ERRORS
7814: WHERE
7815: BATCH_ID = p_batch_id;
7816:
7817: ROLLBACK;

Line 7820: INSERT INTO PON_INTERFACE_ERRORS

7816:
7817: ROLLBACK;
7818:
7819: FORALL x IN 1..l_interface_type.COUNT
7820: INSERT INTO PON_INTERFACE_ERRORS
7821: (
7822: INTERFACE_TYPE,
7823: COLUMN_NAME,
7824: TABLE_NAME,

Line 9157: -- insert an error row into the pon_interface_errors table

9153: ELSE
9154: l_error_message_name := 'PON_NEG_APPROVE_FATAL_ERROR';
9155: END IF;
9156:
9157: -- insert an error row into the pon_interface_errors table
9158: LOG_INTERFACE_ERROR (
9159: p_interface_type => g_interface_type,
9160: p_error_message_name => l_error_message_name,
9161: p_token1_name => 'DOC_NUM',

Line 9515: --Log this error in the PON_INTERFACE_ERRORS TABLE

9511:
9512: RETCODE := 2;
9513: ERRBUF := 'PON_NO_DRAFT_LOCK';
9514:
9515: --Log this error in the PON_INTERFACE_ERRORS TABLE
9516:
9517: LOG_INTERFACE_ERROR (
9518: p_interface_type => g_interface_type,
9519: p_error_message_name => 'PON_NO_DRAFT_LOCK',

Line 9850: --Log this error in the PON_INTERFACE_ERRORS TABLE

9846: FND_LOG.string(log_level => FND_LOG.level_statement,
9847: module => g_module_prefix || l_module_name,
9848: message => l_error_msg);
9849: END IF; --}
9850: --Log this error in the PON_INTERFACE_ERRORS TABLE
9851: LOG_INTERFACE_ERROR (
9852: p_interface_type => g_interface_type,
9853: p_error_message_name => l_error_msg,
9854: p_token1_name => null,