APPS.IGF_AP_BATCH_AW_MAP_PKG dependencies on APP_EXCEPTION

Line 116: APP_EXCEPTION.RAISE_EXCEPTION;

112: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
113: CLOSE cur_old_ref_values;
114: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
115: IGS_GE_MSG_STACK.ADD;
116: APP_EXCEPTION.RAISE_EXCEPTION;
117: RETURN;
118: END IF;
119: CLOSE cur_old_ref_values;
120:

Line 180: APP_EXCEPTION.RAISE_EXCEPTION;

176: IF ( get_uk2_for_validation ( new_references.ci_cal_type,
177: new_references.ci_sequence_number )) THEN
178: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
179: IGS_GE_MSG_STACK.ADD;
180: APP_EXCEPTION.RAISE_EXCEPTION;
181: END IF;
182:
183: IF ( get_uk6_for_validation ( new_references.sys_award_year )) THEN
184: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line 186: APP_EXCEPTION.RAISE_EXCEPTION;

182:
183: IF ( get_uk6_for_validation ( new_references.sys_award_year )) THEN
184: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
185: IGS_GE_MSG_STACK.ADD;
186: APP_EXCEPTION.RAISE_EXCEPTION;
187: END IF;
188:
189: END check_uniqueness;
190:

Line 213: APP_EXCEPTION.RAISE_EXCEPTION;

209: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation ( new_references.ci_cal_type,
210: new_references.ci_sequence_number ) THEN
211: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
212: IGS_GE_MSG_STACK.ADD;
213: APP_EXCEPTION.RAISE_EXCEPTION;
214: END IF;
215:
216: END check_parent_existance;
217:

Line 354: APP_EXCEPTION.RAISE_EXCEPTION;

350: IF (cur_rowid%FOUND) THEN
351: CLOSE cur_rowid;
352: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_BAM_CI_FK');
353: IGS_GE_MSG_STACK.ADD;
354: APP_EXCEPTION.RAISE_EXCEPTION;
355: RETURN;
356: END IF;
357: CLOSE cur_rowid;
358:

Line 446: APP_EXCEPTION.RAISE_EXCEPTION;

442: -- Call all the procedures related to Before Insert.
443: IF ( get_pk_for_validation( new_references.bam_id )) THEN
444: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
445: IGS_GE_MSG_STACK.ADD;
446: APP_EXCEPTION.RAISE_EXCEPTION;
447: END IF;
448: check_uniqueness;
449: check_parent_existance;
450: ELSIF (p_action = 'UPDATE') THEN

Line 459: APP_EXCEPTION.RAISE_EXCEPTION;

455: -- Call all the procedures related to Before Insert.
456: IF ( get_pk_for_validation ( new_references.bam_id ) ) THEN
457: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
458: IGS_GE_MSG_STACK.ADD;
459: APP_EXCEPTION.RAISE_EXCEPTION;
460: END IF;
461: check_uniqueness;
462: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
463: check_uniqueness;

Line 538: APP_EXCEPTION.RAISE_EXCEPTION;

534: END IF;
535: ELSE
536: FND_MESSAGE.SET_NAME ('FND', 'SYSTEM-INVALID ARGS');
537: IGS_GE_MSG_STACK.ADD;
538: APP_EXCEPTION.RAISE_EXCEPTION;
539: END IF;
540:
541: SELECT igf_ap_batch_aw_map_all_s.NEXTVAL INTO x_bam_id FROM dual;
542:

Line 723: APP_EXCEPTION.RAISE_EXCEPTION;

719: IF (c1%notfound) THEN
720: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
721: IGS_GE_MSG_STACK.ADD;
722: CLOSE c1;
723: APP_EXCEPTION.RAISE_EXCEPTION;
724: RETURN;
725: END IF;
726: CLOSE c1;
727:

Line 753: APP_EXCEPTION.RAISE_EXCEPTION;

749: NULL;
750: ELSE
751: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
752: IGS_GE_MSG_STACK.ADD;
753: APP_EXCEPTION.RAISE_EXCEPTION;
754: END IF;
755:
756: RETURN;
757:

Line 822: APP_EXCEPTION.RAISE_EXCEPTION;

818: END IF;
819: ELSE
820: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
821: IGS_GE_MSG_STACK.ADD;
822: APP_EXCEPTION.RAISE_EXCEPTION;
823: END IF;
824:
825: before_dml(
826: p_action => 'UPDATE',