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

Line 263: fem_engines_pkg.tech_message( p_severity => g_log_level_2

259: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;
260: -- initialize status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: fem_engines_pkg.tech_message( p_severity => g_log_level_2
264: ,p_module => G_BLOCK||l_api_name
265: ,p_msg_text => 'BEGIN');
266:
267: -- initialize msg stack?

Line 280: FEM_ENGINES_PKG.User_Message (

276: IF (p_obj_id IS NULL OR p_dataset_grp_obj_def_id IS NULL OR
277: p_effective_date IS NULL OR p_output_cal_period_id IS NULL OR
278: p_ledger_id IS NULL) THEN
279:
280: FEM_ENGINES_PKG.User_Message (
281: p_app_name => G_FEM
282: ,p_msg_name => G_ENG_BAD_CONC_REQ_PARAM_ERR);
283:
284: RAISE e_pagg_engine_error;

Line 292: fem_engines_pkg.tech_message (

288: --------------------------------------------------------------------------
289: -- STEP 1: Engine Master Preparation
290: --------------------------------------------------------------------------
291:
292: fem_engines_pkg.tech_message (
293: p_severity => g_log_level_1
294: ,p_module => G_BLOCK||'.'||l_api_name
295: ,p_msg_text => 'Step 1: Engine Master Preperation');
296:

Line 310: fem_engines_pkg.tech_message (

306:
307: -----------------------------------------------------------------------------
308: -- STEP 2: registering process request for either a single rule or a rule set
309: -----------------------------------------------------------------------------
310: fem_engines_pkg.tech_message (
311: p_severity => g_log_level_3
312: ,p_module => G_BLOCK||'.'||l_api_name
313: ,p_msg_text => 'Step 2: Register Request');
314:

Line 323: fem_engines_pkg.tech_message (

319: IF (l_param_rec.obj_type_code = 'PPROF_PROFIT_AGG') THEN
320: -----------------------------------------------------------------------
321: -- STEP 3: Processing for a single rule submission
322: -----------------------------------------------------------------------
323: fem_engines_pkg.tech_message (
324: p_severity => g_log_level_3
325: ,p_module => G_BLOCK||'.'||l_api_name
326: ,p_msg_text => 'Step 3: Process for a single rule ');
327:

Line 334: fem_engines_pkg.tech_message (

330:
331:
332: Process_Single_Rule( p_param_rec => l_param_rec);
333:
334: fem_engines_pkg.tech_message (
335: p_severity => g_log_level_3
336: ,p_module => G_BLOCK||'.'||l_api_name
337: ,p_msg_text => 'Status After Process for a single rule '
338: || l_param_rec.return_status);

Line 353: fem_engines_pkg.tech_message (

349: ELSIF (l_param_rec.obj_type_code = 'RULE_SET') THEN
350: -----------------------------------------------------------------------
351: -- STEP 4: Processing for a rule set
352: -----------------------------------------------------------------------
353: fem_engines_pkg.tech_message (
354: p_severity => G_LOG_LEVEL_1
355: ,p_module => G_BLOCK||'.'||l_api_name
356: ,p_msg_text => 'Step 4.1: Rule Set Processing');
357: -----------------------------------------------------------------------

Line 361: fem_engines_pkg.tech_message(

357: -----------------------------------------------------------------------
358: -- STEP 4.1: Flattening the rule set
359: -----------------------------------------------------------------------
360:
361: fem_engines_pkg.tech_message(
362: p_severity => g_log_level_3
363: ,p_module => G_BLOCK||'.'||l_api_name
364: ,p_msg_text => 'Step 4.2 Flatten the rule set');
365:

Line 371: fem_engines_pkg.tech_message(

367: ,l_param_rec.crnt_proc_child_obj_id)<> 0) THEN
368: --------------------------------------------------------------------
369: -- STEP 4.2: Preprocess rule set
370: --------------------------------------------------------------------
371: fem_engines_pkg.tech_message(
372: p_severity => g_log_level_1
373: ,p_module => G_BLOCK||'.'||l_api_name
374: ,p_msg_text => 'Step 4.2 PreProcess rule set' );
375:

Line 386: fem_engines_pkg.tech_message(

382: -- STEP 4.3.3: Process each rule in the rule set loop
383: -- STEP 4.3.4: Execution status for rule processing
384: -----------------------------------------------------------------------
385:
386: fem_engines_pkg.tech_message(
387: p_severity => g_log_level_1
388: ,p_module => G_BLOCK||'.'||l_api_name
389: ,p_msg_text => 'Step 4.3.1: Loop through all Rule Set Rules');
390:

Line 395: fem_engines_pkg.tech_message(

391: OPEN l_rule_set_rules(l_param_rec.request_id,l_param_rec.obj_id);
392:
393: l_rule_set_rules_is_open := TRUE;
394:
395: fem_engines_pkg.tech_message(
396: p_severity => g_log_level_1
397: ,p_module => G_BLOCK||'.'||l_api_name
398: ,p_msg_text => 'Step 4.3.2:Rule set loop');
399:

Line 406: fem_engines_pkg.tech_message(

402: l_next_rule_obj_def_id,
403: l_next_rule_exec_status;
404:
405:
406: fem_engines_pkg.tech_message(
407: p_severity => g_log_level_1
408: ,p_module => G_BLOCK||'.'||l_api_name
409: ,p_msg_text => 'Step 4.3.3: Process next rule in rule set: '||
410: l_next_rule_obj_id);

Line 412: fem_engines_pkg.tech_message(

408: ,p_module => G_BLOCK||'.'||l_api_name
409: ,p_msg_text => 'Step 4.3.3: Process next rule in rule set: '||
410: l_next_rule_obj_id);
411:
412: fem_engines_pkg.tech_message(
413: p_severity => g_log_level_1
414: ,p_module => G_BLOCK||'.'||l_api_name
415: ,p_msg_text => 'Step 4.3.4: Process next rule in rule set status:'
416: || l_next_rule_exec_status);

Line 433: fem_engines_pkg.tech_message(

429: -----------------------------------------------------------------
430: -- STEP 4.2.3: Process Rule Set Rule
431: -----------------------------------------------------------------
432:
433: fem_engines_pkg.tech_message(
434: p_severity => g_log_level_1
435: ,p_module => G_BLOCK||'.'||l_api_name
436: ,p_msg_text => 'Step 4.3.5: Process Rule Set Rule #'
437: ||TO_CHAR(l_rollup_sequence));

Line 441: fem_engines_pkg.tech_message (

437: ||TO_CHAR(l_rollup_sequence));
438:
439: Process_Single_Rule( p_param_rec => l_param_rec );
440:
441: fem_engines_pkg.tech_message (
442: p_severity => g_log_level_3
443: ,p_module => G_BLOCK||'.'||l_api_name
444: ,p_msg_text => 'Status After Process for a single rule '
445: || l_param_rec.return_status);

Line 475: fem_engines_pkg.tech_message (

471:
472: --------------------------------------------------------------------------
473: -- STEP 5: Engine Master Post Processing.
474: --------------------------------------------------------------------------
475: fem_engines_pkg.tech_message (
476: p_severity => g_log_level_3
477: ,p_module => G_BLOCK||'.'||l_api_name
478: ,p_msg_text => 'Step 5: Engine Master Post Processing');
479:

Line 496: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

492: END IF;
493:
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495:
496: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
497: ,p_module => G_BLOCK||'.'||l_api_name
498: ,p_msg_text => 'END');
499:
500: EXCEPTION

Line 513: fem_engines_pkg.tech_message (

509:
510: l_completion_status := FND_CONCURRENT.Set_Completion_Status( 'ERROR'
511: ,NULL);
512:
513: fem_engines_pkg.tech_message (
514: p_severity => g_log_level_5
515: ,p_module => G_BLOCK||'.'||l_api_name
516: ,p_msg_text => 'Profit Aggregation Engine Error');
517:

Line 518: --FEM_ENGINES_PKG.User_Message (

514: p_severity => g_log_level_5
515: ,p_module => G_BLOCK||'.'||l_api_name
516: ,p_msg_text => 'Profit Aggregation Engine Error');
517:
518: --FEM_ENGINES_PKG.User_Message (
519: -- p_app_name => G_PFT
520: -- ,p_msg_text => 'Profit Aggregation Engine Error');
521:
522: -- Set the return status to ERROR

Line 540: fem_engines_pkg.tech_message (

536:
537: l_completion_status := FND_CONCURRENT.Set_Completion_Status( 'ERROR'
538: ,NULL);
539:
540: fem_engines_pkg.tech_message (
541: p_severity => g_log_level_6
542: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
543: ,p_msg_text => gv_prg_msg);
544:

Line 545: fem_engines_pkg.tech_message (

541: p_severity => g_log_level_6
542: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
543: ,p_msg_text => gv_prg_msg);
544:
545: fem_engines_pkg.tech_message (
546: p_severity => g_log_level_6
547: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
548: ,p_msg_text => gv_callstack);
549:

Line 550: FEM_ENGINES_PKG.User_Message (

546: p_severity => g_log_level_6
547: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
548: ,p_msg_text => gv_callstack);
549:
550: FEM_ENGINES_PKG.User_Message (
551: p_app_name => G_FEM
552: ,p_msg_name => G_UNEXPECTED_ERROR
553: ,p_token1 => 'ERR_MSG'
554: ,p_value1 => gv_prg_msg);

Line 594: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

590: e_eng_master_prep_error EXCEPTION;
591:
592: BEGIN
593:
594: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
595: ,p_module => G_BLOCK||'.'||l_api_name
596: ,p_msg_text => 'BEGIN');
597:
598: --------------------------------------------------------------------------

Line 624: fem_engines_pkg.tech_message (

620:
621: ----------------------------------------------------------------------------
622: -- Get the object info from fem_object_catalog_b for the object_id passed in
623: ----------------------------------------------------------------------------
624: fem_engines_pkg.tech_message (
625: p_severity => g_log_level_3
626: ,p_module => G_BLOCK||'.'||l_api_name
627: ,p_msg_text => 'Getting the Object Type Code of the given Object');
628:

Line 639: FEM_ENGINES_PKG.User_Message (

635: WHERE object_id = x_param_rec.obj_id;
636:
637: EXCEPTION
638: WHEN OTHERS THEN
639: FEM_ENGINES_PKG.User_Message (
640: p_app_name => G_PFT
641: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
642: ,p_token1 => 'OBJECT_ID'
643: ,p_value1 => x_param_rec.obj_id);

Line 645: fem_engines_pkg.tech_message (

641: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
642: ,p_token1 => 'OBJECT_ID'
643: ,p_value1 => x_param_rec.obj_id);
644:
645: fem_engines_pkg.tech_message (
646: p_severity => g_log_level_3
647: ,p_module => G_BLOCK||'.'||l_api_name
648: ,p_msg_text => 'Invalid Object Id' || x_param_rec.obj_id);
649:

Line 659: fem_engines_pkg.tech_message (

655: -- local_vs_combo_id of the rollup rule matches the Rule Set's.
656: --------------------------------------------------------------------------
657: IF (x_param_rec.obj_type_code = 'RULE_SET') THEN
658:
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 => 'Obj type code is a rule set');
663:

Line 673: FEM_ENGINES_PKG.User_Message (

669: ,x_obj_def_id => x_param_rec.crnt_proc_child_obj_defn_id);
670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: FEM_ENGINES_PKG.User_Message (
674: p_app_name => G_PFT
675: ,p_msg_name => G_ENG_INV_OBJ_DEFN_RS_ERR
676: ,p_token1 => 'OBJECT_ID'
677: ,p_value1 => x_param_rec.obj_id

Line 681: fem_engines_pkg.tech_message (

677: ,p_value1 => x_param_rec.obj_id
678: ,p_token2 => 'EFFECTIVE_DATE'
679: ,p_value2 => x_param_rec.effective_date);
680:
681: fem_engines_pkg.tech_message (
682: p_severity => g_log_level_3
683: ,p_module => G_BLOCK||'.'||l_api_name
684: ,p_msg_text => 'No Definition found for the ruleset :'
685: || x_param_rec.obj_id || 'for the Date :'

Line 692: fem_engines_pkg.tech_message (

688: RAISE e_eng_master_prep_error;
689: END;
690:
691: ELSIF (x_param_rec.obj_type_code = 'PPROF_PROFIT_AGG') THEN
692: fem_engines_pkg.tech_message (
693: p_severity => g_log_level_3
694: ,p_module => G_BLOCK||'.'||l_api_name
695: ,p_msg_text => 'Obj type code is a single rule');
696:

Line 706: FEM_ENGINES_PKG.User_Message (

702: ,x_obj_def_id => x_param_rec.crnt_proc_child_obj_defn_id);
703:
704: EXCEPTION
705: WHEN OTHERS THEN
706: FEM_ENGINES_PKG.User_Message (
707: p_app_name => G_PFT
708: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
709: ,p_token1 => 'OBJECT_ID'
710: ,p_value1 => x_param_rec.obj_id

Line 714: fem_engines_pkg.tech_message (

710: ,p_value1 => x_param_rec.obj_id
711: ,p_token2 => 'EFFECTIVE_DATE'
712: ,p_value2 => x_param_rec.effective_date);
713:
714: fem_engines_pkg.tech_message (
715: p_severity => g_log_level_3
716: ,p_module => G_BLOCK||'.'||l_api_name
717: ,p_msg_text => 'No Definition found for the Rule :'
718: || x_param_rec.obj_id || 'for the Date :'

Line 724: FEM_ENGINES_PKG.User_Message(

720: RAISE e_eng_master_prep_error;
721: END;
722:
723: ELSE
724: FEM_ENGINES_PKG.User_Message(
725: p_app_name => G_PFT
726: ,p_msg_name => G_ENG_INVALIDRULETYPE_ERR
727: ,p_token1 => 'OBJECT_TYPE_CODE'
728: ,p_value1 => x_param_rec.obj_type_code);

Line 744: FEM_ENGINES_PKG.User_Message (

740: FROM fem_object_definition_b
741: WHERE object_definition_id = x_param_rec.dataset_io_obj_def_id;
742: EXCEPTION
743: WHEN OTHERS THEN
744: FEM_ENGINES_PKG.User_Message (
745: p_app_name => G_PFT
746: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
747: ,p_token1 => 'OBJECT_ID'
748: ,p_value1 => x_param_rec.dataset_io_obj_def_id);

Line 750: fem_engines_pkg.tech_message (

746: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
747: ,p_token1 => 'OBJECT_ID'
748: ,p_value1 => x_param_rec.dataset_io_obj_def_id);
749:
750: fem_engines_pkg.tech_message (
751: p_severity => g_log_level_3
752: ,p_module => G_BLOCK||'.'||l_api_name
753: ,p_msg_text => 'No Object found for the given Dataset Group:'
754: || x_param_rec.dataset_io_obj_def_id);

Line 761: fem_engines_pkg.tech_message (

757:
758: --------------------------------------------------------------------------
759: -- Get the Output Dataset Code
760: --------------------------------------------------------------------------
761: fem_engines_pkg.tech_message (
762: p_severity => g_log_level_3
763: ,p_module => G_BLOCK||'.'||l_api_name
764: ,p_msg_text => 'Getting the output DS Code for the given DS Group');
765:

Line 773: FEM_ENGINES_PKG.User_Message (

769: FROM fem_ds_input_output_defs
770: WHERE dataset_io_obj_def_id = x_param_rec.dataset_io_obj_def_id;
771: EXCEPTION
772: WHEN OTHERS THEN
773: FEM_ENGINES_PKG.User_Message (
774: p_app_name => G_PFT
775: ,p_msg_name => G_ENG_NO_OUTPUT_DS_ERR
776: ,p_token1 => 'DATASET_GROUP_OBJ_DEF_ID'
777: ,p_value1 => x_param_rec.dataset_io_obj_def_id);

Line 779: fem_engines_pkg.tech_message (

775: ,p_msg_name => G_ENG_NO_OUTPUT_DS_ERR
776: ,p_token1 => 'DATASET_GROUP_OBJ_DEF_ID'
777: ,p_value1 => x_param_rec.dataset_io_obj_def_id);
778:
779: fem_engines_pkg.tech_message (
780: p_severity => g_log_level_3
781: ,p_module => G_BLOCK||'.'||l_api_name
782: ,p_msg_text => 'No Output Dataset for the DS Group Definition:'
783: || x_param_rec.dataset_io_obj_def_id);

Line 800: FEM_ENGINES_PKG.User_Message (

796: FROM fem_source_systems_b
797: WHERE source_system_display_code = G_PFT;
798: EXCEPTION
799: WHEN OTHERS THEN
800: FEM_ENGINES_PKG.User_Message (
801: p_app_name => G_PFT
802: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
803: ,p_token1 => 'OBJECT_ID'
804: ,p_value1 => x_param_rec.obj_id);

Line 814: fem_engines_pkg.tech_message (

810:
811: -- Log all Request Record Parameters if we have low level debugging
812: IF ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) ) THEN
813:
814: fem_engines_pkg.tech_message (
815: p_severity => G_LOG_LEVEL_1
816: ,p_module => G_BLOCK||'.'||l_api_name||'.x_param_rec'
817: ,p_msg_text =>
818: ' dataset_grp_obj_def_id='||x_param_rec.dataset_io_obj_def_id||

Line 842: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

838: );
839:
840: END IF;
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 => 'END');
845:
846: EXCEPTION

Line 848: fem_engines_pkg.tech_message (

844: ,p_msg_text => 'END');
845:
846: EXCEPTION
847: WHEN e_eng_master_prep_error THEN
848: fem_engines_pkg.tech_message (
849: p_severity => g_log_level_5
850: ,p_module => G_BLOCK||'.'||l_api_name
851: ,p_msg_text => 'Engine Master Preperation Exception');
852: RAISE e_pagg_engine_error;

Line 882: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

878: e_pl_register_request_error EXCEPTION;
879:
880: BEGIN
881:
882: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
883: ,p_module => G_BLOCK||'.'||l_api_name
884: ,p_msg_text => 'BEGIN');
885:
886: SAVEPOINT register_request_pub;

Line 923: fem_engines_pkg.tech_message (

919: END IF;
920:
921: COMMIT;
922:
923: fem_engines_pkg.tech_message (
924: p_severity => g_log_level_1
925: ,p_module => G_BLOCK||'.'||l_api_name
926: ,p_msg_text => 'Request id is '||p_param_rec.request_id);
927:

Line 928: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

924: p_severity => g_log_level_1
925: ,p_module => G_BLOCK||'.'||l_api_name
926: ,p_msg_text => 'Request id is '||p_param_rec.request_id);
927:
928: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
929: ,p_module => G_BLOCK||'.'||l_api_name
930: ,p_msg_text => 'END');
931:
932: EXCEPTION

Line 937: fem_engines_pkg.tech_message (

933: WHEN e_pl_register_request_error THEN
934:
935: ROLLBACK TO register_request_pub;
936:
937: fem_engines_pkg.tech_message (
938: p_severity => g_log_level_5
939: ,p_module => G_BLOCK||'.'||l_api_name
940: ,p_msg_text => 'Register Request Exception');
941:

Line 942: FEM_ENGINES_PKG.User_Message (

938: p_severity => g_log_level_5
939: ,p_module => G_BLOCK||'.'||l_api_name
940: ,p_msg_text => 'Register Request Exception');
941:
942: FEM_ENGINES_PKG.User_Message (
943: p_app_name => G_PFT
944: ,p_msg_name => G_PL_REG_REQUEST_ERR
945: ,p_token1 => 'REQUEST_ID'
946: ,p_value1 => p_param_rec.request_id);

Line 954: FEM_ENGINES_PKG.User_Message (

950: WHEN OTHERS THEN
951:
952: ROLLBACK TO register_request_pub;
953:
954: FEM_ENGINES_PKG.User_Message (
955: p_app_name => G_PFT
956: ,p_msg_name => G_PL_REG_REQUEST_ERR
957: ,p_token1 => 'REQUEST_ID'
958: ,p_value1 => p_param_rec.request_id);

Line 991: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

987: e_register_obj_def_error EXCEPTION;
988:
989: BEGIN
990:
991: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
992: ,p_module => G_BLOCK||'.'||l_api_name
993: ,p_msg_text => 'BEGIN');
994:
995: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register

Line 1018: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1014: ,p_msg_data => l_msg_data);
1015: RAISE e_register_obj_def_error;
1016: END IF;
1017:
1018: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1019: ,p_module => G_BLOCK||'.'||l_api_name
1020: ,p_msg_text => 'END');
1021:
1022: EXCEPTION

Line 1024: fem_engines_pkg.tech_message (

1020: ,p_msg_text => 'END');
1021:
1022: EXCEPTION
1023: WHEN e_register_obj_def_error THEN
1024: fem_engines_pkg.tech_message (
1025: p_severity => g_log_level_5
1026: ,p_module => G_BLOCK||'.'||l_api_name
1027: ,p_msg_text => 'Register Object Definition Exception');
1028:

Line 1029: FEM_ENGINES_PKG.User_Message (

1025: p_severity => g_log_level_5
1026: ,p_module => G_BLOCK||'.'||l_api_name
1027: ,p_msg_text => 'Register Object Definition Exception');
1028:
1029: FEM_ENGINES_PKG.User_Message (
1030: p_app_name => G_PFT
1031: ,p_msg_name => G_PL_OBJ_EXECLOCK_EXISTS_ERR
1032: ,p_token1 => 'REQUEST_ID'
1033: ,p_value1 => p_param_rec.request_id);

Line 1063: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1059: e_register_obj_exe_step_error EXCEPTION;
1060:
1061: BEGIN
1062:
1063: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1064: ,p_module => G_BLOCK||'.'||l_api_name
1065: ,p_msg_text => 'BEGIN');
1066:
1067: --Call the FEM_PL_PKG.Register_Object_Def API procedure to register step

Line 1089: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1085: ,p_msg_data => l_msg_data);
1086: RAISE e_register_obj_exe_step_error;
1087: END IF;
1088:
1089: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1090: ,p_module => G_BLOCK||'.'||l_api_name
1091: ,p_msg_text => 'END');
1092:
1093: EXCEPTION

Line 1095: fem_engines_pkg.tech_message (

1091: ,p_msg_text => 'END');
1092:
1093: EXCEPTION
1094: WHEN e_register_obj_exe_step_error THEN
1095: fem_engines_pkg.tech_message (
1096: p_severity => g_log_level_5
1097: ,p_module => G_BLOCK||'.'||l_api_name
1098: ,p_msg_text => 'Register Obj Exec Step Exception');
1099:

Line 1100: FEM_ENGINES_PKG.User_Message (

1096: p_severity => g_log_level_5
1097: ,p_module => G_BLOCK||'.'||l_api_name
1098: ,p_msg_text => 'Register Obj Exec Step Exception');
1099:
1100: FEM_ENGINES_PKG.User_Message (
1101: p_app_name => G_PFT
1102: ,p_msg_name => G_PL_REG_EXEC_STEP_ERR
1103: ,p_token1 => 'OBJECT_ID'
1104: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1109: FEM_ENGINES_PKG.User_Message (

1105:
1106: RAISE e_pagg_engine_error;
1107:
1108: WHEN OTHERS THEN
1109: FEM_ENGINES_PKG.User_Message (
1110: p_app_name => G_PFT
1111: ,p_msg_name => G_PL_REG_EXEC_STEP_ERR
1112: ,p_token1 => 'OBJECT_ID'
1113: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1146: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1142: e_register_table_error EXCEPTION;
1143:
1144: BEGIN
1145:
1146: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1147: ,p_module => G_BLOCK||'.'||l_api_name
1148: ,p_msg_text => 'BEGIN');
1149:
1150: -- Call the FEM_PL_PKG.Register_Table API procedure to register

Line 1173: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1169: ,p_msg_data => l_msg_data);
1170: RAISE e_register_table_error;
1171: END IF;
1172:
1173: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1174: ,p_module => G_BLOCK||'.'||l_api_name
1175: ,p_msg_text => 'END');
1176:
1177: EXCEPTION

Line 1179: fem_engines_pkg.tech_message(

1175: ,p_msg_text => 'END');
1176:
1177: EXCEPTION
1178: WHEN e_register_table_error THEN
1179: fem_engines_pkg.tech_message(
1180: p_severity => g_log_level_5
1181: ,p_module => G_BLOCK||'.'||l_api_name
1182: ,p_msg_text => 'Register Table Exception');
1183:

Line 1184: FEM_ENGINES_PKG.User_Message (

1180: p_severity => g_log_level_5
1181: ,p_module => G_BLOCK||'.'||l_api_name
1182: ,p_msg_text => 'Register Table Exception');
1183:
1184: FEM_ENGINES_PKG.User_Message (
1185: p_app_name => G_PFT
1186: ,p_msg_name => G_PL_REG_TABLE_ERR
1187: ,p_token1 => 'TABLE_NAME'
1188: ,p_value1 => p_tbl_name);

Line 1193: FEM_ENGINES_PKG.User_Message (

1189:
1190: RAISE e_pagg_engine_error;
1191:
1192: WHEN OTHERS THEN
1193: FEM_ENGINES_PKG.User_Message (
1194: p_app_name => G_PFT
1195: ,p_msg_name => G_PL_REG_TABLE_ERR
1196: ,p_token1 => 'TABLE_NAME'
1197: ,p_value1 => p_tbl_name);

Line 1229: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1225: e_upd_num_output_rows_error EXCEPTION;
1226:
1227: BEGIN
1228:
1229: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1230: ,p_module => G_BLOCK||'.'||l_api_name
1231: ,p_msg_text => 'BEGIN');
1232:
1233: -- Set the number of output rows for the output table.

Line 1255: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1251: ,p_msg_data => l_msg_data);
1252: RAISE e_upd_num_output_rows_error;
1253: END IF;
1254:
1255: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1256: ,p_module => G_BLOCK||'.'||l_api_name
1257: ,p_msg_text => 'END');
1258:
1259: EXCEPTION

Line 1261: fem_engines_pkg.tech_message (

1257: ,p_msg_text => 'END');
1258:
1259: EXCEPTION
1260: WHEN e_upd_num_output_rows_error THEN
1261: fem_engines_pkg.tech_message (
1262: p_severity => g_log_level_5
1263: ,p_module => G_BLOCK||'.'||l_api_name
1264: ,p_msg_text => 'Update Rows Exception');
1265:

Line 1266: FEM_ENGINES_PKG.User_Message (

1262: p_severity => g_log_level_5
1263: ,p_module => G_BLOCK||'.'||l_api_name
1264: ,p_msg_text => 'Update Rows Exception');
1265:
1266: FEM_ENGINES_PKG.User_Message (
1267: p_app_name => G_PFT
1268: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
1269:
1270: RAISE e_pagg_engine_error;

Line 1273: FEM_ENGINES_PKG.User_Message (

1269:
1270: RAISE e_pagg_engine_error;
1271:
1272: WHEN OTHERS THEN
1273: FEM_ENGINES_PKG.User_Message (
1274: p_app_name => G_PFT
1275: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
1276:
1277: RAISE e_pagg_engine_error;

Line 1307: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1303: e_upd_obj_exec_step_stat_error EXCEPTION;
1304:
1305: BEGIN
1306:
1307: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1308: ,p_module => G_BLOCK||'.'||l_api_name
1309: ,p_msg_text => 'BEGIN');
1310:
1311: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure

Line 1333: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1329: RAISE e_upd_obj_exec_step_stat_error;
1330:
1331: END IF;
1332:
1333: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1334: ,p_module => G_BLOCK||'.'||l_api_name
1335: ,p_msg_text => 'END');
1336:
1337: EXCEPTION

Line 1339: fem_engines_pkg.tech_message (

1335: ,p_msg_text => 'END');
1336:
1337: EXCEPTION
1338: WHEN e_upd_obj_exec_step_stat_error THEN
1339: fem_engines_pkg.tech_message (
1340: p_severity => g_log_level_5
1341: ,p_module => G_BLOCK||'.'||l_api_name
1342: ,p_msg_text => 'Update Obj Exec Step API Exception');
1343:

Line 1344: FEM_ENGINES_PKG.User_Message (

1340: p_severity => g_log_level_5
1341: ,p_module => G_BLOCK||'.'||l_api_name
1342: ,p_msg_text => 'Update Obj Exec Step API Exception');
1343:
1344: FEM_ENGINES_PKG.User_Message (
1345: p_app_name => G_PFT
1346: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
1347: ,p_token1 => 'OBJECT_ID'
1348: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1353: FEM_ENGINES_PKG.User_Message (

1349:
1350: RAISE e_pagg_engine_error;
1351:
1352: WHEN OTHERS THEN
1353: FEM_ENGINES_PKG.User_Message (
1354: p_app_name => G_PFT
1355: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
1356: ,p_token1 => 'OBJECT_ID'
1357: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1382: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1378: l_api_name VARCHAR2(30);
1379: BEGIN
1380: l_api_name := 'Process_Obj_Exec_Step';
1381:
1382: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1383: ,p_module => G_BLOCK||'.'||l_api_name
1384: ,p_msg_text => 'BEGIN');
1385:
1386: IF (p_exe_status_code = g_exec_status_success) THEN

Line 1389: fem_engines_pkg.tech_message(

1385:
1386: IF (p_exe_status_code = g_exec_status_success) THEN
1387: -- query table fem_mp_process_ctl_t to get the number of rows processed
1388:
1389: fem_engines_pkg.tech_message(
1390: p_severity => g_log_level_3
1391: ,p_module => G_BLOCK||'.'||l_api_name
1392: ,p_msg_text => 'Rows processed for registered output table :'
1393: ||p_tbl_name);

Line 1405: fem_engines_pkg.tech_message(

1401: -----------------------------------------------------------------------
1402: -- Call FEM_PL_PKG.update_num_of_input_rows();
1403: -----------------------------------------------------------------------
1404:
1405: fem_engines_pkg.tech_message(
1406: p_severity => g_log_level_3,
1407: p_module => G_BLOCK||'.'||l_api_name,
1408: p_msg_text => 'Updating Rows processed from input table');
1409:

Line 1416: fem_engines_pkg.tech_message(

1412: ,p_num_input_rows => p_num_rows);
1413:
1414: END IF;
1415:
1416: fem_engines_pkg.tech_message(
1417: p_severity => g_log_level_3
1418: ,p_module => G_BLOCK||'.'||l_api_name
1419: ,p_msg_text => 'Update the status of the step with execution status :'
1420: ||p_exe_status_code);

Line 1427: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1423: Update_Obj_Exec_Step_Status( p_param_rec => p_param_rec
1424: ,p_exe_step => 'ALL'
1425: ,p_exe_status_code => p_exe_status_code );
1426:
1427: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1428: ,p_module => G_BLOCK||'.'||l_api_name
1429: ,p_msg_text => 'END');
1430:
1431: EXCEPTION

Line 1460: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1456: e_pl_preprocess_rule_set_err EXCEPTION;
1457:
1458: BEGIN
1459:
1460: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1461: ,p_module => G_BLOCK||'.'||l_api_name
1462: ,p_msg_text => 'BEGIN');
1463:
1464: fem_engines_pkg.tech_message(

Line 1464: fem_engines_pkg.tech_message(

1460: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1461: ,p_module => G_BLOCK||'.'||l_api_name
1462: ,p_msg_text => 'BEGIN');
1463:
1464: fem_engines_pkg.tech_message(
1465: p_severity => G_LOG_LEVEL_1
1466: ,p_module => G_BLOCK||'.'||l_api_name
1467: ,p_msg_text => 'Step 4.2.1: Rule Set Pre Processing');
1468:

Line 1494: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1490: RAISE e_pl_preprocess_rule_set_err;
1491:
1492: END IF;
1493:
1494: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1495: ,p_module => G_BLOCK||'.'||l_api_name
1496: ,p_msg_text => 'END');
1497:
1498: EXCEPTION

Line 1500: fem_engines_pkg.tech_message (

1496: ,p_msg_text => 'END');
1497:
1498: EXCEPTION
1499: WHEN e_pl_preprocess_rule_set_err THEN
1500: fem_engines_pkg.tech_message (
1501: p_severity => g_log_level_5
1502: ,p_module => G_BLOCK||'.'||l_api_name
1503: ,p_msg_text => 'Preprocess Rule Set Exception' );
1504:

Line 1505: FEM_ENGINES_PKG.User_Message (

1501: p_severity => g_log_level_5
1502: ,p_module => G_BLOCK||'.'||l_api_name
1503: ,p_msg_text => 'Preprocess Rule Set Exception' );
1504:
1505: FEM_ENGINES_PKG.User_Message (
1506: p_app_name => G_PFT
1507: ,p_msg_name => G_ENG_PRE_PROC_RS_ERR
1508: ,p_token1 => 'RULE_SET_OBJ_ID'
1509: ,p_value1 => p_param_rec.obj_id);

Line 1513: FEM_ENGINES_PKG.User_Message (

1509: ,p_value1 => p_param_rec.obj_id);
1510: RAISE e_pagg_engine_error;
1511:
1512: WHEN OTHERS THEN
1513: FEM_ENGINES_PKG.User_Message (
1514: p_app_name => G_PFT
1515: ,p_msg_name => G_ENG_PRE_PROC_RS_ERR
1516: ,p_token1 => 'RULE_SET_OBJ_ID'
1517: ,p_value1 => p_param_rec.obj_id);

Line 1583: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1579: l_process_table := 'FEM_CUSTOMER_PROFIT';
1580: -- Initialize the return status to SUCCESS
1581: p_param_rec.return_status := fnd_api.G_RET_STS_SUCCESS;
1582:
1583: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1584: ,p_module => G_BLOCK||'.'||l_api_name
1585: ,p_msg_text => 'BEGIN');
1586:
1587: fem_engines_pkg.tech_message (

Line 1587: fem_engines_pkg.tech_message (

1583: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1584: ,p_module => G_BLOCK||'.'||l_api_name
1585: ,p_msg_text => 'BEGIN');
1586:
1587: fem_engines_pkg.tech_message (
1588: p_severity => g_log_level_2
1589: ,p_module => G_BLOCK||'.'||l_api_name
1590: ,p_msg_text => 'Validate the Rule Definition');
1591:

Line 1603: fem_engines_pkg.user_message (p_app_name => G_FEM

1599: p_param_rec.ledger_id);
1600:
1601: -- Unexpected error
1602: IF (l_err_code <> 0) THEN
1603: fem_engines_pkg.user_message (p_app_name => G_FEM
1604: ,p_msg_name => l_err_msg);
1605: RAISE e_process_single_rule_error;
1606: END IF;
1607:

Line 1608: fem_engines_pkg.tech_message (

1604: ,p_msg_name => l_err_msg);
1605: RAISE e_process_single_rule_error;
1606: END IF;
1607:
1608: fem_engines_pkg.tech_message (
1609: p_severity => g_log_level_3
1610: ,p_module => G_BLOCK||'.'||l_api_name
1611: ,p_msg_text => 'Getting Profit Aggregation Rule Details'||p_param_rec.crnt_proc_child_obj_defn_id);
1612:

Line 1632: fem_engines_pkg.user_message (

1628: WHERE pprof_agg_obj_def_id = p_param_rec.crnt_proc_child_obj_defn_id;
1629:
1630: EXCEPTION
1631: WHEN no_data_found THEN
1632: fem_engines_pkg.user_message (
1633: p_app_name => G_PFT
1634: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
1635: ,p_token1 => 'OBJECT_ID'
1636: ,p_value1 => p_param_rec.crnt_proc_child_obj_id

Line 1674: fem_engines_pkg.tech_message (

1670:
1671: EXCEPTION
1672: WHEN e_register_rule_error THEN
1673:
1674: fem_engines_pkg.tech_message (
1675: p_severity => G_LOG_LEVEL_6
1676: ,p_module => G_BLOCK||'.'||l_api_name
1677: ,p_msg_text => 'Register Rule Exception');
1678:

Line 1679: fem_engines_pkg.user_message (

1675: p_severity => G_LOG_LEVEL_6
1676: ,p_module => G_BLOCK||'.'||l_api_name
1677: ,p_msg_text => 'Register Rule Exception');
1678:
1679: fem_engines_pkg.user_message (
1680: p_app_name => G_PFT
1681: ,p_msg_name => G_PL_OBJ_EXEC_LOCK_ERR);
1682:
1683: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;

Line 1700: fem_engines_pkg.tech_message( p_severity => g_log_level_3

1696: --------------------------------------------------------------------------
1697: --call to FEM_PL_PKG.register_dependent_objdefs
1698: --------------------------------------------------------------------------
1699:
1700: fem_engines_pkg.tech_message( p_severity => g_log_level_3
1701: ,p_module => G_BLOCK||'.'||l_api_name
1702: ,p_msg_text => 'Register_Dependent_Objects');
1703:
1704: Register_Dependent_Objects(p_param_rec => p_param_rec);

Line 1710: fem_engines_pkg.tech_message( p_severity => g_log_level_3

1706: --------------------------------------------------------------------------
1707: -- Call FEM_PL_PKG.Register_Table()
1708: --------------------------------------------------------------------------
1709:
1710: fem_engines_pkg.tech_message( p_severity => g_log_level_3
1711: ,p_module => G_BLOCK||'.'||l_api_name
1712: ,p_msg_text => 'Register table ');
1713:
1714: IF (p_param_rec.aggregate_customer = 'Y' ) THEN

Line 1715: fem_engines_pkg.tech_message(

1711: ,p_module => G_BLOCK||'.'||l_api_name
1712: ,p_msg_text => 'Register table ');
1713:
1714: IF (p_param_rec.aggregate_customer = 'Y' ) THEN
1715: fem_engines_pkg.tech_message(
1716: p_severity => g_log_level_3
1717: ,p_module => G_BLOCK||'.'||l_api_name
1718: ,p_msg_text => 'Aggregate to customer: INSERT');
1719:

Line 1726: fem_engines_pkg.tech_message(

1722: ,p_num_output_rows => 0
1723: ,p_stmt_type => g_insert);
1724:
1725: ELSIF (p_param_rec.aggregate_customer = 'N' ) THEN
1726: fem_engines_pkg.tech_message(
1727: p_severity => g_log_level_3
1728: ,p_module => G_BLOCK||'.'||l_api_name
1729: ,p_msg_text => 'Hierarchy Rollup: UPDATE');
1730:

Line 1751: fem_engines_pkg.tech_message (

1747: ,p_exe_status_code => l_exec_state );
1748:
1749: IF (p_param_rec.aggregate_customer = 'N') THEN
1750:
1751: fem_engines_pkg.tech_message (
1752: p_severity => g_log_level_3
1753: ,p_module => G_BLOCK||'.'||l_api_name
1754: ,p_msg_text => 'Hierarchical Rollup');
1755:

Line 1756: fem_engines_pkg.tech_message (

1752: p_severity => g_log_level_3
1753: ,p_module => G_BLOCK||'.'||l_api_name
1754: ,p_msg_text => 'Hierarchical Rollup');
1755:
1756: fem_engines_pkg.tech_message (
1757: p_severity => g_log_level_3
1758: ,p_module => G_BLOCK||'.'||l_api_name
1759: ,p_msg_text => 'Getting the group seq of the given hierarchy');
1760:

Line 1773: fem_engines_pkg.tech_message (

1769: FROM fem_hier_dimension_grps
1770: WHERE hierarchy_obj_id = l_hierarchy_obj_id
1771: AND dimension_group_id = l_dimension_grp_id_from;
1772:
1773: fem_engines_pkg.tech_message (
1774: p_severity => g_log_level_3
1775: ,p_module => G_BLOCK||'.'||l_api_name
1776: ,p_msg_text => 'Rollup To Level' || l_rel_dim_group_seq_to);
1777:

Line 1778: fem_engines_pkg.tech_message (

1774: p_severity => g_log_level_3
1775: ,p_module => G_BLOCK||'.'||l_api_name
1776: ,p_msg_text => 'Rollup To Level' || l_rel_dim_group_seq_to);
1777:
1778: fem_engines_pkg.tech_message (
1779: p_severity => g_log_level_3
1780: ,p_module => G_BLOCK||'.'||l_api_name
1781: ,p_msg_text => 'Rollup From Level' || l_rel_dim_group_seq_from);
1782:

Line 1783: fem_engines_pkg.tech_message (

1779: p_severity => g_log_level_3
1780: ,p_module => G_BLOCK||'.'||l_api_name
1781: ,p_msg_text => 'Rollup From Level' || l_rel_dim_group_seq_from);
1782:
1783: fem_engines_pkg.tech_message (
1784: p_severity => g_log_level_3
1785: ,p_module => G_BLOCK||'.'||l_api_name
1786: ,p_msg_text => 'Getting Customer Hierarchy definition');
1787:

Line 1796: fem_engines_pkg.tech_message(

1792:
1793: BEGIN
1794: -- To get the customer id to which the roll up has to be done
1795: -- and the intermediate cutomers if levels are skipped
1796: fem_engines_pkg.tech_message(
1797: p_severity => g_log_level_2
1798: ,p_module => G_BLOCK||'.'||l_api_name
1799: ,p_msg_text => 'Get all the customers between the From Level and
1800: To Level');

Line 1826: fem_engines_pkg.tech_message(

1822: AND fcp.ledger_id = p_param_rec.ledger_id
1823: AND fcp.dataset_code = p_param_rec.output_dataset_code
1824: AND data_aggregation_type_code = 'CUSTOMER_AGGREGATION';
1825:
1826: fem_engines_pkg.tech_message(
1827: p_severity => g_log_level_2
1828: ,p_module => G_BLOCK||'.'||l_api_name
1829: ,p_msg_text => 'Update the Table Id of the customer records
1830: which has to be updated');

Line 1878: fem_engines_pkg.user_message (

1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: gv_prg_msg := SQLERRM;
1877: gv_callstack := DBMS_UTILITY.Format_Call_Stack;
1878: fem_engines_pkg.user_message (
1879: p_app_name => G_FEM
1880: ,p_msg_name => G_UNEXPECTED_ERROR
1881: ,p_token1 => 'ERR_MSG'
1882: ,p_value1 => gv_prg_msg);

Line 1888: fem_engines_pkg.tech_message(

1884: END;
1885:
1886: IF l_proceed_further THEN
1887:
1888: fem_engines_pkg.tech_message(
1889: p_severity => g_log_level_2
1890: ,p_module => G_BLOCK||'.'||l_api_name
1891: ,p_msg_text => 'Check whether Levels are skipped');
1892:

Line 1897: fem_engines_pkg.tech_message(

1893: l_skip_level := l_rel_dim_group_seq_from - l_rel_dim_group_seq_to;
1894:
1895: IF l_skip_level <= 1 THEN
1896:
1897: fem_engines_pkg.tech_message(
1898: p_severity => g_log_level_2
1899: ,p_module => G_BLOCK||'.'||l_api_name
1900: ,p_msg_text => 'Levels are not skipped');
1901:

Line 1906: fem_engines_pkg.tech_message(

1902: l_levels_skipped := FALSE;
1903:
1904: ELSE
1905:
1906: fem_engines_pkg.tech_message(
1907: p_severity => g_log_level_2
1908: ,p_module => G_BLOCK||'.'||l_api_name
1909: ,p_msg_text => 'Some Intermediate Levels in
1910: the hiearchy are skipped');

Line 1922: fem_engines_pkg.tech_message (

1918:
1919:
1920: IF l_proceed_further THEN
1921:
1922: fem_engines_pkg.tech_message (
1923: p_severity => g_log_level_3
1924: ,p_module => G_BLOCK||'.'||l_api_name
1925: ,p_msg_text => 'Getting column population template definition');
1926:

Line 1939: fem_engines_pkg.tech_message (

1935: WHERE col_pop_templt_obj_def_id = l_col_obj_def_id
1936: AND ROWNUM = 1;
1937:
1938: IF (l_src_tab_name <> l_process_table) THEN
1939: fem_engines_pkg.tech_message (
1940: p_severity => g_log_level_3
1941: ,p_module => G_BLOCK||'.'||l_api_name
1942: ,p_msg_text => 'The source table name defined in the column
1943: population template and the processing table defined

Line 1946: fem_engines_pkg.user_message (

1942: ,p_msg_text => 'The source table name defined in the column
1943: population template and the processing table defined
1944: in the rule should be same.');
1945:
1946: fem_engines_pkg.user_message (
1947: p_app_name => G_PFT
1948: ,p_msg_name => G_ENG_GENERIC_5_ERR);
1949:
1950: RAISE e_process_single_rule_error;

Line 1967: fem_engines_pkg.tech_message (

1963: l_aggregation_method := 0;
1964: END;
1965:
1966: IF (l_aggregation_method <> 1) THEN
1967: fem_engines_pkg.tech_message (
1968: p_severity => g_log_level_3
1969: ,p_module => G_BLOCK||'.'||l_api_name
1970: ,p_msg_text => 'Column population template should have at least
1971: one aggregation function defined for Profit

Line 1974: fem_engines_pkg.user_message (

1970: ,p_msg_text => 'Column population template should have at least
1971: one aggregation function defined for Profit
1972: Aggregation Rule');
1973:
1974: fem_engines_pkg.user_message (
1975: p_app_name => G_PFT
1976: ,p_msg_name => G_ENG_GEN_CPOP_AGG_AGG_ERR);
1977:
1978: RAISE e_process_single_rule_error;

Line 1996: fem_engines_pkg.tech_message(

1992: ,p_aggregate_customer => p_param_rec.aggregate_customer);
1993:
1994: l_table_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;
1995:
1996: fem_engines_pkg.tech_message(
1997: p_severity => g_log_level_3
1998: ,p_module => G_BLOCK||'.'||l_api_name
1999: ,p_msg_text => 'Registering step: ALL');
2000:

Line 2004: fem_engines_pkg.tech_message(

2000:
2001: -- For Hierarchical Rollup and Levels are Skipped
2002: -- Submitting the MP Request for each of the Skipped Levels
2003:
2004: fem_engines_pkg.tech_message(
2005: p_severity => g_log_level_1
2006: ,p_module => G_BLOCK||'.'||l_api_name
2007: ,p_msg_text => l_bulk_sql);
2008:

Line 2011: fem_engines_pkg.tech_message(

2007: ,p_msg_text => l_bulk_sql);
2008:
2009: IF l_levels_skipped AND p_param_rec.aggregate_customer = 'N' THEN
2010:
2011: fem_engines_pkg.tech_message(
2012: p_severity => g_log_level_3
2013: ,p_module => G_BLOCK||'.'||l_api_name
2014: ,p_msg_text => 'Levels are skipped, Creating MP Request in Loop for
2015: all levels');

Line 2019: fem_engines_pkg.tech_message(

2015: all levels');
2016:
2017: WHILE (l_rel_dim_group_seq_to < l_rel_dim_group_seq_from) LOOP
2018:
2019: fem_engines_pkg.tech_message(
2020: p_severity => g_log_level_3
2021: ,p_module => G_BLOCK||'.'||l_api_name
2022: ,p_msg_text => 'Rolling up to level: '||l_rel_dim_group_seq_to || ' from ' || l_rel_dim_group_seq_from );
2023:

Line 2053: fem_engines_pkg.tech_message(

2049:
2050: -- If No Levels are Skipped in Hierarchy Rollup
2051: ELSIF NOT l_levels_skipped AND p_param_rec.aggregate_customer = 'N' THEN
2052:
2053: fem_engines_pkg.tech_message(
2054: p_severity => g_log_level_3
2055: ,p_module => G_BLOCK||'.'||l_api_name
2056: ,p_msg_text => 'LEVELS are not skipped');
2057:

Line 2075: fem_engines_pkg.tech_message(

2071:
2072: -- When Aggregate To customer is selected.
2073: ELSE
2074:
2075: fem_engines_pkg.tech_message(
2076: p_severity => g_log_level_3
2077: ,p_module => G_BLOCK||'.'||l_api_name
2078: ,p_msg_text => 'Aggregate To Customer');
2079:

Line 2109: fem_engines_pkg.tech_message(

2105: ,p_tbl_name => g_fem_customer_profit
2106: ,p_num_rows => NVL(l_num_rows_loaded,0));
2107:
2108: IF (l_update_flag AND p_param_rec.aggregate_customer = 'N' ) THEN
2109: fem_engines_pkg.tech_message(
2110: p_severity => g_log_level_3
2111: ,p_module => G_BLOCK||'.'||l_api_name
2112: ,p_msg_text => 'Update the Created By Object Id and Request Id');
2113:

Line 2142: fem_engines_pkg.user_message (

2138: EXCEPTION
2139: WHEN OTHERS THEN
2140: gv_prg_msg := SQLERRM;
2141: gv_callstack := DBMS_UTILITY.Format_Call_Stack;
2142: fem_engines_pkg.user_message (
2143: p_app_name => G_FEM
2144: ,p_msg_name => G_UNEXPECTED_ERROR
2145: ,p_token1 => 'ERR_MSG'
2146: ,p_value1 => gv_prg_msg);

Line 2151: fem_engines_pkg.tech_message(

2147: RAISE e_process_single_rule_error;
2148: END;
2149:
2150: BEGIN
2151: fem_engines_pkg.tech_message(
2152: p_severity => g_log_level_3
2153: ,p_module => G_BLOCK||'.'||l_api_name
2154: ,p_msg_text => 'Deleting the Duplicate Rows');
2155:

Line 2164: fem_engines_pkg.user_message (

2160: WHEN OTHERS THEN
2161: gv_prg_msg := SQLERRM;
2162: gv_callstack := DBMS_UTILITY.Format_Call_Stack;
2163:
2164: fem_engines_pkg.user_message (
2165: p_app_name => G_FEM
2166: ,p_msg_name => G_UNEXPECTED_ERROR
2167: ,p_token1 => 'ERR_MSG'
2168: ,p_value1 => gv_prg_msg);

Line 2187: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

2183: END IF; -- l_proceed_further
2184:
2185: COMMIT;
2186:
2187: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2
2188: ,p_module => G_BLOCK||'.'||l_api_name
2189: ,p_msg_text => 'END');
2190:
2191: EXCEPTION

Line 2202: fem_engines_pkg.tech_message (

2198: ,p_exe_status_code => 'ERROR_UNDO'
2199: ,p_tbl_name => g_fem_customer_profit
2200: ,p_num_rows => NULL);
2201:
2202: fem_engines_pkg.tech_message (
2203: p_severity => g_log_level_5
2204: ,p_module => G_BLOCK||'.'||l_api_name
2205: ,p_msg_text => 'Process Single Rule Exception');
2206:

Line 2207: --fem_engines_pkg.user_message (p_app_name => G_PFT

2203: p_severity => g_log_level_5
2204: ,p_module => G_BLOCK||'.'||l_api_name
2205: ,p_msg_text => 'Process Single Rule Exception');
2206:
2207: --fem_engines_pkg.user_message (p_app_name => G_PFT
2208: -- ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2209:
2210: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;
2211:

Line 2221: fem_engines_pkg.tech_message (

2217: ,p_exe_status_code => g_exec_status_error_rerun
2218: ,p_tbl_name => g_fem_customer_profit
2219: ,p_num_rows => NULL);
2220:
2221: fem_engines_pkg.tech_message (
2222: p_severity => g_log_level_5
2223: ,p_module => G_BLOCK||'.'||l_api_name
2224: ,p_msg_text => 'Process Single Rule Exception');
2225:

Line 2226: fem_engines_pkg.user_message (p_app_name => G_PFT

2222: p_severity => g_log_level_5
2223: ,p_module => G_BLOCK||'.'||l_api_name
2224: ,p_msg_text => 'Process Single Rule Exception');
2225:
2226: fem_engines_pkg.user_message (p_app_name => G_PFT
2227: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2228:
2229: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;
2230:

Line 2240: fem_engines_pkg.user_message (p_app_name => G_PFT

2236: ,p_exe_status_code => g_exec_status_error_rerun
2237: ,p_tbl_name => g_fem_customer_profit
2238: ,p_num_rows => NULL);
2239:
2240: fem_engines_pkg.user_message (p_app_name => G_PFT
2241: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2242:
2243: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;
2244:

Line 2293: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2289: l_user_id := FND_GLOBAL.user_id;
2290: l_effective_date := FND_DATE.CANONICAL_TO_DATE(p_effective_date);
2291: l_condition_sel_param := 'BOTH';
2292:
2293: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2294: ,p_module => G_BLOCK||'.'||l_api_name
2295: ,p_msg_text => 'BEGIN');
2296:
2297: IF p_condition_obj_id IS NULL THEN

Line 2342: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2338:
2339: l_table_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;
2340:
2341: IF (p_aggregate_customer = 'Y') THEN
2342: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2343: ,p_module => G_BLOCK||'.'||l_api_name
2344: ,p_msg_text => 'Aggregate To Customer');
2345: -- To add the where clause to aggregate all the customer data in
2346: -- FEM_CUSTOMER_PROFIT Table

Line 2366: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2362: p_hier_obj_defn_id => l_hier_object_def_id);
2363: EXCEPTION
2364: WHEN OTHERS THEN
2365:
2366: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2367: ,p_module => G_BLOCK||'.'||l_api_name
2368: ,p_msg_text => 'Hierarchy Flattening Process');
2369:
2370: RAISE;

Line 2372: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2368: ,p_msg_text => 'Hierarchy Flattening Process');
2369:
2370: RAISE;
2371: END;
2372: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2373: ,p_module => G_BLOCK||'.'||l_api_name
2374: ,p_msg_text => 'Hierarchical Rollup');
2375: -- To add the hierarchy details for the customer rollup for aggregation
2376: add_hierarchy_details(p_select_col => l_select_stmt

Line 2400: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

2396:
2397: RETURN l_insert_head_stmt || ' ' || l_select_stmt || ' ' || l_from_stmt
2398: || ' ' || l_where_stmt || ' ' || l_order_by_clause;
2399:
2400: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2
2401: ,p_module => G_BLOCK||'.'||l_api_name
2402: ,p_msg_text => 'END');
2403: EXCEPTION
2404: WHEN e_col_population_api_err THEN

Line 2405: fem_engines_pkg.tech_message (

2401: ,p_module => G_BLOCK||'.'||l_api_name
2402: ,p_msg_text => 'END');
2403: EXCEPTION
2404: WHEN e_col_population_api_err THEN
2405: fem_engines_pkg.tech_message (
2406: p_severity => g_log_level_5
2407: ,p_module => G_BLOCK||'.'||l_api_name
2408: ,p_msg_text => 'Column Population API Exception' );
2409:

Line 2410: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

2406: p_severity => g_log_level_5
2407: ,p_module => G_BLOCK||'.'||l_api_name
2408: ,p_msg_text => 'Column Population API Exception' );
2409:
2410: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
2411: ,p_msg_name => G_ENG_COL_POP_API_ERR);
2412:
2413: RAISE e_pagg_engine_error;
2414:

Line 2440: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2436:
2437: l_count NUMBER;
2438:
2439: BEGIN
2440: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2441: ,p_module => G_BLOCK||'.'||l_api_name
2442: ,p_msg_text => 'BEGIN');
2443: SELECT COUNT(*)
2444: INTO l_count

Line 2458: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

2454: END IF;
2455:
2456: RETURN 0;
2457:
2458: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2
2459: ,p_module => G_BLOCK||'.'||l_api_name
2460: ,p_msg_text => 'END');
2461: EXCEPTION
2462: WHEN no_data_found THEN

Line 2496: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2492: e_eng_master_post_proc_error EXCEPTION;
2493:
2494: BEGIN
2495:
2496: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2497: ,p_module => G_BLOCK||'.'||l_api_name
2498: ,p_msg_text => 'BEGIN');
2499:
2500: --------------------------------------------------------------------------

Line 2503: fem_engines_pkg.tech_message (

2499:
2500: --------------------------------------------------------------------------
2501: -- STEP 1: Update Object Execution Status.
2502: --------------------------------------------------------------------------
2503: fem_engines_pkg.tech_message (
2504: p_severity => g_log_level_1
2505: ,p_module => G_BLOCK||'.'||l_api_name
2506: ,p_msg_text => 'Step 1: Update Object Execution Status');
2507:

Line 2532: fem_engines_pkg.tech_message (

2528: -- STEP 2: Update Object Execution Errors.
2529: --------------------------------------------------------------------------
2530: IF (p_exec_status_code <> g_exec_status_success) THEN
2531:
2532: fem_engines_pkg.tech_message (
2533: p_severity => g_log_level_1
2534: ,p_module => G_BLOCK||'.'||l_api_name
2535: ,p_msg_text => 'Step 2: Update Object Execution Errors');
2536:

Line 2561: fem_engines_pkg.tech_message (

2557:
2558: --------------------------------------------------------------------------
2559: -- STEP 3: Update Request Status.
2560: --------------------------------------------------------------------------
2561: fem_engines_pkg.tech_message (
2562: p_severity => g_log_level_1
2563: ,p_module => G_BLOCK||'.'||l_api_name
2564: ,p_msg_text => 'Step 3: Update Request Status');
2565:

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

2581: RAISE e_eng_master_post_proc_error;
2582: END IF;
2583:
2584: IF (p_exec_status_code = g_exec_status_success) THEN
2585: FEM_ENGINES_PKG.User_Message(p_app_name => G_PFT,
2586: p_msg_name => 'PFT_PPROF_ROW_SUMMARY',
2587: p_token1 => 'ROWSP',
2588: p_value1 => NVL(p_param_rec.rows_loaded,0),
2589: p_token2 => 'ROWSL',

Line 2593: FEM_ENGINES_PKG.User_Message (

2589: p_token2 => 'ROWSL',
2590: p_value2 => NVL(p_param_rec.rows_loaded,0));
2591:
2592: IF NVL(p_param_rec.rows_loaded,0) = 0 THEN
2593: FEM_ENGINES_PKG.User_Message (
2594: p_app_name => G_PFT
2595: ,p_msg_name => G_ENG_PAG_NO_OP_ROWS_ERR);
2596: END IF;
2597:

Line 2602: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2598: END IF;
2599:
2600: COMMIT;
2601:
2602: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2603: ,p_module => G_BLOCK||'.'||l_api_name
2604: ,p_msg_text => 'END');
2605:
2606: EXCEPTION

Line 2608: fem_engines_pkg.tech_message (

2604: ,p_msg_text => 'END');
2605:
2606: EXCEPTION
2607: WHEN e_eng_master_post_proc_error THEN
2608: fem_engines_pkg.tech_message (
2609: p_severity => g_log_level_5
2610: ,p_module => G_BLOCK||'.'||l_api_name
2611: ,p_msg_text => 'Engine Master Post Process Exception');
2612:

Line 2613: FEM_ENGINES_PKG.User_Message (

2609: p_severity => g_log_level_5
2610: ,p_module => G_BLOCK||'.'||l_api_name
2611: ,p_msg_text => 'Engine Master Post Process Exception');
2612:
2613: FEM_ENGINES_PKG.User_Message (
2614: p_app_name => G_PFT
2615: ,p_msg_name => G_ENG_ENGINE_POST_PROC_ERR
2616: ,p_token1 => 'OBJECT_ID'
2617: ,p_value1 => p_param_rec.obj_id);

Line 2645: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2641: l_api_name CONSTANT VARCHAR2(30) := 'Get_Object_Definition';
2642:
2643: BEGIN
2644:
2645: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2646: ,p_module => G_BLOCK||'.'||l_api_name
2647: ,p_msg_text => 'BEGIN');
2648:
2649: SELECT d.object_definition_id

Line 2660: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2656: AND p_effective_date BETWEEN d.effective_start_date
2657: AND d.effective_end_date
2658: AND d.old_approved_copy_flag = 'N';
2659:
2660: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2661: ,p_module => G_BLOCK||'.'||l_api_name
2662: ,p_msg_text => 'END');
2663:
2664: EXCEPTION

Line 2666: FEM_ENGINES_PKG.User_Message (

2662: ,p_msg_text => 'END');
2663:
2664: EXCEPTION
2665: WHEN no_data_found THEN
2666: FEM_ENGINES_PKG.User_Message (
2667: p_app_name => G_PFT
2668: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
2669: ,p_token1 => 'OBJECT_ID'
2670: ,p_value1 => p_object_id

Line 2701: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2697: l_message VARCHAR2(4000);
2698:
2699: BEGIN
2700:
2701: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2702: ,p_module => G_BLOCK||'.'||l_api_name
2703: ,p_msg_text => 'msg_count='||p_msg_count);
2704:
2705: l_msg_data := p_msg_data;

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

2708:
2709: FND_MESSAGE.Set_Encoded(l_msg_data);
2710: l_message := FND_MESSAGE.Get;
2711:
2712: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2713:
2714: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2715: ,p_module => G_BLOCK||'.'||l_api_name
2716: ,p_msg_text => 'msg_data='||l_message);

Line 2714: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2710: l_message := FND_MESSAGE.Get;
2711:
2712: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2713:
2714: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2715: ,p_module => G_BLOCK||'.'||l_api_name
2716: ,p_msg_text => 'msg_data='||l_message);
2717:
2718: ELSIF (p_msg_count > 1) THEN

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

2722: ,p_encoded => FND_API.G_FALSE
2723: ,p_data => l_message
2724: ,p_msg_index_out => l_msg_out);
2725:
2726: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2727:
2728: fem_engines_pkg.tech_message (
2729: p_severity => g_log_level_2
2730: ,p_module => G_BLOCK||'.'||l_api_name

Line 2728: fem_engines_pkg.tech_message (

2724: ,p_msg_index_out => l_msg_out);
2725:
2726: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2727:
2728: fem_engines_pkg.tech_message (
2729: p_severity => g_log_level_2
2730: ,p_module => G_BLOCK||'.'||l_api_name
2731: ,p_msg_text => 'msg_data = '||l_message);
2732:

Line 2759: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2755: IS
2756: l_api_name CONSTANT VARCHAR2(30) := 'add_hierarchy_details';
2757: l_where LONG;
2758: BEGIN
2759: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2760: ,p_module => G_BLOCK||'.'||l_api_name
2761: ,p_msg_text => 'BEGIN');
2762:
2763: SELECT REPLACE(p_select_col,'{{{CUSTOMER_ID}}}',

Line 2797: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2793: Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias ||
2794: '.data_aggregation_type_code = ' ||
2795: '''CUSTOMER_AGGREGATION''';
2796:
2797: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2798: ,p_module => G_BLOCK||'.'||l_api_name
2799: ,p_msg_text => 'END');
2800: EXCEPTION
2801: WHEN OTHERS THEN

Line 2836: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2832:
2833: e_register_dep_obj_def_error EXCEPTION;
2834:
2835: BEGIN
2836: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2837: ,p_module => G_BLOCK||'.'||l_api_name
2838: ,p_msg_text => 'BEGIN');
2839:
2840: -- Register all the Dependent Objects for AGG

Line 2861: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2857: ,p_msg_data => l_msg_data);
2858: RAISE e_register_dep_obj_def_error;
2859: END IF;
2860:
2861: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2862: ,p_module => G_BLOCK||'.'||l_api_name
2863: ,p_msg_text => 'END');
2864:
2865: EXCEPTION

Line 2867: fem_engines_pkg.tech_message (

2863: ,p_msg_text => 'END');
2864:
2865: EXCEPTION
2866: WHEN e_register_dep_obj_def_error THEN
2867: fem_engines_pkg.tech_message (
2868: p_severity => g_log_level_5
2869: ,p_module => G_BLOCK||'.'||l_api_name
2870: ,p_msg_text => 'Register Dependant Objects Exception');
2871:

Line 2872: FEM_ENGINES_PKG.User_Message (

2868: p_severity => g_log_level_5
2869: ,p_module => G_BLOCK||'.'||l_api_name
2870: ,p_msg_text => 'Register Dependant Objects Exception');
2871:
2872: FEM_ENGINES_PKG.User_Message (
2873: p_app_name => G_PFT
2874: ,p_msg_name => G_PL_DEP_OBJ_DEF_ERR
2875: ,p_token1 => 'OBJ_DEF_ID'
2876: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);

Line 2880: fem_engines_pkg.tech_message (

2876: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);
2877: RAISE e_pagg_engine_error;
2878:
2879: WHEN OTHERS THEN
2880: fem_engines_pkg.tech_message (
2881: p_severity => g_log_level_5
2882: ,p_module => G_BLOCK||'.'||l_api_name
2883: ,p_msg_text => 'Register Dependant Objects Exception');
2884:

Line 2885: FEM_ENGINES_PKG.User_Message (

2881: p_severity => g_log_level_5
2882: ,p_module => G_BLOCK||'.'||l_api_name
2883: ,p_msg_text => 'Register Dependant Objects Exception');
2884:
2885: FEM_ENGINES_PKG.User_Message (
2886: p_app_name => G_PFT
2887: ,p_msg_name => G_PL_DEP_OBJ_DEF_ERR
2888: ,p_token1 => 'OBJ_DEF_ID'
2889: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);

Line 2920: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2916: e_upd_num_input_rows_error EXCEPTION;
2917:
2918: BEGIN
2919:
2920: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2921: ,p_module => G_BLOCK||'.'||l_api_name
2922: ,p_msg_text => 'BEGIN');
2923:
2924: -- Set the number of output rows for the output table.

Line 2944: fem_engines_pkg.tech_message( p_severity => g_log_level_2

2940: ,p_msg_data => l_msg_data);
2941: RAISE e_upd_num_input_rows_error;
2942: END IF;
2943:
2944: fem_engines_pkg.tech_message( p_severity => g_log_level_2
2945: ,p_module => G_BLOCK||'.'||l_api_name
2946: ,p_msg_text => 'END');
2947:
2948: EXCEPTION

Line 2950: fem_engines_pkg.tech_message (

2946: ,p_msg_text => 'END');
2947:
2948: EXCEPTION
2949: WHEN e_upd_num_input_rows_error THEN
2950: fem_engines_pkg.tech_message (
2951: p_severity => g_log_level_5
2952: ,p_module => G_BLOCK||'.'||l_api_name
2953: ,p_msg_text => 'Update Input Rows Exception');
2954:

Line 2955: FEM_ENGINES_PKG.User_Message (

2951: p_severity => g_log_level_5
2952: ,p_module => G_BLOCK||'.'||l_api_name
2953: ,p_msg_text => 'Update Input Rows Exception');
2954:
2955: FEM_ENGINES_PKG.User_Message (
2956: p_app_name => G_PFT
2957: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2958:
2959: RAISE e_pagg_engine_error;

Line 2962: fem_engines_pkg.tech_message (

2958:
2959: RAISE e_pagg_engine_error;
2960:
2961: WHEN OTHERS THEN
2962: fem_engines_pkg.tech_message (
2963: p_severity => g_log_level_5
2964: ,p_module => G_BLOCK||'.'||l_api_name
2965: ,p_msg_text => 'Update Input Rows Exception');
2966:

Line 2967: FEM_ENGINES_PKG.User_Message (

2963: p_severity => g_log_level_5
2964: ,p_module => G_BLOCK||'.'||l_api_name
2965: ,p_msg_text => 'Update Input Rows Exception');
2966:
2967: FEM_ENGINES_PKG.User_Message (
2968: p_app_name => G_PFT
2969: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2970:
2971: RAISE e_pagg_engine_error;

Line 3001: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2997: l_dimension_grp_id_from NUMBER;
2998: l_dimension_grp_id_to NUMBER;
2999: BEGIN
3000:
3001: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
3002: ,p_module => G_BLOCK||'.'||l_api_name
3003: ,p_msg_text => 'BEGIN');
3004:
3005: SELECT REPLACE(p_select_col,'{{{CUSTOMER_ID}}}',

Line 3017: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

3013:
3014: p_order_by_clause := 'GROUP BY ' ||
3015: p_src_alias ||'.Customer_Id';
3016:
3017: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
3018: ,p_module => G_BLOCK||'.'||l_api_name
3019: ,p_msg_text => 'END');
3020:
3021: EXCEPTION