[Home] [Help]
338: ((NVL(old_references.expiry_dt,
339: igs_ge_date.igsdate('1900/01/01')) <>
340: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR
341: (old_references.course_status <> new_references.course_status))) THEN
342: IF igs_ps_val_crv.crsp_val_crv_exp_sts (
343: new_references.course_cd,
344: new_references.version_number,
345: new_references.expiry_dt,
346: new_references.course_status,
360: -- IGS_GE_NOTE: A IGS_PS_COURSE version can only be created with a status of PLANNED.
361: -- Hence, only need to perform the check if updating.
362: IF p_updating AND
363: (v_s_course_status = cst_active) THEN
364: IF igs_ps_val_crv.crsp_val_crv_quality(
365: new_references.course_cd,
366: new_references.version_number,
367: old_references.course_status,
368: v_message_name) = FALSE THEN
517: END IF;
518: -- Validate the IGS_PS_COURSE status.
519: IF p_inserting OR
520: (p_updating AND (old_references.course_status <> new_references.course_status)) THEN
521: IF igs_ps_val_crv.crsp_val_crv_status (
522: new_references.course_status,
523: old_references.course_status,
524: v_message_name) = FALSE THEN
525: fnd_message.set_name('IGS',v_message_name);
543: END IF;
544: -- Validate the IGS_PS_COURSE type.
545: IF p_inserting OR
546: (p_updating AND (old_references.course_type <> new_references.course_type)) THEN
547: IF igs_ps_val_crv.crsp_val_crv_type (
548: new_references.course_cd,
549: new_references.version_number,
550: new_references.course_type,
551: v_message_name) = FALSE THEN
557: -- Validate the GOVT special IGS_PS_COURSE type.
558: IF p_inserting OR
559: (p_updating AND
560: (old_references.govt_special_course_type<> new_references.govt_special_course_type)) THEN
561: IF igs_ps_val_crv.crsp_val_crv_gsct (
562: new_references.govt_special_course_type,
563: v_message_name) = FALSE THEN
564: fnd_message.set_name('IGS',v_message_name);
565: igs_ge_msg_stack.add;
574: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01')))) OR
575: (p_updating AND
576: (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
577: NVL(new_references.expiry_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
578: /* As part of bug# 1956374 changed the following call from igs_ps_val_crv.crsp_val_ver_dt*/
579: IF igs_ps_val_us.crsp_val_ver_dt (
580: new_references.start_dt,
581: new_references.end_dt,
582: new_references.expiry_dt,
586: app_exception.raise_exception;
587: END IF;
588: END IF;
589: IF p_updating AND new_references.end_dt IS NOT NULL THEN
590: IF igs_ps_val_crv.crsp_val_crv_end(new_references.course_cd,
591: new_references.version_number,
592: v_return_type,
593: v_message_name) = FALSE THEN
594: IF v_return_type = cst_error THEN
603: (p_updating AND
604: ((old_references.responsible_org_unit_cd <> new_references.responsible_org_unit_cd) OR
605: (NVL(old_references.responsible_ou_start_dt,igs_ge_date.igsdate('1900/01/01')) <>
606: NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')))))THEN
607: IF igs_ps_val_crv.crsp_val_ou_sys_sts (
608: new_references.responsible_org_unit_cd,
609: new_references.responsible_ou_start_dt,
610: v_message_name) = FALSE THEN
611: fnd_message.set_name('IGS',v_message_name);
618: (p_updating AND
619: ((NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
620: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01'))) OR
621: (old_references.course_status <> new_references.course_status))) THEN
622: IF igs_ps_val_crv.crsp_val_crv_end_sts(
623: new_references.end_dt,
624: new_references.course_status,
625: v_message_name) = FALSE THEN
626: fnd_message.set_name('IGS',v_message_name);