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

Line 200: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197:
198: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
199:
200: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
201: ,p_module => G_BLOCK||'.'||l_api_name
202: ,p_msg_text => 'BEGIN');
203:
204: FEM_ENGINES_PKG.Tech_Message (

Line 204: FEM_ENGINES_PKG.Tech_Message (

200: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
201: ,p_module => G_BLOCK||'.'||l_api_name
202: ,p_msg_text => 'BEGIN');
203:
204: FEM_ENGINES_PKG.Tech_Message (
205: p_severity => g_log_level_2
206: ,p_module => G_BLOCK||'.'||l_api_name
207: ,p_msg_text => 'Get The Level for which the
208: Region Counting has to be performed');

Line 222: FEM_ENGINES_PKG.Tech_Message (

218: WHEN OTHERS THEN
219: RAISE;
220: END;
221:
222: FEM_ENGINES_PKG.Tech_Message (
223: p_severity => g_log_level_2
224: ,p_module => G_BLOCK||'.'||l_api_name
225: ,p_msg_text => 'Getting Global VS Combo ID');
226:

Line 233: FEM_ENGINES_PKG.Tech_Message (

229: ,x_err_code => l_err_code
230: ,x_num_msg => l_num_msg);
231:
232: IF(l_err_code <> 0)THEN
233: FEM_ENGINES_PKG.Tech_Message (
234: p_severity => g_log_level_2
235: ,p_module => G_BLOCK||'.'||l_api_name
236: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
237:

Line 238: FEM_ENGINES_PKG.User_Message (

234: p_severity => g_log_level_2
235: ,p_module => G_BLOCK||'.'||l_api_name
236: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
237:
238: FEM_ENGINES_PKG.User_Message (
239: p_app_name => G_PFT
240: ,p_msg_name => G_ENG_INVALID_LEDGER_ERR
241: ,p_token1 => 'LEDGER_ID'
242: ,p_value1 => p_ledger_id);

Line 247: FEM_ENGINES_PKG.Tech_Message (

243:
244: RAISE e_process_single_rule_error;
245: END IF;
246:
247: FEM_ENGINES_PKG.Tech_Message (
248: p_severity => g_log_level_2
249: ,p_module => G_BLOCK||'.'||l_api_name
250: ,p_msg_text => 'Getting Customer Value Set Id');
251:

Line 261: FEM_ENGINES_PKG.Tech_Message (

257: AND dim.dimension_varchar_label = 'CUSTOMER'
258: AND gvsc.global_vs_combo_id = l_gvsc_id;
259: EXCEPTION
260: WHEN no_data_found THEN
261: FEM_ENGINES_PKG.Tech_Message (
262: p_severity => g_log_level_2
263: ,p_module => G_BLOCK||'.'||l_api_name
264: ,p_msg_text => 'No Value Set Id for the Given GVSC '|| l_gvsc_id);
265:

Line 266: FEM_ENGINES_PKG.User_Message (

262: p_severity => g_log_level_2
263: ,p_module => G_BLOCK||'.'||l_api_name
264: ,p_msg_text => 'No Value Set Id for the Given GVSC '|| l_gvsc_id);
265:
266: FEM_ENGINES_PKG.User_Message (
267: p_app_name => G_PFT
268: ,p_msg_name => G_ENG_INVALID_GVSC_ERR
269: ,p_token1 => 'GVSC_ID'
270: ,p_value1 => l_gvsc_id);

Line 285: FEM_ENGINES_PKG.Tech_Message (

281: FROM fem_customers_b
282: WHERE value_set_id = l_value_set_id
283: AND dimension_group_id = p_customer_level;
284:
285: FEM_ENGINES_PKG.Tech_Message (
286: p_severity => g_log_level_3
287: ,p_module => G_BLOCK||'.'||l_api_name
288: ,p_msg_text => 'Generating the dataset where clause');
289:

Line 308: FEM_ENGINES_PKG.User_Message (

304: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
305: Get_Put_Messages ( p_msg_count => l_msg_count
306: ,p_msg_data => l_msg_data);
307:
308: FEM_ENGINES_PKG.User_Message (
309: p_app_name => G_PFT
310: ,p_msg_name => G_ENG_DS_WHERE_CLAUSE_ERR
311: ,p_token1 => 'OUTPUT_DS_CODE'
312: ,p_value1 => p_dataset_io_obj_def_id

Line 317: FEM_ENGINES_PKG.User_Message (

313: ,p_token2 => 'CAL_PERIOD_ID'
314: ,p_value2 => p_cal_period_id);
315:
316: IF (l_ds_where_clause IS NULL) THEN
317: FEM_ENGINES_PKG.User_Message (
318: p_app_name => G_PFT
319: ,p_msg_name => G_ENG_DS_WHERE_CLAUSE_ERR
320: ,p_token1 => 'OUTPUT_DS_CODE'
321: ,p_value1 => p_dataset_io_obj_def_id

Line 338: FEM_ENGINES_PKG.Tech_Message (

334: ELSE
335: l_reuse_slices := 'N';
336: END IF;
337:
338: FEM_ENGINES_PKG.Tech_Message (
339: p_severity => g_log_level_3
340: ,p_module => G_BLOCK||'.'||l_api_name
341: ,p_msg_text => 'Getting the region code attribute id');
342:

Line 351: FEM_ENGINES_PKG.Tech_Message (

347: WHERE dim_attr.dimension_id = xdim.dimension_id
348: AND dim_attr.attribute_varchar_label = 'REGION_CODE'
349: AND xdim.dimension_varchar_label = 'CUSTOMER';
350:
351: FEM_ENGINES_PKG.Tech_Message (
352: p_severity => g_log_level_3
353: ,p_module => G_BLOCK||'.'||l_api_name
354: ,p_msg_text => 'Get the total no. of customers who doesnt have a region code in the given level');
355:

Line 366: FEM_ENGINES_PKG.Tech_Message (

362: AND customer_id NOT IN(SELECT customer_id
363: FROM fem_customers_attr
364: WHERE attribute_id = l_attribute_id);
365:
366: FEM_ENGINES_PKG.Tech_Message (
367: p_severity => g_log_level_3
368: ,p_module => G_BLOCK||'.'||l_api_name
369: ,p_msg_text => 'Check whether region counting is already done for the given level and parameters');
370:

Line 414: FEM_ENGINES_PKG.Tech_Message (

410: END IF;
411:
412: -- Perform region counting for the customers for whom Region code is
413: -- assigned
414: FEM_ENGINES_PKG.Tech_Message (
415: p_severity => g_log_level_3
416: ,p_module => G_BLOCK||'.'||l_api_name
417: ,p_msg_text => 'Perform Region Counting for the region code assigned customers');
418:

Line 419: FEM_ENGINES_PKG.Tech_Message (

415: p_severity => g_log_level_3
416: ,p_module => G_BLOCK||'.'||l_api_name
417: ,p_msg_text => 'Perform Region Counting for the region code assigned customers');
418:
419: FEM_ENGINES_PKG.Tech_Message (
420: p_severity => g_log_level_3
421: ,p_module => G_BLOCK||'.'||l_api_name
422: ,p_msg_text => 'SQL:' ||l_bulk_sql );
423:

Line 449: FEM_ENGINES_PKG.Tech_Message (

445:
446: IF l_cust_wo_rgn_code <> 0 THEN
447: -- Perform region counting for the customers for whom Region code is
448: -- not assigned(NULL)
449: FEM_ENGINES_PKG.Tech_Message (
450: p_severity => g_log_level_3
451: ,p_module => G_BLOCK||'.'||l_api_name
452: ,p_msg_text => 'Perform Region Counting for the customers region code is null');
453:

Line 454: FEM_ENGINES_PKG.Tech_Message (

450: p_severity => g_log_level_3
451: ,p_module => G_BLOCK||'.'||l_api_name
452: ,p_msg_text => 'Perform Region Counting for the customers region code is null');
453:
454: FEM_ENGINES_PKG.Tech_Message (
455: p_severity => g_log_level_3
456: ,p_module => G_BLOCK||'.'||l_api_name
457: ,p_msg_text => 'SQL:' ||l_bulk_sql1 );
458: BEGIN

Line 495: FEM_ENGINES_PKG.Tech_Message (

491: -- commit the work
492: COMMIT;
493:
494: ELSE
495: FEM_ENGINES_PKG.Tech_Message (
496: p_severity => G_LOG_LEVEL_2
497: ,p_module => G_BLOCK||'.'||l_api_name
498: ,p_msg_text => 'Region Counting is already performed for this Level');
499: END IF;

Line 501: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

497: ,p_module => G_BLOCK||'.'||l_api_name
498: ,p_msg_text => 'Region Counting is already performed for this Level');
499: END IF;
500:
501: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
502: ,p_module => G_BLOCK||'.'||l_api_name
503: ,p_msg_text => 'END');
504:
505: EXCEPTION

Line 508: FEM_ENGINES_PKG.Tech_Message (

504:
505: EXCEPTION
506: WHEN e_process_single_rule_error THEN
507:
508: FEM_ENGINES_PKG.Tech_Message (
509: p_severity => g_log_level_5
510: ,p_module => G_BLOCK||'.'||l_api_name
511: ,p_msg_text => 'Generate Region Counting Error:
512: Process Single Rule Exception');

Line 514: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

510: ,p_module => G_BLOCK||'.'||l_api_name
511: ,p_msg_text => 'Generate Region Counting Error:
512: Process Single Rule Exception');
513:
514: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
515: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
516:
517: x_return_status := FND_API.G_RET_STS_ERROR;
518:

Line 521: FEM_ENGINES_PKG.Tech_Message (

517: x_return_status := FND_API.G_RET_STS_ERROR;
518:
519: WHEN OTHERS THEN
520:
521: FEM_ENGINES_PKG.Tech_Message (
522: p_severity => g_log_level_5
523: ,p_module => G_BLOCK||'.'||l_api_name
524: ,p_msg_text => 'Generate Region Counting Error:
525: Process Single Rule Exception');

Line 527: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

523: ,p_module => G_BLOCK||'.'||l_api_name
524: ,p_msg_text => 'Generate Region Counting Error:
525: Process Single Rule Exception');
526:
527: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
528: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
529:
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:

Line 564: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

560: e_upd_num_output_rows_error EXCEPTION;
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: -- Set the number of output rows for the output table.

Line 591: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

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

Line 597: FEM_ENGINES_PKG.Tech_Message (

593: ,p_msg_text => 'END');
594:
595: EXCEPTION
596: WHEN e_upd_num_output_rows_error THEN
597: FEM_ENGINES_PKG.Tech_Message (
598: p_severity => g_log_level_5
599: ,p_module => G_BLOCK||'.'||l_api_name
600: ,p_msg_text => 'Update Rows Exception');
601:

Line 602: FEM_ENGINES_PKG.User_Message (

598: p_severity => g_log_level_5
599: ,p_module => G_BLOCK||'.'||l_api_name
600: ,p_msg_text => 'Update Rows Exception');
601:
602: FEM_ENGINES_PKG.User_Message (
603: p_app_name => G_PFT
604: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
605:
606: RAISE e_process_single_rule_error;

Line 609: FEM_ENGINES_PKG.User_Message (

605:
606: RAISE e_process_single_rule_error;
607:
608: WHEN OTHERS THEN
609: FEM_ENGINES_PKG.User_Message (
610: p_app_name => G_PFT
611: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
612:
613: RAISE e_process_single_rule_error;

Line 646: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

642: e_upd_obj_exec_step_stat_error EXCEPTION;
643:
644: BEGIN
645:
646: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
647: ,p_module => G_BLOCK||'.'||l_api_name
648: ,p_msg_text => 'BEGIN');
649:
650: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure

Line 672: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

668: RAISE e_upd_obj_exec_step_stat_error;
669:
670: END IF;
671:
672: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
673: ,p_module => G_BLOCK||'.'||l_api_name
674: ,p_msg_text => 'END');
675:
676: EXCEPTION

Line 678: FEM_ENGINES_PKG.Tech_Message (

674: ,p_msg_text => 'END');
675:
676: EXCEPTION
677: WHEN e_upd_obj_exec_step_stat_error THEN
678: FEM_ENGINES_PKG.Tech_Message (
679: p_severity => g_log_level_5
680: ,p_module => G_BLOCK||'.'||l_api_name
681: ,p_msg_text => 'Update Obj Exec Step API Exception');
682:

Line 683: FEM_ENGINES_PKG.User_Message (

679: p_severity => g_log_level_5
680: ,p_module => G_BLOCK||'.'||l_api_name
681: ,p_msg_text => 'Update Obj Exec Step API Exception');
682:
683: FEM_ENGINES_PKG.User_Message (
684: p_app_name => G_PFT
685: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
686: ,p_token1 => 'OBJECT_ID'
687: ,p_value1 => p_rule_obj_id);

Line 692: FEM_ENGINES_PKG.User_Message (

688:
689: RAISE e_process_single_rule_error;
690:
691: WHEN OTHERS THEN
692: FEM_ENGINES_PKG.User_Message (
693: p_app_name => G_PFT
694: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
695: ,p_token1 => 'OBJECT_ID'
696: ,p_value1 => p_rule_obj_id);

Line 722: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

718: l_api_name CONSTANT VARCHAR2(30) := 'Get_Nbr_RowsTable_Request';
719:
720: BEGIN
721:
722: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
723: ,p_module => G_BLOCK||'.'||l_api_name
724: ,p_msg_text => 'BEGIN');
725:
726: --Query the fem_mp_process_ctl_t table to get the number of rows

Line 739: FEM_ENGINES_PKG.Tech_Message (

735: WHERE t.req_id = p_request_id
736: AND t.process_num > 0;
737:
738: IF (x_rows_processed = 0) THEN
739: FEM_ENGINES_PKG.Tech_Message (
740: p_severity => g_log_level_5
741: ,p_module => G_BLOCK||'.'||l_api_name
742: ,p_msg_text => 'No Rows returned by the Insert Statement');
743:

Line 744: FEM_ENGINES_PKG.User_Message (

740: p_severity => g_log_level_5
741: ,p_module => G_BLOCK||'.'||l_api_name
742: ,p_msg_text => 'No Rows returned by the Insert Statement');
743:
744: FEM_ENGINES_PKG.User_Message (
745: p_app_name => G_PFT
746: ,p_msg_name => G_ENG_RCNT_NO_OP_ROWS_ERR);
747:
748: RAISE e_process_single_rule_error;

Line 751: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

747:
748: RAISE e_process_single_rule_error;
749: END IF;
750:
751: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
752: ,p_module => G_BLOCK||'.'||l_api_name
753: ,p_msg_text => 'END');
754:
755: EXCEPTION

Line 784: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

780:
781: BEGIN
782: l_api_name := 'Process_Obj_Exec_Step';
783:
784: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
785: ,p_module => G_BLOCK||'.'||l_api_name
786: ,p_msg_text => 'BEGIN');
787: ------------------------------------------------------------------------
788: --Update the status of the step

Line 790: FEM_ENGINES_PKG.Tech_Message(

786: ,p_msg_text => 'BEGIN');
787: ------------------------------------------------------------------------
788: --Update the status of the step
789: ------------------------------------------------------------------------
790: FEM_ENGINES_PKG.Tech_Message(
791: p_severity => g_log_level_3
792: ,p_module => G_BLOCK||'.'||l_api_name
793: ,p_msg_text => 'Update the status of the step with execution status :'
794: ||p_exe_status_code);

Line 811: FEM_ENGINES_PKG.Tech_Message(

807: x_rows_loaded => l_nbr_loaded_rows,
808: x_rows_rejected => l_nbr_rejected_rows,
809: p_request_id => p_request_id);*/
810:
811: FEM_ENGINES_PKG.Tech_Message(
812: p_severity => g_log_level_3
813: ,p_module => G_BLOCK||'.'||l_api_name
814: ,p_msg_text => 'Rows processed for registered output table :'
815: ||p_tbl_name);

Line 830: FEM_ENGINES_PKG.TECH_MESSAGE(

826:
827: -----------------------------------------------------------------------
828: -- Call FEM_PL_PKG.update_num_of_input_rows();
829: -----------------------------------------------------------------------
830: FEM_ENGINES_PKG.TECH_MESSAGE(
831: p_severity => g_log_level_1,
832: p_module => G_BLOCK||'.'||l_api_name,
833: p_msg_text => 'No:of Rows processed from input table'
834: ||p_num_rows );

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

840: ,p_last_update_login => p_login_id
841: ,p_rule_obj_id => p_rule_obj_id
842: ,p_num_of_input_rows => p_num_rows);
843:
844: FEM_ENGINES_PKG.User_Message(p_app_name => G_PFT,
845: p_msg_name => 'PFT_PPROF_RCNT_ROW_SUMMARY',
846: p_token1 => 'ROWSP',
847: p_value1 => p_num_rows,
848: p_token2 => 'ROWSL',

Line 852: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

848: p_token2 => 'ROWSL',
849: p_value2 => p_num_rows);
850: END IF;
851:
852: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
853: ,p_module => G_BLOCK||'.'||l_api_name
854: ,p_msg_text => 'END');
855:
856: EXCEPTION

Line 908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

904: l_request_id := FND_GLOBAL.Conc_Request_Id;
905: l_user_id := FND_GLOBAL.User_Id;
906: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
907:
908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
909: ,p_module => G_BLOCK||'.'||l_api_name
910: ,p_msg_text => 'BEGIN');
911:
912: l_insert_head_stmt := ' INSERT INTO FEM_REGION_INFO ( ' ||

Line 964: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

960:
961: l_group_by_stmt := ' GROUP BY ' ||
962: ' fca.number_assign_value ';
963:
964: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
965: ,p_module => G_BLOCK||'.'||l_api_name
966: ,p_msg_text => 'END');
967: -- add mapped columns
968: RETURN l_insert_head_stmt || ' ' || l_select_stmt || ' ' || l_from_stmt

Line 1000: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

996: l_message VARCHAR2(4000);
997:
998: BEGIN
999:
1000: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1001: ,p_module => G_BLOCK||'.'||l_api_name
1002: ,p_msg_text => 'msg_count='||p_msg_count);
1003:
1004: l_msg_data := p_msg_data;

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

1007:
1008: FND_MESSAGE.Set_Encoded(l_msg_data);
1009: l_message := FND_MESSAGE.Get;
1010:
1011: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1012:
1013: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1014: ,p_module => G_BLOCK||'.'||l_api_name
1015: ,p_msg_text => 'msg_data='||l_message);

Line 1013: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1009: l_message := FND_MESSAGE.Get;
1010:
1011: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1012:
1013: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1014: ,p_module => G_BLOCK||'.'||l_api_name
1015: ,p_msg_text => 'msg_data='||l_message);
1016:
1017: ELSIF (p_msg_count > 1) THEN

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

1021: ,p_encoded => FND_API.G_FALSE
1022: ,p_data => l_message
1023: ,p_msg_index_out => l_msg_out);
1024:
1025: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1026:
1027: FEM_ENGINES_PKG.Tech_Message (
1028: p_severity => g_log_level_2
1029: ,p_module => G_BLOCK||'.'||l_api_name

Line 1027: FEM_ENGINES_PKG.Tech_Message (

1023: ,p_msg_index_out => l_msg_out);
1024:
1025: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1026:
1027: FEM_ENGINES_PKG.Tech_Message (
1028: p_severity => g_log_level_2
1029: ,p_module => G_BLOCK||'.'||l_api_name
1030: ,p_msg_text => 'msg_data = '||l_message);
1031:

Line 1068: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1064: e_upd_num_input_rows_error EXCEPTION;
1065:
1066: BEGIN
1067:
1068: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1069: ,p_module => G_BLOCK||'.'||l_api_name
1070: ,p_msg_text => 'BEGIN');
1071:
1072: -- Set the number of output rows for the output table.

Line 1091: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

1087: ,p_msg_data => l_msg_data);
1088: RAISE e_upd_num_input_rows_error;
1089: END IF;
1090:
1091: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
1092: ,p_module => G_BLOCK||'.'||l_api_name
1093: ,p_msg_text => 'END');
1094:
1095: EXCEPTION

Line 1097: FEM_ENGINES_PKG.Tech_Message (

1093: ,p_msg_text => 'END');
1094:
1095: EXCEPTION
1096: WHEN e_upd_num_input_rows_error THEN
1097: FEM_ENGINES_PKG.Tech_Message (
1098: p_severity => g_log_level_5
1099: ,p_module => G_BLOCK||'.'||l_api_name
1100: ,p_msg_text => 'Update Input Rows Exception');
1101:

Line 1102: FEM_ENGINES_PKG.User_Message (

1098: p_severity => g_log_level_5
1099: ,p_module => G_BLOCK||'.'||l_api_name
1100: ,p_msg_text => 'Update Input Rows Exception');
1101:
1102: FEM_ENGINES_PKG.User_Message (
1103: p_app_name => G_PFT
1104: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
1105:
1106: RAISE e_process_single_rule_error;

Line 1109: FEM_ENGINES_PKG.Tech_Message (

1105:
1106: RAISE e_process_single_rule_error;
1107:
1108: WHEN OTHERS THEN
1109: FEM_ENGINES_PKG.Tech_Message (
1110: p_severity => g_log_level_5
1111: ,p_module => G_BLOCK||'.'||l_api_name
1112: ,p_msg_text => 'Update Input Rows Exception');
1113:

Line 1114: FEM_ENGINES_PKG.User_Message (

1110: p_severity => g_log_level_5
1111: ,p_module => G_BLOCK||'.'||l_api_name
1112: ,p_msg_text => 'Update Input Rows Exception');
1113:
1114: FEM_ENGINES_PKG.User_Message (
1115: p_app_name => G_PFT
1116: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
1117:
1118: RAISE e_process_single_rule_error;

Line 1169: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1165: l_request_id := FND_GLOBAL.Conc_Request_Id;
1166: l_user_id := FND_GLOBAL.User_Id;
1167: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1168:
1169: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1170: ,p_module => G_BLOCK||'.'||l_api_name
1171: ,p_msg_text => 'BEGIN');
1172:
1173: l_insert_head_stmt := ' INSERT INTO FEM_REGION_INFO ( ' ||

Line 1205: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

1201:
1202: l_from_stmt := ' FROM ' ||
1203: ' DUAL';
1204:
1205: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
1206: ,p_module => G_BLOCK||'.'||l_api_name
1207: ,p_msg_text => 'END');
1208: -- add mapped columns
1209: RETURN l_insert_head_stmt || ' ' || l_select_stmt || ' ' || l_from_stmt;