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

APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_GL_POST_PROCESS_PKG

Line 1: PACKAGE BODY FEM_GL_POST_PROCESS_PKG AS

1: PACKAGE BODY FEM_GL_POST_PROCESS_PKG AS
2: /* $Header: fem_gl_post_proc.plb 120.11 2008/04/01 06:55:49 rguerrer ship $ */
3:
4: /**************************************************************************
5: -- Private Package Variables and exceptions

Line 119: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
122:
123: -- --------------------------------------------------------------------

Line 143: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
146: p_msg_name => 'FEM_GL_POST_204',
147: p_token1 => 'VAR_NAME',

Line 154: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
157: p_msg_name => 'FEM_GL_POST_204',
158: p_token1 => 'VAR_NAME',

Line 165: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
168: p_msg_name => 'FEM_GL_POST_204',
169: p_token1 => 'VAR_NAME',

Line 176: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
179: p_msg_name => 'FEM_GL_POST_204',
180: p_token1 => 'VAR_NAME',

Line 187: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
190: p_msg_name => 'FEM_GL_POST_204',
191: p_token1 => 'VAR_NAME',

Line 198: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
201: p_msg_name => 'FEM_GL_POST_204',
202: p_token1 => 'VAR_NAME',

Line 209: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
212: p_msg_name => 'FEM_GL_POST_204',
213: p_token1 => 'VAR_NAME',

Line 220: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
223: p_msg_name => 'FEM_GL_POST_204',
224: p_token1 => 'VAR_NAME',

Line 245: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
248:
249: RAISE Invalid_QTD_YTD;

Line 273: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
276:
277: RAISE Invalid_Object_ID;

Line 289: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
292:
293: EXCEPTION

Line 309: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
312: p_msg_name => 'FEM_GL_POST_010');
313:

Line 327: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',

Line 354: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
357:
358: FEM_ENGINES_PKG.Tech_Message

Line 360: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
363:
364: -- Log the Oracle error message to the Concurrent Request Log.

Line 418: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
421:
422: -- Call the FEM_PL_PKG.Register_Request API procedure to register

Line 448: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
451:
452: RAISE API_Error;

Line 486: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
489:
490: RAISE API_Error;

Line 496: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
499: p_msg_name => 'FEM_GL_POST_204',
500: p_token1 => 'VAR_NAME',

Line 509: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
512: p_msg_name => 'FEM_GL_POST_204',
513: p_token1 => 'VAR_NAME',

Line 542: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
545:
546: RAISE API_Error;

Line 580: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
583:
584: RAISE API_Error;

Line 594: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
597:
598: EXCEPTION

Line 614: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
617: p_msg_name => 'FEM_GL_POST_204',
618: p_token1 => 'VAR_NAME',

Line 627: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
630: p_msg_name => 'FEM_GL_POST_204',
631: p_token1 => 'VAR_NAME',

Line 651: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
654: p_msg_name => 'FEM_GL_POST_204',
655: p_token1 => 'VAR_NAME',

Line 696: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
699:
700: FEM_ENGINES_PKG.Tech_Message

Line 702: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
705:
706: -- Log the Oracle error message to the Concurrent Request Log.

Line 779: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
782:
783: -- Update the total number of rows inserted and/or updated in FEM_BALANCES

Line 905: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
908: p_msg_name => 'FEM_GL_POST_204',
909: p_token1 => 'VAR_NAME',

Line 916: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
919: p_msg_name => 'FEM_GL_POST_204',
920: p_token1 => 'VAR_NAME',

Line 943: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
946: p_msg_name => 'FEM_GL_POST_204',
947: p_token1 => 'VAR_NAME',

Line 974: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
977: p_msg_name => 'FEM_GL_POST_204',
978: p_token1 => 'VAR_NAME',

Line 1007: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1010: p_msg_name => 'FEM_GL_POST_204',
1011: p_token1 => 'VAR_NAME',

Line 1033: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1036: P_MSG_NAME => 'FEM_GL_POST_204',
1037: P_TOKEN1 => 'VAR_NAME',

Line 1060: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1063: P_MSG_NAME => p_final_message_name);
1064:

Line 1067: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1070:
1071: EXCEPTION

Line 1085: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
1088:
1089: FEM_ENGINES_PKG.Tech_Message

Line 1091: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
1094:
1095: -- Log the Oracle error message to the Concurrent Request Log.

Line 1169: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1172:
1173: -- Bulk select dimension information into array of records

Line 1203: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1206: p_msg_name => 'FEM_GL_POST_204',
1207: p_token1 => 'VAR_NAME',

Line 1216: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1219: p_msg_text => 'The FEM_BALANCES Processing Key ' ||
1220: 'has not been set up yet.');

Line 1228: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1231: p_msg_name => 'FEM_GL_POST_204',
1232: p_token1 => 'VAR_NAME',

Line 1239: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1242: p_msg_name => 'FEM_GL_POST_204',
1243: p_token1 => 'VAR_NAME',

Line 1261: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1264:
1265: pv_dim_name := FEM_DIMENSION_UTIL_PKG.Get_Dimension_Name

Line 1274: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1277: p_msg_name => 'FEM_GL_POST_204',
1278: p_token1 => 'VAR_NAME',

Line 1287: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1290: p_msg_name => 'FEM_GL_POST_204',
1291: p_token1 => 'VAR_NAME',

Line 1298: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1301: p_msg_name => 'FEM_GL_POST_204',
1302: p_token1 => 'VAR_NAME',

Line 1312: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1315: p_msg_name => 'FEM_GL_POST_204',
1316: p_token1 => 'VAR_NAME',

Line 1323: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1326: p_msg_name => 'FEM_GL_POST_204',
1327: p_token1 => 'VAR_NAME',

Line 1336: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1339: p_msg_name => 'FEM_GL_POST_204',
1340: p_token1 => 'VAR_NAME',

Line 1351: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1354:
1355: EXCEPTION

Line 1367: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',

Line 1402: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
1405:
1406: FEM_ENGINES_PKG.Tech_Message

Line 1408: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
1411:
1412: -- Log the Oracle error message to the Concurrent Request Log.

Line 1466: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1469:
1470: v_sql_stmt := 'SELECT source_system_display_code, COUNT(*)' ||

Line 1478: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1481: p_msg_name => 'FEM_GL_POST_204',
1482: p_token1 => 'VAR_NAME',

Line 1495: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1498: p_msg_name => 'FEM_GL_POST_204',
1499: p_token1 => 'VAR_NAME',

Line 1510: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1513: p_msg_name => 'FEM_GL_POST_204',
1514: p_token1 => 'VAR_NAME',

Line 1535: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1538:
1539: END Get_SSC;

Line 1581: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1584:
1585: -- -------------------------------------------------------------------

Line 1599: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1602: p_msg_name => 'FEM_GL_POST_204',
1603: p_token1 => 'VAR_NAME',

Line 1610: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1613: p_msg_name => 'FEM_GL_POST_204',
1614: p_token1 => 'VAR_NAME',

Line 1621: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1624: p_msg_name => 'FEM_GL_POST_204',
1625: p_token1 => 'VAR_NAME',

Line 1635: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1638:
1639: RAISE Invalid_Request_ID;

Line 1689: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1692: p_msg_name => 'FEM_GL_POST_204',
1693: p_token1 => 'VAR_NAME',

Line 1703: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1706:
1707: RAISE Invalid_Runtime_Parameter;

Line 1733: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1736:
1737: RAISE Invalid_Runtime_Parameter;

Line 1750: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1753: p_msg_name => 'FEM_GL_POST_204',
1754: p_token1 => 'VAR_NAME',

Line 1764: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1767:
1768: RAISE Invalid_Runtime_Parameter;

Line 1795: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1798:
1799: RAISE Invalid_Runtime_Parameter;

Line 1812: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1815: p_msg_name => 'FEM_GL_POST_204',
1816: p_token1 => 'VAR_NAME',

Line 1826: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1829:
1830: RAISE Invalid_Runtime_Parameter;

Line 1865: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1868: p_msg_name => 'FEM_GL_POST_204',
1869: p_token1 => 'VAR_NAME',

Line 1879: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1882:
1883: RAISE Invalid_Runtime_Parameter;

Line 1930: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1933:
1934: RAISE Invalid_Runtime_Parameter;

Line 1947: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
1950: p_msg_name => 'FEM_GL_POST_204',
1951: p_token1 => 'VAR_NAME',

Line 1961: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1964:
1965: RAISE Invalid_Runtime_Parameter;

Line 1993: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
1996:
1997: RAISE Invalid_Runtime_Parameter;

Line 2010: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2013: p_msg_name => 'FEM_GL_POST_204',
2014: p_token1 => 'VAR_NAME',

Line 2024: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2027:
2028: RAISE Invalid_Runtime_Parameter;

Line 2055: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2058: p_msg_name => 'FEM_GL_POST_204',
2059: p_token1 => 'VAR_NAME',

Line 2069: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2072:
2073: RAISE Invalid_Runtime_Parameter;

Line 2101: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2104:
2105: RAISE Invalid_Runtime_Parameter;

Line 2118: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2121: p_msg_name => 'FEM_GL_POST_204',
2122: p_token1 => 'VAR_NAME',

Line 2132: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2135:
2136: RAISE Invalid_Runtime_Parameter;

Line 2163: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2166: p_msg_name => 'FEM_GL_POST_204',
2167: p_token1 => 'VAR_NAME',

Line 2177: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2180:
2181: RAISE Invalid_Runtime_Parameter;

Line 2213: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2216: p_msg_name => 'FEM_GL_POST_218',
2217: p_token1 => 'NUM',

Line 2228: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2231:
2232: EXCEPTION

Line 2239: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2242: p_msg_name => 'FEM_GL_POST_024');
2243:

Line 2252: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2255: p_msg_name => 'FEM_GL_POST_001',
2256: p_token1 => 'DIMENSION_NAME',

Line 2284: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2287: p_msg_name => 'FEM_GL_POST_024');
2288:

Line 2295: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2298: p_msg_name => 'FEM_GL_POST_025',
2299: p_token1 => 'PARAMETER_NAME',

Line 2346: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2349:
2350: FEM_ENGINES_PKG.Tech_Message

Line 2352: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2355:
2356: SELECT dimension_id

Line 2363: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2366:
2367: SELECT dimension_id

Line 2374: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2377:
2378: SELECT dimension_id

Line 2385: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2388:
2389: SELECT dimension_id

Line 2396: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2399:
2400: SELECT dimension_id

Line 2407: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2410:
2411: SELECT dimension_id

Line 2418: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2421:
2422: SELECT dimension_id

Line 2429: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2432:
2433: EXCEPTION

Line 2470: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2473:
2474: -- Validate the Budget ID engine parameter by looking up the Budget

Line 2488: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2491: p_msg_name => 'FEM_GL_POST_204',
2492: p_token1 => 'VAR_NAME',

Line 2502: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2505:
2506: RAISE Invalid_Budget_ID;

Line 2525: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2528:
2529: RAISE Invalid_Dataset_Code;

Line 2545: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2548:
2549: RAISE Invalid_Dataset_Code;

Line 2556: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2559:
2560: RAISE Invalid_Budget_or_Dataset;

Line 2568: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2571:
2572: EXCEPTION

Line 2617: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2620:
2621: BEGIN

Line 2635: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2638: p_msg_name => 'FEM_GL_POST_204',
2639: p_token1 => 'VAR_NAME',

Line 2651: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2654: p_msg_name => 'FEM_GL_POST_204',
2655: p_token1 => 'VAR_NAME',

Line 2665: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2668:
2669: RAISE Invalid_Cal_Period_ID;

Line 2678: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2681:
2682: RAISE Ledger_Cal_NEQ_Period_Cal;

Line 2702: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2705:
2706: RAISE Invalid_Cal_Period_ID;

Line 2719: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2722: p_msg_name => 'FEM_GL_POST_204',
2723: p_token1 => 'VAR_NAME',

Line 2733: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2736:
2737: RAISE Invalid_Cal_Period_ID;

Line 2756: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2759:
2760: RAISE Invalid_Cal_Period_ID;

Line 2773: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2776: p_msg_name => 'FEM_GL_POST_204',
2777: p_token1 => 'VAR_NAME',

Line 2787: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2790:
2791: RAISE Invalid_Cal_Period_ID;

Line 2798: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2801:
2802: EXCEPTION

Line 2837: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2840:
2841:

Line 2855: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2858:
2859: RAISE Invalid_Dataset_Code;

Line 2878: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2881:
2882: RAISE Invalid_Dataset_Code;

Line 2895: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
2898: p_msg_name => 'FEM_GL_POST_204',
2899: p_token1 => 'VAR_NAME',

Line 2909: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2912:
2913: RAISE Invalid_Dataset_Code;

Line 2920: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2923:
2924: EXCEPTION

Line 2961: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
2964:
2965: IF pv_ds_balance_type_cd = 'ACTUAL' THEN

Line 3052: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3055:
3056: RAISE Invalid_DS_Bal_Type;

Line 3064: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3067:
3068: EXCEPTION

Line 3104: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3107:
3108: -- Validate the Encumbrance Type ID engine parameter by looking up

Line 3123: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3126: p_msg_name => 'FEM_GL_POST_204',
3127: p_token1 => 'VAR_NAME',

Line 3137: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3140:
3141: RAISE Invalid_Enc_Type_ID;

Line 3161: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3164:
3165: RAISE Invalid_Dataset_Code;

Line 3181: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3184:
3185: RAISE Invalid_Dataset_Code;

Line 3192: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3195:
3196: RAISE Invalid_Enc_or_Dataset;

Line 3204: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3207:
3208: EXCEPTION

Line 3249: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3252:
3253: BEGIN

Line 3267: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3270: p_msg_name => 'FEM_GL_POST_204',
3271: p_token1 => 'VAR_NAME',

Line 3281: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3284:
3285: RAISE Invalid_Ledger_ID;

Line 3304: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3307:
3308: pv_attr_label := 'ENTERED_CRNCY_ENABLE_FLAG';

Line 3323: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3326: p_msg_name => 'FEM_GL_POST_204',
3327: p_token1 => 'VAR_NAME',

Line 3337: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3340:
3341: pv_attr_label := 'ENTERED_CRNCY_ENABLE_FLAG';

Line 3362: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3365:
3366: pv_attr_label := 'CAL_PERIOD_HIER_OBJ_DEF_ID';

Line 3381: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3384: p_msg_name => 'FEM_GL_POST_204',
3385: p_token1 => 'VAR_NAME',

Line 3397: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3400: p_msg_name => 'FEM_GL_POST_204',
3401: p_token1 => 'VAR_NAME',

Line 3411: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3414:
3415: pv_attr_label := 'CAL_PERIOD_HIER_OBJ_DEF_ID';

Line 3431: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3434: p_msg_name => 'FEM_GL_POST_204',
3435: p_token1 => 'VAR_NAME',

Line 3445: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3448:
3449: pv_attr_label := 'CAL_PERIOD_HIER_OBJ_DEF_ID';

Line 3471: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3474:
3475: pv_attr_label := 'LEDGER_FUNCTIONAL_CRNCY_CODE';

Line 3490: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3493: p_msg_name => 'FEM_GL_POST_204',
3494: p_token1 => 'VAR_NAME',

Line 3504: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3507:
3508: pv_attr_label := 'LEDGER_FUNCTIONAL_CRNCY_CODE';

Line 3529: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3532:
3533: pv_attr_label := 'GLOBAL_VS_COMBO';

Line 3548: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3551: p_msg_name => 'FEM_GL_POST_204',
3552: p_token1 => 'VAR_NAME',

Line 3562: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3565:
3566: pv_attr_label := 'GLOBAL_VS_COMBO';

Line 3575: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3578:
3579: EXCEPTION

Line 3624: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3627:
3628: -- --------------------------------------------------------------------

Line 3643: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3646: p_msg_name => 'FEM_GL_POST_204',
3647: p_token1 => 'VAR_NAME',

Line 3654: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3657: p_msg_name => 'FEM_GL_POST_204',
3658: p_token1 => 'VAR_NAME',

Line 3668: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3671:
3672: RAISE Invalid_Object_Def_ID;

Line 3688: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3691: p_msg_name => 'FEM_GL_POST_204',
3692: p_token1 => 'VAR_NAME',

Line 3699: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3702: p_msg_name => 'FEM_GL_POST_204',
3703: p_token1 => 'VAR_NAME',

Line 3713: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3716:
3717: RAISE Invalid_Object_ID;

Line 3750: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3753:
3754: v_ds_production_flag := 'N';

Line 3778: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3781:
3782: RAISE Invalid_Obj_Approval_Status;

Line 3791: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3794:
3795: EXCEPTION

Line 3861: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3864:
3865: --------------------------------------------------------------------------

Line 3875: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
3878:
3879: RAISE Invalid_Execution_Mode;

Line 3896: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3899: p_msg_name => 'FEM_GL_POST_204',
3900: p_token1 => 'VAR_NAME',

Line 3907: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3910: p_msg_name => 'FEM_GL_POST_204',
3911: p_token1 => 'VAR_NAME',

Line 3918: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3921: p_msg_name => 'FEM_GL_POST_204',
3922: p_token1 => 'VAR_NAME',

Line 3929: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3932: p_msg_name => 'FEM_GL_POST_204',
3933: p_token1 => 'VAR_NAME',

Line 3983: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
3986: p_msg_name => 'FEM_GL_POST_023');
3987:

Line 4006: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4009: p_msg_name => 'FEM_GL_POST_020');
4010:

Line 4028: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4031: p_msg_name => 'FEM_GL_POST_021');
4032:

Line 4056: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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');
4059:
4060: EXCEPTION

Line 4091: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4094: p_msg_name => 'FEM_GL_POST_003',
4095: p_token1 => 'DIMENSION_NAME1',

Line 4120: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4123: p_msg_name => 'FEM_GL_POST_007');
4124:

Line 4144: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4147: p_msg_name => 'FEM_GL_POST_002',
4148: p_token1 => 'DIMENSION_NAME1',

Line 4176: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4179: p_msg_name => 'FEM_GL_POST_002',
4180: p_token1 => 'DIMENSION_NAME1',

Line 4256: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4259: p_msg_name => 'FEM_GL_POST_026',
4260: p_token1 => 'DS_BAL_TYPE_NAME',

Line 4287: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',

Line 4308: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4311: p_msg_name => 'FEM_GL_POST_009');
4312:

Line 4325: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4328: p_msg_name => 'FEM_GL_POST_014');
4329:

Line 4353: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',

Line 4378: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4381: p_msg_name => 'FEM_GL_POST_003',
4382: p_token1 => 'DIMENSION_NAME1',

Line 4409: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4412: p_msg_name => 'FEM_GL_POST_005');
4413:

Line 4426: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4429: p_msg_name => 'FEM_GL_POST_010');
4430:

Line 4442: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4445: p_msg_name => 'FEM_GL_POST_001',
4446: p_token1 => 'DIMENSION_NAME',

Line 4466: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4469: p_msg_name => 'FEM_GL_POST_006');
4470:

Line 4483: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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',
4486: p_msg_name => 'FEM_GL_POST_011');
4487:

Line 4508: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
4511:
4512: FEM_ENGINES_PKG.Tech_Message

Line 4514: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

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);
4517:
4518: -- Log the Oracle error message to the Concurrent Request Log.

Line 4579: v_module := 'fem.plsql.fem_gl_post_process_pkg.validate_ogl_eng_parameters';

4575:
4576: OGLEngParam_FatalErr EXCEPTION;
4577:
4578: BEGIN
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

Line 4580: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Validate_OGL_Eng_Parameters';

4576: OGLEngParam_FatalErr EXCEPTION;
4577:
4578: BEGIN
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,

Line 5777: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

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',
5780: p_token1 => 'DIMENSION_NAME',
5781: p_value1 => 'FEM_OBJECT_DEF_ID_TXT',

Line 5807: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

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');
5810: FEM_ENGINES_PKG.User_Message
5811: (p_app_name => 'FEM',

Line 5831: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

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');
5834: FEM_ENGINES_PKG.User_Message
5835: (p_app_name => 'FEM',

Line 5877: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

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',
5880: p_token1 => 'ATTR_NAME',
5881: p_value1 => v_attr_name,

Line 5900: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

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,

Line 5958: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

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
5961: (p_severity => pc_log_level_unexpected,
5962: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

Line 5962: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,

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:
5965: -- Log the Oracle error message to the Concurrent Request Log
5966: FEM_ENGINES_PKG.User_Message

Line 6061: v_module := 'fem.plsql.fem_gl_post_process_pkg.register_ogl_process_execution';

6057:
6058: OGLRegProc_FatalErr EXCEPTION;
6059:
6060: BEGIN
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

Line 6062: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Register_OGL_Process_Execution';

6058: OGLRegProc_FatalErr EXCEPTION;
6059:
6060: BEGIN
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,

Line 7242: v_module := 'fem.plsql.fem_gl_post_process_pkg.final_ogl_process_logging';

7238: WHERE REQUEST_ID IS NOT NULL
7239: ORDER BY OUTPUT_DATASET_CODE, CAL_PERIOD_ID;
7240:
7241: BEGIN
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

Line 7243: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Final_OGL_Process_Logging';

7239: ORDER BY OUTPUT_DATASET_CODE, CAL_PERIOD_ID;
7240:
7241: BEGIN
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,

Line 7732: END FEM_GL_POST_PROCESS_PKG;

7728:
7729: END Final_OGL_Process_Logging;
7730: -- =======================================================================
7731:
7732: END FEM_GL_POST_PROCESS_PKG;