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

Line 80: FII_UTIL.Write_Log (

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

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

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

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

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

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 142: l_dir := FII_UTIL.get_utl_file_dir;

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

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

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

Line 150: FII_UTIL.initialize('FII_COM_MAINTAIN_PKG.log',

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 208: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Company dimension');

204: FII_UTIL.Write_Log ('Initialize: Set Trace On');
205: END IF;
206:
207: IF (FIIDIM_Debug) THEN
208: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Company dimension');
209: End If;
210:
211: ------------------------------------------------
212:

Line 269: FII_UTIL.Write_Log ('More than one master value set found for COMPANY Dimension');

265: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
266: token_num => 0);
267: RAISE CODIM_fatal_err;
268: When TOO_MANY_ROWS Then
269: FII_UTIL.Write_Log ('More than one master value set found for COMPANY Dimension');
270: RAISE CODIM_fatal_err;
271: When CODIM_NOT_ENABLED then
272: raise;
273: When CODIM_fatal_err then

Line 276: FII_UTIL.Write_Log ('Unexpected error when getting master value set for COMPANY Dimension');

272: raise;
273: When CODIM_fatal_err then
274: raise;
275: When OTHERS Then
276: FII_UTIL.Write_Log ('Unexpected error when getting master value set for COMPANY Dimension');
277: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
278: RAISE CODIM_fatal_err;
279: End;
280:

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

273: When CODIM_fatal_err then
274: raise;
275: When OTHERS Then
276: FII_UTIL.Write_Log ('Unexpected error when getting master value set for COMPANY Dimension');
277: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
278: RAISE CODIM_fatal_err;
279: End;
280:
281: IF (FIIDIM_Debug) THEN

Line 282: FII_UTIL.Write_Log ('COMPANY Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);

278: RAISE CODIM_fatal_err;
279: End;
280:
281: IF (FIIDIM_Debug) THEN
282: FII_UTIL.Write_Log ('COMPANY Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
283: FII_UTIL.Write_Log ('COMPANY Master Value Set: '||
284: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
285: FII_UTIL.Write_Log (' and COMPANY Top Node: '|| G_TOP_NODE_VALUE);
286: END IF;

Line 283: FII_UTIL.Write_Log ('COMPANY Master Value Set: '||

279: End;
280:
281: IF (FIIDIM_Debug) THEN
282: FII_UTIL.Write_Log ('COMPANY Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
283: FII_UTIL.Write_Log ('COMPANY Master Value Set: '||
284: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
285: FII_UTIL.Write_Log (' and COMPANY Top Node: '|| G_TOP_NODE_VALUE);
286: END IF;
287:

Line 285: FII_UTIL.Write_Log (' and COMPANY Top Node: '|| G_TOP_NODE_VALUE);

281: IF (FIIDIM_Debug) THEN
282: FII_UTIL.Write_Log ('COMPANY Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
283: FII_UTIL.Write_Log ('COMPANY Master Value Set: '||
284: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
285: FII_UTIL.Write_Log (' and COMPANY Top Node: '|| G_TOP_NODE_VALUE);
286: END IF;
287:
288:
289: -- Check if the master value set is a table validated set.

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

308:
309: Exception
310:
311: When CODIM_NOT_ENABLED then
312: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
313: --Let the main program handle this
314: raise;
315:
316: When CODIM_fatal_err then

Line 317: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Initialize : '|| 'User defined error');

313: --Let the main program handle this
314: raise;
315:
316: When CODIM_fatal_err then
317: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Initialize : '|| 'User defined error');
318: FND_CONCURRENT.Af_Rollback;
319: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Initialize');
320: raise;
321:

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

319: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Initialize');
320: raise;
321:
322: When others then
323: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
324: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
325: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
326: RAISE;
327:

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

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

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

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

Line 463: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||

459:
460: Exception
461:
462: When CODIM_fatal_err then
463: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
464:
465:
466: 'User defined error');
467: FND_CONCURRENT.Af_Rollback;

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

468: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
469: raise;
470:
471: When others then
472: FII_UTIL.Write_Log ('Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
473: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
474: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
475: RAISE;
476:

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

469: raise;
470:
471: When others then
472: FII_UTIL.Write_Log ('Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
473: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
474: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
475: RAISE;
476:
477: END Get_NORM_HIERARCHY_TMP;

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

470:
471: When others then
472: FII_UTIL.Write_Log ('Unexpected error when calling Get_NORM_HIERARCHY_TMP.');
473: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
474: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
475: RAISE;
476:
477: END Get_NORM_HIERARCHY_TMP;
478:

Line 550: FII_UTIL.Write_Output (

546: l_vset_name := Get_Value_Set_Name (dup_asg_par_rec.child_flex_value_set_id);
547: l_parent_flex_value:= Get_Flex_Value (dup_asg_par_rec.parent_company_id);
548: l_parent_vset_name := Get_Value_Set_Name (dup_asg_par_rec.parent_flex_value_set_id);
549:
550: FII_UTIL.Write_Output (
551: l_flex_value || ' '||
552: l_vset_name || ' '||
553: l_parent_flex_value || ' '||
554: l_parent_vset_name);

Line 571: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Detect_Diamond_Shape: '||

567:
568: Exception
569:
570: When CODIM_MULT_PAR_err then
571: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Detect_Diamond_Shape: '||
572: 'diamond shape detected!');
573: RAISE;
574:
575: When others then

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

572: 'diamond shape detected!');
573: RAISE;
574:
575: When others then
576: FII_UTIL.Write_Log ('Unexpected error when calling Detect_Diamond_Shape.');
577: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
578: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
579: RAISE;
580:

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

573: RAISE;
574:
575: When others then
576: FII_UTIL.Write_Log ('Unexpected error when calling Detect_Diamond_Shape.');
577: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
578: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
579: RAISE;
580:
581: END Detect_Diamond_Shape;

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

574:
575: When others then
576: FII_UTIL.Write_Log ('Unexpected error when calling Detect_Diamond_Shape.');
577: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
578: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
579: RAISE;
580:
581: END Detect_Diamond_Shape;
582:

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

681: FND_CONCURRENT.Af_Commit; --commit
682:
683: EXCEPTION
684: WHEN NO_DATA_FOUND Then
685: FII_UTIL.Write_Log ('Insert Immediate child: No Data Found');
686: FII_MESSAGE.Func_Fail
687: (func_name => 'FII_COM_MAINTAIN_PKG.Insert_Imm_Child_Nodes');
688: RAISE;
689:

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

687: (func_name => 'FII_COM_MAINTAIN_PKG.Insert_Imm_Child_Nodes');
688: RAISE;
689:
690: WHEN OTHERS Then
691: FII_UTIL.Write_Log (substr(SQLERRM,1,180));
692: FII_MESSAGE.Func_Fail
693: (func_name => 'FII_COM_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
694: RAISE;
695:

Line 719: FII_UTIL.truncate_table ('FII_COMPANY_HIER_GT', 'FII', g_retcode);

715: FII_MESSAGE.Func_Ent(func_name => 'FII_COM_MAINTAIN_PKG.'||
716: 'Flatten_CO_Dim_Hier');
717: END IF;
718: g_phase := 'Truncate table FII_COMPANY_HIER_GT';
719: FII_UTIL.truncate_table ('FII_COMPANY_HIER_GT', 'FII', g_retcode);
720:
721: -----------------------------------------------------------------
722:
723: CODIM_parent_node := p_root_node;

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

763: 'N'
764: from (select distinct child_company_id,child_level,child_flex_value_set_id from fii_company_hier_gt);
765:
766: IF (FIIDIM_Debug) THEN
767: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_hier_gt');
768: END IF;
769:
770: INSERT INTO fii_COMPANY_hier_gt
771: (parent_level,

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

790: 'N',
791: 'N');
792:
793: IF (FIIDIM_Debug) THEN
794: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_hier_gt');
795: END IF;
796:
797: --Insert the UNASSIGNED to the hierarchy table.
798: --Use G_TOP_NODE_ID as the parent

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

822: 'N',
823: 'N');
824:
825: IF (FIIDIM_Debug) THEN
826: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_hier_gt');
827: END IF;
828:
829:
830: -- Another one is (UNASSIGNED, UNASSIGNED, UNASSIGNED)

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

851: 'N',
852: 'N');
853:
854: IF (FIIDIM_Debug) THEN
855: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_hier_gt');
856: END IF;
857:
858: -- Insert a dummy super top node (-999) to the hierarchy table
859: -- (the dummy value set id is -998)

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

884: FROM fii_COMPANY_hier_gt
885: WHERE child_company_id = parent_company_id;
886:
887: IF (FIIDIM_Debug) THEN
888: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_hier_gt');
889: END IF;
890:
891:
892: --Call FND_STATS to collect statistics after populating the table

Line 924: FII_UTIL.Write_Log ('Flatten_COM_Dim_Hier: No Data Found');

920:
921: EXCEPTION
922:
923: WHEN NO_DATA_FOUND THEN
924: FII_UTIL.Write_Log ('Flatten_COM_Dim_Hier: No Data Found');
925: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.'||
926: 'Flatten_CO_Dim_Hier');
927: raise;
928:

Line 930: FII_UTIL.Write_Log ('Flatten_CO_Dim_Hier: Diamond Shape Detected');

926: 'Flatten_CO_Dim_Hier');
927: raise;
928:
929: WhEN CODIM_MULT_PAR_err THEN
930: FII_UTIL.Write_Log ('Flatten_CO_Dim_Hier: Diamond Shape Detected');
931: FII_MESSAGE.Func_Fail (func_name =>
932: 'FII_DIMENSION_MAINTAIN_PKG.Flatten_CO_Dim_Hier');
933: raise;
934:

Line 936: FII_UTIL.Write_Log ('Flatten_CO_Dim_Hier: '|| substr(sqlerrm,1,180));

932: 'FII_DIMENSION_MAINTAIN_PKG.Flatten_CO_Dim_Hier');
933: raise;
934:
935: WHEN OTHERS THEN
936: FII_UTIL.Write_Log ('Flatten_CO_Dim_Hier: '|| substr(sqlerrm,1,180));
937: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.'||
938: 'Flatten_CO_Dim_Hier');
939: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
940: raise;

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

935: WHEN OTHERS THEN
936: FII_UTIL.Write_Log ('Flatten_CO_Dim_Hier: '|| substr(sqlerrm,1,180));
937: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.'||
938: 'Flatten_CO_Dim_Hier');
939: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
940: raise;
941:
942: END Flatten_CO_Dim_Hier;
943:

Line 1029: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows form FII_COMPANY_HIER_GT');

1025: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID
1026: And child_flex_value_set_id <> G_FII_INT_VALUE_SET_ID;
1027:
1028: IF (FIIDIM_Debug) THEN
1029: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows form FII_COMPANY_HIER_GT');
1030: END IF;
1031:
1032: -- Calling procedure to update data in the new columns added for SBA content
1033: Get_level_populated;

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

1050: group by tab3.next_level_company_id
1051: having count(*) = 1);
1052:
1053: IF (FIIDIM_Debug) THEN
1054: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COMPANY_HIER_GT');
1055: END IF;
1056:
1057: --Update the column is_leaf_flag
1058: --We look at all records (A,A,A) in which A is a leaf value

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

1061: Where parent_company_id = child_company_id
1062: and next_level_is_leaf_flag = 'Y';
1063:
1064: IF (FIIDIM_Debug) THEN
1065: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COMPANY_HIER_GT');
1066: END IF;
1067:
1068: IF (FIIDIM_Debug) THEN
1069: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_MAINTAIN_PKG.'||

Line 1075: FII_UTIL.Write_Log ('Get_Pruned_CO_GT -> phase: '|| g_phase);

1071: END IF;
1072: EXCEPTION
1073:
1074: WHEN OTHERS THEN
1075: FII_UTIL.Write_Log ('Get_Pruned_CO_GT -> phase: '|| g_phase);
1076: FII_UTIL.Write_Log ('Get_Pruned_CO_GT: '|| substr(sqlerrm,1,180));
1077: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.'||
1078: 'Get_Pruned_CO_GT');
1079: raise;

Line 1076: FII_UTIL.Write_Log ('Get_Pruned_CO_GT: '|| substr(sqlerrm,1,180));

1072: EXCEPTION
1073:
1074: WHEN OTHERS THEN
1075: FII_UTIL.Write_Log ('Get_Pruned_CO_GT -> phase: '|| g_phase);
1076: FII_UTIL.Write_Log ('Get_Pruned_CO_GT: '|| substr(sqlerrm,1,180));
1077: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.'||
1078: 'Get_Pruned_CO_GT');
1079: raise;
1080:

Line 1113: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);

1109: -- disabled now, in which case initial refresh of MV should happen
1110: -- so it is ok to truncate the tables
1111:
1112: g_phase := 'Truncate dimension hierarchy tables';
1113: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1114: FII_UTIL.truncate_table ('FII_COMPANY_HIERARCHIES', 'FII', g_retcode);
1115:
1116: INSERT INTO FII_FULL_COMPANY_HIERS
1117: (parent_level,

Line 1114: FII_UTIL.truncate_table ('FII_COMPANY_HIERARCHIES', 'FII', g_retcode);

1110: -- so it is ok to truncate the tables
1111:
1112: g_phase := 'Truncate dimension hierarchy tables';
1113: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1114: FII_UTIL.truncate_table ('FII_COMPANY_HIERARCHIES', 'FII', g_retcode);
1115:
1116: INSERT INTO FII_FULL_COMPANY_HIERS
1117: (parent_level,
1118: parent_company_id,

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

1199: END IF;
1200: EXCEPTION
1201:
1202: WHEN OTHERS THEN
1203: FII_UTIL.Write_Log ('Handle_Unenabled_DIM: '|| substr(sqlerrm,1,180));
1204: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.'||
1205: 'Handle_Unenabled_DIM');
1206: raise;
1207:

Line 1246: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);

1242:
1243: --Copy TMP hierarchy table to the final dimension table
1244: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1245:
1246: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1247:
1248: INSERT /*+ APPEND */ INTO FII_FULL_COMPANY_HIERS (
1249: parent_level,
1250: parent_company_id,

Line 1283: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_COMPANY_HIERS');

1279: FII_LOGIN_ID
1280: FROM FII_COMPANY_HIER_GT;
1281:
1282: IF (FIIDIM_Debug) THEN
1283: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_COMPANY_HIERS');
1284: END IF;
1285:
1286: --Call FND_STATS to collect statistics after re-populating the tables.
1287: --for the full dimension table since it will be used later

Line 1302: FII_UTIL.truncate_table ('FII_COMPANY_HIERARCHIES', 'FII', g_retcode);

1298:
1299: --Copy FII_company_HIER_GT to the final (pruned) dimension table
1300: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1301:
1302: FII_UTIL.truncate_table ('FII_COMPANY_HIERARCHIES', 'FII', g_retcode);
1303:
1304: INSERT /*+ APPEND */ INTO FII_COMPANY_HIERARCHIES (
1305: parent_level,
1306: parent_company_id,

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

1347: FII_LOGIN_ID
1348: FROM FII_COMPANY_HIER_GT;
1349:
1350: IF (FIIDIM_Debug) THEN
1351: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
1352: END IF;
1353:
1354: -- This will be in RSG data
1355: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';

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

1375: EXCEPTION
1376:
1377: WHEN CODIM_fatal_err THEN
1378:
1379: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Init_Load: '||
1380: 'User defined error');
1381:
1382: FND_CONCURRENT.Af_Rollback;
1383: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');

Line 1389: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Init_Load: '||

1385: ret_val := FND_CONCURRENT.Set_Completion_Status
1386: (status => 'ERROR', message => substr(sqlerrm,1,180));
1387:
1388: WHEN CODIM_MULT_PAR_err THEN
1389: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Init_Load: '||
1390: 'Diamond Shape Detected');
1391:
1392: FND_CONCURRENT.Af_Rollback;
1393: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');

Line 1399: FII_UTIL.Write_Log ('>>> COMPANY Dimension Not Enabled...');

1395: ret_val := FND_CONCURRENT.Set_Completion_Status
1396: (status => 'ERROR', message => substr(sqlerrm,1,180));
1397:
1398: WHEN CODIM_NOT_ENABLED THEN
1399: FII_UTIL.Write_Log ('>>> COMPANY Dimension Not Enabled...');
1400:
1401: Handle_Unenabled_DIM;
1402:
1403: retcode := sqlcode;

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

1404: --ret_val := FND_CONCURRENT.Set_Completion_Status
1405: -- (status => 'NORMAL', message => NULL);
1406:
1407: WHEN OTHERS THEN
1408: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1409: FII_UTIL.Write_Log (
1410: 'Other error in FII_COM_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1411:
1412:

Line 1409: FII_UTIL.Write_Log (

1405: -- (status => 'NORMAL', message => NULL);
1406:
1407: WHEN OTHERS THEN
1408: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1409: FII_UTIL.Write_Log (
1410: 'Other error in FII_COM_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1411:
1412:
1413: FND_CONCURRENT.Af_Rollback;

Line 1452: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);

1448:
1449: Flatten_CO_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1450:
1451: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1452: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1453:
1454: Insert into FII_FULL_COMPANY_HIERS (
1455: parent_level,
1456: parent_company_id,

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

1484: FII_LOGIN_ID
1485: FROM FII_COMPANY_HIER_GT;
1486:
1487: IF (FIIDIM_Debug) THEN
1488: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COMPANY_HIERS');
1489: END IF;
1490:
1491: --Call FND_STATS to collect statistics after re-populating the tables.
1492: --for the full dimension table since it will be used later

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

1544: FROM fii_company_hier_gt);
1545:
1546:
1547: IF (FIIDIM_Debug) THEN
1548: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_COMPANY_HIERARCHIES');
1549: END IF;
1550:
1551: Insert into FII_COMPANY_HIERARCHIES (
1552: parent_level,

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

1630: -- (ownname => g_schema_name,
1631: -- tabname => 'MLOG$_FII_COMPANY_HIERARCH');
1632:
1633: IF (FIIDIM_Debug) THEN
1634: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
1635: END IF;
1636:
1637:
1638: --=============================================================--

Line 1650: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Incre_Update'||

1646: -- Exception handling
1647:
1648: EXCEPTION
1649: WHEN CODIM_fatal_err THEN
1650: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Incre_Update'||
1651: 'User defined error');
1652:
1653: FND_CONCURRENT.Af_Rollback;
1654: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');

Line 1660: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Incre_Update: '||

1656: ret_val := FND_CONCURRENT.Set_Completion_Status
1657: (status => 'ERROR', message => substr(sqlerrm,1,180));
1658:
1659: WHEN CODIM_MULT_PAR_err THEN
1660: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Incre_Update: '||
1661: 'Diamond Shape Detected');
1662:
1663: FND_CONCURRENT.Af_Rollback;
1664: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');

Line 1670: FII_UTIL.Write_Log ('>>> COMPANY Dimension Not Enabled...');

1666: ret_val := FND_CONCURRENT.Set_Completion_Status
1667: (status => 'ERROR', message => substr(sqlerrm,1,180));
1668:
1669: WHEN CODIM_NOT_ENABLED THEN
1670: FII_UTIL.Write_Log ('>>> COMPANY Dimension Not Enabled...');
1671:
1672: Handle_Unenabled_DIM;
1673:
1674: retcode := sqlcode;

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

1675: --ret_val := FND_CONCURRENT.Set_Completion_Status
1676: -- (status => 'NORMAL', message => NULL);
1677:
1678: WHEN OTHERS THEN
1679: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1680: FII_UTIL.Write_Log (
1681: 'Other error in FII_COM_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1682:
1683:

Line 1680: FII_UTIL.Write_Log (

1676: -- (status => 'NORMAL', message => NULL);
1677:
1678: WHEN OTHERS THEN
1679: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1680: FII_UTIL.Write_Log (
1681: 'Other error in FII_COM_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1682:
1683:
1684: FND_CONCURRENT.Af_Rollback;