[Home] [Help]
48: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
49: CLOSE cur_old_ref_values;
50: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
51: igs_ge_msg_stack.add;
52: app_exception.raise_exception;
53: RETURN;
54: END IF;
55: CLOSE cur_old_ref_values;
56:
103: IF (UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL) THEN
104: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
105: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: END IF;
109: END IF;
110:
111: END check_constraints;
128: IF (cur_rowid%FOUND) THEN
129: Close cur_rowid;
130: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_LKUP_FK');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: Return;
134: END IF;
135: Close cur_rowid;
136:
154: IF (cur_rowid%FOUND) THEN
155: Close cur_rowid;
156: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_LKUP_FK');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: Return;
160: END IF;
161: Close cur_rowid;
162:
181: new_references.correspondence_type,
182: v_message_name) = FALSE THEN
183: Fnd_Message.Set_Name('IGS',v_message_name);
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: -- Validate Correspondence Type is system generated.
188: IF IGS_CO_VAL_SLET.corp_val_cort_sysgen(
189: new_references.correspondence_type,
189: new_references.correspondence_type,
190: v_message_name) = FALSE THEN
191: Fnd_Message.Set_Name('IGS',v_message_name);
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
196: -- Validate System Letter Object closed.
197: IF p_inserting OR
201: new_references.s_letter_object,
202: v_message_name) = FALSE THEN
203: Fnd_Message.Set_Name('IGS',v_message_name);
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: END IF;
208:
209:
230: new_references.correspondence_type
231: ) THEN
232: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
233: igs_ge_msg_stack.add;
234: app_exception.raise_exception;
235: END IF;
236:
237: END check_parent_existance;
238:
325: IF (cur_rowid%FOUND) THEN
326: CLOSE cur_rowid;
327: fnd_message.set_name ('IGS', 'IGS_CO_CORT_SLET_FK');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: RETURN;
331: END IF;
332: CLOSE cur_rowid;
333:
391: )
392: ) THEN
393: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END IF;
397: check_constraints;
398: check_parent_existance;
399: ELSIF (p_action = 'UPDATE') THEN
412: )
413: ) THEN
414: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418: check_constraints;
419: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
420: check_constraints;
473: END IF;
474: ELSE
475: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479:
480: before_dml(
481: p_action => 'INSERT',
577: IF (c1%notfound) THEN
578: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
579: igs_ge_msg_stack.add;
580: CLOSE c1;
581: app_exception.raise_exception;
582: RETURN;
583: END IF;
584: CLOSE c1;
585:
594: NULL;
595: ELSE
596: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
597: igs_ge_msg_stack.add;
598: app_exception.raise_exception;
599: END IF;
600:
601: RETURN;
602:
645: END IF;
646: ELSE
647: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
648: igs_ge_msg_stack.add;
649: app_exception.raise_exception;
650: END IF;
651:
652: before_dml(
653: p_action => 'UPDATE',