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_ENGINE_GRP dependencies on OE_CREDIT_ENGINE_GRP

Line 1: PACKAGE BODY OE_Credit_Engine_GRP AS

1: PACKAGE BODY OE_Credit_Engine_GRP AS
2: -- $Header: OEXPCRGB.pls 120.15 2012/01/04 06:48:15 slagiset ship $
3: --+=======================================================================+
4: --| Copyright (c) 2001 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 13: --| Body of package OE_Credit_Engine_GRP |

9: --| FILENAME |
10: --| OEXPCRGB.pls |
11: --| |
12: --| DESCRIPTION |
13: --| Body of package OE_Credit_Engine_GRP |
14: --| |
15: --| NOTES |
16: --| This package body contains the procedures that will be |
17: --| used to call Order Specific Payment Verification process |

Line 42: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Credit_Engine_GRP';

38:
39: --=========================================================================
40: -- CONSTANTS
41: --=========================================================================
42: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Credit_Engine_GRP';
43:
44: --=========================================================================
45: -- PRIVATE GLOBAL VARIABLES
46: --=========================================================================

Line 369: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

365: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
366: ( p_amount => l_released_order_amount
367: , p_transactional_currency => l_released_curr_code
368: , p_limit_currency => l_header_rec.transactional_curr_code
369: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency
370: , p_conversion_date => SYSDATE
371: , p_conversion_type => l_credit_check_rule_rec.conversion_type
372: );
373: ELSE

Line 395: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

391: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
392: ( p_amount => l_credit_check_rule_rec.tolerance_amount
393: , p_transactional_currency => l_credit_check_rule_rec.tolerance_curr_code
394: , p_limit_currency => l_header_rec.transactional_curr_code
395: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency
396: , p_conversion_date => SYSDATE
397: , p_conversion_type => l_credit_check_rule_rec.conversion_type
398: );
399: ELSE

Line 512: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type

508: OE_HOLDS_PUB.Check_Holds
509: ( p_api_version => 1.0
510: , p_header_id => p_header_id
511: , p_hold_id => 1
512: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
513: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
514: , p_entity_code => 'O'
515: , p_entity_id => p_header_id
516: , x_result_out => l_hold_result

Line 513: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name

509: ( p_api_version => 1.0
510: , p_header_id => p_header_id
511: , p_hold_id => 1
512: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
513: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
514: , p_entity_code => 'O'
515: , p_entity_id => p_header_id
516: , x_result_out => l_hold_result
517: , x_msg_count => l_msg_count

Line 535: NVL(OE_Credit_Engine_GRP.G_currency_error_msg, l_hold_comment) ;

531: p_header_id );
532: ELSE
533: l_hold_comment := 'Credit checking package API Error' ;
534: l_hold_source_rec.hold_comment :=
535: NVL(OE_Credit_Engine_GRP.G_currency_error_msg, l_hold_comment) ;
536:
537: OE_DEBUG_PUB.Add('Call OE_Holds_PUB.Apply_Holds' );
538:
539: OE_Holds_PUB.Apply_Holds

Line 685: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

681: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
682: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );
683: END IF;
684:
685: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
686:
687: IF G_debug_flag = 'Y'
688: THEN
689: OE_DEBUG_PUB.ADD('call Check_Credit for credit checking',1);

Line 891: OE_Credit_Engine_GRP.G_cust_incl_all_flag :='Y';

887: --- used later for unchecked exposure
888:
889: IF l_include_all_flag='Y'
890: THEN
891: OE_Credit_Engine_GRP.G_cust_incl_all_flag :='Y';
892: END IF;
893:
894: FOR a IN 1..l_usage_curr_tbl.COUNT
895: LOOP

Line 905: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;

901: END LOOP;
902: --------------------------------------------------------------------------------
903: ----assign table of usages to the Global variable
904:
905: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
906: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
907:
908: IF G_debug_flag = 'Y'
909: THEN

Line 906: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;

902: --------------------------------------------------------------------------------
903: ----assign table of usages to the Global variable
904:
905: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
906: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
907:
908: IF G_debug_flag = 'Y'
909: THEN
910: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

Line 918: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code

914:
915: FOR i IN l_start..l_end
916: LOOP
917: j:=j+1;
918: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code
919: := l_usage_curr_tbl(j).usage_curr_code;
920:
921: END LOOP;
922:

Line 996: OE_Credit_Engine_GRP.Set_context;

992:
993: /* Start MOAC CREDIT CHECK CHANGE */
994: IF l_global_exposure_flag = 'N'
995: THEN
996: OE_Credit_Engine_GRP.Set_context;
997: END IF;
998: /* End MOAC CREDIT CHECK CHANGE */
999:
1000: IF G_debug_flag = 'Y'

Line 1031: OE_Credit_Engine_GRP.G_cust_incl_all_flag :='Y';

1027: --- used later for unchecked exposure
1028:
1029: IF l_include_all_flag='Y'
1030: THEN
1031: OE_Credit_Engine_GRP.G_cust_incl_all_flag :='Y';
1032: END IF;
1033:
1034:
1035: FOR a IN 1..l_usage_curr_tbl.COUNT

Line 1046: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;

1042: END LOOP;
1043: --------------------------------------------------------------------------------
1044: ----assign table of usages to the Global variable
1045:
1046: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
1047: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1048:
1049: IF G_debug_flag = 'Y'
1050: THEN

Line 1047: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;

1043: --------------------------------------------------------------------------------
1044: ----assign table of usages to the Global variable
1045:
1046: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
1047: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1048:
1049: IF G_debug_flag = 'Y'
1050: THEN
1051: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

Line 1059: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code

1055:
1056: FOR i IN l_start..l_end
1057: LOOP
1058: j:=j+1;
1059: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code
1060: := l_usage_curr_tbl(j).usage_curr_code;
1061:
1062: END LOOP;
1063:

Line 1249: OE_Credit_Engine_GRP.G_site_incl_all_flag:='Y';

1245:
1246: ----IF l_include_all_flag is 'Y', assign it to the global variable
1247: IF l_include_all_flag='Y'
1248: THEN
1249: OE_Credit_Engine_GRP.G_site_incl_all_flag:='Y';
1250: END IF;
1251:
1252:
1253:

Line 1264: l_start := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+1;

1260: END LOOP;
1261: --------------------------------------------------------------------------------
1262:
1263: ----assign table of usages to the Global variable
1264: l_start := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+1;
1265: l_end := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1266:
1267: IF G_debug_flag = 'Y'
1268: THEN

Line 1265: l_end := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;

1261: --------------------------------------------------------------------------------
1262:
1263: ----assign table of usages to the Global variable
1264: l_start := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+1;
1265: l_end := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1266:
1267: IF G_debug_flag = 'Y'
1268: THEN
1269: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

Line 1279: OE_Credit_Engine_GRP.G_site_curr_tbl(i).usage_curr_code

1275: FOR i IN l_start..l_end
1276: LOOP
1277:
1278: j:=j+1;
1279: OE_Credit_Engine_GRP.G_site_curr_tbl(i).usage_curr_code
1280: := l_usage_curr_tbl(j).usage_curr_code;
1281:
1282: IF G_debug_flag = 'Y'
1283: THEN

Line 1478: OE_CREDIT_ENGINE_GRP.Get_customer_exposure

1474: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1475:
1476: END IF;
1477:
1478: OE_CREDIT_ENGINE_GRP.Get_customer_exposure
1479: ( p_party_id => NULL
1480: , p_customer_id => p_customer_id
1481: , p_site_id => p_site_id
1482: , p_limit_curr_code => p_limit_curr_code

Line 1566: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );
1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1564: END IF;
1565:
1566: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1567: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
1568: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;
1569:
1570: --ER#7479609 start

Line 1567: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;

1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1564: END IF;
1565:
1566: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1567: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
1568: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;
1569:
1570: --ER#7479609 start
1571: IF p_calling_action in ('AUTO HOLD','AUTO RELEASE') THEN

Line 1568: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;

1564: END IF;
1565:
1566: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1567: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
1568: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;
1569:
1570: --ER#7479609 start
1571: IF p_calling_action in ('AUTO HOLD','AUTO RELEASE') THEN
1572: OE_Verify_Payment_PUB.G_init_calling_action := p_calling_action;

Line 1584: OE_Credit_Engine_GRP.GL_currency := OE_Credit_Engine_GRP.GET_GL_currency;

1580:
1581: -- Get Gl currency if calling action is not EXTERNAL
1582: --
1583: IF NVL(p_calling_action, 'BOOKING') <> 'EXTERNAL' THEN
1584: OE_Credit_Engine_GRP.GL_currency := OE_Credit_Engine_GRP.GET_GL_currency;
1585:
1586: OE_Header_UTIL.Query_Row
1587: (p_header_id => p_header_id
1588: ,x_header_rec => l_header_rec

Line 1634: OE_CREDIT_ENGINE_GRP.GL_Currency := p_functional_currency_code;

1630:
1631: ELSE
1632: -- External credit checking call
1633: l_credit_check_rule_id := p_credit_check_rule_id;
1634: OE_CREDIT_ENGINE_GRP.GL_Currency := p_functional_currency_code;
1635: l_header_rec.header_id := NULL;
1636: l_header_rec.transactional_curr_code := p_transaction_currency_code;
1637: l_header_rec.invoice_to_org_id := p_bill_to_site_use_id;
1638: END IF;

Line 1642: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '|| OE_Credit_Engine_GRP.GL_currency );

1638: END IF;
1639:
1640: IF G_debug_flag = 'Y'
1641: THEN
1642: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '|| OE_Credit_Engine_GRP.GL_currency );
1643: OE_DEBUG_PUB.ADD('l_credit_check_rule_id = '|| l_credit_check_rule_id );
1644: END IF;
1645:
1646: ----------------------- start Processing --------------------

Line 1775: OE_Credit_Engine_GRP.G_currency_error_msg );

1771: IF G_debug_flag = 'Y'
1772: THEN
1773: OE_DEBUG_PUB.ADD( ' x_return_status = '|| x_return_status );
1774: OE_DEBUG_PUB.ADD( ' G_currency_error_msg = '||
1775: OE_Credit_Engine_GRP.G_currency_error_msg );
1776: END IF;
1777: END IF;
1778:
1779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1840: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

1836: END IF;
1837:
1838:
1839:
1840: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1841:
1842: IF p_calling_action = 'EXTERNAL'
1843: THEN
1844: OE_MSG_PUB.Count_And_Get

Line 1969: END OE_Credit_Engine_GRP ;

1965: END Set_context ;
1966:
1967: /* End MOAC CREDIT CHECK CHANGE */
1968:
1969: END OE_Credit_Engine_GRP ;