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

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

41: l_proc varchar2(72) := g_package||'set_security_group_id';
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 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_tpm_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_tpm_bus.g_training_plan_member_id := p_training_plan_member_id;
150: ota_tpm_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_member_id IS NOT NULL) AND (
194: NVL(ota_tpm_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 384: hr_utility.set_location(' Step:'|| l_proc, 10);

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

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

390: ,p_base_table => ota_tpm_shd.g_tab_nam);
391: END IF;
392: --
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_tpm_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 419: hr_utility.set_location('Entering:'||l_proc, 5);

415: l_person_id number;
416: l_personal_trng_plan boolean;
417: --
418: BEGIN
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- VALIDATE IMPORTANT ATTRIBUTES
422: --
423: hr_api.validate_bus_grp_id(p_rec.business_group_id

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

425: --
426: hr_multi_message.end_validation_set;
427: --
428: --
429: hr_utility.set_location(' Step:'|| l_proc, 10);
430: ota_tpm_bus1.chk_training_plan_id(
431: p_training_plan_id => p_rec.training_plan_id
432: ,p_business_group_id => p_rec.business_group_id);
433: --

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

431: p_training_plan_id => p_rec.training_plan_id
432: ,p_business_group_id => p_rec.business_group_id);
433: --
434:
435: hr_utility.set_location(' Step:'|| l_proc, 20);
436: ota_tpm_bus1.chk_member_status_type_id(
437: p_effective_date => p_effective_date
438: ,p_member_status_type_id => p_rec.member_status_type_id
439: ,p_business_group_id => p_rec.business_group_id

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

444: ,p_training_plan_id => p_rec.training_plan_id
445: ,p_target_completion_date => p_rec.target_completion_date);
446: --
447:
448: hr_utility.set_location(' Step:'|| l_proc, 30);
449: ota_tpm_bus1.chk_version_definition(
450: p_training_plan_member_id => p_rec.training_plan_member_id
451: ,p_object_version_number => p_rec.object_version_number
452: ,p_activity_definition_id => p_rec.activity_definition_id

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

454: ,p_training_plan_id => p_rec.training_plan_id
455: ,p_business_group_id => p_rec.business_group_id);
456:
457: --
458: hr_utility.set_location(' Step:'|| l_proc, 40);
459: ota_tpm_bus1.chk_activity_version_id (
460: p_training_plan_member_id => p_rec.training_plan_member_id
461: ,p_object_version_number => p_rec.object_version_number
462: ,p_activity_version_id => p_rec.activity_version_id

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

471:
472: -- IF l_person_id = 0 THEN
473: IF NOT l_personal_trng_plan THEN
474:
475: hr_utility.set_location(' Step:'|| l_proc, 50);
476: ota_tpm_bus1.chk_activity_definition_id (
477: p_training_plan_member_id => p_rec.training_plan_member_id
478: ,p_object_version_number => p_rec.object_version_number
479: ,p_activity_definition_id => p_rec.activity_definition_id

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

478: ,p_object_version_number => p_rec.object_version_number
479: ,p_activity_definition_id => p_rec.activity_definition_id
480: ,p_business_group_id => p_rec.business_group_id);
481:
482: hr_utility.set_location(' Step:'|| l_proc, 60);
483: ota_tpm_bus1.chk_unique(
484: p_training_plan_member_id => p_rec.training_plan_member_id
485: ,p_object_version_number => p_rec.object_version_number
486: ,p_activity_definition_id => p_rec.activity_definition_id

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

486: ,p_activity_definition_id => p_rec.activity_definition_id
487: ,p_activity_version_id => p_rec.activity_version_id
488: ,p_training_plan_id => p_rec.training_plan_id);
489: ELSE
490: hr_utility.set_location(' Step:'|| l_proc, 70);
491: ota_tpm_bus1.chk_source_function(
492: p_training_plan_member_id => p_rec.training_plan_member_id
493: ,p_source_function => p_rec.source_function
494: ,p_effective_date => p_effective_date);

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

492: p_training_plan_member_id => p_rec.training_plan_member_id
493: ,p_source_function => p_rec.source_function
494: ,p_effective_date => p_effective_date);
495:
496: hr_utility.set_location(' Step:'|| l_proc, 80);
497: ota_tpm_bus1.chk_cancellation_reason(
498: p_training_plan_member_id => p_rec.training_plan_member_id
499: ,p_cancellation_reason => p_rec.cancellation_reason
500: ,p_effective_date => p_effective_date);

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

498: p_training_plan_member_id => p_rec.training_plan_member_id
499: ,p_cancellation_reason => p_rec.cancellation_reason
500: ,p_effective_date => p_effective_date);
501:
502: hr_utility.set_location(' Step:'|| l_proc, 90);
503: ota_tpm_bus1.chk_tpc_tp_actver_dates
504: (p_training_plan_id => p_rec.training_plan_id
505: ,p_training_plan_member_id => p_rec.training_plan_member_id
506: ,p_activity_version_id => p_rec.activity_version_id

Line 511: hr_utility.set_location(' Step:'|| l_proc, 100);

507: ,p_earliest_start_date => p_rec.earliest_start_date
508: ,p_target_completion_date =>p_rec.target_completion_date
509: ,p_object_version_number =>p_rec.object_version_number);
510:
511: hr_utility.set_location(' Step:'|| l_proc, 100);
512: ota_tpm_bus1.chk_unique1(
513: p_training_plan_member_id => p_rec.training_plan_member_id
514: ,p_object_version_number => p_rec.object_version_number
515: ,p_activity_definition_id => p_rec.activity_definition_id

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

521: END IF;
522:
523:
524:
525: hr_utility.set_location(' Step:'|| l_proc, 70);
526:
527: ota_tpm_bus.chk_df(p_rec);
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

525: hr_utility.set_location(' Step:'|| l_proc, 70);
526:
527: ota_tpm_bus.chk_df(p_rec);
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 70);
530: END insert_validate;
531: --
532: -- ----------------------------------------------------------------------------
533: -- |---------------------------< update_validate >----------------------------|

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

542: l_personal_trng_plan BOOLEAN;
543:
544: --
545: BEGIN
546: hr_utility.set_location('Entering:'||l_proc, 5);
547: --
548: -- VALIDATE IMPORTANT ATTRIBUTES
549: --
550: hr_api.validate_bus_grp_id(p_rec.business_group_id

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

556: (p_effective_date => p_effective_date
557: ,p_rec => p_rec
558: );
559: --
560: hr_utility.set_location(' Step:'|| l_proc, 20);
561:
562: -- Modified for Bug#3479186
563: -- l_person_id :=ota_trng_plan_util_ss.get_person_id(p_training_plan_id => p_rec.training_plan_id);
564: l_personal_trng_plan := ota_trng_plan_util_ss.is_personal_trng_plan(p_training_plan_id => p_rec.training_plan_id);

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

563: -- l_person_id :=ota_trng_plan_util_ss.get_person_id(p_training_plan_id => p_rec.training_plan_id);
564: l_personal_trng_plan := ota_trng_plan_util_ss.is_personal_trng_plan(p_training_plan_id => p_rec.training_plan_id);
565:
566:
567: hr_utility.set_location(' Step:'|| l_proc, 10);
568: ota_tpm_bus1.chk_activity_definition_id (
569: p_training_plan_member_id => p_rec.training_plan_member_id
570: ,p_object_version_number => p_rec.object_version_number
571: ,p_activity_definition_id => p_rec.activity_definition_id

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

570: ,p_object_version_number => p_rec.object_version_number
571: ,p_activity_definition_id => p_rec.activity_definition_id
572: ,p_business_group_id => p_rec.business_group_id);
573: --
574: hr_utility.set_location(' Step:'|| l_proc, 20);
575: ota_tpm_bus1.chk_member_status_type_id(
576: p_effective_date => p_effective_date
577: ,p_member_status_type_id => p_rec.member_status_type_id
578: ,p_business_group_id => p_rec.business_group_id

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

582: ,p_activity_version_id => p_rec.activity_version_id
583: ,p_training_plan_id => p_rec.training_plan_id
584: ,p_target_completion_date => p_rec.target_completion_date);
585: --
586: hr_utility.set_location(' Step:'|| l_proc, 30);
587: ota_tpm_bus1.chk_version_definition(
588: p_training_plan_member_id => p_rec.training_plan_member_id
589: ,p_object_version_number => p_rec.object_version_number
590: ,p_activity_definition_id => p_rec.activity_definition_id

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

591: ,p_activity_version_id => p_rec.activity_version_id
592: ,p_training_plan_id => p_rec.training_plan_id
593: ,p_business_group_id => p_rec.business_group_id);
594: --
595: hr_utility.set_location(' Step:'|| l_proc, 40);
596: ota_tpm_bus1.chk_activity_version_id (
597: p_training_plan_member_id => p_rec.training_plan_member_id
598: ,p_object_version_number => p_rec.object_version_number
599: ,p_activity_version_id => p_rec.activity_version_id

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

603: -- Modified for Bug#3479186
604: -- IF l_person_id <> 0 THEN
605: IF l_personal_trng_plan THEN
606:
607: hr_utility.set_location(' Step:'|| l_proc, 50);
608: ota_tpm_bus1.chk_source_function(
609: p_training_plan_member_id => p_rec.training_plan_member_id
610: ,p_source_function => p_rec.source_function
611: ,p_effective_date => p_effective_date);

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

609: p_training_plan_member_id => p_rec.training_plan_member_id
610: ,p_source_function => p_rec.source_function
611: ,p_effective_date => p_effective_date);
612:
613: hr_utility.set_location(' Step:'|| l_proc, 60);
614: ota_tpm_bus1.chk_cancellation_reason(
615: p_training_plan_member_id => p_rec.training_plan_member_id
616: ,p_cancellation_reason => p_rec.cancellation_reason
617: ,p_effective_date => p_effective_date);

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

615: p_training_plan_member_id => p_rec.training_plan_member_id
616: ,p_cancellation_reason => p_rec.cancellation_reason
617: ,p_effective_date => p_effective_date);
618:
619: hr_utility.set_location(' Step:'|| l_proc, 70);
620: ota_tpm_bus1.chk_tpc_tp_actver_dates
621: (p_training_plan_id => p_rec.training_plan_id
622: ,p_training_plan_member_id => p_rec.training_plan_member_id
623: ,p_activity_version_id => p_rec.activity_version_id

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

624: ,p_earliest_start_date => p_rec.earliest_start_date
625: ,p_target_completion_date =>p_rec.target_completion_date
626: ,p_object_version_number =>p_rec.object_version_number);
627:
628: hr_utility.set_location(' Step:'|| l_proc, 80);
629: ota_tpm_bus1.chk_unique1(
630: p_training_plan_member_id => p_rec.training_plan_member_id
631: ,p_object_version_number => p_rec.object_version_number
632: ,p_activity_definition_id => p_rec.activity_definition_id

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

637: -- Modified for Bug#3479186
638: -- ELSIF l_person_id = 0 THEN
639: ELSE
640:
641: hr_utility.set_location(' Step:'|| l_proc, 90);
642: ota_tpm_bus1.chk_unique(
643: p_training_plan_member_id => p_rec.training_plan_member_id
644: ,p_object_version_number => p_rec.object_version_number
645: ,p_activity_definition_id => p_rec.activity_definition_id

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

647: ,p_training_plan_id => p_rec.training_plan_id);
648: -- Commented by rdola on 6/4/03
649: END IF;
650:
651: hr_utility.set_location(' Step:'|| l_proc, 60);
652:
653:
654: ota_tpm_bus.chk_df(p_rec);
655: --

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

652:
653:
654: ota_tpm_bus.chk_df(p_rec);
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 70);
657: END update_validate;
658: --
659: -- ----------------------------------------------------------------------------
660: -- |---------------------------< delete_validate >----------------------------|

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

665: --
666: l_proc varchar2(72) := g_package||'delete_validate';
667: --
668: BEGIN
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);

Line 673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);

669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);
674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);
675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );

Line 674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);

670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);
674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);
675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );
678: --

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

675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );
678: --
679: hr_utility.set_location(' Leaving:'||l_proc, 10);
680: END delete_validate;
681: --
682: END ota_tpm_bus;