[Home] [Help]
140: v_module := 'fem.plsql.fem_intg_bal_eng.main';
141: v_func_name := 'FEM_INTG_BAL_RULE_ENG_PKG.Main';
142:
143: -- Log the function entry time to FND_LOG
144: FEM_ENGINES_PKG.Tech_Message
145: (p_severity => pc_log_level_procedure,
146: p_module => v_module,
147: p_app_name => 'FEM',
148: p_msg_name => 'FEM_GL_POST_201',
153:
154: -- ---------------------------------------------------------
155: -- 1. List the engine parameters and their values to FND_LOG
156: -- ---------------------------------------------------------
157: FEM_ENGINES_PKG.Tech_Message
158: (p_severity => pc_log_level_statement,
159: p_module => v_module,
160: p_app_name => 'FEM',
161: p_msg_name => 'FEM_GL_POST_204',
163: p_value1 => 'p_bal_rule_obj_def_id',
164: p_token2 => 'VAR_VAL',
165: p_value2 => p_bal_rule_obj_def_id);
166:
167: FEM_ENGINES_PKG.Tech_Message
168: (p_severity => pc_log_level_statement,
169: p_module => v_module,
170: p_app_name => 'FEM',
171: p_msg_name => 'FEM_GL_POST_204',
173: p_value1 => 'p_from_period',
174: p_token2 => 'VAR_VAL',
175: p_value2 => p_from_period);
176:
177: FEM_ENGINES_PKG.Tech_Message
178: (p_severity => pc_log_level_statement,
179: p_module => v_module,
180: p_app_name => 'FEM',
181: p_msg_name => 'FEM_GL_POST_204',
183: p_value1 => 'p_to_period',
184: p_token2 => 'VAR_VAL',
185: p_value2 => p_to_period);
186:
187: FEM_ENGINES_PKG.Tech_Message
188: (p_severity => pc_log_level_statement,
189: p_module => v_module,
190: p_app_name => 'FEM',
191: p_msg_name => 'FEM_GL_POST_204',
193: p_value1 => 'p_effective_date',
194: p_token2 => 'VAR_VAL',
195: p_value2 => p_effective_date);
196:
197: FEM_ENGINES_PKG.Tech_Message
198: (p_severity => pc_log_level_statement,
199: p_module => v_module,
200: p_app_name => 'FEM',
201: p_msg_name => 'FEM_GL_POST_204',
203: p_value1 => 'p_bsv_range_low',
204: p_token2 => 'VAR_VAL',
205: p_value2 => p_bsv_range_low);
206:
207: FEM_ENGINES_PKG.Tech_Message
208: (p_severity => pc_log_level_statement,
209: p_module => v_module,
210: p_app_name => 'FEM',
211: p_msg_name => 'FEM_GL_POST_204',
237:
238: -- -----------------------------
239: -- 3. Validate engine parameters
240: -- -----------------------------
241: FEM_ENGINES_PKG.Tech_Message
242: (p_severity => pc_log_level_event,
243: p_module => v_module,
244: p_app_name => 'FEM',
245: p_msg_name => 'FEM_GL_POST_207');
242: (p_severity => pc_log_level_event,
243: p_module => v_module,
244: p_app_name => 'FEM',
245: p_msg_name => 'FEM_GL_POST_207');
246: FEM_ENGINES_PKG.User_Message
247: (p_app_name => 'FEM',
248: p_msg_name => 'FEM_GL_POST_207');
249:
250: -- Initalize v_completion_code to 0 before calling the API
269:
270: -- -----------------------------
271: -- 4. Register process execution
272: -- -----------------------------
273: FEM_ENGINES_PKG.Tech_Message
274: (p_severity => pc_log_level_event,
275: p_module => v_module,
276: p_app_name => 'FEM',
277: p_msg_name => 'FEM_GL_POST_208');
275: p_module => v_module,
276: p_app_name => 'FEM',
277: p_msg_name => 'FEM_GL_POST_208');
278: FND_FILE.NEW_LINE(fnd_file.log);
279: FEM_ENGINES_PKG.User_Message
280: (p_app_name => 'FEM',
281: p_msg_name => 'FEM_GL_POST_208');
282:
283: -- Reset v_completion_code to 0 before calling the API
295:
296: -- -------------------------
297: -- 5. Load standard balances
298: -- -------------------------
299: FEM_ENGINES_PKG.Tech_Message
300: (p_severity => pc_log_level_event,
301: p_module => v_module,
302: p_app_name => 'FEM',
303: p_msg_name => 'FEM_INTG_BAL_LOAD_STD');
301: p_module => v_module,
302: p_app_name => 'FEM',
303: p_msg_name => 'FEM_INTG_BAL_LOAD_STD');
304: FND_FILE.NEW_LINE(fnd_file.log);
305: FEM_ENGINES_PKG.User_Message
306: (p_app_name => 'FEM',
307: p_msg_name => 'FEM_INTG_BAL_LOAD_STD');
308:
309: -- Reset v_completion_code to 0 before calling the API
314: p_bsv_range_low => v_bsv_range_low,
315: p_bsv_range_high => v_bsv_range_high,
316: p_maintain_qtd => FEM_GL_POST_PROCESS_PKG.pv_maintain_qtd_flag);
317:
318: FEM_ENGINES_PKG.Tech_Message
319: (p_severity => pc_log_level_statement,
320: p_module => v_module,
321: p_app_name => 'FEM',
322: p_msg_name => 'FEM_GL_POST_204',
326: p_value2 => v_num_rows_inserted);
327:
328: -- Set the total number of rows inserted
329: v_tot_rows_inserted := v_num_rows_inserted;
330: FEM_ENGINES_PKG.Tech_Message
331: (p_severity => pc_log_level_statement,
332: p_module => v_module,
333: p_app_name => 'FEM',
334: p_msg_name => 'FEM_GL_POST_204',
349: -- 6. Load average balances if the Include Average Balances Flag is Yes
350: -- --------------------------------------------------------------------
351: IF (FEM_GL_POST_PROCESS_PKG.pv_include_avg_bal = 'Y')
352: THEN
353: FEM_ENGINES_PKG.Tech_Message
354: (p_severity => pc_log_level_event,
355: p_module => v_module,
356: p_app_name => 'FEM',
357: p_msg_name => 'FEM_INTG_BAL_LOAD_AVG');
355: p_module => v_module,
356: p_app_name => 'FEM',
357: p_msg_name => 'FEM_INTG_BAL_LOAD_AVG');
358: FND_FILE.NEW_LINE(fnd_file.log);
359: FEM_ENGINES_PKG.User_Message
360: (p_app_name => 'FEM',
361: p_msg_name => 'FEM_INTG_BAL_LOAD_AVG');
362:
363: -- Reset v_completion_code to 0 before calling the API
368: p_effective_date => v_effective_date,
369: p_bsv_range_low => v_bsv_range_low,
370: p_bsv_range_high => v_bsv_range_high);
371:
372: FEM_ENGINES_PKG.Tech_Message
373: (p_severity => pc_log_level_statement,
374: p_module => v_module,
375: p_app_name => 'FEM',
376: p_msg_name => 'FEM_GL_POST_204',
381:
382: -- Set the total number of rows inserted
383: v_tot_rows_inserted := v_tot_rows_inserted + v_num_rows_inserted;
384:
385: FEM_ENGINES_PKG.Tech_Message
386: (p_severity => pc_log_level_statement,
387: p_module => v_module,
388: p_app_name => 'FEM',
389: p_msg_name => 'FEM_GL_POST_204',
412: AND FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL')
413: THEN
414: -- Perform post-processing on FEM_BAL_POST_INTERIM_GT to back out foreign
415: -- converted amounts from the functional entered balances
416: FEM_ENGINES_PKG.Tech_Message
417: (p_severity => pc_log_level_event,
418: p_module => v_module,
419: p_app_name => 'FEM',
420: p_msg_name => 'FEM_INTG_BAL_POST_PROC');
418: p_module => v_module,
419: p_app_name => 'FEM',
420: p_msg_name => 'FEM_INTG_BAL_POST_PROC');
421: FND_FILE.NEW_LINE(fnd_file.log);
422: FEM_ENGINES_PKG.User_Message
423: (p_app_name => 'FEM',
424: p_msg_name => 'FEM_INTG_BAL_POST_PROC');
425:
426: -- Reset v_completion_code to 0 before calling the API
455: AND nvl(ytd_credit_balance_e,0) = 0;
456:
457: v_num_rows_deleted := SQL%ROWCOUNT;
458:
459: FEM_ENGINES_PKG.Tech_Message
460: ( p_severity => pc_log_level_event,
461: p_module => v_module,
462: p_app_name => 'FEM',
463: p_msg_text => 'Removed ' || TO_CHAR(v_num_rows_deleted) ||
488: WHERE ERROR_CODE IS NULL
489: AND REQUEST_ID IS NOT NULL;
490:
491: -- Log the number of rows updated in FEM_INTG_EXEC_PARAMS_GT
492: FEM_ENGINES_PKG.Tech_Message
493: (p_severity => pc_log_level_statement,
494: p_module => v_module,
495: p_app_name => 'FEM',
496: p_msg_name => 'FEM_GL_POST_217',
521: WHERE param.ERROR_CODE IS NULL
522: AND param.REQUEST_ID IS NOT NULL;
523:
524: -- Log the number of rows updated in FEM_INTG_EXEC_PARAMS_GT
525: FEM_ENGINES_PKG.Tech_Message
526: (p_severity => pc_log_level_statement,
527: p_module => v_module,
528: p_app_name => 'FEM',
529: p_msg_name => 'FEM_GL_POST_217',
547: IF (v_tot_rows_valid = 0)
548: THEN
549: -- All CCIDs are not properly mapped
550: -- Log the error messages
551: FEM_ENGINES_PKG.Tech_Message
552: (p_severity => pc_log_level_error,
553: p_module => v_module,
554: p_app_name => 'FEM',
555: p_msg_name => 'FEM_INTG_BAL_ALL_CCID_ERR',
554: p_app_name => 'FEM',
555: p_msg_name => 'FEM_INTG_BAL_ALL_CCID_ERR',
556: p_token1 => 'COA_NAME',
557: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_coa_name);
558: FEM_ENGINES_PKG.User_Message
559: (p_app_name => 'FEM',
560: p_msg_name => 'FEM_INTG_BAL_ALL_CCID_ERR',
561: p_token1 => 'COA_NAME',
562: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_coa_name);
568: ELSIF (v_tot_rows_inserted > v_tot_rows_valid)
569: THEN
570: -- There is at least one CCIDs not properly mapped
571: -- Log the error messags
572: FEM_ENGINES_PKG.Tech_Message
573: (p_severity => pc_log_level_error,
574: p_module => v_module,
575: p_app_name => 'FEM',
576: p_msg_name => 'FEM_INTG_BAL_SNAP_CCID_ERR',
575: p_app_name => 'FEM',
576: p_msg_name => 'FEM_INTG_BAL_SNAP_CCID_ERR',
577: p_token1 => 'COA_NAME',
578: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_coa_name);
579: FEM_ENGINES_PKG.User_Message
580: (p_app_name => 'FEM',
581: p_msg_name => 'FEM_INTG_BAL_SNAP_CCID_ERR',
582: p_token1 => 'COA_NAME',
583: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_coa_name);
591: IF (FEM_GL_POST_PROCESS_PKG.pv_adv_li_fe_mappings_flag = 'Y')
592: THEN
593: -- Override the default Line Item and Financial Element dimension mappings
594: -- based on the Natural Account dimension
595: FEM_ENGINES_PKG.Tech_Message
596: (p_severity => pc_log_level_event,
597: p_module => v_module,
598: p_app_name => 'FEM',
599: p_msg_name => 'FEM_INTG_BAL_MAP_ADV_LI_FE');
597: p_module => v_module,
598: p_app_name => 'FEM',
599: p_msg_name => 'FEM_INTG_BAL_MAP_ADV_LI_FE');
600: FND_FILE.NEW_LINE(fnd_file.log);
601: FEM_ENGINES_PKG.User_Message
602: (p_app_name => 'FEM',
603: p_msg_name => 'FEM_INTG_BAL_MAP_ADV_LI_FE');
604:
605: -- Reset v_completion_code to 0 before calling the API
632:
633: IF (FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd IN ('ACTUAL', 'ENCUMBRANCE'))
634: THEN
635: -- Mark the posted incremental balances
636: FEM_ENGINES_PKG.Tech_Message
637: (p_severity => pc_log_level_event,
638: p_module => v_module,
639: p_app_name => 'FEM',
640: p_msg_name => 'FEM_INTG_BAL_MARK_INCR_BAL');
638: p_module => v_module,
639: p_app_name => 'FEM',
640: p_msg_name => 'FEM_INTG_BAL_MARK_INCR_BAL');
641: FND_FILE.NEW_LINE(fnd_file.log);
642: FEM_ENGINES_PKG.User_Message
643: (p_app_name => 'FEM',
644: p_msg_name => 'FEM_INTG_BAL_MARK_INCR_BAL');
645:
646: -- Reset v_completion_code to 0 before calling the API
664: -- 12. Post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES
665: -- ----------------------------------------------------------
666:
667: -- Posting balances into FEM
668: FEM_ENGINES_PKG.Tech_Message
669: (p_severity => pc_log_level_event,
670: p_module => v_module,
671: p_app_name => 'FEM',
672: p_msg_name => 'FEM_GL_POST_214');
670: p_module => v_module,
671: p_app_name => 'FEM',
672: p_msg_name => 'FEM_GL_POST_214');
673: FND_FILE.NEW_LINE(fnd_file.log);
674: FEM_ENGINES_PKG.User_Message
675: (p_app_name => 'FEM',
676: p_msg_name => 'FEM_GL_POST_214');
677:
678: IF (FEM_GL_POST_PROCESS_PKG.pv_stmt_type = 'INSERT')
676: p_msg_name => 'FEM_GL_POST_214');
677:
678: IF (FEM_GL_POST_PROCESS_PKG.pv_stmt_type = 'INSERT')
679: THEN
680: FEM_ENGINES_PKG.Tech_Message
681: (p_severity => pc_log_level_statement,
682: p_module => v_module,
683: p_app_name => 'FEM',
684: p_msg_name => 'Posting in Snapshot mode');
694: p_maintain_qtd => FEM_GL_POST_PROCESS_PKG.pv_maintain_qtd_flag,
695: p_bsv_range_low => v_bsv_range_low,
696: p_bsv_range_high => v_bsv_range_high);
697: ELSE
698: FEM_ENGINES_PKG.Tech_Message
699: (p_severity => pc_log_level_statement,
700: p_module => v_module,
701: p_app_name => 'FEM',
702: p_msg_name => 'Posting in Incremental mode');
726:
727: -- -------------------
728: -- 13. Generate Report
729: -- -------------------
730: FEM_ENGINES_PKG.Tech_Message
731: (p_severity => pc_log_level_event,
732: p_module => v_module,
733: p_app_name => 'FEM',
734: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
732: p_module => v_module,
733: p_app_name => 'FEM',
734: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
735: FND_FILE.NEW_LINE(fnd_file.log);
736: FEM_ENGINES_PKG.User_Message
737: (p_app_name => 'FEM',
738: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
739:
740: -- Set Generate Report Flag to No i.e. indicating report should not be
766: -- ------------------------------------------------------------------------
767:
768: -- Raise business events to notify other CPM products that new balances have
769: -- been loaded into FEM
770: FEM_ENGINES_PKG.Tech_Message
771: (p_severity => pc_log_level_event,
772: p_module => v_module,
773: p_app_name => 'FEM',
774: p_msg_name => 'FEM_INTG_BAL_RAISE_EVENT');
772: p_module => v_module,
773: p_app_name => 'FEM',
774: p_msg_name => 'FEM_INTG_BAL_RAISE_EVENT');
775: FND_FILE.NEW_LINE(fnd_file.log);
776: FEM_ENGINES_PKG.User_Message
777: (p_app_name => 'FEM',
778: p_msg_name => 'FEM_INTG_BAL_RAISE_EVENT');
779:
780: -- Loop for each request which has posted at least one row into FEM and
781: -- raise a business event to notify other CPM products that OGL balances has
782: -- been loaded into FEM
783: FOR v_req IN req_cur LOOP
784: -- List the request ID for raising event to FND_LOG
785: FEM_ENGINES_PKG.Tech_Message
786: (p_severity => pc_log_level_statement,
787: p_module => v_module,
788: p_app_name => 'FEM',
789: p_msg_name => 'FEM_GL_POST_204',
865: THEN
866: v_param_list.DELETE;
867: END IF;
868:
869: FEM_ENGINES_PKG.Tech_Message
870: (p_severity => pc_log_level_event,
871: p_module => v_module,
872: p_app_name => 'FEM',
873: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
871: p_module => v_module,
872: p_app_name => 'FEM',
873: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
874: FND_FILE.NEW_LINE(fnd_file.log);
875: FEM_ENGINES_PKG.User_Message
876: (p_app_name => 'FEM',
877: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
878:
879: IF (v_completion_status = 'WARNING')
889: p_final_message_name => 'FEM_GL_POST_220');
890: END IF; -- IF (v_completion_status = 'WARNING')
891:
892: -- Log the function exit time to FND_LOG (successful completion)
893: FEM_ENGINES_PKG.Tech_Message
894: (p_severity => pc_log_level_procedure,
895: p_module => v_module,
896: p_app_name => 'FEM',
897: p_msg_name => 'FEM_GL_POST_202',
921:
922: -- Check if we need to generate the report
923: IF (v_generate_report_flag = 'Y')
924: THEN
925: FEM_ENGINES_PKG.Tech_Message
926: (p_severity => pc_log_level_event,
927: p_module => v_module,
928: p_app_name => 'FEM',
929: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
927: p_module => v_module,
928: p_app_name => 'FEM',
929: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
930: FND_FILE.NEW_LINE(fnd_file.log);
931: FEM_ENGINES_PKG.User_Message
932: (p_app_name => 'FEM',
933: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
934:
935: Generate_Report(x_completion_code => v_completion_code,
943: p_tot_rows_posted => 0);
944: END IF;
945:
946: -- Perform post-process logging with an error message
947: FEM_ENGINES_PKG.Tech_Message
948: (p_severity => pc_log_level_event,
949: p_module => v_module,
950: p_app_name => 'FEM',
951: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
949: p_module => v_module,
950: p_app_name => 'FEM',
951: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
952: FND_FILE.NEW_LINE(fnd_file.log);
953: FEM_ENGINES_PKG.User_Message
954: (p_app_name => 'FEM',
955: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
956:
957: FEM_GL_POST_PROCESS_PKG.Final_OGL_Process_Logging
961: -- Set the output parameters for the concurrent program
962: x_errbuf := FND_MESSAGE.Get_String('FEM', 'FEM_GL_POST_205');
963:
964: -- Log the function exit time to FND_LOG (with error)
965: FEM_ENGINES_PKG.Tech_Message
966: (p_severity => pc_log_level_procedure,
967: p_module => v_module,
968: p_app_name => 'FEM',
969: p_msg_name => 'FEM_GL_POST_203',
981: WHEN OGLEngMain_NoData THEN
982: -- <<< No data to be loaded >>>
983:
984: -- Log the error messages
985: FEM_ENGINES_PKG.Tech_Message
986: (p_severity => pc_log_level_exception,
987: p_module => v_module,
988: p_app_name => 'FEM',
989: p_msg_name => 'FEM_INTG_BAL_NO_DATA');
986: (p_severity => pc_log_level_exception,
987: p_module => v_module,
988: p_app_name => 'FEM',
989: p_msg_name => 'FEM_INTG_BAL_NO_DATA');
990: FEM_ENGINES_PKG.User_Message
991: (p_app_name => 'FEM',
992: p_msg_name => 'FEM_INTG_BAL_NO_DATA');
993:
994: -- Generate report to list the parameters
991: (p_app_name => 'FEM',
992: p_msg_name => 'FEM_INTG_BAL_NO_DATA');
993:
994: -- Generate report to list the parameters
995: FEM_ENGINES_PKG.Tech_Message
996: (p_severity => pc_log_level_event,
997: p_module => v_module,
998: p_app_name => 'FEM',
999: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
997: p_module => v_module,
998: p_app_name => 'FEM',
999: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
1000: FND_FILE.NEW_LINE(fnd_file.log);
1001: FEM_ENGINES_PKG.User_Message
1002: (p_app_name => 'FEM',
1003: p_msg_name => 'FEM_INTG_BAL_GENERATE_REPORT');
1004:
1005: Generate_Report(x_completion_code => v_completion_code,
1012: p_tot_rows_valid => v_tot_rows_valid,
1013: p_tot_rows_posted => v_tot_rows_posted);
1014:
1015: -- Log message to show the next step is Final Process Logging
1016: FEM_ENGINES_PKG.Tech_Message
1017: (p_severity => pc_log_level_event,
1018: p_module => v_module,
1019: p_app_name => 'FEM',
1020: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
1018: p_module => v_module,
1019: p_app_name => 'FEM',
1020: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
1021: FND_FILE.NEW_LINE(fnd_file.log);
1022: FEM_ENGINES_PKG.User_Message
1023: (p_app_name => 'FEM',
1024: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
1025:
1026: -- Start bug fix 5623102
1033: (p_exec_status => 'SUCCESS',
1034: p_final_message_name => 'FEM_GL_POST_206');
1035:
1036: -- Log the function exit time to FND_LOG (successful completion)
1037: FEM_ENGINES_PKG.Tech_Message
1038: (p_severity => pc_log_level_procedure,
1039: p_module => v_module,
1040: p_app_name => 'FEM',
1041: p_msg_name => 'FEM_GL_POST_202',
1055: (p_exec_status => 'SUCCESS',
1056: p_final_message_name => 'FEM_GL_POST_220');
1057:
1058: -- Log the function exit time to FND_LOG (successful completion)
1059: FEM_ENGINES_PKG.Tech_Message
1060: (p_severity => pc_log_level_procedure,
1061: p_module => v_module,
1062: p_app_name => 'FEM',
1063: p_msg_name => 'FEM_GL_POST_202',
1089: x_errbuf := SQLERRM;
1090: x_retcode := SQLCODE;
1091:
1092: -- Log the unexpected error message
1093: FEM_ENGINES_PKG.Tech_Message
1094: (p_severity => pc_log_level_unexpected,
1095: p_module => v_module,
1096: p_app_name => 'FEM',
1097: p_msg_name => 'FEM_GL_POST_215',
1096: p_app_name => 'FEM',
1097: p_msg_name => 'FEM_GL_POST_215',
1098: p_token1 => 'ERR_MSG',
1099: p_value1 => x_errbuf);
1100: FEM_ENGINES_PKG.User_Message
1101: (p_app_name => 'FEM',
1102: p_msg_name => 'FEM_GL_POST_215',
1103: p_token1 => 'ERR_MSG',
1104: p_value1 => x_errbuf);
1103: p_token1 => 'ERR_MSG',
1104: p_value1 => x_errbuf);
1105:
1106: -- Log message to show the next step is Final Process Logging
1107: FEM_ENGINES_PKG.Tech_Message
1108: (p_severity => pc_log_level_event,
1109: p_module => v_module,
1110: p_app_name => 'FEM',
1111: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
1109: p_module => v_module,
1110: p_app_name => 'FEM',
1111: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
1112: FND_FILE.NEW_LINE(fnd_file.log);
1113: FEM_ENGINES_PKG.User_Message
1114: (p_app_name => 'FEM',
1115: p_msg_name => 'FEM_INTG_BAL_FINAL_LOG');
1116:
1117: -- Perform post-process logging with an error message
1119: (p_exec_status => 'ERROR_RERUN',
1120: p_final_message_name => 'FEM_GL_POST_205');
1121:
1122: -- Log the function exit time to FND_LOG (with error)
1123: FEM_ENGINES_PKG.Tech_Message
1124: (p_severity => pc_log_level_procedure,
1125: p_module => v_module,
1126: p_app_name => 'FEM',
1127: p_msg_name => 'FEM_GL_POST_203',
1265: v_module := 'fem.plsql.fem_intg_bal_eng.generate_report';
1266: v_func_name := 'FEM_INTG_BAL_RULE_ENG_PKG.Generate_Report';
1267:
1268: -- Log the function entry time to FND_LOG
1269: FEM_ENGINES_PKG.Tech_Message
1270: (p_severity => pc_log_level_procedure,
1271: p_module => v_module,
1272: p_app_name => 'FEM',
1273: p_msg_name => 'FEM_GL_POST_201',
1278:
1279: -- -----------------------------------------------------
1280: -- 1. List the IN parameters and their values to FND_LOG
1281: -- -----------------------------------------------------
1282: FEM_ENGINES_PKG.Tech_Message
1283: (p_severity => pc_log_level_statement,
1284: p_module => v_module,
1285: p_app_name => 'FEM',
1286: p_msg_name => 'FEM_GL_POST_204',
1287: p_token1 => 'VAR_NAME',
1288: p_value1 => 'p_tot_rows_inserted',
1289: p_token2 => 'VAR_VAL',
1290: p_value2 => TO_CHAR(p_tot_rows_inserted));
1291: FEM_ENGINES_PKG.Tech_Message
1292: (p_severity => pc_log_level_statement,
1293: p_module => v_module,
1294: p_app_name => 'FEM',
1295: p_msg_name => 'FEM_GL_POST_204',
1296: p_token1 => 'VAR_NAME',
1297: p_value1 => 'p_tot_rows_valid',
1298: p_token2 => 'VAR_VAL',
1299: p_value2 => TO_CHAR(p_tot_rows_valid));
1300: FEM_ENGINES_PKG.Tech_Message
1301: (p_severity => pc_log_level_statement,
1302: p_module => v_module,
1303: p_app_name => 'FEM',
1304: p_msg_name => 'FEM_GL_POST_204',
1345: WHERE param.ERROR_CODE IS NULL
1346: AND param.REQUEST_ID IS NOT NULL;
1347:
1348: -- Log the number of rows updated in FEM_INTG_EXEC_PARAMS_GT
1349: FEM_ENGINES_PKG.Tech_Message
1350: (p_severity => pc_log_level_statement,
1351: p_module => v_module,
1352: p_app_name => 'FEM',
1353: p_msg_name => 'FEM_GL_POST_217',
1545: THEN
1546: -- No-data-found datasets/snapshot periods exist
1547:
1548: -- Log warning message FEM_INTG_BAL_NO_DATA_PER
1549: FEM_ENGINES_PKG.Tech_Message
1550: (p_severity => pc_log_level_exception,
1551: p_module => v_module,
1552: p_app_name => 'FEM',
1553: p_msg_name => 'FEM_INTG_BAL_NO_DATA_PER');
1550: (p_severity => pc_log_level_exception,
1551: p_module => v_module,
1552: p_app_name => 'FEM',
1553: p_msg_name => 'FEM_INTG_BAL_NO_DATA_PER');
1554: FEM_ENGINES_PKG.User_Message
1555: (p_app_name => 'FEM',
1556: p_msg_name => 'FEM_INTG_BAL_NO_DATA_PER');
1557:
1558: -- Print message FEM_INTG_BAL_NO_DATA_PER to report
1565: -- Set the return code to indicate warning
1566: x_completion_code := 1;
1567:
1568: -- Log that we have set x_completion_code to 1 to FND Log
1569: FEM_ENGINES_PKG.Tech_Message
1570: (p_severity => pc_log_level_statement,
1571: p_module => v_module,
1572: p_app_name => 'FEM',
1573: p_msg_name => 'FEM_GL_POST_204',
1852: END LOOP; -- End of Dataset cursor loop
1853: END IF; -- IF (FEM_GL_POST_PROCESS_PKG.pv_min_valid_period_eff_num <> -1)
1854:
1855: -- Log the function exit time to FND_LOG (successful completion)
1856: FEM_ENGINES_PKG.Tech_Message
1857: (p_severity => pc_log_level_procedure,
1858: p_module => v_module,
1859: p_app_name => 'FEM',
1860: p_msg_name => 'FEM_GL_POST_202',
1869: -- Set the return code to indicate fatal error
1870: x_completion_code := 2;
1871:
1872: -- Log the function exit time to FND_LOG (with error)
1873: FEM_ENGINES_PKG.Tech_Message
1874: (p_severity => pc_log_level_procedure,
1875: p_module => v_module,
1876: p_app_name => 'FEM',
1877: p_msg_name => 'FEM_GL_POST_203',
1886: -- Set the return code to indicate fatal error
1887: x_completion_code := 2;
1888:
1889: -- Log the unexpected error message
1890: FEM_ENGINES_PKG.Tech_Message
1891: (p_severity => pc_log_level_unexpected,
1892: p_module => v_module,
1893: p_app_name => 'FEM',
1894: p_msg_name => 'FEM_GL_POST_215',
1893: p_app_name => 'FEM',
1894: p_msg_name => 'FEM_GL_POST_215',
1895: p_token1 => 'ERR_MSG',
1896: p_value1 => SQLERRM);
1897: FEM_ENGINES_PKG.User_Message
1898: (p_app_name => 'FEM',
1899: p_msg_name => 'FEM_GL_POST_215',
1900: p_token1 => 'ERR_MSG',
1901: p_value1 => SQLERRM);
1900: p_token1 => 'ERR_MSG',
1901: p_value1 => SQLERRM);
1902:
1903: -- Log the function exit time to FND_LOG (with error)
1904: FEM_ENGINES_PKG.Tech_Message
1905: (p_severity => pc_log_level_procedure,
1906: p_module => v_module,
1907: p_app_name => 'FEM',
1908: p_msg_name => 'FEM_GL_POST_203',
1932: v_module := 'fem.plsql.fem_intg_bal_eng.print_report_hdr';
1933: v_func_name := 'FEM_INTG_BAL_RULE_ENG_PKG.Print_Report_Hdr';
1934:
1935: -- Log the function entry time to FND_LOG
1936: FEM_ENGINES_PKG.Tech_Message
1937: (p_severity => pc_log_level_procedure,
1938: p_module => v_module,
1939: p_app_name => 'FEM',
1940: p_msg_name => 'FEM_GL_POST_201',
2042: */
2043: END IF;
2044:
2045: -- Log the function exit time to FND_LOG (successful completion)
2046: FEM_ENGINES_PKG.Tech_Message
2047: (p_severity => pc_log_level_procedure,
2048: p_module => v_module,
2049: p_app_name => 'FEM',
2050: p_msg_name => 'FEM_GL_POST_202',
2056: WHEN Others THEN
2057: -- <<< Unexpected database exceptions >>>
2058:
2059: -- Log the unexpected error message
2060: FEM_ENGINES_PKG.Tech_Message
2061: (p_severity => pc_log_level_unexpected,
2062: p_module => v_module,
2063: p_app_name => 'FEM',
2064: p_msg_name => 'FEM_GL_POST_215',
2063: p_app_name => 'FEM',
2064: p_msg_name => 'FEM_GL_POST_215',
2065: p_token1 => 'ERR_MSG',
2066: p_value1 => SQLERRM);
2067: FEM_ENGINES_PKG.User_Message
2068: (p_app_name => 'FEM',
2069: p_msg_name => 'FEM_GL_POST_215',
2070: p_token1 => 'ERR_MSG',
2071: p_value1 => SQLERRM);
2070: p_token1 => 'ERR_MSG',
2071: p_value1 => SQLERRM);
2072:
2073: -- Log the function exit time to FND_LOG (with error)
2074: FEM_ENGINES_PKG.Tech_Message
2075: (p_severity => pc_log_level_procedure,
2076: p_module => v_module,
2077: p_app_name => 'FEM',
2078: p_msg_name => 'FEM_GL_POST_203',
2148: v_module := 'fem.plsql.fem_intg_bal_eng.write_message';
2149: v_func_name := 'FEM_INTG_BAL_RULE_ENG_PKG.Write_Message';
2150:
2151: -- Log the function entry time to FND_LOG
2152: FEM_ENGINES_PKG.Tech_Message
2153: (p_severity => pc_log_level_procedure,
2154: p_module => v_module,
2155: p_app_name => 'FEM',
2156: p_msg_name => 'FEM_GL_POST_201',
2225: v_str_i := v_str_i + v_str_len;
2226: END LOOP;
2227:
2228: -- Log the function exit time to FND_LOG (successful completion)
2229: FEM_ENGINES_PKG.Tech_Message
2230: (p_severity => pc_log_level_procedure,
2231: p_module => v_module,
2232: p_app_name => 'FEM',
2233: p_msg_name => 'FEM_GL_POST_202',
2240: WHEN Others THEN
2241: -- <<< Unexpected database exceptions >>>
2242:
2243: -- Log the unexpected error message
2244: FEM_ENGINES_PKG.Tech_Message
2245: (p_severity => pc_log_level_unexpected,
2246: p_module => v_module,
2247: p_app_name => 'FEM',
2248: p_msg_name => 'FEM_GL_POST_215',
2247: p_app_name => 'FEM',
2248: p_msg_name => 'FEM_GL_POST_215',
2249: p_token1 => 'ERR_MSG',
2250: p_value1 => SQLERRM);
2251: FEM_ENGINES_PKG.User_Message
2252: (p_app_name => 'FEM',
2253: p_msg_name => 'FEM_GL_POST_215',
2254: p_token1 => 'ERR_MSG',
2255: p_value1 => SQLERRM);
2254: p_token1 => 'ERR_MSG',
2255: p_value1 => SQLERRM);
2256:
2257: -- Log the function exit time to FND_LOG (with error)
2258: FEM_ENGINES_PKG.Tech_Message
2259: (p_severity => pc_log_level_procedure,
2260: p_module => v_module,
2261: p_app_name => 'FEM',
2262: p_msg_name => 'FEM_GL_POST_203',
2286: v_module := 'fem.plsql.fem_intg_bal_eng.write_new_line';
2287: v_func_name := 'FEM_INTG_BAL_RULE_ENG_PKG.Write_New_Line';
2288:
2289: -- Log the function entry time to FND_LOG
2290: FEM_ENGINES_PKG.Tech_Message
2291: (p_severity => pc_log_level_procedure,
2292: p_module => v_module,
2293: p_app_name => 'FEM',
2294: p_msg_name => 'FEM_GL_POST_201',
2310: FND_FILE.new_line(FND_FILE.output, 1);
2311: pv_line_count := pv_line_count + 1;
2312:
2313: -- Log the function exit time to FND_LOG (successful completion)
2314: FEM_ENGINES_PKG.Tech_Message
2315: (p_severity => pc_log_level_procedure,
2316: p_module => v_module,
2317: p_app_name => 'FEM',
2318: p_msg_name => 'FEM_GL_POST_202',
2325: WHEN Others THEN
2326: -- <<< Unexpected database exceptions >>>
2327:
2328: -- Log the unexpected error message
2329: FEM_ENGINES_PKG.Tech_Message
2330: (p_severity => pc_log_level_unexpected,
2331: p_module => v_module,
2332: p_app_name => 'FEM',
2333: p_msg_name => 'FEM_GL_POST_215',
2332: p_app_name => 'FEM',
2333: p_msg_name => 'FEM_GL_POST_215',
2334: p_token1 => 'ERR_MSG',
2335: p_value1 => SQLERRM);
2336: FEM_ENGINES_PKG.User_Message
2337: (p_app_name => 'FEM',
2338: p_msg_name => 'FEM_GL_POST_215',
2339: p_token1 => 'ERR_MSG',
2340: p_value1 => SQLERRM);
2339: p_token1 => 'ERR_MSG',
2340: p_value1 => SQLERRM);
2341:
2342: -- Log the function exit time to FND_LOG (with error)
2343: FEM_ENGINES_PKG.Tech_Message
2344: (p_severity => pc_log_level_procedure,
2345: p_module => v_module,
2346: p_app_name => 'FEM',
2347: p_msg_name => 'FEM_GL_POST_203',
2372: v_module := 'fem.plsql.fem_intg_bal_eng.write_line';
2373: v_func_name := 'FEM_INTG_BAL_RULE_ENG_PKG.Write_Line';
2374:
2375: -- Log the function entry time to FND_LOG
2376: FEM_ENGINES_PKG.Tech_Message
2377: (p_severity => pc_log_level_procedure,
2378: p_module => v_module,
2379: p_app_name => 'FEM',
2380: p_msg_name => 'FEM_GL_POST_201',
2396: FND_FILE.put_line(FND_FILE.output, p_line_text);
2397: pv_line_count := pv_line_count + 1;
2398:
2399: -- Log the function exit time to FND_LOG (successful completion)
2400: FEM_ENGINES_PKG.Tech_Message
2401: (p_severity => pc_log_level_procedure,
2402: p_module => v_module,
2403: p_app_name => 'FEM',
2404: p_msg_name => 'FEM_GL_POST_202',
2411: WHEN Others THEN
2412: -- <<< Unexpected database exceptions >>>
2413:
2414: -- Log the unexpected error message
2415: FEM_ENGINES_PKG.Tech_Message
2416: (p_severity => pc_log_level_unexpected,
2417: p_module => v_module,
2418: p_app_name => 'FEM',
2419: p_msg_name => 'FEM_GL_POST_215',
2418: p_app_name => 'FEM',
2419: p_msg_name => 'FEM_GL_POST_215',
2420: p_token1 => 'ERR_MSG',
2421: p_value1 => SQLERRM);
2422: FEM_ENGINES_PKG.User_Message
2423: (p_app_name => 'FEM',
2424: p_msg_name => 'FEM_GL_POST_215',
2425: p_token1 => 'ERR_MSG',
2426: p_value1 => SQLERRM);
2425: p_token1 => 'ERR_MSG',
2426: p_value1 => SQLERRM);
2427:
2428: -- Log the function exit time to FND_LOG (with error)
2429: FEM_ENGINES_PKG.Tech_Message
2430: (p_severity => pc_log_level_procedure,
2431: p_module => v_module,
2432: p_app_name => 'FEM',
2433: p_msg_name => 'FEM_GL_POST_203',