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_XGL_POST_ENGINE_PKG dependencies on FEM_ENGINES_PKG

Line 48: FEM_ENGINES_PKG.Tech_Message

44: (x_condition_string IN OUT NOCOPY VARCHAR2) IS
45:
46: BEGIN
47:
48: FEM_ENGINES_PKG.Tech_Message
49: (p_severity => pc_log_level_procedure,
50: p_module => 'fem.plsql.xgl_eng.fcs.' || pv_process_slice,
51: p_app_name => 'FEM',
52: p_msg_name => 'FEM_GL_POST_201',

Line 84: FEM_ENGINES_PKG.Tech_Message

80: ' AND encumbrance_type_code = ''' ||
81: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd || '''';
82: END IF;
83:
84: FEM_ENGINES_PKG.Tech_Message
85: (p_severity => pc_log_level_procedure,
86: p_module => 'fem.plsql.xgl_eng.fcs.' || pv_process_slice,
87: p_app_name => 'FEM',
88: p_msg_name => 'FEM_GL_POST_202',

Line 120: FEM_ENGINES_PKG.Tech_Message

116: x_completion_code OUT NOCOPY NUMBER) IS
117:
118: BEGIN
119:
120: FEM_ENGINES_PKG.Tech_Message
121: (p_severity => pc_log_level_procedure,
122: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
123: p_app_name => 'FEM',
124: p_msg_name => 'FEM_GL_POST_201',

Line 201: FEM_ENGINES_PKG.Tech_Message

197: Finish_Condition_String(pv_marking_sql);
198:
199: pv_marking_sql := pv_marking_sql || ' AND ' || pv_data_slice_predicate;
200:
201: FEM_ENGINES_PKG.Tech_Message
202: (p_severity => pc_log_level_procedure,
203: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
204: p_msg_text => 'pv_marking_sql: ' || pv_marking_sql);
205:

Line 214: FEM_ENGINES_PKG.Tech_Message

210: -- ---------------------------------------------------------------------
211:
212: IF NOT pv_snapshot_rows_done THEN
213:
214: FEM_ENGINES_PKG.Tech_Message
215: (p_severity => pc_log_level_statement,
216: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
217: p_msg_text => 'Marking snapshot rows...');
218:

Line 231: FEM_ENGINES_PKG.Tech_Message

227: END IF;
228:
229: x_row_count_in_set := SQL%ROWCOUNT;
230:
231: FEM_ENGINES_PKG.Tech_Message
232: (p_severity => pc_log_level_statement,
233: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
234: p_app_name => 'FEM',
235: p_msg_name => 'FEM_GL_POST_217',

Line 241: FEM_ENGINES_PKG.Tech_Message

237: p_value1 => TO_CHAR(x_row_count_in_set),
238: p_token2 => 'TABLE',
239: p_value2 => 'FEM_BAL_INTERFACE_T');
240:
241: FEM_ENGINES_PKG.Tech_Message
242: (p_severity => pc_log_level_procedure,
243: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
244: p_app_name => 'FEM',
245: p_msg_name => 'FEM_GL_POST_202',

Line 260: FEM_ENGINES_PKG.User_Message

256: ROLLBACK;
257:
258: x_completion_code := 2;
259:
260: FEM_ENGINES_PKG.User_Message
261: (p_app_name => 'FEM',
262: p_msg_name => 'FEM_GL_POST_215',
263: p_token1 => 'ERR_MSG',
264: p_value1 => SQLERRM);

Line 266: FEM_ENGINES_PKG.Tech_Message

262: p_msg_name => 'FEM_GL_POST_215',
263: p_token1 => 'ERR_MSG',
264: p_value1 => SQLERRM);
265:
266: FEM_ENGINES_PKG.Tech_Message
267: (p_severity => pc_log_level_unexpected,
268: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
269: p_app_name => 'FEM',
270: p_msg_name => 'FEM_GL_POST_215',

Line 274: FEM_ENGINES_PKG.Tech_Message

270: p_msg_name => 'FEM_GL_POST_215',
271: p_token1 => 'ERR_MSG',
272: p_value1 => SQLERRM);
273:
274: FEM_ENGINES_PKG.Tech_Message
275: (p_severity => pc_log_level_procedure,
276: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
277: p_app_name => 'FEM',
278: p_msg_name => 'FEM_GL_POST_203',

Line 341: FEM_ENGINES_PKG.Tech_Message

337: pv_col VARCHAR2(30);
338:
339: BEGIN
340:
341: FEM_ENGINES_PKG.Tech_Message
342: (p_severity => pc_log_level_procedure,
343: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
344: p_app_name => 'FEM',
345: p_msg_name => 'FEM_GL_POST_201',

Line 379: FEM_ENGINES_PKG.Tech_Message

375: ' AND posting_request_id = :pv_req_id_slice ' ||
376: ' AND load_set_id = :p_load_set_id ';
377:
378: -- Print out sql statement for debugging purposes
379: FEM_ENGINES_PKG.Tech_Message
380: (p_severity => pc_log_level_statement,
381: p_module => 'fem.plsql.xgl_eng.vid.1.' || pv_process_slice,
382: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
383:

Line 403: FEM_ENGINES_PKG.Tech_Message

399: v_first_time := 'Y';
400: v_key_stmt2 := '';
401: v_key_stmt3 := '';
402:
403: FEM_ENGINES_PKG.Tech_Message
404: (p_severity => pc_log_level_statement,
405: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
406: p_app_name => 'FEM',
407: p_msg_name => 'FEM_GL_POST_204',

Line 446: FEM_ENGINES_PKG.Tech_Message

442: END IF;
443:
444: END LOOP;
445:
446: FEM_ENGINES_PKG.Tech_Message
447: (p_severity => pc_log_level_statement,
448: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
449: p_msg_text => 'v_key_stmt2: ' || v_key_stmt2);
450:

Line 451: FEM_ENGINES_PKG.Tech_Message

447: (p_severity => pc_log_level_statement,
448: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
449: p_msg_text => 'v_key_stmt2: ' || v_key_stmt2);
450:
451: FEM_ENGINES_PKG.Tech_Message
452: (p_severity => pc_log_level_statement,
453: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
454: p_msg_text => 'v_key_stmt3: ' || v_key_stmt3);
455:

Line 481: FEM_ENGINES_PKG.Tech_Message

477: ' AND load_method_code = ''S''' ||
478: ' AND posting_request_id = :pv_req_id_slice ';
479:
480: -- Print out sql statement for debugging purposes
481: FEM_ENGINES_PKG.Tech_Message
482: (p_severity => pc_log_level_statement,
483: p_module => 'fem.plsql.xgl_eng.vid.2.' || pv_process_slice,
484: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
485:

Line 520: FEM_ENGINES_PKG.Tech_Message

516: ' AND (load_set_id = :p_load_set_id OR ' ||
517: ' :p_proc_snapshot_rows = ''Y'')';
518:
519: -- Print out sql statement for debugging purposes
520: FEM_ENGINES_PKG.Tech_Message
521: (p_severity => pc_log_level_statement,
522: p_module => 'fem.plsql.xgl_eng.vid.3.' || pv_process_slice,
523: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
524:

Line 586: FEM_ENGINES_PKG.Tech_Message

582: ' AND (load_set_id = :p_load_set_id OR ' ||
583: ' :p_proc_snapshot_rows = ''Y'') ';
584:
585: -- Print out sql statement for debugging purposes
586: FEM_ENGINES_PKG.Tech_Message
587: (p_severity => pc_log_level_statement,
588: p_module => 'fem.plsql.xgl_eng.vid.4.' || pv_process_slice,
589: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
590:

Line 623: FEM_ENGINES_PKG.TECH_MESSAGE(

619: ' AND u.posting_error_code IS NULL ' ||
620: ' AND u.posting_request_id = :pv_req_id_slice ' ||
621: ' AND u.load_set_id = :p_load_set_id ';
622:
623: FEM_ENGINES_PKG.TECH_MESSAGE(
624: p_severity => pc_log_level_statement,
625: p_module => 'fem.plsql.xgl_eng.vid.5' || pv_process_slice,
626: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
627:

Line 639: FEM_ENGINES_PKG.Tech_Message

635: END IF;
636:
637: IF x_num_invalid_record > 0 THEN
638:
639: FEM_ENGINES_PKG.Tech_Message
640: (p_severity => pc_log_level_error,
641: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
642: p_app_name => 'FEM',
643: p_msg_name => 'FEM_GL_POST_223');

Line 658: FEM_ENGINES_PKG.Tech_Message

654: COMMIT;
655:
656: x_completion_code := 0;
657:
658: FEM_ENGINES_PKG.Tech_Message
659: (p_severity => pc_log_level_procedure,
660: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
661: p_app_name => 'FEM',
662: p_msg_name => 'FEM_GL_POST_202',

Line 677: FEM_ENGINES_PKG.TECH_MESSAGE

673: x_num_invalid_record := p_total_row_num;
674: x_records_to_post_flag := FALSE;
675: x_completion_code := 0;
676:
677: FEM_ENGINES_PKG.TECH_MESSAGE
678: (p_severity => pc_log_level_error,
679: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
680: p_msg_text => 'Mixed LOAD_METHOD_CODE values for load set: ' ||
681: TO_CHAR(p_load_set_id) ||

Line 684: FEM_ENGINES_PKG.Tech_Message

680: p_msg_text => 'Mixed LOAD_METHOD_CODE values for load set: ' ||
681: TO_CHAR(p_load_set_id) ||
682: '. Skipping processing for this load set.');
683:
684: FEM_ENGINES_PKG.Tech_Message
685: (p_severity => pc_log_level_procedure,
686: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
687: p_app_name => 'FEM',
688: p_msg_name => 'FEM_GL_POST_203',

Line 700: FEM_ENGINES_PKG.User_Message

696: ROLLBACK;
697:
698: x_completion_code := 2;
699:
700: FEM_ENGINES_PKG.User_Message
701: (p_app_name => 'FEM',
702: p_msg_name => 'FEM_GL_POST_215',
703: p_token1 => 'ERR_MSG',
704: p_value1 => SQLERRM);

Line 706: FEM_ENGINES_PKG.Tech_Message

702: p_msg_name => 'FEM_GL_POST_215',
703: p_token1 => 'ERR_MSG',
704: p_value1 => SQLERRM);
705:
706: FEM_ENGINES_PKG.Tech_Message
707: (p_severity => pc_log_level_unexpected,
708: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
709: p_app_name => 'FEM',
710: p_msg_name => 'FEM_GL_POST_215',

Line 714: FEM_ENGINES_PKG.Tech_Message

710: p_msg_name => 'FEM_GL_POST_215',
711: p_token1 => 'ERR_MSG',
712: p_value1 => SQLERRM);
713:
714: FEM_ENGINES_PKG.Tech_Message
715: (p_severity => pc_log_level_procedure,
716: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
717: p_app_name => 'FEM',
718: p_msg_name => 'FEM_GL_POST_203',

Line 775: FEM_ENGINES_PKG.Tech_Message

771: v_rows_upd_count NUMBER;
772:
773: BEGIN
774:
775: FEM_ENGINES_PKG.Tech_Message
776: (p_severity => pc_log_level_procedure,
777: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
778: p_app_name => 'FEM',
779: p_msg_name => 'FEM_GL_POST_201',

Line 806: FEM_ENGINES_PKG.Tech_Message

802: v_proc_snapshot_rows := 'N';
803: END IF;
804:
805: -- Move all records in the current load set into FEM_BAL_POST_INTERIM_GT
806: FEM_ENGINES_PKG.Tech_Message
807: (p_severity => pc_log_level_event,
808: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
809: p_msg_text =>
810: 'Moving data from interface table to the interim table...');

Line 812: FEM_ENGINES_PKG.Tech_Message

808: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
809: p_msg_text =>
810: 'Moving data from interface table to the interim table...');
811:
812: FEM_ENGINES_PKG.Tech_Message
813: (p_severity => pc_log_level_statement,
814: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
815: p_app_name => 'FEM',
816: p_msg_name => 'FEM_GL_POST_204',

Line 890: FEM_ENGINES_PKG.Tech_Message

886: v_rows_ins_count := SQL%ROWCOUNT;
887:
888: COMMIT;
889:
890: FEM_ENGINES_PKG.Tech_Message
891: (p_severity => pc_log_level_statement,
892: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
893: p_app_name => 'FEM',
894: p_msg_name => 'FEM_GL_POST_204',

Line 900: FEM_ENGINES_PKG.Tech_Message

896: p_value1 => 'End Time',
897: p_token2 => 'VAR_VAL',
898: p_value2 => TO_CHAR(SYSDATE, 'HH24:MI:SS'));
899:
900: FEM_ENGINES_PKG.Tech_Message
901: (p_severity => pc_log_level_statement,
902: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
903: p_app_name => 'FEM',
904: p_msg_name => 'FEM_GL_POST_216',

Line 915: FEM_ENGINES_PKG.Tech_Message

911: -- dimension members. We will process 5 dimensions at a time
912: -- due to potential performance implications when joining to
913: -- too many tables at a time
914:
915: FEM_ENGINES_PKG.Tech_Message
916: (p_severity => pc_log_level_event,
917: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
918: p_msg_text =>
919: 'Looking up member numeric IDs for 5 dimensions at a time...');

Line 944: FEM_ENGINES_PKG.Tech_Message

940: 'USER_DIM4_ID', 'USER_DIM5_ID', 'USER_DIM6_ID', 'USER_DIM7_ID',
941: 'USER_DIM8_ID', 'USER_DIM9_ID', 'USER_DIM10_ID',
942: 'SOURCE_SYSTEM_CODE')) THEN
943:
944: FEM_ENGINES_PKG.Tech_Message
945: (p_severity => pc_log_level_statement,
946: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
947: p_app_name => 'FEM',
948: p_msg_name => 'FEM_GL_POST_204',

Line 954: FEM_ENGINES_PKG.Tech_Message

950: p_value1 => 'v',
951: p_token2 => 'VAR_VAL',
952: p_value2 => TO_CHAR(v));
953:
954: FEM_ENGINES_PKG.Tech_Message
955: (p_severity => pc_log_level_statement,
956: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
957: p_app_name => 'FEM',
958: p_msg_name => 'FEM_GL_POST_204',

Line 964: FEM_ENGINES_PKG.Tech_Message

960: p_value1 => 'v_dim_count',
961: p_token2 => 'VAR_VAL',
962: p_value2 => TO_CHAr(v_dim_count));
963:
964: FEM_ENGINES_PKG.Tech_Message
965: (p_severity => pc_log_level_statement,
966: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
967: p_app_name => 'FEM',
968: p_msg_name => 'FEM_GL_POST_204',

Line 1021: FEM_ENGINES_PKG.Tech_Message

1017: RTRIM(v_sel_stmt, ', ') || ' ' ||
1018: RTRIM(v_tab_list, ', ') || ' ' ||
1019: v_join_stmt || ')';
1020:
1021: FEM_ENGINES_PKG.Tech_Message
1022: (p_severity => pc_log_level_statement,
1023: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1024: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
1025:

Line 1026: FEM_ENGINES_PKG.Tech_Message

1022: (p_severity => pc_log_level_statement,
1023: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1024: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
1025:
1026: FEM_ENGINES_PKG.Tech_Message
1027: (p_severity => pc_log_level_statement,
1028: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1029: p_app_name => 'FEM',
1030: p_msg_name => 'FEM_GL_POST_204',

Line 1040: FEM_ENGINES_PKG.Tech_Message

1036: EXECUTE IMMEDIATE v_sql_stmt;
1037:
1038: v_rows_upd_count := SQL%ROWCOUNT;
1039:
1040: FEM_ENGINES_PKG.Tech_Message
1041: (p_severity => pc_log_level_statement,
1042: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1043: p_app_name => 'FEM',
1044: p_msg_name => 'FEM_GL_POST_204',

Line 1050: FEM_ENGINES_PKG.Tech_Message

1046: p_value1 => 'End Time',
1047: p_token2 => 'VAR_VAL',
1048: p_value2 => TO_CHAR(SYSDATE, 'HH24:MI:SS'));
1049:
1050: FEM_ENGINES_PKG.Tech_Message
1051: (p_severity => pc_log_level_statement,
1052: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1053: p_app_name => 'FEM',
1054: p_msg_name => 'FEM_GL_POST_217',

Line 1072: FEM_ENGINES_PKG.Tech_Message

1068: -- Check all records in FEM_BAL_POST_INTERIM_GT and see if any
1069: -- records have missing dimension member ID.
1070: -- If so, mark them with error code.
1071:
1072: FEM_ENGINES_PKG.Tech_Message
1073: (p_severity => pc_log_level_statement,
1074: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1075: p_msg_text => 'Checking for missing dimension member ID...');
1076:

Line 1110: FEM_ENGINES_PKG.Tech_Message

1106: END IF;
1107:
1108: END LOOP;
1109:
1110: FEM_ENGINES_PKG.Tech_Message
1111: (p_severity => pc_log_level_statement,
1112: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1113: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
1114:

Line 1117: FEM_ENGINES_PKG.Tech_Message

1113: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
1114:
1115: BEGIN
1116:
1117: FEM_ENGINES_PKG.Tech_Message
1118: (p_severity => pc_log_level_statement,
1119: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1120: p_app_name => 'FEM',
1121: p_msg_name => 'FEM_GL_POST_204',

Line 1131: FEM_ENGINES_PKG.Tech_Message

1127: EXECUTE IMMEDIATE v_sql_stmt;
1128:
1129: x_cur_data_err_rows := SQL%ROWCOUNT;
1130:
1131: FEM_ENGINES_PKG.Tech_Message
1132: (p_severity => pc_log_level_statement,
1133: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1134: p_app_name => 'FEM',
1135: p_msg_name => 'FEM_GL_POST_204',

Line 1141: FEM_ENGINES_PKG.Tech_Message

1137: p_value1 => 'End Time',
1138: p_token2 => 'VAR_VAL',
1139: p_value2 => TO_CHAR(SYSDATE, 'HH24:MI:SS'));
1140:
1141: FEM_ENGINES_PKG.Tech_Message
1142: (p_severity => pc_log_level_statement,
1143: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1144: p_app_name => 'FEM',
1145: p_msg_name => 'FEM_GL_POST_217',

Line 1162: FEM_ENGINES_PKG.Tech_Message

1158: IF (x_cur_data_err_rows > 0) THEN
1159:
1160: IF pv_snapshot_rows_done THEN
1161:
1162: FEM_ENGINES_PKG.Tech_Message
1163: (p_severity => pc_log_level_error,
1164: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1165: p_app_name => 'FEM',
1166: p_msg_name => 'FEM_GL_POST_223');

Line 1170: FEM_ENGINES_PKG.Tech_Message

1166: p_msg_name => 'FEM_GL_POST_223');
1167:
1168: ELSE
1169:
1170: FEM_ENGINES_PKG.Tech_Message
1171: (p_severity => pc_log_level_event,
1172: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1173: p_app_name => 'FEM',
1174: p_msg_text => 'Invalid records are found in the snapshot pass');

Line 1181: FEM_ENGINES_PKG.Tech_Message

1177:
1178: -- Update corresponding error code column in FEM_BAL_INTERFACE_T
1179: -- based on FEM_BAL_POST_INTERIM_GT
1180:
1181: FEM_ENGINES_PKG.Tech_Message
1182: (p_severity => pc_log_level_event,
1183: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1184: p_msg_text => 'Updating interface table with error codes...');
1185:

Line 1193: FEM_ENGINES_PKG.Tech_Message

1189: (SELECT interface_rowid
1190: FROM fem_bal_post_interim_gt
1191: WHERE posting_error_flag = 'Y');
1192:
1193: FEM_ENGINES_PKG.Tech_Message
1194: (p_severity => pc_log_level_statement,
1195: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1196: p_app_name => 'FEM',
1197: p_msg_name => 'FEM_GL_POST_217',

Line 1215: FEM_ENGINES_PKG.Tech_Message

1211: x_nothing_to_post := TRUE;
1212: END IF;
1213:
1214: -- Count number of previous error processed successfully
1215: FEM_ENGINES_PKG.Tech_Message
1216: (p_severity => pc_log_level_statement,
1217: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1218: p_msg_text => 'Counting number of previous error rows reprocessed...');
1219:

Line 1231: FEM_ENGINES_PKG.Tech_Message

1227: WHEN NO_DATA_FOUND THEN
1228: x_prev_err_rows_reproc := 0;
1229: END;
1230:
1231: FEM_ENGINES_PKG.Tech_Message
1232: (p_severity => pc_log_level_procedure,
1233: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1234: p_app_name => 'FEM',
1235: p_msg_name => 'FEM_GL_POST_202',

Line 1248: FEM_ENGINES_PKG.User_Message

1244: ROLLBACK;
1245:
1246: x_completion_code := 2;
1247:
1248: FEM_ENGINES_PKG.User_Message
1249: (p_app_name => 'FEM',
1250: p_msg_name => 'FEM_GL_POST_215',
1251: p_token1 => 'ERR_MSG',
1252: p_value1 => SQLERRM);

Line 1254: FEM_ENGINES_PKG.Tech_Message

1250: p_msg_name => 'FEM_GL_POST_215',
1251: p_token1 => 'ERR_MSG',
1252: p_value1 => SQLERRM);
1253:
1254: FEM_ENGINES_PKG.Tech_Message
1255: (p_severity => pc_log_level_unexpected,
1256: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1257: p_app_name => 'FEM',
1258: p_msg_name => 'FEM_GL_POST_215',

Line 1262: FEM_ENGINES_PKG.Tech_Message

1258: p_msg_name => 'FEM_GL_POST_215',
1259: p_token1 => 'ERR_MSG',
1260: p_value1 => SQLERRM);
1261:
1262: FEM_ENGINES_PKG.Tech_Message
1263: (p_severity => pc_log_level_procedure,
1264: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1265: p_app_name => 'FEM',
1266: p_msg_name => 'FEM_GL_POST_203',

Line 1321: FEM_ENGINES_PKG.Tech_Message

1317: v_nothing_to_post BOOLEAN;
1318:
1319: BEGIN
1320:
1321: FEM_ENGINES_PKG.Tech_Message
1322: (p_severity => pc_log_level_procedure,
1323: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1324: p_app_name => 'FEM',
1325: p_msg_name => 'FEM_GL_POST_201',

Line 1346: FEM_ENGINES_PKG.Tech_Message

1342: -- --------------------------------------------------------------
1343: -- *** Mark rows for processing by populating the request ID ***
1344: -- --------------------------------------------------------------
1345:
1346: FEM_ENGINES_PKG.Tech_Message
1347: (p_severity => pc_log_level_event,
1348: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1349: p_app_name => 'FEM',
1350: p_msg_name => 'FEM_GL_POST_222');

Line 1369: FEM_ENGINES_PKG.Tech_Message

1365: -- -------------------------------------------
1366: -- *** Validate Interface Data ***
1367: -- -------------------------------------------
1368:
1369: FEM_ENGINES_PKG.Tech_Message
1370: (p_severity => pc_log_level_event,
1371: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1372: p_app_name => 'FEM',
1373: p_msg_name => 'FEM_GL_POST_211');

Line 1386: FEM_ENGINES_PKG.Tech_Message

1382: x_completion_code => v_compl_code);
1383:
1384: x_cur_data_err_rows := v_err_count;
1385:
1386: FEM_ENGINES_PKG.Tech_Message
1387: (p_severity => pc_log_level_statement,
1388: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1389: p_app_name => 'FEM',
1390: p_msg_name => 'FEM_GL_POST_204',

Line 1406: FEM_ENGINES_PKG.Tech_Message

1402: -- ------------------------------
1403: -- *** Post to Interim table ***
1404: -- ------------------------------
1405:
1406: FEM_ENGINES_PKG.Tech_Message
1407: (p_severity => pc_log_level_event,
1408: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1409: p_app_name => 'FEM',
1410: p_msg_name => 'FEM_GL_POST_212');

Line 1424: FEM_ENGINES_PKG.Tech_Message

1420:
1421: x_prev_err_rows_reproc := v_prev_err_rows_reproc;
1422: x_cur_data_err_rows := x_cur_data_err_rows + v_err_count;
1423:
1424: FEM_ENGINES_PKG.Tech_Message
1425: (p_severity => pc_log_level_statement,
1426: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1427: p_app_name => 'FEM',
1428: p_msg_name => 'FEM_GL_POST_204',

Line 1434: FEM_ENGINES_PKG.Tech_Message

1430: p_value1 => 'v_prev_err_rows_reproc',
1431: p_token2 => 'VAR_VAL',
1432: p_value2 => TO_CHAR(v_prev_err_rows_reproc));
1433:
1434: FEM_ENGINES_PKG.Tech_Message
1435: (p_severity => pc_log_level_statement,
1436: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1437: p_app_name => 'FEM',
1438: p_msg_name => 'FEM_GL_POST_204',

Line 1454: FEM_ENGINES_PKG.Tech_Message

1450: -- -----------------------------
1451: -- *** Post to FEM_BALANCES ***
1452: -- -----------------------------
1453:
1454: FEM_ENGINES_PKG.Tech_Message
1455: (p_severity => pc_log_level_event,
1456: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1457: p_app_name => 'FEM',
1458: p_msg_name => 'FEM_GL_POST_214');

Line 1472: FEM_ENGINES_PKG.Tech_Message

1468: END IF;
1469:
1470: x_posted_row_num := v_posted_rows;
1471:
1472: FEM_ENGINES_PKG.Tech_Message
1473: (p_severity => pc_log_level_statement,
1474: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1475: p_app_name => 'FEM',
1476: p_msg_name => 'FEM_GL_POST_204',

Line 1482: FEM_ENGINES_PKG.Tech_Message

1478: p_value1 => 'x_posted_row_num',
1479: p_token2 => 'VAR_VAL',
1480: p_value2 => TO_CHAR(x_posted_row_num));
1481:
1482: FEM_ENGINES_PKG.Tech_Message
1483: (p_severity => pc_log_level_procedure,
1484: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1485: p_app_name => 'FEM',
1486: p_msg_name => 'FEM_GL_POST_202',

Line 1499: FEM_ENGINES_PKG.Tech_Message

1495: x_completion_code := 0;
1496:
1497: IF pv_snapshot_rows_done THEN
1498:
1499: FEM_ENGINES_PKG.Tech_Message
1500: (p_severity => pc_log_level_event,
1501: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1502: p_app_name => 'FEM',
1503: p_msg_name => 'FEM_GL_POST_219',

Line 1509: FEM_ENGINES_PKG.Tech_Message

1505: p_value1 => TO_CHAR(p_load_set_id));
1506:
1507: ELSE
1508:
1509: FEM_ENGINES_PKG.Tech_Message
1510: (p_severity => pc_log_level_event,
1511: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1512: p_app_name => 'FEM',
1513: p_msg_text => 'Posting process found nothing to post for ' ||

Line 1518: FEM_ENGINES_PKG.Tech_Message

1514: 'the snapshot pass');
1515:
1516: END IF;
1517:
1518: FEM_ENGINES_PKG.Tech_Message
1519: (p_severity => pc_log_level_procedure,
1520: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1521: p_app_name => 'FEM',
1522: p_msg_name => 'FEM_GL_POST_202',

Line 1534: FEM_ENGINES_PKG.Tech_Message

1530: ROLLBACK;
1531:
1532: x_completion_code := 2;
1533:
1534: FEM_ENGINES_PKG.Tech_Message
1535: (p_severity => pc_log_level_procedure,
1536: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1537: p_app_name => 'FEM',
1538: p_msg_name => 'FEM_GL_POST_203',

Line 1550: FEM_ENGINES_PKG.User_Message

1546: ROLLBACK;
1547:
1548: x_completion_code := 2;
1549:
1550: FEM_ENGINES_PKG.User_Message
1551: (p_app_name => 'FEM',
1552: p_msg_name => 'FEM_GL_POST_215',
1553: p_token1 => 'ERR_MSG',
1554: p_value1 => SQLERRM);

Line 1556: FEM_ENGINES_PKG.Tech_Message

1552: p_msg_name => 'FEM_GL_POST_215',
1553: p_token1 => 'ERR_MSG',
1554: p_value1 => SQLERRM);
1555:
1556: FEM_ENGINES_PKG.Tech_Message
1557: (p_severity => pc_log_level_unexpected,
1558: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1559: p_app_name => 'FEM',
1560: p_msg_name => 'FEM_GL_POST_215',

Line 1564: FEM_ENGINES_PKG.Tech_Message

1560: p_msg_name => 'FEM_GL_POST_215',
1561: p_token1 => 'ERR_MSG',
1562: p_value1 => SQLERRM);
1563:
1564: FEM_ENGINES_PKG.Tech_Message
1565: (p_severity => pc_log_level_procedure,
1566: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1567: p_app_name => 'FEM',
1568: p_msg_name => 'FEM_GL_POST_203',

Line 1634: FEM_ENGINES_PKG.User_Message

1630: -- info about the FEM_GL_POST_INVALID_DIM_MEMBER error code and the
1631: -- dimension display code columns in the interface table to which it may
1632: -- apply.
1633:
1634: FEM_ENGINES_PKG.User_Message
1635: (p_app_name => 'FEM',
1636: p_msg_name => 'FEM_GL_POST_229');
1637:
1638: -- List each of the non-VSR dimension display code interface columns to

Line 1644: FEM_ENGINES_PKG.User_Message

1640: -- the Dimension Name against which it is validated.
1641:
1642: FOR non_vsr_dim IN c1 LOOP
1643:
1644: FEM_ENGINES_PKG.User_Message
1645: (p_app_name => 'FEM',
1646: p_msg_name => 'FEM_GL_POST_230',
1647: p_token1 => 'DIM_DC_COL',
1648: p_value1 => non_vsr_dim.interface_column_name,

Line 1660: FEM_ENGINES_PKG.User_Message

1656: -- the Dimension Name and Value Set against which it is validated.
1657:
1658: FOR vsr_dim IN c2 LOOP
1659:
1660: FEM_ENGINES_PKG.User_Message
1661: (p_app_name => 'FEM',
1662: p_msg_name => 'FEM_GL_POST_231',
1663: p_token1 => 'DIM_DC_COL',
1664: p_value1 => vsr_dim.interface_column_name,

Line 1676: FEM_ENGINES_PKG.User_Message

1672: -- Other data validation error codes that may be reported in
1673: -- POSTING_ERROR_CODE are listed below with their descriptions,
1674: -- to aid in correcting the data errors in the interface table:
1675:
1676: FEM_ENGINES_PKG.User_Message
1677: (p_app_name => 'FEM',
1678: p_msg_name => 'FEM_GL_POST_232');
1679:
1680: -- List descriptions for the following data validation error codes:

Line 1689: FEM_ENGINES_PKG.User_Message

1685: -- FEM_GL_POST_MIX_LOAD_METHOD
1686: -- FEM_GL_POST_PREV_SET_ERROR
1687: -- FEM_GL_POST_TO_BE_REPROCESSED
1688:
1689: FEM_ENGINES_PKG.User_Message
1690: (p_app_name => 'FEM',
1691: p_msg_name => 'FEM_GL_POST_233',
1692: p_token1 => 'DATA_ERROR_MSG_NAME',
1693: p_value1 => 'FEM_GL_POST_DUP_PROC_KEYS',

Line 1699: FEM_ENGINES_PKG.User_Message

1695: p_token2 => 'DATA_ERROR_MSG_TEXT',
1696: p_value2 => 'FEM_GL_POST_DUP_PROC_KEYS',
1697: p_trans2 => 'Y');
1698:
1699: FEM_ENGINES_PKG.User_Message
1700: (p_app_name => 'FEM',
1701: p_msg_name => 'FEM_GL_POST_233',
1702: p_token1 => 'DATA_ERROR_MSG_NAME',
1703: p_value1 => 'FEM_GL_POST_INVALID_CURR_TYPE',

Line 1709: FEM_ENGINES_PKG.User_Message

1705: p_token2 => 'DATA_ERROR_MSG_TEXT',
1706: p_value2 => 'FEM_GL_POST_INVALID_CURR_TYPE',
1707: p_trans2 => 'Y');
1708:
1709: FEM_ENGINES_PKG.User_Message
1710: (p_app_name => 'FEM',
1711: p_msg_name => 'FEM_GL_POST_233',
1712: p_token1 => 'DATA_ERROR_MSG_NAME',
1713: p_value1 => 'FEM_GL_POST_INVALID_POST_TYPE',

Line 1719: FEM_ENGINES_PKG.User_Message

1715: p_token2 => 'DATA_ERROR_MSG_TEXT',
1716: p_value2 => 'FEM_GL_POST_INVALID_POST_TYPE',
1717: p_trans2 => 'Y');
1718:
1719: FEM_ENGINES_PKG.User_Message
1720: (p_app_name => 'FEM',
1721: p_msg_name => 'FEM_GL_POST_233',
1722: p_token1 => 'DATA_ERROR_MSG_NAME',
1723: p_value1 => 'FEM_GL_POST_MISSING_BAL_COL',

Line 1729: FEM_ENGINES_PKG.User_Message

1725: p_token2 => 'DATA_ERROR_MSG_TEXT',
1726: p_value2 => 'FEM_GL_POST_MISSING_BAL_COL',
1727: p_trans2 => 'Y');
1728:
1729: FEM_ENGINES_PKG.User_Message
1730: (p_app_name => 'FEM',
1731: p_msg_name => 'FEM_GL_POST_233',
1732: p_token1 => 'DATA_ERROR_MSG_NAME',
1733: p_value1 => 'FEM_GL_POST_MIX_LOAD_METHOD',

Line 1739: FEM_ENGINES_PKG.User_Message

1735: p_token2 => 'DATA_ERROR_MSG_TEXT',
1736: p_value2 => 'FEM_GL_POST_MIX_LOAD_METHOD',
1737: p_trans2 => 'Y');
1738:
1739: FEM_ENGINES_PKG.User_Message
1740: (p_app_name => 'FEM',
1741: p_msg_name => 'FEM_GL_POST_233',
1742: p_token1 => 'DATA_ERROR_MSG_NAME',
1743: p_value1 => 'FEM_GL_POST_PREV_SET_ERROR',

Line 1749: FEM_ENGINES_PKG.User_Message

1745: p_token2 => 'DATA_ERROR_MSG_TEXT',
1746: p_value2 => 'FEM_GL_POST_PREV_SET_ERROR',
1747: p_trans2 => 'Y');
1748:
1749: FEM_ENGINES_PKG.User_Message
1750: (p_app_name => 'FEM',
1751: p_msg_name => 'FEM_GL_POST_233',
1752: p_token1 => 'DATA_ERROR_MSG_NAME',
1753: p_value1 => 'FEM_GL_POST_TO_BE_REPROCESSED',

Line 1846: FEM_ENGINES_PKG.Tech_Message

1842: v_xgl_rule_type_name fem_object_types_tl.object_type_name%TYPE;
1843:
1844: BEGIN
1845:
1846: FEM_ENGINES_PKG.Tech_Message
1847: (p_severity => pc_log_level_procedure,
1848: p_module => 'fem.plsql.xgl_eng.main',
1849: p_app_name => 'FEM',
1850: p_msg_name => 'FEM_GL_POST_201',

Line 1856: FEM_ENGINES_PKG.User_Message

1852: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
1853: p_token2 => 'TIME',
1854: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1855:
1856: FEM_ENGINES_PKG.User_Message
1857: (p_app_name => 'FEM',
1858: p_msg_name => 'FEM_GL_POST_207');
1859:
1860: FEM_ENGINES_PKG.Tech_Message

Line 1860: FEM_ENGINES_PKG.Tech_Message

1856: FEM_ENGINES_PKG.User_Message
1857: (p_app_name => 'FEM',
1858: p_msg_name => 'FEM_GL_POST_207');
1859:
1860: FEM_ENGINES_PKG.Tech_Message
1861: (p_severity => pc_log_level_event,
1862: p_module => 'fem.plsql.xgl_eng.main',
1863: p_app_name => 'FEM',
1864: p_msg_name => 'FEM_GL_POST_207');

Line 1890: FEM_ENGINES_PKG.User_Message

1886: v_cp_status := 'ERROR';
1887: RAISE FEMXGL_fatal_err;
1888: END IF;
1889:
1890: FEM_ENGINES_PKG.User_Message
1891: (p_app_name => 'FEM',
1892: p_msg_name => 'FEM_GL_POST_208');
1893:
1894: FEM_ENGINES_PKG.Tech_Message

Line 1894: FEM_ENGINES_PKG.Tech_Message

1890: FEM_ENGINES_PKG.User_Message
1891: (p_app_name => 'FEM',
1892: p_msg_name => 'FEM_GL_POST_208');
1893:
1894: FEM_ENGINES_PKG.Tech_Message
1895: (p_severity => pc_log_level_event,
1896: p_module => 'fem.plsql.xgl_eng.main',
1897: p_app_name => 'FEM',
1898: p_msg_name => 'FEM_GL_POST_208');

Line 1922: FEM_ENGINES_PKG.User_Message

1918: status => v_status,
1919: industry => v_industry,
1920: oracle_schema => pv_schema_name) THEN
1921:
1922: FEM_ENGINES_PKG.User_Message
1923: (p_app_name => 'FEM',
1924: p_msg_name => 'FEM_GL_POST_227');
1925:
1926: FEM_ENGINES_PKG.Tech_Message

Line 1926: FEM_ENGINES_PKG.Tech_Message

1922: FEM_ENGINES_PKG.User_Message
1923: (p_app_name => 'FEM',
1924: p_msg_name => 'FEM_GL_POST_227');
1925:
1926: FEM_ENGINES_PKG.Tech_Message
1927: (p_severity => pc_log_level_error,
1928: p_module => 'fem.plsql.xgl_eng.main',
1929: p_app_name => 'FEM',
1930: p_msg_name => 'FEM_GL_POST_227');

Line 1973: FEM_ENGINES_PKG.Tech_Message

1969:
1970: Finish_Condition_String(x_condition_string => v_slices_condition);
1971:
1972: -- Print out v_slices_condition for debugging purposes
1973: FEM_ENGINES_PKG.Tech_Message
1974: (p_severity => pc_log_level_statement,
1975: p_module => 'fem.plsql.xgl_eng.main',
1976: p_msg_text => 'v_slices_condition: ' || v_slices_condition);
1977:

Line 2053: FEM_ENGINES_PKG.Tech_Message

2049: P_ARG14 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
2050: P_ARG15 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2051: P_ARG16 => pv_schema_name);
2052:
2053: FEM_ENGINES_PKG.Tech_Message
2054: (p_severity => pc_log_level_statement,
2055: p_module => 'fem.plsql.xgl_eng.main',
2056: p_app_name => 'FEM',
2057: p_msg_name => 'FEM_GL_POST_204',

Line 2080: FEM_ENGINES_PKG.Tech_Message

2076: RAISE FEMXGL_no_data_to_load;
2077:
2078: ELSIF v_exception_code IS NOT NULL THEN
2079:
2080: FEM_ENGINES_PKG.Tech_Message
2081: (p_severity => pc_log_level_statement,
2082: p_module => 'fem.plsql.xgl_eng.main',
2083: p_app_name => 'FEM',
2084: p_msg_name => 'FEM_GL_POST_204',

Line 2110: FEM_ENGINES_PKG.Tech_Message

2106: INTO v_tot_posted_rows, v_tot_prev_err_rows_reproc, v_tot_cur_data_err_rows
2107: FROM fem_mp_process_ctl_t
2108: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id;
2109:
2110: FEM_ENGINES_PKG.Tech_Message
2111: (p_severity => pc_log_level_statement,
2112: p_module => 'fem.plsql.xgl_eng.main',
2113: p_app_name => 'FEM',
2114: p_msg_name => 'FEM_GL_POST_204',

Line 2120: FEM_ENGINES_PKG.Tech_Message

2116: p_value1 => 'v_tot_posted_rows',
2117: p_token2 => 'VAR_VAL',
2118: p_value2 => TO_CHAR(v_tot_posted_rows));
2119:
2120: FEM_ENGINES_PKG.Tech_Message
2121: (p_severity => pc_log_level_statement,
2122: p_module => 'fem.plsql.xgl_eng.main',
2123: p_app_name => 'FEM',
2124: p_msg_name => 'FEM_GL_POST_204',

Line 2130: FEM_ENGINES_PKG.Tech_Message

2126: p_value1 => 'v_tot_prev_err_rows_reproc',
2127: p_token2 => 'VAR_VAL',
2128: p_value2 => TO_CHAR(v_tot_prev_err_rows_reproc));
2129:
2130: FEM_ENGINES_PKG.Tech_Message
2131: (p_severity => pc_log_level_statement,
2132: p_module => 'fem.plsql.xgl_eng.main',
2133: p_app_name => 'FEM',
2134: p_msg_name => 'FEM_GL_POST_204',

Line 2156: FEM_ENGINES_PKG.Tech_Message

2152: FROM fem_mp_process_ctl_t
2153: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id
2154: AND status = 2;
2155:
2156: FEM_ENGINES_PKG.Tech_Message
2157: (p_severity => pc_log_level_statement,
2158: p_module => 'fem.plsql.xgl_eng.main',
2159: p_app_name => 'FEM',
2160: p_msg_name => 'FEM_GL_POST_204',

Line 2170: FEM_ENGINES_PKG.Tech_Message

2166: -- Log all of the messages
2167:
2168: FOR i IN 1..v_msg_list.count LOOP
2169:
2170: FEM_ENGINES_PKG.Tech_Message
2171: (p_severity => pc_log_level_error,
2172: p_module => 'fem.plsql.xgl_eng.main',
2173: p_app_name => 'FEM',
2174: p_msg_text => v_msg_list(i));

Line 2176: FEM_ENGINES_PKG.User_Message

2172: p_module => 'fem.plsql.xgl_eng.main',
2173: p_app_name => 'FEM',
2174: p_msg_text => v_msg_list(i));
2175:
2176: FEM_ENGINES_PKG.User_Message
2177: (p_app_name => 'FEM',
2178: p_msg_text => v_msg_list(i));
2179:
2180: END LOOP;

Line 2270: FEM_ENGINES_PKG.User_Message

2266: -- WARNING: Some rows from the interface table have data errors
2267: -- and could not be loaded. Correct the errors in the remaining
2268: -- interface rows and resubmit them for processing.
2269:
2270: FEM_ENGINES_PKG.User_Message
2271: (p_app_name => 'FEM',
2272: p_msg_name => 'FEM_GL_POST_226');
2273:
2274: FEM_ENGINES_PKG.Tech_Message

Line 2274: FEM_ENGINES_PKG.Tech_Message

2270: FEM_ENGINES_PKG.User_Message
2271: (p_app_name => 'FEM',
2272: p_msg_name => 'FEM_GL_POST_226');
2273:
2274: FEM_ENGINES_PKG.Tech_Message
2275: (p_severity => pc_log_level_error,
2276: p_module => 'fem.plsql.xgl_eng.main',
2277: p_app_name => 'FEM',
2278: p_msg_name => 'FEM_GL_POST_226');

Line 2320: FEM_ENGINES_PKG.Tech_Message

2316: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2317: p_num_output_rows => v_tot_posted_rows,
2318: p_final_message_name => 'FEM_GL_POST_220');
2319:
2320: FEM_ENGINES_PKG.Tech_Message
2321: (p_severity => pc_log_level_procedure,
2322: p_module => 'fem.plsql.xgl_eng.main',
2323: p_app_name => 'FEM',
2324: p_msg_name => 'FEM_GL_POST_202',

Line 2344: FEM_ENGINES_PKG.Tech_Message

2340: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2341: p_num_output_rows => v_tot_posted_rows,
2342: p_final_message_name => 'FEM_GL_POST_205');
2343:
2344: FEM_ENGINES_PKG.Tech_Message
2345: (p_severity => pc_log_level_procedure,
2346: p_module => 'fem.plsql.xgl_eng.main',
2347: p_app_name => 'FEM',
2348: p_msg_name => 'FEM_GL_POST_203',

Line 2389: FEM_ENGINES_PKG.Tech_Message

2385: p_final_message_name => 'FEM_GL_POST_206');
2386:
2387: -- Logging final messages
2388:
2389: FEM_ENGINES_PKG.Tech_Message
2390: (p_severity => pc_log_level_procedure,
2391: p_module => 'fem.plsql.xgl_eng.main',
2392: p_app_name => 'FEM',
2393: p_msg_name => 'FEM_GL_POST_202',

Line 2421: FEM_ENGINES_PKG.User_Message

2417: INTO v_xgl_rule_type_name
2418: FROM fem_object_types_vl
2419: WHERE object_type_code = 'XGL_INTEGRATION';
2420:
2421: FEM_ENGINES_PKG.User_Message
2422: (p_app_name => 'FEM',
2423: p_msg_name => 'FEM_GL_POST_225',
2424: p_token1 => 'LOAD_METHOD_CODE',
2425: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,

Line 2442: FEM_ENGINES_PKG.User_Message

2438: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2439: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2440: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2441:
2442: FEM_ENGINES_PKG.User_Message
2443: (p_app_name => 'FEM',
2444: p_msg_name => 'FEM_GL_POST_228',
2445: p_token1 => 'DS_BAL_TYPE_ATTR_NAME',
2446: p_value1 => v_ds_bal_type_attr_name,

Line 2452: FEM_ENGINES_PKG.Tech_Message

2448: p_value2 => v_dataset_dim_name,
2449: p_token3 => 'XGL_RULE_TYPE_NAME',
2450: p_value3 => v_xgl_rule_type_name);
2451:
2452: FEM_ENGINES_PKG.Tech_Message
2453: (p_severity => pc_log_level_unexpected,
2454: p_module => 'fem.plsql.xgl_eng.main',
2455: p_app_name => 'FEM',
2456: p_msg_name => 'FEM_GL_POST_225',

Line 2507: FEM_ENGINES_PKG.Tech_Message

2503: (status => 'ERROR', message => NULL);
2504:
2505: END IF;
2506:
2507: FEM_ENGINES_PKG.Tech_Message
2508: (p_severity => pc_log_level_procedure,
2509: p_module => 'fem.plsql.xgl_eng.main',
2510: p_app_name => 'FEM',
2511: p_msg_name => 'FEM_GL_POST_202',

Line 2521: FEM_ENGINES_PKG.User_Message

2517: COMMIT;
2518:
2519: WHEN FEMXGL_all_data_invalid THEN
2520:
2521: FEM_ENGINES_PKG.User_Message
2522: (p_app_name => 'FEM',
2523: p_msg_name => 'FEM_GL_POST_224');
2524:
2525: FEM_ENGINES_PKG.Tech_Message

Line 2525: FEM_ENGINES_PKG.Tech_Message

2521: FEM_ENGINES_PKG.User_Message
2522: (p_app_name => 'FEM',
2523: p_msg_name => 'FEM_GL_POST_224');
2524:
2525: FEM_ENGINES_PKG.Tech_Message
2526: (p_severity => pc_log_level_error,
2527: p_module => 'fem.plsql.xgl_eng.main',
2528: p_app_name => 'FEM',
2529: p_msg_name => 'FEM_GL_POST_224');

Line 2541: FEM_ENGINES_PKG.Tech_Message

2537: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2538: p_num_output_rows => v_tot_posted_rows,
2539: p_final_message_name => 'FEM_GL_POST_205');
2540:
2541: FEM_ENGINES_PKG.Tech_Message
2542: (p_severity => pc_log_level_procedure,
2543: p_module => 'fem.plsql.xgl_eng.main',
2544: p_app_name => 'FEM',
2545: p_msg_name => 'FEM_GL_POST_203',

Line 2560: FEM_ENGINES_PKG.User_Message

2556: WHEN OTHERS THEN
2557:
2558: ROLLBACK;
2559:
2560: FEM_ENGINES_PKG.User_Message
2561: (p_app_name => 'FEM',
2562: p_msg_name => 'FEM_GL_POST_215',
2563: p_token1 => 'ERR_MSG',
2564: p_value1 => SQLERRM);

Line 2566: FEM_ENGINES_PKG.Tech_Message

2562: p_msg_name => 'FEM_GL_POST_215',
2563: p_token1 => 'ERR_MSG',
2564: p_value1 => SQLERRM);
2565:
2566: FEM_ENGINES_PKG.Tech_Message
2567: (p_severity => pc_log_level_unexpected,
2568: p_module => 'fem.plsql.xgl_eng.main',
2569: p_app_name => 'FEM',
2570: p_msg_name => 'FEM_GL_POST_215',

Line 2582: FEM_ENGINES_PKG.Tech_Message

2578: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2579: p_num_output_rows => v_tot_posted_rows,
2580: p_final_message_name => 'FEM_GL_POST_205');
2581:
2582: FEM_ENGINES_PKG.Tech_Message
2583: (p_severity => pc_log_level_procedure,
2584: p_module => 'fem.plsql.xgl_eng.main',
2585: p_app_name => 'FEM',
2586: p_msg_name => 'FEM_GL_POST_203',

Line 2614: FEM_ENGINES_PKG.Tech_Message

2610: PROCEDURE Log_Pkg_Variables IS
2611:
2612: BEGIN
2613:
2614: FEM_ENGINES_PKG.Tech_Message
2615: (p_severity => pc_log_level_procedure,
2616: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2617: p_app_name => 'FEM',
2618: p_msg_name => 'FEM_GL_POST_201',

Line 2624: FEM_ENGINES_PKG.Tech_Message

2620: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Log_Package_Variables',
2621: p_token2 => 'TIME',
2622: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2623:
2624: FEM_ENGINES_PKG.Tech_Message
2625: (p_severity => pc_log_level_statement,
2626: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2627: p_app_name => 'FEM',
2628: p_msg_name => 'FEM_GL_POST_204',

Line 2634: FEM_ENGINES_PKG.Tech_Message

2630: p_value1 => 'pv_process_slice',
2631: p_token2 => 'VAR_VAL',
2632: p_value2 => pv_process_slice);
2633:
2634: FEM_ENGINES_PKG.Tech_Message
2635: (p_severity => pc_log_level_statement,
2636: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2637: p_app_name => 'FEM',
2638: p_msg_name => 'FEM_GL_POST_204',

Line 2644: FEM_ENGINES_PKG.Tech_Message

2640: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_req_id',
2641: p_token2 => 'VAR_VAL',
2642: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id));
2643:
2644: FEM_ENGINES_PKG.Tech_Message
2645: (p_severity => pc_log_level_statement,
2646: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2647: p_app_name => 'FEM',
2648: p_msg_name => 'FEM_GL_POST_204',

Line 2654: FEM_ENGINES_PKG.Tech_Message

2650: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_exec_mode',
2651: p_token2 => 'VAR_VAL',
2652: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode);
2653:
2654: FEM_ENGINES_PKG.Tech_Message
2655: (p_severity => pc_log_level_statement,
2656: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2657: p_app_name => 'FEM',
2658: p_msg_name => 'FEM_GL_POST_204',

Line 2664: FEM_ENGINES_PKG.Tech_Message

2660: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id',
2661: p_token2 => 'VAR_VAL',
2662: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id));
2663:
2664: FEM_ENGINES_PKG.Tech_Message
2665: (p_severity => pc_log_level_statement,
2666: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2667: p_app_name => 'FEM',
2668: p_msg_name => 'FEM_GL_POST_204',

Line 2674: FEM_ENGINES_PKG.Tech_Message

2670: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_dataset_code',
2671: p_token2 => 'VAR_VAL',
2672: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code));
2673:
2674: FEM_ENGINES_PKG.Tech_Message
2675: (p_severity => pc_log_level_statement,
2676: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2677: p_app_name => 'FEM',
2678: p_msg_name => 'FEM_GL_POST_204',

Line 2684: FEM_ENGINES_PKG.Tech_Message

2680: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_period_id',
2681: p_token2 => 'VAR_VAL',
2682: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id));
2683:
2684: FEM_ENGINES_PKG.Tech_Message
2685: (p_severity => pc_log_level_statement,
2686: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2687: p_app_name => 'FEM',
2688: p_msg_name => 'FEM_GL_POST_204',

Line 2694: FEM_ENGINES_PKG.Tech_Message

2690: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_id',
2691: p_token2 => 'VAR_VAL',
2692: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id));
2693:
2694: FEM_ENGINES_PKG.Tech_Message
2695: (p_severity => pc_log_level_statement,
2696: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2697: p_app_name => 'FEM',
2698: p_msg_name => 'FEM_GL_POST_204',

Line 2704: FEM_ENGINES_PKG.Tech_Message

2700: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code',
2701: p_token2 => 'VAR_VAL',
2702: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code);
2703:
2704: FEM_ENGINES_PKG.Tech_Message
2705: (p_severity => pc_log_level_statement,
2706: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2707: p_app_name => 'FEM',
2708: p_msg_name => 'FEM_GL_POST_204',

Line 2714: FEM_ENGINES_PKG.Tech_Message

2710: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag',
2711: p_token2 => 'VAR_VAL',
2712: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag);
2713:
2714: FEM_ENGINES_PKG.Tech_Message
2715: (p_severity => pc_log_level_statement,
2716: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2717: p_app_name => 'FEM',
2718: p_msg_name => 'FEM_GL_POST_204',

Line 2724: FEM_ENGINES_PKG.Tech_Message

2720: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd',
2721: p_token2 => 'VAR_VAL',
2722: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd);
2723:
2724: FEM_ENGINES_PKG.Tech_Message
2725: (p_severity => pc_log_level_statement,
2726: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2727: p_app_name => 'FEM',
2728: p_msg_name => 'FEM_GL_POST_204',

Line 2735: FEM_ENGINES_PKG.Tech_Message

2731: p_token2 => 'VAR_VAL',
2732: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2733: 'YYYY/MM/DD HH24:MI:SS'));
2734:
2735: FEM_ENGINES_PKG.Tech_Message
2736: (p_severity => pc_log_level_statement,
2737: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2738: p_app_name => 'FEM',
2739: p_msg_name => 'FEM_GL_POST_204',

Line 2745: FEM_ENGINES_PKG.Tech_Message

2741: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_gl_per_number',
2742: p_token2 => 'VAR_VAL',
2743: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number));
2744:
2745: FEM_ENGINES_PKG.Tech_Message
2746: (p_severity => pc_log_level_statement,
2747: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2748: p_app_name => 'FEM',
2749: p_msg_name => 'FEM_GL_POST_204',

Line 2755: FEM_ENGINES_PKG.Tech_Message

2751: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd',
2752: p_token2 => 'VAR_VAL',
2753: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd);
2754:
2755: FEM_ENGINES_PKG.Tech_Message
2756: (p_severity => pc_log_level_statement,
2757: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2758: p_app_name => 'FEM',
2759: p_msg_name => 'FEM_GL_POST_204',

Line 2765: FEM_ENGINES_PKG.Tech_Message

2761: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd',
2762: p_token2 => 'VAR_VAL',
2763: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd);
2764:
2765: FEM_ENGINES_PKG.Tech_Message
2766: (p_severity => pc_log_level_statement,
2767: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2768: p_app_name => 'FEM',
2769: p_msg_name => 'FEM_GL_POST_204',

Line 2775: FEM_ENGINES_PKG.Tech_Message

2771: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd',
2772: p_token2 => 'VAR_VAL',
2773: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2774:
2775: FEM_ENGINES_PKG.Tech_Message
2776: (p_severity => pc_log_level_statement,
2777: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2778: p_app_name => 'FEM',
2779: p_msg_name => 'FEM_GL_POST_204',

Line 2785: FEM_ENGINES_PKG.Tech_Message

2781: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd',
2782: p_token2 => 'VAR_VAL',
2783: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd);
2784:
2785: FEM_ENGINES_PKG.Tech_Message
2786: (p_severity => pc_log_level_statement,
2787: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2788: p_app_name => 'FEM',
2789: p_msg_name => 'FEM_GL_POST_204',

Line 2795: FEM_ENGINES_PKG.Tech_Message

2791: p_value1 => 'pv_schema_name',
2792: p_token2 => 'VAR_VAL',
2793: p_value2 => pv_schema_name);
2794:
2795: FEM_ENGINES_PKG.Tech_Message
2796: (p_severity => pc_log_level_procedure,
2797: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2798: p_app_name => 'FEM',
2799: p_msg_name => 'FEM_GL_POST_202',

Line 2929: FEM_ENGINES_PKG.Tech_Message

2925:
2926: pv_process_slice := '{p' || TO_CHAR(p_process_number) || ':s' ||
2927: TO_CHAR(p_slice_id) || '}';
2928:
2929: FEM_ENGINES_PKG.Tech_Message
2930: (p_severity => pc_log_level_procedure,
2931: p_module => 'fem.plsql.xgl_eng.pds.' || pv_process_slice,
2932: p_app_name => 'FEM',
2933: p_msg_name => 'FEM_GL_POST_201',

Line 2939: FEM_ENGINES_PKG.Tech_Message

2935: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',
2936: p_token2 => 'TIME',
2937: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2938:
2939: FEM_ENGINES_PKG.Tech_Message
2940: (p_severity => pc_log_level_statement,
2941: p_module => 'fem.plsql.xgl_eng.pds.' || pv_process_slice,
2942: p_app_name => 'FEM',
2943: p_msg_name => 'FEM_GL_POST_204',

Line 2949: FEM_ENGINES_PKG.Tech_Message

2945: p_value1 => 'p_process_number',
2946: p_token2 => 'VAR_VAL',
2947: p_value2 => TO_CHAR(p_process_number));
2948:
2949: FEM_ENGINES_PKG.Tech_Message
2950: (p_severity => pc_log_level_statement,
2951: p_module => 'fem.plsql.xgl_eng.pds.' || pv_process_slice,
2952: p_app_name => 'FEM',
2953: p_msg_name => 'FEM_GL_POST_204',

Line 2973: FEM_ENGINES_PKG.Tech_Message

2969: -- structure. The values will be available for the duration of the
2970: -- calling subrequst's session, i.e. for subsequent invocations of
2971: -- Process_Data_Slice, so this only needs to be done once per subrequest.
2972:
2973: FEM_ENGINES_PKG.Tech_Message
2974: (p_severity => pc_log_level_event,
2975: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2976: p_msg_text => 'First data slice for subrequest; ' ||
2977: 'resetting package variables from input parameters.');

Line 3033: FEM_ENGINES_PKG.Tech_Message

3029:
3030: pv_data_slice_predicate := p_data_slice_predicate;
3031: pv_partition_clause := p_eng_sql;
3032:
3033: FEM_ENGINES_PKG.Tech_Message
3034: (p_severity => pc_log_level_event,
3035: p_module => 'fem.plsql.xgl_eng.pds.' || pv_process_slice,
3036: p_msg_text => 'pv_data_slice_predicate: ' || pv_data_slice_predicate);
3037:

Line 3038: FEM_ENGINES_PKG.Tech_Message

3034: (p_severity => pc_log_level_event,
3035: p_module => 'fem.plsql.xgl_eng.pds.' || pv_process_slice,
3036: p_msg_text => 'pv_data_slice_predicate: ' || pv_data_slice_predicate);
3037:
3038: FEM_ENGINES_PKG.Tech_Message
3039: (p_severity => pc_log_level_event,
3040: p_module => 'fem.plsql.xgl_eng.pc.' || pv_process_slice,
3041: p_msg_text => 'pv_partition_clause: ' || pv_partition_clause);
3042:

Line 3046: FEM_ENGINES_PKG.Tech_Message

3042:
3043: -- Set the unique Request ID for this data slice:
3044: pv_req_id_slice := p_req_id + p_slice_id / 100000;
3045:
3046: FEM_ENGINES_PKG.Tech_Message
3047: (p_severity => pc_log_level_statement,
3048: p_module => 'fem.plsql.xgl_eng.pds.' || pv_process_slice,
3049: p_app_name => 'FEM',
3050: p_msg_name => 'FEM_GL_POST_204',

Line 3121: FEM_ENGINES_PKG.Tech_Message

3117: WHERE posting_request_id = pv_req_id_slice
3118: AND posting_error_code is NULL
3119: AND load_method_code = 'S';
3120:
3121: FEM_ENGINES_PKG.Tech_Message
3122: (p_severity => pc_log_level_statement,
3123: p_module => 'fem.plsql.xgl_eng.pds.' ||
3124: pv_process_slice || '.ss_rows_del',
3125: p_app_name => 'FEM',

Line 3136: FEM_ENGINES_PKG.Tech_Message

3132: -- ------------------------------------------------------------
3133: -- Truncate FEM_BAL_POST_INTERIM_GT for the next set
3134: -- ------------------------------------------------------------
3135:
3136: FEM_ENGINES_PKG.Tech_Message
3137: (p_severity => pc_log_level_statement,
3138: p_module => 'fem.plsql.xgl_eng.pds.' ||
3139: pv_process_slice || '.ss_trunc',
3140: p_msg_text =>

Line 3192: FEM_ENGINES_PKG.Tech_Message

3188: 'AND (encumbrance_type_code = :enc_type_dsp_cd ' ||
3189: 'OR :enc_type_dsp_cd is NULL) ' ||
3190: 'ORDER BY load_set_id ASC';
3191:
3192: FEM_ENGINES_PKG.Tech_Message
3193: (p_severity => pc_log_level_statement,
3194: p_module => 'fem.plsql.xgl_eng.pds.' ||
3195: pv_process_slice || '.incr_crs_stmt',
3196: p_app_name => 'FEM',

Line 3231: FEM_ENGINES_PKG.Tech_Message

3227: 'AND (encumbrance_type_code = :enc_type_dsp_cd ' ||
3228: 'OR :enc_type_dsp_cd is NULL) ' ||
3229: 'ORDER BY load_set_id ASC';
3230:
3231: FEM_ENGINES_PKG.Tech_Message
3232: (p_severity => pc_log_level_statement,
3233: p_module => 'fem.plsql.xgl_eng.pds.' ||
3234: pv_process_slice || '.err_crs_stmt',
3235: p_msg_text => 'v_err_cursor_stmt: ' || v_err_cursor_stmt);

Line 3262: FEM_ENGINES_PKG.Tech_Message

3258:
3259: EXIT WHEN GetLoadSet_Cursor%NOTFOUND OR
3260: GetLoadSet_Cursor%NOTFOUND IS NULL;
3261:
3262: FEM_ENGINES_PKG.Tech_Message
3263: (p_severity => pc_log_level_statement,
3264: p_module => 'fem.plsql.xgl_eng.pds.' ||
3265: pv_process_slice || '.load_set',
3266: p_app_name => 'FEM',

Line 3312: FEM_ENGINES_PKG.Tech_Message

3308: AND posting_error_code is NULL
3309: AND load_method_code = 'I'
3310: AND load_set_id = v_curr_load_set_id;
3311:
3312: FEM_ENGINES_PKG.Tech_Message
3313: (p_severity => pc_log_level_statement,
3314: p_module => 'fem.plsql.xgl_eng.pds.' ||
3315: pv_process_slice || '.incr_rows_del',
3316: p_app_name => 'FEM',

Line 3327: FEM_ENGINES_PKG.Tech_Message

3323: -- ------------------------------------------------------------
3324: -- Truncate FEM_BAL_POST_INTERIM_GT for the next set
3325: -- ------------------------------------------------------------
3326:
3327: FEM_ENGINES_PKG.Tech_Message
3328: (p_severity => pc_log_level_statement,
3329: p_module => 'fem.plsql.xgl_eng.pds.' ||
3330: pv_process_slice || '.incr_trunc',
3331: p_msg_text =>

Line 3372: FEM_ENGINES_PKG.Tech_Message

3368: x_slice_status_cd := 0;
3369:
3370: END IF;
3371:
3372: FEM_ENGINES_PKG.Tech_Message
3373: (p_severity => pc_log_level_procedure,
3374: p_module => 'fem.plsql.xgl_eng.pds',
3375: p_app_name => 'FEM',
3376: p_msg_name => 'FEM_GL_POST_202',

Line 3407: FEM_ENGINES_PKG.Tech_Message

3403: AND previous_error_flag = 'Y';
3404:
3405: COMMIT;
3406:
3407: FEM_ENGINES_PKG.Tech_Message
3408: (p_severity => pc_log_level_procedure,
3409: p_module => 'fem.plsql.xgl_eng.pds.' ||
3410: pv_process_slice || '.fatal_err',
3411: p_app_name => 'FEM',

Line 3429: FEM_ENGINES_PKG.Tech_Message

3425:
3426: -- Log the Oracle error message to FND_LOG with the
3427: -- "unexpected exception" severity level.
3428:
3429: FEM_ENGINES_PKG.Tech_Message
3430: (p_severity => pc_log_level_unexpected,
3431: p_module => 'fem.plsql.xgl_eng.pds.' ||
3432: pv_process_slice || '.unexpected_exception',
3433: p_msg_text => FEM_GL_POST_PROCESS_PKG.pv_sqlerrm);

Line 3437: FEM_ENGINES_PKG.User_Message

3433: p_msg_text => FEM_GL_POST_PROCESS_PKG.pv_sqlerrm);
3434:
3435: -- Log the Oracle error message to the Concurrent Request Log.
3436:
3437: FEM_ENGINES_PKG.User_Message
3438: (p_msg_text => FEM_GL_POST_PROCESS_PKG.pv_sqlerrm);
3439:
3440: -- Set the OUT parameters
3441:

Line 3459: FEM_ENGINES_PKG.Tech_Message

3455: AND previous_error_flag = 'Y';
3456:
3457: COMMIT;
3458:
3459: FEM_ENGINES_PKG.Tech_Message
3460: (p_severity => pc_log_level_procedure,
3461: p_module => 'fem.plsql.xgl_eng.pds.' ||
3462: pv_process_slice || '.unexpected_exception',
3463: p_app_name => 'FEM',