287: -- End Bug 8985010
288:
289: if h_req1 = 0 then
290:
291: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
292: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
293: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
294:
295: else
288:
289: if h_req1 = 0 then
290:
291: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
292: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
293: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
294:
295: else
296: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
289: if h_req1 = 0 then
290:
291: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
292: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
293: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
294:
295: else
296: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
297: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
292: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
293: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
294:
295: else
296: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
297: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
298: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
299:
300: end if;
293: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
294:
295: else
296: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
297: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
298: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
299:
300: end if;
301:
294:
295: else
296: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
297: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
298: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
299:
300: end if;
301:
302: end if;
315: h_request_id,h_book,h_year,h_locstruct_num,null,'ALL','AUTO',h_all_rep,chr(0));
316:
317: if h_req2 = 0 then
318:
319: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
320: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
321: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
322:
323: else
316:
317: if h_req2 = 0 then
318:
319: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
320: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
321: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
322:
323: else
324: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
317: if h_req2 = 0 then
318:
319: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
320: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
321: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
322:
323: else
324: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
325: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
320: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
321: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
322:
323: else
324: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
325: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
326: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
327:
328: end if;
321: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
322:
323: else
324: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
325: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
326: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
327:
328: end if;
329:
322:
323: else
324: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
325: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
326: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
327:
328: end if;
329:
330: end if;
343: h_request_id,h_book,h_year,h_locstruct_num,null,'ADDITION','NOT APPLICABLE',h_add_rep,chr(0));
344:
345: if h_req3 = 0 then
346:
347: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
348: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
349: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
350:
351: else
344:
345: if h_req3 = 0 then
346:
347: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
348: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
349: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
350:
351: else
352: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
345: if h_req3 = 0 then
346:
347: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
348: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
349: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
350:
351: else
352: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
353: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
348: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
349: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
350:
351: else
352: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
353: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
354: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
355:
356: end if;
349: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
350:
351: else
352: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
353: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
354: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
355:
356: end if;
357:
350:
351: else
352: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
353: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
354: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
355:
356: end if;
357:
358: end if;
371: h_request_id,h_book,h_year,h_locstruct_num,null,chr(0));
372:
373: if h_req4 = 0 then
374:
375: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
376: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
377: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
378:
379: else
372:
373: if h_req4 = 0 then
374:
375: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
376: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
377: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
378:
379: else
380: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
373: if h_req4 = 0 then
374:
375: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
376: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
377: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
378:
379: else
380: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
381: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
376: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
377: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
378:
379: else
380: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
381: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
382: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
383:
384: end if;
377: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
378:
379: else
380: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
381: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
382: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
383:
384: end if;
385:
378:
379: else
380: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
381: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
382: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
383:
384: end if;
385:
386: end if;
386: end if;
387:
388: Exception
389: When NOSETUP_MINOR_CAT then
390: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_NOSETUP_MINOR_CAT');
391: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get);
392:
393: retcode :=2;
394: errbuf := sqlerrm;
387:
388: Exception
389: When NOSETUP_MINOR_CAT then
390: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_NOSETUP_MINOR_CAT');
391: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get);
392:
393: retcode :=2;
394: errbuf := sqlerrm;
395: