DBA Data[Home] [Help]

APPS.IRC_ITA_BUS dependencies on HR_API

Line 53: hr_api.mandatory_arg_error

49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error
54: (p_api_name => l_proc
55: ,p_argument => 'template_association_id'
56: ,p_argument_value => p_template_association_id
57: );

Line 80: hr_api.set_security_group_id

76: close csr_sec_grp;
77: --
78: -- Set the security_group_id in CLIENT_INFO
79: --
80: hr_api.set_security_group_id
81: (p_security_group_id => l_security_group_id
82: );
83: --
84: -- Set the sessions legislation context in HR_SESSION_DATA

Line 86: hr_api.set_legislation_context(l_legislation_code);

82: );
83: --
84: -- Set the sessions legislation context in HR_SESSION_DATA
85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --

Line 128: hr_api.mandatory_arg_error

124: hr_utility.set_location('Entering:'|| l_proc, 10);
125: --
126: -- Ensure that all the mandatory parameter are not null
127: --
128: hr_api.mandatory_arg_error
129: (p_api_name => l_proc
130: ,p_argument => 'template_association_id'
131: ,p_argument_value => p_template_association_id
132: );

Line 134: if ( nvl(irc_ita_bus.g_template_association_id, hr_api.g_number)

130: ,p_argument => 'template_association_id'
131: ,p_argument_value => p_template_association_id
132: );
133: --
134: if ( nvl(irc_ita_bus.g_template_association_id, hr_api.g_number)
135: = p_template_association_id) then
136: --
137: -- The legislation code has already been found with a previous
138: -- call to this function. Just return the value in the global

Line 225: hr_api.argument_changed_error

221: END IF;
222: --
223: --
224: if irc_ita_shd.g_old_rec.template_association_id <> p_rec.template_association_id then
225: hr_api.argument_changed_error
226: (p_api_name => l_proc
227: ,p_argument => 'template_association_id'
228: ,p_base_table => irc_ita_shd.g_tab_nam
229: );

Line 234: hr_api.argument_changed_error

230: end if;
231: --
232: exception
233: when l_error then
234: hr_api.argument_changed_error
235: (p_api_name => l_proc
236: ,p_argument => l_argument);
237: when others then
238: raise;

Line 288: nvl(irc_ita_shd.g_old_rec.template_id,hr_api.g_number) <>

284: ,p_object_version_number => p_object_version_number);
285: hr_utility.set_location(l_proc,20);
286: if ((l_api_updating
287: and
288: nvl(irc_ita_shd.g_old_rec.template_id,hr_api.g_number) <>
289: nvl(p_template_id, hr_api.g_number))
290: or
291: (NOT l_api_updating)) then
292: --

Line 289: nvl(p_template_id, hr_api.g_number))

285: hr_utility.set_location(l_proc,20);
286: if ((l_api_updating
287: and
288: nvl(irc_ita_shd.g_old_rec.template_id,hr_api.g_number) <>
289: nvl(p_template_id, hr_api.g_number))
290: or
291: (NOT l_api_updating)) then
292: --
293: if(p_template_id is not null)

Line 379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)

375: --
376:
377: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_organization_id is not null)
378: or (irc_ita_shd.g_old_rec.template_association_id is not null
379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)
380: <> nvl(p_organization_id, hr_api.g_number))) then
381: --
382: hr_utility.set_location(l_proc, 20);
383: --

Line 380: <> nvl(p_organization_id, hr_api.g_number))) then

376:
377: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_organization_id is not null)
378: or (irc_ita_shd.g_old_rec.template_association_id is not null
379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)
380: <> nvl(p_organization_id, hr_api.g_number))) then
381: --
382: hr_utility.set_location(l_proc, 20);
383: --
384: -- Check that the organization ID is linked to a

Line 463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)

459: --
460:
461: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_job_id is not null)
462: or (irc_ita_shd.g_old_rec.template_association_id is not null
463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)
464: <> nvl(p_job_id, hr_api.g_number))) then
465: --
466: hr_utility.set_location(l_proc, 20);
467: --

Line 464: <> nvl(p_job_id, hr_api.g_number))) then

460:
461: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_job_id is not null)
462: or (irc_ita_shd.g_old_rec.template_association_id is not null
463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)
464: <> nvl(p_job_id, hr_api.g_number))) then
465: --
466: hr_utility.set_location(l_proc, 20);
467: --
468: -- Check that the job ID is linked to a

Line 551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)

547: --
548:
549: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_position_id is not null)
550: or (irc_ita_shd.g_old_rec.template_association_id is not null
551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)
552: <> nvl(p_position_id, hr_api.g_number))) then
553: --
554: hr_utility.set_location(l_proc, 20);
555: --

Line 552: <> nvl(p_position_id, hr_api.g_number))) then

548:
549: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_position_id is not null)
550: or (irc_ita_shd.g_old_rec.template_association_id is not null
551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)
552: <> nvl(p_position_id, hr_api.g_number))) then
553: --
554: hr_utility.set_location(l_proc, 20);
555: --
556: -- Check that the Position ID is linked to a

Line 854: if ((nvl(p_default_association,hr_api.g_varchar2) <>

850: --
851: -- Check if the value for default_association is set on insert or has
852: -- changed on update.
853: --
854: if ((nvl(p_default_association,hr_api.g_varchar2) <>
855: nvl(irc_ita_shd.g_old_rec.default_association,hr_api.g_varchar2)
856: and l_api_updating) or
857: (NOT l_api_updating))
858:

Line 855: nvl(irc_ita_shd.g_old_rec.default_association,hr_api.g_varchar2)

851: -- Check if the value for default_association is set on insert or has
852: -- changed on update.
853: --
854: if ((nvl(p_default_association,hr_api.g_varchar2) <>
855: nvl(irc_ita_shd.g_old_rec.default_association,hr_api.g_varchar2)
856: and l_api_updating) or
857: (NOT l_api_updating))
858:
859: then

Line 865: if hr_api.not_exists_in_hr_lookups

861: -- Check that default_association exists in hr_lookups for the
862: -- lookup type 'YES_NO' with an enabled flag set to 'Y'.
863: --
864: hr_utility.set_location(l_proc,30);
865: if hr_api.not_exists_in_hr_lookups
866: (p_lookup_type => 'YES_NO'
867: ,p_lookup_code => p_default_association
868: ,p_effective_date => p_creation_date
869: )

Line 941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>

937: --
938: hr_utility.set_location(l_proc,20);
939: if ((l_api_updating
940: and
941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>
942: nvl(p_start_date, hr_api.g_date) or
943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>
944: nvl(p_end_date, hr_api.g_date)))
945: or

Line 942: nvl(p_start_date, hr_api.g_date) or

938: hr_utility.set_location(l_proc,20);
939: if ((l_api_updating
940: and
941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>
942: nvl(p_start_date, hr_api.g_date) or
943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>
944: nvl(p_end_date, hr_api.g_date)))
945: or
946: (NOT l_api_updating)) then

Line 943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>

939: if ((l_api_updating
940: and
941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>
942: nvl(p_start_date, hr_api.g_date) or
943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>
944: nvl(p_end_date, hr_api.g_date)))
945: or
946: (NOT l_api_updating)) then
947: --

Line 944: nvl(p_end_date, hr_api.g_date)))

940: and
941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>
942: nvl(p_start_date, hr_api.g_date) or
943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>
944: nvl(p_end_date, hr_api.g_date)))
945: or
946: (NOT l_api_updating)) then
947: --
948: hr_utility.set_location(l_proc,30);

Line 953: if (p_start_date > nvl(p_end_date,hr_api.g_eot))

949: if (p_start_date is not null)
950: then
951: hr_utility.set_location(l_proc,40);
952: --
953: if (p_start_date > nvl(p_end_date,hr_api.g_eot))
954: then
955: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');
956: hr_multi_message.add
957: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.START_DATE'