APPS.PFT_PPROFCAL_MASTER_PUB dependencies on FEM_ENGINES_PKG

Line 241: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

237: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;
238: -- initialize status to success
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
242: ,p_module => G_BLOCK||l_api_name
243: ,p_msg_text => 'BEGIN');
244:
245: fnd_log_repository.init;

Line 256: FEM_ENGINES_PKG.User_Message (

252: IF (p_obj_id IS NULL OR p_dataset_grp_obj_def_id IS NULL OR
253: p_effective_date IS NULL OR p_output_cal_period_id IS NULL OR
254: p_ledger_id IS NULL) THEN
255:
256: FEM_ENGINES_PKG.User_Message (
257: p_app_name => G_FEM
258: ,p_msg_name => G_ENG_BAD_CONC_REQ_PARAM_ERR);
259:
260: RAISE e_pc_engine_error;

Line 268: FEM_ENGINES_PKG.tech_message (

264: --------------------------------------------------------------------------
265: -- STEP 1: Engine Master Preparation
266: --------------------------------------------------------------------------
267:
268: FEM_ENGINES_PKG.tech_message (
269: p_severity => g_log_level_2
270: ,p_module => G_BLOCK||'.'||l_api_name
271: ,p_msg_text => 'Step 1: Engine Master Preperation');
272:

Line 286: FEM_ENGINES_PKG.tech_message (

282:
283: -----------------------------------------------------------------------------
284: -- STEP 2: registering process request for either a single rule or a rule set
285: -----------------------------------------------------------------------------
286: FEM_ENGINES_PKG.tech_message (
287: p_severity => g_log_level_3
288: ,p_module => G_BLOCK||'.'||l_api_name
289: ,p_msg_text => 'Step 2: Register Request');
290:

Line 298: FEM_ENGINES_PKG.tech_message (

294: IF (l_param_rec.obj_type_code = 'PPROF_PROFIT_CALC') THEN
295: -----------------------------------------------------------------------
296: -- STEP 3: Processing for a single rule submission
297: -----------------------------------------------------------------------
298: FEM_ENGINES_PKG.tech_message (
299: p_severity => g_log_level_3
300: ,p_module => G_BLOCK||'.'||l_api_name
301: ,p_msg_text => 'Step 3: Process for a single rule ');
302:

Line 308: FEM_ENGINES_PKG.tech_message (

304: l_param_rec.crnt_proc_child_obj_id := l_param_rec.obj_id;
305:
306: Process_Single_Rule(p_param_rec => l_param_rec);
307:
308: FEM_ENGINES_PKG.tech_message (
309: p_severity => g_log_level_3
310: ,p_module => G_BLOCK||'.'||l_api_name
311: ,p_msg_text => 'Status After Process for a single rule '
312: || l_param_rec.return_status);

Line 328: FEM_ENGINES_PKG.Tech_Message(

324: -----------------------------------------------------------------------
325: -----------------------------------------------------------------------
326: -- STEP 4.1: Flattening the rule set
327: -----------------------------------------------------------------------
328: FEM_ENGINES_PKG.Tech_Message(
329: p_severity => g_log_level_3
330: ,p_module => G_BLOCK||'.'||l_api_name
331: ,p_msg_text => 'Step 3.1 Flatten the rule set');
332:

Line 338: FEM_ENGINES_PKG.Tech_Message(

334: ,l_param_rec.crnt_proc_child_obj_id ) <> 0)THEN
335: --------------------------------------------------------------------
336: -- STEP 4.2: Preprocess rule set
337: --------------------------------------------------------------------
338: FEM_ENGINES_PKG.Tech_Message(
339: p_severity => g_log_level_1
340: ,p_module => G_BLOCK||'.'||l_api_name
341: ,p_msg_text => 'Step 4.2 PreProcess rule set' );
342:

Line 352: FEM_ENGINES_PKG.Tech_Message(

348: -- STEP 4.3.2: Open cursor for rule set
349: -- STEP 4.3.3: Process each rule in the rule set loop
350: -- STEP 4.3.4: Execution status for rule processing
351: -----------------------------------------------------------------------
352: FEM_ENGINES_PKG.Tech_Message(
353: p_severity => g_log_level_1
354: ,p_module => G_BLOCK||'.'||l_api_name
355: ,p_msg_text => 'Step 4.3.1: Loop through all Rule Set Rules');
356:

Line 361: FEM_ENGINES_PKG.Tech_Message(

357: OPEN l_rule_set_rules(l_param_rec.request_id,l_param_rec.obj_id);
358:
359: l_rule_set_rules_is_open := TRUE;
360:
361: FEM_ENGINES_PKG.Tech_Message(
362: p_severity => g_log_level_1
363: ,p_module => G_BLOCK||'.'||l_api_name
364: ,p_msg_text => 'Step 4.3.2:Rule set loop');
365:

Line 371: FEM_ENGINES_PKG.Tech_Message(

367: FETCH l_rule_set_rules INTO l_next_rule_obj_id,
368: l_next_rule_obj_def_id,
369: l_next_rule_exec_status;
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.3.3: Process next rule in rule set: '
375: ||l_next_rule_obj_id);

Line 377: FEM_ENGINES_PKG.Tech_Message(

373: ,p_module => G_BLOCK||'.'||l_api_name
374: ,p_msg_text => 'Step 4.3.3: Process next rule in rule set: '
375: ||l_next_rule_obj_id);
376:
377: FEM_ENGINES_PKG.Tech_Message(
378: p_severity => g_log_level_1
379: ,p_module => G_BLOCK||'.'||l_api_name
380: ,p_msg_text => 'Step 4.3.4: Process next rule in rule set status:'
381: || l_next_rule_exec_status);

Line 397: FEM_ENGINES_PKG.Tech_Message(

393: l_next_rule_exec_status <> 'SUCCESS') THEN
394: -----------------------------------------------------------------
395: -- STEP 4.2.3: Process Rule Set Rule
396: -----------------------------------------------------------------
397: FEM_ENGINES_PKG.Tech_Message(
398: p_severity => g_log_level_1
399: ,p_module => G_BLOCK||'.'||l_api_name
400: ,p_msg_text => 'Step 4.3.5: Process Rule Set Rule #'
401: ||TO_CHAR(l_rollup_sequence));

Line 405: FEM_ENGINES_PKG.tech_message (

401: ||TO_CHAR(l_rollup_sequence));
402:
403: Process_Single_Rule(p_param_rec => l_param_rec );
404:
405: FEM_ENGINES_PKG.tech_message (
406: p_severity => g_log_level_3
407: ,p_module => G_BLOCK||'.'||l_api_name
408: ,p_msg_text => 'Status After Process for a single rule '
409: || l_param_rec.return_status);

Line 439: FEM_ENGINES_PKG.Tech_Message (

435:
436: --------------------------------------------------------------------------
437: -- STEP 5: Engine Master Post Processing.
438: --------------------------------------------------------------------------
439: FEM_ENGINES_PKG.Tech_Message (
440: p_severity => g_log_level_3
441: ,p_module => G_BLOCK||'.'||l_api_name
442: ,p_msg_text => 'Step 5: Engine Master Post Processing');
443:

Line 463: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

459: END IF;
460:
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
464: ,p_module => G_BLOCK||'.'||l_api_name
465: ,p_msg_text => 'END');
466:
467: EXCEPTION

Line 478: FEM_ENGINES_PKG.Tech_Message (

474: IF (l_rule_set_rules%ISOPEN) THEN
475: CLOSE l_rule_set_rules;
476: END IF;
477:
478: FEM_ENGINES_PKG.Tech_Message (
479: p_severity => g_log_level_3
480: ,p_module => G_BLOCK||'.'||l_api_name
481: ,p_msg_text => 'Step 5: Engine Master Post Processing: ERROR');
482:

Line 489: -- FEM_ENGINES_PKG.User_Message (

485:
486: l_completion_status := FND_CONCURRENT.Set_Completion_Status('ERROR'
487: ,NULL);
488:
489: -- FEM_ENGINES_PKG.User_Message (
490: -- p_app_name => G_PFT
491: -- ,p_msg_name => 'Profit Calculation Engine Error');
492:
493: -- Set the return status to ERROR

Line 496: FEM_ENGINES_PKG.Tech_Message (

492:
493: -- Set the return status to ERROR
494: x_return_status := 'E';
495:
496: FEM_ENGINES_PKG.Tech_Message (
497: p_severity => g_log_level_5
498: ,p_module => G_BLOCK||'.'||l_api_name
499: ,p_msg_text => 'Profit Calculation Engine Error');
500: WHEN OTHERS THEN

Line 512: FEM_ENGINES_PKG.Tech_Message (

508: IF (l_rule_set_rules%ISOPEN) THEN
509: CLOSE l_rule_set_rules;
510: END IF;
511:
512: FEM_ENGINES_PKG.Tech_Message (
513: p_severity => g_log_level_3
514: ,p_module => G_BLOCK||'.'||l_api_name
515: ,p_msg_text => 'Step 5: Engine Master Post Processing: ERROR');
516:

Line 523: FEM_ENGINES_PKG.Tech_Message (

519:
520: l_completion_status := FND_CONCURRENT.Set_Completion_Status('ERROR'
521: ,NULL);
522:
523: FEM_ENGINES_PKG.Tech_Message (
524: p_severity => g_log_level_6
525: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
526: ,p_msg_text => gv_prg_msg);
527:

Line 528: FEM_ENGINES_PKG.Tech_Message (

524: p_severity => g_log_level_6
525: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
526: ,p_msg_text => gv_prg_msg);
527:
528: FEM_ENGINES_PKG.Tech_Message (
529: p_severity => g_log_level_6
530: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
531: ,p_msg_text => gv_callstack);
532:

Line 533: FEM_ENGINES_PKG.User_Message (

529: p_severity => g_log_level_6
530: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected Exception'
531: ,p_msg_text => gv_callstack);
532:
533: FEM_ENGINES_PKG.User_Message (
534: p_app_name => G_FEM
535: ,p_msg_name => G_UNEXPECTED_ERROR
536: ,p_token1 => 'ERR_MSG'
537: ,p_value1 => gv_prg_msg);

Line 571: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

567: e_eng_master_prep_error EXCEPTION;
568:
569: BEGIN
570:
571: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
572: ,p_module => G_BLOCK||'.'||l_api_name
573: ,p_msg_text => 'BEGIN');
574:
575: --------------------------------------------------------------------------

Line 608: FEM_ENGINES_PKG.Tech_Message (

604:
605: ----------------------------------------------------------------------------
606: -- Get the object info from fem_object_catalog_b for the object_id passed in
607: ----------------------------------------------------------------------------
608: FEM_ENGINES_PKG.Tech_Message (
609: p_severity => g_log_level_3
610: ,p_module => G_BLOCK||'.'||l_api_name
611: ,p_msg_text => 'Getting the Object Type Code of the given Object');
612:

Line 623: FEM_ENGINES_PKG.User_Message (

619: WHERE object_id = x_param_rec.obj_id;
620:
621: EXCEPTION
622: WHEN OTHERS THEN
623: FEM_ENGINES_PKG.User_Message (
624: p_app_name => G_PFT
625: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
626: ,p_token1 => 'OBJECT_ID'
627: ,p_value1 => x_param_rec.obj_id);

Line 629: FEM_ENGINES_PKG.Tech_Message (

625: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
626: ,p_token1 => 'OBJECT_ID'
627: ,p_value1 => x_param_rec.obj_id);
628:
629: FEM_ENGINES_PKG.Tech_Message (
630: p_severity => g_log_level_3
631: ,p_module => G_BLOCK||'.'||l_api_name
632: ,p_msg_text => 'Invalid Object Id' || x_param_rec.obj_id);
633:

Line 643: FEM_ENGINES_PKG.Tech_Message (

639: -- local_vs_combo_id of the rule matches the Rule Set's.
640: --------------------------------------------------------------------------
641: IF (x_param_rec.obj_type_code = 'RULE_SET') THEN
642:
643: FEM_ENGINES_PKG.Tech_Message (
644: p_severity => g_log_level_3
645: ,p_module => G_BLOCK||'.'||l_api_name
646: ,p_msg_text => 'Obj type code is a rule set');
647:

Line 657: FEM_ENGINES_PKG.User_Message (

653: ,x_obj_def_id => x_param_rec.crnt_proc_child_obj_defn_id);
654:
655: EXCEPTION
656: WHEN OTHERS THEN
657: FEM_ENGINES_PKG.User_Message (
658: p_app_name => G_PFT
659: ,p_msg_name => G_ENG_INV_OBJ_DEFN_RS_ERR
660: ,p_token1 => 'OBJECT_ID'
661: ,p_value1 => x_param_rec.obj_id

Line 665: FEM_ENGINES_PKG.Tech_Message (

661: ,p_value1 => x_param_rec.obj_id
662: ,p_token2 => 'EFFECTIVE_DATE'
663: ,p_value2 => x_param_rec.effective_date);
664:
665: FEM_ENGINES_PKG.Tech_Message (
666: p_severity => g_log_level_3
667: ,p_module => G_BLOCK||'.'||l_api_name
668: ,p_msg_text => 'No Definition found for the ruleset :'
669: || x_param_rec.obj_id || 'for the Date :'

Line 677: FEM_ENGINES_PKG.Tech_Message (

673: END;
674:
675: ELSIF (x_param_rec.obj_type_code = 'PPROF_PROFIT_CALC') THEN
676:
677: FEM_ENGINES_PKG.Tech_Message (
678: p_severity => g_log_level_3
679: ,p_module => G_BLOCK||'.'||l_api_name
680: ,p_msg_text => 'Obj type code is a single rule');
681:

Line 691: FEM_ENGINES_PKG.User_Message (

687: ,x_obj_def_id => x_param_rec.crnt_proc_child_obj_defn_id);
688:
689: EXCEPTION
690: WHEN OTHERS THEN
691: FEM_ENGINES_PKG.User_Message (
692: p_app_name => G_PFT
693: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
694: ,p_token1 => 'OBJECT_ID'
695: ,p_value1 => x_param_rec.obj_id

Line 699: FEM_ENGINES_PKG.Tech_Message (

695: ,p_value1 => x_param_rec.obj_id
696: ,p_token2 => 'EFFECTIVE_DATE'
697: ,p_value2 => x_param_rec.effective_date);
698:
699: FEM_ENGINES_PKG.Tech_Message (
700: p_severity => g_log_level_3
701: ,p_module => G_BLOCK||'.'||l_api_name
702: ,p_msg_text => 'No Definition found for the Rule :'
703: || x_param_rec.obj_id || 'for the Date :'

Line 708: FEM_ENGINES_PKG.User_Message(

704: || x_param_rec.effective_date);
705: RAISE e_eng_master_prep_error;
706: END;
707: ELSE
708: FEM_ENGINES_PKG.User_Message(
709: p_app_name => G_PFT
710: ,p_msg_name => G_ENG_INVALIDRULETYPE_ERR
711: ,p_token1 => 'OBJECT_TYPE_CODE'
712: ,p_value1 => x_param_rec.obj_type_code);

Line 727: FEM_ENGINES_PKG.User_Message (

723: FROM fem_object_definition_b
724: WHERE object_definition_id = x_param_rec.dataset_io_obj_def_id;
725: EXCEPTION
726: WHEN OTHERS THEN
727: FEM_ENGINES_PKG.User_Message (
728: p_app_name => G_PFT
729: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
730: ,p_token1 => 'OBJECT_ID'
731: ,p_value1 => x_param_rec.dataset_io_obj_def_id);

Line 733: FEM_ENGINES_PKG.Tech_Message (

729: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
730: ,p_token1 => 'OBJECT_ID'
731: ,p_value1 => x_param_rec.dataset_io_obj_def_id);
732:
733: FEM_ENGINES_PKG.Tech_Message (
734: p_severity => g_log_level_3
735: ,p_module => G_BLOCK||'.'||l_api_name
736: ,p_msg_text => 'No Object found for the given Dataset Group:'
737: || x_param_rec.dataset_io_obj_def_id);

Line 751: FEM_ENGINES_PKG.User_Message (

747: WHERE dataset_io_obj_def_id = x_param_rec.dataset_io_obj_def_id;
748:
749: EXCEPTION
750: WHEN OTHERS THEN
751: FEM_ENGINES_PKG.User_Message (
752: p_app_name => G_PFT
753: ,p_msg_name => G_ENG_NO_OUTPUT_DS_ERR
754: ,p_token1 => 'DATASET_GROUP_OBJ_DEF_ID'
755: ,p_value1 => x_param_rec.dataset_io_obj_def_id);

Line 757: FEM_ENGINES_PKG.Tech_Message (

753: ,p_msg_name => G_ENG_NO_OUTPUT_DS_ERR
754: ,p_token1 => 'DATASET_GROUP_OBJ_DEF_ID'
755: ,p_value1 => x_param_rec.dataset_io_obj_def_id);
756:
757: FEM_ENGINES_PKG.Tech_Message (
758: p_severity => g_log_level_3
759: ,p_module => G_BLOCK||'.'||l_api_name
760: ,p_msg_text => 'No Output Dataset for the DS Group Definition:'
761: || x_param_rec.dataset_grp_name);

Line 781: FEM_ENGINES_PKG.User_Message (

777: WHERE source_system_display_code = G_PFT;
778:
779: EXCEPTION
780: WHEN OTHERS THEN
781: FEM_ENGINES_PKG.User_Message (
782: p_app_name => G_PFT
783: ,p_msg_name => G_ENG_INVALID_OBJ_ERR
784: ,p_token1 => 'OBJECT_ID'
785: ,p_value1 => x_param_rec.obj_id);

Line 795: FEM_ENGINES_PKG.Tech_Message (

791:
792: -- Log all Request Record Parameters if we have low level debugging
793: IF ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) ) THEN
794:
795: FEM_ENGINES_PKG.Tech_Message (
796: p_severity => G_LOG_LEVEL_1
797: ,p_module => G_BLOCK||'.'||l_api_name||'.x_param_rec'
798: ,p_msg_text =>
799: ' dataset_grp_obj_def_id='||x_param_rec.dataset_io_obj_def_id||

Line 823: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

819: );
820:
821: END IF;
822:
823: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
824: ,p_module => G_BLOCK||'.'||l_api_name
825: ,p_msg_text => 'END');
826:
827: EXCEPTION

Line 830: FEM_ENGINES_PKG.Tech_Message (

826:
827: EXCEPTION
828: WHEN e_eng_master_prep_error THEN
829:
830: FEM_ENGINES_PKG.Tech_Message (
831: p_severity => g_log_level_5
832: ,p_module => G_BLOCK||'.'||l_api_name
833: ,p_msg_text => 'Engine Master Preperation Exception');
834: RAISE e_pc_engine_error;

Line 863: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

859: e_pl_register_request_error EXCEPTION;
860:
861: BEGIN
862:
863: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
864: ,p_module => G_BLOCK||'.'||l_api_name
865: ,p_msg_text => 'BEGIN');
866:
867: SAVEPOINT register_request_pub;

Line 903: FEM_ENGINES_PKG.Tech_Message (

899: END IF;
900:
901: COMMIT;
902:
903: FEM_ENGINES_PKG.Tech_Message (
904: p_severity => g_log_level_1
905: ,p_module => G_BLOCK||'.'||l_api_name
906: ,p_msg_text => 'Request id is '||p_param_rec.request_id);
907:

Line 908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

904: p_severity => g_log_level_1
905: ,p_module => G_BLOCK||'.'||l_api_name
906: ,p_msg_text => 'Request id is '||p_param_rec.request_id);
907:
908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
909: ,p_module => G_BLOCK||'.'||l_api_name
910: ,p_msg_text => 'END');
911:
912: EXCEPTION

Line 917: FEM_ENGINES_PKG.Tech_Message (

913: WHEN e_pl_register_request_error THEN
914:
915: ROLLBACK TO register_request_pub;
916:
917: FEM_ENGINES_PKG.Tech_Message (
918: p_severity => g_log_level_5
919: ,p_module => G_BLOCK||'.'||l_api_name
920: ,p_msg_text => 'Register Request Exception');
921:

Line 922: FEM_ENGINES_PKG.User_Message (

918: p_severity => g_log_level_5
919: ,p_module => G_BLOCK||'.'||l_api_name
920: ,p_msg_text => 'Register Request Exception');
921:
922: FEM_ENGINES_PKG.User_Message (
923: p_app_name => G_PFT
924: ,p_msg_name => G_PL_REG_REQUEST_ERR
925: ,p_token1 => 'REQUEST_ID'
926: ,p_value1 => p_param_rec.request_id);

Line 934: FEM_ENGINES_PKG.User_Message (

930: WHEN OTHERS THEN
931:
932: ROLLBACK TO register_request_pub;
933:
934: FEM_ENGINES_PKG.User_Message (
935: p_app_name => G_PFT
936: ,p_msg_name => G_PL_REG_REQUEST_ERR
937: ,p_token1 => 'REQUEST_ID'
938: ,p_value1 => p_param_rec.request_id);

Line 972: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

968: e_register_obj_def_error EXCEPTION;
969:
970: BEGIN
971:
972: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
973: ,p_module => G_BLOCK||'.'||l_api_name
974: ,p_msg_text => 'BEGIN');
975:
976: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register

Line 999: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

995: ,p_msg_data => l_msg_data);
996: RAISE e_register_obj_def_error;
997: END IF;
998:
999: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1000: ,p_module => G_BLOCK||'.'||l_api_name
1001: ,p_msg_text => 'END');
1002:
1003: EXCEPTION

Line 1005: FEM_ENGINES_PKG.Tech_Message (

1001: ,p_msg_text => 'END');
1002:
1003: EXCEPTION
1004: WHEN e_register_obj_def_error THEN
1005: FEM_ENGINES_PKG.Tech_Message (
1006: p_severity => g_log_level_5
1007: ,p_module => G_BLOCK||'.'||l_api_name
1008: ,p_msg_text => 'Register Object Definition Exception');
1009:

Line 1010: FEM_ENGINES_PKG.User_Message (

1006: p_severity => g_log_level_5
1007: ,p_module => G_BLOCK||'.'||l_api_name
1008: ,p_msg_text => 'Register Object Definition Exception');
1009:
1010: FEM_ENGINES_PKG.User_Message (
1011: p_app_name => G_PFT
1012: ,p_msg_name => G_PL_OBJ_EXECLOCK_EXISTS_ERR
1013: ,p_token1 => 'REQUEST_ID'
1014: ,p_value1 => p_param_rec.request_id);

Line 1045: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1041: e_register_obj_exe_step_error EXCEPTION;
1042:
1043: BEGIN
1044:
1045: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1046: ,p_module => G_BLOCK||'.'||l_api_name
1047: ,p_msg_text => 'BEGIN');
1048:
1049: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register step

Line 1071: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1067: ,p_msg_data => l_msg_data);
1068: RAISE e_register_obj_exe_step_error;
1069: END IF;
1070:
1071: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1072: ,p_module => G_BLOCK||'.'||l_api_name
1073: ,p_msg_text => 'END');
1074:
1075: EXCEPTION

Line 1077: FEM_ENGINES_PKG.Tech_Message (

1073: ,p_msg_text => 'END');
1074:
1075: EXCEPTION
1076: WHEN e_register_obj_exe_step_error THEN
1077: FEM_ENGINES_PKG.Tech_Message (
1078: p_severity => g_log_level_5
1079: ,p_module => G_BLOCK||'.'||l_api_name
1080: ,p_msg_text => 'Register Obj Exec Step Exception');
1081:

Line 1082: FEM_ENGINES_PKG.User_Message (

1078: p_severity => g_log_level_5
1079: ,p_module => G_BLOCK||'.'||l_api_name
1080: ,p_msg_text => 'Register Obj Exec Step Exception');
1081:
1082: FEM_ENGINES_PKG.User_Message (
1083: p_app_name => G_PFT
1084: ,p_msg_name => G_PL_REG_EXEC_STEP_ERR
1085: ,p_token1 => 'OBJECT_ID'
1086: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1091: FEM_ENGINES_PKG.User_Message (

1087:
1088: RAISE e_pc_engine_error;
1089:
1090: WHEN OTHERS THEN
1091: FEM_ENGINES_PKG.User_Message (
1092: p_app_name => G_PFT
1093: ,p_msg_name => G_PL_REG_EXEC_STEP_ERR
1094: ,p_token1 => 'OBJECT_ID'
1095: ,p_value1 => p_param_rec.crnt_proc_child_obj_id);

Line 1125: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

1121: e_pl_preprocess_rule_set_err EXCEPTION;
1122:
1123: BEGIN
1124:
1125: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
1126: ,p_module => G_BLOCK||'.'||l_api_name
1127: ,p_msg_text => 'BEGIN');
1128:
1129: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(

Line 1153: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1149: RAISE e_pl_preprocess_rule_set_err ;
1150:
1151: END IF;
1152:
1153: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1154: ,p_module => G_BLOCK||'.'||l_api_name
1155: ,p_msg_text => 'END');
1156:
1157: EXCEPTION

Line 1159: FEM_ENGINES_PKG.Tech_Message (

1155: ,p_msg_text => 'END');
1156:
1157: EXCEPTION
1158: WHEN e_pl_preprocess_rule_set_err THEN
1159: FEM_ENGINES_PKG.Tech_Message (
1160: p_severity => g_log_level_5
1161: ,p_module => G_BLOCK||'.'||l_api_name
1162: ,p_msg_text => 'Preprocess Rule Set Exception' );
1163:

Line 1164: FEM_ENGINES_PKG.User_Message (

1160: p_severity => g_log_level_5
1161: ,p_module => G_BLOCK||'.'||l_api_name
1162: ,p_msg_text => 'Preprocess Rule Set Exception' );
1163:
1164: FEM_ENGINES_PKG.User_Message (
1165: p_app_name => G_PFT
1166: ,p_msg_name => G_ENG_PRE_PROC_RS_ERR
1167: ,p_token1 => 'RULE_SET_OBJ_ID'
1168: ,p_value1 => p_param_rec.obj_id);

Line 1173: FEM_ENGINES_PKG.User_Message (

1169:
1170: RAISE e_pc_engine_error;
1171:
1172: WHEN OTHERS THEN
1173: FEM_ENGINES_PKG.User_Message (
1174: p_app_name => G_PFT
1175: ,p_msg_name => G_ENG_PRE_PROC_RS_ERR
1176: ,p_token1 => 'RULE_SET_OBJ_ID'
1177: ,p_value1 => p_param_rec.obj_id);

Line 1232: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1228: BEGIN
1229: -- Initialize the return status to SUCCESS
1230: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1231:
1232: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1233: ,p_module => G_BLOCK||'.'||l_api_name
1234: ,p_msg_text => 'BEGIN');
1235:
1236: FEM_ENGINES_PKG.Tech_Message (

Line 1236: FEM_ENGINES_PKG.Tech_Message (

1232: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1233: ,p_module => G_BLOCK||'.'||l_api_name
1234: ,p_msg_text => 'BEGIN');
1235:
1236: FEM_ENGINES_PKG.Tech_Message (
1237: p_severity => g_log_level_2
1238: ,p_module => G_BLOCK||'.'||l_api_name
1239: ,p_msg_text => 'Validate the Rule Definition');
1240:

Line 1252: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

1248: ,p_Ledger_ID => p_param_rec.ledger_id);
1249:
1250: -- Unexpected error
1251: IF (l_err_code <> 0) THEN
1252: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
1253: ,p_msg_name => l_err_msg);
1254:
1255: RAISE e_process_single_rule_error;
1256:

Line 1259: FEM_ENGINES_PKG.Tech_Message (

1255: RAISE e_process_single_rule_error;
1256:
1257: END IF;
1258:
1259: FEM_ENGINES_PKG.Tech_Message (
1260: p_severity => g_log_level_1
1261: ,p_module => G_BLOCK||'.'||l_api_name
1262: ,p_msg_text => 'PROCESSING OBJECT ID: '
1263: ||p_param_rec.crnt_proc_child_obj_id

Line 1267: FEM_ENGINES_PKG.Tech_Message (

1263: ||p_param_rec.crnt_proc_child_obj_id
1264: ||'AND PROCESSING OBJECT DEFINITION ID: '
1265: ||p_param_rec.crnt_proc_child_obj_defn_id);
1266:
1267: FEM_ENGINES_PKG.Tech_Message (
1268: p_severity => g_log_level_3
1269: ,p_module => G_BLOCK||'.'||l_api_name
1270: ,p_msg_text => 'Getting Profit Calculation Rule Details');
1271:

Line 1296: FEM_ENGINES_PKG.User_Message (

1292: WHERE pprof_calc_obj_def_id = p_param_rec.crnt_proc_child_obj_defn_id;
1293:
1294: EXCEPTION
1295: WHEN no_data_found THEN
1296: FEM_ENGINES_PKG.User_Message (
1297: p_app_name => G_PFT
1298: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
1299: ,p_token1 => 'OBJECT_ID'
1300: ,p_value1 => p_param_rec.crnt_proc_child_obj_id

Line 1341: FEM_ENGINES_PKG.Tech_Message (

1337: EXCEPTION
1338: WHEN e_register_rule_error THEN
1339: ROLLBACK TO register_rule_pub;
1340:
1341: FEM_ENGINES_PKG.Tech_Message (
1342: p_severity => G_LOG_LEVEL_6
1343: ,p_module => G_BLOCK||'.'||l_api_name
1344: ,p_msg_text => 'Register Rule Exception');
1345:

Line 1346: FEM_ENGINES_PKG.User_Message (

1342: p_severity => G_LOG_LEVEL_6
1343: ,p_module => G_BLOCK||'.'||l_api_name
1344: ,p_msg_text => 'Register Rule Exception');
1345:
1346: FEM_ENGINES_PKG.User_Message (
1347: p_app_name => G_PFT
1348: ,p_msg_name => G_PL_OBJ_EXEC_LOCK_ERR);
1349:
1350: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 1358: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3

1354:
1355: --------------------------------------------------------------------------
1356: --call to FEM_PL_PKG.register_dependent_objdefs
1357: --------------------------------------------------------------------------
1358: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1359: ,p_module => G_BLOCK||'.'||l_api_name
1360: ,p_msg_text => 'Register_Dependent_Objects');
1361:
1362: Register_Dependent_Objects( p_param_rec => p_param_rec);

Line 1367: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3

1363:
1364: ---------------------------------------------------------------------------
1365: --Register the dependant object 'Dataset Group' object
1366: ---------------------------------------------------------------------------
1367: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1368: ,p_module => G_BLOCK||'.'||l_api_name
1369: ,p_msg_text => 'Register_Dataset_Grp_Object');
1370:
1371: Register_Object_Definition (

Line 1402: FEM_ENGINES_PKG.Tech_Message (

1398: AND source_system_code = p_param_rec.source_system_code
1399: AND dimension_group_id = l_customer_level;
1400: EXCEPTION
1401: WHEN no_data_found THEN
1402: FEM_ENGINES_PKG.Tech_Message (
1403: p_severity => g_log_level_3
1404: ,p_module => G_BLOCK||'.'||l_api_name
1405: ,p_msg_text => 'Region Counting is Already
1406: Performed for the Specified Period');

Line 1408: FEM_ENGINES_PKG.User_Message (

1404: ,p_module => G_BLOCK||'.'||l_api_name
1405: ,p_msg_text => 'Region Counting is Already
1406: Performed for the Specified Period');
1407:
1408: FEM_ENGINES_PKG.User_Message (
1409: p_app_name => G_PFT
1410: ,p_msg_name => G_ENG_RGN_CNT_DONE_ERR
1411: ,p_token1 => 'CAL_PERIOD_ID'
1412: ,p_value1 => p_param_rec.output_cal_period_id);

Line 1420: FEM_ENGINES_PKG.Tech_Message(

1416: IF l_region_percent = 0 THEN
1417: -----------------------------------------------------------------------
1418: -- Call FEM_PL_PKG.Register_Table()
1419: -----------------------------------------------------------------------
1420: FEM_ENGINES_PKG.Tech_Message(
1421: p_severity => g_log_level_3
1422: ,p_module => G_BLOCK||'.'||l_api_name
1423: ,p_msg_text => 'Register Table:REGION_COUNTING');
1424:

Line 1433: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3

1429:
1430: -----------------------------------------------------------------------
1431: -- Register this step
1432: -----------------------------------------------------------------------
1433: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1434: ,p_module => G_BLOCK||'.'||l_api_name
1435: ,p_msg_text => 'Register the step ');
1436:
1437: Register_Obj_Exe_Step( p_param_rec => p_param_rec

Line 1457: FEM_ENGINES_PKG.User_Message (

1453: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1454: Get_Put_Messages (p_msg_count => l_msg_count
1455: ,p_msg_data => l_msg_data);
1456:
1457: FEM_ENGINES_PKG.User_Message (
1458: p_app_name => G_PFT
1459: ,p_msg_name => 'Region Counting Engine Exception');
1460:
1461: RAISE e_process_single_rule_error;

Line 1467: FEM_ENGINES_PKG.Tech_Message (

1463:
1464: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1465:
1466: ELSE
1467: FEM_ENGINES_PKG.Tech_Message (
1468: p_severity => g_log_level_3
1469: ,p_module => G_BLOCK||'.'||l_api_name
1470: ,p_msg_text => 'Region Counting is Already
1471: Performed for the Specified Period');

Line 1473: FEM_ENGINES_PKG.User_Message (

1469: ,p_module => G_BLOCK||'.'||l_api_name
1470: ,p_msg_text => 'Region Counting is Already
1471: Performed for the Specified Period');
1472:
1473: FEM_ENGINES_PKG.User_Message (
1474: p_app_name => G_PFT
1475: ,p_msg_name => G_ENG_RGN_CNT_DONE_ERR
1476: ,p_token1 => 'CAL_PERIOD_ID'
1477: ,p_value1 => p_param_rec.output_cal_period_id);

Line 1497: FEM_ENGINES_PKG.Tech_Message (

1493: AND data_aggregation_type_code = 'CUSTOMER_AGGREGATION';
1494:
1495: EXCEPTION
1496: WHEN no_data_found THEN
1497: FEM_ENGINES_PKG.Tech_Message (
1498: p_severity => g_log_level_3
1499: ,p_module => G_BLOCK||'.'||l_api_name
1500: ,p_msg_text => 'Profit Percentile is Already
1501: Performed for the Specified Period');

Line 1503: FEM_ENGINES_PKG.User_Message (

1499: ,p_module => G_BLOCK||'.'||l_api_name
1500: ,p_msg_text => 'Profit Percentile is Already
1501: Performed for the Specified Period');
1502:
1503: FEM_ENGINES_PKG.User_Message (
1504: p_app_name => G_PFT
1505: ,p_msg_name => G_ENG_PPTILE_DONE_ERR
1506: ,p_token1 => 'CAL_PERIOD_ID'
1507: ,p_value1 => p_param_rec.output_cal_period_id);

Line 1538: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3

1534: IF l_profit_percentile = 0 THEN
1535: -----------------------------------------------------------------------
1536: -- Call FEM_PL_PKG.Register_Table()
1537: -----------------------------------------------------------------------
1538: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1539: ,p_module => G_BLOCK||'.'||l_api_name
1540: ,p_msg_text => 'Register table:CUST_PPTILE');
1541:
1542: Register_Table( p_param_rec => p_param_rec

Line 1547: FEM_ENGINES_PKG.Tech_Message(

1543: ,p_tbl_name => g_fem_customer_profit
1544: ,p_num_output_rows => 0
1545: ,p_stmt_type => g_update);
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 => 'Register updt colmn:CUST_PPTILE');
1551:

Line 1565: FEM_ENGINES_PKG.Tech_Message(

1561:
1562: -----------------------------------------------------------------------
1563: -- Register this step
1564: -----------------------------------------------------------------------
1565: FEM_ENGINES_PKG.Tech_Message(
1566: p_severity => g_log_level_3
1567: ,p_module => G_BLOCK||'.'||l_api_name
1568: ,p_msg_text => 'Register the step: CUST_PPTILE');
1569:

Line 1590: FEM_ENGINES_PKG.User_Message (

1586: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1587: Get_Put_Messages (p_msg_count => l_msg_count
1588: ,p_msg_data => l_msg_data);
1589:
1590: FEM_ENGINES_PKG.User_Message (
1591: p_app_name => G_PFT
1592: ,p_msg_name => 'Profit Percentile Engine Exception');
1593:
1594: RAISE e_process_single_rule_error;

Line 1599: FEM_ENGINES_PKG.Tech_Message (

1595: END IF;
1596:
1597: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1598: ELSE
1599: FEM_ENGINES_PKG.Tech_Message (
1600: p_severity => g_log_level_3
1601: ,p_module => G_BLOCK||'.'||l_api_name
1602: ,p_msg_text => 'Profit Percentile is Already
1603: Performed for the Specified Period');

Line 1605: FEM_ENGINES_PKG.User_Message (

1601: ,p_module => G_BLOCK||'.'||l_api_name
1602: ,p_msg_text => 'Profit Percentile is Already
1603: Performed for the Specified Period');
1604:
1605: FEM_ENGINES_PKG.User_Message (
1606: p_app_name => G_PFT
1607: ,p_msg_name => G_ENG_PPTILE_DONE_ERR
1608: ,p_token1 => 'CAL_PERIOD_ID'
1609: ,p_value1 => p_param_rec.output_cal_period_id);

Line 1627: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3

1623:
1624: -----------------------------------------------------------------------
1625: -- Call FEM_PL_PKG.Register_Table()
1626: -----------------------------------------------------------------------
1627: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_3
1628: ,p_module => G_BLOCK||'.'||l_api_name
1629: ,p_msg_text => 'Register table:Value Index');
1630:
1631: Register_Table( p_param_rec => p_param_rec

Line 1639: FEM_ENGINES_PKG.Tech_Message(

1635:
1636: -----------------------------------------------------------------------
1637: -- Register this step
1638: -----------------------------------------------------------------------
1639: FEM_ENGINES_PKG.Tech_Message(
1640: p_severity => g_log_level_3
1641: ,p_module => G_BLOCK||'.'||l_api_name
1642: ,p_msg_text => 'Register the step:VALUE_INDEX');
1643:

Line 1670: FEM_ENGINES_PKG.User_Message (

1666: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1667: Get_Put_Messages (p_msg_count => l_msg_count
1668: ,p_msg_data => l_msg_data);
1669:
1670: FEM_ENGINES_PKG.User_Message (
1671: p_app_name => G_PFT
1672: ,p_msg_name => 'Value Index Engine Exception');
1673:
1674: RAISE e_process_single_rule_error;

Line 1687: FEM_ENGINES_PKG.Tech_Message(

1683: /* IF (l_prospect_ident_flag = 'Y') THEN
1684: -----------------------------------------------------------------------
1685: -- Call FEM_PL_PKG.Register_Table()
1686: -----------------------------------------------------------------------
1687: FEM_ENGINES_PKG.Tech_Message(
1688: p_severity => g_log_level_3
1689: ,p_module => G_BLOCK||'.'||l_api_name
1690: ,p_msg_text => 'Register table:Prospect Identification');
1691:

Line 1705: FEM_ENGINES_PKG.Tech_Message(

1701:
1702: -----------------------------------------------------------------------
1703: -- Register this step
1704: -----------------------------------------------------------------------
1705: FEM_ENGINES_PKG.Tech_Message(
1706: p_severity => g_log_level_3
1707: ,p_module => G_BLOCK||'.'||l_api_name
1708: ,p_msg_text => 'Register the step:PROSP_IDENT');
1709:

Line 1729: FEM_ENGINES_PKG.User_Message (

1725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1726: Get_Put_Messages (p_msg_count => l_msg_count
1727: ,p_msg_data => l_msg_data);
1728:
1729: FEM_ENGINES_PKG.User_Message (
1730: p_app_name => G_PFT
1731: ,p_msg_name => 'Prospect Identification Engine Exception');
1732:
1733: RAISE e_process_single_rule_error;

Line 1740: FEM_ENGINES_PKG.Tech_Message (

1736:
1737: END IF; */
1738: EXCEPTION
1739: WHEN e_process_single_rule_error THEN
1740: FEM_ENGINES_PKG.Tech_Message (
1741: p_severity => g_log_level_5
1742: ,p_module => G_BLOCK||'.'||l_api_name
1743: ,p_msg_text => 'Process Single Rule Exception');
1744:

Line 1745: -- FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

1741: p_severity => g_log_level_5
1742: ,p_module => G_BLOCK||'.'||l_api_name
1743: ,p_msg_text => 'Process Single Rule Exception');
1744:
1745: -- FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
1746: -- ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
1747:
1748: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
1749:

Line 1752: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

1748: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
1749:
1750: WHEN OTHERS THEN
1751:
1752: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
1753: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
1754:
1755: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
1756:

Line 1779: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1775: l_api_name CONSTANT VARCHAR2(30) := 'is_rule_set_flattened';
1776: l_count NUMBER;
1777:
1778: BEGIN
1779: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1780: ,p_module => G_BLOCK||'.'||l_api_name
1781: ,p_msg_text => 'BEGIN');
1782: SELECT COUNT(*)
1783: INTO l_count

Line 1796: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

1792: RETURN -1;
1793: END IF;
1794:
1795: RETURN 0;
1796: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
1797: ,p_module => G_BLOCK||'.'||l_api_name
1798: ,p_msg_text => 'END');
1799: EXCEPTION
1800: WHEN no_data_found THEN

Line 1834: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1830:
1831:
1832: BEGIN
1833:
1834: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1835: ,p_module => G_BLOCK||'.'||l_api_name
1836: ,p_msg_text => 'BEGIN');
1837:
1838: --------------------------------------------------------------------------

Line 1841: FEM_ENGINES_PKG.Tech_Message (

1837:
1838: --------------------------------------------------------------------------
1839: -- STEP 1: Update Object Execution Status.
1840: --------------------------------------------------------------------------
1841: FEM_ENGINES_PKG.Tech_Message (
1842: p_severity => g_log_level_1
1843: ,p_module => G_BLOCK||'.'||l_api_name
1844: ,p_msg_text => 'Step 1: Update Object Execution Status');
1845:

Line 1869: FEM_ENGINES_PKG.Tech_Message (

1865: -- STEP 2: Update Object Execution Errors.
1866: --------------------------------------------------------------------------
1867: IF (p_exec_status_code <> g_exec_status_success) THEN
1868:
1869: FEM_ENGINES_PKG.Tech_Message (
1870: p_severity => g_log_level_1
1871: ,p_module => G_BLOCK||'.'||l_api_name
1872: ,p_msg_text => 'Step 2: Update Object Execution Errors');
1873:

Line 1898: FEM_ENGINES_PKG.Tech_Message (

1894:
1895: --------------------------------------------------------------------------
1896: -- STEP 3: Update Request Status.
1897: --------------------------------------------------------------------------
1898: FEM_ENGINES_PKG.Tech_Message (
1899: p_severity => g_log_level_1
1900: ,p_module => G_BLOCK||'.'||l_api_name
1901: ,p_msg_text => 'Step 3: Update Request Status');
1902:

Line 1922: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1918: END IF;
1919:
1920: COMMIT;
1921:
1922: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1923: ,p_module => G_BLOCK||'.'||l_api_name
1924: ,p_msg_text => 'END');
1925:
1926: EXCEPTION

Line 1928: FEM_ENGINES_PKG.Tech_Message (

1924: ,p_msg_text => 'END');
1925:
1926: EXCEPTION
1927: WHEN e_eng_master_post_proc_error THEN
1928: FEM_ENGINES_PKG.Tech_Message (
1929: p_severity => g_log_level_5
1930: ,p_module => G_BLOCK||'.'||l_api_name
1931: ,p_msg_text => 'Engine Master Post Process Exception');
1932:

Line 1934: FEM_ENGINES_PKG.User_Message (

1930: ,p_module => G_BLOCK||'.'||l_api_name
1931: ,p_msg_text => 'Engine Master Post Process Exception');
1932:
1933:
1934: FEM_ENGINES_PKG.User_Message (
1935: p_app_name => G_PFT
1936: ,p_msg_name => G_ENG_ENGINE_POST_PROC_ERR
1937: ,p_token1 => 'OBJECT_ID'
1938: ,p_value1 => p_param_rec.obj_id);

Line 1967: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1963: l_api_name CONSTANT VARCHAR2(30) := 'Get_Object_Definition';
1964:
1965: BEGIN
1966:
1967: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1968: ,p_module => G_BLOCK||'.'||l_api_name
1969: ,p_msg_text => 'BEGIN');
1970:
1971: SELECT d.object_definition_id

Line 1981: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1977: AND d.object_id = o.object_id
1978: AND p_effective_date BETWEEN d.effective_start_date AND d.effective_end_date
1979: AND d.old_approved_copy_flag = 'N';
1980:
1981: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1982: ,p_module => G_BLOCK||'.'||l_api_name
1983: ,p_msg_text => 'END');
1984:
1985: EXCEPTION

Line 1987: FEM_ENGINES_PKG.User_Message (

1983: ,p_msg_text => 'END');
1984:
1985: EXCEPTION
1986: WHEN no_data_found THEN
1987: FEM_ENGINES_PKG.User_Message (
1988: p_app_name => G_PFT
1989: ,p_msg_name => G_ENG_INVALID_OBJ_DEFN_ERR
1990: ,p_token1 => 'OBJECT_ID'
1991: ,p_value1 => p_object_id

Line 2022: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2018: l_message VARCHAR2(4000);
2019:
2020: BEGIN
2021:
2022: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2023: ,p_module => G_BLOCK||'.'||l_api_name
2024: ,p_msg_text => 'msg_count='||p_msg_count);
2025:
2026: l_msg_data := p_msg_data;

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

2029:
2030: FND_MESSAGE.Set_Encoded(l_msg_data);
2031: l_message := FND_MESSAGE.Get;
2032:
2033: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2034:
2035: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2036: ,p_module => G_BLOCK||'.'||l_api_name
2037: ,p_msg_text => 'msg_data='||l_message);

Line 2035: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2031: l_message := FND_MESSAGE.Get;
2032:
2033: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2034:
2035: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2036: ,p_module => G_BLOCK||'.'||l_api_name
2037: ,p_msg_text => 'msg_data='||l_message);
2038:
2039: ELSIF (p_msg_count > 1) THEN

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

2044: ,p_encoded => FND_API.G_FALSE
2045: ,p_data => l_message
2046: ,p_msg_index_out => l_msg_out);
2047:
2048: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2049:
2050: FEM_ENGINES_PKG.Tech_Message (
2051: p_severity => g_log_level_2
2052: ,p_module => G_BLOCK||'.'||l_api_name

Line 2050: FEM_ENGINES_PKG.Tech_Message (

2046: ,p_msg_index_out => l_msg_out);
2047:
2048: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
2049:
2050: FEM_ENGINES_PKG.Tech_Message (
2051: p_severity => g_log_level_2
2052: ,p_module => G_BLOCK||'.'||l_api_name
2053: ,p_msg_text => 'msg_data='||l_message);
2054:

Line 2096: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2092: e_register_dep_obj_def_error EXCEPTION;
2093:
2094: BEGIN
2095:
2096: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2097: ,p_module => G_BLOCK||'.'||l_api_name
2098: ,p_msg_text => 'BEGIN');
2099:
2100: -- Register all the Dependent Objects for CALC

Line 2121: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2117: ,p_msg_data => l_msg_data);
2118: RAISE e_register_dep_obj_def_error;
2119: END IF;
2120:
2121: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2122: ,p_module => G_BLOCK||'.'||l_api_name
2123: ,p_msg_text => 'END');
2124:
2125: EXCEPTION

Line 2127: FEM_ENGINES_PKG.Tech_Message (

2123: ,p_msg_text => 'END');
2124:
2125: EXCEPTION
2126: WHEN e_register_dep_obj_def_error THEN
2127: FEM_ENGINES_PKG.Tech_Message (
2128: p_severity => g_log_level_5
2129: ,p_module => G_BLOCK||'.'||l_api_name
2130: ,p_msg_text => 'Register Dependant Objects Exception');
2131:

Line 2132: FEM_ENGINES_PKG.User_Message (

2128: p_severity => g_log_level_5
2129: ,p_module => G_BLOCK||'.'||l_api_name
2130: ,p_msg_text => 'Register Dependant Objects Exception');
2131:
2132: FEM_ENGINES_PKG.User_Message (
2133: p_app_name => G_PFT
2134: ,p_msg_name => G_PL_DEP_OBJ_DEF_ERR
2135: ,p_token1 => 'OBJ_DEF_ID'
2136: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);

Line 2141: FEM_ENGINES_PKG.Tech_Message (

2137:
2138: RAISE e_pc_engine_error;
2139:
2140: WHEN OTHERS THEN
2141: FEM_ENGINES_PKG.Tech_Message (
2142: p_severity => g_log_level_5
2143: ,p_module => G_BLOCK||'.'||l_api_name
2144: ,p_msg_text => 'Register Dependant Objects Exception');
2145:

Line 2146: FEM_ENGINES_PKG.User_Message (

2142: p_severity => g_log_level_5
2143: ,p_module => G_BLOCK||'.'||l_api_name
2144: ,p_msg_text => 'Register Dependant Objects Exception');
2145:
2146: FEM_ENGINES_PKG.User_Message (
2147: p_app_name => G_PFT
2148: ,p_msg_name => G_PL_DEP_OBJ_DEF_ERR
2149: ,p_token1 => 'OBJ_DEF_ID'
2150: ,p_value1 => p_param_rec.crnt_proc_child_obj_defn_id);

Line 2181: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2177: e_upd_num_input_rows_error EXCEPTION;
2178:
2179: BEGIN
2180:
2181: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2182: ,p_module => G_BLOCK||'.'||l_api_name
2183: ,p_msg_text => 'BEGIN');
2184:
2185: -- Set the number of output rows for the output table.

Line 2205: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

2201: ,p_msg_data => l_msg_data);
2202: RAISE e_upd_num_input_rows_error;
2203: END IF;
2204:
2205: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
2206: ,p_module => G_BLOCK||'.'||l_api_name
2207: ,p_msg_text => 'END');
2208:
2209: EXCEPTION

Line 2211: FEM_ENGINES_PKG.Tech_Message (

2207: ,p_msg_text => 'END');
2208:
2209: EXCEPTION
2210: WHEN e_upd_num_input_rows_error THEN
2211: FEM_ENGINES_PKG.Tech_Message (
2212: p_severity => g_log_level_5
2213: ,p_module => G_BLOCK||'.'||l_api_name
2214: ,p_msg_text => 'Update Input Rows Exception');
2215:

Line 2216: FEM_ENGINES_PKG.User_Message (

2212: p_severity => g_log_level_5
2213: ,p_module => G_BLOCK||'.'||l_api_name
2214: ,p_msg_text => 'Update Input Rows Exception');
2215:
2216: FEM_ENGINES_PKG.User_Message (
2217: p_app_name => G_PFT
2218: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2219:
2220: RAISE e_pc_engine_error;

Line 2223: FEM_ENGINES_PKG.Tech_Message (

2219:
2220: RAISE e_pc_engine_error;
2221:
2222: WHEN OTHERS THEN
2223: FEM_ENGINES_PKG.Tech_Message (
2224: p_severity => g_log_level_5
2225: ,p_module => G_BLOCK||'.'||l_api_name
2226: ,p_msg_text => 'Update Input Rows Exception');
2227:

Line 2228: FEM_ENGINES_PKG.User_Message (

2224: p_severity => g_log_level_5
2225: ,p_module => G_BLOCK||'.'||l_api_name
2226: ,p_msg_text => 'Update Input Rows Exception');
2227:
2228: FEM_ENGINES_PKG.User_Message (
2229: p_app_name => G_PFT
2230: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2231:
2232: RAISE e_pc_engine_error;

Line 2263: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2259: e_register_table_error EXCEPTION;
2260:
2261: BEGIN
2262:
2263: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2264: ,p_module => G_BLOCK||'.'||l_api_name
2265: ,p_msg_text => 'BEGIN');
2266:
2267: -- Call the FEM_PL_PKG.Register_Table API procedure to register

Line 2290: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

2286: ,p_msg_data => l_msg_data);
2287: RAISE e_register_table_error;
2288: END IF;
2289:
2290: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
2291: ,p_module => G_BLOCK||'.'||l_api_name
2292: ,p_msg_text => 'END');
2293:
2294: EXCEPTION

Line 2296: FEM_ENGINES_PKG.Tech_Message(

2292: ,p_msg_text => 'END');
2293:
2294: EXCEPTION
2295: WHEN e_register_table_error THEN
2296: FEM_ENGINES_PKG.Tech_Message(
2297: p_severity => g_log_level_5
2298: ,p_module => G_BLOCK||'.'||l_api_name
2299: ,p_msg_text => 'Register Table Exception');
2300:

Line 2301: FEM_ENGINES_PKG.User_Message (

2297: p_severity => g_log_level_5
2298: ,p_module => G_BLOCK||'.'||l_api_name
2299: ,p_msg_text => 'Register Table Exception');
2300:
2301: FEM_ENGINES_PKG.User_Message (
2302: p_app_name => G_PFT
2303: ,p_msg_name => G_PL_REG_TABLE_ERR
2304: ,p_token1 => 'TABLE_NAME'
2305: ,p_value1 => p_tbl_name);

Line 2310: FEM_ENGINES_PKG.User_Message (

2306:
2307: RAISE e_pc_engine_error;
2308:
2309: WHEN OTHERS THEN
2310: FEM_ENGINES_PKG.User_Message (
2311: p_app_name => G_PFT
2312: ,p_msg_name => G_PL_REG_TABLE_ERR
2313: ,p_token1 => 'TABLE_NAME'
2314: ,p_value1 => p_tbl_name);

Line 2347: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2343: e_reg_updated_column_error EXCEPTION;
2344:
2345: BEGIN
2346:
2347: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2348: ,p_module => G_BLOCK||'.'||l_api_name
2349: ,p_msg_text => 'BEGIN');
2350:
2351: -- Set the number of output rows for the output table.

Line 2373: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

2369: ,p_msg_data => l_msg_data);
2370: RAISE e_reg_updated_column_error;
2371: END IF;
2372:
2373: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
2374: ,p_module => G_BLOCK||'.'||l_api_name
2375: ,p_msg_text => 'END');
2376:
2377: EXCEPTION

Line 2379: FEM_ENGINES_PKG.Tech_Message (

2375: ,p_msg_text => 'END');
2376:
2377: EXCEPTION
2378: WHEN e_reg_updated_column_error THEN
2379: FEM_ENGINES_PKG.Tech_Message (
2380: p_severity => g_log_level_5
2381: ,p_module => G_BLOCK||'.'||l_api_name
2382: ,p_msg_text => 'Register_Updated_Column_Exception');
2383:

Line 2384: FEM_ENGINES_PKG.User_Message (

2380: p_severity => g_log_level_5
2381: ,p_module => G_BLOCK||'.'||l_api_name
2382: ,p_msg_text => 'Register_Updated_Column_Exception');
2383:
2384: FEM_ENGINES_PKG.User_Message (
2385: p_app_name => G_PFT
2386: ,p_msg_name => G_PL_REG_UPD_COL_ERR
2387: ,p_token1 => 'TABLE_NAME'
2388: ,p_value1 => p_table_name

Line 2395: FEM_ENGINES_PKG.Tech_Message (

2391:
2392: RAISE e_pc_engine_error;
2393:
2394: WHEN OTHERS THEN
2395: FEM_ENGINES_PKG.Tech_Message (
2396: p_severity => g_log_level_5
2397: ,p_module => G_BLOCK||'.'||l_api_name
2398: ,p_msg_text => 'Register_Updated_Column_Exception');
2399:

Line 2400: FEM_ENGINES_PKG.User_Message (

2396: p_severity => g_log_level_5
2397: ,p_module => G_BLOCK||'.'||l_api_name
2398: ,p_msg_text => 'Register_Updated_Column_Exception');
2399:
2400: FEM_ENGINES_PKG.User_Message (
2401: p_app_name => G_PFT
2402: ,p_msg_name => G_PL_REG_UPD_COL_ERR
2403: ,p_token1 => 'TABLE_NAME'
2404: ,p_value1 => p_table_name