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_HEADERS_INTERFACE

Line 75: FROM PO_HEADERS_INTERFACE

71:
72: CURSOR load_org_ids_csr(p_batch_id NUMBER) IS
73: SELECT interface_header_id
74: , org_id
75: FROM PO_HEADERS_INTERFACE
76: WHERE batch_id = p_batch_id
77: AND process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;
78:
79: BEGIN

Line 115: UPDATE PO_HEADERS_INTERFACE

111: -- Gets the errored rows into GT table.
112: -- SQL Why : It will be used to mark the record in interface tables as rejected.
113: -- SQL Join: interface_header_id
114: FORALL i IN 1 .. l_interface_header_ids.COUNT
115: UPDATE PO_HEADERS_INTERFACE
116: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
117: WHERE interface_header_id = l_interface_header_ids(i)
118: AND (l_org_ids(i) IS NULL
119: OR l_org_ids(i) = g_OU_REQD -- where g_OU_REQD is -2 (iProc defined this value)

Line 141: p_table_name => 'PO_HEADERS_INTERFACE',

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',
142: p_column_name => 'ORG_ID',
143: p_column_value => l_err_org_ids(i) -- debug purposes only, not used in the msg
144: );
145: ELSE -- if org_id is NULL or if ID does not exist in table.

Line 151: p_table_name => 'PO_HEADERS_INTERFACE',

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',
153: p_column_value => l_err_org_ids(i)
154: );
155: END IF;

Line 173: UPDATE PO_HEADERS_INTERFACE

169: -- Gets the errored rows into GT table.
170: -- SQL Why : It will be used to mark the record in interface tables as rejected.
171: -- SQL Join: interface_header_id
172: FORALL i IN 1 .. l_interface_header_ids.COUNT
173: UPDATE PO_HEADERS_INTERFACE
174: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
175: WHERE interface_header_id = l_interface_header_ids(i)
176: -- ECO bug 5584556: Skip the validations covered above
177: AND l_org_ids(i) IS NOT NULL

Line 243: p_table_name => 'PO_HEADERS_INTERFACE',

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',
244: p_column_name => 'ORG_ID',
245: p_column_value => l_ou_name, -- ECO bug 5584556
246: p_token1_name => 'VALUE',
247: p_token1_value => l_err_org_ids(i)

Line 351: p_table_name => 'PO_HEADERS_INTERFACE',

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',
353: p_column_value => p_headers_rec.expiration_date(i),
354: p_token1_name => 'VALUE',
355: p_token1_value => p_headers_rec.effective_date(i)

Line 418: p_table_name => 'PO_HEADERS_INTERFACE',

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',
420: p_column_value => p_headers_rec.agent_id(i),
421: p_token1_name => 'VALUE',
422: p_token1_value => p_headers_rec.agent_id(i)

Line 502: p_table_name => 'PO_HEADERS_INTERFACE',

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',
504: p_column_value => p_headers_rec.currency_code(i)
505: );
506: END IF;

Line 567: p_table_name => 'PO_HEADERS_INTERFACE',

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',
568: p_column_name => 'CURRENCY_CODE',
569: p_column_value => l_err_currency_code_list(i),
570: p_token1_name => 'VALUE',
571: p_token1_value => l_err_currency_code_list(i)

Line 711: p_table_name => 'PO_HEADERS_INTERFACE',

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',
713: p_column_value => l_vendor_id_list(i)
714: );
715: END LOOP;

Line 779: p_table_name => 'PO_HEADERS_INTERFACE',

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',
780: p_column_name => 'VENDOR_NAME',
781: p_column_value => l_vendor_name_list(i),
782: p_token1_name => 'VALUE',
783: p_token1_value => l_vendor_id_list(i) -- debug only

Line 860: p_table_name => 'PO_HEADERS_INTERFACE',

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',
862: p_column_value => l_vendor_site_id_list(i)
863: );
864: END LOOP;

Line 929: p_table_name => 'PO_HEADERS_INTERFACE',

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',
930: p_column_name => 'VENDOR_SITE_ID',
931: p_column_value => l_vendor_site_code_list(i),
932: p_token1_name => 'VALUE',
933: p_token1_value => l_vendor_site_code_list(i)

Line 995: -- p_table_name => 'PO_HEADERS_INTERFACE',

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',
997: -- p_column_value => l_vendor_contact_id_list(i),
998: -- p_token1_name => 'VALUE',
999: -- p_token1_value => l_vendor_contact_id_list(i)

Line 1046: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1047: p_column_name => 'VENDOR_SITE_ID',
1048: p_column_value => p_headers_rec.vendor_site_code(i),
1049: p_token1_name => 'VENDOR_SITE_ID',
1050: p_token1_value => p_headers_rec.vendor_site_id(i),

Line 1240: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1242: p_column_value => l_err_ship_to_loc_id_list(i)
1243: );
1244: END LOOP;

Line 1315: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1316: p_column_name => 'SHIP_TO_LOCATION_ID',
1317: p_column_value => l_location_name, -- ECO bug 5584556
1318: p_token1_name => 'VALUE',
1319: p_token1_value => l_err_ship_to_loc_id_list(i)

Line 1435: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1437: p_column_value => l_err_bill_to_loc_id_list(i)
1438: );
1439: END LOOP;

Line 1509: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1510: p_column_name => 'BILL_TO_LOCATION_ID',
1511: p_column_value => l_location_name, -- ECO bug 5584556
1512: p_token1_name => 'VALUE',
1513: p_token1_value => l_err_bill_to_loc_id_list(i)

Line 1715: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1716: p_column_name => 'FOB_LOOKUP_CODE',
1717: p_column_value => l_lookup_meaning, -- ECO Bug 5584556
1718: p_token1_name => 'VALUE',
1719: p_token1_value => l_err_fob_lookup_code_list(i)

Line 1839: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1841: p_column_value => l_err_ship_via_luc_list(i),
1842: p_token1_name => 'VALUE',
1843: p_token1_value => l_err_ship_via_luc_list(i)

Line 1974: p_table_name => 'PO_HEADERS_INTERFACE',

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',
1976: p_column_value => l_lookup_meaning, -- ECO bug 5584556
1977: p_token1_name => 'VALUE',
1978: p_token1_value => l_err_freight_terms_list(i)

Line 2176: p_table_name => 'PO_HEADERS_INTERFACE',

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',
2177: p_column_name => 'TERMS_ID',
2178: p_column_value => l_terms_name, -- ECO bug 5584556
2179: p_token1_name => 'VALUE',
2180: p_token1_value => l_err_terms_id_list(i)

Line 2311: p_table_name => 'PO_HEADERS_INTERFACE',

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',
2313: p_column_value => l_lookup_meaning, -- ECO bug 5584556
2314: p_token1_name => 'VALUE',
2315: p_token1_value => l_err_shipping_control_list(i)

Line 2395: p_table_name => 'PO_HEADERS_INTERFACE',

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',
2397: p_column_value => NULL,
2398: -- debug purposes only
2399: p_token1_name => 'HEADER_CURRENCY',

Line 2458: p_table_name => 'PO_HEADERS_INTERFACE',

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',
2460: p_column_value => l_err_rate_type_code_list(i),
2461: p_token1_name => 'VALUE',
2462: p_token1_value => l_err_rate_type_code_list(i)

Line 4640: UPDATE PO_HEADERS_INTERFACE POHI

4636:
4637: -- SQL What: validate add action at header level
4638: -- SQL Why : To find incorrect action
4639: -- SQL Join: processing_id, action
4640: UPDATE PO_HEADERS_INTERFACE POHI
4641: SET POHI.processing_id = -POHI.processing_id,
4642: POHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4643: WHERE POHI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4644: AND POHI.action = 'ADD'

Line 4657: p_table_name => 'PO_HEADERS_INTERFACE',

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'
4659: );
4660: END LOOP;
4661:

Line 4872: UPDATE PO_HEADERS_INTERFACE POHI

4868:
4869: -- SQL What: validate update action at Header level
4870: -- SQL Why : To find incorrect action
4871: -- SQL Join: processing_id, action, po_header_id
4872: UPDATE PO_HEADERS_INTERFACE POHI
4873: SET POHI.processing_id = -POHI.processing_id,
4874: POHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4875: WHERE POHI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4876: AND POHI.action = 'UPDATE'

Line 4894: p_table_name => 'PO_HEADERS_INTERFACE',

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'
4896: );
4897: END LOOP;
4898:

Line 5210: UPDATE PO_HEADERS_INTERFACE POHI

5206:
5207: -- SQL What: validate delete action at header level
5208: -- SQL Why : To find incorrect action
5209: -- SQL Join: processing_id, action, po_header_id
5210: UPDATE PO_HEADERS_INTERFACE POHI
5211: SET POHI.processing_id = -POHI.processing_id,
5212: POHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5213: WHERE POHI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5214: AND POHI.action = 'DELETE'

Line 5233: p_table_name => 'po_headers_interface',

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'
5235: );
5236: END LOOP;
5237: