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

Line 72: hr_utility.set_location(' Step:'|| l_proc, 10);

68: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
69:
70: BEGIN
71:
72: hr_utility.set_location(' Step:'|| l_proc, 10);
73:
74: OPEN csr_cert_enrl;
75: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
76: CLOSE csr_cert_enrl;

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

89:
90: p_booking_status_type := l_enroll_status;
91: p_date_status_changed := l_date_status_changed;
92:
93: hr_utility.set_location(' Step:'|| l_proc, 20);
94: --
95: EXCEPTION
96: WHEN others THEN
97: hr_utility.set_location('Leaving :'||l_proc,30);

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

93: hr_utility.set_location(' Step:'|| l_proc, 20);
94: --
95: EXCEPTION
96: WHEN others THEN
97: hr_utility.set_location('Leaving :'||l_proc,30);
98: p_booking_status_type := null;
99: p_date_status_changed := null;
100:
101: END get_enrl_status_on_update;

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

126: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
127:
128: BEGIN
129:
130: hr_utility.set_location(' Step:'|| l_proc, 10);
131:
132: OPEN csr_cert_enrl;
133: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
134: CLOSE csr_cert_enrl;

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

149: p_booking_status_type := l_enroll_status;
150: p_date_status_changed := l_date_status_changed;
151: p_successful_attendance_flag := l_successful_attendance_flag;
152:
153: hr_utility.set_location(' Step:'|| l_proc, 20);
154: --
155: EXCEPTION
156: WHEN others THEN
157: hr_utility.set_location('Leaving :'||l_proc,30);

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

153: hr_utility.set_location(' Step:'|| l_proc, 20);
154: --
155: EXCEPTION
156: WHEN others THEN
157: hr_utility.set_location('Leaving :'||l_proc,30);
158: p_booking_status_type := null;
159: p_date_status_changed := null;
160: p_successful_attendance_flag := null;
161:

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

203: l_cert_prd_count number := 0; --Bug 15938221
204:
205: BEGIN
206:
207: hr_utility.set_location('Entering:'|| l_proc, 10);
208:
209: OPEN csr_cert_enrl;
210: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
211: CLOSE csr_cert_enrl;

Line 213: hr_utility.set_location('Entering:'|| l_proc, 20);

209: OPEN csr_cert_enrl;
210: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
211: CLOSE csr_cert_enrl;
212:
213: hr_utility.set_location('Entering:'|| l_proc, 20);
214:
215: FOR rec_enr IN get_enrl_status(p_activity_version_id,
216: l_cert_period_start_date,
217: l_cert_period_end_date,

Line 231: hr_utility.set_location('Entering:'|| l_proc, 30);

227: l_sign_eval_status := rec_enr.sign_eval_status; --10164130
228: EXIT;
229: END LOOP;
230:
231: hr_utility.set_location('Entering:'|| l_proc, 30);
232:
233: if p_mode = 'C' then
234:
235: --Bug 15938221

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

287: p_completion_date := null;
288: END IF;
289: end if;
290:
291: hr_utility.set_location('Step:'|| l_proc, 40);
292:
293: EXCEPTION
294: WHEN others THEN
295: hr_utility.set_location('LEAVING:'|| l_proc, 50);

Line 295: hr_utility.set_location('LEAVING:'|| l_proc, 50);

291: hr_utility.set_location('Step:'|| l_proc, 40);
292:
293: EXCEPTION
294: WHEN others THEN
295: hr_utility.set_location('LEAVING:'|| l_proc, 50);
296: p_member_status_code := 'PLANNED';
297: p_completion_date := null;
298: RAISE;
299:

Line 364: hr_utility.set_location(' Step:'||l_proc,10);

360: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
361:
362: BEGIN
363:
364: hr_utility.set_location(' Step:'||l_proc,10);
365:
366: OPEN evt_det;
367: FETCH evt_det
368: INTO l_activity_version_id, l_online_flag;

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

367: FETCH evt_det
368: INTO l_activity_version_id, l_online_flag;
369: CLOSE evt_det;
370:
371: hr_utility.set_location(' Step:'|| l_proc, 20);
372:
373:
374: FOR rec_cme_info IN csr_cme_info(l_activity_version_id)
375:

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

434:
435: END LOOP;
436:
437: p_cert_prd_enrollment_ids := l_cert_prd_enrollment_ids;
438: hr_utility.set_location(' Step:'||l_proc,30);
439:
440: EXCEPTION
441: WHEN others THEN
442: hr_utility.set_location('Leaving :'||l_proc,40);

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

438: hr_utility.set_location(' Step:'||l_proc,30);
439:
440: EXCEPTION
441: WHEN others THEN
442: hr_utility.set_location('Leaving :'||l_proc,40);
443: p_cert_prd_enrollment_ids := null;
444: --MULTI MESSAGE SUPPORT
445:
446: END update_cme_status;

Line 509: hr_utility.set_location(' Step:'|| l_proc, 10);

505: l_proc VARCHAR2(72) := g_package|| 'Update_cpe_status';
506:
507: l_child_update_flag varchar2(1) := 'N';
508: BEGIN
509: hr_utility.set_location(' Step:'|| l_proc, 10);
510:
511: FOR rec_cpe_cme in csr_cpe_cme LOOP
512: l_period_status_code := rec_cpe_cme.period_status_code;
513: --update cpe rec

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

523: END IF;
524:
525: END LOOP;
526:
527: hr_utility.set_location(' Step:'|| l_proc, 20);
528: EXCEPTION
529: WHEN others THEN
530: hr_utility.set_location('Leaving :'||l_proc,30);
531: p_cert_prd_enrollment_id := null;

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

526:
527: hr_utility.set_location(' Step:'|| l_proc, 20);
528: EXCEPTION
529: WHEN others THEN
530: hr_utility.set_location('Leaving :'||l_proc,30);
531: p_cert_prd_enrollment_id := null;
532: --MULTI MESSAGE SUPPORT
533:
534: END Update_cpe_status;

Line 574: hr_utility.set_location(' Step:'||l_proc,10);

570: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
571:
572: BEGIN
573:
574: hr_utility.set_location(' Step:'||l_proc,10);
575:
576: open csr_cme_info;
577: fetch csr_cme_info into rec_cme_info;
578: close csr_cme_info;

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

613: ,p_member_status_code => l_member_status_code
614: ,p_completion_date => l_completion_date);
615: END IF;
616:
617: hr_utility.set_location(' Step:'||l_proc,30);
618:
619: EXCEPTION
620: WHEN others THEN
621: hr_utility.set_location('Leaving :'||l_proc,40);

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

617: hr_utility.set_location(' Step:'||l_proc,30);
618:
619: EXCEPTION
620: WHEN others THEN
621: hr_utility.set_location('Leaving :'||l_proc,40);
622: --MULTI MESSAGE SUPPORT
623:
624: END update_cme_status;
625:

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

642: where cme.cert_member_id = p_cmb_id;
643: --
644: Begin
645: --
646: hr_utility.set_location('Entering:'|| v_proc, 5);
647: --
648:
649: p_return_status := 'S';
650:

Line 666: hr_utility.set_location(' Step:'|| v_proc, 30);

662:
663: end if;
664: --
665:
666: hr_utility.set_location(' Step:'|| v_proc, 30);
667:
668: END chk_if_cme_exists;
669:
670: -- ----------------------------------------------------------------------------

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

781: l_cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
782: l_object_version_number ota_cert_mbr_enrollments.object_version_number%type;
783:
784: Begin
785: hr_utility.set_location(' Entering:'||l_proc,10);
786:
787: open csr_cpe;
788: fetch csr_cpe into rec_cpe;
789: close csr_cpe;

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

792: for new_crs in csr_new_crs(rec_cpe.certification_id)
793: loop
794: --create cme record
795:
796: hr_utility.set_location(' Step:'||l_proc,20);
797:
798: ota_utility.Get_Default_Value_Dff(
799: appl_short_name => 'OTA'
800: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'

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

819: ,p_attribute18 => l_attribute18
820: ,p_attribute19 => l_attribute19
821: ,p_attribute20 => l_attribute20);
822:
823: hr_utility.set_location(' Step:'||l_proc,30);
824:
825: ota_cert_mbr_enrollment_api.create_cert_mbr_enrollment(
826: p_effective_date => trunc(sysdate)
827: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id

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

855: );
856:
857: end loop;
858:
859: hr_utility.set_location(' Step:'||l_proc,40);
860:
861: --update cme_record to CANCELLED status for activities which are ended during re-cert
862: for end_crs in csr_end_crs
863: loop

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

870: ,p_cert_mbr_enrollment_id => end_crs.cert_mbr_enrollment_id
871: ,p_member_status_code => 'CANCELLED');
872: end loop;
873:
874: hr_utility.set_location(' Step:'||l_proc,50);
875:
876: EXCEPTION
877: WHEN others THEN
878: hr_utility.set_location('Leaving :'||l_proc,60);

Line 878: hr_utility.set_location('Leaving :'||l_proc,60);

874: hr_utility.set_location(' Step:'||l_proc,50);
875:
876: EXCEPTION
877: WHEN others THEN
878: hr_utility.set_location('Leaving :'||l_proc,60);
879: END refresh_cme;
880:
881: Function chk_active_cme_enrl(p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
882: return varchar2

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

925: l_return_flag varchar2(1) := 'F';
926:
927: begin
928:
929: hr_utility.set_location(' Entering:' || l_proc,10);
930:
931: FOR rec IN csr_active_enrl
932: LOOP
933: l_enrollment_Status_Type := rec.enrollment_Status_Type;

Line 941: hr_utility.set_location('Leaving :'||l_proc,15);

937:
938: return l_return_flag;
939: EXCEPTION
940: WHEN others THEN
941: hr_utility.set_location('Leaving :'||l_proc,15);
942: RETURN l_return_flag;
943: end chk_active_cme_enrl;
944:
945: function get_cert_mbr_enroll_id(p_event_id IN ota_events.event_id%type,