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_UDD2_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 111: FII_UTIL.Write_Log (

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

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

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

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

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

Line 141: l_dir := FII_UTIL.get_utl_file_dir;

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

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

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

Line 149: FII_UTIL.initialize('FII_UDD2_MAINTAIN_PKG.log',

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 207: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'User Defined dimension2');

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

Line 267: FII_UTIL.Write_Log ('More than one master value set found for USER DEFINED Dimension2');

263: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
264: token_num => 0);
265: RAISE UDIM2_fatal_err;
266: When TOO_MANY_ROWS Then
267: FII_UTIL.Write_Log ('More than one master value set found for USER DEFINED Dimension2');
268: RAISE UDIM2_fatal_err;
269: When UDIM2_NOT_ENABLED then
270: raise;
271: When UDIM2_fatal_err then

Line 274: FII_UTIL.Write_Log ('Unexpected error when getting master value set for USER DEFINED Dimension2');

270: raise;
271: When UDIM2_fatal_err then
272: raise;
273: When OTHERS Then
274: FII_UTIL.Write_Log ('Unexpected error when getting master value set for USER DEFINED Dimension2');
275: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
276: RAISE UDIM2_fatal_err;
277: End;
278:

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

271: When UDIM2_fatal_err then
272: raise;
273: When OTHERS Then
274: FII_UTIL.Write_Log ('Unexpected error when getting master value set for USER DEFINED Dimension2');
275: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
276: RAISE UDIM2_fatal_err;
277: End;
278:
279: IF (FIIDIM_Debug) THEN

Line 280: FII_UTIL.Write_Log ('USER DEFINED DIMENSION2 Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);

276: RAISE UDIM2_fatal_err;
277: End;
278:
279: IF (FIIDIM_Debug) THEN
280: FII_UTIL.Write_Log ('USER DEFINED DIMENSION2 Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
281: FII_UTIL.Write_Log ('USER DEFINED DIMENSION2 Master Value Set: '||
282: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
283: FII_UTIL.Write_Log (' and USER DEFINED Dimension2 Top Node: '|| G_TOP_NODE_VALUE);
284: END IF;

Line 281: FII_UTIL.Write_Log ('USER DEFINED DIMENSION2 Master Value Set: '||

277: End;
278:
279: IF (FIIDIM_Debug) THEN
280: FII_UTIL.Write_Log ('USER DEFINED DIMENSION2 Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
281: FII_UTIL.Write_Log ('USER DEFINED DIMENSION2 Master Value Set: '||
282: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
283: FII_UTIL.Write_Log (' and USER DEFINED Dimension2 Top Node: '|| G_TOP_NODE_VALUE);
284: END IF;
285:

Line 283: FII_UTIL.Write_Log (' and USER DEFINED Dimension2 Top Node: '|| G_TOP_NODE_VALUE);

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

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

306:
307: Exception
308:
309: When UDIM2_NOT_ENABLED then
310: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
311: --Let the main program handle this
312: raise;
313:
314: When UDIM2_fatal_err then

Line 315: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Initialize : '|| 'User defined error');

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

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

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

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

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

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

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

Line 461: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||

457:
458: Exception
459:
460: When UDIM2_fatal_err then
461: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
462:
463:
464: 'User defined error');
465: FND_CONCURRENT.Af_Rollback;

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

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

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

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

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

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

Line 548: FII_UTIL.Write_Output (

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

Line 569: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Detect_Diamond_Shape: '||

565:
566: Exception
567:
568: When UDIM2_MULT_PAR_err then
569: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Detect_Diamond_Shape: '||
570: 'diamond shape detected!');
571: RAISE;
572:
573: When others then

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

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

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

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

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

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

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

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

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

684: (func_name => 'FII_UDD2_MAINTAIN_PKG.Insert_Imm_Child_Nodes');
685: RAISE;
686:
687: WHEN OTHERS Then
688: FII_UTIL.Write_Log (substr(SQLERRM,1,180));
689: FII_MESSAGE.Func_Fail
690: (func_name => 'FII_UDD2_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
691: RAISE;
692:

Line 717: FII_UTIL.truncate_table ('FII_UDD2_HIER_GT', 'FII', g_retcode);

713: 'Flatten_UD2_Dim_Hier');
714: END IF;
715:
716: g_phase := 'Truncate table FII_UDD2_HIER_GT';
717: FII_UTIL.truncate_table ('FII_UDD2_HIER_GT', 'FII', g_retcode);
718:
719: -----------------------------------------------------------------
720:
721: UDIM2_parent_node := p_root_node;

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

762: 'N'
763: from (select distinct child_value_id,child_level,child_flex_value_set_id from fii_udd2_hier_gt);
764:
765: IF (FIIDIM_Debug) THEN
766: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_HIER_GT');
767: END IF;
768:
769: g_phase := 'Insert self record for the top node';
770: INSERT INTO fii_UDD2_hier_gt

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

790: 'N',
791: 'N');
792:
793: IF (FIIDIM_Debug) THEN
794: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_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_UDD2_HIER_GT');

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

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

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

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

883: FROM fii_UDD2_hier_gt
884: WHERE child_value_id = parent_value_id;
885:
886: IF (FIIDIM_Debug) THEN
887: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_HIER_GT');
888: END IF;
889:
890: --Call FND_STATS to collect statistics after populating the table
891: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';

Line 921: FII_UTIL.Write_Log ('Flatten_UD2_Dim_Hier: No Data Found');

917: END IF;
918: EXCEPTION
919:
920: WHEN NO_DATA_FOUND THEN
921: FII_UTIL.Write_Log ('Flatten_UD2_Dim_Hier: No Data Found');
922: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.'||
923: 'Flatten_UD2_Dim_Hier');
924: raise;
925:

Line 927: FII_UTIL.Write_Log ('Flatten_UD2_Dim_Hier: Diamond Shape Detected');

923: 'Flatten_UD2_Dim_Hier');
924: raise;
925:
926: WhEN UDIM2_MULT_PAR_err THEN
927: FII_UTIL.Write_Log ('Flatten_UD2_Dim_Hier: Diamond Shape Detected');
928: FII_MESSAGE.Func_Fail (func_name =>
929: 'FII_UDD2_MAINTAIN_PKG.Flatten_UD2_Dim_Hier');
930: raise;
931:

Line 933: FII_UTIL.Write_Log ('Flatten_UD2_Dim_Hier: '|| substr(sqlerrm,1,180));

929: 'FII_UDD2_MAINTAIN_PKG.Flatten_UD2_Dim_Hier');
930: raise;
931:
932: WHEN OTHERS THEN
933: FII_UTIL.Write_Log ('Flatten_UD2_Dim_Hier: '|| substr(sqlerrm,1,180));
934: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.'||
935: 'Flatten_UD2_Dim_Hier');
936: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
937: raise;

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

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

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

968: FROM FII_UDD2_HIERARCHIES ph
969: WHERE ph.is_leaf_flag = 'Y');
970:
971: IF (FIIDIM_Debug) THEN
972: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS_GT');
973: END IF;
974:
975:
976: --Then, insert self-mapping records for all nodes in pruned hierarchy

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

988: AND parent_value_id = child_value_id
989: AND is_leaf_flag = 'N';
990:
991: IF (FIIDIM_Debug) THEN
992: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS_GT');
993: END IF;
994:
995: --Call FND_STATS to collect statistics after populating the table
996: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS_GT';

Line 1009: FII_UTIL.Write_Log ('Get_UD2_Mapping_GT -> phase: '|| g_phase);

1005:
1006: EXCEPTION
1007:
1008: WHEN OTHERS THEN
1009: FII_UTIL.Write_Log ('Get_UD2_Mapping_GT -> phase: '|| g_phase);
1010: FII_UTIL.Write_Log ('Get_UD2_Mapping_GT: '|| substr(sqlerrm,1,180));
1011: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.'||
1012: 'Get_UD2_Mapping_GT');
1013: raise;

Line 1010: FII_UTIL.Write_Log ('Get_UD2_Mapping_GT: '|| substr(sqlerrm,1,180));

1006: EXCEPTION
1007:
1008: WHEN OTHERS THEN
1009: FII_UTIL.Write_Log ('Get_UD2_Mapping_GT -> phase: '|| g_phase);
1010: FII_UTIL.Write_Log ('Get_UD2_Mapping_GT: '|| substr(sqlerrm,1,180));
1011: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.'||
1012: 'Get_UD2_Mapping_GT');
1013: raise;
1014:

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

1035: Where child_flex_value_set_id <> G_MASTER_VALUE_SET_ID
1036: And child_flex_value_set_id <> G_FII_INT_VALUE_SET_ID;
1037:
1038: IF (FIIDIM_Debug) THEN
1039: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows form FII_UDD2_HIER_GT');
1040: END IF;
1041:
1042: --Finally, update the columns next_level_is_leaf_flag, is_leaf_flag again
1043: --for the latest FII_UDD2_HIER_GT

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

1057: group by tab3.next_level_value_id
1058: having count(*) = 1);
1059:
1060: IF (FIIDIM_Debug) THEN
1061: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD2_HIER_GT');
1062: END IF;
1063:
1064: --Update the column is_leaf_flag
1065: --We look at all records (A,A,A) in which A is a leaf value

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

1068: Where parent_value_id = child_value_id
1069: and next_level_is_leaf_flag = 'Y';
1070:
1071: IF (FIIDIM_Debug) THEN
1072: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD2_HIER_GT');
1073: END IF;
1074:
1075: IF (FIIDIM_Debug) THEN
1076: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD2_MAINTAIN_PKG.'||

Line 1083: FII_UTIL.Write_Log ('Get_Pruned_UD2_GT -> phase: '|| g_phase);

1079:
1080: EXCEPTION
1081:
1082: WHEN OTHERS THEN
1083: FII_UTIL.Write_Log ('Get_Pruned_UD2_GT -> phase: '|| g_phase);
1084: FII_UTIL.Write_Log ('Get_Pruned_UD2_GT: '|| substr(sqlerrm,1,180));
1085: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.'||
1086: 'Get_Pruned_UD2_GT');
1087: raise;

Line 1084: FII_UTIL.Write_Log ('Get_Pruned_UD2_GT: '|| substr(sqlerrm,1,180));

1080: EXCEPTION
1081:
1082: WHEN OTHERS THEN
1083: FII_UTIL.Write_Log ('Get_Pruned_UD2_GT -> phase: '|| g_phase);
1084: FII_UTIL.Write_Log ('Get_Pruned_UD2_GT: '|| substr(sqlerrm,1,180));
1085: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.'||
1086: 'Get_Pruned_UD2_GT');
1087: raise;
1088:

Line 1122: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);

1118: -- disabled now, in which case initial refresh of MV should happen
1119: -- so it is ok to truncate the tables
1120:
1121: g_phase := 'Truncate dimension hierarchy tables';
1122: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1123: FII_UTIL.truncate_table ('FII_UDD2_HIERARCHIES', 'FII', g_retcode);
1124: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1125:
1126: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';

Line 1123: FII_UTIL.truncate_table ('FII_UDD2_HIERARCHIES', 'FII', g_retcode);

1119: -- so it is ok to truncate the tables
1120:
1121: g_phase := 'Truncate dimension hierarchy tables';
1122: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1123: FII_UTIL.truncate_table ('FII_UDD2_HIERARCHIES', 'FII', g_retcode);
1124: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1125:
1126: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';
1127:

Line 1124: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);

1120:
1121: g_phase := 'Truncate dimension hierarchy tables';
1122: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1123: FII_UTIL.truncate_table ('FII_UDD2_HIERARCHIES', 'FII', g_retcode);
1124: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1125:
1126: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';
1127:
1128: INSERT INTO FII_FULL_UDD2_HIERS

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

1224:
1225: EXCEPTION
1226:
1227: WHEN OTHERS THEN
1228: FII_UTIL.Write_Log ('Handle_Unenabled_DIM: '|| substr(sqlerrm,1,180));
1229: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.'||
1230: 'Handle_Unenabled_DIM');
1231: raise;
1232:

Line 1269: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);

1265:
1266: --Copy TMP hierarchy table to the final dimension table
1267: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1268:
1269: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1270:
1271: INSERT /*+ APPEND */ INTO FII_FULL_UDD2_HIERS (
1272: parent_level,
1273: parent_value_id,

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

1302: FII_LOGIN_ID
1303: FROM FII_UDD2_HIER_GT;
1304:
1305: IF (FIIDIM_Debug) THEN
1306: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_UDD2_HIERS');
1307: END IF;
1308:
1309: --Call FND_STATS to collect statistics after re-populating the tables.
1310: --for the full dimension table since it will be used later

Line 1325: FII_UTIL.truncate_table ('FII_UDD2_HIERARCHIES', 'FII', g_retcode);

1321:
1322: --Copy FII_UDD2_HIER_GT to the final (pruned) dimension table
1323: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1324:
1325: FII_UTIL.truncate_table ('FII_UDD2_HIERARCHIES', 'FII', g_retcode);
1326:
1327: INSERT /*+ APPEND */ INTO FII_UDD2_HIERARCHIES (
1328: parent_level,
1329: parent_value_id,

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

1362: FII_LOGIN_ID
1363: FROM FII_UDD2_HIER_GT;
1364:
1365: IF (FIIDIM_Debug) THEN
1366: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_HIERARCHIES');
1367: END IF;
1368:
1369: -- This will be in RSG data
1370: g_phase := 'gather_table_stats for FII_UDD2_HIERARCHIES';

Line 1394: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);

1390:
1391: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS
1392: g_phase := 'Copy TMP UD2 Mapping table to the UD2 Mapping Table';
1393:
1394: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1395:
1396: INSERT /*+ APPEND */ INTO FII_UDD2_MAPPINGS (
1397: PARENT_USER_DIM2_ID,
1398: CHILD_USER_DIM2_ID,

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

1411: FII_LOGIN_ID
1412: FROM FII_UDD2_MAPPING_GT;
1413:
1414: IF (FIIDIM_Debug) THEN
1415: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS');
1416: END IF;
1417:
1418: --Call FND_STATS to collect statistics after re-populating the table.
1419:

Line 1446: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Init_Load: '||

1442: EXCEPTION
1443:
1444: WHEN UDIM2_fatal_err THEN
1445:
1446: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Init_Load: '||
1447: 'User defined error');
1448:
1449: FND_CONCURRENT.Af_Rollback;
1450: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');

Line 1456: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Init_Load: '||

1452: ret_val := FND_CONCURRENT.Set_Completion_Status
1453: (status => 'ERROR', message => substr(sqlerrm,1,180));
1454:
1455: WHEN UDIM2_MULT_PAR_err THEN
1456: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Init_Load: '||
1457: 'Diamond Shape Detected');
1458:
1459: FND_CONCURRENT.Af_Rollback;
1460: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');

Line 1466: FII_UTIL.Write_Log ('>>> UDD2 Dimension Not Enabled...');

1462: ret_val := FND_CONCURRENT.Set_Completion_Status
1463: (status => 'ERROR', message => substr(sqlerrm,1,180));
1464:
1465: WHEN UDIM2_NOT_ENABLED THEN
1466: FII_UTIL.Write_Log ('>>> UDD2 Dimension Not Enabled...');
1467:
1468: Handle_Unenabled_DIM;
1469:
1470: retcode := sqlcode;

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

1471: --ret_val := FND_CONCURRENT.Set_Completion_Status
1472: -- (status => 'NORMAL', message => NULL);
1473:
1474: WHEN OTHERS THEN
1475: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1476: FII_UTIL.Write_Log (
1477: 'Other error in FII_UDD2_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1478:
1479:

Line 1476: FII_UTIL.Write_Log (

1472: -- (status => 'NORMAL', message => NULL);
1473:
1474: WHEN OTHERS THEN
1475: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1476: FII_UTIL.Write_Log (
1477: 'Other error in FII_UDD2_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1478:
1479:
1480: FND_CONCURRENT.Af_Rollback;

Line 1517: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);

1513:
1514: Flatten_UD2_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1515:
1516: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1517: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1518:
1519: Insert into FII_FULL_UDD2_HIERS (
1520: parent_level,
1521: parent_value_id,

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

1549: FII_LOGIN_ID
1550: FROM FII_UDD2_HIER_GT;
1551:
1552: IF (FIIDIM_Debug) THEN
1553: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_UDD2_HIERS');
1554: END IF;
1555:
1556: --Call FND_STATS to collect statistics after re-populating the tables.
1557: --for the full dimension table since it will be used later

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

1600: FROM FII_UDD2_HIER_GT);
1601:
1602:
1603: IF (FIIDIM_Debug) THEN
1604: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD2_HIERARCHIES');
1605: END IF;
1606:
1607: Insert into FII_UDD2_HIERARCHIES (
1608: parent_level,

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

1660: FII_LOGIN_ID
1661: FROM FII_UDD2_HIERARCHIES);
1662:
1663: IF (FIIDIM_Debug) THEN
1664: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_HIERARCHIES');
1665: END IF;
1666:
1667: -- This will be in RSG data
1668: g_phase := 'gather_table_stats for FII_UDD2_HIERARCHIES';

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

1698: SELECT PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID
1699: FROM FII_UDD2_MAPPING_GT);
1700:
1701: IF (FIIDIM_Debug) THEN
1702: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD2_MAPPINGS');
1703: END IF;
1704:
1705: g_phase := 'Insert into FII_UDD2_MAPPINGS';
1706:

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

1730: FII_LOGIN_ID
1731: FROM FII_UDD2_MAPPINGS);
1732:
1733: IF (FIIDIM_Debug) THEN
1734: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS');
1735: END IF;
1736:
1737: --Call FND_STATS to collect statistics after re-populating the table.
1738:

Line 1767: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Incre_Update'||

1763: -- Exception handling
1764:
1765: EXCEPTION
1766: WHEN UDIM2_fatal_err THEN
1767: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Incre_Update'||
1768: 'User defined error');
1769:
1770: FND_CONCURRENT.Af_Rollback;
1771: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Incre_Update');

Line 1777: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Incre_Update: '||

1773: ret_val := FND_CONCURRENT.Set_Completion_Status
1774: (status => 'ERROR', message => substr(sqlerrm,1,180));
1775:
1776: WHEN UDIM2_MULT_PAR_err THEN
1777: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Incre_Update: '||
1778: 'Diamond Shape Detected');
1779:
1780: FND_CONCURRENT.Af_Rollback;
1781: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Incre_Update');

Line 1787: FII_UTIL.Write_Log ('>>> User Defined Dimension2 Not Enabled...');

1783: ret_val := FND_CONCURRENT.Set_Completion_Status
1784: (status => 'ERROR', message => substr(sqlerrm,1,180));
1785:
1786: WHEN UDIM2_NOT_ENABLED THEN
1787: FII_UTIL.Write_Log ('>>> User Defined Dimension2 Not Enabled...');
1788:
1789: Handle_Unenabled_DIM;
1790:
1791: retcode := sqlcode;

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

1792: --ret_val := FND_CONCURRENT.Set_Completion_Status
1793: -- (status => 'NORMAL', message => NULL);
1794:
1795: WHEN OTHERS THEN
1796: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1797: FII_UTIL.Write_Log (
1798: 'Other error in FII_UDD2_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1799:
1800:

Line 1797: FII_UTIL.Write_Log (

1793: -- (status => 'NORMAL', message => NULL);
1794:
1795: WHEN OTHERS THEN
1796: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1797: FII_UTIL.Write_Log (
1798: 'Other error in FII_UDD2_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1799:
1800:
1801: FND_CONCURRENT.Af_Rollback;