APPS.PAY_SIR_BUS dependencies on HR_API

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

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

Line 64: nvl(pay_sir_shd.g_old_rec.element_type_id, hr_api.g_number)

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

Line 72: hr_api.argument_changed_error

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

Line 100: hr_api.mandatory_arg_error

96: hr_utility.set_location('Entering:'||l_proc, 5);
97: --
98: -- Check that the element type is not null.
99: --
100: hr_api.mandatory_arg_error
101: (p_api_name => l_proc
102: ,p_argument => 'ELEMENT_TYPE_ID'
103: ,p_argument_value => p_element_type_id
104: );

Line 142: if (l_api_updating and nvl(p_result_name, hr_api.g_varchar2) <>

138: l_api_updating := pay_sir_shd.api_updating
139: (p_iterative_rule_id => p_iterative_rule_id
140: ,p_object_version_number => p_object_version_number
141: );
142: if (l_api_updating and nvl(p_result_name, hr_api.g_varchar2) <>
143: nvl(pay_sir_shd.g_old_rec.result_name, hr_api.g_varchar2)) or
144: not l_api_updating
145: then
146: --

Line 143: nvl(pay_sir_shd.g_old_rec.result_name, hr_api.g_varchar2)) or

139: (p_iterative_rule_id => p_iterative_rule_id
140: ,p_object_version_number => p_object_version_number
141: );
142: if (l_api_updating and nvl(p_result_name, hr_api.g_varchar2) <>
143: nvl(pay_sir_shd.g_old_rec.result_name, hr_api.g_varchar2)) or
144: not l_api_updating
145: then
146: --
147: -- Check that the name format is correct (not null database item name).

Line 197: if (l_api_updating and nvl(p_input_value_id, hr_api.g_number) <>

193: l_api_updating := pay_sir_shd.api_updating
194: (p_iterative_rule_id => p_iterative_rule_id
195: ,p_object_version_number => p_object_version_number
196: );
197: if (l_api_updating and nvl(p_input_value_id, hr_api.g_number) <>
198: nvl(pay_sir_shd.g_old_rec.input_value_id, hr_api.g_number)) or
199: not l_api_updating
200: then
201: if p_input_value_id is not null then

Line 198: nvl(pay_sir_shd.g_old_rec.input_value_id, hr_api.g_number)) or

194: (p_iterative_rule_id => p_iterative_rule_id
195: ,p_object_version_number => p_object_version_number
196: );
197: if (l_api_updating and nvl(p_input_value_id, hr_api.g_number) <>
198: nvl(pay_sir_shd.g_old_rec.input_value_id, hr_api.g_number)) or
199: not l_api_updating
200: then
201: if p_input_value_id is not null then
202: --

Line 237: if (l_api_updating and nvl(p_iterative_rule_type, hr_api.g_varchar2) <>

233: l_api_updating := pay_sir_shd.api_updating
234: (p_iterative_rule_id => p_iterative_rule_id
235: ,p_object_version_number => p_object_version_number
236: );
237: if (l_api_updating and nvl(p_iterative_rule_type, hr_api.g_varchar2) <>
238: nvl(pay_sir_shd.g_old_rec.iterative_rule_type, hr_api.g_varchar2)) or
239: not l_api_updating
240: then
241: --

Line 238: nvl(pay_sir_shd.g_old_rec.iterative_rule_type, hr_api.g_varchar2)) or

234: (p_iterative_rule_id => p_iterative_rule_id
235: ,p_object_version_number => p_object_version_number
236: );
237: if (l_api_updating and nvl(p_iterative_rule_type, hr_api.g_varchar2) <>
238: nvl(pay_sir_shd.g_old_rec.iterative_rule_type, hr_api.g_varchar2)) or
239: not l_api_updating
240: then
241: --
242: -- Iterative rule type is mandatory.

Line 244: hr_api.mandatory_arg_error

240: then
241: --
242: -- Iterative rule type is mandatory.
243: --
244: hr_api.mandatory_arg_error
245: (p_api_name => l_proc
246: ,p_argument => 'ITERATIVE_RULE_TYPE'
247: ,p_argument_value => p_iterative_rule_type
248: );

Line 252: if hr_api.not_exists_in_hr_lookups

248: );
249: --
250: -- Validate against hr_lookups.
251: --
252: if hr_api.not_exists_in_hr_lookups
253: (p_effective_date => p_effective_date
254: ,p_lookup_type => 'ITERATIVE_RULE_TYPE'
255: ,p_lookup_code => p_iterative_rule_type
256: )

Line 287: if (l_api_updating and nvl(p_severity_level, hr_api.g_varchar2) <>

283: (p_iterative_rule_id => p_iterative_rule_id
284: ,p_object_version_number => p_object_version_number
285: );
286: --
287: if (l_api_updating and nvl(p_severity_level, hr_api.g_varchar2) <>
288: nvl(pay_sir_shd.g_old_rec.severity_level, hr_api.g_varchar2)) or
289: not l_api_updating
290: then
291: if p_severity_level is not null then

Line 288: nvl(pay_sir_shd.g_old_rec.severity_level, hr_api.g_varchar2)) or

284: ,p_object_version_number => p_object_version_number
285: );
286: --
287: if (l_api_updating and nvl(p_severity_level, hr_api.g_varchar2) <>
288: nvl(pay_sir_shd.g_old_rec.severity_level, hr_api.g_varchar2)) or
289: not l_api_updating
290: then
291: if p_severity_level is not null then
292: --

Line 295: if hr_api.not_exists_in_hr_lookups

291: if p_severity_level is not null then
292: --
293: -- Validate against hr_lookups.
294: --
295: if hr_api.not_exists_in_hr_lookups
296: (p_effective_date => p_effective_date
297: ,p_lookup_type => 'MESSAGE_LEVEL'
298: ,p_lookup_code => p_severity_level
299: )

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

337: l_api_updating := pay_sir_shd.api_updating
338: (p_iterative_rule_id => p_iterative_rule_id
339: ,p_object_version_number => p_object_version_number
340: );
341: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
342: nvl(pay_sir_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
343: not l_api_updating
344: then
345: if p_exclusion_rule_id is not null then

Line 342: nvl(pay_sir_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

338: (p_iterative_rule_id => p_iterative_rule_id
339: ,p_object_version_number => p_object_version_number
340: );
341: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
342: nvl(pay_sir_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
343: not l_api_updating
344: then
345: if p_exclusion_rule_id is not null then
346: open c_exclusion_rule_is_valid;