271: h_request_id,h_book,h_year,h_locstruct_num,null,chr(0));
272:
273: if h_req1 = 0 then
274:
275: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
276: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
277: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
278:
279: else
272:
273: if h_req1 = 0 then
274:
275: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
276: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
277: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
278:
279: else
280: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
273: if h_req1 = 0 then
274:
275: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
276: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
277: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
278:
279: else
280: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
281: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
276: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
277: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
278:
279: else
280: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
281: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
282: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
283:
284: end if;
277: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
278:
279: else
280: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
281: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
282: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
283:
284: end if;
285:
278:
279: else
280: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
281: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req1,TRUE);
282: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
283:
284: end if;
285:
286: end if;
299: h_request_id,h_book,h_year,h_locstruct_num,null,'ALL','AUTO',h_all_rep,chr(0));
300:
301: if h_req2 = 0 then
302:
303: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
304: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
305: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
306:
307: else
300:
301: if h_req2 = 0 then
302:
303: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
304: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
305: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
306:
307: else
308: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
301: if h_req2 = 0 then
302:
303: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
304: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
305: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
306:
307: else
308: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
309: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
304: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
305: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
306:
307: else
308: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
309: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
310: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
311:
312: end if;
305: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
306:
307: else
308: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
309: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
310: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
311:
312: end if;
313:
306:
307: else
308: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
309: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req2,TRUE);
310: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
311:
312: end if;
313:
314: end if;
327: h_request_id,h_book,h_year,h_locstruct_num,null,'ADDITION','NOT APPLICABLE',h_add_rep,chr(0));
328:
329: if h_req3 = 0 then
330:
331: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
332: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
333: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
334:
335: else
328:
329: if h_req3 = 0 then
330:
331: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
332: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
333: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
334:
335: else
336: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
329: if h_req3 = 0 then
330:
331: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
332: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
333: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
334:
335: else
336: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
337: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
332: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
333: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
334:
335: else
336: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
337: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
338: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
339:
340: end if;
333: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
334:
335: else
336: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
337: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
338: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
339:
340: end if;
341:
334:
335: else
336: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
337: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req3,TRUE);
338: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
339:
340: end if;
341:
342: end if;
355: h_request_id,h_book,h_year,h_locstruct_num,null,chr(0));
356:
357: if h_req4 = 0 then
358:
359: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
360: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
361: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
362:
363: else
356:
357: if h_req4 = 0 then
358:
359: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
360: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
361: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
362:
363: else
364: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
357: if h_req4 = 0 then
358:
359: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_ERROR');
360: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
361: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
362:
363: else
364: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
365: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
360: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
361: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
362:
363: else
364: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
365: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
366: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
367:
368: end if;
361: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
362:
363: else
364: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
365: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
366: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
367:
368: end if;
369:
362:
363: else
364: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_COMP');
365: FND_MESSAGE.SET_TOKEN('REQUEST_ID',h_req4,TRUE);
366: FND_FILE.PUT_LINE(fnd_file.output,fnd_message.get);
367:
368: end if;
369:
370: end if;
370: end if;
371:
372: Exception
373: When NOSETUP_MINOR_CAT then
374: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_NOSETUP_MINOR_CAT');
375: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get);
376:
377: retcode :=2;
378: errbuf := sqlerrm;
371:
372: Exception
373: When NOSETUP_MINOR_CAT then
374: FND_MESSAGE.SET_NAME('OFA','FA_DEPRN_TAX_NOSETUP_MINOR_CAT');
375: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get);
376:
377: retcode :=2;
378: errbuf := sqlerrm;
379: