APPS.FII_GL_EXTRACTION_UTIL dependencies on FII_GL_EXTRACTION_UTIL

Line 1: PACKAGE BODY FII_GL_EXTRACTION_UTIL AS

1: PACKAGE BODY FII_GL_EXTRACTION_UTIL AS
2: /* $Header: FIIGLXUB.pls 120.3 2005/08/16 14:19:19 arcdixit noship $ */
3:
4: g_debug_flag varchar2(1) :=
5: nvl( fnd_profile.value( 'FII_DEBUG_MODE' ), 'N' );

Line 23: FII_MESSAGE.Func_Ent('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');

19:
20: BEGIN
21:
22: if g_debug_flag = 'Y' then
23: FII_MESSAGE.Func_Ent('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');
24: end if;
25:
26: -- set output parameters to no error by default
27:

Line 41: FII_MESSAGE.Func_Succ('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');

37:
38: if l_count > 0 then
39: if g_debug_flag = 'Y' then
40: fii_util.put_line( 'Detected ' || l_count || ' rows' );
41: FII_MESSAGE.Func_Succ('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');
42: end if;
43:
44: return;
45: end if;

Line 91: FII_MESSAGE.Func_Succ('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');

87: l_count := sql%rowcount;
88:
89: if g_debug_flag = 'Y' then
90: fii_util.put_line( 'Inserted ' || l_count || ' rows' );
91: FII_MESSAGE.Func_Succ('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');
92: end if;
93:
94: commit;
95:

Line 113: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');

109: -- set output parameters
110:
111: p_retcode := g_retcode;
112:
113: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR');
114:
115: raise;
116:
117: END LOAD_CCC_MGR;

Line 142: FII_MESSAGE.Func_Ent('FII_GL_EXTRACTION_UTIL.CHECK_MISSING_CCC_MGR');

138:
139: BEGIN
140:
141: if g_debug_flag = 'Y' then
142: FII_MESSAGE.Func_Ent('FII_GL_EXTRACTION_UTIL.CHECK_MISSING_CCC_MGR');
143: end if;
144:
145: load_ccc_mgr ( l_retcode ); -- in case fii_ccc_mgr_gt has not been loaded
146:

Line 169: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.CHECK_MISSING_CCC_MGR');

165: fii_util.write_output( missing_csr_rec.name );
166: end loop;
167:
168: if g_debug_flag = 'Y' then
169: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.CHECK_MISSING_CCC_MGR');
170: end if;
171:
172: return l_count;
173:

Line 186: FII_MESSAGE.Func_Ent('FII_GL_EXTRACTION_UTIL.GET_UNASSIGNED_ID');

182:
183: BEGIN
184:
185: if g_debug_flag = 'Y' then
186: FII_MESSAGE.Func_Ent('FII_GL_EXTRACTION_UTIL.GET_UNASSIGNED_ID');
187: end if;
188:
189: g_state := 'Getting the unassigned id and value set id';
190:

Line 203: FII_MESSAGE.Func_Succ('FII_GL_EXTRACTION_UTIL.GET_UNASSIGNED_ID');

199:
200: g_state := 'Retreived the unassigned id and value set id ';
201:
202: if g_debug_flag = 'Y' then
203: FII_MESSAGE.Func_Succ('FII_GL_EXTRACTION_UTIL.GET_UNASSIGNED_ID');
204: end if;
205:
206:
207: EXCEPTION

Line 221: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.Get_UNASSIGNED_ID');

217: fii_util.put_line( g_exception_msg );
218:
219: -- set output parameters
220: p_retcode := g_retcode;
221: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.Get_UNASSIGNED_ID');
222:
223: when others then
224: -- set global variables
225:

Line 235: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.Get_UNASSIGNED_ID');

231: fii_util.put_line( g_exception_msg );
232:
233: -- set output parameters
234: p_retcode := g_retcode;
235: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.Get_UNASSIGNED_ID');
236:
237: END GET_UNASSIGNED_ID;
238:
239: END FII_GL_EXTRACTION_UTIL;

Line 239: END FII_GL_EXTRACTION_UTIL;

235: FII_MESSAGE.Func_Fail('FII_GL_EXTRACTION_UTIL.Get_UNASSIGNED_ID');
236:
237: END GET_UNASSIGNED_ID;
238:
239: END FII_GL_EXTRACTION_UTIL;