[Home] [Help]
46: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
47: Close cur_old_ref_values;
48: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
49: IGS_GE_MSG_STACK.ADD;
50: App_Exception.Raise_Exception;
51: Return;
52: END IF;
53: Close cur_old_ref_values;
54:
90: v_admission_cat,
91: v_message_name) = FALSE THEN
92: Fnd_Message.Set_Name('IGS',v_message_name);
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END BeforeRowInsertUpdateDelete1;
97:
98:
130: Column_Name IS NULL THEN
131: IF new_references.ADMISSION_CAT <> UPPER(new_references.admission_cat) THEN
132: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137:
138: IF UPPER(Column_Name) = 'S_ADMISSION_PROCESS_TYPE' OR
139: Column_Name IS NULL THEN
140: IF new_references.S_ADMISSION_PROCESS_TYPE <> UPPER(new_references.s_admission_process_type) THEN
141: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:
147: IF upper(column_name) = 'OFFER_RESPONSE_OFFSET' OR
149: IF new_references.offer_response_offset < 1 OR
150: new_references.offer_response_offset > 99 Then
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156:
157: END Check_Constraints;
177: new_references.admission_cat ,
178: 'N') THEN
179: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183:
184:
185: IF (((old_references.s_admission_process_type = new_references.s_admission_process_type)) OR
191: new_references.s_admission_process_type
192: ) THEN
193: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
198: END Check_Parent_Existance;
199:
315: IF (cur_rowid%FOUND) THEN
316: Close cur_rowid;
317: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APC_AC_FK');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: Return;
321: END IF;
322: Close cur_rowid;
323:
351: IF (cur_rowid%FOUND) THEN
352: Close cur_rowid;
353: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APC_SAPT_FK');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356: Return;
357: END IF;
358: Close cur_rowid;
359:
409: new_references.admission_cat,
410: new_references.s_admission_process_type) THEN
411: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
412: IGS_GE_MSG_STACK.ADD;
413: App_Exception.Raise_Exception;
414: END IF;
415: Check_Constraints;
416: Check_Parent_Existance;
417: ELSIF (p_action = 'UPDATE') THEN
429: new_references.admission_cat,
430: new_references.s_admission_process_type) THEN
431: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
432: IGS_GE_MSG_STACK.ADD;
433: App_Exception.Raise_Exception;
434: END IF;
435: Check_Constraints;
436: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
437: Check_Constraints;
516: end if;
517: else
518: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
519: IGS_GE_MSG_STACK.ADD;
520: app_exception.raise_exception;
521: end if;
522: Before_DML(
523: p_action=>'INSERT',
524: x_rowid=>X_ROWID,
597: if (c1%notfound) then
598: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
599: IGS_GE_MSG_STACK.ADD;
600: close c1;
601: app_exception.raise_exception;
602: return;
603: end if;
604: close c1;
605: if ( ( (tlinfo.OFFER_RESPONSE_OFFSET = X_OFFER_RESPONSE_OFFSET)
610: null;
611: else
612: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
613: IGS_GE_MSG_STACK.ADD;
614: app_exception.raise_exception;
615: end if;
616: return;
617: end LOCK_ROW;
618: Procedure UPDATE_ROW (
653: end if;
654: else
655: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
656: IGS_GE_MSG_STACK.ADD;
657: app_exception.raise_exception;
658: end if;
659: Before_DML(
660: p_action=>'UPDATE',
661: x_rowid=>X_ROWID,