DBA Data[Home] [Help]

APPS.PAY_RETRO_STATUS_INTERNAL dependencies on HR_API

Line 381: l_leg_code := hr_api.return_legislation_code(p_business_group_id);

377: hr_utility.set_location('Entering:'|| l_proc, 10);
378:
379: if p_owner_type = g_user then
380:
381: l_leg_code := hr_api.return_legislation_code(p_business_group_id);
382:
383: pay_core_utils.get_legislation_rule
384: (p_legrul_name => 'RETRO_STATUS_USER_UPD'
385: ,p_legislation => l_leg_code

Line 413: if hr_api.not_exists_in_hr_lookups

409: end if;
410: elsif p_owner_type = g_system then
411: hr_utility.set_location(l_proc, 30);
412:
413: if hr_api.not_exists_in_hr_lookups
414: (trunc(sysdate), 'ADVANCE_RETRO_STATUS', p_approval_status) then
415:
416: l_inv_app_status := true;
417: end if;

Line 1015: hr_api.mandatory_arg_error

1011: hr_utility.set_location('Entering:'|| l_proc, 10);
1012: --
1013: -- Check mandatory parameters have been set
1014: --
1015: hr_api.mandatory_arg_error
1016: (p_api_name => l_proc
1017: ,p_argument => 'retro_component_id'
1018: ,p_argument_value => p_retro_component_id
1019: );

Line 1024: := hr_api.return_legislation_code(p_business_group_id);

1020: --
1021: -- Set the legislation code
1022: --
1023: l_legislation_code
1024: := hr_api.return_legislation_code(p_business_group_id);
1025: --
1026: -- Check if the retro component exists.
1027: --
1028: hr_utility.set_location(l_proc, 20);

Line 1157: When HR_Api.Object_Locked then

1153: p_old_rec := l_old_rec;
1154:
1155: hr_utility.set_location(' Leaving:'||l_proc, 40);
1156: Exception
1157: When HR_Api.Object_Locked then
1158: --
1159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1160: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1161: fnd_message.raise_error;

Line 1267: hr_api.mandatory_arg_error

1263: -- Issue a savepoint
1264: --
1265: savepoint rts_create_super_retro_asg;
1266:
1267: hr_api.mandatory_arg_error
1268: (p_api_name => l_proc
1269: ,p_argument => 'ASSIGNMENT_ID'
1270: ,p_argument_value => p_assignment_id
1271: );

Line 1289: hr_api.mandatory_arg_error

1285: if l_old_retro_asg_id is null then
1286: --
1287: -- Reprocess Date is mandatory
1288: --
1289: hr_api.mandatory_arg_error
1290: (p_api_name => l_proc
1291: ,p_argument => 'ASG REPROCESS_DATE'
1292: ,p_argument_value => p_reprocess_date
1293: );

Line 1478: ,p_reprocess_date in date default hr_api.g_date

1474: -- |---------------------------< update_retro_asg >---------------------------|
1475: -- ----------------------------------------------------------------------------
1476: procedure update_retro_asg
1477: (p_retro_assignment_id in number
1478: ,p_reprocess_date in date default hr_api.g_date
1479: ,p_start_date in date default hr_api.g_date
1480: ,p_approval_status in varchar2 default hr_api.g_varchar2
1481: ,p_owner_type in varchar2 default g_user
1482: )

Line 1479: ,p_start_date in date default hr_api.g_date

1475: -- ----------------------------------------------------------------------------
1476: procedure update_retro_asg
1477: (p_retro_assignment_id in number
1478: ,p_reprocess_date in date default hr_api.g_date
1479: ,p_start_date in date default hr_api.g_date
1480: ,p_approval_status in varchar2 default hr_api.g_varchar2
1481: ,p_owner_type in varchar2 default g_user
1482: )
1483: is

Line 1480: ,p_approval_status in varchar2 default hr_api.g_varchar2

1476: procedure update_retro_asg
1477: (p_retro_assignment_id in number
1478: ,p_reprocess_date in date default hr_api.g_date
1479: ,p_start_date in date default hr_api.g_date
1480: ,p_approval_status in varchar2 default hr_api.g_varchar2
1481: ,p_owner_type in varchar2 default g_user
1482: )
1483: is
1484: l_proc varchar2(72) := g_package||'update_retro_asg';

Line 1496: hr_api.mandatory_arg_error

1492: -- Issue a savepoint
1493: --
1494: savepoint rts_update_retro_asg;
1495: --
1496: hr_api.mandatory_arg_error
1497: (p_api_name => l_proc
1498: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1499: ,p_argument_value => p_retro_assignment_id
1500: );

Line 1524: ,hr_api.g_date

1520: --
1521: l_new_rec := l_old_rec;
1522: --
1523: l_new_rec.reprocess_date := decode_default(p_reprocess_date
1524: ,hr_api.g_date
1525: ,l_old_rec.reprocess_date);
1526: l_new_rec.start_date := decode_default(p_start_date
1527: ,hr_api.g_date
1528: ,l_old_rec.start_date);

Line 1527: ,hr_api.g_date

1523: l_new_rec.reprocess_date := decode_default(p_reprocess_date
1524: ,hr_api.g_date
1525: ,l_old_rec.reprocess_date);
1526: l_new_rec.start_date := decode_default(p_start_date
1527: ,hr_api.g_date
1528: ,l_old_rec.start_date);
1529: l_new_rec.approval_status := decode_default(p_approval_status
1530: ,hr_api.g_varchar2
1531: ,l_old_rec.approval_status);

Line 1530: ,hr_api.g_varchar2

1526: l_new_rec.start_date := decode_default(p_start_date
1527: ,hr_api.g_date
1528: ,l_old_rec.start_date);
1529: l_new_rec.approval_status := decode_default(p_approval_status
1530: ,hr_api.g_varchar2
1531: ,l_old_rec.approval_status);
1532: hr_utility.set_location(l_proc, 40);
1533: --
1534: -- Update validation.

Line 1546: ,hr_api.g_varchar2

1542: -- setting null if approval status is defaulted.
1543: --
1544: ,p_new_approval_status => decode_default
1545: (p_approval_status
1546: ,hr_api.g_varchar2
1547: ,null)
1548: ,p_owner_type => p_owner_type
1549: ,p_dml_mode => g_update
1550: );

Line 1585: ,hr_api.g_date

1581: -- If the start date was not specified, change the start date
1582: -- as well.
1583: --
1584: l_new_rec.start_date := decode_default(p_start_date
1585: ,hr_api.g_date
1586: ,l_new_rec.reprocess_date);
1587: end if;
1588:
1589: hr_utility.set_location(l_proc, 60);

Line 1718: hr_api.mandatory_arg_error

1714: -- Issue a savepoint
1715: --
1716: savepoint rts_delete_retro_asg;
1717: --
1718: hr_api.mandatory_arg_error
1719: (p_api_name => l_proc
1720: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1721: ,p_argument_value => p_retro_assignment_id
1722: );

Line 1816: hr_api.mandatory_arg_error

1812: -- Issue a savepoint
1813: --
1814: savepoint rts_delete_retro_asg_cascade;
1815: --
1816: hr_api.mandatory_arg_error
1817: (p_api_name => l_proc
1818: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1819: ,p_argument_value => p_retro_assignment_id
1820: );

Line 1879: When HR_Api.Object_Locked then

1875: p_old_rec := l_old_rec;
1876:
1877: hr_utility.set_location(' Leaving:'||l_proc, 40);
1878: Exception
1879: When HR_Api.Object_Locked then
1880: --
1881: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1882: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1883: fnd_message.raise_error;

Line 1896: ,p_system_reprocess_date in date default hr_api.g_eot

1892: ,p_reprocess_date in date
1893: ,p_effective_date in date default null
1894: ,p_retro_component_id in number default null
1895: ,p_owner_type in varchar2 default g_user
1896: ,p_system_reprocess_date in date default hr_api.g_eot
1897: ,p_entry_param_name in varchar2 default null
1898: )
1899: is
1900: l_proc varchar2(72) := g_package||'maintain_retro_entry';

Line 1923: hr_api.mandatory_arg_error

1919: -- Issue a savepoint
1920: --
1921: savepoint rts_maintain_retro_entry;
1922:
1923: hr_api.mandatory_arg_error
1924: (p_api_name => l_proc
1925: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1926: ,p_argument_value => p_retro_assignment_id
1927: );

Line 1929: hr_api.mandatory_arg_error

1925: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1926: ,p_argument_value => p_retro_assignment_id
1927: );
1928:
1929: hr_api.mandatory_arg_error
1930: (p_api_name => l_proc
1931: ,p_argument => 'ELEMENT_ENTRY_ID'
1932: ,p_argument_value => p_element_entry_id
1933: );

Line 1967: hr_api.mandatory_arg_error

1963: --
1964: -- Insert and update validations
1965: --
1966: if l_old_rec.retro_assignment_id is null then
1967: hr_api.mandatory_arg_error
1968: (p_api_name => l_proc
1969: ,p_argument => nvl(p_entry_param_name,'ENTRY')
1970: ||' REPROCESS_DATE'
1971: ,p_argument_value => p_reprocess_date

Line 2012: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);

2008: hr_utility.set_location(l_proc, 100);
2009: l_reprocess_date := nvl(p_reprocess_date, l_old_rec.reprocess_date);
2010:
2011: l_retro_component_id := p_retro_component_id;
2012: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
2013: --
2014: if p_retro_component_id is null then
2015: hr_utility.set_location(l_proc, 110);
2016: --

Line 2140: hr_api.mandatory_arg_error

2136: -- Issue a savepoint
2137: --
2138: savepoint rts_delete_retro_entry;
2139:
2140: hr_api.mandatory_arg_error
2141: (p_api_name => l_proc
2142: ,p_argument => 'RETRO_ASSIGNMENT_ID'
2143: ,p_argument_value => p_retro_assignment_id
2144: );

Line 2146: hr_api.mandatory_arg_error

2142: ,p_argument => 'RETRO_ASSIGNMENT_ID'
2143: ,p_argument_value => p_retro_assignment_id
2144: );
2145:
2146: hr_api.mandatory_arg_error
2147: (p_api_name => l_proc
2148: ,p_argument => 'ELEMENT_ENTRY_ID'
2149: ,p_argument_value => p_element_entry_id
2150: );

Line 2232: hr_api.mandatory_arg_error

2228: -- Issue a savepoint
2229: --
2230: savepoint rts_update_reprocess_date;
2231:
2232: hr_api.mandatory_arg_error
2233: (p_api_name => l_proc
2234: ,p_argument => 'ASSIGNMENT_ID'
2235: ,p_argument_value => p_assignment_id
2236: );