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

Line 39: App_Exception.Raise_Exception;

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

Line 77: App_Exception.Raise_Exception;

73: new_references.course_cd
74: ) THEN
75: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79: END IF;
80:
81: IF (((old_references.progression_rule_cat = new_references.progression_rule_cat) AND

Line 96: App_Exception.Raise_Exception;

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

Line 151: App_Exception.Raise_Exception;

147: IF (cur_rowid%FOUND) THEN
148: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POC_CRS_FK');
149: IGS_GE_MSG_STACK.ADD;
150: Close cur_rowid;
151: App_Exception.Raise_Exception;
152: Return;
153: END IF;
154: Close cur_rowid;
155:

Line 181: App_Exception.Raise_Exception;

177: IF (cur_rowid%FOUND) THEN
178: Fnd_Message.Set_Name ('IGS','IGS_PR_POC_PRO_FK');
179: IGS_GE_MSG_STACK.ADD;
180: Close cur_rowid;
181: App_Exception.Raise_Exception;
182: Return;
183: END IF;
184: Close cur_rowid;
185:

Line 219: APP_EXCEPTION.RAISE_EXCEPTION;

215: IF c_parent%NOTFOUND THEN
216: CLOSE c_parent;
217: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
218: IGS_GE_MSG_STACK.ADD;
219: APP_EXCEPTION.RAISE_EXCEPTION;
220: END IF;
221: CLOSE c_parent;
222: ELSIF(p_action = 'UPDATE') THEN
223: IF new_references.progression_rule_cat <> old_references.progression_rule_cat OR

Line 232: APP_EXCEPTION.RAISE_EXCEPTION;

228: IF c_parent%NOTFOUND THEN
229: CLOSE c_parent;
230: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
231: IGS_GE_MSG_STACK.ADD;
232: APP_EXCEPTION.RAISE_EXCEPTION;
233: END IF;
234: CLOSE c_parent;
235: END IF;
236: END IF;

Line 281: App_Exception.Raise_Exception;

277: new_references.course_cd
278: ) THEN
279: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: Check_Constraints;
284: Check_Parent_Existance;
285: ELSIF (p_action = 'UPDATE') THEN

Line 299: App_Exception.Raise_Exception;

295: new_references.course_cd
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: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
303: -- Call all the procedures related to Before Update.

Line 346: app_exception.raise_exception;

342: end if;
343: else
344: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348:
349: Before_DML (
350: p_action => 'INSERT',

Line 417: app_exception.raise_exception;

413: if (c1%notfound) then
414: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
415: IGS_GE_MSG_STACK.ADD;
416: close c1;
417: app_exception.raise_exception;
418: return;
419: end if;
420: close c1;
421: return;

Line 468: App_Exception.Raise_Exception ;

464: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
465: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
466: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
467: IGS_GE_MSG_STACK.ADD;
468: App_Exception.Raise_Exception ;
469: END IF;
470:
471: END IF ;
472:

Line 477: App_Exception.Raise_Exception ;

473: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
474: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
475: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
476: IGS_GE_MSG_STACK.ADD;
477: App_Exception.Raise_Exception ;
478: END IF;
479:
480: END IF ;
481:

Line 486: App_Exception.Raise_Exception ;

482: IF upper(Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
483: IF new_references.PRO_SEQUENCE_NUMBER < 1 or new_references.PRO_SEQUENCE_NUMBER > 999999 then
484: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception ;
487: END IF;
488:
489: END IF ;
490:

Line 495: App_Exception.Raise_Exception ;

491: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
492: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
493: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception ;
496: END IF;
497:
498: END IF ;
499: