DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_ENGINE_GRP

Line 4403: oe_debug_pub.add('OEXUCRCB: OE_Credit_Engine_GRP.G_Credit_Profile_Level ' || OE_Credit_Engine_GRP.G_Credit_Profile_Level);

4399: l_hold_source_id NUMBER;
4400: BEGIN
4401: IF G_debug_flag = 'Y' THEN
4402: oe_debug_pub.add('Starting Update_Credit_Profile_Level');
4403: oe_debug_pub.add('OEXUCRCB: OE_Credit_Engine_GRP.G_Credit_Profile_Level ' || OE_Credit_Engine_GRP.G_Credit_Profile_Level);
4404: END IF;
4405:
4406: IF p_hold_source_rec.hold_source_id IS NOT NULL
4407: THEN

Line 4456: SET Credit_Profile_Level=OE_Credit_Engine_GRP.G_Credit_Profile_Level,

4452: END IF;
4453: END IF;
4454:
4455: UPDATE OE_ORDER_HOLDS_ALL
4456: SET Credit_Profile_Level=OE_Credit_Engine_GRP.G_Credit_Profile_Level,
4457: Last_Update_Date = SYSDATE,
4458: Last_Updated_By = FND_GLOBAL.user_id
4459: WHERE hold_source_id = l_hold_source_id;
4460:

Line 5395: OE_Credit_Engine_GRP.GL_currency );

5391: BEGIN
5392: IF G_debug_flag = 'Y'
5393: THEN
5394: OE_DEBUG_PUB.Add(' GL_CURRENCY = '||
5395: OE_Credit_Engine_GRP.GL_currency );
5396: END IF;
5397: -- Bug 8249878
5398: /* l_order_value := NVL(l_order_value,0)
5399: - NVL(l_commitment,0)

Line 5415: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
5416: , p_conversion_date => SYSDATE
5417: , p_conversion_type => p_credit_check_rule_rec.conversion_type
5418: );
5419:

Line 10255: OE_Credit_Engine_GRP.GL_currency );

10251: || l_cum_ar_amount);
10252:
10253: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );
10254: OE_DEBUG_PUB.Add(' GL_CURRENCY = '||
10255: OE_Credit_Engine_GRP.GL_currency );
10256: END IF;
10257:
10258:
10259: IF OE_Credit_Engine_GRP.GL_currency IS NULL

Line 10259: IF OE_Credit_Engine_GRP.GL_currency IS NULL

10255: OE_Credit_Engine_GRP.GL_currency );
10256: END IF;
10257:
10258:
10259: IF OE_Credit_Engine_GRP.GL_currency IS NULL
10260: THEN
10261: OE_DEBUG_PUB.ADD(' Call GET_GL_currency ');
10262:
10263: OE_Credit_Engine_GRP.GL_currency :=

Line 10263: OE_Credit_Engine_GRP.GL_currency :=

10259: IF OE_Credit_Engine_GRP.GL_currency IS NULL
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 );

Line 10267: || OE_Credit_Engine_GRP.GL_currency );

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:
10269: END IF;
10270:
10271: l_limit_total_exposure :=

Line 10276: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
10277: , p_conversion_date => SYSDATE
10278: , p_conversion_type => p_credit_check_rule_rec.conversion_type
10279: );
10280:

Line 10296: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
10297: , p_conversion_date => SYSDATE
10298: , p_conversion_type =>
10299: p_credit_check_rule_rec.conversion_type
10300: );

Line 10308: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
10309: , p_conversion_date => SYSDATE
10310: , p_conversion_type =>
10311: p_credit_check_rule_rec.conversion_type
10312: );

Line 10319: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
10320: , p_conversion_date => SYSDATE
10321: , p_conversion_type =>
10322: p_credit_check_rule_rec.conversion_type
10323: );

Line 11038: OE_Credit_Engine_GRP.GL_currency );

11034:
11035: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );
11036:
11037: OE_DEBUG_PUB.Add(' GL_CURRENCY = '||
11038: OE_Credit_Engine_GRP.GL_currency );
11039: END IF;
11040:
11041: l_limit_total_exposure :=
11042: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

Line 11046: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
11047: , p_conversion_date => SYSDATE
11048: , p_conversion_type => p_credit_check_rule_rec.conversion_type
11049: );
11050:

Line 11064: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
11065: , p_conversion_date => SYSDATE
11066: , p_conversion_type =>
11067: p_credit_check_rule_rec.conversion_type
11068: );

Line 11075: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
11076: , p_conversion_date => SYSDATE
11077: , p_conversion_type =>
11078: p_credit_check_rule_rec.conversion_type
11079: );

Line 11085: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
11086: , p_conversion_date => SYSDATE
11087: , p_conversion_type =>
11088: p_credit_check_rule_rec.conversion_type
11089: );

Line 11724: OE_DEBUG_PUB.Add(' GL_CURRENCY = '|| OE_Credit_Engine_GRP.GL_currency);

11720: -- convert amount
11721: BEGIN
11722: IF G_debug_flag = 'Y'
11723: THEN
11724: OE_DEBUG_PUB.Add(' GL_CURRENCY = '|| OE_Credit_Engine_GRP.GL_currency);
11725: OE_DEBUG_PUB.ADD(' Total order amount = '|| p_transaction_amount);
11726: END IF;
11727:
11728:

Line 11734: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

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
11735: , p_conversion_date => SYSDATE
11736: , p_conversion_type => p_credit_check_rule_rec.conversion_type
11737: );
11738: END ;