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_COM_CC_DIM_MAPS_PKG dependencies on FII_COM_CC_DIM_MAPS_PKG

Line 1: PACKAGE BODY FII_COM_CC_DIM_MAPS_PKG AS

1: PACKAGE BODY FII_COM_CC_DIM_MAPS_PKG AS
2: /* $Header: FIICCMPB.pls 120.1 2005/10/30 05:05:42 appldev noship $ */
3:
4: G_UNASSIGNED_ID NUMBER(15);
5: G_CO_MAP_SEG VARCHAR2(30);

Line 43: FII_UTIL.initialize('FII_COM_CC_DIM_MAPS_PKG.log',

39: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
40: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
41: -- the log files and output files are written to
42: ----------------------------------------------------------------
43: FII_UTIL.initialize('FII_COM_CC_DIM_MAPS_PKG.log',
44: 'FII_COM_CC_DIM_MAPS_PKG.out',l_dir,'FII_COM_CC_DIM_MAPS_PKG');
45:
46:
47: -- Obtain FII schema name

Line 44: 'FII_COM_CC_DIM_MAPS_PKG.out',l_dir,'FII_COM_CC_DIM_MAPS_PKG');

40: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
41: -- the log files and output files are written to
42: ----------------------------------------------------------------
43: FII_UTIL.initialize('FII_COM_CC_DIM_MAPS_PKG.log',
44: 'FII_COM_CC_DIM_MAPS_PKG.out',l_dir,'FII_COM_CC_DIM_MAPS_PKG');
45:
46:
47: -- Obtain FII schema name
48: g_schema_name := FII_UTIL.get_schema_name ('FII');

Line 129: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Initialize : '|| 'User defined error');

125:
126: Exception
127:
128: When COMCCDIM_fatal_err then
129: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Initialize : '|| 'User defined error');
130: FII_UTIL.Write_Log ('G_PHASE : ' || g_phase);
131: FND_CONCURRENT.Af_Rollback;
132: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Initialize');
133: raise;

Line 132: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Initialize');

128: When COMCCDIM_fatal_err then
129: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Initialize : '|| 'User defined error');
130: FII_UTIL.Write_Log ('G_PHASE : ' || g_phase);
131: FND_CONCURRENT.Af_Rollback;
132: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Initialize');
133: raise;
134:
135: When others then
136: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');

Line 151: FII_MESSAGE.Func_Ent(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Populate_com_cc_Maps');

147:
148: PROCEDURE Populate_com_cc_Maps IS
149: BEGIN
150: IF (FIIDIM_Debug) THEN
151: FII_MESSAGE.Func_Ent(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Populate_com_cc_Maps');
152: END IF;
153:
154: -- Insert records in the com cc mappings GI table
155: g_phase := 'Insert into FII_COM_CC_DIM_MAP_GT';

Line 213: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Populate_com_cc_Maps');

209: h2.child_cc_id ;
210: -- Removed outer join as we dont want unassigned as a parent
211: IF (FIIDIM_Debug) THEN
212: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAP_GT');
213: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Populate_com_cc_Maps');
214: END IF;
215:
216: Exception
217:

Line 238: FII_MESSAGE.Func_Ent(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');

234:
235: BEGIN
236:
237: IF (FIIDIM_Debug) THEN
238: FII_MESSAGE.Func_Ent(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
239: END IF;
240:
241: --First do the initialization
242: g_phase := 'Calling intialize procedure';

Line 304: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');

300:
301: --=====================================================================
302:
303: IF (FIIDIM_Debug) THEN
304: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
305: END IF;
306:
307: -- Exception handling
308:

Line 313: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Init_Load: '||

309: EXCEPTION
310:
311: WHEN COMCCDIM_fatal_err THEN
312:
313: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Init_Load: '||
314: 'User defined error');
315: FND_CONCURRENT.Af_Rollback;
316: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
317: retcode := sqlcode;

Line 316: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');

312:
313: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Init_Load: '||
314: 'User defined error');
315: FND_CONCURRENT.Af_Rollback;
316: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
317: retcode := sqlcode;
318: ret_val := FND_CONCURRENT.Set_Completion_Status
319: (status => 'ERROR', message => substr(sqlerrm,1,180));
320:

Line 326: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');

322: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
323: FII_UTIL.Write_Log (
324: 'Other error in FII_CC_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
325: FND_CONCURRENT.Af_Rollback;
326: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
327: retcode := sqlcode;
328: ret_val := FND_CONCURRENT.Set_Completion_Status
329: (status => 'ERROR', message => substr(sqlerrm,1,180));
330:

Line 346: FII_MESSAGE.Func_Ent(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

342: ret_code VARCHAR2(2):=0;
343: BEGIN
344:
345: IF (FIIDIM_Debug) THEN
346: FII_MESSAGE.Func_Ent(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
347: END IF;
348:
349: --First do the initialization
350: g_phase := 'Calling intialize procedure';

Line 448: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

444: --(ownname => g_schema_name,
445: --tabname => 'MLOG$_FII_COM_CC_DIM_MAPS');
446:
447: IF (FIIDIM_Debug) THEN
448: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
449: END IF;
450:
451: -- Exception handling
452:

Line 455: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Incre_Update'||

451: -- Exception handling
452:
453: EXCEPTION
454: WHEN COMCCDIM_fatal_err THEN
455: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Incre_Update'||
456: 'User defined error');
457:
458: FND_CONCURRENT.Af_Rollback;
459: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

Line 459: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

455: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Incre_Update'||
456: 'User defined error');
457:
458: FND_CONCURRENT.Af_Rollback;
459: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
460: retcode := sqlcode;
461: ret_val := FND_CONCURRENT.Set_Completion_Status
462: (status => 'ERROR', message => substr(sqlerrm,1,180));
463:

Line 467: 'Other error in FII_COM_CC_DIM_MAPS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));

463:
464: WHEN OTHERS THEN
465: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
466: FII_UTIL.Write_Log (
467: 'Other error in FII_COM_CC_DIM_MAPS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
468:
469:
470: FND_CONCURRENT.Af_Rollback;
471: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

Line 471: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

467: 'Other error in FII_COM_CC_DIM_MAPS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
468:
469:
470: FND_CONCURRENT.Af_Rollback;
471: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
472: retcode := sqlcode;
473: ret_val := FND_CONCURRENT.Set_Completion_Status
474: (status => 'ERROR', message => substr(sqlerrm,1,180));
475:

Line 478: END FII_COM_CC_DIM_MAPS_PKG ;

474: (status => 'ERROR', message => substr(sqlerrm,1,180));
475:
476: END Incre_Update;
477:
478: END FII_COM_CC_DIM_MAPS_PKG ;