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

Line 45: App_Exception.Raise_Exception;

41: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: Close cur_old_ref_values;
45: App_Exception.Raise_Exception;
46: Return;
47: END IF;
48: Close cur_old_ref_values;
49:

Line 87: App_Exception.Raise_Exception;

83: new_references.dflt_restricted_att_type
84: ) THEN
85: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90:
91: IF (((old_references.encumbrance_type = new_references.encumbrance_type)) OR

Line 100: App_Exception.Raise_Exception;

96: new_references.encumbrance_type
97: ) THEN
98: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103:
104: IF (((old_references.s_progression_outcome_type = new_references.s_progression_outcome_type)) OR

Line 114: App_Exception.Raise_Exception;

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

Line 177: App_Exception.Raise_Exception;

173: IF (cur_rowid%FOUND) THEN
174: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POT_ATT_FK');
175: IGS_GE_MSG_STACK.ADD;
176: Close cur_rowid;
177: App_Exception.Raise_Exception;
178: Return;
179: END IF;
180: Close cur_rowid;
181:

Line 203: App_Exception.Raise_Exception;

199: IF (cur_rowid%FOUND) THEN
200: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POT_ET_FK');
201: IGS_GE_MSG_STACK.ADD;
202: Close cur_rowid;
203: App_Exception.Raise_Exception;
204: Return;
205: END IF;
206: Close cur_rowid;
207:

Line 229: App_Exception.Raise_Exception;

225: IF (cur_rowid%FOUND) THEN
226: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POT_SPOT_FK');
227: IGS_GE_MSG_STACK.ADD;
228: Close cur_rowid;
229: App_Exception.Raise_Exception;
230: Return;
231: END IF;
232: Close cur_rowid;
233:

Line 243: App_Exception.Raise_Exception;

239: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.encumbrance_type <> old_references.encumbrance_type) ) THEN
240: IF NOT igs_en_val_etde.enrp_val_et_closed(new_references.encumbrance_type,p_message_name) THEN
241: Fnd_Message.Set_Name('IGS', p_message_name);
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246: END BeforeInsertUpdate;
247:

Line 299: App_Exception.Raise_Exception;

295: new_references.progression_outcome_type
296: ) THEN
297: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
298: IGS_GE_MSG_STACK.ADD;
299: App_Exception.Raise_Exception;
300: END IF;
301: Check_Constraints;
302: Check_Parent_Existance;
303: ELSIF (p_action = 'UPDATE') THEN

Line 318: App_Exception.Raise_Exception;

314: new_references.progression_outcome_type
315: ) THEN
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: Check_Constraints;
321: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
322: -- Call all the procedures related to Before Update.

Line 367: app_exception.raise_exception;

363: end if;
364: else
365: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
366: IGS_GE_MSG_STACK.ADD;
367: app_exception.raise_exception;
368: end if;
369: Before_DML (
370: p_action => 'INSERT',
371: x_rowid => x_rowid,

Line 462: app_exception.raise_exception;

458: if (c1%notfound) then
459: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
460: IGS_GE_MSG_STACK.ADD;
461: close c1;
462: app_exception.raise_exception;
463: return;
464: end if;
465: close c1;
466:

Line 487: app_exception.raise_exception;

483: null;
484: else
485: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
486: IGS_GE_MSG_STACK.ADD;
487: app_exception.raise_exception;
488: end if;
489: return;
490: end LOCK_ROW;
491:

Line 525: app_exception.raise_exception;

521: end if;
522: else
523: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
524: IGS_GE_MSG_STACK.ADD;
525: app_exception.raise_exception;
526: end if;
527: Before_DML (
528: p_action => 'UPDATE',
529: x_rowid => x_rowid,

Line 655: App_Exception.Raise_Exception ;

651: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
652: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
653: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
654: IGS_GE_MSG_STACK.ADD;
655: App_Exception.Raise_Exception ;
656: END IF;
657:
658: IF new_references.CLOSED_IND not in ('Y','N') then
659: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 661: App_Exception.Raise_Exception ;

657:
658: IF new_references.CLOSED_IND not in ('Y','N') then
659: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
660: IGS_GE_MSG_STACK.ADD;
661: App_Exception.Raise_Exception ;
662: END IF;
663:
664: END IF ;
665:

Line 670: App_Exception.Raise_Exception ;

666: IF upper(Column_name) = 'ENCUMBRANCE_TYPE' OR COLUMN_NAME IS NULL THEN
667: IF new_references.ENCUMBRANCE_TYPE<> upper(new_references.ENCUMBRANCE_TYPE) 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) = 'PROGRESSION_OUTCOME_TYPE' OR COLUMN_NAME IS NULL THEN
676: IF new_references.PROGRESSION_OUTCOME_TYPE<> upper(new_references.PROGRESSION_OUTCOME_TYPE) 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: END IF ;
683:

Line 688: App_Exception.Raise_Exception ;

684: IF upper(Column_name) = 'S_PROGRESSION_OUTCOME_TYPE' OR COLUMN_NAME IS NULL THEN
685: IF new_references.S_PROGRESSION_OUTCOME_TYPE<> upper(new_references.S_PROGRESSION_OUTCOME_TYPE) then
686: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
687: IGS_GE_MSG_STACK.ADD;
688: App_Exception.Raise_Exception ;
689: END IF;
690:
691: END IF ;
692:

Line 697: App_Exception.Raise_Exception ;

693: IF upper(Column_name) = 'DFLT_RESTRICTED_ENROLMENT_CP' OR COLUMN_NAME IS NULL THEN
694: IF new_references.DFLT_RESTRICTED_ENROLMENT_CP < 0 or new_references.DFLT_RESTRICTED_ENROLMENT_CP > 999.999 then
695: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
696: IGS_GE_MSG_STACK.ADD;
697: App_Exception.Raise_Exception ;
698: END IF;
699:
700: END IF ;
701: END Check_Constraints;