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.OTA_TCC_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'cross_charge_id'
47: ,p_argument_value => p_cross_charge_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'cross_charge_id'
107: ,p_argument_value => p_cross_charge_id
108: );

Line 110: if ( nvl(ota_tcc_bus.g_cross_charge_id, hr_api.g_number)

106: ,p_argument => 'cross_charge_id'
107: ,p_argument_value => p_cross_charge_id
108: );
109: --
110: if ( nvl(ota_tcc_bus.g_cross_charge_id, hr_api.g_number)
111: = p_cross_charge_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 204: hr_api.argument_changed_error

200: -- not been updated.
201: --
202: EXCEPTION
203: WHEN l_error THEN
204: hr_api.argument_changed_error
205: (p_api_name => l_proc
206: ,p_argument => l_argument);
207: WHEN OTHERS THEN
208: RAISE;

Line 234: (p_start_date_active between start_date_active and nvl(end_date_active, hr_api.g_eot) or

230: Business_group_id = p_business_group_id and
231: gl_Set_of_books_id = p_gl_set_of_books_id and
232: From_to = p_from_to and
233: type = p_type and
234: (p_start_date_active between start_date_active and nvl(end_date_active, hr_api.g_eot) or
235: nvl(p_end_date_active,hr_api.g_eot) between start_date_active and nvl(end_date_active, hr_api.g_eot));
236: -- bug no 4587140
237: /* ((start_date_active <= p_start_date_active and
238: start_date_active <= nvl(end_date_active,hr_api.g_date) ) or

Line 235: nvl(p_end_date_active,hr_api.g_eot) between start_date_active and nvl(end_date_active, hr_api.g_eot));

231: gl_Set_of_books_id = p_gl_set_of_books_id and
232: From_to = p_from_to and
233: type = p_type and
234: (p_start_date_active between start_date_active and nvl(end_date_active, hr_api.g_eot) or
235: nvl(p_end_date_active,hr_api.g_eot) between start_date_active and nvl(end_date_active, hr_api.g_eot));
236: -- bug no 4587140
237: /* ((start_date_active <= p_start_date_active and
238: start_date_active <= nvl(end_date_active,hr_api.g_date) ) or
239: (start_date_active >= p_start_date_active and

Line 238: start_date_active <= nvl(end_date_active,hr_api.g_date) ) or

234: (p_start_date_active between start_date_active and nvl(end_date_active, hr_api.g_eot) or
235: nvl(p_end_date_active,hr_api.g_eot) between start_date_active and nvl(end_date_active, hr_api.g_eot));
236: -- bug no 4587140
237: /* ((start_date_active <= p_start_date_active and
238: start_date_active <= nvl(end_date_active,hr_api.g_date) ) or
239: (start_date_active >= p_start_date_active and
240: nvl(p_end_date_active,hr_api.g_eot) >= start_date_active ));
241:
242: */

Line 240: nvl(p_end_date_active,hr_api.g_eot) >= start_date_active ));

236: -- bug no 4587140
237: /* ((start_date_active <= p_start_date_active and
238: start_date_active <= nvl(end_date_active,hr_api.g_date) ) or
239: (start_date_active >= p_start_date_active and
240: nvl(p_end_date_active,hr_api.g_eot) >= start_date_active ));
241:
242: */
243: /* ((start_date_active <= p_start_date_active and
244: nvl(end_date_active,hr_api.g_date) >= nvl(p_end_date_active,hr_api.g_date)) or

Line 244: nvl(end_date_active,hr_api.g_date) >= nvl(p_end_date_active,hr_api.g_date)) or

240: nvl(p_end_date_active,hr_api.g_eot) >= start_date_active ));
241:
242: */
243: /* ((start_date_active <= p_start_date_active and
244: nvl(end_date_active,hr_api.g_date) >= nvl(p_end_date_active,hr_api.g_date)) or
245: (start_date_active >= p_start_date_active and
246: start_date_active <= nvl(p_end_date_active,hr_api.g_eot)) or
247: (start_date_active <= p_start_date_active and
248: nvl(end_date_active,hr_api.g_date) <= nvl(p_end_date_active,hr_api.g_date) and

Line 246: start_date_active <= nvl(p_end_date_active,hr_api.g_eot)) or

242: */
243: /* ((start_date_active <= p_start_date_active and
244: nvl(end_date_active,hr_api.g_date) >= nvl(p_end_date_active,hr_api.g_date)) or
245: (start_date_active >= p_start_date_active and
246: start_date_active <= nvl(p_end_date_active,hr_api.g_eot)) or
247: (start_date_active <= p_start_date_active and
248: nvl(end_date_active,hr_api.g_date) <= nvl(p_end_date_active,hr_api.g_date) and
249: nvl(end_date_active,hr_api.g_date) >= p_start_date_active )) ; */
250:

Line 248: nvl(end_date_active,hr_api.g_date) <= nvl(p_end_date_active,hr_api.g_date) and

244: nvl(end_date_active,hr_api.g_date) >= nvl(p_end_date_active,hr_api.g_date)) or
245: (start_date_active >= p_start_date_active and
246: start_date_active <= nvl(p_end_date_active,hr_api.g_eot)) or
247: (start_date_active <= p_start_date_active and
248: nvl(end_date_active,hr_api.g_date) <= nvl(p_end_date_active,hr_api.g_date) and
249: nvl(end_date_active,hr_api.g_date) >= p_start_date_active )) ; */
250:
251: Begin
252: hr_utility.set_location(' entering:'||l_proc, 10);

Line 249: nvl(end_date_active,hr_api.g_date) >= p_start_date_active )) ; */

245: (start_date_active >= p_start_date_active and
246: start_date_active <= nvl(p_end_date_active,hr_api.g_eot)) or
247: (start_date_active <= p_start_date_active and
248: nvl(end_date_active,hr_api.g_date) <= nvl(p_end_date_active,hr_api.g_date) and
249: nvl(end_date_active,hr_api.g_date) >= p_start_date_active )) ; */
250:
251: Begin
252: hr_utility.set_location(' entering:'||l_proc, 10);
253:

Line 255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>

251: Begin
252: hr_utility.set_location(' entering:'||l_proc, 10);
253:
254: if (((p_cross_charge_id is not null) and
255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>
256: nvl(p_start_date_active,hr_api.g_date) or
257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then

Line 256: nvl(p_start_date_active,hr_api.g_date) or

252: hr_utility.set_location(' entering:'||l_proc, 10);
253:
254: if (((p_cross_charge_id is not null) and
255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>
256: nvl(p_start_date_active,hr_api.g_date) or
257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then
260:

Line 257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>

253:
254: if (((p_cross_charge_id is not null) and
255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>
256: nvl(p_start_date_active,hr_api.g_date) or
257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then
260:
261: If ota_tcc_shd.g_old_rec.end_date_active is not null and

Line 258: nvl(p_end_date_active,hr_api.g_date)) )

254: if (((p_cross_charge_id is not null) and
255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>
256: nvl(p_start_date_active,hr_api.g_date) or
257: nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then
260:
261: If ota_tcc_shd.g_old_rec.end_date_active is not null and
262: nvl(p_end_date_active,hr_api.g_date) >

Line 262: nvl(p_end_date_active,hr_api.g_date) >

258: nvl(p_end_date_active,hr_api.g_date)) )
259: or (p_cross_charge_id is null)) then
260:
261: If ota_tcc_shd.g_old_rec.end_date_active is not null and
262: nvl(p_end_date_active,hr_api.g_date) >
263: ota_tcc_shd.g_old_rec.end_date_active then
264:
265: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
266: fnd_message.raise_error;

Line 299: (nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>

295: Begin
296: hr_utility.set_location(' entering:'||l_proc, 10);
297:
298: if (((p_cross_charge_id is not null) and
299: (nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
300: nvl(p_end_date_active,hr_api.g_date)))
301: or (p_cross_charge_id is null)) then
302:
303: If ota_tcc_shd.g_old_rec.end_date_active is not null and

Line 300: nvl(p_end_date_active,hr_api.g_date)))

296: hr_utility.set_location(' entering:'||l_proc, 10);
297:
298: if (((p_cross_charge_id is not null) and
299: (nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
300: nvl(p_end_date_active,hr_api.g_date)))
301: or (p_cross_charge_id is null)) then
302:
303: If ota_tcc_shd.g_old_rec.end_date_active is not null and
304: nvl(p_end_date_active,hr_api.g_date) >

Line 304: nvl(p_end_date_active,hr_api.g_date) >

300: nvl(p_end_date_active,hr_api.g_date)))
301: or (p_cross_charge_id is null)) then
302:
303: If ota_tcc_shd.g_old_rec.end_date_active is not null and
304: nvl(p_end_date_active,hr_api.g_date) >
305: ota_tcc_shd.g_old_rec.end_date_active then
306:
307: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
308: fnd_message.raise_error;

Line 337: nvl(ota_tcc_shd.g_old_rec.type,hr_api.g_varchar2) <>

333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334:
335:
336: if (((p_cross_charge_id is not null) and
337: nvl(ota_tcc_shd.g_old_rec.type,hr_api.g_varchar2) <>
338: nvl(p_type,hr_api.g_varchar2))
339: or
340: (p_cross_charge_id is null)) then
341:

Line 338: nvl(p_type,hr_api.g_varchar2))

334:
335:
336: if (((p_cross_charge_id is not null) and
337: nvl(ota_tcc_shd.g_old_rec.type,hr_api.g_varchar2) <>
338: nvl(p_type,hr_api.g_varchar2))
339: or
340: (p_cross_charge_id is null)) then
341:
342: hr_utility.set_location(' entering:'||l_proc, 20);

Line 349: if hr_api.not_exists_in_hrstanlookups

345: -- check if the type value exists in hr_lookups
346: -- where lookup_type is 'OTA_CROSS_CHARGE_TYPE'
347: --
348: if p_type is not null then
349: if hr_api.not_exists_in_hrstanlookups
350: (p_effective_date => p_effective_date
351: ,p_lookup_type => 'OTA_CROSS_CHARGE_TYPE'
352: ,p_lookup_code => p_type) then
353: fnd_message.set_name('OTA','OTA_13334_TCC_TYPE_INVALID');

Line 383: nvl(ota_tcc_shd.g_old_rec.from_to,hr_api.g_varchar2) <>

379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380:
381:
382: if (((p_cross_charge_id is not null) and
383: nvl(ota_tcc_shd.g_old_rec.from_to,hr_api.g_varchar2) <>
384: nvl(p_from_to,hr_api.g_varchar2))
385: or
386: (p_cross_charge_id is null)) then
387:

Line 384: nvl(p_from_to,hr_api.g_varchar2))

380:
381:
382: if (((p_cross_charge_id is not null) and
383: nvl(ota_tcc_shd.g_old_rec.from_to,hr_api.g_varchar2) <>
384: nvl(p_from_to,hr_api.g_varchar2))
385: or
386: (p_cross_charge_id is null)) then
387:
388: hr_utility.set_location(' entering:'||l_proc, 20);

Line 395: if hr_api.not_exists_in_hrstanlookups

391: -- check if the from_to value exists in hr_lookups
392: -- where lookup_type is 'OTA_CROSS_CHARGE_FROM_TO'
393: --
394: if p_from_to is not null then
395: if hr_api.not_exists_in_hrstanlookups
396: (p_effective_date => p_effective_date
397: ,p_lookup_type => 'OTA_CROSS_CHARGE_FROM_TO'
398: ,p_lookup_code => p_from_to) then
399: fnd_message.set_name('OTA','OTA_13341_TCC_FROM_TO_INVALID');

Line 447: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

443: (p_cross_charge_id => p_rec.cross_charge_id
444: ,p_type => p_rec.type
445: ,p_effective_date => p_effective_date);
446:
447: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
448: --
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 10);
451: End insert_validate;

Line 468: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Call all supporting business operations
467: --
468: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
469: --
470: chk_non_updateable_args
471: (p_effective_date => p_effective_date
472: ,p_rec => p_rec