APPS.MSC_CL_WIP_ODS_LOAD dependencies on FND_MESSAGE

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

290:
291: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
292:
293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
294: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
295: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
296: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
298:

Line 295: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');

291: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
292:
293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
294: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
295: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
296: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
298:
299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 296: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');

292:
293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
294: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
295: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
296: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
298:
299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
300: RAISE;

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

293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
294: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
295: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
296: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
298:
299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
300: RAISE;
301:

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

303:
304: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
305:
306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
311:

Line 308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');

304: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
305:
306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
311:
312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');

305:
306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
311:
312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
313: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
311:
312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
313: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
314: FND_MESSAGE.SET_TOKEN('VALUE',

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

308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
311:
312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
313: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
314: FND_MESSAGE.SET_TOKEN('VALUE',
315: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
316: MSC_CL_COLLECTION.v_instance_id));

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

309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
311:
312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
313: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
314: FND_MESSAGE.SET_TOKEN('VALUE',
315: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
316: MSC_CL_COLLECTION.v_instance_id));
317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 314: FND_MESSAGE.SET_TOKEN('VALUE',

310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
311:
312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
313: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
314: FND_MESSAGE.SET_TOKEN('VALUE',
315: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
316: MSC_CL_COLLECTION.v_instance_id));
317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
318:

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

313: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
314: FND_MESSAGE.SET_TOKEN('VALUE',
315: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
316: MSC_CL_COLLECTION.v_instance_id));
317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
318:
319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
320: END IF;
321:

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

699:
700: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
701:
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
703: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
705: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
707:

Line 704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');

700: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
701:
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
703: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
705: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
707:
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 705: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');

701:
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
703: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
705: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
707:
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
709: RAISE;

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

702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
703: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
705: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
707:
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
709: RAISE;
710:

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

712:
713: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
714:
715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
716: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:

Line 717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');

713: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
714:
715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
716: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');

714:
715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
716: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
722: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
716: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
722: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
723: FND_MESSAGE.SET_TOKEN('VALUE',

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

717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
722: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
723: FND_MESSAGE.SET_TOKEN('VALUE',
724: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
725: MSC_CL_COLLECTION.v_instance_id));

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

718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
722: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
723: FND_MESSAGE.SET_TOKEN('VALUE',
724: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
725: MSC_CL_COLLECTION.v_instance_id));
726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 723: FND_MESSAGE.SET_TOKEN('VALUE',

719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
722: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
723: FND_MESSAGE.SET_TOKEN('VALUE',
724: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
725: MSC_CL_COLLECTION.v_instance_id));
726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
727:

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

722: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
723: FND_MESSAGE.SET_TOKEN('VALUE',
724: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
725: MSC_CL_COLLECTION.v_instance_id));
726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
727:
728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
729: END IF;
730:

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

1136:
1137: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1138:
1139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1140: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1141: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1142: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1144:

Line 1141: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');

1137: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1138:
1139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1140: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1141: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1142: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1144:
1145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1142: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');

1138:
1139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1140: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1141: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1142: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1144:
1145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1146: RAISE;

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

1139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1140: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1141: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1142: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1144:
1145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1146: RAISE;
1147:

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

1149:
1150: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1151:
1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1153: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:

Line 1154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');

1150: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1151:
1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1153: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:
1158: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');

1151:
1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1153: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:
1158: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1159: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1153: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:
1158: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1159: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1160: FND_MESSAGE.SET_TOKEN('VALUE',

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

1154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:
1158: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1159: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1160: FND_MESSAGE.SET_TOKEN('VALUE',
1161: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1162: MSC_CL_COLLECTION.v_instance_id));

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

1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:
1158: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1159: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1160: FND_MESSAGE.SET_TOKEN('VALUE',
1161: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1162: MSC_CL_COLLECTION.v_instance_id));
1163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1160: FND_MESSAGE.SET_TOKEN('VALUE',

1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:
1158: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1159: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1160: FND_MESSAGE.SET_TOKEN('VALUE',
1161: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1162: MSC_CL_COLLECTION.v_instance_id));
1163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1164:

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

1159: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1160: FND_MESSAGE.SET_TOKEN('VALUE',
1161: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1162: MSC_CL_COLLECTION.v_instance_id));
1163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1164:
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1166: END IF;
1167:

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

1584:
1585: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1586:
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1588: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1589: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1592:

Line 1589: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');

1585: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1586:
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1588: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1589: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1592:
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');

1586:
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1588: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1589: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1592:
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: RAISE;

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

1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1588: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1589: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1592:
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: RAISE;
1595:

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

1597:
1598: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1599:
1600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1601: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:

Line 1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');

1598: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1599:
1600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1601: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');

1599:
1600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1601: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1601: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1608: FND_MESSAGE.SET_TOKEN('VALUE',

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

1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1608: FND_MESSAGE.SET_TOKEN('VALUE',
1609: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1610: MSC_CL_COLLECTION.v_instance_id));

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

1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1608: FND_MESSAGE.SET_TOKEN('VALUE',
1609: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1610: MSC_CL_COLLECTION.v_instance_id));
1611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1608: FND_MESSAGE.SET_TOKEN('VALUE',

1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1608: FND_MESSAGE.SET_TOKEN('VALUE',
1609: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1610: MSC_CL_COLLECTION.v_instance_id));
1611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1612:

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

1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1608: FND_MESSAGE.SET_TOKEN('VALUE',
1609: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1610: MSC_CL_COLLECTION.v_instance_id));
1611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1612:
1613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1614: END IF;
1615:

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

2037:
2038: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2039:
2040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2043: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2045:

Line 2042: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');

2038: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2039:
2040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2043: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2045:
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2043: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');

2039:
2040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2043: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2045:
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2047: RAISE;

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

2040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2043: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2045:
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2047: RAISE;
2048:

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

2050:
2051: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2052:
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2054: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:

Line 2055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');

2051: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2052:
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2054: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:
2059: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');

2052:
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2054: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:
2059: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2060: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2054: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:
2059: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2060: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2061: FND_MESSAGE.SET_TOKEN('VALUE',

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

2055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:
2059: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2060: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2061: FND_MESSAGE.SET_TOKEN('VALUE',
2062: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2063: MSC_CL_COLLECTION.v_instance_id));

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

2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:
2059: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2060: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2061: FND_MESSAGE.SET_TOKEN('VALUE',
2062: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2063: MSC_CL_COLLECTION.v_instance_id));
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2061: FND_MESSAGE.SET_TOKEN('VALUE',

2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:
2059: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2060: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2061: FND_MESSAGE.SET_TOKEN('VALUE',
2062: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2063: MSC_CL_COLLECTION.v_instance_id));
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2065:

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

2060: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2061: FND_MESSAGE.SET_TOKEN('VALUE',
2062: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2063: MSC_CL_COLLECTION.v_instance_id));
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2065:
2066: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2067: END IF;
2068:

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

2358: WHEN OTHERS THEN
2359: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2360:
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2364: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2366:

Line 2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');

2359: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2360:
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2364: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2364: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');

2360:
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2364: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2368: RAISE;

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

2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2364: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2368: RAISE;
2369:

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

2368: RAISE;
2369:
2370: ELSE
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2372: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2373: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2376:

Line 2373: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');

2369:
2370: ELSE
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2372: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2373: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2376:
2377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');

2370: ELSE
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2372: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2373: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2376:
2377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2378:

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

2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2372: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2373: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2376:
2377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2378:
2379: --If Direct path load results in warning then the processing has to be

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

2500:
2501: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2506: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2508:

Line 2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');

2501: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2506: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2508:
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2506: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');

2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2506: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2508:
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2510: RAISE;

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

2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2506: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2508:
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2510: RAISE;
2511:

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

2513:
2514: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2515:
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2517: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2518: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2519: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2521:

Line 2518: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');

2514: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2515:
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2517: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2518: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2519: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2521:
2522: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2519: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');

2515:
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2517: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2518: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2519: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2521:
2522: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2523:

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

2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2517: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2518: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2519: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2521:
2522: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2523:
2524: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2518: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2519: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2521:
2522: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2523:
2524: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2525: FND_MESSAGE.SET_TOKEN('VALUE',
2526: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,

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

2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2521:
2522: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2523:
2524: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2525: FND_MESSAGE.SET_TOKEN('VALUE',
2526: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2527: MSC_CL_COLLECTION.v_instance_id));
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2525: FND_MESSAGE.SET_TOKEN('VALUE',

2521:
2522: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2523:
2524: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2525: FND_MESSAGE.SET_TOKEN('VALUE',
2526: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2527: MSC_CL_COLLECTION.v_instance_id));
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2529:

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

2524: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2525: FND_MESSAGE.SET_TOKEN('VALUE',
2526: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2527: MSC_CL_COLLECTION.v_instance_id));
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2529:
2530: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

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

2526: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2527: MSC_CL_COLLECTION.v_instance_id));
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2529:
2530: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2534:

Line 2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

2527: MSC_CL_COLLECTION.v_instance_id));
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2529:
2530: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2534:
2535: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2529:
2530: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2534:
2535: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

2529:
2530: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2534:
2535: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

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

2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2534:
2535: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2539:

Line 2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

2532: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2534:
2535: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2539:
2540: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

2533: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2534:
2535: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2539:
2540: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2541: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');

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

2534:
2535: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2539:
2540: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2541: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2542: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));

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

2536: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2539:
2540: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2541: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2542: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2544:

Line 2541: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');

2537: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2539:
2540: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2541: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2542: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2544:
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2542: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));

2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2539:
2540: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2541: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2542: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2544:
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2546: END IF;

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

2539:
2540: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2541: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2542: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2544:
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2546: END IF;
2547:

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

3211:
3212: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3213:
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3215: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3216: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3217: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:

Line 3216: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

3212: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3213:
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3215: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3216: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3217: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3213:
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3215: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3216: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3217: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3221: RAISE;

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

3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3215: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3216: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3217: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3221: RAISE;
3222:

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

3223: ELSE
3224: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3225:
3226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3227: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3229: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:

Line 3228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

3224: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3225:
3226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3227: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3229: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3225:
3226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3227: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3229: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');

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

3226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3227: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3229: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));

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

3228: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3229: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3236:

Line 3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');

3229: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3236:
3237: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));

3230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3236:
3237: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3238: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

3231:
3232: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3236:
3237: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3238: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));

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

3233: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3236:
3237: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3238: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3241:

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

3234: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3236:
3237: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3238: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3241:
3242: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));

3235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3236:
3237: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3238: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3241:
3242: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3243: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3236:
3237: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3238: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3241:
3242: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3243: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3244: FND_MESSAGE.SET_TOKEN('VALUE',

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

3238: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3241:
3242: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3243: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3244: FND_MESSAGE.SET_TOKEN('VALUE',
3245: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3246: MSC_CL_COLLECTION.v_instance_id));

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

3239: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3241:
3242: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3243: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3244: FND_MESSAGE.SET_TOKEN('VALUE',
3245: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3246: MSC_CL_COLLECTION.v_instance_id));
3247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3244: FND_MESSAGE.SET_TOKEN('VALUE',

3240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3241:
3242: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3243: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3244: FND_MESSAGE.SET_TOKEN('VALUE',
3245: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3246: MSC_CL_COLLECTION.v_instance_id));
3247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3248:

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

3243: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3244: FND_MESSAGE.SET_TOKEN('VALUE',
3245: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3246: MSC_CL_COLLECTION.v_instance_id));
3247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3248:
3249: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3250: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));

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

3245: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3246: MSC_CL_COLLECTION.v_instance_id));
3247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3248:
3249: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3250: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3253:

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

3246: MSC_CL_COLLECTION.v_instance_id));
3247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3248:
3249: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3250: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3253:
3254: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));

3247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3248:
3249: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3250: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3253:
3254: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3255: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

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

3248:
3249: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3250: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3253:
3254: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3255: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3256: FND_MESSAGE.SET_TOKEN('VALUE',

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

3250: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3253:
3254: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3255: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3256: FND_MESSAGE.SET_TOKEN('VALUE',
3257: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3258: lv_ORIGINATION_TYPE));

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

3251: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3253:
3254: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3255: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3256: FND_MESSAGE.SET_TOKEN('VALUE',
3257: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3258: lv_ORIGINATION_TYPE));
3259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3256: FND_MESSAGE.SET_TOKEN('VALUE',

3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3253:
3254: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3255: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3256: FND_MESSAGE.SET_TOKEN('VALUE',
3257: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3258: lv_ORIGINATION_TYPE));
3259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3260:

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

3255: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3256: FND_MESSAGE.SET_TOKEN('VALUE',
3257: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3258: lv_ORIGINATION_TYPE));
3259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3260:
3261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3262: END IF;
3263:

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

3741: WHEN OTHERS THEN
3742: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
3743:
3744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3745: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3746: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3747: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3749:

Line 3746: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');

3742: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
3743:
3744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3745: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3746: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3747: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3749:
3750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3747: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

3743:
3744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3745: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3746: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3747: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3749:
3750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3751: RAISE;

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

3744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3745: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3746: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3747: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3749:
3750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3751: RAISE;
3752:

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

3751: RAISE;
3752:
3753: ELSE
3754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3755: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3756: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3757: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3758: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3759:

Line 3756: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');

3752:
3753: ELSE
3754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3755: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3756: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3757: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3758: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3759:
3760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3757: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

3753: ELSE
3754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3755: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3756: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3757: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3758: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3759:
3760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3761:

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

3754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3755: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3756: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3757: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3758: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3759:
3760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3761:
3762: --If Direct path load results in warning then the processing has to be

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

4013:
4014: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
4015:
4016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4017: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4018: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4019: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4021:

Line 4018: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

4014: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
4015:
4016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4017: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4018: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4019: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4021:
4022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4019: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

4015:
4016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4017: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4018: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4019: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4021:
4022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4023: RAISE;

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

4016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4017: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4018: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4019: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4021:
4022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4023: RAISE;
4024:

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

4026:
4027: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4028:
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4030: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4031: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4032: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4034:

Line 4031: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

4027: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4028:
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4030: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4031: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4032: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4034:
4035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 4032: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');

4028:
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4030: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4031: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4032: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4034:
4035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4036: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4030: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4031: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4032: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4034:
4035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4036: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4037: FND_MESSAGE.SET_TOKEN('VALUE',

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

4031: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
4032: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4034:
4035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4036: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4037: FND_MESSAGE.SET_TOKEN('VALUE',
4038: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
4039: MSC_CL_COLLECTION.v_instance_id));

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

4032: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
4033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4034:
4035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4036: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4037: FND_MESSAGE.SET_TOKEN('VALUE',
4038: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
4039: MSC_CL_COLLECTION.v_instance_id));
4040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 4037: FND_MESSAGE.SET_TOKEN('VALUE',

4033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4034:
4035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4036: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4037: FND_MESSAGE.SET_TOKEN('VALUE',
4038: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
4039: MSC_CL_COLLECTION.v_instance_id));
4040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4041:

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

4036: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4037: FND_MESSAGE.SET_TOKEN('VALUE',
4038: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
4039: MSC_CL_COLLECTION.v_instance_id));
4040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4041:
4042: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4043: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

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

4038: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
4039: MSC_CL_COLLECTION.v_instance_id));
4040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4041:
4042: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4043: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
4045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4046:

Line 4043: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

4039: MSC_CL_COLLECTION.v_instance_id));
4040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4041:
4042: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4043: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
4045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4046:
4047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

4040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4041:
4042: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4043: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
4045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4046:
4047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4048: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

4041:
4042: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4043: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
4045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4046:
4047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4048: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
4049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

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

4043: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
4045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4046:
4047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4048: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
4049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
4050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4051:

Line 4048: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

4044: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
4045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4046:
4047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4048: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
4049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
4050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4051:
4052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

4045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4046:
4047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4048: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
4049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
4050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4051:
4052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4053: END IF;

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

4046:
4047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4048: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
4049: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
4050: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4051:
4052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4053: END IF;
4054: