DBA Data[Home] [Help]

APPS.IGS_AS_SUA_AI_GROUP_PKG dependencies on FND_MESSAGE

Line 56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

52: OPEN cur_old_ref_values;
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;

Line 113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

109: new_references.uoo_id,
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:

Line 163: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

159: new_references.person_id,
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:

Line 174: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

170: NULL;
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:

Line 185: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

181: NULL;
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:

Line 298: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

294: OPEN cur_rowid;
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;

Line 333: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

329: OPEN cur_rowid;
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;

Line 368: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

364: OPEN cur_rowid;
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;

Line 443: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

439: IF ( get_pk_for_validation(
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;

Line 459: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

455: IF ( get_pk_for_validation (
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;

Line 521: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

517: IF (x_last_update_login IS NULL) THEN
518: x_last_update_login := -1;
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;

Line 522: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.INSERT_ROW');

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

Line 605: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
605: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
606: IF (x_mode = 'S') THEN
607: igs_sc_gen_001.unset_ctx('R');
608: END IF;
609:

Line 610: fnd_message.set_token ('ERR_CD', SQLCODE);

606: IF (x_mode = 'S') THEN
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

Line 673: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

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

Line 698: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

694: AND ((tlinfo.logical_delete_date = x_logical_delete_date) OR ((tlinfo.logical_delete_date IS NULL) AND (x_logical_delete_date IS NULL)))
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:

Line 755: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

751: IF (x_last_update_login IS NULL) THEN
752: x_last_update_login := -1;
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;

Line 756: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.UPDATE_ROW');

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

Line 809: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

805: last_update_login = x_last_update_login
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;

Line 823: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

819:
820: EXCEPTION
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;

Line 824: fnd_message.set_token ('ERR_CD', SQLCODE);

820: EXCEPTION
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

Line 945: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

941: DELETE FROM igs_as_sua_ai_group
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;