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.6.12010000.3 2008/11/14 11:52:18 msundara 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 269: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type

265: OE_HOLDS_PUB.Check_Holds
266: ( p_api_version => 1.0
267: , p_header_id => p_header_id
268: , p_hold_id => 1
269: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
270: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
271: , p_entity_code => 'O'
272: , p_entity_id => p_header_id
273: , x_result_out => l_hold_result

Line 270: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name

266: ( p_api_version => 1.0
267: , p_header_id => p_header_id
268: , p_hold_id => 1
269: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
270: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
271: , p_entity_code => 'O'
272: , p_entity_id => p_header_id
273: , x_result_out => l_hold_result
274: , x_msg_count => l_msg_count

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

288: p_header_id );
289: ELSE
290: l_hold_comment := 'Credit checking package API Error' ;
291: l_hold_source_rec.hold_comment :=
292: NVL(OE_Credit_Engine_GRP.G_currency_error_msg, l_hold_comment) ;
293:
294: OE_DEBUG_PUB.Add('Call OE_Holds_PUB.Apply_Holds' );
295:
296: OE_Holds_PUB.Apply_Holds

Line 442: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

438: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
439: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );
440: END IF;
441:
442: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
443:
444: IF G_debug_flag = 'Y'
445: THEN
446: OE_DEBUG_PUB.ADD('call Check_Credit for credit checking',1);

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

639: --- used later for unchecked exposure
640:
641: IF l_include_all_flag='Y'
642: THEN
643: OE_Credit_Engine_GRP.G_cust_incl_all_flag :='Y';
644: END IF;
645:
646: FOR a IN 1..l_usage_curr_tbl.COUNT
647: LOOP

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

653: END LOOP;
654: --------------------------------------------------------------------------------
655: ----assign table of usages to the Global variable
656:
657: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
658: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
659:
660: IF G_debug_flag = 'Y'
661: THEN

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

654: --------------------------------------------------------------------------------
655: ----assign table of usages to the Global variable
656:
657: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
658: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
659:
660: IF G_debug_flag = 'Y'
661: THEN
662: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

Line 670: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code

666:
667: FOR i IN l_start..l_end
668: LOOP
669: j:=j+1;
670: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code
671: := l_usage_curr_tbl(j).usage_curr_code;
672:
673: END LOOP;
674:

Line 748: OE_Credit_Engine_GRP.Set_context;

744:
745: /* Start MOAC CREDIT CHECK CHANGE */
746: IF l_global_exposure_flag = 'N'
747: THEN
748: OE_Credit_Engine_GRP.Set_context;
749: END IF;
750: /* End MOAC CREDIT CHECK CHANGE */
751:
752: IF G_debug_flag = 'Y'

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

779: --- used later for unchecked exposure
780:
781: IF l_include_all_flag='Y'
782: THEN
783: OE_Credit_Engine_GRP.G_cust_incl_all_flag :='Y';
784: END IF;
785:
786:
787: FOR a IN 1..l_usage_curr_tbl.COUNT

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

794: END LOOP;
795: --------------------------------------------------------------------------------
796: ----assign table of usages to the Global variable
797:
798: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
799: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
800:
801: IF G_debug_flag = 'Y'
802: THEN

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

795: --------------------------------------------------------------------------------
796: ----assign table of usages to the Global variable
797:
798: l_start:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+1;
799: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
800:
801: IF G_debug_flag = 'Y'
802: THEN
803: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

Line 811: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code

807:
808: FOR i IN l_start..l_end
809: LOOP
810: j:=j+1;
811: OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code
812: := l_usage_curr_tbl(j).usage_curr_code;
813:
814: END LOOP;
815:

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

997:
998: ----IF l_include_all_flag is 'Y', assign it to the global variable
999: IF l_include_all_flag='Y'
1000: THEN
1001: OE_Credit_Engine_GRP.G_site_incl_all_flag:='Y';
1002: END IF;
1003:
1004:
1005:

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

1012: END LOOP;
1013: --------------------------------------------------------------------------------
1014:
1015: ----assign table of usages to the Global variable
1016: l_start := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+1;
1017: l_end := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1018:
1019: IF G_debug_flag = 'Y'
1020: THEN

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

1013: --------------------------------------------------------------------------------
1014:
1015: ----assign table of usages to the Global variable
1016: l_start := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+1;
1017: l_end := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1018:
1019: IF G_debug_flag = 'Y'
1020: THEN
1021: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

Line 1031: OE_Credit_Engine_GRP.G_site_curr_tbl(i).usage_curr_code

1027: FOR i IN l_start..l_end
1028: LOOP
1029:
1030: j:=j+1;
1031: OE_Credit_Engine_GRP.G_site_curr_tbl(i).usage_curr_code
1032: := l_usage_curr_tbl(j).usage_curr_code;
1033:
1034: IF G_debug_flag = 'Y'
1035: THEN

Line 1230: OE_CREDIT_ENGINE_GRP.Get_customer_exposure

1226: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1227:
1228: END IF;
1229:
1230: OE_CREDIT_ENGINE_GRP.Get_customer_exposure
1231: ( p_party_id => NULL
1232: , p_customer_id => p_customer_id
1233: , p_site_id => p_site_id
1234: , p_limit_curr_code => p_limit_curr_code

Line 1318: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

1314: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );
1315: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1316: END IF;
1317:
1318: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1319: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
1320: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;
1321:
1322: --ER#7479609 start

Line 1319: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;

1315: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1316: END IF;
1317:
1318: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1319: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
1320: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;
1321:
1322: --ER#7479609 start
1323: IF p_calling_action in ('AUTO HOLD','AUTO RELEASE') THEN

Line 1320: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;

1316: END IF;
1317:
1318: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1319: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
1320: OE_Credit_Engine_GRP.G_delayed_request := p_delayed_request ;
1321:
1322: --ER#7479609 start
1323: IF p_calling_action in ('AUTO HOLD','AUTO RELEASE') THEN
1324: OE_Verify_Payment_PUB.G_init_calling_action := p_calling_action;

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

1332:
1333: -- Get Gl currency if calling action is not EXTERNAL
1334: --
1335: IF NVL(p_calling_action, 'BOOKING') <> 'EXTERNAL' THEN
1336: OE_Credit_Engine_GRP.GL_currency := OE_Credit_Engine_GRP.GET_GL_currency;
1337:
1338: OE_Header_UTIL.Query_Row
1339: (p_header_id => p_header_id
1340: ,x_header_rec => l_header_rec

Line 1386: OE_CREDIT_ENGINE_GRP.GL_Currency := p_functional_currency_code;

1382:
1383: ELSE
1384: -- External credit checking call
1385: l_credit_check_rule_id := p_credit_check_rule_id;
1386: OE_CREDIT_ENGINE_GRP.GL_Currency := p_functional_currency_code;
1387: l_header_rec.header_id := NULL;
1388: l_header_rec.transactional_curr_code := p_transaction_currency_code;
1389: l_header_rec.invoice_to_org_id := p_bill_to_site_use_id;
1390: END IF;

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

1390: END IF;
1391:
1392: IF G_debug_flag = 'Y'
1393: THEN
1394: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '|| OE_Credit_Engine_GRP.GL_currency );
1395: OE_DEBUG_PUB.ADD('l_credit_check_rule_id = '|| l_credit_check_rule_id );
1396: END IF;
1397:
1398: ----------------------- start Processing --------------------

Line 1520: OE_Credit_Engine_GRP.G_currency_error_msg );

1516: IF G_debug_flag = 'Y'
1517: THEN
1518: OE_DEBUG_PUB.ADD( ' x_return_status = '|| x_return_status );
1519: OE_DEBUG_PUB.ADD( ' G_currency_error_msg = '||
1520: OE_Credit_Engine_GRP.G_currency_error_msg );
1521: END IF;
1522: END IF;
1523:
1524: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1585: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

1581: END IF;
1582:
1583:
1584:
1585: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1586:
1587: IF p_calling_action = 'EXTERNAL'
1588: THEN
1589: OE_MSG_PUB.Count_And_Get

Line 1709: END OE_Credit_Engine_GRP ;

1705: END Set_context ;
1706:
1707: /* End MOAC CREDIT CHECK CHANGE */
1708:
1709: END OE_Credit_Engine_GRP ;