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 FND_FILE

Line 39: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for all classes');

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
41: OPEN get_class_name(p_event_id);
42: FETCH get_class_name into l_event_title;
43: CLOSE get_class_name;

Line 44: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for Class -' || l_event_title);

40: ELSE
41: OPEN get_class_name(p_event_id);
42: FETCH get_class_name into l_event_title;
43: CLOSE get_class_name;
44: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for Class -' || l_event_title);
45: END IF;
46:
47: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
48: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));

Line 47: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);

43: CLOSE get_class_name;
44: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for Class -' || l_event_title);
45: END IF;
46:
47: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
48: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
49: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
50:
51: SELECT

Line 48: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));

44: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for Class -' || l_event_title);
45: END IF;
46:
47: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
48: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
49: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
50:
51: SELECT
52: oea.MANDATORY_ENROLLMENT_PREREQ enr_prereq_type,

Line 49: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');

45: END IF;
46:
47: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
48: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
49: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
50:
51: SELECT
52: oea.MANDATORY_ENROLLMENT_PREREQ enr_prereq_type,
53: oea.EVENT_ID event_id,

Line 113: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'End time is - '||TO_CHAR(SYSTIMESTAMP));

109:
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:

Line 207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - '|| l_person_name);

203: OPEN csr_get_person_name(p_person_id);
204: FETCH csr_get_person_name INTO l_person_name;
205: CLOSE csr_get_person_name;
206:
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);

Line 208: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner has duplicate assignments.Error creating enrollment INTO class -' || p_event_id);

204: FETCH csr_get_person_name INTO l_person_name;
205: CLOSE csr_get_person_name;
206:
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;

Line 209: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');

205: CLOSE csr_get_person_name;
206:
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;

Line 479: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);

475: END LOOP;--END FOR learner IN csr_get_learners
476: ELSE
477: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
478: usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
479: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
480: sql_stmnt :='SELECT * FROM(
481: SELECT
482: ppf.person_id person_id
483: , pjt.job_id job_id

Line 561: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

557:
558:
559:
560: --Write the error messages to log
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
563: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
564: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

Line 562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');

558:
559:
560: --Write the error messages to log
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
563: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
564: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
566: FOR unsuccessful_learner IN unprocessed_enrollments LOOP

Line 563: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

559:
560: --Write the error messages to log
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
563: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
564: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
566: FOR unsuccessful_learner IN unprocessed_enrollments LOOP
567: OPEN csr_get_person_name(unsuccessful_learner.person_id);

Line 564: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');

560: --Write the error messages to log
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
563: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
564: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
566: FOR unsuccessful_learner IN unprocessed_enrollments LOOP
567: OPEN csr_get_person_name(unsuccessful_learner.person_id);
568: FETCH csr_get_person_name INTO l_person_name;

Line 565: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

561: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
563: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
564: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
566: FOR unsuccessful_learner IN unprocessed_enrollments LOOP
567: OPEN csr_get_person_name(unsuccessful_learner.person_id);
568: FETCH csr_get_person_name INTO l_person_name;
569: CLOSE csr_get_person_name;

Line 573: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

569: CLOSE csr_get_person_name;
570: IF unsuccessful_learner.create_enrollment = 'N' THEN
571: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
572: --The learner has NOT completed the course perquisites FOR the event
573: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
574: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
575: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
576: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
577: END IF;

Line 574: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);

570: IF unsuccessful_learner.create_enrollment = 'N' THEN
571: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
572: --The learner has NOT completed the course perquisites FOR the event
573: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
574: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
575: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
576: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
577: END IF;
578: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN

Line 575: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/

571: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
572: --The learner has NOT completed the course perquisites FOR the event
573: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
574: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
575: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
576: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
577: END IF;
578: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
579: --The learner has NOT completed the competence perquisites FOR the event

Line 576: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');

572: --The learner has NOT completed the course perquisites FOR the event
573: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
574: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
575: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
576: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
577: END IF;
578: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
579: --The learner has NOT completed the competence perquisites FOR the event
580: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

Line 580: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

576: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
577: END IF;
578: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
579: --The learner has NOT completed the competence perquisites FOR the event
580: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
583: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
584: END IF;

Line 581: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);

577: END IF;
578: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
579: --The learner has NOT completed the competence perquisites FOR the event
580: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
583: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
584: END IF;
585: END IF;

Line 582: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/

578: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
579: --The learner has NOT completed the competence perquisites FOR the event
580: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
583: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
584: END IF;
585: END IF;
586:

Line 583: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');

579: --The learner has NOT completed the competence perquisites FOR the event
580: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
583: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
584: END IF;
585: END IF;
586:
587: IF unsuccessful_learner.error_message IS NOT NULL THEN

Line 588: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

584: END IF;
585: END IF;
586:
587: IF unsuccessful_learner.error_message IS NOT NULL THEN
588: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
591: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
592: END IF;

Line 589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);

585: END IF;
586:
587: IF unsuccessful_learner.error_message IS NOT NULL THEN
588: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
591: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
592: END IF;
593:

Line 590: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/

586:
587: IF unsuccessful_learner.error_message IS NOT NULL THEN
588: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
591: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
592: END IF;
593:
594:

Line 591: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);

587: IF unsuccessful_learner.error_message IS NOT NULL THEN
588: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
591: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
592: END IF;
593:
594:
595: END LOOP;

Line 665: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR-No requests found FOR concurrent program- '||p_conc_reqId);

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
664: -- Raise error that no request found
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR-No requests found FOR concurrent program- '||p_conc_reqId);
666: CLOSE get_all_mandatory_enr_requests;
667: RETURN;
668: ELSE
669: CLOSE get_all_mandatory_enr_requests;

Line 670: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

666: CLOSE get_all_mandatory_enr_requests;
667: RETURN;
668: ELSE
669: CLOSE get_all_mandatory_enr_requests;
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
671: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
672: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
674: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

Line 671: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');

667: RETURN;
668: ELSE
669: CLOSE get_all_mandatory_enr_requests;
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
671: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
672: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
674: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
675:

Line 672: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

668: ELSE
669: CLOSE get_all_mandatory_enr_requests;
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
671: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
672: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
674: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
675:
676: FOR l_req_member_rec IN csr_get_request_members(p_conc_reqId) LOOP

Line 673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');

669: CLOSE get_all_mandatory_enr_requests;
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
671: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
672: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
674: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
675:
676: FOR l_req_member_rec IN csr_get_request_members(p_conc_reqId) LOOP
677:

Line 674: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

670: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
671: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
672: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
674: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
675:
676: FOR l_req_member_rec IN csr_get_request_members(p_conc_reqId) LOOP
677:
678: l_booking_id := NULL;

Line 684: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

680:
681: OPEN csr_get_person_name(l_req_member_rec.person_id);
682: FETCH csr_get_person_name INTO l_person_name;
683: CLOSE csr_get_person_name;
684: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
685:
686:
687: OPEN csr_get_cost_center_info(l_req_member_rec.assignment_id);
688: FETCH csr_get_cost_center_info INTO l_cost_center_info;

Line 720: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);

716: FETCH get_class_name into l_class_name;
717: CLOSE get_class_name;
718:
719: IF l_booking_id IS NOT NULL THEN
720: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
721: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
722: UPDATE ota_mandatory_enr_req_members
723: SET error_message = NULL
724: WHERE person_id = l_req_member_rec.person_id

Line 721: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');

717: CLOSE get_class_name;
718:
719: IF l_booking_id IS NOT NULL THEN
720: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
721: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
722: UPDATE ota_mandatory_enr_req_members
723: SET error_message = NULL
724: WHERE person_id = l_req_member_rec.person_id
725: AND assignment_id = l_req_member_rec.assignment_id

Line 730: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);

726: AND event_id = l_req_member_rec.event_id
727: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;
728: ELSE
729: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
730: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
731: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
732: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
733:
734: UPDATE ota_mandatory_enr_req_members

Line 731: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);

727: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;
728: ELSE
729: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
730: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
731: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
732: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
733:
734: UPDATE ota_mandatory_enr_req_members
735: SET error_message = l_error_message

Line 732: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');

728: ELSE
729: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
730: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
731: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
732: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
733:
734: UPDATE ota_mandatory_enr_req_members
735: SET error_message = l_error_message
736: WHERE person_id = l_req_member_rec.person_id

Line 805: --fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);

801: OPEN csr_get_user_name(p_person_id);
802: FETCH csr_get_user_name INTO l_user_name;
803: CLOSE csr_get_user_name;
804:
805: --fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);
806:
807: IF l_person_full_name IS NOT NULL then
808: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'EVENT_OWNER',l_user_name);
809: END IF;