APPS.PAY_SDB_BUS dependencies on HR_API

Line 62: if nvl(p_rec.balance_type_id, hr_api.g_number) <>

58: close csr_disallow_update;
59: --
60: -- p_balance_type_id
61: --
62: if nvl(p_rec.balance_type_id, hr_api.g_number) <>
63: nvl(pay_sdb_shd.g_old_rec.balance_type_id, hr_api.g_number)
64: then
65: hr_utility.set_location(l_proc, 25);
66: l_argument := 'p_balance_type_id';

Line 63: nvl(pay_sdb_shd.g_old_rec.balance_type_id, hr_api.g_number)

59: --
60: -- p_balance_type_id
61: --
62: if nvl(p_rec.balance_type_id, hr_api.g_number) <>
63: nvl(pay_sdb_shd.g_old_rec.balance_type_id, hr_api.g_number)
64: then
65: hr_utility.set_location(l_proc, 25);
66: l_argument := 'p_balance_type_id';
67: raise l_error;

Line 73: hr_api.argument_changed_error

69: hr_utility.set_location(' Leaving:'||l_proc, 25);
70: exception
71: when l_error then
72: hr_utility.set_location('Leaving:'||l_proc, 30);
73: hr_api.argument_changed_error
74: (p_api_name => l_proc
75: ,p_argument => l_argument);
76: when others then
77: hr_utility.set_location('Leaving:'||l_proc, 35);

Line 111: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

107: l_api_updating := pay_sdb_shd.api_updating
108: (p_defined_balance_id => p_defined_balance_id
109: ,p_object_version_number => p_object_version_number
110: );
111: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
112: nvl(pay_sdb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
113: not l_api_updating
114: then
115: if p_exclusion_rule_id is not null then

Line 112: nvl(pay_sdb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

108: (p_defined_balance_id => p_defined_balance_id
109: ,p_object_version_number => p_object_version_number
110: );
111: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
112: nvl(pay_sdb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
113: not l_api_updating
114: then
115: if p_exclusion_rule_id is not null then
116: open csr_exclusion_rule_id_valid;

Line 151: hr_api.mandatory_arg_error

147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- Check that the balance type is not null.
150: --
151: hr_api.mandatory_arg_error
152: (p_api_name => l_proc
153: ,p_argument => 'p_balance_type_id'
154: ,p_argument_value => p_balance_type_id
155: );

Line 199: if (l_api_updating and nvl(p_dimension_name, hr_api.g_varchar2)

195: l_api_updating := pay_sdb_shd.api_updating
196: (p_defined_balance_id => p_defined_balance_id
197: ,p_object_version_number => p_object_version_number
198: );
199: if (l_api_updating and nvl(p_dimension_name, hr_api.g_varchar2)
200: <> nvl(pay_sdb_shd.g_old_rec.dimension_name, hr_api.g_varchar2))
201: or not l_api_updating
202: then
203: --

Line 200: <> nvl(pay_sdb_shd.g_old_rec.dimension_name, hr_api.g_varchar2))

196: (p_defined_balance_id => p_defined_balance_id
197: ,p_object_version_number => p_object_version_number
198: );
199: if (l_api_updating and nvl(p_dimension_name, hr_api.g_varchar2)
200: <> nvl(pay_sdb_shd.g_old_rec.dimension_name, hr_api.g_varchar2))
201: or not l_api_updating
202: then
203: --
204: -- Check that the balance dimension is not null.

Line 206: hr_api.mandatory_arg_error

202: then
203: --
204: -- Check that the balance dimension is not null.
205: --
206: hr_api.mandatory_arg_error
207: (p_api_name => l_proc
208: ,p_argument => 'p_dimension_name'
209: ,p_argument_value => p_dimension_name
210: );

Line 246: nvl(p_force_latest_balance_flag, hr_api.g_varchar2) <>

242: (p_defined_balance_id => p_defined_balance_id
243: ,p_object_version_number => p_object_version_number
244: );
245: if (l_api_updating and
246: nvl(p_force_latest_balance_flag, hr_api.g_varchar2) <>
247: nvl(pay_sdb_shd.g_old_rec.force_latest_balance_flag, hr_api.g_varchar2))
248: or not l_api_updating
249: then
250: if p_force_latest_balance_flag is not null then

Line 247: nvl(pay_sdb_shd.g_old_rec.force_latest_balance_flag, hr_api.g_varchar2))

243: ,p_object_version_number => p_object_version_number
244: );
245: if (l_api_updating and
246: nvl(p_force_latest_balance_flag, hr_api.g_varchar2) <>
247: nvl(pay_sdb_shd.g_old_rec.force_latest_balance_flag, hr_api.g_varchar2))
248: or not l_api_updating
249: then
250: if p_force_latest_balance_flag is not null then
251: --

Line 254: if hr_api.not_exists_in_hr_lookups

250: if p_force_latest_balance_flag is not null then
251: --
252: -- Validate against hr_lookups.
253: --
254: if hr_api.not_exists_in_hr_lookups
255: (p_effective_date => p_effective_date
256: ,p_lookup_type => 'YES_NO'
257: ,p_lookup_code => p_force_latest_balance_flag
258: )

Line 290: nvl(p_grossup_allowed_flag, hr_api.g_varchar2) <>

286: (p_defined_balance_id => p_defined_balance_id
287: ,p_object_version_number => p_object_version_number
288: );
289: if (l_api_updating and
290: nvl(p_grossup_allowed_flag, hr_api.g_varchar2) <>
291: nvl(pay_sdb_shd.g_old_rec.grossup_allowed_flag, hr_api.g_varchar2))
292: or not l_api_updating
293: then
294: if p_grossup_allowed_flag is not null then

Line 291: nvl(pay_sdb_shd.g_old_rec.grossup_allowed_flag, hr_api.g_varchar2))

287: ,p_object_version_number => p_object_version_number
288: );
289: if (l_api_updating and
290: nvl(p_grossup_allowed_flag, hr_api.g_varchar2) <>
291: nvl(pay_sdb_shd.g_old_rec.grossup_allowed_flag, hr_api.g_varchar2))
292: or not l_api_updating
293: then
294: if p_grossup_allowed_flag is not null then
295: --

Line 298: if hr_api.not_exists_in_hr_lookups

294: if p_grossup_allowed_flag is not null then
295: --
296: -- Validate against hr_lookups.
297: --
298: if hr_api.not_exists_in_hr_lookups
299: (p_effective_date => p_effective_date
300: ,p_lookup_type => 'YES_NO'
301: ,p_lookup_code => p_grossup_allowed_flag
302: )