36:
37: If l_vehicle_ownership = 'PL_PC' and l_vehicle_type <> 'PL_T' then
38:
39: If p_val_information2 is null then
40: hr_utility.set_message(800,'HR_375879_PL_MILEAGE_LMT_LAW');
41: hr_utility.raise_error;
42: End if;
43:
44: If p_val_information3 is null then
37: If l_vehicle_ownership = 'PL_PC' and l_vehicle_type <> 'PL_T' then
38:
39: If p_val_information2 is null then
40: hr_utility.set_message(800,'HR_375879_PL_MILEAGE_LMT_LAW');
41: hr_utility.raise_error;
42: End if;
43:
44: If p_val_information3 is null then
45: hr_utility.set_message(800,'HR_375880_PL_MILEAGE_LMT_EMP');
41: hr_utility.raise_error;
42: End if;
43:
44: If p_val_information3 is null then
45: hr_utility.set_message(800,'HR_375880_PL_MILEAGE_LMT_EMP');
46: hr_utility.raise_error;
47: End if;
48: If p_val_information3 < l_mileage_value then
49: hr_utility.set_message(800,'HR_375881_PL_EMP_LIMIT');
42: End if;
43:
44: If p_val_information3 is null then
45: hr_utility.set_message(800,'HR_375880_PL_MILEAGE_LMT_EMP');
46: hr_utility.raise_error;
47: End if;
48: If p_val_information3 < l_mileage_value then
49: hr_utility.set_message(800,'HR_375881_PL_EMP_LIMIT');
50: hr_utility.raise_error;
45: hr_utility.set_message(800,'HR_375880_PL_MILEAGE_LMT_EMP');
46: hr_utility.raise_error;
47: End if;
48: If p_val_information3 < l_mileage_value then
49: hr_utility.set_message(800,'HR_375881_PL_EMP_LIMIT');
50: hr_utility.raise_error;
51: End if;
52: End if;
53: If l_vehicle_type = 'PL_T' then
46: hr_utility.raise_error;
47: End if;
48: If p_val_information3 < l_mileage_value then
49: hr_utility.set_message(800,'HR_375881_PL_EMP_LIMIT');
50: hr_utility.raise_error;
51: End if;
52: End if;
53: If l_vehicle_type = 'PL_T' then
54: -- Check for Vehicle type Truck
53: If l_vehicle_type = 'PL_T' then
54: -- Check for Vehicle type Truck
55: If p_val_information2 is not null or p_val_information3 is not null then
56: -- Check the value is null for Truck
57: hr_utility.set_message(800,'HR_375838_VAL_PL_TRUCK');
58: --Monthly mileage limit is not applicable to trucks. Ensure that you do not specify a monthly mileage limit for a truck.
59: hr_utility.raise_error;
60: End if;
61: End if;
55: If p_val_information2 is not null or p_val_information3 is not null then
56: -- Check the value is null for Truck
57: hr_utility.set_message(800,'HR_375838_VAL_PL_TRUCK');
58: --Monthly mileage limit is not applicable to trucks. Ensure that you do not specify a monthly mileage limit for a truck.
59: hr_utility.raise_error;
60: End if;
61: End if;
62: END PL_VALIDATE_ALLOCATION;
63:
89:
90: Begin
91:
92: /* Added for GSI Bug 5472781 */
93: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
94: hr_utility.trace('PL not installed.Leaving CREATE_PL_VEHICLE_ALLOCATION');
95: return;
96: END IF;
97:
90: Begin
91:
92: /* Added for GSI Bug 5472781 */
93: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
94: hr_utility.trace('PL not installed.Leaving CREATE_PL_VEHICLE_ALLOCATION');
95: return;
96: END IF;
97:
98: If p_val_information_category = 'PL' then
132: ,p_val_information20 in varchar2) IS
133:
134: BEGIN
135: /* Added for GSI Bug 5472781 */
136: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
137: hr_utility.trace('PL not installed.Leaving UPDATE_PL_VEHICLE_ALLOCATION');
138: return;
139: END IF;
140:
133:
134: BEGIN
135: /* Added for GSI Bug 5472781 */
136: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
137: hr_utility.trace('PL not installed.Leaving UPDATE_PL_VEHICLE_ALLOCATION');
138: return;
139: END IF;
140:
141: If p_val_information_category = 'PL' then
195:
196: BEGIN
197:
198: /* Added for GSI Bug 5472781 */
199: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
200: hr_utility.trace('PL not installed.Leaving DELETE_PL_VEHICLE_ALLOCATION');
201: return;
202: END IF;
203:
196: BEGIN
197:
198: /* Added for GSI Bug 5472781 */
199: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
200: hr_utility.trace('PL not installed.Leaving DELETE_PL_VEHICLE_ALLOCATION');
201: return;
202: END IF;
203:
204: open csr_element_entry;