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

Line 43: App_Exception.Raise_Exception; RETURN;

39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
40: CLOSE cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception; RETURN;
44: END IF;
45: CLOSE cur_old_ref_values;
46:
47: -- Populate New Values.

Line 87: App_Exception.Raise_Exception;

83: new_references.testamur_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90: END IF;
91: END IF;

Line 101: App_Exception.Raise_Exception;

97: old_references.s_award_type,
98: v_message_name) = FALSE THEN
99: Fnd_Message.Set_Name('IGS',v_message_name);
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:
105: END BeforeRowInsertUpdate1;

Line 135: App_Exception.Raise_Exception;

131: column_name IS NULL THEN
132: IF ( new_references.closed_ind NOT IN ( 'Y' , 'N' ) ) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:
139: IF UPPER(column_name) = 'S_AWARD_TYPE' OR

Line 144: App_Exception.Raise_Exception;

140: column_name IS NULL THEN
141: IF ( new_references.s_award_type NOT IN ( 'COURSE' , 'HONORARY' , 'MEDAL' , 'PRIZE' ,'ENTRYQUAL') ) THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:
148: IF UPPER(column_name) = 'AWARD_CD' OR

Line 153: App_Exception.Raise_Exception;

149: column_name IS NULL THEN
150: IF ( new_references.award_cd <> UPPER(new_references.award_cd) ) THEN
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156:
157: IF UPPER(column_name) = 'CLOSED_IND' OR

Line 162: App_Exception.Raise_Exception;

158: column_name IS NULL THEN
159: IF ( new_references.closed_ind <> UPPER(new_references.closed_ind) ) THEN
160: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: END IF;
164: END IF;
165:
166: IF UPPER(column_name) = 'S_AWARD_TYPE' OR

Line 171: App_Exception.Raise_Exception;

167: column_name IS NULL THEN
168: IF ( new_references.s_award_type <> UPPER(new_references.s_award_type) ) THEN
169: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
175: IF UPPER(column_name) = 'TESTAMUR_TYPE' OR

Line 180: App_Exception.Raise_Exception;

176: column_name IS NULL THEN
177: IF ( new_references.testamur_type <> UPPER(new_references.testamur_type) ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:
184: -- Added by aiyer for the build of PSCR015 Tertiary And Secondary Bug No #2216952

Line 190: APP_EXCEPTION.RAISE_EXCEPTION;

186: column_name IS NULL THEN
187: IF new_references.GRADING_SCHEMA_CD <> UPPER(new_references.GRADING_SCHEMA_CD) THEN
188: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
189: IGS_GE_MSG_STACK.ADD;
190: APP_EXCEPTION.RAISE_EXCEPTION;
191: END IF;
192: END IF;
193:
194: -- Added by aiyer for the build of PSCR015 Tertiary And Secondary Bug No #2216952

Line 200: APP_EXCEPTION.RAISE_EXCEPTION;

196: column_name IS NULL THEN
197: IF new_references.GS_VERSION_NUMBER < 0 OR new_references.GS_VERSION_NUMBER > 999 THEN
198: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
199: IGS_GE_MSG_STACK.ADD;
200: APP_EXCEPTION.RAISE_EXCEPTION;
201: END IF;
202: END IF;
203:
204: END Check_Constraints;

Line 217: App_Exception.Raise_Exception;

213: IF NOT IGS_GR_TESTAMUR_TYPE_PKG.Get_PK_For_Validation (
214: new_references.testamur_type ) THEN
215: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;
220:
221: -- Added by aiyer for the build of PSCR015 Tertiary And Secondary Bug No #2216952

Line 245: App_Exception.Raise_Exception;

241: new_references.gs_version_number
242: ) THEN
243: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248:
249: END Check_Parent_Existance;

Line 296: App_Exception.Raise_Exception;

292: IF (cur_rowid%FOUND) THEN
293: CLOSE cur_rowid;
294: Fnd_Message.Set_Name ('IGS', 'IGS_PS_AW_TT_FK');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: RETURN;
298: END IF;
299: CLOSE cur_rowid;
300:

Line 327: App_Exception.Raise_Exception;

323: IF (cur_rowid%FOUND) THEN
324: CLOSE cur_rowid;
325: Fnd_Message.Set_Name ('IGS', 'IGS_PS_AW_GS_FK');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: RETURN;
329: END IF;
330: CLOSE cur_rowid;
331:

Line 378: App_Exception.Raise_Exception;

374: IF Get_PK_For_Validation (
375: new_references.award_cd) THEN
376: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: Check_Constraints;
381: Check_Parent_Existance;
382: ELSIF (p_action = 'UPDATE') THEN

Line 392: App_Exception.Raise_Exception;

388: IF Get_PK_For_Validation (
389: new_references.award_cd ) THEN
390: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: END IF;
394: Check_Constraints;
395: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
396: Check_Constraints;

Line 445: app_exception.raise_exception;

441: END IF;
442: ELSE
443: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: END IF;
447:
448: Before_DML (
449: p_action => 'INSERT',

Line 542: app_exception.raise_exception;

538: IF (c1%NOTFOUND) THEN
539: CLOSE c1;
540: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
541: IGS_GE_MSG_STACK.ADD;
542: app_exception.raise_exception;
543: RETURN;
544: END IF;
545: CLOSE c1;
546:

Line 581: app_exception.raise_exception;

577: NULL;
578: ELSE
579: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
580: IGS_GE_MSG_STACK.ADD;
581: app_exception.raise_exception;
582: END IF;
583: RETURN;
584: END LOCK_ROW;
585:

Line 618: app_exception.raise_exception;

614: END IF;
615: ELSE
616: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
617: IGS_GE_MSG_STACK.ADD;
618: app_exception.raise_exception;
619: END IF;
620:
621: Before_DML (
622: p_action => 'UPDATE',