3356: l_progress := '020';
3357: BEGIN
3358: SELECT concatenated_segments
3359: INTO x_category_name
3360: FROM MTL_CATEGORIES_B_KFV
3361: WHERE category_id = p_category_id;
3362: EXCEPTION
3363: WHEN OTHERS THEN
3364: l_progress := '030';
3361: WHERE category_id = p_category_id;
3362: EXCEPTION
3363: WHEN OTHERS THEN
3364: l_progress := '030';
3365: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from MTL_CATEGORIES_B_KFV: '||SQLERRM); END IF;
3366:
3367: x_category_name := p_category_id;
3368: END;
3369: -- ECO bug 5584556: End
3524:
3525: l_validate_flag MTL_CATEGORY_SETS_V.validate_flag%TYPE;
3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;
3527:
3528: l_category_name MTL_CATEGORIES_B_KFV.concatenated_segments%TYPE;
3529:
3530: l_ip_category_name ICX_CAT_CATEGORIES_V.category_name%TYPE;
3531: l_ip_catgeory_found VARCHAR2(1);
3532: BEGIN