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

Line 136: IF igs_av_val_asule.advp_val_ule_closed (

132: END IF;
133: END IF;
134: -- Validate Unit Level closed indicator.
135: IF p_inserting OR p_updating THEN
136: IF igs_av_val_asule.advp_val_ule_closed (
137: new_references.UNIT_LEVEL,
138: v_message_name) = FALSE THEN
139: Fnd_Message.Set_Name('IGS', v_message_name);
140: Igs_Ge_Msg_Stack.Add;

Line 149: IF igs_av_val_asu.advp_val_as_dates (

145: IF (new_references.approved_dt IS NOT NULL) AND
146: (p_inserting OR
147: (NVL(old_references.approved_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
148: new_references.approved_dt)) THEN
149: IF igs_av_val_asu.advp_val_as_dates (
150: new_references.approved_dt,
151: 'APPROVED',
152: v_message_name,
153: p_adv_stnd_trans) = FALSE THEN

Line 183: IF igs_av_val_asu.advp_val_as_dates (

179: IF (new_references.granted_dt IS NOT NULL) AND
180: (p_inserting OR
181: (NVL(old_references.granted_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
182: new_references.granted_dt)) THEN
183: IF igs_av_val_asu.advp_val_as_dates (
184: new_references.granted_dt,
185: 'GRANTED',
186: v_message_name,
187: p_adv_stnd_trans) = FALSE THEN

Line 198: IF igs_av_val_asu.advp_val_expiry_dt (

194: IF (new_references.expiry_dt IS NOT NULL) AND
195: (p_inserting OR
196: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
197: new_references.expiry_dt)) THEN
198: IF igs_av_val_asu.advp_val_expiry_dt (
199: new_references.expiry_dt,
200: v_message_name,
201: p_adv_stnd_trans) = FALSE THEN
202: Fnd_Message.Set_Name('IGS', v_message_name);

Line 212: IF igs_av_val_asu.advp_val_as_dates (

208: IF (new_references.cancelled_dt IS NOT NULL) AND
209: (p_inserting OR
210: (NVL(old_references.cancelled_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
211: new_references.cancelled_dt)) THEN
212: IF igs_av_val_asu.advp_val_as_dates (
213: new_references.cancelled_dt,
214: 'CANCELLED',
215: v_message_name) = FALSE THEN
216: Fnd_Message.Set_Name('IGS', v_message_name);

Line 220: IF igs_av_val_asu.advp_val_as_aprvd_dt (

216: Fnd_Message.Set_Name('IGS', v_message_name);
217: Igs_Ge_Msg_Stack.Add;
218: App_Exception.Raise_Exception;
219: END IF;
220: IF igs_av_val_asu.advp_val_as_aprvd_dt (
221: new_references.approved_dt,
222: new_references.cancelled_dt,
223: v_message_name) = FALSE THEN
224: Fnd_Message.Set_Name('IGS', v_message_name);

Line 234: IF igs_av_val_asu.advp_val_as_dates (

230: IF (new_references.revoked_dt IS NOT NULL) AND
231: (p_inserting OR
232: (NVL(old_references.revoked_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
233: new_references.revoked_dt)) THEN
234: IF igs_av_val_asu.advp_val_as_dates (
235: new_references.revoked_dt,
236: 'REVOKED',
237: v_message_name) = FALSE THEN
238: Fnd_Message.Set_Name('IGS', v_message_name);

Line 242: IF igs_av_val_asu.advp_val_as_aprvd_dt (

238: Fnd_Message.Set_Name('IGS', v_message_name);
239: Igs_Ge_Msg_Stack.Add;
240: App_Exception.Raise_Exception;
241: END IF;
242: IF igs_av_val_asu.advp_val_as_aprvd_dt (
243: new_references.approved_dt,
244: new_references.revoked_dt,
245: v_message_name) = FALSE THEN
246: Fnd_Message.Set_Name('IGS', v_message_name);

Line 255: IF igs_av_val_asu.advp_val_status_dts (

251: -- Validate that related date is set for the granting status.
252: IF p_inserting OR (p_updating AND (new_references.s_adv_stnd_granting_status <>
253: old_references.s_adv_stnd_granting_status)) THEN
254: IF new_references.s_adv_stnd_granting_status = 'GRANTED' THEN
255: IF igs_av_val_asu.advp_val_status_dts (
256: 'GRANTED',
257: new_references.granted_dt,
258: v_message_name,
259: p_adv_stnd_trans

Line 266: IF igs_av_val_asu.advp_val_status_dts (

262: Igs_Ge_Msg_Stack.Add;
263: App_Exception.Raise_Exception;
264: END IF;
265: ELSIF new_references.s_adv_stnd_granting_status = 'REVOKED' THEN
266: IF igs_av_val_asu.advp_val_status_dts (
267: 'REVOKED',
268: new_references.revoked_dt,
269: v_message_name
270: ) = FALSE THEN

Line 276: IF igs_av_val_asu.advp_val_status_dts (

272: Igs_Ge_Msg_Stack.Add;
273: App_Exception.Raise_Exception;
274: END IF;
275: ELSIF new_references.s_adv_stnd_granting_status = 'CANCELLED' THEN
276: IF igs_av_val_asu.advp_val_status_dts (
277: 'CANCELLED',
278: new_references.cancelled_dt,
279: v_message_name
280: ) = FALSE THEN

Line 286: IF igs_av_val_asu.advp_val_status_dts (

282: Igs_Ge_Msg_Stack.Add;
283: App_Exception.Raise_Exception;
284: END IF;
285: ELSIF new_references.s_adv_stnd_granting_status = 'EXPIRED' THEN
286: IF igs_av_val_asu.advp_val_status_dts (
287: 'EXPIRED',
288: new_references.expiry_dt,
289: v_message_name
290: ) = FALSE THEN

Line 296: IF igs_av_val_asu.advp_val_status_dts (

292: Igs_Ge_Msg_Stack.Add;
293: App_Exception.Raise_Exception;
294: END IF;
295: ELSIF new_references.s_adv_stnd_granting_status = 'APPROVED' THEN
296: IF igs_av_val_asu.advp_val_status_dts (
297: 'APPROVED',
298: new_references.approved_dt,
299: v_message_name,
300: p_adv_stnd_trans

Line 349: IF igs_av_val_asu.advp_val_asu_inst (

345: END IF;
346: -- Validate that exemption institution code is valid.
347: IF p_inserting OR (p_updating AND (new_references.exemption_institution_cd <>
348: old_references.exemption_institution_cd)) THEN
349: IF igs_av_val_asu.advp_val_asu_inst (
350: new_references.exemption_institution_cd,
351: v_message_name) = FALSE THEN
352: Fnd_Message.Set_Name('IGS', v_message_name);
353: Igs_Ge_Msg_Stack.Add;