24: close csr_veh_ownership_type;
25:
26: If l_vehicle_ownership = 'C' then
27: If P_USAGE_TYPE is null then
28: hr_utility.set_message(8303,'PQP_GB_230619_USAGE_TYPE_MAND');
29: hr_utility.raise_error;
30: End if;
31: End if;
32:
25:
26: If l_vehicle_ownership = 'C' then
27: If P_USAGE_TYPE is null then
28: hr_utility.set_message(8303,'PQP_GB_230619_USAGE_TYPE_MAND');
29: hr_utility.raise_error;
30: End if;
31: End if;
32:
33: /* Added below two errors for the bug 10020963 */
31: End if;
32:
33: /* Added below two errors for the bug 10020963 */
34: If (P_PRIVATE_CONTRIBUTION <> hr_api.g_number and P_PRIVATE_CONTRIBUTION <> 0 and P_PRIVATE_CONTRIBUTION < 0) then
35: hr_utility.set_message(8303,'PQP_GB_230252_PVT_CONTRIB_NEG');
36: hr_utility.raise_error;
37: End if;
38:
39: If (P_CAPITAL_CONTRIBUTION <> hr_api.g_number and P_CAPITAL_CONTRIBUTION <> 0 and P_CAPITAL_CONTRIBUTION < 0) then
32:
33: /* Added below two errors for the bug 10020963 */
34: If (P_PRIVATE_CONTRIBUTION <> hr_api.g_number and P_PRIVATE_CONTRIBUTION <> 0 and P_PRIVATE_CONTRIBUTION < 0) then
35: hr_utility.set_message(8303,'PQP_GB_230252_PVT_CONTRIB_NEG');
36: hr_utility.raise_error;
37: End if;
38:
39: If (P_CAPITAL_CONTRIBUTION <> hr_api.g_number and P_CAPITAL_CONTRIBUTION <> 0 and P_CAPITAL_CONTRIBUTION < 0) then
40: hr_utility.set_message(8303,'PQP_GB_230253_CAP_CONTRIB_NEG');
36: hr_utility.raise_error;
37: End if;
38:
39: If (P_CAPITAL_CONTRIBUTION <> hr_api.g_number and P_CAPITAL_CONTRIBUTION <> 0 and P_CAPITAL_CONTRIBUTION < 0) then
40: hr_utility.set_message(8303,'PQP_GB_230253_CAP_CONTRIB_NEG');
41: hr_utility.raise_error;
42: End if;
43:
44: END GB_VALIDATE_USAGE_TYPE;
37: End if;
38:
39: If (P_CAPITAL_CONTRIBUTION <> hr_api.g_number and P_CAPITAL_CONTRIBUTION <> 0 and P_CAPITAL_CONTRIBUTION < 0) then
40: hr_utility.set_message(8303,'PQP_GB_230253_CAP_CONTRIB_NEG');
41: hr_utility.raise_error;
42: End if;
43:
44: END GB_VALIDATE_USAGE_TYPE;
45: