APPS.IGF_AP_ISIR_CORR_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 104: app_exception.raise_exception;

100: )
101: ) THEN
102: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
103: igs_ge_msg_stack.add;
104: app_exception.raise_exception;
105: END IF;
106:
107: END check_uniqueness;
108:

Line 130: app_exception.raise_exception;

126: new_references.isir_id
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132:
133: IF (((old_references.ci_cal_type = new_references.ci_cal_type) AND
134: (old_references.ci_sequence_number = new_references.ci_sequence_number)) OR

Line 144: app_exception.raise_exception;

140: new_references.ci_sequence_number
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: END check_parent_existance;
148:

Line 267: app_exception.raise_exception;

263: CLOSE c_non_ack_corr_count;
264: IF l_non_ack_corr_count <> 0 THEN
265: fnd_message.set_name ('IGF', 'IGF_AP_ISIRC_ISIRM_FK');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: RETURN;
269: ELSE
270: WHILE cur_rowid%FOUND LOOP
271: igf_ap_isir_corr_pkg.delete_row(lv_rowid.rowid);

Line 310: app_exception.raise_exception;

306: IF (cur_rowid%FOUND) THEN
307: CLOSE cur_rowid;
308: fnd_message.set_name ('IGF', 'IGF_AP_ISIRC_CI_FK');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: RETURN;
312: END IF;
313: CLOSE cur_rowid;
314:

Line 375: app_exception.raise_exception;

371: )
372: ) THEN
373: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377: check_uniqueness;
378: check_parent_existance;
379: ELSIF (p_action = 'UPDATE') THEN

Line 391: app_exception.raise_exception;

387: )
388: ) THEN
389: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393: check_uniqueness;
394: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
395: check_uniqueness;

Line 475: app_exception.raise_exception;

471: END IF;
472: ELSE
473: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
477:
478: before_dml(
479: p_action => 'INSERT',

Line 596: app_exception.raise_exception;

592: IF (c1%notfound) THEN
593: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
594: igs_ge_msg_stack.add;
595: CLOSE c1;
596: app_exception.raise_exception;
597: RETURN;
598: END IF;
599: CLOSE c1;
600:

Line 615: app_exception.raise_exception;

611: NULL;
612: ELSE
613: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
614: igs_ge_msg_stack.add;
615: app_exception.raise_exception;
616: END IF;
617:
618: RETURN;
619:

Line 671: app_exception.raise_exception;

667: END IF;
668: ELSE
669: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
670: igs_ge_msg_stack.add;
671: app_exception.raise_exception;
672: END IF;
673:
674: before_dml(
675: p_action => 'UPDATE',