DBA Data[Home] [Help]

APPS.HR_UPLOAD_PROPOSAL_API dependencies on HR_API

Line 1079: when hr_api.cannot_find_prog_unit then

1075: ,p_component_id_10 => p_component_id_10
1076: ,p_ppc_object_version_number_10 => p_ppc_object_version_number_10
1077: );
1078: exception
1079: when hr_api.cannot_find_prog_unit then
1080: hr_api.cannot_find_prog_unit_error
1081: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1082: ,p_hook_type => 'BP'
1083: );

Line 1080: hr_api.cannot_find_prog_unit_error

1076: ,p_ppc_object_version_number_10 => p_ppc_object_version_number_10
1077: );
1078: exception
1079: when hr_api.cannot_find_prog_unit then
1080: hr_api.cannot_find_prog_unit_error
1081: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1082: ,p_hook_type => 'BP'
1083: );
1084: --

Line 1216: if l_next_sal_review_date = hr_api.g_date then

1212: else
1213: --
1214: -- p_next_sal_review_date is being set to null if it is
1215: -- defaulted to EOT
1216: if l_next_sal_review_date = hr_api.g_date then
1217: l_next_sal_review_date := null;
1218: end if;
1219: --
1220: -- This means that the record need to be inserted

Line 1471: if l_next_sal_review_date = hr_api.g_date then

1467: hr_utility.set_location(l_proc,85);
1468: --
1469: end if;
1470: --
1471: if l_next_sal_review_date = hr_api.g_date then
1472: l_next_sal_review_date := null;
1473: end if;
1474:
1475: -- insert an unapproved single component salary proposal record in

Line 1592: nvl(l_change_amount,hr_api.g_number)

1588: --
1589: -- Do nothing if the component has not changed at all.
1590: --
1591: if (l_component_reason = l_component_reason_in AND
1592: nvl(l_change_amount,hr_api.g_number)
1593: = nvl(l_change_amount_in,hr_api.g_number) AND
1594: nvl(l_change_percentage,hr_api.g_number)
1595: = nvl(l_change_percentage_in,hr_api.g_number) AND
1596: l_ppc_approved = l_approved_in ) then

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

1589: -- Do nothing if the component has not changed at all.
1590: --
1591: if (l_component_reason = l_component_reason_in AND
1592: nvl(l_change_amount,hr_api.g_number)
1593: = nvl(l_change_amount_in,hr_api.g_number) AND
1594: nvl(l_change_percentage,hr_api.g_number)
1595: = nvl(l_change_percentage_in,hr_api.g_number) AND
1596: l_ppc_approved = l_approved_in ) then
1597: --

Line 1594: nvl(l_change_percentage,hr_api.g_number)

1590: --
1591: if (l_component_reason = l_component_reason_in AND
1592: nvl(l_change_amount,hr_api.g_number)
1593: = nvl(l_change_amount_in,hr_api.g_number) AND
1594: nvl(l_change_percentage,hr_api.g_number)
1595: = nvl(l_change_percentage_in,hr_api.g_number) AND
1596: l_ppc_approved = l_approved_in ) then
1597: --
1598: -- this means that the component has not changed

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

1591: if (l_component_reason = l_component_reason_in AND
1592: nvl(l_change_amount,hr_api.g_number)
1593: = nvl(l_change_amount_in,hr_api.g_number) AND
1594: nvl(l_change_percentage,hr_api.g_number)
1595: = nvl(l_change_percentage_in,hr_api.g_number) AND
1596: l_ppc_approved = l_approved_in ) then
1597: --
1598: -- this means that the component has not changed
1599: -- we just adding the amount.

Line 1606: nvl(l_change_amount,hr_api.g_number)

1602: l_component_sum
1603: := l_component_sum + l_change_amount;
1604: --
1605: elsif (l_component_reason = l_component_reason_in AND
1606: nvl(l_change_amount,hr_api.g_number)
1607: = nvl(l_change_amount_in,hr_api.g_number) AND
1608: nvl(l_change_percentage,hr_api.g_number)
1609: = nvl(l_change_percentage_in,hr_api.g_number) AND
1610: l_ppc_approved <> l_approved_in ) then

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

1603: := l_component_sum + l_change_amount;
1604: --
1605: elsif (l_component_reason = l_component_reason_in AND
1606: nvl(l_change_amount,hr_api.g_number)
1607: = nvl(l_change_amount_in,hr_api.g_number) AND
1608: nvl(l_change_percentage,hr_api.g_number)
1609: = nvl(l_change_percentage_in,hr_api.g_number) AND
1610: l_ppc_approved <> l_approved_in ) then
1611: --

Line 1608: nvl(l_change_percentage,hr_api.g_number)

1604: --
1605: elsif (l_component_reason = l_component_reason_in AND
1606: nvl(l_change_amount,hr_api.g_number)
1607: = nvl(l_change_amount_in,hr_api.g_number) AND
1608: nvl(l_change_percentage,hr_api.g_number)
1609: = nvl(l_change_percentage_in,hr_api.g_number) AND
1610: l_ppc_approved <> l_approved_in ) then
1611: --
1612: -- this means that the component approval status has changed.

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

1605: elsif (l_component_reason = l_component_reason_in AND
1606: nvl(l_change_amount,hr_api.g_number)
1607: = nvl(l_change_amount_in,hr_api.g_number) AND
1608: nvl(l_change_percentage,hr_api.g_number)
1609: = nvl(l_change_percentage_in,hr_api.g_number) AND
1610: l_ppc_approved <> l_approved_in ) then
1611: --
1612: -- this means that the component approval status has changed.
1613: -- We need to update the record.Set the update flag to true.

Line 1626: nvl(l_change_amount,hr_api.g_number)

1622: -- issue an error if updating an approved component
1623: --
1624: elsif (l_ppc_approved = 'Y' AND
1625: (l_component_reason <> l_component_reason_in OR
1626: nvl(l_change_amount,hr_api.g_number)
1627: <> nvl(l_change_amount_in,hr_api.g_number) OR
1628: nvl(l_change_percentage,hr_api.g_number)
1629: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1630: hr_utility.set_location(l_proc,140);

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

1623: --
1624: elsif (l_ppc_approved = 'Y' AND
1625: (l_component_reason <> l_component_reason_in OR
1626: nvl(l_change_amount,hr_api.g_number)
1627: <> nvl(l_change_amount_in,hr_api.g_number) OR
1628: nvl(l_change_percentage,hr_api.g_number)
1629: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1630: hr_utility.set_location(l_proc,140);
1631: hr_utility.set_message(801,'HR_51454_PPC_CANT_UPD_COMP');

Line 1628: nvl(l_change_percentage,hr_api.g_number)

1624: elsif (l_ppc_approved = 'Y' AND
1625: (l_component_reason <> l_component_reason_in OR
1626: nvl(l_change_amount,hr_api.g_number)
1627: <> nvl(l_change_amount_in,hr_api.g_number) OR
1628: nvl(l_change_percentage,hr_api.g_number)
1629: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1630: hr_utility.set_location(l_proc,140);
1631: hr_utility.set_message(801,'HR_51454_PPC_CANT_UPD_COMP');
1632: hr_utility.raise_error;

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

1625: (l_component_reason <> l_component_reason_in OR
1626: nvl(l_change_amount,hr_api.g_number)
1627: <> nvl(l_change_amount_in,hr_api.g_number) OR
1628: nvl(l_change_percentage,hr_api.g_number)
1629: <> nvl(l_change_percentage_in,hr_api.g_number))) then
1630: hr_utility.set_location(l_proc,140);
1631: hr_utility.set_message(801,'HR_51454_PPC_CANT_UPD_COMP');
1632: hr_utility.raise_error;
1633: elsif (l_ppc_approved = 'N') then

Line 1926: when hr_api.cannot_find_prog_unit then

1922: ,p_pyp_proposed_sal_warning => l_pyp_proposed_sal_warning
1923: ,p_additional_comp_warning => l_additional_comp_warning
1924: );
1925: exception
1926: when hr_api.cannot_find_prog_unit then
1927: hr_api.cannot_find_prog_unit_error
1928: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1929: ,p_hook_type => 'AP'
1930: );

Line 1927: hr_api.cannot_find_prog_unit_error

1923: ,p_additional_comp_warning => l_additional_comp_warning
1924: );
1925: exception
1926: when hr_api.cannot_find_prog_unit then
1927: hr_api.cannot_find_prog_unit_error
1928: (p_module_name => 'UPLOAD_SALARY_PROPOSAL'
1929: ,p_hook_type => 'AP'
1930: );
1931: --

Line 1939: raise hr_api.validate_enabled;

1935: --
1936: -- when in validation only mode raise the Validate_Enabled exception
1937: --
1938: if p_validate then
1939: raise hr_api.validate_enabled;
1940: end if;
1941: --
1942: -- Set output parameters
1943: --

Line 1972: when hr_api.validate_enabled then

1968:
1969: --
1970: hr_utility.set_location(' Leaving:'||l_proc, 190);
1971: exception
1972: when hr_api.validate_enabled then
1973: --
1974: -- As the Validate_Enabled exception has been raised
1975: -- we must rollback to the savepoint
1976: --