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_OTHER_ODS_LOAD dependencies on MSC_UTIL

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

30: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
31:
32: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
33:
34: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
35: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
36: ELSE
37: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
38: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

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

33:
34: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
35: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
36: ELSE
37: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
38: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
39: END IF;
40:
41: END IF;

Line 43: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN

39: END IF;
40:
41: END IF;
42: -- SRP enhancement
43: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
44: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
45: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;
46: ELSE
47: lv_ITEM_TYPE_ID := NULL;

Line 44: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

40:
41: END IF;
42: -- SRP enhancement
43: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
44: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
45: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;
46: ELSE
47: lv_ITEM_TYPE_ID := NULL;
48: lv_ITEM_TYPE_VALUE := NULL;

Line 45: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;

41: END IF;
42: -- SRP enhancement
43: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
44: lv_ITEM_TYPE_ID := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
45: lv_ITEM_TYPE_VALUE := MSC_UTIL.G_PARTCONDN_GOOD;
46: ELSE
47: lv_ITEM_TYPE_ID := NULL;
48: lv_ITEM_TYPE_VALUE := NULL;
49: END IF;

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

128: WHEN OTHERS THEN
129:
130: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
131:
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
137:
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
139: RAISE;
140:

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

134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
137:
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
139: RAISE;
140:
141: ELSE
142: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
139: RAISE;
140:
141: ELSE
142: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
143:
144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');

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

140:
141: ELSE
142: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
143:
144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:
155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
157: FND_MESSAGE.SET_TOKEN('VALUE',

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

156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
157: FND_MESSAGE.SET_TOKEN('VALUE',
158: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
159: MSC_CL_COLLECTION.v_instance_id));
160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
161:
162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));

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

161:
162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));

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

166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));

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

171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
176:
177: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
178: END IF;
179:

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

173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
176:
177: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
178: END IF;
179:
180: END;
181:

Line 483: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN

479: BEGIN
480:
481: --/* it's removed due to bug 1219661
482: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
483: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
484:
485: UPDATE MSC_ASSIGNMENT_SETS
486: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
487: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 486: SET DELETED_FLAG= MSC_UTIL.SYS_YES,

482: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
483: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
484:
485: UPDATE MSC_ASSIGNMENT_SETS
486: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
487: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
488: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
489: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
490: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

Line 490: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

486: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
487: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
488: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
489: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
490: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
491:
492: END IF;
493:
494: COMMIT;

Line 506: mas.Deleted_Flag= MSC_UTIL.SYS_NO,

502:
503: UPDATE MSC_ASSIGNMENT_SETS mas
504: SET mas.ASSIGNMENT_SET_NAME=c_rec.ASSIGNMENT_SET_NAME,
505: mas.Description= c_rec.Description,
506: mas.Deleted_Flag= MSC_UTIL.SYS_NO,
507: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
508: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
509: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
510: WHERE mas.SR_Assignment_Set_Id= c_rec.SR_Assignment_Set_Id

Line 512: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

508: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
509: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
510: WHERE mas.SR_Assignment_Set_Id= c_rec.SR_Assignment_Set_Id
511: AND mas.SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
512: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
513:
514: IF SQL%NOTFOUND THEN
515:
516: INSERT INTO MSC_ASSIGNMENT_SETS

Line 534: MSC_UTIL.SYS_YES,

530: ( MSC_ASSIGNMENT_SETS_S.NEXTVAL,
531: c_rec.SR_ASSIGNMENT_SET_ID,
532: c_rec.DESCRIPTION,
533: c_rec.ASSIGNMENT_SET_NAME,
534: MSC_UTIL.SYS_YES,
535: c_rec.SR_INSTANCE_ID,
536: MSC_UTIL.SYS_NO,
537: MSC_CL_COLLECTION.v_last_collection_id,
538: MSC_CL_COLLECTION.v_current_date,

Line 536: MSC_UTIL.SYS_NO,

532: c_rec.DESCRIPTION,
533: c_rec.ASSIGNMENT_SET_NAME,
534: MSC_UTIL.SYS_YES,
535: c_rec.SR_INSTANCE_ID,
536: MSC_UTIL.SYS_NO,
537: MSC_CL_COLLECTION.v_last_collection_id,
538: MSC_CL_COLLECTION.v_current_date,
539: MSC_CL_COLLECTION.v_current_user,
540: MSC_CL_COLLECTION.v_current_date,

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

553: WHEN OTHERS THEN
554:
555: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
556:
557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
562:
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
564: RAISE;
565:

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

559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
562:
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
564: RAISE;
565:
566: ELSE
567:

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

564: RAISE;
565:
566: ELSE
567:
568: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
569:
570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

566: ELSE
567:
568: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
569:
570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);

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

575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);
579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));

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

580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
585:
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
587: END IF;
588:

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

582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
585:
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
587: END IF;
588:
589: END;
590:

Line 597: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES

593: COMMIT;
594:
595: --/* it's removed due to bug 1219661
596: DELETE MSC_ASSIGNMENT_SETS
597: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
598: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
599: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
600:
601: COMMIT;

Line 599: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

595: --/* it's removed due to bug 1219661
596: DELETE MSC_ASSIGNMENT_SETS
597: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
598: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
599: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
600:
601: COMMIT;
602: --*/
603:

Line 612: AND MSC_CL_COLLECTION.v_sourcing_flag =MSC_UTIL.SYS_YES) THEN

608: END IF;
609:
610: --/* it's removed due to bug 1219661
611: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
612: AND MSC_CL_COLLECTION.v_sourcing_flag =MSC_UTIL.SYS_YES) THEN
613:
614: UPDATE MSC_SOURCING_RULES
615: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
616: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 615: SET DELETED_FLAG= MSC_UTIL.SYS_YES,

611: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
612: AND MSC_CL_COLLECTION.v_sourcing_flag =MSC_UTIL.SYS_YES) THEN
613:
614: UPDATE MSC_SOURCING_RULES
615: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
616: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
617: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
618: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
619: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

Line 619: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

615: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
616: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
617: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
618: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
619: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
620:
621: END IF;
622:
623: COMMIT;

Line 638: msr.Deleted_Flag= MSC_UTIL.SYS_NO,

634: msr.Status= c_rec.Status,
635: msr.Sourcing_Rule_Type= c_rec.Sourcing_Rule_Type,
636: msr.sourcing_rule_name= c_rec.sourcing_rule_name,
637: msr.Planning_Active= c_rec.Planning_Active,
638: msr.Deleted_Flag= MSC_UTIL.SYS_NO,
639: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
640: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
641: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
642: CREATION_DATE= MSC_CL_COLLECTION.v_current_date,

Line 646: AND msr.COLLECTED_FLAG= MSC_UTIL.SYS_YES;

642: CREATION_DATE= MSC_CL_COLLECTION.v_current_date,
643: CREATED_BY= MSC_CL_COLLECTION.v_current_user
644: WHERE msr.SR_Sourcing_Rule_ID= c_rec.SR_Sourcing_Rule_ID
645: AND msr.SR_Instance_ID= c_rec.SR_Instance_ID
646: AND msr.COLLECTED_FLAG= MSC_UTIL.SYS_YES;
647:
648: IF SQL%NOTFOUND THEN
649:
650: INSERT INTO MSC_SOURCING_RULES

Line 676: MSC_UTIL.SYS_YES,

672: c_rec.DESCRIPTION,
673: c_rec.STATUS,
674: c_rec.SOURCING_RULE_TYPE,
675: c_rec.PLANNING_ACTIVE,
676: MSC_UTIL.SYS_YES,
677: c_rec.SR_INSTANCE_ID,
678: MSC_UTIL.SYS_NO,
679: MSC_CL_COLLECTION.v_last_collection_id,
680: MSC_CL_COLLECTION.v_current_date,

Line 678: MSC_UTIL.SYS_NO,

674: c_rec.SOURCING_RULE_TYPE,
675: c_rec.PLANNING_ACTIVE,
676: MSC_UTIL.SYS_YES,
677: c_rec.SR_INSTANCE_ID,
678: MSC_UTIL.SYS_NO,
679: MSC_CL_COLLECTION.v_last_collection_id,
680: MSC_CL_COLLECTION.v_current_date,
681: MSC_CL_COLLECTION.v_current_user,
682: MSC_CL_COLLECTION.v_current_date,

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

694: EXCEPTION
695: WHEN OTHERS THEN
696: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
697:
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
703:
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
705: RAISE;
706:

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

700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
703:
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
705: RAISE;
706:
707: ELSE
708: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
705: RAISE;
706:
707: ELSE
708: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

706:
707: ELSE
708: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);

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

715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
722: END IF;
723:

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

717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
722: END IF;
723:
724: END;
725:

Line 732: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES

728: COMMIT;
729:
730: --/* it's removed due to bug 1219661
731: DELETE MSC_SOURCING_RULES
732: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
733: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
734: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
735:
736: COMMIT;

Line 734: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

730: --/* it's removed due to bug 1219661
731: DELETE MSC_SOURCING_RULES
732: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
733: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
734: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
735:
736: COMMIT;
737: --*/
738:

Line 748: SET DELETED_FLAG= MSC_UTIL.SYS_YES,

744:
745: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
746:
747: UPDATE MSC_SR_ASSIGNMENTS
748: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
749: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
750: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
751: WHERE SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
752: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

Line 752: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

748: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
749: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
750: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
751: WHERE SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
752: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
753:
754: END IF;
755:
756: COMMIT;

Line 819: msa.Deleted_Flag= MSC_UTIL.SYS_NO,

815: msa.CATEGORY_SET_ID = lb_Category_Set_ID(j),
816: msa.ORGANIZATION_ID = lb_ORGANIZATION_ID(j),
817: msa.SR_INSTANCE_ID = lb_SR_INSTANCE_ID(j),
818: msa.CATEGORY_NAME = lb_category_name(j),
819: msa.Deleted_Flag= MSC_UTIL.SYS_NO,
820: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
821: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
822: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
823: CREATION_DATE= MSC_CL_COLLECTION.v_current_date,

Line 827: AND msa.COLLECTED_FLAG= MSC_UTIL.SYS_YES;

823: CREATION_DATE= MSC_CL_COLLECTION.v_current_date,
824: CREATED_BY= MSC_CL_COLLECTION.v_current_user
825: WHERE msa.SR_Assignment_ID= lb_SR_ASSIGNMENT_ID(j)
826: AND msa.SR_Assignment_Instance_ID= lb_SR_ASSIGNMENT_INSTANCE_ID(j)
827: AND msa.COLLECTED_FLAG= MSC_UTIL.SYS_YES;
828:
829: EXCEPTION
830: WHEN OTHERS THEN
831:

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

830: WHEN OTHERS THEN
831:
832: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
833:
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:
840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
841: RAISE;
842:

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

836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:
840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
841: RAISE;
842:
843: ELSE
844:

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

841: RAISE;
842:
843: ELSE
844:
845: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

843: ELSE
844:
845: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
854: END IF;
855:

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

849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
854: END IF;
855:
856: END;
857: commit;

Line 902: MSC_UTIL.SYS_YES,

898: mcsil.Category_Set_ID,
899: mssa.ORGANIZATION_ID,
900: mssa.SR_INSTANCE_ID,
901: mssa.CATEGORY_NAME,
902: MSC_UTIL.SYS_YES,
903: mssa.SR_ASSIGNMENT_INSTANCE_ID,
904: MSC_UTIL.SYS_NO,
905: MSC_CL_COLLECTION.v_last_collection_id,
906: MSC_CL_COLLECTION.v_current_date,

Line 904: MSC_UTIL.SYS_NO,

900: mssa.SR_INSTANCE_ID,
901: mssa.CATEGORY_NAME,
902: MSC_UTIL.SYS_YES,
903: mssa.SR_ASSIGNMENT_INSTANCE_ID,
904: MSC_UTIL.SYS_NO,
905: MSC_CL_COLLECTION.v_last_collection_id,
906: MSC_CL_COLLECTION.v_current_date,
907: MSC_CL_COLLECTION.v_current_user,
908: MSC_CL_COLLECTION.v_current_date,

Line 956: AND msa2.collected_flag = MSC_UTIL.SYS_YES);

952: AND not exists (select 1
953: from MSC_SR_ASSIGNMENTS msa2
954: where msa2.SR_Assignment_ID = mssa.SR_Assignment_ID
955: AND msa2.SR_Assignment_Instance_ID = mssa.SR_Assignment_Instance_ID
956: AND msa2.collected_flag = MSC_UTIL.SYS_YES);
957:
958: EXCEPTION
959: WHEN OTHERS THEN
960:

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

959: WHEN OTHERS THEN
960:
961: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:
969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
970: RAISE;
971:

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

965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:
969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
970: RAISE;
971:
972: ELSE
973:

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

970: RAISE;
971:
972: ELSE
973:
974: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

972: ELSE
973:
974: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
983: END IF;
984:

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

978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
983: END IF;
984:
985: END;
986:

Line 991: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES

987:
988: COMMIT;
989:
990: DELETE MSC_SR_ASSIGNMENTS
991: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
992: AND SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
993: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
994:
995: COMMIT;

Line 993: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

989:
990: DELETE MSC_SR_ASSIGNMENTS
991: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
992: AND SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
993: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
994:
995: COMMIT;
996:
997: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 1005: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN

1001: END IF;
1002:
1003: --/* it's removed due to bug 1219661
1004: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
1005: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
1006:
1007: UPDATE MSC_SR_RECEIPT_ORG
1008: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
1009: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1008: SET DELETED_FLAG= MSC_UTIL.SYS_YES,

1004: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
1005: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
1006:
1007: UPDATE MSC_SR_RECEIPT_ORG
1008: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
1009: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1010: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1011: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1012: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

Line 1012: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1008: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
1009: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1010: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1011: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1012: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1013:
1014: END IF;
1015:
1016: COMMIT;

Line 1033: msro.Deleted_Flag= MSC_UTIL.SYS_NO,

1029: msro.RECEIPT_PARTNER_ID= c_rec.Receipt_Partner_ID,
1030: msro.RECEIPT_PARTNER_SITE_ID= c_rec.Receipt_Partner_Site_ID,
1031: msro.EFFECTIVE_DATE= c_rec.Effective_Date,
1032: msro.DISABLE_DATE= c_rec.Disable_Date,
1033: msro.Deleted_Flag= MSC_UTIL.SYS_NO,
1034: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1035: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1036: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
1037: CREATION_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1041: AND msro.COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1037: CREATION_DATE= MSC_CL_COLLECTION.v_current_date,
1038: CREATED_BY= MSC_CL_COLLECTION.v_current_user
1039: WHERE msro.SR_SR_Receipt_ID= c_rec.SR_Receipt_ID
1040: AND msro.SR_Instance_ID= c_rec.SR_Instance_ID
1041: AND msro.COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1042:
1043: IF SQL%NOTFOUND THEN
1044:
1045: INSERT INTO MSC_SR_RECEIPT_ORG

Line 1073: MSC_UTIL.SYS_YES,

1069: c_rec.RECEIPT_PARTNER_ID,
1070: c_rec.RECEIPT_PARTNER_SITE_ID,
1071: c_rec.EFFECTIVE_DATE,
1072: c_rec.DISABLE_DATE,
1073: MSC_UTIL.SYS_YES,
1074: c_rec.SR_INSTANCE_ID,
1075: MSC_UTIL.SYS_NO,
1076: MSC_CL_COLLECTION.v_last_collection_id,
1077: MSC_CL_COLLECTION.v_current_date,

Line 1075: MSC_UTIL.SYS_NO,

1071: c_rec.EFFECTIVE_DATE,
1072: c_rec.DISABLE_DATE,
1073: MSC_UTIL.SYS_YES,
1074: c_rec.SR_INSTANCE_ID,
1075: MSC_UTIL.SYS_NO,
1076: MSC_CL_COLLECTION.v_last_collection_id,
1077: MSC_CL_COLLECTION.v_current_date,
1078: MSC_CL_COLLECTION.v_current_user,
1079: MSC_CL_COLLECTION.v_current_date,

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

1093: WHEN OTHERS THEN
1094:
1095: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1096:
1097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1102:
1103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1104: RAISE;
1105:

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

1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1102:
1103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1104: RAISE;
1105:
1106: ELSE
1107: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1104: RAISE;
1105:
1106: ELSE
1107: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1108:
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1105:
1106: ELSE
1107: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1108:
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));

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

1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: END IF;
1122:

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

1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: END IF;
1122:
1123: END;
1124:

Line 1131: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES

1127: COMMIT;
1128:
1129: --/* it's removed due to bug 1219661
1130: DELETE MSC_SR_RECEIPT_ORG
1131: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
1132: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1133: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1134:
1135: COMMIT;

Line 1133: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1129: --/* it's removed due to bug 1219661
1130: DELETE MSC_SR_RECEIPT_ORG
1131: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
1132: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1133: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1134:
1135: COMMIT;
1136: --*/
1137:

Line 1146: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN

1142: END IF;
1143:
1144: --/* it's removed due to bug 1219661
1145: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
1146: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
1147:
1148: UPDATE MSC_SR_SOURCE_ORG
1149: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
1150: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1149: SET DELETED_FLAG= MSC_UTIL.SYS_YES,

1145: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
1146: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
1147:
1148: UPDATE MSC_SR_SOURCE_ORG
1149: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
1150: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1151: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1152: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1153: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

Line 1153: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1149: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
1150: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1151: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1152: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1153: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1154:
1155: END IF;
1156:
1157: COMMIT;

Line 1176: msso.Deleted_Flag= MSC_UTIL.SYS_NO,

1172: msso.ALLOCATION_PERCENT= c_rec.Allocation_percent,
1173: msso.RANK= c_rec.Rank,
1174: msso.SHIP_METHOD= c_rec.Ship_Method,
1175: msso.SOURCE_TYPE= c_rec.Source_Type,
1176: msso.Deleted_Flag= MSC_UTIL.SYS_NO,
1177: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1178: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1179: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1180: WHERE msso.SR_SR_SOURCE_ID= c_rec.SR_SR_SOURCE_ID

Line 1182: AND msso.COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1178: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1179: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1180: WHERE msso.SR_SR_SOURCE_ID= c_rec.SR_SR_SOURCE_ID
1181: AND msso.SR_Instance_ID= c_rec.SR_Instance_ID
1182: AND msso.COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1183:
1184: IF SQL%NOTFOUND THEN
1185:
1186: INSERT INTO MSC_SR_SOURCE_ORG

Line 1216: MSC_UTIL.SYS_YES,

1212: c_rec.TP_ID,
1213: c_rec.TP_SITE_ID,
1214: c_rec.ALLOCATION_PERCENT,
1215: c_rec.RANK,
1216: MSC_UTIL.SYS_YES,
1217: c_rec.SR_INSTANCE_ID,
1218: MSC_UTIL.SYS_NO,
1219: c_rec.SHIP_METHOD,
1220: c_rec.SOURCE_TYPE,

Line 1218: MSC_UTIL.SYS_NO,

1214: c_rec.ALLOCATION_PERCENT,
1215: c_rec.RANK,
1216: MSC_UTIL.SYS_YES,
1217: c_rec.SR_INSTANCE_ID,
1218: MSC_UTIL.SYS_NO,
1219: c_rec.SHIP_METHOD,
1220: c_rec.SOURCE_TYPE,
1221: MSC_CL_COLLECTION.v_last_collection_id,
1222: MSC_CL_COLLECTION.v_current_date,

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

1238: WHEN OTHERS THEN
1239:
1240: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1241:
1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1247:
1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1249: RAISE;
1250:

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

1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1247:
1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1249: RAISE;
1250:
1251: ELSE
1252: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1249: RAISE;
1250:
1251: ELSE
1252: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1253:
1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1250:
1251: ELSE
1252: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1253:
1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));

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

1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));
1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1264:
1265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1266: END IF;
1267:

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

1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));
1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1264:
1265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1266: END IF;
1267:
1268: END;
1269:

Line 1276: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES

1272: COMMIT;
1273:
1274: --/* it's removed due to bug 1219661
1275: DELETE MSC_SR_SOURCE_ORG
1276: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
1277: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1278: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1279:
1280: COMMIT;

Line 1278: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1274: --/* it's removed due to bug 1219661
1275: DELETE MSC_SR_SOURCE_ORG
1276: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
1277: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1278: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1279:
1280: COMMIT;
1281: --*/
1282:

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

1393: WHEN OTHERS THEN
1394:
1395: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1396:
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1402:
1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1404: RAISE;
1405:

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

1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1402:
1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1404: RAISE;
1405:
1406: ELSE
1407: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1404: RAISE;
1405:
1406: ELSE
1407: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1408:
1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1405:
1406: ELSE
1407: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1408:
1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');
1417: FND_MESSAGE.SET_TOKEN('VALUE',

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

1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');
1417: FND_MESSAGE.SET_TOKEN('VALUE',
1418: MSC_GET_NAME.ORG_CODE( c_rec.FROM_ORGANIZATION_ID,
1419: MSC_CL_COLLECTION.v_instance_id));
1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1421:
1422: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');
1424: FND_MESSAGE.SET_TOKEN('VALUE',

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

1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');
1424: FND_MESSAGE.SET_TOKEN('VALUE',
1425: MSC_GET_NAME.ORG_CODE( c_rec.TO_ORGANIZATION_ID,
1426: MSC_CL_COLLECTION.v_instance_id));
1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1428:
1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));

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

1428:
1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));

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

1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));
1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);

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

1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);
1442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1443:
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1445: END IF;
1446:

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

1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);
1442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1443:
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1445: END IF;
1446:
1447: END;
1448:

Line 1457: IF (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS107) OR (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS110) THEN

1453: /* Code added for Region Level Sourcing for ATP - Only for 11i Source */
1454: IF MSC_CL_COLLECTION.v_apps_ver >= 3 THEN
1455:
1456:
1457: IF (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS107) OR (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS110) THEN
1458: lv_msc_tp_coll_window := 0;
1459: ELSE
1460: BEGIN
1461: lv_msc_tp_coll_window:= NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);

Line 1523: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');

1519: END IF;
1520: /* Get the swap table index number in the list*/
1521: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGIONS'); --ods table name
1522: IF i = -1 THEN
1523: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
1524: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1525: END IF;
1526: /* Do phase 1 exchange*/
1527:

Line 1532: MSC_UTIL.SYS_NO ) THEN

1528: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1529: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1530: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1531: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1532: MSC_UTIL.SYS_NO ) THEN
1533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1534: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1535: END IF;
1536:

Line 1533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

1529: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1530: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1531: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1532: MSC_UTIL.SYS_NO ) THEN
1533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1534: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1535: END IF;
1536:
1537: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '

Line 1552: MSC_UTIL.SYS_NO,

1548: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1549: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1550: MSC_CL_COLLECTION.v_instance_code,
1551: MSC_CL_COLLECTION.v_instance_id,
1552: MSC_UTIL.SYS_NO,
1553: MSC_CL_COLLECTION.G_WARNING
1554: );
1555:
1556: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN

Line 1557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1553: MSC_CL_COLLECTION.G_WARNING
1554: );
1555:
1556: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1558: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1560: --RETURN ;
1561: ELSE

Line 1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1555:
1556: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1558: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1560: --RETURN ;
1561: ELSE
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1563: END IF;

Line 1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1558: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1560: --RETURN ;
1561: ELSE
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1563: END IF;
1564:
1565: COMMIT;
1566:

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

1572: WHEN OTHERS THEN
1573:
1574: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1575:
1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1583: RAISE;
1584:

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

1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1583: RAISE;
1584:
1585: ELSE
1586: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1583: RAISE;
1584:
1585: ELSE
1586: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1584:
1585: ELSE
1586: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: END IF;
1595: END; -- load for MSC_REGIONS
1596:

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

1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: END IF;
1595: END; -- load for MSC_REGIONS
1596:
1597:

Line 1622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');

1618: END IF;
1619: /* Get the swap table index number in the list*/
1620: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_ZONE_REGIONS'); --ods table name
1621: IF i = -1 THEN
1622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
1623: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1624: END IF;
1625: /* Do phase 1 exchange*/
1626:

Line 1631: MSC_UTIL.SYS_NO ) THEN

1627: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1628: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1629: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1630: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1631: MSC_UTIL.SYS_NO ) THEN
1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1633: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1634: END IF;
1635:

Line 1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

1628: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1629: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1630: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1631: MSC_UTIL.SYS_NO ) THEN
1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1633: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1634: END IF;
1635:
1636: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '

Line 1651: MSC_UTIL.SYS_NO,

1647: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1648: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1649: MSC_CL_COLLECTION.v_instance_code,
1650: MSC_CL_COLLECTION.v_instance_id,
1651: MSC_UTIL.SYS_NO,
1652: MSC_CL_COLLECTION.G_WARNING
1653: );
1654:
1655: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN

Line 1656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1652: MSC_CL_COLLECTION.G_WARNING
1653: );
1654:
1655: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1657: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1659: -- RETURN ;
1660: ELSE

Line 1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1654:
1655: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1657: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1659: -- RETURN ;
1660: ELSE
1661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1662: END IF;

Line 1661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1657: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1659: -- RETURN ;
1660: ELSE
1661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1662: END IF;
1663:
1664: EXCEPTION
1665: WHEN MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR THEN

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

1667: WHEN OTHERS THEN
1668:
1669: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1672: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1672: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1676:
1677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1678: RAISE;
1679:

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

1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1676:
1677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1678: RAISE;
1679:
1680: ELSE
1681: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1678: RAISE;
1679:
1680: ELSE
1681: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1682:
1683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1679:
1680: ELSE
1681: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1682:
1683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1689: END IF;
1690: END; -- load for MSC_ZONE_REGIONS
1691:

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

1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1689: END IF;
1690: END; -- load for MSC_ZONE_REGIONS
1691:
1692:

Line 1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');

1711: END IF;
1712: /* Get the swap table index number in the list*/
1713: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_REGION_LOCATIONS'); --ods table name
1714: IF i = -1 THEN
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
1716: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1717: END IF;
1718: /* Do phase 1 exchange*/
1719:

Line 1724: MSC_UTIL.SYS_NO ) THEN

1720: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
1721: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1722: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1723: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1724: MSC_UTIL.SYS_NO ) THEN
1725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1726: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1727: END IF;
1728:

Line 1725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

1721: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
1722: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
1723: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1724: MSC_UTIL.SYS_NO ) THEN
1725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
1726: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
1727: END IF;
1728:
1729: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '

Line 1744: MSC_UTIL.SYS_NO,

1740: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).ods_table_name,
1741: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
1742: MSC_CL_COLLECTION.v_instance_code,
1743: MSC_CL_COLLECTION.v_instance_id,
1744: MSC_UTIL.SYS_NO,
1745: MSC_CL_COLLECTION.G_WARNING
1746: );
1747:
1748: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN

Line 1749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1745: MSC_CL_COLLECTION.G_WARNING
1746: );
1747:
1748: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1750: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1752: -- RETURN ;
1753: ELSE

Line 1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1747:
1748: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
1749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1750: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1752: -- RETURN ;
1753: ELSE
1754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1755: END IF;

Line 1754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);

1750: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during nonunique index creation on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1752: -- RETURN ;
1753: ELSE
1754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'NonUnique index creation successful on table, ' || MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name);
1755: END IF;
1756:
1757: EXCEPTION
1758: WHEN MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR THEN

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

1760: WHEN OTHERS THEN
1761:
1762: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1763:
1764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1765: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1765: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1769:
1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1771: RAISE;
1772:

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

1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1769:
1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1771: RAISE;
1772:
1773: ELSE
1774: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1771: RAISE;
1772:
1773: ELSE
1774: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1775:
1776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1772:
1773: ELSE
1774: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1775:
1776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1781: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1782: END IF;
1783: END; -- load for MSC_REGION_LOCATIONS
1784: END IF; --IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)) THEN

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

1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1781: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1782: END IF;
1783: END; -- load for MSC_REGION_LOCATIONS
1784: END IF; --IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)) THEN
1785:

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

1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1844:
1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1846: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1846: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1850:
1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1852: RAISE;
1853:

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

1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1850:
1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1852: RAISE;
1853:
1854: ELSE
1855: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1852: RAISE;
1853:
1854: ELSE
1855: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1856:
1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1853:
1854: ELSE
1855: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1856:
1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1862:
1863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1864: END IF;
1865:

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

1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1862:
1863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1864: END IF;
1865:
1866: END;
1867:

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

1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1920:
1921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1922: RAISE;
1923:

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

1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1920:
1921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1922: RAISE;
1923:
1924: ELSE
1925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1922: RAISE;
1923:
1924: ELSE
1925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1926:
1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

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

1923:
1924: ELSE
1925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1926:
1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1932:
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1934: END IF;
1935:

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

1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1932:
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1934: END IF;
1935:
1936: END;
1937:

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

1969: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1970:
1971: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUB_INVENTORIES', MSC_CL_COLLECTION.v_instance_id, -1);
1972:
1973: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1974: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUB_INVENTORIES', MSC_CL_COLLECTION.v_instance_id, -1);
1975: ELSE
1976: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1977: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUB_INVENTORIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

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

1972:
1973: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1974: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUB_INVENTORIES', MSC_CL_COLLECTION.v_instance_id, -1);
1975: ELSE
1976: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1977: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUB_INVENTORIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
1978: END IF;
1979:
1980: END IF;

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

2055: WHEN OTHERS THEN
2056:
2057: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2058:
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2064:
2065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2066: RAISE;
2067:

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

2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2064:
2065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2066: RAISE;
2067:
2068: ELSE
2069: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2066: RAISE;
2067:
2068: ELSE
2069: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2070:
2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');

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

2067:
2068: ELSE
2069: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2070:
2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
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', 'ORGANIZATION_CODE');
2079: FND_MESSAGE.SET_TOKEN('VALUE',

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

2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2079: FND_MESSAGE.SET_TOKEN('VALUE',
2080: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2081: MSC_CL_COLLECTION.v_instance_id));
2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2083:
2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);

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

2083:
2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2088:
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2090: END IF;
2091: END;

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

2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2088:
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2090: END IF;
2091: END;
2092:
2093: END LOOP;

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

2120: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2121:
2122: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_UNIT_NUMBERS', MSC_CL_COLLECTION.v_instance_id, NULL);
2123:
2124: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2125: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_UNIT_NUMBERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2126: ELSE
2127: MSC_CL_COLLECTION.v_sub_str :='AND MASTER_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2128: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_UNIT_NUMBERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);

Line 2127: MSC_CL_COLLECTION.v_sub_str :='AND MASTER_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2123:
2124: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2125: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_UNIT_NUMBERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2126: ELSE
2127: MSC_CL_COLLECTION.v_sub_str :='AND MASTER_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2128: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_UNIT_NUMBERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
2129: END IF;
2130:
2131: END IF;

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

2189: WHEN OTHERS THEN
2190:
2191: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2192:
2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2194: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2194: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2198:
2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2200: RAISE;
2201:

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

2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2198:
2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2200: RAISE;
2201:
2202: ELSE
2203: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2200: RAISE;
2201:
2202: ELSE
2203: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2204:
2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');

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

2201:
2202: ELSE
2203: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2204:
2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);

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

2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);
2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));

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

2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));
2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:
2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2222: FND_MESSAGE.SET_TOKEN('COLUMN', 'MASTER_ORGANIZATION_CODE');
2223: FND_MESSAGE.SET_TOKEN('VALUE',

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

2223: FND_MESSAGE.SET_TOKEN('VALUE',
2224: MSC_GET_NAME.ORG_CODE(
2225: c_rec.MASTER_ORGANIZATION_ID,
2226: MSC_CL_COLLECTION.v_instance_id));
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2228:
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2230: END IF;
2231:

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

2225: c_rec.MASTER_ORGANIZATION_ID,
2226: MSC_CL_COLLECTION.v_instance_id));
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2228:
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2230: END IF;
2231:
2232: END;
2233:

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

2284: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2285:
2286: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2287:
2288: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2289: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2290: ELSE
2291: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

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

2287:
2288: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2289: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2290: ELSE
2291: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2293: END IF;
2294:
2295: END IF;

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

2389: WHEN OTHERS THEN
2390:
2391: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2392:
2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2398:
2399: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2400: RAISE;
2401:

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

2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2398:
2399: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2400: RAISE;
2401:
2402: ELSE
2403:

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

2400: RAISE;
2401:
2402: ELSE
2403:
2404: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2405:
2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');

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

2402: ELSE
2403:
2404: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2405:
2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2414: FND_MESSAGE.SET_TOKEN('VALUE',

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

2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2414: FND_MESSAGE.SET_TOKEN('VALUE',
2415: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2416: MSC_CL_COLLECTION.v_instance_id));
2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2418:
2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);

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

2418:
2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: END IF;
2426:

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

2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: END IF;
2426:
2427: END;
2428:

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

2433: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2434:
2435: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2436:
2437: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2438: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2439: ELSE
2440: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2441: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

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

2436:
2437: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2438: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2439: ELSE
2440: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2441: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2442: END IF;
2443:
2444: END IF;

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

2524: WHEN OTHERS THEN
2525:
2526: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2527:
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2533:
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2535: RAISE;
2536:

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

2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2533:
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2535: RAISE;
2536:
2537: ELSE
2538:

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

2535: RAISE;
2536:
2537: ELSE
2538:
2539: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');

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

2537: ELSE
2538:
2539: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2549: FND_MESSAGE.SET_TOKEN('VALUE',

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

2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2549: FND_MESSAGE.SET_TOKEN('VALUE',
2550: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2551: MSC_CL_COLLECTION.v_instance_id));
2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2553:
2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);

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

2553:
2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);

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

2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);
2562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2563:
2564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2565: END IF;
2566:

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

2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);
2562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2563:
2564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2565: END IF;
2566:
2567: END;
2568:

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

2658: WHEN OTHERS THEN
2659:
2660: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2661:
2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2667:
2668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2669: RAISE;
2670:

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

2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2667:
2668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2669: RAISE;
2670:
2671: ELSE
2672: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2669: RAISE;
2670:
2671: ELSE
2672: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2673:
2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

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

2670:
2671: ELSE
2672: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2673:
2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));

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

2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);

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

2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);
2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);

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

2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2696: END IF;
2697:

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

2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2696: END IF;
2697:
2698: END;
2699:

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

2811: WHEN OTHERS THEN
2812:
2813: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2814:
2815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2820:
2821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2822: RAISE;
2823:

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

2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2820:
2821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2822: RAISE;
2823:
2824: ELSE
2825:

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

2822: RAISE;
2823:
2824: ELSE
2825:
2826: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2827:
2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

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

2824: ELSE
2825:
2826: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2827:
2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);

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

2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);
2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));

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

2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);

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

2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);

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

2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);
2852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2853:
2854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2855: END IF;
2856:

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

2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);
2852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2853:
2854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2855: END IF;
2856:
2857: END;
2858:

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

2977: WHEN OTHERS THEN
2978:
2979: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2980:
2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2986:
2987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2988: RAISE;
2989:

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

2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2986:
2987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2988: RAISE;
2989:
2990: ELSE
2991: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

2987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2988: RAISE;
2989:
2990: ELSE
2991: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2992:
2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

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

2989:
2990: ELSE
2991: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2992:
2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));

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

2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));

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

3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));

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

3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);

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

3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);

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

3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3025: END IF;
3026:

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

3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3025: END IF;
3026:
3027: END;
3028:

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

3099: WHEN OTHERS THEN
3100:
3101: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3102:
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3108:
3109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3110: RAISE;
3111:

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

3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3108:
3109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3110: RAISE;
3111:
3112: ELSE
3113:

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

3110: RAISE;
3111:
3112: ELSE
3113:
3114: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3115:
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

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

3112: ELSE
3113:
3114: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3115:
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));

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

3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));

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

3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));
3130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3131:
3132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3133: END IF;
3134:

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

3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));
3130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3131:
3132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3133: END IF;
3134:
3135: END;
3136:

Line 3190: (MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER AND lv_rec_count > 0) THEN

3186: lv_rec_count := 0;
3187: END;
3188:
3189: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) or
3190: (MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER AND lv_rec_count > 0) THEN
3191: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id, NULL);
3192:
3193: IF (MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS) OR (MSC_CL_COLLECTION.v_coll_prec.org_group_flag IS NULL) THEN
3194: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL);

Line 3193: IF (MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS) OR (MSC_CL_COLLECTION.v_coll_prec.org_group_flag IS NULL) THEN

3189: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) or
3190: (MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER AND lv_rec_count > 0) THEN
3191: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id, NULL);
3192:
3193: IF (MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS) OR (MSC_CL_COLLECTION.v_coll_prec.org_group_flag IS NULL) THEN
3194: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL);
3195: ELSE
3196: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3197: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);

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

3192:
3193: IF (MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS) OR (MSC_CL_COLLECTION.v_coll_prec.org_group_flag IS NULL) THEN
3194: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL);
3195: ELSE
3196: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3197: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
3198: END IF;
3199:
3200: END IF;

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

3261: WHEN OTHERS THEN
3262:
3263: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3264:
3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3270:
3271: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3272: RAISE;
3273:

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

3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3270:
3271: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3272: RAISE;
3273:
3274: ELSE
3275: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

3271: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3272: RAISE;
3273:
3274: ELSE
3275: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3276:
3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

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

3273:
3274: ELSE
3275: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3276:
3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3285: FND_MESSAGE.SET_TOKEN('VALUE',

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

3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3285: FND_MESSAGE.SET_TOKEN('VALUE',
3286: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3287: MSC_CL_COLLECTION.v_instance_id));
3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3289:
3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);

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

3289:
3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);

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

3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);
3298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3299:
3300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3301: END IF;
3302:

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

3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);
3298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3299:
3300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3301: END IF;
3302:
3303: END;
3304:

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

3479: WHEN OTHERS THEN
3480:
3481: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3482:
3483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3488:
3489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3490: RAISE;
3491:

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

3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3488:
3489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3490: RAISE;
3491:
3492: ELSE
3493: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

3489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3490: RAISE;
3491:
3492: ELSE
3493: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3494:
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');

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

3491:
3492: ELSE
3493: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3494:
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));

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

3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));
3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);

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

3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);
3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3510:
3511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3512: END IF;
3513:

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

3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);
3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3510:
3511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3512: END IF;
3513:
3514: END;
3515:

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

3556:
3557: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3558:
3559: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PLANNERS', MSC_CL_COLLECTION.v_instance_id, NULL);
3560: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3561: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PLANNERS', MSC_CL_COLLECTION.v_instance_id,NULL);
3562: ELSE
3563: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3564: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PLANNERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);

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

3559: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PLANNERS', MSC_CL_COLLECTION.v_instance_id, NULL);
3560: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3561: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PLANNERS', MSC_CL_COLLECTION.v_instance_id,NULL);
3562: ELSE
3563: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3564: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PLANNERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
3565: END IF;
3566:
3567: c_count:= 0;

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

3611: WHEN OTHERS THEN
3612:
3613: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3614:
3615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3616: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3616: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3620:
3621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3622: RAISE;
3623:

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

3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3620:
3621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3622: RAISE;
3623:
3624: ELSE
3625: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

3621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3622: RAISE;
3623:
3624: ELSE
3625: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3626:
3627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');

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

3623:
3624: ELSE
3625: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3626:
3627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:
3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3635: FND_MESSAGE.SET_TOKEN('VALUE',

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

3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3635: FND_MESSAGE.SET_TOKEN('VALUE',
3636: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3637: MSC_CL_COLLECTION.v_instance_id));
3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3639:
3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);

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

3639:
3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);
3643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3644:
3645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3646: END IF;
3647:

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

3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);
3643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3644:
3645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3646: END IF;
3647:
3648: END;
3649:

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

3662: EXCEPTION
3663:
3664: WHEN OTHERS THEN
3665:
3666: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3667:
3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');

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

3664: WHEN OTHERS THEN
3665:
3666: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3667:
3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);

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

3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);
3677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3678:
3679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3680:
3681: END;

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

3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);
3677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3678:
3679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3680:
3681: END;
3682:
3683: END LOOP;

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

3767: WHEN OTHERS THEN
3768:
3769: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3770:
3771: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3771: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3776:
3777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3778: RAISE;
3779:

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

3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3776:
3777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3778: RAISE;
3779:
3780: ELSE
3781:

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

3778: RAISE;
3779:
3780: ELSE
3781:
3782: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3783:
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');

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

3780: ELSE
3781:
3782: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3783:
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);

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

3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);
3793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3794:
3795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3796: END IF;
3797:

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

3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);
3793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3794:
3795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3796: END IF;
3797:
3798: END;
3799:

Line 3882: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

3878:
3879: EXCEPTION
3880: WHEN OTHERS THEN
3881:
3882: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3884: RAISE;
3885: END;
3886:

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

3879: EXCEPTION
3880: WHEN OTHERS THEN
3881:
3882: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3884: RAISE;
3885: END;
3886:
3887: END LOOP;

Line 3991: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

3987: END IF;
3988: EXCEPTION
3989: WHEN OTHERS THEN
3990:
3991: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3993: RAISE;
3994: END;
3995:

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

3988: EXCEPTION
3989: WHEN OTHERS THEN
3990:
3991: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3993: RAISE;
3994: END;
3995:
3996: BEGIN

Line 4083: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

4079:
4080: EXCEPTION
4081: WHEN OTHERS THEN
4082:
4083: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4085: RAISE;
4086: END;
4087:

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

4080: EXCEPTION
4081: WHEN OTHERS THEN
4082:
4083: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4085: RAISE;
4086: END;
4087:
4088: END LOOP;

Line 4112: AND mst.DELETED_FLAG= MSC_UTIL.SYS_NO;

4108: mst.VOLUME_UOM,
4109: mst.SR_INSTANCE_ID
4110: FROM MSC_ST_TRIPS mst
4111: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
4112: AND mst.DELETED_FLAG= MSC_UTIL.SYS_NO;
4113:
4114: CURSOR c1_d IS
4115: SELECT
4116: mst.TRIP_ID,

Line 4120: AND mst.DELETED_FLAG= MSC_UTIL.SYS_YES;

4116: mst.TRIP_ID,
4117: mst.SR_INSTANCE_ID
4118: FROM MSC_ST_TRIPS mst
4119: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
4120: AND mst.DELETED_FLAG= MSC_UTIL.SYS_YES;
4121:
4122: CURSOR c2 IS
4123: SELECT
4124: STOP_ID,

Line 4134: AND mst.DELETED_FLAG= MSC_UTIL.SYS_NO;

4130: TRIP_ID,
4131: mst.SR_INSTANCE_ID
4132: FROM MSC_ST_TRIP_STOPS mst
4133: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
4134: AND mst.DELETED_FLAG= MSC_UTIL.SYS_NO;
4135:
4136: CURSOR c2_d IS
4137: SELECT
4138: mst.STOP_ID,

Line 4142: AND mst.DELETED_FLAG= MSC_UTIL.SYS_YES;

4138: mst.STOP_ID,
4139: mst.SR_INSTANCE_ID
4140: FROM MSC_ST_TRIP_STOPS mst
4141: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
4142: AND mst.DELETED_FLAG= MSC_UTIL.SYS_YES;
4143:
4144:
4145: c_count NUMBER:= 0;
4146: lv_tbl VARCHAR2(30);

Line 4151: IF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

4147: lv_sql_stmt VARCHAR2(5000);
4148:
4149: BEGIN
4150:
4151: IF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
4152:
4153: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4154:
4155: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIPS', MSC_CL_COLLECTION.v_instance_id, -1);

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

4257: EXCEPTION WHEN OTHERS THEN
4258:
4259: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4260:
4261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4262: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4263: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4264: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4262: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4263: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4264: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4266:
4267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4268: RAISE;
4269:

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

4263: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4264: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4266:
4267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4268: RAISE;
4269:
4270: ELSE
4271: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

4267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4268: RAISE;
4269:
4270: ELSE
4271: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4272:
4273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4274: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4275: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

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

4269:
4270: ELSE
4271: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4272:
4273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4274: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4275: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4276: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4274: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4275: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4276: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4278:
4279:
4280: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4281: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

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

4279:
4280: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4281: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4282: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4285:
4286: END IF;
4287:

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

4280: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4281: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4282: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4285:
4286: END IF;
4287:
4288: END;

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

4361: EXCEPTION WHEN OTHERS THEN
4362:
4363: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4364:
4365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4366: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4367: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4368: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4366: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4367: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4368: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4370:
4371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4372: RAISE;
4373:

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

4367: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4368: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4370:
4371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4372: RAISE;
4373:
4374: ELSE
4375: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

4371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4372: RAISE;
4373:
4374: ELSE
4375: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4376:
4377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4378: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

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

4373:
4374: ELSE
4375: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4376:
4377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4378: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4380: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4378: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4380: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4382:
4383:
4384: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4385: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');

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

4383:
4384: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4385: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4386: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4388:
4389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4390:
4391: END IF;

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

4385: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4386: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4388:
4389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4390:
4391: END IF;
4392:
4393: END;

Line 4459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge stale currency data. '|| reqid);

4455: 'MSC_CL_OTHER_ODS_LOAD',
4456: 'PURGE_STALE_CURRENCY_CONV',
4457: Null);
4458: commit ;
4459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge stale currency data. '|| reqid);
4460: EXCEPTION
4461: WHEN OTHERS THEN
4462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4463: RAISE;

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

4458: commit ;
4459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge stale currency data. '|| reqid);
4460: EXCEPTION
4461: WHEN OTHERS THEN
4462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4463: RAISE;
4464: End;
4465:
4466: Begin

Line 4477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP MSCHUBRMV to refresh MV. '|| reqid);

4473: Null,
4474: False,
4475: 1);
4476: commit ;
4477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP MSCHUBRMV to refresh MV. '|| reqid);
4478: EXCEPTION
4479: WHEN OTHERS THEN
4480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4481: RAISE;

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

4476: commit ;
4477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP MSCHUBRMV to refresh MV. '|| reqid);
4478: EXCEPTION
4479: WHEN OTHERS THEN
4480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4481: RAISE;
4482: End;
4483:
4484: EXCEPTION

Line 4487: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

4483:
4484: EXCEPTION
4485: WHEN OTHERS THEN
4486:
4487: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4489: RAISE;
4490:
4491: END LOAD_CURRENCY_CONVERSION;

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

4484: EXCEPTION
4485: WHEN OTHERS THEN
4486:
4487: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4489: RAISE;
4490:
4491: END LOAD_CURRENCY_CONVERSION;
4492:

Line 4519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');

4515: END IF;
4516: /* Get the swap table index number in the list*/
4517: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_DELIVERY_DETAILS'); --ods table name
4518: IF i = -1 THEN
4519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
4520: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4521: END IF;
4522: /* Do phase 1 exchange*/
4523:

Line 4528: MSC_UTIL.SYS_NO ) THEN

4524: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
4525: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4526: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4527: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4528: MSC_UTIL.SYS_NO ) THEN
4529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
4530: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4531: END IF;
4532:

Line 4529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');

4525: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4526: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4527: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4528: MSC_UTIL.SYS_NO ) THEN
4529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
4530: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4531: END IF;
4532:
4533: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '

Line 4613: ||' and organization_id not '|| msc_Util.v_in_org_str;

4609: ||' CREATED_BY,'
4610: ||' LAST_UPDATE_LOGIN'
4611: ||' FROM MSC_DELIVERY_DETAILS '
4612: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4613: ||' and organization_id not '|| msc_Util.v_in_org_str;
4614:
4615:
4616: EXECUTE IMMEDIATE lv_sql_stmt;
4617: /* Add code to create indexes on this temp table*/

Line 4633: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge MSC_TRANSPORTATION_UPDATES. '|| reqid);

4629: 'MSC_WS_OTM_BPEL',
4630: 'PURGETRANSPORTATIONUPDATES',
4631: Null);
4632: commit ;
4633: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge MSC_TRANSPORTATION_UPDATES. '|| reqid);
4634: EXCEPTION
4635: WHEN OTHERS THEN
4636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4637: RAISE;

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

4632: commit ;
4633: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge MSC_TRANSPORTATION_UPDATES. '|| reqid);
4634: EXCEPTION
4635: WHEN OTHERS THEN
4636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4637: RAISE;
4638: End;
4639: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh
4640: END LOAD_DELIVERY_DETAILS;

Line 4654: WHERE msv.deleted_flag = MSC_UTIL.SYS_NO

4650: msv.VISIT_END_DATE,
4651: msv.ORGANIZATION_ID,
4652: msv.SR_INSTANCE_ID
4653: FROM MSC_ST_VISITS msv
4654: WHERE msv.deleted_flag = MSC_UTIL.SYS_NO
4655: AND msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4656:
4657: CURSOR c_del IS
4658: SELECT

Line 4663: WHERE msv.deleted_flag = MSC_UTIL.SYS_YES

4659: msv.VISIT_ID,
4660: msv.ORGANIZATION_ID,
4661: msv.SR_INSTANCE_ID
4662: FROM MSC_ST_VISITS msv
4663: WHERE msv.deleted_flag = MSC_UTIL.SYS_YES
4664: and msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4665:
4666: BEGIN
4667:

Line 4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD VISITS');

4664: and msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4665:
4666: BEGIN
4667:
4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD VISITS');
4669:
4670: FOR c_rec IN c_del LOOP
4671: BEGIN
4672:

Line 4686: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of Visits.');

4682:
4683: EXCEPTION
4684: WHEN OTHERS THEN
4685:
4686: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of Visits.');
4687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4688: RAISE;
4689: END;
4690: END LOOP;

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

4683: EXCEPTION
4684: WHEN OTHERS THEN
4685:
4686: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of Visits.');
4687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4688: RAISE;
4689: END;
4690: END LOOP;
4691:

Line 4745: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

4741:
4742: EXCEPTION
4743: WHEN OTHERS THEN
4744:
4745: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4747: RAISE;
4748: END;
4749:

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

4742: EXCEPTION
4743: WHEN OTHERS THEN
4744:
4745: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4747: RAISE;
4748: END;
4749:
4750: END LOOP;

Line 4764: WHERE mswm.deleted_flag = MSC_UTIL.SYS_NO

4760: mswm.VISIT_ID,
4761: mswm.ORGANIZATION_ID,
4762: mswm.SR_INSTANCE_ID
4763: FROM MSC_ST_WO_MILESTONES mswm
4764: WHERE mswm.deleted_flag = MSC_UTIL.SYS_NO
4765: AND mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4766:
4767: CURSOR c_del IS
4768: SELECT

Line 4774: WHERE mswm.deleted_flag = MSC_UTIL.SYS_YES

4770: mswm.VISIT_ID,
4771: mswm.ORGANIZATION_ID,
4772: mswm.SR_INSTANCE_ID
4773: FROM MSC_ST_WO_MILESTONES mswm
4774: WHERE mswm.deleted_flag = MSC_UTIL.SYS_YES
4775: and mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4776:
4777: BEGIN
4778: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD MILESTONES- Inst :'||MSC_CL_COLLECTION.v_instance_id );

Line 4778: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD MILESTONES- Inst :'||MSC_CL_COLLECTION.v_instance_id );

4774: WHERE mswm.deleted_flag = MSC_UTIL.SYS_YES
4775: and mswm.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4776:
4777: BEGIN
4778: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD MILESTONES- Inst :'||MSC_CL_COLLECTION.v_instance_id );
4779: FOR c_rec IN c_del LOOP
4780: BEGIN
4781:
4782: DELETE MSC_WO_MILESTONES

Line 4791: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of Milestones.');

4787:
4788: EXCEPTION
4789: WHEN OTHERS THEN
4790:
4791: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of Milestones.');
4792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4793: RAISE;
4794: END;
4795:

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

4788: EXCEPTION
4789: WHEN OTHERS THEN
4790:
4791: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of Milestones.');
4792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4793: RAISE;
4794: END;
4795:
4796: END LOOP;

Line 4845: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

4841: END IF;
4842: EXCEPTION
4843: WHEN OTHERS THEN
4844:
4845: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4847: RAISE;
4848: END;
4849:

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

4842: EXCEPTION
4843: WHEN OTHERS THEN
4844:
4845: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4847: RAISE;
4848: END;
4849:
4850: END LOOP;

Line 4863: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_NO

4859: mswbs.DISPLAY_NAME,
4860: mswbs.ORGANIZATION_ID,
4861: mswbs.SR_INSTANCE_ID
4862: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs
4863: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_NO
4864: AND mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4865:
4866: CURSOR c_del IS
4867: SELECT

Line 4873: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_YES

4869: mswbs.DISPLAY_NAME,
4870: mswbs.ORGANIZATION_ID,
4871: mswbs.SR_INSTANCE_ID
4872: FROM MSC_ST_WORK_BREAKDOWN_STRUCT mswbs
4873: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_YES
4874: and mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4875:
4876: BEGIN
4877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WBS- Inst :'||MSC_CL_COLLECTION.v_instance_id );

Line 4877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WBS- Inst :'||MSC_CL_COLLECTION.v_instance_id );

4873: WHERE mswbs.deleted_flag = MSC_UTIL.SYS_YES
4874: and mswbs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4875:
4876: BEGIN
4877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WBS- Inst :'||MSC_CL_COLLECTION.v_instance_id );
4878: FOR c_rec IN c_del LOOP
4879: BEGIN
4880:
4881: DELETE MSC_WORK_BREAKDOWN_STRUCT

Line 4889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WBS.');

4885:
4886: EXCEPTION
4887: WHEN OTHERS THEN
4888:
4889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WBS.');
4890: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4891: RAISE;
4892: END;
4893:

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

4886: EXCEPTION
4887: WHEN OTHERS THEN
4888:
4889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WBS.');
4890: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4891: RAISE;
4892: END;
4893:
4894: END LOOP;

Line 4941: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

4937: END IF;
4938: EXCEPTION
4939: WHEN OTHERS THEN
4940:
4941: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4943: RAISE;
4944: END;
4945:

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

4938: EXCEPTION
4939: WHEN OTHERS THEN
4940:
4941: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4943: RAISE;
4944: END;
4945:
4946: END LOOP;

Line 4974: WHERE mswa.deleted_flag = MSC_UTIL.SYS_NO

4970: mswa.NEXT_MILESTONE,
4971: mswa.ORGANIZATION_ID,
4972: mswa.SR_INSTANCE_ID
4973: FROM MSC_ST_WO_ATTRIBUTES mswa
4974: WHERE mswa.deleted_flag = MSC_UTIL.SYS_NO
4975: AND mswa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4976:
4977: CURSOR c_del IS
4978: SELECT

Line 4984: WHERE mswa.deleted_flag = MSC_UTIL.SYS_YES

4980: mswa.VISIT_ID,
4981: mswa.ORGANIZATION_ID,
4982: mswa.SR_INSTANCE_ID
4983: FROM MSC_ST_WO_ATTRIBUTES mswa
4984: WHERE mswa.deleted_flag = MSC_UTIL.SYS_YES
4985: and mswa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4986:
4987: BEGIN
4988:

Line 4989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WO ATTRIBUTES- Inst :'||MSC_CL_COLLECTION.v_instance_id );

4985: and mswa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4986:
4987: BEGIN
4988:
4989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WO ATTRIBUTES- Inst :'||MSC_CL_COLLECTION.v_instance_id );
4990: FOR c_rec IN c_del LOOP
4991: BEGIN
4992:
4993: DELETE MSC_WO_ATTRIBUTES

Line 5002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO attributes.');

4998:
4999: EXCEPTION
5000: WHEN OTHERS THEN
5001:
5002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO attributes.');
5003: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5004: RAISE;
5005: END;
5006:

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

4999: EXCEPTION
5000: WHEN OTHERS THEN
5001:
5002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO attributes.');
5003: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5004: RAISE;
5005: END;
5006:
5007: END LOOP;

Line 5098: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

5094: END IF;
5095: EXCEPTION
5096: WHEN OTHERS THEN
5097:
5098: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
5099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5100: RAISE;
5101: END;
5102:

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

5095: EXCEPTION
5096: WHEN OTHERS THEN
5097:
5098: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
5099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5100: RAISE;
5101: END;
5102:
5103: END LOOP;

Line 5122: WHERE mswth.deleted_flag = MSC_UTIL.SYS_NO

5118: mswth.MAX_SEP_TIME_UNIT,
5119: mswth.ORGANIZATION_ID,
5120: mswth.SR_INSTANCE_ID
5121: FROM MSC_ST_WO_TASK_HIERARCHY mswth
5122: WHERE mswth.deleted_flag = MSC_UTIL.SYS_NO
5123: AND mswth.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5124:
5125: CURSOR c_del IS
5126: SELECT

Line 5132: WHERE mswth.deleted_flag = MSC_UTIL.SYS_YES

5128: mswth.NEXT_SUPPLY_ID,
5129: mswth.ORGANIZATION_ID,
5130: mswth.SR_INSTANCE_ID
5131: FROM MSC_ST_WO_TASK_HIERARCHY mswth
5132: WHERE mswth.deleted_flag = MSC_UTIL.SYS_YES
5133: AND mswth.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5134:
5135: BEGIN
5136:

Line 5137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WO_TASK_HIERARCHY- Inst :'||MSC_CL_COLLECTION.v_instance_id );

5133: AND mswth.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5134:
5135: BEGIN
5136:
5137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WO_TASK_HIERARCHY- Inst :'||MSC_CL_COLLECTION.v_instance_id );
5138:
5139: FOR c_rec IN c_del LOOP
5140: BEGIN
5141:

Line 5151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO task hierarchy.');

5147:
5148: EXCEPTION
5149: WHEN OTHERS THEN
5150:
5151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO task hierarchy.');
5152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5153: RAISE;
5154: END;
5155:

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

5148: EXCEPTION
5149: WHEN OTHERS THEN
5150:
5151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO task hierarchy.');
5152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5153: RAISE;
5154: END;
5155:
5156: END LOOP;

Line 5218: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

5214: END IF;
5215: EXCEPTION
5216: WHEN OTHERS THEN
5217:
5218: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
5219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5220: RAISE;
5221: END;
5222:

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

5215: EXCEPTION
5216: WHEN OTHERS THEN
5217:
5218: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
5219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5220: RAISE;
5221: END;
5222:
5223: END LOOP;

Line 5247: WHERE mswor.deleted_flag = MSC_UTIL.SYS_NO

5243: mswor.TO_OP_DESC,
5244: mswor.ORGANIZATION_ID,
5245: mswor.SR_INSTANCE_ID
5246: FROM MSC_ST_WO_OPERATION_REL mswor
5247: WHERE mswor.deleted_flag = MSC_UTIL.SYS_NO
5248: AND mswor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5249:
5250: CURSOR c_del IS
5251: SELECT

Line 5260: WHERE mswor.deleted_flag = MSC_UTIL.SYS_YES

5256: mswor.TO_OP_RES_SEQ_NUM,
5257: mswor.ORGANIZATION_ID,
5258: mswor.SR_INSTANCE_ID
5259: FROM MSC_ST_WO_OPERATION_REL mswor
5260: WHERE mswor.deleted_flag = MSC_UTIL.SYS_YES
5261: and mswor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5262:
5263: BEGIN
5264:

Line 5265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WO_OPERATION REL- Inst :'||MSC_CL_COLLECTION.v_instance_id );

5261: and mswor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5262:
5263: BEGIN
5264:
5265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WO_OPERATION REL- Inst :'||MSC_CL_COLLECTION.v_instance_id );
5266:
5267: FOR c_rec IN c_del LOOP
5268: BEGIN
5269:

Line 5282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO operation Relation.');

5278:
5279: EXCEPTION
5280: WHEN OTHERS THEN
5281:
5282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO operation Relation.');
5283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5284: RAISE;
5285: END;
5286:

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

5279: EXCEPTION
5280: WHEN OTHERS THEN
5281:
5282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred during deletion of WO operation Relation.');
5283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5284: RAISE;
5285: END;
5286:
5287: END LOOP;

Line 5362: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

5358: END IF;
5359: EXCEPTION
5360: WHEN OTHERS THEN
5361:
5362: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
5363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5364: RAISE;
5365: END;
5366:

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

5359: EXCEPTION
5360: WHEN OTHERS THEN
5361:
5362: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
5363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5364: RAISE;
5365: END;
5366:
5367: END LOOP;

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

5382:
5383: BEGIN
5384:
5385:
5386: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
5387: lv_tbl:= 'ORG_AGGR_IBUC_'||MSC_CL_COLLECTION.v_instance_code;
5388: ELSE
5389: lv_tbl:= 'MSC_ORG_AGGR_IBUC';
5390:

Line 5400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);

5396: WHERE SAMPLE_DATE = trunc(lv_last_ibuc_coll_date);
5397:
5398: END IF;
5399:
5400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);
5401: /* bulk insert statement, used in case of target/complete collection */
5402:
5403: lv_cursor_stmt:=
5404: 'INSERT INTO '||lv_tbl

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

5454: MSC_CL_COLLECTION.v_current_user;
5455:
5456: EXCEPTION
5457: WHEN OTHERS THEN
5458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5459: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5460: END;
5461:
5462: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

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

5458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5459: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5460: END;
5461:
5462: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5463: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
5464: lv_retcode,
5465: 'MSC_ORG_AGGR_IBUC',
5466: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 5467: MSC_UTIL.G_ERROR);

5463: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
5464: lv_retcode,
5465: 'MSC_ORG_AGGR_IBUC',
5466: MSC_CL_COLLECTION.v_INSTANCE_CODE,
5467: MSC_UTIL.G_ERROR);
5468:
5469: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5471: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 5469: IF lv_retcode = MSC_UTIL.G_ERROR THEN

5465: 'MSC_ORG_AGGR_IBUC',
5466: MSC_CL_COLLECTION.v_INSTANCE_CODE,
5467: MSC_UTIL.G_ERROR);
5468:
5469: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5471: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5472: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5473: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5466: MSC_CL_COLLECTION.v_INSTANCE_CODE,
5467: MSC_UTIL.G_ERROR);
5468:
5469: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5471: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5472: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5473: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5474: END IF;

Line 5472: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

5468:
5469: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5471: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5472: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5473: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5474: END IF;
5475:
5476: END IF;

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

5469: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5470: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5471: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5472: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5473: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5474: END IF;
5475:
5476: END IF;
5477:

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

5479: COMMIT;
5480: EXCEPTION
5481: WHEN OTHERS THEN
5482: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
5483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');
5484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');
5487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');
5484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');
5487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5489: RAISE;
5490: ELSE
5491: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');
5487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5489: RAISE;
5490: ELSE
5491: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');

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

5487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5489: RAISE;
5490: ELSE
5491: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');
5493: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5494: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5495: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');

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

5488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5489: RAISE;
5490: ELSE
5491: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');
5493: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5494: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5495: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');
5496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');
5493: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5494: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5495: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');
5496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5497:
5498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5499: FND_MESSAGE.SET_TOKEN('COLUMN', 'INVENTORY_ITEM_ID');
5500: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );

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

5497:
5498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5499: FND_MESSAGE.SET_TOKEN('COLUMN', 'INVENTORY_ITEM_ID');
5500: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );
5501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5502: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5503:
5504: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5505: FND_MESSAGE.SET_TOKEN('COLUMN', 'SAMPLE_DATE');

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

5498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5499: FND_MESSAGE.SET_TOKEN('COLUMN', 'INVENTORY_ITEM_ID');
5500: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );
5501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5502: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5503:
5504: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5505: FND_MESSAGE.SET_TOKEN('COLUMN', 'SAMPLE_DATE');
5506: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );

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

5503:
5504: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5505: FND_MESSAGE.SET_TOKEN('COLUMN', 'SAMPLE_DATE');
5506: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );
5507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5509:
5510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ZONE');

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

5504: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5505: FND_MESSAGE.SET_TOKEN('COLUMN', 'SAMPLE_DATE');
5506: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );
5507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5509:
5510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ZONE');
5512: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );

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

5509:
5510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ZONE');
5512: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );
5513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5515:
5516: END IF;
5517:

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

5510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ZONE');
5512: --FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.ITEM_INSTANCE_ID) );
5513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5515:
5516: END IF;
5517:
5518: COMMIT;

Line 5542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Instance ID---' || lv_instance_id ||

5538: lv_instance_id := instance_id;
5539: lv_assign_set_id := assignment_set_id;
5540: lv_refresh_type := complete_refresh;
5541:
5542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Instance ID---' || lv_instance_id ||
5543: ' Assignment Set Id ----' || lv_assign_set_id || ' Refresh Type ----' ||lv_refresh_type) ;
5544:
5545: /*SELECT ASSIGNMENT_SET_ID INTO lv_assign_set_id
5546: FROM MSC_ASSIGNMENT_SETS

Line 5550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Aset id ---' || lv_assign_set_id) ;

5546: FROM MSC_ASSIGNMENT_SETS
5547: WHERE ASSIGNMENT_SET_NAME = lv_assign_set_name
5548: AND SR_INSTANCE_ID = lv_instance_id;*/
5549:
5550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Aset id ---' || lv_assign_set_id) ;
5551:
5552: SELECT IBUCCP_LCID, lcid INTO n1, n2
5553: FROM MSC_APPS_INSTANCES WHERE instance_id = lv_instance_id ;
5554:

Line 5587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt-' ||lv_sql_stmt);

5583: IF lv_refresh_type = 2 THEN
5584:
5585: lv_sql_stmt := lv_sql_stmt || ' AND MOAI.REFRESH_NUMBER > :n1';
5586:
5587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt-' ||lv_sql_stmt);
5588: EXECUTE IMMEDIATE lv_sql_stmt using lv_assign_set_id , lv_assign_set_id ,lv_instance_id,n1;
5589:
5590: ELSE
5591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt-' ||lv_sql_stmt);

Line 5591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt-' ||lv_sql_stmt);

5587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt-' ||lv_sql_stmt);
5588: EXECUTE IMMEDIATE lv_sql_stmt using lv_assign_set_id , lv_assign_set_id ,lv_instance_id,n1;
5589:
5590: ELSE
5591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt-' ||lv_sql_stmt);
5592:
5593: EXECUTE IMMEDIATE lv_sql_stmt using lv_assign_set_id , lv_assign_set_id ,lv_instance_id;
5594:
5595: END IF ;

Line 5597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Popualted Org info. for Install base Aggregations');

5593: EXECUTE IMMEDIATE lv_sql_stmt using lv_assign_set_id , lv_assign_set_id ,lv_instance_id;
5594:
5595: END IF ;
5596:
5597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Popualted Org info. for Install base Aggregations');
5598: COMMIT;
5599:
5600: UPDATE MSC_APPS_INSTANCES
5601: SET IBUCCP_LCID = n2 WHERE INSTANCE_ID= lv_instance_id;

Line 5607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'ERROR ' || ERRBUF) ;

5603:
5604: EXCEPTION
5605: WHEN OTHERS THEN
5606: ERRBUF := SQLERRM;
5607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'ERROR ' || ERRBUF) ;
5608:
5609: END POPULATE_ORG;
5610:
5611: PROCEDURE LOAD_SHORT_TEXT IS

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

5618:
5619: BEGIN
5620:
5621: BEGIN
5622: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5623: lv_tbl:= ' DOC_ATTACHMENTS_'||MSC_CL_COLLECTION.v_instance_code;
5624: ELSE
5625: lv_tbl:= ' MSC_DOC_ATTACHMENTS ';
5626: END IF;

Line 5628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);

5624: ELSE
5625: lv_tbl:= ' MSC_DOC_ATTACHMENTS ';
5626: END IF;
5627:
5628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);
5629: /* bulk insert statement, used in case of target/complete collection
5630: This stmt needs to be repeated for each entity_name covered */
5631:
5632: lv_cursor_stmt:=

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

5704:
5705: COMMIT;
5706: EXCEPTION
5707: WHEN OTHERS THEN
5708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5709: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5710: END;
5711:
5712:

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

5709: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5710: END;
5711:
5712:
5713: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5714: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_DOC_ATTACHMENTS',
5715: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5716:
5717: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 5715: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);

5711:
5712:
5713: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5714: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_DOC_ATTACHMENTS',
5715: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5716:
5717: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5719: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 5717: IF lv_retcode = MSC_UTIL.G_ERROR THEN

5713: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5714: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_DOC_ATTACHMENTS',
5715: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5716:
5717: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5719: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5720: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5721: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5714: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_DOC_ATTACHMENTS',
5715: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5716:
5717: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5719: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5720: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5721: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5722: END IF;

Line 5720: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

5716:
5717: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5719: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5720: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5721: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5722: END IF;
5723:
5724: END IF;

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

5717: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5719: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5720: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5721: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5722: END IF;
5723:
5724: END IF;
5725:

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

5729: WHEN OTHERS THEN
5730:
5731: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
5732:
5733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5734: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5735: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5736: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DOC_ATTACHMENTS');
5737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5734: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5735: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5736: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DOC_ATTACHMENTS');
5737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5738:
5739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5740: RAISE;
5741:

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

5735: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5736: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DOC_ATTACHMENTS');
5737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5738:
5739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5740: RAISE;
5741:
5742: ELSE
5743: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5740: RAISE;
5741:
5742: ELSE
5743: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5744:
5745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5746: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5747: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');

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

5741:
5742: ELSE
5743: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5744:
5745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5746: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5747: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5748: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DOC_ATTACHMENTS');
5749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5746: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5747: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5748: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DOC_ATTACHMENTS');
5749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5751: END IF;
5752: END; -- load for MSC_DOC_ATTACHMENTS
5753:

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

5746: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5747: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5748: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DOC_ATTACHMENTS');
5749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5751: END IF;
5752: END; -- load for MSC_DOC_ATTACHMENTS
5753:
5754: BEGIN -- load for MSC_SHORT_TEXT

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

5752: END; -- load for MSC_DOC_ATTACHMENTS
5753:
5754: BEGIN -- load for MSC_SHORT_TEXT
5755:
5756: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5757: lv_tbl:= ' SHORT_TEXT_'||MSC_CL_COLLECTION.v_instance_code;
5758: ELSE
5759: lv_tbl:= ' MSC_SHORT_TEXT';
5760: END IF ;

Line 5762: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);

5758: ELSE
5759: lv_tbl:= ' MSC_SHORT_TEXT';
5760: END IF ;
5761:
5762: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);
5763: /* bulk insert statement, used in case of target/complete collection */
5764: lv_cursor_stmt:=
5765: ' INSERT INTO '||lv_tbl
5766: ||'( MEDIA_ID,'

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

5800:
5801: COMMIT;
5802: EXCEPTION
5803: WHEN OTHERS THEN
5804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5805: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5806: END;
5807:
5808: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

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

5804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5805: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5806: END;
5807:
5808: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5809: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_SHORT_TEXT',
5810: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5811:
5812: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 5810: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);

5806: END;
5807:
5808: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5809: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_SHORT_TEXT',
5810: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5811:
5812: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5814: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 5812: IF lv_retcode = MSC_UTIL.G_ERROR THEN

5808: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5809: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_SHORT_TEXT',
5810: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5811:
5812: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5814: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5815: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5816: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5809: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_SHORT_TEXT',
5810: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5811:
5812: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5814: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5815: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5816: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5817: END IF;

Line 5815: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

5811:
5812: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5814: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5815: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5816: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5817: END IF;
5818:
5819: END IF;

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

5812: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5814: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5815: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5816: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5817: END IF;
5818:
5819: END IF;
5820:

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

5824: WHEN OTHERS THEN
5825:
5826: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
5827:
5828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHORT_TEXT');
5832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHORT_TEXT');
5832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5833:
5834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5835: RAISE;
5836:

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

5830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHORT_TEXT');
5832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5833:
5834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5835: RAISE;
5836:
5837: ELSE
5838: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5835: RAISE;
5836:
5837: ELSE
5838: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5839:
5840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5841: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5842: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');

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

5836:
5837: ELSE
5838: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5839:
5840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5841: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5842: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5843: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHORT_TEXT');
5844: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5841: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5842: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5843: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHORT_TEXT');
5844: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5846: END IF;
5847: END; -- load for MSC_SHORT_TEXT
5848:

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

5841: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5842: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SHORT_TEXT');
5843: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHORT_TEXT');
5844: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5846: END IF;
5847: END; -- load for MSC_SHORT_TEXT
5848:
5849:

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

5859: lv_retcode NUMBER;
5860:
5861: BEGIN
5862:
5863: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5864: lv_tbl:= ' LONG_TEXT_'||MSC_CL_COLLECTION.v_instance_code;
5865: ELSE
5866: lv_tbl:= ' MSC_LONG_TEXT ';
5867: END IF;

Line 5869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);

5865: ELSE
5866: lv_tbl:= ' MSC_LONG_TEXT ';
5867: END IF;
5868:
5869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Inserting data into table ' || lv_tbl);
5870: /* bulk insert statement, used in case of target/complete collection */
5871: lv_cursor_stmt:=
5872:
5873: ' INSERT INTO '||lv_tbl

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

5909: COMMIT;
5910:
5911: EXCEPTION
5912: WHEN OTHERS THEN
5913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5914: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5915: END;
5916:
5917: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

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

5913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5914: -- IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
5915: END;
5916:
5917: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5918: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_LONG_TEXT',
5919: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5920:
5921: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 5919: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);

5915: END;
5916:
5917: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5918: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_LONG_TEXT',
5919: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5920:
5921: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5923: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;

Line 5921: IF lv_retcode = MSC_UTIL.G_ERROR THEN

5917: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5918: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_LONG_TEXT',
5919: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5920:
5921: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5923: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5924: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5918: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,lv_retcode,'MSC_LONG_TEXT',
5919: MSC_CL_COLLECTION.v_INSTANCE_CODE, MSC_UTIL.G_ERROR);
5920:
5921: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5923: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5924: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5926: END IF;

Line 5924: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

5920:
5921: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5923: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5924: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5926: END IF;
5927:
5928: END IF;

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

5921: IF lv_retcode = MSC_UTIL.G_ERROR THEN
5922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
5923: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
5924: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
5925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5926: END IF;
5927:
5928: END IF;
5929:

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

5934: WHEN OTHERS THEN
5935:
5936: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
5937:
5938: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5939: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5940: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_LONG_TEXT');
5941: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LONG_TEXT');
5942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5938: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5939: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5940: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_LONG_TEXT');
5941: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LONG_TEXT');
5942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5943:
5944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5945: RAISE;
5946:

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

5940: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_LONG_TEXT');
5941: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LONG_TEXT');
5942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5943:
5944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5945: RAISE;
5946:
5947: ELSE
5948: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

5944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5945: RAISE;
5946:
5947: ELSE
5948: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5949:
5950: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5951: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5952: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_LONG_TEXT');

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

5946:
5947: ELSE
5948: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5949:
5950: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5951: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5952: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_LONG_TEXT');
5953: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LONG_TEXT');
5954: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

5950: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5951: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5952: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_LONG_TEXT');
5953: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LONG_TEXT');
5954: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5956: END IF;
5957:
5958:

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

5951: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5952: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_LONG_TEXT');
5953: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LONG_TEXT');
5954: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5956: END IF;
5957:
5958:
5959: END LOAD_LONG_TEXT;