APPS.PAY_SGB_BUS dependencies on HR_API

Line 63: if nvl(p_rec.source_id, hr_api.g_number) <>

59: END IF;
60: --
61: -- p_source_id
62: --
63: if nvl(p_rec.source_id, hr_api.g_number) <>
64: nvl(pay_sgb_shd.g_old_rec.source_id, hr_api.g_number)
65: then
66: l_argument := 'p_source_id';
67: raise l_error;

Line 64: nvl(pay_sgb_shd.g_old_rec.source_id, hr_api.g_number)

60: --
61: -- p_source_id
62: --
63: if nvl(p_rec.source_id, hr_api.g_number) <>
64: nvl(pay_sgb_shd.g_old_rec.source_id, hr_api.g_number)
65: then
66: l_argument := 'p_source_id';
67: raise l_error;
68: end if;

Line 73: hr_api.argument_changed_error

69: --
70: --
71: EXCEPTION
72: WHEN l_error THEN
73: hr_api.argument_changed_error
74: (p_api_name => l_proc
75: ,p_argument => l_argument);
76: WHEN OTHERS THEN
77: RAISE;

Line 102: hr_api.mandatory_arg_error

98: hr_utility.set_location('Entering:'||l_proc, 5);
99: --
100: -- Check that the source_id is not null.
101: --
102: hr_api.mandatory_arg_error
103: (p_api_name => l_proc
104: ,p_argument => 'SOURCE_ID'
105: ,p_argument_value => p_source_id
106: );

Line 156: hr_api.mandatory_arg_error

152: if p_balance_type_id is null then
153: --
154: -- Balance type name is mandatory
155: --
156: hr_api.mandatory_arg_error
157: (p_api_name => l_proc
158: ,p_argument => 'BALANCE_TYPE_NAME'
159: ,p_argument_value => p_balance_type_name
160: );

Line 200: hr_api.mandatory_arg_error

196: if p_balance_type_name is null then
197: --
198: -- Balance type ID is mandatory
199: --
200: hr_api.mandatory_arg_error
201: (p_api_name => l_proc
202: ,p_argument => 'BALANCE_TYPE_ID'
203: ,p_argument_value => p_balance_type_id
204: );

Line 207: if (l_api_updating and nvl(p_balance_type_id, hr_api.g_number) <>

203: ,p_argument_value => p_balance_type_id
204: );
205: end if;
206: --
207: if (l_api_updating and nvl(p_balance_type_id, hr_api.g_number) <>
208: nvl(pay_sgb_shd.g_old_rec.balance_type_id, hr_api.g_number)) or
209: not l_api_updating
210: then
211: if p_balance_type_id is not null then

Line 208: nvl(pay_sgb_shd.g_old_rec.balance_type_id, hr_api.g_number)) or

204: );
205: end if;
206: --
207: if (l_api_updating and nvl(p_balance_type_id, hr_api.g_number) <>
208: nvl(pay_sgb_shd.g_old_rec.balance_type_id, hr_api.g_number)) or
209: not l_api_updating
210: then
211: if p_balance_type_id is not null then
212: open c_bal_type_id_valid;

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

251: l_api_updating := pay_sgb_shd.api_updating
252: (p_grossup_balances_id => p_grossup_balances_id
253: ,p_object_version_number => p_object_version_number
254: );
255: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
256: nvl(pay_sgb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
257: not l_api_updating
258: then
259: if p_exclusion_rule_id is not null then

Line 256: nvl(pay_sgb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

252: (p_grossup_balances_id => p_grossup_balances_id
253: ,p_object_version_number => p_object_version_number
254: );
255: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
256: nvl(pay_sgb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
257: not l_api_updating
258: then
259: if p_exclusion_rule_id is not null then
260: open c_exclusion_rule_id_valid;