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 182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for all classes');

178:
179: close csr_check_mand_multi_running;
180:
181: if p_event_id is NULL then
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for all classes');
183: ELSE
184: OPEN get_class_name(p_event_id);
185: FETCH get_class_name into l_event_title;
186: CLOSE get_class_name;

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

183: ELSE
184: OPEN get_class_name(p_event_id);
185: FETCH get_class_name into l_event_title;
186: CLOSE get_class_name;
187: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for Class -' || l_event_title);
188: END IF;
189:
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
191: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));

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

186: CLOSE get_class_name;
187: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for Class -' || l_event_title);
188: END IF;
189:
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
191: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
193:
194: SELECT

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

187: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mandatory Enrollments are being processed for Class -' || l_event_title);
188: END IF;
189:
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
191: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
193:
194: SELECT
195: oea.MANDATORY_ENROLLMENT_PREREQ enr_prereq_type,

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

188: END IF;
189:
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
191: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
193:
194: SELECT
195: oea.MANDATORY_ENROLLMENT_PREREQ enr_prereq_type,
196: oea.EVENT_ID event_id,

Line 222: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_rec.event_id.COUNT:'||l_rec.event_id.COUNT);

218: AND nvl(p_event_id,-1)= decode(p_event_id,NULL,-1,evt.EVENT_ID)
219: AND evt.business_group_id = OTA_GENERAL.get_business_group_id
220: ORDER BY evt.event_id;
221:
222: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_rec.event_id.COUNT:'||l_rec.event_id.COUNT);
223:
224: FORALL i IN 1 .. l_rec.event_id.COUNT
225:
226: INSERT INTO OTA_MAND_MULTI_ENR_REQUESTS(

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

265: -- Start workflow AND send a notification to the requestor
266: if p_action_id is null then
267:
268: --Write the error messages to log
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
271: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

266: if p_action_id is null then
267:
268: --Write the error messages to log
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
271: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
274: FOR unsuccessful_learner IN unprocessed_multi_enrollments(l_conc_request_id) LOOP

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

267:
268: --Write the error messages to log
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
271: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
274: FOR unsuccessful_learner IN unprocessed_multi_enrollments(l_conc_request_id) LOOP
275: OPEN csr_get_person_name(unsuccessful_learner.person_id);

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

268: --Write the error messages to log
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
271: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
274: FOR unsuccessful_learner IN unprocessed_multi_enrollments(l_conc_request_id) LOOP
275: OPEN csr_get_person_name(unsuccessful_learner.person_id);
276: FETCH csr_get_person_name INTO l_person_name;

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

269: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
271: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
274: FOR unsuccessful_learner IN unprocessed_multi_enrollments(l_conc_request_id) LOOP
275: OPEN csr_get_person_name(unsuccessful_learner.person_id);
276: FETCH csr_get_person_name INTO l_person_name;
277: CLOSE csr_get_person_name;

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

277: CLOSE csr_get_person_name;
278: IF unsuccessful_learner.create_enrollment = 'N' THEN
279: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
280: --The learner has NOT completed the course perquisites FOR the event
281: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
282: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
283: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
284: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
285: END IF;

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

278: IF unsuccessful_learner.create_enrollment = 'N' THEN
279: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
280: --The learner has NOT completed the course perquisites FOR the event
281: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
282: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
283: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
284: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
285: END IF;
286: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN

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

279: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
280: --The learner has NOT completed the course perquisites FOR the event
281: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
282: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
283: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
284: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
285: END IF;
286: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
287: --The learner has NOT completed the competence perquisites FOR the event

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

280: --The learner has NOT completed the course perquisites FOR the event
281: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
282: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
283: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
284: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
285: END IF;
286: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
287: --The learner has NOT completed the competence perquisites FOR the event
288: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

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

284: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
285: END IF;
286: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
287: --The learner has NOT completed the competence perquisites FOR the event
288: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
289: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
290: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
291: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
292: END IF;

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

285: END IF;
286: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
287: --The learner has NOT completed the competence perquisites FOR the event
288: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
289: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
290: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
291: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
292: END IF;
293: END IF;

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

286: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
287: --The learner has NOT completed the competence perquisites FOR the event
288: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
289: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
290: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
291: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
292: END IF;
293: END IF;
294:

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

287: --The learner has NOT completed the competence perquisites FOR the event
288: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
289: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
290: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
291: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
292: END IF;
293: END IF;
294:
295: IF unsuccessful_learner.error_message IS NOT NULL THEN

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

292: END IF;
293: END IF;
294:
295: IF unsuccessful_learner.error_message IS NOT NULL THEN
296: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
297: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
299: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
300: END IF;

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

293: END IF;
294:
295: IF unsuccessful_learner.error_message IS NOT NULL THEN
296: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
297: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
299: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
300: END IF;
301:

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

294:
295: IF unsuccessful_learner.error_message IS NOT NULL THEN
296: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
297: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
299: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
300: END IF;
301:
302:

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

295: IF unsuccessful_learner.error_message IS NOT NULL THEN
296: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
297: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
299: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
300: END IF;
301:
302:
303: END LOOP;

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

305: notify_multi_class_owners(l_conc_request_id);
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');

Line 313: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Another Process Mandatory Enrollment Multi threaded concurrent program is in progress');

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;
315:
316: FUNCTION learner_can_enroll_in_class(p_event_id IN NUMBER
317: ,p_learner_id IN NUMBER)

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

411: OPEN csr_get_person_name(p_person_id);
412: FETCH csr_get_person_name INTO l_person_name;
413: CLOSE csr_get_person_name;
414:
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);

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

412: FETCH csr_get_person_name INTO l_person_name;
413: CLOSE csr_get_person_name;
414:
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;

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

413: CLOSE csr_get_person_name;
414:
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;

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

462: OPEN csr_get_person_name(p_person_id);
463: FETCH csr_get_person_name INTO l_person_name;
464: CLOSE csr_get_person_name;
465:
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);

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

463: FETCH csr_get_person_name INTO l_person_name;
464: CLOSE csr_get_person_name;
465:
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;

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

464: CLOSE csr_get_person_name;
465:
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;

Line 502: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered learner_is_notSelected_inCert');

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;
505: FETCH lrnr_already_selected INTO l_lrnr_assignment_id;
506:

Line 509: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Return true');

505: FETCH lrnr_already_selected INTO l_lrnr_assignment_id;
506:
507: IF lrnr_already_selected%NOTFOUND THEN
508: CLOSE lrnr_already_selected;
509: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Return true');
510: RETURN TRUE;
511: ELSE
512: IF p_assignment_id = l_lrnr_assignment_id THEN
513: CLOSE lrnr_already_selected;

Line 515: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Return false');

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
519: OPEN csr_get_person_name(p_person_id);

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

519: OPEN csr_get_person_name(p_person_id);
520: FETCH csr_get_person_name INTO l_person_name;
521: CLOSE csr_get_person_name;
522:
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);

Line 524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner has duplicate assignments.Error creating enrollment INTO cert -' || p_certification_id);

520: FETCH csr_get_person_name INTO l_person_name;
521: CLOSE csr_get_person_name;
522:
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');

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

521: CLOSE csr_get_person_name;
522:
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;

Line 528: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return false as lrnr has multiple assignments');

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:
532: END IF;

Line 982: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);

978: IF l_allow_future_end_prof_val is null then
979: l_allow_future_end_prof_val := 'N';
980: END IF;
981:
982: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);
983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
985:
986:

Line 983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);

979: l_allow_future_end_prof_val := 'N';
980: END IF;
981:
982: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);
983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
985:
986:
987: FOR request IN get_all_mandatory_enr_requests(p_conc_request_id) LOOP

Line 984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);

980: END IF;
981:
982: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);
983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
985:
986:
987: FOR request IN get_all_mandatory_enr_requests(p_conc_request_id) LOOP
988: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));

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

1006: ELSE
1007: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
1008: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
1009: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
1010: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
1011: sql_stmnt :='SELECT * FROM(
1012: SELECT
1013: ppf.person_id person_id
1014: , pjt.job_id job_id

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

1143:
1144:
1145:
1146: --Write the error messages to log
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

1144:
1145:
1146: --Write the error messages to log
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1152: FOR unsuccessful_learner IN unprocessed_enrollments(p_conc_request_id) LOOP

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

1145:
1146: --Write the error messages to log
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1152: FOR unsuccessful_learner IN unprocessed_enrollments(p_conc_request_id) LOOP
1153: OPEN csr_get_person_name(unsuccessful_learner.person_id);

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

1146: --Write the error messages to log
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1152: FOR unsuccessful_learner IN unprocessed_enrollments(p_conc_request_id) LOOP
1153: OPEN csr_get_person_name(unsuccessful_learner.person_id);
1154: FETCH csr_get_person_name INTO l_person_name;

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

1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1152: FOR unsuccessful_learner IN unprocessed_enrollments(p_conc_request_id) LOOP
1153: OPEN csr_get_person_name(unsuccessful_learner.person_id);
1154: FETCH csr_get_person_name INTO l_person_name;
1155: CLOSE csr_get_person_name;

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

1155: CLOSE csr_get_person_name;
1156: IF unsuccessful_learner.create_enrollment = 'N' THEN
1157: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
1158: --The learner has NOT completed the course perquisites FOR the event
1159: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
1163: END IF;

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

1156: IF unsuccessful_learner.create_enrollment = 'N' THEN
1157: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
1158: --The learner has NOT completed the course perquisites FOR the event
1159: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
1163: END IF;
1164: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN

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

1157: IF unsuccessful_learner.completed_course_prereq = 'N' THEN
1158: --The learner has NOT completed the course perquisites FOR the event
1159: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
1163: END IF;
1164: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
1165: --The learner has NOT completed the competence perquisites FOR the event

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

1158: --The learner has NOT completed the course perquisites FOR the event
1159: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the course perquisites for the class -'||unsuccessful_learner.title);
1161: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1162: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
1163: END IF;
1164: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
1165: --The learner has NOT completed the competence perquisites FOR the event
1166: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

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

1162: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete course prerequisites');
1163: END IF;
1164: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
1165: --The learner has NOT completed the competence perquisites FOR the event
1166: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
1170: END IF;

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

1163: END IF;
1164: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
1165: --The learner has NOT completed the competence perquisites FOR the event
1166: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
1170: END IF;
1171: END IF;

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

1164: IF unsuccessful_learner.completed_competence_prereq = 'N' THEN
1165: --The learner has NOT completed the competence perquisites FOR the event
1166: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
1170: END IF;
1171: END IF;
1172:

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

1165: --The learner has NOT completed the competence perquisites FOR the event
1166: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG,'The learner has NOT completed the competence perquisites for the class -'||unsuccessful_learner.title);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Incomplete competence prerequisites');
1170: END IF;
1171: END IF;
1172:
1173: IF unsuccessful_learner.error_message IS NOT NULL THEN

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

1170: END IF;
1171: END IF;
1172:
1173: IF unsuccessful_learner.error_message IS NOT NULL THEN
1174: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
1178: END IF;

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

1171: END IF;
1172:
1173: IF unsuccessful_learner.error_message IS NOT NULL THEN
1174: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
1178: END IF;
1179:

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

1172:
1173: IF unsuccessful_learner.error_message IS NOT NULL THEN
1174: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
1178: END IF;
1179:
1180:

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

1173: IF unsuccessful_learner.error_message IS NOT NULL THEN
1174: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
1178: END IF;
1179:
1180:
1181: END LOOP;

Line 1377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);

1373: IF l_allow_future_end_prof_val is null then
1374: l_allow_future_end_prof_val := 'N';
1375: END IF;
1376:
1377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);
1378: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
1379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
1380:
1381:

Line 1378: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);

1374: l_allow_future_end_prof_val := 'N';
1375: END IF;
1376:
1377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);
1378: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
1379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
1380:
1381:
1382: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP

Line 1379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);

1375: END IF;
1376:
1377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS : '||l_allow_future_end_prof_val);
1378: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
1379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
1380:
1381:
1382: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP
1383: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));

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

1461: ELSE
1462: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
1463: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
1464: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
1465: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
1466: sql_stmnt :='SELECT * FROM(
1467: SELECT
1468: ppf.person_id person_id
1469: , pjt.job_id job_id

Line 1716: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Person record to process');

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');
1717: END process_mand_enr_reqs_multi;
1718:
1719: PROCEDURE create_enrollments(p_conc_reqId IN NUMBER) IS
1720:

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

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
1780: -- Raise error that no request found
1781: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR-No requests found FOR concurrent program- '||p_conc_reqId);
1782: CLOSE get_all_mandatory_enr_requests;
1783: RETURN;
1784: ELSE
1785: CLOSE get_all_mandatory_enr_requests;

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

1782: CLOSE get_all_mandatory_enr_requests;
1783: RETURN;
1784: ELSE
1785: CLOSE get_all_mandatory_enr_requests;
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

1783: RETURN;
1784: ELSE
1785: CLOSE get_all_mandatory_enr_requests;
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1791:

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

1784: ELSE
1785: CLOSE get_all_mandatory_enr_requests;
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1791:
1792: FOR l_req_member_rec IN csr_get_request_members(p_conc_reqId) LOOP

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

1785: CLOSE get_all_mandatory_enr_requests;
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1791:
1792: FOR l_req_member_rec IN csr_get_request_members(p_conc_reqId) LOOP
1793:

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

1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1791:
1792: FOR l_req_member_rec IN csr_get_request_members(p_conc_reqId) LOOP
1793:
1794: l_booking_id := NULL;

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

1796:
1797: OPEN csr_get_person_name(l_req_member_rec.person_id);
1798: FETCH csr_get_person_name INTO l_person_name;
1799: CLOSE csr_get_person_name;
1800: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1801:
1802:
1803: OPEN csr_get_cost_center_info(l_req_member_rec.assignment_id);
1804: FETCH csr_get_cost_center_info INTO l_cost_center_info;

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

1832: FETCH get_class_name into l_class_name;
1833: CLOSE get_class_name;
1834:
1835: IF l_booking_id IS NOT NULL THEN
1836: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
1837: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
1838: UPDATE ota_mandatory_enr_req_members
1839: SET error_message = NULL
1840: WHERE person_id = l_req_member_rec.person_id

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

1833: CLOSE get_class_name;
1834:
1835: IF l_booking_id IS NOT NULL THEN
1836: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
1837: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
1838: UPDATE ota_mandatory_enr_req_members
1839: SET error_message = NULL
1840: WHERE person_id = l_req_member_rec.person_id
1841: AND assignment_id = l_req_member_rec.assignment_id

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

1842: AND event_id = l_req_member_rec.event_id
1843: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;
1844: ELSE
1845: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
1846: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
1847: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
1849:
1850: UPDATE ota_mandatory_enr_req_members

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

1843: AND mandatory_enr_request_id = l_req_member_rec.mandatory_enr_request_id;
1844: ELSE
1845: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
1846: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
1847: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
1849:
1850: UPDATE ota_mandatory_enr_req_members
1851: SET error_message = l_error_message

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

1844: ELSE
1845: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
1846: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
1847: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
1849:
1850: UPDATE ota_mandatory_enr_req_members
1851: SET error_message = l_error_message
1852: WHERE person_id = l_req_member_rec.person_id

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

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,'-----------------------------------------------------------');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

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,'-----------------------------------------------------------');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1942:

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

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,'-----------------------------------------------------------');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1942:
1943: LOOP

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

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,'-----------------------------------------------------------');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1942:
1943: LOOP
1944: OPEN c_range_thread;

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

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,'-----------------------------------------------------------');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class ');
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
1942:
1943: LOOP
1944: OPEN c_range_thread;
1945:

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

1970:
1971: OPEN csr_get_person_name(l_req_member_rec.person_id);
1972: FETCH csr_get_person_name INTO l_person_name;
1973: CLOSE csr_get_person_name;
1974: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
1975:
1976:
1977: OPEN csr_get_cost_center_info(l_req_member_rec.assignment_id);
1978: FETCH csr_get_cost_center_info INTO l_cost_center_info;

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

2006: FETCH get_class_name into l_class_name;
2007: CLOSE get_class_name;
2008:
2009: IF l_booking_id IS NOT NULL THEN
2010: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
2011: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2012:
2013: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS
2014: SET action_status_cd = 'P',error_message = NULL

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

2007: CLOSE get_class_name;
2008:
2009: IF l_booking_id IS NOT NULL THEN
2010: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_class_name);
2011: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2012:
2013: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS
2014: SET action_status_cd = 'P',error_message = NULL
2015: WHERE person_id = l_req_member_rec.person_id

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

2018: AND action_status_cd not in ('P','E');
2019:
2020: ELSE
2021: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
2022: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
2023: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2024: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2025:
2026: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS

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

2019:
2020: ELSE
2021: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
2022: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
2023: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2024: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2025:
2026: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS
2027: SET error_message = l_error_message, action_status_cd = 'E'

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

2020: ELSE
2021: l_error_message := nvl(substr(l_error_message,1,2000),'Booking_id IS NULL');
2022: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
2023: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2024: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2025:
2026: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS
2027: SET error_message = l_error_message, action_status_cd = 'E'
2028: WHERE person_id = l_req_member_rec.person_id

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

2090: OPEN csr_get_user_name(p_person_id);
2091: FETCH csr_get_user_name INTO l_user_name;
2092: CLOSE csr_get_user_name;
2093:
2094: --fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);
2095:
2096: IF l_person_full_name IS NOT NULL then
2097: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'EVENT_OWNER',l_user_name);
2098: END IF;

Line 2268: FND_FILE.PUT_LINE(FND_FILE.LOG,'Automatic subscriptions are being processed for all certifications');

2264:
2265: if p_action_id is null then
2266:
2267: if p_cert_id is NULL then
2268: FND_FILE.PUT_LINE(FND_FILE.LOG,'Automatic subscriptions are being processed for all certifications');
2269: ELSE
2270: OPEN get_certification_name(p_cert_id);
2271: FETCH get_certification_name into l_cert_name;
2272: CLOSE get_certification_name;

Line 2273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Automatic subscriptions is being processed for Certification -' || l_cert_name);

2269: ELSE
2270: OPEN get_certification_name(p_cert_id);
2271: FETCH get_certification_name into l_cert_name;
2272: CLOSE get_certification_name;
2273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Automatic subscriptions is being processed for Certification -' || l_cert_name);
2274: END IF;
2275:
2276: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
2277: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));

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

2272: CLOSE get_certification_name;
2273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Automatic subscriptions is being processed for Certification -' || l_cert_name);
2274: END IF;
2275:
2276: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
2277: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
2278: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2279:
2280: SELECT

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

2273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Automatic subscriptions is being processed for Certification -' || l_cert_name);
2274: END IF;
2275:
2276: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
2277: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
2278: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2279:
2280: SELECT
2281: 'N' prereq_type,

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

2274: END IF;
2275:
2276: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Id : ' || FND_GLOBAL.conc_request_id);
2277: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time is - '||TO_CHAR(SYSTIMESTAMP));
2278: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
2279:
2280: SELECT
2281: 'N' prereq_type,
2282: NULL event_id,

Line 2310: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting into ota_mandatory_enr_requests');

2306:
2307:
2308:
2309: FOR i IN 1 .. l_rec.certification_id.COUNT LOOP
2310: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting into ota_mandatory_enr_requests');
2311:
2312: INSERT INTO OTA_MAND_MULTI_ENR_REQUESTS(
2313: MANDATORY_ENR_REQUEST_ID ,
2314: REQUESTOR_ID,

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

2350:
2351: if p_action_id is null then
2352:
2353: --Write the error messages to log
2354: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
2356: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

2351: if p_action_id is null then
2352:
2353: --Write the error messages to log
2354: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
2356: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2359: FOR unsuccessful_learner IN unprocessed_subscriptions(l_conc_request_id) LOOP

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

2352:
2353: --Write the error messages to log
2354: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
2356: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2359: FOR unsuccessful_learner IN unprocessed_subscriptions(l_conc_request_id) LOOP
2360: OPEN csr_get_person_name(unsuccessful_learner.person_id);

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

2353: --Write the error messages to log
2354: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
2356: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2359: FOR unsuccessful_learner IN unprocessed_subscriptions(l_conc_request_id) LOOP
2360: OPEN csr_get_person_name(unsuccessful_learner.person_id);
2361: FETCH csr_get_person_name INTO l_person_name;

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

2354: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful Learners');
2356: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Class Reason');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2359: FOR unsuccessful_learner IN unprocessed_subscriptions(l_conc_request_id) LOOP
2360: OPEN csr_get_person_name(unsuccessful_learner.person_id);
2361: FETCH csr_get_person_name INTO l_person_name;
2362: CLOSE csr_get_person_name;

Line 2364: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Unable to create certification subscription');

2360: OPEN csr_get_person_name(unsuccessful_learner.person_id);
2361: FETCH csr_get_person_name INTO l_person_name;
2362: CLOSE csr_get_person_name;
2363: IF unsuccessful_learner.create_enrollment = 'N' THEN
2364: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Unable to create certification subscription');
2365: END IF;
2366:
2367: IF unsuccessful_learner.error_message IS NOT NULL THEN
2368: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);

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

2364: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||'Unable to create certification subscription');
2365: END IF;
2366:
2367: IF unsuccessful_learner.error_message IS NOT NULL THEN
2368: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2369: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
2370: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
2371: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
2372: END IF;

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

2365: END IF;
2366:
2367: IF unsuccessful_learner.error_message IS NOT NULL THEN
2368: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2369: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
2370: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
2371: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
2372: END IF;
2373:

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

2366:
2367: IF unsuccessful_learner.error_message IS NOT NULL THEN
2368: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2369: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
2370: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
2371: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
2372: END IF;
2373:
2374:

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

2367: IF unsuccessful_learner.error_message IS NOT NULL THEN
2368: /* FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2369: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message - '||unsuccessful_learner.error_message);
2370: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');*/
2371: FND_FILE.PUT_LINE(FND_FILE.LOG, l_person_name||' | '||unsuccessful_learner.title||' | '||unsuccessful_learner.error_message);
2372: END IF;
2373:
2374:
2375:

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

2378: l_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'OTA'
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:

Line 2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);

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');
2543:
2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
2546:
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2548: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');

Line 2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);

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');
2543:
2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
2546:
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2548: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

2543:
2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
2546:
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2548: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

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

2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
2546:
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2548: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2552:

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

2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
2546:
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2548: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2552:
2553: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP

Line 2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');

2546:
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2548: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2552:
2553: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP
2554: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Looping through OTA_MAND_MULTI_ENR_REQUESTS');

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

2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2548: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successful Learners');
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2552:
2553: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP
2554: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Looping through OTA_MAND_MULTI_ENR_REQUESTS');
2555: l_cert_status_code :=0;

Line 2554: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Looping through OTA_MAND_MULTI_ENR_REQUESTS');

2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2552:
2553: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP
2554: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Looping through OTA_MAND_MULTI_ENR_REQUESTS');
2555: l_cert_status_code :=0;
2556: l_cert_enrollment_id :=0;
2557:
2558: IF request.usergroup_id IS NULL THEN

Line 2572: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');

2568: ELSIF l_cert_status_code = l_cancelled_subc_exist THEN
2569: create_cert_req_member_record(learner.person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2570: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2571: -- update the subscription, set is_automatic_subscription to Y
2572: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2573: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2574: where cert_enrollment_id = l_cert_enrollment_id;
2575:
2576: OPEN csr_get_person_name(learner.person_id);

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

2575:
2576: OPEN csr_get_person_name(learner.person_id);
2577: FETCH csr_get_person_name INTO l_person_name;
2578: CLOSE csr_get_person_name;
2579: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2580: --l_numberof_records_processed := l_numberof_records_processed + 1;
2581: END IF;
2582:
2583: if l_person_action_id is not null then

Line 2628: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');

2624: ELSIF l_cert_status_code = l_cancelled_subc_exist THEN
2625: create_cert_req_member_record(asg_learner.person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2626: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2627: -- update the subscription, set is_automatic_subscription to Y
2628: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2629: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2630: where cert_enrollment_id = l_cert_enrollment_id;
2631: OPEN csr_get_person_name(asg_learner.person_id);
2632: FETCH csr_get_person_name INTO l_person_name;

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

2630: where cert_enrollment_id = l_cert_enrollment_id;
2631: OPEN csr_get_person_name(asg_learner.person_id);
2632: FETCH csr_get_person_name INTO l_person_name;
2633: CLOSE csr_get_person_name;
2634: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2635: --l_numberof_records_processed := l_numberof_records_processed + 1;
2636: END IF;
2637:
2638: if l_person_action_id is not null then

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

2670: ELSE
2671: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
2672: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
2673: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
2674: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
2675: sql_stmnt :='SELECT * FROM(
2676: SELECT
2677: ppf.person_id person_id
2678: , pjt.job_id job_id

Line 2761: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');

2757: ELSIF l_cert_status_code = l_cancelled_subc_exist THEN
2758: create_cert_req_member_record(v_person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2759: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2760: -- update the subscription, set is_automatic_subscription to Y
2761: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2762: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2763: where cert_enrollment_id = l_cert_enrollment_id;
2764:
2765: OPEN csr_get_person_name(v_person_id);

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

2764:
2765: OPEN csr_get_person_name(v_person_id);
2766: FETCH csr_get_person_name INTO l_person_name;
2767: CLOSE csr_get_person_name;
2768: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2769: --l_numberof_records_processed := l_numberof_records_processed + 1;
2770: END IF;
2771:
2772: if l_person_action_id is not null then

Line 2826: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');

2822: ELSIF l_cert_status_code = l_cancelled_subc_exist THEN
2823: create_cert_req_member_record(lrnr_rec.person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2824: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2825: -- update the subscription, set is_automatic_subscription to Y
2826: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2827: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2828: where cert_enrollment_id = l_cert_enrollment_id;
2829:
2830: OPEN csr_get_person_name(lrnr_rec.person_id);

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

2829:
2830: OPEN csr_get_person_name(lrnr_rec.person_id);
2831: FETCH csr_get_person_name INTO l_person_name;
2832: CLOSE csr_get_person_name;
2833: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2834: --l_numberof_records_processed := l_numberof_records_processed + 1;
2835: END IF;
2836:
2837: if l_person_action_id is not null then

Line 2927: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' No person or no learner group to process');

2923: then
2924: -- Means no person is selected or no ug to process
2925: --
2926: --
2927: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' No person or no learner group to process');
2928: raise OTA_NO_PERSON_TO_PROCESS;
2929:
2930: --
2931: end if; --2

Line 2942: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Person record to process');

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');
2943: END process_auto_cert_subscr_req;
2944:
2945:
2946: PROCEDURE learner_can_enroll_in_cert(p_certification_id IN NUMBER

Line 2974: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered learner can enrol in cert ');

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;
2978: FETCH check_subscr_exists INTO l_cert_enrollment_id, l_certification_status_code, l_is_automatic_subscription;

Line 2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription does not exist Returning Y ');

2977: OPEN check_subscr_exists;
2978: FETCH check_subscr_exists INTO l_cert_enrollment_id, l_certification_status_code, l_is_automatic_subscription;
2979: IF check_subscr_exists%NOTFOUND THEN---if subscription does not exist
2980: CLOSE check_subscr_exists;
2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription does not exist Returning Y ');
2982: l_return_status:= l_subc_doesnot_exist;
2983: ELSE
2984: CLOSE check_subscr_exists;
2985: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_certification_status_code ' || l_certification_status_code);

Line 2985: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_certification_status_code ' || l_certification_status_code);

2981: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription does not exist Returning Y ');
2982: l_return_status:= l_subc_doesnot_exist;
2983: ELSE
2984: CLOSE check_subscr_exists;
2985: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_certification_status_code ' || l_certification_status_code);
2986: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_is_automatic_subscription' ||l_is_automatic_subscription);
2987: IF ((l_certification_status_code = 'AWAITING_APPROVAL') OR
2988: (l_certification_status_code = 'CANCELLED' AND l_is_automatic_subscription = 'Y')) THEN
2989: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription exists with status AWAITING_APPROVAL or Automatic subscription exists with Cancelled status. Returning N ');

Line 2986: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_is_automatic_subscription' ||l_is_automatic_subscription);

2982: l_return_status:= l_subc_doesnot_exist;
2983: ELSE
2984: CLOSE check_subscr_exists;
2985: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_certification_status_code ' || l_certification_status_code);
2986: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_is_automatic_subscription' ||l_is_automatic_subscription);
2987: IF ((l_certification_status_code = 'AWAITING_APPROVAL') OR
2988: (l_certification_status_code = 'CANCELLED' AND l_is_automatic_subscription = 'Y')) THEN
2989: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription exists with status AWAITING_APPROVAL or Automatic subscription exists with Cancelled status. Returning N ');
2990: l_return_status:= l_non_upd_subc_exist;

Line 2989: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription exists with status AWAITING_APPROVAL or Automatic subscription exists with Cancelled status. Returning N ');

2985: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_certification_status_code ' || l_certification_status_code);
2986: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_is_automatic_subscription' ||l_is_automatic_subscription);
2987: IF ((l_certification_status_code = 'AWAITING_APPROVAL') OR
2988: (l_certification_status_code = 'CANCELLED' AND l_is_automatic_subscription = 'Y')) THEN
2989: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription exists with status AWAITING_APPROVAL or Automatic subscription exists with Cancelled status. Returning N ');
2990: l_return_status:= l_non_upd_subc_exist;
2991: ELSE
2992: -- Both cert subscription in cancel and rejected status without the automatic certification flag set will be
2993: --re-subscribed, in case of automatic certification subscription

Line 2995: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Non auto subscription exists with status CANCELLED. Resubscribe ');

2991: ELSE
2992: -- Both cert subscription in cancel and rejected status without the automatic certification flag set will be
2993: --re-subscribed, in case of automatic certification subscription
2994: IF (l_certification_status_code = 'CANCELLED' OR l_certification_status_code = 'REJECTED') AND l_is_automatic_subscription = 'N' THEN
2995: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Non auto subscription exists with status CANCELLED. Resubscribe ');
2996: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Update cancelled existing subscription');
2997: l_return_status := l_cancelled_subc_exist;
2998: l_cert_enr_id := l_cert_enrollment_id;
2999: ELSE

Line 2996: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Update cancelled existing subscription');

2992: -- Both cert subscription in cancel and rejected status without the automatic certification flag set will be
2993: --re-subscribed, in case of automatic certification subscription
2994: IF (l_certification_status_code = 'CANCELLED' OR l_certification_status_code = 'REJECTED') AND l_is_automatic_subscription = 'N' THEN
2995: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Non auto subscription exists with status CANCELLED. Resubscribe ');
2996: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Update cancelled existing subscription');
2997: l_return_status := l_cancelled_subc_exist;
2998: l_cert_enr_id := l_cert_enrollment_id;
2999: ELSE
3000: IF l_is_automatic_subscription <> 'Y' THEN

Line 3001: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription exists. Update. Returning Y ');

2997: l_return_status := l_cancelled_subc_exist;
2998: l_cert_enr_id := l_cert_enrollment_id;
2999: ELSE
3000: IF l_is_automatic_subscription <> 'Y' THEN
3001: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription exists. Update. Returning Y ');
3002: l_return_status := l_upd_subc_exist;
3003: l_cert_enr_id:= l_cert_enrollment_id;
3004: END IF;
3005: END IF;

Line 3063: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside create_cert_req_member_record for person_id - ' || l_person_id);

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.
3066: OPEN csr_get_assignment_info(l_person_id);
3067: FETCH csr_get_assignment_info INTO l_assignment_info;

Line 3071: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting into req members');

3067: FETCH csr_get_assignment_info INTO l_assignment_info;
3068: CLOSE csr_get_assignment_info;
3069:
3070: IF learner_is_notSelected_inCert(l_person_id,l_assignment_info.assignment_id,req_cert_id) THEN
3071: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting into req members');
3072: Open C_Sel1;
3073: Fetch C_Sel1 Into l_person_action_id;
3074: Close C_Sel1;
3075: INSERT INTO OTA_MAND_MULTI_ENR_REQ_MEMBERS(mandatory_enr_request_id,person_id,assignment_id,error_message,

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

3186: ,p_cert_enrollment_id => l_cert_enrollment_id
3187: ,p_certification_status_code => l_certification_status_code
3188: ,p_is_automatic_subscription => 'Y');
3189:
3190: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
3191:
3192: EXCEPTION
3193: WHEN OTHERS THEN
3194: l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating certification subscription ');

Line 3207: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_certification_name||' | '||l_cert_enrollment_id);

3203: FETCH get_certification_name into l_certification_name;
3204: CLOSE get_certification_name;
3205:
3206: IF l_cert_enrollment_id IS NOT NULL THEN
3207: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_certification_name||' | '||l_cert_enrollment_id);
3208: IF l_req_member_rec.create_enrollment = 'U' THEN
3209: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_req_member_rec.create_enrollment = U');
3210: update ota_cert_enrollments set is_automatic_subscription = 'Y'
3211: where cert_enrollment_id = l_cert_enrollment_id;

Line 3209: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_req_member_rec.create_enrollment = U');

3205:
3206: IF l_cert_enrollment_id IS NOT NULL THEN
3207: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_certification_name||' | '||l_cert_enrollment_id);
3208: IF l_req_member_rec.create_enrollment = 'U' THEN
3209: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_req_member_rec.create_enrollment = U');
3210: update ota_cert_enrollments set is_automatic_subscription = 'Y'
3211: where cert_enrollment_id = l_cert_enrollment_id;
3212: END IF;
3213:

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

3219:
3220:
3221: ELSE
3222: l_error_message := nvl(substr(l_error_message,1,2000),'Subscription IS NULL');
3223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
3224: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
3225: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
3226:
3227: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS

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

3220:
3221: ELSE
3222: l_error_message := nvl(substr(l_error_message,1,2000),'Subscription IS NULL');
3223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
3224: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
3225: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
3226:
3227: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS
3228: SET error_message = l_error_message, action_status_cd = 'E'

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

3221: ELSE
3222: l_error_message := nvl(substr(l_error_message,1,2000),'Subscription IS NULL');
3223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Error when creating enrollment into class- '||l_class_name);
3224: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
3225: --FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------');
3226:
3227: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS
3228: SET error_message = l_error_message, action_status_cd = 'E'
3229: WHERE person_id = l_req_member_rec.person_id

Line 3253: fnd_file.put_line(fnd_file.log,'<<>>');

3249: ) is
3250: L_proc varchar2(80) := g_package||'.rpt_error';
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;

Line 3300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error:'||substr(SQLERRM,1,2000));

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);
3302: raise;
3303: End check_all_slaves_finished;
3304: