55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
463: IF NOT pqp_pvd_shd.api_updating
464: (p_vehicle_details_id => p_rec.vehicle_details_id
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
464: (p_vehicle_details_id => p_rec.vehicle_details_id
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
472: --
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
472: --
473: -- EDIT_HERE: Add checks to ensure non-updateable args have
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
472: --
473: -- EDIT_HERE: Add checks to ensure non-updateable args have
474: -- not been updated.
502: p_effective_date => p_effective_date ) THEN
503:
504: -- Raise error as the value does not exist as a lookup
505:
506: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
507: fnd_message.set_token('COLUMN','FUEL_TYPE' );
508: fnd_message.set_token('LOOKUP_TYPE', 'PQP_FUEL_TYPE' );
509: fnd_message.raise_error;
510:
503:
504: -- Raise error as the value does not exist as a lookup
505:
506: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
507: fnd_message.set_token('COLUMN','FUEL_TYPE' );
508: fnd_message.set_token('LOOKUP_TYPE', 'PQP_FUEL_TYPE' );
509: fnd_message.raise_error;
510:
511: END IF;
504: -- Raise error as the value does not exist as a lookup
505:
506: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
507: fnd_message.set_token('COLUMN','FUEL_TYPE' );
508: fnd_message.set_token('LOOKUP_TYPE', 'PQP_FUEL_TYPE' );
509: fnd_message.raise_error;
510:
511: END IF;
512:
505:
506: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
507: fnd_message.set_token('COLUMN','FUEL_TYPE' );
508: fnd_message.set_token('LOOKUP_TYPE', 'PQP_FUEL_TYPE' );
509: fnd_message.raise_error;
510:
511: END IF;
512:
513:
527: hr_utility.set_location('Entering:'||l_proc, 5);
528:
529: IF p_vehicle_ownership NOT IN ('COMPANY','PRIVATE') THEN
530: -- Raise error as the allowed values are company,private and NULL
531: fnd_message.set_name('PQP','PQP_230521_INVALID_VEH_OWNSHP');
532: fnd_message.raise_error;
533: END IF;
534:
535: END check_vehicle_ownership;
528:
529: IF p_vehicle_ownership NOT IN ('COMPANY','PRIVATE') THEN
530: -- Raise error as the allowed values are company,private and NULL
531: fnd_message.set_name('PQP','PQP_230521_INVALID_VEH_OWNSHP');
532: fnd_message.raise_error;
533: END IF;
534:
535: END check_vehicle_ownership;
536:
558: IF veh_cur%FOUND THEN
559: -- Raise error as there is an assignment for the vehicle
560: -- that is being deleted
561: CLOSE veh_cur;
562: fnd_message.set_name('PQP','PQP_230522_ASSIGNMENT_EXISTS' );
563: fnd_message.raise_error;
564: END IF;
565: CLOSE veh_cur;
566:
559: -- Raise error as there is an assignment for the vehicle
560: -- that is being deleted
561: CLOSE veh_cur;
562: fnd_message.set_name('PQP','PQP_230522_ASSIGNMENT_EXISTS' );
563: fnd_message.raise_error;
564: END IF;
565: CLOSE veh_cur;
566:
567: END check_assignment_exists;
586:
587: IF p_currency_code <> l_default_currency_code THEN
588: -- Raise error as the input currency code is not equal
589: -- to the default currency for the BG
590: fnd_message.set_name('PQP','PQP_230520_CUR_CODE_MISMATCH' );
591: fnd_message.raise_error;
592: END IF;
593:
594: END check_currency_code;
587: IF p_currency_code <> l_default_currency_code THEN
588: -- Raise error as the input currency code is not equal
589: -- to the default currency for the BG
590: fnd_message.set_name('PQP','PQP_230520_CUR_CODE_MISMATCH' );
591: fnd_message.raise_error;
592: END IF;
593:
594: END check_currency_code;
595:
613: p_effective_date => p_effective_date ) THEN
614:
615: -- Raise error as the value does not exist as a lookup
616:
617: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
618: fnd_message.set_token('COLUMN','VEHICLE_TYPE' );
619: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VEHICLE_TYPE' );
620: fnd_message.raise_error;
621:
614:
615: -- Raise error as the value does not exist as a lookup
616:
617: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
618: fnd_message.set_token('COLUMN','VEHICLE_TYPE' );
619: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VEHICLE_TYPE' );
620: fnd_message.raise_error;
621:
622: END IF;
615: -- Raise error as the value does not exist as a lookup
616:
617: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
618: fnd_message.set_token('COLUMN','VEHICLE_TYPE' );
619: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VEHICLE_TYPE' );
620: fnd_message.raise_error;
621:
622: END IF;
623:
616:
617: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );
618: fnd_message.set_token('COLUMN','VEHICLE_TYPE' );
619: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VEHICLE_TYPE' );
620: fnd_message.raise_error;
621:
622: END IF;
623:
624:
634: BEGIN
635:
636: hr_utility.set_location('Entering:'||l_proc, 5);
637: IF p_number_to_check < 0 THEN
638: fnd_message.set_name ('PAY','HR_7355_PPM_AMOUNT_NEGATIVE' );
639: fnd_message.set_token('ERROR','Value Cannot Be Negative');
640: fnd_message.raise_error;
641: END IF;
642:
635:
636: hr_utility.set_location('Entering:'||l_proc, 5);
637: IF p_number_to_check < 0 THEN
638: fnd_message.set_name ('PAY','HR_7355_PPM_AMOUNT_NEGATIVE' );
639: fnd_message.set_token('ERROR','Value Cannot Be Negative');
640: fnd_message.raise_error;
641: END IF;
642:
643: END check_negative;
636: hr_utility.set_location('Entering:'||l_proc, 5);
637: IF p_number_to_check < 0 THEN
638: fnd_message.set_name ('PAY','HR_7355_PPM_AMOUNT_NEGATIVE' );
639: fnd_message.set_token('ERROR','Value Cannot Be Negative');
640: fnd_message.raise_error;
641: END IF;
642:
643: END check_negative;
644: --