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.17.12010000.5 2008/11/14 12:34:53 msundara 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 3039: , x_usage_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

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

Line 3231: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;

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

Line 3251: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

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

Line 3301: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := NULL ;

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

Line 3508: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := l_excl_curr_list ;

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

Line 3513: OE_CREDIT_CHECK_UTIL.G_excl_curr_list );

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

Line 3782: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

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

Line 4003: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;

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

Line 4021: OE_Credit_CHECK_UTIL.Get_Credit_Check_Rule_ID

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

Line 4049: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

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

Line 4095: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

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

Line 4332: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

4328: PROCEDURE GET_transaction_amount
4329: ( p_header_id IN NUMBER
4330: , p_transaction_curr_code IN VARCHAR2
4331: , p_credit_check_rule_rec IN
4332: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4333: , p_system_parameter_rec IN
4334: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
4335: , p_customer_id IN NUMBER
4336: , p_site_use_id IN NUMBER

Line 4334: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

4330: , p_transaction_curr_code IN VARCHAR2
4331: , p_credit_check_rule_rec IN
4332: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4333: , p_system_parameter_rec IN
4334: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
4335: , p_customer_id IN NUMBER
4336: , p_site_use_id IN NUMBER
4337: , p_limit_curr_code IN VARCHAR2
4338: , x_amount OUT NOCOPY NUMBER

Line 4339: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE

4335: , p_customer_id IN NUMBER
4336: , p_site_use_id IN NUMBER
4337: , p_limit_curr_code IN VARCHAR2
4338: , x_amount OUT NOCOPY NUMBER
4339: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
4340: , x_return_status OUT NOCOPY VARCHAR2
4341: )
4342: IS
4343:

Line 4368: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;

4364: -- Bug 2328351 check for line ctg code as well
4365:
4366: x_return_status := FND_API.G_RET_STS_SUCCESS;
4367:
4368: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
4369:
4370: IF p_credit_check_rule_rec.credit_check_level_code = 'LINE'
4371: THEN
4372: IF G_debug_flag = 'Y'

Line 5205: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

5201: OE_DEBUG_PUB.ADD(' Total order amount = '|| l_order_value );
5202: END IF;
5203:
5204: l_limit_order_value :=
5205: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
5206: ( p_amount => l_order_value
5207: , p_transactional_currency => p_transaction_curr_code
5208: , p_limit_currency => p_limit_curr_code
5209: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 5219: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code

5215: END ;
5216:
5217: -- x_amount := NVL(l_limit_order_value,0) ;
5218:
5219: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
5220: ,p_unrounded_amount => NVL(l_limit_order_value,0)
5221: ,x_rounded_amount => x_amount);
5222:
5223: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

Line 5223: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

5219: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
5220: ,p_unrounded_amount => NVL(l_limit_order_value,0)
5221: ,x_rounded_amount => x_amount);
5222:
5223: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;
5224:
5225: IF G_debug_flag = 'Y'
5226: THEN
5227: OE_DEBUG_PUB.Add(' g_current_order_value = '||

Line 5228: OE_CREDIT_CHECK_UTIL.g_current_order_value );

5224:
5225: IF G_debug_flag = 'Y'
5226: THEN
5227: OE_DEBUG_PUB.Add(' g_current_order_value = '||
5228: OE_CREDIT_CHECK_UTIL.g_current_order_value );
5229: OE_DEBUG_PUB.Add(' Final trx check order amount = '|| x_amount,1 );
5230: OE_DEBUG_PUB.Add(' ====================================');
5231: END IF;
5232:

Line 5285: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

5281: ( p_customer_id IN NUMBER
5282: , p_site_use_id IN NUMBER
5283: , p_party_id IN NUMBER
5284: , p_credit_check_rule_rec IN
5285: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5286: , p_system_parameter_rec IN
5287: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5288: , p_credit_level IN VARCHAR2
5289: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

Line 5287: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

5283: , p_party_id IN NUMBER
5284: , p_credit_check_rule_rec IN
5285: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5286: , p_system_parameter_rec IN
5287: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5288: , p_credit_level IN VARCHAR2
5289: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5290: , p_include_all_flag IN VARCHAR2
5291: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 5289: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

5285: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5286: , p_system_parameter_rec IN
5287: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5288: , p_credit_level IN VARCHAR2
5289: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5290: , p_include_all_flag IN VARCHAR2
5291: , p_global_exposure_flag IN VARCHAR2 := 'N'
5292: , x_exist_flag OUT NOCOPY VARCHAR2
5293: , x_return_status OUT NOCOPY VARCHAR2

Line 5586: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

5582: , p_transaction_curr_code IN VARCHAR2
5583: , p_customer_id IN NUMBER
5584: , p_site_use_id IN NUMBER
5585: , p_credit_check_rule_rec IN
5586: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5587: , p_system_parameter_rec IN
5588: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5589: , p_credit_level IN VARCHAR2
5590: , p_limit_curr_code IN VARCHAR2

Line 5588: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

5584: , p_site_use_id IN NUMBER
5585: , p_credit_check_rule_rec IN
5586: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
5587: , p_system_parameter_rec IN
5588: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5589: , p_credit_level IN VARCHAR2
5590: , p_limit_curr_code IN VARCHAR2
5591: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5592: , p_include_all_flag IN VARCHAR2

Line 5591: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

5587: , p_system_parameter_rec IN
5588: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
5589: , p_credit_level IN VARCHAR2
5590: , p_limit_curr_code IN VARCHAR2
5591: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
5592: , p_include_all_flag IN VARCHAR2
5593: , p_global_exposure_flag IN VARCHAR2 := 'N'
5594: , p_need_exposure_details IN VARCHAR2 := 'N'
5595: , x_total_exposure OUT NOCOPY NUMBER

Line 8792: IF oe_credit_check_util.Check_drawee_exists

8788:
8789: -------------------------------------- BR support ---------------
8790: IF l_open_ar_days > 0
8791: THEN
8792: IF oe_credit_check_util.Check_drawee_exists
8793: (p_cust_account_id => p_customer_id ) = 'Y'
8794: THEN
8795: IF G_debug_flag = 'Y'
8796: THEN

Line 9911: OE_CREDIT_CHECK_UTIL.GET_GL_currency ;

9907: THEN
9908: OE_DEBUG_PUB.ADD(' Call GET_GL_currency ');
9909:
9910: OE_Credit_Engine_GRP.GL_currency :=
9911: OE_CREDIT_CHECK_UTIL.GET_GL_currency ;
9912:
9913: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '
9914: || OE_Credit_Engine_GRP.GL_currency );
9915:

Line 9919: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

9915:
9916: END IF;
9917:
9918: l_limit_total_exposure :=
9919: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
9920: ( p_amount => l_usage_total_exposure
9921: , p_transactional_currency => p_usage_curr(i).usage_curr_code
9922: , p_limit_currency => p_limit_curr_code
9923: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 9939: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

9935: oe_debug_pub.add( ' Into p_need_exposure_details ');
9936: END IF;
9937:
9938: l_limit_cum_order_amount :=
9939: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
9940: ( p_amount => l_cum_order_amount
9941: , p_transactional_currency => p_usage_curr(i).usage_curr_code
9942: , p_limit_currency => p_limit_curr_code
9943: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 9951: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

9947: );
9948:
9949:
9950: l_limit_cum_order_hold_amount :=
9951: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
9952: ( p_amount =>l_cum_order_hold_amount
9953: , p_transactional_currency => p_usage_curr(i).usage_curr_code
9954: , p_limit_currency => p_limit_curr_code
9955: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 9962: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

9958: p_credit_check_rule_rec.conversion_type
9959: );
9960:
9961: l_limit_cum_ar_amount :=
9962: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
9963: ( p_amount => l_cum_ar_amount
9964: , p_transactional_currency => p_usage_curr(i).usage_curr_code
9965: , p_limit_currency => p_limit_curr_code
9966: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10123: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);

10119: ----------------------------- BR ------------------------
10120: IF l_open_ar_balance_flag = 'Y'
10121: THEN
10122: l_drawee_site_use_id :=
10123: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);
10124: END IF;
10125:
10126: IF G_debug_flag = 'Y'
10127: THEN

Line 10689: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10685: OE_Credit_Engine_GRP.GL_currency );
10686: END IF;
10687:
10688: l_limit_total_exposure :=
10689: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10690: ( p_amount => l_usage_total_exposure
10691: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10692: , p_limit_currency => p_limit_curr_code
10693: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10707: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10703: oe_debug_pub.add( ' Into p_need_exposure_details ');
10704: END IF;
10705:
10706: l_limit_cum_order_amount :=
10707: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10708: ( p_amount => l_cum_order_amount
10709: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10710: , p_limit_currency => p_limit_curr_code
10711: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10718: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10714: p_credit_check_rule_rec.conversion_type
10715: );
10716:
10717: l_limit_cum_order_hold_amount :=
10718: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10719: ( p_amount => l_cum_order_hold_amount
10720: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10721: , p_limit_currency => p_limit_curr_code
10722: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 10728: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

10724: , p_conversion_type =>
10725: p_credit_check_rule_rec.conversion_type
10726: );
10727: l_limit_cum_ar_amount :=
10728: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
10729: ( p_amount => l_cum_ar_amount
10730: , p_transactional_currency => p_usage_curr(i).usage_curr_code
10731: , p_limit_currency => p_limit_curr_code
10732: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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

10816: -- Check the global. Get the current order value fromt the global
10817: -- this global would be set when calculating the transaction amount.
10818:
10819: l_limit_current_order :=
10820: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0);
10821:
10822: IF G_debug_flag = 'Y'
10823: THEN
10824: OE_DEBUG_PUB.Add(' Current order value is available already = '

Line 10825: || OE_CREDIT_CHECK_UTIL.g_current_order_value );

10821:
10822: IF G_debug_flag = 'Y'
10823: THEN
10824: OE_DEBUG_PUB.Add(' Current order value is available already = '
10825: || OE_CREDIT_CHECK_UTIL.g_current_order_value );
10826: OE_DEBUG_PUB.Add(' l_limit_current_order = '||
10827: l_limit_current_order );
10828: END IF;
10829: END ; -- p_header_id

Line 10855: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;

10851: x_order_hold_amount := l_order_hold_amount;
10852: x_ar_amount := l_ar_amount;
10853: END IF;
10854:
10855: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
10856:
10857: --bug# 2714553
10858: OE_CREDIT_INTERFACE_UTIL.Get_exposure_amount
10859: ( p_header_id => p_header_id

Line 10979: l_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;

10975: l_CREDIT_CHECK_FLAG VARCHAR2(1);
10976: l_OVERALL_CREDIT_LIMIT NUMBER;
10977: l_TRX_CREDIT_LIMIT NUMBER;
10978: l_include_all_flag VARCHAR2(1);
10979: l_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;
10980: l_global_exposure_flag VARCHAR2(1);
10981: l_credit_limit_party_id NUMBER ;
10982: l_use_credit_hierarchy varchar2(1);
10983:

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

11163:
11164: BEGIN
11165: IF G_debug_flag = 'Y'
11166: THEN
11167: oe_debug_pub.ADD('In OE_CREDIT_CHECK_UTIL.Send_Credit_Hold_NTF', 1);
11168: END IF;
11169:
11170: -- Initialize return status to success
11171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11337: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

11333: PROCEDURE GET_external_trx_amount
11334: ( p_transaction_curr_code IN VARCHAR2
11335: , p_transaction_amount IN NUMBER
11336: , p_credit_check_rule_rec IN
11337: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
11338: , p_system_parameter_rec IN
11339: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
11340: , p_limit_curr_code IN VARCHAR2
11341: , x_amount OUT NOCOPY NUMBER

Line 11339: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

11335: , p_transaction_amount IN NUMBER
11336: , p_credit_check_rule_rec IN
11337: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
11338: , p_system_parameter_rec IN
11339: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
11340: , p_limit_curr_code IN VARCHAR2
11341: , x_amount OUT NOCOPY NUMBER
11342: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
11343: , x_return_status OUT NOCOPY VARCHAR2

Line 11342: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE

11338: , p_system_parameter_rec IN
11339: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
11340: , p_limit_curr_code IN VARCHAR2
11341: , x_amount OUT NOCOPY NUMBER
11342: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE
11343: , x_return_status OUT NOCOPY VARCHAR2
11344: )
11345: IS
11346: l_limit_order_value NUMBER := 0;

Line 11355: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;

11351: OE_DEBUG_PUB.ADD('OEXUCRCB: IN GET_external_trx_amount');
11352: END IF;
11353:
11354: x_return_status := FND_API.G_RET_STS_SUCCESS;
11355: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
11356:
11357: IF G_debug_flag = 'Y'
11358: THEN
11359: OE_DEBUG_PUB.ADD('Order Level Credit Check only');

Line 11371: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

11367: END IF;
11368:
11369:
11370: l_limit_order_value :=
11371: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
11372: ( p_amount => p_transaction_amount
11373: , p_transactional_currency => p_transaction_curr_code
11374: , p_limit_currency => p_limit_curr_code
11375: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 11382: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code

11378: );
11379: END ;
11380: -- x_amount := NVL(l_limit_order_value,0);
11381:
11382: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
11383: ,p_unrounded_amount => NVL(l_limit_order_value,0)
11384: ,x_rounded_amount => x_amount);
11385:
11386: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

Line 11386: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;

11382: OE_CREDIT_CHECK_UTIL.Rounded_Amount(p_currency_code => p_limit_curr_code
11383: ,p_unrounded_amount => NVL(l_limit_order_value,0)
11384: ,x_rounded_amount => x_amount);
11385:
11386: OE_CREDIT_CHECK_UTIL.g_current_order_value := x_amount ;
11387:
11388: IF G_debug_flag = 'Y'
11389: THEN
11390: OE_DEBUG_PUB.Add(' g_current_order_value = '||

Line 11391: OE_CREDIT_CHECK_UTIL.g_current_order_value);

11387:
11388: IF G_debug_flag = 'Y'
11389: THEN
11390: OE_DEBUG_PUB.Add(' g_current_order_value = '||
11391: OE_CREDIT_CHECK_UTIL.g_current_order_value);
11392: OE_DEBUG_PUB.Add(' Final trx check order amount = '|| x_amount,1 );
11393: OE_DEBUG_PUB.Add(' ====================================');
11394: OE_DEBUG_PUB.ADD('OEXUCRCB: OUT NOCOPY Get_external_trx_amount ');
11395: END IF;

Line 11547: OE_CREDIT_CHECK_UTIL.curr_tbl_type

11543: , x_trx_limit OUT NOCOPY NUMBER
11544: , x_overall_limit OUT NOCOPY NUMBER
11545: , x_include_all_flag OUT NOCOPY VARCHAR2
11546: , x_usage_curr_tbl OUT NOCOPY
11547: OE_CREDIT_CHECK_UTIL.curr_tbl_type
11548: , x_default_limit_flag OUT NOCOPY VARCHAR2
11549: , x_global_exposure_flag OUT NOCOPY VARCHAR2
11550: , x_credit_limit_entity_id OUT NOCOPY NUMBER
11551: , x_credit_check_level OUT NOCOPY VARCHAR2

Line 11576: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := NULL ;

11572: x_global_exposure_flag := 'N' ;
11573: l_suppress_unused_usages_flag := p_suppress_unused_usages_flag ;
11574: x_default_limit_flag := 'N' ;
11575:
11576: OE_CREDIT_CHECK_UTIL.G_excl_curr_list := NULL ;
11577:
11578: IF G_debug_flag = 'Y'
11579: THEN
11580:

Line 11669: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

11665: ------- Party level changes
11666: -----------------------------------------------------
11667: IF p_precalc_exposure_used = 'Y'
11668: THEN
11669: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
11670: THEN
11671: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
11672: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
11673: END IF;

Line 11671: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

11667: IF p_precalc_exposure_used = 'Y'
11668: THEN
11669: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
11670: THEN
11671: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
11672: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
11673: END IF;
11674:
11675: -- Get party limit only if credit management is installed

Line 11676: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

11672: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
11673: END IF;
11674:
11675: -- Get party limit only if credit management is installed
11676: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed
11677: THEN
11678: IF x_limit_curr_code IS NULL
11679: THEN
11680: IF G_debug_flag = 'Y'

Line 11845: END OE_CREDIT_CHECK_UTIL;

11841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11842: END Get_CC_Lookup_Meaning;
11843:
11844:
11845: END OE_CREDIT_CHECK_UTIL;