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_UDD1_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_UDD1_MAINTAIN_PKG.log',

Line 149: FII_UTIL.initialize('FII_UDD1_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_UDD1_MAINTAIN_PKG.log',
150: 'FII_UDD1_MAINTAIN_PKG.out',l_dir,'FII_UDD1_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 UDIM1_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 UDIM1_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 UDIM1_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 dimension1');

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

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 dimension1');
208: End If;
209:
210:
211: -- --------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

279: IF (FIIDIM_Debug) THEN
280: FII_UTIL.Write_Log ('USER DEFINED DIMENSION1 Master Value Set ID: '|| G_MASTER_VALUE_SET_ID);
281: FII_UTIL.Write_Log ('USER DEFINED DIMENSION1 Master Value Set: '||
282: Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
283: FII_UTIL.Write_Log (' and USER DEFINED Dimension1 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 UDIM1_NOT_ENABLED then
310: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
311: --Let the main program handle this
312: raise;
313:
314: When UDIM1_fatal_err then

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

311: --Let the main program handle this
312: raise;
313:
314: When UDIM1_fatal_err then
315: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Initialize : '|| 'User defined error');
316: FND_CONCURRENT.Af_Rollback;
317: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_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_UDD1_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_UDD1_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||

457:
458: Exception
459:
460: When UDIM1_fatal_err then
461: FII_UTIL.Write_Log ('FII_UDD1_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_UDD1_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 568: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Detect_Diamond_Shape: '||

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

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

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

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

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

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

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

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

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

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

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

Line 715: FII_UTIL.truncate_table ('FII_UDD1_HIER_GT', 'FII', g_retcode);

711: FII_MESSAGE.Func_Ent(func_name => 'FII_UDD1_MAINTAIN_PKG.'||
712: 'Flatten_UD1_Dim_Hier');
713: END IF;
714: g_phase := 'Truncate table FII_UDD1_HIER_GT';
715: FII_UTIL.truncate_table ('FII_UDD1_HIER_GT', 'FII', g_retcode);
716:
717: -----------------------------------------------------------------
718:
719: UDIM1_parent_node := p_root_node;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

929: 'FII_UDD1_MAINTAIN_PKG.Flatten_UD1_Dim_Hier');
930: raise;
931:
932: WHEN OTHERS THEN
933: FII_UTIL.Write_Log ('Flatten_UD1_Dim_Hier: '|| substr(sqlerrm,1,180));
934: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.'||
935: 'Flatten_UD1_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_UD1_Dim_Hier: '|| substr(sqlerrm,1,180));
934: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.'||
935: 'Flatten_UD1_Dim_Hier');
936: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
937: raise;
938:
939: END Flatten_UD1_Dim_Hier;
940:

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

968: FROM FII_UDD1_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_UDD1_MAPPING_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_UDD1_MAPPING_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_UDD1_MAPPING_GT');
993: END IF;
994:
995: --------------------------------------------------------
996: -- Gather statistics for the use of cost-based optimizer

Line 1012: FII_UTIL.Write_Log ('Get_UD1_Mapping_GT -> phase: '|| g_phase);

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

Line 1013: FII_UTIL.Write_Log ('Get_UD1_Mapping_GT: '|| substr(sqlerrm,1,180));

1009: EXCEPTION
1010:
1011: WHEN OTHERS THEN
1012: FII_UTIL.Write_Log ('Get_UD1_Mapping_GT -> phase: '|| g_phase);
1013: FII_UTIL.Write_Log ('Get_UD1_Mapping_GT: '|| substr(sqlerrm,1,180));
1014: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.'||
1015: 'Get_UD1_Mapping_GT');
1016: raise;
1017:

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

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

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

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

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

1071: Where parent_value_id = child_value_id
1072: and next_level_is_leaf_flag = 'Y';
1073:
1074: IF (FIIDIM_Debug) THEN
1075: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD1_HIER_GT');
1076: END IF;
1077:
1078: IF (FIIDIM_Debug) THEN
1079: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD1_MAINTAIN_PKG.'||

Line 1085: FII_UTIL.Write_Log ('Get_Pruned_UD1_GT -> phase: '|| g_phase);

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

Line 1086: FII_UTIL.Write_Log ('Get_Pruned_UD1_GT: '|| substr(sqlerrm,1,180));

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

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

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

Line 1125: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);

1121: -- so it is ok to truncate the tables
1122:
1123: g_phase := 'Truncate dimension hierarchy tables';
1124: FII_UTIL.truncate_table ('FII_FULL_UDD1_HIERS', 'FII', g_retcode);
1125: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);
1126: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);
1127:
1128: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';
1129:

Line 1126: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);

1122:
1123: g_phase := 'Truncate dimension hierarchy tables';
1124: FII_UTIL.truncate_table ('FII_FULL_UDD1_HIERS', 'FII', g_retcode);
1125: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);
1126: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);
1127:
1128: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';
1129:
1130: INSERT INTO FII_FULL_UDD1_HIERS

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

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

Line 1270: FII_UTIL.truncate_table ('FII_FULL_UDD1_HIERS', 'FII', g_retcode);

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

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

1303: FII_LOGIN_ID
1304: FROM FII_UDD1_HIER_GT;
1305:
1306: IF (FIIDIM_Debug) THEN
1307: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_UDD1_HIERS');
1308: END IF;
1309:
1310: --------------------------------------------------------
1311: -- Gather statistics for the use of cost-based optimizer

Line 1330: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);

1326:
1327: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table
1328: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1329:
1330: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);
1331:
1332: INSERT /*+ APPEND */ INTO FII_UDD1_HIERARCHIES (
1333: parent_level,
1334: parent_value_id,

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

1367: FII_LOGIN_ID
1368: FROM FII_UDD1_HIER_GT;
1369:
1370: IF (FIIDIM_Debug) THEN
1371: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
1372: END IF;
1373:
1374:
1375: -- This will be in RSG data

Line 1400: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);

1396:
1397: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS
1398: g_phase := 'Copy TMP UD1 Mapping table to the UD1 Mapping Table';
1399:
1400: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);
1401:
1402: INSERT /*+ APPEND */ INTO FII_UDD1_MAPPINGS (
1403: PARENT_USER_DIM1_ID,
1404: CHILD_USER_DIM1_ID,

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

1417: FII_LOGIN_ID
1418: FROM FII_UDD1_MAPPING_GT;
1419:
1420: IF (FIIDIM_Debug) THEN
1421: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_MAPPINGS');
1422: END IF;
1423:
1424: --------------------------------------------------------
1425: -- Gather statistics for the use of cost-based optimizer

Line 1455: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Init_Load: '||

1451: EXCEPTION
1452:
1453: WHEN UDIM1_fatal_err THEN
1454:
1455: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Init_Load: '||
1456: 'User defined error');
1457:
1458: FND_CONCURRENT.Af_Rollback;
1459: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');

Line 1465: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Init_Load: '||

1461: ret_val := FND_CONCURRENT.Set_Completion_Status
1462: (status => 'ERROR', message => substr(sqlerrm,1,180));
1463:
1464: WHEN UDIM1_MULT_PAR_err THEN
1465: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Init_Load: '||
1466: 'Diamond Shape Detected');
1467:
1468: FND_CONCURRENT.Af_Rollback;
1469: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');

Line 1475: FII_UTIL.Write_Log ('>>> UDD1 Dimension Not Enabled...');

1471: ret_val := FND_CONCURRENT.Set_Completion_Status
1472: (status => 'ERROR', message => substr(sqlerrm,1,180));
1473:
1474: WHEN UDIM1_NOT_ENABLED THEN
1475: FII_UTIL.Write_Log ('>>> UDD1 Dimension Not Enabled...');
1476:
1477: Handle_Unenabled_DIM;
1478:
1479: retcode := sqlcode;

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

1480: --ret_val := FND_CONCURRENT.Set_Completion_Status
1481: -- (status => 'NORMAL', message => NULL);
1482:
1483: WHEN OTHERS THEN
1484: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1485: FII_UTIL.Write_Log (
1486: 'Other error in FII_UDD1_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1487:
1488:

Line 1485: FII_UTIL.Write_Log (

1481: -- (status => 'NORMAL', message => NULL);
1482:
1483: WHEN OTHERS THEN
1484: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1485: FII_UTIL.Write_Log (
1486: 'Other error in FII_UDD1_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1487:
1488:
1489: FND_CONCURRENT.Af_Rollback;

Line 1526: FII_UTIL.truncate_table ('FII_FULL_UDD1_HIERS', 'FII', g_retcode);

1522:
1523: Flatten_UD1_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1524:
1525: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1526: FII_UTIL.truncate_table ('FII_FULL_UDD1_HIERS', 'FII', g_retcode);
1527:
1528: Insert into FII_FULL_UDD1_HIERS (
1529: parent_level,
1530: parent_value_id,

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

1558: FII_LOGIN_ID
1559: FROM FII_UDD1_HIER_GT;
1560:
1561: IF (FIIDIM_Debug) THEN
1562: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_UDD1_HIERS');
1563: END IF;
1564:
1565: --------------------------------------------------------
1566: -- Gather statistics for the use of cost-based optimizer

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

1612: FROM FII_UDD1_HIER_GT);
1613:
1614:
1615: IF (FIIDIM_Debug) THEN
1616: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_HIERARCHIES');
1617: END IF;
1618:
1619: Insert into FII_UDD1_HIERARCHIES (
1620: parent_level,

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

1672: FII_LOGIN_ID
1673: FROM FII_UDD1_HIERARCHIES);
1674:
1675: IF (FIIDIM_Debug) THEN
1676: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
1677: END IF;
1678:
1679: -- This will be in RSG data
1680: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';

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

1711: SELECT PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID
1712: FROM FII_UDD1_MAPPING_GT);
1713:
1714: IF (FIIDIM_Debug) THEN
1715: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_MAPPINGS');
1716: END IF;
1717:
1718: g_phase := 'Insert into FII_UDD1_MAPPINGS';
1719:

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

1743: FII_LOGIN_ID
1744: FROM FII_UDD1_MAPPINGS);
1745:
1746: IF (FIIDIM_Debug) THEN
1747: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_MAPPINGS');
1748: END IF;
1749:
1750: --------------------------------------------------------
1751: -- Gather statistics for the use of cost-based optimizer

Line 1783: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Incre_Update'||

1779: -- Exception handling
1780:
1781: EXCEPTION
1782: WHEN UDIM1_fatal_err THEN
1783: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Incre_Update'||
1784: 'User defined error');
1785:
1786: FND_CONCURRENT.Af_Rollback;
1787: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');

Line 1793: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Incre_Update: '||

1789: ret_val := FND_CONCURRENT.Set_Completion_Status
1790: (status => 'ERROR', message => substr(sqlerrm,1,180));
1791:
1792: WHEN UDIM1_MULT_PAR_err THEN
1793: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Incre_Update: '||
1794: 'Diamond Shape Detected');
1795:
1796: FND_CONCURRENT.Af_Rollback;
1797: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');

Line 1803: FII_UTIL.Write_Log ('>>> User Defined Dimension1 Not Enabled...');

1799: ret_val := FND_CONCURRENT.Set_Completion_Status
1800: (status => 'ERROR', message => substr(sqlerrm,1,180));
1801:
1802: WHEN UDIM1_NOT_ENABLED THEN
1803: FII_UTIL.Write_Log ('>>> User Defined Dimension1 Not Enabled...');
1804:
1805: Handle_Unenabled_DIM;
1806:
1807: retcode := sqlcode;

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

1808: --ret_val := FND_CONCURRENT.Set_Completion_Status
1809: -- (status => 'NORMAL', message => NULL);
1810:
1811: WHEN OTHERS THEN
1812: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1813: FII_UTIL.Write_Log (
1814: 'Other error in FII_UDD1_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1815:
1816:

Line 1813: FII_UTIL.Write_Log (

1809: -- (status => 'NORMAL', message => NULL);
1810:
1811: WHEN OTHERS THEN
1812: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1813: FII_UTIL.Write_Log (
1814: 'Other error in FII_UDD1_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1815:
1816:
1817: FND_CONCURRENT.Af_Rollback;