DBA Data[Home] [Help]

APPS.IGF_AW_FUND_MAST_PKG dependencies on APP_EXCEPTION

Line 232: app_exception.raise_exception;

228: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
229: CLOSE cur_old_ref_values;
230: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: RETURN;
234: END IF;
235: CLOSE cur_old_ref_values;
236:

Line 431: app_exception.raise_exception;

427: )
428: ) THEN
429: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
430: igs_ge_msg_stack.add;
431: app_exception.raise_exception;
432: END IF;
433:
434: END check_uniqueness;
435:

Line 468: app_exception.raise_exception;

464: new_references.fund_code
465: ) THEN
466: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
467: igs_ge_msg_stack.add;
468: app_exception.raise_exception;
469: END IF;
470:
471: IF (((old_references.ci_cal_type = new_references.ci_cal_type) AND
472: (old_references.ci_sequence_number = new_references.ci_sequence_number)) OR

Line 482: app_exception.raise_exception;

478: new_references.ci_sequence_number
479: ) THEN
480: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: END IF;
484:
485: --
486: -- Added Get PK Calls for Person ID Groups

Line 496: app_exception.raise_exception;

492: ELSIF NOT igs_pe_persid_group_pkg.get_pk_for_validation (
493: new_references.group_id) THEN
494: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
495: igs_ge_msg_stack.add;
496: app_exception.raise_exception;
497: END IF;
498:
499: --
500: -- Added Get PK Calls for Fee Types

Line 510: app_exception.raise_exception;

506: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
507: new_references.fee_type) THEN
508: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
509: igs_ge_msg_stack.add;
510: app_exception.raise_exception;
511: END IF;
512:
513: IF ((old_references.spnsr_fee_type = new_references.spnsr_fee_type)
514: OR

Line 521: app_exception.raise_exception;

517: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
518: new_references.spnsr_fee_type) THEN
519: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
520: igs_ge_msg_stack.add;
521: app_exception.raise_exception;
522: END IF;
523:
524: END check_parent_existance;
525:

Line 642: app_exception.raise_exception;

638: IF (cur_rowid%FOUND) THEN
639: CLOSE cur_rowid;
640: fnd_message.set_name ('IGF', 'IGF_AW_FMAST_FCAT_FK');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: RETURN;
644: END IF;
645: CLOSE cur_rowid;
646:

Line 678: app_exception.raise_exception;

674: IF (cur_rowid%FOUND) THEN
675: CLOSE cur_rowid;
676: fnd_message.set_name ('IGF', 'IGF_AW_CI_FMAST_FK');
677: igs_ge_msg_stack.add;
678: app_exception.raise_exception;
679: RETURN;
680: END IF;
681: CLOSE cur_rowid;
682:

Line 712: app_exception.raise_exception;

708: IF (cur_rowid%FOUND) THEN
709: CLOSE cur_rowid;
710: fnd_message.set_name ('IGF', 'IGF_AW_FMAST_CT_FK');
711: igs_ge_msg_stack.add;
712: app_exception.raise_exception;
713: RETURN;
714: END IF;
715: CLOSE cur_rowid;
716:

Line 1009: app_exception.raise_exception;

1005: )
1006: ) THEN
1007: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1008: igs_ge_msg_stack.add;
1009: app_exception.raise_exception;
1010: END IF;
1011: check_parent_existance;
1012: check_uniqueness;
1013: ELSIF (p_action = 'UPDATE') THEN

Line 1028: app_exception.raise_exception;

1024: )
1025: ) THEN
1026: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1027: igs_ge_msg_stack.add;
1028: app_exception.raise_exception;
1029: END IF;
1030: check_uniqueness;
1031: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1032: check_uniqueness;

Line 1225: app_exception.raise_exception;

1221: END IF;
1222: ELSE
1223: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1224: igs_ge_msg_stack.add;
1225: app_exception.raise_exception;
1226: END IF;
1227:
1228: select IGF_AW_FUND_MAST_S.NEXTVAL into x_fund_id from dual ;
1229:

Line 1922: app_exception.raise_exception;

1918: IF (c1%notfound) THEN
1919: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1920: igs_ge_msg_stack.add;
1921: CLOSE c1;
1922: app_exception.raise_exception;
1923: RETURN;
1924: END IF;
1925: CLOSE c1;
1926:

Line 2053: app_exception.raise_exception;

2049: NULL;
2050: ELSE
2051: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2052: igs_ge_msg_stack.add;
2053: app_exception.raise_exception;
2054: END IF;
2055:
2056: RETURN;
2057: END lock_row;

Line 2231: app_exception.raise_exception;

2227: END IF;
2228: ELSE
2229: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2230: igs_ge_msg_stack.add;
2231: app_exception.raise_exception;
2232: END IF;
2233:
2234: before_dml(
2235: p_action => 'UPDATE',