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

Line 43: app_exception.raise_exception;

39: FETCH cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
42: igs_ge_msg_stack.add;
43: app_exception.raise_exception;
44: CLOSE cur_old_ref_values;
45: RETURN;
46: END IF;
47: CLOSE cur_old_ref_values;

Line 85: app_exception.raise_exception;

81: ELSE
82: IF NOT igs_lookups_view_pkg.get_pk_for_validation('TRACKING_TYPE',new_references.s_tracking_type)THEN
83: fnd_message.set_name('FND','FORM_RECORD_DELETED');
84: igs_ge_msg_stack.add;
85: app_exception.raise_exception;
86: END IF;
87: END IF;
88:
89: END check_parent_existance;

Line 135: app_exception.raise_exception;

131: IF (cur_rowid%FOUND) THEN
132: CLOSE cur_rowid;
133: fnd_message.set_name ('IGS', 'IGS_TR_TRT_STT_FK');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: RETURN;
137: END IF;
138: CLOSE cur_rowid;
139:

Line 171: app_exception.raise_exception;

167: IF UPPER(column_name) = 'TARGET_DAYS' OR column_name IS NULL THEN
168: IF (new_references.target_days < 0 OR new_references.target_days > 9999 )THEN
169: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: END IF;
173: END IF;
174:
175: IF UPPER(column_name) = 'BUSINESS_DAYS_IND' OR column_name IS NULL THEN

Line 179: app_exception.raise_exception;

175: IF UPPER(column_name) = 'BUSINESS_DAYS_IND' OR column_name IS NULL THEN
176: IF new_references.business_days_ind NOT IN ('Y','N') THEN
177: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181: END IF;
182:
183: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN

Line 187: app_exception.raise_exception;

183: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN
184: IF new_references.closed_ind NOT IN ('Y','N') THEN
185: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189: END IF;
190:
191: IF UPPER(column_name) = 'SEQUENCE_IND' OR column_name IS NULL THEN

Line 195: app_exception.raise_exception;

191: IF UPPER(column_name) = 'SEQUENCE_IND' OR column_name IS NULL THEN
192: IF new_references.sequence_ind NOT IN ('Y','N') THEN
193: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
194: igs_ge_msg_stack.add;
195: app_exception.raise_exception;
196: END IF;
197: END IF;
198:
199: IF UPPER(column_name) = 'BUSINESS_DAYS_IND' OR column_name IS NULL THEN

Line 203: app_exception.raise_exception;

199: IF UPPER(column_name) = 'BUSINESS_DAYS_IND' OR column_name IS NULL THEN
200: IF new_references.business_days_ind <> UPPER(new_references.business_days_ind) THEN
201: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: END IF;
205: END IF;
206:
207: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN

Line 211: app_exception.raise_exception;

207: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN
208: IF new_references.closed_ind <> UPPER(new_references.closed_ind) THEN
209: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END IF;
213: END IF;
214:
215: IF UPPER(column_name) = 'SEQUENCE_IND' OR column_name IS NULL THEN

Line 219: app_exception.raise_exception;

215: IF UPPER(column_name) = 'SEQUENCE_IND' OR column_name IS NULL THEN
216: IF new_references.sequence_ind <> UPPER(new_references.sequence_ind) THEN
217: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221: END IF;
222:
223: IF UPPER(column_name) = 'S_TRACKING_TYPE' OR column_name IS NULL THEN

Line 227: app_exception.raise_exception;

223: IF UPPER(column_name) = 'S_TRACKING_TYPE' OR column_name IS NULL THEN
224: IF new_references.s_tracking_type <> UPPER(new_references.s_tracking_type) THEN
225: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229: END IF;
230:
231: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN

Line 235: app_exception.raise_exception;

231: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN
232: IF new_references.tracking_type <> UPPER(new_references.tracking_type) THEN
233: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: END IF;
237: END IF;
238:
239: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN

Line 243: app_exception.raise_exception;

239: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
240: IF new_references.publish_ind NOT IN ('Y','N') THEN
241: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245: END IF;
246:
247: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN

Line 251: app_exception.raise_exception;

247: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
248: IF new_references.publish_ind <> UPPER(new_references.publish_ind) THEN
249: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: END IF;
253: END IF;
254: END check_constraints;
255:

Line 304: app_exception.raise_exception;

300:
301: IF get_pk_for_validation( new_references.tracking_type )THEN
302: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306: check_constraints;
307: check_parent_existance;
308:

Line 320: app_exception.raise_exception;

316: -- Call all the procedures related to Before Delete.
317: IF get_pk_for_validation( new_references.tracking_type)THEN
318: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: END IF;
322: check_constraints;
323:
324: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 386: app_exception.raise_exception;

382:
383: ELSE
384: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
389: before_dml(
390: p_action =>'INSERT',

Line 482: app_exception.raise_exception;

478: FETCH c1 INTO tlinfo;
479: IF (c1%NOTFOUND) THEN
480: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: CLOSE c1;
484: RETURN;
485: END IF;
486: CLOSE c1;

Line 502: app_exception.raise_exception;

498: NULL;
499: ELSE
500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: END IF;
504: RETURN;
505: END lock_row;
506:

Line 541: app_exception.raise_exception;

537: END IF;
538: ELSE
539: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
540: igs_ge_msg_stack.add;
541: app_exception.raise_exception;
542: END IF;
543:
544: before_dml(p_action =>'UPDATE',
545: x_rowid =>x_rowid,