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.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_R12_CAT_UPG_UTL

Line 137: PO_R12_CAT_UPG_UTL.add_fatal_error(

133: LOOP
134: IF (l_err_org_ids(i) = g_OU_REQD) THEN
135: -- ICX_CAT_ALL_BUYERS_DEPRECATED:
136: -- "Provide an Operating Unit. 'All Buyers' has been deprecated."
137: PO_R12_CAT_UPG_UTL.add_fatal_error(
138: p_interface_header_id => l_err_interface_header_ids(i),
139: --p_error_message_name => 'PO_R12_CAT_UPG_OU_REQD',
140: p_error_message_name => 'ICX_CAT_ALL_BUYERS_DEPRECATED',
141: p_table_name => 'PO_HEADERS_INTERFACE',

Line 148: PO_R12_CAT_UPG_UTL.add_fatal_error(

144: );
145: ELSE -- if org_id is NULL or if ID does not exist in table.
146: -- ICX_CAT_OU_REQD:
147: -- "Operating unit is missing."
148: PO_R12_CAT_UPG_UTL.add_fatal_error(
149: p_interface_header_id => l_err_interface_header_ids(i),
150: p_error_message_name => 'ICX_CAT_OU_REQD',
151: p_table_name => 'PO_HEADERS_INTERFACE',
152: p_column_name => 'ORG_ID',

Line 161: PO_R12_CAT_UPG_UTL.reject_headers_intf('INTERFACE_HEADER_ID', l_err_interface_header_ids, 'Y');

157: l_progress := '080';
158: -- Cascade errors down to lower levels
159: -- Skip cascading of errors in Validate Only mode (iP Requirement - all errors should be reported)
160: IF (p_validate_only_mode <> FND_API.G_TRUE) THEN
161: PO_R12_CAT_UPG_UTL.reject_headers_intf('INTERFACE_HEADER_ID', l_err_interface_header_ids, 'Y');
162: END IF;
163: END LOOP;
164: -- ECO bug 5584556: End
165:

Line 239: PO_R12_CAT_UPG_UTL.add_fatal_error(

235: -- ECO bug 5584556: End
236:
237: -- ICX_CAT_INVALID_OU:
238: -- "Operating Unit (VALUE) is invalid or inactive."
239: PO_R12_CAT_UPG_UTL.add_fatal_error(
240: p_interface_header_id => l_err_interface_header_ids(i),
241: --p_error_message_name => 'PO_R12_CAT_UPG_INVALID_OU',
242: p_error_message_name => 'ICX_CAT_INVALID_OU',
243: p_table_name => 'PO_HEADERS_INTERFACE',

Line 254: PO_R12_CAT_UPG_UTL.reject_headers_intf('INTERFACE_HEADER_ID', l_err_interface_header_ids, 'Y');

250: l_progress := '110';
251: -- Cascade errors down to lower levels
252: -- Skip cascading of errors in Validate Only mode (iP Requirement - all errors should be reported)
253: IF (p_validate_only_mode <> FND_API.G_TRUE) THEN
254: PO_R12_CAT_UPG_UTL.reject_headers_intf('INTERFACE_HEADER_ID', l_err_interface_header_ids, 'Y');
255: END IF;
256: END LOOP;
257:
258: l_progress := '120';

Line 348: PO_R12_CAT_UPG_UTL.add_fatal_error(

344:
345: -- Add error message into INTERFACE_ERRORS table
346: -- PO_PDOI_INVALID_START_DATE:
347: -- "Effective Date (VALUE =VALUE) specified should be less than the end date specified."
348: PO_R12_CAT_UPG_UTL.add_fatal_error(
349: p_interface_header_id => p_headers_rec.interface_header_id(i),
350: p_error_message_name => 'PO_PDOI_INVALID_START_DATE',
351: p_table_name => 'PO_HEADERS_INTERFACE',
352: p_column_name => 'EXPIRATION_DATE',

Line 415: PO_R12_CAT_UPG_UTL.add_fatal_error(

411:
412: -- Add error message into INTERFACE_ERRORS table
413: -- ICX_CAT_BUYER_REQD:
414: -- "The system cannot obtain the default value for the buyer."
415: PO_R12_CAT_UPG_UTL.add_fatal_error(
416: p_interface_header_id => p_headers_rec.interface_header_id(i),
417: p_error_message_name => 'ICX_CAT_BUYER_REQD', -- ECO bug 5584556: changed from ICX_CAT_NO_BUYER
418: p_table_name => 'PO_HEADERS_INTERFACE',
419: p_column_name => 'AGENT_ID',

Line 481: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.currency_code.COUNT);

477: BEGIN
478: l_progress := '010';
479: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
480:
481: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.currency_code.COUNT);
482:
483: IF (p_headers_rec.currency_code.COUNT > 0) THEN
484: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.currency_code(1)='||p_headers_rec.currency_code(1)); END IF;
485: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 499: PO_R12_CAT_UPG_UTL.add_fatal_error(

495:
496: -- Add error message into INTERFACE_ERRORS table
497: -- ICX_CAT_CURRENCY_REQD:
498: -- "Currency code is missing."
499: PO_R12_CAT_UPG_UTL.add_fatal_error(
500: p_interface_header_id => l_interface_header_ids(i),
501: p_error_message_name => 'ICX_CAT_CURRENCY_REQD',
502: p_table_name => 'PO_HEADERS_INTERFACE',
503: p_column_name => 'CURRENCY_CODE',

Line 563: PO_R12_CAT_UPG_UTL.add_fatal_error(

559:
560: -- Add error message into INTERFACE_ERRORS table
561: -- ICX_CAT_INVALID_CURRENCY:
562: -- "Currency code (VALUE) is inactive or invalid."
563: PO_R12_CAT_UPG_UTL.add_fatal_error(
564: p_interface_header_id => l_interface_header_ids(i),
565: --p_error_message_name => 'PO_PDOI_INVALID_CURRENCY',
566: p_error_message_name => 'ICX_CAT_INVALID_CURRENCY',
567: p_table_name => 'PO_HEADERS_INTERFACE',

Line 650: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_id.COUNT);

646: BEGIN
647: l_progress := '010';
648: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
649:
650: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_id.COUNT);
651:
652: ----------------------------------------------------------------------------
653: -- Validate vendor_id
654: ----------------------------------------------------------------------------

Line 708: PO_R12_CAT_UPG_UTL.add_fatal_error(

704:
705: -- Add error message into INTERFACE_ERRORS table
706: -- ICX_CAT_SUPPLIER_REQD:
707: -- "Supplier is missing."
708: PO_R12_CAT_UPG_UTL.add_fatal_error(
709: p_interface_header_id => l_interface_header_ids(i),
710: p_error_message_name => 'ICX_CAT_SUPPLIER_REQD',
711: p_table_name => 'PO_HEADERS_INTERFACE',
712: p_column_name => 'VENDOR_ID',

Line 775: PO_R12_CAT_UPG_UTL.add_fatal_error(

771:
772: -- Add error message into INTERFACE_ERRORS table
773: -- ICX_CAT_INVALID_SUPPLIER:
774: -- "Supplier (VALUE) is inactive or invalid."
775: PO_R12_CAT_UPG_UTL.add_fatal_error(
776: p_interface_header_id => l_interface_header_ids(i),
777: --p_error_message_name => 'PO_PDOI_INVALID_VENDOR',
778: p_error_message_name => 'ICX_CAT_INVALID_SUPPLIER',
779: p_table_name => 'PO_HEADERS_INTERFACE',

Line 857: PO_R12_CAT_UPG_UTL.add_fatal_error(

853:
854: -- Add error message into INTERFACE_ERRORS table
855: -- ICX_CAT_SUPPLIER_SITE_REQD:
856: -- "Supplier site is missing."
857: PO_R12_CAT_UPG_UTL.add_fatal_error(
858: p_interface_header_id => l_interface_header_ids(i),
859: p_error_message_name => 'ICX_CAT_SUPPLIER_SITE_REQD',
860: p_table_name => 'PO_HEADERS_INTERFACE',
861: p_column_name => 'VENDOR_SITE_ID',

Line 925: PO_R12_CAT_UPG_UTL.add_fatal_error(

921:
922: -- Add error message into INTERFACE_ERRORS table
923: -- ICX_CAT_INVALID_SUPPLIER_SITE:
924: -- "Supplier site (VALUE) is not an active and valid purchasing supplier site."
925: PO_R12_CAT_UPG_UTL.add_fatal_error(
926: p_interface_header_id => l_interface_header_ids(i),
927: --p_error_message_name => 'PO_INVALID_VENDOR_SITE_ID',
928: p_error_message_name => 'ICX_CAT_INVALID_SUPPLIER_SITE',
929: p_table_name => 'PO_HEADERS_INTERFACE',

Line 992: --PO_R12_CAT_UPG_UTL.add_fatal_error(

988:
989: -- Add error message into INTERFACE_ERRORS table
990: -- PO_PDOI_INVALID_VDR_CNTCT:
991: -- "Supplier Contact (VALUE=VALUE) is not an active and valid contact for the specified supplier site."
992: --PO_R12_CAT_UPG_UTL.add_fatal_error(
993: -- p_interface_header_id => l_interface_header_ids(i),
994: -- p_error_message_name => 'PO_PDOI_INVALID_VDR_CNTCT',
995: -- p_table_name => 'PO_HEADERS_INTERFACE',
996: -- p_column_name => 'VENDOR_CONTACT_ID',

Line 1042: PO_R12_CAT_UPG_UTL.add_fatal_error(

1038: -- Add error message into INTERFACE_ERRORS table
1039: -- ICX_CAT_SUPPLIER_SITE_CCR_INV:
1040: -- "Supplier site (VENDOR_SITE) is assigned to a CCR supplier
1041: -- (VENDOR_NAME) with an expired or deleted registration."
1042: PO_R12_CAT_UPG_UTL.add_fatal_error(
1043: p_interface_header_id => p_headers_rec.interface_header_id(i),
1044: --p_error_message_name => 'PO_PDOI_VENDOR_SITE_CCR_INV',
1045: p_error_message_name => 'ICX_CAT_SUPPLIER_SITE_CCR_INV',
1046: p_table_name => 'PO_HEADERS_INTERFACE',

Line 1181: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.ship_to_location_id.COUNT);

1177: BEGIN
1178: l_progress := '010';
1179: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1180:
1181: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.ship_to_location_id.COUNT);
1182:
1183: IF (p_headers_rec.currency_code.COUNT > 0) THEN
1184: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.ship_to_location_id(1)='||p_headers_rec.ship_to_location_id(1)); END IF;
1185: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 1237: PO_R12_CAT_UPG_UTL.add_fatal_error(

1233:
1234: -- Add error message into INTERFACE_ERRORS table
1235: -- ICX_CAT_SHIP_LOC_REQD:
1236: -- "The system cannot obtain the default value for the ship to location."
1237: PO_R12_CAT_UPG_UTL.add_fatal_error(
1238: p_interface_header_id => l_interface_header_ids(i),
1239: p_error_message_name => 'ICX_CAT_SHIP_LOC_REQD',
1240: p_table_name => 'PO_HEADERS_INTERFACE',
1241: p_column_name => 'SHIP_TO_LOCATION_ID',

Line 1311: PO_R12_CAT_UPG_UTL.add_fatal_error(

1307:
1308: -- Add error message into INTERFACE_ERRORS table
1309: -- ICX_CAT_INVALID_SHIP_LOC:
1310: -- "Default ship to location (VALUE) is inactive or invalid."
1311: PO_R12_CAT_UPG_UTL.add_fatal_error(
1312: p_interface_header_id => l_interface_header_ids(i),
1313: --p_error_message_name => 'PO_PDOI_INVALID_SHIP_LOC_ID',
1314: p_error_message_name => 'ICX_CAT_INVALID_SHIP_LOC',
1315: p_table_name => 'PO_HEADERS_INTERFACE',

Line 1379: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.bill_to_location_id.COUNT);

1375: BEGIN
1376: l_progress := '010';
1377: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1378:
1379: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.bill_to_location_id.COUNT);
1380:
1381: IF (p_headers_rec.currency_code.COUNT > 0) THEN
1382: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.bill_to_location_id(1)='||p_headers_rec.bill_to_location_id(1)); END IF;
1383: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 1432: PO_R12_CAT_UPG_UTL.add_fatal_error(

1428:
1429: -- Add error message into INTERFACE_ERRORS table
1430: -- ICX_CAT_BILL_LOC_REQD:
1431: -- "The system cannot obtain the default value for the bill to location."
1432: PO_R12_CAT_UPG_UTL.add_fatal_error(
1433: p_interface_header_id => l_interface_header_ids(i),
1434: p_error_message_name => 'ICX_CAT_BILL_LOC_REQD',
1435: p_table_name => 'PO_HEADERS_INTERFACE',
1436: p_column_name => 'BILL_TO_LOCATION_ID',

Line 1505: PO_R12_CAT_UPG_UTL.add_fatal_error(

1501:
1502: -- Add error message into INTERFACE_ERRORS table
1503: -- ICX_CAT_INVALID_BILL_LOC:
1504: -- "Default bill to location (VALUE) is inactive or invalid."
1505: PO_R12_CAT_UPG_UTL.add_fatal_error(
1506: p_interface_header_id => l_interface_header_ids(i),
1507: --p_error_message_name => 'PO_PDOI_INVALID_BILL_LOC_ID',
1508: p_error_message_name => 'ICX_CAT_INVALID_BILL_LOC',
1509: p_table_name => 'PO_HEADERS_INTERFACE',

Line 1645: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.fob.COUNT);

1641: l_progress := '010';
1642: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1643: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- FOB_LOOKUP_CODE'); END IF;
1644:
1645: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.fob.COUNT);
1646:
1647: IF (p_headers_rec.fob.COUNT > 0) THEN
1648: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.fob(1)='||p_headers_rec.fob(1)); END IF;
1649: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 1711: PO_R12_CAT_UPG_UTL.add_fatal_error(

1707: l_progress := '060';
1708: -- Add error message into INTERFACE_ERRORS table
1709: -- ICX_CAT_INVALID_FOB:
1710: -- "Default FOB carrier (VALUE) is inactive or invalid."
1711: PO_R12_CAT_UPG_UTL.add_fatal_error(
1712: p_interface_header_id => l_interface_header_ids(i),
1713: --p_error_message_name => 'ICX_CAT_INVALID_FOB_CODE',
1714: p_error_message_name => 'ICX_CAT_INVALID_FOB', -- Bug 5461235
1715: p_table_name => 'PO_HEADERS_INTERFACE',

Line 1778: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.freight_carrier.COUNT);

1774: l_progress := '010';
1775: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1776: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;
1777:
1778: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.freight_carrier.COUNT);
1779:
1780: IF (p_headers_rec.freight_carrier.COUNT > 0) THEN
1781: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.freight_carrier(1)='||p_headers_rec.freight_carrier(1)); END IF;
1782: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 1836: PO_R12_CAT_UPG_UTL.add_fatal_error(

1832:
1833: -- Add error message into INTERFACE_ERRORS table
1834: -- ICX_CAT_INVALID_FREIGHT_CAR:
1835: -- "Default freight carrier (VALUE) is inactive or invalid."
1836: PO_R12_CAT_UPG_UTL.add_fatal_error(
1837: p_interface_header_id => l_interface_header_ids(i),
1838: p_error_message_name => 'ICX_CAT_INVALID_FREIGHT_CAR', -- ECO bug 5584556: 'ICX_CAT_INVALID_SHIP_VIA_CODE',
1839: p_table_name => 'PO_HEADERS_INTERFACE',
1840: p_column_name => 'SHIP_VIA_LOOKUP_CODE',

Line 1904: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.freight_terms.COUNT);

1900: l_progress := '010';
1901: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1902: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;
1903:
1904: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.freight_terms.COUNT);
1905:
1906: IF (p_headers_rec.freight_terms.COUNT > 0) THEN
1907: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.freight_terms(1)='||p_headers_rec.freight_terms(1)); END IF;
1908: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 1971: PO_R12_CAT_UPG_UTL.add_fatal_error(

1967: l_progress := '060';
1968: -- Add error message into INTERFACE_ERRORS table
1969: -- ICX_CAT_INVALID_FREIGHT_TERMS:
1970: -- "Default freight terms (VALUE) is inactive or invalid."
1971: PO_R12_CAT_UPG_UTL.add_fatal_error(
1972: p_interface_header_id => l_interface_header_ids(i),
1973: p_error_message_name => 'ICX_CAT_INVALID_FREIGHT_TERMS',
1974: p_table_name => 'PO_HEADERS_INTERFACE',
1975: p_column_name => 'FREIGHT_TERMS_LOOKUP_CODE',

Line 2105: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.terms_id.COUNT);

2101: l_progress := '010';
2102: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2103: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;
2104:
2105: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.terms_id.COUNT);
2106:
2107: IF (p_headers_rec.terms_id.COUNT > 0) THEN
2108: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.terms_id(1)='||p_headers_rec.terms_id(1)); END IF;
2109: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 2172: PO_R12_CAT_UPG_UTL.add_fatal_error(

2168: l_progress := '060';
2169: -- Add error message into INTERFACE_ERRORS table
2170: -- ICX_CAT_INVALID_PAY_TERMS
2171: -- "Default payment terms (VALUE) is inactive or invalid."
2172: PO_R12_CAT_UPG_UTL.add_fatal_error(
2173: p_interface_header_id => l_interface_header_ids(i),
2174: --p_error_message_name => 'ICX_CAT_INVALID_TERMS_ID',
2175: p_error_message_name => 'ICX_CAT_INVALID_PAY_TERMS', -- Bug 5461235
2176: p_table_name => 'PO_HEADERS_INTERFACE',

Line 2241: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.shipping_control.COUNT);

2237: l_progress := '010';
2238: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2239: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;
2240:
2241: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.shipping_control.COUNT);
2242:
2243: IF (p_headers_rec.shipping_control.COUNT > 0) THEN
2244: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.shipping_control(1)='||p_headers_rec.shipping_control(1)); END IF;
2245: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 2308: PO_R12_CAT_UPG_UTL.add_fatal_error(

2304: l_progress := '060';
2305: -- Add error message into INTERFACE_ERRORS table
2306: -- ICX_CAT_INVALID_SHIPPING_CTRL:
2307: -- "Default shipping control (VALUE) is inactive or invalid."
2308: PO_R12_CAT_UPG_UTL.add_fatal_error(
2309: p_interface_header_id => l_interface_header_ids(i),
2310: p_error_message_name => 'ICX_CAT_INVALID_SHIPPING_CTRL', -- ECO bug 5584556 'ICX_CAT_INVALID_SHIP_CONTROL'
2311: p_table_name => 'PO_HEADERS_INTERFACE',
2312: p_column_name => 'SHIPPING_CONTROL',

Line 2374: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.rate_type_code.COUNT);

2370: BEGIN
2371: l_progress := '010';
2372: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2373:
2374: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.rate_type_code.COUNT);
2375:
2376: IF (p_headers_rec.rate_type_code.COUNT > 0) THEN
2377: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.rate_type_code(1)='||p_headers_rec.rate_type_code(1)); END IF;
2378: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.action(1)='||p_headers_rec.action(1)); END IF;

Line 2392: PO_R12_CAT_UPG_UTL.add_fatal_error(

2388: AND (p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code)
2389: AND (p_headers_rec.rate_type_code(i) IS NULL) ) THEN
2390: -- ICX_CAT_RATE_TYPE_REQD:
2391: -- "The system cannot obtain the default value for the rate type."
2392: PO_R12_CAT_UPG_UTL.add_fatal_error(
2393: p_interface_header_id => p_headers_rec.interface_header_id(i),
2394: p_error_message_name => 'ICX_CAT_RATE_TYPE_REQD',
2395: p_table_name => 'PO_HEADERS_INTERFACE',
2396: p_column_name => 'RATE_TYPE',

Line 2455: PO_R12_CAT_UPG_UTL.add_fatal_error(

2451:
2452: -- Add error message into INTERFACE_ERRORS table
2453: -- ICX_CAT_INVALID_RATE_TYPE:
2454: -- "Default rate type (VALUE) is inactive or invalid."
2455: PO_R12_CAT_UPG_UTL.add_fatal_error(
2456: p_interface_header_id => l_interface_header_ids(i),
2457: p_error_message_name => 'ICX_CAT_INVALID_RATE_TYPE',
2458: p_table_name => 'PO_HEADERS_INTERFACE',
2459: p_column_name => 'RATE_TYPE',

Line 2680: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);

2676: BEGIN
2677: l_progress := '010';
2678: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2679:
2680: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);
2681:
2682: l_progress := '020';
2683: -- SQL What: Bulk validate item_id. If item id is not null, it has to exist
2684: -- in mtl_system_items table.

Line 2749: --PO_R12_CAT_UPG_UTL.add_fatal_error(

2745:
2746: -- Add error message into INTERFACE_ERRORS table
2747: -- PO_PDOI_INVALID_ITEM_ID:
2748: -- "ITEM ID (VALUE =VALUE) is not a valid purchasable item."
2749: --PO_R12_CAT_UPG_UTL.add_fatal_error(
2750: -- p_interface_header_id => l_interface_header_ids(i),
2751: -- p_interface_line_id => l_interface_line_ids(i),
2752: -- p_error_message_name => 'PO_PDOI_INVALID_ITEM_ID',
2753: -- p_table_name => 'PO_LINES_INTERFACE',

Line 2818: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);

2814: BEGIN
2815: l_progress := '010';
2816: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2817:
2818: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);
2819:
2820: l_progress := '020';
2821: -- SQL What: Bulk validate item_description. Make sure that the
2822: -- item_description is populated, and also need to find out if it

Line 2880: --PO_R12_CAT_UPG_UTL.add_fatal_error(

2876:
2877: -- Add error message into INTERFACE_ERRORS table
2878: -- PO_PDOI_DIFF_ITEM_DESC:
2879: -- "Pre-defined item description cannot be changed for this item."
2880: --PO_R12_CAT_UPG_UTL.add_fatal_error(
2881: -- p_interface_header_id => l_interface_header_ids(i),
2882: -- p_interface_line_id => l_interface_line_ids(i),
2883: -- p_error_message_name => 'PO_PDOI_DIFF_ITEM_DESC',
2884: -- p_table_name => 'PO_LINES_INTERFACE',

Line 2946: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);

2942: BEGIN
2943: l_progress := '010';
2944: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2945:
2946: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);
2947:
2948: IF (p_lines_rec.unit_of_measure.COUNT > 0) THEN
2949: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_lines_rec.unit_of_measure(1)='||p_lines_rec.unit_of_measure(1)); END IF;
2950: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_lines_rec.uom_code(1)='||p_lines_rec.uom_code(1)); END IF;

Line 2983: PO_R12_CAT_UPG_UTL.add_fatal_error(

2979: -- Add error message into INTERFACE_ERRORS table
2980: -- ECO bug 5584556: Add new messages
2981: -- ICX_CAT_UOM_CODE_REQD:
2982: -- "Unit of measure is missing for one or more lines."
2983: PO_R12_CAT_UPG_UTL.add_fatal_error(
2984: p_interface_header_id => p_lines_rec.interface_header_id(i),
2985: p_interface_line_id => p_lines_rec.interface_line_id(i),
2986: p_error_message_name => 'ICX_CAT_UOM_CODE_REQD',
2987: p_table_name => 'PO_LINES_INTERFACE',

Line 3058: PO_R12_CAT_UPG_UTL.add_fatal_error(

3054: -- Add error message into INTERFACE_ERRORS table
3055: -- ECO bug 5584556: Add new messages
3056: -- ICX_CAT_INVALID_UOM_CODE:
3057: -- "The following unit of measure codes are inactive or invalid: VALUE, VALUE"
3058: PO_R12_CAT_UPG_UTL.add_fatal_error(
3059: p_interface_header_id => p_lines_rec.interface_header_id(i),
3060: p_interface_line_id => p_lines_rec.interface_line_id(i),
3061: p_error_message_name => 'ICX_CAT_INVALID_UOM_CODE',
3062: p_table_name => 'PO_LINES_INTERFACE',

Line 3134: PO_R12_CAT_UPG_UTL.add_fatal_error(

3130:
3131: -- Add error message into INTERFACE_ERRORS table
3132: -- ICX_CAT_INVALID_UOM_CODE:
3133: -- "The following unit of measure codes are inactive or invalid: VALUE, VALUE"
3134: PO_R12_CAT_UPG_UTL.add_fatal_error(
3135: p_interface_header_id => l_interface_header_ids(i),
3136: p_interface_line_id => l_interface_line_ids(i),
3137: --p_error_message_name => 'PO_PDOI_INVALID_UOM_CODE',
3138: p_error_message_name => 'ICX_CAT_INVALID_UOM_CODE',

Line 3223: --PO_R12_CAT_UPG_UTL.add_fatal_error(

3219:
3220: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Ignoring item_revision for interface_lien-id='||p_lines_rec.interface_line_id(i)||' because item_id is NULL'); END IF;
3221:
3222: -- Add error message into INTERFACE_ERRORS table
3223: --PO_R12_CAT_UPG_UTL.add_fatal_error(
3224: -- p_interface_header_id => p_lines_rec.interface_header_id(i),
3225: -- p_interface_line_id => p_lines_rec.interface_line_id(i),
3226: -- p_error_message_name => 'PO_COLUMN_NOT_NULL',
3227: -- p_table_name => 'PO_LINES_INTERFACE',

Line 3235: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);

3231: END IF;
3232: END LOOP;
3233:
3234: l_progress := '040';
3235: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);
3236:
3237: l_progress := '050';
3238: -- SQL What: Bulk validate item revision. Check to see if the item_revision
3239: -- exists in MTL_ITEM_REVISIONS table.

Line 3293: --PO_R12_CAT_UPG_UTL.add_fatal_error(

3289:
3290: -- Add error message into INTERFACE_ERRORS table
3291: -- PO_PDOI_ITEM_RELATED_INFO:
3292: -- "COLUMN_NAME (VALUE=VALUE) specified is inactive or invalid for item_id (VALUE=ITEM)."
3293: --PO_R12_CAT_UPG_UTL.add_fatal_error(
3294: -- p_interface_header_id => l_interface_header_ids(i),
3295: -- p_interface_line_id => l_interface_line_ids(i),
3296: -- p_error_message_name => 'PO_PDOI_ITEM_RELATED_INFO',
3297: -- p_table_name => 'PO_LINES_INTERFACE',

Line 3454: PO_R12_CAT_UPG_UTL.add_fatal_error(

3450:
3451: -- Add error message into INTERFACE_ERRORS table
3452: -- ICX_CAT_SHOP_CATEG_REQD:
3453: -- "Shopping category is missing for one or more lines."
3454: PO_R12_CAT_UPG_UTL.add_fatal_error(
3455: p_interface_header_id => p_interface_header_id,
3456: p_interface_line_id => p_interface_line_id,
3457: p_error_message_name => 'ICX_CAT_SHOP_CATEG_REQD',
3458: p_table_name => 'PO_LINES_INTERFACE',

Line 3580: PO_R12_CAT_UPG_UTL.add_fatal_error(

3576: IF (l_ip_catgeory_found = 'Y') THEN
3577: -- Add error message into INTERFACE_ERRORS table
3578: -- ICX_CAT_CATEGORY_REQD:
3579: -- "The following categories cannot be mapped to a valid purchasing category: VALUE, VALUE"
3580: PO_R12_CAT_UPG_UTL.add_fatal_error(
3581: p_interface_header_id => p_lines_rec.interface_header_id(i),
3582: p_interface_line_id => p_lines_rec.interface_line_id(i),
3583: --p_error_message_name => 'PO_COLUMN_IS_NULL',
3584: p_error_message_name => 'ICX_CAT_CATEGORY_REQD',

Line 3609: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);

3605: FROM MTL_DEFAULT_CATEGORY_SETS
3606: WHERE functional_area_id = 2) ; -- Purchasing
3607:
3608: l_progress := '050';
3609: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);
3610:
3611: l_progress := '060';
3612: -- SQL What: Bulk validate category. Validate if category_id belongs to the
3613: -- item.

Line 3686: PO_R12_CAT_UPG_UTL.add_fatal_error(

3682:
3683: -- Add error message into INTERFACE_ERRORS table
3684: -- ICX_CAT_INVALID_CATEGORY:
3685: -- "The following purchasing categories are inactive or invalid: VALUE, VALUE"
3686: PO_R12_CAT_UPG_UTL.add_fatal_error(
3687: p_interface_header_id => l_interface_header_ids(i),
3688: p_interface_line_id => l_interface_line_ids(i),
3689: --p_error_message_name => 'PO_PDOI_ITEM_RELATED_INFO',
3690: p_error_message_name => 'ICX_CAT_INVALID_CATEGORY',

Line 3774: PO_R12_CAT_UPG_UTL.add_fatal_error(

3770:
3771: -- Add error message into INTERFACE_ERRORS table
3772: -- ICX_CAT_INVALID_CATEGORY:
3773: -- "The following purchasing categories are inactive or invalid: VALUE, VALUE"
3774: PO_R12_CAT_UPG_UTL.add_fatal_error(
3775: p_interface_header_id => l_interface_header_ids(i),
3776: p_interface_line_id => l_interface_line_ids(i),
3777: --p_error_message_name => 'PO_PDOI_INVALID_CATEGORY_ID',
3778: p_error_message_name => 'ICX_CAT_INVALID_CATEGORY',

Line 3861: PO_R12_CAT_UPG_UTL.add_fatal_error(

3857:
3858: -- Add error message into INTERFACE_ERRORS table
3859: -- ICX_CAT_INVALID_CATEGORY:
3860: -- "The following purchasing categories are inactive or invalid: VALUE, VALUE"
3861: PO_R12_CAT_UPG_UTL.add_fatal_error(
3862: p_interface_header_id => l_interface_header_ids(i),
3863: p_interface_line_id => l_interface_line_ids(i),
3864: --p_error_message_name => 'PO_PDOI_INVALID_CATEGORY_ID',
3865: p_error_message_name => 'ICX_CAT_INVALID_CATEGORY',

Line 3949: PO_R12_CAT_UPG_UTL.add_fatal_error(

3945:
3946: -- Add error message into INTERFACE_ERRORS table
3947: -- PO_PDOI_LT_ZERO:
3948: -- "COLUMN_NAME (VALUE =VALUE) specified is less than zero."
3949: PO_R12_CAT_UPG_UTL.add_fatal_error(
3950: p_interface_header_id => p_lines_rec.interface_header_id(i),
3951: p_interface_line_id => p_lines_rec.interface_line_id(i),
3952: --p_error_message_name => 'PO_PDOI_LT_ZERO',
3953: p_error_message_name => 'ICX_CAT_INVALID_PRICE',

Line 4170: PO_R12_CAT_UPG_UTL.add_fatal_error(

4166: l_progress := '050';
4167: -- Add error message into INTERFACE_ERRORS table
4168: FOR i in 1..l_err_line_ids.COUNT
4169: LOOP
4170: PO_R12_CAT_UPG_UTL.add_fatal_error(
4171: p_interface_header_id => l_err_header_ids(i),
4172: p_interface_line_id => l_err_line_ids(i),
4173: p_error_message_name => 'PO_CAT_UPG_ORIG_NOT_ALLOWED',
4174: p_table_name => 'PO_LINES_INTERFACE',

Line 4183: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);

4179: l_progress := '060';
4180: -- Cascade errors down to attribute and TLP levels
4181: -- Skip cascading of errors in Validate Only mode (iP Requirement - all errors should be reported)
4182: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4183: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
4184: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4185: END IF;
4186:
4187: -----------------------------------------------------------------------------

Line 4184: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

4180: -- Cascade errors down to attribute and TLP levels
4181: -- Skip cascading of errors in Validate Only mode (iP Requirement - all errors should be reported)
4182: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4183: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
4184: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4185: END IF;
4186:
4187: -----------------------------------------------------------------------------
4188: -- CREATE action validations for Attribute Values

Line 4237: PO_R12_CAT_UPG_UTL.add_fatal_error(

4233: l_progress := '080';
4234: -- Add error message into INTERFACE_ERRORS table
4235: FOR i in 1..l_err_attr_values_ids.COUNT
4236: LOOP
4237: PO_R12_CAT_UPG_UTL.add_fatal_error(
4238: p_interface_header_id => l_err_header_ids(i),
4239: p_interface_line_id => l_err_line_ids(i),
4240: p_interface_attr_values_id => l_err_attr_values_ids(i),
4241: p_error_message_name => 'PO_CAT_UPG_NULL_IDS',

Line 4251: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

4247: l_progress := '090';
4248: -- Cascade errors down to TLP level
4249: -- Skip cascading of errors in Validate Only mode.
4250: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4251: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4252: END IF;
4253:
4254: ----------------------------------------------------------------------------------
4255: -- Clear the error arrays

Line 4288: PO_R12_CAT_UPG_UTL.add_fatal_error(

4284: l_progress := '072';
4285: -- Add error message into INTERFACE_ERRORS table
4286: FOR i in 1..l_err_attr_values_ids.COUNT
4287: LOOP
4288: PO_R12_CAT_UPG_UTL.add_fatal_error(
4289: p_interface_header_id => l_err_header_ids(i),
4290: p_interface_line_id => l_err_line_ids(i),
4291: p_interface_attr_values_id => l_err_attr_values_ids(i),
4292: p_error_message_name => 'PO_CAT_UPG_INV_LINE_ACTION_BL',

Line 4341: PO_R12_CAT_UPG_UTL.add_fatal_error(

4337: l_progress := '072';
4338: -- Add error message into INTERFACE_ERRORS table
4339: FOR i in 1..l_err_attr_values_ids.COUNT
4340: LOOP
4341: PO_R12_CAT_UPG_UTL.add_fatal_error(
4342: p_interface_header_id => l_err_header_ids(i),
4343: p_interface_line_id => l_err_line_ids(i),
4344: p_interface_attr_values_id => l_err_attr_values_ids(i),
4345: p_error_message_name => 'PO_CAT_UPG_INV_LINE_ACTION_RT',

Line 4386: PO_R12_CAT_UPG_UTL.add_fatal_error(

4382: l_progress := '074';
4383: -- Add error message into INTERFACE_ERRORS table
4384: FOR i in 1..l_err_attr_values_ids.COUNT
4385: LOOP
4386: PO_R12_CAT_UPG_UTL.add_fatal_error(
4387: p_interface_header_id => l_err_header_ids(i),
4388: p_interface_line_id => l_err_line_ids(i),
4389: p_interface_attr_values_id => l_err_attr_values_ids(i),
4390: p_error_message_name => 'PO_CAT_UPG_ALL_3_FOR_REQT',

Line 4433: PO_R12_CAT_UPG_UTL.add_fatal_error(

4429: l_progress := '076';
4430: -- Add error message into INTERFACE_ERRORS table
4431: FOR i in 1..l_err_attr_values_ids.COUNT
4432: LOOP
4433: PO_R12_CAT_UPG_UTL.add_fatal_error(
4434: p_interface_header_id => l_err_header_ids(i),
4435: p_interface_line_id => l_err_line_ids(i),
4436: p_interface_attr_values_id => l_err_attr_values_ids(i),
4437: p_error_message_name => 'PO_CAT_UPG_ALL_NO_REQTEMP',

Line 4449: PO_R12_CAT_UPG_UTL.add_fatal_error(

4445: l_progress := '080';
4446: -- Add error message into INTERFACE_ERRORS table
4447: FOR i in 1..l_err_attr_values_ids.COUNT
4448: LOOP
4449: PO_R12_CAT_UPG_UTL.add_fatal_error(
4450: p_interface_header_id => l_err_header_ids(i),
4451: p_interface_line_id => l_err_line_ids(i),
4452: p_interface_attr_values_id => l_err_attr_values_ids(i),
4453: p_error_message_name => 'PO_CAT_UPG_INVALID_ATTR_ROW',

Line 4463: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

4459: l_progress := '090';
4460: -- Cascade errors down to TLP level
4461: -- Skip cascading of errors in Validate Only mode.
4462: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4463: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4464: END IF;
4465:
4466: -----------------------------------------------------------------------------
4467: -- CREATE action validations for Attribute Values TLP

Line 4559: PO_R12_CAT_UPG_UTL.add_fatal_error(

4555: l_progress := '110';
4556: -- Add error message into INTERFACE_ERRORS table
4557: FOR i in 1..l_err_attr_values_tlp_ids.COUNT
4558: LOOP
4559: PO_R12_CAT_UPG_UTL.add_fatal_error(
4560: p_interface_header_id => l_err_header_ids(i),
4561: p_interface_line_id => l_err_line_ids(i),
4562: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
4563: p_error_message_name => 'PO_CAT_UPG_INVALID_TLP_ROW',

Line 4654: PO_R12_CAT_UPG_UTL.add_fatal_error(

4650: l_progress := '020';
4651: -- Add error message into INTERFACE_ERRORS table
4652: FOR i in 1..l_err_header_ids.COUNT
4653: LOOP
4654: PO_R12_CAT_UPG_UTL.add_fatal_error(
4655: p_interface_header_id => l_err_header_ids(i),
4656: p_error_message_name => 'PO_CAT_UPG_ADD_NOT_ALLOWED',
4657: p_table_name => 'PO_HEADERS_INTERFACE',
4658: p_column_name => 'ACTION'

Line 4666: PO_R12_CAT_UPG_UTL.reject_headers_intf('INTERFACE_HEADER_ID', l_err_header_ids, 'Y');

4662: l_progress := '030';
4663: -- Cascade errors down to attribute and TLP levels
4664: -- Skip cascading of errors in Validate Only mode (iP Requirement - all errors should be reported)
4665: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4666: PO_R12_CAT_UPG_UTL.reject_headers_intf('INTERFACE_HEADER_ID', l_err_header_ids, 'Y');
4667: END IF;
4668:
4669: -----------------------------------------------------------------------------
4670: -- ADD action validations for Lines

Line 4701: PO_R12_CAT_UPG_UTL.add_fatal_error(

4697: l_progress := '050';
4698: -- Add error message into INTERFACE_ERRORS table
4699: FOR i in 1..l_err_line_ids.COUNT
4700: LOOP
4701: PO_R12_CAT_UPG_UTL.add_fatal_error(
4702: p_interface_header_id => l_err_header_ids(i),
4703: p_interface_line_id => l_err_line_ids(i),
4704: p_error_message_name => 'PO_CAT_UPG_INVALID_HEADER_ID',
4705: p_table_name => 'PO_LINES_INTERFACE',

Line 4714: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);

4710: l_progress := '060';
4711: -- Cascade errors down to attribute and TLP levels
4712: -- Skip cascading of errors in Validate Only mode (iP Requirement - all errors should be reported)
4713: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4714: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
4715: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4716: END IF;
4717:
4718: -----------------------------------------------------------------------------

Line 4715: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

4711: -- Cascade errors down to attribute and TLP levels
4712: -- Skip cascading of errors in Validate Only mode (iP Requirement - all errors should be reported)
4713: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4714: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
4715: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4716: END IF;
4717:
4718: -----------------------------------------------------------------------------
4719: -- ORIGINAL action validations for Attribute Values

Line 4745: PO_R12_CAT_UPG_UTL.add_fatal_error(

4741: l_progress := '080';
4742: -- Add error message into INTERFACE_ERRORS table
4743: FOR i in 1..l_err_attr_values_ids.COUNT
4744: LOOP
4745: PO_R12_CAT_UPG_UTL.add_fatal_error(
4746: p_interface_header_id => l_err_header_ids(i),
4747: p_interface_line_id => l_err_line_ids(i),
4748: p_interface_attr_values_id => l_err_attr_values_ids(i),
4749: p_error_message_name => 'PO_CAT_UPG_ORIG_NOT_ALLOWED',

Line 4759: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

4755: l_progress := '090';
4756: -- Cascade errors down to TLP level
4757: -- Skip cascading of errors in Validate Only mode.
4758: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4759: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4760: END IF;
4761:
4762: -----------------------------------------------------------------------------
4763: -- ORIGINAL action validations for Attribute Values TLP

Line 4789: PO_R12_CAT_UPG_UTL.add_fatal_error(

4785: l_progress := '110';
4786: -- Add error message into INTERFACE_ERRORS table
4787: FOR i in 1..l_err_attr_values_tlp_ids.COUNT
4788: LOOP
4789: PO_R12_CAT_UPG_UTL.add_fatal_error(
4790: p_interface_header_id => l_err_header_ids(i),
4791: p_interface_line_id => l_err_line_ids(i),
4792: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
4793: p_error_message_name => 'PO_CAT_UPG_ORIG_NOT_ALLOWED',

Line 4891: PO_R12_CAT_UPG_UTL.add_fatal_error(

4887: l_progress := '020';
4888: -- Add error message into INTERFACE_ERRORS table
4889: FOR i in 1..l_err_header_ids.COUNT
4890: LOOP
4891: PO_R12_CAT_UPG_UTL.add_fatal_error(
4892: p_interface_header_id => l_err_header_ids(i),
4893: p_error_message_name => 'PO_CAT_UPG_INVALID_HEADER_ID',
4894: p_table_name => 'PO_HEADERS_INTERFACE',
4895: p_column_name => 'PO_HEADER_ID'

Line 4903: PO_R12_CAT_UPG_UTL.reject_lines_intf(p_id_param_type => 'INTERFACE_HEADER_ID',

4899: l_progress := '030';
4900: -- Cascade errors down to attribute and TLP levels
4901: -- Skip cascading of errors in Validate Only mode.
4902: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4903: PO_R12_CAT_UPG_UTL.reject_lines_intf(p_id_param_type => 'INTERFACE_HEADER_ID',
4904: p_id_tbl => l_err_header_ids,
4905: p_cascade => 'Y');
4906: END IF;
4907:

Line 4938: PO_R12_CAT_UPG_UTL.add_fatal_error(

4934: l_progress := '040';
4935: -- Add error message into INTERFACE_ERRORS table
4936: FOR i in 1..l_err_line_ids.COUNT
4937: LOOP
4938: PO_R12_CAT_UPG_UTL.add_fatal_error(
4939: p_interface_header_id => l_err_header_ids(i),
4940: p_interface_line_id => l_err_line_ids(i),
4941: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',
4942: p_table_name => 'po_lines_interface',

Line 4951: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);

4947: l_progress := '050';
4948: -- Cascade errors down to attribute and TLP levels
4949: -- Skip cascading of errors in Validate Only mode.
4950: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4951: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
4952: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4953: END IF;
4954:
4955: -----------------------------------------------------------------------------

Line 4952: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

4948: -- Cascade errors down to attribute and TLP levels
4949: -- Skip cascading of errors in Validate Only mode.
4950: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
4951: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
4952: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
4953: END IF;
4954:
4955: -----------------------------------------------------------------------------
4956: -- UPDATE action validations for Attribute Values

Line 5027: PO_R12_CAT_UPG_UTL.add_fatal_error(

5023: l_progress := '070';
5024: -- Add error message into INTERFACE_ERRORS table
5025: FOR i in 1..l_err_attr_values_ids.COUNT
5026: LOOP
5027: PO_R12_CAT_UPG_UTL.add_fatal_error(
5028: p_interface_header_id => l_err_header_ids(i),
5029: p_interface_line_id => l_err_line_ids(i),
5030: p_interface_attr_values_id => l_err_attr_values_ids(i),
5031: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',

Line 5041: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

5037: l_progress := '080';
5038: -- Cascade errors down to TLP level
5039: -- Skip cascading of errors in Validate Only mode.
5040: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
5041: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
5042: END IF;
5043:
5044: -----------------------------------------------------------------------------
5045: -- UPDATE action validations for Attribute Values TLP

Line 5127: PO_R12_CAT_UPG_UTL.add_fatal_error(

5123: l_progress := '100';
5124: -- Add error message into INTERFACE_ERRORS table
5125: FOR i in 1..l_err_attr_values_tlp_ids.COUNT
5126: LOOP
5127: PO_R12_CAT_UPG_UTL.add_fatal_error(
5128: p_interface_header_id => l_err_header_ids(i),
5129: p_interface_line_id => l_err_line_ids(i),
5130: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
5131: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',

Line 5230: PO_R12_CAT_UPG_UTL.add_fatal_error(

5226: l_progress := '020';
5227: -- Add error message into INTERFACE_ERRORS table
5228: FOR i in 1..l_err_header_ids.COUNT
5229: LOOP
5230: PO_R12_CAT_UPG_UTL.add_fatal_error(
5231: p_interface_header_id => l_err_header_ids(i),
5232: p_error_message_name => 'PO_CAT_UPG_INVALID_HEADER_ID',
5233: p_table_name => 'po_headers_interface',
5234: p_column_name => 'PO_HEADER_ID'

Line 5242: PO_R12_CAT_UPG_UTL.reject_lines_intf(p_id_param_type => 'INTERFACE_HEADER_ID',

5238: l_progress := '030';
5239: -- Cascade errors down to attribute and TLP levels
5240: -- Skip cascading of errors in Validate Only mode.
5241: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
5242: PO_R12_CAT_UPG_UTL.reject_lines_intf(p_id_param_type => 'INTERFACE_HEADER_ID',
5243: p_id_tbl => l_err_header_ids,
5244: p_cascade => 'Y');
5245: END IF;
5246:

Line 5278: PO_R12_CAT_UPG_UTL.add_fatal_error(

5274: l_progress := '040';
5275: -- Add error message into INTERFACE_ERRORS table
5276: FOR i in 1..l_err_line_ids.COUNT
5277: LOOP
5278: PO_R12_CAT_UPG_UTL.add_fatal_error(
5279: p_interface_header_id => l_err_header_ids(i),
5280: p_interface_line_id => l_err_line_ids(i),
5281: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',
5282: p_table_name => 'po_lines_interface',

Line 5291: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);

5287: l_progress := '050';
5288: -- Cascade errors down to attribute and TLP levels
5289: -- Skip cascading of errors in Validate Only mode.
5290: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
5291: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
5292: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
5293: END IF;
5294:
5295: -----------------------------------------------------------------------------

Line 5292: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

5288: -- Cascade errors down to attribute and TLP levels
5289: -- Skip cascading of errors in Validate Only mode.
5290: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
5291: PO_R12_CAT_UPG_UTL.reject_attr_values_intf('INTERFACE_LINE_ID', l_err_line_ids);
5292: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
5293: END IF;
5294:
5295: -----------------------------------------------------------------------------
5296: -- DELETE action validations for Attribute Values

Line 5324: PO_R12_CAT_UPG_UTL.add_fatal_error(

5320: l_progress := '070';
5321: -- Add error message into INTERFACE_ERRORS table
5322: FOR i in 1..l_err_attr_values_ids.COUNT
5323: LOOP
5324: PO_R12_CAT_UPG_UTL.add_fatal_error(
5325: p_interface_header_id => l_err_header_ids(i),
5326: p_interface_line_id => l_err_line_ids(i),
5327: p_interface_attr_values_id => l_err_attr_values_ids(i),
5328: p_error_message_name => 'PO_CAT_UPG_CANT_DEL_ATTR',

Line 5338: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);

5334: l_progress := '080';
5335: -- Cascade errors down to TLP level
5336: -- Skip cascading of errors in Validate Only mode.
5337: IF (p_validate_only_mode = FND_API.G_FALSE) THEN
5338: PO_R12_CAT_UPG_UTL.reject_attr_values_tlp_intf('INTERFACE_LINE_ID', l_err_line_ids);
5339: END IF;
5340:
5341: -----------------------------------------------------------------------------
5342: -- DELETE action validations for Attribute Values TLP

Line 5346: l_base_language := PO_R12_CAT_UPG_UTL.get_base_lang;

5342: -- DELETE action validations for Attribute Values TLP
5343: -----------------------------------------------------------------------------
5344:
5345: l_progress := '090';
5346: l_base_language := PO_R12_CAT_UPG_UTL.get_base_lang;
5347:
5348: -- For Attribute Values TLP,
5349: -- Check that a Unique Key is provided for which the attribute TLP needs to be deleted
5350: -- Unique key for TLP table is:

Line 5452: PO_R12_CAT_UPG_UTL.add_fatal_error(

5448: l_progress := '100';
5449: -- Add error message into INTERFACE_ERRORS table
5450: FOR i in 1..l_err_attr_values_tlp_ids.COUNT
5451: LOOP
5452: PO_R12_CAT_UPG_UTL.add_fatal_error(
5453: p_interface_header_id => l_err_header_ids(i),
5454: p_interface_line_id => l_err_line_ids(i),
5455: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
5456: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',