APPS.IGS_CO_LTR_RPT_GRP_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:

Line 92: App_Exception.Raise_Exception;

88: new_references.letter_reference_number,
89: v_message_name) = FALSE THEN
90: Fnd_Message.Set_Name('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95:
96:

Line 120: App_Exception.Raise_Exception;

116: column_name is null Then
117: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) Then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123:
124: IF upper(column_name) = 'LETTER_REPEATING_GROUP_CD' OR

Line 129: App_Exception.Raise_Exception;

125: column_name is null Then
126: IF new_references.letter_repeating_group_cd <> UPPER(new_references.letter_repeating_group_cd) Then
127: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:
133: IF upper(column_name) = 'SUP_LETTER_REPEATING_GROUP_CD' OR

Line 139: App_Exception.Raise_Exception;

135: IF new_references.sup_repeating_group_cd <>
136: UPPER(new_references.sup_repeating_group_cd) Then
137: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF; END Check_Constraints;
142:
143:

Line 170: app_exception.raise_exception;

166: new_references.sup_repeating_group_cd
167: ) THEN
168: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: END IF;
172:
173: IF (((old_references.correspondence_type = new_references.correspondence_type) AND
174: (old_references.letter_reference_number = new_references.letter_reference_number)) OR

Line 184: app_exception.raise_exception;

180: new_references.letter_reference_number
181: ) THEN
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186:
187: END check_parent_existance;
188:

Line 293: app_exception.raise_exception;

289: IF (cur_rowid%FOUND) THEN
290: CLOSE cur_rowid;
291: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
292: igs_ge_msg_stack.add;
293: app_exception.raise_exception;
294: RETURN;
295: END IF;
296: CLOSE cur_rowid;
297:

Line 330: app_exception.raise_exception;

326: IF (cur_rowid%FOUND) THEN
327: CLOSE cur_rowid;
328: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: RETURN;
332: END IF;
333: CLOSE cur_rowid;
334:

Line 393: app_exception.raise_exception;

389: )
390: ) THEN
391: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: Check_Constraints;
396: check_parent_existance;
397: ELSIF (p_action = 'UPDATE') THEN

Line 415: app_exception.raise_exception;

411: )
412: ) THEN
413: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;
417: Check_Constraints;
418:
419: ELSIF (p_action = 'VALIDATE_DELETE') THEN

Line 475: app_exception.raise_exception;

471: END IF;
472: ELSE
473: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
477:
478: before_dml(
479: p_action => 'INSERT',

Line 566: app_exception.raise_exception;

562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: igs_ge_msg_stack.add;
565: CLOSE c1;
566: app_exception.raise_exception;
567: RETURN;
568: END IF;
569: CLOSE c1;
570:

Line 579: app_exception.raise_exception;

575: NULL;
576: ELSE
577: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
578: igs_ge_msg_stack.add;
579: app_exception.raise_exception;
580: END IF;
581:
582: RETURN;
583:

Line 627: app_exception.raise_exception;

623: END IF;
624: ELSE
625: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
626: igs_ge_msg_stack.add;
627: app_exception.raise_exception;
628: END IF;
629:
630: before_dml(
631: p_action => 'UPDATE',