APPS.IGS_HE_UT_PRS_DTLS_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 99: app_exception.raise_exception;

95: new_references.person_id
96: ) THEN
97: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: -- Check for award cd existance
103: IF ((old_references.award_cd = new_references.award_cd) OR

Line 109: app_exception.raise_exception;

105: NULL;
106: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation(new_references.award_cd) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: END check_parent_existance;
113:

Line 174: app_exception.raise_exception;

170: IF (cur_rowid%FOUND) THEN
171: CLOSE cur_rowid;
172: fnd_message.set_name ('IGS', 'IGS_HE_HUPD_HUPC_FK');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: RETURN;
176: END IF;
177: CLOSE cur_rowid;
178:

Line 232: app_exception.raise_exception;

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

Line 245: app_exception.raise_exception;

241: )
242: ) THEN
243: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;
247: END IF;
248:
249: IF (p_action IN ('VALIDATE_INSERT', 'VALIDATE_UPDATE', 'VALIDATE_DELETE')) THEN

Line 298: app_exception.raise_exception;

294: ELSE
295: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
296: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.INSERT_ROW');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300:
301: before_dml(
302: p_action => 'INSERT',

Line 357: app_exception.raise_exception;

353: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
354: fnd_message.set_token ('ERR_CD', SQLCODE);
355: igs_ge_msg_stack.add;
356: igs_sc_gen_001.unset_ctx('R');
357: app_exception.raise_exception;
358: ELSE
359: igs_sc_gen_001.unset_ctx('R');
360: RAISE;
361: END IF;

Line 400: app_exception.raise_exception;

396: IF (c1%notfound) THEN
397: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
398: igs_ge_msg_stack.add;
399: CLOSE c1;
400: app_exception.raise_exception;
401: RETURN;
402: END IF;
403: CLOSE c1;
404:

Line 413: app_exception.raise_exception;

409: NULL;
410: ELSE
411: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: END IF;
415:
416: RETURN;
417:

Line 462: app_exception.raise_exception;

458: ELSE
459: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
460: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.UPDATE_ROW');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;
464:
465: before_dml(
466: p_action => 'UPDATE',

Line 496: app_exception.raise_exception;

492: IF (SQL%NOTFOUND) THEN
493: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
494: igs_ge_msg_stack.add;
495: igs_sc_gen_001.unset_ctx('R');
496: app_exception.raise_exception;
497: END IF;
498: IF (x_mode = 'S') THEN
499: igs_sc_gen_001.unset_ctx('R');
500: END IF;

Line 512: app_exception.raise_exception;

508: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
514: igs_sc_gen_001.unset_ctx('R');
515: RAISE;
516: END IF;

Line 609: app_exception.raise_exception;

605: IF (SQL%NOTFOUND) THEN
606: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
607: igs_ge_msg_stack.add;
608: igs_sc_gen_001.unset_ctx('R');
609: app_exception.raise_exception;
610: END IF;
611: IF (x_mode = 'S') THEN
612: igs_sc_gen_001.unset_ctx('R');
613: END IF;