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_PR_RPT_GR_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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;
54: CLOSE cur_old_ref_values;
55:

Line 105: app_exception.raise_exception;

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:
108: IF (((old_references.letter_order_number = new_references.letter_order_number) AND
109: (old_references.correspondence_type = new_references.correspondence_type) AND

Line 122: app_exception.raise_exception;

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:
125: END check_parent_existance;
126:

Line 150: App_Exception.Raise_Exception;

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

Line 160: App_Exception.Raise_Exception;

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

Line 169: App_Exception.Raise_Exception;

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

Line 178: App_Exception.Raise_Exception;

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;
181:
182:

Line 206: App_Exception.Raise_Exception;

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

Line 214: App_Exception.Raise_Exception;

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;
217:
218:

Line 316: app_exception.raise_exception;

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;
319: CLOSE cur_rowid;
320:

Line 355: app_exception.raise_exception;

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;
358: CLOSE cur_rowid;
359:

Line 419: app_exception.raise_exception;

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;
422: check_parent_existance;
423: ELSIF (p_action = 'UPDATE') THEN

Line 441: app_exception.raise_exception;

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;
444: ELSIF (p_action = 'VALIDATE_DELETE') THEN
445: check_child_existance;

Line 500: app_exception.raise_exception;

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

Line 591: app_exception.raise_exception;

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;
593: END IF;
594: CLOSE c1;
595:

Line 604: app_exception.raise_exception;

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:
607: RETURN;
608:

Line 652: app_exception.raise_exception;

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