DBA Data[Home] [Help]

APPS.IGS_EN_SPL_PERM_PKG dependencies on APP_EXCEPTION

Line 96: app_exception.raise_exception;

92: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
93: CLOSE cur_old_ref_values;
94: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: RETURN;
98: END IF;
99: CLOSE cur_old_ref_values;
100:

Line 202: APP_EXCEPTION.RAISE_EXCEPTION;

198: new_references.instructor_more_info := old_references.instructor_more_info;
199: ELSE
200: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FIELD_LENGTH_GREATER');
201: IGS_GE_MSG_STACK.ADD;
202: APP_EXCEPTION.RAISE_EXCEPTION;
203: END IF;
204: ELSE
205: IF LENGTH(old_references.instructor_more_info || new_references.instructor_more_info ) <= 4000 THEN
206: new_references.instructor_more_info := old_references.instructor_more_info|| new_references.instructor_more_info;

Line 215: APP_EXCEPTION.RAISE_EXCEPTION;

211: new_references.instructor_more_info := old_references.instructor_more_info;
212: ELSE
213: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FIELD_LENGTH_GREATER');
214: IGS_GE_MSG_STACK.ADD;
215: APP_EXCEPTION.RAISE_EXCEPTION;
216: END IF;
217: END IF;
218: END IF;
219:

Line 230: APP_EXCEPTION.RAISE_EXCEPTION;

226: new_references.instructor_more_info := old_references.instructor_more_info;
227: ELSE
228: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FIELD_LENGTH_GREATER');
229: IGS_GE_MSG_STACK.ADD;
230: APP_EXCEPTION.RAISE_EXCEPTION;
231: END IF;
232: ELSE
233: IF LENGTH(old_references.instructor_more_info || new_references.student_more_info ) <= 4000 THEN
234: new_references.instructor_more_info := old_references.instructor_more_info|| new_references.student_more_info;

Line 243: APP_EXCEPTION.RAISE_EXCEPTION;

239: new_references.instructor_more_info := old_references.instructor_more_info;
240: ELSE
241: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FIELD_LENGTH_GREATER');
242: IGS_GE_MSG_STACK.ADD;
243: APP_EXCEPTION.RAISE_EXCEPTION;
244: END IF;
245: END IF;
246: END IF;
247:

Line 350: app_exception.raise_exception;

346: new_references.student_person_id
347: ) THEN
348: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352:
353: IF (((old_references.uoo_id = new_references.uoo_id)) OR
354: ((new_references.uoo_id IS NULL))) THEN

Line 361: app_exception.raise_exception;

357: new_references.uoo_id
358: ) THEN
359: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363:
364: IF (((old_references.instructor_person_id = new_references.instructor_person_id)) OR
365: ((new_references.instructor_person_id IS NULL))) THEN

Line 372: app_exception.raise_exception;

368: new_references.instructor_person_id
369: ) THEN
370: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374:
375: IF (((old_references.transaction_type =
376: new_references.transaction_type)) OR

Line 384: App_Exception.Raise_Exception;

380: IF NOT IGS_LOOKUPS_VIEW_Pkg.Get_PK_For_Validation ('SPL_PERM_TRANSCTION_TYPE',
381: new_references.transaction_type) THEN
382: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
383: Igs_Ge_Msg_Stack.Add;
384: App_Exception.Raise_Exception;
385: END IF;
386:
387: END IF;
388:

Line 475: app_exception.raise_exception;

471: IF (cur_rowid%FOUND) THEN
472: CLOSE cur_rowid;
473: fnd_message.set_name ('IGS', 'IGS_EN_SPLP_HZ_FK');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: RETURN;
477: END IF;
478: CLOSE cur_rowid;
479:

Line 510: app_exception.raise_exception;

506: IF (cur_rowid%FOUND) THEN
507: CLOSE cur_rowid;
508: fnd_message.set_name ('IGS', 'IGS_EN_SPLP_UOO_FK');
509: igs_ge_msg_stack.add;
510: app_exception.raise_exception;
511: RETURN;
512: END IF;
513: CLOSE cur_rowid;
514:

Line 585: app_exception.raise_exception;

581: )
582: ) THEN
583: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587: check_parent_existance;
588: ELSIF (p_action = 'UPDATE') THEN
589: -- Call all the procedures related to Before Update.

Line 608: app_exception.raise_exception;

604: )
605: ) THEN
606: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610: ELSIF (p_action = 'VALIDATE_DELETE') THEN
611: check_child_existance;
612: END IF;

Line 712: app_exception.raise_exception;

708: END IF;
709: ELSE
710: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
711: igs_ge_msg_stack.add;
712: app_exception.raise_exception;
713: END IF;
714:
715: SELECT igs_en_spl_perm_s.NEXTVAL
716: INTO x_spl_perm_request_id

Line 746: app_exception.raise_exception;

742: RETURN;
743: ELSE
744: fnd_message.set_name ('IGS', 'IGS_EN_REC_EXST_APRV_MORE');
745: igs_ge_msg_stack.add;
746: app_exception.raise_exception;
747: END IF;
748: ELSE
749: CLOSE c_spl_perm;
750: END IF;

Line 884: app_exception.raise_exception;

880: IF (c1%notfound) THEN
881: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
882: igs_ge_msg_stack.add;
883: CLOSE c1;
884: app_exception.raise_exception;
885: RETURN;
886: END IF;
887: CLOSE c1;
888:

Line 907: app_exception.raise_exception;

903: NULL;
904: ELSE
905: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
906: igs_ge_msg_stack.add;
907: app_exception.raise_exception;
908: END IF;
909:
910: RETURN;
911:

Line 964: app_exception.raise_exception;

960: END IF;
961: ELSE
962: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
963: igs_ge_msg_stack.add;
964: app_exception.raise_exception;
965: END IF;
966:
967: before_dml(
968: p_action => 'UPDATE',