APPS.IGS_PE_STD_TODO_REF_PKG dependencies on IGS_GE_MSG_STACK

Line 84: IGS_GE_MSG_STACK.ADD;

80:
81: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN( 'INSERT','VALIDATE_INSERT')) THEN
82:
83: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
84: IGS_GE_MSG_STACK.ADD;
85:
86:
87: Close cur_old_ref_values;
88: App_Exception.Raise_Exception;

Line 179: IGS_GE_MSG_STACK.ADD;

175: IF upper(column_name) = 'CAL_TYPE' OR
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

Line 187: IGS_GE_MSG_STACK.ADD;

183: IF upper(column_name) = 'COURSE_CD' OR
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

Line 195: IGS_GE_MSG_STACK.ADD;

191: IF upper(column_name) = 'OTHER_REFERENCE' OR
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:

Line 204: IGS_GE_MSG_STACK.ADD;

200: IF upper(column_name) = 'S_STUDENT_TODO_TYPE' OR
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

Line 212: IGS_GE_MSG_STACK.ADD;

208: IF upper(column_name) = 'UNIT_CD' OR
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:

Line 221: IGS_GE_MSG_STACK.ADD;

217: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR
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:

Line 249: IGS_GE_MSG_STACK.ADD;

245: new_references.person_id,
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;

Line 348: IGS_GE_MSG_STACK.ADD;

344:
345: IF (cur_rowid%FOUND) THEN
346:
347: Fnd_Message.Set_Name ('IGS', 'IGS_PE_STR_ST_FK');
348: IGS_GE_MSG_STACK.ADD;
349:
350:
351: Close cur_rowid;
352: App_Exception.Raise_Exception;

Line 459: IGS_GE_MSG_STACK.ADD;

455: new_references.s_student_todo_type ,
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

Line 482: IGS_GE_MSG_STACK.ADD;

478: new_references.s_student_todo_type ,
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

Line 618: IGS_GE_MSG_STACK.ADD;

614:
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:

Line 738: IGS_GE_MSG_STACK.ADD;

734:
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:

Line 856: IGS_GE_MSG_STACK.ADD;

852: X_LAST_UPDATE_LOGIN := -1;
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: --