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

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

38: l_proc varchar2(72) := g_package||'set_security_group_id';
39: --
40: BEGIN
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error

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

75: (p_security_group_id => l_security_group_id
76: );
77: --
78: END IF;
79: hr_utility.set_location(' Leaving:'|| l_proc, 20);
80: --
81: END set_security_group_id;
82: --
83: -- ---------------------------------------------------------------------------

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

104: l_proc varchar2(72) := g_package||'return_legislation_code';
105: --
106: BEGIN
107: --
108: hr_utility.set_location('Entering:'|| l_proc, 10);
109: --
110: -- Ensure that all the mandatory parameter are not null
111: --
112: hr_api.mandatory_arg_error

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

122: -- call to this function. Just return the value in the global
123: -- variable.
124: --
125: l_legislation_code := ota_tps_bus.g_legislation_code;
126: hr_utility.set_location(l_proc, 20);
127: ELSE
128: --
129: -- The ID is different to the last call to this function
130: -- or this is the first call to this function.

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

139: CLOSE csr_leg_code;
140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: END IF;
143: hr_utility.set_location(l_proc,30);
144: --
145: -- Set the global variables so the values are
146: -- available for the next call to this function.
147: --

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

148: CLOSE csr_leg_code;
149: ota_tps_bus.g_training_plan_id := p_training_plan_id;
150: ota_tps_bus.g_legislation_code := l_legislation_code;
151: END IF;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: RETURN l_legislation_code;
154: END return_legislation_code;
155: --
156: -- ----------------------------------------------------------------------------

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

187: --
188: l_proc varchar2(72) := g_package || 'chk_df';
189: --
190: BEGIN
191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: IF ((p_rec.training_plan_id IS NOT NULL) AND (
194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR

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

326: ,p_attribute30_value => p_rec.attribute30
327: );
328: END IF;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc,20);
331: END chk_df;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |-----------------------< chk_non_updateable_args >------------------------|

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

381: fnd_message.raise_error;
382: END IF;
383: --
384: --
385: hr_utility.set_location(' Step:'|| l_proc, 10);
386: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
388: hr_api.argument_changed_error
389: (p_api_name => l_proc

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

390: ,p_argument => 'BUSINESS_GROUP_ID'
391: ,p_base_table => ota_tps_shd.g_tab_nam);
392: END IF;
393: --
394: hr_utility.set_location(' Step:'|| l_proc, 20);
395: IF NVL(p_rec.training_plan_id, hr_api.g_number) <>
396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN
397: hr_api.argument_changed_error
398: (p_api_name => l_proc

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

399: ,p_argument => 'TRAINING_PLAN_ID'
400: ,p_base_table => ota_tps_shd.g_tab_nam);
401: END IF;
402: --
403: hr_utility.set_location(' Step:'|| l_proc, 30);
404: IF NVL(p_rec.organization_id, hr_api.g_number) <>
405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN
406: hr_api.argument_changed_error
407: (p_api_name => l_proc

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

408: ,p_argument => 'ORGANIZATION_ID'
409: ,p_base_table => ota_tps_shd.g_tab_nam);
410: END IF;
411: --
412: hr_utility.set_location(' Step:'|| l_proc, 40);
413: IF NVL(p_rec.person_id, hr_api.g_number) <>
414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN
415: hr_api.argument_changed_error
416: (p_api_name => l_proc

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

434: --
435: l_proc varchar2(72) := g_package||'insert_validate';
436: --
437: BEGIN
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: -- Call all supporting business operations
441: --Validate Important Attributes
442: --

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

445: --
446: hr_multi_message.end_validation_set;
447:
448: --
449: hr_utility.set_location(' Step:'|| l_proc, 20);
450: ota_tps_bus1.chk_org_person (
451: p_organization_id => p_rec.organization_id
452: ,p_person_id => p_rec.person_id
453: ,p_contact_id => p_rec.contact_id);

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

451: p_organization_id => p_rec.organization_id
452: ,p_person_id => p_rec.person_id
453: ,p_contact_id => p_rec.contact_id);
454: --
455: hr_utility.set_location(' Step:'|| l_proc, 30);
456: ota_tps_bus1.chk_organization_id (
457: p_organization_id => p_rec.organization_id
458: ,p_business_group_id => p_rec.business_group_id);
459: --

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

456: ota_tps_bus1.chk_organization_id (
457: p_organization_id => p_rec.organization_id
458: ,p_business_group_id => p_rec.business_group_id);
459: --
460: hr_utility.set_location(' Step:'|| l_proc, 40);
461: ota_tps_bus1.chk_person_id (
462: p_effective_date => p_effective_date
463: ,p_person_id => p_rec.person_id
464: ,p_business_group_id => p_rec.business_group_id);

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

462: p_effective_date => p_effective_date
463: ,p_person_id => p_rec.person_id
464: ,p_business_group_id => p_rec.business_group_id);
465: --
466: hr_utility.set_location(' Step:'|| l_proc, 50);
467: -- Set the Is_Per_Trng_Plan global variable
468: IF p_rec.person_id IS NOT NULL OR p_rec.contact_id IS NOT NULL THEN
469: OTA_TRNG_PLAN_UTIL_SS.g_is_per_trng_plan := TRUE;
470: END IF;

Line 476: hr_utility.set_location(' Step:'|| l_proc, 80);

472: ota_tps_bus1.chk_plan_status_type_id (
473: p_effective_date => p_effective_date
474: ,p_plan_status_type_id => p_rec.plan_status_type_id);
475: --
476: hr_utility.set_location(' Step:'|| l_proc, 80);
477: ota_tps_bus1.chk_currency_code (
478: p_budget_currency => p_rec.budget_currency
479: ,p_training_plan_id => p_rec.training_plan_id
480: ,p_business_group_id => p_rec.business_group_id

Line 484: hr_utility.set_location(' Step:'|| l_proc, 90);

480: ,p_business_group_id => p_rec.business_group_id
481: ,p_object_version_number => p_rec.object_version_number);
482: --
483: IF p_rec.learning_path_id IS NULL THEN
484: hr_utility.set_location(' Step:'|| l_proc, 90);
485: ota_tps_bus1.chk_name
486: (p_name => p_rec.name
487: ,p_training_plan_id => p_rec.training_plan_id
488: ,p_person_id => p_rec.person_id --Bug#3484692

Line 495: hr_utility.set_location(' Step:'|| l_proc, 55);

491: ,p_object_version_number => p_rec.object_version_number );
492: END IF;
493:
494: IF p_rec.person_id IS NOT NULL OR p_rec.contact_id IS NOT NULL THEN
495: hr_utility.set_location(' Step:'|| l_proc, 55);
496:
497:
498: ota_tps_bus1.chk_tp_date_range
499: (p_training_plan_id => p_rec.training_plan_id

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

506: ,p_plan_source => p_rec.plan_source
507: ,p_training_plan_id => p_rec.training_plan_id);
508:
509: ELSIF p_rec.person_id IS NULL AND p_rec.contact_id IS NULL THEN
510: hr_utility.set_location(' Step:'|| l_proc, 60);
511: ota_tps_bus1.chk_time_period_id (
512: p_training_plan_id => p_rec.training_plan_id
513: ,p_object_version_number => p_rec.object_version_number
514: ,p_time_period_id => p_rec.time_period_id

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

521: ,p_organization_id => p_rec.organization_id
522: ,p_person_id => p_rec.person_id
523: ,p_time_period_id => p_rec.time_period_id );
524:
525: hr_utility.set_location(' Step:'|| l_proc, 70);
526: ota_tps_bus1.chk_period_overlap (
527: p_training_plan_id => p_rec.training_plan_id
528: ,p_object_version_number => p_rec.object_version_number
529: ,p_plan_status_type_id => p_rec.plan_status_type_id

Line 539: hr_utility.set_location(' Leaving:'||l_proc, 100);

535:
536: --
537: ota_tps_bus.chk_df(p_rec);
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 100);
540: END insert_validate;
541: --
542: -- ----------------------------------------------------------------------------
543: -- |---------------------------< update_validate >----------------------------|

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

550: l_proc varchar2(72) := g_package||'update_validate';
551: l_boolean boolean := null;
552: --
553: BEGIN
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: -- Call all supporting business operations
557: --Validate Important attribute
558:

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

565: (p_effective_date => p_effective_date
566: ,p_rec => p_rec
567: );
568: --
569: hr_utility.set_location(' Step:'|| l_proc, 10);
570: -- Set the Is_Per_Trng_Plan global variable
571: l_boolean := OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_rec.training_plan_id);
572:
573: ota_tps_bus1.chk_plan_status_type_id (

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

573: ota_tps_bus1.chk_plan_status_type_id (
574: p_effective_date => p_effective_date
575: ,p_plan_status_type_id => p_rec.plan_status_type_id);
576: --
577: hr_utility.set_location(' Step:'|| l_proc, 40);
578:
579: ota_tps_bus1.chk_currency_code (
580: p_budget_currency => p_rec.budget_currency
581: ,p_training_plan_id => p_rec.training_plan_id

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

581: ,p_training_plan_id => p_rec.training_plan_id
582: ,p_business_group_id => p_rec.business_group_id
583: ,p_object_version_number => p_rec.object_version_number);
584: --
585: hr_utility.set_location(' Step:'|| l_proc, 50);
586:
587: ota_tps_bus1.chk_name (
588: p_name => p_rec.name
589: ,p_training_plan_id => p_rec.training_plan_id

Line 597: hr_utility.set_location(' Step:'|| l_proc, 15);

593: ,p_object_version_number => p_rec.object_version_number);
594: --
595:
596: IF p_rec.person_id IS NOT NULL OR p_rec.contact_id IS NOT NULL THEN
597: hr_utility.set_location(' Step:'|| l_proc, 15);
598:
599: ota_tps_bus1.chk_tp_date_range
600: (p_training_plan_id => p_rec.training_plan_id
601: ,p_start_date => p_rec.start_date

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

609:
610: END IF;
611: --
612: IF p_rec.person_id IS NULL AND p_rec.contact_id IS NULL THEN
613: hr_utility.set_location(' Step:'|| l_proc, 20);
614: ota_tps_bus1.chk_time_period_id (
615: p_training_plan_id => p_rec.training_plan_id
616: ,p_object_version_number => p_rec.object_version_number
617: ,p_time_period_id => p_rec.time_period_id

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

616: ,p_object_version_number => p_rec.object_version_number
617: ,p_time_period_id => p_rec.time_period_id
618: ,p_business_group_id => p_rec.business_group_id);
619: --
620: hr_utility.set_location(' Step:'|| l_proc, 30);
621:
622: ota_tps_bus1.chk_unique (
623: p_training_plan_id => p_rec.training_plan_id
624: ,p_object_version_number => p_rec.object_version_number

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

635: ,p_person_id => p_rec.person_id
636: ,p_organization_id => p_rec.organization_id);
637: END IF;
638:
639: hr_utility.set_location(' Step:'|| l_proc, 60);
640: ota_tps_bus.chk_df(p_rec);
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 70);
643: END update_validate;

Line 642: hr_utility.set_location(' Leaving:'||l_proc, 70);

638:
639: hr_utility.set_location(' Step:'|| l_proc, 60);
640: ota_tps_bus.chk_df(p_rec);
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 70);
643: END update_validate;
644: --
645: -- ----------------------------------------------------------------------------
646: -- |---------------------------< delete_validate >----------------------------|

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

651: --
652: l_proc varchar2(72) := g_package||'delete_validate';
653: --
654: BEGIN
655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- Call all supporting business operations
658: --
659: hr_utility.set_location(' Step:'|| l_proc, 10);

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

655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- Call all supporting business operations
658: --
659: hr_utility.set_location(' Step:'|| l_proc, 10);
660: ota_tps_bus1.chk_del_training_plan_id(
661: p_training_plan_id => ota_tps_shd.g_old_rec.training_plan_id);
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

659: hr_utility.set_location(' Step:'|| l_proc, 10);
660: ota_tps_bus1.chk_del_training_plan_id(
661: p_training_plan_id => ota_tps_shd.g_old_rec.training_plan_id);
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 20);
664: END delete_validate;
665: --
666: END ota_tps_bus;