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

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

57: l_object_version_number number;
58: l_effective_date date;
59:
60: begin
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Issue a savepoint
64: --
65: savepoint CREATE_cert_enrollment;

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

212: if p_validate then
213: raise hr_api.validate_enabled;
214: end if;
215:
216: hr_utility.set_location(' Leaving:'||l_proc, 70);
217: exception
218: when hr_api.validate_enabled then
219: --
220: -- As the Validate_Enabled exception has been raised

Line 231: hr_utility.set_location(' Leaving:'||l_proc, 80);

227: -- when validation only mode is being used.)
228: --
229: p_cert_enrollment_id := null;
230: p_object_version_number := null;
231: hr_utility.set_location(' Leaving:'||l_proc, 80);
232: when others then
233: --
234: -- A validation or unexpected error has occured
235: --

Line 239: hr_utility.set_location(' Leaving:'||l_proc, 90);

235: --
236: rollback to CREATE_cert_enrollment;
237: p_cert_enrollment_id := null;
238: p_object_version_number := null;
239: hr_utility.set_location(' Leaving:'||l_proc, 90);
240: raise;
241: end create_cert_enrollment;
242: -- ----------------------------------------------------------------------------
243: -- |-------------------------< UPDATE_cert_enrollment >-------------------------|

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

288: l_object_version_number number := p_object_version_number;
289: l_effective_date date;
290:
291: begin
292: hr_utility.set_location('Entering:'|| l_proc, 10);
293: --
294: -- Issue a savepoint
295: --
296: savepoint UPDATE_cert_enrollment;

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

446: -- Set all output arguments
447: --
448: p_object_version_number := l_object_version_number;
449:
450: hr_utility.set_location(' Leaving:'||l_proc, 70);
451: exception
452: when hr_api.validate_enabled then
453: --
454: -- As the Validate_Enabled exception has been raised

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

460: -- (Any key or derived arguments must be set to null
461: -- when validation only mode is being used.)
462: --
463: p_object_version_number := null;
464: hr_utility.set_location(' Leaving:'||l_proc, 80);
465: when others then
466: --
467: -- A validation or unexpected error has occured
468: --

Line 471: hr_utility.set_location(' Leaving:'||l_proc, 90);

467: -- A validation or unexpected error has occured
468: --
469: rollback to UPDATE_cert_enrollment;
470: p_object_version_number := l_object_version_number;
471: hr_utility.set_location(' Leaving:'||l_proc, 90);
472: raise;
473: end update_cert_enrollment;
474: --
475: -- ----------------------------------------------------------------------------

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

496: l_person_id number := -1;
497: --
498: --
499: begin
500: hr_utility.set_location('Entering:'|| l_proc, 10);
501:
502: OPEN get_person_info;
503: FETCH get_person_info INTO l_person_id;
504: CLOSE get_person_info;

Line 563: hr_utility.set_location(' Leaving:'||l_proc, 170);

559: --
560: -- Set all output arguments
561: --
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 170);
564: exception
565: when hr_api.validate_enabled then
566: --
567: -- As the Validate_Enabled exception has been raised

Line 576: hr_utility.set_location(' Leaving:'||l_proc, 180);

572: -- Only set output warning arguments
573: -- (Any key or derived arguments must be set to null
574: -- when validation only mode is being used.)
575: --
576: hr_utility.set_location(' Leaving:'||l_proc, 180);
577: when others then
578: --
579: -- A validation or unexpected error has occured
580: --

Line 582: hr_utility.set_location(' Leaving:'||l_proc, 190);

578: --
579: -- A validation or unexpected error has occured
580: --
581: rollback to DELETE_cert_enrollment;
582: hr_utility.set_location(' Leaving:'||l_proc, 190);
583: raise;
584: end delete_cert_enrollment;
585:
586: -- ----------------------------------------------------------------------------

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

721: l_o_cert_enroll_id number;
722: l_o_cert_enroll_status varchar2(100);
723:
724: BEGIN
725: hr_utility.set_location('Entering:'|| l_proc, 10);
726:
727: OPEN csr_cert_info;
728: FETCH csr_cert_info INTO l_cert_rec;
729: CLOSE csr_cert_info;

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

737: else
738: l_certification_status_code := 'AWAITING_APPROVAL';
739: end if;
740:
741: hr_utility.set_location(' Step:'|| l_proc, 20);
742:
743: --check for initial subscription or resubscription to unsubscribed cert
744: --re-cert is applicable if approvals is off and certification_status_code in 'CANCELLED'
745: --or if approvals on and certification_status_code in 'AWAITING_APPROVAL' but has atleast one period.

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

752: l_o_cert_enroll_id := l_recert_rec.cert_enrollment_id;
753: l_o_cert_enroll_status :=l_recert_rec.certification_status_code;
754:
755:
756: hr_utility.set_location(' Step:'|| l_proc, 30);
757:
758: --check for approvals re-cert
759: if (l_recert_rec.certification_status_code = 'AWAITING_APPROVAL') then
760: open csr_cpe_exist(l_recert_rec.cert_enrollment_id);

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

772: end if;
773:
774: l_cert_enrollment_id := l_recert_rec.cert_enrollment_id;
775:
776: hr_utility.set_location(' Step:'|| l_proc, 40);
777:
778: --calculate exp and earliest enrol dates
779: --for onetime certs there's no expiration
780: --for renewable certs calc based on initial_completion_date, INITIAL_COMPLETION_DURATION,

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

783: if (l_cert_rec.renewable_flag = 'Y') then
784: ota_cpe_util.calc_cre_dates(null, l_cert_rec.certification_id, 'I', l_earliest_enroll_date, l_expiration_date, p_enrollment_date);
785: end if; --end renewal flag
786:
787: hr_utility.set_location(' Step:'|| l_proc, 50);
788:
789: --create or update CRE based on recert flag
790: if (l_is_recert = 'N') then
791: -- initial subscription

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

792: --create cert enrollment only when the approval is off or enrl is sent for approval
793:
794: if (p_approval_flag = 'N' or p_approval_flag = 'A') then
795:
796: hr_utility.set_location(' Step:'|| l_proc, 60);
797: ota_utility.Get_Default_Value_Dff(
798: appl_short_name => 'OTA'
799: ,flex_field_name => 'OTA_CERT_ENROLLMENTS'
800: ,p_attribute_category => l_attribute_category

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

858: ,p_is_automatic_subscription => p_is_automatic_subscription
859: );
860: end if; --end create CRE
861:
862: hr_utility.set_location(' Step:'|| l_proc, 70);
863:
864: if (p_approval_flag = 'N' or p_approval_flag = 'S') then
865:
866: --update cre status on approval confirmed

Line 872: hr_utility.set_location(' Step:'|| l_proc, 75);

868: OPEN csr_cert_enrl(l_cert_enrollment_id);
869: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
870: CLOSE csr_cert_enrl;
871:
872: hr_utility.set_location(' Step:'|| l_proc, 75);
873:
874: ota_cert_enrollment_api.update_cert_enrollment
875: (p_effective_date => sysdate
876: ,p_cert_enrollment_id => l_cert_enrollment_id

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

888: p_certification_status_code => l_certification_status_code,
889: p_is_recert => l_is_recert);
890: end if;--create CPE CMEs
891:
892: hr_utility.set_location(' Step:'|| l_proc, 80);
893:
894: else -- start of recert
895: -- resubscription to unsubscribed cert
896: -- set the status and flip the unenrollment date to null

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

894: else -- start of recert
895: -- resubscription to unsubscribed cert
896: -- set the status and flip the unenrollment date to null
897:
898: hr_utility.set_location(' Step:'|| l_proc, 90);
899:
900: --update cert enrollment
901: OPEN csr_cert_enrl(l_recert_rec.cert_enrollment_id);
902: FETCH csr_cert_enrl INTO l_cert_enrl_rec;

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

901: OPEN csr_cert_enrl(l_recert_rec.cert_enrollment_id);
902: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
903: CLOSE csr_cert_enrl;
904:
905: hr_utility.set_location(' Step:'|| l_proc, 100);
906:
907: ota_cert_enrollment_api.update_cert_enrollment
908: (p_effective_date => sysdate
909: ,p_cert_enrollment_id => l_cert_enrollment_id

Line 948: hr_utility.set_location(' Step:'|| l_proc, 110);

944: l_cert_prd_enrollment_id := l_prd_enrl_rec.cert_prd_enrollment_id;
945: end if;
946: CLOSE csr_prd_enrl;
947:
948: hr_utility.set_location(' Step:'|| l_proc, 110);
949:
950: if (l_cert_prd_enrollment_id is not null) then
951: --Bug 4565761
952: ota_cme_util.refresh_cme(l_cert_prd_enrollment_id);

Line 958: hr_utility.set_location(' Step:'|| l_proc, 120);

954: --calculate period and mbr enroll status for existing data and update accordingly
955: ota_cpe_util.update_cpe_status(l_cert_prd_enrollment_id,
956: p_certification_status_code => l_certification_status_code);
957:
958: hr_utility.set_location(' Step:'|| l_proc, 120);
959:
960: else
961: --create prd and mbr enrols
962:

Line 972: hr_utility.set_location(' Step:'|| l_proc, 130);

968: OPEN csr_cert_enrl(l_recert_rec.cert_enrollment_id);
969: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
970: CLOSE csr_cert_enrl;
971:
972: hr_utility.set_location(' Step:'|| l_proc, 130);
973:
974: ota_cert_enrollment_api.update_cert_enrollment
975: (p_effective_date => sysdate
976: ,p_cert_enrollment_id => l_cert_enrollment_id

Line 984: hr_utility.set_location(' Step:'|| l_proc, 140);

980: ,p_is_history_flag => p_is_history_flag
981: ,p_earliest_enroll_date => l_earliest_enroll_date
982: );
983:
984: hr_utility.set_location(' Step:'|| l_proc, 140);
985:
986: --call create CPE and CME util proc
987: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => l_cert_enrollment_id,
988: p_expiration_date => l_expiration_date,

Line 997: hr_utility.set_location(' Step:'|| l_proc, 150);

993: end if;
994: end if; --for approval N or S
995: end if; --end recert
996:
997: hr_utility.set_location(' Step:'|| l_proc, 150);
998:
999: --set output param
1000: p_cert_enrollment_id := l_cert_enrollment_id;
1001: p_certification_status_code := l_certification_status_code;

Line 1038: hr_utility.set_location(' Leaving:' || l_proc, 160);

1034: -- Reset IN OUT parameters and set OUT parameters
1035: --
1036: p_cert_enrollment_id := null;
1037: p_certification_status_code := null;
1038: hr_utility.set_location(' Leaving:' || l_proc, 160);
1039:
1040: when others then
1041: --
1042: -- A validation or unexpected error has occured

Line 1051: hr_utility.set_location(' Leaving:' || l_proc,170);

1047: --
1048: p_cert_enrollment_id := null;
1049: p_certification_status_code := null;
1050:
1051: hr_utility.set_location(' Leaving:' || l_proc,170);
1052: raise;
1053: END subscribe_to_certification;
1054: --
1055: end OTA_CERT_ENROLLMENT_api;