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:

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

144: l_mandatory_enrollment_flag varchar2(1) := NULL;
145: l_proc varchar2(72) := g_package||'learner_can_enroll_in_class';
146: BEGIN
147:
148: hr_utility.set_location(' Entering:'||l_proc, 5);
149:
150: OPEN get_learner_class_enr_status;
151: FETCH get_learner_class_enr_status INTO l_status_code, l_status, l_status_id, l_status_number, l_mandatory_enrollment_flag ;
152: CLOSE get_learner_class_enr_status;

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

151: FETCH get_learner_class_enr_status INTO l_status_code, l_status, l_status_id, l_status_number, l_mandatory_enrollment_flag ;
152: CLOSE get_learner_class_enr_status;
153:
154: IF((l_status_code = 'C' AND l_mandatory_enrollment_flag = 'N') OR (l_status_code IS NULL))THEN
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: RETURN 'Y';
157: ELSE
158: hr_utility.set_location(' Leaving:'||l_proc, 15);
159: RETURN 'N';

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

154: IF((l_status_code = 'C' AND l_mandatory_enrollment_flag = 'N') OR (l_status_code IS NULL))THEN
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: RETURN 'Y';
157: ELSE
158: hr_utility.set_location(' Leaving:'||l_proc, 15);
159: RETURN 'N';
160: END IF;
161:
162:

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

184: l_proc varchar2(72) := g_package||'learner_is_notSelected';
185:
186: BEGIN
187:
188: hr_utility.set_location(' Entering:'||l_proc, 5);
189:
190: OPEN lrnr_already_selected;
191: FETCH lrnr_already_selected INTO l_lrnr_assignment_id;
192:

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

195: RETURN TRUE;
196: ELSE
197: IF p_assignment_id = l_lrnr_assignment_id THEN
198: CLOSE lrnr_already_selected;
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: RETURN false;
201: ELSE
202: --Log an error mentioning learner has duplicate assignments
203: OPEN csr_get_person_name(p_person_id);

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

207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - '|| l_person_name);
208: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner has duplicate assignments.Error creating enrollment INTO class -' || p_event_id);
209: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
210: CLOSE lrnr_already_selected;
211: hr_utility.set_location(' Leaving:'||l_proc, 15);
212: RETURN false;
213: END IF;
214:
215: END IF;

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

250: l_assignment_id per_all_assignments_f.assignment_id%type;
251: l_proc varchar2(72) := g_package||'learner_belongs_to_child_org';
252: BEGIN
253:
254: hr_utility.set_location(' Entering:'||l_proc, 5);
255:
256: OPEN csr_lrnr_belongs_to_org;
257: FETCH csr_lrnr_belongs_to_org INTO l_assignment_id;
258: CLOSE csr_lrnr_belongs_to_org;

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

257: FETCH csr_lrnr_belongs_to_org INTO l_assignment_id;
258: CLOSE csr_lrnr_belongs_to_org;
259:
260: IF l_assignment_id IS NOT NULL THEN
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: RETURN 'Y';
263: ELSE
264: hr_utility.set_location(' Leaving:'||l_proc, 15);
265: RETURN 'N';

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

260: IF l_assignment_id IS NOT NULL THEN
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: RETURN 'Y';
263: ELSE
264: hr_utility.set_location(' Leaving:'||l_proc, 15);
265: RETURN 'N';
266: END IF;
267:
268: END learner_belongs_to_child_org;

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

312: l_proc varchar2(72) := g_package||'create_request_member_record';
313:
314: BEGIN
315:
316: hr_utility.set_location(' Entering:'||l_proc, 5);
317: --As learners are selected based on primary or secondary assignment criteria,but enrollments must be created
318: -- based on primary assignment we need to retreive the primary assignment before validations.
319: OPEN csr_get_assignment_info(l_person_id);
320: FETCH csr_get_assignment_info INTO l_assignment_info;

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

355: l_create_enrollment,req_event_id,l_assignment_info.organization_id,l_assignment_info.business_group_id);
356: l_numberof_records_processed := l_numberof_records_processed + 1;
357: END IF;--learner_is_notSelected
358:
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360:
361: end create_request_member_record;
362:
363:

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

464: usergroup_whereclause varchar2(4000);
465: l_proc varchar2(72) := g_package||'process_mandatory_enr_requests';
466: BEGIN
467:
468: hr_utility.set_location(' Entering:'||l_proc, 5);
469:
470: FOR request IN get_all_mandatory_enr_requests(p_conc_request_id) LOOP
471: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));
472: IF request.usergroup_id IS NULL THEN

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

593:
594:
595: END LOOP;
596:
597: hr_utility.set_location(' Leaving:'||l_proc, 10);
598:
599:
600: END process_mandatory_enr_requests;
601:

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

655: l_proc varchar2(72) := g_package||'create_enrollments';
656:
657: BEGIN
658:
659: hr_utility.set_location(' Entering:'||l_proc, 5);
660:
661: OPEN get_all_mandatory_enr_requests(p_conc_reqId);
662: FETCH get_all_mandatory_enr_requests INTO l_request_rec;
663: IF get_all_mandatory_enr_requests%NOTFOUND THEN

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

742: -- Start workflow AND send a notification to the requestor
743: notify_class_owners(p_conc_reqId);
744: END IF;
745:
746: hr_utility.set_location(' Leaving:'||l_proc, 10);
747:
748: END create_enrollments;
749:
750:

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

779: CURSOR csr_get_person_name(p_person_id IN number) IS
780: SELECT ppf.full_name FROM per_all_people_f ppf WHERE person_id = p_person_id;
781:
782: BEGIN
783: hr_utility.set_location('Entering:'||l_proc, 5);
784:
785: -- Get the next item key from the sequence
786: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
787:

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

810: END IF;
811:
812: -- Get and set owner role
813:
814: hr_utility.set_location('Before Getting Owner'||l_proc, 10);
815:
816: WF_DIRECTORY.GetRoleName(p_orig_system =>'PER',
817: p_orig_system_id => p_person_id,
818: p_name =>l_role_name,

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

822: WF_ENGINE.SetItemOwner(itemtype => l_item_type,
823: itemkey =>l_item_key,
824: owner =>l_role_name);
825:
826: hr_utility.set_location('After Setting Owner'||l_proc, 10);
827:
828:
829: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
830:

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

827:
828:
829: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
830:
831: hr_utility.set_location('leaving:'||l_proc, 20);
832:
833: EXCEPTION
834: WHEN OTHERS THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

865:
866: l_proc varchar2(72) := g_package||'notify_class_owners';
867:
868: BEGIN
869: hr_utility.set_location('Entering:'||l_proc, 5);
870: for owner in csr_get_all_event_owners loop
871:
872: OPEN csr_get_error_learners(owner.event_id);
873: FETCH csr_get_error_learners INTO l_error_learners;