APPS.MSC_CL_WIP_ODS_LOAD dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 313: FND_MESSAGE.SET_TOKEN('VALUE',

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

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

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

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

674:
675: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
676:
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
682:

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

675: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
676:
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
682:
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

676:
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
682:
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
684: RAISE;

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

677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
682:
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
684: RAISE;
685:

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

687:
688: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
689:
690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:

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

688: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
689:
690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

689:
690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
698: FND_MESSAGE.SET_TOKEN('VALUE',

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

692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
698: FND_MESSAGE.SET_TOKEN('VALUE',
699: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
700: MSC_CL_COLLECTION.v_instance_id));

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

693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
698: FND_MESSAGE.SET_TOKEN('VALUE',
699: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
700: MSC_CL_COLLECTION.v_instance_id));
701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 698: FND_MESSAGE.SET_TOKEN('VALUE',

694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
698: FND_MESSAGE.SET_TOKEN('VALUE',
699: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
700: MSC_CL_COLLECTION.v_instance_id));
701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
702:

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

697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
698: FND_MESSAGE.SET_TOKEN('VALUE',
699: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
700: MSC_CL_COLLECTION.v_instance_id));
701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
702:
703: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
704: END IF;
705:

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

1111:
1112: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1113:
1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1115: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:

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

1112: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1113:
1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1115: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1113:
1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1115: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: RAISE;

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

1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1115: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: RAISE;
1122:

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

1124:
1125: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1126:
1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:

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

1125: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1126:
1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1126:
1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1135: FND_MESSAGE.SET_TOKEN('VALUE',

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

1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1135: FND_MESSAGE.SET_TOKEN('VALUE',
1136: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1137: MSC_CL_COLLECTION.v_instance_id));

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

1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1135: FND_MESSAGE.SET_TOKEN('VALUE',
1136: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1137: MSC_CL_COLLECTION.v_instance_id));
1138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1135: FND_MESSAGE.SET_TOKEN('VALUE',

1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1135: FND_MESSAGE.SET_TOKEN('VALUE',
1136: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1137: MSC_CL_COLLECTION.v_instance_id));
1138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1139:

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

1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1135: FND_MESSAGE.SET_TOKEN('VALUE',
1136: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1137: MSC_CL_COLLECTION.v_instance_id));
1138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1139:
1140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1141: END IF;
1142:

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

1559:
1560: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1561:
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1563: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1567:

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

1560: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1561:
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1563: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1567:
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1561:
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1563: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1567:
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1569: RAISE;

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

1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1563: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1567:
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1569: RAISE;
1570:

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

1572:
1573: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1574:
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1580:

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

1573: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1574:
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1580:
1581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1574:
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1580:
1581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1582: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1580:
1581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1582: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1583: FND_MESSAGE.SET_TOKEN('VALUE',

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

1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1580:
1581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1582: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1583: FND_MESSAGE.SET_TOKEN('VALUE',
1584: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1585: MSC_CL_COLLECTION.v_instance_id));

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

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

Line 1583: FND_MESSAGE.SET_TOKEN('VALUE',

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

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

1582: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1583: FND_MESSAGE.SET_TOKEN('VALUE',
1584: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1585: MSC_CL_COLLECTION.v_instance_id));
1586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1589: END IF;
1590:

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

2012:
2013: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2014:
2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2020:

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

2013: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2014:
2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2020:
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2014:
2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2020:
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2022: RAISE;

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

2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2020:
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2022: RAISE;
2023:

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

2025:
2026: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:

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

2026: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2036: FND_MESSAGE.SET_TOKEN('VALUE',

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

2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2036: FND_MESSAGE.SET_TOKEN('VALUE',
2037: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2038: MSC_CL_COLLECTION.v_instance_id));

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

2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2036: FND_MESSAGE.SET_TOKEN('VALUE',
2037: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2038: MSC_CL_COLLECTION.v_instance_id));
2039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2036: FND_MESSAGE.SET_TOKEN('VALUE',

2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2036: FND_MESSAGE.SET_TOKEN('VALUE',
2037: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2038: MSC_CL_COLLECTION.v_instance_id));
2039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2040:

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

2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2036: FND_MESSAGE.SET_TOKEN('VALUE',
2037: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2038: MSC_CL_COLLECTION.v_instance_id));
2039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2040:
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2042: END IF;
2043:

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

2333: WHEN OTHERS THEN
2334: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2335:
2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2337: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2338: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2339: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2341:

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

2334: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2335:
2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2337: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2338: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2339: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2341:
2342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2335:
2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2337: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2338: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2339: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2341:
2342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2343: RAISE;

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

2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2337: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2338: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2339: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2341:
2342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2343: RAISE;
2344:

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

2343: RAISE;
2344:
2345: ELSE
2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2347: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2348: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2349: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2351:

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

2344:
2345: ELSE
2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2347: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2348: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2349: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2351:
2352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2345: ELSE
2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2347: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2348: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2349: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2351:
2352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2353:

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

2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2347: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2348: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2349: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2351:
2352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2353:
2354: --If Direct path load results in warning then the processing has to be

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

2475:
2476: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:

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

2476: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2485: RAISE;

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

2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2485: RAISE;
2486:

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

2488:
2489: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:

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

2489: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498:

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

2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498:
2499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498:
2499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2500: FND_MESSAGE.SET_TOKEN('VALUE',
2501: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,

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

2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498:
2499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2500: FND_MESSAGE.SET_TOKEN('VALUE',
2501: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2502: MSC_CL_COLLECTION.v_instance_id));
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2500: FND_MESSAGE.SET_TOKEN('VALUE',

2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498:
2499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2500: FND_MESSAGE.SET_TOKEN('VALUE',
2501: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2502: MSC_CL_COLLECTION.v_instance_id));
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2504:

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

2499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2500: FND_MESSAGE.SET_TOKEN('VALUE',
2501: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2502: MSC_CL_COLLECTION.v_instance_id));
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2504:
2505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

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

2501: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2502: MSC_CL_COLLECTION.v_instance_id));
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2504:
2505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:

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

2502: MSC_CL_COLLECTION.v_instance_id));
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2504:
2505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2504:
2505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

2504:
2505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

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

2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:

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

2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');

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

2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));

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

2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2519:

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

2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2521: END IF;

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

2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2521: END IF;
2522:

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

3186:
3187: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3188:
3189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3190: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3191: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3192: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3194:

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

3187: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3188:
3189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3190: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3191: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3192: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3194:
3195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3188:
3189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3190: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3191: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3192: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3194:
3195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3196: RAISE;

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

3189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3190: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3191: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3192: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3194:
3195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3196: RAISE;
3197:

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

3198: ELSE
3199: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3200:
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3202: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:

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

3199: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3200:
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3202: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3200:
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3202: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');

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

3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3202: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));

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

3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:

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

3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));

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

3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:

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

3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',

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

3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',
3220: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3221: MSC_CL_COLLECTION.v_instance_id));

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

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

Line 3219: FND_MESSAGE.SET_TOKEN('VALUE',

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

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

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

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

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

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

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

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

3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3226: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');

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

3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3226: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3231: FND_MESSAGE.SET_TOKEN('VALUE',

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

3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3226: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3231: FND_MESSAGE.SET_TOKEN('VALUE',
3232: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3233: lv_ORIGINATION_TYPE));

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

3226: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3231: FND_MESSAGE.SET_TOKEN('VALUE',
3232: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3233: lv_ORIGINATION_TYPE));
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3231: FND_MESSAGE.SET_TOKEN('VALUE',

3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3231: FND_MESSAGE.SET_TOKEN('VALUE',
3232: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3233: lv_ORIGINATION_TYPE));
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3235:

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

3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3231: FND_MESSAGE.SET_TOKEN('VALUE',
3232: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3233: lv_ORIGINATION_TYPE));
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3235:
3236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3237: END IF;
3238:

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

3693: WHEN OTHERS THEN
3694: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
3695:
3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3697: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3701:

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

3694: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
3695:
3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3697: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3701:
3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3695:
3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3697: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3701:
3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3703: RAISE;

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

3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3697: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3701:
3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3703: RAISE;
3704:

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

3703: RAISE;
3704:
3705: ELSE
3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3711:

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

3704:
3705: ELSE
3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3711:
3712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3705: ELSE
3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3711:
3712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3713:

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

3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3711:
3712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3713:
3714: --If Direct path load results in warning then the processing has to be

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

3939:
3940: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3941:
3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3943: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3947:

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

3940: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3941:
3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3943: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3947:
3948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3941:
3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3943: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3947:
3948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3949: RAISE;

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

3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3943: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3947:
3948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3949: RAISE;
3950:

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

3952:
3953: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3954:
3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:

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

3953: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3954:
3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3954:
3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3963: FND_MESSAGE.SET_TOKEN('VALUE',

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

3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3963: FND_MESSAGE.SET_TOKEN('VALUE',
3964: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3965: MSC_CL_COLLECTION.v_instance_id));

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

3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3963: FND_MESSAGE.SET_TOKEN('VALUE',
3964: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3965: MSC_CL_COLLECTION.v_instance_id));
3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3963: FND_MESSAGE.SET_TOKEN('VALUE',

3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3963: FND_MESSAGE.SET_TOKEN('VALUE',
3964: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3965: MSC_CL_COLLECTION.v_instance_id));
3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3967:

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

3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3963: FND_MESSAGE.SET_TOKEN('VALUE',
3964: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3965: MSC_CL_COLLECTION.v_instance_id));
3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3967:
3968: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

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

3964: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3965: MSC_CL_COLLECTION.v_instance_id));
3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3967:
3968: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:

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

3965: MSC_CL_COLLECTION.v_instance_id));
3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3967:
3968: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3967:
3968: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

3967:
3968: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

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

3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
3976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3977:

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

3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
3976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3977:
3978: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
3976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3977:
3978: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3979: END IF;

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

3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
3976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3977:
3978: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3979: END IF;
3980: