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

Line 325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------ Rule Based Settlement Report --------------------------------_');

321: IF OZF_DEBUG_HIGH_ON THEN
322: OZF_Utility_PVT.debug_message(l_full_name||': start');
323: END IF;
324:
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Rule Based Settlement Report --------------------------------_*');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
327: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
329:

Line 326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

322: OZF_Utility_PVT.debug_message(l_full_name||': start');
323: END IF;
324:
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Rule Based Settlement Report --------------------------------_*');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
327: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
329:
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 327: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

323: END IF;
324:
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Rule Based Settlement Report --------------------------------_*');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
327: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
329:
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);

Line 328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

324:
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Rule Based Settlement Report --------------------------------_*');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
327: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
329:
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches :' || l_possiblematchTbl.count);

Line 330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
327: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
329:
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches :' || l_possiblematchTbl.count);
333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :' || l_accrualmatchTbl.count);
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);

327: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
329:
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches :' || l_possiblematchTbl.count);
333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :' || l_accrualmatchTbl.count);
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
335:

Line 332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches :' || l_possiblematchTbl.count);

328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
329:
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches :' || l_possiblematchTbl.count);
333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :' || l_accrualmatchTbl.count);
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
335:
336: IF (l_exactmatchTbl.count >0) THEN

Line 333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :' || l_accrualmatchTbl.count);

329:
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches :' || l_possiblematchTbl.count);
333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :' || l_accrualmatchTbl.count);
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
335:
336: IF (l_exactmatchTbl.count >0) THEN
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches ');

Line 334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches :' || l_exactmatchTbl.count);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches :' || l_possiblematchTbl.count);
333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :' || l_accrualmatchTbl.count);
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
335:
336: IF (l_exactmatchTbl.count >0) THEN
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches ');
338: FOR j IN l_exactmatchTbl.FIRST..l_exactmatchTbl.LAST LOOP

Line 337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches ');

333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :' || l_accrualmatchTbl.count);
334: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
335:
336: IF (l_exactmatchTbl.count >0) THEN
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches ');
338: FOR j IN l_exactmatchTbl.FIRST..l_exactmatchTbl.LAST LOOP
339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);
341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);

Line 339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

335:
336: IF (l_exactmatchTbl.count >0) THEN
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches ');
338: FOR j IN l_exactmatchTbl.FIRST..l_exactmatchTbl.LAST LOOP
339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);
341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_amount ||' ' || l_exactmatchTbl(j).currency_code);
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_amount || ' '|| l_exactmatchTbl(j).currency_code);

Line 340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);

336: IF (l_exactmatchTbl.count >0) THEN
337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches ');
338: FOR j IN l_exactmatchTbl.FIRST..l_exactmatchTbl.LAST LOOP
339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);
341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_amount ||' ' || l_exactmatchTbl(j).currency_code);
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_amount || ' '|| l_exactmatchTbl(j).currency_code);
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);

337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '100% Credit Matches ');
338: FOR j IN l_exactmatchTbl.FIRST..l_exactmatchTbl.LAST LOOP
339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);
341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_amount ||' ' || l_exactmatchTbl(j).currency_code);
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_amount || ' '|| l_exactmatchTbl(j).currency_code);
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
345:

Line 342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_amount ||' ' || l_exactmatchTbl(j).currency_code);

338: FOR j IN l_exactmatchTbl.FIRST..l_exactmatchTbl.LAST LOOP
339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);
341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_amount ||' ' || l_exactmatchTbl(j).currency_code);
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_amount || ' '|| l_exactmatchTbl(j).currency_code);
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
345:
346: IF l_exactmatchTbl.exists(j) THEN

Line 343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_amount || ' '|| l_exactmatchTbl(j).currency_code);

339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);
341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_amount ||' ' || l_exactmatchTbl(j).currency_code);
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_amount || ' '|| l_exactmatchTbl(j).currency_code);
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
345:
346: IF l_exactmatchTbl.exists(j) THEN
347: l_exact_match_rec_type := l_exactmatchTbl(j);

Line 344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_number);
341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_memo_number);
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).claim_amount ||' ' || l_exactmatchTbl(j).currency_code);
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_exactmatchTbl(j).credit_amount || ' '|| l_exactmatchTbl(j).currency_code);
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
345:
346: IF l_exactmatchTbl.exists(j) THEN
347: l_exact_match_rec_type := l_exactmatchTbl(j);
348:

Line 390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches');

386: END LOOP;
387: END IF;
388:
389: IF (l_possiblematchTbl.count >0) THEN
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches');
391: FOR k IN l_possiblematchTbl.FIRST..l_possiblematchTbl.LAST LOOP
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);

Line 392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

388:
389: IF (l_possiblematchTbl.count >0) THEN
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches');
391: FOR k IN l_possiblematchTbl.FIRST..l_possiblematchTbl.LAST LOOP
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);
395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_amount || ' ' || l_possiblematchTbl(k).currency_code);
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_amount || ' ' || l_possiblematchTbl(k).currency_code);

Line 393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);

389: IF (l_possiblematchTbl.count >0) THEN
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches');
391: FOR k IN l_possiblematchTbl.FIRST..l_possiblematchTbl.LAST LOOP
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);
395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_amount || ' ' || l_possiblematchTbl(k).currency_code);
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_amount || ' ' || l_possiblematchTbl(k).currency_code);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);

390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Possible Credit Matches');
391: FOR k IN l_possiblematchTbl.FIRST..l_possiblematchTbl.LAST LOOP
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);
395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_amount || ' ' || l_possiblematchTbl(k).currency_code);
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_amount || ' ' || l_possiblematchTbl(k).currency_code);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
398:

Line 395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_amount || ' ' || l_possiblematchTbl(k).currency_code);

391: FOR k IN l_possiblematchTbl.FIRST..l_possiblematchTbl.LAST LOOP
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);
395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_amount || ' ' || l_possiblematchTbl(k).currency_code);
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_amount || ' ' || l_possiblematchTbl(k).currency_code);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
398:
399: IF l_possiblematchTbl.exists(k) THEN

Line 396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_amount || ' ' || l_possiblematchTbl(k).currency_code);

392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);
395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_amount || ' ' || l_possiblematchTbl(k).currency_code);
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_amount || ' ' || l_possiblematchTbl(k).currency_code);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
398:
399: IF l_possiblematchTbl.exists(k) THEN
400: l_poss_match_rec_type := l_possiblematchTbl(k);

Line 397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_number);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Memo #', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_memo_number);
395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).claim_amount || ' ' || l_possiblematchTbl(k).currency_code);
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Credit Amount', 40, ' ') || ': ' || l_possiblematchTbl(k).credit_amount || ' ' || l_possiblematchTbl(k).currency_code);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
398:
399: IF l_possiblematchTbl.exists(k) THEN
400: l_poss_match_rec_type := l_possiblematchTbl(k);
401:

Line 441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :');

437: END LOOP;
438: END IF;
439:
440: IF (l_accrualmatchTbl.count >0) THEN
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :');
442: FOR i IN l_accrualmatchTbl.FIRST..l_accrualmatchTbl.LAST LOOP
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_number);
445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Code', 40, ' ') || ': ' || l_accrualmatchTbl(i).Offer_Code);

Line 443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

439:
440: IF (l_accrualmatchTbl.count >0) THEN
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :');
442: FOR i IN l_accrualmatchTbl.FIRST..l_accrualmatchTbl.LAST LOOP
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_number);
445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Code', 40, ' ') || ': ' || l_accrualmatchTbl(i).Offer_Code);
446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Amount', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_amount || ' ' || l_accrualmatchTbl(i).currency_code);
447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_number);

440: IF (l_accrualmatchTbl.count >0) THEN
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :');
442: FOR i IN l_accrualmatchTbl.FIRST..l_accrualmatchTbl.LAST LOOP
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_number);
445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Code', 40, ' ') || ': ' || l_accrualmatchTbl(i).Offer_Code);
446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Amount', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_amount || ' ' || l_accrualmatchTbl(i).currency_code);
447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
448: IF l_accrualmatchTbl.exists(i) THEN

Line 445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Code', 40, ' ') || ': ' || l_accrualmatchTbl(i).Offer_Code);

441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Accrual Matches :');
442: FOR i IN l_accrualmatchTbl.FIRST..l_accrualmatchTbl.LAST LOOP
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_number);
445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Code', 40, ' ') || ': ' || l_accrualmatchTbl(i).Offer_Code);
446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Amount', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_amount || ' ' || l_accrualmatchTbl(i).currency_code);
447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
448: IF l_accrualmatchTbl.exists(i) THEN
449: l_accrual_match_rec_type := l_accrualmatchTbl(i);

Line 446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Amount', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_amount || ' ' || l_accrualmatchTbl(i).currency_code);

442: FOR i IN l_accrualmatchTbl.FIRST..l_accrualmatchTbl.LAST LOOP
443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_number);
445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Code', 40, ' ') || ': ' || l_accrualmatchTbl(i).Offer_Code);
446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Amount', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_amount || ' ' || l_accrualmatchTbl(i).currency_code);
447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
448: IF l_accrualmatchTbl.exists(i) THEN
449: l_accrual_match_rec_type := l_accrualmatchTbl(i);
450:

Line 447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

443: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Deduction #', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_number);
445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Code', 40, ' ') || ': ' || l_accrualmatchTbl(i).Offer_Code);
446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Amount', 40, ' ') || ': ' || l_accrualmatchTbl(i).claim_amount || ' ' || l_accrualmatchTbl(i).currency_code);
447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
448: IF l_accrualmatchTbl.exists(i) THEN
449: l_accrual_match_rec_type := l_accrualmatchTbl(i);
450:
451: INSERT INTO OZF_RULE_BASED_LOG

Line 489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

485: END LOOP;
486:
487: END IF;
488:
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------------------------------------------------------------------*');
493:

Line 490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );

486:
487: END IF;
488:
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------------------------------------------------------------------*');
493:
494: EXCEPTION

Line 491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

487: END IF;
488:
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------------------------------------------------------------------*');
493:
494: EXCEPTION
495:

Line 492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------');

488:
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------------------------------------------------------------------*');
493:
494: EXCEPTION
495:
496: WHEN FND_API.G_EXC_ERROR THEN

Line 1382: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO RuleBased;
1382: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1383: OZF_UTILITY_PVT.write_conc_log;
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');

Line 1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO RuleBased;
1382: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1383: OZF_UTILITY_PVT.write_conc_log;
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1381: ROLLBACK TO RuleBased;
1382: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1383: OZF_UTILITY_PVT.write_conc_log;
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');

1382: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1383: OZF_UTILITY_PVT.write_conc_log;
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: ROLLBACK TO RuleBased;

Line 1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

1383: OZF_UTILITY_PVT.write_conc_log;
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: ROLLBACK TO RuleBased;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

Line 1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: ROLLBACK TO RuleBased;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1392: OZF_UTILITY_PVT.write_conc_log;

Line 1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: ROLLBACK TO RuleBased;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1392: OZF_UTILITY_PVT.write_conc_log;
1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');

Line 1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: ROLLBACK TO RuleBased;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1392: OZF_UTILITY_PVT.write_conc_log;
1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1390: ROLLBACK TO RuleBased;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1392: OZF_UTILITY_PVT.write_conc_log;
1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1398:

Line 1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');

1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1392: OZF_UTILITY_PVT.write_conc_log;
1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1398:
1399: WHEN OTHERS THEN

Line 1396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

1392: OZF_UTILITY_PVT.write_conc_log;
1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1398:
1399: WHEN OTHERS THEN
1400: ROLLBACK TO RuleBased;

Line 1397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1398:
1399: WHEN OTHERS THEN
1400: ROLLBACK TO RuleBased;
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

Line 1401: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

1397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1398:
1399: WHEN OTHERS THEN
1400: ROLLBACK TO RuleBased;
1401: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1402: IF OZF_DEBUG_HIGH_ON THEN
1403: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1404: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1405: FND_MSG_PUB.Add;

Line 1408: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

1404: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1405: FND_MSG_PUB.Add;
1406: END IF;
1407: OZF_UTILITY_PVT.write_conc_log;
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1409: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1405: FND_MSG_PUB.Add;
1406: END IF;
1407: OZF_UTILITY_PVT.write_conc_log;
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1413: END Start_Rule_Based_Settlement;

Line 1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');

1406: END IF;
1407: OZF_UTILITY_PVT.write_conc_log;
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1413: END Start_Rule_Based_Settlement;
1414:

Line 1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);

1407: OZF_UTILITY_PVT.write_conc_log;
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1413: END Start_Rule_Based_Settlement;
1414:
1415:

Line 1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1408: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1413: END Start_Rule_Based_Settlement;
1414:
1415:
1416: End OZF_claim_Utility_pvt;