[Home] [Help]
113: v_row_count NUMBER;
114:
115: BEGIN
116:
117: FEM_ENGINES_PKG.Tech_Message
118: (p_severity => pc_log_level_procedure,
119: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
120: 'validate_xgl_eng_parameters.begin',
121: p_msg_text => 'BEGIN');
137: -- --------------------------------------------------------------------
138: -- Log debug messages to display values for those variables
139: -- --------------------------------------------------------------------
140:
141: FEM_ENGINES_PKG.Tech_Message
142: (p_severity => pc_log_level_statement,
143: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
144: 'validate_xgl_eng_parameters.pv_ledger_id',
145: p_app_name => 'FEM',
148: p_value1 => 'pv_ledger_id',
149: p_token2 => 'VAR_VAL',
150: p_value2 => TO_CHAR(pv_ledger_id));
151:
152: FEM_ENGINES_PKG.Tech_Message
153: (p_severity => pc_log_level_statement,
154: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
155: 'validate_xgl_eng_parameters.pv_cal_period_id',
156: p_app_name => 'FEM',
159: p_value1 => 'pv_cal_period_id',
160: p_token2 => 'VAR_VAL',
161: p_value2 => TO_CHAR(pv_cal_period_id));
162:
163: FEM_ENGINES_PKG.Tech_Message
164: (p_severity => pc_log_level_statement,
165: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
166: 'validate_xgl_eng_parameters.pv_dataset_code',
167: p_app_name => 'FEM',
170: p_value1 => 'pv_dataset_code',
171: p_token2 => 'VAR_VAL',
172: p_value2 => TO_CHAR(pv_dataset_code));
173:
174: FEM_ENGINES_PKG.Tech_Message
175: (p_severity => pc_log_level_statement,
176: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
177: 'validate_xgl_eng_parameters.pv_budget_id',
178: p_app_name => 'FEM',
181: p_value1 => 'pv_budget_id',
182: p_token2 => 'VAR_VAL',
183: p_value2 => TO_CHAR(pv_budget_id));
184:
185: FEM_ENGINES_PKG.Tech_Message
186: (p_severity => pc_log_level_statement,
187: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
188: 'validate_xgl_eng_parameters.pv_enc_type_id',
189: p_app_name => 'FEM',
192: p_value1 => 'pv_enc_type_id',
193: p_token2 => 'VAR_VAL',
194: p_value2 => TO_CHAR(pv_enc_type_id));
195:
196: FEM_ENGINES_PKG.Tech_Message
197: (p_severity => pc_log_level_statement,
198: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
199: 'validate_xgl_eng_parameters.pv_exec_mode',
200: p_app_name => 'FEM',
203: p_value1 => 'pv_exec_mode',
204: p_token2 => 'VAR_VAL',
205: p_value2 => pv_exec_mode);
206:
207: FEM_ENGINES_PKG.Tech_Message
208: (p_severity => pc_log_level_statement,
209: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
210: 'validate_xgl_eng_parameters.pv_rule_obj_def_id',
211: p_app_name => 'FEM',
214: p_value1 => 'pv_rule_obj_def_id',
215: p_token2 => 'VAR_VAL',
216: p_value2 => TO_CHAR(pv_rule_obj_def_id));
217:
218: FEM_ENGINES_PKG.Tech_Message
219: (p_severity => pc_log_level_statement,
220: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
221: 'validate_xgl_eng_parameters.pv_qtd_ytd_code',
222: p_app_name => 'FEM',
239: AND view_application_id = 274;
240:
241: IF v_row_count = 0 THEN
242:
243: FEM_ENGINES_PKG.Tech_Message
244: (p_severity => pc_log_level_statement,
245: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
246: 'validate_xgl_eng_parameters.iqy',
247: p_msg_text => 'raising Invalid_QTD_YTD');
267: -- Validate that the rule to be executed is an XGL_INTEGRATION rule.
268:
269: IF pv_obj_type_cd <> 'XGL_INTEGRATION' THEN
270:
271: FEM_ENGINES_PKG.Tech_Message
272: (p_severity => pc_log_level_statement,
273: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
274: 'validate_xgl_eng_parameters.iobj2.',
275: p_msg_text => 'raising Invalid_Object_ID');
283: IF x_completion_code <> 1 THEN
284: x_completion_code := 0;
285: END IF;
286:
287: FEM_ENGINES_PKG.Tech_Message
288: (p_severity => pc_log_level_procedure,
289: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
290: 'validate_xgl_eng_parameters.end',
291: p_msg_text => 'END');
303: -- has the wrong Object Type.
304: ------------------------------------------------------------------
305: x_completion_code := 2;
306:
307: FEM_ENGINES_PKG.Tech_Message
308: (p_severity => pc_log_level_error,
309: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
310: 'validate_xgl_eng_parameters.invalid_object_id',
311: p_app_name => 'FEM',
310: 'validate_xgl_eng_parameters.invalid_object_id',
311: p_app_name => 'FEM',
312: p_msg_name => 'FEM_GL_POST_010');
313:
314: FEM_ENGINES_PKG.User_Message
315: (p_app_name => 'FEM',
316: p_msg_name => 'FEM_GL_POST_010');
317:
318: WHEN Invalid_QTD_YTD THEN
321: -- P_QTD_YTD_CODE (Period Specific Amounts Provided)
322: ------------------------------------------------------------------
323: x_completion_code := 2;
324:
325: FEM_ENGINES_PKG.Tech_Message
326: (p_severity => pc_log_level_error,
327: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
328: 'validate_xgl_eng_parameters.invalid_qtd_ytd',
329: p_app_name => 'FEM',
330: p_msg_name => 'FEM_GL_POST_001',
331: p_token1 => 'DIMENSION_NAME',
332: p_value1 => 'P_QTD_YTD_CODE (Period Specific Amounts Provided)');
333:
334: FEM_ENGINES_PKG.User_Message
335: (p_app_name => 'FEM',
336: p_msg_name => 'FEM_GL_POST_001',
337: p_token1 => 'DIMENSION_NAME',
338: p_value1 => 'P_QTD_YTD_CODE (Period Specific Amounts Provided)');
348:
349: -- Log the call stack and the Oracle error message to
350: -- FND_LOG with the "unexpected exception" severity level.
351:
352: FEM_ENGINES_PKG.Tech_Message
353: (p_severity => pc_log_level_unexpected,
354: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
355: 'validate_xgl_eng_parameters.unexpected_exception',
356: p_msg_text => pv_sqlerrm);
354: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
355: 'validate_xgl_eng_parameters.unexpected_exception',
356: p_msg_text => pv_sqlerrm);
357:
358: FEM_ENGINES_PKG.Tech_Message
359: (p_severity => pc_log_level_unexpected,
360: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
361: 'validate_xgl_eng_parameters.unexpected_exception',
362: p_msg_text => pv_callstack);
362: p_msg_text => pv_callstack);
363:
364: -- Log the Oracle error message to the Concurrent Request Log.
365:
366: FEM_ENGINES_PKG.User_Message
367: (p_app_name => 'FEM',
368: p_msg_text => pv_sqlerrm);
369:
370: END Validate_XGL_Eng_Parameters;
412: API_Error EXCEPTION;
413:
414: BEGIN
415:
416: FEM_ENGINES_PKG.Tech_Message
417: (p_severity => pc_log_level_procedure,
418: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
419: 'register_process_execution.begin',
420: p_msg_text => 'BEGIN');
442: X_RETURN_STATUS => v_return_status);
443:
444: IF v_return_status <> 'S' THEN
445:
446: FEM_ENGINES_PKG.Tech_Message
447: (p_severity => pc_log_level_statement,
448: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
449: 'register_process_execution.rrapie',
450: p_msg_text => 'raising API_Error');
480: -- Lock exists
481: v_exec_lock_exists := TRUE;
482: END IF;
483:
484: FEM_ENGINES_PKG.Tech_Message
485: (p_severity => pc_log_level_statement,
486: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
487: 'register_process_execution.roeapie',
488: p_msg_text => 'raising API_Error');
490: RAISE API_Error;
491:
492: END IF;
493:
494: FEM_ENGINES_PKG.Tech_Message
495: (p_severity => pc_log_level_statement,
496: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
497: 'register_process_execution.pv_exec_state',
498: p_app_name => 'FEM',
503: p_value2 => pv_exec_state);
504:
505: IF pv_exec_state = 'RERUN' THEN
506:
507: FEM_ENGINES_PKG.Tech_Message
508: (p_severity => pc_log_level_statement,
509: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
510: 'register_process_execution.pv_prev_req_id',
511: p_app_name => 'FEM',
536: X_RETURN_STATUS => v_return_status);
537:
538: IF v_return_status <> 'S' THEN
539:
540: FEM_ENGINES_PKG.Tech_Message
541: (p_severity => pc_log_level_statement,
542: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
543: 'register_process_execution.rodapie',
544: p_msg_text => 'raising API_Error');
574: X_RETURN_STATUS => v_return_status);
575:
576: IF v_return_status <> 'S' THEN
577:
578: FEM_ENGINES_PKG.Tech_Message
579: (p_severity => pc_log_level_statement,
580: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
581: 'register_process_execution.rtapie',
582: p_msg_text => 'raising API_Error');
588: -- Successful completion
589:
590: x_completion_code := 0;
591:
592: FEM_ENGINES_PKG.Tech_Message
593: (p_severity => pc_log_level_procedure,
594: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
595: 'register_process_execution.end',
596: p_msg_text => 'END');
608: p_encoded => 'F',
609: p_count => v_msg_count,
610: p_data => v_msg_data);
611:
612: FEM_ENGINES_PKG.Tech_Message
613: (p_severity => pc_log_level_statement,
614: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
615: 'register_process_execution.v_msg_count',
616: p_app_name => 'FEM',
621: p_value2 => TO_CHAR(v_msg_count));
622:
623: IF v_msg_count = 1 THEN
624:
625: FEM_ENGINES_PKG.Tech_Message
626: (p_severity => pc_log_level_statement,
627: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
628: 'register_process_execution.v_msg_data1',
629: p_app_name => 'FEM',
632: p_value1 => 'v_msg_data',
633: p_token2 => 'VAR_VAL',
634: p_value2 => v_msg_data);
635:
636: FEM_ENGINES_PKG.User_Message
637: (p_app_name => 'FEM',
638: p_msg_text => v_msg_data);
639:
640: ELSIF v_msg_count > 1 THEN
645:
646: v_msg_data :=
647: FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
648:
649: FEM_ENGINES_PKG.Tech_Message
650: (p_severity => pc_log_level_statement,
651: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
652: 'register_process_execution.v_msg_data2.',
653: p_app_name => 'FEM',
656: p_value1 => 'v_msg_data',
657: p_token2 => 'VAR_VAL',
658: p_value2 => v_msg_data);
659:
660: FEM_ENGINES_PKG.User_Message
661: (p_app_name => 'FEM',
662: p_msg_text => v_msg_data);
663:
664: END LOOP;
690:
691: -- Log the call stack and the Oracle error message to
692: -- FND_LOG with the "unexpected exception" severity level.
693:
694: FEM_ENGINES_PKG.Tech_Message
695: (p_severity => pc_log_level_unexpected,
696: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
697: 'register_process_execution.unexpected_exception',
698: p_msg_text => pv_sqlerrm);
696: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
697: 'register_process_execution.unexpected_exception',
698: p_msg_text => pv_sqlerrm);
699:
700: FEM_ENGINES_PKG.Tech_Message
701: (p_severity => pc_log_level_unexpected,
702: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
703: 'register_process_execution.unexpected_exception',
704: p_msg_text => pv_callstack);
704: p_msg_text => pv_callstack);
705:
706: -- Log the Oracle error message to the Concurrent Request Log.
707:
708: FEM_ENGINES_PKG.User_Message
709: (p_app_name => 'FEM',
710: p_msg_text => pv_sqlerrm);
711:
712: END Register_Process_Execution;
773: j PLS_INTEGER;
774:
775: BEGIN
776:
777: FEM_ENGINES_PKG.Tech_Message
778: (p_severity => pc_log_level_procedure,
779: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
780: 'final_process_logging.begin',
781: p_msg_text => 'BEGIN');
857: p_data => v_msg_data);
858:
859: IF v_msg_count = 1 THEN
860:
861: FEM_ENGINES_PKG.User_Message
862: (p_app_name => 'FEM',
863: p_msg_text => v_msg_data);
864:
865: ELSIF v_msg_count > 1 THEN
868:
869: v_msg_data :=
870: FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
871:
872: FEM_ENGINES_PKG.User_Message
873: (p_app_name => 'FEM',
874: p_msg_text => v_msg_data);
875:
876: END LOOP;
899: -- with the Source System Codes "Not (fully) Processed".
900:
901: FOR i IN 1..pv_ssc_tbp.count LOOP
902:
903: FEM_ENGINES_PKG.Tech_Message
904: (p_severity => pc_log_level_statement,
905: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
906: 'final_process_logging.i',
907: p_app_name => 'FEM',
910: p_value1 => 'i',
911: p_token2 => 'VAR_VAL',
912: p_value2 => TO_CHAR(i));
913:
914: FEM_ENGINES_PKG.Tech_Message
915: (p_severity => pc_log_level_statement,
916: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
917: 'final_process_logging.j',
918: p_app_name => 'FEM',
937: -- No interface rows with this Source System Code should have been
938: -- processed because it's an invalid code. Don't log any Data
939: -- Locations entry for it.
940:
941: FEM_ENGINES_PKG.Tech_Message
942: (p_severity => pc_log_level_statement,
943: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
944: 'final_process_logging.ssc_invalid',
945: p_app_name => 'FEM',
968: P_DATASET_CD => pv_dataset_code,
969: P_SOURCE_CD => v_src_sys_code,
970: P_LOAD_STATUS => 'COMPLETE');
971:
972: FEM_ENGINES_PKG.Tech_Message
973: (p_severity => pc_log_level_statement,
974: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
975: 'final_process_logging.ssc_complete',
976: p_app_name => 'FEM',
1001: P_DATASET_CD => pv_dataset_code,
1002: P_SOURCE_CD => v_src_sys_code,
1003: P_LOAD_STATUS => 'INCOMPLETE');
1004:
1005: FEM_ENGINES_PKG.Tech_Message
1006: (p_severity => pc_log_level_statement,
1007: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1008: 'final_process_logging.ssc_complete',
1009: p_app_name => 'FEM',
1027: END IF;
1028:
1029: -- Log final messages
1030:
1031: FEM_ENGINES_PKG.Tech_Message
1032: (P_SEVERITY => pc_log_level_statement,
1033: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||
1034: 'final_process_logging.completion_status',
1035: P_APP_NAME => 'FEM',
1042: -- Successful completion
1043:
1044: -- LOADNUM rows loaded successfully.
1045: -- REJECTNUM rows failed to load successfully.
1046: FEM_ENGINES_PKG.User_Message
1047: (P_APP_NAME => 'FEM',
1048: P_MSG_NAME => 'FEM_SD_LDR_PROCESS_SUMMARY',
1049: P_TOKEN1 => 'LOADNUM',
1050: P_VALUE1 => TO_CHAR(NVL(p_num_output_rows, 0)),
1050: P_VALUE1 => TO_CHAR(NVL(p_num_output_rows, 0)),
1051: P_TOKEN2 => 'REJECTNUM',
1052: P_VALUE2 => TO_CHAR(NVL(p_num_data_errors, 0)));
1053:
1054: FEM_ENGINES_PKG.User_Message
1055: (P_APP_NAME => 'FEM',
1056: P_MSG_NAME => p_final_message_name);
1057:
1058: FEM_ENGINES_PKG.Tech_Message
1054: FEM_ENGINES_PKG.User_Message
1055: (P_APP_NAME => 'FEM',
1056: P_MSG_NAME => p_final_message_name);
1057:
1058: FEM_ENGINES_PKG.Tech_Message
1059: (P_SEVERITY => pc_log_level_event,
1060: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||
1061: 'final_process_logging.final',
1062: P_APP_NAME => 'FEM',
1061: 'final_process_logging.final',
1062: P_APP_NAME => 'FEM',
1063: P_MSG_NAME => p_final_message_name);
1064:
1065: FEM_ENGINES_PKG.Tech_Message
1066: (P_SEVERITY => pc_log_level_procedure,
1067: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||
1068: 'final_process_logging.end',
1069: P_MSG_TEXT => 'END');
1079:
1080: -- Log the call stack and the Oracle error message to
1081: -- FND_LOG with the "unexpected exception" severity level.
1082:
1083: FEM_ENGINES_PKG.Tech_Message
1084: (P_SEVERITY => pc_log_level_unexpected,
1085: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||
1086: 'final_process_logging.exception',
1087: P_MSG_TEXT => pv_sqlerrm);
1085: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||
1086: 'final_process_logging.exception',
1087: P_MSG_TEXT => pv_sqlerrm);
1088:
1089: FEM_ENGINES_PKG.Tech_Message
1090: (P_SEVERITY => pc_log_level_unexpected,
1091: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||
1092: 'final_process_logging.exception',
1093: P_MSG_TEXT => pv_callstack);
1093: P_MSG_TEXT => pv_callstack);
1094:
1095: -- Log the Oracle error message to the Concurrent Request Log.
1096:
1097: FEM_ENGINES_PKG.User_Message
1098: (p_app_name => 'FEM',
1099: p_msg_text => pv_sqlerrm);
1100:
1101: -- LOADNUM rows loaded successfully.
1099: p_msg_text => pv_sqlerrm);
1100:
1101: -- LOADNUM rows loaded successfully.
1102: -- REJECTNUM rows failed to load successfully.
1103: FEM_ENGINES_PKG.User_Message
1104: (P_APP_NAME => 'FEM',
1105: P_MSG_NAME => 'FEM_SD_LDR_PROCESS_SUMMARY',
1106: P_TOKEN1 => 'LOADNUM',
1107: P_VALUE1 => TO_CHAR(NVL(p_num_output_rows, 0)),
1163: v NUMBER;
1164:
1165: BEGIN
1166:
1167: FEM_ENGINES_PKG.Tech_Message
1168: (p_severity => pc_log_level_procedure,
1169: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1170: 'get_proc_key_info.' || p_process_slice,
1171: p_msg_text => 'BEGIN');
1197: ORDER BY tcp.column_name;
1198:
1199: pv_proc_key_dim_num := pv_proc_keys.count;
1200:
1201: FEM_ENGINES_PKG.Tech_Message
1202: (p_severity => pc_log_level_statement,
1203: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1204: 'get_proc_key_info.' || p_process_slice,
1205: p_app_name => 'FEM',
1210: p_value2 => TO_CHAR(pv_proc_key_dim_num));
1211:
1212: IF pv_proc_key_dim_num = 0 THEN
1213:
1214: FEM_ENGINES_PKG.Tech_Message
1215: (p_severity => pc_log_level_error,
1216: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1217: 'get_proc_key_info.' || p_process_slice,
1218: p_app_name => 'FEM',
1222: END IF;
1223:
1224: FOR v IN 1..pv_proc_key_dim_num LOOP
1225:
1226: FEM_ENGINES_PKG.Tech_Message
1227: (p_severity => pc_log_level_statement,
1228: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1229: 'get_proc_key_info.' || p_process_slice,
1230: p_app_name => 'FEM',
1233: p_value1 => 'dim_col_name',
1234: p_token2 => 'VAR_VAL',
1235: p_value2 => pv_proc_keys(v).dim_col_name);
1236:
1237: FEM_ENGINES_PKG.Tech_Message
1238: (p_severity => pc_log_level_statement,
1239: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1240: 'get_proc_key_info.' || p_process_slice,
1241: p_app_name => 'FEM',
1255: p_Ledger_ID => pv_ledger_id);
1256:
1257: IF pv_proc_keys(v).dim_vs_id = -1 THEN
1258:
1259: FEM_ENGINES_PKG.Tech_Message
1260: (p_severity => pc_log_level_statement,
1261: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1262: 'get_proc_key_info.' || p_process_slice,
1263: p_msg_text => 'raising Value_Set_ID_Error');
1268: RAISE Value_Set_ID_Error;
1269:
1270: END IF;
1271:
1272: FEM_ENGINES_PKG.Tech_Message
1273: (p_severity => pc_log_level_statement,
1274: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1275: 'get_proc_key_info.' || p_process_slice,
1276: p_app_name => 'FEM',
1281: p_value2 => TO_CHAR(pv_proc_keys(v).dim_vs_id));
1282:
1283: END IF;
1284:
1285: FEM_ENGINES_PKG.Tech_Message
1286: (p_severity => pc_log_level_statement,
1287: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1288: 'get_proc_key_info.' || p_process_slice,
1289: p_app_name => 'FEM',
1292: p_value1 => 'dim_member_b_table_name',
1293: p_token2 => 'VAR_VAL',
1294: p_value2 => pv_proc_keys(v).dim_member_b_table_name);
1295:
1296: FEM_ENGINES_PKG.Tech_Message
1297: (p_severity => pc_log_level_statement,
1298: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1299: 'get_proc_key_info.' || p_process_slice,
1300: p_app_name => 'FEM',
1306:
1307: IF pv_proc_keys(v).dim_col_name NOT IN
1308: ('CAL_PERIOD_ID', 'DATASET_CODE', 'CREATED_BY_OBJECT_ID') THEN
1309:
1310: FEM_ENGINES_PKG.Tech_Message
1311: (p_severity => pc_log_level_statement,
1312: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1313: 'get_proc_key_info.' || p_process_slice,
1314: p_app_name => 'FEM',
1317: p_value1 => 'dim_member_disp_code_col',
1318: p_token2 => 'VAR_VAL',
1319: p_value2 => pv_proc_keys(v).dim_member_disp_code_col);
1320:
1321: FEM_ENGINES_PKG.Tech_Message
1322: (p_severity => pc_log_level_statement,
1323: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1324: 'get_proc_key_info.' || p_process_slice,
1325: p_app_name => 'FEM',
1330: p_value2 => pv_proc_keys(v).dim_int_disp_code_col);
1331:
1332: END IF;
1333:
1334: FEM_ENGINES_PKG.Tech_Message
1335: (p_severity => pc_log_level_statement,
1336: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1337: 'get_proc_key_info.' || p_process_slice,
1338: p_app_name => 'FEM',
1345: END LOOP;
1346:
1347: x_completion_code := 0;
1348:
1349: FEM_ENGINES_PKG.Tech_Message
1350: (p_severity => pc_log_level_procedure,
1351: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1352: 'get_proc_key_info.' || p_process_slice,
1353: p_msg_text => 'END');
1361: ------------------------------------------------------------------
1362:
1363: x_completion_code := 2;
1364:
1365: FEM_ENGINES_PKG.Tech_Message
1366: (p_severity => pc_log_level_error,
1367: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1368: 'get_proc_key_info.' || p_process_slice,
1369: p_app_name => 'FEM',
1370: p_msg_name => 'FEM_GL_POST_022',
1371: p_token1 => 'DIMENSION_NAME',
1372: p_value1 => pv_dim_name);
1373:
1374: FEM_ENGINES_PKG.User_Message
1375: (p_app_name => 'FEM',
1376: p_msg_name => 'FEM_GL_POST_022',
1377: p_token1 => 'DIMENSION_NAME',
1378: p_value1 => pv_dim_name);
1378: p_value1 => pv_dim_name);
1379:
1380: FND_MSG_PUB.Initialize;
1381:
1382: FEM_ENGINES_PKG.Put_Message
1383: (p_app_name => 'FEM',
1384: p_msg_name => 'FEM_GL_POST_022',
1385: p_token1 => 'DIMENSION_NAME',
1386: p_value1 => pv_dim_name);
1396:
1397: -- Log the call stack and the Oracle error message to
1398: -- FND_LOG with the "unexpected exception" severity level.
1399:
1400: FEM_ENGINES_PKG.Tech_Message
1401: (p_severity => pc_log_level_unexpected,
1402: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1403: 'get_proc_key_info.' || p_process_slice,
1404: p_msg_text => pv_sqlerrm);
1402: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1403: 'get_proc_key_info.' || p_process_slice,
1404: p_msg_text => pv_sqlerrm);
1405:
1406: FEM_ENGINES_PKG.Tech_Message
1407: (p_severity => pc_log_level_unexpected,
1408: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1409: 'get_proc_key_info.' || p_process_slice,
1410: p_msg_text => pv_callstack);
1410: p_msg_text => pv_callstack);
1411:
1412: -- Log the Oracle error message to the Concurrent Request Log.
1413:
1414: FEM_ENGINES_PKG.User_Message
1415: (p_app_name => 'FEM',
1416: p_msg_text => pv_sqlerrm);
1417:
1418: END Get_Proc_Key_Info;
1460: SrcSysDspCdTBP SrcSysDspCdTBP_cursor;
1461:
1462: BEGIN
1463:
1464: FEM_ENGINES_PKG.Tech_Message
1465: (p_severity => pc_log_level_procedure,
1466: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1467: 'get_ssc.begin',
1468: p_msg_text => 'BEGIN');
1472: ' WHERE ' || pv_ssc_where ||
1473: ' GROUP BY source_system_display_code' ||
1474: ' ORDER BY source_system_display_code';
1475:
1476: FEM_ENGINES_PKG.Tech_Message
1477: (p_severity => pc_log_level_statement,
1478: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1479: 'get_ssc',
1480: p_app_name => 'FEM',
1489: IF p_dest_code = 'TBP' THEN
1490:
1491: FETCH SrcSysDspCdTBP BULK COLLECT INTO pv_ssc_tbp;
1492:
1493: FEM_ENGINES_PKG.Tech_Message
1494: (p_severity => pc_log_level_statement,
1495: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1496: 'get_ssc',
1497: p_app_name => 'FEM',
1504: ELSE
1505:
1506: FETCH SrcSysDspCdTBP BULK COLLECT INTO pv_ssc_np;
1507:
1508: FEM_ENGINES_PKG.Tech_Message
1509: (p_severity => pc_log_level_statement,
1510: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1511: 'get_ssc',
1512: p_app_name => 'FEM',
1529: END IF;
1530:
1531: CLOSE SrcSysDspCdTBP;
1532:
1533: FEM_ENGINES_PKG.Tech_Message
1534: (p_severity => pc_log_level_procedure,
1535: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1536: 'get_ssc.end',
1537: p_msg_text => 'END');
1575: v_attr_name fem_dim_attributes_tl.attribute_name%TYPE;
1576:
1577: BEGIN
1578:
1579: FEM_ENGINES_PKG.Tech_Message
1580: (p_severity => pc_log_level_procedure,
1581: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1582: 'undo_xgl_int_error_rows.begin',
1583: p_msg_text => 'BEGIN');
1593: INTO pv_ledger_id, pv_cal_period_id, pv_dataset_code
1594: FROM fem_pl_requests
1595: WHERE request_id = p_request_id;
1596:
1597: FEM_ENGINES_PKG.Tech_Message
1598: (p_severity => pc_log_level_statement,
1599: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1600: 'undo_xgl_int_error_rows.pv_ledger_id',
1601: p_app_name => 'FEM',
1604: p_value1 => 'pv_ledger_id',
1605: p_token2 => 'VAR_VAL',
1606: p_value2 => TO_CHAR(pv_ledger_id));
1607:
1608: FEM_ENGINES_PKG.Tech_Message
1609: (p_severity => pc_log_level_statement,
1610: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1611: 'undo_xgl_int_error_rows.pv_cal_period_id',
1612: p_app_name => 'FEM',
1615: p_value1 => 'pv_cal_period_id',
1616: p_token2 => 'VAR_VAL',
1617: p_value2 => TO_CHAR(pv_cal_period_id));
1618:
1619: FEM_ENGINES_PKG.Tech_Message
1620: (p_severity => pc_log_level_statement,
1621: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1622: 'undo_xgl_int_error_rows.pv_dataset_code',
1623: p_app_name => 'FEM',
1629:
1630: EXCEPTION
1631: WHEN NO_DATA_FOUND THEN
1632:
1633: FEM_ENGINES_PKG.Tech_Message
1634: (p_severity => pc_log_level_statement,
1635: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1636: 'undo_xgl_int_error_rows.irid.',
1637: p_msg_text => 'raising Invalid_Request_ID');
1683: INTO pv_cal_per_dim_grp_dsp_cd
1684: FROM fem_dimension_grps_b
1685: WHERE dimension_group_id = v_cal_per_dim_group_id;
1686:
1687: FEM_ENGINES_PKG.Tech_Message
1688: (p_severity => pc_log_level_statement,
1689: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1690: 'undo_xgl_int_error_rows.pv_cal_per_dim_grp_dsp_cd',
1691: p_app_name => 'FEM',
1697:
1698: EXCEPTION
1699: WHEN NO_DATA_FOUND THEN
1700:
1701: FEM_ENGINES_PKG.Tech_Message
1702: (p_severity => pc_log_level_statement,
1703: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1704: 'undo_xgl_int_error_rows.icpid1.',
1705: p_msg_text => 'raising Invalid_Runtime_Parameter');
1727: p_attr_label => 'CAL_PERIOD_END_DATE');
1728:
1729: IF pv_API_return_code > 0 THEN
1730:
1731: FEM_ENGINES_PKG.Tech_Message
1732: (p_severity => pc_log_level_statement,
1733: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1734: 'undo_xgl_int_error_rows.icpid2.',
1735: p_msg_text => 'raising Invalid_Runtime_Parameter');
1744: WHERE attribute_id = pv_dim_attr_id
1745: AND version_id = pv_dim_attr_ver_id
1746: AND cal_period_id = pv_cal_period_id;
1747:
1748: FEM_ENGINES_PKG.Tech_Message
1749: (p_severity => pc_log_level_statement,
1750: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1751: 'undo_xgl_int_error_rows.pv_cal_per_end_date',
1752: p_app_name => 'FEM',
1758:
1759: EXCEPTION
1760: WHEN NO_DATA_FOUND THEN
1761:
1762: FEM_ENGINES_PKG.Tech_Message
1763: (p_severity => pc_log_level_statement,
1764: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1765: 'undo_xgl_int_error_rows.icpid3.',
1766: p_msg_text => 'raising Invalid_Runtime_Parameter');
1789: p_attr_label => 'GL_PERIOD_NUM');
1790:
1791: IF pv_API_return_code > 0 THEN
1792:
1793: FEM_ENGINES_PKG.Tech_Message
1794: (p_severity => pc_log_level_statement,
1795: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1796: 'undo_xgl_int_error_rows.icpid4.',
1797: p_msg_text => 'raising Invalid_Runtime_Parameter');
1806: WHERE attribute_id = pv_dim_attr_id
1807: AND version_id = pv_dim_attr_ver_id
1808: AND cal_period_id = pv_cal_period_id;
1809:
1810: FEM_ENGINES_PKG.Tech_Message
1811: (p_severity => pc_log_level_statement,
1812: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1813: 'undo_xgl_int_error_rows.pv_gl_per_number',
1814: p_app_name => 'FEM',
1820:
1821: EXCEPTION
1822: WHEN NO_DATA_FOUND THEN
1823:
1824: FEM_ENGINES_PKG.Tech_Message
1825: (p_severity => pc_log_level_statement,
1826: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1827: 'undo_xgl_int_error_rows.icpid5.',
1828: p_msg_text => 'raising Invalid_Runtime_Parameter');
1859: WHERE ledger_id = pv_ledger_id
1860: AND enabled_flag = 'Y'
1861: AND personal_flag = 'N';
1862:
1863: FEM_ENGINES_PKG.Tech_Message
1864: (p_severity => pc_log_level_statement,
1865: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1866: 'undo_xgl_int_error_rows.pv_ledger_dsp_cd',
1867: p_app_name => 'FEM',
1873:
1874: EXCEPTION
1875: WHEN NO_DATA_FOUND THEN
1876:
1877: FEM_ENGINES_PKG.Tech_Message
1878: (p_severity => pc_log_level_statement,
1879: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1880: 'undo_xgl_int_error_rows.ilid.',
1881: p_msg_text => 'raising Invalid_Runtime_Parameter');
1924: p_attr_label => 'DATASET_BALANCE_TYPE_CODE');
1925:
1926: IF pv_API_return_code > 0 THEN
1927:
1928: FEM_ENGINES_PKG.Tech_Message
1929: (p_severity => pc_log_level_statement,
1930: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1931: 'undo_xgl_int_error_rows.idsc1.',
1932: p_msg_text => 'raising Invalid_Runtime_Parameter');
1941: WHERE attribute_id = pv_dim_attr_id
1942: AND version_id = pv_dim_attr_ver_id
1943: AND dataset_code = pv_dataset_code;
1944:
1945: FEM_ENGINES_PKG.Tech_Message
1946: (p_severity => pc_log_level_statement,
1947: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1948: 'undo_xgl_int_error_rows.pv_ds_balance_type_cd',
1949: p_app_name => 'FEM',
1955:
1956: EXCEPTION
1957: WHEN NO_DATA_FOUND THEN
1958:
1959: FEM_ENGINES_PKG.Tech_Message
1960: (p_severity => pc_log_level_statement,
1961: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1962: 'undo_xgl_int_error_rows.idsc2.',
1963: p_msg_text => 'raising Invalid_Runtime_Parameter');
1987: p_attr_label => 'BUDGET_ID');
1988:
1989: IF pv_API_return_code > 0 THEN
1990:
1991: FEM_ENGINES_PKG.Tech_Message
1992: (p_severity => pc_log_level_statement,
1993: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
1994: 'undo_xgl_int_error_rows.idsc3.',
1995: p_msg_text => 'raising Invalid_Runtime_Parameter');
2004: WHERE attribute_id = pv_dim_attr_id
2005: AND version_id = pv_dim_attr_ver_id
2006: AND dataset_code = pv_dataset_code;
2007:
2008: FEM_ENGINES_PKG.Tech_Message
2009: (p_severity => pc_log_level_statement,
2010: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2011: 'undo_xgl_int_error_rows.pv_budget_id',
2012: p_app_name => 'FEM',
2018:
2019: EXCEPTION
2020: WHEN NO_DATA_FOUND THEN
2021:
2022: FEM_ENGINES_PKG.Tech_Message
2023: (p_severity => pc_log_level_statement,
2024: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2025: 'undo_xgl_int_error_rows.idsc4.',
2026: p_msg_text => 'raising Invalid_Runtime_Parameter');
2049: INTO pv_budget_dsp_cd
2050: FROM fem_budgets_b
2051: WHERE budget_id = pv_budget_id;
2052:
2053: FEM_ENGINES_PKG.Tech_Message
2054: (p_severity => pc_log_level_statement,
2055: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2056: 'undo_xgl_int_error_rows.pv_budget_dsp_cd',
2057: p_app_name => 'FEM',
2063:
2064: EXCEPTION
2065: WHEN NO_DATA_FOUND THEN
2066:
2067: FEM_ENGINES_PKG.Tech_Message
2068: (p_severity => pc_log_level_statement,
2069: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2070: 'undo_xgl_int_error_rows.idsc5.',
2071: p_msg_text => 'raising Invalid_Runtime_Parameter');
2095: p_attr_label => 'ENCUMBRANCE_TYPE_ID');
2096:
2097: IF pv_API_return_code > 0 THEN
2098:
2099: FEM_ENGINES_PKG.Tech_Message
2100: (p_severity => pc_log_level_statement,
2101: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2102: 'undo_xgl_int_error_rows.idsc6.',
2103: p_msg_text => 'raising Invalid_Runtime_Parameter');
2112: WHERE attribute_id = pv_dim_attr_id
2113: AND version_id = pv_dim_attr_ver_id
2114: AND dataset_code = pv_dataset_code;
2115:
2116: FEM_ENGINES_PKG.Tech_Message
2117: (p_severity => pc_log_level_statement,
2118: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2119: 'undo_xgl_int_error_rows.pv_enc_type_id',
2120: p_app_name => 'FEM',
2126:
2127: EXCEPTION
2128: WHEN NO_DATA_FOUND THEN
2129:
2130: FEM_ENGINES_PKG.Tech_Message
2131: (p_severity => pc_log_level_statement,
2132: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2133: 'undo_xgl_int_error_rows.idsc7.',
2134: p_msg_text => 'raising Invalid_Runtime_Parameter');
2157: INTO pv_enc_type_dsp_cd
2158: FROM fem_encumbrance_types_b
2159: WHERE encumbrance_type_id = pv_enc_type_id;
2160:
2161: FEM_ENGINES_PKG.Tech_Message
2162: (p_severity => pc_log_level_statement,
2163: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2164: 'undo_xgl_int_error_rows.pv_enc_type_dsp_cd',
2165: p_app_name => 'FEM',
2171:
2172: EXCEPTION
2173: WHEN NO_DATA_FOUND THEN
2174:
2175: FEM_ENGINES_PKG.Tech_Message
2176: (p_severity => pc_log_level_statement,
2177: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2178: 'undo_xgl_int_error_rows.idsc8.',
2179: p_msg_text => 'raising Invalid_Runtime_Parameter');
2207: v_rows_deleted := SQL%ROWCOUNT;
2208:
2209: COMMIT;
2210:
2211: FEM_ENGINES_PKG.Tech_Message
2212: (p_severity => pc_log_level_statement,
2213: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2214: 'undo_xgl_int_error_rows.v_rows_deleted',
2215: p_app_name => 'FEM',
2222: x_return_status := 'S';
2223: x_msg_data := NULL;
2224: x_msg_count := 0;
2225:
2226: FEM_ENGINES_PKG.Tech_Message
2227: (p_severity => pc_log_level_procedure,
2228: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2229: 'undo_xgl_int_error_rows.end',
2230: p_msg_text => 'END');
2233: WHEN Invalid_Request_ID THEN
2234:
2235: -- WARNING: Error rows not undone from FEM_BAL_INTERFACE_T
2236:
2237: FEM_ENGINES_PKG.Tech_Message
2238: (p_severity => pc_log_level_error,
2239: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2240: 'undo_xgl_int_error_rows.xirid1',
2241: p_app_name => 'FEM',
2240: 'undo_xgl_int_error_rows.xirid1',
2241: p_app_name => 'FEM',
2242: p_msg_name => 'FEM_GL_POST_024');
2243:
2244: FEM_ENGINES_PKG.Put_Message
2245: (p_app_name => 'FEM',
2246: p_msg_name => 'FEM_GL_POST_024');
2247:
2248: -- Invalid parameter. Value not found. Parameter Name: Request ID.
2246: p_msg_name => 'FEM_GL_POST_024');
2247:
2248: -- Invalid parameter. Value not found. Parameter Name: Request ID.
2249:
2250: FEM_ENGINES_PKG.Tech_Message
2251: (p_severity => pc_log_level_error,
2252: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2253: 'undo_xgl_int_error_rows.xirid2',
2254: p_app_name => 'FEM',
2256: p_token1 => 'DIMENSION_NAME',
2257: p_value1 => 'FEM_REQUEST_ID_TXT',
2258: p_trans1 => 'Y');
2259:
2260: FEM_ENGINES_PKG.Put_Message
2261: (p_app_name => 'FEM',
2262: p_msg_name => 'FEM_GL_POST_001',
2263: p_token1 => 'DIMENSION_NAME',
2264: p_value1 => 'FEM_REQUEST_ID_TXT',
2278: -- Parameter Name: v_param_name. Parameter Value:
2279: -- v_param_value. Attribute Name: v_attr_name.
2280: ------------------------------------------------------------------
2281:
2282: FEM_ENGINES_PKG.Tech_Message
2283: (p_severity => pc_log_level_error,
2284: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2285: 'undo_xgl_int_error_rows.xirp1',
2286: p_app_name => 'FEM',
2285: 'undo_xgl_int_error_rows.xirp1',
2286: p_app_name => 'FEM',
2287: p_msg_name => 'FEM_GL_POST_024');
2288:
2289: FEM_ENGINES_PKG.Put_Message
2290: (p_app_name => 'FEM',
2291: p_msg_name => 'FEM_GL_POST_024');
2292:
2293: FEM_ENGINES_PKG.Tech_Message
2289: FEM_ENGINES_PKG.Put_Message
2290: (p_app_name => 'FEM',
2291: p_msg_name => 'FEM_GL_POST_024');
2292:
2293: FEM_ENGINES_PKG.Tech_Message
2294: (p_severity => pc_log_level_error,
2295: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2296: 'undo_xgl_int_error_rows.xirp2',
2297: p_app_name => 'FEM',
2302: p_value2 => v_param_value,
2303: p_token3 => 'ATTRIBUTE_NAME',
2304: p_value3 => v_attr_name);
2305:
2306: FEM_ENGINES_PKG.Put_Message
2307: (p_app_name => 'FEM',
2308: p_msg_name => 'FEM_GL_POST_025',
2309: p_token1 => 'PARAMETER_NAME',
2310: p_value1 => v_param_name,
2340: -- =======================================================================
2341:
2342: BEGIN
2343:
2344: FEM_ENGINES_PKG.Tech_Message
2345: (p_severity => pc_log_level_procedure,
2346: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2347: 'get_dim_ids.begin',
2348: p_msg_text => 'BEGIN');
2346: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2347: 'get_dim_ids.begin',
2348: p_msg_text => 'BEGIN');
2349:
2350: FEM_ENGINES_PKG.Tech_Message
2351: (p_severity => pc_log_level_statement,
2352: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2353: 'get_dim_ids',
2354: p_msg_text => 'Get Calendar Period dimension ID');
2357: INTO pv_cal_per_dim_id
2358: FROM fem_dimensions_b
2359: WHERE dimension_varchar_label = 'CAL_PERIOD';
2360:
2361: FEM_ENGINES_PKG.Tech_Message
2362: (p_severity => pc_log_level_statement,
2363: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2364: 'get_dim_ids',
2365: p_msg_text => 'Get Ledger dimension ID');
2368: INTO pv_ledger_dim_id
2369: FROM fem_dimensions_b
2370: WHERE dimension_varchar_label = 'LEDGER';
2371:
2372: FEM_ENGINES_PKG.Tech_Message
2373: (p_severity => pc_log_level_statement,
2374: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2375: 'get_dim_ids',
2376: p_msg_text => 'Get Dataset dimension ID');
2379: INTO pv_dataset_dim_id
2380: FROM fem_dimensions_b
2381: WHERE dimension_varchar_label = 'DATASET';
2382:
2383: FEM_ENGINES_PKG.Tech_Message
2384: (p_severity => pc_log_level_statement,
2385: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2386: 'get_dim_ids',
2387: p_msg_text => 'Get Budget dimension ID');
2390: INTO pv_budget_dim_id
2391: FROM fem_dimensions_b
2392: WHERE dimension_varchar_label = 'BUDGET';
2393:
2394: FEM_ENGINES_PKG.Tech_Message
2395: (p_severity => pc_log_level_statement,
2396: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2397: 'get_dim_ids',
2398: p_msg_text => 'Get Encumbrance Type dimension ID');
2401: INTO pv_enc_type_dim_id
2402: FROM fem_dimensions_b
2403: WHERE dimension_varchar_label = 'ENCUMBRANCE_TYPE';
2404:
2405: FEM_ENGINES_PKG.Tech_Message
2406: (p_severity => pc_log_level_statement,
2407: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2408: 'get_dim_ids',
2409: p_msg_text => 'Get Extended Account Type dimension ID');
2412: INTO pv_ext_acct_type_dim_id
2413: FROM fem_dimensions_b
2414: WHERE dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE';
2415:
2416: FEM_ENGINES_PKG.Tech_Message
2417: (p_severity => pc_log_level_statement,
2418: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2419: 'get_dim_ids',
2420: p_msg_text => 'Get Natural Account dimension ID');
2423: INTO pv_nat_acct_dim_id
2424: FROM fem_dimensions_b
2425: WHERE dimension_varchar_label = 'NATURAL_ACCOUNT';
2426:
2427: FEM_ENGINES_PKG.Tech_Message
2428: (p_severity => pc_log_level_procedure,
2429: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2430: 'get_dim_ids.end',
2431: p_msg_text => 'END');
2464: v_budget_ledger fem_budgets_attr.dim_attribute_numeric_member%TYPE;
2465:
2466: BEGIN
2467:
2468: FEM_ENGINES_PKG.Tech_Message
2469: (p_severity => pc_log_level_procedure,
2470: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2471: 'validate_budget.begin',
2472: p_msg_text => 'BEGIN');
2482: WHERE budget_id = pv_budget_id
2483: AND enabled_flag = 'Y'
2484: AND personal_flag = 'N';
2485:
2486: FEM_ENGINES_PKG.Tech_Message
2487: (p_severity => pc_log_level_statement,
2488: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2489: 'validate_budget.pv_budget_dsp_cd',
2490: p_app_name => 'FEM',
2496:
2497: EXCEPTION
2498: WHEN NO_DATA_FOUND THEN
2499:
2500: FEM_ENGINES_PKG.Tech_Message
2501: (p_severity => pc_log_level_statement,
2502: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2503: 'validate_budget.ibid1.',
2504: p_msg_text => 'raising Invalid_Budget_ID');
2519: p_attr_label => 'BUDGET_ID');
2520:
2521: IF pv_API_return_code > 0 THEN
2522:
2523: FEM_ENGINES_PKG.Tech_Message
2524: (p_severity => pc_log_level_statement,
2525: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2526: 'validate_budget.idsc1.',
2527: p_msg_text => 'raising Invalid_Dataset_Code');
2539:
2540: EXCEPTION
2541: WHEN NO_DATA_FOUND THEN
2542:
2543: FEM_ENGINES_PKG.Tech_Message
2544: (p_severity => pc_log_level_statement,
2545: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2546: 'validate_budget.idsc2.',
2547: p_msg_text => 'raising Invalid_Dataset_Code');
2550: END;
2551:
2552: IF pv_budget_id <> v_ds_budget_id THEN
2553:
2554: FEM_ENGINES_PKG.Tech_Message
2555: (p_severity => pc_log_level_statement,
2556: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2557: 'validate_budget.ibds1.',
2558: p_msg_text => 'raising Invalid_Budget_or_Dataset');
2562: END IF;
2563:
2564: -- Successful completion
2565:
2566: FEM_ENGINES_PKG.Tech_Message
2567: (p_severity => pc_log_level_procedure,
2568: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2569: 'validate_budget.end',
2570: p_msg_text => 'END');
2611: v_cp_exists_in_hier VARCHAR2(1);
2612:
2613: BEGIN
2614:
2615: FEM_ENGINES_PKG.Tech_Message
2616: (p_severity => pc_log_level_procedure,
2617: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2618: 'validate_cal_period.begin',
2619: p_msg_text => 'BEGIN');
2629: WHERE cal_period_id = pv_cal_period_id
2630: AND enabled_flag = 'Y'
2631: AND personal_flag = 'N';
2632:
2633: FEM_ENGINES_PKG.Tech_Message
2634: (p_severity => pc_log_level_statement,
2635: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2636: 'validate_cal_period.pv_cal_per_calendar_id',
2637: p_app_name => 'FEM',
2645: INTO pv_cal_per_dim_grp_dsp_cd
2646: FROM fem_dimension_grps_b
2647: WHERE dimension_group_id = v_cal_per_dim_group_id;
2648:
2649: FEM_ENGINES_PKG.Tech_Message
2650: (p_severity => pc_log_level_statement,
2651: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2652: 'validate_cal_period.pv_cal_per_dim_grp_dsp_cd',
2653: p_app_name => 'FEM',
2659:
2660: EXCEPTION
2661: WHEN NO_DATA_FOUND THEN
2662:
2663: FEM_ENGINES_PKG.Tech_Message
2664: (p_severity => pc_log_level_statement,
2665: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2666: 'validate_cal_period.icpid1.',
2667: p_msg_text => 'raising Invalid_Cal_Period_ID');
2672: -- Compare the Cal Period Calendar ID and the Ledger Calendar ID.
2673:
2674: IF pv_cal_per_calendar_id <> pv_ledger_calendar_id THEN
2675:
2676: FEM_ENGINES_PKG.Tech_Message
2677: (p_severity => pc_log_level_statement,
2678: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2679: 'validate_cal_period.lcneqpc.',
2680: p_msg_text => 'raising Ledger_Cal_NEQ_Period_Cal');
2696: p_attr_label => 'CAL_PERIOD_END_DATE');
2697:
2698: IF pv_API_return_code > 0 THEN
2699:
2700: FEM_ENGINES_PKG.Tech_Message
2701: (p_severity => pc_log_level_statement,
2702: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2703: 'validate_cal_period.icpid2.',
2704: p_msg_text => 'raising Invalid_Cal_Period_ID');
2713: WHERE attribute_id = pv_dim_attr_id
2714: AND version_id = pv_dim_attr_ver_id
2715: AND cal_period_id = pv_cal_period_id;
2716:
2717: FEM_ENGINES_PKG.Tech_Message
2718: (p_severity => pc_log_level_statement,
2719: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2720: 'validate_cal_period.pv_cal_per_end_date',
2721: p_app_name => 'FEM',
2727:
2728: EXCEPTION
2729: WHEN NO_DATA_FOUND THEN
2730:
2731: FEM_ENGINES_PKG.Tech_Message
2732: (p_severity => pc_log_level_statement,
2733: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2734: 'validate_cal_period.icpid3.',
2735: p_msg_text => 'raising Invalid_Cal_Period_ID');
2750: p_attr_label => 'GL_PERIOD_NUM');
2751:
2752: IF pv_API_return_code > 0 THEN
2753:
2754: FEM_ENGINES_PKG.Tech_Message
2755: (p_severity => pc_log_level_statement,
2756: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2757: 'validate_cal_period.icpid4.',
2758: p_msg_text => 'raising Invalid_Cal_Period_ID');
2767: WHERE attribute_id = pv_dim_attr_id
2768: AND version_id = pv_dim_attr_ver_id
2769: AND cal_period_id = pv_cal_period_id;
2770:
2771: FEM_ENGINES_PKG.Tech_Message
2772: (p_severity => pc_log_level_statement,
2773: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2774: 'validate_cal_period.pv_gl_per_number',
2775: p_app_name => 'FEM',
2781:
2782: EXCEPTION
2783: WHEN NO_DATA_FOUND THEN
2784:
2785: FEM_ENGINES_PKG.Tech_Message
2786: (p_severity => pc_log_level_statement,
2787: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2788: 'validate_cal_period.icpid5.',
2789: p_msg_text => 'raising Invalid_Cal_Period_ID');
2792: END;
2793:
2794: -- Successful completion
2795:
2796: FEM_ENGINES_PKG.Tech_Message
2797: (p_severity => pc_log_level_procedure,
2798: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2799: 'validate_cal_period.end',
2800: p_msg_text => 'END');
2831: v_rowcount PLS_INTEGER;
2832:
2833: BEGIN
2834:
2835: FEM_ENGINES_PKG.Tech_Message
2836: (p_severity => pc_log_level_procedure,
2837: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2838: 'validate_dataset.begin',
2839: p_msg_text => 'BEGIN');
2849: AND personal_flag = 'N';
2850:
2851: IF v_rowcount <> 1 THEN
2852:
2853: FEM_ENGINES_PKG.Tech_Message
2854: (p_severity => pc_log_level_statement,
2855: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2856: 'validate_dataset.idsc7.',
2857: p_msg_text => 'raising Invalid_Dataset_Code');
2872: p_attr_label => 'DATASET_BALANCE_TYPE_CODE');
2873:
2874: IF pv_API_return_code > 0 THEN
2875:
2876: FEM_ENGINES_PKG.Tech_Message
2877: (p_severity => pc_log_level_statement,
2878: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2879: 'validate_dataset.idsc8.',
2880: p_msg_text => 'raising Invalid_Dataset_Code');
2889: WHERE attribute_id = pv_dim_attr_id
2890: AND version_id = pv_dim_attr_ver_id
2891: AND dataset_code = pv_dataset_code;
2892:
2893: FEM_ENGINES_PKG.Tech_Message
2894: (p_severity => pc_log_level_statement,
2895: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2896: 'validate_dataset.pv_ds_balance_type_cd',
2897: p_app_name => 'FEM',
2903:
2904: EXCEPTION
2905: WHEN NO_DATA_FOUND THEN
2906:
2907: FEM_ENGINES_PKG.Tech_Message
2908: (p_severity => pc_log_level_statement,
2909: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2910: 'validate_dataset.idsc9.',
2911: p_msg_text => 'raising Invalid_Dataset_Code');
2914: END;
2915:
2916: -- Successful completion
2917:
2918: FEM_ENGINES_PKG.Tech_Message
2919: (p_severity => pc_log_level_procedure,
2920: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2921: 'validate_dataset.end',
2922: p_msg_text => 'END');
2955: -- =======================================================================
2956:
2957: BEGIN
2958:
2959: FEM_ENGINES_PKG.Tech_Message
2960: (p_severity => pc_log_level_procedure,
2961: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
2962: 'validate_ds_bal_type.begin',
2963: p_msg_text => 'BEGIN');
3046: END IF;
3047:
3048: IF pv_precedent_dataset_code > 0 THEN
3049:
3050: FEM_ENGINES_PKG.Tech_Message
3051: (p_severity => pc_log_level_statement,
3052: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3053: 'validate_ds_bal_type.idsbt.',
3054: p_msg_text => 'raising Invalid_DS_Bal_Type');
3058: END IF;
3059:
3060: -- Successful completion
3061:
3062: FEM_ENGINES_PKG.Tech_Message
3063: (p_severity => pc_log_level_procedure,
3064: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3065: 'validate_ds_bal_type.end',
3066: p_msg_text => 'END');
3098: v_ds_enc_type_id fem_datasets_attr.dim_attribute_numeric_member%TYPE;
3099:
3100: BEGIN
3101:
3102: FEM_ENGINES_PKG.Tech_Message
3103: (p_severity => pc_log_level_procedure,
3104: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3105: 'validate_encumbrance_type.begin',
3106: p_msg_text => 'BEGIN');
3117: WHERE encumbrance_type_id = pv_enc_type_id
3118: AND enabled_flag = 'Y'
3119: AND personal_flag = 'N';
3120:
3121: FEM_ENGINES_PKG.Tech_Message
3122: (p_severity => pc_log_level_statement,
3123: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3124: 'validate_encumbrance_type.pv_enc_type_dsp_cd',
3125: p_app_name => 'FEM',
3131:
3132: EXCEPTION
3133: WHEN NO_DATA_FOUND THEN
3134:
3135: FEM_ENGINES_PKG.Tech_Message
3136: (p_severity => pc_log_level_statement,
3137: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3138: 'validate_encumbrance_type.ietid1.',
3139: p_msg_text => 'raising Invalid_Enc_Type_ID');
3155: p_attr_label => 'ENCUMBRANCE_TYPE_ID');
3156:
3157: IF pv_API_return_code > 0 THEN
3158:
3159: FEM_ENGINES_PKG.Tech_Message
3160: (p_severity => pc_log_level_statement,
3161: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3162: 'validate_encumbrance_type.idsc3.',
3163: p_msg_text => 'raising Invalid_Dataset_Code');
3175:
3176: EXCEPTION
3177: WHEN NO_DATA_FOUND THEN
3178:
3179: FEM_ENGINES_PKG.Tech_Message
3180: (p_severity => pc_log_level_statement,
3181: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3182: 'validate_encumbrance_type.idsc4.',
3183: p_msg_text => 'raising Invalid_Dataset_Code');
3186: END;
3187:
3188: IF pv_enc_type_id <> v_ds_enc_type_id THEN
3189:
3190: FEM_ENGINES_PKG.Tech_Message
3191: (p_severity => pc_log_level_statement,
3192: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3193: 'validate_encumbrance_type.ieds1.',
3194: p_msg_text => 'raising Invalid_Enc_or_Dataset');
3198: END IF;
3199:
3200: -- Successful completion
3201:
3202: FEM_ENGINES_PKG.Tech_Message
3203: (p_severity => pc_log_level_procedure,
3204: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3205: 'validate_encumbrance_type.end',
3206: p_msg_text => 'END');
3243: -- =======================================================================
3244:
3245: BEGIN
3246:
3247: FEM_ENGINES_PKG.Tech_Message
3248: (p_severity => pc_log_level_procedure,
3249: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3250: 'validate_ledger.begin',
3251: p_msg_text => 'BEGIN');
3261: WHERE ledger_id = pv_ledger_id
3262: AND enabled_flag = 'Y'
3263: AND personal_flag = 'N';
3264:
3265: FEM_ENGINES_PKG.Tech_Message
3266: (p_severity => pc_log_level_statement,
3267: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3268: 'validate_ledger.pv_ledger_dsp_cd',
3269: p_app_name => 'FEM',
3275:
3276: EXCEPTION
3277: WHEN NO_DATA_FOUND THEN
3278:
3279: FEM_ENGINES_PKG.Tech_Message
3280: (p_severity => pc_log_level_statement,
3281: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3282: 'validate_ledger.ilid1.',
3283: p_msg_text => 'raising Invalid_Ledger_ID');
3298: p_attr_label => 'ENTERED_CRNCY_ENABLE_FLAG');
3299:
3300: IF pv_API_return_code > 0 THEN
3301:
3302: FEM_ENGINES_PKG.Tech_Message
3303: (p_severity => pc_log_level_statement,
3304: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3305: 'validate_ledger.ilid7.',
3306: p_msg_text => 'raising Invalid_Ledger_ID');
3317: WHERE attribute_id = pv_dim_attr_id
3318: AND version_id = pv_dim_attr_ver_id
3319: AND ledger_id = pv_ledger_id;
3320:
3321: FEM_ENGINES_PKG.Tech_Message
3322: (p_severity => pc_log_level_statement,
3323: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3324: 'validate_ledger.pv_entered_crncy_flag',
3325: p_app_name => 'FEM',
3331:
3332: EXCEPTION
3333: WHEN NO_DATA_FOUND THEN
3334:
3335: FEM_ENGINES_PKG.Tech_Message
3336: (p_severity => pc_log_level_statement,
3337: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3338: 'validate_ledger.ilid8.',
3339: p_msg_text => 'raising Invalid_Ledger_ID');
3356: p_attr_label => 'CAL_PERIOD_HIER_OBJ_DEF_ID');
3357:
3358: IF pv_API_return_code> 0 THEN
3359:
3360: FEM_ENGINES_PKG.Tech_Message
3361: (p_severity => pc_log_level_statement,
3362: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3363: 'validate_ledger.ilid4.',
3364: p_msg_text => 'raising Invalid_Ledger_ID');
3375: WHERE attribute_id = pv_dim_attr_id
3376: AND version_id = pv_dim_attr_ver_id
3377: AND ledger_id = pv_ledger_id;
3378:
3379: FEM_ENGINES_PKG.Tech_Message
3380: (p_severity => pc_log_level_statement,
3381: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3382: 'validate_ledger.pv_lph_odid',
3383: p_app_name => 'FEM',
3391: INTO pv_ledger_per_hier_obj_id
3392: FROM fem_object_definition_b
3393: WHERE object_definition_id = pv_ledger_per_hier_obj_def_id;
3394:
3395: FEM_ENGINES_PKG.Tech_Message
3396: (p_severity => pc_log_level_statement,
3397: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3398: 'validate_ledger.pv_lph_oid',
3399: p_app_name => 'FEM',
3405:
3406: EXCEPTION
3407: WHEN NO_DATA_FOUND THEN
3408:
3409: FEM_ENGINES_PKG.Tech_Message
3410: (p_severity => pc_log_level_statement,
3411: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3412: 'validate_ledger.ilid5.',
3413: p_msg_text => 'raising Invalid_Ledger_ID');
3425: INTO pv_ledger_calendar_id
3426: FROM fem_hierarchies
3427: WHERE hierarchy_obj_id = pv_ledger_per_hier_obj_id;
3428:
3429: FEM_ENGINES_PKG.Tech_Message
3430: (p_severity => pc_log_level_statement,
3431: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3432: 'validate_ledger.pv_ledger_calendar_id',
3433: p_app_name => 'FEM',
3439:
3440: EXCEPTION
3441: WHEN NO_DATA_FOUND THEN
3442:
3443: FEM_ENGINES_PKG.Tech_Message
3444: (p_severity => pc_log_level_statement,
3445: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3446: 'validate_ledger.ilid6.',
3447: p_msg_text => 'raising Invalid_Ledger_ID');
3465: p_attr_label => 'LEDGER_FUNCTIONAL_CRNCY_CODE');
3466:
3467: IF pv_API_return_code > 0 THEN
3468:
3469: FEM_ENGINES_PKG.Tech_Message
3470: (p_severity => pc_log_level_statement,
3471: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3472: 'validate_ledger.ilid9.',
3473: p_msg_text => 'raising Invalid_Ledger_ID');
3484: WHERE attribute_id = pv_dim_attr_id
3485: AND version_id = pv_dim_attr_ver_id
3486: AND ledger_id = pv_ledger_id;
3487:
3488: FEM_ENGINES_PKG.Tech_Message
3489: (p_severity => pc_log_level_statement,
3490: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3491: 'validate_ledger.pv_func_ccy_code',
3492: p_app_name => 'FEM',
3498:
3499: EXCEPTION
3500: WHEN NO_DATA_FOUND THEN
3501:
3502: FEM_ENGINES_PKG.Tech_Message
3503: (p_severity => pc_log_level_statement,
3504: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3505: 'validate_ledger.ilid10.',
3506: p_msg_text => 'raising Invalid_Ledger_ID');
3523: p_attr_label => 'GLOBAL_VS_COMBO');
3524:
3525: IF pv_API_return_code > 0 THEN
3526:
3527: FEM_ENGINES_PKG.Tech_Message
3528: (p_severity => pc_log_level_statement,
3529: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3530: 'validate_ledger.ilid11.',
3531: p_msg_text => 'raising Invalid_Ledger_ID');
3542: WHERE attribute_id = pv_dim_attr_id
3543: AND version_id = pv_dim_attr_ver_id
3544: AND ledger_id = pv_ledger_id;
3545:
3546: FEM_ENGINES_PKG.Tech_Message
3547: (p_severity => pc_log_level_statement,
3548: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3549: 'validate_ledger.pv_global_vs_combo_id',
3550: p_app_name => 'FEM',
3556:
3557: EXCEPTION
3558: WHEN NO_DATA_FOUND THEN
3559:
3560: FEM_ENGINES_PKG.Tech_Message
3561: (p_severity => pc_log_level_statement,
3562: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3563: 'validate_ledger.ilid12.',
3564: p_msg_text => 'raising Invalid_Ledger_ID');
3569: END;
3570:
3571: -- Successful completion
3572:
3573: FEM_ENGINES_PKG.Tech_Message
3574: (p_severity => pc_log_level_procedure,
3575: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3576: 'validate_ledger.end',
3577: p_msg_text => 'END');
3618: v_rowcount PLS_INTEGER;
3619:
3620: BEGIN
3621:
3622: FEM_ENGINES_PKG.Tech_Message
3623: (p_severity => pc_log_level_procedure,
3624: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3625: 'validate_object_def_id.begin',
3626: p_msg_text => 'BEGIN');
3637: FROM fem_object_definition_b
3638: WHERE object_definition_id = pv_rule_obj_def_id
3639: AND old_approved_copy_flag = 'N';
3640:
3641: FEM_ENGINES_PKG.Tech_Message
3642: (p_severity => pc_log_level_statement,
3643: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3644: 'validate_object_def_id.pv_rule_obj_id',
3645: p_app_name => 'FEM',
3648: p_value1 => 'pv_rule_obj_id',
3649: p_token2 => 'VAR_VAL',
3650: p_value2 => TO_CHAR(pv_rule_obj_id));
3651:
3652: FEM_ENGINES_PKG.Tech_Message
3653: (p_severity => pc_log_level_statement,
3654: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3655: 'validate_object_def_id.v_obj_approval_status_cd',
3656: p_app_name => 'FEM',
3662:
3663: EXCEPTION
3664: WHEN NO_DATA_FOUND THEN
3665:
3666: FEM_ENGINES_PKG.Tech_Message
3667: (p_severity => pc_log_level_statement,
3668: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3669: 'validate_object_def_id.iodid1.',
3670: p_msg_text => 'raising Invalid_Object_Def_ID');
3682: INTO pv_obj_type_cd, v_folder_id
3683: FROM fem_object_catalog_b
3684: WHERE object_id = pv_rule_obj_id;
3685:
3686: FEM_ENGINES_PKG.Tech_Message
3687: (p_severity => pc_log_level_statement,
3688: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3689: 'validate_object_def_id.pv_obj_type_cd',
3690: p_app_name => 'FEM',
3693: p_value1 => 'pv_obj_type_cd',
3694: p_token2 => 'VAR_VAL',
3695: p_value2 => pv_obj_type_cd);
3696:
3697: FEM_ENGINES_PKG.Tech_Message
3698: (p_severity => pc_log_level_statement,
3699: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3700: 'validate_object_def_id.v_folder_id',
3701: p_app_name => 'FEM',
3707:
3708: EXCEPTION
3709: WHEN NO_DATA_FOUND THEN
3710:
3711: FEM_ENGINES_PKG.Tech_Message
3712: (p_severity => pc_log_level_statement,
3713: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3714: 'validate_object_def_id.iobj1.',
3715: p_msg_text => 'raising Invalid_Object_ID');
3744: p_attr_label => 'PRODUCTION_FLAG');
3745:
3746: IF pv_API_return_code > 0 THEN
3747:
3748: FEM_ENGINES_PKG.Tech_Message
3749: (p_severity => pc_log_level_statement,
3750: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3751: 'validate_object_def_id.idsc5.',
3752: p_msg_text => 'raising Invalid_Dataset_Code');
3772:
3773: IF (v_ds_production_flag = 'Y') AND
3774: (v_obj_approval_status_cd <> 'APPROVED') THEN
3775:
3776: FEM_ENGINES_PKG.Tech_Message
3777: (p_severity => pc_log_level_statement,
3778: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3779: 'validate_object_def_id.ioas1.',
3780: p_msg_text => 'raising Invalid_Obj_Approval_Status');
3785:
3786: END IF; -- IF pv_obj_type_cd = 'XGL_INTEGRATION' THEN
3787:
3788: -- Successful completion
3789: FEM_ENGINES_PKG.Tech_Message
3790: (p_severity => pc_log_level_procedure,
3791: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3792: 'validate_object_def_id.end',
3793: p_msg_text => 'END');
3855: x_completion_code := 2;
3856: pv_proc_name := 'validate_engine_parameters';
3857: pv_attr_label := NULL;
3858:
3859: FEM_ENGINES_PKG.Tech_Message
3860: (p_severity => pc_log_level_procedure,
3861: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3862: 'validate_engine_parameters.begin',
3863: p_msg_text => 'BEGIN');
3869: IF pv_exec_mode NOT IN ('S', 'I', 'E') THEN
3870:
3871: -- Execution mode is invalid
3872:
3873: FEM_ENGINES_PKG.Tech_Message
3874: (p_severity => pc_log_level_statement,
3875: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3876: 'validate_engine_parameters.iem',
3877: p_msg_text => 'raising Invalid_Execution_Mode');
3890: pv_login_id := FND_GLOBAL.Login_Id;
3891: pv_pgm_id := FND_GLOBAL.Conc_Program_Id;
3892: pv_pgm_app_id := FND_GLOBAL.Prog_Appl_ID;
3893:
3894: FEM_ENGINES_PKG.Tech_Message
3895: (p_severity => pc_log_level_statement,
3896: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3897: 'validate_engine_parameters.pv_req_id',
3898: p_app_name => 'FEM',
3901: p_value1 => 'pv_req_id',
3902: p_token2 => 'VAR_VAL',
3903: p_value2 => TO_CHAR(pv_req_id));
3904:
3905: FEM_ENGINES_PKG.Tech_Message
3906: (p_severity => pc_log_level_statement,
3907: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3908: 'validate_engine_parameters.pv_user_id',
3909: p_app_name => 'FEM',
3912: p_value1 => 'pv_user_id',
3913: p_token2 => 'VAR_VAL',
3914: p_value2 => TO_CHAR(pv_user_id));
3915:
3916: FEM_ENGINES_PKG.Tech_Message
3917: (p_severity => pc_log_level_statement,
3918: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3919: 'validate_engine_parameters.pv_login_id',
3920: p_app_name => 'FEM',
3923: p_value1 => 'pv_login_id',
3924: p_token2 => 'VAR_VAL',
3925: p_value2 => TO_CHAR(pv_login_id));
3926:
3927: FEM_ENGINES_PKG.Tech_Message
3928: (p_severity => pc_log_level_statement,
3929: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3930: 'validate_engine_parameters.pv_pgm_id',
3931: p_app_name => 'FEM',
3977:
3978: IF (pv_budget_id IS NOT NULL) OR
3979: (pv_enc_type_id IS NOT NULL) THEN
3980:
3981: FEM_ENGINES_PKG.Tech_Message
3982: (p_severity => pc_log_level_error,
3983: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
3984: 'validate_engine_parameters.budget_enc_ignored',
3985: p_app_name => 'FEM',
3984: 'validate_engine_parameters.budget_enc_ignored',
3985: p_app_name => 'FEM',
3986: p_msg_name => 'FEM_GL_POST_023');
3987:
3988: FEM_ENGINES_PKG.User_Message
3989: (p_app_name => 'FEM',
3990: p_msg_name => 'FEM_GL_POST_023');
3991:
3992: pv_budget_id := NULL;
4000: Validate_Budget;
4001:
4002: IF pv_enc_type_id IS NOT NULL THEN
4003:
4004: FEM_ENGINES_PKG.Tech_Message
4005: (p_severity => pc_log_level_error,
4006: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4007: 'validate_engine_parameters.enc_type_ignored',
4008: p_app_name => 'FEM',
4007: 'validate_engine_parameters.enc_type_ignored',
4008: p_app_name => 'FEM',
4009: p_msg_name => 'FEM_GL_POST_020');
4010:
4011: FEM_ENGINES_PKG.User_Message
4012: (p_app_name => 'FEM',
4013: p_msg_name => 'FEM_GL_POST_020');
4014:
4015: pv_enc_type_id := NULL;
4022: Validate_Encumbrance_Type;
4023:
4024: IF pv_budget_id IS NOT NULL THEN
4025:
4026: FEM_ENGINES_PKG.Tech_Message
4027: (p_severity => pc_log_level_error,
4028: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4029: 'validate_engine_parameters.budget_id_ignored',
4030: p_app_name => 'FEM',
4029: 'validate_engine_parameters.budget_id_ignored',
4030: p_app_name => 'FEM',
4031: p_msg_name => 'FEM_GL_POST_021');
4032:
4033: FEM_ENGINES_PKG.User_Message
4034: (p_app_name => 'FEM',
4035: p_msg_name => 'FEM_GL_POST_021');
4036:
4037: pv_budget_id := NULL;
4050: IF x_completion_code <> 1 THEN
4051: x_completion_code := 0;
4052: END IF;
4053:
4054: FEM_ENGINES_PKG.Tech_Message
4055: (p_severity => pc_log_level_procedure,
4056: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4057: 'validate_engine_parameters.end',
4058: p_msg_text => 'END');
4085: IF v_attr_name IS NULL THEN
4086: v_attr_name := 'Budget Ledger';
4087: END IF;
4088:
4089: FEM_ENGINES_PKG.Tech_Message
4090: (p_severity => pc_log_level_error,
4091: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4092: pv_proc_name || '.invalid_budget_id',
4093: p_app_name => 'FEM',
4098: p_value2 => v_dim_name1,
4099: p_token3 => 'ATTRIBUTE_NAME',
4100: p_value3 => v_attr_name);
4101:
4102: FEM_ENGINES_PKG.User_Message
4103: (p_app_name => 'FEM',
4104: p_msg_name => 'FEM_GL_POST_003',
4105: p_token1 => 'DIMENSION_NAME1',
4106: p_value1 => v_dim_name1,
4114: -- Invalid Budget or Dataset parameter: Budget does not match
4115: -- Dataset attribute "Budget ID".
4116: ------------------------------------------------------------------
4117:
4118: FEM_ENGINES_PKG.Tech_Message
4119: (p_severity => pc_log_level_error,
4120: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4121: pv_proc_name || '.invalid_budget_or_dataset',
4122: p_app_name => 'FEM',
4121: pv_proc_name || '.invalid_budget_or_dataset',
4122: p_app_name => 'FEM',
4123: p_msg_name => 'FEM_GL_POST_007');
4124:
4125: FEM_ENGINES_PKG.User_Message
4126: (p_app_name => 'FEM',
4127: p_msg_name => 'FEM_GL_POST_007');
4128:
4129: WHEN Invalid_Cal_Period_ID THEN
4138: IF v_dim_name1 IS NULL THEN
4139: v_dim_name1 := 'Calendar Period';
4140: END IF;
4141:
4142: FEM_ENGINES_PKG.Tech_Message
4143: (p_severity => pc_log_level_error,
4144: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4145: pv_proc_name || '.invalid_cal_period_id',
4146: p_app_name => 'FEM',
4149: p_value1 => v_dim_name1,
4150: p_token2 => 'DIMENSION_NAME2',
4151: p_value2 => v_dim_name1);
4152:
4153: FEM_ENGINES_PKG.User_Message
4154: (p_app_name => 'FEM',
4155: p_msg_name => 'FEM_GL_POST_002',
4156: p_token1 => 'DIMENSION_NAME1',
4157: p_value1 => v_dim_name1,
4170: IF v_dim_name1 IS NULL THEN
4171: v_dim_name1 := 'Dataset';
4172: END IF;
4173:
4174: FEM_ENGINES_PKG.Tech_Message
4175: (p_severity => pc_log_level_error,
4176: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4177: pv_proc_name || '.invalid_dataset_code',
4178: p_app_name => 'FEM',
4181: p_value1 => v_dim_name1,
4182: p_token2 => 'DIMENSION_NAME2',
4183: p_value2 => v_dim_name1);
4184:
4185: FEM_ENGINES_PKG.User_Message
4186: (p_app_name => 'FEM',
4187: p_msg_name => 'FEM_GL_POST_002',
4188: p_token1 => 'DIMENSION_NAME1',
4189: p_value1 => v_dim_name1,
4250: v_ds_balance_type_string := v_ds_balance_type_name || ' ' || v_enc_type_name;
4251:
4252: END IF;
4253:
4254: FEM_ENGINES_PKG.Tech_Message
4255: (p_severity => pc_log_level_error,
4256: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4257: pv_proc_name || '.invalid_dataset_code',
4258: p_app_name => 'FEM',
4261: p_value1 => v_ds_balance_type_string,
4262: p_token2 => 'PRECEDENT_DATASET_NAME',
4263: p_value2 => v_precedent_dataset_name);
4264:
4265: FEM_ENGINES_PKG.User_Message
4266: (p_app_name => 'FEM',
4267: p_msg_name => 'FEM_GL_POST_026',
4268: p_token1 => 'DS_BAL_TYPE_NAME',
4269: p_value1 => v_ds_balance_type_string,
4281: IF v_dim_name1 IS NULL THEN
4282: v_dim_name1 := 'Encumbrance Type';
4283: END IF;
4284:
4285: FEM_ENGINES_PKG.Tech_Message
4286: (p_severity => pc_log_level_error,
4287: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4288: pv_proc_name || '.invalid_enc_type_id',
4289: p_app_name => 'FEM',
4290: p_msg_name => 'FEM_GL_POST_001',
4291: p_token1 => 'DIMENSION_NAME',
4292: p_value1 => v_dim_name1);
4293:
4294: FEM_ENGINES_PKG.User_Message
4295: (p_app_name => 'FEM',
4296: p_msg_name => 'FEM_GL_POST_001',
4297: p_token1 => 'DIMENSION_NAME',
4298: p_value1 => v_dim_name1);
4302: -- Invalid Encumbrance Type or Dataset parameter: Encumbrance Type
4303: -- does not match Dataset attribute "Dataset Encumbrance Type ID".
4304: ------------------------------------------------------------------
4305:
4306: FEM_ENGINES_PKG.Tech_Message
4307: (p_severity => pc_log_level_error,
4308: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4309: pv_proc_name || '.invalid_enc_or_dataset',
4310: p_app_name => 'FEM',
4309: pv_proc_name || '.invalid_enc_or_dataset',
4310: p_app_name => 'FEM',
4311: p_msg_name => 'FEM_GL_POST_009');
4312:
4313: FEM_ENGINES_PKG.User_Message
4314: (p_app_name => 'FEM',
4315: p_msg_name => 'FEM_GL_POST_009');
4316:
4317: WHEN Invalid_Execution_Mode THEN
4319: -- Invalid Execution Mode. Valid values are 'S' (Snapshot), 'I'
4320: -- (Incremental), and 'E' (Error Reprocessing Only).
4321: ------------------------------------------------------------------
4322:
4323: FEM_ENGINES_PKG.Tech_Message
4324: (p_severity => fnd_log.level_error,
4325: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4326: pv_proc_name || '.invalid_exec_mode',
4327: p_app_name => 'FEM',
4326: pv_proc_name || '.invalid_exec_mode',
4327: p_app_name => 'FEM',
4328: p_msg_name => 'FEM_GL_POST_014');
4329:
4330: FEM_ENGINES_PKG.Put_Message
4331: (p_app_name => 'FEM',
4332: p_msg_name => 'FEM_GL_POST_014');
4333:
4334: WHEN Invalid_Ledger_ID THEN
4347: END IF;
4348:
4349: IF pv_attr_label IS NULL THEN
4350:
4351: FEM_ENGINES_PKG.Tech_Message
4352: (p_severity => pc_log_level_error,
4353: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4354: pv_proc_name || '.invalid_ledger_id',
4355: p_app_name => 'FEM',
4356: p_msg_name => 'FEM_GL_POST_001',
4357: p_token1 => 'DIMENSION_NAME',
4358: p_value1 => v_dim_name1);
4359:
4360: FEM_ENGINES_PKG.User_Message
4361: (p_app_name => 'FEM',
4362: p_msg_name => 'FEM_GL_POST_001',
4363: p_token1 => 'DIMENSION_NAME',
4364: p_value1 => v_dim_name1);
4372: IF v_attr_name IS NULL THEN
4373: v_attr_name := pv_attr_label;
4374: END IF;
4375:
4376: FEM_ENGINES_PKG.Tech_Message
4377: (p_severity => pc_log_level_error,
4378: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4379: pv_proc_name || '.invalid_ledger_id',
4380: p_app_name => 'FEM',
4385: p_value2 => v_dim_name1,
4386: p_token3 => 'ATTRIBUTE_NAME',
4387: p_value3 => v_attr_name);
4388:
4389: FEM_ENGINES_PKG.User_Message
4390: (p_app_name => 'FEM',
4391: p_msg_name => 'FEM_GL_POST_003',
4392: p_token1 => 'DIMENSION_NAME1',
4393: p_value1 => v_dim_name1,
4403: -- Cannot process a "production" Dataset using an Object
4404: -- Definition that is not in "approved" status.
4405: ------------------------------------------------------------------
4406:
4407: FEM_ENGINES_PKG.Tech_Message
4408: (p_severity => pc_log_level_error,
4409: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4410: pv_proc_name || '.invalid_obj_approval_status',
4411: p_app_name => 'FEM',
4410: pv_proc_name || '.invalid_obj_approval_status',
4411: p_app_name => 'FEM',
4412: p_msg_name => 'FEM_GL_POST_005');
4413:
4414: FEM_ENGINES_PKG.User_Message
4415: (p_app_name => 'FEM',
4416: p_msg_name => 'FEM_GL_POST_005');
4417:
4418: WHEN Invalid_Object_ID THEN
4420: -- Invalid External GL Integration Rule: Value not found or rule
4421: -- has the wrong Object Type.
4422: ------------------------------------------------------------------
4423:
4424: FEM_ENGINES_PKG.Tech_Message
4425: (p_severity => pc_log_level_error,
4426: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4427: pv_proc_name || '.invalid_object_def_id',
4428: p_app_name => 'FEM',
4427: pv_proc_name || '.invalid_object_def_id',
4428: p_app_name => 'FEM',
4429: p_msg_name => 'FEM_GL_POST_010');
4430:
4431: FEM_ENGINES_PKG.User_Message
4432: (p_app_name => 'FEM',
4433: p_msg_name => 'FEM_GL_POST_010');
4434:
4435: WHEN Invalid_Object_Def_ID THEN
4436: ------------------------------------------------------------------
4437: -- Invalid Object Definition ID parameter: Value not found.
4438: ------------------------------------------------------------------
4439:
4440: FEM_ENGINES_PKG.Tech_Message
4441: (p_severity => pc_log_level_error,
4442: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4443: pv_proc_name || '.invalid_object_def_id',
4444: p_app_name => 'FEM',
4446: p_token1 => 'DIMENSION_NAME',
4447: p_value1 => 'FEM_OBJECT_DEF_ID_TXT',
4448: p_trans1 => 'Y');
4449:
4450: FEM_ENGINES_PKG.User_Message
4451: (p_app_name => 'FEM',
4452: p_msg_name => 'FEM_GL_POST_001',
4453: p_token1 => 'DIMENSION_NAME',
4454: p_value1 => 'FEM_OBJECT_DEF_ID_TXT',
4460: -- The Calendar assigned to the Ledger does not match
4461: -- the Calendar assigned to the Calendar Period.
4462: ------------------------------------------------------------------
4463:
4464: FEM_ENGINES_PKG.Tech_Message
4465: (p_severity => pc_log_level_error,
4466: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4467: pv_proc_name || '.ledger_cal_neq_period_cal',
4468: p_app_name => 'FEM',
4467: pv_proc_name || '.ledger_cal_neq_period_cal',
4468: p_app_name => 'FEM',
4469: p_msg_name => 'FEM_GL_POST_006');
4470:
4471: FEM_ENGINES_PKG.User_Message
4472: (p_app_name => 'FEM',
4473: p_msg_name => 'FEM_GL_POST_006');
4474:
4475: WHEN User_Not_Allowed THEN
4477: -- The current user is not allowed to execute this rule. The
4478: -- user must have access to the folder containing the rule.
4479: ------------------------------------------------------------------
4480:
4481: FEM_ENGINES_PKG.Tech_Message
4482: (p_severity => pc_log_level_error,
4483: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4484: pv_proc_name || '.user_not_allowed',
4485: p_app_name => 'FEM',
4484: pv_proc_name || '.user_not_allowed',
4485: p_app_name => 'FEM',
4486: p_msg_name => 'FEM_GL_POST_011');
4487:
4488: FEM_ENGINES_PKG.User_Message
4489: (p_app_name => 'FEM',
4490: p_msg_name => 'FEM_GL_POST_011');
4491:
4492: WHEN OTHERS THEN
4502:
4503: -- Log the call stack and the Oracle error message to
4504: -- FND_LOG with the "unexpected exception" severity level.
4505:
4506: FEM_ENGINES_PKG.Tech_Message
4507: (p_severity => pc_log_level_unexpected,
4508: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4509: pv_proc_name || '.unexpected_exception',
4510: p_msg_text => pv_sqlerrm);
4508: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4509: pv_proc_name || '.unexpected_exception',
4510: p_msg_text => pv_sqlerrm);
4511:
4512: FEM_ENGINES_PKG.Tech_Message
4513: (p_severity => pc_log_level_unexpected,
4514: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4515: pv_proc_name || '.unexpected_exception',
4516: p_msg_text => pv_callstack);
4516: p_msg_text => pv_callstack);
4517:
4518: -- Log the Oracle error message to the Concurrent Request Log.
4519:
4520: FEM_ENGINES_PKG.User_Message
4521: (p_app_name => 'FEM',
4522: p_msg_text => pv_sqlerrm);
4523:
4524: END Validate_Engine_Parameters;
4579: v_module := 'fem.plsql.fem_gl_post_process_pkg.validate_ogl_eng_parameters';
4580: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Validate_OGL_Eng_Parameters';
4581:
4582: -- Log the function entry time to FND_LOG
4583: FEM_ENGINES_PKG.Tech_Message
4584: (p_severity => pc_log_level_procedure,
4585: p_module => v_module,
4586: p_app_name => 'FEM',
4587: p_msg_name => 'FEM_GL_POST_201',
4602: -- Bug 4394404 hkaniven end - package variable to store the no of valid rows
4603:
4604: -- Set Request ID and then print its value to FND_LOG
4605: pv_req_id := FND_GLOBAL.Conc_Request_Id;
4606: FEM_ENGINES_PKG.Tech_Message
4607: (p_severity => pc_log_level_statement,
4608: p_module => v_module,
4609: p_app_name => 'FEM',
4610: p_msg_name => 'FEM_GL_POST_204',
4614: p_value2 => TO_CHAR(pv_req_id));
4615:
4616: -- Set User ID and then print its value to FND_LOG
4617: pv_user_id := FND_GLOBAL.User_Id;
4618: FEM_ENGINES_PKG.Tech_Message
4619: (p_severity => pc_log_level_statement,
4620: p_module => v_module,
4621: p_app_name => 'FEM',
4622: p_msg_name => 'FEM_GL_POST_204',
4626: p_value2 => TO_CHAR(pv_user_id));
4627:
4628: -- Set Login ID and then print its value to FND_LOG
4629: pv_login_id := FND_GLOBAL.Login_Id;
4630: FEM_ENGINES_PKG.Tech_Message
4631: (p_severity => pc_log_level_statement,
4632: p_module => v_module,
4633: p_app_name => 'FEM',
4634: p_msg_name => 'FEM_GL_POST_204',
4638: p_value2 => TO_CHAR(pv_login_id));
4639:
4640: -- Set Concurrent Program ID and then print its value to FND_LOG
4641: pv_pgm_id := FND_GLOBAL.Conc_Program_Id;
4642: FEM_ENGINES_PKG.Tech_Message
4643: (p_severity => pc_log_level_statement,
4644: p_module => v_module,
4645: p_app_name => 'FEM',
4646: p_msg_name => 'FEM_GL_POST_204',
4650: p_value2 => TO_CHAR(pv_pgm_id));
4651:
4652: -- Set Program Application ID and then print its value to FND_LOG
4653: pv_pgm_app_id := FND_GLOBAL.Prog_Appl_ID;
4654: FEM_ENGINES_PKG.Tech_Message
4655: (p_severity => pc_log_level_statement,
4656: p_module => v_module,
4657: p_app_name => 'FEM',
4658: p_msg_name => 'FEM_GL_POST_204',
4668: -- then error out
4669: IF (v_signage_method IS NULL)
4670: THEN
4671: -- Print the error message to FND_LOG and concurrent program log
4672: FEM_ENGINES_PKG.Tech_Message
4673: (p_severity => pc_log_level_event,
4674: p_module => v_module,
4675: p_app_name => 'FEM',
4676: p_msg_name => 'FEM_INTG_BAL_SIGN_PROF_NOT_SET');
4673: (p_severity => pc_log_level_event,
4674: p_module => v_module,
4675: p_app_name => 'FEM',
4676: p_msg_name => 'FEM_INTG_BAL_SIGN_PROF_NOT_SET');
4677: FEM_ENGINES_PKG.User_Message
4678: (p_app_name => 'FEM',
4679: p_msg_name => 'FEM_INTG_BAL_SIGN_PROF_NOT_SET');
4680:
4681: RAISE OGLEngParam_FatalErr;
4700: -- Bug 4294018 hkaniven end - Count the no of 'SIGN' attribute rows
4701:
4702: -- Bug 4294018 hkaniven start - If no 'SIGN' attribute rows then error out
4703: IF v_count = 0 THEN
4704: FEM_ENGINES_PKG.Tech_Message
4705: (p_severity => pc_log_level_event,
4706: p_module => v_module,
4707: p_app_name => 'FEM',
4708: p_msg_name => 'FEM_INTG_BAL_SIGN_CP_NOT_RUN');
4705: (p_severity => pc_log_level_event,
4706: p_module => v_module,
4707: p_app_name => 'FEM',
4708: p_msg_name => 'FEM_INTG_BAL_SIGN_CP_NOT_RUN');
4709: FEM_ENGINES_PKG.User_Message
4710: (p_app_name => 'FEM',
4711: p_msg_name => 'FEM_INTG_BAL_SIGN_CP_NOT_RUN');
4712:
4713: RAISE OGLEngParam_FatalErr;
4714: END IF;
4715: -- Bug 4294018 hkaniven end - If no 'SIGN' attribute rows then error out
4716:
4717: -- Log the signage method value
4718: FEM_ENGINES_PKG.Tech_Message
4719: (p_severity => pc_log_level_statement,
4720: p_module => v_module,
4721: p_app_name => 'FEM',
4722: p_msg_name => 'FEM_GL_POST_204',
4732: -- If it is not set, default it as 'N'
4733: IF (pv_adv_li_fe_mappings_flag IS NULL)
4734: THEN
4735: -- Print the warning message to FND_LOG and concurrent program log
4736: FEM_ENGINES_PKG.Tech_Message
4737: (p_severity => pc_log_level_event,
4738: p_module => v_module,
4739: p_app_name => 'FEM',
4740: p_msg_name => 'FEM_INTG_BAL_DEFAULT_ADV_MAP');
4737: (p_severity => pc_log_level_event,
4738: p_module => v_module,
4739: p_app_name => 'FEM',
4740: p_msg_name => 'FEM_INTG_BAL_DEFAULT_ADV_MAP');
4741: FEM_ENGINES_PKG.User_Message
4742: (p_app_name => 'FEM',
4743: p_msg_name => 'FEM_INTG_BAL_DEFAULT_ADV_MAP');
4744: -- Default it to No
4745: pv_adv_li_fe_mappings_flag := 'N';
4745: pv_adv_li_fe_mappings_flag := 'N';
4746: END IF;
4747:
4748: -- Log the advanced mapping flag value
4749: FEM_ENGINES_PKG.Tech_Message
4750: (p_severity => pc_log_level_statement,
4751: p_module => v_module,
4752: p_app_name => 'FEM',
4753: p_msg_name => 'FEM_GL_POST_204',
4761: INTO pv_gl_source_system_code
4762: FROM FEM_SOURCE_SYSTEMS_B
4763: WHERE SOURCE_SYSTEM_DISPLAY_CODE = 'OGL';
4764:
4765: FEM_ENGINES_PKG.Tech_Message
4766: (p_severity => pc_log_level_statement,
4767: p_module => v_module,
4768: p_app_name => 'FEM',
4769: p_msg_name => 'FEM_GL_POST_204',
4832: AND lgr.LEDGER_ID = balRule.LEDGER_ID;
4833: EXCEPTION
4834: WHEN NO_DATA_FOUND THEN
4835: -- The balances rule object definition is not found
4836: FEM_ENGINES_PKG.Tech_Message
4837: (p_severity => pc_log_level_statement,
4838: p_module => v_module,
4839: p_msg_text => 'Raising Invalid_Object_Def_ID exception');
4840: RAISE Invalid_Object_Def_ID;
4840: RAISE Invalid_Object_Def_ID;
4841: END;
4842:
4843: -- List out the balances rule setup to FND_LOG
4844: FEM_ENGINES_PKG.Tech_Message
4845: (p_severity => pc_log_level_statement,
4846: p_module => v_module,
4847: p_app_name => 'FEM',
4848: p_msg_name => 'FEM_GL_POST_204',
4849: p_token1 => 'VAR_NAME',
4850: p_value1 => 'pv_rule_obj_def_id',
4851: p_token2 => 'VAR_VAL',
4852: p_value2 => TO_CHAR(pv_rule_obj_def_id));
4853: FEM_ENGINES_PKG.Tech_Message
4854: (p_severity => pc_log_level_statement,
4855: p_module => v_module,
4856: p_app_name => 'FEM',
4857: p_msg_name => 'FEM_GL_POST_204',
4858: p_token1 => 'VAR_NAME',
4859: p_value1 => 'pv_rule_obj_def_name',
4860: p_token2 => 'VAR_VAL',
4861: p_value2 => pv_rule_obj_def_name);
4862: FEM_ENGINES_PKG.Tech_Message
4863: (p_severity => pc_log_level_statement,
4864: p_module => v_module,
4865: p_app_name => 'FEM',
4866: p_msg_name => 'FEM_GL_POST_204',
4867: p_token1 => 'VAR_NAME',
4868: p_value1 => 'pv_rule_obj_id',
4869: p_token2 => 'VAR_VAL',
4870: p_value2 => TO_CHAR(pv_rule_obj_id));
4871: FEM_ENGINES_PKG.Tech_Message
4872: (p_severity => pc_log_level_statement,
4873: p_module => v_module,
4874: p_app_name => 'FEM',
4875: p_msg_name => 'FEM_GL_POST_204',
4876: p_token1 => 'VAR_NAME',
4877: p_value1 => 'pv_ledger_id',
4878: p_token2 => 'VAR_VAL',
4879: p_value2 => TO_CHAR(pv_ledger_id));
4880: FEM_ENGINES_PKG.Tech_Message
4881: (p_severity => pc_log_level_statement,
4882: p_module => v_module,
4883: p_app_name => 'FEM',
4884: p_msg_name => 'FEM_GL_POST_204',
4885: p_token1 => 'VAR_NAME',
4886: p_value1 => 'pv_ledger_name',
4887: p_token2 => 'VAR_VAL',
4888: p_value2 => pv_ledger_name);
4889: FEM_ENGINES_PKG.Tech_Message
4890: (p_severity => pc_log_level_statement,
4891: p_module => v_module,
4892: p_app_name => 'FEM',
4893: p_msg_name => 'FEM_GL_POST_204',
4894: p_token1 => 'VAR_NAME',
4895: p_value1 => 'pv_coa_id',
4896: p_token2 => 'VAR_VAL',
4897: p_value2 => TO_CHAR(pv_coa_id));
4898: FEM_ENGINES_PKG.Tech_Message
4899: (p_severity => pc_log_level_statement,
4900: p_module => v_module,
4901: p_app_name => 'FEM',
4902: p_msg_name => 'FEM_GL_POST_204',
4903: p_token1 => 'VAR_NAME',
4904: p_value1 => 'pv_coa_name',
4905: p_token2 => 'VAR_VAL',
4906: p_value2 => pv_coa_name);
4907: FEM_ENGINES_PKG.Tech_Message
4908: (p_severity => pc_log_level_statement,
4909: p_module => v_module,
4910: p_app_name => 'FEM',
4911: p_msg_name => 'FEM_GL_POST_204',
4912: p_token1 => 'VAR_NAME',
4913: p_value1 => 'pv_bsv_app_col_name',
4914: p_token2 => 'VAR_VAL',
4915: p_value2 => pv_bsv_app_col_name);
4916: FEM_ENGINES_PKG.Tech_Message
4917: (p_severity => pc_log_level_statement,
4918: p_module => v_module,
4919: p_app_name => 'FEM',
4920: p_msg_name => 'FEM_GL_POST_204',
4921: p_token1 => 'VAR_NAME',
4922: p_value1 => 'pv_ds_balance_type_cd',
4923: p_token2 => 'VAR_VAL',
4924: p_value2 => pv_ds_balance_type_cd);
4925: FEM_ENGINES_PKG.Tech_Message
4926: (p_severity => pc_log_level_statement,
4927: p_module => v_module,
4928: p_app_name => 'FEM',
4929: p_msg_name => 'FEM_GL_POST_204',
4930: p_token1 => 'VAR_NAME',
4931: p_value1 => 'pv_include_avg_bal',
4932: p_token2 => 'VAR_VAL',
4933: p_value2 => pv_include_avg_bal);
4934: FEM_ENGINES_PKG.Tech_Message
4935: (p_severity => pc_log_level_statement,
4936: p_module => v_module,
4937: p_app_name => 'FEM',
4938: p_msg_name => 'FEM_GL_POST_204',
4939: p_token1 => 'VAR_NAME',
4940: p_value1 => 'pv_maintain_qtd_flag',
4941: p_token2 => 'VAR_VAL',
4942: p_value2 => pv_maintain_qtd_flag);
4943: FEM_ENGINES_PKG.Tech_Message
4944: (p_severity => pc_log_level_statement,
4945: p_module => v_module,
4946: p_app_name => 'FEM',
4947: p_msg_name => 'FEM_GL_POST_204',
4948: p_token1 => 'VAR_NAME',
4949: p_value1 => 'pv_exec_mode',
4950: p_token2 => 'VAR_VAL',
4951: p_value2 => pv_exec_mode);
4952: FEM_ENGINES_PKG.Tech_Message
4953: (p_severity => pc_log_level_statement,
4954: p_module => v_module,
4955: p_app_name => 'FEM',
4956: p_msg_name => 'FEM_GL_POST_204',
4957: p_token1 => 'VAR_NAME',
4958: p_value1 => 'pv_bsv_option',
4959: p_token2 => 'VAR_VAL',
4960: p_value2 => pv_bsv_option);
4961: FEM_ENGINES_PKG.Tech_Message
4962: (p_severity => pc_log_level_statement,
4963: p_module => v_module,
4964: p_app_name => 'FEM',
4965: p_msg_name => 'FEM_GL_POST_204',
4966: p_token1 => 'VAR_NAME',
4967: p_value1 => 'pv_curr_option',
4968: p_token2 => 'VAR_VAL',
4969: p_value2 => pv_curr_option);
4970: FEM_ENGINES_PKG.Tech_Message
4971: (p_severity => pc_log_level_statement,
4972: p_module => v_module,
4973: p_app_name => 'FEM',
4974: p_msg_name => 'FEM_GL_POST_204',
4975: p_token1 => 'VAR_NAME',
4976: p_value1 => 'pv_xlated_bal_option',
4977: p_token2 => 'VAR_VAL',
4978: p_value2 => pv_xlated_bal_option);
4979: FEM_ENGINES_PKG.Tech_Message
4980: (p_severity => pc_log_level_statement,
4981: p_module => v_module,
4982: p_app_name => 'FEM',
4983: p_msg_name => 'FEM_GL_POST_204',
4984: p_token1 => 'VAR_NAME',
4985: p_value1 => 'pv_dataset_code',
4986: p_token2 => 'VAR_VAL',
4987: p_value2 => pv_dataset_code);
4988: FEM_ENGINES_PKG.Tech_Message
4989: (p_severity => pc_log_level_statement,
4990: p_module => v_module,
4991: p_app_name => 'FEM',
4992: p_msg_name => 'FEM_GL_POST_204',
4993: p_token1 => 'VAR_NAME',
4994: p_value1 => 'pv_rule_eff_start_date',
4995: p_token2 => 'VAR_VAL',
4996: p_value2 => TO_CHAR(pv_rule_eff_start_date, 'DD-MON-YYYY'));
4997: FEM_ENGINES_PKG.Tech_Message
4998: (p_severity => pc_log_level_statement,
4999: p_module => v_module,
5000: p_app_name => 'FEM',
5001: p_msg_name => 'FEM_GL_POST_204',
5009:
5010: IF pv_obj_type_cd <> 'OGL_INTG_BAL_RULE'
5011: THEN
5012: -- It is not a FEM-OGL Integration Balances Rule
5013: FEM_ENGINES_PKG.Tech_Message
5014: (p_severity => pc_log_level_exception,
5015: p_module => v_module,
5016: p_msg_text => 'Raising Invalid_Object_ID exception');
5017:
5035: AND p.LEDGER_DISPLAY_CODE = 'OGL_SOURCE_LEDGER_GROUP';
5036: EXCEPTION
5037: WHEN NO_DATA_FOUND THEN
5038: -- The Ledger is not assigned to the source ledger group
5039: FEM_ENGINES_PKG.Tech_Message
5040: (p_severity => pc_log_level_error,
5041: p_module => v_module,
5042: p_app_name => 'FEM',
5043: p_msg_name => 'FEM_INTG_BAL_LG_NOT_IN_SRC',
5043: p_msg_name => 'FEM_INTG_BAL_LG_NOT_IN_SRC',
5044: p_token1 => 'LEDGER_NAME',
5045: p_value1 => pv_ledger_name);
5046:
5047: FEM_ENGINES_PKG.User_Message
5048: (p_app_name => 'FEM',
5049: p_msg_name => 'FEM_INTG_BAL_LG_NOT_IN_SRC',
5050: p_token1 => 'LEDGER_NAME',
5051: p_value1 => pv_ledger_name);
5064: -- this Ledger
5065: IF (pv_ledger_per_hier_obj_def_id = -1 OR pv_ledger_per_hier_obj_id = -1)
5066: THEN
5067: -- The Time Hierarchy Object ID/Object Def ID is wrong
5068: FEM_ENGINES_PKG.Tech_Message
5069: (p_severity => pc_log_level_error,
5070: p_module => v_module,
5071: p_app_name => 'FEM',
5072: p_msg_name => 'FEM_INTG_BAL_PER_HIER_ERR',
5072: p_msg_name => 'FEM_INTG_BAL_PER_HIER_ERR',
5073: p_token1 => 'LEDGER_NAME',
5074: p_value1 => pv_ledger_name);
5075:
5076: FEM_ENGINES_PKG.User_Message
5077: (p_app_name => 'FEM',
5078: p_msg_name => 'FEM_INTG_BAL_PER_HIER_ERR',
5079: p_token1 => 'LEDGER_NAME',
5080: p_value1 => pv_ledger_name);
5099: AND gvsc.GLOBAL_VS_COMBO_ID = pv_global_vs_combo_id);
5100: EXCEPTION
5101: WHEN NO_DATA_FOUND THEN
5102: -- No missing value-set-required dimensions
5103: FEM_ENGINES_PKG.Tech_Message
5104: (p_severity => pc_log_level_statement,
5105: p_module => v_module,
5106: p_msg_text => 'All Value-Set-Required dimensions are defined in the GVSC');
5107: END;
5108:
5109: IF (v_dummy_flag = 'X')
5110: THEN
5111: -- Incomplete the Global Value Set Comboination setup
5112: FEM_ENGINES_PKG.Tech_Message
5113: (p_severity => pc_log_level_error,
5114: p_module => v_module,
5115: p_app_name => 'FEM',
5116: p_msg_name => 'FEM_INTG_BAL_GVSC_ERR',
5116: p_msg_name => 'FEM_INTG_BAL_GVSC_ERR',
5117: p_token1 => 'COA_NAME',
5118: p_value1 => pv_coa_name);
5119:
5120: FEM_ENGINES_PKG.User_Message
5121: (p_app_name => 'FEM',
5122: p_msg_name => 'FEM_INTG_BAL_GVSC_ERR',
5123: p_token1 => 'COA_NAME',
5124: p_value1 => pv_coa_name);
5149: AND r.chart_of_accounts_id = pv_coa_id;
5150: EXCEPTION
5151: WHEN NO_DATA_FOUND THEN
5152: -- All non-processing key dimensions have SINGLEVAL dim rule versions
5153: FEM_ENGINES_PKG.Tech_Message
5154: (p_severity => pc_log_level_statement,
5155: p_module => v_module,
5156: p_msg_text => 'All non-processing key dimensions have SINGLEVAL dimension rule versions');
5157: END;
5158:
5159: IF (v_dummy_flag = 'X')
5160: THEN
5161: -- Invalid dimension rule setup for this COA
5162: FEM_ENGINES_PKG.Tech_Message
5163: (p_severity => pc_log_level_error,
5164: p_module => v_module,
5165: p_app_name => 'FEM',
5166: p_msg_name => 'FEM_INTG_BAL_DIM_RULE_ERR',
5166: p_msg_name => 'FEM_INTG_BAL_DIM_RULE_ERR',
5167: p_token1 => 'COA_NAME',
5168: p_value1 => pv_coa_name);
5169:
5170: FEM_ENGINES_PKG.User_Message
5171: (p_app_name => 'FEM',
5172: p_msg_name => 'FEM_INTG_BAL_DIM_RULE_ERR',
5173: p_token1 => 'COA_NAME',
5174: p_value1 => pv_coa_name);
5195: AND per.PERIOD_NAME = p_from_period;
5196: EXCEPTION
5197: WHEN NO_DATA_FOUND THEN
5198: -- The From Period is not a valid OGL period
5199: FEM_ENGINES_PKG.Tech_Message
5200: (p_severity => pc_log_level_error,
5201: p_module => v_module,
5202: p_app_name => 'FEM',
5203: p_msg_name => 'FEM_GL_POST_001',
5203: p_msg_name => 'FEM_GL_POST_001',
5204: p_token1 => 'DIMENSION_NAME',
5205: p_value1 => 'FEM_FROM_PERIOD_TXT',
5206: p_trans1 => 'Y');
5207: FEM_ENGINES_PKG.User_Message
5208: (p_app_name => 'FEM',
5209: p_msg_name => 'FEM_GL_POST_001',
5210: p_token1 => 'DIMENSION_NAME',
5211: p_value1 => 'FEM_FROM_PERIOD_TXT',
5213:
5214: Raise OGLEngParam_FatalErr;
5215: END;
5216:
5217: FEM_ENGINES_PKG.Tech_Message
5218: (p_severity => pc_log_level_statement,
5219: p_module => v_module,
5220: p_app_name => 'FEM',
5221: p_msg_name => 'FEM_GL_POST_204',
5241: AND per.PERIOD_NAME = p_to_period;
5242: EXCEPTION
5243: WHEN NO_DATA_FOUND THEN
5244: -- The To Period is not a valid OGL period
5245: FEM_ENGINES_PKG.Tech_Message
5246: (p_severity => pc_log_level_error,
5247: p_module => v_module,
5248: p_app_name => 'FEM',
5249: p_msg_name => 'FEM_GL_POST_001',
5249: p_msg_name => 'FEM_GL_POST_001',
5250: p_token1 => 'DIMENSION_NAME',
5251: p_value1 => 'FEM_TO_PERIOD_TXT',
5252: p_trans1 => 'Y');
5253: FEM_ENGINES_PKG.User_Message
5254: (p_app_name => 'FEM',
5255: p_msg_name => 'FEM_GL_POST_001',
5256: p_token1 => 'DIMENSION_NAME',
5257: p_value1 => 'FEM_TO_PERIOD_TXT',
5259:
5260: Raise OGLEngParam_FatalErr;
5261: END;
5262:
5263: FEM_ENGINES_PKG.Tech_Message
5264: (p_severity => pc_log_level_statement,
5265: p_module => v_module,
5266: p_app_name => 'FEM',
5267: p_msg_name => 'FEM_GL_POST_204',
5272:
5273: -- Validate the From Period must be earlier than or same as To Period
5274: IF (pv_from_period_eff_num > pv_to_period_eff_num)
5275: THEN
5276: FEM_ENGINES_PKG.Tech_Message
5277: (p_severity => pc_log_level_error,
5278: p_module => v_module,
5279: p_app_name => 'FEM',
5280: p_msg_name => 'FEM_INTG_BAL_PER_RANGE_ERR',
5281: p_token1 => 'FROM_PERIOD',
5282: p_value1 => p_from_period,
5283: p_token2 => 'TO_PERIOD',
5284: p_value2 => p_to_period);
5285: FEM_ENGINES_PKG.User_Message
5286: (p_app_name => 'FEM',
5287: p_msg_name => 'FEM_INTG_BAL_PER_RANGE_ERR',
5288: p_token1 => 'FROM_PERIOD',
5289: p_value1 => p_from_period,
5297: -- date range
5298: IF (pv_from_date < pv_rule_eff_start_date
5299: OR pv_to_date > pv_rule_eff_end_date)
5300: THEN
5301: FEM_ENGINES_PKG.Tech_Message
5302: (p_severity => pc_log_level_error,
5303: p_module => v_module,
5304: p_app_name => 'FEM',
5305: p_msg_name => 'FEM_INTG_BAL_RULE_NOT_EFF');
5302: (p_severity => pc_log_level_error,
5303: p_module => v_module,
5304: p_app_name => 'FEM',
5305: p_msg_name => 'FEM_INTG_BAL_RULE_NOT_EFF');
5306: FEM_ENGINES_PKG.User_Message
5307: (p_app_name => 'FEM',
5308: p_msg_name => 'FEM_INTG_BAL_RULE_NOT_EFF');
5309:
5310: Raise OGLEngParam_FatalErr;
5318: -- Period, we set it as the end date of the To Period
5319: p_effective_date := pv_to_date;
5320:
5321: -- Log a warning message to FND_LOG as well as the concurrent request log
5322: FEM_ENGINES_PKG.Tech_Message
5323: (p_severity => pc_log_level_event,
5324: p_module => v_module,
5325: p_app_name => 'FEM',
5326: p_msg_name => 'FEM_INTG_BAL_EFF_DATE_WARN');
5323: (p_severity => pc_log_level_event,
5324: p_module => v_module,
5325: p_app_name => 'FEM',
5326: p_msg_name => 'FEM_INTG_BAL_EFF_DATE_WARN');
5327: FEM_ENGINES_PKG.User_Message
5328: (p_app_name => 'FEM',
5329: p_msg_name => 'FEM_INTG_BAL_EFF_DATE_WARN');
5330: END IF; -- IF (pv_include_avg_bal = 'Y' ...
5331:
5334: -- ------------------------------------------------------------
5335: IF (p_bsv_range_low IS NOT NULL AND p_bsv_range_high IS NULL) OR
5336: (p_bsv_range_low IS NULL AND p_bsv_range_high IS NOT NULL) THEN
5337:
5338: FEM_ENGINES_PKG.Tech_Message
5339: (p_severity => pc_log_level_event,
5340: p_module => v_module,
5341: p_app_name => 'FEM',
5342: p_msg_name => 'FEM_INTG_BSV_ONE_NULL');
5339: (p_severity => pc_log_level_event,
5340: p_module => v_module,
5341: p_app_name => 'FEM',
5342: p_msg_name => 'FEM_INTG_BSV_ONE_NULL');
5343: FEM_ENGINES_PKG.User_Message
5344: (p_app_name => 'FEM',
5345: p_msg_name => 'FEM_INTG_BSV_ONE_NULL');
5346:
5347: Raise OGLEngParam_FatalErr;
5384: END;
5385:
5386: IF (v_dummy_flag = 'Y') THEN
5387:
5388: FEM_ENGINES_PKG.Tech_Message
5389: (p_severity => pc_log_level_event,
5390: p_module => v_module,
5391: p_app_name => 'FEM',
5392: p_msg_name => 'FEM_INTG_SNAPSHOT_LOAD_ERR');
5389: (p_severity => pc_log_level_event,
5390: p_module => v_module,
5391: p_app_name => 'FEM',
5392: p_msg_name => 'FEM_INTG_SNAPSHOT_LOAD_ERR');
5393: FEM_ENGINES_PKG.User_Message
5394: (p_app_name => 'FEM',
5395: p_msg_name => 'FEM_INTG_SNAPSHOT_LOAD_ERR');
5396:
5397: Raise OGLEngParam_FatalErr;
5540: END IF; -- IF (pv_ds_balance_type_cd = 'ACTUAL')
5541:
5542: -- Get the number of rows inserted and log it to FND_LOG
5543: pv_num_rows := SQL%ROWCOUNT;
5544: FEM_ENGINES_PKG.Tech_Message
5545: (p_severity => pc_log_level_statement,
5546: p_module => v_module,
5547: p_app_name => 'FEM',
5548: p_msg_name => 'FEM_GL_POST_216',
5556: -- No rows are inserted. It can be invalid budget/encumbrance type setup.
5557: -- If it is Actual balance type, it's impossible for them to get 0 rows.
5558: IF (pv_ds_balance_type_cd = 'BUDGET')
5559: THEN
5560: FEM_ENGINES_PKG.Tech_Message
5561: (p_severity => pc_log_level_error,
5562: p_module => v_module,
5563: p_app_name => 'FEM',
5564: p_msg_name => 'FEM_INTG_BAL_BGT_SETUP_ERR');
5561: (p_severity => pc_log_level_error,
5562: p_module => v_module,
5563: p_app_name => 'FEM',
5564: p_msg_name => 'FEM_INTG_BAL_BGT_SETUP_ERR');
5565: FEM_ENGINES_PKG.User_Message
5566: (p_app_name => 'FEM',
5567: p_msg_name => 'FEM_INTG_BAL_BGT_SETUP_ERR');
5568:
5569: ELSE -- i.e. Encumbrance Type
5566: (p_app_name => 'FEM',
5567: p_msg_name => 'FEM_INTG_BAL_BGT_SETUP_ERR');
5568:
5569: ELSE -- i.e. Encumbrance Type
5570: FEM_ENGINES_PKG.Tech_Message
5571: (p_severity => pc_log_level_error,
5572: p_module => v_module,
5573: p_app_name => 'FEM',
5574: p_msg_name => 'FEM_INTG_BAL_ECT_SETUP_ERR');
5571: (p_severity => pc_log_level_error,
5572: p_module => v_module,
5573: p_app_name => 'FEM',
5574: p_msg_name => 'FEM_INTG_BAL_ECT_SETUP_ERR');
5575: FEM_ENGINES_PKG.User_Message
5576: (p_app_name => 'FEM',
5577: p_msg_name => 'FEM_INTG_BAL_ECT_SETUP_ERR');
5578:
5579: END IF; -- IF (pv_ds_balance_type_cd = 'BUDGET')
5615: AND per.EFFECTIVE_PERIOD_NUM BETWEEN pv_from_period_eff_num
5616: AND pv_to_period_eff_num);
5617:
5618: -- Log the number of rows updated in FEM_INTG_EXEC_PARAMS_GT
5619: FEM_ENGINES_PKG.Tech_Message
5620: (p_severity => pc_log_level_statement,
5621: p_module => v_module,
5622: p_app_name => 'FEM',
5623: p_msg_name => 'FEM_GL_POST_217',
5638: -- generated when erroring out after this point
5639: x_generate_report_flag := 'Y';
5640:
5641: -- Log the number of rows updated in FEM_INTG_EXEC_PARAMS_GT
5642: FEM_ENGINES_PKG.Tech_Message
5643: (p_severity => pc_log_level_statement,
5644: p_module => v_module,
5645: p_app_name => 'FEM',
5646: p_msg_name => 'FEM_GL_POST_217',
5656: , pv_max_valid_period_eff_num
5657: FROM FEM_INTG_EXEC_PARAMS_GT
5658: WHERE ERROR_CODE IS NULL;
5659:
5660: FEM_ENGINES_PKG.Tech_Message
5661: (p_severity => pc_log_level_statement,
5662: p_module => v_module,
5663: p_app_name => 'FEM',
5664: p_msg_name => 'FEM_GL_POST_204',
5666: p_value1 => 'pv_min_valid_period_eff_num',
5667: p_token2 => 'VAR_VAL',
5668: p_value2 => TO_CHAR(pv_min_valid_period_eff_num));
5669:
5670: FEM_ENGINES_PKG.Tech_Message
5671: (p_severity => pc_log_level_statement,
5672: p_module => v_module,
5673: p_app_name => 'FEM',
5674: p_msg_name => 'FEM_GL_POST_204',
5692: IF (pv_min_valid_period_eff_num = -1)
5693: THEN
5694: -- All periods are invalid, so errors out
5695: -- Bug fix 4170124: The message is changed and doesn't have any tockens.
5696: FEM_ENGINES_PKG.Tech_Message
5697: (p_severity => pc_log_level_error,
5698: p_module => v_module,
5699: p_app_name => 'FEM',
5700: p_msg_name => 'FEM_INTG_BAL_NO_VALID_PER');
5697: (p_severity => pc_log_level_error,
5698: p_module => v_module,
5699: p_app_name => 'FEM',
5700: p_msg_name => 'FEM_INTG_BAL_NO_VALID_PER');
5701: FEM_ENGINES_PKG.User_Message
5702: (p_app_name => 'FEM',
5703: p_msg_name => 'FEM_INTG_BAL_NO_VALID_PER');
5704:
5705: Raise OGLEngParam_FatalErr;
5723: x_completion_code := 1;
5724:
5725: -- Log a warning message to FND_LOG as well as the concurrent request log
5726: -- Bug fix 4170124: The message is changed and doesn't have any tockens.
5727: FEM_ENGINES_PKG.Tech_Message
5728: (p_severity => pc_log_level_exception,
5729: p_module => v_module,
5730: p_app_name => 'FEM',
5731: p_msg_name => 'FEM_INTG_BAL_INVALID_PER');
5728: (p_severity => pc_log_level_exception,
5729: p_module => v_module,
5730: p_app_name => 'FEM',
5731: p_msg_name => 'FEM_INTG_BAL_INVALID_PER');
5732: FEM_ENGINES_PKG.User_Message
5733: (p_app_name => 'FEM',
5734: p_msg_name => 'FEM_INTG_BAL_INVALID_PER');
5735:
5736: END IF; -- IF (pv_min_valid_period_eff_num = -1)
5741: SELECT NVL(MAX(DELTA_RUN_ID), 0)
5742: INTO pv_max_delta_run_id
5743: FROM GL_BALANCES_DELTA;
5744:
5745: FEM_ENGINES_PKG.Tech_Message
5746: (p_severity => pc_log_level_statement,
5747: p_module => v_module,
5748: p_app_name => 'FEM',
5749: p_msg_name => 'FEM_GL_POST_204',
5756: -- 7. Exit with success/warning
5757: -- ----------------------------
5758:
5759: -- Log the function exit time to FND_LOG (successful completion)
5760: FEM_ENGINES_PKG.Tech_Message
5761: (p_severity => pc_log_level_procedure,
5762: p_module => v_module,
5763: p_app_name => 'FEM',
5764: p_msg_name => 'FEM_GL_POST_202',
5771: WHEN Invalid_Object_Def_ID THEN
5772: -- <<< Balances rule definition not found >>>
5773: x_completion_code := 2; -- Indicating fatal error
5774:
5775: FEM_ENGINES_PKG.Tech_Message
5776: (p_severity => pc_log_level_error,
5777: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5778: p_app_name => 'FEM',
5779: p_msg_name => 'FEM_GL_POST_001',
5779: p_msg_name => 'FEM_GL_POST_001',
5780: p_token1 => 'DIMENSION_NAME',
5781: p_value1 => 'FEM_OBJECT_DEF_ID_TXT',
5782: p_trans1 => 'Y');
5783: FEM_ENGINES_PKG.User_Message
5784: (p_app_name => 'FEM',
5785: p_msg_name => 'FEM_GL_POST_001',
5786: p_token1 => 'DIMENSION_NAME',
5787: p_value1 => 'FEM_OBJECT_DEF_ID_TXT',
5787: p_value1 => 'FEM_OBJECT_DEF_ID_TXT',
5788: p_trans1 => 'Y');
5789:
5790: -- Log the function exit time to FND_LOG (with error)
5791: FEM_ENGINES_PKG.Tech_Message
5792: (p_severity => pc_log_level_procedure,
5793: p_module => v_module,
5794: p_app_name => 'FEM',
5795: p_msg_name => 'FEM_GL_POST_203',
5801: WHEN Invalid_Object_ID THEN
5802: -- <<< Balances rule not found or wrong object type >>>
5803: x_completion_code := 2; -- Indicating fatal error
5804:
5805: FEM_ENGINES_PKG.Tech_Message
5806: (p_severity => pc_log_level_error,
5807: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5808: p_app_name => 'FEM',
5809: p_msg_name => 'FEM_INTG_BAL_INVALID_RULE');
5806: (p_severity => pc_log_level_error,
5807: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5808: p_app_name => 'FEM',
5809: p_msg_name => 'FEM_INTG_BAL_INVALID_RULE');
5810: FEM_ENGINES_PKG.User_Message
5811: (p_app_name => 'FEM',
5812: p_msg_name => 'FEM_INTG_BAL_INVALID_RULE');
5813:
5814: -- Log the function exit time to FND_LOG (with error)
5811: (p_app_name => 'FEM',
5812: p_msg_name => 'FEM_INTG_BAL_INVALID_RULE');
5813:
5814: -- Log the function exit time to FND_LOG (with error)
5815: FEM_ENGINES_PKG.Tech_Message
5816: (p_severity => pc_log_level_procedure,
5817: p_module => v_module,
5818: p_app_name => 'FEM',
5819: p_msg_name => 'FEM_GL_POST_203',
5825: WHEN User_Not_Allowed THEN
5826: -- <<< User not allowed to execute >>>
5827: x_completion_code := 2; -- Indicating fatal error
5828:
5829: FEM_ENGINES_PKG.Tech_Message
5830: (p_severity => pc_log_level_error,
5831: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5832: p_app_name => 'FEM',
5833: p_msg_name => 'FEM_GL_POST_011');
5830: (p_severity => pc_log_level_error,
5831: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5832: p_app_name => 'FEM',
5833: p_msg_name => 'FEM_GL_POST_011');
5834: FEM_ENGINES_PKG.User_Message
5835: (p_app_name => 'FEM',
5836: p_msg_name => 'FEM_GL_POST_011');
5837:
5838: -- Log the function exit time to FND_LOG (with error)
5835: (p_app_name => 'FEM',
5836: p_msg_name => 'FEM_GL_POST_011');
5837:
5838: -- Log the function exit time to FND_LOG (with error)
5839: FEM_ENGINES_PKG.Tech_Message
5840: (p_severity => pc_log_level_procedure,
5841: p_module => v_module,
5842: p_app_name => 'FEM',
5843: p_msg_name => 'FEM_GL_POST_203',
5871: THEN
5872: v_attr_name := pv_attr_label;
5873: END IF;
5874:
5875: FEM_ENGINES_PKG.Tech_Message
5876: (p_severity => pc_log_level_error,
5877: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5878: p_app_name => 'FEM',
5879: p_msg_name => 'FEM_INTG_BAL_LG_ATTR_ERR',
5882: p_token2 => 'LEDGER_NAME',
5883: p_value2 => pv_ledger_name,
5884: p_token3 => 'LEDGER_DIM',
5885: p_value3 => v_dim_name);
5886: FEM_ENGINES_PKG.User_Message
5887: (p_app_name => 'FEM',
5888: p_msg_name => 'FEM_INTG_BAL_LG_ATTR_ERR',
5889: p_token1 => 'ATTR_NAME',
5890: p_value1 => v_attr_name,
5894: p_value3 => v_dim_name);
5895:
5896: ELSE
5897: -- The Ledger cannot be found in FEM Ledger Dimension
5898: FEM_ENGINES_PKG.Tech_Message
5899: (p_severity => pc_log_level_error,
5900: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5901: p_app_name => 'FEM',
5902: p_msg_name => 'FEM_INTG_BAL_LG_ERR',
5903: p_token1 => 'LEDGER_NAME',
5904: p_value1 => pv_ledger_name,
5905: p_token2 => 'LEDGER_DIM',
5906: p_value2 => v_dim_name);
5907: FEM_ENGINES_PKG.User_Message
5908: (p_app_name => 'FEM',
5909: p_msg_name => 'FEM_INTG_BAL_LG_ERR',
5910: p_token1 => 'LEDGER_NAME',
5911: p_value1 => pv_ledger_name,
5914:
5915: END IF; -- IF pv_attr_label IS NOT NULL
5916:
5917: -- Log the function exit time to FND_LOG (with error)
5918: FEM_ENGINES_PKG.Tech_Message
5919: (p_severity => pc_log_level_procedure,
5920: p_module => v_module,
5921: p_app_name => 'FEM',
5922: p_msg_name => 'FEM_GL_POST_203',
5930: x_completion_code := 2; -- Indicating fatal error
5931:
5932: -- The error messages were printed, so just need to log the function exit
5933: -- time to FND_LOG (with error)
5934: FEM_ENGINES_PKG.Tech_Message
5935: (p_severity => pc_log_level_procedure,
5936: p_module => v_module,
5937: p_app_name => 'FEM',
5938: p_msg_name => 'FEM_GL_POST_203',
5952: END IF;
5953:
5954: -- Log the call stack and the Oracle error message to
5955: -- FND_LOG with the "unexpected exception" severity level.
5956: FEM_ENGINES_PKG.Tech_Message
5957: (p_severity => pc_log_level_unexpected,
5958: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5959: p_msg_text => pv_sqlerrm);
5960: FEM_ENGINES_PKG.Tech_Message
5956: FEM_ENGINES_PKG.Tech_Message
5957: (p_severity => pc_log_level_unexpected,
5958: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5959: p_msg_text => pv_sqlerrm);
5960: FEM_ENGINES_PKG.Tech_Message
5961: (p_severity => pc_log_level_unexpected,
5962: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5963: p_msg_text => pv_callstack);
5964:
5962: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5963: p_msg_text => pv_callstack);
5964:
5965: -- Log the Oracle error message to the Concurrent Request Log
5966: FEM_ENGINES_PKG.User_Message
5967: (p_app_name => 'FEM',
5968: p_msg_text => pv_sqlerrm);
5969:
5970: -- Log the function exit time to FND_LOG (with error)
5967: (p_app_name => 'FEM',
5968: p_msg_text => pv_sqlerrm);
5969:
5970: -- Log the function exit time to FND_LOG (with error)
5971: FEM_ENGINES_PKG.Tech_Message
5972: (p_severity => pc_log_level_procedure,
5973: p_module => v_module,
5974: p_app_name => 'FEM',
5975: p_msg_name => 'FEM_GL_POST_203',
6061: v_module := 'fem.plsql.fem_gl_post_process_pkg.register_ogl_process_execution';
6062: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Register_OGL_Process_Execution';
6063:
6064: -- Log the function entry time to FND_LOG
6065: FEM_ENGINES_PKG.Tech_Message
6066: (p_severity => pc_log_level_procedure,
6067: p_module => v_module,
6068: p_app_name => 'FEM',
6069: p_msg_name => 'FEM_GL_POST_201',
6076: -- Loop for each Output Dataset in FEM_INTG_EXEC_PARAMS_GT
6077: -- -------------------------------------------------------
6078: FOR v_ds IN ds_cur LOOP
6079: -- Log the current Dataset Code
6080: FEM_ENGINES_PKG.Tech_Message
6081: (p_severity => pc_log_level_statement,
6082: p_module => v_module,
6083: p_app_name => 'FEM',
6084: p_msg_name => 'FEM_GL_POST_204',
6103: FROM FEM_INTG_EXEC_PARAMS_GT
6104: WHERE ERROR_CODE IS NULL
6105: AND OUTPUT_DATASET_CODE = v_ds.output_dataset_code;
6106:
6107: FEM_ENGINES_PKG.Tech_Message
6108: (p_severity => pc_log_level_statement,
6109: p_module => v_module,
6110: p_app_name => 'FEM',
6111: p_msg_name => 'FEM_GL_POST_204',
6112: p_token1 => 'VAR_NAME',
6113: p_value1 => 'v_min_valid_eff_per_num',
6114: p_token2 => 'VAR_VAL',
6115: p_value2 => TO_CHAR(v_min_valid_eff_per_num));
6116: FEM_ENGINES_PKG.Tech_Message
6117: (p_severity => pc_log_level_statement,
6118: p_module => v_module,
6119: p_app_name => 'FEM',
6120: p_msg_name => 'FEM_GL_POST_204',
6147: OR (DATASET_CODE = v_ds.output_dataset_code))
6148: AND SOURCE_SYSTEM_CODE = pv_gl_source_system_code
6149: AND TABLE_NAME = 'FEM_BALANCES';
6150:
6151: FEM_ENGINES_PKG.Tech_Message
6152: (p_severity => pc_log_level_statement,
6153: p_module => v_module,
6154: p_app_name => 'FEM',
6155: p_msg_name => 'FEM_GL_POST_204',
6157: p_value1 => 'v_first_load_cal_per_id',
6158: p_token2 => 'VAR_VAL',
6159: p_value2 => TO_CHAR(v_first_load_cal_per_id));
6160:
6161: FEM_ENGINES_PKG.Tech_Message
6162: (p_severity => pc_log_level_statement,
6163: p_module => v_module,
6164: p_app_name => 'FEM',
6165: p_msg_name => 'FEM_GL_POST_204',
6191:
6192: IF pv_API_return_code > 0
6193: THEN
6194: -- Fail to find the attribute version
6195: FEM_ENGINES_PKG.Tech_Message
6196: (p_severity => pc_log_level_exception,
6197: p_module => v_module,
6198: p_msg_text => 'raising Invalid_Cal_Period_ID when getting period num');
6199: pv_attr_label := 'GL_PERIOD_NUM';
6206: WHERE attribute_id = pv_dim_attr_id
6207: AND version_id = pv_dim_attr_ver_id
6208: AND cal_period_id = v_first_load_cal_per_id;
6209:
6210: FEM_ENGINES_PKG.Tech_Message
6211: (p_severity => pc_log_level_statement,
6212: p_module => v_module,
6213: p_app_name => 'FEM',
6214: p_msg_name => 'FEM_GL_POST_204',
6219:
6220: EXCEPTION
6221: WHEN NO_DATA_FOUND THEN
6222: -- Fail to retrieve the First Load Cal Peroid Number
6223: FEM_ENGINES_PKG.Tech_Message
6224: (p_severity => pc_log_level_exception,
6225: p_module => v_module,
6226: p_msg_text => 'raising Invalid_Cal_Period_ID when getting period num');
6227: pv_attr_label := 'GL_PERIOD_NUM';
6239:
6240: IF pv_API_return_code > 0
6241: THEN
6242: -- Fail to find the attribute version
6243: FEM_ENGINES_PKG.Tech_Message
6244: (p_severity => pc_log_level_exception,
6245: p_module => v_module,
6246: p_msg_text => 'raising Invalid_Cal_Period_ID when getting year');
6247: pv_attr_label := 'ACCOUNTING_YEAR';
6254: WHERE attribute_id = pv_dim_attr_id
6255: AND version_id = pv_dim_attr_ver_id
6256: AND cal_period_id = v_first_load_cal_per_id;
6257:
6258: FEM_ENGINES_PKG.Tech_Message
6259: (p_severity => pc_log_level_statement,
6260: p_module => v_module,
6261: p_app_name => 'FEM',
6262: p_msg_name => 'FEM_GL_POST_204',
6267:
6268: EXCEPTION
6269: WHEN NO_DATA_FOUND THEN
6270: -- Fail to retrieve the First Load Cal Period Accounting Year
6271: FEM_ENGINES_PKG.Tech_Message
6272: (p_severity => pc_log_level_exception,
6273: p_module => v_module,
6274: p_msg_text => 'raising Invalid_Cal_Period_ID when getting year');
6275: pv_attr_label := 'ACCOUNTING_YEAR';
6284: AND LEDGER_ID = pv_ledger_id
6285: AND PERIOD_YEAR = v_cal_per_year
6286: AND PERIOD_NUM = v_cal_per_num;
6287:
6288: FEM_ENGINES_PKG.Tech_Message
6289: (p_severity => pc_log_level_statement,
6290: p_module => v_module,
6291: p_app_name => 'FEM',
6292: p_msg_name => 'FEM_GL_POST_204',
6318:
6319: IF pv_API_return_code > 0
6320: THEN
6321: -- Fail to find the attribute version
6322: FEM_ENGINES_PKG.Tech_Message
6323: (p_severity => pc_log_level_exception,
6324: p_module => v_module,
6325: p_msg_text => 'raising Invalid_Cal_Period_ID when getting period num');
6326: pv_attr_label := 'GL_PERIOD_NUM';
6333: WHERE attribute_id = pv_dim_attr_id
6334: AND version_id = pv_dim_attr_ver_id
6335: AND cal_period_id = v_last_load_cal_per_id;
6336:
6337: FEM_ENGINES_PKG.Tech_Message
6338: (p_severity => pc_log_level_statement,
6339: p_module => v_module,
6340: p_app_name => 'FEM',
6341: p_msg_name => 'FEM_GL_POST_204',
6346:
6347: EXCEPTION
6348: WHEN NO_DATA_FOUND THEN
6349: -- Fail to retrieve the Last Load Cal Peroid Number
6350: FEM_ENGINES_PKG.Tech_Message
6351: (p_severity => pc_log_level_exception,
6352: p_module => v_module,
6353: p_msg_text => 'raising Invalid_Cal_Period_ID when getting period num');
6354: pv_attr_label := 'GL_PERIOD_NUM';
6366:
6367: IF pv_API_return_code > 0
6368: THEN
6369: -- Fail to find the attribute version
6370: FEM_ENGINES_PKG.Tech_Message
6371: (p_severity => pc_log_level_exception,
6372: p_module => v_module,
6373: p_msg_text => 'raising Invalid_Cal_Period_ID when getting year');
6374: pv_attr_label := 'ACCOUNTING_YEAR';
6381: WHERE attribute_id = pv_dim_attr_id
6382: AND version_id = pv_dim_attr_ver_id
6383: AND cal_period_id = v_last_load_cal_per_id;
6384:
6385: FEM_ENGINES_PKG.Tech_Message
6386: (p_severity => pc_log_level_statement,
6387: p_module => v_module,
6388: p_app_name => 'FEM',
6389: p_msg_name => 'FEM_GL_POST_204',
6394:
6395: EXCEPTION
6396: WHEN NO_DATA_FOUND THEN
6397: -- Fail to retrieve the Last Load Cal Period Accounting Year
6398: FEM_ENGINES_PKG.Tech_Message
6399: (p_severity => pc_log_level_exception,
6400: p_module => v_module,
6401: p_msg_text => 'raising Invalid_Cal_Period_ID when getting year');
6402: pv_attr_label := 'ACCOUNTING_YEAR';
6417: v_last_load_eff_per_num := v_first_load_eff_per_num;
6418:
6419: END IF; -- IF (v_last_load_cal_per_id <> v_first_load_cal_per_id)
6420:
6421: FEM_ENGINES_PKG.Tech_Message
6422: (p_severity => pc_log_level_statement,
6423: p_module => v_module,
6424: p_app_name => 'FEM',
6425: p_msg_name => 'FEM_GL_POST_204',
6450: END;
6451:
6452: END IF; -- IF (v_first_load_cal_per_id <> -1)
6453:
6454: FEM_ENGINES_PKG.Tech_Message
6455: (p_severity => pc_log_level_statement,
6456: p_module => v_module,
6457: p_app_name => 'FEM',
6458: p_msg_name => 'FEM_GL_POST_204',
6471: -- Output Dataset
6472: -- ------------------------------------------------------------------
6473: FOR v_cp IN cp_cur(v_ds.output_dataset_code) LOOP
6474: -- Log the current Period Name, Cal Period ID, and Load Method Code
6475: FEM_ENGINES_PKG.Tech_Message
6476: (p_severity => pc_log_level_statement,
6477: p_module => v_module,
6478: p_app_name => 'FEM',
6479: p_msg_name => 'FEM_GL_POST_204',
6480: p_token1 => 'VAR_NAME',
6481: p_value1 => 'v_cp.period_name',
6482: p_token2 => 'VAR_VAL',
6483: p_value2 => v_cp.period_name);
6484: FEM_ENGINES_PKG.Tech_Message
6485: (p_severity => pc_log_level_statement,
6486: p_module => v_module,
6487: p_app_name => 'FEM',
6488: p_msg_name => 'FEM_GL_POST_204',
6489: p_token1 => 'VAR_NAME',
6490: p_value1 => 'v_cp.cal_period_id',
6491: p_token2 => 'VAR_VAL',
6492: p_value2 => TO_CHAR(v_cp.cal_period_id));
6493: FEM_ENGINES_PKG.Tech_Message
6494: (p_severity => pc_log_level_statement,
6495: p_module => v_module,
6496: p_app_name => 'FEM',
6497: p_msg_name => 'FEM_GL_POST_204',
6498: p_token1 => 'VAR_NAME',
6499: p_value1 => 'v_cp.effective_period_num',
6500: p_token2 => 'VAR_VAL',
6501: p_value2 => TO_CHAR(v_cp.effective_period_num));
6502: FEM_ENGINES_PKG.Tech_Message
6503: (p_severity => pc_log_level_statement,
6504: p_module => v_module,
6505: p_app_name => 'FEM',
6506: p_msg_name => 'FEM_GL_POST_204',
6508: p_value1 => 'v_cp.load_method_code',
6509: p_token2 => 'VAR_VAL',
6510: p_value2 => v_cp.load_method_code);
6511: -- Bug fix 4285337: Print the end date for each period
6512: FEM_ENGINES_PKG.Tech_Message
6513: (p_severity => pc_log_level_statement,
6514: p_module => v_module,
6515: p_app_name => 'FEM',
6516: p_msg_name => 'FEM_GL_POST_204',
6557: END;
6558: END IF; -- IF (v_first_load_cal_period_id = -1)
6559: END IF; -- IF (v_cp.load_method_code = 'I')
6560:
6561: FEM_ENGINES_PKG.Tech_Message
6562: (p_severity => pc_log_level_statement,
6563: p_module => v_module,
6564: p_app_name => 'FEM',
6565: p_msg_name => 'FEM_GL_POST_204',
6577: INTO v_req_id
6578: FROM DUAL;
6579:
6580: -- Print the request ID to FND Log
6581: FEM_ENGINES_PKG.Tech_Message
6582: (p_severity => pc_log_level_statement,
6583: p_module => v_module,
6584: p_app_name => 'FEM',
6585: p_msg_name => 'FEM_GL_POST_204',
6613:
6614: IF (v_return_status <> 'S')
6615: THEN
6616: -- Incompatible API or unexpected database error
6617: FEM_ENGINES_PKG.Tech_Message
6618: (p_severity => pc_log_level_statement,
6619: p_module => v_module,
6620: p_msg_text => 'Raising OGLRegProc_FatalErr after calling Register_Request');
6621: RAISE OGLRegProc_FatalErr;
6647:
6648: IF v_return_status = 'E'
6649: THEN
6650: -- The execution lock exists for this Output Dataset/Cal Period
6651: FEM_ENGINES_PKG.Tech_Message
6652: (p_severity => pc_log_level_exception,
6653: p_module => v_module,
6654: p_app_name => 'FEM',
6655: p_msg_name => 'FEM_INTG_BAL_REGISTER_FAIL',
6656: p_token1 => 'DS_CODE',
6657: p_value1 => v_ds.output_dataset_code,
6658: p_token2 => 'PER_NAME',
6659: p_value2 => v_cp.PERIOD_NAME);
6660: FEM_ENGINES_PKG.User_Message
6661: (p_app_name => 'FEM',
6662: p_msg_name => 'FEM_INTG_BAL_REGISTER_FAIL',
6663: p_token1 => 'DS_CODE',
6664: p_value1 => v_ds.output_dataset_code,
6668: -- Log the user message(s) returned by Register_Object_Execution()
6669: IF v_msg_count = 1
6670: THEN
6671: -- Only one message
6672: FEM_ENGINES_PKG.User_Message
6673: (p_app_name => 'FEM',
6674: p_msg_text => v_msg_data);
6675:
6676: ELSIF v_msg_count > 1
6677: THEN
6678: -- More than one messages
6679: FOR i IN 1 .. v_msg_count LOOP
6680: v_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
6681: FEM_ENGINES_PKG.User_Message
6682: (p_app_name => 'FEM',
6683: p_msg_text => v_msg_data);
6684: END LOOP;
6685:
6707: -- Log the user message(s) returned by Unregister_Request()
6708: IF v_msg_count = 1
6709: THEN
6710: -- Only one message
6711: FEM_ENGINES_PKG.User_Message
6712: (p_app_name => 'FEM',
6713: p_msg_text => v_msg_data);
6714:
6715: ELSIF v_msg_count > 1
6716: THEN
6717: -- More than one messages
6718: FOR i IN 1 .. v_msg_count LOOP
6719: v_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
6720: FEM_ENGINES_PKG.User_Message
6721: (p_app_name => 'FEM',
6722: p_msg_text => v_msg_data);
6723: END LOOP;
6724: END IF; -- IF v_msg_count = 1
6728:
6729: ELSIF v_return_status = 'U'
6730: THEN
6731: -- Unexpected database error
6732: FEM_ENGINES_PKG.Tech_Message
6733: (p_severity => pc_log_level_exception,
6734: p_module => v_module,
6735: p_app_name => 'FEM',
6736: p_msg_name => 'FEM_INTG_BAL_REGISTER_FAIL',
6737: p_token1 => 'DS_CODE',
6738: p_value1 => v_ds.output_dataset_code,
6739: p_token2 => 'PER_NAME',
6740: p_value2 => v_cp.PERIOD_NAME);
6741: FEM_ENGINES_PKG.User_Message
6742: (p_app_name => 'FEM',
6743: p_msg_name => 'FEM_INTG_BAL_REGISTER_FAIL',
6744: p_token1 => 'DS_CODE',
6745: p_value1 => v_ds.output_dataset_code,
6745: p_value1 => v_ds.output_dataset_code,
6746: p_token2 => 'PER_NAME',
6747: p_value2 => v_cp.PERIOD_NAME);
6748:
6749: FEM_ENGINES_PKG.Tech_Message
6750: (p_severity => pc_log_level_exception,
6751: p_module => v_module,
6752: p_msg_text => 'Raising OGLRegProc_FatalErr after calling Register_Object_Execution');
6753: RAISE OGLRegProc_FatalErr;
6753: RAISE OGLRegProc_FatalErr;
6754:
6755: ELSE
6756: -- Succeed to register execution for this Cal Period/Output Dataset
6757: FEM_ENGINES_PKG.Tech_Message
6758: (p_severity => pc_log_level_event,
6759: p_module => v_module,
6760: p_app_name => 'FEM',
6761: p_msg_name => 'FEM_INTG_BAL_REGISTER_SUCC',
6762: p_token1 => 'DS_CODE',
6763: p_value1 => v_ds.output_dataset_code,
6764: p_token2 => 'PER_NAME',
6765: p_value2 => v_cp.PERIOD_NAME);
6766: FEM_ENGINES_PKG.User_Message
6767: (p_app_name => 'FEM',
6768: p_msg_name => 'FEM_INTG_BAL_REGISTER_SUCC',
6769: p_token1 => 'DS_CODE',
6770: p_value1 => v_ds.output_dataset_code,
6792: END IF; -- IF v_return_status = 'E'
6793:
6794: END LOOP; -- cp_cur LOOP
6795:
6796: FEM_ENGINES_PKG.Tech_Message
6797: (p_severity => pc_log_level_statement,
6798: p_module => v_module,
6799: p_app_name => 'FEM',
6800: p_msg_name => 'FEM_GL_POST_204',
6801: p_token1 => 'VAR_NAME',
6802: p_value1 => 'v_first_reg_eff_per_num',
6803: p_token2 => 'VAR_VAL',
6804: p_value2 => TO_CHAR(v_first_reg_eff_per_num));
6805: FEM_ENGINES_PKG.Tech_Message
6806: (p_severity => pc_log_level_statement,
6807: p_module => v_module,
6808: p_app_name => 'FEM',
6809: p_msg_name => 'FEM_GL_POST_204',
6836: v_any_period_gap := 'N';
6837: END;
6838: END IF; -- IF (v_first_load_eff_per_num <> -1)
6839:
6840: FEM_ENGINES_PKG.Tech_Message
6841: (p_severity => pc_log_level_statement,
6842: p_module => v_module,
6843: p_app_name => 'FEM',
6844: p_msg_name => 'FEM_GL_POST_204',
6855: -- period range/registered period range, so no periods can be
6856: -- processed
6857:
6858: -- Log the warning messages
6859: FEM_ENGINES_PKG.Tech_Message
6860: (p_severity => pc_log_level_exception,
6861: p_module => v_module,
6862: p_app_name => 'FEM',
6863: p_msg_name => 'FEM_INTG_BAL_PERIOD_GAP',
6862: p_app_name => 'FEM',
6863: p_msg_name => 'FEM_INTG_BAL_PERIOD_GAP',
6864: p_token1 => 'DS_CODE',
6865: p_value1 => v_ds.output_dataset_code);
6866: FEM_ENGINES_PKG.User_Message
6867: (p_app_name => 'FEM',
6868: p_msg_name => 'FEM_INTG_BAL_PERIOD_GAP',
6869: p_token1 => 'DS_CODE',
6870: p_value1 => v_ds.output_dataset_code);
6897: AND REQUEST_ID IS NOT NULL;
6898: EXCEPTION
6899: WHEN NO_DATA_FOUND THEN
6900: -- There are no valid execution parameters
6901: FEM_ENGINES_PKG.Tech_Message
6902: (p_severity => pc_log_level_error,
6903: p_module => v_module,
6904: p_app_name => 'FEM',
6905: p_msg_name => 'FEM_INTG_BAL_NO_VALID_EXEC');
6902: (p_severity => pc_log_level_error,
6903: p_module => v_module,
6904: p_app_name => 'FEM',
6905: p_msg_name => 'FEM_INTG_BAL_NO_VALID_EXEC');
6906: FEM_ENGINES_PKG.User_Message
6907: (p_app_name => 'FEM',
6908: p_msg_name => 'FEM_INTG_BAL_NO_VALID_EXEC');
6909: RAISE OGLRegProc_FatalErr;
6910:
6921: IF (pv_exec_mode = 'I')
6922: THEN
6923: -- The original execution mode is Incremental, so log a message to
6924: -- inform users that it's been changed to Snapshot mode
6925: FEM_ENGINES_PKG.Tech_Message
6926: (p_severity => pc_log_level_event,
6927: p_module => v_module,
6928: p_app_name => 'FEM',
6929: p_msg_name => 'FEM_INTG_BAL_CHANGE_TO_SNAP');
6926: (p_severity => pc_log_level_event,
6927: p_module => v_module,
6928: p_app_name => 'FEM',
6929: p_msg_name => 'FEM_INTG_BAL_CHANGE_TO_SNAP');
6930: FEM_ENGINES_PKG.User_Message
6931: (p_app_name => 'FEM',
6932: p_msg_name => 'FEM_INTG_BAL_CHANGE_TO_SNAP');
6933: END IF;
6934:
6937: pv_stmt_type := 'MERGE';
6938:
6939: END IF; -- IF (v_load_method = 'S')
6940:
6941: FEM_ENGINES_PKG.Tech_Message
6942: (p_severity => pc_log_level_statement,
6943: p_module => v_module,
6944: p_app_name => 'FEM',
6945: p_msg_name => 'FEM_GL_POST_204',
6970: pv_from_gl_delta_flag := 'Y';
6971:
6972: END IF; -- IF (pv_ds_balance_type_cd = 'BALANCE' OR v_load_method = 'S')
6973:
6974: FEM_ENGINES_PKG.Tech_Message
6975: (p_severity => pc_log_level_statement,
6976: p_module => v_module,
6977: p_app_name => 'FEM',
6978: p_msg_name => 'FEM_GL_POST_204',
6980: p_value1 => 'pv_from_gl_bal_flag',
6981: p_token2 => 'VAR_VAL',
6982: p_value2 => pv_from_gl_bal_flag);
6983:
6984: FEM_ENGINES_PKG.Tech_Message
6985: (p_severity => pc_log_level_statement,
6986: p_module => v_module,
6987: p_app_name => 'FEM',
6988: p_msg_name => 'FEM_GL_POST_204',
7014: X_RETURN_STATUS => v_return_status);
7015:
7016: IF v_return_status <> 'S'
7017: THEN
7018: FEM_ENGINES_PKG.Tech_Message
7019: (p_severity => pc_log_level_exception,
7020: p_module => v_module,
7021: p_msg_text => 'Raising OGLRegProc_FatalErr after calling Register_Table');
7022: RAISE OGLRegProc_FatalErr;
7028: -- 7. Exit with success/warning
7029: -- ----------------------------
7030:
7031: -- Log the function exit time to FND_LOG (successful completion)
7032: FEM_ENGINES_PKG.Tech_Message
7033: (p_severity => pc_log_level_procedure,
7034: p_module => v_module,
7035: p_app_name => 'FEM',
7036: p_msg_name => 'FEM_GL_POST_202',
7067:
7068: END IF; -- IF (pv_attr_label IS NOT NULL)
7069:
7070: -- Log the error message
7071: FEM_ENGINES_PKG.Tech_Message
7072: (p_severity => pc_log_level_error,
7073: p_module => v_module,
7074: p_app_name => 'FEM',
7075: p_msg_name => 'FEM_INTG_BAL_DIM_ATTR_ERR',
7078: p_token2 => 'PER_NAME',
7079: p_value2 => v_cal_per_name,
7080: p_token3 => 'DIM_NAME',
7081: p_value3 => v_dim_name);
7082: FEM_ENGINES_PKG.User_Message
7083: (p_app_name => 'FEM',
7084: p_msg_name => 'FEM_INTG_BAL_PER_ATTR_ERR',
7085: p_token1 => 'ATTR_NAME',
7086: p_value1 => v_attr_name,
7089: p_token3 => 'DIM_NAME',
7090: p_value3 => v_dim_name);
7091:
7092: -- Log the function exit time to FND_LOG (with error)
7093: FEM_ENGINES_PKG.Tech_Message
7094: (p_severity => pc_log_level_procedure,
7095: p_module => v_module,
7096: p_app_name => 'FEM',
7097: p_msg_name => 'FEM_GL_POST_203',
7107: -- Log the user message(s) returned by the API being called
7108: IF v_msg_count = 1
7109: THEN
7110: -- Only one message
7111: FEM_ENGINES_PKG.User_Message
7112: (p_app_name => 'FEM',
7113: p_msg_text => v_msg_data);
7114:
7115: ELSIF v_msg_count > 1
7116: THEN
7117: -- More than one messages
7118: FOR i IN 1 .. v_msg_count LOOP
7119: v_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
7120: FEM_ENGINES_PKG.User_Message
7121: (p_app_name => 'FEM',
7122: p_msg_text => v_msg_data);
7123: END LOOP;
7124:
7124:
7125: END IF; -- IF v_msg_count = 1
7126:
7127: -- Log the function exit time to FND_LOG (with error)
7128: FEM_ENGINES_PKG.Tech_Message
7129: (p_severity => pc_log_level_procedure,
7130: p_module => v_module,
7131: p_app_name => 'FEM',
7132: p_msg_name => 'FEM_GL_POST_203',
7143: pv_callstack := dbms_utility.format_call_stack;
7144:
7145: -- Log the call stack and the Oracle error message to
7146: -- FND_LOG with the "unexpected exception" severity level.
7147: FEM_ENGINES_PKG.Tech_Message
7148: (p_severity => pc_log_level_unexpected,
7149: p_module => v_module,
7150: p_msg_text => pv_sqlerrm);
7151: FEM_ENGINES_PKG.Tech_Message
7147: FEM_ENGINES_PKG.Tech_Message
7148: (p_severity => pc_log_level_unexpected,
7149: p_module => v_module,
7150: p_msg_text => pv_sqlerrm);
7151: FEM_ENGINES_PKG.Tech_Message
7152: (p_severity => pc_log_level_unexpected,
7153: p_module => v_module,
7154: p_msg_text => pv_callstack);
7155:
7153: p_module => v_module,
7154: p_msg_text => pv_callstack);
7155:
7156: -- Log the Oracle error message to the Concurrent Request Log
7157: FEM_ENGINES_PKG.User_Message
7158: (p_app_name => 'FEM',
7159: p_msg_text => pv_sqlerrm);
7160:
7161: -- Log the function exit time to FND_LOG (with error)
7158: (p_app_name => 'FEM',
7159: p_msg_text => pv_sqlerrm);
7160:
7161: -- Log the function exit time to FND_LOG (with error)
7162: FEM_ENGINES_PKG.Tech_Message
7163: (p_severity => pc_log_level_procedure,
7164: p_module => v_module,
7165: p_app_name => 'FEM',
7166: p_msg_name => 'FEM_GL_POST_203',
7242: v_module := 'fem.plsql.fem_gl_post_process_pkg.final_ogl_process_logging';
7243: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Final_OGL_Process_Logging';
7244:
7245: -- Log the function entry time to FND_LOG
7246: FEM_ENGINES_PKG.Tech_Message
7247: (p_severity => pc_log_level_procedure,
7248: p_module => v_module,
7249: p_app_name => 'FEM',
7250: p_msg_name => 'FEM_GL_POST_201',
7253: p_token2 => 'TIME',
7254: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
7255:
7256: -- List the IN parameters to FND_LOG
7257: FEM_ENGINES_PKG.Tech_Message
7258: (p_severity => pc_log_level_statement,
7259: p_module => v_module,
7260: p_app_name => 'FEM',
7261: p_msg_name => 'FEM_GL_POST_204',
7262: p_token1 => 'VAR_NAME',
7263: p_value1 => 'p_exec_status',
7264: p_token2 => 'VAR_VAL',
7265: p_value2 => p_exec_status);
7266: FEM_ENGINES_PKG.Tech_Message
7267: (p_severity => pc_log_level_statement,
7268: p_module => v_module,
7269: p_app_name => 'FEM',
7270: p_msg_name => 'FEM_GL_POST_204',
7290: THEN
7291: -- A translated currency is found
7292: v_xlated_curr_found := TRUE;
7293: -- Log the values retrieved from the translated currency cursor
7294: FEM_ENGINES_PKG.Tech_Message
7295: (p_severity => pc_log_level_statement,
7296: p_module => v_module,
7297: p_app_name => 'FEM',
7298: p_msg_name => 'FEM_GL_POST_204',
7299: p_token1 => 'VAR_NAME',
7300: p_value1 => 'v_xlated_curr_ds_code',
7301: p_token2 => 'VAR_VAL',
7302: p_value2 => TO_CHAR(v_xlated_curr_ds_code));
7303: FEM_ENGINES_PKG.Tech_Message
7304: (p_severity => pc_log_level_statement,
7305: p_module => v_module,
7306: p_app_name => 'FEM',
7307: p_msg_name => 'FEM_GL_POST_204',
7308: p_token1 => 'VAR_NAME',
7309: p_value1 => 'v_xlated_curr_cal_per_id',
7310: p_token2 => 'VAR_VAL',
7311: p_value2 => TO_CHAR(v_xlated_curr_cal_per_id));
7312: FEM_ENGINES_PKG.Tech_Message
7313: (p_severity => pc_log_level_statement,
7314: p_module => v_module,
7315: p_app_name => 'FEM',
7316: p_msg_name => 'FEM_GL_POST_204',
7324: -- Loop for each request to perform final process logging
7325: FOR v_req IN req_cur LOOP
7326:
7327: -- Log the values retrieved from the request cursor for this Request
7328: FEM_ENGINES_PKG.Tech_Message
7329: (p_severity => pc_log_level_statement,
7330: p_module => v_module,
7331: p_app_name => 'FEM',
7332: p_msg_name => 'FEM_GL_POST_204',
7333: p_token1 => 'VAR_NAME',
7334: p_value1 => 'v_req.request_id',
7335: p_token2 => 'VAR_VAL',
7336: p_value2 => TO_CHAR(v_req.request_id));
7337: FEM_ENGINES_PKG.Tech_Message
7338: (p_severity => pc_log_level_statement,
7339: p_module => v_module,
7340: p_app_name => 'FEM',
7341: p_msg_name => 'FEM_GL_POST_204',
7342: p_token1 => 'VAR_NAME',
7343: p_value1 => 'v_req.output_dataset_code',
7344: p_token2 => 'VAR_VAL',
7345: p_value2 => v_req.output_dataset_code);
7346: FEM_ENGINES_PKG.Tech_Message
7347: (p_severity => pc_log_level_statement,
7348: p_module => v_module,
7349: p_app_name => 'FEM',
7350: p_msg_name => 'FEM_GL_POST_204',
7351: p_token1 => 'VAR_NAME',
7352: p_value1 => 'v_req.period_name',
7353: p_token2 => 'VAR_VAL',
7354: p_value2 => v_req.period_name);
7355: FEM_ENGINES_PKG.Tech_Message
7356: (p_severity => pc_log_level_statement,
7357: p_module => v_module,
7358: p_app_name => 'FEM',
7359: p_msg_name => 'FEM_GL_POST_204',
7360: p_token1 => 'VAR_NAME',
7361: p_value1 => 'v_req.cal_period_id',
7362: p_token2 => 'VAR_VAL',
7363: p_value2 => TO_CHAR(v_req.cal_period_id));
7364: FEM_ENGINES_PKG.Tech_Message
7365: (p_severity => pc_log_level_statement,
7366: p_module => v_module,
7367: p_app_name => 'FEM',
7368: p_msg_name => 'FEM_GL_POST_204',
7369: p_token1 => 'VAR_NAME',
7370: p_value1 => 'v_req.num_of_rows_selected',
7371: p_token2 => 'VAR_VAL',
7372: p_value2 => TO_CHAR(v_req.num_of_rows_selected));
7373: FEM_ENGINES_PKG.Tech_Message
7374: (p_severity => pc_log_level_statement,
7375: p_module => v_module,
7376: p_app_name => 'FEM',
7377: p_msg_name => 'FEM_GL_POST_204',
7378: p_token1 => 'VAR_NAME',
7379: p_value1 => 'v_req.num_of_rows_posted',
7380: p_token2 => 'VAR_VAL',
7381: p_value2 => TO_CHAR(v_req.num_of_rows_posted));
7382: FEM_ENGINES_PKG.Tech_Message
7383: (p_severity => pc_log_level_statement,
7384: p_module => v_module,
7385: p_app_name => 'FEM',
7386: p_msg_name => 'FEM_GL_POST_204',
7416: -- Log the user message(s) returned by the API
7417: IF v_msg_count = 1
7418: THEN
7419: -- Only one message
7420: FEM_ENGINES_PKG.User_Message
7421: (p_app_name => 'FEM',
7422: p_msg_text => v_msg_data);
7423:
7424: ELSIF v_msg_count > 1
7425: THEN
7426: -- More than one messages
7427: FOR i IN 1 .. v_msg_count LOOP
7428: v_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
7429: FEM_ENGINES_PKG.User_Message
7430: (p_app_name => 'FEM',
7431: p_msg_text => v_msg_data);
7432: END LOOP;
7433: END IF; -- IF v_msg_count = 1
7462: -- Log the user message(s) returned by the API
7463: IF v_msg_count = 1
7464: THEN
7465: -- Only one message
7466: FEM_ENGINES_PKG.User_Message
7467: (p_app_name => 'FEM',
7468: p_msg_text => v_msg_data);
7469:
7470: ELSIF v_msg_count > 1
7471: THEN
7472: -- More than one messages
7473: FOR i IN 1 .. v_msg_count LOOP
7474: v_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
7475: FEM_ENGINES_PKG.User_Message
7476: (p_app_name => 'FEM',
7477: p_msg_text => v_msg_data);
7478: END LOOP;
7479: END IF; -- IF v_msg_count = 1
7497: -- For other cases, set the execution status to SUCCESS
7498: v_exec_status := 'SUCCESS';
7499: END IF;
7500: -- Log the execution status of this Request
7501: FEM_ENGINES_PKG.Tech_Message
7502: (p_severity => pc_log_level_statement,
7503: p_module => v_module,
7504: p_app_name => 'FEM',
7505: p_msg_name => 'FEM_GL_POST_204',
7529: -- Log the user message(s) returned by the API
7530: IF v_msg_count = 1
7531: THEN
7532: -- Only one message
7533: FEM_ENGINES_PKG.User_Message
7534: (p_app_name => 'FEM',
7535: p_msg_text => v_msg_data);
7536:
7537: ELSIF v_msg_count > 1
7538: THEN
7539: -- More than one messages
7540: FOR i IN 1 .. v_msg_count LOOP
7541: v_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
7542: FEM_ENGINES_PKG.User_Message
7543: (p_app_name => 'FEM',
7544: p_msg_text => v_msg_data);
7545: END LOOP;
7546: END IF; -- IF v_msg_count = 1
7565: -- Log the user message(s) returned by the API
7566: IF v_msg_count = 1
7567: THEN
7568: -- Only one message
7569: FEM_ENGINES_PKG.User_Message
7570: (p_app_name => 'FEM',
7571: p_msg_text => v_msg_data);
7572:
7573: ELSIF v_msg_count > 1
7574: THEN
7575: -- More than one messages
7576: FOR i IN 1 .. v_msg_count LOOP
7577: v_msg_data := FND_MSG_PUB.Get(p_msg_index => i, p_encoded => 'F');
7578: FEM_ENGINES_PKG.User_Message
7579: (p_app_name => 'FEM',
7580: p_msg_text => v_msg_data);
7581: END LOOP;
7582: END IF; -- IF v_msg_count = 1
7672:
7673: -- ---------------------------------------------
7674: -- 7. Log the passed Final Message and then exit
7675: -- ---------------------------------------------
7676: FEM_ENGINES_PKG.Tech_Message
7677: (P_SEVERITY => pc_log_level_event,
7678: P_MODULE => v_module,
7679: P_APP_NAME => 'FEM',
7680: P_MSG_NAME => p_final_message_name);
7677: (P_SEVERITY => pc_log_level_event,
7678: P_MODULE => v_module,
7679: P_APP_NAME => 'FEM',
7680: P_MSG_NAME => p_final_message_name);
7681: FEM_ENGINES_PKG.User_Message
7682: (P_APP_NAME => 'FEM',
7683: P_MSG_NAME => p_final_message_name);
7684:
7685: -- Log the function exit time to FND_LOG (successful completion)
7682: (P_APP_NAME => 'FEM',
7683: P_MSG_NAME => p_final_message_name);
7684:
7685: -- Log the function exit time to FND_LOG (successful completion)
7686: FEM_ENGINES_PKG.Tech_Message
7687: (p_severity => pc_log_level_procedure,
7688: p_module => v_module,
7689: p_app_name => 'FEM',
7690: p_msg_name => 'FEM_GL_POST_202',
7700: pv_callstack := dbms_utility.format_call_stack;
7701:
7702: -- Log the call stack and the Oracle error message to
7703: -- FND_LOG with the "unexpected exception" severity level.
7704: FEM_ENGINES_PKG.Tech_Message
7705: (p_severity => pc_log_level_unexpected,
7706: p_module => v_module,
7707: p_msg_text => pv_sqlerrm);
7708: FEM_ENGINES_PKG.Tech_Message
7704: FEM_ENGINES_PKG.Tech_Message
7705: (p_severity => pc_log_level_unexpected,
7706: p_module => v_module,
7707: p_msg_text => pv_sqlerrm);
7708: FEM_ENGINES_PKG.Tech_Message
7709: (p_severity => pc_log_level_unexpected,
7710: p_module => v_module,
7711: p_msg_text => pv_callstack);
7712:
7710: p_module => v_module,
7711: p_msg_text => pv_callstack);
7712:
7713: -- Log the Oracle error message to the Concurrent Request Log
7714: FEM_ENGINES_PKG.User_Message
7715: (p_app_name => 'FEM',
7716: p_msg_text => pv_sqlerrm);
7717:
7718: -- Log the function exit time to FND_LOG (with error)
7715: (p_app_name => 'FEM',
7716: p_msg_text => pv_sqlerrm);
7717:
7718: -- Log the function exit time to FND_LOG (with error)
7719: FEM_ENGINES_PKG.Tech_Message
7720: (p_severity => pc_log_level_procedure,
7721: p_module => v_module,
7722: p_app_name => 'FEM',
7723: p_msg_name => 'FEM_GL_POST_203',