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 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 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 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 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 3849: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

3845:
3846: EXCEPTION
3847: WHEN OTHERS THEN
3848:
3849: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3850: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3851: RAISE;
3852:
3853: END LOAD_SALES_CHANNEL;

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

3846: EXCEPTION
3847: WHEN OTHERS THEN
3848:
3849: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3850: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3851: RAISE;
3852:
3853: END LOAD_SALES_CHANNEL;
3854:

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

3947:
3948: EXCEPTION
3949: WHEN OTHERS THEN
3950:
3951: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3952: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3953: RAISE;
3954:
3955: END LOAD_FISCAL_CALENDAR;

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

3948: EXCEPTION
3949: WHEN OTHERS THEN
3950:
3951: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
3952: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3953: RAISE;
3954:
3955: END LOAD_FISCAL_CALENDAR;
3956:

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

3970: mst.VOLUME_UOM,
3971: mst.SR_INSTANCE_ID
3972: FROM MSC_ST_TRIPS mst
3973: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3974: AND mst.DELETED_FLAG= MSC_UTIL.SYS_NO;
3975:
3976: CURSOR c1_d IS
3977: SELECT
3978: mst.TRIP_ID,

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

3978: mst.TRIP_ID,
3979: mst.SR_INSTANCE_ID
3980: FROM MSC_ST_TRIPS mst
3981: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3982: AND mst.DELETED_FLAG= MSC_UTIL.SYS_YES;
3983:
3984: CURSOR c2 IS
3985: SELECT
3986: STOP_ID,

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

3992: TRIP_ID,
3993: mst.SR_INSTANCE_ID
3994: FROM MSC_ST_TRIP_STOPS mst
3995: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3996: AND mst.DELETED_FLAG= MSC_UTIL.SYS_NO;
3997:
3998: CURSOR c2_d IS
3999: SELECT
4000: mst.STOP_ID,

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

4000: mst.STOP_ID,
4001: mst.SR_INSTANCE_ID
4002: FROM MSC_ST_TRIP_STOPS mst
4003: WHERE mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
4004: AND mst.DELETED_FLAG= MSC_UTIL.SYS_YES;
4005:
4006:
4007: c_count NUMBER:= 0;
4008: lv_tbl VARCHAR2(30);

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

4009: lv_sql_stmt VARCHAR2(5000);
4010:
4011: BEGIN
4012:
4013: IF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
4014:
4015: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4016:
4017: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIPS', MSC_CL_COLLECTION.v_instance_id, -1);

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

4119: EXCEPTION WHEN OTHERS THEN
4120:
4121: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4122:
4123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4128:
4129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4130: RAISE;
4131:

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

4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4128:
4129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4130: RAISE;
4131:
4132: ELSE
4133: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

4129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4130: RAISE;
4131:
4132: ELSE
4133: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4134:
4135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

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

4131:
4132: ELSE
4133: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4134:
4135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4140:
4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

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

4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4144: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4147:
4148: END IF;
4149:

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

4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4144: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4147:
4148: END IF;
4149:
4150: END;

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

4223: EXCEPTION WHEN OTHERS THEN
4224:
4225: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4226:
4227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4232:
4233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4234: RAISE;
4235:

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

4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4232:
4233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4234: RAISE;
4235:
4236: ELSE
4237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

4233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4234: RAISE;
4235:
4236: ELSE
4237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4238:
4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

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

4235:
4236: ELSE
4237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4238:
4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:
4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');

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

4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4248: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4250:
4251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4252:
4253: END IF;

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

4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4248: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4250:
4251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4252:
4253: END IF;
4254:
4255: END;

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

4317: 'MSC_CL_OTHER_ODS_LOAD',
4318: 'PURGE_STALE_CURRENCY_CONV',
4319: Null);
4320: commit ;
4321: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge stale currency data. '|| reqid);
4322: EXCEPTION
4323: WHEN OTHERS THEN
4324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4325: RAISE;

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

4320: commit ;
4321: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge stale currency data. '|| reqid);
4322: EXCEPTION
4323: WHEN OTHERS THEN
4324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4325: RAISE;
4326: End;
4327:
4328: Begin

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

4335: 'MSC_PHUB_PKG',
4336: 'REFRESH_MVS',
4337: 1);
4338: commit ;
4339: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP to refresh MV. '|| reqid);
4340: EXCEPTION
4341: WHEN OTHERS THEN
4342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4343: RAISE;

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

4338: commit ;
4339: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP to refresh MV. '|| reqid);
4340: EXCEPTION
4341: WHEN OTHERS THEN
4342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4343: RAISE;
4344: End;
4345:
4346: EXCEPTION

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

4345:
4346: EXCEPTION
4347: WHEN OTHERS THEN
4348:
4349: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4351: RAISE;
4352:
4353: END LOAD_CURRENCY_CONVERSION;

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

4346: EXCEPTION
4347: WHEN OTHERS THEN
4348:
4349: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
4350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4351: RAISE;
4352:
4353: END LOAD_CURRENCY_CONVERSION;
4354:

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

4377: END IF;
4378: /* Get the swap table index number in the list*/
4379: i := MSC_CL_EXCHANGE_PARTTBL.get_SWAP_table_index('MSC_DELIVERY_DETAILS'); --ods table name
4380: IF i = -1 THEN
4381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Table not in the list of SWAP partition');
4382: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4383: END IF;
4384: /* Do phase 1 exchange*/
4385:

Line 4390: MSC_UTIL.SYS_NO ) THEN

4386: IF NOT MSC_CL_EXCHANGE_PARTTBL.EXCHANGE_SINGLE_TAB_PARTN (
4387: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4388: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4389: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4390: MSC_UTIL.SYS_NO ) THEN
4391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
4392: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4393: END IF;
4394:

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

4387: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_name,
4388: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).stg_table_partn_name,
4389: MSC_CL_EXCHANGE_PARTTBL.v_swapTblList(i).temp_table_name,
4390: MSC_UTIL.SYS_NO ) THEN
4391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Exchange partition failed');
4392: RAISE MSC_CL_COLLECTION.EXCHANGE_PARTN_ERROR;
4393: END IF;
4394:
4395: EXECUTE IMMEDIATE ' Update msc_coll_parameters set '

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

4471: ||' CREATED_BY,'
4472: ||' LAST_UPDATE_LOGIN'
4473: ||' FROM MSC_DELIVERY_DETAILS '
4474: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4475: ||' and organization_id not '|| msc_Util.v_in_org_str;
4476:
4477:
4478: EXECUTE IMMEDIATE lv_sql_stmt;
4479: /* Add code to create indexes on this temp table*/

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

4491: 'MSC_WS_OTM_BPEL',
4492: 'PURGETRANSPORTATIONUPDATES',
4493: Null);
4494: commit ;
4495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge MSC_TRANSPORTATION_UPDATES. '|| reqid);
4496: EXCEPTION
4497: WHEN OTHERS THEN
4498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4499: RAISE;

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

4494: commit ;
4495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Submitted CP for purge MSC_TRANSPORTATION_UPDATES. '|| reqid);
4496: EXCEPTION
4497: WHEN OTHERS THEN
4498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4499: RAISE;
4500: End;
4501: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh
4502: END LOAD_DELIVERY_DETAILS;