APPS.IGS_EN_SPL_PERM_PKG dependencies on IGS_GE_MSG_STACK

Line 95: igs_ge_msg_stack.add;

91: FETCH cur_old_ref_values INTO old_references;
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;

Line 201: IGS_GE_MSG_STACK.ADD;

197: new_references.student_more_info := old_references.student_more_info || new_references.instructor_more_info;
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

Line 214: IGS_GE_MSG_STACK.ADD;

210: new_references.student_more_info := old_references.student_more_info || new_references.instructor_more_info;
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;

Line 229: IGS_GE_MSG_STACK.ADD;

225: new_references.student_more_info:= old_references.student_more_info || new_references.student_more_info;
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

Line 242: IGS_GE_MSG_STACK.ADD;

238: new_references.student_more_info := old_references.student_more_info || new_references.student_more_info;
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;

Line 349: igs_ge_msg_stack.add;

345: ELSIF NOT get_hz_pk_for_validation (
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

Line 360: igs_ge_msg_stack.add;

356: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
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

Line 371: igs_ge_msg_stack.add;

367: ELSIF NOT get_hz_pk_for_validation (
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 =

Line 383: Igs_Ge_Msg_Stack.Add;

379: ELSE
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;

Line 474: igs_ge_msg_stack.add;

470: FETCH cur_rowid INTO lv_rowid;
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;

Line 509: igs_ge_msg_stack.add;

505: FETCH cur_rowid INTO lv_rowid;
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;

Line 584: igs_ge_msg_stack.add;

580: new_references.spl_perm_request_id
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

Line 607: igs_ge_msg_stack.add;

603: new_references.spl_perm_request_id
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;

Line 711: igs_ge_msg_stack.add;

707: x_last_update_login := -1;
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

Line 745: igs_ge_msg_stack.add;

741: );
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;

Line 882: igs_ge_msg_stack.add;

878: OPEN c1;
879: FETCH c1 INTO tlinfo;
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;

Line 906: igs_ge_msg_stack.add;

902: ) THEN
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;

Line 963: igs_ge_msg_stack.add;

959: x_last_update_login := -1;
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(