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.FEM_DIS_HIER_PKG dependencies on FEM_ENGINES_PKG

Line 99: FEM_ENGINES_PKG.Tech_Message(

95:
96: --
97: -- Print Dynamic SQL Elements for INSERT INTO _B table to Debug Log
98: --
99: FEM_ENGINES_PKG.Tech_Message(
100: p_severity => pc_log_level_statement,
101: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
102: p_msg_text => p_insert_b1
103: );

Line 105: FEM_ENGINES_PKG.Tech_Message(

101: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
102: p_msg_text => p_insert_b1
103: );
104:
105: FEM_ENGINES_PKG.Tech_Message(
106: p_severity => pc_log_level_statement,
107: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
108: p_msg_text => p_insert_b2
109: );

Line 111: FEM_ENGINES_PKG.Tech_Message(

107: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
108: p_msg_text => p_insert_b2
109: );
110:
111: FEM_ENGINES_PKG.Tech_Message(
112: p_severity => pc_log_level_statement,
113: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
114: p_msg_text => p_insert_b3
115: );

Line 118: FEM_ENGINES_PKG.Tech_Message(

114: p_msg_text => p_insert_b3
115: );
116:
117: IF p_insert_b4 IS NOT NULL THEN
118: FEM_ENGINES_PKG.Tech_Message(
119: p_severity => pc_log_level_statement,
120: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
121: p_msg_text => p_insert_b4
122: );

Line 125: FEM_ENGINES_PKG.Tech_Message(

121: p_msg_text => p_insert_b4
122: );
123: END IF;
124:
125: FEM_ENGINES_PKG.Tech_Message(
126: p_severity => pc_log_level_statement,
127: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
128: p_msg_text => p_insert_b5
129: );

Line 131: FEM_ENGINES_PKG.Tech_Message(

127: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
128: p_msg_text => p_insert_b5
129: );
130:
131: FEM_ENGINES_PKG.Tech_Message(
132: p_severity => pc_log_level_statement,
133: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
134: p_msg_text => p_insert_b6
135: );

Line 137: FEM_ENGINES_PKG.Tech_Message(

133: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
134: p_msg_text => p_insert_b6
135: );
136:
137: FEM_ENGINES_PKG.Tech_Message(
138: p_severity => pc_log_level_statement,
139: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
140: p_msg_text => p_insert_b7
141: );

Line 143: FEM_ENGINES_PKG.Tech_Message(

139: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
140: p_msg_text => p_insert_b7
141: );
142:
143: FEM_ENGINES_PKG.Tech_Message(
144: p_severity => pc_log_level_statement,
145: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
146: p_msg_text => p_insert_b8
147: );

Line 149: FEM_ENGINES_PKG.Tech_Message(

145: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
146: p_msg_text => p_insert_b8
147: );
148:
149: FEM_ENGINES_PKG.Tech_Message(
150: p_severity => pc_log_level_statement,
151: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
152: p_msg_text => p_insert_b9
153: );

Line 155: FEM_ENGINES_PKG.Tech_Message(

151: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
152: p_msg_text => p_insert_b9
153: );
154:
155: FEM_ENGINES_PKG.Tech_Message(
156: p_severity => pc_log_level_statement,
157: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
158: p_msg_text => p_insert_b10
159: );

Line 162: FEM_ENGINES_PKG.Tech_Message(

158: p_msg_text => p_insert_b10
159: );
160:
161: IF p_insert_b11 IS NOT NULL THEN
162: FEM_ENGINES_PKG.Tech_Message(
163: p_severity => pc_log_level_statement,
164: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
165: p_msg_text => p_insert_b11
166: );

Line 169: FEM_ENGINES_PKG.Tech_Message(

165: p_msg_text => p_insert_b11
166: );
167: END IF;
168:
169: FEM_ENGINES_PKG.Tech_Message(
170: p_severity => pc_log_level_statement,
171: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
172: p_msg_text => p_insert_b12
173: );

Line 175: FEM_ENGINES_PKG.Tech_Message(

171: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
172: p_msg_text => p_insert_b12
173: );
174:
175: FEM_ENGINES_PKG.Tech_Message(
176: p_severity => pc_log_level_statement,
177: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
178: p_msg_text => p_insert_b13
179: );

Line 181: FEM_ENGINES_PKG.Tech_Message(

177: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
178: p_msg_text => p_insert_b13
179: );
180:
181: FEM_ENGINES_PKG.Tech_Message(
182: p_severity => pc_log_level_statement,
183: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
184: p_msg_text => p_insert_b14
185: );

Line 186: FEM_ENGINES_PKG.Tech_Message(

182: p_severity => pc_log_level_statement,
183: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
184: p_msg_text => p_insert_b14
185: );
186: FEM_ENGINES_PKG.Tech_Message(
187: p_severity => pc_log_level_statement,
188: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_b,
189: p_msg_text => 'USING ' ||
190: p_using1 || ', ' ||

Line 243: FEM_ENGINES_PKG.Tech_Message(

239:
240: --
241: -- Print Dynamic SQL Elements for INSERT INTO _TL table to Debug Log
242: --
243: FEM_ENGINES_PKG.Tech_Message(
244: p_severity => pc_log_level_statement,
245: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
246: p_msg_text => p_insert_tl1
247: );

Line 249: FEM_ENGINES_PKG.Tech_Message(

245: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
246: p_msg_text => p_insert_tl1
247: );
248:
249: FEM_ENGINES_PKG.Tech_Message(
250: p_severity => pc_log_level_statement,
251: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
252: p_msg_text => p_insert_tl2
253: );

Line 255: FEM_ENGINES_PKG.Tech_Message(

251: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
252: p_msg_text => p_insert_tl2
253: );
254:
255: FEM_ENGINES_PKG.Tech_Message(
256: p_severity => pc_log_level_statement,
257: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
258: p_msg_text => p_insert_tl3
259: );

Line 261: FEM_ENGINES_PKG.Tech_Message(

257: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
258: p_msg_text => p_insert_tl3
259: );
260:
261: FEM_ENGINES_PKG.Tech_Message(
262: p_severity => pc_log_level_statement,
263: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
264: p_msg_text => p_insert_tl4
265: );

Line 267: FEM_ENGINES_PKG.Tech_Message(

263: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
264: p_msg_text => p_insert_tl4
265: );
266:
267: FEM_ENGINES_PKG.Tech_Message(
268: p_severity => pc_log_level_statement,
269: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
270: p_msg_text => p_insert_tl5
271: );

Line 273: FEM_ENGINES_PKG.Tech_Message(

269: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
270: p_msg_text => p_insert_tl5
271: );
272:
273: FEM_ENGINES_PKG.Tech_Message(
274: p_severity => pc_log_level_statement,
275: p_module => p_module || '.dsql_insert_into_' || p_dis_hierarchy_table_name_tl,
276: p_msg_text => 'USING ' ||
277: p_using1 || ', ' ||

Line 415: FEM_ENGINES_PKG.Tech_Message(

411:
412: v_module := v_module || '.' || LOWER(p_dimension_varchar_label);
413: v_func_name := v_func_name || '.' || p_dimension_varchar_label;
414:
415: FEM_ENGINES_PKG.Tech_Message(
416: p_severity => pc_log_level_procedure,
417: p_module => v_module || '.begin',
418: p_app_name => 'FEM',
419: p_msg_name => 'FEM_GL_POST_201',

Line 426: FEM_ENGINES_PKG.User_Message(

422: p_token2 => 'TIME',
423: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
424: );
425:
426: FEM_ENGINES_PKG.User_Message(
427: p_app_name => 'FEM',
428: p_msg_name => 'FEM_GL_POST_201',
429: p_token1 => 'FUNC_NAME',
430: p_value1 => v_func_name,

Line 797: FEM_ENGINES_PKG.Tech_Message(

793: )
794: SELECT
795: Q.*,';
796:
797: FEM_ENGINES_PKG.Tech_Message(
798: p_severity => pc_log_level_statement,
799: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
800: p_msg_text => 'v_insert_b_column_list_l='||LENGTH(v_insert_b_column_list)
801: );

Line 870: FEM_ENGINES_PKG.Tech_Message(

866: WHERE B.' || v_member_col || ' = Q.LEVEL10_ID ' ||
867: v_vs_where_display_code || '
868: ),';
869:
870: FEM_ENGINES_PKG.Tech_Message(
871: p_severity => pc_log_level_statement,
872: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
873: p_msg_text => 'v_insert_b_display_code1_l='||LENGTH(v_insert_b_display_code1)
874: );

Line 948: FEM_ENGINES_PKG.Tech_Message(

944: :pv_login_id LAST_UPDATE_LOGIN
945: FROM (
946: WITH'; -- Q
947:
948: FEM_ENGINES_PKG.Tech_Message(
949: p_severity => pc_log_level_statement,
950: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
951: p_msg_text => 'v_insert_b_display_code2_l='||LENGTH(v_insert_b_display_code2)
952: );

Line 1010: FEM_ENGINES_PKG.Tech_Message(

1006: v_attribute_where_orphan ||
1007: v_where_composite_only || '
1008: ),';
1009:
1010: FEM_ENGINES_PKG.Tech_Message(
1011: p_severity => pc_log_level_statement,
1012: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1013: p_msg_text => 'v_insert_b_with_o_l='||LENGTH(v_insert_b_with_o)
1014: );

Line 1084: FEM_ENGINES_PKG.Tech_Message(

1080: AND H4.PARENT_ID = R.L5
1081: AND H4.CHILD_ID = R.L6
1082: ) N6,';
1083:
1084: FEM_ENGINES_PKG.Tech_Message(
1085: p_severity => pc_log_level_statement,
1086: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1087: p_msg_text => 'v_insert_b_with_p1_l='||LENGTH(v_insert_b_with_p1)
1088: );

Line 1152: FEM_ENGINES_PKG.Tech_Message(

1148: AND H4.PARENT_ID = R.L12
1149: AND H4.CHILD_ID = R.L13
1150: ) N13,';
1151:
1152: FEM_ENGINES_PKG.Tech_Message(
1153: p_severity => pc_log_level_statement,
1154: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1155: p_msg_text => 'v_insert_b_with_p2_l='||LENGTH(v_insert_b_with_p2)
1156: );

Line 1221: FEM_ENGINES_PKG.Tech_Message(

1217: AND H4.CHILD_ID = R.L20
1218: ) N20
1219: FROM ('; -- R
1220:
1221: FEM_ENGINES_PKG.Tech_Message(
1222: p_severity => pc_log_level_statement,
1223: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1224: p_msg_text => 'v_insert_b_with_p3_l='||LENGTH(v_insert_b_with_p3)
1225: );

Line 1315: FEM_ENGINES_PKG.Tech_Message(

1311: INSTR(SYS_CONNECT_BY_PATH(H1.CHILD_ID, ''' || pc_delimiter || ''') || ''' || pc_delimiter || ''', ''' || pc_delimiter || ''', 1, 10)-' || pc_delimiter_length || '
1312: ) AS NUMBER
1313: ) L10,';
1314:
1315: FEM_ENGINES_PKG.Tech_Message(
1316: p_severity => pc_log_level_statement,
1317: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1318: p_msg_text => 'v_insert_b_subquery_r1_l='||LENGTH(v_insert_b_subquery_r1)
1319: );

Line 1406: FEM_ENGINES_PKG.Tech_Message(

1402: INSTR(SYS_CONNECT_BY_PATH(H1.CHILD_ID, ''' || pc_delimiter || ''') || ''' || pc_delimiter || ''', ''' || pc_delimiter || ''', 1, 20)-' || pc_delimiter_length || '
1403: ) AS NUMBER
1404: ) L20';
1405:
1406: FEM_ENGINES_PKG.Tech_Message(
1407: p_severity => pc_log_level_statement,
1408: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1409: p_msg_text => 'v_insert_b_subquery_r2_l='||LENGTH(v_insert_b_subquery_r2)
1410: );

Line 1447: FEM_ENGINES_PKG.Tech_Message(

1443: ((' || v_vs_where_root || 'H.PARENT_ID = H.CHILD_ID AND H.PARENT_DEPTH_NUM = 1) OR
1444: H.CHILD_DEPTH_NUM - H.PARENT_DEPTH_NUM = 1) ' ||
1445: v_where_composite_only;
1446:
1447: FEM_ENGINES_PKG.Tech_Message(
1448: p_severity => pc_log_level_statement,
1449: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1450: p_msg_text => 'v_insert_b_subquery_h11_l='||LENGTH(v_insert_b_subquery_h11)
1451: );

Line 1477: FEM_ENGINES_PKG.Tech_Message(

1473: ((' || v_vs_where_root_o || 'H1.PARENT_ID = H1.CHILD_ID AND H1.PARENT_DEPTH_NUM = 1) OR
1474: H1.CHILD_DEPTH_NUM - H1.PARENT_DEPTH_NUM = 1) ' ||
1475: v_where_composite_only;
1476:
1477: FEM_ENGINES_PKG.Tech_Message(
1478: p_severity => pc_log_level_statement,
1479: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1480: p_msg_text => 'v_insert_b_subquery_h11_o_l='||LENGTH(v_insert_b_subquery_h11_o)
1481: );

Line 1518: FEM_ENGINES_PKG.Tech_Message(

1514: v_vs_column_child_union3 || '
1515: O.MEMBER_ID CHILD_ID
1516: FROM O';
1517:
1518: FEM_ENGINES_PKG.Tech_Message(
1519: p_severity => pc_log_level_statement,
1520: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1521: p_msg_text => 'v_insert_b_subquery_h12_l='||LENGTH(v_insert_b_subquery_h12)
1522: );

Line 1569: FEM_ENGINES_PKG.Tech_Message(

1565: H1.PARENT_ID = PRIOR H1.CHILD_ID
1566: ) R
1567: )'; -- P
1568:
1569: FEM_ENGINES_PKG.Tech_Message(
1570: p_severity => pc_log_level_statement,
1571: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1572: p_msg_text => 'v_insert_b_exclude_nonleaf_l='||LENGTH(v_insert_b_exclude_nonleaf)
1573: );

Line 1617: FEM_ENGINES_PKG.Tech_Message(

1613: AND H1.SINGLE_DEPTH_FLAG = ''Y'' AND H1.CHILD_DEPTH_NUM <> 1
1614: ) R
1615: )'; -- P
1616:
1617: FEM_ENGINES_PKG.Tech_Message(
1618: p_severity => pc_log_level_statement,
1619: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1620: p_msg_text => 'v_insert_b_exclude_nonleaf_o_l='||LENGTH(v_insert_b_exclude_nonleaf_o)
1621: );

Line 1653: FEM_ENGINES_PKG.Tech_Message(

1649: COALESCE(P.L18,P.L17,P.L16,P.L15,P.L14,P.L13,P.L12,P.L11,P.L10,P.L9,P.L8,P.L7,P.L6,P.L5,P.L4,P.L3,P.L2,P.L1) LEVEL18_ID,
1650: COALESCE(P.L19,P.L18,P.L17,P.L16,P.L15,P.L14,P.L13,P.L12,P.L11,P.L10,P.L9,P.L8,P.L7,P.L6,P.L5,P.L4,P.L3,P.L2,P.L1) LEVEL19_ID,
1651: COALESCE(P.L20,P.L19,P.L18,P.L17,P.L16,P.L15,P.L14,P.L13,P.L12,P.L11,P.L10,P.L9,P.L8,P.L7,P.L6,P.L5,P.L4,P.L3,P.L2,P.L1) LEVEL20_ID,';
1652:
1653: FEM_ENGINES_PKG.Tech_Message(
1654: p_severity => pc_log_level_statement,
1655: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1656: p_msg_text => 'v_insert_b_subquery_q1_l='||LENGTH(v_insert_b_subquery_q1)
1657: );

Line 1696: FEM_ENGINES_PKG.Tech_Message(

1692: D.OBJECT_ID = H.HIERARCHY_OBJ_ID AND
1693: C.OBJECT_ID = D.OBJECT_ID
1694: ) Q';
1695:
1696: FEM_ENGINES_PKG.Tech_Message(
1697: p_severity => pc_log_level_statement,
1698: p_module => v_module || '.length_insert_into_' || v_dis_hierarchy_table_name_b,
1699: p_msg_text => 'v_insert_b_subquery_q2_l='||LENGTH(v_insert_b_subquery_q2)
1700: );

Line 2148: FEM_ENGINES_PKG.Tech_Message(

2144: *************************************************************************/
2145: --
2146: -- Execute Dynamic SQL for DELETE FROM _B table
2147: --
2148: FEM_ENGINES_PKG.Tech_Message(
2149: p_severity => pc_log_level_statement,
2150: p_module => v_module || '.delete_from_b',
2151: p_msg_text => 'Deleting from _B table'
2152: );

Line 2163: FEM_ENGINES_PKG.Tech_Message(

2159: --
2160: -- Execute Dynamic SQL for INSERT INTO _B table
2161: --
2162: -- Open hierarchy type
2163: FEM_ENGINES_PKG.Tech_Message(
2164: p_severity => pc_log_level_statement,
2165: p_module => v_module || '.insert_into_b_open_attr_enabled_dim',
2166: p_msg_text => 'Inserting into _B table for Open hierarchy (attribute enabled dimension)'
2167: );

Line 2229: FEM_ENGINES_PKG.Tech_Message(

2225:
2226: IF v_attribute_table_name IS NOT NULL THEN
2227:
2228: -- Reconciliation hierarchy type
2229: FEM_ENGINES_PKG.Tech_Message(
2230: p_severity => pc_log_level_statement,
2231: p_module => v_module || '.insert_into_b_recon_attr_enabled_dim',
2232: p_msg_text => 'Inserting into _B table for Reconciliation hierarchy (attribute enabled dimension)'
2233: );

Line 2296: FEM_ENGINES_PKG.Tech_Message(

2292:
2293: ELSE -- IF v_attribute_table_name IS NOT NULL THEN
2294:
2295: -- Reconciliation hierarchy type
2296: FEM_ENGINES_PKG.Tech_Message(
2297: p_severity => pc_log_level_statement,
2298: p_module => v_module || '.insert_into_b_recon_attr_disabled_dim',
2299: p_msg_text => 'Inserting into _B table for Reconciliation hierarchy (attribute disabled dimension)'
2300: );

Line 2372: FEM_ENGINES_PKG.Tech_Message(

2368:
2369: --
2370: -- Execute Dynamic SQL for DELETE FROM _TL table
2371: --
2372: FEM_ENGINES_PKG.Tech_Message(
2373: p_severity => pc_log_level_statement,
2374: p_module => v_module || '.delete_from_tl',
2375: p_msg_text => 'Deleting from _TL table'
2376: );

Line 2386: FEM_ENGINES_PKG.Tech_Message(

2382:
2383: --
2384: -- Execute Dynamic SQL for INSERT INTO _TL table
2385: --
2386: FEM_ENGINES_PKG.Tech_Message(
2387: p_severity => pc_log_level_statement,
2388: p_module => v_module || '.delete_from_tl',
2389: p_msg_text => 'Inserting into _TL table'
2390: );

Line 2451: FEM_ENGINES_PKG.Tech_Message(

2447:
2448: v_multi_vs_num := SQL%ROWCOUNT;
2449:
2450: IF v_multi_vs_num > 0 THEN
2451: FEM_ENGINES_PKG.Tech_Message(
2452: p_severity => pc_log_level_statement,
2453: p_module => v_module || '.multi_vs',
2454: p_app_name => 'FEM',
2455: p_msg_name => 'FEM_DIS_HIER_MULTI_VALUE_SETS',

Line 2460: FEM_ENGINES_PKG.User_Message(

2456: p_token1 => 'DIMENSION',
2457: p_value1 => v_dimension_name
2458: );
2459:
2460: FEM_ENGINES_PKG.User_Message(
2461: p_app_name => 'FEM',
2462: p_msg_name => 'FEM_DIS_HIER_MULTI_VALUE_SETS',
2463: p_token1 => 'DIMENSION',
2464: p_value1 => v_dimension_name

Line 2468: FEM_ENGINES_PKG.Tech_Message(

2464: p_value1 => v_dimension_name
2465: );
2466:
2467: FOR i IN 1..v_multi_vs_num LOOP
2468: FEM_ENGINES_PKG.Tech_Message(
2469: p_severity => pc_log_level_statement,
2470: p_module => v_module || '.multi_vs',
2471: p_msg_text => ' ' ||
2472: v_object_name_array(i) || '(' ||

Line 2476: FEM_ENGINES_PKG.User_Message(

2472: v_object_name_array(i) || '(' ||
2473: v_object_id_array(i) || ')'
2474: );
2475:
2476: FEM_ENGINES_PKG.User_Message(
2477: p_msg_text => ' ' ||
2478: v_object_name_array(i) || '(' ||
2479: v_object_id_array(i) || ')'
2480: );

Line 2485: FEM_ENGINES_PKG.Tech_Message(

2481: END LOOP;
2482:
2483: END IF;
2484:
2485: FEM_ENGINES_PKG.Tech_Message(
2486: p_severity => pc_log_level_statement,
2487: p_module => v_module || '.rowcount',
2488: p_msg_text => 'v_deleted_b=' || v_deleted_b || ', ' ||
2489: 'v_inserted_b1=' || v_inserted_b1 || ', ' ||

Line 2495: FEM_ENGINES_PKG.Tech_Message(

2491: 'v_deleted_tl=' || v_deleted_tl || ', ' ||
2492: 'v_inserted_tl=' || v_inserted_tl
2493: );
2494:
2495: FEM_ENGINES_PKG.Tech_Message(
2496: p_severity => pc_log_level_procedure,
2497: p_module => v_module || '.end',
2498: p_app_name => 'FEM',
2499: p_msg_name => 'FEM_GL_POST_202',

Line 2506: FEM_ENGINES_PKG.User_Message(

2502: p_token2 => 'TIME',
2503: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2504: );
2505:
2506: FEM_ENGINES_PKG.User_Message(
2507: p_app_name => 'FEM',
2508: p_msg_name => 'FEM_GL_POST_202',
2509: p_token1 => 'FUNC_NAME',
2510: p_value1 => v_func_name,

Line 2521: FEM_ENGINES_PKG.Tech_Message(

2517: EXCEPTION
2518: WHEN OTHERS THEN
2519: ROLLBACK;
2520:
2521: FEM_ENGINES_PKG.Tech_Message(
2522: p_severity => pc_log_level_exception,
2523: p_module => v_module || '.others',
2524: p_app_name => 'FEM',
2525: p_msg_name => 'FEM_GL_POST_215',

Line 2530: FEM_ENGINES_PKG.User_Message(

2526: p_token1 => 'ERR_MSG',
2527: p_value1 => SQLERRM
2528: );
2529:
2530: FEM_ENGINES_PKG.User_Message(
2531: p_app_name => 'FEM',
2532: p_msg_name => 'FEM_GL_POST_215',
2533: p_token1 => 'ERR_MSG',
2534: p_value1 => SQLERRM

Line 2559: FEM_ENGINES_PKG.Tech_Message(

2555: v_insert_tl_name2_l := LENGTH(v_insert_tl_name2);
2556: v_insert_tl_description1_l := LENGTH(v_insert_tl_description1);
2557: v_insert_tl_description2_l := LENGTH(v_insert_tl_description2);
2558:
2559: FEM_ENGINES_PKG.Tech_Message(
2560: p_severity => pc_log_level_exception,
2561: p_module => v_module || '.others',
2562: p_msg_text => 'v_insert_b_column_list_l='|| v_insert_b_column_list_l || ', ' ||
2563: 'v_insert_b_display_code1_l='|| v_insert_b_display_code1_l || ', ' ||

Line 2585: FEM_ENGINES_PKG.Tech_Message(

2581: 'v_insert_tl_description2_l=' ||v_insert_tl_description2_l
2582: );
2583:
2584:
2585: FEM_ENGINES_PKG.Tech_Message(
2586: p_severity => pc_log_level_exception,
2587: p_module => v_module || '.others',
2588: p_app_name => 'FEM',
2589: p_msg_name => 'FEM_GL_POST_203',

Line 2596: FEM_ENGINES_PKG.User_Message(

2592: p_token2 => 'TIME',
2593: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2594: );
2595:
2596: FEM_ENGINES_PKG.User_Message(
2597: p_app_name => 'FEM',
2598: p_msg_name => 'FEM_GL_POST_203',
2599: p_token1 => 'FUNC_NAME',
2600: p_value1 => v_func_name,

Line 2672: FEM_ENGINES_PKG.Tech_Message(

2668: HIER_TRANS_CHILD_SUB_FAILED EXCEPTION;
2669:
2670: BEGIN
2671:
2672: FEM_ENGINES_PKG.Tech_Message(
2673: p_severity => pc_log_level_procedure,
2674: p_module => v_module || '.begin',
2675: p_app_name => 'FEM',
2676: p_msg_name => 'FEM_GL_POST_201',

Line 2683: FEM_ENGINES_PKG.User_Message(

2679: p_token2 => 'TIME',
2680: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2681: );
2682:
2683: FEM_ENGINES_PKG.User_Message(
2684: p_app_name => 'FEM',
2685: p_msg_name => 'FEM_GL_POST_201',
2686: p_token1 => 'FUNC_NAME',
2687: p_value1 => v_func_name,

Line 2781: FEM_ENGINES_PKG.User_Message(

2777: RAISE HIER_TRANS_CHILD_SUB_FAILED;
2778:
2779: ELSE
2780:
2781: FEM_ENGINES_PKG.User_Message(
2782: p_app_name => 'FEM',
2783: p_msg_name => 'FEM_DIS_HIER_REQ_SUB_SUCCESS',
2784: p_token1 => 'DIMENSION',
2785: p_value1 => v_dis_dims(i).dimension_name,

Line 2790: FEM_ENGINES_PKG.Tech_Message(

2786: p_token2 => 'REQ_ID',
2787: p_value2 => TO_CHAR(v_child_request_id)
2788: );
2789:
2790: FEM_ENGINES_PKG.Tech_Message(
2791: p_severity => pc_log_level_statement,
2792: p_module => v_module || '.child_req_submission',
2793: p_app_name => 'FEM',
2794: p_msg_name => 'FEM_DIS_HIER_REQ_SUB_SUCCESS',

Line 2847: FEM_ENGINES_PKG.Tech_Message(

2843: ELSIF v_dev_status <> 'NORMAL' THEN
2844: v_errors := v_errors + 1;
2845: END IF;
2846:
2847: FEM_ENGINES_PKG.Tech_Message(
2848: p_severity => pc_log_level_statement,
2849: p_module => v_module || 'child_req_status',
2850: p_app_name => 'FEM',
2851: p_msg_name => 'FEM_DIS_HIER_REQ_STATUS',

Line 2860: FEM_ENGINES_PKG.User_Message(

2856: p_token3 => 'STATUS',
2857: p_value3 => v_status
2858: );
2859:
2860: FEM_ENGINES_PKG.User_Message(
2861: p_app_name => 'FEM',
2862: p_msg_name => 'FEM_DIS_HIER_REQ_STATUS',
2863: p_token1 => 'DIMENSION',
2864: p_value1 => v_child_requests(i).description,

Line 2897: FEM_ENGINES_PKG.Tech_Message(

2893: --
2894: IF v_completion_status = 'NORMAL' THEN
2895: x_retcode := '0';
2896:
2897: FEM_ENGINES_PKG.Tech_Message(
2898: p_severity => pc_log_level_procedure,
2899: p_module => v_module || '.end',
2900: p_app_name => 'FEM',
2901: p_msg_name => 'FEM_GL_POST_202',

Line 2908: FEM_ENGINES_PKG.User_Message(

2904: p_token2 => 'TIME',
2905: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2906: );
2907:
2908: FEM_ENGINES_PKG.User_Message(
2909: p_app_name => 'FEM',
2910: p_msg_name => 'FEM_GL_POST_202',
2911: p_token1 => 'FUNC_NAME',
2912: p_value1 => v_func_name,

Line 2920: FEM_ENGINES_PKG.Tech_Message(

2916:
2917: ELSIF v_completion_status = 'WARNING' THEN
2918: x_retcode := '1';
2919:
2920: FEM_ENGINES_PKG.Tech_Message(
2921: p_severity => pc_log_level_procedure,
2922: p_module => v_module || '.end',
2923: p_app_name => 'FEM',
2924: p_msg_name => 'FEM_GL_POST_206'

Line 2927: FEM_ENGINES_PKG.User_Message(

2923: p_app_name => 'FEM',
2924: p_msg_name => 'FEM_GL_POST_206'
2925: );
2926:
2927: FEM_ENGINES_PKG.User_Message(
2928: p_app_name => 'FEM',
2929: p_msg_name => 'FEM_GL_POST_206'
2930: );
2931:

Line 2935: FEM_ENGINES_PKG.Tech_Message(

2931:
2932: ELSE
2933: x_retcode := '2';
2934:
2935: FEM_ENGINES_PKG.Tech_Message(
2936: p_severity => pc_log_level_procedure,
2937: p_module => v_module || '.end',
2938: p_app_name => 'FEM',
2939: p_msg_name => 'FEM_GL_POST_203',

Line 2946: FEM_ENGINES_PKG.User_Message(

2942: p_token2 => 'TIME',
2943: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2944: );
2945:
2946: FEM_ENGINES_PKG.User_Message(
2947: p_app_name => 'FEM',
2948: p_msg_name => 'FEM_GL_POST_203',
2949: p_token1 => 'FUNC_NAME',
2950: p_value1 => v_func_name,

Line 2963: FEM_ENGINES_PKG.Tech_Message(

2959: ROLLBACK;
2960:
2961: x_retcode := '2';
2962:
2963: FEM_ENGINES_PKG.Tech_Message(
2964: p_severity => pc_log_level_exception,
2965: p_module => v_module || '.invalid_dimension',
2966: p_app_name => 'FEM',
2967: p_msg_name => 'FEM_DIS_HIER_INVALID_DIMENSION',

Line 2972: FEM_ENGINES_PKG.User_Message(

2968: p_token1 => 'DIMENSION',
2969: p_value1 => p_dimension_varchar_label
2970: );
2971:
2972: FEM_ENGINES_PKG.User_Message(
2973: p_app_name => 'FEM',
2974: p_msg_name => 'FEM_DIS_HIER_INVALID_DIMENSION',
2975: p_token1 => 'DIMENSION',
2976: p_value1 => p_dimension_varchar_label

Line 2979: FEM_ENGINES_PKG.Tech_Message(

2975: p_token1 => 'DIMENSION',
2976: p_value1 => p_dimension_varchar_label
2977: );
2978:
2979: FEM_ENGINES_PKG.Tech_Message(
2980: p_severity => pc_log_level_exception,
2981: p_module => v_module || '.invalid_dimension',
2982: p_app_name => 'FEM',
2983: p_msg_name => 'FEM_GL_POST_203',

Line 2990: FEM_ENGINES_PKG.User_Message(

2986: p_token2 => 'TIME',
2987: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2988: );
2989:
2990: FEM_ENGINES_PKG.User_Message(
2991: p_app_name => 'FEM',
2992: p_msg_name => 'FEM_GL_POST_203',
2993: p_token1 => 'FUNC_NAME',
2994: p_value1 => v_func_name,

Line 3004: FEM_ENGINES_PKG.Tech_Message(

3000: ROLLBACK;
3001:
3002: x_retcode := '2';
3003:
3004: FEM_ENGINES_PKG.Tech_Message(
3005: p_severity => pc_log_level_exception,
3006: p_module => v_module || '.sub_failed',
3007: p_app_name => 'FEM',
3008: p_msg_name => 'FEM_DIS_HIER_REQ_SUB_FAILURE',

Line 3013: FEM_ENGINES_PKG.User_Message(

3009: p_token1 => 'DIMENSION',
3010: p_value1 => v_dimension_name
3011: );
3012:
3013: FEM_ENGINES_PKG.User_Message(
3014: p_app_name => 'FEM',
3015: p_msg_name => 'FEM_DIS_HIER_REQ_SUB_FAILURE',
3016: p_token1 => 'DIMENSION',
3017: p_value1 => v_dimension_name

Line 3020: FEM_ENGINES_PKG.Tech_Message(

3016: p_token1 => 'DIMENSION',
3017: p_value1 => v_dimension_name
3018: );
3019:
3020: FEM_ENGINES_PKG.Tech_Message(
3021: p_severity => pc_log_level_exception,
3022: p_module => v_module || '.sub_failed',
3023: p_app_name => 'FEM',
3024: p_msg_name => 'FEM_GL_POST_203',

Line 3031: FEM_ENGINES_PKG.User_Message(

3027: p_token2 => 'TIME',
3028: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
3029: );
3030:
3031: FEM_ENGINES_PKG.User_Message(
3032: p_app_name => 'FEM',
3033: p_msg_name => 'FEM_GL_POST_203',
3034: p_token1 => 'FUNC_NAME',
3035: p_value1 => v_func_name,

Line 3045: FEM_ENGINES_PKG.Tech_Message(

3041: ROLLBACK;
3042:
3043: x_retcode := '2';
3044:
3045: FEM_ENGINES_PKG.Tech_Message(
3046: p_severity => pc_log_level_exception,
3047: p_module => v_module || '.others',
3048: p_app_name => 'FEM',
3049: p_msg_name => 'FEM_GL_POST_215',

Line 3054: FEM_ENGINES_PKG.User_Message(

3050: p_token1 => 'ERR_MSG',
3051: p_value1 => SQLERRM
3052: );
3053:
3054: FEM_ENGINES_PKG.User_Message(
3055: p_app_name => 'FEM',
3056: p_msg_name => 'FEM_GL_POST_215',
3057: p_token1 => 'ERR_MSG',
3058: p_value1 => SQLERRM

Line 3061: FEM_ENGINES_PKG.Tech_Message(

3057: p_token1 => 'ERR_MSG',
3058: p_value1 => SQLERRM
3059: );
3060:
3061: FEM_ENGINES_PKG.Tech_Message(
3062: p_severity => pc_log_level_exception,
3063: p_module => v_module || '.others',
3064: p_app_name => 'FEM',
3065: p_msg_name => 'FEM_GL_POST_203',

Line 3072: FEM_ENGINES_PKG.User_Message(

3068: p_token2 => 'TIME',
3069: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
3070: );
3071:
3072: FEM_ENGINES_PKG.User_Message(
3073: p_app_name => 'FEM',
3074: p_msg_name => 'FEM_GL_POST_203',
3075: p_token1 => 'FUNC_NAME',
3076: p_value1 => v_func_name,