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

Line 40: App_Exception.Raise_Exception;

36: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: Close cur_old_ref_values;
40: App_Exception.Raise_Exception;
41:
42: Return;
43: END IF;
44: Close cur_old_ref_values;

Line 82: App_Exception.Raise_Exception;

78: new_references.spo_sequence_number
79: )THEN
80: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83:
84: END IF;
85:
86: END IF;

Line 97: App_Exception.Raise_Exception;

93: new_references.unit_cd
94: )THEN
95: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98:
99: END IF;
100:
101: END IF;

Line 160: App_Exception.Raise_Exception;

156: IF (cur_rowid%FOUND) THEN
157: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_SPO_FK');
158: IGS_GE_MSG_STACK.ADD;
159: Close cur_rowid;
160: App_Exception.Raise_Exception;
161:
162: Return;
163: END IF;
164: Close cur_rowid;

Line 187: App_Exception.Raise_Exception;

183: IF (cur_rowid%FOUND) THEN
184: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPU_UN_FK');
185: IGS_GE_MSG_STACK.ADD;
186: Close cur_rowid;
187: App_Exception.Raise_Exception;
188:
189: Return;
190: END IF;
191: Close cur_rowid;

Line 236: App_Exception.Raise_Exception;

232: new_references.spo_sequence_number,
233: new_references.unit_cd) THEN
234: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: CHECK_CONSTRAINTS;
239:
240: ELSIF (p_action = 'UPDATE') THEN

Line 254: App_Exception.Raise_Exception;

250: new_references.spo_sequence_number,
251: new_references.unit_cd) THEN
252: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: CHECK_CONSTRAINTS;
257:
258: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 299: app_exception.raise_exception;

295: end if;
296: else
297: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
298: IGS_GE_MSG_STACK.ADD;
299: app_exception.raise_exception;
300: end if;
301: Before_DML (
302: p_action => 'INSERT',
303: x_rowid => x_rowid ,

Line 361: app_exception.raise_exception;

357: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
358: fnd_message.set_token ('ERR_CD', SQLCODE);
359: igs_ge_msg_stack.add;
360: igs_sc_gen_001.unset_ctx('R');
361: app_exception.raise_exception;
362: ELSE
363: igs_sc_gen_001.unset_ctx('R');
364: RAISE;
365: END IF;

Line 395: app_exception.raise_exception;

391: if (c1%notfound) then
392: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
393: IGS_GE_MSG_STACK.ADD;
394: close c1;
395: app_exception.raise_exception;
396:
397: return;
398: end if;
399: close c1;

Line 412: app_exception.raise_exception;

408: null;
409: else
410: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
411: IGS_GE_MSG_STACK.ADD;
412: app_exception.raise_exception;
413: end if;
414: return;
415: end LOCK_ROW;
416:

Line 446: app_exception.raise_exception;

442: end if;
443: else
444: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
445: IGS_GE_MSG_STACK.ADD;
446: app_exception.raise_exception;
447: end if;
448: Before_DML (
449: p_action => 'UPDATE',
450: x_rowid => x_rowid ,

Line 475: app_exception.raise_exception;

471: if (sql%notfound) then
472: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
473: igs_ge_msg_stack.add;
474: igs_sc_gen_001.unset_ctx('R');
475: app_exception.raise_exception;
476: end if;
477: IF (x_mode = 'S') THEN
478: igs_sc_gen_001.unset_ctx('R');
479: END IF;

Line 488: app_exception.raise_exception;

484: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
485: fnd_message.set_token ('ERR_CD', SQLCODE);
486: igs_ge_msg_stack.add;
487: igs_sc_gen_001.unset_ctx('R');
488: app_exception.raise_exception;
489: ELSE
490: igs_sc_gen_001.unset_ctx('R');
491: RAISE;
492: END IF;

Line 556: app_exception.raise_exception;

552: if (sql%notfound) then
553: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
554: igs_ge_msg_stack.add;
555: igs_sc_gen_001.unset_ctx('R');
556: app_exception.raise_exception;
557: end if;
558: IF (x_mode = 'S') THEN
559: igs_sc_gen_001.unset_ctx('R');
560: END IF;

Line 587: App_Exception.Raise_Exception ;

583: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
584: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
585: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
586: IGS_GE_MSG_STACK.ADD;
587: App_Exception.Raise_Exception ;
588: END IF;
589:
590: END IF ;
591:

Line 596: App_Exception.Raise_Exception ;

592: IF upper(Column_name) = 'S_UNIT_TYPE' OR COLUMN_NAME IS NULL THEN
593: IF new_references.S_UNIT_TYPE<> upper(new_references.S_UNIT_TYPE) then
594: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
595: IGS_GE_MSG_STACK.ADD;
596: App_Exception.Raise_Exception ;
597: END IF;
598:
599: IF new_references.S_UNIT_TYPE not in ('EXCLUDED','REQUIRED') then
600: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 602: App_Exception.Raise_Exception ;

598:
599: IF new_references.S_UNIT_TYPE not in ('EXCLUDED','REQUIRED') then
600: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
601: IGS_GE_MSG_STACK.ADD;
602: App_Exception.Raise_Exception ;
603: END IF;
604:
605: END IF ;
606:

Line 611: App_Exception.Raise_Exception ;

607: IF upper(Column_name) = 'UNIT_CD' OR COLUMN_NAME IS NULL THEN
608: IF new_references.UNIT_CD<> upper(new_references.UNIT_CD) then
609: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
610: IGS_GE_MSG_STACK.ADD;
611: App_Exception.Raise_Exception ;
612: END IF;
613:
614: END IF ;
615: