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 60: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

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

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

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

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

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

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

284: l_object_version_number number := p_object_version_number;
285: l_effective_date date;
286:
287: begin
288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: -- Issue a savepoint
291: --
292: savepoint UPDATE_cert_enrollment;

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

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

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

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

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

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

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

484: l_proc varchar2(72) := g_package||'DELETE_cert_enrollment';
485: --
486: --
487: begin
488: hr_utility.set_location('Entering:'|| l_proc, 10);
489: --
490: -- Issue a savepoint
491: --
492: savepoint DELETE_cert_enrollment;

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

541: --
542: -- Set all output arguments
543: --
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 170);
546: exception
547: when hr_api.validate_enabled then
548: --
549: -- As the Validate_Enabled exception has been raised

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

554: -- Only set output warning arguments
555: -- (Any key or derived arguments must be set to null
556: -- when validation only mode is being used.)
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 180);
559: when others then
560: --
561: -- A validation or unexpected error has occured
562: --

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

560: --
561: -- A validation or unexpected error has occured
562: --
563: rollback to DELETE_cert_enrollment;
564: hr_utility.set_location(' Leaving:'||l_proc, 190);
565: raise;
566: end delete_cert_enrollment;
567:
568: -- ----------------------------------------------------------------------------

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

701: l_o_cert_enroll_id number;
702: l_o_cert_enroll_status varchar2(100);
703:
704: BEGIN
705: hr_utility.set_location('Entering:'|| l_proc, 10);
706:
707: OPEN csr_cert_info;
708: FETCH csr_cert_info INTO l_cert_rec;
709: CLOSE csr_cert_info;

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

717: else
718: l_certification_status_code := 'AWAITING_APPROVAL';
719: end if;
720:
721: hr_utility.set_location(' Step:'|| l_proc, 20);
722:
723: --check for initial subscription or resubscription to unsubscribed cert
724: --re-cert is applicable if approvals is off and certification_status_code in 'CANCELLED'
725: --or if approvals on and certification_status_code in 'AWAITING_APPROVAL' but has atleast one period.

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

732: l_o_cert_enroll_id := l_recert_rec.cert_enrollment_id;
733: l_o_cert_enroll_status :=l_recert_rec.certification_status_code;
734:
735:
736: hr_utility.set_location(' Step:'|| l_proc, 30);
737:
738: --check for approvals re-cert
739: if (l_recert_rec.certification_status_code = 'AWAITING_APPROVAL') then
740: open csr_cpe_exist(l_recert_rec.cert_enrollment_id);

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

752: end if;
753:
754: l_cert_enrollment_id := l_recert_rec.cert_enrollment_id;
755:
756: hr_utility.set_location(' Step:'|| l_proc, 40);
757:
758: --calculate exp and earliest enrol dates
759: --for onetime certs there's no expiration
760: --for renewable certs calc based on initial_completion_date, INITIAL_COMPLETION_DURATION,

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

763: if (l_cert_rec.renewable_flag = 'Y') then
764: ota_cpe_util.calc_cre_dates(null, l_cert_rec.certification_id, 'I', l_earliest_enroll_date, l_expiration_date, p_enrollment_date);
765: end if; --end renewal flag
766:
767: hr_utility.set_location(' Step:'|| l_proc, 50);
768:
769: --create or update CRE based on recert flag
770: if (l_is_recert = 'N') then
771: -- initial subscription

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

772: --create cert enrollment only when the approval is off or enrl is sent for approval
773:
774: if (p_approval_flag = 'N' or p_approval_flag = 'A') then
775:
776: hr_utility.set_location(' Step:'|| l_proc, 60);
777: ota_utility.Get_Default_Value_Dff(
778: appl_short_name => 'OTA'
779: ,flex_field_name => 'OTA_CERT_ENROLLMENTS'
780: ,p_attribute_category => l_attribute_category

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

837: ,p_object_version_number => l_object_version_number1
838: );
839: end if; --end create CRE
840:
841: hr_utility.set_location(' Step:'|| l_proc, 70);
842:
843: if (p_approval_flag = 'N' or p_approval_flag = 'S') then
844:
845: --update cre status on approval confirmed

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

847: OPEN csr_cert_enrl(l_cert_enrollment_id);
848: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
849: CLOSE csr_cert_enrl;
850:
851: hr_utility.set_location(' Step:'|| l_proc, 75);
852:
853: ota_cert_enrollment_api.update_cert_enrollment
854: (p_effective_date => sysdate
855: ,p_cert_enrollment_id => l_cert_enrollment_id

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

866: p_cert_prd_enrollment_id => l_cert_prd_enrollment_id,
867: p_certification_status_code => l_certification_status_code);
868: end if;--create CPE CMEs
869:
870: hr_utility.set_location(' Step:'|| l_proc, 80);
871:
872: else -- start of recert
873: -- resubscription to unsubscribed cert
874: -- set the status and flip the unenrollment date to null

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

872: else -- start of recert
873: -- resubscription to unsubscribed cert
874: -- set the status and flip the unenrollment date to null
875:
876: hr_utility.set_location(' Step:'|| l_proc, 90);
877:
878: --update cert enrollment
879: OPEN csr_cert_enrl(l_recert_rec.cert_enrollment_id);
880: FETCH csr_cert_enrl INTO l_cert_enrl_rec;

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

879: OPEN csr_cert_enrl(l_recert_rec.cert_enrollment_id);
880: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
881: CLOSE csr_cert_enrl;
882:
883: hr_utility.set_location(' Step:'|| l_proc, 100);
884:
885: ota_cert_enrollment_api.update_cert_enrollment
886: (p_effective_date => sysdate
887: ,p_cert_enrollment_id => l_cert_enrollment_id

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

922: l_cert_prd_enrollment_id := l_prd_enrl_rec.cert_prd_enrollment_id;
923: end if;
924: CLOSE csr_prd_enrl;
925:
926: hr_utility.set_location(' Step:'|| l_proc, 110);
927:
928: if (l_cert_prd_enrollment_id is not null) then
929: --Bug 4565761
930: ota_cme_util.refresh_cme(l_cert_prd_enrollment_id);

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

932: --calculate period and mbr enroll status for existing data and update accordingly
933: ota_cpe_util.update_cpe_status(l_cert_prd_enrollment_id,
934: p_certification_status_code => l_certification_status_code);
935:
936: hr_utility.set_location(' Step:'|| l_proc, 120);
937:
938: else
939: --create prd and mbr enrols
940:

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

946: OPEN csr_cert_enrl(l_recert_rec.cert_enrollment_id);
947: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
948: CLOSE csr_cert_enrl;
949:
950: hr_utility.set_location(' Step:'|| l_proc, 130);
951:
952: ota_cert_enrollment_api.update_cert_enrollment
953: (p_effective_date => sysdate
954: ,p_cert_enrollment_id => l_cert_enrollment_id

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

958: ,p_is_history_flag => p_is_history_flag
959: ,p_earliest_enroll_date => l_earliest_enroll_date
960: );
961:
962: hr_utility.set_location(' Step:'|| l_proc, 140);
963:
964: --call create CPE and CME util proc
965: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => l_cert_enrollment_id,
966: p_expiration_date => l_expiration_date,

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

970: end if;
971: end if; --for approval N or S
972: end if; --end recert
973:
974: hr_utility.set_location(' Step:'|| l_proc, 150);
975:
976: --set output param
977: p_cert_enrollment_id := l_cert_enrollment_id;
978: p_certification_status_code := l_certification_status_code;

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

1011: -- Reset IN OUT parameters and set OUT parameters
1012: --
1013: p_cert_enrollment_id := null;
1014: p_certification_status_code := null;
1015: hr_utility.set_location(' Leaving:' || l_proc, 160);
1016:
1017: when others then
1018: --
1019: -- A validation or unexpected error has occured

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

1024: --
1025: p_cert_enrollment_id := null;
1026: p_certification_status_code := null;
1027:
1028: hr_utility.set_location(' Leaving:' || l_proc,170);
1029: raise;
1030: END subscribe_to_certification;
1031: --
1032: end OTA_CERT_ENROLLMENT_api;