DBA Data[Home] [Help]

APPS.IGS_AS_SUA_AI_GROUP_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

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;
62:

Line 115: app_exception.raise_exception;

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;
119:

Line 165: app_exception.raise_exception;

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
169: ((new_references.unit_ass_item_group_id IS NULL))) THEN

Line 176: app_exception.raise_exception;

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
180: ((new_references.us_ass_item_group_id IS NULL))) THEN

Line 187: app_exception.raise_exception;

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;
191:

Line 300: app_exception.raise_exception;

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;
304:

Line 335: app_exception.raise_exception;

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;
339:

Line 370: app_exception.raise_exception;

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;
374:

Line 445: app_exception.raise_exception;

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;
449: ELSIF (p_action = 'UPDATE') THEN

Line 461: app_exception.raise_exception;

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
465: check_uniqueness;

Line 524: app_exception.raise_exception;

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;
528:

Line 613: app_exception.raise_exception;

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');
616: RAISE;
617: END IF;

Line 676: app_exception.raise_exception;

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;
679: CLOSE c1;
680:

Line 700: app_exception.raise_exception;

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;
704:

Line 758: app_exception.raise_exception;

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(
762: p_action => 'UPDATE',

Line 812: app_exception.raise_exception;

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
815: igs_sc_gen_001.unset_ctx('R');
816: END IF;

Line 827: app_exception.raise_exception;

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');
830: RAISE;
831: END IF;

Line 948: app_exception.raise_exception;

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
951: igs_sc_gen_001.unset_ctx('R');
952: END IF;