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 185: INSERT INTO pon_interface_errors

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

Line 308: THEN INTO PON_INTERFACE_ERRORS

304: (sel_group_type IN ('GROUP_LINE', 'LOT_LINE') AND sel_parent_line_number IS NULL) OR
305: (sel_group_type IN ('GROUP', 'LOT') AND sel_parent_line_number IS NOT NULL)
306: )
307:
308: THEN INTO PON_INTERFACE_ERRORS
309: (
310: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
311: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
312: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 341: THEN INTO PON_INTERFACE_ERRORS

337: g_document_type_validity_rule ('ITEM_DESCRIPTION') = 'Y' AND
338: (sel_item_description IS NULL OR trim (sel_item_description) = '')
339: )
340:
341: THEN INTO PON_INTERFACE_ERRORS
342: (
343: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
344: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
345: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 375: THEN INTO PON_INTERFACE_ERRORS

371: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
372: sel_line_type_id IS NULL
373: )
374:
375: THEN INTO PON_INTERFACE_ERRORS
376: (
377: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
378: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
379: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 408: THEN INTO PON_INTERFACE_ERRORS

404: (sel_category_name IS NULL OR TRIM (sel_category_name) = '' OR sel_category_id IS NULL) AND
405: NVL (sel_group_type, g_invalid_string) <> 'GROUP'
406: )
407:
408: THEN INTO PON_INTERFACE_ERRORS
409: (
410: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
411: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
412: LAST_UPDATE_LOGIN

Line 442: THEN INTO PON_INTERFACE_ERRORS

438: sel_target_price IS NOT NULL AND
439: sel_target_price <= 0
440: )
441:
442: THEN INTO PON_INTERFACE_ERRORS
443: (
444: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
445: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
446: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 477: THEN INTO PON_INTERFACE_ERRORS

473: sel_bid_start_price IS NOT NULL AND
474: sel_bid_start_price <= 0
475: )
476:
477: THEN INTO PON_INTERFACE_ERRORS
478: (
479: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
480: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
481: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 512: THEN INTO PON_INTERFACE_ERRORS

508: sel_current_price IS NOT NULL AND
509: sel_current_price <= 0
510: )
511:
512: THEN INTO PON_INTERFACE_ERRORS
513: (
514: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
515: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
516: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 546: THEN INTO PON_INTERFACE_ERRORS

542: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
543: sel_target_price >= sel_bid_start_price
544: )
545:
546: THEN INTO PON_INTERFACE_ERRORS
547: (
548: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
549: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
550: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 580: THEN INTO PON_INTERFACE_ERRORS

576: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
577: sel_target_price IS NULL AND
578: sel_display_target_price_flag = 'Y'
579: )
580: THEN INTO PON_INTERFACE_ERRORS
581: (
582: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
583: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
584: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 615: THEN INTO PON_INTERFACE_ERRORS

611: sel_po_min_rel_amount <> g_null_int AND
612: sel_po_min_rel_amount < 0
613: )
614:
615: THEN INTO PON_INTERFACE_ERRORS
616: (
617: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
618: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
619: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 649: THEN INTO PON_INTERFACE_ERRORS

645: sel_unit_target_price IS NULL AND
646: sel_unit_display_target_flag = 'Y'
647: )
648:
649: THEN INTO PON_INTERFACE_ERRORS
650: (
651: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
652: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
653: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 683: THEN INTO PON_INTERFACE_ERRORS

679: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
680: sel_target_price IS NOT NULL AND
681: ABS (sel_target_price * l_temp - TRUNC (sel_target_price * l_temp)) > 0
682: )
683: THEN INTO PON_INTERFACE_ERRORS
684: (
685: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
686: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
687: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 716: THEN INTO PON_INTERFACE_ERRORS

712: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
713: sel_bid_start_price IS NOT NULL AND
714: ABS (sel_bid_start_price * l_temp - TRUNC (sel_bid_start_price * l_temp)) > 0
715: )
716: THEN INTO PON_INTERFACE_ERRORS
717: (
718: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
719: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
720: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 749: THEN INTO PON_INTERFACE_ERRORS

745: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
746: sel_current_price IS NOT NULL AND
747: ABS (sel_current_price * l_temp - TRUNC (sel_current_price * l_temp)) > 0
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_po_min_rel_amount <> g_null_int AND
782: ABS (sel_po_min_rel_amount * l_temp_fnd - TRUNC (sel_po_min_rel_amount * l_temp_fnd)) > 0
783: )
784:
785: THEN INTO PON_INTERFACE_ERRORS
786: (
787: INTERFACE_TYPE,
788: ERROR_MESSAGE_NAME,
789: REQUEST_ID,

Line 827: THEN INTO PON_INTERFACE_ERRORS

823: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
824: sel_need_by_date < sel_need_by_start_date
825: )
826:
827: THEN INTO PON_INTERFACE_ERRORS
828: (
829: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
830: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
831: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 863: THEN INTO PON_INTERFACE_ERRORS

859: sel_need_by_date IS NOT NULL AND
860: sel_need_by_date < nvl (p_close_bidding_date, SYSDATE)
861: )
862:
863: THEN INTO PON_INTERFACE_ERRORS
864: (
865: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
866: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
867: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 930: THEN INTO PON_INTERFACE_ERRORS

926: sel_need_by_start_date < nvl (p_close_bidding_date, SYSDATE) AND
927: p_contract_type = 'STANDARD'
928: )
929:
930: THEN INTO PON_INTERFACE_ERRORS
931: (
932: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
933: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
934: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 980: THEN INTO PON_INTERFACE_ERRORS

976: (3, 4, 7, 8, 9))
977: )
978: )
979:
980: THEN INTO PON_INTERFACE_ERRORS
981: (
982: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
983: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
984: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1016: THEN INTO PON_INTERFACE_ERRORS

1012: p_global_agreement_flag = 'Y' AND
1013: l_price_tiers_indicator = 'PRICE_BREAKS'
1014: )
1015:
1016: THEN INTO PON_INTERFACE_ERRORS
1017: (
1018: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1019: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1020: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1061: THEN INTO PON_INTERFACE_ERRORS

1057: PASA.LINE_NUMBER = sel_line_number
1058: )
1059: )
1060:
1061: THEN INTO PON_INTERFACE_ERRORS
1062: (
1063: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1064: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY, CREATION_DATE,
1065: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1103: THEN INTO PON_INTERFACE_ERRORS

1099: PPD.SHIPMENT_NUMBER = -1
1100: )
1101: )
1102:
1103: THEN INTO PON_INTERFACE_ERRORS
1104: (
1105: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1106: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE,TOKEN1_NAME, TOKEN1_VALUE,
1107: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1145: THEN INTO PON_INTERFACE_ERRORS

1141: PPD.SHIPMENT_NUMBER = -1
1142: )
1143: )
1144:
1145: THEN INTO PON_INTERFACE_ERRORS
1146: (
1147: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1148: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE,TOKEN1_NAME, TOKEN1_VALUE,
1149: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1184: THEN INTO PON_INTERFACE_ERRORS

1180: PARENT_LINE_NUMBER = sel_line_number
1181: )
1182: )
1183:
1184: THEN INTO PON_INTERFACE_ERRORS
1185: (
1186: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1187: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1188: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1218: THEN INTO PON_INTERFACE_ERRORS

1214: sel_unit_target_price IS NOT NULL AND
1215: sel_unit_target_price < 0
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 1260: THEN INTO PON_INTERFACE_ERRORS

1256: PF_TYPE='SUPPLIER'
1257: )
1258: )
1259:
1260: THEN INTO PON_INTERFACE_ERRORS
1261: (
1262: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1263: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1264: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1310: THEN INTO PON_INTERFACE_ERRORS

1306: AUCTION_HEADER_ID = p_auction_header_id
1307: AND LINE_NUMBER = sel_line_number) <> 100
1308: )
1309:
1310: THEN INTO PON_INTERFACE_ERRORS
1311: (
1312: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1313: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1314: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1344: THEN INTO PON_INTERFACE_ERRORS

1340: sel_quantity IS NOT NULL AND
1341: sel_quantity <= 0
1342: )
1343:
1344: THEN INTO PON_INTERFACE_ERRORS
1345: (
1346: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1347: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1348: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1377: THEN INTO PON_INTERFACE_ERRORS

1373: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1374: sel_po_agreed_amount IS NOT NULL AND
1375: ABS (sel_po_agreed_amount * l_temp - TRUNC (sel_po_agreed_amount * l_temp)) > 0
1376: )
1377: THEN INTO PON_INTERFACE_ERRORS
1378: (
1379: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1380: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1381: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1414: THEN INTO PON_INTERFACE_ERRORS

1410: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1411: nvl (sel_line_origination_code,g_invalid_string) <> 'REQUISITION' AND
1412: sel_ship_to_location_id IS NULL
1413: )
1414: THEN INTO PON_INTERFACE_ERRORS
1415: (
1416: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1417: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1418: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1451: THEN INTO PON_INTERFACE_ERRORS

1447: AUCTION_HEADER_ID = p_auction_header_id AND
1448: sel_group_type IN ('LOT', 'GROUP', 'LINE') AND
1449: LINE_NUMBER = sel_line_number) = p_invitees_count
1450: )
1451: THEN INTO PON_INTERFACE_ERRORS
1452: (
1453: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1454: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1455: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1564: THEN INTO PON_INTERFACE_ERRORS

1560: (
1561: sel_uom_code IS NULL OR TRIM (sel_uom_code) = ''
1562: )
1563: )
1564: THEN INTO PON_INTERFACE_ERRORS
1565: (
1566: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1567: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1568: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1601: THEN INTO PON_INTERFACE_ERRORS

1597: ((nvl (sel_purchase_basis,g_invalid_string) <> g_temp_labor AND
1598: g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION) OR
1599: p_contract_type = 'STANDARD')
1600: )
1601: THEN INTO PON_INTERFACE_ERRORS
1602: (
1603: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1604: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1605: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1634: THEN INTO PON_INTERFACE_ERRORS

1630: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1631: sel_job_id IS NULL AND
1632: sel_purchase_basis = g_temp_labor
1633: )
1634: THEN INTO PON_INTERFACE_ERRORS
1635: (
1636: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1637: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1638: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1668: THEN INTO PON_INTERFACE_ERRORS

1664: sel_po_agreed_amount IS NOT NULL AND
1665: sel_purchase_basis = g_temp_labor AND
1666: sel_po_agreed_amount <= 0
1667: )
1668: THEN INTO PON_INTERFACE_ERRORS
1669: (
1670: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1671: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1672: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1703: THEN INTO PON_INTERFACE_ERRORS

1699: g_document_type_names (p_doctype_id) <> PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION AND
1700: NVL (p_global_agreement_flag, g_invalid_string) <> 'Y'
1701: )
1702:
1703: THEN INTO PON_INTERFACE_ERRORS
1704: (
1705: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1706: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY, CREATION_DATE,
1707: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1736: THEN INTO PON_INTERFACE_ERRORS

1732: sel_order_type_lookup_code = g_fixed_price AND
1733: ABS (sel_unit_target_price * l_temp_fnd - TRUNC (sel_unit_target_price * l_temp_fnd)) > 0
1734: )
1735:
1736: THEN INTO PON_INTERFACE_ERRORS
1737: (
1738: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1739: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1740: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1773: THEN INTO PON_INTERFACE_ERRORS

1769: NVL (sel_order_type_lookup_code, g_invalid_string) <> g_fixed_price AND
1770: ABS (sel_unit_target_price * l_temp - TRUNC (sel_unit_target_price * l_temp)) > 0
1771: )
1772:
1773: THEN INTO PON_INTERFACE_ERRORS
1774: (
1775: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1776: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
1777: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 1818: THEN INTO PON_INTERFACE_ERRORS

1814: AUCTION_HEADER_ID = p_auction_header_id AND
1815: LINE_NUMBER = sel_line_number AND
1816: PRICING_BASIS = g_fixed_amount)
1817: )
1818: THEN INTO PON_INTERFACE_ERRORS
1819: (
1820: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
1821: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
1822: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

Line 1856: THEN INTO PON_INTERFACE_ERRORS

1852: NVL (sel_order_type_lookup_code, g_invalid_string) <> g_fixed_price AND
1853: NVL (sel_purchase_basis, g_invalid_string) <> g_temp_labor AND
1854: g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION
1855: )
1856: THEN INTO PON_INTERFACE_ERRORS
1857: (
1858: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
1859: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
1860: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

Line 1940: INSERT INTO PON_INTERFACE_ERRORS

1936: IF (l_allow_other_bid_currency = 'Y') THEN --{
1937:
1938: l_doctype_suffix := PON_LARGE_AUCTION_UTIL_PKG.GET_DOCTYPE_SUFFIX (p_auction_header_id);
1939:
1940: INSERT INTO PON_INTERFACE_ERRORS
1941: (
1942: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
1943: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY,
1944: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2019: THEN INTO PON_INTERFACE_ERRORS

2015: (
2016: sel_attribute_name IS NULL OR
2017: TRIM (sel_attribute_name) = ''
2018: )
2019: THEN INTO PON_INTERFACE_ERRORS
2020: (
2021: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
2022: LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2023: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2052: THEN INTO PON_INTERFACE_ERRORS

2048: sel_sequence_number > 0 and
2049: sel_value IS NULL AND
2050: sel_display_target_flag = 'Y'
2051: )
2052: THEN INTO PON_INTERFACE_ERRORS
2053: (
2054: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2055: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2056: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2083: THEN INTO PON_INTERFACE_ERRORS

2079: (
2080: sel_weight IS NOT NULL AND
2081: (sel_weight - sel_trunc_weight <> 0)
2082: )
2083: THEN INTO PON_INTERFACE_ERRORS
2084: (
2085: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2086: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2087: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,

Line 2119: THEN INTO PON_INTERFACE_ERRORS

2115: (
2116: sel_weight is not null AND
2117: sel_trunc_weight NOT BETWEEN 0 AND 100
2118: )
2119: THEN INTO PON_INTERFACE_ERRORS
2120: (
2121: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2122: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2123: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2150: THEN INTO PON_INTERFACE_ERRORS

2146: (
2147: sel_attr_max_score is not null AND
2148: (sel_attr_max_score - sel_trunc_attr_max_score <> 0)
2149: )
2150: THEN INTO PON_INTERFACE_ERRORS
2151: (
2152: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2153: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2154: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2181: THEN INTO PON_INTERFACE_ERRORS

2177: (
2178: sel_attr_max_score is not null AND
2179: (sel_trunc_attr_max_score < 0)
2180: )
2181: THEN INTO PON_INTERFACE_ERRORS
2182: (
2183: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2184: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, CREATED_BY,
2185: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2213: THEN INTO PON_INTERFACE_ERRORS

2209: sel_sequence_number = -20 AND
2210: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
2211: p_full_quantity_bid_code = 'FULL_QTY_BIDS_REQD'
2212: )
2213: THEN INTO PON_INTERFACE_ERRORS
2214: (
2215: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2216: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2217: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2247: THEN INTO PON_INTERFACE_ERRORS

2243: sel_weight > 0 AND
2244: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
2245: NVL (sel_scoring_type, 'NONE') = 'NONE'
2246: )
2247: THEN INTO PON_INTERFACE_ERRORS
2248: (
2249: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2250: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, TOKEN1_NAME,
2251: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 2285: THEN INTO PON_INTERFACE_ERRORS

2281: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
2282: (sel_weight IS NULL OR sel_weight <= 0) AND
2283: NVL (sel_scoring_type, 'NONE') <> 'NONE'
2284: )
2285: THEN INTO PON_INTERFACE_ERRORS
2286: (
2287: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2288: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE, TOKEN1_NAME,
2289: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 2366: INSERT INTO PON_INTERFACE_ERRORS

2362: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_ATTR_NAME_UNIQUE'
2363: || ', p_auction_header_id = ' || p_auction_header_id);
2364: END IF; --}
2365:
2366: INSERT INTO PON_INTERFACE_ERRORS
2367: (
2368: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2369: AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_NAME, EXPIRATION_DATE,
2370: TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 2436: THEN INTO PON_INTERFACE_ERRORS

2432: (
2433: SCORE is not null AND
2434: sel_trunc_score NOT BETWEEN 0 and 100
2435: )
2436: THEN INTO PON_INTERFACE_ERRORS
2437: (
2438: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID,
2439: ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE,
2440: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2466: THEN INTO PON_INTERFACE_ERRORS

2462: (
2463: SCORE is not null AND
2464: (SCORE - sel_trunc_score <>0)
2465: )
2466: THEN INTO PON_INTERFACE_ERRORS
2467: (
2468: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2469: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, CREATED_BY,
2470: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2564: THEN INTO PON_INTERFACE_ERRORS

2560: sel_effective_start_date IS NOT NULL AND
2561: sel_effective_end_date IS NOT NULL AND
2562: sel_effective_end_date < sel_effective_start_date
2563: )
2564: THEN INTO PON_INTERFACE_ERRORS
2565: (
2566: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2567: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
2568: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 2607: THEN INTO PON_INTERFACE_ERRORS

2603: NVL(L.SHIP_TO_SITE_FLAG,'N') = 'Y' AND
2604: L.LOCATION_ID = sel_ship_to_location_id AND
2605: nvl (L.INVENTORY_ORGANIZATION_ID, sel_ship_to_organization_id) = sel_ship_to_organization_id)
2606: )
2607: THEN INTO PON_INTERFACE_ERRORS
2608: (
2609: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2610: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2611: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2644: THEN INTO PON_INTERFACE_ERRORS

2640: sel_effective_start_date IS NULL AND
2641: sel_effective_end_date IS NULL AND
2642: sel_quantity IS NULL
2643: )
2644: THEN INTO PON_INTERFACE_ERRORS
2645: (
2646: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2647: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2648: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2678: THEN INTO PON_INTERFACE_ERRORS

2674: sel_quantity IS NOT NULL AND
2675: sel_quantity < 0 AND
2676: sel_quantity <> g_null_int
2677: )
2678: THEN INTO PON_INTERFACE_ERRORS
2679: (
2680: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2681: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2682: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2710: THEN INTO PON_INTERFACE_ERRORS

2706: WHEN
2707: (
2708: sel_price < 0
2709: )
2710: THEN INTO PON_INTERFACE_ERRORS
2711: (
2712: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2713: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2714: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2743: THEN INTO PON_INTERFACE_ERRORS

2739: (
2740: sel_effective_start_date IS NOT NULL AND
2741: sel_effective_start_date <= NVL (p_close_bidding_date, SYSDATE)
2742: )
2743: THEN INTO PON_INTERFACE_ERRORS
2744: (
2745: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2746: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2747: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2776: THEN INTO PON_INTERFACE_ERRORS

2772: (
2773: sel_effective_end_date IS NOT NULL AND
2774: sel_effective_end_date <= NVL (p_close_bidding_date, SYSDATE)
2775: )
2776: THEN INTO PON_INTERFACE_ERRORS
2777: (
2778: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2779: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2780: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2817: THEN INTO PON_INTERFACE_ERRORS

2813: PPD.LINE_NUMBER = sel_line_number AND
2814: PPD.SHIPMENT_NUMBER = sel_shipment_number
2815: )
2816: )
2817: THEN INTO PON_INTERFACE_ERRORS
2818: (
2819: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2820: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2821: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2857: THEN INTO PON_INTERFACE_ERRORS

2853: PPD.LINE_NUMBER = sel_line_number AND
2854: PPD.SHIPMENT_NUMBER = sel_shipment_number
2855: )
2856: )
2857: THEN INTO PON_INTERFACE_ERRORS
2858: (
2859: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2860: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2861: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2890: THEN INTO PON_INTERFACE_ERRORS

2886: (
2887: sel_price >= 0 AND
2888: ABS (sel_price * l_temp - TRUNC (sel_price * l_temp)) > 0
2889: )
2890: THEN INTO PON_INTERFACE_ERRORS
2891: (
2892: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
2893: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
2894: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2924: THEN INTO PON_INTERFACE_ERRORS

2920: p_po_start_date IS NOT NULL AND
2921: sel_effective_start_date IS NOT NULL AND
2922: sel_effective_start_date < p_po_start_date
2923: )
2924: THEN INTO PON_INTERFACE_ERRORS
2925: (
2926: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE,AUCTION_HEADER_ID, LINE_NUMBER,
2927: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,CREATION_DATE, LAST_UPDATED_BY,
2928: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2958: THEN INTO PON_INTERFACE_ERRORS

2954: p_po_start_date IS NOT NULL AND
2955: sel_effective_end_date IS NOT NULL AND
2956: sel_effective_end_date < p_po_start_date
2957: )
2958: THEN INTO PON_INTERFACE_ERRORS
2959: (
2960: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE,AUCTION_HEADER_ID, LINE_NUMBER,
2961: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,CREATION_DATE, LAST_UPDATED_BY,
2962: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 2992: THEN INTO PON_INTERFACE_ERRORS

2988: p_po_end_date IS NOT NULL AND
2989: sel_effective_start_date IS NOT NULL AND
2990: sel_effective_start_date > p_po_end_date
2991: )
2992: THEN INTO PON_INTERFACE_ERRORS
2993: (
2994: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
2995: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
2996: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3026: THEN INTO PON_INTERFACE_ERRORS

3022: p_po_end_date IS NOT NULL AND
3023: sel_effective_end_date IS NOT NULL AND
3024: sel_effective_end_date > p_po_end_date
3025: )
3026: THEN INTO PON_INTERFACE_ERRORS
3027: (
3028: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, batch_id, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3029: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3030: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3125: THEN INTO PON_INTERFACE_ERRORS

3121: sel_min_quantity IS NULL
3122: OR
3123: sel_min_quantity = g_null_int
3124: )
3125: THEN INTO PON_INTERFACE_ERRORS
3126: (
3127: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3128: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
3129: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 3161: THEN INTO PON_INTERFACE_ERRORS

3157: sel_max_quantity IS NULL
3158: OR
3159: sel_max_quantity = g_null_int
3160: )
3161: THEN INTO PON_INTERFACE_ERRORS
3162: (
3163: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3164: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3165: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3195: THEN INTO PON_INTERFACE_ERRORS

3191: (sel_min_quantity IS NOT NULL AND
3192: sel_min_quantity <= 0 AND
3193: sel_min_quantity <> g_null_int)
3194: )
3195: THEN INTO PON_INTERFACE_ERRORS
3196: (
3197: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3198: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3199: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3229: THEN INTO PON_INTERFACE_ERRORS

3225: (sel_max_quantity IS NOT NULL AND
3226: sel_max_quantity <= 0 AND
3227: sel_max_quantity <> g_null_int)
3228: )
3229: THEN INTO PON_INTERFACE_ERRORS
3230: (
3231: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3232: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3233: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3261: THEN INTO PON_INTERFACE_ERRORS

3257: WHEN
3258: (
3259: sel_min_quantity > sel_max_quantity
3260: )
3261: THEN INTO PON_INTERFACE_ERRORS
3262: (
3263: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3264: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3265: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3295: THEN INTO PON_INTERFACE_ERRORS

3291: sel_price <> g_null_int
3292: AND
3293: sel_price <= 0
3294: )
3295: THEN INTO PON_INTERFACE_ERRORS
3296: (
3297: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3298: SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3299: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3328: THEN INTO PON_INTERFACE_ERRORS

3324: (
3325: sel_price > 0 AND
3326: ABS (sel_price * l_temp - TRUNC (sel_price * l_temp)) > 0
3327: )
3328: THEN INTO PON_INTERFACE_ERRORS
3329: (
3330: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3331: AUCTION_HEADER_ID, LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME,
3332: TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3379: INSERT INTO PON_INTERFACE_ERRORS

3375: -- The ranges of min-max quantities should not overlap across tiers for a given line in a negotiation
3376: -- When this validation is performed at shipments level multiple error message were thrown for one particular line
3377: -- To avoid the multiple error messages this validation has to be performed at line level rather than shipments level.
3378:
3379: INSERT INTO PON_INTERFACE_ERRORS
3380: (
3381: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID, LINE_NUMBER,
3382: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
3383: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3437: INSERT INTO PON_INTERFACE_ERRORS

3433: END IF; --}
3434:
3435: -- For price differentials directly under the lines
3436:
3437: INSERT INTO PON_INTERFACE_ERRORS
3438: (
3439: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3440: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3441: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3477: INSERT INTO PON_INTERFACE_ERRORS

3473: COUNT(PPD.LINE_NUMBER) > 1;
3474:
3475: -- For price differentials under shipments
3476:
3477: INSERT INTO PON_INTERFACE_ERRORS
3478: (
3479: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3480: AUCTION_HEADER_ID, LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3481: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3560: THEN INTO PON_INTERFACE_ERRORS

3556: (
3557: sel_multiplier IS NULL OR
3558: sel_multiplier <= 0
3559: )
3560: THEN INTO PON_INTERFACE_ERRORS
3561: (
3562: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
3563: LINE_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3564: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 3596: THEN INTO PON_INTERFACE_ERRORS

3592: (
3593: sel_price_type = g_empty_price_type AND
3594: sel_multiplier IS NULL
3595: )
3596: THEN INTO PON_INTERFACE_ERRORS
3597: (
3598: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
3599: LINE_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
3600: TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3653: THEN INTO PON_INTERFACE_ERRORS

3649: (
3650: sel_multiplier IS NULL OR
3651: sel_multiplier <= 0
3652: )
3653: THEN INTO PON_INTERFACE_ERRORS
3654: (
3655: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
3656: LINE_NUMBER, SHIPMENT_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3657: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 3690: THEN INTO PON_INTERFACE_ERRORS

3686: (
3687: sel_price_type = g_empty_price_type AND
3688: sel_multiplier IS NULL
3689: )
3690: THEN INTO PON_INTERFACE_ERRORS
3691: (
3692: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
3693: LINE_NUMBER, SHIPMENT_NUMBER, PRICE_DIFFERENTIAL_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
3694: TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3803: THEN INTO PON_INTERFACE_ERRORS

3799: sel_value IS NOT NULL AND
3800: sel_price_element_type_id = g_item_price_type_id AND
3801: sel_value <= 0
3802: )
3803: THEN INTO PON_INTERFACE_ERRORS
3804: (
3805: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
3806: LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
3807: TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 3839: THEN INTO PON_INTERFACE_ERRORS

3835: sel_VALUE IS NOT NULL AND
3836: sel_PRICE_ELEMENT_TYPE_ID <> g_item_price_type_id AND
3837: sel_VALUE < 0
3838: )
3839: THEN INTO PON_INTERFACE_ERRORS
3840: (
3841: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
3842: LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3843: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 3875: THEN INTO PON_INTERFACE_ERRORS

3871: (
3872: sel_value IS NULL AND
3873: sel_display_target_flag = 'Y'
3874: )
3875: THEN INTO PON_INTERFACE_ERRORS
3876: (
3877: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
3878: LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3879: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,

Line 3914: THEN INTO PON_INTERFACE_ERRORS

3910: sel_pricing_basis = g_per_unit AND
3911: ABS (sel_value * l_temp - TRUNC (sel_value * l_temp))> 0
3912: )
3913:
3914: THEN INTO PON_INTERFACE_ERRORS
3915: (
3916: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3917: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
3918: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 3952: THEN INTO PON_INTERFACE_ERRORS

3948: sel_value IS NOT NULL AND
3949: sel_pricing_basis = g_fixed_amount AND
3950: ABS (sel_value * l_temp_fnd - TRUNC (sel_value * l_temp_fnd)) >0
3951: )
3952: THEN INTO PON_INTERFACE_ERRORS
3953: (
3954: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3955: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
3956: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 3987: THEN INTO PON_INTERFACE_ERRORS

3983: WHEN
3984: (
3985: sel_enabled_flag = 'N'
3986: )
3987: THEN INTO PON_INTERFACE_ERRORS
3988: (
3989: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
3990: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
3991: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 4023: THEN INTO PON_INTERFACE_ERRORS

4019: WHEN
4020: (
4021: sel_pricing_basis IS NULL
4022: )
4023: THEN INTO PON_INTERFACE_ERRORS
4024: (
4025: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4026: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4027: TOKEN1_NAME, TOKEN1_VALUE,

Line 4056: THEN INTO PON_INTERFACE_ERRORS

4052: WHEN
4053: (
4054: sel_name IS NULL
4055: )
4056: THEN INTO PON_INTERFACE_ERRORS
4057: (
4058: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4059: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4060: TOKEN1_NAME, TOKEN1_VALUE,

Line 4134: INSERT INTO PON_INTERFACE_ERRORS

4130: message => 'Entering PON_NEGOTIATION_HELPER_PVT.VAL_PE_UNIQUE'
4131: || ', p_auction_header_id = ' || p_auction_header_id);
4132: END IF; --}
4133:
4134: INSERT INTO PON_INTERFACE_ERRORS
4135: (
4136: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4137: AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, EXPIRATION_DATE,
4138: TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY,

Line 4219: INSERT INTO PON_INTERFACE_ERRORS

4215: WHERE
4216: auction_header_id = p_auction_header_id AND
4217: group_type IN ('LOT', 'GROUP', 'LINE');
4218:
4219: INSERT INTO PON_INTERFACE_ERRORS
4220: (
4221: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4222: AUCTION_HEADER_ID, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY,
4223: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4286: THEN INTO PON_INTERFACE_ERRORS

4282: NOT EXISTS (SELECT 'X'
4283: FROM PO_JOB_ASSOCIATIONS
4284: WHERE JOB_ID = SELECTED_JOB_ID)
4285: )
4286: THEN INTO PON_INTERFACE_ERRORS
4287: (
4288: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4289: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
4290: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4320: THEN INTO PON_INTERFACE_ERRORS

4316: NOT EXISTS (SELECT 'X'
4317: FROM PO_LINE_TYPES_B
4318: WHERE LINE_TYPE_ID = SELECTED_LINE_TYPE_ID)
4319: )
4320: THEN INTO PON_INTERFACE_ERRORS
4321: (
4322: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4323: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
4324: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4362: THEN INTO PON_INTERFACE_ERRORS

4358: AND NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999)
4359: AND MIC.CATEGORY_SET_ID = MDSV.CATEGORY_SET_ID
4360: AND MDSV.FUNCTIONAL_AREA_ID = 2)
4361: )
4362: THEN INTO PON_INTERFACE_ERRORS
4363: (
4364: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4365: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
4366: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4399: THEN INTO PON_INTERFACE_ERRORS

4395: FROM MTL_ITEM_REVISIONS
4396: WHERE REVISION = SELECTED_ITEM_REVISION AND
4397: INVENTORY_ITEM_ID = SELECTED_ITEM_ID)
4398: )
4399: THEN INTO PON_INTERFACE_ERRORS
4400: (
4401: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4402: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
4403: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4445: THEN INTO PON_INTERFACE_ERRORS

4441: FROM PO_LINE_TYPES_B PLT
4442: WHERE PLT.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID
4443: AND PLT.OUTSIDE_OPERATION_FLAG ='Y') ) ) )
4444: )
4445: THEN INTO PON_INTERFACE_ERRORS
4446: (
4447: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4448: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
4449: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4486: THEN INTO PON_INTERFACE_ERRORS

4482: MSI.PURCHASING_ENABLED_FLAG = 'Y' AND
4483: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND
4484: NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999))
4485: )
4486: THEN INTO PON_INTERFACE_ERRORS
4487: (
4488: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4489: LINE_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, CREATED_BY, CREATION_DATE,
4490: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4555: THEN INTO PON_INTERFACE_ERRORS

4551: MSI.INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID AND
4552: ((PLTB.OUTSIDE_OPERATION_FLAG = 'Y' AND
4553: MSI.OUTSIDE_OPERATION_FLAG = 'Y') OR PLTB.OUTSIDE_OPERATION_FLAG = 'N'))
4554: )
4555: THEN INTO PON_INTERFACE_ERRORS
4556: (
4557: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4558: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4559: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 4599: THEN INTO PON_INTERFACE_ERRORS

4595: LOC.SHIP_TO_SITE_FLAG = 'Y' AND
4596: (SELECTED_SHIP_TO_ORG_ID IS NULL OR
4597: 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))
4598: )
4599: THEN INTO PON_INTERFACE_ERRORS
4600: (
4601: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4602: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, TOKEN2_NAME,
4603: TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 4671: THEN INTO PON_INTERFACE_ERRORS

4667: MSI.PURCHASING_ENABLED_FLAG = 'Y' AND
4668: NVL(MSI.OUTSIDE_OPERATION_FLAG, 'N') =
4669: NVL(PLTB.OUTSIDE_OPERATION_FLAG, 'N'))
4670: )
4671: THEN INTO PON_INTERFACE_ERRORS
4672: (
4673: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4674: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4675: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 4714: THEN INTO PON_INTERFACE_ERRORS

4710: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
4711: FSP.ORG_ID = SELECTED_ORG_ID AND
4712: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) )
4713: )
4714: THEN INTO PON_INTERFACE_ERRORS
4715: (
4716: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE, AUCTION_HEADER_ID,
4717: LINE_NUMBER, SHIPMENT_NUMBER, EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
4718: TOKEN2_NAME, TOKEN2_VALUE, CREATED_BY, CREATION_DATE,

Line 4799: INSERT INTO PON_INTERFACE_ERRORS

4795: module => g_module_prefix || 'VAL_OUTSIDE_FLAG_EXISTS',
4796: message => 'This is a global agreement so validation for outside ops');
4797: END IF; --}
4798:
4799: INSERT INTO PON_INTERFACE_ERRORS
4800: (
4801: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
4802: AUCTION_HEADER_ID, EXPIRATION_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
4803: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 4880: INTO pon_interface_errors

4876: INSERT ALL
4877: WHEN NOT ((order_type_lookup_code = 'FIXED PRICE' AND purchase_basis = 'SERVICES') OR
4878: (order_type_lookup_code = 'QUANTITY' AND purchase_basis = 'GOODS'))
4879: OR po_outside_operation_flag = 'Y' THEN
4880: INTO pon_interface_errors
4881: (
4882: interface_type, error_message_name, batch_id, -- 1
4883: entity_type, auction_header_id, line_number, -- 2
4884: token1_name, token1_value, expiration_date, -- 3

Line 4913: INTO pon_interface_errors

4909: ELSIF l_contract_type = 'STANDARD' THEN
4910:
4911: INSERT ALL
4912: WHEN retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
4913: INTO pon_interface_errors
4914: (
4915: interface_type, error_message_name, batch_id, -- 2
4916: entity_type, auction_header_id, line_number, -- 3
4917: token1_name, token1_value, expiration_date, -- 4

Line 4931: INTO pon_interface_errors

4927: SYSDATE, p_login_id, p_request_id -- 6
4928: )
4929:
4930: WHEN max_retainage_amount IS NOT NULL AND max_retainage_amount < 0 THEN
4931: INTO pon_interface_errors
4932: (
4933: interface_type, error_message_name, batch_id, -- 2
4934: entity_type, auction_header_id, line_number, -- 3
4935: token1_name, token1_value, expiration_date, -- 4

Line 4949: INTO pon_interface_errors

4945: SYSDATE, p_login_id, p_request_id -- 6
4946: )
4947:
4948: WHEN advance_amount IS NOT NULL AND advance_amount < 0 THEN
4949: INTO pon_interface_errors
4950: (
4951: interface_type, error_message_name, batch_id, -- 2
4952: entity_type, auction_header_id, line_number, -- 3
4953: token1_name, token1_value, expiration_date, -- 4

Line 4967: INTO pon_interface_errors

4963: SYSDATE, p_login_id, p_request_id -- 6
4964: )
4965:
4966: WHEN progress_pymt_rate_percent IS NOT NULL AND (progress_pymt_rate_percent < 0 OR progress_pymt_rate_percent > 100) then
4967: INTO pon_interface_errors
4968: (
4969: interface_type, error_message_name, batch_id, -- 2
4970: entity_type, auction_header_id, line_number, -- 3
4971: token1_name, token1_value, expiration_date, -- 4

Line 4984: INTO pon_interface_errors

4980: p_user_id, SYSDATE, p_user_id, -- 5
4981: SYSDATE, p_login_id, p_request_id -- 6
4982: )
4983: WHEN recoupment_rate_percent IS NOT NULL AND (recoupment_rate_percent < 0 OR recoupment_rate_percent > 100) THEN
4984: INTO pon_interface_errors
4985: (
4986: interface_type, error_message_name, batch_id, -- 2
4987: entity_type, auction_header_id, line_number, -- 3
4988: token1_name, token1_value, expiration_date, -- 4

Line 5003: INTO pon_interface_errors

4999: )
5000:
5001: WHEN progress_pymt_rate_percent IS NOT NULL AND
5002: PON_BID_VALIDATIONS_PKG.validate_currency_precision(progress_pymt_rate_percent, 2) = 'F' THEN
5003: INTO pon_interface_errors
5004: (
5005: interface_type, error_message_name, batch_id, -- 2
5006: entity_type, auction_header_id, line_number, -- 3
5007: token1_name, token1_value, expiration_date, -- 4

Line 5024: INTO pon_interface_errors

5020: )
5021:
5022: WHEN recoupment_rate_percent IS NOT NULL AND
5023: PON_BID_VALIDATIONS_PKG.validate_currency_precision(recoupment_rate_percent, 2) = 'F' THEN
5024: INTO pon_interface_errors
5025: (
5026: interface_type, error_message_name, batch_id, -- 2
5027: entity_type, auction_header_id, line_number, -- 3
5028: token1_name, token1_value, expiration_date, -- 4

Line 5045: INTO pon_interface_errors

5041: )
5042:
5043: WHEN retainage_rate_percent IS NOT NULL AND
5044: PON_BID_VALIDATIONS_PKG.validate_currency_precision(retainage_rate_percent, 2) = 'F' THEN
5045: INTO pon_interface_errors
5046: (
5047: interface_type, error_message_name, batch_id, -- 2
5048: entity_type, auction_header_id, line_number, -- 3
5049: token1_name, token1_value, expiration_date, -- 4

Line 5066: INTO pon_interface_errors

5062: )
5063:
5064: WHEN advance_amount IS NOT NULL AND
5065: PON_BID_VALIDATIONS_PKG.validate_currency_precision(advance_amount, p_fnd_currency_precision) = 'F' THEN
5066: INTO pon_interface_errors
5067: (
5068: interface_type, error_message_name, batch_id, -- 2
5069: entity_type, auction_header_id, line_number, -- 3
5070: token1_name, token1_value, expiration_date, -- 4

Line 5087: INTO pon_interface_errors

5083: )
5084:
5085: WHEN max_retainage_amount IS NOT NULL AND
5086: PON_BID_VALIDATIONS_PKG.validate_currency_precision(max_retainage_amount, p_fnd_currency_precision) = 'F' THEN
5087: INTO pon_interface_errors
5088: (
5089: interface_type, error_message_name, batch_id, -- 2
5090: entity_type, auction_header_id, line_number, -- 3
5091: token1_name, token1_value, expiration_date, -- 4

Line 5107: INTO pon_interface_errors

5103: 'LINENUM', document_disp_line_number
5104: )
5105:
5106: WHEN l_progress_payment_type = 'FINANCE' AND progress_pymt_rate_percent IS NULL THEN
5107: INTO pon_interface_errors
5108: (
5109: interface_type, error_message_name, batch_id, -- 2
5110: entity_type, auction_header_id, line_number, -- 3
5111: token1_name, token1_value, expiration_date, -- 4

Line 5129: INTO pon_interface_errors

5125: (po_outside_operation_flag = 'Y' OR
5126: NOT ((order_type_lookup_code = 'FIXED PRICE' AND purchase_basis = 'SERVICES') OR
5127: (order_type_lookup_code = 'QUANTITY' AND purchase_basis = 'GOODS'))
5128: )) THEN
5129: INTO pon_interface_errors
5130: (
5131: interface_type, error_message_name, batch_id, -- 2
5132: entity_type, auction_header_id, line_number, -- 3
5133: token1_name, token1_value, expiration_date, -- 4

Line 5149: INTO pon_interface_errors

5145:
5146: WHEN progress_pymt_rate_percent IS NOT NULL AND
5147: recoupment_rate_percent IS NULL AND
5148: l_recoupment_negotiable_flag = 'N' THEN
5149: INTO pon_interface_errors
5150: (
5151: interface_type, error_message_name, batch_id, -- 2
5152: entity_type, auction_header_id, line_number, -- 3
5153: token1_name, token1_value, expiration_date, -- 4

Line 5168: INTO pon_interface_errors

5164: )
5165:
5166: WHEN ((advance_amount IS NOT NULL or l_advance_negotiable_flag = 'Y') AND
5167: (recoupment_rate_percent IS NULL AND l_recoupment_negotiable_flag = 'N')) THEN
5168: INTO pon_interface_errors
5169: (
5170: interface_type, error_message_name, batch_id, -- 2
5171: entity_type, auction_header_id, line_number, -- 3
5172: token1_name, token1_value, expiration_date, -- 4

Line 5187: INTO pon_interface_errors

5183: )
5184:
5185: WHEN target_price IS NOT NULL AND advance_amount IS NOT NULL
5186: AND (advance_amount > nvl(s_quantity,1) * target_price) THEN
5187: INTO pon_interface_errors
5188: (
5189: interface_type, error_message_name, batch_id, -- 2
5190: entity_type, auction_header_id, line_number, -- 3
5191: token1_name, token1_value, expiration_date, -- 4

Line 5208: INTO pon_interface_errors

5204: WHEN l_progress_payment_type = 'ACTUAL' AND recoupment_rate_percent IS NOT NULL
5205: AND target_price IS NOT NULL
5206: AND advance_amount IS NOT NULL
5207: AND (recoupment_rate_percent < (advance_amount * 100)/(nvl(s_quantity,1) * target_price)) THEN
5208: INTO pon_interface_errors
5209: (
5210: interface_type, error_message_name, batch_id, -- 2
5211: entity_type, auction_header_id, line_number, -- 3
5212: token1_name, token1_value, expiration_date, -- 4

Line 5232: INTO pon_interface_errors

5228: FROM PON_AUC_PAYMENTS_SHIPMENTS p_aps
5229: WHERE p_aps.auction_header_id=p_auction_header_id
5230: AND p_aps.line_number=s_line_number ))
5231: + NVL(advance_amount,0)) * 100)/((nvl(s_quantity, 1) * target_price))) THEN
5232: INTO pon_interface_errors
5233: (
5234: interface_type, error_message_name, batch_id, -- 2
5235: entity_type, auction_header_id, line_number, -- 3
5236: token1_name, token1_value, expiration_date, -- 4

Line 5253: INTO pon_interface_errors

5249: WHEN (pai_project_id IS NOT NULL OR pai_project_task_id IS NOT NULL OR pai_project_exp_org_id IS NOT NULL
5250: OR pai_project_exp_item_date IS NOT NULL OR pai_project_exp_type IS NOT NULL)
5251: AND (pai_project_id IS NULL OR pai_project_task_id IS NULL OR pai_project_exp_org_id IS NULL
5252: OR pai_project_exp_item_date IS NULL OR pai_project_exp_type IS NULL) THEN
5253: INTO pon_interface_errors
5254: (
5255: interface_type, error_message_name, batch_id, -- 2
5256: entity_type, auction_header_id, line_number, -- 3
5257: token1_name, token1_value, expiration_date, -- 4

Line 5310: INTO pon_interface_errors

5306: WHERE fu.user_id = work_approver_user_id
5307: AND fu.employee_id = peo.person_id
5308: AND SYSDATE >= nvl(fu.start_date, SYSDATE)
5309: AND SYSDATE <= nvl(fu.end_date, SYSDATE) ) THEN
5310: INTO pon_interface_errors
5311: (
5312: interface_type, error_message_name, batch_id, -- 2
5313: entity_type, auction_header_id, line_number, -- 3
5314: token1_name, token1_value, expiration_date, -- 4

Line 5343: INTO pon_interface_errors

5339: WHEN pai_project_id IS NOT NULL
5340: AND NOT EXISTS(SELECT 1
5341: FROM pa_projects_expend_v pro
5342: WHERE pro.project_id = pai_project_id) THEN
5343: INTO pon_interface_errors
5344: (
5345: interface_type, error_message_name, batch_id, -- 2
5346: entity_type, auction_header_id, line_number, -- 3
5347: token1_name, token1_value, expiration_date, -- 4

Line 5365: INTO pon_interface_errors

5361: AND NOT EXISTS(SELECT 1
5362: FROM pa_tasks_expend_v tas
5363: WHERE tas.project_id = pai_project_id
5364: AND tas.task_id = pai_project_task_id) THEN
5365: INTO pon_interface_errors
5366: (
5367: interface_type, error_message_name, batch_id, -- 2
5368: entity_type, auction_header_id, line_number, -- 3
5369: token1_name, token1_value, expiration_date, -- 4

Line 5390: INTO pon_interface_errors

5386: FROM GMS_AWARDS_BASIC_V award
5387: WHERE award.project_id = pai_project_id
5388: AND award.task_id = pai_project_task_id
5389: AND award.award_id = pai_project_award_id) THEN
5390: INTO pon_interface_errors
5391: (
5392: interface_type, error_message_name, batch_id, -- 2
5393: entity_type, auction_header_id, line_number, -- 3
5394: token1_name, token1_value, expiration_date, -- 4

Line 5412: INTO pon_interface_errors

5408: AND NOT EXISTS (SELECT 1
5409: FROM PA_ORGANIZATIONS_EXPEND_V porg
5410: WHERE porg.organization_id = pai_project_exp_org_id) THEN
5411:
5412: INTO pon_interface_errors
5413: (
5414: interface_type, error_message_name, batch_id, -- 2
5415: entity_type, auction_header_id, line_number, -- 3
5416: token1_name, token1_value, expiration_date, -- 4

Line 5438: INTO pon_interface_errors

5434: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
5435: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))
5436: AND trunc(sysdate) BETWEEN nvl(exptype.sys_link_start_date_active, trunc(sysdate))
5437: AND nvl(exptype.sys_link_end_date_Active, trunc(sysdate))) THEN
5438: INTO pon_interface_errors
5439: (
5440: interface_type, error_message_name, batch_id, -- 2
5441: entity_type, auction_header_id, line_number, -- 3
5442: token1_name, token1_value, expiration_date, -- 4

Line 5458: INTO pon_interface_errors

5454:
5455: WHEN pai_project_id IS NOT NULL
5456: AND pai_project_award_id IS NULL
5457: AND IS_PROJECT_SPONSORED(pai_project_id) = 'Y' THEN
5458: INTO pon_interface_errors
5459: (
5460: interface_type, error_message_name, batch_id, -- 2
5461: entity_type, auction_header_id, line_number, -- 3
5462: token1_name, token1_value, expiration_date, -- 4

Line 5518: INSERT INTO PON_INTERFACE_ERRORS

5514: END LOOP;
5515:
5516: BEGIN
5517:
5518: INSERT INTO PON_INTERFACE_ERRORS
5519: (
5520: interface_type,
5521: error_message_name,
5522: batch_id,

Line 5626: INTO pon_interface_errors

5622: END IF; --}
5623:
5624: INSERT ALL
5625: WHEN payment_display_number < 1 OR payment_display_number<> ROUND(payment_display_number) THEN
5626: INTO pon_interface_errors
5627: (
5628: column_name, entity_attr_name, error_message_name, -- 1
5629: error_value_datatype, error_value_number, error_value_date, -- 2
5630: token1_name, token1_value, token2_name, -- 3

Line 5649: INTO pon_interface_errors

5645: p_expiration_date, p_user_id, SYSDATE, -- 7
5646: p_user_id, SYSDATE, p_login_id -- 8
5647: )
5648: WHEN payment_type_code = 'RATE' AND quantity < 0 THEN
5649: INTO pon_interface_errors
5650: (
5651: column_name, entity_attr_name, error_message_name, -- 1
5652: error_value_datatype, error_value_number, error_value_date, -- 2
5653: token1_name, token1_value, token2_name, -- 3

Line 5672: INTO pon_interface_errors

5668: p_expiration_date, p_user_id, SYSDATE, -- 7
5669: p_user_id, SYSDATE, p_login_id -- 8
5670: )
5671: WHEN target_price IS NOT NULL AND target_price < 0 THEN
5672: INTO pon_interface_errors
5673: (
5674: column_name, entity_attr_name, error_message_name, -- 1
5675: error_value_datatype, error_value_number, error_value_date, -- 2
5676: token1_name, token1_value, token2_name, -- 3

Line 5696: INTO pon_interface_errors

5692: p_user_id, SYSDATE, p_login_id -- 8
5693: )
5694: WHEN target_price IS NOT NULL
5695: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(target_price, p_price_precision) = 'F' THEN
5696: INTO pon_interface_errors
5697: (
5698: column_name, entity_attr_name, error_message_name, -- 1
5699: error_value_datatype, error_value_number, error_value_date, -- 2
5700: token1_name, token1_value, token2_name, -- 3

Line 5719: INTO pon_interface_errors

5715: p_expiration_date, p_user_id, SYSDATE, -- 7
5716: p_user_id, SYSDATE, p_login_id -- 8
5717: )
5718: WHEN payment_display_number IS NULL THEN
5719: INTO pon_interface_errors
5720: (
5721: column_name, entity_attr_name, error_message_name, -- 1
5722: error_value_datatype, error_value_number, error_value_date, -- 2
5723: token1_name, token1_value, token2_name, -- 3

Line 5742: INTO pon_interface_errors

5738: p_expiration_date, p_user_id, SYSDATE, -- 7
5739: p_user_id, SYSDATE, p_login_id -- 8
5740: )
5741: WHEN payment_type_code IS NULL THEN
5742: INTO pon_interface_errors
5743: (
5744: column_name, entity_attr_name, error_message_name, -- 1
5745: error_value_datatype, error_value, error_value_date, -- 2
5746: token1_name, token1_value, token2_name, -- 3

Line 5765: INTO pon_interface_errors

5761: p_expiration_date, p_user_id, SYSDATE, -- 7
5762: p_user_id, SYSDATE, p_login_id -- 8
5763: )
5764: WHEN payment_description IS NULL THEN
5765: INTO pon_interface_errors
5766: (
5767: column_name, entity_attr_name, error_message_name, -- 1
5768: error_value_datatype, error_value, error_value_date, -- 2
5769: token1_name, token1_value, token2_name, -- 3

Line 5788: INTO pon_interface_errors

5784: p_expiration_date, p_user_id, SYSDATE, -- 7
5785: p_user_id, SYSDATE, p_login_id -- 8
5786: )
5787: WHEN payment_type_code = 'RATE' AND quantity IS NULL THEN
5788: INTO pon_interface_errors
5789: (
5790: column_name, entity_attr_name, error_message_name, -- 1
5791: error_value_datatype, error_value_number, error_value_date, -- 2
5792: token1_name, token1_value, token2_name, -- 3

Line 5811: INTO pon_interface_errors

5807: p_expiration_date, p_user_id, SYSDATE, -- 7
5808: p_user_id, SYSDATE, p_login_id -- 8
5809: )
5810: WHEN payment_type_code = 'RATE' AND uom_code IS NULL THEN
5811: INTO pon_interface_errors
5812: (
5813: column_name, entity_attr_name, error_message_name, -- 1
5814: error_value_datatype, error_value, error_value_date, -- 2
5815: token1_name, token1_value, token2_name, -- 3

Line 5834: INTO pon_interface_errors

5830: p_expiration_date, p_user_id, SYSDATE, -- 7
5831: p_user_id, SYSDATE, p_login_id -- 8
5832: )
5833: WHEN nvl(supplier_enterable_pymt_flag,'N') = 'N' AND ship_to_location_id IS NULL THEN
5834: INTO pon_interface_errors
5835: (
5836: column_name, entity_attr_name, error_message_name, -- 1
5837: error_value_datatype, error_value, error_value_date, -- 2
5838: token1_name, token1_value, token2_name, -- 3

Line 5857: INTO pon_interface_errors

5853: p_expiration_date, p_user_id, SYSDATE, -- 7
5854: p_user_id, SYSDATE, p_login_id -- 8
5855: )
5856: WHEN need_by_date IS NOT NULL AND need_by_date <= pah_close_bidding_date THEN
5857: INTO pon_interface_errors
5858: (
5859: column_name, entity_attr_name, error_message_name, -- 1
5860: error_value_datatype, error_value_number, error_value_date, -- 2
5861: token1_name, token1_value, token2_name, -- 3

Line 5887: INTO pon_interface_errors

5883: WHERE fu.user_id = work_approver_user_id
5884: AND fu.employee_id = peo.person_id
5885: AND SYSDATE >= nvl(fu.start_date, SYSDATE)
5886: AND SYSDATE <= nvl(fu.end_date, SYSDATE) ) THEN
5887: INTO pon_interface_errors
5888: (
5889: column_name, entity_attr_name, error_message_name, -- 1
5890: error_value_datatype, error_value_number, error_value_date, -- 2
5891: token1_name, token1_value, token2_name, -- 3

Line 5913: INTO pon_interface_errors

5909: WHEN (s_project_id IS NOT NULL OR s_project_task_id IS NOT NULL OR s_project_exp_org_id IS NOT NULL
5910: OR s_project_exp_item_date IS NOT NULL OR s_project_exp_type IS NOT NULL)
5911: AND (s_project_id IS NULL OR s_project_task_id IS NULL OR s_project_exp_org_id IS NULL
5912: OR s_project_exp_item_date IS NULL OR s_project_exp_type IS NULL) THEN
5913: INTO pon_interface_errors
5914: (
5915: column_name, entity_attr_name, error_message_name, -- 1
5916: error_value_datatype, error_value, error_value_date, -- 2
5917: token1_name, token1_value, token2_name, -- 3

Line 5971: INTO pon_interface_errors

5967: WHEN s_project_id IS NOT NULL
5968: AND NOT EXISTS(SELECT 1
5969: FROM pa_projects_expend_v pro
5970: WHERE pro.project_id = s_project_id) THEN
5971: INTO pon_interface_errors
5972: (
5973: column_name, entity_attr_name, error_message_name, -- 1
5974: error_value_datatype, error_value_number, error_value_date, -- 2
5975: token1_name, token1_value, token2_name, -- 3

Line 5998: INTO pon_interface_errors

5994: AND NOT EXISTS(SELECT 1
5995: FROM pa_tasks_expend_v tas
5996: WHERE tas.project_id = s_project_id
5997: AND tas.task_id = s_project_task_id) THEN
5998: INTO pon_interface_errors
5999: (
6000: column_name, entity_attr_name, error_message_name, -- 1
6001: error_value_datatype, error_value_number, error_value_date, -- 2
6002: token1_name, token1_value, token2_name, -- 3

Line 6028: INTO pon_interface_errors

6024: FROM GMS_AWARDS_BASIC_V award
6025: WHERE award.project_id = s_project_id
6026: AND award.task_id = s_project_task_id
6027: AND award.award_id = s_project_award_id) THEN
6028: INTO pon_interface_errors
6029: (
6030: column_name, entity_attr_name, error_message_name, -- 1
6031: error_value_datatype, error_value_number, error_value_date, -- 2
6032: token1_name, token1_value, token2_name, -- 3

Line 6053: INTO pon_interface_errors

6049: )
6050: WHEN s_project_id IS NOT NULL
6051: AND s_project_award_id IS NULL
6052: AND IS_PROJECT_SPONSORED(s_project_id) = 'Y' THEN
6053: INTO pon_interface_errors
6054: (
6055: column_name, entity_attr_name, error_message_name, -- 1
6056: error_value_datatype, error_value_number, error_value_date, -- 2
6057: token1_name, token1_value, token2_name, -- 3

Line 6079: INTO pon_interface_errors

6075: WHEN s_project_exp_org_id IS NOT NULL
6076: AND NOT EXISTS (SELECT 1
6077: FROM PA_ORGANIZATIONS_EXPEND_V porg
6078: WHERE porg.organization_id = s_project_exp_org_id) THEN
6079: INTO pon_interface_errors
6080: (
6081: column_name, entity_attr_name, error_message_name, -- 1
6082: error_value_datatype, error_value_number, error_value_date, -- 2
6083: token1_name, token1_value, token2_name, -- 3

Line 6110: INTO pon_interface_errors

6106: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
6107: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))
6108: AND trunc(sysdate) BETWEEN nvl(exptype.sys_link_start_date_active, trunc(sysdate))
6109: AND nvl(exptype.sys_link_end_date_Active, trunc(sysdate))) THEN
6110: INTO pon_interface_errors
6111: (
6112: column_name, entity_attr_name, error_message_name, -- 1
6113: error_value_datatype, error_value, error_value_date, -- 2
6114: token1_name, token1_value, token2_name, -- 3

Line 6737: INSERT INTO PON_INTERFACE_ERRORS

6733: p_user_id IN NUMBER
6734: ) IS
6735: BEGIN
6736:
6737: INSERT INTO PON_INTERFACE_ERRORS
6738: (
6739: INTERFACE_TYPE,
6740: ERROR_MESSAGE_NAME,
6741: TOKEN1_NAME,

Line 6791: PON_INTERFACE_ERRORS

6787: BATCH_ID
6788: INTO
6789: l_batch_id
6790: FROM
6791: PON_INTERFACE_ERRORS
6792: WHERE
6793: BATCH_ID = p_batch_id AND
6794: ROWNUM =1;
6795:

Line 6922: PON_INTERFACE_ERRORS

6918: l_token5_value,
6919: l_payment_id,
6920: l_bid_payment_id
6921: FROM
6922: PON_INTERFACE_ERRORS
6923: WHERE
6924: BATCH_ID = p_batch_id;
6925:
6926: ROLLBACK;

Line 6929: INSERT INTO PON_INTERFACE_ERRORS

6925:
6926: ROLLBACK;
6927:
6928: FORALL x IN 1..l_interface_type.COUNT
6929: INSERT INTO PON_INTERFACE_ERRORS
6930: (
6931: INTERFACE_TYPE,
6932: COLUMN_NAME,
6933: TABLE_NAME,

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

8262: ELSE
8263: l_error_message_name := 'PON_NEG_APPROVE_FATAL_ERROR';
8264: END IF;
8265:
8266: -- insert an error row into the pon_interface_errors table
8267: LOG_INTERFACE_ERROR (
8268: p_interface_type => g_interface_type,
8269: p_error_message_name => l_error_message_name,
8270: p_token1_name => 'DOC_NUM',

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

8607:
8608: RETCODE := 2;
8609: ERRBUF := 'PON_NO_DRAFT_LOCK';
8610:
8611: --Log this error in the PON_INTERFACE_ERRORS TABLE
8612:
8613: LOG_INTERFACE_ERROR (
8614: p_interface_type => g_interface_type,
8615: p_error_message_name => 'PON_NO_DRAFT_LOCK',