DBA Data[Home] [Help]

APPS.IGS_AS_SUA_AI_GROUP_PKG dependencies on IGS_GE_MSG_STACK

Line 57: igs_ge_msg_stack.add;

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

Line 114: igs_ge_msg_stack.add;

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

Line 164: igs_ge_msg_stack.add;

160: new_references.course_cd,
161: new_references.uoo_id
162: ) THEN
163: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END IF;
167:
168: IF (((old_references.unit_ass_item_group_id = new_references.unit_ass_item_group_id)) OR

Line 175: igs_ge_msg_stack.add;

171: ELSIF NOT igs_as_unit_ai_grp_pkg.get_pk_for_validation (
172: new_references.unit_ass_item_group_id
173: ) THEN
174: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178:
179: IF (((old_references.us_ass_item_group_id = new_references.us_ass_item_group_id)) OR

Line 186: igs_ge_msg_stack.add;

182: ELSIF NOT igs_as_us_ai_group_pkg.get_pk_for_validation (
183: new_references.us_ass_item_group_id
184: ) THEN
185: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189:
190: END check_parent_existance;

Line 299: igs_ge_msg_stack.add;

295: FETCH cur_rowid INTO lv_rowid;
296: IF (cur_rowid%FOUND) THEN
297: CLOSE cur_rowid;
298: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: RETURN;
302: END IF;
303: CLOSE cur_rowid;

Line 334: igs_ge_msg_stack.add;

330: FETCH cur_rowid INTO lv_rowid;
331: IF (cur_rowid%FOUND) THEN
332: CLOSE cur_rowid;
333: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: RETURN;
337: END IF;
338: CLOSE cur_rowid;

Line 369: igs_ge_msg_stack.add;

365: FETCH cur_rowid INTO lv_rowid;
366: IF (cur_rowid%FOUND) THEN
367: CLOSE cur_rowid;
368: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: RETURN;
372: END IF;
373: CLOSE cur_rowid;

Line 444: igs_ge_msg_stack.add;

440: new_references.sua_ass_item_group_id
441: )
442: ) THEN
443: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447: check_uniqueness;
448: check_parent_existance;

Line 460: igs_ge_msg_stack.add;

456: new_references.sua_ass_item_group_id
457: )
458: ) THEN
459: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
460: igs_ge_msg_stack.add;
461: app_exception.raise_exception;
462: END IF;
463: check_uniqueness;
464: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 523: igs_ge_msg_stack.add;

519: END IF;
520: ELSE
521: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
522: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.INSERT_ROW');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526:
527: x_sua_ass_item_group_id := NULL;

Line 611: igs_ge_msg_stack.add;

607: igs_sc_gen_001.unset_ctx('R');
608: END IF;
609:
610: fnd_message.set_token ('ERR_CD', SQLCODE);
611: igs_ge_msg_stack.add;
612: igs_sc_gen_001.unset_ctx('R');
613: app_exception.raise_exception;
614: ELSE
615: igs_sc_gen_001.unset_ctx('R');

Line 674: igs_ge_msg_stack.add;

670: OPEN c1;
671: FETCH c1 INTO tlinfo;
672: IF (c1%notfound) THEN
673: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
674: igs_ge_msg_stack.add;
675: CLOSE c1;
676: app_exception.raise_exception;
677: RETURN;
678: END IF;

Line 699: igs_ge_msg_stack.add;

695: ) THEN
696: NULL;
697: ELSE
698: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
699: igs_ge_msg_stack.add;
700: app_exception.raise_exception;
701: END IF;
702:
703: RETURN;

Line 757: igs_ge_msg_stack.add;

753: END IF;
754: ELSE
755: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
756: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.UPDATE_ROW');
757: igs_ge_msg_stack.add;
758: app_exception.raise_exception;
759: END IF;
760:
761: before_dml(

Line 810: igs_ge_msg_stack.add;

806: WHERE rowid = x_rowid;
807:
808: IF (SQL%NOTFOUND) THEN
809: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
810: igs_ge_msg_stack.add;
811: igs_sc_gen_001.unset_ctx('R');
812: app_exception.raise_exception;
813: END IF;
814: IF (x_mode = 'S') THEN

Line 825: igs_ge_msg_stack.add;

821: WHEN OTHERS THEN
822: IF (SQLCODE = (-28115)) THEN
823: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
824: fnd_message.set_token ('ERR_CD', SQLCODE);
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: ELSE
829: igs_sc_gen_001.unset_ctx('R');

Line 946: igs_ge_msg_stack.add;

942: WHERE rowid = x_rowid;
943:
944: IF (SQL%NOTFOUND) THEN
945: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
946: igs_ge_msg_stack.add;
947: igs_sc_gen_001.unset_ctx('R');
948: app_exception.raise_exception;
949: END IF;
950: IF (x_mode = 'S') THEN