DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on ICX_CAT_POPULATE_ITEM_PVT

Line 1: PACKAGE BODY ICX_CAT_POPULATE_ITEM_PVT AS

1: PACKAGE BODY ICX_CAT_POPULATE_ITEM_PVT AS
2: /* $Header: ICXVPPIB.pls 120.14.12010000.2 2008/08/02 14:39:01 kkram ship $*/
3:
4: -- Constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_ITEM_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_ITEM_PVT';

1: PACKAGE BODY ICX_CAT_POPULATE_ITEM_PVT AS
2: /* $Header: ICXVPPIB.pls 120.14.12010000.2 2008/08/02 14:39:01 kkram ship $*/
3:
4: -- Constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_ITEM_PVT';
6: gTotalRowCount PLS_INTEGER := 0;
7: TYPE g_csr_type IS REF CURSOR;
8:
9: ----------------------------------------------------

Line 4333: l_err_string := 'ICX_CAT_POPULATE_ITEM_PVT.purgeInvalidCategoryItems' ||l_err_loc;

4329: l_err_loc := 1750;
4330: EXIT WHEN l_po_category_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
4331: EXCEPTION
4332: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
4333: l_err_string := 'ICX_CAT_POPULATE_ITEM_PVT.purgeInvalidCategoryItems' ||l_err_loc;
4334: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
4335: CLOSE l_invalid_category_csr;
4336: openInvalidCategoryCsr(l_invalid_category_csr);
4337: END;

Line 4876: END ICX_CAT_POPULATE_ITEM_PVT;

4872: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
4873: RAISE;
4874: END rebuildIPIntermediaIndex;
4875:
4876: END ICX_CAT_POPULATE_ITEM_PVT;