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_TMT_BUS1 dependencies on HR_API

Line 34: hr_api.mandatory_arg_error

30: --
31: -- check mandatory parameters have been set
32: --
33: hr_utility.set_location('Entering:'||l_proc, 5);
34: hr_api.mandatory_arg_error
35: (p_api_name => l_proc
36: ,p_argument => 'p_effective_date'
37: ,p_argument_value => p_effective_date
38: );

Line 41: hr_api.mandatory_arg_error

37: ,p_argument_value => p_effective_date
38: );
39: --
40: hr_utility.set_location(' Step:'|| l_proc, 20);
41: hr_api.mandatory_arg_error
42: (p_api_name => l_proc
43: ,p_argument => 'p_tp_measurement_code'
44: ,p_argument_value => p_tp_measurement_code
45: );

Line 48: hr_api.mandatory_arg_error

44: ,p_argument_value => p_tp_measurement_code
45: );
46: --
47: hr_utility.set_location(' Step:'|| l_proc, 30);
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'p_business_group_id'
51: ,p_argument_value => p_business_group_id
52: );

Line 57: if hr_api.not_exists_in_hr_lookups

53: --
54: -- Check that the lookup code is valid
55: --
56: hr_utility.set_location(' Step:'|| l_proc, 40);
57: if hr_api.not_exists_in_hr_lookups
58: (p_effective_date => p_effective_date
59: ,p_lookup_type => 'OTA_PLAN_MEASUREMENT_TYPE'
60: ,p_lookup_code => p_tp_measurement_code
61: ) then

Line 112: hr_api.mandatory_arg_error

108: --
109: -- check mandatory parameters have been set
110: --
111: hr_utility.set_location('Entering:'||l_proc, 5);
112: hr_api.mandatory_arg_error
113: (p_api_name => l_proc
114: ,p_argument => 'p_tp_measurement_code'
115: ,p_argument_value => p_tp_measurement_code
116: );

Line 119: hr_api.mandatory_arg_error

115: ,p_argument_value => p_tp_measurement_code
116: );
117: --
118: hr_utility.set_location('Entering:'||l_proc, 10);
119: hr_api.mandatory_arg_error
120: (p_api_name => l_proc
121: ,p_argument => 'p_tp_measurement_type_id'
122: ,p_argument_value => p_tp_measurement_type_id
123: );

Line 126: hr_api.mandatory_arg_error

122: ,p_argument_value => p_tp_measurement_type_id
123: );
124: --
125: hr_utility.set_location(' Step:'|| l_proc, 30);
126: hr_api.mandatory_arg_error
127: (p_api_name => l_proc
128: ,p_argument => 'p_business_group_id'
129: ,p_argument_value => p_business_group_id
130: );

Line 173: hr_api.mandatory_arg_error

169: --
170: -- check mandatory parameters have been set
171: --
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: hr_api.mandatory_arg_error
174: (p_api_name => l_proc
175: ,p_argument => 'p_unit'
176: ,p_argument_value => p_unit
177: );

Line 180: hr_api.mandatory_arg_error

176: ,p_argument_value => p_unit
177: );
178: --
179: hr_utility.set_location(' Step:'|| l_proc, 30);
180: hr_api.mandatory_arg_error
181: (p_api_name => l_proc
182: ,p_argument => 'p_business_group_id'
183: ,p_argument_value => p_business_group_id
184: );

Line 187: hr_api.mandatory_arg_error

183: ,p_argument_value => p_business_group_id
184: );
185: --
186: hr_utility.set_location(' Step:'|| l_proc, 40);
187: hr_api.mandatory_arg_error
188: (p_api_name => l_proc
189: ,p_argument => 'p_effective_date'
190: ,p_argument_value => p_effective_date
191: );

Line 201: nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>

197: --
198: -- If this is a changing update, or a new insert, test
199: --
200: if ((l_api_updating and
201: nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>
202: nvl(p_unit, hr_api.g_varchar2))
203: or (NOT l_api_updating))
204: then
205: hr_utility.set_location(l_proc, 50);

Line 202: nvl(p_unit, hr_api.g_varchar2))

198: -- If this is a changing update, or a new insert, test
199: --
200: if ((l_api_updating and
201: nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>
202: nvl(p_unit, hr_api.g_varchar2))
203: or (NOT l_api_updating))
204: then
205: hr_utility.set_location(l_proc, 50);
206: --

Line 209: if hr_api.not_exists_in_hr_lookups

205: hr_utility.set_location(l_proc, 50);
206: --
207: -- Validate that the code exists in the lookups view
208: --
209: if hr_api.not_exists_in_hr_lookups
210: (p_effective_date => p_effective_date
211: ,p_lookup_type => 'UNITS'
212: ,p_lookup_code => p_unit
213: ) then

Line 231: and nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>

227: --
228: -- but changes are only allowed if there are no current recs in costs
229: --
230: If l_api_updating
231: and nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>
232: nvl(p_unit, hr_api.g_varchar2) then
233: hr_utility.set_location(' Step:'|| l_proc, 80);
234: open csr_chk_no_cost_recs;
235: fetch csr_chk_no_cost_recs into l_exists;

Line 232: nvl(p_unit, hr_api.g_varchar2) then

228: -- but changes are only allowed if there are no current recs in costs
229: --
230: If l_api_updating
231: and nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>
232: nvl(p_unit, hr_api.g_varchar2) then
233: hr_utility.set_location(' Step:'|| l_proc, 80);
234: open csr_chk_no_cost_recs;
235: fetch csr_chk_no_cost_recs into l_exists;
236: If csr_chk_no_cost_recs%FOUND then

Line 278: hr_api.mandatory_arg_error

274: --
275: -- check mandatory parameters have been set
276: --
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: hr_api.mandatory_arg_error
279: (p_api_name => l_proc
280: ,p_argument => 'p_tp_measurement_code'
281: ,p_argument_value => p_tp_measurement_code
282: );

Line 285: hr_api.mandatory_arg_error

281: ,p_argument_value => p_tp_measurement_code
282: );
283: --
284: hr_utility.set_location(' Step:'|| l_proc, 30);
285: hr_api.mandatory_arg_error
286: (p_api_name => l_proc
287: ,p_argument => 'p_business_group_id'
288: ,p_argument_value => p_business_group_id
289: );

Line 292: hr_api.mandatory_arg_error

288: ,p_argument_value => p_business_group_id
289: );
290: --
291: hr_utility.set_location(' Step:'|| l_proc, 40);
292: hr_api.mandatory_arg_error
293: (p_api_name => l_proc
294: ,p_argument => 'p_effective_date'
295: ,p_argument_value => p_effective_date
296: );

Line 299: hr_api.mandatory_arg_error

295: ,p_argument_value => p_effective_date
296: );
297: --
298: hr_utility.set_location(' Step:'|| l_proc, 50);
299: hr_api.mandatory_arg_error
300: (p_api_name => l_proc
301: ,p_argument => 'p_budget_level'
302: ,p_argument_value => p_budget_level
303: );

Line 313: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>

309: --
310: -- If this is a changing update, or a new insert, test
311: --
312: if (l_api_updating and
313: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
314: nvl(p_budget_level, hr_api.g_varchar2))
315: or (NOT l_api_updating)
316: then
317: hr_utility.set_location(l_proc, 60);

Line 314: nvl(p_budget_level, hr_api.g_varchar2))

310: -- If this is a changing update, or a new insert, test
311: --
312: if (l_api_updating and
313: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
314: nvl(p_budget_level, hr_api.g_varchar2))
315: or (NOT l_api_updating)
316: then
317: hr_utility.set_location(l_proc, 60);
318: --

Line 321: if hr_api.not_exists_in_hr_lookups

317: hr_utility.set_location(l_proc, 60);
318: --
319: -- Validate that the code exists in the lookups view
320: --
321: if hr_api.not_exists_in_hr_lookups
322: (p_effective_date => p_effective_date
323: ,p_lookup_type => 'OTA_TRAINING_PLAN_BUDGET_LEVEL'
324: ,p_lookup_code => p_budget_level
325: ) then

Line 337: and nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>

333: --
334: -- but changes are only allowed if there are no current recs in budget elements
335: --
336: If l_api_updating
337: and nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
338: nvl(p_budget_level, hr_api.g_varchar2) then
339: hr_utility.set_location(' Step:'|| l_proc, 80);
340: open csr_upd_tp_budget_level;
341: fetch csr_upd_tp_budget_level into l_exists;

Line 338: nvl(p_budget_level, hr_api.g_varchar2) then

334: -- but changes are only allowed if there are no current recs in budget elements
335: --
336: If l_api_updating
337: and nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
338: nvl(p_budget_level, hr_api.g_varchar2) then
339: hr_utility.set_location(' Step:'|| l_proc, 80);
340: open csr_upd_tp_budget_level;
341: fetch csr_upd_tp_budget_level into l_exists;
342: If csr_upd_tp_budget_level%FOUND then

Line 374: hr_api.mandatory_arg_error

370: --
371: -- check mandatory parameters have been set
372: --
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: hr_api.mandatory_arg_error
375: (p_api_name => l_proc
376: ,p_argument => 'p_budget_level'
377: ,p_argument_value => p_budget_level
378: );

Line 381: hr_api.mandatory_arg_error

377: ,p_argument_value => p_budget_level
378: );
379: --
380: hr_utility.set_location(' Step:'|| l_proc, 20);
381: hr_api.mandatory_arg_error
382: (p_api_name => l_proc
383: ,p_argument => 'p_cost_level'
384: ,p_argument_value => p_cost_level
385: );

Line 397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>

393: -- If either budget level or cost level is changing, or this is an
394: -- insert, check the combinations
395: --
396: if ((l_api_updating and
397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
398: nvl(p_budget_level, hr_api.g_varchar2)
399: or
400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
401: nvl(p_cost_level, hr_api.g_varchar2))

Line 398: nvl(p_budget_level, hr_api.g_varchar2)

394: -- insert, check the combinations
395: --
396: if ((l_api_updating and
397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
398: nvl(p_budget_level, hr_api.g_varchar2)
399: or
400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
401: nvl(p_cost_level, hr_api.g_varchar2))
402: or (NOT l_api_updating))

Line 400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>

396: if ((l_api_updating and
397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
398: nvl(p_budget_level, hr_api.g_varchar2)
399: or
400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
401: nvl(p_cost_level, hr_api.g_varchar2))
402: or (NOT l_api_updating))
403: then
404: hr_utility.set_location(l_proc, 50);

Line 401: nvl(p_cost_level, hr_api.g_varchar2))

397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
398: nvl(p_budget_level, hr_api.g_varchar2)
399: or
400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
401: nvl(p_cost_level, hr_api.g_varchar2))
402: or (NOT l_api_updating))
403: then
404: hr_utility.set_location(l_proc, 50);
405: --

Line 445: hr_api.mandatory_arg_error

441: --
442: -- check mandatory parameters have been set
443: --
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc
447: ,p_argument => 'p_business_group_id'
448: ,p_argument_value => p_business_group_id
449: );

Line 452: hr_api.mandatory_arg_error

448: ,p_argument_value => p_business_group_id
449: );
450: --
451: hr_utility.set_location(' Step:'|| l_proc, 40);
452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc
454: ,p_argument => 'p_effective_date'
455: ,p_argument_value => p_effective_date
456: );

Line 459: hr_api.mandatory_arg_error

455: ,p_argument_value => p_effective_date
456: );
457: --
458: hr_utility.set_location(' Step:'|| l_proc, 50);
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc
461: ,p_argument => 'p_cost_level'
462: ,p_argument_value => p_cost_level
463: );

Line 473: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>

469: --
470: -- If this is a changing update, or a new insert, test
471: --
472: if (l_api_updating and
473: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
474: nvl(p_cost_level, hr_api.g_varchar2))
475: or (NOT l_api_updating)
476: then
477: hr_utility.set_location(l_proc, 60);

Line 474: nvl(p_cost_level, hr_api.g_varchar2))

470: -- If this is a changing update, or a new insert, test
471: --
472: if (l_api_updating and
473: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
474: nvl(p_cost_level, hr_api.g_varchar2))
475: or (NOT l_api_updating)
476: then
477: hr_utility.set_location(l_proc, 60);
478: --

Line 481: if hr_api.not_exists_in_hr_lookups

477: hr_utility.set_location(l_proc, 60);
478: --
479: -- Validate that the code exists in the lookups view
480: --
481: if hr_api.not_exists_in_hr_lookups
482: (p_effective_date => p_effective_date
483: ,p_lookup_type => 'OTA_TRAINING_PLAN_COST_LEVEL'
484: ,p_lookup_code => p_cost_level
485: ) then

Line 497: and nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>

493: --
494: -- but changes are only allowed if there are no current recs in cost table
495: --
496: If l_api_updating
497: and nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
498: nvl(p_cost_level, hr_api.g_varchar2) then
499: hr_utility.set_location(' Step:'|| l_proc, 80);
500: open csr_upd_cost_level;
501: fetch csr_upd_cost_level into l_exists;

Line 498: nvl(p_cost_level, hr_api.g_varchar2) then

494: -- but changes are only allowed if there are no current recs in cost table
495: --
496: If l_api_updating
497: and nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
498: nvl(p_cost_level, hr_api.g_varchar2) then
499: hr_utility.set_location(' Step:'|| l_proc, 80);
500: open csr_upd_cost_level;
501: fetch csr_upd_cost_level into l_exists;
502: If csr_upd_cost_level%FOUND then

Line 550: hr_api.mandatory_arg_error

546: --
547: -- check mandatory parameters have been set
548: --
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc
552: ,p_argument => 'p_tp_measurement_code'
553: ,p_argument_value => p_tp_measurement_code
554: );

Line 557: hr_api.mandatory_arg_error

553: ,p_argument_value => p_tp_measurement_code
554: );
555: --
556: hr_utility.set_location(' Step:'|| l_proc, 30);
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc
559: ,p_argument => 'p_business_group_id'
560: ,p_argument_value => p_business_group_id
561: );

Line 564: hr_api.mandatory_arg_error

560: ,p_argument_value => p_business_group_id
561: );
562: --
563: hr_utility.set_location(' Step:'|| l_proc, 40);
564: hr_api.mandatory_arg_error
565: (p_api_name => l_proc
566: ,p_argument => 'p_effective_date'
567: ,p_argument_value => p_effective_date
568: );

Line 571: hr_api.mandatory_arg_error

567: ,p_argument_value => p_effective_date
568: );
569: --
570: hr_utility.set_location(' Step:'|| l_proc, 50);
571: hr_api.mandatory_arg_error
572: (p_api_name => l_proc
573: ,p_argument => 'p_many_budget_values_flag'
574: ,p_argument_value => p_many_budget_values_flag
575: );

Line 585: nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>

581: --
582: -- If this is a changing update, or a new insert, test
583: --
584: if ((l_api_updating and
585: nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>
586: nvl(p_many_budget_values_flag, hr_api.g_varchar2))
587: or (NOT l_api_updating))
588: then
589: hr_utility.set_location(l_proc, 60);

Line 586: nvl(p_many_budget_values_flag, hr_api.g_varchar2))

582: -- If this is a changing update, or a new insert, test
583: --
584: if ((l_api_updating and
585: nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>
586: nvl(p_many_budget_values_flag, hr_api.g_varchar2))
587: or (NOT l_api_updating))
588: then
589: hr_utility.set_location(l_proc, 60);
590: --

Line 593: if hr_api.not_exists_in_hr_lookups

589: hr_utility.set_location(l_proc, 60);
590: --
591: -- Validate that the code exists in the lookups view
592: --
593: if hr_api.not_exists_in_hr_lookups
594: (p_effective_date => p_effective_date
595: ,p_lookup_type => 'YES_NO'
596: ,p_lookup_code => p_many_budget_values_flag
597: ) then

Line 610: and (nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>

606: -- but changes to 'N' are only allowed if there zero or 1 recs in budget elements
607: --
608: If l_api_updating
609: and p_many_budget_values_flag = 'N'
610: and (nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>
611: nvl(p_many_budget_values_flag, hr_api.g_varchar2)) then
612: hr_utility.set_location(' Step:'|| l_proc, 80);
613: open csr_upd_tp_budget_flag;
614: fetch csr_upd_tp_budget_flag into l_exists;

Line 611: nvl(p_many_budget_values_flag, hr_api.g_varchar2)) then

607: --
608: If l_api_updating
609: and p_many_budget_values_flag = 'N'
610: and (nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>
611: nvl(p_many_budget_values_flag, hr_api.g_varchar2)) then
612: hr_utility.set_location(' Step:'|| l_proc, 80);
613: open csr_upd_tp_budget_flag;
614: fetch csr_upd_tp_budget_flag into l_exists;
615: if csr_upd_tp_budget_flag%FOUND then

Line 652: hr_api.mandatory_arg_error

648: -- check mandatory parameters have been set
649: --
650: --
651: hr_utility.set_location('Entering:'||l_proc, 5);
652: hr_api.mandatory_arg_error
653: (p_api_name => l_proc
654: ,p_argument => 'p_business_group_id'
655: ,p_argument_value => p_business_group_id
656: );

Line 667: nvl(ota_tmt_shd.g_old_rec.item_type_usage_id, hr_api.g_number) <>

663: -- If this is a changing update, or a new insert, test
664: --
665: If p_item_type_usage_id is not null then
666: If ((l_api_updating and
667: nvl(ota_tmt_shd.g_old_rec.item_type_usage_id, hr_api.g_number) <>
668: nvl(p_item_type_usage_id, hr_api.g_number))
669: or (NOT l_api_updating))
670: Then
671: -- Test that it exists in hr_summary

Line 668: nvl(p_item_type_usage_id, hr_api.g_number))

664: --
665: If p_item_type_usage_id is not null then
666: If ((l_api_updating and
667: nvl(ota_tmt_shd.g_old_rec.item_type_usage_id, hr_api.g_number) <>
668: nvl(p_item_type_usage_id, hr_api.g_number))
669: or (NOT l_api_updating))
670: Then
671: -- Test that it exists in hr_summary
672: hr_utility.set_location(l_proc, 10);

Line 710: hr_api.mandatory_arg_error

706: --
707: -- check mandatory parameters have been set
708: --
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: hr_api.mandatory_arg_error
711: (p_api_name => l_proc
712: ,p_argument => 'p_tp_measurement_type_id'
713: ,p_argument_value => p_tp_measurement_type_id
714: );

Line 754: hr_api.mandatory_arg_error

750: --
751: -- check mandatory parameters have been set
752: --
753: hr_utility.set_location('Entering:'||l_proc, 5);
754: hr_api.mandatory_arg_error
755: (p_api_name => l_proc
756: ,p_argument => 'tp_measurement_code'
757: ,p_argument_value => p_tp_measurement_code
758: );

Line 761: hr_api.mandatory_arg_error

757: ,p_argument_value => p_tp_measurement_code
758: );
759: --
760: hr_utility.set_location(' Step:'|| l_proc, 10);
761: hr_api.mandatory_arg_error
762: (p_api_name => l_proc
763: ,p_argument => 'p_unit'
764: ,p_argument_value => p_unit
765: );

Line 768: hr_api.mandatory_arg_error

764: ,p_argument_value => p_unit
765: );
766: --
767: hr_utility.set_location(' Step:'|| l_proc, 20);
768: hr_api.mandatory_arg_error
769: (p_api_name => l_proc
770: ,p_argument => 'p_cost_level'
771: ,p_argument_value => p_cost_level
772: );

Line 775: hr_api.mandatory_arg_error

771: ,p_argument_value => p_cost_level
772: );
773: --
774: hr_utility.set_location(' Step:'|| l_proc, 30);
775: hr_api.mandatory_arg_error
776: (p_api_name => l_proc
777: ,p_argument => 'p_budget_level'
778: ,p_argument_value => p_budget_level
779: );

Line 782: hr_api.mandatory_arg_error

778: ,p_argument_value => p_budget_level
779: );
780: --
781: hr_utility.set_location(' Step:'|| l_proc, 40);
782: hr_api.mandatory_arg_error
783: (p_api_name => l_proc
784: ,p_argument => 'p_many_budget_values_flag'
785: ,p_argument_value => p_many_budget_values_flag
786: );

Line 789: hr_api.mandatory_arg_error

785: ,p_argument_value => p_many_budget_values_flag
786: );
787: --
788: hr_utility.set_location(' Step:'|| l_proc, 50);
789: hr_api.mandatory_arg_error
790: (p_api_name => l_proc
791: ,p_argument => 'p_legislation_code'
792: ,p_argument_value => p_legislation_code
793: );