APPS.FII_GL_EXTRACTION_UTIL dependencies on FII_UTIL

Line 40: fii_util.put_line( 'Detected ' || l_count || ' rows' );

36: select count(*) into l_count from fii_ccc_mgr_gt;
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;

Line 48: fii_util.put_line( 'Populating fii_ccc_mgr_gt' );

44: return;
45: end if;
46:
47: if g_debug_flag = 'Y' then
48: fii_util.put_line( 'Populating fii_ccc_mgr_gt' );
49: end if;
50:
51: /* Table fii_ccc_mgr_gt has a row for each ccc_org_id.
52: Column manager is the ID of the current manager of a ccc_org_id.

Line 90: fii_util.put_line( 'Inserted ' || l_count || ' rows' );

86:
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;

Line 106: fii_util.put_line( 'Error occured while ' || g_state );

102: g_errbuf := sqlerrm;
103: g_retcode := -1;
104: g_exception_msg := g_retcode || ':' || g_errbuf;
105:
106: fii_util.put_line( 'Error occured while ' || g_state );
107: fii_util.put_line( g_exception_msg );
108:
109: -- set output parameters
110:

Line 107: fii_util.put_line( g_exception_msg );

103: g_retcode := -1;
104: g_exception_msg := g_retcode || ':' || g_errbuf;
105:
106: fii_util.put_line( 'Error occured while ' || g_state );
107: fii_util.put_line( g_exception_msg );
108:
109: -- set output parameters
110:
111: p_retcode := g_retcode;

Line 165: fii_util.write_output( missing_csr_rec.name );

161: fii_message.write_output( msg_name => 'FII_CCC_ORG_LIST',
162: token_num => 0 );
163: END IF;
164:
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');

Line 216: fii_util.put_line( 'Error occured while ' || g_state );

212: g_errbuf := sqlerrm;
213: g_retcode := -1;
214: g_exception_msg := g_retcode || ':' || g_errbuf;
215:
216: fii_util.put_line( 'Error occured while ' || g_state );
217: fii_util.put_line( g_exception_msg );
218:
219: -- set output parameters
220: p_retcode := g_retcode;

Line 217: fii_util.put_line( g_exception_msg );

213: g_retcode := -1;
214: g_exception_msg := g_retcode || ':' || g_errbuf;
215:
216: fii_util.put_line( 'Error occured while ' || g_state );
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');

Line 230: fii_util.put_line( 'Error occured while ' || g_state );

226: g_errbuf := sqlerrm;
227: g_retcode := -1;
228: g_exception_msg := g_retcode || ':' || g_errbuf;
229:
230: fii_util.put_line( 'Error occured while ' || g_state );
231: fii_util.put_line( g_exception_msg );
232:
233: -- set output parameters
234: p_retcode := g_retcode;

Line 231: fii_util.put_line( g_exception_msg );

227: g_retcode := -1;
228: g_exception_msg := g_retcode || ':' || g_errbuf;
229:
230: fii_util.put_line( 'Error occured while ' || g_state );
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');