eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_CC_MGR_SUP_C dependencies on FII_UTIL

Line 27: FII_UTIL.put_line('');

23:
24: l_stmt:='truncate table '||g_fii_schema||'.'|| p_table_name;
25:
26: if g_debug_flag = 'Y' then
27: FII_UTIL.put_line('');
28: FII_UTIL.put_line(l_stmt);
29: end if;
30:
31: execute immediate l_stmt;

Line 28: FII_UTIL.put_line(l_stmt);

24: l_stmt:='truncate table '||g_fii_schema||'.'|| p_table_name;
25:
26: if g_debug_flag = 'Y' then
27: FII_UTIL.put_line('');
28: FII_UTIL.put_line(l_stmt);
29: end if;
30:
31: execute immediate l_stmt;
32:

Line 35: FII_UTIL.put_line('

31: execute immediate l_stmt;
32:
33: Exception
34: WHEN OTHERS THEN
35: FII_UTIL.put_line('
36: Error in Procedure: TRUNCATE_TABLE
37: Message: '||sqlerrm);
38: RAISE;
39: End truncate_Table;

Line 67: l_dir := FII_UTIL.get_utl_file_dir ;

63: -- Set default directory in case if the profile option
64: -- BIS_DEBUG_LOG_DIRECTORY is not set up
65: ------------------------------------------------------
66: if l_dir is NULL then
67: l_dir := FII_UTIL.get_utl_file_dir ;
68: end if;
69:
70: ----------------------------------------------------------------
71: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

Line 71: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

67: l_dir := FII_UTIL.get_utl_file_dir ;
68: end if;
69:
70: ----------------------------------------------------------------
71: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
72: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
73: -- the log files and output files are written to
74: ----------------------------------------------------------------
75: FII_UTIL.initialize ('FII_CC_MGR_SUP_C.log',

Line 75: FII_UTIL.initialize ('FII_CC_MGR_SUP_C.log',

71: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
72: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
73: -- the log files and output files are written to
74: ----------------------------------------------------------------
75: FII_UTIL.initialize ('FII_CC_MGR_SUP_C.log',
76: 'FII_CC_MGR_SUP_C.out',l_dir, 'FII_GL_COMCCH_C');
77:
78: ----------------------------------------------------------
79: -- Find the schema owner of FII

Line 81: g_fii_schema := FII_UTIL.get_schema_name ('FII');

77:
78: ----------------------------------------------------------
79: -- Find the schema owner of FII
80: ----------------------------------------------------------
81: g_fii_schema := FII_UTIL.get_schema_name ('FII');
82:
83: g_fii_user_id := FND_GLOBAL.User_Id;
84: g_fii_login_id := FND_GLOBAL.Login_Id;
85: IF (g_fii_user_id IS NULL OR g_fii_login_id IS NULL) THEN

Line 90: FII_UTIL.put_line('User ID: ' || g_fii_user_id ||

86: RAISE G_LOGIN_INFO_NOT_AVABLE;
87: END IF;
88:
89: if g_debug_flag = 'Y' then
90: FII_UTIL.put_line('User ID: ' || g_fii_user_id ||
91: ' Login ID: ' || g_fii_login_id);
92: end if;
93:
94: if g_debug_flag = 'Y' then

Line 100: FII_UTIL.put_line('Can not get User ID and Login ID, program exit');

96: end if;
97:
98: EXCEPTION
99: WHEN G_LOGIN_INFO_NOT_AVABLE THEN
100: FII_UTIL.put_line('Can not get User ID and Login ID, program exit');
101: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');
102: raise;
103:
104: WHEN OTHERS THEN

Line 105: FII_UTIL.put_line('

101: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');
102: raise;
103:
104: WHEN OTHERS THEN
105: FII_UTIL.put_line('
106: Error in Procedure: INIT
107: Phase: '||g_phase||'
108: Message: '||sqlerrm);
109: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');

Line 137: FII_UTIL.put_line('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');

133:
134: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
135:
136: IF l_status = -1 then
137: FII_UTIL.put_line('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
138: FII_UTIL.put_line('Table FII_CCC_MGR_GT is not populated');
139: raise NO_DATA_FOUND;
140: END IF;
141:

Line 138: FII_UTIL.put_line('Table FII_CCC_MGR_GT is not populated');

134: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
135:
136: IF l_status = -1 then
137: FII_UTIL.put_line('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
138: FII_UTIL.put_line('Table FII_CCC_MGR_GT is not populated');
139: raise NO_DATA_FOUND;
140: END IF;
141:
142: --First, join the fii_ccc_mgr_gt table with hri_cs_suph to

Line 162: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_PERSON_ID_TMP');

158: and suph.sup_assignment_status_type_id = ast.assignment_status_type_id
159: and ast.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
160:
161: if g_debug_flag = 'Y' then
162: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_PERSON_ID_TMP');
163: end if;
164:
165: ----------------------------------------------------------
166: --Begin to populate the table FII_CC_MGR_HIER_GT

Line 168: FII_UTIL.start_timer;

164:
165: ----------------------------------------------------------
166: --Begin to populate the table FII_CC_MGR_HIER_GT
167: ----------------------------------------------------------
168: FII_UTIL.start_timer;
169: g_phase := 'Truncate table FII_CC_MGR_HIER_GT';
170:
171: TRUNCATE_TABLE ('FII_CC_MGR_HIER_GT');
172:

Line 216: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||

212:
213: ---------------------------------------------------------------
214:
215: if g_debug_flag = 'Y' then
216: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
217: ' rows of data into FII_CC_MGR_HIER_GT table');
218: end if;
219:
220: --Set mgr_id to -999 and mgr_level to 0 for records of

Line 231: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');

227: Where mgr_level = 1
228: and direct_level = 1;
229:
230: if g_debug_flag = 'Y' then
231: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');
232: end if;
233:
234: --Insert all self records (using mgr_id = -999)
235: g_phase := 'Insert all self records';

Line 261: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_MGR_HIER_GT');

257: from FII_CC_MGR_HIER_GT
258: where mgr_id = -999;
259:
260: if g_debug_flag = 'Y' then
261: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_MGR_HIER_GT');
262: end if;
263:
264: --Update the column next_level_is_leaf
265: g_phase := 'Update column next_level_is_leaf...';

Line 277: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');

273: where tab2.mgr_id = tab1.direct_id
274: and tab2.aggregation_flag = 'Y');
275:
276: if g_debug_flag = 'Y' then
277: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');
278: end if;
279:
280: --Update the column is_leaf_flag
281: g_phase := 'Update column is_leaf_flag...';

Line 290: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');

286: and direct_id = emp_id
287: and next_level_is_leaf = 'Y';
288:
289: if g_debug_flag = 'Y' then
290: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');
291: end if;
292:
293: FII_UTIL.stop_timer;
294:

Line 293: FII_UTIL.stop_timer;

289: if g_debug_flag = 'Y' then
290: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');
291: end if;
292:
293: FII_UTIL.stop_timer;
294:
295: if g_debug_flag = 'Y' then
296: FII_UTIL.print_timer('Duration');
297: end if;

Line 296: FII_UTIL.print_timer('Duration');

292:
293: FII_UTIL.stop_timer;
294:
295: if g_debug_flag = 'Y' then
296: FII_UTIL.print_timer('Duration');
297: end if;
298:
299: if g_debug_flag = 'Y' then
300: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Populate_HIER_TMP');

Line 306: FII_UTIL.put_line('Error in phase ' || g_phase ||

302:
303: Exception
304:
305: WHEN OTHERS Then
306: FII_UTIL.put_line('Error in phase ' || g_phase ||
307: ' of running FII_CC_MGR_SUP_C.Populate_HIER_TMP; '
308: || 'Message: ' || sqlerrm);
309: ROLLBACK;
310: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Populate_HIER_TMP');

Line 340: FII_UTIL.start_timer;

336: --by diff FII_CC_MGR_HIER_GT and FII_CC_MGR_HIERARCHIES
337: --for incremental update
338: ----------------------------------------------------------
339:
340: FII_UTIL.start_timer;
341:
342: g_phase := 'DELETE FROM FII_CC_MGR_HIERARCHIES';
343:
344: DELETE FROM FII_CC_MGR_HIERARCHIES

Line 357: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_CC_MGR_HIERARCHIES');

353: FROM FII_CC_MGR_HIER_GT
354: WHERE aggregation_flag = 'Y');
355:
356: if g_debug_flag = 'Y' then
357: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_CC_MGR_HIERARCHIES');
358: end if;
359:
360: g_phase := 'INSERT INTO FII_CC_MGR_HIERARCHIES';
361:

Line 410: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||

406:
407: ---------------------------------------------------------------
408:
409: if g_debug_flag = 'Y' then
410: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
411: ' rows of data into FII_CC_MGR_HIERARCHIES table');
412: end if;
413:
414: --Call FND_STATS to collect statistics after re-populating the tables.

Line 428: FII_UTIL.stop_timer;

424: tabname => 'MLOG$_FII_CC_MGR_HIERARCHI');
425:
426: FND_CONCURRENT.Af_Commit;
427:
428: FII_UTIL.stop_timer;
429:
430: if g_debug_flag = 'Y' then
431: FII_UTIL.print_timer('Duration');
432: end if;

Line 431: FII_UTIL.print_timer('Duration');

427:
428: FII_UTIL.stop_timer;
429:
430: if g_debug_flag = 'Y' then
431: FII_UTIL.print_timer('Duration');
432: end if;
433:
434: if g_debug_flag = 'Y' then
435: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Incre_Update');

Line 445: FII_UTIL.put_line('

441:
442: WHEN OTHERS Then
443: errbuf := SQLERRM;
444: retcode := SQLCODE;
445: FII_UTIL.put_line('
446: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Incre_Update; '
447: || 'Message: ' || sqlerrm);
448: ROLLBACK;
449: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Incre_Update');

Line 518: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||

514:
515: ---------------------------------------------------------------
516:
517: if g_debug_flag = 'Y' then
518: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
519: ' rows of data into FII_CC_MGR_HIERARCHIES table');
520: end if;
521:
522: --Call FND_STATS to collect statistics after re-populating the tables.

Line 536: FII_UTIL.stop_timer;

532: tabname => 'MLOG$_FII_CC_MGR_HIERARCHI');
533:
534: FND_CONCURRENT.Af_Commit;
535:
536: FII_UTIL.stop_timer;
537:
538: if g_debug_flag = 'Y' then
539: FII_UTIL.print_timer('Duration');
540: end if;

Line 539: FII_UTIL.print_timer('Duration');

535:
536: FII_UTIL.stop_timer;
537:
538: if g_debug_flag = 'Y' then
539: FII_UTIL.print_timer('Duration');
540: end if;
541:
542: if g_debug_flag = 'Y' then
543: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Init_Load');

Line 552: FII_UTIL.put_line('

548: Exception
549: WHEN OTHERS THEN
550: errbuf := SQLERRM;
551: retcode := SQLCODE;
552: FII_UTIL.put_line('
553: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Init_Load; '
554: || 'Message: ' || sqlerrm);
555: ROLLBACK;
556: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Init_Load');