eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_VRE_BUS dependencies on FND_MESSAGE

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

59: CLOSE csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'VEHICLE_REPOSITORY_ID')
67: );

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

141: --
142: -- The primary key is invalid therefore we must error
143: --
144: CLOSE csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: END IF;
148: hr_utility.set_location(l_proc,30);
149: --

Line 146: fnd_message.raise_error;

142: -- The primary key is invalid therefore we must error
143: --
144: CLOSE csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: END IF;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are

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

475: (p_vehicle_repository_id => p_rec.vehicle_repository_id
476: ,p_effective_date => p_effective_date
477: ,p_object_version_number => p_rec.object_version_number
478: ) THEN
479: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
480: fnd_message.set_token('PROCEDURE ', l_proc);
481: fnd_message.set_token('STEP ', '5');
482: fnd_message.raise_error;
483: END IF;

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

476: ,p_effective_date => p_effective_date
477: ,p_object_version_number => p_rec.object_version_number
478: ) THEN
479: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
480: fnd_message.set_token('PROCEDURE ', l_proc);
481: fnd_message.set_token('STEP ', '5');
482: fnd_message.raise_error;
483: END IF;
484: --

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

477: ,p_object_version_number => p_rec.object_version_number
478: ) THEN
479: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
480: fnd_message.set_token('PROCEDURE ', l_proc);
481: fnd_message.set_token('STEP ', '5');
482: fnd_message.raise_error;
483: END IF;
484: --
485: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 482: fnd_message.raise_error;

478: ) THEN
479: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
480: fnd_message.set_token('PROCEDURE ', l_proc);
481: fnd_message.set_token('STEP ', '5');
482: fnd_message.raise_error;
483: END IF;
484: --
485: -- EDIT_HERE: Add checks to ensure non-updateable args have
486: -- not been updated.

Line 561: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

557: --
558: -- An unhandled or unexpected error has occurred which
559: -- we must report
560: --
561: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
562: fnd_message.set_token('PROCEDURE', l_proc);
563: fnd_message.set_token('STEP','15');
564: fnd_message.raise_error;
565: END dt_update_validate;

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

558: -- An unhandled or unexpected error has occurred which
559: -- we must report
560: --
561: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
562: fnd_message.set_token('PROCEDURE', l_proc);
563: fnd_message.set_token('STEP','15');
564: fnd_message.raise_error;
565: END dt_update_validate;
566: --

Line 563: fnd_message.set_token('STEP','15');

559: -- we must report
560: --
561: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
562: fnd_message.set_token('PROCEDURE', l_proc);
563: fnd_message.set_token('STEP','15');
564: fnd_message.raise_error;
565: END dt_update_validate;
566: --
567: -- ----------------------------------------------------------------------------

Line 564: fnd_message.raise_error;

560: --
561: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
562: fnd_message.set_token('PROCEDURE', l_proc);
563: fnd_message.set_token('STEP','15');
564: fnd_message.raise_error;
565: END dt_update_validate;
566: --
567: -- ----------------------------------------------------------------------------
568: -- |--------------------------< dt_delete_validate >--------------------------|

Line 658: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

654: --
655: -- An unhandled or unexpected error has occurred which
656: -- we must report
657: --
658: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
659: fnd_message.set_token('PROCEDURE', l_proc);
660: fnd_message.set_token('STEP','15');
661: fnd_message.raise_error;
662: --

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

655: -- An unhandled or unexpected error has occurred which
656: -- we must report
657: --
658: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
659: fnd_message.set_token('PROCEDURE', l_proc);
660: fnd_message.set_token('STEP','15');
661: fnd_message.raise_error;
662: --
663: END dt_delete_validate;

Line 660: fnd_message.set_token('STEP','15');

656: -- we must report
657: --
658: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
659: fnd_message.set_token('PROCEDURE', l_proc);
660: fnd_message.set_token('STEP','15');
661: fnd_message.raise_error;
662: --
663: END dt_delete_validate;
664: --

Line 661: fnd_message.raise_error;

657: --
658: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
659: fnd_message.set_token('PROCEDURE', l_proc);
660: fnd_message.set_token('STEP','15');
661: fnd_message.raise_error;
662: --
663: END dt_delete_validate;
664: --
665: -- ----------------------------------------------------------------------------

Line 713: fnd_message.set_name('PQP','PQP_230150_INDEN_EXISTS');

709: OPEN c_iden_exist_cursor;
710: FETCH c_iden_exist_cursor INTO l_count;
711: CLOSE c_iden_exist_cursor;
712: IF l_count>0 THEN
713: fnd_message.set_name('PQP','PQP_230150_INDEN_EXISTS');
714: fnd_message.raise_error;
715: END IF;
716: END IF;
717: ELSE

Line 714: fnd_message.raise_error;

710: FETCH c_iden_exist_cursor INTO l_count;
711: CLOSE c_iden_exist_cursor;
712: IF l_count>0 THEN
713: fnd_message.set_name('PQP','PQP_230150_INDEN_EXISTS');
714: fnd_message.raise_error;
715: END IF;
716: END IF;
717: ELSE
718: OPEN c_iden_exist_cursor;

Line 722: fnd_message.set_name('PQP','PQP_230150_INDEN_EXISTS');

718: OPEN c_iden_exist_cursor;
719: FETCH c_iden_exist_cursor INTO l_count;
720: CLOSE c_iden_exist_cursor;
721: IF l_count>0 THEN
722: fnd_message.set_name('PQP','PQP_230150_INDEN_EXISTS');
723: fnd_message.raise_error;
724: END IF;
725: END IF;
726: EXCEPTION

Line 723: fnd_message.raise_error;

719: FETCH c_iden_exist_cursor INTO l_count;
720: CLOSE c_iden_exist_cursor;
721: IF l_count>0 THEN
722: fnd_message.set_name('PQP','PQP_230150_INDEN_EXISTS');
723: fnd_message.raise_error;
724: END IF;
725: END IF;
726: EXCEPTION
727: --------

Line 762: fnd_message.set_name('PQP','PQP_230728_VEH_EXISTS');

758: OPEN reg_exist_cursor;
759: FETCH reg_exist_cursor INTO l_count;
760: CLOSE reg_exist_cursor;
761: IF l_count>0 THEN
762: fnd_message.set_name('PQP','PQP_230728_VEH_EXISTS');
763: fnd_message.raise_error;
764: END IF;
765: EXCEPTION
766: --------

Line 763: fnd_message.raise_error;

759: FETCH reg_exist_cursor INTO l_count;
760: CLOSE reg_exist_cursor;
761: IF l_count>0 THEN
762: fnd_message.set_name('PQP','PQP_230728_VEH_EXISTS');
763: fnd_message.raise_error;
764: END IF;
765: EXCEPTION
766: --------
767: WHEN no_data_found THEN

Line 1065: fnd_message.set_name('PQP', 'PQP_230727_REGNUM_UPD_RSTRICT');

1061: ,p_validation_end_date in date
1062: ) IS
1063: BEGIN
1064: IF p_rec.registration_number<> pqp_vre_shd.g_old_rec.registration_number THEN
1065: fnd_message.set_name('PQP', 'PQP_230727_REGNUM_UPD_RSTRICT');
1066: fnd_message.raise_error;
1067: END IF;
1068: END;
1069: --

Line 1066: fnd_message.raise_error;

1062: ) IS
1063: BEGIN
1064: IF p_rec.registration_number<> pqp_vre_shd.g_old_rec.registration_number THEN
1065: fnd_message.set_name('PQP', 'PQP_230727_REGNUM_UPD_RSTRICT');
1066: fnd_message.raise_error;
1067: END IF;
1068: END;
1069: --
1070: ---------------------------------------------------------------------------

Line 1531: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1527: ,p_argument_value =>p_rec.registration_number
1528: ,p_message =>l_message);
1529:
1530: IF l_return_status = -1 THEN
1531: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1532: fnd_message.set_token('FEILD','Model');
1533: fnd_message.raise_error;
1534: END IF;
1535: -- Added by gattu for phase 2

Line 1532: fnd_message.set_token('FEILD','Model');

1528: ,p_message =>l_message);
1529:
1530: IF l_return_status = -1 THEN
1531: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1532: fnd_message.set_token('FEILD','Model');
1533: fnd_message.raise_error;
1534: END IF;
1535: -- Added by gattu for phase 2
1536: IF p_rec.vehicle_ownership in ('C','PL_LEC','PL_LC') THEN

Line 1533: fnd_message.raise_error;

1529:
1530: IF l_return_status = -1 THEN
1531: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1532: fnd_message.set_token('FEILD','Model');
1533: fnd_message.raise_error;
1534: END IF;
1535: -- Added by gattu for phase 2
1536: IF p_rec.vehicle_ownership in ('C','PL_LEC','PL_LC') THEN
1537: --Added to check the listprice is mandatory for Irish leg

Line 1545: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1541: ,p_argument_value =>p_rec.list_price
1542: ,p_message =>l_message);
1543:
1544: IF l_return_status = -1 THEN
1545: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1546: fnd_message.set_token('FEILD','List Price');
1547: fnd_message.raise_error;
1548: END IF;
1549: END IF;

Line 1546: fnd_message.set_token('FEILD','List Price');

1542: ,p_message =>l_message);
1543:
1544: IF l_return_status = -1 THEN
1545: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1546: fnd_message.set_token('FEILD','List Price');
1547: fnd_message.raise_error;
1548: END IF;
1549: END IF;
1550:

Line 1547: fnd_message.raise_error;

1543:
1544: IF l_return_status = -1 THEN
1545: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1546: fnd_message.set_token('FEILD','List Price');
1547: fnd_message.raise_error;
1548: END IF;
1549: END IF;
1550:
1551: --Taxation Method is Mandatory for German Leg and should have values

Line 1560: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1556: ,p_argument_value =>p_rec.taxation_method
1557: ,p_message =>l_message);
1558:
1559: IF l_return_status = -1 THEN
1560: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1561: fnd_message.set_token('FEILD','Taxation Method');
1562: fnd_message.raise_error;
1563: END IF;
1564: --If taxation method value exist then check for value validation for german

Line 1561: fnd_message.set_token('FEILD','Taxation Method');

1557: ,p_message =>l_message);
1558:
1559: IF l_return_status = -1 THEN
1560: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1561: fnd_message.set_token('FEILD','Taxation Method');
1562: fnd_message.raise_error;
1563: END IF;
1564: --If taxation method value exist then check for value validation for german
1565: l_return_status := chk_lookup(

Line 1562: fnd_message.raise_error;

1558:
1559: IF l_return_status = -1 THEN
1560: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1561: fnd_message.set_token('FEILD','Taxation Method');
1562: fnd_message.raise_error;
1563: END IF;
1564: --If taxation method value exist then check for value validation for german
1565: l_return_status := chk_lookup(
1566: p_vehicle_repository_id => p_rec.vehicle_repository_id

Line 1574: fnd_message.set_name('PQP','PQP_230114_VLD_TAXATION_CDE');

1570: ,p_validation_start_date => p_validation_start_date
1571: ,p_validation_end_date => p_validation_end_date);
1572:
1573: IF l_return_status = -1 THEN
1574: fnd_message.set_name('PQP','PQP_230114_VLD_TAXATION_CDE');
1575: fnd_message.raise_error;
1576: END IF;
1577: END IF;
1578: END IF;

Line 1575: fnd_message.raise_error;

1571: ,p_validation_end_date => p_validation_end_date);
1572:
1573: IF l_return_status = -1 THEN
1574: fnd_message.set_name('PQP','PQP_230114_VLD_TAXATION_CDE');
1575: fnd_message.raise_error;
1576: END IF;
1577: END IF;
1578: END IF;
1579:

Line 1587: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1583: ,p_argument_value => p_rec.vehicle_ownership
1584: ,p_message => l_message);
1585:
1586: IF l_return_status = -1 THEN
1587: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1588: fnd_message.set_token('FEILD','Vehicle Ownership');
1589: fnd_message.raise_error;
1590: END IF;
1591:

Line 1588: fnd_message.set_token('FEILD','Vehicle Ownership');

1584: ,p_message => l_message);
1585:
1586: IF l_return_status = -1 THEN
1587: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1588: fnd_message.set_token('FEILD','Vehicle Ownership');
1589: fnd_message.raise_error;
1590: END IF;
1591:
1592: --Checking Vehicle Type Mandatory

Line 1589: fnd_message.raise_error;

1585:
1586: IF l_return_status = -1 THEN
1587: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1588: fnd_message.set_token('FEILD','Vehicle Ownership');
1589: fnd_message.raise_error;
1590: END IF;
1591:
1592: --Checking Vehicle Type Mandatory
1593: l_return_status := chk_mandatory(

Line 1598: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1594: p_argument =>'vehicle_type'
1595: ,p_argument_value => p_rec.vehicle_type
1596: ,p_message => l_message);
1597: IF l_return_status = -1 THEN
1598: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1599: fnd_message.set_token('FEILD','Vehicle Type');
1600: fnd_message.raise_error;
1601: END IF;
1602:

Line 1599: fnd_message.set_token('FEILD','Vehicle Type');

1595: ,p_argument_value => p_rec.vehicle_type
1596: ,p_message => l_message);
1597: IF l_return_status = -1 THEN
1598: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1599: fnd_message.set_token('FEILD','Vehicle Type');
1600: fnd_message.raise_error;
1601: END IF;
1602:
1603:

Line 1600: fnd_message.raise_error;

1596: ,p_message => l_message);
1597: IF l_return_status = -1 THEN
1598: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1599: fnd_message.set_token('FEILD','Vehicle Type');
1600: fnd_message.raise_error;
1601: END IF;
1602:
1603:
1604: --Checking Registration Number Mandatory

Line 1616: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1612: ,p_argument_value =>p_rec.registration_number
1613: ,p_message =>l_message);
1614:
1615: IF l_return_status = -1 THEN
1616: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1617: fnd_message.set_token('FEILD','Registration Number');
1618: fnd_message.raise_error;
1619: END IF;
1620: END IF;

Line 1617: fnd_message.set_token('FEILD','Registration Number');

1613: ,p_message =>l_message);
1614:
1615: IF l_return_status = -1 THEN
1616: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1617: fnd_message.set_token('FEILD','Registration Number');
1618: fnd_message.raise_error;
1619: END IF;
1620: END IF;
1621:

Line 1618: fnd_message.raise_error;

1614:
1615: IF l_return_status = -1 THEN
1616: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1617: fnd_message.set_token('FEILD','Registration Number');
1618: fnd_message.raise_error;
1619: END IF;
1620: END IF;
1621:
1622: --Checking Make Mandatory

Line 1628: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1624: p_argument =>'make'
1625: ,p_argument_value => p_rec.make
1626: ,p_message => l_message);
1627: IF l_return_status = -1 THEN
1628: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1629: fnd_message.set_token('FEILD','Make');
1630: fnd_message.raise_error;
1631: END IF;
1632:

Line 1629: fnd_message.set_token('FEILD','Make');

1625: ,p_argument_value => p_rec.make
1626: ,p_message => l_message);
1627: IF l_return_status = -1 THEN
1628: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1629: fnd_message.set_token('FEILD','Make');
1630: fnd_message.raise_error;
1631: END IF;
1632:
1633: --Checking Model Mandatory

Line 1630: fnd_message.raise_error;

1626: ,p_message => l_message);
1627: IF l_return_status = -1 THEN
1628: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1629: fnd_message.set_token('FEILD','Make');
1630: fnd_message.raise_error;
1631: END IF;
1632:
1633: --Checking Model Mandatory
1634: l_return_status := chk_mandatory(

Line 1639: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1635: p_argument =>'Model'
1636: ,p_argument_value => p_rec.model
1637: ,p_message => l_message);
1638: IF l_return_status = -1 THEN
1639: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1640: fnd_message.set_token('FEILD','Model');
1641: fnd_message.raise_error;
1642: END IF;
1643:

Line 1640: fnd_message.set_token('FEILD','Model');

1636: ,p_argument_value => p_rec.model
1637: ,p_message => l_message);
1638: IF l_return_status = -1 THEN
1639: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1640: fnd_message.set_token('FEILD','Model');
1641: fnd_message.raise_error;
1642: END IF;
1643:
1644: --Checking EngineCapacity Mandatory

Line 1641: fnd_message.raise_error;

1637: ,p_message => l_message);
1638: IF l_return_status = -1 THEN
1639: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1640: fnd_message.set_token('FEILD','Model');
1641: fnd_message.raise_error;
1642: END IF;
1643:
1644: --Checking EngineCapacity Mandatory
1645: IF l_legislation_code = 'GB' OR l_legislation_code = 'PL' THEN

Line 1651: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1647: p_argument =>'Engine Capacity'
1648: ,p_argument_value => p_rec.engine_capacity_in_cc
1649: ,p_message => l_message);
1650: IF l_return_status = -1 THEN
1651: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1652: fnd_message.set_token('FEILD','Engine Capacity');
1653: fnd_message.raise_error;
1654: END IF;
1655:

Line 1652: fnd_message.set_token('FEILD','Engine Capacity');

1648: ,p_argument_value => p_rec.engine_capacity_in_cc
1649: ,p_message => l_message);
1650: IF l_return_status = -1 THEN
1651: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1652: fnd_message.set_token('FEILD','Engine Capacity');
1653: fnd_message.raise_error;
1654: END IF;
1655:
1656: --Checking Fueltype Mandatory

Line 1653: fnd_message.raise_error;

1649: ,p_message => l_message);
1650: IF l_return_status = -1 THEN
1651: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1652: fnd_message.set_token('FEILD','Engine Capacity');
1653: fnd_message.raise_error;
1654: END IF;
1655:
1656: --Checking Fueltype Mandatory
1657: l_return_status := chk_mandatory(

Line 1662: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1658: p_argument =>'fuelType'
1659: ,p_argument_value => p_rec.fuel_type
1660: ,p_message => l_message);
1661: IF l_return_status = -1 THEN
1662: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1663: fnd_message.set_token('FEILD','Fuel Type');
1664: fnd_message.raise_error;
1665: END IF;
1666: END IF;

Line 1663: fnd_message.set_token('FEILD','Fuel Type');

1659: ,p_argument_value => p_rec.fuel_type
1660: ,p_message => l_message);
1661: IF l_return_status = -1 THEN
1662: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1663: fnd_message.set_token('FEILD','Fuel Type');
1664: fnd_message.raise_error;
1665: END IF;
1666: END IF;
1667: --Checking vehicleStatus Mandatory

Line 1664: fnd_message.raise_error;

1660: ,p_message => l_message);
1661: IF l_return_status = -1 THEN
1662: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1663: fnd_message.set_token('FEILD','Fuel Type');
1664: fnd_message.raise_error;
1665: END IF;
1666: END IF;
1667: --Checking vehicleStatus Mandatory
1668: l_return_status := chk_mandatory(

Line 1673: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1669: p_argument =>'VehicleStatus'
1670: ,p_argument_value => p_rec.vehicle_status
1671: ,p_message => l_message);
1672: IF l_return_status = -1 THEN
1673: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1674: fnd_message.set_token('FEILD','Vehicle Status');
1675: fnd_message.raise_error;
1676: END IF;
1677:

Line 1674: fnd_message.set_token('FEILD','Vehicle Status');

1670: ,p_argument_value => p_rec.vehicle_status
1671: ,p_message => l_message);
1672: IF l_return_status = -1 THEN
1673: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1674: fnd_message.set_token('FEILD','Vehicle Status');
1675: fnd_message.raise_error;
1676: END IF;
1677:
1678:

Line 1675: fnd_message.raise_error;

1671: ,p_message => l_message);
1672: IF l_return_status = -1 THEN
1673: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1674: fnd_message.set_token('FEILD','Vehicle Status');
1675: fnd_message.raise_error;
1676: END IF;
1677:
1678:
1679: --Checking Ownership lookup validation

Line 1689: fnd_message.set_name('PQP','PQP_230741_VLD_OWNRSHP_CDE');

1685: ,p_validation_start_date => p_validation_start_date
1686: ,p_validation_end_date => p_validation_end_date);
1687:
1688: IF l_return_status = -1 THEN
1689: fnd_message.set_name('PQP','PQP_230741_VLD_OWNRSHP_CDE');
1690: fnd_message.raise_error;
1691: END IF;
1692:
1693: --Checking vehicle_status lookup validation

Line 1690: fnd_message.raise_error;

1686: ,p_validation_end_date => p_validation_end_date);
1687:
1688: IF l_return_status = -1 THEN
1689: fnd_message.set_name('PQP','PQP_230741_VLD_OWNRSHP_CDE');
1690: fnd_message.raise_error;
1691: END IF;
1692:
1693: --Checking vehicle_status lookup validation
1694: l_return_status := chk_lookup(

Line 1703: fnd_message.set_name('PQP','PQP_230742_VLD_STATUS_CDE');

1699: ,p_validation_start_date => p_validation_start_date
1700: ,p_validation_end_date => p_validation_end_date);
1701:
1702: IF l_return_status = -1 THEN
1703: fnd_message.set_name('PQP','PQP_230742_VLD_STATUS_CDE');
1704: fnd_message.raise_error;
1705: END IF;
1706:
1707: --Checking Fuel Type lookup validation

Line 1704: fnd_message.raise_error;

1700: ,p_validation_end_date => p_validation_end_date);
1701:
1702: IF l_return_status = -1 THEN
1703: fnd_message.set_name('PQP','PQP_230742_VLD_STATUS_CDE');
1704: fnd_message.raise_error;
1705: END IF;
1706:
1707: --Checking Fuel Type lookup validation
1708: l_return_status := chk_lookup(

Line 1716: fnd_message.set_name('PQP','PQP_230743_VLD_FUEL_TYP');

1712: ,p_effective_date => p_effective_date
1713: ,p_validation_start_date => p_validation_start_date
1714: ,p_validation_end_date => p_validation_end_date);
1715: IF l_return_status = -1 THEN
1716: fnd_message.set_name('PQP','PQP_230743_VLD_FUEL_TYP');
1717: fnd_message.raise_error;
1718: END IF;
1719:
1720: --Checking Vehicle Type lookup validation

Line 1717: fnd_message.raise_error;

1713: ,p_validation_start_date => p_validation_start_date
1714: ,p_validation_end_date => p_validation_end_date);
1715: IF l_return_status = -1 THEN
1716: fnd_message.set_name('PQP','PQP_230743_VLD_FUEL_TYP');
1717: fnd_message.raise_error;
1718: END IF;
1719:
1720: --Checking Vehicle Type lookup validation
1721: l_return_status := chk_lookup(

Line 1729: fnd_message.set_name('PQP','PQP_230744_VLD_VEH_TYP');

1725: ,p_effective_date => p_effective_date
1726: ,p_validation_start_date => p_validation_start_date
1727: ,p_validation_end_date => p_validation_end_date);
1728: IF l_return_status = -1 THEN
1729: fnd_message.set_name('PQP','PQP_230744_VLD_VEH_TYP');
1730: fnd_message.raise_error;
1731: END IF;
1732:
1733: --Checking If Vehicle Status is Inactive then inactive reason with lookup

Line 1730: fnd_message.raise_error;

1726: ,p_validation_start_date => p_validation_start_date
1727: ,p_validation_end_date => p_validation_end_date);
1728: IF l_return_status = -1 THEN
1729: fnd_message.set_name('PQP','PQP_230744_VLD_VEH_TYP');
1730: fnd_message.raise_error;
1731: END IF;
1732:
1733: --Checking If Vehicle Status is Inactive then inactive reason with lookup
1734: IF p_rec.vehicle_status = 'I' THEN

Line 1744: fnd_message.set_name('PQP','PQP_230852_VEH_INACTIVE_REASON');

1740: ,p_effective_date => p_effective_date
1741: ,p_validation_start_date=> p_validation_start_date
1742: ,p_validation_end_date => p_validation_end_date);
1743: IF l_return_status = -1 THEN
1744: fnd_message.set_name('PQP','PQP_230852_VEH_INACTIVE_REASON');
1745: fnd_message.raise_error;
1746: END IF;
1747: ELSE
1748: --If vehicle status is active then Inactive Reason should be NULL

Line 1745: fnd_message.raise_error;

1741: ,p_validation_start_date=> p_validation_start_date
1742: ,p_validation_end_date => p_validation_end_date);
1743: IF l_return_status = -1 THEN
1744: fnd_message.set_name('PQP','PQP_230852_VEH_INACTIVE_REASON');
1745: fnd_message.raise_error;
1746: END IF;
1747: ELSE
1748: --If vehicle status is active then Inactive Reason should be NULL
1749: IF p_rec.vehicle_inactivity_reason IS NOT NULL THEN

Line 1750: fnd_message.set_name('PQP','PQP_230853_INACTIVE_REASON_ERR');

1746: END IF;
1747: ELSE
1748: --If vehicle status is active then Inactive Reason should be NULL
1749: IF p_rec.vehicle_inactivity_reason IS NOT NULL THEN
1750: fnd_message.set_name('PQP','PQP_230853_INACTIVE_REASON_ERR');
1751: fnd_message.raise_error;
1752: END IF;
1753: END IF;
1754:

Line 1751: fnd_message.raise_error;

1747: ELSE
1748: --If vehicle status is active then Inactive Reason should be NULL
1749: IF p_rec.vehicle_inactivity_reason IS NOT NULL THEN
1750: fnd_message.set_name('PQP','PQP_230853_INACTIVE_REASON_ERR');
1751: fnd_message.raise_error;
1752: END IF;
1753: END IF;
1754:
1755: --Checking the mandatory fields for company vehicle

Line 1764: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');

1760: ,p_argument_value =>p_rec.initial_registration
1761: ,p_message =>l_message);
1762:
1763: IF l_return_status = -1 THEN
1764: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
1765: fnd_message.set_token('TOKEN','Registration Number');
1766: fnd_message.raise_error;
1767: END IF;
1768: --Check for list_price

Line 1765: fnd_message.set_token('TOKEN','Registration Number');

1761: ,p_message =>l_message);
1762:
1763: IF l_return_status = -1 THEN
1764: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
1765: fnd_message.set_token('TOKEN','Registration Number');
1766: fnd_message.raise_error;
1767: END IF;
1768: --Check for list_price
1769: END IF;

Line 1766: fnd_message.raise_error;

1762:
1763: IF l_return_status = -1 THEN
1764: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
1765: fnd_message.set_token('TOKEN','Registration Number');
1766: fnd_message.raise_error;
1767: END IF;
1768: --Check for list_price
1769: END IF;
1770:

Line 1787: fnd_message.set_name('PQP','PQP_230720_COMP_CAR_NT_SHARED');

1783: --If configuration value is 'N' then user shouldnot select the checkbox
1784: --If user selects then raise error
1785: IF l_share_conf_value = 'N' THEN
1786: IF p_rec.shared_vehicle = 'Y' THEN
1787: fnd_message.set_name('PQP','PQP_230720_COMP_CAR_NT_SHARED');
1788: fnd_message.raise_error;
1789: END IF;
1790: END IF;
1791:

Line 1788: fnd_message.raise_error;

1784: --If user selects then raise error
1785: IF l_share_conf_value = 'N' THEN
1786: IF p_rec.shared_vehicle = 'Y' THEN
1787: fnd_message.set_name('PQP','PQP_230720_COMP_CAR_NT_SHARED');
1788: fnd_message.raise_error;
1789: END IF;
1790: END IF;
1791:
1792: ELSE

Line 1804: fnd_message.set_name('PQP', 'PQP_230721_PVT_CAR_NT_SHARED');

1800: hr_utility.set_location('Config pri veh share val:'||l_share_conf_value,40);
1801:
1802: IF l_share_conf_value = 'N' THEN
1803: IF p_rec.shared_vehicle = 'Y' THEN
1804: fnd_message.set_name('PQP', 'PQP_230721_PVT_CAR_NT_SHARED');
1805: fnd_message.raise_error;
1806: END IF;
1807: END IF;
1808: END IF;

Line 1805: fnd_message.raise_error;

1801:
1802: IF l_share_conf_value = 'N' THEN
1803: IF p_rec.shared_vehicle = 'Y' THEN
1804: fnd_message.set_name('PQP', 'PQP_230721_PVT_CAR_NT_SHARED');
1805: fnd_message.raise_error;
1806: END IF;
1807: END IF;
1808: END IF;
1809: --handling multiple messages

Line 1917: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1913: ,p_argument_value =>p_rec.list_price
1914: ,p_message =>l_message);
1915:
1916: IF l_return_status = -1 THEN
1917: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1918: fnd_message.set_token('FEILD','List Price');
1919: fnd_message.raise_error;
1920: END IF;
1921: END IF;

Line 1918: fnd_message.set_token('FEILD','List Price');

1914: ,p_message =>l_message);
1915:
1916: IF l_return_status = -1 THEN
1917: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1918: fnd_message.set_token('FEILD','List Price');
1919: fnd_message.raise_error;
1920: END IF;
1921: END IF;
1922:

Line 1919: fnd_message.raise_error;

1915:
1916: IF l_return_status = -1 THEN
1917: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1918: fnd_message.set_token('FEILD','List Price');
1919: fnd_message.raise_error;
1920: END IF;
1921: END IF;
1922:
1923: --Taxation Method is Mandatory for German Leg and should have values

Line 1932: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1928: ,p_argument_value =>p_rec.taxation_method
1929: ,p_message =>l_message);
1930:
1931: IF l_return_status = -1 THEN
1932: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1933: fnd_message.set_token('FEILD','Taxation Method');
1934: fnd_message.raise_error;
1935: END IF;
1936: --If taxation method value exist then check for value validation for german

Line 1933: fnd_message.set_token('FEILD','Taxation Method');

1929: ,p_message =>l_message);
1930:
1931: IF l_return_status = -1 THEN
1932: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1933: fnd_message.set_token('FEILD','Taxation Method');
1934: fnd_message.raise_error;
1935: END IF;
1936: --If taxation method value exist then check for value validation for german
1937: l_return_status := chk_lookup(

Line 1934: fnd_message.raise_error;

1930:
1931: IF l_return_status = -1 THEN
1932: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1933: fnd_message.set_token('FEILD','Taxation Method');
1934: fnd_message.raise_error;
1935: END IF;
1936: --If taxation method value exist then check for value validation for german
1937: l_return_status := chk_lookup(
1938: p_vehicle_repository_id => p_rec.vehicle_repository_id

Line 1946: fnd_message.set_name('PQP','PQP_230114_VLD_TAXATION_CDE');

1942: ,p_validation_start_date => p_validation_start_date
1943: ,p_validation_end_date => p_validation_end_date);
1944:
1945: IF l_return_status = -1 THEN
1946: fnd_message.set_name('PQP','PQP_230114_VLD_TAXATION_CDE');
1947: fnd_message.raise_error;
1948: END IF;
1949: END IF;
1950: END IF;

Line 1947: fnd_message.raise_error;

1943: ,p_validation_end_date => p_validation_end_date);
1944:
1945: IF l_return_status = -1 THEN
1946: fnd_message.set_name('PQP','PQP_230114_VLD_TAXATION_CDE');
1947: fnd_message.raise_error;
1948: END IF;
1949: END IF;
1950: END IF;
1951:

Line 1965: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1961: ,p_message =>l_message
1962: );
1963:
1964: IF l_return_status = -1 THEN
1965: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1966: fnd_message.set_token('PROCEDURE',l_message);
1967: fnd_message.raise_error;
1968: END IF;
1969: */

Line 1966: fnd_message.set_token('PROCEDURE',l_message);

1962: );
1963:
1964: IF l_return_status = -1 THEN
1965: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1966: fnd_message.set_token('PROCEDURE',l_message);
1967: fnd_message.raise_error;
1968: END IF;
1969: */
1970:

Line 1967: fnd_message.raise_error;

1963:
1964: IF l_return_status = -1 THEN
1965: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1966: fnd_message.set_token('PROCEDURE',l_message);
1967: fnd_message.raise_error;
1968: END IF;
1969: */
1970:
1971: --Checking the Ownership Change validation

Line 1984: fnd_message.set_name('PQP', 'PQP_230731_OWNRSHP_CHG_RSTRICT');

1980: (p_rec =>p_rec
1981: ,p_effective_date =>p_effective_date
1982: ,p_message =>l_message
1983: );
1984: fnd_message.set_name('PQP', 'PQP_230731_OWNRSHP_CHG_RSTRICT');
1985: fnd_message.set_token('NAME',l_return_message);
1986: fnd_message.raise_error;
1987: END IF;
1988:

Line 1985: fnd_message.set_token('NAME',l_return_message);

1981: ,p_effective_date =>p_effective_date
1982: ,p_message =>l_message
1983: );
1984: fnd_message.set_name('PQP', 'PQP_230731_OWNRSHP_CHG_RSTRICT');
1985: fnd_message.set_token('NAME',l_return_message);
1986: fnd_message.raise_error;
1987: END IF;
1988:
1989: --Checking vehicle_ownership Mandatory

Line 1986: fnd_message.raise_error;

1982: ,p_message =>l_message
1983: );
1984: fnd_message.set_name('PQP', 'PQP_230731_OWNRSHP_CHG_RSTRICT');
1985: fnd_message.set_token('NAME',l_return_message);
1986: fnd_message.raise_error;
1987: END IF;
1988:
1989: --Checking vehicle_ownership Mandatory
1990: l_return_status := chk_mandatory(

Line 1996: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

1992: ,p_argument_value => p_rec.vehicle_ownership
1993: ,p_message => l_message);
1994:
1995: IF l_return_status = -1 THEN
1996: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1997: fnd_message.set_token('FEILD','OwnerShip');
1998: fnd_message.raise_error;
1999: END IF;
2000:

Line 1997: fnd_message.set_token('FEILD','OwnerShip');

1993: ,p_message => l_message);
1994:
1995: IF l_return_status = -1 THEN
1996: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1997: fnd_message.set_token('FEILD','OwnerShip');
1998: fnd_message.raise_error;
1999: END IF;
2000:
2001: --Checking Vehicle Type Mandatory

Line 1998: fnd_message.raise_error;

1994:
1995: IF l_return_status = -1 THEN
1996: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1997: fnd_message.set_token('FEILD','OwnerShip');
1998: fnd_message.raise_error;
1999: END IF;
2000:
2001: --Checking Vehicle Type Mandatory
2002: l_return_status := chk_mandatory(

Line 2007: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2003: p_argument =>'vehicle_type'
2004: ,p_argument_value => p_rec.vehicle_type
2005: ,p_message => l_message);
2006: IF l_return_status = -1 THEN
2007: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2008: fnd_message.set_token('FEILD','Vehicle Type');
2009: fnd_message.raise_error;
2010: END IF;
2011:

Line 2008: fnd_message.set_token('FEILD','Vehicle Type');

2004: ,p_argument_value => p_rec.vehicle_type
2005: ,p_message => l_message);
2006: IF l_return_status = -1 THEN
2007: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2008: fnd_message.set_token('FEILD','Vehicle Type');
2009: fnd_message.raise_error;
2010: END IF;
2011:
2012:

Line 2009: fnd_message.raise_error;

2005: ,p_message => l_message);
2006: IF l_return_status = -1 THEN
2007: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2008: fnd_message.set_token('FEILD','Vehicle Type');
2009: fnd_message.raise_error;
2010: END IF;
2011:
2012:
2013: --Checking Registration Number Mandatory

Line 2020: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2016: p_argument =>'registration_number'
2017: ,p_argument_value => p_rec.registration_number
2018: ,p_message => l_message);
2019: IF l_return_status = -1 THEN
2020: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2021: fnd_message.set_token('FEILD','Registration Number');
2022: fnd_message.raise_error;
2023: END IF;
2024: END IF;

Line 2021: fnd_message.set_token('FEILD','Registration Number');

2017: ,p_argument_value => p_rec.registration_number
2018: ,p_message => l_message);
2019: IF l_return_status = -1 THEN
2020: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2021: fnd_message.set_token('FEILD','Registration Number');
2022: fnd_message.raise_error;
2023: END IF;
2024: END IF;
2025:

Line 2022: fnd_message.raise_error;

2018: ,p_message => l_message);
2019: IF l_return_status = -1 THEN
2020: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2021: fnd_message.set_token('FEILD','Registration Number');
2022: fnd_message.raise_error;
2023: END IF;
2024: END IF;
2025:
2026: --Checking Make Mandatory

Line 2032: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2028: p_argument =>'make'
2029: ,p_argument_value => p_rec.make
2030: ,p_message => l_message);
2031: IF l_return_status = -1 THEN
2032: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2033: fnd_message.set_token('FEILD','Make');
2034: fnd_message.raise_error;
2035: END IF;
2036:

Line 2033: fnd_message.set_token('FEILD','Make');

2029: ,p_argument_value => p_rec.make
2030: ,p_message => l_message);
2031: IF l_return_status = -1 THEN
2032: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2033: fnd_message.set_token('FEILD','Make');
2034: fnd_message.raise_error;
2035: END IF;
2036:
2037: --Checking Model Mandatory

Line 2034: fnd_message.raise_error;

2030: ,p_message => l_message);
2031: IF l_return_status = -1 THEN
2032: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2033: fnd_message.set_token('FEILD','Make');
2034: fnd_message.raise_error;
2035: END IF;
2036:
2037: --Checking Model Mandatory
2038: l_return_status := chk_mandatory(

Line 2043: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2039: p_argument =>'Model'
2040: ,p_argument_value => p_rec.model
2041: ,p_message => l_message);
2042: IF l_return_status = -1 THEN
2043: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2044: fnd_message.set_token('FEILD','Model');
2045: fnd_message.raise_error;
2046: END IF;
2047:

Line 2044: fnd_message.set_token('FEILD','Model');

2040: ,p_argument_value => p_rec.model
2041: ,p_message => l_message);
2042: IF l_return_status = -1 THEN
2043: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2044: fnd_message.set_token('FEILD','Model');
2045: fnd_message.raise_error;
2046: END IF;
2047:
2048: --Checking EngineCapacity Mandatory

Line 2045: fnd_message.raise_error;

2041: ,p_message => l_message);
2042: IF l_return_status = -1 THEN
2043: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2044: fnd_message.set_token('FEILD','Model');
2045: fnd_message.raise_error;
2046: END IF;
2047:
2048: --Checking EngineCapacity Mandatory
2049: --Not required now to be mandatory as this is non mandatory

Line 2057: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2053: p_argument =>'Engine Capacity'
2054: ,p_argument_value => p_rec.engine_capacity_in_cc
2055: ,p_message => l_message);
2056: IF l_return_status = -1 THEN
2057: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2058: fnd_message.set_token('FEILD','Engine Capacity');
2059: fnd_message.raise_error;
2060: END IF;
2061: END IF;

Line 2058: fnd_message.set_token('FEILD','Engine Capacity');

2054: ,p_argument_value => p_rec.engine_capacity_in_cc
2055: ,p_message => l_message);
2056: IF l_return_status = -1 THEN
2057: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2058: fnd_message.set_token('FEILD','Engine Capacity');
2059: fnd_message.raise_error;
2060: END IF;
2061: END IF;
2062: --Checking Fueltype Mandatory

Line 2059: fnd_message.raise_error;

2055: ,p_message => l_message);
2056: IF l_return_status = -1 THEN
2057: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2058: fnd_message.set_token('FEILD','Engine Capacity');
2059: fnd_message.raise_error;
2060: END IF;
2061: END IF;
2062: --Checking Fueltype Mandatory
2063: l_return_status := chk_mandatory(

Line 2068: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2064: p_argument =>'fuelType'
2065: ,p_argument_value => p_rec.fuel_type
2066: ,p_message => l_message);
2067: IF l_return_status = -1 THEN
2068: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2069: fnd_message.set_token('FEILD','Fuel Type');
2070: fnd_message.raise_error;
2071: END IF;
2072:

Line 2069: fnd_message.set_token('FEILD','Fuel Type');

2065: ,p_argument_value => p_rec.fuel_type
2066: ,p_message => l_message);
2067: IF l_return_status = -1 THEN
2068: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2069: fnd_message.set_token('FEILD','Fuel Type');
2070: fnd_message.raise_error;
2071: END IF;
2072:
2073: --Checking vehicleStatus Mandatory

Line 2070: fnd_message.raise_error;

2066: ,p_message => l_message);
2067: IF l_return_status = -1 THEN
2068: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2069: fnd_message.set_token('FEILD','Fuel Type');
2070: fnd_message.raise_error;
2071: END IF;
2072:
2073: --Checking vehicleStatus Mandatory
2074: l_return_status := chk_mandatory(

Line 2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2075: p_argument =>'VehicleStatus'
2076: ,p_argument_value => p_rec.vehicle_status
2077: ,p_message => l_message);
2078: IF l_return_status = -1 THEN
2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2080: fnd_message.set_token('FEILD','Vehicle Status');
2081: fnd_message.raise_error;
2082: END IF;
2083:

Line 2080: fnd_message.set_token('FEILD','Vehicle Status');

2076: ,p_argument_value => p_rec.vehicle_status
2077: ,p_message => l_message);
2078: IF l_return_status = -1 THEN
2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2080: fnd_message.set_token('FEILD','Vehicle Status');
2081: fnd_message.raise_error;
2082: END IF;
2083:
2084:

Line 2081: fnd_message.raise_error;

2077: ,p_message => l_message);
2078: IF l_return_status = -1 THEN
2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2080: fnd_message.set_token('FEILD','Vehicle Status');
2081: fnd_message.raise_error;
2082: END IF;
2083:
2084:
2085: --Checking for value change

Line 2101: fnd_message.set_name('PQP','PQP_230852_VEH_INACTIVE_REASON');

2097: ,p_effective_date => p_effective_date
2098: ,p_validation_start_date=> p_validation_start_date
2099: ,p_validation_end_date => p_validation_end_date);
2100: IF l_return_status = -1 THEN
2101: fnd_message.set_name('PQP','PQP_230852_VEH_INACTIVE_REASON');
2102: fnd_message.raise_error;
2103: END IF;
2104: ELSE
2105: --If vehicle status is active then Inactive Reason should be NULL

Line 2102: fnd_message.raise_error;

2098: ,p_validation_start_date=> p_validation_start_date
2099: ,p_validation_end_date => p_validation_end_date);
2100: IF l_return_status = -1 THEN
2101: fnd_message.set_name('PQP','PQP_230852_VEH_INACTIVE_REASON');
2102: fnd_message.raise_error;
2103: END IF;
2104: ELSE
2105: --If vehicle status is active then Inactive Reason should be NULL
2106: IF p_rec.vehicle_inactivity_reason IS NOT NULL THEN

Line 2107: fnd_message.set_name('PQP','PQP_230853_INACTIVE_REASON_ERR');

2103: END IF;
2104: ELSE
2105: --If vehicle status is active then Inactive Reason should be NULL
2106: IF p_rec.vehicle_inactivity_reason IS NOT NULL THEN
2107: fnd_message.set_name('PQP','PQP_230853_INACTIVE_REASON_ERR');
2108: fnd_message.raise_error;
2109: END IF;
2110:
2111: END IF;

Line 2108: fnd_message.raise_error;

2104: ELSE
2105: --If vehicle status is active then Inactive Reason should be NULL
2106: IF p_rec.vehicle_inactivity_reason IS NOT NULL THEN
2107: fnd_message.set_name('PQP','PQP_230853_INACTIVE_REASON_ERR');
2108: fnd_message.raise_error;
2109: END IF;
2110:
2111: END IF;
2112: END IF;

Line 2127: fnd_message.set_name('PQP','PQP_230741_VLD_OWNRSHP_CDE');

2123: ,p_validation_start_date => p_validation_start_date
2124: ,p_validation_end_date => p_validation_end_date);
2125:
2126: IF l_return_status = -1 THEN
2127: fnd_message.set_name('PQP','PQP_230741_VLD_OWNRSHP_CDE');
2128: fnd_message.raise_error;
2129: END IF;
2130: END IF;
2131:

Line 2128: fnd_message.raise_error;

2124: ,p_validation_end_date => p_validation_end_date);
2125:
2126: IF l_return_status = -1 THEN
2127: fnd_message.set_name('PQP','PQP_230741_VLD_OWNRSHP_CDE');
2128: fnd_message.raise_error;
2129: END IF;
2130: END IF;
2131:
2132: --Checking for value change

Line 2145: fnd_message.set_name('PQP','PQP_230742_VLD_STATUS_CDE');

2141: ,p_validation_start_date => p_validation_start_date
2142: ,p_validation_end_date => p_validation_end_date);
2143:
2144: IF l_return_status = -1 THEN
2145: fnd_message.set_name('PQP','PQP_230742_VLD_STATUS_CDE');
2146: fnd_message.raise_error;
2147: END IF;
2148: END IF;
2149:

Line 2146: fnd_message.raise_error;

2142: ,p_validation_end_date => p_validation_end_date);
2143:
2144: IF l_return_status = -1 THEN
2145: fnd_message.set_name('PQP','PQP_230742_VLD_STATUS_CDE');
2146: fnd_message.raise_error;
2147: END IF;
2148: END IF;
2149:
2150: --Checking for value change

Line 2162: fnd_message.set_name('PQP','PQP_230743_VLD_FUEL_TYP');

2158: ,p_effective_date => p_effective_date
2159: ,p_validation_start_date => p_validation_start_date
2160: ,p_validation_end_date => p_validation_end_date);
2161: IF l_return_status = -1 THEN
2162: fnd_message.set_name('PQP','PQP_230743_VLD_FUEL_TYP');
2163: fnd_message.raise_error;
2164: END IF;
2165: END IF;
2166:

Line 2163: fnd_message.raise_error;

2159: ,p_validation_start_date => p_validation_start_date
2160: ,p_validation_end_date => p_validation_end_date);
2161: IF l_return_status = -1 THEN
2162: fnd_message.set_name('PQP','PQP_230743_VLD_FUEL_TYP');
2163: fnd_message.raise_error;
2164: END IF;
2165: END IF;
2166:
2167: --Checking for value change

Line 2179: fnd_message.set_name('PQP','PQP_230744_VLD_VEH_TYP');

2175: ,p_effective_date => p_effective_date
2176: ,p_validation_start_date => p_validation_start_date
2177: ,p_validation_end_date => p_validation_end_date);
2178: IF l_return_status = -1 THEN
2179: fnd_message.set_name('PQP','PQP_230744_VLD_VEH_TYP');
2180: fnd_message.raise_error;
2181: END IF;
2182: END IF;
2183:

Line 2180: fnd_message.raise_error;

2176: ,p_validation_start_date => p_validation_start_date
2177: ,p_validation_end_date => p_validation_end_date);
2178: IF l_return_status = -1 THEN
2179: fnd_message.set_name('PQP','PQP_230744_VLD_VEH_TYP');
2180: fnd_message.raise_error;
2181: END IF;
2182: END IF;
2183:
2184:

Line 2194: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');

2190: ,p_argument_value => p_rec.initial_registration
2191: ,p_message => l_message);
2192:
2193: IF l_return_status = -1 THEN
2194: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
2195: fnd_message.set_token('FEILD','Initial Registration');
2196: fnd_message.raise_error;
2197: END IF;
2198: --Check for list_price

Line 2195: fnd_message.set_token('FEILD','Initial Registration');

2191: ,p_message => l_message);
2192:
2193: IF l_return_status = -1 THEN
2194: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
2195: fnd_message.set_token('FEILD','Initial Registration');
2196: fnd_message.raise_error;
2197: END IF;
2198: --Check for list_price
2199: l_return_status := chk_mandatory(

Line 2196: fnd_message.raise_error;

2192:
2193: IF l_return_status = -1 THEN
2194: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
2195: fnd_message.set_token('FEILD','Initial Registration');
2196: fnd_message.raise_error;
2197: END IF;
2198: --Check for list_price
2199: l_return_status := chk_mandatory(
2200: p_argument =>'ListPrice'

Line 2205: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');

2201: ,p_argument_value => p_rec.list_price
2202: ,p_message => l_message);
2203:
2204: IF l_return_status = -1 THEN
2205: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
2206: fnd_message.set_token('FEILD','List Price');
2207: fnd_message.raise_error;
2208: END IF;
2209: END IF;

Line 2206: fnd_message.set_token('FEILD','List Price');

2202: ,p_message => l_message);
2203:
2204: IF l_return_status = -1 THEN
2205: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
2206: fnd_message.set_token('FEILD','List Price');
2207: fnd_message.raise_error;
2208: END IF;
2209: END IF;
2210:

Line 2207: fnd_message.raise_error;

2203:
2204: IF l_return_status = -1 THEN
2205: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
2206: fnd_message.set_token('FEILD','List Price');
2207: fnd_message.raise_error;
2208: END IF;
2209: END IF;
2210:
2211:

Line 2219: fnd_message.set_name('PQP', 'PQP_230758_SHARE_EMP_CHG');

2215: ,p_effective_date =>p_effective_date
2216: ,p_message =>l_message
2217: );
2218: IF l_return_status = -1 THEN
2219: fnd_message.set_name('PQP', 'PQP_230758_SHARE_EMP_CHG');
2220: fnd_message.raise_error;
2221: END IF;
2222: EXCEPTION
2223: WHEN app_exception.application_exception THEN

Line 2220: fnd_message.raise_error;

2216: ,p_message =>l_message
2217: );
2218: IF l_return_status = -1 THEN
2219: fnd_message.set_name('PQP', 'PQP_230758_SHARE_EMP_CHG');
2220: fnd_message.raise_error;
2221: END IF;
2222: EXCEPTION
2223: WHEN app_exception.application_exception THEN
2224: IF hr_multi_message.exception_add

Line 2295: fnd_message.set_name('PQP', 'PQP_230730_VEH_DEL_RSTRICT');

2291:
2292: hr_utility.set_location('Veh purge Delete Status :'||l_return_message,50);
2293:
2294: IF l_return_message IS NOT NULL THEN
2295: fnd_message.set_name('PQP', 'PQP_230730_VEH_DEL_RSTRICT');
2296: fnd_message.set_token('NAME',l_return_message);
2297: fnd_message.raise_error;
2298: END IF;
2299: ELSIF p_datetrack_mode = 'DELETE' THEN

Line 2296: fnd_message.set_token('NAME',l_return_message);

2292: hr_utility.set_location('Veh purge Delete Status :'||l_return_message,50);
2293:
2294: IF l_return_message IS NOT NULL THEN
2295: fnd_message.set_name('PQP', 'PQP_230730_VEH_DEL_RSTRICT');
2296: fnd_message.set_token('NAME',l_return_message);
2297: fnd_message.raise_error;
2298: END IF;
2299: ELSIF p_datetrack_mode = 'DELETE' THEN
2300: --This is for enddate

Line 2297: fnd_message.raise_error;

2293:
2294: IF l_return_message IS NOT NULL THEN
2295: fnd_message.set_name('PQP', 'PQP_230730_VEH_DEL_RSTRICT');
2296: fnd_message.set_token('NAME',l_return_message);
2297: fnd_message.raise_error;
2298: END IF;
2299: ELSIF p_datetrack_mode = 'DELETE' THEN
2300: --This is for enddate
2301: l_return_message := pqp_enddate_delete_veh

Line 2310: fnd_message.set_name('PQP', 'PQP_230729_VEH_ENDDT_RSTRICT');

2306:
2307: hr_utility.set_location('Veh enddate Delete Status :'||l_return_message,55);
2308:
2309: IF l_return_message IS NOT NULL THEN
2310: fnd_message.set_name('PQP', 'PQP_230729_VEH_ENDDT_RSTRICT');
2311: fnd_message.set_token('NAME',l_return_message);
2312: fnd_message.raise_error;
2313: END IF;
2314:

Line 2311: fnd_message.set_token('NAME',l_return_message);

2307: hr_utility.set_location('Veh enddate Delete Status :'||l_return_message,55);
2308:
2309: IF l_return_message IS NOT NULL THEN
2310: fnd_message.set_name('PQP', 'PQP_230729_VEH_ENDDT_RSTRICT');
2311: fnd_message.set_token('NAME',l_return_message);
2312: fnd_message.raise_error;
2313: END IF;
2314:
2315: END IF;

Line 2312: fnd_message.raise_error;

2308:
2309: IF l_return_message IS NOT NULL THEN
2310: fnd_message.set_name('PQP', 'PQP_230729_VEH_ENDDT_RSTRICT');
2311: fnd_message.set_token('NAME',l_return_message);
2312: fnd_message.raise_error;
2313: END IF;
2314:
2315: END IF;
2316: