APPS.MSC_CL_ITEM_ODS_LOAD dependencies on FND_MESSAGE

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

205: WHEN OTHERS THEN
206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
207:
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:

Line 210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');

206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
207:
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

207:
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));

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

210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:

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

211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:
219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));

212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:
219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:
219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
221: FND_MESSAGE.SET_TOKEN('VALUE',

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

215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:
219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
221: FND_MESSAGE.SET_TOKEN('VALUE',
222: MSC_GET_NAME.ORG_CODE( lv_organization_id,
223: MSC_CL_COLLECTION.v_instance_id));

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

216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:
219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
221: FND_MESSAGE.SET_TOKEN('VALUE',
222: MSC_GET_NAME.ORG_CODE( lv_organization_id,
223: MSC_CL_COLLECTION.v_instance_id));
224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 221: FND_MESSAGE.SET_TOKEN('VALUE',

217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:
219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
221: FND_MESSAGE.SET_TOKEN('VALUE',
222: MSC_GET_NAME.ORG_CODE( lv_organization_id,
223: MSC_CL_COLLECTION.v_instance_id));
224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
225:

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

220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
221: FND_MESSAGE.SET_TOKEN('VALUE',
222: MSC_GET_NAME.ORG_CODE( lv_organization_id,
223: MSC_CL_COLLECTION.v_instance_id));
224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
225:
226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
227:
228: END ADD_NEW_IMPL_ITEM_ASL;

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

366: WHEN OTHERS THEN
367: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
368:
369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
370: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
374:

Line 371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');

367: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
368:
369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
370: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
374:
375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');

368:
369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
370: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
374:
375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
376: RAISE;

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

369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
370: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
374:
375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
376: RAISE;
377:

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

379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
380: null;
381:
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
383: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
387:

Line 384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');

380: null;
381:
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
383: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
387:
388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');

381:
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
383: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
387:
388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
389: END IF;

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

382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
383: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
387:
388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
389: END IF;
390:

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

1002: WHEN OTHERS THEN
1003: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1004:
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1006: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1010:

Line 1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');

1003: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1004:
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1006: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1010:
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');

1004:
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1006: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1010:
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1012: RAISE;

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

1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1006: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1010:
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1012: RAISE;
1013:

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

1015:
1016: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1017:
1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1019: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:

Line 1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');

1016: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1017:
1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1019: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');

1017:
1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1019: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');

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

1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1019: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );

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

1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );
1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:

Line 1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');

1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );
1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );

1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );
1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');

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

1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );
1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );

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

1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );
1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );
1032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1033:

Line 1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');

1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );
1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );
1032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1033:
1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );

1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );
1032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1033:
1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1035: END IF;

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

1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );
1032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1033:
1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1035: END IF;
1036:

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

1192: EXCEPTION
1193: WHEN OTHERS THEN
1194:
1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1196: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1200:

Line 1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');

1193: WHEN OTHERS THEN
1194:
1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1196: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');

1194:
1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1196: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1202: RAISE;

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

1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1196: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1202: RAISE;
1203:

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

1365:
1366: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1367:
1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1369: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1373:

Line 1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');

1366: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1367:
1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1369: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');

1367:
1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1369: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1375: RAISE;

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

1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1369: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1375: RAISE;
1376:

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

1378:
1379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1380:
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:

Line 1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');

1379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1380:
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');

1380:
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));

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

1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));
1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:

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

1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));
1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:
1392: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));

1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));
1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:
1392: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));
1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:
1392: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1394: FND_MESSAGE.SET_TOKEN('VALUE',

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

1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));
1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:
1392: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1394: FND_MESSAGE.SET_TOKEN('VALUE',
1395: MSC_GET_NAME.ORG_CODE( lb_organization_id(j),
1396: MSC_CL_COLLECTION.v_instance_id));

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

1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));
1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:
1392: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1394: FND_MESSAGE.SET_TOKEN('VALUE',
1395: MSC_GET_NAME.ORG_CODE( lb_organization_id(j),
1396: MSC_CL_COLLECTION.v_instance_id));
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1394: FND_MESSAGE.SET_TOKEN('VALUE',

1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:
1392: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1394: FND_MESSAGE.SET_TOKEN('VALUE',
1395: MSC_GET_NAME.ORG_CODE( lb_organization_id(j),
1396: MSC_CL_COLLECTION.v_instance_id));
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1398:

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

1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1394: FND_MESSAGE.SET_TOKEN('VALUE',
1395: MSC_GET_NAME.ORG_CODE( lb_organization_id(j),
1396: MSC_CL_COLLECTION.v_instance_id));
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1398:
1399: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));

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

1395: MSC_GET_NAME.ORG_CODE( lb_organization_id(j),
1396: MSC_CL_COLLECTION.v_instance_id));
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1398:
1399: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));
1402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1403:

Line 1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');

1396: MSC_CL_COLLECTION.v_instance_id));
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1398:
1399: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));
1402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1403:
1404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));

1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1398:
1399: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));
1402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1403:
1404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1405: END IF;

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

1398:
1399: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));
1402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1403:
1404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1405: END IF;
1406:

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

1657:
1658: WHEN OTHERS THEN
1659:
1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1661: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:

Line 1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

1658: WHEN OTHERS THEN
1659:
1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1661: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');

1659:
1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1661: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1661: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);

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

1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);
1669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1670:

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

1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);
1669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);

1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);
1669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1672:

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

1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);
1669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1672:
1673: ERRBUF := sqlerrm;

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

1703:
1704: IF SQLCODE IN (-1653,-1654) THEN
1705:
1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:

Line 1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

1704: IF SQLCODE IN (-1653,-1654) THEN
1705:
1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');

1705:
1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:

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

1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');

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

1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));

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

1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1721:

Line 1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');

1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1721:
1722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));

1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1721:
1722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1723:

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

1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1721:
1722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1723:
1724: ERRBUF := sqlerrm;

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

1729:
1730: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1731:
1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1733: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:

Line 1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

1730: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1731:
1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1733: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');

1731:
1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1733: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1733: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:

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

1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');

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

1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));

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

1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1747:

Line 1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');

1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1747:
1748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));

1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1747:
1748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1749:

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

1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1747:
1748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1749:
1750: ERRBUF := sqlerrm;

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

1800:
1801: WHEN OTHERS THEN
1802:
1803: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1804: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:

Line 1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

1801: WHEN OTHERS THEN
1802:
1803: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1804: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');

1802:
1803: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1804: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');

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

1803: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1804: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

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

1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1813:

Line 1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');

1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1813:
1814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1813:
1814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1815:

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

1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1813:
1814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1815:
1816: ERRBUF := sqlerrm;

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

1880:
1881: IF SQLCODE IN (-1653,-1654) THEN
1882:
1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1884: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:

Line 1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

1881: IF SQLCODE IN (-1653,-1654) THEN
1882:
1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1884: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');

1882:
1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1884: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');

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

1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1884: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

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

1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1893:

Line 1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');

1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1895:

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

1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1895:
1896: ERRBUF := sqlerrm;

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

1901:
1902: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1903:
1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1905: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:

Line 1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

1902: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1903:
1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1905: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');

1903:
1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1905: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');

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

1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1905: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

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

1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1914:

Line 1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');

1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1916:

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

1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1916:
1917: ERRBUF := sqlerrm;

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

2415:
2416: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2417:
2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2419: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:

Line 2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

2416: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2417:
2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2419: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2417:
2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2419: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: RAISE;

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

2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2419: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: RAISE;
2426:

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

2427: ELSE
2428: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2429:
2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:

Line 2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

2428: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2429:
2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2429:
2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:

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

2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:
2441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:
2441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:
2441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2443: FND_MESSAGE.SET_TOKEN('VALUE',

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

2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:
2441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2443: FND_MESSAGE.SET_TOKEN('VALUE',
2444: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2445: MSC_CL_COLLECTION.v_instance_id));

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

2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:
2441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2443: FND_MESSAGE.SET_TOKEN('VALUE',
2444: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2445: MSC_CL_COLLECTION.v_instance_id));
2446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2443: FND_MESSAGE.SET_TOKEN('VALUE',

2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:
2441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2443: FND_MESSAGE.SET_TOKEN('VALUE',
2444: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2445: MSC_CL_COLLECTION.v_instance_id));
2446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2447:

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

2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2443: FND_MESSAGE.SET_TOKEN('VALUE',
2444: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2445: MSC_CL_COLLECTION.v_instance_id));
2446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2447:
2448: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

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

2444: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2445: MSC_CL_COLLECTION.v_instance_id));
2446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2447:
2448: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:

Line 2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');

2445: MSC_CL_COLLECTION.v_instance_id));
2446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2447:
2448: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

2446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2447:
2448: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');

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

2447:
2448: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

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

2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
2456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2457:

Line 2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');

2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
2456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2457:
2458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
2456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2457:
2458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2459: END IF;

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

2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
2456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2457:
2458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2459: END IF;
2460:

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

2505:
2506: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2507:
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2513:

Line 2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

2506: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2507:
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2513:
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2507:
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2513:
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2515: RAISE;

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

2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2513:
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2515: RAISE;
2516:

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

2517: ELSE
2518: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:

Line 2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

2518: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));

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

2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));
2529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2530:

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

2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));
2529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2530:
2531: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));

2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));
2529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2530:
2531: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2532: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');

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

2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));
2529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2530:
2531: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2532: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2533: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_ID));

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

2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));
2529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2530:
2531: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2532: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2533: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_ID));
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2535:

Line 2532: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');

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

Line 2533: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_ID));

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

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

2530:
2531: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2532: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2533: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_ID));
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2535:
2536: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2537: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2538: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_SITE_ID));

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

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

Line 2537: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');

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

Line 2538: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_SITE_ID));

2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2535:
2536: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2537: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2538: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_SITE_ID));
2539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2542: END IF ;

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

2535:
2536: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2537: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2538: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_SITE_ID));
2539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2542: END IF ;
2543: END ;

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

2811:
2812: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2813:
2814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2815: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2819:

Line 2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

2812: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2813:
2814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2815: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2819:
2820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2813:
2814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2815: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2819:
2820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2821: RAISE;

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

2814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2815: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2819:
2820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2821: RAISE;
2822:

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

2824:
2825: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2826:
2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2832:

Line 2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

2825: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2826:
2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2832:
2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2826:
2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2832:
2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2834: END IF;-- exception end

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

2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2832:
2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2834: END IF;-- exception end
2835: END ; -- begin end

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

2992:
2993: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2994:
2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2996: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
2999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3000:

Line 2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

2993: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2994:
2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2996: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
2999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');

2994:
2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2996: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
2999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3002: RAISE;

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

2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2996: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
2999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3002: RAISE;
3003:

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

3004: ELSE
3005: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3006:
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:

Line 3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

3005: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3006:
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');

3006:
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3017:

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

3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3017:
3018: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3017:
3018: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3019: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3017:
3018: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3019: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3020: FND_MESSAGE.SET_TOKEN('VALUE',

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

3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3017:
3018: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3019: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3020: FND_MESSAGE.SET_TOKEN('VALUE',
3021: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3022: MSC_CL_COLLECTION.v_instance_id));

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

3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3017:
3018: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3019: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3020: FND_MESSAGE.SET_TOKEN('VALUE',
3021: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3022: MSC_CL_COLLECTION.v_instance_id));
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3020: FND_MESSAGE.SET_TOKEN('VALUE',

3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3017:
3018: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3019: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3020: FND_MESSAGE.SET_TOKEN('VALUE',
3021: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3022: MSC_CL_COLLECTION.v_instance_id));
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3024:

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

3019: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3020: FND_MESSAGE.SET_TOKEN('VALUE',
3021: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3022: MSC_CL_COLLECTION.v_instance_id));
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3024:
3025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3026: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

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

3021: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3022: MSC_CL_COLLECTION.v_instance_id));
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3024:
3025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3026: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3029:

Line 3026: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');

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

Line 3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

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

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

3024:
3025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3026: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3029:
3030: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

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

3026: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3029:
3030: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:

Line 3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');

3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3029:
3030: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

3028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3029:
3030: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');

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

3029:
3030: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));

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

3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3039:

Line 3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');

3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3039:
3040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));

3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3039:
3040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3041: END IF;

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

3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3039:
3040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3041: END IF;
3042:

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

3135:
3136: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3137:
3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3139: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3143:

Line 3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

3136: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3137:
3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3139: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3143:
3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');

3137:
3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3139: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3143:
3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3145: RAISE;

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

3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3139: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3143:
3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3145: RAISE;
3146:

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

3147: ELSE
3148: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3149:
3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:

Line 3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

3148: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3149:
3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');

3149:
3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:

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

3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:
3161: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:
3161: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:
3161: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3163: FND_MESSAGE.SET_TOKEN('VALUE',

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

3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:
3161: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3163: FND_MESSAGE.SET_TOKEN('VALUE',
3164: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3165: MSC_CL_COLLECTION.v_instance_id));

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

3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:
3161: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3163: FND_MESSAGE.SET_TOKEN('VALUE',
3164: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3165: MSC_CL_COLLECTION.v_instance_id));
3166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3163: FND_MESSAGE.SET_TOKEN('VALUE',

3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:
3161: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3163: FND_MESSAGE.SET_TOKEN('VALUE',
3164: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3165: MSC_CL_COLLECTION.v_instance_id));
3166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3167:

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

3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3163: FND_MESSAGE.SET_TOKEN('VALUE',
3164: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3165: MSC_CL_COLLECTION.v_instance_id));
3166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3167:
3168: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

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

3164: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3165: MSC_CL_COLLECTION.v_instance_id));
3166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3167:
3168: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:

Line 3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');

3165: MSC_CL_COLLECTION.v_instance_id));
3166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3167:
3168: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

3166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3167:
3168: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');

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

3167:
3168: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

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

3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:

Line 3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');

3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');

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

3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));

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

3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));
3181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3182:

Line 3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');

3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));
3181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3182:
3183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));

3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));
3181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3182:
3183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3184: END IF;

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

3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));
3181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3182:
3183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3184: END IF;
3185:

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

4108: EXCEPTION
4109: WHEN OTHERS THEN
4110:
4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4116:

Line 4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');

4109: WHEN OTHERS THEN
4110:
4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4116:
4117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');

4110:
4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4116:
4117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4118: RAISE;

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

4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4116:
4117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4118: RAISE;
4119:

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

4588: WHEN OTHERS THEN
4589: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
4590:
4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4592: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4596:

Line 4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');

4589: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
4590:
4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4592: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4596:
4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');

4590:
4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4592: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4596:
4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4598: RAISE;

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

4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4592: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4596:
4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4598: RAISE;
4599:

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

4601:
4602: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4603:
4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:

Line 4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');

4602: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4603:
4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');

4603:
4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));

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

4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));
4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:

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

4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));
4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:
4615: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));

4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));
4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:
4615: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));
4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:
4615: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4617: FND_MESSAGE.SET_TOKEN('VALUE',

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

4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));
4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:
4615: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4617: FND_MESSAGE.SET_TOKEN('VALUE',
4618: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
4619: MSC_CL_COLLECTION.v_instance_id));

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

4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));
4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:
4615: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4617: FND_MESSAGE.SET_TOKEN('VALUE',
4618: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
4619: MSC_CL_COLLECTION.v_instance_id));
4620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 4617: FND_MESSAGE.SET_TOKEN('VALUE',

4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:
4615: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4617: FND_MESSAGE.SET_TOKEN('VALUE',
4618: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
4619: MSC_CL_COLLECTION.v_instance_id));
4620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4621:

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

4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4617: FND_MESSAGE.SET_TOKEN('VALUE',
4618: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
4619: MSC_CL_COLLECTION.v_instance_id));
4620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4621:
4622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));

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

4618: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
4619: MSC_CL_COLLECTION.v_instance_id));
4620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4621:
4622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));
4625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4626:

Line 4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');

4619: MSC_CL_COLLECTION.v_instance_id));
4620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4621:
4622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));
4625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4626:
4627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));

4620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4621:
4622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));
4625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4626:
4627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4628: END IF;

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

4621:
4622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));
4625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4626:
4627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4628: END IF;
4629: