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_VAL_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_ALLOCATION_ID')
67: );

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

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

Line 145: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 481: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 563: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 660: fnd_message.raise_error;

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

Line 858: fnd_message.raise_error;

854:
855: EXCEPTION
856: ---------
857: WHEN no_data_found then
858: fnd_message.raise_error;
859:
860: WHEN others then
861: fnd_message.raise_error;
862:

Line 861: fnd_message.raise_error;

857: WHEN no_data_found then
858: fnd_message.raise_error;
859:
860: WHEN others then
861: fnd_message.raise_error;
862:
863:
864: End;
865: ------------------------------------------------------------------------------

Line 888: fnd_message.raise_error;

884:
885: EXCEPTION
886: ---------
887: WHEN no_data_found then
888: fnd_message.raise_error;
889:
890: WHEN others then
891: fnd_message.raise_error;
892: End;

Line 891: fnd_message.raise_error;

887: WHEN no_data_found then
888: fnd_message.raise_error;
889:
890: WHEN others then
891: fnd_message.raise_error;
892: End;
893: -----------------------------------------------------------------------------
894: ---------------------Check the Primary Vehicle Allocation-
895: -----------------------------------------------------------------------------

Line 1431: fnd_message.set_name('PQP', 'PQP_230925_INACTIVE_VEH_ASSIGN');

1427:
1428: --Checking the vehicle status ,if it Inactive then
1429: --vehicle cannot be allocate
1430: IF l_vehicle_status = 'I' THEN
1431: fnd_message.set_name('PQP', 'PQP_230925_INACTIVE_VEH_ASSIGN');
1432: fnd_message.raise_error;
1433: END IF;
1434:
1435: --Fixing the bug #2864591

Line 1432: fnd_message.raise_error;

1428: --Checking the vehicle status ,if it Inactive then
1429: --vehicle cannot be allocate
1430: IF l_vehicle_status = 'I' THEN
1431: fnd_message.set_name('PQP', 'PQP_230925_INACTIVE_VEH_ASSIGN');
1432: fnd_message.raise_error;
1433: END IF;
1434:
1435: --Fixing the bug #2864591
1436: --Checking the allocation effective start date is

Line 1440: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');

1436: --Checking the allocation effective start date is
1437: --greter than or equal to veh reg date
1438: IF l_initial_registration IS NOT NULL THEN
1439: IF l_initial_registration > p_effective_date THEN
1440: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');
1441: fnd_message.set_token('TOKEN',l_registration_number);
1442: fnd_message.raise_error;
1443: END IF;
1444: END IF;

Line 1441: fnd_message.set_token('TOKEN',l_registration_number);

1437: --greter than or equal to veh reg date
1438: IF l_initial_registration IS NOT NULL THEN
1439: IF l_initial_registration > p_effective_date THEN
1440: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');
1441: fnd_message.set_token('TOKEN',l_registration_number);
1442: fnd_message.raise_error;
1443: END IF;
1444: END IF;
1445:

Line 1442: fnd_message.raise_error;

1438: IF l_initial_registration IS NOT NULL THEN
1439: IF l_initial_registration > p_effective_date THEN
1440: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');
1441: fnd_message.set_token('TOKEN',l_registration_number);
1442: fnd_message.raise_error;
1443: END IF;
1444: END IF;
1445:
1446:

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

1451: ,p_argument_value => p_rec.usage_type
1452: ,p_message => l_message);
1453:
1454: IF l_return_status = -1 THEN
1455: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1456: fnd_message.set_token('FEILD','Usage Type');
1457: fnd_message.raise_error;
1458: END IF;
1459: END IF;

Line 1456: fnd_message.set_token('FEILD','Usage Type');

1452: ,p_message => l_message);
1453:
1454: IF l_return_status = -1 THEN
1455: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1456: fnd_message.set_token('FEILD','Usage Type');
1457: fnd_message.raise_error;
1458: END IF;
1459: END IF;
1460:

Line 1457: fnd_message.raise_error;

1453:
1454: IF l_return_status = -1 THEN
1455: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
1456: fnd_message.set_token('FEILD','Usage Type');
1457: fnd_message.raise_error;
1458: END IF;
1459: END IF;
1460:
1461: --Checking usage Type lookup validation

Line 1474: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');

1470: ,p_validation_start_date => p_validation_start_date
1471: ,p_validation_end_date => p_validation_end_date);
1472:
1473: IF l_return_status = -1 THEN
1474: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1475: fnd_message.raise_error;
1476: END IF;
1477: ELSE
1478: /*

Line 1475: fnd_message.raise_error;

1471: ,p_validation_end_date => p_validation_end_date);
1472:
1473: IF l_return_status = -1 THEN
1474: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1475: fnd_message.raise_error;
1476: END IF;
1477: ELSE
1478: /*
1479: l_return_status := chk_lookup(

Line 1488: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');

1484: ,p_validation_start_date => p_validation_start_date
1485: ,p_validation_end_date => p_validation_end_date);
1486:
1487: IF l_return_status = -1 THEN
1488: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1489: fnd_message.raise_error;
1490: END IF;*/
1491: NULL;
1492: END IF;

Line 1489: fnd_message.raise_error;

1485: ,p_validation_end_date => p_validation_end_date);
1486:
1487: IF l_return_status = -1 THEN
1488: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1489: fnd_message.raise_error;
1490: END IF;*/
1491: NULL;
1492: END IF;
1493:

Line 1504: fnd_message.set_name('PQP','PQP_230824_VALID_CALC_METHOD');

1500: ,p_validation_start_date => p_validation_start_date
1501: ,p_validation_end_date => p_validation_end_date);
1502:
1503: IF l_return_status = -1 THEN
1504: fnd_message.set_name('PQP','PQP_230824_VALID_CALC_METHOD');
1505: fnd_message.raise_error;
1506: END IF;
1507:
1508: --Checking the regnumber exist

Line 1505: fnd_message.raise_error;

1501: ,p_validation_end_date => p_validation_end_date);
1502:
1503: IF l_return_status = -1 THEN
1504: fnd_message.set_name('PQP','PQP_230824_VALID_CALC_METHOD');
1505: fnd_message.raise_error;
1506: END IF;
1507:
1508: --Checking the regnumber exist
1509: l_return_status := chk_reg_exist_for_alloc(

Line 1515: fnd_message.set_name('PQP', 'PQP_230759_ALLOC_REG_EXIST');

1511: ,p_effective_date => p_effective_date
1512: ,p_message => l_message );
1513:
1514: IF l_return_status = -1 THEN
1515: fnd_message.set_name('PQP', 'PQP_230759_ALLOC_REG_EXIST');
1516: fnd_message.raise_error;
1517: END IF;
1518:
1519:

Line 1516: fnd_message.raise_error;

1512: ,p_message => l_message );
1513:
1514: IF l_return_status = -1 THEN
1515: fnd_message.set_name('PQP', 'PQP_230759_ALLOC_REG_EXIST');
1516: fnd_message.raise_error;
1517: END IF;
1518:
1519:
1520: --Checking the fuelcard/fuelNumber/fuelbenifit value

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

1527: ,p_effective_date => p_effective_date
1528: ,p_message => l_message );
1529:
1530: IF l_return_status = -1 THEN
1531: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
1532: fnd_message.set_token('TOKEN','Fuel Card');
1533: fnd_message.raise_error;
1534: END IF;
1535: END IF;

Line 1532: fnd_message.set_token('TOKEN','Fuel Card');

1528: ,p_message => l_message );
1529:
1530: IF l_return_status = -1 THEN
1531: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
1532: fnd_message.set_token('TOKEN','Fuel Card');
1533: fnd_message.raise_error;
1534: END IF;
1535: END IF;
1536:

Line 1533: fnd_message.raise_error;

1529:
1530: IF l_return_status = -1 THEN
1531: fnd_message.set_name('PQP', 'PQP_230738_COMP_OWNR_MNDTRY');
1532: fnd_message.set_token('TOKEN','Fuel Card');
1533: fnd_message.raise_error;
1534: END IF;
1535: END IF;
1536:
1537: --Getting the legislationId for business groupId

Line 1555: fnd_message.set_name('PQP', 'PQP_230708_PMRY_RESTRICT');

1551:
1552: -- If there is already allocation then throw error
1553: -- because it should be only one entry for P/E
1554: IF l_return_count = -1 THEN
1555: fnd_message.set_name('PQP', 'PQP_230708_PMRY_RESTRICT');
1556: fnd_message.raise_error;
1557: END IF;
1558: END IF;
1559:

Line 1556: fnd_message.raise_error;

1552: -- If there is already allocation then throw error
1553: -- because it should be only one entry for P/E
1554: IF l_return_count = -1 THEN
1555: fnd_message.set_name('PQP', 'PQP_230708_PMRY_RESTRICT');
1556: fnd_message.raise_error;
1557: END IF;
1558: END IF;
1559:
1560:

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

1583: l_number_value := fnd_number.CANONICAL_TO_NUMBER(l_max_conf_count);
1584: End;
1585: IF l_cmy_veh_alloc_count >= l_number_value THEN
1586: l_message := 'person already reached the maximum limit';
1587: fnd_message.set_name('PQP', 'PQP_230709_MAX_COMP_ALLOC');
1588: fnd_message.raise_error;
1589: END IF;
1590: END IF;
1591:

Line 1588: fnd_message.raise_error;

1584: End;
1585: IF l_cmy_veh_alloc_count >= l_number_value THEN
1586: l_message := 'person already reached the maximum limit';
1587: fnd_message.set_name('PQP', 'PQP_230709_MAX_COMP_ALLOC');
1588: fnd_message.raise_error;
1589: END IF;
1590: END IF;
1591:
1592: --Checking the Share Company Car validation

Line 1605: fnd_message.set_name('PQP', 'PQP_230707_VEH_ALLOC_INFO');

1601: p_information_category =>'PQP_VEHICLE_MILEAGE',
1602: p_message => l_message );
1603:
1604: IF l_return_count = -1 THEN
1605: fnd_message.set_name('PQP', 'PQP_230707_VEH_ALLOC_INFO');
1606: fnd_message.raise_error;
1607: END IF;
1608: END IF;
1609:

Line 1606: fnd_message.raise_error;

1602: p_message => l_message );
1603:
1604: IF l_return_count = -1 THEN
1605: fnd_message.set_name('PQP', 'PQP_230707_VEH_ALLOC_INFO');
1606: fnd_message.raise_error;
1607: END IF;
1608: END IF;
1609:
1610:

Line 1629: fnd_message.set_name('PQP', 'PQP_230746_ONE_ESS_RSTRICT');

1625: ,p_message =>l_message );
1626: -- If there is already allocation then throw error
1627: -- because it should be only one entry for default
1628: IF l_return_count = -1 THEN
1629: fnd_message.set_name('PQP', 'PQP_230746_ONE_ESS_RSTRICT');
1630: fnd_message.raise_error;
1631: END IF;
1632: END IF;
1633:

Line 1630: fnd_message.raise_error;

1626: -- If there is already allocation then throw error
1627: -- because it should be only one entry for default
1628: IF l_return_count = -1 THEN
1629: fnd_message.set_name('PQP', 'PQP_230746_ONE_ESS_RSTRICT');
1630: fnd_message.raise_error;
1631: END IF;
1632: END IF;
1633:
1634:

Line 1657: fnd_message.set_name('PQP', 'PQP_230710_MAX_PVT_ALLOC');

1653: End;
1654:
1655: IF l_pri_veh_alloc_count >= l_number_value THEN
1656: l_message := 'person already reached the maximum limit';
1657: fnd_message.set_name('PQP', 'PQP_230710_MAX_PVT_ALLOC');
1658: fnd_message.raise_error;
1659: END IF;
1660: END IF;
1661: -- cheking for share Private car

Line 1658: fnd_message.raise_error;

1654:
1655: IF l_pri_veh_alloc_count >= l_number_value THEN
1656: l_message := 'person already reached the maximum limit';
1657: fnd_message.set_name('PQP', 'PQP_230710_MAX_PVT_ALLOC');
1658: fnd_message.raise_error;
1659: END IF;
1660: END IF;
1661: -- cheking for share Private car
1662: l_return_count := pqp_config_shared_veh(

Line 1674: fnd_message.set_name('PQP', 'PQP_230707_VEH_ALLOC_INFO');

1670: p_information_category =>'PQP_VEHICLE_MILEAGE',
1671: p_message => l_message );
1672:
1673: IF l_return_count = -1 THEN
1674: fnd_message.set_name('PQP', 'PQP_230707_VEH_ALLOC_INFO');
1675: fnd_message.raise_error;
1676: END IF;
1677: END IF;
1678: Exception

Line 1675: fnd_message.raise_error;

1671: p_message => l_message );
1672:
1673: IF l_return_count = -1 THEN
1674: fnd_message.set_name('PQP', 'PQP_230707_VEH_ALLOC_INFO');
1675: fnd_message.raise_error;
1676: END IF;
1677: END IF;
1678: Exception
1679: when app_exception.application_exception then

Line 1795: fnd_message.set_name('PQP', 'PQP_230925_INACTIVE_VEH_ASSIGN');

1791: p_rec.vehicle_repository_id THEN
1792:
1793: IF l_vehicle_status = 'I' THEN
1794: l_message := 'Vehicle status is Inactive,so vehicle cannot update';
1795: fnd_message.set_name('PQP', 'PQP_230925_INACTIVE_VEH_ASSIGN');
1796: fnd_message.raise_error;
1797: END IF;
1798: END IF;
1799:

Line 1796: fnd_message.raise_error;

1792:
1793: IF l_vehicle_status = 'I' THEN
1794: l_message := 'Vehicle status is Inactive,so vehicle cannot update';
1795: fnd_message.set_name('PQP', 'PQP_230925_INACTIVE_VEH_ASSIGN');
1796: fnd_message.raise_error;
1797: END IF;
1798: END IF;
1799:
1800: --Fixing the bug #2864591

Line 1805: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');

1801: --Checking the allocation effective start date is
1802: --greter than or equal to veh reg date
1803: IF l_initial_registration IS NOT NULL THEN
1804: IF l_initial_registration > p_effective_date THEN
1805: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');
1806: fnd_message.set_token('TOKEN',l_registration_number);
1807: fnd_message.raise_error;
1808: END IF;
1809: END IF;

Line 1806: fnd_message.set_token('TOKEN',l_registration_number);

1802: --greter than or equal to veh reg date
1803: IF l_initial_registration IS NOT NULL THEN
1804: IF l_initial_registration > p_effective_date THEN
1805: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');
1806: fnd_message.set_token('TOKEN',l_registration_number);
1807: fnd_message.raise_error;
1808: END IF;
1809: END IF;
1810:

Line 1807: fnd_message.raise_error;

1803: IF l_initial_registration IS NOT NULL THEN
1804: IF l_initial_registration > p_effective_date THEN
1805: fnd_message.set_name('PQP', 'PQP_230926_REG_DATE_ASSIGN_ERR');
1806: fnd_message.set_token('TOKEN',l_registration_number);
1807: fnd_message.raise_error;
1808: END IF;
1809: END IF;
1810:
1811: --Checking for value change

Line 1827: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');

1823: ,p_effective_date => p_effective_date
1824: ,p_validation_start_date => p_validation_start_date
1825: ,p_validation_end_date => p_validation_end_date);
1826: IF l_return_status = -1 THEN
1827: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1828: fnd_message.raise_error;
1829: END IF;
1830: ELSE
1831: /*

Line 1828: fnd_message.raise_error;

1824: ,p_validation_start_date => p_validation_start_date
1825: ,p_validation_end_date => p_validation_end_date);
1826: IF l_return_status = -1 THEN
1827: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1828: fnd_message.raise_error;
1829: END IF;
1830: ELSE
1831: /*
1832: l_return_status := chk_lookup(

Line 1840: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');

1836: ,p_effective_date => p_effective_date
1837: ,p_validation_start_date => p_validation_start_date
1838: ,p_validation_end_date => p_validation_end_date);
1839: IF l_return_status = -1 THEN
1840: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1841: fnd_message.raise_error;
1842: END IF;*/
1843: NULL;
1844: END IF;

Line 1841: fnd_message.raise_error;

1837: ,p_validation_start_date => p_validation_start_date
1838: ,p_validation_end_date => p_validation_end_date);
1839: IF l_return_status = -1 THEN
1840: fnd_message.set_name('PQP','PQP_230722_VLD_USG_OWNRSHP');
1841: fnd_message.raise_error;
1842: END IF;*/
1843: NULL;
1844: END IF;
1845: END IF;

Line 1860: fnd_message.set_name('PQP','PQP_230824_VALID_CALC_METHOD');

1856: ,p_validation_start_date => p_validation_start_date
1857: ,p_validation_end_date => p_validation_end_date);
1858:
1859: IF l_return_status = -1 THEN
1860: fnd_message.set_name('PQP','PQP_230824_VALID_CALC_METHOD');
1861: fnd_message.raise_error;
1862: END IF;
1863: END IF;
1864:

Line 1861: fnd_message.raise_error;

1857: ,p_validation_end_date => p_validation_end_date);
1858:
1859: IF l_return_status = -1 THEN
1860: fnd_message.set_name('PQP','PQP_230824_VALID_CALC_METHOD');
1861: fnd_message.raise_error;
1862: END IF;
1863: END IF;
1864:
1865:

Line 1881: fnd_message.set_name('PQP', 'PQP_230708_PMRY_RESTRICT');

1877:
1878: -- If there is already allocation then throw error,because it
1879: --should be only one entry for P
1880: IF l_return_count = -1 THEN
1881: fnd_message.set_name('PQP', 'PQP_230708_PMRY_RESTRICT');
1882: fnd_message.raise_error;
1883: END IF;
1884: END IF;
1885: END IF;

Line 1882: fnd_message.raise_error;

1878: -- If there is already allocation then throw error,because it
1879: --should be only one entry for P
1880: IF l_return_count = -1 THEN
1881: fnd_message.set_name('PQP', 'PQP_230708_PMRY_RESTRICT');
1882: fnd_message.raise_error;
1883: END IF;
1884: END IF;
1885: END IF;
1886:

Line 1906: fnd_message.set_name('PQP', 'PQP_230746_ONE_ESS_RSTRICT');

1902: ,p_message =>l_message );
1903: --If there is already allocation then throw error
1904: --because it should be only one entry for default
1905: IF l_return_count = -1 THEN
1906: fnd_message.set_name('PQP', 'PQP_230746_ONE_ESS_RSTRICT');
1907: fnd_message.raise_error;
1908: END IF;
1909: END IF;
1910: END IF;

Line 1907: fnd_message.raise_error;

1903: --If there is already allocation then throw error
1904: --because it should be only one entry for default
1905: IF l_return_count = -1 THEN
1906: fnd_message.set_name('PQP', 'PQP_230746_ONE_ESS_RSTRICT');
1907: fnd_message.raise_error;
1908: END IF;
1909: END IF;
1910: END IF;
1911:

Line 1967: fnd_message.set_name('PQP', 'PQP_230724_DEL_ALLOC_RESTRICT');

1963: ,p_effective_date =>p_effective_date
1964: ,p_message => l_message );
1965: hr_utility.set_location('Purge delete status:'||l_return_status,40);
1966: IF l_return_status = -1 THEN
1967: fnd_message.set_name('PQP', 'PQP_230724_DEL_ALLOC_RESTRICT');
1968: fnd_message.raise_error;
1969: END IF;
1970:
1971: ELSIF p_datetrack_mode = 'DELETE' THEN

Line 1968: fnd_message.raise_error;

1964: ,p_message => l_message );
1965: hr_utility.set_location('Purge delete status:'||l_return_status,40);
1966: IF l_return_status = -1 THEN
1967: fnd_message.set_name('PQP', 'PQP_230724_DEL_ALLOC_RESTRICT');
1968: fnd_message.raise_error;
1969: END IF;
1970:
1971: ELSIF p_datetrack_mode = 'DELETE' THEN
1972: --This is for enddate

Line 1979: fnd_message.set_name('PQP', 'PQP_230700_CANCEL_INFO');

1975: ,p_effective_date =>p_effective_date
1976: ,p_message => l_message );
1977: hr_utility.set_location('En date delete status :'||l_return_status,45);
1978: IF l_return_status = -1 THEN
1979: fnd_message.set_name('PQP', 'PQP_230700_CANCEL_INFO');
1980: fnd_message.raise_error;
1981: END IF;
1982: END IF;
1983:

Line 1980: fnd_message.raise_error;

1976: ,p_message => l_message );
1977: hr_utility.set_location('En date delete status :'||l_return_status,45);
1978: IF l_return_status = -1 THEN
1979: fnd_message.set_name('PQP', 'PQP_230700_CANCEL_INFO');
1980: fnd_message.raise_error;
1981: END IF;
1982: END IF;
1983:
1984: hr_utility.set_location(' Leaving:'||l_proc, 10);