APPS.IGF_SL_LOANS_PKG dependencies on APP_EXCEPTION

Line 65: APP_EXCEPTION.RAISE_EXCEPTION;

61: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
62: CLOSE cur_old_ref_values;
63: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
64: IGS_GE_MSG_STACK.ADD;
65: APP_EXCEPTION.RAISE_EXCEPTION;
66: RETURN;
67: END IF;
68: CLOSE cur_old_ref_values;
69:

Line 120: APP_EXCEPTION.RAISE_EXCEPTION;

116:
117: IF ( get_uk_for_validation ( new_references.loan_number )) THEN
118: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
119: IGS_GE_MSG_STACK.ADD;
120: APP_EXCEPTION.RAISE_EXCEPTION;
121: END IF;
122:
123: IF ( get_uk2_for_validation ( new_references.award_id ) ) THEN
124: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line 126: APP_EXCEPTION.RAISE_EXCEPTION;

122:
123: IF ( get_uk2_for_validation ( new_references.award_id ) ) THEN
124: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: IGS_GE_MSG_STACK.ADD;
126: APP_EXCEPTION.RAISE_EXCEPTION;
127: END IF;
128:
129: END check_uniqueness;
130:

Line 152: APP_EXCEPTION.RAISE_EXCEPTION;

148: NULL;
149: ELSIF NOT igf_aw_award_pkg.get_pk_for_validation ( new_references.award_id ) THEN
150: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
151: IGS_GE_MSG_STACK.ADD;
152: APP_EXCEPTION.RAISE_EXCEPTION;
153: END IF;
154:
155: IF (((old_references.borw_detrm_code = new_references.borw_detrm_code)) OR
156: ((new_references.borw_detrm_code IS NULL))) THEN

Line 161: APP_EXCEPTION.RAISE_EXCEPTION;

157: NULL;
158: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation( 'IGS_FI_BORW_DETRM', new_references.borw_detrm_code ) THEN
159: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: END IF;
163: END check_parent_existance;
164:
165:

Line 334: APP_EXCEPTION.RAISE_EXCEPTION;

330: IF (cur_rowid%FOUND) THEN
331: CLOSE cur_rowid;
332: FND_MESSAGE.SET_NAME ('IGF', 'IGF_SL_LAR_AWD_FK');
333: IGS_GE_MSG_STACK.ADD;
334: APP_EXCEPTION.RAISE_EXCEPTION;
335: RETURN;
336: END IF;
337: CLOSE cur_rowid;
338:

Line 384: app_exception.raise_exception;

380: );
381: IF l_v_message_name IS NOT NULL THEN
382: fnd_message.set_name ('IGS',l_v_message_name);
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: -- bvisvana - FA 161 - Bug 5091643 and 5006587
387: --tsailaja - FA 163 --Bug 5337555
388: IF l_v_fed_fund_code IN ('FLS','FLU','FLP','ALT','GPLUSFL') THEN

Line 412: app_exception.raise_exception;

408: igf_sl_cl_chg_prc.parse_tokens(
409: p_t_message_tokens => igf_sl_cl_chg_prc.g_message_tokens);
410:
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414: END IF;
415: END IF;
416: END IF;

Line 579: APP_EXCEPTION.RAISE_EXCEPTION;

575: -- Call all the procedures related to Before Insert.
576: IF ( get_pk_for_validation( new_references.loan_id ) ) THEN
577: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
578: IGS_GE_MSG_STACK.ADD;
579: APP_EXCEPTION.RAISE_EXCEPTION;
580: END IF;
581: check_uniqueness;
582: check_parent_existance;
583: ELSIF (p_action = 'UPDATE') THEN

Line 595: APP_EXCEPTION.RAISE_EXCEPTION;

591: -- Call all the procedures related to Before Insert.
592: IF ( get_pk_for_validation ( new_references.loan_id ) ) THEN
593: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
594: IGS_GE_MSG_STACK.ADD;
595: APP_EXCEPTION.RAISE_EXCEPTION;
596: END IF;
597: check_uniqueness;
598: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
599: check_uniqueness;

Line 708: APP_EXCEPTION.RAISE_EXCEPTION;

704: END IF;
705: ELSE
706: FND_MESSAGE.SET_NAME ('FND', 'SYSTEM-INVALID ARGS');
707: IGS_GE_MSG_STACK.ADD;
708: APP_EXCEPTION.RAISE_EXCEPTION;
709: END IF;
710:
711: SELECT igf_sl_loans_s.nextval INTO x_loan_id FROM DUAL;
712:

Line 864: APP_EXCEPTION.RAISE_EXCEPTION;

860: IF (c1%notfound) THEN
861: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
862: IGS_GE_MSG_STACK.ADD;
863: CLOSE c1;
864: APP_EXCEPTION.RAISE_EXCEPTION;
865: RETURN;
866: END IF;
867: CLOSE c1;
868:

Line 891: APP_EXCEPTION.RAISE_EXCEPTION;

887: NULL;
888: ELSE
889: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
890: IGS_GE_MSG_STACK.ADD;
891: APP_EXCEPTION.RAISE_EXCEPTION;
892: END IF;
893:
894: RETURN;
895:

Line 957: APP_EXCEPTION.RAISE_EXCEPTION;

953: END IF;
954: ELSE
955: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
956: IGS_GE_MSG_STACK.ADD;
957: APP_EXCEPTION.RAISE_EXCEPTION;
958: END IF;
959:
960: before_dml(
961: p_action => 'UPDATE',