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

Line 138: FEM_ENGINES_PKG.TECH_MESSAGE

134: BEGIN
135:
136: g_block := 'Master';
137:
138: FEM_ENGINES_PKG.TECH_MESSAGE
139: (p_severity => c_log_level_3,
140: p_module => v_block||'.Begin{100}',
141: p_msg_text => 'Begin FEM_DATAX_LOADER.Master');
142:

Line 152: FEM_ENGINES_PKG.TECH_MESSAGE

148: g_cal_per_id := p_cal_per_id;
149: g_source_cd := p_source_cd;
150: g_exec_mode := p_exec_mode;
151:
152: FEM_ENGINES_PKG.TECH_MESSAGE
153: (p_severity => c_log_level_2,
154: p_module => v_block||'.g_req_id{101}',
155: p_msg_text => g_req_id);
156: FEM_ENGINES_PKG.TECH_MESSAGE

Line 156: FEM_ENGINES_PKG.TECH_MESSAGE

152: FEM_ENGINES_PKG.TECH_MESSAGE
153: (p_severity => c_log_level_2,
154: p_module => v_block||'.g_req_id{101}',
155: p_msg_text => g_req_id);
156: FEM_ENGINES_PKG.TECH_MESSAGE
157: (p_severity => c_log_level_2,
158: p_module => v_block||'.c_user_id{102}',
159: p_msg_text => c_user_id);
160: FEM_ENGINES_PKG.TECH_MESSAGE

Line 160: FEM_ENGINES_PKG.TECH_MESSAGE

156: FEM_ENGINES_PKG.TECH_MESSAGE
157: (p_severity => c_log_level_2,
158: p_module => v_block||'.c_user_id{102}',
159: p_msg_text => c_user_id);
160: FEM_ENGINES_PKG.TECH_MESSAGE
161: (p_severity => c_log_level_2,
162: p_module => v_block||'.g_obj_def_id{103}',
163: p_msg_text => g_obj_def_id);
164: FEM_ENGINES_PKG.TECH_MESSAGE

Line 164: FEM_ENGINES_PKG.TECH_MESSAGE

160: FEM_ENGINES_PKG.TECH_MESSAGE
161: (p_severity => c_log_level_2,
162: p_module => v_block||'.g_obj_def_id{103}',
163: p_msg_text => g_obj_def_id);
164: FEM_ENGINES_PKG.TECH_MESSAGE
165: (p_severity => c_log_level_2,
166: p_module => v_block||'.g_ledger_id{104}',
167: p_msg_text => g_ledger_id);
168: FEM_ENGINES_PKG.TECH_MESSAGE

Line 168: FEM_ENGINES_PKG.TECH_MESSAGE

164: FEM_ENGINES_PKG.TECH_MESSAGE
165: (p_severity => c_log_level_2,
166: p_module => v_block||'.g_ledger_id{104}',
167: p_msg_text => g_ledger_id);
168: FEM_ENGINES_PKG.TECH_MESSAGE
169: (p_severity => c_log_level_2,
170: p_module => v_block||'.g_dataset_cd{105}',
171: p_msg_text => g_dataset_cd);
172: FEM_ENGINES_PKG.TECH_MESSAGE

Line 172: FEM_ENGINES_PKG.TECH_MESSAGE

168: FEM_ENGINES_PKG.TECH_MESSAGE
169: (p_severity => c_log_level_2,
170: p_module => v_block||'.g_dataset_cd{105}',
171: p_msg_text => g_dataset_cd);
172: FEM_ENGINES_PKG.TECH_MESSAGE
173: (p_severity => c_log_level_2,
174: p_module => v_block||'.g_cal_per_id{106}',
175: p_msg_text => g_cal_per_id);
176: FEM_ENGINES_PKG.TECH_MESSAGE

Line 176: FEM_ENGINES_PKG.TECH_MESSAGE

172: FEM_ENGINES_PKG.TECH_MESSAGE
173: (p_severity => c_log_level_2,
174: p_module => v_block||'.g_cal_per_id{106}',
175: p_msg_text => g_cal_per_id);
176: FEM_ENGINES_PKG.TECH_MESSAGE
177: (p_severity => c_log_level_2,
178: p_module => v_block||'.g_source_cd{107}',
179: p_msg_text => g_source_cd);
180: FEM_ENGINES_PKG.TECH_MESSAGE

Line 180: FEM_ENGINES_PKG.TECH_MESSAGE

176: FEM_ENGINES_PKG.TECH_MESSAGE
177: (p_severity => c_log_level_2,
178: p_module => v_block||'.g_source_cd{107}',
179: p_msg_text => g_source_cd);
180: FEM_ENGINES_PKG.TECH_MESSAGE
181: (p_severity => c_log_level_2,
182: p_module => v_block||'.g_exec_mode{108}',
183: p_msg_text => g_exec_mode);
184:

Line 250: FEM_ENGINES_PKG.TECH_MESSAGE

246: p_arg28 => g_user_dim8_sql,
247: p_arg29 => g_user_dim9_sql,
248: p_arg30 => g_user_dim10_sql);
249:
250: FEM_ENGINES_PKG.TECH_MESSAGE
251: (p_severity => c_log_level_2,
252: p_module => v_block||'.v_prg_stat{109}',
253: p_msg_text => v_prg_stat);
254: FEM_ENGINES_PKG.TECH_MESSAGE

Line 254: FEM_ENGINES_PKG.TECH_MESSAGE

250: FEM_ENGINES_PKG.TECH_MESSAGE
251: (p_severity => c_log_level_2,
252: p_module => v_block||'.v_prg_stat{109}',
253: p_msg_text => v_prg_stat);
254: FEM_ENGINES_PKG.TECH_MESSAGE
255: (p_severity => c_log_level_2,
256: p_module => v_block||'.v_exception_code{110}',
257: p_msg_text => v_exception_code);
258:

Line 262: FEM_ENGINES_PKG.PUT_MESSAGE

258:
259: IF (v_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR')
260: THEN
261:
262: FEM_ENGINES_PKG.PUT_MESSAGE
263: (p_app_name => 'FEM',
264: p_msg_name => 'FEM_DATAX_LDR_NULL_SLICES_ERR',
265: p_token1 => 'TABLE',
266: p_value1 => g_data_t_table);

Line 269: FEM_ENGINES_PKG.TECH_MESSAGE

265: p_token1 => 'TABLE',
266: p_value1 => g_data_t_table);
267: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
268:
269: FEM_ENGINES_PKG.TECH_MESSAGE
270: (p_severity => c_log_level_2,
271: p_module => v_block||'.null_slices{111}',
272: p_msg_text => g_message);
273: FEM_ENGINES_PKG.USER_MESSAGE

Line 273: FEM_ENGINES_PKG.USER_MESSAGE

269: FEM_ENGINES_PKG.TECH_MESSAGE
270: (p_severity => c_log_level_2,
271: p_module => v_block||'.null_slices{111}',
272: p_msg_text => g_message);
273: FEM_ENGINES_PKG.USER_MESSAGE
274: (p_msg_text => g_message);
275: END IF;
276:
277: SELECT NVL(SUM(rows_processed),0),

Line 314: FEM_ENGINES_PKG.TECH_MESSAGE

310: FEM_Multi_Proc_Pkg.Delete_Data_Slices(
311: p_req_id => g_req_id);
312: END IF;
313:
314: FEM_ENGINES_PKG.TECH_MESSAGE
315: (p_severity => c_log_level_2,
316: p_module => v_block||'.g_rows_processed{112}',
317: p_msg_text => g_rows_processed);
318: FEM_ENGINES_PKG.TECH_MESSAGE

Line 318: FEM_ENGINES_PKG.TECH_MESSAGE

314: FEM_ENGINES_PKG.TECH_MESSAGE
315: (p_severity => c_log_level_2,
316: p_module => v_block||'.g_rows_processed{112}',
317: p_msg_text => g_rows_processed);
318: FEM_ENGINES_PKG.TECH_MESSAGE
319: (p_severity => c_log_level_2,
320: p_module => v_block||'.g_rows_loaded{113}',
321: p_msg_text => g_rows_loaded);
322: FEM_ENGINES_PKG.TECH_MESSAGE

Line 322: FEM_ENGINES_PKG.TECH_MESSAGE

318: FEM_ENGINES_PKG.TECH_MESSAGE
319: (p_severity => c_log_level_2,
320: p_module => v_block||'.g_rows_loaded{113}',
321: p_msg_text => g_rows_loaded);
322: FEM_ENGINES_PKG.TECH_MESSAGE
323: (p_severity => c_log_level_2,
324: p_module => v_block||'.g_rows_rejected{114}',
325: p_msg_text => g_rows_rejected);
326: FEM_ENGINES_PKG.TECH_MESSAGE

Line 326: FEM_ENGINES_PKG.TECH_MESSAGE

322: FEM_ENGINES_PKG.TECH_MESSAGE
323: (p_severity => c_log_level_2,
324: p_module => v_block||'.g_rows_rejected{114}',
325: p_msg_text => g_rows_rejected);
326: FEM_ENGINES_PKG.TECH_MESSAGE
327: (p_severity => c_log_level_2,
328: p_module => v_block||'.g_exec_status{115}',
329: p_msg_text => g_exec_status);
330:

Line 346: FEM_ENGINES_PKG.PUT_MESSAGE

342: -- Post Messages --
343: -------------------
344: IF (g_exec_status = 'SUCCESS')
345: THEN
346: FEM_ENGINES_PKG.PUT_MESSAGE
347: (p_app_name => 'FEM',
348: p_msg_name => 'FEM_EXEC_SUCCESS');
349: ELSE
350: FEM_ENGINES_PKG.PUT_MESSAGE

Line 350: FEM_ENGINES_PKG.PUT_MESSAGE

346: FEM_ENGINES_PKG.PUT_MESSAGE
347: (p_app_name => 'FEM',
348: p_msg_name => 'FEM_EXEC_SUCCESS');
349: ELSE
350: FEM_ENGINES_PKG.PUT_MESSAGE
351: (p_app_name => 'FEM',
352: p_msg_name => 'FEM_EXEC_RERUN');
353: END IF;
354:

Line 357: FEM_ENGINES_PKG.TECH_MESSAGE

353: END IF;
354:
355: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
356:
357: FEM_ENGINES_PKG.TECH_MESSAGE
358: (p_severity => c_log_level_2,
359: p_module => v_block||'.exec_status{120}',
360: p_msg_text => g_message);
361: FEM_ENGINES_PKG.USER_MESSAGE

Line 361: FEM_ENGINES_PKG.USER_MESSAGE

357: FEM_ENGINES_PKG.TECH_MESSAGE
358: (p_severity => c_log_level_2,
359: p_module => v_block||'.exec_status{120}',
360: p_msg_text => g_message);
361: FEM_ENGINES_PKG.USER_MESSAGE
362: (p_msg_text => g_message);
363:
364: IF (g_rows_rejected > 0)
365: THEN

Line 366: FEM_ENGINES_PKG.PUT_MESSAGE

362: (p_msg_text => g_message);
363:
364: IF (g_rows_rejected > 0)
365: THEN
366: FEM_ENGINES_PKG.PUT_MESSAGE
367: (p_app_name => 'FEM',
368: p_msg_name => 'FEM_DATAX_LDR_BAD_DATA_ERR',
369: p_token1 => 'COUNT',
370: p_value1 => g_rows_rejected);

Line 373: FEM_ENGINES_PKG.TECH_MESSAGE

369: p_token1 => 'COUNT',
370: p_value1 => g_rows_rejected);
371: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
372:
373: FEM_ENGINES_PKG.TECH_MESSAGE
374: (p_severity => c_log_level_2,
375: p_module => v_block||'.exec_status{121}',
376: p_msg_text => g_message);
377: FEM_ENGINES_PKG.USER_MESSAGE

Line 377: FEM_ENGINES_PKG.USER_MESSAGE

373: FEM_ENGINES_PKG.TECH_MESSAGE
374: (p_severity => c_log_level_2,
375: p_module => v_block||'.exec_status{121}',
376: p_msg_text => g_message);
377: FEM_ENGINES_PKG.USER_MESSAGE
378: (p_msg_text => g_message);
379:
380: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
381:

Line 384: FEM_ENGINES_PKG.TECH_MESSAGE

380: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
381:
382: END IF;
383:
384: FEM_ENGINES_PKG.TECH_MESSAGE
385: (p_severity => c_log_level_3,
386: p_module => v_block||'.End{130}',
387: p_msg_text => 'End FEM_DATAX_LOADER.Master');
388:

Line 399: FEM_ENGINES_PKG.TECH_MESSAGE

395:
396: ------- Clean-up -------
397: g_exec_status := 'ERROR_RERUN';
398:
399: FEM_ENGINES_PKG.TECH_MESSAGE
400: (p_severity => c_log_level_2,
401: p_module => v_block||'.g_upd_pl_on_err{190}',
402: p_msg_text => g_upd_pl_on_err);
403:

Line 411: FEM_ENGINES_PKG.PUT_MESSAGE

407: Post_Process;
408: END IF;
409:
410: ------- Post Error -------
411: FEM_ENGINES_PKG.PUT_MESSAGE
412: (p_app_name => 'FEM',
413: p_msg_name => 'FEM_DATAX_LDR_PROCESS_LOCK_ERR',
414: p_token1 => 'BLOCK',
415: p_value1 => g_block);

Line 419: FEM_ENGINES_PKG.TECH_MESSAGE

415: p_value1 => g_block);
416:
417: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
418:
419: FEM_ENGINES_PKG.TECH_MESSAGE
420: (p_severity => c_log_level_5,
421: p_module => v_block||'.Exception{191}',
422: p_msg_text => g_message);
423:

Line 424: FEM_ENGINES_PKG.USER_MESSAGE

420: (p_severity => c_log_level_5,
421: p_module => v_block||'.Exception{191}',
422: p_msg_text => g_message);
423:
424: FEM_ENGINES_PKG.USER_MESSAGE
425: (p_msg_text => g_message);
426:
427: ------- Post Status -------
428: FEM_ENGINES_PKG.PUT_MESSAGE

Line 428: FEM_ENGINES_PKG.PUT_MESSAGE

424: FEM_ENGINES_PKG.USER_MESSAGE
425: (p_msg_text => g_message);
426:
427: ------- Post Status -------
428: FEM_ENGINES_PKG.PUT_MESSAGE
429: (p_app_name => 'FEM',
430: p_msg_name => 'FEM_EXEC_RERUN');
431:
432: g_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 434: FEM_ENGINES_PKG.TECH_MESSAGE

430: p_msg_name => 'FEM_EXEC_RERUN');
431:
432: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
433:
434: FEM_ENGINES_PKG.TECH_MESSAGE
435: (p_severity => c_log_level_2,
436: p_module => v_block||'.Process_Lock_Error{192}',
437: p_msg_text => g_message);
438:

Line 439: FEM_ENGINES_PKG.USER_MESSAGE

435: (p_severity => c_log_level_2,
436: p_module => v_block||'.Process_Lock_Error{192}',
437: p_msg_text => g_message);
438:
439: FEM_ENGINES_PKG.USER_MESSAGE
440: (p_msg_text => g_message);
441:
442: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
443:

Line 449: FEM_ENGINES_PKG.TECH_MESSAGE

445:
446: ------- Clean-up -------
447: g_exec_status := 'ERROR_RERUN';
448:
449: FEM_ENGINES_PKG.TECH_MESSAGE
450: (p_severity => c_log_level_2,
451: p_module => v_block||'.g_upd_pl_on_err{190}',
452: p_msg_text => g_upd_pl_on_err);
453:

Line 461: FEM_ENGINES_PKG.TECH_MESSAGE

457: Post_Process;
458: END IF;
459:
460: ------- Post Error -------
461: FEM_ENGINES_PKG.TECH_MESSAGE
462: (p_severity => c_log_level_5,
463: p_module => v_block||'.Exception{'||g_msg_no||'}',
464: p_msg_text => g_message);
465:

Line 466: FEM_ENGINES_PKG.USER_MESSAGE

462: (p_severity => c_log_level_5,
463: p_module => v_block||'.Exception{'||g_msg_no||'}',
464: p_msg_text => g_message);
465:
466: FEM_ENGINES_PKG.USER_MESSAGE
467: (p_msg_text => g_message);
468:
469: ------- Post Status -------
470: FEM_ENGINES_PKG.PUT_MESSAGE

Line 470: FEM_ENGINES_PKG.PUT_MESSAGE

466: FEM_ENGINES_PKG.USER_MESSAGE
467: (p_msg_text => g_message);
468:
469: ------- Post Status -------
470: FEM_ENGINES_PKG.PUT_MESSAGE
471: (p_app_name => 'FEM',
472: p_msg_name => 'FEM_EXEC_RERUN');
473:
474: g_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 476: FEM_ENGINES_PKG.TECH_MESSAGE

472: p_msg_name => 'FEM_EXEC_RERUN');
473:
474: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
475:
476: FEM_ENGINES_PKG.TECH_MESSAGE
477: (p_severity => c_log_level_2,
478: p_module => v_block||'.Validation_Error{192}',
479: p_msg_text => g_message);
480:

Line 481: FEM_ENGINES_PKG.USER_MESSAGE

477: (p_severity => c_log_level_2,
478: p_module => v_block||'.Validation_Error{192}',
479: p_msg_text => g_message);
480:
481: FEM_ENGINES_PKG.USER_MESSAGE
482: (p_msg_text => g_message);
483:
484: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
485:

Line 492: FEM_ENGINES_PKG.TECH_MESSAGE

488:
489: ------- Clean-up -------
490: g_exec_status := 'ERROR_RERUN';
491:
492: FEM_ENGINES_PKG.TECH_MESSAGE
493: (p_severity => c_log_level_2,
494: p_module => v_block||'.g_upd_pl_on_err{190}',
495: p_msg_text => g_upd_pl_on_err);
496:

Line 504: FEM_ENGINES_PKG.PUT_MESSAGE

500: Post_Process;
501: END IF;
502:
503: ------- Post Error -------
504: FEM_ENGINES_PKG.PUT_MESSAGE
505: (p_app_name => 'FEM',
506: p_msg_name => 'FEM_UNEXPECTED_ERROR',
507: p_token1 => 'ERR_MSG',
508: p_value1 => g_message);

Line 512: FEM_ENGINES_PKG.TECH_MESSAGE

508: p_value1 => g_message);
509:
510: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
511:
512: FEM_ENGINES_PKG.TECH_MESSAGE
513: (p_severity => c_log_level_2,
514: p_module => v_block||'.Exception{194}',
515: p_msg_text => g_message);
516:

Line 517: FEM_ENGINES_PKG.USER_MESSAGE

513: (p_severity => c_log_level_2,
514: p_module => v_block||'.Exception{194}',
515: p_msg_text => g_message);
516:
517: FEM_ENGINES_PKG.USER_MESSAGE
518: (p_msg_text => g_message);
519:
520: ------- Post Status -------
521: FEM_ENGINES_PKG.PUT_MESSAGE

Line 521: FEM_ENGINES_PKG.PUT_MESSAGE

517: FEM_ENGINES_PKG.USER_MESSAGE
518: (p_msg_text => g_message);
519:
520: ------- Post Status -------
521: FEM_ENGINES_PKG.PUT_MESSAGE
522: (p_app_name => 'FEM',
523: p_msg_name => 'FEM_EXEC_RERUN');
524:
525: g_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 527: FEM_ENGINES_PKG.TECH_MESSAGE

523: p_msg_name => 'FEM_EXEC_RERUN');
524:
525: g_message := FND_MSG_PUB.GET(p_encoded => c_false);
526:
527: FEM_ENGINES_PKG.TECH_MESSAGE
528: (p_severity => c_log_level_2,
529: p_module => v_block||'.Unexpected_Error{195}',
530: p_msg_text => g_message);
531:

Line 532: FEM_ENGINES_PKG.USER_MESSAGE

528: (p_severity => c_log_level_2,
529: p_module => v_block||'.Unexpected_Error{195}',
530: p_msg_text => g_message);
531:
532: FEM_ENGINES_PKG.USER_MESSAGE
533: (p_msg_text => g_message);
534:
535: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
536:

Line 638: FEM_ENGINES_PKG.TECH_MESSAGE

634: e_no_data_match EXCEPTION;
635:
636: BEGIN
637:
638: FEM_ENGINES_PKG.TECH_MESSAGE
639: (p_severity => c_log_level_3,
640: p_module => v_block||'.Begin{200}',
641: p_msg_text => 'Begin FEM_DATAX_LOADER.Validation');
642:

Line 671: FEM_ENGINES_PKG.TECH_MESSAGE

667: WHEN no_data_found THEN
668: RAISE e_bad_obj_def;
669: END;
670:
671: FEM_ENGINES_PKG.TECH_MESSAGE
672: (p_severity => c_log_level_2,
673: p_module => v_block||'.g_object_id{201}',
674: p_msg_text => g_object_id);
675:

Line 705: FEM_ENGINES_PKG.TECH_MESSAGE

701: THEN
702: g_data_table := g_table_name;
703: END IF;
704:
705: FEM_ENGINES_PKG.TECH_MESSAGE
706: (p_severity => c_log_level_2,
707: p_module => v_block||'.g_data_table{202}',
708: p_msg_text => g_data_table);
709:

Line 732: FEM_ENGINES_PKG.TECH_MESSAGE

728: FOR r_proc_key IN c_proc_key
729: LOOP
730: v_proc_col := r_proc_key.column_name;
731:
732: FEM_ENGINES_PKG.TECH_MESSAGE
733: (p_severity => c_log_level_1,
734: p_module => v_block||'.v_proc_col{204}',
735: p_msg_text => v_proc_col);
736:

Line 803: FEM_ENGINES_PKG.TECH_MESSAGE

799: END CASE;
800:
801: END IF;
802:
803: FEM_ENGINES_PKG.TECH_MESSAGE
804: (p_severity => c_log_level_1,
805: p_module => v_block||'.v_dc_col{205}',
806: p_msg_text => v_dc_col);
807:

Line 818: FEM_ENGINES_PKG.TECH_MESSAGE

814: END IF;
815: END LOOP;
816: v_pk_count := v_pk_count + v_pk_add;
817:
818: FEM_ENGINES_PKG.TECH_MESSAGE
819: (p_severity => c_log_level_2,
820: p_module => v_block||'.v_proc_cols{207}',
821: p_msg_text => v_proc_cols);
822:

Line 828: FEM_ENGINES_PKG.TECH_MESSAGE

824: THEN
825: RAISE e_no_proc_key;
826: END IF;
827:
828: FEM_ENGINES_PKG.TECH_MESSAGE
829: (p_severity => c_log_level_2,
830: p_module => v_block||'.v_pk_count{208}',
831: p_msg_text => v_pk_count);
832:

Line 840: FEM_ENGINES_PKG.TECH_MESSAGE

836: FOR r_uniq_idx IN c_uniq_idx
837: LOOP
838: v_uniq_idx := r_uniq_idx.index_name;
839:
840: FEM_ENGINES_PKG.TECH_MESSAGE
841: (p_severity => c_log_level_2,
842: p_module => v_block||'.v_uniq_idx{211}',
843: p_msg_text => v_uniq_idx);
844:

Line 872: FEM_ENGINES_PKG.TECH_MESSAGE

868: END IF;
869: END IF;
870: END LOOP;
871:
872: FEM_ENGINES_PKG.TECH_MESSAGE
873: (p_severity => c_log_level_2,
874: p_module => v_block||'.v_ui_count{212}',
875: p_msg_text => v_ui_count);
876: FEM_ENGINES_PKG.TECH_MESSAGE

Line 876: FEM_ENGINES_PKG.TECH_MESSAGE

872: FEM_ENGINES_PKG.TECH_MESSAGE
873: (p_severity => c_log_level_2,
874: p_module => v_block||'.v_ui_count{212}',
875: p_msg_text => v_ui_count);
876: FEM_ENGINES_PKG.TECH_MESSAGE
877: (p_severity => c_log_level_2,
878: p_module => v_block||'.v_proc_key_ok{213}',
879: p_msg_text => v_proc_key_ok);
880:

Line 921: FEM_ENGINES_PKG.TECH_MESSAGE

917: AND V.default_version_flag = 'Y'
918: AND D.dimension_id = T.dimension_id
919: AND D.dimension_varchar_label = 'LEDGER';
920:
921: FEM_ENGINES_PKG.TECH_MESSAGE
922: (p_severity => c_log_level_2,
923: p_module => v_block||'.g_ledger_id{215}',
924: p_msg_text => g_ledger_id||':COUNT='||v_count);
925:

Line 942: FEM_ENGINES_PKG.TECH_MESSAGE

938: x_msg_count => v_msg_count,
939: x_msg_data => g_message,
940: p_ledger_id => g_ledger_id);
941:
942: FEM_ENGINES_PKG.TECH_MESSAGE
943: (p_severity => c_log_level_2,
944: p_module => v_block||'.g_gvc_id{217}',
945: p_msg_text => g_gvc_id);
946:

Line 982: FEM_ENGINES_PKG.TECH_MESSAGE

978: AND V.default_version_flag = 'Y'
979: AND D.dimension_id = T.dimension_id
980: AND D.dimension_varchar_label = 'DATASET';
981:
982: FEM_ENGINES_PKG.TECH_MESSAGE
983: (p_severity => c_log_level_2,
984: p_module => v_block||'.g_dataset_cd{218}',
985: p_msg_text => g_dataset_cd||':COUNT='||v_count);
986:

Line 1005: FEM_ENGINES_PKG.TECH_MESSAGE

1001: WHEN no_data_found THEN
1002: RAISE e_bad_source_cd;
1003: END;
1004:
1005: FEM_ENGINES_PKG.TECH_MESSAGE
1006: (p_severity => c_log_level_2,
1007: p_module => v_block||'.v_source_dc{220}',
1008: p_msg_text => v_source_dc);
1009:

Line 1052: FEM_ENGINES_PKG.TECH_MESSAGE

1048: AND D.version_id = DV.version_id
1049: AND D.cal_period_id = g_cal_per_id
1050: AND DV.default_version_flag = 'Y';
1051:
1052: FEM_ENGINES_PKG.TECH_MESSAGE
1053: (p_severity => c_log_level_2,
1054: p_module => v_block||'.v_dim_grp_cd{230}',
1055: p_msg_text => v_dim_grp_cd);
1056: FEM_ENGINES_PKG.TECH_MESSAGE

Line 1056: FEM_ENGINES_PKG.TECH_MESSAGE

1052: FEM_ENGINES_PKG.TECH_MESSAGE
1053: (p_severity => c_log_level_2,
1054: p_module => v_block||'.v_dim_grp_cd{230}',
1055: p_msg_text => v_dim_grp_cd);
1056: FEM_ENGINES_PKG.TECH_MESSAGE
1057: (p_severity => c_log_level_2,
1058: p_module => v_block||'.v_cal_per_end_date{232}',
1059: p_msg_text => TO_CHAR(v_cal_per_end_date,'YYYY/MM/DD HH24:MI:SS'));
1060: FEM_ENGINES_PKG.TECH_MESSAGE

Line 1060: FEM_ENGINES_PKG.TECH_MESSAGE

1056: FEM_ENGINES_PKG.TECH_MESSAGE
1057: (p_severity => c_log_level_2,
1058: p_module => v_block||'.v_cal_per_end_date{232}',
1059: p_msg_text => TO_CHAR(v_cal_per_end_date,'YYYY/MM/DD HH24:MI:SS'));
1060: FEM_ENGINES_PKG.TECH_MESSAGE
1061: (p_severity => c_log_level_2,
1062: p_module => v_block||'.v_cal_per_num{234}',
1063: p_msg_text => v_cal_per_num);
1064:

Line 1092: FEM_ENGINES_PKG.TECH_MESSAGE

1088: v_ledger_dc,
1089: v_dataset_dc,
1090: v_source_dc;
1091:
1092: FEM_ENGINES_PKG.TECH_MESSAGE
1093: (p_severity => c_log_level_2,
1094: p_module => v_block||'.data_match{236}',
1095: p_msg_text => 'data_match='||v_count);
1096:

Line 1119: FEM_ENGINES_PKG.TECH_MESSAGE

1115: ELSE
1116: g_condition := g_condition||' AND status <> ''LOAD''';
1117: END IF;
1118:
1119: FEM_ENGINES_PKG.TECH_MESSAGE
1120: (p_severity => c_log_level_3,
1121: p_module => v_block||'.End{240}',
1122: p_msg_text => 'End FEM_DATAX_LOADER.Validation');
1123:

Line 1130: FEM_ENGINES_PKG.PUT_MESSAGE

1126: ---------------------
1127: EXCEPTION
1128:
1129: WHEN e_bad_exec_mode THEN
1130: FEM_ENGINES_PKG.PUT_MESSAGE
1131: (p_app_name => 'FEM',
1132: p_msg_name => 'FEM_DATAX_LDR_BAD_EXEC_ERR');
1133:
1134: g_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 1140: FEM_ENGINES_PKG.PUT_MESSAGE

1136:
1137: RAISE e_validation_error;
1138:
1139: WHEN e_bad_obj_def THEN
1140: FEM_ENGINES_PKG.PUT_MESSAGE
1141: (p_app_name => 'FEM',
1142: p_msg_name => 'FEM_DATAX_LDR_BAD_OBJ_ERR',
1143: p_token1 => 'OBJECT',
1144: p_value1 => g_obj_def_id);

Line 1152: FEM_ENGINES_PKG.PUT_MESSAGE

1148:
1149: RAISE e_validation_error;
1150:
1151: WHEN e_bad_target_table THEN
1152: FEM_ENGINES_PKG.PUT_MESSAGE
1153: (p_app_name => 'FEM',
1154: p_msg_name => 'FEM_DATAX_LDR_BAD_TABLE_ERR',
1155: p_token1 => 'TABLE',
1156: p_value1 => g_data_table);

Line 1164: FEM_ENGINES_PKG.PUT_MESSAGE

1160:
1161: RAISE e_validation_error;
1162:
1163: WHEN e_no_proc_key THEN
1164: FEM_ENGINES_PKG.PUT_MESSAGE
1165: (p_app_name => 'FEM',
1166: p_msg_name => 'FEM_DATAX_LDR_NO_PROC_KEY_ERR',
1167: p_token1 => 'TABLE',
1168: p_value1 => g_data_table);

Line 1176: FEM_ENGINES_PKG.PUT_MESSAGE

1172:
1173: RAISE e_validation_error;
1174:
1175: WHEN e_bad_proc_key THEN
1176: FEM_ENGINES_PKG.PUT_MESSAGE
1177: (p_app_name => 'FEM',
1178: p_msg_name => 'FEM_DATAX_LDR_BAD_PROC_KEY_ERR',
1179: p_token1 => 'COLUMN',
1180: p_value1 => v_proc_col);

Line 1188: FEM_ENGINES_PKG.PUT_MESSAGE

1184:
1185: RAISE e_validation_error;
1186:
1187: WHEN e_no_unq_idx THEN
1188: FEM_ENGINES_PKG.PUT_MESSAGE
1189: (p_app_name => 'FEM',
1190: p_msg_name => 'FEM_DATAX_LDR_NO_UNIQ_IDX_ERR',
1191: p_token1 => 'TABLE',
1192: p_value1 => g_data_t_table);

Line 1200: FEM_ENGINES_PKG.PUT_MESSAGE

1196:
1197: RAISE e_validation_error;
1198:
1199: WHEN e_no_pk_match THEN
1200: FEM_ENGINES_PKG.PUT_MESSAGE
1201: (p_app_name => 'FEM',
1202: p_msg_name => 'FEM_DATAX_LDR_NO_PK_MATCH_ERR');
1203:
1204: g_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 1210: FEM_ENGINES_PKG.PUT_MESSAGE

1206:
1207: RAISE e_validation_error;
1208:
1209: WHEN e_bad_ledger_id THEN
1210: FEM_ENGINES_PKG.PUT_MESSAGE
1211: (p_app_name => 'FEM',
1212: p_msg_name => 'FEM_DATAX_LDR_BAD_LEDGER_ERR',
1213: p_token1 => 'LEDGER',
1214: p_value1 => g_ledger_id);

Line 1222: FEM_ENGINES_PKG.PUT_MESSAGE

1218:
1219: RAISE e_validation_error;
1220:
1221: WHEN e_bad_ledger_attr THEN
1222: FEM_ENGINES_PKG.PUT_MESSAGE
1223: (p_app_name => 'FEM',
1224: p_msg_name => 'FEM_DATAX_LDR_LEDGER_ATTR_ERR',
1225: p_token1 => 'LEDGER',
1226: p_value1 => v_ledger_name);

Line 1239: FEM_ENGINES_PKG.PUT_MESSAGE

1235: g_msg_no := 250;
1236: RAISE e_validation_error;
1237:
1238: WHEN e_bad_dataset_cd THEN
1239: FEM_ENGINES_PKG.PUT_MESSAGE
1240: (p_app_name => 'FEM',
1241: p_msg_name => 'FEM_DATAX_LDR_BAD_DATASET_ERR',
1242: p_token1 => 'DATASET',
1243: p_value1 => g_dataset_cd);

Line 1251: FEM_ENGINES_PKG.PUT_MESSAGE

1247:
1248: RAISE e_validation_error;
1249:
1250: WHEN e_bad_dataset_attr THEN
1251: FEM_ENGINES_PKG.PUT_MESSAGE
1252: (p_app_name => 'FEM',
1253: p_msg_name => 'FEM_DATAX_LDR_DATASET_ATTR_ERR',
1254: p_token1 => 'DATASET',
1255: p_value1 => v_dataset_name);

Line 1263: FEM_ENGINES_PKG.PUT_MESSAGE

1259:
1260: RAISE e_validation_error;
1261:
1262: WHEN e_bad_source_cd THEN
1263: FEM_ENGINES_PKG.PUT_MESSAGE
1264: (p_app_name => 'FEM',
1265: p_msg_name => 'FEM_DATAX_LDR_BAD_SOURCE_ERR',
1266: p_token1 => 'SOURCE',
1267: p_value1 => g_source_cd);

Line 1275: FEM_ENGINES_PKG.PUT_MESSAGE

1271:
1272: RAISE e_validation_error;
1273:
1274: WHEN e_bad_cal_per_id THEN
1275: FEM_ENGINES_PKG.PUT_MESSAGE
1276: (p_app_name => 'FEM',
1277: p_msg_name => 'FEM_DATAX_LDR_BAD_CAL_PER_ERR',
1278: p_token1 => 'CAL_PER',
1279: p_value1 => v_cal_period);

Line 1287: FEM_ENGINES_PKG.PUT_MESSAGE

1283:
1284: RAISE e_validation_error;
1285:
1286: WHEN e_no_data_match THEN
1287: FEM_ENGINES_PKG.PUT_MESSAGE
1288: (p_app_name => 'FEM',
1289: p_msg_name => 'FEM_DATAX_LDR_DATA_MATCH_ERR',
1290: p_token1 => 'TABLE',
1291: p_value1 => g_data_t_table,

Line 1339: FEM_ENGINES_PKG.TECH_MESSAGE

1335: 'fem.plsql.fem_datax_loader_pkg.registration';
1336:
1337: BEGIN
1338:
1339: FEM_ENGINES_PKG.TECH_MESSAGE
1340: (p_severity => c_log_level_3,
1341: p_module => v_block||'.Begin{300}',
1342: p_msg_text => 'Begin FEM_DATAX_LOADER.Registration');
1343:

Line 1371: FEM_ENGINES_PKG.TECH_MESSAGE

1367: x_msg_count => v_msg_count,
1368: x_msg_data => v_msg_data,
1369: x_return_status => v_return_status);
1370:
1371: FEM_ENGINES_PKG.TECH_MESSAGE
1372: (p_severity => c_log_level_2,
1373: p_module => v_block||'.register_request.return_status{301}',
1374: p_msg_text => v_return_status);
1375:

Line 1402: FEM_ENGINES_PKG.TECH_MESSAGE

1398: x_msg_count => v_msg_count,
1399: x_msg_data => v_msg_data,
1400: x_return_status => v_return_status);
1401:
1402: FEM_ENGINES_PKG.TECH_MESSAGE
1403: (p_severity => c_log_level_2,
1404: p_module => v_block||'.v_exec_state{302}',
1405: p_msg_text => v_exec_state);
1406: FEM_ENGINES_PKG.TECH_MESSAGE

Line 1406: FEM_ENGINES_PKG.TECH_MESSAGE

1402: FEM_ENGINES_PKG.TECH_MESSAGE
1403: (p_severity => c_log_level_2,
1404: p_module => v_block||'.v_exec_state{302}',
1405: p_msg_text => v_exec_state);
1406: FEM_ENGINES_PKG.TECH_MESSAGE
1407: (p_severity => c_log_level_2,
1408: p_module => v_block||'.v_prev_req_id{303}',
1409: p_msg_text => v_prev_req_id);
1410: FEM_ENGINES_PKG.TECH_MESSAGE

Line 1410: FEM_ENGINES_PKG.TECH_MESSAGE

1406: FEM_ENGINES_PKG.TECH_MESSAGE
1407: (p_severity => c_log_level_2,
1408: p_module => v_block||'.v_prev_req_id{303}',
1409: p_msg_text => v_prev_req_id);
1410: FEM_ENGINES_PKG.TECH_MESSAGE
1411: (p_severity => c_log_level_2,
1412: p_module => v_block||'.object_execution.return_status{304}',
1413: p_msg_text => v_return_status);
1414:

Line 1429: FEM_ENGINES_PKG.TECH_MESSAGE

1425: x_msg_count => v_msg_count,
1426: x_msg_data => v_msg_data,
1427: x_return_status => v_return_status);
1428:
1429: FEM_ENGINES_PKG.TECH_MESSAGE
1430: (p_severity => c_log_level_2,
1431: p_module => v_block||'.unregister_request.return_status{305}',
1432: p_msg_text => v_return_status);
1433:

Line 1457: FEM_ENGINES_PKG.TECH_MESSAGE

1453: x_msg_count => v_msg_count,
1454: x_msg_data => v_msg_data,
1455: x_return_status => v_return_status);
1456:
1457: FEM_ENGINES_PKG.TECH_MESSAGE
1458: (p_severity => c_log_level_2,
1459: p_module => v_block||'.register_object_def.return_status{306}',
1460: p_msg_text => v_return_status);
1461:

Line 1487: FEM_ENGINES_PKG.TECH_MESSAGE

1483: x_msg_count => v_msg_count,
1484: x_msg_data => v_msg_data,
1485: x_return_status => v_return_status);
1486:
1487: FEM_ENGINES_PKG.TECH_MESSAGE
1488: (p_severity => c_log_level_2,
1489: p_module => v_block||'.register_table.return_status{307}',
1490: p_msg_text => v_return_status);
1491:

Line 1514: FEM_ENGINES_PKG.TECH_MESSAGE

1510: p_dataset_cd => g_dataset_cd,
1511: p_source_cd => g_source_cd,
1512: p_load_status => 'INCOMPLETE');
1513:
1514: FEM_ENGINES_PKG.TECH_MESSAGE
1515: (p_severity => c_log_level_3,
1516: p_module => v_block||'.End{320}',
1517: p_msg_text => 'End FEM_DATAX_LOADER.Registration');
1518:

Line 1628: FEM_ENGINES_PKG.TECH_MESSAGE

1624: 'fem.plsql.fem_datax_loader_pkg.pre_process';
1625:
1626: BEGIN
1627:
1628: FEM_ENGINES_PKG.TECH_MESSAGE
1629: (p_severity => c_log_level_3,
1630: p_module => v_block||'.Begin{400}',
1631: p_msg_text => 'Begin FEM_DATAX_LOADER.Pre_Process');
1632:

Line 2134: FEM_ENGINES_PKG.TECH_MESSAGE

2130: ' FROM '||g_data_t_table||
2131: ' WHERE '||g_condition||
2132: ' AND {{data_slice}} ';
2133:
2134: FEM_ENGINES_PKG.TECH_MESSAGE
2135: (p_severity => c_log_level_3,
2136: p_module => v_block||'.End{410}',
2137: p_msg_text => 'End FEM_DATAX_LOADER.Pre_Process');
2138:

Line 2307: FEM_ENGINES_PKG.TECH_MESSAGE

2303:
2304: v_block := 'fem.plsql.fem_datax_loader_pkg.process_rows'||
2305: '{p'||p_proc_num||'}';
2306:
2307: FEM_ENGINES_PKG.TECH_MESSAGE
2308: (p_severity => c_log_level_3,
2309: p_module => v_block||'.Begin{800}',
2310: p_msg_text => 'Begin FEM_DATAX_LOADER.Process_Rows');
2311: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2311: FEM_ENGINES_PKG.TECH_MESSAGE

2307: FEM_ENGINES_PKG.TECH_MESSAGE
2308: (p_severity => c_log_level_3,
2309: p_module => v_block||'.Begin{800}',
2310: p_msg_text => 'Begin FEM_DATAX_LOADER.Process_Rows');
2311: FEM_ENGINES_PKG.TECH_MESSAGE
2312: (p_severity => c_log_level_1,
2313: p_module => v_block||'.p_eng_sql{801}',
2314: p_msg_text => p_eng_sql);
2315: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2315: FEM_ENGINES_PKG.TECH_MESSAGE

2311: FEM_ENGINES_PKG.TECH_MESSAGE
2312: (p_severity => c_log_level_1,
2313: p_module => v_block||'.p_eng_sql{801}',
2314: p_msg_text => p_eng_sql);
2315: FEM_ENGINES_PKG.TECH_MESSAGE
2316: (p_severity => c_log_level_2,
2317: p_module => v_block||'.p_slc_pred{802}',
2318: p_msg_text => p_slc_pred);
2319: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2319: FEM_ENGINES_PKG.TECH_MESSAGE

2315: FEM_ENGINES_PKG.TECH_MESSAGE
2316: (p_severity => c_log_level_2,
2317: p_module => v_block||'.p_slc_pred{802}',
2318: p_msg_text => p_slc_pred);
2319: FEM_ENGINES_PKG.TECH_MESSAGE
2320: (p_severity => c_log_level_2,
2321: p_module => v_block||'.p_proc_num{803}',
2322: p_msg_text => p_proc_num);
2323: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2323: FEM_ENGINES_PKG.TECH_MESSAGE

2319: FEM_ENGINES_PKG.TECH_MESSAGE
2320: (p_severity => c_log_level_2,
2321: p_module => v_block||'.p_proc_num{803}',
2322: p_msg_text => p_proc_num);
2323: FEM_ENGINES_PKG.TECH_MESSAGE
2324: (p_severity => c_log_level_2,
2325: p_module => v_block||'.p_part_code{804}',
2326: p_msg_text => p_part_code);
2327: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2327: FEM_ENGINES_PKG.TECH_MESSAGE

2323: FEM_ENGINES_PKG.TECH_MESSAGE
2324: (p_severity => c_log_level_2,
2325: p_module => v_block||'.p_part_code{804}',
2326: p_msg_text => p_part_code);
2327: FEM_ENGINES_PKG.TECH_MESSAGE
2328: (p_severity => c_log_level_2,
2329: p_module => v_block||'.p_fetch_limit{805}',
2330: p_msg_text => p_fetch_limit);
2331: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2331: FEM_ENGINES_PKG.TECH_MESSAGE

2327: FEM_ENGINES_PKG.TECH_MESSAGE
2328: (p_severity => c_log_level_2,
2329: p_module => v_block||'.p_fetch_limit{805}',
2330: p_msg_text => p_fetch_limit);
2331: FEM_ENGINES_PKG.TECH_MESSAGE
2332: (p_severity => c_log_level_2,
2333: p_module => v_block||'.p_data_table{806}',
2334: p_msg_text => p_data_table);
2335: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2335: FEM_ENGINES_PKG.TECH_MESSAGE

2331: FEM_ENGINES_PKG.TECH_MESSAGE
2332: (p_severity => c_log_level_2,
2333: p_module => v_block||'.p_data_table{806}',
2334: p_msg_text => p_data_table);
2335: FEM_ENGINES_PKG.TECH_MESSAGE
2336: (p_severity => c_log_level_2,
2337: p_module => v_block||'.p_object_id{807}',
2338: p_msg_text => p_object_id);
2339: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2339: FEM_ENGINES_PKG.TECH_MESSAGE

2335: FEM_ENGINES_PKG.TECH_MESSAGE
2336: (p_severity => c_log_level_2,
2337: p_module => v_block||'.p_object_id{807}',
2338: p_msg_text => p_object_id);
2339: FEM_ENGINES_PKG.TECH_MESSAGE
2340: (p_severity => c_log_level_2,
2341: p_module => v_block||'.p_ledger_id{808}',
2342: p_msg_text => p_ledger_id);
2343: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2343: FEM_ENGINES_PKG.TECH_MESSAGE

2339: FEM_ENGINES_PKG.TECH_MESSAGE
2340: (p_severity => c_log_level_2,
2341: p_module => v_block||'.p_ledger_id{808}',
2342: p_msg_text => p_ledger_id);
2343: FEM_ENGINES_PKG.TECH_MESSAGE
2344: (p_severity => c_log_level_2,
2345: p_module => v_block||'.p_dataset_cd{809}',
2346: p_msg_text => p_dataset_cd);
2347: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2347: FEM_ENGINES_PKG.TECH_MESSAGE

2343: FEM_ENGINES_PKG.TECH_MESSAGE
2344: (p_severity => c_log_level_2,
2345: p_module => v_block||'.p_dataset_cd{809}',
2346: p_msg_text => p_dataset_cd);
2347: FEM_ENGINES_PKG.TECH_MESSAGE
2348: (p_severity => c_log_level_2,
2349: p_module => v_block||'.p_cal_per_id{810}',
2350: p_msg_text => p_cal_per_id);
2351: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2351: FEM_ENGINES_PKG.TECH_MESSAGE

2347: FEM_ENGINES_PKG.TECH_MESSAGE
2348: (p_severity => c_log_level_2,
2349: p_module => v_block||'.p_cal_per_id{810}',
2350: p_msg_text => p_cal_per_id);
2351: FEM_ENGINES_PKG.TECH_MESSAGE
2352: (p_severity => c_log_level_2,
2353: p_module => v_block||'.p_source_cd{811}',
2354: p_msg_text => p_source_cd);
2355: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2355: FEM_ENGINES_PKG.TECH_MESSAGE

2351: FEM_ENGINES_PKG.TECH_MESSAGE
2352: (p_severity => c_log_level_2,
2353: p_module => v_block||'.p_source_cd{811}',
2354: p_msg_text => p_source_cd);
2355: FEM_ENGINES_PKG.TECH_MESSAGE
2356: (p_severity => c_log_level_2,
2357: p_module => v_block||'.p_req_id{812}',
2358: p_msg_text => p_req_id);
2359: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2359: FEM_ENGINES_PKG.TECH_MESSAGE

2355: FEM_ENGINES_PKG.TECH_MESSAGE
2356: (p_severity => c_log_level_2,
2357: p_module => v_block||'.p_req_id{812}',
2358: p_msg_text => p_req_id);
2359: FEM_ENGINES_PKG.TECH_MESSAGE
2360: (p_severity => c_log_level_1,
2361: p_module => v_block||'.p_cctr_org_sql{813.1}',
2362: p_msg_text => p_cctr_org_sql);
2363: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2363: FEM_ENGINES_PKG.TECH_MESSAGE

2359: FEM_ENGINES_PKG.TECH_MESSAGE
2360: (p_severity => c_log_level_1,
2361: p_module => v_block||'.p_cctr_org_sql{813.1}',
2362: p_msg_text => p_cctr_org_sql);
2363: FEM_ENGINES_PKG.TECH_MESSAGE
2364: (p_severity => c_log_level_1,
2365: p_module => v_block||'.p_fin_elem_sql{813.2}',
2366: p_msg_text => p_fin_elem_sql);
2367: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2367: FEM_ENGINES_PKG.TECH_MESSAGE

2363: FEM_ENGINES_PKG.TECH_MESSAGE
2364: (p_severity => c_log_level_1,
2365: p_module => v_block||'.p_fin_elem_sql{813.2}',
2366: p_msg_text => p_fin_elem_sql);
2367: FEM_ENGINES_PKG.TECH_MESSAGE
2368: (p_severity => c_log_level_1,
2369: p_module => v_block||'.p_product_sql{813.3}',
2370: p_msg_text => p_product_sql);
2371: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2371: FEM_ENGINES_PKG.TECH_MESSAGE

2367: FEM_ENGINES_PKG.TECH_MESSAGE
2368: (p_severity => c_log_level_1,
2369: p_module => v_block||'.p_product_sql{813.3}',
2370: p_msg_text => p_product_sql);
2371: FEM_ENGINES_PKG.TECH_MESSAGE
2372: (p_severity => c_log_level_1,
2373: p_module => v_block||'.p_nat_acct_sql{813.4}',
2374: p_msg_text => p_nat_acct_sql);
2375: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2375: FEM_ENGINES_PKG.TECH_MESSAGE

2371: FEM_ENGINES_PKG.TECH_MESSAGE
2372: (p_severity => c_log_level_1,
2373: p_module => v_block||'.p_nat_acct_sql{813.4}',
2374: p_msg_text => p_nat_acct_sql);
2375: FEM_ENGINES_PKG.TECH_MESSAGE
2376: (p_severity => c_log_level_1,
2377: p_module => v_block||'.p_channel_sql{813.5}',
2378: p_msg_text => p_channel_sql);
2379: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2379: FEM_ENGINES_PKG.TECH_MESSAGE

2375: FEM_ENGINES_PKG.TECH_MESSAGE
2376: (p_severity => c_log_level_1,
2377: p_module => v_block||'.p_channel_sql{813.5}',
2378: p_msg_text => p_channel_sql);
2379: FEM_ENGINES_PKG.TECH_MESSAGE
2380: (p_severity => c_log_level_1,
2381: p_module => v_block||'.p_line_item_sql{813.6}',
2382: p_msg_text => p_line_item_sql);
2383: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2383: FEM_ENGINES_PKG.TECH_MESSAGE

2379: FEM_ENGINES_PKG.TECH_MESSAGE
2380: (p_severity => c_log_level_1,
2381: p_module => v_block||'.p_line_item_sql{813.6}',
2382: p_msg_text => p_line_item_sql);
2383: FEM_ENGINES_PKG.TECH_MESSAGE
2384: (p_severity => c_log_level_1,
2385: p_module => v_block||'.p_project_sql{813.7}',
2386: p_msg_text => p_project_sql);
2387: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2387: FEM_ENGINES_PKG.TECH_MESSAGE

2383: FEM_ENGINES_PKG.TECH_MESSAGE
2384: (p_severity => c_log_level_1,
2385: p_module => v_block||'.p_project_sql{813.7}',
2386: p_msg_text => p_project_sql);
2387: FEM_ENGINES_PKG.TECH_MESSAGE
2388: (p_severity => c_log_level_1,
2389: p_module => v_block||'.p_customer_sql{813.8}',
2390: p_msg_text => p_customer_sql);
2391: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2391: FEM_ENGINES_PKG.TECH_MESSAGE

2387: FEM_ENGINES_PKG.TECH_MESSAGE
2388: (p_severity => c_log_level_1,
2389: p_module => v_block||'.p_customer_sql{813.8}',
2390: p_msg_text => p_customer_sql);
2391: FEM_ENGINES_PKG.TECH_MESSAGE
2392: (p_severity => c_log_level_1,
2393: p_module => v_block||'.p_entity_sql{813.9}',
2394: p_msg_text => p_entity_sql);
2395:

Line 2406: FEM_ENGINES_PKG.TECH_MESSAGE

2402: ELSE
2403: v_fetch_limit := c_fetch_limit;
2404: END IF;
2405:
2406: FEM_ENGINES_PKG.TECH_MESSAGE
2407: (p_severity => c_log_level_1,
2408: p_module => v_block||'.v_fetch_limit{820}',
2409: p_msg_text => v_fetch_limit);
2410:

Line 2418: FEM_ENGINES_PKG.TECH_MESSAGE

2414: ELSE
2415: x_select_stmt := REPLACE(p_eng_sql,'{{data_slice}}','1=1');
2416: END IF;
2417:
2418: FEM_ENGINES_PKG.TECH_MESSAGE
2419: (p_severity => c_log_level_1,
2420: p_module => v_block||'.x_select_stmt{821}',
2421: p_msg_text => x_select_stmt);
2422:

Line 2533: FEM_ENGINES_PKG.TECH_MESSAGE

2529: x_part_name => p_part_name,
2530: p_req_id => p_req_id,
2531: p_proc_num => p_proc_num);
2532:
2533: FEM_ENGINES_PKG.TECH_MESSAGE
2534: (p_severity => c_log_level_2,
2535: p_module => v_block||'.v_slc_id{822.1}',
2536: p_msg_text => v_slc_id);
2537: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2537: FEM_ENGINES_PKG.TECH_MESSAGE

2533: FEM_ENGINES_PKG.TECH_MESSAGE
2534: (p_severity => c_log_level_2,
2535: p_module => v_block||'.v_slc_id{822.1}',
2536: p_msg_text => v_slc_id);
2537: FEM_ENGINES_PKG.TECH_MESSAGE
2538: (p_severity => c_log_level_2,
2539: p_module => v_block||'.v_num_vals{822.2}',
2540: p_msg_text => v_num_vals);
2541: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2541: FEM_ENGINES_PKG.TECH_MESSAGE

2537: FEM_ENGINES_PKG.TECH_MESSAGE
2538: (p_severity => c_log_level_2,
2539: p_module => v_block||'.v_num_vals{822.2}',
2540: p_msg_text => v_num_vals);
2541: FEM_ENGINES_PKG.TECH_MESSAGE
2542: (p_severity => c_log_level_2,
2543: p_module => v_block||'.v_slc_val1{823.1}',
2544: p_msg_text => v_slc_val1);
2545: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2545: FEM_ENGINES_PKG.TECH_MESSAGE

2541: FEM_ENGINES_PKG.TECH_MESSAGE
2542: (p_severity => c_log_level_2,
2543: p_module => v_block||'.v_slc_val1{823.1}',
2544: p_msg_text => v_slc_val1);
2545: FEM_ENGINES_PKG.TECH_MESSAGE
2546: (p_severity => c_log_level_2,
2547: p_module => v_block||'.v_slc_val2{823.2}',
2548: p_msg_text => v_slc_val2);
2549: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2549: FEM_ENGINES_PKG.TECH_MESSAGE

2545: FEM_ENGINES_PKG.TECH_MESSAGE
2546: (p_severity => c_log_level_2,
2547: p_module => v_block||'.v_slc_val2{823.2}',
2548: p_msg_text => v_slc_val2);
2549: FEM_ENGINES_PKG.TECH_MESSAGE
2550: (p_severity => c_log_level_2,
2551: p_module => v_block||'.v_slc_val3{823.3}',
2552: p_msg_text => v_slc_val3);
2553: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2553: FEM_ENGINES_PKG.TECH_MESSAGE

2549: FEM_ENGINES_PKG.TECH_MESSAGE
2550: (p_severity => c_log_level_2,
2551: p_module => v_block||'.v_slc_val3{823.3}',
2552: p_msg_text => v_slc_val3);
2553: FEM_ENGINES_PKG.TECH_MESSAGE
2554: (p_severity => c_log_level_2,
2555: p_module => v_block||'.v_slc_val4{823.4}',
2556: p_msg_text => v_slc_val4);
2557: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2557: FEM_ENGINES_PKG.TECH_MESSAGE

2553: FEM_ENGINES_PKG.TECH_MESSAGE
2554: (p_severity => c_log_level_2,
2555: p_module => v_block||'.v_slc_val4{823.4}',
2556: p_msg_text => v_slc_val4);
2557: FEM_ENGINES_PKG.TECH_MESSAGE
2558: (p_severity => c_log_level_2,
2559: p_module => v_block||'.p_part_name{824}',
2560: p_msg_text => p_part_name);
2561:

Line 2604: FEM_ENGINES_PKG.TECH_MESSAGE

2600: v_rows_loaded := 0;
2601:
2602: LOOP
2603:
2604: FEM_ENGINES_PKG.TECH_MESSAGE
2605: (p_severity => c_log_level_3,
2606: p_module => v_block||'.Begin fetch{830}',
2607: p_msg_text => v_last_row);
2608:

Line 2652: FEM_ENGINES_PKG.TECH_MESSAGE

2648: END IF;
2649:
2650: v_rows_processed := cv_get_rows%ROWCOUNT;
2651:
2652: FEM_ENGINES_PKG.TECH_MESSAGE
2653: (p_severity => c_log_level_2,
2654: p_module => v_block||'.Rows this fetch{831}',
2655: p_msg_text => v_last_row);
2656: FEM_ENGINES_PKG.TECH_MESSAGE

Line 2656: FEM_ENGINES_PKG.TECH_MESSAGE

2652: FEM_ENGINES_PKG.TECH_MESSAGE
2653: (p_severity => c_log_level_2,
2654: p_module => v_block||'.Rows this fetch{831}',
2655: p_msg_text => v_last_row);
2656: FEM_ENGINES_PKG.TECH_MESSAGE
2657: (p_severity => c_log_level_2,
2658: p_module => v_block||'.Total rows fetched{832}',
2659: p_msg_text => v_rows_processed);
2660:

Line 2665: FEM_ENGINES_PKG.TECH_MESSAGE

2661: -------------------------------
2662: -- Validate Dimension Values --
2663: -------------------------------
2664:
2665: FEM_ENGINES_PKG.TECH_MESSAGE
2666: (p_severity => c_log_level_3,
2667: p_module => v_block||'.Begin validation{833}',
2668: p_msg_text => v_last_row);
2669:

Line 3054: FEM_ENGINES_PKG.TECH_MESSAGE

3050: -----------------------------------------
3051: -- Bulk Insert Rows in FEM_DATAn table --
3052: -----------------------------------------
3053:
3054: FEM_ENGINES_PKG.TECH_MESSAGE
3055: (p_severity => c_log_level_3,
3056: p_module => v_block||'.Begin bulk insert{834}',
3057: p_msg_text => v_last_row);
3058:

Line 3100: FEM_ENGINES_PKG.TECH_MESSAGE

3096:
3097: -----------------------------------
3098: -- Update Rows in FEM_DATAn_T Table
3099: -----------------------------------
3100: FEM_ENGINES_PKG.TECH_MESSAGE
3101: (p_severity => c_log_level_3,
3102: p_module => v_block||'.Begin bulk update{835}',
3103: p_msg_text => v_last_row);
3104:

Line 3113: FEM_ENGINES_PKG.TECH_MESSAGE

3109:
3110: -------------------------------------
3111: -- Delete Rows from FEM_DATAn_T Table
3112: -------------------------------------
3113: FEM_ENGINES_PKG.TECH_MESSAGE
3114: (p_severity => c_log_level_3,
3115: p_module => v_block||'.Begin bulk delete{836}',
3116: p_msg_text => v_last_row);
3117:

Line 3131: FEM_ENGINES_PKG.TECH_MESSAGE

3127:
3128: --------------------------------------------
3129: -- Delete Collections for Next Bulk Fetch --
3130: --------------------------------------------
3131: FEM_ENGINES_PKG.TECH_MESSAGE
3132: (p_severity => c_log_level_3,
3133: p_module => v_block||'.Begin array delete{837}',
3134: p_msg_text => v_last_row);
3135:

Line 3165: FEM_ENGINES_PKG.TECH_MESSAGE

3161: t_alpha_measure.DELETE;
3162: t_date_measure.DELETE;
3163: t_status.DELETE;
3164:
3165: FEM_ENGINES_PKG.TECH_MESSAGE
3166: (p_severity => c_log_level_3,
3167: p_module => v_block||'.End fetch{838}',
3168: p_msg_text => v_last_row);
3169:

Line 3173: FEM_ENGINES_PKG.TECH_MESSAGE

3169:
3170: END LOOP;
3171: CLOSE cv_get_rows;
3172:
3173: FEM_ENGINES_PKG.TECH_MESSAGE
3174: (p_severity => c_log_level_3,
3175: p_module => v_block||'.Close fetch cursor{839}',
3176: p_msg_text => v_rows_processed);
3177:

Line 3184: FEM_ENGINES_PKG.TECH_MESSAGE

3180: ---------------------
3181:
3182: v_rows_loaded := v_rows_processed - v_rows_rejected;
3183:
3184: FEM_ENGINES_PKG.TECH_MESSAGE
3185: (p_severity => c_log_level_2,
3186: p_module => v_block||'.v_rows_processed{840}',
3187: p_msg_text => v_rows_processed);
3188: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3188: FEM_ENGINES_PKG.TECH_MESSAGE

3184: FEM_ENGINES_PKG.TECH_MESSAGE
3185: (p_severity => c_log_level_2,
3186: p_module => v_block||'.v_rows_processed{840}',
3187: p_msg_text => v_rows_processed);
3188: FEM_ENGINES_PKG.TECH_MESSAGE
3189: (p_severity => c_log_level_2,
3190: p_module => v_block||'.v_rows_loaded{841}',
3191: p_msg_text => v_rows_loaded);
3192: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3192: FEM_ENGINES_PKG.TECH_MESSAGE

3188: FEM_ENGINES_PKG.TECH_MESSAGE
3189: (p_severity => c_log_level_2,
3190: p_module => v_block||'.v_rows_loaded{841}',
3191: p_msg_text => v_rows_loaded);
3192: FEM_ENGINES_PKG.TECH_MESSAGE
3193: (p_severity => c_log_level_2,
3194: p_module => v_block||'.v_rows_rejected{842}',
3195: p_msg_text => v_rows_rejected);
3196:

Line 3199: FEM_ENGINES_PKG.PUT_MESSAGE

3195: p_msg_text => v_rows_rejected);
3196:
3197: IF (v_rows_rejected > 0)
3198: THEN
3199: FEM_ENGINES_PKG.PUT_MESSAGE
3200: (p_app_name => 'FEM',
3201: p_msg_name => 'FEM_DATAX_LDR_BAD_DATA_ERR',
3202: p_token1 => 'COUNT',
3203: p_value1 => v_rows_rejected);

Line 3206: FEM_ENGINES_PKG.TECH_MESSAGE

3202: p_token1 => 'COUNT',
3203: p_value1 => v_rows_rejected);
3204: v_message := FND_MSG_PUB.GET(p_encoded => c_false);
3205:
3206: FEM_ENGINES_PKG.TECH_MESSAGE
3207: (p_severity => c_log_level_2,
3208: p_module => v_block||'.data_errors{843}',
3209: p_msg_text => v_message);
3210:

Line 3225: FEM_ENGINES_PKG.TECH_MESSAGE

3221: p_rows_rejected => v_rows_rejected);
3222:
3223: END LOOP;
3224:
3225: FEM_ENGINES_PKG.TECH_MESSAGE
3226: (p_severity => c_log_level_3,
3227: p_module => v_block||'.End{844}',
3228: p_msg_text => 'End FEM_DATAX_LOADER.Process_Rows');
3229:

Line 3247: FEM_ENGINES_PKG.TECH_MESSAGE

3243: p_slc_id => v_slc_id,
3244: p_status => v_status,
3245: p_message => v_message);
3246:
3247: FEM_ENGINES_PKG.TECH_MESSAGE
3248: (p_severity => c_log_level_6,
3249: p_module => v_block||'.Exception{845}',
3250: p_msg_text => sqlerrm);
3251:

Line 3252: FEM_ENGINES_PKG.USER_MESSAGE

3248: (p_severity => c_log_level_6,
3249: p_module => v_block||'.Exception{845}',
3250: p_msg_text => sqlerrm);
3251:
3252: FEM_ENGINES_PKG.USER_MESSAGE
3253: (p_msg_text => v_message);
3254:
3255: END Process_Rows;
3256:

Line 3279: FEM_ENGINES_PKG.TECH_MESSAGE

3275: 'fem.plsql.fem_datax_loader_pkg.post_process_rows';
3276:
3277: BEGIN
3278:
3279: FEM_ENGINES_PKG.TECH_MESSAGE
3280: (p_severity => c_log_level_3,
3281: p_module => v_block||'.Begin{900}',
3282: p_msg_text => 'Begin FEM_DATAX_LOADER.Post_Process');
3283: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3283: FEM_ENGINES_PKG.TECH_MESSAGE

3279: FEM_ENGINES_PKG.TECH_MESSAGE
3280: (p_severity => c_log_level_3,
3281: p_module => v_block||'.Begin{900}',
3282: p_msg_text => 'Begin FEM_DATAX_LOADER.Post_Process');
3283: FEM_ENGINES_PKG.TECH_MESSAGE
3284: (p_severity => c_log_level_2,
3285: p_module => v_block||'.c_user_id{901}',
3286: p_msg_text => c_user_id);
3287: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3287: FEM_ENGINES_PKG.TECH_MESSAGE

3283: FEM_ENGINES_PKG.TECH_MESSAGE
3284: (p_severity => c_log_level_2,
3285: p_module => v_block||'.c_user_id{901}',
3286: p_msg_text => c_user_id);
3287: FEM_ENGINES_PKG.TECH_MESSAGE
3288: (p_severity => c_log_level_2,
3289: p_module => v_block||'.g_req_id{902}',
3290: p_msg_text => g_req_id);
3291: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3291: FEM_ENGINES_PKG.TECH_MESSAGE

3287: FEM_ENGINES_PKG.TECH_MESSAGE
3288: (p_severity => c_log_level_2,
3289: p_module => v_block||'.g_req_id{902}',
3290: p_msg_text => g_req_id);
3291: FEM_ENGINES_PKG.TECH_MESSAGE
3292: (p_severity => c_log_level_2,
3293: p_module => v_block||'.g_object_id{903}',
3294: p_msg_text => g_object_id);
3295: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3295: FEM_ENGINES_PKG.TECH_MESSAGE

3291: FEM_ENGINES_PKG.TECH_MESSAGE
3292: (p_severity => c_log_level_2,
3293: p_module => v_block||'.g_object_id{903}',
3294: p_msg_text => g_object_id);
3295: FEM_ENGINES_PKG.TECH_MESSAGE
3296: (p_severity => c_log_level_2,
3297: p_module => v_block||'.g_data_table{904}',
3298: p_msg_text => g_data_table);
3299: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3299: FEM_ENGINES_PKG.TECH_MESSAGE

3295: FEM_ENGINES_PKG.TECH_MESSAGE
3296: (p_severity => c_log_level_2,
3297: p_module => v_block||'.g_data_table{904}',
3298: p_msg_text => g_data_table);
3299: FEM_ENGINES_PKG.TECH_MESSAGE
3300: (p_severity => c_log_level_2,
3301: p_module => v_block||'.g_data_t_table{905}',
3302: p_msg_text => g_data_t_table);
3303: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3303: FEM_ENGINES_PKG.TECH_MESSAGE

3299: FEM_ENGINES_PKG.TECH_MESSAGE
3300: (p_severity => c_log_level_2,
3301: p_module => v_block||'.g_data_t_table{905}',
3302: p_msg_text => g_data_t_table);
3303: FEM_ENGINES_PKG.TECH_MESSAGE
3304: (p_severity => c_log_level_2,
3305: p_module => v_block||'.g_rows_processed{906}',
3306: p_msg_text => g_rows_processed);
3307: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3307: FEM_ENGINES_PKG.TECH_MESSAGE

3303: FEM_ENGINES_PKG.TECH_MESSAGE
3304: (p_severity => c_log_level_2,
3305: p_module => v_block||'.g_rows_processed{906}',
3306: p_msg_text => g_rows_processed);
3307: FEM_ENGINES_PKG.TECH_MESSAGE
3308: (p_severity => c_log_level_2,
3309: p_module => v_block||'.g_rows_loaded{907}',
3310: p_msg_text => g_rows_loaded);
3311: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3311: FEM_ENGINES_PKG.TECH_MESSAGE

3307: FEM_ENGINES_PKG.TECH_MESSAGE
3308: (p_severity => c_log_level_2,
3309: p_module => v_block||'.g_rows_loaded{907}',
3310: p_msg_text => g_rows_loaded);
3311: FEM_ENGINES_PKG.TECH_MESSAGE
3312: (p_severity => c_log_level_2,
3313: p_module => v_block||'.g_rows_rejected{908}',
3314: p_msg_text => g_rows_rejected);
3315: FEM_ENGINES_PKG.TECH_MESSAGE

Line 3315: FEM_ENGINES_PKG.TECH_MESSAGE

3311: FEM_ENGINES_PKG.TECH_MESSAGE
3312: (p_severity => c_log_level_2,
3313: p_module => v_block||'.g_rows_rejected{908}',
3314: p_msg_text => g_rows_rejected);
3315: FEM_ENGINES_PKG.TECH_MESSAGE
3316: (p_severity => c_log_level_2,
3317: p_module => v_block||'.g_exec_status{909}',
3318: p_msg_text => g_exec_status);
3319:

Line 3355: FEM_ENGINES_PKG.TECH_MESSAGE

3351: x_msg_count => v_msg_count,
3352: x_msg_data => v_msg_data,
3353: x_return_status => v_return_status);
3354:
3355: FEM_ENGINES_PKG.TECH_MESSAGE
3356: (p_severity => c_log_level_2,
3357: p_module => v_block||'.update_obj_exec_errors.return_status{910}',
3358: p_msg_text => v_return_status);
3359:

Line 3385: FEM_ENGINES_PKG.TECH_MESSAGE

3381: x_msg_count => v_msg_count,
3382: x_msg_data => v_msg_data,
3383: x_return_status => v_return_status);
3384:
3385: FEM_ENGINES_PKG.TECH_MESSAGE
3386: (p_severity => c_log_level_2,
3387: p_module => v_block||'.update_num_of_output_rows.return_status{911}',
3388: p_msg_text => v_return_status);
3389:

Line 3413: FEM_ENGINES_PKG.TECH_MESSAGE

3409: x_msg_count => v_msg_count,
3410: x_msg_data => v_msg_data,
3411: x_return_status => v_return_status);
3412:
3413: FEM_ENGINES_PKG.TECH_MESSAGE
3414: (p_severity => c_log_level_2,
3415: p_module => v_block||'.update_obj_exec_status.return_status{912}',
3416: p_msg_text => v_return_status);
3417:

Line 3440: FEM_ENGINES_PKG.TECH_MESSAGE

3436: x_msg_count => v_msg_count,
3437: x_msg_data => v_msg_data,
3438: x_return_status => v_return_status);
3439:
3440: FEM_ENGINES_PKG.TECH_MESSAGE
3441: (p_severity => c_log_level_2,
3442: p_module => v_block||'.update_request_status.return_status{913}',
3443: p_msg_text => v_return_status);
3444:

Line 3454: FEM_ENGINES_PKG.TECH_MESSAGE

3450: THEN
3451: RAISE e_process_lock_error;
3452: END IF;
3453:
3454: FEM_ENGINES_PKG.TECH_MESSAGE
3455: (p_severity => c_log_level_3,
3456: p_module => v_block||'.End{930}',
3457: p_msg_text => 'End FEM_DATAX_LOADER.Post_Process');
3458:

Line 3487: FEM_ENGINES_PKG.TECH_MESSAGE

3483: 'fem.plsql.fem_datax_loader_pkg.get_put_messages';
3484:
3485: BEGIN
3486:
3487: FEM_ENGINES_PKG.TECH_MESSAGE
3488: (p_severity => c_log_level_2,
3489: p_module => v_block||'.msg_count{920}',
3490: p_msg_text => p_msg_count);
3491:

Line 3499: FEM_ENGINES_PKG.User_Message(

3495: THEN
3496: FND_MESSAGE.Set_Encoded(v_msg_data);
3497: v_message := FND_MESSAGE.Get;
3498:
3499: FEM_ENGINES_PKG.User_Message(
3500: p_msg_text => v_message);
3501:
3502: FEM_ENGINES_PKG.TECH_MESSAGE
3503: (p_severity => c_log_level_2,

Line 3502: FEM_ENGINES_PKG.TECH_MESSAGE

3498:
3499: FEM_ENGINES_PKG.User_Message(
3500: p_msg_text => v_message);
3501:
3502: FEM_ENGINES_PKG.TECH_MESSAGE
3503: (p_severity => c_log_level_2,
3504: p_module => v_block||'.msg_data{921}',
3505: p_msg_text => v_message);
3506:

Line 3517: FEM_ENGINES_PKG.User_Message(

3513: p_encoded => c_false,
3514: p_data => v_message,
3515: p_msg_index_out => v_msg_out);
3516:
3517: FEM_ENGINES_PKG.User_Message(
3518: p_msg_text => v_message);
3519:
3520: FEM_ENGINES_PKG.TECH_MESSAGE
3521: (p_severity => c_log_level_2,

Line 3520: FEM_ENGINES_PKG.TECH_MESSAGE

3516:
3517: FEM_ENGINES_PKG.User_Message(
3518: p_msg_text => v_message);
3519:
3520: FEM_ENGINES_PKG.TECH_MESSAGE
3521: (p_severity => c_log_level_2,
3522: p_module => v_block||'.msg_data{922}',
3523: p_msg_text => v_message);
3524: