eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CO_LTR_PARAM_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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;
51: CLOSE cur_old_ref_values;
52:

Line 94: app_exception.raise_exception;

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:
97: IF (((old_references.correspondence_type = new_references.correspondence_type) AND
98: (old_references.letter_reference_number = new_references.letter_reference_number)) OR

Line 108: app_exception.raise_exception;

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:
111: END check_parent_existance;
112:

Line 135: App_Exception.Raise_Exception;

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;
138:
139: IF upper(column_name) = 'LETTER_PARAMETER_TYPE' OR

Line 145: App_Exception.Raise_Exception;

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;
148:
149:

Line 155: App_Exception.Raise_Exception;

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;
158:
159:

Line 183: App_Exception.Raise_Exception;

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,

Line 192: App_Exception.Raise_Exception;

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.
195: IF igs_ad_val_aalp.corp_val_lpt_closed(
196: new_references.letter_parameter_type,

Line 200: App_Exception.Raise_Exception;

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
203: -- assigned to the correspondence type.
204: IF IGS_CO_VAL_LP.corp_val_lptr_rstrn(

Line 210: App_Exception.Raise_Exception;

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;
213:
214:

Line 311: app_exception.raise_exception;

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;
314: CLOSE cur_rowid;
315:

Line 348: app_exception.raise_exception;

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;
351: CLOSE cur_rowid;
352:

Line 407: app_exception.raise_exception;

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;
410: ELSIF (p_action = 'UPDATE') THEN
411: -- Call all the procedures related to Before Update.

Line 426: app_exception.raise_exception;

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
429: check_child_existance;
430: END IF;

Line 481: app_exception.raise_exception;

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:
484: before_dml(
485: p_action => 'INSERT',

Line 564: app_exception.raise_exception;

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;
566: END IF;
567: CLOSE c1;
568:

Line 576: app_exception.raise_exception;

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:
579: RETURN;
580:

Line 623: app_exception.raise_exception;

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:
626: before_dml(
627: p_action => 'UPDATE',