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

Line 103: RAISE FND_API.G_EXC_ERROR;

99: )
100: ) THEN
101: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
102: igs_ge_msg_stack.add;
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105:
106: END check_uniqueness;
107:

Line 334: RAISE FND_API.G_EXC_ERROR;

330: )
331: ) THEN
332: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
333: igs_ge_msg_stack.add;
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336: check_uniqueness;
337: check_parent_existance;
338: update_az_advising_rel;

Line 476: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

472: x_last_updated_by,
473: x_last_update_login
474: ) RETURNING ROWID, group_student_id INTO x_rowid, x_group_student_id;
475: -- Initialize API return status to success.
476: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
477: -- Standard call to get message count and if count is 1, get message
478: -- info.
479: FND_MSG_PUB.Count_And_Get(
480: p_encoded => FND_API.G_FALSE,

Line 480: p_encoded => FND_API.G_FALSE,

476: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
477: -- Standard call to get message count and if count is 1, get message
478: -- info.
479: FND_MSG_PUB.Count_And_Get(
480: p_encoded => FND_API.G_FALSE,
481: p_count => x_MSG_COUNT,
482: p_data => X_MSG_DATA);
483:
484: EXCEPTION

Line 485: WHEN FND_API.G_EXC_ERROR THEN

481: p_count => x_MSG_COUNT,
482: p_data => X_MSG_DATA);
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.Count_And_Get(
488: p_encoded => FND_API.G_FALSE,
489: p_count => x_MSG_COUNT,

Line 486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

482: p_data => X_MSG_DATA);
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.Count_And_Get(
488: p_encoded => FND_API.G_FALSE,
489: p_count => x_MSG_COUNT,
490: p_data => X_MSG_DATA);

Line 488: p_encoded => FND_API.G_FALSE,

484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.Count_And_Get(
488: p_encoded => FND_API.G_FALSE,
489: p_count => x_MSG_COUNT,
490: p_data => X_MSG_DATA);
491: RETURN;
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

488: p_encoded => FND_API.G_FALSE,
489: p_count => x_MSG_COUNT,
490: p_data => X_MSG_DATA);
491: RETURN;
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_MSG_COUNT,

Line 493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

489: p_count => x_MSG_COUNT,
490: p_data => X_MSG_DATA);
491: RETURN;
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_MSG_COUNT,
497: p_data => X_MSG_DATA);

Line 495: p_encoded => FND_API.G_FALSE,

491: RETURN;
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_MSG_COUNT,
497: p_data => X_MSG_DATA);
498: RETURN;
499: WHEN OTHERS THEN

Line 500: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

496: p_count => x_MSG_COUNT,
497: p_data => X_MSG_DATA);
498: RETURN;
499: WHEN OTHERS THEN
500: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
502: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
503: FND_MSG_PUB.ADD;
504: FND_MSG_PUB.Count_And_Get(

Line 505: p_encoded => FND_API.G_FALSE,

501: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
502: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
503: FND_MSG_PUB.ADD;
504: FND_MSG_PUB.Count_And_Get(
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_MSG_COUNT,
507: p_data => X_MSG_DATA);
508: RETURN;
509: END insert_row;

Line 562: RAISE FND_API.G_EXC_ERROR;

558: IF (c1%NOTFOUND) THEN
559: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
560: igs_ge_msg_stack.add;
561: CLOSE c1;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564: CLOSE c1;
565:
566: IF (

Line 581: RAISE FND_API.G_EXC_ERROR;

577: NULL;
578: ELSE
579: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
580: igs_ge_msg_stack.add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584:
585: -- Initialize API return status to success.

Line 586: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

582: END IF;
583:
584:
585: -- Initialize API return status to success.
586: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
587: -- Standard call to get message count and if count is 1, get message
588: -- info.
589: FND_MSG_PUB.Count_And_Get(
590: p_encoded => FND_API.G_FALSE,

Line 590: p_encoded => FND_API.G_FALSE,

586: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
587: -- Standard call to get message count and if count is 1, get message
588: -- info.
589: FND_MSG_PUB.Count_And_Get(
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_MSG_COUNT,
592: p_data => X_MSG_DATA);
593: RETURN;
594: EXCEPTION

Line 595: WHEN FND_API.G_EXC_ERROR THEN

591: p_count => x_MSG_COUNT,
592: p_data => X_MSG_DATA);
593: RETURN;
594: EXCEPTION
595: WHEN FND_API.G_EXC_ERROR THEN
596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
597: FND_MSG_PUB.Count_And_Get(
598: p_encoded => FND_API.G_FALSE,
599: p_count => x_MSG_COUNT,

Line 596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

592: p_data => X_MSG_DATA);
593: RETURN;
594: EXCEPTION
595: WHEN FND_API.G_EXC_ERROR THEN
596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
597: FND_MSG_PUB.Count_And_Get(
598: p_encoded => FND_API.G_FALSE,
599: p_count => x_MSG_COUNT,
600: p_data => X_MSG_DATA);

Line 598: p_encoded => FND_API.G_FALSE,

594: EXCEPTION
595: WHEN FND_API.G_EXC_ERROR THEN
596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
597: FND_MSG_PUB.Count_And_Get(
598: p_encoded => FND_API.G_FALSE,
599: p_count => x_MSG_COUNT,
600: p_data => X_MSG_DATA);
601: RETURN;
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

598: p_encoded => FND_API.G_FALSE,
599: p_count => x_MSG_COUNT,
600: p_data => X_MSG_DATA);
601: RETURN;
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_MSG_COUNT,

Line 603: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

599: p_count => x_MSG_COUNT,
600: p_data => X_MSG_DATA);
601: RETURN;
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_MSG_COUNT,
607: p_data => X_MSG_DATA);

Line 605: p_encoded => FND_API.G_FALSE,

601: RETURN;
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_MSG_COUNT,
607: p_data => X_MSG_DATA);
608: RETURN;
609: WHEN OTHERS THEN

Line 610: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

606: p_count => x_MSG_COUNT,
607: p_data => X_MSG_DATA);
608: RETURN;
609: WHEN OTHERS THEN
610: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
612: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
613: FND_MSG_PUB.ADD;
614: FND_MSG_PUB.Count_And_Get(

Line 615: p_encoded => FND_API.G_FALSE,

611: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
612: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
613: FND_MSG_PUB.ADD;
614: FND_MSG_PUB.Count_And_Get(
615: p_encoded => FND_API.G_FALSE,
616: p_count => x_MSG_COUNT,
617: p_data => X_MSG_DATA);
618: RETURN;
619:

Line 714: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

710: IF (SQL%NOTFOUND) THEN
711: RAISE NO_DATA_FOUND;
712: END IF;
713: -- Initialize API return status to success.
714: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
715: -- Standard call to get message count and if count is 1, get message
716: -- info.
717: FND_MSG_PUB.Count_And_Get(
718: p_encoded => FND_API.G_FALSE,

Line 718: p_encoded => FND_API.G_FALSE,

714: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
715: -- Standard call to get message count and if count is 1, get message
716: -- info.
717: FND_MSG_PUB.Count_And_Get(
718: p_encoded => FND_API.G_FALSE,
719: p_count => x_MSG_COUNT,
720: p_data => X_MSG_DATA);
721:
722: EXCEPTION

Line 723: WHEN FND_API.G_EXC_ERROR THEN

719: p_count => x_MSG_COUNT,
720: p_data => X_MSG_DATA);
721:
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get(
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_MSG_COUNT,

Line 724: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

720: p_data => X_MSG_DATA);
721:
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get(
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_MSG_COUNT,
728: p_data => X_MSG_DATA);

Line 726: p_encoded => FND_API.G_FALSE,

722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get(
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_MSG_COUNT,
728: p_data => X_MSG_DATA);
729: RETURN;
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

726: p_encoded => FND_API.G_FALSE,
727: p_count => x_MSG_COUNT,
728: p_data => X_MSG_DATA);
729: RETURN;
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_MSG_COUNT,

Line 731: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

727: p_count => x_MSG_COUNT,
728: p_data => X_MSG_DATA);
729: RETURN;
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_MSG_COUNT,
735: p_data => X_MSG_DATA);

Line 733: p_encoded => FND_API.G_FALSE,

729: RETURN;
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_MSG_COUNT,
735: p_data => X_MSG_DATA);
736: RETURN;
737: WHEN OTHERS THEN

Line 738: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

734: p_count => x_MSG_COUNT,
735: p_data => X_MSG_DATA);
736: RETURN;
737: WHEN OTHERS THEN
738: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
739: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
740: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
741: FND_MSG_PUB.ADD;
742: FND_MSG_PUB.Count_And_Get(

Line 743: p_encoded => FND_API.G_FALSE,

739: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
740: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
741: FND_MSG_PUB.ADD;
742: FND_MSG_PUB.Count_And_Get(
743: p_encoded => FND_API.G_FALSE,
744: p_count => x_MSG_COUNT,
745: p_data => X_MSG_DATA);
746: RETURN;
747:

Line 860: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

856: IF (SQL%NOTFOUND) THEN
857: RAISE NO_DATA_FOUND;
858: END IF;
859: -- Initialize API return status to success.
860: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
861: -- Standard call to get message count and if count is 1, get message
862: -- info.
863: FND_MSG_PUB.Count_And_Get(
864: p_encoded => FND_API.G_FALSE,

Line 864: p_encoded => FND_API.G_FALSE,

860: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
861: -- Standard call to get message count and if count is 1, get message
862: -- info.
863: FND_MSG_PUB.Count_And_Get(
864: p_encoded => FND_API.G_FALSE,
865: p_count => x_MSG_COUNT,
866: p_data => X_MSG_DATA);
867:
868: EXCEPTION

Line 869: WHEN FND_API.G_EXC_ERROR THEN

865: p_count => x_MSG_COUNT,
866: p_data => X_MSG_DATA);
867:
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,

Line 870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

866: p_data => X_MSG_DATA);
867:
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);

Line 872: p_encoded => FND_API.G_FALSE,

868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);
875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);
875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_And_Get(
879: p_encoded => FND_API.G_FALSE,
880: p_count => x_MSG_COUNT,

Line 877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);
875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_And_Get(
879: p_encoded => FND_API.G_FALSE,
880: p_count => x_MSG_COUNT,
881: p_data => X_MSG_DATA);

Line 879: p_encoded => FND_API.G_FALSE,

875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_And_Get(
879: p_encoded => FND_API.G_FALSE,
880: p_count => x_MSG_COUNT,
881: p_data => X_MSG_DATA);
882: RETURN;
883: WHEN OTHERS THEN

Line 884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

880: p_count => x_MSG_COUNT,
881: p_data => X_MSG_DATA);
882: RETURN;
883: WHEN OTHERS THEN
884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
886: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(

Line 889: p_encoded => FND_API.G_FALSE,

885: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
886: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_MSG_COUNT,
891: p_data => X_MSG_DATA);
892: RETURN;
893: