APPS.IGS_HE_POOUS_OU_ALL_PKG dependencies on IGS_GE_MSG_STACK

Line 55: igs_ge_msg_stack.add;

51: FETCH cur_old_ref_values INTO old_references;
52: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: igs_ge_msg_stack.add;
56: app_exception.raise_exception;
57: RETURN;
58: END IF;
59: CLOSE cur_old_ref_values;

Line 115: igs_ge_msg_stack.add;

111: new_references.organization_unit
112: )
113: ) THEN
114: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
119: END check_uniqueness;

Line 183: igs_ge_msg_stack.add;

179: new_references.attendance_mode,
180: new_references.attendance_type
181: ) THEN
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186:
187: IF((( old_references.unit_set_cd = new_references.unit_set_cd) AND

Line 198: igs_ge_msg_stack.add;

194: new_references.unit_set_cd,
195: new_references.us_version_number
196: )THEN
197: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
198: igs_ge_msg_stack.add;
199: app_exception.raise_exception;
200: END IF;
201:
202: --Added this check for unit sets in IGS_PS_OFR_OPT_UNIT_SET_V view

Line 215: IGS_GE_MSG_STACK.ADD;

211: FETCH cur_unitset_check INTO l_c_var;
212: IF cur_unitset_check%NOTFOUND THEN
213: CLOSE cur_unitset_check;
214: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: CLOSE cur_unitset_check;
219:

Line 363: igs_ge_msg_stack.add;

359: FETCH cur_rowid INTO lv_rowid;
360: IF (cur_rowid%FOUND) THEN
361: CLOSE cur_rowid;
362: fnd_message.set_name ('IGS', 'IGS_HE_HPOU_COO_FK');
363: igs_ge_msg_stack.add;
364: app_exception.raise_exception;
365: RETURN;
366: END IF;
367: CLOSE cur_rowid;

Line 399: igs_ge_msg_stack.add;

395: FETCH cur_rowid INTO lv_rowid;
396: IF (cur_rowid%FOUND) THEN
397: CLOSE cur_rowid;
398: fnd_message.set_name ('IGS', 'IGS_HE_HPOU_US_FK');
399: igs_ge_msg_stack.add;
400: app_exception.raise_exception;
401: RETURN;
402: END IF;
403: CLOSE cur_rowid;

Line 442: IGS_GE_MSG_STACK.ADD;

438: Fetch cur_rowid INTO lv_rowid;
439: IF (cur_rowid%FOUND) THEN
440: Close cur_rowid;
441: Fnd_Message.Set_Name ('IGS', 'IGS_HE_HPUD_US_FK');
442: IGS_GE_MSG_STACK.ADD;
443: App_Exception.Raise_Exception;
444: Return;
445: END IF;
446: Close cur_rowid;

Line 515: igs_ge_msg_stack.add;

511: new_references.hesa_poous_ou_id
512: )
513: ) THEN
514: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518: check_uniqueness;
519: check_parent_existance;

Line 534: igs_ge_msg_stack.add;

530: new_references.hesa_poous_ou_id
531: )
532: ) THEN
533: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
534: igs_ge_msg_stack.add;
535: app_exception.raise_exception;
536: END IF;
537: check_uniqueness;
538: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 600: igs_ge_msg_stack.add;

596: x_last_update_login := -1;
597: END IF;
598: ELSE
599: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
600: igs_ge_msg_stack.add;
601: app_exception.raise_exception;
602: END IF;
603:
604: SELECT igs_he_poous_ou_all_s.NEXTVAL

Line 729: igs_ge_msg_stack.add;

725: OPEN c1;
726: FETCH c1 INTO tlinfo;
727: IF (c1%notfound) THEN
728: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
729: igs_ge_msg_stack.add;
730: CLOSE c1;
731: app_exception.raise_exception;
732: RETURN;
733: END IF;

Line 751: igs_ge_msg_stack.add;

747: ) THEN
748: NULL;
749: ELSE
750: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
751: igs_ge_msg_stack.add;
752: app_exception.raise_exception;
753: END IF;
754:
755: RETURN;

Line 808: igs_ge_msg_stack.add;

804: x_last_update_login := -1;
805: END IF;
806: ELSE
807: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
808: igs_ge_msg_stack.add;
809: app_exception.raise_exception;
810: END IF;
811:
812: before_dml(