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_PVT

Line 8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_VAL_PVT';
5: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
6:
7: g_debug BOOLEAN := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;
9:
10: -- Value of PO_LINE_ID and REQ_TEMPLATE_LINE_NUM if they are not
11: -- required in Attr/TLP tables.
12: g_NOT_REQUIRED_ID CONSTANT NUMBER := PO_R12_CAT_UPG_PVT.g_NOT_REQUIRED_ID;

Line 12: g_NOT_REQUIRED_ID CONSTANT NUMBER := PO_R12_CAT_UPG_PVT.g_NOT_REQUIRED_ID;

8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;
9:
10: -- Value of PO_LINE_ID and REQ_TEMPLATE_LINE_NUM if they are not
11: -- required in Attr/TLP tables.
12: g_NOT_REQUIRED_ID CONSTANT NUMBER := PO_R12_CAT_UPG_PVT.g_NOT_REQUIRED_ID;
13: -- Value of REQ_TEMPLATE_NAME if it is not required in Attr/TLP tables.
14: g_NOT_REQUIRED_REQ_TEMPLATE CONSTANT VARCHAR2(30) := PO_R12_CAT_UPG_PVT.g_NOT_REQUIRED_REQ_TEMPLATE ;
15:
16: -- If the value of a column (vendor_id, site_id, etc.) in the interface table

Line 14: g_NOT_REQUIRED_REQ_TEMPLATE CONSTANT VARCHAR2(30) := PO_R12_CAT_UPG_PVT.g_NOT_REQUIRED_REQ_TEMPLATE ;

10: -- Value of PO_LINE_ID and REQ_TEMPLATE_LINE_NUM if they are not
11: -- required in Attr/TLP tables.
12: g_NOT_REQUIRED_ID CONSTANT NUMBER := PO_R12_CAT_UPG_PVT.g_NOT_REQUIRED_ID;
13: -- Value of REQ_TEMPLATE_NAME if it is not required in Attr/TLP tables.
14: g_NOT_REQUIRED_REQ_TEMPLATE CONSTANT VARCHAR2(30) := PO_R12_CAT_UPG_PVT.g_NOT_REQUIRED_REQ_TEMPLATE ;
15:
16: -- If the value of a column (vendor_id, site_id, etc.) in the interface table
17: -- is -2, then treat it as NULL for validation routines.
18: g_NULL_COLUMN_VALUE NUMBER := -2;

Line 77: AND process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;

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
80: l_progress := '010';
81: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 116: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

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)
120: OR NOT EXISTS

Line 174: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

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
178: AND l_org_ids(i) <> g_OU_REQD -- where g_OU_REQD is -2 (iProc defined this value)

Line 321: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

317: --End of Comments
318: --------------------------------------------------------------------------------
319: PROCEDURE validate_expiration_date
320: (
321: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
322: )
323: IS
324: l_api_name CONSTANT VARCHAR2(30) := 'validate_expiration_date';
325: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 337: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create AND --Bug#5018883

333: FOR i IN 1 .. p_headers_rec.expiration_date.COUNT
334: LOOP
335: l_progress := '020';
336: IF (--p_headers_rec.has_errors(i) = 'N' AND
337: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create AND --Bug#5018883
338: p_headers_rec.effective_date(i) IS NOT NULL AND
339: p_headers_rec.expiration_date(i) IS NOT NULL AND
340: p_headers_rec.effective_date(i) > p_headers_rec.expiration_date(i)) THEN
341:

Line 390: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

386: --End of Comments
387: --------------------------------------------------------------------------------
388: PROCEDURE validate_buyer
389: (
390: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
391: )
392: IS
393: l_api_name CONSTANT VARCHAR2(30) := 'validate_buyer';
394: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 406: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create AND --Bug#5018883

402: FOR i IN 1 .. p_headers_rec.agent_id.COUNT
403: LOOP
404: l_progress := '020';
405: IF (--p_headers_rec.has_errors(i) = 'N' AND
406: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create AND --Bug#5018883
407: p_headers_rec.agent_id(i) IS NULL) THEN
408:
409: l_progress := '030';
410: p_headers_rec.has_errors(i) := 'Y';

Line 461: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

457: --------------------------------------------------------------------------------
458: PROCEDURE validate_currency_code
459: (
460: p_key IN NUMBER,
461: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
462: )
463: IS
464: l_api_name CONSTANT VARCHAR2(30) := 'validate_currency_code';
465: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 492: IF ( (p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create) AND

488:
489: -- ECO bug 5584556: Add new messages
490: FOR i IN 1 .. p_headers_rec.currency_code.COUNT
491: LOOP
492: IF ( (p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create) AND
493: (p_headers_rec.currency_code(i) IS NULL) ) THEN
494: p_headers_rec.has_errors(i) := 'Y';
495:
496: -- Add error message into INTERFACE_ERRORS table

Line 526: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

522: , p_headers_rec.interface_header_id(i)
523: , p_headers_rec.currency_code(i)
524: FROM DUAL
525: WHERE --p_headers_rec.has_errors(i) = 'N'
526: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
527: -- ECO bug 5584556: Start
528: -- The following validation check is already done above.
529: -- So adding these additional where-clauses to skip those cases.
530: AND p_headers_rec.currency_code(i) IS NOT NULL

Line 614: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

610: --------------------------------------------------------------------------------
611: PROCEDURE validate_vendor_info
612: (
613: p_key IN NUMBER,
614: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
615: )
616: IS
617: l_api_name CONSTANT VARCHAR2(30) := 'validate_vendor_info';
618: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 676: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

672: , p_headers_rec.vendor_id(i)
673: , p_headers_rec.vendor_name(i)
674: FROM DUAL
675: WHERE --p_headers_rec.has_errors(i) = 'N'
676: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
677: AND (p_headers_rec.vendor_id(i) IS NULL
678: OR p_headers_rec.vendor_id(i) = g_NULL_COLUMN_VALUE -- -2
679: OR NOT EXISTS(SELECT 1
680: FROM PO_VENDORS PV

Line 736: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

732: , p_headers_rec.vendor_id(i)
733: , p_headers_rec.vendor_name(i)
734: FROM DUAL
735: WHERE --p_headers_rec.has_errors(i) = 'N'
736: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
737: -- ECO bug 5584556: Start
738: -- The following 3 validation checks are already done above.
739: -- So adding these additional where-clauses to skip those cases.
740: AND p_headers_rec.vendor_id(i) IS NOT NULL

Line 811: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')

807: , p_headers_rec.vendor_site_id(i)
808: , p_headers_rec.vendor_site_code(i)
809: FROM DUAL
810: WHERE --p_headers_rec.has_errors(i) = 'N'
811: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')
812: AND
813: (
814: (
815: -- Handle null Supplier Sites for Create action only

Line 816: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create

812: AND
813: (
814: (
815: -- Handle null Supplier Sites for Create action only
816: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create
817: AND (p_headers_rec.vendor_site_id(i) IS NULL
818: OR p_headers_rec.vendor_site_id(i) = g_NULL_COLUMN_VALUE)
819: )
820: OR

Line 885: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')

881: , p_headers_rec.vendor_site_id(i)
882: , p_headers_rec.vendor_site_code(i)
883: FROM DUAL
884: WHERE --p_headers_rec.has_errors(i) = 'N'
885: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')
886: -- ECO bug 5584556: Start
887: -- The following 3 validation checks are already done above.
888: -- So adding these additional where-clauses to skip those cases.
889: AND p_headers_rec.vendor_site_id(i) IS NOT NULL

Line 957: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')

953: , p_headers_rec.interface_header_id(i)
954: , p_headers_rec.vendor_contact_id(i)
955: FROM DUAL
956: WHERE --p_headers_rec.has_errors(i) = 'N'
957: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE')
958: AND p_headers_rec.vendor_id(i) IS NOT NULL
959: AND p_headers_rec.vendor_site_id(i) IS NOT NULL
960: AND p_headers_rec.vendor_contact_id(i) IS NOT NULL
961: AND NOT EXISTS(SELECT 1

Line 1020: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE') --AND

1016: IF (p_headers_rec.vendor_id(i) IS NOT NULL AND
1017: p_headers_rec.vendor_id(i) <> g_NULL_COLUMN_VALUE AND -- -2
1018: p_headers_rec.vendor_site_id(i) IS NOT NULL AND
1019: p_headers_rec.vendor_site_id(i) <> g_NULL_COLUMN_VALUE AND -- -2
1020: p_headers_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE') --AND
1021: --p_headers_rec.has_errors(i) = 'N'
1022: ) THEN
1023:
1024: l_progress := '180';

Line 1159: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

1155: --------------------------------------------------------------------------------
1156: PROCEDURE validate_ship_to_location_id
1157: (
1158: p_key IN NUMBER,
1159: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
1160: )
1161: IS
1162: l_api_name CONSTANT VARCHAR2(30) := 'validate_ship_to_location_id';
1163: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1208: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

1204: , p_headers_rec.interface_header_id(i)
1205: , p_headers_rec.ship_to_location_id(i)
1206: FROM DUAL
1207: WHERE --p_headers_rec.has_errors(i) = 'N'
1208: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1209: AND (p_headers_rec.ship_to_location_id(i) IS NULL OR
1210: NOT EXISTS(SELECT 1
1211: FROM HR_LOCATIONS_ALL HRLA
1212: WHERE p_headers_rec.ship_to_location_id(i) = HRLA.location_id));

Line 1264: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

1260: , p_headers_rec.interface_header_id(i)
1261: , p_headers_rec.ship_to_location_id(i)
1262: FROM DUAL
1263: WHERE --p_headers_rec.has_errors(i) = 'N'
1264: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1265: -- ECO bug 5584556: Start
1266: -- The following validation checks are already done above.
1267: -- So adding these additional where-clauses to skip those cases.
1268: AND p_headers_rec.ship_to_location_id(i) IS NOT NULL

Line 1357: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

1353: --------------------------------------------------------------------------------
1354: PROCEDURE validate_bill_to_location_id
1355: (
1356: p_key IN NUMBER,
1357: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
1358: )
1359: IS
1360: l_api_name CONSTANT VARCHAR2(30) := 'validate_bill_to_location_id';
1361: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1403: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

1399: , p_headers_rec.interface_header_id(i)
1400: , p_headers_rec.bill_to_location_id(i)
1401: FROM DUAL
1402: WHERE --p_headers_rec.has_errors(i) = 'N'
1403: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1404: AND (p_headers_rec.bill_to_location_id(i) IS NULL OR
1405: NOT EXISTS(SELECT 1
1406: FROM HR_LOCATIONS_ALL HRLA
1407: WHERE p_headers_rec.bill_to_location_id(i) = HRLA.location_id));

Line 1458: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

1454: , p_headers_rec.interface_header_id(i)
1455: , p_headers_rec.bill_to_location_id(i)
1456: FROM DUAL
1457: WHERE --p_headers_rec.has_errors(i) = 'N'
1458: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1459: -- ECO bug 5584556: Start
1460: -- The following validation checks are already done above.
1461: -- So adding these additional where-clauses to skip those cases.
1462: AND p_headers_rec.bill_to_location_id(i) IS NOT NULL

Line 1622: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

1618: --------------------------------------------------------------------------------
1619: PROCEDURE validate_fob_lookup_code
1620: (
1621: p_key IN NUMBER,
1622: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
1623: )
1624: IS
1625: l_api_name CONSTANT VARCHAR2(30) := 'validate_fob_lookup_code';
1626: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1669: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

1665: , p_headers_rec.interface_header_id(i)
1666: , p_headers_rec.fob(i)
1667: FROM DUAL
1668: WHERE --p_headers_rec.has_errors(i) = 'N'
1669: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1670: AND p_headers_rec.fob(i) IS NOT NULL
1671: AND NOT EXISTS(SELECT 1
1672: FROM PO_LOOKUP_CODES PLC
1673: WHERE p_headers_rec.fob(i) = PLC.lookup_code

Line 1757: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

1753: --------------------------------------------------------------------------------
1754: PROCEDURE validate_ship_via_luc
1755: (
1756: p_key IN NUMBER,
1757: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
1758: )
1759: IS
1760: l_api_name CONSTANT VARCHAR2(30) := 'validate_ship_via_luc';
1761: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1805: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

1801: , p_headers_rec.interface_header_id(i)
1802: , p_headers_rec.freight_carrier(i)
1803: FROM DUAL
1804: WHERE --p_headers_rec.has_errors(i) = 'N'
1805: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1806: AND p_headers_rec.freight_carrier(i) IS NOT NULL
1807: AND NOT EXISTS(SELECT 1
1808: FROM ORG_FREIGHT OFR
1809: WHERE p_headers_rec.freight_carrier(i) = OFR.freight_code

Line 1811: AND OFR.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);

1807: AND NOT EXISTS(SELECT 1
1808: FROM ORG_FREIGHT OFR
1809: WHERE p_headers_rec.freight_carrier(i) = OFR.freight_code
1810: AND NVL(OFR.disable_date, SYSDATE + 1) > SYSDATE
1811: AND OFR.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1812:
1813: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
1814:
1815: l_progress := '030';

Line 1881: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

1877: --------------------------------------------------------------------------------
1878: PROCEDURE validate_freight_terms
1879: (
1880: p_key IN NUMBER,
1881: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
1882: )
1883: IS
1884: l_api_name CONSTANT VARCHAR2(30) := 'validate_freight_terms';
1885: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1928: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

1924: , p_headers_rec.interface_header_id(i)
1925: , p_headers_rec.freight_terms(i)
1926: FROM DUAL
1927: WHERE --p_headers_rec.has_errors(i) = 'N'
1928: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1929: AND p_headers_rec.freight_terms(i) IS NOT NULL
1930: AND NOT EXISTS(
1931: SELECT 1
1932: FROM PO_LOOKUP_CODES PLC

Line 2082: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

2078: --------------------------------------------------------------------------------
2079: PROCEDURE validate_terms_id
2080: (
2081: p_key IN NUMBER,
2082: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
2083: )
2084: IS
2085: l_api_name CONSTANT VARCHAR2(30) := 'validate_terms_id';
2086: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2129: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

2125: , p_headers_rec.interface_header_id(i)
2126: , p_headers_rec.terms_id(i)
2127: FROM DUAL
2128: WHERE --p_headers_rec.has_errors(i) = 'N'
2129: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2130: AND p_headers_rec.terms_id(i) IS NOT NULL
2131: AND NOT EXISTS
2132: (SELECT 1
2133: FROM AP_TERMS APT

Line 2218: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

2214: --------------------------------------------------------------------------------
2215: PROCEDURE validate_shipping_control
2216: (
2217: p_key IN NUMBER,
2218: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
2219: )
2220: IS
2221: l_api_name CONSTANT VARCHAR2(30) := 'validate_shipping_control';
2222: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2265: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

2261: , p_headers_rec.interface_header_id(i)
2262: , p_headers_rec.shipping_control(i)
2263: FROM DUAL
2264: WHERE --p_headers_rec.has_errors(i) = 'N'
2265: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2266: AND p_headers_rec.shipping_control(i) IS NOT NULL
2267: AND NOT EXISTS(
2268: SELECT 1
2269: FROM PO_LOOKUP_CODES PLC

Line 2354: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

2350: --------------------------------------------------------------------------------
2351: PROCEDURE validate_rate_type_code
2352: (
2353: p_key IN NUMBER,
2354: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
2355: )
2356: IS
2357: l_api_name CONSTANT VARCHAR2(30) := 'validate_rate_type_code';
2358: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2387: IF ( (p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create)

2383: -- Add a separate message for NULL value of rate_type_code
2384: l_progress := '020';
2385: FOR i IN 1 .. p_headers_rec.rate_type_code.COUNT
2386: LOOP
2387: IF ( (p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create)
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."

Line 2388: AND (p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code)

2384: l_progress := '020';
2385: FOR i IN 1 .. p_headers_rec.rate_type_code.COUNT
2386: LOOP
2387: IF ( (p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create)
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(

Line 2402: p_token2_value => PO_R12_CAT_UPG_PVT.g_sys.currency_code

2398: -- debug purposes only
2399: p_token1_name => 'HEADER_CURRENCY',
2400: p_token1_value => p_headers_rec.currency_code(i),
2401: p_token2_name => 'FUNCTIONAL_CURRENCY',
2402: p_token2_value => PO_R12_CAT_UPG_PVT.g_sys.currency_code
2403: );
2404: END IF;
2405: END LOOP;
2406: -- ECO bug 5584556: End

Line 2424: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883

2420: , p_headers_rec.interface_header_id(i)
2421: , p_headers_rec.rate_type_code(i)
2422: FROM DUAL
2423: WHERE --p_headers_rec.has_errors(i) = 'N'
2424: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2425: AND p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code
2426: AND p_headers_rec.rate_type_code(i) IS NOT NULL
2427: AND NOT EXISTS(
2428: SELECT 'Rate type exists'

Line 2425: AND p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code

2421: , p_headers_rec.rate_type_code(i)
2422: FROM DUAL
2423: WHERE --p_headers_rec.has_errors(i) = 'N'
2424: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2425: AND p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code
2426: AND p_headers_rec.rate_type_code(i) IS NOT NULL
2427: AND NOT EXISTS(
2428: SELECT 'Rate type exists'
2429: FROM GL_DAILY_CONVERSION_TYPES_V GLDCT

Line 2512: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

2508: --End of Comments
2509: --------------------------------------------------------------------------------
2510: PROCEDURE validate_headers
2511: (
2512: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
2513: )
2514: IS
2515: l_api_name CONSTANT VARCHAR2(30) := 'validate_headers';
2516: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2659: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

2655: --------------------------------------------------------------------------------
2656: PROCEDURE validate_item
2657: (
2658: p_key IN NUMBER,
2659: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
2660: )
2661: IS
2662: l_api_name CONSTANT VARCHAR2(30) := 'validate_item';
2663: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2701: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')

2697: , p_lines_rec.interface_line_id(i)
2698: , p_lines_rec.item_id(i)
2699: FROM PO_LINE_TYPES_B PLT
2700: WHERE --p_lines_rec.has_errors(i) = 'N'
2701: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
2702: AND p_lines_rec.item_id(i) is not null
2703: AND p_lines_rec.line_type_id(i) is not null
2704: AND p_lines_rec.line_type_id(i)= PLT.line_type_id
2705: AND PLT.outside_operation_flag is not null

Line 2709: AND MSI.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id

2705: AND PLT.outside_operation_flag is not null
2706: AND NOT EXISTS (SELECT 1
2707: FROM MTL_SYSTEM_ITEMS MSI
2708: WHERE MSI.inventory_item_id = p_lines_rec.item_id(i)
2709: AND MSI.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id
2710: AND MSI.enabled_flag = 'Y'
2711: AND MSI.purchasing_item_flag = 'Y'
2712: AND MSI.purchasing_enabled_flag = 'Y'
2713: AND MSI.outside_operation_flag = PLT.outside_operation_flag

Line 2797: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

2793: --------------------------------------------------------------------------------
2794: PROCEDURE validate_item_description
2795: (
2796: p_key IN NUMBER,
2797: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
2798: )
2799: IS
2800: l_api_name CONSTANT VARCHAR2(30) := 'validate_item_description';
2801: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2840: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')

2836: , p_lines_rec.interface_line_id(i)
2837: , p_lines_rec.item_description(i)
2838: FROM DUAL
2839: WHERE --p_lines_rec.has_errors(i) = 'N'
2840: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
2841: AND (p_lines_rec.item_description(i) is null OR
2842: (p_lines_rec.item_id(i) is not null AND
2843: EXISTS (SELECT 1
2844: FROM MTL_SYSTEM_ITEMS MSI

Line 2846: AND MSI.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id

2842: (p_lines_rec.item_id(i) is not null AND
2843: EXISTS (SELECT 1
2844: FROM MTL_SYSTEM_ITEMS MSI
2845: WHERE MSI.inventory_item_id = p_lines_rec.item_id(i)
2846: AND MSI.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id
2847: AND MSI.allow_item_desc_update_flag = 'N'
2848: AND p_lines_rec.item_description(i) <> MSI.description)));
2849: --AND create_or_update_item_flag = 'N'))); its a parameter to PDOI, For catalog migration, it would always be 'N'
2850:

Line 2924: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

2920: --------------------------------------------------------------------------------
2921: PROCEDURE validate_uom
2922: (
2923: p_key IN NUMBER,
2924: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
2925: )
2926: IS
2927: l_api_name CONSTANT VARCHAR2(30) := 'validate_uom';
2928: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2965: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND

2961: -- If it is specified as NULL in INTF table, then the column
2962: -- remains unchanged in TXN table. This is handled via a DECODE in the
2963: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
2964: -- where CREATED_BY is NOT -12.
2965: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
2966: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
2967: OR
2968: (p_lines_rec.action(i) = 'UPDATE' AND
2969: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

Line 2966: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create

2962: -- remains unchanged in TXN table. This is handled via a DECODE in the
2963: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
2964: -- where CREATED_BY is NOT -12.
2965: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
2966: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
2967: OR
2968: (p_lines_rec.action(i) = 'UPDATE' AND
2969: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
2970: )

Line 2969: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

2965: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
2966: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
2967: OR
2968: (p_lines_rec.action(i) = 'UPDATE' AND
2969: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
2970: )
2971: AND
2972: p_lines_rec.uom_code(i) IS NULL) THEN
2973:

Line 3000: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND

2996: FOR i IN 1 .. p_lines_rec.uom_code.COUNT
2997: LOOP
2998: l_progress := '020';
2999: IF (--p_lines_rec.has_errors(i) = 'N' AND
3000: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3001: p_lines_rec.unit_of_measure(i) IS NULL AND
3002: p_lines_rec.uom_code(i) IS NOT NULL) THEN
3003:
3004: l_progress := '030';

Line 3037: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND

3033: -- If it is specified as NULL in INTF table, then the column
3034: -- remains unchanged in TXN table. This is handled via a DECODE in the
3035: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
3036: -- where CREATED_BY is NOT -12.
3037: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3038: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
3039: OR
3040: (p_lines_rec.action(i) = 'UPDATE' AND
3041: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

Line 3038: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create

3034: -- remains unchanged in TXN table. This is handled via a DECODE in the
3035: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
3036: -- where CREATED_BY is NOT -12.
3037: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3038: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
3039: OR
3040: (p_lines_rec.action(i) = 'UPDATE' AND
3041: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
3042: )

Line 3041: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

3037: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3038: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
3039: OR
3040: (p_lines_rec.action(i) = 'UPDATE' AND
3041: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
3042: )
3043: AND p_lines_rec.unit_of_measure(i) IS NULL
3044: -- ECO bug 5584556: This validation is already done above.
3045: -- So skip these cases.

Line 3092: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')

3088: , p_lines_rec.unit_of_measure(i)
3089: , p_lines_rec.uom_code(i)
3090: FROM DUAL
3091: WHERE --p_lines_rec.has_errors(i) = 'N'
3092: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3093: AND p_lines_rec.unit_of_measure(i) is not null
3094: AND p_lines_rec.uom_code(i) is not null
3095: AND ( (p_lines_rec.item_id(i) is not null
3096: AND NOT EXISTS (SELECT 1

Line 3099: AND MIUV.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id

3095: AND ( (p_lines_rec.item_id(i) is not null
3096: AND NOT EXISTS (SELECT 1
3097: FROM MTL_ITEM_UOMS_VIEW MIUV
3098: WHERE MIUV.inventory_item_id = p_lines_rec.item_id(i)
3099: AND MIUV.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id
3100: AND MIUV.unit_of_measure = p_lines_rec.unit_of_measure(i)))
3101: OR
3102: (p_lines_rec.item_id(i) is null
3103: AND NOT EXISTS (SELECT 1

Line 3183: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

3179: --------------------------------------------------------------------------------
3180: PROCEDURE validate_item_revision
3181: (
3182: p_key IN NUMBER,
3183: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
3184: )
3185: IS
3186: l_api_name CONSTANT VARCHAR2(30) := 'validate_item_revision';
3187: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 3210: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND

3206: FOR i IN 1 .. p_lines_rec.item_revision.COUNT
3207: LOOP
3208: l_progress := '020';
3209: IF (--p_lines_rec.has_errors(i) = 'N' AND
3210: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3211: p_lines_rec.item_id(i) IS NULL AND
3212: p_lines_rec.item_revision(i) IS NOT NULL) THEN
3213:
3214: l_progress := '030';

Line 3258: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')

3254: , p_lines_rec.item_id(i)
3255: , p_lines_rec.item_revision(i)
3256: FROM DUAL
3257: WHERE --p_lines_rec.has_errors(i) = 'N'
3258: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3259: AND p_lines_rec.item_revision(i) is not null
3260: AND p_lines_rec.item_id(i) is not null
3261: AND NOT EXISTS (SELECT 1
3262: FROM MTL_ITEM_REVISIONS MIR

Line 3505: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

3501: --------------------------------------------------------------------------------
3502: PROCEDURE validate_category
3503: (
3504: p_key IN NUMBER,
3505: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
3506: )
3507: IS
3508: l_api_name CONSTANT VARCHAR2(30) := 'validate_category';
3509: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 3547: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND

3543: -- If it is specified as NULL in INTF table, then the column
3544: -- remains unchanged in TXN table. This is handled via a DECODE in the
3545: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
3546: -- where CREATED_BY is NOT -12.
3547: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3548: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
3549: OR
3550: (p_lines_rec.action(i) = 'UPDATE' AND
3551: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

Line 3548: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create

3544: -- remains unchanged in TXN table. This is handled via a DECODE in the
3545: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
3546: -- where CREATED_BY is NOT -12.
3547: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3548: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
3549: OR
3550: (p_lines_rec.action(i) = 'UPDATE' AND
3551: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
3552: )

Line 3551: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

3547: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3548: ( p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create
3549: OR
3550: (p_lines_rec.action(i) = 'UPDATE' AND
3551: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
3552: )
3553: AND
3554: (p_lines_rec.category_id(i) IS NULL
3555: OR p_lines_rec.category_id(i) = g_NULL_COLUMN_VALUE)) -- -2

Line 3634: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')

3630: , p_lines_rec.category_id(i)
3631: , p_lines_rec.category(i) -- category name
3632: FROM DUAL
3633: WHERE --p_lines_rec.has_errors(i) = 'N'
3634: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3635: AND p_lines_rec.item_id(i) is not null
3636: AND p_lines_rec.category_id(i) is not null
3637: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3638: AND NOT EXISTS (SELECT 1

Line 3646: AND MIC.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id

3642: MIC.category_id = MCS.category_id
3643: AND MIC.category_set_id = l_category_set_id
3644: AND MIC.category_id = p_lines_rec.category_id(i)
3645: AND MIC.inventory_item_id = p_lines_rec.item_id(i)
3646: AND MIC.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id
3647: AND sysdate < nvl(MCS.disable_date, sysdate+1)
3648: AND MCS.enabled_flag = 'Y');
3649:
3650: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;

Line 3724: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')

3720: , p_lines_rec.category_id(i)
3721: , p_lines_rec.category(i) -- category name
3722: FROM DUAL
3723: WHERE --p_lines_rec.has_errors(i) = 'N'
3724: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3725: AND p_lines_rec.item_id(i) is null
3726: AND p_lines_rec.category_id(i) is not null
3727: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3728: AND NOT EXISTS

Line 3812: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')

3808: , p_lines_rec.category_id(i)
3809: , p_lines_rec.category(i) -- category name
3810: FROM DUAL
3811: WHERE --p_lines_rec.has_errors(i) = 'N'
3812: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3813: AND p_lines_rec.item_id(i) is null
3814: AND p_lines_rec.category_id(i) is not null
3815: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3816: AND NOT EXISTS

Line 3909: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

3905: --End of Comments
3906: --------------------------------------------------------------------------------
3907: PROCEDURE validate_unit_price
3908: (
3909: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
3910: )
3911: IS
3912: l_api_name CONSTANT VARCHAR2(30) := 'validate_unit_price';
3913: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 3931: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND

3927: -- If it is specified as NULL in INTF table, then the column
3928: -- remains unchanged in TXN table. This is handled via a DECODE in the
3929: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
3930: -- where CREATED_BY is NOT -12.
3931: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3932: ( p_lines_rec.action(i) =PO_R12_CAT_UPG_PVT.g_action_line_create
3933: OR
3934: (p_lines_rec.action(i) = 'UPDATE' AND
3935: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

Line 3932: ( p_lines_rec.action(i) =PO_R12_CAT_UPG_PVT.g_action_line_create

3928: -- remains unchanged in TXN table. This is handled via a DECODE in the
3929: -- UPDATE statement, later in the flow. So allow NULL value in UPDATE flow
3930: -- where CREATED_BY is NOT -12.
3931: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3932: ( p_lines_rec.action(i) =PO_R12_CAT_UPG_PVT.g_action_line_create
3933: OR
3934: (p_lines_rec.action(i) = 'UPDATE' AND
3935: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
3936: )

Line 3935: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)

3931: --p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE') AND
3932: ( p_lines_rec.action(i) =PO_R12_CAT_UPG_PVT.g_action_line_create
3933: OR
3934: (p_lines_rec.action(i) = 'UPDATE' AND
3935: p_lines_rec.created_by(i) = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER)
3936: )
3937: AND
3938: (p_lines_rec.unit_price(i) IS NULL OR
3939: p_lines_rec.unit_price(i) < 0)) THEN

Line 4010: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

4006: --End of Comments
4007: --------------------------------------------------------------------------------
4008: PROCEDURE validate_lines
4009: (
4010: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
4011: )
4012: IS
4013: l_api_name CONSTANT VARCHAR2(30) := 'validate_lines';
4014: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 4158: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4154: -- SQL Why : To find incorrect action
4155: -- SQL Join: processing_id, action, interface_header_id
4156: UPDATE PO_LINES_INTERFACE POLI
4157: SET POLI.processing_id = -POLI.processing_id,
4158: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4159: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4160: AND POLI.action = 'ORIGINAL'
4161: RETURNING POLI.interface_line_id, POLI.interface_header_id
4162: BULK COLLECT INTO l_err_line_ids, l_err_header_ids;

Line 4159: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4155: -- SQL Join: processing_id, action, interface_header_id
4156: UPDATE PO_LINES_INTERFACE POLI
4157: SET POLI.processing_id = -POLI.processing_id,
4158: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4159: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4160: AND POLI.action = 'ORIGINAL'
4161: RETURNING POLI.interface_line_id, POLI.interface_header_id
4162: BULK COLLECT INTO l_err_line_ids, l_err_header_ids;
4163:

Line 4190: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_action_line_create='||PO_R12_CAT_UPG_PVT.g_action_line_create); END IF;

4186:
4187: -----------------------------------------------------------------------------
4188: -- CREATE action validations for Attribute Values
4189: -----------------------------------------------------------------------------
4190: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_action_line_create='||PO_R12_CAT_UPG_PVT.g_action_line_create); END IF;
4191: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_action_attr_create='||PO_R12_CAT_UPG_PVT.g_action_attr_create); END IF;
4192:
4193: -- Clear the error arrays
4194: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_err_header_ids.COUNT='||l_err_header_ids.COUNT); END IF;

Line 4191: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_action_attr_create='||PO_R12_CAT_UPG_PVT.g_action_attr_create); END IF;

4187: -----------------------------------------------------------------------------
4188: -- CREATE action validations for Attribute Values
4189: -----------------------------------------------------------------------------
4190: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_action_line_create='||PO_R12_CAT_UPG_PVT.g_action_line_create); END IF;
4191: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_action_attr_create='||PO_R12_CAT_UPG_PVT.g_action_attr_create); END IF;
4192:
4193: -- Clear the error arrays
4194: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_err_header_ids.COUNT='||l_err_header_ids.COUNT); END IF;
4195: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_err_line_ids.COUNT='||l_err_line_ids.COUNT); END IF;

Line 4211: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4207: -- SQL Why : To find incorrect action
4208: -- SQL Join: processing_id, action, interface_line_id
4209: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4210: SET POAI.processing_id = -POAI.processing_id,
4211: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4212: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4213: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4214: AND (
4215: POAI.interface_line_id IS NULL

Line 4212: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4208: -- SQL Join: processing_id, action, interface_line_id
4209: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4210: SET POAI.processing_id = -POAI.processing_id,
4211: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4212: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4213: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4214: AND (
4215: POAI.interface_line_id IS NULL
4216: OR

Line 4213: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

4209: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4210: SET POAI.processing_id = -POAI.processing_id,
4211: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4212: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4213: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4214: AND (
4215: POAI.interface_line_id IS NULL
4216: OR
4217: -- the following are NOT NULL columns in the TXN table, so they must

Line 4267: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4263:
4264: l_progress := '071';
4265: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4266: SET POAI.processing_id = -POAI.processing_id,
4267: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4268: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4269: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4270: AND (EXISTS
4271: (SELECT 'Invalid relationship with Line Level'

Line 4268: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4264: l_progress := '071';
4265: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4266: SET POAI.processing_id = -POAI.processing_id,
4267: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4268: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4269: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4270: AND (EXISTS
4271: (SELECT 'Invalid relationship with Line Level'
4272: FROM PO_LINES_INTERFACE POLI

Line 4269: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

4265: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4266: SET POAI.processing_id = -POAI.processing_id,
4267: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4268: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4269: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4270: AND (EXISTS
4271: (SELECT 'Invalid relationship with Line Level'
4272: FROM PO_LINES_INTERFACE POLI
4273: WHERE POLI.interface_line_id = POAI.interface_line_id

Line 4277: POLI.action NOT IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE'))

4273: WHERE POLI.interface_line_id = POAI.interface_line_id
4274: AND ( -- Attribute Row for GBPA must have appr action at line level
4275: (POAI.req_template_name = g_NOT_REQUIRED_REQ_TEMPLATE AND
4276: POAI.req_template_line_num = g_NOT_REQUIRED_ID AND
4277: POLI.action NOT IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE'))
4278: )))
4279: RETURNING POAI.interface_attr_values_id, POAI.interface_line_id, POAI.interface_header_id
4280: BULK COLLECT INTO l_err_attr_values_ids, l_err_line_ids, l_err_header_ids;
4281:

Line 4320: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4316:
4317: l_progress := '07';
4318: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4319: SET POAI.processing_id = -POAI.processing_id,
4320: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4321: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4322: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4323: AND (EXISTS
4324: (SELECT 'Invalid relationship with Line Level'

Line 4321: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4317: l_progress := '07';
4318: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4319: SET POAI.processing_id = -POAI.processing_id,
4320: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4321: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4322: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4323: AND (EXISTS
4324: (SELECT 'Invalid relationship with Line Level'
4325: FROM PO_LINES_INTERFACE POLI

Line 4322: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

4318: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4319: SET POAI.processing_id = -POAI.processing_id,
4320: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4321: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4322: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4323: AND (EXISTS
4324: (SELECT 'Invalid relationship with Line Level'
4325: FROM PO_LINES_INTERFACE POLI
4326: WHERE POLI.interface_line_id = POAI.interface_line_id

Line 4363: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4359:
4360: l_progress := '073';
4361: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4362: SET POAI.processing_id = -POAI.processing_id,
4363: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4364: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4365: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4366: AND (
4367: ( -- For ReqTemplates, ALL the 3 columns must be given

Line 4364: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4360: l_progress := '073';
4361: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4362: SET POAI.processing_id = -POAI.processing_id,
4363: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4364: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4365: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4366: AND (
4367: ( -- For ReqTemplates, ALL the 3 columns must be given
4368: (POAI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE AND

Line 4365: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

4361: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4362: SET POAI.processing_id = -POAI.processing_id,
4363: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4364: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4365: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4366: AND (
4367: ( -- For ReqTemplates, ALL the 3 columns must be given
4368: (POAI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE AND
4369: (POAI.req_template_line_num = g_NOT_REQUIRED_ID OR

Line 4408: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4404:
4405: l_progress := '075';
4406: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4407: SET POAI.processing_id = -POAI.processing_id,
4408: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4409: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4410: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4411: AND (
4412: (-- For ReqTemplates, the ReqTemplate Line must exist in Txn tables

Line 4409: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4405: l_progress := '075';
4406: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4407: SET POAI.processing_id = -POAI.processing_id,
4408: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4409: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4410: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4411: AND (
4412: (-- For ReqTemplates, the ReqTemplate Line must exist in Txn tables
4413: POAI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE AND

Line 4410: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

4406: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4407: SET POAI.processing_id = -POAI.processing_id,
4408: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4409: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4410: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create
4411: AND (
4412: (-- For ReqTemplates, the ReqTemplate Line must exist in Txn tables
4413: POAI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE AND
4414: POAI.req_template_line_num <> g_NOT_REQUIRED_ID AND

Line 4489: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4485: -- SQL Why : To find incorrect action
4486: -- SQL Join: processing_id, action, interface_line_id
4487: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
4488: SET POATI.processing_id = -POATI.processing_id,
4489: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4490: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4491: AND POATI.action = PO_R12_CAT_UPG_PVT.g_action_tlp_create
4492: AND (
4493: POATI.language IS NULL

Line 4490: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4486: -- SQL Join: processing_id, action, interface_line_id
4487: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
4488: SET POATI.processing_id = -POATI.processing_id,
4489: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4490: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4491: AND POATI.action = PO_R12_CAT_UPG_PVT.g_action_tlp_create
4492: AND (
4493: POATI.language IS NULL
4494: OR

Line 4491: AND POATI.action = PO_R12_CAT_UPG_PVT.g_action_tlp_create

4487: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
4488: SET POATI.processing_id = -POATI.processing_id,
4489: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4490: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4491: AND POATI.action = PO_R12_CAT_UPG_PVT.g_action_tlp_create
4492: AND (
4493: POATI.language IS NULL
4494: OR
4495: POATI.interface_line_id IS NULL

Line 4516: POLI.action NOT IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE'))

4512: WHERE POLI.interface_line_id = POATI.interface_line_id
4513: AND ( -- Attribute Row for GBPA must have appr action at line level
4514: (POATI.req_template_name = g_NOT_REQUIRED_REQ_TEMPLATE AND
4515: POATI.req_template_line_num = g_NOT_REQUIRED_ID AND
4516: POLI.action NOT IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE'))
4517: OR
4518: -- Attribute Row for ReqTemplate must have action as REQTEMPALTE at line level
4519: ((POATI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE OR
4520: POATI.req_template_line_num <> g_NOT_REQUIRED_ID) AND

Line 4642: POHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

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'
4645: RETURNING POHI.interface_header_id
4646: BULK COLLECT INTO l_err_header_ids;

Line 4643: WHERE POHI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

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'
4645: RETURNING POHI.interface_header_id
4646: BULK COLLECT INTO l_err_header_ids;
4647:

Line 4683: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4679: -- SQL Why : To find incorrect action
4680: -- SQL Join: processing_id, action, po_header_id
4681: UPDATE PO_LINES_INTERFACE POLI
4682: SET POLI.processing_id = -POLI.processing_id,
4683: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4684: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4685: AND POLI.action = PO_R12_CAT_UPG_PVT.g_action_line_create -- ADD
4686: AND (POLI.interface_header_id IS NULL OR
4687: (POLI.po_header_id IS NOT NULL AND

Line 4684: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4680: -- SQL Join: processing_id, action, po_header_id
4681: UPDATE PO_LINES_INTERFACE POLI
4682: SET POLI.processing_id = -POLI.processing_id,
4683: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4684: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4685: AND POLI.action = PO_R12_CAT_UPG_PVT.g_action_line_create -- ADD
4686: AND (POLI.interface_header_id IS NULL OR
4687: (POLI.po_header_id IS NOT NULL AND
4688: NOT EXISTS

Line 4685: AND POLI.action = PO_R12_CAT_UPG_PVT.g_action_line_create -- ADD

4681: UPDATE PO_LINES_INTERFACE POLI
4682: SET POLI.processing_id = -POLI.processing_id,
4683: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4684: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4685: AND POLI.action = PO_R12_CAT_UPG_PVT.g_action_line_create -- ADD
4686: AND (POLI.interface_header_id IS NULL OR
4687: (POLI.po_header_id IS NOT NULL AND
4688: NOT EXISTS
4689: (SELECT 'PO_HEADER_ID points to valid doc'

Line 4731: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4727: -- SQL Why : To find incorrect action
4728: -- SQL Join: processing_id, action, po_line_id
4729: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4730: SET POAI.processing_id = -POAI.processing_id,
4731: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4732: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4733: AND POAI.action = 'ORIGINAL'
4734: RETURNING POAI.interface_attr_values_id, POAI.interface_line_id, POAI.interface_header_id
4735: BULK COLLECT INTO l_err_attr_values_ids, l_err_line_ids, l_err_header_ids;

Line 4732: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4728: -- SQL Join: processing_id, action, po_line_id
4729: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4730: SET POAI.processing_id = -POAI.processing_id,
4731: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4732: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4733: AND POAI.action = 'ORIGINAL'
4734: RETURNING POAI.interface_attr_values_id, POAI.interface_line_id, POAI.interface_header_id
4735: BULK COLLECT INTO l_err_attr_values_ids, l_err_line_ids, l_err_header_ids;
4736:

Line 4775: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4771: -- SQL Why : To find incorrect action
4772: -- SQL Join: processing_id, action, po_line_id
4773: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
4774: SET POATI.processing_id = -POATI.processing_id,
4775: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4776: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4777: AND POATI.action = 'ORIGINAL'
4778: RETURNING POATI.interface_attr_values_tlp_id, POATI.interface_line_id, POATI.interface_header_id
4779: BULK COLLECT INTO l_err_attr_values_tlp_ids, l_err_line_ids, l_err_header_ids;

Line 4776: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4772: -- SQL Join: processing_id, action, po_line_id
4773: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
4774: SET POATI.processing_id = -POATI.processing_id,
4775: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4776: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4777: AND POATI.action = 'ORIGINAL'
4778: RETURNING POATI.interface_attr_values_tlp_id, POATI.interface_line_id, POATI.interface_header_id
4779: BULK COLLECT INTO l_err_attr_values_tlp_ids, l_err_line_ids, l_err_header_ids;
4780:

Line 4874: POHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

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'
4877: AND (POHI.po_header_id is null
4878: OR NOT EXISTS

Line 4875: WHERE POHI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

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'
4877: AND (POHI.po_header_id is null
4878: OR NOT EXISTS
4879: (SELECT 'document exists'

Line 4921: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4917: -- SQL Why : To find incorrect action
4918: -- SQL Join: processing_id, action, po_line_id
4919: UPDATE PO_LINES_INTERFACE POLI
4920: SET POLI.processing_id = -POLI.processing_id,
4921: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4922: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4923: AND POLI.action = 'UPDATE'
4924: AND (POLI.po_line_id is null
4925: OR NOT EXISTS

Line 4922: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4918: -- SQL Join: processing_id, action, po_line_id
4919: UPDATE PO_LINES_INTERFACE POLI
4920: SET POLI.processing_id = -POLI.processing_id,
4921: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4922: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4923: AND POLI.action = 'UPDATE'
4924: AND (POLI.po_line_id is null
4925: OR NOT EXISTS
4926: (SELECT 'line exists'

Line 4972: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

4968: -- SQL Why : To find incorrect action
4969: -- SQL Join: processing_id, action, po_line_id
4970: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4971: SET POAI.processing_id = -POAI.processing_id,
4972: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4973: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4974: AND POAI.action = 'UPDATE'
4975: AND (
4976: -- the following are NOT NULL columns in the TXN table, so they must

Line 4973: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

4969: -- SQL Join: processing_id, action, po_line_id
4970: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4971: SET POAI.processing_id = -POAI.processing_id,
4972: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4973: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4974: AND POAI.action = 'UPDATE'
4975: AND (
4976: -- the following are NOT NULL columns in the TXN table, so they must
4977: -- have a not null value in the INTF table as well.

Line 5062: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

5058: -- SQL Why : To find incorrect action
5059: -- SQL Join: processing_id, action, po_line_id
5060: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
5061: SET POATI.processing_id = -POATI.processing_id,
5062: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5063: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5064: AND POATI.action = 'UPDATE'
5065: AND (
5066: -- the following are NOT NULL columns in the TXN table, so they must

Line 5063: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

5059: -- SQL Join: processing_id, action, po_line_id
5060: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
5061: SET POATI.processing_id = -POATI.processing_id,
5062: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5063: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5064: AND POATI.action = 'UPDATE'
5065: AND (
5066: -- the following are NOT NULL columns in the TXN table, so they must
5067: -- have a not null value in the INTF table as well.

Line 5212: POHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

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'
5215: AND (POHI.po_header_id is null
5216: OR EXISTS

Line 5213: WHERE POHI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

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'
5215: AND (POHI.po_header_id is null
5216: OR EXISTS
5217: (SELECT 'document not created by migration program'

Line 5220: AND POH.created_by <> PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER))

5216: OR EXISTS
5217: (SELECT 'document not created by migration program'
5218: FROM PO_HEADERS_ALL POH
5219: WHERE POH.po_header_id = POHI.po_header_id
5220: AND POH.created_by <> PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER))
5221: RETURNING POHI.interface_header_id
5222: BULK COLLECT INTO l_err_header_ids;
5223:
5224: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of invalid DELETE action at Header level='||SQL%rowcount); END IF;

Line 5260: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

5256: -- SQL Why : To find incorrect action
5257: -- SQL Join: processing_id, action, po_line_id
5258: UPDATE PO_LINES_INTERFACE POLI
5259: SET POLI.processing_id = -POLI.processing_id,
5260: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5261: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5262: AND POLI.action = 'DELETE'
5263: AND (POLI.po_line_id is null
5264: OR EXISTS

Line 5261: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

5257: -- SQL Join: processing_id, action, po_line_id
5258: UPDATE PO_LINES_INTERFACE POLI
5259: SET POLI.processing_id = -POLI.processing_id,
5260: POLI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5261: WHERE POLI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5262: AND POLI.action = 'DELETE'
5263: AND (POLI.po_line_id is null
5264: OR EXISTS
5265: (SELECT 'line not created by migration program'

Line 5268: AND POL.created_by <> PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER))

5264: OR EXISTS
5265: (SELECT 'line not created by migration program'
5266: FROM PO_LINES_ALL POL
5267: WHERE POL.po_line_id = POLI.po_line_id
5268: AND POL.created_by <> PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER))
5269: RETURNING POLI.interface_line_id, POLI.interface_header_id
5270: BULK COLLECT INTO l_err_line_ids, l_err_header_ids;
5271:
5272: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of invalid DELETE action at Line level='||SQL%rowcount); END IF;

Line 5312: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

5308: -- SQL Why : To find incorrect action
5309: -- SQL Join: processing_id, action
5310: UPDATE PO_ATTR_VALUES_INTERFACE POAI
5311: SET POAI.processing_id = -POAI.processing_id,
5312: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5313: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5314: AND POAI.action = 'DELETE'
5315: RETURNING POAI.interface_attr_values_id, POAI.interface_line_id, POAI.interface_header_id
5316: BULK COLLECT INTO l_err_attr_values_ids, l_err_line_ids, l_err_header_ids;

Line 5313: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

5309: -- SQL Join: processing_id, action
5310: UPDATE PO_ATTR_VALUES_INTERFACE POAI
5311: SET POAI.processing_id = -POAI.processing_id,
5312: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5313: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5314: AND POAI.action = 'DELETE'
5315: RETURNING POAI.interface_attr_values_id, POAI.interface_line_id, POAI.interface_header_id
5316: BULK COLLECT INTO l_err_attr_values_ids, l_err_line_ids, l_err_header_ids;
5317:

Line 5375: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

5371: -- SQL Why : To find incorrect action
5372: -- SQL Join: processing_id, action, ppo_line_id
5373: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
5374: SET POATI.processing_id = -POATI.processing_id,
5375: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5376: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5377: AND POATI.action = 'DELETE'
5378: AND (
5379: -- the following are NOT NULL columns in the TXN table, so they must

Line 5376: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

5372: -- SQL Join: processing_id, action, ppo_line_id
5373: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
5374: SET POATI.processing_id = -POATI.processing_id,
5375: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5376: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5377: AND POATI.action = 'DELETE'
5378: AND (
5379: -- the following are NOT NULL columns in the TXN table, so they must
5380: -- have a not null value in the INTF table as well.