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

Line 536: FND_FILE.PUT_LINE (FND_FILE.LOG,'Adjustment Amount: '

532: --------------------------------------------------------
533: -- Process Lines with Adjustment amounts
534: --------------------------------------------------------
535: FOR adj_streams_rec IN adj_streams_csr( rbk_ctrct_rec.id ) LOOP
536: FND_FILE.PUT_LINE (FND_FILE.LOG,'Adjustment Amount: '
537: ||adj_streams_rec.amount
538: ||' for Contract: '
539: ||adj_streams_rec.contract_number);
540:

Line 651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');

647: err_tbl(err_idx).amount := i_taiv_rec.amount;
648:
649:
650: IF (x_return_status = 'S' ) THEN
651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');
652: ELSE
653: l_err_status := 'E';
654: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
655: END IF;

Line 654: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

650: IF (x_return_status = 'S' ) THEN
651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');
652: ELSE
653: l_err_status := 'E';
654: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
655: END IF;
656:
657:
658: IF (x_return_status <> 'S' ) THEN

Line 662: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

658: IF (x_return_status <> 'S' ) THEN
659: UPDATE okl_trx_ar_invoices_b
660: SET trx_status_code = 'ERROR'
661: WHERE id = lx_taiv_rec.id;
662: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
663: ELSE
664: ----------------------------------------------
665: -- Check if there was ever an error and update
666: -- accordingly

Line 674: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(i).amount);

670: -- Flag all TAI records for this bill adj
671: -- as error
672: -----------------------------------------
673: FOR i in err_tbl.FIRST..err_tbl.LAST LOOP
674: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(i).amount);
675:
676:
677: UPDATE okl_trx_ar_invoices_b
678: SET trx_status_code = 'ERROR'

Line 772: FND_FILE.PUT_LINE (FND_FILE.LOG,'Credited AR Invoice: '

768: err_tbl(err_idx).amount := l_credit_amount;
769:
770:
771: IF l_return_status = 'S' THEN
772: FND_FILE.PUT_LINE (FND_FILE.LOG,'Credited AR Invoice: '
773: ||unpaid_invs_rec.trx_number
774: ||' for: '||l_credit_amount);
775: l_bill_ajst_amt := l_bill_ajst_amt + unpaid_invs_rec.amount_due_remaining;
776: ELSE

Line 780: FND_FILE.PUT_LINE (FND_FILE.LOG,'ERROR Crediting AR Invoice: '

776: ELSE
777: l_err_status := 'E';
778:
779:
780: FND_FILE.PUT_LINE (FND_FILE.LOG,'ERROR Crediting AR Invoice: '
781: ||unpaid_invs_rec.trx_number
782: ||' for: '||l_credit_amount);
783: EXIT;
784: END IF;

Line 871: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Billing Transactions Created.');

867: err_tbl(err_idx).amount := lx_taiv_rec.amount;
868:
869:
870: IF (x_return_status = 'S' ) THEN
871: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Billing Transactions Created.');
872: ELSE
873: l_err_status := 'E';
874: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Billing Transactions.');
875: END IF;

Line 874: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Billing Transactions.');

870: IF (x_return_status = 'S' ) THEN
871: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Billing Transactions Created.');
872: ELSE
873: l_err_status := 'E';
874: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Billing Transactions.');
875: END IF;
876:
877:
878:

Line 896: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '

892: -- as error
893: -----------------------------------------
894: FOR i in err_tbl.FIRST..err_tbl.LAST LOOP
895: IF err_tbl(i).trx_number IS NOT NULL THEN
896: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '
897: ||err_tbl(i).trx_number
898: ||' for amount '
899: ||err_tbl(i).amount);
900: ELSE

Line 901: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '

897: ||err_tbl(i).trx_number
898: ||' for amount '
899: ||err_tbl(i).amount);
900: ELSE
901: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '
902: ||err_tbl(i).amount);
903: END IF;
904:
905:

Line 923: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');

919:
920: --UPDATE okl_trx_ar_invoices_b
921: --SET trx_status_code = 'ERROR'
922: --WHERE id = x_taiv_rec.id;
923: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
924: ELSE
925: IF l_err_status = 'E' THEN
926: -----------------------------------------
927: -- Flag all TAI records for this bill adj

Line 932: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '

928: -- as error
929: -----------------------------------------
930: FOR i in err_tbl.FIRST..err_tbl.LAST LOOP
931: IF err_tbl(i).trx_number IS NOT NULL THEN
932: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '
933: ||err_tbl(i).trx_number
934: ||' for amount '
935: ||err_tbl(i).amount);
936: ELSE

Line 937: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '

933: ||err_tbl(i).trx_number
934: ||' for amount '
935: ||err_tbl(i).amount);
936: ELSE
937: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '
938: ||err_tbl(i).amount);
939: END IF;
940:
941:

Line 983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);

979: ------------------------------------------------------------
980:
981:
982: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
984: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
985: p_api_name => l_api_name,
986: p_pkg_name => G_PKG_NAME,
987: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

Line 994: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

990: p_api_type => '_PVT');
991:
992:
993: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
994: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
995: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
996: p_api_name => l_api_name,
997: p_pkg_name => G_PKG_NAME,
998: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1005: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);

1001: p_api_type => '_PVT');
1002:
1003:
1004: WHEN OTHERS THEN
1005: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
1006: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1007: p_api_name => l_api_name,
1008: p_pkg_name => G_PKG_NAME,
1009: p_exc_name => 'OTHERS',

Line 1254: FND_FILE.PUT_LINE (FND_FILE.LOG,'Adjustment Amount: '

1250: --------------------------------------------------------
1251: -- Process Lines with Adjustment amounts
1252: --------------------------------------------------------
1253: FOR adj_streams_rec IN adj_streams_csr( rbk_ctrct_rec.id ) LOOP
1254: FND_FILE.PUT_LINE (FND_FILE.LOG,'Adjustment Amount: '
1255: ||adj_streams_rec.amount
1256: ||' for Contract: '
1257: ||adj_streams_rec.contract_number);
1258:

Line 1340: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');

1336: => lx_tldv_tbl);
1337:
1338:
1339: IF (x_return_status = 'S' ) THEN
1340: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');
1341: ELSE
1342: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1343: END IF;
1344:

Line 1342: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

1338:
1339: IF (x_return_status = 'S' ) THEN
1340: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');
1341: ELSE
1342: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1343: END IF;
1344:
1345:
1346: IF (x_return_status <> 'S' ) THEN

Line 1350: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

1346: IF (x_return_status <> 'S' ) THEN
1347: UPDATE okl_trx_ar_invoices_b
1348: SET trx_status_code = 'ERROR'
1349: WHERE id = lx_taiv_rec.id;
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1351: ELSE
1352: UPDATE okl_strm_elements
1353: SET date_billed = SYSDATE
1354: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 changes start here

Line 1445: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created');

1441: => lx_tldv_tbl);
1442:
1443:
1444: IF (x_return_status = 'S' ) THEN
1445: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created');
1446: ELSE
1447: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1448: END IF;
1449:

Line 1447: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

1443:
1444: IF (x_return_status = 'S' ) THEN
1445: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created');
1446: ELSE
1447: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1448: END IF;
1449:
1450:
1451: IF (x_return_status <> 'S' ) THEN

Line 1455: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

1451: IF (x_return_status <> 'S' ) THEN
1452: UPDATE okl_trx_ar_invoices_b
1453: SET trx_status_code = 'ERROR'
1454: WHERE id = lx_taiv_rec.id;
1455: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1456: ELSE
1457: UPDATE okl_strm_elements
1458: SET date_billed = SYSDATE
1459: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 changes start here

Line 1491: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);

1487: ------------------------------------------------------------
1488:
1489:
1490: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1491: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1492: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1493: p_api_name => l_api_name,
1494: p_pkg_name => G_PKG_NAME,
1495: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

Line 1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

1498: p_api_type => '_PVT');
1499:
1500:
1501: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1503: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1504: p_api_name => l_api_name,
1505: p_pkg_name => G_PKG_NAME,
1506: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1513: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);

1509: p_api_type => '_PVT');
1510:
1511:
1512: WHEN OTHERS THEN
1513: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
1514: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1515: p_api_name => l_api_name,
1516: p_pkg_name => G_PKG_NAME,
1517: p_exc_name => 'OTHERS',

Line 1595: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');

1591: FETCH req_id_csr INTO l_request_id;
1592: CLOSE req_id_csr;
1593:
1594:
1595: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');
1596: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number = ' ||p_contract_number);
1597: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');
1598:
1599:

Line 1596: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number = ' ||p_contract_number);

1592: CLOSE req_id_csr;
1593:
1594:
1595: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');
1596: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number = ' ||p_contract_number);
1597: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');
1598:
1599:
1600: IF fnd_profile.value('OKL_APPLY_CM') IS NULL THEN

Line 1597: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');

1593:
1594:
1595: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');
1596: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number = ' ||p_contract_number);
1597: FND_FILE.PUT_LINE (FND_FILE.LOG, '** * **');
1598:
1599:
1600: IF fnd_profile.value('OKL_APPLY_CM') IS NULL THEN
1601: -- On Account Credit Memo For Manual application

Line 1604: FND_FILE.PUT_LINE (FND_FILE.LOG,

1600: IF fnd_profile.value('OKL_APPLY_CM') IS NULL THEN
1601: -- On Account Credit Memo For Manual application
1602:
1603:
1604: FND_FILE.PUT_LINE (FND_FILE.LOG,
1605: '******************************************');
1606: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
1607: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
1608: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');

Line 1606: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');

1602:
1603:
1604: FND_FILE.PUT_LINE (FND_FILE.LOG,
1605: '******************************************');
1606: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
1607: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
1608: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
1609: FND_FILE.PUT_LINE (FND_FILE.LOG,
1610: '******************************************');

Line 1607: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');

1603:
1604: FND_FILE.PUT_LINE (FND_FILE.LOG,
1605: '******************************************');
1606: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
1607: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
1608: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
1609: FND_FILE.PUT_LINE (FND_FILE.LOG,
1610: '******************************************');
1611:

Line 1608: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');

1604: FND_FILE.PUT_LINE (FND_FILE.LOG,
1605: '******************************************');
1606: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
1607: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
1608: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
1609: FND_FILE.PUT_LINE (FND_FILE.LOG,
1610: '******************************************');
1611:
1612:

Line 1609: FND_FILE.PUT_LINE (FND_FILE.LOG,

1605: '******************************************');
1606: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
1607: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
1608: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
1609: FND_FILE.PUT_LINE (FND_FILE.LOG,
1610: '******************************************');
1611:
1612:
1613: ON_ACCT_Bill_adjustments (

Line 1625: FND_FILE.PUT_LINE (FND_FILE.LOG,

1621:
1622:
1623: ELSIF (fnd_profile.value('OKL_APPLY_CM') = 'SEEDED') THEN
1624: -- Development Logic
1625: FND_FILE.PUT_LINE (FND_FILE.LOG,
1626: '******************************************');
1627: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
1628: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
1629: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');

Line 1627: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');

1623: ELSIF (fnd_profile.value('OKL_APPLY_CM') = 'SEEDED') THEN
1624: -- Development Logic
1625: FND_FILE.PUT_LINE (FND_FILE.LOG,
1626: '******************************************');
1627: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
1628: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
1629: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
1630: FND_FILE.PUT_LINE (FND_FILE.LOG,
1631: '******************************************');

Line 1628: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');

1624: -- Development Logic
1625: FND_FILE.PUT_LINE (FND_FILE.LOG,
1626: '******************************************');
1627: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
1628: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
1629: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
1630: FND_FILE.PUT_LINE (FND_FILE.LOG,
1631: '******************************************');
1632:

Line 1629: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');

1625: FND_FILE.PUT_LINE (FND_FILE.LOG,
1626: '******************************************');
1627: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
1628: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
1629: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
1630: FND_FILE.PUT_LINE (FND_FILE.LOG,
1631: '******************************************');
1632:
1633:

Line 1630: FND_FILE.PUT_LINE (FND_FILE.LOG,

1626: '******************************************');
1627: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
1628: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
1629: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
1630: FND_FILE.PUT_LINE (FND_FILE.LOG,
1631: '******************************************');
1632:
1633:
1634: CM_Bill_adjustments (

Line 1648: FND_FILE.PUT_LINE (FND_FILE.LOG,

1644: ELSIF (fnd_profile.value('OKL_APPLY_CM') = 'CUSTOM') THEN
1645:
1646:
1647: -- Custom Logic
1648: FND_FILE.PUT_LINE (FND_FILE.LOG,
1649: '******************************************');
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');

Line 1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');

1646:
1647: -- Custom Logic
1648: FND_FILE.PUT_LINE (FND_FILE.LOG,
1649: '******************************************');
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG,
1654: '******************************************');

Line 1651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');

1647: -- Custom Logic
1648: FND_FILE.PUT_LINE (FND_FILE.LOG,
1649: '******************************************');
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG,
1654: '******************************************');
1655:

Line 1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');

1648: FND_FILE.PUT_LINE (FND_FILE.LOG,
1649: '******************************************');
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG,
1654: '******************************************');
1655:
1656:

Line 1653: FND_FILE.PUT_LINE (FND_FILE.LOG,

1649: '******************************************');
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG,
1654: '******************************************');
1655:
1656:
1657: OKL_CUSTOM_PVT.CUSTOM_CM_Bill_adjustments (

Line 1668: FND_FILE.PUT_LINE (FND_FILE.LOG,

1664: );
1665:
1666:
1667: ELSE
1668: FND_FILE.PUT_LINE (FND_FILE.LOG,
1669: '******************************************');
1670: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
1671: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
1672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');

Line 1670: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));

1666:
1667: ELSE
1668: FND_FILE.PUT_LINE (FND_FILE.LOG,
1669: '******************************************');
1670: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
1671: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
1672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
1673: FND_FILE.PUT_LINE (FND_FILE.LOG,
1674: '******************************************');

Line 1671: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');

1667: ELSE
1668: FND_FILE.PUT_LINE (FND_FILE.LOG,
1669: '******************************************');
1670: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
1671: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
1672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
1673: FND_FILE.PUT_LINE (FND_FILE.LOG,
1674: '******************************************');
1675: END IF;

Line 1672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');

1668: FND_FILE.PUT_LINE (FND_FILE.LOG,
1669: '******************************************');
1670: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
1671: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
1672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
1673: FND_FILE.PUT_LINE (FND_FILE.LOG,
1674: '******************************************');
1675: END IF;
1676:

Line 1673: FND_FILE.PUT_LINE (FND_FILE.LOG,

1669: '******************************************');
1670: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
1671: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
1672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
1673: FND_FILE.PUT_LINE (FND_FILE.LOG,
1674: '******************************************');
1675: END IF;
1676:
1677:

Line 1690: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Automatic Adjustments for Rebooked Contracts');

1686: FETCH txd_cnt_err_csr INTO l_err_cnt;
1687: CLOSE txd_cnt_err_csr;
1688:
1689:
1690: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Automatic Adjustments for Rebooked Contracts');
1691: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
1692: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
1693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1694: '***********************************************');

Line 1691: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');

1687: CLOSE txd_cnt_err_csr;
1688:
1689:
1690: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Automatic Adjustments for Rebooked Contracts');
1691: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
1692: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
1693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1694: '***********************************************');
1695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');

Line 1692: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);

1688:
1689:
1690: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Automatic Adjustments for Rebooked Contracts');
1691: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
1692: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
1693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1694: '***********************************************');
1695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = '

Line 1693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1689:
1690: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Automatic Adjustments for Rebooked Contracts');
1691: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
1692: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
1693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1694: '***********************************************');
1695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = '
1697: ||p_contract_number);

Line 1695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');

1691: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '************************************');
1692: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
1693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1694: '***********************************************');
1695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = '
1697: ||p_contract_number);
1698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1699: '***********************************************');

Line 1696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = '

1692: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date: '||SYSDATE||' Request Id: '||l_request_id);
1693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1694: '***********************************************');
1695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = '
1697: ||p_contract_number);
1698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1699: '***********************************************');
1700:

Line 1698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1694: '***********************************************');
1695: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = '
1697: ||p_contract_number);
1698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1699: '***********************************************');
1700:
1701:
1702: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Successful Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_succ_cnt);

Line 1702: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Successful Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_succ_cnt);

1698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1699: '***********************************************');
1700:
1701:
1702: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Successful Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_succ_cnt);
1703: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Errored Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_err_cnt);
1704: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');
1705:
1706:

Line 1703: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Errored Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_err_cnt);

1699: '***********************************************');
1700:
1701:
1702: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Successful Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_succ_cnt);
1703: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Errored Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_err_cnt);
1704: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');
1705:
1706:
1707: IF lx_msg_count > 0 THEN

Line 1704: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');

1700:
1701:
1702: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Successful Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_succ_cnt);
1703: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Errored Stream Lines in Okl_Txd_Ar_Ln_Dtls_b = '||l_err_cnt);
1704: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Messages For Each Records and Columns from TAPI ');
1705:
1706:
1707: IF lx_msg_count > 0 THEN
1708: FOR i IN 1..lx_msg_count LOOP

Line 1715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,TO_CHAR(i) || ': ' ||

1711: p_data => lx_msg_data,
1712: p_msg_index_out => l_msg_index_out);
1713:
1714:
1715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,TO_CHAR(i) || ': ' ||
1716: lx_msg_data);
1717: END LOOP;
1718: END IF;
1719: EXCEPTION

Line 2197: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Accounting Distributions Created.');

2193:
2194:
2195:
2196: IF (x_return_status = 'S' ) THEN
2197: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Accounting Distributions Created.');
2198: ELSE
2199: l_err_status := 'E';
2200: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2201: END IF;

Line 2200: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');

2196: IF (x_return_status = 'S' ) THEN
2197: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Accounting Distributions Created.');
2198: ELSE
2199: l_err_status := 'E';
2200: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2201: END IF;
2202:
2203:
2204: IF (x_return_status <> 'S' ) THEN

Line 2208: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');

2204: IF (x_return_status <> 'S' ) THEN
2205: UPDATE okl_trx_ar_invoices_b
2206: SET trx_status_code = 'ERROR'
2207: WHERE id = lx_taiv_rec.id;
2208: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2209: ELSE
2210: ----------------------------------------------
2211: -- Check if there was ever an error and update
2212: -- accordingly

Line 2220: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(j).amount);

2216: -- Flag all TAI records for this bill adj
2217: -- as error
2218: -----------------------------------------
2219: FOR j in err_tbl.FIRST..err_tbl.LAST LOOP
2220: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(j).amount);
2221:
2222:
2223: UPDATE okl_trx_ar_invoices_b
2224: SET trx_status_code = 'ERROR'

Line 2311: FND_FILE.PUT_LINE (FND_FILE.LOG,'Credited AR Invoice: '

2307: err_tbl(err_idx).amount := l_credit_amount;
2308:
2309:
2310: IF l_return_status = 'S' THEN
2311: FND_FILE.PUT_LINE (FND_FILE.LOG,'Credited AR Invoice: '
2312: ||unpaid_invs_rec.trx_number
2313: ||' for: '||l_credit_amount);
2314: l_bill_ajst_amt := l_bill_ajst_amt +
2315: unpaid_invs_rec.amount_due_remaining;

Line 2320: FND_FILE.PUT_LINE (FND_FILE.LOG,'ERROR Crediting AR Invoice: '

2316: ELSE
2317: l_err_status := 'E';
2318:
2319:
2320: FND_FILE.PUT_LINE (FND_FILE.LOG,'ERROR Crediting AR Invoice: '
2321: ||unpaid_invs_rec.trx_number
2322: ||' for: '||l_credit_amount);
2323: EXIT;
2324: END IF;

Line 2417: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Accounting Distributions Created.');

2413: err_tbl(err_idx).amount := i_taiv_rec.amount;
2414:
2415:
2416: IF (x_return_status = 'S' ) THEN
2417: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Accounting Distributions Created.');
2418: ELSE
2419: l_err_status := 'E';
2420: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Accounting Distributions.');
2421: END IF;

Line 2420: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Accounting Distributions.');

2416: IF (x_return_status = 'S' ) THEN
2417: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Accounting Distributions Created.');
2418: ELSE
2419: l_err_status := 'E';
2420: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Accounting Distributions.');
2421: END IF;
2422:
2423:
2424: END IF; -- More Credit remaining than needed

Line 2440: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '

2436: -- as error
2437: -----------------------------------------
2438: FOR j in err_tbl.FIRST..err_tbl.LAST LOOP
2439: IF err_tbl(j).trx_number IS NOT NULL THEN
2440: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '
2441: ||err_tbl(j).trx_number
2442: ||' for amount '
2443: ||err_tbl(j).amount);
2444: ELSE

Line 2445: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '

2441: ||err_tbl(j).trx_number
2442: ||' for amount '
2443: ||err_tbl(j).amount);
2444: ELSE
2445: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '
2446: ||err_tbl(j).amount);
2447: END IF;
2448:
2449:

Line 2460: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');

2456:
2457: --UPDATE okl_trx_ar_invoices_b
2458: --SET trx_status_code = 'ERROR'
2459: --WHERE id = x_taiv_rec.id;
2460: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2461: ELSE
2462: IF l_err_status = 'E' THEN
2463: -----------------------------------------
2464: -- Flag all TAI records for this bill adj

Line 2469: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '

2465: -- as error
2466: -----------------------------------------
2467: FOR j in err_tbl.FIRST..err_tbl.LAST LOOP
2468: IF err_tbl(j).trx_number IS NOT NULL THEN
2469: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credited Invoice '
2470: ||err_tbl(j).trx_number
2471: ||' for amount '
2472: ||err_tbl(j).amount);
2473: ELSE

Line 2474: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '

2470: ||err_tbl(j).trx_number
2471: ||' for amount '
2472: ||err_tbl(j).amount);
2473: ELSE
2474: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Credit for amount '
2475: ||err_tbl(j).amount);
2476: END IF;
2477:
2478:

Line 2522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);

2518: ------------------------------------------------------------
2519:
2520:
2521: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2524: p_api_name => l_api_name,
2525: p_pkg_name => G_PKG_NAME,
2526: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

Line 2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

2529: p_api_type => '_PVT');
2530:
2531:
2532: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,
2537: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2544: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);

2540: p_api_type => '_PVT');
2541:
2542:
2543: WHEN OTHERS THEN
2544: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
2545: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2546: p_api_name => l_api_name,
2547: p_pkg_name => G_PKG_NAME,
2548: p_exc_name => 'OTHERS',

Line 2682: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Count'||p_rebook_adj_tbl.COUNT);

2678:
2679:
2680:
2681:
2682: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Count'||p_rebook_adj_tbl.COUNT);
2683: ------------------------------------------------------------
2684: -- Process Adjustments
2685: ------------------------------------------------------------
2686: IF (p_rebook_adj_tbl.COUNT > 0) THEN

Line 2776: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');

2772: => lx_tldv_tbl);
2773:
2774:
2775: IF (x_return_status = 'S' ) THEN
2776: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');
2777: ELSE
2778: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
2779: END IF;
2780:

Line 2778: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

2774:
2775: IF (x_return_status = 'S' ) THEN
2776: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Billing Transactions Created.');
2777: ELSE
2778: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
2779: END IF;
2780:
2781:
2782: IF (x_return_status <> 'S' ) THEN

Line 2786: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');

2782: IF (x_return_status <> 'S' ) THEN
2783: UPDATE okl_trx_ar_invoices_b
2784: SET trx_status_code = 'ERROR'
2785: WHERE id = lx_taiv_rec.id;
2786: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
2787: END IF;
2788:
2789:
2790: ELSE -- (create On-account credit memo)

Line 2877: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Billing Transactions Created.');

2873:
2874:
2875:
2876: IF (x_return_status = 'S' ) THEN
2877: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Billing Transactions Created.');
2878: ELSE
2879: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Billing Transactions.');
2880: END IF;
2881:

Line 2879: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Billing Transactions.');

2875:
2876: IF (x_return_status = 'S' ) THEN
2877: FND_FILE.PUT_LINE (FND_FILE.LOG, 'On Account Billing Transactions Created.');
2878: ELSE
2879: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating On Account Billing Transactions.');
2880: END IF;
2881:
2882:
2883: IF (x_return_status <> 'S' ) THEN

Line 2887: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions');

2883: IF (x_return_status <> 'S' ) THEN
2884: UPDATE okl_trx_ar_invoices_b
2885: SET trx_status_code = 'ERROR'
2886: WHERE id = lx_taiv_rec.id;
2887: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions');
2888: END IF;
2889:
2890:
2891: END IF;

Line 2920: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);

2916: ------------------------------------------------------------
2917:
2918:
2919: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2920: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2921: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2922: p_api_name => l_api_name,
2923: p_pkg_name => G_PKG_NAME,
2924: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

Line 2931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

2927: p_api_type => '_PVT');
2928:
2929:
2930: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2933: p_api_name => l_api_name,
2934: p_pkg_name => G_PKG_NAME,
2935: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2942: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);

2938: p_api_type => '_PVT');
2939:
2940:
2941: WHEN OTHERS THEN
2942: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
2943: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2944: p_api_name => l_api_name,
2945: p_pkg_name => G_PKG_NAME,
2946: p_exc_name => 'OTHERS',

Line 3018: FND_FILE.PUT_LINE (FND_FILE.LOG,

3014: IF fnd_profile.value('OKL_APPLY_CM') IS NULL THEN
3015: -- On Account Credit Memo For Manual application
3016:
3017:
3018: FND_FILE.PUT_LINE (FND_FILE.LOG,
3019: '******************************************');
3020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
3021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
3022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');

Line 3020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');

3016:
3017:
3018: FND_FILE.PUT_LINE (FND_FILE.LOG,
3019: '******************************************');
3020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
3021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
3022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
3023: FND_FILE.PUT_LINE (FND_FILE.LOG,
3024: '******************************************');

Line 3021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');

3017:
3018: FND_FILE.PUT_LINE (FND_FILE.LOG,
3019: '******************************************');
3020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
3021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
3022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
3023: FND_FILE.PUT_LINE (FND_FILE.LOG,
3024: '******************************************');
3025:

Line 3022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');

3018: FND_FILE.PUT_LINE (FND_FILE.LOG,
3019: '******************************************');
3020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
3021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
3022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
3023: FND_FILE.PUT_LINE (FND_FILE.LOG,
3024: '******************************************');
3025:
3026:

Line 3023: FND_FILE.PUT_LINE (FND_FILE.LOG,

3019: '******************************************');
3020: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: NULL');
3021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice Credit Memo.');
3022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.ON_ACCT_Bill_adjustments');
3023: FND_FILE.PUT_LINE (FND_FILE.LOG,
3024: '******************************************');
3025:
3026:
3027: ON_ACCT_Bill_adjustments (

Line 3039: FND_FILE.PUT_LINE (FND_FILE.LOG,

3035:
3036:
3037: ELSIF (fnd_profile.value('OKL_APPLY_CM') = 'SEEDED') THEN
3038: -- Development Logic
3039: FND_FILE.PUT_LINE (FND_FILE.LOG,
3040: '******************************************');
3041: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
3042: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
3043: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');

Line 3041: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');

3037: ELSIF (fnd_profile.value('OKL_APPLY_CM') = 'SEEDED') THEN
3038: -- Development Logic
3039: FND_FILE.PUT_LINE (FND_FILE.LOG,
3040: '******************************************');
3041: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
3042: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
3043: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
3044: FND_FILE.PUT_LINE (FND_FILE.LOG,
3045: '******************************************');

Line 3042: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');

3038: -- Development Logic
3039: FND_FILE.PUT_LINE (FND_FILE.LOG,
3040: '******************************************');
3041: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
3042: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
3043: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
3044: FND_FILE.PUT_LINE (FND_FILE.LOG,
3045: '******************************************');
3046:

Line 3043: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');

3039: FND_FILE.PUT_LINE (FND_FILE.LOG,
3040: '******************************************');
3041: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
3042: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
3043: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
3044: FND_FILE.PUT_LINE (FND_FILE.LOG,
3045: '******************************************');
3046:
3047:

Line 3044: FND_FILE.PUT_LINE (FND_FILE.LOG,

3040: '******************************************');
3041: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: SEEDED');
3042: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create On-Invoice and On-Acct Credit Memo.');
3043: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CM_Bill_adjustments');
3044: FND_FILE.PUT_LINE (FND_FILE.LOG,
3045: '******************************************');
3046:
3047:
3048: CM_Bill_adjustments (

Line 3063: FND_FILE.PUT_LINE (FND_FILE.LOG,

3059: ELSIF (fnd_profile.value('OKL_APPLY_CM') = 'CUSTOM') THEN
3060:
3061:
3062: -- Custom Logic
3063: FND_FILE.PUT_LINE (FND_FILE.LOG,
3064: '******************************************');
3065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
3066: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
3067: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');

Line 3065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');

3061:
3062: -- Custom Logic
3063: FND_FILE.PUT_LINE (FND_FILE.LOG,
3064: '******************************************');
3065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
3066: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
3067: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
3068: FND_FILE.PUT_LINE (FND_FILE.LOG,
3069: '******************************************');

Line 3066: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');

3062: -- Custom Logic
3063: FND_FILE.PUT_LINE (FND_FILE.LOG,
3064: '******************************************');
3065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
3066: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
3067: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
3068: FND_FILE.PUT_LINE (FND_FILE.LOG,
3069: '******************************************');
3070:

Line 3067: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');

3063: FND_FILE.PUT_LINE (FND_FILE.LOG,
3064: '******************************************');
3065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
3066: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
3067: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
3068: FND_FILE.PUT_LINE (FND_FILE.LOG,
3069: '******************************************');
3070:
3071:

Line 3068: FND_FILE.PUT_LINE (FND_FILE.LOG,

3064: '******************************************');
3065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: CUSTOM');
3066: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Credit Memo using CUSTOM Logic.');
3067: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoking OKL_REBOOK_CM_PVT.CUSTOM_CM_Bill_adjustments');
3068: FND_FILE.PUT_LINE (FND_FILE.LOG,
3069: '******************************************');
3070:
3071:
3072: OKL_CUSTOM_PVT.CUSTOM_CM_Bill_adjustments (

Line 3083: FND_FILE.PUT_LINE (FND_FILE.LOG,

3079: );
3080:
3081:
3082: ELSE
3083: FND_FILE.PUT_LINE (FND_FILE.LOG,
3084: '******************************************');
3085: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
3086: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
3087: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');

Line 3085: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));

3081:
3082: ELSE
3083: FND_FILE.PUT_LINE (FND_FILE.LOG,
3084: '******************************************');
3085: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
3086: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
3087: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
3088: FND_FILE.PUT_LINE (FND_FILE.LOG,
3089: '******************************************');

Line 3086: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');

3082: ELSE
3083: FND_FILE.PUT_LINE (FND_FILE.LOG,
3084: '******************************************');
3085: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
3086: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
3087: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
3088: FND_FILE.PUT_LINE (FND_FILE.LOG,
3089: '******************************************');
3090: END IF;

Line 3087: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');

3083: FND_FILE.PUT_LINE (FND_FILE.LOG,
3084: '******************************************');
3085: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
3086: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
3087: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
3088: FND_FILE.PUT_LINE (FND_FILE.LOG,
3089: '******************************************');
3090: END IF;
3091:

Line 3088: FND_FILE.PUT_LINE (FND_FILE.LOG,

3084: '******************************************');
3085: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile OKL:Apply Billing Adjustment: '||fnd_profile.value('OKL_APPLY_CM'));
3086: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Acceptable Values are: NULL, SEEDED OR CUSTOM.');
3087: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Exiting Procedure ..');
3088: FND_FILE.PUT_LINE (FND_FILE.LOG,
3089: '******************************************');
3090: END IF;
3091:
3092:

Line 3117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);

3113: ------------------------------------------------------------
3114:
3115:
3116: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3118: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3119: p_api_name => l_api_name,
3120: p_pkg_name => G_PKG_NAME,
3121: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

Line 3128: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

3124: p_api_type => '_PVT');
3125:
3126:
3127: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3128: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3129: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3130: p_api_name => l_api_name,
3131: p_pkg_name => G_PKG_NAME,
3132: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 3139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);

3135: p_api_type => '_PVT');
3136:
3137:
3138: WHEN OTHERS THEN
3139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
3140: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3141: p_api_name => l_api_name,
3142: p_pkg_name => G_PKG_NAME,
3143: p_exc_name => 'OTHERS',