DBA Data[Home] [Help]

APPS.PQP_PL_VEHICLE_ALLOCATIONS dependencies on HR_UTILITY

Line 40: hr_utility.set_message(800,'HR_375879_PL_MILEAGE_LMT_LAW');

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

Line 41: hr_utility.raise_error;

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');

Line 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');

Line 46: 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');
50: hr_utility.raise_error;

Line 49: hr_utility.set_message(800,'HR_375881_PL_EMP_LIMIT');

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

Line 50: hr_utility.raise_error;

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

Line 57: hr_utility.set_message(800,'HR_375838_VAL_PL_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;

Line 59: hr_utility.raise_error;

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:

Line 93: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

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:

Line 94: hr_utility.trace('PL not installed.Leaving CREATE_PL_VEHICLE_ALLOCATION');

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

Line 136: IF NOT hr_utility.chk_product_install('Oracle Human Resources', '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:

Line 137: hr_utility.trace('PL not installed.Leaving UPDATE_PL_VEHICLE_ALLOCATION');

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

Line 199: IF NOT hr_utility.chk_product_install('Oracle Human Resources', '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:

Line 200: hr_utility.trace('PL not installed.Leaving DELETE_PL_VEHICLE_ALLOCATION');

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;