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

Line 49: hr_utility.set_location('Entering:'|| v_proc, 10);

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

Line 96: hr_utility.set_location(' Leaving:'|| v_proc, 20);

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

Line 129: hr_utility.set_location('Entering:'|| v_proc, 10);

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

Line 154: hr_utility.set_location(v_proc, 20);

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

Line 171: hr_utility.set_location(v_proc,30);

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

Line 181: hr_utility.set_location(' Leaving:'|| v_proc, 40);

177: ota_aci_bus.g_activity_version_id := p_activity_version_id;
178: ota_aci_bus.g_category_usage_id := p_category_usage_id;
179: ota_aci_bus.g_legislation_code := l_legislation_code;
180: end if;
181: hr_utility.set_location(' Leaving:'|| v_proc, 40);
182: return l_legislation_code;
183: end return_legislation_code;
184: --
185: -- ----------------------------------------------------------------------------

Line 220: hr_utility.set_location('Entering:'||v_proc,10);

216: --
217: v_proc varchar2(72) := g_package || 'chk_ddf';
218: --
219: begin
220: hr_utility.set_location('Entering:'||v_proc,10);
221: --
222: if (
223: --(p_rec.activity_version_id is not null)
224: --(p_rec.category_usage_id is not null) and

Line 324: hr_utility.set_location(' Leaving:'||v_proc,20);

320: ,p_attribute20_value => p_rec.aci_information20
321: );
322: end if;
323: --
324: hr_utility.set_location(' Leaving:'||v_proc,20);
325: end chk_ddf;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |-----------------------< chk_non_updateable_args >------------------------|

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

421: l_course_start_date date;
422: l_course_end_date date;
423:
424: Begin
425: hr_utility.set_location(' Entering:' || l_proc,10);
426: --
427: IF hr_multi_message.no_exclusive_error
428: (p_check_column1 => 'ota_activity_versions.START_DATE'
429: ,p_check_column2 => 'ota_activity_versions.END_DATE'

Line 443: hr_utility.set_location(' Cursors found:' || l_proc,10);

439:
440: IF csr_cat_start_end_date%FOUND AND csr_course_start_end_date%FOUND THEN
441: CLOSE csr_cat_start_end_date;
442: CLOSE csr_course_start_end_date;
443: hr_utility.set_location(' Cursors found:' || l_proc,10);
444: IF (l_cate_type = 'C') THEN
445: --
446: IF ( l_cat_start_date > l_course_start_date
447: or l_cat_end_date < l_course_end_date

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

458: CLOSE csr_course_start_end_date;
459: End IF;
460: End IF;
461: --
462: hr_utility.set_location(' Leaving:' || l_proc,10);
463: Exception
464: when app_exception.application_exception then
465: IF hr_multi_message.exception_add
466: (p_associated_column1 => 'ota_activity_versions.START_DATE'

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

465: IF hr_multi_message.exception_add
466: (p_associated_column1 => 'ota_activity_versions.START_DATE'
467: ,p_associated_column2 => 'ota_activity_versions.END_DATE'
468: ) THEN
469: hr_utility.set_location(' Leaving:'|| l_proc,20);
470: raise;
471: END IF;
472:
473: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

469: hr_utility.set_location(' Leaving:'|| l_proc,20);
470: raise;
471: END IF;
472:
473: hr_utility.set_location(' Leaving:'|| l_proc,30);
474: --
475: End Check_course_category_dates;
476: --
477: -- ----------------------------------------------------------------------------

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

489: --
490: v_proc varchar2(72) := g_package||'check_category';
491: --
492: Begin
493: hr_utility.set_location('Entering:'|| v_proc, 5);
494: --
495: -- ota_general.check_domain_value( 'ACTIVITY_CATEGORY', p_activity_category);
496: --
497: hr_utility.set_location(' Leaving:'|| v_proc, 10);

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

493: hr_utility.set_location('Entering:'|| v_proc, 5);
494: --
495: -- ota_general.check_domain_value( 'ACTIVITY_CATEGORY', p_activity_category);
496: --
497: hr_utility.set_location(' Leaving:'|| v_proc, 10);
498: End check_category;
499: --
500: --
501: -- ----------------------------------------------------------------------------

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

519: where aci.activity_version_id = p_activity_version_id
520: and aci.primary_flag = 'Y';
521: --
522: Begin
523: hr_utility.set_location('Entering:'|| v_proc, 5);
524: --
525: Open sel_multiple_primary;
526: fetch sel_multiple_primary into v_exists;
527: --

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

532: fnd_message.raise_error;
533: end if;
534: close sel_multiple_primary;
535: --
536: hr_utility.set_location(' Leaving:'|| v_proc, 10);
537: End check_multiple_primary_ctgr;
538: --
539: --
540: -- ----------------------------------------------------------------------------

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

561: and aci.category_usage_id = p_category_usage_id
562: and aci.primary_flag = 'Y';
563: --
564: Begin
565: hr_utility.set_location('Entering:'|| v_proc, 5);
566: --
567: Open sel_primary_category;
568: fetch sel_primary_category into v_exists;
569: --

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

574: fnd_message.raise_error;
575: end if;
576: close sel_primary_category;
577: --
578: hr_utility.set_location(' Leaving:'|| v_proc, 10);
579: Exception
580: WHEN app_exception.application_exception THEN
581:
582: IF hr_multi_message.exception_add(

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

583: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.PRIMARY_FLAG')
584:
585: THEN
586:
587: hr_utility.set_location(' Leaving:'||v_proc, 22);
588: RAISE;
589:
590: END IF;
591: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

587: hr_utility.set_location(' Leaving:'||v_proc, 22);
588: RAISE;
589:
590: END IF;
591: hr_utility.set_location(' Leaving:'||v_proc, 25);
592: End check_if_primary_category;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |----------------------------< check_start_end_dates >-----------------|

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

608: v_proc varchar2(72) := g_package||'check_start_end_dates';
609: --
610: Begin
611: --
612: hr_utility.set_location('Entering:'|| v_proc, 5);
613: --
614: ota_general.check_start_end_dates( p_start_date, p_end_date);
615: --
616: hr_utility.set_location(' Leaving:'|| v_proc, 10);

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

612: hr_utility.set_location('Entering:'|| v_proc, 5);
613: --
614: ota_general.check_start_end_dates( p_start_date, p_end_date);
615: --
616: hr_utility.set_location(' Leaving:'|| v_proc, 10);
617:
618: Exception
619: WHEN app_exception.application_exception THEN
620:

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

622: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
623: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
624: THEN
625:
626: hr_utility.set_location(' Leaving:'||v_proc, 22);
627: RAISE;
628:
629: END IF;
630: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

626: hr_utility.set_location(' Leaving:'||v_proc, 22);
627: RAISE;
628:
629: END IF;
630: hr_utility.set_location(' Leaving:'||v_proc, 25);
631: --
632: End check_start_end_dates;
633: --
634: -- ----------------------------------------------------------------------------

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

660: where aci.category_usage_id = p_category_usage_id;
661: --
662: Begin
663: --
664: hr_utility.set_location('Entering:'|| v_proc, 5);
665: --
666: Open sel_check_dates;
667: Fetch sel_check_dates into v_start_date
668: , v_end_date;

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

730: End loop;
731: --
732: Close sel_check_dates;
733: --
734: hr_utility.set_location(' Leaving:'|| v_proc, 10);
735:
736: Exception
737: WHEN app_exception.application_exception THEN
738:

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

740: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
741: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
742: THEN
743:
744: hr_utility.set_location(' Leaving:'||v_proc, 22);
745: RAISE;
746:
747: END IF;
748: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

744: hr_utility.set_location(' Leaving:'||v_proc, 22);
745: RAISE;
746:
747: END IF;
748: hr_utility.set_location(' Leaving:'||v_proc, 25);
749: --
750: End check_dates_update;
751:
752: --

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

780: where tav.activity_version_id = p_activity_version_id;
781: --
782: Begin
783: --
784: hr_utility.set_location('Entering:'|| v_proc, 5);
785: --
786: Open sel_check_dates;
787: Fetch sel_check_dates into v_start_date
788: , v_end_date;

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

850: End loop;
851: --
852: Close sel_check_dates;
853: --
854: hr_utility.set_location(' Leaving:'|| v_proc, 10);
855:
856: Exception
857: WHEN app_exception.application_exception THEN
858:

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

860: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
861: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
862: THEN
863:
864: hr_utility.set_location(' Leaving:'||v_proc, 22);
865: RAISE;
866:
867: END IF;
868: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

864: hr_utility.set_location(' Leaving:'||v_proc, 22);
865: RAISE;
866:
867: END IF;
868: hr_utility.set_location(' Leaving:'||v_proc, 25);
869: --
870: End check_dates_update_act;
871:
872:

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

894: where aci.activity_version_id = p_activity_version_id
895: and aci.category_usage_id = p_category_usage_id;
896: --
897: Begin
898: hr_utility.set_location('Entering:'|| v_proc, 5);
899: --
900: Open sel_unique_key;
901: fetch sel_unique_key into v_exists;
902: --

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

907: fnd_message.raise_error;
908: end if;
909: close sel_unique_key;
910: --
911: hr_utility.set_location(' Leaving:'|| v_proc, 10);
912: Exception
913: WHEN app_exception.application_exception THEN
914:
915: IF hr_multi_message.exception_add(

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

915: IF hr_multi_message.exception_add(
916: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.ACTIVITY_VERSION_ID',
917: p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
918: THEN
919: hr_utility.set_location(' Leaving:'||v_proc, 22);
920: RAISE;
921:
922: END IF;
923: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

919: hr_utility.set_location(' Leaving:'||v_proc, 22);
920: RAISE;
921:
922: END IF;
923: hr_utility.set_location(' Leaving:'||v_proc, 25);
924: End check_unique_key;
925: --
926: -- ----------------------------------------------------------------------------
927: -- |---------------------------< insert_validate >----------------------------|

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

935: --
936: v_proc varchar2(72) := g_package||'insert_validate';
937: --
938: Begin
939: hr_utility.set_location('Entering:'||v_proc, 5);
940: --
941: ota_ctu_bus.set_security_group_id(p_category_usage_id);
942: --
943: -- Call all supporting business operations

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

969: , p_rec.end_date_active);
970: --
971: ota_aci_bus.chk_ddf(p_rec);
972: --
973: hr_utility.set_location(' Leaving:'||v_proc, 10);
974: End insert_validate;
975: --
976: -- ----------------------------------------------------------------------------
977: -- |---------------------------< update_validate >----------------------------|

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

995: , p_rec.primary_flag );
996: --
997: --
998: Begin
999: hr_utility.set_location('Entering:'||v_proc, 5);
1000: --
1001: -- Call all supporting business operations
1002: --
1003: --

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

1055: --
1056: ota_aci_bus.chk_ddf(p_rec);
1057: end if;
1058: --
1059: hr_utility.set_location(' Leaving:'||v_proc, 10);
1060: End update_validate;
1061: --
1062: -- ----------------------------------------------------------------------------
1063: -- |---------------------------< delete_validate >----------------------------|

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

1068: --
1069: v_proc varchar2(72) := g_package||'delete_validate';
1070: --
1071: Begin
1072: hr_utility.set_location('Entering:'||v_proc, 5);
1073: --
1074: check_if_primary_category( p_rec.activity_version_id
1075: ,p_rec.category_usage_id);
1076: --

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

1073: --
1074: check_if_primary_category( p_rec.activity_version_id
1075: ,p_rec.category_usage_id);
1076: --
1077: hr_utility.set_location(' Leaving:'||v_proc, 10);
1078: End delete_validate;
1079: --
1080: end ota_aci_bus;
1081: