APPS.IGS_PS_UNIT_LGCY_PKG dependencies on FND_API

Line 2487: IF p_usec_rec.unit_cd IS NULL OR p_usec_rec.unit_cd = FND_API.G_MISS_CHAR THEN

2483: -- This procedure validates UO parameter values in Unit Section record
2484: PROCEDURE validate_uo_parameters ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2485: BEGIN
2486: /* Check for Mandatory Fields */
2487: IF p_usec_rec.unit_cd IS NULL OR p_usec_rec.unit_cd = FND_API.G_MISS_CHAR THEN
2488: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);
2489: p_usec_rec.status := 'E';
2490: END IF;
2491: IF p_usec_rec.version_number IS NULL OR p_usec_rec.version_number = FND_API.G_MISS_NUM THEN

Line 2491: IF p_usec_rec.version_number IS NULL OR p_usec_rec.version_number = FND_API.G_MISS_NUM THEN

2487: IF p_usec_rec.unit_cd IS NULL OR p_usec_rec.unit_cd = FND_API.G_MISS_CHAR THEN
2488: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);
2489: p_usec_rec.status := 'E';
2490: END IF;
2491: IF p_usec_rec.version_number IS NULL OR p_usec_rec.version_number = FND_API.G_MISS_NUM THEN
2492: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VER_NUM', 'LEGACY_TOKENS', FALSE);
2493: p_usec_rec.status := 'E';
2494: END IF;
2495: IF p_usec_rec.teach_cal_alternate_code IS NULL OR p_usec_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

Line 2495: IF p_usec_rec.teach_cal_alternate_code IS NULL OR p_usec_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

2491: IF p_usec_rec.version_number IS NULL OR p_usec_rec.version_number = FND_API.G_MISS_NUM THEN
2492: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VER_NUM', 'LEGACY_TOKENS', FALSE);
2493: p_usec_rec.status := 'E';
2494: END IF;
2495: IF p_usec_rec.teach_cal_alternate_code IS NULL OR p_usec_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
2496: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD', 'LEGACY_TOKENS', FALSE);
2497: p_usec_rec.status := 'E';
2498: END IF;
2499: END validate_uo_parameters;

Line 2914: IF p_usec_rec.location_cd IS NULL OR p_usec_rec.location_cd = FND_API.G_MISS_CHAR THEN

2910: PROCEDURE validate_uoo_parameters ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2911: BEGIN
2912:
2913: /* Check for Mandatory Fields */
2914: IF p_usec_rec.location_cd IS NULL OR p_usec_rec.location_cd = FND_API.G_MISS_CHAR THEN
2915: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD', 'LEGACY_TOKENS', FALSE);
2916: p_usec_rec.status := 'E';
2917: END IF;
2918: IF p_usec_rec.unit_class IS NULL OR p_usec_rec.unit_class = FND_API.G_MISS_CHAR THEN

Line 2918: IF p_usec_rec.unit_class IS NULL OR p_usec_rec.unit_class = FND_API.G_MISS_CHAR THEN

2914: IF p_usec_rec.location_cd IS NULL OR p_usec_rec.location_cd = FND_API.G_MISS_CHAR THEN
2915: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD', 'LEGACY_TOKENS', FALSE);
2916: p_usec_rec.status := 'E';
2917: END IF;
2918: IF p_usec_rec.unit_class IS NULL OR p_usec_rec.unit_class = FND_API.G_MISS_CHAR THEN
2919: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CLASS', 'LEGACY_TOKENS', FALSE);
2920: p_usec_rec.status := 'E';
2921: END IF;
2922:

Line 3479: ELSIF p_usec_rec.ivrs_available_ind = FND_API.G_MISS_CHAR THEN

3475: CLOSE c_usec;
3476:
3477: IF p_usec_rec.ivrs_available_ind IS NULL THEN
3478: p_usec_rec.ivrs_available_ind := c_usec_rec.ivrs_available_ind ;
3479: ELSIF p_usec_rec.ivrs_available_ind = FND_API.G_MISS_CHAR THEN
3480: p_usec_rec.ivrs_available_ind :='N';
3481: END IF;
3482:
3483: IF p_usec_rec.call_number IS NULL THEN

Line 3485: ELSIF p_usec_rec.call_number = FND_API.G_MISS_NUM THEN

3481: END IF;
3482:
3483: IF p_usec_rec.call_number IS NULL THEN
3484: p_usec_rec.call_number := c_usec_rec.call_number;
3485: ELSIF p_usec_rec.call_number = FND_API.G_MISS_NUM THEN
3486: IF fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' THEN
3487: p_usec_rec.call_number :=NULL;
3488: ELSE
3489: p_usec_rec.call_number := c_usec_rec.call_number;

Line 3502: ELSIF p_usec_rec.unit_section_status = FND_API.G_MISS_CHAR THEN

3498: END IF;
3499:
3500: IF p_usec_rec.unit_section_status IS NULL THEN
3501: p_usec_rec.unit_section_status :=c_usec_rec.unit_section_status;
3502: ELSIF p_usec_rec.unit_section_status = FND_API.G_MISS_CHAR THEN
3503: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'USEC_STATUS', 'LEGACY_TOKENS', FALSE);
3504: p_usec_rec.status := 'E';
3505: END IF;
3506:

Line 3509: ELSIF p_usec_rec.unit_section_start_date = FND_API.G_MISS_DATE THEN

3505: END IF;
3506:
3507: IF p_usec_rec.unit_section_start_date IS NULL THEN
3508: p_usec_rec.unit_section_start_date :=c_usec_rec.unit_section_start_date;
3509: ELSIF p_usec_rec.unit_section_start_date = FND_API.G_MISS_DATE THEN
3510: p_usec_rec.unit_section_start_date :=NULL;
3511: END IF;
3512:
3513: IF p_usec_rec.unit_section_end_date IS NULL THEN

Line 3515: ELSIF p_usec_rec.unit_section_end_date = FND_API.G_MISS_DATE THEN

3511: END IF;
3512:
3513: IF p_usec_rec.unit_section_end_date IS NULL THEN
3514: p_usec_rec.unit_section_end_date := c_usec_rec.unit_section_end_date;
3515: ELSIF p_usec_rec.unit_section_end_date = FND_API.G_MISS_DATE THEN
3516: p_usec_rec.unit_section_end_date :=NULL;
3517: END IF;
3518:
3519: IF p_usec_rec.offered_ind IS NULL THEN

Line 3521: ELSIF p_usec_rec.offered_ind = FND_API.G_MISS_CHAR THEN

3517: END IF;
3518:
3519: IF p_usec_rec.offered_ind IS NULL THEN
3520: p_usec_rec.offered_ind := c_usec_rec.offered_ind;
3521: ELSIF p_usec_rec.offered_ind = FND_API.G_MISS_CHAR THEN
3522: p_usec_rec.offered_ind :='N';
3523: END IF;
3524:
3525: IF p_usec_rec.state_financial_aid IS NULL THEN

Line 3527: ELSIF p_usec_rec.state_financial_aid = FND_API.G_MISS_CHAR THEN

3523: END IF;
3524:
3525: IF p_usec_rec.state_financial_aid IS NULL THEN
3526: p_usec_rec.state_financial_aid := c_usec_rec.state_financial_aid;
3527: ELSIF p_usec_rec.state_financial_aid = FND_API.G_MISS_CHAR THEN
3528: p_usec_rec.state_financial_aid :='N';
3529: END IF;
3530:
3531: IF p_usec_rec.grading_schema_prcdnce_ind IS NULL THEN

Line 3533: ELSIF p_usec_rec.grading_schema_prcdnce_ind = FND_API.G_MISS_CHAR THEN

3529: END IF;
3530:
3531: IF p_usec_rec.grading_schema_prcdnce_ind IS NULL THEN
3532: p_usec_rec.grading_schema_prcdnce_ind := c_usec_rec.grading_schema_prcdnce_ind;
3533: ELSIF p_usec_rec.grading_schema_prcdnce_ind = FND_API.G_MISS_CHAR THEN
3534: p_usec_rec.grading_schema_prcdnce_ind :='N';
3535: END IF;
3536:
3537: IF p_usec_rec.federal_financial_aid IS NULL THEN

Line 3539: ELSIF p_usec_rec.federal_financial_aid = FND_API.G_MISS_CHAR THEN

3535: END IF;
3536:
3537: IF p_usec_rec.federal_financial_aid IS NULL THEN
3538: p_usec_rec.federal_financial_aid := c_usec_rec.federal_financial_aid;
3539: ELSIF p_usec_rec.federal_financial_aid = FND_API.G_MISS_CHAR THEN
3540: p_usec_rec.federal_financial_aid :='N';
3541: END IF;
3542:
3543: IF p_usec_rec.unit_quota IS NULL THEN

Line 3545: ELSIF p_usec_rec.unit_quota = FND_API.G_MISS_NUM THEN

3541: END IF;
3542:
3543: IF p_usec_rec.unit_quota IS NULL THEN
3544: p_usec_rec.unit_quota := c_usec_rec.unit_quota;
3545: ELSIF p_usec_rec.unit_quota = FND_API.G_MISS_NUM THEN
3546: p_usec_rec.unit_quota :=NULL;
3547: END IF;
3548:
3549: IF p_usec_rec.unit_quota_reserved_places IS NULL THEN

Line 3551: ELSIF p_usec_rec.unit_quota_reserved_places = FND_API.G_MISS_NUM THEN

3547: END IF;
3548:
3549: IF p_usec_rec.unit_quota_reserved_places IS NULL THEN
3550: p_usec_rec.unit_quota_reserved_places := c_usec_rec.unit_quota_reserved_places;
3551: ELSIF p_usec_rec.unit_quota_reserved_places = FND_API.G_MISS_NUM THEN
3552: p_usec_rec.unit_quota_reserved_places :=NULL;
3553: END IF;
3554:
3555: IF p_usec_rec.institutional_financial_aid IS NULL THEN

Line 3557: ELSIF p_usec_rec.institutional_financial_aid = FND_API.G_MISS_CHAR THEN

3553: END IF;
3554:
3555: IF p_usec_rec.institutional_financial_aid IS NULL THEN
3556: p_usec_rec.institutional_financial_aid := c_usec_rec.institutional_financial_aid;
3557: ELSIF p_usec_rec.institutional_financial_aid = FND_API.G_MISS_CHAR THEN
3558: p_usec_rec.institutional_financial_aid :='N';
3559: END IF;
3560:
3561: IF p_usec_rec.grading_schema_cd IS NULL THEN

Line 3563: ELSIF p_usec_rec.grading_schema_cd = FND_API.G_MISS_CHAR THEN

3559: END IF;
3560:
3561: IF p_usec_rec.grading_schema_cd IS NULL THEN
3562: p_usec_rec.grading_schema_cd := c_usec_rec.grading_schema_cd;
3563: ELSIF p_usec_rec.grading_schema_cd = FND_API.G_MISS_CHAR THEN
3564: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'GRADINGS_SCHEMA_CD', 'LEGACY_TOKENS', FALSE);
3565: p_usec_rec.status := 'E';
3566: END IF;
3567:

Line 3570: ELSIF p_usec_rec.gs_version_number = FND_API.G_MISS_NUM THEN

3566: END IF;
3567:
3568: IF p_usec_rec.gs_version_number IS NULL THEN
3569: p_usec_rec.gs_version_number := c_usec_rec.gs_version_number;
3570: ELSIF p_usec_rec.gs_version_number = FND_API.G_MISS_NUM THEN
3571: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'GS_VERSION_NUMBER', 'LEGACY_TOKENS', FALSE);
3572: p_usec_rec.status := 'E';
3573: END IF;
3574:

Line 3577: ELSIF p_usec_rec.unit_contact_number = FND_API.G_MISS_NUM THEN

3573: END IF;
3574:
3575: IF p_usec_rec.unit_contact_number IS NULL THEN
3576: p_usec_rec.unit_contact_number := c_usec_rec.unit_contact;
3577: ELSIF p_usec_rec.unit_contact_number = FND_API.G_MISS_NUM THEN
3578: p_usec_rec.unit_contact_number :=NULL;
3579: END IF;
3580:
3581: IF p_usec_rec.ss_enrol_ind IS NULL THEN

Line 3583: ELSIF p_usec_rec.ss_enrol_ind = FND_API.G_MISS_CHAR THEN

3579: END IF;
3580:
3581: IF p_usec_rec.ss_enrol_ind IS NULL THEN
3582: p_usec_rec.ss_enrol_ind := c_usec_rec.ss_enrol_ind;
3583: ELSIF p_usec_rec.ss_enrol_ind = FND_API.G_MISS_CHAR THEN
3584: p_usec_rec.ss_enrol_ind :='N';
3585: END IF;
3586:
3587: IF p_usec_rec.owner_org_unit_cd IS NULL THEN

Line 3589: ELSIF p_usec_rec.owner_org_unit_cd = FND_API.G_MISS_CHAR THEN

3585: END IF;
3586:
3587: IF p_usec_rec.owner_org_unit_cd IS NULL THEN
3588: p_usec_rec.owner_org_unit_cd := c_usec_rec.owner_org_unit_cd;
3589: ELSIF p_usec_rec.owner_org_unit_cd = FND_API.G_MISS_CHAR THEN
3590: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'OWNER_ORG_UNIT_CD', 'LEGACY_TOKENS', FALSE);
3591: p_usec_rec.status := 'E';
3592: END IF;
3593:

Line 3596: ELSIF p_usec_rec.attendance_required_ind = FND_API.G_MISS_CHAR THEN

3592: END IF;
3593:
3594: IF p_usec_rec.attendance_required_ind IS NULL THEN
3595: p_usec_rec.attendance_required_ind := c_usec_rec.attendance_required_ind;
3596: ELSIF p_usec_rec.attendance_required_ind = FND_API.G_MISS_CHAR THEN
3597: p_usec_rec.attendance_required_ind :='N';
3598: END IF;
3599:
3600: IF p_usec_rec.reserved_seating_allowed IS NULL THEN

Line 3602: ELSIF p_usec_rec.reserved_seating_allowed = FND_API.G_MISS_CHAR THEN

3598: END IF;
3599:
3600: IF p_usec_rec.reserved_seating_allowed IS NULL THEN
3601: p_usec_rec.reserved_seating_allowed := c_usec_rec.reserved_seating_allowed;
3602: ELSIF p_usec_rec.reserved_seating_allowed = FND_API.G_MISS_CHAR THEN
3603: p_usec_rec.reserved_seating_allowed :='N';
3604: END IF;
3605:
3606: IF p_usec_rec.special_permission_ind IS NULL THEN

Line 3608: ELSIF p_usec_rec.special_permission_ind = FND_API.G_MISS_CHAR THEN

3604: END IF;
3605:
3606: IF p_usec_rec.special_permission_ind IS NULL THEN
3607: p_usec_rec.special_permission_ind := c_usec_rec.special_permission_ind;
3608: ELSIF p_usec_rec.special_permission_ind = FND_API.G_MISS_CHAR THEN
3609: p_usec_rec.special_permission_ind :='N';
3610: END IF;
3611:
3612: IF p_usec_rec.ss_display_ind IS NULL THEN

Line 3614: ELSIF p_usec_rec.ss_display_ind = FND_API.G_MISS_CHAR THEN

3610: END IF;
3611:
3612: IF p_usec_rec.ss_display_ind IS NULL THEN
3613: p_usec_rec.ss_display_ind := c_usec_rec.ss_display_ind;
3614: ELSIF p_usec_rec.ss_display_ind = FND_API.G_MISS_CHAR THEN
3615: p_usec_rec.ss_display_ind :='N';
3616: END IF;
3617:
3618: IF p_usec_rec.rev_account_cd IS NULL THEN

Line 3620: ELSIF p_usec_rec.rev_account_cd = FND_API.G_MISS_CHAR THEN

3616: END IF;
3617:
3618: IF p_usec_rec.rev_account_cd IS NULL THEN
3619: p_usec_rec.rev_account_cd := c_usec_rec.rev_account_cd;
3620: ELSIF p_usec_rec.rev_account_cd = FND_API.G_MISS_CHAR THEN
3621: p_usec_rec.rev_account_cd :=NULL;
3622: END IF;
3623:
3624: IF p_usec_rec.anon_unit_grading_ind IS NULL THEN

Line 3626: ELSIF p_usec_rec.anon_unit_grading_ind = FND_API.G_MISS_CHAR THEN

3622: END IF;
3623:
3624: IF p_usec_rec.anon_unit_grading_ind IS NULL THEN
3625: p_usec_rec.anon_unit_grading_ind := c_usec_rec.anon_unit_grading_ind;
3626: ELSIF p_usec_rec.anon_unit_grading_ind = FND_API.G_MISS_CHAR THEN
3627: p_usec_rec.anon_unit_grading_ind :='N';
3628: END IF;
3629:
3630: IF p_usec_rec.anon_assess_grading_ind IS NULL THEN

Line 3632: ELSIF p_usec_rec.anon_assess_grading_ind = FND_API.G_MISS_CHAR THEN

3628: END IF;
3629:
3630: IF p_usec_rec.anon_assess_grading_ind IS NULL THEN
3631: p_usec_rec.anon_assess_grading_ind := c_usec_rec.anon_assess_grading_ind;
3632: ELSIF p_usec_rec.anon_assess_grading_ind = FND_API.G_MISS_CHAR THEN
3633: p_usec_rec.anon_assess_grading_ind :='N';
3634: END IF;
3635:
3636: IF p_usec_rec.non_std_usec_ind IS NULL THEN

Line 3638: ELSIF p_usec_rec.non_std_usec_ind = FND_API.G_MISS_CHAR THEN

3634: END IF;
3635:
3636: IF p_usec_rec.non_std_usec_ind IS NULL THEN
3637: p_usec_rec.non_std_usec_ind := c_usec_rec.non_std_usec_ind;
3638: ELSIF p_usec_rec.non_std_usec_ind = FND_API.G_MISS_CHAR THEN
3639: p_usec_rec.non_std_usec_ind :='N';
3640: END IF;
3641:
3642: IF p_usec_rec.auditable_ind IS NULL THEN

Line 3644: ELSIF p_usec_rec.auditable_ind = FND_API.G_MISS_CHAR THEN

3640: END IF;
3641:
3642: IF p_usec_rec.auditable_ind IS NULL THEN
3643: p_usec_rec.auditable_ind := c_usec_rec.auditable_ind;
3644: ELSIF p_usec_rec.auditable_ind = FND_API.G_MISS_CHAR THEN
3645: p_usec_rec.auditable_ind :='N';
3646: END IF;
3647:
3648: IF p_usec_rec.audit_permission_ind IS NULL THEN

Line 3650: ELSIF p_usec_rec.audit_permission_ind = FND_API.G_MISS_CHAR THEN

3646: END IF;
3647:
3648: IF p_usec_rec.audit_permission_ind IS NULL THEN
3649: p_usec_rec.audit_permission_ind := c_usec_rec.audit_permission_ind;
3650: ELSIF p_usec_rec.audit_permission_ind = FND_API.G_MISS_CHAR THEN
3651: p_usec_rec.audit_permission_ind :='N';
3652: END IF;
3653:
3654: IF p_usec_rec.not_multiple_section_flag IS NULL THEN

Line 3656: ELSIF p_usec_rec.not_multiple_section_flag = FND_API.G_MISS_CHAR THEN

3652: END IF;
3653:
3654: IF p_usec_rec.not_multiple_section_flag IS NULL THEN
3655: p_usec_rec.not_multiple_section_flag := c_usec_rec.not_multiple_section_flag;
3656: ELSIF p_usec_rec.not_multiple_section_flag = FND_API.G_MISS_CHAR THEN
3657: p_usec_rec.not_multiple_section_flag :='N';
3658: END IF;
3659:
3660: IF p_usec_rec.default_enroll_flag IS NULL THEN

Line 3662: ELSIF p_usec_rec.default_enroll_flag = FND_API.G_MISS_CHAR THEN

3658: END IF;
3659:
3660: IF p_usec_rec.default_enroll_flag IS NULL THEN
3661: p_usec_rec.default_enroll_flag := c_usec_rec.default_enroll_flag;
3662: ELSIF p_usec_rec.default_enroll_flag = FND_API.G_MISS_CHAR THEN
3663: p_usec_rec.default_enroll_flag :='N';
3664: END IF;
3665:
3666: END IF;

Line 4347: ELSIF p_usec_rec.minimum_credit_points = FND_API.G_MISS_NUM THEN

4343: CLOSE c_usec_cp;
4344:
4345: IF p_usec_rec.minimum_credit_points IS NULL THEN
4346: p_usec_rec.minimum_credit_points := c_usec_cp_rec.minimum_credit_points ;
4347: ELSIF p_usec_rec.minimum_credit_points = FND_API.G_MISS_NUM THEN
4348: p_usec_rec.minimum_credit_points :=NULL;
4349: END IF;
4350: IF p_usec_rec.maximum_credit_points IS NULL THEN
4351: p_usec_rec.maximum_credit_points := c_usec_cp_rec.maximum_credit_points ;

Line 4352: ELSIF p_usec_rec.maximum_credit_points = FND_API.G_MISS_NUM THEN

4348: p_usec_rec.minimum_credit_points :=NULL;
4349: END IF;
4350: IF p_usec_rec.maximum_credit_points IS NULL THEN
4351: p_usec_rec.maximum_credit_points := c_usec_cp_rec.maximum_credit_points ;
4352: ELSIF p_usec_rec.maximum_credit_points = FND_API.G_MISS_NUM THEN
4353: p_usec_rec.maximum_credit_points :=NULL;
4354: END IF;
4355: IF p_usec_rec.variable_increment IS NULL THEN
4356: p_usec_rec.variable_increment := c_usec_cp_rec.variable_increment ;

Line 4357: ELSIF p_usec_rec.variable_increment = FND_API.G_MISS_NUM THEN

4353: p_usec_rec.maximum_credit_points :=NULL;
4354: END IF;
4355: IF p_usec_rec.variable_increment IS NULL THEN
4356: p_usec_rec.variable_increment := c_usec_cp_rec.variable_increment ;
4357: ELSIF p_usec_rec.variable_increment = FND_API.G_MISS_NUM THEN
4358: p_usec_rec.variable_increment :=NULL;
4359: END IF;
4360: IF p_usec_rec.lecture_credit_points IS NULL THEN
4361: p_usec_rec.lecture_credit_points := c_usec_cp_rec.lecture_credit_points ;

Line 4362: ELSIF p_usec_rec.lecture_credit_points = FND_API.G_MISS_NUM THEN

4358: p_usec_rec.variable_increment :=NULL;
4359: END IF;
4360: IF p_usec_rec.lecture_credit_points IS NULL THEN
4361: p_usec_rec.lecture_credit_points := c_usec_cp_rec.lecture_credit_points ;
4362: ELSIF p_usec_rec.lecture_credit_points = FND_API.G_MISS_NUM THEN
4363: p_usec_rec.lecture_credit_points :=NULL;
4364: END IF;
4365: IF p_usec_rec.lab_credit_points IS NULL THEN
4366: p_usec_rec.lab_credit_points := c_usec_cp_rec.lab_credit_points ;

Line 4367: ELSIF p_usec_rec.lab_credit_points = FND_API.G_MISS_NUM THEN

4363: p_usec_rec.lecture_credit_points :=NULL;
4364: END IF;
4365: IF p_usec_rec.lab_credit_points IS NULL THEN
4366: p_usec_rec.lab_credit_points := c_usec_cp_rec.lab_credit_points ;
4367: ELSIF p_usec_rec.lab_credit_points = FND_API.G_MISS_NUM THEN
4368: p_usec_rec.lab_credit_points :=NULL;
4369: END IF;
4370: IF p_usec_rec.other_credit_points IS NULL THEN
4371: p_usec_rec.other_credit_points := c_usec_cp_rec.other_credit_points ;

Line 4372: ELSIF p_usec_rec.other_credit_points = FND_API.G_MISS_NUM THEN

4368: p_usec_rec.lab_credit_points :=NULL;
4369: END IF;
4370: IF p_usec_rec.other_credit_points IS NULL THEN
4371: p_usec_rec.other_credit_points := c_usec_cp_rec.other_credit_points ;
4372: ELSIF p_usec_rec.other_credit_points = FND_API.G_MISS_NUM THEN
4373: p_usec_rec.other_credit_points :=NULL;
4374: END IF;
4375: IF p_usec_rec.clock_hours IS NULL THEN
4376: p_usec_rec.clock_hours := c_usec_cp_rec.clock_hours ;

Line 4377: ELSIF p_usec_rec.clock_hours = FND_API.G_MISS_NUM THEN

4373: p_usec_rec.other_credit_points :=NULL;
4374: END IF;
4375: IF p_usec_rec.clock_hours IS NULL THEN
4376: p_usec_rec.clock_hours := c_usec_cp_rec.clock_hours ;
4377: ELSIF p_usec_rec.clock_hours = FND_API.G_MISS_NUM THEN
4378: p_usec_rec.clock_hours :=NULL;
4379: END IF;
4380: IF p_usec_rec.billing_credit_points IS NULL THEN
4381: p_usec_rec.billing_credit_points := c_usec_cp_rec.billing_credit_points ;

Line 4382: ELSIF p_usec_rec.billing_credit_points = FND_API.G_MISS_NUM THEN

4378: p_usec_rec.clock_hours :=NULL;
4379: END IF;
4380: IF p_usec_rec.billing_credit_points IS NULL THEN
4381: p_usec_rec.billing_credit_points := c_usec_cp_rec.billing_credit_points ;
4382: ELSIF p_usec_rec.billing_credit_points = FND_API.G_MISS_NUM THEN
4383: p_usec_rec.billing_credit_points :=NULL;
4384: END IF;
4385: IF p_usec_rec.work_load_cp_lecture IS NULL THEN
4386: p_usec_rec.work_load_cp_lecture := c_usec_cp_rec.work_load_cp_lecture ;

Line 4387: ELSIF p_usec_rec.work_load_cp_lecture = FND_API.G_MISS_NUM THEN

4383: p_usec_rec.billing_credit_points :=NULL;
4384: END IF;
4385: IF p_usec_rec.work_load_cp_lecture IS NULL THEN
4386: p_usec_rec.work_load_cp_lecture := c_usec_cp_rec.work_load_cp_lecture ;
4387: ELSIF p_usec_rec.work_load_cp_lecture = FND_API.G_MISS_NUM THEN
4388: p_usec_rec.work_load_cp_lecture :=NULL;
4389: END IF;
4390: IF p_usec_rec.work_load_cp_lab IS NULL THEN
4391: p_usec_rec.work_load_cp_lab := c_usec_cp_rec.work_load_cp_lab ;

Line 4392: ELSIF p_usec_rec.work_load_cp_lab = FND_API.G_MISS_NUM THEN

4388: p_usec_rec.work_load_cp_lecture :=NULL;
4389: END IF;
4390: IF p_usec_rec.work_load_cp_lab IS NULL THEN
4391: p_usec_rec.work_load_cp_lab := c_usec_cp_rec.work_load_cp_lab ;
4392: ELSIF p_usec_rec.work_load_cp_lab = FND_API.G_MISS_NUM THEN
4393: p_usec_rec.work_load_cp_lab :=NULL;
4394: END IF;
4395: IF p_usec_rec.continuing_education_units IS NULL THEN
4396: p_usec_rec.continuing_education_units := c_usec_cp_rec.continuing_education_units ;

Line 4397: ELSIF p_usec_rec.continuing_education_units = FND_API.G_MISS_NUM THEN

4393: p_usec_rec.work_load_cp_lab :=NULL;
4394: END IF;
4395: IF p_usec_rec.continuing_education_units IS NULL THEN
4396: p_usec_rec.continuing_education_units := c_usec_cp_rec.continuing_education_units ;
4397: ELSIF p_usec_rec.continuing_education_units = FND_API.G_MISS_NUM THEN
4398: p_usec_rec.continuing_education_units :=NULL;
4399: END IF;
4400: IF p_usec_rec.achievable_credit_points IS NULL THEN
4401: p_usec_rec.achievable_credit_points := c_usec_cp_rec.achievable_credit_points ;

Line 4402: ELSIF p_usec_rec.achievable_credit_points = FND_API.G_MISS_NUM THEN

4398: p_usec_rec.continuing_education_units :=NULL;
4399: END IF;
4400: IF p_usec_rec.achievable_credit_points IS NULL THEN
4401: p_usec_rec.achievable_credit_points := c_usec_cp_rec.achievable_credit_points ;
4402: ELSIF p_usec_rec.achievable_credit_points = FND_API.G_MISS_NUM THEN
4403: p_usec_rec.achievable_credit_points :=NULL;
4404: END IF;
4405: IF p_usec_rec.enrolled_credit_points IS NULL THEN
4406: p_usec_rec.enrolled_credit_points := c_usec_cp_rec.enrolled_credit_points ;

Line 4407: ELSIF p_usec_rec.enrolled_credit_points = FND_API.G_MISS_NUM THEN

4403: p_usec_rec.achievable_credit_points :=NULL;
4404: END IF;
4405: IF p_usec_rec.enrolled_credit_points IS NULL THEN
4406: p_usec_rec.enrolled_credit_points := c_usec_cp_rec.enrolled_credit_points ;
4407: ELSIF p_usec_rec.enrolled_credit_points = FND_API.G_MISS_NUM THEN
4408: p_usec_rec.enrolled_credit_points :=NULL;
4409: END IF;
4410: IF p_usec_rec.work_load_other IS NULL THEN
4411: p_usec_rec.work_load_other := c_usec_cp_rec.work_load_other ;

Line 4412: ELSIF p_usec_rec.work_load_other = FND_API.G_MISS_NUM THEN

4408: p_usec_rec.enrolled_credit_points :=NULL;
4409: END IF;
4410: IF p_usec_rec.work_load_other IS NULL THEN
4411: p_usec_rec.work_load_other := c_usec_cp_rec.work_load_other ;
4412: ELSIF p_usec_rec.work_load_other = FND_API.G_MISS_NUM THEN
4413: p_usec_rec.work_load_other :=NULL;
4414: END IF;
4415: IF p_usec_rec.contact_hrs_lecture IS NULL THEN
4416: p_usec_rec.contact_hrs_lecture := c_usec_cp_rec.contact_hrs_lecture ;

Line 4417: ELSIF p_usec_rec.contact_hrs_lecture = FND_API.G_MISS_NUM THEN

4413: p_usec_rec.work_load_other :=NULL;
4414: END IF;
4415: IF p_usec_rec.contact_hrs_lecture IS NULL THEN
4416: p_usec_rec.contact_hrs_lecture := c_usec_cp_rec.contact_hrs_lecture ;
4417: ELSIF p_usec_rec.contact_hrs_lecture = FND_API.G_MISS_NUM THEN
4418: p_usec_rec.contact_hrs_lecture :=NULL;
4419: END IF;
4420: IF p_usec_rec.contact_hrs_lab IS NULL THEN
4421: p_usec_rec.contact_hrs_lab := c_usec_cp_rec.contact_hrs_lab ;

Line 4422: ELSIF p_usec_rec.contact_hrs_lab = FND_API.G_MISS_NUM THEN

4418: p_usec_rec.contact_hrs_lecture :=NULL;
4419: END IF;
4420: IF p_usec_rec.contact_hrs_lab IS NULL THEN
4421: p_usec_rec.contact_hrs_lab := c_usec_cp_rec.contact_hrs_lab ;
4422: ELSIF p_usec_rec.contact_hrs_lab = FND_API.G_MISS_NUM THEN
4423: p_usec_rec.contact_hrs_lab :=NULL;
4424: END IF;
4425: IF p_usec_rec.contact_hrs_other IS NULL THEN
4426: p_usec_rec.contact_hrs_other := c_usec_cp_rec.contact_hrs_other ;

Line 4427: ELSIF p_usec_rec.contact_hrs_other = FND_API.G_MISS_NUM THEN

4423: p_usec_rec.contact_hrs_lab :=NULL;
4424: END IF;
4425: IF p_usec_rec.contact_hrs_other IS NULL THEN
4426: p_usec_rec.contact_hrs_other := c_usec_cp_rec.contact_hrs_other ;
4427: ELSIF p_usec_rec.contact_hrs_other = FND_API.G_MISS_NUM THEN
4428: p_usec_rec.contact_hrs_other :=NULL;
4429: END IF;
4430: IF p_usec_rec.billing_hrs IS NULL THEN
4431: p_usec_rec.billing_hrs := c_usec_cp_rec.billing_hrs ;

Line 4432: ELSIF p_usec_rec.billing_hrs = FND_API.G_MISS_NUM THEN

4428: p_usec_rec.contact_hrs_other :=NULL;
4429: END IF;
4430: IF p_usec_rec.billing_hrs IS NULL THEN
4431: p_usec_rec.billing_hrs := c_usec_cp_rec.billing_hrs ;
4432: ELSIF p_usec_rec.billing_hrs = FND_API.G_MISS_NUM THEN
4433: p_usec_rec.billing_hrs :=NULL;
4434: END IF;
4435: IF p_usec_rec.non_schd_required_hrs IS NULL THEN
4436: p_usec_rec.non_schd_required_hrs := c_usec_cp_rec.non_schd_required_hrs ;

Line 4437: ELSIF p_usec_rec.non_schd_required_hrs = FND_API.G_MISS_NUM THEN

4433: p_usec_rec.billing_hrs :=NULL;
4434: END IF;
4435: IF p_usec_rec.non_schd_required_hrs IS NULL THEN
4436: p_usec_rec.non_schd_required_hrs := c_usec_cp_rec.non_schd_required_hrs ;
4437: ELSIF p_usec_rec.non_schd_required_hrs = FND_API.G_MISS_NUM THEN
4438: p_usec_rec.non_schd_required_hrs :=NULL;
4439: END IF;
4440: IF p_usec_rec.exclude_from_max_cp_limit IS NULL THEN
4441: p_usec_rec.exclude_from_max_cp_limit := c_usec_cp_rec.exclude_from_max_cp_limit ;

Line 4442: ELSIF p_usec_rec.exclude_from_max_cp_limit = FND_API.G_MISS_CHAR THEN

4438: p_usec_rec.non_schd_required_hrs :=NULL;
4439: END IF;
4440: IF p_usec_rec.exclude_from_max_cp_limit IS NULL THEN
4441: p_usec_rec.exclude_from_max_cp_limit := c_usec_cp_rec.exclude_from_max_cp_limit ;
4442: ELSIF p_usec_rec.exclude_from_max_cp_limit = FND_API.G_MISS_CHAR THEN
4443: p_usec_rec.exclude_from_max_cp_limit :=NULL;
4444: END IF;
4445: IF p_usec_rec.claimable_hours IS NULL THEN
4446: p_usec_rec.claimable_hours := c_usec_cp_rec.claimable_hours ;

Line 4447: ELSIF p_usec_rec.claimable_hours = FND_API.G_MISS_NUM THEN

4443: p_usec_rec.exclude_from_max_cp_limit :=NULL;
4444: END IF;
4445: IF p_usec_rec.claimable_hours IS NULL THEN
4446: p_usec_rec.claimable_hours := c_usec_cp_rec.claimable_hours ;
4447: ELSIF p_usec_rec.claimable_hours = FND_API.G_MISS_NUM THEN
4448: p_usec_rec.claimable_hours :=NULL;
4449: END IF;
4450: END IF;
4451:

Line 4768: ELSIF p_usec_rec.reference_subtitle = FND_API.G_MISS_CHAR THEN

4764: CLOSE c_usec_ref;
4765:
4766: IF p_usec_rec.reference_subtitle IS NULL THEN
4767: p_usec_rec.reference_subtitle := c_usec_ref_rec.subtitle ;
4768: ELSIF p_usec_rec.reference_subtitle = FND_API.G_MISS_CHAR THEN
4769: p_usec_rec.reference_subtitle :=NULL;
4770: END IF;
4771: IF p_usec_rec.reference_short_title IS NULL THEN
4772: p_usec_rec.reference_short_title := c_usec_ref_rec.short_title ;

Line 4773: ELSIF p_usec_rec.reference_short_title = FND_API.G_MISS_CHAR THEN

4769: p_usec_rec.reference_subtitle :=NULL;
4770: END IF;
4771: IF p_usec_rec.reference_short_title IS NULL THEN
4772: p_usec_rec.reference_short_title := c_usec_ref_rec.short_title ;
4773: ELSIF p_usec_rec.reference_short_title = FND_API.G_MISS_CHAR THEN
4774: p_usec_rec.reference_short_title :=NULL;
4775: END IF;
4776: IF p_usec_rec.reference_subtitle_mod_flag IS NULL THEN
4777: p_usec_rec.reference_subtitle_mod_flag := c_usec_ref_rec.subtitle_modifiable_flag ;

Line 4778: ELSIF p_usec_rec.reference_subtitle_mod_flag = FND_API.G_MISS_CHAR THEN

4774: p_usec_rec.reference_short_title :=NULL;
4775: END IF;
4776: IF p_usec_rec.reference_subtitle_mod_flag IS NULL THEN
4777: p_usec_rec.reference_subtitle_mod_flag := c_usec_ref_rec.subtitle_modifiable_flag ;
4778: ELSIF p_usec_rec.reference_subtitle_mod_flag = FND_API.G_MISS_CHAR THEN
4779: p_usec_rec.reference_subtitle_mod_flag :='N';
4780: END IF;
4781: IF p_usec_rec.reference_class_sch_excl_flag IS NULL THEN
4782: p_usec_rec.reference_class_sch_excl_flag := c_usec_ref_rec.class_schedule_exclusion_flag ;

Line 4783: ELSIF p_usec_rec.reference_class_sch_excl_flag = FND_API.G_MISS_CHAR THEN

4779: p_usec_rec.reference_subtitle_mod_flag :='N';
4780: END IF;
4781: IF p_usec_rec.reference_class_sch_excl_flag IS NULL THEN
4782: p_usec_rec.reference_class_sch_excl_flag := c_usec_ref_rec.class_schedule_exclusion_flag ;
4783: ELSIF p_usec_rec.reference_class_sch_excl_flag = FND_API.G_MISS_CHAR THEN
4784: p_usec_rec.reference_class_sch_excl_flag :='N';
4785: END IF;
4786: IF p_usec_rec.reference_rec_exclusion_flag IS NULL THEN
4787: p_usec_rec.reference_rec_exclusion_flag := c_usec_ref_rec.record_exclusion_flag ;

Line 4788: ELSIF p_usec_rec.reference_rec_exclusion_flag = FND_API.G_MISS_CHAR THEN

4784: p_usec_rec.reference_class_sch_excl_flag :='N';
4785: END IF;
4786: IF p_usec_rec.reference_rec_exclusion_flag IS NULL THEN
4787: p_usec_rec.reference_rec_exclusion_flag := c_usec_ref_rec.record_exclusion_flag ;
4788: ELSIF p_usec_rec.reference_rec_exclusion_flag = FND_API.G_MISS_CHAR THEN
4789: p_usec_rec.reference_rec_exclusion_flag :='N';
4790: END IF;
4791: IF p_usec_rec.reference_attribute_category IS NULL THEN
4792: p_usec_rec.reference_attribute_category := c_usec_ref_rec.attribute_category ;

Line 4793: ELSIF p_usec_rec.reference_attribute_category = FND_API.G_MISS_CHAR THEN

4789: p_usec_rec.reference_rec_exclusion_flag :='N';
4790: END IF;
4791: IF p_usec_rec.reference_attribute_category IS NULL THEN
4792: p_usec_rec.reference_attribute_category := c_usec_ref_rec.attribute_category ;
4793: ELSIF p_usec_rec.reference_attribute_category = FND_API.G_MISS_CHAR THEN
4794: p_usec_rec.reference_attribute_category :=NULL;
4795: END IF;
4796: IF p_usec_rec.reference_attribute1 IS NULL THEN
4797: p_usec_rec.reference_attribute1 := c_usec_ref_rec.attribute1 ;

Line 4798: ELSIF p_usec_rec.reference_attribute1 = FND_API.G_MISS_CHAR THEN

4794: p_usec_rec.reference_attribute_category :=NULL;
4795: END IF;
4796: IF p_usec_rec.reference_attribute1 IS NULL THEN
4797: p_usec_rec.reference_attribute1 := c_usec_ref_rec.attribute1 ;
4798: ELSIF p_usec_rec.reference_attribute1 = FND_API.G_MISS_CHAR THEN
4799: p_usec_rec.reference_attribute1 :=NULL;
4800: END IF;
4801: IF p_usec_rec.reference_attribute2 IS NULL THEN
4802: p_usec_rec.reference_attribute2 := c_usec_ref_rec.attribute2 ;

Line 4803: ELSIF p_usec_rec.reference_attribute2 = FND_API.G_MISS_CHAR THEN

4799: p_usec_rec.reference_attribute1 :=NULL;
4800: END IF;
4801: IF p_usec_rec.reference_attribute2 IS NULL THEN
4802: p_usec_rec.reference_attribute2 := c_usec_ref_rec.attribute2 ;
4803: ELSIF p_usec_rec.reference_attribute2 = FND_API.G_MISS_CHAR THEN
4804: p_usec_rec.reference_attribute2 :=NULL;
4805: END IF;
4806: IF p_usec_rec.reference_attribute3 IS NULL THEN
4807: p_usec_rec.reference_attribute3 := c_usec_ref_rec.attribute3 ;

Line 4808: ELSIF p_usec_rec.reference_attribute3 = FND_API.G_MISS_CHAR THEN

4804: p_usec_rec.reference_attribute2 :=NULL;
4805: END IF;
4806: IF p_usec_rec.reference_attribute3 IS NULL THEN
4807: p_usec_rec.reference_attribute3 := c_usec_ref_rec.attribute3 ;
4808: ELSIF p_usec_rec.reference_attribute3 = FND_API.G_MISS_CHAR THEN
4809: p_usec_rec.reference_attribute3 :=NULL;
4810: END IF;
4811: IF p_usec_rec.reference_attribute4 IS NULL THEN
4812: p_usec_rec.reference_attribute4 := c_usec_ref_rec.attribute4 ;

Line 4813: ELSIF p_usec_rec.reference_attribute4 = FND_API.G_MISS_CHAR THEN

4809: p_usec_rec.reference_attribute3 :=NULL;
4810: END IF;
4811: IF p_usec_rec.reference_attribute4 IS NULL THEN
4812: p_usec_rec.reference_attribute4 := c_usec_ref_rec.attribute4 ;
4813: ELSIF p_usec_rec.reference_attribute4 = FND_API.G_MISS_CHAR THEN
4814: p_usec_rec.reference_attribute4 :=NULL;
4815: END IF;
4816: IF p_usec_rec.reference_attribute5 IS NULL THEN
4817: p_usec_rec.reference_attribute5 := c_usec_ref_rec.attribute5 ;

Line 4818: ELSIF p_usec_rec.reference_attribute5 = FND_API.G_MISS_CHAR THEN

4814: p_usec_rec.reference_attribute4 :=NULL;
4815: END IF;
4816: IF p_usec_rec.reference_attribute5 IS NULL THEN
4817: p_usec_rec.reference_attribute5 := c_usec_ref_rec.attribute5 ;
4818: ELSIF p_usec_rec.reference_attribute5 = FND_API.G_MISS_CHAR THEN
4819: p_usec_rec.reference_attribute5 :=NULL;
4820: END IF;
4821: IF p_usec_rec.reference_attribute6 IS NULL THEN
4822: p_usec_rec.reference_attribute6 := c_usec_ref_rec.attribute6 ;

Line 4823: ELSIF p_usec_rec.reference_attribute6 = FND_API.G_MISS_CHAR THEN

4819: p_usec_rec.reference_attribute5 :=NULL;
4820: END IF;
4821: IF p_usec_rec.reference_attribute6 IS NULL THEN
4822: p_usec_rec.reference_attribute6 := c_usec_ref_rec.attribute6 ;
4823: ELSIF p_usec_rec.reference_attribute6 = FND_API.G_MISS_CHAR THEN
4824: p_usec_rec.reference_attribute6 :=NULL;
4825: END IF;
4826: IF p_usec_rec.reference_attribute7 IS NULL THEN
4827: p_usec_rec.reference_attribute7 := c_usec_ref_rec.attribute7 ;

Line 4828: ELSIF p_usec_rec.reference_attribute7 = FND_API.G_MISS_CHAR THEN

4824: p_usec_rec.reference_attribute6 :=NULL;
4825: END IF;
4826: IF p_usec_rec.reference_attribute7 IS NULL THEN
4827: p_usec_rec.reference_attribute7 := c_usec_ref_rec.attribute7 ;
4828: ELSIF p_usec_rec.reference_attribute7 = FND_API.G_MISS_CHAR THEN
4829: p_usec_rec.reference_attribute7 :=NULL;
4830: END IF;
4831: IF p_usec_rec.reference_attribute8 IS NULL THEN
4832: p_usec_rec.reference_attribute8 := c_usec_ref_rec.attribute8 ;

Line 4833: ELSIF p_usec_rec.reference_attribute8 = FND_API.G_MISS_CHAR THEN

4829: p_usec_rec.reference_attribute7 :=NULL;
4830: END IF;
4831: IF p_usec_rec.reference_attribute8 IS NULL THEN
4832: p_usec_rec.reference_attribute8 := c_usec_ref_rec.attribute8 ;
4833: ELSIF p_usec_rec.reference_attribute8 = FND_API.G_MISS_CHAR THEN
4834: p_usec_rec.reference_attribute8 :=NULL;
4835: END IF;
4836: IF p_usec_rec.reference_attribute9 IS NULL THEN
4837: p_usec_rec.reference_attribute9 := c_usec_ref_rec.attribute9 ;

Line 4838: ELSIF p_usec_rec.reference_attribute9 = FND_API.G_MISS_CHAR THEN

4834: p_usec_rec.reference_attribute8 :=NULL;
4835: END IF;
4836: IF p_usec_rec.reference_attribute9 IS NULL THEN
4837: p_usec_rec.reference_attribute9 := c_usec_ref_rec.attribute9 ;
4838: ELSIF p_usec_rec.reference_attribute9 = FND_API.G_MISS_CHAR THEN
4839: p_usec_rec.reference_attribute9 :=NULL;
4840: END IF;
4841: IF p_usec_rec.reference_attribute10 IS NULL THEN
4842: p_usec_rec.reference_attribute10 := c_usec_ref_rec.attribute10 ;

Line 4843: ELSIF p_usec_rec.reference_attribute10 = FND_API.G_MISS_CHAR THEN

4839: p_usec_rec.reference_attribute9 :=NULL;
4840: END IF;
4841: IF p_usec_rec.reference_attribute10 IS NULL THEN
4842: p_usec_rec.reference_attribute10 := c_usec_ref_rec.attribute10 ;
4843: ELSIF p_usec_rec.reference_attribute10 = FND_API.G_MISS_CHAR THEN
4844: p_usec_rec.reference_attribute10 :=NULL;
4845: END IF;
4846: IF p_usec_rec.reference_attribute11 IS NULL THEN
4847: p_usec_rec.reference_attribute11 := c_usec_ref_rec.attribute11 ;

Line 4848: ELSIF p_usec_rec.reference_attribute11 = FND_API.G_MISS_CHAR THEN

4844: p_usec_rec.reference_attribute10 :=NULL;
4845: END IF;
4846: IF p_usec_rec.reference_attribute11 IS NULL THEN
4847: p_usec_rec.reference_attribute11 := c_usec_ref_rec.attribute11 ;
4848: ELSIF p_usec_rec.reference_attribute11 = FND_API.G_MISS_CHAR THEN
4849: p_usec_rec.reference_attribute11 :=NULL;
4850: END IF;
4851: IF p_usec_rec.reference_attribute12 IS NULL THEN
4852: p_usec_rec.reference_attribute12 := c_usec_ref_rec.attribute12 ;

Line 4853: ELSIF p_usec_rec.reference_attribute12 = FND_API.G_MISS_CHAR THEN

4849: p_usec_rec.reference_attribute11 :=NULL;
4850: END IF;
4851: IF p_usec_rec.reference_attribute12 IS NULL THEN
4852: p_usec_rec.reference_attribute12 := c_usec_ref_rec.attribute12 ;
4853: ELSIF p_usec_rec.reference_attribute12 = FND_API.G_MISS_CHAR THEN
4854: p_usec_rec.reference_attribute12 :=NULL;
4855: END IF;
4856: IF p_usec_rec.reference_attribute13 IS NULL THEN
4857: p_usec_rec.reference_attribute13 := c_usec_ref_rec.attribute13 ;

Line 4858: ELSIF p_usec_rec.reference_attribute13 = FND_API.G_MISS_CHAR THEN

4854: p_usec_rec.reference_attribute12 :=NULL;
4855: END IF;
4856: IF p_usec_rec.reference_attribute13 IS NULL THEN
4857: p_usec_rec.reference_attribute13 := c_usec_ref_rec.attribute13 ;
4858: ELSIF p_usec_rec.reference_attribute13 = FND_API.G_MISS_CHAR THEN
4859: p_usec_rec.reference_attribute13 :=NULL;
4860: END IF;
4861: IF p_usec_rec.reference_attribute14 IS NULL THEN
4862: p_usec_rec.reference_attribute14 := c_usec_ref_rec.attribute14 ;

Line 4863: ELSIF p_usec_rec.reference_attribute14 = FND_API.G_MISS_CHAR THEN

4859: p_usec_rec.reference_attribute13 :=NULL;
4860: END IF;
4861: IF p_usec_rec.reference_attribute14 IS NULL THEN
4862: p_usec_rec.reference_attribute14 := c_usec_ref_rec.attribute14 ;
4863: ELSIF p_usec_rec.reference_attribute14 = FND_API.G_MISS_CHAR THEN
4864: p_usec_rec.reference_attribute14 :=NULL;
4865: END IF;
4866: IF p_usec_rec.reference_attribute15 IS NULL THEN
4867: p_usec_rec.reference_attribute15 := c_usec_ref_rec.attribute15 ;

Line 4868: ELSIF p_usec_rec.reference_attribute15 = FND_API.G_MISS_CHAR THEN

4864: p_usec_rec.reference_attribute14 :=NULL;
4865: END IF;
4866: IF p_usec_rec.reference_attribute15 IS NULL THEN
4867: p_usec_rec.reference_attribute15 := c_usec_ref_rec.attribute15 ;
4868: ELSIF p_usec_rec.reference_attribute15 = FND_API.G_MISS_CHAR THEN
4869: p_usec_rec.reference_attribute15 :=NULL;
4870: END IF;
4871: IF p_usec_rec.reference_attribute16 IS NULL THEN
4872: p_usec_rec.reference_attribute16 := c_usec_ref_rec.attribute16 ;

Line 4873: ELSIF p_usec_rec.reference_attribute16 = FND_API.G_MISS_CHAR THEN

4869: p_usec_rec.reference_attribute15 :=NULL;
4870: END IF;
4871: IF p_usec_rec.reference_attribute16 IS NULL THEN
4872: p_usec_rec.reference_attribute16 := c_usec_ref_rec.attribute16 ;
4873: ELSIF p_usec_rec.reference_attribute16 = FND_API.G_MISS_CHAR THEN
4874: p_usec_rec.reference_attribute16 :=NULL;
4875: END IF;
4876: IF p_usec_rec.reference_attribute17 IS NULL THEN
4877: p_usec_rec.reference_attribute17 := c_usec_ref_rec.attribute17 ;

Line 4878: ELSIF p_usec_rec.reference_attribute17 = FND_API.G_MISS_CHAR THEN

4874: p_usec_rec.reference_attribute16 :=NULL;
4875: END IF;
4876: IF p_usec_rec.reference_attribute17 IS NULL THEN
4877: p_usec_rec.reference_attribute17 := c_usec_ref_rec.attribute17 ;
4878: ELSIF p_usec_rec.reference_attribute17 = FND_API.G_MISS_CHAR THEN
4879: p_usec_rec.reference_attribute17 :=NULL;
4880: END IF;
4881: IF p_usec_rec.reference_attribute18 IS NULL THEN
4882: p_usec_rec.reference_attribute18 := c_usec_ref_rec.attribute18 ;

Line 4883: ELSIF p_usec_rec.reference_attribute18 = FND_API.G_MISS_CHAR THEN

4879: p_usec_rec.reference_attribute17 :=NULL;
4880: END IF;
4881: IF p_usec_rec.reference_attribute18 IS NULL THEN
4882: p_usec_rec.reference_attribute18 := c_usec_ref_rec.attribute18 ;
4883: ELSIF p_usec_rec.reference_attribute18 = FND_API.G_MISS_CHAR THEN
4884: p_usec_rec.reference_attribute18 :=NULL;
4885: END IF;
4886: IF p_usec_rec.reference_attribute19 IS NULL THEN
4887: p_usec_rec.reference_attribute19 := c_usec_ref_rec.attribute19 ;

Line 4888: ELSIF p_usec_rec.reference_attribute19 = FND_API.G_MISS_CHAR THEN

4884: p_usec_rec.reference_attribute18 :=NULL;
4885: END IF;
4886: IF p_usec_rec.reference_attribute19 IS NULL THEN
4887: p_usec_rec.reference_attribute19 := c_usec_ref_rec.attribute19 ;
4888: ELSIF p_usec_rec.reference_attribute19 = FND_API.G_MISS_CHAR THEN
4889: p_usec_rec.reference_attribute19 :=NULL;
4890: END IF;
4891: IF p_usec_rec.reference_attribute20 IS NULL THEN
4892: p_usec_rec.reference_attribute20 := c_usec_ref_rec.attribute20 ;

Line 4893: ELSIF p_usec_rec.reference_attribute20 = FND_API.G_MISS_CHAR THEN

4889: p_usec_rec.reference_attribute19 :=NULL;
4890: END IF;
4891: IF p_usec_rec.reference_attribute20 IS NULL THEN
4892: p_usec_rec.reference_attribute20 := c_usec_ref_rec.attribute20 ;
4893: ELSIF p_usec_rec.reference_attribute20 = FND_API.G_MISS_CHAR THEN
4894: p_usec_rec.reference_attribute20 :=NULL;
4895: END IF;
4896: IF p_usec_rec.reference_title IS NULL THEN
4897: p_usec_rec.reference_title := c_usec_ref_rec.title ;

Line 4898: ELSIF p_usec_rec.reference_title = FND_API.G_MISS_CHAR THEN

4894: p_usec_rec.reference_attribute20 :=NULL;
4895: END IF;
4896: IF p_usec_rec.reference_title IS NULL THEN
4897: p_usec_rec.reference_title := c_usec_ref_rec.title ;
4898: ELSIF p_usec_rec.reference_title = FND_API.G_MISS_CHAR THEN
4899: p_usec_rec.reference_title :=NULL;
4900: END IF;
4901: END IF;
4902: END Assign_default;

Line 5181: ELSIF p_usec_rec.usec_waitlist_allowed = FND_API.G_MISS_CHAR THEN

5177: CLOSE c_usec_lim;
5178:
5179: IF p_usec_rec.usec_waitlist_allowed IS NULL THEN
5180: p_usec_rec.usec_waitlist_allowed := c_usec_lim_rec.waitlist_allowed;
5181: ELSIF p_usec_rec.usec_waitlist_allowed = FND_API.G_MISS_CHAR THEN
5182: p_usec_rec.usec_waitlist_allowed :='N';
5183: END IF;
5184:
5185: IF p_usec_rec.usec_max_students_per_waitlist IS NULL THEN

Line 5187: ELSIF p_usec_rec.usec_max_students_per_waitlist = FND_API.G_MISS_NUM THEN

5183: END IF;
5184:
5185: IF p_usec_rec.usec_max_students_per_waitlist IS NULL THEN
5186: p_usec_rec.usec_max_students_per_waitlist := c_usec_lim_rec.max_students_per_waitlist ;
5187: ELSIF p_usec_rec.usec_max_students_per_waitlist = FND_API.G_MISS_NUM THEN
5188: p_usec_rec.usec_max_students_per_waitlist :=0;
5189: END IF;
5190:
5191: IF p_usec_rec.enrollment_expected IS NULL THEN

Line 5193: ELSIF p_usec_rec.enrollment_expected = FND_API.G_MISS_NUM THEN

5189: END IF;
5190:
5191: IF p_usec_rec.enrollment_expected IS NULL THEN
5192: p_usec_rec.enrollment_expected := c_usec_lim_rec.enrollment_expected ;
5193: ELSIF p_usec_rec.enrollment_expected = FND_API.G_MISS_NUM THEN
5194: p_usec_rec.enrollment_expected :=NULL;
5195: END IF;
5196:
5197: IF p_usec_rec.enrollment_minimum IS NULL THEN

Line 5199: ELSIF p_usec_rec.enrollment_minimum = FND_API.G_MISS_NUM THEN

5195: END IF;
5196:
5197: IF p_usec_rec.enrollment_minimum IS NULL THEN
5198: p_usec_rec.enrollment_minimum := c_usec_lim_rec.enrollment_minimum ;
5199: ELSIF p_usec_rec.enrollment_minimum = FND_API.G_MISS_NUM THEN
5200: p_usec_rec.enrollment_minimum :=NULL;
5201: END IF;
5202:
5203: IF p_usec_rec.enrollment_maximum IS NULL THEN

Line 5205: ELSIF p_usec_rec.enrollment_maximum = FND_API.G_MISS_NUM THEN

5201: END IF;
5202:
5203: IF p_usec_rec.enrollment_maximum IS NULL THEN
5204: p_usec_rec.enrollment_maximum := c_usec_lim_rec.enrollment_maximum ;
5205: ELSIF p_usec_rec.enrollment_maximum = FND_API.G_MISS_NUM THEN
5206: p_usec_rec.enrollment_maximum :=NULL;
5207: END IF;
5208:
5209: IF p_usec_rec.advance_maximum IS NULL THEN

Line 5211: ELSIF p_usec_rec.advance_maximum = FND_API.G_MISS_NUM THEN

5207: END IF;
5208:
5209: IF p_usec_rec.advance_maximum IS NULL THEN
5210: p_usec_rec.advance_maximum := c_usec_lim_rec.advance_maximum ;
5211: ELSIF p_usec_rec.advance_maximum = FND_API.G_MISS_NUM THEN
5212: p_usec_rec.advance_maximum :=NULL;
5213: END IF;
5214:
5215: IF p_usec_rec.override_enrollment_maximum IS NULL THEN

Line 5217: ELSIF p_usec_rec.override_enrollment_maximum = FND_API.G_MISS_NUM THEN

5213: END IF;
5214:
5215: IF p_usec_rec.override_enrollment_maximum IS NULL THEN
5216: p_usec_rec.override_enrollment_maximum := c_usec_lim_rec.override_enrollment_max ;
5217: ELSIF p_usec_rec.override_enrollment_maximum = FND_API.G_MISS_NUM THEN
5218: p_usec_rec.override_enrollment_maximum :=NULL;
5219: END IF;
5220:
5221: IF p_usec_rec.max_auditors_allowed IS NULL THEN

Line 5223: ELSIF p_usec_rec.max_auditors_allowed = FND_API.G_MISS_NUM THEN

5219: END IF;
5220:
5221: IF p_usec_rec.max_auditors_allowed IS NULL THEN
5222: p_usec_rec.max_auditors_allowed := c_usec_lim_rec.max_auditors_allowed ;
5223: ELSIF p_usec_rec.max_auditors_allowed = FND_API.G_MISS_NUM THEN
5224: p_usec_rec.max_auditors_allowed :=NULL;
5225: END IF;
5226: END IF;
5227:

Line 5692: IF p_usec_gs_rec.unit_cd IS NULL OR p_usec_gs_rec.unit_cd = FND_API.G_MISS_CHAR THEN

5688: PROCEDURE validate_parameters ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5689: BEGIN
5690:
5691: /* Check for Mandatory Parameters */
5692: IF p_usec_gs_rec.unit_cd IS NULL OR p_usec_gs_rec.unit_cd = FND_API.G_MISS_CHAR THEN
5693: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);
5694: p_usec_gs_rec.status := 'E';
5695: END IF;
5696: IF p_usec_gs_rec.version_number IS NULL OR p_usec_gs_rec.version_number = FND_API.G_MISS_NUM THEN

Line 5696: IF p_usec_gs_rec.version_number IS NULL OR p_usec_gs_rec.version_number = FND_API.G_MISS_NUM THEN

5692: IF p_usec_gs_rec.unit_cd IS NULL OR p_usec_gs_rec.unit_cd = FND_API.G_MISS_CHAR THEN
5693: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);
5694: p_usec_gs_rec.status := 'E';
5695: END IF;
5696: IF p_usec_gs_rec.version_number IS NULL OR p_usec_gs_rec.version_number = FND_API.G_MISS_NUM THEN
5697: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VER_NUM', 'LEGACY_TOKENS', FALSE);
5698: p_usec_gs_rec.status := 'E';
5699: END IF;
5700: IF p_usec_gs_rec.teach_cal_alternate_code IS NULL OR p_usec_gs_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

Line 5700: IF p_usec_gs_rec.teach_cal_alternate_code IS NULL OR p_usec_gs_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

5696: IF p_usec_gs_rec.version_number IS NULL OR p_usec_gs_rec.version_number = FND_API.G_MISS_NUM THEN
5697: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VER_NUM', 'LEGACY_TOKENS', FALSE);
5698: p_usec_gs_rec.status := 'E';
5699: END IF;
5700: IF p_usec_gs_rec.teach_cal_alternate_code IS NULL OR p_usec_gs_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
5701: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD', 'LEGACY_TOKENS', FALSE);
5702: p_usec_gs_rec.status := 'E';
5703: END IF;
5704: IF p_usec_gs_rec.location_cd IS NULL OR p_usec_gs_rec.location_cd = FND_API.G_MISS_CHAR THEN

Line 5704: IF p_usec_gs_rec.location_cd IS NULL OR p_usec_gs_rec.location_cd = FND_API.G_MISS_CHAR THEN

5700: IF p_usec_gs_rec.teach_cal_alternate_code IS NULL OR p_usec_gs_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
5701: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD', 'LEGACY_TOKENS', FALSE);
5702: p_usec_gs_rec.status := 'E';
5703: END IF;
5704: IF p_usec_gs_rec.location_cd IS NULL OR p_usec_gs_rec.location_cd = FND_API.G_MISS_CHAR THEN
5705: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD', 'LEGACY_TOKENS', FALSE);
5706: p_usec_gs_rec.status := 'E';
5707: END IF;
5708: IF p_usec_gs_rec.unit_class IS NULL OR p_usec_gs_rec.unit_class = FND_API.G_MISS_CHAR THEN

Line 5708: IF p_usec_gs_rec.unit_class IS NULL OR p_usec_gs_rec.unit_class = FND_API.G_MISS_CHAR THEN

5704: IF p_usec_gs_rec.location_cd IS NULL OR p_usec_gs_rec.location_cd = FND_API.G_MISS_CHAR THEN
5705: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD', 'LEGACY_TOKENS', FALSE);
5706: p_usec_gs_rec.status := 'E';
5707: END IF;
5708: IF p_usec_gs_rec.unit_class IS NULL OR p_usec_gs_rec.unit_class = FND_API.G_MISS_CHAR THEN
5709: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CLASS', 'LEGACY_TOKENS', FALSE);
5710: p_usec_gs_rec.status := 'E';
5711: END IF;
5712: IF p_usec_gs_rec.grading_schema_code IS NULL OR p_usec_gs_rec.grading_schema_code = FND_API.G_MISS_CHAR THEN

Line 5712: IF p_usec_gs_rec.grading_schema_code IS NULL OR p_usec_gs_rec.grading_schema_code = FND_API.G_MISS_CHAR THEN

5708: IF p_usec_gs_rec.unit_class IS NULL OR p_usec_gs_rec.unit_class = FND_API.G_MISS_CHAR THEN
5709: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CLASS', 'LEGACY_TOKENS', FALSE);
5710: p_usec_gs_rec.status := 'E';
5711: END IF;
5712: IF p_usec_gs_rec.grading_schema_code IS NULL OR p_usec_gs_rec.grading_schema_code = FND_API.G_MISS_CHAR THEN
5713: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_GRADING_SCHM_CD', 'LEGACY_TOKENS', FALSE);
5714: p_usec_gs_rec.status := 'E';
5715: END IF;
5716: IF p_usec_gs_rec.grd_schm_version_number IS NULL OR p_usec_gs_rec.grd_schm_version_number = FND_API.G_MISS_NUM THEN

Line 5716: IF p_usec_gs_rec.grd_schm_version_number IS NULL OR p_usec_gs_rec.grd_schm_version_number = FND_API.G_MISS_NUM THEN

5712: IF p_usec_gs_rec.grading_schema_code IS NULL OR p_usec_gs_rec.grading_schema_code = FND_API.G_MISS_CHAR THEN
5713: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_GRADING_SCHM_CD', 'LEGACY_TOKENS', FALSE);
5714: p_usec_gs_rec.status := 'E';
5715: END IF;
5716: IF p_usec_gs_rec.grd_schm_version_number IS NULL OR p_usec_gs_rec.grd_schm_version_number = FND_API.G_MISS_NUM THEN
5717: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_GRADING_SCHM_VER_NUM', 'LEGACY_TOKENS', FALSE);
5718: p_usec_gs_rec.status := 'E';
5719: END IF;
5720: IF p_usec_gs_rec.default_flag IS NULL OR p_usec_gs_rec.default_flag = FND_API.G_MISS_CHAR THEN

Line 5720: IF p_usec_gs_rec.default_flag IS NULL OR p_usec_gs_rec.default_flag = FND_API.G_MISS_CHAR THEN

5716: IF p_usec_gs_rec.grd_schm_version_number IS NULL OR p_usec_gs_rec.grd_schm_version_number = FND_API.G_MISS_NUM THEN
5717: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_GRADING_SCHM_VER_NUM', 'LEGACY_TOKENS', FALSE);
5718: p_usec_gs_rec.status := 'E';
5719: END IF;
5720: IF p_usec_gs_rec.default_flag IS NULL OR p_usec_gs_rec.default_flag = FND_API.G_MISS_CHAR THEN
5721: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'DEFAULT_FLAG', 'LEGACY_TOKENS', FALSE);
5722: p_usec_gs_rec.status := 'E';
5723: END IF;
5724: END validate_parameters;

Line 6135: IF p_uso_rec.unit_cd IS NULL OR p_uso_rec.unit_cd = FND_API.G_MISS_CHAR THEN

6131: PROCEDURE validate_parameters ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS
6132: BEGIN
6133:
6134: /* Check for Mandatory Parameters */
6135: IF p_uso_rec.unit_cd IS NULL OR p_uso_rec.unit_cd = FND_API.G_MISS_CHAR THEN
6136: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);
6137: p_uso_rec.status := 'E';
6138: END IF;
6139: IF p_uso_rec.version_number IS NULL OR p_uso_rec.version_number = FND_API.G_MISS_NUM THEN

Line 6139: IF p_uso_rec.version_number IS NULL OR p_uso_rec.version_number = FND_API.G_MISS_NUM THEN

6135: IF p_uso_rec.unit_cd IS NULL OR p_uso_rec.unit_cd = FND_API.G_MISS_CHAR THEN
6136: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);
6137: p_uso_rec.status := 'E';
6138: END IF;
6139: IF p_uso_rec.version_number IS NULL OR p_uso_rec.version_number = FND_API.G_MISS_NUM THEN
6140: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VERSION', 'LEGACY_TOKENS', FALSE);
6141: p_uso_rec.status := 'E';
6142: END IF;
6143: IF p_uso_rec.teach_cal_alternate_code IS NULL OR p_uso_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

Line 6143: IF p_uso_rec.teach_cal_alternate_code IS NULL OR p_uso_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

6139: IF p_uso_rec.version_number IS NULL OR p_uso_rec.version_number = FND_API.G_MISS_NUM THEN
6140: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VERSION', 'LEGACY_TOKENS', FALSE);
6141: p_uso_rec.status := 'E';
6142: END IF;
6143: IF p_uso_rec.teach_cal_alternate_code IS NULL OR p_uso_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
6144: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD', 'LEGACY_TOKENS', FALSE);
6145: p_uso_rec.status := 'E';
6146: END IF;
6147: IF p_uso_rec.location_cd IS NULL OR p_uso_rec.location_cd = FND_API.G_MISS_CHAR THEN

Line 6147: IF p_uso_rec.location_cd IS NULL OR p_uso_rec.location_cd = FND_API.G_MISS_CHAR THEN

6143: IF p_uso_rec.teach_cal_alternate_code IS NULL OR p_uso_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
6144: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD', 'LEGACY_TOKENS', FALSE);
6145: p_uso_rec.status := 'E';
6146: END IF;
6147: IF p_uso_rec.location_cd IS NULL OR p_uso_rec.location_cd = FND_API.G_MISS_CHAR THEN
6148: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD', 'LEGACY_TOKENS', FALSE);
6149: p_uso_rec.status := 'E';
6150: END IF;
6151: IF p_uso_rec.unit_class IS NULL OR p_uso_rec.unit_class = FND_API.G_MISS_CHAR THEN

Line 6151: IF p_uso_rec.unit_class IS NULL OR p_uso_rec.unit_class = FND_API.G_MISS_CHAR THEN

6147: IF p_uso_rec.location_cd IS NULL OR p_uso_rec.location_cd = FND_API.G_MISS_CHAR THEN
6148: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD', 'LEGACY_TOKENS', FALSE);
6149: p_uso_rec.status := 'E';
6150: END IF;
6151: IF p_uso_rec.unit_class IS NULL OR p_uso_rec.unit_class = FND_API.G_MISS_CHAR THEN
6152: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CLASS', 'LEGACY_TOKENS', FALSE);
6153: p_uso_rec.status := 'E';
6154: END IF;
6155: IF p_uso_rec.occurrence_identifier IS NULL OR p_uso_rec.occurrence_identifier = FND_API.G_MISS_CHAR THEN

Line 6155: IF p_uso_rec.occurrence_identifier IS NULL OR p_uso_rec.occurrence_identifier = FND_API.G_MISS_CHAR THEN

6151: IF p_uso_rec.unit_class IS NULL OR p_uso_rec.unit_class = FND_API.G_MISS_CHAR THEN
6152: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CLASS', 'LEGACY_TOKENS', FALSE);
6153: p_uso_rec.status := 'E';
6154: END IF;
6155: IF p_uso_rec.occurrence_identifier IS NULL OR p_uso_rec.occurrence_identifier = FND_API.G_MISS_CHAR THEN
6156: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_OCCRS_ID', 'IGS_PS_LOG_PARAMETERS', FALSE);
6157: p_uso_rec.status := 'E';
6158: END IF;
6159:

Line 6219: IF p_uso_rec.building_code IS NOT NULL AND p_uso_rec.building_code <> FND_API.G_MISS_CHAR THEN

6215: p_uso_rec.status := 'E';
6216: END IF;
6217:
6218: -- Derive Building Identifier and associated Room Identifier.
6219: IF p_uso_rec.building_code IS NOT NULL AND p_uso_rec.building_code <> FND_API.G_MISS_CHAR THEN
6220: OPEN c_build_id ( p_uso_rec.building_code);
6221: FETCH c_build_id INTO l_n_building_code;
6222: IF ( c_build_id%NOTFOUND ) THEN
6223: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'BUILDING_CODE', 'LEGACY_TOKENS', FALSE);

Line 6229: IF p_uso_rec.room_code IS NOT NULL AND p_uso_rec.room_code <> FND_API.G_MISS_CHAR THEN

6225: END IF;
6226: CLOSE c_build_id;
6227:
6228: -- Derive Room Identifier
6229: IF p_uso_rec.room_code IS NOT NULL AND p_uso_rec.room_code <> FND_API.G_MISS_CHAR THEN
6230: OPEN c_room_id ( l_n_building_code, p_uso_rec.room_code );
6231: FETCH c_room_id INTO l_n_room_code;
6232: IF ( c_room_id%NOTFOUND ) THEN
6233: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'ROOM_CODE', 'LEGACY_TOKENS', FALSE);

Line 6241: IF p_uso_rec.dedicated_building_code IS NOT NULL AND p_uso_rec.dedicated_building_code <> FND_API.G_MISS_CHAR THEN

6237: END IF;
6238: END IF;
6239:
6240: -- Derive Dedicated Building Identifier associated Room Identifier
6241: IF p_uso_rec.dedicated_building_code IS NOT NULL AND p_uso_rec.dedicated_building_code <> FND_API.G_MISS_CHAR THEN
6242: OPEN c_bld_id ( p_uso_rec.dedicated_building_code, p_uso_rec.location_cd );
6243: FETCH c_bld_id INTO l_n_dedicated_building_code;
6244: IF ( c_bld_id%NOTFOUND ) THEN
6245: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED', 'LEGACY_TOKENS') || ' ' ||

Line 6252: IF p_uso_rec.dedicated_room_code IS NOT NULL AND p_uso_rec.dedicated_room_code <> FND_API.G_MISS_CHAR THEN

6248: END IF;
6249: CLOSE c_bld_id;
6250:
6251: -- Derive Dedicated Room Identifier
6252: IF p_uso_rec.dedicated_room_code IS NOT NULL AND p_uso_rec.dedicated_room_code <> FND_API.G_MISS_CHAR THEN
6253: OPEN c_room_id ( l_n_dedicated_building_code, p_uso_rec.dedicated_room_code );
6254: FETCH c_room_id INTO l_n_dedicated_room_code;
6255: IF ( c_room_id%NOTFOUND ) THEN
6256: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED', 'LEGACY_TOKENS') || ' ' ||

Line 6265: IF p_uso_rec.preferred_building_code IS NOT NULL AND p_uso_rec.preferred_building_code <> FND_API.G_MISS_CHAR THEN

6261: END IF;
6262: END IF;
6263:
6264: -- Derive Preferred Building Identifier
6265: IF p_uso_rec.preferred_building_code IS NOT NULL AND p_uso_rec.preferred_building_code <> FND_API.G_MISS_CHAR THEN
6266: OPEN c_bld_id ( p_uso_rec.preferred_building_code, p_uso_rec.location_cd );
6267: FETCH c_bld_id INTO l_n_preferred_building_code;
6268: IF ( c_bld_id%NOTFOUND ) THEN
6269: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED', 'LEGACY_TOKENS') || ' ' ||

Line 6276: IF p_uso_rec.preferred_room_code IS NOT NULL AND p_uso_rec.preferred_room_code <> FND_API.G_MISS_CHAR THEN

6272: END IF;
6273: CLOSE c_bld_id;
6274:
6275: -- Derive Preferred Room Identifier
6276: IF p_uso_rec.preferred_room_code IS NOT NULL AND p_uso_rec.preferred_room_code <> FND_API.G_MISS_CHAR THEN
6277: OPEN c_room_id ( l_n_preferred_building_code, p_uso_rec.preferred_room_code );
6278: FETCH c_room_id INTO l_n_preferred_room_code;
6279: IF ( c_room_id%NOTFOUND ) THEN
6280: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED', 'LEGACY_TOKENS') || ' ' ||

Line 6552: ELSIF p_uso_rec.to_be_announced = FND_API.G_MISS_CHAR THEN

6548: CLOSE cur_usec_ocurs;
6549:
6550: IF ( p_uso_rec.to_be_announced IS NULL ) THEN
6551: p_uso_rec.to_be_announced := l_cur_usec_ocurs.to_be_announced;
6552: ELSIF p_uso_rec.to_be_announced = FND_API.G_MISS_CHAR THEN
6553: p_uso_rec.to_be_announced := 'N';
6554: END IF;
6555:
6556: -- Similarly default days to 'N', if they are NULL.

Line 6559: ELSIF p_uso_rec.monday = FND_API.G_MISS_CHAR THEN

6555:
6556: -- Similarly default days to 'N', if they are NULL.
6557: IF ( p_uso_rec.monday IS NULL ) THEN
6558: p_uso_rec.monday := l_cur_usec_ocurs.monday;
6559: ELSIF p_uso_rec.monday = FND_API.G_MISS_CHAR THEN
6560: p_uso_rec.monday := 'N';
6561: END IF;
6562:
6563: IF ( p_uso_rec.tuesday IS NULL ) THEN

Line 6565: ELSIF p_uso_rec.tuesday = FND_API.G_MISS_CHAR THEN

6561: END IF;
6562:
6563: IF ( p_uso_rec.tuesday IS NULL ) THEN
6564: p_uso_rec.tuesday := l_cur_usec_ocurs.tuesday;
6565: ELSIF p_uso_rec.tuesday = FND_API.G_MISS_CHAR THEN
6566: p_uso_rec.tuesday := 'N';
6567: END IF;
6568:
6569: IF ( p_uso_rec.wednesday IS NULL ) THEN

Line 6571: ELSIF p_uso_rec.wednesday = FND_API.G_MISS_CHAR THEN

6567: END IF;
6568:
6569: IF ( p_uso_rec.wednesday IS NULL ) THEN
6570: p_uso_rec.wednesday := l_cur_usec_ocurs.wednesday;
6571: ELSIF p_uso_rec.wednesday = FND_API.G_MISS_CHAR THEN
6572: p_uso_rec.wednesday := 'N';
6573: END IF;
6574:
6575: IF ( p_uso_rec.thursday IS NULL ) THEN

Line 6577: ELSIF p_uso_rec.thursday = FND_API.G_MISS_CHAR THEN

6573: END IF;
6574:
6575: IF ( p_uso_rec.thursday IS NULL ) THEN
6576: p_uso_rec.thursday := l_cur_usec_ocurs.thursday;
6577: ELSIF p_uso_rec.thursday = FND_API.G_MISS_CHAR THEN
6578: p_uso_rec.thursday := 'N';
6579: END IF;
6580:
6581: IF ( p_uso_rec.friday IS NULL ) THEN

Line 6583: ELSIF p_uso_rec.friday = FND_API.G_MISS_CHAR THEN

6579: END IF;
6580:
6581: IF ( p_uso_rec.friday IS NULL ) THEN
6582: p_uso_rec.friday := l_cur_usec_ocurs.friday;
6583: ELSIF p_uso_rec.friday = FND_API.G_MISS_CHAR THEN
6584: p_uso_rec.friday := 'N';
6585: END IF;
6586:
6587: IF ( p_uso_rec.saturday IS NULL ) THEN

Line 6589: ELSIF p_uso_rec.saturday = FND_API.G_MISS_CHAR THEN

6585: END IF;
6586:
6587: IF ( p_uso_rec.saturday IS NULL ) THEN
6588: p_uso_rec.saturday := l_cur_usec_ocurs.saturday;
6589: ELSIF p_uso_rec.saturday = FND_API.G_MISS_CHAR THEN
6590: p_uso_rec.saturday := 'N';
6591: END IF;
6592:
6593:

Line 6596: ELSIF p_uso_rec.sunday = FND_API.G_MISS_CHAR THEN

6592:
6593:
6594: IF ( p_uso_rec.sunday IS NULL ) THEN
6595: p_uso_rec.sunday := l_cur_usec_ocurs.sunday;
6596: ELSIF p_uso_rec.sunday = FND_API.G_MISS_CHAR THEN
6597: p_uso_rec.sunday := 'N';
6598: END IF;
6599:
6600:

Line 6603: ELSIF p_uso_rec.no_set_day_ind = FND_API.G_MISS_CHAR THEN

6599:
6600:
6601: IF p_uso_rec.no_set_day_ind IS NULL THEN
6602: p_uso_rec.no_set_day_ind := l_cur_usec_ocurs.no_set_day_ind;
6603: ELSIF p_uso_rec.no_set_day_ind = FND_API.G_MISS_CHAR THEN
6604: p_uso_rec.no_set_day_ind := 'N';
6605: END IF;
6606:
6607:

Line 6610: ELSIF p_uso_rec.attribute_category = FND_API.G_MISS_CHAR THEN

6606:
6607:
6608: IF p_uso_rec.attribute_category IS NULL THEN
6609: p_uso_rec.attribute_category := l_cur_usec_ocurs.attribute_category;
6610: ELSIF p_uso_rec.attribute_category = FND_API.G_MISS_CHAR THEN
6611: p_uso_rec.attribute_category := NULL;
6612: END IF;
6613:
6614:

Line 6617: ELSIF p_uso_rec.attribute1 = FND_API.G_MISS_CHAR THEN

6613:
6614:
6615: IF p_uso_rec.attribute1 IS NULL THEN
6616: p_uso_rec.attribute1 := l_cur_usec_ocurs.attribute1;
6617: ELSIF p_uso_rec.attribute1 = FND_API.G_MISS_CHAR THEN
6618: p_uso_rec.attribute1 := NULL;
6619: END IF;
6620:
6621:

Line 6624: ELSIF p_uso_rec.attribute2 = FND_API.G_MISS_CHAR THEN

6620:
6621:
6622: IF p_uso_rec.attribute2 IS NULL THEN
6623: p_uso_rec.attribute2 := l_cur_usec_ocurs.attribute2;
6624: ELSIF p_uso_rec.attribute2 = FND_API.G_MISS_CHAR THEN
6625: p_uso_rec.attribute2 := NULL;
6626: END IF;
6627:
6628:

Line 6631: ELSIF p_uso_rec.attribute3 = FND_API.G_MISS_CHAR THEN

6627:
6628:
6629: IF p_uso_rec.attribute3 IS NULL THEN
6630: p_uso_rec.attribute3 := l_cur_usec_ocurs.attribute3;
6631: ELSIF p_uso_rec.attribute3 = FND_API.G_MISS_CHAR THEN
6632: p_uso_rec.attribute3 := NULL;
6633: END IF;
6634:
6635: IF p_uso_rec.attribute4 IS NULL THEN

Line 6637: ELSIF p_uso_rec.attribute4 = FND_API.G_MISS_CHAR THEN

6633: END IF;
6634:
6635: IF p_uso_rec.attribute4 IS NULL THEN
6636: p_uso_rec.attribute4 := l_cur_usec_ocurs.attribute4;
6637: ELSIF p_uso_rec.attribute4 = FND_API.G_MISS_CHAR THEN
6638: p_uso_rec.attribute4 := NULL;
6639: END IF;
6640:
6641: IF p_uso_rec.attribute5 IS NULL THEN

Line 6643: ELSIF p_uso_rec.attribute5 = FND_API.G_MISS_CHAR THEN

6639: END IF;
6640:
6641: IF p_uso_rec.attribute5 IS NULL THEN
6642: p_uso_rec.attribute5 := l_cur_usec_ocurs.attribute5;
6643: ELSIF p_uso_rec.attribute5 = FND_API.G_MISS_CHAR THEN
6644: p_uso_rec.attribute5 := NULL;
6645: END IF;
6646:
6647:

Line 6650: ELSIF p_uso_rec.attribute6 = FND_API.G_MISS_CHAR THEN

6646:
6647:
6648: IF p_uso_rec.attribute6 IS NULL THEN
6649: p_uso_rec.attribute6 := l_cur_usec_ocurs.attribute6;
6650: ELSIF p_uso_rec.attribute6 = FND_API.G_MISS_CHAR THEN
6651: p_uso_rec.attribute6 := NULL;
6652: END IF;
6653:
6654:

Line 6657: ELSIF p_uso_rec.attribute7 = FND_API.G_MISS_CHAR THEN

6653:
6654:
6655: IF p_uso_rec.attribute7 IS NULL THEN
6656: p_uso_rec.attribute7 := l_cur_usec_ocurs.attribute7;
6657: ELSIF p_uso_rec.attribute7 = FND_API.G_MISS_CHAR THEN
6658: p_uso_rec.attribute7 := NULL;
6659: END IF;
6660:
6661:

Line 6664: ELSIF p_uso_rec.attribute8 = FND_API.G_MISS_CHAR THEN

6660:
6661:
6662: IF p_uso_rec.attribute8 IS NULL THEN
6663: p_uso_rec.attribute8 := l_cur_usec_ocurs.attribute8;
6664: ELSIF p_uso_rec.attribute8 = FND_API.G_MISS_CHAR THEN
6665: p_uso_rec.attribute8 := NULL;
6666: END IF;
6667:
6668:

Line 6671: ELSIF p_uso_rec.attribute9 = FND_API.G_MISS_CHAR THEN

6667:
6668:
6669: IF p_uso_rec.attribute9 IS NULL THEN
6670: p_uso_rec.attribute9 := l_cur_usec_ocurs.attribute9;
6671: ELSIF p_uso_rec.attribute9 = FND_API.G_MISS_CHAR THEN
6672: p_uso_rec.attribute9 := NULL;
6673: END IF;
6674:
6675:

Line 6678: ELSIF p_uso_rec.attribute10 = FND_API.G_MISS_CHAR THEN

6674:
6675:
6676: IF p_uso_rec.attribute10 IS NULL THEN
6677: p_uso_rec.attribute10 := l_cur_usec_ocurs.attribute10;
6678: ELSIF p_uso_rec.attribute10 = FND_API.G_MISS_CHAR THEN
6679: p_uso_rec.attribute10 := NULL;
6680: END IF;
6681:
6682:

Line 6685: ELSIF p_uso_rec.attribute11 = FND_API.G_MISS_CHAR THEN

6681:
6682:
6683: IF p_uso_rec.attribute11 IS NULL THEN
6684: p_uso_rec.attribute11 := l_cur_usec_ocurs.attribute11;
6685: ELSIF p_uso_rec.attribute11 = FND_API.G_MISS_CHAR THEN
6686: p_uso_rec.attribute11 := NULL;
6687: END IF;
6688:
6689:

Line 6692: ELSIF p_uso_rec.attribute12 = FND_API.G_MISS_CHAR THEN

6688:
6689:
6690: IF p_uso_rec.attribute12 IS NULL THEN
6691: p_uso_rec.attribute12 := l_cur_usec_ocurs.attribute12;
6692: ELSIF p_uso_rec.attribute12 = FND_API.G_MISS_CHAR THEN
6693: p_uso_rec.attribute12 := NULL;
6694: END IF;
6695:
6696:

Line 6699: ELSIF p_uso_rec.attribute13 = FND_API.G_MISS_CHAR THEN

6695:
6696:
6697: IF p_uso_rec.attribute13 IS NULL THEN
6698: p_uso_rec.attribute13 := l_cur_usec_ocurs.attribute13;
6699: ELSIF p_uso_rec.attribute13 = FND_API.G_MISS_CHAR THEN
6700: p_uso_rec.attribute13 := NULL;
6701: END IF;
6702:
6703:

Line 6706: ELSIF p_uso_rec.attribute14 = FND_API.G_MISS_CHAR THEN

6702:
6703:
6704: IF p_uso_rec.attribute14 IS NULL THEN
6705: p_uso_rec.attribute14 := l_cur_usec_ocurs.attribute14;
6706: ELSIF p_uso_rec.attribute14 = FND_API.G_MISS_CHAR THEN
6707: p_uso_rec.attribute14 := NULL;
6708: END IF;
6709:
6710: IF p_uso_rec.attribute15 IS NULL THEN

Line 6712: ELSIF p_uso_rec.attribute15 = FND_API.G_MISS_CHAR THEN

6708: END IF;
6709:
6710: IF p_uso_rec.attribute15 IS NULL THEN
6711: p_uso_rec.attribute15 := l_cur_usec_ocurs.attribute15;
6712: ELSIF p_uso_rec.attribute15 = FND_API.G_MISS_CHAR THEN
6713: p_uso_rec.attribute15 := NULL;
6714: END IF;
6715:
6716:

Line 6719: ELSIF p_uso_rec.attribute16 = FND_API.G_MISS_CHAR THEN

6715:
6716:
6717: IF p_uso_rec.attribute16 IS NULL THEN
6718: p_uso_rec.attribute16 := l_cur_usec_ocurs.attribute16;
6719: ELSIF p_uso_rec.attribute16 = FND_API.G_MISS_CHAR THEN
6720: p_uso_rec.attribute16 := NULL;
6721: END IF;
6722:
6723: IF p_uso_rec.attribute17 IS NULL THEN

Line 6725: ELSIF p_uso_rec.attribute17 = FND_API.G_MISS_CHAR THEN

6721: END IF;
6722:
6723: IF p_uso_rec.attribute17 IS NULL THEN
6724: p_uso_rec.attribute17 := l_cur_usec_ocurs.attribute17;
6725: ELSIF p_uso_rec.attribute17 = FND_API.G_MISS_CHAR THEN
6726: p_uso_rec.attribute17 := NULL;
6727: END IF;
6728:
6729: IF p_uso_rec.attribute18 IS NULL THEN

Line 6731: ELSIF p_uso_rec.attribute18 = FND_API.G_MISS_CHAR THEN

6727: END IF;
6728:
6729: IF p_uso_rec.attribute18 IS NULL THEN
6730: p_uso_rec.attribute18 := l_cur_usec_ocurs.attribute18;
6731: ELSIF p_uso_rec.attribute18 = FND_API.G_MISS_CHAR THEN
6732: p_uso_rec.attribute18 := NULL;
6733: END IF;
6734:
6735: IF p_uso_rec.attribute19 IS NULL THEN

Line 6737: ELSIF p_uso_rec.attribute19 = FND_API.G_MISS_CHAR THEN

6733: END IF;
6734:
6735: IF p_uso_rec.attribute19 IS NULL THEN
6736: p_uso_rec.attribute19 := l_cur_usec_ocurs.attribute19;
6737: ELSIF p_uso_rec.attribute19 = FND_API.G_MISS_CHAR THEN
6738: p_uso_rec.attribute19 := NULL;
6739: END IF;
6740:
6741:

Line 6744: ELSIF p_uso_rec.attribute20 = FND_API.G_MISS_CHAR THEN

6740:
6741:
6742: IF p_uso_rec.attribute20 IS NULL THEN
6743: p_uso_rec.attribute20 := l_cur_usec_ocurs.attribute20;
6744: ELSIF p_uso_rec.attribute20 = FND_API.G_MISS_CHAR THEN
6745: p_uso_rec.attribute20 := NULL;
6746: END IF;
6747:
6748:

Line 6751: ELSIF p_uso_rec.start_time = FND_API.G_MISS_DATE THEN

6747:
6748:
6749: IF p_uso_rec.start_time IS NULL THEN
6750: p_uso_rec.start_time := l_cur_usec_ocurs.start_time;
6751: ELSIF p_uso_rec.start_time = FND_API.G_MISS_DATE THEN
6752: p_uso_rec.start_time := NULL;
6753: END IF;
6754:
6755:

Line 6758: ELSIF p_uso_rec.end_time = FND_API.G_MISS_DATE THEN

6754:
6755:
6756: IF p_uso_rec.end_time IS NULL THEN
6757: p_uso_rec.end_time := l_cur_usec_ocurs.end_time;
6758: ELSIF p_uso_rec.end_time = FND_API.G_MISS_DATE THEN
6759: p_uso_rec.end_time := NULL;
6760: END IF;
6761:
6762:

Line 6765: ELSIF p_uso_rec.building_code = FND_API.G_MISS_CHAR THEN

6761:
6762:
6763: IF p_uso_rec.building_code IS NULL THEN
6764: l_n_building_code := l_cur_usec_ocurs.building_code;
6765: ELSIF p_uso_rec.building_code = FND_API.G_MISS_CHAR THEN
6766: l_n_building_code := NULL;
6767: END IF;
6768:
6769: IF p_uso_rec.room_code IS NULL THEN

Line 6771: ELSIF p_uso_rec.room_code = FND_API.G_MISS_CHAR THEN

6767: END IF;
6768:
6769: IF p_uso_rec.room_code IS NULL THEN
6770: l_n_room_code := l_cur_usec_ocurs.room_code;
6771: ELSIF p_uso_rec.room_code = FND_API.G_MISS_CHAR THEN
6772: l_n_room_code := NULL;
6773: ELSIF p_uso_rec.room_code IS NOT NULL THEN
6774:
6775: OPEN cur_room(l_n_building_code,p_uso_rec.room_code);

Line 6787: ELSIF p_uso_rec.dedicated_building_code = FND_API.G_MISS_CHAR THEN

6783:
6784:
6785: IF p_uso_rec.dedicated_building_code IS NULL THEN
6786: l_n_dedicated_building_code := l_cur_usec_ocurs.dedicated_building_code;
6787: ELSIF p_uso_rec.dedicated_building_code = FND_API.G_MISS_CHAR THEN
6788: l_n_dedicated_building_code := NULL;
6789: END IF;
6790:
6791:

Line 6794: ELSIF p_uso_rec.dedicated_room_code = FND_API.G_MISS_CHAR THEN

6790:
6791:
6792: IF p_uso_rec.dedicated_room_code IS NULL THEN
6793: l_n_dedicated_room_code := l_cur_usec_ocurs.dedicated_room_code;
6794: ELSIF p_uso_rec.dedicated_room_code = FND_API.G_MISS_CHAR THEN
6795: l_n_dedicated_room_code := NULL;
6796: ELSIF p_uso_rec.dedicated_room_code IS NOT NULL THEN
6797: OPEN cur_room(l_n_dedicated_building_code,p_uso_rec.dedicated_room_code);
6798: FETCH cur_room INTO l_n_dedicated_room_code;

Line 6809: ELSIF p_uso_rec.preferred_building_code = FND_API.G_MISS_CHAR THEN

6805: END IF;
6806:
6807: IF p_uso_rec.preferred_building_code IS NULL THEN
6808: l_n_preferred_building_code := l_cur_usec_ocurs.preferred_building_code;
6809: ELSIF p_uso_rec.preferred_building_code = FND_API.G_MISS_CHAR THEN
6810: l_n_preferred_building_code := NULL;
6811: END IF;
6812:
6813:

Line 6816: ELSIF p_uso_rec.preferred_room_code = FND_API.G_MISS_CHAR THEN

6812:
6813:
6814: IF p_uso_rec.preferred_room_code IS NULL THEN
6815: l_n_preferred_room_code := l_cur_usec_ocurs.preferred_room_code;
6816: ELSIF p_uso_rec.preferred_room_code = FND_API.G_MISS_CHAR THEN
6817: l_n_preferred_room_code := NULL;
6818: ELSIF p_uso_rec.preferred_room_code IS NOT NULL THEN
6819: OPEN cur_room(l_n_preferred_building_code,p_uso_rec.preferred_room_code);
6820: FETCH cur_room INTO l_n_preferred_room_code;

Line 6832: ELSIF p_uso_rec.start_date = FND_API.G_MISS_DATE THEN

6828:
6829:
6830: IF p_uso_rec.start_date IS NULL THEN
6831: p_uso_rec.start_date := l_cur_usec_ocurs.start_date;
6832: ELSIF p_uso_rec.start_date = FND_API.G_MISS_DATE THEN
6833: p_uso_rec.start_date := NULL;
6834: END IF;
6835:
6836:

Line 6839: ELSIF p_uso_rec.end_date = FND_API.G_MISS_DATE THEN

6835:
6836:
6837: IF p_uso_rec.end_date IS NULL THEN
6838: p_uso_rec.end_date := l_cur_usec_ocurs.end_date;
6839: ELSIF p_uso_rec.end_date = FND_API.G_MISS_DATE THEN
6840: p_uso_rec.end_date := NULL;
6841: END IF;
6842:
6843:

Line 6846: ELSIF p_uso_rec.preferred_region_code = FND_API.G_MISS_CHAR THEN

6842:
6843:
6844: IF p_uso_rec.preferred_region_code IS NULL THEN
6845: p_uso_rec.preferred_region_code := l_cur_usec_ocurs.preferred_region_code;
6846: ELSIF p_uso_rec.preferred_region_code = FND_API.G_MISS_CHAR THEN
6847: p_uso_rec.preferred_region_code := NULL;
6848: END IF;
6849:
6850: --Set the schedule status.

Line 7375: IF p_ref_cd_rec.unit_cd IS NULL OR p_ref_cd_rec.unit_cd = FND_API.G_MISS_CHAR THEN

7371:
7372: -- Validate the Mandatory Parameters for creation of unit referrence code
7373: PROCEDURE validate_unit_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7374: BEGIN
7375: IF p_ref_cd_rec.unit_cd IS NULL OR p_ref_cd_rec.unit_cd = FND_API.G_MISS_CHAR THEN
7376: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD','LEGACY_TOKENS', FALSE);
7377: p_ref_cd_rec.status := 'E';
7378: END IF;
7379: IF p_ref_cd_rec.version_number IS NULL OR p_ref_cd_rec.version_number = FND_API.G_MISS_NUM THEN

Line 7379: IF p_ref_cd_rec.version_number IS NULL OR p_ref_cd_rec.version_number = FND_API.G_MISS_NUM THEN

7375: IF p_ref_cd_rec.unit_cd IS NULL OR p_ref_cd_rec.unit_cd = FND_API.G_MISS_CHAR THEN
7376: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD','LEGACY_TOKENS', FALSE);
7377: p_ref_cd_rec.status := 'E';
7378: END IF;
7379: IF p_ref_cd_rec.version_number IS NULL OR p_ref_cd_rec.version_number = FND_API.G_MISS_NUM THEN
7380: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VER_NUM','LEGACY_TOKENS', FALSE);
7381: p_ref_cd_rec.status := 'E';
7382: END IF;
7383: IF p_ref_cd_rec.data_type IS NULL OR p_ref_cd_rec.data_type = FND_API.G_MISS_CHAR THEN

Line 7383: IF p_ref_cd_rec.data_type IS NULL OR p_ref_cd_rec.data_type = FND_API.G_MISS_CHAR THEN

7379: IF p_ref_cd_rec.version_number IS NULL OR p_ref_cd_rec.version_number = FND_API.G_MISS_NUM THEN
7380: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_VER_NUM','LEGACY_TOKENS', FALSE);
7381: p_ref_cd_rec.status := 'E';
7382: END IF;
7383: IF p_ref_cd_rec.data_type IS NULL OR p_ref_cd_rec.data_type = FND_API.G_MISS_CHAR THEN
7384: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'DATA_TYPE','LEGACY_TOKENS', FALSE);
7385: p_ref_cd_rec.status := 'E';
7386: END IF;
7387: IF p_ref_cd_rec.reference_cd_type IS NULL OR p_ref_cd_rec.reference_cd_type = FND_API.G_MISS_CHAR THEN

Line 7387: IF p_ref_cd_rec.reference_cd_type IS NULL OR p_ref_cd_rec.reference_cd_type = FND_API.G_MISS_CHAR THEN

7383: IF p_ref_cd_rec.data_type IS NULL OR p_ref_cd_rec.data_type = FND_API.G_MISS_CHAR THEN
7384: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'DATA_TYPE','LEGACY_TOKENS', FALSE);
7385: p_ref_cd_rec.status := 'E';
7386: END IF;
7387: IF p_ref_cd_rec.reference_cd_type IS NULL OR p_ref_cd_rec.reference_cd_type = FND_API.G_MISS_CHAR THEN
7388: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'REFERENCE_CD_TYPE','LEGACY_TOKENS', FALSE);
7389: p_ref_cd_rec.status := 'E';
7390: END IF;
7391: IF p_ref_cd_rec.reference_cd IS NULL OR p_ref_cd_rec.reference_cd = FND_API.G_MISS_CHAR THEN

Line 7391: IF p_ref_cd_rec.reference_cd IS NULL OR p_ref_cd_rec.reference_cd = FND_API.G_MISS_CHAR THEN

7387: IF p_ref_cd_rec.reference_cd_type IS NULL OR p_ref_cd_rec.reference_cd_type = FND_API.G_MISS_CHAR THEN
7388: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'REFERENCE_CD_TYPE','LEGACY_TOKENS', FALSE);
7389: p_ref_cd_rec.status := 'E';
7390: END IF;
7391: IF p_ref_cd_rec.reference_cd IS NULL OR p_ref_cd_rec.reference_cd = FND_API.G_MISS_CHAR THEN
7392: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'REFERENCE_CD','LEGACY_TOKENS', FALSE);
7393: p_ref_cd_rec.status := 'E';
7394: END IF;
7395: END validate_unit_parameters;

Line 7401: IF p_ref_cd_rec.teach_cal_alternate_code IS NULL OR p_ref_cd_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

7397: -- Validate the Mandatory Parameters for Unit Section / Unit Section Occurrence
7398: PROCEDURE validate_usec_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7399: BEGIN
7400: validate_unit_parameters( p_ref_cd_rec );
7401: IF p_ref_cd_rec.teach_cal_alternate_code IS NULL OR p_ref_cd_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
7402: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
7403: p_ref_cd_rec.status := 'E';
7404: END IF;
7405: IF p_ref_cd_rec.location_cd IS NULL OR p_ref_cd_rec.location_cd = FND_API.G_MISS_CHAR THEN

Line 7405: IF p_ref_cd_rec.location_cd IS NULL OR p_ref_cd_rec.location_cd = FND_API.G_MISS_CHAR THEN

7401: IF p_ref_cd_rec.teach_cal_alternate_code IS NULL OR p_ref_cd_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
7402: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
7403: p_ref_cd_rec.status := 'E';
7404: END IF;
7405: IF p_ref_cd_rec.location_cd IS NULL OR p_ref_cd_rec.location_cd = FND_API.G_MISS_CHAR THEN
7406: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD','LEGACY_TOKENS', FALSE);
7407: p_ref_cd_rec.status := 'E';
7408: END IF;
7409: IF p_ref_cd_rec.unit_class IS NULL OR p_ref_cd_rec.unit_class = FND_API.G_MISS_CHAR THEN

Line 7409: IF p_ref_cd_rec.unit_class IS NULL OR p_ref_cd_rec.unit_class = FND_API.G_MISS_CHAR THEN

7405: IF p_ref_cd_rec.location_cd IS NULL OR p_ref_cd_rec.location_cd = FND_API.G_MISS_CHAR THEN
7406: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD','LEGACY_TOKENS', FALSE);
7407: p_ref_cd_rec.status := 'E';
7408: END IF;
7409: IF p_ref_cd_rec.unit_class IS NULL OR p_ref_cd_rec.unit_class = FND_API.G_MISS_CHAR THEN
7410: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CLASS','LEGACY_TOKENS', FALSE);
7411: p_ref_cd_rec.status := 'E';
7412: END IF;
7413:

Line 7415: (p_ref_cd_rec.occurrence_identifier IS NULL OR p_ref_cd_rec.occurrence_identifier = FND_API.G_MISS_CHAR) AND (p_ref_cd_rec.production_uso_id IS NULL OR p_ref_cd_rec.production_uso_id = FND_API.G_MISS_NUM) THEN

7411: p_ref_cd_rec.status := 'E';
7412: END IF;
7413:
7414: IF p_ref_cd_rec.data_type = 'OCCURRENCE' AND
7415: (p_ref_cd_rec.occurrence_identifier IS NULL OR p_ref_cd_rec.occurrence_identifier = FND_API.G_MISS_CHAR) AND (p_ref_cd_rec.production_uso_id IS NULL OR p_ref_cd_rec.production_uso_id = FND_API.G_MISS_NUM) THEN
7416: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS', FALSE);
7417: p_ref_cd_rec.status := 'E';
7418: END IF;
7419:

Line 7833: ELSIF p_ref_cd_rec.description = FND_API.G_MISS_CHAR THEN

7829: CLOSE c_gen;
7830: IF l_c_gen.restricted_flag = 'N' THEN
7831: IF p_ref_cd_rec.description IS NULL THEN
7832: p_ref_cd_rec.description := l_c_gen.reference_code_desc;
7833: ELSIF p_ref_cd_rec.description = FND_API.G_MISS_CHAR THEN
7834: p_ref_cd_rec.description := NULL;
7835: END IF;
7836: END IF;
7837: RETURN 'U';

Line 7850: ELSIF p_ref_cd_rec.description = FND_API.G_MISS_CHAR THEN

7846: CLOSE c_req;
7847: IF l_c_req.restricted_flag = 'N' THEN
7848: IF p_ref_cd_rec.description IS NULL THEN
7849: p_ref_cd_rec.description := l_c_req.reference_code_desc;
7850: ELSIF p_ref_cd_rec.description = FND_API.G_MISS_CHAR THEN
7851: p_ref_cd_rec.description := NULL;
7852: END IF;
7853: END IF;
7854: RETURN 'U';

Line 7869: ELSIF p_ref_cd_rec.description = FND_API.G_MISS_CHAR THEN

7865: CLOSE c_occr;
7866: IF l_c_occr.restricted_flag = 'N' THEN
7867: IF p_ref_cd_rec.description IS NULL THEN
7868: p_ref_cd_rec.description := l_c_occr.reference_code_desc;
7869: ELSIF p_ref_cd_rec.description = FND_API.G_MISS_CHAR THEN
7870: p_ref_cd_rec.description := NULL;
7871: END IF;
7872: END IF;
7873: RETURN 'U';

Line 8360: IF p_uso_ins_rec.instructor_person_number IS NULL OR p_uso_ins_rec.instructor_person_number = FND_API.G_MISS_CHAR THEN

8356: BEGIN
8357: p_uso_ins_rec.status:='S';
8358:
8359: -- Checking for the mandatory existence of Unit Code, verison number, instructor person number parameter in the record.
8360: IF p_uso_ins_rec.instructor_person_number IS NULL OR p_uso_ins_rec.instructor_person_number = FND_API.G_MISS_CHAR THEN
8361: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8362: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8363: p_uso_ins_rec.status := 'E';
8364: END IF;

Line 8366: IF p_uso_ins_rec.unit_cd IS NULL OR p_uso_ins_rec.unit_cd = FND_API.G_MISS_CHAR THEN

8362: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8363: p_uso_ins_rec.status := 'E';
8364: END IF;
8365:
8366: IF p_uso_ins_rec.unit_cd IS NULL OR p_uso_ins_rec.unit_cd = FND_API.G_MISS_CHAR THEN
8367: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','UNIT_CD','LEGACY_TOKENS',FALSE);
8368: p_uso_ins_rec.status := 'E';
8369: END IF;
8370:

Line 8371: IF p_uso_ins_rec.version_number IS NULL OR p_uso_ins_rec.version_number = FND_API.G_MISS_NUM THEN

8367: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','UNIT_CD','LEGACY_TOKENS',FALSE);
8368: p_uso_ins_rec.status := 'E';
8369: END IF;
8370:
8371: IF p_uso_ins_rec.version_number IS NULL OR p_uso_ins_rec.version_number = FND_API.G_MISS_NUM THEN
8372: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','UNIT_VER_NUM','LEGACY_TOKENS',FALSE);
8373: p_uso_ins_rec.status := 'E';
8374: END IF;
8375:

Line 8378: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN

8374: END IF;
8375:
8376: -- if the production USO id is not provided then Teching calendar alternate code, location code and
8377: -- unit class are required.
8378: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8379: IF p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
8380: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS',FALSE);
8381: p_uso_ins_rec.status := 'E';
8382: END IF;

Line 8379: IF p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

8375:
8376: -- if the production USO id is not provided then Teching calendar alternate code, location code and
8377: -- unit class are required.
8378: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8379: IF p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
8380: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS',FALSE);
8381: p_uso_ins_rec.status := 'E';
8382: END IF;
8383: IF p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR THEN

Line 8383: IF p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR THEN

8379: IF p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
8380: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS',FALSE);
8381: p_uso_ins_rec.status := 'E';
8382: END IF;
8383: IF p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR THEN
8384: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD','LEGACY_TOKENS',FALSE);
8385: p_uso_ins_rec.status := 'E';
8386: END IF;
8387: IF p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR THEN

Line 8387: IF p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR THEN

8383: IF p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR THEN
8384: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'LOCATION_CD','LEGACY_TOKENS',FALSE);
8385: p_uso_ins_rec.status := 'E';
8386: END IF;
8387: IF p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR THEN
8388: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','UNIT_CLASS','LEGACY_TOKENS',FALSE);
8389: p_uso_ins_rec.status := 'E';
8390: END IF;
8391: END IF;

Line 8393: IF (p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR ) AND

8389: p_uso_ins_rec.status := 'E';
8390: END IF;
8391: END IF;
8392:
8393: IF (p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR ) AND
8394: (p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR ) AND
8395: (p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR) THEN
8396: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8397: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');

Line 8394: (p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR ) AND

8390: END IF;
8391: END IF;
8392:
8393: IF (p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR ) AND
8394: (p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR ) AND
8395: (p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR) THEN
8396: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8397: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');
8398: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);

Line 8395: (p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR) THEN

8391: END IF;
8392:
8393: IF (p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR ) AND
8394: (p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR ) AND
8395: (p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR) THEN
8396: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8397: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');
8398: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8399: p_uso_ins_rec.status := 'E';

Line 8396: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN

8392:
8393: IF (p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR ) AND
8394: (p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR ) AND
8395: (p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR) THEN
8396: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8397: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');
8398: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8399: p_uso_ins_rec.status := 'E';
8400: END IF;

Line 8403: IF (p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM ) AND

8399: p_uso_ins_rec.status := 'E';
8400: END IF;
8401: END IF;
8402:
8403: IF (p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM ) AND
8404: (p_uso_ins_rec.occurrence_identifier IS NULL OR p_uso_ins_rec.occurrence_identifier = FND_API.G_MISS_CHAR) THEN
8405: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS', FALSE);
8406: p_uso_ins_rec.status := 'E';
8407: END IF;

Line 8404: (p_uso_ins_rec.occurrence_identifier IS NULL OR p_uso_ins_rec.occurrence_identifier = FND_API.G_MISS_CHAR) THEN

8400: END IF;
8401: END IF;
8402:
8403: IF (p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM ) AND
8404: (p_uso_ins_rec.occurrence_identifier IS NULL OR p_uso_ins_rec.occurrence_identifier = FND_API.G_MISS_CHAR) THEN
8405: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS', FALSE);
8406: p_uso_ins_rec.status := 'E';
8407: END IF;
8408: