APPS.IGS_EN_TIMESLOT_CONF_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) AND l_rowid IS NOT NULL THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.ADD;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:

Line 93: app_exception.raise_exception;

89: )
90: ) THEN
91: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
92: igs_ge_msg_stack.ADD;
93: app_exception.raise_exception;
94: END IF;
95:
96: IF ( get_uk2_for_validation (
97: new_references.start_dt_alias,

Line 103: app_exception.raise_exception;

99: )
100: ) THEN
101: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
102: igs_ge_msg_stack.ADD;
103: app_exception.raise_exception;
104: END IF;
105:
106: END check_uniqueness;
107:

Line 146: app_exception.raise_exception;

142: new_references.start_dt_alias
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.ADD;
146: app_exception.raise_exception;
147: END IF;
148:
149: IF (((old_references.end_dt_alias = new_references.end_dt_alias)) OR
150: ((new_references.end_dt_alias IS NULL))) THEN

Line 157: app_exception.raise_exception;

153: new_references.end_dt_alias
154: ) THEN
155: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
156: igs_ge_msg_stack.ADD;
157: app_exception.raise_exception;
158: END IF;
159:
160: END check_parent_existance;
161:

Line 298: app_exception.raise_exception;

294: IF (cur_rowid%FOUND) THEN
295: CLOSE cur_rowid;
296: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
297: igs_ge_msg_stack.ADD;
298: app_exception.raise_exception;
299: RETURN;
300: END IF;
301: CLOSE cur_rowid;
302:

Line 355: app_exception.raise_exception;

351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.ADD;
355: app_exception.raise_exception;
356: END IF;
357: check_uniqueness;
358: check_parent_existance;
359: ELSIF (p_action = 'UPDATE') THEN

Line 373: app_exception.raise_exception;

369: )
370: ) THEN
371: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
372: igs_ge_msg_stack.ADD;
373: app_exception.raise_exception;
374: END IF;
375: check_uniqueness;
376: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
377: check_uniqueness;

Line 433: app_exception.raise_exception;

429: END IF;
430: ELSE
431: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
432: igs_ge_msg_stack.ADD;
433: app_exception.raise_exception;
434: END IF;
435: --Select Next value from sequnce IGS_EN_TIMESLOT_CONF_S for the Primary key to be inserted.
436: SELECT IGS_EN_TIMESLOT_CONF_S.NEXTVAL INTO x_igs_en_timeslot_conf_id FROM DUAL;
437:

Line 523: app_exception.raise_exception;

519: IF (c1%NOTFOUND) THEN
520: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
521: igs_ge_msg_stack.ADD;
522: CLOSE c1;
523: app_exception.raise_exception;
524: RETURN;
525: END IF;
526: CLOSE c1;
527:

Line 537: app_exception.raise_exception;

533: NULL;
534: ELSE
535: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
536: igs_ge_msg_stack.ADD;
537: app_exception.raise_exception;
538: END IF;
539:
540: RETURN;
541:

Line 584: app_exception.raise_exception;

580: END IF;
581: ELSE
582: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
583: igs_ge_msg_stack.ADD;
584: app_exception.raise_exception;
585: END IF;
586:
587: before_dml(
588: p_action => 'UPDATE',