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.25 2011/05/06 09:41:51 mmaramga 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.25 2011/05/06 09:41:51 mmaramga 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 4358: l_err_string := 'ICX_CAT_POPULATE_ITEM_PVT.purgeInvalidCategoryItems' ||l_err_loc;

4354: l_err_loc := 1750;
4355: EXIT WHEN l_po_category_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
4356: EXCEPTION
4357: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
4358: l_err_string := 'ICX_CAT_POPULATE_ITEM_PVT.purgeInvalidCategoryItems' ||l_err_loc;
4359: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
4360: CLOSE l_invalid_category_csr;
4361: openInvalidCategoryCsr(l_invalid_category_csr);
4362: END;

Line 4901: END ICX_CAT_POPULATE_ITEM_PVT;

4897: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
4898: RAISE;
4899: END rebuildIPIntermediaIndex;
4900:
4901: END ICX_CAT_POPULATE_ITEM_PVT;