APPS.IGS_PE_STD_TODO_PKG dependencies on APP_EXCEPTION

Line 36: App_Exception.Raise_Exception;

32: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN( 'INSERT','VALIDATE_INSERT')) THEN
33: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
34: IGS_GE_MSG_STACK.ADD;
35: Close cur_old_ref_values;
36: App_Exception.Raise_Exception;
37: Return;
38: END IF;
39: Close cur_old_ref_values;
40: -- Populate New Values.

Line 75: App_Exception.Raise_Exception;

71: column_name is null Then
72: IF new_references.s_student_todo_type <>UPPER(new_references.s_student_todo_type)Then
73: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76: END IF;
77: END IF;
78:
79: END Check_Constraints;

Line 91: App_Exception.Raise_Exception;

87: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
88: new_references.person_id ) THEN
89: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: END IF;
94: IF (((old_references.s_student_todo_type = new_references.s_student_todo_type)) OR
95: ((new_references.s_student_todo_type IS NULL))) THEN

Line 104: App_Exception.Raise_Exception;

100: 'STUDENT_TODO_TYPE',
101: new_references.s_student_todo_type ) THEN
102: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107: END Check_Parent_Existance;
108: PROCEDURE Check_Child_Existance AS

Line 162: App_Exception.Raise_Exception;

158: IF (cur_rowid%FOUND) THEN
159: Fnd_Message.Set_Name ('IGS', 'IGS_PE_ST_PE_FK');
160: IGS_GE_MSG_STACK.ADD;
161: Close cur_rowid;
162: App_Exception.Raise_Exception;
163: Return;
164: END IF;
165: Close cur_rowid;
166: END GET_FK_IGS_PE_PERSON;

Line 213: App_Exception.Raise_Exception;

209: new_references.s_student_todo_type ,
210: new_references.sequence_number ) THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215:
216: Check_Constraints; -- if procedure present
217: Check_Parent_Existance; -- if procedure present

Line 236: App_Exception.Raise_Exception;

232: new_references.s_student_todo_type ,
233: new_references.sequence_number ) THEN
234: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238:
239: Check_Constraints; -- if procedure present
240: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 313: app_exception.raise_exception;

309: end if;
310: else
311: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
312: IGS_GE_MSG_STACK.ADD;
313: app_exception.raise_exception;
314: end if;
315: Before_DML(
316: p_action=>'INSERT',
317: x_rowid=> X_ROWID,

Line 394: App_Exception.Raise_Exception;

390: if (c1%notfound) then
391: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
392:
393: close c1;
394: App_Exception.Raise_Exception;
395: return;
396: end if;
397: close c1;
398: if ( ((tlinfo.TODO_DT = X_TODO_DT)

Line 408: app_exception.raise_exception;

404: ) then
405: null;
406: else
407: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
408: app_exception.raise_exception;
409: end if;
410: return;
411: end LOCK_ROW;
412: procedure UPDATE_ROW (

Line 445: app_exception.raise_exception;

441: end if;
442: else
443: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: end if;
447: Before_DML(
448: p_action=>'UPDATE',
449: x_rowid=>X_ROWID,