DBA Data[Home] [Help]

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 165: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );

161: );
162:
163: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
164: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
165: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );
166: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
167: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );
168: ELSE
169: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

163: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
164: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
165: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );
166: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
167: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );
168: ELSE
169: FND_MESSAGE.set_name( 'AHL', l_msg_data );
170: END IF;
171:

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

165: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ROUTE_TYPE' );
166: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
167: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ROUTE_TYPES' );
168: ELSE
169: FND_MESSAGE.set_name( 'AHL', l_msg_data );
170: END IF;
171:
172: IF ( p_x_route_rec.route_type IS NULL OR
173: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN

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

170: END IF;
171:
172: IF ( p_x_route_rec.route_type IS NULL OR
173: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
174: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type_code );
175: ELSE
176: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type );
177: END IF;
178:

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

172: IF ( p_x_route_rec.route_type IS NULL OR
173: p_x_route_rec.route_type = FND_API.G_MISS_CHAR ) THEN
174: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type_code );
175: ELSE
176: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.route_type );
177: END IF;
178:
179: FND_MSG_PUB.add;
180: END IF;

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

198: );
199:
200: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
201: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
202: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
203: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
204: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
205: ELSE
206: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

200: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
201: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
202: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
203: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
204: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
205: ELSE
206: FND_MESSAGE.set_name( 'AHL', l_msg_data );
207: END IF;
208:

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

202: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
203: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
204: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
205: ELSE
206: FND_MESSAGE.set_name( 'AHL', l_msg_data );
207: END IF;
208:
209: IF ( p_x_route_rec.model_meaning IS NULL OR
210: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

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

207: END IF;
208:
209: IF ( p_x_route_rec.model_meaning IS NULL OR
210: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
211: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_code );
212: ELSE
213: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_meaning );
214: END IF;
215:

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

209: IF ( p_x_route_rec.model_meaning IS NULL OR
210: p_x_route_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
211: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_code );
212: ELSE
213: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.model_meaning );
214: END IF;
215:
216: FND_MSG_PUB.add;
217: END IF;

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

235: );
236:
237: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
238: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
239: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
240: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
241: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
242: ELSE
243: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

237: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
238: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
239: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
240: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
241: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
242: ELSE
243: FND_MESSAGE.set_name( 'AHL', l_msg_data );
244: END IF;
245:

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

239: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
240: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
241: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
242: ELSE
243: FND_MESSAGE.set_name( 'AHL', l_msg_data );
244: END IF;
245:
246: IF ( p_x_route_rec.process IS NULL OR
247: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN

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

244: END IF;
245:
246: IF ( p_x_route_rec.process IS NULL OR
247: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
248: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process_code );
249: ELSE
250: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process );
251: END IF;
252:

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

246: IF ( p_x_route_rec.process IS NULL OR
247: p_x_route_rec.process = FND_API.G_MISS_CHAR ) THEN
248: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process_code );
249: ELSE
250: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.process );
251: END IF;
252:
253: FND_MSG_PUB.add;
254: END IF;

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

271: );
272:
273: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
274: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
275: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );
276: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
277: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );
278: ELSE
279: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

273: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
274: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
275: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );
276: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
277: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );
278: ELSE
279: FND_MESSAGE.set_name( 'AHL', l_msg_data );
280: END IF;
281:

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

275: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PRODUCT_TYPE' );
276: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
277: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PRODUCT_TYPES' );
278: ELSE
279: FND_MESSAGE.set_name( 'AHL', l_msg_data );
280: END IF;
281:
282: IF ( p_x_route_rec.product_type IS NULL OR
283: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN

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

280: END IF;
281:
282: IF ( p_x_route_rec.product_type IS NULL OR
283: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
284: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type_code );
285: ELSE
286: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type );
287: END IF;
288:

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

282: IF ( p_x_route_rec.product_type IS NULL OR
283: p_x_route_rec.product_type = FND_API.G_MISS_CHAR ) THEN
284: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type_code );
285: ELSE
286: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.product_type );
287: END IF;
288:
289: FND_MSG_PUB.add;
290: END IF;

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

305: p_x_operator_party_id => p_x_route_rec.operator_party_id
306: );
307:
308: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
309: FND_MESSAGE.set_name( 'AHL', l_msg_data );
310:
311: IF ( p_x_route_rec.operator_name IS NULL OR
312: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
313: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );

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

309: FND_MESSAGE.set_name( 'AHL', l_msg_data );
310:
311: IF ( p_x_route_rec.operator_name IS NULL OR
312: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
313: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );
314: ELSE
315: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.operator_name );
316: END IF;
317:

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

311: IF ( p_x_route_rec.operator_name IS NULL OR
312: p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
313: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.operator_party_id ) );
314: ELSE
315: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.operator_name );
316: END IF;
317:
318: FND_MSG_PUB.add;
319: END IF;

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

336: );
337:
338: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
339: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
340: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );
341: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );
343: ELSE
344: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

338: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
339: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
340: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );
341: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );
343: ELSE
344: FND_MESSAGE.set_name( 'AHL', l_msg_data );
345: END IF;
346:

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

340: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ZONE' );
341: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
342: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ZONES' );
343: ELSE
344: FND_MESSAGE.set_name( 'AHL', l_msg_data );
345: END IF;
346:
347: IF ( p_x_route_rec.zone IS NULL OR
348: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN

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

345: END IF;
346:
347: IF ( p_x_route_rec.zone IS NULL OR
348: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
349: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone_code );
350: ELSE
351: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone );
352: END IF;
353:

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

347: IF ( p_x_route_rec.zone IS NULL OR
348: p_x_route_rec.zone = FND_API.G_MISS_CHAR ) THEN
349: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone_code );
350: ELSE
351: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.zone );
352: END IF;
353:
354: FND_MSG_PUB.add;
355: END IF;

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

372: );
373:
374: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
375: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
376: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );
377: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
378: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );
379: ELSE
380: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

374: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
375: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
376: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );
377: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
378: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );
379: ELSE
380: FND_MESSAGE.set_name( 'AHL', l_msg_data );
381: END IF;
382:

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

376: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_SUB_ZONE' );
377: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
378: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_SUB_ZONES' );
379: ELSE
380: FND_MESSAGE.set_name( 'AHL', l_msg_data );
381: END IF;
382:
383: IF ( p_x_route_rec.sub_zone IS NULL OR
384: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN

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

381: END IF;
382:
383: IF ( p_x_route_rec.sub_zone IS NULL OR
384: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
385: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone_code );
386: ELSE
387: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone );
388: END IF;
389:

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

383: IF ( p_x_route_rec.sub_zone IS NULL OR
384: p_x_route_rec.sub_zone = FND_API.G_MISS_CHAR ) THEN
385: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone_code );
386: ELSE
387: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.sub_zone );
388: END IF;
389:
390: FND_MSG_PUB.add;
391: END IF;

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

409: p_x_inventory_org_id => p_x_route_rec.service_item_org_id
410: );
411:
412: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
413: FND_MESSAGE.set_name( 'AHL', l_msg_data );
414:
415: IF ( p_x_route_rec.service_item_number IS NULL OR
416: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
417: 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 417: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );

413: FND_MESSAGE.set_name( 'AHL', l_msg_data );
414:
415: IF ( p_x_route_rec.service_item_number IS NULL OR
416: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
417: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );
418: ELSE
419: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.service_item_number );
420: END IF;
421:

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

415: IF ( p_x_route_rec.service_item_number IS NULL OR
416: p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
417: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.service_item_id ) || TO_CHAR( p_x_route_rec.service_item_org_id ) );
418: ELSE
419: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.service_item_number );
420: END IF;
421:
422: FND_MSG_PUB.add;
423: END IF;

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

441: p_x_accounting_class_org_id => p_x_route_rec.accounting_class_org_id
442: );
443:
444: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
445: FND_MESSAGE.set_name( 'AHL', l_msg_data );
446:
447: IF ( p_x_route_rec.accounting_class IS NULL OR
448: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
449: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );

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

445: FND_MESSAGE.set_name( 'AHL', l_msg_data );
446:
447: IF ( p_x_route_rec.accounting_class IS NULL OR
448: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
449: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );
450: ELSE
451: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class );
452: END IF;
453:

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

447: IF ( p_x_route_rec.accounting_class IS NULL OR
448: p_x_route_rec.accounting_class = FND_API.G_MISS_CHAR ) THEN
449: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class_code || '-' || TO_CHAR( p_x_route_rec.accounting_class_org_id ) );
450: ELSE
451: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.accounting_class );
452: END IF;
453:
454: FND_MSG_PUB.add;
455: END IF;

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

470: p_x_task_template_group_id => p_x_route_rec.task_template_group_id
471: );
472:
473: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
474: FND_MESSAGE.set_name( 'AHL', l_msg_data );
475:
476: IF ( p_x_route_rec.task_template_group IS NULL OR
477: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
478: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );

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

474: FND_MESSAGE.set_name( 'AHL', l_msg_data );
475:
476: IF ( p_x_route_rec.task_template_group IS NULL OR
477: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
478: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );
479: ELSE
480: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.task_template_group );
481: END IF;
482:

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

476: IF ( p_x_route_rec.task_template_group IS NULL OR
477: p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
478: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_rec.task_template_group_id ) );
479: ELSE
480: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.task_template_group );
481: END IF;
482:
483: FND_MSG_PUB.add;
484: END IF;

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

499: p_x_qa_inspection_type => p_x_route_rec.qa_inspection_type
500: );
501:
502: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
503: FND_MESSAGE.set_name( 'AHL', l_msg_data );
504:
505: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
506: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
507: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );

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

503: FND_MESSAGE.set_name( 'AHL', l_msg_data );
504:
505: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
506: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
507: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );
508: ELSE
509: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type_desc );
510: END IF;
511:

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

505: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL OR
506: p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
507: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type );
508: ELSE
509: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.qa_inspection_type_desc );
510: END IF;
511:
512: FND_MSG_PUB.add;
513: END IF;

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

530: );
531:
532: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
533: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
534: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
535: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
536: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
537: ELSE
538: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

532: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
533: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
534: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
535: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
536: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
537: ELSE
538: FND_MESSAGE.set_name( 'AHL', l_msg_data );
539: END IF;
540:

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

534: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
535: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
536: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
537: ELSE
538: FND_MESSAGE.set_name( 'AHL', l_msg_data );
539: END IF;
540:
541: IF ( p_x_route_rec.revision_status IS NULL OR
542: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN

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

539: END IF;
540:
541: IF ( p_x_route_rec.revision_status IS NULL OR
542: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
543: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status_code );
544: ELSE
545: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status );
546: END IF;
547:

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

541: IF ( p_x_route_rec.revision_status IS NULL OR
542: p_x_route_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
543: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status_code );
544: ELSE
545: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.revision_status );
546: END IF;
547:
548: FND_MSG_PUB.add;
549: END IF;

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

567: );
568:
569: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
570: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
571: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );
572: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
573: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );
574: ELSE
575: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

569: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
570: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
571: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );
572: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
573: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );
574: ELSE
575: FND_MESSAGE.set_name( 'AHL', l_msg_data );
576: END IF;
577:

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

571: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UNIT_RECEIPT' );
572: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
573: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_UNIT_RECEIPTS' );
574: ELSE
575: FND_MESSAGE.set_name( 'AHL', l_msg_data );
576: END IF;
577:
578: IF ( p_x_route_rec.unit_receipt_update IS NULL OR
579: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN

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

576: END IF;
577:
578: IF ( p_x_route_rec.unit_receipt_update IS NULL OR
579: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN
580: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update_flag );
581: ELSE
582: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update );
583: END IF;
584: FND_MSG_PUB.add;

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

578: IF ( p_x_route_rec.unit_receipt_update IS NULL OR
579: p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN
580: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update_flag );
581: ELSE
582: FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update );
583: END IF;
584: FND_MSG_PUB.add;
585: END IF;
586:

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

1073: p_x_route_rec => l_old_route_rec
1074: );
1075:
1076: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1077: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1078: FND_MSG_PUB.add;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081:

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

1087: p_x_route_rec.revision_status_code := 'DRAFT';
1088: END IF;
1089: -- Condition added in 11.5.10.
1090: ELSIF p_x_route_rec.revision_status_code <> l_old_route_rec.revision_status_code THEN
1091: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
1092: FND_MSG_PUB.add;
1093: END IF;
1094:
1095: IF ( p_x_route_rec.revision_status IS NULL ) THEN

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

1094:
1095: IF ( p_x_route_rec.revision_status IS NULL ) THEN
1096: p_x_route_rec.revision_status := l_old_route_rec.revision_status;
1097: ELSIF p_x_route_rec.revision_status <> l_old_route_rec.revision_status THEN
1098: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
1099: FND_MSG_PUB.add;
1100: END IF;
1101:
1102: --bachandr Enigma Phase I changes -- start

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

1105: -- If it is not null and it does not match with the value in the DB then throw an error
1106: IF ( l_old_route_rec.enigma_doc_id IS NOT NULL AND p_x_route_rec.model_code IS NULL ) THEN
1107: p_x_route_rec.model_code := l_old_route_rec.model_code;
1108: ELSIF ( l_old_route_rec.enigma_doc_id IS NOT NULL AND p_x_route_rec.model_code <> l_old_route_rec.model_code ) THEN
1109: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_RO' );
1110: FND_MSG_PUB.add;
1111: END IF;
1112:
1113: -- Do the following only when the route is created from Enigma

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

1115: -- If it is not null / Enigma Route it does not match with the value in the DB then throw an error
1116: IF ( l_old_route_rec.enigma_doc_id IS NOT NULL AND p_x_route_rec.model_meaning IS NULL ) THEN
1117: p_x_route_rec.model_meaning := l_old_route_rec.model_meaning;
1118: ELSIF ( l_old_route_rec.enigma_doc_id IS NOT NULL AND p_x_route_rec.model_meaning <> l_old_route_rec.model_meaning ) THEN
1119: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_RO' );
1120: FND_MSG_PUB.add;
1121: END IF;
1122:
1123:

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

1130:
1131: IF ( p_x_route_rec.revision_number IS NULL ) THEN
1132: p_x_route_rec.revision_number := l_old_route_rec.revision_number;
1133: ELSIF p_x_route_rec.revision_number <> l_old_route_rec.revision_number THEN
1134: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_REVISION_RO' );
1135: FND_MSG_PUB.add;
1136: END IF;
1137:
1138: IF ( p_x_route_rec.route_no IS NULL ) THEN

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

1137:
1138: IF ( p_x_route_rec.route_no IS NULL ) THEN
1139: p_x_route_rec.route_no := l_old_route_rec.route_no;
1140: ELSIF p_x_route_rec.route_no <> l_old_route_rec.route_no THEN
1141: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_RO' );
1142: FND_MSG_PUB.add;
1143: END IF;
1144:
1145: IF ( p_x_route_rec.revision_status_code = 'DRAFT' ) THEN

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

1151: IF ( p_x_route_rec.title IS NULL ) THEN
1152: p_x_route_rec.title := l_old_route_rec.title;
1153: ELSE
1154: IF ( l_read_only_flag = 'Y' ) THEN
1155: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TITLE_RO' );
1156: FND_MSG_PUB.add;
1157: END IF;
1158: END IF;
1159:

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

1160: IF ( p_x_route_rec.active_start_date IS NULL ) THEN
1161: p_x_route_rec.active_start_date := l_old_route_rec.active_start_date;
1162: ELSE
1163: IF ( l_read_only_flag = 'Y' ) THEN
1164: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ST_DATE_RO' );
1165: FND_MSG_PUB.add;
1166: ELSIF ( p_x_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1167: p_x_route_rec.active_start_date := NULL;
1168: END IF;

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

1171: IF ( p_x_route_rec.active_end_date IS NULL ) THEN
1172: p_x_route_rec.active_end_date := l_old_route_rec.active_end_date;
1173: ELSE
1174: IF ( l_read_only_flag = 'Y' ) THEN
1175: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_RO' );
1176: FND_MSG_PUB.add;
1177: END IF;
1178: END IF;
1179:

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

1240: IF ( p_x_route_rec.operator_party_id IS NULL ) THEN
1241: p_x_route_rec.operator_party_id := l_old_route_rec.operator_party_id;
1242: ELSE
1243: IF ( l_read_only_flag = 'Y' ) THEN
1244: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );
1245: FND_MSG_PUB.add;
1246: ELSE
1247: IF ( p_x_route_rec.operator_party_id = FND_API.G_MISS_NUM ) THEN
1248: p_x_route_rec.operator_party_id := null;

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

1253: IF ( p_x_route_rec.operator_name IS NULL ) THEN
1254: p_x_route_rec.operator_name := l_old_route_rec.operator_name;
1255: ELSE
1256: IF ( l_read_only_flag = 'Y' ) THEN
1257: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_OPERATOR_RO' );
1258: FND_MSG_PUB.add;
1259: ELSE
1260: IF ( p_x_route_rec.operator_name = FND_API.G_MISS_CHAR ) THEN
1261: p_x_route_rec.operator_name := null;

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

1290: IF ( p_x_route_rec.service_item_id IS NULL ) THEN
1291: p_x_route_rec.service_item_id := l_old_route_rec.service_item_id;
1292: ELSE
1293: IF ( l_read_only_flag = 'Y' ) THEN
1294: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1295: FND_MSG_PUB.add;
1296: ELSE
1297: IF ( p_x_route_rec.service_item_id = FND_API.G_MISS_NUM ) THEN
1298: p_x_route_rec.service_item_id := null;

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

1303: IF ( p_x_route_rec.service_item_org_id IS NULL ) THEN
1304: p_x_route_rec.service_item_org_id := l_old_route_rec.service_item_org_id;
1305: ELSE
1306: IF ( l_read_only_flag = 'Y' ) THEN
1307: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1308: FND_MSG_PUB.add;
1309: ELSE
1310: IF ( p_x_route_rec.service_item_org_id = FND_API.G_MISS_NUM ) THEN
1311: p_x_route_rec.service_item_org_id := null;

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

1316: IF ( p_x_route_rec.service_item_number IS NULL ) THEN
1317: p_x_route_rec.service_item_number := l_old_route_rec.service_item_number;
1318: ELSE
1319: IF ( l_read_only_flag = 'Y' ) THEN
1320: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_SVC_ITEM_RO' );
1321: FND_MSG_PUB.add;
1322: ELSE
1323: IF ( p_x_route_rec.service_item_number = FND_API.G_MISS_CHAR ) THEN
1324: p_x_route_rec.service_item_number := null;

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

1347: IF ( p_x_route_rec.task_template_group_id IS NULL ) THEN
1348: p_x_route_rec.task_template_group_id := l_old_route_rec.task_template_group_id;
1349: ELSE
1350: IF ( l_read_only_flag = 'Y' ) THEN
1351: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );
1352: FND_MSG_PUB.add;
1353: ELSE
1354: IF ( p_x_route_rec.task_template_group_id = FND_API.G_MISS_NUM ) THEN
1355: p_x_route_rec.task_template_group_id := null;

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

1360: IF ( p_x_route_rec.task_template_group IS NULL ) THEN
1361: p_x_route_rec.task_template_group := l_old_route_rec.task_template_group;
1362: ELSE
1363: IF ( l_read_only_flag = 'Y' ) THEN
1364: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_TASK_TEMP_RO' );
1365: FND_MSG_PUB.add;
1366: ELSE
1367: IF ( p_x_route_rec.task_template_group = FND_API.G_MISS_CHAR ) THEN
1368: p_x_route_rec.task_template_group := null;

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

1373: IF ( p_x_route_rec.qa_inspection_type IS NULL ) THEN
1374: p_x_route_rec.qa_inspection_type := l_old_route_rec.qa_inspection_type;
1375: ELSE
1376: IF ( l_read_only_flag = 'Y' ) THEN
1377: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
1378: FND_MSG_PUB.add;
1379: ELSE
1380: IF ( p_x_route_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN
1381: p_x_route_rec.qa_inspection_type := null;

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

1386: IF ( p_x_route_rec.qa_inspection_type_desc IS NULL ) THEN
1387: p_x_route_rec.qa_inspection_type_desc := l_old_route_rec.qa_inspection_type_desc;
1388: ELSE
1389: IF ( l_read_only_flag = 'Y' ) THEN
1390: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
1391: FND_MSG_PUB.add;
1392: ELSE
1393: IF ( p_x_route_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
1394: p_x_route_rec.qa_inspection_type_desc := null;

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

1638: /*
1639: IF ( ( p_route_rec.dml_operation = 'C' AND
1640: p_route_rec.revision_status_code IS NULL ) OR
1641: p_route_rec.revision_status_code = FND_API.G_MISS_CHAR ) THEN
1642: FND_MESSAGE.set_name( 'AHL','AHL_RM_STATUS_NULL' );
1643: FND_MSG_PUB.add;
1644: END IF;
1645: */
1646:

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

1647: -- Check if the Route Number does not column contains a null value.
1648: IF ( ( p_route_rec.dml_operation = 'C' AND
1649: p_route_rec.route_no IS NULL ) OR
1650: p_route_rec.route_no = FND_API.G_MISS_CHAR ) THEN
1651: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_NO_NULL' );
1652: FND_MSG_PUB.add;
1653: END IF;
1654:
1655: -- Check if the Route Title does not column contains a null value.

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

1655: -- Check if the Route Title does not column contains a null value.
1656: IF ( ( p_route_rec.dml_operation = 'C' AND
1657: p_route_rec.title IS NULL ) OR
1658: p_route_rec.title = FND_API.G_MISS_CHAR ) THEN
1659: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_TITLE_NULL' );
1660: FND_MSG_PUB.add;
1661: END IF;
1662:
1663: -- Check if the Route Start Date does not column contains a null value.

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

1663: -- Check if the Route Start Date does not column contains a null value.
1664: IF ( ( p_route_rec.dml_operation = 'C' AND
1665: p_route_rec.active_start_date IS NULL ) OR
1666: p_route_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1667: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_NULL' );
1668: FND_MSG_PUB.add;
1669: END IF;
1670:
1671: --bachandr Enigma Phase I changes -- start

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

1676: IF l_enigma_avail = 'N' THEN
1677: IF ( ( p_route_rec.dml_operation = 'C' AND
1678: p_route_rec.time_span IS NULL ) OR
1679: p_route_rec.time_span = FND_API.G_MISS_NUM ) THEN
1680: FND_MESSAGE.set_name( 'AHL','AHL_RM_TIME_SPAN_NULL' );
1681: FND_MSG_PUB.add;
1682: END IF;
1683: END IF;
1684:

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

1687: IF ( p_route_rec.dml_operation = 'C' AND p_route_rec.enigma_doc_id IS NOT NULL
1688: AND p_route_rec.enigma_doc_id <> FND_API.G_MISS_CHAR) THEN
1689: IF (( p_route_rec.model_code IS NULL OR p_route_rec.model_code = FND_API.G_MISS_CHAR ) AND
1690: ( p_route_rec.model_meaning IS NULL OR p_route_rec.model_meaning = FND_API.G_MISS_CHAR ) )THEN
1691: FND_MESSAGE.set_name( 'AHL','AHL_RM_MODEL_CODE_NULL' );
1692: FND_MSG_PUB.add;
1693: END IF;
1694: END IF;
1695: --bachandr Enigma Phase I changes -- end

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

1697: -- Check if Time Span is not less than or equal to zero
1698: IF ( p_route_rec.time_span IS NOT NULL AND
1699: p_route_rec.time_span <> FND_API.G_MISS_NUM AND
1700: p_route_rec.time_span <= 0 ) THEN
1701: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TIME_SPAN' );
1702: FND_MESSAGE.set_token( 'FIELD', p_route_rec.time_span );
1703: FND_MSG_PUB.add;
1704: END IF;
1705:

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

1698: IF ( p_route_rec.time_span IS NOT NULL AND
1699: p_route_rec.time_span <> FND_API.G_MISS_NUM AND
1700: p_route_rec.time_span <= 0 ) THEN
1701: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_TIME_SPAN' );
1702: FND_MESSAGE.set_token( 'FIELD', p_route_rec.time_span );
1703: FND_MSG_PUB.add;
1704: END IF;
1705:
1706: IF ( p_route_rec.dml_operation = 'C' ) THEN

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

1709:
1710: -- Check if the mandatory Route ID column contains a null value.
1711: IF ( p_route_rec.route_id IS NULL OR
1712: p_route_rec.route_id = FND_API.G_MISS_NUM ) THEN
1713: FND_MESSAGE.set_name( 'AHL','AHL_RM_ROUTE_ID_NULL' );
1714: FND_MSG_PUB.add;
1715: RETURN;
1716: END IF;
1717:

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

1717:
1718: -- Check if the mandatory Object Version Number column contains a null value.
1719: IF ( p_route_rec.object_version_number IS NULL OR
1720: p_route_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1721: FND_MESSAGE.set_name( 'AHL','AHL_RM_OBJ_VERSION_NULL' );
1722: FND_MSG_PUB.add;
1723: RETURN;
1724: END IF;
1725:

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

1737: x_res_max_duration => l_res_max_duration
1738: );
1739:
1740: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1741: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1742: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
1743: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );
1744: FND_MSG_PUB.add;
1745: END IF;

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

1738: );
1739:
1740: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1741: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1742: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
1743: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );
1744: FND_MSG_PUB.add;
1745: END IF;
1746: END IF;

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

1739:
1740: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1741: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1742: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
1743: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.time_span );
1744: FND_MSG_PUB.add;
1745: END IF;
1746: END IF;
1747:

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

1747:
1748: -- Added by Tamal for Bug #3854052
1749: IF (p_route_rec.dml_operation = 'U' AND p_route_rec.revision_status_code IN ('COMPLETE', 'APPROVAL_PENDING', 'TERMINATION_PENDING', 'TERMINATED'))
1750: THEN
1751: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_STS_NO_UPD' );
1752: FND_MSG_PUB.add;
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: END IF;
1755: -- Added by Tamal for Bug #3854052

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

1759: OPEN validate_route_ovn;
1760: FETCH validate_route_ovn INTO l_dummy;
1761: IF (validate_route_ovn%NOTFOUND)
1762: THEN
1763: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1764: FND_MSG_PUB.add;
1765: END IF;
1766: END IF;
1767:

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

1799: IF ( p_route_rec.dml_operation = 'C' )
1800: THEN
1801: -- if its create then p_route_rec.route_id = null and any duplicate record should make you throw an err.
1802: IF ( get_dup_rec%FOUND ) THEN
1803: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
1804: FND_MSG_PUB.add;
1805: x_return_status := FND_API.G_RET_STS_ERROR;
1806: END IF;
1807: ELSIF ( p_route_rec.dml_operation = 'U' )

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

1806: END IF;
1807: ELSIF ( p_route_rec.dml_operation = 'U' )
1808: THEN
1809: IF ( l_route_id <> p_route_rec.route_id ) THEN
1810: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
1811: FND_MSG_PUB.add;
1812: x_return_status := FND_API.G_RET_STS_ERROR;
1813: END IF;
1814: END IF;

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

1821: p_route_rec.revision_status_code = 'APPROVAL_REJECTED' ) AND
1822: p_route_rec.active_start_date IS NOT NULL AND
1823: p_route_rec.active_start_date <> FND_API.G_MISS_DATE AND
1824: TRUNC( p_route_rec.active_start_date ) < TRUNC( SYSDATE ) ) THEN
1825: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
1826: FND_MESSAGE.set_token( 'FIELD', SYSDATE );
1827: FND_MSG_PUB.add;
1828: END IF;
1829: */

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

1822: p_route_rec.active_start_date IS NOT NULL AND
1823: p_route_rec.active_start_date <> FND_API.G_MISS_DATE AND
1824: TRUNC( p_route_rec.active_start_date ) < TRUNC( SYSDATE ) ) THEN
1825: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
1826: FND_MESSAGE.set_token( 'FIELD', SYSDATE );
1827: FND_MSG_PUB.add;
1828: END IF;
1829: */
1830: -- Check if Active start date is less than today's date and the start

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

1844: x_start_date => l_start_date
1845: );
1846:
1847: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1848: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1849: FND_MESSAGE.set_token( 'FIELD', l_start_date );
1850: FND_MSG_PUB.add;
1851: x_return_status := FND_API.G_RET_STS_ERROR;
1852: END IF;

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

1845: );
1846:
1847: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1848: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1849: FND_MESSAGE.set_token( 'FIELD', l_start_date );
1850: FND_MSG_PUB.add;
1851: x_return_status := FND_API.G_RET_STS_ERROR;
1852: END IF;
1853: END IF;

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

1856: IF ( ( p_route_rec.zone IS NOT NULL OR
1857: p_route_rec.zone_code IS NOT NULL ) AND
1858: ( p_route_rec.product_type IS NULL AND
1859: p_route_rec.product_type_code IS NULL ) ) THEN
1860: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_ZONE_NOTNULL' );
1861: FND_MSG_PUB.add;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END IF;
1864:

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

1868: ( ( p_route_rec.product_type IS NULL AND
1869: p_route_rec.product_type_code IS NULL ) OR
1870: ( p_route_rec.zone IS NULL AND
1871: p_route_rec.zone_code IS NULL ) ) ) THEN
1872: FND_MESSAGE.set_name( 'AHL','AHL_RM_PT_NULL_SUBZONE_NOTNULL' );
1873: FND_MSG_PUB.add;
1874: x_return_status := FND_API.G_RET_STS_ERROR;
1875: END IF;
1876:

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

1886: p_zone_code => p_route_rec.zone_code
1887: );
1888:
1889: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1890: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1891: IF ( p_route_rec.zone IS NULL ) THEN
1892: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );
1893: ELSE
1894: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );

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

1888:
1889: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1890: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1891: IF ( p_route_rec.zone IS NULL ) THEN
1892: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );
1893: ELSE
1894: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );
1895: END IF;
1896:

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

1890: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1891: IF ( p_route_rec.zone IS NULL ) THEN
1892: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone_code );
1893: ELSE
1894: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );
1895: END IF;
1896:
1897: IF ( p_route_rec.product_type IS NULL ) THEN
1898: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type_code );

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

1894: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.zone );
1895: END IF;
1896:
1897: IF ( p_route_rec.product_type IS NULL ) THEN
1898: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type_code );
1899: ELSE
1900: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type );
1901: END IF;
1902:

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

1896:
1897: IF ( p_route_rec.product_type IS NULL ) THEN
1898: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type_code );
1899: ELSE
1900: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.product_type );
1901: END IF;
1902:
1903: FND_MSG_PUB.add;
1904: x_return_status := FND_API.G_RET_STS_ERROR;

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

1919: p_sub_zone_code => p_route_rec.sub_zone_code
1920: );
1921:
1922: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1923: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1924: IF ( p_route_rec.sub_zone IS NULL ) THEN
1925: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );
1926: ELSE
1927: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );

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

1921:
1922: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1923: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1924: IF ( p_route_rec.sub_zone IS NULL ) THEN
1925: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );
1926: ELSE
1927: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );
1928: END IF;
1929:

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

1923: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1924: IF ( p_route_rec.sub_zone IS NULL ) THEN
1925: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone_code );
1926: ELSE
1927: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );
1928: END IF;
1929:
1930: IF ( p_route_rec.zone IS NULL ) THEN
1931: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone_code );

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

1927: FND_MESSAGE.set_token( 'FIELD1', p_route_rec.sub_zone );
1928: END IF;
1929:
1930: IF ( p_route_rec.zone IS NULL ) THEN
1931: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone_code );
1932: ELSE
1933: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone );
1934: END IF;
1935:

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

1929:
1930: IF ( p_route_rec.zone IS NULL ) THEN
1931: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone_code );
1932: ELSE
1933: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone );
1934: END IF;
1935:
1936: IF ( p_route_rec.product_type IS NULL ) THEN
1937: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type_code );

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

1933: FND_MESSAGE.set_token( 'FIELD2', p_route_rec.zone );
1934: END IF;
1935:
1936: IF ( p_route_rec.product_type IS NULL ) THEN
1937: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type_code );
1938: ELSE
1939: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type );
1940: END IF;
1941:

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

1935:
1936: IF ( p_route_rec.product_type IS NULL ) THEN
1937: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type_code );
1938: ELSE
1939: FND_MESSAGE.set_token( 'FIELD3', p_route_rec.product_type );
1940: END IF;
1941:
1942: FND_MSG_PUB.add;
1943: x_return_status := FND_API.G_RET_STS_ERROR;

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

2290: X_SUMMARY_FLAG => 'N'
2291: );
2292: EXCEPTION
2293: WHEN NO_DATA_FOUND THEN
2294: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2295: FND_MSG_PUB.add;
2296: WHEN OTHERS THEN
2297: IF ( SQLCODE = -1 ) THEN
2298: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

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

2294: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2295: FND_MSG_PUB.add;
2296: WHEN OTHERS THEN
2297: IF ( SQLCODE = -1 ) THEN
2298: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2299: FND_MSG_PUB.add;
2300: ELSE
2301: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2302: fnd_log.string

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

2385: );
2386:
2387: EXCEPTION
2388: WHEN NO_DATA_FOUND THEN
2389: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2390: FND_MSG_PUB.add;
2391: WHEN OTHERS THEN
2392: IF ( SQLCODE = -1 ) THEN
2393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

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

2389: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2390: FND_MSG_PUB.add;
2391: WHEN OTHERS THEN
2392: IF ( SQLCODE = -1 ) THEN
2393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2394: FND_MSG_PUB.add;
2395: ELSE
2396: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2397: fnd_log.string

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

2414: OPEN validate_system_kfv(p_x_route_rec.route_no, l_concat_segs);
2415: FETCH validate_system_kfv INTO l_kfv_flag;
2416: IF (validate_system_kfv%FOUND)
2417: THEN
2418: FND_MESSAGE.set_name('AHL', 'AHL_RM_INV_SYS_KFV');
2419: FND_MSG_PUB.add;
2420: END IF;
2421: CLOSE validate_system_kfv;
2422: END IF;

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

2613: IF ( p_route_id IS NULL OR
2614: p_route_id = FND_API.G_MISS_NUM OR
2615: p_object_version_number IS NULL OR
2616: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2617: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2618: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );
2619: FND_MSG_PUB.add;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;

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

2614: p_route_id = FND_API.G_MISS_NUM OR
2615: p_object_version_number IS NULL OR
2616: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2617: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2618: FND_MESSAGE.set_token( 'PROCEDURE', l_api_name );
2619: FND_MSG_PUB.add;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:

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

2623: OPEN validate_route_ovn;
2624: FETCH validate_route_ovn INTO l_dummy;
2625: IF (validate_route_ovn%NOTFOUND)
2626: THEN
2627: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
2628: FND_MSG_PUB.add;
2629: x_return_status := FND_API.G_RET_STS_ERROR;
2630: RAISE FND_API.G_EXC_ERROR;
2631: END IF;

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

2638: OPEN get_doc_id;
2639: FETCH get_doc_id INTO l_doc_id;
2640: IF (get_doc_id%FOUND AND l_doc_id IS NOT NULL)
2641: THEN
2642: FND_MESSAGE.set_name('AHL', 'AHL_RM_ROUTE_ENIG_DEL');
2643: FND_MSG_PUB.add;
2644: x_return_status := FND_API.G_RET_STS_ERROR;
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;

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

2655: );
2656:
2657: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2658: IF ( l_msg_data = 'AHL_RM_INVALID_ROUTE_STATUS' ) THEN
2659: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_DRAFT' );
2660: ELSE
2661: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2662: END IF;
2663:

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

2657: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2658: IF ( l_msg_data = 'AHL_RM_INVALID_ROUTE_STATUS' ) THEN
2659: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_DRAFT' );
2660: ELSE
2661: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2662: END IF;
2663:
2664: FND_MSG_PUB.add;
2665: RAISE FND_API.G_EXC_ERROR;

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

2761: );
2762:
2763: EXCEPTION
2764: WHEN NO_DATA_FOUND THEN
2765: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2766: FND_MSG_PUB.add;
2767: RAISE FND_API.G_EXC_ERROR;
2768: WHEN OTHERS THEN
2769: RAISE;

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

3044: IF ( p_route_id IS NULL OR
3045: p_route_id = FND_API.G_MISS_NUM OR
3046: p_object_version_number IS NULL OR
3047: p_object_version_number = FND_API.G_MISS_NUM ) THEN
3048: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
3049: FND_MSG_PUB.add;
3050: RAISE FND_API.G_EXC_ERROR;
3051: END IF;
3052:

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

3059: p_x_route_rec => l_old_route_rec
3060: );
3061:
3062: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
3063: FND_MESSAGE.set_name( 'AHL', l_msg_data );
3064: FND_MSG_PUB.add;
3065: RAISE FND_API.G_EXC_ERROR;
3066: END IF;
3067:

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

3066: END IF;
3067:
3068: -- Check if the Status is COMPLETE
3069: IF ( l_old_route_rec.revision_status_code <> 'COMPLETE' ) THEN
3070: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_COMPLETE' );
3071: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3072: FND_MSG_PUB.add;
3073: RAISE FND_API.G_EXC_ERROR;
3074: END IF;

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

3067:
3068: -- Check if the Status is COMPLETE
3069: IF ( l_old_route_rec.revision_status_code <> 'COMPLETE' ) THEN
3070: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_STATUS_NOT_COMPLETE' );
3071: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3072: FND_MSG_PUB.add;
3073: RAISE FND_API.G_EXC_ERROR;
3074: END IF;
3075:

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

3074: END IF;
3075:
3076: -- Check if this revision is not Terminated
3077: IF ( l_old_route_rec.active_end_date IS NOT NULL ) THEN
3078: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
3079: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3080: FND_MSG_PUB.add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: END IF;

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

3075:
3076: -- Check if this revision is not Terminated
3077: IF ( l_old_route_rec.active_end_date IS NOT NULL ) THEN
3078: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
3079: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3080: FND_MSG_PUB.add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: END IF;
3083:

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

3087: FETCH get_latest_revision INTO
3088: l_revision_number;
3089:
3090: IF ( l_revision_number <> l_old_route_rec.revision_number ) THEN
3091: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_REVISION_NOT_LATEST' );
3092: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3093: FND_MSG_PUB.add;
3094: CLOSE get_latest_revision;
3095: RAISE FND_API.G_EXC_ERROR;

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

3088: l_revision_number;
3089:
3090: IF ( l_revision_number <> l_old_route_rec.revision_number ) THEN
3091: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_REVISION_NOT_LATEST' );
3092: FND_MESSAGE.set_token( 'RECORD', l_old_route_rec.route_no );
3093: FND_MSG_PUB.add;
3094: CLOSE get_latest_revision;
3095: RAISE FND_API.G_EXC_ERROR;
3096: END IF;

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

3189: );
3190:
3191: EXCEPTION
3192: WHEN NO_DATA_FOUND THEN
3193: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
3194: FND_MSG_PUB.add;
3195: WHEN OTHERS THEN
3196: IF ( SQLCODE = -1 ) THEN
3197: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );

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

3193: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
3194: FND_MSG_PUB.add;
3195: WHEN OTHERS THEN
3196: IF ( SQLCODE = -1 ) THEN
3197: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
3198: FND_MSG_PUB.add;
3199: ELSE
3200: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3201: fnd_log.string