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

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_UTIL

Line 6: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed

2: /* $Header: MSCLRTGB.pls 120.9.12020000.2 2013/02/13 11:17:24 swundapa ship $ */
3:
4: v_sub_str VARCHAR2(32767):=NULL;
5: c_count NUMBER:= 0;
6: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed
7:
8: -- G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
9: -- To collect SRP Data when this profile is set to Yes neds to be deleted
10: -- v_is_cont_refresh BOOLEAN;

Line 46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

42:
43: BEGIN
44:
45: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh)) THEN
46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
48: ELSE
49: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_STD_OP_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */
50: END IF;

Line 112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

108: WHEN OTHERS THEN
109:
110: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
111:
112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
113: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
114: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STD_OP_RESOURCES');
115: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
113: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
114: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STD_OP_RESOURCES');
115: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
117:
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
119: RAISE;
120: ELSE

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

114: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STD_OP_RESOURCES');
115: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
117:
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
119: RAISE;
120: ELSE
121: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
122:

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

117:
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
119: RAISE;
120: ELSE
121: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
122:
123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STD_OP_RESOURCES');

Line 123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

119: RAISE;
120: ELSE
121: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
122:
123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STD_OP_RESOURCES');
126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STD_OP_RESOURCES');
126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.OPERATION_CODE);

Line 132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.OPERATION_CODE);
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
133:
134: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
135: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
136: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

Line 137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

133:
134: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
135: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
136: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
138:
139: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
140: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
141: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_SEQ_NUM);

Line 142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

138:
139: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
140: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
141: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_SEQ_NUM);
142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
143:
144:
145: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
146: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');

Line 149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

145: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
146: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
147: FND_MESSAGE.SET_TOKEN('VALUE', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
148: MSC_CL_COLLECTION.v_instance_id));
149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
151: END IF;
152:
153: END;

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

146: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
147: FND_MESSAGE.SET_TOKEN('VALUE', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
148: MSC_CL_COLLECTION.v_instance_id));
149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
151: END IF;
152:
153: END;
154:

Line 156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total std op resources = '|| to_char(total_count));

152:
153: END;
154:
155: END LOOP;
156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total std op resources = '|| to_char(total_count));
157: COMMIT;
158:
159: END IF; /* MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh */
160:

Line 218: AND mon.DELETED_FLAG = MSC_UTIL.SYS_NO

214: mon.SR_INSTANCE_ID
215: from MSC_ST_OPERATION_NETWORKS mon,
216: MSC_ITEM_ID_LID t1 /* ds change change */
217: WHERE mon.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
218: AND mon.DELETED_FLAG = MSC_UTIL.SYS_NO
219: AND mon.FROM_ITEM_ID = t1.SR_INVENTORY_ITEM_ID(+) /* ds change change */
220: AND mon.sr_instance_id = t1.sr_instance_id(+) ; /* ds change change */
221:
222:

Line 232: and mon.DELETED_FLAG= MSC_UTIL.SYS_YES;

228: mon.REFRESH_ID,
229: mon.SR_INSTANCE_ID
230: FROM MSC_ST_OPERATION_NETWORKS mon
231: WHERE mon.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
232: and mon.DELETED_FLAG= MSC_UTIL.SYS_YES;
233:
234: c_count NUMBER:= 0;
235: lv_tbl VARCHAR2(30);
236: lv_sql_stmt VARCHAR2(5000);

Line 242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

238: BEGIN
239:
240: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
241:
242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE
245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

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

241:
242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE
245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
247: END IF;
248:
249: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

Line 424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

420: WHEN OTHERS THEN
421:
422: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
423:
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
425: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
426: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
427: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
425: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
426: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
427: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
429:
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
431: RAISE;
432:

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

426: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
427: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
429:
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
431: RAISE;
432:
433: ELSE
434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
431: RAISE;
432:
433: ELSE
434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
435:
436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
437: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
438: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');

Line 436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

432:
433: ELSE
434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
435:
436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
437: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
438: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
439: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
437: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
438: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
439: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
441:
442: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
443: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_OP_SEQ_ID');
444: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.FROM_OP_SEQ_ID));

Line 445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

441:
442: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
443: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_OP_SEQ_ID');
444: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.FROM_OP_SEQ_ID));
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
446:
447: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
448: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_OP_SEQ_ID');
449: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.TO_OP_SEQ_ID));

Line 450: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

446:
447: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
448: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_OP_SEQ_ID');
449: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.TO_OP_SEQ_ID));
450: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
451:
452: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
453: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_OP_SEQ_NUM');
454: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.FROM_OP_SEQ_NUM));

Line 455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

451:
452: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
453: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_OP_SEQ_NUM');
454: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.FROM_OP_SEQ_NUM));
455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
456:
457: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
458: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_OP_SEQ_NUM');
459: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.TO_OP_SEQ_NUM));

Line 460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

456:
457: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
458: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_OP_SEQ_NUM');
459: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.TO_OP_SEQ_NUM));
460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
461:
462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
463: END IF;
464: END;

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

458: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_OP_SEQ_NUM');
459: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.TO_OP_SEQ_NUM));
460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
461:
462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
463: END IF;
464: END;
465:
466: END LOOP;

Line 501: AND msr.DELETED_FLAG= MSC_UTIL.SYS_NO;

497: MSC_ST_ROUTINGS msr
498: WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id
499: AND t1.sr_instance_id= msr.sr_instance_id
500: AND msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
501: AND msr.DELETED_FLAG= MSC_UTIL.SYS_NO;
502:
503: CURSOR c4_d IS
504: SELECT
505: msr.ROUTING_SEQUENCE_ID,

Line 509: AND msr.DELETED_FLAG= MSC_UTIL.SYS_YES;

505: msr.ROUTING_SEQUENCE_ID,
506: msr.SR_INSTANCE_ID
507: FROM MSC_ST_ROUTINGS msr
508: WHERE msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
509: AND msr.DELETED_FLAG= MSC_UTIL.SYS_YES;
510:
511:
512: c_count NUMBER:= 0;
513: lv_tbl VARCHAR2(30);

Line 525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

521: -- We want to delete all ROUTING related data and get new stuff.
522:
523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
524:
525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE
528: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

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

524:
525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE
528: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
530: END IF;
531:
532: BEGIN

Line 589: ||' AND msr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;

585: ||' MSC_ST_ROUTINGS msr'
586: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id'
587: ||' AND t1.sr_instance_id= msr.sr_instance_id'
588: ||' AND msr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
589: ||' AND msr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
590:
591: EXECUTE IMMEDIATE lv_sql_ins
592: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
593:

Line 595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'routings loaded');

591: EXECUTE IMMEDIATE lv_sql_ins
592: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
593:
594: COMMIT;
595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'routings loaded');
596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN

Line 601: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

597: EXCEPTION
598: WHEN OTHERS THEN
599: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
600:
601: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

601: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
608: RAISE;
609:

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

603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
608: RAISE;
609:
610: ELSE
611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

Line 611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
608: RAISE;
609:
610: ELSE
611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
612: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
613: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
614: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
612: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
613: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
614: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
618:
619: --If Direct path load results in warning then the processing has to be

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

613: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
614: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
618:
619: --If Direct path load results in warning then the processing has to be
620: --switched back to row by row processing. This will help to identify the
621: --erroneous record and will also help in processing the rest of the records.

Line 622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - routings');

618:
619: --If Direct path load results in warning then the processing has to be
620: --switched back to row by row processing. This will help to identify the
621: --erroneous record and will also help in processing the rest of the records.
622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - routings');
623: lb_refresh_failed := TRUE;
624: END IF;
625: END;
626:

Line 749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

745: WHEN OTHERS THEN
746:
747: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
748:
749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
750: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
751: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
752: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
750: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
751: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
752: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
754:
755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
756: RAISE;
757:

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

751: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
752: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
754:
755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
756: RAISE;
757:
758: ELSE
759: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
756: RAISE;
757:
758: ELSE
759: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
760:
761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
762: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
763: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');

Line 761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

757:
758: ELSE
759: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
760:
761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
762: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
763: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
764: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
762: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
763: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
764: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
766:
767: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
768: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
769: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.ASSEMBLY_ITEM_ID));

Line 770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

766:
767: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
768: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
769: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.ASSEMBLY_ITEM_ID));
770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
771:
772: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
773: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
774: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

Line 775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

771:
772: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
773: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
774: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
776:
777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
778: END IF;
779: END;

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

773: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
774: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
776:
777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
778: END IF;
779: END;
780:
781: END LOOP;

Line 802: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;

798: ROUTING_SEQUENCE_ID,
799: SR_INSTANCE_ID
800: FROM MSC_ST_OPERATION_COMPONENTS msoc
801: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
802: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
803:
804: CURSOR c9_d IS
805: SELECT
806: OPERATION_SEQUENCE_ID,

Line 814: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_YES

810: SR_INSTANCE_ID,
811: ORGANIZATION_ID
812: FROM MSC_ST_OPERATION_COMPONENTS msoc
813: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
814: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_YES
815: UNION ALL
816: SELECT DISTINCT
817: TO_NUMBER(NULL),
818: TO_NUMBER(NULL),

Line 830: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO

826: AND msoc.Routing_Sequence_ID <> moc.Routing_Sequence_ID
827: AND msoc.Organization_ID= moc.Organization_ID
828: AND msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
829: AND moc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
830: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO
831: AND moc.PLAN_ID= -1;
832:
833:
834: c_count NUMBER:= 0;

Line 848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

844: -- We want to delete all BOM related data and get new stuff.
845:
846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
847:
848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE
851: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

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

847:
848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE
851: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
853: END IF;
854: BEGIN
855: INSERT /*+ append */

Line 884: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;

880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user
882: FROM MSC_ST_OPERATION_COMPONENTS msoc
883: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
884: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
885:
886: COMMIT;
887: EXCEPTION
888: WHEN OTHERS THEN

Line 892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

888: WHEN OTHERS THEN
889:
890: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
891:
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
899: RAISE;
900: ELSE

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

894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
899: RAISE;
900: ELSE
901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

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

897:
898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
899: RAISE;
900: ELSE
901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
903: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
904: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
905: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');

Line 902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
899: RAISE;
900: ELSE
901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
903: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
904: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
905: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
903: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
904: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
905: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
907:
908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
909: lb_refresh_failed := TRUE;
910: END IF;

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

904: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
905: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
907:
908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
909: lb_refresh_failed := TRUE;
910: END IF;
911: END;
912: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

Line 968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

964: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
965: */
966: EXCEPTION
967: WHEN OTHERS THEN
968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
969: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
970: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
971: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
969: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
970: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
971: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
973:
974: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
975: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
976: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));

Line 977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

973:
974: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
975: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
976: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));
977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
978:
979: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
980: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
981: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));

Line 982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

978:
979: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
980: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
981: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
983:
984: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
985: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
986: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

Line 987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

983:
984: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
985: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
986: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
988:
989: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
990: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
991: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));

Line 992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

988:
989: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
990: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
991: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
993:
994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
995:
996: END;

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

990: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
991: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
993:
994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
995:
996: END;
997:
998: END LOOP;

Line 1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1064: WHEN OTHERS THEN
1065:
1066: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1067:
1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1069: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1070: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
1071: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1069: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1070: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
1071: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1073:
1074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1075: RAISE;
1076:

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

1070: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
1071: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1073:
1074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1075: RAISE;
1076:
1077: ELSE
1078: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1075: RAISE;
1076:
1077: ELSE
1078: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1079:
1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1081: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');

Line 1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1076:
1077: ELSE
1078: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1079:
1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1081: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
1083: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1081: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
1083: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1087: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1088: FND_MESSAGE.SET_TOKEN('VALUE', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID, MSC_CL_COLLECTION.v_instance_id));

Line 1089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1085:
1086: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1087: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1088: FND_MESSAGE.SET_TOKEN('VALUE', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID, MSC_CL_COLLECTION.v_instance_id));
1089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1090:
1091: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1092: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
1093: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));

Line 1094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1090:
1091: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1092: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
1093: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));
1094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1095:
1096: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1097: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
1098: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));

Line 1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1095:
1096: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1097: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
1098: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1102: END IF;
1103:

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

1097: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
1098: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1102: END IF;
1103:
1104: END;
1105:

Line 1130: AND msors.DELETED_FLAG= MSC_UTIL.SYS_NO;

1126: msors.SR_INSTANCE_ID,
1127: msors.ORGANIZATION_ID
1128: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1129: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1130: AND msors.DELETED_FLAG= MSC_UTIL.SYS_NO;
1131:
1132: CURSOR c7_d IS
1133: SELECT
1134: msors.ROUTING_SEQUENCE_ID,

Line 1140: AND msors.DELETED_FLAG= MSC_UTIL.SYS_YES;

1136: msors.RESOURCE_SEQ_NUM,
1137: msors.SR_INSTANCE_ID
1138: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1139: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1140: AND msors.DELETED_FLAG= MSC_UTIL.SYS_YES;
1141:
1142:
1143: c_count NUMBER:= 0;
1144: lv_tbl VARCHAR2(30);

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

1150: lv_retcode NUMBER;
1151:
1152: BEGIN
1153:
1154: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1155: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1156: ELSE
1157: lv_tbl:= 'MSC_OPERATION_RESOURCE_SEQS';
1158: END IF;

Line 1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

1160: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1161: -- We want to delete all BOM related data and get new stuff.
1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1163:
1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1167: ELSE
1168: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1161: -- We want to delete all BOM related data and get new stuff.
1162: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1163:
1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1167: ELSE
1168: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1169: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

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

1164: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1165: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1166: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1167: ELSE
1168: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1169: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1170: END IF;
1171: END IF;
1172:

Line 1210: ||' AND msors.DELETED_FLAG= '||MSC_UTIL.SYS_NO

1206: ||' :v_current_date,'
1207: ||' :v_current_user '
1208: ||' FROM MSC_ST_OPERATION_RESOURCE_SEQS msors'
1209: ||' WHERE msors.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1210: ||' AND msors.DELETED_FLAG= '||MSC_UTIL.SYS_NO
1211: ||' GROUP BY '
1212: ||' msors.ROUTING_SEQUENCE_ID, '
1213: ||' msors.OPERATION_SEQUENCE_ID, '
1214: ||' msors.RESOURCE_SEQ_NUM,'

Line 1221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resource seqs loaded');

1217: EXECUTE IMMEDIATE lv_sql_ins
1218: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
1219:
1220: COMMIT;
1221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resource seqs loaded');
1222:
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN

Line 1227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1226:
1227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1232:
1233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1234: RAISE;
1235:

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

1229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1232:
1233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1234: RAISE;
1235:
1236: ELSE
1237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

Line 1237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1234: RAISE;
1235:
1236: ELSE
1237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1238: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1239: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1240: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1238: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1239: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1240: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1242:
1243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1244:
1245: --If Direct path load results in warning then the processing has to be

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

1239: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1240: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1242:
1243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1244:
1245: --If Direct path load results in warning then the processing has to be
1246: --switched back to row by row processing. This will help to identify the
1247: --erroneous record and will also help in processing the rest of the records.

Line 1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - operation resource seqs');

1244:
1245: --If Direct path load results in warning then the processing has to be
1246: --switched back to row by row processing. This will help to identify the
1247: --erroneous record and will also help in processing the rest of the records.
1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - operation resource seqs');
1249: lb_refresh_failed := TRUE;
1250: END IF;
1251: END;
1252:

Line 1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1373: WHEN OTHERS THEN
1374:
1375: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1376:
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1378: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1380: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1378: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1380: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1382:
1383: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1384: RAISE;
1385:

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

1379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1380: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1382:
1383: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1384: RAISE;
1385:
1386: ELSE
1387: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1383: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1384: RAISE;
1385:
1386: ELSE
1387: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1388:
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1390: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1391: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');

Line 1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1385:
1386: ELSE
1387: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1388:
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1390: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1391: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1392: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1390: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1391: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1392: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1394:
1395: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1396: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1397: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

Line 1398: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1394:
1395: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1396: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1397: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1398: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1399:
1400: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1401: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
1402: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));

Line 1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1399:
1400: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1401: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
1402: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));
1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1404:
1405: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1406: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
1407: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_SEQ_NUM));

Line 1408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1404:
1405: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1406: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
1407: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_SEQ_NUM));
1408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1409:
1410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1411:
1412: END IF;

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

1406: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
1407: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_SEQ_NUM));
1408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1409:
1410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1411:
1412: END IF;
1413: END;
1414:

Line 1422: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

1418: COMMIT;
1419:
1420: BEGIN
1421:
1422: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1423:
1424: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1425:
1426: lv_sql_stmt:=

Line 1427: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl

1423:
1424: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1425:
1426: lv_sql_stmt:=
1427: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1428: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCE_SEQS'
1429: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1430: ||' AND plan_id = -1 '
1431: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

Line 1428: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCE_SEQS'

1424: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1425:
1426: lv_sql_stmt:=
1427: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1428: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCE_SEQS'
1429: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1430: ||' AND plan_id = -1 '
1431: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1432:

Line 1431: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

1427: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1428: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCE_SEQS'
1429: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1430: ||' AND plan_id = -1 '
1431: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1432:
1433: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1434: EXECUTE IMMEDIATE lv_sql_stmt;
1435:

Line 1433: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

1429: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1430: ||' AND plan_id = -1 '
1431: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1432:
1433: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1434: EXECUTE IMMEDIATE lv_sql_stmt;
1435:
1436: COMMIT;
1437:

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

1436: COMMIT;
1437:
1438: END IF;
1439:
1440: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1441: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1442: lv_retcode,
1443: 'MSC_OPERATION_RESOURCE_SEQS',
1444: MSC_CL_COLLECTION.v_instance_code,

Line 1445: MSC_UTIL.G_WARNING

1441: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1442: lv_retcode,
1443: 'MSC_OPERATION_RESOURCE_SEQS',
1444: MSC_CL_COLLECTION.v_instance_code,
1445: MSC_UTIL.G_WARNING
1446: );
1447:
1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1449: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1444: MSC_CL_COLLECTION.v_instance_code,
1445: MSC_UTIL.G_WARNING
1446: );
1447:
1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1449: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1450: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1451: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1452: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1445: MSC_UTIL.G_WARNING
1446: );
1447:
1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1449: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1450: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1451: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1452: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1453: END IF;

Line 1451: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1447:
1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1449: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1450: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1451: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1452: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1453: END IF;
1454:
1455: END IF;

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

1448: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1449: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1450: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1451: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1452: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1453: END IF;
1454:
1455: END IF;
1456:

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

1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459:
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1461: RAISE;
1462: END;
1463:
1464: END LOAD_OP_RESOURCE_SEQ;

Line 1500: AND msro.DELETED_FLAG= MSC_UTIL.SYS_NO;

1496: msro.SR_INSTANCE_ID,
1497: msro.ORGANIZATION_ID
1498: FROM MSC_ST_ROUTING_OPERATIONS msro
1499: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1500: AND msro.DELETED_FLAG= MSC_UTIL.SYS_NO;
1501:
1502: CURSOR c5_d IS
1503: SELECT
1504: msro.ROUTING_SEQUENCE_ID,

Line 1509: AND msro.DELETED_FLAG= MSC_UTIL.SYS_YES;

1505: msro.OPERATION_SEQUENCE_ID,
1506: msro.SR_INSTANCE_ID
1507: FROM MSC_ST_ROUTING_OPERATIONS msro
1508: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1509: AND msro.DELETED_FLAG= MSC_UTIL.SYS_YES;
1510:
1511:
1512: c_count NUMBER:= 0;
1513: lv_tbl VARCHAR2(30);

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

1519: lv_retcode NUMBER;
1520:
1521: BEGIN
1522:
1523: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1524: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1525: ELSE
1526: lv_tbl:= 'MSC_ROUTING_OPERATIONS';
1527: END IF;

Line 1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

1529: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1530: -- We want to delete all BOM related data and get new stuff
1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1530: -- We want to delete all BOM related data and get new stuff
1531: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1532:
1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

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

1533: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1534: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1536: ELSE
1537: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1539: END IF;
1540: END IF;
1541:

Line 1612: ||' AND msro.DELETED_FLAG= ' || MSC_UTIL.SYS_NO;

1608: ||' :v_current_date, '
1609: ||' :v_current_user '
1610: ||' FROM MSC_ST_ROUTING_OPERATIONS msro '
1611: ||' WHERE msro.SR_INSTANCE_ID= ' || MSC_CL_COLLECTION.v_instance_id
1612: ||' AND msro.DELETED_FLAG= ' || MSC_UTIL.SYS_NO;
1613:
1614: EXECUTE IMMEDIATE lv_sql_ins
1615: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
1616:

Line 1618: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'routing operations loaded');

1614: EXECUTE IMMEDIATE lv_sql_ins
1615: USING v_chr10, v_chr13, MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
1616:
1617: COMMIT;
1618: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'routing operations loaded');
1619:
1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN

Line 1624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1623:
1624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1625: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1626: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1627: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1625: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1626: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1627: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1629:
1630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1631: RAISE;
1632:

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

1626: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1627: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1629:
1630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1631: RAISE;
1632:
1633: ELSE
1634: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

Line 1634: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1631: RAISE;
1632:
1633: ELSE
1634: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1635: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1636: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1637: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1634: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1635: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1636: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1637: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1639:
1640: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1641:
1642: --If Direct path load results in warning then the processing has to be

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

1636: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1637: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1639:
1640: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1641:
1642: --If Direct path load results in warning then the processing has to be
1643: --switched back to row by row processing. This will help to identify the
1644: --erroneous record and will also help in processing the rest of the records.

Line 1645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - routing operations');

1641:
1642: --If Direct path load results in warning then the processing has to be
1643: --switched back to row by row processing. This will help to identify the
1644: --erroneous record and will also help in processing the rest of the records.
1645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - routing operations');
1646: lb_refresh_failed := TRUE;
1647: END IF;
1648: END;
1649:

Line 1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1823: WHEN OTHERS THEN
1824:
1825: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1826:
1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1832:
1833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1834: RAISE;
1835:

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

1829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1832:
1833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1834: RAISE;
1835:
1836: ELSE
1837: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1834: RAISE;
1835:
1836: ELSE
1837: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1838:
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');

Line 1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1835:
1836: ELSE
1837: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1838:
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1842: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1840: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1841: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1842: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1844:
1845: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1846: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1847: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

Line 1848: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1844:
1845: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1846: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1847: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1848: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1849:
1850: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1851: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQ_NUM');
1852: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQ_NUM));

Line 1853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1849:
1850: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1851: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQ_NUM');
1852: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQ_NUM));
1853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1854:
1855: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1856: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
1857: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));

Line 1858: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1854:
1855: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1856: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
1857: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));
1858: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1859:
1860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1861: END IF;
1862: END;

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

1856: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
1857: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));
1858: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1859:
1860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1861: END IF;
1862: END;
1863:
1864: END LOOP;

Line 1871: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

1867: COMMIT;
1868:
1869: BEGIN
1870:
1871: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1872:
1873: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1874:
1875: lv_sql_stmt:=

Line 1876: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl

1872:
1873: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1874:
1875: lv_sql_stmt:=
1876: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'
1878: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1879: ||' AND plan_id = -1 '
1880: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

Line 1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'

1873: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1874:
1875: lv_sql_stmt:=
1876: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'
1878: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1879: ||' AND plan_id = -1 '
1880: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1881:

Line 1880: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

1876: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1877: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ROUTING_OPERATIONS'
1878: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1879: ||' AND plan_id = -1 '
1880: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1881:
1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1883: EXECUTE IMMEDIATE lv_sql_stmt;
1884:

Line 1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

1878: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1879: ||' AND plan_id = -1 '
1880: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1881:
1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1883: EXECUTE IMMEDIATE lv_sql_stmt;
1884:
1885: COMMIT;
1886:

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

1885: COMMIT;
1886:
1887: END IF;
1888:
1889: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1890: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1891: lv_retcode,
1892: 'MSC_ROUTING_OPERATIONS',
1893: MSC_CL_COLLECTION.v_instance_code,

Line 1894: MSC_UTIL.G_WARNING

1890: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1891: lv_retcode,
1892: 'MSC_ROUTING_OPERATIONS',
1893: MSC_CL_COLLECTION.v_instance_code,
1894: MSC_UTIL.G_WARNING
1895: );
1896:
1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1893: MSC_CL_COLLECTION.v_instance_code,
1894: MSC_UTIL.G_WARNING
1895: );
1896:
1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1899: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1900: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1894: MSC_UTIL.G_WARNING
1895: );
1896:
1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1899: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1900: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1902: END IF;

Line 1900: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1896:
1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1899: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1900: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1902: END IF;
1903:
1904: END IF;

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

1897: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1899: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1900: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1902: END IF;
1903:
1904: END IF;
1905:

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

1905:
1906: EXCEPTION
1907: WHEN OTHERS THEN
1908:
1909: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1910: RAISE;
1911: END;
1912:
1913:

Line 1943: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO;

1939: msor.orig_resource_seq_num,
1940: msor.BREAKABLE_ACTIVITY_FLAG /*ds change change end */
1941: FROM MSC_ST_OPERATION_RESOURCES msor
1942: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1943: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO;
1944:
1945: CURSOR c6_d IS
1946: SELECT
1947: msor.ROUTING_SEQUENCE_ID,

Line 1955: AND msor.DELETED_FLAG= MSC_UTIL.SYS_YES;

1951: msor.ALTERNATE_NUMBER,
1952: msor.SR_INSTANCE_ID
1953: FROM MSC_ST_OPERATION_RESOURCES msor
1954: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1955: AND msor.DELETED_FLAG= MSC_UTIL.SYS_YES;
1956:
1957: CURSOR c6_corrupt_data IS
1958: SELECT
1959: msor.ROUTING_SEQUENCE_ID,

Line 1964: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO

1960: msor.RESOURCE_ID,
1961: msor.RESOURCE_SEQ_NUM
1962: FROM MSC_ST_OPERATION_RESOURCES msor
1963: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1964: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO
1965: AND nvl(msor.RESOURCE_SEQ_NUM,0)=0
1966: AND msor.ALTERNATE_NUMBER > 0;
1967:
1968: c_count NUMBER:= 0;

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

1977: lv_delete_flag BOOLEAN:= FALSE;
1978:
1979: BEGIN
1980:
1981: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1982: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1983: ELSE
1984: lv_tbl:= 'MSC_OPERATION_RESOURCES';
1985: END IF;

Line 1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

1988:
1989: -- We want to delete all BOM related data and get new stuff.
1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1989: -- We want to delete all BOM related data and get new stuff.
1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

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

1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1998: END IF;
1999: END IF;
2000:

Line 2057: ||' AND msor.DELETED_FLAG= '||MSC_UTIL.SYS_NO

2053: ||' :v_current_date, '
2054: ||' :v_current_user '
2055: ||' FROM MSC_ST_OPERATION_RESOURCES msor'
2056: ||' WHERE msor.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2057: ||' AND msor.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2058: ||' AND NOT(nvl(msor.RESOURCE_SEQ_NUM,0)=0 AND msor.ALTERNATE_NUMBER > 0)';
2059:
2060: EXECUTE IMMEDIATE lv_sql_ins
2061: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;

Line 2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resources loaded');

2060: EXECUTE IMMEDIATE lv_sql_ins
2061: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
2062:
2063: COMMIT;
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resources loaded');
2065:
2066: FOR c_rec IN c6_corrupt_data LOOP
2067:
2068: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'operation resources loaded');
2065:
2066: FOR c_rec IN c6_corrupt_data LOOP
2067:
2068: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2069:
2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2071:
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

Line 2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2066: FOR c_rec IN c6_corrupt_data LOOP
2067:
2068: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2069:
2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2071:
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

Line 2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2071:
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
2079: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_SEQ_NUM));

Line 2080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
2079: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_SEQ_NUM));
2080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2081:
2082: FND_MESSAGE.SET_NAME('MSC','MSC_INVALID_RES_SEQ_NUM');
2083: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID', TO_CHAR(c_rec.ROUTING_SEQUENCE_ID));
2084: FND_MESSAGE.SET_TOKEN('RESOURCE_ID', TO_CHAR(c_rec.RESOURCE_ID));

Line 2085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2081:
2082: FND_MESSAGE.SET_NAME('MSC','MSC_INVALID_RES_SEQ_NUM');
2083: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID', TO_CHAR(c_rec.ROUTING_SEQUENCE_ID));
2084: FND_MESSAGE.SET_TOKEN('RESOURCE_ID', TO_CHAR(c_rec.RESOURCE_ID));
2085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2086:
2087: END LOOP;
2088:
2089: EXCEPTION

Line 2093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2089: EXCEPTION
2090: WHEN OTHERS THEN
2091: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2092:
2093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2094: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2095: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2096: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2094: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2095: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2096: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2098:
2099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2100: RAISE;
2101:

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

2095: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2096: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2098:
2099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2100: RAISE;
2101:
2102: ELSE
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

Line 2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2100: RAISE;
2101:
2102: ELSE
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2108:
2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2110:
2111: --If Direct path load results in warning then the processing has to be

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

2105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2108:
2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2110:
2111: --If Direct path load results in warning then the processing has to be
2112: --switched back to row by row processing. This will help to identify the
2113: --erroneous record and will also help in processing the rest of the records.

Line 2114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - operation resources');

2110:
2111: --If Direct path load results in warning then the processing has to be
2112: --switched back to row by row processing. This will help to identify the
2113: --erroneous record and will also help in processing the rest of the records.
2114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - operation resources');
2115: lb_refresh_failed := TRUE;
2116: END IF;
2117:
2118: END;

Line 2223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');

2219: EXECUTE IMMEDIATE lv_sql_stmt1 USING MSC_CL_COLLECTION.v_last_collection_id, MSC_CL_COLLECTION.v_current_date, MSC_CL_COLLECTION.v_current_user, c_rec.SR_INSTANCE_ID ;
2220: end if;
2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL Executed: ' || lv_sql_stmt1);
2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);
2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);

Line 2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL Executed: ' || lv_sql_stmt1);

2220: end if;
2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL Executed: ' || lv_sql_stmt1);
2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);
2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);

Line 2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);

2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL Executed: ' || lv_sql_stmt1);
2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);
2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Alternate Number: ' || c_rec.ALTERNATE_NUMBER);

Line 2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );

2222: WHEN OTHERS THEN
2223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL Executed: ' || lv_sql_stmt1);
2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);
2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Alternate Number: ' || c_rec.ALTERNATE_NUMBER);
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');

Line 2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);

2223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL Executed: ' || lv_sql_stmt1);
2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);
2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Alternate Number: ' || c_rec.ALTERNATE_NUMBER);
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2231: END;

Line 2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);

2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL Executed: ' || lv_sql_stmt1);
2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);
2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Alternate Number: ' || c_rec.ALTERNATE_NUMBER);
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2231: END;
2232:

Line 2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Alternate Number: ' || c_rec.ALTERNATE_NUMBER);

2225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Routing Sequence Id: ' || c_rec.ROUTING_SEQUENCE_ID);
2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Alternate Number: ' || c_rec.ALTERNATE_NUMBER);
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2231: END;
2232:
2233: /*

Line 2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');

2226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Operation Sequence Id: ' || c_rec.OPERATION_SEQUENCE_ID );
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Seq Num: ' || c_rec.RESOURCE_SEQ_NUM);
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Resource Id: ' || c_rec.RESOURCE_ID);
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Alternate Number: ' || c_rec.ALTERNATE_NUMBER);
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2231: END;
2232:
2233: /*
2234: UPDATE MSC_OPERATION_RESOURCES

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

2289: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2290: /* Start changes for 3586386*/
2291: IF nvl(c_rec.RESOURCE_SEQ_NUM,0)=0 AND c_rec.ALTERNATE_NUMBER > 0 THEN
2292:
2293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2294:
2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2296:
2297: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

Line 2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2291: IF nvl(c_rec.RESOURCE_SEQ_NUM,0)=0 AND c_rec.ALTERNATE_NUMBER > 0 THEN
2292:
2293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2294:
2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2296:
2297: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2298: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2299: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

Line 2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2296:
2297: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2298: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2299: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2301:
2302: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2303: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
2304: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_SEQ_NUM));

Line 2305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2301:
2302: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2303: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
2304: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_SEQ_NUM));
2305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2306:
2307: FND_MESSAGE.SET_NAME('MSC','MSC_INVALID_RES_SEQ_NUM');
2308: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID', TO_CHAR(c_rec.ROUTING_SEQUENCE_ID));
2309: FND_MESSAGE.SET_TOKEN('RESOURCE_ID', TO_CHAR(c_rec.RESOURCE_ID));

Line 2310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2306:
2307: FND_MESSAGE.SET_NAME('MSC','MSC_INVALID_RES_SEQ_NUM');
2308: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID', TO_CHAR(c_rec.ROUTING_SEQUENCE_ID));
2309: FND_MESSAGE.SET_TOKEN('RESOURCE_ID', TO_CHAR(c_rec.RESOURCE_ID));
2310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2311:
2312: /* End changes for 3586386*/
2313: ELSE
2314: EXECUTE IMMEDIATE lv_sql_stmt USING

Line 2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2351: WHEN OTHERS THEN
2352:
2353: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2354:
2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2356: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2357: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2358: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2356: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2357: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2358: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2360:
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2362: RAISE;
2363:

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

2357: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2358: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2360:
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2362: RAISE;
2363:
2364: ELSE
2365: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2362: RAISE;
2363:
2364: ELSE
2365: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2368: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2369: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');

Line 2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2363:
2364: ELSE
2365: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2368: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2369: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2370: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2368: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2369: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2370: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2372:
2373: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2374: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
2375: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

Line 2376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2372:
2373: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2374: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
2375: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
2376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2377:
2378: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2379: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
2380: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));

Line 2381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2377:
2378: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2379: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');
2380: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.OPERATION_SEQUENCE_ID));
2381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2382:
2383: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2384: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
2385: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_SEQ_NUM));

Line 2386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2382:
2383: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2384: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');
2385: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_SEQ_NUM));
2386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2387:
2388: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2389: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2390: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_ID));

Line 2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2387:
2388: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2389: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2390: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_ID));
2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2392:
2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2394: END IF;
2395: END;

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

2389: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2390: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.RESOURCE_ID));
2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2392:
2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2394: END IF;
2395: END;
2396:
2397: END LOOP;

Line 2404: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

2400: COMMIT;
2401:
2402: BEGIN
2403:
2404: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
2405:
2406: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
2407:
2408: lv_sql_stmt:=

Line 2409: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl

2405:
2406: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
2407:
2408: lv_sql_stmt:=
2409: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'
2411: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2412: ||' AND plan_id = -1 '
2413: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

Line 2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'

2406: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
2407:
2408: lv_sql_stmt:=
2409: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'
2411: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2412: ||' AND plan_id = -1 '
2413: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2414:

Line 2413: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

2409: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'
2411: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2412: ||' AND plan_id = -1 '
2413: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2414:
2415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
2416: EXECUTE IMMEDIATE lv_sql_stmt;
2417:

Line 2415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

2411: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2412: ||' AND plan_id = -1 '
2413: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2414:
2415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
2416: EXECUTE IMMEDIATE lv_sql_stmt;
2417:
2418: COMMIT;
2419:

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

2418: COMMIT;
2419:
2420: END IF;
2421:
2422: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2423: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2424: lv_retcode,
2425: 'MSC_OPERATION_RESOURCES',
2426: MSC_CL_COLLECTION.v_instance_code,

Line 2427: MSC_UTIL.G_WARNING

2423: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2424: lv_retcode,
2425: 'MSC_OPERATION_RESOURCES',
2426: MSC_CL_COLLECTION.v_instance_code,
2427: MSC_UTIL.G_WARNING
2428: );
2429:
2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN

2426: MSC_CL_COLLECTION.v_instance_code,
2427: MSC_UTIL.G_WARNING
2428: );
2429:
2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2432: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2433: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2427: MSC_UTIL.G_WARNING
2428: );
2429:
2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2432: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2433: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2435: END IF;

Line 2433: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

2429:
2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2432: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2433: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2435: END IF;
2436:
2437: END IF;

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

2430: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2432: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2433: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2434: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2435: END IF;
2436:
2437: END IF;
2438:

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

2438:
2439: EXCEPTION
2440: WHEN OTHERS THEN
2441:
2442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2443: RAISE;
2444: END;
2445:
2446: END LOAD_OPERATION_RESOURCES;

Line 2464: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'.. In procedure GET_START_END_OP ..');

2460: and (mr.first_op_seq_num is null or mr.last_op_seq_num is null);
2461:
2462: BEGIN
2463:
2464: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'.. In procedure GET_START_END_OP ..');
2465: FOR c_rec IN c1 LOOP
2466:
2467: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2468: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

Line 2470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2466:
2467: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2468: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
2469: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ROUTING_SEQUENCE_ID);
2470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2471: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2472: FND_MESSAGE.SET_TOKEN('COLUMN', 'effectivity_date');
2473: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);
2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2471: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2472: FND_MESSAGE.SET_TOKEN('COLUMN', 'effectivity_date');
2473: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);
2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2475:
2476: UPDATE MSC_ROUTINGS mr
2477: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2478: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)

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

2491: EXCEPTION
2492: WHEN OTHERS THEN
2493: ROLLBACK;
2494:
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,SQLERRM);
2496: END GET_START_END_OP;
2497:
2498:
2499: PROCEDURE GET_START_END_OP_PARTIAL

Line 2510: and mr.deleted_flag = MSC_UTIL.SYS_NO

2506: mr.sr_instance_id=mn.sr_instance_id
2507: and mr.routing_sequence_id= mn.routing_sequence_id
2508: and mr.CFM_ROUTING_FLAG=3
2509: and mn.plan_id = -1
2510: and mr.deleted_flag = MSC_UTIL.SYS_NO
2511: and mr.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2512: and (mr.first_op_seq_num is null or mr.last_op_seq_num is null);
2513:
2514: BEGIN

Line 2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'.. In procedure GET_START_END_OP ..');

2512: and (mr.first_op_seq_num is null or mr.last_op_seq_num is null);
2513:
2514: BEGIN
2515:
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'.. In procedure GET_START_END_OP ..');
2517: FOR c_rec IN c1 LOOP
2518:
2519: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2520: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

Line 2522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2518:
2519: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2520: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
2521: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ROUTING_SEQUENCE_ID);
2522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2523:
2524: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2525: FND_MESSAGE.SET_TOKEN('COLUMN', 'effectivity_date');
2526: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);

Line 2527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2523:
2524: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2525: FND_MESSAGE.SET_TOKEN('COLUMN', 'effectivity_date');
2526: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);
2527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2528:
2529: UPDATE MSC_ROUTINGS mr
2530: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2531: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)

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

2543:
2544: EXCEPTION
2545: WHEN OTHERS THEN
2546: ROLLBACK;
2547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,SQLERRM);
2548: END GET_START_END_OP_PARTIAL;
2549:
2550:
2551: FUNCTION get_start_op(v_instance_id in number, v_routing_sequence_id in number, v_routing_effdate in date)