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

Line 282: fem_engines_pkg.tech_message( p_severity => g_log_level_2

278:
279: -- initialize status to success
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: fem_engines_pkg.tech_message( p_severity => g_log_level_2
283: ,p_module => G_BLOCK||l_api_name
284: ,p_msg_text => 'BEGIN');
285:
286: -- initialize msg stack?

Line 299: fem_engines_pkg.user_message (

295: IF (p_obj_id IS NULL OR p_dataset_grp_obj_def_id IS NULL OR
296: p_effective_date IS NULL OR p_output_cal_period_id IS NULL OR
297: p_ledger_id IS NULL) THEN
298:
299: fem_engines_pkg.user_message (
300: p_app_name => G_FEM
301: ,p_msg_name => G_ENG_BAD_CONC_REQ_PARAM_ERR);
302: RAISE e_arc_engine_error;
303: END IF;

Line 310: fem_engines_pkg.tech_message (

306: --------------------------------------------------------------------------
307: -- STEP 1: Engine Master Preparation
308: --------------------------------------------------------------------------
309:
310: fem_engines_pkg.tech_message (
311: p_severity => g_log_level_2
312: ,p_module => G_BLOCK||'.'||l_api_name
313: ,p_msg_text => 'Step 1: Engine Master Preperation');
314:

Line 328: fem_engines_pkg.tech_message ( p_severity => g_log_level_3

324:
325: -----------------------------------------------------------------------------
326: -- STEP 2: registering process request for either a single rule or a rule set
327: -----------------------------------------------------------------------------
328: fem_engines_pkg.tech_message ( p_severity => g_log_level_3
329: ,p_module => G_BLOCK||'.'||l_api_name
330: ,p_msg_text => 'Step 2: Register Request');
331:
332:

Line 340: fem_engines_pkg.tech_message (

336: IF (l_param_rec.obj_type_code = 'PPROF_ACCT_REL_CONS') THEN
337: ------------------------------------------------------------------------
338: -- STEP 3: Processing for a single rule submission
339: ------------------------------------------------------------------------
340: fem_engines_pkg.tech_message (
341: p_severity => g_log_level_3
342: ,p_module => G_BLOCK||'.'||l_api_name
343: ,p_msg_text => 'Step 3: Process for a single rule ');
344:

Line 350: fem_engines_pkg.tech_message (

346: l_param_rec.crnt_proc_child_obj_id := l_param_rec.obj_id;
347:
348: Process_Single_Rule( p_param_rec => l_param_rec);
349:
350: fem_engines_pkg.tech_message (
351: p_severity => g_log_level_3
352: ,p_module => G_BLOCK||'.'||l_api_name
353: ,p_msg_text => 'Status After Process for a single rule '
354: || l_param_rec.return_status);

Line 371: fem_engines_pkg.tech_message(

367: ------------------------------------------------------------------------
368: ------------------------------------------------------------------------
369: -- STEP 4.1: Flattening the rule set
370: ------------------------------------------------------------------------
371: fem_engines_pkg.tech_message(
372: p_severity => g_log_level_3
373: ,p_module => G_BLOCK||'.'||l_api_name
374: ,p_msg_text => 'Step 3.1 Flatten the rule set');
375:

Line 381: fem_engines_pkg.tech_message(

377: ,l_param_rec.crnt_proc_child_obj_id) <> 0) THEN
378: ---------------------------------------------------------------------
379: -- STEP 4.2: Preprocess rule set
380: ---------------------------------------------------------------------
381: fem_engines_pkg.tech_message(
382: p_severity => g_log_level_1
383: ,p_module => G_BLOCK||'.'||l_api_name
384: ,p_msg_text => 'Step 4.2 PreProcess rule set' );
385:

Line 396: fem_engines_pkg.tech_message(

392: -- STEP 4.3.3: Process each rule in the rule set loop
393: -- STEP 4.3.4: Execution status for rule processing
394: ------------------------------------------------------------------------
395:
396: fem_engines_pkg.tech_message(
397: p_severity => g_log_level_1
398: ,p_module => G_BLOCK||'.'||l_api_name
399: ,p_msg_text => 'Step 4.3.1: Loop through all Rule Set Rules');
400:

Line 405: fem_engines_pkg.tech_message(

401: OPEN l_rule_set_rules(l_param_rec.request_id,l_param_rec.obj_id);
402:
403: l_rule_set_rules_is_open := TRUE;
404:
405: fem_engines_pkg.tech_message(
406: p_severity => g_log_level_1
407: ,p_module => G_BLOCK||'.'||l_api_name
408: ,p_msg_text => 'Step 4.3.2:Rule set loop');
409:

Line 415: fem_engines_pkg.tech_message(

411: FETCH l_rule_set_rules INTO l_next_rule_obj_id,
412: l_next_rule_obj_def_id,
413: l_next_rule_exec_status;
414:
415: fem_engines_pkg.tech_message(
416: p_severity => g_log_level_1
417: ,p_module => G_BLOCK||'.'||l_api_name
418: ,p_msg_text => 'Step 4.3.3: Process next rule in rule set: '
419: ||l_next_rule_obj_id);

Line 421: fem_engines_pkg.tech_message(

417: ,p_module => G_BLOCK||'.'||l_api_name
418: ,p_msg_text => 'Step 4.3.3: Process next rule in rule set: '
419: ||l_next_rule_obj_id);
420:
421: fem_engines_pkg.tech_message(
422: p_severity => g_log_level_1
423: ,p_module => G_BLOCK||'.'||l_api_name
424: ,p_msg_text => 'Step 4.3.4: Process next rule in rule set status:'
425: || l_next_rule_exec_status);

Line 442: fem_engines_pkg.tech_message(

438: ------------------------------------------------------------------
439: -- STEP 4.2.3: Process Rule Set Rule
440: ------------------------------------------------------------------
441:
442: fem_engines_pkg.tech_message(
443: p_severity => g_log_level_1
444: ,p_module => G_BLOCK||'.'||l_api_name
445: ,p_msg_text => 'Step 4.3.5: Process Rule Set Rule #'
446: ||TO_CHAR(l_rollup_sequence));

Line 456: fem_engines_pkg.tech_message (

452: ,x_obj_def_id => l_param_rec.crnt_proc_child_obj_defn_id);*/
453:
454: Process_Single_Rule( p_param_rec => l_param_rec );
455:
456: fem_engines_pkg.tech_message (
457: p_severity => g_log_level_3
458: ,p_module => G_BLOCK||'.'||l_api_name
459: ,p_msg_text => 'Status After Process for a single rule '
460: || l_param_rec.return_status);

Line 490: fem_engines_pkg.tech_message (

486:
487: ---------------------------------------------------------------------------
488: -- STEP 5: Engine Master Post Processing.
489: ---------------------------------------------------------------------------
490: fem_engines_pkg.tech_message (
491: p_severity => g_log_level_3
492: ,p_module => G_BLOCK||'.'||l_api_name
493: ,p_msg_text => 'Step 5: Engine Master Post Processing');
494:

Line 514: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

510: END IF;
511:
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513:
514: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
515: ,p_module => G_BLOCK||'.'||l_api_name
516: ,p_msg_text => 'END');
517:
518: EXCEPTION

Line 528: fem_engines_pkg.tech_message (

524: IF (l_rule_set_rules%ISOPEN) THEN
525: CLOSE l_rule_set_rules;
526: END IF;
527:
528: fem_engines_pkg.tech_message (
529: p_severity => g_log_level_3
530: ,p_module => G_BLOCK||'.'||l_api_name
531: ,p_msg_text => 'Step 5: Engine Master Post Processing: ERROR');
532:

Line 539: fem_engines_pkg.tech_message (

535:
536: l_completion_status := Fnd_Concurrent.Set_Completion_Status( 'ERROR'
537: ,NULL);
538:
539: fem_engines_pkg.tech_message (
540: p_severity => g_log_level_5
541: ,p_module => G_BLOCK||'.'||l_api_name
542: ,p_msg_text => 'Account consolidation Engine Error');
543:

Line 544: --fem_engines_pkg.user_message (

540: p_severity => g_log_level_5
541: ,p_module => G_BLOCK||'.'||l_api_name
542: ,p_msg_text => 'Account consolidation Engine Error');
543:
544: --fem_engines_pkg.user_message (
545: -- p_app_name => G_PFT
546: -- ,p_msg_text => 'Account consolidation Engine Error');
547:
548: -- Set the return status to ERROR

Line 564: fem_engines_pkg.tech_message (

560: IF (l_rule_set_rules%ISOPEN) THEN
561: CLOSE l_rule_set_rules;
562: END IF;
563:
564: fem_engines_pkg.tech_message (
565: p_severity => g_log_level_3
566: ,p_module => G_BLOCK||'.'||l_api_name
567: ,p_msg_text => 'Step 5: Engine Master Post Processing: ERROR');
568:

Line 575: fem_engines_pkg.tech_message (

571:
572: l_completion_status := Fnd_Concurrent.Set_Completion_Status( 'ERROR'
573: ,NULL);
574:
575: fem_engines_pkg.tech_message (
576: p_severity => g_log_level_6
577: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
578: ,p_msg_text => gv_prg_msg);
579:

Line 580: fem_engines_pkg.tech_message (

576: p_severity => g_log_level_6
577: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
578: ,p_msg_text => gv_prg_msg);
579:
580: fem_engines_pkg.tech_message (
581: p_severity => g_log_level_6
582: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
583: ,p_msg_text => gv_callstack);
584:

Line 585: fem_engines_pkg.user_message (

581: p_severity => g_log_level_6
582: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
583: ,p_msg_text => gv_callstack);
584:
585: fem_engines_pkg.user_message (
586: p_app_name => G_FEM
587: ,p_msg_name => G_UNEXPECTED_ERROR
588: ,p_token1 => 'ERR_MSG'
589: ,p_value1 => gv_prg_msg);

Line 629: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

625: e_eng_master_prep_error EXCEPTION;
626:
627: BEGIN
628:
629: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
630: ,p_module => G_BLOCK||'.'||l_api_name
631: ,p_msg_text => 'BEGIN');
632:
633: --------------------------------------------------------------------------

Line 666: fem_engines_pkg.tech_message (

662:
663: ----------------------------------------------------------------------------
664: -- Get the object info from fem_object_catalog_b for the object_id passed in
665: ----------------------------------------------------------------------------
666: fem_engines_pkg.tech_message (
667: p_severity => g_log_level_3
668: ,p_module => G_BLOCK||'.'||l_api_name
669: ,p_msg_text => 'Getting the Object Type Code of the given Object');
670:

Line 681: fem_engines_pkg.user_message (

677: WHERE object_id = x_param_rec.obj_id;
678:
679: EXCEPTION
680: WHEN OTHERS THEN
681: fem_engines_pkg.user_message (
682: p_app_name => G_PFT
683: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
684: ,p_token1 => 'OBJECT_ID'
685: ,p_value1 => x_param_rec.obj_id);

Line 687: fem_engines_pkg.tech_message (

683: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
684: ,p_token1 => 'OBJECT_ID'
685: ,p_value1 => x_param_rec.obj_id);
686:
687: fem_engines_pkg.tech_message (
688: p_severity => g_log_level_3
689: ,p_module => G_BLOCK||'.'||l_api_name
690: ,p_msg_text => 'Invalid Object Id' || x_param_rec.obj_id);
691:

Line 701: fem_engines_pkg.tech_message (

697: -- local_vs_combo_id of the rollup rule matches the Rule Set's.
698: --------------------------------------------------------------------------
699: IF (x_param_rec.obj_type_code = 'RULE_SET') THEN
700:
701: fem_engines_pkg.tech_message (
702: p_severity => g_log_level_3
703: ,p_module => G_BLOCK||'.'||l_api_name
704: ,p_msg_text => 'Obj type code is a rule set');
705:

Line 715: fem_engines_pkg.user_message (

711: ,x_obj_def_id => x_param_rec.crnt_proc_child_obj_defn_id);
712:
713: EXCEPTION
714: WHEN OTHERS THEN
715: fem_engines_pkg.user_message (
716: p_app_name => G_PFT
717: ,p_msg_name => G_ENG_INV_OBJ_DEFN_RS_ERR
718: ,p_token1 => 'OBJECT_ID'
719: ,p_value1 => x_param_rec.obj_id

Line 723: fem_engines_pkg.tech_message (

719: ,p_value1 => x_param_rec.obj_id
720: ,p_token2 => 'EFFECTIVE_DATE'
721: ,p_value2 => x_param_rec.effective_date);
722:
723: fem_engines_pkg.tech_message (
724: p_severity => g_log_level_3
725: ,p_module => G_BLOCK||'.'||l_api_name
726: ,p_msg_text => 'No Definition found for the ruleset :'
727: || x_param_rec.obj_id || 'for the Date :'

Line 735: fem_engines_pkg.tech_message (

731: END;
732:
733: ELSIF (x_param_rec.obj_type_code = 'PPROF_ACCT_REL_CONS') THEN
734:
735: fem_engines_pkg.tech_message (
736: p_severity => g_log_level_3
737: ,p_module => G_BLOCK||'.'||l_api_name
738: ,p_msg_text => 'Objext type code is a single rule');
739:

Line 752: fem_engines_pkg.user_message (

748: ,x_obj_def_id => x_param_rec.crnt_proc_child_obj_defn_id);
749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: fem_engines_pkg.user_message (
753: p_app_name => G_PFT
754: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
755: ,p_token1 => 'OBJECT_ID'
756: ,p_value1 => x_param_rec.obj_id

Line 760: fem_engines_pkg.tech_message (

756: ,p_value1 => x_param_rec.obj_id
757: ,p_token2 => 'EFFECTIVE_DATE'
758: ,p_value2 => x_param_rec.effective_date);
759:
760: fem_engines_pkg.tech_message (
761: p_severity => g_log_level_3
762: ,p_module => G_BLOCK||'.'||l_api_name
763: ,p_msg_text => 'No Definition found for the Rule :'
764: || x_param_rec.obj_id || 'for the Date :'

Line 769: fem_engines_pkg.user_message(

765: || x_param_rec.effective_date);
766: RAISE e_eng_master_prep_error;
767: END;
768: ELSE
769: fem_engines_pkg.user_message(
770: p_app_name => G_PFT
771: ,p_msg_name => G_ENG_INVALIDRULETYPE_ERR
772: ,p_token1 => 'OBJECT_TYPE_CODE'
773: ,p_value1 => x_param_rec.obj_type_code);

Line 779: fem_engines_pkg.tech_message (

775: RAISE e_eng_master_prep_error;
776:
777: END IF;
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 => 'Get the Dataset Group Object Id:');
783: --------------------------------------------------------------------------

Line 793: fem_engines_pkg.user_message (

789: FROM fem_object_definition_b
790: WHERE object_definition_id = x_param_rec.dataset_io_obj_def_id;
791: EXCEPTION
792: WHEN OTHERS THEN
793: fem_engines_pkg.user_message (
794: p_app_name => G_PFT
795: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
796: ,p_token1 => 'OBJECT_ID'
797: ,p_value1 => x_param_rec.dataset_io_obj_def_id);

Line 799: fem_engines_pkg.tech_message (

795: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
796: ,p_token1 => 'OBJECT_ID'
797: ,p_value1 => x_param_rec.dataset_io_obj_def_id);
798:
799: fem_engines_pkg.tech_message (
800: p_severity => g_log_level_3
801: ,p_module => G_BLOCK||'.'||l_api_name
802: ,p_msg_text => 'No Object found for the given Dataset Group:'
803: || x_param_rec.dataset_io_obj_def_id);

Line 810: fem_engines_pkg.tech_message (

806:
807: --------------------------------------------------------------------------
808: -- Get the Output Dataset Code
809: --------------------------------------------------------------------------
810: fem_engines_pkg.tech_message (
811: p_severity => g_log_level_3
812: ,p_module => G_BLOCK||'.'||l_api_name
813: ,p_msg_text => 'Getting the output DS Code for the given DS Group');
814:

Line 822: fem_engines_pkg.user_message (

818: FROM fem_ds_input_output_defs
819: WHERE dataset_io_obj_def_id = x_param_rec.dataset_io_obj_def_id;
820: EXCEPTION
821: WHEN OTHERS THEN
822: fem_engines_pkg.user_message (
823: p_app_name => G_PFT
824: ,p_msg_name => G_ENG_NO_OUTPUT_DS_ERR
825: ,p_token1 => 'DATASET_GROUP_OBJ_DEF_ID'
826: ,p_value1 => x_param_rec.dataset_io_obj_def_id);

Line 828: fem_engines_pkg.tech_message (

824: ,p_msg_name => G_ENG_NO_OUTPUT_DS_ERR
825: ,p_token1 => 'DATASET_GROUP_OBJ_DEF_ID'
826: ,p_value1 => x_param_rec.dataset_io_obj_def_id);
827:
828: fem_engines_pkg.tech_message (
829: p_severity => g_log_level_3
830: ,p_module => G_BLOCK||'.'||l_api_name
831: ,p_msg_text => 'No Output Dataset for the DS Group Definition:'
832: || x_param_rec.dataset_grp_name);

Line 851: fem_engines_pkg.user_message (

847: WHERE source_system_display_code = G_PFT;
848:
849: EXCEPTION
850: WHEN OTHERS THEN
851: fem_engines_pkg.user_message (
852: p_app_name => G_PFT
853: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
854: ,p_token1 => 'OBJECT_ID'
855: ,p_value1 => x_param_rec.obj_id);

Line 865: fem_engines_pkg.tech_message (

861:
862: -- Log all Request Record Parameters if we have low level debugging
863: IF ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) ) THEN
864:
865: fem_engines_pkg.tech_message (
866: p_severity => G_LOG_LEVEL_1
867: ,p_module => G_BLOCK||'.'||l_api_name||'.x_param_rec'
868: ,p_msg_text =>
869: ' dataset_grp_obj_def_id='||x_param_rec.dataset_io_obj_def_id||

Line 892: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

888: ' user_id='||x_param_rec.user_id);
889:
890: END IF;
891:
892: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2
893: ,p_module => G_BLOCK||'.'||l_api_name
894: ,p_msg_text => 'END');
895:
896: EXCEPTION

Line 899: fem_engines_pkg.tech_message (

895:
896: EXCEPTION
897: WHEN e_eng_master_prep_error THEN
898:
899: fem_engines_pkg.tech_message (
900: p_severity => g_log_level_5
901: ,p_module => G_BLOCK||'.'||l_api_name
902: ,p_msg_text => 'Engine Master Preperation Exception');
903: RAISE e_arc_engine_error;

Line 933: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

929: e_pl_register_request_error EXCEPTION;
930:
931: BEGIN
932:
933: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
934: ,p_module => G_BLOCK||'.'||l_api_name
935: ,p_msg_text => 'BEGIN');
936:
937: SAVEPOINT register_request_pub;

Line 974: fem_engines_pkg.tech_message (

970: END IF;
971:
972: COMMIT;
973:
974: fem_engines_pkg.tech_message (
975: p_severity => g_log_level_1
976: ,p_module => G_BLOCK||'.'||l_api_name
977: ,p_msg_text => 'Request id is '||p_param_rec.request_id);
978:

Line 979: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

975: p_severity => g_log_level_1
976: ,p_module => G_BLOCK||'.'||l_api_name
977: ,p_msg_text => 'Request id is '||p_param_rec.request_id);
978:
979: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
980: ,p_module => G_BLOCK||'.'||l_api_name
981: ,p_msg_text => 'END');
982:
983: EXCEPTION

Line 988: fem_engines_pkg.tech_message (

984: WHEN e_pl_register_request_error THEN
985:
986: ROLLBACK TO register_request_pub;
987:
988: fem_engines_pkg.tech_message (
989: p_severity => g_log_level_5
990: ,p_module => G_BLOCK||'.'||l_api_name
991: ,p_msg_text => 'Register Request Exception');
992:

Line 993: fem_engines_pkg.user_message (

989: p_severity => g_log_level_5
990: ,p_module => G_BLOCK||'.'||l_api_name
991: ,p_msg_text => 'Register Request Exception');
992:
993: fem_engines_pkg.user_message (
994: p_app_name => G_PFT
995: ,p_msg_name => G_PL_REG_REQUEST_ERR
996: ,p_token1 => 'REQUEST_ID'
997: ,p_value1 => p_param_rec.request_id);

Line 1005: fem_engines_pkg.user_message (

1001: WHEN OTHERS THEN
1002:
1003: ROLLBACK TO register_request_pub;
1004:
1005: fem_engines_pkg.user_message (
1006: p_app_name => G_PFT
1007: ,p_msg_name => G_PL_REG_REQUEST_ERR
1008: ,p_token1 => 'REQUEST_ID'
1009: ,p_value1 => p_param_rec.request_id);

Line 1043: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1039: e_register_obj_def_error EXCEPTION;
1040:
1041: BEGIN
1042:
1043: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1044: ,p_module => G_BLOCK||'.'||l_api_name
1045: ,p_msg_text => 'BEGIN');
1046:
1047: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register

Line 1070: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1066: ,p_msg_data => l_msg_data);
1067: RAISE e_register_obj_def_error;
1068: END IF;
1069:
1070: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1071: ,p_module => G_BLOCK||'.'||l_api_name
1072: ,p_msg_text => 'END');
1073:
1074: EXCEPTION

Line 1076: fem_engines_pkg.tech_message (

1072: ,p_msg_text => 'END');
1073:
1074: EXCEPTION
1075: WHEN e_register_obj_def_error THEN
1076: fem_engines_pkg.tech_message (
1077: p_severity => g_log_level_5
1078: ,p_module => G_BLOCK||'.'||l_api_name
1079: ,p_msg_text => 'Register Object Definition Exception');
1080:

Line 1081: fem_engines_pkg.user_message (

1077: p_severity => g_log_level_5
1078: ,p_module => G_BLOCK||'.'||l_api_name
1079: ,p_msg_text => 'Register Object Definition Exception');
1080:
1081: fem_engines_pkg.user_message (
1082: p_app_name => G_PFT
1083: ,p_msg_name => G_PL_OBJ_EXECLOCK_EXISTS_ERR
1084: ,p_token1 => 'REQUEST_ID'
1085: ,p_value1 => p_param_rec.request_id);

Line 1115: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1111: e_register_obj_exe_step_error EXCEPTION;
1112:
1113: BEGIN
1114:
1115: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1116: ,p_module => G_BLOCK||'.'||l_api_name
1117: ,p_msg_text => 'BEGIN');
1118:
1119: -- Call the FEM_PL_PKG.Register_Obj_Exec_Step API procedure

Line 1141: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1137: ,p_msg_data => l_msg_data);
1138: RAISE e_register_obj_exe_step_error;
1139: END IF;
1140:
1141: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1142: ,p_module => G_BLOCK||'.'||l_api_name
1143: ,p_msg_text => 'END');
1144:
1145: EXCEPTION

Line 1147: fem_engines_pkg.tech_message (

1143: ,p_msg_text => 'END');
1144:
1145: EXCEPTION
1146: WHEN e_register_obj_exe_step_error THEN
1147: fem_engines_pkg.tech_message (
1148: p_severity => g_log_level_5
1149: ,p_module => G_BLOCK||'.'||l_api_name
1150: ,p_msg_text => 'Register Obj Exec Step Exception');
1151:

Line 1152: fem_engines_pkg.user_message (

1148: p_severity => g_log_level_5
1149: ,p_module => G_BLOCK||'.'||l_api_name
1150: ,p_msg_text => 'Register Obj Exec Step Exception');
1151:
1152: fem_engines_pkg.user_message (
1153: p_app_name => G_PFT
1154: ,p_msg_name => G_PL_REG_EXEC_STEP_ERR
1155: ,p_token1 => 'OBJECT_ID'
1156: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1161: fem_engines_pkg.user_message (

1157:
1158: RAISE e_arc_engine_error;
1159:
1160: WHEN OTHERS THEN
1161: fem_engines_pkg.user_message (
1162: p_app_name => G_PFT
1163: ,p_msg_name => G_PL_REG_EXEC_STEP_ERR
1164: ,p_token1 => 'OBJECT_ID'
1165: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1197: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1193: e_register_table_error EXCEPTION;
1194:
1195: BEGIN
1196:
1197: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1198: ,p_module => G_BLOCK||'.'||l_api_name
1199: ,p_msg_text => 'BEGIN');
1200:
1201: -- Call the FEM_PL_PKG.Register_Table API procedure to register

Line 1224: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1220: ,p_msg_data => l_msg_data);
1221: RAISE e_register_table_error;
1222: END IF;
1223:
1224: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1225: ,p_module => G_BLOCK||'.'||l_api_name
1226: ,p_msg_text => 'END');
1227:
1228: EXCEPTION

Line 1230: fem_engines_pkg.tech_message(

1226: ,p_msg_text => 'END');
1227:
1228: EXCEPTION
1229: WHEN e_register_table_error THEN
1230: fem_engines_pkg.tech_message(
1231: p_severity => g_log_level_5
1232: ,p_module => G_BLOCK||'.'||l_api_name
1233: ,p_msg_text => 'Register Table Exception');
1234:

Line 1235: fem_engines_pkg.user_message (

1231: p_severity => g_log_level_5
1232: ,p_module => G_BLOCK||'.'||l_api_name
1233: ,p_msg_text => 'Register Table Exception');
1234:
1235: fem_engines_pkg.user_message (
1236: p_app_name => G_PFT
1237: ,p_msg_name => G_PL_REG_TABLE_ERR
1238: ,p_token1 => 'TABLE_NAME'
1239: ,p_value1 => p_tbl_name);

Line 1244: fem_engines_pkg.user_message (

1240:
1241: RAISE e_arc_engine_error;
1242:
1243: WHEN OTHERS THEN
1244: fem_engines_pkg.user_message (
1245: p_app_name => G_PFT
1246: ,p_msg_name => G_PL_REG_TABLE_ERR
1247: ,p_token1 => 'TABLE_NAME'
1248: ,p_value1 => p_tbl_name);

Line 1281: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1277: e_upd_num_output_rows_error EXCEPTION;
1278:
1279: BEGIN
1280:
1281: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1282: ,p_module => G_BLOCK||'.'||l_api_name
1283: ,p_msg_text => 'BEGIN');
1284:
1285: -- Set the number of output rows for the output table.

Line 1308: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1304:
1305: RAISE e_upd_num_output_rows_error;
1306: END IF;
1307:
1308: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1309: ,p_module => G_BLOCK||'.'||l_api_name
1310: ,p_msg_text => 'END');
1311:
1312: EXCEPTION

Line 1314: fem_engines_pkg.tech_message (

1310: ,p_msg_text => 'END');
1311:
1312: EXCEPTION
1313: WHEN e_upd_num_output_rows_error THEN
1314: fem_engines_pkg.tech_message (
1315: p_severity => g_log_level_5
1316: ,p_module => G_BLOCK||'.'||l_api_name
1317: ,p_msg_text => 'Update Rows Exception');
1318:

Line 1319: fem_engines_pkg.user_message (

1315: p_severity => g_log_level_5
1316: ,p_module => G_BLOCK||'.'||l_api_name
1317: ,p_msg_text => 'Update Rows Exception');
1318:
1319: fem_engines_pkg.user_message (
1320: p_app_name => G_PFT
1321: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
1322:
1323: RAISE e_arc_engine_error;

Line 1326: fem_engines_pkg.user_message (

1322:
1323: RAISE e_arc_engine_error;
1324:
1325: WHEN OTHERS THEN
1326: fem_engines_pkg.user_message (
1327: p_app_name => G_PFT
1328: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
1329:
1330: RAISE e_arc_engine_error;

Line 1360: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1356: e_upd_obj_exec_step_stat_error EXCEPTION;
1357:
1358: BEGIN
1359:
1360: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1361: ,p_module => G_BLOCK||'.'||l_api_name
1362: ,p_msg_text => 'BEGIN');
1363:
1364: --Call the FEM_PL_PKG.Update_Obj_Exec_Step_status API procedure

Line 1387: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1383: RAISE e_upd_obj_exec_step_stat_error;
1384:
1385: END IF;
1386:
1387: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1388: ,p_module => G_BLOCK||'.'||l_api_name
1389: ,p_msg_text => 'END');
1390:
1391: EXCEPTION

Line 1393: fem_engines_pkg.tech_message (

1389: ,p_msg_text => 'END');
1390:
1391: EXCEPTION
1392: WHEN e_upd_obj_exec_step_stat_error THEN
1393: fem_engines_pkg.tech_message (
1394: p_severity => g_log_level_5
1395: ,p_module => G_BLOCK||'.'||l_api_name
1396: ,p_msg_text => 'Update Obj Exec Step API Exception');
1397:

Line 1398: fem_engines_pkg.user_message (

1394: p_severity => g_log_level_5
1395: ,p_module => G_BLOCK||'.'||l_api_name
1396: ,p_msg_text => 'Update Obj Exec Step API Exception');
1397:
1398: fem_engines_pkg.user_message (
1399: p_app_name => G_PFT
1400: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
1401: ,p_token1 => 'OBJECT_ID'
1402: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1407: fem_engines_pkg.user_message (

1403:
1404: RAISE e_arc_engine_error;
1405:
1406: WHEN OTHERS THEN
1407: fem_engines_pkg.user_message (
1408: p_app_name => G_PFT
1409: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
1410: ,p_token1 => 'OBJECT_ID'
1411: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1438: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1434: l_api_name CONSTANT VARCHAR2(30) := 'Get_Nbr_RowsTable_Request';
1435:
1436: BEGIN
1437:
1438: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1439: ,p_module => G_BLOCK||'.'||l_api_name
1440: ,p_msg_text => 'BEGIN');
1441:
1442: --Query the fem_mp_process_ctl_t table to get the number of rows

Line 1451: fem_engines_pkg.tech_message (

1447: WHERE t.req_id = p_request_id
1448: AND t.process_num > 0;
1449:
1450: IF (x_rows_processed = 0) THEN
1451: fem_engines_pkg.tech_message (
1452: p_severity => g_log_level_5
1453: ,p_module => G_BLOCK||'.'||l_api_name
1454: ,p_msg_text => 'No Rows returned by the Insert Statement');
1455:

Line 1457: fem_engines_pkg.user_message (

1453: ,p_module => G_BLOCK||'.'||l_api_name
1454: ,p_msg_text => 'No Rows returned by the Insert Statement');
1455:
1456: IF (p_sec_relns_flag = 'Y') THEN
1457: fem_engines_pkg.user_message (
1458: p_app_name => G_PFT
1459: ,p_msg_name => G_ENG_SEC_NO_OP_ROWS_ERR);
1460: ELSE
1461: fem_engines_pkg.user_message (

Line 1461: fem_engines_pkg.user_message (

1457: fem_engines_pkg.user_message (
1458: p_app_name => G_PFT
1459: ,p_msg_name => G_ENG_SEC_NO_OP_ROWS_ERR);
1460: ELSE
1461: fem_engines_pkg.user_message (
1462: p_app_name => G_PFT
1463: ,p_msg_name => G_ENG_NO_OP_ROWS_ERR);
1464: END IF;
1465: END IF;

Line 1467: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1463: ,p_msg_name => G_ENG_NO_OP_ROWS_ERR);
1464: END IF;
1465: END IF;
1466:
1467: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1468: ,p_module => G_BLOCK||'.'||l_api_name
1469: ,p_msg_text => 'END');
1470:
1471: EXCEPTION

Line 1499: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1495: BEGIN
1496: l_api_name := 'Process_Obj_Exec_Step';
1497: l_nbr_output_rows := NULL;
1498:
1499: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1500: ,p_module => G_BLOCK||'.'||l_api_name
1501: ,p_msg_text => 'BEGIN');
1502:
1503: IF (p_exe_status_code = g_exec_status_success) THEN

Line 1519: fem_engines_pkg.tech_message(

1515:
1516: --update the number of output rows processed succesfully
1517: --in the registered table
1518:
1519: fem_engines_pkg.tech_message(
1520: p_severity => g_log_level_3
1521: ,p_module => G_BLOCK||'.'||l_api_name
1522: ,p_msg_text => 'Total Number of Processed Rows :'
1523: ||l_nbr_output_rows);

Line 1535: fem_engines_pkg.tech_message(

1531: -----------------------------------------------------------------------
1532: -- Call FEM_PL_PKG.update_num_of_input_rows();
1533: -----------------------------------------------------------------------
1534:
1535: fem_engines_pkg.tech_message(
1536: p_severity => g_log_level_1,
1537: p_module => G_BLOCK||'.'||l_api_name,
1538: p_msg_text => 'No:of Rows processed from input table'
1539: ||l_nbr_loaded_rows );

Line 1547: fem_engines_pkg.tech_message(

1543: ,p_num_input_rows => p_param_rec.rows_processed);
1544:
1545: END IF;
1546:
1547: fem_engines_pkg.tech_message(
1548: p_severity => g_log_level_3
1549: ,p_module => G_BLOCK||'.'||l_api_name
1550: ,p_msg_text => 'Update the status of the step with execution status :'
1551: ||p_exe_status_code);

Line 1558: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1554: Update_Obj_Exec_Step_Status( p_param_rec => p_param_rec
1555: ,p_exe_step => 'ACCT_REL_CONS'
1556: ,p_exe_status_code => p_exe_status_code );
1557:
1558: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1559: ,p_module => G_BLOCK||'.'||l_api_name
1560: ,p_msg_text => 'END');
1561:
1562: EXCEPTION

Line 1592: fem_engines_pkg.tech_message( p_severity => g_log_level_2

1588: e_pl_preprocess_rule_set_err EXCEPTION;
1589:
1590: BEGIN
1591:
1592: fem_engines_pkg.tech_message( p_severity => g_log_level_2
1593: ,p_module => G_BLOCK||'.'||l_api_name
1594: ,p_msg_text => 'BEGIN');
1595:
1596: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(

Line 1621: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1617: RAISE e_pl_preprocess_rule_set_err ;
1618:
1619: END IF;
1620:
1621: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1622: ,p_module => G_BLOCK||'.'||l_api_name
1623: ,p_msg_text => 'END');
1624:
1625: EXCEPTION

Line 1627: fem_engines_pkg.tech_message (

1623: ,p_msg_text => 'END');
1624:
1625: EXCEPTION
1626: WHEN e_pl_preprocess_rule_set_err THEN
1627: fem_engines_pkg.tech_message (
1628: p_severity => g_log_level_5
1629: ,p_module => G_BLOCK||'.'||l_api_name
1630: ,p_msg_text => 'Preprocess Rule Set Exception' );
1631:

Line 1632: fem_engines_pkg.user_message (

1628: p_severity => g_log_level_5
1629: ,p_module => G_BLOCK||'.'||l_api_name
1630: ,p_msg_text => 'Preprocess Rule Set Exception' );
1631:
1632: fem_engines_pkg.user_message (
1633: p_app_name => G_PFT
1634: ,p_msg_name => G_ENG_PRE_PROC_RS_ERR
1635: ,p_token1 => 'RULE_SET_OBJ_ID'
1636: ,p_value1 => p_param_rec.obj_id);

Line 1641: fem_engines_pkg.user_message (

1637:
1638: RAISE e_arc_engine_error;
1639:
1640: WHEN OTHERS THEN
1641: fem_engines_pkg.user_message (
1642: p_app_name => G_PFT
1643: ,p_msg_name => G_ENG_PRE_PROC_RS_ERR
1644: ,p_token1 => 'RULE_SET_OBJ_ID'
1645: ,p_value1 => p_param_rec.obj_id);

Line 1699: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

1695: BEGIN
1696: -- Initialize the return status to SUCCESS
1697: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1698:
1699: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1700: ,p_module => G_BLOCK||'.'||l_api_name
1701: ,p_msg_text => 'BEGIN');
1702:
1703: fem_engines_pkg.tech_message (

Line 1703: fem_engines_pkg.tech_message (

1699: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1700: ,p_module => G_BLOCK||'.'||l_api_name
1701: ,p_msg_text => 'BEGIN');
1702:
1703: fem_engines_pkg.tech_message (
1704: p_severity => g_log_level_2
1705: ,p_module => G_BLOCK||'.'||l_api_name
1706: ,p_msg_text => 'Validate the Rule Definition');
1707:

Line 1719: fem_engines_pkg.user_message (p_app_name => G_FEM

1715: p_param_rec.ledger_id);
1716:
1717: -- Unexpected error
1718: IF (l_err_code <> 0) THEN
1719: fem_engines_pkg.user_message (p_app_name => G_FEM
1720: ,p_msg_name => l_err_msg);
1721:
1722: RAISE e_process_single_rule_error;
1723:

Line 1726: fem_engines_pkg.tech_message (

1722: RAISE e_process_single_rule_error;
1723:
1724: END IF;
1725:
1726: fem_engines_pkg.tech_message (
1727: p_severity => g_log_level_1
1728: ,p_module => G_BLOCK||'.'||l_api_name
1729: ,p_msg_text => 'PROCESSING OBJECT ID: '
1730: ||p_param_rec.crnt_proc_child_obj_id

Line 1734: fem_engines_pkg.tech_message (

1730: ||p_param_rec.crnt_proc_child_obj_id
1731: ||'AND PROCESSING OBJECT DEFINITION ID: '
1732: ||p_param_rec.crnt_proc_child_obj_defn_id);
1733:
1734: fem_engines_pkg.tech_message (
1735: p_severity => g_log_level_3
1736: ,p_module => G_BLOCK||'.'||l_api_name
1737: ,p_msg_text => 'Getting Account Consolidation Rule Details');
1738:

Line 1755: fem_engines_pkg.user_message (

1751: p_param_rec.crnt_proc_child_obj_defn_id;
1752:
1753: EXCEPTION
1754: WHEN no_data_found THEN
1755: fem_engines_pkg.user_message (
1756: p_app_name => G_PFT
1757: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
1758: ,p_token1 => 'OBJECT_ID'
1759: ,p_value1 => p_param_rec.crnt_proc_child_obj_id

Line 1767: fem_engines_pkg.tech_message (

1763: RAISE e_process_single_rule_error;
1764:
1765: END;
1766:
1767: fem_engines_pkg.tech_message (
1768: p_severity => g_log_level_3
1769: ,p_module => G_BLOCK||'.'||l_api_name
1770: ,p_msg_text => 'Getting column population template definition');
1771:

Line 1784: fem_engines_pkg.tech_message (

1780: WHERE col_pop_templt_obj_def_id = l_col_obj_def_id
1781: AND ROWNUM = 1;
1782:
1783: IF (l_src_tab_name <> l_process_table) THEN
1784: fem_engines_pkg.tech_message (
1785: p_severity => g_log_level_3
1786: ,p_module => G_BLOCK||'.'||l_api_name
1787: ,p_msg_text => 'The source table name defined in the column
1788: population template and the processing table

Line 1791: fem_engines_pkg.user_message (

1787: ,p_msg_text => 'The source table name defined in the column
1788: population template and the processing table
1789: defined in the rule should be same.');
1790:
1791: fem_engines_pkg.user_message (
1792: p_app_name => G_PFT
1793: ,p_msg_name => G_ENG_GENERIC_5_ERR);
1794:
1795: RAISE e_process_single_rule_error;

Line 1800: fem_engines_pkg.user_message (

1796: END IF;
1797:
1798: EXCEPTION
1799: WHEN no_data_found THEN
1800: fem_engines_pkg.user_message (
1801: p_app_name => G_PFT
1802: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
1803: ,p_token1 => 'OBJECT_DEFINITION_ID'
1804: ,p_value1 => l_col_obj_def_id

Line 1819: fem_engines_pkg.tech_message (

1815: WHERE col_pop_templt_obj_def_id = l_col_obj_def_id
1816: AND aggregation_method <> 'NOAGG';
1817:
1818: IF (l_aggregation_method <> 0) THEN
1819: fem_engines_pkg.tech_message (
1820: p_severity => g_log_level_3
1821: ,p_module => G_BLOCK||'.'||l_api_name
1822: ,p_msg_text => 'No aggregation function should be defined on
1823: column population template for Account

Line 1827: fem_engines_pkg.user_message (

1823: column population template for Account
1824: Consolidation Rule');
1825:
1826: -- Start of Bug 4686523
1827: fem_engines_pkg.user_message (
1828: p_app_name => G_PFT
1829: ,p_msg_name => G_ENG_COL_POP_GEN_ARC_AGG_ERR);
1830:
1831: -- End of Bug 4686523

Line 1837: fem_engines_pkg.user_message (

1833: RAISE e_process_single_rule_error;
1834: END IF;
1835: EXCEPTION
1836: WHEN no_data_found THEN
1837: fem_engines_pkg.user_message (
1838: p_app_name => G_PFT
1839: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
1840: ,p_token1 => 'OBJECT_DEFINITION_ID'
1841: ,p_value1 => l_col_obj_def_id

Line 1883: fem_engines_pkg.tech_message (

1879: WHEN e_register_rule_error THEN
1880:
1881: ROLLBACK TO register_rule_pub;
1882:
1883: fem_engines_pkg.tech_message (
1884: p_severity => G_LOG_LEVEL_6
1885: ,p_module => G_BLOCK||'.'||l_api_name
1886: ,p_msg_text => 'Register Rule Exception');
1887:

Line 1888: fem_engines_pkg.user_message (

1884: p_severity => G_LOG_LEVEL_6
1885: ,p_module => G_BLOCK||'.'||l_api_name
1886: ,p_msg_text => 'Register Rule Exception');
1887:
1888: fem_engines_pkg.user_message (
1889: p_app_name => G_PFT
1890: ,p_msg_name => G_PL_OBJ_EXEC_LOCK_ERR);
1891:
1892: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 1901: fem_engines_pkg.tech_message(p_severity => g_log_level_3

1897:
1898: --------------------------------------------------------------------------
1899: --Register the dependant object 'Dataset Group' object
1900: --------------------------------------------------------------------------
1901: fem_engines_pkg.tech_message(p_severity => g_log_level_3
1902: ,p_module => G_BLOCK||'.'||l_api_name
1903: ,p_msg_text => 'Register_Dataset_Grp_Object');
1904:
1905: Register_Object_Definition (

Line 1923: fem_engines_pkg.tech_message( p_severity => g_log_level_3

1919: --------------------------------------------------------------------------
1920: --call to FEM_PL_PKG.register_dependent_objdefs
1921: --------------------------------------------------------------------------
1922:
1923: fem_engines_pkg.tech_message( p_severity => g_log_level_3
1924: ,p_module => G_BLOCK||'.'||l_api_name
1925: ,p_msg_text => 'Register_Dependent_Objects');
1926:
1927: Register_Dependent_Objects(p_param_rec => p_param_rec);

Line 1932: fem_engines_pkg.tech_message( p_severity => g_log_level_3

1928:
1929: --------------------------------------------------------------------------
1930: -- Call FEM_PL_PKG.Register_Table()
1931: --------------------------------------------------------------------------
1932: fem_engines_pkg.tech_message( p_severity => g_log_level_3
1933: ,p_module => G_BLOCK||'.'||l_api_name
1934: ,p_msg_text => 'Register table ');
1935:
1936: Register_Table( p_param_rec => p_param_rec

Line 1954: fem_engines_pkg.tech_message(

1950: ,p_source_system_code => p_param_rec.source_system_code
1951: ,p_secondary_flag => p_param_rec.sec_relns_flag
1952: ,p_col_obj_def_id => l_col_obj_def_id);
1953:
1954: fem_engines_pkg.tech_message(
1955: p_severity => g_log_level_3
1956: ,p_module => G_BLOCK||'.'||l_api_name
1957: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
1958: ||p_param_rec.crnt_proc_child_obj_id);

Line 1962: fem_engines_pkg.tech_message(

1958: ||p_param_rec.crnt_proc_child_obj_id);
1959:
1960: l_table_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;
1961:
1962: fem_engines_pkg.tech_message(
1963: p_severity => g_log_level_3
1964: ,p_module => G_BLOCK||'.'||l_api_name
1965: ,p_msg_text => 'Registering step: ACCT_REL_CONS');
1966:

Line 1978: fem_engines_pkg.tech_message(

1974: Register_Obj_Exe_Step(p_param_rec => p_param_rec
1975: ,p_exe_step => 'ACCT_REL_CONS'
1976: ,p_exe_status_code => l_exec_state );
1977:
1978: fem_engines_pkg.tech_message(
1979: p_severity => g_log_level_3
1980: ,p_module => G_BLOCK||'.'||l_api_name
1981: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
1982: ||p_param_rec.crnt_proc_child_obj_id);

Line 1984: fem_engines_pkg.tech_message(

1980: ,p_module => G_BLOCK||'.'||l_api_name
1981: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
1982: ||p_param_rec.crnt_proc_child_obj_id);
1983:
1984: fem_engines_pkg.tech_message(
1985: p_severity => g_log_level_3
1986: ,p_module => G_BLOCK||'.'||l_api_name
1987: ,p_msg_text => 'Submitting to MP Master.p_eng_sql: '||l_bulk_sql);
1988:

Line 2012: fem_engines_pkg.tech_message(p_severity => g_log_level_1

2008: FROM fem_mp_process_ctl_t
2009: WHERE req_id = p_param_rec.request_id
2010: AND status = 2;
2011:
2012: fem_engines_pkg.tech_message(p_severity => g_log_level_1
2013: ,p_module => G_BLOCK||'.'||l_api_name
2014: ,p_msg_text => 'Total Errors : ' ||
2015: TO_CHAR(v_msg_list.COUNT));
2016:

Line 2020: fem_engines_pkg.tech_message( p_severity => g_log_level_5

2016:
2017: -- Log all of the messages
2018: FOR i IN 1..v_msg_list.COUNT LOOP
2019:
2020: fem_engines_pkg.tech_message( p_severity => g_log_level_5
2021: ,p_module => G_BLOCK||'.'||l_api_name
2022: ,p_msg_text => v_msg_list(i));
2023:
2024: fem_engines_pkg.user_message ( p_app_name => G_PFT

Line 2024: fem_engines_pkg.user_message ( p_app_name => G_PFT

2020: fem_engines_pkg.tech_message( p_severity => g_log_level_5
2021: ,p_module => G_BLOCK||'.'||l_api_name
2022: ,p_msg_text => v_msg_list(i));
2023:
2024: fem_engines_pkg.user_message ( p_app_name => G_PFT
2025: ,p_msg_text => v_msg_list(i));
2026:
2027: -- fnd_file.put_line(fnd_file.log, v_msg_list(i));
2028:

Line 2031: fem_engines_pkg.user_message (p_app_name => G_PFT

2027: -- fnd_file.put_line(fnd_file.log, v_msg_list(i));
2028:
2029: END LOOP;
2030:
2031: fem_engines_pkg.user_message (p_app_name => G_PFT
2032: ,p_msg_name => G_ENG_MULTI_PROC_ERR);
2033:
2034: Process_Obj_Exec_Step( p_param_rec => p_param_rec
2035: ,p_exe_step => 'ALL'

Line 2057: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

2053: -- Purge Data Slices
2054: FEM_MULTI_PROC_PKG.Delete_Data_Slices (
2055: p_req_id => p_param_rec.request_id);
2056:
2057: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2
2058: ,p_module => G_BLOCK||'.'||l_api_name
2059: ,p_msg_text => 'END');
2060:
2061: EXCEPTION

Line 2063: fem_engines_pkg.tech_message (

2059: ,p_msg_text => 'END');
2060:
2061: EXCEPTION
2062: WHEN e_process_single_rule_error THEN
2063: fem_engines_pkg.tech_message (
2064: p_severity => g_log_level_5
2065: ,p_module => G_BLOCK||'.'||l_api_name
2066: ,p_msg_text => 'Process Single Rule Exception');
2067:

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

2064: p_severity => g_log_level_5
2065: ,p_module => G_BLOCK||'.'||l_api_name
2066: ,p_msg_text => 'Process Single Rule Exception');
2067:
2068: --fem_engines_pkg.user_message (p_app_name => G_PFT
2069: -- ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2070:
2071: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
2072:

Line 2075: fem_engines_pkg.user_message (p_app_name => G_PFT

2071: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
2072:
2073: WHEN OTHERS THEN
2074:
2075: fem_engines_pkg.user_message (p_app_name => G_PFT
2076: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2077:
2078: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
2079:

Line 2133: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2129: l_user_id := FND_GLOBAL.User_Id;
2130: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
2131: l_condition_sel_param := 'BOTH';
2132:
2133: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2134: ,p_module => G_BLOCK||'.'||l_api_name
2135: ,p_msg_text => 'BEGIN');
2136:
2137: IF p_condition_obj_id IS NULL THEN

Line 2199: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

2195: -- add mapped columns
2196: RETURN l_insert_head_stmt || ' ' || l_select_stmt || ' ' || l_from_stmt
2197: || ' ' || l_where_stmt;
2198:
2199: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2
2200: ,p_module => G_BLOCK||'.'||l_api_name
2201: ,p_msg_text => 'END');
2202:
2203: EXCEPTION

Line 2205: fem_engines_pkg.tech_message (

2201: ,p_msg_text => 'END');
2202:
2203: EXCEPTION
2204: WHEN e_col_population_api_err THEN
2205: fem_engines_pkg.tech_message (
2206: p_severity => g_log_level_5
2207: ,p_module => G_BLOCK||'.'||l_api_name
2208: ,p_msg_text => 'Column Population API Exception');
2209:

Line 2210: fem_engines_pkg.user_message (p_app_name => G_PFT

2206: p_severity => g_log_level_5
2207: ,p_module => G_BLOCK||'.'||l_api_name
2208: ,p_msg_text => 'Column Population API Exception');
2209:
2210: fem_engines_pkg.user_message (p_app_name => G_PFT
2211: ,p_msg_name => G_ENG_COL_POP_API_ERR);
2212:
2213: RAISE e_arc_engine_error;
2214:

Line 2242: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2238:
2239: l_count NUMBER;
2240:
2241: BEGIN
2242: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2243: ,p_module => G_BLOCK||'.'||l_api_name
2244: ,p_msg_text => 'BEGIN');
2245: SELECT COUNT(*)
2246: INTO l_count

Line 2259: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2

2255: RETURN -1;
2256: END IF;
2257:
2258: RETURN 0;
2259: fem_engines_pkg.tech_message ( p_severity => G_LOG_LEVEL_2
2260: ,p_module => G_BLOCK||'.'||l_api_name
2261: ,p_msg_text => 'END');
2262: EXCEPTION
2263: WHEN no_data_found THEN

Line 2298: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2294:
2295:
2296: BEGIN
2297:
2298: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2299: ,p_module => G_BLOCK||'.'||l_api_name
2300: ,p_msg_text => 'BEGIN');
2301:
2302: --------------------------------------------------------------------------

Line 2305: fem_engines_pkg.tech_message (

2301:
2302: --------------------------------------------------------------------------
2303: -- STEP 1: Update Object Execution Status.
2304: --------------------------------------------------------------------------
2305: fem_engines_pkg.tech_message (
2306: p_severity => g_log_level_1
2307: ,p_module => G_BLOCK||'.'||l_api_name
2308: ,p_msg_text => 'Step 1: Update Object Execution Status');
2309:

Line 2333: fem_engines_pkg.tech_message (

2329: -- STEP 2: Update Object Execution Errors.
2330: --------------------------------------------------------------------------
2331: IF (p_exec_status_code <> g_exec_status_success) THEN
2332:
2333: fem_engines_pkg.tech_message (
2334: p_severity => g_log_level_1
2335: ,p_module => G_BLOCK||'.'||l_api_name
2336: ,p_msg_text => 'Step 2: Update Object Execution Errors');
2337:

Line 2362: fem_engines_pkg.tech_message (

2358:
2359: --------------------------------------------------------------------------
2360: -- STEP 3: Update Request Status.
2361: --------------------------------------------------------------------------
2362: fem_engines_pkg.tech_message (
2363: p_severity => g_log_level_1
2364: ,p_module => G_BLOCK||'.'||l_api_name
2365: ,p_msg_text => 'Step 3: Update Request Status');
2366:

Line 2385: fem_engines_pkg.user_message(p_app_name => G_PFT,

2381: RAISE e_eng_master_post_proc_error;
2382: END IF;
2383:
2384: IF (p_exec_status_code = g_exec_status_success) THEN
2385: fem_engines_pkg.user_message(p_app_name => G_PFT,
2386: p_msg_name => 'PFT_PPROF_ROW_SUMMARY',
2387: p_token1 => 'ROWSP',
2388: p_value1 => p_param_rec.rows_processed,
2389: p_token2 => 'ROWSL',

Line 2395: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2391: END IF;
2392:
2393: COMMIT;
2394:
2395: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2396: ,p_module => G_BLOCK||'.'||l_api_name
2397: ,p_msg_text => 'END');
2398:
2399: EXCEPTION

Line 2401: fem_engines_pkg.tech_message (

2397: ,p_msg_text => 'END');
2398:
2399: EXCEPTION
2400: WHEN e_eng_master_post_proc_error THEN
2401: fem_engines_pkg.tech_message (
2402: p_severity => g_log_level_5
2403: ,p_module => G_BLOCK||'.'||l_api_name
2404: ,p_msg_text => 'Engine Master Post Process Exception');
2405:

Line 2406: fem_engines_pkg.user_message (

2402: p_severity => g_log_level_5
2403: ,p_module => G_BLOCK||'.'||l_api_name
2404: ,p_msg_text => 'Engine Master Post Process Exception');
2405:
2406: fem_engines_pkg.user_message (
2407: p_app_name => G_PFT
2408: ,p_msg_name => G_ENG_ENGINE_POST_PROC_ERR
2409: ,p_token1 => 'OBJECT_ID'
2410: ,p_value1 => p_param_rec.obj_id);

Line 2438: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2434: l_api_name CONSTANT VARCHAR2(30) := 'Get_Object_Definition';
2435:
2436: BEGIN
2437:
2438: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2439: ,p_module => G_BLOCK||'.'||l_api_name
2440: ,p_msg_text => 'BEGIN');
2441:
2442: SELECT d.object_definition_id

Line 2453: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2449: AND p_effective_date BETWEEN d.effective_start_date
2450: AND d.effective_end_date
2451: AND d.old_approved_copy_flag = 'N';
2452:
2453: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2454: ,p_module => G_BLOCK||'.'||l_api_name
2455: ,p_msg_text => 'END');
2456:
2457: EXCEPTION

Line 2459: fem_engines_pkg.user_message (

2455: ,p_msg_text => 'END');
2456:
2457: EXCEPTION
2458: WHEN no_data_found THEN
2459: fem_engines_pkg.user_message (
2460: p_app_name => G_PFT
2461: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
2462: ,p_token1 => 'OBJECT_ID'
2463: ,p_value1 => p_object_id

Line 2494: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2490: l_message VARCHAR2(4000);
2491:
2492: BEGIN
2493:
2494: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2495: ,p_module => G_BLOCK||'.'||l_api_name
2496: ,p_msg_text => 'msg_count='||p_msg_count);
2497:
2498: l_msg_data := p_msg_data;

Line 2505: fem_engines_pkg.user_message ( p_msg_text => l_message );

2501:
2502: FND_MESSAGE.Set_Encoded(l_msg_data);
2503: l_message := FND_MESSAGE.Get;
2504:
2505: fem_engines_pkg.user_message ( p_msg_text => l_message );
2506:
2507: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2508: ,p_module => G_BLOCK||'.'||l_api_name
2509: ,p_msg_text => 'msg_data='||l_message);

Line 2507: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2503: l_message := FND_MESSAGE.Get;
2504:
2505: fem_engines_pkg.user_message ( p_msg_text => l_message );
2506:
2507: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2508: ,p_module => G_BLOCK||'.'||l_api_name
2509: ,p_msg_text => 'msg_data='||l_message);
2510:
2511: ELSIF (p_msg_count > 1) THEN

Line 2520: fem_engines_pkg.user_message ( p_msg_text => l_message );

2516: ,p_encoded => FND_API.G_FALSE
2517: ,p_data => l_message
2518: ,p_msg_index_out => l_msg_out);
2519:
2520: fem_engines_pkg.user_message ( p_msg_text => l_message );
2521:
2522: fem_engines_pkg.tech_message (
2523: p_severity => g_log_level_2
2524: ,p_module => G_BLOCK||'.'||l_api_name

Line 2522: fem_engines_pkg.tech_message (

2518: ,p_msg_index_out => l_msg_out);
2519:
2520: fem_engines_pkg.user_message ( p_msg_text => l_message );
2521:
2522: fem_engines_pkg.tech_message (
2523: p_severity => g_log_level_2
2524: ,p_module => G_BLOCK||'.'||l_api_name
2525: ,p_msg_text => 'msg_data='||l_message);
2526:

Line 2561: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2557: l_table_id NUMBER;
2558:
2559: BEGIN
2560:
2561: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2562: ,p_module => G_BLOCK||'.'||l_api_name
2563: ,p_msg_text => 'BEGIN');
2564:
2565: l_src_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;

Line 2597: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2593: || '''' || l_table_id || '''' || ')';
2594:
2595: p_where_clause := p_where_clause || ' AND ' || l_where;
2596:
2597: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2598: ,p_module => G_BLOCK||'.'||l_api_name
2599: ,p_msg_text => 'END');
2600:
2601: EXCEPTION

Line 2639: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2635: e_register_dep_obj_def_error EXCEPTION;
2636:
2637: BEGIN
2638:
2639: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2640: ,p_module => G_BLOCK||'.'||l_api_name
2641: ,p_msg_text => 'BEGIN');
2642:
2643: -- Register all the Dependent Objects for ARC

Line 2665: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2661: ,p_msg_data => l_msg_data);
2662: RAISE e_register_dep_obj_def_error;
2663: END IF;
2664:
2665: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2666: ,p_module => G_BLOCK||'.'||l_api_name
2667: ,p_msg_text => 'END');
2668:
2669: EXCEPTION

Line 2671: fem_engines_pkg.tech_message (

2667: ,p_msg_text => 'END');
2668:
2669: EXCEPTION
2670: WHEN e_register_dep_obj_def_error THEN
2671: fem_engines_pkg.tech_message (
2672: p_severity => g_log_level_5
2673: ,p_module => G_BLOCK||'.'||l_api_name
2674: ,p_msg_text => 'Register Dependant Objects Exception');
2675:

Line 2676: fem_engines_pkg.user_message (

2672: p_severity => g_log_level_5
2673: ,p_module => G_BLOCK||'.'||l_api_name
2674: ,p_msg_text => 'Register Dependant Objects Exception');
2675:
2676: fem_engines_pkg.user_message (
2677: p_app_name => G_PFT
2678: ,p_msg_name => G_PL_DEP_OBJ_DEF_ERR
2679: ,p_token1 => 'OBJ_DEF_ID'
2680: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);

Line 2684: fem_engines_pkg.tech_message (

2680: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);
2681: RAISE e_arc_engine_error;
2682:
2683: WHEN OTHERS THEN
2684: fem_engines_pkg.tech_message (
2685: p_severity => g_log_level_5
2686: ,p_module => G_BLOCK||'.'||l_api_name
2687: ,p_msg_text => 'Register Dependant Objects Exception');
2688:

Line 2689: fem_engines_pkg.user_message (

2685: p_severity => g_log_level_5
2686: ,p_module => G_BLOCK||'.'||l_api_name
2687: ,p_msg_text => 'Register Dependant Objects Exception');
2688:
2689: fem_engines_pkg.user_message (
2690: p_app_name => G_PFT
2691: ,p_msg_name => G_PL_DEP_OBJ_DEF_ERR
2692: ,p_token1 => 'OBJ_DEF_ID'
2693: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);

Line 2724: fem_engines_pkg.tech_message ( p_severity => g_log_level_2

2720: e_upd_num_input_rows_error EXCEPTION;
2721:
2722: BEGIN
2723:
2724: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2725: ,p_module => G_BLOCK||'.'||l_api_name
2726: ,p_msg_text => 'BEGIN');
2727:
2728: -- Set the number of output rows for the output table.

Line 2748: fem_engines_pkg.tech_message( p_severity => g_log_level_2

2744: ,p_msg_data => l_msg_data);
2745: RAISE e_upd_num_input_rows_error;
2746: END IF;
2747:
2748: fem_engines_pkg.tech_message( p_severity => g_log_level_2
2749: ,p_module => G_BLOCK||'.'||l_api_name
2750: ,p_msg_text => 'END');
2751:
2752: EXCEPTION

Line 2754: fem_engines_pkg.tech_message (

2750: ,p_msg_text => 'END');
2751:
2752: EXCEPTION
2753: WHEN e_upd_num_input_rows_error THEN
2754: fem_engines_pkg.tech_message (
2755: p_severity => g_log_level_5
2756: ,p_module => G_BLOCK||'.'||l_api_name
2757: ,p_msg_text => 'Update Input Rows Exception');
2758:

Line 2759: fem_engines_pkg.user_message (

2755: p_severity => g_log_level_5
2756: ,p_module => G_BLOCK||'.'||l_api_name
2757: ,p_msg_text => 'Update Input Rows Exception');
2758:
2759: fem_engines_pkg.user_message (
2760: p_app_name => G_PFT
2761: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2762:
2763: RAISE e_arc_engine_error;

Line 2766: fem_engines_pkg.tech_message (

2762:
2763: RAISE e_arc_engine_error;
2764:
2765: WHEN OTHERS THEN
2766: fem_engines_pkg.tech_message (
2767: p_severity => g_log_level_5
2768: ,p_module => G_BLOCK||'.'||l_api_name
2769: ,p_msg_text => 'Update Input Rows Exception');
2770:

Line 2771: fem_engines_pkg.user_message (

2767: p_severity => g_log_level_5
2768: ,p_module => G_BLOCK||'.'||l_api_name
2769: ,p_msg_text => 'Update Input Rows Exception');
2770:
2771: fem_engines_pkg.user_message (
2772: p_app_name => G_PFT
2773: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2774:
2775: RAISE e_arc_engine_error;