APPS.FII_FA_CAT_C dependencies on FII_FA_CAT_C

Line 1: PACKAGE BODY FII_FA_CAT_C AS

1: PACKAGE BODY FII_FA_CAT_C AS
2: /* $Header: FIIFACATB.pls 120.1 2005/10/30 05:06:01 appldev noship $ */
3:
4: g_debug_flag Varchar2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
5:

Line 32: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.INIT_DBI_CHANGE_LOG';

28: -- PROCEDURE INIT_DBI_CHANGE_LOG
29: -- ---------------------------------------------------------------
30: PROCEDURE INIT_DBI_CHANGE_LOG IS
31:
32: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.INIT_DBI_CHANGE_LOG';
33:
34: BEGIN
35:
36: If g_debug_flag = 'Y' then

Line 94: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.GET_STRUCTURE_NAME';

90: -------------------------------------------------------
91: FUNCTION GET_STRUCTURE_NAME (p_structure_id IN NUMBER) RETURN VARCHAR2 IS
92:
93: l_structure_name VARCHAR2(30);
94: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.GET_STRUCTURE_NAME';
95:
96: BEGIN
97: If g_debug_flag = 'Y' then
98: FII_MESSAGE.Func_Ent(l_calling_fn);

Line 157: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.GET_CAT_SEGMENTS';

153: l_structure_name VARCHAR2(30);
154: l_flex_structure_id NUMBER;
155: l_parent_value_set_id NUMBER;
156: l_dependant_value_set_flag VARCHAR2(1) := 'N';
157: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.GET_CAT_SEGMENTS';
158:
159: error_found exception;
160:
161:

Line 499: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.INSERT_INTO_CAT';

495: l_minor_id_seq_tbl num_tbl;
496: l_minor_value_tbl v30_tbl;
497:
498: l_stmt long;
499: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.INSERT_INTO_CAT';
500:
501: BEGIN
502:
503: If g_debug_flag = 'Y' then

Line 770: l_calling_fn varchar2(40) := 'FII_FA_CAT_C.RECORD_MAX_PROCESSED_CAT_ID';

766: ------------------------------------------------------------------
767: PROCEDURE RECORD_MAX_PROCESSED_CAT_ID IS
768:
769: l_tmp_max_cat_id NUMBER;
770: l_calling_fn varchar2(40) := 'FII_FA_CAT_C.RECORD_MAX_PROCESSED_CAT_ID';
771:
772: BEGIN
773:
774: If g_debug_flag = 'Y' then

Line 856: l_calling_fn varchar2(40) := 'FII_FA_CAT_C.NEW_CAT_IN_FA';

852: -- FUNCTION NEW_CAT_IN_FA
853: ------------------------------------------------------------------
854: FUNCTION NEW_CAT_IN_FA RETURN BOOLEAN IS
855:
856: l_calling_fn varchar2(40) := 'FII_FA_CAT_C.NEW_CAT_IN_FA';
857:
858: BEGIN
859:
860: If g_debug_flag = 'Y' then

Line 1395: END FII_FA_CAT_C;

1391: ret_val := FND_CONCURRENT.Set_Completion_Status
1392: (status => 'ERROR', message => substr(sqlerrm,1,180));
1393: END MAIN;
1394:
1395: END FII_FA_CAT_C;