261: return l_output_value;
262:
263: Exception
264: when others then
265: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
266: fnd_file.put_line (fnd_file.LOG, 'input_value ' ||l_input_value );
267:
268: fnd_message.raise_error;
269: end;
262:
263: Exception
264: when others then
265: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
266: fnd_file.put_line (fnd_file.LOG, 'input_value ' ||l_input_value );
267:
268: fnd_message.raise_error;
269: end;
270:
287: from dual;
288: return l_output_value;
289: Exception
290: when others then
291: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
292: fnd_file.put_line (fnd_file.LOG, 'input_value ' ||l_input_value );
293: fnd_file.put_line (fnd_file.LOG, 'cut to size ' ||l_cut_to_size);
294:
295: fnd_message.raise_error;
288: return l_output_value;
289: Exception
290: when others then
291: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
292: fnd_file.put_line (fnd_file.LOG, 'input_value ' ||l_input_value );
293: fnd_file.put_line (fnd_file.LOG, 'cut to size ' ||l_cut_to_size);
294:
295: fnd_message.raise_error;
296: end;
289: Exception
290: when others then
291: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
292: fnd_file.put_line (fnd_file.LOG, 'input_value ' ||l_input_value );
293: fnd_file.put_line (fnd_file.LOG, 'cut to size ' ||l_cut_to_size);
294:
295: fnd_message.raise_error;
296: end;
297:
329:
330: return l_description;
331: exception
332: when Others then
333: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
334: fnd_file.put_line (fnd_file.LOG, 'effective date ' ||l_effective_date );
335: fnd_file.put_line (fnd_file.LOG, 'lookup_type ' ||l_lookup_type );
336: fnd_file.put_line (fnd_file.LOG, 'lookup_code ' ||l_lookup_code );
337:
330: return l_description;
331: exception
332: when Others then
333: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
334: fnd_file.put_line (fnd_file.LOG, 'effective date ' ||l_effective_date );
335: fnd_file.put_line (fnd_file.LOG, 'lookup_type ' ||l_lookup_type );
336: fnd_file.put_line (fnd_file.LOG, 'lookup_code ' ||l_lookup_code );
337:
338: fnd_message.raise_error;
331: exception
332: when Others then
333: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
334: fnd_file.put_line (fnd_file.LOG, 'effective date ' ||l_effective_date );
335: fnd_file.put_line (fnd_file.LOG, 'lookup_type ' ||l_lookup_type );
336: fnd_file.put_line (fnd_file.LOG, 'lookup_code ' ||l_lookup_code );
337:
338: fnd_message.raise_error;
339: end;
332: when Others then
333: fnd_file.put_line (fnd_file.LOG, 'Error: ' || sqlerrm);
334: fnd_file.put_line (fnd_file.LOG, 'effective date ' ||l_effective_date );
335: fnd_file.put_line (fnd_file.LOG, 'lookup_type ' ||l_lookup_type );
336: fnd_file.put_line (fnd_file.LOG, 'lookup_code ' ||l_lookup_code );
337:
338: fnd_message.raise_error;
339: end;
340: END; -- Package Body PAY_GB_P11D_MAGTAPE