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

Line 42: App_Exception.Raise_Exception;

38: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: Igs_Ge_Msg_Stack.Add;
41: Close cur_old_ref_values;
42: App_Exception.Raise_Exception;
43:
44: Return;
45: END IF;
46: Close cur_old_ref_values;

Line 92: App_Exception.Raise_Exception;

88: new_references.version_number,
89: v_message_name) = FALSE THEN
90: Fnd_Message.Set_Name('IGS', v_message_name);
91: Igs_Ge_Msg_Stack.Add;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95:
96: END BeforeRowInsertUpdate1;

Line 140: App_Exception.Raise_Exception;

136: column_name is null Then
137: IF new_references.COURSE_CD <> UPPER(new_references.COURSE_CD) Then
138: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
139: Igs_Ge_Msg_Stack.Add;
140: App_Exception.Raise_Exception;
141: END IF;
142: END IF;
143: OPEN c_local_inst_ind (new_references.exemption_institution_cd);
144: FETCH c_local_inst_ind INTO rec_local_inst_ind;

Line 167: App_Exception.Raise_Exception;

163: IF new_references.total_exmptn_granted < 0 OR
164: new_references.total_exmptn_granted > rec_cur_program_exempt_totals.adv_stnd_limit Then
165: Fnd_Message.Set_Name ('IGS', l_message_name);
166: Igs_Ge_Msg_Stack.Add;
167: App_Exception.Raise_Exception;
168: END IF;
169: END IF;
170: END IF;
171:

Line 178: App_Exception.Raise_Exception;

174: IF new_references.TOTAL_EXMPTN_PERC_GRNTD < 0 OR
175: new_references.TOTAL_EXMPTN_PERC_GRNTD > 100 Then
176: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
177: Igs_Ge_Msg_Stack.Add;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;
181:
182: IF upper(column_name) = 'TOTAL_EXMPTN_APPROVED' OR

Line 189: App_Exception.Raise_Exception;

185: IF new_references.TOTAL_EXMPTN_APPROVED < 0 OR
186: new_references.TOTAL_EXMPTN_APPROVED > rec_cur_program_exempt_totals.adv_stnd_limit Then
187: Fnd_Message.Set_Name ('IGS', l_message_name);
188: Igs_Ge_Msg_Stack.Add;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192: END IF;
193: END CHECK_CONSTRAINTS ;

Line 212: App_Exception.Raise_Exception ;

208: new_references.version_number) THEN
209:
210: FND_Message.Set_Name('FND','FORM_RECORD_DELETED');
211: Igs_Ge_Msg_Stack.Add;
212: App_Exception.Raise_Exception ;
213:
214: END IF;
215: ---
216: END IF;

Line 228: App_Exception.Raise_Exception ;

224: new_references.person_id) THEN
225:
226: FND_Message.Set_Name('FND','FORM_RECORD_DELETED');
227: Igs_Ge_Msg_Stack.Add;
228: App_Exception.Raise_Exception ;
229: END IF;
230: ---
231: END IF;
232:

Line 309: App_Exception.Raise_Exception;

305: IF (cur_rowid%FOUND) THEN
306: Fnd_Message.Set_Name ('IGS', 'IGS_AV_AS_CRV_FK');
307: Igs_Ge_Msg_Stack.Add;
308: Close cur_rowid;
309: App_Exception.Raise_Exception;
310: Return;
311: END IF;
312: END GET_FK_IGS_PS_VER;
313:

Line 333: App_Exception.Raise_Exception;

329: IF (cur_rowid%FOUND) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_AV_AS_PE_FK');
331: Igs_Ge_Msg_Stack.Add;
332: Close cur_rowid;
333: App_Exception.Raise_Exception;
334: Return;
335: END IF;
336: Close cur_rowid;
337:

Line 385: App_Exception.Raise_Exception ;

381: IF Get_PK_For_Validation (new_references.person_id,
382: new_references.course_cd, new_references.version_number,new_references.exemption_institution_cd) THEN
383: FND_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC') ;
384: Igs_Ge_Msg_Stack.Add;
385: App_Exception.Raise_Exception ;
386: END IF;
387: --
388: CHECK_CONSTRAINTS;
389: Check_Parent_Existance;

Line 404: App_Exception.Raise_Exception ;

400: IF Get_PK_For_Validation (new_references.person_id,
401: new_references.course_cd, new_references.version_number,new_references.exemption_institution_cd) THEN
402: FND_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC') ;
403: Igs_Ge_Msg_Stack.Add;
404: App_Exception.Raise_Exception ;
405: END IF;
406: CHECK_CONSTRAINTS;
407: ELSIF (P_Action = 'VALIDATE_UPDATE') THEN
408: CHECK_CONSTRAINTS;

Line 451: app_exception.raise_exception;

447: end if;
448: else
449: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
450: Igs_Ge_Msg_Stack.Add;
451: app_exception.raise_exception;
452: end if;
453: Before_DML(
454: p_action=>'INSERT',
455: x_rowid=>X_ROWID,

Line 522: app_exception.raise_exception;

518: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
519: fnd_message.set_token ('ERR_CD', SQLCODE);
520: igs_ge_msg_stack.add;
521: igs_sc_gen_001.unset_ctx('R');
522: app_exception.raise_exception;
523: ELSE
524: igs_sc_gen_001.unset_ctx('R');
525: RAISE;
526: END IF;

Line 556: app_exception.raise_exception;

552: if (c1%notfound) then
553: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
554: Igs_Ge_Msg_Stack.Add;
555: close c1;
556: app_exception.raise_exception;
557: return;
558: end if;
559: close c1;
560:

Line 570: app_exception.raise_exception;

566: null;
567: else
568: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
569: Igs_Ge_Msg_Stack.Add;
570: app_exception.raise_exception;
571: end if;
572: return;
573: end LOCK_ROW;
574:

Line 606: app_exception.raise_exception;

602: end if;
603: else
604: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
605: Igs_Ge_Msg_Stack.Add;
606: app_exception.raise_exception;
607: end if;
608: Before_DML(
609: p_action=>'UPDATE',
610: x_rowid=>X_ROWID,

Line 639: app_exception.raise_exception;

635: if (sql%notfound) then
636: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
637: igs_ge_msg_stack.add;
638: igs_sc_gen_001.unset_ctx('R');
639: app_exception.raise_exception;
640: end if;
641: IF (x_mode = 'S') THEN
642: igs_sc_gen_001.unset_ctx('R');
643: END IF;

Line 653: app_exception.raise_exception;

649: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
650: fnd_message.set_token ('ERR_CD', SQLCODE);
651: igs_ge_msg_stack.add;
652: igs_sc_gen_001.unset_ctx('R');
653: app_exception.raise_exception;
654: ELSE
655: igs_sc_gen_001.unset_ctx('R');
656: RAISE;
657: END IF;

Line 727: app_exception.raise_exception;

723: if (sql%notfound) then
724: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
725: igs_ge_msg_stack.add;
726: igs_sc_gen_001.unset_ctx('R');
727: app_exception.raise_exception;
728: end if;
729: IF (x_mode = 'S') THEN
730: igs_sc_gen_001.unset_ctx('R');
731: END IF;