APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on FND_MESSAGE

Line 485: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

481: COMMIT;
482:
483: CLOSE c1; -- close the REF cursor
484:
485: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
486: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
487: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
489:

Line 486: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

482:
483: CLOSE c1; -- close the REF cursor
484:
485: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
486: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
487: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
489:
490: RETURN TRUE;

Line 488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);

484:
485: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
486: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
487: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
489:
490: RETURN TRUE;
491:
492: EXCEPTION

Line 605: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

601: COMMIT;
602:
603: CLOSE c1; -- close the REF cursor
604:
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
606: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
607: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
609:

Line 606: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

602:
603: CLOSE c1; -- close the REF cursor
604:
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
606: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
607: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
609:
610: RETURN TRUE;

Line 608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);

604:
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
606: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
607: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
609:
610: RETURN TRUE;
611:
612: EXCEPTION

Line 803: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

799:
800: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
801:
802: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
803: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
805: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
807:

Line 804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');

800: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
801:
802: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
803: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
805: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
807:
808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 805: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

801:
802: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
803: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
805: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
807:
808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
809: RAISE;

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

802: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
803: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
805: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
807:
808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
809: RAISE;
810:

Line 814: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

810:
811: ELSE
812: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
814: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
815: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
816: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
817: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 815: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');

811: ELSE
812: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
814: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
815: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
816: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
817: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
819: END IF;

Line 816: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

812: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
814: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
815: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
816: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
817: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
819: END IF;
820: END;

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

813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
814: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
815: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
816: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
817: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
819: END IF;
820: END;
821:

Line 1002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

998:
999: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1000:
1001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1006:

Line 1003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');

999: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1000:
1001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1000:
1001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1008: RAISE;

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

1001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1008: RAISE;
1009:

Line 1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1010: ELSE
1011: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:

Line 1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');

1011: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1021: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

Line 1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1021: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:

Line 1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1021: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024:

Line 1021: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1021: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024:
1025: /*

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

1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1021: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024:
1025: /*
1026: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1026: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024:
1025: /*
1026: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1027: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1028: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1029: */
1030:

Line 1027: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');

1023:
1024:
1025: /*
1026: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1027: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1028: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1029: */
1030:
1031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1028: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);

1024:
1025: /*
1026: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1027: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1028: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1029: */
1030:
1031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1032:

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

1027: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1028: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1029: */
1030:
1031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1032:
1033: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1035: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);

Line 1033: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1029: */
1030:
1031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1032:
1033: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1035: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');

1030:
1031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1032:
1033: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1035: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1038:

Line 1035: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);

1031: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1032:
1033: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1035: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1038:
1039:

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

1033: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1035: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1038:
1039:
1040: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1041: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 1040: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1038:
1039:
1040: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1041: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1042: FND_MESSAGE.SET_TOKEN('VALUE',
1043: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1044: MSC_CL_COLLECTION.v_instance_id));

Line 1041: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1038:
1039:
1040: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1041: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1042: FND_MESSAGE.SET_TOKEN('VALUE',
1043: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1044: MSC_CL_COLLECTION.v_instance_id));
1045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1042: FND_MESSAGE.SET_TOKEN('VALUE',

1038:
1039:
1040: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1041: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1042: FND_MESSAGE.SET_TOKEN('VALUE',
1043: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1044: MSC_CL_COLLECTION.v_instance_id));
1045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1046:

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

1041: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1042: FND_MESSAGE.SET_TOKEN('VALUE',
1043: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1044: MSC_CL_COLLECTION.v_instance_id));
1045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1046:
1047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));

Line 1047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1043: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1044: MSC_CL_COLLECTION.v_instance_id));
1045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1046:
1047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1051:

Line 1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');

1044: MSC_CL_COLLECTION.v_instance_id));
1045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1046:
1047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1051:
1052: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));

1045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1046:
1047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1051:
1052: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1053: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

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

1046:
1047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1051:
1052: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1053: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1054: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1052: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1051:
1052: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1053: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1054: FND_MESSAGE.SET_TOKEN('VALUE',
1055: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1056: c_rec.ORIGINATION_TYPE));

Line 1053: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

1049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1051:
1052: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1053: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1054: FND_MESSAGE.SET_TOKEN('VALUE',
1055: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1056: c_rec.ORIGINATION_TYPE));
1057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1054: FND_MESSAGE.SET_TOKEN('VALUE',

1050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1051:
1052: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1053: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1054: FND_MESSAGE.SET_TOKEN('VALUE',
1055: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1056: c_rec.ORIGINATION_TYPE));
1057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1058:

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

1053: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1054: FND_MESSAGE.SET_TOKEN('VALUE',
1055: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1056: c_rec.ORIGINATION_TYPE));
1057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1058:
1059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1060: END IF;
1061:

Line 1283: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1279:
1280: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1281:
1282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1283: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1284: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1285: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1287:

Line 1284: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');

1280: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1281:
1282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1283: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1284: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1285: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1287:
1288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1285: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

1281:
1282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1283: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1284: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1285: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1287:
1288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1289: RAISE;

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

1282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1283: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1284: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1285: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1287:
1288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1289: RAISE;
1290:

Line 1295: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1291: ELSE
1292: IF SQLCODE = -00001 THEN
1293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1294: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1295: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1296: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:

Line 1296: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');

1292: IF SQLCODE = -00001 THEN
1293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1294: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1295: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1296: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');

Line 1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

1293: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1294: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1295: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1296: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);

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

1294: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1295: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1296: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1302: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));

Line 1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');

1296: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1302: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1304:

Line 1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);

1297: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1302: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1304:
1305:

Line 1302: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));

1298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1302: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1304:
1305:
1306:

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

1299:
1300: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1301: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1302: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1304:
1305:
1306:
1307: ELSE

Line 1312: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1308:
1309: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1310:
1311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1312: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:

Line 1313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');

1309: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1310:
1311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1312: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:
1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

1310:
1311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1312: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:
1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1312: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:
1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1319: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:
1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1319: FND_MESSAGE.SET_TOKEN('VALUE',
1320: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1321: MSC_CL_COLLECTION.v_instance_id));

Line 1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

1314: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:
1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1319: FND_MESSAGE.SET_TOKEN('VALUE',
1320: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1321: MSC_CL_COLLECTION.v_instance_id));
1322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1319: FND_MESSAGE.SET_TOKEN('VALUE',

1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1316:
1317: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1319: FND_MESSAGE.SET_TOKEN('VALUE',
1320: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1321: MSC_CL_COLLECTION.v_instance_id));
1322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1323:

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

1318: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1319: FND_MESSAGE.SET_TOKEN('VALUE',
1320: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1321: MSC_CL_COLLECTION.v_instance_id));
1322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1323:
1324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1326: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

Line 1324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1320: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1321: MSC_CL_COLLECTION.v_instance_id));
1322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1323:
1324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1326: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1328:

Line 1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');

1321: MSC_CL_COLLECTION.v_instance_id));
1322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1323:
1324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1326: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1328:
1329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1326: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

1322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1323:
1324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1326: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1328:
1329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1330: END IF;

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

1323:
1324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1326: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1328:
1329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1330: END IF;
1331: END IF;

Line 1978: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1974:
1975: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1976:
1977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1978: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1979: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1980: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1982:

Line 1979: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');

1975: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1976:
1977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1978: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1979: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1980: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1982:
1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1980: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1976:
1977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1978: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1979: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1980: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1982:
1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1984: RAISE;

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

1977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1978: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1979: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1980: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1982:
1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1984: RAISE;
1985:

Line 1991: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1987:
1988: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1991: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1992: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:

Line 1992: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');

1988: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1991: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1992: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1991: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1992: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1991: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1992: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));

Line 1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1992: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2000:

Line 1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2000:
2001: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));

1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2000:
2001: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2002: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2000:
2001: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2002: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2003: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2001: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2000:
2001: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2002: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2003: FND_MESSAGE.SET_TOKEN('VALUE',
2004: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2005: MSC_CL_COLLECTION.v_instance_id));

Line 2002: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

1998: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2000:
2001: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2002: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2003: FND_MESSAGE.SET_TOKEN('VALUE',
2004: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2005: MSC_CL_COLLECTION.v_instance_id));
2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2003: FND_MESSAGE.SET_TOKEN('VALUE',

1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2000:
2001: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2002: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2003: FND_MESSAGE.SET_TOKEN('VALUE',
2004: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2005: MSC_CL_COLLECTION.v_instance_id));
2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2007:

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

2002: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2003: FND_MESSAGE.SET_TOKEN('VALUE',
2004: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2005: MSC_CL_COLLECTION.v_instance_id));
2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2007:
2008: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2009: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));

Line 2008: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2004: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2005: MSC_CL_COLLECTION.v_instance_id));
2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2007:
2008: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2009: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2012:

Line 2009: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');

2005: MSC_CL_COLLECTION.v_instance_id));
2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2007:
2008: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2009: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2012:
2013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));

2006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2007:
2008: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2009: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2012:
2013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

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

2007:
2008: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2009: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2012:
2013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2015: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2009: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2012:
2013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2015: FND_MESSAGE.SET_TOKEN('VALUE',
2016: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2017: lb_ORIGINATION_TYPE(j)));

Line 2014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

2010: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2012:
2013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2015: FND_MESSAGE.SET_TOKEN('VALUE',
2016: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2017: lb_ORIGINATION_TYPE(j)));
2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2015: FND_MESSAGE.SET_TOKEN('VALUE',

2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2012:
2013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2015: FND_MESSAGE.SET_TOKEN('VALUE',
2016: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2017: lb_ORIGINATION_TYPE(j)));
2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2019:

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

2014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2015: FND_MESSAGE.SET_TOKEN('VALUE',
2016: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2017: lb_ORIGINATION_TYPE(j)));
2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2019:
2020: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2021: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2022: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');

Line 2021: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2017: lb_ORIGINATION_TYPE(j)));
2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2019:
2020: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2021: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2022: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2023: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025: END IF;

Line 2022: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');

2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2019:
2020: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2021: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2022: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2023: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025: END IF;
2026:

Line 2023: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));

2019:
2020: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2021: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2022: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2023: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025: END IF;
2026:
2027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2020: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2021: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2022: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2023: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025: END IF;
2026:
2027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2028: END IF;

Line 2692: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2688:
2689: /* MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2690:
2691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2692: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2693: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:

Line 2693: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');

2689: /* MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2690:
2691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2692: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2693: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');

2690:
2691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2692: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2693: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/

2691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2692: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2693: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));

Line 2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2693: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2701:

Line 2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2701:
2702: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));

2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2701:
2702: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2703: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/

2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2701:
2702: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2703: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2704: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2702: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2701:
2702: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2703: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2704: FND_MESSAGE.SET_TOKEN('VALUE',
2705: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2706: MSC_CL_COLLECTION.v_instance_id));*/

Line 2703: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

2699: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2701:
2702: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2703: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2704: FND_MESSAGE.SET_TOKEN('VALUE',
2705: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2706: MSC_CL_COLLECTION.v_instance_id));*/
2707:

Line 2704: FND_MESSAGE.SET_TOKEN('VALUE',

2700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2701:
2702: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2703: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2704: FND_MESSAGE.SET_TOKEN('VALUE',
2705: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2706: MSC_CL_COLLECTION.v_instance_id));*/
2707:
2708: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2708: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2704: FND_MESSAGE.SET_TOKEN('VALUE',
2705: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2706: MSC_CL_COLLECTION.v_instance_id));*/
2707:
2708: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2709: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
2710: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
2711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2712:

Line 2709: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');

2705: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2706: MSC_CL_COLLECTION.v_instance_id));*/
2707:
2708: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2709: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
2710: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
2711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2712:
2713: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN

Line 2710: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));

2706: MSC_CL_COLLECTION.v_instance_id));*/
2707:
2708: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2709: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
2710: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
2711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2712:
2713: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
2714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/

2707:
2708: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2709: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
2710: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
2711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2712:
2713: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
2714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2715: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');

Line 2714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2710: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
2711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2712:
2713: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
2714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2715: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
2716: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2718: END IF;*/

Line 2715: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');

2711: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2712:
2713: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
2714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2715: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
2716: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2718: END IF;*/
2719:

Line 2716: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);

2712:
2713: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
2714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2715: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
2716: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2718: END IF;*/
2719:
2720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2713: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
2714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2715: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
2716: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2718: END IF;*/
2719:
2720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2721: RAISE;

Line 2989: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2985:
2986: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2987:
2988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2989: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2990: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
2991: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
2992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2993:

Line 2990: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');

2986: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2987:
2988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2989: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2990: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
2991: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
2992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2993:
2994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2991: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');

2987:
2988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2989: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2990: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
2991: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
2992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2993:
2994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2995: RAISE;

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

2988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2989: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2990: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
2991: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
2992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2993:
2994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2995: RAISE;
2996:

Line 3002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2998:
2999: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:

Line 3003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');

2999: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');

3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

Line 3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3011:

Line 3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3011:
3012: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3011:
3012: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3013: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3011:
3012: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3013: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3014: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3012: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3011:
3012: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3013: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3014: FND_MESSAGE.SET_TOKEN('VALUE',
3015: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3016: MSC_CL_COLLECTION.v_instance_id));

Line 3013: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

3009: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3011:
3012: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3013: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3014: FND_MESSAGE.SET_TOKEN('VALUE',
3015: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3016: MSC_CL_COLLECTION.v_instance_id));
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3014: FND_MESSAGE.SET_TOKEN('VALUE',

3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3011:
3012: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3013: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3014: FND_MESSAGE.SET_TOKEN('VALUE',
3015: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3016: MSC_CL_COLLECTION.v_instance_id));
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:

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

3013: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3014: FND_MESSAGE.SET_TOKEN('VALUE',
3015: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3016: MSC_CL_COLLECTION.v_instance_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', 'TRANSACTION_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));

Line 3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3015: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3016: MSC_CL_COLLECTION.v_instance_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', 'TRANSACTION_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:

Line 3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');

3016: MSC_CL_COLLECTION.v_instance_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', 'TRANSACTION_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_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', 'TRANSACTION_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3025: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_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', 'TRANSACTION_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3025: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3026: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));

Line 3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3025: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3026: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3028:

Line 3025: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');

3021: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3025: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3026: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3028:
3029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3026: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));

3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3025: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3026: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3028:
3029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3030: END IF;

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

3023:
3024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3025: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3026: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3028:
3029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3030: END IF;
3031:

Line 3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3196:
3197: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3198:
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3202: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3204:

Line 3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');

3197: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3198:
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3202: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3204:
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3202: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

3198:
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3202: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3204:
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3206: RAISE;

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

3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3200: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3201: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3202: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3204:
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3206: RAISE;
3207:

Line 3212: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3208: ELSE
3209: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3210:
3211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3212: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3213: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:

Line 3213: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');

3209: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3210:
3211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3212: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3213: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

3210:
3211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3212: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3213: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3212: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3213: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3213: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',
3220: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3221: MSC_CL_COLLECTION.v_instance_id));

Line 3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

3214: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',
3220: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3221: MSC_CL_COLLECTION.v_instance_id));
3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3219: FND_MESSAGE.SET_TOKEN('VALUE',

3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',
3220: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3221: MSC_CL_COLLECTION.v_instance_id));
3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3223:

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

3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',
3220: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3221: MSC_CL_COLLECTION.v_instance_id));
3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3226: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

Line 3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3220: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3221: MSC_CL_COLLECTION.v_instance_id));
3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3226: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:

Line 3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');

3221: MSC_CL_COLLECTION.v_instance_id));
3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3226: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3226: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3226: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3230: END IF;

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

3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3226: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3230: END IF;
3231: