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_RUD_BUS dependencies on HR_UTILITY

Line 45: hr_utility.set_location('Entering:'|| l_proc, 10);

41: l_legislation_code varchar2(150);
42: --
43: begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --
49: hr_api.mandatory_arg_error

Line 85: hr_utility.set_location(' Leaving:'|| l_proc, 20);

81: --
82: hr_api.set_legislation_context(l_legislation_code);
83: end if;
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
86: --
87: end set_security_group_id;
88: --
89: -- ---------------------------------------------------------------------------

Line 116: hr_utility.set_location('Entering:'|| l_proc, 10);

112: l_proc varchar2(72) := g_package||'return_legislation_code';
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Ensure that all the mandatory parameter are not null
119: --
120: hr_api.mandatory_arg_error

Line 134: hr_utility.set_location(l_proc, 20);

130: -- call to this function. Just return the value in the global
131: -- variable.
132: --
133: l_legislation_code := ota_rud_bus.g_legislation_code;
134: hr_utility.set_location(l_proc, 20);
135: else
136: --
137: -- The ID is different to the last call to this function
138: -- or this is the first call to this function.

Line 151: hr_utility.set_location(l_proc,30);

147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
153: -- Set the global variables so the values are
154: -- available for the next call to this function.
155: --

Line 160: hr_utility.set_location(' Leaving:'|| l_proc, 40);

156: close csr_leg_code;
157: ota_rud_bus.g_resource_usage_id := p_resource_usage_id;
158: ota_rud_bus.g_legislation_code := l_legislation_code;
159: end if;
160: hr_utility.set_location(' Leaving:'|| l_proc, 40);
161: return l_legislation_code;
162: end return_legislation_code;
163: --
164: -- ----------------------------------------------------------------------------

Line 187: hr_utility.set_location ('Entering:' || l_proc, 5);

183: and rud.offering_id = p_offering_id;
184: --
185: begin
186: --
187: hr_utility.set_location ('Entering:' || l_proc, 5);
188: --
189: open c1;
190: fetch c1
191: into l_ok;

Line 197: hr_utility.set_location (' leaving:' || l_proc, 10);

193: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_PK');
194: end if;
195: close c1;
196: --
197: hr_utility.set_location (' leaving:' || l_proc, 10);
198: --
199: end check_unique_key;
200: --
201: -- ----------------------------------------------------------------------------

Line 218: hr_utility.set_location ('entering:' || l_proc, 5);

214: --
215: --
216: begin
217: --
218: hr_utility.set_location ('entering:' || l_proc, 5);
219: --
220: if (p_start_date
221: > nvl (p_end_date, to_date ('31-12-4712', 'DD-MM-YYYY'))) then
222: ota_rud_shd.constraint_error ('OTA_RUD_DATES');

Line 225: hr_utility.set_location (' leaving:' || l_proc, 5);

221: > nvl (p_end_date, to_date ('31-12-4712', 'DD-MM-YYYY'))) then
222: ota_rud_shd.constraint_error ('OTA_RUD_DATES');
223: end if;
224: --
225: hr_utility.set_location (' leaving:' || l_proc, 5);
226: --
227: end check_start_end_dates;
228: --
229: -- ----------------------------------------------------------------------------

Line 254: hr_utility.set_location ('Entering:' || l_proc, 5);

250: off.offering_id = p_offering_id;
251: --
252: begin
253: --
254: hr_utility.set_location ('Entering:' || l_proc, 5);
255: --
256: -- valid Offering ?
257: --
258: open c1;

Line 284: hr_utility.set_location (' leaving:' || l_proc, 5);

280: and nvl (l_off_end_date, hr_general.end_of_time))) then
281: ota_rud_shd.constraint_error ('OTA_RUD_TAV_DATES');
282: end if;
283: --
284: hr_utility.set_location (' leaving:' || l_proc, 5);
285: --
286: end check_off;
287: --
288: -- ----------------------------------------------------------------------------

Line 311: hr_utility.set_location ('Entering:' || l_proc, 5);

307: where tsr.supplied_resource_id = p_supplied_resource_id;
308: --
309: begin
310: --
311: hr_utility.set_location ('Entering:' || l_proc, 5);
312: --
313: -- valid resource ?
314: --
315: open c1;

Line 341: hr_utility.set_location (' leaving:' || l_proc, 10);

337: and nvl (l_tsr_end_date, hr_general.end_of_time))) then
338: ota_rud_shd.constraint_error ('OTA_RUD_TSR_DATES');
339: end if;
340: --
341: hr_utility.set_location (' leaving:' || l_proc, 10);
342: --
343: end check_tsr;
344: --
345: -- ----------------------------------------------------------------------------

Line 370: hr_utility.set_location ('Entering:' || l_proc, 5);

366: and tsr.business_group_id = off.business_group_id;
367: --
368: begin
369: --
370: hr_utility.set_location ('Entering:' || l_proc, 5);
371: --
372: open c1;
373: fetch c1
374: into l_ok;

Line 381: hr_utility.set_location (' Leaving:' || l_proc, 10);

377: ota_rud_shd.constraint_error ('OTA_RUD_BUSINESS_GROUPS');
378: end if;
379: close c1;
380: --
381: hr_utility.set_location (' Leaving:' || l_proc, 10);
382: --
383: end check_off_tsr_bus_grp;
384: --
385: -- ----------------------------------------------------------------------------

Line 399: hr_utility.set_location ('Entering:' || l_proc, 5);

395: l_proc varchar2 (72) := g_package || 'check_resource_type';
396: --
397: begin
398: --
399: hr_utility.set_location ('Entering:' || l_proc, 5);
400: --
401: ota_general.check_domain_value ('RESOURCE_TYPE', p_resource_type);
402: --
403: hr_utility.set_location (' Leaving:' || l_proc, 10);

Line 403: hr_utility.set_location (' Leaving:' || l_proc, 10);

399: hr_utility.set_location ('Entering:' || l_proc, 5);
400: --
401: ota_general.check_domain_value ('RESOURCE_TYPE', p_resource_type);
402: --
403: hr_utility.set_location (' Leaving:' || l_proc, 10);
404: --
405: end check_resource_type;
406: --
407: -- ----------------------------------------------------------------------------

Line 430: hr_utility.set_location ('Entering' || l_proc, 10);

426: tsr.supplied_resource_id = p_supplied_resource_id;
427:
428: Begin
429: --
430: hr_utility.set_location ('Entering' || l_proc, 10);
431: --
432: If p_role_to_play is not null then
433: If p_resource_type is not null and p_resource_type <> 'T' then
434: ota_rud_shd.constraint_error ('OTA_RUD_RESOURCE_ROLE');

Line 450: hr_utility.set_location (' Leaving:' || l_proc, 10);

446: --
447: ota_general.check_domain_value ('TRAINER_PARTICIPATION', p_role_to_play);
448: --
449: End If;
450: hr_utility.set_location (' Leaving:' || l_proc, 10);
451: --
452: End Check_role;
453: --
454: -- ----------------------------------------------------------------------------

Line 466: hr_utility.set_location ('Entering' || l_proc, 10);

462: l_proc varchar2 (72) := g_package || 'check_usage_reason';
463: --
464: begin
465: --
466: hr_utility.set_location ('Entering' || l_proc, 10);
467: --
468: ota_general.check_domain_value ('RESOURCE_USAGE_REASON', p_usage_reason);
469: --
470: hr_utility.set_location (' Leaving:' || l_proc, 10);

Line 470: hr_utility.set_location (' Leaving:' || l_proc, 10);

466: hr_utility.set_location ('Entering' || l_proc, 10);
467: --
468: ota_general.check_domain_value ('RESOURCE_USAGE_REASON', p_usage_reason);
469: --
470: hr_utility.set_location (' Leaving:' || l_proc, 10);
471: --
472: end check_usage_reason;
473: --
474: -- ----------------------------------------------------------------------------

Line 487: hr_utility.set_location ('Entering' || l_proc, 10);

483: l_proc varchar2 (72) := g_package || 'check_quantity';
484: --
485: begin
486: --
487: hr_utility.set_location ('Entering' || l_proc, 10);
488: --
489: If p_resource_type = 'V' or p_resource_type = 'T' Then
490: --
491: If p_quantity is null or p_quantity <> 1 Then

Line 504: hr_utility.set_location ('Leaving:' || l_proc, 20);

500: fnd_message.raise_error;
501: --
502: End If;
503: --
504: hr_utility.set_location ('Leaving:' || l_proc, 20);
505: --
506: Exception
507: --
508: when app_exception.application_exception then

Line 514: hr_utility.set_location(' Leaving:'|| l_proc, 30);

510: (p_associated_column1 => 'OTA_RESOURCE_USAGES.QUANTITY'
511: )
512: Then
513: --
514: hr_utility.set_location(' Leaving:'|| l_proc, 30);
515: raise;
516: --
517: end if;
518: --

Line 519: hr_utility.set_location(' Leaving:'|| l_proc, 40);

515: raise;
516: --
517: end if;
518: --
519: hr_utility.set_location(' Leaving:'|| l_proc, 40);
520: --
521: end check_quantity;
522:
523: --

Line 542: hr_utility.set_location ('Entering' || l_proc, 10);

538: where supplied_resource_id = p_rec.supplied_resource_id;
539: --
540: begin
541: --
542: hr_utility.set_location ('Entering' || l_proc, 10);
543: --
544: check_start_end_dates
545: (p_start_date => p_rec.start_date
546: ,p_end_date => p_rec.end_date

Line 623: hr_utility.set_location (' Leaving:' || l_proc, 10);

619: check_usage_reason
620: (p_usage_reason => p_rec.usage_reason
621: );
622: --
623: hr_utility.set_location (' Leaving:' || l_proc, 10);
624: --
625: end validity_checks;
626: --
627: -- ----------------------------------------------------------------------------

Line 662: hr_utility.set_location('Entering:'||l_proc,10);

658: --
659: l_proc varchar2(72) := g_package || 'chk_ddf';
660: --
661: begin
662: hr_utility.set_location('Entering:'||l_proc,10);
663: --
664: if ((p_rec.resource_usage_id is not null) and (
665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or

Line 761: hr_utility.set_location(' Leaving:'||l_proc,20);

757: ,p_attribute20_value => p_rec.rud_information20
758: );
759: end if;
760: --
761: hr_utility.set_location(' Leaving:'||l_proc,20);
762: end chk_ddf;
763: --
764: -- ----------------------------------------------------------------------------
765: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 829: hr_utility.set_location('Entering:'||l_proc, 5);

825: --
826: l_proc varchar2(72) := g_package||'insert_validate';
827: --
828: Begin
829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: -- Call all supporting business operations
832: ota_off_bus.set_security_group_id(p_rec.offering_id);
833: --

Line 845: hr_utility.set_location(' Leaving:'||l_proc, 10);

841: --
842: --
843: ota_rud_bus.chk_ddf(p_rec);
844: --
845: hr_utility.set_location(' Leaving:'||l_proc, 10);
846: End insert_validate;
847: --
848: -- ----------------------------------------------------------------------------
849: -- |---------------------------< update_validate >----------------------------|

Line 859: hr_utility.set_location('Entering:'||l_proc, 5);

855: --
856: l_proc varchar2(72) := g_package||'update_validate';
857: --
858: Begin
859: hr_utility.set_location('Entering:'||l_proc, 5);
860: --
861: -- Call all supporting business operations
862: ota_off_bus.set_security_group_id(p_rec.offering_id);
863: --

Line 883: hr_utility.set_location(' Leaving:'||l_proc, 10);

879: --
880: --
881: ota_rud_bus.chk_ddf(p_rec);
882: --
883: hr_utility.set_location(' Leaving:'||l_proc, 10);
884: End update_validate;
885: --
886: -- ----------------------------------------------------------------------------
887: -- |---------------------------< delete_validate >----------------------------|

Line 896: hr_utility.set_location('Entering:'||l_proc, 5);

892: --
893: l_proc varchar2(72) := g_package||'delete_validate';
894: --
895: Begin
896: hr_utility.set_location('Entering:'||l_proc, 5);
897: --
898: -- Call all supporting business operations
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 900: hr_utility.set_location(' Leaving:'||l_proc, 10);

896: hr_utility.set_location('Entering:'||l_proc, 5);
897: --
898: -- Call all supporting business operations
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 10);
901: End delete_validate;
902: --
903: end ota_rud_bus;