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 IGS_GE_MSG_STACK

Line 45: igs_ge_msg_stack.add;

41: OPEN cur_old_ref_values;
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;

Line 92: IGS_GE_MSG_STACK.ADD;

88: IF (p_inserting OR (p_updating AND (old_references.step_catalog_cd <> new_references.step_catalog_cd))) THEN
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;

Line 130: igs_ge_msg_stack.add;

126: new_references.by_pass_ind,
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:

Line 152: igs_ge_msg_stack.add;

148: v_tracking_type,
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:

Line 169: igs_ge_msg_stack.add;

165: NULL;
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:

Line 180: igs_ge_msg_stack.add;

176: NULL;
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:

Line 190: igs_ge_msg_stack.add;

186: NULL;
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:

Line 200: igs_ge_msg_stack.add;

196: NULL;
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;

Line 262: igs_ge_msg_stack.add;

258: FETCH cur_rowid INTO lv_rowid;
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;

Line 288: igs_ge_msg_stack.add;

284: FETCH cur_rowid INTO lv_rowid;
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;

Line 315: igs_ge_msg_stack.add;

311: FETCH cur_rowid INTO lv_rowid;
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;

Line 351: igs_ge_msg_stack.add;

347:
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:

Line 360: igs_ge_msg_stack.add;

356: --kumma, 2702342, increased the constant value from 999 to 9999
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:

Line 368: igs_ge_msg_stack.add;

364:
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:

Line 376: igs_ge_msg_stack.add;

372:
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:

Line 384: igs_ge_msg_stack.add;

380:
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:

Line 392: igs_ge_msg_stack.add;

388:
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:

Line 400: igs_ge_msg_stack.add;

396:
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:

Line 408: igs_ge_msg_stack.add;

404:
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:

Line 416: igs_ge_msg_stack.add;

412:
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:

Line 480: igs_ge_msg_stack.add;

476: new_references.tracking_id,
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;

Line 505: igs_ge_msg_stack.add;

501: new_references.tracking_id,
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:

Line 587: igs_ge_msg_stack.add;

583: END IF;
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',

Line 704: igs_ge_msg_stack.add;

700: OPEN c1;
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;

Line 739: igs_ge_msg_stack.add;

735: NULL;
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:

Line 786: igs_ge_msg_stack.add;

782: x_last_update_login := -1;
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',