eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PFT_PROFCAL_VALIDX_PUB dependencies on FEM_ENGINES_PKG

Line 297: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

293:
294: -- Initialize the return status to SUCCESS
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
298: ,p_module => G_BLOCK||'.'||l_api_name
299: ,p_msg_text => 'BEGIN');
300:
301: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);

Line 313: FEM_ENGINES_PKG.Tech_Message (

309: l_region_counting_flag := p_region_counting_flag ;
310: l_proft_percentile_flag := p_proft_percentile_flag;
311:
312: BEGIN
313: FEM_ENGINES_PKG.Tech_Message (
314: p_severity => g_log_level_2
315: ,p_module => G_BLOCK||'.'||l_api_name
316: ,p_msg_text => 'Value Index Formula ' || p_value_index_formula_id);
317:

Line 327: FEM_ENGINES_PKG.Tech_Message (

323:
324: IF l_measure_type = 0 THEN
325: l_region_exists := FALSE;
326:
327: FEM_ENGINES_PKG.Tech_Message (
328: p_severity => g_log_level_2
329: ,p_module => G_BLOCK||'.'||l_api_name
330: ,p_msg_text => 'Region Counting Formula does not Exist');
331:

Line 332: FEM_ENGINES_PKG.User_Message (

328: p_severity => g_log_level_2
329: ,p_module => G_BLOCK||'.'||l_api_name
330: ,p_msg_text => 'Region Counting Formula does not Exist');
331:
332: FEM_ENGINES_PKG.User_Message (
333: p_app_name => G_PFT
334: ,p_msg_name => G_ENG_RCNT_NO_FORMULA_ERR);
335: END IF;
336:

Line 356: FEM_ENGINES_PKG.Tech_Message (

352: IF l_measure_type = 0 THEN
353:
354: l_profit_exists := FALSE;
355:
356: FEM_ENGINES_PKG.Tech_Message (
357: p_severity => g_log_level_2
358: ,p_module => G_BLOCK||'.'||l_api_name
359: ,p_msg_text => 'Profit Percentile Formula does not Exist');
360:

Line 361: FEM_ENGINES_PKG.User_Message (

357: p_severity => g_log_level_2
358: ,p_module => G_BLOCK||'.'||l_api_name
359: ,p_msg_text => 'Profit Percentile Formula does not Exist');
360:
361: FEM_ENGINES_PKG.User_Message (
362: p_app_name => G_PFT
363: ,p_msg_name => G_ENG_PPTILE_NO_FORMULA_ERR);
364:
365: END IF;

Line 375: FEM_ENGINES_PKG.Tech_Message (

371: WHEN OTHERS THEN
372: RAISE;
373: END;
374:
375: FEM_ENGINES_PKG.Tech_Message (
376: p_severity => g_log_level_2
377: ,p_module => G_BLOCK||'.'||l_api_name
378: ,p_msg_text => 'Getting Global VS Combo ID');
379:

Line 386: FEM_ENGINES_PKG.Tech_Message (

382: ,x_err_code => l_err_code
383: ,x_num_msg => l_num_msg);
384:
385: IF(l_err_code <> 0)THEN
386: FEM_ENGINES_PKG.Tech_Message (
387: p_severity => g_log_level_2
388: ,p_module => G_BLOCK||'.'||l_api_name
389: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
390:

Line 391: FEM_ENGINES_PKG.User_Message (

387: p_severity => g_log_level_2
388: ,p_module => G_BLOCK||'.'||l_api_name
389: ,p_msg_text => 'No GVSC Id for the Given Ledger' || p_ledger_id);
390:
391: FEM_ENGINES_PKG.User_Message (
392: p_app_name => G_PFT
393: ,p_msg_name => G_ENG_INVALID_LEDGER_ERR
394: ,p_token1 => 'LEDGER_ID'
395: ,p_value1 => p_ledger_id);

Line 400: FEM_ENGINES_PKG.Tech_Message (

396:
397: RAISE e_process_single_rule_error;
398: END IF;
399:
400: FEM_ENGINES_PKG.Tech_Message (
401: p_severity => g_log_level_2
402: ,p_module => G_BLOCK||'.'||l_api_name
403: ,p_msg_text => 'Getting Customer Value Set Id');
404:

Line 415: FEM_ENGINES_PKG.Tech_Message (

411: AND dim.dimension_varchar_label = 'CUSTOMER'
412: AND gvsc.global_vs_combo_id = l_gvsc_id;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: FEM_ENGINES_PKG.Tech_Message (
416: p_severity => g_log_level_2
417: ,p_module => G_BLOCK||'.'||l_api_name
418: ,p_msg_text => 'No Value Set Id for the Given GVSC '|| l_gvsc_id);
419:

Line 420: FEM_ENGINES_PKG.User_Message (

416: p_severity => g_log_level_2
417: ,p_module => G_BLOCK||'.'||l_api_name
418: ,p_msg_text => 'No Value Set Id for the Given GVSC '|| l_gvsc_id);
419:
420: FEM_ENGINES_PKG.User_Message (
421: p_app_name => G_PFT
422: ,p_msg_name => G_ENG_INVALID_GVSC_ERR
423: ,p_token1 => 'GVSC_ID'
424: ,p_value1 => l_gvsc_id);

Line 441: FEM_ENGINES_PKG.Tech_Message (

437:
438: IF l_product_id = 0 THEN
439: l_product_exists := FALSE;
440:
441: FEM_ENGINES_PKG.Tech_Message (
442: p_severity => g_log_level_2
443: ,p_module => G_BLOCK||'.'||l_api_name
444: ,p_msg_text => 'Product Formula does not Exist');
445:

Line 446: --FEM_ENGINES_PKG.User_Message (

442: p_severity => g_log_level_2
443: ,p_module => G_BLOCK||'.'||l_api_name
444: ,p_msg_text => 'Product Formula does not Exist');
445:
446: --FEM_ENGINES_PKG.User_Message (
447: -- p_app_name => G_PFT
448: -- ,p_msg_name => 'Product Formula does not Exist');
449:
450: END IF;

Line 459: FEM_ENGINES_PKG.TECH_MESSAGE(

455: WHEN OTHERS THEN
456: RAISE;
457: END;
458:
459: FEM_ENGINES_PKG.TECH_MESSAGE(
460: p_severity => g_log_level_3
461: ,p_module => G_BLOCK||'.'||l_api_name
462: ,p_msg_text => 'Register update colmn:Value Index');
463:

Line 472: FEM_ENGINES_PKG.Tech_Message (

468: ,p_table_name => g_fem_customer_profit
469: ,p_statement_type => g_update
470: ,p_column_name => p_output_column);
471:
472: FEM_ENGINES_PKG.Tech_Message (
473: p_severity => g_log_level_2
474: ,p_module => G_BLOCK||'.'||l_api_name
475: ,p_msg_text => 'Get The Level for which the
476: Value Index has to be calculated');

Line 491: FEM_ENGINES_PKG.Tech_Message (

487: END;
488:
489: IF (p_cond_obj_id IS NOT NULL) THEN
490:
491: FEM_ENGINES_PKG.Tech_Message (
492: p_severity => g_log_level_3
493: ,p_module => G_BLOCK||'.'||l_api_name
494: ,p_msg_text => 'Generating the Condition where clause');
495:

Line 517: FEM_ENGINES_PKG.User_Message (

513: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
514: Get_Put_Messages ( p_msg_count => l_msg_count
515: ,p_msg_data => l_msg_data);
516:
517: FEM_ENGINES_PKG.User_Message (
518: p_app_name => G_PFT
519: ,p_msg_name => G_ENG_COND_PRED_CLAUSE_ERR
520: ,p_token1 => 'CONDITION_OBJ_ID'
521: ,p_value1 => p_cond_obj_id);

Line 524: FEM_ENGINES_PKG.User_Message (

520: ,p_token1 => 'CONDITION_OBJ_ID'
521: ,p_value1 => p_cond_obj_id);
522:
523: IF (l_condition_clause IS NULL) THEN
524: FEM_ENGINES_PKG.User_Message (
525: p_app_name => G_PFT
526: ,p_msg_name => G_ENG_COND_PRED_CLAUSE_ERR
527: ,p_token1 => 'CONDITION_OBJ_ID'
528: ,p_value1 => p_cond_obj_id);

Line 537: FEM_ENGINES_PKG.Tech_Message (

533: END IF;
534:
535: -------------------- Register the chain if required ---------------------
536: --Step :1: Set The l_Chaining_flag
537: FEM_ENGINES_PKG.Tech_Message (
538: p_severity => g_log_level_1
539: ,p_module => G_BLOCK||'.'||l_api_name
540: ,p_msg_text => 'Register Chain Step:1:
541: Identify whether chaining is needed ');

Line 567: FEM_ENGINES_PKG.Tech_Message (

563: --------------------------------------------------------------------------
564: --Step 2: If the l_chaining flag := TRUE call Register_Chain
565: --------------------------------------------------------------------------
566: IF (l_chaining_flag) THEN
567: FEM_ENGINES_PKG.Tech_Message (
568: p_severity => g_log_level_1
569: ,p_module => G_BLOCK||'.'||l_api_name
570: ,p_msg_text => 'Register Chain Step:2:Call PL_Chains:');
571:

Line 610: FEM_ENGINES_PKG.User_Message (

606: ,x_msg_data => l_msg_data
607: ,x_return_status => l_return_status);
608:
609: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
610: FEM_ENGINES_PKG.User_Message (
611: p_app_name => G_PFT
612: ,p_msg_name => G_PL_REG_CHAIN_ERR);
613:
614: RAISE e_process_single_rule_error;

Line 666: FEM_ENGINES_PKG.User_Message (

662: ,x_msg_data => l_msg_data
663: ,x_return_status => l_return_status);
664:
665: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
666: FEM_ENGINES_PKG.User_Message (
667: p_app_name => G_PFT
668: ,p_msg_name => G_PL_REG_CHAIN_ERR);
669:
670: RAISE e_process_single_rule_error;

Line 704: FEM_ENGINES_PKG.Tech_Message (

700:
701: -- When the given formula has Region Counting Formula defined
702: IF l_region_exists THEN
703:
704: FEM_ENGINES_PKG.Tech_Message (
705: p_severity => g_log_level_3
706: ,p_module => G_BLOCK||'.'||l_api_name
707: ,p_msg_text => 'Building Region Count Value Index SQL');
708:

Line 746: FEM_ENGINES_PKG.TECH_MESSAGE(

742: ELSE
743: l_reuse_slices := 'N';
744: END IF;
745:
746: FEM_ENGINES_PKG.TECH_MESSAGE(
747: p_severity => g_log_level_1
748: ,p_module => G_BLOCK ||'.' || l_api_name
749: ,p_msg_text => l_rgn_cnt_sql);
750:

Line 751: FEM_ENGINES_PKG.TECH_MESSAGE(

747: p_severity => g_log_level_1
748: ,p_module => G_BLOCK ||'.' || l_api_name
749: ,p_msg_text => l_rgn_cnt_sql);
750:
751: FEM_ENGINES_PKG.TECH_MESSAGE(
752: p_severity => g_log_level_3
753: ,p_module => G_BLOCK||'.'||l_api_name
754: ,p_msg_text => 'Registering step: VALUE_INDEX');
755:

Line 756: FEM_ENGINES_PKG.TECH_MESSAGE(

752: p_severity => g_log_level_3
753: ,p_module => G_BLOCK||'.'||l_api_name
754: ,p_msg_text => 'Registering step: VALUE_INDEX');
755:
756: FEM_ENGINES_PKG.TECH_MESSAGE(
757: p_severity => g_log_level_3
758: ,p_module => G_BLOCK||'.'||l_api_name
759: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
760: ||p_rule_obj_id);

Line 762: FEM_ENGINES_PKG.TECH_MESSAGE(

758: ,p_module => G_BLOCK||'.'||l_api_name
759: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
760: ||p_rule_obj_id);
761:
762: FEM_ENGINES_PKG.TECH_MESSAGE(
763: p_severity => g_log_level_3
764: ,p_module => G_BLOCK||'.'||l_api_name
765: ,p_msg_text => 'Submitting Region Count SQL to MP Master.p_eng_sql: '
766: ||l_rgn_cnt_sql);

Line 791: FEM_ENGINES_PKG.Tech_Message(

787: FROM fem_mp_process_ctl_t
788: WHERE req_id = l_request_id
789: AND status = 2;
790:
791: FEM_ENGINES_PKG.Tech_Message(
792: p_severity => g_log_level_1
793: ,p_module => G_BLOCK||'.'||l_api_name
794: ,p_msg_text => 'Total Errors : ' || TO_CHAR(v_msg_list.COUNT));
795:

Line 799: FEM_ENGINES_PKG.Tech_Message(

795:
796: -- Log all of the messages
797: FOR i IN 1..v_msg_list.COUNT LOOP
798:
799: FEM_ENGINES_PKG.Tech_Message(
800: p_severity => g_log_level_5
801: ,p_module => G_BLOCK||'.'||l_api_name
802: ,p_msg_text => v_msg_list(i));
803:

Line 809: FEM_ENGINES_PKG.User_Message (

805:
806:
807: END LOOP;
808:
809: FEM_ENGINES_PKG.User_Message (
810: p_app_name => G_PFT
811: ,p_msg_name => G_ENG_MULTI_PROC_ERR);
812:
813: Process_Obj_Exec_Step(

Line 847: FEM_ENGINES_PKG.Tech_Message (

843:
844: -- When the given formula has Profit Percentile formula defined
845: IF l_profit_exists THEN
846:
847: FEM_ENGINES_PKG.Tech_Message (
848: p_severity => g_log_level_3
849: ,p_module => G_BLOCK||'.'||l_api_name
850: ,p_msg_text => 'Building Profit Percentile Value Index SQL');
851:

Line 876: FEM_ENGINES_PKG.TECH_MESSAGE(

872: ELSE
873: l_reuse_slices := 'N';
874: END IF;
875:
876: FEM_ENGINES_PKG.TECH_MESSAGE(
877: p_severity => g_log_level_1
878: ,p_module => G_BLOCK ||'.' || l_api_name
879: ,p_msg_text => l_prof_ptile_sql);
880:

Line 881: FEM_ENGINES_PKG.TECH_MESSAGE(

877: p_severity => g_log_level_1
878: ,p_module => G_BLOCK ||'.' || l_api_name
879: ,p_msg_text => l_prof_ptile_sql);
880:
881: FEM_ENGINES_PKG.TECH_MESSAGE(
882: p_severity => g_log_level_3
883: ,p_module => G_BLOCK||'.'||l_api_name
884: ,p_msg_text => 'Registering step: VALUE_INDEX');
885:

Line 886: FEM_ENGINES_PKG.TECH_MESSAGE(

882: p_severity => g_log_level_3
883: ,p_module => G_BLOCK||'.'||l_api_name
884: ,p_msg_text => 'Registering step: VALUE_INDEX');
885:
886: FEM_ENGINES_PKG.TECH_MESSAGE(
887: p_severity => g_log_level_3
888: ,p_module => G_BLOCK||'.'||l_api_name
889: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
890: ||p_rule_obj_id);

Line 892: FEM_ENGINES_PKG.TECH_MESSAGE(

888: ,p_module => G_BLOCK||'.'||l_api_name
889: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
890: ||p_rule_obj_id);
891:
892: FEM_ENGINES_PKG.TECH_MESSAGE(
893: p_severity => g_log_level_3
894: ,p_module => G_BLOCK||'.'||l_api_name
895: ,p_msg_text => 'Submitting Percentile SQL to MP Master.p_eng_sql: '
896: ||l_prof_ptile_sql);

Line 921: FEM_ENGINES_PKG.Tech_Message(

917: FROM fem_mp_process_ctl_t
918: WHERE req_id = l_request_id
919: AND status = 2;
920:
921: FEM_ENGINES_PKG.Tech_Message(
922: p_severity => g_log_level_1
923: ,p_module => G_BLOCK||'.'||l_api_name
924: ,p_msg_text => 'Total Errors : ' || TO_CHAR(v_msg_list.COUNT));
925:

Line 929: FEM_ENGINES_PKG.Tech_Message(

925:
926: -- Log all of the messages
927: FOR i IN 1..v_msg_list.COUNT LOOP
928:
929: FEM_ENGINES_PKG.Tech_Message(
930: p_severity => g_log_level_5
931: ,p_module => G_BLOCK||'.'||l_api_name
932: ,p_msg_text => v_msg_list(i));
933:

Line 938: FEM_ENGINES_PKG.User_Message (

934: FND_FILE.Put_Line(FND_FILE.log, v_msg_list(i));
935:
936: END LOOP;
937:
938: FEM_ENGINES_PKG.User_Message (
939: p_app_name => G_PFT
940: ,p_msg_name => G_ENG_MULTI_PROC_ERR);
941:
942: Process_Obj_Exec_Step(

Line 978: FEM_ENGINES_PKG.Tech_Message (

974:
975: -- When the given formula has Product formula defined
976: IF l_product_exists THEN
977:
978: FEM_ENGINES_PKG.Tech_Message (
979: p_severity => g_log_level_3
980: ,p_module => G_BLOCK||'.'||l_api_name
981: ,p_msg_text => 'Building Product attribute Value Index SQL');
982:

Line 1021: FEM_ENGINES_PKG.TECH_MESSAGE(

1017: ELSE
1018: l_reuse_slices := 'N';
1019: END IF;
1020:
1021: FEM_ENGINES_PKG.TECH_MESSAGE(
1022: p_severity => g_log_level_1
1023: ,p_module => G_BLOCK ||'.' || l_api_name
1024: ,p_msg_text => l_prod_cd_sql);
1025:

Line 1026: FEM_ENGINES_PKG.Tech_Message(

1022: p_severity => g_log_level_1
1023: ,p_module => G_BLOCK ||'.' || l_api_name
1024: ,p_msg_text => l_prod_cd_sql);
1025:
1026: FEM_ENGINES_PKG.Tech_Message(
1027: p_severity => g_log_level_3
1028: ,p_module => G_BLOCK||'.'||l_api_name
1029: ,p_msg_text => 'Registering step: VALUE_INDEX');
1030:

Line 1031: FEM_ENGINES_PKG.Tech_Message(

1027: p_severity => g_log_level_3
1028: ,p_module => G_BLOCK||'.'||l_api_name
1029: ,p_msg_text => 'Registering step: VALUE_INDEX');
1030:
1031: FEM_ENGINES_PKG.Tech_Message(
1032: p_severity => g_log_level_3
1033: ,p_module => G_BLOCK||'.'||l_api_name
1034: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
1035: ||p_rule_obj_id);

Line 1037: FEM_ENGINES_PKG.Tech_Message(

1033: ,p_module => G_BLOCK||'.'||l_api_name
1034: ,p_msg_text => 'Submitting to MP Master.p_rule_id: '
1035: ||p_rule_obj_id);
1036:
1037: FEM_ENGINES_PKG.Tech_Message(
1038: p_severity => g_log_level_3
1039: ,p_module => G_BLOCK||'.'||l_api_name
1040: ,p_msg_text => 'Submitting Region Count SQL to MP Master.p_eng_sql: '
1041: ||l_prod_cd_sql);

Line 1066: FEM_ENGINES_PKG.Tech_Message(

1062: FROM fem_mp_process_ctl_t
1063: WHERE req_id = l_request_id
1064: AND status = 2;
1065:
1066: FEM_ENGINES_PKG.Tech_Message(
1067: p_severity => g_log_level_1
1068: ,p_module => G_BLOCK||'.'||l_api_name
1069: ,p_msg_text => 'Total Errors : ' || TO_CHAR(v_msg_list.COUNT));
1070:

Line 1074: FEM_ENGINES_PKG.Tech_Message(

1070:
1071: -- Log all of the messages
1072: FOR i IN 1..v_msg_list.COUNT LOOP
1073:
1074: FEM_ENGINES_PKG.Tech_Message(
1075: p_severity => g_log_level_5
1076: ,p_module => G_BLOCK||'.'||l_api_name
1077: ,p_msg_text => v_msg_list(i));
1078:

Line 1083: FEM_ENGINES_PKG.User_Message (

1079: FND_FILE.Put_Line(FND_FILE.log, v_msg_list(i));
1080:
1081: END LOOP;
1082:
1083: FEM_ENGINES_PKG.User_Message (
1084: p_app_name => G_PFT
1085: ,p_msg_name => G_ENG_MULTI_PROC_ERR);
1086:
1087: Process_Obj_Exec_Step(

Line 1119: FEM_ENGINES_PKG.User_Message (

1115: END IF;
1116: END IF;
1117:
1118: IF g_num_rows = 0 THEN
1119: FEM_ENGINES_PKG.User_Message (
1120: p_app_name => G_PFT
1121: ,p_msg_name => G_ENG_NO_OP_ROWS_ERR);
1122: END IF;
1123:

Line 1124: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

1120: p_app_name => G_PFT
1121: ,p_msg_name => G_ENG_NO_OP_ROWS_ERR);
1122: END IF;
1123:
1124: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
1125: ,p_module => G_BLOCK||'.'||l_api_name
1126: ,p_msg_text => 'END');
1127:
1128: EXCEPTION

Line 1135: FEM_ENGINES_PKG.Tech_Message (

1131: IF l_cv_chains%ISOPEN THEN
1132: CLOSE l_cv_chains;
1133: END IF;
1134:
1135: FEM_ENGINES_PKG.Tech_Message (
1136: p_severity => g_log_level_5
1137: ,p_module => G_BLOCK||'.'||l_api_name
1138: ,p_msg_text => 'Generate Value Index Error:
1139: Process Single Rule Exception');

Line 1141: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

1137: ,p_module => G_BLOCK||'.'||l_api_name
1138: ,p_msg_text => 'Generate Value Index Error:
1139: Process Single Rule Exception');
1140:
1141: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
1142: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
1143:
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145:

Line 1152: FEM_ENGINES_PKG.Tech_Message (

1148: IF l_cv_chains%ISOPEN THEN
1149: CLOSE l_cv_chains;
1150: END IF;
1151:
1152: FEM_ENGINES_PKG.Tech_Message (
1153: p_severity => g_log_level_5
1154: ,p_module => G_BLOCK||'.'||l_api_name
1155: ,p_msg_text => 'Generate Value Index Error:
1156: Process Single Rule Exception');

Line 1158: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

1154: ,p_module => G_BLOCK||'.'||l_api_name
1155: ,p_msg_text => 'Generate Value Index Error:
1156: Process Single Rule Exception');
1157:
1158: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
1159: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
1160:
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162:

Line 1195: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1191: e_upd_num_output_rows_error EXCEPTION;
1192:
1193: BEGIN
1194:
1195: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1196: ,p_module => G_BLOCK||'.'||l_api_name
1197: ,p_msg_text => 'BEGIN');
1198:
1199: -- Set the number of output rows for the output table.

Line 1221: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

1217: ,p_msg_data => l_msg_data);
1218: RAISE e_upd_num_output_rows_error;
1219: END IF;
1220:
1221: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
1222: ,p_module => G_BLOCK||'.'||l_api_name
1223: ,p_msg_text => 'END');
1224:
1225: EXCEPTION

Line 1227: FEM_ENGINES_PKG.Tech_Message (

1223: ,p_msg_text => 'END');
1224:
1225: EXCEPTION
1226: WHEN e_upd_num_output_rows_error THEN
1227: FEM_ENGINES_PKG.Tech_Message (
1228: p_severity => g_log_level_5
1229: ,p_module => G_BLOCK||'.'||l_api_name
1230: ,p_msg_text => 'Update Rows Exception');
1231:

Line 1232: FEM_ENGINES_PKG.User_Message (

1228: p_severity => g_log_level_5
1229: ,p_module => G_BLOCK||'.'||l_api_name
1230: ,p_msg_text => 'Update Rows Exception');
1231:
1232: FEM_ENGINES_PKG.User_Message (
1233: p_app_name => G_PFT
1234: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
1235:
1236: RAISE e_process_single_rule_error;

Line 1239: FEM_ENGINES_PKG.User_Message (

1235:
1236: RAISE e_process_single_rule_error;
1237:
1238: WHEN OTHERS THEN
1239: FEM_ENGINES_PKG.User_Message (
1240: p_app_name => G_PFT
1241: ,p_msg_name => G_PL_OP_UPD_ROWS_ERR);
1242:
1243: RAISE;

Line 1276: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1272: e_upd_obj_exec_step_stat_error EXCEPTION;
1273:
1274: BEGIN
1275:
1276: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1277: ,p_module => G_BLOCK||'.'||l_api_name
1278: ,p_msg_text => 'BEGIN');
1279:
1280: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure

Line 1302: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1298: RAISE e_upd_obj_exec_step_stat_error;
1299:
1300: END IF;
1301:
1302: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1303: ,p_module => G_BLOCK||'.'||l_api_name
1304: ,p_msg_text => 'END');
1305:
1306: EXCEPTION

Line 1308: FEM_ENGINES_PKG.Tech_Message (

1304: ,p_msg_text => 'END');
1305:
1306: EXCEPTION
1307: WHEN e_upd_obj_exec_step_stat_error THEN
1308: FEM_ENGINES_PKG.Tech_Message (
1309: p_severity => g_log_level_5
1310: ,p_module => G_BLOCK||'.'||l_api_name
1311: ,p_msg_text => 'Update Obj Exec Step API Exception');
1312:

Line 1313: FEM_ENGINES_PKG.User_Message (

1309: p_severity => g_log_level_5
1310: ,p_module => G_BLOCK||'.'||l_api_name
1311: ,p_msg_text => 'Update Obj Exec Step API Exception');
1312:
1313: FEM_ENGINES_PKG.User_Message (
1314: p_app_name => G_PFT
1315: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
1316: ,p_token1 => 'OBJECT_ID'
1317: ,p_value1 => p_rule_obj_id);

Line 1322: FEM_ENGINES_PKG.User_Message (

1318:
1319: RAISE e_process_single_rule_error;
1320:
1321: WHEN OTHERS THEN
1322: FEM_ENGINES_PKG.User_Message (
1323: p_app_name => G_PFT
1324: ,p_msg_name => G_PL_UPD_EXEC_STEP_ERR
1325: ,p_token1 => 'OBJECT_ID'
1326: ,p_value1 => p_rule_obj_id);

Line 1352: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1348: l_api_name CONSTANT VARCHAR2(30) := 'Get_Nbr_RowsTable_Request';
1349:
1350: BEGIN
1351:
1352: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1353: ,p_module => G_BLOCK||'.'||l_api_name
1354: ,p_msg_text => 'BEGIN');
1355:
1356: --Query the fem_mp_process_ctl_t table to get the number of rows

Line 1370: FEM_ENGINES_PKG.Tech_Message (

1366: AND t.process_num > 0;
1367:
1368:
1369: IF (x_rows_processed = 0) THEN
1370: FEM_ENGINES_PKG.Tech_Message (
1371: p_severity => g_log_level_5
1372: ,p_module => G_BLOCK||'.'||l_api_name
1373: ,p_msg_text => 'No Rows returned by the Insert Statement');
1374:

Line 1383: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

1379: ELSE
1380: g_num_rows := x_rows_processed;
1381: END IF;
1382:
1383: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
1384: ,p_module => G_BLOCK||'.'||l_api_name
1385: ,p_msg_text => 'END');
1386:
1387: EXCEPTION

Line 1421: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2

1417: l_api_name := 'Process_Obj_Exec_Step';
1418: l_nbr_output_rows := NULL;
1419: l_nbr_input_rows := NULL;
1420:
1421: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2
1422: ,p_module => G_BLOCK||'.'||l_api_name
1423: ,p_msg_text => 'BEGIN');
1424:
1425: ------------------------------------------------------------------------

Line 1429: FEM_ENGINES_PKG.Tech_Message(

1425: ------------------------------------------------------------------------
1426: --Update the status of the step
1427: ------------------------------------------------------------------------
1428:
1429: FEM_ENGINES_PKG.Tech_Message(
1430: p_severity => g_log_level_3
1431: ,p_module => G_BLOCK||'.'||l_api_name
1432: ,p_msg_text => 'Update the status of the step with execution status :'
1433: ||p_exe_status_code);

Line 1449: FEM_ENGINES_PKG.Tech_Message(

1445: x_rows_loaded => l_nbr_loaded_rows,
1446: x_rows_rejected => l_nbr_rejected_rows,
1447: p_request_id => p_request_id);
1448:
1449: FEM_ENGINES_PKG.Tech_Message(
1450: p_severity => g_log_level_3
1451: ,p_module => G_BLOCK||'.'||l_api_name
1452: ,p_msg_text => 'Rows processed for registered output table :'
1453: ||p_tbl_name);

Line 1467: FEM_ENGINES_PKG.TECH_MESSAGE(

1463:
1464: -----------------------------------------------------------------------
1465: -- Call FEM_PL_PKG.update_num_of_input_rows();
1466: -----------------------------------------------------------------------
1467: FEM_ENGINES_PKG.TECH_MESSAGE(
1468: p_severity => g_log_level_1,
1469: p_module => G_BLOCK||'.'||l_api_name,
1470: p_msg_text => 'No:of Rows processed from input table'
1471: ||l_nbr_loaded_rows );

Line 1481: FEM_ENGINES_PKG.User_Message(

1477: ,p_rule_obj_id => p_rule_obj_id
1478: ,p_num_of_input_rows => l_nbr_output_rows);
1479:
1480: IF l_nbr_output_rows > 0 THEN
1481: FEM_ENGINES_PKG.User_Message(
1482: p_app_name => G_PFT,
1483: p_msg_name => 'PFT_PPROF_VIDX_ROW_SUMMARY',
1484: p_token1 => 'ROWSP',
1485: p_value1 => l_nbr_output_rows,

Line 1492: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2

1488: END IF;
1489:
1490: END IF;
1491:
1492: FEM_ENGINES_PKG.TECH_MESSAGE( p_severity => g_log_level_2
1493: ,p_module => G_BLOCK||'.'||l_api_name
1494: ,p_msg_text => 'END');
1495:
1496: EXCEPTION

Line 1548: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1544: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1545:
1546:
1547:
1548: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1549: ,p_module => G_BLOCK||'.'||l_api_name
1550: ,p_msg_text => 'BEGIN');
1551:
1552: l_update_stmt := ' UPDATE fem_customer_profit fcp' ||

Line 1617: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

1613:
1614: -- add mapped columns
1615: RETURN l_update_stmt || ' ' || l_select_stmt || ' ' || l_where_stmt;
1616:
1617: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
1618: ,p_module => G_BLOCK||'.'||l_api_name
1619: ,p_msg_text => 'END');
1620:
1621: EXCEPTION

Line 1670: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1666: l_request_id := FND_GLOBAL.Conc_Request_Id;
1667: l_user_id := FND_GLOBAL.user_Id;
1668: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1669:
1670: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1671: ,p_module => G_BLOCK||'.'||l_api_name
1672: ,p_msg_text => 'BEGIN');
1673:
1674: l_update_stmt := ' UPDATE fem_customer_profit fcp' ||

Line 1720: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

1716:
1717: -- add mapped columns
1718: RETURN l_update_stmt || ' ' || l_select_stmt || ' ' || l_where_stmt;
1719:
1720: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
1721: ,p_module => G_BLOCK||'.'||l_api_name
1722: ,p_msg_text => 'END');
1723:
1724: EXCEPTION

Line 1774: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1770: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1771:
1772:
1773:
1774: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1775: ,p_module => G_BLOCK||'.'||l_api_name
1776: ,p_msg_text => 'BEGIN');
1777:
1778: l_update_stmt := ' UPDATE fem_customer_profit fcp' ||

Line 1826: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2

1822:
1823: -- add mapped columns
1824: RETURN l_update_stmt || ' ' || l_select_stmt || ' ' || l_where_stmt;
1825:
1826: FEM_ENGINES_PKG.Tech_Message ( p_severity => G_LOG_LEVEL_2
1827: ,p_module => G_BLOCK||'.'||l_api_name
1828: ,p_msg_text => 'END');
1829:
1830: EXCEPTION

Line 1859: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1855: l_message VARCHAR2(4000);
1856:
1857: BEGIN
1858:
1859: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1860: ,p_module => G_BLOCK||'.'||l_api_name
1861: ,p_msg_text => 'msg_count='||p_msg_count);
1862:
1863: l_msg_data := p_msg_data;

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

1866:
1867: FND_MESSAGE.Set_Encoded(l_msg_data);
1868: l_message := FND_MESSAGE.Get;
1869:
1870: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1871:
1872: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1873: ,p_module => G_BLOCK||'.'||l_api_name
1874: ,p_msg_text => 'msg_data='||l_message);

Line 1872: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1868: l_message := FND_MESSAGE.Get;
1869:
1870: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1871:
1872: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1873: ,p_module => G_BLOCK||'.'||l_api_name
1874: ,p_msg_text => 'msg_data='||l_message);
1875:
1876: ELSIF (p_msg_count > 1) THEN

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

1880: ,p_encoded => FND_API.G_FALSE
1881: ,p_data => l_message
1882: ,p_msg_index_out => l_msg_out);
1883:
1884: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1885:
1886: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1887: ,p_module => G_BLOCK||'.'||l_api_name
1888: ,p_msg_text => 'msg_data = '||l_message);

Line 1886: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1882: ,p_msg_index_out => l_msg_out);
1883:
1884: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );
1885:
1886: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1887: ,p_module => G_BLOCK||'.'||l_api_name
1888: ,p_msg_text => 'msg_data = '||l_message);
1889:
1890: END LOOP;

Line 1926: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

1922:
1923: e_reg_updated_column_error EXCEPTION;
1924:
1925: BEGIN
1926: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1927: ,p_module => G_BLOCK||'.'||l_api_name
1928: ,p_msg_text => 'BEGIN');
1929:
1930: -- Set the number of output rows for the output table.

Line 1952: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

1948: ,p_msg_data => l_msg_data);
1949: RAISE e_reg_updated_column_error;
1950: END IF;
1951:
1952: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
1953: ,p_module => G_BLOCK||'.'||l_api_name
1954: ,p_msg_text => 'END');
1955:
1956: EXCEPTION

Line 1958: FEM_ENGINES_PKG.Tech_Message (

1954: ,p_msg_text => 'END');
1955:
1956: EXCEPTION
1957: WHEN e_reg_updated_column_error THEN
1958: FEM_ENGINES_PKG.Tech_Message (
1959: p_severity => g_log_level_5
1960: ,p_module => G_BLOCK||'.'||l_api_name
1961: ,p_msg_text => 'Register_Updated_Column_Exception');
1962:

Line 1963: FEM_ENGINES_PKG.User_Message (

1959: p_severity => g_log_level_5
1960: ,p_module => G_BLOCK||'.'||l_api_name
1961: ,p_msg_text => 'Register_Updated_Column_Exception');
1962:
1963: FEM_ENGINES_PKG.User_Message (
1964: p_app_name => G_PFT
1965: ,p_msg_name => G_PL_REG_UPD_COL_ERR
1966: ,p_token1 => 'TABLE_NAME'
1967: ,p_value1 => p_table_name

Line 1974: FEM_ENGINES_PKG.Tech_Message (

1970:
1971: RAISE e_process_single_rule_error;
1972:
1973: WHEN OTHERS THEN
1974: FEM_ENGINES_PKG.Tech_Message (
1975: p_severity => g_log_level_5
1976: ,p_module => G_BLOCK||'.'||l_api_name
1977: ,p_msg_text => 'Register_Updated_Column_Exception');
1978:

Line 1979: FEM_ENGINES_PKG.User_Message (

1975: p_severity => g_log_level_5
1976: ,p_module => G_BLOCK||'.'||l_api_name
1977: ,p_msg_text => 'Register_Updated_Column_Exception');
1978:
1979: FEM_ENGINES_PKG.User_Message (
1980: p_app_name => G_PFT
1981: ,p_msg_name => G_PL_REG_UPD_COL_ERR
1982: ,p_token1 => 'TABLE_NAME'
1983: ,p_value1 => p_table_name

Line 2020: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

2016: e_upd_num_input_rows_error EXCEPTION;
2017:
2018: BEGIN
2019:
2020: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
2021: ,p_module => G_BLOCK||'.'||l_api_name
2022: ,p_msg_text => 'BEGIN');
2023:
2024: -- Set the number of output rows for the output table.

Line 2044: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2

2040: ,p_msg_data => l_msg_data);
2041: RAISE e_upd_num_input_rows_error;
2042: END IF;
2043:
2044: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
2045: ,p_module => G_BLOCK||'.'||l_api_name
2046: ,p_msg_text => 'END');
2047:
2048: EXCEPTION

Line 2050: FEM_ENGINES_PKG.Tech_Message (

2046: ,p_msg_text => 'END');
2047:
2048: EXCEPTION
2049: WHEN e_upd_num_input_rows_error THEN
2050: FEM_ENGINES_PKG.Tech_Message (
2051: p_severity => g_log_level_5
2052: ,p_module => G_BLOCK||'.'||l_api_name
2053: ,p_msg_text => 'Update Input Rows Exception');
2054:

Line 2055: FEM_ENGINES_PKG.User_Message (

2051: p_severity => g_log_level_5
2052: ,p_module => G_BLOCK||'.'||l_api_name
2053: ,p_msg_text => 'Update Input Rows Exception');
2054:
2055: FEM_ENGINES_PKG.User_Message (
2056: p_app_name => G_PFT
2057: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2058:
2059: RAISE e_process_single_rule_error;

Line 2062: FEM_ENGINES_PKG.Tech_Message (

2058:
2059: RAISE e_process_single_rule_error;
2060:
2061: WHEN OTHERS THEN
2062: FEM_ENGINES_PKG.Tech_Message (
2063: p_severity => g_log_level_5
2064: ,p_module => G_BLOCK||'.'||l_api_name
2065: ,p_msg_text => 'Update Input Rows Exception');
2066:

Line 2067: FEM_ENGINES_PKG.User_Message (

2063: p_severity => g_log_level_5
2064: ,p_module => G_BLOCK||'.'||l_api_name
2065: ,p_msg_text => 'Update Input Rows Exception');
2066:
2067: FEM_ENGINES_PKG.User_Message (
2068: p_app_name => G_PFT
2069: ,p_msg_name => G_PL_IP_UPD_ROWS_ERR);
2070:
2071: RAISE e_process_single_rule_error;