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_DATA_LOADER_PKG dependencies on FEM_ENGINES_PKG

Line 103: fem_engines_pkg.tech_message (p_severity => g_log_level_2

99: l_dummy VARCHAR2(10);
100: BEGIN
101: fnd_log_repository.init;
102:
103: fem_engines_pkg.tech_message (p_severity => g_log_level_2
104: ,p_module => g_block||'.process_request(PROCEDURE)'
105: ,p_msg_text => 'BEGIN..for process_request');
106:
107: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 107: fem_engines_pkg.tech_message (p_severity => g_log_level_1

103: fem_engines_pkg.tech_message (p_severity => g_log_level_2
104: ,p_module => g_block||'.process_request(PROCEDURE)'
105: ,p_msg_text => 'BEGIN..for process_request');
106:
107: fem_engines_pkg.tech_message (p_severity => g_log_level_1
108: ,p_module => g_block||'.process_request(PARAMETERS)'
109: ,p_msg_text => 'p_obj_def_id :: ' || p_obj_def_id);
110:
111:

Line 112: fem_engines_pkg.tech_message (p_severity => g_log_level_1

108: ,p_module => g_block||'.process_request(PARAMETERS)'
109: ,p_msg_text => 'p_obj_def_id :: ' || p_obj_def_id);
110:
111:
112: fem_engines_pkg.tech_message (p_severity => g_log_level_1
113: ,p_module => g_block||'.process_request(PARAMETERS)'
114: ,p_msg_text => 'p_start_date :: ' || p_start_date);
115:
116:

Line 117: fem_engines_pkg.tech_message (p_severity => g_log_level_1

113: ,p_module => g_block||'.process_request(PARAMETERS)'
114: ,p_msg_text => 'p_start_date :: ' || p_start_date);
115:
116:
117: fem_engines_pkg.tech_message (p_severity => g_log_level_1
118: ,p_module => g_block||'.process_request(PARAMETERS)'
119: ,p_msg_text => 'p_end_date :: ' || p_end_date);
120:
121:

Line 122: fem_engines_pkg.tech_message (p_severity => g_log_level_1

118: ,p_module => g_block||'.process_request(PARAMETERS)'
119: ,p_msg_text => 'p_end_date :: ' || p_end_date);
120:
121:
122: fem_engines_pkg.tech_message (p_severity => g_log_level_1
123: ,p_module => g_block||'.process_request(PARAMETERS)'
124: ,p_msg_text => 'p_balance_type :: ' || p_balance_type);
125:
126: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 126: fem_engines_pkg.tech_message (p_severity => g_log_level_1

122: fem_engines_pkg.tech_message (p_severity => g_log_level_1
123: ,p_module => g_block||'.process_request(PARAMETERS)'
124: ,p_msg_text => 'p_balance_type :: ' || p_balance_type);
125:
126: fem_engines_pkg.tech_message (p_severity => g_log_level_1
127: ,p_module => g_block||'.process_request(PROCEDURE)'
128: ,p_msg_text => 'Calling get_parameters');
129:
130: -- DBMS_SESSION.SET_SQL_TRACE (sql_trace => FALSE);

Line 138: fem_engines_pkg.tech_message (p_severity => g_log_level_1

134: -- FROM dual;
135:
136: get_parameters(p_obj_def_id);
137:
138: fem_engines_pkg.tech_message (p_severity => g_log_level_1
139: ,p_module => g_block||'.process_request(PROCEDURE)'
140: ,p_msg_text => 'Completed get_parameters');
141:
142:

Line 148: fem_engines_pkg.tech_message (p_severity => g_log_level_1

144: g_end_date := p_end_date;
145:
146: fnd_msg_pub.initialize;
147:
148: fem_engines_pkg.tech_message (p_severity => g_log_level_1
149: ,p_module => g_block||'.process_request(PROCEDURE)'
150: ,p_msg_text => 'Calling process_global_id');
151:
152: process_global_id;

Line 154: fem_engines_pkg.tech_message (p_severity => g_log_level_1

150: ,p_msg_text => 'Calling process_global_id');
151:
152: process_global_id;
153:
154: fem_engines_pkg.tech_message (p_severity => g_log_level_1
155: ,p_module => g_block||'.process_request(PROCEDURE)'
156: ,p_msg_text => 'Completed process_global_id');
157:
158:

Line 164: fem_engines_pkg.tech_message (p_severity => g_log_level_1

160: DELETE fem_ld_dim_requests_gt;
161: DELETE fem_ld_hier_requests_gt;
162: DELETE fem_ld_cal_periods_gt;
163:
164: fem_engines_pkg.tech_message (p_severity => g_log_level_1
165: ,p_module => g_block||'.process_request(PROCEDURE)'
166: ,p_msg_text => 'Completed deleting the object tables');
167:
168: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 168: fem_engines_pkg.tech_message (p_severity => g_log_level_1

164: fem_engines_pkg.tech_message (p_severity => g_log_level_1
165: ,p_module => g_block||'.process_request(PROCEDURE)'
166: ,p_msg_text => 'Completed deleting the object tables');
167:
168: fem_engines_pkg.tech_message (p_severity => g_log_level_1
169: ,p_module => g_block||'.process_request(PROCEDURE)'
170: ,p_msg_text => 'Calling build_dim_stages');
171:
172:

Line 175: fem_engines_pkg.tech_message (p_severity => g_log_level_1

171:
172:
173: build_dim_stages;
174:
175: fem_engines_pkg.tech_message (p_severity => g_log_level_1
176: ,p_module => g_block||'.process_request(PROCEDURE)'
177: ,p_msg_text => 'Completed build_dim_stages');
178:
179: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 179: fem_engines_pkg.tech_message (p_severity => g_log_level_1

175: fem_engines_pkg.tech_message (p_severity => g_log_level_1
176: ,p_module => g_block||'.process_request(PROCEDURE)'
177: ,p_msg_text => 'Completed build_dim_stages');
178:
179: fem_engines_pkg.tech_message (p_severity => g_log_level_1
180: ,p_module => g_block||'.process_request(PROCEDURE)'
181: ,p_msg_text => 'Calling evaluate_parameters');
182:
183:

Line 186: fem_engines_pkg.tech_message (p_severity => g_log_level_1

182:
183:
184: evaluate_parameters;
185:
186: fem_engines_pkg.tech_message (p_severity => g_log_level_1
187: ,p_module => g_block||'.process_request(PROCEDURE)'
188: ,p_msg_text => 'Completed evaluate_parameters');
189:
190:

Line 193: fem_engines_pkg.tech_message (p_severity => g_log_level_1

189:
190:
191: IF g_loader_run AND g_evaluate_parameters THEN
192:
193: fem_engines_pkg.tech_message (p_severity => g_log_level_1
194: ,p_module => g_block||'.process_request(PROCEDURE)'
195: ,p_msg_text => 'Calling populate_cal_periods');
196:
197:

Line 200: fem_engines_pkg.tech_message (p_severity => g_log_level_1

196:
197:
198: populate_cal_periods;
199:
200: fem_engines_pkg.tech_message (p_severity => g_log_level_1
201: ,p_module => g_block||'.process_request(PROCEDURE)'
202: ,p_msg_text => 'Completed populate_cal_periods');
203:
204: print_params;

Line 209: fem_engines_pkg.tech_message (p_severity => g_log_level_1

205:
206: IF g_evaluate_parameters THEN
207:
208: IF g_loader_type = 'LEDGER' THEN
209: fem_engines_pkg.tech_message (p_severity => g_log_level_1
210: ,p_module => g_block||'.process_request(PROCEDURE)'
211: ,p_msg_text => 'Calling populate_master_table_lldr');
212:
213: populate_master_table_lldr;

Line 215: fem_engines_pkg.tech_message (p_severity => g_log_level_1

211: ,p_msg_text => 'Calling populate_master_table_lldr');
212:
213: populate_master_table_lldr;
214:
215: fem_engines_pkg.tech_message (p_severity => g_log_level_1
216: ,p_module => g_block||'.process_request(PROCEDURE)'
217: ,p_msg_text => 'Completed populate_master_table_lldr');
218:
219: ELSE

Line 220: fem_engines_pkg.tech_message (p_severity => g_log_level_1

216: ,p_module => g_block||'.process_request(PROCEDURE)'
217: ,p_msg_text => 'Completed populate_master_table_lldr');
218:
219: ELSE
220: fem_engines_pkg.tech_message (p_severity => g_log_level_1
221: ,p_module => g_block||'.process_request(PROCEDURE)'
222: ,p_msg_text => 'Calling populate_master_table_dldr');
223:
224: populate_master_table_dldr;

Line 226: fem_engines_pkg.tech_message (p_severity => g_log_level_1

222: ,p_msg_text => 'Calling populate_master_table_dldr');
223:
224: populate_master_table_dldr;
225:
226: fem_engines_pkg.tech_message (p_severity => g_log_level_1
227: ,p_module => g_block||'.process_request(PROCEDURE)'
228: ,p_msg_text => 'Completed populate_master_table_dldr');
229:
230: END IF;

Line 238: fem_engines_pkg.tech_message (p_severity => g_log_level_1

234: g_user_id := fnd_global.user_id;
235: g_login_id := fnd_global.login_id;
236:
237: IF g_loader_type = 'LEDGER' THEN
238: fem_engines_pkg.tech_message (p_severity => g_log_level_1
239: ,p_module => g_block||'.process_request(PROCEDURE)'
240: ,p_msg_text => 'Calling submit_ledger_loader');
241:
242: submit_ledger_loader(p_balance_type);

Line 244: fem_engines_pkg.tech_message (p_severity => g_log_level_1

240: ,p_msg_text => 'Calling submit_ledger_loader');
241:
242: submit_ledger_loader(p_balance_type);
243:
244: fem_engines_pkg.tech_message (p_severity => g_log_level_1
245: ,p_module => g_block||'.process_request(PROCEDURE)'
246: ,p_msg_text => 'Completed submit_ledger_loader');
247: ELSE
248:

Line 249: fem_engines_pkg.tech_message (p_severity => g_log_level_1

245: ,p_module => g_block||'.process_request(PROCEDURE)'
246: ,p_msg_text => 'Completed submit_ledger_loader');
247: ELSE
248:
249: fem_engines_pkg.tech_message (p_severity => g_log_level_1
250: ,p_module => g_block||'.process_request(PROCEDURE)'
251: ,p_msg_text => 'Calling submit_data_loaders');
252:
253: submit_data_loaders;

Line 255: fem_engines_pkg.tech_message (p_severity => g_log_level_1

251: ,p_msg_text => 'Calling submit_data_loaders');
252:
253: submit_data_loaders;
254:
255: fem_engines_pkg.tech_message (p_severity => g_log_level_1
256: ,p_module => g_block||'.process_request(PROCEDURE)'
257: ,p_msg_text => 'Completed submit_data_loaders');
258: END IF;
259: ELSE

Line 260: fem_engines_pkg.tech_message (p_severity => g_log_level_1

256: ,p_module => g_block||'.process_request(PROCEDURE)'
257: ,p_msg_text => 'Completed submit_data_loaders');
258: END IF;
259: ELSE
260: fem_engines_pkg.tech_message (p_severity => g_log_level_1
261: ,p_module => g_block||'.process_request(PROCEDURE)'
262: ,p_msg_text => 'Nothing to process - will not submit the loader CP');
263: END IF;
264:

Line 276: fem_engines_pkg.tech_message (p_severity => g_log_level_1

272: NULL;
273: END IF; -- g_loader_run and g_evaluate_parameters
274:
275: IF g_hierarchy_exists THEN
276: fem_engines_pkg.tech_message (p_severity => g_log_level_1
277: ,p_module => g_block||'.process_request(PROCEDURE)'
278: ,p_msg_text => 'Calling submit_hierarchy_loaders');
279:
280: submit_hierarchy_loaders;

Line 282: fem_engines_pkg.tech_message (p_severity => g_log_level_1

278: ,p_msg_text => 'Calling submit_hierarchy_loaders');
279:
280: submit_hierarchy_loaders;
281:
282: fem_engines_pkg.tech_message (p_severity => g_log_level_1
283: ,p_module => g_block||'.process_request(PROCEDURE)'
284: ,p_msg_text => 'Completed submit_hierarchy_loaders');
285:
286: END IF;

Line 288: fem_engines_pkg.tech_message (p_severity => g_log_level_1

284: ,p_msg_text => 'Completed submit_hierarchy_loaders');
285:
286: END IF;
287:
288: fem_engines_pkg.tech_message (p_severity => g_log_level_1
289: ,p_module => g_block||'.process_request(PROCEDURE)'
290: ,p_msg_text => 'Calling populate_log');
291:
292:

Line 295: fem_engines_pkg.tech_message (p_severity => g_log_level_1

291:
292:
293: populate_log;
294:
295: fem_engines_pkg.tech_message (p_severity => g_log_level_1
296: ,p_module => g_block||'.process_request(PROCEDURE)'
297: ,p_msg_text => 'Completed populate_log');
298:
299: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 299: fem_engines_pkg.tech_message (p_severity => g_log_level_1

295: fem_engines_pkg.tech_message (p_severity => g_log_level_1
296: ,p_module => g_block||'.process_request(PROCEDURE)'
297: ,p_msg_text => 'Completed populate_log');
298:
299: fem_engines_pkg.tech_message (p_severity => g_log_level_1
300: ,p_module => g_block||'.process_request(PROCEDURE)'
301: ,p_msg_text => 'Calling cleanup');
302:
303: cleanup;

Line 305: fem_engines_pkg.tech_message (p_severity => g_log_level_1

301: ,p_msg_text => 'Calling cleanup');
302:
303: cleanup;
304:
305: fem_engines_pkg.tech_message (p_severity => g_log_level_1
306: ,p_module => g_block||'.process_request(PROCEDURE)'
307: ,p_msg_text => 'Completed cleanup');
308:
309:

Line 310: fem_engines_pkg.tech_message (p_severity => g_log_level_2

306: ,p_module => g_block||'.process_request(PROCEDURE)'
307: ,p_msg_text => 'Completed cleanup');
308:
309:
310: fem_engines_pkg.tech_message (p_severity => g_log_level_2
311: ,p_module => g_block||'.process_request(PROCEDURE)'
312: ,p_msg_text => 'END process_request');
313:
314: EXCEPTION

Line 316: fem_engines_pkg.tech_message (p_severity => g_log_level_6

312: ,p_msg_text => 'END process_request');
313:
314: EXCEPTION
315: WHEN OTHERS THEN
316: fem_engines_pkg.tech_message (p_severity => g_log_level_6
317: ,p_module => g_block||'.process_request(PROCEDURE)'
318: ,p_msg_text => 'EXCEPTION in process_request ' || sqlerrm);
319: fnd_file.put_line(fnd_file.log, 'Exception - process_request ' || sqlerrm);
320: RAISE;

Line 342: fem_engines_pkg.tech_message (p_severity => g_log_level_2

338: l_message VARCHAR2(2000);
339:
340: BEGIN
341:
342: fem_engines_pkg.tech_message (p_severity => g_log_level_2
343: ,p_module => g_block||'.trace(PROCEDURE)'
344: ,p_msg_text => 'BEGIN..for trace ' || p_trace_what);
345:
346: IF p_trace_what = 'SEPARATOR' THEN

Line 356: fem_engines_pkg.tech_message (p_severity => g_log_level_2

352: END IF;
353:
354: fnd_file.put_line(FND_FILE.OUTPUT, l_message);
355:
356: fem_engines_pkg.tech_message (p_severity => g_log_level_2
357: ,p_module => g_block||'.trace(PROCEDURE)'
358: ,p_msg_text => 'END trace ');
359:
360:

Line 363: fem_engines_pkg.tech_message (p_severity => g_log_level_6

359:
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: fem_engines_pkg.tech_message (p_severity => g_log_level_6
364: ,p_module => g_block||'.trace(PROCEDURE)'
365: ,p_msg_text => 'EXCEPTION in trace ' || sqlerrm);
366: fnd_file.put_line(fnd_file.log, 'Exception - trace ' || sqlerrm);
367: RAISE;

Line 389: fem_engines_pkg.tech_message (p_severity => g_log_level_2

385:
386: PROCEDURE cleanup IS
387:
388: BEGIN
389: fem_engines_pkg.tech_message (p_severity => g_log_level_2
390: ,p_module => g_block||'.cleanup(PROCEDURE)'
391: ,p_msg_text => 'BEGIN..for cleanup ');
392:
393:

Line 437: fem_engines_pkg.tech_message (p_severity => g_log_level_2

433: DELETE fem_ld_dim_requests_gt;
434: DELETE fem_ld_hier_requests_gt;
435: DELETE fem_ld_cal_periods_gt;
436:
437: fem_engines_pkg.tech_message (p_severity => g_log_level_2
438: ,p_module => g_block||'.cleanup(PROCEDURE)'
439: ,p_msg_text => 'END cleanup ');
440:
441: EXCEPTION

Line 443: fem_engines_pkg.tech_message (p_severity => g_log_level_6

439: ,p_msg_text => 'END cleanup ');
440:
441: EXCEPTION
442: WHEN OTHERS THEN
443: fem_engines_pkg.tech_message (p_severity => g_log_level_6
444: ,p_module => g_block||'.cleanup(PROCEDURE)'
445: ,p_msg_text => 'EXCEPTION in cleanup ' || sqlerrm);
446: fnd_file.put_line(fnd_file.log, 'Exception - cleanup ' || sqlerrm);
447: RAISE;

Line 469: fem_engines_pkg.tech_message (p_severity => g_log_level_2

465: PROCEDURE get_parameters(p_obj_def_id IN NUMBER) IS
466: l_approval_status VARCHAR2(30);
467: BEGIN
468:
469: fem_engines_pkg.tech_message (p_severity => g_log_level_2
470: ,p_module => g_block||'.get_parameters(PROCEDURE)'
471: ,p_msg_text => 'BEGIN..for get_parameters ');
472:
473: BEGIN

Line 487: fem_engines_pkg.tech_message (p_severity => g_log_level_6

483: AND fod.object_definition_id = p_obj_def_id;
484:
485: EXCEPTION
486: WHEN OTHERS THEN
487: fem_engines_pkg.tech_message (p_severity => g_log_level_6
488: ,p_module => g_block||'.get_parameters (PROCEDURE)'
489: ,p_msg_text => 'EXCEPTION in get_parameters.loader_type ' || sqlerrm);
490: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters ' || sqlerrm);
491: RAISE; -- loader_rule_error;

Line 545: fem_engines_pkg.tech_message (p_severity => g_log_level_6

541: AND fdlp.table_name = fdlo.table_name
542: AND fdlo.object_id = fodb.object_id;
543: EXCEPTION
544: WHEN OTHERS THEN
545: fem_engines_pkg.tech_message (p_severity => g_log_level_6
546: ,p_module => g_block||'.get_parameters (PROCEDURE)'
547: ,p_msg_text => 'EXCEPTION in get_parameters ' || sqlerrm);
548: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters(DATA LOAD) ' || sqlerrm);
549: RAISE;

Line 582: fem_engines_pkg.tech_message (p_severity => g_log_level_6

578: WHERE loader_obj_def_id = p_obj_def_id;
579:
580: EXCEPTION
581: WHEN OTHERS THEN
582: fem_engines_pkg.tech_message (p_severity => g_log_level_6
583: ,p_module => g_block||'.get_parameters (PROCEDURE)'
584: ,p_msg_text => 'EXCEPTION in get_parameters(LEDGER LOAD) ' || sqlerrm);
585: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters ' || sqlerrm);
586: RAISE;

Line 591: fem_engines_pkg.tech_message (p_severity => g_log_level_2

587: END;
588:
589: END IF;
590:
591: fem_engines_pkg.tech_message (p_severity => g_log_level_2
592: ,p_module => g_block||'.get_parameters(PROCEDURE)'
593: ,p_msg_text => 'END get_parameters');
594:
595: END get_parameters;

Line 612: fem_engines_pkg.tech_message (p_severity => g_log_level_2

608: PROCEDURE process_global_id IS
609:
610: BEGIN
611:
612: fem_engines_pkg.tech_message (p_severity => g_log_level_2
613: ,p_module => g_block||'.process_global_id(PROCEDURE)'
614: ,p_msg_text => 'BEGIN..for process_global_id ');
615:
616: BEGIN

Line 623: fem_engines_pkg.tech_message (p_severity => g_log_level_6

619: FROM fem_dimensions_b
620: WHERE dimension_varchar_label = 'LEDGER';
621: EXCEPTION
622: WHEN OTHERS THEN
623: fem_engines_pkg.tech_message (p_severity => g_log_level_6
624: ,p_module => g_block||'.process_global_id(PROCEDURE)'
625: ,p_msg_text => 'EXCEPTION fetching dimension_id for LEDGER');
626: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
627: RAISE;

Line 630: fem_engines_pkg.tech_message (p_severity => g_log_level_1

626: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
627: RAISE;
628: END;
629:
630: fem_engines_pkg.tech_message (p_severity => g_log_level_1
631: ,p_module => g_block||'.process_global_id(PROCEDURE)'
632: ,p_msg_text => 'Evaluated dimension_id for LEDGER :: ' || g_ledger_dim_id);
633:
634: BEGIN

Line 645: fem_engines_pkg.tech_message (p_severity => g_log_level_6

641: AND dav.attribute_id = da.attribute_id
642: AND dav.default_version_flag = 'Y';
643: EXCEPTION
644: WHEN OTHERS THEN
645: fem_engines_pkg.tech_message (p_severity => g_log_level_6
646: ,p_module => g_block||'.process_global_id(PROCEDURE)'
647: ,p_msg_text => 'EXCEPTION fetching attribute_id for CAL PERIOD HIERARCHY');
648: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
649: RAISE;

Line 652: fem_engines_pkg.tech_message (p_severity => g_log_level_1

648: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
649: RAISE;
650: END;
651:
652: fem_engines_pkg.tech_message (p_severity => g_log_level_1
653: ,p_module => g_block||'.process_global_id(PROCEDURE)'
654: ,p_msg_text => 'Evaluated attribute_id for CAL PERIOD HIERARCHY :: ' ||
655: g_cal_period_hier_attr);
656:

Line 665: fem_engines_pkg.tech_message (p_severity => g_log_level_6

661: FROM fem_dimensions_b
662: WHERE dimension_varchar_label = 'CAL_PERIOD';
663: EXCEPTION
664: WHEN OTHERS THEN
665: fem_engines_pkg.tech_message (p_severity => g_log_level_6
666: ,p_module => g_block||'.process_global_id(PROCEDURE)'
667: ,p_msg_text => 'EXCEPTION fetching dimension_id for CAL PERIOD');
668: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
669: RAISE;

Line 672: fem_engines_pkg.tech_message (p_severity => g_log_level_1

668: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
669: RAISE;
670: END;
671:
672: fem_engines_pkg.tech_message (p_severity => g_log_level_1
673: ,p_module => g_block||'.process_global_id(PROCEDURE)'
674: ,p_msg_text => 'Evaluated dimension_id for CAL_PERIOD :: ' || g_cal_period_dim_id);
675:
676:

Line 688: fem_engines_pkg.tech_message (p_severity => g_log_level_6

684: AND dav.attribute_id = da.attribute_id
685: AND dav.default_version_flag = 'Y';
686: EXCEPTION
687: WHEN OTHERS THEN
688: fem_engines_pkg.tech_message (p_severity => g_log_level_6
689: ,p_module => g_block||'.process_global_id(PROCEDURE)'
690: ,p_msg_text => 'EXCEPTION fetching attribute_id for CAL PERIOD START DATE');
691: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
692: RAISE;

Line 695: fem_engines_pkg.tech_message (p_severity => g_log_level_1

691: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
692: RAISE;
693: END;
694:
695: fem_engines_pkg.tech_message (p_severity => g_log_level_1
696: ,p_module => g_block||'.process_global_id(PROCEDURE)'
697: ,p_msg_text => 'Evaluated attribute_id for CAL PERIOD START DATE :: ' ||
698: g_start_date_attr);
699:

Line 712: fem_engines_pkg.tech_message (p_severity => g_log_level_6

708: AND dav.attribute_id = da.attribute_id
709: AND dav.default_version_flag = 'Y';
710: EXCEPTION
711: WHEN OTHERS THEN
712: fem_engines_pkg.tech_message (p_severity => g_log_level_6
713: ,p_module => g_block||'.process_global_id(PROCEDURE)'
714: ,p_msg_text => 'EXCEPTION fetching attribute_id for CAL PERIOD END DATE');
715: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
716: RAISE;

Line 719: fem_engines_pkg.tech_message (p_severity => g_log_level_1

715: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
716: RAISE;
717: END;
718:
719: fem_engines_pkg.tech_message (p_severity => g_log_level_1
720: ,p_module => g_block||'.process_global_id(PROCEDURE)'
721: ,p_msg_text => 'Evaluated attribute_id for CAL PERIOD END DATE :: ' || g_end_date_attr);
722:
723: BEGIN

Line 730: fem_engines_pkg.tech_message (p_severity => g_log_level_6

726: FROM fem_dimensions_b
727: WHERE dimension_varchar_label = 'DATASET';
728: EXCEPTION
729: WHEN OTHERS THEN
730: fem_engines_pkg.tech_message (p_severity => g_log_level_6
731: ,p_module => g_block||'.process_global_id(PROCEDURE)'
732: ,p_msg_text => 'EXCEPTION fetching dimension_id for DATASET');
733: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
734: RAISE;

Line 737: fem_engines_pkg.tech_message (p_severity => g_log_level_1

733: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
734: RAISE;
735: END;
736:
737: fem_engines_pkg.tech_message (p_severity => g_log_level_1
738: ,p_module => g_block||'.process_global_id(PROCEDURE)'
739: ,p_msg_text => 'Evaluated dimension_id for DATASET :: ' || g_dataset_dim_id);
740:
741:

Line 753: fem_engines_pkg.tech_message (p_severity => g_log_level_6

749: AND dav.attribute_id = da.attribute_id
750: AND dav.default_version_flag = 'Y';
751: EXCEPTION
752: WHEN OTHERS THEN
753: fem_engines_pkg.tech_message (p_severity => g_log_level_6
754: ,p_module => g_block||'.process_global_id(PROCEDURE)'
755: ,p_msg_text => 'EXCEPTION fetching attribute_id for DATASET BALANCE TYPE');
756: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
757: RAISE;

Line 760: fem_engines_pkg.tech_message (p_severity => g_log_level_1

756: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
757: RAISE;
758: END;
759:
760: fem_engines_pkg.tech_message (p_severity => g_log_level_1
761: ,p_module => g_block||'.process_global_id(PROCEDURE)'
762: ,p_msg_text => 'Evaluated attribute_id for DATASET BALANCE TYPE :: ' ||
763: g_dataset_bal_attr);
764:

Line 777: fem_engines_pkg.tech_message (p_severity => g_log_level_6

773: AND dav.attribute_id = da.attribute_id
774: AND dav.default_version_flag = 'Y';
775: EXCEPTION
776: WHEN OTHERS THEN
777: fem_engines_pkg.tech_message (p_severity => g_log_level_6
778: ,p_module => g_block||'.process_global_id(PROCEDURE)'
779: ,p_msg_text => 'EXCEPTION fetching attribute_id for PRODUCTION FLAG');
780: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
781: RAISE;

Line 784: fem_engines_pkg.tech_message (p_severity => g_log_level_1

780: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
781: RAISE;
782: END;
783:
784: fem_engines_pkg.tech_message (p_severity => g_log_level_1
785: ,p_module => g_block||'.process_global_id(PROCEDURE)'
786: ,p_msg_text => 'Evaluated attribute_id for PRODUCTION FLAG :: ' || g_production_attr);
787:
788:

Line 796: fem_engines_pkg.tech_message (p_severity => g_log_level_6

792: FROM fem_dimensions_b dim
793: WHERE dim.dimension_varchar_label = 'BUDGET';
794: EXCEPTION
795: WHEN OTHERS THEN
796: fem_engines_pkg.tech_message (p_severity => g_log_level_6
797: ,p_module => g_block||'.process_global_id(PROCEDURE)'
798: ,p_msg_text => 'EXCEPTION fetching dimension_id for BUDGET');
799: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
800: RAISE;

Line 803: fem_engines_pkg.tech_message (p_severity => g_log_level_1

799: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
800: RAISE;
801: END;
802:
803: fem_engines_pkg.tech_message (p_severity => g_log_level_1
804: ,p_module => g_block||'.process_global_id(PROCEDURE)'
805: ,p_msg_text => 'Evaluated dimension_id for BUDGET :: ' || g_budget_dim_id);
806:
807:

Line 808: fem_engines_pkg.tech_message (p_severity => g_log_level_2

804: ,p_module => g_block||'.process_global_id(PROCEDURE)'
805: ,p_msg_text => 'Evaluated dimension_id for BUDGET :: ' || g_budget_dim_id);
806:
807:
808: fem_engines_pkg.tech_message (p_severity => g_log_level_2
809: ,p_module => g_block||'.process_global_id(PROCEDURE)'
810: ,p_msg_text => 'END process_global_id');
811:
812: END process_global_id;

Line 841: fem_engines_pkg.tech_message (p_severity => g_log_level_2

837: l_ret_code NUMBER;
838: l_err_buff VARCHAR2(1000);
839: BEGIN
840:
841: fem_engines_pkg.tech_message (p_severity => g_log_level_2
842: ,p_module => g_block||'.wait_for_requests(PROCEDURE)'
843: ,p_msg_text => 'BEGIN..for wait_for_requests ');
844:
845: CASE p_wait_for

Line 929: fem_engines_pkg.tech_message (p_severity => g_log_level_2

925: END LOOP; -- hier_rec
926:
927: END CASE; -- p_wait_for
928:
929: fem_engines_pkg.tech_message (p_severity => g_log_level_2
930: ,p_module => g_block||'.wait_for_requests(PROCEDURE)'
931: ,p_msg_text => 'END wait_for_requests ');
932:
933: EXCEPTION

Line 935: fem_engines_pkg.tech_message (p_severity => g_log_level_6

931: ,p_msg_text => 'END wait_for_requests ');
932:
933: EXCEPTION
934: WHEN OTHERS THEN
935: fem_engines_pkg.tech_message (p_severity => g_log_level_6
936: ,p_module => g_block||'.wait_for_requests(PROCEDURE)'
937: ,p_msg_text => 'EXCEPTION in wait_for_requests ' || sqlerrm);
938: fnd_file.put_line(fnd_file.log, 'Exception - wait_for_requests ' || sqlerrm);
939: RAISE;

Line 971: fem_engines_pkg.tech_message (p_severity => g_log_level_2

967: l_dummy NUMBER;
968: l_at_least_one BOOLEAN;
969: BEGIN
970:
971: fem_engines_pkg.tech_message (p_severity => g_log_level_2
972: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
973: ,p_msg_text => 'BEGIN..for submit_dimension_loaders');
974:
975: l_at_least_one := FALSE;

Line 988: fem_engines_pkg.tech_message (p_severity => g_log_level_1

984: EXECUTE IMMEDIATE 'SELECT 1 FROM ' || dim_rec.dim_intf_table_name || ' WHERE ROWNUM = 1' INTO l_dummy;
985: EXCEPTION
986: WHEN NO_DATA_FOUND THEN
987: l_dummy := 0.0;
988: fem_engines_pkg.tech_message (p_severity => g_log_level_1
989: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
990: ,p_msg_text => 'No data exists in the interface table '
991: || dim_rec.dim_intf_table_name );
992: WHEN OTHERS THEN

Line 993: fem_engines_pkg.tech_message (p_severity => g_log_level_6

989: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
990: ,p_msg_text => 'No data exists in the interface table '
991: || dim_rec.dim_intf_table_name );
992: WHEN OTHERS THEN
993: fem_engines_pkg.tech_message (p_severity => g_log_level_6
994: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
995: ,p_msg_text => 'Error while checking if data EXISTS in interface table '
996: || dim_rec.dim_intf_table_name || ' - ' || sqlerrm);
997: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);

Line 1037: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1033:
1034: END LOOP;
1035:
1036: IF l_at_least_one THEN
1037: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1038: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
1039: ,p_msg_text => 'Calling wait_for_requests - DIMENSION');
1040:
1041: wait_for_requests(c_dim_loader);

Line 1043: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1039: ,p_msg_text => 'Calling wait_for_requests - DIMENSION');
1040:
1041: wait_for_requests(c_dim_loader);
1042:
1043: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1044: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
1045: ,p_msg_text => 'Completed wait_for_requests - DIMENSION');
1046: END IF;
1047:

Line 1048: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1044: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
1045: ,p_msg_text => 'Completed wait_for_requests - DIMENSION');
1046: END IF;
1047:
1048: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1049: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
1050: ,p_msg_text => 'END submit_dimension_loaders');
1051:
1052: EXCEPTION

Line 1054: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1050: ,p_msg_text => 'END submit_dimension_loaders');
1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1055: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
1056: ,p_msg_text => 'EXCEPTION in submit_dimension_loaders ' || sqlerrm);
1057: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);
1058: RAISE;

Line 1092: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1088: e_num_loader_neg EXCEPTION;
1089:
1090: BEGIN
1091:
1092: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1093: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1094: ,p_msg_text => 'BEGIN..for submit_data_loaders');
1095:
1096: l_at_least_one := FALSE;

Line 1164: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1160:
1161: END LOOP; -- g_master_rec
1162:
1163: IF l_at_least_one THEN
1164: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1165: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1166: ,p_msg_text => 'Calling wait_for_requests - DATA LOAD');
1167:
1168: wait_for_requests(c_data_ledger_loader);

Line 1170: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1166: ,p_msg_text => 'Calling wait_for_requests - DATA LOAD');
1167:
1168: wait_for_requests(c_data_ledger_loader);
1169:
1170: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1171: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1172: ,p_msg_text => 'Completed wait_for_requests - DATA LOAD');
1173:
1174: END IF;

Line 1176: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1172: ,p_msg_text => 'Completed wait_for_requests - DATA LOAD');
1173:
1174: END IF;
1175:
1176: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1177: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1178: ,p_msg_text => 'END submit_data_loaders');
1179:
1180: END IF;--IF (l_num_loader is NULL OR l_num_loader>=l_rec_count)

Line 1251: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1247:
1248:
1249: --wait only for submitted requests
1250: IF l_at_least_one THEN
1251: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1252: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1253: ,p_msg_text => 'Calling wait_for_requests - DATA LOAD');
1254:
1255: wait_for_requests(c_data_ledger_loader);

Line 1257: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1253: ,p_msg_text => 'Calling wait_for_requests - DATA LOAD');
1254:
1255: wait_for_requests(c_data_ledger_loader);
1256:
1257: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1258: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1259: ,p_msg_text => 'Completed wait_for_requests - DATA LOAD');
1260:
1261: END IF;

Line 1263: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1259: ,p_msg_text => 'Completed wait_for_requests - DATA LOAD');
1260:
1261: END IF;
1262:
1263: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1264: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1265: ,p_msg_text => 'END submit_data_loaders');
1266:
1267: END LOOP; --WHILE(i<=l_rec_count) LOOP

Line 1275: FEM_ENGINES_PKG.User_Message (

1271:
1272: EXCEPTION
1273: WHEN e_num_loader_neg THEN
1274:
1275: FEM_ENGINES_PKG.User_Message (
1276: p_app_name => 'FEM'
1277: ,p_msg_name => 'FEM_NUM_OF_LOADERS_NEG_ERR'
1278: );
1279:

Line 1282: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1278: );
1279:
1280: RAISE ;
1281: WHEN OTHERS THEN
1282: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1283: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1284: ,p_msg_text => 'EXCEPTION in submit_data_loaders ' || sqlerrm);
1285: fnd_file.put_line(fnd_file.log, 'Exception - submit_data_loader ' || sqlerrm);
1286: RAISE;

Line 1312: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1308: exit_condition BOOLEAN;
1309: l_ledger_load_mode VARCHAR2(1);
1310: BEGIN
1311:
1312: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1313: ,p_module => g_block||'.submit_ledger_loader(PROCEDURE)'
1314: ,p_msg_text => 'BEGIN..for submit_ledger_loader');
1315:
1316: l_at_least_one := FALSE;

Line 1376: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1372:
1373: END LOOP; -- g_master_rec
1374:
1375: IF l_at_least_one THEN
1376: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1377: ,p_module => g_block||'.submit_ledger_loader(PROCEDURE)'
1378: ,p_msg_text => 'Calling wait_for_requests - LEDGER LOAD');
1379:
1380: wait_for_requests(c_data_ledger_loader);

Line 1382: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1378: ,p_msg_text => 'Calling wait_for_requests - LEDGER LOAD');
1379:
1380: wait_for_requests(c_data_ledger_loader);
1381:
1382: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1383: ,p_module => g_block||'.submit_ledger_loader(PROCEDURE)'
1384: ,p_msg_text => 'Completed wait_for_requests - LEDGER LOAD');
1385:
1386: END IF;

Line 1388: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1384: ,p_msg_text => 'Completed wait_for_requests - LEDGER LOAD');
1385:
1386: END IF;
1387:
1388: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1389: ,p_module => g_block||'.submit_ledger_loader(PROCEDURE)'
1390: ,p_msg_text => 'END submit_ledger_loader');
1391:
1392:

Line 1395: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1391:
1392:
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1396: ,p_module => g_block||'.submit_ledger_loader(PROCEDURE)'
1397: ,p_msg_text => 'EXCEPTION in submit_ledger_loader ' || sqlerrm);
1398: fnd_file.put_line(fnd_file.log, 'Exception - submit_ledger_loader ' || sqlerrm);
1399: RAISE;

Line 1429: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1425:
1426: l_at_least_one BOOLEAN;
1427: BEGIN
1428:
1429: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1430: ,p_module => g_block||'.submit_hierarchy_loader(PROCEDURE)'
1431: ,p_msg_text => 'BEGIN..for submit_hierarchy_loader');
1432:
1433: l_at_least_one := FALSE;

Line 1478: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1474: END LOOP;
1475:
1476:
1477: IF l_at_least_one THEN
1478: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1479: ,p_module => g_block||'.submit_hierarchy_loaders(PROCEDURE)'
1480: ,p_msg_text => 'Calling wait_for_requests - HIERARCHY');
1481:
1482: wait_for_requests(c_hier_loader);

Line 1484: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1480: ,p_msg_text => 'Calling wait_for_requests - HIERARCHY');
1481:
1482: wait_for_requests(c_hier_loader);
1483:
1484: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1485: ,p_module => g_block||'.submit_hierarchy_loaders(PROCEDURE)'
1486: ,p_msg_text => 'Completed wait_for_requests - HIERARCHY');
1487: END IF;
1488:

Line 1489: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1485: ,p_module => g_block||'.submit_hierarchy_loaders(PROCEDURE)'
1486: ,p_msg_text => 'Completed wait_for_requests - HIERARCHY');
1487: END IF;
1488:
1489: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1490: ,p_module => g_block||'.submit_hierarchy_loader(PROCEDURE)'
1491: ,p_msg_text => 'END submit_hierarchy_loader');
1492:
1493:

Line 1496: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1492:
1493:
1494: EXCEPTION
1495: WHEN OTHERS THEN
1496: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1497: ,p_module => g_block||'.submit_hierarchy_loader(PROCEDURE)'
1498: ,p_msg_text => 'EXCEPTION in submit_hierarchy_loader ' || sqlerrm);
1499: fnd_file.put_line(fnd_file.log, 'Exception - submit_hierarchy_loaders ' || sqlerrm);
1500: RAISE;

Line 1521: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1517: l_dummy NUMBER;
1518: l_dimension_load BOOLEAN;
1519: BEGIN
1520:
1521: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1522: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1523: ,p_msg_text => 'BEGIN..for build_dim_stages');
1524:
1525: l_dummy := 0.0;

Line 1529: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1525: l_dummy := 0.0;
1526: l_dimension_load := FALSE;
1527:
1528: FOR i IN 1..gs_table_name_tab.COUNT LOOP
1529: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1530: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1531: ,p_msg_text => 'Building dim stages for table :: ' ||
1532: gs_table_name_tab(i) ||
1533: ' Load Option :: ' ||

Line 1581: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1577: END IF;
1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1582: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1583: ,p_msg_text => 'EXCEPTION in build_dim_stages - insert into
1584: fem_ld_dim_requests_gt');
1585: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);

Line 1613: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1609: AND d.old_approved_copy_flag = 'N'
1610: AND d.approval_status_code NOT IN ('SUBMIT_DELETE','SUBMIT_APPROVAL');
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1614: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1615: ,p_msg_text => 'EXCEPTION in build_dim_stages - fetching
1616: object_def_id for HIER');
1617: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);

Line 1656: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1652: WHERE table_name = gs_table_name_tab(i)
1653: AND drt.dimension_varchar_label = fht.dimension_varchar_label;
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1657: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1658: ,p_msg_text => 'EXCEPTION in build_dim_stages - insert into
1659: fem_ld_hier_requests_gt');
1660: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);

Line 1671: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1667:
1668: END LOOP; -- 1..gs_table_name_tab.COUNT
1669:
1670: IF l_dimension_load THEN
1671: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1672: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1673: ,p_msg_text => 'Calling submit_dimension_loaders');
1674:
1675: submit_dimension_loaders;

Line 1677: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1673: ,p_msg_text => 'Calling submit_dimension_loaders');
1674:
1675: submit_dimension_loaders;
1676:
1677: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1678: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1679: ,p_msg_text => 'Completed submit_dimension_loaders');
1680: END IF;
1681:

Line 1682: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1678: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1679: ,p_msg_text => 'Completed submit_dimension_loaders');
1680: END IF;
1681:
1682: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1683: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1684: ,p_msg_text => 'END build_dim_stages');
1685:
1686:

Line 1689: fem_engines_pkg.tech_message (p_severity => g_log_level_6

1685:
1686:
1687: EXCEPTION
1688: WHEN OTHERS THEN
1689: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1690: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1691: ,p_msg_text => 'EXCEPTION in build_dim_stages ' || sqlerrm);
1692: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);
1693: RAISE;

Line 1802: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1798: l_dupe_position NUMBER;
1799: l_dupe_text VARCHAR2(20);
1800: BEGIN
1801:
1802: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1803: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1804: ,p_msg_text => 'BEGIN..for evaluate_parameters');
1805:
1806: l_dummy := 0.0;

Line 2000: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
1998: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1999:
2000: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2001: ,p_module => g_block||'.evaluate_parameters(0)'
2002: ,p_msg_text => ' Table Name :: ' || gs_table_name_tab(k) ||
2003: ' Table Row :: ' || gs_table_row_tab(k) ||
2004: ' Dup Row :: ' || gs_sql_dup_indx_tab(k) ||

Line 2032: fem_engines_pkg.tech_message(p_severity => g_log_level_1

2028: WHERE idt.cal_period_level =
2029: fdgb.dimension_group_display_code
2030: AND personal_flag = 'N'
2031: AND enabled_flag = 'Y');
2032: fem_engines_pkg.tech_message(p_severity => g_log_level_1
2033: ,p_module => g_block||'.evaluate_parameters'
2034: ,p_msg_text => ' Rows updated after ID population(DATA LOAD) :: ' || SQL%ROWCOUNT);
2035:
2036: fnd_file.put_line(fnd_file.log, ' Rows updated after ID population :: ' || SQL%ROWCOUNT);

Line 2215: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
2213: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2214:
2215: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2216: ,p_module => g_block||'.evaluate_parameters(0)'
2217: ,p_msg_text => ' Table Name :: ' || gs_table_name_tab(k) ||
2218: ' Table Row :: ' || gs_table_row_tab(k) ||
2219: ' Dup Row :: ' || gs_sql_dup_indx_tab(k) ||

Line 2244: fem_engines_pkg.tech_message(p_severity => g_log_level_1

2240: fdgb.dimension_group_display_code
2241: AND fdgb.personal_flag = 'N'
2242: AND fdgb.enabled_flag = 'Y');
2243:
2244: fem_engines_pkg.tech_message(p_severity => g_log_level_1
2245: ,p_module => g_block||'.evaluate_parameters'
2246: ,p_msg_text => ' Rows updated after ID population(LEDGER LOAD) :: ' || SQL%ROWCOUNT);
2247:
2248: fnd_file.put_line(fnd_file.log, ' Rows updated after ID population :: ' || SQL%ROWCOUNT);

Line 2290: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2288: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2289:
2290: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2291: ,p_module => g_block||'.evaluate_parameters(1)'
2292: ,p_msg_text => ' Table Name :: ' || int_rec.table_name ||
2293: ' Table Row :: ' || int_rec.table_row ||
2294: ' Ledger :: ' || int_rec.ledger_id ||

Line 2344: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2340: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' COUNT(*) = ' || l_dummy);
2341: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' Valid = ' || gs_valid_rows(i));
2342: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2343:
2344: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2345: ,p_module => g_block||'.evaluate_parameters(1.1)'
2346: ,p_msg_text => ' TABLE :: ' || gs_table_name_tab(i) ||
2347: ' ROW :: ' || gs_table_row_tab(i) ||
2348: ' COUNT :: ' || l_dummy ||

Line 2358: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2354: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2355: fnd_file.put_line(FND_FILE.log, ' No valid rows exists for ' || gs_table_name_tab(i));
2356: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2357:
2358: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2359: ,p_module => g_block||'.evaluate_parameters(1.1)'
2360: ,p_msg_text => ' No valid rows exists for ' || gs_table_name_tab(i));
2361:
2362: END IF; -- gs_valid_rows(i) > 0.0

Line 2381: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);
2379: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2380:
2381: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2382: ,p_module => g_block||'.evaluate_parameters(2)'
2383: ,p_msg_text => ' Table Name :: ' || int_rec.table_name ||
2384: ' Table Row :: ' || int_rec.table_row ||
2385: ' Ledger :: ' || int_rec.ledger_id ||

Line 2470: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));
2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));
2468: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2469:
2470: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2471: ,p_module => g_block||'.evaluate_parameters(Invalid section)'
2472: ,p_msg_text => ' Table Name :: ' || g_inv_table_name(z) ||
2473: ' Table Row :: ' || g_inv_table_row(z) ||
2474: ' Ledger :: ' || g_inv_ledger(z) ||

Line 2482: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2478: END LOOP;
2479:
2480: END IF; -- g_loader_run (second occurence)
2481:
2482: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2483: ,p_module => g_block||'.evaluate_parameters(PROCEDURE)'
2484: ,p_msg_text => 'END evaluate_parameters');
2485:
2486:

Line 2489: fem_engines_pkg.tech_message (p_severity => g_log_level_6

2485:
2486:
2487: EXCEPTION
2488: WHEN OTHERS THEN
2489: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2490: ,p_module => g_block||'.evaluate_parameters(PROCEDURE)'
2491: ,p_msg_text => 'EXCEPTION in evaluate_parameters ' || sqlerrm);
2492: fnd_file.put_line(fnd_file.log, 'Exception - evaluate_params ' || sqlerrm);
2493: RAISE;

Line 2528: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2524: l_dummy1 NUMBER;
2525:
2526: BEGIN
2527:
2528: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2529: ,p_module => g_block||'.populate_cal_periods(PROCEDURE)'
2530: ,p_msg_text => 'BEGIN..for populate_cal_periods');
2531:
2532: FOR i IN 1..gs_ledger_tab.COUNT LOOP

Line 2671: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);
2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);
2669: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2670:
2671: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2672: ,p_module => g_block||'.populate_cal_periods'
2673: ,p_msg_text => ' Table Name :: ' || cal_rec.table_name ||
2674: ' Table Row :: ' || cal_rec.table_row ||
2675: ' Ledger :: ' || cal_rec.ledger_id ||

Line 2687: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2683: WHERE ROWNUM = 1;
2684:
2685: IF l_dummy1 = 0.0 THEN
2686: g_evaluate_parameters := FALSE;
2687: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2688: ,p_module => g_block||'.populate_cal_periods'
2689: ,p_msg_text => ' No valid CAL PERIODS');
2690: fnd_file.put_line(FND_FILE.log, ' No valid cal Periods');
2691: ELSE

Line 2692: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2688: ,p_module => g_block||'.populate_cal_periods'
2689: ,p_msg_text => ' No valid CAL PERIODS');
2690: fnd_file.put_line(FND_FILE.log, ' No valid cal Periods');
2691: ELSE
2692: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2693: ,p_module => g_block||'.populate_cal_periods'
2694: ,p_msg_text => 'Some valid CAL PERIODS exist');
2695: END IF; -- l_dummy = 0.0
2696:

Line 2697: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2693: ,p_module => g_block||'.populate_cal_periods'
2694: ,p_msg_text => 'Some valid CAL PERIODS exist');
2695: END IF; -- l_dummy = 0.0
2696:
2697: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2698: ,p_module => g_block||'.populate_cal_periods(PROCEDURE)'
2699: ,p_msg_text => 'END populate_cal_periods');
2700:
2701:

Line 2704: fem_engines_pkg.tech_message (p_severity => g_log_level_6

2700:
2701:
2702: EXCEPTION
2703: WHEN OTHERS THEN
2704: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2705: ,p_module => g_block||'.populate_cal_periods(PROCEDURE)'
2706: ,p_msg_text => 'EXCEPTION in populate_cal_periods ' || sqlerrm);
2707: fnd_file.put_line(fnd_file.log, 'Exception - populate_cal_periods ' || sqlerrm);
2708: RAISE;

Line 2727: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2723: PROCEDURE populate_master_table_lldr IS
2724: indx PLS_INTEGER;
2725: BEGIN
2726:
2727: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2728: ,p_module => g_block||'.populate_master_table_lldr(PROCEDURE)'
2729: ,p_msg_text => 'BEGIN..for populate_master_table_lldr');
2730:
2731:

Line 2799: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);
2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);
2797: fnd_file.put_line(fnd_file.log, '=================================================================');
2798:
2799: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2800: ,p_module => g_block||'.populate_master_table_lldr(MASTER INDEX TABLE)'
2801: ,p_msg_text => ' Table Name :: ' || g_master_rec(j).table_name ||
2802: ' Table Row :: ' || g_master_rec(j).table_row ||
2803: ' Ledger ID :: ' || g_master_rec(j).ledger_id ||

Line 2811: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2807: ' Enc Type ID :: ' || g_master_rec(j).enc_type_id);
2808:
2809: END LOOP;
2810:
2811: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2812: ,p_module => g_block||'.populate_master_table_lldr(PROCEDURE)'
2813: ,p_msg_text => 'END populate_master_table_lldr');
2814:
2815:

Line 2818: fem_engines_pkg.tech_message (p_severity => g_log_level_6

2814:
2815:
2816: EXCEPTION
2817: WHEN OTHERS THEN
2818: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2819: ,p_module => g_block||'.populate_master_table_lldr(PROCEDURE)'
2820: ,p_msg_text => 'EXCEPTION in populate_master_table_lldr ' || sqlerrm);
2821: fnd_file.put_line(fnd_file.log, 'Exception - populate_master_table_lldr ' || sqlerrm);
2822: RAISE;

Line 2840: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2836: PROCEDURE populate_master_table_dldr IS
2837: indx PLS_INTEGER;
2838: BEGIN
2839:
2840: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2841: ,p_module => g_block||'.populate_master_table_dldr(PROCEDURE)'
2842: ,p_msg_text => 'BEGIN..for populate_master_table_dldr');
2843:
2844: indx := 1.0;

Line 2906: fem_engines_pkg.tech_message (p_severity => g_log_level_1

2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);
2904: fnd_file.put_line(fnd_file.log, '=================================================================');
2905:
2906: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2907: ,p_module => g_block||'.populate_master_table_dldr(MASTER INDEX TABLE)'
2908: ,p_msg_text => ' Table Name :: ' || g_master_rec(j).table_name ||
2909: ' Table Row :: ' || g_master_rec(j).table_row ||
2910: ' Ledger ID :: ' || g_master_rec(j).ledger_id ||

Line 2917: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2913: ' Source System :: ' || g_master_rec(j).source_system_code);
2914:
2915: END LOOP;
2916:
2917: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2918: ,p_module => g_block||'.populate_master_table_dldr(PROCEDURE)'
2919: ,p_msg_text => 'END populate_master_table_dldr');
2920:
2921:

Line 2924: fem_engines_pkg.tech_message (p_severity => g_log_level_6

2920:
2921:
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2925: ,p_module => g_block||'.populate_master_table_dldr(PROCEDURE)'
2926: ,p_msg_text => 'EXCEPTION in populate_master_table_dldr ' || sqlerrm);
2927: fnd_file.put_line(fnd_file.log, 'Exception - populate_master_table_dldr ' || sqlerrm);
2928: RAISE;

Line 2950: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2946: l_request_id NUMBER;
2947: l_table_name VARCHAR2(30);
2948: BEGIN
2949:
2950: fem_engines_pkg.tech_message (p_severity => g_log_level_2
2951: ,p_module => g_block||'.log_dimensions(PROCEDURE)'
2952: ,p_msg_text => 'BEGIN..for log_dimensions(' || p_table_name || ')');
2953:
2954: FOR dim_rec IN ( SELECT dimension_id,

Line 3000: fem_engines_pkg.tech_message (p_severity => g_log_level_2

2996: trace('MESSAGE');
2997:
2998: END LOOP; -- dim_rec
2999:
3000: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3001: ,p_module => g_block||'.log_dimensions(PROCEDURE)'
3002: ,p_msg_text => 'END log_dimensions(' || p_table_name || ')');
3003:
3004: EXCEPTION

Line 3006: fem_engines_pkg.tech_message (p_severity => g_log_level_6

3002: ,p_msg_text => 'END log_dimensions(' || p_table_name || ')');
3003:
3004: EXCEPTION
3005: WHEN OTHERS THEN
3006: fem_engines_pkg.tech_message (p_severity => g_log_level_6
3007: ,p_module => g_block||'.log_dimensions(PROCEDURE)'
3008: ,p_msg_text => 'EXCEPTION in log_dimensions(' || p_table_name || ') - ' || sqlerrm);
3009: fnd_file.put_line(fnd_file.log, 'Exception - log_dimensions ' || sqlerrm);
3010: RAISE;

Line 3032: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3028: l_request_id NUMBER;
3029: l_table_name VARCHAR2(30);
3030: BEGIN
3031:
3032: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3033: ,p_module => g_block||'.log_hierarchies(PROCEDURE)'
3034: ,p_msg_text => 'BEGIN..for log_hierarchies');
3035:
3036: FOR hier_rec IN (SELECT dimension_varchar_label,

Line 3081: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3077: trace('MESSAGE');
3078:
3079: END LOOP;
3080:
3081: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3082: ,p_module => g_block||'.log_hierarchies(PROCEDURE)'
3083: ,p_msg_text => 'END log_hierarchies');
3084:
3085:

Line 3088: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3084:
3085:
3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3089: ,p_module => g_block||'.log_hierarchies(PROCEDURE)'
3090: ,p_msg_text => 'EXCEPTION in log_hierarchies ' || sqlerrm);
3091: fnd_file.put_line(fnd_file.log, 'Exception - log_hierarchies ' || sqlerrm);
3092: RAISE;

Line 3121: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3117:
3118: e_process_single_rule_error EXCEPTION;
3119: BEGIN
3120:
3121: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3122: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3123: ,p_msg_text => 'BEGIN..for log_fact_table(' || p_table_name || ',' || p_table_row || ')');
3124:
3125: l_start := NULL;

Line 3177: fem_engines_pkg.tech_message (p_severity => g_log_level_1

3173: fnd_message.set_token('ROW',p_table_row);
3174: END IF;
3175: END IF;
3176:
3177: fem_engines_pkg.tech_message (p_severity => g_log_level_1
3178: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3179: ,p_msg_text => 'Register the chain for parent request(' || g_request_id ||
3180: '), child request(' || g_master_rec(i).request_id || ')');
3181:

Line 3194: fem_engines_pkg.tech_message (p_severity => g_log_level_1

3190: ,x_msg_count => l_msg_count
3191: ,x_msg_data => l_msg_data
3192: ,x_return_status => l_return_status);
3193:
3194: fem_engines_pkg.tech_message (p_severity => g_log_level_1
3195: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3196: ,p_msg_text => 'Completed registering the chain for parent request('
3197: || g_request_id ||
3198: '), child request(' || g_master_rec(i).request_id || ')');

Line 3235: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3231: END LOOP;
3232:
3233: trace('SEPARATOR');
3234:
3235: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3236: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3237: ,p_msg_text => 'END log_fact_table(' || p_table_name || ',' || p_table_row || ')');
3238:
3239: EXCEPTION

Line 3241: fem_engines_pkg.tech_message (

3237: ,p_msg_text => 'END log_fact_table(' || p_table_name || ',' || p_table_row || ')');
3238:
3239: EXCEPTION
3240: WHEN e_process_single_rule_error THEN
3241: fem_engines_pkg.tech_message (
3242: p_severity => g_log_level_5
3243: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3244: ,p_msg_text => 'EXCEPTION in log_fact_table while registering the chain(' || p_table_name || ',' ||
3245: p_table_row || ')' );

Line 3247: fem_engines_pkg.tech_message (p_severity => g_log_level_6

3243: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3244: ,p_msg_text => 'EXCEPTION in log_fact_table while registering the chain(' || p_table_name || ',' ||
3245: p_table_row || ')' );
3246: WHEN OTHERS THEN
3247: fem_engines_pkg.tech_message (p_severity => g_log_level_6
3248: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3249: ,p_msg_text => 'EXCEPTION in log_fact_table(' || p_table_name || ',' ||
3250: p_table_row || ') ' || sqlerrm);
3251: fnd_file.put_line(fnd_file.log, 'Exception - log_fact_table ' || sqlerrm);

Line 3276: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3272: l_table_name VARCHAR2(30);
3273: all_str VARCHAR2(30);
3274: BEGIN
3275:
3276: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3277: ,p_module => g_block||'.populate_log(PROCEDURE)'
3278: ,p_msg_text => 'BEGIN..for populate_log');
3279:
3280: fnd_message.set_name('FEM', 'FEM_ALL_TXT');

Line 3329: fem_engines_pkg.tech_message (p_severity => g_log_level_1

3325: END IF; -- g_loader_type = 'CLIENT'
3326:
3327: END LOOP;
3328:
3329: fem_engines_pkg.tech_message (p_severity => g_log_level_1
3330: ,p_module => g_block||'.populate_log(PROCEDURE)'
3331: ,p_msg_text => 'Fetched all the display codes');
3332:
3333: FOR i IN 1..gs_table_name_tab.COUNT LOOP

Line 3430: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3426: END CASE; -- gs_valid_rows(i)
3427:
3428: END LOOP;
3429:
3430: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3431: ,p_module => g_block||'.populate_log(PROCEDURE)'
3432: ,p_msg_text => 'END populate_log');
3433:
3434:

Line 3437: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3433:
3434:
3435: EXCEPTION
3436: WHEN OTHERS THEN
3437: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3438: ,p_module => g_block||'.populate_log(PROCEDURE)'
3439: ,p_msg_text => 'EXCEPTION in populate_log ' || sqlerrm);
3440: fnd_file.put_line(fnd_file.log, 'Exception - populate_log ' || sqlerrm);
3441: RAISE;

Line 3451: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3447: -------------------
3448:
3449: BEGIN
3450:
3451: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3452: ,p_module => g_block||'.MAIN - start'
3453: ,p_msg_text => 'BEGIN MAIN PACKAGE SECTION');
3454:
3455: g_approval_flag := FALSE;

Line 3463: fem_engines_pkg.tech_message (p_severity => g_log_level_2

3459:
3460: g_loader_run := FALSE;
3461: g_evaluate_parameters := FALSE;
3462:
3463: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3464: ,p_module => g_block||'.MAIN - end'
3465: ,p_msg_text => 'END MAIN PACKAGE SECTION');
3466:
3467: EXCEPTION

Line 3469: fem_engines_pkg.tech_message (p_severity => g_log_level_6

3465: ,p_msg_text => 'END MAIN PACKAGE SECTION');
3466:
3467: EXCEPTION
3468: WHEN OTHERS THEN
3469: fem_engines_pkg.tech_message (p_severity => g_log_level_6
3470: ,p_module => g_block||'.MAIN'
3471: ,p_msg_text => 'EXCEPTION in MAIN PACKAGE SECTION ' || sqlerrm);
3472:
3473: fnd_file.put_line(fnd_file.log, 'Exception - main ' || sqlerrm);