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.5 2010/06/03 10:01:34 sosharma 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 2385: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.receipt_mismatch ...');

2381: IF (G_DEBUG_ENABLED = 'Y') THEN
2382: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2383: END IF;
2384: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2385: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.receipt_mismatch ...');
2386: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Procedure parameters, p_customer_num : '|| p_customer_num);
2387: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_org_id : '|| p_org_id);
2388: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_currency_code : '|| p_currency_code);
2389: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_rcpt_amount : '|| p_rcpt_amount);

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

2663: IF (G_DEBUG_ENABLED = 'Y') THEN
2664: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2665: END IF;
2666: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2667: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Starting execution of OKL_AUTO_CASH_APPL_RULES_PVT.GET_APPLICATIONS ...');
2668: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Count of l_rcpt_tbl: '|| l_rcpt_tbl.COUNT);
2669: END IF;
2670:
2671: IF (l_rcpt_tbl IS NOT NULL AND l_rcpt_tbl.COUNT > 0) THEN

Line 2942: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;

2938: -- DECLARE Record/Table Types
2939: ------------------------------
2940:
2941:
2942: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
2943: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
2944: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
2945:
2946: -- ** internal use only ** --

Line 2943: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;

2939: ------------------------------
2940:
2941:
2942: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
2943: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
2944: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
2945:
2946: -- ** internal use only ** --
2947:

Line 2944: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;

2940:
2941:
2942: l_rcpt_tbl okl_auto_cash_appl_rules_pvt.okl_rcpt_dtls_tbl_type;
2943: l_appl_tbl okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
2944: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
2945:
2946: -- ** internal use only ** --
2947:
2948: TYPE okl_inv_refs_type IS RECORD ( contract_number AR_PAYMENTS_INTERFACE_ALL.INVOICE1%TYPE DEFAULT NULL

Line 4226: 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 ...');

4222: END IF;
4223: END IF;
4224: END IF;
4225: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4226: 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 ...');
4227:
4228:
4229: END IF;
4230: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4257: END OKL_AUTO_CASH_APPL_RULES_PVT;

4253: WHEN OTHERS THEN
4254: RETURN 0;
4255: END GET_ROUNDED_AMOUNT;
4256:
4257: END OKL_AUTO_CASH_APPL_RULES_PVT;