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

Line 45: app_exception.raise_exception;

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

Line 90: App_Exception.Raise_Exception;

86: IF NOT IGS_TR_VAL_TRI.TRKP_VAL_TRI_TYPE (new_references.tracking_type,
87: v_message_name) THEN
88: Fnd_Message.Set_Name('IGS', v_message_name);
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;
93:
94: IF (p_inserting OR (p_updating AND (old_references.step_catalog_cd <> new_references.step_catalog_cd))) THEN

Line 99: App_Exception.Raise_Exception;

95: IF NOT IGS_TR_VAL_TRI.val_tr_step_ctlg (new_references.step_catalog_cd,
96: v_message_name) 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: END IF;
102: END BeforeRowInsertUpdate;
103:

Line 128: app_exception.raise_exception;

124: v_message_name) = FALSE THEN
125:
126: fnd_message.set_name('IGS',v_message_name);
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130: END IF;
131:
132: END beforerowinsertupdate1;

Line 149: app_exception.raise_exception;

145: new_references.recipient_id
146: )THEN
147: fnd_message.set_name('FND','FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151: END IF;
152:
153: IF (((old_references.s_tracking_step_type = new_references.s_tracking_step_type)) OR

Line 160: app_exception.raise_exception;

156: ELSE
157: IF NOT igs_lookups_view_pkg.get_pk_for_validation('TRACKING_STEP_TYPE',new_references.s_tracking_step_type)THEN
158: fnd_message.set_name('FND','FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162: END IF;
163:
164: IF (((old_references.tracking_type = new_references.tracking_type)) OR

Line 173: app_exception.raise_exception;

169: new_references.tracking_type
170: )THEN
171: fnd_message.set_name('FND','FORM_RECORD_DELETED');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175: END IF;
176:
177: IF (((old_references.step_catalog_cd = new_references.step_catalog_cd)) OR

Line 186: app_exception.raise_exception;

182: new_references.step_catalog_cd
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: END IF;
189: END check_parent_existance;
190:

Line 249: app_exception.raise_exception;

245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGS', 'IGS_TR_TTS_PE_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;
252: CLOSE cur_rowid;
253:

Line 275: app_exception.raise_exception;

271: IF (cur_rowid%FOUND) THEN
272: CLOSE cur_rowid;
273: fnd_message.set_name ('IGS', 'IGS_TR_TTS_STST_FK');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: RETURN;
277: END IF;
278: CLOSE cur_rowid;
279:

Line 306: app_exception.raise_exception;

302: IF UPPER(column_name) = 'TRACKING_TYPE_STEP_NUMBER' OR column_name IS NULL THEN
303: IF (new_references.tracking_type_step_number < 1 OR new_references.tracking_type_step_number > 99 )THEN
304: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308: END IF;
309:
310: --kumma, 2702342, increased the constant value from 999 to 9999

Line 315: app_exception.raise_exception;

311: IF UPPER(column_name) = 'ACTION_DAYS' OR column_name IS NULL THEN
312: IF (new_references.action_days < 0 OR new_references.action_days > 9999 )THEN
313: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: END IF;
317: END IF;
318:
319: IF UPPER(column_name) = 'S_TRACKING_STEP_TYPE' OR column_name IS NULL THEN

Line 323: app_exception.raise_exception;

319: IF UPPER(column_name) = 'S_TRACKING_STEP_TYPE' OR column_name IS NULL THEN
320: IF new_references.s_tracking_step_type <> UPPER(new_references.s_tracking_step_type) THEN
321: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: END IF;
326:
327: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN

Line 331: app_exception.raise_exception;

327: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN
328: IF new_references.tracking_type <> UPPER(new_references.tracking_type) THEN
329: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: END IF;
334:
335: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN

Line 339: app_exception.raise_exception;

335: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
336: IF new_references.publish_ind <> UPPER(new_references.publish_ind) THEN
337: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341: END IF;
342:
343: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN

Line 347: app_exception.raise_exception;

343: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
344: IF new_references.publish_ind NOT IN ('Y','N') THEN
345: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348: END IF;
349: END IF;
350:
351: END check_constraints;

Line 407: app_exception.raise_exception;

403: new_references.tracking_type_step_id
404: )THEN
405: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
406: igs_ge_msg_stack.add;
407: app_exception.raise_exception;
408: END IF;
409: check_constraints;
410: check_parent_existance;
411:

Line 432: app_exception.raise_exception;

428: new_references.tracking_type_step_id
429: )THEN
430: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: END IF;
434: check_constraints;
435:
436: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 504: app_exception.raise_exception;

500:
501: ELSE
502: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506:
507: before_dml(p_action =>'INSERT',
508: x_rowid =>x_rowid,

Line 608: app_exception.raise_exception;

604: FETCH c1 INTO tlinfo;
605: IF (c1%NOTFOUND) THEN
606: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: CLOSE c1;
610: RETURN;
611: END IF;
612: CLOSE c1;

Line 637: app_exception.raise_exception;

633: NULL;
634: ELSE
635: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
636: igs_ge_msg_stack.add;
637: app_exception.raise_exception;
638: END IF;
639: RETURN;
640:
641: END lock_row;

Line 684: app_exception.raise_exception;

680: END IF;
681: ELSE
682: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
683: igs_ge_msg_stack.add;
684: app_exception.raise_exception;
685: END IF;
686:
687: before_dml(p_action =>'UPDATE',
688: x_rowid =>x_rowid,