APPS.IGS_ADMAPPLICATION_PUB dependencies on APP_EXCEPTION

Line 760: APP_EXCEPTION.RAISE_EXCEPTION;

756: IF l_decision_make_id IS NULL THEN
757: IF l_s_adm_outcome_status NOT IN ('PENDING') THEN
758: fnd_message.set_name('IGS', 'IGS_AD_INVALID_DECISION_ID');
759: IGS_GE_MSG_STACK.ADD;
760: APP_EXCEPTION.RAISE_EXCEPTION;
761: END IF;
762: ELSIF l_decision_make_id = p_person_id THEN
763: fnd_message.set_name('IGS', 'IGS_AD_INVALID_DECISION_ID');
764: IGS_GE_MSG_STACK.ADD;

Line 765: APP_EXCEPTION.RAISE_EXCEPTION;

761: END IF;
762: ELSIF l_decision_make_id = p_person_id THEN
763: fnd_message.set_name('IGS', 'IGS_AD_INVALID_DECISION_ID');
764: IGS_GE_MSG_STACK.ADD;
765: APP_EXCEPTION.RAISE_EXCEPTION;
766: ELSIF NOT igs_ad_val_acai.genp_val_staff_fculty_prsn
767: (l_decision_make_id, v_message_name) THEN
768: fnd_message.set_name('IGS', v_message_name);
769: IGS_GE_MSG_STACK.ADD;

Line 770: APP_EXCEPTION.RAISE_EXCEPTION;

766: ELSIF NOT igs_ad_val_acai.genp_val_staff_fculty_prsn
767: (l_decision_make_id, v_message_name) THEN
768: fnd_message.set_name('IGS', v_message_name);
769: IGS_GE_MSG_STACK.ADD;
770: APP_EXCEPTION.RAISE_EXCEPTION;
771: END IF;
772: -- Validate decision Date
773: IF l_decision_date IS NULL AND l_s_adm_outcome_status NOT IN ('PENDING') THEN
774: fnd_message.set_name('IGS', 'IGS_AD_MAND_DECISION_INFO');

Line 776: APP_EXCEPTION.RAISE_EXCEPTION;

772: -- Validate decision Date
773: IF l_decision_date IS NULL AND l_s_adm_outcome_status NOT IN ('PENDING') THEN
774: fnd_message.set_name('IGS', 'IGS_AD_MAND_DECISION_INFO');
775: IGS_GE_MSG_STACK.ADD;
776: APP_EXCEPTION.RAISE_EXCEPTION;
777: ELSE
778: -- Decision date should be between the application date and the system date
779: IF NOT l_decision_date BETWEEN l_c_appl_cur.appl_dt AND SYSDATE THEN
780: fnd_message.set_name('IGS', 'IGS_AD_DECISION_DATE');

Line 782: APP_EXCEPTION.RAISE_EXCEPTION;

778: -- Decision date should be between the application date and the system date
779: IF NOT l_decision_date BETWEEN l_c_appl_cur.appl_dt AND SYSDATE THEN
780: fnd_message.set_name('IGS', 'IGS_AD_DECISION_DATE');
781: IGS_GE_MSG_STACK.ADD;
782: APP_EXCEPTION.RAISE_EXCEPTION;
783: END IF;
784: END IF;
785:
786: --Validate Decision Reason

Line 792: APP_EXCEPTION.RAISE_EXCEPTION;

788: l_s_adm_outcome_status NOT IN ('PENDING')
789: THEN
790: fnd_message.set_name('IGS', 'IGS_AD_DECISION_REASON_INVALID');
791: IGS_GE_MSG_STACK.ADD;
792: APP_EXCEPTION.RAISE_EXCEPTION;
793: END IF;
794:
795: -- ==============================================================
796:

Line 804: APP_EXCEPTION.RAISE_EXCEPTION;

800: l_s_adm_outcome_status IN ('PENDING') AND
801: l_c_aplinst_cur.adm_outcome_status <> l_adm_outcome_status_reason THEN
802: fnd_message.set_name('IGS', 'IGS_AD_PENDING_REASON_INVALID');
803: IGS_GE_MSG_STACK.ADD;
804: APP_EXCEPTION.RAISE_EXCEPTION;
805: END IF;
806:
807: IF l_s_adm_outcome_status IN ('OFFER', 'COND-OFFER') THEN
808: IF (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN

Line 927: APP_EXCEPTION.RAISE_EXCEPTION;

923: IF lv_return_status = 'N'
924: THEN
925: FND_MESSAGE.SET_NAME('IGS', lv_msg_nme);
926: IGS_GE_MSG_STACK.ADD;
927: APP_EXCEPTION.RAISE_EXCEPTION;
928: END IF;
929:
930: igs_ad_ps_appl_pkg.update_row(x_rowid => l_c_ps_appl_cur.row_id,
931: x_person_id => l_c_ps_appl_cur.person_id,

Line 1404: APP_EXCEPTION.RAISE_EXCEPTION;

1400: IF l_acaiv_rec.person_id IS NULL THEN
1401: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
1402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
1403: IGS_GE_MSG_STACK.ADD;
1404: APP_EXCEPTION.RAISE_EXCEPTION;
1405: END IF;
1406:
1407:
1408: -- begin apadegal adtd001 igs.m

Line 1886: App_Exception.Raise_Exception;

1882: )
1883: THEN
1884:
1885:
1886: App_Exception.Raise_Exception;
1887:
1888: END IF;
1889: END IF;
1890: