DBA Data[Home] [Help]

APPS.PAY_TER_BUS dependencies on HR_API

Line 39: if nvl(p_rec.template_id, hr_api.g_number) <>

35: hr_utility.set_location(l_proc, 15);
36: --
37: -- p_template_id
38: --
39: if nvl(p_rec.template_id, hr_api.g_number) <>
40: nvl(pay_ter_shd.g_old_rec.template_id, hr_api.g_number)
41: then
42: l_argument := 'p_template_id';
43: raise l_error;

Line 40: nvl(pay_ter_shd.g_old_rec.template_id, hr_api.g_number)

36: --
37: -- p_template_id
38: --
39: if nvl(p_rec.template_id, hr_api.g_number) <>
40: nvl(pay_ter_shd.g_old_rec.template_id, hr_api.g_number)
41: then
42: l_argument := 'p_template_id';
43: raise l_error;
44: end if;

Line 49: hr_api.argument_changed_error

45: hr_utility.set_location(' Leaving:'||l_proc, 20);
46: exception
47: when l_error then
48: hr_utility.set_location('Leaving:'||l_proc, 25);
49: hr_api.argument_changed_error
50: (p_api_name => l_proc
51: ,p_argument => l_argument);
52: when others then
53: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 80: hr_api.mandatory_arg_error

76: hr_utility.set_location('Entering:'||l_proc, 5);
77: --
78: -- Check that template_id is not null.
79: --
80: hr_api.mandatory_arg_error
81: (p_api_name => l_proc
82: ,p_argument => 'p_template_id'
83: ,p_argument_value => p_template_id
84: );

Line 118: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =

114: from pay_shadow_element_types pset
115: , pay_shadow_input_values psiv
116: where pset.template_id = p_template_id
117: and psiv.element_type_id = pset.element_type_id
118: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =
119: upper(p_flexfield_column);
120: --
121: l_proc varchar2(72) := g_package||'chk_flexfield_column';
122: l_len number;

Line 135: if (l_api_updating and nvl(p_flexfield_column, hr_api.g_varchar2) <>

131: l_api_updating := pay_ter_shd.api_updating
132: (p_exclusion_rule_id => p_exclusion_rule_id
133: ,p_object_version_number => p_object_version_number
134: );
135: if (l_api_updating and nvl(p_flexfield_column, hr_api.g_varchar2) <>
136: nvl(pay_ter_shd.g_old_rec.flexfield_column, hr_api.g_varchar2)) or
137: not l_api_updating
138: then
139: --

Line 136: nvl(pay_ter_shd.g_old_rec.flexfield_column, hr_api.g_varchar2)) or

132: (p_exclusion_rule_id => p_exclusion_rule_id
133: ,p_object_version_number => p_object_version_number
134: );
135: if (l_api_updating and nvl(p_flexfield_column, hr_api.g_varchar2) <>
136: nvl(pay_ter_shd.g_old_rec.flexfield_column, hr_api.g_varchar2)) or
137: not l_api_updating
138: then
139: --
140: -- Check that the flexfield column is not null.

Line 142: hr_api.mandatory_arg_error

138: then
139: --
140: -- Check that the flexfield column is not null.
141: --
142: hr_api.mandatory_arg_error
143: (p_api_name => l_proc
144: ,p_argument => 'p_flexfield_column'
145: ,p_argument_value => p_flexfield_column
146: );

Line 208: if (l_api_updating and nvl(p_exclusion_value, hr_api.g_varchar2) <>

204: l_api_updating := pay_ter_shd.api_updating
205: (p_exclusion_rule_id => p_exclusion_rule_id
206: ,p_object_version_number => p_object_version_number
207: );
208: if (l_api_updating and nvl(p_exclusion_value, hr_api.g_varchar2) <>
209: nvl(pay_ter_shd.g_old_rec.exclusion_value, hr_api.g_varchar2)) or
210: not l_api_updating
211: then
212: --

Line 209: nvl(pay_ter_shd.g_old_rec.exclusion_value, hr_api.g_varchar2)) or

205: (p_exclusion_rule_id => p_exclusion_rule_id
206: ,p_object_version_number => p_object_version_number
207: );
208: if (l_api_updating and nvl(p_exclusion_value, hr_api.g_varchar2) <>
209: nvl(pay_ter_shd.g_old_rec.exclusion_value, hr_api.g_varchar2)) or
210: not l_api_updating
211: then
212: --
213: -- Check that the exclusion value is not null.

Line 215: hr_api.mandatory_arg_error

211: then
212: --
213: -- Check that the exclusion value is not null.
214: --
215: hr_api.mandatory_arg_error
216: (p_api_name => l_proc
217: ,p_argument => 'p_exclusion_value'
218: ,p_argument_value => p_exclusion_value
219: );