APPS.HR_UPLOAD_PROPOSAL_API dependencies on HR_API

Line 1049: when hr_api.cannot_find_prog_unit then

1045: ,p_component_id_10 => p_component_id_10
1046: ,p_ppc_object_version_number_10 => p_ppc_object_version_number_10
1047: );
1048: exception
1049: when hr_api.cannot_find_prog_unit then
1050: hr_api.cannot_find_prog_unit_error
1051: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1052: ,p_hook_type => 'BP'
1053: );

Line 1050: hr_api.cannot_find_prog_unit_error

1046: ,p_ppc_object_version_number_10 => p_ppc_object_version_number_10
1047: );
1048: exception
1049: when hr_api.cannot_find_prog_unit then
1050: hr_api.cannot_find_prog_unit_error
1051: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1052: ,p_hook_type => 'BP'
1053: );
1054: --

Line 1186: if l_next_sal_review_date = hr_api.g_date then

1182: else
1183: --
1184: -- p_next_sal_review_date is being set to null if it is
1185: -- defaulted to EOT
1186: if l_next_sal_review_date = hr_api.g_date then
1187: l_next_sal_review_date := null;
1188: end if;
1189: --
1190: -- This means that the record need to be inserted

Line 1441: if l_next_sal_review_date = hr_api.g_date then

1437: hr_utility.set_location(l_proc,85);
1438: --
1439: end if;
1440: --
1441: if l_next_sal_review_date = hr_api.g_date then
1442: l_next_sal_review_date := null;
1443: end if;
1444:
1445: -- insert an unapproved single component salary proposal record in

Line 1562: nvl(l_change_amount,hr_api.g_number)

1558: --
1559: -- Do nothing if the component has not changed at all.
1560: --
1561: if (l_component_reason = l_component_reason_in AND
1562: nvl(l_change_amount,hr_api.g_number)
1563: = nvl(l_change_amount_in,hr_api.g_number) AND
1564: nvl(l_change_percentage,hr_api.g_number)
1565: = nvl(l_change_percentage_in,hr_api.g_number) AND
1566: l_ppc_approved = l_approved_in ) then

Line 1563: = nvl(l_change_amount_in,hr_api.g_number) AND

1559: -- Do nothing if the component has not changed at all.
1560: --
1561: if (l_component_reason = l_component_reason_in AND
1562: nvl(l_change_amount,hr_api.g_number)
1563: = nvl(l_change_amount_in,hr_api.g_number) AND
1564: nvl(l_change_percentage,hr_api.g_number)
1565: = nvl(l_change_percentage_in,hr_api.g_number) AND
1566: l_ppc_approved = l_approved_in ) then
1567: --

Line 1564: nvl(l_change_percentage,hr_api.g_number)

1560: --
1561: if (l_component_reason = l_component_reason_in AND
1562: nvl(l_change_amount,hr_api.g_number)
1563: = nvl(l_change_amount_in,hr_api.g_number) AND
1564: nvl(l_change_percentage,hr_api.g_number)
1565: = nvl(l_change_percentage_in,hr_api.g_number) AND
1566: l_ppc_approved = l_approved_in ) then
1567: --
1568: -- this means that the component has not changed

Line 1565: = nvl(l_change_percentage_in,hr_api.g_number) AND

1561: if (l_component_reason = l_component_reason_in AND
1562: nvl(l_change_amount,hr_api.g_number)
1563: = nvl(l_change_amount_in,hr_api.g_number) AND
1564: nvl(l_change_percentage,hr_api.g_number)
1565: = nvl(l_change_percentage_in,hr_api.g_number) AND
1566: l_ppc_approved = l_approved_in ) then
1567: --
1568: -- this means that the component has not changed
1569: -- we just adding the amount.

Line 1576: nvl(l_change_amount,hr_api.g_number)

1572: l_component_sum
1573: := l_component_sum + l_change_amount;
1574: --
1575: elsif (l_component_reason = l_component_reason_in AND
1576: nvl(l_change_amount,hr_api.g_number)
1577: = nvl(l_change_amount_in,hr_api.g_number) AND
1578: nvl(l_change_percentage,hr_api.g_number)
1579: = nvl(l_change_percentage_in,hr_api.g_number) AND
1580: l_ppc_approved <> l_approved_in ) then

Line 1577: = nvl(l_change_amount_in,hr_api.g_number) AND

1573: := l_component_sum + l_change_amount;
1574: --
1575: elsif (l_component_reason = l_component_reason_in AND
1576: nvl(l_change_amount,hr_api.g_number)
1577: = nvl(l_change_amount_in,hr_api.g_number) AND
1578: nvl(l_change_percentage,hr_api.g_number)
1579: = nvl(l_change_percentage_in,hr_api.g_number) AND
1580: l_ppc_approved <> l_approved_in ) then
1581: --

Line 1578: nvl(l_change_percentage,hr_api.g_number)

1574: --
1575: elsif (l_component_reason = l_component_reason_in AND
1576: nvl(l_change_amount,hr_api.g_number)
1577: = nvl(l_change_amount_in,hr_api.g_number) AND
1578: nvl(l_change_percentage,hr_api.g_number)
1579: = nvl(l_change_percentage_in,hr_api.g_number) AND
1580: l_ppc_approved <> l_approved_in ) then
1581: --
1582: -- this means that the component approval status has changed.

Line 1579: = nvl(l_change_percentage_in,hr_api.g_number) AND

1575: elsif (l_component_reason = l_component_reason_in AND
1576: nvl(l_change_amount,hr_api.g_number)
1577: = nvl(l_change_amount_in,hr_api.g_number) AND
1578: nvl(l_change_percentage,hr_api.g_number)
1579: = nvl(l_change_percentage_in,hr_api.g_number) AND
1580: l_ppc_approved <> l_approved_in ) then
1581: --
1582: -- this means that the component approval status has changed.
1583: -- We need to update the record.Set the update flag to true.

Line 1596: nvl(l_change_amount,hr_api.g_number)

1592: -- issue an error if updating an approved component
1593: --
1594: elsif (l_ppc_approved = 'Y' AND
1595: (l_component_reason <> l_component_reason_in OR
1596: nvl(l_change_amount,hr_api.g_number)
1597: <> nvl(l_change_amount_in,hr_api.g_number) OR
1598: nvl(l_change_percentage,hr_api.g_number)
1599: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1600: hr_utility.set_location(l_proc,140);

Line 1597: <> nvl(l_change_amount_in,hr_api.g_number) OR

1593: --
1594: elsif (l_ppc_approved = 'Y' AND
1595: (l_component_reason <> l_component_reason_in OR
1596: nvl(l_change_amount,hr_api.g_number)
1597: <> nvl(l_change_amount_in,hr_api.g_number) OR
1598: nvl(l_change_percentage,hr_api.g_number)
1599: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1600: hr_utility.set_location(l_proc,140);
1601: hr_utility.set_message(801,'HR_51454_PPC_CANT_UPD_COMP');

Line 1598: nvl(l_change_percentage,hr_api.g_number)

1594: elsif (l_ppc_approved = 'Y' AND
1595: (l_component_reason <> l_component_reason_in OR
1596: nvl(l_change_amount,hr_api.g_number)
1597: <> nvl(l_change_amount_in,hr_api.g_number) OR
1598: nvl(l_change_percentage,hr_api.g_number)
1599: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1600: hr_utility.set_location(l_proc,140);
1601: hr_utility.set_message(801,'HR_51454_PPC_CANT_UPD_COMP');
1602: hr_utility.raise_error;

Line 1599: <> nvl(l_change_percentage_in,hr_api.g_number))) then

1595: (l_component_reason <> l_component_reason_in OR
1596: nvl(l_change_amount,hr_api.g_number)
1597: <> nvl(l_change_amount_in,hr_api.g_number) OR
1598: nvl(l_change_percentage,hr_api.g_number)
1599: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1600: hr_utility.set_location(l_proc,140);
1601: hr_utility.set_message(801,'HR_51454_PPC_CANT_UPD_COMP');
1602: hr_utility.raise_error;
1603: elsif (l_ppc_approved = 'N') then

Line 1896: when hr_api.cannot_find_prog_unit then

1892: ,p_pyp_proposed_sal_warning => l_pyp_proposed_sal_warning
1893: ,p_additional_comp_warning => l_additional_comp_warning
1894: );
1895: exception
1896: when hr_api.cannot_find_prog_unit then
1897: hr_api.cannot_find_prog_unit_error
1898: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1899: ,p_hook_type => 'AP'
1900: );

Line 1897: hr_api.cannot_find_prog_unit_error

1893: ,p_additional_comp_warning => l_additional_comp_warning
1894: );
1895: exception
1896: when hr_api.cannot_find_prog_unit then
1897: hr_api.cannot_find_prog_unit_error
1898: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1899: ,p_hook_type => 'AP'
1900: );
1901: --

Line 1909: raise hr_api.validate_enabled;

1905: --
1906: -- when in validation only mode raise the Validate_Enabled exception
1907: --
1908: if p_validate then
1909: raise hr_api.validate_enabled;
1910: end if;
1911: --
1912: -- Set output parameters
1913: --

Line 1942: when hr_api.validate_enabled then

1938:
1939: --
1940: hr_utility.set_location(' Leaving:'||l_proc, 190);
1941: exception
1942: when hr_api.validate_enabled then
1943: --
1944: -- As the Validate_Enabled exception has been raised
1945: -- we must rollback to the savepoint
1946: --