APPS.INV_ITEM_ATTRIBUTES_PKG dependencies on INV_ORGHIERARCHY_PVT

Line 85: g_org_tab INV_ORGHIERARCHY_PVT.orgid_tbl_type;

81: g_current_sel_index BINARY_INTEGER := 0;
82: g_empty_att_tab att_tbl_type;
83: g_empty_sel_tab sel_tbl_type;
84: g_itm_rec inv_item_grp.item_rec_type;
85: g_org_tab INV_ORGHIERARCHY_PVT.orgid_tbl_type;
86: g_current_org_index BINARY_INTEGER := 0;
87: g_empty_org_tab INV_ORGHIERARCHY_PVT.orgid_tbl_type;
88: g_count NUMBER := 0;
89: g_unit_test_mode BOOLEAN := FALSE;

Line 87: g_empty_org_tab INV_ORGHIERARCHY_PVT.orgid_tbl_type;

83: g_empty_sel_tab sel_tbl_type;
84: g_itm_rec inv_item_grp.item_rec_type;
85: g_org_tab INV_ORGHIERARCHY_PVT.orgid_tbl_type;
86: g_current_org_index BINARY_INTEGER := 0;
87: g_empty_org_tab INV_ORGHIERARCHY_PVT.orgid_tbl_type;
88: g_count NUMBER := 0;
89: g_unit_test_mode BOOLEAN := FALSE;
90: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_ATT_MTN';
91: G_SLEEP_TIME NUMBER := 15;

Line 413: INV_ORGHIERARCHY_PVT.Log

409: l_dff_w VARCHAR2(2000);
410: BEGIN
411:
412: IF G_DEBUG = 'Y' THEN
413: INV_ORGHIERARCHY_PVT.Log
414: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
415: , '> Build_Item_Cursor'
416: );
417: END IF;

Line 414: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

410: BEGIN
411:
412: IF G_DEBUG = 'Y' THEN
413: INV_ORGHIERARCHY_PVT.Log
414: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
415: , '> Build_Item_Cursor'
416: );
417: END IF;
418:

Line 444: INV_ORGHIERARCHY_PVT.Log

440: END IF;
441: END LOOP;
442:
443: IF G_DEBUG = 'Y' THEN
444: INV_ORGHIERARCHY_PVT.Log
445: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
446: , 'item flexfield segments:'||l_mstk_segs
447: );
448: END IF;

Line 445: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

441: END LOOP;
442:
443: IF G_DEBUG = 'Y' THEN
444: INV_ORGHIERARCHY_PVT.Log
445: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
446: , 'item flexfield segments:'||l_mstk_segs
447: );
448: END IF;
449:

Line 530: INV_ORGHIERARCHY_PVT.Log

526: l_sts_w ||
527: l_dff_w;
528:
529: IF G_DEBUG = 'Y' THEN
530: INV_ORGHIERARCHY_PVT.Log
531: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
532: , SUBSTR(x_item_cursor, 1, 250)
533: );
534: INV_ORGHIERARCHY_PVT.Log

Line 531: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

527: l_dff_w;
528:
529: IF G_DEBUG = 'Y' THEN
530: INV_ORGHIERARCHY_PVT.Log
531: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
532: , SUBSTR(x_item_cursor, 1, 250)
533: );
534: INV_ORGHIERARCHY_PVT.Log
535: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 534: INV_ORGHIERARCHY_PVT.Log

530: INV_ORGHIERARCHY_PVT.Log
531: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
532: , SUBSTR(x_item_cursor, 1, 250)
533: );
534: INV_ORGHIERARCHY_PVT.Log
535: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
536: , SUBSTR(x_item_cursor, 251, 500)
537: );
538: INV_ORGHIERARCHY_PVT.Log

Line 535: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

531: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
532: , SUBSTR(x_item_cursor, 1, 250)
533: );
534: INV_ORGHIERARCHY_PVT.Log
535: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
536: , SUBSTR(x_item_cursor, 251, 500)
537: );
538: INV_ORGHIERARCHY_PVT.Log
539: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 538: INV_ORGHIERARCHY_PVT.Log

534: INV_ORGHIERARCHY_PVT.Log
535: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
536: , SUBSTR(x_item_cursor, 251, 500)
537: );
538: INV_ORGHIERARCHY_PVT.Log
539: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
540: , SUBSTR(x_item_cursor, 501, 750)
541: );
542:

Line 539: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

535: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
536: , SUBSTR(x_item_cursor, 251, 500)
537: );
538: INV_ORGHIERARCHY_PVT.Log
539: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
540: , SUBSTR(x_item_cursor, 501, 750)
541: );
542:
543: INV_ORGHIERARCHY_PVT.Log

Line 543: INV_ORGHIERARCHY_PVT.Log

539: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
540: , SUBSTR(x_item_cursor, 501, 750)
541: );
542:
543: INV_ORGHIERARCHY_PVT.Log
544: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
545: , '< Build_Item_Cursor'
546: );
547: END IF;

Line 544: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

540: , SUBSTR(x_item_cursor, 501, 750)
541: );
542:
543: INV_ORGHIERARCHY_PVT.Log
544: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
545: , '< Build_Item_Cursor'
546: );
547: END IF;
548: EXCEPTION

Line 551: INV_ORGHIERARCHY_PVT.Log

547: END IF;
548: EXCEPTION
549: WHEN OTHERS THEN
550: IF G_DEBUG = 'Y' THEN
551: INV_ORGHIERARCHY_PVT.Log
552: ( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
553: , FND_FLEX_KEY_API.message
554: );
555: END IF;

Line 552: ( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

548: EXCEPTION
549: WHEN OTHERS THEN
550: IF G_DEBUG = 'Y' THEN
551: INV_ORGHIERARCHY_PVT.Log
552: ( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
553: , FND_FLEX_KEY_API.message
554: );
555: END IF;
556: RAISE;

Line 573: ,p_org_code_list IN INV_ORGHIERARCHY_PVT.orgid_tbl_type

569: /* Bug: 4025750
570: One more filter parameter p_copy_dff_to_null added to find items that need to be populated*/
571: PROCEDURE populate_temp_table
572: (p_item_id IN NUMBER
573: ,p_org_code_list IN INV_ORGHIERARCHY_PVT.orgid_tbl_type
574: ,p_cat_id IN NUMBER
575: ,p_cat_set_id IN NUMBER
576: ,p_item_low IN VARCHAR2
577: ,p_item_high IN VARCHAR2

Line 1005: INV_ORGHIERARCHY_PVT.Log

1001:
1002: WHILE l_item_cur%FOUND LOOP
1003:
1004: IF G_DEBUG = 'Y' THEN
1005: INV_ORGHIERARCHY_PVT.Log
1006: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1007: , 'Organization Code:' || l_organization_code || ' ' ||
1008: 'Organization Id:' || l_organization_id || ' ' ||
1009: 'Item Number:' || l_item_number || ' ' ||

Line 1006: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT

1002: WHILE l_item_cur%FOUND LOOP
1003:
1004: IF G_DEBUG = 'Y' THEN
1005: INV_ORGHIERARCHY_PVT.Log
1006: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1007: , 'Organization Code:' || l_organization_code || ' ' ||
1008: 'Organization Id:' || l_organization_id || ' ' ||
1009: 'Item Number:' || l_item_number || ' ' ||
1010: 'Inventory Item Id:' || l_inventory_item_id

Line 1207: ( p_org_tab OUT NOCOPY INV_ORGHIERARCHY_PVT.orgid_tbl_type

1203: -- COMMENT : Find the organizations that exist in the master org
1204: -- PRE-COND : called from form
1205: --=========================================================================
1206: PROCEDURE find_org_list
1207: ( p_org_tab OUT NOCOPY INV_ORGHIERARCHY_PVT.orgid_tbl_type
1208: )
1209: IS
1210:
1211: --================

Line 1318: INV_ORGHIERARCHY_PVT.Log

1314: l_error_count NUMBER;
1315: BEGIN
1316:
1317: IF G_DEBUG = 'Y' THEN
1318: INV_ORGHIERARCHY_PVT.Log
1319: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1320: , '> Determine_Return_Code'
1321: );
1322: END IF;

Line 1319: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1315: BEGIN
1316:
1317: IF G_DEBUG = 'Y' THEN
1318: INV_ORGHIERARCHY_PVT.Log
1319: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1320: , '> Determine_Return_Code'
1321: );
1322: END IF;
1323:

Line 1339: INV_ORGHIERARCHY_PVT.Log

1335: x_retcode := RETCODE_SUCCESS;
1336: x_errbuff := NULL;
1337: END IF;
1338: IF G_DEBUG = 'Y' THEN
1339: INV_ORGHIERARCHY_PVT.Log
1340: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1341: , '< Determine_Return_Code'
1342: );
1343: END IF;

Line 1340: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1336: x_errbuff := NULL;
1337: END IF;
1338: IF G_DEBUG = 'Y' THEN
1339: INV_ORGHIERARCHY_PVT.Log
1340: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1341: , '< Determine_Return_Code'
1342: );
1343: END IF;
1344:

Line 1364: INV_ORGHIERARCHY_PVT.Log

1360: l_result BOOLEAN;
1361: BEGIN
1362:
1363: IF G_DEBUG = 'Y' THEN
1364: INV_ORGHIERARCHY_PVT.Log
1365: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1366: , '> Has_Worker_Completed'
1367: );
1368: END IF;

Line 1365: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1361: BEGIN
1362:
1363: IF G_DEBUG = 'Y' THEN
1364: INV_ORGHIERARCHY_PVT.Log
1365: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1366: , '> Has_Worker_Completed'
1367: );
1368: END IF;
1369:

Line 1383: INV_ORGHIERARCHY_PVT.Log

1379: l_result := FALSE;
1380: END IF;
1381:
1382: IF G_DEBUG = 'Y' THEN
1383: INV_ORGHIERARCHY_PVT.Log
1384: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1385: , '< Has_Worker_Completed'
1386: );
1387: END IF;

Line 1384: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1380: END IF;
1381:
1382: IF G_DEBUG = 'Y' THEN
1383: INV_ORGHIERARCHY_PVT.Log
1384: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1385: , '< Has_Worker_Completed'
1386: );
1387: END IF;
1388:

Line 1411: INV_ORGHIERARCHY_PVT.Log

1407: l_done BOOLEAN;
1408: BEGIN
1409:
1410: IF G_DEBUG = 'Y' THEN
1411: INV_ORGHIERARCHY_PVT.Log
1412: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1413: , '> Wait_For_Worker'
1414: );
1415: END IF;

Line 1412: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1408: BEGIN
1409:
1410: IF G_DEBUG = 'Y' THEN
1411: INV_ORGHIERARCHY_PVT.Log
1412: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1413: , '> Wait_For_Worker'
1414: );
1415: END IF;
1416:

Line 1438: INV_ORGHIERARCHY_PVT.Log

1434:
1435: END LOOP;
1436:
1437: IF G_DEBUG = 'Y' THEN
1438: INV_ORGHIERARCHY_PVT.Log
1439: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1440: , '< Wait_For_Worker'
1441: );
1442: END IF;

Line 1439: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1435: END LOOP;
1436:
1437: IF G_DEBUG = 'Y' THEN
1438: INV_ORGHIERARCHY_PVT.Log
1439: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1440: , '< Wait_For_Worker'
1441: );
1442: END IF;
1443:

Line 1461: INV_ORGHIERARCHY_PVT.Log

1457: l_done BOOLEAN;
1458: BEGIN
1459:
1460: IF G_DEBUG = 'Y' THEN
1461: INV_ORGHIERARCHY_PVT.Log
1462: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1463: , '> Wait_For_All_Workers'
1464: );
1465: END IF;

Line 1462: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1458: BEGIN
1459:
1460: IF G_DEBUG = 'Y' THEN
1461: INV_ORGHIERARCHY_PVT.Log
1462: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1463: , '> Wait_For_All_Workers'
1464: );
1465: END IF;
1466:

Line 1489: INV_ORGHIERARCHY_PVT.Log

1485:
1486: END LOOP;
1487:
1488: IF G_DEBUG = 'Y' THEN
1489: INV_ORGHIERARCHY_PVT.Log
1490: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1491: , '< Wait_For_All_Workers'
1492: );
1493: END IF;

Line 1490: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1486: END LOOP;
1487:
1488: IF G_DEBUG = 'Y' THEN
1489: INV_ORGHIERARCHY_PVT.Log
1490: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1491: , '< Wait_For_All_Workers'
1492: );
1493: END IF;
1494:

Line 1521: INV_ORGHIERARCHY_PVT.Log

1517: l_request_id NUMBER;
1518: BEGIN
1519:
1520: IF G_DEBUG = 'Y' THEN
1521: INV_ORGHIERARCHY_PVT.Log
1522: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1523: , '> Submit_Item_Update'
1524: );
1525:

Line 1522: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1518: BEGIN
1519:
1520: IF G_DEBUG = 'Y' THEN
1521: INV_ORGHIERARCHY_PVT.Log
1522: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1523: , '> Submit_Item_Update'
1524: );
1525:
1526: INV_ORGHIERARCHY_PVT.Log

Line 1526: INV_ORGHIERARCHY_PVT.Log

1522: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1523: , '> Submit_Item_Update'
1524: );
1525:
1526: INV_ORGHIERARCHY_PVT.Log
1527: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1528: , 'x_workers.COUNT: '||TO_CHAR(x_workers.COUNT)
1529: );
1530: END IF;

Line 1527: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1523: , '> Submit_Item_Update'
1524: );
1525:
1526: INV_ORGHIERARCHY_PVT.Log
1527: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1528: , 'x_workers.COUNT: '||TO_CHAR(x_workers.COUNT)
1529: );
1530: END IF;
1531:

Line 1577: INV_ORGHIERARCHY_PVT.Log

1573:
1574: COMMIT;
1575:
1576: IF G_DEBUG = 'Y' THEN
1577: INV_ORGHIERARCHY_PVT.Log
1578: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1579: , '< Submit_Item_Update'
1580: );
1581: END IF;

Line 1578: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1574: COMMIT;
1575:
1576: IF G_DEBUG = 'Y' THEN
1577: INV_ORGHIERARCHY_PVT.Log
1578: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1579: , '< Submit_Item_Update'
1580: );
1581: END IF;
1582:

Line 1599: INV_ORGHIERARCHY_PVT.Log

1595: l_set_process_id NUMBER;
1596: BEGIN
1597:
1598: IF G_DEBUG = 'Y' THEN
1599: INV_ORGHIERARCHY_PVT.Log
1600: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1601: , '> Get_Set_Process_ID'
1602: );
1603: END IF;

Line 1600: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1596: BEGIN
1597:
1598: IF G_DEBUG = 'Y' THEN
1599: INV_ORGHIERARCHY_PVT.Log
1600: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1601: , '> Get_Set_Process_ID'
1602: );
1603: END IF;
1604:

Line 1610: INV_ORGHIERARCHY_PVT.Log

1606: INTO l_set_process_id
1607: FROM dual;
1608:
1609: IF G_DEBUG = 'Y' THEN
1610: INV_ORGHIERARCHY_PVT.Log
1611: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1612: , '< Get_Set_Process_ID'
1613: );
1614: END IF;

Line 1611: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1607: FROM dual;
1608:
1609: IF G_DEBUG = 'Y' THEN
1610: INV_ORGHIERARCHY_PVT.Log
1611: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1612: , '< Get_Set_Process_ID'
1613: );
1614: END IF;
1615:

Line 1761: INV_ORGHIERARCHY_PVT.Log_Initialize;

1757: l_app_info_status BOOLEAN;
1758:
1759: BEGIN
1760:
1761: INV_ORGHIERARCHY_PVT.Log_Initialize;
1762:
1763: IF G_DEBUG = 'Y' THEN
1764: INV_ORGHIERARCHY_PVT.Log
1765: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

Line 1764: INV_ORGHIERARCHY_PVT.Log

1760:
1761: INV_ORGHIERARCHY_PVT.Log_Initialize;
1762:
1763: IF G_DEBUG = 'Y' THEN
1764: INV_ORGHIERARCHY_PVT.Log
1765: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1766: , '> Batch Item Update'
1767: );
1768: END IF;

Line 1765: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1761: INV_ORGHIERARCHY_PVT.Log_Initialize;
1762:
1763: IF G_DEBUG = 'Y' THEN
1764: INV_ORGHIERARCHY_PVT.Log
1765: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1766: , '> Batch Item Update'
1767: );
1768: END IF;
1769:

Line 1827: INV_ORGHIERARCHY_PVT.Log

1823: , 1000
1824: );
1825:
1826: IF G_DEBUG = 'Y' THEN
1827: INV_ORGHIERARCHY_PVT.Log
1828: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1829: , 'l_max_batch_size: '||TO_CHAR(l_max_batch_size)
1830: );
1831: END IF;

Line 1828: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1824: );
1825:
1826: IF G_DEBUG = 'Y' THEN
1827: INV_ORGHIERARCHY_PVT.Log
1828: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1829: , 'l_max_batch_size: '||TO_CHAR(l_max_batch_size)
1830: );
1831: END IF;
1832:

Line 1842: INV_ORGHIERARCHY_PVT.Log

1838: , 1
1839: );
1840:
1841: IF G_DEBUG = 'Y' THEN
1842: INV_ORGHIERARCHY_PVT.Log
1843: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1844: , 'l_request_count: '||TO_CHAR(l_request_count)
1845: );
1846: END IF;

Line 1843: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1839: );
1840:
1841: IF G_DEBUG = 'Y' THEN
1842: INV_ORGHIERARCHY_PVT.Log
1843: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1844: , 'l_request_count: '||TO_CHAR(l_request_count)
1845: );
1846: END IF;
1847:

Line 1999: INV_ORGHIERARCHY_PVT.Log

1995: EXECUTE IMMEDIATE l_dml_str
1996: USING l_current_att_index, p_seq_id, l_set_process_id;
1997:
1998: IF G_DEBUG = 'Y' THEN
1999: INV_ORGHIERARCHY_PVT.Log
2000: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2001: , 'Update Complete'
2002: );
2003: END IF;

Line 2000: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1996: USING l_current_att_index, p_seq_id, l_set_process_id;
1997:
1998: IF G_DEBUG = 'Y' THEN
1999: INV_ORGHIERARCHY_PVT.Log
2000: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2001: , 'Update Complete'
2002: );
2003: END IF;
2004:

Line 2022: INV_ORGHIERARCHY_PVT.Log

2018: ,l_workers_tbl
2019: ,l_request_count);
2020:
2021: IF G_DEBUG = 'Y' THEN
2022: INV_ORGHIERARCHY_PVT.Log
2023: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2024: , 'Submit done'
2025: );
2026: END IF;

Line 2023: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2019: ,l_request_count);
2020:
2021: IF G_DEBUG = 'Y' THEN
2022: INV_ORGHIERARCHY_PVT.Log
2023: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2024: , 'Submit done'
2025: );
2026: END IF;
2027:

Line 2056: INV_ORGHIERARCHY_PVT.Log

2052: , x_errbuff => x_errbuff
2053: );
2054:
2055: IF G_DEBUG = 'Y' THEN
2056: INV_ORGHIERARCHY_PVT.Log
2057: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2058: , '< Batch Item Update'
2059: );
2060: END IF;

Line 2057: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2053: );
2054:
2055: IF G_DEBUG = 'Y' THEN
2056: INV_ORGHIERARCHY_PVT.Log
2057: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2058: , '< Batch Item Update'
2059: );
2060: END IF;
2061: