[Home] [Help]
90: OPEN cur_old_ref_values;
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;
196: IF LENGTH(old_references.student_more_info || new_references.instructor_more_info ) <= 4000 THEN
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
209: IF LENGTH(old_references.student_more_info || new_references.instructor_more_info ) <= 4000 THEN
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;
224: IF LENGTH(old_references.student_more_info || new_references.student_more_info ) <= 4000 THEN
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
237: IF LENGTH(old_references.student_more_info || new_references.student_more_info ) <= 4000 THEN
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;
344: NULL;
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:
355: NULL;
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:
366: NULL;
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:
378: NULL;
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:
469: OPEN cur_rowid;
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;
504: OPEN cur_rowid;
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;
579: IF ( get_pk_for_validation(
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;
602: IF ( get_pk_for_validation (
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
706: IF (x_last_update_login IS NULL) THEN
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:
740: x_mode
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
877:
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;
901: AND ((tlinfo.request_type = x_request_type) OR ((tlinfo.request_type IS NULL) AND (X_request_type IS NULL)))
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:
958: IF (x_last_update_login IS NULL) THEN
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: