APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 740: l_shopping_category icx_cat_categories_tl.key%TYPE;

736: l_params xml_bind_params;
737: x_result CLOB;
738: l_attr_list varchar2(18000);
739: l_progress PLS_INTEGER;
740: l_shopping_category icx_cat_categories_tl.key%TYPE;
741: l_att_list_qry varchar2(20000);
742: l_log_string varchar2(400);
743: l_module_name varchar2(200);
744: l_start_date DATE;

Line 789: FROM icx_cat_categories_tl icat

785: l_progress := 120;
786: BEGIN
787: SELECT distinct icat.key
788: INTO l_shopping_category
789: FROM icx_cat_categories_tl icat
790: WHERE icat.rt_category_id = p_category_id;
791: EXCEPTION
792: when no_data_found then
793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 794: l_log_string := 'generate_lines_section:'||'No data found in icx_cat_categories_tl'||

790: WHERE icat.rt_category_id = p_category_id;
791: EXCEPTION
792: when no_data_found then
793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: l_log_string := 'generate_lines_section:'||'No data found in icx_cat_categories_tl'||
795: 'Assigning '' '' to shopping category for category id :'||p_category_id;
796: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name);
797: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);
798: END IF;