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_MESSAGE

Line 167: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',

163: FROM FII_FINANCIAL_DIMENSIONS
164: WHERE DIMENSION_SHORT_NAME = 'GL_FII_FIN_ITEM';
165:
166: IF(G_FC_DBI_ENABLED_FLAG = 'Y' and G_FC_TOP_NODE_ID is NULL) THEN
167: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
168: token_num => 1,
169: t1 => 'DIM_NAME',
170: v1 => Dimension_name('GL_FII_FIN_ITEM'));
171: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

Line 171: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

167: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
168: token_num => 1,
169: t1 => 'DIM_NAME',
170: v1 => Dimension_name('GL_FII_FIN_ITEM'));
171: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',
172: token_num => 1,
173: t1 => 'DIM_NAME',
174: v1 => Dimension_name('GL_FII_FIN_ITEM'));
175: raise PMVH_fatal_err;

Line 202: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',

198: FROM FII_FINANCIAL_DIMENSIONS
199: WHERE DIMENSION_SHORT_NAME = 'FII_COMPANIES';
200:
201: IF(G_CO_DBI_ENABLED_FLAG = 'Y' and G_CO_TOP_NODE_ID is NULL) THEN
202: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
203: token_num => 1,
204: t1 => 'DIM_NAME',
205: v1 => Dimension_name('FII_COMPANIES'));
206: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

Line 206: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

202: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
203: token_num => 1,
204: t1 => 'DIM_NAME',
205: v1 => Dimension_name('FII_COMPANIES'));
206: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',
207: token_num => 1,
208: t1 => 'DIM_NAME',
209: v1 => Dimension_name('FII_COMPANIES'));
210: raise PMVH_fatal_err;

Line 241: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',

237: FROM FII_FINANCIAL_DIMENSIONS
238: WHERE DIMENSION_SHORT_NAME = 'HRI_CL_ORGCC';
239:
240: IF(G_CC_DBI_ENABLED_FLAG = 'Y' and G_CC_TOP_NODE_ID is NULL) THEN
241: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
242: token_num => 1,
243: t1 => 'DIM_NAME',
244: v1 => Dimension_name('HRI_CL_ORGCC'));
245: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

Line 245: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

241: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
242: token_num => 1,
243: t1 => 'DIM_NAME',
244: v1 => Dimension_name('HRI_CL_ORGCC'));
245: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',
246: token_num => 1,
247: t1 => 'DIM_NAME',
248: v1 => Dimension_name('HRI_CL_ORGCC'));
249: raise PMVH_fatal_err;

Line 281: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',

277: FROM FII_FINANCIAL_DIMENSIONS
278: WHERE DIMENSION_SHORT_NAME = 'FII_USER_DEFINED_1';
279:
280: IF(G_UDD1_DBI_ENABLED_FLAG = 'Y' and G_UDD1_TOP_NODE_ID is NULL) THEN
281: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
282: token_num => 1,
283: t1 => 'DIM_NAME',
284: v1 => Dimension_name('FII_USER_DEFINED_1'));
285: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

Line 285: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',

281: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',
282: token_num => 1,
283: t1 => 'DIM_NAME',
284: v1 => Dimension_name('FII_USER_DEFINED_1'));
285: FII_MESSAGE.write_output (msg_name => 'FII_TNODE_NOT_FOUND',
286: token_num => 1,
287: t1 => 'DIM_NAME',
288: v1 => Dimension_name('FII_USER_DEFINED_1'));
289: raise PMVH_fatal_err;

Line 324: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Initialize');

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:
327: When others then
328: FND_CONCURRENT.Af_Rollback;

Line 347: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.populate_temp');

343: Procedure populate_temp IS
344: BEGIN
345:
346: IF (FIIDIM_Debug) THEN
347: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.populate_temp');
348: END IF;
349:
350: g_phase := 'Populate FII_AGGRT_NODE_GT';
351: -- For FC Dimension

Line 560: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.populate_temp');

556:
557: END IF;
558:
559: IF (FIIDIM_Debug) THEN
560: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.populate_temp');
561: END IF;
562: --FND_CONCURRENT.Af_Commit;
563:
564: EXCEPTION

Line 593: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.calculate_sort_nodes');

589:
590: BEGIN
591:
592: IF (FIIDIM_Debug) THEN
593: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.calculate_sort_nodes');
594: END IF;
595:
596: For dim_no_of_nodes_rec in dim_no_of_nodes
597: LOOP

Line 624: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.calculate_sort_nodes');

620: I := I +1;
621: END LOOP;
622:
623: IF (FIIDIM_Debug) THEN
624: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.calculate_sort_nodes');
625: END IF;
626:
627: END calculate_sort_nodes;
628:

Line 639: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.update_hierarchy');

635: l_max_level number;
636: BEGIN
637:
638: IF (FIIDIM_Debug) THEN
639: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.update_hierarchy');
640: END IF;
641:
642: -- The first two levels should always be set to aggregated
643: -- This is to improve the performance of the reports.

Line 851: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.update_hierarchy');

847:
848: END IF;
849:
850: IF (FIIDIM_Debug) THEN
851: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.update_hierarchy');
852: END IF;
853:
854: END update_hierarchy;
855:

Line 866: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.Update_pruned_table');

862: l_max_agrt_level number;
863: BEGIN
864:
865: IF (FIIDIM_Debug) THEN
866: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.Update_pruned_table');
867: END IF;
868:
869: -- For FC Dimension
870: IF (p_dim_short_name = 'GL_FII_FIN_ITEM') THEN

Line 1022: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.Update_pruned_table');

1018: END IF;
1019: END IF;
1020:
1021: IF (FIIDIM_Debug) THEN
1022: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.Update_pruned_table');
1023: END IF;
1024:
1025: EXCEPTION
1026: When others then

Line 1044: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.update_viewby_flag');

1040: Procedure update_viewby_flag (p_dim_short_name varchar2) IS
1041: BEGIN
1042:
1043: IF (FIIDIM_Debug) THEN
1044: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.update_viewby_flag');
1045: END IF;
1046:
1047: -- For FC Dimension
1048: IF (p_dim_short_name = 'GL_FII_FIN_ITEM') THEN

Line 1125: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.update_viewby_flag');

1121:
1122: END IF;
1123:
1124: IF (FIIDIM_Debug) THEN
1125: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.update_viewby_flag');
1126: END IF;
1127:
1128: EXCEPTION
1129: When others then

Line 1153: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.Populate_PMV_Helper_GT');

1149:
1150: BEGIN
1151:
1152: IF (FIIDIM_Debug) THEN
1153: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.Populate_PMV_Helper_GT');
1154: END IF;
1155:
1156: l_nodes_aggregated := G_OPTIMUM_NODES;
1157:

Line 1581: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.Populate_PMV_Helper_GT');

1577:
1578: gain := G_OPTIMUM_NODES / l_nodes_aggregated ;
1579:
1580: IF (FIIDIM_Debug) THEN
1581: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.Populate_PMV_Helper_GT');
1582: END If;
1583:
1584: EXCEPTION
1585: When others then

Line 1604: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.truncate_helper_tables');

1600: PMVH_lock_err EXCEPTION;
1601: BEGIN
1602:
1603: IF (FIIDIM_Debug) THEN
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);

Line 1629: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.truncate_helper_tables');

1625: raise PMVH_lock_err;
1626: END IF;
1627:
1628: IF (FIIDIM_Debug) THEN
1629: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.truncate_helper_tables');
1630: END If;
1631:
1632: EXCEPTION
1633: WHEN PMVH_lock_err THEN

Line 1636: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.'||

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:
1640: WHEN OTHERS THEN

Line 1643: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.'||

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:
1647: END;

Line 1658: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.Dim_number_nodes');

1654: Procedure Dim_number_nodes IS
1655: BEGIN
1656:
1657: IF (FIIDIM_Debug) THEN
1658: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.Dim_number_nodes');
1659: END IF;
1660:
1661: -- First truncate all the helper tables.
1662: g_phase := 'Truncate all the helper tables';

Line 1753: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.Dim_number_nodes');

1749: p_tab(4).gain);
1750: End if;
1751:
1752: IF (FIIDIM_Debug) THEN
1753: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.Dim_number_nodes');
1754: END IF;
1755:
1756: EXCEPTION
1757: WHEN OTHERS THEN

Line 1775: FII_MESSAGE.Func_Ent(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');

1771:
1772: BEGIN
1773:
1774: IF (FIIDIM_Debug) THEN
1775: FII_MESSAGE.Func_Ent(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');
1776: END IF;
1777:
1778: g_phase := 'Set the Load mode';
1779: G_PROGRAM_MODE := p_load_mode;

Line 1825: FII_MESSAGE.Func_Succ(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');

1821:
1822: FND_CONCURRENT.Af_Commit;
1823:
1824: IF (FIIDIM_Debug) THEN
1825: FII_MESSAGE.Func_Succ(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');
1826: END IF;
1827:
1828: -- Exception handling
1829:

Line 1838: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');

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');
1839: retcode := sqlcode;
1840: ret_val := FND_CONCURRENT.Set_Completion_Status
1841: (status => 'ERROR', message => substr(sqlerrm,1,180));
1842:

Line 1849: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');

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');
1850: retcode := sqlcode;
1851: ret_val := FND_CONCURRENT.Set_Completion_Status
1852: (status => 'ERROR', message => substr(sqlerrm,1,180));
1853: