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_ELIG_PROFILE_UTIL dependencies on FND_FILE

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Record exist for person_id : ' ||TO_CHAR(p_person_id) ||' user_group_id : ' ||TO_CHAR(p_user_group_id) ||' so update.Eligibility profile id is : '||TO_CHAR(p_eligibility_profile_id));

186: begin
187:
188: if is_learner_in_resolved_ug_data(p_user_group_id, p_person_id)= 'Y' then
189: if p_enable_logging = 'Y' then
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Record exist for person_id : ' ||TO_CHAR(p_person_id) ||' user_group_id : ' ||TO_CHAR(p_user_group_id) ||' so update.Eligibility profile id is : '||TO_CHAR(p_eligibility_profile_id));
191: end if;
192:
193: update ota_user_group_elements set processing_status= 'A' ,elig_prfl_id = p_eligibility_profile_id
194: where

Line 203: FND_FILE.PUT_LINE(FND_FILE.LOG,'Record does not exist for person_id : ' ||TO_CHAR(p_person_id) ||' user_group_id : ' ||TO_CHAR(p_user_group_id) ||' so create.Eligibility profile id is : '||TO_CHAR(p_eligibility_profile_id));

199:
200:
201: else
202: if p_enable_logging = 'Y' then
203: FND_FILE.PUT_LINE(FND_FILE.LOG,'Record does not exist for person_id : ' ||TO_CHAR(p_person_id) ||' user_group_id : ' ||TO_CHAR(p_user_group_id) ||' so create.Eligibility profile id is : '||TO_CHAR(p_eligibility_profile_id));
204: end if;
205:
206: insert into ota_user_group_elements(
207: USER_GROUP_ELEMENT_ID,

Line 325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));

321: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_ep_whereclause ;
322:
323:
324: if p_enable_logging = 'Y' then
325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));
326: FND_FILE.PUT_LINE(FND_FILE.LOG,'PER_BUSINESS_GROUP_ID :' ||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
327: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_ug_to_be_processed is:'||get_ug_to_be_processed);
328:
329: end if;

Line 326: FND_FILE.PUT_LINE(FND_FILE.LOG,'PER_BUSINESS_GROUP_ID :' ||fnd_profile.value('PER_BUSINESS_GROUP_ID'));

322:
323:
324: if p_enable_logging = 'Y' then
325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));
326: FND_FILE.PUT_LINE(FND_FILE.LOG,'PER_BUSINESS_GROUP_ID :' ||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
327: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_ug_to_be_processed is:'||get_ug_to_be_processed);
328:
329: end if;
330:

Line 327: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_ug_to_be_processed is:'||get_ug_to_be_processed);

323:
324: if p_enable_logging = 'Y' then
325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));
326: FND_FILE.PUT_LINE(FND_FILE.LOG,'PER_BUSINESS_GROUP_ID :' ||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
327: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_ug_to_be_processed is:'||get_ug_to_be_processed);
328:
329: end if;
330:
331: OPEN csr_get_ug_to_be_processed for get_ug_to_be_processed;

Line 345: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner group being processed : '||l_learner_group_name);

341:
342: l_learner_group_name := get_learner_group_name(user_group_rec.user_group_id);
343:
344:
345: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner group being processed : '||l_learner_group_name);
346:
347: if check_processing_status(user_group_rec.user_group_id, user_group_rec.elig_prfl_id) <> 'P' then
348: --This is done to avoid the learner group if its been picked/processed by some other run of this conc program
349: --i.e the user group is under processing in the mean time.

Line 361: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eligibility profile details not found or it is in inactive/closed status');

357: open get_elig_prof_details(user_group_rec.elig_prfl_id);
358: fetch get_elig_prof_details into l_elig_prof_id,l_elig_prof_name,l_asmt_to_use_cd,l_elig_pro_bg_id;
359: if get_elig_prof_details%NOTFOUND then
360: close get_elig_prof_details;
361: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eligibility profile details not found or it is in inactive/closed status');
362: --write messages in conc program log;
363: else
364: -- row exists, so resolve ppl based on column asmt_to_use_cd and then function is_eligible.
365: --lookup name 'BEN_ASMT_TO_USE';

Line 370: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eligibility profile being processed :'||l_elig_prof_name);

366: close get_elig_prof_details;
367: l_eligprof_tab(1).eligy_prfl_id := l_elig_prof_id;
368:
369: l_elig_obj_id := get_elig_object_id(user_group_rec.user_group_id);
370: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eligibility profile being processed :'||l_elig_prof_name);
371:
372: if l_asmt_to_use_cd = 'EAO' then --(Employee Assignment only)
373: assignment_whereclause := 'assignment_type = ''E'' ';
374: elsif l_asmt_to_use_cd = 'AAO' then --(Applicant Assignment only)

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_stmnt is:'||l_sql_stmnt);

398: and ((fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') is not null and business_group_id = '||l_elig_pro_bg_id||') or (business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))))
399: QRSLT WHERE ' || assignment_whereclause;
400:
401: if p_enable_logging = 'Y' then
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_stmnt is:'||l_sql_stmnt);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_elig_obj_id is:'|| TO_CHAR(l_elig_obj_id));
404: end if;
405:
406: OPEN csr_get_lrnr_in_assign FOR l_sql_stmnt;

Line 403: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_elig_obj_id is:'|| TO_CHAR(l_elig_obj_id));

399: QRSLT WHERE ' || assignment_whereclause;
400:
401: if p_enable_logging = 'Y' then
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_stmnt is:'||l_sql_stmnt);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_elig_obj_id is:'|| TO_CHAR(l_elig_obj_id));
404: end if;
405:
406: OPEN csr_get_lrnr_in_assign FOR l_sql_stmnt;
407:

Line 461: FND_FILE.PUT_LINE(FND_FILE.LOG,'The given combination of learner group and eligibility profile donot exist');

457: end loop;
458: close csr_get_ug_to_be_processed;
459:
460: if l_counter = 0 then
461: FND_FILE.PUT_LINE(FND_FILE.LOG,'The given combination of learner group and eligibility profile donot exist');
462: end if;
463:
464: commit;
465: exception

Line 471: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in processing learner group '||l_learner_group_name);

467:
468: update ota_user_group_elements set processing_status= 'E' --Parent record to Error
469: where user_group_element_id =l_learner_group_element_id;
470:
471: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in processing learner group '||l_learner_group_name);
472: commit;
473:
474: end resolve_eligibility_profile;
475:

Line 543: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_per_bg_grp_prof_val:'||l_per_bg_grp_prof_val);

539:
540: begin
541:
542: if p_enable_logging = 'Y' then
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_per_bg_grp_prof_val:'||l_per_bg_grp_prof_val);
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ota_global_bg_prof_val:'||l_ota_global_bg_prof_val);
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);

Line 544: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ota_global_bg_prof_val:'||l_ota_global_bg_prof_val);

540: begin
541:
542: if p_enable_logging = 'Y' then
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_per_bg_grp_prof_val:'||l_per_bg_grp_prof_val);
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ota_global_bg_prof_val:'||l_ota_global_bg_prof_val);
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_elig_prof_id:'||p_elig_prof_id);

Line 545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');

541:
542: if p_enable_logging = 'Y' then
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_per_bg_grp_prof_val:'||l_per_bg_grp_prof_val);
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ota_global_bg_prof_val:'||l_ota_global_bg_prof_val);
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_elig_prof_id:'||p_elig_prof_id);
549: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_enable_logging:'||p_enable_logging);

Line 546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);

542: if p_enable_logging = 'Y' then
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_per_bg_grp_prof_val:'||l_per_bg_grp_prof_val);
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ota_global_bg_prof_val:'||l_ota_global_bg_prof_val);
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_elig_prof_id:'||p_elig_prof_id);
549: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_enable_logging:'||p_enable_logging);
550: end if;

Line 547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);

543: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_per_bg_grp_prof_val:'||l_per_bg_grp_prof_val);
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ota_global_bg_prof_val:'||l_ota_global_bg_prof_val);
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_elig_prof_id:'||p_elig_prof_id);
549: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_enable_logging:'||p_enable_logging);
550: end if;
551:

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_elig_prof_id:'||p_elig_prof_id);

544: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ota_global_bg_prof_val:'||l_ota_global_bg_prof_val);
545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_elig_prof_id:'||p_elig_prof_id);
549: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_enable_logging:'||p_enable_logging);
550: end if;
551:
552: If p_action_id is null then

Line 549: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_enable_logging:'||p_enable_logging);

545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering :resolve_eligibility_profile');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id:'||p_action_id);
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_learner_group_id:'||p_learner_group_id);
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_elig_prof_id:'||p_elig_prof_id);
549: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_enable_logging:'||p_enable_logging);
550: end if;
551:
552: If p_action_id is null then
553: --

Line 555: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id is null');

551:
552: If p_action_id is null then
553: --
554: if p_enable_logging = 'Y' then
555: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_action_id is null');
556: end if;
557:
558: ota_batch_action_api.create_bulk_enr_request
559: (p_bulk_enr_request_id => l_action_id

Line 566: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_action_id:'||l_action_id);

562: ,p_business_group_id => ota_general.get_business_group_id
563: ,p_conc_program_request_id => fnd_global.conc_request_id);
564:
565: if p_enable_logging = 'Y' then
566: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_action_id:'||l_action_id);
567: end if;
568:
569: if p_learner_group_id is not null and p_elig_prof_id is not null then
570:

Line 611: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);

607: FETCH csr_get_ug_to_be_processed BULK COLLECT into user_elig_pro_rec;
608: CLOSE csr_get_ug_to_be_processed;
609:
610: if p_enable_logging = 'Y' then
611: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);
612: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' ota_general.get_business_group_id:'||ota_general.get_business_group_id);
613: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' user_elig_pro_rec.count:'||user_elig_pro_rec.count);
614: end if;
615: if user_elig_pro_rec.count > 0 then -- check whether there is any ug to process

Line 612: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' ota_general.get_business_group_id:'||ota_general.get_business_group_id);

608: CLOSE csr_get_ug_to_be_processed;
609:
610: if p_enable_logging = 'Y' then
611: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);
612: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' ota_general.get_business_group_id:'||ota_general.get_business_group_id);
613: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' user_elig_pro_rec.count:'||user_elig_pro_rec.count);
614: end if;
615: if user_elig_pro_rec.count > 0 then -- check whether there is any ug to process
616:

Line 613: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' user_elig_pro_rec.count:'||user_elig_pro_rec.count);

609:
610: if p_enable_logging = 'Y' then
611: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);
612: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' ota_general.get_business_group_id:'||ota_general.get_business_group_id);
613: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' user_elig_pro_rec.count:'||user_elig_pro_rec.count);
614: end if;
615: if user_elig_pro_rec.count > 0 then -- check whether there is any ug to process
616:
617: for ug_print_count in user_elig_pro_rec.first..user_elig_pro_rec.last --{ ug_ep loop

Line 795: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' leaving');

791: commit;
792: end if;
793: hr_utility.set_location('in multithread',10);
794: end; --1
795: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' leaving');
796: exception
797: when OTA_NO_PERSON_LG_TO_PROCESS then
798: if p_enable_logging = 'Y' then
799: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' No person or no learner group to process');

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

795: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' leaving');
796: exception
797: when OTA_NO_PERSON_LG_TO_PROCESS then
798: if p_enable_logging = 'Y' then
799: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' No person or no learner group to process');
800: end if;
801: IF user_elig_pro_rec.count > 0 THEN
802: for ug_print_count in user_elig_pro_rec.first..user_elig_pro_rec.last --{ ug_ep loop
803: loop

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

814: end if;
815: commit;
816: when others then
817: if p_enable_logging = 'Y' then
818: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error:'||substr(SQLERRM,1,2000));
819: end if;
820: IF user_elig_pro_rec.count > 0 THEN
821: for ug_print_count in user_elig_pro_rec.first..user_elig_pro_rec.last --{ ug_ep loop
822: loop

Line 1004: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);

1000: || ''' and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '
1001: || ug_whereclause
1002: || ' order by user_group_id';
1003: if p_enable_logging = 'Y' then
1004: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);
1005: end if;
1006:
1007: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' conc_parent_request_id:'||conc_parent_request_id(fnd_global.conc_request_id));
1008:

Line 1007: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' conc_parent_request_id:'||conc_parent_request_id(fnd_global.conc_request_id));

1003: if p_enable_logging = 'Y' then
1004: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);
1005: end if;
1006:
1007: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' conc_parent_request_id:'||conc_parent_request_id(fnd_global.conc_request_id));
1008:
1009: OPEN csr_get_ug_to_be_processed
1010: FOR get_ug_to_be_processed;
1011:

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

1048: l_counter := l_counter + 1;
1049: FOR l_rec IN c_person_assign_thread LOOP
1050:
1051: IF p_enable_logging = 'Y' THEN
1052: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
1053: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.person_id:'||l_rec.person_id);
1054: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.mbr_bg_id:'||l_rec.mbr_bg_id);
1055: End if;
1056:

Line 1053: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.person_id:'||l_rec.person_id);

1049: FOR l_rec IN c_person_assign_thread LOOP
1050:
1051: IF p_enable_logging = 'Y' THEN
1052: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
1053: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.person_id:'||l_rec.person_id);
1054: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.mbr_bg_id:'||l_rec.mbr_bg_id);
1055: End if;
1056:
1057: l_counter := l_counter + 1;

Line 1054: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.mbr_bg_id:'||l_rec.mbr_bg_id);

1050:
1051: IF p_enable_logging = 'Y' THEN
1052: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------');
1053: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.person_id:'||l_rec.person_id);
1054: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' l_rec.mbr_bg_id:'||l_rec.mbr_bg_id);
1055: End if;
1056:
1057: l_counter := l_counter + 1;
1058: l_pre_ug_id := - 1;

Line 1110: fnd_file.put_line (fnd_file.log

1106: l_numberof_records_processed := 0;
1107: END IF;
1108:
1109: IF p_enable_logging = 'Y' THEN
1110: fnd_file.put_line (fnd_file.log
1111: ,l_rec.person_id
1112: || ' is eligible for '
1113: || l_learner_group_name);
1114: END IF;

Line 1145: fnd_file.put_line (fnd_file.log

1141: ota_elig_profile_util.check_all_slaves_finished
1142: (p_rpt_flag => TRUE);
1143:
1144: IF l_counter = 0 THEN
1145: fnd_file.put_line (fnd_file.log
1146: ,'The given combination of learner group and eligibility profile donot exist');
1147: END IF;
1148:
1149: IF p_enable_logging = 'Y' THEN

Line 1150: fnd_file.put_line (fnd_file.log

1146: ,'The given combination of learner group and eligibility profile donot exist');
1147: END IF;
1148:
1149: IF p_enable_logging = 'Y' THEN
1150: fnd_file.put_line (fnd_file.log
1151: ,'Commit Done');
1152: END IF;
1153:
1154: COMMIT;

Line 1174: fnd_file.put_line (fnd_file.log

1170: l_pre_ug_id := user_elig_pro_rec(ug_print_count).user_group_id;
1171: end if;
1172: end loop;
1173: end if;
1174: fnd_file.put_line (fnd_file.log
1175: ,'Error in processing learner group '
1176: || l_learner_group_name);
1177:
1178: fnd_file.put_line (fnd_file.log

Line 1178: fnd_file.put_line (fnd_file.log

1174: fnd_file.put_line (fnd_file.log
1175: ,'Error in processing learner group '
1176: || l_learner_group_name);
1177:
1178: fnd_file.put_line (fnd_file.log
1179: ,substr (sqlerrm
1180: ,1
1181: ,2000)
1182: || l_learner_group_name);

Line 1257: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner group being processed : '||l_learner_group_name);

1253:
1254: l_learner_group_name := get_learner_group_name(user_group_rec.user_group_id);
1255: l_learner_group_element_id := user_group_rec.user_group_element_id;
1256:
1257: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner group being processed : '||l_learner_group_name);
1258:
1259: open get_elig_prof_details(user_group_rec.elig_prfl_id);
1260: fetch get_elig_prof_details into l_elig_prof_id,l_elig_prof_name,l_asmt_to_use_cd,l_business_group_id;
1261: if get_elig_prof_details%NOTFOUND then

Line 1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eligibility profile details not found or it is in inactive/closed status');

1259: open get_elig_prof_details(user_group_rec.elig_prfl_id);
1260: fetch get_elig_prof_details into l_elig_prof_id,l_elig_prof_name,l_asmt_to_use_cd,l_business_group_id;
1261: if get_elig_prof_details%NOTFOUND then
1262: close get_elig_prof_details;
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eligibility profile details not found or it is in inactive/closed status');
1264: --write messages in conc program log;
1265: else
1266:
1267: l_counter := l_counter+1;

Line 1291: FND_FILE.PUT_LINE(FND_FILE.LOG,'The given combination of learner group and eligibility profile donot exist');

1287:
1288: end loop;
1289:
1290: if l_counter = 0 then
1291: FND_FILE.PUT_LINE(FND_FILE.LOG,'The given combination of learner group and eligibility profile donot exist');
1292: end if;
1293:
1294: exception
1295: when others then

Line 1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in deleting ineligible records for learner group '||l_learner_group_name);

1296:
1297: update ota_user_group_elements set processing_status= 'E' --Parent record to Error
1298: where user_group_element_id =l_learner_group_element_id;
1299:
1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in deleting ineligible records for learner group '||l_learner_group_name);
1301: commit;
1302:
1303: end delete_ineligible_records;
1304:

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

1558: ) is
1559: L_proc varchar2(80) := g_package||'.rpt_error';
1560: Begin
1561: If (p_rpt_flag ) then
1562: fnd_file.put_line(fnd_file.log,'<<>>');
1563: End if;
1564: hr_utility.set_location('> Fail in ' || p_proc, 999 );
1565: hr_utility.set_location('>> While ' || p_last_actn, 999);
1566: End rpt_error;