APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on FND_MESSAGE

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

529: COMMIT;
530:
531: CLOSE c1; -- close the REF cursor
532:
533: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
534: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
535: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
537:

Line 534: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

530:
531: CLOSE c1; -- close the REF cursor
532:
533: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
534: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
535: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
537:
538: RETURN TRUE;

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

532:
533: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
534: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
535: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
537:
538: RETURN TRUE;
539:
540: EXCEPTION

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

649: COMMIT;
650:
651: CLOSE c1; -- close the REF cursor
652:
653: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
654: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
655: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
657:

Line 654: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

650:
651: CLOSE c1; -- close the REF cursor
652:
653: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
654: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
655: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
657:
658: RETURN TRUE;

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

652:
653: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
654: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
655: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
657:
658: RETURN TRUE;
659:
660: EXCEPTION

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

853:
854: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
855:
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
857: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
861:

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

854: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
855:
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
857: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
861:
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

855:
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
857: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
861:
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
863: RAISE;

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

856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
857: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
861:
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
863: RAISE;
864:

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

864:
865: ELSE
866: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

865: ELSE
866: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
873: END IF;

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

866: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
873: END IF;
874: END;

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

867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
873: END IF;
874: END;
875:

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

1060:
1061: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1062:
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1064: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1068:

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

1061: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1062:
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1064: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1068:
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1062:
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1064: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1068:
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: RAISE;

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

1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1064: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1068:
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: RAISE;
1071:

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

1072: ELSE
1073: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1074:
1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:

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

1073: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1074:
1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1074:
1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1083: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1083: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:

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

1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1083: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086:

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

1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1083: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086:
1087: /*

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

1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1083: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086:
1087: /*
1088: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086:
1087: /*
1088: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1089: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1090: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1091: */
1092:

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

1085:
1086:
1087: /*
1088: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1089: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1090: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1091: */
1092:
1093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1086:
1087: /*
1088: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1089: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1090: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1091: */
1092:
1093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1094:

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

1089: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1090: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1091: */
1092:
1093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1094:
1095: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1097: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);

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

1091: */
1092:
1093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1094:
1095: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1097: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1098:
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1092:
1093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1094:
1095: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1097: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1098:
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:

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

1093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1094:
1095: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1097: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1098:
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:
1101:

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

1095: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1097: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1098:
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:
1101:
1102: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1103: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1098:
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:
1101:
1102: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1103: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1104: FND_MESSAGE.SET_TOKEN('VALUE',
1105: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1106: MSC_CL_COLLECTION.v_instance_id));

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

1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:
1101:
1102: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1103: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1104: FND_MESSAGE.SET_TOKEN('VALUE',
1105: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1106: MSC_CL_COLLECTION.v_instance_id));
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1104: FND_MESSAGE.SET_TOKEN('VALUE',

1100:
1101:
1102: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1103: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1104: FND_MESSAGE.SET_TOKEN('VALUE',
1105: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1106: MSC_CL_COLLECTION.v_instance_id));
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1108:

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

1103: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1104: FND_MESSAGE.SET_TOKEN('VALUE',
1105: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1106: MSC_CL_COLLECTION.v_instance_id));
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1108:
1109: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));

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

1105: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1106: MSC_CL_COLLECTION.v_instance_id));
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1108:
1109: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:

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

1106: MSC_CL_COLLECTION.v_instance_id));
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1108:
1109: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:
1114: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1108:
1109: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:
1114: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

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

1108:
1109: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:
1114: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1116: FND_MESSAGE.SET_TOKEN('VALUE',

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

1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:
1114: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1116: FND_MESSAGE.SET_TOKEN('VALUE',
1117: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1118: c_rec.ORIGINATION_TYPE));

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

1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:
1114: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1116: FND_MESSAGE.SET_TOKEN('VALUE',
1117: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1118: c_rec.ORIGINATION_TYPE));
1119: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1116: FND_MESSAGE.SET_TOKEN('VALUE',

1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:
1114: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1116: FND_MESSAGE.SET_TOKEN('VALUE',
1117: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1118: c_rec.ORIGINATION_TYPE));
1119: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1120:

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

1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1116: FND_MESSAGE.SET_TOKEN('VALUE',
1117: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1118: c_rec.ORIGINATION_TYPE));
1119: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1120:
1121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1122: END IF;
1123:

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

1341:
1342: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1343:
1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1349:

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

1342: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1343:
1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1349:
1350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1343:
1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1349:
1350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1351: RAISE;

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

1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1349:
1350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1351: RAISE;
1352:

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

1353: ELSE
1354: IF SQLCODE = -00001 THEN
1355: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:

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

1354: IF SQLCODE = -00001 THEN
1355: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');

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

1355: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);

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

1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1364: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));

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

1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1364: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1366:

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

1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1364: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1366:
1367:

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

1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1364: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1366:
1367:
1368:

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

1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1364: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1366:
1367:
1368:
1369: ELSE

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

1370:
1371: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1372:
1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:

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

1371: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1372:
1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1372:
1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1381: FND_MESSAGE.SET_TOKEN('VALUE',

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

1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1381: FND_MESSAGE.SET_TOKEN('VALUE',
1382: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1383: MSC_CL_COLLECTION.v_instance_id));

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

1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1381: FND_MESSAGE.SET_TOKEN('VALUE',
1382: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1383: MSC_CL_COLLECTION.v_instance_id));
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1381: FND_MESSAGE.SET_TOKEN('VALUE',

1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1381: FND_MESSAGE.SET_TOKEN('VALUE',
1382: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1383: MSC_CL_COLLECTION.v_instance_id));
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1385:

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

1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1381: FND_MESSAGE.SET_TOKEN('VALUE',
1382: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1383: MSC_CL_COLLECTION.v_instance_id));
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1385:
1386: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

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

1382: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1383: MSC_CL_COLLECTION.v_instance_id));
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1385:
1386: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1390:

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

1383: MSC_CL_COLLECTION.v_instance_id));
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1385:
1386: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1390:
1391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1385:
1386: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1390:
1391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1392: END IF;

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

1385:
1386: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1390:
1391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1392: END IF;
1393: END IF;

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

1544:
1545: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1546:
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1548: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1552:

Line 1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');

1545: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1546:
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1548: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1552:
1553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1546:
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1548: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1552:
1553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1554: RAISE;

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

1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1548: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1552:
1553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1554: RAISE;
1555:

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

1556: ELSE
1557: IF SQLCODE = -00001 THEN
1558: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:

Line 1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');

1557: IF SQLCODE = -00001 THEN
1558: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');

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

1558: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);

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

1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1567: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));

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

1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1567: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1569:

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

1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1567: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1569:
1570:

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

1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1567: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1569:
1570:
1571:

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

1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1567: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1569:
1570:
1571:
1572: ELSE

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

1573:
1574: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
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_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:

Line 1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');

1574: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
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_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

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_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1584: FND_MESSAGE.SET_TOKEN('VALUE',

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

1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1584: FND_MESSAGE.SET_TOKEN('VALUE',
1585: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1586: MSC_CL_COLLECTION.v_instance_id));

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

1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1584: FND_MESSAGE.SET_TOKEN('VALUE',
1585: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1586: MSC_CL_COLLECTION.v_instance_id));
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1584: FND_MESSAGE.SET_TOKEN('VALUE',

1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1584: FND_MESSAGE.SET_TOKEN('VALUE',
1585: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1586: MSC_CL_COLLECTION.v_instance_id));
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1588:

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

1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1584: FND_MESSAGE.SET_TOKEN('VALUE',
1585: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1586: MSC_CL_COLLECTION.v_instance_id));
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1588:
1589: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

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

1585: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1586: MSC_CL_COLLECTION.v_instance_id));
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1588:
1589: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593:

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

1586: MSC_CL_COLLECTION.v_instance_id));
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1588:
1589: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593:
1594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1588:
1589: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593:
1594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1595: END IF;

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

1588:
1589: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593:
1594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1595: END IF;
1596: END IF;

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

2247:
2248: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2249:
2250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2251: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2255:

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

2248: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2249:
2250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2251: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2249:
2250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2251: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2257: RAISE;

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

2250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2251: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2257: RAISE;
2258:

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

2260:
2261: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2262:
2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:

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

2261: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2262:
2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2262:
2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));

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

2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:

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

2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:
2274: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:
2274: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:
2274: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2276: FND_MESSAGE.SET_TOKEN('VALUE',

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

2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:
2274: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2276: FND_MESSAGE.SET_TOKEN('VALUE',
2277: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2278: MSC_CL_COLLECTION.v_instance_id));

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

2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:
2274: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2276: FND_MESSAGE.SET_TOKEN('VALUE',
2277: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2278: MSC_CL_COLLECTION.v_instance_id));
2279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2276: FND_MESSAGE.SET_TOKEN('VALUE',

2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:
2274: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2276: FND_MESSAGE.SET_TOKEN('VALUE',
2277: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2278: MSC_CL_COLLECTION.v_instance_id));
2279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2280:

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

2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2276: FND_MESSAGE.SET_TOKEN('VALUE',
2277: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2278: MSC_CL_COLLECTION.v_instance_id));
2279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2280:
2281: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));

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

2277: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2278: MSC_CL_COLLECTION.v_instance_id));
2279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2280:
2281: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:

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

2278: MSC_CL_COLLECTION.v_instance_id));
2279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2280:
2281: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:
2286: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2280:
2281: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:
2286: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

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

2280:
2281: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:
2286: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2288: FND_MESSAGE.SET_TOKEN('VALUE',

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

2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:
2286: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2288: FND_MESSAGE.SET_TOKEN('VALUE',
2289: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2290: lb_ORIGINATION_TYPE(j)));

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

2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:
2286: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2288: FND_MESSAGE.SET_TOKEN('VALUE',
2289: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2290: lb_ORIGINATION_TYPE(j)));
2291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2288: FND_MESSAGE.SET_TOKEN('VALUE',

2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:
2286: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2288: FND_MESSAGE.SET_TOKEN('VALUE',
2289: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2290: lb_ORIGINATION_TYPE(j)));
2291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2292:

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

2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2288: FND_MESSAGE.SET_TOKEN('VALUE',
2289: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2290: lb_ORIGINATION_TYPE(j)));
2291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2292:
2293: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2294: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2295: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');

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

2290: lb_ORIGINATION_TYPE(j)));
2291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2292:
2293: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2294: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2295: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2296: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2298: END IF;

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

2291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2292:
2293: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2294: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2295: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2296: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2298: END IF;
2299:

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

2292:
2293: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2294: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2295: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2296: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2298: END IF;
2299:
2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2293: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2294: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2295: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2296: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2298: END IF;
2299:
2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2301: END IF;

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

3020:
3021: /* MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3022:
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:

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

3021: /* MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3022:
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3022:
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));

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

3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:

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

3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:
3034: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:
3034: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:
3034: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3036: FND_MESSAGE.SET_TOKEN('VALUE',

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

3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:
3034: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3036: FND_MESSAGE.SET_TOKEN('VALUE',
3037: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3038: MSC_CL_COLLECTION.v_instance_id));*/

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

3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:
3034: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3036: FND_MESSAGE.SET_TOKEN('VALUE',
3037: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3038: MSC_CL_COLLECTION.v_instance_id));*/
3039:

Line 3036: FND_MESSAGE.SET_TOKEN('VALUE',

3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:
3034: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3036: FND_MESSAGE.SET_TOKEN('VALUE',
3037: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3038: MSC_CL_COLLECTION.v_instance_id));*/
3039:
3040: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3036: FND_MESSAGE.SET_TOKEN('VALUE',
3037: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3038: MSC_CL_COLLECTION.v_instance_id));*/
3039:
3040: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3041: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
3042: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3044:

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

3037: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3038: MSC_CL_COLLECTION.v_instance_id));*/
3039:
3040: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3041: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
3042: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3044:
3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN

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

3038: MSC_CL_COLLECTION.v_instance_id));*/
3039:
3040: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3041: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
3042: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3044:
3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3039:
3040: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3041: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
3042: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3044:
3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3047: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');

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

3042: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3044:
3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3047: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
3048: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
3049: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3050: END IF;*/

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

3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3044:
3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3047: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
3048: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
3049: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3050: END IF;*/
3051:

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

3044:
3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3047: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
3048: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
3049: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3050: END IF;*/
3051:
3052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3047: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
3048: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
3049: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3050: END IF;*/
3051:
3052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3053: RAISE;

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

3321:
3322: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3323:
3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3325: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3329:

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

3322: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3323:
3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3325: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3329:
3330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3323:
3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3325: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3329:
3330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3331: RAISE;

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

3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3325: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3329:
3330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3331: RAISE;
3332:

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

3334:
3335: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3336: IF (print_all_debug_msg) THEN
3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:

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

3335: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3336: IF (print_all_debug_msg) THEN
3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3336: IF (print_all_debug_msg) THEN
3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:

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

3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3350: FND_MESSAGE.SET_TOKEN('VALUE',

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

3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3350: FND_MESSAGE.SET_TOKEN('VALUE',
3351: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3352: MSC_CL_COLLECTION.v_instance_id));

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

3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3350: FND_MESSAGE.SET_TOKEN('VALUE',
3351: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3352: MSC_CL_COLLECTION.v_instance_id));
3353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3350: FND_MESSAGE.SET_TOKEN('VALUE',

3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3350: FND_MESSAGE.SET_TOKEN('VALUE',
3351: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3352: MSC_CL_COLLECTION.v_instance_id));
3353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3354:

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

3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3350: FND_MESSAGE.SET_TOKEN('VALUE',
3351: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3352: MSC_CL_COLLECTION.v_instance_id));
3353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3354:
3355: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));

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

3351: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3352: MSC_CL_COLLECTION.v_instance_id));
3353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3354:
3355: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:

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

3352: MSC_CL_COLLECTION.v_instance_id));
3353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3354:
3355: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));

3353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3354:
3355: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');

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

3354:
3355: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));

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

3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3364:

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

3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3364:
3365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3364:
3365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3366: END IF;

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

3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3364:
3365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3366: END IF;
3367: -- bug12740169

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

3554:
3555: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3556:
3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3562:

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

3555: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3556:
3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3562:
3563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3556:
3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3562:
3563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3564: RAISE;

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

3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3562:
3563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3564: RAISE;
3565:

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

3566: ELSE
3567: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3568:
3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:

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

3567: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3568:
3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3568:
3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3577: FND_MESSAGE.SET_TOKEN('VALUE',

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

3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3577: FND_MESSAGE.SET_TOKEN('VALUE',
3578: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3579: MSC_CL_COLLECTION.v_instance_id));

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

3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3577: FND_MESSAGE.SET_TOKEN('VALUE',
3578: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3579: MSC_CL_COLLECTION.v_instance_id));
3580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3577: FND_MESSAGE.SET_TOKEN('VALUE',

3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3577: FND_MESSAGE.SET_TOKEN('VALUE',
3578: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3579: MSC_CL_COLLECTION.v_instance_id));
3580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3581:

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

3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3577: FND_MESSAGE.SET_TOKEN('VALUE',
3578: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3579: MSC_CL_COLLECTION.v_instance_id));
3580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3581:
3582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

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

3578: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3579: MSC_CL_COLLECTION.v_instance_id));
3580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3581:
3582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3586:

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

3579: MSC_CL_COLLECTION.v_instance_id));
3580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3581:
3582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3586:
3587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3581:
3582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3586:
3587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3588: END IF;

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

3581:
3582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3586:
3587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3588: END IF;
3589: