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.IRC_OFFER_NOTIFICATIONS_PKG dependencies on FND_FILE

Line 740: fnd_file.put_line

736: processed_record_count :=0;
737: failure_record_count :=0;
738:
739: -- setting header to the log file
740: fnd_file.put_line
741: (which => fnd_file.log
742: ,buff => rpad('Sr#',4,' ')
743: || rpad('Vacancy Name',16,' ')
744: || rpad('Offer ID',12,' ')

Line 741: (which => fnd_file.log

737: failure_record_count :=0;
738:
739: -- setting header to the log file
740: fnd_file.put_line
741: (which => fnd_file.log
742: ,buff => rpad('Sr#',4,' ')
743: || rpad('Vacancy Name',16,' ')
744: || rpad('Offer ID',12,' ')
745: || rpad('Applicant ID',13,' ')

Line 749: fnd_file.NEW_LINE(WHICH => fnd_file.log );

745: || rpad('Applicant ID',13,' ')
746: || rpad('Applicant Last Name',27,' ')
747: || lpad('Status',8,' ')
748: );
749: fnd_file.NEW_LINE(WHICH => fnd_file.log );
750:
751: --Fetch applicantion's current session Language
752: open get_nls_lang(userenv('LANG'));
753: fetch get_nls_lang into l_intial_set_lang;

Line 869: fnd_file.put_line

865: EXCEPTION
866: When OTHERS then
867: send_notitfication_status := 'failure';
868: failure_record_count := failure_record_count + 1;
869: fnd_file.put_line
870: ( which => fnd_file.log
871: ,buff => rpad(processed_record_count ||'.',4,' ')
872: || rpad(offer_expiry_rec.vacancy_name,16,' ')
873: || rpad(offer_expiry_rec.offer_id,12,' ')

Line 870: ( which => fnd_file.log

866: When OTHERS then
867: send_notitfication_status := 'failure';
868: failure_record_count := failure_record_count + 1;
869: fnd_file.put_line
870: ( which => fnd_file.log
871: ,buff => rpad(processed_record_count ||'.',4,' ')
872: || rpad(offer_expiry_rec.vacancy_name,16,' ')
873: || rpad(offer_expiry_rec.offer_id,12,' ')
874: || rpad(offer_expiry_rec.applicant_id,13,' ')

Line 879: fnd_file.put_line

875: || rpad(rtrim(substr(rtrim(offer_expiry_rec.applicant_name),1, INSTR(rtrim(offer_expiry_rec.applicant_name), ',', 1, 1)-1)),27,' ')
876: || lpad(send_notitfication_status,8,' ')
877: );
878:
879: fnd_file.put_line
880: ( which => fnd_file.log
881: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
882: );
883: END;

Line 880: ( which => fnd_file.log

876: || lpad(send_notitfication_status,8,' ')
877: );
878:
879: fnd_file.put_line
880: ( which => fnd_file.log
881: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
882: );
883: END;
884:

Line 996: fnd_file.put_line

992: end if;
993: hr_utility.set_location(l_proc,120);
994: EXCEPTION
995: When OTHERS then
996: fnd_file.put_line
997: ( which => fnd_file.log
998: ,buff => 'The Manager' || rpad(offer_expiry_rec.manager_id,10,' ')||'dont have workflow role'
999: );
1000:

Line 997: ( which => fnd_file.log

993: hr_utility.set_location(l_proc,120);
994: EXCEPTION
995: When OTHERS then
996: fnd_file.put_line
997: ( which => fnd_file.log
998: ,buff => 'The Manager' || rpad(offer_expiry_rec.manager_id,10,' ')||'dont have workflow role'
999: );
1000:
1001: fnd_file.put_line

Line 1001: fnd_file.put_line

997: ( which => fnd_file.log
998: ,buff => 'The Manager' || rpad(offer_expiry_rec.manager_id,10,' ')||'dont have workflow role'
999: );
1000:
1001: fnd_file.put_line
1002: ( which => fnd_file.log
1003: ,buff => ' Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1004: );
1005: END;

Line 1002: ( which => fnd_file.log

998: ,buff => 'The Manager' || rpad(offer_expiry_rec.manager_id,10,' ')||'dont have workflow role'
999: );
1000:
1001: fnd_file.put_line
1002: ( which => fnd_file.log
1003: ,buff => ' Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1004: );
1005: END;
1006: END IF;

Line 1008: fnd_file.put_line

1004: );
1005: END;
1006: END IF;
1007: if send_notitfication_status = 'success' then
1008: fnd_file.put_line
1009: ( which => fnd_file.log
1010: ,buff => rpad(processed_record_count ||'.',4,' ')
1011: || rpad(offer_expiry_rec.vacancy_name,16,' ')
1012: || rpad(offer_expiry_rec.offer_id,12,' ')

Line 1009: ( which => fnd_file.log

1005: END;
1006: END IF;
1007: if send_notitfication_status = 'success' then
1008: fnd_file.put_line
1009: ( which => fnd_file.log
1010: ,buff => rpad(processed_record_count ||'.',4,' ')
1011: || rpad(offer_expiry_rec.vacancy_name,16,' ')
1012: || rpad(offer_expiry_rec.offer_id,12,' ')
1013: || rpad(offer_expiry_rec.applicant_id,13,' ')

Line 1023: fnd_file.NEW_LINE(WHICH => fnd_file.log );

1019: --Reset applicantion's current session Language
1020: if l_intial_set_lang <> l_current_set_lang then
1021: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1022: end if;
1023: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1024: fnd_file.put_line
1025: (which => fnd_file.log
1026: ,buff => 'Total Record Processed ' || processed_record_count ||
1027: ' Successful Records '|| (processed_record_count - failure_record_count) ||

Line 1024: fnd_file.put_line

1020: if l_intial_set_lang <> l_current_set_lang then
1021: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1022: end if;
1023: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1024: fnd_file.put_line
1025: (which => fnd_file.log
1026: ,buff => 'Total Record Processed ' || processed_record_count ||
1027: ' Successful Records '|| (processed_record_count - failure_record_count) ||
1028: ' Error Records '|| failure_record_count

Line 1025: (which => fnd_file.log

1021: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1022: end if;
1023: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1024: fnd_file.put_line
1025: (which => fnd_file.log
1026: ,buff => 'Total Record Processed ' || processed_record_count ||
1027: ' Successful Records '|| (processed_record_count - failure_record_count) ||
1028: ' Error Records '|| failure_record_count
1029: );

Line 1080: fnd_file.put_line

1076: processed_record_count :=0;
1077: failure_record_count :=0;
1078:
1079: --setting header to the log file
1080: fnd_file.put_line
1081: (which => fnd_file.log
1082: ,buff => rpad('Sr#',4,' ')
1083: || rpad('Vacancy Name',16,' ')
1084: || rpad('Offer ID',12,' ')

Line 1081: (which => fnd_file.log

1077: failure_record_count :=0;
1078:
1079: --setting header to the log file
1080: fnd_file.put_line
1081: (which => fnd_file.log
1082: ,buff => rpad('Sr#',4,' ')
1083: || rpad('Vacancy Name',16,' ')
1084: || rpad('Offer ID',12,' ')
1085: || rpad('Applicant ID',13,' ')

Line 1090: fnd_file.NEW_LINE(WHICH => fnd_file.log );

1086: || rpad('Applicant Last Name',27,' ')
1087: || lpad('Status',8,' ')
1088: );
1089:
1090: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1091: --Fetch applicantion's current session Language
1092: open get_nls_lang(userenv('LANG'));
1093: fetch get_nls_lang into l_intial_set_lang;
1094: close get_nls_lang;

Line 1179: fnd_file.put_line

1175: EXCEPTION
1176: When OTHERS then
1177: send_notitfication_status := 'failure';
1178: failure_record_count := failure_record_count + 1;
1179: fnd_file.put_line
1180: ( which => fnd_file.log
1181: ,buff => rpad(processed_record_count ||'.',4,' ')
1182: || rpad(offer_expired_rec.vacancy_name,16,' ')
1183: || rpad(offer_expired_rec.offer_id,12,' ')

Line 1180: ( which => fnd_file.log

1176: When OTHERS then
1177: send_notitfication_status := 'failure';
1178: failure_record_count := failure_record_count + 1;
1179: fnd_file.put_line
1180: ( which => fnd_file.log
1181: ,buff => rpad(processed_record_count ||'.',4,' ')
1182: || rpad(offer_expired_rec.vacancy_name,16,' ')
1183: || rpad(offer_expired_rec.offer_id,12,' ')
1184: || rpad(offer_expired_rec.applicant_id,13,' ')

Line 1189: fnd_file.put_line

1185: || rpad(rtrim(substr(rtrim(offer_expired_rec.applicant_name),1, INSTR(rtrim(offer_expired_rec.applicant_name), ',', 1, 1)-1)),27,' ')
1186: || lpad(send_notitfication_status,8,' ')
1187: );
1188:
1189: fnd_file.put_line
1190: ( which => fnd_file.log
1191: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1192: );
1193: END;

Line 1190: ( which => fnd_file.log

1186: || lpad(send_notitfication_status,8,' ')
1187: );
1188:
1189: fnd_file.put_line
1190: ( which => fnd_file.log
1191: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1192: );
1193: END;
1194:

Line 1297: fnd_file.put_line

1293: end if;
1294: hr_utility.set_location(l_proc,100);
1295: EXCEPTION
1296: When OTHERS then
1297: fnd_file.put_line
1298: ( which => fnd_file.log
1299: ,buff => 'The Manager' || rpad(offer_expired_rec.manager_id,10,' ')||'dont have workflow role'
1300: );
1301:

Line 1298: ( which => fnd_file.log

1294: hr_utility.set_location(l_proc,100);
1295: EXCEPTION
1296: When OTHERS then
1297: fnd_file.put_line
1298: ( which => fnd_file.log
1299: ,buff => 'The Manager' || rpad(offer_expired_rec.manager_id,10,' ')||'dont have workflow role'
1300: );
1301:
1302: fnd_file.put_line

Line 1302: fnd_file.put_line

1298: ( which => fnd_file.log
1299: ,buff => 'The Manager' || rpad(offer_expired_rec.manager_id,10,' ')||'dont have workflow role'
1300: );
1301:
1302: fnd_file.put_line
1303: ( which => fnd_file.log
1304: ,buff => ' Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1305: );
1306:

Line 1303: ( which => fnd_file.log

1299: ,buff => 'The Manager' || rpad(offer_expired_rec.manager_id,10,' ')||'dont have workflow role'
1300: );
1301:
1302: fnd_file.put_line
1303: ( which => fnd_file.log
1304: ,buff => ' Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1305: );
1306:
1307: END;

Line 1322: fnd_file.put_line

1318: );
1319: hr_utility.set_location(l_proc,110);
1320:
1321: if send_notitfication_status = 'success' then
1322: fnd_file.put_line
1323: ( which => fnd_file.log
1324: ,buff => rpad(processed_record_count ||'.',4,' ')
1325: || rpad(offer_expired_rec.vacancy_name,16,' ')
1326: || rpad(offer_expired_rec.offer_id,12,' ')

Line 1323: ( which => fnd_file.log

1319: hr_utility.set_location(l_proc,110);
1320:
1321: if send_notitfication_status = 'success' then
1322: fnd_file.put_line
1323: ( which => fnd_file.log
1324: ,buff => rpad(processed_record_count ||'.',4,' ')
1325: || rpad(offer_expired_rec.vacancy_name,16,' ')
1326: || rpad(offer_expired_rec.offer_id,12,' ')
1327: || rpad(offer_expired_rec.applicant_id,13,' ')

Line 1339: fnd_file.NEW_LINE(WHICH => fnd_file.log );

1335: --Reset applicantion's current session Language
1336: if l_intial_set_lang <> l_current_set_lang then
1337: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1338: end if;
1339: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1340: fnd_file.put_line
1341: (which => fnd_file.log
1342: ,buff => 'Total Record Processed ' || processed_record_count ||
1343: ' Successful Records '|| (processed_record_count - failure_record_count) ||

Line 1340: fnd_file.put_line

1336: if l_intial_set_lang <> l_current_set_lang then
1337: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1338: end if;
1339: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1340: fnd_file.put_line
1341: (which => fnd_file.log
1342: ,buff => 'Total Record Processed ' || processed_record_count ||
1343: ' Successful Records '|| (processed_record_count - failure_record_count) ||
1344: ' Error Records '|| failure_record_count

Line 1341: (which => fnd_file.log

1337: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1338: end if;
1339: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1340: fnd_file.put_line
1341: (which => fnd_file.log
1342: ,buff => 'Total Record Processed ' || processed_record_count ||
1343: ' Successful Records '|| (processed_record_count - failure_record_count) ||
1344: ' Error Records '|| failure_record_count
1345: );