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

Line 39: hr_utility.set_location(' Step:'|| l_proc, 45);

35: --
36: -- check mandatory parameters have been set
37: --
38: --
39: hr_utility.set_location(' Step:'|| l_proc, 45);
40:
41: IF hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'

Line 72: hr_utility.set_location(' Step:'|| l_proc, 50);

68: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
69: NVL(p_time_period_id, hr_api.g_number) )
70: OR (NOT l_api_updating)
71: THEN
72: hr_utility.set_location(' Step:'|| l_proc, 50);
73: OPEN csr_unique;
74: FETCH csr_unique INTO l_exists;
75: IF csr_unique%FOUND THEN
76: CLOSE csr_unique;

Line 77: hr_utility.set_location(' Step:'|| l_proc, 60);

73: OPEN csr_unique;
74: FETCH csr_unique INTO l_exists;
75: IF csr_unique%FOUND THEN
76: CLOSE csr_unique;
77: hr_utility.set_location(' Step:'|| l_proc, 60);
78: fnd_message.set_name('OTA', 'OTA_13867_TPS_DUPLICATE_TP');
79: fnd_message.raise_error;
80: ELSE
81: CLOSE csr_unique;

Line 82: hr_utility.set_location(' Step:'|| l_proc, 70);

78: fnd_message.set_name('OTA', 'OTA_13867_TPS_DUPLICATE_TP');
79: fnd_message.raise_error;
80: ELSE
81: CLOSE csr_unique;
82: hr_utility.set_location(' Step:'|| l_proc, 70);
83: END IF;
84: END IF;
85: --
86: END IF;

Line 87: hr_utility.set_location(' Leaving:'||l_proc, 90);

83: END IF;
84: END IF;
85: --
86: END IF;
87: hr_utility.set_location(' Leaving:'||l_proc, 90);
88:
89: --MULTI MESSAGE SUPPORT
90: EXCEPTION
91:

Line 97: hr_utility.set_location(' Leaving:'||l_proc, 92);

93:
94: IF hr_multi_message.exception_add(
95: p_same_associated_columns => 'Y') THEN
96:
97: hr_utility.set_location(' Leaving:'||l_proc, 92);
98: RAISE;
99:
100: END IF;
101: hr_utility.set_location(' Leaving:'||l_proc, 95);

Line 101: hr_utility.set_location(' Leaving:'||l_proc, 95);

97: hr_utility.set_location(' Leaving:'||l_proc, 92);
98: RAISE;
99:
100: END IF;
101: hr_utility.set_location(' Leaving:'||l_proc, 95);
102:
103: END chk_unique;
104:
105: -- ----------------------------------------------------------------------------

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

117: BEGIN
118: --
119: -- check mandatory parameters have been set
120: --
121: hr_utility.set_location(' Entering:'||l_proc, 10);
122: /*
123: IF ( (p_organization_id IS NOT NULL AND p_person_id IS NOT NULL )
124: OR (p_organization_id IS NULL AND p_person_id IS NULL) ) THEN
125: */

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

129: fnd_message.set_name('OTA', 'OTA_13858_TPS_ORG_OR_PERSON');
130: fnd_message.raise_error;
131: END IF;
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 20);
134:
135: --MULTI MESSAGE SUPPORT
136: EXCEPTION
137:

Line 145: hr_utility.set_location(' Leaving:'||l_proc, 22);

141: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
142: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
143: ,p_associated_column3 => 'OTA_TRAINING_PLANS.CONTACT_ID') THEN
144:
145: hr_utility.set_location(' Leaving:'||l_proc, 22);
146: RAISE;
147:
148: END IF;
149: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 149: hr_utility.set_location(' Leaving:'||l_proc, 25);

145: hr_utility.set_location(' Leaving:'||l_proc, 22);
146: RAISE;
147:
148: END IF;
149: hr_utility.set_location(' Leaving:'||l_proc, 25);
150:
151: END chk_org_person;
152: -- ----------------------------------------------------------------------------
153: -- |-----------------------------------------------------|

Line 173: hr_utility.set_location(' Step:'|| l_proc, 20);

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

Line 180: hr_utility.set_location(' Step:'|| l_proc, 30);

176: ,p_argument => 'p_business_group_id'
177: ,p_argument_value => p_business_group_id
178: );
179: --
180: hr_utility.set_location(' Step:'|| l_proc, 30);
181: IF p_organization_id IS NOT NULL THEN
182: OPEN csr_organization_id;
183: FETCH csr_organization_id INTO l_business_group_id;
184: IF csr_organization_id%NOTFOUND THEN

Line 186: hr_utility.set_location(' Step:'|| l_proc, 40);

182: OPEN csr_organization_id;
183: FETCH csr_organization_id INTO l_business_group_id;
184: IF csr_organization_id%NOTFOUND THEN
185: CLOSE csr_organization_id;
186: hr_utility.set_location(' Step:'|| l_proc, 40);
187: fnd_message.set_name('OTA', 'OTA_13859_TPS_BAD_ORG');
188: fnd_message.raise_error;
189: ELSIF l_business_group_id <> p_business_group_id THEN
190: CLOSE csr_organization_id;

Line 198: hr_utility.set_location(' Leaving:'||l_proc, 50);

194: CLOSE csr_organization_id;
195: END IF;
196: END IF;
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 50);
199:
200: --MULTI MESSAGE SUPPORT
201: EXCEPTION
202:

Line 208: hr_utility.set_location(' Leaving:'||l_proc, 52);

204:
205: IF hr_multi_message.exception_add(
206: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID') THEN
207:
208: hr_utility.set_location(' Leaving:'||l_proc, 52);
209: RAISE;
210:
211: END IF;
212: hr_utility.set_location(' Leaving:'||l_proc, 55);

Line 212: hr_utility.set_location(' Leaving:'||l_proc, 55);

208: hr_utility.set_location(' Leaving:'||l_proc, 52);
209: RAISE;
210:
211: END IF;
212: hr_utility.set_location(' Leaving:'||l_proc, 55);
213:
214:
215: END chk_organization_id;
216:

Line 239: hr_utility.set_location(' Step:'|| l_proc, 20);

235: BEGIN
236: --
237: -- check mandatory parameters have been set
238: --
239: hr_utility.set_location(' Step:'|| l_proc, 20);
240: hr_api.mandatory_arg_error
241: (p_api_name => l_proc
242: ,p_argument => 'p_business_group_id'
243: ,p_argument_value => p_business_group_id

Line 246: hr_utility.set_location(' Step:'|| l_proc, 30);

242: ,p_argument => 'p_business_group_id'
243: ,p_argument_value => p_business_group_id
244: );
245: --
246: hr_utility.set_location(' Step:'|| l_proc, 30);
247: IF p_person_id IS NOT NULL THEN
248: OPEN csr_person_id;
249: FETCH csr_person_id INTO l_business_group_id;
250: IF csr_person_id%NOTFOUND THEN

Line 252: hr_utility.set_location(' Step:'|| l_proc, 40);

248: OPEN csr_person_id;
249: FETCH csr_person_id INTO l_business_group_id;
250: IF csr_person_id%NOTFOUND THEN
251: CLOSE csr_person_id;
252: hr_utility.set_location(' Step:'|| l_proc, 40);
253: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
254: fnd_message.raise_error;
255: /*
256: selected person can be from a business group other than

Line 268: hr_utility.set_location(' Leaving:'||l_proc, 50);

264: CLOSE csr_person_id;
265: END IF;
266: END IF;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 50);
269:
270: --MULTI MESSAGE SUPPORT
271: EXCEPTION
272:

Line 278: hr_utility.set_location(' Leaving:'||l_proc, 52);

274:
275: IF hr_multi_message.exception_add(
276: p_associated_column1 => 'OTA_TRAINING_PLANS.PERSON_ID') THEN
277:
278: hr_utility.set_location(' Leaving:'||l_proc, 52);
279: RAISE;
280:
281: END IF;
282: hr_utility.set_location(' Leaving:'||l_proc, 55);

Line 282: hr_utility.set_location(' Leaving:'||l_proc, 55);

278: hr_utility.set_location(' Leaving:'||l_proc, 52);
279: RAISE;
280:
281: END IF;
282: hr_utility.set_location(' Leaving:'||l_proc, 55);
283:
284: END chk_person_id;
285: -- ----------------------------------------------------------------------------
286: -- |-------------------------------------------------------|

Line 314: hr_utility.set_location(' Step:'|| l_proc, 20);

310: BEGIN
311: --
312: -- check mandatory parameters have been set
313: --
314: hr_utility.set_location(' Step:'|| l_proc, 20);
315: hr_api.mandatory_arg_error
316: (p_api_name => l_proc
317: ,p_argument => 'p_business_group_id'
318: ,p_argument_value => p_business_group_id

Line 337: hr_utility.set_location(' Step:'|| l_proc, 30);

333: THEN
334: --
335: -- The time period_id must exist in per_time_periods
336: --
337: hr_utility.set_location(' Step:'|| l_proc, 30);
338: OPEN csr_time_period_id;
339: FETCH csr_time_period_id INTO l_exists;
340: IF csr_time_period_id%NOTFOUND THEN
341: CLOSE csr_time_period_id;

Line 352: hr_utility.set_location(' Step:'|| l_proc, 40);

348: --
349: -- If it is a changing update, no members are allowed
350: -- in OTA_TRAINING_PLAN_MEMBERS
351: --
352: hr_utility.set_location(' Step:'|| l_proc, 40);
353: IF l_api_updating AND
354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
355: NVL(p_time_period_id, hr_api.g_number) THEN
356: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 356: hr_utility.set_location(' Step:'|| l_proc, 50);

352: hr_utility.set_location(' Step:'|| l_proc, 40);
353: IF l_api_updating AND
354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
355: NVL(p_time_period_id, hr_api.g_number) THEN
356: hr_utility.set_location(' Step:'|| l_proc, 50);
357: OPEN csr_members;
358: FETCH csr_members INTO l_exists;
359: IF csr_members%FOUND THEN
360: CLOSE csr_members;

Line 367: hr_utility.set_location(' Leaving:'||l_proc, 60);

363: ELSE
364: CLOSE csr_members;
365: END IF;
366: END IF;
367: hr_utility.set_location(' Leaving:'||l_proc, 60);
368:
369: --MULTI MESSAGE SUPPORT
370: EXCEPTION
371:

Line 377: hr_utility.set_location(' Leaving:'||l_proc, 62);

373:
374: IF hr_multi_message.exception_add(
375: p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID') THEN
376:
377: hr_utility.set_location(' Leaving:'||l_proc, 62);
378: RAISE;
379:
380: END IF;
381: hr_utility.set_location(' Leaving:'||l_proc, 65);

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

377: hr_utility.set_location(' Leaving:'||l_proc, 62);
378: RAISE;
379:
380: END IF;
381: hr_utility.set_location(' Leaving:'||l_proc, 65);
382:
383:
384: END chk_time_period_id;
385: -- ----------------------------------------------------------------------------

Line 401: hr_utility.set_location(' Step:'|| l_proc, 10);

397: --
398: -- check mandatory parameters have been set
399: --
400: --
401: hr_utility.set_location(' Step:'|| l_proc, 10);
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc
404: ,p_argument => 'p_plan_status_type_id'
405: ,p_argument_value => p_plan_status_type_id

Line 408: hr_utility.set_location(' Step:'|| l_proc, 20);

404: ,p_argument => 'p_plan_status_type_id'
405: ,p_argument_value => p_plan_status_type_id
406: );
407: --
408: hr_utility.set_location(' Step:'|| l_proc, 20);
409: IF hr_api.not_exists_in_hr_lookups
410: (p_effective_date => p_effective_date
411: ,p_lookup_type => 'OTA_PLAN_USER_STATUS_TYPE'
412: ,p_lookup_code => p_plan_status_type_id

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

420: fnd_message.raise_error;
421: END IF;
422: --
423: --
424: hr_utility.set_location(' Leaving:'||l_proc, 30);
425:
426: --MULTI MESSAGE SUPPORT
427: EXCEPTION
428:

Line 434: hr_utility.set_location(' Leaving:'||l_proc, 32);

430:
431: IF hr_multi_message.exception_add(
432: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID') THEN
433:
434: hr_utility.set_location(' Leaving:'||l_proc, 32);
435: RAISE;
436:
437: END IF;
438: hr_utility.set_location(' Leaving:'||l_proc, 35);

Line 438: hr_utility.set_location(' Leaving:'||l_proc, 35);

434: hr_utility.set_location(' Leaving:'||l_proc, 32);
435: RAISE;
436:
437: END IF;
438: hr_utility.set_location(' Leaving:'||l_proc, 35);
439:
440: END chk_plan_status_type_id;
441: -- ----------------------------------------------------------------------------
442: -- |-------------------------------------------------------|

Line 493: hr_utility.set_location(' Step:'|| l_proc, 10);

489: --
490: -- check mandatory parameters have been set
491: --
492: --
493: hr_utility.set_location(' Step:'|| l_proc, 10);
494:
495:
496: --MULTI MESSAGE SUPPORT
497:

Line 516: hr_utility.set_location(' Step:'|| l_proc, 20);

512: ,p_argument_value => p_plan_status_type_id
513: );
514: --
515: --
516: hr_utility.set_location(' Step:'|| l_proc, 20);
517: hr_api.mandatory_arg_error
518: (p_api_name => l_proc
519: ,p_argument => 'p_time_period_id'
520: ,p_argument_value => p_time_period_id

Line 523: hr_utility.set_location(' Step:'|| l_proc, 30);

519: ,p_argument => 'p_time_period_id'
520: ,p_argument_value => p_time_period_id
521: );
522: --
523: hr_utility.set_location(' Step:'|| l_proc, 30);
524: --
525: l_api_updating := ota_tps_shd.api_updating
526: (p_training_plan_id => p_training_plan_id
527: ,p_object_version_number => p_object_version_number

Line 547: hr_utility.set_location(' Step:'|| l_proc, 50);

543: THEN
544: --
545: -- Fetch the plan dates
546: --
547: hr_utility.set_location(' Step:'|| l_proc, 50);
548: OPEN csr_get_dates;
549: FETCH csr_get_dates INTO l_start_date, l_end_date;
550: CLOSE csr_get_dates;
551: --

Line 554: hr_utility.set_location(' Step:'|| l_proc, 60);

550: CLOSE csr_get_dates;
551: --
552: -- Look for duplicates
553: --
554: hr_utility.set_location(' Step:'|| l_proc, 60);
555: OPEN csr_plan_overlap;
556: FETCH csr_plan_overlap INTO l_exists;
557: IF csr_plan_overlap%FOUND THEN
558: CLOSE csr_plan_overlap;

Line 559: hr_utility.set_location(' Step:'|| l_proc, 70);

555: OPEN csr_plan_overlap;
556: FETCH csr_plan_overlap INTO l_exists;
557: IF csr_plan_overlap%FOUND THEN
558: CLOSE csr_plan_overlap;
559: hr_utility.set_location(' Step:'|| l_proc, 70);
560: fnd_message.set_name('OTA', 'OTA_13863_TPS_OVERLAP_PLANS');
561: fnd_message.raise_error;
562: ELSE
563: CLOSE csr_plan_overlap;

Line 568: hr_utility.set_location(' Leaving:'||l_proc, 80);

564: END IF;
565: END IF;
566: --
567: END IF;
568: hr_utility.set_location(' Leaving:'||l_proc, 80);
569:
570: EXCEPTION
571:
572: WHEN app_exception.application_exception THEN

Line 577: hr_utility.set_location(' Leaving:'||l_proc, 82);

573:
574: IF hr_multi_message.exception_add
575: (p_same_associated_columns => 'Y') THEN
576:
577: hr_utility.set_location(' Leaving:'||l_proc, 82);
578: RAISE;
579: END IF;
580:
581: hr_utility.set_location(' Leaving:'||l_proc, 85);

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

577: hr_utility.set_location(' Leaving:'||l_proc, 82);
578: RAISE;
579: END IF;
580:
581: hr_utility.set_location(' Leaving:'||l_proc, 85);
582:
583:
584: END chk_period_overlap;
585: -- ----------------------------------------------------------------------------

Line 610: hr_utility.set_location(' Step:'|| l_proc, 30);

606: --
607: -- check mandatory parameters have been set. Currency code can
608: -- be null, so it is not mandatory.
609: --
610: hr_utility.set_location(' Step:'|| l_proc, 30);
611: hr_api.mandatory_arg_error
612: (p_api_name => l_proc
613: ,p_argument => 'p_business_group_id'
614: ,p_argument_value => p_business_group_id

Line 617: hr_utility.set_location(' Step:'|| l_proc, 40);

613: ,p_argument => 'p_business_group_id'
614: ,p_argument_value => p_business_group_id
615: );
616: --
617: hr_utility.set_location(' Step:'|| l_proc, 40);
618: hr_api.mandatory_arg_error
619: (p_api_name => l_proc
620: ,p_argument => 'p_budget_currency'
621: ,p_argument_value => p_budget_currency

Line 636: hr_utility.set_location(' Step:'|| l_proc, 50);

632: NVL(ota_tps_shd.g_old_rec.budget_currency, hr_api.g_varchar2) <>
633: NVL(p_budget_currency, hr_api.g_varchar2) )
634: OR (NOT l_api_updating))
635: THEN
636: hr_utility.set_location(' Step:'|| l_proc, 50);
637: IF p_budget_currency IS NOT NULL THEN
638: OPEN csr_currency_code;
639: FETCH csr_currency_code INTO l_exists;
640: IF csr_currency_code%NOTFOUND THEN

Line 651: hr_utility.set_location(' Leaving:'||l_proc, 90);

647: END IF;
648: END IF;
649: END IF;
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 90);
652:
653: --MULTI MESSAGE SUPPORT
654: EXCEPTION
655:

Line 661: hr_utility.set_location(' Leaving:'||l_proc, 92);

657:
658: IF hr_multi_message.exception_add(
659: p_associated_column1 => 'OTA_TRAINING_PLANS.BUDGET_CURRENCY') THEN
660:
661: hr_utility.set_location(' Leaving:'||l_proc, 92);
662: RAISE;
663:
664: END IF;
665: hr_utility.set_location(' Leaving:'||l_proc, 95);

Line 665: hr_utility.set_location(' Leaving:'||l_proc, 95);

661: hr_utility.set_location(' Leaving:'||l_proc, 92);
662: RAISE;
663:
664: END IF;
665: hr_utility.set_location(' Leaving:'||l_proc, 95);
666:
667: END chk_currency_code;
668: --
669: --

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

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

Line 729: hr_utility.set_location(' Step:'|| l_proc, 50);

725: NVL(ota_tps_shd.g_old_rec.name, hr_api.g_varchar2) <>
726: NVL(p_name, hr_api.g_varchar2) )
727: OR (NOT l_api_updating))
728: THEN
729: hr_utility.set_location(' Step:'|| l_proc, 50);
730: IF p_name IS NOT NULL THEN
731: --Bug#3484692
732: --check if lp is org or non-org
733: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan()) THEN

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

752: END IF;
753: END IF;
754: END IF;
755: END IF;
756: hr_utility.set_location(' Leaving:'||l_proc, 10);
757:
758: --MULTI MESSAGE SUPPORT
759: EXCEPTION
760:

Line 766: hr_utility.set_location(' Leaving:'||l_proc, 12);

762:
763: IF hr_multi_message.exception_add(
764: p_associated_column1 => 'OTA_TRAINING_PLANS.NAME') THEN
765:
766: hr_utility.set_location(' Leaving:'||l_proc, 12);
767: RAISE;
768:
769: END IF;
770: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 770: hr_utility.set_location(' Leaving:'||l_proc, 15);

766: hr_utility.set_location(' Leaving:'||l_proc, 12);
767: RAISE;
768:
769: END IF;
770: hr_utility.set_location(' Leaving:'||l_proc, 15);
771: --
772: END chk_name;
773: -- ----------------------------------------------------------------------------
774: -- |-------------------------------------------------|

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

796: BEGIN
797: --
798: -- check mandatory parameters have been set
799: --
800: hr_utility.set_location('Entering:'||l_proc, 5);
801: hr_api.mandatory_arg_error
802: (p_api_name => l_proc
803: ,p_argument => 'p_training_plan_id'
804: ,p_argument_value => p_training_plan_id

Line 813: hr_utility.set_location(' Step:'|| l_proc, 10);

809: OPEN csr_del_training_plan_id;
810: FETCH csr_del_training_plan_id INTO l_exists;
811: IF csr_del_training_plan_id%FOUND THEN
812: CLOSE csr_del_training_plan_id;
813: hr_utility.set_location(' Step:'|| l_proc, 10);
814: fnd_message.set_name('OTA', 'OTA_13868_TPS_CHILD_RECORDS');
815: fnd_message.raise_error;
816: END IF;
817: CLOSE csr_del_training_plan_id;

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

814: fnd_message.set_name('OTA', 'OTA_13868_TPS_CHILD_RECORDS');
815: fnd_message.raise_error;
816: END IF;
817: CLOSE csr_del_training_plan_id;
818: hr_utility.set_location(' Leaving:'||l_proc, 20);
819: --
820: END chk_del_training_plan_id;
821: --
822:

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

832: l_proc varchar2(72) := g_package||'chk_plan_source';
833: l_api_updating boolean;
834:
835: BEGIN
836: hr_utility.set_location(' Leaving:'||l_proc, 10);
837: --
838: -- check mandatory parameters has been set
839: --
840: hr_api.mandatory_arg_error

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

847: NVL(p_plan_source,hr_api.g_varchar2))
848: OR
849: (p_training_plan_id IS NULL)) THEN
850:
851: hr_utility.set_location(' Leaving:'||l_proc, 20);
852: --
853:
854: --
855: IF p_plan_source IS NOT NULL THEN

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

859: ,p_lookup_code => p_plan_source) THEN
860: fnd_message.set_name('OTA','OTA_13176_TPM_PLN_SRC_INVLD');
861: fnd_message.raise_error;
862: END IF;
863: hr_utility.set_location(' Leaving:'||l_proc, 30);
864:
865: END IF;
866:
867: END IF;

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

864:
865: END IF;
866:
867: END IF;
868: hr_utility.set_location(' Leaving:'||l_proc, 40);
869:
870: --MULTI MESSAGE SUPPORT
871: EXCEPTION
872:

Line 878: hr_utility.set_location(' Leaving:'||l_proc, 42);

874:
875: IF hr_multi_message.exception_add(
876: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_SOURCE') THEN
877:
878: hr_utility.set_location(' Leaving:'||l_proc, 42);
879: RAISE;
880:
881: END IF;
882: hr_utility.set_location(' Leaving:'||l_proc, 45);

Line 882: hr_utility.set_location(' Leaving:'||l_proc, 45);

878: hr_utility.set_location(' Leaving:'||l_proc, 42);
879: RAISE;
880:
881: END IF;
882: hr_utility.set_location(' Leaving:'||l_proc, 45);
883:
884:
885: END chk_plan_source;
886:

Line 924: hr_utility.set_location(' Step:'|| l_proc, 10);

920: BEGIN
921:
922: -- check mandatory parameters have been set
923: --
924: hr_utility.set_location(' Step:'|| l_proc, 10);
925:
926: hr_api.mandatory_arg_error
927: (p_api_name => l_proc
928: ,p_argument => 'p_start_date'

Line 947: hr_utility.set_location(' Step:'|| l_proc, 20);

943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>
944: NVL( p_end_date, hr_api.g_date) )
945: OR ( NOT l_api_updating) )
946: THEN
947: hr_utility.set_location(' Step:'|| l_proc, 20);
948:
949: /* IF ( NOT l_api_updating
950: or NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
951: NVL( p_start_date, hr_api.g_date )) THEN

Line 1021: hr_utility.set_location(' Step:'|| l_proc, 30);

1017:
1018:
1019: END IF;
1020:
1021: hr_utility.set_location(' Step:'|| l_proc, 30);
1022:
1023:
1024: --MULTI MESSAGE SUPPORT
1025: EXCEPTION

Line 1033: hr_utility.set_location(' Leaving:'||l_proc, 32);

1029: IF l_flag = 'END_DATE' THEN
1030:
1031: /* IF hr_multi_message.exception_add(
1032: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE') THEN
1033: hr_utility.set_location(' Leaving:'||l_proc, 32);
1034: RAISE;
1035:
1036: END IF;
1037: ELSIF l_flag = 'END_DATE' THEN */

Line 1042: hr_utility.set_location(' Leaving:'||l_proc, 34);

1038:
1039: IF hr_multi_message.exception_add(
1040: p_associated_column1 => 'OTA_TRAINING_PLANS.END_DATE') THEN
1041:
1042: hr_utility.set_location(' Leaving:'||l_proc, 34);
1043: RAISE;
1044:
1045: END IF;
1046:

Line 1053: hr_utility.set_location(' Leaving:'||l_proc, 36);

1049: IF hr_multi_message.exception_add(
1050: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE'
1051: ,p_associated_column2 => 'OTA_TRAINING_PLANS.END_DATE') THEN
1052:
1053: hr_utility.set_location(' Leaving:'||l_proc, 36);
1054: RAISE;
1055:
1056: END IF;
1057:

Line 1059: hr_utility.set_location(' Leaving:'||l_proc, 38);

1055:
1056: END IF;
1057:
1058: END IF;
1059: hr_utility.set_location(' Leaving:'||l_proc, 38);
1060:
1061: END chk_tp_date_range;
1062:
1063: END ota_tps_bus1;