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.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_CREDIT_CHECK_LINES_PVT

Line 1: PACKAGE BODY OE_credit_check_lines_PVT AS

1: PACKAGE BODY OE_credit_check_lines_PVT AS
2: -- $Header: OEXVCRLB.pls 120.35.12020000.5 2012/09/13 10:29:21 sujithku ship $
3: --+=======================================================================+
4: --| Copyright (c) 2001 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 12: --| Body of package OE_credit_check_lines_PVT. It contains the |

8: --| |
9: --| FILENAME |
10: --| OEXVCRLB.pls |
11: --| DESCRIPTION |
12: --| Body of package OE_credit_check_lines_PVT. It contains the |
13: --| and functions used to perform line level credit checking according |
14: --| to a given credit rule. It will check the amount against the credit|
15: --| limits set at the customer/site. The result returned will be |
16: --| 'PASS' if it is within the customer/site limit and |

Line 62: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_credit_check_lines_PVT';

58:
59: ------------
60: -- CONSTANTS
61: ------------
62: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_credit_check_lines_PVT';
63:
64: ---------------------------
65: -- PRIVATE GLOBAL VARIABLES
66: ---------------------------

Line 3244: OE_credit_check_lines_PVT.Validate_other_credit_check

3240: -- or the site level and the credit limits at that level. |
3241: -- The information returned will be used for credit check.|
3242: -----------------------------------------------------------
3243: --
3244: OE_credit_check_lines_PVT.Validate_other_credit_check
3245: ( p_header_rec => p_header_rec
3246: , p_customer_id => p_customer_id
3247: , p_site_use_id => p_site_use_id
3248: , p_calling_action => p_calling_action

Line 3437: OE_credit_check_lines_PVT.Chk_Past_Due_Invoice

3433: ----------------------------------------------------+
3434: --
3435:
3436:
3437: OE_credit_check_lines_PVT.Chk_Past_Due_Invoice
3438: ( p_customer_id => p_customer_id
3439: , p_site_use_id => p_site_use_id
3440: , p_party_id => l_credit_limit_entity_id
3441: , p_credit_check_rule_rec => p_credit_check_rule_rec

Line 3504: OE_credit_check_lines_PVT.Check_Trx_Limit

3500: -- check 4: overall limit |
3501: ----------------------------------------------------+
3502: --
3503:
3504: OE_credit_check_lines_PVT.Check_Trx_Limit
3505: ( p_header_rec => p_header_rec
3506: , p_customer_id => p_customer_id
3507: , p_site_use_id => p_site_use_id
3508: , p_credit_level => x_credit_level

Line 3609: OE_credit_check_lines_PVT.Check_Order_lines_exposure

3605: NVL(l_prev_customer_id,p_customer_id * -1) <> p_customer_id
3606: )
3607: THEN
3608:
3609: OE_credit_check_lines_PVT.Check_Order_lines_exposure
3610: ( p_customer_id => p_customer_id
3611: , p_site_use_id => p_site_use_id
3612: , p_header_id => p_header_rec.header_id
3613: , p_party_id => p_party_id

Line 3831: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));-- Bug 12651163

3827: OE_DEBUG_PUB.Add('p_review_type= ORDER_HOLD');
3828: OE_DEBUG_PUB.Add('p_credit_classification= NULL');
3829: --OE_DEBUG_PUB.Add('p_requested_amount= '||TO_CHAR(l_total_exposure ));-- Bug 12651163
3830: OE_DEBUG_PUB.Add('p_requested_amount= '||
3831: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));-- Bug 12651163
3832: --OE_DEBUG_PUB.Add('p_requested_currency= '||l_limit_curr_code);-- Bug 12651163
3833: OE_DEBUG_PUB.Add('p_requested_currency= '||
3834: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);-- Bug 12651163
3835: --OE_DEBUG_PUB.Add('p_trx_amount= '||TO_CHAR(g_order));-- Bug 12651163

Line 3834: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);-- Bug 12651163

3830: OE_DEBUG_PUB.Add('p_requested_amount= '||
3831: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));-- Bug 12651163
3832: --OE_DEBUG_PUB.Add('p_requested_currency= '||l_limit_curr_code);-- Bug 12651163
3833: OE_DEBUG_PUB.Add('p_requested_currency= '||
3834: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);-- Bug 12651163
3835: --OE_DEBUG_PUB.Add('p_trx_amount= '||TO_CHAR(g_order));-- Bug 12651163
3836: OE_DEBUG_PUB.Add('p_trx_amount= '||
3837: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));-- Bug 12651163
3838: OE_DEBUG_PUB.Add('p_trx_currency= '||p_header_rec.transactional_curr_code );

Line 3879: , p_requested_amount => OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure -- Bug 12651163

3875: , p_requestor_id => fnd_global.employee_id
3876: , p_review_type => 'ORDER_HOLD'
3877: , p_credit_classification => NULL
3878: --, p_requested_amount => l_total_exposure -- Bug 12651163
3879: , p_requested_amount => OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure -- Bug 12651163
3880: --, p_requested_currency => l_limit_curr_code -- Bug 12651163
3881: , p_requested_currency => OE_CREDIT_CHECK_LINES_PVT.G_limit_currency -- Bug 12651163
3882: --, p_trx_amount => g_order -- Bug 12651163
3883: , p_trx_amount => OE_CREDIT_CHECK_UTIL.g_current_order_value-- Bug 12651163

Line 3881: , p_requested_currency => OE_CREDIT_CHECK_LINES_PVT.G_limit_currency -- Bug 12651163

3877: , p_credit_classification => NULL
3878: --, p_requested_amount => l_total_exposure -- Bug 12651163
3879: , p_requested_amount => OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure -- Bug 12651163
3880: --, p_requested_currency => l_limit_curr_code -- Bug 12651163
3881: , p_requested_currency => OE_CREDIT_CHECK_LINES_PVT.G_limit_currency -- Bug 12651163
3882: --, p_trx_amount => g_order -- Bug 12651163
3883: , p_trx_amount => OE_CREDIT_CHECK_UTIL.g_current_order_value-- Bug 12651163
3884: , p_trx_currency => p_header_rec.transactional_curr_code
3885: , p_credit_type => 'TRADE'

Line 3977: , p_limit_currency => OE_CREDIT_CHECK_LINES_PVT.G_limit_currency

3973: , p_party_id => l_credit_limit_entity_id
3974: , p_exposure => l_total_exposure
3975: , p_overall_credit_limit => l_overall_credit_limit
3976: --13939240 Start
3977: , p_limit_currency => OE_CREDIT_CHECK_LINES_PVT.G_limit_currency
3978: , p_transactional_currency =>p_header_rec.transactional_curr_code
3979: , p_conversion_type =>p_credit_check_rule_rec.conversion_type
3980: --13939240 End
3981: );

Line 4730: --IF OE_CREDIT_CHECK_LINES_PVT.G_cc_limit_used = 'OVERALL' --ER8880886

4726: IF l_cc_result_out in ('FAIL_HOLD','FAIL')
4727: --kadiraju changes End for Bug#13768161
4728: THEN
4729: ---------submit AR Credit Review---------
4730: --IF OE_CREDIT_CHECK_LINES_PVT.G_cc_limit_used = 'OVERALL' --ER8880886
4731: --THEN --ER8880886
4732:
4733: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
4734: THEN

Line 4786: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));

4782: OE_DEBUG_PUB.Add('p_requestor_id= '||TO_CHAR(fnd_global.employee_id));
4783: OE_DEBUG_PUB.Add('p_review_type= ORDER_HOLD');
4784: OE_DEBUG_PUB.Add('p_credit_classification= NULL');
4785: OE_DEBUG_PUB.Add('p_requested_amount= '||
4786: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));
4787: OE_DEBUG_PUB.Add('p_requested_currency= '||
4788: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);
4789: OE_DEBUG_PUB.Add('p_trx_amount= '||
4790: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));

Line 4788: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);

4784: OE_DEBUG_PUB.Add('p_credit_classification= NULL');
4785: OE_DEBUG_PUB.Add('p_requested_amount= '||
4786: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));
4787: OE_DEBUG_PUB.Add('p_requested_currency= '||
4788: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);
4789: OE_DEBUG_PUB.Add('p_trx_amount= '||
4790: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));
4791: OE_DEBUG_PUB.Add('p_trx_currency= '||
4792: p_header_rec.transactional_curr_code );

Line 4833: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure

4829: , p_requestor_id => fnd_global.employee_id
4830: , p_review_type => 'ORDER_HOLD'
4831: , p_credit_classification => NULL
4832: , p_requested_amount =>
4833: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure
4834: , p_requested_currency =>
4835: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency
4836: , p_trx_amount =>
4837: OE_CREDIT_CHECK_UTIL.g_current_order_value

Line 4835: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency

4831: , p_credit_classification => NULL
4832: , p_requested_amount =>
4833: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure
4834: , p_requested_currency =>
4835: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency
4836: , p_trx_amount =>
4837: OE_CREDIT_CHECK_UTIL.g_current_order_value
4838: , p_trx_currency => p_header_rec.transactional_curr_code
4839: , p_credit_type => 'TRADE'

Line 5041: END OE_credit_check_lines_PVT;

5037: END IF;
5038: END Check_order_lines_credit;
5039:
5040:
5041: END OE_credit_check_lines_PVT;