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_SETTLEMENT_DOC_PVT dependencies on FND_FILE

Line 1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_rec.claim_number);

1370: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1371: RAISE FND_API.g_exc_unexpected_error;
1372: END IF;
1373:
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_rec.claim_number);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Reopened. ');
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1377:
1378: IF OZF_DEBUG_HIGH_ON THEN

Line 1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Reopened. ');

1371: RAISE FND_API.g_exc_unexpected_error;
1372: END IF;
1373:
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_rec.claim_number);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Reopened. ');
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1377:
1378: IF OZF_DEBUG_HIGH_ON THEN
1379: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');

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

1372: END IF;
1373:
1374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_rec.claim_number);
1375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Reopened. ');
1376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1377:
1378: IF OZF_DEBUG_HIGH_ON THEN
1379: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
1380: END IF;

Line 2916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||p_claim_setl_rec.amount_settled);

2912: l_rma_cm_total_amount := NVL(l_rma_cm_line_amount,0) + NVL(l_rma_cm_tax_amount,0) + NVL(l_rma_cm_freight_amount,0);
2913:
2914: l_difference_amount := p_claim_setl_rec.amount_settled + l_rma_cm_total_amount;
2915:
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||p_claim_setl_rec.amount_settled);
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||p_claim_setl_rec.amount_remaining);
2918:
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);

Line 2917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||p_claim_setl_rec.amount_remaining);

2913:
2914: l_difference_amount := p_claim_setl_rec.amount_settled + l_rma_cm_total_amount;
2915:
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||p_claim_setl_rec.amount_settled);
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||p_claim_setl_rec.amount_remaining);
2918:
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);
2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);

Line 2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);

2915:
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||p_claim_setl_rec.amount_settled);
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||p_claim_setl_rec.amount_remaining);
2918:
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);
2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo freight amount = '||l_rma_cm_freight_amount);
2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');

Line 2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);

2916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||p_claim_setl_rec.amount_settled);
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||p_claim_setl_rec.amount_remaining);
2918:
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);
2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo freight amount = '||l_rma_cm_freight_amount);
2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);

Line 2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);

2917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||p_claim_setl_rec.amount_remaining);
2918:
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);
2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo freight amount = '||l_rma_cm_freight_amount);
2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
2925:

Line 2922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo freight amount = '||l_rma_cm_freight_amount);

2918:
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);
2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo freight amount = '||l_rma_cm_freight_amount);
2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
2925:
2926:

Line 2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');

2919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo total amount = '||l_rma_cm_total_amount);
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);
2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo freight amount = '||l_rma_cm_freight_amount);
2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
2925:
2926:
2927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || p_claim_setl_rec.amount_settled);

Line 2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);

2920: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo amount = '||l_rma_cm_line_amount);
2921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo tax amount = '||l_rma_cm_tax_amount);
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RMA Credit Memo freight amount = '||l_rma_cm_freight_amount);
2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
2925:
2926:
2927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || p_claim_setl_rec.amount_settled);
2928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || p_claim_setl_rec.amount_remaining);

Line 2927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || p_claim_setl_rec.amount_settled);

2923: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
2925:
2926:
2927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || p_claim_setl_rec.amount_settled);
2928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || p_claim_setl_rec.amount_remaining);
2929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' RMA Total Amount : ' || l_rma_cm_total_amount);
2930:
2931:

Line 2928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || p_claim_setl_rec.amount_remaining);

2924: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
2925:
2926:
2927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || p_claim_setl_rec.amount_settled);
2928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || p_claim_setl_rec.amount_remaining);
2929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' RMA Total Amount : ' || l_rma_cm_total_amount);
2930:
2931:
2932:

Line 2929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' RMA Total Amount : ' || l_rma_cm_total_amount);

2925:
2926:
2927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || p_claim_setl_rec.amount_settled);
2928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || p_claim_setl_rec.amount_remaining);
2929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' RMA Total Amount : ' || l_rma_cm_total_amount);
2930:
2931:
2932:
2933: -- OVERPAYMENT and CHARGE claim_class cannot be settled by RMA

Line 2986: fnd_file.put_line(fnd_file.log, 'Tax Amount '||l_upd_claim_rec.tax_amount);

2982: l_upd_claim_rec.amount_remaining := l_upd_claim_rec.amount - l_upd_claim_rec.amount_adjusted -
2983: l_upd_claim_rec.amount_settled -
2984: l_upd_claim_rec.tax_amount;
2985:
2986: fnd_file.put_line(fnd_file.log, 'Tax Amount '||l_upd_claim_rec.tax_amount);
2987: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_upd_claim_rec.amount_remaining);
2988: Update_Claim_Tax_Amount(
2989: p_claim_rec => l_upd_claim_rec
2990: ,x_return_status => l_return_status

Line 2987: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_upd_claim_rec.amount_remaining);

2983: l_upd_claim_rec.amount_settled -
2984: l_upd_claim_rec.tax_amount;
2985:
2986: fnd_file.put_line(fnd_file.log, 'Tax Amount '||l_upd_claim_rec.tax_amount);
2987: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_upd_claim_rec.amount_remaining);
2988: Update_Claim_Tax_Amount(
2989: p_claim_rec => l_upd_claim_rec
2990: ,x_return_status => l_return_status
2991: ,x_msg_data => x_msg_data

Line 3041: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);

3037: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3038: RAISE FND_API.g_exc_unexpected_error;
3039: END IF;
3040:
3041: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);
3042: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');
3043:
3044: END IF;
3045:

Line 3042: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');

3038: RAISE FND_API.g_exc_unexpected_error;
3039: END IF;
3040:
3041: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);
3042: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');
3043:
3044: END IF;
3045:
3046: -- re-query claim here because amount_remaining is changed

Line 3062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Recalculated Settlement Amount = '||l_settlement_amount);

3058: -- Bug3951827: Settlement Amount is recalculated.
3059: -- Bug4365819: Calculate settlement amount before write off
3060: l_settlement_amount :=( NVL(l_claim_rec.amount_settled, 0) + NVL(l_claim_rec.tax_amount, 0)) ;
3061:
3062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Recalculated Settlement Amount = '||l_settlement_amount);
3063:
3064:
3065: -- -----------------------------------------------
3066: -- Bug4087329: Write Off

Line 3087: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Write Off ');

3083: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3084: RAISE FND_API.g_exc_unexpected_error;
3085: END IF;
3086:
3087: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Write Off ');
3088:
3089: -- re-query claim here because amount_remaining is changed
3090: OZF_AR_PAYMENT_PVT.Query_Claim(
3091: p_claim_id => p_claim_setl_rec.claim_id

Line 3187: FND_FILE.PUT_LINE(FND_FILE.LOG, p_claim_setl_rec.claim_number||' --> Success.');

3183:
3184: END IF;
3185:
3186:
3187: FND_FILE.PUT_LINE(FND_FILE.LOG, p_claim_setl_rec.claim_number||' --> Success.');
3188: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||p_claim_setl_rec.claim_number||' -------------*/');
3189:
3190: IF OZF_DEBUG_HIGH_ON THEN
3191: OZF_Utility_PVT.debug_message(l_full_name||' : end');

Line 3188: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||p_claim_setl_rec.claim_number||' -------------/');

3184: END IF;
3185:
3186:
3187: FND_FILE.PUT_LINE(FND_FILE.LOG, p_claim_setl_rec.claim_number||' --> Success.');
3188: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||p_claim_setl_rec.claim_number||' -------------*/');
3189:
3190: IF OZF_DEBUG_HIGH_ON THEN
3191: OZF_Utility_PVT.debug_message(l_full_name||' : end');
3192: END IF;

Line 3433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

3429: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
3430:
3431: l_stmt_debug := fnd_dsql.get_text(TRUE);
3432:
3433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3434:
3435: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

Line 3502: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_fetch(i).claim_number||' --------------/');

3498: FETCH csr_rma_status INTO l_rma_status;
3499: CLOSE csr_rma_status;
3500:
3501: IF l_rma_status = 'CANCELLED' THEN
3502: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Status is Cancelled ' );
3504:
3505: Process_Cancelled_Setl_Doc(
3506: p_claim_id => l_claim_rma_fetch(i).claim_id

Line 3503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Status is Cancelled ' );

3499: CLOSE csr_rma_status;
3500:
3501: IF l_rma_status = 'CANCELLED' THEN
3502: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Status is Cancelled ' );
3504:
3505: Process_Cancelled_Setl_Doc(
3506: p_claim_id => l_claim_rma_fetch(i).claim_id
3507: ,x_return_status => l_return_status

Line 3538: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AR Transactinn# = ' || l_settlement_doc_tbl(j).settlement_number);

3534: IF j IS NOT NULL THEN
3535: LOOP
3536: IF l_settlement_doc_tbl(j).settlement_id IS NOT NULL AND
3537: l_settlement_doc_tbl(j).settlement_id <> FND_API.g_miss_num THEN
3538: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AR Transactinn# = ' || l_settlement_doc_tbl(j).settlement_number);
3539: Create_Settlement_Doc(
3540: p_api_version_number => l_api_version,
3541: p_init_msg_list => FND_API.g_false,
3542: p_commit => FND_API.g_false,

Line 3605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');

3601:
3602: EXCEPTION
3603: WHEN FND_API.G_EXC_ERROR THEN
3604: ROLLBACK TO RMA_CR_FETCH;
3605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');
3606: OZF_UTILITY_PVT.write_conc_log;
3607: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3608:
3609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3607: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_fetch(i).claim_number||' --------------/');

3603: WHEN FND_API.G_EXC_ERROR THEN
3604: ROLLBACK TO RMA_CR_FETCH;
3605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');
3606: OZF_UTILITY_PVT.write_conc_log;
3607: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3608:
3609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3610: ROLLBACK TO RMA_CR_FETCH;
3611: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');

Line 3611: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');

3607: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3608:
3609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3610: ROLLBACK TO RMA_CR_FETCH;
3611: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');
3612: OZF_UTILITY_PVT.write_conc_log;
3613: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3614:
3615: WHEN OTHERS THEN

Line 3613: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_fetch(i).claim_number||' --------------/');

3609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3610: ROLLBACK TO RMA_CR_FETCH;
3611: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');
3612: OZF_UTILITY_PVT.write_conc_log;
3613: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3614:
3615: WHEN OTHERS THEN
3616: ROLLBACK TO RMA_CR_FETCH;
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');

Line 3617: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');

3613: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3614:
3615: WHEN OTHERS THEN
3616: ROLLBACK TO RMA_CR_FETCH;
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');
3618: OZF_UTILITY_PVT.write_conc_log;
3619: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3620:
3621: END;

Line 3619: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_fetch(i).claim_number||' --------------/');

3615: WHEN OTHERS THEN
3616: ROLLBACK TO RMA_CR_FETCH;
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_fetch(i).claim_number||' --> Failed in Fetch.');
3618: OZF_UTILITY_PVT.write_conc_log;
3619: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_fetch(i).claim_number||' --------------*/');
3620:
3621: END;
3622: END LOOP;
3623: END IF; -- end if l_claim_rma_fetch.count > 0

Line 3642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

3638: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
3639:
3640: l_stmt_debug := fnd_dsql.get_text(TRUE);
3641:
3642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3643:
3644: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

Line 3708: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_setl(i).claim_number||' --------------/');

3704: WHEN OTHERS THEN
3705: RAISE LOCK_EXCEPTION;
3706: END;
3707:
3708: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_rma_setl(i).claim_number);
3710:
3711: Get_RMA_Setl_Doc_Tbl(
3712: p_claim_id => l_claim_rma_setl(i).claim_id,

Line 3709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_rma_setl(i).claim_number);

3705: RAISE LOCK_EXCEPTION;
3706: END;
3707:
3708: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_rma_setl(i).claim_number);
3710:
3711: Get_RMA_Setl_Doc_Tbl(
3712: p_claim_id => l_claim_rma_setl(i).claim_id,
3713: x_settlement_doc_tbl => l_settlement_doc_tbl,

Line 3748: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Success. ');

3744: RAISE FND_API.g_exc_error;
3745: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3746: RAISE FND_API.g_exc_unexpected_error;
3747: END IF;
3748: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Success. ');
3749: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3750: l_successful_claims := l_successful_claims + 1;
3751: END IF; -- end if l_claim_rma_setl.claim_id is not null and g_miss_num
3752: EXCEPTION

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

3745: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3746: RAISE FND_API.g_exc_unexpected_error;
3747: END IF;
3748: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Success. ');
3749: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3750: l_successful_claims := l_successful_claims + 1;
3751: END IF; -- end if l_claim_rma_setl.claim_id is not null and g_miss_num
3752: EXCEPTION
3753: WHEN FND_API.G_EXC_ERROR THEN

Line 3755: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');

3751: END IF; -- end if l_claim_rma_setl.claim_id is not null and g_miss_num
3752: EXCEPTION
3753: WHEN FND_API.G_EXC_ERROR THEN
3754: ROLLBACK TO RMA_SETL;
3755: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3756: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3757: OZF_UTILITY_PVT.write_conc_log;
3758: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

Line 3758: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_setl(i).claim_number||' --------------/');

3754: ROLLBACK TO RMA_SETL;
3755: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3756: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3757: OZF_UTILITY_PVT.write_conc_log;
3758: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3760: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3762: l_failed_claims := l_failed_claims + 1;

Line 3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

3755: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3756: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3757: OZF_UTILITY_PVT.write_conc_log;
3758: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3760: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3762: l_failed_claims := l_failed_claims + 1;
3763:

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

3756: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3757: OZF_UTILITY_PVT.write_conc_log;
3758: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3760: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3762: l_failed_claims := l_failed_claims + 1;
3763:
3764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3757: OZF_UTILITY_PVT.write_conc_log;
3758: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3760: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3762: l_failed_claims := l_failed_claims + 1;
3763:
3764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3765: ROLLBACK TO RMA_SETL;

Line 3766: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');

3762: l_failed_claims := l_failed_claims + 1;
3763:
3764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3765: ROLLBACK TO RMA_SETL;
3766: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3767: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3768: OZF_UTILITY_PVT.write_conc_log;
3769: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

Line 3769: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_setl(i).claim_number||' --------------/');

3765: ROLLBACK TO RMA_SETL;
3766: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3767: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3768: OZF_UTILITY_PVT.write_conc_log;
3769: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3773: l_failed_claims := l_failed_claims + 1;

Line 3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

3766: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3767: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3768: OZF_UTILITY_PVT.write_conc_log;
3769: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3773: l_failed_claims := l_failed_claims + 1;
3774:

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

3767: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3768: OZF_UTILITY_PVT.write_conc_log;
3769: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3773: l_failed_claims := l_failed_claims + 1;
3774:
3775: WHEN OTHERS THEN

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

3768: OZF_UTILITY_PVT.write_conc_log;
3769: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3773: l_failed_claims := l_failed_claims + 1;
3774:
3775: WHEN OTHERS THEN
3776: ROLLBACK TO RMA_SETL;

Line 3777: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');

3773: l_failed_claims := l_failed_claims + 1;
3774:
3775: WHEN OTHERS THEN
3776: ROLLBACK TO RMA_SETL;
3777: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3778: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3779: OZF_UTILITY_PVT.write_conc_log;
3780: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

Line 3780: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_rma_setl(i).claim_number||' --------------/');

3776: ROLLBACK TO RMA_SETL;
3777: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3778: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3779: OZF_UTILITY_PVT.write_conc_log;
3780: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
3783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3784: l_failed_claims := l_failed_claims + 1;

Line 3781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

3777: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_rma_setl(i).claim_number||' --> Failed in Settlement.');
3778: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3779: OZF_UTILITY_PVT.write_conc_log;
3780: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
3783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3784: l_failed_claims := l_failed_claims + 1;
3785:

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

3778: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3779: OZF_UTILITY_PVT.write_conc_log;
3780: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
3783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3784: l_failed_claims := l_failed_claims + 1;
3785:
3786: END;

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

3779: OZF_UTILITY_PVT.write_conc_log;
3780: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
3783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3784: l_failed_claims := l_failed_claims + 1;
3785:
3786: END;
3787: END LOOP;

Line 3799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for RMA Settlement : ' || l_successful_claims);

3795: END IF;
3796: IF OZF_DEBUG_HIGH_ON THEN
3797: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
3798: END IF;
3799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for RMA Settlement : ' || l_successful_claims);
3800: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for RMA Settlement : ' || l_failed_claims);
3801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for RMA Settlement : ' || l_reopened_claims);
3802:
3803: EXCEPTION

Line 3800: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for RMA Settlement : ' || l_failed_claims);

3796: IF OZF_DEBUG_HIGH_ON THEN
3797: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
3798: END IF;
3799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for RMA Settlement : ' || l_successful_claims);
3800: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for RMA Settlement : ' || l_failed_claims);
3801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for RMA Settlement : ' || l_reopened_claims);
3802:
3803: EXCEPTION
3804: WHEN OTHERS THEN

Line 3801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for RMA Settlement : ' || l_reopened_claims);

3797: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
3798: END IF;
3799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for RMA Settlement : ' || l_successful_claims);
3800: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for RMA Settlement : ' || l_failed_claims);
3801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for RMA Settlement : ' || l_reopened_claims);
3802:
3803: EXCEPTION
3804: WHEN OTHERS THEN
3805: ROLLBACK TO Get_RMA_Settlement;

Line 3815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement Failed.');

3811: p_encoded => FND_API.g_false,
3812: p_count => x_msg_count,
3813: p_data => x_msg_data
3814: );
3815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement Failed.');
3816: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
3817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3818: End Get_RMA_Settlement;
3819:

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

3812: p_count => x_msg_count,
3813: p_data => x_msg_data
3814: );
3815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement Failed.');
3816: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
3817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3818: End Get_RMA_Settlement;
3819:
3820:

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

3813: p_data => x_msg_data
3814: );
3815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement Failed.');
3816: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
3817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3818: End Get_RMA_Settlement;
3819:
3820:
3821: ---------------------------------------------------------------------

Line 3954: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

3950: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
3951:
3952: l_stmt_debug := fnd_dsql.get_text(TRUE);
3953:
3954: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3955:
3956: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

Line 4039: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------- '||l_claim_id_ver(i).claim_number||' --------------');

4035: END IF;
4036:
4037: IF l_settlement_doc_tbl.count > 0 THEN
4038:
4039: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------- '||l_claim_id_ver(i).claim_number||' --------------');
4040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_id_ver(i).claim_number);
4041:
4042: -- ----------------
4043: -- 1. Query Claim

Line 4040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_id_ver(i).claim_number);

4036:
4037: IF l_settlement_doc_tbl.count > 0 THEN
4038:
4039: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------- '||l_claim_id_ver(i).claim_number||' --------------');
4040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_id_ver(i).claim_number);
4041:
4042: -- ----------------
4043: -- 1. Query Claim
4044: -- ----------------

Line 4099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||l_claim_rec.amount_settled);

4095: l_cm_dm_total_amount := l_cm_dm_amount + l_cm_dm_tax_amount + l_cm_dm_freight_amount;
4096:
4097: l_difference_amount := l_claim_rec.amount_settled + l_cm_dm_total_amount;
4098:
4099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||l_claim_rec.amount_settled);
4100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||l_claim_rec.amount_remaining);
4101:
4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);
4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);

Line 4100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||l_claim_rec.amount_remaining);

4096:
4097: l_difference_amount := l_claim_rec.amount_settled + l_cm_dm_total_amount;
4098:
4099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||l_claim_rec.amount_settled);
4100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||l_claim_rec.amount_remaining);
4101:
4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);
4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);

Line 4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);

4098:
4099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||l_claim_rec.amount_settled);
4100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||l_claim_rec.amount_remaining);
4101:
4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);
4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);
4105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo freight amount = '||l_cm_dm_freight_amount);
4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');

Line 4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);

4099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount settled = '||l_claim_rec.amount_settled);
4100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||l_claim_rec.amount_remaining);
4101:
4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);
4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);
4105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo freight amount = '||l_cm_dm_freight_amount);
4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);

Line 4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);

4100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'claim amount remaining = '||l_claim_rec.amount_remaining);
4101:
4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);
4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);
4105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo freight amount = '||l_cm_dm_freight_amount);
4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
4108:

Line 4105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo freight amount = '||l_cm_dm_freight_amount);

4101:
4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);
4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);
4105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo freight amount = '||l_cm_dm_freight_amount);
4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
4108:
4109:

Line 4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');

4102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo total amount = '||l_cm_dm_total_amount);
4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);
4105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo freight amount = '||l_cm_dm_freight_amount);
4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
4108:
4109:
4110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || l_claim_rec.amount_settled);

Line 4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);

4103: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo line amount = '||l_cm_dm_amount);
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo tax amount = '||l_cm_dm_tax_amount);
4105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Credit/Debit Memo freight amount = '||l_cm_dm_freight_amount);
4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
4108:
4109:
4110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || l_claim_rec.amount_settled);
4111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || l_claim_rec.amount_remaining);

Line 4110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || l_claim_rec.amount_settled);

4106: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ----');
4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
4108:
4109:
4110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || l_claim_rec.amount_settled);
4111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || l_claim_rec.amount_remaining);
4112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit/Debit Amount : ' || l_cm_dm_total_amount);
4113:
4114: -- Bug3805485: Tax Amount Calculation

Line 4111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || l_claim_rec.amount_remaining);

4107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference Amount = '||l_difference_amount);
4108:
4109:
4110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || l_claim_rec.amount_settled);
4111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || l_claim_rec.amount_remaining);
4112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit/Debit Amount : ' || l_cm_dm_total_amount);
4113:
4114: -- Bug3805485: Tax Amount Calculation
4115: IF ABS(l_difference_amount) > 0 AND Is_Tax_Inclusive(l_deduction_type,l_claim_rec.org_id) THEN

Line 4112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit/Debit Amount : ' || l_cm_dm_total_amount);

4108:
4109:
4110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Settled : ' || l_claim_rec.amount_settled);
4111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Amount Remaining : ' || l_claim_rec.amount_remaining);
4112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit/Debit Amount : ' || l_cm_dm_total_amount);
4113:
4114: -- Bug3805485: Tax Amount Calculation
4115: IF ABS(l_difference_amount) > 0 AND Is_Tax_Inclusive(l_deduction_type,l_claim_rec.org_id) THEN
4116: -- Calculate other amount and update it in claim tax_amount

Line 4138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Amount = '||l_claim_rec.tax_amount);

4134: l_upd_claim_rec.amount_remaining := l_upd_claim_rec.amount - l_upd_claim_rec.amount_adjusted -
4135: l_upd_claim_rec.amount_settled - l_upd_claim_rec.tax_amount;
4136:
4137:
4138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Amount = '||l_claim_rec.tax_amount);
4139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Remaining Amount = '||l_claim_rec.amount_remaining);
4140:
4141: Update_Claim_Tax_Amount(
4142: p_claim_rec => l_claim_rec

Line 4139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Remaining Amount = '||l_claim_rec.amount_remaining);

4135: l_upd_claim_rec.amount_settled - l_upd_claim_rec.tax_amount;
4136:
4137:
4138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Amount = '||l_claim_rec.tax_amount);
4139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Remaining Amount = '||l_claim_rec.amount_remaining);
4140:
4141: Update_Claim_Tax_Amount(
4142: p_claim_rec => l_claim_rec
4143: ,x_return_status => l_return_status

Line 4200: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);

4196: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4197: RAISE FND_API.g_exc_unexpected_error;
4198: END IF;
4199:
4200: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);
4201: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');
4202: END IF;
4203: END IF;
4204:

Line 4201: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');

4197: RAISE FND_API.g_exc_unexpected_error;
4198: END IF;
4199:
4200: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);
4201: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');
4202: END IF;
4203: END IF;
4204:
4205: -- re-query claim here becasue amount_remaining is changed

Line 4222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Recalculated Settlement Amount = '||l_settlement_doc_tbl(1).settlement_amount);

4218: -- Bug4087329: Settlement Amount is recalculated.
4219: -- Bug4365819: Calculate settlement amount before doing a write off
4220: l_settlement_doc_tbl(1).settlement_amount :=( NVL(l_claim_rec.amount_settled, 0) +
4221: NVL(l_claim_rec.tax_amount, 0)) * -1 ;
4222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Recalculated Settlement Amount = '||l_settlement_doc_tbl(1).settlement_amount);
4223:
4224:
4225: -- -----------------------------------------------
4226: -- Bug4087329: Write Off

Line 4246: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Write Off ');

4242: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4243: RAISE FND_API.g_exc_unexpected_error;
4244: END IF;
4245:
4246: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Write Off ');
4247:
4248: -- re-query claim here becasue amount_remaining is changed
4249: OZF_AR_PAYMENT_PVT.Query_Claim(
4250: p_claim_id => l_claim_id_ver(i).claim_id

Line 4270: fnd_file.put_line(fnd_file.log, 'l_deduction_type '||l_deduction_type);

4266: IF l_claim_id_ver(i).claim_class IN ('DEDUCTION', 'OVERPAYMENT') AND
4267: l_settlement_doc_tbl(1).settlement_id IS NOT NULL AND
4268: l_settlement_doc_tbl(1).settlement_id <> FND_API.G_miss_num THEN
4269:
4270: fnd_file.put_line(fnd_file.log, 'l_deduction_type '||l_deduction_type);
4271:
4272: IF l_deduction_type IN ('SOURCE_DED', 'RECEIPT_DED') THEN
4273: IF l_deduction_type = 'SOURCE_DED' THEN
4274: OZF_CLAIM_SETTLEMENT_PVT.Check_Transaction_Balance(

Line 4292: fnd_file.put_line(fnd_file.log, 'Before Pay_by_Credit_Memo');

4288: END IF;
4289:
4290: IF NOT l_inv_bal_error THEN
4291:
4292: fnd_file.put_line(fnd_file.log, 'Before Pay_by_Credit_Memo');
4293: OZF_AR_PAYMENT_PVT.Pay_by_Credit_Memo(
4294: p_claim_rec => l_claim_rec
4295: ,p_deduction_type => l_deduction_type
4296: ,p_payment_reference_id => l_settlement_doc_tbl(1).settlement_id

Line 4313: fnd_file.put_line(fnd_file.log, 'Before Pay_by_Debit_Memo');

4309:
4310: -- Added for ER#14109799
4311: ELSIF l_deduction_type IN ('RECEIPT_OPM','SOURCE_OPM') THEN
4312:
4313: fnd_file.put_line(fnd_file.log, 'Before Pay_by_Debit_Memo');
4314: OZF_AR_PAYMENT_PVT.Pay_by_Debit_Memo(
4315: p_claim_rec => l_claim_rec
4316: ,p_deduction_type => l_deduction_type
4317: ,p_payment_reference_id => l_settlement_doc_tbl(1).settlement_id

Line 4343: fnd_file.put_line(fnd_file.log, 'Before Create_Settlement_Doc');

4339: l_settlement_doc_tbl(j).settlement_id <> FND_API.g_miss_num THEN
4340: l_settlement_doc_tbl(j).settlement_date := SYSDATE;
4341: l_settlement_doc_tbl(j).payment_method := l_claim_rec.payment_method;
4342:
4343: fnd_file.put_line(fnd_file.log, 'Before Create_Settlement_Doc');
4344: Create_Settlement_Doc(
4345: p_api_version_number => l_api_version,
4346: p_init_msg_list => FND_API.g_false,
4347: p_commit => FND_API.g_false,

Line 4389: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Success.');

4385: END IF; -- end if l_upd_claim_status
4386: END IF; -- end if l_claim_id_ver(i).claim_class IN ('DEDUCTION', 'OVERPAYMENT')
4387:
4388:
4389: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Success.');
4390:
4391: l_successful_claims := l_successful_claims + 1;
4392:
4393: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');

Line 4393: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');

4389: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Success.');
4390:
4391: l_successful_claims := l_successful_claims + 1;
4392:
4393: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4394: END IF; -- end if l_settlement_doc_tbl.count > 0
4395: END IF; -- end if l_claim_id_ver.claim_id is not null and g_miss_num
4396:
4397: EXCEPTION

Line 4400: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4396:
4397: EXCEPTION
4398: WHEN FND_API.G_EXC_ERROR THEN
4399: ROLLBACK TO AR_SETTLEMENT;
4400: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4401: OZF_UTILITY_PVT.write_conc_log;
4402: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4403:
4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

Line 4402: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');

4398: WHEN FND_API.G_EXC_ERROR THEN
4399: ROLLBACK TO AR_SETTLEMENT;
4400: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4401: OZF_UTILITY_PVT.write_conc_log;
4402: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4403:
4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

4400: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4401: OZF_UTILITY_PVT.write_conc_log;
4402: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4403:
4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4407:
4408: l_failed_claims := l_failed_claims + 1;

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

4401: OZF_UTILITY_PVT.write_conc_log;
4402: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4403:
4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4407:
4408: l_failed_claims := l_failed_claims + 1;
4409:

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

4402: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4403:
4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4407:
4408: l_failed_claims := l_failed_claims + 1;
4409:
4410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4412: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4408: l_failed_claims := l_failed_claims + 1;
4409:
4410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4411: ROLLBACK TO AR_SETTLEMENT;
4412: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4413: OZF_UTILITY_PVT.write_conc_log;
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4415:
4416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

Line 4414: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');

4410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4411: ROLLBACK TO AR_SETTLEMENT;
4412: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4413: OZF_UTILITY_PVT.write_conc_log;
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4415:
4416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4418: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

4412: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4413: OZF_UTILITY_PVT.write_conc_log;
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4415:
4416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4418: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4419:
4420: l_failed_claims := l_failed_claims + 1;

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

4413: OZF_UTILITY_PVT.write_conc_log;
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4415:
4416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4418: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4419:
4420: l_failed_claims := l_failed_claims + 1;
4421:

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

4414: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4415:
4416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4418: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4419:
4420: l_failed_claims := l_failed_claims + 1;
4421:
4422: WHEN LOCK_EXCEPTION THEN

Line 4423: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' cannot be proceed again.');

4419:
4420: l_failed_claims := l_failed_claims + 1;
4421:
4422: WHEN LOCK_EXCEPTION THEN
4423: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' cannot be proceed again.');
4424: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4425:
4426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : Claim is locked and cannot be processed.');

Line 4424: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');

4420: l_failed_claims := l_failed_claims + 1;
4421:
4422: WHEN LOCK_EXCEPTION THEN
4423: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' cannot be proceed again.');
4424: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4425:
4426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : Claim is locked and cannot be processed.');
4428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

4422: WHEN LOCK_EXCEPTION THEN
4423: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' cannot be proceed again.');
4424: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4425:
4426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : Claim is locked and cannot be processed.');
4428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4429:
4430: l_failed_claims := l_failed_claims + 1;

Line 4427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : Claim is locked and cannot be processed.');

4423: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' cannot be proceed again.');
4424: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4425:
4426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : Claim is locked and cannot be processed.');
4428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4429:
4430: l_failed_claims := l_failed_claims + 1;
4431:

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

4424: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4425:
4426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : Claim is locked and cannot be processed.');
4428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4429:
4430: l_failed_claims := l_failed_claims + 1;
4431:
4432: WHEN OTHERS THEN

Line 4434: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4430: l_failed_claims := l_failed_claims + 1;
4431:
4432: WHEN OTHERS THEN
4433: ROLLBACK TO AR_SETTLEMENT;
4434: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4435: OZF_UTILITY_PVT.write_conc_log;
4436: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4437:
4438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

Line 4436: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');

4432: WHEN OTHERS THEN
4433: ROLLBACK TO AR_SETTLEMENT;
4434: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4435: OZF_UTILITY_PVT.write_conc_log;
4436: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4437:
4438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

4434: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4435: OZF_UTILITY_PVT.write_conc_log;
4436: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4437:
4438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4441:
4442: l_failed_claims := l_failed_claims + 1;

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

4435: OZF_UTILITY_PVT.write_conc_log;
4436: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4437:
4438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4441:
4442: l_failed_claims := l_failed_claims + 1;
4443: END;

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

4436: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4437:
4438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4441:
4442: l_failed_claims := l_failed_claims + 1;
4443: END;
4444:

Line 4457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for AR Settlement : ' || l_successful_claims);

4453: IF OZF_DEBUG_HIGH_ON THEN
4454: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
4455: END IF;
4456:
4457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for AR Settlement : ' || l_successful_claims);
4458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for AR Settlement : ' || l_failed_claims);
4459:
4460: EXCEPTION
4461: WHEN OTHERS THEN

Line 4458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for AR Settlement : ' || l_failed_claims);

4454: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
4455: END IF;
4456:
4457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for AR Settlement : ' || l_successful_claims);
4458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for AR Settlement : ' || l_failed_claims);
4459:
4460: EXCEPTION
4461: WHEN OTHERS THEN
4462: ROLLBACK TO Get_Receivable_Settlement;

Line 4472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement Failed.');

4468: p_encoded => FND_API.g_false,
4469: p_count => x_msg_count,
4470: p_data => x_msg_data
4471: );
4472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement Failed.');
4473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
4474: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4475: End Get_Receivable_Settlement;
4476:

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

4469: p_count => x_msg_count,
4470: p_data => x_msg_data
4471: );
4472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement Failed.');
4473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
4474: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4475: End Get_Receivable_Settlement;
4476:
4477:

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

4470: p_data => x_msg_data
4471: );
4472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement Failed.');
4473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
4474: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4475: End Get_Receivable_Settlement;
4476:
4477:
4478: ---------------------------------------------------------------------

Line 4633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

4629: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
4630:
4631: l_stmt_debug := fnd_dsql.get_text(TRUE);
4632:
4633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
4634:
4635: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

Line 4684: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_id_ver(i).claim_number||' --------------/');

4680: BEGIN
4681: SAVEPOINT AP_SETTLEMENT;
4682: FND_MSG_PUB.initialize;
4683:
4684: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4685: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_id_ver(i).claim_number);
4686:
4687: -- set to 0 for next claim in loop
4688: l_total_pay_amount := 0;

Line 4685: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_id_ver(i).claim_number);

4681: SAVEPOINT AP_SETTLEMENT;
4682: FND_MSG_PUB.initialize;
4683:
4684: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4685: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_id_ver(i).claim_number);
4686:
4687: -- set to 0 for next claim in loop
4688: l_total_pay_amount := 0;
4689: l_pay_clear_flag := NULL;

Line 4699: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AP Document is Cancelled ' );

4695: CLOSE csr_inv_status;
4696:
4697: IF l_cancelled_date IS NOT NULL THEN
4698:
4699: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AP Document is Cancelled ' );
4700:
4701: -- R12: Handle Document Cancellation
4702: Process_Cancelled_Setl_Doc(
4703: p_claim_id => l_claim_id_ver(i).claim_id

Line 4714: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Deleting settlement docs ' );

4710: RAISE FND_API.g_exc_unexpected_error;
4711: END IF;
4712:
4713: IF l_claim_id_ver(i).payment_method IN ( 'CHECK','EFT','WIRE','AP_DEFAULT') THEN
4714: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Deleting settlement docs ' );
4715: DELETE FROM ozf_settlement_docs_all
4716: WHERE claim_id = l_claim_id_ver(i).claim_id;
4717: END IF;
4718: l_reopened_claims := l_reopened_claims + 1;

Line 4747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Settled = '||l_claim_rec.amount_settled);

4743: END IF;
4744:
4745:
4746: l_difference_amount := l_gross_amt - l_claim_rec.amount_settled ;
4747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Settled = '||l_claim_rec.amount_settled);
4748: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Remaining = '||l_claim_rec.amount_remaining);
4749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Document Gross amount = '||l_gross_amt );
4750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference amount = '||l_difference_amount);
4751:

Line 4748: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Remaining = '||l_claim_rec.amount_remaining);

4744:
4745:
4746: l_difference_amount := l_gross_amt - l_claim_rec.amount_settled ;
4747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Settled = '||l_claim_rec.amount_settled);
4748: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Remaining = '||l_claim_rec.amount_remaining);
4749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Document Gross amount = '||l_gross_amt );
4750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference amount = '||l_difference_amount);
4751:
4752: l_settlement_amount := l_claim_rec.amount_settled;

Line 4749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Document Gross amount = '||l_gross_amt );

4745:
4746: l_difference_amount := l_gross_amt - l_claim_rec.amount_settled ;
4747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Settled = '||l_claim_rec.amount_settled);
4748: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Remaining = '||l_claim_rec.amount_remaining);
4749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Document Gross amount = '||l_gross_amt );
4750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference amount = '||l_difference_amount);
4751:
4752: l_settlement_amount := l_claim_rec.amount_settled;
4753: l_tax_included_flag := FALSE;

Line 4750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference amount = '||l_difference_amount);

4746: l_difference_amount := l_gross_amt - l_claim_rec.amount_settled ;
4747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Settled = '||l_claim_rec.amount_settled);
4748: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount Remaining = '||l_claim_rec.amount_remaining);
4749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Document Gross amount = '||l_gross_amt );
4750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Difference amount = '||l_difference_amount);
4751:
4752: l_settlement_amount := l_claim_rec.amount_settled;
4753: l_tax_included_flag := FALSE;
4754: IF ABS(l_difference_amount) <> 0 AND Is_Tax_Inclusive(l_claim_rec.claim_class,l_claim_rec.org_id)

Line 4832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update settlement doc :: settlement_doc_id='||l_settlement_doc_tbl(j).settlement_id);

4828: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4829: RAISE FND_API.g_exc_unexpected_error;
4830: END IF;
4831:
4832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update settlement doc :: settlement_doc_id='||l_settlement_doc_tbl(j).settlement_id);
4833: END IF;
4834: ELSE
4835: Create_Settlement_Doc(
4836: p_api_version_number => 1.0,

Line 4852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create settlement doc :: settlement_doc_id = '||l_settlement_doc_id);

4848: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4849: RAISE FND_API.g_exc_unexpected_error;
4850: END IF;
4851:
4852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create settlement doc :: settlement_doc_id = '||l_settlement_doc_id);
4853:
4854: END IF; -- l_settle_doc_id IS NOT NULL
4855:
4856: END LOOP;

Line 4858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice amount ='||l_invoice_amount);

4854: END IF; -- l_settle_doc_id IS NOT NULL
4855:
4856: END LOOP;
4857:
4858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice amount ='||l_invoice_amount);
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total payment ='||l_total_pay_amount);
4860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Invoice Amount : ' || l_invoice_amount);
4861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Payment : ' || l_total_pay_amount);
4862:

Line 4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total payment ='||l_total_pay_amount);

4855:
4856: END LOOP;
4857:
4858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice amount ='||l_invoice_amount);
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total payment ='||l_total_pay_amount);
4860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Invoice Amount : ' || l_invoice_amount);
4861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Payment : ' || l_total_pay_amount);
4862:
4863: ------------------------------------------------

Line 4860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Invoice Amount : ' || l_invoice_amount);

4856: END LOOP;
4857:
4858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice amount ='||l_invoice_amount);
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total payment ='||l_total_pay_amount);
4860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Invoice Amount : ' || l_invoice_amount);
4861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Payment : ' || l_total_pay_amount);
4862:
4863: ------------------------------------------------
4864: -- R12: Consider Tax and Split ------

Line 4861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Payment : ' || l_total_pay_amount);

4857:
4858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice amount ='||l_invoice_amount);
4859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total payment ='||l_total_pay_amount);
4860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Invoice Amount : ' || l_invoice_amount);
4861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Payment : ' || l_total_pay_amount);
4862:
4863: ------------------------------------------------
4864: -- R12: Consider Tax and Split ------
4865: ------------------------------------------------

Line 4880: fnd_file.put_line(fnd_file.log, 'Tax Amount '||l_claim_rec.tax_amount);

4876: END IF;
4877: l_claim_rec.amount_remaining := l_claim_rec.amount - l_claim_rec.amount_settled - l_claim_rec.amount_adjusted -
4878: l_claim_rec.tax_amount;
4879:
4880: fnd_file.put_line(fnd_file.log, 'Tax Amount '||l_claim_rec.tax_amount);
4881: fnd_file.put_line(fnd_file.log, 'Amount Remaining '||l_claim_rec.amount_remaining);
4882: Update_Claim_Tax_Amount(
4883: p_claim_rec => l_claim_rec
4884: ,x_return_status => l_return_status

Line 4881: fnd_file.put_line(fnd_file.log, 'Amount Remaining '||l_claim_rec.amount_remaining);

4877: l_claim_rec.amount_remaining := l_claim_rec.amount - l_claim_rec.amount_settled - l_claim_rec.amount_adjusted -
4878: l_claim_rec.tax_amount;
4879:
4880: fnd_file.put_line(fnd_file.log, 'Tax Amount '||l_claim_rec.tax_amount);
4881: fnd_file.put_line(fnd_file.log, 'Amount Remaining '||l_claim_rec.amount_remaining);
4882: Update_Claim_Tax_Amount(
4883: p_claim_rec => l_claim_rec
4884: ,x_return_status => l_return_status
4885: ,x_msg_data => x_msg_data

Line 4921: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);

4917: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4918: RAISE FND_API.g_exc_unexpected_error;
4919: END IF;
4920:
4921: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);
4922: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');
4923: END IF;
4924:
4925: OZF_AR_PAYMENT_PVT.Query_Claim(

Line 4922: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');

4918: RAISE FND_API.g_exc_unexpected_error;
4919: END IF;
4920:
4921: fnd_file.put_line(fnd_file.log, 'Amount Remaning '||l_claim_rec.amount_remaining);
4922: fnd_file.put_line(fnd_file.log, ' Amount Remaining --> Split');
4923: END IF;
4924:
4925: OZF_AR_PAYMENT_PVT.Query_Claim(
4926: p_claim_id => l_claim_id_ver(i).claim_id

Line 4952: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4948: p_payment_status => 'PAID'
4949: );
4950: IF l_return_status = FND_API.g_ret_sts_error THEN
4951: RAISE FND_API.g_exc_error;
4952: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4953: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4954: RAISE FND_API.g_exc_unexpected_error;
4955: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4956: END IF;

Line 4955: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4951: RAISE FND_API.g_exc_error;
4952: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4953: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4954: RAISE FND_API.g_exc_unexpected_error;
4955: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4956: END IF;
4957: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Success.');
4958:
4959: ELSE

Line 4957: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Success.');

4953: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4954: RAISE FND_API.g_exc_unexpected_error;
4955: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4956: END IF;
4957: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Success.');
4958:
4959: ELSE
4960: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> is not CLOSED because amount settled is not fully paid.');
4961: END IF; -- Close Claim

Line 4960: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> is not CLOSED because amount settled is not fully paid.');

4956: END IF;
4957: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Success.');
4958:
4959: ELSE
4960: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> is not CLOSED because amount settled is not fully paid.');
4961: END IF; -- Close Claim
4962:
4963:
4964: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');

Line 4964: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_id_ver(i).claim_number||' --------------/');

4960: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> is not CLOSED because amount settled is not fully paid.');
4961: END IF; -- Close Claim
4962:
4963:
4964: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Success. ');
4966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4967: l_successful_claims := l_successful_claims + 1;
4968:

Line 4965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Success. ');

4961: END IF; -- Close Claim
4962:
4963:
4964: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Success. ');
4966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4967: l_successful_claims := l_successful_claims + 1;
4968:
4969: END IF; -- l_settlement_doc_tbl.count > 0

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

4962:
4963:
4964: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Success. ');
4966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4967: l_successful_claims := l_successful_claims + 1;
4968:
4969: END IF; -- l_settlement_doc_tbl.count > 0
4970: END IF; -- Camcelled;

Line 4975: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4971:
4972: EXCEPTION
4973: WHEN FND_API.G_EXC_ERROR THEN
4974: ROLLBACK TO AP_SETTLEMENT;
4975: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4976: OZF_UTILITY_PVT.write_conc_log;
4977: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4978: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));

Line 4977: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_id_ver(i).claim_number||' --------------/');

4973: WHEN FND_API.G_EXC_ERROR THEN
4974: ROLLBACK TO AP_SETTLEMENT;
4975: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4976: OZF_UTILITY_PVT.write_conc_log;
4977: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4978: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4981: l_failed_claims := l_failed_claims + 1;

Line 4978: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

4974: ROLLBACK TO AP_SETTLEMENT;
4975: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4976: OZF_UTILITY_PVT.write_conc_log;
4977: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4978: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4981: l_failed_claims := l_failed_claims + 1;
4982:

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

4975: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4976: OZF_UTILITY_PVT.write_conc_log;
4977: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4978: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4981: l_failed_claims := l_failed_claims + 1;
4982:
4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4976: OZF_UTILITY_PVT.write_conc_log;
4977: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4978: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4981: l_failed_claims := l_failed_claims + 1;
4982:
4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4984: ROLLBACK TO AP_SETTLEMENT;

Line 4985: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4981: l_failed_claims := l_failed_claims + 1;
4982:
4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4984: ROLLBACK TO AP_SETTLEMENT;
4985: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4986: OZF_UTILITY_PVT.write_conc_log;
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));

Line 4987: FND_FILE.PUT_LINE(FND_FILE.LOG, '/-------------- '||l_claim_id_ver(i).claim_number||' --------------/');

4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4984: ROLLBACK TO AP_SETTLEMENT;
4985: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4986: OZF_UTILITY_PVT.write_conc_log;
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4991: l_failed_claims := l_failed_claims + 1;

Line 4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

4984: ROLLBACK TO AP_SETTLEMENT;
4985: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4986: OZF_UTILITY_PVT.write_conc_log;
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4991: l_failed_claims := l_failed_claims + 1;
4992:

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

4985: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4986: OZF_UTILITY_PVT.write_conc_log;
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4991: l_failed_claims := l_failed_claims + 1;
4992:
4993: WHEN OTHERS THEN

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

4986: OZF_UTILITY_PVT.write_conc_log;
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4991: l_failed_claims := l_failed_claims + 1;
4992:
4993: WHEN OTHERS THEN
4994: ROLLBACK TO AP_SETTLEMENT;

Line 4995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');

4991: l_failed_claims := l_failed_claims + 1;
4992:
4993: WHEN OTHERS THEN
4994: ROLLBACK TO AP_SETTLEMENT;
4995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4996: OZF_UTILITY_PVT.write_conc_log;
4997: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4997: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');

4993: WHEN OTHERS THEN
4994: ROLLBACK TO AP_SETTLEMENT;
4995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4996: OZF_UTILITY_PVT.write_conc_log;
4997: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5000: l_failed_claims := l_failed_claims + 1;
5001: END;

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

4994: ROLLBACK TO AP_SETTLEMENT;
4995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4996: OZF_UTILITY_PVT.write_conc_log;
4997: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5000: l_failed_claims := l_failed_claims + 1;
5001: END;
5002:

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

4995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4996: OZF_UTILITY_PVT.write_conc_log;
4997: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || SQLCODE || ' : ' || SQLERRM);
4999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5000: l_failed_claims := l_failed_claims + 1;
5001: END;
5002:
5003: END LOOP;

Line 5019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for AP Settlement : ' || l_successful_claims);

5015:
5016: IF OZF_DEBUG_HIGH_ON THEN
5017: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
5018: END IF;
5019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for AP Settlement : ' || l_successful_claims);
5020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for AP Settlement : ' || l_failed_claims);
5021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for AP Settlement : ' || l_reopened_claims);
5022:
5023: EXCEPTION

Line 5020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for AP Settlement : ' || l_failed_claims);

5016: IF OZF_DEBUG_HIGH_ON THEN
5017: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
5018: END IF;
5019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for AP Settlement : ' || l_successful_claims);
5020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for AP Settlement : ' || l_failed_claims);
5021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for AP Settlement : ' || l_reopened_claims);
5022:
5023: EXCEPTION
5024: WHEN FND_API.G_EXC_ERROR THEN

Line 5021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for AP Settlement : ' || l_reopened_claims);

5017: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
5018: END IF;
5019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims successfully fetched for AP Settlement : ' || l_successful_claims);
5020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims failed to be fetched for AP Settlement : ' || l_failed_claims);
5021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claims reopened for AP Settlement : ' || l_reopened_claims);
5022:
5023: EXCEPTION
5024: WHEN FND_API.G_EXC_ERROR THEN
5025: ROLLBACK TO Get_Payable_Settlement;

Line 5027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');

5023: EXCEPTION
5024: WHEN FND_API.G_EXC_ERROR THEN
5025: ROLLBACK TO Get_Payable_Settlement;
5026: x_return_status := FND_API.g_ret_sts_error;
5027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5029: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5030: FND_MSG_PUB.Count_And_Get(
5031: p_encoded => FND_API.g_false,

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

5024: WHEN FND_API.G_EXC_ERROR THEN
5025: ROLLBACK TO Get_Payable_Settlement;
5026: x_return_status := FND_API.g_ret_sts_error;
5027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5029: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5030: FND_MSG_PUB.Count_And_Get(
5031: p_encoded => FND_API.g_false,
5032: p_count => x_msg_count,

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

5025: ROLLBACK TO Get_Payable_Settlement;
5026: x_return_status := FND_API.g_ret_sts_error;
5027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5029: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5030: FND_MSG_PUB.Count_And_Get(
5031: p_encoded => FND_API.g_false,
5032: p_count => x_msg_count,
5033: p_data => x_msg_data

Line 5039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');

5035:
5036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5037: ROLLBACK TO Get_Payable_Settlement;
5038: x_return_status := FND_API.g_ret_sts_unexp_error;
5039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5042: FND_MSG_PUB.Count_And_Get(
5043: p_encoded => FND_API.g_false,

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

5036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5037: ROLLBACK TO Get_Payable_Settlement;
5038: x_return_status := FND_API.g_ret_sts_unexp_error;
5039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5042: FND_MSG_PUB.Count_And_Get(
5043: p_encoded => FND_API.g_false,
5044: p_count => x_msg_count,

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

5037: ROLLBACK TO Get_Payable_Settlement;
5038: x_return_status := FND_API.g_ret_sts_unexp_error;
5039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5042: FND_MSG_PUB.Count_And_Get(
5043: p_encoded => FND_API.g_false,
5044: p_count => x_msg_count,
5045: p_data => x_msg_data

Line 5054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');

5050: x_return_status := FND_API.g_ret_sts_unexp_error;
5051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5052: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5053: END IF;
5054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
5056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5057: FND_MSG_PUB.Count_And_Get(
5058: p_encoded => FND_API.g_false,

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

5051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5052: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5053: END IF;
5054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
5056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5057: FND_MSG_PUB.Count_And_Get(
5058: p_encoded => FND_API.g_false,
5059: p_count => x_msg_count,

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

5052: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5053: END IF;
5054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
5056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5057: FND_MSG_PUB.Count_And_Get(
5058: p_encoded => FND_API.g_false,
5059: p_count => x_msg_count,
5060: p_data => x_msg_data

Line 5158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));

5154: IF (l_org_id.COUNT > 0) THEN
5155: FOR m IN l_org_id.FIRST..l_org_id.LAST LOOP
5156: MO_GLOBAL.set_policy_context('S',l_org_id(m));
5157: -- Write OU info to OUT file
5158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
5160: -- Write OU info to LOG file
5161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5162: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');

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

5155: FOR m IN l_org_id.FIRST..l_org_id.LAST LOOP
5156: MO_GLOBAL.set_policy_context('S',l_org_id(m));
5157: -- Write OU info to OUT file
5158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
5160: -- Write OU info to LOG file
5161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5162: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
5163:

Line 5161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));

5157: -- Write OU info to OUT file
5158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
5160: -- Write OU info to LOG file
5161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5162: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
5163:
5164: IF p_claim_class IS NOT NULL THEN
5165: OPEN csr_claim_class_name(p_claim_class);

Line 5162: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');

5158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
5160: -- Write OU info to LOG file
5161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
5162: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
5163:
5164: IF p_claim_class IS NOT NULL THEN
5165: OPEN csr_claim_class_name(p_claim_class);
5166: FETCH csr_claim_class_name INTO l_claim_class_name;

Line 5190: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');

5186: FETCH csr_reason_name INTO l_reason_name;
5187: CLOSE csr_reason_name;
5188: END IF;
5189:
5190: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------ Claims Settlement Fetcher Execution Report -------------------------*');
5192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);

Line 5191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------ Claims Settlement Fetcher Execution Report -------------------------');

5187: CLOSE csr_reason_name;
5188: END IF;
5189:
5190: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------ Claims Settlement Fetcher Execution Report -------------------------*');
5192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);

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

5188: END IF;
5189:
5190: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------ Claims Settlement Fetcher Execution Report -------------------------*');
5192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);

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

5189:
5190: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------ Claims Settlement Fetcher Execution Report -------------------------*');
5192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);

Line 5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);

5190: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------ Claims Settlement Fetcher Execution Report -------------------------*');
5192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);
5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);

Line 5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);

5191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------ Claims Settlement Fetcher Execution Report -------------------------*');
5192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);
5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);

5192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);
5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement : ');

Line 5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);

5193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);
5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement : ');
5201:

Line 5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);

5194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Class', 40, ' ') || ': ' || l_claim_class_name);
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);
5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement : ');
5201:
5202: IF p_payment_method IS NULL OR p_payment_method IN ( 'CREDIT_MEMO', 'DEBIT_MEMO') THEN

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

5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Settlement Method', 40, ' ') || ': ' || l_settlement_method_name);
5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);
5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement : ');
5201:
5202: IF p_payment_method IS NULL OR p_payment_method IN ( 'CREDIT_MEMO', 'DEBIT_MEMO') THEN
5203: Get_Receivable_Settlement(

Line 5200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement : ');

5196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer', 40, ' ') || ': ' || l_customer_name);
5197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Claim Type', 40, ' ') || ': ' || l_claim_type_name);
5198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Reason Code', 40, ' ') || ': ' || l_reason_name);
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Receivable Settlement : ');
5201:
5202: IF p_payment_method IS NULL OR p_payment_method IN ( 'CREDIT_MEMO', 'DEBIT_MEMO') THEN
5203: Get_Receivable_Settlement(
5204: p_api_version_number => 1.0,

Line 5229: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');

5225: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5226: RAISE FND_API.g_exc_unexpected_error;
5227: END IF;
5228:
5229: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5231: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement : ');
5232: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5233: --OZF_UTILITY_PVT.debug_message('== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

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

5226: RAISE FND_API.g_exc_unexpected_error;
5227: END IF;
5228:
5229: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5231: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement : ');
5232: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5233: --OZF_UTILITY_PVT.debug_message('== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
5234: END IF;

Line 5231: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement : ');

5227: END IF;
5228:
5229: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5231: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement : ');
5232: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5233: --OZF_UTILITY_PVT.debug_message('== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
5234: END IF;
5235:

Line 5232: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');

5228:
5229: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AR settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5231: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement : ');
5232: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5233: --OZF_UTILITY_PVT.debug_message('== START: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
5234: END IF;
5235:
5236: IF p_payment_method IS NULL OR p_payment_method IN ( 'CHECK','EFT','WIRE','AP_DEFAULT','AP_DEBIT') THEN

Line 5263: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');

5259: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5260: RAISE FND_API.g_exc_unexpected_error;
5261: END IF;
5262:
5263: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement : ');
5266: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5267: END IF;

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

5260: RAISE FND_API.g_exc_unexpected_error;
5261: END IF;
5262:
5263: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement : ');
5266: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5267: END IF;
5268:

Line 5265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement : ');

5261: END IF;
5262:
5263: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement : ');
5266: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5267: END IF;
5268:
5269: IF p_payment_method IS NULL OR p_payment_method = 'RMA' THEN

Line 5266: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');

5262:
5263: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching AP settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for RMA Settlement : ');
5266: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== START: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =====');
5267: END IF;
5268:
5269: IF p_payment_method IS NULL OR p_payment_method = 'RMA' THEN
5270: Get_RMA_Settlement(

Line 5297: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_RETURN_STATUS ');

5293: RAISE FND_API.g_exc_unexpected_error;
5294: END IF;
5295: /*
5296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5297: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_RETURN_STATUS ');
5298: END IF;
5299: */
5300:
5301: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');

Line 5301: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');

5297: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_RETURN_STATUS ');
5298: END IF;
5299: */
5300:
5301: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5303: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
5304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

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

5298: END IF;
5299: */
5300:
5301: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5303: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
5304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5306: END IF;

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

5299: */
5300:
5301: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5303: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
5304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5306: END IF;
5307:

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

5300:
5301: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5303: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
5304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5306: END IF;
5307:
5308: --OZF_UTILITY_PVT.write_conc_log;

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

5301: FND_FILE.PUT_LINE(FND_FILE.LOG, '===== END: fetching RMA settlement -- time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')||' =======');
5302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5303: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
5304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5306: END IF;
5307:
5308: --OZF_UTILITY_PVT.write_conc_log;
5309: END LOOP;

Line 5318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');

5314: ROLLBACK TO Populate_Settlement_Data;
5315: OZF_UTILITY_PVT.write_conc_log;
5316: ERRBUF := l_msg_data;
5317: RETCODE := 2;
5318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');
5319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5321:
5322: WHEN FND_API.g_exc_unexpected_error THEN

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

5315: OZF_UTILITY_PVT.write_conc_log;
5316: ERRBUF := l_msg_data;
5317: RETCODE := 2;
5318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');
5319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5321:
5322: WHEN FND_API.g_exc_unexpected_error THEN
5323: ROLLBACK TO Populate_Settlement_Data;

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

5316: ERRBUF := l_msg_data;
5317: RETCODE := 2;
5318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');
5319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5321:
5322: WHEN FND_API.g_exc_unexpected_error THEN
5323: ROLLBACK TO Populate_Settlement_Data;
5324: OZF_UTILITY_PVT.write_conc_log;

Line 5327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');

5323: ROLLBACK TO Populate_Settlement_Data;
5324: OZF_UTILITY_PVT.write_conc_log;
5325: ERRBUF := l_msg_data;
5326: RETCODE := 2;
5327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');
5328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5330:
5331: WHEN OTHERS THEN

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

5324: OZF_UTILITY_PVT.write_conc_log;
5325: ERRBUF := l_msg_data;
5326: RETCODE := 2;
5327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');
5328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5330:
5331: WHEN OTHERS THEN
5332: ROLLBACK TO Populate_Settlement_Data;

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

5325: ERRBUF := l_msg_data;
5326: RETCODE := 2;
5327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || l_msg_data ||')');
5328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5330:
5331: WHEN OTHERS THEN
5332: ROLLBACK TO Populate_Settlement_Data;
5333: OZF_UTILITY_PVT.write_conc_log;

Line 5336: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');

5332: ROLLBACK TO Populate_Settlement_Data;
5333: OZF_UTILITY_PVT.write_conc_log;
5334: ERRBUF := substr(sqlerrm, 1, 80);
5335: RETCODE := 2;
5336: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
5337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5339:
5340: End Populate_Settlement_Data;

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

5333: OZF_UTILITY_PVT.write_conc_log;
5334: ERRBUF := substr(sqlerrm, 1, 80);
5335: RETCODE := 2;
5336: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
5337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5339:
5340: End Populate_Settlement_Data;
5341:

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

5334: ERRBUF := substr(sqlerrm, 1, 80);
5335: RETCODE := 2;
5336: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
5337: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
5339:
5340: End Populate_Settlement_Data;
5341:
5342: