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

Line 46: app_exception.raise_exception;

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

Line 93: App_Exception.Raise_Exception;

89: IF NOT IGS_TR_VAL_TRI.val_tr_step_ctlg (new_references.step_catalog_cd,
90: v_message_name) THEN
91: Fnd_Message.Set_Name('IGS', v_message_name);
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception;
94: END IF;
95: END IF;
96: END BeforeRowInsertUpdate;
97:

Line 131: app_exception.raise_exception;

127: v_message_name) = FALSE THEN
128:
129: fnd_message.set_name('IGS',v_message_name);
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133: END IF;
134:
135: -- Validate the tracking step type.

Line 153: app_exception.raise_exception;

149: v_message_name) = FALSE THEN
150:
151: fnd_message.set_name('IGS',v_message_name);
152: igs_ge_msg_stack.add;
153: app_exception.raise_exception;
154: END IF;
155: END IF;
156:
157: END beforerowinsertupdatedelete1;

Line 170: app_exception.raise_exception;

166: ELSE
167: IF NOT igs_pe_person_pkg.get_pk_for_validation ( new_references.recipient_id )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: END IF;
173:
174: IF (((old_references.s_tracking_step_type = new_references.s_tracking_step_type)) OR

Line 181: app_exception.raise_exception;

177: ELSE
178: IF NOT igs_lookups_view_pkg.get_pk_for_validation('TRACKING_STEP_TYPE',new_references.s_tracking_step_type)THEN
179: fnd_message.set_name('FND','FORM_RECORD_DELETED');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END IF;
183: END IF;
184:
185: IF (((old_references.tracking_id = new_references.tracking_id)) OR ((new_references.tracking_id IS NULL))) THEN

Line 191: app_exception.raise_exception;

187: ELSE
188: IF NOT igs_tr_item_pkg.get_pk_for_validation ( new_references.tracking_id )THEN
189: fnd_message.set_name('FND','FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193: END IF;
194:
195: IF (((old_references.step_catalog_cd = new_references.step_catalog_cd)) OR ((new_references.step_catalog_cd IS NULL))) THEN

Line 201: app_exception.raise_exception;

197: ELSE
198: IF NOT igs_tr_step_ctlg_pkg.get_uk_for_validation ( new_references.step_catalog_cd )THEN
199: fnd_message.set_name('FND','FORM_RECORD_DELETED');
200: igs_ge_msg_stack.add;
201: app_exception.raise_exception;
202: END IF;
203: END IF;
204: END check_parent_existance;
205:

Line 263: app_exception.raise_exception;

259: IF (cur_rowid%FOUND) THEN
260: CLOSE cur_rowid;
261: fnd_message.set_name ('IGS', 'IGS_TR_TRST_PE_RECIPIENT_FK');
262: igs_ge_msg_stack.add;
263: app_exception.raise_exception;
264: RETURN;
265: END IF;
266: CLOSE cur_rowid;
267:

Line 289: app_exception.raise_exception;

285: IF (cur_rowid%FOUND) THEN
286: CLOSE cur_rowid;
287: fnd_message.set_name ('IGS', 'IGS_TR_TRST_TRI_FK');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: RETURN;
291: END IF;
292: CLOSE cur_rowid;
293:

Line 316: app_exception.raise_exception;

312: IF (cur_rowid%FOUND) THEN
313: CLOSE cur_rowid;
314: fnd_message.set_name ('IGS', 'IGS_TR_TRST_STST_FK');
315: igs_ge_msg_stack.add;
316: app_exception.raise_exception;
317: RETURN;
318: END IF;
319: CLOSE cur_rowid;
320:

Line 352: app_exception.raise_exception;

348: IF UPPER(column_name) = 'TRACKING_STEP_NUMBER' OR column_name IS NULL THEN
349: IF (new_references.tracking_step_number < 1 OR new_references.tracking_step_number > 99 )THEN
350: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354: END IF;
355:
356: --kumma, 2702342, increased the constant value from 999 to 9999

Line 361: app_exception.raise_exception;

357: IF UPPER(column_name) = 'ACTION_DAYS' OR column_name IS NULL THEN
358: IF (new_references.action_days < 0 OR new_references.action_days > 9999 )THEN
359: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363: END IF;
364:
365: IF UPPER(column_name) = 'STEP_COMPLETION_IND' OR column_name IS NULL THEN

Line 369: app_exception.raise_exception;

365: IF UPPER(column_name) = 'STEP_COMPLETION_IND' OR column_name IS NULL THEN
366: IF new_references.step_completion_ind NOT IN ('Y','N') THEN
367: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371: END IF;
372:
373: IF UPPER(column_name) = 'BY_PASS_IND' OR column_name IS NULL THEN

Line 377: app_exception.raise_exception;

373: IF UPPER(column_name) = 'BY_PASS_IND' OR column_name IS NULL THEN
374: IF new_references.by_pass_ind NOT IN ('Y','N') THEN
375: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: END IF;
379: END IF;
380:
381: IF UPPER(column_name) = 'BY_PASS_IND' OR column_name IS NULL THEN

Line 385: app_exception.raise_exception;

381: IF UPPER(column_name) = 'BY_PASS_IND' OR column_name IS NULL THEN
382: IF new_references.by_pass_ind <> UPPER(new_references.by_pass_ind) THEN
383: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
384: igs_ge_msg_stack.add;
385: app_exception.raise_exception;
386: END IF;
387: END IF;
388:
389: IF UPPER(column_name) = 'STEP_COMPLETION_IND' OR column_name IS NULL THEN

Line 393: app_exception.raise_exception;

389: IF UPPER(column_name) = 'STEP_COMPLETION_IND' OR column_name IS NULL THEN
390: IF new_references.step_completion_ind <> UPPER(new_references.step_completion_ind) THEN
391: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: END IF;
396:
397: IF UPPER(column_name) = 'S_TRACKING_STEP_TYPE' OR column_name IS NULL THEN

Line 401: app_exception.raise_exception;

397: IF UPPER(column_name) = 'S_TRACKING_STEP_TYPE' OR column_name IS NULL THEN
398: IF new_references.s_tracking_step_type <> UPPER(new_references.s_tracking_step_type) THEN
399: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403: END IF;
404:
405: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN

Line 409: app_exception.raise_exception;

405: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
406: IF new_references.publish_ind <> UPPER(new_references.publish_ind) THEN
407: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
408: igs_ge_msg_stack.add;
409: app_exception.raise_exception;
410: END IF;
411: END IF;
412:
413: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN

Line 417: app_exception.raise_exception;

413: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
414: IF new_references.publish_ind NOT IN ('Y','N') THEN
415: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: END IF;
419: END IF;
420:
421: END check_constraints;

Line 481: app_exception.raise_exception;

477: new_references.tracking_step_id
478: )THEN
479: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482: END IF;
483: check_constraints;
484: check_parent_existance;
485:

Line 506: app_exception.raise_exception;

502: new_references.tracking_step_id
503: )THEN
504: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: END IF;
508: check_constraints;
509:
510: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 588: app_exception.raise_exception;

584:
585: ELSE
586: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
587: igs_ge_msg_stack.add;
588: app_exception.raise_exception;
589: END IF;
590:
591: before_dml(p_action =>'INSERT',
592: x_rowid =>x_rowid,

Line 705: app_exception.raise_exception;

701: FETCH c1 INTO tlinfo;
702: IF (c1%NOTFOUND) THEN
703: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
704: igs_ge_msg_stack.add;
705: app_exception.raise_exception;
706: CLOSE c1;
707: RETURN;
708: END IF;
709: CLOSE c1;

Line 740: app_exception.raise_exception;

736:
737: ELSE
738: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
739: igs_ge_msg_stack.add;
740: app_exception.raise_exception;
741: END IF;
742: RETURN;
743:
744: END lock_row;

Line 787: app_exception.raise_exception;

783: END IF;
784: ELSE
785: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
786: igs_ge_msg_stack.add;
787: app_exception.raise_exception;
788: END IF;
789:
790: before_dml(p_action =>'UPDATE',
791: x_rowid =>x_rowid,