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_AS_SUA_SES_ATTS_PKG dependencies on FND_API

Line 93: RAISE FND_API.G_EXC_ERROR;

89: x_uoo_id => new_references.uoo_id
90: ) THEN
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
96: IF NOT igs_en_su_Attempt_pkg.get_pk_for_validation(x_person_id => new_references.person_id ,
97: x_course_cd => new_references.course_cd,

Line 102: RAISE FND_API.G_EXC_ERROR;

98: x_uoo_id => new_references.uoo_id)
99: THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:
105: END check_parent_existance;
106:

Line 320: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

316: END IF;
317:
318:
319: -- Initialize API return status to success.
320: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
321: -- Standard call to get message count and if count is 1, get message
322: -- info.
323: FND_MSG_PUB.Count_And_Get(
324: p_encoded => FND_API.G_FALSE,

Line 324: p_encoded => FND_API.G_FALSE,

320: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
321: -- Standard call to get message count and if count is 1, get message
322: -- info.
323: FND_MSG_PUB.Count_And_Get(
324: p_encoded => FND_API.G_FALSE,
325: p_count => x_MSG_COUNT,
326: p_data => X_MSG_DATA);
327:
328: EXCEPTION

Line 329: WHEN FND_API.G_EXC_ERROR THEN

325: p_count => x_MSG_COUNT,
326: p_data => X_MSG_DATA);
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: igs_sc_gen_001.unset_ctx('R');
331: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get(
333: p_encoded => FND_API.G_FALSE,

Line 331: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: igs_sc_gen_001.unset_ctx('R');
331: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get(
333: p_encoded => FND_API.G_FALSE,
334: p_count => x_MSG_COUNT,
335: p_data => X_MSG_DATA);

Line 333: p_encoded => FND_API.G_FALSE,

329: WHEN FND_API.G_EXC_ERROR THEN
330: igs_sc_gen_001.unset_ctx('R');
331: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get(
333: p_encoded => FND_API.G_FALSE,
334: p_count => x_MSG_COUNT,
335: p_data => X_MSG_DATA);
336: RETURN;
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

333: p_encoded => FND_API.G_FALSE,
334: p_count => x_MSG_COUNT,
335: p_data => X_MSG_DATA);
336: RETURN;
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: igs_sc_gen_001.unset_ctx('R');
339: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get(
341: p_encoded => FND_API.G_FALSE,

Line 339: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

335: p_data => X_MSG_DATA);
336: RETURN;
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: igs_sc_gen_001.unset_ctx('R');
339: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get(
341: p_encoded => FND_API.G_FALSE,
342: p_count => x_MSG_COUNT,
343: p_data => X_MSG_DATA);

Line 341: p_encoded => FND_API.G_FALSE,

337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: igs_sc_gen_001.unset_ctx('R');
339: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get(
341: p_encoded => FND_API.G_FALSE,
342: p_count => x_MSG_COUNT,
343: p_data => X_MSG_DATA);
344: RETURN;
345: WHEN OTHERS THEN

Line 352: p_encoded => FND_API.G_FALSE,

348: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
349: fnd_message.set_token ('ERR_CD', SQLCODE);
350: FND_MSG_PUB.ADD;
351: FND_MSG_PUB.Count_And_Get(
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_MSG_COUNT,
354: p_data => X_MSG_DATA);
355: ELSE
356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

352: p_encoded => FND_API.G_FALSE,
353: p_count => x_MSG_COUNT,
354: p_data => X_MSG_DATA);
355: ELSE
356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
358: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
359: FND_MSG_PUB.ADD;
360: FND_MSG_PUB.Count_And_Get(

Line 361: p_encoded => FND_API.G_FALSE,

357: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
358: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
359: FND_MSG_PUB.ADD;
360: FND_MSG_PUB.Count_And_Get(
361: p_encoded => FND_API.G_FALSE,
362: p_count => x_MSG_COUNT,
363: p_data => X_MSG_DATA);
364: END IF;
365: RETURN;

Line 423: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

419: app_exception.raise_exception;
420: END IF;
421:
422: -- Initialize API return status to success.
423: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
424: -- Standard call to get message count and if count is 1, get message
425: -- info.
426: FND_MSG_PUB.Count_And_Get(
427: p_encoded => FND_API.G_FALSE,

Line 427: p_encoded => FND_API.G_FALSE,

423: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
424: -- Standard call to get message count and if count is 1, get message
425: -- info.
426: FND_MSG_PUB.Count_And_Get(
427: p_encoded => FND_API.G_FALSE,
428: p_count => x_MSG_COUNT,
429: p_data => X_MSG_DATA);
430:
431: EXCEPTION

Line 432: WHEN FND_API.G_EXC_ERROR THEN

428: p_count => x_MSG_COUNT,
429: p_data => X_MSG_DATA);
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
434: FND_MSG_PUB.Count_And_Get(
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_MSG_COUNT,

Line 433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

429: p_data => X_MSG_DATA);
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
434: FND_MSG_PUB.Count_And_Get(
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_MSG_COUNT,
437: p_data => X_MSG_DATA);

Line 435: p_encoded => FND_API.G_FALSE,

431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
434: FND_MSG_PUB.Count_And_Get(
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_MSG_COUNT,
437: p_data => X_MSG_DATA);
438: RETURN;
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

435: p_encoded => FND_API.G_FALSE,
436: p_count => x_MSG_COUNT,
437: p_data => X_MSG_DATA);
438: RETURN;
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_MSG_COUNT,

Line 440: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

436: p_count => x_MSG_COUNT,
437: p_data => X_MSG_DATA);
438: RETURN;
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_MSG_COUNT,
444: p_data => X_MSG_DATA);

Line 442: p_encoded => FND_API.G_FALSE,

438: RETURN;
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_MSG_COUNT,
444: p_data => X_MSG_DATA);
445: RETURN;
446: WHEN OTHERS THEN

Line 447: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

443: p_count => x_MSG_COUNT,
444: p_data => X_MSG_DATA);
445: RETURN;
446: WHEN OTHERS THEN
447: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
449: FND_MESSAGE.SET_TOKEN('NAME','lock_row : '||SQLERRM);
450: FND_MSG_PUB.ADD;
451: FND_MSG_PUB.Count_And_Get(

Line 452: p_encoded => FND_API.G_FALSE,

448: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
449: FND_MESSAGE.SET_TOKEN('NAME','lock_row : '||SQLERRM);
450: FND_MSG_PUB.ADD;
451: FND_MSG_PUB.Count_And_Get(
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_MSG_COUNT,
454: p_data => X_MSG_DATA);
455: RETURN;
456:

Line 547: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

543: END IF;
544:
545:
546: -- Initialize API return status to success.
547: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
548: -- Standard call to get message count and if count is 1, get message
549: -- info.
550: FND_MSG_PUB.Count_And_Get(
551: p_encoded => FND_API.G_FALSE,

Line 551: p_encoded => FND_API.G_FALSE,

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

Line 556: WHEN FND_API.G_EXC_ERROR THEN

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

Line 557: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 559: p_encoded => FND_API.G_FALSE,

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

Line 563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 564: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 566: p_encoded => FND_API.G_FALSE,

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

Line 577: p_encoded => FND_API.G_FALSE,

573: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
574: fnd_message.set_token ('ERR_CD', SQLCODE);
575: FND_MSG_PUB.ADD;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_MSG_COUNT,
579: p_data => X_MSG_DATA);
580: ELSE
581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

577: p_encoded => FND_API.G_FALSE,
578: p_count => x_MSG_COUNT,
579: p_data => X_MSG_DATA);
580: ELSE
581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
584: FND_MSG_PUB.ADD;
585: FND_MSG_PUB.Count_And_Get(

Line 586: p_encoded => FND_API.G_FALSE,

582: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
584: FND_MSG_PUB.ADD;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589:
590: END IF;

Line 662: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

658: x_msg_count
659: );
660:
661: -- Initialize API return status to success.
662: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
663: -- Standard call to get message count and if count is 1, get message
664: -- info.
665: FND_MSG_PUB.Count_And_Get(
666: p_encoded => FND_API.G_FALSE,

Line 666: p_encoded => FND_API.G_FALSE,

662: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
663: -- Standard call to get message count and if count is 1, get message
664: -- info.
665: FND_MSG_PUB.Count_And_Get(
666: p_encoded => FND_API.G_FALSE,
667: p_count => x_MSG_COUNT,
668: p_data => X_MSG_DATA);
669:
670: EXCEPTION

Line 671: WHEN FND_API.G_EXC_ERROR THEN

667: p_count => x_MSG_COUNT,
668: p_data => X_MSG_DATA);
669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => FND_API.G_FALSE,
675: p_count => x_MSG_COUNT,

Line 672: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

668: p_data => X_MSG_DATA);
669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => FND_API.G_FALSE,
675: p_count => x_MSG_COUNT,
676: p_data => X_MSG_DATA);

Line 674: p_encoded => FND_API.G_FALSE,

670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => FND_API.G_FALSE,
675: p_count => x_MSG_COUNT,
676: p_data => X_MSG_DATA);
677: RETURN;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

674: p_encoded => FND_API.G_FALSE,
675: p_count => x_MSG_COUNT,
676: p_data => X_MSG_DATA);
677: RETURN;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.Count_And_Get(
681: p_encoded => FND_API.G_FALSE,
682: p_count => x_MSG_COUNT,

Line 679: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

675: p_count => x_MSG_COUNT,
676: p_data => X_MSG_DATA);
677: RETURN;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.Count_And_Get(
681: p_encoded => FND_API.G_FALSE,
682: p_count => x_MSG_COUNT,
683: p_data => X_MSG_DATA);

Line 681: p_encoded => FND_API.G_FALSE,

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

Line 686: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

682: p_count => x_MSG_COUNT,
683: p_data => X_MSG_DATA);
684: RETURN;
685: WHEN OTHERS THEN
686: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
687: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
688: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
689: FND_MSG_PUB.ADD;
690: FND_MSG_PUB.Count_And_Get(

Line 691: p_encoded => FND_API.G_FALSE,

687: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
688: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
689: FND_MSG_PUB.ADD;
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:

Line 742: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

738: END IF;
739:
740:
741: -- Initialize API return status to success.
742: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
743: -- Standard call to get message count and if count is 1, get message
744: -- info.
745: FND_MSG_PUB.Count_And_Get(
746: p_encoded => FND_API.G_FALSE,

Line 746: p_encoded => FND_API.G_FALSE,

742: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
743: -- Standard call to get message count and if count is 1, get message
744: -- info.
745: FND_MSG_PUB.Count_And_Get(
746: p_encoded => FND_API.G_FALSE,
747: p_count => x_MSG_COUNT,
748: p_data => X_MSG_DATA);
749:
750: EXCEPTION

Line 751: WHEN FND_API.G_EXC_ERROR THEN

747: p_count => x_MSG_COUNT,
748: p_data => X_MSG_DATA);
749:
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
753: FND_MSG_PUB.Count_And_Get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_MSG_COUNT,

Line 752: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

748: p_data => X_MSG_DATA);
749:
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
753: FND_MSG_PUB.Count_And_Get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_MSG_COUNT,
756: p_data => X_MSG_DATA);

Line 754: p_encoded => FND_API.G_FALSE,

750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
753: FND_MSG_PUB.Count_And_Get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_MSG_COUNT,
756: p_data => X_MSG_DATA);
757: RETURN;
758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

754: p_encoded => FND_API.G_FALSE,
755: p_count => x_MSG_COUNT,
756: p_data => X_MSG_DATA);
757: RETURN;
758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
759: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
760: FND_MSG_PUB.Count_And_Get(
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_MSG_COUNT,

Line 759: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

755: p_count => x_MSG_COUNT,
756: p_data => X_MSG_DATA);
757: RETURN;
758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
759: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
760: FND_MSG_PUB.Count_And_Get(
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_MSG_COUNT,
763: p_data => X_MSG_DATA);

Line 761: p_encoded => FND_API.G_FALSE,

757: RETURN;
758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
759: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
760: FND_MSG_PUB.Count_And_Get(
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_MSG_COUNT,
763: p_data => X_MSG_DATA);
764: RETURN;
765: WHEN OTHERS THEN

Line 766: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

762: p_count => x_MSG_COUNT,
763: p_data => X_MSG_DATA);
764: RETURN;
765: WHEN OTHERS THEN
766: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
768: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
769: FND_MSG_PUB.ADD;
770: FND_MSG_PUB.Count_And_Get(

Line 771: p_encoded => FND_API.G_FALSE,

767: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
768: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
769: FND_MSG_PUB.ADD;
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_MSG_COUNT,
773: p_data => X_MSG_DATA);
774: RETURN;
775: