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_GL_COMCCH_C

Line 1: PACKAGE BODY FII_GL_COMCCH_C AS

1: PACKAGE BODY FII_GL_COMCCH_C AS
2: /* $Header: FIIGLH1B.pls 120.3 2006/02/21 22:07:30 juding noship $ */
3:
4: g_debug_flag Varchar2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
5:

Line 66: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.PRINT_DUP_ORG_IN_TEMP');

62:
63: BEGIN
64:
65: If g_debug_flag = 'Y' then
66: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.PRINT_DUP_ORG_IN_TEMP');
67: END IF;
68:
69: --The information is written to the log file only for debug purpose
70: --called from an EXCEPTION section

Line 89: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.PRINT_DUP_ORG_IN_TEMP');

85: END LOOP;
86: END LOOP;
87:
88: If g_debug_flag = 'Y' then
89: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.PRINT_DUP_ORG_IN_TEMP');
90: END IF;
91:
92: EXCEPTION
93: WHEN OTHERS THEN

Line 99: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.PRINT_DUP_ORG_IN_TEMP');

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');
100: raise;
101:
102: END PRINT_DUP_ORG_IN_TEMP;
103:

Line 133: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.PRINT_DUP_MGR_IN_TEMP');

129:
130: BEGIN
131:
132: If g_debug_flag = 'Y' then
133: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.PRINT_DUP_MGR_IN_TEMP');
134: END IF;
135:
136: --The information is written to the log file only for debug purpose
137: --called from an EXCEPTION section

Line 156: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.PRINT_DUP_MGR_IN_TEMP');

152: END LOOP;
153: END LOOP;
154:
155: If g_debug_flag = 'Y' then
156: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.PRINT_DUP_MGR_IN_TEMP');
157: END IF;
158:
159: EXCEPTION
160: WHEN OTHERS THEN

Line 166: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.PRINT_DUP_MGR_IN_TEMP');

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');
167: raise;
168:
169: END PRINT_DUP_MGR_IN_TEMP;
170:

Line 180: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INITIAL_LOAD');

176:
177: BEGIN
178:
179: If g_debug_flag = 'Y' then
180: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INITIAL_LOAD');
181: END IF;
182:
183: g_phase := 'Insert into FII_COM_CC_MAPPINGS by INITIAL_LOAD';
184:

Line 233: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INITIAL_LOAD');

229: -- (ownname => g_fii_schema,
230: -- tabname => 'FII_COM_CC_MAPPINGS');
231:
232: If g_debug_flag = 'Y' then
233: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INITIAL_LOAD');
234: END IF;
235:
236: EXCEPTION
237: WHEN OTHERS THEN

Line 249: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIAL_LOAD');

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');
250:
251: RAISE;
252:
253: END INITIAL_LOAD;

Line 263: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INCREMENTAL_LOAD');

259:
260: BEGIN
261:
262: If g_debug_flag = 'Y' then
263: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INCREMENTAL_LOAD');
264: END IF;
265:
266: g_phase := 'Insert into FII_COM_CC_MAPPINGS1_GT by INCREMENTAL_LOAD';
267:

Line 300: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INCREMENTAL_LOAD');

296:
297: --G_UNASSIGNED_LOB_ID here is the id of the unassigned LOB
298:
299: If g_debug_flag = 'Y' then
300: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INCREMENTAL_LOAD');
301: END IF;
302:
303: EXCEPTION
304: WHEN OTHERS THEN

Line 315: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INCREMENTAL_LOAD');

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');
316:
317: RAISE;
318:
319: END INCREMENTAL_LOAD;

Line 330: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INITIAL_LOAD_LOB');

326:
327: BEGIN
328:
329: If g_debug_flag = 'Y' then
330: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INITIAL_LOAD_LOB');
331: END IF;
332:
333: g_phase := 'Update LOB by INITIAL_LOAD_LOB';
334:

Line 443: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INITIAL_LOAD_LOB');

439:
440: COMMIT;
441:
442: If g_debug_flag = 'Y' then
443: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INITIAL_LOAD_LOB');
444: END IF;
445:
446: EXCEPTION
447: WHEN OTHERS THEN

Line 459: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIAL_LOAD_LOB');

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');
460:
461: RAISE;
462:
463: END INITIAL_LOAD_LOB;

Line 475: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INCREMENTAL_LOAD_LOB_MERGE');

471:
472: BEGIN
473:
474: If g_debug_flag = 'Y' then
475: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INCREMENTAL_LOAD_LOB_MERGE');
476: END IF;
477:
478: g_phase := 'Update LOB by INCREMENTAL_LOAD_LOB_MERGE';
479:

Line 665: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INCREMENTAL_LOAD_LOB_MERGE');

661:
662: commit;
663:
664: If g_debug_flag = 'Y' then
665: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INCREMENTAL_LOAD_LOB_MERGE');
666: END IF;
667:
668: EXCEPTION
669: WHEN OTHERS THEN

Line 683: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INCREMENTAL_LOAD_LOB_MERGE');

679: PRINT_DUP_ORG_IN_TEMP;
680:
681: PRINT_DUP_MGR_IN_TEMP;
682:
683: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INCREMENTAL_LOAD_LOB_MERGE');
684:
685: RAISE;
686:
687: END INCREMENTAL_LOAD_LOB_MERGE;

Line 702: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INITIALIZE');

698: l_flag NUMBER(15) := 0;
699: BEGIN
700:
701: If g_debug_flag = 'Y' then
702: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.INITIALIZE');
703: END IF;
704:
705: ----------------------------------------------
706: -- Do set up for log file

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 785: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INITIALIZE');

781: end if;
782: -----------------------------------------------
783:
784: If g_debug_flag = 'Y' then
785: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.INITIALIZE');
786: END IF;
787:
788: EXCEPTION
789: WHEN G_LOGIN_INFO_NOT_AVABLE THEN

Line 796: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIALIZE');

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');
797: raise;
798:
799: WHEN OTHERS THEN
800: g_retcode := -1;

Line 808: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIALIZE');

804: Error in Procedure: INIT
805: Phase: '||g_phase||'
806: Message: '||sqlerrm);
807:
808: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.INITIALIZE');
809: raise;
810:
811: END INITIALIZE;
812:

Line 839: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.HANDLE_MISSING_COA');

835:
836: Begin
837:
838: If g_debug_flag = 'Y' then
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;

Line 901: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.HANDLE_MISSING_COA');

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');
902: END IF;
903:
904: Exception
905: WHEN OTHERS Then

Line 907: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.HANDLE_MISSING_COA');

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

Line 949: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.POPULATE_COM_CCC_TEMP');

945:
946: BEGIN
947:
948: If g_debug_flag = 'Y' then
949: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.POPULATE_COM_CCC_TEMP');
950: END IF;
951:
952: g_phase := 'truncate table FII_COM_CC_MAPPINGS_GT';
953:

Line 1087: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.POPULATE_COM_CCC_TEMP');

1083: message => 'There are null company cost center organizations in HR');
1084: end if;
1085:
1086: If g_debug_flag = 'Y' then
1087: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.POPULATE_COM_CCC_TEMP');
1088: END IF;
1089:
1090: EXCEPTION
1091: WHEN OTHERS THEN

Line 1100: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.POPULATE_COM_CCC_TEMP');

1096: Error occured in Procedure: POPULATE_COM_CCC_TEMP
1097: Phase: ' || g_phase || '
1098: Message: ' || sqlerrm);
1099:
1100: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.POPULATE_COM_CCC_TEMP');
1101: raise;
1102: END POPULATE_COM_CCC_TEMP;
1103:
1104: -----------------------------------------------------------------

Line 1113: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.POPULATE_ORG_MGR_MAP');

1109:
1110: BEGIN
1111:
1112: If g_debug_flag = 'Y' then
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');

Line 1161: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.POPULATE_ORG_MGR_MAP');

1157:
1158: commit;
1159:
1160: If g_debug_flag = 'Y' then
1161: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.POPULATE_ORG_MGR_MAP');
1162: END IF;
1163:
1164: EXCEPTION
1165:

Line 1175: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.POPULATE_ORG_MGR_MAP');

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;
1178:
1179: END POPULATE_ORG_MGR_MAP;

Line 1191: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.Main_CCID');

1187: l_count NUMBER(15) := 0;
1188:
1189: BEGIN
1190: If g_debug_flag = 'Y' then
1191: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.Main_CCID');
1192: END IF;
1193:
1194: g_mode := pmode;
1195:

Line 1297: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.Main_CCID');

1293:
1294: COMMIT;
1295:
1296: If g_debug_flag = 'Y' then
1297: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.Main_CCID');
1298: END IF;
1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN

Line 1307: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.Main_CCID');

1303: ----------------------------
1304: Error in Function: MAIN_CCID
1305: Message: '||sqlerrm);
1306: rollback;
1307: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.Main_CCID');
1308: raise;
1309: END MAIN_CCID;
1310:
1311: -----------------------------------------------------------------

Line 1325: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.Main');

1321: l_count NUMBER(15);
1322:
1323: BEGIN
1324: If g_debug_flag = 'Y' then
1325: FII_MESSAGE.Func_Ent('FII_GL_COMCCH_C.Main');
1326: END IF;
1327:
1328: errbuf := NULL;
1329: retcode := 0;

Line 1346: FII_GL_COMCCH_C.MAIN_CCID (g_mode);

1342:
1343: -- Then, populate FII_COM_CC_MAPPINGS
1344: g_phase := 'Populate FII_COM_CC_MAPPINGS';
1345:
1346: FII_GL_COMCCH_C.MAIN_CCID (g_mode);
1347:
1348: -- Call the procedure to populate table FII_ORG_MGR_MAPPINGS used in PMV
1349: g_phase := 'Populate FII_ORG_MGR_MAPPINGS';
1350:

Line 1364: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.Main');

1360: message => 'Some company cost center organizations have no managers assigned to them.');
1361: end if;
1362:
1363: If g_debug_flag = 'Y' then
1364: FII_MESSAGE.Func_Succ('FII_GL_COMCCH_C.Main');
1365: END IF;
1366:
1367: EXCEPTION
1368:

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 1376: FII_MESSAGE.Func_Fail('FII_GL_COMCCH_C.Main');

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;
1378:
1379: END MAIN;
1380:

Line 1381: END FII_GL_COMCCH_C;

1377: rollback;
1378:
1379: END MAIN;
1380:
1381: END FII_GL_COMCCH_C;