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_GL_COMCCH_C dependencies on FII_UTIL

Line 75: fii_util.write_log('Printing out company cost_center with multiple orgs in table FII_COM_CC_MAPPINGS_GT');

71:
72: l_count := 0;
73: FOR r_dup_org IN c_duplicate_org LOOP
74: if l_count = 0 then
75: fii_util.write_log('Printing out company cost_center with multiple orgs in table FII_COM_CC_MAPPINGS_GT');
76: fii_util.write_log('');
77: fii_util.write_log ('- Company (ID) --- Cost Center (ID) --- Organization (ID) -');
78: end if;
79:

Line 76: fii_util.write_log('');

72: l_count := 0;
73: FOR r_dup_org IN c_duplicate_org LOOP
74: if l_count = 0 then
75: fii_util.write_log('Printing out company cost_center with multiple orgs in table FII_COM_CC_MAPPINGS_GT');
76: fii_util.write_log('');
77: fii_util.write_log ('- Company (ID) --- Cost Center (ID) --- Organization (ID) -');
78: end if;
79:
80: l_count := l_count + 1;

Line 77: fii_util.write_log ('- Company (ID) --- Cost Center (ID) --- Organization (ID) -');

73: FOR r_dup_org IN c_duplicate_org LOOP
74: if l_count = 0 then
75: fii_util.write_log('Printing out company cost_center with multiple orgs in table FII_COM_CC_MAPPINGS_GT');
76: fii_util.write_log('');
77: fii_util.write_log ('- Company (ID) --- Cost Center (ID) --- Organization (ID) -');
78: end if;
79:
80: l_count := l_count + 1;
81: FOR r_list_org IN c_list_dup_org (r_dup_org.company_id, r_dup_org.cost_center_id) LOOP

Line 82: fii_util.write_log (r_list_org.company || ' (' || r_dup_org.company_id || ') ' ||

78: end if;
79:
80: l_count := l_count + 1;
81: FOR r_list_org IN c_list_dup_org (r_dup_org.company_id, r_dup_org.cost_center_id) LOOP
82: fii_util.write_log (r_list_org.company || ' (' || r_dup_org.company_id || ') ' ||
83: r_list_org.cost_center || ' (' || r_dup_org.cost_center_id || ') ' ||
84: r_list_org.organization|| ' (' || r_list_org.org_id || ')');
85: END LOOP;
86: END LOOP;

Line 95: fii_util.write_log('

91:
92: EXCEPTION
93: WHEN OTHERS THEN
94: g_retcode := -1;
95: fii_util.write_log('
96: -----------------------------
97: Error occured in Procedure: PRINT_DUP_ORG_IN_TEMP
98: Message: ' || sqlerrm);
99: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.PRINT_DUP_ORG_IN_TEMP');

Line 142: fii_util.write_log('Printing out employee with multiple managers in table FII_CC_MGR_HIER_GT at level ' || G_AGGREGATION_LEVELS);

138:
139: l_count := 0;
140: FOR r_dup_mgr IN c_duplicate_mgr LOOP
141: if l_count = 0 then
142: fii_util.write_log('Printing out employee with multiple managers in table FII_CC_MGR_HIER_GT at level ' || G_AGGREGATION_LEVELS);
143: fii_util.write_log('');
144: fii_util.write_log ('- Employee ID --- Manager ID --- Employee Level -');
145: end if;
146:

Line 143: fii_util.write_log('');

139: l_count := 0;
140: FOR r_dup_mgr IN c_duplicate_mgr LOOP
141: if l_count = 0 then
142: fii_util.write_log('Printing out employee with multiple managers in table FII_CC_MGR_HIER_GT at level ' || G_AGGREGATION_LEVELS);
143: fii_util.write_log('');
144: fii_util.write_log ('- Employee ID --- Manager ID --- Employee Level -');
145: end if;
146:
147: l_count := l_count + 1;

Line 144: fii_util.write_log ('- Employee ID --- Manager ID --- Employee Level -');

140: FOR r_dup_mgr IN c_duplicate_mgr LOOP
141: if l_count = 0 then
142: fii_util.write_log('Printing out employee with multiple managers in table FII_CC_MGR_HIER_GT at level ' || G_AGGREGATION_LEVELS);
143: fii_util.write_log('');
144: fii_util.write_log ('- Employee ID --- Manager ID --- Employee Level -');
145: end if;
146:
147: l_count := l_count + 1;
148: FOR r_list_mgr IN c_list_dup_mgr (r_dup_mgr.emp_id) LOOP

Line 149: fii_util.write_log (r_dup_mgr.emp_id || ' ' ||

145: end if;
146:
147: l_count := l_count + 1;
148: FOR r_list_mgr IN c_list_dup_mgr (r_dup_mgr.emp_id) LOOP
149: fii_util.write_log (r_dup_mgr.emp_id || ' ' ||
150: r_list_mgr.mgr_id || ' ' ||
151: r_list_mgr.emp_level);
152: END LOOP;
153: END LOOP;

Line 162: fii_util.write_log('

158:
159: EXCEPTION
160: WHEN OTHERS THEN
161: g_retcode := -1;
162: fii_util.write_log('
163: -----------------------------
164: Error occured in Procedure: PRINT_DUP_MGR_IN_TEMP
165: Message: ' || sqlerrm);
166: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.PRINT_DUP_MGR_IN_TEMP');

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

215: WHERE company_cost_center_org_id <> -1
216: and dim.company_cost_center_org_id = ct.CCC_ORG_ID (+);
217:
218: If g_debug_flag = 'Y' then
219: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_MAPPINGS');
220: END IF;
221:
222: COMMIT;
223:

Line 238: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS' , g_fii_schema, g_retcode);

234: END IF;
235:
236: EXCEPTION
237: WHEN OTHERS THEN
238: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS' , g_fii_schema, g_retcode);
239: g_retcode := '-1';
240:
241: fii_util.write_log('
242: ---------------------------------

Line 241: fii_util.write_log('

237: WHEN OTHERS THEN
238: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS' , g_fii_schema, g_retcode);
239: g_retcode := '-1';
240:
241: fii_util.write_log('
242: ---------------------------------
243: Error in Procedure: INITIAL_LOAD
244: Message: '||sqlerrm);
245: fii_util.write_log(g_phase);

Line 245: fii_util.write_log(g_phase);

241: fii_util.write_log('
242: ---------------------------------
243: Error in Procedure: INITIAL_LOAD
244: Message: '||sqlerrm);
245: fii_util.write_log(g_phase);
246:
247: PRINT_DUP_ORG_IN_TEMP;
248:
249: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIAL_LOAD');

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

288: WHERE dim.company_cost_center_org_id <> -1
289: and dim.company_cost_center_org_id = ct.CCC_ORG_ID (+);
290:
291: If g_debug_flag = 'Y' then
292: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_MAPPINGS1_GT');
293: END IF;
294:
295: COMMIT;
296:

Line 307: fii_util.write_log('

303: EXCEPTION
304: WHEN OTHERS THEN
305: g_retcode := '-1';
306:
307: fii_util.write_log('
308: ---------------------------------
309: Error in Procedure: INCREMENTAL_LOAD
310: Message: '||sqlerrm);
311: fii_util.write_log(g_phase);

Line 311: fii_util.write_log(g_phase);

307: fii_util.write_log('
308: ---------------------------------
309: Error in Procedure: INCREMENTAL_LOAD
310: Message: '||sqlerrm);
311: fii_util.write_log(g_phase);
312:
313: PRINT_DUP_ORG_IN_TEMP;
314:
315: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INCREMENTAL_LOAD');

Line 339: fii_util.write_log('Update LOB_ID for DBI50');

335:
336: if G_DBI50_FOR_LOB then
337:
338: If g_debug_flag = 'Y' then
339: fii_util.write_log('Update LOB_ID for DBI50');
340: End if;
341:
342: --Update LOB if using old lob assignment (DEBUG: we use NVL ?)
343: UPDATE FII_COM_CC_MAPPINGS dim

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

358: AND x.b = dim.COMPANY_COST_CENTER_ORG_ID), dim.LOB_ID)
359: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
360:
361: If g_debug_flag = 'Y' then
362: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS');
363: END IF;
364:
365: else
366:

Line 368: fii_util.write_log('Update LOB_ID for DBI60 and above');

364:
365: else
366:
367: If g_debug_flag = 'Y' then
368: fii_util.write_log('Update LOB_ID for DBI60 and above');
369: End if;
370:
371: --Update LOB if using new lob assignment (DEBUG: we use NVL ?)
372: --Bug 3243824: use in ('GL_BALANCING', 'FA_COST_CTR')

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

398: ), dim.LOB_ID)
399: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
400:
401: If g_debug_flag = 'Y' then
402: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS');
403: END IF;
404:
405: end if;
406:

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

414: where mgr.mgr_level = G_AGGREGATION_LEVELS
415: and mgr.emp_id = dim.manager_id), dim.manager_id);
416:
417: If g_debug_flag = 'Y' then
418: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS');
419: END IF;
420:
421: g_phase := 'Update parent_lob_id by INITIAL_LOAD_LOB';
422:

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

433: where v.child_lob_id = dim.lob_id
434: and rownum = 1), dim.lob_id);
435:
436: If g_debug_flag = 'Y' then
437: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS');
438: END IF;
439:
440: COMMIT;
441:

Line 448: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS' , g_fii_schema, g_retcode);

444: END IF;
445:
446: EXCEPTION
447: WHEN OTHERS THEN
448: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS' , g_fii_schema, g_retcode);
449: g_retcode := '-1';
450:
451: fii_util.write_log('
452: ---------------------------------

Line 451: fii_util.write_log('

447: WHEN OTHERS THEN
448: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS' , g_fii_schema, g_retcode);
449: g_retcode := '-1';
450:
451: fii_util.write_log('
452: ---------------------------------
453: Error in Procedure: INITIAL_LOAD_LOB
454: Message: '||sqlerrm);
455: fii_util.write_log(g_phase);

Line 455: fii_util.write_log(g_phase);

451: fii_util.write_log('
452: ---------------------------------
453: Error in Procedure: INITIAL_LOAD_LOB
454: Message: '||sqlerrm);
455: fii_util.write_log(g_phase);
456:
457: PRINT_DUP_MGR_IN_TEMP;
458:
459: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIAL_LOAD_LOB');

Line 484: fii_util.write_log('Update LOB_ID for DBI50');

480: if G_DBI50_FOR_LOB then
481: --Update LOB if using old lob assignment (DEBUG: we use NVL ?)
482:
483: If g_debug_flag = 'Y' then
484: fii_util.write_log('Update LOB_ID for DBI50');
485: End if;
486:
487: UPDATE FII_COM_CC_MAPPINGS1_GT dim
488: SET dim.LOB_ID = NVL(

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

502: AND x.b = dim.COMPANY_COST_CENTER_ORG_ID), dim.LOB_ID)
503: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
504:
505: If g_debug_flag = 'Y' then
506: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
507: END IF;
508:
509: else
510:

Line 518: fii_util.write_log('Update LOB_ID for DBI60 and above');

514:
515: --Bug 3407938: the lob_id should be in LOB dimension full hierarchy
516:
517: If g_debug_flag = 'Y' then
518: fii_util.write_log('Update LOB_ID for DBI60 and above');
519: End if;
520:
521: UPDATE FII_COM_CC_MAPPINGS1_GT dim
522: SET dim.LOB_ID = NVL(

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

542: ), dim.LOB_ID)
543: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
544:
545: If g_debug_flag = 'Y' then
546: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
547: END IF;
548:
549: end if;
550:

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

558: where mgr.mgr_level = G_AGGREGATION_LEVELS
559: and mgr.emp_id = dim.manager_id), dim.manager_id);
560:
561: If g_debug_flag = 'Y' then
562: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
563: END IF;
564:
565: g_phase := 'Update parent_lob_id by INCREMENTAL_LOAD_LOB_MERGE';
566:

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

577: where v.child_lob_id = dim.lob_id
578: and rownum = 1), dim.lob_id);
579:
580: If g_debug_flag = 'Y' then
581: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_CC_MAPPINGS1_GT');
582: END IF;
583:
584: --Incrementally populate fii_com_cc_mappings for both new and old lob assignments
585:

Line 659: FII_UTIL.Write_Log('Merged ' || SQL%ROWCOUNT || ' rows into fii_com_cc_mappings');

655: g_fii_user_id,
656: g_fii_login_id);
657:
658: If g_debug_flag = 'Y' then
659: FII_UTIL.Write_Log('Merged ' || SQL%ROWCOUNT || ' rows into fii_com_cc_mappings');
660: END IF;
661:
662: commit;
663:

Line 673: fii_util.write_log('

669: WHEN OTHERS THEN
670: rollback;
671: g_retcode := -1;
672:
673: fii_util.write_log('
674: ---------------------------------
675: Error in Procedure: INCREMENTAL_LOAD_LOB_MERGE
676: Message: '||sqlerrm);
677: fii_util.write_log(g_phase);

Line 677: fii_util.write_log(g_phase);

673: fii_util.write_log('
674: ---------------------------------
675: Error in Procedure: INCREMENTAL_LOAD_LOB_MERGE
676: Message: '||sqlerrm);
677: fii_util.write_log(g_phase);
678:
679: PRINT_DUP_ORG_IN_TEMP;
680:
681: PRINT_DUP_MGR_IN_TEMP;

Line 716: l_dir := FII_UTIL.get_utl_file_dir;

712: -- Set default directory in case if the profile option
713: -- BIS_DEBUG_LOG_DIRECTORY is not set up
714: ------------------------------------------------------
715: if l_dir is NULL then
716: l_dir := FII_UTIL.get_utl_file_dir;
717: end if;
718:
719: ----------------------------------------------------------------
720: -- FII_UTIL.initialize will get profile options FII_DEBUG_pmode

Line 720: -- FII_UTIL.initialize will get profile options FII_DEBUG_pmode

716: l_dir := FII_UTIL.get_utl_file_dir;
717: end if;
718:
719: ----------------------------------------------------------------
720: -- FII_UTIL.initialize will get profile options FII_DEBUG_pmode
721: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
722: -- the log files and output files are written to
723: ----------------------------------------------------------------
724: FII_UTIL.initialize('FII_GL_COMCCH_C.log','FII_GL_COMCCH_C.out',l_dir, 'FII_GL_COMCCH_C');

Line 724: FII_UTIL.initialize('FII_GL_COMCCH_C.log','FII_GL_COMCCH_C.out',l_dir, 'FII_GL_COMCCH_C');

720: -- FII_UTIL.initialize will get profile options FII_DEBUG_pmode
721: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
722: -- the log files and output files are written to
723: ----------------------------------------------------------------
724: FII_UTIL.initialize('FII_GL_COMCCH_C.log','FII_GL_COMCCH_C.out',l_dir, 'FII_GL_COMCCH_C');
725:
726: -- --------------------------------------------------------
727: -- Find out the user ID ,login ID, and current language
728: -- --------------------------------------------------------

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

739: -- Find the schema owner
740: -- --------------------------------------------------------
741: g_phase := 'Find schema owner for FII';
742:
743: g_fii_schema := FII_UTIL.get_schema_name ('FII');
744:
745:
746: -- --------------------------------------------------------
747: -- Find the unassigned LOB ID

Line 791: fii_util.write_log(g_phase);

787:
788: EXCEPTION
789: WHEN G_LOGIN_INFO_NOT_AVABLE THEN
790:
791: fii_util.write_log(g_phase);
792: fii_util.write_log('
793: Can not get User ID and Login ID, program exit');
794:
795: g_retcode := -1;

Line 792: fii_util.write_log('

788: EXCEPTION
789: WHEN G_LOGIN_INFO_NOT_AVABLE THEN
790:
791: fii_util.write_log(g_phase);
792: fii_util.write_log('
793: Can not get User ID and Login ID, program exit');
794:
795: g_retcode := -1;
796: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIALIZE');

Line 802: fii_util.write_log('

798:
799: WHEN OTHERS THEN
800: g_retcode := -1;
801:
802: fii_util.write_log('
803: ------------------------
804: Error in Procedure: INIT
805: Phase: '||g_phase||'
806: Message: '||sqlerrm);

Line 843: fii_util.start_timer;

839: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.HANDLE_MISSING_COA');
840: END IF;
841:
842: If g_debug_flag = 'Y' then
843: fii_util.start_timer;
844: End if;
845:
846: For r_value_sets IN c_all_value_sets Loop
847:

Line 895: fii_util.put_line('Updated '||l_count||' rows with coa_id = -1 in FII_COM_CC_MAPPINGS_GT');

891:
892: End Loop;
893:
894: if g_debug_flag = 'Y' then
895: fii_util.put_line('Updated '||l_count||' rows with coa_id = -1 in FII_COM_CC_MAPPINGS_GT');
896: fii_util.stop_timer;
897: fii_util.print_timer('Duration');
898: end if;
899:

Line 896: fii_util.stop_timer;

892: End Loop;
893:
894: if g_debug_flag = 'Y' then
895: fii_util.put_line('Updated '||l_count||' rows with coa_id = -1 in FII_COM_CC_MAPPINGS_GT');
896: fii_util.stop_timer;
897: fii_util.print_timer('Duration');
898: end if;
899:
900: If g_debug_flag = 'Y' then

Line 897: fii_util.print_timer('Duration');

893:
894: if g_debug_flag = 'Y' then
895: fii_util.put_line('Updated '||l_count||' rows with coa_id = -1 in FII_COM_CC_MAPPINGS_GT');
896: fii_util.stop_timer;
897: fii_util.print_timer('Duration');
898: end if;
899:
900: If g_debug_flag = 'Y' then
901: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.HANDLE_MISSING_COA');

Line 906: FII_UTIL.put_line('Error in HANDLE_MISSING_COA; ' || 'Message: ' || sqlerrm);

902: END IF;
903:
904: Exception
905: WHEN OTHERS Then
906: FII_UTIL.put_line('Error in HANDLE_MISSING_COA; ' || 'Message: ' || sqlerrm);
907: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.HANDLE_MISSING_COA');
908: raise;
909:
910: End HANDLE_MISSING_COA;

Line 954: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS_GT', g_fii_schema, g_retcode);

950: END IF;
951:
952: g_phase := 'truncate table FII_COM_CC_MAPPINGS_GT';
953:
954: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS_GT', g_fii_schema, g_retcode);
955:
956: ---------------------------------------------------------------------------------------
957: /* Bug 3700956: stop getting ccc org information from CCID
958:

Line 975: -- FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_MAPPINGS_GT');

971: -- dim.chart_of_accounts_id
972: -- FROM fii_gl_ccid_dimensions dim;
973:
974: -- If g_debug_flag = 'Y' then
975: -- FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_MAPPINGS_GT');
976: -- END IF;
977:
978: End of Bug 3700956 */
979: ---------------------------------------------------------------------------------------

Line 1013: FII_UTIL.Write_Output (

1009: end if;
1010:
1011: l_count := l_count + 1;
1012: FOR r_list_org IN c_list_dup_org (r_dup_org.company_id, r_dup_org.cost_center_id) LOOP
1013: FII_UTIL.Write_Output (
1014: r_list_org.organization || ' ' ||
1015: r_list_org.company || ' ' ||
1016: r_list_org.cost_center );
1017: END LOOP;

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

1038: group by company_id, cost_center_id
1039: having count(*) = 1;
1040:
1041: If g_debug_flag = 'Y' then
1042: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_MAPPINGS_GT');
1043: END IF;
1044:
1045: -- Call HANDLE_MISSING_COA to update coa_id = -1 records.
1046: -- Do this only if using DBI 6.0 for LOB

Line 1094: fii_util.write_log('

1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: g_retcode := -1;
1093:
1094: fii_util.write_log('
1095: -----------------------------
1096: Error occured in Procedure: POPULATE_COM_CCC_TEMP
1097: Phase: ' || g_phase || '
1098: Message: ' || sqlerrm);

Line 1117: fii_util.put_line('Populating FII_ORG_MGR_MAPPINGS table');

1113: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.POPULATE_ORG_MGR_MAP');
1114: END IF;
1115:
1116: if g_debug_flag = 'Y' then
1117: fii_util.put_line('Populating FII_ORG_MGR_MAPPINGS table');
1118: end if;
1119:
1120: g_phase := 'truncate table FII_ORG_MGR_MAPPINGS';
1121:

Line 1122: FII_UTIL.TRUNCATE_TABLE('FII_ORG_MGR_MAPPINGS', g_fii_schema, g_retcode);

1118: end if;
1119:
1120: g_phase := 'truncate table FII_ORG_MGR_MAPPINGS';
1121:
1122: FII_UTIL.TRUNCATE_TABLE('FII_ORG_MGR_MAPPINGS', g_fii_schema, g_retcode);
1123:
1124: g_phase := 'insert into FII_ORG_MGR_MAPPINGS';
1125:
1126: --Bug 3750856: should use parent_manager_id when join to fii_com_cc_mappings

Line 1149: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows to FII_ORG_MGR_MAPPINGS');

1145: FROM fii_cc_mgr_hierarchies) x
1146: WHERE x.emp_id = parent_manager_id;
1147:
1148: if g_debug_flag = 'Y' then
1149: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows to FII_ORG_MGR_MAPPINGS');
1150: end if;
1151:
1152: g_phase := 'gather_table_stats for FII_ORG_MGR_MAPPINGS';
1153:

Line 1169: FII_UTIL.put_line('

1165:
1166: WHEN OTHERS THEN
1167: g_retcode := -1;
1168:
1169: FII_UTIL.put_line('
1170: ----------------------------
1171: Error in Function: POPULATE_ORG_MGR_MAP
1172: Message: '||sqlerrm);
1173: fii_util.write_log(g_phase);

Line 1173: fii_util.write_log(g_phase);

1169: FII_UTIL.put_line('
1170: ----------------------------
1171: Error in Function: POPULATE_ORG_MGR_MAP
1172: Message: '||sqlerrm);
1173: fii_util.write_log(g_phase);
1174:
1175: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.POPULATE_ORG_MGR_MAP');
1176:
1177: RAISE;

Line 1202: fii_util.write_log('Calling INITIALIZE');

1198: -- options and other resources
1199: ---------------------------------------------------
1200:
1201: If g_debug_flag = 'Y' then
1202: fii_util.write_log('Calling INITIALIZE');
1203: End if;
1204:
1205: INITIALIZE;
1206:

Line 1212: fii_util.write_log('Calling LOAD_CCC_MGR');

1208: -- Populate CCC - Mgr mappings temp. table
1209: -----------------------------------------------------
1210:
1211: If g_debug_flag = 'Y' then
1212: fii_util.write_log('Calling LOAD_CCC_MGR');
1213: End if;
1214:
1215: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (p_status);
1216:

Line 1218: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');

1214:
1215: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (p_status);
1216:
1217: IF p_status = -1 then
1218: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
1219: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
1220: raise NO_DATA_FOUND;
1221: END IF;
1222:

Line 1219: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');

1215: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (p_status);
1216:
1217: IF p_status = -1 then
1218: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
1219: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
1220: raise NO_DATA_FOUND;
1221: END IF;
1222:
1223: ----------------------------------------------------

Line 1229: fii_util.write_log('Make sure FII_CC_MGR_HIER_GT is populated');

1225: -- If not, call FII_CC_MGR_SUP_C.Populate_HIER_TMP
1226: ----------------------------------------------------
1227:
1228: If g_debug_flag = 'Y' then
1229: fii_util.write_log('Make sure FII_CC_MGR_HIER_GT is populated');
1230: End if;
1231:
1232: begin
1233: select 1 into l_count from FII_CC_MGR_HIER_GT

Line 1249: fii_util.write_log('Calling POPULATE_COM_CCC_TEMP');

1245: -- Populate temp table with updated ccids
1246: ----------------------------------------------------
1247:
1248: If g_debug_flag = 'Y' then
1249: fii_util.write_log('Calling POPULATE_COM_CCC_TEMP');
1250: End if;
1251:
1252: POPULATE_COM_CCC_TEMP;
1253:

Line 1261: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS', g_fii_schema, g_retcode);

1257: IF (g_mode = 'L') THEN
1258: ------------------------------------------------------
1259: -- Populate fii_com_ccc_mappings in initial pmode
1260: ------------------------------------------------------
1261: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS', g_fii_schema, g_retcode);
1262:
1263: If g_debug_flag = 'Y' then
1264: fii_util.write_log('Calling INITIAL_LOAD');
1265: End if;

Line 1264: fii_util.write_log('Calling INITIAL_LOAD');

1260: ------------------------------------------------------
1261: FII_UTIL.TRUNCATE_TABLE('FII_COM_CC_MAPPINGS', g_fii_schema, g_retcode);
1262:
1263: If g_debug_flag = 'Y' then
1264: fii_util.write_log('Calling INITIAL_LOAD');
1265: End if;
1266:
1267: INITIAL_LOAD;
1268:

Line 1270: fii_util.write_log('Calling INITIAL_LOAD_LOB');

1266:
1267: INITIAL_LOAD;
1268:
1269: If g_debug_flag = 'Y' then
1270: fii_util.write_log('Calling INITIAL_LOAD_LOB');
1271: End if;
1272:
1273: INITIAL_LOAD_LOB;
1274:

Line 1281: fii_util.write_log('Calling INCREMENTAL_LOAD');

1277: -- Populate fii_com_ccc_mappings in incremental pmode
1278: ------------------------------------------------------
1279:
1280: If g_debug_flag = 'Y' then
1281: fii_util.write_log('Calling INCREMENTAL_LOAD');
1282: End if;
1283:
1284: INCREMENTAL_LOAD;
1285:

Line 1287: fii_util.write_log('Calling INCREMENTAL_LOAD_LOB_MERGE');

1283:
1284: INCREMENTAL_LOAD;
1285:
1286: If g_debug_flag = 'Y' then
1287: fii_util.write_log('Calling INCREMENTAL_LOAD_LOB_MERGE');
1288: End if;
1289:
1290: INCREMENTAL_LOAD_LOB_MERGE;
1291:

Line 1302: FII_UTIL.put_line('

1298: END IF;
1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: FII_UTIL.put_line('
1303: ----------------------------
1304: Error in Function: MAIN_CCID
1305: Message: '||sqlerrm);
1306: rollback;

Line 1372: FII_UTIL.Write_Log ('FII_GL_COMCCH_C.Main: error in phase '|| g_phase);

1368:
1369: WHEN OTHERS THEN
1370: errbuf := sqlerrm;
1371: retcode := sqlcode;
1372: FII_UTIL.Write_Log ('FII_GL_COMCCH_C.Main: error in phase '|| g_phase);
1373: FII_UTIL.Write_Log ( substr(sqlerrm,1,180) );
1374: l_ret_val := FND_CONCURRENT.Set_Completion_Status
1375: (status => 'ERROR', message => substr(sqlerrm,1,180));
1376: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.Main');

Line 1373: FII_UTIL.Write_Log ( substr(sqlerrm,1,180) );

1369: WHEN OTHERS THEN
1370: errbuf := sqlerrm;
1371: retcode := sqlcode;
1372: FII_UTIL.Write_Log ('FII_GL_COMCCH_C.Main: error in phase '|| g_phase);
1373: FII_UTIL.Write_Log ( substr(sqlerrm,1,180) );
1374: l_ret_val := FND_CONCURRENT.Set_Completion_Status
1375: (status => 'ERROR', message => substr(sqlerrm,1,180));
1376: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.Main');
1377: rollback;