203: ben_batch_utils.write('Termination Date: '||l_term_date);
204: ben_batch_utils.write ('+==========================Warnings=========================================+');
205:
206: if(upper(l_no_payroll_warn)='Y') then
207: fnd_message.set_name('BEN','BEN_94050_ADMIN_PP_NO_PAYROLL');
208: ben_batch_utils.write(fnd_message.get);
209: end if;
210: if(upper(l_no_salary_warn)='Y') then
211: fnd_message.set_name('BEN','BEN_94051_ADMIN_PP_NO_SALARY');
204: ben_batch_utils.write ('+==========================Warnings=========================================+');
205:
206: if(upper(l_no_payroll_warn)='Y') then
207: fnd_message.set_name('BEN','BEN_94050_ADMIN_PP_NO_PAYROLL');
208: ben_batch_utils.write(fnd_message.get);
209: end if;
210: if(upper(l_no_salary_warn)='Y') then
211: fnd_message.set_name('BEN','BEN_94051_ADMIN_PP_NO_SALARY');
212: ben_batch_utils.write(fnd_message.get);
207: fnd_message.set_name('BEN','BEN_94050_ADMIN_PP_NO_PAYROLL');
208: ben_batch_utils.write(fnd_message.get);
209: end if;
210: if(upper(l_no_salary_warn)='Y') then
211: fnd_message.set_name('BEN','BEN_94051_ADMIN_PP_NO_SALARY');
212: ben_batch_utils.write(fnd_message.get);
213: end if;
214: if(upper(l_no_supervisor_warn)='Y') then
215: fnd_message.set_name('BEN','BEN_94052_ADMIN_PP_NO_SUPRVSR');
208: ben_batch_utils.write(fnd_message.get);
209: end if;
210: if(upper(l_no_salary_warn)='Y') then
211: fnd_message.set_name('BEN','BEN_94051_ADMIN_PP_NO_SALARY');
212: ben_batch_utils.write(fnd_message.get);
213: end if;
214: if(upper(l_no_supervisor_warn)='Y') then
215: fnd_message.set_name('BEN','BEN_94052_ADMIN_PP_NO_SUPRVSR');
216: ben_batch_utils.write(fnd_message.get);
211: fnd_message.set_name('BEN','BEN_94051_ADMIN_PP_NO_SALARY');
212: ben_batch_utils.write(fnd_message.get);
213: end if;
214: if(upper(l_no_supervisor_warn)='Y') then
215: fnd_message.set_name('BEN','BEN_94052_ADMIN_PP_NO_SUPRVSR');
216: ben_batch_utils.write(fnd_message.get);
217: end if;
218: if(upper(l_no_position_warn)='Y') then
219: fnd_message.set_name('BEN','BEN_94053_ADMIN_PP_NO_POSITION');
212: ben_batch_utils.write(fnd_message.get);
213: end if;
214: if(upper(l_no_supervisor_warn)='Y') then
215: fnd_message.set_name('BEN','BEN_94052_ADMIN_PP_NO_SUPRVSR');
216: ben_batch_utils.write(fnd_message.get);
217: end if;
218: if(upper(l_no_position_warn)='Y') then
219: fnd_message.set_name('BEN','BEN_94053_ADMIN_PP_NO_POSITION');
220: ben_batch_utils.write(fnd_message.get);
215: fnd_message.set_name('BEN','BEN_94052_ADMIN_PP_NO_SUPRVSR');
216: ben_batch_utils.write(fnd_message.get);
217: end if;
218: if(upper(l_no_position_warn)='Y') then
219: fnd_message.set_name('BEN','BEN_94053_ADMIN_PP_NO_POSITION');
220: ben_batch_utils.write(fnd_message.get);
221: end if;
222: if(upper(l_no_paybasis_warn)='Y') then
223: fnd_message.set_name('BEN','BEN_94054_ADMIN_PP_NO_PAYBASIS');
216: ben_batch_utils.write(fnd_message.get);
217: end if;
218: if(upper(l_no_position_warn)='Y') then
219: fnd_message.set_name('BEN','BEN_94053_ADMIN_PP_NO_POSITION');
220: ben_batch_utils.write(fnd_message.get);
221: end if;
222: if(upper(l_no_paybasis_warn)='Y') then
223: fnd_message.set_name('BEN','BEN_94054_ADMIN_PP_NO_PAYBASIS');
224: ben_batch_utils.write(fnd_message.get);
219: fnd_message.set_name('BEN','BEN_94053_ADMIN_PP_NO_POSITION');
220: ben_batch_utils.write(fnd_message.get);
221: end if;
222: if(upper(l_no_paybasis_warn)='Y') then
223: fnd_message.set_name('BEN','BEN_94054_ADMIN_PP_NO_PAYBASIS');
224: ben_batch_utils.write(fnd_message.get);
225: end if;
226:
227: if(l_method='SPECIAL') then
220: ben_batch_utils.write(fnd_message.get);
221: end if;
222: if(upper(l_no_paybasis_warn)='Y') then
223: fnd_message.set_name('BEN','BEN_94054_ADMIN_PP_NO_PAYBASIS');
224: ben_batch_utils.write(fnd_message.get);
225: end if;
226:
227: if(l_method='SPECIAL') then
228: fnd_message.set_name('BEN','BEN_94055_ADMIN_PP_SPL_PROCESS');
224: ben_batch_utils.write(fnd_message.get);
225: end if;
226:
227: if(l_method='SPECIAL') then
228: fnd_message.set_name('BEN','BEN_94055_ADMIN_PP_SPL_PROCESS');
229: ben_batch_utils.write(fnd_message.get);
230: fnd_message.set_name('BEN','BEN_94056_ADMIN_PP_SPL_PRC_ABR');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
225: end if;
226:
227: if(l_method='SPECIAL') then
228: fnd_message.set_name('BEN','BEN_94055_ADMIN_PP_SPL_PROCESS');
229: ben_batch_utils.write(fnd_message.get);
230: fnd_message.set_name('BEN','BEN_94056_ADMIN_PP_SPL_PRC_ABR');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
233: ben_batch_utils.write(fnd_message.get);
226:
227: if(l_method='SPECIAL') then
228: fnd_message.set_name('BEN','BEN_94055_ADMIN_PP_SPL_PROCESS');
229: ben_batch_utils.write(fnd_message.get);
230: fnd_message.set_name('BEN','BEN_94056_ADMIN_PP_SPL_PRC_ABR');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
233: ben_batch_utils.write(fnd_message.get);
234: fnd_message.set_name('BEN','BEN_94058_ADMIN_PP_SPL_PRC_MGR');
227: if(l_method='SPECIAL') then
228: fnd_message.set_name('BEN','BEN_94055_ADMIN_PP_SPL_PROCESS');
229: ben_batch_utils.write(fnd_message.get);
230: fnd_message.set_name('BEN','BEN_94056_ADMIN_PP_SPL_PRC_ABR');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
233: ben_batch_utils.write(fnd_message.get);
234: fnd_message.set_name('BEN','BEN_94058_ADMIN_PP_SPL_PRC_MGR');
235: ben_batch_utils.write(fnd_message.get);
228: fnd_message.set_name('BEN','BEN_94055_ADMIN_PP_SPL_PROCESS');
229: ben_batch_utils.write(fnd_message.get);
230: fnd_message.set_name('BEN','BEN_94056_ADMIN_PP_SPL_PRC_ABR');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
233: ben_batch_utils.write(fnd_message.get);
234: fnd_message.set_name('BEN','BEN_94058_ADMIN_PP_SPL_PRC_MGR');
235: ben_batch_utils.write(fnd_message.get);
236: l_clone_all_data_flag := 'Y';
229: ben_batch_utils.write(fnd_message.get);
230: fnd_message.set_name('BEN','BEN_94056_ADMIN_PP_SPL_PRC_ABR');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
233: ben_batch_utils.write(fnd_message.get);
234: fnd_message.set_name('BEN','BEN_94058_ADMIN_PP_SPL_PRC_MGR');
235: ben_batch_utils.write(fnd_message.get);
236: l_clone_all_data_flag := 'Y';
237: elsif (l_method='REPROCESS') then
230: fnd_message.set_name('BEN','BEN_94056_ADMIN_PP_SPL_PRC_ABR');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
233: ben_batch_utils.write(fnd_message.get);
234: fnd_message.set_name('BEN','BEN_94058_ADMIN_PP_SPL_PRC_MGR');
235: ben_batch_utils.write(fnd_message.get);
236: l_clone_all_data_flag := 'Y';
237: elsif (l_method='REPROCESS') then
238: fnd_message.set_name('BEN','BEN_94063_ADMIN_PP_REPROCESS');
231: ben_batch_utils.write(fnd_message.get);
232: fnd_message.set_name('BEN','BEN_94057_ADMIN_PP_SPL_PRC_ELG');
233: ben_batch_utils.write(fnd_message.get);
234: fnd_message.set_name('BEN','BEN_94058_ADMIN_PP_SPL_PRC_MGR');
235: ben_batch_utils.write(fnd_message.get);
236: l_clone_all_data_flag := 'Y';
237: elsif (l_method='REPROCESS') then
238: fnd_message.set_name('BEN','BEN_94063_ADMIN_PP_REPROCESS');
239: ben_batch_utils.write(fnd_message.get);
234: fnd_message.set_name('BEN','BEN_94058_ADMIN_PP_SPL_PRC_MGR');
235: ben_batch_utils.write(fnd_message.get);
236: l_clone_all_data_flag := 'Y';
237: elsif (l_method='REPROCESS') then
238: fnd_message.set_name('BEN','BEN_94063_ADMIN_PP_REPROCESS');
239: ben_batch_utils.write(fnd_message.get);
240: end if;
241:
242: if((l_method='REPROCESS') or (l_method='PH_TO_NORMAL')) then
235: ben_batch_utils.write(fnd_message.get);
236: l_clone_all_data_flag := 'Y';
237: elsif (l_method='REPROCESS') then
238: fnd_message.set_name('BEN','BEN_94063_ADMIN_PP_REPROCESS');
239: ben_batch_utils.write(fnd_message.get);
240: end if;
241:
242: if((l_method='REPROCESS') or (l_method='PH_TO_NORMAL')) then
243: l_backout_and_process_flag := 'Y';
243: l_backout_and_process_flag := 'Y';
244: end if;
245:
246: if(upper(l_past_term_warn)='Y') then
247: fnd_message.set_name('BEN','BEN_94059_ADMIN_PP_PAST_TERM');
248: ben_batch_utils.write(fnd_message.get);
249: end if;
250: if(upper(l_future_term_warn)='Y') then
251: fnd_message.set_name('BEN','BEN_94060_ADMIN_PP_FUTURE_TERM');
244: end if;
245:
246: if(upper(l_past_term_warn)='Y') then
247: fnd_message.set_name('BEN','BEN_94059_ADMIN_PP_PAST_TERM');
248: ben_batch_utils.write(fnd_message.get);
249: end if;
250: if(upper(l_future_term_warn)='Y') then
251: fnd_message.set_name('BEN','BEN_94060_ADMIN_PP_FUTURE_TERM');
252: ben_batch_utils.write(fnd_message.get);
247: fnd_message.set_name('BEN','BEN_94059_ADMIN_PP_PAST_TERM');
248: ben_batch_utils.write(fnd_message.get);
249: end if;
250: if(upper(l_future_term_warn)='Y') then
251: fnd_message.set_name('BEN','BEN_94060_ADMIN_PP_FUTURE_TERM');
252: ben_batch_utils.write(fnd_message.get);
253: end if;
254: if(upper(l_curr_absence_warn)='Y') then
255: fnd_message.set_name('BEN','BEN_94061_ADMIN_PP_CURR_ABSNCE');
248: ben_batch_utils.write(fnd_message.get);
249: end if;
250: if(upper(l_future_term_warn)='Y') then
251: fnd_message.set_name('BEN','BEN_94060_ADMIN_PP_FUTURE_TERM');
252: ben_batch_utils.write(fnd_message.get);
253: end if;
254: if(upper(l_curr_absence_warn)='Y') then
255: fnd_message.set_name('BEN','BEN_94061_ADMIN_PP_CURR_ABSNCE');
256: ben_batch_utils.write(fnd_message.get);
251: fnd_message.set_name('BEN','BEN_94060_ADMIN_PP_FUTURE_TERM');
252: ben_batch_utils.write(fnd_message.get);
253: end if;
254: if(upper(l_curr_absence_warn)='Y') then
255: fnd_message.set_name('BEN','BEN_94061_ADMIN_PP_CURR_ABSNCE');
256: ben_batch_utils.write(fnd_message.get);
257: end if;
258: if(upper(l_future_absence_warn)='Y') then
259: fnd_message.set_name('BEN','BEN_94062_ADMIN_PP_FUTUR_ABSNC');
252: ben_batch_utils.write(fnd_message.get);
253: end if;
254: if(upper(l_curr_absence_warn)='Y') then
255: fnd_message.set_name('BEN','BEN_94061_ADMIN_PP_CURR_ABSNCE');
256: ben_batch_utils.write(fnd_message.get);
257: end if;
258: if(upper(l_future_absence_warn)='Y') then
259: fnd_message.set_name('BEN','BEN_94062_ADMIN_PP_FUTUR_ABSNC');
260: ben_batch_utils.write(fnd_message.get);
255: fnd_message.set_name('BEN','BEN_94061_ADMIN_PP_CURR_ABSNCE');
256: ben_batch_utils.write(fnd_message.get);
257: end if;
258: if(upper(l_future_absence_warn)='Y') then
259: fnd_message.set_name('BEN','BEN_94062_ADMIN_PP_FUTUR_ABSNC');
260: ben_batch_utils.write(fnd_message.get);
261: end if;
262:
263: end if;
256: ben_batch_utils.write(fnd_message.get);
257: end if;
258: if(upper(l_future_absence_warn)='Y') then
259: fnd_message.set_name('BEN','BEN_94062_ADMIN_PP_FUTUR_ABSNC');
260: ben_batch_utils.write(fnd_message.get);
261: end if;
262:
263: end if;
264:
328: --l_err := FND_MSG_PUB.GET_DETAIL(p_msg_index => FND_MSG_PUB.G_FIRST);
329: --l_err := replace(FND_MSG_PUB.GET_DETAIL(p_msg_index => FND_MSG_PUB.G_FIRST),chr(0),' ');
330: --l_appl := rtrim(substr(l_err,0,instr(l_err,' ')));
331: --l_err := rtrim(substr(ltrim(substr(l_err,instr(l_err,' '))),0,instr(ltrim(substr(l_err,instr(l_err,' '))),' ')));
332: --fnd_message.set_name (l_appl, l_err);
333: /*
334: FND_MESSAGE.Set_Encoded(FND_MSG_PUB.GET_DETAIL(p_msg_index => FND_MSG_PUB.G_FIRST));
335: */
336:
330: --l_appl := rtrim(substr(l_err,0,instr(l_err,' ')));
331: --l_err := rtrim(substr(ltrim(substr(l_err,instr(l_err,' '))),0,instr(ltrim(substr(l_err,instr(l_err,' '))),' ')));
332: --fnd_message.set_name (l_appl, l_err);
333: /*
334: FND_MESSAGE.Set_Encoded(FND_MSG_PUB.GET_DETAIL(p_msg_index => FND_MSG_PUB.G_FIRST));
335: */
336:
337: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
338: if(i=1) then
357: --l_loc
358: );
359: END LOOP;
360: commit;
361: FND_MESSAGE.Set_Encoded(l_err);
362: l_loc := FND_MESSAGE.GET_TOKEN('FND_ERROR_LOCATION_FIELD','Y');
363: l_type := FND_MESSAGE.GET_TOKEN('FND_MESSAGE_TYPE','Y');
364: raise;
365: end;
358: );
359: END LOOP;
360: commit;
361: FND_MESSAGE.Set_Encoded(l_err);
362: l_loc := FND_MESSAGE.GET_TOKEN('FND_ERROR_LOCATION_FIELD','Y');
363: l_type := FND_MESSAGE.GET_TOKEN('FND_MESSAGE_TYPE','Y');
364: raise;
365: end;
366:
359: END LOOP;
360: commit;
361: FND_MESSAGE.Set_Encoded(l_err);
362: l_loc := FND_MESSAGE.GET_TOKEN('FND_ERROR_LOCATION_FIELD','Y');
363: l_type := FND_MESSAGE.GET_TOKEN('FND_MESSAGE_TYPE','Y');
364: raise;
365: end;
366:
367: --
387: fetch c_errors into l_errors;
388: EXIT WHEN c_errors%NOTFOUND;
389:
390: l_message := replace(l_errors,' ',chr(0));
391: fnd_message.set_encoded(l_message);
392: FND_MSG_PUB.ADD;
393:
394: end loop;
395: close c_errors;