eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_PVT dependencies on FND_MESSAGE

Line 37: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );

33: p_route_rec.dml_operation <> 'C'
34: )
35: )
36: THEN
37: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
38: FND_MESSAGE.set_token( 'FIELD', p_route_rec.dml_operation );
39: FND_MSG_PUB.add;
40: x_return_status := FND_API.G_RET_STS_ERROR;
41: RETURN;

Line 38: FND_MESSAGE.set_token( 'FIELD', p_route_rec.dml_operation );

34: )
35: )
36: THEN
37: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
38: FND_MESSAGE.set_token( 'FIELD', p_route_rec.dml_operation );
39: FND_MSG_PUB.add;
40: x_return_status := FND_API.G_RET_STS_ERROR;
41: RETURN;
42: END IF;

Line 180: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );

176: );
177:
178: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
179: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
180: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );
181: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
182: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );
183: ELSE
184: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 182: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );

178: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
179: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
180: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );
181: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
182: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );
183: ELSE
184: FND_MESSAGE.set_name( 'AHL', l_msg_data );
185: END IF;
186:

Line 184: FND_MESSAGE.set_name( 'AHL', l_msg_data );

180: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );
181: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
182: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );
183: ELSE
184: FND_MESSAGE.set_name( 'AHL', l_msg_data );
185: END IF;
186:
187: IF ( p_x_route_rec.route_type IS NULL OR
188: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN

Line 189: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type_code );

185: END IF;
186:
187: IF ( p_x_route_rec.route_type IS NULL OR
188: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
189: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type_code );
190: ELSE
191: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type );
192: END IF;
193:

Line 191: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type );

187: IF ( p_x_route_rec.route_type IS NULL OR
188: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
189: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type_code );
190: ELSE
191: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type );
192: END IF;
193:
194: FND_MSG_PUB.add;
195: END IF;

Line 217: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );

213: );
214:
215: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
216: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
217: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
218: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
219: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
220: ELSE
221: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 219: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );

215: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
216: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
217: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
218: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
219: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
220: ELSE
221: FND_MESSAGE.set_name( 'AHL', l_msg_data );
222: END IF;
223:

Line 221: FND_MESSAGE.set_name( 'AHL', l_msg_data );

217: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
218: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
219: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
220: ELSE
221: FND_MESSAGE.set_name( 'AHL', l_msg_data );
222: END IF;
223:
224: IF ( p_x_route_rec.model_meaning IS NULL OR
225: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

Line 226: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_code );

222: END IF;
223:
224: IF ( p_x_route_rec.model_meaning IS NULL OR
225: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
226: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_code );
227: ELSE
228: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_meaning );
229: END IF;
230:

Line 228: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_meaning );

224: IF ( p_x_route_rec.model_meaning IS NULL OR
225: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
226: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_code );
227: ELSE
228: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_meaning );
229: END IF;
230:
231: FND_MSG_PUB.add;
232: END IF;

Line 254: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );

250: );
251:
252: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
253: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
254: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
255: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
256: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
257: ELSE
258: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 256: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );

252: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
253: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
254: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
255: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
256: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
257: ELSE
258: FND_MESSAGE.set_name( 'AHL', l_msg_data );
259: END IF;
260:

Line 258: FND_MESSAGE.set_name( 'AHL', l_msg_data );

254: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
255: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
256: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
257: ELSE
258: FND_MESSAGE.set_name( 'AHL', l_msg_data );
259: END IF;
260:
261: IF ( p_x_route_rec.process IS NULL OR
262: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN

Line 263: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process_code );

259: END IF;
260:
261: IF ( p_x_route_rec.process IS NULL OR
262: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
263: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process_code );
264: ELSE
265: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process );
266: END IF;
267:

Line 265: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process );

261: IF ( p_x_route_rec.process IS NULL OR
262: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
263: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process_code );
264: ELSE
265: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process );
266: END IF;
267:
268: FND_MSG_PUB.add;
269: END IF;

Line 290: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );

286: );
287:
288: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
289: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
290: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );
291: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
292: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );
293: ELSE
294: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 292: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );

288: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
289: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
290: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );
291: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
292: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );
293: ELSE
294: FND_MESSAGE.set_name( 'AHL', l_msg_data );
295: END IF;
296:

Line 294: FND_MESSAGE.set_name( 'AHL', l_msg_data );

290: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );
291: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
292: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );
293: ELSE
294: FND_MESSAGE.set_name( 'AHL', l_msg_data );
295: END IF;
296:
297: IF ( p_x_route_rec.product_type IS NULL OR
298: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN

Line 299: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type_code );

295: END IF;
296:
297: IF ( p_x_route_rec.product_type IS NULL OR
298: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
299: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type_code );
300: ELSE
301: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type );
302: END IF;
303:

Line 301: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type );

297: IF ( p_x_route_rec.product_type IS NULL OR
298: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
299: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type_code );
300: ELSE
301: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type );
302: END IF;
303:
304: FND_MSG_PUB.add;
305: END IF;

Line 324: FND_MESSAGE.set_name( 'AHL', l_msg_data );

320: p_x_operator_party_id => p_x_route_rec.operator_party_id
321: );
322:
323: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
324: FND_MESSAGE.set_name( 'AHL', l_msg_data );
325:
326: IF ( p_x_route_rec.operator_name IS NULL OR
327: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
328: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );

Line 328: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );

324: FND_MESSAGE.set_name( 'AHL', l_msg_data );
325:
326: IF ( p_x_route_rec.operator_name IS NULL OR
327: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
328: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );
329: ELSE
330: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.operator_name );
331: END IF;
332:

Line 330: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.operator_name );

326: IF ( p_x_route_rec.operator_name IS NULL OR
327: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
328: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );
329: ELSE
330: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.operator_name );
331: END IF;
332:
333: FND_MSG_PUB.add;
334: END IF;

Line 355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );

351: );
352:
353: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
354: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );
356: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
357: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );
358: ELSE
359: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 357: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );

353: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
354: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );
356: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
357: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );
358: ELSE
359: FND_MESSAGE.set_name( 'AHL', l_msg_data );
360: END IF;
361:

Line 359: FND_MESSAGE.set_name( 'AHL', l_msg_data );

355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );
356: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
357: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );
358: ELSE
359: FND_MESSAGE.set_name( 'AHL', l_msg_data );
360: END IF;
361:
362: IF ( p_x_route_rec.zone IS NULL OR
363: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN

Line 364: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone_code );

360: END IF;
361:
362: IF ( p_x_route_rec.zone IS NULL OR
363: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
364: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone_code );
365: ELSE
366: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone );
367: END IF;
368:

Line 366: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone );

362: IF ( p_x_route_rec.zone IS NULL OR
363: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
364: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone_code );
365: ELSE
366: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone );
367: END IF;
368:
369: FND_MSG_PUB.add;
370: END IF;

Line 391: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );

387: );
388:
389: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
390: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
391: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );
392: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );
394: ELSE
395: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );

389: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
390: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
391: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );
392: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );
394: ELSE
395: FND_MESSAGE.set_name( 'AHL', l_msg_data );
396: END IF;
397:

Line 395: FND_MESSAGE.set_name( 'AHL', l_msg_data );

391: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );
392: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );
394: ELSE
395: FND_MESSAGE.set_name( 'AHL', l_msg_data );
396: END IF;
397:
398: IF ( p_x_route_rec.sub_zone IS NULL OR
399: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN

Line 400: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone_code );

396: END IF;
397:
398: IF ( p_x_route_rec.sub_zone IS NULL OR
399: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
400: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone_code );
401: ELSE
402: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone );
403: END IF;
404:

Line 402: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone );

398: IF ( p_x_route_rec.sub_zone IS NULL OR
399: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
400: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone_code );
401: ELSE
402: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone );
403: END IF;
404:
405: FND_MSG_PUB.add;
406: END IF;

Line 428: FND_MESSAGE.set_name( 'AHL', l_msg_data );

424: p_x_inventory_org_id => p_x_route_rec.service_item_org_id
425: );
426:
427: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
428: FND_MESSAGE.set_name( 'AHL', l_msg_data );
429:
430: IF ( p_x_route_rec.service_item_number IS NULL OR
431: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
432: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );

Line 432: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );

428: FND_MESSAGE.set_name( 'AHL', l_msg_data );
429:
430: IF ( p_x_route_rec.service_item_number IS NULL OR
431: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
432: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );
433: ELSE
434: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.service_item_number );
435: END IF;
436:

Line 434: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.service_item_number );

430: IF ( p_x_route_rec.service_item_number IS NULL OR
431: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
432: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );
433: ELSE
434: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.service_item_number );
435: END IF;
436:
437: FND_MSG_PUB.add;
438: END IF;

Line 460: FND_MESSAGE.set_name( 'AHL', l_msg_data );

456: p_x_accounting_class_org_id => p_x_route_rec.accounting_class_org_id
457: );
458:
459: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
460: FND_MESSAGE.set_name( 'AHL', l_msg_data );
461:
462: IF ( p_x_route_rec.accounting_class IS NULL OR
463: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
464: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );

Line 464: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );

460: FND_MESSAGE.set_name( 'AHL', l_msg_data );
461:
462: IF ( p_x_route_rec.accounting_class IS NULL OR
463: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
464: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );
465: ELSE
466: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class );
467: END IF;
468:

Line 466: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class );

462: IF ( p_x_route_rec.accounting_class IS NULL OR
463: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
464: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );
465: ELSE
466: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class );
467: END IF;
468:
469: FND_MSG_PUB.add;
470: END IF;

Line 489: FND_MESSAGE.set_name( 'AHL', l_msg_data );

485: p_x_task_template_group_id => p_x_route_rec.task_template_group_id
486: );
487:
488: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
489: FND_MESSAGE.set_name( 'AHL', l_msg_data );
490:
491: IF ( p_x_route_rec.task_template_group IS NULL OR
492: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
493: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );

Line 493: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );

489: FND_MESSAGE.set_name( 'AHL', l_msg_data );
490:
491: IF ( p_x_route_rec.task_template_group IS NULL OR
492: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
493: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );
494: ELSE
495: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.task_template_group );
496: END IF;
497:

Line 495: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.task_template_group );

491: IF ( p_x_route_rec.task_template_group IS NULL OR
492: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
493: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );
494: ELSE
495: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.task_template_group );
496: END IF;
497:
498: FND_MSG_PUB.add;
499: END IF;

Line 520: FND_MESSAGE.set_name( 'AHL', l_msg_data );

516: );
517:
518: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
519:
520: FND_MESSAGE.set_name( 'AHL', l_msg_data );
521: IF ( p_x_route_rec.warranty_template_name IS NULL OR
522: p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
523: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.warranty_template_id ) );
524: ELSE

Line 523: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.warranty_template_id ) );

519:
520: FND_MESSAGE.set_name( 'AHL', l_msg_data );
521: IF ( p_x_route_rec.warranty_template_name IS NULL OR
522: p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
523: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.warranty_template_id ) );
524: ELSE
525: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.warranty_template_name );
526: END IF;
527: FND_MSG_PUB.add;

Line 525: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.warranty_template_name );

521: IF ( p_x_route_rec.warranty_template_name IS NULL OR
522: p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
523: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.warranty_template_id ) );
524: ELSE
525: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.warranty_template_name );
526: END IF;
527: FND_MSG_PUB.add;
528:
529: END IF;

Line 536: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVLD_DUPLICATE_ROUTE' );

532: -- MANESING::VWP Enhancements, 18-Jan-2011
533: -- Validate Duplicate flag
534: IF ( p_x_route_rec.duplicate_flag IS NOT NULL AND
535: p_x_route_rec.duplicate_flag <> 'Y' AND p_x_route_rec.duplicate_flag <> 'N' ) THEN
536: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVLD_DUPLICATE_ROUTE' );
537: FND_MSG_PUB.add;
538: END IF;
539:
540: -- Validate Return to supply flag

Line 543: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVLD_RETURN_TO_SUPPLY' );

539:
540: -- Validate Return to supply flag
541: IF ( p_x_route_rec.return_to_supply_flag IS NOT NULL AND
542: p_x_route_rec.return_to_supply_flag <> 'Y' AND p_x_route_rec.return_to_supply_flag <> 'N' ) THEN
543: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVLD_RETURN_TO_SUPPLY' );
544: FND_MSG_PUB.add;
545: END IF;
546:
547: -- Convert / Validate QA Plan

Line 562: FND_MESSAGE.set_name( 'AHL', l_msg_data );

558: p_x_qa_inspection_type => p_x_route_rec.qa_inspection_type
559: );
560:
561: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
562: FND_MESSAGE.set_name( 'AHL', l_msg_data );
563:
564: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
565: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
566: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );

Line 566: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );

562: FND_MESSAGE.set_name( 'AHL', l_msg_data );
563:
564: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
565: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
566: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );
567: ELSE
568: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type_desc );
569: END IF;
570:

Line 568: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type_desc );

564: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
565: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
566: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );
567: ELSE
568: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type_desc );
569: END IF;
570:
571: FND_MSG_PUB.add;
572: END IF;

Line 593: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );

589: );
590:
591: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
592: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
593: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
594: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
596: ELSE
597: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );

591: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
592: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
593: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
594: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
596: ELSE
597: FND_MESSAGE.set_name( 'AHL', l_msg_data );
598: END IF;
599:

Line 597: FND_MESSAGE.set_name( 'AHL', l_msg_data );

593: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
594: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
595: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
596: ELSE
597: FND_MESSAGE.set_name( 'AHL', l_msg_data );
598: END IF;
599:
600: IF ( p_x_route_rec.revision_status IS NULL OR
601: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN

Line 602: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status_code );

598: END IF;
599:
600: IF ( p_x_route_rec.revision_status IS NULL OR
601: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
602: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status_code );
603: ELSE
604: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status );
605: END IF;
606:

Line 604: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status );

600: IF ( p_x_route_rec.revision_status IS NULL OR
601: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
602: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status_code );
603: ELSE
604: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status );
605: END IF;
606:
607: FND_MSG_PUB.add;
608: END IF;

Line 630: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );

626: );
627:
628: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
629: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
630: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );
631: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
632: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );
633: ELSE
634: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 632: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );

628: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
629: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
630: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );
631: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
632: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );
633: ELSE
634: FND_MESSAGE.set_name( 'AHL', l_msg_data );
635: END IF;
636:

Line 634: FND_MESSAGE.set_name( 'AHL', l_msg_data );

630: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );
631: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
632: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );
633: ELSE
634: FND_MESSAGE.set_name( 'AHL', l_msg_data );
635: END IF;
636:
637: IF ( p_x_route_rec.unit_receipt_update IS NULL OR
638: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN

Line 639: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update_flag );

635: END IF;
636:
637: IF ( p_x_route_rec.unit_receipt_update IS NULL OR
638: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN
639: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update_flag );
640: ELSE
641: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update );
642: END IF;
643: FND_MSG_PUB.add;

Line 641: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update );

637: IF ( p_x_route_rec.unit_receipt_update IS NULL OR
638: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN
639: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update_flag );
640: ELSE
641: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update );
642: END IF;
643: FND_MSG_PUB.add;
644: END IF;
645:

Line 665: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_JOB_CARD_LYT' );

661: );
662:
663: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
664: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
665: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_JOB_CARD_LYT' );
666: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
667: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_JOB_CARD_LYT' );
668: ELSE
669: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 667: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_JOB_CARD_LYT' );

663: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
664: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
665: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_JOB_CARD_LYT' );
666: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
667: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_JOB_CARD_LYT' );
668: ELSE
669: FND_MESSAGE.set_name( 'AHL', l_msg_data );
670: END IF;
671:

Line 669: FND_MESSAGE.set_name( 'AHL', l_msg_data );

665: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_JOB_CARD_LYT' );
666: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
667: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_JOB_CARD_LYT' );
668: ELSE
669: FND_MESSAGE.set_name( 'AHL', l_msg_data );
670: END IF;
671:
672: IF ( p_x_route_rec.model_meaning IS NULL OR
673: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

Line 674: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_code );

670: END IF;
671:
672: IF ( p_x_route_rec.model_meaning IS NULL OR
673: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
674: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_code );
675: ELSE
676: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_meaning );
677: END IF;
678:

Line 676: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_meaning );

672: IF ( p_x_route_rec.model_meaning IS NULL OR
673: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
674: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_code );
675: ELSE
676: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.job_card_lyt_meaning );
677: END IF;
678:
679: FND_MSG_PUB.add;
680: END IF;

Line 1230: FND_MESSAGE.set_name( 'AHL', l_msg_data );

1226: p_x_route_rec => l_old_route_rec
1227: );
1228:
1229: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1230: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1231: FND_MSG_PUB.add;
1232: RAISE FND_API.G_EXC_ERROR;
1233: END IF;
1234:

Line 1244: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );

1240: p_x_route_rec.revision_status_code := 'DRAFT';
1241: END IF;
1242: -- Condition added in 11.5.10.
1243: ELSIF p_x_route_rec.revision_status_code <> l_old_route_rec.revision_status_code THEN
1244: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
1245: FND_MSG_PUB.add;
1246: END IF;
1247:
1248: IF ( p_x_route_rec.revision_status IS NULL ) THEN

Line 1251: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );

1247:
1248: IF ( p_x_route_rec.revision_status IS NULL ) THEN
1249: p_x_route_rec.revision_status := l_old_route_rec.revision_status;
1250: ELSIF p_x_route_rec.revision_status <> l_old_route_rec.revision_status THEN
1251: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
1252: FND_MSG_PUB.add;
1253: END IF;
1254:
1255: --snarkhed Enigma Phase II changes start

Line 1265: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_RO' );

1261: p_x_route_rec.model_code := null;
1262: END IF;
1263:
1264: IF( upper(l_old_route_rec.enigma_source_code) = 'AUTOMATIC' AND p_x_route_rec.model_code <> l_old_route_rec.model_code ) THEN
1265: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_RO' );
1266: FND_MSG_PUB.add;
1267: END IF;
1268:
1269: IF ( p_x_route_rec.model_meaning IS NULL ) THEN

Line 1276: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_RO' );

1272: p_x_route_rec.model_meaning := null;
1273: END IF;
1274:
1275: IF (upper(l_old_route_rec.enigma_source_code) = 'AUTOMATIC' AND p_x_route_rec.model_meaning <> l_old_route_rec.model_meaning ) THEN
1276: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_RO' );
1277: FND_MSG_PUB.add;
1278: END IF;
1279:
1280: IF ( upper(l_old_route_rec.enigma_source_code) = 'AUTOMATIC' AND p_x_route_rec.file_id IS NULL ) THEN

Line 1296: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ENGIMA_DOC_CHANGE' );

1292: p_x_route_rec.enigma_doc_id := l_old_route_rec.enigma_doc_id;
1293: END IF;
1294:
1295: IF(upper(l_old_route_rec.enigma_source_code) = 'AUTOMATIC' AND p_x_route_rec.enigma_doc_id <> l_old_route_rec.enigma_doc_id AND p_module_type <> 'BPEL') THEN
1296: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ENGIMA_DOC_CHANGE' );
1297: FND_MSG_PUB.add;
1298: END IF;
1299:
1300: -- IF Job Card Layout Defaulting logic.

Line 1312: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_REVISION_RO' );

1308:
1309: IF ( p_x_route_rec.revision_number IS NULL ) THEN
1310: p_x_route_rec.revision_number := l_old_route_rec.revision_number;
1311: ELSIF p_x_route_rec.revision_number <> l_old_route_rec.revision_number THEN
1312: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_REVISION_RO' );
1313: FND_MSG_PUB.add;
1314: END IF;
1315:
1316: IF ( p_x_route_rec.route_no IS NULL ) THEN

Line 1319: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_RO' );

1315:
1316: IF ( p_x_route_rec.route_no IS NULL ) THEN
1317: p_x_route_rec.route_no := l_old_route_rec.route_no;
1318: ELSIF p_x_route_rec.route_no <> l_old_route_rec.route_no THEN
1319: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_RO' );
1320: FND_MSG_PUB.add;
1321: END IF;
1322:
1323: IF ( p_x_route_rec.revision_status_code = 'DRAFT' ) THEN

Line 1333: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TITLE_RO' );

1329: IF ( p_x_route_rec.title IS NULL ) THEN
1330: p_x_route_rec.title := l_old_route_rec.title;
1331: ELSE
1332: IF ( l_read_only_flag = 'Y' ) THEN
1333: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TITLE_RO' );
1334: FND_MSG_PUB.add;
1335: END IF;
1336: END IF;
1337:

Line 1342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ST_DATE_RO' );

1338: IF ( p_x_route_rec.active_start_date IS NULL ) THEN
1339: p_x_route_rec.active_start_date := l_old_route_rec.active_start_date;
1340: ELSE
1341: IF ( l_read_only_flag = 'Y' ) THEN
1342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ST_DATE_RO' );
1343: FND_MSG_PUB.add;
1344: ELSIF ( p_x_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1345: p_x_route_rec.active_start_date := NULL;
1346: END IF;

Line 1353: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_RO' );

1349: IF ( p_x_route_rec.active_end_date IS NULL ) THEN
1350: p_x_route_rec.active_end_date := l_old_route_rec.active_end_date;
1351: ELSE
1352: IF ( l_read_only_flag = 'Y' ) THEN
1353: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_RO' );
1354: FND_MSG_PUB.add;
1355: END IF;
1356: END IF;
1357:

Line 1421: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );

1417: IF ( p_x_route_rec.operator_party_id IS NULL ) THEN
1418: p_x_route_rec.operator_party_id := l_old_route_rec.operator_party_id;
1419: ELSE
1420: IF ( l_read_only_flag = 'Y' ) THEN
1421: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );
1422: FND_MSG_PUB.add;
1423: ELSE
1424: IF ( p_x_route_rec.operator_party_id = FND_API.G_MISS_NUM ) THEN
1425: p_x_route_rec.operator_party_id := null;

Line 1434: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );

1430: IF ( p_x_route_rec.operator_name IS NULL ) THEN
1431: p_x_route_rec.operator_name := l_old_route_rec.operator_name;
1432: ELSE
1433: IF ( l_read_only_flag = 'Y' ) THEN
1434: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );
1435: FND_MSG_PUB.add;
1436: ELSE
1437: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
1438: p_x_route_rec.operator_name := null;

Line 1471: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );

1467: IF ( p_x_route_rec.service_item_id IS NULL ) THEN
1468: p_x_route_rec.service_item_id := l_old_route_rec.service_item_id;
1469: ELSE
1470: IF ( l_read_only_flag = 'Y' ) THEN
1471: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1472: FND_MSG_PUB.add;
1473: ELSE
1474: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN
1475: p_x_route_rec.service_item_id := null;

Line 1484: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );

1480: IF ( p_x_route_rec.service_item_org_id IS NULL ) THEN
1481: p_x_route_rec.service_item_org_id := l_old_route_rec.service_item_org_id;
1482: ELSE
1483: IF ( l_read_only_flag = 'Y' ) THEN
1484: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1485: FND_MSG_PUB.add;
1486: ELSE
1487: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN
1488: p_x_route_rec.service_item_org_id := null;

Line 1497: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );

1493: IF ( p_x_route_rec.service_item_number IS NULL ) THEN
1494: p_x_route_rec.service_item_number := l_old_route_rec.service_item_number;
1495: ELSE
1496: IF ( l_read_only_flag = 'Y' ) THEN
1497: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1498: FND_MSG_PUB.add;
1499: ELSE
1500: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
1501: p_x_route_rec.service_item_number := null;

Line 1528: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );

1524: IF ( p_x_route_rec.task_template_group_id IS NULL ) THEN
1525: p_x_route_rec.task_template_group_id := l_old_route_rec.task_template_group_id;
1526: ELSE
1527: IF ( l_read_only_flag = 'Y' ) THEN
1528: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );
1529: FND_MSG_PUB.add;
1530: ELSE
1531: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN
1532: p_x_route_rec.task_template_group_id := null;

Line 1541: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );

1537: IF ( p_x_route_rec.task_template_group IS NULL ) THEN
1538: p_x_route_rec.task_template_group := l_old_route_rec.task_template_group;
1539: ELSE
1540: IF ( l_read_only_flag = 'Y' ) THEN
1541: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );
1542: FND_MSG_PUB.add;
1543: ELSE
1544: IF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
1545: p_x_route_rec.task_template_group := null;

Line 1555: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_WARR_TEMP_NAME_RO' );

1551: IF ( p_x_route_rec.warranty_template_id IS NULL ) THEN
1552: p_x_route_rec.warranty_template_id := l_old_route_rec.warranty_template_id;
1553: ELSE
1554: IF ( l_read_only_flag = 'Y' ) THEN
1555: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_WARR_TEMP_NAME_RO' );
1556: FND_MSG_PUB.add;
1557: ELSE
1558: IF ( p_x_route_rec.warranty_template_id = FND_API.G_MISS_NUM ) THEN
1559: p_x_route_rec.warranty_template_id := null;

Line 1568: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_WARR_TEMP_NAME_RO' );

1564: IF ( p_x_route_rec.warranty_template_name IS NULL ) THEN
1565: p_x_route_rec.warranty_template_name := l_old_route_rec.warranty_template_name;
1566: ELSE
1567: IF ( l_read_only_flag = 'Y' ) THEN
1568: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_WARR_TEMP_NAME_RO' );
1569: FND_MSG_PUB.add;
1570: ELSE
1571: IF ( p_x_route_rec.warranty_template_name = FND_API.G_MISS_CHAR ) THEN
1572: p_x_route_rec.warranty_template_name := null;

Line 1581: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DUPLICATE_ROUTE_RO' );

1577: --MANESING::VWP Enhancements, 18-Jan-2011, included changes for Duplicate and Return to supply flags
1578: IF ( p_x_route_rec.duplicate_flag IS NULL ) THEN
1579: p_x_route_rec.duplicate_flag := l_old_route_rec.duplicate_flag;
1580: ELSIF ( l_read_only_flag = 'Y' ) THEN
1581: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DUPLICATE_ROUTE_RO' );
1582: FND_MSG_PUB.add;
1583: END IF;
1584:
1585: IF ( p_x_route_rec.return_to_supply_flag IS NULL ) THEN

Line 1588: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RETURN_TO_SUPPLY_RO' );

1584:
1585: IF ( p_x_route_rec.return_to_supply_flag IS NULL ) THEN
1586: p_x_route_rec.return_to_supply_flag := l_old_route_rec.return_to_supply_flag;
1587: ELSIF ( l_read_only_flag = 'Y' ) THEN
1588: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RETURN_TO_SUPPLY_RO' );
1589: FND_MSG_PUB.add;
1590: END IF;
1591:
1592: IF ( p_x_route_rec.qa_inspection_type IS NULL ) THEN

Line 1596: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );

1592: IF ( p_x_route_rec.qa_inspection_type IS NULL ) THEN
1593: p_x_route_rec.qa_inspection_type := l_old_route_rec.qa_inspection_type;
1594: ELSE
1595: IF ( l_read_only_flag = 'Y' ) THEN
1596: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
1597: FND_MSG_PUB.add;
1598: ELSE
1599: IF ( p_x_route_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN
1600: p_x_route_rec.qa_inspection_type := null;

Line 1609: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );

1605: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL ) THEN
1606: p_x_route_rec.qa_inspection_type_desc := l_old_route_rec.qa_inspection_type_desc;
1607: ELSE
1608: IF ( l_read_only_flag = 'Y' ) THEN
1609: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
1610: FND_MSG_PUB.add;
1611: ELSE
1612: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
1613: p_x_route_rec.qa_inspection_type_desc := null;

Line 1861: FND_MESSAGE.set_name( 'AHL','AHL_RM_STATUS_NULL' );

1857: /*
1858: IF ( ( p_route_rec.dml_operation = 'C' AND
1859: p_route_rec.revision_status_code IS NULL ) OR
1860: p_route_rec.revision_status_code = FND_API.G_MISS_CHAR ) THEN
1861: FND_MESSAGE.set_name( 'AHL','AHL_RM_STATUS_NULL' );
1862: FND_MSG_PUB.add;
1863: END IF;
1864: */
1865:

Line 1870: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_NO_NULL' );

1866: -- Check if the Route Number does not column contains a null value.
1867: IF ( ( p_route_rec.dml_operation = 'C' AND
1868: p_route_rec.route_no IS NULL ) OR
1869: p_route_rec.route_no = FND_API.G_MISS_CHAR ) THEN
1870: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_NO_NULL' );
1871: FND_MSG_PUB.add;
1872: END IF;
1873:
1874: -- Check if the Route Title does not column contains a null value.

Line 1878: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_TITLE_NULL' );

1874: -- Check if the Route Title does not column contains a null value.
1875: IF ( ( p_route_rec.dml_operation = 'C' AND
1876: p_route_rec.title IS NULL ) OR
1877: p_route_rec.title = FND_API.G_MISS_CHAR ) THEN
1878: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_TITLE_NULL' );
1879: FND_MSG_PUB.add;
1880: END IF;
1881:
1882: -- Check if the Route Start Date does not column contains a null value.

Line 1886: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_NULL' );

1882: -- Check if the Route Start Date does not column contains a null value.
1883: IF ( ( p_route_rec.dml_operation = 'C' AND
1884: p_route_rec.active_start_date IS NULL ) OR
1885: p_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1886: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_NULL' );
1887: FND_MSG_PUB.add;
1888: END IF;
1889:
1890: --bachandr Enigma Phase I changes -- start

Line 1899: FND_MESSAGE.set_name( 'AHL','AHL_RM_TIME_SPAN_NULL' );

1895: IF l_enigma_avail = 'N' THEN
1896: IF ( ( p_route_rec.dml_operation = 'C' AND
1897: p_route_rec.time_span IS NULL ) OR
1898: p_route_rec.time_span = FND_API.G_MISS_NUM ) THEN
1899: FND_MESSAGE.set_name( 'AHL','AHL_RM_TIME_SPAN_NULL' );
1900: FND_MSG_PUB.add;
1901: END IF;
1902: END IF;
1903:

Line 1910: FND_MESSAGE.set_name( 'AHL','AHL_RM_MODEL_CODE_NULL' );

1906: -- modified by snarkhed since from enigma phase II:: Model code is mandatory for Enigma Routes
1907: IF ( (upper(p_route_rec.enigma_source_code) = 'AUTOMATIC') OR upper(p_route_rec.enigma_source_code) = 'MANUAL') THEN
1908: IF (( p_route_rec.model_code IS NULL OR p_route_rec.model_code = FND_API.G_MISS_CHAR ) AND
1909: ( p_route_rec.model_meaning IS NULL OR p_route_rec.model_meaning = FND_API.G_MISS_CHAR ) )THEN
1910: FND_MESSAGE.set_name( 'AHL','AHL_RM_MODEL_CODE_NULL' );
1911: FND_MSG_PUB.add;
1912: END IF;
1913: END IF;
1914: --bachandr Enigma Phase I changes -- end

Line 1920: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TIME_SPAN' );

1916: -- Check if Time Span is not less than or equal to zero
1917: IF ( p_route_rec.time_span IS NOT NULL AND
1918: p_route_rec.time_span <> FND_API.G_MISS_NUM AND
1919: p_route_rec.time_span <= 0 ) THEN
1920: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TIME_SPAN' );
1921: FND_MESSAGE.set_token( 'FIELD', p_route_rec.time_span );
1922: FND_MSG_PUB.add;
1923: END IF;
1924:

Line 1921: FND_MESSAGE.set_token( 'FIELD', p_route_rec.time_span );

1917: IF ( p_route_rec.time_span IS NOT NULL AND
1918: p_route_rec.time_span <> FND_API.G_MISS_NUM AND
1919: p_route_rec.time_span <= 0 ) THEN
1920: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TIME_SPAN' );
1921: FND_MESSAGE.set_token( 'FIELD', p_route_rec.time_span );
1922: FND_MSG_PUB.add;
1923: END IF;
1924:
1925: IF ( p_route_rec.dml_operation = 'C' ) THEN

Line 1932: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_ID_NULL' );

1928:
1929: -- Check if the mandatory Route ID column contains a null value.
1930: IF ( p_route_rec.route_id IS NULL OR
1931: p_route_rec.route_id = FND_API.G_MISS_NUM ) THEN
1932: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_ID_NULL' );
1933: FND_MSG_PUB.add;
1934: RETURN;
1935: END IF;
1936:

Line 1940: FND_MESSAGE.set_name( 'AHL','AHL_RM_OBJ_VERSION_NULL' );

1936:
1937: -- Check if the mandatory Object Version Number column contains a null value.
1938: IF ( p_route_rec.object_version_number IS NULL OR
1939: p_route_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1940: FND_MESSAGE.set_name( 'AHL','AHL_RM_OBJ_VERSION_NULL' );
1941: FND_MSG_PUB.add;
1942: RETURN;
1943: END IF;
1944:

Line 1964: FND_MESSAGE.set_name( 'AHL', l_msg_data );

1960:
1961: -- Bug # 8639648 - end
1962:
1963: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1964: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1965: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
1966: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );
1967: FND_MSG_PUB.add;
1968: END IF;

Line 1965: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );

1961: -- Bug # 8639648 - end
1962:
1963: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1964: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1965: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
1966: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );
1967: FND_MSG_PUB.add;
1968: END IF;
1969: END IF;

Line 1966: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );

1962:
1963: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1964: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1965: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
1966: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );
1967: FND_MSG_PUB.add;
1968: END IF;
1969: END IF;
1970:

Line 1974: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_STS_NO_UPD' );

1970:
1971: -- Added by Tamal for Bug #3854052
1972: IF (p_route_rec.dml_operation = 'U' AND p_route_rec.revision_status_code IN ('COMPLETE', 'APPROVAL_PENDING', 'TERMINATION_PENDING', 'TERMINATED'))
1973: THEN
1974: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_STS_NO_UPD' );
1975: FND_MSG_PUB.add;
1976: x_return_status := FND_API.G_RET_STS_ERROR;
1977: END IF;
1978: -- Added by Tamal for Bug #3854052

Line 1986: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

1982: OPEN validate_route_ovn;
1983: FETCH validate_route_ovn INTO l_dummy;
1984: IF (validate_route_ovn%NOTFOUND)
1985: THEN
1986: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1987: FND_MSG_PUB.add;
1988: END IF;
1989: END IF;
1990:

Line 2026: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

2022: IF ( p_route_rec.dml_operation = 'C' )
2023: THEN
2024: -- if its create then p_route_rec.route_id = null and any duplicate record should make you throw an err.
2025: IF ( get_dup_rec%FOUND ) THEN
2026: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2027: FND_MSG_PUB.add;
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: END IF;
2030: ELSIF ( p_route_rec.dml_operation = 'U' )

Line 2033: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

2029: END IF;
2030: ELSIF ( p_route_rec.dml_operation = 'U' )
2031: THEN
2032: IF ( l_route_id <> p_route_rec.route_id ) THEN
2033: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2034: FND_MSG_PUB.add;
2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036: END IF;
2037: END IF;

Line 2048: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );

2044: p_route_rec.revision_status_code = 'APPROVAL_REJECTED' ) AND
2045: p_route_rec.active_start_date IS NOT NULL AND
2046: p_route_rec.active_start_date <> FND_API.G_MISS_DATE AND
2047: TRUNC( p_route_rec.active_start_date ) < TRUNC( SYSDATE ) ) THEN
2048: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
2049: FND_MESSAGE.set_token( 'FIELD', SYSDATE );
2050: FND_MSG_PUB.add;
2051: END IF;
2052: */

Line 2049: FND_MESSAGE.set_token( 'FIELD', SYSDATE );

2045: p_route_rec.active_start_date IS NOT NULL AND
2046: p_route_rec.active_start_date <> FND_API.G_MISS_DATE AND
2047: TRUNC( p_route_rec.active_start_date ) < TRUNC( SYSDATE ) ) THEN
2048: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
2049: FND_MESSAGE.set_token( 'FIELD', SYSDATE );
2050: FND_MSG_PUB.add;
2051: END IF;
2052: */
2053: -- Check if Active start date is less than today's date and the start

Line 2071: FND_MESSAGE.set_name( 'AHL', l_msg_data );

2067: x_start_date => l_start_date
2068: );
2069:
2070: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2071: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2072: FND_MESSAGE.set_token( 'FIELD', l_start_date );
2073: FND_MSG_PUB.add;
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: END IF;

Line 2072: FND_MESSAGE.set_token( 'FIELD', l_start_date );

2068: );
2069:
2070: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2071: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2072: FND_MESSAGE.set_token( 'FIELD', l_start_date );
2073: FND_MSG_PUB.add;
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: END IF;
2076: END IF;

Line 2083: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_ZONE_NOTNULL' );

2079: IF ( ( p_route_rec.zone IS NOT NULL OR
2080: p_route_rec.zone_code IS NOT NULL ) AND
2081: ( p_route_rec.product_type IS NULL AND
2082: p_route_rec.product_type_code IS NULL ) ) THEN
2083: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_ZONE_NOTNULL' );
2084: FND_MSG_PUB.add;
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: END IF;
2087:

Line 2095: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_SUBZONE_NOTNULL' );

2091: ( ( p_route_rec.product_type IS NULL AND
2092: p_route_rec.product_type_code IS NULL ) OR
2093: ( p_route_rec.zone IS NULL AND
2094: p_route_rec.zone_code IS NULL ) ) ) THEN
2095: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_SUBZONE_NOTNULL' );
2096: FND_MSG_PUB.add;
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END IF;
2099:

Line 2113: FND_MESSAGE.set_name( 'AHL', l_msg_data );

2109: p_zone_code => p_route_rec.zone_code
2110: );
2111:
2112: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2113: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2114: IF ( p_route_rec.zone IS NULL ) THEN
2115: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );
2116: ELSE
2117: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );

Line 2115: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );

2111:
2112: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2113: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2114: IF ( p_route_rec.zone IS NULL ) THEN
2115: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );
2116: ELSE
2117: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );
2118: END IF;
2119:

Line 2117: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );

2113: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2114: IF ( p_route_rec.zone IS NULL ) THEN
2115: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );
2116: ELSE
2117: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );
2118: END IF;
2119:
2120: IF ( p_route_rec.product_type IS NULL ) THEN
2121: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type_code );

Line 2121: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type_code );

2117: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );
2118: END IF;
2119:
2120: IF ( p_route_rec.product_type IS NULL ) THEN
2121: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type_code );
2122: ELSE
2123: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type );
2124: END IF;
2125:

Line 2123: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type );

2119:
2120: IF ( p_route_rec.product_type IS NULL ) THEN
2121: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type_code );
2122: ELSE
2123: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type );
2124: END IF;
2125:
2126: FND_MSG_PUB.add;
2127: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2146: FND_MESSAGE.set_name( 'AHL', l_msg_data );

2142: p_sub_zone_code => p_route_rec.sub_zone_code
2143: );
2144:
2145: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2146: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2147: IF ( p_route_rec.sub_zone IS NULL ) THEN
2148: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );
2149: ELSE
2150: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );

Line 2148: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );

2144:
2145: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2146: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2147: IF ( p_route_rec.sub_zone IS NULL ) THEN
2148: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );
2149: ELSE
2150: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );
2151: END IF;
2152:

Line 2150: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );

2146: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2147: IF ( p_route_rec.sub_zone IS NULL ) THEN
2148: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );
2149: ELSE
2150: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );
2151: END IF;
2152:
2153: IF ( p_route_rec.zone IS NULL ) THEN
2154: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone_code );

Line 2154: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone_code );

2150: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );
2151: END IF;
2152:
2153: IF ( p_route_rec.zone IS NULL ) THEN
2154: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone_code );
2155: ELSE
2156: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone );
2157: END IF;
2158:

Line 2156: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone );

2152:
2153: IF ( p_route_rec.zone IS NULL ) THEN
2154: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone_code );
2155: ELSE
2156: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone );
2157: END IF;
2158:
2159: IF ( p_route_rec.product_type IS NULL ) THEN
2160: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type_code );

Line 2160: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type_code );

2156: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone );
2157: END IF;
2158:
2159: IF ( p_route_rec.product_type IS NULL ) THEN
2160: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type_code );
2161: ELSE
2162: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type );
2163: END IF;
2164:

Line 2162: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type );

2158:
2159: IF ( p_route_rec.product_type IS NULL ) THEN
2160: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type_code );
2161: ELSE
2162: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type );
2163: END IF;
2164:
2165: FND_MSG_PUB.add;
2166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2603: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

2599: X_SUMMARY_FLAG => 'N'
2600: );
2601: EXCEPTION
2602: WHEN NO_DATA_FOUND THEN
2603: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2604: FND_MSG_PUB.add;
2605: WHEN OTHERS THEN
2606: IF ( SQLCODE = -1 ) THEN
2607: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

Line 2607: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

2603: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2604: FND_MSG_PUB.add;
2605: WHEN OTHERS THEN
2606: IF ( SQLCODE = -1 ) THEN
2607: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2608: FND_MSG_PUB.add;
2609: ELSE
2610: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string

Line 2708: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

2704: );
2705:
2706: EXCEPTION
2707: WHEN NO_DATA_FOUND THEN
2708: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2709: FND_MSG_PUB.add;
2710: WHEN OTHERS THEN
2711: IF ( SQLCODE = -1 ) THEN
2712: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

Line 2712: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

2708: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2709: FND_MSG_PUB.add;
2710: WHEN OTHERS THEN
2711: IF ( SQLCODE = -1 ) THEN
2712: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2713: FND_MSG_PUB.add;
2714: ELSE
2715: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2716: fnd_log.string

Line 2737: FND_MESSAGE.set_name('AHL', 'AHL_RM_INV_SYS_KFV');

2733: OPEN validate_system_kfv(p_x_route_rec.route_no, l_concat_segs);
2734: FETCH validate_system_kfv INTO l_kfv_flag;
2735: IF (validate_system_kfv%FOUND)
2736: THEN
2737: FND_MESSAGE.set_name('AHL', 'AHL_RM_INV_SYS_KFV');
2738: FND_MSG_PUB.add;
2739: END IF;
2740: CLOSE validate_system_kfv;
2741: END IF;

Line 2938: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

2934: IF ( p_route_id IS NULL OR
2935: p_route_id = FND_API.G_MISS_NUM OR
2936: p_object_version_number IS NULL OR
2937: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2938: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2939: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );
2940: FND_MSG_PUB.add;
2941: RAISE FND_API.G_EXC_ERROR;
2942: END IF;

Line 2939: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );

2935: p_route_id = FND_API.G_MISS_NUM OR
2936: p_object_version_number IS NULL OR
2937: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2938: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2939: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );
2940: FND_MSG_PUB.add;
2941: RAISE FND_API.G_EXC_ERROR;
2942: END IF;
2943:

Line 2948: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

2944: OPEN validate_route_ovn;
2945: FETCH validate_route_ovn INTO l_dummy;
2946: IF (validate_route_ovn%NOTFOUND)
2947: THEN
2948: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
2949: FND_MSG_PUB.add;
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: RAISE FND_API.G_EXC_ERROR;
2952: END IF;

Line 2971: FND_MESSAGE.set_name('AHL', 'AHL_RM_ROUTE_ENIG_DEL');

2967: THEN
2968: IF G_DEBUG = 'Y' THEN
2969: AHL_DEBUG_PUB.debug( 'Enigma Route Id IS NOT NULL');
2970: END IF;
2971: FND_MESSAGE.set_name('AHL', 'AHL_RM_ROUTE_ENIG_DEL');
2972: FND_MSG_PUB.add;
2973: x_return_status := FND_API.G_RET_STS_ERROR;
2974: RAISE FND_API.G_EXC_ERROR;
2975: END IF;

Line 2990: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_DRAFT' );

2986: );
2987:
2988: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2989: IF ( l_msg_data = 'AHL_RM_INVALID_ROUTE_STATUS' ) THEN
2990: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_DRAFT' );
2991: ELSE
2992: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2993: END IF;
2994:

Line 2992: FND_MESSAGE.set_name( 'AHL', l_msg_data );

2988: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2989: IF ( l_msg_data = 'AHL_RM_INVALID_ROUTE_STATUS' ) THEN
2990: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_DRAFT' );
2991: ELSE
2992: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2993: END IF;
2994:
2995: FND_MSG_PUB.add;
2996: RAISE FND_API.G_EXC_ERROR;

Line 3096: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

3092: );
3093:
3094: EXCEPTION
3095: WHEN NO_DATA_FOUND THEN
3096: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
3097: FND_MSG_PUB.add;
3098: RAISE FND_API.G_EXC_ERROR;
3099: WHEN OTHERS THEN
3100: RAISE;

Line 3456: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

3452: IF ( p_route_id IS NULL OR
3453: p_route_id = FND_API.G_MISS_NUM OR
3454: p_object_version_number IS NULL OR
3455: p_object_version_number = FND_API.G_MISS_NUM ) THEN
3456: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
3457: FND_MSG_PUB.add;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460:

Line 3471: FND_MESSAGE.set_name( 'AHL', l_msg_data );

3467: p_x_route_rec => l_old_route_rec
3468: );
3469:
3470: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
3471: FND_MESSAGE.set_name( 'AHL', l_msg_data );
3472: FND_MSG_PUB.add;
3473: RAISE FND_API.G_EXC_ERROR;
3474: END IF;
3475:

Line 3478: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_COMPLETE' );

3474: END IF;
3475:
3476: -- Check if the Status is COMPLETE
3477: IF ( l_old_route_rec.revision_status_code <> 'COMPLETE' ) THEN
3478: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_COMPLETE' );
3479: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3480: FND_MSG_PUB.add;
3481: RAISE FND_API.G_EXC_ERROR;
3482: END IF;

Line 3479: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );

3475:
3476: -- Check if the Status is COMPLETE
3477: IF ( l_old_route_rec.revision_status_code <> 'COMPLETE' ) THEN
3478: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_COMPLETE' );
3479: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3480: FND_MSG_PUB.add;
3481: RAISE FND_API.G_EXC_ERROR;
3482: END IF;
3483:

Line 3486: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );

3482: END IF;
3483:
3484: -- Check if this revision is not Terminated
3485: IF ( l_old_route_rec.active_end_date IS NOT NULL ) THEN
3486: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
3487: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3488: FND_MSG_PUB.add;
3489: RAISE FND_API.G_EXC_ERROR;
3490: END IF;

Line 3487: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );

3483:
3484: -- Check if this revision is not Terminated
3485: IF ( l_old_route_rec.active_end_date IS NOT NULL ) THEN
3486: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
3487: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3488: FND_MSG_PUB.add;
3489: RAISE FND_API.G_EXC_ERROR;
3490: END IF;
3491:

Line 3499: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_REVISION_NOT_LATEST' );

3495: FETCH get_latest_revision INTO
3496: l_revision_number;
3497:
3498: IF ( l_revision_number <> l_old_route_rec.revision_number ) THEN
3499: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_REVISION_NOT_LATEST' );
3500: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3501: FND_MSG_PUB.add;
3502: CLOSE get_latest_revision;
3503: RAISE FND_API.G_EXC_ERROR;

Line 3500: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );

3496: l_revision_number;
3497:
3498: IF ( l_revision_number <> l_old_route_rec.revision_number ) THEN
3499: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_REVISION_NOT_LATEST' );
3500: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3501: FND_MSG_PUB.add;
3502: CLOSE get_latest_revision;
3503: RAISE FND_API.G_EXC_ERROR;
3504: END IF;

Line 3610: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

3606: );
3607:
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
3611: FND_MSG_PUB.add;
3612: WHEN OTHERS THEN
3613: IF ( SQLCODE = -1 ) THEN
3614: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

Line 3614: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

3610: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
3611: FND_MSG_PUB.add;
3612: WHEN OTHERS THEN
3613: IF ( SQLCODE = -1 ) THEN
3614: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
3615: FND_MSG_PUB.add;
3616: ELSE
3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3618: fnd_log.string