APPS.IGS_PE_FUND_SOURCE_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 102: app_exception.raise_exception;

98: new_references.person_id
99: ) THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
105: END check_parent_existance;
106:

Line 170: app_exception.raise_exception;

166: IF (cur_rowid%FOUND) THEN
167: CLOSE cur_rowid;
168: fnd_message.set_name ('IGS', 'IGS_PE_PFS_HZ_FK');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: RETURN;
172: END IF;
173: CLOSE cur_rowid;
174:

Line 233: app_exception.raise_exception;

229: )
230: ) THEN
231: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235: check_parent_existance;
236: ELSIF (p_action = 'UPDATE') THEN
237: -- Call all the procedures related to Before Update.

Line 247: app_exception.raise_exception;

243: )
244: ) THEN
245: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: END IF;
249: END IF;
250:
251: END before_dml;

Line 302: app_exception.raise_exception;

298: END IF;
299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: END IF;
304:
305: SELECT igs_pe_fund_source_s.NEXTVAL
306: INTO x_fund_source_id

Line 380: app_exception.raise_exception;

376: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
377: fnd_message.set_token ('ERR_CD', SQLCODE);
378: igs_ge_msg_stack.add;
379: igs_sc_gen_001.unset_ctx('R');
380: app_exception.raise_exception;
381: ELSE
382: igs_sc_gen_001.unset_ctx('R');
383: RAISE;
384: END IF;

Line 431: app_exception.raise_exception;

427: IF (c1%notfound) THEN
428: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
429: igs_ge_msg_stack.add;
430: CLOSE c1;
431: app_exception.raise_exception;
432: RETURN;
433: END IF;
434: CLOSE c1;
435:

Line 449: app_exception.raise_exception;

445: NULL;
446: ELSE
447: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
448: igs_ge_msg_stack.add;
449: app_exception.raise_exception;
450: END IF;
451:
452: RETURN;
453:

Line 500: app_exception.raise_exception;

496: END IF;
497: ELSE
498: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
499: igs_ge_msg_stack.add;
500: app_exception.raise_exception;
501: END IF;
502:
503: before_dml(
504: p_action => 'UPDATE',

Line 542: app_exception.raise_exception;

538: IF (SQL%NOTFOUND) THEN
539: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
540: igs_ge_msg_stack.add;
541: igs_sc_gen_001.unset_ctx('R');
542: app_exception.raise_exception;
543: END IF;
544: IF (x_mode = 'S') THEN
545: igs_sc_gen_001.unset_ctx('R');
546: END IF;

Line 557: app_exception.raise_exception;

553: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
554: fnd_message.set_token ('ERR_CD', SQLCODE);
555: igs_ge_msg_stack.add;
556: igs_sc_gen_001.unset_ctx('R');
557: app_exception.raise_exception;
558: ELSE
559: igs_sc_gen_001.unset_ctx('R');
560: RAISE;
561: END IF;

Line 660: app_exception.raise_exception;

656: IF (SQL%NOTFOUND) THEN
657: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: END IF;
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.unset_ctx('R');
664: END IF;