61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64:
65: if nvl(p_rec.option_type_id, hr_api.g_number) <>
66: nvl(hr_opt_shd.g_old_rec.option_type_id
67: ,hr_api.g_number
68: ) then
69: hr_api.argument_changed_error
63: END IF;
64:
65: if nvl(p_rec.option_type_id, hr_api.g_number) <>
66: nvl(hr_opt_shd.g_old_rec.option_type_id
67: ,hr_api.g_number
68: ) then
69: hr_api.argument_changed_error
70: (p_api_name => l_proc
71: ,p_argument => 'OPTION_TYPE_ID'
65: if nvl(p_rec.option_type_id, hr_api.g_number) <>
66: nvl(hr_opt_shd.g_old_rec.option_type_id
67: ,hr_api.g_number
68: ) then
69: hr_api.argument_changed_error
70: (p_api_name => l_proc
71: ,p_argument => 'OPTION_TYPE_ID'
72: ,p_base_table => hr_opt_shd.g_tab_nam
73: );
72: ,p_base_table => hr_opt_shd.g_tab_nam
73: );
74: end if;
75:
76: if nvl(p_rec.option_level, hr_api.g_number) <>
77: nvl(hr_opt_shd.g_old_rec.option_level
78: ,hr_api.g_number
79: ) then
80: hr_api.argument_changed_error
74: end if;
75:
76: if nvl(p_rec.option_level, hr_api.g_number) <>
77: nvl(hr_opt_shd.g_old_rec.option_level
78: ,hr_api.g_number
79: ) then
80: hr_api.argument_changed_error
81: (p_api_name => l_proc
82: ,p_argument => 'OPTION_LEVEL'
76: if nvl(p_rec.option_level, hr_api.g_number) <>
77: nvl(hr_opt_shd.g_old_rec.option_level
78: ,hr_api.g_number
79: ) then
80: hr_api.argument_changed_error
81: (p_api_name => l_proc
82: ,p_argument => 'OPTION_LEVEL'
83: ,p_base_table => hr_opt_shd.g_tab_nam
84: );
84: );
85: end if;
86:
87:
88: if nvl(p_rec.option_level_id, hr_api.g_varchar2) <>
89: nvl(hr_opt_shd.g_old_rec.option_level_id
90: ,hr_api.g_varchar2
91: ) then
92: hr_api.argument_changed_error
86:
87:
88: if nvl(p_rec.option_level_id, hr_api.g_varchar2) <>
89: nvl(hr_opt_shd.g_old_rec.option_level_id
90: ,hr_api.g_varchar2
91: ) then
92: hr_api.argument_changed_error
93: (p_api_name => l_proc
94: ,p_argument => 'OPTION_LEVEL_ID'
88: if nvl(p_rec.option_level_id, hr_api.g_varchar2) <>
89: nvl(hr_opt_shd.g_old_rec.option_level_id
90: ,hr_api.g_varchar2
91: ) then
92: hr_api.argument_changed_error
93: (p_api_name => l_proc
94: ,p_argument => 'OPTION_LEVEL_ID'
95: ,p_base_table => hr_opt_shd.g_tab_nam
96: );
95: ,p_base_table => hr_opt_shd.g_tab_nam
96: );
97: end if;
98:
99: if nvl(p_rec.integration_id, hr_api.g_number) <>
100: nvl(hr_opt_shd.g_old_rec.integration_id
101: ,hr_api.g_number
102: ) then
103: hr_api.argument_changed_error
97: end if;
98:
99: if nvl(p_rec.integration_id, hr_api.g_number) <>
100: nvl(hr_opt_shd.g_old_rec.integration_id
101: ,hr_api.g_number
102: ) then
103: hr_api.argument_changed_error
104: (p_api_name => l_proc
105: ,p_argument => 'INTEGRATION_ID'
99: if nvl(p_rec.integration_id, hr_api.g_number) <>
100: nvl(hr_opt_shd.g_old_rec.integration_id
101: ,hr_api.g_number
102: ) then
103: hr_api.argument_changed_error
104: (p_api_name => l_proc
105: ,p_argument => 'INTEGRATION_ID'
106: ,p_base_table => hr_opt_shd.g_tab_nam
107: );
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc,10);
149:
150: hr_api.mandatory_arg_error
151: (p_api_name => l_proc
152: ,p_argument => 'OPTION_TYPE_ID'
153: ,p_argument_value => p_option_type_id
154: );
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211:
212: hr_api.mandatory_arg_error
213: (p_api_name => l_proc
214: ,p_argument => 'OPTION_LEVEL'
215: ,p_argument_value => p_option_level
216: );
218:
219: hr_utility.set_location('validating:'||l_proc,20);
220:
221: --Is it neccessary to validate against not_exists_in_fnd_lookups?
222: if hr_api.not_exists_in_hrstanlookups
223: (p_effective_date => p_effective_date
224: ,p_lookup_type => 'HR_KPI_OPTION_LEVEL'
225: ,p_lookup_code => p_option_level
226: ) then
325: --check if level is NOT SITE
326: IF p_option_level <> l_site_value THEN
327:
328: --level_id should not be null
329: hr_api.mandatory_arg_error
330: (p_api_name => l_proc
331: ,p_argument => 'OPTION_LEVEL_ID'
332: ,p_argument_value => p_option_level_id
333: );
470: Begin
471: hr_utility.set_location('Entering:'||l_proc,10);
472:
473: --encrypted column should not be null
474: hr_api.mandatory_arg_error
475: (p_api_name => l_proc
476: ,p_argument => 'ENCRYPTED'
477: ,p_argument_value => p_encrypted
478: );
539: hr_utility.set_location('Entering:'||l_proc,10);
540:
541: --integration_id should not be null
542:
543: hr_api.mandatory_arg_error
544: (p_api_name => l_proc
545: ,p_argument => 'INTEGRATION_ID'
546: ,p_argument_value => p_integration_id
547: );