[Home] [Help]
128: BEGIN
129:
130: v_condition := NVL(REPLACE(p_condition,'WHERE',''),'1=1');
131:
132: FEM_ENGINES_PKG.TECH_MESSAGE
133: (p_severity => c_log_level_2,
134: p_module => v_block||'.p_part_name{580}',
135: p_msg_text => p_part_name);
136: FEM_ENGINES_PKG.TECH_MESSAGE
132: FEM_ENGINES_PKG.TECH_MESSAGE
133: (p_severity => c_log_level_2,
134: p_module => v_block||'.p_part_name{580}',
135: p_msg_text => p_part_name);
136: FEM_ENGINES_PKG.TECH_MESSAGE
137: (p_severity => c_log_level_2,
138: p_module => v_block||'.p_data_slc{581}',
139: p_msg_text => p_data_slc);
140: FEM_ENGINES_PKG.TECH_MESSAGE
136: FEM_ENGINES_PKG.TECH_MESSAGE
137: (p_severity => c_log_level_2,
138: p_module => v_block||'.p_data_slc{581}',
139: p_msg_text => p_data_slc);
140: FEM_ENGINES_PKG.TECH_MESSAGE
141: (p_severity => c_log_level_2,
142: p_module => v_block||'.p_rownum{582}',
143: p_msg_text => TO_CHAR(p_rownum));
144:
160: '(SELECT DISTINCT ' || p_data_slc || ' data_slice' ||
161: ' FROM ' || p_data_table || v_part_clause ||
162: ' WHERE ' || v_condition || ')';
163:
164: FEM_ENGINES_PKG.TECH_MESSAGE
165: (p_severity => c_log_level_1,
166: p_module => v_block||'.v_sql_cmd{583}',
167: p_msg_text => v_sql_cmd);
168:
173: INTO p_rownum
174: FROM FEM_MP_PROCESS_CTL_T
175: WHERE req_id = p_req_id;
176:
177: FEM_ENGINES_PKG.TECH_MESSAGE
178: (p_severity => c_log_level_2,
179: p_module => v_block||'.p_rownum{584}',
180: p_msg_text => p_rownum);
181:
223: BEGIN
224:
225: v_condition := NVL(REPLACE(p_condition,'WHERE',''),'1=1');
226:
227: FEM_ENGINES_PKG.TECH_MESSAGE
228: (p_severity => c_log_level_2,
229: p_module => v_block||'.p_part_name{580}',
230: p_msg_text => p_part_name);
231: FEM_ENGINES_PKG.TECH_MESSAGE
227: FEM_ENGINES_PKG.TECH_MESSAGE
228: (p_severity => c_log_level_2,
229: p_module => v_block||'.p_part_name{580}',
230: p_msg_text => p_part_name);
231: FEM_ENGINES_PKG.TECH_MESSAGE
232: (p_severity => c_log_level_2,
233: p_module => v_block||'.p_slc_col{581}',
234: p_msg_text => p_slc_col);
235: FEM_ENGINES_PKG.TECH_MESSAGE
231: FEM_ENGINES_PKG.TECH_MESSAGE
232: (p_severity => c_log_level_2,
233: p_module => v_block||'.p_slc_col{581}',
234: p_msg_text => p_slc_col);
235: FEM_ENGINES_PKG.TECH_MESSAGE
236: (p_severity => c_log_level_2,
237: p_module => v_block||'.p_rownum{582}',
238: p_msg_text => TO_CHAR(p_rownum));
239:
269: 'FROM ' || p_data_table || v_part_clause ||
270: ' WHERE ' || v_condition || ') ' ||
271: 'GROUP BY tile)';
272:
273: FEM_ENGINES_PKG.TECH_MESSAGE
274: (p_severity => c_log_level_1,
275: p_module => v_block||'.v_sql_cmd{583}',
276: p_msg_text => v_sql_cmd);
277:
282: INTO p_rownum
283: FROM FEM_MP_PROCESS_CTL_T
284: WHERE req_id = p_req_id;
285:
286: FEM_ENGINES_PKG.TECH_MESSAGE
287: (p_severity => c_log_level_2,
288: p_module => v_block||'.p_rownum{584}',
289: p_msg_text => p_rownum);
290:
313: v_block VARCHAR2(80) := 'fem.plsql.fem_mp.put_data_slice';
314:
315: BEGIN
316:
317: FEM_ENGINES_PKG.TECH_MESSAGE
318: (p_severity => c_log_level_2,
319: p_module => v_block||'.p_rownum{582}',
320: p_msg_text => TO_CHAR(p_rownum));
321:
329: null, null, null, null, null);
330:
331: COMMIT;
332:
333: FEM_ENGINES_PKG.TECH_MESSAGE
334: (p_severity => c_log_level_2,
335: p_module => v_block||'.p_rownum{584}',
336: p_msg_text => TO_CHAR(p_rownum));
337:
386: BEGIN
387:
388: v_condition := NVL(REPLACE(p_condition,'WHERE',''),'1=1');
389:
390: FEM_ENGINES_PKG.TECH_MESSAGE
391: (p_severity => c_log_level_2,
392: p_module => v_block||'.p_part_name{580}',
393: p_msg_text => p_part_name);
394: FEM_ENGINES_PKG.TECH_MESSAGE
390: FEM_ENGINES_PKG.TECH_MESSAGE
391: (p_severity => c_log_level_2,
392: p_module => v_block||'.p_part_name{580}',
393: p_msg_text => p_part_name);
394: FEM_ENGINES_PKG.TECH_MESSAGE
395: (p_severity => c_log_level_2,
396: p_module => v_block||'.p_slc_col{581}',
397: p_msg_text => p_slc_col);
398: FEM_ENGINES_PKG.TECH_MESSAGE
394: FEM_ENGINES_PKG.TECH_MESSAGE
395: (p_severity => c_log_level_2,
396: p_module => v_block||'.p_slc_col{581}',
397: p_msg_text => p_slc_col);
398: FEM_ENGINES_PKG.TECH_MESSAGE
399: (p_severity => c_log_level_2,
400: p_module => v_block||'.p_rownum{582}',
401: p_msg_text => TO_CHAR(p_rownum));
402:
428: 'FROM ' || p_data_table || v_part_clause ||
429: ' WHERE ' || v_condition ||
430: ' AND ' || p_slc_col || ' > :b_last_max';
431:
432: FEM_ENGINES_PKG.TECH_MESSAGE
433: (p_severity => c_log_level_1,
434: p_module => v_block||'.v_sql_cmd1{571}',
435: p_msg_text => v_sql_cmd1);
436: FEM_ENGINES_PKG.TECH_MESSAGE
432: FEM_ENGINES_PKG.TECH_MESSAGE
433: (p_severity => c_log_level_1,
434: p_module => v_block||'.v_sql_cmd1{571}',
435: p_msg_text => v_sql_cmd1);
436: FEM_ENGINES_PKG.TECH_MESSAGE
437: (p_severity => c_log_level_1,
438: p_module => v_block||'.v_sql_cmd2{572}',
439: p_msg_text => v_sql_cmd2);
440:
450: LOOP
451: FETCH c_col_slc INTO v_lo_val, v_hi_val;
452: EXIT WHEN c_col_slc%NOTFOUND;
453:
454: FEM_ENGINES_PKG.TECH_MESSAGE
455: (p_severity => c_log_level_3,
456: p_module => v_block||'.ntile_min_max{574}',
457: p_msg_text => v_lo_val||'{#}'||v_hi_val);
458:
463: EXECUTE IMMEDIATE v_sql_cmd2
464: INTO v_lo_val
465: USING v_last_hi;
466:
467: FEM_ENGINES_PKG.TECH_MESSAGE
468: (p_severity => c_log_level_3,
469: p_module => v_block||'.adjusted_min_max{574.1}',
470: p_msg_text => v_lo_val||'{#}'||v_hi_val);
471: END IF;
473: IF (TO_NUMBER(v_lo_val) > TO_NUMBER(v_hi_val))
474: THEN
475: v_hi_val := v_lo_val;
476:
477: FEM_ENGINES_PKG.TECH_MESSAGE
478: (p_severity => c_log_level_3,
479: p_module => v_block||'.adjusted_min_max{574.2}',
480: p_msg_text => v_lo_val||'{#}'||v_hi_val);
481: END IF;
487: EXECUTE IMMEDIATE v_sql_cmd2
488: INTO v_lo_val
489: USING v_last_hi;
490:
491: FEM_ENGINES_PKG.TECH_MESSAGE
492: (p_severity => c_log_level_3,
493: p_module => v_block||'.adjusted_min_max{575.1}',
494: p_msg_text => v_lo_val||'{#}'||v_hi_val);
495: END IF;
497: IF (v_lo_val > v_hi_val)
498: THEN
499: v_hi_val := v_lo_val;
500:
501: FEM_ENGINES_PKG.TECH_MESSAGE
502: (p_severity => c_log_level_3,
503: p_module => v_block||'.adjusted_min_max{575.2}',
504: p_msg_text => v_lo_val||'{#}'||v_hi_val);
505: END IF;
520: p_part_name => p_part_name);
521:
522: v_last_hi := v_hi_val;
523:
524: FEM_ENGINES_PKG.TECH_MESSAGE
525: (p_severity => c_log_level_2,
526: p_module => v_block||'.v_last_hi{576}',
527: p_msg_text => v_last_hi);
528:
600: Build Data Slices: Execution Block
601: **************************************************************************/
602: BEGIN
603:
604: FEM_ENGINES_PKG.TECH_MESSAGE
605: (p_severity => c_log_level_3,
606: p_module => v_block||'.Begin{550}',
607: p_msg_text => 'Begin FEM_MP.Build_Data_Slices');
608: FEM_ENGINES_PKG.TECH_MESSAGE
604: FEM_ENGINES_PKG.TECH_MESSAGE
605: (p_severity => c_log_level_3,
606: p_module => v_block||'.Begin{550}',
607: p_msg_text => 'Begin FEM_MP.Build_Data_Slices');
608: FEM_ENGINES_PKG.TECH_MESSAGE
609: (p_severity => c_log_level_2,
610: p_module => v_block||'.p_req_id{552}',
611: p_msg_text => p_req_id);
612: FEM_ENGINES_PKG.TECH_MESSAGE
608: FEM_ENGINES_PKG.TECH_MESSAGE
609: (p_severity => c_log_level_2,
610: p_module => v_block||'.p_req_id{552}',
611: p_msg_text => p_req_id);
612: FEM_ENGINES_PKG.TECH_MESSAGE
613: (p_severity => c_log_level_2,
614: p_module => v_block||'.p_slc_code{553}',
615: p_msg_text => p_slc_code);
616: FEM_ENGINES_PKG.TECH_MESSAGE
612: FEM_ENGINES_PKG.TECH_MESSAGE
613: (p_severity => c_log_level_2,
614: p_module => v_block||'.p_slc_code{553}',
615: p_msg_text => p_slc_code);
616: FEM_ENGINES_PKG.TECH_MESSAGE
617: (p_severity => c_log_level_2,
618: p_module => v_block||'.p_slc_type{554}',
619: p_msg_text => p_slc_type);
620: FEM_ENGINES_PKG.TECH_MESSAGE
616: FEM_ENGINES_PKG.TECH_MESSAGE
617: (p_severity => c_log_level_2,
618: p_module => v_block||'.p_slc_type{554}',
619: p_msg_text => p_slc_type);
620: FEM_ENGINES_PKG.TECH_MESSAGE
621: (p_severity => c_log_level_2,
622: p_module => v_block||'.p_part_code{555}',
623: p_msg_text => p_part_code);
624: FEM_ENGINES_PKG.TECH_MESSAGE
620: FEM_ENGINES_PKG.TECH_MESSAGE
621: (p_severity => c_log_level_2,
622: p_module => v_block||'.p_part_code{555}',
623: p_msg_text => p_part_code);
624: FEM_ENGINES_PKG.TECH_MESSAGE
625: (p_severity => c_log_level_2,
626: p_module => v_block||'.p_data_table{556}',
627: p_msg_text => p_data_table);
628: FEM_ENGINES_PKG.TECH_MESSAGE
624: FEM_ENGINES_PKG.TECH_MESSAGE
625: (p_severity => c_log_level_2,
626: p_module => v_block||'.p_data_table{556}',
627: p_msg_text => p_data_table);
628: FEM_ENGINES_PKG.TECH_MESSAGE
629: (p_severity => c_log_level_2,
630: p_module => v_block||'.p_table_alias{557}',
631: p_msg_text => p_table_alias);
632: FEM_ENGINES_PKG.TECH_MESSAGE
628: FEM_ENGINES_PKG.TECH_MESSAGE
629: (p_severity => c_log_level_2,
630: p_module => v_block||'.p_table_alias{557}',
631: p_msg_text => p_table_alias);
632: FEM_ENGINES_PKG.TECH_MESSAGE
633: (p_severity => c_log_level_2,
634: p_module => v_block||'.p_condition{558}',
635: p_msg_text => p_condition);
636:
635: p_msg_text => p_condition);
636:
637: v_condition := NVL(REPLACE(p_condition,'WHERE',''),'1=1');
638:
639: FEM_ENGINES_PKG.TECH_MESSAGE
640: (p_severity => c_log_level_2,
641: p_module => v_block||'.v_condition{559}',
642: p_msg_text => v_condition);
643:
666: USING p_data_table;
667:
668: END IF;
669:
670: FEM_ENGINES_PKG.TECH_MESSAGE
671: (p_severity => c_log_level_2,
672: p_module => v_block||'.v_tab_name{556.1}',
673: p_msg_text => v_tab_name);
674: FEM_ENGINES_PKG.TECH_MESSAGE
670: FEM_ENGINES_PKG.TECH_MESSAGE
671: (p_severity => c_log_level_2,
672: p_module => v_block||'.v_tab_name{556.1}',
673: p_msg_text => v_tab_name);
674: FEM_ENGINES_PKG.TECH_MESSAGE
675: (p_severity => c_log_level_2,
676: p_module => v_block||'.v_tab_owner{556.2}',
677: p_msg_text => v_tab_owner);
678: FEM_ENGINES_PKG.TECH_MESSAGE
674: FEM_ENGINES_PKG.TECH_MESSAGE
675: (p_severity => c_log_level_2,
676: p_module => v_block||'.v_tab_owner{556.2}',
677: p_msg_text => v_tab_owner);
678: FEM_ENGINES_PKG.TECH_MESSAGE
679: (p_severity => c_log_level_2,
680: p_module => v_block||'.v_data_table{556.3}',
681: p_msg_text => v_data_table);
682:
703: v_slc_col := '';
704: v_col_type := 'VARCHAR2';
705: END;
706:
707: FEM_ENGINES_PKG.TECH_MESSAGE
708: (p_severity => c_log_level_2,
709: p_module => v_block||'.v_slc_col{560}',
710: p_msg_text => v_slc_col);
711:
780: v_rows_slice := null;
781: END IF;
782: END IF;
783:
784: FEM_ENGINES_PKG.TECH_MESSAGE(
785: p_severity => c_log_level_2,
786: p_module => v_block||'.v_num_slices{561}',
787: p_msg_text => v_num_slices);
788: FEM_ENGINES_PKG.TECH_MESSAGE(
784: FEM_ENGINES_PKG.TECH_MESSAGE(
785: p_severity => c_log_level_2,
786: p_module => v_block||'.v_num_slices{561}',
787: p_msg_text => v_num_slices);
788: FEM_ENGINES_PKG.TECH_MESSAGE(
789: p_severity => c_log_level_2,
790: p_module => v_block||'.v_rows_slice{562}',
791: p_msg_text => v_rows_slice);
792: FEM_ENGINES_PKG.TECH_MESSAGE
788: FEM_ENGINES_PKG.TECH_MESSAGE(
789: p_severity => c_log_level_2,
790: p_module => v_block||'.v_rows_slice{562}',
791: p_msg_text => v_rows_slice);
792: FEM_ENGINES_PKG.TECH_MESSAGE
793: (p_severity => c_log_level_2,
794: p_module => v_block||'.v_slc_col{563}',
795: p_msg_text => v_slc_col);
796: FEM_ENGINES_PKG.TECH_MESSAGE
792: FEM_ENGINES_PKG.TECH_MESSAGE
793: (p_severity => c_log_level_2,
794: p_module => v_block||'.v_slc_col{563}',
795: p_msg_text => v_slc_col);
796: FEM_ENGINES_PKG.TECH_MESSAGE
797: (p_severity => c_log_level_2,
798: p_module => v_block||'.v_col_type{564}',
799: p_msg_text => v_col_type);
800:
882: v_data_slice := 1;
883:
884: END IF;
885:
886: FEM_ENGINES_PKG.TECH_MESSAGE
887: (p_severity => c_log_level_2,
888: p_module => v_block||'.v_slc_method{565}',
889: p_msg_text => v_slc_method);
890: FEM_ENGINES_PKG.TECH_MESSAGE
886: FEM_ENGINES_PKG.TECH_MESSAGE
887: (p_severity => c_log_level_2,
888: p_module => v_block||'.v_slc_method{565}',
889: p_msg_text => v_slc_method);
890: FEM_ENGINES_PKG.TECH_MESSAGE
891: (p_severity => c_log_level_2,
892: p_module => v_block||'.v_data_slc{566}',
893: p_msg_text => v_data_slice);
894:
933: ELSE NULL;
934: END CASE;
935: END IF;
936:
937: FEM_ENGINES_PKG.TECH_MESSAGE
938: (p_severity => c_log_level_2,
939: p_module => v_block||'.v_part_name{580}',
940: p_msg_text => v_part_name);
941:
978: END IF;
979:
980: v_num_slices_calc := CEIL(v_count/v_rows_slice);
981:
982: FEM_ENGINES_PKG.TECH_MESSAGE
983: (p_severity => c_log_level_2,
984: p_module => v_block||'.v_num_slices_calc{570}',
985: p_msg_text => v_num_slices_calc);
986:
1038: -- Partitioning is off; must post one dummy data slice for the table.
1039: v_count := 1;
1040: END IF;
1041:
1042: FEM_ENGINES_PKG.TECH_MESSAGE
1043: (p_severity => c_log_level_2,
1044: p_module => v_block||'.v_count{570.1}',
1045: p_msg_text => v_count);
1046:
1068:
1069: END LOOP;
1070: CLOSE c_tab_part;
1071:
1072: FEM_ENGINES_PKG.TECH_MESSAGE
1073: (p_severity => c_log_level_3,
1074: p_module => v_block||'.End{579}',
1075: p_msg_text => 'End FEM_MP.Build_Data_Slices');
1076:
1209:
1210: DBMS_SESSION.SET_SQL_TRACE (sql_trace => FALSE);
1211: v_trace := 'FEM_MP.Master:'||v_req_id;
1212:
1213: FEM_ENGINES_PKG.TECH_MESSAGE(
1214: p_severity => c_log_level_3,
1215: p_module => v_block||'.Begin{500}',
1216: p_msg_text => 'Begin FEM_MP.MASTER');
1217: FEM_ENGINES_PKG.TECH_MESSAGE(
1213: FEM_ENGINES_PKG.TECH_MESSAGE(
1214: p_severity => c_log_level_3,
1215: p_module => v_block||'.Begin{500}',
1216: p_msg_text => 'Begin FEM_MP.MASTER');
1217: FEM_ENGINES_PKG.TECH_MESSAGE(
1218: p_severity => c_log_level_2,
1219: p_module => v_block||'.v_req_id{501}',
1220: p_msg_text => v_req_id);
1221: FEM_ENGINES_PKG.TECH_MESSAGE(
1217: FEM_ENGINES_PKG.TECH_MESSAGE(
1218: p_severity => c_log_level_2,
1219: p_module => v_block||'.v_req_id{501}',
1220: p_msg_text => v_req_id);
1221: FEM_ENGINES_PKG.TECH_MESSAGE(
1222: p_severity => c_log_level_2,
1223: p_module => v_block||'.p_rule_id{502}',
1224: p_msg_text => p_rule_id);
1225: FEM_ENGINES_PKG.TECH_MESSAGE(
1221: FEM_ENGINES_PKG.TECH_MESSAGE(
1222: p_severity => c_log_level_2,
1223: p_module => v_block||'.p_rule_id{502}',
1224: p_msg_text => p_rule_id);
1225: FEM_ENGINES_PKG.TECH_MESSAGE(
1226: p_severity => c_log_level_2,
1227: p_module => v_block||'.p_eng_step{503}',
1228: p_msg_text => p_eng_step);
1229: FEM_ENGINES_PKG.TECH_MESSAGE(
1225: FEM_ENGINES_PKG.TECH_MESSAGE(
1226: p_severity => c_log_level_2,
1227: p_module => v_block||'.p_eng_step{503}',
1228: p_msg_text => p_eng_step);
1229: FEM_ENGINES_PKG.TECH_MESSAGE(
1230: p_severity => c_log_level_1,
1231: p_module => v_block||'.p_eng_sql{504}',
1232: p_msg_text => p_eng_sql);
1233: FEM_ENGINES_PKG.TECH_MESSAGE(
1229: FEM_ENGINES_PKG.TECH_MESSAGE(
1230: p_severity => c_log_level_1,
1231: p_module => v_block||'.p_eng_sql{504}',
1232: p_msg_text => p_eng_sql);
1233: FEM_ENGINES_PKG.TECH_MESSAGE(
1234: p_severity => c_log_level_2,
1235: p_module => v_block||'.p_data_table{505}',
1236: p_msg_text => p_data_table);
1237: FEM_ENGINES_PKG.TECH_MESSAGE(
1233: FEM_ENGINES_PKG.TECH_MESSAGE(
1234: p_severity => c_log_level_2,
1235: p_module => v_block||'.p_data_table{505}',
1236: p_msg_text => p_data_table);
1237: FEM_ENGINES_PKG.TECH_MESSAGE(
1238: p_severity => c_log_level_2,
1239: p_module => v_block||'.p_table_alias{506}',
1240: p_msg_text => p_table_alias);
1241: FEM_ENGINES_PKG.TECH_MESSAGE(
1237: FEM_ENGINES_PKG.TECH_MESSAGE(
1238: p_severity => c_log_level_2,
1239: p_module => v_block||'.p_table_alias{506}',
1240: p_msg_text => p_table_alias);
1241: FEM_ENGINES_PKG.TECH_MESSAGE(
1242: p_severity => c_log_level_2,
1243: p_module => v_block||'.p_run_name{507}',
1244: p_msg_text => p_run_name);
1245: FEM_ENGINES_PKG.TECH_MESSAGE(
1241: FEM_ENGINES_PKG.TECH_MESSAGE(
1242: p_severity => c_log_level_2,
1243: p_module => v_block||'.p_run_name{507}',
1244: p_msg_text => p_run_name);
1245: FEM_ENGINES_PKG.TECH_MESSAGE(
1246: p_severity => c_log_level_2,
1247: p_module => v_block||'.p_eng_prg{508}',
1248: p_msg_text => p_eng_prg);
1249: FEM_ENGINES_PKG.TECH_MESSAGE(
1245: FEM_ENGINES_PKG.TECH_MESSAGE(
1246: p_severity => c_log_level_2,
1247: p_module => v_block||'.p_eng_prg{508}',
1248: p_msg_text => p_eng_prg);
1249: FEM_ENGINES_PKG.TECH_MESSAGE(
1250: p_severity => c_log_level_2,
1251: p_module => v_block||'.p_condition{509}',
1252: p_msg_text => p_condition);
1253: FEM_ENGINES_PKG.TECH_MESSAGE(
1249: FEM_ENGINES_PKG.TECH_MESSAGE(
1250: p_severity => c_log_level_2,
1251: p_module => v_block||'.p_condition{509}',
1252: p_msg_text => p_condition);
1253: FEM_ENGINES_PKG.TECH_MESSAGE(
1254: p_severity => c_log_level_2,
1255: p_module => v_block||'.p_failed_req_id{510}',
1256: p_msg_text => p_failed_req_id);
1257:
1396: AND step_name = 'ALL'
1397: AND object_id IS NULL;
1398: EXCEPTION
1399: WHEN no_data_found THEN
1400: FEM_ENGINES_PKG.PUT_MESSAGE
1401: (p_app_name => 'FEM',
1402: p_msg_name => 'FEM_MP_NO_SETTINGS_WARN',
1403: p_token1 => 'REQUEST',
1404: p_value1 => v_req_name);
1403: p_token1 => 'REQUEST',
1404: p_value1 => v_req_name);
1405: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1406:
1407: FEM_ENGINES_PKG.TECH_MESSAGE
1408: (p_severity => c_log_level_5,
1409: p_module => v_block||'.get_mp_settings{542}',
1410: p_msg_text => v_prg_msg);
1411: FEM_ENGINES_PKG.USER_MESSAGE(
1407: FEM_ENGINES_PKG.TECH_MESSAGE
1408: (p_severity => c_log_level_5,
1409: p_module => v_block||'.get_mp_settings{542}',
1410: p_msg_text => v_prg_msg);
1411: FEM_ENGINES_PKG.USER_MESSAGE(
1412: p_msg_text => v_prg_msg);
1413:
1414: -- f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS(
1415: -- 'WARNING',null);
1432: THEN
1433: v_num_procs := 0;
1434: END IF;
1435:
1436: FEM_ENGINES_PKG.TECH_MESSAGE(
1437: p_severity => c_log_level_2,
1438: p_module => v_block||'.v_eng_prg{511}',
1439: p_msg_text => v_eng_prg);
1440: FEM_ENGINES_PKG.TECH_MESSAGE(
1436: FEM_ENGINES_PKG.TECH_MESSAGE(
1437: p_severity => c_log_level_2,
1438: p_module => v_block||'.v_eng_prg{511}',
1439: p_msg_text => v_eng_prg);
1440: FEM_ENGINES_PKG.TECH_MESSAGE(
1441: p_severity => c_log_level_2,
1442: p_module => v_block||'.v_obj_type{512}',
1443: p_msg_text => v_obj_type);
1444: FEM_ENGINES_PKG.TECH_MESSAGE(
1440: FEM_ENGINES_PKG.TECH_MESSAGE(
1441: p_severity => c_log_level_2,
1442: p_module => v_block||'.v_obj_type{512}',
1443: p_msg_text => v_obj_type);
1444: FEM_ENGINES_PKG.TECH_MESSAGE(
1445: p_severity => c_log_level_2,
1446: p_module => v_block||'.v_eng_step{513}',
1447: p_msg_text => v_eng_step);
1448: CASE v_mp_method
1450: WHEN 1 THEN v_msg_text := v_mp_method||' (Pull)';
1451: WHEN 2 THEN v_msg_text := v_mp_method||' (Bind values push)';
1452: ELSE v_msg_text := v_mp_method||' (Invalid MP Method Code)';
1453: END CASE;
1454: FEM_ENGINES_PKG.TECH_MESSAGE(
1455: p_severity => c_log_level_2,
1456: p_module => v_block||'.v_mp_method{514}',
1457: p_msg_text => v_msg_text);
1458: FEM_ENGINES_PKG.TECH_MESSAGE(
1454: FEM_ENGINES_PKG.TECH_MESSAGE(
1455: p_severity => c_log_level_2,
1456: p_module => v_block||'.v_mp_method{514}',
1457: p_msg_text => v_msg_text);
1458: FEM_ENGINES_PKG.TECH_MESSAGE(
1459: p_severity => c_log_level_2,
1460: p_module => v_block||'.v_slc_code{515}',
1461: p_msg_text => v_slc_code);
1462: CASE v_slc_type
1465: WHEN 2 THEN v_msg_text := v_slc_type||' (Value ranges)';
1466: WHEN 3 THEN v_msg_text := v_slc_type||' (No slicing)';
1467: ELSE v_msg_text := v_slc_type||' (Invalid Data Slice Type Code)';
1468: END CASE;
1469: FEM_ENGINES_PKG.TECH_MESSAGE(
1470: p_severity => c_log_level_2,
1471: p_module => v_block||'.v_slc_type{516}',
1472: p_msg_text => v_msg_text);
1473: CASE v_part_code
1475: WHEN 1 THEN v_msg_text := v_part_code||' (Shared partitioning)';
1476: WHEN 2 THEN v_msg_text := v_part_code||' (Dedicated partitioning)';
1477: ELSE v_msg_text := v_part_code||' (Invalid Process Partition Code)';
1478: END CASE;
1479: FEM_ENGINES_PKG.TECH_MESSAGE(
1480: p_severity => c_log_level_2,
1481: p_module => v_block||'.v_part_code{517}',
1482: p_msg_text => v_msg_text);
1483: FEM_ENGINES_PKG.TECH_MESSAGE(
1479: FEM_ENGINES_PKG.TECH_MESSAGE(
1480: p_severity => c_log_level_2,
1481: p_module => v_block||'.v_part_code{517}',
1482: p_msg_text => v_msg_text);
1483: FEM_ENGINES_PKG.TECH_MESSAGE(
1484: p_severity => c_log_level_2,
1485: p_module => v_block||'.v_num_procs{518}',
1486: p_msg_text => v_num_procs);
1487: FEM_ENGINES_PKG.TECH_MESSAGE(
1483: FEM_ENGINES_PKG.TECH_MESSAGE(
1484: p_severity => c_log_level_2,
1485: p_module => v_block||'.v_num_procs{518}',
1486: p_msg_text => v_num_procs);
1487: FEM_ENGINES_PKG.TECH_MESSAGE(
1488: p_severity => c_log_level_2,
1489: p_module => v_block||'.v_fetch_limit{519}',
1490: p_msg_text => v_fetch_limit);
1491:
1540: p_condition => p_condition);
1541: END IF;
1542: END IF;
1543:
1544: FEM_ENGINES_PKG.TECH_MESSAGE(
1545: p_severity => c_log_level_2,
1546: p_module => v_block||'.v_slc_pred{520.1}',
1547: p_msg_text => v_slc_pred);
1548: FEM_ENGINES_PKG.TECH_MESSAGE(
1544: FEM_ENGINES_PKG.TECH_MESSAGE(
1545: p_severity => c_log_level_2,
1546: p_module => v_block||'.v_slc_pred{520.1}',
1547: p_msg_text => v_slc_pred);
1548: FEM_ENGINES_PKG.TECH_MESSAGE(
1549: p_severity => c_log_level_2,
1550: p_module => v_block||'.v_part_code{520.2}',
1551: p_msg_text => v_part_code);
1552:
1572: ELSE
1573: RAISE e_no_data_slices;
1574: END IF;
1575:
1576: FEM_ENGINES_PKG.TECH_MESSAGE(
1577: p_severity => c_log_level_2,
1578: p_module => v_block||'.v_num_slices{521}',
1579: p_msg_text => v_num_slices);
1580:
1592: THEN
1593: v_num_procs := c_max_procs;
1594: END IF;
1595:
1596: FEM_ENGINES_PKG.TECH_MESSAGE(
1597: p_severity => c_log_level_2,
1598: p_module => v_block||'.v_num_procs{522}',
1599: p_msg_text => v_num_procs);
1600: FEM_ENGINES_PKG.TECH_MESSAGE(
1596: FEM_ENGINES_PKG.TECH_MESSAGE(
1597: p_severity => c_log_level_2,
1598: p_module => v_block||'.v_num_procs{522}',
1599: p_msg_text => v_num_procs);
1600: FEM_ENGINES_PKG.TECH_MESSAGE(
1601: p_severity => c_log_level_2,
1602: p_module => v_block||'.v_slc_pred{523}',
1603: p_msg_text => v_slc_pred);
1604: END IF;
1665: x_prms_in => v_prms_count);
1666:
1667: v_args_count := v_prms_count - 5; -- There are 5 reqd IN parameters
1668:
1669: FEM_ENGINES_PKG.TECH_MESSAGE(
1670: p_severity => c_log_level_2,
1671: p_module => v_block||'.v_prms_count{524.1}',
1672: p_msg_text => v_prms_count);
1673: END IF;
1671: p_module => v_block||'.v_prms_count{524.1}',
1672: p_msg_text => v_prms_count);
1673: END IF;
1674:
1675: FEM_ENGINES_PKG.TECH_MESSAGE(
1676: p_severity => c_log_level_2,
1677: p_module => v_block||'.v_args_count{524.2}',
1678: p_msg_text => v_args_count);
1679:
1676: p_severity => c_log_level_2,
1677: p_module => v_block||'.v_args_count{524.2}',
1678: p_msg_text => v_args_count);
1679:
1680: FEM_ENGINES_PKG.TECH_MESSAGE(
1681: p_severity => c_log_level_1,
1682: p_module => v_block||'.v_sql_cmd{525}',
1683: p_msg_text => 'Inserting into FEM_MP_PROCESS_ARGS_T...');
1684:
1730: argument4 => i_proc_num,
1731: argument5 => v_part_code,
1732: argument6 => v_fetch_limit);
1733:
1734: FEM_ENGINES_PKG.TECH_MESSAGE(
1735: p_severity => c_log_level_2,
1736: p_module => v_block||'.sub_request{530}',
1737: p_msg_text => 'i_proc_num='||i_proc_num||':v_sub_req_id='||v_sub_req_id);
1738:
1755: LOOP
1756:
1757: v_sub_req_id := r_sub_req_id.request_id;
1758:
1759: FEM_ENGINES_PKG.TECH_MESSAGE(
1760: p_severity => c_log_level_2,
1761: p_module => v_block||'.v_sub_req_id{531.1}',
1762: p_msg_text => v_sub_req_id);
1763:
1765: f_req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST
1766: (v_sub_req_id,5,0,v_req_phase,v_req_status,
1767: v_dev_phase,v_dev_status,v_req_message);
1768:
1769: FEM_ENGINES_PKG.TECH_MESSAGE(
1770: p_severity => c_log_level_2,
1771: p_module => v_block||'.req_status{531.2}',
1772: p_msg_text => 'Sub-request='||v_sub_req_id||' : '||
1773: 'Phase='||v_dev_phase||' : '||
1801: THEN
1802: RAISE e_no_subreq;
1803: END IF;
1804:
1805: FEM_ENGINES_PKG.TECH_MESSAGE(
1806: p_severity => c_log_level_2,
1807: p_module => v_block||'.x_prg_stat{532}',
1808: p_msg_text => x_prg_stat);
1809:
1808: p_msg_text => x_prg_stat);
1809:
1810: IF (x_prg_stat = 'COMPLETE:NORMAL')
1811: THEN
1812: FEM_ENGINES_PKG.PUT_MESSAGE(
1813: p_app_name => 'FEM',
1814: p_msg_name => 'FEM_MP_SUBS_NORMAL_TXT',
1815: p_token1 => 'REQUEST',
1816: p_value1 => v_req_name);
1816: p_value1 => v_req_name);
1817: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1818: ELSIF (x_prg_stat = 'COMPLETE:WARNING')
1819: THEN
1820: FEM_ENGINES_PKG.PUT_MESSAGE(
1821: p_app_name => 'FEM',
1822: p_msg_name => 'FEM_MP_SUBS_WARN_TXT',
1823: p_token1 => 'REQUEST',
1824: p_value1 => v_req_name);
1823: p_token1 => 'REQUEST',
1824: p_value1 => v_req_name);
1825: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1826: ELSE
1827: FEM_ENGINES_PKG.PUT_MESSAGE
1828: (p_app_name => 'FEM',
1829: p_msg_name => 'FEM_MP_SUBS_ERROR_TXT',
1830: p_token1 => 'REQUEST',
1831: p_value1 => v_req_name);
1831: p_value1 => v_req_name);
1832: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1833: END IF;
1834:
1835: FEM_ENGINES_PKG.TECH_MESSAGE(
1836: p_severity => c_log_level_3,
1837: p_module => v_block||'.End{533}',
1838: p_msg_text => 'End FEM_MP.MASTER. '||v_prg_msg);
1839: -- FEM_ENGINES_PKG.USER_MESSAGE(
1835: FEM_ENGINES_PKG.TECH_MESSAGE(
1836: p_severity => c_log_level_3,
1837: p_module => v_block||'.End{533}',
1838: p_msg_text => 'End FEM_MP.MASTER. '||v_prg_msg);
1839: -- FEM_ENGINES_PKG.USER_MESSAGE(
1840: -- p_msg_text => v_prg_msg);
1841:
1842: /*************************************************************************
1843:
1847:
1848: EXCEPTION
1849:
1850: WHEN e_soft_kill THEN
1851: FEM_ENGINES_PKG.PUT_MESSAGE(
1852: p_app_name => 'FEM',
1853: p_msg_name => 'FEM_MP_SOFT_KILL_WARN',
1854: p_token1 => 'REQUEST',
1855: p_value1 => v_req_name);
1854: p_token1 => 'REQUEST',
1855: p_value1 => v_req_name);
1856: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1857:
1858: FEM_ENGINES_PKG.TECH_MESSAGE(
1859: p_severity => c_log_level_5,
1860: p_module => v_block||'.soft_kill_signal{540}',
1861: p_msg_text => v_prg_msg);
1862: FEM_ENGINES_PKG.USER_MESSAGE(
1858: FEM_ENGINES_PKG.TECH_MESSAGE(
1859: p_severity => c_log_level_5,
1860: p_module => v_block||'.soft_kill_signal{540}',
1861: p_msg_text => v_prg_msg);
1862: FEM_ENGINES_PKG.USER_MESSAGE(
1863: p_msg_text => v_prg_msg);
1864:
1865: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',null);
1866: x_prg_stat := 'COMPLETE:WARNING';
1866: x_prg_stat := 'COMPLETE:WARNING';
1867: x_exception_code := 'FEM_MP_SOFT_KILL_WARN';
1868:
1869: WHEN e_no_rule_id THEN
1870: FEM_ENGINES_PKG.PUT_MESSAGE
1871: (p_app_name => 'FEM',
1872: p_msg_name => 'FEM_MP_BAD_OBJECT_ERR',
1873: p_token1 => 'REQUEST',
1874: p_value1 => v_req_name);
1873: p_token1 => 'REQUEST',
1874: p_value1 => v_req_name);
1875: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1876:
1877: FEM_ENGINES_PKG.TECH_MESSAGE
1878: (p_severity => c_log_level_5,
1879: p_module => v_block||'.get_object_type_code{541}',
1880: p_msg_text => v_prg_msg);
1881: FEM_ENGINES_PKG.USER_MESSAGE(
1877: FEM_ENGINES_PKG.TECH_MESSAGE
1878: (p_severity => c_log_level_5,
1879: p_module => v_block||'.get_object_type_code{541}',
1880: p_msg_text => v_prg_msg);
1881: FEM_ENGINES_PKG.USER_MESSAGE(
1882: p_msg_text => v_prg_msg);
1883:
1884: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1885: x_prg_stat := 'COMPLETE:ERROR';
1885: x_prg_stat := 'COMPLETE:ERROR';
1886: x_exception_code := 'FEM_MP_BAD_OBJECT_ERR';
1887:
1888: WHEN e_no_mp_method THEN
1889: FEM_ENGINES_PKG.PUT_MESSAGE
1890: (p_app_name => 'FEM',
1891: p_msg_name => 'FEM_MP_NO_METHOD_ERR',
1892: p_token1 => 'REQUEST',
1893: p_value1 => v_req_name);
1892: p_token1 => 'REQUEST',
1893: p_value1 => v_req_name);
1894: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1895:
1896: FEM_ENGINES_PKG.TECH_MESSAGE
1897: (p_severity => c_log_level_5,
1898: p_module => v_block||'.get_mp_settings{542}',
1899: p_msg_text => v_prg_msg);
1900: FEM_ENGINES_PKG.USER_MESSAGE(
1896: FEM_ENGINES_PKG.TECH_MESSAGE
1897: (p_severity => c_log_level_5,
1898: p_module => v_block||'.get_mp_settings{542}',
1899: p_msg_text => v_prg_msg);
1900: FEM_ENGINES_PKG.USER_MESSAGE(
1901: p_msg_text => v_prg_msg);
1902:
1903: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1904: x_prg_stat := 'COMPLETE:ERROR';
1904: x_prg_stat := 'COMPLETE:ERROR';
1905: x_exception_code := 'FEM_MP_NO_METHOD_ERR';
1906:
1907: WHEN e_bad_mp_settings THEN
1908: FEM_ENGINES_PKG.PUT_MESSAGE
1909: (p_app_name => 'FEM',
1910: p_msg_name => 'FEM_MP_BAD_SETTINGS_ERR',
1911: p_token1 => 'REQUEST',
1912: p_value1 => v_req_name);
1911: p_token1 => 'REQUEST',
1912: p_value1 => v_req_name);
1913: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1914:
1915: FEM_ENGINES_PKG.TECH_MESSAGE
1916: (p_severity => c_log_level_5,
1917: p_module => v_block||'.get_mp_settings{543}',
1918: p_msg_text => v_prg_msg);
1919: FEM_ENGINES_PKG.USER_MESSAGE(
1915: FEM_ENGINES_PKG.TECH_MESSAGE
1916: (p_severity => c_log_level_5,
1917: p_module => v_block||'.get_mp_settings{543}',
1918: p_msg_text => v_prg_msg);
1919: FEM_ENGINES_PKG.USER_MESSAGE(
1920: p_msg_text => v_prg_msg);
1921:
1922: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1923: x_prg_stat := 'COMPLETE:ERROR';
1923: x_prg_stat := 'COMPLETE:ERROR';
1924: x_exception_code := 'FEM_MP_BAD_SETTINGS_ERR';
1925:
1926: WHEN e_no_data_slices THEN
1927: FEM_ENGINES_PKG.PUT_MESSAGE
1928: (p_app_name => 'FEM',
1929: p_msg_name => 'FEM_MP_NO_DATA_SLICES_ERR',
1930: p_token1 => 'REQUEST',
1931: p_value1 => v_req_name);
1930: p_token1 => 'REQUEST',
1931: p_value1 => v_req_name);
1932: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1933:
1934: FEM_ENGINES_PKG.TECH_MESSAGE
1935: (p_severity => c_log_level_5,
1936: p_module => v_block||'.Build_Data_Slices{544}',
1937: p_msg_text => v_prg_msg);
1938:
1940: x_prg_stat := 'COMPLETE:ERROR';
1941: x_exception_code := 'FEM_MP_NO_DATA_SLICES_ERR';
1942:
1943: WHEN e_no_subreq THEN
1944: FEM_ENGINES_PKG.PUT_MESSAGE
1945: (p_app_name => 'FEM',
1946: p_msg_name => 'FEM_MP_NO_SUBREQ_ERR',
1947: p_token1 => 'REQUEST',
1948: p_value1 => v_req_name);
1947: p_token1 => 'REQUEST',
1948: p_value1 => v_req_name);
1949: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1950:
1951: FEM_ENGINES_PKG.TECH_MESSAGE
1952: (p_severity => c_log_level_5,
1953: p_module => v_block||'.submit_sub_request{545}',
1954: p_msg_text => v_prg_msg);
1955: FEM_ENGINES_PKG.USER_MESSAGE(
1951: FEM_ENGINES_PKG.TECH_MESSAGE
1952: (p_severity => c_log_level_5,
1953: p_module => v_block||'.submit_sub_request{545}',
1954: p_msg_text => v_prg_msg);
1955: FEM_ENGINES_PKG.USER_MESSAGE(
1956: p_msg_text => v_prg_msg);
1957:
1958: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1959: x_prg_stat := 'COMPLETE:ERROR';
1961:
1962: WHEN others THEN
1963: v_stack := dbms_utility.format_call_stack;
1964:
1965: FEM_ENGINES_PKG.PUT_MESSAGE(
1966: p_app_name => 'FEM',
1967: p_msg_name => 'FEM_MP_UNEXP_ERR',
1968: p_token1 => 'REQUEST',
1969: p_value1 => v_req_name,
1970: p_token2 => 'SQLERRM',
1971: p_value2 => sqlerrm);
1972: v_prg_msg := FND_MSG_PUB.GET(p_encoded => 'F');
1973:
1974: FEM_ENGINES_PKG.TECH_MESSAGE
1975: (p_severity => c_log_level_6,
1976: p_module => v_block||'.exception{546}',
1977: p_msg_text => v_prg_msg||'
1978: '||v_stack);
1975: (p_severity => c_log_level_6,
1976: p_module => v_block||'.exception{546}',
1977: p_msg_text => v_prg_msg||'
1978: '||v_stack);
1979: FEM_ENGINES_PKG.USER_MESSAGE(
1980: p_msg_text => v_prg_msg);
1981:
1982: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1983: x_prg_stat := 'COMPLETE:ERROR';
2076:
2077: DBMS_SESSION.SET_SQL_TRACE (sql_trace => FALSE);
2078: v_trace := 'FEM_MP.Subrequest:'||v_sub_req_id;
2079:
2080: FEM_ENGINES_PKG.TECH_MESSAGE
2081: (p_severity => c_log_level_3,
2082: p_module => v_block||'.Begin{600}',
2083: p_msg_text => 'Begin FEM_MP.SUBREQ');
2084: FEM_ENGINES_PKG.TECH_MESSAGE
2080: FEM_ENGINES_PKG.TECH_MESSAGE
2081: (p_severity => c_log_level_3,
2082: p_module => v_block||'.Begin{600}',
2083: p_msg_text => 'Begin FEM_MP.SUBREQ');
2084: FEM_ENGINES_PKG.TECH_MESSAGE
2085: (p_severity => c_log_level_2,
2086: p_module => v_block||'.v_sub_req_id{601}',
2087: p_msg_text => v_sub_req_id);
2088: FEM_ENGINES_PKG.TECH_MESSAGE
2084: FEM_ENGINES_PKG.TECH_MESSAGE
2085: (p_severity => c_log_level_2,
2086: p_module => v_block||'.v_sub_req_id{601}',
2087: p_msg_text => v_sub_req_id);
2088: FEM_ENGINES_PKG.TECH_MESSAGE
2089: (p_severity => c_log_level_2,
2090: p_module => v_block||'.p_mp_method{602}',
2091: p_msg_text => p_mp_method);
2092: FEM_ENGINES_PKG.TECH_MESSAGE
2088: FEM_ENGINES_PKG.TECH_MESSAGE
2089: (p_severity => c_log_level_2,
2090: p_module => v_block||'.p_mp_method{602}',
2091: p_msg_text => p_mp_method);
2092: FEM_ENGINES_PKG.TECH_MESSAGE
2093: (p_severity => c_log_level_2,
2094: p_module => v_block||'.p_slc_type{603}',
2095: p_msg_text => p_slc_type);
2096: FEM_ENGINES_PKG.TECH_MESSAGE
2092: FEM_ENGINES_PKG.TECH_MESSAGE
2093: (p_severity => c_log_level_2,
2094: p_module => v_block||'.p_slc_type{603}',
2095: p_msg_text => p_slc_type);
2096: FEM_ENGINES_PKG.TECH_MESSAGE
2097: (p_severity => c_log_level_2,
2098: p_module => v_block||'.p_proc_num{605}',
2099: p_msg_text => p_proc_num);
2100: FEM_ENGINES_PKG.TECH_MESSAGE
2096: FEM_ENGINES_PKG.TECH_MESSAGE
2097: (p_severity => c_log_level_2,
2098: p_module => v_block||'.p_proc_num{605}',
2099: p_msg_text => p_proc_num);
2100: FEM_ENGINES_PKG.TECH_MESSAGE
2101: (p_severity => c_log_level_2,
2102: p_module => v_block||'.p_part_code{606}',
2103: p_msg_text => p_part_code);
2104: FEM_ENGINES_PKG.TECH_MESSAGE
2100: FEM_ENGINES_PKG.TECH_MESSAGE
2101: (p_severity => c_log_level_2,
2102: p_module => v_block||'.p_part_code{606}',
2103: p_msg_text => p_part_code);
2104: FEM_ENGINES_PKG.TECH_MESSAGE
2105: (p_severity => c_log_level_2,
2106: p_module => v_block||'.p_fetch_limit{607}',
2107: p_msg_text => p_fetch_limit);
2108:
2146: FROM fem_mp_process_args_t
2147: WHERE req_id = p_req_id;
2148: END IF;
2149:
2150: FEM_ENGINES_PKG.TECH_MESSAGE
2151: (p_severity => c_log_level_2,
2152: p_module => v_block||'.v_rule_id{611}',
2153: p_msg_text => v_rule_id);
2154: FEM_ENGINES_PKG.TECH_MESSAGE
2150: FEM_ENGINES_PKG.TECH_MESSAGE
2151: (p_severity => c_log_level_2,
2152: p_module => v_block||'.v_rule_id{611}',
2153: p_msg_text => v_rule_id);
2154: FEM_ENGINES_PKG.TECH_MESSAGE
2155: (p_severity => c_log_level_2,
2156: p_module => v_block||'.v_eng_prg{612}',
2157: p_msg_text => v_eng_prg);
2158: FEM_ENGINES_PKG.TECH_MESSAGE
2154: FEM_ENGINES_PKG.TECH_MESSAGE
2155: (p_severity => c_log_level_2,
2156: p_module => v_block||'.v_eng_prg{612}',
2157: p_msg_text => v_eng_prg);
2158: FEM_ENGINES_PKG.TECH_MESSAGE
2159: (p_severity => c_log_level_1,
2160: p_module => v_block||'.v_eng_sql_param{613}',
2161: p_msg_text => v_eng_sql_param);
2162: FEM_ENGINES_PKG.TECH_MESSAGE
2158: FEM_ENGINES_PKG.TECH_MESSAGE
2159: (p_severity => c_log_level_1,
2160: p_module => v_block||'.v_eng_sql_param{613}',
2161: p_msg_text => v_eng_sql_param);
2162: FEM_ENGINES_PKG.TECH_MESSAGE
2163: (p_severity => c_log_level_2,
2164: p_module => v_block||'.v_slc_pred{614}',
2165: p_msg_text => v_slc_pred);
2166: FEM_ENGINES_PKG.TECH_MESSAGE
2162: FEM_ENGINES_PKG.TECH_MESSAGE
2163: (p_severity => c_log_level_2,
2164: p_module => v_block||'.v_slc_pred{614}',
2165: p_msg_text => v_slc_pred);
2166: FEM_ENGINES_PKG.TECH_MESSAGE
2167: (p_severity => c_log_level_2,
2168: p_module => v_block||'.v_args_count{615}',
2169: p_msg_text => v_args_count);
2170:
2169: p_msg_text => v_args_count);
2170:
2171: IF (p_mp_method <> 1)
2172: THEN
2173: FEM_ENGINES_PKG.TECH_MESSAGE
2174: (p_severity => c_log_level_2,
2175: p_module => v_block||'.t_arg_1{616.1}',
2176: p_msg_text => t_arg(1));
2177: FEM_ENGINES_PKG.TECH_MESSAGE
2173: FEM_ENGINES_PKG.TECH_MESSAGE
2174: (p_severity => c_log_level_2,
2175: p_module => v_block||'.t_arg_1{616.1}',
2176: p_msg_text => t_arg(1));
2177: FEM_ENGINES_PKG.TECH_MESSAGE
2178: (p_severity => c_log_level_2,
2179: p_module => v_block||'.t_arg_1{616.2}',
2180: p_msg_text => t_arg(2));
2181: FEM_ENGINES_PKG.TECH_MESSAGE
2177: FEM_ENGINES_PKG.TECH_MESSAGE
2178: (p_severity => c_log_level_2,
2179: p_module => v_block||'.t_arg_1{616.2}',
2180: p_msg_text => t_arg(2));
2181: FEM_ENGINES_PKG.TECH_MESSAGE
2182: (p_severity => c_log_level_2,
2183: p_module => v_block||'.t_arg_1{616.3}',
2184: p_msg_text => t_arg(3));
2185: FEM_ENGINES_PKG.TECH_MESSAGE
2181: FEM_ENGINES_PKG.TECH_MESSAGE
2182: (p_severity => c_log_level_2,
2183: p_module => v_block||'.t_arg_1{616.3}',
2184: p_msg_text => t_arg(3));
2185: FEM_ENGINES_PKG.TECH_MESSAGE
2186: (p_severity => c_log_level_2,
2187: p_module => v_block||'.t_arg_1{616.4}',
2188: p_msg_text => t_arg(4));
2189: FEM_ENGINES_PKG.TECH_MESSAGE
2185: FEM_ENGINES_PKG.TECH_MESSAGE
2186: (p_severity => c_log_level_2,
2187: p_module => v_block||'.t_arg_1{616.4}',
2188: p_msg_text => t_arg(4));
2189: FEM_ENGINES_PKG.TECH_MESSAGE
2190: (p_severity => c_log_level_2,
2191: p_module => v_block||'.t_arg_1{616.5}',
2192: p_msg_text => t_arg(5));
2193: FEM_ENGINES_PKG.TECH_MESSAGE
2189: FEM_ENGINES_PKG.TECH_MESSAGE
2190: (p_severity => c_log_level_2,
2191: p_module => v_block||'.t_arg_1{616.5}',
2192: p_msg_text => t_arg(5));
2193: FEM_ENGINES_PKG.TECH_MESSAGE
2194: (p_severity => c_log_level_2,
2195: p_module => v_block||'.t_arg_1{616.6}',
2196: p_msg_text => t_arg(6));
2197: FEM_ENGINES_PKG.TECH_MESSAGE
2193: FEM_ENGINES_PKG.TECH_MESSAGE
2194: (p_severity => c_log_level_2,
2195: p_module => v_block||'.t_arg_1{616.6}',
2196: p_msg_text => t_arg(6));
2197: FEM_ENGINES_PKG.TECH_MESSAGE
2198: (p_severity => c_log_level_2,
2199: p_module => v_block||'.t_arg_1{616.7}',
2200: p_msg_text => t_arg(7));
2201: FEM_ENGINES_PKG.TECH_MESSAGE
2197: FEM_ENGINES_PKG.TECH_MESSAGE
2198: (p_severity => c_log_level_2,
2199: p_module => v_block||'.t_arg_1{616.7}',
2200: p_msg_text => t_arg(7));
2201: FEM_ENGINES_PKG.TECH_MESSAGE
2202: (p_severity => c_log_level_2,
2203: p_module => v_block||'.t_arg_1{616.8}',
2204: p_msg_text => t_arg(8));
2205: FEM_ENGINES_PKG.TECH_MESSAGE
2201: FEM_ENGINES_PKG.TECH_MESSAGE
2202: (p_severity => c_log_level_2,
2203: p_module => v_block||'.t_arg_1{616.8}',
2204: p_msg_text => t_arg(8));
2205: FEM_ENGINES_PKG.TECH_MESSAGE
2206: (p_severity => c_log_level_2,
2207: p_module => v_block||'.t_arg_1{616.9}',
2208: p_msg_text => t_arg(9));
2209: FEM_ENGINES_PKG.TECH_MESSAGE
2205: FEM_ENGINES_PKG.TECH_MESSAGE
2206: (p_severity => c_log_level_2,
2207: p_module => v_block||'.t_arg_1{616.9}',
2208: p_msg_text => t_arg(9));
2209: FEM_ENGINES_PKG.TECH_MESSAGE
2210: (p_severity => c_log_level_2,
2211: p_module => v_block||'.t_arg_1{616.10}',
2212: p_msg_text => t_arg(10));
2213: FEM_ENGINES_PKG.TECH_MESSAGE
2209: FEM_ENGINES_PKG.TECH_MESSAGE
2210: (p_severity => c_log_level_2,
2211: p_module => v_block||'.t_arg_1{616.10}',
2212: p_msg_text => t_arg(10));
2213: FEM_ENGINES_PKG.TECH_MESSAGE
2214: (p_severity => c_log_level_2,
2215: p_module => v_block||'.t_arg_1{616.11}',
2216: p_msg_text => t_arg(11));
2217: FEM_ENGINES_PKG.TECH_MESSAGE
2213: FEM_ENGINES_PKG.TECH_MESSAGE
2214: (p_severity => c_log_level_2,
2215: p_module => v_block||'.t_arg_1{616.11}',
2216: p_msg_text => t_arg(11));
2217: FEM_ENGINES_PKG.TECH_MESSAGE
2218: (p_severity => c_log_level_2,
2219: p_module => v_block||'.t_arg_1{616.12}',
2220: p_msg_text => t_arg(12));
2221: FEM_ENGINES_PKG.TECH_MESSAGE
2217: FEM_ENGINES_PKG.TECH_MESSAGE
2218: (p_severity => c_log_level_2,
2219: p_module => v_block||'.t_arg_1{616.12}',
2220: p_msg_text => t_arg(12));
2221: FEM_ENGINES_PKG.TECH_MESSAGE
2222: (p_severity => c_log_level_2,
2223: p_module => v_block||'.t_arg_1{616.13}',
2224: p_msg_text => t_arg(13));
2225: FEM_ENGINES_PKG.TECH_MESSAGE
2221: FEM_ENGINES_PKG.TECH_MESSAGE
2222: (p_severity => c_log_level_2,
2223: p_module => v_block||'.t_arg_1{616.13}',
2224: p_msg_text => t_arg(13));
2225: FEM_ENGINES_PKG.TECH_MESSAGE
2226: (p_severity => c_log_level_2,
2227: p_module => v_block||'.t_arg_1{616.14}',
2228: p_msg_text => t_arg(14));
2229: FEM_ENGINES_PKG.TECH_MESSAGE
2225: FEM_ENGINES_PKG.TECH_MESSAGE
2226: (p_severity => c_log_level_2,
2227: p_module => v_block||'.t_arg_1{616.14}',
2228: p_msg_text => t_arg(14));
2229: FEM_ENGINES_PKG.TECH_MESSAGE
2230: (p_severity => c_log_level_2,
2231: p_module => v_block||'.t_arg_1{616.15}',
2232: p_msg_text => t_arg(15));
2233: FEM_ENGINES_PKG.TECH_MESSAGE
2229: FEM_ENGINES_PKG.TECH_MESSAGE
2230: (p_severity => c_log_level_2,
2231: p_module => v_block||'.t_arg_1{616.15}',
2232: p_msg_text => t_arg(15));
2233: FEM_ENGINES_PKG.TECH_MESSAGE
2234: (p_severity => c_log_level_2,
2235: p_module => v_block||'.t_arg_1{616.16}',
2236: p_msg_text => t_arg(16));
2237: FEM_ENGINES_PKG.TECH_MESSAGE
2233: FEM_ENGINES_PKG.TECH_MESSAGE
2234: (p_severity => c_log_level_2,
2235: p_module => v_block||'.t_arg_1{616.16}',
2236: p_msg_text => t_arg(16));
2237: FEM_ENGINES_PKG.TECH_MESSAGE
2238: (p_severity => c_log_level_2,
2239: p_module => v_block||'.t_arg_1{616.17}',
2240: p_msg_text => t_arg(17));
2241: FEM_ENGINES_PKG.TECH_MESSAGE
2237: FEM_ENGINES_PKG.TECH_MESSAGE
2238: (p_severity => c_log_level_2,
2239: p_module => v_block||'.t_arg_1{616.17}',
2240: p_msg_text => t_arg(17));
2241: FEM_ENGINES_PKG.TECH_MESSAGE
2242: (p_severity => c_log_level_2,
2243: p_module => v_block||'.t_arg_1{616.18}',
2244: p_msg_text => t_arg(18));
2245: FEM_ENGINES_PKG.TECH_MESSAGE
2241: FEM_ENGINES_PKG.TECH_MESSAGE
2242: (p_severity => c_log_level_2,
2243: p_module => v_block||'.t_arg_1{616.18}',
2244: p_msg_text => t_arg(18));
2245: FEM_ENGINES_PKG.TECH_MESSAGE
2246: (p_severity => c_log_level_2,
2247: p_module => v_block||'.t_arg_1{616.19}',
2248: p_msg_text => t_arg(19));
2249: FEM_ENGINES_PKG.TECH_MESSAGE
2245: FEM_ENGINES_PKG.TECH_MESSAGE
2246: (p_severity => c_log_level_2,
2247: p_module => v_block||'.t_arg_1{616.19}',
2248: p_msg_text => t_arg(19));
2249: FEM_ENGINES_PKG.TECH_MESSAGE
2250: (p_severity => c_log_level_2,
2251: p_module => v_block||'.t_arg_1{616.20}',
2252: p_msg_text => t_arg(20));
2253: FEM_ENGINES_PKG.TECH_MESSAGE
2249: FEM_ENGINES_PKG.TECH_MESSAGE
2250: (p_severity => c_log_level_2,
2251: p_module => v_block||'.t_arg_1{616.20}',
2252: p_msg_text => t_arg(20));
2253: FEM_ENGINES_PKG.TECH_MESSAGE
2254: (p_severity => c_log_level_2,
2255: p_module => v_block||'.t_arg_1{616.21}',
2256: p_msg_text => t_arg(21));
2257: FEM_ENGINES_PKG.TECH_MESSAGE
2253: FEM_ENGINES_PKG.TECH_MESSAGE
2254: (p_severity => c_log_level_2,
2255: p_module => v_block||'.t_arg_1{616.21}',
2256: p_msg_text => t_arg(21));
2257: FEM_ENGINES_PKG.TECH_MESSAGE
2258: (p_severity => c_log_level_2,
2259: p_module => v_block||'.t_arg_1{616.22}',
2260: p_msg_text => t_arg(22));
2261: FEM_ENGINES_PKG.TECH_MESSAGE
2257: FEM_ENGINES_PKG.TECH_MESSAGE
2258: (p_severity => c_log_level_2,
2259: p_module => v_block||'.t_arg_1{616.22}',
2260: p_msg_text => t_arg(22));
2261: FEM_ENGINES_PKG.TECH_MESSAGE
2262: (p_severity => c_log_level_2,
2263: p_module => v_block||'.t_arg_1{616.23}',
2264: p_msg_text => t_arg(23));
2265: FEM_ENGINES_PKG.TECH_MESSAGE
2261: FEM_ENGINES_PKG.TECH_MESSAGE
2262: (p_severity => c_log_level_2,
2263: p_module => v_block||'.t_arg_1{616.23}',
2264: p_msg_text => t_arg(23));
2265: FEM_ENGINES_PKG.TECH_MESSAGE
2266: (p_severity => c_log_level_2,
2267: p_module => v_block||'.t_arg_1{616.24}',
2268: p_msg_text => t_arg(24));
2269: FEM_ENGINES_PKG.TECH_MESSAGE
2265: FEM_ENGINES_PKG.TECH_MESSAGE
2266: (p_severity => c_log_level_2,
2267: p_module => v_block||'.t_arg_1{616.24}',
2268: p_msg_text => t_arg(24));
2269: FEM_ENGINES_PKG.TECH_MESSAGE
2270: (p_severity => c_log_level_2,
2271: p_module => v_block||'.t_arg_1{616.25}',
2272: p_msg_text => t_arg(25));
2273: FEM_ENGINES_PKG.TECH_MESSAGE
2269: FEM_ENGINES_PKG.TECH_MESSAGE
2270: (p_severity => c_log_level_2,
2271: p_module => v_block||'.t_arg_1{616.25}',
2272: p_msg_text => t_arg(25));
2273: FEM_ENGINES_PKG.TECH_MESSAGE
2274: (p_severity => c_log_level_2,
2275: p_module => v_block||'.t_arg_1{616.26}',
2276: p_msg_text => t_arg(26));
2277: FEM_ENGINES_PKG.TECH_MESSAGE
2273: FEM_ENGINES_PKG.TECH_MESSAGE
2274: (p_severity => c_log_level_2,
2275: p_module => v_block||'.t_arg_1{616.26}',
2276: p_msg_text => t_arg(26));
2277: FEM_ENGINES_PKG.TECH_MESSAGE
2278: (p_severity => c_log_level_2,
2279: p_module => v_block||'.t_arg_1{616.27}',
2280: p_msg_text => t_arg(27));
2281: FEM_ENGINES_PKG.TECH_MESSAGE
2277: FEM_ENGINES_PKG.TECH_MESSAGE
2278: (p_severity => c_log_level_2,
2279: p_module => v_block||'.t_arg_1{616.27}',
2280: p_msg_text => t_arg(27));
2281: FEM_ENGINES_PKG.TECH_MESSAGE
2282: (p_severity => c_log_level_2,
2283: p_module => v_block||'.t_arg_1{616.28}',
2284: p_msg_text => t_arg(28));
2285: FEM_ENGINES_PKG.TECH_MESSAGE
2281: FEM_ENGINES_PKG.TECH_MESSAGE
2282: (p_severity => c_log_level_2,
2283: p_module => v_block||'.t_arg_1{616.28}',
2284: p_msg_text => t_arg(28));
2285: FEM_ENGINES_PKG.TECH_MESSAGE
2286: (p_severity => c_log_level_2,
2287: p_module => v_block||'.t_arg_1{616.29}',
2288: p_msg_text => t_arg(29));
2289: FEM_ENGINES_PKG.TECH_MESSAGE
2285: FEM_ENGINES_PKG.TECH_MESSAGE
2286: (p_severity => c_log_level_2,
2287: p_module => v_block||'.t_arg_1{616.29}',
2288: p_msg_text => t_arg(29));
2289: FEM_ENGINES_PKG.TECH_MESSAGE
2290: (p_severity => c_log_level_2,
2291: p_module => v_block||'.t_arg_1{616.30}',
2292: p_msg_text => t_arg(30));
2293: FEM_ENGINES_PKG.TECH_MESSAGE
2289: FEM_ENGINES_PKG.TECH_MESSAGE
2290: (p_severity => c_log_level_2,
2291: p_module => v_block||'.t_arg_1{616.30}',
2292: p_msg_text => t_arg(30));
2293: FEM_ENGINES_PKG.TECH_MESSAGE
2294: (p_severity => c_log_level_2,
2295: p_module => v_block||'.t_arg_1{616.31}',
2296: p_msg_text => t_arg(31));
2297: FEM_ENGINES_PKG.TECH_MESSAGE
2293: FEM_ENGINES_PKG.TECH_MESSAGE
2294: (p_severity => c_log_level_2,
2295: p_module => v_block||'.t_arg_1{616.31}',
2296: p_msg_text => t_arg(31));
2297: FEM_ENGINES_PKG.TECH_MESSAGE
2298: (p_severity => c_log_level_2,
2299: p_module => v_block||'.t_arg_1{616.32}',
2300: p_msg_text => t_arg(32));
2301: FEM_ENGINES_PKG.TECH_MESSAGE
2297: FEM_ENGINES_PKG.TECH_MESSAGE
2298: (p_severity => c_log_level_2,
2299: p_module => v_block||'.t_arg_1{616.32}',
2300: p_msg_text => t_arg(32));
2301: FEM_ENGINES_PKG.TECH_MESSAGE
2302: (p_severity => c_log_level_2,
2303: p_module => v_block||'.t_arg_1{616.33}',
2304: p_msg_text => t_arg(33));
2305: FEM_ENGINES_PKG.TECH_MESSAGE
2301: FEM_ENGINES_PKG.TECH_MESSAGE
2302: (p_severity => c_log_level_2,
2303: p_module => v_block||'.t_arg_1{616.33}',
2304: p_msg_text => t_arg(33));
2305: FEM_ENGINES_PKG.TECH_MESSAGE
2306: (p_severity => c_log_level_2,
2307: p_module => v_block||'.t_arg_1{616.34}',
2308: p_msg_text => t_arg(34));
2309: FEM_ENGINES_PKG.TECH_MESSAGE
2305: FEM_ENGINES_PKG.TECH_MESSAGE
2306: (p_severity => c_log_level_2,
2307: p_module => v_block||'.t_arg_1{616.34}',
2308: p_msg_text => t_arg(34));
2309: FEM_ENGINES_PKG.TECH_MESSAGE
2310: (p_severity => c_log_level_2,
2311: p_module => v_block||'.t_arg_1{616.35}',
2312: p_msg_text => t_arg(35));
2313: FEM_ENGINES_PKG.TECH_MESSAGE
2309: FEM_ENGINES_PKG.TECH_MESSAGE
2310: (p_severity => c_log_level_2,
2311: p_module => v_block||'.t_arg_1{616.35}',
2312: p_msg_text => t_arg(35));
2313: FEM_ENGINES_PKG.TECH_MESSAGE
2314: (p_severity => c_log_level_2,
2315: p_module => v_block||'.t_arg_1{616.36}',
2316: p_msg_text => t_arg(36));
2317: FEM_ENGINES_PKG.TECH_MESSAGE
2313: FEM_ENGINES_PKG.TECH_MESSAGE
2314: (p_severity => c_log_level_2,
2315: p_module => v_block||'.t_arg_1{616.36}',
2316: p_msg_text => t_arg(36));
2317: FEM_ENGINES_PKG.TECH_MESSAGE
2318: (p_severity => c_log_level_2,
2319: p_module => v_block||'.t_arg_1{616.37}',
2320: p_msg_text => t_arg(37));
2321: FEM_ENGINES_PKG.TECH_MESSAGE
2317: FEM_ENGINES_PKG.TECH_MESSAGE
2318: (p_severity => c_log_level_2,
2319: p_module => v_block||'.t_arg_1{616.37}',
2320: p_msg_text => t_arg(37));
2321: FEM_ENGINES_PKG.TECH_MESSAGE
2322: (p_severity => c_log_level_2,
2323: p_module => v_block||'.t_arg_1{616.38}',
2324: p_msg_text => t_arg(38));
2325: FEM_ENGINES_PKG.TECH_MESSAGE
2321: FEM_ENGINES_PKG.TECH_MESSAGE
2322: (p_severity => c_log_level_2,
2323: p_module => v_block||'.t_arg_1{616.38}',
2324: p_msg_text => t_arg(38));
2325: FEM_ENGINES_PKG.TECH_MESSAGE
2326: (p_severity => c_log_level_2,
2327: p_module => v_block||'.t_arg_1{616.39}',
2328: p_msg_text => t_arg(39));
2329: FEM_ENGINES_PKG.TECH_MESSAGE
2325: FEM_ENGINES_PKG.TECH_MESSAGE
2326: (p_severity => c_log_level_2,
2327: p_module => v_block||'.t_arg_1{616.39}',
2328: p_msg_text => t_arg(39));
2329: FEM_ENGINES_PKG.TECH_MESSAGE
2330: (p_severity => c_log_level_2,
2331: p_module => v_block||'.t_arg_1{616.40}',
2332: p_msg_text => t_arg(40));
2333: END IF;
2339: Bind Processing
2340:
2341: ----------------------------------------------------------------------*/
2342:
2343: FEM_ENGINES_PKG.TECH_MESSAGE
2344: (p_severity => c_log_level_2,
2345: p_module => v_block||'.Process Method{620}',
2346: p_msg_text => 'Preparing for Bind Processing');
2347:
2346: p_msg_text => 'Preparing for Bind Processing');
2347:
2348: v_eng_sql := v_eng_sql_param;
2349:
2350: FEM_ENGINES_PKG.TECH_MESSAGE
2351: (p_severity => c_log_level_2,
2352: p_module => v_block||'.v_eng_sql{616}',
2353: p_msg_text => v_eng_sql);
2354:
2365: THEN
2366: v_eng_call := v_eng_call||');'||
2367: ' END;';
2368:
2369: FEM_ENGINES_PKG.TECH_MESSAGE
2370: (p_severity => c_log_level_1,
2371: p_module => v_block||'.v_eng_call{620.0}',
2372: p_msg_text => v_eng_call);
2373:
2379: v_eng_call := v_eng_call||','||
2380: ' :b_arg1);'||
2381: ' END;';
2382:
2383: FEM_ENGINES_PKG.TECH_MESSAGE
2384: (p_severity => c_log_level_1,
2385: p_module => v_block||'.v_eng_call{620.1}',
2386: p_msg_text => v_eng_call);
2387:
2394: v_eng_call := v_eng_call||','||
2395: ' :b_arg1, :b_arg2);'||
2396: ' END;';
2397:
2398: FEM_ENGINES_PKG.TECH_MESSAGE
2399: (p_severity => c_log_level_1,
2400: p_module => v_block||'.v_eng_call{620.2}',
2401: p_msg_text => v_eng_call);
2402:
2409: v_eng_call := v_eng_call||','||
2410: ' :b_arg1, :b_arg2, :b_arg3);'||
2411: ' END;';
2412:
2413: FEM_ENGINES_PKG.TECH_MESSAGE
2414: (p_severity => c_log_level_1,
2415: p_module => v_block||'.v_eng_call{620.3}',
2416: p_msg_text => v_eng_call);
2417:
2424: v_eng_call := v_eng_call||','||
2425: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4);'||
2426: ' END;';
2427:
2428: FEM_ENGINES_PKG.TECH_MESSAGE
2429: (p_severity => c_log_level_1,
2430: p_module => v_block||'.v_eng_call{620.4}',
2431: p_msg_text => v_eng_call);
2432:
2440: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
2441: ' :b_arg5);'||
2442: ' END;';
2443:
2444: FEM_ENGINES_PKG.TECH_MESSAGE
2445: (p_severity => c_log_level_1,
2446: p_module => v_block||'.v_eng_call{620.5}',
2447: p_msg_text => v_eng_call);
2448:
2457: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
2458: ' :b_arg5, :b_arg6);'||
2459: ' END;';
2460:
2461: FEM_ENGINES_PKG.TECH_MESSAGE
2462: (p_severity => c_log_level_1,
2463: p_module => v_block||'.v_eng_call{620.6}',
2464: p_msg_text => v_eng_call);
2465:
2474: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
2475: ' :b_arg5, :b_arg6, :b_arg7);'||
2476: ' END;';
2477:
2478: FEM_ENGINES_PKG.TECH_MESSAGE
2479: (p_severity => c_log_level_1,
2480: p_module => v_block||'.v_eng_call{620.7}',
2481: p_msg_text => v_eng_call);
2482:
2491: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
2492: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8);'||
2493: ' END;';
2494:
2495: FEM_ENGINES_PKG.TECH_MESSAGE
2496: (p_severity => c_log_level_1,
2497: p_module => v_block||'.v_eng_call{620.8}',
2498: p_msg_text => v_eng_call);
2499:
2509: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
2510: ' :b_arg9);'||
2511: ' END;';
2512:
2513: FEM_ENGINES_PKG.TECH_MESSAGE
2514: (p_severity => c_log_level_1,
2515: p_module => v_block||'.v_eng_call{620.9}',
2516: p_msg_text => v_eng_call);
2517:
2528: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
2529: ' :b_arg9, :b_arg10);'||
2530: ' END;';
2531:
2532: FEM_ENGINES_PKG.TECH_MESSAGE
2533: (p_severity => c_log_level_1,
2534: p_module => v_block||'.v_eng_call{620.10}',
2535: p_msg_text => v_eng_call);
2536:
2547: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
2548: ' :b_arg9, :b_arg10,:b_arg11);'||
2549: ' END;';
2550:
2551: FEM_ENGINES_PKG.TECH_MESSAGE
2552: (p_severity => c_log_level_1,
2553: p_module => v_block||'.v_eng_call{620.11}',
2554: p_msg_text => v_eng_call);
2555:
2566: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
2567: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12);'||
2568: ' END;';
2569:
2570: FEM_ENGINES_PKG.TECH_MESSAGE
2571: (p_severity => c_log_level_1,
2572: p_module => v_block||'.v_eng_call{620.12}',
2573: p_msg_text => v_eng_call);
2574:
2586: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
2587: ' :b_arg13);'||
2588: ' END;';
2589:
2590: FEM_ENGINES_PKG.TECH_MESSAGE
2591: (p_severity => c_log_level_1,
2592: p_module => v_block||'.v_eng_call{620.13}',
2593: p_msg_text => v_eng_call);
2594:
2607: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
2608: ' :b_arg13,:b_arg14);'||
2609: ' END;';
2610:
2611: FEM_ENGINES_PKG.TECH_MESSAGE
2612: (p_severity => c_log_level_1,
2613: p_module => v_block||'.v_eng_call{620.14}',
2614: p_msg_text => v_eng_call);
2615:
2628: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
2629: ' :b_arg13,:b_arg14,:b_arg15);'||
2630: ' END;';
2631:
2632: FEM_ENGINES_PKG.TECH_MESSAGE
2633: (p_severity => c_log_level_1,
2634: p_module => v_block||'.v_eng_call{620.15}',
2635: p_msg_text => v_eng_call);
2636:
2649: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
2650: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16);'||
2651: ' END;';
2652:
2653: FEM_ENGINES_PKG.TECH_MESSAGE
2654: (p_severity => c_log_level_1,
2655: p_module => v_block||'.v_eng_call{620.16}',
2656: p_msg_text => v_eng_call);
2657:
2671: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
2672: ' :b_arg17);'||
2673: ' END;';
2674:
2675: FEM_ENGINES_PKG.TECH_MESSAGE
2676: (p_severity => c_log_level_1,
2677: p_module => v_block||'.v_eng_call{620.17}',
2678: p_msg_text => v_eng_call);
2679:
2694: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
2695: ' :b_arg17,:b_arg18);'||
2696: ' END;';
2697:
2698: FEM_ENGINES_PKG.TECH_MESSAGE
2699: (p_severity => c_log_level_1,
2700: p_module => v_block||'.v_eng_call{620.18}',
2701: p_msg_text => v_eng_call);
2702:
2717: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
2718: ' :b_arg17,:b_arg18,:b_arg19);'||
2719: ' END;';
2720:
2721: FEM_ENGINES_PKG.TECH_MESSAGE
2722: (p_severity => c_log_level_1,
2723: p_module => v_block||'.v_eng_call{620.19}',
2724: p_msg_text => v_eng_call);
2725:
2740: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
2741: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20);'||
2742: ' END;';
2743:
2744: FEM_ENGINES_PKG.TECH_MESSAGE
2745: (p_severity => c_log_level_1,
2746: p_module => v_block||'.v_eng_call{620.20}',
2747: p_msg_text => v_eng_call);
2748:
2764: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
2765: ' :b_arg21);'||
2766: ' END;';
2767:
2768: FEM_ENGINES_PKG.TECH_MESSAGE
2769: (p_severity => c_log_level_1,
2770: p_module => v_block||'.v_eng_call{620.21}',
2771: p_msg_text => v_eng_call);
2772:
2789: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
2790: ' :b_arg21,:b_arg22);'||
2791: ' END;';
2792:
2793: FEM_ENGINES_PKG.TECH_MESSAGE
2794: (p_severity => c_log_level_1,
2795: p_module => v_block||'.v_eng_call{620.22}',
2796: p_msg_text => v_eng_call);
2797:
2814: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
2815: ' :b_arg21,:b_arg22,:b_arg23);'||
2816: ' END;';
2817:
2818: FEM_ENGINES_PKG.TECH_MESSAGE
2819: (p_severity => c_log_level_1,
2820: p_module => v_block||'.v_eng_call{620.23}',
2821: p_msg_text => v_eng_call);
2822:
2839: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
2840: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24);'||
2841: ' END;';
2842:
2843: FEM_ENGINES_PKG.TECH_MESSAGE
2844: (p_severity => c_log_level_1,
2845: p_module => v_block||'.v_eng_call{620.24}',
2846: p_msg_text => v_eng_call);
2847:
2865: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
2866: ' :b_arg25);'||
2867: ' END;';
2868:
2869: FEM_ENGINES_PKG.TECH_MESSAGE
2870: (p_severity => c_log_level_1,
2871: p_module => v_block||'.v_eng_call{620.25}',
2872: p_msg_text => v_eng_call);
2873:
2892: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
2893: ' :b_arg25,:b_arg26);'||
2894: ' END;';
2895:
2896: FEM_ENGINES_PKG.TECH_MESSAGE
2897: (p_severity => c_log_level_1,
2898: p_module => v_block||'.v_eng_call{620.26}',
2899: p_msg_text => v_eng_call);
2900:
2919: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
2920: ' :b_arg25,:b_arg26,:b_arg27);'||
2921: ' END;';
2922:
2923: FEM_ENGINES_PKG.TECH_MESSAGE
2924: (p_severity => c_log_level_1,
2925: p_module => v_block||'.v_eng_call{620.27}',
2926: p_msg_text => v_eng_call);
2927:
2946: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
2947: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28);'||
2948: ' END;';
2949:
2950: FEM_ENGINES_PKG.TECH_MESSAGE
2951: (p_severity => c_log_level_1,
2952: p_module => v_block||'.v_eng_call{620.28}',
2953: p_msg_text => v_eng_call);
2954:
2974: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
2975: ' :b_arg29);'||
2976: ' END;';
2977:
2978: FEM_ENGINES_PKG.TECH_MESSAGE
2979: (p_severity => c_log_level_1,
2980: p_module => v_block||'.v_eng_call{620.29}',
2981: p_msg_text => v_eng_call);
2982:
3003: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
3004: ' :b_arg29,:b_arg30);'||
3005: ' END;';
3006:
3007: FEM_ENGINES_PKG.TECH_MESSAGE
3008: (p_severity => c_log_level_1,
3009: p_module => v_block||'.v_eng_call{620.30}',
3010: p_msg_text => v_eng_call);
3011:
3032: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
3033: ' :b_arg29,:b_arg30,:b_arg31);'||
3034: ' END;';
3035:
3036: FEM_ENGINES_PKG.TECH_MESSAGE
3037: (p_severity => c_log_level_1,
3038: p_module => v_block||'.v_eng_call{620.31}',
3039: p_msg_text => v_eng_call);
3040:
3061: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
3062: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32);'||
3063: ' END;';
3064:
3065: FEM_ENGINES_PKG.TECH_MESSAGE
3066: (p_severity => c_log_level_1,
3067: p_module => v_block||'.v_eng_call{620.32}',
3068: p_msg_text => v_eng_call);
3069:
3091: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
3092: ' :b_arg33);'||
3093: ' END;';
3094:
3095: FEM_ENGINES_PKG.TECH_MESSAGE
3096: (p_severity => c_log_level_1,
3097: p_module => v_block||'.v_eng_call{620.33}',
3098: p_msg_text => v_eng_call);
3099:
3122: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
3123: ' :b_arg33,:b_arg34);'||
3124: ' END;';
3125:
3126: FEM_ENGINES_PKG.TECH_MESSAGE
3127: (p_severity => c_log_level_1,
3128: p_module => v_block||'.v_eng_call{620.34}',
3129: p_msg_text => v_eng_call);
3130:
3153: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
3154: ' :b_arg33,:b_arg34,:b_arg35);'||
3155: ' END;';
3156:
3157: FEM_ENGINES_PKG.TECH_MESSAGE
3158: (p_severity => c_log_level_1,
3159: p_module => v_block||'.v_eng_call{620.35}',
3160: p_msg_text => v_eng_call);
3161:
3184: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
3185: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36);'||
3186: ' END;';
3187:
3188: FEM_ENGINES_PKG.TECH_MESSAGE
3189: (p_severity => c_log_level_1,
3190: p_module => v_block||'.v_eng_call{620.36}',
3191: p_msg_text => v_eng_call);
3192:
3216: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
3217: ' :b_arg37);'||
3218: ' END;';
3219:
3220: FEM_ENGINES_PKG.TECH_MESSAGE
3221: (p_severity => c_log_level_1,
3222: p_module => v_block||'.v_eng_call{620.37}',
3223: p_msg_text => v_eng_call);
3224:
3249: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
3250: ' :b_arg37,:b_arg38);'||
3251: ' END;';
3252:
3253: FEM_ENGINES_PKG.TECH_MESSAGE
3254: (p_severity => c_log_level_1,
3255: p_module => v_block||'.v_eng_call{620.38}',
3256: p_msg_text => v_eng_call);
3257:
3282: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
3283: ' :b_arg37,:b_arg38,:b_arg39);'||
3284: ' END;';
3285:
3286: FEM_ENGINES_PKG.TECH_MESSAGE
3287: (p_severity => c_log_level_1,
3288: p_module => v_block||'.v_eng_call{620.39}',
3289: p_msg_text => v_eng_call);
3290:
3315: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
3316: ' :b_arg37,:b_arg38,:b_arg39,:b_arg40);'||
3317: ' END;';
3318:
3319: FEM_ENGINES_PKG.TECH_MESSAGE
3320: (p_severity => c_log_level_1,
3321: p_module => v_block||'.v_eng_call{620.40}',
3322: p_msg_text => v_eng_call);
3323:
3347: LOOP
3348:
3349: IF (p_mp_method = 0)
3350: THEN
3351: FEM_ENGINES_PKG.TECH_MESSAGE
3352: (p_severity => c_log_level_2,
3353: p_module => v_block||'.Process Method{630}',
3354: p_msg_text => 'Preparing for Push Processing');
3355: ELSE
3352: (p_severity => c_log_level_2,
3353: p_module => v_block||'.Process Method{630}',
3354: p_msg_text => 'Preparing for Push Processing');
3355: ELSE
3356: FEM_ENGINES_PKG.TECH_MESSAGE
3357: (p_severity => c_log_level_2,
3358: p_module => v_block||'.Process Method{630}',
3359: p_msg_text => 'Preparing for Pull Processing');
3360: END IF;
3372: x_part_name => v_part_name,
3373: p_req_id => p_req_id,
3374: p_proc_num => p_proc_num);
3375:
3376: FEM_ENGINES_PKG.TECH_MESSAGE
3377: (p_severity => c_log_level_2,
3378: p_module => v_block||'.v_slc_id{631}',
3379: p_msg_text => v_slc_id);
3380: FEM_ENGINES_PKG.TECH_MESSAGE
3376: FEM_ENGINES_PKG.TECH_MESSAGE
3377: (p_severity => c_log_level_2,
3378: p_module => v_block||'.v_slc_id{631}',
3379: p_msg_text => v_slc_id);
3380: FEM_ENGINES_PKG.TECH_MESSAGE
3381: (p_severity => c_log_level_2,
3382: p_module => v_block||'.v_num_vals{632}',
3383: p_msg_text => v_num_vals);
3384: FEM_ENGINES_PKG.TECH_MESSAGE
3380: FEM_ENGINES_PKG.TECH_MESSAGE
3381: (p_severity => c_log_level_2,
3382: p_module => v_block||'.v_num_vals{632}',
3383: p_msg_text => v_num_vals);
3384: FEM_ENGINES_PKG.TECH_MESSAGE
3385: (p_severity => c_log_level_2,
3386: p_module => v_block||'.v_slc_val1{632.1}',
3387: p_msg_text => v_slc_val1);
3388: FEM_ENGINES_PKG.TECH_MESSAGE
3384: FEM_ENGINES_PKG.TECH_MESSAGE
3385: (p_severity => c_log_level_2,
3386: p_module => v_block||'.v_slc_val1{632.1}',
3387: p_msg_text => v_slc_val1);
3388: FEM_ENGINES_PKG.TECH_MESSAGE
3389: (p_severity => c_log_level_2,
3390: p_module => v_block||'.v_slc_val2{632.2}',
3391: p_msg_text => v_slc_val2);
3392: FEM_ENGINES_PKG.TECH_MESSAGE
3388: FEM_ENGINES_PKG.TECH_MESSAGE
3389: (p_severity => c_log_level_2,
3390: p_module => v_block||'.v_slc_val2{632.2}',
3391: p_msg_text => v_slc_val2);
3392: FEM_ENGINES_PKG.TECH_MESSAGE
3393: (p_severity => c_log_level_2,
3394: p_module => v_block||'.v_slc_val3{632.3}',
3395: p_msg_text => v_slc_val3);
3396: FEM_ENGINES_PKG.TECH_MESSAGE
3392: FEM_ENGINES_PKG.TECH_MESSAGE
3393: (p_severity => c_log_level_2,
3394: p_module => v_block||'.v_slc_val3{632.3}',
3395: p_msg_text => v_slc_val3);
3396: FEM_ENGINES_PKG.TECH_MESSAGE
3397: (p_severity => c_log_level_2,
3398: p_module => v_block||'.v_slc_val4{632.4}',
3399: p_msg_text => v_slc_val4);
3400:
3404:
3405: IF (v_num_vals > 0)
3406: THEN
3407:
3408: FEM_ENGINES_PKG.TECH_MESSAGE
3409: (p_severity => c_log_level_2,
3410: p_module => v_block2||'.v_part_name{633}',
3411: p_msg_text => v_part_name);
3412:
3417: v_eng_sql := REPLACE(v_eng_sql_param,'{{table_partition}}',
3418: ' PARTITION(' || v_part_name || ') ');
3419: END IF;
3420:
3421: FEM_ENGINES_PKG.TECH_MESSAGE
3422: (p_severity => c_log_level_2,
3423: p_module => v_block||'.v_eng_sql{634}',
3424: p_msg_text => v_eng_sql);
3425:
3434: ---------------------------------------------------------------------*/
3435:
3436: v_slc_pred1 := v_slc_pred;
3437:
3438: FEM_ENGINES_PKG.TECH_MESSAGE
3439: (p_severity => c_log_level_2,
3440: p_module => v_block2||'.v_slc_pred1{640}',
3441: p_msg_text => v_slc_pred1);
3442:
3476: ''''''||v_slc_val4||'''''');
3477: v_data_slc := v_slc_pred1;
3478: END IF;
3479:
3480: FEM_ENGINES_PKG.TECH_MESSAGE
3481: (p_severity => c_log_level_2,
3482: p_module => v_block2||'.v_data_slc{641}',
3483: p_msg_text => v_data_slc);
3484:
3517: THEN
3518: v_eng_call := v_eng_call||');'||
3519: v_upd_stmt;
3520:
3521: FEM_ENGINES_PKG.TECH_MESSAGE
3522: (p_severity => c_log_level_1,
3523: p_module => v_block2||'.v_eng_call{642.0}',
3524: p_msg_text => v_eng_call);
3525:
3532: v_eng_call := v_eng_call||','||
3533: ' :b_arg1);'||
3534: v_upd_stmt;
3535:
3536: FEM_ENGINES_PKG.TECH_MESSAGE
3537: (p_severity => c_log_level_1,
3538: p_module => v_block||'.v_eng_call{620.1}',
3539: p_msg_text => v_eng_call);
3540:
3548: v_eng_call := v_eng_call||','||
3549: ' :b_arg1, :b_arg2);'||
3550: v_upd_stmt;
3551:
3552: FEM_ENGINES_PKG.TECH_MESSAGE
3553: (p_severity => c_log_level_1,
3554: p_module => v_block||'.v_eng_call{620.2}',
3555: p_msg_text => v_eng_call);
3556:
3564: v_eng_call := v_eng_call||','||
3565: ' :b_arg1, :b_arg2, :b_arg3);'||
3566: v_upd_stmt;
3567:
3568: FEM_ENGINES_PKG.TECH_MESSAGE
3569: (p_severity => c_log_level_1,
3570: p_module => v_block||'.v_eng_call{620.3}',
3571: p_msg_text => v_eng_call);
3572:
3580: v_eng_call := v_eng_call||','||
3581: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4);'||
3582: v_upd_stmt;
3583:
3584: FEM_ENGINES_PKG.TECH_MESSAGE
3585: (p_severity => c_log_level_1,
3586: p_module => v_block||'.v_eng_call{620.4}',
3587: p_msg_text => v_eng_call);
3588:
3597: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
3598: ' :b_arg5);'||
3599: v_upd_stmt;
3600:
3601: FEM_ENGINES_PKG.TECH_MESSAGE
3602: (p_severity => c_log_level_1,
3603: p_module => v_block||'.v_eng_call{620.5}',
3604: p_msg_text => v_eng_call);
3605:
3615: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
3616: ' :b_arg5, :b_arg6);'||
3617: v_upd_stmt;
3618:
3619: FEM_ENGINES_PKG.TECH_MESSAGE
3620: (p_severity => c_log_level_1,
3621: p_module => v_block||'.v_eng_call{620.6}',
3622: p_msg_text => v_eng_call);
3623:
3633: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
3634: ' :b_arg5, :b_arg6, :b_arg7);'||
3635: v_upd_stmt;
3636:
3637: FEM_ENGINES_PKG.TECH_MESSAGE
3638: (p_severity => c_log_level_1,
3639: p_module => v_block||'.v_eng_call{620.7}',
3640: p_msg_text => v_eng_call);
3641:
3651: ' :b_arg1, :b_arg2, :b_arg3, :b_arg4,'||
3652: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8);'||
3653: v_upd_stmt;
3654:
3655: FEM_ENGINES_PKG.TECH_MESSAGE
3656: (p_severity => c_log_level_1,
3657: p_module => v_block||'.v_eng_call{620.8}',
3658: p_msg_text => v_eng_call);
3659:
3670: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
3671: ' :b_arg9);'||
3672: v_upd_stmt;
3673:
3674: FEM_ENGINES_PKG.TECH_MESSAGE
3675: (p_severity => c_log_level_1,
3676: p_module => v_block||'.v_eng_call{620.9}',
3677: p_msg_text => v_eng_call);
3678:
3690: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
3691: ' :b_arg9, :b_arg10);'||
3692: v_upd_stmt;
3693:
3694: FEM_ENGINES_PKG.TECH_MESSAGE
3695: (p_severity => c_log_level_1,
3696: p_module => v_block||'.v_eng_call{620.10}',
3697: p_msg_text => v_eng_call);
3698:
3710: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
3711: ' :b_arg9, :b_arg10,:b_arg11);'||
3712: v_upd_stmt;
3713:
3714: FEM_ENGINES_PKG.TECH_MESSAGE
3715: (p_severity => c_log_level_1,
3716: p_module => v_block||'.v_eng_call{620.11}',
3717: p_msg_text => v_eng_call);
3718:
3730: ' :b_arg5, :b_arg6, :b_arg7, :b_arg8,'||
3731: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12);'||
3732: v_upd_stmt;
3733:
3734: FEM_ENGINES_PKG.TECH_MESSAGE
3735: (p_severity => c_log_level_1,
3736: p_module => v_block||'.v_eng_call{620.12}',
3737: p_msg_text => v_eng_call);
3738:
3751: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
3752: ' :b_arg13);'||
3753: v_upd_stmt;
3754:
3755: FEM_ENGINES_PKG.TECH_MESSAGE
3756: (p_severity => c_log_level_1,
3757: p_module => v_block||'.v_eng_call{620.13}',
3758: p_msg_text => v_eng_call);
3759:
3773: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
3774: ' :b_arg13,:b_arg14);'||
3775: v_upd_stmt;
3776:
3777: FEM_ENGINES_PKG.TECH_MESSAGE
3778: (p_severity => c_log_level_1,
3779: p_module => v_block||'.v_eng_call{620.14}',
3780: p_msg_text => v_eng_call);
3781:
3795: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
3796: ' :b_arg13,:b_arg14,:b_arg15);'||
3797: v_upd_stmt;
3798:
3799: FEM_ENGINES_PKG.TECH_MESSAGE
3800: (p_severity => c_log_level_1,
3801: p_module => v_block||'.v_eng_call{620.15}',
3802: p_msg_text => v_eng_call);
3803:
3817: ' :b_arg9, :b_arg10,:b_arg11,:b_arg12,'||
3818: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16);'||
3819: v_upd_stmt;
3820:
3821: FEM_ENGINES_PKG.TECH_MESSAGE
3822: (p_severity => c_log_level_1,
3823: p_module => v_block||'.v_eng_call{620.16}',
3824: p_msg_text => v_eng_call);
3825:
3840: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
3841: ' :b_arg17);'||
3842: v_upd_stmt;
3843:
3844: FEM_ENGINES_PKG.TECH_MESSAGE
3845: (p_severity => c_log_level_1,
3846: p_module => v_block||'.v_eng_call{620.17}',
3847: p_msg_text => v_eng_call);
3848:
3864: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
3865: ' :b_arg17,:b_arg18);'||
3866: v_upd_stmt;
3867:
3868: FEM_ENGINES_PKG.TECH_MESSAGE
3869: (p_severity => c_log_level_1,
3870: p_module => v_block||'.v_eng_call{620.18}',
3871: p_msg_text => v_eng_call);
3872:
3888: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
3889: ' :b_arg17,:b_arg18,:b_arg19);'||
3890: v_upd_stmt;
3891:
3892: FEM_ENGINES_PKG.TECH_MESSAGE
3893: (p_severity => c_log_level_1,
3894: p_module => v_block||'.v_eng_call{620.19}',
3895: p_msg_text => v_eng_call);
3896:
3912: ' :b_arg13,:b_arg14,:b_arg15,:b_arg16,'||
3913: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20);'||
3914: v_upd_stmt;
3915:
3916: FEM_ENGINES_PKG.TECH_MESSAGE
3917: (p_severity => c_log_level_1,
3918: p_module => v_block||'.v_eng_call{620.20}',
3919: p_msg_text => v_eng_call);
3920:
3937: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
3938: ' :b_arg21);'||
3939: v_upd_stmt;
3940:
3941: FEM_ENGINES_PKG.TECH_MESSAGE
3942: (p_severity => c_log_level_1,
3943: p_module => v_block||'.v_eng_call{620.21}',
3944: p_msg_text => v_eng_call);
3945:
3963: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
3964: ' :b_arg21,:b_arg22);'||
3965: v_upd_stmt;
3966:
3967: FEM_ENGINES_PKG.TECH_MESSAGE
3968: (p_severity => c_log_level_1,
3969: p_module => v_block||'.v_eng_call{620.22}',
3970: p_msg_text => v_eng_call);
3971:
3989: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
3990: ' :b_arg21,:b_arg22,:b_arg23);'||
3991: v_upd_stmt;
3992:
3993: FEM_ENGINES_PKG.TECH_MESSAGE
3994: (p_severity => c_log_level_1,
3995: p_module => v_block||'.v_eng_call{620.23}',
3996: p_msg_text => v_eng_call);
3997:
4015: ' :b_arg17,:b_arg18,:b_arg19,:b_arg20,'||
4016: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24);'||
4017: v_upd_stmt;
4018:
4019: FEM_ENGINES_PKG.TECH_MESSAGE
4020: (p_severity => c_log_level_1,
4021: p_module => v_block||'.v_eng_call{620.24}',
4022: p_msg_text => v_eng_call);
4023:
4042: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
4043: ' :b_arg25);'||
4044: v_upd_stmt;
4045:
4046: FEM_ENGINES_PKG.TECH_MESSAGE
4047: (p_severity => c_log_level_1,
4048: p_module => v_block||'.v_eng_call{620.25}',
4049: p_msg_text => v_eng_call);
4050:
4070: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
4071: ' :b_arg25,:b_arg26);'||
4072: v_upd_stmt;
4073:
4074: FEM_ENGINES_PKG.TECH_MESSAGE
4075: (p_severity => c_log_level_1,
4076: p_module => v_block||'.v_eng_call{620.26}',
4077: p_msg_text => v_eng_call);
4078:
4098: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
4099: ' :b_arg25,:b_arg26,:b_arg27);'||
4100: v_upd_stmt;
4101:
4102: FEM_ENGINES_PKG.TECH_MESSAGE
4103: (p_severity => c_log_level_1,
4104: p_module => v_block||'.v_eng_call{620.27}',
4105: p_msg_text => v_eng_call);
4106:
4126: ' :b_arg21,:b_arg22,:b_arg23,:b_arg24,'||
4127: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28);'||
4128: v_upd_stmt;
4129:
4130: FEM_ENGINES_PKG.TECH_MESSAGE
4131: (p_severity => c_log_level_1,
4132: p_module => v_block||'.v_eng_call{620.28}',
4133: p_msg_text => v_eng_call);
4134:
4155: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
4156: ' :b_arg29);'||
4157: v_upd_stmt;
4158:
4159: FEM_ENGINES_PKG.TECH_MESSAGE
4160: (p_severity => c_log_level_1,
4161: p_module => v_block||'.v_eng_call{620.29}',
4162: p_msg_text => v_eng_call);
4163:
4185: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
4186: ' :b_arg29,:b_arg30);'||
4187: v_upd_stmt;
4188:
4189: FEM_ENGINES_PKG.TECH_MESSAGE
4190: (p_severity => c_log_level_1,
4191: p_module => v_block2||'.v_eng_call{642.30}',
4192: p_msg_text => v_eng_call);
4193:
4215: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
4216: ' :b_arg29,:b_arg30,:b_arg31);'||
4217: v_upd_stmt;
4218:
4219: FEM_ENGINES_PKG.TECH_MESSAGE
4220: (p_severity => c_log_level_1,
4221: p_module => v_block||'.v_eng_call{620.31}',
4222: p_msg_text => v_eng_call);
4223:
4245: ' :b_arg25,:b_arg26,:b_arg27,:b_arg28,'||
4246: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32);'||
4247: v_upd_stmt;
4248:
4249: FEM_ENGINES_PKG.TECH_MESSAGE
4250: (p_severity => c_log_level_1,
4251: p_module => v_block||'.v_eng_call{620.32}',
4252: p_msg_text => v_eng_call);
4253:
4276: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
4277: ' :b_arg33);'||
4278: v_upd_stmt;
4279:
4280: FEM_ENGINES_PKG.TECH_MESSAGE
4281: (p_severity => c_log_level_1,
4282: p_module => v_block||'.v_eng_call{620.33}',
4283: p_msg_text => v_eng_call);
4284:
4308: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
4309: ' :b_arg33,:b_arg34);'||
4310: v_upd_stmt;
4311:
4312: FEM_ENGINES_PKG.TECH_MESSAGE
4313: (p_severity => c_log_level_1,
4314: p_module => v_block||'.v_eng_call{620.34}',
4315: p_msg_text => v_eng_call);
4316:
4340: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
4341: ' :b_arg33,:b_arg34,:b_arg35);'||
4342: v_upd_stmt;
4343:
4344: FEM_ENGINES_PKG.TECH_MESSAGE
4345: (p_severity => c_log_level_1,
4346: p_module => v_block||'.v_eng_call{620.35}',
4347: p_msg_text => v_eng_call);
4348:
4372: ' :b_arg29,:b_arg30,:b_arg31,:b_arg32,'||
4373: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36);'||
4374: v_upd_stmt;
4375:
4376: FEM_ENGINES_PKG.TECH_MESSAGE
4377: (p_severity => c_log_level_1,
4378: p_module => v_block||'.v_eng_call{620.36}',
4379: p_msg_text => v_eng_call);
4380:
4405: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
4406: ' :b_arg37);'||
4407: v_upd_stmt;
4408:
4409: FEM_ENGINES_PKG.TECH_MESSAGE
4410: (p_severity => c_log_level_1,
4411: p_module => v_block||'.v_eng_call{620.37}',
4412: p_msg_text => v_eng_call);
4413:
4439: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
4440: ' :b_arg37,:b_arg38);'||
4441: v_upd_stmt;
4442:
4443: FEM_ENGINES_PKG.TECH_MESSAGE
4444: (p_severity => c_log_level_1,
4445: p_module => v_block||'.v_eng_call{620.38}',
4446: p_msg_text => v_eng_call);
4447:
4473: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
4474: ' :b_arg37,:b_arg38,:b_arg39);'||
4475: v_upd_stmt;
4476:
4477: FEM_ENGINES_PKG.TECH_MESSAGE
4478: (p_severity => c_log_level_1,
4479: p_module => v_block||'.v_eng_call{620.39}',
4480: p_msg_text => v_eng_call);
4481:
4507: ' :b_arg33,:b_arg34,:b_arg35,:b_arg36,'||
4508: ' :b_arg37,:b_arg38,:b_arg39,:b_arg40);'||
4509: v_upd_stmt;
4510:
4511: FEM_ENGINES_PKG.TECH_MESSAGE
4512: (p_severity => c_log_level_1,
4513: p_module => v_block||'.v_eng_call{620.40}',
4514: p_msg_text => v_eng_call);
4515:
4544: Pull Processing
4545:
4546: ----------------------------------------------------------------------*/
4547:
4548: FEM_ENGINES_PKG.TECH_MESSAGE
4549: (p_severity => c_log_level_2,
4550: p_module => v_block2||'.Engine_Pull{650}',
4551: p_msg_text => 'Data slice pulled by MP Subrequest for processing');
4552:
4551: p_msg_text => 'Data slice pulled by MP Subrequest for processing');
4552:
4553: v_eng_sql := REPLACE(v_eng_sql,'{{data_slice}}',v_slc_pred);
4554:
4555: FEM_ENGINES_PKG.TECH_MESSAGE
4556: (p_severity => c_log_level_2,
4557: p_module => v_block2||'.v_eng_sql{651}',
4558: p_msg_text => v_eng_sql);
4559:
4605:
4606: ------------------------------
4607: -- Check for completion status
4608: ------------------------------
4609: FEM_ENGINES_PKG.TECH_MESSAGE
4610: (p_severity => c_log_level_2,
4611: p_module => v_block2||'.slc_status{660}',
4612: p_msg_text => v_slc_stat||':'||v_slc_msg);
4613:
4628: FROM fem_mp_process_ctl_t
4629: WHERE req_id = p_req_id
4630: AND process_num = p_proc_num;
4631:
4632: FEM_ENGINES_PKG.TECH_MESSAGE
4633: (p_severity => c_log_level_2,
4634: p_module => v_block||'.v_sub_stat{661}',
4635: p_msg_text => v_sub_stat);
4636:
4636:
4637: IF (v_sub_stat IS NULL)
4638: THEN
4639: v_sub_stat := 0;
4640: FEM_ENGINES_PKG.TECH_MESSAGE
4641: (p_severity => c_log_level_2,
4642: p_module => v_block||'.v_sub_msg{662}',
4643: p_msg_text => 'Sub-request found no data slices to process');
4644: END IF;
4644: END IF;
4645:
4646: IF (v_sub_stat = 0)
4647: THEN
4648: FEM_ENGINES_PKG.PUT_MESSAGE
4649: (p_app_name => 'FEM',
4650: p_msg_name => 'FEM_MP_SUB_NORMAL_TXT',
4651: p_token1 => 'PARENT_REQ',
4652: p_value1 => p_req_id,
4656: v_sub_msg := FND_MSG_PUB.GET(p_encoded => 'F');
4657:
4658: ELSIF (v_sub_stat = 1)
4659: THEN
4660: FEM_ENGINES_PKG.PUT_MESSAGE
4661: (p_app_name => 'FEM',
4662: p_msg_name => 'FEM_MP_SUB_WARN_TXT',
4663: p_token1 => 'PARENT_REQ',
4664: p_value1 => p_req_id,
4668: v_sub_msg := FND_MSG_PUB.GET(p_encoded => 'F');
4669: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',null);
4670:
4671: ELSE
4672: FEM_ENGINES_PKG.PUT_MESSAGE(
4673: p_app_name => 'FEM',
4674: p_msg_name => 'FEM_MP_SUB_ENG_ERR',
4675: p_token1 => 'PARENT_REQ',
4676: p_value1 => p_req_id,
4681: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
4682:
4683: END IF;
4684:
4685: FEM_ENGINES_PKG.TECH_MESSAGE
4686: (p_severity => c_log_level_2,
4687: p_module => v_block||'.v_sub_msg{663}',
4688: p_msg_text => v_sub_msg);
4689: FEM_ENGINES_PKG.USER_MESSAGE(
4685: FEM_ENGINES_PKG.TECH_MESSAGE
4686: (p_severity => c_log_level_2,
4687: p_module => v_block||'.v_sub_msg{663}',
4688: p_msg_text => v_sub_msg);
4689: FEM_ENGINES_PKG.USER_MESSAGE(
4690: p_msg_text => v_sub_msg);
4691:
4692: /*=========================================================================
4693:
4697:
4698: EXCEPTION
4699:
4700: WHEN e_soft_kill THEN
4701: FEM_ENGINES_PKG.PUT_MESSAGE(
4702: p_app_name => 'FEM',
4703: p_msg_name => 'FEM_MP_SOFT_KILL_WARN',
4704: p_token1 => 'REQUEST',
4705: p_value1 => v_sub_req_id);
4705: p_value1 => v_sub_req_id);
4706:
4707: v_sub_msg := FND_MSG_PUB.GET(p_encoded => 'F');
4708:
4709: FEM_ENGINES_PKG.TECH_MESSAGE(
4710: p_severity => c_log_level_5,
4711: p_module => v_block||'.soft_kill_signal{664}',
4712: p_msg_text => v_sub_msg);
4713: FEM_ENGINES_PKG.USER_MESSAGE(
4709: FEM_ENGINES_PKG.TECH_MESSAGE(
4710: p_severity => c_log_level_5,
4711: p_module => v_block||'.soft_kill_signal{664}',
4712: p_msg_text => v_sub_msg);
4713: FEM_ENGINES_PKG.USER_MESSAGE(
4714: p_msg_text => v_sub_msg);
4715:
4716: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
4717:
4717:
4718: WHEN others THEN
4719: v_stack := dbms_utility.format_call_stack;
4720:
4721: FEM_ENGINES_PKG.PUT_MESSAGE(
4722: p_app_name => 'FEM',
4723: p_msg_name => 'FEM_MP_SUB_UNEXP_ERR',
4724: p_token1 => 'PARENT_REQ',
4725: p_value1 => p_req_id,
4729: p_value3 => sqlerrm);
4730:
4731: v_sub_msg := FND_MSG_PUB.GET(p_encoded => 'F');
4732:
4733: FEM_ENGINES_PKG.TECH_MESSAGE
4734: (p_severity => c_log_level_6,
4735: p_module => v_block||'.exception{665}',
4736: p_msg_text => v_sub_msg||'
4737: '||v_stack);
4734: (p_severity => c_log_level_6,
4735: p_module => v_block||'.exception{665}',
4736: p_msg_text => v_sub_msg||'
4737: '||v_stack);
4738: FEM_ENGINES_PKG.USER_MESSAGE(
4739: p_msg_text => v_sub_msg);
4740:
4741: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
4742:
4819: INTO v_part_count
4820: FROM fem_mp_process_ctl_t
4821: WHERE req_id = p_req_id;
4822:
4823: FEM_ENGINES_PKG.TECH_MESSAGE
4824: (p_severity => c_log_level_2,
4825: p_module => v_block||'.v_part_count{670}',
4826: p_msg_text => v_part_count);
4827:
4847: WHEN 1 THEN RAISE e_soft_kill;
4848: ELSE null;
4849: END CASE;
4850:
4851: FEM_ENGINES_PKG.TECH_MESSAGE
4852: (p_severity => c_log_level_2,
4853: p_module => v_block||'.Get_Slice{671}',
4854: p_msg_text => 'Getting slice to process. '||
4855: 'Log entry will appear as (p'||p_proc_num||':sN)');
4921: COMMIT;
4922:
4923: EXCEPTION
4924: WHEN no_data_found THEN
4925: FEM_ENGINES_PKG.TECH_MESSAGE
4926: (p_severity => c_log_level_3,
4927: p_module => v_block||'.End{699}',
4928: p_msg_text => 'End FEM_MP.SUBREQ. No more slices to process');
4929: RETURN;
4950: ----------------------------
4951:
4952: IF (p_proc_num <= v_part_count)
4953: THEN
4954: FEM_ENGINES_PKG.TECH_MESSAGE
4955: (p_severity => c_log_level_2,
4956: p_module => v_block||'.Get_Slice{680}',
4957: p_msg_text => 'Searching previously used partition');
4958: BEGIN
4976: -----------------------------
4977:
4978: IF (v_part_next IS NULL)
4979: THEN
4980: FEM_ENGINES_PKG.TECH_MESSAGE
4981: (p_severity => c_log_level_2,
4982: p_module => v_block||'.Get_Slice{681}',
4983: p_msg_text => 'Searching next unprocessed partition');
4984: BEGIN
4999: -----------------------------
5000:
5001: IF (v_part_next IS NULL)
5002: THEN
5003: FEM_ENGINES_PKG.TECH_MESSAGE
5004: (p_severity => c_log_level_2,
5005: p_module => v_block||'.Get_Slice{682}',
5006: p_msg_text => 'Searching least processed partition');
5007: BEGIN
5062: COMMIT;
5063:
5064: EXCEPTION
5065: WHEN no_data_found THEN
5066: FEM_ENGINES_PKG.TECH_MESSAGE
5067: (p_severity => c_log_level_3,
5068: p_module => v_block||'.End{699}',
5069: p_msg_text => 'End FEM_MP.SUBREQ. No more slices to process');
5070: RETURN;
5069: p_msg_text => 'End FEM_MP.SUBREQ. No more slices to process');
5070: RETURN;
5071: END;
5072:
5073: FEM_ENGINES_PKG.TECH_MESSAGE
5074: (c_log_level_2,v_block||'.v_part_name{683}',v_part_name);
5075: FEM_ENGINES_PKG.TECH_MESSAGE
5076: (c_log_level_2,v_block||'.v_part_next{684}',v_part_next);
5077:
5071: END;
5072:
5073: FEM_ENGINES_PKG.TECH_MESSAGE
5074: (c_log_level_2,v_block||'.v_part_name{683}',v_part_name);
5075: FEM_ENGINES_PKG.TECH_MESSAGE
5076: (c_log_level_2,v_block||'.v_part_next{684}',v_part_next);
5077:
5078: ------------------------------------
5079: -- Reset partition name if necessary
5080: ------------------------------------
5081: IF (v_part_next <> v_part_name)
5082: THEN
5083:
5084: FEM_ENGINES_PKG.TECH_MESSAGE
5085: (p_severity => c_log_level_2,
5086: p_module => v_block||'.v_part_reset{685}',
5087: p_msg_text => 'Resetting v_part_name to '||v_part_next);
5088:
5098:
5099: ---------------------------------------------------------------------*/
5100:
5101: x_slc_id := v_slc_id;
5102: FEM_ENGINES_PKG.TECH_MESSAGE
5103: (p_severity => c_log_level_2,
5104: p_module => v_block||'.x_slc_id{690}',
5105: p_msg_text => x_slc_id);
5106:
5106:
5107: v_block2 := REPLACE(v_block,'}',':s'||v_slc_id||'}');
5108:
5109: x_part_name := v_part_name;
5110: FEM_ENGINES_PKG.TECH_MESSAGE
5111: (p_severity => c_log_level_2,
5112: p_module => v_block2||'.x_part_name{691}',
5113: p_msg_text => x_part_name);
5114:
5123: WHEN no_data_found THEN
5124: v_data_slc := null;
5125: END;
5126:
5127: FEM_ENGINES_PKG.TECH_MESSAGE
5128: (p_severity => c_log_level_2,
5129: p_module => v_block2||'.v_data_slc{692}',
5130: p_msg_text => v_data_slc);
5131:
5142:
5143: LOOP
5144: v_slc_len := INSTR(v_data_slc,'{#}',1,v_slc_num)-v_slc_beg;
5145:
5146: FEM_ENGINES_PKG.TECH_MESSAGE
5147: (p_severity => c_log_level_2,
5148: p_module => v_block2||'.v_slc_len(slc#'||v_slc_num||'){693}',
5149: p_msg_text => v_slc_len);
5150:
5175: x_num_vals := v_slc_num;
5176:
5177: END IF;
5178:
5179: FEM_ENGINES_PKG.TECH_MESSAGE
5180: (p_severity => c_log_level_2,
5181: p_module => v_block2||'.x_slc_val1{694.1}',
5182: p_msg_text => x_slc_val1);
5183: FEM_ENGINES_PKG.TECH_MESSAGE
5179: FEM_ENGINES_PKG.TECH_MESSAGE
5180: (p_severity => c_log_level_2,
5181: p_module => v_block2||'.x_slc_val1{694.1}',
5182: p_msg_text => x_slc_val1);
5183: FEM_ENGINES_PKG.TECH_MESSAGE
5184: (p_severity => c_log_level_2,
5185: p_module => v_block2||'.x_slc_val2{694.2}',
5186: p_msg_text => x_slc_val2);
5187: FEM_ENGINES_PKG.TECH_MESSAGE
5183: FEM_ENGINES_PKG.TECH_MESSAGE
5184: (p_severity => c_log_level_2,
5185: p_module => v_block2||'.x_slc_val2{694.2}',
5186: p_msg_text => x_slc_val2);
5187: FEM_ENGINES_PKG.TECH_MESSAGE
5188: (p_severity => c_log_level_2,
5189: p_module => v_block2||'.x_slc_val3{694.3}',
5190: p_msg_text => x_slc_val3);
5191: FEM_ENGINES_PKG.TECH_MESSAGE
5187: FEM_ENGINES_PKG.TECH_MESSAGE
5188: (p_severity => c_log_level_2,
5189: p_module => v_block2||'.x_slc_val3{694.3}',
5190: p_msg_text => x_slc_val3);
5191: FEM_ENGINES_PKG.TECH_MESSAGE
5192: (p_severity => c_log_level_2,
5193: p_module => v_block2||'.x_slc_val4{694.4}',
5194: p_msg_text => x_slc_val4);
5195:
5218: v_block VARCHAR2(80) := 'fem.plsql.fem_mp.post_data_slice';
5219: v_sql_cmd VARCHAR2(32766);
5220: BEGIN
5221:
5222: FEM_ENGINES_PKG.TECH_MESSAGE
5223: (p_severity => c_log_level_2,
5224: p_module => v_block||'.p_req_id{700}',
5225: p_msg_text => p_req_id);
5226: FEM_ENGINES_PKG.TECH_MESSAGE
5222: FEM_ENGINES_PKG.TECH_MESSAGE
5223: (p_severity => c_log_level_2,
5224: p_module => v_block||'.p_req_id{700}',
5225: p_msg_text => p_req_id);
5226: FEM_ENGINES_PKG.TECH_MESSAGE
5227: (p_severity => c_log_level_2,
5228: p_module => v_block||'.p_slc_id{701}',
5229: p_msg_text => p_slc_id);
5230: FEM_ENGINES_PKG.TECH_MESSAGE
5226: FEM_ENGINES_PKG.TECH_MESSAGE
5227: (p_severity => c_log_level_2,
5228: p_module => v_block||'.p_slc_id{701}',
5229: p_msg_text => p_slc_id);
5230: FEM_ENGINES_PKG.TECH_MESSAGE
5231: (p_severity => c_log_level_2,
5232: p_module => v_block||'.p_status{702}',
5233: p_msg_text => p_status);
5234: FEM_ENGINES_PKG.TECH_MESSAGE
5230: FEM_ENGINES_PKG.TECH_MESSAGE
5231: (p_severity => c_log_level_2,
5232: p_module => v_block||'.p_status{702}',
5233: p_msg_text => p_status);
5234: FEM_ENGINES_PKG.TECH_MESSAGE
5235: (p_severity => c_log_level_2,
5236: p_module => v_block||'.p_message{703}',
5237: p_msg_text => p_message);
5238: FEM_ENGINES_PKG.TECH_MESSAGE
5234: FEM_ENGINES_PKG.TECH_MESSAGE
5235: (p_severity => c_log_level_2,
5236: p_module => v_block||'.p_message{703}',
5237: p_msg_text => p_message);
5238: FEM_ENGINES_PKG.TECH_MESSAGE
5239: (p_severity => c_log_level_2,
5240: p_module => v_block||'.p_rows_processed{704}',
5241: p_msg_text => p_rows_processed);
5242: FEM_ENGINES_PKG.TECH_MESSAGE
5238: FEM_ENGINES_PKG.TECH_MESSAGE
5239: (p_severity => c_log_level_2,
5240: p_module => v_block||'.p_rows_processed{704}',
5241: p_msg_text => p_rows_processed);
5242: FEM_ENGINES_PKG.TECH_MESSAGE
5243: (p_severity => c_log_level_2,
5244: p_module => v_block||'.p_rows_loaded{705}',
5245: p_msg_text => p_rows_loaded);
5246: FEM_ENGINES_PKG.TECH_MESSAGE
5242: FEM_ENGINES_PKG.TECH_MESSAGE
5243: (p_severity => c_log_level_2,
5244: p_module => v_block||'.p_rows_loaded{705}',
5245: p_msg_text => p_rows_loaded);
5246: FEM_ENGINES_PKG.TECH_MESSAGE
5247: (p_severity => c_log_level_2,
5248: p_module => v_block||'.p_rows_rejected{706}',
5249: p_msg_text => p_rows_rejected);
5250:
5247: (p_severity => c_log_level_2,
5248: p_module => v_block||'.p_rows_rejected{706}',
5249: p_msg_text => p_rows_rejected);
5250:
5251: FEM_ENGINES_PKG.TECH_MESSAGE
5252: (p_severity => c_log_level_2,
5253: p_module => v_block||'.v_sql_cmd{707}',
5254: p_msg_text => 'Updating FEM_MP_PROCESS_CTL_T.');
5255:
5288: FROM fem_mp_process_ctl_t
5289: WHERE req_id = p_req_id
5290: AND status IN (1,2);
5291:
5292: FEM_ENGINES_PKG.User_Message (
5293: p_app_name => 'FEM',
5294: p_msg_text => '
5295: ========== Warnings and Errors ==========');
5296:
5295: ========== Warnings and Errors ==========');
5296:
5297: FOR i IN 1..v_msg_list.COUNT
5298: LOOP
5299: FEM_ENGINES_PKG.User_Message (
5300: p_app_name => 'FEM',
5301: p_msg_text => v_msg_list(i) );
5302: END LOOP;
5303:
5300: p_app_name => 'FEM',
5301: p_msg_text => v_msg_list(i) );
5302: END LOOP;
5303:
5304: FEM_ENGINES_PKG.User_Message (
5305: p_app_name => 'FEM',
5306: p_msg_text => '=========================================
5307: ');
5308: