DBA Data[Home] [Help]

APPS.IGS_EN_UNIT_SET_PKG dependencies on IGS_PS_VAL_US

Line 245: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_US.crsp_val_ou_sys_sts

241: -- Validate that inserts/updates are allowed
242: IF p_inserting THEN
243: --
244: -- Org UNIT inactive validation
245: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_US.crsp_val_ou_sys_sts
246: IF IGS_PS_VAL_CRV.crsp_val_ou_sys_sts (
247: new_references.responsible_org_unit_cd,
248: new_references.responsible_ou_start_dt,
249: v_message_name) = FALSE THEN

Line 256: IF IGS_PS_VAL_US.crsp_val_uss_closed (

252: App_Exception.Raise_Exception;
253: END IF;
254: --
255: -- UNIT set status closed validation
256: IF IGS_PS_VAL_US.crsp_val_uss_closed (
257: new_references.unit_set_status,
258: v_message_name) = FALSE THEN
259: Fnd_Message.Set_Name('IGS', v_message_name);
260: IGS_GE_MSG_STACK.ADD;

Line 265: IF IGS_PS_VAL_US.crsp_val_usc_closed (

261: App_Exception.Raise_Exception;
262: END IF;
263: --
264: -- UNIT set category closed validation
265: IF IGS_PS_VAL_US.crsp_val_usc_closed (
266: new_references.UNIT_SET_CAT,
267: v_message_name) = FALSE THEN
268: Fnd_Message.Set_Name('IGS', v_message_name);
269: IGS_GE_MSG_STACK.ADD;

Line 277: IF IGS_PS_VAL_US.crsp_val_ver_dt (

273: -- Validate that inserts/updates are allowed
274: IF p_inserting OR p_updating THEN
275: -- , ,
276: -- Start/Expiry/End date validations
277: IF IGS_PS_VAL_US.crsp_val_ver_dt (
278: new_references.start_dt,
279: new_references.end_dt,
280: new_references.expiry_dt,
281: v_message_name,FALSE) = FALSE THEN

Line 288: IF IGS_PS_VAL_US.crsp_val_us_end_sts (

284: App_Exception.Raise_Exception;
285: END IF;
286: --
287: -- End date/UNIT set status cross-field validation
288: IF IGS_PS_VAL_US.crsp_val_us_end_sts (
289: new_references.end_dt,
290: new_references.unit_set_status,
291: v_message_name) = FALSE THEN
292: Fnd_Message.Set_Name('IGS', v_message_name);

Line 300: IF IGS_PS_VAL_US.crsp_val_us_enr (

296: --
297: -- Validate end date/UNIT set status when there are active students
298: IF new_references.end_dt IS NOT NULL or
299: IGS_PS_GEN_006.CRSP_GET_US_SYS_STS (new_references.unit_set_status) = 'INACTIVE' THEN
300: IF IGS_PS_VAL_US.crsp_val_us_enr (
301: new_references.unit_set_cd,
302: new_references.version_number,
303: v_message_name) = FALSE THEN
304: Fnd_Message.Set_Name('IGS', v_message_name);

Line 311: IF IGS_PS_VAL_US.crsp_val_us_status (

307: END IF;
308: END IF;
309: --
310: -- Validate UNIT set status changes
311: IF IGS_PS_VAL_US.crsp_val_us_status (
312: old_references.unit_set_status,
313: new_references.unit_set_status,
314: v_message_name) = FALSE THEN
315: Fnd_Message.Set_Name('IGS', v_message_name);

Line 350: IF IGS_PS_VAL_US.crsp_val_us_exp_sts (

346: p_deleting IN BOOLEAN DEFAULT FALSE
347: ) as
348: v_message_name varchar2(30);
349: BEGIN
350: IF IGS_PS_VAL_US.crsp_val_us_exp_sts (
351: New_References.unit_set_cd,
352: New_References.version_number,
353: New_References.unit_set_status,
354: New_References.expiry_dt,