DBA Data[Home] [Help]

APPS.PER_ENV_BUS dependencies on HR_API

Line 48: hr_api.mandatory_arg_error

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

Line 74: hr_api.set_security_group_id

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

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 => 'cal_entry_value_id'
117: ,p_argument_value => p_cal_entry_value_id
118: );

Line 120: if ( nvl(per_env_bus.g_cal_entry_value_id, hr_api.g_number)

116: ,p_argument => 'cal_entry_value_id'
117: ,p_argument_value => p_cal_entry_value_id
118: );
119: --
120: if ( nvl(per_env_bus.g_cal_entry_value_id, hr_api.g_number)
121: = p_cal_entry_value_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 208: If nvl(p_rec.calendar_entry_id, hr_api.g_number) <>

204: fnd_message.raise_error;
205: END IF;
206: --
207: -- check parent Entry Id is not updated
208: If nvl(p_rec.calendar_entry_id, hr_api.g_number) <>
209: nvl(per_env_shd.g_old_rec.calendar_entry_id ,hr_api.g_number)
210: then
211: hr_api.argument_changed_error
212: (p_api_name => l_proc

Line 209: nvl(per_env_shd.g_old_rec.calendar_entry_id ,hr_api.g_number)

205: END IF;
206: --
207: -- check parent Entry Id is not updated
208: If nvl(p_rec.calendar_entry_id, hr_api.g_number) <>
209: nvl(per_env_shd.g_old_rec.calendar_entry_id ,hr_api.g_number)
210: then
211: hr_api.argument_changed_error
212: (p_api_name => l_proc
213: ,p_argument => 'CALENDAR_ENTRY_ID'

Line 211: hr_api.argument_changed_error

207: -- check parent Entry Id is not updated
208: If nvl(p_rec.calendar_entry_id, hr_api.g_number) <>
209: nvl(per_env_shd.g_old_rec.calendar_entry_id ,hr_api.g_number)
210: then
211: hr_api.argument_changed_error
212: (p_api_name => l_proc
213: ,p_argument => 'CALENDAR_ENTRY_ID'
214: ,p_base_table => 'PER_CAL_ENTRY_VALUES'
215: );

Line 332: hr_api.mandatory_arg_error

328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: hr_api.mandatory_arg_error
333: (p_api_name => l_proc
334: ,p_argument => 'calendar_entry_id'
335: ,p_argument_value => p_calendar_entry_id
336: );

Line 423: hr_api.mandatory_arg_error

419: Begin
420: --
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: hr_api.mandatory_arg_error
424: (p_api_name => l_proc
425: ,p_argument => 'calendar_entry_id'
426: ,p_argument_value => p_calendar_entry_id
427: );

Line 541: or (nvl(p_override_name,hr_api.g_varchar2)

537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: IF (p_cal_entry_value_id is NULL
540: or (p_usage_flag <> per_env_shd.g_old_rec.usage_flag)
541: or (nvl(p_override_name,hr_api.g_varchar2)
542: <> nvl(per_env_shd.g_old_rec.override_name,hr_api.g_varchar2))
543: or (nvl(p_override_type,hr_api.g_varchar2)
544: <> nvl(per_env_shd.g_old_rec.override_type,hr_api.g_varchar2)) )
545: THEN

Line 542: <> nvl(per_env_shd.g_old_rec.override_name,hr_api.g_varchar2))

538: --
539: IF (p_cal_entry_value_id is NULL
540: or (p_usage_flag <> per_env_shd.g_old_rec.usage_flag)
541: or (nvl(p_override_name,hr_api.g_varchar2)
542: <> nvl(per_env_shd.g_old_rec.override_name,hr_api.g_varchar2))
543: or (nvl(p_override_type,hr_api.g_varchar2)
544: <> nvl(per_env_shd.g_old_rec.override_type,hr_api.g_varchar2)) )
545: THEN
546:

Line 543: or (nvl(p_override_type,hr_api.g_varchar2)

539: IF (p_cal_entry_value_id is NULL
540: or (p_usage_flag <> per_env_shd.g_old_rec.usage_flag)
541: or (nvl(p_override_name,hr_api.g_varchar2)
542: <> nvl(per_env_shd.g_old_rec.override_name,hr_api.g_varchar2))
543: or (nvl(p_override_type,hr_api.g_varchar2)
544: <> nvl(per_env_shd.g_old_rec.override_type,hr_api.g_varchar2)) )
545: THEN
546:
547: IF p_usage_flag = 'O' and p_override_name is null and p_override_type is null then

Line 544: <> nvl(per_env_shd.g_old_rec.override_type,hr_api.g_varchar2)) )

540: or (p_usage_flag <> per_env_shd.g_old_rec.usage_flag)
541: or (nvl(p_override_name,hr_api.g_varchar2)
542: <> nvl(per_env_shd.g_old_rec.override_name,hr_api.g_varchar2))
543: or (nvl(p_override_type,hr_api.g_varchar2)
544: <> nvl(per_env_shd.g_old_rec.override_type,hr_api.g_varchar2)) )
545: THEN
546:
547: IF p_usage_flag = 'O' and p_override_name is null and p_override_type is null then
548: -- override must have a name or value - convert to MM

Line 567: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS

563: fnd_message.set_name('PER', 'HR_289994_CAL_OVERT_SET');
564: fnd_message.raise_error;
565: ELSE
566: -- check the value exists in lookups...
567: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS
568: (p_effective_date => p_effective_date
569: ,p_lookup_type => 'CALENDAR_ENTRY_TYPE'
570: ,p_lookup_code => p_override_type)
571: then

Line 649: or (nvl(p_parent_entry_value_id,hr_api.g_number)

645: hr_utility.set_location('Entering:'||l_proc, 5);
646: --
647: --
648: IF (p_cal_entry_value_id is NULL
649: or (nvl(p_parent_entry_value_id,hr_api.g_number)
650: <> nvl(per_env_shd.g_old_rec.parent_entry_value_id,hr_api.g_number))
651: or (nvl(p_usage_flag,hr_api.g_varchar2)
652: <> nvl(per_env_shd.g_old_rec.usage_flag,hr_api.g_varchar2)) )
653: THEN

Line 650: <> nvl(per_env_shd.g_old_rec.parent_entry_value_id,hr_api.g_number))

646: --
647: --
648: IF (p_cal_entry_value_id is NULL
649: or (nvl(p_parent_entry_value_id,hr_api.g_number)
650: <> nvl(per_env_shd.g_old_rec.parent_entry_value_id,hr_api.g_number))
651: or (nvl(p_usage_flag,hr_api.g_varchar2)
652: <> nvl(per_env_shd.g_old_rec.usage_flag,hr_api.g_varchar2)) )
653: THEN
654:

Line 651: or (nvl(p_usage_flag,hr_api.g_varchar2)

647: --
648: IF (p_cal_entry_value_id is NULL
649: or (nvl(p_parent_entry_value_id,hr_api.g_number)
650: <> nvl(per_env_shd.g_old_rec.parent_entry_value_id,hr_api.g_number))
651: or (nvl(p_usage_flag,hr_api.g_varchar2)
652: <> nvl(per_env_shd.g_old_rec.usage_flag,hr_api.g_varchar2)) )
653: THEN
654:
655:

Line 652: <> nvl(per_env_shd.g_old_rec.usage_flag,hr_api.g_varchar2)) )

648: IF (p_cal_entry_value_id is NULL
649: or (nvl(p_parent_entry_value_id,hr_api.g_number)
650: <> nvl(per_env_shd.g_old_rec.parent_entry_value_id,hr_api.g_number))
651: or (nvl(p_usage_flag,hr_api.g_varchar2)
652: <> nvl(per_env_shd.g_old_rec.usage_flag,hr_api.g_varchar2)) )
653: THEN
654:
655:
656: If p_usage_flag is null or p_usage_flag not in ('Y','N','O') then