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

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

45: l_legislation_code varchar2(150);
46: --
47: begin
48: --
49: hr_utility.set_location('Entering:'|| l_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:'|| l_proc, 20);

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

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

125: l_proc varchar2(72) := g_package||'return_legislation_code';
126: --
127: Begin
128: --
129: hr_utility.set_location('Entering:'|| l_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(l_proc, 20);

150: -- call to this function. Just return the value in the global
151: -- variable.
152: --
153: l_legislation_code := ota_cci_bus.g_legislation_code;
154: hr_utility.set_location(l_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(l_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(l_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:'|| l_proc, 40);

177: ota_cci_bus.g_category_usage_id := p_category_usage_id;
178: ota_cci_bus.g_certification_id := p_certification_id;
179: ota_cci_bus.g_legislation_code := l_legislation_code;
180: end if;
181: hr_utility.set_location(' Leaving:'|| l_proc, 40);
182: return l_legislation_code;
183: end return_legislation_code;
184: --
185: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

476: --
477: l_proc varchar2(72) := g_package||'insert_validate';
478: --
479: Begin
480: hr_utility.set_location('Entering:'||l_proc, 5);
481: --
482: -- Call all supporting business operations
483: --
484: ota_ctu_bus.set_security_group_id(p_category_usage_id => p_category_usage_id);

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

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

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

523: l_end_date ota_cert_cat_inclusions.end_date_active%TYPE;
524: --
525: --
526: Begin
527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: -- Call all supporting business operations
530: --
531: --

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

566: END IF;
567: --
568: ota_cci_bus.chk_df(p_rec);
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 10);
571: End update_validate;
572: --
573: -- ----------------------------------------------------------------------------
574: -- |---------------------------< delete_validate >----------------------------|

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

579: --
580: l_proc varchar2(72) := g_package||'delete_validate';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call all supporting business operations
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call all supporting business operations
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 10);
588: End delete_validate;
589: --
590: --
591: -- ----------------------------------------------------------------------------

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

609: where cci.certification_id = p_certification_id
610: and cci.primary_flag = 'Y';
611: --
612: Begin
613: hr_utility.set_location('Entering:'|| v_proc, 5);
614: --
615: Open sel_multiple_primary;
616: fetch sel_multiple_primary into v_exists;
617: --

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

622: fnd_message.raise_error;
623: end if;
624: close sel_multiple_primary;
625: --
626: hr_utility.set_location(' Leaving:'|| v_proc, 10);
627:
628: Exception
629: WHEN app_exception.application_exception THEN
630:

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

632: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')
633:
634: THEN
635:
636: hr_utility.set_location(' Leaving:'||v_proc, 22);
637: RAISE;
638:
639: END IF;
640: End check_multiple_primary_ctgr;

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

663: and cci.category_usage_id = p_category_usage_id
664: and cci.primary_flag = 'Y';
665: --
666: Begin
667: hr_utility.set_location('Entering:'|| v_proc, 5);
668: --
669: Open sel_primary_category;
670: fetch sel_primary_category into v_exists;
671: --

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

676: fnd_message.raise_error;
677: end if;
678: close sel_primary_category;
679: --
680: hr_utility.set_location(' Leaving:'|| v_proc, 10);
681: Exception
682: WHEN app_exception.application_exception THEN
683:
684: IF hr_multi_message.exception_add(

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

685: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')
686:
687: THEN
688:
689: hr_utility.set_location(' Leaving:'||v_proc, 22);
690: RAISE;
691:
692: END IF;
693: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

689: hr_utility.set_location(' Leaving:'||v_proc, 22);
690: RAISE;
691:
692: END IF;
693: hr_utility.set_location(' Leaving:'||v_proc, 25);
694: End check_if_primary_category;
695:
696: --
697: -- ----------------------------------------------------------------------------

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

711: v_proc varchar2(72) := g_package||'check_start_end_dates';
712: --
713: Begin
714: --
715: hr_utility.set_location('Entering:'|| v_proc, 5);
716: --
717: ota_general.check_start_end_dates( p_start_date, p_end_date);
718: --
719: hr_utility.set_location(' Leaving:'|| v_proc, 10);

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

715: hr_utility.set_location('Entering:'|| v_proc, 5);
716: --
717: ota_general.check_start_end_dates( p_start_date, p_end_date);
718: --
719: hr_utility.set_location(' Leaving:'|| v_proc, 10);
720:
721: Exception
722: WHEN app_exception.application_exception THEN
723:

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

725: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
726: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')
727: THEN
728:
729: hr_utility.set_location(' Leaving:'||v_proc, 22);
730: RAISE;
731:
732: END IF;
733: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

729: hr_utility.set_location(' Leaving:'||v_proc, 22);
730: RAISE;
731:
732: END IF;
733: hr_utility.set_location(' Leaving:'||v_proc, 25);
734: --
735: End check_start_end_dates;
736:
737: --

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

760: where cci.certification_id = p_certification_id
761: and cci.category_usage_id = p_category_usage_id;
762: --
763: Begin
764: hr_utility.set_location('Entering:'|| v_proc, 5);
765: --
766: Open sel_unique_key;
767: fetch sel_unique_key into v_exists;
768: --

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

773: fnd_message.raise_error;
774: end if;
775: close sel_unique_key;
776: --
777: hr_utility.set_location(' Leaving:'|| v_proc, 10);
778: Exception
779: WHEN app_exception.application_exception THEN
780:
781: IF hr_multi_message.exception_add(

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

781: IF hr_multi_message.exception_add(
782: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.certification_id',
783: p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
784: THEN
785: hr_utility.set_location(' Leaving:'||v_proc, 22);
786: RAISE;
787:
788: END IF;
789: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

785: hr_utility.set_location(' Leaving:'||v_proc, 22);
786: RAISE;
787:
788: END IF;
789: hr_utility.set_location(' Leaving:'||v_proc, 25);
790: End check_unique_key;
791: --
792:
793: --

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

820: where ctu.category_usage_id = p_category_usage_id;
821: --
822: Begin
823: --
824: hr_utility.set_location('Entering:'|| v_proc, 5);
825: --
826: Open sel_check_dates;
827: Fetch sel_check_dates into v_start_date, v_end_date;
828: IF sel_check_dates%FOUND THEN

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

830: END IF;
831: --
832: Close sel_check_dates;
833: --
834: hr_utility.set_location(' Leaving:'|| v_proc, 10);
835:
836: Exception
837: WHEN app_exception.application_exception THEN
838:

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

840: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
841: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')
842: THEN
843:
844: hr_utility.set_location(' Leaving:'||v_proc, 22);
845: RAISE;
846:
847: END IF;
848: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

844: hr_utility.set_location(' Leaving:'||v_proc, 22);
845: RAISE;
846:
847: END IF;
848: hr_utility.set_location(' Leaving:'||v_proc, 25);
849: --
850: End check_category_dates;
851: --
852: --