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_UTIL dependencies on OE_CREDIT_CHECK_UTIL

Line 1: PACKAGE BODY OE_CREDIT_CHECK_UTIL AS

1: PACKAGE BODY OE_CREDIT_CHECK_UTIL AS
2: -- $Header: OEXUCRCB.pls 120.31.12020000.2 2012/08/22 10:15:32 sujithku ship $
3: --+=======================================================================+
4: --| Copyright (c) 2000 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 12: --| Package Spec of OE_CREDIT_CHECK_UTIL |

8: --| FILENAME |
9: --| OEXUCRCB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Package Spec of OE_CREDIT_CHECK_UTIL |
13: --| |
14: --| PROCEDURE LIST |
15: --| Get_Credit_Check_Rule_ID |
16: --| Get_Credit_Check_Rule |

Line 78: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CREDIT_CHECK_UTIL';

74:
75: ------------
76: -- CONSTANTS
77: ------------
78: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CREDIT_CHECK_UTIL';
79: G_DBG_MSG VARCHAR2(200) := NULL;
80: /* Start MOAC CREDIT CHECK CHANGE */
81: --G_ORG_ID NUMBER :=
82: -- NVL(TO_NUMBER(FND_PROFILE.value('ORG_ID')), -99);

Line 85: NVL( OE_CREDIT_CHECK_UTIL.check_debug_flag ,'N') ;

81: --G_ORG_ID NUMBER :=
82: -- NVL(TO_NUMBER(FND_PROFILE.value('ORG_ID')), -99);
83: /* End MOAC CREDIT CHECK CHANGE */
84: G_debug_flag VARCHAR2(1) :=
85: NVL( OE_CREDIT_CHECK_UTIL.check_debug_flag ,'N') ;
86: G_MULTIPLE_PAYMENTS_ENABLED BOOLEAN :=
87: OE_PrePayment_Util.IS_MULTIPLE_PAYMENTS_ENABLED;
88:
89: -------------------

Line 278: and hn.hierarchy_type = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

274: and hn.parent_table_name = 'HZ_PARTIES'
275: and hn.child_object_type = 'ORGANIZATION'
276: and hn.effective_start_date <= sysdate
277: and hn.effective_end_date >= SYSDATE
278: and hn.hierarchy_type = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
279: ORDER BY hn.LEVEL_NUMBER DESC ;
280:
281:
282: party_hier_limit_no_incl_rec party_hier_limit_no_incl_csr%ROWTYPE ;

Line 322: and hn.hierarchy_type = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

318: and hn.parent_table_name = 'HZ_PARTIES'
319: and hn.child_object_type = 'ORGANIZATION'
320: and hn.effective_start_date <= sysdate
321: and hn.effective_end_date >= SYSDATE
322: and hn.hierarchy_type = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
323: ORDER BY hn.LEVEL_NUMBER DESC ;
324:
325: party_hier_limit_incl_rec party_hier_limit_incl_csr%ROWTYPE ;
326:

Line 352: and hn.hierarchy_type = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

348: and hn.effective_start_date
349: <= sysdate
350: and hn.effective_end_date
351: >= SYSDATE
352: and hn.hierarchy_type = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
353: ORDER BY hn.LEVEL_NUMBER DESC ;
354:
355:
356: party_hier_single_limit_rec party_hier_single_limit_csr%ROWTYPE ;

Line 2362: OE_CREDIT_CHECK_UTIL.item_limits_tbl_type

2358: , p_trx_curr_code IN VARCHAR2
2359: , p_site_use_id IN NUMBER
2360: , p_include_tax_flag IN VARCHAR2
2361: , x_item_limits_tbl OUT NOCOPY
2362: OE_CREDIT_CHECK_UTIL.item_limits_tbl_type
2363: , x_lines_tbl OUT NOCOPY
2364: OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type
2365: )
2366: IS

Line 2364: OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type

2360: , p_include_tax_flag IN VARCHAR2
2361: , x_item_limits_tbl OUT NOCOPY
2362: OE_CREDIT_CHECK_UTIL.item_limits_tbl_type
2363: , x_lines_tbl OUT NOCOPY
2364: OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type
2365: )
2366: IS
2367:
2368: l_site_use_id NUMBER ;

Line 2370: l_tmp_lines_tbl OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type ;

2366: IS
2367:
2368: l_site_use_id NUMBER ;
2369: l_include_tax_flag VARCHAR2(1) := 'N' ;
2370: l_tmp_lines_tbl OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type ;
2371: l_tmp_category_tbl category_tmp_tbl_type ;
2372: l_selling_price NUMBER;
2373: l_tax_value NUMBER;
2374: l_ordered_quantity NUMBER;

Line 3040: , x_usage_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

3036: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
3037: , p_default_limit_flag IN VARCHAR2 := 'N'
3038: , p_global_exposure_flag IN VARCHAR2 := 'N'
3039: , x_include_all_flag OUT NOCOPY VARCHAR2
3040: , x_usage_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
3041: )
3042: IS
3043:
3044: l_count NUMBER;

Line 3232: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;

3228: and hn.child_object_type = 'ORGANIZATION'
3229: and hn.effective_start_date <= sysdatE
3230: and hn.effective_end_date >= SYSDATE
3231: and hn.hierarchy_type
3232: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;
3233:
3234: CURSOR party_txn_cur IS
3235: SELECT distinct ( currency_code) user_code
3236: FROM oe_credit_summaries

Line 3252: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

3248: and hn.child_object_type = 'ORGANIZATION'
3249: and hn.effective_start_date <= sysdate
3250: and hn.effective_end_date >= SYSDATE
3251: and hn.hierarchy_type
3252: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
3253: AND oes.party_id = hn.child_id
3254: AND oes.bucket_duration = OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH ;
3255:
3256:

Line 3302: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := NULL ;

3298: OE_DEBUG_PUB.ADD(' ---------------------------------------------- ');
3299:
3300: END IF;
3301:
3302: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := NULL ;
3303: l_exclude_flag := 'N' ;
3304:
3305: IF G_debug_flag = 'Y'
3306: THEN

Line 3509: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := l_excl_curr_list ;

3505: -- End dflt_rule_set_csr
3506: END IF;
3507: -- End default flag IF
3508:
3509: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := l_excl_curr_list ;
3510:
3511: IF G_debug_flag = 'Y'
3512: THEN
3513: OE_DEBUG_PUB.ADD(' G_excl_curr_list => '||

Line 3514: OE_CREDIT_CHECK_UTIL.G_excl_curr_list );

3510:
3511: IF G_debug_flag = 'Y'
3512: THEN
3513: OE_DEBUG_PUB.ADD(' G_excl_curr_list => '||
3514: OE_CREDIT_CHECK_UTIL.G_excl_curr_list );
3515: END IF;
3516: -----------------------------------------------------------
3517: ---------------------------------------------
3518: -- identify all the transaction currencies

Line 3783: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

3779: -- 02/12/2002 vto Added NVL on org_id to handle multi-org/non multi-org setup
3780: ------------------------------------------------------------------------------
3781: PROCEDURE GET_System_parameters
3782: ( x_system_parameter_rec OUT NOCOPY
3783: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
3784: )
3785: IS
3786: BEGIN
3787: IF G_debug_flag = 'Y'

Line 4004: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;

4000:
4001: l_level VARCHAR2(30);
4002: l_credit_check_rule_id NUMBER;
4003: l_credit_check_rule_rec
4004: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
4005:
4006: BEGIN
4007: IF G_debug_flag = 'Y'
4008: THEN

Line 4022: OE_Credit_CHECK_UTIL.Get_Credit_Check_Rule_ID

4018: THEN
4019: OE_DEBUG_PUB.ADD(' Calling Get_Credit_Check_Rule_ID ');
4020: END IF;
4021:
4022: OE_Credit_CHECK_UTIL.Get_Credit_Check_Rule_ID
4023: ( p_calling_action => p_calling_action
4024: , p_order_type_id => p_order_type_id
4025: , x_credit_rule_id => l_credit_check_rule_id
4026: );

Line 4050: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

4046: THEN
4047: OE_DEBUG_PUB.ADD('OEXUCRCB: Call GET_credit_check_rule ');
4048: END IF;
4049:
4050: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
4051: ( p_credit_check_rule_id => l_credit_check_rule_id
4052: , x_credit_check_rules_rec => l_credit_check_rule_rec
4053: );
4054:

Line 4096: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

4092: PROCEDURE GET_credit_check_rule
4093: ( p_header_id IN NUMBER := NULL
4094: , p_credit_check_rule_id IN NUMBER
4095: , x_credit_check_rules_rec OUT NOCOPY
4096: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4097: )
4098: IS
4099:
4100: BEGIN

Line 4339: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;

4335: p_header_id NUMBER,
4336: p_hold_release_id NUMBER)
4337: IS
4338: l_credit_check_rule_id NUMBER;
4339: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
4340: l_header_rec OE_Order_PUB.Header_Rec_Type;
4341: l_released_amount NUMBER;
4342: l_calling_action VARCHAR2(30);
4343: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 4343: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

4339: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
4340: l_header_rec OE_Order_PUB.Header_Rec_Type;
4341: l_released_amount NUMBER;
4342: l_calling_action VARCHAR2(30);
4343: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
4344: l_return_status VARCHAR2(30);
4345: BEGIN
4346: IF G_debug_flag = 'Y' THEN
4347: oe_debug_pub.add('Starting Update_Released_Amount');

Line 4354: OE_CREDIT_CHECK_UTIL.Get_Credit_Check_Rule_ID ( p_calling_action => l_calling_action , p_order_type_id => l_header_rec.order_type_id , x_credit_rule_id => l_credit_check_rule_id );

4350: END IF;
4351: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_header_id);
4352: oe_debug_pub.add('slagiset: l_calling_action ' || l_calling_action);
4353: OE_HEADER_UTIL.QUERY_ROW ( p_header_id => p_header_id, x_header_rec => l_header_rec);
4354: OE_CREDIT_CHECK_UTIL.Get_Credit_Check_Rule_ID ( p_calling_action => l_calling_action , p_order_type_id => l_header_rec.order_type_id , x_credit_rule_id => l_credit_check_rule_id );
4355: oe_debug_pub.add('slagiset: l_credit_check_rule_id ' || l_credit_check_rule_id);
4356:
4357: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule ( p_header_id => p_header_id ,
4358: p_credit_check_rule_id => l_credit_check_rule_id ,

Line 4357: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule ( p_header_id => p_header_id ,

4353: OE_HEADER_UTIL.QUERY_ROW ( p_header_id => p_header_id, x_header_rec => l_header_rec);
4354: OE_CREDIT_CHECK_UTIL.Get_Credit_Check_Rule_ID ( p_calling_action => l_calling_action , p_order_type_id => l_header_rec.order_type_id , x_credit_rule_id => l_credit_check_rule_id );
4355: oe_debug_pub.add('slagiset: l_credit_check_rule_id ' || l_credit_check_rule_id);
4356:
4357: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule ( p_header_id => p_header_id ,
4358: p_credit_check_rule_id => l_credit_check_rule_id ,
4359: x_credit_check_rules_rec => l_credit_check_rule_rec );
4360:
4361: l_credit_check_rule_rec.credit_check_level_code := 'ORDER';

Line 4363: OE_CREDIT_CHECK_UTIL.GET_transaction_amount ( p_header_id => p_header_id ,

4359: x_credit_check_rules_rec => l_credit_check_rule_rec );
4360:
4361: l_credit_check_rule_rec.credit_check_level_code := 'ORDER';
4362:
4363: OE_CREDIT_CHECK_UTIL.GET_transaction_amount ( p_header_id => p_header_id ,
4364: p_transaction_curr_code => l_header_rec.transactional_curr_code ,
4365: p_credit_check_rule_rec => l_credit_check_rule_rec ,
4366: p_system_parameter_rec => NULL ,
4367: p_customer_id => NULL ,

Line 4487: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

4483: PROCEDURE GET_transaction_amount
4484: ( p_header_id IN NUMBER
4485: , p_transaction_curr_code IN VARCHAR2
4486: , p_credit_check_rule_rec IN
4487: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4488: , p_system_parameter_rec IN
4489: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
4490: , p_customer_id IN NUMBER
4491: , p_site_use_id IN NUMBER

Line 4489: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

4485: , p_transaction_curr_code IN VARCHAR2
4486: , p_credit_check_rule_rec IN
4487: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4488: , p_system_parameter_rec IN
4489: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
4490: , p_customer_id IN NUMBER
4491: , p_site_use_id IN NUMBER
4492: , p_limit_curr_code IN VARCHAR2
4493: , p_all_lines IN VARCHAR2 := 'N' --ER 12363706

Line 4495: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE

4491: , p_site_use_id IN NUMBER
4492: , p_limit_curr_code IN VARCHAR2
4493: , p_all_lines IN VARCHAR2 := 'N' --ER 12363706
4494: , x_amount OUT NOCOPY NUMBER
4495: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
4496: , x_return_status OUT NOCOPY VARCHAR2
4497: )
4498: IS
4499:

Line 4524: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;

4520: -- Bug 2328351 check for line ctg code as well
4521:
4522: x_return_status := FND_API.G_RET_STS_SUCCESS;
4523:
4524: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
4525:
4526: IF p_credit_check_rule_rec.credit_check_level_code = 'LINE'
4527: THEN
4528: IF G_debug_flag = 'Y'

Line 5411: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

5407: OE_DEBUG_PUB.ADD(' Total order amount = '|| l_order_value );
5408: END IF;
5409:
5410: l_limit_order_value :=
5411: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
5412: ( p_amount => l_order_value
5413: , p_transactional_currency => p_transaction_curr_code
5414: , p_limit_currency => p_limit_curr_code
5415: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 5425: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code

5421: END ;
5422:
5423: -- x_amount := NVL(l_limit_order_value,0) ;
5424:
5425: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
5426: ,p_unrounded_amount => NVL(l_limit_order_value,0)
5427: ,x_rounded_amount => x_amount);
5428:
5429: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

Line 5429: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

5425: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
5426: ,p_unrounded_amount => NVL(l_limit_order_value,0)
5427: ,x_rounded_amount => x_amount);
5428:
5429: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;
5430:
5431: IF G_debug_flag = 'Y'
5432: THEN
5433: OE_DEBUG_PUB.Add(' g_current_order_value = '||

Line 5434: OE_CREDIT_CHECK_UTIL.g_current_order_value );

5430:
5431: IF G_debug_flag = 'Y'
5432: THEN
5433: OE_DEBUG_PUB.Add(' g_current_order_value = '||
5434: OE_CREDIT_CHECK_UTIL.g_current_order_value );
5435: OE_DEBUG_PUB.Add(' Final trx check order amount = '|| x_amount,1 );
5436: OE_DEBUG_PUB.Add(' ====================================');
5437: END IF;
5438:

Line 5491: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

5487: ( p_customer_id IN NUMBER
5488: , p_site_use_id IN NUMBER
5489: , p_party_id IN NUMBER
5490: , p_credit_check_rule_rec IN
5491: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5492: , p_system_parameter_rec IN
5493: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5494: , p_credit_level IN VARCHAR2
5495: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

Line 5493: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

5489: , p_party_id IN NUMBER
5490: , p_credit_check_rule_rec IN
5491: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5492: , p_system_parameter_rec IN
5493: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5494: , p_credit_level IN VARCHAR2
5495: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5496: , p_include_all_flag IN VARCHAR2
5497: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 5495: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

5491: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5492: , p_system_parameter_rec IN
5493: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5494: , p_credit_level IN VARCHAR2
5495: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5496: , p_include_all_flag IN VARCHAR2
5497: , p_global_exposure_flag IN VARCHAR2 := 'N'
5498: , x_exist_flag OUT NOCOPY VARCHAR2
5499: , x_return_status OUT NOCOPY VARCHAR2

Line 5792: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

5788: , p_transaction_curr_code IN VARCHAR2
5789: , p_customer_id IN NUMBER
5790: , p_site_use_id IN NUMBER
5791: , p_credit_check_rule_rec IN
5792: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5793: , p_system_parameter_rec IN
5794: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5795: , p_credit_level IN VARCHAR2
5796: , p_limit_curr_code IN VARCHAR2

Line 5794: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

5790: , p_site_use_id IN NUMBER
5791: , p_credit_check_rule_rec IN
5792: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5793: , p_system_parameter_rec IN
5794: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5795: , p_credit_level IN VARCHAR2
5796: , p_limit_curr_code IN VARCHAR2
5797: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5798: , p_include_all_flag IN VARCHAR2

Line 5797: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

5793: , p_system_parameter_rec IN
5794: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5795: , p_credit_level IN VARCHAR2
5796: , p_limit_curr_code IN VARCHAR2
5797: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5798: , p_include_all_flag IN VARCHAR2
5799: , p_global_exposure_flag IN VARCHAR2 := 'N'
5800: , p_need_exposure_details IN VARCHAR2 := 'N'
5801: , x_total_exposure OUT NOCOPY NUMBER

Line 9145: IF oe_credit_check_util.Check_drawee_exists

9141:
9142: -------------------------------------- BR support ---------------
9143: IF l_open_ar_days > 0
9144: THEN
9145: IF oe_credit_check_util.Check_drawee_exists
9146: (p_cust_account_id => p_customer_id ) = 'Y'
9147: THEN
9148: IF G_debug_flag = 'Y'
9149: THEN

Line 10264: OE_CREDIT_CHECK_UTIL.GET_GL_currency ;

10260: THEN
10261: OE_DEBUG_PUB.ADD(' Call GET_GL_currency ');
10262:
10263: OE_Credit_Engine_GRP.GL_currency :=
10264: OE_CREDIT_CHECK_UTIL.GET_GL_currency ;
10265:
10266: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '
10267: || OE_Credit_Engine_GRP.GL_currency );
10268:

Line 10272: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10268:
10269: END IF;
10270:
10271: l_limit_total_exposure :=
10272: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10273: ( p_amount => l_usage_total_exposure
10274: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10275: , p_limit_currency => p_limit_curr_code
10276: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10292: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10288: oe_debug_pub.add( ' Into p_need_exposure_details ');
10289: END IF;
10290:
10291: l_limit_cum_order_amount :=
10292: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10293: ( p_amount => l_cum_order_amount
10294: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10295: , p_limit_currency => p_limit_curr_code
10296: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10304: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10300: );
10301:
10302:
10303: l_limit_cum_order_hold_amount :=
10304: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10305: ( p_amount =>l_cum_order_hold_amount
10306: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10307: , p_limit_currency => p_limit_curr_code
10308: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10315: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10311: p_credit_check_rule_rec.conversion_type
10312: );
10313:
10314: l_limit_cum_ar_amount :=
10315: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10316: ( p_amount => l_cum_ar_amount
10317: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10318: , p_limit_currency => p_limit_curr_code
10319: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10476: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);

10472: ----------------------------- BR ------------------------
10473: IF l_open_ar_balance_flag = 'Y'
10474: THEN
10475: l_drawee_site_use_id :=
10476: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);
10477: END IF;
10478:
10479: IF G_debug_flag = 'Y'
10480: THEN

Line 11042: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

11038: OE_Credit_Engine_GRP.GL_currency );
11039: END IF;
11040:
11041: l_limit_total_exposure :=
11042: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
11043: ( p_amount => l_usage_total_exposure
11044: , p_transactional_currency => p_usage_curr(i).usage_curr_code
11045: , p_limit_currency => p_limit_curr_code
11046: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 11060: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

11056: oe_debug_pub.add( ' Into p_need_exposure_details ');
11057: END IF;
11058:
11059: l_limit_cum_order_amount :=
11060: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
11061: ( p_amount => l_cum_order_amount
11062: , p_transactional_currency => p_usage_curr(i).usage_curr_code
11063: , p_limit_currency => p_limit_curr_code
11064: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 11071: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

11067: p_credit_check_rule_rec.conversion_type
11068: );
11069:
11070: l_limit_cum_order_hold_amount :=
11071: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
11072: ( p_amount => l_cum_order_hold_amount
11073: , p_transactional_currency => p_usage_curr(i).usage_curr_code
11074: , p_limit_currency => p_limit_curr_code
11075: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 11081: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

11077: , p_conversion_type =>
11078: p_credit_check_rule_rec.conversion_type
11079: );
11080: l_limit_cum_ar_amount :=
11081: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
11082: ( p_amount => l_cum_ar_amount
11083: , p_transactional_currency => p_usage_curr(i).usage_curr_code
11084: , p_limit_currency => p_limit_curr_code
11085: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 11173: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0);

11169: -- Check the global. Get the current order value fromt the global
11170: -- this global would be set when calculating the transaction amount.
11171:
11172: l_limit_current_order :=
11173: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0);
11174:
11175: IF G_debug_flag = 'Y'
11176: THEN
11177: OE_DEBUG_PUB.Add(' Current order value is available already = '

Line 11178: || OE_CREDIT_CHECK_UTIL.g_current_order_value );

11174:
11175: IF G_debug_flag = 'Y'
11176: THEN
11177: OE_DEBUG_PUB.Add(' Current order value is available already = '
11178: || OE_CREDIT_CHECK_UTIL.g_current_order_value );
11179: OE_DEBUG_PUB.Add(' l_limit_current_order = '||
11180: l_limit_current_order );
11181: END IF;
11182: END ; -- p_header_id

Line 11208: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;

11204: x_order_hold_amount := l_order_hold_amount;
11205: x_ar_amount := l_ar_amount;
11206: END IF;
11207:
11208: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
11209:
11210: --bug# 2714553
11211: OE_CREDIT_INTERFACE_UTIL.Get_exposure_amount
11212: ( p_header_id => p_header_id

Line 11332: l_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;

11328: l_CREDIT_CHECK_FLAG VARCHAR2(1);
11329: l_OVERALL_CREDIT_LIMIT NUMBER;
11330: l_TRX_CREDIT_LIMIT NUMBER;
11331: l_include_all_flag VARCHAR2(1);
11332: l_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;
11333: l_global_exposure_flag VARCHAR2(1);
11334: l_credit_limit_party_id NUMBER ;
11335: l_use_credit_hierarchy varchar2(1);
11336:

Line 11520: oe_debug_pub.ADD('In OE_CREDIT_CHECK_UTIL.Send_Credit_Hold_NTF', 1);

11516:
11517: BEGIN
11518: IF G_debug_flag = 'Y'
11519: THEN
11520: oe_debug_pub.ADD('In OE_CREDIT_CHECK_UTIL.Send_Credit_Hold_NTF', 1);
11521: END IF;
11522:
11523: -- Initialize return status to success
11524: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11696: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

11692: PROCEDURE GET_external_trx_amount
11693: ( p_transaction_curr_code IN VARCHAR2
11694: , p_transaction_amount IN NUMBER
11695: , p_credit_check_rule_rec IN
11696: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
11697: , p_system_parameter_rec IN
11698: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
11699: , p_limit_curr_code IN VARCHAR2
11700: , x_amount OUT NOCOPY NUMBER

Line 11698: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

11694: , p_transaction_amount IN NUMBER
11695: , p_credit_check_rule_rec IN
11696: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
11697: , p_system_parameter_rec IN
11698: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
11699: , p_limit_curr_code IN VARCHAR2
11700: , x_amount OUT NOCOPY NUMBER
11701: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
11702: , x_return_status OUT NOCOPY VARCHAR2

Line 11701: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE

11697: , p_system_parameter_rec IN
11698: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
11699: , p_limit_curr_code IN VARCHAR2
11700: , x_amount OUT NOCOPY NUMBER
11701: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
11702: , x_return_status OUT NOCOPY VARCHAR2
11703: )
11704: IS
11705: l_limit_order_value NUMBER := 0;

Line 11714: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;

11710: OE_DEBUG_PUB.ADD('OEXUCRCB: IN GET_external_trx_amount');
11711: END IF;
11712:
11713: x_return_status := FND_API.G_RET_STS_SUCCESS;
11714: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
11715:
11716: IF G_debug_flag = 'Y'
11717: THEN
11718: OE_DEBUG_PUB.ADD('Order Level Credit Check only');

Line 11730: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

11726: END IF;
11727:
11728:
11729: l_limit_order_value :=
11730: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
11731: ( p_amount => p_transaction_amount
11732: , p_transactional_currency => p_transaction_curr_code
11733: , p_limit_currency => p_limit_curr_code
11734: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 11741: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code

11737: );
11738: END ;
11739: -- x_amount := NVL(l_limit_order_value,0);
11740:
11741: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
11742: ,p_unrounded_amount => NVL(l_limit_order_value,0)
11743: ,x_rounded_amount => x_amount);
11744:
11745: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

Line 11745: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

11741: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
11742: ,p_unrounded_amount => NVL(l_limit_order_value,0)
11743: ,x_rounded_amount => x_amount);
11744:
11745: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;
11746:
11747: IF G_debug_flag = 'Y'
11748: THEN
11749: OE_DEBUG_PUB.Add(' g_current_order_value = '||

Line 11750: OE_CREDIT_CHECK_UTIL.g_current_order_value);

11746:
11747: IF G_debug_flag = 'Y'
11748: THEN
11749: OE_DEBUG_PUB.Add(' g_current_order_value = '||
11750: OE_CREDIT_CHECK_UTIL.g_current_order_value);
11751: OE_DEBUG_PUB.Add(' Final trx check order amount = '|| x_amount,1 );
11752: OE_DEBUG_PUB.Add(' ====================================');
11753: OE_DEBUG_PUB.ADD('OEXUCRCB: OUT NOCOPY Get_external_trx_amount ');
11754: END IF;

Line 11906: OE_CREDIT_CHECK_UTIL.curr_tbl_type

11902: , x_trx_limit OUT NOCOPY NUMBER
11903: , x_overall_limit OUT NOCOPY NUMBER
11904: , x_include_all_flag OUT NOCOPY VARCHAR2
11905: , x_usage_curr_tbl OUT NOCOPY
11906: OE_CREDIT_CHECK_UTIL.curr_tbl_type
11907: , x_default_limit_flag OUT NOCOPY VARCHAR2
11908: , x_global_exposure_flag OUT NOCOPY VARCHAR2
11909: , x_credit_limit_entity_id OUT NOCOPY NUMBER
11910: , x_credit_check_level OUT NOCOPY VARCHAR2

Line 11935: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := NULL ;

11931: x_global_exposure_flag := 'N' ;
11932: l_suppress_unused_usages_flag := p_suppress_unused_usages_flag ;
11933: x_default_limit_flag := 'N' ;
11934:
11935: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := NULL ;
11936:
11937: IF G_debug_flag = 'Y'
11938: THEN
11939:

Line 12030: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

12026: ------- Party level changes
12027: -----------------------------------------------------
12028: IF p_precalc_exposure_used = 'Y'
12029: THEN
12030: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
12031: THEN
12032: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
12033: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
12034: END IF;

Line 12032: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

12028: IF p_precalc_exposure_used = 'Y'
12029: THEN
12030: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
12031: THEN
12032: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
12033: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
12034: END IF;
12035:
12036: -- Get party limit only if credit management is installed

Line 12037: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

12033: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
12034: END IF;
12035:
12036: -- Get party limit only if credit management is installed
12037: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed
12038: THEN
12039: IF x_limit_curr_code IS NULL
12040: THEN
12041: IF G_debug_flag = 'Y'

Line 12206: END OE_CREDIT_CHECK_UTIL;

12202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12203: END Get_CC_Lookup_Meaning;
12204:
12205:
12206: END OE_CREDIT_CHECK_UTIL;