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.16.12010000.5 2008/11/12 07:54:48 cpati 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 58: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_credit_check_lines_PVT';

54:
55: ------------
56: -- CONSTANTS
57: ------------
58: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_credit_check_lines_PVT';
59:
60: ---------------------------
61: -- PRIVATE GLOBAL VARIABLES
62: ---------------------------

Line 3024: OE_credit_check_lines_PVT.Validate_other_credit_check

3020: -- or the site level and the credit limits at that level. |
3021: -- The information returned will be used for credit check.|
3022: -----------------------------------------------------------
3023: --
3024: OE_credit_check_lines_PVT.Validate_other_credit_check
3025: ( p_header_rec => p_header_rec
3026: , p_customer_id => p_customer_id
3027: , p_site_use_id => p_site_use_id
3028: , p_calling_action => p_calling_action

Line 3088: OE_credit_check_lines_PVT.Chk_Past_Due_Invoice

3084: ----------------------------------------------------+
3085: --
3086:
3087:
3088: OE_credit_check_lines_PVT.Chk_Past_Due_Invoice
3089: ( p_customer_id => p_customer_id
3090: , p_site_use_id => p_site_use_id
3091: , p_party_id => l_credit_limit_entity_id
3092: , p_credit_check_rule_rec => p_credit_check_rule_rec

Line 3149: OE_credit_check_lines_PVT.Check_Trx_Limit

3145: -- check 4: overall limit |
3146: ----------------------------------------------------+
3147: --
3148:
3149: OE_credit_check_lines_PVT.Check_Trx_Limit
3150: ( p_header_rec => p_header_rec
3151: , p_customer_id => p_customer_id
3152: , p_site_use_id => p_site_use_id
3153: , p_credit_level => x_credit_level

Line 3238: OE_credit_check_lines_PVT.Check_Order_lines_exposure

3234: NVL(l_prev_customer_id,p_customer_id * -1) <> p_customer_id
3235: )
3236: THEN
3237:
3238: OE_credit_check_lines_PVT.Check_Order_lines_exposure
3239: ( p_customer_id => p_customer_id
3240: , p_site_use_id => p_site_use_id
3241: , p_header_id => p_header_rec.header_id
3242: , p_party_id => p_party_id

Line 4185: IF OE_CREDIT_CHECK_LINES_PVT.G_cc_limit_used = 'OVERALL'

4181:
4182: IF l_cc_result_out in ('FAIL_HOLD','FAIL_NONE','FAIL')
4183: THEN
4184: ---------submit AR Credit Review---------
4185: IF OE_CREDIT_CHECK_LINES_PVT.G_cc_limit_used = 'OVERALL'
4186: THEN
4187:
4188: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
4189: THEN

Line 4241: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));

4237: OE_DEBUG_PUB.Add('p_requestor_id= '||TO_CHAR(fnd_global.employee_id));
4238: OE_DEBUG_PUB.Add('p_review_type= ORDER_HOLD');
4239: OE_DEBUG_PUB.Add('p_credit_classification= NULL');
4240: OE_DEBUG_PUB.Add('p_requested_amount= '||
4241: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));
4242: OE_DEBUG_PUB.Add('p_requested_currency= '||
4243: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);
4244: OE_DEBUG_PUB.Add('p_trx_amount= '||
4245: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));

Line 4243: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);

4239: OE_DEBUG_PUB.Add('p_credit_classification= NULL');
4240: OE_DEBUG_PUB.Add('p_requested_amount= '||
4241: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));
4242: OE_DEBUG_PUB.Add('p_requested_currency= '||
4243: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);
4244: OE_DEBUG_PUB.Add('p_trx_amount= '||
4245: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));
4246: OE_DEBUG_PUB.Add('p_trx_currency= '||
4247: p_header_rec.transactional_curr_code );

Line 4288: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure

4284: , p_requestor_id => fnd_global.employee_id
4285: , p_review_type => 'ORDER_HOLD'
4286: , p_credit_classification => NULL
4287: , p_requested_amount =>
4288: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure
4289: , p_requested_currency =>
4290: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency
4291: , p_trx_amount =>
4292: OE_CREDIT_CHECK_UTIL.g_current_order_value

Line 4290: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency

4286: , p_credit_classification => NULL
4287: , p_requested_amount =>
4288: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure
4289: , p_requested_currency =>
4290: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency
4291: , p_trx_amount =>
4292: OE_CREDIT_CHECK_UTIL.g_current_order_value
4293: , p_trx_currency => p_header_rec.transactional_curr_code
4294: , p_credit_type => 'TRADE'

Line 4488: END OE_credit_check_lines_PVT;

4484: END IF;
4485: END Check_order_lines_credit;
4486:
4487:
4488: END OE_credit_check_lines_PVT;