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

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

46: l_legislation_code varchar2(150);
47: --
48: begin
49: --
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: -- Ensure that all the mandatory parameter are not null
53: --
54: hr_api.mandatory_arg_error

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

93: --
94: hr_api.set_legislation_context(l_legislation_code);
95: end if;
96: --
97: hr_utility.set_location(' Leaving:'|| l_proc, 20);
98: --
99: end set_security_group_id;
100: --
101: -- ---------------------------------------------------------------------------

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

126: l_proc varchar2(72) := g_package||'return_legislation_code';
127: --
128: Begin
129: --
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Ensure that all the mandatory parameter are not null
133: --
134: hr_api.mandatory_arg_error

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

151: -- call to this function. Just return the value in the global
152: -- variable.
153: --
154: l_legislation_code := ota_lci_bus.g_legislation_code;
155: hr_utility.set_location(l_proc, 20);
156: else
157: --
158: -- The ID is different to the last call to this function
159: -- or this is the first call to this function.

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

168: close csr_leg_code;
169: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
170: fnd_message.raise_error;
171: end if;
172: hr_utility.set_location(l_proc,30);
173: --
174: -- Set the global variables so the values are
175: -- available for the next call to this function.
176: --

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

178: ota_lci_bus.g_learning_path_id := p_learning_path_id;
179: ota_lci_bus.g_category_usage_id := p_category_usage_id;
180: ota_lci_bus.g_legislation_code := l_legislation_code;
181: end if;
182: hr_utility.set_location(' Leaving:'|| l_proc, 40);
183: return l_legislation_code;
184: end return_legislation_code;
185: --
186: -- ----------------------------------------------------------------------------

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

217: --
218: l_proc varchar2(72) := g_package || 'chk_df';
219: --
220: begin
221: hr_utility.set_location('Entering:'||l_proc,10);
222: --
223: if ((p_rec.learning_path_id is not null) and
224: (p_rec.category_usage_id is not null) and (
225: nvl(ota_lci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

318: ,p_attribute20_value => p_rec.attribute20
319: );
320: end if;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc,20);
323: end chk_df;
324: --
325: -- ----------------------------------------------------------------------------
326: -- |-----------------------< chk_non_updateable_args >------------------------|

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

417: l_lp_start_date date;
418: l_lp_end_date date;
419:
420: Begin
421: hr_utility.set_location(' Entering:' || l_proc,10);
422: --
423: IF hr_multi_message.no_exclusive_error
424: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
425: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'

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

449: CLOSE csr_lp_start_end_date;
450: End IF;
451: End IF;
452: --
453: hr_utility.set_location(' Leaving:' || l_proc,10);
454: Exception
455: when app_exception.application_exception then
456: IF hr_multi_message.exception_add
457: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'

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

456: IF hr_multi_message.exception_add
457: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
458: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
459: ) THEN
460: hr_utility.set_location(' Leaving:'|| l_proc,20);
461: raise;
462: END IF;
463:
464: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

460: hr_utility.set_location(' Leaving:'|| l_proc,20);
461: raise;
462: END IF;
463:
464: hr_utility.set_location(' Leaving:'|| l_proc,30);
465: --
466: End check_lp_category_dates;
467: --
468: -- ----------------------------------------------------------------------------

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

477: --
478: l_proc varchar2(72) := g_package||'insert_validate';
479: --
480: Begin
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: --
483: -- Call all supporting business operations
484: --
485: --Added for Bug#4310348

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

502: --
503: --
504: ota_lci_bus.chk_df(p_rec);
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: End insert_validate;
508: --
509: -- ----------------------------------------------------------------------------
510: -- |---------------------------< update_validate >----------------------------|

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

524: l_end_date ota_lp_cat_inclusions.end_date_active%TYPE;
525: --
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: -- Call all supporting business operations
531: --
532: --Added for Bug#4310348

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

573:
574: --
575: ota_lci_bus.chk_df(p_rec);
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 10);
578: End update_validate;
579: --
580: -- ----------------------------------------------------------------------------
581: -- |---------------------------< delete_validate >----------------------------|

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

586: --
587: l_proc varchar2(72) := g_package||'delete_validate';
588: --
589: Begin
590: hr_utility.set_location('Entering:'||l_proc, 5);
591: --
592: -- Call all supporting business operations
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

590: hr_utility.set_location('Entering:'||l_proc, 5);
591: --
592: -- Call all supporting business operations
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 10);
595: End delete_validate;
596:
597: --
598: -- ----------------------------------------------------------------------------

Line 620: hr_utility.set_location('Entering:'|| v_proc, 5);

616: where lci.learning_path_id = p_learning_path_id
617: and lci.primary_flag = 'Y';
618: --
619: Begin
620: hr_utility.set_location('Entering:'|| v_proc, 5);
621: --
622: Open sel_multiple_primary;
623: fetch sel_multiple_primary into v_exists;
624: --

Line 633: hr_utility.set_location(' Leaving:'|| v_proc, 10);

629: fnd_message.raise_error;
630: end if;
631: close sel_multiple_primary;
632: --
633: hr_utility.set_location(' Leaving:'|| v_proc, 10);
634:
635: Exception
636: WHEN app_exception.application_exception THEN
637:

Line 643: hr_utility.set_location(' Leaving:'||v_proc, 22);

639: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.PRIMARY_FLAG')
640:
641: THEN
642:
643: hr_utility.set_location(' Leaving:'||v_proc, 22);
644: RAISE;
645:
646: END IF;
647: End check_multiple_primary_ctgr;

Line 675: hr_utility.set_location('Entering:'|| v_proc, 5);

671: and lci.category_usage_id = p_category_usage_id
672: and lci.primary_flag = 'Y';
673: --
674: Begin
675: hr_utility.set_location('Entering:'|| v_proc, 5);
676: --
677: Open sel_primary_category;
678: fetch sel_primary_category into v_exists;
679: --

Line 688: hr_utility.set_location(' Leaving:'|| v_proc, 10);

684: fnd_message.raise_error;
685: end if;
686: close sel_primary_category;
687: --
688: hr_utility.set_location(' Leaving:'|| v_proc, 10);
689: Exception
690: WHEN app_exception.application_exception THEN
691:
692: IF hr_multi_message.exception_add(

Line 697: hr_utility.set_location(' Leaving:'||v_proc, 22);

693: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.PRIMARY_FLAG')
694:
695: THEN
696:
697: hr_utility.set_location(' Leaving:'||v_proc, 22);
698: RAISE;
699:
700: END IF;
701: hr_utility.set_location(' Leaving:'||v_proc, 25);

Line 701: hr_utility.set_location(' Leaving:'||v_proc, 25);

697: hr_utility.set_location(' Leaving:'||v_proc, 22);
698: RAISE;
699:
700: END IF;
701: hr_utility.set_location(' Leaving:'||v_proc, 25);
702: End check_if_primary_category;
703: --
704: -- ----------------------------------------------------------------------------
705: -- |----------------------------< check_start_end_dates >-----------------|

Line 722: hr_utility.set_location('Entering:'|| v_proc, 5);

718: v_proc varchar2(72) := g_package||'check_start_end_dates';
719: --
720: Begin
721: --
722: hr_utility.set_location('Entering:'|| v_proc, 5);
723: --
724: ota_general.check_start_end_dates( p_start_date, p_end_date);
725: --
726: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 726: hr_utility.set_location(' Leaving:'|| v_proc, 10);

722: hr_utility.set_location('Entering:'|| v_proc, 5);
723: --
724: ota_general.check_start_end_dates( p_start_date, p_end_date);
725: --
726: hr_utility.set_location(' Leaving:'|| v_proc, 10);
727:
728: Exception
729: WHEN app_exception.application_exception THEN
730:

Line 736: hr_utility.set_location(' Leaving:'||v_proc, 22);

732: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'
733: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')
734: THEN
735:
736: hr_utility.set_location(' Leaving:'||v_proc, 22);
737: RAISE;
738:
739: END IF;
740: hr_utility.set_location(' Leaving:'||v_proc, 25);

Line 740: hr_utility.set_location(' Leaving:'||v_proc, 25);

736: hr_utility.set_location(' Leaving:'||v_proc, 22);
737: RAISE;
738:
739: END IF;
740: hr_utility.set_location(' Leaving:'||v_proc, 25);
741: --
742: End check_start_end_dates;
743: --
744: --

Line 770: hr_utility.set_location('Entering:'|| v_proc, 5);

766: where lci.learning_path_id = p_learning_path_id
767: and lci.category_usage_id = p_category_usage_id;
768: --
769: Begin
770: hr_utility.set_location('Entering:'|| v_proc, 5);
771: --
772: Open sel_unique_key;
773: fetch sel_unique_key into v_exists;
774: --

Line 783: hr_utility.set_location(' Leaving:'|| v_proc, 10);

779: fnd_message.raise_error;
780: end if;
781: close sel_unique_key;
782: --
783: hr_utility.set_location(' Leaving:'|| v_proc, 10);
784: Exception
785: WHEN app_exception.application_exception THEN
786:
787: IF hr_multi_message.exception_add(

Line 791: hr_utility.set_location(' Leaving:'||v_proc, 22);

787: IF hr_multi_message.exception_add(
788: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.learning_path_id',
789: p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
790: THEN
791: hr_utility.set_location(' Leaving:'||v_proc, 22);
792: RAISE;
793:
794: END IF;
795: hr_utility.set_location(' Leaving:'||v_proc, 25);

Line 795: hr_utility.set_location(' Leaving:'||v_proc, 25);

791: hr_utility.set_location(' Leaving:'||v_proc, 22);
792: RAISE;
793:
794: END IF;
795: hr_utility.set_location(' Leaving:'||v_proc, 25);
796: End check_unique_key;
797: --
798:
799: --

Line 830: hr_utility.set_location('Entering:'|| v_proc, 5);

826: where ctu.category_usage_id = p_category_usage_id;
827: --
828: Begin
829: --
830: hr_utility.set_location('Entering:'|| v_proc, 5);
831: --
832: Open sel_check_dates;
833: Fetch sel_check_dates into v_start_date, v_end_date;
834: IF sel_check_dates%FOUND THEN

Line 840: hr_utility.set_location(' Leaving:'|| v_proc, 10);

836: END IF;
837: --
838: Close sel_check_dates;
839: --
840: hr_utility.set_location(' Leaving:'|| v_proc, 10);
841:
842: Exception
843: WHEN app_exception.application_exception THEN
844:

Line 850: hr_utility.set_location(' Leaving:'||v_proc, 22);

846: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'
847: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')
848: THEN
849:
850: hr_utility.set_location(' Leaving:'||v_proc, 22);
851: RAISE;
852:
853: END IF;
854: hr_utility.set_location(' Leaving:'||v_proc, 25);

Line 854: hr_utility.set_location(' Leaving:'||v_proc, 25);

850: hr_utility.set_location(' Leaving:'||v_proc, 22);
851: RAISE;
852:
853: END IF;
854: hr_utility.set_location(' Leaving:'||v_proc, 25);
855: --
856: End check_category_dates;
857: --
858: --