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

Line 163: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

159: BEGIN
160: -- Initialize the return status to SUCCESS
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
164: ,p_module => G_BLOCK||'.'||l_api_name
165: ,p_msg_text => 'BEGIN');
166:
167: FEM_ENGINES_PKG.Tech_Message (

Line 167: FEM_ENGINES_PKG.Tech_Message (

163: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
164: ,p_module => G_BLOCK||'.'||l_api_name
165: ,p_msg_text => 'BEGIN');
166:
167: FEM_ENGINES_PKG.Tech_Message (
168: p_severity => g_log_level_3
169: ,p_module => G_BLOCK||'.'||l_api_name
170: ,p_msg_text => 'Generating the dataset where clause');
171:

Line 189: FEM_ENGINES_PKG.User_Message (

185:
186: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
187: Get_Put_Messages ( p_msg_count => l_msg_count
188: ,p_msg_data => l_msg_data);
189: FEM_ENGINES_PKG.User_Message (
190: p_app_name => G_PFT
191: ,p_msg_name => G_ENG_DS_WHERE_CLAUSE_ERR
192: ,p_token1 => 'OUTPUT_DS_CODE'
193: ,p_value1 => p_dataset_io_obj_def_id

Line 198: FEM_ENGINES_PKG.User_Message (

194: ,p_token2 => 'CAL_PERIOD_ID'
195: ,p_value2 => p_cal_period_id);
196:
197: IF (l_ds_where_clause IS NULL) THEN
198: FEM_ENGINES_PKG.User_Message (
199: p_app_name => G_PFT
200: ,p_msg_name => G_ENG_DS_WHERE_CLAUSE_ERR
201: ,p_token1 => 'OUTPUT_DS_CODE'
202: ,p_value1 => p_dataset_io_obj_def_id

Line 219: FEM_ENGINES_PKG.Tech_Message (

215: ELSE
216: l_reuse_slices := 'N';
217: END IF;
218:
219: FEM_ENGINES_PKG.Tech_Message (
220: p_severity => g_log_level_3
221: ,p_module => G_BLOCK||'.'||l_api_name
222: ,p_msg_text => 'Building Update SQL');
223:

Line 235: FEM_ENGINES_PKG.TECH_MESSAGE(

231: ,p_ledger_id => p_ledger_id
232: ,p_source_system_code => p_source_system_code
233: ,p_ds_where_clause => l_ds_where_clause);
234:
235: FEM_ENGINES_PKG.TECH_MESSAGE(
236: p_severity => g_log_level_3
237: ,p_module => G_BLOCK||'.'||l_api_name
238: ,p_msg_text => 'Update Sql'|| l_update_sql);
239:

Line 241: FEM_ENGINES_PKG.TECH_MESSAGE(

237: ,p_module => G_BLOCK||'.'||l_api_name
238: ,p_msg_text => 'Update Sql'|| l_update_sql);
239:
240: BEGIN
241: FEM_ENGINES_PKG.TECH_MESSAGE(
242: p_severity => g_log_level_3
243: ,p_module => G_BLOCK||'.'||l_api_name
244: ,p_msg_text => 'Issuing the Execute Immediate Stmt');
245:

Line 253: FEM_ENGINES_PKG.Tech_Message (

249: EXCEPTION
250: WHEN OTHERS THEN
251: gv_prg_msg := SQLERRM;
252:
253: FEM_ENGINES_PKG.Tech_Message (
254: p_severity => g_log_level_3
255: ,p_module => G_BLOCK||'.'||l_api_name
256: ,p_msg_text => 'UPDATE STATEMENT ERROR');
257:

Line 258: FEM_ENGINES_PKG.Tech_Message (

254: p_severity => g_log_level_3
255: ,p_module => G_BLOCK||'.'||l_api_name
256: ,p_msg_text => 'UPDATE STATEMENT ERROR');
257:
258: FEM_ENGINES_PKG.Tech_Message (
259: p_severity => g_log_level_6
260: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
261: ,p_msg_text => gv_prg_msg);
262:

Line 263: FEM_ENGINES_PKG.User_Message (

259: p_severity => g_log_level_6
260: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
261: ,p_msg_text => gv_prg_msg);
262:
263: FEM_ENGINES_PKG.User_Message (
264: p_app_name => G_FEM
265: ,p_msg_name => G_UNEXPECTED_ERROR
266: ,p_token1 => 'ERR_MSG'
267: ,p_value1 => gv_prg_msg);

Line 294: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

290:
291: -- commit the work
292: COMMIT;
293:
294: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
295: ,p_module => G_BLOCK||'.'||l_api_name
296: ,p_msg_text => 'END');
297:
298: EXCEPTION

Line 301: FEM_ENGINES_PKG.Tech_Message (

297:
298: EXCEPTION
299: WHEN e_process_single_rule_error THEN
300:
301: FEM_ENGINES_PKG.Tech_Message (
302: p_severity => g_log_level_5
303: ,p_module => G_BLOCK||'.'||l_api_name
304: ,p_msg_text => 'Process Single Rule Exception');
305:

Line 306: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

302: p_severity => g_log_level_5
303: ,p_module => G_BLOCK||'.'||l_api_name
304: ,p_msg_text => 'Process Single Rule Exception');
305:
306: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
307: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
308:
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:

Line 312: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

308:
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: WHEN OTHERS THEN
312: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
313: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
314:
315: x_return_status := FND_API.G_RET_STS_ERROR;
316:

Line 349: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

345: e_upd_num_output_rows_error EXCEPTION;
346:
347: BEGIN
348:
349: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
350: ,p_module => G_BLOCK||'.'||l_api_name
351: ,p_msg_text => 'BEGIN');
352:
353: -- Set the number of output rows for the output table.

Line 376: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

372:
373: RAISE e_upd_num_output_rows_error;
374: END IF;
375:
376: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
377: ,p_module => G_BLOCK||'.'||l_api_name
378: ,p_msg_text => 'END');
379:
380: EXCEPTION

Line 382: FEM_ENGINES_PKG.Tech_Message (

378: ,p_msg_text => 'END');
379:
380: EXCEPTION
381: WHEN e_upd_num_output_rows_error THEN
382: FEM_ENGINES_PKG.Tech_Message (
383: p_severity => g_log_level_5
384: ,p_module => G_BLOCK||'.'||l_api_name
385: ,p_msg_text => 'Update Rows Exception');
386:

Line 387: FEM_ENGINES_PKG.User_Message (

383: p_severity => g_log_level_5
384: ,p_module => G_BLOCK||'.'||l_api_name
385: ,p_msg_text => 'Update Rows Exception');
386:
387: FEM_ENGINES_PKG.User_Message (
388: p_app_name => G_PFT
389: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
390:
391: RAISE e_process_single_rule_error;

Line 394: FEM_ENGINES_PKG.User_Message (

390:
391: RAISE e_process_single_rule_error;
392:
393: WHEN OTHERS THEN
394: FEM_ENGINES_PKG.User_Message (
395: p_app_name => G_PFT
396: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
397:
398: RAISE e_process_single_rule_error;

Line 431: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

427: e_upd_obj_exec_step_stat_error EXCEPTION;
428:
429: BEGIN
430:
431: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
432: ,p_module => G_BLOCK||'.'||l_api_name
433: ,p_msg_text => 'BEGIN');
434:
435: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure

Line 457: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

453: RAISE e_upd_obj_exec_step_stat_error;
454:
455: END IF;
456:
457: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
458: ,p_module => G_BLOCK||'.'||l_api_name
459: ,p_msg_text => 'END');
460:
461: EXCEPTION

Line 463: FEM_ENGINES_PKG.Tech_Message (

459: ,p_msg_text => 'END');
460:
461: EXCEPTION
462: WHEN e_upd_obj_exec_step_stat_error THEN
463: FEM_ENGINES_PKG.Tech_Message (
464: p_severity => g_log_level_5
465: ,p_module => G_BLOCK||'.'||l_api_name
466: ,p_msg_text => 'Update Obj Exec Step API Exception');
467:

Line 468: FEM_ENGINES_PKG.User_Message (

464: p_severity => g_log_level_5
465: ,p_module => G_BLOCK||'.'||l_api_name
466: ,p_msg_text => 'Update Obj Exec Step API Exception');
467:
468: FEM_ENGINES_PKG.User_Message (
469: p_app_name => G_PFT
470: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
471: ,p_token1 => 'OBJECT_ID'
472: ,p_value1 => p_rule_obj_id);

Line 477: FEM_ENGINES_PKG.User_Message (

473:
474: RAISE e_process_single_rule_error;
475:
476: WHEN OTHERS THEN
477: FEM_ENGINES_PKG.User_Message (
478: p_app_name => G_PFT
479: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
480: ,p_token1 => 'OBJECT_ID'
481: ,p_value1 => p_rule_obj_id);

Line 512: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

508:
509: BEGIN
510: l_api_name := 'Process_Obj_Exec_Step';
511:
512: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
513: ,p_module => G_BLOCK||'.'||l_api_name
514: ,p_msg_text => 'BEGIN');
515:
516: --------------------------------------------------------------------------

Line 519: FEM_ENGINES_PKG.Tech_Message(

515:
516: --------------------------------------------------------------------------
517: --update the status of the step
518: --------------------------------------------------------------------------
519: FEM_ENGINES_PKG.Tech_Message(
520: p_severity => g_log_level_3
521: ,p_module => G_BLOCK||'.'||l_api_name
522: ,p_msg_text => 'Update the status of the step with execution status :'
523: ||p_exe_status_code);

Line 536: FEM_ENGINES_PKG.Tech_Message(

532: IF (p_exe_status_code = g_exec_status_success) THEN
533:
534: --update the number of output rows processed succesfully
535: --in the registered table
536: FEM_ENGINES_PKG.Tech_Message(
537: p_severity => g_log_level_3
538: ,p_module => G_BLOCK||'.'||l_api_name
539: ,p_msg_text => 'Rows processed for registered output table :'
540: ||p_tbl_name);

Line 555: FEM_ENGINES_PKG.TECH_MESSAGE(

551: -----------------------------------------------------------------------
552: -- Call FEM_PL_PKG.update_num_of_input_rows();
553: -----------------------------------------------------------------------
554:
555: FEM_ENGINES_PKG.TECH_MESSAGE(
556: p_severity => g_log_level_1,
557: p_module => G_BLOCK||'.'||l_api_name,
558: p_msg_text => 'No.of Rows processed from input table :'
559: || p_num_rows);

Line 568: FEM_ENGINES_PKG.User_Message(

564: ,p_last_update_login => p_login_id
565: ,p_rule_obj_id => p_rule_obj_id
566: ,p_num_of_input_rows => p_num_rows);
567:
568: FEM_ENGINES_PKG.User_Message(
569: p_app_name => G_PFT
570: ,p_msg_name => 'PFT_PPROF_PPTILE_ROW_SUMMARY'
571: ,p_token1 => 'ROWSP'
572: ,p_value1 => NVL(p_num_rows,0)

Line 578: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

574: ,p_value2 => NVL(p_num_rows,0));
575:
576: END IF;
577:
578: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
579: ,p_module => G_BLOCK||'.'||l_api_name
580: ,p_msg_text => 'END');
581:
582: EXCEPTION

Line 633: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

629: l_request_id := FND_GLOBAL.Conc_Request_Id;
630: l_user_id := FND_GLOBAL.User_Id;
631: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
632:
633: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
634: ,p_module => G_BLOCK||'.'||l_api_name
635: ,p_msg_text => 'BEGIN');
636:
637: FEM_ENGINES_PKG.Tech_Message (

Line 637: FEM_ENGINES_PKG.Tech_Message (

633: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
634: ,p_module => G_BLOCK||'.'||l_api_name
635: ,p_msg_text => 'BEGIN');
636:
637: FEM_ENGINES_PKG.Tech_Message (
638: p_severity => g_log_level_2
639: ,p_module => G_BLOCK||'.'||l_api_name
640: ,p_msg_text => 'Getting Global VS Combo ID');
641:

Line 648: FEM_ENGINES_PKG.Tech_Message (

644: ,x_err_code => l_err_code
645: ,x_num_msg => l_num_msg);
646:
647: IF(l_err_code <> 0)THEN
648: FEM_ENGINES_PKG.Tech_Message (
649: p_severity => g_log_level_2
650: ,p_module => G_BLOCK||'.'||l_api_name
651: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
652:

Line 653: FEM_ENGINES_PKG.User_Message (

649: p_severity => g_log_level_2
650: ,p_module => G_BLOCK||'.'||l_api_name
651: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
652:
653: FEM_ENGINES_PKG.User_Message (
654: p_app_name => G_PFT
655: ,p_msg_name => G_ENG_INVALID_LEDGER_ERR
656: ,p_token1 => 'LEDGER_ID'
657: ,p_value1 => p_ledger_id);

Line 662: FEM_ENGINES_PKG.Tech_Message (

658:
659: RAISE e_process_single_rule_error;
660: END IF;
661:
662: FEM_ENGINES_PKG.Tech_Message (
663: p_severity => g_log_level_2
664: ,p_module => G_BLOCK||'.'||l_api_name
665: ,p_msg_text => 'Getting Customer Value Set Id');
666:

Line 676: FEM_ENGINES_PKG.Tech_Message (

672: AND dim.dimension_varchar_label = 'CUSTOMER'
673: AND gvsc.global_vs_combo_id = l_gvsc_id;
674: EXCEPTION
675: WHEN no_data_found THEN
676: FEM_ENGINES_PKG.Tech_Message (
677: p_severity => g_log_level_2
678: ,p_module => G_BLOCK||'.'||l_api_name
679: ,p_msg_text => 'No Value Set Id for the Given GVSC '|| l_gvsc_id);
680:

Line 681: FEM_ENGINES_PKG.User_Message (

677: p_severity => g_log_level_2
678: ,p_module => G_BLOCK||'.'||l_api_name
679: ,p_msg_text => 'No Value Set Id for the Given GVSC '|| l_gvsc_id);
680:
681: FEM_ENGINES_PKG.User_Message (
682: p_app_name => G_PFT
683: ,p_msg_name => G_ENG_INVALID_GVSC_ERR
684: ,p_token1 => 'GVSC_ID'
685: ,p_value1 => l_gvsc_id);

Line 746: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

742: -- add mapped columns
743: RETURN l_update_head_stmt || ' ' || l_select_stmt || ' ' || l_from_stmt
744: || ' ' || l_where_stmt ;
745:
746: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
747: ,p_module => G_BLOCK||'.'||l_api_name
748: ,p_msg_text => 'END');
749:
750: EXCEPTION

Line 779: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

775: l_message VARCHAR2(4000);
776:
777: BEGIN
778:
779: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
780: ,p_module => G_BLOCK||'.'||l_api_name
781: ,p_msg_text => 'msg_count='||p_msg_count);
782:
783: l_msg_data := p_msg_data;

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

787: FND_MESSAGE.Set_Encoded(l_msg_data);
788:
789: l_message := FND_MESSAGE.Get;
790:
791: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
792:
793: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
794: ,p_module => G_BLOCK||'.'||l_api_name
795: ,p_msg_text => 'msg_data='||l_message);

Line 793: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

789: l_message := FND_MESSAGE.Get;
790:
791: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
792:
793: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
794: ,p_module => G_BLOCK||'.'||l_api_name
795: ,p_msg_text => 'msg_data='||l_message);
796:
797: ELSIF (p_msg_count > 1) THEN

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

801: ,p_encoded => FND_API.G_FALSE
802: ,p_data => l_message
803: ,p_msg_index_out => l_msg_out);
804:
805: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
806:
807: FEM_ENGINES_PKG.Tech_Message (
808: p_severity => g_log_level_2
809: ,p_module => G_BLOCK||'.'||l_api_name

Line 807: FEM_ENGINES_PKG.Tech_Message (

803: ,p_msg_index_out => l_msg_out);
804:
805: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
806:
807: FEM_ENGINES_PKG.Tech_Message (
808: p_severity => g_log_level_2
809: ,p_module => G_BLOCK||'.'||l_api_name
810: ,p_msg_text => 'msg_data = '||l_message);
811:

Line 849: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

845: e_upd_num_input_rows_error EXCEPTION;
846:
847: BEGIN
848:
849: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
850: ,p_module => G_BLOCK||'.'||l_api_name
851: ,p_msg_text => 'BEGIN');
852:
853: -- Set the number of output rows for the output table.

Line 872: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

868: ,p_msg_data => l_msg_data);
869: RAISE e_upd_num_input_rows_error;
870: END IF;
871:
872: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
873: ,p_module => G_BLOCK||'.'||l_api_name
874: ,p_msg_text => 'END');
875:
876: EXCEPTION

Line 878: FEM_ENGINES_PKG.Tech_Message (

874: ,p_msg_text => 'END');
875:
876: EXCEPTION
877: WHEN e_upd_num_input_rows_error THEN
878: FEM_ENGINES_PKG.Tech_Message (
879: p_severity => g_log_level_5
880: ,p_module => G_BLOCK||'.'||l_api_name
881: ,p_msg_text => 'Update Input Rows Exception');
882:

Line 883: FEM_ENGINES_PKG.User_Message (

879: p_severity => g_log_level_5
880: ,p_module => G_BLOCK||'.'||l_api_name
881: ,p_msg_text => 'Update Input Rows Exception');
882:
883: FEM_ENGINES_PKG.User_Message (
884: p_app_name => G_PFT
885: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
886:
887: RAISE e_process_single_rule_error;

Line 890: FEM_ENGINES_PKG.Tech_Message (

886:
887: RAISE e_process_single_rule_error;
888:
889: WHEN OTHERS THEN
890: FEM_ENGINES_PKG.Tech_Message (
891: p_severity => g_log_level_5
892: ,p_module => G_BLOCK||'.'||l_api_name
893: ,p_msg_text => 'Update Input Rows Exception');
894:

Line 895: FEM_ENGINES_PKG.User_Message (

891: p_severity => g_log_level_5
892: ,p_module => G_BLOCK||'.'||l_api_name
893: ,p_msg_text => 'Update Input Rows Exception');
894:
895: FEM_ENGINES_PKG.User_Message (
896: p_app_name => G_PFT
897: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
898:
899: RAISE e_process_single_rule_error;