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

Line 174: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171:
172: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
173:
174: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
175: ,p_module => G_BLOCK||'.'||l_api_name
176: ,p_msg_text => 'BEGIN');
177:
178: -- CHECKPOINT RESTART

Line 188: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

184: l_reuse_slices := 'N';
185: END IF;
186:
187: -- Get Value Set Id for the given LEDGER.
188: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
189: ,p_module => G_BLOCK||'.'||l_api_name
190: ,p_msg_text => 'Getting Global VS Combo ID');
191:
192: l_gvsc_id := FEM_DIMENSION_UTIL_PKG.Global_VS_Combo_ID (

Line 198: FEM_ENGINES_PKG.Tech_Message (

194: ,x_err_code => l_err_code
195: ,x_num_msg => l_num_msg);
196:
197: IF(l_err_code <> 0)THEN
198: FEM_ENGINES_PKG.Tech_Message (
199: p_severity => g_log_level_2
200: ,p_module => G_BLOCK||'.'||l_api_name
201: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
202:

Line 203: FEM_ENGINES_PKG.User_Message (

199: p_severity => g_log_level_2
200: ,p_module => G_BLOCK||'.'||l_api_name
201: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
202:
203: FEM_ENGINES_PKG.User_Message (
204: p_app_name => G_PFT
205: ,p_msg_name => G_ENG_INVALID_LEDGER_ERR
206: ,p_token1 => 'LEDGER_ID'
207: ,p_value1 => p_ledger_id);

Line 212: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

208:
209: RAISE e_process_single_rule_error;
210: END IF;
211:
212: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
213: ,p_module => G_BLOCK||'.'||l_api_name
214: ,p_msg_text => 'Getting Customer Value Set Id');
215: BEGIN
216: SELECT gvsc.value_set_id

Line 224: FEM_ENGINES_PKG.Tech_Message (

220: AND dim.dimension_varchar_label = 'CUSTOMER'
221: AND gvsc.global_vs_combo_id = l_gvsc_id;
222: EXCEPTION
223: WHEN no_data_found THEN
224: FEM_ENGINES_PKG.Tech_Message (
225: p_severity => g_log_level_2
226: ,p_module => G_BLOCK||'.'||l_api_name
227: ,p_msg_text => 'No Value Set Id for the Given GVSC ' ||l_gvsc_id);
228:

Line 229: FEM_ENGINES_PKG.User_Message (

225: p_severity => g_log_level_2
226: ,p_module => G_BLOCK||'.'||l_api_name
227: ,p_msg_text => 'No Value Set Id for the Given GVSC ' ||l_gvsc_id);
228:
229: FEM_ENGINES_PKG.User_Message (
230: p_app_name => G_PFT
231: ,p_msg_name => G_ENG_INVALID_GVSC_ERR
232: ,p_token1 => 'GVSC_ID'
233: ,p_value1 => l_gvsc_id);

Line 252: FEM_ENGINES_PKG.TECH_MESSAGE(

248: ,p_ledger_id => p_ledger_id
249: ,p_source_system_code => p_source_system_code
250: ,P_value_set_id => l_value_set_id);
251:
252: FEM_ENGINES_PKG.TECH_MESSAGE(
253: p_severity => g_log_level_3
254: ,p_module => G_BLOCK||'.'||l_api_name
255: ,p_msg_text => 'Registering step: PROSP_IDENT');
256:

Line 257: FEM_ENGINES_PKG.TECH_MESSAGE(

253: p_severity => g_log_level_3
254: ,p_module => G_BLOCK||'.'||l_api_name
255: ,p_msg_text => 'Registering step: PROSP_IDENT');
256:
257: FEM_ENGINES_PKG.TECH_MESSAGE(
258: p_severity => g_log_level_3
259: ,p_module => G_BLOCK||'.'||l_api_name
260: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
261: ||p_rule_obj_id);

Line 263: FEM_ENGINES_PKG.TECH_MESSAGE(

259: ,p_module => G_BLOCK||'.'||l_api_name
260: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
261: ||p_rule_obj_id);
262:
263: FEM_ENGINES_PKG.TECH_MESSAGE(
264: p_severity => g_log_level_3
265: ,p_module => G_BLOCK||'.'||l_api_name
266: ,p_msg_text => 'Submitting Prospect Ident SQL to MP Master.p_eng_sql: '
267: ||l_bulk_sql);

Line 292: FEM_ENGINES_PKG.Tech_Message(p_severity => g_log_level_1

288: FROM fem_mp_process_ctl_t
289: WHERE req_id = l_request_id
290: AND status = 2;
291:
292: FEM_ENGINES_PKG.Tech_Message(p_severity => g_log_level_1
293: ,p_module => G_BLOCK||'.'||l_api_name
294: ,p_msg_text => 'Total Errors : ' ||
295: TO_CHAR(v_msg_list.COUNT));
296:

Line 300: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_5

296:
297: -- Log all of the messages
298: FOR i IN 1..v_msg_list.COUNT LOOP
299:
300: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_5
301: ,p_module => G_BLOCK||'.'||l_api_name
302: ,p_msg_text => v_msg_list(i));
303:
304: FND_FILE.Put_Line(FND_FILE.log, v_msg_list(i));

Line 307: FEM_ENGINES_PKG.User_Message (

303:
304: FND_FILE.Put_Line(FND_FILE.log, v_msg_list(i));
305: END LOOP;
306:
307: FEM_ENGINES_PKG.User_Message (
308: p_app_name => G_PFT
309: ,p_msg_name => G_ENG_MULTI_PROC_ERR);
310:
311: Process_Obj_Exec_Step(

Line 344: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

340:
341: -- commit the work
342: COMMIT;
343:
344: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
345: ,p_module => G_BLOCK||'.'||l_api_name
346: ,p_msg_text => 'END');
347:
348: EXCEPTION

Line 351: FEM_ENGINES_PKG.Tech_Message (

347:
348: EXCEPTION
349: WHEN e_process_single_rule_error THEN
350:
351: FEM_ENGINES_PKG.Tech_Message (
352: p_severity => g_log_level_5
353: ,p_module => G_BLOCK||'.'||l_api_name
354: ,p_msg_text => 'Prospect Identification Error:
355: Process Single Rule Exception');

Line 357: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

353: ,p_module => G_BLOCK||'.'||l_api_name
354: ,p_msg_text => 'Prospect Identification Error:
355: Process Single Rule Exception');
356:
357: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
358: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
359:
360: x_return_status := FND_API.G_RET_STS_ERROR;
361:

Line 364: FEM_ENGINES_PKG.Tech_Message (

360: x_return_status := FND_API.G_RET_STS_ERROR;
361:
362: WHEN OTHERS THEN
363:
364: FEM_ENGINES_PKG.Tech_Message (
365: p_severity => g_log_level_5
366: ,p_module => G_BLOCK||'.'||l_api_name
367: ,p_msg_text => 'Prospect Identification Error:
368: Process Single Rule Exception');

Line 370: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

366: ,p_module => G_BLOCK||'.'||l_api_name
367: ,p_msg_text => 'Prospect Identification Error:
368: Process Single Rule Exception');
369:
370: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
371: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:

Line 407: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

403: e_upd_num_output_rows_error EXCEPTION;
404:
405: BEGIN
406:
407: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
408: ,p_module => G_BLOCK||'.'||l_api_name
409: ,p_msg_text => 'BEGIN');
410:
411: -- Set the number of output rows for the output table.

Line 433: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

429: ,p_msg_data => l_msg_data);
430: RAISE e_upd_num_output_rows_error;
431: END IF;
432:
433: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
434: ,p_module => G_BLOCK||'.'||l_api_name
435: ,p_msg_text => 'END');
436:
437: EXCEPTION

Line 439: FEM_ENGINES_PKG.Tech_Message (

435: ,p_msg_text => 'END');
436:
437: EXCEPTION
438: WHEN e_upd_num_output_rows_error THEN
439: FEM_ENGINES_PKG.Tech_Message (
440: p_severity => g_log_level_5
441: ,p_module => G_BLOCK||'.'||l_api_name
442: ,p_msg_text => 'Update Rows Exception');
443:

Line 444: FEM_ENGINES_PKG.User_Message (

440: p_severity => g_log_level_5
441: ,p_module => G_BLOCK||'.'||l_api_name
442: ,p_msg_text => 'Update Rows Exception');
443:
444: FEM_ENGINES_PKG.User_Message (
445: p_app_name => G_PFT
446: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
447:
448: RAISE e_process_single_rule_error;

Line 451: FEM_ENGINES_PKG.User_Message (

447:
448: RAISE e_process_single_rule_error;
449:
450: WHEN OTHERS THEN
451: FEM_ENGINES_PKG.User_Message (
452: p_app_name => G_PFT
453: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
454:
455: RAISE e_process_single_rule_error;

Line 488: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

484: e_upd_obj_exec_step_stat_error EXCEPTION;
485:
486: BEGIN
487:
488: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
489: ,p_module => G_BLOCK||'.'||l_api_name
490: ,p_msg_text => 'BEGIN');
491:
492: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure

Line 514: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

510: RAISE e_upd_obj_exec_step_stat_error;
511:
512: END IF;
513:
514: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
515: ,p_module => G_BLOCK||'.'||l_api_name
516: ,p_msg_text => 'END');
517:
518: EXCEPTION

Line 520: FEM_ENGINES_PKG.Tech_Message (

516: ,p_msg_text => 'END');
517:
518: EXCEPTION
519: WHEN e_upd_obj_exec_step_stat_error THEN
520: FEM_ENGINES_PKG.Tech_Message (
521: p_severity => g_log_level_5
522: ,p_module => G_BLOCK||'.'||l_api_name
523: ,p_msg_text => 'Update Obj Exec Step API Exception');
524:

Line 525: FEM_ENGINES_PKG.User_Message (

521: p_severity => g_log_level_5
522: ,p_module => G_BLOCK||'.'||l_api_name
523: ,p_msg_text => 'Update Obj Exec Step API Exception');
524:
525: FEM_ENGINES_PKG.User_Message (
526: p_app_name => G_PFT
527: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
528: ,p_token1 => 'OBJECT_ID'
529: ,p_value1 => p_rule_obj_id);

Line 534: FEM_ENGINES_PKG.User_Message (

530:
531: RAISE e_process_single_rule_error;
532:
533: WHEN OTHERS THEN
534: FEM_ENGINES_PKG.User_Message (
535: p_app_name => G_PFT
536: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
537: ,p_token1 => 'OBJECT_ID'
538: ,p_value1 => p_rule_obj_id);

Line 564: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

560: l_api_name CONSTANT VARCHAR2(30) := 'Get_Nbr_RowsTable_Request';
561:
562: BEGIN
563:
564: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
565: ,p_module => G_BLOCK||'.'||l_api_name
566: ,p_msg_text => 'BEGIN');
567:
568: --Query the fem_mp_process_ctl_t table to get the number of rows

Line 581: FEM_ENGINES_PKG.Tech_Message (

577: WHERE t.req_id = p_request_id
578: AND t.process_num > 0;
579:
580: IF (x_rows_processed = 0) THEN
581: FEM_ENGINES_PKG.Tech_Message (
582: p_severity => g_log_level_5
583: ,p_module => G_BLOCK||'.'||l_api_name
584: ,p_msg_text => 'No Rows returned by the SQL');
585:

Line 586: FEM_ENGINES_PKG.User_Message (

582: p_severity => g_log_level_5
583: ,p_module => G_BLOCK||'.'||l_api_name
584: ,p_msg_text => 'No Rows returned by the SQL');
585:
586: FEM_ENGINES_PKG.User_Message (
587: p_app_name => G_PFT
588: ,p_msg_name => G_ENG_NO_OP_ROWS_ERR);
589:
590: RAISE e_process_single_rule_error;

Line 593: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

589:
590: RAISE e_process_single_rule_error;
591: END IF;
592:
593: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
594: ,p_module => G_BLOCK||'.'||l_api_name
595: ,p_msg_text => 'END');
596:
597: EXCEPTION

Line 632: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2

628: l_api_name := 'Process_Obj_Exec_Step';
629: l_nbr_output_rows := NULL;
630: l_nbr_input_rows := NULL;
631:
632: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2
633: ,p_module => G_BLOCK||'.'||l_api_name
634: ,p_msg_text => 'BEGIN');
635:
636: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 636: FEM_ENGINES_PKG.TECH_MESSAGE(

632: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2
633: ,p_module => G_BLOCK||'.'||l_api_name
634: ,p_msg_text => 'BEGIN');
635:
636: FEM_ENGINES_PKG.TECH_MESSAGE(
637: p_severity => g_log_level_3
638: ,p_module => G_BLOCK||'.'||l_api_name
639: ,p_msg_text => 'Update the status of the step with execution status :'
640: ||p_exe_status_code);

Line 659: FEM_ENGINES_PKG.TECH_MESSAGE(

655: p_request_id => p_request_id);
656:
657: --update the number of output rows processed succesfully
658: --in the registered table
659: FEM_ENGINES_PKG.TECH_MESSAGE(
660: p_severity => g_log_level_3
661: ,p_module => G_BLOCK||'.'||l_api_name
662: ,p_msg_text => 'Rows processed for registered output table :'
663: ||p_tbl_name);

Line 677: FEM_ENGINES_PKG.TECH_MESSAGE(

673:
674: -----------------------------------------------------------------------
675: -- Call FEM_PL_PKG.update_num_of_input_rows();
676: -----------------------------------------------------------------------
677: FEM_ENGINES_PKG.TECH_MESSAGE(
678: p_severity => g_log_level_1,
679: p_module => G_BLOCK||'.'||l_api_name,
680: p_msg_text => 'No:of Rows processed from input table'
681: ||l_nbr_input_rows);

Line 690: FEM_ENGINES_PKG.User_Message(p_app_name => G_PFT,

686: ,p_last_update_login => p_login_id
687: ,p_rule_obj_id => p_rule_obj_id
688: ,p_num_of_input_rows => l_nbr_input_rows);
689:
690: FEM_ENGINES_PKG.User_Message(p_app_name => G_PFT,
691: p_msg_name => 'PFT_PPROF_PIDNT_ROW_SUMMARY',
692: p_token1 => 'ROWSP',
693: p_value1 => l_nbr_output_rows,
694: p_token2 => 'ROWSL',

Line 699: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2

695: p_value2 => l_nbr_loaded_rows);
696:
697: END IF;
698:
699: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2
700: ,p_module => G_BLOCK||'.'||l_api_name
701: ,p_msg_text => 'END');
702:
703: EXCEPTION

Line 749: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

745: l_request_id := FND_GLOBAL.Conc_Request_Id;
746: l_user_id := FND_GLOBAL.User_Id;
747: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
748:
749: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
750: ,p_module => G_BLOCK||'.'||l_api_name
751: ,p_msg_text => 'BEGIN');
752:
753: l_update_head_stmt := ' UPDATE FEM_CUSTOMERS_ATTR attr' ||

Line 796: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

792: -- add mapped columns
793: RETURN l_update_head_stmt || ' ' || l_where_stmt || ' ' || l_select_stmt || ' ' ||
794: l_sub_query_stmt;
795:
796: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
797: ,p_module => G_BLOCK||'.'||l_api_name
798: ,p_msg_text => 'END');
799:
800: EXCEPTION

Line 829: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

825: l_message VARCHAR2(4000);
826:
827: BEGIN
828:
829: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
830: ,p_module => G_BLOCK||'.'||l_api_name
831: ,p_msg_text => 'msg_count='||p_msg_count);
832:
833: l_msg_data := p_msg_data;

Line 840: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );

836:
837: FND_MESSAGE.Set_Encoded(l_msg_data);
838: l_message := FND_MESSAGE.Get;
839:
840: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
841:
842: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
843: ,p_module => G_BLOCK||'.'||l_api_name
844: ,p_msg_text => 'msg_data='||l_message);

Line 842: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

838: l_message := FND_MESSAGE.Get;
839:
840: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
841:
842: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
843: ,p_module => G_BLOCK||'.'||l_api_name
844: ,p_msg_text => 'msg_data='||l_message);
845:
846: ELSIF (p_msg_count > 1) THEN

Line 854: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );

850: ,p_encoded => FND_API.G_FALSE
851: ,p_data => l_message
852: ,p_msg_index_out => l_msg_out);
853:
854: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
855:
856: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
857: ,p_module => G_BLOCK||'.'||l_api_name
858: ,p_msg_text => 'msg_data = '||l_message);

Line 856: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

852: ,p_msg_index_out => l_msg_out);
853:
854: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
855:
856: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
857: ,p_module => G_BLOCK||'.'||l_api_name
858: ,p_msg_text => 'msg_data = '||l_message);
859:
860: END LOOP;

Line 897: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

893: e_upd_num_input_rows_error EXCEPTION;
894:
895: BEGIN
896:
897: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
898: ,p_module => G_BLOCK||'.'||l_api_name
899: ,p_msg_text => 'BEGIN');
900:
901: -- Set the number of output rows for the output table.

Line 921: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

917: ,p_msg_data => l_msg_data);
918: RAISE e_upd_num_input_rows_error;
919: END IF;
920:
921: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
922: ,p_module => G_BLOCK||'.'||l_api_name
923: ,p_msg_text => 'END');
924:
925: EXCEPTION

Line 927: FEM_ENGINES_PKG.Tech_Message (

923: ,p_msg_text => 'END');
924:
925: EXCEPTION
926: WHEN e_upd_num_input_rows_error THEN
927: FEM_ENGINES_PKG.Tech_Message (
928: p_severity => g_log_level_5
929: ,p_module => G_BLOCK||'.'||l_api_name
930: ,p_msg_text => 'Update Input Rows Exception');
931:

Line 932: FEM_ENGINES_PKG.User_Message (

928: p_severity => g_log_level_5
929: ,p_module => G_BLOCK||'.'||l_api_name
930: ,p_msg_text => 'Update Input Rows Exception');
931:
932: FEM_ENGINES_PKG.User_Message (
933: p_app_name => G_PFT
934: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
935:
936: RAISE e_process_single_rule_error;

Line 939: FEM_ENGINES_PKG.Tech_Message (

935:
936: RAISE e_process_single_rule_error;
937:
938: WHEN OTHERS THEN
939: FEM_ENGINES_PKG.Tech_Message (
940: p_severity => g_log_level_5
941: ,p_module => G_BLOCK||'.'||l_api_name
942: ,p_msg_text => 'Update Input Rows Exception');
943:

Line 944: FEM_ENGINES_PKG.User_Message (

940: p_severity => g_log_level_5
941: ,p_module => G_BLOCK||'.'||l_api_name
942: ,p_msg_text => 'Update Input Rows Exception');
943:
944: FEM_ENGINES_PKG.User_Message (
945: p_app_name => G_PFT
946: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
947:
948: RAISE e_process_single_rule_error;