APPS.MSC_CL_BOM_ODS_LOAD dependencies on FND_MESSAGE

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

102:
103: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
106: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
108: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
110:

Line 107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');

103: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
106: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
108: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 108: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');

104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
106: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
108: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
112: RAISE;

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

105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
106: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
108: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
112: RAISE;
113:

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

114: ELSE
115: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
116:
117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
118: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
119: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:

Line 119: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');

115: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
116:
117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
118: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
119: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:
123: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');

116:
117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
118: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
119: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:
123: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
118: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
119: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:
123: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
125: FND_MESSAGE.SET_TOKEN('VALUE',

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

119: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:
123: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
125: FND_MESSAGE.SET_TOKEN('VALUE',
126: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
127: MSC_CL_COLLECTION.v_instance_id));

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

120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:
123: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
125: FND_MESSAGE.SET_TOKEN('VALUE',
126: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
127: MSC_CL_COLLECTION.v_instance_id));
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 125: FND_MESSAGE.SET_TOKEN('VALUE',

121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:
123: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
125: FND_MESSAGE.SET_TOKEN('VALUE',
126: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
127: MSC_CL_COLLECTION.v_instance_id));
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
129:

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

124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
125: FND_MESSAGE.SET_TOKEN('VALUE',
126: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
127: MSC_CL_COLLECTION.v_instance_id));
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
129:
130: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
131: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

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

126: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
127: MSC_CL_COLLECTION.v_instance_id));
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
129:
130: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
131: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
134:

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

127: MSC_CL_COLLECTION.v_instance_id));
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
129:
130: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
131: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
134:
135: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
129:
130: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
131: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
134:
135: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');

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

129:
130: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
131: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
134:
135: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
137: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);

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

131: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
134:
135: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
137: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
139:

Line 136: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');

132: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
134:
135: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
137: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
139:
140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 137: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);

133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
134:
135: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
137: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
139:
140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
141: END IF;

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

134:
135: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
137: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
139:
140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
141: END IF;
142:

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

231:
232: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
239:

Line 236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');

232: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
239:
240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');

233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
239:
240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
241: RAISE;

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

234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
239:
240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
241: RAISE;
242: ELSE

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

242: ELSE
243: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
244:
245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
246: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
247: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:

Line 247: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');

243: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
244:
245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
246: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
247: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:
251: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');

244:
245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
246: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
247: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:
251: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
252: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
246: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
247: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:
251: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
252: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
253: FND_MESSAGE.SET_TOKEN('VALUE',

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

247: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:
251: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
252: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
253: FND_MESSAGE.SET_TOKEN('VALUE',
254: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
255: MSC_CL_COLLECTION.v_instance_id));

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

248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:
251: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
252: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
253: FND_MESSAGE.SET_TOKEN('VALUE',
254: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
255: MSC_CL_COLLECTION.v_instance_id));
256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 253: FND_MESSAGE.SET_TOKEN('VALUE',

249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:
251: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
252: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
253: FND_MESSAGE.SET_TOKEN('VALUE',
254: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
255: MSC_CL_COLLECTION.v_instance_id));
256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
257:

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

252: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
253: FND_MESSAGE.SET_TOKEN('VALUE',
254: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
255: MSC_CL_COLLECTION.v_instance_id));
256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
257:
258: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
259: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

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

254: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
255: MSC_CL_COLLECTION.v_instance_id));
256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
257:
258: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
259: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
262:

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

255: MSC_CL_COLLECTION.v_instance_id));
256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
257:
258: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
259: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
257:
258: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
259: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');

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

257:
258: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
259: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);

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

259: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267:

Line 264: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');

260: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267:
268:

Line 265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);

261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267:
268:
269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

262:
263: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
264: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267:
268:
269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
270: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');

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

265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267:
268:
269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
270: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
271: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 270: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');

266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267:
268:
269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
270: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
271: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
274: END IF;

Line 271: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);

267:
268:
269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
270: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
271: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
274: END IF;
275:

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

268:
269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
270: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_SETUP_ID');
271: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
274: END IF;
275:
276: END;

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

405: WHEN OTHERS THEN
406: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
409: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
410: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
411: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
413:

Line 410: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');

406: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
409: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
410: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
411: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
413:
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 411: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');

407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
409: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
410: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
411: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
413:
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
415: RAISE;

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

408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
409: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
410: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
411: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
413:
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
415: RAISE;
416:

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

418:
419: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
420:
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
422: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
423: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
424: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
426:

Line 423: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');

419: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
420:
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
422: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
423: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
424: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
426:
427: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 424: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');

420:
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
422: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
423: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
424: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
426:
427: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');

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

421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
422: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
423: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
424: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
426:
427: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);

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

423: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
424: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
426:
427: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
431:

Line 428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');

424: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
426:
427: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
431:
432: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);

425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
426:
427: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
431:
432: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
433: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');

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

426:
427: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
431:
432: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
433: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
434: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);

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

428: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
431:
432: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
433: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
434: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
436:

Line 433: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');

429: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
431:
432: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
433: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
434: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
436:
437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 434: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);

430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
431:
432: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
433: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
434: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
436:
437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
438: END IF;

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

431:
432: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
433: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
434: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
436:
437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
438: END IF;
439:

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

581: WHEN OTHERS THEN
582:
583: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
585: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
586: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
589:

Line 586: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');

582:
583: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
585: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
586: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');

583: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
585: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
586: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
591: RAISE;

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

584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
585: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
586: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
591: RAISE;
592:

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

593: ELSE
594: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
595:
596: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
597: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
598: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:

Line 598: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');

594: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
595:
596: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
597: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
598: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');

595:
596: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
597: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
598: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

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

596: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
597: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
598: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));

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

598: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:

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

599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));

600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));

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

603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:

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

604: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612:

Line 609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));

605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612:
613: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

606:
607: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
608: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612:
613: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
614: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');

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

609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612:
613: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
614: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
615: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
617:

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

610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612:
613: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
614: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
615: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
617:
618: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 615: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));

611:
612:
613: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
614: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
615: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
617:
618: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');

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

612:
613: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
614: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
615: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
617:
618: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);

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

614: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
615: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
617:
618: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
622:

Line 619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');

615: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
617:
618: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
622:
623: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);

616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
617:
618: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
622:
623: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');

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

617:
618: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
622:
623: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));

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

619: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
622:
623: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
627:

Line 624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');

620: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);
621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
622:
623: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
627:
628: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));

621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
622:
623: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
627:
628: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');

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

622:
623: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
627:
628: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));

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

624: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIFT_NUM');
625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
627:
628: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
632:

Line 629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');

625: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SHIFT_NUM));
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
627:
628: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
632:
633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));

626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
627:
628: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
632:
633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
634: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');

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

627:
628: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
632:
633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
634: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
635: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);

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

629: FND_MESSAGE.SET_TOKEN('COLUMN', 'ACTION_TYPE');
630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
632:
633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
634: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
635: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
637:

Line 634: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');

630: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.ACTION_TYPE));
631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
632:
633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
634: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
635: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
637:
638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 635: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);

631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
632:
633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
634: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
635: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
637:
638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
639: END IF;

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

632:
633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
634: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
635: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
637:
638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
639: END IF;
640:

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

840:
841: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
842:
843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
844: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
845: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:

Line 845: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');

841: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
842:
843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
844: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
845: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');

842:
843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
844: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
845: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

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

843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
844: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
845: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));

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

845: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
853:

Line 850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
853:
854: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));

847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
853:
854: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');

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

848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
853:
854: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));

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

850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
853:
854: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
858:

Line 855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');

851: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
853:
854: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
858:
859: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));

852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
853:
854: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
858:
859: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');

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

853:
854: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
858:
859: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));

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

855: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
858:
859: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
863:

Line 860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');

856: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));
857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
858:
859: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
863:
864: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));

857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
858:
859: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
863:
864: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
865: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

858:
859: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
863:
864: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
865: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
866: FND_MESSAGE.SET_TOKEN('VALUE',

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

860: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
863:
864: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
865: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
866: FND_MESSAGE.SET_TOKEN('VALUE',
867: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
868: MSC_CL_COLLECTION.v_instance_id));

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

861: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
863:
864: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
865: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
866: FND_MESSAGE.SET_TOKEN('VALUE',
867: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
868: MSC_CL_COLLECTION.v_instance_id));
869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 866: FND_MESSAGE.SET_TOKEN('VALUE',

862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
863:
864: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
865: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
866: FND_MESSAGE.SET_TOKEN('VALUE',
867: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
868: MSC_CL_COLLECTION.v_instance_id));
869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
870:

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

865: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
866: FND_MESSAGE.SET_TOKEN('VALUE',
867: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
868: MSC_CL_COLLECTION.v_instance_id));
869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
870:
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
872:
873: END;

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

1010:
1011: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:

Line 1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');

1011: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');

1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1020: RAISE;

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

1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1020: RAISE;
1021:

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

1022: ELSE
1023: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1024:
1025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1026: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1027: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1030:

Line 1027: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');

1023: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1024:
1025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1026: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1027: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1030:
1031: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');

1024:
1025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1026: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1027: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1030:
1031: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1032: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1026: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1027: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1030:
1031: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1032: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1033: FND_MESSAGE.SET_TOKEN('VALUE',

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

1027: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1030:
1031: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1032: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1033: FND_MESSAGE.SET_TOKEN('VALUE',
1034: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1035: MSC_CL_COLLECTION.v_instance_id));

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

1028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1030:
1031: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1032: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1033: FND_MESSAGE.SET_TOKEN('VALUE',
1034: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1035: MSC_CL_COLLECTION.v_instance_id));
1036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1033: FND_MESSAGE.SET_TOKEN('VALUE',

1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1030:
1031: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1032: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1033: FND_MESSAGE.SET_TOKEN('VALUE',
1034: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1035: MSC_CL_COLLECTION.v_instance_id));
1036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1037:

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

1032: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1033: FND_MESSAGE.SET_TOKEN('VALUE',
1034: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1035: MSC_CL_COLLECTION.v_instance_id));
1036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1037:
1038: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1039: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1040: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);

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

1034: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1035: MSC_CL_COLLECTION.v_instance_id));
1036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1037:
1038: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1039: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1040: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1042:

Line 1039: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');

1035: MSC_CL_COLLECTION.v_instance_id));
1036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1037:
1038: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1039: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1040: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1042:
1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1040: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);

1036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1037:
1038: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1039: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1040: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1042:
1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1044:

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

1037:
1038: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1039: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1040: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1042:
1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1044:
1045: END IF;

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

1152:
1153: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1156: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1158: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1160:

Line 1157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');

1153: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1156: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1158: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1158: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');

1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1156: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1158: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1162: RAISE;

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

1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1156: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1158: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1162: RAISE;
1163:

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

1164: ELSE
1165: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1166:
1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1168: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:

Line 1169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');

1165: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1166:
1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1168: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');

1166:
1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1168: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');

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

1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1168: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));

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

1169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1177:

Line 1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');

1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1177:
1178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));

1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1177:
1178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1179: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

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

1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1177:
1178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1179: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);

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

1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1177:
1178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1179: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1182:

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

1175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1177:
1178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1179: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1182:
1183: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);

1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1177:
1178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1179: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1182:
1183: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

1177:
1178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1179: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1182:
1183: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1185: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

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

1179: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1182:
1183: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1185: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1187:

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

1180: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
1181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1182:
1183: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1185: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1187:
1188: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1185: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

1181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1182:
1183: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1185: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1187:
1188: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1189:

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

1182:
1183: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
1185: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
1186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1187:
1188: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1189:
1190: END IF;

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

1491:
1492: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1493:
1494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1495: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1497: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1499:

Line 1496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');

1492: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1493:
1494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1495: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1497: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1499:
1500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1497: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');

1493:
1494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1495: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1497: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1499:
1500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1501: RAISE;

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

1494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1495: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1497: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1499:
1500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1501: RAISE;
1502:

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

1503: ELSE
1504: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1505:
1506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1507: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:

Line 1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');

1504: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1505:
1506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1507: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');

1505:
1506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1507: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

1506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1507: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1514: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1514: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1516:

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

1509: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1514: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1516:
1517: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1514: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1516:
1517: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1518: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1511:
1512: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1514: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1516:
1517: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1518: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1519: FND_MESSAGE.SET_TOKEN('VALUE',

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

1513: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1514: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1516:
1517: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1518: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1519: FND_MESSAGE.SET_TOKEN('VALUE',
1520: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1521: MSC_CL_COLLECTION.v_instance_id));

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

1514: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1516:
1517: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1518: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1519: FND_MESSAGE.SET_TOKEN('VALUE',
1520: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1521: MSC_CL_COLLECTION.v_instance_id));
1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1519: FND_MESSAGE.SET_TOKEN('VALUE',

1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1516:
1517: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1518: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1519: FND_MESSAGE.SET_TOKEN('VALUE',
1520: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1521: MSC_CL_COLLECTION.v_instance_id));
1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1523:

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

1518: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1519: FND_MESSAGE.SET_TOKEN('VALUE',
1520: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1521: MSC_CL_COLLECTION.v_instance_id));
1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1523:
1524: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1525: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));

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

1520: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1521: MSC_CL_COLLECTION.v_instance_id));
1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1523:
1524: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1525: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1528:

Line 1525: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

1521: MSC_CL_COLLECTION.v_instance_id));
1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1523:
1524: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1525: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1528:
1529: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));

1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1523:
1524: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1525: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1528:
1529: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1530: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

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

1523:
1524: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1525: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1528:
1529: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1530: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1531: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

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

1525: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1528:
1529: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1530: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1531: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1533:

Line 1530: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

1526: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1528:
1529: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1530: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1531: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1533:
1534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1531: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1528:
1529: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1530: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1531: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1533:
1534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1535: END IF;

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

1528:
1529: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1530: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1531: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1533:
1534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1535: END IF;
1536: END;

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

1733: WHEN OTHERS THEN
1734: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1735:
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1737: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1741:

Line 1738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');

1734: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1735:
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1737: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1741:
1742: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1735:
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1737: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1741:
1742: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1743: RAISE;

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

1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1737: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1741:
1742: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1743: RAISE;
1744:

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

1743: RAISE;
1744:
1745: ELSE
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1747: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1748: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1749: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1751:

Line 1748: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');

1744:
1745: ELSE
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1747: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1748: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1749: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1751:
1752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1749: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1745: ELSE
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1747: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1748: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1749: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1751:
1752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1753:

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

1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1747: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1748: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1749: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1751:
1752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1753:
1754: --If Direct path load results in warning then the processing has to be

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

1878: WHEN OTHERS THEN
1879: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1880:
1881: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1882: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1883: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1884: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1886:

Line 1883: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');

1879: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1880:
1881: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1882: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1883: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1884: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1886:
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1884: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1880:
1881: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1882: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1883: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1884: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1886:
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1888: RAISE;

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

1881: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1882: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1883: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1884: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1886:
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1888: RAISE;
1889:

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

1891:
1892: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1895: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:

Line 1896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');

1892: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1895: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');

1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1895: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');

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

1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1895: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));

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

1896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1904:

Line 1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');

1897: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1904:
1905: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));

1898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1904:
1905: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1906: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

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

1899:
1900: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1904:
1905: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1906: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1907: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));

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

1901: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1904:
1905: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1906: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1907: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:

Line 1906: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

1902: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1904:
1905: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1906: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1907: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1907: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));

1903: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1904:
1905: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1906: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1907: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1911:

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

1904:
1905: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1906: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1907: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1911:
1912: END IF;

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

2240: WHEN OTHERS THEN
2241: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2242:
2243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2244: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2245: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2246: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2248:

Line 2245: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');

2241: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2242:
2243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2244: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2245: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2246: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2248:
2249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2246: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2242:
2243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2244: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2245: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2246: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2248:
2249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2250: RAISE;

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

2243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2244: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2245: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2246: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2248:
2249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2250: RAISE;
2251:

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

2250: RAISE;
2251:
2252: ELSE
2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2254: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2255: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2256: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2258:

Line 2255: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');

2251:
2252: ELSE
2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2254: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2255: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2256: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2258:
2259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2256: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2252: ELSE
2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2254: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2255: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2256: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2258:
2259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2260:

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

2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2254: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2255: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2256: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2258:
2259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2260:
2261: --If Direct path load results in warning then the processing has to be

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

2494: WHEN OTHERS THEN
2495: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2496:
2497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2498: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2499: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2500: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2502:

Line 2499: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');

2495: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2496:
2497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2498: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2499: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2500: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2500: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2496:
2497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2498: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2499: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2500: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2504: RAISE;

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

2497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2498: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2499: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2500: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2504: RAISE;
2505:

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

2507:
2508: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2509:
2510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2511: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:

Line 2512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');

2508: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2509:
2510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2511: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2509:
2510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2511: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

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

2510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2511: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));

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

2512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2520:

Line 2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2520:
2521: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));

2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2520:
2521: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2522: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');

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

2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2520:
2521: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2522: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2523: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));

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

2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2520:
2521: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2522: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2523: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:

Line 2522: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');

2518: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2520:
2521: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2522: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2523: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2523: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));

2519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2520:
2521: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2522: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2523: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2527:

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

2520:
2521: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2522: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2523: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2527:
2528: END IF;

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

3091:
3092: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3093:
3094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3095: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3096: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3097: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:

Line 3096: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3092: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3093:
3094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3095: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3096: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3097: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3097: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');

3093:
3094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3095: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3096: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3097: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3101: RAISE;

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

3094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3095: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3096: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3097: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3101: RAISE;
3102:

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

3103: ELSE
3104: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3105:
3106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3107: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3108: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:

Line 3108: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3104: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3105:
3106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3107: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3108: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:
3112: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');

3105:
3106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3107: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3108: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:
3112: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3113: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3107: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3108: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:
3112: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3113: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3114: FND_MESSAGE.SET_TOKEN('VALUE',

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

3108: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:
3112: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3113: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3114: FND_MESSAGE.SET_TOKEN('VALUE',
3115: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3116: MSC_CL_COLLECTION.v_instance_id));

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

3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:
3112: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3113: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3114: FND_MESSAGE.SET_TOKEN('VALUE',
3115: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3116: MSC_CL_COLLECTION.v_instance_id));
3117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3114: FND_MESSAGE.SET_TOKEN('VALUE',

3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:
3112: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3113: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3114: FND_MESSAGE.SET_TOKEN('VALUE',
3115: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3116: MSC_CL_COLLECTION.v_instance_id));
3117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3118:

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

3113: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3114: FND_MESSAGE.SET_TOKEN('VALUE',
3115: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3116: MSC_CL_COLLECTION.v_instance_id));
3117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3118:
3119: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3120: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);

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

3115: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3116: MSC_CL_COLLECTION.v_instance_id));
3117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3118:
3119: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3120: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3123:

Line 3120: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');

3116: MSC_CL_COLLECTION.v_instance_id));
3117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3118:
3119: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3120: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3123:
3124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);

3117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3118:
3119: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3120: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3123:
3124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');

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

3118:
3119: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3120: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3123:
3124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);

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

3120: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3123:
3124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3128:

Line 3125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');

3121: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3123:
3124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3128:
3129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);

3122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3123:
3124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3128:
3129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3130: END IF;

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

3123:
3124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3128:
3129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3130: END IF;
3131:

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

3194:
3195: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3196:
3197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3198: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3199: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3200: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3202:

Line 3199: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3195: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3196:
3197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3198: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3199: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3200: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3202:
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3200: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');

3196:
3197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3198: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3199: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3200: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3202:
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3204: RAISE;

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

3197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3198: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3199: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3200: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3202:
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3204: RAISE;
3205:

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

3206: ELSE
3207: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3208:
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3210: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3211: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:

Line 3211: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3207: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3208:
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3210: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3211: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');

3208:
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3210: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3211: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');

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

3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3210: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3211: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);

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

3211: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:

Line 3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');

3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);

3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3221: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

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

3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3221: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);

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

3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3221: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3224:

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

3217: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3221: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3224:
3225: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);

3218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3219:
3220: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3221: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3224:
3225: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3226: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

3219:
3220: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3221: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3224:
3225: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3226: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

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

3221: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3224:
3225: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3226: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3229:

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

3222: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3224:
3225: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3226: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3229:
3230: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

3223: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3224:
3225: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3226: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3229:
3230: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3231: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');

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

3224:
3225: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3226: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3229:
3230: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3231: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3232: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);

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

3226: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3229:
3230: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3231: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3232: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3227: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3229:
3230: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3231: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3232: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3235: END IF;

Line 3232: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);

3228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3229:
3230: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3231: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3232: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3235: END IF;
3236:

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

3229:
3230: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3231: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3232: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3235: END IF;
3236:
3237: END;

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

3303:
3304: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3305:
3306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:

Line 3308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3304: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3305:
3306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');

3305:
3306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3313: RAISE;

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

3306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3313: RAISE;
3314:

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

3315: ELSE
3316: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3317:
3318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3319: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3320: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:

Line 3320: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3316: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3317:
3318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3319: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3320: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:
3324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');

3317:
3318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3319: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3320: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:
3324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3319: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3320: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:
3324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3326: FND_MESSAGE.SET_TOKEN('VALUE',

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

3320: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:
3324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3326: FND_MESSAGE.SET_TOKEN('VALUE',
3327: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3328: MSC_CL_COLLECTION.v_instance_id));

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

3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:
3324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3326: FND_MESSAGE.SET_TOKEN('VALUE',
3327: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3328: MSC_CL_COLLECTION.v_instance_id));
3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3326: FND_MESSAGE.SET_TOKEN('VALUE',

3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:
3324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3326: FND_MESSAGE.SET_TOKEN('VALUE',
3327: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3328: MSC_CL_COLLECTION.v_instance_id));
3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3330:

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

3325: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3326: FND_MESSAGE.SET_TOKEN('VALUE',
3327: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3328: MSC_CL_COLLECTION.v_instance_id));
3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3330:
3331: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3332: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3333: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);

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

3327: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3328: MSC_CL_COLLECTION.v_instance_id));
3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3330:
3331: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3332: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3333: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3335:

Line 3332: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');

3328: MSC_CL_COLLECTION.v_instance_id));
3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3330:
3331: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3332: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3333: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3335:
3336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3333: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);

3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3330:
3331: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3332: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3333: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3335:
3336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3337: END IF;

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

3330:
3331: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3332: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3333: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3335:
3336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3337: END IF;
3338:

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

3388:
3389: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3390:
3391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3392: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3393: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3394: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3396:

Line 3393: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3389: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3390:
3391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3392: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3393: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3394: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3396:
3397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3394: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');

3390:
3391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3392: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3393: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3394: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3396:
3397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3398: RAISE;

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

3391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3392: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3393: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3394: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3396:
3397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3398: RAISE;
3399:

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

3400: ELSE
3401: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3402:
3403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3404: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3405: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:

Line 3405: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');

3401: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3402:
3403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3404: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3405: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');

3402:
3403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3404: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3405: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');

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

3403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3404: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3405: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3411: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);

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

3405: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3411: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3413:

Line 3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');

3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3411: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3413:
3414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3411: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);

3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3411: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3413:
3414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3415: END IF;

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

3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3411: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3413:
3414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3415: END IF;
3416: