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

Line 75: l_dir := FII_UTIL.get_utl_file_dir;

71: -- Set default directory in case if the profile option
72: -- BIS_DEBUG_LOG_DIRECTORY is not set up
73: ------------------------------------------------------
74: if l_dir is NULL then
75: l_dir := FII_UTIL.get_utl_file_dir;
76: end if;
77:
78: ----------------------------------------------------------------
79: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

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

75: l_dir := FII_UTIL.get_utl_file_dir;
76: end if;
77:
78: ----------------------------------------------------------------
79: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
80: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
81: -- the log files and output files are written to
82: ----------------------------------------------------------------
83: FII_UTIL.initialize('FII_PMV_HELPER_TABLES_C.log',

Line 83: FII_UTIL.initialize('FII_PMV_HELPER_TABLES_C.log',

79: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
80: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
81: -- the log files and output files are written to
82: ----------------------------------------------------------------
83: FII_UTIL.initialize('FII_PMV_HELPER_TABLES_C.log',
84: 'FII_PMV_HELPER_TABLES_C.out',l_dir,'FII_PMV_HELPER_TABLES_C');
85:
86: -- Obtain FII schema name
87: g_schema_name := FII_UTIL.get_schema_name ('FII');

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

83: FII_UTIL.initialize('FII_PMV_HELPER_TABLES_C.log',
84: 'FII_PMV_HELPER_TABLES_C.out',l_dir,'FII_PMV_HELPER_TABLES_C');
85:
86: -- Obtain FII schema name
87: g_schema_name := FII_UTIL.get_schema_name ('FII');
88:
89: -- Obtain user ID, login ID and initialize package variables
90: g_phase := 'Obtain the User ID and Login ID';
91: FII_USER_ID := FND_GLOBAL.USER_ID;

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

92: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
93:
94: -- If any of the above values is not set, error out
95: IF (FII_User_Id is NULL OR FII_Login_Id is NULL) THEN
96: FII_UTIL.Write_Log ('>>> Failed Intialization');
97: RAISE PMVH_fatal_err;
98: END IF;
99:
100: -- Determine if process will be run in debug mode

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

99:
100: -- Determine if process will be run in debug mode
101: IF (NVL(G_Debug_Mode, 'N') <> 'N') THEN
102: FIIDIM_Debug := TRUE;
103: FII_UTIL.Write_Log (' Debug On');
104: ELSE
105: FIIDIM_Debug := FALSE;
106: FII_UTIL.Write_Log (' Debug Off');
107: END IF;

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

102: FIIDIM_Debug := TRUE;
103: FII_UTIL.Write_Log (' Debug On');
104: ELSE
105: FIIDIM_Debug := FALSE;
106: FII_UTIL.Write_Log (' Debug Off');
107: END IF;
108:
109: -- Turn trace on if process is run in debug mode
110: IF (FIIDIM_Debug) THEN

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

109: -- Turn trace on if process is run in debug mode
110: IF (FIIDIM_Debug) THEN
111: -- Program running in debug mode, turning trace on
112: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';
113: FII_UTIL.Write_Log ('Initialize: Set Trace On');
114: END IF;
115:
116: IF (FIIDIM_Debug) THEN
117: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Helper Table Population');

Line 117: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Helper Table Population');

113: FII_UTIL.Write_Log ('Initialize: Set Trace On');
114: END IF;
115:
116: IF (FIIDIM_Debug) THEN
117: FII_UTIL.Write_Log ('Initialize: Now start processing '|| 'Helper Table Population');
118: End If;
119:
120: -- --------------------------------------------------------
121: -- Find the unassigned ID

Line 141: FII_UTIL.Write_Log ('Value for profile FII: Nodes to be Aggregated is not set correctly.

137: -- should be 100.
138: l_nodes := NVL(fnd_profile.value('FII_AGGREGATE_NODES'), 100);
139: EXCEPTION
140: WHEN value_error THEN
141: FII_UTIL.Write_Log ('Value for profile FII: Nodes to be Aggregated is not set correctly.
142: Please enter a numeric value for the profile.');
143: raise;
144: END;
145: G_SUPPORTED_NODES := POWER(l_nodes,4);

Line 148: FII_UTIL.Write_Log('Supported number of nodes : ' || G_SUPPORTED_NODES);

144: END;
145: G_SUPPORTED_NODES := POWER(l_nodes,4);
146:
147: IF (FIIDIM_Debug) THEN
148: FII_UTIL.Write_Log('Supported number of nodes : ' || G_SUPPORTED_NODES);
149: END IF;
150:
151: -- --------------------------------------------------------
152: -- Get the DBI enabled flag for all the dimensions which

Line 181: FII_UTIL.Write_Log ('Set up for Financial Category not done');

177: END IF;
178:
179: EXCEPTION
180: WHEN NO_DATA_FOUND THEN
181: FII_UTIL.Write_Log ('Set up for Financial Category not done');
182: G_FC_DBI_ENABLED_FLAG := 'N';
183: END;
184:
185: IF (G_FC_DBI_ENABLED_FLAG = 'N') THEN

Line 190: FII_UTIL.Write_Log('DBI Enabled flag for Financial Category : ' || G_FC_DBI_ENABLED_FLAG);

186: l_count := l_count - 1;
187: END IF;
188:
189: IF (FIIDIM_Debug) THEN
190: FII_UTIL.Write_Log('DBI Enabled flag for Financial Category : ' || G_FC_DBI_ENABLED_FLAG);
191: END IF;
192:
193: g_phase := 'Get the enabled flag for Company';
194: -- Get the enabled flag for Company

Line 216: FII_UTIL.Write_Log ('Set up for Company not done');

212: END IF;
213:
214: EXCEPTION
215: WHEN NO_DATA_FOUND THEN
216: FII_UTIL.Write_Log ('Set up for Company not done');
217: G_CO_DBI_ENABLED_FLAG := 'N';
218: END;
219:
220: IF (FIIDIM_Debug) THEN

Line 221: FII_UTIL.Write_Log('DBI Enabled flag for Company : ' || G_CO_DBI_ENABLED_FLAG);

217: G_CO_DBI_ENABLED_FLAG := 'N';
218: END;
219:
220: IF (FIIDIM_Debug) THEN
221: FII_UTIL.Write_Log('DBI Enabled flag for Company : ' || G_CO_DBI_ENABLED_FLAG);
222: END IF;
223:
224: IF(G_CO_DBI_ENABLED_FLAG = 'N') THEN
225: l_count := l_count - 1;

Line 255: FII_UTIL.Write_Log ('Set up for Cost Center not done');

251: END IF;
252:
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: FII_UTIL.Write_Log ('Set up for Cost Center not done');
256: G_CC_DBI_ENABLED_FLAG := 'N';
257: END;
258:
259: IF (FIIDIM_Debug) THEN

Line 260: FII_UTIL.Write_Log('DBI Enabled flag for Cost Center : ' || G_CC_DBI_ENABLED_FLAG);

256: G_CC_DBI_ENABLED_FLAG := 'N';
257: END;
258:
259: IF (FIIDIM_Debug) THEN
260: FII_UTIL.Write_Log('DBI Enabled flag for Cost Center : ' || G_CC_DBI_ENABLED_FLAG);
261: END IF;
262:
263: IF(G_CC_DBI_ENABLED_FLAG = 'N') THEN
264: l_count := l_count - 1;

Line 295: FII_UTIL.Write_Log ('Set up for User Defined Dimension1 not done');

291: END IF;
292:
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: FII_UTIL.Write_Log ('Set up for User Defined Dimension1 not done');
296: G_UDD1_DBI_ENABLED_FLAG := 'N';
297: END;
298:
299: IF(G_UDD1_DBI_ENABLED_FLAG = 'N') THEN

Line 304: FII_UTIL.Write_Log('DBI Enabled flag for User Defined Dimension1 : ' || G_UDD1_DBI_ENABLED_FLAG);

300: l_count := l_count - 1;
301: END IF;
302:
303: IF (FIIDIM_Debug) THEN
304: FII_UTIL.Write_Log('DBI Enabled flag for User Defined Dimension1 : ' || G_UDD1_DBI_ENABLED_FLAG);
305: END IF;
306:
307: -- Calculate the initial no of nodes allowed to be aggregated
308: -- in each dimension

Line 317: FII_UTIL.Write_Log('Number of Nodes supported to be aggregated for each dimension ' || G_NODES);

313:
314: END IF;
315:
316: IF (FIIDIM_Debug) THEN
317: FII_UTIL.Write_Log('Number of Nodes supported to be aggregated for each dimension ' || G_NODES);
318: END IF;
319:
320: Exception
321: When PMVH_fatal_err then

Line 322: FII_UTIL.Write_Log ('FII_PMV_HELPER_TABLES_C.Initialize : '|| 'User defined error');

318: END IF;
319:
320: Exception
321: When PMVH_fatal_err then
322: FII_UTIL.Write_Log ('FII_PMV_HELPER_TABLES_C.Initialize : '|| 'User defined error');
323: FND_CONCURRENT.Af_Rollback;
324: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Initialize');
325: raise;
326:

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

325: raise;
326:
327: When others then
328: FND_CONCURRENT.Af_Rollback;
329: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
330: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
331: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
332: RAISE;
333:

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

326:
327: When others then
328: FND_CONCURRENT.Af_Rollback;
329: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
330: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
331: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
332: RAISE;
333:
334: END Initialize;

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

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

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

372: NEXT_LEVEL_FIN_CAT_ID,
373: subtree_freq ;
374:
375: IF (FIIDIM_Debug) THEN
376: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
377: END IF;
378:
379: -- This is done to treat the top node differently
380: UPDATE FII_AGGRT_NODE_GT

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

381: SET no_of_children = no_of_children + 1
382: WHERE id = G_FC_TOP_NODE_ID ;
383:
384: IF (FIIDIM_Debug) THEN
385: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
386: END IF;
387:
388: ELSE
389: -- Populate the unassigned node in case the dimension is disabled

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

395: dim_short_name)
396: VALUES(G_UNASSIGNED_ID, 1, 'GL_FII_FIN_ITEM');
397:
398: IF (FIIDIM_Debug) THEN
399: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
400: END IF;
401: END IF;
402:
403: -- For Company Dimension

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

423: NEXT_LEVEL_COMPANY_ID,
424: subtree_freq ;
425:
426: IF (FIIDIM_Debug) THEN
427: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
428: END IF;
429:
430: -- This is done to treat the top node differently
431: UPDATE FII_AGGRT_NODE_GT

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

432: SET no_of_children = no_of_children + 1
433: WHERE id = G_CO_TOP_NODE_ID ;
434:
435: IF (FIIDIM_Debug) THEN
436: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
437: END IF;
438:
439: ELSE
440: -- Populate the unassigned node in case the dimension is disabled

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

445: dim_short_name)
446: VALUES(G_UNASSIGNED_ID, 1, 'FII_COMPANIES');
447:
448: IF (FIIDIM_Debug) THEN
449: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
450: END IF;
451:
452: END IF;
453:

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

474: NEXT_LEVEL_CC_ID,
475: subtree_freq ;
476:
477: IF (FIIDIM_Debug) THEN
478: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
479: END IF;
480:
481: -- This is done to treat the top node differently
482: UPDATE FII_AGGRT_NODE_GT

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

483: SET no_of_children = no_of_children + 1
484: WHERE id = G_CC_TOP_NODE_ID ;
485:
486: IF (FIIDIM_Debug) THEN
487: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
488: END IF;
489:
490: ELSE
491:

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

498: dim_short_name)
499: VALUES(G_UNASSIGNED_ID, 1, 'HRI_CL_ORGCC');
500:
501: IF (FIIDIM_Debug) THEN
502: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
503: END IF;
504:
505: END IF;
506:

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

526: NEXT_LEVEL_VALUE_ID,
527: subtree_freq ;
528:
529: IF (FIIDIM_Debug) THEN
530: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
531: END IF;
532:
533: -- This is done to treat the top node differently
534: UPDATE FII_AGGRT_NODE_GT

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

535: SET no_of_children = no_of_children + 1
536: WHERE id = G_UDD1_TOP_NODE_ID ;
537:
538: IF (FIIDIM_Debug) THEN
539: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
540: END IF;
541:
542: ELSE
543:

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

550: dim_short_name)
551: VALUES(G_UNASSIGNED_ID, 1, 'FII_USER_DEFINED_1');
552:
553: IF (FIIDIM_Debug) THEN
554: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
555: END IF;
556:
557: END IF;
558:

Line 567: FII_UTIL.Write_Log ('Unexpected error when calling populate_temp...');

563:
564: EXCEPTION
565: When others then
566: FND_CONCURRENT.Af_Rollback;
567: FII_UTIL.Write_Log ('Unexpected error when calling populate_temp...');
568: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
569: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
570: raise;
571:

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

564: EXCEPTION
565: When others then
566: FND_CONCURRENT.Af_Rollback;
567: FII_UTIL.Write_Log ('Unexpected error when calling populate_temp...');
568: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
569: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
570: raise;
571:
572: END populate_temp;

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

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

Line 617: FII_UTIL.Write_Log('Dimension : ' || Dimension_name(p_tab(I).dim_short_name) || ' has : ' || p_tab(I).number_of_nodes ||' Nodes.');

613: p_tab(I).dim_short_name := dim_no_of_nodes_rec.dim_short_name;
614: p_tab(I).gain := 1;
615: -- The no of nodes here includes unassigned node as well except in FC
616: IF (FIIDIM_Debug) THEN
617: FII_UTIL.Write_Log('Dimension : ' || Dimension_name(p_tab(I).dim_short_name) || ' has : ' || p_tab(I).number_of_nodes ||' Nodes.');
618: END IF;
619:
620: I := I +1;
621: END LOOP;

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

671: from fii_fin_cat_type_assgns
672: where fin_cat_type_code = 'R')));
673:
674: IF (FIIDIM_Debug) THEN
675: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
676: END IF;
677:
678: g_phase := 'Get the lowest level at which the top node is defined for Expense';
679: select max(child_level) into l_max_level

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

692: from fii_fin_cat_type_assgns
693: where fin_cat_type_code = 'EXP'));
694:
695: IF (FIIDIM_Debug) THEN
696: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
697: END IF;
698:
699: g_phase := 'Updating the FC pmv helper table for the newly aggregated nodes';
700: update fii_fc_pmv_agrt_nodes f

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

707: where next_level_fin_cat_id = f.fin_category_id
708: and parent_level = next_level);
709:
710: IF (FIIDIM_Debug) THEN
711: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FC_PMV_AGRT_NODES');
712: END IF;
713:
714: g_phase := 'gather_table_stats for FII_FIN_ITEM_LEAF_HIERS';
715: FND_STATS.gather_table_stats

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

733: and next_level in (1,2);
734:
735:
736: IF (FIIDIM_Debug) THEN
737: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
738: END IF;
739:
740: g_phase := 'Updating the Cost Center pmv helper table for the newly aggregated nodes';
741: update fii_cc_pmv_agrt_nodes f

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

748: where next_level_cc_id = f.cost_center_id
749: and parent_level = next_level);
750:
751: IF (FIIDIM_Debug) THEN
752: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
753: END IF;
754:
755: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';
756: FND_STATS.gather_table_stats

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

773: where aggregate_next_level_flag <> 'Y'
774: and next_level in (1,2);
775:
776: IF (FIIDIM_Debug) THEN
777: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
778: END IF;
779:
780: g_phase := 'Updating the Company pmv helper table for the newly aggregated nodes';
781: update fii_com_pmv_agrt_nodes f

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

788: where next_level_company_id = f.company_id
789: and parent_level = next_level);
790:
791: IF (FIIDIM_Debug) THEN
792: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COM_PMV_AGRT_NODES');
793: END IF;
794:
795: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';
796: FND_STATS.gather_table_stats

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

813: where aggregate_next_level_flag <> 'Y'
814: and next_level in (1,2);
815:
816: IF (FIIDIM_Debug) THEN
817: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
818: END IF;
819:
820: g_phase := 'Updating the User Defined Dimension 1 pmv helper table for the newly aggregated nodes';
821: update fii_udd1_pmv_agrt_nodes f

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

828: where next_level_value_id = f.udd1_value_id
829: and parent_level = next_level);
830:
831: IF (FIIDIM_Debug) THEN
832: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
833: END IF;
834:
835: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
836: FND_STATS.gather_table_stats

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

878: from fii_fc_pmv_agrt_nodes
879: where fin_category_id = f.next_level_fin_cat_id);
880:
881: IF (FIIDIM_Debug) THEN
882: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
883: END IF;
884:
885: ELSE
886: g_phase := 'In ELSE Update FII_FIN_ITEM_LEAF_HIERS and set the aggregate_next_level_flag';

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

889: from fii_fc_pmv_agrt_nodes
890: where fin_category_id = f.next_level_fin_cat_id);
891:
892: IF (FIIDIM_Debug) THEN
893: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
894: END IF;
895:
896: END IF;
897:

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

913: from fii_com_pmv_agrt_nodes
914: where company_id = f.next_level_company_id);
915:
916: IF (FIIDIM_Debug) THEN
917: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
918: END IF;
919:
920: ELSE
921: g_phase := 'In ELSE Update fii_company_hierarchies and set the aggregate_next_level_flag';

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

924: from fii_com_pmv_agrt_nodes
925: where company_id = f.next_level_company_id);
926:
927: IF (FIIDIM_Debug) THEN
928: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
929: END IF;
930:
931: END IF;
932:

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

947: from fii_cc_pmv_agrt_nodes
948: where cost_center_id = f.next_level_cc_id);
949:
950: IF (FIIDIM_Debug) THEN
951: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
952: END IF;
953:
954: ELSE
955: g_phase := 'In ELSE Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';

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

958: from fii_cc_pmv_agrt_nodes
959: where cost_center_id = f.next_level_cc_id);
960:
961: IF (FIIDIM_Debug) THEN
962: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
963: END IF;
964:
965: END IF;
966:

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

981: from fii_udd1_pmv_agrt_nodes
982: where UDD1_VALUE_ID = f.next_level_value_id);
983:
984: IF (FIIDIM_Debug) THEN
985: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
986: END IF;
987:
988: ELSE
989: g_phase := 'In ELSE Update fii_udd1_hierarchies and set the aggregate_next_level_flag';

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

992: from fii_udd1_pmv_agrt_nodes
993: where UDD1_VALUE_ID = f.next_level_value_id);
994:
995: IF (FIIDIM_Debug) THEN
996: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
997: END IF;
998:
999: END IF;
1000:

Line 1028: FII_UTIL.Write_Log ('Unexpected error when calling Update_pruned_table...');

1024:
1025: EXCEPTION
1026: When others then
1027: FND_CONCURRENT.Af_Rollback;
1028: FII_UTIL.Write_Log ('Unexpected error when calling Update_pruned_table...');
1029: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1030: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1031: raise;
1032:

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

1025: EXCEPTION
1026: When others then
1027: FND_CONCURRENT.Af_Rollback;
1028: FII_UTIL.Write_Log ('Unexpected error when calling Update_pruned_table...');
1029: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1030: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1031: raise;
1032:
1033: END Update_pruned_table;

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

1026: When others then
1027: FND_CONCURRENT.Af_Rollback;
1028: FII_UTIL.Write_Log ('Unexpected error when calling Update_pruned_table...');
1029: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1030: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1031: raise;
1032:
1033: END Update_pruned_table;
1034:

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

1059: where f1.next_level_fin_cat_id = f2.parent_fin_cat_id
1060: and f2.aggregate_next_level_flag = 'Y'
1061: and f2.parent_fin_cat_id <> f2.next_level_fin_cat_id));
1062: IF (FIIDIM_Debug) THEN
1063: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_FC_PMV_AGRT_NODES');
1064: END IF;
1065:
1066:
1067: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN

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

1078: and f2.aggregate_next_level_flag = 'Y'
1079: and f2.parent_company_id <> f2.next_level_company_id));
1080:
1081: IF (FIIDIM_Debug) THEN
1082: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_COM_PMV_AGRT_NODES');
1083: END IF;
1084:
1085:
1086: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN

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

1097: and f2.aggregate_next_level_flag = 'Y'
1098: and f2.parent_cc_id <> f2.next_level_cc_id));
1099:
1100: IF (FIIDIM_Debug) THEN
1101: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_PMV_AGRT_NODES');
1102: END IF;
1103:
1104: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1105: g_phase := 'Update FII_UDD1_PMV_AGRT_NODES for User Defined Dimension1';

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

1115: and f2.aggregate_next_level_flag = 'Y'
1116: and f2.parent_value_id <> f2.next_level_value_id));
1117:
1118: IF (FIIDIM_Debug) THEN
1119: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD1_PMV_AGRT_NODES');
1120: END IF;
1121:
1122: END IF;
1123:

Line 1131: FII_UTIL.Write_Log ('Unexpected error when calling update_viewby_flag...');

1127:
1128: EXCEPTION
1129: When others then
1130: FND_CONCURRENT.Af_Rollback;
1131: FII_UTIL.Write_Log ('Unexpected error when calling update_viewby_flag...');
1132: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1133: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1134: raise;
1135:

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

1128: EXCEPTION
1129: When others then
1130: FND_CONCURRENT.Af_Rollback;
1131: FII_UTIL.Write_Log ('Unexpected error when calling update_viewby_flag...');
1132: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1133: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1134: raise;
1135:
1136: END update_viewby_flag;

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

1129: When others then
1130: FND_CONCURRENT.Af_Rollback;
1131: FII_UTIL.Write_Log ('Unexpected error when calling update_viewby_flag...');
1132: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1133: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1134: raise;
1135:
1136: END update_viewby_flag;
1137:

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

1178: where parent_level= next_level
1179: ) ;
1180:
1181: IF (FIIDIM_Debug) THEN
1182: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_PMV_AGRT_NODES');
1183: END IF;
1184: --For Company Dimension
1185: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN
1186: g_phase := 'Inserting into fii_com_pmv_agrt_nodes for Company';

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

1202: where parent_level= next_level
1203: );
1204:
1205: IF (FIIDIM_Debug) THEN
1206: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_PMV_AGRT_NODES');
1207: END IF;
1208:
1209: --For CC Dimension
1210: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN

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

1227: where parent_level= next_level
1228: ) ;
1229:
1230: IF (FIIDIM_Debug) THEN
1231: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
1232: END IF;
1233:
1234: --For UDD1
1235: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN

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

1252: where parent_level= next_level
1253: ) ;
1254:
1255: IF (FIIDIM_Debug) THEN
1256: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
1257: END IF;
1258:
1259: END IF;
1260:

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

1312: where dim_short_name = p_dim_short_name
1313: AND no_of_children >= l_subtree_freq;
1314:
1315: IF (FIIDIM_Debug) THEN
1316: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_PMV_AGRT_NODES');
1317: END IF;
1318: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN
1319:
1320: g_phase := 'Inserting into fii_com_pmv_agrt_nodes from fii_aggrt_node_gt';

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

1337: where dim_short_name = p_dim_short_name
1338: AND no_of_children >= l_subtree_freq;
1339:
1340: IF (FIIDIM_Debug) THEN
1341: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_PMV_AGRT_NODES');
1342: END IF;
1343:
1344: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1345:

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

1363: where dim_short_name = p_dim_short_name
1364: AND no_of_children >= l_subtree_freq;
1365:
1366: IF (FIIDIM_Debug) THEN
1367: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
1368: END IF;
1369:
1370: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1371:

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

1389: where dim_short_name = p_dim_short_name
1390: AND no_of_children >= l_subtree_freq;
1391:
1392: IF (FIIDIM_Debug) THEN
1393: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
1394: END IF;
1395: END IF;
1396:
1397: -- Insert the records which will not be aggregated

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

1423: FII_LOGIN_ID
1424: from fii_fc_pmv_agrt_nodes);
1425:
1426: IF (FIIDIM_Debug) THEN
1427: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_PMV_AGRT_NODES');
1428: END IF;
1429:
1430: --For Company Dimension
1431: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN

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

1455: FII_LOGIN_ID
1456: from fii_com_pmv_agrt_nodes);
1457:
1458: IF (FIIDIM_Debug) THEN
1459: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_PMV_AGRT_NODES');
1460: END IF;
1461:
1462: --For CC Dimension
1463: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN

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

1487: FII_LOGIN_ID
1488: from fii_cc_pmv_agrt_nodes) ;
1489:
1490: IF (FIIDIM_Debug) THEN
1491: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
1492: END IF;
1493:
1494: --For UDD1
1495: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN

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

1519: FII_LOGIN_ID
1520: from fii_udd1_pmv_agrt_nodes) ;
1521:
1522: IF (FIIDIM_Debug) THEN
1523: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
1524: END IF;
1525:
1526: END IF;
1527:

Line 1587: FII_UTIL.Write_Log ('Unexpected error when calling Populate_PMV_Helper_GT...');

1583:
1584: EXCEPTION
1585: When others then
1586: FND_CONCURRENT.Af_Rollback;
1587: FII_UTIL.Write_Log ('Unexpected error when calling Populate_PMV_Helper_GT...');
1588: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1589: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1590: raise;
1591:

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

1584: EXCEPTION
1585: When others then
1586: FND_CONCURRENT.Af_Rollback;
1587: FII_UTIL.Write_Log ('Unexpected error when calling Populate_PMV_Helper_GT...');
1588: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1589: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1590: raise;
1591:
1592: END Populate_PMV_Helper_GT;

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

1585: When others then
1586: FND_CONCURRENT.Af_Rollback;
1587: FII_UTIL.Write_Log ('Unexpected error when calling Populate_PMV_Helper_GT...');
1588: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1589: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1590: raise;
1591:
1592: END Populate_PMV_Helper_GT;
1593:

Line 1608: FII_UTIL.truncate_table ('FII_FC_PMV_AGRT_NODES', 'FII', g_retcode);

1604: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.truncate_helper_tables');
1605: END IF;
1606:
1607: g_phase := 'Truncate all the helper tables';
1608: FII_UTIL.truncate_table ('FII_FC_PMV_AGRT_NODES', 'FII', g_retcode);
1609: IF(g_retcode = '-1') THEN
1610: raise PMVH_lock_err;
1611: END IF;
1612:

Line 1613: FII_UTIL.truncate_table ('FII_COM_PMV_AGRT_NODES', 'FII', g_retcode);

1609: IF(g_retcode = '-1') THEN
1610: raise PMVH_lock_err;
1611: END IF;
1612:
1613: FII_UTIL.truncate_table ('FII_COM_PMV_AGRT_NODES', 'FII', g_retcode);
1614: IF(g_retcode = '-1') THEN
1615: raise PMVH_lock_err;
1616: END IF;
1617:

Line 1618: FII_UTIL.truncate_table ('FII_CC_PMV_AGRT_NODES', 'FII', g_retcode);

1614: IF(g_retcode = '-1') THEN
1615: raise PMVH_lock_err;
1616: END IF;
1617:
1618: FII_UTIL.truncate_table ('FII_CC_PMV_AGRT_NODES', 'FII', g_retcode);
1619: IF(g_retcode = '-1') THEN
1620: raise PMVH_lock_err;
1621: END IF;
1622:

Line 1623: FII_UTIL.truncate_table ('FII_UDD1_PMV_AGRT_NODES','FII', g_retcode);

1619: IF(g_retcode = '-1') THEN
1620: raise PMVH_lock_err;
1621: END IF;
1622:
1623: FII_UTIL.truncate_table ('FII_UDD1_PMV_AGRT_NODES','FII', g_retcode);
1624: IF(g_retcode = '-1') THEN
1625: raise PMVH_lock_err;
1626: END IF;
1627:

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

1630: END If;
1631:
1632: EXCEPTION
1633: WHEN PMVH_lock_err THEN
1634: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1635: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1636: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.'||
1637: 'truncate_helper_tables');
1638: raise;

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

1631:
1632: EXCEPTION
1633: WHEN PMVH_lock_err THEN
1634: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1635: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1636: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.'||
1637: 'truncate_helper_tables');
1638: raise;
1639:

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

1637: 'truncate_helper_tables');
1638: raise;
1639:
1640: WHEN OTHERS THEN
1641: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1642: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1643: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.'||
1644: 'truncate_helper_tables');
1645: raise;

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

1638: raise;
1639:
1640: WHEN OTHERS THEN
1641: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1642: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1643: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.'||
1644: 'truncate_helper_tables');
1645: raise;
1646:

Line 1673: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(1).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );

1669: g_phase := 'Processing for the smallest Dimension';
1670: G_OPTIMUM_NODES := G_NODES;
1671:
1672: IF (FIIDIM_Debug) THEN
1673: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(1).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );
1674: END IF;
1675:
1676: If(p_tab(1).number_of_nodes< G_OPTIMUM_NODES) THEN
1677: g_keep_gain_flag := 'N';

Line 1688: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(2).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );

1684: p_tab(1).gain);
1685: End if;
1686:
1687: IF (FIIDIM_Debug) THEN
1688: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(2).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );
1689: END IF;
1690: g_phase := 'Processing for the second smallest Dimension';
1691: -- For the second smallest dimension
1692: If(p_tab(2).number_of_nodes < G_OPTIMUM_NODES) THEN

Line 1712: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(3).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );

1708:
1709: G_OPTIMUM_NODES := ROUND(G_NODES * p_tab(2).gain);
1710:
1711: IF (FIIDIM_Debug) THEN
1712: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(3).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );
1713: END IF;
1714:
1715: If(p_tab(3).number_of_nodes < G_OPTIMUM_NODES) THEN
1716: g_keep_gain_flag := 'N';

Line 1735: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(4).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );

1731: g_phase := 'Processing for the largest Dimension';
1732: G_OPTIMUM_NODES := ROUND(G_NODES * p_tab(3).gain *p_tab(1).gain);
1733:
1734: IF (FIIDIM_Debug) THEN
1735: FII_UTIL.Write_Log('No. of Nodes which can be aggregated in ' || Dimension_name(p_tab(4).dim_short_name) || ' is : ' || G_OPTIMUM_NODES );
1736: END IF;
1737:
1738: If(p_tab(4).number_of_nodes < G_OPTIMUM_NODES) THEN
1739: g_keep_gain_flag := 'N';

Line 1834: FII_UTIL.Write_Log ('FII_PMV_HELPER_TABLES_C.Load_Main: '||

1830: EXCEPTION
1831:
1832: WHEN PMVH_fatal_err THEN
1833:
1834: FII_UTIL.Write_Log ('FII_PMV_HELPER_TABLES_C.Load_Main: '||
1835: 'User defined error');
1836:
1837: FND_CONCURRENT.Af_Rollback;
1838: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');

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

1840: ret_val := FND_CONCURRENT.Set_Completion_Status
1841: (status => 'ERROR', message => substr(sqlerrm,1,180));
1842:
1843: WHEN OTHERS THEN
1844: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1845: FII_UTIL.Write_Log (
1846: 'Other error in FII_PMV_HELPER_TABLES_C.Load_Main: ' || substr(sqlerrm,1,180));
1847:
1848: FND_CONCURRENT.Af_Rollback;

Line 1845: FII_UTIL.Write_Log (

1841: (status => 'ERROR', message => substr(sqlerrm,1,180));
1842:
1843: WHEN OTHERS THEN
1844: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1845: FII_UTIL.Write_Log (
1846: 'Other error in FII_PMV_HELPER_TABLES_C.Load_Main: ' || substr(sqlerrm,1,180));
1847:
1848: FND_CONCURRENT.Af_Rollback;
1849: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');