APPS.IGS_PE_STD_TODO_REF_PKG dependencies on APP_EXCEPTION

Line 88: App_Exception.Raise_Exception;

84: IGS_GE_MSG_STACK.ADD;
85:
86:
87: Close cur_old_ref_values;
88: App_Exception.Raise_Exception;
89: Return;
90:
91: END IF;
92:

Line 180: App_Exception.Raise_Exception;

176: column_name is null Then
177: IF new_references.cal_type <>UPPER(new_references.cal_type )Then
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183: IF upper(column_name) = 'COURSE_CD' OR
184: column_name is null Then

Line 188: App_Exception.Raise_Exception;

184: column_name is null Then
185: IF new_references.course_cd <>UPPER(new_references.course_cd)Then
186: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
191: IF upper(column_name) = 'OTHER_REFERENCE' OR
192: column_name is null Then

Line 196: App_Exception.Raise_Exception;

192: column_name is null Then
193: IF new_references.other_reference <>UPPER(new_references.other_reference)Then
194: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: END IF;
199:
200: IF upper(column_name) = 'S_STUDENT_TODO_TYPE' OR

Line 205: App_Exception.Raise_Exception;

201: column_name is null Then
202: IF new_references.s_student_todo_type <>UPPER(new_references.s_student_todo_type)Then
203: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: END IF;
208: IF upper(column_name) = 'UNIT_CD' OR
209: column_name is null Then

Line 213: App_Exception.Raise_Exception;

209: column_name is null Then
210: IF new_references.unit_cd <>UPPER(new_references.unit_cd ) Then
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: END IF;
216:
217: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR

Line 222: App_Exception.Raise_Exception;

218: column_name is null Then
219: IF new_references.ci_sequence_number < 1 OR new_references.ci_sequence_number > 999999 Then
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: END IF;
225:
226: -- remove check on reference number.

Line 250: App_Exception.Raise_Exception;

246: new_references.s_student_todo_type,
247: new_references.sequence_number ) THEN
248: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252: END IF;
253: END Check_Parent_Existance;
254:

Line 352: App_Exception.Raise_Exception;

348: IGS_GE_MSG_STACK.ADD;
349:
350:
351: Close cur_rowid;
352: App_Exception.Raise_Exception;
353: Return;
354:
355: END IF;
356:

Line 460: App_Exception.Raise_Exception;

456: new_references.sequence_number ,
457: new_references.reference_number ) THEN
458: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
459: IGS_GE_MSG_STACK.ADD;
460: App_Exception.Raise_Exception;
461: END IF;
462:
463: Check_Constraints; -- if procedure present
464: Check_Parent_Existance; -- if procedure present

Line 483: App_Exception.Raise_Exception;

479: new_references.sequence_number ,
480: new_references.reference_number ) THEN
481: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
482: IGS_GE_MSG_STACK.ADD;
483: App_Exception.Raise_Exception;
484: END IF;
485:
486: Check_Constraints; -- if procedure present
487: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 619: app_exception.raise_exception;

615: end if;
616: else
617: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
618: IGS_GE_MSG_STACK.ADD;
619: app_exception.raise_exception;
620: end if;
621:
622:
623:

Line 739: App_Exception.Raise_Exception;

735: EXCEPTION
736: WHEN OTHERS THEN
737: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
738: IGS_GE_MSG_STACK.ADD;
739: App_Exception.Raise_Exception;
740:
741: end INSERT_ROW;
742:
743: procedure LOCK_ROW (

Line 777: App_Exception.Raise_Exception;

773: fetch c1 into tlinfo;
774: if (c1%notfound) then
775: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
776: close c1;
777: App_Exception.Raise_Exception;
778: return;
779: end if;
780: close c1;
781:

Line 808: app_exception.raise_exception;

804: ) then
805: null;
806: else
807: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
808: app_exception.raise_exception;
809: end if;
810: return;
811: end LOCK_ROW;
812:

Line 857: app_exception.raise_exception;

853: end if;
854: else
855: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
856: IGS_GE_MSG_STACK.ADD;
857: app_exception.raise_exception;
858: end if;
859:
860: --
861: