DBA Data[Home] [Help]

APPS.IGS_EN_SVS_AUTH_PKG dependencies on APP_EXCEPTION

Line 64: app_exception.raise_exception;

60: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
61: CLOSE cur_old_ref_values;
62: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
63: igs_ge_msg_stack.add;
64: app_exception.raise_exception;
65: RETURN;
66: END IF;
67: CLOSE cur_old_ref_values;
68:

Line 123: app_exception.raise_exception;

119: )
120: ) THEN
121: fnd_message.set_name ('IGS', 'IGS_EN_SVS_AUTH_CD_REPEAT');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125: END IF;
126:
127: END check_uniqueness;

Line 147: app_exception.raise_exception;

143: new_references.person_id
144: ) THEN
145: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
146: igs_ge_msg_stack.add;
147: app_exception.raise_exception;
148: END IF;
149:
150: END check_parent_existance;
151:

Line 324: app_exception.raise_exception;

320: )
321: ) THEN
322: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325: END IF;
326: check_uniqueness;
327: check_parent_existance;
328: ELSIF (p_action = 'UPDATE') THEN

Line 343: app_exception.raise_exception;

339: )
340: ) THEN
341: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
342: igs_ge_msg_stack.add;
343: app_exception.raise_exception;
344: END IF;
345: check_uniqueness;
346: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
347: check_uniqueness;

Line 360: app_exception.raise_exception;

356: l_no_of_months) THEN
357: FND_MESSAGE.Set_name('IGS', 'IGS_EN_AUTH_PERIOD_VAL');
358: FND_MESSAGE.Set_token('N',l_no_of_months );
359: igs_ge_msg_stack.add;
360: app_exception.raise_exception;
361: END IF;
362: END IF;
363:
364: IF (p_action = 'UPDATE') AND new_references.cancel_flag = 'Y'

Line 433: app_exception.raise_exception;

429: ELSE
430: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
431: fnd_message.set_token ('ROUTINE', 'IGS_EN_SVS_AUTH_PKG.INSERT_ROW');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435:
436: x_sevis_auth_id := NULL;
437:

Line 541: app_exception.raise_exception;

537: IF (c1%notfound) THEN
538: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
539: igs_ge_msg_stack.add;
540: CLOSE c1;
541: app_exception.raise_exception;
542: RETURN;
543: END IF;
544: CLOSE c1;
545:

Line 559: app_exception.raise_exception;

555: NULL;
556: ELSE
557: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
558: igs_ge_msg_stack.add;
559: app_exception.raise_exception;
560: END IF;
561:
562: RETURN;
563:

Line 615: app_exception.raise_exception;

611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: fnd_message.set_token ('ROUTINE', 'IGS_EN_SVS_AUTH_PKG.UPDATE_ROW');
614: igs_ge_msg_stack.add;
615: app_exception.raise_exception;
616: END IF;
617:
618: before_dml(
619: p_action => 'UPDATE',