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

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

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

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

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

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

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

129: l_course_end_date ota_events.course_end_date%type;
130:
131: BEGIN
132:
133: hr_utility.set_location('Entering:'|| l_proc, 10);
134:
135: OPEN csr_cert_enrl;
136: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
137: CLOSE csr_cert_enrl;

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

135: OPEN csr_cert_enrl;
136: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
137: CLOSE csr_cert_enrl;
138:
139: hr_utility.set_location('Entering:'|| l_proc, 20);
140:
141: FOR rec_enr IN get_enrl_status(p_activity_version_id,
142: l_cert_period_start_date,
143: l_cert_period_end_date,

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

151: l_course_end_date := rec_enr.course_end_date;
152: EXIT;
153: END LOOP;
154:
155: hr_utility.set_location('Entering:'|| l_proc, 30);
156:
157: if p_mode = 'C' then
158:
159: --don't consider past attended enrls during cert mbr enrl create

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

192: p_completion_date := null;
193: END IF;
194: end if;
195:
196: hr_utility.set_location('Step:'|| l_proc, 40);
197:
198: EXCEPTION
199: WHEN others THEN
200: hr_utility.set_location('LEAVING:'|| l_proc, 50);

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

196: hr_utility.set_location('Step:'|| l_proc, 40);
197:
198: EXCEPTION
199: WHEN others THEN
200: hr_utility.set_location('LEAVING:'|| l_proc, 50);
201: p_member_status_code := 'PLANNED';
202: p_completion_date := null;
203: RAISE;
204:

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

264: l_cert_prd_enrollment_ids varchar2(4000) := '';
265:
266: BEGIN
267:
268: hr_utility.set_location(' Step:'||l_proc,10);
269:
270: OPEN evt_det;
271: FETCH evt_det
272: INTO l_activity_version_id, l_online_flag;

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

271: FETCH evt_det
272: INTO l_activity_version_id, l_online_flag;
273: CLOSE evt_det;
274:
275: hr_utility.set_location(' Step:'|| l_proc, 20);
276:
277:
278: FOR rec_cme_info IN csr_cme_info(l_activity_version_id)
279:

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

331:
332: END LOOP;
333:
334: p_cert_prd_enrollment_ids := l_cert_prd_enrollment_ids;
335: hr_utility.set_location(' Step:'||l_proc,30);
336:
337: EXCEPTION
338: WHEN others THEN
339: hr_utility.set_location('Leaving :'||l_proc,40);

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

335: hr_utility.set_location(' Step:'||l_proc,30);
336:
337: EXCEPTION
338: WHEN others THEN
339: hr_utility.set_location('Leaving :'||l_proc,40);
340: p_cert_prd_enrollment_ids := null;
341: --MULTI MESSAGE SUPPORT
342:
343: END update_cme_status;

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

402: l_proc VARCHAR2(72) := g_package|| 'Update_cpe_status';
403:
404: l_child_update_flag varchar2(1) := 'N';
405: BEGIN
406: hr_utility.set_location(' Step:'|| l_proc, 10);
407:
408: FOR rec_cpe_cme in csr_cpe_cme LOOP
409: l_period_status_code := rec_cpe_cme.period_status_code;
410: --update cpe rec

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

420: END IF;
421:
422: END LOOP;
423:
424: hr_utility.set_location(' Step:'|| l_proc, 20);
425: EXCEPTION
426: WHEN others THEN
427: hr_utility.set_location('Leaving :'||l_proc,30);
428: p_cert_prd_enrollment_id := null;

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

423:
424: hr_utility.set_location(' Step:'|| l_proc, 20);
425: EXCEPTION
426: WHEN others THEN
427: hr_utility.set_location('Leaving :'||l_proc,30);
428: p_cert_prd_enrollment_id := null;
429: --MULTI MESSAGE SUPPORT
430:
431: END Update_cpe_status;

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

466: rec_cme_info csr_cme_info%ROWTYPE;
467:
468: BEGIN
469:
470: hr_utility.set_location(' Step:'||l_proc,10);
471:
472: open csr_cme_info;
473: fetch csr_cme_info into rec_cme_info;
474: close csr_cme_info;

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

502: ,p_member_status_code => l_member_status_code
503: ,p_completion_date => l_completion_date);
504: END IF;
505:
506: hr_utility.set_location(' Step:'||l_proc,30);
507:
508: EXCEPTION
509: WHEN others THEN
510: hr_utility.set_location('Leaving :'||l_proc,40);

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

506: hr_utility.set_location(' Step:'||l_proc,30);
507:
508: EXCEPTION
509: WHEN others THEN
510: hr_utility.set_location('Leaving :'||l_proc,40);
511: --MULTI MESSAGE SUPPORT
512:
513: END update_cme_status;
514:

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

531: where cme.cert_member_id = p_cmb_id;
532: --
533: Begin
534: --
535: hr_utility.set_location('Entering:'|| v_proc, 5);
536: --
537:
538: p_return_status := 'S';
539:

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

551:
552: end if;
553: --
554:
555: hr_utility.set_location(' Step:'|| v_proc, 30);
556:
557: END chk_if_cme_exists;
558:
559: -- ----------------------------------------------------------------------------

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

670: l_cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
671: l_object_version_number ota_cert_mbr_enrollments.object_version_number%type;
672:
673: Begin
674: hr_utility.set_location(' Entering:'||l_proc,10);
675:
676: open csr_cpe;
677: fetch csr_cpe into rec_cpe;
678: close csr_cpe;

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

681: for new_crs in csr_new_crs(rec_cpe.certification_id)
682: loop
683: --create cme record
684:
685: hr_utility.set_location(' Step:'||l_proc,20);
686:
687: ota_utility.Get_Default_Value_Dff(
688: appl_short_name => 'OTA'
689: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'

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

708: ,p_attribute18 => l_attribute18
709: ,p_attribute19 => l_attribute19
710: ,p_attribute20 => l_attribute20);
711:
712: hr_utility.set_location(' Step:'||l_proc,30);
713:
714: ota_cert_mbr_enrollment_api.create_cert_mbr_enrollment(
715: p_effective_date => trunc(sysdate)
716: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id

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

743: );
744:
745: end loop;
746:
747: hr_utility.set_location(' Step:'||l_proc,40);
748:
749: --update cme_record to CANCELLED status for activities which are ended during re-cert
750: for end_crs in csr_end_crs
751: loop

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

758: ,p_cert_mbr_enrollment_id => end_crs.cert_mbr_enrollment_id
759: ,p_member_status_code => 'CANCELLED');
760: end loop;
761:
762: hr_utility.set_location(' Step:'||l_proc,50);
763:
764: EXCEPTION
765: WHEN others THEN
766: hr_utility.set_location('Leaving :'||l_proc,60);

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

762: hr_utility.set_location(' Step:'||l_proc,50);
763:
764: EXCEPTION
765: WHEN others THEN
766: hr_utility.set_location('Leaving :'||l_proc,60);
767: END refresh_cme;
768:
769: Function chk_active_cme_enrl(p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
770: return varchar2

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

813: l_return_flag varchar2(1) := 'F';
814:
815: begin
816:
817: hr_utility.set_location(' Entering:' || l_proc,10);
818:
819: FOR rec IN csr_active_enrl
820: LOOP
821: l_enrollment_Status_Type := rec.enrollment_Status_Type;

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

825:
826: return l_return_flag;
827: EXCEPTION
828: WHEN others THEN
829: hr_utility.set_location('Leaving :'||l_proc,15);
830: RETURN l_return_flag;
831: end chk_active_cme_enrl;
832:
833: