APPS.IGS_CO_LTR_PR_RSTCN_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 91: App_Exception.Raise_Exception;

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.
94: IF igs_ad_val_aal.corp_val_cort_closed(
95: new_references.correspondence_type,

Line 99: App_Exception.Raise_Exception;

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
102: -- that conflicts with the letter parameter type being restricted to a
103: -- particular correspondence type.

Line 113: App_Exception.Raise_Exception;

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;
116:
117:

Line 138: App_Exception.Raise_Exception;

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

Line 148: App_Exception.Raise_Exception;

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;
151:
152: END Check_Constraints;

Line 175: app_exception.raise_exception;

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:
178: IF (((old_references.letter_parameter_type = new_references.letter_parameter_type)) OR
179: ((new_references.letter_parameter_type IS NULL))) THEN

Line 186: app_exception.raise_exception;

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

Line 256: app_exception.raise_exception;

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

Line 291: app_exception.raise_exception;

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

Line 346: app_exception.raise_exception;

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

Line 365: app_exception.raise_exception;

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;
368:
369: END before_dml;

Line 416: app_exception.raise_exception;

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