DBA Data[Home] [Help]

APPS.IGF_AW_FUND_CAT_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

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

Line 101: app_exception.raise_exception;

97:
98: IF ((get_uk_for_validation(new_references.fund_code)) OR (get_uk1_for_validation(new_references.alt_loan_code))) THEN
99: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
104: END check_uniqueness;
105:

Line 127: app_exception.raise_exception;

123: new_references.fund_type
124: ) THEN
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:
130: END check_parent_existance;
131:

Line 354: app_exception.raise_exception;

350: IF (cur_rowid%FOUND) THEN
351: CLOSE cur_rowid;
352: fnd_message.set_name ('IGF','IGF_AW_FUND_CAT_FK');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: RETURN;
356: END IF;
357: CLOSE cur_rowid;
358:

Line 391: app_exception.raise_exception;

387: IF (cur_rowid%FOUND) THEN
388: CLOSE cur_rowid;
389: fnd_message.set_name ('IGF', 'IGF_AW_FCAT_FT_FK');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: RETURN;
393: END IF;
394: CLOSE cur_rowid;
395:

Line 458: app_exception.raise_exception;

454: )
455: ) THEN
456: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END IF;
460: check_uniqueness;
461: check_parent_existance;
462: ELSIF (p_action = 'UPDATE') THEN

Line 475: app_exception.raise_exception;

471: )
472: ) THEN
473: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
477: check_uniqueness;
478: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
479: check_uniqueness;

Line 544: app_exception.raise_exception;

540: END IF;
541: ELSE
542: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:
547: SELECT igf_aw_fund_cat_all_s.nextval INTO x_fcat_id FROM dual;
548:

Line 662: app_exception.raise_exception;

658: IF (c1%notfound) THEN
659: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
660: igs_ge_msg_stack.add;
661: CLOSE c1;
662: app_exception.raise_exception;
663: RETURN;
664: END IF;
665: CLOSE c1;
666:

Line 682: app_exception.raise_exception;

678: NULL;
679: ELSE
680: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
681: igs_ge_msg_stack.add;
682: app_exception.raise_exception;
683: END IF;
684:
685: RETURN;
686:

Line 735: app_exception.raise_exception;

731: END IF;
732: ELSE
733: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
734: igs_ge_msg_stack.add;
735: app_exception.raise_exception;
736: END IF;
737:
738: before_dml(
739: p_action => 'UPDATE',