APPS.ICX_CAT_POPULATE_MI_PVT dependencies on ICX_CAT_POPULATE_MI_PVT

Line 1: PACKAGE BODY ICX_CAT_POPULATE_MI_PVT AS

1: PACKAGE BODY ICX_CAT_POPULATE_MI_PVT AS
2: /* $Header: ICXVPPMB.pls 120.8.12010000.2 2008/08/02 14:39:28 kkram ship $*/
3:
4: --Will have the MI cursors
5: --for pre-upgrade, upgrade and online populate

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_MI_PVT';

6:
7: --Both will call icx_cat_populate_item_pvt.populatePODocs
8:
9: -- Constants
10: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_MI_PVT';
11:
12: g_upgrade_last_run_date DATE;
13: g_online_mode VARCHAR2(15) := null;
14: g_onlineUpdate_mode VARCHAR2(15) := 'OnlineUpdate';

Line 1271: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc

1267: l_err_loc := 1400;
1268: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1269: EXCEPTION
1270: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1271: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1272: ||', Total processeded batches:' ||l_batch_count
1273: ||', Cursor will be reopened with inventory_item_id:' ||l_start_inv_item_id;
1274: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1275: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 1503: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc

1499: l_err_loc := 1300;
1500: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1501: EXCEPTION
1502: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1503: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc
1504: ||', Total processeded batches:' ||l_batch_count
1505: ||', Cursor will be reopened;';
1506: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1507: l_err_loc := 1400;

Line 1645: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN

1641: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForMIs';
1642: l_err_loc PLS_INTEGER;
1643: BEGIN
1644: l_err_loc := 100;
1645: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN
1646: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1648: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1649: 'about to call buildmetadatinfo');

Line 1656: ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed := TRUE;

1652: l_err_loc := 200;
1653: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
1654: (0, g_special_metadata_tbl, g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl);
1655: l_err_loc := 300;
1656: ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed := TRUE;
1657: END IF;
1658:
1659: l_err_loc := 400;
1660: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN

Line 1660: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN

1656: ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed := TRUE;
1657: END IF;
1658:
1659: l_err_loc := 400;
1660: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN
1661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1663: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1664: 'about to call buildctxsql');

Line 1672: ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed := TRUE;

1668: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'NOTROWID', g_special_metadata_tbl,
1669: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
1670: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
1671: l_err_loc := 600;
1672: ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed := TRUE;
1673: END IF;
1674:
1675: l_err_loc := 700;
1676: p_special_ctx_sql_tbl := g_special_ctx_sql_tbl;

Line 1688: END ICX_CAT_POPULATE_MI_PVT;

1684: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1685: RAISE;
1686: END buildCtxSqlForMIs;
1687:
1688: END ICX_CAT_POPULATE_MI_PVT;