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.IGS_DA_REQ_FTRS_PKG dependencies on FND_API

Line 250: RAISE FND_API.G_EXC_ERROR;

246: )
247: ) THEN
248: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
249: igs_ge_msg_stack.add;
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: check_parent_existance;
253: ELSIF (p_action = 'UPDATE') THEN
254: -- Call all the procedures related to Before Update.

Line 265: RAISE FND_API.G_EXC_ERROR;

261: )
262: ) THEN
263: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
264: igs_ge_msg_stack.add;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;
267: END IF;
268:
269: END before_dml;

Line 351: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

347: x_last_update_login
348: ) RETURNING ROWID INTO x_rowid;
349:
350: -- Initialize API return status to success.
351: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
352: -- Standard call to get message count and if count is 1, get message
353: -- info.
354: FND_MSG_PUB.Count_And_Get(
355: p_encoded => FND_API.G_FALSE,

Line 355: p_encoded => FND_API.G_FALSE,

351: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
352: -- Standard call to get message count and if count is 1, get message
353: -- info.
354: FND_MSG_PUB.Count_And_Get(
355: p_encoded => FND_API.G_FALSE,
356: p_count => x_MSG_COUNT,
357: p_data => X_MSG_DATA);
358:
359: EXCEPTION

Line 360: WHEN FND_API.G_EXC_ERROR THEN

356: p_count => x_MSG_COUNT,
357: p_data => X_MSG_DATA);
358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362: FND_MSG_PUB.Count_And_Get(
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_MSG_COUNT,

Line 361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

357: p_data => X_MSG_DATA);
358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362: FND_MSG_PUB.Count_And_Get(
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_MSG_COUNT,
365: p_data => X_MSG_DATA);

Line 363: p_encoded => FND_API.G_FALSE,

359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362: FND_MSG_PUB.Count_And_Get(
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_MSG_COUNT,
365: p_data => X_MSG_DATA);
366: RETURN;
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

363: p_encoded => FND_API.G_FALSE,
364: p_count => x_MSG_COUNT,
365: p_data => X_MSG_DATA);
366: RETURN;
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_And_Get(
370: p_encoded => FND_API.G_FALSE,
371: p_count => x_MSG_COUNT,

Line 368: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

364: p_count => x_MSG_COUNT,
365: p_data => X_MSG_DATA);
366: RETURN;
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_And_Get(
370: p_encoded => FND_API.G_FALSE,
371: p_count => x_MSG_COUNT,
372: p_data => X_MSG_DATA);

Line 370: p_encoded => FND_API.G_FALSE,

366: RETURN;
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_And_Get(
370: p_encoded => FND_API.G_FALSE,
371: p_count => x_MSG_COUNT,
372: p_data => X_MSG_DATA);
373: RETURN;
374: WHEN OTHERS THEN

Line 375: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

371: p_count => x_MSG_COUNT,
372: p_data => X_MSG_DATA);
373: RETURN;
374: WHEN OTHERS THEN
375: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
377: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
378: FND_MSG_PUB.ADD;
379: FND_MSG_PUB.Count_And_Get(

Line 380: p_encoded => FND_API.G_FALSE,

376: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
377: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
378: FND_MSG_PUB.ADD;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_MSG_COUNT,
382: p_data => X_MSG_DATA);
383: RETURN;
384:

Line 435: RAISE FND_API.G_EXC_ERROR;

431: NULL;
432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: igs_ge_msg_stack.add;
435: RAISE FND_API.G_EXC_ERROR;
436: END IF;
437:
438: -- Initialize API return status to success.
439: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 439: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

435: RAISE FND_API.G_EXC_ERROR;
436: END IF;
437:
438: -- Initialize API return status to success.
439: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
440: -- Standard call to get message count and if count is 1, get message
441: -- info.
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,

Line 443: p_encoded => FND_API.G_FALSE,

439: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
440: -- Standard call to get message count and if count is 1, get message
441: -- info.
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_MSG_COUNT,
445: p_data => X_MSG_DATA);
446: RETURN;
447: EXCEPTION

Line 448: WHEN FND_API.G_EXC_ERROR THEN

444: p_count => x_MSG_COUNT,
445: p_data => X_MSG_DATA);
446: RETURN;
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get(
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_MSG_COUNT,

Line 449: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

445: p_data => X_MSG_DATA);
446: RETURN;
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get(
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_MSG_COUNT,
453: p_data => X_MSG_DATA);

Line 451: p_encoded => FND_API.G_FALSE,

447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get(
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_MSG_COUNT,
453: p_data => X_MSG_DATA);
454: RETURN;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

451: p_encoded => FND_API.G_FALSE,
452: p_count => x_MSG_COUNT,
453: p_data => X_MSG_DATA);
454: RETURN;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_FALSE,
459: p_count => x_MSG_COUNT,

Line 456: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

452: p_count => x_MSG_COUNT,
453: p_data => X_MSG_DATA);
454: RETURN;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_FALSE,
459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);

Line 458: p_encoded => FND_API.G_FALSE,

454: RETURN;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_FALSE,
459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461: RETURN;
462: WHEN OTHERS THEN

Line 463: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461: RETURN;
462: WHEN OTHERS THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
464: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
465: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_And_Get(

Line 468: p_encoded => FND_API.G_FALSE,

464: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
465: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_And_Get(
468: p_encoded => FND_API.G_FALSE,
469: p_count => x_MSG_COUNT,
470: p_data => X_MSG_DATA);
471: RETURN;
472:

Line 545: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

541: IF (SQL%NOTFOUND) THEN
542: RAISE NO_DATA_FOUND;
543: END IF;
544: -- Initialize API return status to success.
545: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
546: -- Standard call to get message count and if count is 1, get message
547: -- info.
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,

Line 549: p_encoded => FND_API.G_FALSE,

545: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
546: -- Standard call to get message count and if count is 1, get message
547: -- info.
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_MSG_COUNT,
551: p_data => X_MSG_DATA);
552:
553: EXCEPTION

Line 554: WHEN FND_API.G_EXC_ERROR THEN

550: p_count => x_MSG_COUNT,
551: p_data => X_MSG_DATA);
552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_MSG_COUNT,

Line 555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

551: p_data => X_MSG_DATA);
552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_MSG_COUNT,
559: p_data => X_MSG_DATA);

Line 557: p_encoded => FND_API.G_FALSE,

553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_MSG_COUNT,
559: p_data => X_MSG_DATA);
560: RETURN;
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

557: p_encoded => FND_API.G_FALSE,
558: p_count => x_MSG_COUNT,
559: p_data => X_MSG_DATA);
560: RETURN;
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MSG_PUB.Count_And_Get(
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_MSG_COUNT,

Line 562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

558: p_count => x_MSG_COUNT,
559: p_data => X_MSG_DATA);
560: RETURN;
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MSG_PUB.Count_And_Get(
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_MSG_COUNT,
566: p_data => X_MSG_DATA);

Line 564: p_encoded => FND_API.G_FALSE,

560: RETURN;
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MSG_PUB.Count_And_Get(
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_MSG_COUNT,
566: p_data => X_MSG_DATA);
567: RETURN;
568: WHEN OTHERS THEN

Line 569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

565: p_count => x_MSG_COUNT,
566: p_data => X_MSG_DATA);
567: RETURN;
568: WHEN OTHERS THEN
569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
571: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
572: FND_MSG_PUB.ADD;
573: FND_MSG_PUB.Count_And_Get(

Line 574: p_encoded => FND_API.G_FALSE,

570: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
571: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
572: FND_MSG_PUB.ADD;
573: FND_MSG_PUB.Count_And_Get(
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_MSG_COUNT,
576: p_data => X_MSG_DATA);
577: RETURN;
578:

Line 672: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

668: IF (SQL%NOTFOUND) THEN
669: RAISE NO_DATA_FOUND;
670: END IF;
671: -- Initialize API return status to success.
672: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
673: -- Standard call to get message count and if count is 1, get message
674: -- info.
675: FND_MSG_PUB.Count_And_Get(
676: p_encoded => FND_API.G_FALSE,

Line 676: p_encoded => FND_API.G_FALSE,

672: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
673: -- Standard call to get message count and if count is 1, get message
674: -- info.
675: FND_MSG_PUB.Count_And_Get(
676: p_encoded => FND_API.G_FALSE,
677: p_count => x_MSG_COUNT,
678: p_data => X_MSG_DATA);
679:
680: EXCEPTION

Line 681: WHEN FND_API.G_EXC_ERROR THEN

677: p_count => x_MSG_COUNT,
678: p_data => X_MSG_DATA);
679:
680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get(
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_MSG_COUNT,

Line 682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

678: p_data => X_MSG_DATA);
679:
680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get(
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_MSG_COUNT,
686: p_data => X_MSG_DATA);

Line 684: p_encoded => FND_API.G_FALSE,

680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get(
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_MSG_COUNT,
686: p_data => X_MSG_DATA);
687: RETURN;
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

684: p_encoded => FND_API.G_FALSE,
685: p_count => x_MSG_COUNT,
686: p_data => X_MSG_DATA);
687: RETURN;
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.Count_And_Get(
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_MSG_COUNT,

Line 689: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

685: p_count => x_MSG_COUNT,
686: p_data => X_MSG_DATA);
687: RETURN;
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.Count_And_Get(
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_MSG_COUNT,
693: p_data => X_MSG_DATA);

Line 691: p_encoded => FND_API.G_FALSE,

687: RETURN;
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.Count_And_Get(
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_MSG_COUNT,
693: p_data => X_MSG_DATA);
694: RETURN;
695: WHEN OTHERS THEN

Line 696: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

692: p_count => x_MSG_COUNT,
693: p_data => X_MSG_DATA);
694: RETURN;
695: WHEN OTHERS THEN
696: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
698: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
699: FND_MSG_PUB.ADD;
700: FND_MSG_PUB.Count_And_Get(

Line 701: p_encoded => FND_API.G_FALSE,

697: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
698: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
699: FND_MSG_PUB.ADD;
700: FND_MSG_PUB.Count_And_Get(
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_MSG_COUNT,
703: p_data => X_MSG_DATA);
704: RETURN;
705: