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

Line 79: FII_UTIL.Write_Log(

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

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

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

Line 82: FII_UTIL.WRITE_LOG ( 'Value Set ID: ' || p_vs_id);

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

Line 112: FII_UTIL.Write_Log (

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

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

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

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

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

Line 145: FII_UTIL.Write_Log( 'DHM is locking out value set: ' || fvsid);

141: -- locking was successful
142: return;
143: elsif ( lkresult = 1 ) then
144: -- Dimension Hierarchy Manager is locking out value set
145: FII_UTIL.Write_Log( 'DHM is locking out value set: ' || fvsid);
146: app_exception.raise_exception;
147: else
148: FII_UTIL.Write_Log( 'Error when locking out value set: ' || fvsid);
149: app_exception.raise_exception;

Line 148: FII_UTIL.Write_Log( 'Error when locking out value set: ' || fvsid);

144: -- Dimension Hierarchy Manager is locking out value set
145: FII_UTIL.Write_Log( 'DHM is locking out value set: ' || fvsid);
146: app_exception.raise_exception;
147: else
148: FII_UTIL.Write_Log( 'Error when locking out value set: ' || fvsid);
149: app_exception.raise_exception;
150: end if;
151:
152: END lock_flex_value_set;

Line 175: l_dir := FII_UTIL.get_utl_file_dir ;

171: -- Set default directory in case if the profile option
172: -- BIS_DEBUG_LOG_DIRECTORY is not set up
173: ------------------------------------------------------
174: if l_dir is NULL then
175: l_dir := FII_UTIL.get_utl_file_dir ;
176: end if;
177:
178: ----------------------------------------------------------------
179: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

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

175: l_dir := FII_UTIL.get_utl_file_dir ;
176: end if;
177:
178: ----------------------------------------------------------------
179: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
180: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
181: -- the log files and output files are written to
182: ----------------------------------------------------------------
183: FII_UTIL.initialize('FII_FIN_CAT_MAINTAIN_PKG.log',

Line 183: FII_UTIL.initialize('FII_FIN_CAT_MAINTAIN_PKG.log',

179: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
180: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
181: -- the log files and output files are written to
182: ----------------------------------------------------------------
183: FII_UTIL.initialize('FII_FIN_CAT_MAINTAIN_PKG.log',
184: 'FII_FIN_CAT_MAINTAIN_PKG.out',l_dir, 'FII_FIN_CAT_MAINTAIN_PKG');
185:
186: -- --------------------------------------------------------
187: -- Check source ledger setup for DBI

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

188: -- --------------------------------------------------------
189: l_check := FII_EXCEPTION_CHECK_PKG.check_slg_setup;
190:
191: if l_check <> 0 then
192: FII_UTIL.write_log(' No source ledger setup for DBI');
193: RAISE FINDIM_fatal_err;
194: end if;
195:
196: -- --------------------------------------------------------

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

208: RAISE FINDIM_fatal_err;
209: end if;
210:
211: -- Obtain FII schema name
212: g_schema_name := FII_UTIL.get_schema_name ('FII');
213:
214: -- Obtain user ID, login ID and initialize package variables
215: FII_USER_ID := FND_GLOBAL.USER_ID;
216: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;

Line 221: FII_UTIL.Write_Log(' Fail Intialization');

217:
218: -- If any of the above values is not set, error out
219: IF (FII_User_Id is NULL OR FII_Login_Id is NULL) THEN
220: -- Fail to initialize
221: FII_UTIL.Write_Log(' Fail Intialization');
222: RAISE FINDIM_fatal_err;
223: END IF;
224:
225: -- Determine if process will be run in debug mode

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

224:
225: -- Determine if process will be run in debug mode
226: IF (NVL(G_Debug_Mode, 'N') <> 'N') THEN
227: FIIDIM_Debug := TRUE;
228: FII_UTIL.Write_Log('Debug On');
229: ELSE
230: FIIDIM_Debug := FALSE;
231: FII_UTIL.Write_Log('Debug Off');
232: END IF;

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

227: FIIDIM_Debug := TRUE;
228: FII_UTIL.Write_Log('Debug On');
229: ELSE
230: FIIDIM_Debug := FALSE;
231: FII_UTIL.Write_Log('Debug Off');
232: END IF;
233:
234: -- Turn trace on if process is run in debug mode
235: IF (FIIDIM_Debug) THEN

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

234: -- Turn trace on if process is run in debug mode
235: IF (FIIDIM_Debug) THEN
236: -- Program running in debug mode, turning trace on
237: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';
238: FII_UTIL.Write_Log('Initialize: Set Trace On');
239: END IF;
240:
241: IF (FIIDIM_Debug) THEN
242: FII_UTIL.Write_Log('Initialize: Now start processing '||

Line 242: FII_UTIL.Write_Log('Initialize: Now start processing '||

238: FII_UTIL.Write_Log('Initialize: Set Trace On');
239: END IF;
240:
241: IF (FIIDIM_Debug) THEN
242: FII_UTIL.Write_Log('Initialize: Now start processing '||
243: 'Financial Category Dimension');
244: End If;
245:
246: --Get the master value set and top node for Financial Category

Line 278: FII_UTIL.Write_Log ('More than one master value set found for Financial Category Dimension');

274: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
275: token_num => 0);
276: RAISE FINDIM_fatal_err;
277: When TOO_MANY_ROWS Then
278: FII_UTIL.Write_Log ('More than one master value set found for Financial Category Dimension');
279: RAISE FINDIM_fatal_err;
280: When OTHERS Then
281: FII_UTIL.Write_Log ('Unexpected error when getting master value set for Financial Category Dimension');
282: FII_UTIL.WRITE_LOG ('Error Message: '|| substr(sqlerrm,1,180));

Line 281: FII_UTIL.Write_Log ('Unexpected error when getting master value set for Financial Category Dimension');

277: When TOO_MANY_ROWS Then
278: FII_UTIL.Write_Log ('More than one master value set found for Financial Category Dimension');
279: RAISE FINDIM_fatal_err;
280: When OTHERS Then
281: FII_UTIL.Write_Log ('Unexpected error when getting master value set for Financial Category Dimension');
282: FII_UTIL.WRITE_LOG ('Error Message: '|| substr(sqlerrm,1,180));
283: RAISE FINDIM_fatal_err;
284: End;
285:

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

278: FII_UTIL.Write_Log ('More than one master value set found for Financial Category Dimension');
279: RAISE FINDIM_fatal_err;
280: When OTHERS Then
281: FII_UTIL.Write_Log ('Unexpected error when getting master value set for Financial Category Dimension');
282: FII_UTIL.WRITE_LOG ('Error Message: '|| substr(sqlerrm,1,180));
283: RAISE FINDIM_fatal_err;
284: End;
285:
286: IF (FIIDIM_Debug) THEN

Line 287: FII_UTIL.Write_Log('Financial Category Master Value Set Id: '

283: RAISE FINDIM_fatal_err;
284: End;
285:
286: IF (FIIDIM_Debug) THEN
287: FII_UTIL.Write_Log('Financial Category Master Value Set Id: '
288: || G_MASTER_VALUE_SET_ID);
289: FII_UTIL.Write_Log('Financial Category Master Value Set Name: '
290: || Get_Value_Set_Name(G_MASTER_VALUE_SET_ID));
291: FII_UTIL.Write_Log(' and Financial Category Top Node: '

Line 289: FII_UTIL.Write_Log('Financial Category Master Value Set Name: '

285:
286: IF (FIIDIM_Debug) THEN
287: FII_UTIL.Write_Log('Financial Category Master Value Set Id: '
288: || G_MASTER_VALUE_SET_ID);
289: FII_UTIL.Write_Log('Financial Category Master Value Set Name: '
290: || Get_Value_Set_Name(G_MASTER_VALUE_SET_ID));
291: FII_UTIL.Write_Log(' and Financial Category Top Node: '
292: || G_TOP_NODE_VALUE);
293: END IF;

Line 291: FII_UTIL.Write_Log(' and Financial Category Top Node: '

287: FII_UTIL.Write_Log('Financial Category Master Value Set Id: '
288: || G_MASTER_VALUE_SET_ID);
289: FII_UTIL.Write_Log('Financial Category Master Value Set Name: '
290: || Get_Value_Set_Name(G_MASTER_VALUE_SET_ID));
291: FII_UTIL.Write_Log(' and Financial Category Top Node: '
292: || G_TOP_NODE_VALUE);
293: END IF;
294:
295: -- Check if the master value set is a table validated set.

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

313:
314: Exception
315:
316: When FINDIM_NOT_ENABLED then
317: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
318: --Let the main program to handle this
319: raise;
320:
321: When FINDIM_fatal_err then

Line 322: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Initialize : '||

318: --Let the main program to handle this
319: raise;
320:
321: When FINDIM_fatal_err then
322: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Initialize : '||
323: 'User defined error');
324: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
325: -- Rollback
326: FND_CONCURRENT.Af_Rollback;

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

320:
321: When FINDIM_fatal_err then
322: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Initialize : '||
323: 'User defined error');
324: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
325: -- Rollback
326: FND_CONCURRENT.Af_Rollback;
327: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Initialize');
328: raise;

Line 331: FII_UTIL.Write_Log(

327: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Initialize');
328: raise;
329:
330: When others then
331: FII_UTIL.Write_Log(
332: 'Unexpected error when calling Initialize...');
333: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
334: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
335: RAISE;

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

329:
330: When others then
331: FII_UTIL.Write_Log(
332: 'Unexpected error when calling Initialize...');
333: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
334: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
335: RAISE;
336:
337: END Initialize;

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

330: When others then
331: FII_UTIL.Write_Log(
332: 'Unexpected error when calling Initialize...');
333: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
334: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
335: RAISE;
336:
337: END Initialize;
338:

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

396: and sts.source_ledger_group_id = slg.source_ledger_group_id
397: and slg.usage_code = 'DBI');
398:
399: IF (FIIDIM_Debug) THEN
400: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');
401: END IF;
402:
403: --Insert records for the master value set
404: g_phase := 'insert records for the master value set';

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

420: From FND_FLEX_VALUE_NORM_HIERARCHY
421: Where flex_value_set_id = G_MASTER_VALUE_SET_ID;
422:
423: IF (FIIDIM_Debug) THEN
424: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_DIM_NORM_HIER_GT');
425: END IF;
426:
427: --Insert records for all local (child) value sets
428: g_phase := 'Insert records for all local (child) value sets';

Line 478: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||

474:
475: Exception
476:
477: When FINDIM_fatal_err then
478: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
479: 'User defined error');
480: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
481: -- Rollback
482: FND_CONCURRENT.Af_Rollback;

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

476:
477: When FINDIM_fatal_err then
478: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
479: 'User defined error');
480: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
481: -- Rollback
482: FND_CONCURRENT.Af_Rollback;
483: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
484: raise;

Line 487: FII_UTIL.Write_Log(

483: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
484: raise;
485:
486: When others then
487: FII_UTIL.Write_Log(
488: 'Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
489: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
490: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
491: RAISE;

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

485:
486: When others then
487: FII_UTIL.Write_Log(
488: 'Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
489: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
490: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
491: RAISE;
492:
493: END Get_NORM_HIERARCHY_TMP;

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

486: When others then
487: FII_UTIL.Write_Log(
488: 'Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
489: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
490: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
491: RAISE;
492:
493: END Get_NORM_HIERARCHY_TMP;
494:

Line 566: FII_UTIL.Write_Output (

562: l_vset_name := Get_Value_Set_Name (dup_asg_par_rec.child_flex_value_set_id);
563: l_parent_flex_value:= Get_Flex_Value (dup_asg_par_rec.parent_fin_cat_id);
564: l_parent_vset_name := Get_Value_Set_Name (dup_asg_par_rec.parent_flex_value_set_id);
565:
566: FII_UTIL.Write_Output (
567: l_flex_value || ' '||
568: l_vset_name || ' '||
569: l_parent_flex_value || ' '||
570: l_parent_vset_name);

Line 587: FII_UTIL.Write_Log ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape: '||

583:
584: Exception
585:
586: When FINDIM_MULT_PAR_err then
587: FII_UTIL.Write_Log ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape: '||
588: 'diamond shape detected!');
589: RAISE;
590:
591: When others then

Line 592: FII_UTIL.Write_Log (

588: 'diamond shape detected!');
589: RAISE;
590:
591: When others then
592: FII_UTIL.Write_Log (
593: 'Unexpected error when calling Detect_Diamond_Shape.');
594: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
595: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
596: RAISE;

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

590:
591: When others then
592: FII_UTIL.Write_Log (
593: 'Unexpected error when calling Detect_Diamond_Shape.');
594: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
595: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
596: RAISE;
597:
598: END Detect_Diamond_Shape;

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

591: When others then
592: FII_UTIL.Write_Log (
593: 'Unexpected error when calling Detect_Diamond_Shape.');
594: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
595: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
596: RAISE;
597:
598: END Detect_Diamond_Shape;
599:

Line 701: FII_UTIL.WRITE_LOG ('Insert Immediate child: No Data Found');

697: FND_CONCURRENT.Af_Commit;
698:
699: EXCEPTION
700: WHEN NO_DATA_FOUND Then
701: FII_UTIL.WRITE_LOG ('Insert Immediate child: No Data Found');
702: FII_MESSAGE.Func_Fail
703: (func_name =>
704: 'FII_DIMENSION_MAINTAIN_PKG.Fin_Insert_Imm_Child_Nodes');
705: RAISE;

Line 708: FII_UTIL.WRITE_LOG( substr(SQLERRM,1,180));

704: 'FII_DIMENSION_MAINTAIN_PKG.Fin_Insert_Imm_Child_Nodes');
705: RAISE;
706:
707: WHEN OTHERS Then
708: FII_UTIL.WRITE_LOG( substr(SQLERRM,1,180));
709: FII_MESSAGE.Func_Fail
710: (func_name => 'FII_FIN_CAT_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
711: RAISE;
712:

Line 733: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIER_GT', 'FII', g_retcode);

729: 'Flatten_Fin_Dim_Hier');
730: END IF;
731:
732: g_phase := 'Truncate table FII_FIN_ITEM_HIER_GT';
733: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIER_GT', 'FII', g_retcode);
734:
735: -----------------------------------------------------------------
736:
737: FINDIM_parent_node := p_root_node;

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

779: 'N'
780: from (select distinct child_fin_cat_id,child_level,child_flex_value_set_id from fii_fin_item_hier_gt);
781:
782: IF (FIIDIM_Debug) THEN
783: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_fin_item_hier_gt');
784: END IF;
785:
786: g_phase := 'Insert self node for the top node';
787:

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

808: 'N',
809: 'N');
810:
811: IF (FIIDIM_Debug) THEN
812: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_fin_item_hier_gt');
813: END IF;
814:
815:
816: --Call FND_STATS to collect statistics after populating the table

Line 895: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: No Data Found');

891:
892: EXCEPTION
893:
894: WHEN NO_DATA_FOUND THEN
895: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: No Data Found');
896: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
897: 'Flatten_Fin_Dim_Hier');
898: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
899: raise;

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

894: WHEN NO_DATA_FOUND THEN
895: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: No Data Found');
896: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
897: 'Flatten_Fin_Dim_Hier');
898: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
899: raise;
900:
901: WhEN FINDIM_MULT_PAR_err THEN
902: FII_UTIL.WRITE_LOG ('Flatten_Fin_Dim_Hier: Diamond Shape Detected');

Line 902: FII_UTIL.WRITE_LOG ('Flatten_Fin_Dim_Hier: Diamond Shape Detected');

898: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
899: raise;
900:
901: WhEN FINDIM_MULT_PAR_err THEN
902: FII_UTIL.WRITE_LOG ('Flatten_Fin_Dim_Hier: Diamond Shape Detected');
903: FII_MESSAGE.Func_Fail (func_name =>
904: 'FII_DIMENSION_MAINTAIN_PKG.Flatten_Fin_Dim_Hier');
905: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
906: raise;

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

901: WhEN FINDIM_MULT_PAR_err THEN
902: FII_UTIL.WRITE_LOG ('Flatten_Fin_Dim_Hier: Diamond Shape Detected');
903: FII_MESSAGE.Func_Fail (func_name =>
904: 'FII_DIMENSION_MAINTAIN_PKG.Flatten_Fin_Dim_Hier');
905: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
906: raise;
907:
908: WHEN OTHERS THEN
909: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: '|| substr(sqlerrm,1,180));

Line 909: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: '|| substr(sqlerrm,1,180));

905: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
906: raise;
907:
908: WHEN OTHERS THEN
909: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: '|| substr(sqlerrm,1,180));
910: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
911: 'Flatten_Fin_Dim_Hier');
912: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
913: raise;

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

908: WHEN OTHERS THEN
909: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: '|| substr(sqlerrm,1,180));
910: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
911: 'Flatten_Fin_Dim_Hier');
912: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
913: raise;
914:
915: END Flatten_Fin_Dim_Hier;
916:

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

946: group by tab3.next_level_fin_cat_id
947: having count(*) = 1);
948:
949: IF (FIIDIM_Debug) THEN
950: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');
951: END IF;
952:
953: g_phase := 'Update is_leaf_flag';
954:

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

960: and next_level_fin_cat_id = child_fin_cat_id
961: and next_level_is_leaf = 'Y';
962:
963: IF (FIIDIM_Debug) THEN
964: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');
965: END IF;
966:
967: IF (FIIDIM_Debug) THEN
968: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

Line 975: FII_UTIL.Write_Log ('Update_GT -> phase: '|| g_phase);

971:
972: EXCEPTION
973:
974: WHEN OTHERS THEN
975: FII_UTIL.Write_Log ('Update_GT -> phase: '|| g_phase);
976: FII_UTIL.Write_Log ('Update_GT: '|| substr(sqlerrm,1,180));
977: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
978: 'Update_GT');
979: raise;

Line 976: FII_UTIL.Write_Log ('Update_GT: '|| substr(sqlerrm,1,180));

972: EXCEPTION
973:
974: WHEN OTHERS THEN
975: FII_UTIL.Write_Log ('Update_GT -> phase: '|| g_phase);
976: FII_UTIL.Write_Log ('Update_GT: '|| substr(sqlerrm,1,180));
977: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
978: 'Update_GT');
979: raise;
980:

Line 1033: FII_UTIL.Write_Log('Updating for parent and child : ' || r_stack( p_top ).cid || ' and ' || r_stack( c_top ).cid );

1029: ELSE
1030: n_top := p_top + 1;
1031: END IF;
1032:
1033: FII_UTIL.Write_Log('Updating for parent and child : ' || r_stack( p_top ).cid || ' and ' || r_stack( c_top ).cid );
1034:
1035: update fii_fin_item_hier_gt
1036: set LEVEL2_fin_cat_ID = r_stack( least( p_top + 1, c_top) ).cid
1037: , LEVEL3_fin_cat_ID = r_stack( least( p_top + 2, c_top ) ).cid

Line 1070: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');

1066: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID;
1067:
1068:
1069: IF (FIIDIM_Debug) THEN
1070: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');
1071: END IF;
1072:
1073: Get_level_populated ;
1074:

Line 1089: FII_UTIL.Write_Log ('Delete_LVS_Records -> phase: '|| g_phase);

1085:
1086: EXCEPTION
1087:
1088: WHEN OTHERS THEN
1089: FII_UTIL.Write_Log ('Delete_LVS_Records -> phase: '|| g_phase);
1090: FII_UTIL.Write_Log ('Delete_LVS_Records: '|| substr(sqlerrm,1,180));
1091: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1092: 'Delete_LVS_Records');
1093: raise;

Line 1090: FII_UTIL.Write_Log ('Delete_LVS_Records: '|| substr(sqlerrm,1,180));

1086: EXCEPTION
1087:
1088: WHEN OTHERS THEN
1089: FII_UTIL.Write_Log ('Delete_LVS_Records -> phase: '|| g_phase);
1090: FII_UTIL.Write_Log ('Delete_LVS_Records: '|| substr(sqlerrm,1,180));
1091: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1092: 'Delete_LVS_Records');
1093: raise;
1094:

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

1123: FROM FII_FIN_ITEM_HIERARCHIES ph
1124: WHERE ph.is_leaf_flag = 'Y');
1125:
1126: IF (FIIDIM_Debug) THEN
1127: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_MAPPINGS_GT');
1128: END IF;
1129:
1130: --Then, insert self-mapping records for all nodes in pruned hierarchy
1131: --FII_FIN_ITEM_HIERARCHIES. Note we should exclude all self leaf

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

1142: AND parent_fin_cat_id = child_fin_cat_id
1143: AND is_leaf_flag = 'N';
1144:
1145: IF (FIIDIM_Debug) THEN
1146: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_MAPPINGS_GT');
1147: END IF;
1148:
1149: --Call FND_STATS to collect statistics after populating the table
1150: g_phase := 'gather_table_stats for FII_FIN_CAT_MAPPINGS_GT';

Line 1163: FII_UTIL.Write_Log ('Get_FC_Mapping_GT -> phase: '|| g_phase);

1159:
1160: EXCEPTION
1161:
1162: WHEN OTHERS THEN
1163: FII_UTIL.Write_Log ('Get_FC_Mapping_GT -> phase: '|| g_phase);
1164: FII_UTIL.Write_Log ('Get_FC_Mapping_GT: '|| substr(sqlerrm,1,180));
1165: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1166: 'Get_FC_Mapping_GT');
1167: raise;

Line 1164: FII_UTIL.Write_Log ('Get_FC_Mapping_GT: '|| substr(sqlerrm,1,180));

1160: EXCEPTION
1161:
1162: WHEN OTHERS THEN
1163: FII_UTIL.Write_Log ('Get_FC_Mapping_GT -> phase: '|| g_phase);
1164: FII_UTIL.Write_Log ('Get_FC_Mapping_GT: '|| substr(sqlerrm,1,180));
1165: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1166: 'Get_FC_Mapping_GT');
1167: raise;
1168:

Line 1245: FII_UTIL.Write_Output (l_cat_value || ' , ' ||

1241:
1242: --bug 3263273: should print out flex value
1243: l_cat_value := Get_Flex_Value (bad_asg_rec.FIN_CATEGORY_ID);
1244:
1245: FII_UTIL.Write_Output (l_cat_value || ' , ' ||
1246: bad_asg_rec.FIN_CAT_TYPE_CODE);
1247: End Loop;
1248:
1249: END LOOP;

Line 1276: FII_UTIL.Write_Output (l_cat_value || ' , ' ||

1272: end if;
1273:
1274: l_cat_value := Get_Flex_Value (bad_asg_rec.FIN_CATEGORY_ID);
1275:
1276: FII_UTIL.Write_Output (l_cat_value || ' , ' ||
1277: bad_asg_rec.FIN_CAT_TYPE_CODE);
1278: End Loop;
1279:
1280: END LOOP;

Line 1289: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.check_rules_denorm: '||

1285:
1286: Exception
1287:
1288: When FINDIM_Invalid_FC_ASG_err then
1289: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.check_rules_denorm: '||
1290: 'invalid FC Type assignment detected!');
1291: raise;
1292:
1293: When others then

Line 1294: FII_UTIL.Write_Log(

1290: 'invalid FC Type assignment detected!');
1291: raise;
1292:
1293: When others then
1294: FII_UTIL.Write_Log(
1295: 'Unexpected error check_rules_denorm');
1296: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
1297: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1298: RAISE;

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

1292:
1293: When others then
1294: FII_UTIL.Write_Log(
1295: 'Unexpected error check_rules_denorm');
1296: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
1297: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1298: RAISE;
1299:
1300: END Check_rules_denorm;

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

1293: When others then
1294: FII_UTIL.Write_Log(
1295: 'Unexpected error check_rules_denorm');
1296: FII_UTIL.WRITE_LOG ( 'Error Message: '|| substr(sqlerrm,1,180));
1297: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1298: RAISE;
1299:
1300: END Check_rules_denorm;
1301:

Line 1320: FII_UTIL.truncate_table ('FII_FC_TYPE_ASSGNS_GT', 'FII', g_retcode);

1316:
1317: --clean up the denorm TMP table
1318: g_phase := 'Truncate FII_FC_TYPE_ASSGNS_GT';
1319:
1320: FII_UTIL.truncate_table ('FII_FC_TYPE_ASSGNS_GT', 'FII', g_retcode);
1321:
1322: --First, insert records into the denorm TMP table
1323: --Note that we need to use DISTINCT here since both parent-child
1324: --can be assigned to same type in FII_FC_TYPE_NORM_ASSIGN

Line 1342: FII_UTIL.Write_Log('Inserted ' || l_sql_rowcount || ' rows into FII_FC_TYPE_ASSGNS_GT');

1338:
1339: l_sql_rowcount := SQL%ROWCOUNT;
1340:
1341: IF (FIIDIM_Debug) THEN
1342: FII_UTIL.Write_Log('Inserted ' || l_sql_rowcount || ' rows into FII_FC_TYPE_ASSGNS_GT');
1343: END IF;
1344:
1345: --Check if there is any Financial Category type assignment in the system
1346: g_phase := 'Check if there is any Financial Category type assignment';

Line 1349: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);

1345: --Check if there is any Financial Category type assignment in the system
1346: g_phase := 'Check if there is any Financial Category type assignment';
1347:
1348: if l_sql_rowcount = 0 then
1349: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1350: raise FINDIM_NO_FC_TYPE_ASGN;
1351: end if;
1352:
1353: --Insert a new internal type (EXP) that contains a distinct list

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

1378: from FII_FC_TYPE_ASSGNS_GT fct
1379: where fct.fin_cat_type_code IN ('OE', 'TE', 'PE', 'CGS');
1380:
1381: IF (FIIDIM_Debug) THEN
1382: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_TYPE_ASSGNS_GT');
1383: END IF;
1384:
1385: --Call FND_STATS to collect statistics after populating the table
1386: g_phase := 'gather_table_stats for FII_FC_TYPE_ASSGNS_GT';

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

1422: tab3.fin_category_id
1423: having count(*) = 1);
1424:
1425: IF (FIIDIM_Debug) THEN
1426: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_FC_TYPE_ASSGNS_GT');
1427: END IF;
1428:
1429: --Validate the denorm table by 2 business rules
1430: g_phase := 'Validate the denorm table by 2 business rules';

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

1437: IF p_initial_load = 'Y' THEN --initial load
1438:
1439: g_phase := 'truncate FII_FIN_CAT_TYPE_ASSGNS';
1440:
1441: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1442:
1443: g_phase := 'INSERT INTO FII_FIN_CAT_TYPE_ASSGNS';
1444:
1445: INSERT /*+ APPEND */ INTO FII_FIN_CAT_TYPE_ASSGNS

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

1461: FII_LOGIN_ID
1462: FROM FII_FC_TYPE_ASSGNS_GT;
1463:
1464: IF (FIIDIM_Debug) THEN
1465: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_TYPE_ASSGNS');
1466: END IF;
1467:
1468: ELSE --incremental update
1469:

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

1477: SELECT fin_cat_type_code, fin_category_id, top_node_flag
1478: FROM FII_FC_TYPE_ASSGNS_GT);
1479:
1480: IF (FIIDIM_Debug) THEN
1481: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_CAT_TYPE_ASSGNS');
1482: END IF;
1483:
1484: g_phase := 'Insert into FII_FIN_CAT_TYPE_ASSGNS';
1485:

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

1514: FII_LOGIN_ID
1515: FROM FII_FIN_CAT_TYPE_ASSGNS);
1516:
1517: IF (FIIDIM_Debug) THEN
1518: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_TYPE_ASSGNS');
1519: END IF;
1520:
1521: END IF;
1522: -----------------------------------------

Line 1548: FII_UTIL.Write_Log('Populate_FCT_denorm : No Data Found');

1544:
1545: EXCEPTION
1546:
1547: WHEN NO_DATA_FOUND THEN
1548: FII_UTIL.Write_Log('Populate_FCT_denorm : No Data Found');
1549: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1550: 'Populate_FCT_denorm');
1551: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1552: raise;

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

1547: WHEN NO_DATA_FOUND THEN
1548: FII_UTIL.Write_Log('Populate_FCT_denorm : No Data Found');
1549: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1550: 'Populate_FCT_denorm');
1551: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1552: raise;
1553:
1554: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
1555: FII_MESSAGE.write_log( msg_name => 'FII_NO_FC_TYPE_ASGN',

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

1557: FII_MESSAGE.write_output(msg_name => 'FII_NO_FC_TYPE_ASGN',
1558: token_num => 0);
1559: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1560: 'Populate_FCT_denorm');
1561: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1562: raise;
1563:
1564: WHEN OTHERS THEN
1565: FII_UTIL.Write_Log('Populate_FCT_denorm: '|| substr(sqlerrm,1,180));

Line 1565: FII_UTIL.Write_Log('Populate_FCT_denorm: '|| substr(sqlerrm,1,180));

1561: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1562: raise;
1563:
1564: WHEN OTHERS THEN
1565: FII_UTIL.Write_Log('Populate_FCT_denorm: '|| substr(sqlerrm,1,180));
1566: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1567: 'Populate_FCT_denorm');
1568: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1569: raise;

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

1564: WHEN OTHERS THEN
1565: FII_UTIL.Write_Log('Populate_FCT_denorm: '|| substr(sqlerrm,1,180));
1566: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1567: 'Populate_FCT_denorm');
1568: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1569: raise;
1570:
1571: END Populate_FCT_denorm;
1572:

Line 1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);

1582: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1583: 'Handle_Unenabled_DIM');
1584: END IF;
1585:
1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);

Line 1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);

1583: 'Handle_Unenabled_DIM');
1584: END IF;
1585:
1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);

Line 1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);

1584: END IF;
1585:
1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);
1592:

Line 1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);

1585:
1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);
1592:
1593: IF (FIIDIM_Debug) THEN

Line 1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);

1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);
1592:
1593: IF (FIIDIM_Debug) THEN
1594: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

Line 1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);

1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);
1592:
1593: IF (FIIDIM_Debug) THEN
1594: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1595: 'Handle_Unenabled_DIM');

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

1597:
1598: EXCEPTION
1599:
1600: WHEN OTHERS THEN
1601: FII_UTIL.Write_Log ('Handle_Unenabled_DIM: '|| substr(sqlerrm,1,180));
1602: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1603: 'Handle_Unenabled_DIM');
1604: raise;
1605:

Line 1646: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);

1642:
1643: --Copy TMP hierarchy table to the final dimension table
1644: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1645:
1646: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1647:
1648: INSERT /*+ APPEND */ INTO FII_FULL_FIN_ITEM_HIERS (
1649: parent_level,
1650: parent_fin_cat_id,

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

1679: FII_LOGIN_ID
1680: FROM FII_FIN_ITEM_HIER_GT;
1681:
1682: IF (FIIDIM_Debug) THEN
1683: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');
1684: END IF;
1685:
1686: commit;
1687:

Line 1707: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);

1703:
1704: --Copy TMP hierarchy table to the final dimension table for Expense Analysis
1705: g_phase := 'Copy TMP hierarchy table to the final dimension table for Expense Analysis';
1706:
1707: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1708:
1709: INSERT /*+ APPEND */ INTO FII_FIN_ITEM_LEAF_HIERS (
1710: parent_level,
1711: parent_fin_cat_id,

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

1754: 'N'
1755: FROM FII_FIN_ITEM_HIER_GT;
1756:
1757: IF (FIIDIM_Debug) THEN
1758: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
1759: END IF;
1760:
1761: commit;
1762:

Line 1767: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);

1763: -- Since leaf nodes are always included we copy FII_FIN_ITEM_HIER_GT to FII_FIN_ITEM_HIERARCHIES
1764: --Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final dimension table for DBI6.0
1765: g_phase := 'Copy FII_FIN_ITEM_HIER_GT hierarchy table to the final full dimension table for DBI 6.0';
1766:
1767: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1768:
1769: INSERT /*+ APPEND */ INTO FII_FIN_ITEM_HIERARCHIES (
1770: parent_level,
1771: parent_fin_cat_id,

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

1800: FII_LOGIN_ID
1801: FROM FII_FIN_ITEM_HIER_GT;
1802:
1803: IF (FIIDIM_Debug) THEN
1804: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_HIERARCHIES');
1805: END IF;
1806:
1807: -- We have added an update statement on FII_FIN_ITEM_LEAF_HIERS. Hence, moved gathering statistics
1808: -- for FII_FIN_ITEM_LEAF_HIERS table and its mlog at the end of procedure.

Line 1829: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);

1825:
1826: --Copy FII_FIN_CAT_MAPPINGS_GT to FII_FIN_CAT_LEAF_MAPS
1827: g_phase := 'Copy TMP FC Mapping table to the FC Mapping Table';
1828:
1829: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);
1830:
1831: INSERT /*+ APPEND */ INTO FII_FIN_CAT_LEAF_MAPS (
1832: parent_fin_cat_id,
1833: child_fin_cat_id,

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

1846: FII_LOGIN_ID
1847: FROM FII_FIN_CAT_MAPPINGS_GT;
1848:
1849: IF (FIIDIM_Debug) THEN
1850: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_LEAF_MAPS');
1851: END IF;
1852:
1853: --Copy FII_FIN_CAT_MAPPINGS_GT to FII_FIN_CAT_MAPPINGS
1854: g_phase := 'Copy TMP FC Mapping table to the FC Mapping Table';

Line 1856: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);

1852:
1853: --Copy FII_FIN_CAT_MAPPINGS_GT to FII_FIN_CAT_MAPPINGS
1854: g_phase := 'Copy TMP FC Mapping table to the FC Mapping Table';
1855:
1856: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1857:
1858: INSERT /*+ APPEND */ INTO FII_FIN_CAT_MAPPINGS (
1859: parent_fin_cat_id,
1860: child_fin_cat_id,

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

1873: FII_LOGIN_ID
1874: FROM FII_FIN_CAT_MAPPINGS_GT;
1875:
1876: IF (FIIDIM_Debug) THEN
1877: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_MAPPINGS');
1878: END IF;
1879:
1880: --Call FND_STATS to collect statistics after re-populating the table.
1881:

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

1982: -- Exception handling
1983: EXCEPTION
1984:
1985: WHEN FINDIM_fatal_err THEN
1986: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1987: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1988: 'User defined error');
1989: -- Rollback
1990: rollback; --FND_CONCURRENT.Af_Rollback;

Line 1987: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||

1983: EXCEPTION
1984:
1985: WHEN FINDIM_fatal_err THEN
1986: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1987: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1988: 'User defined error');
1989: -- Rollback
1990: rollback; --FND_CONCURRENT.Af_Rollback;
1991: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

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

1993: ret_val := FND_CONCURRENT.Set_Completion_Status
1994: (status => 'ERROR', message => substr(sqlerrm,1,180));
1995:
1996: WHEN FINDIM_MULT_PAR_err THEN
1997: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1998: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1999: 'Diamond Shape Detected');
2000: -- Rollback
2001: rollback; --FND_CONCURRENT.Af_Rollback;

Line 1998: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||

1994: (status => 'ERROR', message => substr(sqlerrm,1,180));
1995:
1996: WHEN FINDIM_MULT_PAR_err THEN
1997: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1998: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1999: 'Diamond Shape Detected');
2000: -- Rollback
2001: rollback; --FND_CONCURRENT.Af_Rollback;
2002: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

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

2004: ret_val := FND_CONCURRENT.Set_Completion_Status
2005: (status => 'ERROR', message => substr(sqlerrm,1,180));
2006:
2007: WHEN FINDIM_Invalid_FC_ASG_err then
2008: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2009: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
2010: 'Invalid FC Type Assignment Detected');
2011: -- Rollback
2012: rollback; --FND_CONCURRENT.Af_Rollback;

Line 2009: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||

2005: (status => 'ERROR', message => substr(sqlerrm,1,180));
2006:
2007: WHEN FINDIM_Invalid_FC_ASG_err then
2008: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2009: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
2010: 'Invalid FC Type Assignment Detected');
2011: -- Rollback
2012: rollback; --FND_CONCURRENT.Af_Rollback;
2013: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

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

2015: ret_val := FND_CONCURRENT.Set_Completion_Status
2016: (status => 'ERROR', message => substr(sqlerrm,1,180));
2017:
2018: WHEN FINDIM_NOT_ENABLED THEN
2019: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2020: FII_UTIL.Write_Log ('>>> Financial Categories Dimension Not Enabled...');
2021:
2022: Handle_Unenabled_DIM;
2023:

Line 2020: FII_UTIL.Write_Log ('>>> Financial Categories Dimension Not Enabled...');

2016: (status => 'ERROR', message => substr(sqlerrm,1,180));
2017:
2018: WHEN FINDIM_NOT_ENABLED THEN
2019: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2020: FII_UTIL.Write_Log ('>>> Financial Categories Dimension Not Enabled...');
2021:
2022: Handle_Unenabled_DIM;
2023:
2024: retcode := sqlcode;

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

2025: -- ret_val := FND_CONCURRENT.Set_Completion_Status
2026: -- (status => 'NORMAL', message => NULL);
2027:
2028: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2029: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2030: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2031: -- Rollback
2032: rollback; --FND_CONCURRENT.Af_Rollback;
2033: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

Line 2030: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');

2026: -- (status => 'NORMAL', message => NULL);
2027:
2028: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2029: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2030: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2031: -- Rollback
2032: rollback; --FND_CONCURRENT.Af_Rollback;
2033: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2034: retcode := sqlcode;

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

2036: (status => 'ERROR',
2037: message => 'No Financial Category Type assignment is done.');
2038:
2039: WHEN OTHERS THEN
2040: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2041: FII_UTIL.Write_Log(
2042: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
2043: -- Rollback
2044: rollback; --FND_CONCURRENT.Af_Rollback;

Line 2041: FII_UTIL.Write_Log(

2037: message => 'No Financial Category Type assignment is done.');
2038:
2039: WHEN OTHERS THEN
2040: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2041: FII_UTIL.Write_Log(
2042: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
2043: -- Rollback
2044: rollback; --FND_CONCURRENT.Af_Rollback;
2045: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

Line 2091: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);

2087: --Copy TMP hierarchy table to the final dimension table
2088: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
2089:
2090: --FII_FULL_FIN_ITEM_HIERS does not require an incremental refresh.
2091: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
2092:
2093: INSERT /*+ APPEND */ INTO FII_FULL_FIN_ITEM_HIERS (
2094: parent_level,
2095: parent_fin_cat_id,

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

2126:
2127: commit;
2128:
2129: IF (FIIDIM_Debug) THEN
2130: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');
2131: END IF;
2132:
2133: --Call FND_STATS to collect statistics after re-populating the tables.
2134: --for the full table since it will be used later in the program

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

2186: LEVEL5_fin_cat_ID
2187: FROM FII_FIN_ITEM_HIER_GT);
2188:
2189: IF (FIIDIM_Debug) THEN
2190: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_ITEM_LEAF_HIERS');
2191: END IF;
2192:
2193: g_phase := 'Insert into FII_FIN_ITEM_LEAF_HIERS';
2194:

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

2263: 'N'
2264: FROM FII_FIN_ITEM_LEAF_HIERS);
2265:
2266: IF (FIIDIM_Debug) THEN
2267: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
2268: END IF;
2269:
2270: --Copy FII_FIN_ITEM_HIER_GT to the final (pruned) dimension table for DBI6.0
2271:

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

2292: parent_flex_value_set_id, child_flex_value_set_id
2293: FROM FII_FIN_ITEM_HIER_GT);
2294:
2295: IF (FIIDIM_Debug) THEN
2296: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_ITEM_HIERARCHIES');
2297: END IF;
2298:
2299: g_phase := 'Insert into FII_FIN_ITEM_HIERARCHIES';
2300:

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

2348: FII_LOGIN_ID
2349: FROM FII_FIN_ITEM_HIERARCHIES);
2350:
2351: IF (FIIDIM_Debug) THEN
2352: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_HIERARCHIES');
2353: END IF;
2354:
2355: -- We have added an update statement on FII_FIN_ITEM_LEAF_HIERS. Hence, moved gathering statistics
2356: -- for FII_FIN_ITEM_LEAF_HIERS table at the end of procedure.

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

2379: SELECT parent_fin_cat_id, child_fin_cat_id
2380: FROM FII_FIN_CAT_MAPPINGS_GT);
2381:
2382: IF (FIIDIM_Debug) THEN
2383: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_CAT_LEAF_MAPS');
2384: END IF;
2385:
2386: g_phase := 'Insert into FII_FIN_CAT_LEAF_MAPS';
2387:

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

2411: FII_LOGIN_ID
2412: FROM FII_FIN_CAT_LEAF_MAPS);
2413:
2414: IF (FIIDIM_Debug) THEN
2415: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_LEAF_MAPS');
2416: END IF;
2417:
2418: --Copy FII_FIN_CAT_MAPPINGS_GT to FII_FIN_CAT_MAPPINGS
2419:

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

2428: SELECT parent_fin_cat_id, child_fin_cat_id
2429: FROM FII_FIN_CAT_MAPPINGS_GT);
2430:
2431: IF (FIIDIM_Debug) THEN
2432: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FIN_CAT_MAPPINGS');
2433: END IF;
2434:
2435: g_phase := 'Insert into FII_FIN_CAT_MAPPINGS';
2436:

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

2460: FII_LOGIN_ID
2461: FROM FII_FIN_CAT_MAPPINGS);
2462:
2463: IF (FIIDIM_Debug) THEN
2464: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_MAPPINGS');
2465: END IF;
2466:
2467: --Call FND_STATS to collect statistics after re-populating the table.
2468:

Line 2526: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');

2522: ))
2523: AND is_to_be_rolled_up_flag <> 'Y' ;
2524:
2525: IF (FIIDIM_Debug) THEN
2526: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
2527: END IF;
2528:
2529: g_phase := 'Update top_node_fin_cat_type flag for OE';
2530:

Line 2540: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');

2536: AND next_level_fin_cat_id <> parent_fin_cat_id
2537: AND (top_node_fin_cat_type <> 'OE' OR top_node_fin_cat_type is null);
2538:
2539: IF (FIIDIM_Debug) THEN
2540: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
2541: END IF;
2542:
2543: g_phase := 'Update top_node_fin_cat_type flag for CGS';
2544:

Line 2555: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');

2551: AND next_level_fin_cat_id <> parent_fin_cat_id
2552: AND (top_node_fin_cat_type <> 'CGS' OR top_node_fin_cat_type is null);
2553:
2554: IF (FIIDIM_Debug) THEN
2555: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
2556: END IF;
2557:
2558: g_phase := 'Update top_node_fin_cat_type flag for other category types';
2559:

Line 2587: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');

2583: )
2584: AND next_level_fin_cat_id <> parent_fin_cat_id;
2585:
2586: IF (FIIDIM_Debug) THEN
2587: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
2588: END IF;
2589:
2590: -- Call FND_STATS to collect statistics of the table.
2591: g_phase := 'gather_table_stats FII_FIN_ITEM_LEAF_HIERS';

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

2613:
2614: -- Exception handling
2615: EXCEPTION
2616: WHEN FINDIM_fatal_err THEN
2617: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2618: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update'||
2619: 'User defined error');
2620: -- Rollback
2621: rollback; --FND_CONCURRENT.Af_Rollback;

Line 2618: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update'||

2614: -- Exception handling
2615: EXCEPTION
2616: WHEN FINDIM_fatal_err THEN
2617: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2618: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update'||
2619: 'User defined error');
2620: -- Rollback
2621: rollback; --FND_CONCURRENT.Af_Rollback;
2622: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

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

2624: ret_val := FND_CONCURRENT.Set_Completion_Status
2625: (status => 'ERROR', message => substr(sqlerrm,1,180));
2626:
2627: WHEN FINDIM_MULT_PAR_err THEN
2628: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2629: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2630: 'Diamond Shape Detected');
2631: -- Rollback
2632: rollback; --FND_CONCURRENT.Af_Rollback;

Line 2629: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||

2625: (status => 'ERROR', message => substr(sqlerrm,1,180));
2626:
2627: WHEN FINDIM_MULT_PAR_err THEN
2628: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2629: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2630: 'Diamond Shape Detected');
2631: -- Rollback
2632: rollback; --FND_CONCURRENT.Af_Rollback;
2633: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

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

2635: ret_val := FND_CONCURRENT.Set_Completion_Status
2636: (status => 'ERROR', message => substr(sqlerrm,1,180));
2637:
2638: WHEN FINDIM_Invalid_FC_ASG_err then
2639: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2640: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2641: 'Invalid FC Type Assignment Detected');
2642: -- Rollback
2643: rollback; --FND_CONCURRENT.Af_Rollback;

Line 2640: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||

2636: (status => 'ERROR', message => substr(sqlerrm,1,180));
2637:
2638: WHEN FINDIM_Invalid_FC_ASG_err then
2639: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2640: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2641: 'Invalid FC Type Assignment Detected');
2642: -- Rollback
2643: rollback; --FND_CONCURRENT.Af_Rollback;
2644: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

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

2646: ret_val := FND_CONCURRENT.Set_Completion_Status
2647: (status => 'ERROR', message => substr(sqlerrm,1,180));
2648:
2649: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2650: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2651: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2652: -- Rollback
2653: rollback; --FND_CONCURRENT.Af_Rollback;
2654: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

Line 2651: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');

2647: (status => 'ERROR', message => substr(sqlerrm,1,180));
2648:
2649: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2650: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2651: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2652: -- Rollback
2653: rollback; --FND_CONCURRENT.Af_Rollback;
2654: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2655: retcode := sqlcode;

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

2657: (status => 'ERROR',
2658: message => 'No Financial Category Type assignment is done.');
2659:
2660: WHEN FINDIM_NOT_ENABLED THEN
2661: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2662: FII_UTIL.Write_Log ('>>> Financial Categories Dimension Not Enabled...');
2663:
2664: Handle_Unenabled_DIM;
2665:

Line 2662: FII_UTIL.Write_Log ('>>> Financial Categories Dimension Not Enabled...');

2658: message => 'No Financial Category Type assignment is done.');
2659:
2660: WHEN FINDIM_NOT_ENABLED THEN
2661: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2662: FII_UTIL.Write_Log ('>>> Financial Categories Dimension Not Enabled...');
2663:
2664: Handle_Unenabled_DIM;
2665:
2666: retcode := sqlcode;

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

2667: -- ret_val := FND_CONCURRENT.Set_Completion_Status
2668: -- (status => 'NORMAL', message => NULL);
2669:
2670: WHEN OTHERS THEN
2671: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2672: FII_UTIL.Write_Log(
2673: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
2674: -- Rollback
2675: rollback; --FND_CONCURRENT.Af_Rollback;

Line 2672: FII_UTIL.Write_Log(

2668: -- (status => 'NORMAL', message => NULL);
2669:
2670: WHEN OTHERS THEN
2671: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2672: FII_UTIL.Write_Log(
2673: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
2674: -- Rollback
2675: rollback; --FND_CONCURRENT.Af_Rollback;
2676: FII_MESSAGE.Func_Fail(func_name => 'II_FIN_CAT_MAINTAIN_PKG.Incre_Update');