DBA Data[Home] [Help]

APPS.PQP_PVD_BUS dependencies on FND_MESSAGE

Line 59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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;

Line 60: fnd_message.raise_error;

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: --

Line 132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 133: fnd_message.raise_error;

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

Line 467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 468: fnd_message.set_token('PROCEDURE ', l_proc);

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: --

Line 469: fnd_message.set_token('STEP ', '5');

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

Line 470: fnd_message.raise_error;

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.

Line 506: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );

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:

Line 507: fnd_message.set_token('COLUMN','FUEL_TYPE' );

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;

Line 508: fnd_message.set_token('LOOKUP_TYPE', 'PQP_FUEL_TYPE' );

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:

Line 509: fnd_message.raise_error;

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:

Line 531: fnd_message.set_name('PQP','PQP_230521_INVALID_VEH_OWNSHP');

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;

Line 532: fnd_message.raise_error;

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:

Line 562: fnd_message.set_name('PQP','PQP_230522_ASSIGNMENT_EXISTS' );

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:

Line 563: fnd_message.raise_error;

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;

Line 590: fnd_message.set_name('PQP','PQP_230520_CUR_CODE_MISMATCH' );

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;

Line 591: fnd_message.raise_error;

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:

Line 617: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP' );

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:

Line 618: fnd_message.set_token('COLUMN','VEHICLE_TYPE' );

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;

Line 619: fnd_message.set_token('LOOKUP_TYPE', 'PQP_VEHICLE_TYPE' );

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:

Line 620: fnd_message.raise_error;

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:

Line 638: fnd_message.set_name ('PAY','HR_7355_PPM_AMOUNT_NEGATIVE' );

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:

Line 639: fnd_message.set_token('ERROR','Value Cannot Be Negative');

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;

Line 640: fnd_message.raise_error;

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: --