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_UTIL

Line 35: l_dir := FII_UTIL.get_utl_file_dir;

31: -- Set default directory in case if the profile option
32: -- BIS_DEBUG_LOG_DIRECTORY is not set up
33: ------------------------------------------------------
34: if l_dir is NULL then
35: l_dir := FII_UTIL.get_utl_file_dir;
36: end if;
37:
38: ----------------------------------------------------------------
39: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

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

35: l_dir := FII_UTIL.get_utl_file_dir;
36: end if;
37:
38: ----------------------------------------------------------------
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',

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 48: g_schema_name := FII_UTIL.get_schema_name ('FII');

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');
49:
50: -- Obtain user ID, login ID and initialize package variables
51: FII_USER_ID := FND_GLOBAL.USER_ID;
52: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;

Line 56: FII_UTIL.Write_Log ('>>> Failed Intialization');

52: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
53:
54: -- If any of the above values is not set, error out
55: IF (FII_User_Id is NULL OR FII_Login_Id is NULL) THEN
56: FII_UTIL.Write_Log ('>>> Failed Intialization');
57: RAISE COMCCDIM_fatal_err;
58: END IF;
59:
60: -- Determine if process will be run in debug mode

Line 63: FII_UTIL.Write_Log (' Debug On');

59:
60: -- Determine if process will be run in debug mode
61: IF (NVL(G_Debug_Mode, 'N') <> 'N') THEN
62: FIIDIM_Debug := TRUE;
63: FII_UTIL.Write_Log (' Debug On');
64: ELSE
65: FIIDIM_Debug := FALSE;
66: FII_UTIL.Write_Log (' Debug Off');
67: END IF;

Line 66: FII_UTIL.Write_Log (' Debug Off');

62: FIIDIM_Debug := TRUE;
63: FII_UTIL.Write_Log (' Debug On');
64: ELSE
65: FIIDIM_Debug := FALSE;
66: FII_UTIL.Write_Log (' Debug Off');
67: END IF;
68:
69: -- Turn trace on if process is run in debug mode
70: IF (FIIDIM_Debug) THEN

Line 73: FII_UTIL.Write_Log ('Initialize: Set Trace On');

69: -- Turn trace on if process is run in debug mode
70: IF (FIIDIM_Debug) THEN
71: -- Program running in debug mode, turning trace on
72: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';
73: FII_UTIL.Write_Log ('Initialize: Set Trace On');
74: END IF;
75:
76: IF (FIIDIM_Debug) THEN
77: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Company Cost Center Mapping');

Line 77: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Company Cost Center Mapping');

73: FII_UTIL.Write_Log ('Initialize: Set Trace On');
74: END IF;
75:
76: IF (FIIDIM_Debug) THEN
77: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Company Cost Center Mapping');
78: End If;
79:
80: -- --------------------------------------------------------
81: -- Find the unassigned ID for company and cost center

Line 103: FII_UTIL.Write_Log ('Set up for Company not done');

99: WHERE DIMENSION_SHORT_NAME = 'FII_COMPANIES';
100:
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: FII_UTIL.Write_Log ('Set up for Company not done');
104: G_CO_MAP_SEG := NULL;
105: END;
106:
107: BEGIN

Line 115: FII_UTIL.Write_Log ('Set up for Cost Center not done');

111: WHERE DIMENSION_SHORT_NAME = 'HRI_CL_ORGCC';
112:
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN
115: FII_UTIL.Write_Log ('Set up for Cost Center not done');
116: G_CC_MAP_SEG := NULL;
117: END;
118:
119: IF (FIIDIM_Debug) THEN

Line 120: FII_UTIL.Write_Log ('COST CENTER is Mapped to segment : '|| G_CC_MAP_SEG );

116: G_CC_MAP_SEG := NULL;
117: END;
118:
119: IF (FIIDIM_Debug) THEN
120: FII_UTIL.Write_Log ('COST CENTER is Mapped to segment : '|| G_CC_MAP_SEG );
121: FII_UTIL.Write_Log ('COMPANY is Mapped to segment : '|| G_CO_MAP_SEG);
122: END IF;
123:
124:

Line 121: FII_UTIL.Write_Log ('COMPANY is Mapped to segment : '|| G_CO_MAP_SEG);

117: END;
118:
119: IF (FIIDIM_Debug) THEN
120: FII_UTIL.Write_Log ('COST CENTER is Mapped to segment : '|| G_CC_MAP_SEG );
121: FII_UTIL.Write_Log ('COMPANY is Mapped to segment : '|| G_CO_MAP_SEG);
122: END IF;
123:
124:
125:

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 130: FII_UTIL.Write_Log ('G_PHASE : ' || g_phase);

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

Line 136: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');

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...');
137: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
138: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
139: RAISE;
140:

Line 137: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);

133: raise;
134:
135: When others then
136: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
137: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
138: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
139: RAISE;
140:
141: END Initialize;

Line 138: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));

134:
135: When others then
136: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
137: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
138: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
139: RAISE;
140:
141: END Initialize;
142:

Line 212: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAP_GT');

208: 'COST CENTER', g.cost_center_id, G_UNASSIGNED_ID) =
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

Line 219: FII_UTIL.Write_Log ('Unexpected error when calling Populate_com_cc_Maps...');

215:
216: Exception
217:
218: When others then
219: FII_UTIL.Write_Log ('Unexpected error when calling Populate_com_cc_Maps...');
220: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
221: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
222: RAISE;
223:

Line 220: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);

216: Exception
217:
218: When others then
219: FII_UTIL.Write_Log ('Unexpected error when calling Populate_com_cc_Maps...');
220: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
221: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
222: RAISE;
223:
224: END Populate_com_cc_Maps;

Line 221: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));

217:
218: When others then
219: FII_UTIL.Write_Log ('Unexpected error when calling Populate_com_cc_Maps...');
220: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
221: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
222: RAISE;
223:
224: END Populate_com_cc_Maps;
225:

Line 256: FII_UTIL.truncate_table ('FII_COM_CC_DIM_MAPS', 'FII', g_retcode);

252: -- Now all the mappings are populated in the GT table.
253: -- Copy data from GT table to Mappings table
254: g_phase := 'Copy from FII_COM_CC_DIM_MAP_GT to FII_COM_CC_DIM_MAPS';
255:
256: FII_UTIL.truncate_table ('FII_COM_CC_DIM_MAPS', 'FII', g_retcode);
257:
258: Insert into /*+ APPEND */ FII_COM_CC_DIM_MAPS (
259: PARENT_COMPANY_DIM_ID,
260: CHILD_COMPANY_ID,

Line 281: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');

277: FII_LOGIN_ID
278: FROM FII_COM_CC_DIM_MAPS_GT;
279:
280: IF (FIIDIM_Debug) THEN
281: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');
282: END IF;
283:
284:
285: FND_CONCURRENT.Af_Commit;

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 322: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

318: ret_val := FND_CONCURRENT.Set_Completion_Status
319: (status => 'ERROR', message => substr(sqlerrm,1,180));
320:
321: WHEN OTHERS THEN
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');

Line 323: FII_UTIL.Write_Log (

319: (status => 'ERROR', message => substr(sqlerrm,1,180));
320:
321: WHEN OTHERS THEN
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;

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

383: FROM FII_COM_CC_DIM_MAPS_GT);
384:
385:
386: IF (FIIDIM_Debug) THEN
387: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');
388: END IF;
389:
390:
391: Insert into FII_COM_CC_DIM_MAPS (

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

422: FII_LOGIN_ID
423: FROM FII_COM_CC_DIM_MAPS);
424:
425: IF (FIIDIM_Debug) THEN
426: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_DIM_MAPS');
427: END IF;
428:
429: FND_CONCURRENT.Af_Commit;
430:

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 465: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

461: ret_val := FND_CONCURRENT.Set_Completion_Status
462: (status => 'ERROR', message => 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:

Line 466: FII_UTIL.Write_Log (

462: (status => 'ERROR', message => 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;