[Home] [Help]
45: OPEN cur_old_ref_values;
46: FETCH cur_old_ref_values INTO old_references;
47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
99: new_references.correspondence_type,
100: new_references.letter_reference_number,
101: new_references.letter_repeating_group_cd
102: ) THEN
103: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
116: new_references.letter_order_number,
117: new_references.correspondence_type,
118: new_references.letter_reference_number
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
144:
145: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR
146: column_name is null Then
147: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) Then
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
154: IF upper(column_name) = 'LETTER_PARAMETER_TYPE' OR
155: column_name is null Then
156: IF new_references.letter_parameter_type <>
157: UPPER(new_references.letter_parameter_type) Then
158: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
163:
164: IF upper(column_name) = 'LETTER_REPEATING_GROUP_CD' OR
165: column_name is null Then
166: IF new_references.letter_repeating_group_cd <> UPPER(new_references.letter_repeating_group_cd) Then
167: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;
172:
173: IF upper(column_name) = 'LETTER_ORDER_NUMBER' OR
174: column_name is null Then
175: IF new_references.letter_order_number < 1 Then
176: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;
200: IF igs_ad_val_apcl.corp_val_slet_closed(
201: new_references.correspondence_type,
202: new_references.letter_reference_number,
203: v_message_name) = FALSE THEN
204: Fnd_Message.Set_Name('IGS',v_message_name);
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: -- Validate Letter Parameter Type closed.
208: -- Validate Letter Parameter Type closed.
209: IF igs_ad_val_aalp.corp_val_lpt_closed(
210: new_references.letter_parameter_type,
211: v_message_name) = FALSE THEN
212: Fnd_Message.Set_Name('IGS',v_message_name);
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END IF;
216: END IF;
310: OPEN cur_rowid;
311: FETCH cur_rowid INTO lv_rowid;
312: IF (cur_rowid%FOUND) THEN
313: CLOSE cur_rowid;
314: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
315: igs_ge_msg_stack.add;
316: app_exception.raise_exception;
317: RETURN;
318: END IF;
349: OPEN cur_rowid;
350: FETCH cur_rowid INTO lv_rowid;
351: IF (cur_rowid%FOUND) THEN
352: CLOSE cur_rowid;
353: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: RETURN;
357: END IF;
413: new_references.letter_reference_number,
414: new_references.letter_repeating_group_cd
415: )
416: ) THEN
417: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
418: igs_ge_msg_stack.add;
419: app_exception.raise_exception;
420: END IF;
421: Check_Constraints;
435: new_references.letter_reference_number,
436: new_references.letter_repeating_group_cd
437: )
438: ) THEN
439: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
440: igs_ge_msg_stack.add;
441: app_exception.raise_exception;
442: END IF;
443: Check_Constraints;
494: IF (x_last_update_login IS NULL) THEN
495: x_last_update_login := -1;
496: END IF;
497: ELSE
498: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
499: igs_ge_msg_stack.add;
500: app_exception.raise_exception;
501: END IF;
502:
584:
585: OPEN c1;
586: FETCH c1 INTO tlinfo;
587: IF (c1%notfound) THEN
588: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
589: igs_ge_msg_stack.add;
590: CLOSE c1;
591: app_exception.raise_exception;
592: RETURN;
598:
599: ) THEN
600: NULL;
601: ELSE
602: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605: END IF;
606:
646: IF (x_last_update_login IS NULL) THEN
647: x_last_update_login := -1;
648: END IF;
649: ELSE
650: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
651: igs_ge_msg_stack.add;
652: app_exception.raise_exception;
653: END IF;
654: