APPS.MSC_CL_BOM_ODS_LOAD dependencies on FND_MESSAGE

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

96:
97: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
98:
99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:

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

97: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
98:
99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

98:
99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
106: RAISE;

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

99: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
100: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
101: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
102: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
106: RAISE;
107:

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

108: ELSE
109: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:

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

109: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',

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

113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));

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

114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 119: FND_MESSAGE.SET_TOKEN('VALUE',

115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
116:
117: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
118: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
119: FND_MESSAGE.SET_TOKEN('VALUE',
120: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
121: MSC_CL_COLLECTION.v_instance_id));
122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
123:

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

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

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

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

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

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

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

122: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
123:
124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');

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

123:
124: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
126: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
128:
129: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'SETUP_CODE');
131: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SETUP_CODE);

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

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

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

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

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

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

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

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

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

225:
226: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
227:
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:

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

226: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
227:
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

227:
228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
235: RAISE;

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

228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
229: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
230: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
231: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
235: RAISE;
236: ELSE

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

236: ELSE
237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
238:
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:

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

237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
238:
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

238:
239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',

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

241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));

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

242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 247: FND_MESSAGE.SET_TOKEN('VALUE',

243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
244:
245: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
246: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
247: FND_MESSAGE.SET_TOKEN('VALUE',
248: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
249: MSC_CL_COLLECTION.v_instance_id));
250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
251:

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

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

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

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

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

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

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

250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
251:
252: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');

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

251:
252: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
254: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
256:
257: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_SETUP_ID');
259: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.FROM_SETUP_ID);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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', 'TO_SETUP_ID');
265: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TO_SETUP_ID);
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
268: END IF;
269:
270: END;

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

399: WHEN OTHERS THEN
400: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:

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

400: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

401:
402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
409: RAISE;

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

402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
403: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
404: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
405: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
407:
408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
409: RAISE;
410:

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

412:
413: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
414:
415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:

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

413: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
414:
415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

414:
415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');

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

415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
416: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);

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

417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_CHARGES');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:

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

418: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHARGES');
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');

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

420:
421: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);

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

422: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_TRANSACTION_ID');
423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
430:

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

423: FND_MESSAGE.SET_TOKEN('VALUE', lv_TRANSACTION_ID);
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
430:
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
425:
426: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'CHARGE_NUMBER');
428: FND_MESSAGE.SET_TOKEN('VALUE', lv_CHARGE_NUMBER);
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
430:
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
432: END IF;

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

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

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

575: WHEN OTHERS THEN
576:
577: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:

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

576:
577: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

577: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
585: RAISE;

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

578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
585: RAISE;
586:

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

587: ELSE
588: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:

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

588: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

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

590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));

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

592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:

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

593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
598: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEPARTMENT_ID));
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
600:
601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
602: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
603: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RESOURCE_ID));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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', 'RES_INSTANCE_ID');
609: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RES_INSTANCE_ID));
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
611:
612: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
613: FND_MESSAGE.SET_TOKEN('COLUMN', 'SERIAL_NUMBER');
614: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SERIAL_NUMBER);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

834:
835: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
836:
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:

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

835: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
836:
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

836:
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

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

837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));

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

839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:

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

840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');

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

842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
845: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
847:
848: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
849: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
850: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.COMPONENT_SEQUENCE_ID));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

854: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUBSTITUTE_ITEM_NAME');
855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));

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

855: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.SUBSTITUTE_ITEM_ID));
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));
863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 860: FND_MESSAGE.SET_TOKEN('VALUE',

856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
857:
858: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));
863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
864:

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

859: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
860: FND_MESSAGE.SET_TOKEN('VALUE',
861: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
862: MSC_CL_COLLECTION.v_instance_id));
863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
864:
865: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
866:
867: END;

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

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

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

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

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

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

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

1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1014: RAISE;
1015:

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

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

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

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

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

1018:
1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1020: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1020: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',

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

1021: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));

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

1022: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BILL_OF_RESOURCES');
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1027: FND_MESSAGE.SET_TOKEN('VALUE',

1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1024:
1025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1026: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1027: FND_MESSAGE.SET_TOKEN('VALUE',
1028: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1029: MSC_CL_COLLECTION.v_instance_id));
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1031:

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

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

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

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

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

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

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

1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1031:
1032: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1033: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1034: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1038:

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

1031:
1032: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1033: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_OF_RESOURCES');
1034: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.BILL_OF_RESOURCES);
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1036:
1037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1038:
1039: END IF;

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

1146:
1147: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1148:
1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:

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

1147: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1148:
1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1148:
1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1156: RAISE;

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

1149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1150: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1151: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1152: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1156: RAISE;
1157:

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

1158: ELSE
1159: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:

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

1159: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');

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

1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1162: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));

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

1163: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:

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

1164: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

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

1166:
1167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1168: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');
1169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.SR_TRANSACTION_ID));
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
1174: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1472:
1473: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1474:
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:

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

1473: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1474:
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1474:
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1482: RAISE;

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

1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1482: RAISE;
1483:

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

1484: ELSE
1485: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1486:
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:

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

1485: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1486:
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1486:
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

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

1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:

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

1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',

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

1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));

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

1495: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1500: FND_MESSAGE.SET_TOKEN('VALUE',

1496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1497:
1498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:

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

1499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1500: FND_MESSAGE.SET_TOKEN('VALUE',
1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));

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

1501: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:

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

1502: MSC_CL_COLLECTION.v_instance_id));
1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

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

1504:
1505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));

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

1506: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:

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

1507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.BILL_SEQUENCE_ID));
1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1516: END IF;

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

1509:
1510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1511: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');
1512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.ROUTING_SEQUENCE_ID));
1513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1514:
1515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1516: END IF;
1517: END;

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

1714: WHEN OTHERS THEN
1715: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1716:
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:

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

1715: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1716:
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1716:
1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1724: RAISE;

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

1717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1718: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1719: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1720: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1722:
1723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1724: RAISE;
1725:

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

1724: RAISE;
1725:
1726: ELSE
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:

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

1725:
1726: ELSE
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1726: ELSE
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1734:

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

1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1728: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1729: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1730: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1734:
1735: --If Direct path load results in warning then the processing has to be

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

1859: WHEN OTHERS THEN
1860: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1861:
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:

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

1860: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1861:
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1861:
1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1869: RAISE;

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

1862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1863: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1864: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1865: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1869: RAISE;
1870:

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

1872:
1873: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1874:
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:

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

1873: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1874:
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1874:
1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');

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

1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1876: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));

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

1877: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM');
1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:

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

1878: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOMS');
1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

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

1880:
1881: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));

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

1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');
1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:

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

1883: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(lb_ASSEMBLY_ITEM_ID(j)));
1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:
1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

1884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:
1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1892:

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

1885:
1886: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1887: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
1888: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
1889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1890:
1891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1892:
1893: END IF;

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

2221: WHEN OTHERS THEN
2222: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2223:
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:

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

2222: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2223:
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2223:
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2231: RAISE;

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

2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2231: RAISE;
2232:

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

2231: RAISE;
2232:
2233: ELSE
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:

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

2232:
2233: ELSE
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2233: ELSE
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2241:

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

2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2241:
2242: --If Direct path load results in warning then the processing has to be

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));

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

2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:

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

2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');

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

2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));

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

2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');
2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:

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

2499: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_BILL_SEQUENCE_ID(j)));
2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

2500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2508:

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

2501:
2502: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2503: FND_MESSAGE.SET_TOKEN('COLUMN', 'COMPONENT_SEQUENCE_ID');
2504: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( lb_COMPONENT_SEQUENCE_ID(j)));
2505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2506:
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2508:
2509: END IF;

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

3072:
3073: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3074:
3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:

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

3073: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3074:
3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:
3081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3074:
3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:
3081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3082: RAISE;

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

3075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3080:
3081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3082: RAISE;
3083:

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

3084: ELSE
3085: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3086:
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:

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

3085: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3086:
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3086:
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',

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

3089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));

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

3090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3095: FND_MESSAGE.SET_TOKEN('VALUE',

3091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3092:
3093: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:

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

3094: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3095: FND_MESSAGE.SET_TOKEN('VALUE',
3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);

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

3096: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:

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

3097: MSC_CL_COLLECTION.v_instance_id));
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');

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

3099:
3100: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);

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

3101: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_CODE');
3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:

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

3102: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_CODE);
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3111: END IF;

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

3104:
3105: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3106: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_CODE');
3107: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_CODE);
3108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3109:
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3111: END IF;
3112:

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

3175:
3176: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3177:
3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:

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

3176: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3177:
3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:
3184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3177:
3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:
3184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3185: RAISE;

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

3178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3179: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3180: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3181: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3182: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3183:
3184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3185: RAISE;
3186:

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

3187: ELSE
3188: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3189:
3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:

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

3188: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3189:
3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3189:
3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');

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

3190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3191: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);

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

3192: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:

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

3193: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');

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

3195:
3196: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);

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

3197: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');
3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:

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

3198: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.ORGANIZATION_ID);
3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

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

3200:
3201: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);

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

3202: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:

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

3203: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEPARTMENT_ID);
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');

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

3205:
3206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);

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

3207: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3208: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RESOURCE_ID);
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3216: END IF;

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

3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3216: END IF;
3217:

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

3210:
3211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3212: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
3213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RES_INSTANCE_ID);
3214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3216: END IF;
3217:
3218: END;

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

3284:
3285: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3286:
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:

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

3285: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3286:
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3286:
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3294: RAISE;

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

3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3294: RAISE;
3295:

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

3296: ELSE
3297: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3298:
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:

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

3297: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3298:
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3298:
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',

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

3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));

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

3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3307: FND_MESSAGE.SET_TOKEN('VALUE',

3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:

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

3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3307: FND_MESSAGE.SET_TOKEN('VALUE',
3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);

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

3308: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:

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

3309: MSC_CL_COLLECTION.v_instance_id));
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:
3317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:
3317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3318: END IF;

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

3311:
3312: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3313: FND_MESSAGE.SET_TOKEN('COLUMN', 'SIMULATION_SET');
3314: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SIMULATION_SET);
3315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3316:
3317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3318: END IF;
3319:

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

3369:
3370: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3371:
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:

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

3370: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3371:
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3371:
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3379: RAISE;

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

3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3379: RAISE;
3380:

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

3381: ELSE
3382: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3383:
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:

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

3382: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3383:
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

3383:
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');

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

3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);

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

3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:

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

3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

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

3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3396: END IF;

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

3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');
3392: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.GROUP_CODE);
3393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3394:
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3396: END IF;
3397: