DBA Data[Home] [Help]

APPS.FEM_INTG_CAL_RULE_ENG_PKG dependencies on FEM_ENGINES_PKG

Line 134: FEM_ENGINES_PKG.Tech_Message(

130: v_gap_found VARCHAR2(1) := 'N';
131:
132: BEGIN
133:
134: FEM_ENGINES_PKG.Tech_Message(
135: p_severity => pc_log_level_procedure,
136: p_module => pc_module_name || 'init.begin',
137: p_app_name => 'FEM',
138: p_msg_name => 'FEM_GL_POST_201',

Line 231: FEM_ENGINES_PKG.Tech_Message(

227:
228: pv_effective_start_date := pc_effective_start_date;
229: pv_effective_end_date := pc_effective_end_date;
230:
231: FEM_ENGINES_PKG.Tech_Message(
232: p_severity => pc_log_level_error,
233: p_module => pc_module_name || 'init.invalid_dt_fmt',
234: p_app_name => 'FEM',
235: p_msg_name => 'FEM_INTG_CAL_INVALID_DT_FMT'

Line 237: FEM_ENGINES_PKG.User_Message(

233: p_module => pc_module_name || 'init.invalid_dt_fmt',
234: p_app_name => 'FEM',
235: p_msg_name => 'FEM_INTG_CAL_INVALID_DT_FMT'
236: );
237: FEM_ENGINES_PKG.User_Message(
238: p_app_name => 'FEM',
239: p_msg_name => 'FEM_INTG_CAL_INVALID_DT_FMT'
240: );
241: END;

Line 251: FEM_ENGINES_PKG.Tech_Message(

247: p_period_set_name IS NULL OR
248: p_period_type IS NULL OR
249: p_period_year IS NULL THEN
250:
251: FEM_ENGINES_PKG.Tech_Message(
252: p_severity => pc_log_level_error,
253: p_module => pc_module_name || 'init.cal_para_not_found',
254: p_app_name => 'FEM',
255: p_msg_name => 'FEM_INTG_CAL_PARA_MISSING'

Line 258: FEM_ENGINES_PKG.User_Message(

254: p_app_name => 'FEM',
255: p_msg_name => 'FEM_INTG_CAL_PARA_MISSING'
256: );
257:
258: FEM_ENGINES_PKG.User_Message(
259: p_app_name => 'FEM',
260: p_msg_name => 'FEM_INTG_CAL_PARA_MISSING'
261: );
262:

Line 320: FEM_ENGINES_PKG.Tech_Message(

316: AND P.PERIOD_YEAR = pv_period_year;
317:
318: IF v_ogl_number_per_fiscal_year <> pv_ogl_number_per_fiscal_year THEN
319:
320: FEM_ENGINES_PKG.Tech_Message(
321: p_severity => pc_log_level_error,
322: p_module => pc_module_name || 'init.no_new_periods',
323: p_app_name => 'FEM',
324: p_msg_name => 'FEM_INTG_CAL_INVALID_NUM_PER_Y',

Line 329: FEM_ENGINES_PKG.User_Message(

325: p_token1 => 'FISCAL_YEAR',
326: p_value1 => pv_period_year
327: );
328:
329: FEM_ENGINES_PKG.User_Message(
330: p_app_name => 'FEM',
331: p_msg_name => 'FEM_INTG_CAL_INVALID_NUM_PER_Y',
332: p_token1 => 'FISCAL_YEAR',
333: p_value1 => pv_period_year

Line 476: FEM_ENGINES_PKG.Tech_Message(

472: END IF;
473: END IF;
474:
475: IF v_gap_found = 'Y' THEN
476: FEM_ENGINES_PKG.Tech_Message(
477: p_severity => pc_log_level_error,
478: p_module => pc_module_name || 'init.period_gap_found',
479: p_app_name => 'FEM',
480: p_msg_name => 'FEM_INTG_CAL_PERIOD_GAP_FOUND',

Line 489: FEM_ENGINES_PKG.User_Message(

485: p_token3 => 'PERIOD_TYPE',
486: p_value3 => pv_period_type_name
487: );
488:
489: FEM_ENGINES_PKG.User_Message(
490: p_app_name => 'FEM',
491: p_msg_name => 'FEM_INTG_CAL_PERIOD_GAP_FOUND',
492: p_token1 => 'FISCAL_YEAR',
493: p_value1 => pv_period_year,

Line 518: FEM_ENGINES_PKG.Tech_Message(

514: ELSE
515:
516: pv_new_periods_to_process := 'N';
517:
518: FEM_ENGINES_PKG.Tech_Message(
519: p_severity => pc_log_level_error,
520: p_module => pc_module_name || 'init.no_new_periods',
521: p_app_name => 'FEM',
522: p_msg_name => 'FEM_INTG_CAL_NO_NEW_PERIODS'

Line 525: FEM_ENGINES_PKG.User_Message(

521: p_app_name => 'FEM',
522: p_msg_name => 'FEM_INTG_CAL_NO_NEW_PERIODS'
523: );
524:
525: FEM_ENGINES_PKG.User_Message(
526: p_app_name => 'FEM',
527: p_msg_name => 'FEM_INTG_CAL_NO_NEW_PERIODS'
528: );
529: END IF;

Line 598: FEM_ENGINES_PKG.Tech_Message(

594: NVL(v_calendar_id, -1) <> NVL(pv_calendar_id, -1) OR
595: NVL(v_dimension_grp_id_period,-1)<>NVL(pv_dimension_grp_id_period,-1) OR
596: NVL(v_cal_per_hier_obj_id, -1) <> NVL(pv_cal_per_hier_obj_id, -1)) THEN
597:
598: FEM_ENGINES_PKG.Tech_Message(
599: p_severity => pc_log_level_error,
600: p_module => pc_module_name || 'init.invalid_cal_map',
601: p_app_name => 'FEM',
602: p_msg_name => 'FEM_INTG_CAL_INVALID_CAL_MAP',

Line 609: FEM_ENGINES_PKG.User_Message(

605: p_token2 => 'PERIOD_TYPE',
606: p_value2 => pv_period_type_name
607: );
608:
609: FEM_ENGINES_PKG.User_Message(
610: p_app_name => 'FEM',
611: p_msg_name => 'FEM_INTG_CAL_INVALID_CAL_MAP',
612: p_token1 => 'PERIOD_SET_NAME',
613: p_value1 => pv_period_set_name,

Line 672: FEM_ENGINES_PKG.Tech_Message(

668: WHERE SOURCE_SYSTEM_DISPLAY_CODE = 'OGL';
669:
670: pv_row_count_tot := 0;
671:
672: FEM_ENGINES_PKG.Tech_Message(
673: p_severity => pc_log_level_procedure,
674: p_module => pc_module_name || 'init.end',
675: p_app_name => 'FEM',
676: p_msg_name => 'FEM_GL_POST_202',

Line 687: FEM_ENGINES_PKG.Tech_Message(

683: EXCEPTION
684: WHEN FEM_INTG_fatal_err THEN
685: ROLLBACK;
686:
687: FEM_ENGINES_PKG.Tech_Message(
688: p_severity => pc_log_level_exception,
689: p_module => pc_module_name || 'init.exception_fatal_err',
690: p_app_name => 'FEM',
691: p_msg_name => 'FEM_GL_POST_203',

Line 703: FEM_ENGINES_PKG.Tech_Message(

699:
700: WHEN OTHERS THEN
701: ROLLBACK;
702:
703: FEM_ENGINES_PKG.Tech_Message(
704: p_severity => pc_log_level_exception,
705: p_module => pc_module_name || 'init.exception_others' ,
706: p_app_name => 'FEM',
707: p_msg_name => 'FEM_GL_POST_215',

Line 712: FEM_ENGINES_PKG.User_Message(

708: p_token1 => 'ERR_MSG',
709: p_value1 => SQLERRM
710: );
711:
712: FEM_ENGINES_PKG.User_Message(
713: p_app_name => 'FEM',
714: p_msg_name => 'FEM_GL_POST_215',
715: p_token1 => 'ERR_MSG',
716: p_value1 => SQLERRM

Line 719: FEM_ENGINES_PKG.Tech_Message(

715: p_token1 => 'ERR_MSG',
716: p_value1 => SQLERRM
717: );
718:
719: FEM_ENGINES_PKG.Tech_Message(
720: p_severity => pc_log_level_exception,
721: p_module => pc_module_name || 'init.exception_others',
722: p_app_name => 'FEM',
723: p_msg_name => 'FEM_GL_POST_203',

Line 754: FEM_ENGINES_PKG.Tech_Message(

750: v_msg_count NUMBER;
751: v_msg_data VARCHAR2(2000);
752: BEGIN
753:
754: FEM_ENGINES_PKG.Tech_Message(
755: p_severity => pc_log_level_procedure,
756: p_module => pc_module_name || 'new_calendar.begin',
757: p_app_name => 'FEM',
758: p_msg_name => 'FEM_GL_POST_201',

Line 792: FEM_ENGINES_PKG.Tech_Message(

788: p_msg_index => i,
789: p_encoded => 'F'
790: );
791:
792: FEM_ENGINES_PKG.Tech_Message(
793: p_severity => pc_log_level_error,
794: p_module => pc_module_name || 'new_calendar_error',
795: p_app_name => 'FEM',
796: p_msg_text => v_msg_data

Line 800: FEM_ENGINES_PKG.Tech_Message(

796: p_msg_text => v_msg_data
797: );
798: END LOOP;
799:
800: FEM_ENGINES_PKG.Tech_Message(
801: p_severity => pc_log_level_error,
802: p_module => pc_module_name || 'new_calendar_error',
803: p_app_name => 'FEM',
804: p_msg_name => 'FEM_INTG_CAL_NEW_CAL_ERROR',

Line 809: FEM_ENGINES_PKG.User_Message(

805: p_token1 => 'CALENDAR_DIMENSION',
806: p_value1 => pv_period_set_name
807: );
808:
809: FEM_ENGINES_PKG.User_Message(
810: p_app_name => 'FEM',
811: p_msg_name => 'FEM_INTG_CAL_NEW_CAL_ERROR',
812: p_token1 => 'CALENDAR_DIMENSION',
813: p_value1 => pv_period_set_name

Line 820: FEM_ENGINES_PKG.Tech_Message(

816: RAISE FEM_INTG_fatal_err;
817:
818: END IF;
819:
820: FEM_ENGINES_PKG.Tech_Message(
821: p_severity => pc_log_level_procedure,
822: p_module => pc_module_name || 'new_calendar.end',
823: p_app_name => 'FEM',
824: p_msg_name => 'FEM_GL_POST_202',

Line 835: FEM_ENGINES_PKG.Tech_Message(

831: EXCEPTION
832: WHEN FEM_INTG_fatal_err THEN
833: ROLLBACK;
834:
835: FEM_ENGINES_PKG.Tech_Message(
836: p_severity => pc_log_level_exception,
837: p_module => pc_module_name || 'new_calendar.exception_fatal_err',
838: p_app_name => 'FEM',
839: p_msg_name => 'FEM_GL_POST_203',

Line 851: FEM_ENGINES_PKG.Tech_Message(

847:
848: WHEN OTHERS THEN
849: ROLLBACK;
850:
851: FEM_ENGINES_PKG.Tech_Message(
852: p_severity => pc_log_level_exception,
853: p_module => pc_module_name || 'new_calendar.exception_others' ,
854: p_app_name => 'FEM',
855: p_msg_name => 'FEM_GL_POST_215',

Line 860: FEM_ENGINES_PKG.User_Message(

856: p_token1 => 'ERR_MSG',
857: p_value1 => SQLERRM
858: );
859:
860: FEM_ENGINES_PKG.User_Message(
861: p_app_name => 'FEM',
862: p_msg_name => 'FEM_GL_POST_215',
863: p_token1 => 'ERR_MSG',
864: p_value1 => SQLERRM

Line 867: FEM_ENGINES_PKG.Tech_Message(

863: p_token1 => 'ERR_MSG',
864: p_value1 => SQLERRM
865: );
866:
867: FEM_ENGINES_PKG.Tech_Message(
868: p_severity => pc_log_level_exception,
869: p_module => pc_module_name || 'new_calendar.exception_others',
870: p_app_name => 'FEM',
871: p_msg_name => 'FEM_GL_POST_203',

Line 904: FEM_ENGINES_PKG.Tech_Message(

900:
901: v_time_group_type_code VARCHAR2(30):= NULL;
902: BEGIN
903:
904: FEM_ENGINES_PKG.Tech_Message(
905: p_severity => pc_log_level_procedure,
906: p_module => pc_module_name || 'new_time_dimension_group.begin',
907: p_app_name => 'FEM',
908: p_msg_name => 'FEM_GL_POST_201',

Line 925: FEM_ENGINES_PKG.Tech_Message(

921: FROM FEM_TIME_GROUP_TYPES_B
922: WHERE TIME_GROUP_TYPE_CODE = pv_ogl_period_type_code;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN
925: FEM_ENGINES_PKG.Tech_Message(
926: p_severity => pc_log_level_statement,
927: p_module => pc_module_name || 'new_time_group_type_create_new',
928: p_app_name => 'FEM',
929: p_msg_text => 'Creating a new Time Group Type Code.'

Line 956: FEM_ENGINES_PKG.Tech_Message(

952: v_msg_data := FND_MSG_PUB.Get(
953: p_msg_index => i,
954: p_encoded => 'F'
955: );
956: FEM_ENGINES_PKG.Tech_Message(
957: p_severity => pc_log_level_error,
958: p_module => pc_module_name || 'new_time_group_type_error',
959: p_app_name => 'FEM',
960: p_msg_text => v_msg_data

Line 965: FEM_ENGINES_PKG.Tech_Message(

961: );
962:
963: END LOOP;
964:
965: FEM_ENGINES_PKG.Tech_Message(
966: p_severity => pc_log_level_error,
967: p_module => pc_module_name || 'new_time_group_type_error',
968: p_app_name => 'FEM',
969: p_msg_name => 'FEM_INTG_CAL_NEW_TGT_ERROR',

Line 974: FEM_ENGINES_PKG.User_Message(

970: p_token1 => 'TIME_GROUP_TYPE',
971: p_value1 => pv_ogl_period_type_name
972: );
973:
974: FEM_ENGINES_PKG.User_Message(
975: p_app_name => 'FEM',
976: p_msg_name => 'FEM_INTG_CAL_NEW_TGT_ERROR',
977: p_token1 => 'TIME_GROUP_TYPE',
978: p_value1 => pv_ogl_period_type_name

Line 989: FEM_ENGINES_PKG.Tech_Message(

985: END IF;
986:
987: IF pv_dimension_grp_id_period IS NULL THEN
988:
989: FEM_ENGINES_PKG.Tech_Message(
990: p_severity => pc_log_level_statement,
991: p_module => pc_module_name || 'new_time_dimension_group_create_new',
992: p_app_name => 'FEM',
993: p_msg_text => 'Creating a new Time Dimension Group.'

Line 1016: FEM_ENGINES_PKG.Tech_Message(

1012: v_msg_data := FND_MSG_PUB.Get(
1013: p_msg_index => i,
1014: p_encoded => 'F'
1015: );
1016: FEM_ENGINES_PKG.Tech_Message(
1017: p_severity => pc_log_level_error,
1018: p_module => pc_module_name || 'new_time_dimension_group_error',
1019: p_app_name => 'FEM',
1020: p_msg_text => v_msg_data

Line 1025: FEM_ENGINES_PKG.Tech_Message(

1021: );
1022: END LOOP;
1023:
1024:
1025: FEM_ENGINES_PKG.Tech_Message(
1026: p_severity => pc_log_level_error,
1027: p_module => pc_module_name || 'new_time_dimension_group_error',
1028: p_app_name => 'FEM',
1029: p_msg_name => 'FEM_INTG_CAL_NEW_TDG_ERROR',

Line 1034: FEM_ENGINES_PKG.User_Message(

1030: p_token1 => 'TIME_DIMENSION_GROUP',
1031: p_value1 => pv_ogl_period_type_name
1032: );
1033:
1034: FEM_ENGINES_PKG.User_Message(
1035: p_app_name => 'FEM',
1036: p_msg_name => 'FEM_INTG_CAL_NEW_TDG_ERROR',
1037: p_token1 => 'TIME_DIMENSION_GROUP',
1038: p_value1 => pv_ogl_period_type_name

Line 1047: FEM_ENGINES_PKG.Tech_Message(

1043: END IF;
1044:
1045: END IF;
1046:
1047: FEM_ENGINES_PKG.Tech_Message(
1048: p_severity => pc_log_level_procedure,
1049: p_module => pc_module_name || 'new_time_dimension_group.end',
1050: p_app_name => 'FEM',
1051: p_msg_name => 'FEM_GL_POST_202',

Line 1062: FEM_ENGINES_PKG.Tech_Message(

1058: EXCEPTION
1059: WHEN FEM_INTG_fatal_err THEN
1060: ROLLBACK;
1061:
1062: FEM_ENGINES_PKG.Tech_Message(
1063: p_severity => pc_log_level_exception,
1064: p_module => pc_module_name || 'new_time_dimension_group.exception_fatal_err',
1065: p_app_name => 'FEM',
1066: p_msg_name => 'FEM_GL_POST_203',

Line 1078: FEM_ENGINES_PKG.Tech_Message(

1074:
1075: WHEN OTHERS THEN
1076: ROLLBACK;
1077:
1078: FEM_ENGINES_PKG.Tech_Message(
1079: p_severity => pc_log_level_exception,
1080: p_module => pc_module_name || 'new_time_dimension_group.exception_others' ,
1081: p_app_name => 'FEM',
1082: p_msg_name => 'FEM_GL_POST_215',

Line 1087: FEM_ENGINES_PKG.User_Message(

1083: p_token1 => 'ERR_MSG',
1084: p_value1 => SQLERRM
1085: );
1086:
1087: FEM_ENGINES_PKG.User_Message(
1088: p_app_name => 'FEM',
1089: p_msg_name => 'FEM_GL_POST_215',
1090: p_token1 => 'ERR_MSG',
1091: p_value1 => SQLERRM

Line 1094: FEM_ENGINES_PKG.Tech_Message(

1090: p_token1 => 'ERR_MSG',
1091: p_value1 => SQLERRM
1092: );
1093:
1094: FEM_ENGINES_PKG.Tech_Message(
1095: p_severity => pc_log_level_exception,
1096: p_module => pc_module_name || 'new_time_dimension_group.exception_others',
1097: p_app_name => 'FEM',
1098: p_msg_name => 'FEM_GL_POST_203',

Line 1131: FEM_ENGINES_PKG.Tech_Message(

1127: v_msg_count NUMBER;
1128: v_msg_data VARCHAR2(2000);
1129: BEGIN
1130:
1131: FEM_ENGINES_PKG.Tech_Message(
1132: p_severity => pc_log_level_procedure,
1133: p_module => pc_module_name || 'new_gl_cal_period_hier.begin',
1134: p_app_name => 'FEM',
1135: p_msg_name => 'FEM_GL_POST_201',

Line 1176: FEM_ENGINES_PKG.Tech_Message(

1172: p_msg_index => i,
1173: p_encoded => 'F'
1174: );
1175:
1176: FEM_ENGINES_PKG.Tech_Message(
1177: p_severity => pc_log_level_error,
1178: p_module => pc_module_name || 'new_gl_cal_period_hier_error',
1179: p_app_name => 'FEM',
1180: p_msg_text => v_msg_data

Line 1184: FEM_ENGINES_PKG.Tech_Message(

1180: p_msg_text => v_msg_data
1181: );
1182: END LOOP;
1183:
1184: FEM_ENGINES_PKG.Tech_Message(
1185: p_severity => pc_log_level_error,
1186: p_module => pc_module_name || 'new_gl_cal_period_hier_error',
1187: p_app_name => 'FEM',
1188: p_msg_name => 'FEM_INTG_CAL_NEW_HIER_ERROR',

Line 1193: FEM_ENGINES_PKG.User_Message(

1189: p_token1 => 'TIME_DIMENSION_HIER_OBJ',
1190: p_value1 => v_object_name
1191: );
1192:
1193: FEM_ENGINES_PKG.User_Message(
1194: p_app_name => 'FEM',
1195: p_msg_name => 'FEM_INTG_CAL_NEW_HIER_ERROR',
1196: p_token1 => 'TIME_DIMENSION_HIER_OBJ',
1197: p_value1 => v_object_name

Line 1305: FEM_ENGINES_PKG.Tech_Message(

1301: );
1302: */
1303: pv_row_count_tot := pv_row_count_tot + SQL%ROWCOUNT;
1304:
1305: FEM_ENGINES_PKG.Tech_Message(
1306: p_severity => pc_log_level_procedure,
1307: p_module => pc_module_name || 'new_gl_cal_period_hier.end',
1308: p_app_name => 'FEM',
1309: p_msg_name => 'FEM_GL_POST_202',

Line 1320: FEM_ENGINES_PKG.Tech_Message(

1316: EXCEPTION
1317: WHEN FEM_INTG_fatal_err THEN
1318: ROLLBACK;
1319:
1320: FEM_ENGINES_PKG.Tech_Message(
1321: p_severity => pc_log_level_exception,
1322: p_module => pc_module_name || 'new_gl_cal_period_hier.exception_fatal_err',
1323: p_app_name => 'FEM',
1324: p_msg_name => 'FEM_GL_POST_203',

Line 1336: FEM_ENGINES_PKG.Tech_Message(

1332:
1333: WHEN OTHERS THEN
1334: ROLLBACK;
1335:
1336: FEM_ENGINES_PKG.Tech_Message(
1337: p_severity => pc_log_level_exception,
1338: p_module => pc_module_name || 'new_gl_cal_period_hier.exception_others' ,
1339: p_app_name => 'FEM',
1340: p_msg_name => 'FEM_GL_POST_215',

Line 1345: FEM_ENGINES_PKG.User_Message(

1341: p_token1 => 'ERR_MSG',
1342: p_value1 => SQLERRM
1343: );
1344:
1345: FEM_ENGINES_PKG.User_Message(
1346: p_app_name => 'FEM',
1347: p_msg_name => 'FEM_GL_POST_215',
1348: p_token1 => 'ERR_MSG',
1349: p_value1 => SQLERRM

Line 1352: FEM_ENGINES_PKG.Tech_Message(

1348: p_token1 => 'ERR_MSG',
1349: p_value1 => SQLERRM
1350: );
1351:
1352: FEM_ENGINES_PKG.Tech_Message(
1353: p_severity => pc_log_level_exception,
1354: p_module => pc_module_name || 'new_gl_cal_period_hier.exception_others',
1355: p_app_name => 'FEM',
1356: p_msg_name => 'FEM_GL_POST_203',

Line 1389: FEM_ENGINES_PKG.Tech_Message(

1385: v_err_code NUMBER;
1386: v_num_msg NUMBER;
1387: BEGIN
1388:
1389: FEM_ENGINES_PKG.Tech_Message(
1390: p_severity => pc_log_level_procedure,
1391: p_module => pc_module_name || 'generate_member_ids.begin',
1392: p_app_name => 'FEM',
1393: p_msg_name => 'FEM_GL_POST_201',

Line 1512: FEM_ENGINES_PKG.Tech_Message(

1508: PT.PERIOD_TYPE = pv_period_type;
1509:
1510: pv_row_count_tot := pv_row_count_tot + SQL%ROWCOUNT;
1511:
1512: FEM_ENGINES_PKG.Tech_Message(
1513: p_severity => pc_log_level_procedure,
1514: p_module => pc_module_name || 'generate_member_ids.end',
1515: p_app_name => 'FEM',
1516: p_msg_name => 'FEM_GL_POST_202',

Line 1527: FEM_ENGINES_PKG.Tech_Message(

1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: ROLLBACK;
1526:
1527: FEM_ENGINES_PKG.Tech_Message(
1528: p_severity => pc_log_level_exception,
1529: p_module => pc_module_name || 'generate_member_ids.exception_others' ,
1530: p_app_name => 'FEM',
1531: p_msg_name => 'FEM_GL_POST_215',

Line 1536: FEM_ENGINES_PKG.User_Message(

1532: p_token1 => 'ERR_MSG',
1533: p_value1 => SQLERRM
1534: );
1535:
1536: FEM_ENGINES_PKG.User_Message(
1537: p_app_name => 'FEM',
1538: p_msg_name => 'FEM_GL_POST_215',
1539: p_token1 => 'ERR_MSG',
1540: p_value1 => SQLERRM

Line 1543: FEM_ENGINES_PKG.Tech_Message(

1539: p_token1 => 'ERR_MSG',
1540: p_value1 => SQLERRM
1541: );
1542:
1543: FEM_ENGINES_PKG.Tech_Message(
1544: p_severity => pc_log_level_exception,
1545: p_module => pc_module_name || 'generate_member_ids.exception_others',
1546: p_app_name => 'FEM',
1547: p_msg_name => 'FEM_GL_POST_203',

Line 1592: FEM_ENGINES_PKG.Tech_Message(

1588: v_err_code NUMBER;
1589: v_num_msg NUMBER;
1590: BEGIN
1591:
1592: FEM_ENGINES_PKG.Tech_Message(
1593: p_severity => pc_log_level_procedure,
1594: p_module => pc_module_name || 'populate_time_dimension.begin',
1595: p_app_name => 'FEM',
1596: p_msg_name => 'FEM_GL_POST_201',

Line 1856: FEM_ENGINES_PKG.Tech_Message(

1852: );
1853:
1854: pv_row_count_tot := pv_row_count_tot + SQL%ROWCOUNT;
1855:
1856: FEM_ENGINES_PKG.Tech_Message(
1857: p_severity => pc_log_level_procedure,
1858: p_module => pc_module_name || 'populate_time_dimension.end',
1859: p_app_name => 'FEM',
1860: p_msg_name => 'FEM_GL_POST_202',

Line 1871: FEM_ENGINES_PKG.Tech_Message(

1867: EXCEPTION
1868: WHEN OTHERS THEN
1869: ROLLBACK;
1870:
1871: FEM_ENGINES_PKG.Tech_Message(
1872: p_severity => pc_log_level_exception,
1873: p_module => pc_module_name || 'populate_time_dimension.exception_others' ,
1874: p_app_name => 'FEM',
1875: p_msg_name => 'FEM_GL_POST_215',

Line 1880: FEM_ENGINES_PKG.User_Message(

1876: p_token1 => 'ERR_MSG',
1877: p_value1 => SQLERRM
1878: );
1879:
1880: FEM_ENGINES_PKG.User_Message(
1881: p_app_name => 'FEM',
1882: p_msg_name => 'FEM_GL_POST_215',
1883: p_token1 => 'ERR_MSG',
1884: p_value1 => SQLERRM

Line 1887: FEM_ENGINES_PKG.Tech_Message(

1883: p_token1 => 'ERR_MSG',
1884: p_value1 => SQLERRM
1885: );
1886:
1887: FEM_ENGINES_PKG.Tech_Message(
1888: p_severity => pc_log_level_exception,
1889: p_module => pc_module_name || 'populate_time_dimension.exception_others',
1890: p_app_name => 'FEM',
1891: p_msg_name => 'FEM_GL_POST_203',

Line 1925: FEM_ENGINES_PKG.Tech_Message(

1921: v_err_code NUMBER;
1922: v_num_msg NUMBER;
1923: BEGIN
1924:
1925: FEM_ENGINES_PKG.Tech_Message(
1926: p_severity => pc_log_level_procedure,
1927: p_module => pc_module_name || 'populate_time_hierarchy.begin',
1928: p_app_name => 'FEM',
1929: p_msg_name => 'FEM_GL_POST_201',

Line 2131: FEM_ENGINES_PKG.Tech_Message(

2127: );
2128:
2129: pv_row_count_tot := pv_row_count_tot + SQL%ROWCOUNT;
2130:
2131: FEM_ENGINES_PKG.Tech_Message(
2132: p_severity => pc_log_level_procedure,
2133: p_module => pc_module_name || 'populate_time_hierarchy.end',
2134: p_app_name => 'FEM',
2135: p_msg_name => 'FEM_GL_POST_202',

Line 2146: FEM_ENGINES_PKG.Tech_Message(

2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: ROLLBACK;
2145:
2146: FEM_ENGINES_PKG.Tech_Message(
2147: p_severity => pc_log_level_exception,
2148: p_module => pc_module_name || 'populate_time_hierarchy.exception_others' ,
2149: p_app_name => 'FEM',
2150: p_msg_name => 'FEM_GL_POST_215',

Line 2155: FEM_ENGINES_PKG.User_Message(

2151: p_token1 => 'ERR_MSG',
2152: p_value1 => SQLERRM
2153: );
2154:
2155: FEM_ENGINES_PKG.User_Message(
2156: p_app_name => 'FEM',
2157: p_msg_name => 'FEM_GL_POST_215',
2158: p_token1 => 'ERR_MSG',
2159: p_value1 => SQLERRM

Line 2162: FEM_ENGINES_PKG.Tech_Message(

2158: p_token1 => 'ERR_MSG',
2159: p_value1 => SQLERRM
2160: );
2161:
2162: FEM_ENGINES_PKG.Tech_Message(
2163: p_severity => pc_log_level_exception,
2164: p_module => pc_module_name || 'populate_time_hierarchy.exception_others',
2165: p_app_name => 'FEM',
2166: p_msg_name => 'FEM_GL_POST_203',

Line 2192: FEM_ENGINES_PKG.Tech_Message(

2188: PROCEDURE Update_Calendar_Map
2189: IS
2190: BEGIN
2191:
2192: FEM_ENGINES_PKG.Tech_Message(
2193: p_severity => pc_log_level_procedure,
2194: p_module => pc_module_name || 'update_calendar_map.begin',
2195: p_app_name => 'FEM',
2196: p_msg_name => 'FEM_GL_POST_201',

Line 2223: FEM_ENGINES_PKG.Tech_Message(

2219: AND pv_effective_period_num_high > NVL(EFFECTIVE_PERIOD_NUM_MAX, 0);
2220:
2221: pv_row_count_tot := pv_row_count_tot + SQL%ROWCOUNT;
2222:
2223: FEM_ENGINES_PKG.Tech_Message(
2224: p_severity => pc_log_level_procedure,
2225: p_module => pc_module_name || 'update_calendar_map.end',
2226: p_app_name => 'FEM',
2227: p_msg_name => 'FEM_GL_POST_202',

Line 2238: FEM_ENGINES_PKG.Tech_Message(

2234: EXCEPTION
2235: WHEN OTHERS THEN
2236: ROLLBACK;
2237:
2238: FEM_ENGINES_PKG.Tech_Message(
2239: p_severity => pc_log_level_exception,
2240: p_module => pc_module_name || 'update_calendar_map.exception_others' ,
2241: p_app_name => 'FEM',
2242: p_msg_name => 'FEM_GL_POST_215',

Line 2247: FEM_ENGINES_PKG.User_Message(

2243: p_token1 => 'ERR_MSG',
2244: p_value1 => SQLERRM
2245: );
2246:
2247: FEM_ENGINES_PKG.User_Message(
2248: p_app_name => 'FEM',
2249: p_msg_name => 'FEM_GL_POST_215',
2250: p_token1 => 'ERR_MSG',
2251: p_value1 => SQLERRM

Line 2254: FEM_ENGINES_PKG.Tech_Message(

2250: p_token1 => 'ERR_MSG',
2251: p_value1 => SQLERRM
2252: );
2253:
2254: FEM_ENGINES_PKG.Tech_Message(
2255: p_severity => pc_log_level_exception,
2256: p_module => pc_module_name || 'update_calendar_map.exception_others',
2257: p_app_name => 'FEM',
2258: p_msg_name => 'FEM_GL_POST_203',

Line 2285: FEM_ENGINES_PKG.Tech_Message(

2281: IS
2282: cr CONSTANT VARCHAR2(1) := '
2283: ';
2284: BEGIN
2285: FEM_ENGINES_PKG.Tech_Message(
2286: p_severity => pc_log_level_procedure,
2287: p_module => pc_module_name || 'print_pkg_variable_values',
2288: p_msg_text => cr ||
2289: 'pv_folder_id=' || pv_folder_id || cr ||

Line 2363: FEM_ENGINES_PKG.Tech_Message(

2359: v_ret_status BOOLEAN;
2360:
2361: BEGIN
2362:
2363: FEM_ENGINES_PKG.Tech_Message(
2364: p_severity => pc_log_level_procedure,
2365: p_module => pc_module_name || 'main.begin',
2366: p_app_name => 'FEM',
2367: p_msg_name => 'FEM_GL_POST_201',

Line 2486: FEM_ENGINES_PKG.Tech_Message(

2482: IF v_completion_code = 2 THEN
2483: RAISE FEM_INTG_fatal_err;
2484: END IF;
2485:
2486: FEM_ENGINES_PKG.Tech_Message(
2487: p_severity => pc_log_level_procedure,
2488: p_module => pc_module_name || 'main.end' ,
2489: p_app_name => 'FEM',
2490: p_msg_name => 'FEM_GL_POST_202',

Line 2497: FEM_ENGINES_PKG.User_Message(

2493: p_token2 => 'TIME',
2494: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2495: );
2496:
2497: FEM_ENGINES_PKG.User_Message(
2498: p_app_name => 'FEM',
2499: p_msg_name => 'FEM_INTG_PROC_SUCCESS'
2500: );
2501:

Line 2527: FEM_ENGINES_PKG.Tech_Message(

2523: p_module_name => pc_module_name || 'final_process_logging',
2524: x_completion_code => v_completion_code
2525: );
2526:
2527: FEM_ENGINES_PKG.Tech_Message(
2528: p_severity => pc_log_level_exception,
2529: p_module => pc_module_name || 'main.exception_others',
2530: p_app_name => 'FEM',
2531: p_msg_name => 'FEM_GL_POST_203',

Line 2538: FEM_ENGINES_PKG.User_Message(

2534: p_token2 => 'TIME',
2535: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2536: );
2537:
2538: FEM_ENGINES_PKG.User_Message(
2539: p_app_name => 'FEM',
2540: p_msg_name => 'FEM_INTG_PROC_FAILURE'
2541: );
2542: