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 IGS_GE_MSG_STACK

Line 50: igs_ge_msg_stack.add;

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

Line 104: igs_ge_msg_stack.add;

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

Line 121: igs_ge_msg_stack.add;

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

Line 149: IGS_GE_MSG_STACK.ADD;

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;
153:

Line 159: IGS_GE_MSG_STACK.ADD;

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:

Line 168: IGS_GE_MSG_STACK.ADD;

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:

Line 177: IGS_GE_MSG_STACK.ADD;

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

Line 205: IGS_GE_MSG_STACK.ADD;

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.
209: IF igs_ad_val_aalp.corp_val_lpt_closed(

Line 213: IGS_GE_MSG_STACK.ADD;

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

Line 315: igs_ge_msg_stack.add;

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

Line 354: igs_ge_msg_stack.add;

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

Line 418: igs_ge_msg_stack.add;

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;
422: check_parent_existance;

Line 440: igs_ge_msg_stack.add;

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

Line 499: igs_ge_msg_stack.add;

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:
503: before_dml(

Line 589: igs_ge_msg_stack.add;

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;
593: END IF;

Line 603: igs_ge_msg_stack.add;

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

Line 651: igs_ge_msg_stack.add;

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:
655: before_dml(