DBA Data[Home] [Help]

APPS.IGF_AW_TARGET_GRP_PKG dependencies on APP_EXCEPTION

Line 79: app_exception.raise_exception;

75: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
76: CLOSE cur_old_ref_values;
77: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
78: igs_ge_msg_stack.add;
79: app_exception.raise_exception;
80: RETURN;
81: END IF;
82: CLOSE cur_old_ref_values;
83:

Line 154: app_exception.raise_exception;

150: NULL;
151: ELSIF NOT igf_aw_awd_dist_plans_pkg.get_pk_for_validation(new_references.adplans_id) THEN
152: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
153: igs_ge_msg_stack.add;
154: app_exception.raise_exception;
155: END IF;
156: END check_parent_existance;
157:
158: PROCEDURE check_uniqueness AS

Line 179: app_exception.raise_exception;

175: )
176: ) THEN
177: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181:
182: END check_uniqueness;
183:

Line 398: app_exception.raise_exception;

394: )
395: ) THEN
396: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400: check_uniqueness;
401: check_parent_existance;
402: ELSIF (p_action = 'UPDATE') THEN

Line 417: app_exception.raise_exception;

413: )
414: ) THEN
415: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: END IF;
419: check_uniqueness;
420: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
421: check_uniqueness;

Line 459: app_exception.raise_exception;

455: IF (cur_rowid%FOUND) THEN
456: CLOSE cur_rowid;
457: fnd_message.set_name ('IGF', 'IGF_AW_TGRP_ADPLANS_FK');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception;
460: RETURN;
461: END IF;
462: CLOSE cur_rowid;
463:

Line 541: app_exception.raise_exception;

537: END IF;
538: ELSE
539: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
540: igs_ge_msg_stack.add;
541: app_exception.raise_exception;
542: END IF;
543:
544: SELECT igf_aw_target_grp_all_s.NEXTVAL
545: INTO x_tgrp_id

Line 781: app_exception.raise_exception;

777: IF (c1%notfound) THEN
778: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
779: igs_ge_msg_stack.add;
780: CLOSE c1;
781: app_exception.raise_exception;
782: RETURN;
783: END IF;
784: CLOSE c1;
785:

Line 822: app_exception.raise_exception;

818: NULL;
819: ELSE
820: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
821: igs_ge_msg_stack.add;
822: app_exception.raise_exception;
823: END IF;
824:
825: RETURN;
826:

Line 900: app_exception.raise_exception;

896: END IF;
897: ELSE
898: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
899: igs_ge_msg_stack.add;
900: app_exception.raise_exception;
901: END IF;
902:
903: before_dml(
904: p_action => 'UPDATE',