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

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

32:
33: BEGIN
34:
35: l_conc_request_id := FND_GLOBAL.conc_request_id;
36: hr_utility.set_location(' Entering:'||l_proc, 5);
37:
38: if p_event_id is NULL then
39: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for all classes');
40: ELSE

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

110: process_mandatory_enr_requests(l_conc_request_id);
111:
112:
113: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'End time is - '||TO_CHAR(SYSTIMESTAMP));
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115:
116: END process_mandatory_event_assoc;
117:
118: PROCEDURE process_mand_event_assoc_multi( ERRBUF OUT NOCOPY VARCHAR2,

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

157:
158: BEGIN
159:
160: l_conc_request_id := FND_GLOBAL.conc_request_id;
161: hr_utility.set_location(' Entering:'||l_proc, 5);
162: if p_chunk_size is NULL then
163: l_chunk_size := 1000;
164: end if;
165: if p_thread_count is NULL then

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

306: l_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'OTA'
307: ,program => 'OTA_PURGE_MAND_ENROLL_REC');
308: end if;
309: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'End time is - '||TO_CHAR(SYSTIMESTAMP));
310: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: Exception
312: when OTA_INCOMP_MAND_MULTI_EXIST then
313: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Another Process Mandatory Enrollment Multi threaded concurrent program is in progress');
314: END process_mand_event_assoc_multi;

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

342: l_proc varchar2(72) := g_package||'learner_can_enroll_in_class';
343: l_booking_id ota_delegate_bookings.booking_id%type;
344: BEGIN
345:
346: hr_utility.set_location(' Entering:'||l_proc, 5);
347:
348: OPEN check_enr_exists;
349: FETCH check_enr_exists INTO l_booking_id;
350: IF check_enr_exists%NOTFOUND THEN---if enrollment doesnot exist

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

359: FETCH get_learner_class_enr_status INTO l_status_code, l_status_id, l_status_number, l_mandatory_enrollment_flag ;
360: CLOSE get_learner_class_enr_status;
361:
362: IF((l_status_code = 'C' AND l_mandatory_enrollment_flag = 'N') OR (l_status_code IS NULL))THEN
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: RETURN 'Y';
365: ELSE
366: hr_utility.set_location(' Leaving:'||l_proc, 15);
367: RETURN 'N';

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

362: IF((l_status_code = 'C' AND l_mandatory_enrollment_flag = 'N') OR (l_status_code IS NULL))THEN
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: RETURN 'Y';
365: ELSE
366: hr_utility.set_location(' Leaving:'||l_proc, 15);
367: RETURN 'N';
368: END IF;
369:
370: END IF;

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

392: l_proc varchar2(72) := g_package||'learner_is_notSelected_inClass';
393:
394: BEGIN
395:
396: hr_utility.set_location(' Entering:'||l_proc, 5);
397:
398: OPEN lrnr_already_selected;
399: FETCH lrnr_already_selected INTO l_lrnr_assignment_id;
400:

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

403: RETURN TRUE;
404: ELSE
405: IF p_assignment_id = l_lrnr_assignment_id THEN
406: CLOSE lrnr_already_selected;
407: hr_utility.set_location(' Leaving:'||l_proc, 10);
408: RETURN false;
409: ELSE
410: --Log an error mentioning learner has duplicate assignments
411: OPEN csr_get_person_name(p_person_id);

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

415: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - '|| l_person_name);
416: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner has duplicate assignments.Error creating enrollment INTO class -' || p_event_id);
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
418: CLOSE lrnr_already_selected;
419: hr_utility.set_location(' Leaving:'||l_proc, 15);
420: RETURN false;
421: END IF;
422:
423: END IF;

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

443: l_proc varchar2(72) := g_package||'lrn_is_notSelected_inClass_mul';
444:
445: BEGIN
446:
447: hr_utility.set_location(' Entering:'||l_proc, 5);
448:
449: OPEN lrnr_already_selected;
450: FETCH lrnr_already_selected INTO l_lrnr_assignment_id;
451:

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

454: RETURN TRUE;
455: ELSE
456: IF p_assignment_id = l_lrnr_assignment_id THEN
457: CLOSE lrnr_already_selected;
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: RETURN false;
460: ELSE
461: --Log an error mentioning learner has duplicate assignments
462: OPEN csr_get_person_name(p_person_id);

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

466: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - '|| l_person_name);
467: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner has duplicate assignments.Error creating enrollment INTO class -' || p_event_id);
468: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
469: CLOSE lrnr_already_selected;
470: hr_utility.set_location(' Leaving:'||l_proc, 15);
471: RETURN false;
472: END IF;
473:
474: END IF;

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

496: l_proc varchar2(72) := g_package||'learner_is_notSelected_inCert';
497:
498: BEGIN
499:
500: hr_utility.set_location(' Entering:'||l_proc, 5);
501:
502: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered learner_is_notSelected_inCert');
503:
504: OPEN lrnr_already_selected;

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

510: RETURN TRUE;
511: ELSE
512: IF p_assignment_id = l_lrnr_assignment_id THEN
513: CLOSE lrnr_already_selected;
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Return false');
516: RETURN false;
517: ELSE
518: --Log an error mentioning learner has duplicate assignments

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

523: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - '|| l_person_name);
524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner has duplicate assignments.Error creating enrollment INTO cert -' || p_certification_id);
525: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
526: CLOSE lrnr_already_selected;
527: hr_utility.set_location(' Leaving:'||l_proc, 15);
528: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return false as lrnr has multiple assignments');
529: RETURN false;
530: END IF;
531:

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

590: l_assignment_id per_all_assignments_f.assignment_id%type;
591: l_proc varchar2(72) := g_package||'learner_belongs_to_child_org';
592: BEGIN
593:
594: hr_utility.set_location(' Entering:'||l_proc, 5);
595:
596: OPEN csr_lrnr_belongs_to_org;
597: FETCH csr_lrnr_belongs_to_org INTO l_assignment_id;
598: CLOSE csr_lrnr_belongs_to_org;

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

597: FETCH csr_lrnr_belongs_to_org INTO l_assignment_id;
598: CLOSE csr_lrnr_belongs_to_org;
599:
600: IF l_assignment_id IS NOT NULL THEN
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: RETURN 'Y';
603: ELSE
604: hr_utility.set_location(' Leaving:'||l_proc, 15);
605: RETURN 'N';

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

600: IF l_assignment_id IS NOT NULL THEN
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: RETURN 'Y';
603: ELSE
604: hr_utility.set_location(' Leaving:'||l_proc, 15);
605: RETURN 'N';
606: END IF;
607:
608: END learner_belongs_to_child_org;

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

652: l_proc varchar2(72) := g_package||'create_request_member_record';
653:
654: BEGIN
655:
656: hr_utility.set_location(' Entering:'||l_proc, 5);
657: --As learners are selected based on primary or secondary assignment criteria,but enrollments must be created
658: -- based on primary assignment we need to retreive the primary assignment before validations.
659: OPEN csr_get_assignment_info(l_person_id);
660: FETCH csr_get_assignment_info INTO l_assignment_info;

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

696: l_completed_comp_prereq, l_create_enrollment,req_event_id,l_assignment_info.organization_id,l_assignment_info.business_group_id);
697: l_numberof_records_processed := l_numberof_records_processed + 1;
698: END IF;--learner_is_notSelected_inClass
699:
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701:
702: end create_request_member_record;
703:
704: PROCEDURE create_request_member_record(l_person_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.person_id%type,

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

749: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
750:
751: BEGIN
752:
753: hr_utility.set_location(' Entering:'||l_proc, 5);
754: --As learners are selected based on primary or secondary assignment criteria,but enrollments must be created
755: -- based on primary assignment we need to retreive the primary assignment before validations.
756: OPEN csr_get_assignment_info(l_person_id);
757: FETCH csr_get_assignment_info INTO l_assignment_info;

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

799: l_person_action_id,'U');
800: l_numberof_records_processed := l_numberof_records_processed + 1;
801: END IF;--lrn_is_notSelected_inClass_mul
802: p_person_action_id := l_person_action_id;
803: hr_utility.set_location(' Leaving:'||l_proc, 10);
804:
805: end create_request_member_record;
806:
807:

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

968: ignore INTEGER;
969: l_proc varchar2(72) := g_package||'process_mandatory_enr_requests';
970: BEGIN
971:
972: hr_utility.set_location(' Entering:'||l_proc, 5);
973:
974: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
975: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
976: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

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

1179:
1180:
1181: END LOOP;
1182:
1183: hr_utility.set_location(' Leaving:'||l_proc, 10);
1184:
1185:
1186: END process_mandatory_enr_requests;
1187:

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

1363: l_request_id number;
1364: OTA_NO_PERSON_TO_PROCESS exception;
1365: BEGIN
1366:
1367: hr_utility.set_location(' Entering:'||l_proc, 5);
1368:
1369: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
1370: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1371: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

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

1708:
1709:
1710: create_enrollments_multi(p_conc_request_id);
1711:
1712: hr_utility.set_location(' Leaving:'||l_proc, 10);
1713:
1714: Exception
1715: when OTA_NO_PERSON_TO_PROCESS then
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Person record to process');

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

1771: l_proc varchar2(72) := g_package||'create_enrollments';
1772:
1773: BEGIN
1774:
1775: hr_utility.set_location(' Entering:'||l_proc, 5);
1776:
1777: OPEN get_all_mandatory_enr_requests(p_conc_reqId);
1778: FETCH get_all_mandatory_enr_requests INTO l_request_rec;
1779: IF get_all_mandatory_enr_requests%NOTFOUND THEN

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

1858: -- Start workflow AND send a notification to the requestor
1859: notify_class_owners(p_conc_reqId);
1860: END IF;
1861:
1862: hr_utility.set_location(' Leaving:'||l_proc, 10);
1863:
1864: END create_enrollments;
1865:
1866:

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

1931: l_proc varchar2(72) := g_package||'create_enrollments_multi';
1932:
1933: BEGIN
1934:
1935: hr_utility.set_location(' Entering:'||l_proc, 5);
1936:
1937: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1938: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

2032:
2033: END LOOP;
2034:
2035: commit;
2036: hr_utility.set_location(' Leaving:'||l_proc, 10);
2037: END LOOP;
2038:
2039: END create_enrollments_multi;
2040:

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

2068: CURSOR csr_get_person_name(p_person_id IN number) IS
2069: SELECT ppf.full_name FROM per_all_people_f ppf WHERE person_id = p_person_id;
2070:
2071: BEGIN
2072: hr_utility.set_location('Entering:'||l_proc, 5);
2073:
2074: -- Get the next item key from the sequence
2075: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
2076:

Line 2103: hr_utility.set_location('Before Getting Owner'||l_proc, 10);

2099: END IF;
2100:
2101: -- Get and set owner role
2102:
2103: hr_utility.set_location('Before Getting Owner'||l_proc, 10);
2104:
2105: WF_DIRECTORY.GetRoleName(p_orig_system =>'PER',
2106: p_orig_system_id => p_person_id,
2107: p_name =>l_role_name,

Line 2115: hr_utility.set_location('After Setting Owner'||l_proc, 10);

2111: WF_ENGINE.SetItemOwner(itemtype => l_item_type,
2112: itemkey =>l_item_key,
2113: owner =>l_role_name);
2114:
2115: hr_utility.set_location('After Setting Owner'||l_proc, 10);
2116:
2117:
2118: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
2119:

Line 2120: hr_utility.set_location('leaving:'||l_proc, 20);

2116:
2117:
2118: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
2119:
2120: hr_utility.set_location('leaving:'||l_proc, 20);
2121:
2122: EXCEPTION
2123: WHEN OTHERS THEN
2124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2154: l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';
2155: l_proc varchar2(72) := g_package||'notify_class_owners';
2156:
2157: BEGIN
2158: hr_utility.set_location('Entering:'||l_proc, 5);
2159: for owner in csr_get_all_event_owners loop
2160:
2161: OPEN csr_get_error_learners(owner.event_id);
2162: FETCH csr_get_error_learners INTO l_error_learners;

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

2200: l_process wf_activities.name%type :='OTA_BLK_MANDATORY_ENR_NTF_PRC';
2201: l_proc varchar2(72) := g_package||'notify_multi_class_owners';
2202:
2203: BEGIN
2204: hr_utility.set_location('Entering:'||l_proc, 5);
2205: for owner in csr_get_all_event_owners loop
2206:
2207: OPEN csr_get_error_learners(owner.event_id);
2208: FETCH csr_get_error_learners INTO l_error_learners;

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

2253:
2254: BEGIN
2255:
2256: l_conc_request_id := FND_GLOBAL.conc_request_id;
2257: hr_utility.set_location(' Entering:'||l_proc, 5);
2258: if p_chunk_size is NULL then
2259: l_chunk_size := 1000;
2260: end if;
2261: if p_thread_count is NULL then

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

2379: ,program => 'OTA_PURGE_MAND_ENROLL_REC');
2380: end if;
2381:
2382: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'End time is - '||TO_CHAR(SYSTIMESTAMP));
2383: hr_utility.set_location(' Leaving:'||l_proc, 10);
2384:
2385: END process_automatic_cert_subscr;
2386:
2387:

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

2534: l_request_id number;
2535: OTA_NO_PERSON_TO_PROCESS exception;
2536: BEGIN
2537:
2538: hr_utility.set_location(' Entering:'||l_proc, 5);
2539:
2540:
2541: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
2542: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

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

2934: --and create_enrollment IS set to 'N'
2935:
2936: create_cert_subscriptions(p_conc_request_id);
2937:
2938: hr_utility.set_location(' Leaving:'||l_proc, 10);
2939:
2940: Exception
2941: when OTA_NO_PERSON_TO_PROCESS then
2942: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Person record to process');

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

2969: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
2970: l_is_automatic_subscription ota_cert_enrollments.is_automatic_subscription%type;
2971: BEGIN
2972:
2973: hr_utility.set_location(' Entering:'||l_proc, 5);
2974: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered learner can enrol in cert ');
2975: l_cert_enr_id := 0;
2976:
2977: OPEN check_subscr_exists;

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

3057: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
3058:
3059: BEGIN
3060:
3061: hr_utility.set_location(' Entering:'||l_proc, 5);
3062:
3063: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside create_cert_req_member_record for person_id - ' || l_person_id);
3064: --As learners are selected based on primary or secondary assignment criteria,but enrollments must be created
3065: -- based on primary assignment we need to retreive the primary assignment before validations.

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

3081: l_numberof_records_processed := l_numberof_records_processed + 1;
3082: END IF;--learner_is_notSelected_inCert
3083: p_person_action_id := l_person_action_id;
3084:
3085: hr_utility.set_location(' Leaving:'||l_proc, 10);
3086:
3087: end create_cert_req_member_record;
3088:
3089:

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

3138: l_proc varchar2(72) := g_package||'create_cert_subscriptions';
3139:
3140: BEGIN
3141:
3142: hr_utility.set_location(' Entering:'||l_proc, 5);
3143: LOOP
3144: OPEN c_range_thread;
3145:
3146: FETCH c_range_thread

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

3233:
3234: END LOOP;
3235:
3236: commit;
3237: hr_utility.set_location(' Leaving:'||l_proc, 10);
3238: END LOOP;
3239: END create_cert_subscriptions;
3240:
3241:

Line 3255: hr_utility.set_location('> Fail in ' || p_proc, 999 );

3251: Begin
3252: If (p_rpt_flag ) then
3253: fnd_file.put_line(fnd_file.log,'<<>>');
3254: End if;
3255: hr_utility.set_location('> Fail in ' || p_proc, 999 );
3256: hr_utility.set_location('>> While ' || p_last_actn, 999);
3257: End rpt_error;
3258:
3259: --

Line 3256: hr_utility.set_location('>> While ' || p_last_actn, 999);

3252: If (p_rpt_flag ) then
3253: fnd_file.put_line(fnd_file.log,'<<>>');
3254: End if;
3255: hr_utility.set_location('> Fail in ' || p_proc, 999 );
3256: hr_utility.set_location('>> While ' || p_last_actn, 999);
3257: End rpt_error;
3258:
3259: --
3260: -- ============================================================================

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

3273: From fnd_concurrent_requests fnd
3274: Where fnd.phase_code <> 'C'
3275: And fnd.request_id = p_request_id;
3276: Begin
3277: hr_utility.set_location ('Entering '||l_proc,5);
3278: If g_num_processes <> 0 then
3279: l_actn := 'Checking Slaves.....';
3280: While l_no_slaves loop
3281: l_no_slaves := false;

Line 3297: hr_utility.set_location ('Leaving '||l_proc,5);

3293: dbms_lock.sleep(5);
3294: End if;
3295: End loop;
3296: End if;
3297: hr_utility.set_location ('Leaving '||l_proc,5);
3298: Exception
3299: when others then
3300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error:'||substr(SQLERRM,1,2000));
3301: rpt_error(p_proc =>l_proc,p_last_actn=>l_actn,p_rpt_flag=>p_rpt_flag);

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

3311: TYPE t_mand_rec IS TABLE OF mand_rec INDEX BY binary_integer;
3312: mand_enr_req_rec t_mand_rec;
3313: l_proc varchar2(80) := g_package||'.purge_mand_enroll_data';
3314: begin
3315: hr_utility.set_location ('Entering '||l_proc,5);
3316: dbms_lock.sleep(5);
3317: select omr.CONC_PROGRAM_REQUEST_ID, omr.MANDATORY_ENR_REQUEST_ID
3318: bulk collect into mand_enr_req_rec
3319: from OTA_MAND_MULTI_ENR_REQUESTS omr, fnd_concurrent_requests fcr

Line 3352: hr_utility.set_location ('Leaving '||l_proc,5);

3348:
3349: if sql%rowcount > 0 then
3350: commit;
3351: end if;
3352: hr_utility.set_location ('Leaving '||l_proc,5);
3353: end purge_mand_enroll_data;
3354:
3355: END ota_mandatory_enroll_util;