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_STND_UNIT_PKG dependencies on IGS_AV_VAL_ASU

Line 145: IF igs_av_val_asu.advp_val_asrt_closed (

141: -- Validate that the advanced standing recognition type is open.
142: IF p_inserting OR
143: (p_updating AND (new_references.s_adv_stnd_recognition_type <>
144: old_references.s_adv_stnd_recognition_type)) THEN
145: IF igs_av_val_asu.advp_val_asrt_closed (
146: new_references.s_adv_stnd_recognition_type,
147: v_message_name
148: ) = FALSE THEN
149: Fnd_Message.Set_Name('IGS', v_message_name);

Line 159: IF igs_av_val_asu.advp_val_as_dates (

155: IF (new_references.approved_dt IS NOT NULL) AND
156: (p_inserting OR
157: (NVL(old_references.approved_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
158: new_references.approved_dt)) THEN
159: IF igs_av_val_asu.advp_val_as_dates (
160: new_references.approved_dt,
161: 'APPROVED',
162: v_message_name,
163: p_adv_stnd_trans

Line 194: IF igs_av_val_asu.advp_val_as_dates (

190: IF (new_references.granted_dt IS NOT NULL) AND
191: (p_inserting OR
192: (NVL(old_references.granted_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
193: new_references.granted_dt)) THEN
194: IF igs_av_val_asu.advp_val_as_dates (
195: new_references.granted_dt,
196: 'GRANTED',
197: v_message_name,
198: p_adv_stnd_trans

Line 210: IF igs_av_val_asu.advp_val_expiry_dt (

206: IF (new_references.expiry_dt IS NOT NULL) AND
207: (p_inserting OR
208: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
209: new_references.expiry_dt)) THEN
210: IF igs_av_val_asu.advp_val_expiry_dt (
211: new_references.expiry_dt,
212: v_message_name,
213: p_adv_stnd_trans
214: ) = FALSE THEN

Line 225: IF igs_av_val_asu.advp_val_as_dates (

221: IF (new_references.cancelled_dt IS NOT NULL) AND
222: (p_inserting OR
223: (NVL(old_references.cancelled_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
224: new_references.cancelled_dt)) THEN
225: IF igs_av_val_asu.advp_val_as_dates (
226: new_references.cancelled_dt,
227: 'CANCELLED',
228: v_message_name
229: ) = FALSE THEN

Line 234: IF igs_av_val_asu.advp_val_as_aprvd_dt (

230: Fnd_Message.Set_Name('IGS', v_message_name);
231: Igs_Ge_Msg_Stack.Add;
232: App_Exception.Raise_Exception;
233: END IF;
234: IF igs_av_val_asu.advp_val_as_aprvd_dt (
235: new_references.approved_dt,
236: new_references.cancelled_dt,
237: v_message_name
238: ) = FALSE THEN

Line 249: IF igs_av_val_asu.advp_val_as_dates (

245: IF (new_references.revoked_dt IS NOT NULL) AND
246: (p_inserting OR
247: (NVL(old_references.revoked_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
248: new_references.revoked_dt)) THEN
249: IF igs_av_val_asu.advp_val_as_dates (
250: new_references.revoked_dt,
251: 'REVOKED',
252: v_message_name
253: ) = FALSE THEN

Line 258: IF igs_av_val_asu.advp_val_as_aprvd_dt (

254: Fnd_Message.Set_Name('IGS', v_message_name);
255: Igs_Ge_Msg_Stack.Add;
256: App_Exception.Raise_Exception;
257: END IF;
258: IF igs_av_val_asu.advp_val_as_aprvd_dt (
259: new_references.approved_dt,
260: new_references.revoked_dt,
261: v_message_name
262: ) = FALSE THEN

Line 272: IF igs_av_val_asu.advp_val_status_dts (

268: -- Validate that related date is set for the granting status.
269: IF p_inserting OR (p_updating AND (new_references.s_adv_stnd_granting_status <>
270: old_references.s_adv_stnd_granting_status)) THEN
271: IF new_references.s_adv_stnd_granting_status = 'GRANTED' THEN
272: IF igs_av_val_asu.advp_val_status_dts (
273: 'GRANTED',
274: new_references.granted_dt,
275: v_message_name,
276: p_adv_stnd_trans

Line 283: IF igs_av_val_asu.advp_val_status_dts (

279: Igs_Ge_Msg_Stack.Add;
280: App_Exception.Raise_Exception;
281: END IF;
282: ELSIF new_references.s_adv_stnd_granting_status = 'REVOKED' THEN
283: IF igs_av_val_asu.advp_val_status_dts (
284: 'REVOKED',
285: new_references.revoked_dt,
286: v_message_name
287: ) = FALSE THEN

Line 293: IF igs_av_val_asu.advp_val_status_dts (

289: Igs_Ge_Msg_Stack.Add;
290: App_Exception.Raise_Exception;
291: END IF;
292: ELSIF new_references.s_adv_stnd_granting_status = 'CANCELLED' THEN
293: IF igs_av_val_asu.advp_val_status_dts (
294: 'CANCELLED',
295: new_references.cancelled_dt,
296: v_message_name
297: ) = FALSE THEN

Line 303: IF igs_av_val_asu.advp_val_status_dts (

299: Igs_Ge_Msg_Stack.Add;
300: App_Exception.Raise_Exception;
301: END IF;
302: ELSIF new_references.s_adv_stnd_granting_status = 'EXPIRED' THEN
303: IF igs_av_val_asu.advp_val_status_dts (
304: 'EXPIRED',
305: new_references.expiry_dt,
306: v_message_name
307: ) = FALSE THEN

Line 313: IF igs_av_val_asu.advp_val_status_dts (

309: Igs_Ge_Msg_Stack.Add;
310: App_Exception.Raise_Exception;
311: END IF;
312: ELSIF new_references.s_adv_stnd_granting_status = 'APPROVED' THEN
313: IF igs_av_val_asu.advp_val_status_dts (
314: 'APPROVED',
315: new_references.approved_dt,
316: v_message_name,
317: p_adv_stnd_trans

Line 365: IF igs_av_val_asu.advp_val_asu_inst (

361: END IF;
362: -- Validate that exemption institution code is valid.
363: IF p_inserting OR (p_updating AND (new_references.exemption_institution_cd <>
364: old_references.exemption_institution_cd)) THEN
365: IF igs_av_val_asu.advp_val_asu_inst (
366: new_references.exemption_institution_cd,
367: v_message_name) = FALSE THEN
368: Fnd_Message.Set_Name('IGS', v_message_name);
369: Igs_Ge_Msg_Stack.Add;