APPS.IGS_EN_TIMESLOT_CONF_PKG dependencies on IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.ADD;

44: FETCH cur_old_ref_values INTO old_references;
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;

Line 92: igs_ge_msg_stack.ADD;

88: new_references.timeslot_name
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 (

Line 102: igs_ge_msg_stack.ADD;

98: new_references.end_dt_alias
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;

Line 145: igs_ge_msg_stack.ADD;

141: ELSIF NOT igs_ca_da_pkg.get_pk_for_validation (
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

Line 156: igs_ge_msg_stack.ADD;

152: ELSIF NOT igs_ca_da_pkg.get_pk_for_validation (
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;

Line 297: igs_ge_msg_stack.ADD;

293: FETCH cur_rowid INTO lv_rowid;
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;

Line 354: igs_ge_msg_stack.ADD;

350: new_references.igs_en_timeslot_conf_id
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;

Line 372: igs_ge_msg_stack.ADD;

368: new_references.igs_en_timeslot_conf_id
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

Line 432: igs_ge_msg_stack.ADD;

428: x_last_update_login := -1;
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;

Line 521: igs_ge_msg_stack.ADD;

517: OPEN c1;
518: FETCH c1 INTO tlinfo;
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;

Line 536: igs_ge_msg_stack.ADD;

532: ) THEN
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;

Line 583: igs_ge_msg_stack.ADD;

579: x_last_update_login := -1;
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(