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.

[Home] [Help]

APPS.OTA_LO_UTILITY dependencies on HR_UTILITY

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

288: l_learning_object_id ota_offerings.learning_object_id%type;
289: l_failed varchar2(1):= null;
290:
291: begin
292: hr_utility.set_location('Entering:'|| l_proc, 10);
293: open perf_lesson_status;
294: fetch perf_lesson_status into l_perf_status,l_learning_object_id;
295: close perf_lesson_status;
296: if(l_perf_status = 'F') then

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

323: l_failed);
324: end loop;
325:
326: End If;
327: hr_utility.set_location('Exiting:'|| l_proc, 20);
328: end update_enrollment_status;
329:
330:
331:

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

341:
342: l_proc varchar2(72) := g_package||'update_enroll_status_for_lo';
343:
344: begin
345: hr_utility.set_location('Entering:'|| l_proc, 10);
346: update_enroll_status_for_lo(p_lo_id,p_user_id,p_user_type,p_date,null);
347:
348: hr_utility.set_location('Exiting:'|| l_proc, 15);
349: end update_enroll_status_for_lo;

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

344: begin
345: hr_utility.set_location('Entering:'|| l_proc, 10);
346: update_enroll_status_for_lo(p_lo_id,p_user_id,p_user_type,p_date,null);
347:
348: hr_utility.set_location('Exiting:'|| l_proc, 15);
349: end update_enroll_status_for_lo;
350:
351: procedure update_enroll_status_for_lo(
352: p_lo_id ota_learning_objects.learning_object_id%type,

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

458: l_status varchar2(80) :='ATTENDED';
459: l_user_type ota_attempts.user_type%type;
460:
461: begin
462: hr_utility.set_location('Entering:'|| l_proc, 10);
463: if p_user_type = 'E' then
464: for a_booking in person_bookings(p_lo_id, p_user_id) loop
465: l_event_id := a_booking.event_id;
466: open csr_evt_evaluations;

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

540: l_status,
541: p_failed);
542: end loop;
543: end if;
544: hr_utility.set_location('Exiting:'|| l_proc, 15);
545: end update_enroll_status_for_lo;
546:
547:
548: procedure update_cme_status_for_lo(

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

1978: And per.user_type(+) = p_user_type
1979: AND per.cert_prd_enrollment_id(+) is null;
1980:
1981: Begin
1982: hr_utility.set_location('Entering :'||l_proc,5);
1983:
1984: open c_max_performance_id;
1985: fetch c_max_performance_id into l_max_performance_id;
1986: close c_max_performance_id;

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

2066: end if;
2067:
2068: End If;
2069:
2070: hr_utility.set_location('Leaving :'||l_proc,10);
2071: RETURN l_return_tree_title;
2072: EXCEPTION
2073: WHEN others THEN
2074: hr_utility.set_location('Leaving :'||l_proc,15);

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

2070: hr_utility.set_location('Leaving :'||l_proc,10);
2071: RETURN l_return_tree_title;
2072: EXCEPTION
2073: WHEN others THEN
2074: hr_utility.set_location('Leaving :'||l_proc,15);
2075:
2076: RETURN l_return_tree_title;
2077: End get_lo_title_for_tree;
2078:

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

2645: l_proc varchar2(72) := g_package||'Root_Folder_Exists';
2646: --
2647: begin
2648: --
2649: hr_utility.set_location('Entering:'|| l_proc, 10);
2650: --
2651: open root_folder;
2652: fetch root_folder into l_folder_flag;
2653: IF root_folder%found THEN

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

2652: fetch root_folder into l_folder_flag;
2653: IF root_folder%found THEN
2654: --
2655: l_return := 'Y';
2656: hr_utility.set_location('returning Y:'|| l_proc, 10);
2657: End if;
2658: --
2659: close root_folder;
2660: --

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

2657: End if;
2658: --
2659: close root_folder;
2660: --
2661: hr_utility.set_location('Exiting:'|| l_proc, 20);
2662: --
2663: return l_return;
2664: --
2665: End Root_Folder_Exists;

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

2733:
2734: l_imported_offering ota_events.offering_id%TYPE := null;
2735:
2736: BEGIN
2737: hr_utility.set_location(' Step:'|| l_proc, 10);
2738:
2739: open c_learning_object;
2740: fetch c_learning_object into l_learning_object_id;
2741: close c_learning_object;

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

2760:
2761: End If;
2762:
2763: RETURN l_status;
2764: hr_utility.set_location(' Step:'|| l_proc, 20);
2765: END get_player_status;
2766:
2767: -- ----------------------------------------------------------------------------
2768: -- |-------------------------< get_enroll_lo_time >--------------------------|

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

2833:
2834: l_imported_offering ota_events.offering_id%TYPE := null;
2835:
2836: BEGIN
2837: hr_utility.set_location(' Step:'|| l_proc, 10);
2838:
2839: open c_learning_object;
2840: fetch c_learning_object into l_learning_object_id;
2841: close c_learning_object;

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

2860:
2861: End If;
2862:
2863: RETURN l_time;
2864: hr_utility.set_location(' Step:'|| l_proc, 20);
2865: END get_enroll_lo_time;
2866:
2867: -- ----------------------------------------------------------------------------
2868: -- |-------------------------< get_enroll_lo_score >--------------------------|

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

2933:
2934: l_imported_offering ota_events.offering_id%TYPE := null;
2935:
2936: BEGIN
2937: hr_utility.set_location(' Step:'|| l_proc, 10);
2938:
2939: open c_learning_object;
2940: fetch c_learning_object into l_learning_object_id;
2941: close c_learning_object;

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

2964: l_score := null;
2965: End If;
2966:
2967: RETURN l_score;
2968: hr_utility.set_location(' Step:'|| l_proc, 20);
2969: END get_enroll_lo_score;
2970: -- ----------------------------------------------------------------------------
2971: -- |-------------------------< get_enroll_lo_status >--------------------------|
2972: -- ----------------------------------------------------------------------------

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

3092: l_contact_id ota_cert_enrollments.contact_id%type := null;
3093:
3094:
3095: BEGIN
3096: hr_utility.set_location(' Step:'|| l_proc, 10);
3097: open c_delivery_mode;
3098: fetch c_delivery_mode into l_online_flag, l_learning_object_id, l_course_end_date, l_sysdate; --Bug 5222464
3099: close c_delivery_mode;
3100:

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

3190: End If;
3191: End If;
3192:
3193: RETURN l_status_name;
3194: hr_utility.set_location(' Step:'|| l_proc, 20);
3195: END get_enroll_lo_status;
3196:
3197: -- ----------------------------------------------------------------------------
3198: -- |-------------------------< get_history_button >----------------------------|

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

3266: AND content_player_status in ('P', 'C');
3267:
3268: BEGIN
3269:
3270: hr_utility.set_location(' Step:'|| l_proc, 10);
3271:
3272: --Initialize local variables
3273: l_enable_move_to_history := false;
3274: l_return := 'MoveToHistoryDisabled';

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

3398: And nvl(opf.cert_prd_enrollment_id(+), -1) = nvl(p_cert_prd_enroll_id, -1)
3399: And ocu.Category_Usage_Id = ofr.Delivery_Mode_Id;
3400:
3401: Begin
3402: hr_utility.set_location('Entering :'||l_proc,5);
3403: /* if p_event_id = 3051 THEN
3404: hr_utility.trace_on(NULL, 'ORACLE');
3405: END IF;
3406: hr_utility.trace(' inside lo completion method');

Line 3404: hr_utility.trace_on(NULL, 'ORACLE');

3400:
3401: Begin
3402: hr_utility.set_location('Entering :'||l_proc,5);
3403: /* if p_event_id = 3051 THEN
3404: hr_utility.trace_on(NULL, 'ORACLE');
3405: END IF;
3406: hr_utility.trace(' inside lo completion method');
3407: hr_utility.trace('nls lan param ' || get_nls_language);
3408:

Line 3406: hr_utility.trace(' inside lo completion method');

3402: hr_utility.set_location('Entering :'||l_proc,5);
3403: /* if p_event_id = 3051 THEN
3404: hr_utility.trace_on(NULL, 'ORACLE');
3405: END IF;
3406: hr_utility.trace(' inside lo completion method');
3407: hr_utility.trace('nls lan param ' || get_nls_language);
3408:
3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );
3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );

Line 3407: hr_utility.trace('nls lan param ' || get_nls_language);

3403: /* if p_event_id = 3051 THEN
3404: hr_utility.trace_on(NULL, 'ORACLE');
3405: END IF;
3406: hr_utility.trace(' inside lo completion method');
3407: hr_utility.trace('nls lan param ' || get_nls_language);
3408:
3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );
3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );
3411: hr_utility.trace('nls date language ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_LANGUAGE') );

Line 3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );

3405: END IF;
3406: hr_utility.trace(' inside lo completion method');
3407: hr_utility.trace('nls lan param ' || get_nls_language);
3408:
3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );
3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );
3411: hr_utility.trace('nls date language ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_LANGUAGE') );
3412: hr_utility.trace('ICX Language ' || fnd_profile.value('ICX_LANGUAGE'));
3413: hr_utility.trace('ICX Date format ' || fnd_profile.value('ICX_DATE_FORMAT_MASK'));

Line 3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );

3406: hr_utility.trace(' inside lo completion method');
3407: hr_utility.trace('nls lan param ' || get_nls_language);
3408:
3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );
3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );
3411: hr_utility.trace('nls date language ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_LANGUAGE') );
3412: hr_utility.trace('ICX Language ' || fnd_profile.value('ICX_LANGUAGE'));
3413: hr_utility.trace('ICX Date format ' || fnd_profile.value('ICX_DATE_FORMAT_MASK'));
3414: */

Line 3411: hr_utility.trace('nls date language ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_LANGUAGE') );

3407: hr_utility.trace('nls lan param ' || get_nls_language);
3408:
3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );
3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );
3411: hr_utility.trace('nls date language ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_LANGUAGE') );
3412: hr_utility.trace('ICX Language ' || fnd_profile.value('ICX_LANGUAGE'));
3413: hr_utility.trace('ICX Date format ' || fnd_profile.value('ICX_DATE_FORMAT_MASK'));
3414: */
3415:

Line 3412: hr_utility.trace('ICX Language ' || fnd_profile.value('ICX_LANGUAGE'));

3408:
3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );
3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );
3411: hr_utility.trace('nls date language ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_LANGUAGE') );
3412: hr_utility.trace('ICX Language ' || fnd_profile.value('ICX_LANGUAGE'));
3413: hr_utility.trace('ICX Date format ' || fnd_profile.value('ICX_DATE_FORMAT_MASK'));
3414: */
3415:
3416:

Line 3413: hr_utility.trace('ICX Date format ' || fnd_profile.value('ICX_DATE_FORMAT_MASK'));

3409: hr_utility.trace('nls date format ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_FORMAT') );
3410: hr_utility.trace('nls language2 ' || hr_util_misc_web.get_nls_parameter('NLS_LANGUAGE') );
3411: hr_utility.trace('nls date language ' || hr_util_misc_web.get_nls_parameter('NLS_DATE_LANGUAGE') );
3412: hr_utility.trace('ICX Language ' || fnd_profile.value('ICX_LANGUAGE'));
3413: hr_utility.trace('ICX Date format ' || fnd_profile.value('ICX_DATE_FORMAT_MASK'));
3414: */
3415:
3416:
3417: open c_get_lo_completion_date;

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

3435:
3436: RETURN l_return_completion_date;
3437: EXCEPTION
3438: WHEN others THEN
3439: hr_utility.set_location('Leaving :'||l_proc,15);
3440: RETURN l_return_completion_date;
3441: End get_lo_completion_date;
3442:
3443: -- ----------------------------------------------------------------------------

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

3487: And nvl(opf.cert_prd_enrollment_id(+), -1) = nvl(p_cert_prd_enroll_id, -1)
3488: And ocu.Category_Usage_Id = ofr.Delivery_Mode_Id;
3489:
3490: Begin
3491: hr_utility.set_location('Entering :'||l_proc,5);
3492:
3493:
3494: open c_get_lo_completion_date;
3495: fetch c_get_lo_completion_date 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 3511: hr_utility.set_location('Leaving :'||l_proc,15);

3507:
3508: RETURN l_return_completion_date;
3509: EXCEPTION
3510: WHEN others THEN
3511: hr_utility.set_location('Leaving :'||l_proc,15);
3512: RETURN l_return_completion_date;
3513: End get_lo_completion_date_time;
3514:
3515: -- ----------------------------------------------------------------------------

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

3587: l_status VARCHAR2(30) := null;
3588: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3589:
3590: BEGIN
3591: hr_utility.set_location(' Step:'|| l_proc, 10);
3592: open c_delivery_mode;
3593: fetch c_delivery_mode into l_online_flag, l_learning_object_id, l_course_end_date;
3594: close c_delivery_mode;
3595:

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

3619: close c_booking_status;
3620: End If;
3621:
3622: RETURN l_status_name;
3623: hr_utility.set_location(' Step:'|| l_proc, 20);
3624:
3625: EXCEPTION
3626: WHEN others THEN
3627: hr_utility.set_location('Leaving :'||l_proc,30);

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

3623: hr_utility.set_location(' Step:'|| l_proc, 20);
3624:
3625: EXCEPTION
3626: WHEN others THEN
3627: hr_utility.set_location('Leaving :'||l_proc,30);
3628: RETURN NULL;
3629:
3630: END get_cert_lo_status;
3631:

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

3723: And per.user_type(+) = p_user_type
3724: And per.cert_prd_enrollment_id(+) = p_cert_prd_enrollment_id;
3725:
3726: Begin
3727: hr_utility.set_location('Entering :'||l_proc,5);
3728:
3729: open c_max_performance_id;
3730: fetch c_max_performance_id into l_max_performance_id;
3731: close c_max_performance_id;

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

3797: Else
3798: l_return_tree_title := l_lo_status_icon;
3799: End If;
3800:
3801: hr_utility.set_location('Leaving :'||l_proc,10);
3802: RETURN l_return_tree_title;
3803: EXCEPTION
3804: WHEN others THEN
3805: hr_utility.set_location('Leaving :'||l_proc,15);

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

3801: hr_utility.set_location('Leaving :'||l_proc,10);
3802: RETURN l_return_tree_title;
3803: EXCEPTION
3804: WHEN others THEN
3805: hr_utility.set_location('Leaving :'||l_proc,15);
3806:
3807: RETURN l_return_tree_title;
3808: End get_cert_lo_title_for_tree;
3809:

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

3901: l_online_event_id ota_events.event_id%type;
3902: l_online_evt_count number;
3903:
3904: BEGIN
3905: hr_utility.set_location('Entering :'||l_proc,5);
3906:
3907: --check for mult online evts and throw null if so
3908: l_online_evt_count := get_cme_onl_evt_count(p_user_id, p_user_type, p_cert_mbr_enrollment_id);
3909:

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

3918: OPEN csr_cert_enrl(rec_cme_info.cert_prd_enrollment_id);
3919: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
3920: CLOSE csr_cert_enrl;
3921:
3922: hr_utility.set_location(' Step:'||l_proc,10);
3923:
3924: FOR rec IN get_enrl_status_on_update(rec_cme_info.object_id,
3925: l_cert_period_start_date,
3926: l_cert_period_end_date,

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

3935:
3936:
3937: END LOOP;
3938:
3939: hr_utility.set_location('Leaving :'||l_proc,10);
3940:
3941: return l_online_event_id;
3942:
3943: EXCEPTION

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

3941: return l_online_event_id;
3942:
3943: EXCEPTION
3944: WHEN others THEN
3945: hr_utility.set_location('Leaving :'||l_proc,15);
3946:
3947: RETURN null;
3948:
3949: End get_cme_online_event_id;

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

3982: l_return_play_btn VARCHAR2(30) := 'DISABLE_NOT_ENROLLED';
3983: l_online_evt_count number;
3984:
3985: BEGIN
3986: hr_utility.set_location('Entering :'||l_proc,5);
3987:
3988: --check for mult online evts and throw null if so
3989: l_online_evt_count := get_cme_onl_evt_count(p_user_id, p_user_type, p_cert_mbr_enrollment_id);
3990:

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

4006: 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
4007: ,rec.SYNCHRONOUS_FLAG, rec.ONLINE_FLAG
4008: ,rec.COURSE_START_DATE ,rec.COURSE_END_DATE, null,rec_cme.cert_prd_enrollment_id);
4009: end if;
4010: hr_utility.set_location('Leaving :'||l_proc,10);
4011:
4012: return l_return_play_btn;
4013:
4014: EXCEPTION

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

4012: return l_return_play_btn;
4013:
4014: EXCEPTION
4015: WHEN others THEN
4016: hr_utility.set_location('Leaving :'||l_proc,15);
4017:
4018: RETURN null;
4019:
4020: End get_cme_play_button;

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

4039: l_online_event_id ota_events.event_id%type;
4040: l_online_evt_count number;
4041:
4042: BEGIN
4043: hr_utility.set_location('Entering :'||l_proc,5);
4044:
4045: --check for mult online evts and throw null if so
4046: l_online_evt_count := get_cme_onl_evt_count(p_user_id, p_user_type, p_cert_mbr_enrollment_id);
4047:

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

4054: open csr_toolbar_flag(l_online_event_id);
4055: fetch csr_toolbar_flag into l_player_toolbar_flag;
4056: close csr_toolbar_flag;
4057:
4058: hr_utility.set_location('Leaving :'||l_proc,10);
4059:
4060: return l_player_toolbar_flag;
4061:
4062: EXCEPTION

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

4060: return l_player_toolbar_flag;
4061:
4062: EXCEPTION
4063: WHEN others THEN
4064: hr_utility.set_location('Leaving :'||l_proc,15);
4065:
4066: RETURN null;
4067:
4068: End get_cme_player_toolbar_flag;

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

4153: rec_prf_ord csr_prf_ord%rowtype;
4154: rec_get_act csr_get_act%rowtype;
4155:
4156: BEGIN
4157: hr_utility.set_location('Entering :'||l_proc,5);
4158:
4159: open csr_cme;
4160: fetch csr_cme into l_cert_prd_enrollment_id;
4161: close csr_cme;

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

4210: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
4211: End If;
4212: End If;
4213:
4214: hr_utility.set_location('Leaving :'||l_proc,10);
4215:
4216: return l_status_name;
4217:
4218: EXCEPTION

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

4216: return l_status_name;
4217:
4218: EXCEPTION
4219: WHEN others THEN
4220: hr_utility.set_location('Leaving :'||l_proc,15);
4221:
4222: RETURN null;
4223:
4224: End get_cert_lo_status;

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

4316: l_online_event_id ota_events.event_id%type;
4317: l_online_event_count number := 0;
4318:
4319: BEGIN
4320: hr_utility.set_location('Entering :'||l_proc,5);
4321:
4322:
4323: open csr_cme_info;
4324: fetch csr_cme_info into rec_cme_info;

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

4327: OPEN csr_cert_enrl(rec_cme_info.cert_prd_enrollment_id);
4328: FETCH csr_cert_enrl into l_person_id, l_contact_id, l_cert_period_start_date, l_cert_period_end_date;
4329: CLOSE csr_cert_enrl;
4330:
4331: hr_utility.set_location(' Step:'||l_proc,10);
4332:
4333: FOR rec IN get_enrl_status_on_update(rec_cme_info.object_id,
4334: l_cert_period_start_date,
4335: l_cert_period_end_date,

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

4345:
4346:
4347: END LOOP;
4348:
4349: hr_utility.set_location('Leaving :'||l_proc,10);
4350:
4351: return '' || l_online_event_count;
4352:
4353: EXCEPTION

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

4351: return '' || l_online_event_count;
4352:
4353: EXCEPTION
4354: WHEN others THEN
4355: hr_utility.set_location('Leaving :'||l_proc,15);
4356:
4357: RETURN null;
4358:
4359: End get_cme_onl_evt_count;

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

4486: l_online_event_id ota_events.event_id%type;
4487: l_online_evt_count number;
4488:
4489: BEGIN
4490: hr_utility.set_location('Entering :'||l_proc,5);
4491:
4492: --check for mult online evts and throw null if so
4493: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
4494:

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

4499: open csr_lme_info;
4500: fetch csr_lme_info into rec_lme_info;
4501: close csr_lme_info;
4502:
4503: hr_utility.set_location(' Step:'||l_proc,10);
4504:
4505: FOR rec IN get_enrl_status(rec_lme_info.activity_version_id,
4506: rec_lme_info.person_id,
4507: rec_lme_info.contact_id)

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

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

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

4520: return l_online_event_id;
4521:
4522: EXCEPTION
4523: WHEN others THEN
4524: hr_utility.set_location('Leaving :'||l_proc,15);
4525:
4526: RETURN null;
4527:
4528: End get_lme_online_event_id;

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

4555: l_return_play_btn VARCHAR2(30) := 'DISABLE_NOT_ENROLLED';
4556: l_online_evt_count number;
4557:
4558: BEGIN
4559: hr_utility.set_location('Entering :'||l_proc,5);
4560:
4561: --check for mult online evts and throw null if so
4562: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
4563:

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

4575: l_return_play_btn := GET_PLAY_BUTTON(p_user_id,p_user_type, p_is_manager, rec.EVENT_ID, rec.EVENT_TYPE
4576: ,rec.SYNCHRONOUS_FLAG, rec.ONLINE_FLAG
4577: ,rec.COURSE_START_DATE ,rec.COURSE_END_DATE);
4578: end if;
4579: hr_utility.set_location('Leaving :'||l_proc,10);
4580:
4581: return l_return_play_btn;
4582:
4583: EXCEPTION

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

4581: return l_return_play_btn;
4582:
4583: EXCEPTION
4584: WHEN others THEN
4585: hr_utility.set_location('Leaving :'||l_proc,15);
4586:
4587: RETURN null;
4588:
4589: End get_lme_play_button;

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

4606: l_online_event_id ota_events.event_id%type;
4607: l_online_evt_count number;
4608:
4609: BEGIN
4610: hr_utility.set_location('Entering :'||l_proc,5);
4611:
4612: --check for mult online evts and throw null if so
4613: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
4614:

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

4621: open csr_toolbar_flag(l_online_event_id);
4622: fetch csr_toolbar_flag into l_player_toolbar_flag;
4623: close csr_toolbar_flag;
4624:
4625: hr_utility.set_location('Leaving :'||l_proc,10);
4626:
4627: return l_player_toolbar_flag;
4628:
4629: EXCEPTION

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

4627: return l_player_toolbar_flag;
4628:
4629: EXCEPTION
4630: WHEN others THEN
4631: hr_utility.set_location('Leaving :'||l_proc,15);
4632:
4633: RETURN null;
4634:
4635: End get_lme_player_toolbar_flag;

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

4700:
4701: l_return_lo_status VARCHAR2(30);
4702: l_online_evt_count number;
4703: BEGIN
4704: hr_utility.set_location('Entering :'||l_proc,5);
4705:
4706: --check for mult online evts and throw null if so
4707: l_online_evt_count := get_lme_onl_evt_count(p_lp_member_enrollment_id);
4708:

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

4736: close csr_event;
4737:
4738: l_status_name := get_enroll_lo_status(p_user_id, p_user_type, rec.event_id, null, null, 1);
4739:
4740: hr_utility.set_location('Leaving :'||l_proc,10);
4741:
4742: return l_status_name;
4743:
4744: EXCEPTION

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

4742: return l_status_name;
4743:
4744: EXCEPTION
4745: WHEN others THEN
4746: hr_utility.set_location('Leaving :'||l_proc,15);
4747:
4748: RETURN null;
4749:
4750: End get_lpe_lo_status;

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

4807: l_online_event_count number := 0;
4808: l_online_evt_count number;
4809:
4810: BEGIN
4811: hr_utility.set_location('Entering :'||l_proc,5);
4812:
4813: open csr_lme_info;
4814: fetch csr_lme_info into rec_lme_info;
4815: close csr_lme_info;

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

4813: open csr_lme_info;
4814: fetch csr_lme_info into rec_lme_info;
4815: close csr_lme_info;
4816:
4817: hr_utility.set_location(' Step:'||l_proc,10);
4818:
4819: FOR rec IN get_enrl_status(rec_lme_info.activity_version_id,
4820: rec_lme_info.person_id,
4821: rec_lme_info.contact_id)

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

4828: end if;
4829:
4830: END LOOP;
4831:
4832: hr_utility.set_location('Leaving :'||l_proc,10);
4833:
4834: return '' || l_online_event_count;
4835:
4836: EXCEPTION

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

4834: return '' || l_online_event_count;
4835:
4836: EXCEPTION
4837: WHEN others THEN
4838: hr_utility.set_location('Leaving :'||l_proc,15);
4839:
4840: RETURN null;
4841:
4842: End get_lme_onl_evt_count;

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

4887:
4888:
4889: begin
4890:
4891: hr_utility.set_location(' Step:'||l_proc,10);
4892:
4893: for rec_active_cert_prd in csr_active_cert_prd
4894: loop
4895: --populate OUT cert_prd_enrollment_ids params

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

4902: END IF;
4903: end loop;
4904:
4905: p_cert_prd_enrollment_ids := l_cert_prd_enrollment_ids;
4906: hr_utility.set_location(' Step:'||l_proc,30);
4907:
4908: EXCEPTION
4909: WHEN others THEN
4910: hr_utility.set_location('Leaving :'||l_proc,40);

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

4906: hr_utility.set_location(' Step:'||l_proc,30);
4907:
4908: EXCEPTION
4909: WHEN others THEN
4910: hr_utility.set_location('Leaving :'||l_proc,40);
4911: p_cert_prd_enrollment_ids := null;
4912: --MULTI MESSAGE SUPPORT
4913:
4914: end get_active_cert_prds;

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

4936: l_proc varchar2(72) := g_package||'LO_has_child_and_having_url';
4937: --
4938: BEGIN
4939: --
4940: hr_utility.set_location('Entering:'|| l_proc, 10);
4941: --
4942: OPEN csr_par_with_cld_no_url;
4943: FETCH csr_par_with_cld_no_url INTO l_learning_object_flag;
4944: IF csr_par_with_cld_no_url%found THEN

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

4943: FETCH csr_par_with_cld_no_url INTO l_learning_object_flag;
4944: IF csr_par_with_cld_no_url%found THEN
4945: --
4946: l_return := 'Y';
4947: hr_utility.set_location('returning Y:'|| l_proc, 10);
4948: END IF;
4949: --
4950: CLOSE csr_par_with_cld_no_url;
4951: --

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

4948: END IF;
4949: --
4950: CLOSE csr_par_with_cld_no_url;
4951: --
4952: hr_utility.set_location('Exiting:'|| l_proc, 20);
4953: --
4954: RETURN l_return;
4955: --
4956: End Lo_has_cld_and_no_strt_url;