DBA Data[Home] [Help]

APPS.IGS_FI_WAIVER_PGMS_PKG dependencies on APP_EXCEPTION

Line 35: app_exception.raise_exception;

31: new_references.fee_ci_sequence_number
32: ) THEN
33: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
34: igs_ge_msg_stack.add;
35: app_exception.raise_exception;
36: END IF;
37: /*
38: Check For the parent validation for credit_type_id
39: */

Line 46: app_exception.raise_exception;

42: NULL;
43: ELSIF NOT igs_fi_cr_types_pkg.get_pk_for_validation(new_references.credit_type_id) THEN
44: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
45: igs_ge_msg_stack.add;
46: app_exception.raise_exception;
47: END IF;
48: /*
49: Check For the parent validation for adjustment_fee_type
50: */

Line 57: app_exception.raise_exception;

53: NULL;
54: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation(new_references.adjustment_fee_type) THEN
55: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: END IF;
59: /*
60: Check For the parent validation for rule_fee_type
61: */

Line 68: app_exception.raise_exception;

64: NULL;
65: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation(new_references.rule_fee_type) THEN
66: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
67: igs_ge_msg_stack.add;
68: app_exception.raise_exception;
69: END IF;
70: /*
71: Check For the parent validation for target_fee_type
72: */

Line 79: app_exception.raise_exception;

75: NULL;
76: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation(new_references.target_fee_type) THEN
77: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
78: igs_ge_msg_stack.add;
79: app_exception.raise_exception;
80: END IF;
81:
82: END check_parent_existance;
83:

Line 105: app_exception.raise_exception;

101: ELSIF (Upper(Column_Name) = 'WAIVER_METHOD_CODE' AND Upper(Column_Value) = 'COMP_RULE' ) THEN
102: IF ((new_references.waiver_criteria_code IS NULL) OR (new_references.WAIVER_PERCENT_ALLOC IS NULL) OR (new_references.RULE_FEE_TYPE IS NULL)) THEN
103: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107: END IF;
108: END Check_Constraints;
109:

Line 161: app_exception.raise_exception;

157: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
158: CLOSE cur_old_ref_values;
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: RETURN;
163: END IF;
164: CLOSE cur_old_ref_values;
165:

Line 305: app_exception.raise_exception;

301: )
302: ) THEN
303: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
304: igs_ge_msg_stack.add;
305: app_exception.raise_exception;
306: END IF;
307: check_constraints;
308: check_parent_existance;
309: ELSIF (p_action = 'VALIDATE_INSERT') THEN

Line 319: app_exception.raise_exception;

315: )
316: ) THEN
317: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321: END IF;
322:
323: END before_dml;

Line 376: app_exception.raise_exception;

372: ELSE
373: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
374: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAIVER_PGMS_PKG.INSERT_ROW');
375: igs_ge_msg_stack.add;
376: app_exception.raise_exception;
377: END IF;
378:
379: before_dml(
380: p_action => 'INSERT',

Line 501: app_exception.raise_exception;

497: IF (c1%notfound) THEN
498: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
499: igs_ge_msg_stack.add;
500: CLOSE c1;
501: app_exception.raise_exception;
502: RETURN;
503: END IF;
504: CLOSE c1;
505:

Line 523: app_exception.raise_exception;

519: NULL;
520: ELSE
521: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
522: igs_ge_msg_stack.add;
523: app_exception.raise_exception;
524: END IF;
525:
526: RETURN;
527:

Line 591: app_exception.raise_exception;

587: ELSE
588: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
589: fnd_message.set_token ('ROUTINE', 'IGS_FI_WAIVER_PGMS_PKG.UPDATE_ROW');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
594: before_dml(
595: p_action => 'UPDATE',