[Home] [Help]
41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
85: -- Validate Letter Parameter Type closed.
86: IF igs_ad_val_aalp.corp_val_lpt_closed(
87: new_references.letter_parameter_type,
88: v_message_name) = FALSE THEN
89: Fnd_Message.Set_Name('IGS',v_message_name);
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: -- Validate Correspondence Type closed.
93: -- Validate Correspondence Type closed.
94: IF igs_ad_val_aal.corp_val_cort_closed(
95: new_references.correspondence_type,
96: v_message_name) = FALSE THEN
97: Fnd_Message.Set_Name('IGS',v_message_name);
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: -- Validate that no System Letter Parameter Type Restrictions exists
107: IF IGS_CO_VAL_LPTR.corp_val_slptr_rstrn(
108: v_s_letter_parameter_type,
109: new_references.correspondence_type,
110: v_message_name) = FALSE THEN
111: Fnd_Message.Set_Name('IGS',v_message_name);
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
132:
133: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR
134: column_name is null Then
135: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) Then
136: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
142: IF upper(column_name) = 'LETTER_PARAMETER_TYPE' OR
143: column_name is null Then
144: IF new_references.letter_parameter_type <>
145: UPPER(new_references.letter_parameter_type) Then
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
169: NULL;
170: ELSIF NOT igs_co_type_pkg.get_pk_for_validation (
171: new_references.correspondence_type
172: ) THEN
173: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: END IF;
177:
180: NULL;
181: ELSIF NOT igs_co_ltr_parm_type_pkg.get_pk_for_validation (
182: new_references.letter_parameter_type
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:
250: OPEN cur_rowid;
251: FETCH cur_rowid INTO lv_rowid;
252: IF (cur_rowid%FOUND) THEN
253: CLOSE cur_rowid;
254: fnd_message.set_name ('IGS', 'IGS_CO_CORT_LPTR_FK');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: RETURN;
258: END IF;
285: OPEN cur_rowid;
286: FETCH cur_rowid INTO lv_rowid;
287: IF (cur_rowid%FOUND) THEN
288: CLOSE cur_rowid;
289: fnd_message.set_name ('IGS', 'IGS_CO_LPT_LPTR_FK');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: RETURN;
293: END IF;
340: new_references.letter_parameter_type,
341: new_references.correspondence_type
342: )
343: ) THEN
344: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
345: igs_ge_msg_stack.add;
346: app_exception.raise_exception;
347: END IF;
348: Check_Constraints;
359: new_references.letter_parameter_type,
360: new_references.correspondence_type
361: )
362: ) THEN
363: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
364: igs_ge_msg_stack.add;
365: app_exception.raise_exception;
366: END IF;
367: END IF;
410: IF (x_last_update_login IS NULL) THEN
411: x_last_update_login := -1;
412: END IF;
413: ELSE
414: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418: