APPS.IGS_PR_STAT_TYPE_PKG dependencies on APP_EXCEPTION

Line 56: app_exception.raise_exception;

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

Line 64: app_exception.raise_exception;

60:
61: IF (p_action = 'UPDATE' OR p_action = 'INSERT') AND x_derivation IS NULL THEN
62: fnd_message.set_name('IGS','IGS_PR_DERIVATION_NULL');
63: igs_ge_msg_stack.add;
64: app_exception.raise_exception;
65: RETURN;
66: END IF;
67:
68: -- Populate New Values.

Line 79: app_exception.raise_exception;

75: new_references.created_by := old_references.created_by;
76: IF ((old_references.derivation = 'CALCULATED') AND (x_derivation = 'STORED')) THEN
77: fnd_message.set_name('IGS','IGS_PR_DERIVAT_CALC_TO_STORE');
78: igs_ge_msg_stack.add;
79: app_exception.raise_exception;
80: RETURN;
81: ELSIF ((old_references.derivation = 'STORED') AND (x_derivation = 'CALCULATED')) THEN
82: OPEN cur_stu_acad_stat;
83: FETCH cur_stu_acad_stat INTO lv_stu_acad_stat;

Line 87: app_exception.raise_exception;

83: FETCH cur_stu_acad_stat INTO lv_stu_acad_stat;
84: IF (cur_stu_acad_stat%FOUND) THEN
85: fnd_message.set_name('IGS','IGS_PR_DERIVAT_STORE_TO_CALC');
86: igs_ge_msg_stack.add;
87: app_exception.raise_exception;
88: RETURN;
89: END IF;
90: CLOSE cur_stu_acad_stat;
91: ELSIF ((old_references.derivation = 'BOTH') AND (x_derivation = 'CALCULATED')) THEN

Line 97: app_exception.raise_exception;

93: FETCH cur_stu_acad_stat INTO lv_stu_acad_stat;
94: IF (cur_stu_acad_stat%FOUND) THEN
95: fnd_message.set_name('IGS','IGS_PR_DERIVAT_BOTH_TO_CALC');
96: igs_ge_msg_stack.add;
97: app_exception.raise_exception;
98: RETURN;
99: END IF;
100: CLOSE cur_stu_acad_stat;
101: ELSIF ((old_references.derivation ='BOTH') AND (x_derivation ='STORED')) THEN

Line 104: app_exception.raise_exception;

100: CLOSE cur_stu_acad_stat;
101: ELSIF ((old_references.derivation ='BOTH') AND (x_derivation ='STORED')) THEN
102: fnd_message.set_name('IGS','IGS_PR_DERIVAT_BOTH_TO_STORE');
103: igs_ge_msg_stack.add;
104: app_exception.raise_exception;
105: RETURN;
106: END IF;
107: ELSE
108: new_references.creation_date := x_creation_date;

Line 240: app_exception.raise_exception;

236: )
237: ) THEN
238: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
239: igs_ge_msg_stack.add;
240: app_exception.raise_exception;
241: END IF;
242: ELSIF (p_action = 'DELETE') THEN
243: -- Call all the procedures related to Before Delete.
244: check_child_existance;

Line 253: app_exception.raise_exception;

249: )
250: ) THEN
251: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
252: igs_ge_msg_stack.add;
253: app_exception.raise_exception;
254: END IF;
255: ELSIF (p_action = 'VALIDATE_DELETE') THEN
256: check_child_existance;
257: END IF;

Line 306: app_exception.raise_exception;

302: END IF;
303: ELSE
304: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308:
309: before_dml(
310: p_action => 'INSERT',

Line 391: app_exception.raise_exception;

387: IF (c1%notfound) THEN
388: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
389: igs_ge_msg_stack.add;
390: CLOSE c1;
391: app_exception.raise_exception;
392: RETURN;
393: END IF;
394: CLOSE c1;
395:

Line 405: app_exception.raise_exception;

401: NULL;
402: ELSE
403: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: RETURN;
409:

Line 452: app_exception.raise_exception;

448: END IF;
449: ELSE
450: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: END IF;
454:
455: before_dml(
456: p_action => 'UPDATE',