APPS.MSC_CL_EAM_ODS_LOAD dependencies on FND_MESSAGE

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

191: WHEN OTHERS THEN
192: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
194: '========================================');
195: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
197: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
198: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 196: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

192: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
194: '========================================');
195: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
197: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
198: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
200: RAISE;

Line 197: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
194: '========================================');
195: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
197: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
198: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
200: RAISE;
201: ELSE

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

194: '========================================');
195: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
197: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
198: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
200: RAISE;
201: ELSE
202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

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

200: RAISE;
201: ELSE
202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
203: '========================================');
204: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
205: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
206: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 205: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

201: ELSE
202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
203: '========================================');
204: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
205: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
206: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
209: END IF;

Line 206: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
203: '========================================');
204: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
205: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
206: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
209: END IF;
210: END;

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

203: '========================================');
204: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
205: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
206: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
209: END IF;
210: END;
211:

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

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

Line 293: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

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

Line 294: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

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

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

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

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

300: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
301:
302: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
303: '========================================');
304: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
305: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
306: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
308:

Line 305: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

301:
302: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
303: '========================================');
304: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
305: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
306: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
308:
309: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 306: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

302: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
303: '========================================');
304: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
305: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
306: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
308:
309: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
310: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

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

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

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

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

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

Line 311: FND_MESSAGE.SET_TOKEN('VALUE',

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

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

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

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

312: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
313: MSC_CL_COLLECTION.v_instance_id));
314: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
315:
316: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
317: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
318: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
320:

Line 317: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');

313: MSC_CL_COLLECTION.v_instance_id));
314: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
315:
316: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
317: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
318: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
320:
321: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 318: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));

314: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
315:
316: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
317: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
318: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
320:
321: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
322: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_REBUILD_ITEM_ID');

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

315:
316: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
317: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
318: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
320:
321: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
322: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_REBUILD_ITEM_ID');
323: FND_MESSAGE.SET_TOKEN('VALUE',

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

317: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
318: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
320:
321: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
322: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_REBUILD_ITEM_ID');
323: FND_MESSAGE.SET_TOKEN('VALUE',
324: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 322: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_REBUILD_ITEM_ID');

318: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
320:
321: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
322: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_REBUILD_ITEM_ID');
323: FND_MESSAGE.SET_TOKEN('VALUE',
324: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
326:

Line 323: FND_MESSAGE.SET_TOKEN('VALUE',

319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
320:
321: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
322: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_REBUILD_ITEM_ID');
323: FND_MESSAGE.SET_TOKEN('VALUE',
324: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
326:
327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

321: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
322: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_REBUILD_ITEM_ID');
323: FND_MESSAGE.SET_TOKEN('VALUE',
324: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
326:
327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
328: END IF;
329: END;

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

537: WHEN OTHERS THEN
538: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
540: '========================================');
541: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
542: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
543: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 542: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

538: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
540: '========================================');
541: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
542: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
543: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
546: RAISE;

Line 543: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');

539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
540: '========================================');
541: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
542: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
543: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
546: RAISE;
547: ELSE

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

540: '========================================');
541: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
542: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
543: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
546: RAISE;
547: ELSE
548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

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

546: RAISE;
547: ELSE
548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
549: '========================================');
550: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
551: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
552: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 551: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

547: ELSE
548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
549: '========================================');
550: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
551: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
552: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
555: END IF;

Line 552: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');

548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
549: '========================================');
550: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
551: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
552: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
555: END IF;
556: END;

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

549: '========================================');
550: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
551: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
552: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
555: END IF;
556: END;
557:

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

646: WHEN OTHERS THEN
647: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
648: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
649: '========================================');
650: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
651: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
652: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 651: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

647: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
648: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
649: '========================================');
650: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
651: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
652: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
655: RAISE;

Line 652: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');

648: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
649: '========================================');
650: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
651: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
652: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
655: RAISE;
656:

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

649: '========================================');
650: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
651: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
652: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
655: RAISE;
656:
657: ELSE

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

658: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
659:
660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
661: '========================================');
662: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
663: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
664: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
665: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
666:

Line 663: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

659:
660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
661: '========================================');
662: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
663: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
664: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
665: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
666:
667: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 664: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');

660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
661: '========================================');
662: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
663: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
664: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
665: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
666:
667: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
668: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

661: '========================================');
662: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
663: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
664: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
665: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
666:
667: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
668: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
669: FND_MESSAGE.SET_TOKEN('VALUE',

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

663: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
664: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
665: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
666:
667: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
668: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
669: FND_MESSAGE.SET_TOKEN('VALUE',
670: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
671: MSC_CL_COLLECTION.v_instance_id));

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

664: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ASSET_EQUIP_DTLS');
665: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
666:
667: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
668: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
669: FND_MESSAGE.SET_TOKEN('VALUE',
670: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
671: MSC_CL_COLLECTION.v_instance_id));
672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 669: FND_MESSAGE.SET_TOKEN('VALUE',

665: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
666:
667: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
668: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
669: FND_MESSAGE.SET_TOKEN('VALUE',
670: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
671: MSC_CL_COLLECTION.v_instance_id));
672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
673:

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

668: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
669: FND_MESSAGE.SET_TOKEN('VALUE',
670: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
671: MSC_CL_COLLECTION.v_instance_id));
672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
673:
674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');
676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));

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

670: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
671: MSC_CL_COLLECTION.v_instance_id));
672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
673:
674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');
676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
678:

Line 675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');

671: MSC_CL_COLLECTION.v_instance_id));
672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
673:
674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');
676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
678:
679: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));

672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
673:
674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');
676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
678:
679: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
680: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');

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

673:
674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');
676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
678:
679: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
680: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
681: FND_MESSAGE.SET_TOKEN('VALUE',

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

675: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_GROUP_ITEM_ID');
676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
678:
679: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
680: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
681: FND_MESSAGE.SET_TOKEN('VALUE',
682: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 680: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');

676: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_ASSET_ACTIVITY_ID));
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
678:
679: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
680: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
681: FND_MESSAGE.SET_TOKEN('VALUE',
682: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
684:

Line 681: FND_MESSAGE.SET_TOKEN('VALUE',

677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
678:
679: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
680: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
681: FND_MESSAGE.SET_TOKEN('VALUE',
682: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
684:
685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

679: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
680: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
681: FND_MESSAGE.SET_TOKEN('VALUE',
682: TO_CHAR(lv_ASSET_REBUILD_ITEM_ID));
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
684:
685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
686: END IF;
687: END;

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

876:
877: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
878:
879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
880: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
881: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
882: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
884:

Line 881: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

877: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
878:
879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
880: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
881: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
882: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
884:
885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 882: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

878:
879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
880: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
881: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
882: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
884:
885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
886: RAISE;

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

879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
880: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
881: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
882: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
884:
885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
886: RAISE;
887:

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

889:
890: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
891:
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:

Line 894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');

890: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
891:
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

891:
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');

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

892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
900: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ASSET_ACTIVITY_ID );

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

894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
900: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ASSET_ACTIVITY_ID );
901: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
902:

Line 899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');

895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
900: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ASSET_ACTIVITY_ID );
901: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
902:
903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 900: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ASSET_ACTIVITY_ID );

896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
900: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ASSET_ACTIVITY_ID );
901: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
902:
903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
904: END IF;

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

897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');
900: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ASSET_ACTIVITY_ID );
901: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
902:
903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
904: END IF;
905:

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

1052: WHEN OTHERS THEN
1053: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1054: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1055: '========================================');
1056: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1057: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1058: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1057: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');

1053: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1054: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1055: '========================================');
1056: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1057: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1058: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1061: RAISE;

Line 1058: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

1054: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1055: '========================================');
1056: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1057: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1058: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1061: RAISE;
1062: ELSE

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

1055: '========================================');
1056: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1057: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1058: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1061: RAISE;
1062: ELSE
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

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

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

Line 1066: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');

1062: ELSE
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1064: '========================================');
1065: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1066: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1067: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: END IF;

Line 1067: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

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

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

1064: '========================================');
1065: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1066: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1067: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: END IF;
1071: END;
1072: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh