[Home] [Help]
45: FETCH cur_old_ref_values INTO old_references;
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;
87: new_references.correspondence_type,
88: new_references.letter_reference_number,
89: v_message_name) = FALSE THEN
90: Fnd_Message.Set_Name('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95:
115: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR
116: column_name is null Then
117: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) Then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123:
124: IF upper(column_name) = 'LETTER_REPEATING_GROUP_CD' OR
125: column_name is null Then
126: IF new_references.letter_repeating_group_cd <> UPPER(new_references.letter_repeating_group_cd) Then
127: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:
134: column_name is null Then
135: IF new_references.sup_repeating_group_cd <>
136: UPPER(new_references.sup_repeating_group_cd) Then
137: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF; END Check_Constraints;
142:
165: new_references.letter_reference_number,
166: new_references.sup_repeating_group_cd
167: ) THEN
168: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: END IF;
172:
173: IF (((old_references.correspondence_type = new_references.correspondence_type) AND
179: new_references.correspondence_type,
180: new_references.letter_reference_number
181: ) THEN
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186:
187: END check_parent_existance;
288: FETCH cur_rowid INTO lv_rowid;
289: IF (cur_rowid%FOUND) THEN
290: CLOSE cur_rowid;
291: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
292: igs_ge_msg_stack.add;
293: app_exception.raise_exception;
294: RETURN;
295: END IF;
296: CLOSE cur_rowid;
325: FETCH cur_rowid INTO lv_rowid;
326: IF (cur_rowid%FOUND) THEN
327: CLOSE cur_rowid;
328: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: RETURN;
332: END IF;
333: CLOSE cur_rowid;
388: new_references.letter_repeating_group_cd
389: )
390: ) THEN
391: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: Check_Constraints;
396: check_parent_existance;
410: new_references.letter_repeating_group_cd
411: )
412: ) THEN
413: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;
417: Check_Constraints;
418:
470: x_last_update_login := -1;
471: END IF;
472: ELSE
473: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
477:
478: before_dml(
560: OPEN c1;
561: FETCH c1 INTO tlinfo;
562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: igs_ge_msg_stack.add;
565: CLOSE c1;
566: app_exception.raise_exception;
567: RETURN;
568: END IF;
574: ) THEN
575: NULL;
576: ELSE
577: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
578: igs_ge_msg_stack.add;
579: app_exception.raise_exception;
580: END IF;
581:
582: RETURN;
622: x_last_update_login := -1;
623: END IF;
624: ELSE
625: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
626: igs_ge_msg_stack.add;
627: app_exception.raise_exception;
628: END IF;
629:
630: before_dml(