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

Line 34: App_Exception.Raise_Exception;

30: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
31: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
32: Igs_Ge_Msg_Stack.Add;
33: Close cur_old_ref_values;
34: App_Exception.Raise_Exception;
35: Return;
36: END IF;
37: Close cur_old_ref_values;
38: -- Populate New Values.

Line 88: App_Exception.Raise_Exception;

84: v_return_type) = FALSE THEN
85: IF v_return_type = 'E' THEN
86: Fnd_Message.Set_Name('IGS', v_message_name);
87: Igs_Ge_Msg_Stack.Add;
88: App_Exception.Raise_Exception;
89: null;
90: END IF;
91: END IF;
92: END IF;

Line 122: App_Exception.Raise_Exception;

118: column_name is null Then
119: IF new_references.BASIS_COMPLETION_IND <> UPPER(new_references.BASIS_COMPLETION_IND) Then
120: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
121: Igs_Ge_Msg_Stack.Add;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125:
126: IF upper(column_name) = 'BASIS_COURSE_TYPE' OR

Line 131: App_Exception.Raise_Exception;

127: column_name is null Then
128: IF new_references.BASIS_COURSE_TYPE <> UPPER(new_references.BASIS_COURSE_TYPE) Then
129: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
130: Igs_Ge_Msg_Stack.Add;
131: App_Exception.Raise_Exception;
132: END IF;
133: END IF;
134:
135:

Line 141: App_Exception.Raise_Exception;

137: column_name is null Then
138: IF new_references.BASIS_COMPLETION_IND not in ('Y','N') THEN
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: Igs_Ge_Msg_Stack.Add;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF ;
144:
145: IF upper(column_name) = 'BASIS_YEAR' OR

Line 151: App_Exception.Raise_Exception;

147: IF new_references.BASIS_YEAR < 1900 OR
148: new_references.BASIS_YEAR > 2100 Then
149: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
150: Igs_Ge_Msg_Stack.Add;
151: App_Exception.Raise_Exception;
152: END IF;
153: END IF;
154:
155: END CHECK_CONSTRAINTS;

Line 169: App_Exception.Raise_Exception;

165: IF NOT IGS_AV_STND_UNIT_LVL_PKG.Get_PK_For_Validation (
166: new_references.av_stnd_unit_lvl_id) THEN
167: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
168: Igs_Ge_Msg_Stack.Add;
169: App_Exception.Raise_Exception;
170: END IF;
171: --
172: END IF ;
173:

Line 183: App_Exception.Raise_Exception;

179: new_references.basis_course_type
180: )THEN
181: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
182: Igs_Ge_Msg_Stack.Add;
183: App_Exception.Raise_Exception;
184: END IF;
185:
186: END IF;
187: END Check_Parent_Existance;

Line 229: App_Exception.Raise_Exception;

225: IF (cur_rowid%FOUND) THEN
226: Fnd_Message.Set_Name ('IGS', 'IGS_AV_ASULEB_ASULE_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: END GET_FK_IGS_AV_STND_UNIT_LVL;

Line 273: App_Exception.Raise_Exception;

269: new_references.av_stnd_unit_lvl_id
270: ) THEN
271: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
272: Igs_Ge_Msg_Stack.Add;
273: App_Exception.Raise_Exception;
274: END IF;
275: ---
276: -- *
277: CHECK_CONSTRAINTS;

Line 296: App_Exception.Raise_Exception;

292: new_references.av_stnd_unit_lvl_id
293: ) THEN
294: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
295: Igs_Ge_Msg_Stack.Add;
296: App_Exception.Raise_Exception;
297: END IF;
298: Check_Constraints;
299: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
300: Check_Constraints;

Line 337: app_exception.raise_exception;

333: end if;
334: else
335: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
336: Igs_Ge_Msg_Stack.Add;
337: app_exception.raise_exception;
338: end if;
339: Before_DML(
340: p_action=>'INSERT',
341: x_rowid=>X_ROWID,

Line 397: app_exception.raise_exception;

393: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
394: fnd_message.set_token ('ERR_CD', SQLCODE);
395: igs_ge_msg_stack.add;
396: igs_sc_gen_001.unset_ctx('R');
397: app_exception.raise_exception;
398: ELSE
399: igs_sc_gen_001.unset_ctx('R');
400: RAISE;
401: END IF;

Line 427: app_exception.raise_exception;

423: if (c1%notfound) then
424: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
425: Igs_Ge_Msg_Stack.Add;
426: close c1;
427: app_exception.raise_exception;
428: return;
429: end if;
430: close c1;
431: if (

Line 440: app_exception.raise_exception;

436: null;
437: else
438: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
439: Igs_Ge_Msg_Stack.Add;
440: app_exception.raise_exception;
441: end if;
442: return;
443: end LOCK_ROW;
444:

Line 473: app_exception.raise_exception;

469: end if;
470: else
471: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
472: Igs_Ge_Msg_Stack.Add;
473: app_exception.raise_exception;
474: end if;
475: Before_DML(
476: p_action=>'UPDATE',
477: x_rowid=>X_ROWID,

Line 505: app_exception.raise_exception;

501: if (sql%notfound) then
502: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
503: igs_ge_msg_stack.add;
504: igs_sc_gen_001.unset_ctx('R');
505: app_exception.raise_exception;
506: end if;
507: IF (x_mode = 'S') THEN
508: igs_sc_gen_001.unset_ctx('R');
509: END IF;

Line 520: app_exception.raise_exception;

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

Line 582: app_exception.raise_exception;

578: if (sql%notfound) then
579: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
580: igs_ge_msg_stack.add;
581: igs_sc_gen_001.unset_ctx('R');
582: app_exception.raise_exception;
583: end if;
584: IF (x_mode = 'S') THEN
585: igs_sc_gen_001.unset_ctx('R');
586: END IF;