DBA Data[Home] [Help]

APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKL_AUTO_CASH_APPL_RULES_PVT

Line 1: PACKAGE BODY okl_auto_cash_appl_rules_pvt AS

1: PACKAGE BODY okl_auto_cash_appl_rules_pvt AS
2: /* $Header: OKLRACUB.pls 120.34.12010000.3 2008/08/29 08:12:50 nikshah ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 1452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_PVT.auto_cashapp_for_arinv ...');

1448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_ERROR;
1450: END IF;
1451: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_PVT.auto_cashapp_for_arinv ...');
1453: END IF;
1454: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1455: EXCEPTION
1456: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1553: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;

1549: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE;
1550:
1551:
1552: --Record/Table Definitions
1553: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
1554: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
1555: l_tot_amt_app_from NUMBEr := 0;
1556:
1557: --Cursor definitions

Line 1554: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;

1550:
1551:
1552: --Record/Table Definitions
1553: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
1554: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
1555: l_tot_amt_app_from NUMBEr := 0;
1556:
1557: --Cursor definitions
1558:

Line 1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.auto_cashapp_for_contract ...');

1638: IF (G_DEBUG_ENABLED = 'Y') THEN
1639: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1640: END IF;
1641: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.auto_cashapp_for_contract ...');
1643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Procedure parameters, p_customer_num : '|| p_customer_num);
1644: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_num : '|| p_contract_num);
1645: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_currency_code : '|| p_currency_code);
1646: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_amount_app_to : '|| p_amount_app_to);

Line 2379: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.receipt_mismatch ...');

2375: IF (G_DEBUG_ENABLED = 'Y') THEN
2376: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2377: END IF;
2378: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2379: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.receipt_mismatch ...');
2380: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Procedure parameters, p_customer_num : '|| p_customer_num);
2381: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_org_id : '|| p_org_id);
2382: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_currency_code : '|| p_currency_code);
2383: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_rcpt_amount : '|| p_rcpt_amount);

Line 2657: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.GET_APPLICATIONS ...');

2653: IF (G_DEBUG_ENABLED = 'Y') THEN
2654: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2655: END IF;
2656: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2657: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.GET_APPLICATIONS ...');
2658: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Count of l_rcpt_tbl: '|| l_rcpt_tbl.COUNT);
2659: END IF;
2660:
2661: IF (l_rcpt_tbl IS NOT NULL AND l_rcpt_tbl.COUNT > 0) THEN

Line 2932: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;

2928: -- DECLARE Record/Table Types
2929: ------------------------------
2930:
2931:
2932: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
2933: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
2934: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
2935:
2936: -- ** internal use only ** --

Line 2933: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;

2929: ------------------------------
2930:
2931:
2932: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
2933: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
2934: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
2935:
2936: -- ** internal use only ** --
2937:

Line 2934: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;

2930:
2931:
2932: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
2933: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
2934: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
2935:
2936: -- ** internal use only ** --
2937:
2938: TYPE okl_inv_refs_type IS RECORD ( contract_number AR_PAYMENTS_INTERFACE_ALL.INVOICE1%TYPE DEFAULT NULL

Line 4216: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_pvt.auto_cash_app_for_consinv ...');

4212: END IF;
4213: END IF;
4214: END IF;
4215: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4216: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_pvt.auto_cash_app_for_consinv ...');
4217:
4218:
4219: END IF;
4220: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4247: END OKL_AUTO_CASH_APPL_RULES_PVT;

4243: WHEN OTHERS THEN
4244: RETURN 0;
4245: END GET_ROUNDED_AMOUNT;
4246:
4247: END OKL_AUTO_CASH_APPL_RULES_PVT;