APPS.IGS_PE_SN_SERVICE_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 101: app_exception.raise_exception;

97: )
98: ) 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: 'PE_SN_SERVICE',new_references.special_service_cd
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: IF (((old_references.disability_id = new_references.disability_id)) OR
131: ((new_references.disability_id IS NULL))) THEN

Line 138: app_exception.raise_exception;

134: new_references.disability_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
141: END check_parent_existance;
142:

Line 246: app_exception.raise_exception;

242: IF (cur_rowid%FOUND) THEN
243: CLOSE cur_rowid;
244: fnd_message.set_name ('IGS', 'IGS_PE_SNSV_PD_FK');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: RETURN;
248: END IF;
249: CLOSE cur_rowid;
250:

Line 307: app_exception.raise_exception;

303: )
304: ) THEN
305: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: END IF;
309:
310: check_uniqueness;
311: check_parent_existance;

Line 325: app_exception.raise_exception;

321: )
322: ) THEN
323: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: END IF;
327: check_uniqueness;
328:
329: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 382: app_exception.raise_exception;

378: END IF;
379: ELSE
380: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
381: igs_ge_msg_stack.add;
382: app_exception.raise_exception;
383: END IF;
384:
385: SELECT igs_pe_sn_service_s.NEXTVAL
386: INTO x_sn_service_id

Line 454: app_exception.raise_exception;

450: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
451: fnd_message.set_token ('ERR_CD', SQLCODE);
452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: ELSE
456: igs_sc_gen_001.unset_ctx('R');
457: RAISE;
458: END IF;

Line 502: app_exception.raise_exception;

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

Line 527: app_exception.raise_exception;

523: NULL;
524: ELSE
525: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:
530: RETURN;
531:

Line 576: app_exception.raise_exception;

572: END IF;
573: ELSE
574: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
575: igs_ge_msg_stack.add;
576: app_exception.raise_exception;
577: END IF;
578:
579: before_dml(
580: p_action => 'UPDATE',

Line 614: app_exception.raise_exception;

610: IF (SQL%NOTFOUND) THEN
611: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
612: igs_ge_msg_stack.add;
613: igs_sc_gen_001.unset_ctx('R');
614: app_exception.raise_exception;
615: END IF;
616: IF (x_mode = 'S') THEN
617: igs_sc_gen_001.unset_ctx('R');
618: END IF;

Line 629: app_exception.raise_exception;

625: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
626: fnd_message.set_token ('ERR_CD', SQLCODE);
627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: ELSE
631: igs_sc_gen_001.unset_ctx('R');
632: RAISE;
633: END IF;

Line 726: app_exception.raise_exception;

722: IF (SQL%NOTFOUND) THEN
723: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
724: igs_ge_msg_stack.add;
725: igs_sc_gen_001.unset_ctx('R');
726: app_exception.raise_exception;
727: END IF;
728: IF (x_mode = 'S') THEN
729: igs_sc_gen_001.unset_ctx('R');
730: END IF;