APPS.IGS_PE_VISIT_HISTRY_PKG dependencies on APP_EXCEPTION

Line 71: app_exception.raise_exception;

67: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
68: CLOSE cur_old_ref_values;
69: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
70: igs_ge_msg_stack.add;
71: app_exception.raise_exception;
72: RETURN;
73: END IF;
74: CLOSE cur_old_ref_values;
75:

Line 140: app_exception.raise_exception;

136: new_references.visa_id
137: ) THEN
138: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
139: igs_ge_msg_stack.add;
140: app_exception.raise_exception;
141: END IF;
142:
143: END check_parent_existance;
144:

Line 175: APP_EXCEPTION.RAISE_EXCEPTION;

171: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
172: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
173: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
174: IGS_GE_MSG_STACK.ADD;
175: APP_EXCEPTION.RAISE_EXCEPTION;
176: END IF;
177: END IF;
178:
179: IF p_updating THEN

Line 194: APP_EXCEPTION.RAISE_EXCEPTION;

190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_POE_VISA_OVERLAP');
191: FND_MESSAGE.SET_TOKEN('VISA_ISSUE', visa_dtl_rec.visa_issue_date);
192: FND_MESSAGE.SET_TOKEN('VISA_EXP', visa_dtl_rec.visa_expiry_date + 30);
193: IGS_GE_MSG_STACK.ADD;
194: APP_EXCEPTION.RAISE_EXCEPTION;
195: END IF;
196: END IF;
197: END IF;
198:

Line 203: APP_EXCEPTION.RAISE_EXCEPTION;

199: IF p_inserting OR p_updating THEN
200: IF new_references.visit_start_date > new_references.visit_end_date THEN
201: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_FROM_DT_GRT_TO_DATE');
202: IGS_GE_MSG_STACK.ADD;
203: APP_EXCEPTION.RAISE_EXCEPTION;
204: END IF;
205: END IF;
206: END beforerowinsertupdate;
207:

Line 273: app_exception.raise_exception;

269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: RETURN;
275: END IF;
276: CLOSE cur_rowid;
277:

Line 376: app_exception.raise_exception;

372: )
373: ) THEN
374: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');
375: igs_ge_msg_stack.add;
376: app_exception.raise_exception;
377: END IF;
378: check_parent_existance;
379: ELSIF (p_action = 'UPDATE') THEN
380: -- Call all the procedures related to Before Update.

Line 392: app_exception.raise_exception;

388: )
389: ) THEN
390: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394: END IF;
395:
396: END before_dml;

Line 444: APP_EXCEPTION.RAISE_EXCEPTION;

440:
441: IF l_count > 0 THEN
442: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PORT_DATE_OVERLAP');
443: IGS_GE_MSG_STACK.ADD;
444: APP_EXCEPTION.RAISE_EXCEPTION;
445: END IF;
446:
447: END afterrowinsertupdate;
448:

Line 549: app_exception.raise_exception;

545: END IF;
546: ELSE
547: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
548: igs_ge_msg_stack.add;
549: app_exception.raise_exception;
550: END IF;
551:
552: before_dml(
553: p_action => 'INSERT',

Line 745: app_exception.raise_exception;

741: IF (c1%notfound) THEN
742: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
743: igs_ge_msg_stack.add;
744: CLOSE c1;
745: app_exception.raise_exception;
746: RETURN;
747: END IF;
748: CLOSE c1;
749:

Line 781: app_exception.raise_exception;

777: NULL;
778: ELSE
779: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
780: igs_ge_msg_stack.add;
781: app_exception.raise_exception;
782: END IF;
783:
784: RETURN;
785:

Line 861: app_exception.raise_exception;

857: END IF;
858: ELSE
859: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
860: igs_ge_msg_stack.add;
861: app_exception.raise_exception;
862: END IF;
863:
864: before_dml(
865: p_action => 'UPDATE',

Line 907: app_exception.raise_exception;

903: IF cur_rowid%FOUND THEN
904: CLOSE cur_rowid;
905: fnd_message.set_name('IGS','IGS_PE_PORT_DUP_EXISTS');
906: igs_ge_msg_stack.add;
907: app_exception.raise_exception;
908: END IF;
909:
910: CLOSE cur_rowid;
911: