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

Line 78: FII_UTIL.Write_Log (

74: return l_vs_name;
75:
76: Exception
77: when others then
78: FII_UTIL.Write_Log (
79: 'Unexpected error when calling Get_Value_Set_Name...');
80: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,80));
81: FII_UTIL.Write_Log ('Value Set ID: ' || p_vs_id);
82: RAISE;

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

76: Exception
77: when others then
78: FII_UTIL.Write_Log (
79: 'Unexpected error when calling Get_Value_Set_Name...');
80: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,80));
81: FII_UTIL.Write_Log ('Value Set ID: ' || p_vs_id);
82: RAISE;
83:
84: End Get_Value_Set_Name;

Line 81: FII_UTIL.Write_Log ('Value Set ID: ' || p_vs_id);

77: when others then
78: FII_UTIL.Write_Log (
79: 'Unexpected error when calling Get_Value_Set_Name...');
80: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,80));
81: FII_UTIL.Write_Log ('Value Set ID: ' || p_vs_id);
82: RAISE;
83:
84: End Get_Value_Set_Name;
85:

Line 110: FII_UTIL.Write_Log (

106: return l_flex_value;
107:
108: Exception
109: when others then
110: FII_UTIL.Write_Log (
111: 'Unexpected error when calling Get_Flex_Value...');
112: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,80));
113: FII_UTIL.Write_Log ('Value ID: ' || p_flex_value_id);
114: RAISE;

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

108: Exception
109: when others then
110: FII_UTIL.Write_Log (
111: 'Unexpected error when calling Get_Flex_Value...');
112: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,80));
113: FII_UTIL.Write_Log ('Value ID: ' || p_flex_value_id);
114: RAISE;
115:
116: End Get_Flex_Value;

Line 113: FII_UTIL.Write_Log ('Value ID: ' || p_flex_value_id);

109: when others then
110: FII_UTIL.Write_Log (
111: 'Unexpected error when calling Get_Flex_Value...');
112: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,80));
113: FII_UTIL.Write_Log ('Value ID: ' || p_flex_value_id);
114: RAISE;
115:
116: End Get_Flex_Value;
117:

Line 140: l_dir := FII_UTIL.get_utl_file_dir;

136: -- Set default directory in case if the profile option
137: -- BIS_DEBUG_LOG_DIRECTORY is not set up
138: ------------------------------------------------------
139: if l_dir is NULL then
140: l_dir := FII_UTIL.get_utl_file_dir;
141: end if;
142:
143: ----------------------------------------------------------------
144: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

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

140: l_dir := FII_UTIL.get_utl_file_dir;
141: end if;
142:
143: ----------------------------------------------------------------
144: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
145: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
146: -- the log files and output files are written to
147: ----------------------------------------------------------------
148: FII_UTIL.initialize('FII_CC_MAINTAIN_PKG.log',

Line 148: FII_UTIL.initialize('FII_CC_MAINTAIN_PKG.log',

144: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
145: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
146: -- the log files and output files are written to
147: ----------------------------------------------------------------
148: FII_UTIL.initialize('FII_CC_MAINTAIN_PKG.log',
149: 'FII_CC_MAINTAIN_PKG.out',l_dir,'FII_CC_MAINTAIN_PKG' );
150:
151: -- --------------------------------------------------------
152: -- Check source ledger setup for DBI

Line 157: FII_UTIL.write_log('>>> No source ledger setup for DBI');

153: -- --------------------------------------------------------
154: l_check := FII_EXCEPTION_CHECK_PKG.check_slg_setup;
155:
156: if l_check <> 0 then
157: FII_UTIL.write_log('>>> No source ledger setup for DBI');
158: RAISE CCDIM_fatal_err;
159: end if;
160:
161: -- --------------------------------------------------------

Line 177: g_schema_name := FII_UTIL.get_schema_name ('FII');

173: elsif l_check < 0 then
174: RAISE CCDIM_fatal_err;
175: end if;
176: -- Obtain FII schema name
177: g_schema_name := FII_UTIL.get_schema_name ('FII');
178:
179: -- Obtain user ID, login ID and initialize package variables
180: FII_USER_ID := FND_GLOBAL.USER_ID;
181: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;

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

181: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
182:
183: -- If any of the above values is not set, error out
184: IF (FII_User_Id is NULL OR FII_Login_Id is NULL) THEN
185: FII_UTIL.Write_Log ('>>> Failed Intialization');
186: RAISE CCDIM_fatal_err;
187: END IF;
188:
189: -- Determine if process will be run in debug mode

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

188:
189: -- Determine if process will be run in debug mode
190: IF (NVL(G_Debug_Mode, 'N') <> 'N') THEN
191: FIIDIM_Debug := TRUE;
192: FII_UTIL.Write_Log (' Debug On');
193: ELSE
194: FIIDIM_Debug := FALSE;
195: FII_UTIL.Write_Log (' Debug Off');
196: END IF;

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

191: FIIDIM_Debug := TRUE;
192: FII_UTIL.Write_Log (' Debug On');
193: ELSE
194: FIIDIM_Debug := FALSE;
195: FII_UTIL.Write_Log (' Debug Off');
196: END IF;
197:
198: -- Turn trace on if process is run in debug mode
199: IF (FIIDIM_Debug) THEN

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

198: -- Turn trace on if process is run in debug mode
199: IF (FIIDIM_Debug) THEN
200: -- Program running in debug mode, turning trace on
201: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';
202: FII_UTIL.Write_Log ('Initialize: Set Trace On');
203: END IF;
204:
205: IF (FIIDIM_Debug) THEN
206: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Cost Center dimension');

Line 206: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Cost Center dimension');

202: FII_UTIL.Write_Log ('Initialize: Set Trace On');
203: END IF;
204:
205: IF (FIIDIM_Debug) THEN
206: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Cost Center dimension');
207: End If;
208:
209: -- --------------------------------------------------------
210: -- Find the unassigned cost center ID

Line 265: FII_UTIL.Write_Log ('More than one master value set found for COST CENTER Dimension');

261: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
262: token_num => 0);
263: RAISE CCDIM_fatal_err;
264: When TOO_MANY_ROWS Then
265: FII_UTIL.Write_Log ('More than one master value set found for COST CENTER Dimension');
266: RAISE CCDIM_fatal_err;
267: When CCDIM_NOT_ENABLED then
268: raise;
269: When CCDIM_fatal_err then

Line 272: FII_UTIL.Write_Log ('Unexpected error when getting master value set for COST CENTER Dimension');

268: raise;
269: When CCDIM_fatal_err then
270: raise;
271: When OTHERS Then
272: FII_UTIL.Write_Log ('Unexpected error when getting master value set for COST CENTER Dimension');
273: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
274: RAISE CCDIM_fatal_err;
275: End;
276:

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

269: When CCDIM_fatal_err then
270: raise;
271: When OTHERS Then
272: FII_UTIL.Write_Log ('Unexpected error when getting master value set for COST CENTER Dimension');
273: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
274: RAISE CCDIM_fatal_err;
275: End;
276:
277: IF (FIIDIM_Debug) THEN

Line 278: FII_UTIL.Write_Log ('COST CENTER Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);

274: RAISE CCDIM_fatal_err;
275: End;
276:
277: IF (FIIDIM_Debug) THEN
278: FII_UTIL.Write_Log ('COST CENTER Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
279: FII_UTIL.Write_Log ('COST CENTER Master Value Set: '||
280: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
281: FII_UTIL.Write_Log (' and COST CENTER Top Node: '|| G_TOP_NODE_VALUE);
282: END IF;

Line 279: FII_UTIL.Write_Log ('COST CENTER Master Value Set: '||

275: End;
276:
277: IF (FIIDIM_Debug) THEN
278: FII_UTIL.Write_Log ('COST CENTER Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
279: FII_UTIL.Write_Log ('COST CENTER Master Value Set: '||
280: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
281: FII_UTIL.Write_Log (' and COST CENTER Top Node: '|| G_TOP_NODE_VALUE);
282: END IF;
283:

Line 281: FII_UTIL.Write_Log (' and COST CENTER Top Node: '|| G_TOP_NODE_VALUE);

277: IF (FIIDIM_Debug) THEN
278: FII_UTIL.Write_Log ('COST CENTER Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
279: FII_UTIL.Write_Log ('COST CENTER Master Value Set: '||
280: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
281: FII_UTIL.Write_Log (' and COST CENTER Top Node: '|| G_TOP_NODE_VALUE);
282: END IF;
283:
284:
285: -- Check if the master value set is a table validated set.

Line 308: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

304:
305: Exception
306:
307: When CCDIM_NOT_ENABLED then
308: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
309: --Let the main program handle this
310: raise;
311:
312: When CCDIM_fatal_err then

Line 313: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Initialize : '|| 'User defined error');

309: --Let the main program handle this
310: raise;
311:
312: When CCDIM_fatal_err then
313: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Initialize : '|| 'User defined error');
314: FND_CONCURRENT.Af_Rollback;
315: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.Initialize');
316: raise;
317:

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

315: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.Initialize');
316: raise;
317:
318: When others then
319: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
320: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
321: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
322: RAISE;
323:

Line 320: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

316: raise;
317:
318: When others then
319: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
320: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
321: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
322: RAISE;
323:
324: END Initialize;

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

317:
318: When others then
319: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
320: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
321: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
322: RAISE;
323:
324: END Initialize;
325:

Line 457: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||

453: END IF;
454: Exception
455:
456: When CCDIM_fatal_err then
457: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
458:
459:
460: 'User defined error');
461: FND_CONCURRENT.Af_Rollback;

Line 466: FII_UTIL.Write_Log ('Unexpected error when calling Get_NORM_HIERARCHY_TMP.');

462: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
463: raise;
464:
465: When others then
466: FII_UTIL.Write_Log ('Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
467: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
468: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
469: RAISE;
470:

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

463: raise;
464:
465: When others then
466: FII_UTIL.Write_Log ('Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
467: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
468: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
469: RAISE;
470:
471: END Get_NORM_HIERARCHY_TMP;

Line 468: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

464:
465: When others then
466: FII_UTIL.Write_Log ('Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
467: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
468: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
469: RAISE;
470:
471: END Get_NORM_HIERARCHY_TMP;
472:

Line 544: FII_UTIL.Write_Output (

540: l_vset_name := Get_Value_Set_Name (dup_asg_par_rec.child_flex_value_set_id);
541: l_parent_flex_value:= Get_Flex_Value (dup_asg_par_rec.parent_cc_id);
542: l_parent_vset_name := Get_Value_Set_Name (dup_asg_par_rec.parent_flex_value_set_id);
543:
544: FII_UTIL.Write_Output (
545: l_flex_value || ' '||
546: l_vset_name || ' '||
547: l_parent_flex_value || ' '||
548: l_parent_vset_name);

Line 564: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Detect_Diamond_Shape: '||

560:
561: Exception
562:
563: When CCDIM_MULT_PAR_err then
564: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Detect_Diamond_Shape: '||
565: 'diamond shape detected!');
566: RAISE;
567:
568: When others then

Line 569: FII_UTIL.Write_Log ('Unexpected error when calling Detect_Diamond_Shape.');

565: 'diamond shape detected!');
566: RAISE;
567:
568: When others then
569: FII_UTIL.Write_Log ('Unexpected error when calling Detect_Diamond_Shape.');
570: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
571: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
572: RAISE;
573:

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

566: RAISE;
567:
568: When others then
569: FII_UTIL.Write_Log ('Unexpected error when calling Detect_Diamond_Shape.');
570: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
571: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
572: RAISE;
573:
574: END Detect_Diamond_Shape;

Line 571: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

567:
568: When others then
569: FII_UTIL.Write_Log ('Unexpected error when calling Detect_Diamond_Shape.');
570: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
571: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
572: RAISE;
573:
574: END Detect_Diamond_Shape;
575:

Line 676: FII_UTIL.Write_Log ('Insert Immediate child: No Data Found');

672: FND_CONCURRENT.Af_Commit;
673:
674: EXCEPTION
675: WHEN NO_DATA_FOUND Then
676: FII_UTIL.Write_Log ('Insert Immediate child: No Data Found');
677: FII_MESSAGE.Func_Fail
678: (func_name => 'FII_CC_MAINTAIN_PKG.Insert_Imm_Child_Nodes');
679: RAISE;
680:

Line 682: FII_UTIL.Write_Log (substr(SQLERRM,1,180));

678: (func_name => 'FII_CC_MAINTAIN_PKG.Insert_Imm_Child_Nodes');
679: RAISE;
680:
681: WHEN OTHERS Then
682: FII_UTIL.Write_Log (substr(SQLERRM,1,180));
683: FII_MESSAGE.Func_Fail
684: (func_name => 'FII_CC_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
685: RAISE;
686:

Line 710: FII_UTIL.truncate_table ('FII_COST_CTR_HIER_GT', 'FII', g_retcode);

706: FII_MESSAGE.Func_Ent(func_name => 'FII_CC_MAINTAIN_PKG.'||
707: 'Flatten_CC_Dim_Hier');
708: END IF;
709: g_phase := 'Truncate table FII_CC_HIER_GT';
710: FII_UTIL.truncate_table ('FII_COST_CTR_HIER_GT', 'FII', g_retcode);
711:
712: -----------------------------------------------------------------
713:
714: CCDIM_parent_node := p_root_node;

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

754: 'N'
755: from (select distinct child_cc_id,child_level,child_flex_value_set_id from fii_cOST_CTR_hier_gt);
756:
757: IF (FIIDIM_Debug) THEN
758: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_ctr_hier_gt');
759: END IF;
760:
761: INSERT INTO fii_COST_CTR_hier_gt
762: (parent_level,

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

781: 'N',
782: 'N');
783:
784: IF (FIIDIM_Debug) THEN
785: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_ctr_hier_gt');
786: END IF;
787:
788: --Insert the UNASSIGNED to the hierarchy table.
789: --Use top node as the parent

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

813: 'N',
814: 'N');
815:
816: IF (FIIDIM_Debug) THEN
817: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_ctr_hier_gt');
818: END IF;
819:
820: -- Another one is (UNASSIGNED, UNASSIGNED, UNASSIGNED)
821: INSERT INTO fii_COST_CTR_hier_gt

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

841: 'N',
842: 'N');
843:
844: IF (FIIDIM_Debug) THEN
845: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_ctr_hier_gt');
846: END IF;
847:
848: -- Insert a dummy super top node (-999) to the hierarchy table
849: -- (the dummy value set id is -998)

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

875: WHERE child_cc_id = parent_cc_id;
876:
877:
878: IF (FIIDIM_Debug) THEN
879: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_ctr_hier_gt');
880: END IF;
881:
882: --Call FND_STATS to collect statistics after populating the table
883: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';

Line 914: FII_UTIL.Write_Log ('Flatten_CC_Dim_Hier: No Data Found');

910:
911: EXCEPTION
912:
913: WHEN NO_DATA_FOUND THEN
914: FII_UTIL.Write_Log ('Flatten_CC_Dim_Hier: No Data Found');
915: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.'||
916: 'Flatten_CC_Dim_Hier');
917: raise;
918:

Line 920: FII_UTIL.Write_Log ('Flatten_CC_Dim_Hier: Diamond Shape Detected');

916: 'Flatten_CC_Dim_Hier');
917: raise;
918:
919: WHEN CCDIM_MULT_PAR_err THEN
920: FII_UTIL.Write_Log ('Flatten_CC_Dim_Hier: Diamond Shape Detected');
921: FII_MESSAGE.Func_Fail (func_name =>
922: 'FII_DIMENSION_MAINTAIN_PKG.Flatten_CC_Dim_Hier');
923: raise;
924:

Line 926: FII_UTIL.Write_Log ('Flatten_CC_Dim_Hier: '|| substr(sqlerrm,1,180));

922: 'FII_DIMENSION_MAINTAIN_PKG.Flatten_CC_Dim_Hier');
923: raise;
924:
925: WHEN OTHERS THEN
926: FII_UTIL.Write_Log ('Flatten_CC_Dim_Hier: '|| substr(sqlerrm,1,180));
927: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.'||
928: 'Flatten_CC_Dim_Hier');
929: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
930: raise;

Line 929: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

925: WHEN OTHERS THEN
926: FII_UTIL.Write_Log ('Flatten_CC_Dim_Hier: '|| substr(sqlerrm,1,180));
927: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.'||
928: 'Flatten_CC_Dim_Hier');
929: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
930: raise;
931:
932: END Flatten_CC_Dim_Hier;
933:

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

1017: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID
1018: And child_flex_value_set_id <> G_FII_INT_VALUE_SET_ID;
1019:
1020: IF (FIIDIM_Debug) THEN
1021: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from fii_COST_CTR_hier_gt');
1022: END IF;
1023:
1024: Get_level_populated;
1025:

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

1041: group by tab3.next_level_cc_id
1042: having count(*) = 1);
1043:
1044: IF (FIIDIM_Debug) THEN
1045: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_COST_CTR_hier_gt');
1046: END IF;
1047:
1048:
1049: -- Update the column is_leaf_flag

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

1053: Where parent_cc_id = child_cc_id
1054: and next_level_is_leaf_flag = 'Y';
1055:
1056: IF (FIIDIM_Debug) THEN
1057: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_COST_CTR_hier_gt');
1058: END IF;
1059:
1060: IF (FIIDIM_Debug) THEN
1061: FII_MESSAGE.Func_Succ(func_name => 'FII_CC_MAINTAIN_PKG.'||

Line 1067: FII_UTIL.Write_Log ('Get_Pruned_CC_GT -> phase: '|| g_phase);

1063: END IF;
1064: EXCEPTION
1065:
1066: WHEN OTHERS THEN
1067: FII_UTIL.Write_Log ('Get_Pruned_CC_GT -> phase: '|| g_phase);
1068: FII_UTIL.Write_Log ('Get_Pruned_CC_GT: '|| substr(sqlerrm,1,180));
1069: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.'||
1070: 'Get_Pruned_CC_GT');
1071: raise;

Line 1068: FII_UTIL.Write_Log ('Get_Pruned_CC_GT: '|| substr(sqlerrm,1,180));

1064: EXCEPTION
1065:
1066: WHEN OTHERS THEN
1067: FII_UTIL.Write_Log ('Get_Pruned_CC_GT -> phase: '|| g_phase);
1068: FII_UTIL.Write_Log ('Get_Pruned_CC_GT: '|| substr(sqlerrm,1,180));
1069: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.'||
1070: 'Get_Pruned_CC_GT');
1071: raise;
1072:

Line 1105: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);

1101: -- disabled now, in which case initial refresh of MV should happen
1102: -- so it is ok to truncate the tables
1103:
1104: g_phase := 'Truncate dimension hierarchy tables';
1105: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1106: FII_UTIL.truncate_table ('FII_COST_CTR_HIERARCHIES', 'FII', g_retcode);
1107:
1108: INSERT INTO FII_FULL_COST_CTR_HIERS
1109: (parent_level,

Line 1106: FII_UTIL.truncate_table ('FII_COST_CTR_HIERARCHIES', 'FII', g_retcode);

1102: -- so it is ok to truncate the tables
1103:
1104: g_phase := 'Truncate dimension hierarchy tables';
1105: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1106: FII_UTIL.truncate_table ('FII_COST_CTR_HIERARCHIES', 'FII', g_retcode);
1107:
1108: INSERT INTO FII_FULL_COST_CTR_HIERS
1109: (parent_level,
1110: parent_cc_id,

Line 1195: FII_UTIL.Write_Log ('Handle_Unenabled_DIM: '|| substr(sqlerrm,1,180));

1191:
1192: EXCEPTION
1193:
1194: WHEN OTHERS THEN
1195: FII_UTIL.Write_Log ('Handle_Unenabled_DIM: '|| substr(sqlerrm,1,180));
1196: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.'||
1197: 'Handle_Unenabled_DIM');
1198: raise;
1199:

Line 1234: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);

1230:
1231: --Copy TMP hierarchy table to the final dimension table
1232: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1233:
1234: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1235:
1236: INSERT /*+ APPEND */ INTO FII_FULL_COST_CTR_HIERS (
1237: parent_level,
1238: parent_cc_id,

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

1267: FII_LOGIN_ID
1268: FROM FII_COST_CTR_HIER_GT;
1269:
1270: IF (FIIDIM_Debug) THEN
1271: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COST_CTR_HIERS');
1272: END IF;
1273:
1274:
1275: --Call FND_STATS to collect statistics after re-populating the tables.

Line 1291: FII_UTIL.truncate_table ('FII_COST_CTR_HIERARCHIES', 'FII', g_retcode);

1287:
1288: --Copy FII_CC_HIER_GT to the final (pruned) dimension table
1289: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1290:
1291: FII_UTIL.truncate_table ('FII_COST_CTR_HIERARCHIES', 'FII', g_retcode);
1292:
1293: INSERT /*+ APPEND */ INTO FII_COST_CTR_HIERARCHIES (
1294: parent_level,
1295: parent_cc_id,

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

1337: FROM FII_COST_CTR_HIER_GT;
1338:
1339:
1340: IF (FIIDIM_Debug) THEN
1341: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
1342: END IF;
1343:
1344: -- This will be in RSG data
1345: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';

Line 1369: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Init_Load: '||

1365: EXCEPTION
1366:
1367: WHEN CCDIM_fatal_err THEN
1368:
1369: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Init_Load: '||
1370: 'User defined error');
1371:
1372: FND_CONCURRENT.Af_Rollback;
1373: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.Init_Load');

Line 1379: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Init_Load: '||

1375: ret_val := FND_CONCURRENT.Set_Completion_Status
1376: (status => 'ERROR', message => substr(sqlerrm,1,180));
1377:
1378: WHEN CCDIM_MULT_PAR_err THEN
1379: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Init_Load: '||
1380: 'Diamond Shape Detected');
1381:
1382: FND_CONCURRENT.Af_Rollback;
1383: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.Init_Load');

Line 1389: FII_UTIL.Write_Log ('>>> COST CENTER Dimension Not Enabled...');

1385: ret_val := FND_CONCURRENT.Set_Completion_Status
1386: (status => 'ERROR', message => substr(sqlerrm,1,180));
1387:
1388: WHEN CCDIM_NOT_ENABLED THEN
1389: FII_UTIL.Write_Log ('>>> COST CENTER Dimension Not Enabled...');
1390:
1391: Handle_Unenabled_DIM;
1392:
1393: retcode := sqlcode;

Line 1398: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

1394: --ret_val := FND_CONCURRENT.Set_Completion_Status
1395: -- (status => 'NORMAL', message => NULL);
1396:
1397: WHEN OTHERS THEN
1398: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1399: FII_UTIL.Write_Log (
1400: 'Other error in FII_CC_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1401:
1402:

Line 1399: FII_UTIL.Write_Log (

1395: -- (status => 'NORMAL', message => NULL);
1396:
1397: WHEN OTHERS THEN
1398: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1399: FII_UTIL.Write_Log (
1400: 'Other error in FII_CC_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1401:
1402:
1403: FND_CONCURRENT.Af_Rollback;

Line 1441: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);

1437: Flatten_CC_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1438:
1439:
1440: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1441: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1442:
1443: Insert into FII_FULL_COST_CTR_HIERS (
1444: parent_level,
1445: parent_cc_id,

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

1473: FII_LOGIN_ID
1474: FROM FII_COST_CTR_HIER_GT;
1475:
1476: IF (FIIDIM_Debug) THEN
1477: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COST_CTR_HIERS');
1478: END IF;
1479:
1480: --Call FND_STATS to collect statistics after re-populating the tables.
1481: --for the full dimension table since it will be used later

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

1533: FROM FII_COST_CTR_HIER_GT);
1534:
1535:
1536: IF (FIIDIM_Debug) THEN
1537: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_COST_CTR_HIERARCHIES');
1538: END IF;
1539:
1540: Insert into FII_COST_CTR_HIERARCHIES (
1541: parent_level,

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

1605: FII_LOGIN_ID
1606: FROM FII_COST_CTR_HIERARCHIES);
1607:
1608: IF (FIIDIM_Debug) THEN
1609: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
1610: END IF;
1611:
1612: -- This is in RSG data
1613: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';

Line 1637: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Incre_Update'||

1633: -- Exception handling
1634:
1635: EXCEPTION
1636: WHEN CCDIM_fatal_err THEN
1637: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Incre_Update'||
1638: 'User defined error');
1639:
1640: FND_CONCURRENT.Af_Rollback;
1641: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.Incre_Update');

Line 1647: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Incre_Update: '||

1643: ret_val := FND_CONCURRENT.Set_Completion_Status
1644: (status => 'ERROR', message => substr(sqlerrm,1,180));
1645:
1646: WHEN CCDIM_MULT_PAR_err THEN
1647: FII_UTIL.Write_Log ('FII_CC_MAINTAIN_PKG.Incre_Update: '||
1648: 'Diamond Shape Detected');
1649:
1650: FND_CONCURRENT.Af_Rollback;
1651: FII_MESSAGE.Func_Fail(func_name => 'FII_CC_MAINTAIN_PKG.Incre_Update');

Line 1657: FII_UTIL.Write_Log ('>>> COST CENTER Dimension Not Enabled...');

1653: ret_val := FND_CONCURRENT.Set_Completion_Status
1654: (status => 'ERROR', message => substr(sqlerrm,1,180));
1655:
1656: WHEN CCDIM_NOT_ENABLED THEN
1657: FII_UTIL.Write_Log ('>>> COST CENTER Dimension Not Enabled...');
1658:
1659: Handle_Unenabled_DIM;
1660:
1661: retcode := sqlcode;

Line 1666: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

1662: -- ret_val := FND_CONCURRENT.Set_Completion_Status
1663: -- (status => 'NORMAL', message => NULL);
1664:
1665: WHEN OTHERS THEN
1666: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1667: FII_UTIL.Write_Log (
1668: 'Other error in FII_CC_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1669:
1670:

Line 1667: FII_UTIL.Write_Log (

1663: -- (status => 'NORMAL', message => NULL);
1664:
1665: WHEN OTHERS THEN
1666: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1667: FII_UTIL.Write_Log (
1668: 'Other error in FII_CC_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1669:
1670:
1671: FND_CONCURRENT.Af_Rollback;