[Home] [Help]
42: OPEN cur_old_ref_values;
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
88: NULL;
89: ELSIF NOT igs_co_ltr_parm_type_pkg.get_pk_for_validation (
90: new_references.letter_parameter_type
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
102: ELSIF NOT igs_co_s_ltr_pkg.get_pk_for_validation (
103: new_references.correspondence_type,
104: new_references.letter_reference_number
105: ) THEN
106: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110:
129:
130: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR
131: column_name is null Then
132: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) Then
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
139: IF upper(column_name) = 'LETTER_PARAMETER_TYPE' OR
140: column_name is null Then
141: IF new_references.letter_parameter_type<>
142: UPPER(new_references.letter_parameter_type) Then
143: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147: END IF;
149:
150: IF upper(column_name) = 'LETTER_ORDER_NUMBER' OR
151: column_name is null Then
152: IF new_references.letter_order_number < 1 Then
153: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
177: -- Validate Correspondence Type closed.
178: IF igs_ad_val_aal.corp_val_cort_closed(
179: new_references.correspondence_type,
180: v_message_name) = FALSE THEN
181: Fnd_Message.Set_Name('IGS',v_message_name);
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185: -- Validate System Letter closed.
186: IF igs_ad_val_apcl.corp_val_slet_closed(
187: new_references.correspondence_type,
188: new_references.letter_reference_number,
189: v_message_name) = FALSE THEN
190: Fnd_Message.Set_Name('IGS',v_message_name);
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: END IF;
194: -- Validate Letter Parameter Type closed.
194: -- Validate Letter Parameter Type closed.
195: IF igs_ad_val_aalp.corp_val_lpt_closed(
196: new_references.letter_parameter_type,
197: v_message_name) = FALSE THEN
198: Fnd_Message.Set_Name('IGS',v_message_name);
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END IF;
202: -- Validate if restrictions exists preventing the letter parameter type being
204: IF IGS_CO_VAL_LP.corp_val_lptr_rstrn(
205: new_references.letter_parameter_type,
206: new_references.correspondence_type,
207: v_message_name) = FALSE THEN
208: Fnd_Message.Set_Name('IGS',v_message_name);
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
305: OPEN cur_rowid;
306: FETCH cur_rowid INTO lv_rowid;
307: IF (cur_rowid%FOUND) THEN
308: CLOSE cur_rowid;
309: fnd_message.set_name ('IGS', 'IGS_CO_LPT_LP_FK');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: RETURN;
313: END IF;
342: OPEN cur_rowid;
343: FETCH cur_rowid INTO lv_rowid;
344: IF (cur_rowid%FOUND) THEN
345: CLOSE cur_rowid;
346: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
347: igs_ge_msg_stack.add;
348: app_exception.raise_exception;
349: RETURN;
350: END IF;
401: new_references.correspondence_type,
402: new_references.letter_reference_number
403: )
404: ) THEN
405: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
406: igs_ge_msg_stack.add;
407: app_exception.raise_exception;
408: END IF;
409: check_parent_existance;
420: new_references.correspondence_type,
421: new_references.letter_reference_number
422: )
423: ) THEN
424: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
425: igs_ge_msg_stack.add;
426: app_exception.raise_exception;
427: END IF;
428: ELSIF (p_action = 'VALIDATE_DELETE') THEN
475: IF (x_last_update_login IS NULL) THEN
476: x_last_update_login := -1;
477: END IF;
478: ELSE
479: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482: END IF;
483:
557:
558: OPEN c1;
559: FETCH c1 INTO tlinfo;
560: IF (c1%notfound) THEN
561: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
562: igs_ge_msg_stack.add;
563: CLOSE c1;
564: app_exception.raise_exception;
565: RETURN;
570: (tlinfo.letter_parameter_type = x_letter_parameter_type)
571: ) THEN
572: NULL;
573: ELSE
574: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
575: igs_ge_msg_stack.add;
576: app_exception.raise_exception;
577: END IF;
578:
617: IF (x_last_update_login IS NULL) THEN
618: x_last_update_login := -1;
619: END IF;
620: ELSE
621: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
622: igs_ge_msg_stack.add;
623: app_exception.raise_exception;
624: END IF;
625: