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

Line 341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);

337: l_member_in varchar2(10);
338: l_booking_successful_att_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
339: l_booking_failure_reason ota_delegate_bookings.failure_reason%Type;
340: begin
341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);
342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
343: --HR_UTILITY.TRACE ('ENR STATUS: ' || p_new_status);
344: --HR_UTILITY.TRACE ('FAILURE: ' || p_failed);
345: --HR_UTILITY.TRACE ('DATE_BOOKING_PLACED: ' || p_date_booking_placed);

Line 342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);

338: l_booking_successful_att_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
339: l_booking_failure_reason ota_delegate_bookings.failure_reason%Type;
340: begin
341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);
342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
343: --HR_UTILITY.TRACE ('ENR STATUS: ' || p_new_status);
344: --HR_UTILITY.TRACE ('FAILURE: ' || p_failed);
345: --HR_UTILITY.TRACE ('DATE_BOOKING_PLACED: ' || p_date_booking_placed);
346: v_finance_line_id := null;

Line 343: --HR_UTILITY.TRACE ('ENR STATUS: ' || p_new_status);

339: l_booking_failure_reason ota_delegate_bookings.failure_reason%Type;
340: begin
341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);
342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
343: --HR_UTILITY.TRACE ('ENR STATUS: ' || p_new_status);
344: --HR_UTILITY.TRACE ('FAILURE: ' || p_failed);
345: --HR_UTILITY.TRACE ('DATE_BOOKING_PLACED: ' || p_date_booking_placed);
346: v_finance_line_id := null;
347: v_object_version_number := p_object_version_number;

Line 344: --HR_UTILITY.TRACE ('FAILURE: ' || p_failed);

340: begin
341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);
342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
343: --HR_UTILITY.TRACE ('ENR STATUS: ' || p_new_status);
344: --HR_UTILITY.TRACE ('FAILURE: ' || p_failed);
345: --HR_UTILITY.TRACE ('DATE_BOOKING_PLACED: ' || p_date_booking_placed);
346: v_finance_line_id := null;
347: v_object_version_number := p_object_version_number;
348: if p_sign_eval_status is not null then

Line 345: --HR_UTILITY.TRACE ('DATE_BOOKING_PLACED: ' || p_date_booking_placed);

341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);
342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
343: --HR_UTILITY.TRACE ('ENR STATUS: ' || p_new_status);
344: --HR_UTILITY.TRACE ('FAILURE: ' || p_failed);
345: --HR_UTILITY.TRACE ('DATE_BOOKING_PLACED: ' || p_date_booking_placed);
346: v_finance_line_id := null;
347: v_object_version_number := p_object_version_number;
348: if p_sign_eval_status is not null then
349: if p_signed='Y' then

Line 466: HR_UTILITY.SET_LOCATION ('Leaving:' || L_PROC, 10);

462: update_cme_status_for_lo(l_lo_id, sysdate, l_cert_prd_enr_id);
463: end if;
464: end if;
465: end if;
466: HR_UTILITY.SET_LOCATION ('Leaving:' || L_PROC, 10);
467: end update_enrollment;
468:
469:
470: procedure update_enrollment(

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

578: l_failed varchar2(1):= null;
579: l_new_sign_eval_status varchar2(2) := null;
580:
581: begin
582: hr_utility.set_location('Entering:'|| l_proc, 10);
583: open perf_lesson_status;
584: fetch perf_lesson_status into l_perf_status,l_learning_object_id;
585: close perf_lesson_status;
586: if(l_perf_status = 'F') then

Line 619: hr_utility.set_location('Exiting:'|| l_proc, 20);

615: l_failed);
616: end loop;
617:
618: End If;
619: hr_utility.set_location('Exiting:'|| l_proc, 20);
620: end update_enrollment_status;
621:
622:
623:

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

633:
634: l_proc varchar2(72) := g_package||'update_enroll_status_for_lo';
635:
636: begin
637: hr_utility.set_location('Entering:'|| l_proc, 10);
638: update_enroll_status_for_lo(p_lo_id,p_user_id,p_user_type,p_date,null);
639:
640: hr_utility.set_location('Exiting:'|| l_proc, 15);
641: end update_enroll_status_for_lo;

Line 640: hr_utility.set_location('Exiting:'|| l_proc, 15);

636: begin
637: hr_utility.set_location('Entering:'|| l_proc, 10);
638: update_enroll_status_for_lo(p_lo_id,p_user_id,p_user_type,p_date,null);
639:
640: hr_utility.set_location('Exiting:'|| l_proc, 15);
641: end update_enroll_status_for_lo;
642:
643: procedure update_enroll_status_for_lo(
644: p_lo_id ota_learning_objects.learning_object_id%type,

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

788: l_new_sign_eval_status varchar2(2):= null;
789: l_member_in varchar2(30);
790: l_cert_status OTA_CERT_ENROLLMENTS.CERTIFICATION_STATUS_CODE%type;
791: begin
792: hr_utility.set_location('Entering:'|| l_proc, 10);
793: if p_user_type = 'E' then
794: for a_booking in person_bookings(p_lo_id, p_user_id) loop
795: l_member_in := get_member_in(a_booking.event_id, a_booking.delegate_person_id,null); -- added to check if the course played by learner is part of a certification.
796: --checking if the course is part of cert and signature is enabled for the course and whether the course has already been completed(with signature) once by the learner(person)

Line 864: hr_utility.set_location('Exiting:'|| l_proc, 15);

860: p_failed);
861: end if;
862: end loop;
863: end if;
864: hr_utility.set_location('Exiting:'|| l_proc, 15);
865: end update_enroll_status_for_lo;
866:
867:
868:

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

2349: And per.user_id(+) = p_user_id
2350: And per.user_type(+) = p_user_type
2351: AND per.cert_prd_enrollment_id(+) is null;
2352: Begin
2353: hr_utility.set_location('Entering :'||l_proc,5);
2354:
2355: if(p_scorm_learning_attempt_id is null) then
2356: open c_max_performance_id;
2357: fetch c_max_performance_id into l_max_performance_id;

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

2451: end if;
2452:
2453: End If;
2454:
2455: hr_utility.set_location('Leaving :'||l_proc,10);
2456: RETURN l_return_tree_title;
2457: EXCEPTION
2458: WHEN others THEN
2459: hr_utility.set_location('Leaving :'||l_proc,15);

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

2455: hr_utility.set_location('Leaving :'||l_proc,10);
2456: RETURN l_return_tree_title;
2457: EXCEPTION
2458: WHEN others THEN
2459: hr_utility.set_location('Leaving :'||l_proc,15);
2460:
2461: RETURN l_return_tree_title;
2462: End get_lo_title_for_tree;
2463:

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

3010: l_proc varchar2(72) := g_package||'Root_Folder_Exists';
3011: --
3012: begin
3013: --
3014: hr_utility.set_location('Entering:'|| l_proc, 10);
3015: --
3016: open root_folder;
3017: fetch root_folder into l_folder_flag;
3018: IF root_folder%found THEN

Line 3021: hr_utility.set_location('returning Y:'|| l_proc, 10);

3017: fetch root_folder into l_folder_flag;
3018: IF root_folder%found THEN
3019: --
3020: l_return := 'Y';
3021: hr_utility.set_location('returning Y:'|| l_proc, 10);
3022: End if;
3023: --
3024: close root_folder;
3025: --

Line 3026: hr_utility.set_location('Exiting:'|| l_proc, 20);

3022: End if;
3023: --
3024: close root_folder;
3025: --
3026: hr_utility.set_location('Exiting:'|| l_proc, 20);
3027: --
3028: return l_return;
3029: --
3030: End Root_Folder_Exists;

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

3098:
3099: l_imported_offering ota_events.offering_id%TYPE := null;
3100:
3101: BEGIN
3102: hr_utility.set_location(' Step:'|| l_proc, 10);
3103:
3104: open c_learning_object;
3105: fetch c_learning_object into l_learning_object_id;
3106: close c_learning_object;

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

3125:
3126: End If;
3127:
3128: RETURN l_status;
3129: hr_utility.set_location(' Step:'|| l_proc, 20);
3130: END get_player_status;
3131:
3132: -- ----------------------------------------------------------------------------
3133: -- |-------------------------< get_enroll_lo_time >--------------------------|

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

3198:
3199: l_imported_offering ota_events.offering_id%TYPE := null;
3200:
3201: BEGIN
3202: hr_utility.set_location(' Step:'|| l_proc, 10);
3203:
3204: open c_learning_object;
3205: fetch c_learning_object into l_learning_object_id;
3206: close c_learning_object;

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

3225:
3226: End If;
3227:
3228: RETURN l_time;
3229: hr_utility.set_location(' Step:'|| l_proc, 20);
3230: END get_enroll_lo_time;
3231:
3232: -- ----------------------------------------------------------------------------
3233: -- |-------------------------< get_enroll_lo_score >--------------------------|

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

3298:
3299: l_imported_offering ota_events.offering_id%TYPE := null;
3300:
3301: BEGIN
3302: hr_utility.set_location(' Step:'|| l_proc, 10);
3303:
3304: open c_learning_object;
3305: fetch c_learning_object into l_learning_object_id;
3306: close c_learning_object;

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

3329: l_score := null;
3330: End If;
3331:
3332: RETURN l_score;
3333: hr_utility.set_location(' Step:'|| l_proc, 20);
3334: END get_enroll_lo_score;
3335: -- ----------------------------------------------------------------------------
3336: -- |-------------------------< get_enroll_lo_status >--------------------------|
3337: -- ----------------------------------------------------------------------------

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

3495: l_perf_rec_count INTEGER := 0;
3496: l_multiple boolean:=false;
3497:
3498: BEGIN
3499: hr_utility.set_location(' Step:'|| l_proc, 10);
3500: open c_delivery_mode;
3501: fetch c_delivery_mode into l_online_flag, l_learning_object_id, l_course_end_date, l_sysdate; --Bug 5222464
3502: close c_delivery_mode;
3503:

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

3638: End If;
3639: End If;
3640:
3641: RETURN l_status_name;
3642: hr_utility.set_location(' Step:'|| l_proc, 20);
3643: END get_enroll_lo_status;
3644:
3645: -- ----------------------------------------------------------------------------
3646: -- |-------------------------< get_history_button >----------------------------|

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

3714: AND content_player_status in ('P', 'C');
3715:
3716: BEGIN
3717:
3718: hr_utility.set_location(' Step:'|| l_proc, 10);
3719:
3720: --Initialize local variables
3721: l_enable_move_to_history := false;
3722: l_return := 'MoveToHistoryDisabled';

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

3869: And opf.cert_prd_enrollment_id(+) = p_cert_prd_enroll_id
3870: And ocu.Category_Usage_Id = ofr.Delivery_Mode_Id;
3871:
3872: Begin
3873: hr_utility.set_location('Entering :'||l_proc,5);
3874: if(p_cert_prd_enroll_id is not null) then
3875: open c_get_lo_completion_date_cert;
3876: fetch c_get_lo_completion_date_cert into l_event_id, l_lo_id, l_lo_completed_date, l_lo_completed_time, l_lo_lesson_status, l_sync_flag, l_online_flag, l_lo_completed_date_tz;
3877: close c_get_lo_completion_date_cert;

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

3898:
3899: RETURN l_return_completion_date;
3900: EXCEPTION
3901: WHEN others THEN
3902: hr_utility.set_location('Leaving :'||l_proc,15);
3903: RETURN l_return_completion_date;
3904: End get_lo_completion_date;
3905:
3906: -- ----------------------------------------------------------------------------

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

3978: And opf.cert_prd_enrollment_id(+) = p_cert_prd_enroll_id
3979: And ocu.Category_Usage_Id = ofr.Delivery_Mode_Id;
3980:
3981: Begin
3982: hr_utility.set_location('Entering :'||l_proc,5);
3983:
3984: if(p_cert_prd_enroll_id is not null) then
3985: open c_get_lo_completion_date_cert;
3986: fetch c_get_lo_completion_date_cert into l_event_id, l_lo_id, l_lo_completed_date, l_lo_completed_time, l_lo_lesson_status, l_sync_flag, l_online_flag, l_lo_completed_date_tz,l_lo_comp_date;

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

4003:
4004: RETURN l_return_completion_date;
4005: EXCEPTION
4006: WHEN others THEN
4007: hr_utility.set_location('Leaving :'||l_proc,15);
4008: RETURN l_return_completion_date;
4009: End get_lo_completion_date_time;
4010:
4011: -- ----------------------------------------------------------------------------

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

4089: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4090: l_sign_eval_status OTA_DELEGATE_BOOKINGS.sign_eval_status%type;
4091:
4092: BEGIN
4093: hr_utility.set_location(' Step:'|| l_proc, 10);
4094: open c_delivery_mode;
4095: fetch c_delivery_mode into l_online_flag, l_learning_object_id, l_course_end_date;
4096: close c_delivery_mode;
4097:

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

4135: close c_booking_status;
4136: End If;
4137:
4138: RETURN l_status_name;
4139: hr_utility.set_location(' Step:'|| l_proc, 20);
4140:
4141: EXCEPTION
4142: WHEN others THEN
4143: hr_utility.set_location('Leaving :'||l_proc,30);

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

4139: hr_utility.set_location(' Step:'|| l_proc, 20);
4140:
4141: EXCEPTION
4142: WHEN others THEN
4143: hr_utility.set_location('Leaving :'||l_proc,30);
4144: RETURN NULL;
4145:
4146: END get_cert_lo_status;
4147:

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

4285: And per.user_id(+) = p_user_id
4286: And per.user_type(+) = p_user_type
4287: And per.cert_prd_enrollment_id(+) = p_cert_prd_enrollment_id;
4288: Begin
4289: hr_utility.set_location('Entering :'||l_proc,5);
4290:
4291: if(p_scormattempid is null) then
4292: open c_max_performance_id;
4293: fetch c_max_performance_id into l_max_performance_id;

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

4373: Else
4374: l_return_tree_title := l_lo_status_icon;
4375: End If;
4376:
4377: hr_utility.set_location('Leaving :'||l_proc,10);
4378: RETURN l_return_tree_title;
4379: EXCEPTION
4380: WHEN others THEN
4381: hr_utility.set_location('Leaving :'||l_proc,15);

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

4377: hr_utility.set_location('Leaving :'||l_proc,10);
4378: RETURN l_return_tree_title;
4379: EXCEPTION
4380: WHEN others THEN
4381: hr_utility.set_location('Leaving :'||l_proc,15);
4382:
4383: RETURN l_return_tree_title;
4384: End get_cert_lo_title_for_tree;
4385:

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

4477: l_online_event_id ota_events.event_id%type;
4478: l_online_evt_count number;
4479:
4480: BEGIN
4481: hr_utility.set_location('Entering :'||l_proc,5);
4482:
4483: --check for mult online evts and throw null if so
4484: l_online_evt_count := get_cme_onl_evt_count(p_user_id, p_user_type, p_cert_mbr_enrollment_id);
4485:

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

4494: OPEN csr_cert_enrl(rec_cme_info.cert_prd_enrollment_id);
4495: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
4496: CLOSE csr_cert_enrl;
4497:
4498: hr_utility.set_location(' Step:'||l_proc,10);
4499:
4500: FOR rec IN get_enrl_status_on_update(rec_cme_info.object_id,
4501: l_cert_period_start_date,
4502: l_cert_period_end_date,

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

4511:
4512:
4513: END LOOP;
4514:
4515: hr_utility.set_location('Leaving :'||l_proc,10);
4516:
4517: return l_online_event_id;
4518:
4519: EXCEPTION

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

4517: return l_online_event_id;
4518:
4519: EXCEPTION
4520: WHEN others THEN
4521: hr_utility.set_location('Leaving :'||l_proc,15);
4522:
4523: RETURN null;
4524:
4525: End get_cme_online_event_id;

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

4558: l_return_play_btn VARCHAR2(30) := 'DISABLE_NOT_ENROLLED';
4559: l_online_evt_count number;
4560:
4561: BEGIN
4562: hr_utility.set_location('Entering :'||l_proc,5);
4563:
4564: --check for mult online evts and throw null if so
4565: l_online_evt_count := get_cme_onl_evt_count(p_user_id, p_user_type, p_cert_mbr_enrollment_id);
4566:

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

4582: l_return_play_btn := OTA_LO_UTILITY.GET_PLAY_BUTTON(p_user_id,p_user_type, p_is_manager, rec.EVENT_ID, rec.EVENT_TYPE
4583: ,rec.SYNCHRONOUS_FLAG, rec.ONLINE_FLAG
4584: ,rec.COURSE_START_DATE ,rec.COURSE_END_DATE, null,rec_cme.cert_prd_enrollment_id);
4585: end if;
4586: hr_utility.set_location('Leaving :'||l_proc,10);
4587:
4588: return l_return_play_btn;
4589:
4590: EXCEPTION

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

4588: return l_return_play_btn;
4589:
4590: EXCEPTION
4591: WHEN others THEN
4592: hr_utility.set_location('Leaving :'||l_proc,15);
4593:
4594: RETURN null;
4595:
4596: End get_cme_play_button;

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

4615: l_online_event_id ota_events.event_id%type;
4616: l_online_evt_count number;
4617:
4618: BEGIN
4619: hr_utility.set_location('Entering :'||l_proc,5);
4620:
4621: --check for mult online evts and throw null if so
4622: l_online_evt_count := get_cme_onl_evt_count(p_user_id, p_user_type, p_cert_mbr_enrollment_id);
4623:

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

4630: open csr_toolbar_flag(l_online_event_id);
4631: fetch csr_toolbar_flag into l_player_toolbar_flag;
4632: close csr_toolbar_flag;
4633:
4634: hr_utility.set_location('Leaving :'||l_proc,10);
4635:
4636: return l_player_toolbar_flag;
4637:
4638: EXCEPTION

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

4636: return l_player_toolbar_flag;
4637:
4638: EXCEPTION
4639: WHEN others THEN
4640: hr_utility.set_location('Leaving :'||l_proc,15);
4641:
4642: RETURN null;
4643:
4644: End get_cme_player_toolbar_flag;

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

4729: rec_prf_ord csr_prf_ord%rowtype;
4730: rec_get_act csr_get_act%rowtype;
4731:
4732: BEGIN
4733: hr_utility.set_location('Entering :'||l_proc,5);
4734:
4735: open csr_cme;
4736: fetch csr_cme into l_cert_prd_enrollment_id;
4737: close csr_cme;

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

4786: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
4787: End If;
4788: End If;
4789:
4790: hr_utility.set_location('Leaving :'||l_proc,10);
4791:
4792: return l_status_name;
4793:
4794: EXCEPTION

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

4792: return l_status_name;
4793:
4794: EXCEPTION
4795: WHEN others THEN
4796: hr_utility.set_location('Leaving :'||l_proc,15);
4797:
4798: RETURN null;
4799:
4800: End get_cert_lo_status;

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

4892: l_online_event_id ota_events.event_id%type;
4893: l_online_event_count number := 0;
4894:
4895: BEGIN
4896: hr_utility.set_location('Entering :'||l_proc,5);
4897:
4898:
4899: open csr_cme_info;
4900: fetch csr_cme_info into rec_cme_info;

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

4903: OPEN csr_cert_enrl(rec_cme_info.cert_prd_enrollment_id);
4904: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
4905: CLOSE csr_cert_enrl;
4906:
4907: hr_utility.set_location(' Step:'||l_proc,10);
4908:
4909: FOR rec IN get_enrl_status_on_update(rec_cme_info.object_id,
4910: l_cert_period_start_date,
4911: l_cert_period_end_date,

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

4921:
4922:
4923: END LOOP;
4924:
4925: hr_utility.set_location('Leaving :'||l_proc,10);
4926:
4927: return '' || l_online_event_count;
4928:
4929: EXCEPTION

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

4927: return '' || l_online_event_count;
4928:
4929: EXCEPTION
4930: WHEN others THEN
4931: hr_utility.set_location('Leaving :'||l_proc,15);
4932:
4933: RETURN null;
4934:
4935: End get_cme_onl_evt_count;

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

5062: l_online_event_id ota_events.event_id%type;
5063: l_online_evt_count number;
5064:
5065: BEGIN
5066: hr_utility.set_location('Entering :'||l_proc,5);
5067:
5068: --check for mult online evts and throw null if so
5069: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
5070:

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

5075: open csr_lme_info;
5076: fetch csr_lme_info into rec_lme_info;
5077: close csr_lme_info;
5078:
5079: hr_utility.set_location(' Step:'||l_proc,10);
5080:
5081: FOR rec IN get_enrl_status(rec_lme_info.activity_version_id,
5082: rec_lme_info.person_id,
5083: rec_lme_info.contact_id)

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

5090:
5091:
5092: END LOOP;
5093:
5094: hr_utility.set_location('Leaving :'||l_proc,10);
5095:
5096: return l_online_event_id;
5097:
5098: EXCEPTION

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

5096: return l_online_event_id;
5097:
5098: EXCEPTION
5099: WHEN others THEN
5100: hr_utility.set_location('Leaving :'||l_proc,15);
5101:
5102: RETURN null;
5103:
5104: End get_lme_online_event_id;

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

5131: l_return_play_btn VARCHAR2(30) := 'DISABLE_NOT_ENROLLED';
5132: l_online_evt_count number;
5133:
5134: BEGIN
5135: hr_utility.set_location('Entering :'||l_proc,5);
5136:
5137: --check for mult online evts and throw null if so
5138: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
5139:

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

5151: l_return_play_btn := GET_PLAY_BUTTON(p_user_id,p_user_type, p_is_manager, rec.EVENT_ID, rec.EVENT_TYPE
5152: ,rec.SYNCHRONOUS_FLAG, rec.ONLINE_FLAG
5153: ,rec.COURSE_START_DATE ,rec.COURSE_END_DATE);
5154: end if;
5155: hr_utility.set_location('Leaving :'||l_proc,10);
5156:
5157: return l_return_play_btn;
5158:
5159: EXCEPTION

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

5157: return l_return_play_btn;
5158:
5159: EXCEPTION
5160: WHEN others THEN
5161: hr_utility.set_location('Leaving :'||l_proc,15);
5162:
5163: RETURN null;
5164:
5165: End get_lme_play_button;

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

5182: l_online_event_id ota_events.event_id%type;
5183: l_online_evt_count number;
5184:
5185: BEGIN
5186: hr_utility.set_location('Entering :'||l_proc,5);
5187:
5188: --check for mult online evts and throw null if so
5189: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
5190:

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

5197: open csr_toolbar_flag(l_online_event_id);
5198: fetch csr_toolbar_flag into l_player_toolbar_flag;
5199: close csr_toolbar_flag;
5200:
5201: hr_utility.set_location('Leaving :'||l_proc,10);
5202:
5203: return l_player_toolbar_flag;
5204:
5205: EXCEPTION

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

5203: return l_player_toolbar_flag;
5204:
5205: EXCEPTION
5206: WHEN others THEN
5207: hr_utility.set_location('Leaving :'||l_proc,15);
5208:
5209: RETURN null;
5210:
5211: End get_lme_player_toolbar_flag;

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

5276:
5277: l_return_lo_status VARCHAR2(30);
5278: l_online_evt_count number;
5279: BEGIN
5280: hr_utility.set_location('Entering :'||l_proc,5);
5281:
5282: --check for mult online evts and throw null if so
5283: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
5284:

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

5312: close csr_event;
5313:
5314: l_status_name := get_enroll_lo_status(p_user_id, p_user_type, rec.event_id, null, null, 1);
5315:
5316: hr_utility.set_location('Leaving :'||l_proc,10);
5317:
5318: return l_status_name;
5319:
5320: EXCEPTION

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

5318: return l_status_name;
5319:
5320: EXCEPTION
5321: WHEN others THEN
5322: hr_utility.set_location('Leaving :'||l_proc,15);
5323:
5324: RETURN null;
5325:
5326: End get_lpe_lo_status;

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

5383: l_online_event_count number := 0;
5384: l_online_evt_count number;
5385:
5386: BEGIN
5387: hr_utility.set_location('Entering :'||l_proc,5);
5388:
5389: open csr_lme_info;
5390: fetch csr_lme_info into rec_lme_info;
5391: close csr_lme_info;

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

5389: open csr_lme_info;
5390: fetch csr_lme_info into rec_lme_info;
5391: close csr_lme_info;
5392:
5393: hr_utility.set_location(' Step:'||l_proc,10);
5394:
5395: FOR rec IN get_enrl_status(rec_lme_info.activity_version_id,
5396: rec_lme_info.person_id,
5397: rec_lme_info.contact_id)

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

5404: end if;
5405:
5406: END LOOP;
5407:
5408: hr_utility.set_location('Leaving :'||l_proc,10);
5409:
5410: return '' || l_online_event_count;
5411:
5412: EXCEPTION

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

5410: return '' || l_online_event_count;
5411:
5412: EXCEPTION
5413: WHEN others THEN
5414: hr_utility.set_location('Leaving :'||l_proc,15);
5415:
5416: RETURN null;
5417:
5418: End get_lme_onl_evt_count;

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

5431:
5432:
5433: begin
5434:
5435: hr_utility.set_location(' Step:'||l_proc,10);
5436:
5437: if(p_person_id is not null) then
5438: for rec_active_cert_prd in csr_active_cert_prd_person(p_event_id, p_person_id)
5439: loop

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

5460: end loop;
5461: end if;
5462:
5463: p_cert_prd_enrollment_ids := l_cert_prd_enrollment_ids;
5464: hr_utility.set_location(' Step:'||l_proc,30);
5465:
5466: EXCEPTION
5467: WHEN others THEN
5468: hr_utility.set_location('Leaving :'||l_proc,40);

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

5464: hr_utility.set_location(' Step:'||l_proc,30);
5465:
5466: EXCEPTION
5467: WHEN others THEN
5468: hr_utility.set_location('Leaving :'||l_proc,40);
5469: p_cert_prd_enrollment_ids := null;
5470: --MULTI MESSAGE SUPPORT
5471:
5472: end get_active_cert_prds;

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

5494: l_proc varchar2(72) := g_package||'LO_has_child_and_having_url';
5495: --
5496: BEGIN
5497: --
5498: hr_utility.set_location('Entering:'|| l_proc, 10);
5499: --
5500: OPEN csr_par_with_cld_no_url;
5501: FETCH csr_par_with_cld_no_url INTO l_learning_object_flag;
5502: IF csr_par_with_cld_no_url%found THEN

Line 5505: hr_utility.set_location('returning Y:'|| l_proc, 10);

5501: FETCH csr_par_with_cld_no_url INTO l_learning_object_flag;
5502: IF csr_par_with_cld_no_url%found THEN
5503: --
5504: l_return := 'Y';
5505: hr_utility.set_location('returning Y:'|| l_proc, 10);
5506: END IF;
5507: --
5508: CLOSE csr_par_with_cld_no_url;
5509: --

Line 5510: hr_utility.set_location('Exiting:'|| l_proc, 20);

5506: END IF;
5507: --
5508: CLOSE csr_par_with_cld_no_url;
5509: --
5510: hr_utility.set_location('Exiting:'|| l_proc, 20);
5511: --
5512: RETURN l_return;
5513: --
5514: End Lo_has_cld_and_no_strt_url;

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

5684: l_person_id ota_cert_enrollments.person_id%type := null;
5685: l_contact_id ota_cert_enrollments.contact_id%type := null;
5686: BEGIN
5687:
5688: hr_utility.set_location(' Step:'|| l_proc, 10);
5689: if p_chk_active_cert_flag is not null and p_chk_active_cert_flag = 'Y' then
5690: if p_user_type = 'E' then
5691: l_person_id := p_user_id;
5692: elsif p_user_type = 'C' then