APPS.PQP_PL_VEH_REPOS_EXTRA_INFO dependencies on FND_DATE

Line 63: If fnd_date.canonical_to_date(p_vrei_information1) < l_effective_start_date or fnd_date.canonical_to_date(p_vrei_information1) > l_effective_end_date Then

59:
60: If p_vrei_information_category in ('PL_VEHICLE_INSURANCE_INFO','PL_VEHICLE_ACCIDENT_INFO','PL_VEHICLE_ADDITIONAL_INFO') Then
61: Open cur_eff;
62: fetch cur_eff into l_effective_start_date, l_effective_end_date;
63: If fnd_date.canonical_to_date(p_vrei_information1) < l_effective_start_date or fnd_date.canonical_to_date(p_vrei_information1) > l_effective_end_date Then
64: close cur_eff;
65:
66: hr_utility.set_message(800,'HR_375832_VRE_PL_EFF_DATE');
67: hr_utility.set_message_token('STARTDATE',l_effective_start_date);

Line 134: If fnd_date.canonical_to_date(p_vrei_information1) < l_effective_start_date or fnd_date.canonical_to_date(p_vrei_information1) > l_effective_end_date Then

130:
131: If p_vrei_information_category in ('PL_VEHICLE_INSURANCE_INFO','PL_VEHICLE_ACCIDENT_INFO','PL_VEHICLE_ADDITIONAL_INFO') Then
132: Open cur_eff;
133: fetch cur_eff into l_effective_start_date, l_effective_end_date;
134: If fnd_date.canonical_to_date(p_vrei_information1) < l_effective_start_date or fnd_date.canonical_to_date(p_vrei_information1) > l_effective_end_date Then
135: close cur_eff;
136: hr_utility.set_message(800,'HR_375832_VRE_PL_EFF_DATE');
137: hr_utility.set_message_token('STARTDATE',l_effective_start_date);
138: hr_utility.set_message_token('ENDDATE',l_effective_end_date);