96:
97: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
98:
99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:
97: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
98:
99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
98:
99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
106: RAISE;
99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
106: RAISE;
107:
108: ELSE
109: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
109: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
123:
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
123:
124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
123:
124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
121: MSC_CL_COLLECTION.v_instance_id));
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
123:
124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
123:
124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
123:
124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
133:
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
133:
134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
133:
134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
135: END IF;
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
133:
134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
135: END IF;
136:
225:
226: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
227:
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:
226: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
227:
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
227:
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
235: RAISE;
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
235: RAISE;
236: ELSE
236: ELSE
237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
238:
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
238:
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
238:
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
251:
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
251:
252: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
251:
252: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
249: MSC_CL_COLLECTION.v_instance_id));
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
251:
252: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
251:
252: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
251:
252: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
259: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
259: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
261:
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
259: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
261:
262:
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
259: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
261:
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
259: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
261:
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
259: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
261:
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
261:
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
268: END IF;
261:
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
268: END IF;
269:
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
268: END IF;
269:
270: END;
399: WHEN OTHERS THEN
400: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:
400: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
409: RAISE;
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
409: RAISE;
410:
412:
413: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
414:
415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
413: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
414:
415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
414:
415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
430:
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
430:
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
430:
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
432: END IF;
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
430:
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
432: END IF;
433:
575: WHEN OTHERS THEN
576:
577: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
576:
577: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
577: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
585: RAISE;
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
585: RAISE;
586:
587: ELSE
588: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
588: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
603: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
603: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
605:
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
603: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
605:
606:
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
603: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
605:
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
603: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
605:
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
603: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
605:
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
605:
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
605:
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
618: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
618: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
619: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
618: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
619: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
621:
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
618: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
619: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
621:
622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
618: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
619: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
621:
622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
623: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
616:
617: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
618: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
619: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
621:
622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
623: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
618: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
619: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
621:
622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
623: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
626:
619: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
621:
622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
623: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
626:
627: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
621:
622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
623: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
626:
627: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
628: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
621:
622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
623: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
626:
627: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
628: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
629: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
623: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
626:
627: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
628: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
629: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
631:
624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
626:
627: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
628: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
629: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
631:
632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
626:
627: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
628: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
629: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
631:
632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
633: END IF;
626:
627: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
628: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
629: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
631:
632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
633: END IF;
634:
834:
835: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
836:
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
835: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
836:
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
836:
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
852:
853: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));
863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));
863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
864:
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));
863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
864:
865: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
866:
867: END;
1004:
1005: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1012:
1005: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1014: RAISE;
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1014: RAISE;
1015:
1016: ELSE
1017: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1020: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1017: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1020: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1020: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1020: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1031:
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1031:
1032: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1033: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1034: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1031:
1032: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1033: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1034: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1036:
1029: MSC_CL_COLLECTION.v_instance_id));
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1031:
1032: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1033: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1034: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1031:
1032: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1033: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1034: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1038:
1031:
1032: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1033: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1034: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1038:
1039: END IF;
1146:
1147: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1148:
1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:
1147: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1148:
1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1148:
1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1156: RAISE;
1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1156: RAISE;
1157:
1158: ELSE
1159: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1159: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1176:
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1176:
1177: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1176:
1177: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1178: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1176:
1177: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1178: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1179: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1176:
1177: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1178: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1179: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1180: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1181:
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1176:
1177: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1178: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1179: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1180: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1181:
1182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1176:
1177: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1178: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1179: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1180: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1181:
1182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1183:
1176:
1177: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1178: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1179: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1180: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1181:
1182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1183:
1184: END IF;
1472:
1473: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1474:
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1473: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1474:
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1474:
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1482: RAISE;
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1482: RAISE;
1483:
1484: ELSE
1485: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1486:
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1485: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1486:
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1486:
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1516: END IF;
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1516: END IF;
1517: END;
1714: WHEN OTHERS THEN
1715: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1716:
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1715: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1716:
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1716:
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1724: RAISE;
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1724: RAISE;
1725:
1724: RAISE;
1725:
1726: ELSE
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1725:
1726: ELSE
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1726: ELSE
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1734:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1734:
1735: --If Direct path load results in warning then the processing has to be
1859: WHEN OTHERS THEN
1860: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1861:
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1860: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1861:
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1861:
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1869: RAISE;
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1869: RAISE;
1870:
1872:
1873: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1874:
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1873: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1874:
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1874:
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:
1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:
1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1892:
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:
1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1892:
1893: END IF;
2221: WHEN OTHERS THEN
2222: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2223:
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2222: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2223:
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2223:
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2231: RAISE;
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2231: RAISE;
2232:
2231: RAISE;
2232:
2233: ELSE
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2232:
2233: ELSE
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2233: ELSE
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2241:
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2241:
2242: --If Direct path load results in warning then the processing has to be
2475: WHEN OTHERS THEN
2476: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2476: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2485: RAISE;
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2485: RAISE;
2486:
2488:
2489: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2489: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2508:
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2508:
2509: END IF;
3072:
3073: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3074:
3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:
3073: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3074:
3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:
3081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3074:
3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:
3081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3082: RAISE;
3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:
3081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3082: RAISE;
3083:
3084: ELSE
3085: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3086:
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3085: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3086:
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3086:
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3111: END IF;
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3111: END IF;
3112:
3175:
3176: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3177:
3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:
3176: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3177:
3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:
3184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3177:
3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:
3184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3185: RAISE;
3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:
3184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3185: RAISE;
3186:
3187: ELSE
3188: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3189:
3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3188: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3189:
3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3189:
3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3216: END IF;
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3216: END IF;
3217:
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3216: END IF;
3217:
3218: END;
3284:
3285: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3286:
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3285: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3286:
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3286:
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3294: RAISE;
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3294: RAISE;
3295:
3296: ELSE
3297: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3298:
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3297: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3298:
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3298:
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:
3317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:
3317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3318: END IF;
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:
3317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3318: END IF;
3319:
3369:
3370: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3371:
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3370: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3371:
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3371:
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3379: RAISE;
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3379: RAISE;
3380:
3381: ELSE
3382: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3383:
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3382: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3383:
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3383:
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3396: END IF;
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3396: END IF;
3397: