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_MEL_CDL_ATA_SEQS_PVT dependencies on FND_MESSAGE

Line 178: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');

174:
175: -- Verify DML operation flag is right...
176: IF (p_x_ata_sequences_tbl(l_rec_idx).dml_operation NOT IN ('C', 'U', 'D'))
177: THEN
178: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');
179: -- Invalid DML operation FIELD specified
180: FND_MESSAGE.SET_TOKEN('FIELD', p_x_ata_sequences_tbl(l_rec_idx).dml_operation);
181: FND_MSG_PUB.ADD;
182: RAISE FND_API.G_EXC_ERROR;

Line 180: FND_MESSAGE.SET_TOKEN('FIELD', p_x_ata_sequences_tbl(l_rec_idx).dml_operation);

176: IF (p_x_ata_sequences_tbl(l_rec_idx).dml_operation NOT IN ('C', 'U', 'D'))
177: THEN
178: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');
179: -- Invalid DML operation FIELD specified
180: FND_MESSAGE.SET_TOKEN('FIELD', p_x_ata_sequences_tbl(l_rec_idx).dml_operation);
181: FND_MSG_PUB.ADD;
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:

Line 267: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_CHG_UPD');

263: CLOSE get_ata_details;
264:
265: IF (l_ata_code <> p_x_ata_sequences_tbl(l_rec_idx).ata_code)
266: THEN
267: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_CHG_UPD');
268: -- Cannot modify System Sequence from "OLDATA" to "ATA" for existing record
269: FND_MESSAGE.SET_TOKEN('OLDATA', l_ata_code);
270: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
271: FND_MSG_PUB.ADD;

Line 269: FND_MESSAGE.SET_TOKEN('OLDATA', l_ata_code);

265: IF (l_ata_code <> p_x_ata_sequences_tbl(l_rec_idx).ata_code)
266: THEN
267: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_CHG_UPD');
268: -- Cannot modify System Sequence from "OLDATA" to "ATA" for existing record
269: FND_MESSAGE.SET_TOKEN('OLDATA', l_ata_code);
270: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;

Line 270: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

266: THEN
267: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_CHG_UPD');
268: -- Cannot modify System Sequence from "OLDATA" to "ATA" for existing record
269: FND_MESSAGE.SET_TOKEN('OLDATA', l_ata_code);
270: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: END IF;

Line 283: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_NUM_MAND');

279: --amsriniv. Bug 6659422
280: /*
281: IF (p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).installed_number = FND_API.G_MISS_NUM)
282: THEN
283: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_NUM_MAND');
284: -- Installed Number for System Sequence "ATA" is invalid
285: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
286: FND_MSG_PUB.ADD;
287: END IF;

Line 285: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

281: IF (p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).installed_number = FND_API.G_MISS_NUM)
282: THEN
283: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_NUM_MAND');
284: -- Installed Number for System Sequence "ATA" is invalid
285: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
286: FND_MSG_PUB.ADD;
287: END IF;
288:
289: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).dispatch_number = FND_API.G_MISS_NUM)

Line 291: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_NUM_MAND');

287: END IF;
288:
289: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).dispatch_number = FND_API.G_MISS_NUM)
290: THEN
291: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_NUM_MAND');
292: -- Dispatch Number for System Sequence "ATA" is invalid
293: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
294: FND_MSG_PUB.ADD;
295: END IF;

Line 293: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

289: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).dispatch_number = FND_API.G_MISS_NUM)
290: THEN
291: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_NUM_MAND');
292: -- Dispatch Number for System Sequence "ATA" is invalid
293: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
294: FND_MSG_PUB.ADD;
295: END IF;
296: */
297: IF ((p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL

Line 302: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');

298: AND p_x_ata_sequences_tbl(l_rec_idx).dispatch_number < 0)
299: OR (p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NOT NULL
300: AND p_x_ata_sequences_tbl(l_rec_idx).installed_number < 0))
301: THEN
302: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
303: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
304: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
305: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
306: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

Line 304: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

300: AND p_x_ata_sequences_tbl(l_rec_idx).installed_number < 0))
301: THEN
302: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
303: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
304: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
305: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
306: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
307: FND_MSG_PUB.ADD;
308: END IF;

Line 305: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);

301: THEN
302: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
303: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
304: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
305: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
306: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
307: FND_MSG_PUB.ADD;
308: END IF;
309:

Line 306: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

302: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
303: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
304: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
305: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
306: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
307: FND_MSG_PUB.ADD;
308: END IF;
309:
310: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND

Line 314: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');

310: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND
311: p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NOT NULL AND
312: p_x_ata_sequences_tbl(l_rec_idx).dispatch_number > p_x_ata_sequences_tbl(l_rec_idx).installed_number)
313: THEN
314: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
315: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
316: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
317: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
318: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

Line 316: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

312: p_x_ata_sequences_tbl(l_rec_idx).dispatch_number > p_x_ata_sequences_tbl(l_rec_idx).installed_number)
313: THEN
314: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
315: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
316: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
317: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
318: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
319: FND_MSG_PUB.ADD;
320: END IF;

Line 317: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);

313: THEN
314: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
315: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
316: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
317: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
318: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
319: FND_MSG_PUB.ADD;
320: END IF;
321:

Line 318: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

314: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
315: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
316: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
317: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
318: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
319: FND_MSG_PUB.ADD;
320: END IF;
321:
322: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND

Line 325: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');

321:
322: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND
323: p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL)
324: THEN
325: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
326: -- Installed Number should be entered when Required(Dispatch) Number is entered.
327: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
328: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
329: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

Line 327: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

323: p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL)
324: THEN
325: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
326: -- Installed Number should be entered when Required(Dispatch) Number is entered.
327: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
328: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
329: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
330: FND_MSG_PUB.ADD;
331: END IF;

Line 328: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);

324: THEN
325: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
326: -- Installed Number should be entered when Required(Dispatch) Number is entered.
327: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
328: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
329: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
330: FND_MSG_PUB.ADD;
331: END IF;
332: --amsriniv. End

Line 329: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

325: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
326: -- Installed Number should be entered when Required(Dispatch) Number is entered.
327: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
328: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
329: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
330: FND_MSG_PUB.ADD;
331: END IF;
332: --amsriniv. End
333: -- Check Error Message stack.

Line 530: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_NUM_MAND');

526: --amsriniv. Bug 6659422
527: /*
528: IF (p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).installed_number = FND_API.G_MISS_NUM)
529: THEN
530: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_NUM_MAND');
531: -- Installed Number for System Sequence "ATA" is invalid
532: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
533: FND_MSG_PUB.ADD;
534: END IF;

Line 532: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

528: IF (p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).installed_number = FND_API.G_MISS_NUM)
529: THEN
530: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_NUM_MAND');
531: -- Installed Number for System Sequence "ATA" is invalid
532: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
533: FND_MSG_PUB.ADD;
534: END IF;
535:
536: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).dispatch_number = FND_API.G_MISS_NUM)

Line 538: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_NUM_MAND');

534: END IF;
535:
536: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).dispatch_number = FND_API.G_MISS_NUM)
537: THEN
538: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_NUM_MAND');
539: -- Dispatch Number for System Sequence "ATA" is invalid
540: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
541: FND_MSG_PUB.ADD;
542: END IF;

Line 540: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

536: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NULL OR p_x_ata_sequences_tbl(l_rec_idx).dispatch_number = FND_API.G_MISS_NUM)
537: THEN
538: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_NUM_MAND');
539: -- Dispatch Number for System Sequence "ATA" is invalid
540: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
541: FND_MSG_PUB.ADD;
542: END IF;
543: */
544: IF ((p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND

Line 549: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');

545: p_x_ata_sequences_tbl(l_rec_idx).dispatch_number < 0) OR
546: (p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NOT NULL
547: AND p_x_ata_sequences_tbl(l_rec_idx).installed_number < 0))
548: THEN
549: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
550: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
551: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
552: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
553: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

Line 551: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

547: AND p_x_ata_sequences_tbl(l_rec_idx).installed_number < 0))
548: THEN
549: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
550: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
551: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
552: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
553: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
554: FND_MSG_PUB.ADD;
555: END IF;

Line 552: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);

548: THEN
549: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
550: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
551: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
552: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
553: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
554: FND_MSG_PUB.ADD;
555: END IF;
556:

Line 553: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

549: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_INST_LESS_0');
550: -- Both Dispatch Number "DISP" and Installed Number "INST" for System Sequence "ATA" should be positive integers
551: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
552: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
553: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
554: FND_MSG_PUB.ADD;
555: END IF;
556:
557: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND

Line 561: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');

557: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND
558: p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NOT NULL AND
559: p_x_ata_sequences_tbl(l_rec_idx).dispatch_number > p_x_ata_sequences_tbl(l_rec_idx).installed_number)
560: THEN
561: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
562: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
563: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
564: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
565: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

Line 563: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

559: p_x_ata_sequences_tbl(l_rec_idx).dispatch_number > p_x_ata_sequences_tbl(l_rec_idx).installed_number)
560: THEN
561: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
562: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
563: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
564: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
565: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
566: FND_MSG_PUB.ADD;
567: END IF;

Line 564: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);

560: THEN
561: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
562: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
563: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
564: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
565: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
566: FND_MSG_PUB.ADD;
567: END IF;
568:

Line 565: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

561: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DISP_MORE_INST');
562: -- Dispatch Number "DISP" for System Sequence "ATA" should be less than Installed Number "INST"
563: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
564: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
565: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
566: FND_MSG_PUB.ADD;
567: END IF;
568:
569: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND

Line 572: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');

568:
569: IF (p_x_ata_sequences_tbl(l_rec_idx).dispatch_number IS NOT NULL AND
570: p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL)
571: THEN
572: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
573: -- Installed Number should be entered when Required(Dispatch) Number is entered.
574: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
575: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
576: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

Line 574: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

570: p_x_ata_sequences_tbl(l_rec_idx).installed_number IS NULL)
571: THEN
572: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
573: -- Installed Number should be entered when Required(Dispatch) Number is entered.
574: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
575: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
576: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
577: FND_MSG_PUB.ADD;
578: END IF;

Line 575: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);

571: THEN
572: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
573: -- Installed Number should be entered when Required(Dispatch) Number is entered.
574: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
575: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
576: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
577: FND_MSG_PUB.ADD;
578: END IF;
579: --amsriniv. End

Line 576: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);

572: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_INST_MISSING');
573: -- Installed Number should be entered when Required(Dispatch) Number is entered.
574: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
575: FND_MESSAGE.SET_TOKEN('DISP', p_x_ata_sequences_tbl(l_rec_idx).dispatch_number);
576: FND_MESSAGE.SET_TOKEN('INST', p_x_ata_sequences_tbl(l_rec_idx).installed_number);
577: FND_MSG_PUB.ADD;
578: END IF;
579: --amsriniv. End
580:

Line 587: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_EXISTS');

583: OPEN check_ata_unique(p_x_ata_sequences_tbl(l_rec_idx).mel_cdl_header_id, p_x_ata_sequences_tbl(l_rec_idx).ata_code);
584: FETCH check_ata_unique INTO l_dummy_varchar;
585: IF (check_ata_unique%FOUND)
586: THEN
587: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_EXISTS');
588: -- System Sequence "ATA" is already associated with the MEL/CDL
589: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
590: FND_MSG_PUB.ADD;
591: END IF;

Line 589: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);

585: IF (check_ata_unique%FOUND)
586: THEN
587: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_EXISTS');
588: -- System Sequence "ATA" is already associated with the MEL/CDL
589: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_tbl(l_rec_idx).ata_code);
590: FND_MSG_PUB.ADD;
591: END IF;
592: CLOSE check_ata_unique;
593:

Line 956: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');

952:
953: -- Verify DML operation flag is right...
954: IF (p_x_mo_procedures_tbl(l_rec_idx).dml_operation NOT IN ( 'C', 'D'))
955: THEN
956: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');
957: -- Invalid DML operation FIELD specified
958: FND_MESSAGE.SET_TOKEN('FIELD', p_x_mo_procedures_tbl(l_rec_idx).dml_operation);
959: FND_MSG_PUB.ADD;
960: RAISE FND_API.G_EXC_ERROR;

Line 958: FND_MESSAGE.SET_TOKEN('FIELD', p_x_mo_procedures_tbl(l_rec_idx).dml_operation);

954: IF (p_x_mo_procedures_tbl(l_rec_idx).dml_operation NOT IN ( 'C', 'D'))
955: THEN
956: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');
957: -- Invalid DML operation FIELD specified
958: FND_MESSAGE.SET_TOKEN('FIELD', p_x_mo_procedures_tbl(l_rec_idx).dml_operation);
959: FND_MSG_PUB.ADD;
960: RAISE FND_API.G_EXC_ERROR;
961: END IF;
962:

Line 990: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_MR_NOTMO_INV');

986: FETCH validate_mr_header_id INTO l_dummy_varchar;
987:
988: IF (validate_mr_header_id%NOTFOUND)
989: THEN
990: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_MR_NOTMO_INV');
991: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);
992: FND_MSG_PUB.ADD;
993: END IF;
994: CLOSE validate_mr_header_id;

Line 991: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);

987:
988: IF (validate_mr_header_id%NOTFOUND)
989: THEN
990: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_MR_NOTMO_INV');
991: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);
992: FND_MSG_PUB.ADD;
993: END IF;
994: CLOSE validate_mr_header_id;
995:

Line 1002: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_STATUS_INV');

998: FETCH validate_mr_header_status INTO l_status;
999:
1000: IF (validate_mr_header_status%NOTFOUND)
1001: THEN
1002: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_STATUS_INV');
1003: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);
1004: FND_MSG_PUB.ADD;
1005: END IF;
1006: CLOSE validate_mr_header_status;

Line 1003: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);

999:
1000: IF (validate_mr_header_status%NOTFOUND)
1001: THEN
1002: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_STATUS_INV');
1003: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);
1004: FND_MSG_PUB.ADD;
1005: END IF;
1006: CLOSE validate_mr_header_status;
1007:

Line 1012: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_MO_MR_MAND');

1008: ELSIF (p_x_mo_procedures_tbl(l_rec_idx).mr_header_id IS NULL or p_x_mo_procedures_tbl(l_rec_idx).mr_header_id = FND_API.G_MISS_NUM)
1009: THEN
1010: IF (p_x_mo_procedures_tbl(l_rec_idx).mr_title IS NULL OR p_x_mo_procedures_tbl(l_rec_idx).mr_version_number IS NULL )
1011: THEN
1012: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_MO_MR_MAND');
1013: FND_MSG_PUB.ADD;
1014: ELSE
1015: --Get Mr Header Id using the Title and Version Number
1016: OPEN get_mr_header_id ( p_x_mo_procedures_tbl(l_rec_idx).mr_title, p_x_mo_procedures_tbl(l_rec_idx).mr_version_number );

Line 1021: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_INV');

1017: FETCH get_mr_header_id INTO p_x_mo_procedures_tbl(l_rec_idx).mr_header_id;
1018:
1019: IF (get_mr_header_id%NOTFOUND)
1020: THEN
1021: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_INV');
1022: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);
1023: FND_MSG_PUB.ADD;
1024: END IF;
1025: CLOSE get_mr_header_id;

Line 1022: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);

1018:
1019: IF (get_mr_header_id%NOTFOUND)
1020: THEN
1021: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_MO_INV');
1022: FND_MESSAGE.SET_TOKEN('MRTITLE',p_x_mo_procedures_tbl(l_rec_idx).mr_title);
1023: FND_MSG_PUB.ADD;
1024: END IF;
1025: CLOSE get_mr_header_id;
1026: END IF;

Line 1038: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_ATA_INV');

1034: FETCH validate_ata_seq INTO l_dummy_varchar;
1035:
1036: IF(validate_ata_seq%NOTFOUND)
1037: THEN
1038: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_ATA_INV');
1039: FND_MSG_PUB.ADD;
1040: END IF;
1041: CLOSE validate_ata_seq;
1042:

Line 1050: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_UPDATA_STS_INV');

1046: CLOSE val_mel_cdl_status;
1047:
1048: IF (l_status NOT IN ('DRAFT', 'APPROVAL_REJECTED'))
1049: THEN
1050: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_UPDATA_STS_INV');
1051: -- Cannot process if MEL/CDL is not in draft or approval rejected status
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;

Line 1069: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_MO_EXISTS');

1065: AND mr_header_id = p_x_mo_procedures_tbl(l_rec_idx).mr_header_id);
1066:
1067: EXCEPTION
1068: WHEN NO_DATA_FOUND THEN
1069: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_MO_EXISTS');
1070: -- MO Proc Assocaition Already Exists for the ATA Seq
1071: FND_MESSAGE.SET_TOKEN('MRTitle', p_x_mo_procedures_tbl(l_rec_idx).mr_title);
1072: FND_MSG_PUB.ADD;
1073: END;

Line 1071: FND_MESSAGE.SET_TOKEN('MRTitle', p_x_mo_procedures_tbl(l_rec_idx).mr_title);

1067: EXCEPTION
1068: WHEN NO_DATA_FOUND THEN
1069: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_MO_EXISTS');
1070: -- MO Proc Assocaition Already Exists for the ATA Seq
1071: FND_MESSAGE.SET_TOKEN('MRTitle', p_x_mo_procedures_tbl(l_rec_idx).mr_title);
1072: FND_MSG_PUB.ADD;
1073: END;
1074:
1075: -- Check Error Message stack.

Line 1347: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');

1343: -- Verify DML operation flag is right...
1344: IF (p_x_ata_relations_tbl(l_rec_idx).dml_operation NOT IN ( 'C', 'D'))
1345: THEN
1346:
1347: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');
1348: -- Invalid DML operation FIELD specified
1349: FND_MESSAGE.SET_TOKEN('FIELD', p_x_ata_relations_tbl(l_rec_idx).dml_operation);
1350: FND_MSG_PUB.ADD;
1351: RAISE FND_API.G_EXC_ERROR;

Line 1349: FND_MESSAGE.SET_TOKEN('FIELD', p_x_ata_relations_tbl(l_rec_idx).dml_operation);

1345: THEN
1346:
1347: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML_REC');
1348: -- Invalid DML operation FIELD specified
1349: FND_MESSAGE.SET_TOKEN('FIELD', p_x_ata_relations_tbl(l_rec_idx).dml_operation);
1350: FND_MSG_PUB.ADD;
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:

Line 1387: FND_MESSAGE.Set_Name('AHL', 'AHL_MEL_CDL_ATA_MAND');

1383:
1384: --Check if Ata Sequence Id is null , as its a mandatory field
1385: IF (p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id IS NULL)
1386: THEN
1387: FND_MESSAGE.Set_Name('AHL', 'AHL_MEL_CDL_ATA_MAND');
1388: FND_MSG_PUB.ADD;
1389: END IF;
1390:
1391: --Check for the Related Ata Sequence Id, It is also a mandatory Field

Line 1394: FND_MESSAGE.Set_Name('AHL', 'AHL_MEL_CDL_RELN_MAND');

1390:
1391: --Check for the Related Ata Sequence Id, It is also a mandatory Field
1392: IF (p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id IS NULL)
1393: THEN
1394: FND_MESSAGE.Set_Name('AHL', 'AHL_MEL_CDL_RELN_MAND');
1395: FND_MSG_PUB.ADD;
1396:
1397: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1398: THEN

Line 1416: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_ATA_INV');

1412: FETCH validate_ata_seq INTO l_dummy_varchar;
1413:
1414: IF(validate_ata_seq%NOTFOUND)
1415: THEN
1416: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_ATA_INV');
1417: FND_MSG_PUB.ADD;
1418: END IF;
1419: CLOSE validate_ata_seq;
1420:

Line 1428: FND_MESSAGE.SET_NAME(G_APP_NAME, ' AHL_MEL_CDL_UPDATA_STS_INV');

1424: CLOSE val_mel_cdl_status;
1425:
1426: IF (l_status NOT IN ('DRAFT', 'APPROVAL_REJECTED'))
1427: THEN
1428: FND_MESSAGE.SET_NAME(G_APP_NAME, ' AHL_MEL_CDL_UPDATA_STS_INV');
1429: -- Cannot process if MEL/CDL is not in draft or approval rejected status
1430: FND_MSG_PUB.ADD;
1431: RAISE FND_API.G_EXC_ERROR;
1432: END IF;

Line 1443: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_ATA_INV');

1439: FETCH validate_ata_seq INTO l_dummy_varchar;
1440:
1441: IF(validate_ata_seq%NOTFOUND)
1442: THEN
1443: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_ATA_INV');
1444: FND_MSG_PUB.ADD;
1445: END IF;
1446: CLOSE validate_ata_seq;
1447: END IF;

Line 1470: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_RELN_EXISTS');

1466: FETCH Check_Reln_Exists INTO l_dummy_varchar;
1467:
1468: IF (Check_Reln_Exists%FOUND)
1469: THEN
1470: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_RELN_EXISTS');
1471: -- Interrelation alredy Exists for ATA Sequence
1472: FND_MESSAGE.SET_TOKEN('ATA',l_ata_mng);
1473: FND_MSG_PUB.ADD;
1474: END IF;

Line 1472: FND_MESSAGE.SET_TOKEN('ATA',l_ata_mng);

1468: IF (Check_Reln_Exists%FOUND)
1469: THEN
1470: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_RELN_EXISTS');
1471: -- Interrelation alredy Exists for ATA Sequence
1472: FND_MESSAGE.SET_TOKEN('ATA',l_ata_mng);
1473: FND_MSG_PUB.ADD;
1474: END IF;
1475: CLOSE Check_Reln_Exists;
1476:

Line 1483: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_RELN_DIFF');

1479: FETCH Validate_For_Same_Mel_Cdl INTO l_dummy_varchar;
1480:
1481: IF (Validate_For_Same_Mel_Cdl%NOTFOUND)
1482: THEN
1483: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_RELN_DIFF');
1484: FND_MESSAGE.SET_TOKEN('ATA', l_ata_mng);
1485: FND_MESSAGE.SET_TOKEN('RELATA', l_reln_ata_mng);
1486: FND_MSG_PUB.ADD;
1487: END IF;

Line 1484: FND_MESSAGE.SET_TOKEN('ATA', l_ata_mng);

1480:
1481: IF (Validate_For_Same_Mel_Cdl%NOTFOUND)
1482: THEN
1483: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_RELN_DIFF');
1484: FND_MESSAGE.SET_TOKEN('ATA', l_ata_mng);
1485: FND_MESSAGE.SET_TOKEN('RELATA', l_reln_ata_mng);
1486: FND_MSG_PUB.ADD;
1487: END IF;
1488: CLOSE Validate_For_Same_Mel_Cdl;

Line 1485: FND_MESSAGE.SET_TOKEN('RELATA', l_reln_ata_mng);

1481: IF (Validate_For_Same_Mel_Cdl%NOTFOUND)
1482: THEN
1483: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_RELN_DIFF');
1484: FND_MESSAGE.SET_TOKEN('ATA', l_ata_mng);
1485: FND_MESSAGE.SET_TOKEN('RELATA', l_reln_ata_mng);
1486: FND_MSG_PUB.ADD;
1487: END IF;
1488: CLOSE Validate_For_Same_Mel_Cdl;
1489:

Line 1498: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_RELN_CYCLIC');

1494: p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id <> FND_API.G_MISS_NUM AND p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id <> FND_API.G_MISS_NUM )
1495: THEN
1496: IF (p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id )
1497: THEN
1498: FND_MESSAGE.Set_Name('AHL','AHL_MEL_CDL_RELN_CYCLIC');
1499: FND_MSG_PUB.ADD;
1500: END IF;
1501:
1502: END IF;

Line 1902: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_NOTFOUND');

1898: FETCH check_exists INTO l_ovn;
1899: IF (check_exists%NOTFOUND)
1900: THEN
1901: CLOSE check_exists;
1902: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_NOTFOUND');
1903: -- System Sequence is not found
1904: FND_MSG_PUB.ADD;
1905: RAISE FND_API.G_EXC_ERROR;
1906: ELSE

Line 1910: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');

1906: ELSE
1907: CLOSE check_exists;
1908: IF (l_ovn <> p_ata_object_version)
1909: THEN
1910: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');
1911: -- Record has been modified by another user
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;

Line 1951: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_MAND');

1947:
1948: -- Convert value-to-id for ata_code
1949: IF (p_x_ata_sequences_rec.ata_code IS NULL OR p_x_ata_sequences_rec.ata_code = FND_API.G_MISS_CHAR)
1950: THEN
1951: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_MAND');
1952: -- System Sequence is mandatory
1953: FND_MSG_PUB.ADD;
1954: ELSIF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_ATA_CODE', p_x_ata_sequences_rec.ata_code))
1955: THEN

Line 1956: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_INV');

1952: -- System Sequence is mandatory
1953: FND_MSG_PUB.ADD;
1954: ELSIF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_ATA_CODE', p_x_ata_sequences_rec.ata_code))
1955: THEN
1956: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_ATA_INV');
1957: -- System Sequence is invalid
1958: FND_MSG_PUB.ADD;
1959: END IF;
1960:

Line 1966: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_MAND');

1962: IF (p_x_ata_sequences_rec.repair_category_id IS NULL OR p_x_ata_sequences_rec.repair_category_id = FND_API.G_MISS_NUM)
1963: THEN
1964: IF (p_x_ata_sequences_rec.repair_category_name IS NULL OR p_x_ata_sequences_rec.repair_category_name = FND_API.G_MISS_CHAR)
1965: THEN
1966: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_MAND');
1967: -- Repair Category for System Sequence "ATA" is mandatory
1968: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);
1969: FND_MSG_PUB.ADD;
1970: ELSE

Line 1968: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);

1964: IF (p_x_ata_sequences_rec.repair_category_name IS NULL OR p_x_ata_sequences_rec.repair_category_name = FND_API.G_MISS_CHAR)
1965: THEN
1966: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_MAND');
1967: -- Repair Category for System Sequence "ATA" is mandatory
1968: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);
1969: FND_MSG_PUB.ADD;
1970: ELSE
1971: OPEN convert_repcat(p_x_ata_sequences_rec.repair_category_name);
1972: FETCH convert_repcat INTO p_x_ata_sequences_rec.repair_category_id;

Line 1975: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_INV');

1971: OPEN convert_repcat(p_x_ata_sequences_rec.repair_category_name);
1972: FETCH convert_repcat INTO p_x_ata_sequences_rec.repair_category_id;
1973: IF (convert_repcat%NOTFOUND)
1974: THEN
1975: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_INV');
1976: -- Repair Category for System Sequence "ATA" is invalid
1977: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);
1978: FND_MSG_PUB.ADD;
1979: END IF;

Line 1977: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);

1973: IF (convert_repcat%NOTFOUND)
1974: THEN
1975: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_INV');
1976: -- Repair Category for System Sequence "ATA" is invalid
1977: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);
1978: FND_MSG_PUB.ADD;
1979: END IF;
1980: CLOSE convert_repcat;
1981: END IF;

Line 1987: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_INV');

1983: OPEN validate_repcat(p_x_ata_sequences_rec.repair_category_id);
1984: FETCH validate_repcat INTO l_dummy_varchar;
1985: IF (validate_repcat%NOTFOUND)
1986: THEN
1987: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_INV');
1988: -- Repair Category for System Sequence "ATA" is invalid
1989: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);
1990: FND_MSG_PUB.ADD;
1991: END IF;

Line 1989: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);

1985: IF (validate_repcat%NOTFOUND)
1986: THEN
1987: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_INV');
1988: -- Repair Category for System Sequence "ATA" is invalid
1989: FND_MESSAGE.SET_TOKEN('ATA', p_x_ata_sequences_rec.ata_code);
1990: FND_MSG_PUB.ADD;
1991: END IF;
1992: CLOSE validate_repcat;
1993: END IF;

Line 2035: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_HDR_MAND');

2031: OPEN get_ata_mel_cdl_status;
2032: FETCH get_ata_mel_cdl_status INTO l_status, l_mel_cdl_header_id;
2033: CLOSE get_ata_mel_cdl_status;
2034: ELSE
2035: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_HDR_MAND');
2036: -- MEL/CDL information is mandatory for processing System Sequence(s)
2037: FND_MSG_PUB.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;

Line 2043: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_ATA');

2039: END IF;
2040:
2041: IF (l_status NOT IN ('DRAFT', 'APPROVAL_REJECTED'))
2042: THEN
2043: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_ATA');
2044: -- Cannot process System Sequence(s) for MEL/CDL not in draft or approval rejected status
2045: FND_MSG_PUB.ADD;
2046: RAISE FND_API.G_EXC_ERROR;
2047: ELSIF (l_status = 'APPROVAL_REJECTED')

Line 2082: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_MO_PROC_NOTFOUND');

2078: FETCH check_exists INTO l_ovn;
2079: IF (check_exists%NOTFOUND)
2080: THEN
2081: CLOSE check_exists;
2082: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_MO_PROC_NOTFOUND');
2083: -- MO Procedure is not found
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: ELSE

Line 2090: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');

2086: ELSE
2087: CLOSE check_exists;
2088: IF (l_ovn <> p_mo_proc_object_version)
2089: THEN
2090: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');
2091: -- Record has been modified by another user
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;

Line 2126: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REL_NOTFOUND');

2122: IF (check_exists%NOTFOUND)
2123: THEN
2124: CLOSE check_exists;
2125:
2126: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REL_NOTFOUND');
2127: -- MO Procedure is not found
2128: FND_MSG_PUB.ADD;
2129: RAISE FND_API.G_EXC_ERROR;
2130:

Line 2136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');

2132: CLOSE check_exists;
2133:
2134: IF (l_ovn <> p_rel_object_version)
2135: THEN
2136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');
2137: -- Record has been modified by another user
2138: FND_MSG_PUB.ADD;
2139: RAISE FND_API.G_EXC_ERROR;
2140: END IF;