DBA Data[Home] [Help]

APPS.PAY_PUC_BUS dependencies on HR_API

Line 50: hr_api.mandatory_arg_error

46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'user_column_id'
53: ,p_argument_value => p_user_column_id
54: );

Line 76: hr_api.set_security_group_id

72: close csr_sec_grp;
73: --
74: -- Set the security_group_id in CLIENT_INFO
75: --
76: hr_api.set_security_group_id
77: (p_security_group_id => l_security_group_id
78: );
79: end if;
80: --

Line 114: hr_api.mandatory_arg_error

110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Ensure that all the mandatory parameter are not null
113: --
114: hr_api.mandatory_arg_error
115: (p_api_name => l_proc
116: ,p_argument => 'user_column_id'
117: ,p_argument_value => p_user_column_id
118: );

Line 120: if ( nvl(pay_puc_bus.g_user_column_id, hr_api.g_number)

116: ,p_argument => 'user_column_id'
117: ,p_argument_value => p_user_column_id
118: );
119: --
120: if ( nvl(pay_puc_bus.g_user_column_id, hr_api.g_number)
121: = p_user_column_id) then
122: --
123: -- The legislation code has already been found with a previous
124: -- call to this function. Just return the value in the global

Line 206: if nvl(p_rec.business_group_id, hr_api.g_number) <>

202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: if nvl(p_rec.business_group_id, hr_api.g_number) <>
207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'BUSINESS_GROUP_ID'

Line 207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then

203: fnd_message.raise_error;
204: END IF;
205: --
206: if nvl(p_rec.business_group_id, hr_api.g_number) <>
207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'BUSINESS_GROUP_ID'
211: ,p_base_table => pay_puc_shd.g_tab_nam

Line 208: hr_api.argument_changed_error

204: END IF;
205: --
206: if nvl(p_rec.business_group_id, hr_api.g_number) <>
207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'BUSINESS_GROUP_ID'
211: ,p_base_table => pay_puc_shd.g_tab_nam
212: );

Line 215: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

211: ,p_base_table => pay_puc_shd.g_tab_nam
212: );
213: end if;
214: --
215: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
216: nvl(pay_puc_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'LEGISLATION_CODE'

Line 216: nvl(pay_puc_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

212: );
213: end if;
214: --
215: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
216: nvl(pay_puc_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'LEGISLATION_CODE'
220: ,p_base_table => pay_puc_shd.g_tab_nam

Line 217: hr_api.argument_changed_error

213: end if;
214: --
215: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
216: nvl(pay_puc_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'LEGISLATION_CODE'
220: ,p_base_table => pay_puc_shd.g_tab_nam
221: );

Line 224: if nvl(p_rec.user_table_id, hr_api.g_number) <>

220: ,p_base_table => pay_puc_shd.g_tab_nam
221: );
222: end if;
223: --
224: if nvl(p_rec.user_table_id, hr_api.g_number) <>
225: pay_puc_shd.g_old_rec.user_table_id then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'USER_TABLE_ID'

Line 226: hr_api.argument_changed_error

222: end if;
223: --
224: if nvl(p_rec.user_table_id, hr_api.g_number) <>
225: pay_puc_shd.g_old_rec.user_table_id then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'USER_TABLE_ID'
229: ,p_base_table => pay_puc_shd.g_tab_nam
230: );

Line 301: hr_api.mandatory_arg_error

297: begin
298: --
299: -- USER_TABLE_ID is mandatory.
300: --
301: hr_api.mandatory_arg_error
302: (p_api_name => l_proc
303: ,p_argument => 'USER_TABLE_ID'
304: ,p_argument_value => p_user_table_id
305: );

Line 373: puc.legislation_code = hr_api.return_legislation_code(p_business_group_id )))

369: or ( p_business_group_id is not null and p_business_group_id = puc.business_group_id )
370: or ( p_business_group_id is not null and
371: puc.legislation_code is null and puc.business_group_id is null )
372: or ( p_business_group_id is not null and
373: puc.legislation_code = hr_api.return_legislation_code(p_business_group_id )))
374: and (p_legislation_code is null
375: or ( p_legislation_code is not null and p_legislation_code = puc.legislation_code )
376: or ( p_legislation_code is not null and
377: puc.legislation_code is null and puc.business_group_id is null)

Line 379: p_legislation_code = hr_api.return_legislation_code(puc.business_group_id )));

375: or ( p_legislation_code is not null and p_legislation_code = puc.legislation_code )
376: or ( p_legislation_code is not null and
377: puc.legislation_code is null and puc.business_group_id is null)
378: or ( p_legislation_code is not null and
379: p_legislation_code = hr_api.return_legislation_code(puc.business_group_id )));
380: --
381: l_proc varchar2(100) := g_package || 'chk_user_column_name';
382: l_name varchar2(200);
383: l_exists varchar2(1);

Line 393: nvl(p_user_column_name, hr_api.g_varchar2) <>

389: not pay_puc_shd.api_updating
390: (p_user_column_id => p_user_column_id
391: ,p_object_version_number => p_object_version_number
392: ) or
393: nvl(p_user_column_name, hr_api.g_varchar2) <>
394: pay_puc_shd.g_old_rec.user_column_name
395: ) then
396: --
397: -- The name is mandatory.

Line 399: hr_api.mandatory_arg_error

395: ) then
396: --
397: -- The name is mandatory.
398: --
399: hr_api.mandatory_arg_error
400: (p_api_name => l_proc
401: ,p_argument => 'USER_COLUMN_NAME'
402: ,p_argument_value => p_user_column_name
403: );

Line 475: nvl(p_formula_id, hr_api.g_number) <>

471: ,p_object_version_number => p_object_version_number
472: );
473: --
474: if not l_updating or
475: nvl(p_formula_id, hr_api.g_number) <>
476: nvl(pay_puc_shd.g_old_rec.formula_id, hr_api.g_number) then
477: --
478: -- No need to warn and do anything further if no formula is to be
479: -- referenced.

Line 476: nvl(pay_puc_shd.g_old_rec.formula_id, hr_api.g_number) then

472: );
473: --
474: if not l_updating or
475: nvl(p_formula_id, hr_api.g_number) <>
476: nvl(pay_puc_shd.g_old_rec.formula_id, hr_api.g_number) then
477: --
478: -- No need to warn and do anything further if no formula is to be
479: -- referenced.
480: --

Line 650: hr_api.validate_bus_grp_id

646: NOT IN ('GENERIC','STARTUP') THEN
647: --
648: -- Validate Important Attributes
649: --
650: hr_api.validate_bus_grp_id
651: (p_business_group_id => p_rec.business_group_id
652: ,p_associated_column1 => pay_puc_shd.g_tab_nam
653: || '.BUSINESS_GROUP_ID');
654: --

Line 729: hr_api.validate_bus_grp_id

725: NOT IN ('GENERIC','STARTUP') THEN
726: --
727: -- Validate Important Attributes
728: --
729: hr_api.validate_bus_grp_id
730: (p_business_group_id => p_rec.business_group_id
731: ,p_associated_column1 => pay_puc_shd.g_tab_nam
732: || '.BUSINESS_GROUP_ID');
733: --