eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ESU_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

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

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: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

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

Line 122: if ( nvl(pay_esu_bus.g_element_span_usage_id, hr_api.g_number)

118: ,p_argument => 'element_span_usage_id'
119: ,p_argument_value => p_element_span_usage_id
120: );
121: --
122: if ( nvl(pay_esu_bus.g_element_span_usage_id, hr_api.g_number)
123: = p_element_span_usage_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

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

209: END IF;
210: --
211: hr_utility.set_location(l_proc, 10);
212: --
213: if nvl(p_rec.business_group_id, hr_api.g_number) <>
214: nvl(pay_esu_shd.g_old_rec.business_group_id, hr_api.g_number) then
215: l_argument := 'business_group_id';
216: raise l_error;
217: end if;

Line 214: nvl(pay_esu_shd.g_old_rec.business_group_id, hr_api.g_number) then

210: --
211: hr_utility.set_location(l_proc, 10);
212: --
213: if nvl(p_rec.business_group_id, hr_api.g_number) <>
214: nvl(pay_esu_shd.g_old_rec.business_group_id, hr_api.g_number) then
215: l_argument := 'business_group_id';
216: raise l_error;
217: end if;
218: hr_utility.set_location(l_proc, 15);

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

216: raise l_error;
217: end if;
218: hr_utility.set_location(l_proc, 15);
219: --
220: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
221: nvl(pay_esu_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
222: l_argument := 'legislation_code';
223: raise l_error;
224: end if;

Line 221: nvl(pay_esu_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

217: end if;
218: hr_utility.set_location(l_proc, 15);
219: --
220: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
221: nvl(pay_esu_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
222: l_argument := 'legislation_code';
223: raise l_error;
224: end if;
225: hr_utility.set_location(l_proc, 20);

Line 227: if nvl(p_rec.retro_component_usage_id, hr_api.g_number) <>

223: raise l_error;
224: end if;
225: hr_utility.set_location(l_proc, 20);
226: --
227: if nvl(p_rec.retro_component_usage_id, hr_api.g_number) <>
228: nvl(pay_esu_shd.g_old_rec.retro_component_usage_id, hr_api.g_number) then
229: l_argument := 'retro_component_usage_id';
230: raise l_error;
231: end if;

Line 228: nvl(pay_esu_shd.g_old_rec.retro_component_usage_id, hr_api.g_number) then

224: end if;
225: hr_utility.set_location(l_proc, 20);
226: --
227: if nvl(p_rec.retro_component_usage_id, hr_api.g_number) <>
228: nvl(pay_esu_shd.g_old_rec.retro_component_usage_id, hr_api.g_number) then
229: l_argument := 'retro_component_usage_id';
230: raise l_error;
231: end if;
232: hr_utility.set_location(l_proc, 25);

Line 234: if nvl(p_rec.time_span_id, hr_api.g_number) <>

230: raise l_error;
231: end if;
232: hr_utility.set_location(l_proc, 25);
233: --
234: if nvl(p_rec.time_span_id, hr_api.g_number) <>
235: nvl(pay_esu_shd.g_old_rec.time_span_id, hr_api.g_number) then
236: l_argument := 'time_span_id';
237: raise l_error;
238: end if;

Line 235: nvl(pay_esu_shd.g_old_rec.time_span_id, hr_api.g_number) then

231: end if;
232: hr_utility.set_location(l_proc, 25);
233: --
234: if nvl(p_rec.time_span_id, hr_api.g_number) <>
235: nvl(pay_esu_shd.g_old_rec.time_span_id, hr_api.g_number) then
236: l_argument := 'time_span_id';
237: raise l_error;
238: end if;
239: hr_utility.set_location(l_proc, 30);

Line 243: hr_api.argument_changed_error

239: hr_utility.set_location(l_proc, 30);
240: --
241: exception
242: when l_error then
243: hr_api.argument_changed_error
244: (p_api_name => l_proc
245: ,p_argument => l_argument
246: );
247: when others then

Line 332: l_varchar2 varchar2(30) := hr_api.g_varchar2;

328: --
329: -- Declare local variables
330: --
331: l_proc varchar2(72) := g_package||'chk_retro_component_usage_id';
332: l_varchar2 varchar2(30) := hr_api.g_varchar2;
333: l_number number := hr_api.g_number;
334: l_exists varchar2(1);
335: l_legislation_code pay_element_span_usages.legislation_code%type;
336:

Line 333: l_number number := hr_api.g_number;

329: -- Declare local variables
330: --
331: l_proc varchar2(72) := g_package||'chk_retro_component_usage_id';
332: l_varchar2 varchar2(30) := hr_api.g_varchar2;
333: l_number number := hr_api.g_number;
334: l_exists varchar2(1);
335: l_legislation_code pay_element_span_usages.legislation_code%type;
336:
337: --

Line 354: hr_api.mandatory_arg_error

350: hr_utility.set_location('Entering:'|| l_proc, 10);
351: --
352: -- Check mandatory parameters have been set
353: --
354: hr_api.mandatory_arg_error
355: (p_api_name => l_proc
356: ,p_argument => 'retro_component_usage_id'
357: ,p_argument_value => p_retro_component_usage_id
358: );

Line 365: ,hr_api.return_legislation_code(p_business_group_id));

361: -- Set the legislation code
362: --
363: l_legislation_code
364: := nvl(p_legislation_code
365: ,hr_api.return_legislation_code(p_business_group_id));
366:
367: --
368: -- Check if the retro component usage exists.
369: --

Line 422: l_varchar2 varchar2(30) := hr_api.g_varchar2;

418: --
419: -- Declare local variables
420: --
421: l_proc varchar2(72) := g_package||'chk_time_span_id';
422: l_varchar2 varchar2(30) := hr_api.g_varchar2;
423: l_number number := hr_api.g_number;
424: l_exists varchar2(1);
425:
426: --

Line 423: l_number number := hr_api.g_number;

419: -- Declare local variables
420: --
421: l_proc varchar2(72) := g_package||'chk_time_span_id';
422: l_varchar2 varchar2(30) := hr_api.g_varchar2;
423: l_number number := hr_api.g_number;
424: l_exists varchar2(1);
425:
426: --
427: -- Cursor to check that a retro component exists.

Line 443: hr_api.mandatory_arg_error

439: hr_utility.set_location('Entering:'|| l_proc, 10);
440: --
441: -- Check mandatory parameters have been set
442: --
443: hr_api.mandatory_arg_error
444: (p_api_name => l_proc
445: ,p_argument => 'time_span_id'
446: ,p_argument_value => p_time_span_id
447: );

Line 448: hr_api.mandatory_arg_error

444: (p_api_name => l_proc
445: ,p_argument => 'time_span_id'
446: ,p_argument_value => p_time_span_id
447: );
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc
450: ,p_argument => 'retro_component_usage_id'
451: ,p_argument_value => p_retro_component_usage_id
452: );

Line 523: hr_api.mandatory_arg_error

519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: -- Check mandatory parameters have been set
522: --
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc
525: ,p_argument => 'effective_date'
526: ,p_argument_value => p_effective_date
527: );

Line 547: nvl(pay_esu_shd.g_old_rec.adjustment_type, hr_api.g_varchar2)

543: -- another not null value.
544: -- b) During insert, the value is not null.
545: --
546: if ((l_api_updating and
547: nvl(pay_esu_shd.g_old_rec.adjustment_type, hr_api.g_varchar2)
548: <> nvl(p_adjustment_type, hr_api.g_varchar2))
549: or
550: NOT l_api_updating) then
551: --

Line 548: <> nvl(p_adjustment_type, hr_api.g_varchar2))

544: -- b) During insert, the value is not null.
545: --
546: if ((l_api_updating and
547: nvl(pay_esu_shd.g_old_rec.adjustment_type, hr_api.g_varchar2)
548: <> nvl(p_adjustment_type, hr_api.g_varchar2))
549: or
550: NOT l_api_updating) then
551: --
552: hr_utility.set_location(l_proc, 30);

Line 560: if hr_api.not_exists_in_hr_lookups

556: -- Check if the adjustment_type value exists in hr_lookups
557: -- where the lookup_type is 'RETRO_ADJUSTMENT_TYPE'
558: --
559: if p_adjustment_type is not null then
560: if hr_api.not_exists_in_hr_lookups
561: (p_effective_date => p_effective_date
562: ,p_lookup_type => 'RETRO_ADJUSTMENT_TYPE'
563: ,p_lookup_code => p_adjustment_type
564: ) then

Line 623: l_varchar2 varchar2(30) := hr_api.g_varchar2;

619: --
620: -- Declare local variables
621: --
622: l_proc varchar2(72) := g_package||'chk_retro_element_type_id';
623: l_varchar2 varchar2(30) := hr_api.g_varchar2;
624: l_number number := hr_api.g_number;
625: l_exists varchar2(1);
626: l_api_updating boolean;
627: l_legislation_code pay_element_span_usages.legislation_code%type;

Line 624: l_number number := hr_api.g_number;

620: -- Declare local variables
621: --
622: l_proc varchar2(72) := g_package||'chk_retro_element_type_id';
623: l_varchar2 varchar2(30) := hr_api.g_varchar2;
624: l_number number := hr_api.g_number;
625: l_exists varchar2(1);
626: l_api_updating boolean;
627: l_legislation_code pay_element_span_usages.legislation_code%type;
628:

Line 648: hr_api.mandatory_arg_error

644: hr_utility.set_location('Entering:'|| l_proc, 10);
645: --
646: -- Check mandatory parameters have been set
647: --
648: hr_api.mandatory_arg_error
649: (p_api_name => l_proc
650: ,p_argument => 'retro_element_type_id'
651: ,p_argument_value => p_retro_element_type_id
652: );

Line 658: ,hr_api.return_legislation_code(p_business_group_id));

654: -- Set the legislation code
655: --
656: l_legislation_code
657: := nvl(p_legislation_code
658: ,hr_api.return_legislation_code(p_business_group_id));
659:
660: --
661: -- Check if the retro component usage is being updated and ensure that
662: -- g_old_rec contains the values for this retro_component_usage_id.

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_esu_shd.g_tab_nam
732: || '.BUSINESS_GROUP_ID');
733: --

Line 800: hr_api.validate_bus_grp_id

796: NOT IN ('GENERIC','STARTUP') THEN
797: --
798: -- Validate Important Attributes
799: --
800: hr_api.validate_bus_grp_id
801: (p_business_group_id => p_rec.business_group_id
802: ,p_associated_column1 => pay_esu_shd.g_tab_nam
803: || '.BUSINESS_GROUP_ID');
804: --