APPS.IGS_AD_PNL_HIS_DTLS_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 94: app_exception.raise_exception;

90: new_references.panel_dtls_id
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: IF ((old_references.final_decision_code = new_references.final_decision_code) AND
98: (old_references.final_decision_type = new_references.final_decision_type)) THEN

Line 107: app_exception.raise_exception;

103: 'N'
104: ) THEN
105: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: END IF;
109:
110: END check_parent_existance;
111:

Line 177: app_exception.raise_exception;

173: IF (cur_rowid%FOUND) THEN
174: CLOSE cur_rowid;
175: fnd_message.set_name ('IGS', 'IGS_AD_PNLHIS_PNDTLS_FK');
176: igs_ge_msg_stack.add;
177: app_exception.raise_exception;
178: RETURN;
179: END IF;
180: CLOSE cur_rowid;
181:

Line 214: app_exception.raise_exception;

210: IF (cur_rowid%FOUND) THEN
211: CLOSE cur_rowid;
212: fnd_message.set_name ('IGS', 'IGS_AD_PNLHIS_CODE_CLS_FK');
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215: RETURN;
216: END IF;
217: CLOSE cur_rowid;
218:

Line 270: app_exception.raise_exception;

266: )
267: ) THEN
268: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;
272: check_parent_existance;
273: ELSIF (p_action = 'UPDATE') THEN
274: -- Call all the procedures related to Before Update.

Line 285: app_exception.raise_exception;

281: )
282: ) THEN
283: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287: END IF;
288:
289: END before_dml;

Line 333: app_exception.raise_exception;

329: ELSE
330: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
331: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.insert_row');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335:
336: before_dml(
337: p_action => 'INSERT',

Line 383: app_exception.raise_exception;

379: -- that the ownerof policy function does not have privilege to access.
380: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
381: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
382: IGS_GE_MSG_STACK.ADD;
383: app_exception.raise_exception;
384: ELSE
385: RAISE;
386: END IF;
387: END insert_row;

Line 424: app_exception.raise_exception;

420: IF (c1%notfound) THEN
421: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
422: igs_ge_msg_stack.add;
423: CLOSE c1;
424: app_exception.raise_exception;
425: RETURN;
426: END IF;
427: CLOSE c1;
428:

Line 437: app_exception.raise_exception;

433: NULL;
434: ELSE
435: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: END IF;
439:
440: RETURN;
441:

Line 485: app_exception.raise_exception;

481: ELSE
482: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
483: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.update_row');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487:
488: before_dml(
489: p_action => 'UPDATE',

Line 514: app_exception.raise_exception;

510:
511: IF (SQL%NOTFOUND) THEN
512: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
513: IGS_GE_MSG_STACK.ADD;
514: app_exception.raise_exception;
515: END IF;
516:
517: EXCEPTION
518: WHEN OTHERS THEN

Line 528: app_exception.raise_exception;

524: -- that the ownerof policy function does not have privilege to access.
525: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
526: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
527: IGS_GE_MSG_STACK.ADD;
528: app_exception.raise_exception;
529: ELSE
530: RAISE;
531: END IF;
532: END update_row;

Line 614: app_exception.raise_exception;

610:
611: IF (SQL%NOTFOUND) THEN
612: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
613: IGS_GE_MSG_STACK.ADD;
614: app_exception.raise_exception;
615: END IF;
616:
617: EXCEPTION
618: WHEN OTHERS THEN

Line 628: app_exception.raise_exception;

624: -- that the ownerof policy function does not have privilege to access.
625: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
626: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
627: IGS_GE_MSG_STACK.ADD;
628: app_exception.raise_exception;
629: ELSE
630: RAISE;
631: END IF;
632: END delete_row;