DBA Data[Home] [Help]

APPS.PAY_RETRO_STATUS_INTERNAL dependencies on HR_API

Line 357: if hr_api.not_exists_in_hr_lookups

353: begin
354: hr_utility.set_location('Entering:'|| l_proc, 10);
355:
356: /*Check if the provided status is available in lookups or not*/
357: if hr_api.not_exists_in_hr_lookups
358: (trunc(sysdate), 'ADVANCE_RETRO_STATUS', p_approval_status) then
359: hr_utility.set_location(l_proc, 20);
360: l_inv_app_status := true;
361: else

Line 983: hr_api.mandatory_arg_error

979: hr_utility.set_location('Entering:'|| l_proc, 10);
980: --
981: -- Check mandatory parameters have been set
982: --
983: hr_api.mandatory_arg_error
984: (p_api_name => l_proc
985: ,p_argument => 'retro_component_id'
986: ,p_argument_value => p_retro_component_id
987: );

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

988: --
989: -- Set the legislation code
990: --
991: l_legislation_code
992: := hr_api.return_legislation_code(p_business_group_id);
993: --
994: -- Check if the retro component exists.
995: --
996: hr_utility.set_location(l_proc, 20);

Line 1125: When HR_Api.Object_Locked then

1121: p_old_rec := l_old_rec;
1122:
1123: hr_utility.set_location(' Leaving:'||l_proc, 40);
1124: Exception
1125: When HR_Api.Object_Locked then
1126: --
1127: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1128: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1129: fnd_message.raise_error;

Line 1235: hr_api.mandatory_arg_error

1231: -- Issue a savepoint
1232: --
1233: savepoint rts_create_super_retro_asg;
1234:
1235: hr_api.mandatory_arg_error
1236: (p_api_name => l_proc
1237: ,p_argument => 'ASSIGNMENT_ID'
1238: ,p_argument_value => p_assignment_id
1239: );

Line 1257: hr_api.mandatory_arg_error

1253: if l_old_retro_asg_id is null then
1254: --
1255: -- Reprocess Date is mandatory
1256: --
1257: hr_api.mandatory_arg_error
1258: (p_api_name => l_proc
1259: ,p_argument => 'ASG REPROCESS_DATE'
1260: ,p_argument_value => p_reprocess_date
1261: );

Line 1444: ,p_reprocess_date in date default hr_api.g_date

1440: -- |---------------------------< update_retro_asg >---------------------------|
1441: -- ----------------------------------------------------------------------------
1442: procedure update_retro_asg
1443: (p_retro_assignment_id in number
1444: ,p_reprocess_date in date default hr_api.g_date
1445: ,p_start_date in date default hr_api.g_date
1446: ,p_approval_status in varchar2 default hr_api.g_varchar2
1447: ,p_owner_type in varchar2 default g_user
1448: )

Line 1445: ,p_start_date in date default hr_api.g_date

1441: -- ----------------------------------------------------------------------------
1442: procedure update_retro_asg
1443: (p_retro_assignment_id in number
1444: ,p_reprocess_date in date default hr_api.g_date
1445: ,p_start_date in date default hr_api.g_date
1446: ,p_approval_status in varchar2 default hr_api.g_varchar2
1447: ,p_owner_type in varchar2 default g_user
1448: )
1449: is

Line 1446: ,p_approval_status in varchar2 default hr_api.g_varchar2

1442: procedure update_retro_asg
1443: (p_retro_assignment_id in number
1444: ,p_reprocess_date in date default hr_api.g_date
1445: ,p_start_date in date default hr_api.g_date
1446: ,p_approval_status in varchar2 default hr_api.g_varchar2
1447: ,p_owner_type in varchar2 default g_user
1448: )
1449: is
1450: l_proc varchar2(72) := g_package||'update_retro_asg';

Line 1472: hr_api.mandatory_arg_error

1468: -- Issue a savepoint
1469: --
1470: savepoint rts_update_retro_asg;
1471: --
1472: hr_api.mandatory_arg_error
1473: (p_api_name => l_proc
1474: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1475: ,p_argument_value => p_retro_assignment_id
1476: );

Line 1500: ,hr_api.g_date

1496: --
1497: l_new_rec := l_old_rec;
1498: --
1499: l_new_rec.reprocess_date := decode_default(p_reprocess_date
1500: ,hr_api.g_date
1501: ,l_old_rec.reprocess_date);
1502: l_new_rec.start_date := decode_default(p_start_date
1503: ,hr_api.g_date
1504: ,l_old_rec.start_date);

Line 1503: ,hr_api.g_date

1499: l_new_rec.reprocess_date := decode_default(p_reprocess_date
1500: ,hr_api.g_date
1501: ,l_old_rec.reprocess_date);
1502: l_new_rec.start_date := decode_default(p_start_date
1503: ,hr_api.g_date
1504: ,l_old_rec.start_date);
1505: l_new_rec.approval_status := decode_default(p_approval_status
1506: ,hr_api.g_varchar2
1507: ,l_old_rec.approval_status);

Line 1506: ,hr_api.g_varchar2

1502: l_new_rec.start_date := decode_default(p_start_date
1503: ,hr_api.g_date
1504: ,l_old_rec.start_date);
1505: l_new_rec.approval_status := decode_default(p_approval_status
1506: ,hr_api.g_varchar2
1507: ,l_old_rec.approval_status);
1508: hr_utility.set_location(l_proc, 40);
1509: --
1510: -- Update validation.

Line 1522: ,hr_api.g_varchar2

1518: -- setting null if approval status is defaulted.
1519: --
1520: ,p_new_approval_status => decode_default
1521: (p_approval_status
1522: ,hr_api.g_varchar2
1523: ,null)
1524: ,p_owner_type => p_owner_type
1525: ,p_dml_mode => g_update
1526: );

Line 1559: ,hr_api.g_date

1555: -- If the start date was not specified, change the start date
1556: -- as well.
1557: --
1558: l_new_rec.start_date := decode_default(p_start_date
1559: ,hr_api.g_date
1560: ,l_new_rec.reprocess_date);
1561: end if;
1562:
1563: hr_utility.set_location(l_proc, 60);

Line 1755: hr_api.mandatory_arg_error

1751: -- Issue a savepoint
1752: --
1753: savepoint rts_delete_retro_asg;
1754: --
1755: hr_api.mandatory_arg_error
1756: (p_api_name => l_proc
1757: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1758: ,p_argument_value => p_retro_assignment_id
1759: );

Line 1861: hr_api.mandatory_arg_error

1857: -- Issue a savepoint
1858: --
1859: savepoint rts_delete_retro_asg_cascade;
1860: --
1861: hr_api.mandatory_arg_error
1862: (p_api_name => l_proc
1863: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1864: ,p_argument_value => p_retro_assignment_id
1865: );

Line 1924: When HR_Api.Object_Locked then

1920: p_old_rec := l_old_rec;
1921:
1922: hr_utility.set_location(' Leaving:'||l_proc, 40);
1923: Exception
1924: When HR_Api.Object_Locked then
1925: --
1926: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1927: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1928: fnd_message.raise_error;

Line 1941: ,p_system_reprocess_date in date default hr_api.g_eot

1937: ,p_reprocess_date in date
1938: ,p_effective_date in date default null
1939: ,p_retro_component_id in number default null
1940: ,p_owner_type in varchar2 default g_user
1941: ,p_system_reprocess_date in date default hr_api.g_eot
1942: ,p_entry_param_name in varchar2 default null
1943: )
1944: is
1945: l_proc varchar2(72) := g_package||'maintain_retro_entry';

Line 1968: hr_api.mandatory_arg_error

1964: -- Issue a savepoint
1965: --
1966: savepoint rts_maintain_retro_entry;
1967:
1968: hr_api.mandatory_arg_error
1969: (p_api_name => l_proc
1970: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1971: ,p_argument_value => p_retro_assignment_id
1972: );

Line 1974: hr_api.mandatory_arg_error

1970: ,p_argument => 'RETRO_ASSIGNMENT_ID'
1971: ,p_argument_value => p_retro_assignment_id
1972: );
1973:
1974: hr_api.mandatory_arg_error
1975: (p_api_name => l_proc
1976: ,p_argument => 'ELEMENT_ENTRY_ID'
1977: ,p_argument_value => p_element_entry_id
1978: );

Line 2012: hr_api.mandatory_arg_error

2008: --
2009: -- Insert and update validations
2010: --
2011: if l_old_rec.retro_assignment_id is null then
2012: hr_api.mandatory_arg_error
2013: (p_api_name => l_proc
2014: ,p_argument => nvl(p_entry_param_name,'ENTRY')
2015: ||' REPROCESS_DATE'
2016: ,p_argument_value => p_reprocess_date

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

2053: hr_utility.set_location(l_proc, 100);
2054: l_reprocess_date := nvl(p_reprocess_date, l_old_rec.reprocess_date);
2055:
2056: l_retro_component_id := p_retro_component_id;
2057: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
2058: --
2059: if p_retro_component_id is null then
2060: hr_utility.set_location(l_proc, 110);
2061: --

Line 2185: hr_api.mandatory_arg_error

2181: -- Issue a savepoint
2182: --
2183: savepoint rts_delete_retro_entry;
2184:
2185: hr_api.mandatory_arg_error
2186: (p_api_name => l_proc
2187: ,p_argument => 'RETRO_ASSIGNMENT_ID'
2188: ,p_argument_value => p_retro_assignment_id
2189: );

Line 2191: hr_api.mandatory_arg_error

2187: ,p_argument => 'RETRO_ASSIGNMENT_ID'
2188: ,p_argument_value => p_retro_assignment_id
2189: );
2190:
2191: hr_api.mandatory_arg_error
2192: (p_api_name => l_proc
2193: ,p_argument => 'ELEMENT_ENTRY_ID'
2194: ,p_argument_value => p_element_entry_id
2195: );

Line 2277: hr_api.mandatory_arg_error

2273: -- Issue a savepoint
2274: --
2275: savepoint rts_update_reprocess_date;
2276:
2277: hr_api.mandatory_arg_error
2278: (p_api_name => l_proc
2279: ,p_argument => 'ASSIGNMENT_ID'
2280: ,p_argument_value => p_assignment_id
2281: );