APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_UTIL

Line 23: WHERE msv.deleted_flag = MSC_UTIL.SYS_NO

19: msv.VISIT_STATUS,
20: msv.VISIT_NUMBER,
21: msv.SR_INSTANCE_ID
22: FROM MSC_ST_VISITS msv
23: WHERE msv.deleted_flag = MSC_UTIL.SYS_NO
24: AND msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
25:
26: CURSOR c_del IS
27: SELECT msv.VISIT_ID,

Line 31: WHERE msv.deleted_flag = MSC_UTIL.SYS_YES

27: SELECT msv.VISIT_ID,
28: msv.ORGANIZATION_ID,
29: msv.SR_INSTANCE_ID
30: FROM MSC_ST_VISITS msv
31: WHERE msv.deleted_flag = MSC_UTIL.SYS_YES
32: AND msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
33:
34: BEGIN
35: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');

Line 35: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');

31: WHERE msv.deleted_flag = MSC_UTIL.SYS_YES
32: AND msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
33:
34: BEGIN
35: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_VISITS ');
36:
37: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
38: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
39: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =

Line 40: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

36:
37: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
38: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
39: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
40: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
41: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_VISITS',
42: MSC_CL_COLLECTION.v_instance_id,
43: -1);
44: ELSE

Line 45: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

41: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_VISITS',
42: MSC_CL_COLLECTION.v_instance_id,
43: -1);
44: ELSE
45: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
46: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_VISITS',
47: MSC_CL_COLLECTION.v_instance_id,
48: null,
49: v_sub_str);

Line 54: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

50: END IF;
51: END IF;
52:
53: BEGIN
54: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
55: lv_tbl:= 'VISITS_'||MSC_CL_COLLECTION.v_instance_code;
56: ELSE
57: lv_tbl:= 'MSC_VISITS';
58: END IF;

Line 59: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

55: lv_tbl:= 'VISITS_'||MSC_CL_COLLECTION.v_instance_code;
56: ELSE
57: lv_tbl:= 'MSC_VISITS';
58: END IF;
59: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
60: 'In Procedure LOAD_VISITS lv_tbl'||lv_tbl);
61:
62: lv_cursor_stmt:=
63: 'INSERT INTO '||lv_tbl

Line 97: ||'WHERE msv.deleted_flag = '||MSC_UTIL.SYS_NO

93: ||':v_current_user,'
94: ||':v_current_date,'
95: ||':v_current_user'
96: ||' FROM MSC_ST_VISITS msv '
97: ||'WHERE msv.deleted_flag = '||MSC_UTIL.SYS_NO
98: ||' AND msv.SR_INSTANCE_ID= '
99: ||MSC_CL_COLLECTION.v_instance_id;
100:
101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

97: ||'WHERE msv.deleted_flag = '||MSC_UTIL.SYS_NO
98: ||' AND msv.SR_INSTANCE_ID= '
99: ||MSC_CL_COLLECTION.v_instance_id;
100:
101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
102: 'In Procedure LOAD_VISITS lv_cursor_stmt: '|| lv_cursor_stmt);
103: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
104: MSC_CL_COLLECTION.v_is_partial_refresh) OR
105: (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN

Line 117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

113: END IF;
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
118: RAISE;
119: END;
120:
121: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR

Line 139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

135: AND ORGANIZATION_ID = c_rec.organization_id;
136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
140: 'An error has occurred during deletion of Visits.');
141: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
142: RAISE;
143: END;

Line 141: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

137: EXCEPTION
138: WHEN OTHERS THEN
139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
140: 'An error has occurred during deletion of Visits.');
141: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
142: RAISE;
143: END;
144: END LOOP;
145:

Line 226: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

222: END LOOP;
223: END IF;
224:
225:
226: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
227: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
228: lv_retcode,
229: 'MSC_VISITS',
230: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 231: MSC_UTIL.G_ERROR);

227: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
228: lv_retcode,
229: 'MSC_VISITS',
230: MSC_CL_COLLECTION.v_INSTANCE_CODE,
231: MSC_UTIL.G_ERROR);
232:
233: IF lv_retcode = MSC_UTIL.G_ERROR THEN
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
235: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 233: IF lv_retcode = MSC_UTIL.G_ERROR THEN

229: 'MSC_VISITS',
230: MSC_CL_COLLECTION.v_INSTANCE_CODE,
231: MSC_UTIL.G_ERROR);
232:
233: IF lv_retcode = MSC_UTIL.G_ERROR THEN
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
235: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
236: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

230: MSC_CL_COLLECTION.v_INSTANCE_CODE,
231: MSC_UTIL.G_ERROR);
232:
233: IF lv_retcode = MSC_UTIL.G_ERROR THEN
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
235: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
236: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
238: END IF;

Line 236: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

232:
233: IF lv_retcode = MSC_UTIL.G_ERROR THEN
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
235: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
236: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
238: END IF;
239: END IF;
240: COMMIT;

Line 237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

233: IF lv_retcode = MSC_UTIL.G_ERROR THEN
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
235: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
236: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
238: END IF;
239: END IF;
240: COMMIT;
241:

Line 252: WHERE mswa.deleted_flag = MSC_UTIL.SYS_YES

248: mswa.VISIT_ID,
249: mswa.ORGANIZATION_ID,
250: mswa.SR_INSTANCE_ID
251: FROM MSC_ST_WO_ATTRIBUTES mswa
252: WHERE mswa.deleted_flag = MSC_UTIL.SYS_YES
253: AND mswa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
254:
255: lv_supplies_tbl VARCHAR2(30);
256: type ref_cur is ref cursor;

Line 286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');

282:
283: c_rec cursorRec;
284: BEGIN
285:
286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_ATTRIBUTES ');
287:
288: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
289: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
290: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =

Line 291: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

287:
288: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
289: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
290: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
291: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_ATTRIBUTES',
293: MSC_CL_COLLECTION.v_instance_id,
294: -1);
295: ELSE

Line 296: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_ATTRIBUTES',
293: MSC_CL_COLLECTION.v_instance_id,
294: -1);
295: ELSE
296: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
297: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_ATTRIBUTES',
298: MSC_CL_COLLECTION.v_instance_id,
299: null,
300: v_sub_str);

Line 306: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

302: END IF;
303:
304:
305: BEGIN
306: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
307: lv_tbl:= 'WO_ATTRIBUTES_'||MSC_CL_COLLECTION.v_instance_code;
308: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
309: ELSE
310: lv_tbl:= 'MSC_WO_ATTRIBUTES';

Line 378: ||' WHERE mswa.DELETED_FLAG = '||MSC_UTIL.SYS_NO

374: ||':v_current_date, '
375: ||':v_current_user '
376: ||' FROM MSC_ST_WO_ATTRIBUTES mswa, '
377: || lv_supplies_tbl||' ms'
378: ||' WHERE mswa.DELETED_FLAG = '||MSC_UTIL.SYS_NO
379: ||' AND mswa.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
380: ||' AND ms.SR_INSTANCE_ID(+)= mswa.SR_INSTANCE_ID'
381: ||' AND ms.ORGANIZATION_ID(+)= mswa.ORGANIZATION_ID'
382: ||' AND ms.DISPOSITION_ID(+)= mswa.WIP_ENTITY_ID*2'

Line 400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

396: END IF;
397:
398: EXCEPTION
399: WHEN OTHERS THEN
400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
401: RAISE;
402: END;
403:
404: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR

Line 417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

413: AND ORGANIZATION_ID = c1.organization_id;
414:
415: EXCEPTION
416: WHEN OTHERS THEN
417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
418: 'An error has occurred during deletion of WO attributes.');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
420: RAISE;
421: END;

Line 419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

415: EXCEPTION
416: WHEN OTHERS THEN
417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
418: 'An error has occurred during deletion of WO attributes.');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
420: RAISE;
421: END;
422:
423: END LOOP;

Line 451: ||' WHERE mswa.DELETED_FLAG = '||MSC_UTIL.SYS_NO

447: ||'mswa.MAINTENANCE_REQT, '
448: ||'mswa.WIP_ENTITY_ID '
449: ||' FROM MSC_ST_WO_ATTRIBUTES mswa, '
450: || lv_supplies_tbl||' ms'
451: ||' WHERE mswa.DELETED_FLAG = '||MSC_UTIL.SYS_NO
452: ||' AND mswa.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
453: ||' AND ms.SR_INSTANCE_ID(+)= mswa.SR_INSTANCE_ID'
454: ||' AND ms.ORGANIZATION_ID(+)= mswa.ORGANIZATION_ID'
455: ||' AND ms.DISPOSITION_ID(+)= mswa.WIP_ENTITY_ID*2'

Line 590: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

586: END IF;
587: END LOOP;
588: END IF;
589:
590: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
591: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
592: lv_retcode,
593: 'MSC_WO_ATTRIBUTES',
594: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 595: MSC_UTIL.G_ERROR);

591: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
592: lv_retcode,
593: 'MSC_WO_ATTRIBUTES',
594: MSC_CL_COLLECTION.v_INSTANCE_CODE,
595: MSC_UTIL.G_ERROR);
596:
597: IF lv_retcode = MSC_UTIL.G_ERROR THEN
598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
599: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 597: IF lv_retcode = MSC_UTIL.G_ERROR THEN

593: 'MSC_WO_ATTRIBUTES',
594: MSC_CL_COLLECTION.v_INSTANCE_CODE,
595: MSC_UTIL.G_ERROR);
596:
597: IF lv_retcode = MSC_UTIL.G_ERROR THEN
598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
599: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
600: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
601: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

594: MSC_CL_COLLECTION.v_INSTANCE_CODE,
595: MSC_UTIL.G_ERROR);
596:
597: IF lv_retcode = MSC_UTIL.G_ERROR THEN
598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
599: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
600: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
601: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
602: END IF;

Line 600: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

596:
597: IF lv_retcode = MSC_UTIL.G_ERROR THEN
598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
599: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
600: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
601: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
602: END IF;
603:
604: END IF;

Line 601: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

597: IF lv_retcode = MSC_UTIL.G_ERROR THEN
598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
599: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
600: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
601: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
602: END IF;
603:
604: END IF;
605: COMMIT;

Line 616: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_NO

612: mswbs.DISPLAY_NAME,
613: mswbs.ORGANIZATION_ID,
614: mswbs.SR_INSTANCE_ID
615: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs
616: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_NO
617: AND mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
618:
619: CURSOR c_del IS
620: SELECT mswbs.PARAMETER_NAME,

Line 625: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_YES

621: mswbs.DISPLAY_NAME,
622: mswbs.ORGANIZATION_ID,
623: mswbs.SR_INSTANCE_ID
624: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs
625: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_YES
626: AND mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
627:
628: BEGIN
629: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 629: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

625: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_YES
626: AND mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
627:
628: BEGIN
629: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
630: 'In Procedure LOAD_WORK_BREAKDOWN_STRUCT ');
631:
632: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
633: MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 635: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

631:
632: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
633: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
634: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
635: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
636: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WORK_BREAKDOWN_STRUCT',
637: MSC_CL_COLLECTION.v_instance_id,
638: -1);
639: ELSE

Line 640: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

636: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WORK_BREAKDOWN_STRUCT',
637: MSC_CL_COLLECTION.v_instance_id,
638: -1);
639: ELSE
640: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
641: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WORK_BREAKDOWN_STRUCT',
642: MSC_CL_COLLECTION.v_instance_id,
643: null,
644: v_sub_str);

Line 650: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

646: END IF;
647:
648:
649: BEGIN
650: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
651: lv_tbl:= 'WORK_BREAKDOWN_STRUCT_'
652: ||MSC_CL_COLLECTION.v_instance_code;
653: ELSE
654: lv_tbl:= 'MSC_WORK_BREAKDOWN_STRUCT';

Line 678: ||'WHERE mswbs.deleted_flag ='|| MSC_UTIL.SYS_NO

674: ||':v_current_user, '
675: ||':v_current_date, '
676: ||':v_current_user '
677: ||' FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs '
678: ||'WHERE mswbs.deleted_flag ='|| MSC_UTIL.SYS_NO
679: ||' AND mswbs.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id;
680:
681: IF (MSC_CL_COLLECTION.v_is_complete_refresh or
682: MSC_CL_COLLECTION.v_is_partial_refresh) OR

Line 694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

690: MSC_CL_COLLECTION.v_current_user;
691: END IF;
692: EXCEPTION
693: WHEN OTHERS THEN
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
695: RAISE;
696: END;
697:
698: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR

Line 709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

705: AND ORGANIZATION_ID = c_rec.organization_id;
706:
707: EXCEPTION
708: WHEN OTHERS THEN
709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
710: 'An error has occurred during deletion of WBS.');
711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
712: RAISE;
713: END;

Line 711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

707: EXCEPTION
708: WHEN OTHERS THEN
709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
710: 'An error has occurred during deletion of WBS.');
711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
712: RAISE;
713: END;
714:
715: END LOOP;

Line 765: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

761: END LOOP;
762: END IF;
763:
764:
765: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
766: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
767: lv_retcode,
768: 'MSC_WORK_BREAKDOWN_STRUCT',
769: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 770: MSC_UTIL.G_ERROR);

766: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
767: lv_retcode,
768: 'MSC_WORK_BREAKDOWN_STRUCT',
769: MSC_CL_COLLECTION.v_INSTANCE_CODE,
770: MSC_UTIL.G_ERROR);
771:
772: IF lv_retcode = MSC_UTIL.G_ERROR THEN
773: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
774: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 772: IF lv_retcode = MSC_UTIL.G_ERROR THEN

768: 'MSC_WORK_BREAKDOWN_STRUCT',
769: MSC_CL_COLLECTION.v_INSTANCE_CODE,
770: MSC_UTIL.G_ERROR);
771:
772: IF lv_retcode = MSC_UTIL.G_ERROR THEN
773: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
774: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
775: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
776: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 773: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

769: MSC_CL_COLLECTION.v_INSTANCE_CODE,
770: MSC_UTIL.G_ERROR);
771:
772: IF lv_retcode = MSC_UTIL.G_ERROR THEN
773: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
774: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
775: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
776: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
777: END IF;

Line 775: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

771:
772: IF lv_retcode = MSC_UTIL.G_ERROR THEN
773: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
774: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
775: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
776: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
777: END IF;
778: END IF;
779: COMMIT;

Line 776: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

772: IF lv_retcode = MSC_UTIL.G_ERROR THEN
773: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
774: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
775: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
776: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
777: END IF;
778: END IF;
779: COMMIT;
780:

Line 791: WHERE mswth.deleted_flag = MSC_UTIL.SYS_YES

787: mswth.NEXT_SUPPLY_ID,
788: mswth.ORGANIZATION_ID,
789: mswth.SR_INSTANCE_ID
790: FROM MSC_ST_WO_TASK_HIERARCHY mswth
791: WHERE mswth.deleted_flag = MSC_UTIL.SYS_YES
792: AND mswth.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
793: lv_supplies_tbl VARCHAR2(30);
794: type ref_cur is ref cursor;
795: c_ref_cur ref_cur;

Line 812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

808: );
809:
810: c_rec cursorRec;
811: BEGIN
812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
813: 'In Procedure LOAD_WO_TASK_HIERARCHY ');
814:
815: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
816: MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 818: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

814:
815: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
816: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
817: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
818: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
819: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',
820: MSC_CL_COLLECTION.v_instance_id, -1);
821: ELSE
822: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 822: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

818: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
819: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',
820: MSC_CL_COLLECTION.v_instance_id, -1);
821: ELSE
822: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',
824: MSC_CL_COLLECTION.v_instance_id,
825: null,
826: v_sub_str);

Line 832: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

828: END IF;
829:
830:
831: BEGIN
832: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
833: lv_tbl:= 'WO_TASK_HIERARCHY_'||MSC_CL_COLLECTION.v_instance_code;
834: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
835: ELSE
836: lv_tbl:= 'MSC_WO_TASK_HIERARCHY';

Line 879: ||' WHERE mswth.deleted_flag = '|| MSC_UTIL.SYS_NO

875: ||':v_current_user '
876: ||' FROM MSC_ST_WO_TASK_HIERARCHY mswth, '
877: || lv_supplies_tbl||' ms1,'
878: || lv_supplies_tbl||' ms2'
879: ||' WHERE mswth.deleted_flag = '|| MSC_UTIL.SYS_NO
880: ||' AND mswth.SR_INSTANCE_ID= '
881: || MSC_CL_COLLECTION.v_instance_id
882: ||' AND ms1.SR_INSTANCE_ID(+)=mswth.SR_INSTANCE_ID'
883: ||' AND ms2.SR_INSTANCE_ID(+)=mswth.SR_INSTANCE_ID'

Line 907: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

903: MSC_CL_COLLECTION.v_current_user;
904: END IF;
905: EXCEPTION
906: WHEN OTHERS THEN
907: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
908: RAISE;
909: END;
910:
911: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR

Line 922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

918: AND NEXT_SUPPLY_ID = c_rec.next_supply_id
919: AND ORGANIZATION_ID = c_rec.organization_id;
920: EXCEPTION
921: WHEN OTHERS THEN
922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
923: 'An error has occurred during deletion of WO task hierarchy.');
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
925: RAISE;
926: END;

Line 924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

920: EXCEPTION
921: WHEN OTHERS THEN
922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
923: 'An error has occurred during deletion of WO task hierarchy.');
924: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
925: RAISE;
926: END;
927: END LOOP;
928: COMMIT;

Line 944: ||' WHERE mswth.deleted_flag = '|| MSC_UTIL.SYS_NO

940: ||'mswth.NEXT_WIP_ENTITY_ID '
941: ||' FROM MSC_ST_WO_TASK_HIERARCHY mswth, '
942: || lv_supplies_tbl||' ms1,'
943: || lv_supplies_tbl||' ms2'
944: ||' WHERE mswth.deleted_flag = '|| MSC_UTIL.SYS_NO
945: ||' AND mswth.SR_INSTANCE_ID= '
946: || MSC_CL_COLLECTION.v_instance_id
947: ||' AND ms1.SR_INSTANCE_ID(+)=mswth.SR_INSTANCE_ID'
948: ||' AND ms2.SR_INSTANCE_ID(+)=mswth.SR_INSTANCE_ID'

Line 1043: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1039: END LOOP;
1040: END IF;
1041:
1042:
1043: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1044: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1045: lv_retcode,
1046: 'MSC_WO_TASK_HIERARCHY',
1047: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 1048: MSC_UTIL.G_ERROR);

1044: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1045: lv_retcode,
1046: 'MSC_WO_TASK_HIERARCHY',
1047: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1048: MSC_UTIL.G_ERROR);
1049:
1050: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1052: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 1050: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1046: 'MSC_WO_TASK_HIERARCHY',
1047: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1048: MSC_UTIL.G_ERROR);
1049:
1050: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1052: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1053: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1054: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

1047: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1048: MSC_UTIL.G_ERROR);
1049:
1050: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1052: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1053: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1054: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1055: END IF;

Line 1053: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1049:
1050: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1052: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1053: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1054: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1055: END IF;
1056:
1057: END IF;

Line 1054: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1050: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1052: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1053: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1054: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1055: END IF;
1056:
1057: END IF;
1058: COMMIT;

Line 1072: WHERE mswor.deleted_flag = MSC_UTIL.SYS_YES

1068: mswor.TO_OP_RES_SEQ_NUM,
1069: mswor.ORGANIZATION_ID,
1070: mswor.SR_INSTANCE_ID
1071: FROM MSC_ST_WO_OPERATION_REL mswor
1072: WHERE mswor.deleted_flag = MSC_UTIL.SYS_YES
1073: AND mswor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1074:
1075: lv_supplies_tbl VARCHAR2(30);
1076: type ref_cur is ref cursor;

Line 1098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

1094: );
1095:
1096: c_rec cursorRec;
1097: BEGIN
1098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1099: 'In Procedure LOAD_WO_OPERATION_REL ');
1100:
1101: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
1102: MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 1104: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1100:
1101: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
1102: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1103: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
1104: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1105: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_OPERATION_REL',
1106: MSC_CL_COLLECTION.v_instance_id,
1107: -1);
1108: ELSE

Line 1109: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1105: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_OPERATION_REL',
1106: MSC_CL_COLLECTION.v_instance_id,
1107: -1);
1108: ELSE
1109: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1110: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_OPERATION_REL',
1111: MSC_CL_COLLECTION.v_instance_id,
1112: null,
1113: v_sub_str);

Line 1119: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1115: END IF;
1116:
1117:
1118: BEGIN
1119: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1120: lv_tbl:= 'WO_OPERATION_REL_'||MSC_CL_COLLECTION.v_instance_code;
1121: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1122: ELSE
1123: lv_tbl:= 'MSC_WO_OPERATION_REL';

Line 1173: ||' WHERE mswor.deleted_flag = '||MSC_UTIL.SYS_NO

1169: ||':v_current_date, '
1170: ||':v_current_user '
1171: ||' FROM MSC_ST_WO_OPERATION_REL mswor,'
1172: || lv_supplies_tbl||' ms'
1173: ||' WHERE mswor.deleted_flag = '||MSC_UTIL.SYS_NO
1174: ||' AND mswor.SR_INSTANCE_ID= '
1175: ||MSC_CL_COLLECTION.v_instance_id
1176: ||' AND ms.SR_INSTANCE_ID(+)= mswor.SR_INSTANCE_ID'
1177: ||' AND ms.ORGANIZATION_ID(+)= mswor.ORGANIZATION_ID'

Line 1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1191: MSC_CL_COLLECTION.v_current_user;
1192: END IF;
1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1196: RAISE;
1197: END;
1198:
1199: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR

Line 1214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

1210: AND nvl(TO_OP_RES_SEQ_NUM,-1) = nvl(c_rec.TO_OP_RES_SEQ_NUM,-1)
1211: AND ORGANIZATION_ID = c_rec.organization_id;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1215: 'An error has occurred during deletion of WO operation Relation.');
1216: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1217: RAISE;
1218: END;

Line 1216: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1215: 'An error has occurred during deletion of WO operation Relation.');
1216: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1217: RAISE;
1218: END;
1219: END LOOP;
1220: COMMIT;

Line 1239: ||' WHERE mswor.deleted_flag = '||MSC_UTIL.SYS_NO

1235: ||'mswor.WORKORDER_ID, '
1236: ||'mswor.WIP_ENTITY_ID '
1237: ||' FROM MSC_ST_WO_OPERATION_REL mswor,'
1238: || lv_supplies_tbl||' ms'
1239: ||' WHERE mswor.deleted_flag = '||MSC_UTIL.SYS_NO
1240: ||' AND mswor.SR_INSTANCE_ID= '
1241: ||MSC_CL_COLLECTION.v_instance_id
1242: ||' AND ms.SR_INSTANCE_ID(+)= mswor.SR_INSTANCE_ID'
1243: ||' AND ms.ORGANIZATION_ID(+)= mswor.ORGANIZATION_ID'

Line 1347: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1343: END LOOP;
1344: END IF;
1345:
1346:
1347: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1348: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1349: lv_retcode,
1350: 'MSC_WO_OPERATION_REL',
1351: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 1352: MSC_UTIL.G_ERROR);

1348: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1349: lv_retcode,
1350: 'MSC_WO_OPERATION_REL',
1351: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1352: MSC_UTIL.G_ERROR);
1353:
1354: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1356: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 1354: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1350: 'MSC_WO_OPERATION_REL',
1351: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1352: MSC_UTIL.G_ERROR);
1353:
1354: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1356: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1357: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1358: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

1351: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1352: MSC_UTIL.G_ERROR);
1353:
1354: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1356: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1357: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1358: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1359: END IF;

Line 1357: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1353:
1354: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1356: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1357: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1358: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1359: END IF;
1360:
1361: END IF;

Line 1358: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1354: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1356: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1357: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1358: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1359: END IF;
1360:
1361: END IF;
1362: commit;

Line 1376: WHERE mswm.deleted_flag = MSC_UTIL.SYS_NO

1372: mswm.EARLIEST_START_DATE,
1373: mswm.TARGET_COMPLETION_DATE,
1374: mswm.SR_INSTANCE_ID
1375: FROM MSC_ST_WO_MILESTONES mswm
1376: WHERE mswm.deleted_flag = MSC_UTIL.SYS_NO
1377: AND mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1378:
1379: CURSOR c_del IS
1380: SELECT mswm.MILESTONE,

Line 1385: WHERE mswm.deleted_flag = MSC_UTIL.SYS_YES

1381: mswm.VISIT_ID,
1382: mswm.ORGANIZATION_ID,
1383: mswm.SR_INSTANCE_ID
1384: FROM MSC_ST_WO_MILESTONES mswm
1385: WHERE mswm.deleted_flag = MSC_UTIL.SYS_YES
1386: AND mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1387:
1388: BEGIN
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

1385: WHERE mswm.deleted_flag = MSC_UTIL.SYS_YES
1386: AND mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1387:
1388: BEGIN
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1390: 'In Procedure LOAD_WO_MILESTONES ');
1391:
1392: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
1393: MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 1395: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1391:
1392: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
1393: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1394: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
1395: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1396: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_MILESTONES',
1397: MSC_CL_COLLECTION.v_instance_id,
1398: -1);
1399: ELSE

Line 1400: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1396: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_MILESTONES',
1397: MSC_CL_COLLECTION.v_instance_id,
1398: -1);
1399: ELSE
1400: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1401: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_MILESTONES',
1402: MSC_CL_COLLECTION.v_instance_id,
1403: null,
1404: v_sub_str);

Line 1410: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1406: END IF;
1407:
1408:
1409: BEGIN
1410: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1411: lv_tbl:= 'WO_MILESTONES_'||MSC_CL_COLLECTION.v_instance_code;
1412: ELSE
1413: lv_tbl:= 'MSC_WO_MILESTONES';
1414: END IF;

Line 1443: ||' WHERE mswm.deleted_flag = '||MSC_UTIL.SYS_NO

1439: ||':v_current_user, '
1440: ||':v_current_date, '
1441: ||':v_current_user '
1442: ||' FROM MSC_ST_WO_MILESTONES mswm '
1443: ||' WHERE mswm.deleted_flag = '||MSC_UTIL.SYS_NO
1444: ||' AND mswm.SR_INSTANCE_ID= '
1445: ||MSC_CL_COLLECTION.v_instance_id;
1446:
1447: IF (MSC_CL_COLLECTION.v_is_complete_refresh or

Line 1470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

1466: AND VISIT_ID = c_rec.visit_id
1467: AND ORGANIZATION_ID = c_rec.organization_id;
1468: EXCEPTION
1469: WHEN OTHERS THEN
1470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1471: 'An error has occurred during deletion of Milestones.');
1472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1473: RAISE;
1474: END;

Line 1472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1468: EXCEPTION
1469: WHEN OTHERS THEN
1470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1471: 'An error has occurred during deletion of Milestones.');
1472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1473: RAISE;
1474: END;
1475: END LOOP;
1476: COMMIT;

Line 1539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1535: END IF;
1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1540: RAISE;
1541: END;
1542: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1543: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,

Line 1542: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1538: WHEN OTHERS THEN
1539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1540: RAISE;
1541: END;
1542: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1543: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1544: lv_retcode,
1545: 'MSC_WO_MILESTONES',
1546: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 1547: MSC_UTIL.G_ERROR);

1543: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1544: lv_retcode,
1545: 'MSC_WO_MILESTONES',
1546: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1547: MSC_UTIL.G_ERROR);
1548:
1549: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1551: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 1549: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1545: 'MSC_WO_MILESTONES',
1546: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1547: MSC_UTIL.G_ERROR);
1548:
1549: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1551: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1552: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1553: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

1546: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1547: MSC_UTIL.G_ERROR);
1548:
1549: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1551: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1552: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1553: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1554: END IF;

Line 1552: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1548:
1549: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1551: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1552: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1553: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1554: END IF;
1555:
1556: END IF;

Line 1553: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1549: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1551: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1552: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1553: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1554: END IF;
1555:
1556: END IF;
1557: commit;

Line 1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');

1583: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1584: lv_supplies_tbl VARCHAR2(30);
1585: BEGIN
1586:
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_WO_SUB_COMP ');
1588: -- We do not support net-change collection for the table msc_wo_sub_comp
1589: -- at this time.
1590: -- Hence, we need to delete from this table for all types of
1591: -- collection (targeted or net-change)

Line 1598: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1594: MSC_CL_COLLECTION.v_is_partial_refresh OR
1595: MSC_CL_COLLECTION.v_is_incremental_refresh) THEN
1596:
1597: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
1598: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1599: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_SUB_COMP',
1600: MSC_CL_COLLECTION.v_instance_id,
1601: -1);
1602: ELSE

Line 1603: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1599: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_SUB_COMP',
1600: MSC_CL_COLLECTION.v_instance_id,
1601: -1);
1602: ELSE
1603: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1604: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_SUB_COMP',
1605: MSC_CL_COLLECTION.v_instance_id,
1606: null,
1607: v_sub_str);

Line 1613: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1609: END IF;
1610:
1611: COMMIT;
1612:
1613: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1614: lv_tbl:= 'WO_SUB_COMP_'||MSC_CL_COLLECTION.v_instance_code;
1615: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1616: ELSE
1617: lv_tbl:= 'MSC_WO_SUB_COMP';

Line 1620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

1616: ELSE
1617: lv_tbl:= 'MSC_WO_SUB_COMP';
1618: lv_supplies_tbl:= 'MSC_SUPPLIES';
1619: END IF;
1620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1621: 'In Procedure LOAD_WO_SUB_COMP, lv_tbl: '||lv_tbl);
1622:
1623: lv_cursor_stmt:=
1624: 'INSERT INTO '||lv_tbl

Line 1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

1669: ||' AND MIL2.sr_instance_id = msw.sr_instance_id'
1670: ||' AND MIL2.SR_INVENTORY_ITEM_ID = msw.ALTERNATE_COMPONENT_ID';
1671:
1672:
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1674: 'In Procedure LOAD_WO_SUB_COMP lv_cursor_stmt: '|| lv_cursor_stmt);
1675: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
1676: MSC_CL_COLLECTION.v_is_partial_refresh OR
1677: MSC_CL_COLLECTION.v_is_incremental_refresh) THEN

Line 1688: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1684: MSC_CL_COLLECTION.v_current_user;
1685: END IF;
1686:
1687:
1688: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1689: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1690: lv_retcode,
1691: 'MSC_WO_SUB_COMP',
1692: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 1693: MSC_UTIL.G_ERROR);

1689: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1690: lv_retcode,
1691: 'MSC_WO_SUB_COMP',
1692: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1693: MSC_UTIL.G_ERROR);
1694:
1695: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1697: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 1695: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1691: 'MSC_WO_SUB_COMP',
1692: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1693: MSC_UTIL.G_ERROR);
1694:
1695: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1697: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1698: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1699: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

1692: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1693: MSC_UTIL.G_ERROR);
1694:
1695: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1697: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1698: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1699: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1700: END IF;

Line 1698: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1694:
1695: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1697: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1698: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1699: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1700: END IF;
1701: END IF;
1702: COMMIT;

Line 1699: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1695: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1697: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1698: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1699: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1700: END IF;
1701: END IF;
1702: COMMIT;
1703:

Line 1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

1711: lv_cursor_stmt VARCHAR2(32767);
1712: lv_sql_stmt VARCHAR2(32767);
1713:
1714: BEGIN
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1716: 'In Procedure LOAD_CMRO_FORECAST_SUPPLIES ');
1717:
1718: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1719: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

Line 1718: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1714: BEGIN
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1716: 'In Procedure LOAD_CMRO_FORECAST_SUPPLIES ');
1717:
1718: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1719: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1720: ELSE
1721: lv_supplies_tbl:= 'MSC_SUPPLIES';
1722: END IF;

Line 1756: ||' AND ms.DELETED_FLAG = '|| MSC_UTIL.SYS_NO

1752: ||' MSC_ST_SUPPLIES ms,'
1753: ||' MSC_DESIGNATORS md'
1754: ||' WHERE t1.SR_INVENTORY_ITEM_ID= -1003'
1755: ||' AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
1756: ||' AND ms.DELETED_FLAG = '|| MSC_UTIL.SYS_NO
1757: ||' AND ms.SCHEDULE_DESIGNATOR_ID = md.SRC_SIM_FCST_ID'
1758: ||' AND md.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
1759: ||' AND md.DESIGNATOR_TYPE = 13'
1760: ||' AND md.organization_id = -23453'

Line 1799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1795: || lv_cursor_stmt;
1796:
1797: BEGIN
1798:
1799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1800: 'The Insert statement is: ' || lv_sql_stmt);
1801:
1802: SAVEPOINT Load_cmro_sup;
1803: EXECUTE IMMEDIATE lv_sql_stmt

Line 1811: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

1807: MSC_CL_COLLECTION.v_current_user,
1808: MSC_CL_COLLECTION.v_current_date,
1809: MSC_CL_COLLECTION.v_current_user;
1810:
1811: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
1812: 'The number of rows inserted is: ' || SQL%ROWCOUNT);
1813: COMMIT;
1814: RETURN;
1815:

Line 1819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

1815:
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818:
1819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1820: IF lv_sql_stmt IS NOT NULL THEN
1821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
1822: END IF;
1823: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);

1817: WHEN OTHERS THEN
1818:
1819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1820: IF lv_sql_stmt IS NOT NULL THEN
1821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
1822: END IF;
1823: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1824:
1825: ROLLBACK WORK TO SAVEPOINT Load_cmro_sup;

Line 1823: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1820: IF lv_sql_stmt IS NOT NULL THEN
1821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
1822: END IF;
1823: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1824:
1825: ROLLBACK WORK TO SAVEPOINT Load_cmro_sup;
1826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
1827:

Line 1826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');

1822: END IF;
1823: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1824:
1825: ROLLBACK WORK TO SAVEPOINT Load_cmro_sup;
1826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
1827:
1828: END;
1829:
1830: END IF;

Line 1843: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1839: lv_sql_stmt VARCHAR2(32767);
1840: lv_supplies_tbl VARCHAR2(30);
1841:
1842: BEGIN
1843: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1844: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1845: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1846: ELSE
1847: lv_tbl:= 'MSC_DEMANDS';

Line 1879: --||' AND ms.DELETED_FLAG ='|| MSC_UTIL.SYS_NO

1875: ||' MSC_DESIGNATORS md1 ,'
1876: ||' MSC_ST_DEMANDS md,'
1877: || lv_supplies_tbl||' ms'
1878: ||' WHERE ms.MAINTENANCE_OBJECT_SOURCE = 2'
1879: --||' AND ms.DELETED_FLAG ='|| MSC_UTIL.SYS_NO
1880: ||' AND ms.ORDER_TYPE = 92 '
1881: ||' AND md.SR_INSTANCE_ID= '|| MSC_CL_COLLECTION.v_instance_id
1882: ||' AND t1.SR_INVENTORY_ITEM_ID= md.inventory_item_id '
1883: ||' AND t1.sr_instance_id= '|| MSC_CL_COLLECTION.v_instance_id

Line 1942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

1938:
1939: EXCEPTION
1940: WHEN OTHERS THEN
1941:
1942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1943: IF lv_sql_stmt IS NOT NULL THEN
1944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
1945: END IF;
1946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);

1940: WHEN OTHERS THEN
1941:
1942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1943: IF lv_sql_stmt IS NOT NULL THEN
1944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
1945: END IF;
1946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1947:
1948: ROLLBACK WORK TO SAVEPOINT Load_cmro_dem;

Line 1946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1943: IF lv_sql_stmt IS NOT NULL THEN
1944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
1945: END IF;
1946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1947:
1948: ROLLBACK WORK TO SAVEPOINT Load_cmro_dem;
1949: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
1950:

Line 1949: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');

1945: END IF;
1946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1947:
1948: ROLLBACK WORK TO SAVEPOINT Load_cmro_dem;
1949: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
1950:
1951: END;
1952:
1953: END IF;

Line 1968: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

1964: lv_sql_stmt VARCHAR2(32767);
1965:
1966: BEGIN
1967:
1968: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1969: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
1970: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1971: ELSE
1972: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';

Line 2007: --||' AND mrr.DELETED_FLAG ='|| MSC_UTIL.SYS_NO

2003: ||' FROM MSC_ST_RESOURCE_REQUIREMENTS mrr, '
2004: ||' MSC_DESIGNATORS md1 ,'
2005: || lv_supplies_tbl||' ms'
2006: ||' WHERE ms.MAINTENANCE_OBJECT_SOURCE = 2'
2007: --||' AND mrr.DELETED_FLAG ='|| MSC_UTIL.SYS_NO
2008: ||' AND ms.ORDER_TYPE = 92'
2009: ||' AND mrr.MAINTENANCE_OBJECT_SOURCE = 2'
2010: ||' AND nvl(mrr.OPERATING_FLEET,1) = nvl(ms.OPERATING_FLEET,1)'
2011: ||' AND mrr.MAINTENANCE_REQUIREMENT = ms.MAINTENANCE_REQUIREMENT'

Line 2012: --||' AND ms.DELETED_FLAG ='|| MSC_UTIL.SYS_NO

2008: ||' AND ms.ORDER_TYPE = 92'
2009: ||' AND mrr.MAINTENANCE_OBJECT_SOURCE = 2'
2010: ||' AND nvl(mrr.OPERATING_FLEET,1) = nvl(ms.OPERATING_FLEET,1)'
2011: ||' AND mrr.MAINTENANCE_REQUIREMENT = ms.MAINTENANCE_REQUIREMENT'
2012: --||' AND ms.DELETED_FLAG ='|| MSC_UTIL.SYS_NO
2013: ||' AND ms.PLAN_ID = -1'
2014: ||' AND mrr.supply_type = 92'
2015: ||' AND ms.SCHEDULE_DESIGNATOR_ID = md1.DESIGNATOR_ID'
2016: ||' AND ms.SOURCE_ITEM_ID =mrr.INVENTORY_ITEM_ID'

Line 2074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

2070:
2071: EXCEPTION
2072: WHEN OTHERS THEN
2073:
2074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2075: IF lv_sql_stmt IS NOT NULL THEN
2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2077: END IF;
2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);

2072: WHEN OTHERS THEN
2073:
2074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2075: IF lv_sql_stmt IS NOT NULL THEN
2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2077: END IF;
2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2079:
2080: ROLLBACK WORK TO SAVEPOINT Load_cmro_res;

Line 2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2075: IF lv_sql_stmt IS NOT NULL THEN
2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2077: END IF;
2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2079:
2080: ROLLBACK WORK TO SAVEPOINT Load_cmro_res;
2081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
2082:

Line 2081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');

2077: END IF;
2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2079:
2080: ROLLBACK WORK TO SAVEPOINT Load_cmro_res;
2081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
2082:
2083: END;
2084:
2085: END IF;--MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh

Line 2104: WHERE deleted_flag = MSC_UTIL.SYS_NO

2100: SUBINVENTORY,
2101: TASK_ID,
2102: PROJECT_ID
2103: FROM MSC_ST_RESERVATIONS
2104: WHERE deleted_flag = MSC_UTIL.SYS_NO
2105: AND SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;
2106:
2107: CURSOR c_del IS
2108: SELECT TRANSACTION_ID,

Line 2112: WHERE deleted_flag = MSC_UTIL.SYS_YES

2108: SELECT TRANSACTION_ID,
2109: ORGANIZATION_ID,
2110: SR_INSTANCE_ID
2111: FROM MSC_ST_RESERVATIONS
2112: WHERE deleted_flag = MSC_UTIL.SYS_YES
2113: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
2114: BEGIN
2115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
2116: -- This code is being commented out as we are handling CMRO reservations in MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION

Line 2115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');

2111: FROM MSC_ST_RESERVATIONS
2112: WHERE deleted_flag = MSC_UTIL.SYS_YES
2113: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
2114: BEGIN
2115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
2116: -- This code is being commented out as we are handling CMRO reservations in MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION
2117: /*
2118: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
2119: MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 2121: MSC_UTIL.G_ALL_ORGANIZATIONS THEN

2117: /*
2118: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
2119: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2120: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
2121: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS',
2123: MSC_CL_COLLECTION.v_instance_id,
2124: -1);
2125: ELSE

Line 2126: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str

2122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS',
2123: MSC_CL_COLLECTION.v_instance_id,
2124: -1);
2125: ELSE
2126: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
2127: ||' AND RESERVATION_TYPE in (15,16,17)';
2128: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS',
2129: MSC_CL_COLLECTION.v_instance_id,
2130: -1,

Line 2146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

2142: AND RESERVATION_TYPE in (15,16,17);
2143:
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
2147: 'An error has occurred during deletion of MSC_RESERVATIONS.');
2148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2149: RAISE;
2150: END;

Line 2148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
2147: 'An error has occurred during deletion of MSC_RESERVATIONS.');
2148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2149: RAISE;
2150: END;
2151: END LOOP;
2152:

Line 2157: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

2153: COMMIT;
2154:
2155: BEGIN
2156:
2157: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2158: 'In Procedure LOAD_SUPPLY_RESERVATIONS ');
2159:
2160: lv_cursor_stmt:=
2161: 'INSERT INTO MSC_RESERVATIONS'

Line 2215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

2211: ||MSC_CL_COLLECTION.v_instance_id
2212: ||' AND mil.sr_instance_id = ms.sr_instance_id'
2213: ||' AND mil.SR_INVENTORY_ITEM_ID = ms.INVENTORY_ITEM_ID';
2214:
2215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2216: 'In Procedure LOAD_SUPPLY_RESERVATIONS lv_cursor_stmt: '|| lv_cursor_stmt);
2217: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
2218: MSC_CL_COLLECTION.v_is_partial_refresh) OR
2219: (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN

Line 2258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2254: END IF;
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2259: RAISE;
2260: END;
2261:
2262: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 2262: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

2258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2259: RAISE;
2260: END;
2261:
2262: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2263: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2264: lv_retcode,
2265: 'MSC_RESERVATIONS',
2266: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 2267: MSC_UTIL.G_ERROR);

2263: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2264: lv_retcode,
2265: 'MSC_RESERVATIONS',
2266: MSC_CL_COLLECTION.v_INSTANCE_CODE,
2267: MSC_UTIL.G_ERROR);
2268:
2269: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2271: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 2269: IF lv_retcode = MSC_UTIL.G_ERROR THEN

2265: 'MSC_RESERVATIONS',
2266: MSC_CL_COLLECTION.v_INSTANCE_CODE,
2267: MSC_UTIL.G_ERROR);
2268:
2269: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2271: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2272: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2273: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 2270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

2266: MSC_CL_COLLECTION.v_INSTANCE_CODE,
2267: MSC_UTIL.G_ERROR);
2268:
2269: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2271: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2272: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2273: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2274: END IF;

Line 2272: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

2268:
2269: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2271: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2272: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2273: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2274: END IF;
2275: END IF;
2276: COMMIT;

Line 2273: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2269: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2271: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2272: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2273: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2274: END IF;
2275: END IF;
2276: COMMIT;
2277: */

Line 2321: AND ms.deleted_flag = MSC_UTIL.SYS_NO

2317: FROM MSC_ST_SUPPLIES ms,
2318: MSC_ITEM_ID_LID t1
2319: WHERE t1.SR_INVENTORY_ITEM_ID= ms.INVENTORY_ITEM_ID
2320: AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID
2321: AND ms.deleted_flag = MSC_UTIL.SYS_NO
2322: AND ms.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2323: AND ms.order_type=90;
2324:
2325: CURSOR c_del IS

Line 2331: WHERE deleted_flag = MSC_UTIL.SYS_YES

2327: ORDER_TYPE,
2328: ORGANIZATION_ID,
2329: SR_INSTANCE_ID
2330: FROM MSC_ST_SUPPLIES
2331: WHERE deleted_flag = MSC_UTIL.SYS_YES
2332: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2333: AND order_type=90;
2334:
2335: BEGIN

Line 2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

2332: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2333: AND order_type=90;
2334:
2335: BEGIN
2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2337: 'In Procedure LOAD_CLOSED_CMRO_WOS ');
2338: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2339: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2340: ELSE

Line 2338: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

2334:
2335: BEGIN
2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2337: 'In Procedure LOAD_CLOSED_CMRO_WOS ');
2338: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2339: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2340: ELSE
2341: lv_tbl:= 'MSC_SUPPLIES';
2342: END IF;

Line 2345: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

2341: lv_tbl:= 'MSC_SUPPLIES';
2342: END IF;
2343:
2344: BEGIN
2345: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
2346: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2347: ELSE
2348: lv_tbl:= 'MSC_SUPPLIES';
2349: END IF;

Line 2397: ||' AND ms.deleted_flag = '||MSC_UTIL.SYS_NO

2393: ||' FROM MSC_ITEM_ID_LID t1, '
2394: ||' MSC_ST_SUPPLIES ms '
2395: ||'WHERE t1.SR_INVENTORY_ITEM_ID= ms.INVENTORY_ITEM_ID '
2396: ||' AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID '
2397: ||' AND ms.deleted_flag = '||MSC_UTIL.SYS_NO
2398: ||' AND ms.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2399: ||' AND ms.order_type=90';
2400:
2401: v_sql_stmt:=

Line 2470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

2466: AND ORDER_TYPE= c_rec.ORDER_TYPE
2467: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
2471: 'An error has occurred during deletion of ordertype 90 supplies.');
2472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2473: RAISE;
2474: END;

Line 2472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
2471: 'An error has occurred during deletion of ordertype 90 supplies.');
2472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2473: RAISE;
2474: END;
2475: END LOOP;
2476: COMMIT;

Line 2645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2641: END IF;
2642:
2643: EXCEPTION
2644: WHEN OTHERS THEN
2645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2646: RAISE;
2647: END;
2648:
2649: commit;

Line 2653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in ods load -LOAD_CLOSED_CMRO_WOS '||SQLERRM);

2649: commit;
2650: EXCEPTION
2651: WHEN OTHERS THEN
2652:
2653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in ods load -LOAD_CLOSED_CMRO_WOS '||SQLERRM);
2654: RAISE;
2655: END LOAD_CLOSED_CMRO_WOS;
2656:
2657:

Line 2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

2662: lv_cursor_stmt VARCHAR2(32767);
2663: lv_sql_stmt VARCHAR2(32767);
2664:
2665: BEGIN
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2667: 'In Procedure LOAD_OSP_SUPPLY ');
2668:
2669: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
2670: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

Line 2669: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN

2665: BEGIN
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2667: 'In Procedure LOAD_OSP_SUPPLY ');
2668:
2669: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
2670: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2671: ELSE
2672: lv_supplies_tbl:= 'MSC_SUPPLIES';
2673: END IF;

Line 2705: ||' AND ms.deleted_flag = ' || MSC_UTIL.SYS_NO

2701: ||' MSC_TP_ID_LID tp,'
2702: ||' MSC_TP_SITE_ID_LID tps'
2703: ||' WHERE t1.SR_INVENTORY_ITEM_ID= ms.INVENTORY_ITEM_ID'
2704: ||' AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'
2705: ||' AND ms.deleted_flag = ' || MSC_UTIL.SYS_NO
2706: ||' AND ms.SR_INSTANCE_ID= '|| MSC_CL_COLLECTION.v_instance_id
2707: ||' AND ms.order_type=74'
2708: ||' AND ms.COLL_ORDER_TYPE = 974'
2709: ||' AND tp.SR_TP_ID(+)= ms.SUPPLIER_ID'

Line 2744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

2740: || lv_cursor_stmt;
2741:
2742: BEGIN
2743:
2744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
2745: 'The Insert statement is: ' || lv_sql_stmt);
2746:
2747:
2748: EXECUTE IMMEDIATE lv_sql_stmt

Line 2756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

2752: MSC_CL_COLLECTION.v_current_user,
2753: MSC_CL_COLLECTION.v_current_date,
2754: MSC_CL_COLLECTION.v_current_user;
2755:
2756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2757: 'The number of rows inserted is: ' || SQL%ROWCOUNT);
2758: COMMIT;
2759: RETURN;
2760:

Line 2764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

2760:
2761: EXCEPTION
2762: WHEN OTHERS THEN
2763:
2764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2765: IF lv_sql_stmt IS NOT NULL THEN
2766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2767: END IF;
2768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);

2762: WHEN OTHERS THEN
2763:
2764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2765: IF lv_sql_stmt IS NOT NULL THEN
2766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2767: END IF;
2768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2769:
2770: END;

Line 2768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2765: IF lv_sql_stmt IS NOT NULL THEN
2766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2767: END IF;
2768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2769:
2770: END;
2771:
2772: END IF;