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

Line 44: App_Exception.Raise_Exception;

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: Close cur_old_ref_values;
44: App_Exception.Raise_Exception;
45:
46: Return;
47: END IF;
48: Close cur_old_ref_values;

Line 88: App_Exception.Raise_Exception;

84: new_references.pra_sequence_number
85: )THEN
86: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89:
90: END IF;
91:
92: END IF;

Line 115: App_Exception.Raise_Exception;

111: new_references.rule_check_dt
112: )THEN
113: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116:
117: END IF;
118:
119: END IF;

Line 197: App_Exception.Raise_Exception;

193: IF (cur_rowid%FOUND) THEN
194: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPRC_PRA_FK');
195: IGS_GE_MSG_STACK.ADD;
196: Close cur_rowid;
197: App_Exception.Raise_Exception;
198:
199: Return;
200: END IF;
201: Close cur_rowid;

Line 232: App_Exception.Raise_Exception;

228: IF (cur_rowid%FOUND) THEN
229: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPRC_SPCHK_FK');
230: IGS_GE_MSG_STACK.ADD;
231: Close cur_rowid;
232: App_Exception.Raise_Exception;
233:
234: Return;
235: END IF;
236: Close cur_rowid;

Line 295: App_Exception.Raise_Exception;

291: new_references.pra_sequence_number,
292: new_references.rule_check_dt) THEN
293: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: CHECK_CONSTRAINTS;
298:
299: ELSIF (p_action = 'UPDATE') THEN

Line 319: App_Exception.Raise_Exception;

315: new_references.pra_sequence_number,
316: new_references.rule_check_dt) THEN
317: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: CHECK_CONSTRAINTS;
322:
323: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 374: app_exception.raise_exception;

370: end if;
371: else
372: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
373: IGS_GE_MSG_STACK.ADD;
374: app_exception.raise_exception;
375: end if;
376: Before_DML (
377: p_action => 'INSERT',
378: x_rowid => x_rowid ,

Line 471: app_exception.raise_exception;

467: if (c1%notfound) then
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: IGS_GE_MSG_STACK.ADD;
470: close c1;
471: app_exception.raise_exception;
472:
473: return;
474: end if;
475: close c1;

Line 495: app_exception.raise_exception;

491: null;
492: else
493: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497: return;
498: end LOCK_ROW;
499:

Line 533: app_exception.raise_exception;

529: end if;
530: else
531: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
532: IGS_GE_MSG_STACK.ADD;
533: app_exception.raise_exception;
534: end if;
535: Before_DML (
536: p_action => 'UPDATE',
537: x_rowid => x_rowid ,

Line 670: App_Exception.Raise_Exception ;

666: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
667: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
668: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
669: IGS_GE_MSG_STACK.ADD;
670: App_Exception.Raise_Exception ;
671: END IF;
672:
673: END IF ;
674:

Line 679: App_Exception.Raise_Exception ;

675: IF upper(Column_name) = 'PASSED_IND' OR COLUMN_NAME IS NULL THEN
676: IF new_references.PASSED_IND<> upper(new_references.PASSED_IND) then
677: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
678: IGS_GE_MSG_STACK.ADD;
679: App_Exception.Raise_Exception ;
680: END IF;
681:
682: IF new_references.PASSED_IND not in ('Y','N') then
683: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 685: App_Exception.Raise_Exception ;

681:
682: IF new_references.PASSED_IND not in ('Y','N') then
683: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
684: IGS_GE_MSG_STACK.ADD;
685: App_Exception.Raise_Exception ;
686: END IF;
687:
688: END IF ;
689:

Line 694: App_Exception.Raise_Exception ;

690: IF upper(Column_name) = 'PRG_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
691: IF new_references.PRG_CAL_TYPE<> upper(new_references.PRG_CAL_TYPE) then
692: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception ;
695: END IF;
696:
697: END IF ;
698:

Line 703: App_Exception.Raise_Exception ;

699: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
700: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
701: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
702: IGS_GE_MSG_STACK.ADD;
703: App_Exception.Raise_Exception ;
704: END IF;
705:
706: END IF ;
707:

Line 712: App_Exception.Raise_Exception ;

708: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
709: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
710: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
711: IGS_GE_MSG_STACK.ADD;
712: App_Exception.Raise_Exception ;
713: END IF;
714:
715: END IF ;
716:

Line 721: App_Exception.Raise_Exception ;

717: IF upper(Column_name) = 'PRG_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
718: IF new_references.PRG_CI_SEQUENCE_NUMBER < 1 or new_references.PRG_CI_SEQUENCE_NUMBER > 999999 then
719: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
720: IGS_GE_MSG_STACK.ADD;
721: App_Exception.Raise_Exception ;
722: END IF;
723:
724: END IF ;
725: