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

Line 67: G_debug_flag VARCHAR2(1) := NVL(OE_CREDIT_CHECK_UTIL.check_debug_flag,'N');

63:
64: ---------------------------
65: -- PRIVATE GLOBAL VARIABLES
66: ---------------------------
67: G_debug_flag VARCHAR2(1) := NVL(OE_CREDIT_CHECK_UTIL.check_debug_flag,'N');
68: G_result_out VARCHAR2(10) := 'PASS' ;
69: G_release_status VARCHAR2(30) := 'NO' ;
70: G_hdr_hold_released VARCHAR2(1) := 'N' ;
71: G_order NUMBER;

Line 648: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

644: --Needs amount conversion while checking amounts.
645: IF p_limit_currency <> p_transactional_currency THEN
646: l_converted_amt:=0;
647: l_converted_amt :=
648: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
649: ( p_amount => p_holds_table(i).line_total
650: , p_transactional_currency => p_transactional_currency
651: , p_limit_currency => p_limit_currency
652: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 706: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

702: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
703: , p_header_id IN NUMBER
704: , p_line_id IN NUMBER
705: , p_credit_check_rule_rec IN
706: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
707: )
708: RETURN VARCHAR2
709: IS
710: l_hold_release_id NUMBER;

Line 899: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

895: ( p_customer_id IN NUMBER
896: , p_site_use_id IN NUMBER
897: , p_party_id IN NUMBER
898: , p_credit_check_rule_rec IN
899: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
900: , p_system_parameter_rec IN
901: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
902: , p_credit_level IN VARCHAR2
903: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

Line 901: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

897: , p_party_id IN NUMBER
898: , p_credit_check_rule_rec IN
899: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
900: , p_system_parameter_rec IN
901: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
902: , p_credit_level IN VARCHAR2
903: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
904: , p_include_all_flag IN VARCHAR2
905: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 903: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

899: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
900: , p_system_parameter_rec IN
901: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
902: , p_credit_level IN VARCHAR2
903: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
904: , p_include_all_flag IN VARCHAR2
905: , p_global_exposure_flag IN VARCHAR2 := 'N'
906: , x_cc_result_out OUT NOCOPY VARCHAR2
907: , x_return_status OUT NOCOPY VARCHAR2

Line 925: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice

921: x_cc_result_out := 'PASS';
922:
923:
924:
925: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice
926: ( p_customer_id => p_customer_id
927: , p_site_use_id => p_site_use_id
928: , p_party_id => p_party_id
929: , p_credit_check_rule_rec => p_credit_check_rule_rec

Line 1093: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);

1089: -- FND_API.G_FALSE THEN
1090: IF p_cc_limit_used <> 'ITEM' THEN
1091: -- bug 4002820
1092: IF INSTR(p_cc_limit_used, ',') > 0 THEN
1093: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1094: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

Line 1308: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);

1304: -- bug 4002820
1305: IF INSTR(p_cc_limit_used, ',') > 0 THEN
1306:
1307: --bug 4153299
1308: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1309:
1310: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

Line 1443: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1439: , p_site_use_id IN NUMBER DEFAULT NULL
1440: , p_item_category_id IN NUMBER DEFAULT NULL
1441: , p_credit_hold_level IN VARCHAR2
1442: , p_credit_check_rule_rec IN
1443: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1444: , x_cc_result_out OUT NOCOPY VARCHAR2
1445: )
1446: IS
1447:

Line 1768: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1764: , p_cc_profile_used IN VARCHAR2
1765: , p_item_category_id IN NUMBER DEFAULT NULL
1766: , p_credit_hold_level IN VARCHAR2
1767: , p_credit_check_rule_rec IN
1768: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1769: , x_cc_result_out OUT NOCOPY VARCHAR2
1770: )
1771: IS
1772:

Line 2032: , p_lines IN OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type

2028:
2029: PROCEDURE Apply_Item_Category_Holds
2030: ( p_header_id IN NUMBER
2031: , p_item_category_id IN NUMBER
2032: , p_lines IN OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type
2033: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
2034: )
2035: IS
2036: i BINARY_INTEGER := 1;

Line 2275: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

2271: , p_customer_id IN NUMBER
2272: , p_site_use_id IN NUMBER
2273: , p_credit_level IN VARCHAR2
2274: , p_credit_check_rule_rec IN
2275: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2276: , p_system_parameter_rec IN
2277: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2278: , p_limit_curr_code IN VARCHAR2
2279: , p_trx_credit_limit IN NUMBER

Line 2277: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

2273: , p_credit_level IN VARCHAR2
2274: , p_credit_check_rule_rec IN
2275: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2276: , p_system_parameter_rec IN
2277: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2278: , p_limit_curr_code IN VARCHAR2
2279: , p_trx_credit_limit IN NUMBER
2280: , x_cc_result_out OUT NOCOPY VARCHAR2
2281: , x_return_status OUT NOCOPY VARCHAR2

Line 2282: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

2278: , p_limit_curr_code IN VARCHAR2
2279: , p_trx_credit_limit IN NUMBER
2280: , x_cc_result_out OUT NOCOPY VARCHAR2
2281: , x_return_status OUT NOCOPY VARCHAR2
2282: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
2283: )
2284: IS
2285:
2286: l_order_value NUMBER;

Line 2289: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;

2285:
2286: l_order_value NUMBER;
2287: l_customer_id NUMBER;
2288: -- 13987649
2289: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type;
2290:
2291: BEGIN
2292: IF G_debug_flag = 'Y'
2293: THEN

Line 2347: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

2343: OE_DEBUG_PUB.ADD(' l_customer_id = '|| l_customer_id );
2344: OE_DEBUG_PUB.ADD(' Call GET_transaction_amount ' );
2345: END IF;
2346:
2347: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
2348: ( p_header_id => p_header_rec.header_id
2349: , p_transaction_curr_code => p_header_rec.transactional_curr_code
2350: -- , p_credit_check_rule_rec => p_credit_check_rule_rec -- 13987649
2351: , p_credit_check_rule_rec => l_credit_check_rule_rec -- 13987649

Line 2454: OE_Credit_Check_Util.OE_credit_rules_rec_type

2450: , p_site_use_id IN NUMBER
2451: , p_calling_action IN VARCHAR2 := 'BOOKING'
2452: , p_party_id IN NUMBER
2453: , p_credit_check_rule_rec IN
2454: OE_Credit_Check_Util.OE_credit_rules_rec_type
2455: , x_check_order_flag OUT NOCOPY VARCHAR2
2456: , x_credit_check_lvl_out OUT NOCOPY VARCHAR2
2457: , x_default_limit_flag OUT NOCOPY VARCHAR2
2458: , x_limit_curr_code OUT NOCOPY VARCHAR2

Line 2461: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

2457: , x_default_limit_flag OUT NOCOPY VARCHAR2
2458: , x_limit_curr_code OUT NOCOPY VARCHAR2
2459: , x_overall_credit_limit OUT NOCOPY NUMBER
2460: , x_trx_credit_limit OUT NOCOPY NUMBER
2461: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
2462: , x_include_all_flag OUT NOCOPY VARCHAR2
2463: , x_return_status OUT NOCOPY VARCHAR2
2464: , x_global_exposure_flag OUT NOCOPY VARCHAR2
2465: , x_credit_limit_entity_id OUT NOCOPY NUMBER

Line 2517: OE_CREDIT_CHECK_UTIL.Get_Limit_Info

2513: -- default limits of the operating unit |
2514: -- [a 11.5.3 feature] |
2515: ------------------------------------------------
2516:
2517: OE_CREDIT_CHECK_UTIL.Get_Limit_Info
2518: ( p_header_id => p_header_rec.header_id
2519: , p_entity_type => 'SITE'
2520: , p_entity_id => p_site_use_id
2521: , p_cust_account_id => p_customer_id

Line 2627: OE_CREDIT_CHECK_UTIL.curr_tbl_type

2623: , p_limit_curr_code IN VARCHAR2
2624: , p_overall_credit_limit IN NUMBER
2625: , p_calling_action IN VARCHAR2
2626: , p_usage_curr IN
2627: OE_CREDIT_CHECK_UTIL.curr_tbl_type
2628: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
2629: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
2630: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
2631: , p_credit_check_rule_rec IN

Line 2632: OE_Credit_Check_Util.OE_credit_rules_rec_type

2628: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
2629: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
2630: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
2631: , p_credit_check_rule_rec IN
2632: OE_Credit_Check_Util.OE_credit_rules_rec_type
2633: , p_system_parameter_rec IN
2634: OE_Credit_Check_Util.OE_systems_param_rec_type
2635: , p_global_exposure_flag IN VARCHAR2 := 'N'
2636: , p_party_id IN NUMBER

Line 2634: OE_Credit_Check_Util.OE_systems_param_rec_type

2630: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
2631: , p_credit_check_rule_rec IN
2632: OE_Credit_Check_Util.OE_credit_rules_rec_type
2633: , p_system_parameter_rec IN
2634: OE_Credit_Check_Util.OE_systems_param_rec_type
2635: , p_global_exposure_flag IN VARCHAR2 := 'N'
2636: , p_party_id IN NUMBER
2637: , p_credit_limit_entity_id IN NUMBER
2638: , x_total_exposure OUT NOCOPY NUMBER

Line 2641: OE_CREDIT_CHECK_UTIL.curr_tbl_type

2637: , p_credit_limit_entity_id IN NUMBER
2638: , x_total_exposure OUT NOCOPY NUMBER
2639: , x_cc_result_out OUT NOCOPY VARCHAR2
2640: , x_error_curr_tbl OUT NOCOPY
2641: OE_CREDIT_CHECK_UTIL.curr_tbl_type
2642: , x_return_status OUT NOCOPY VARCHAR2
2643: )
2644: IS
2645: l_customer_id NUMBER;

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

2760: and NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
2761: FND_API.G_FALSE
2762: THEN
2763: l_current_order_value :=
2764: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
2765: ELSE
2766: IF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
2767: THEN
2768: l_current_order_value :=

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

2765: ELSE
2766: IF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
2767: THEN
2768: l_current_order_value :=
2769: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
2770: ELSE
2771: l_current_order_value := 0 ;
2772: END IF;
2773: END IF;

Line 2879: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

2875: , p_customer_id IN NUMBER
2876: , p_site_use_id IN NUMBER
2877: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2878: , p_credit_check_rule_rec IN
2879: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2880: , p_system_parameter_rec IN
2881: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2882: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
2883: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 2881: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

2877: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2878: , p_credit_check_rule_rec IN
2879: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2880: , p_system_parameter_rec IN
2881: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2882: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
2883: , x_cc_result_out OUT NOCOPY VARCHAR2
2884: , x_return_status OUT NOCOPY VARCHAR2
2885: )

Line 2893: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;

2889:
2890: l_return_status VARCHAR2(30);
2891: l_credit_hold_level VARCHAR2(30);
2892: l_include_tax_flag VARCHAR2(1) := 'Y';
2893: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2894: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2895: j BINARY_INTEGER := 1;
2896: i BINARY_INTEGER := 1;
2897: l_cc_result_out VARCHAR2(30);

Line 2894: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;

2890: l_return_status VARCHAR2(30);
2891: l_credit_hold_level VARCHAR2(30);
2892: l_include_tax_flag VARCHAR2(1) := 'Y';
2893: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2894: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2895: j BINARY_INTEGER := 1;
2896: i BINARY_INTEGER := 1;
2897: l_cc_result_out VARCHAR2(30);
2898: l_check_category_id NUMBER;

Line 2916: OE_CREDIT_CHECK_UTIL.Get_Item_Limit

2912: l_include_tax_flag := p_credit_check_rule_rec.include_tax_flag ;
2913:
2914: OE_DEBUG_PUB.Add(' Call Get_Item_Limit ');
2915:
2916: OE_CREDIT_CHECK_UTIL.Get_Item_Limit
2917: ( p_header_id => p_header_rec.header_id
2918: , p_include_tax_flag => p_credit_check_rule_rec.include_tax_flag
2919: , p_site_use_id => p_site_use_id
2920: , p_trx_curr_code => p_header_rec.transactional_curr_code

Line 2972: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2968: l_check_category_id := l_item_limits(i).item_category_id ;
2969: l_limit_currency := l_item_limits(i).limit_curr_code ;
2970:
2971: l_limit_category_sum :=
2972: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2973: ( p_amount => l_category_sum
2974: , p_transactional_currency => p_header_rec.transactional_curr_code
2975: , p_limit_currency => l_item_limits(i).limit_curr_code
2976: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 3105: OE_Credit_Check_Util.OE_credit_rules_rec_type

3101: , p_customer_id IN NUMBER
3102: , p_site_use_id IN NUMBER
3103: , p_calling_action IN VARCHAR2 := 'BOOKING'
3104: , p_credit_check_rule_rec IN
3105: OE_Credit_Check_Util.OE_credit_rules_rec_type
3106: , p_system_parameter_rec IN
3107: OE_Credit_Check_Util.OE_systems_param_rec_type
3108: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
3109: , p_party_id IN NUMBER

Line 3107: OE_Credit_Check_Util.OE_systems_param_rec_type

3103: , p_calling_action IN VARCHAR2 := 'BOOKING'
3104: , p_credit_check_rule_rec IN
3105: OE_Credit_Check_Util.OE_credit_rules_rec_type
3106: , p_system_parameter_rec IN
3107: OE_Credit_Check_Util.OE_systems_param_rec_type
3108: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
3109: , p_party_id IN NUMBER
3110: , x_credit_level OUT NOCOPY VARCHAR2
3111: , x_check_exposure_mode OUT NOCOPY VARCHAR2

Line 3123: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;

3119: l_default_limit_flag VARCHAR2(1);
3120: l_limit_curr_code VARCHAR2(30);
3121: l_overall_credit_limit NUMBER;
3122: l_trx_credit_limit NUMBER;
3123: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;
3124: l_include_all_flag VARCHAR2(1);
3125: l_prev_customer_id NUMBER;
3126: l_customer_result_out VARCHAR2(30) := NULL;
3127: l_total_exposure NUMBER;

Line 3132: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;

3128: l_orders NUMBER;
3129: l_orders_on_hold NUMBER;
3130: l_payments_overdue NUMBER;
3131: l_payments_at_risk NUMBER;
3132: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;
3133: l_cc_profile_used VARCHAR2(30);
3134: l_cc_limit_used VARCHAR2(80);
3135: l_cc_result_out VARCHAR2(30);
3136: l_credit_hold_level VARCHAR2(30);

Line 3289: FOR i IN 1 .. OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.count

3285: l_credit_profile_level := NULL;
3286: END;
3287: END IF;
3288:
3289: FOR i IN 1 .. OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.count
3290: LOOP
3291: l_line_exists := 'N';
3292:
3293: IF G_debug_flag = 'Y' THEN

Line 3300: IF OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id = p_holds_table(k).line_id THEN

3296: END IF;
3297:
3298: FOR k IN 1 ..p_holds_table.count
3299: LOOP
3300: IF OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id = p_holds_table(k).line_id THEN
3301: l_line_exists := 'Y';
3302: --13706069 start
3303: ELSE
3304: IF G_debug_flag = 'Y' THEN

Line 3305: oe_debug_pub.add('OEXVCRLB: Bill To site is not changed for the line.' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);

3301: l_line_exists := 'Y';
3302: --13706069 start
3303: ELSE
3304: IF G_debug_flag = 'Y' THEN
3305: oe_debug_pub.add('OEXVCRLB: Bill To site is not changed for the line.' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);
3306: END IF;
3307:
3308: l_tolerance_check := 'Y';
3309: --13706069 end

Line 3314: IF OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id IS NOT NULL AND p_credit_check_rule_rec.credit_hold_level_code = 'LINE' THEN

3310: END IF;
3311: END LOOP;
3312:
3313: IF l_line_exists = 'Y' THEN
3314: IF OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id IS NOT NULL AND p_credit_check_rule_rec.credit_hold_level_code = 'LINE' THEN
3315:
3316: --13706069 start
3317: BEGIN
3318: IF G_debug_flag = 'Y' THEN

Line 3319: OE_DEBUG_PUB.Add('OEXVCRLB: Retrieve the latest released Credit Profile ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);

3315:
3316: --13706069 start
3317: BEGIN
3318: IF G_debug_flag = 'Y' THEN
3319: OE_DEBUG_PUB.Add('OEXVCRLB: Retrieve the latest released Credit Profile ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);
3320: END IF;
3321:
3322: OPEN released_hold_line(OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);
3323: FETCH released_hold_line INTO l_credit_profile_level;

Line 3322: OPEN released_hold_line(OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);

3318: IF G_debug_flag = 'Y' THEN
3319: OE_DEBUG_PUB.Add('OEXVCRLB: Retrieve the latest released Credit Profile ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);
3320: END IF;
3321:
3322: OPEN released_hold_line(OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).line_id);
3323: FETCH released_hold_line INTO l_credit_profile_level;
3324:
3325: IF (released_hold_line%notfound) THEN
3326: oe_debug_pub.add('No Released record found');

Line 3348: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id

3344: INTO l_new_cust_account_id
3345: FROM HZ_CUST_SITE_USES_ALL SITE,
3346: HZ_PARTY_SITES PARTY_SITE,
3347: HZ_CUST_ACCT_SITES ACCT_SITE
3348: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id
3349: AND SITE.SITE_USE_CODE = 'BILL_TO'
3350: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
3351: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
3352: AND SITE.ORG_ID = ACCT_SITE.ORG_ID;

Line 3359: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id

3355: INTO l_old_cust_account_id
3356: FROM HZ_CUST_SITE_USES_ALL SITE,
3357: HZ_PARTY_SITES PARTY_SITE,
3358: HZ_CUST_ACCT_SITES ACCT_SITE
3359: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id
3360: AND SITE.SITE_USE_CODE = 'BILL_TO'
3361: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
3362: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
3363: AND SITE.ORG_ID = ACCT_SITE.ORG_ID;

Line 3391: -- OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; Commented for bug# 13706069

3387: RETURN;
3388: END IF;
3389: END IF;
3390:
3391: -- OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; Commented for bug# 13706069
3392: --ER 12363706 end
3393: IF G_debug_flag = 'Y'
3394: THEN
3395: OE_DEBUG_PUB.Add(' After Validate_other_credit_check status '

Line 3486: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

3482: -- Changed IF condition to fix bug 4002820, need to do overall
3483: -- limit checking even order limit checking failed when
3484: -- Credit Management is installed and used.
3485:
3486: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3487: THEN
3488: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3489: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3490: END IF;

Line 3488: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

3484: -- Credit Management is installed and used.
3485:
3486: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3487: THEN
3488: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3489: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3490: END IF;
3491:
3492: IF l_cc_duedate_result_out = 'PASS'

Line 3493: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

3489: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3490: END IF;
3491:
3492: IF l_cc_duedate_result_out = 'PASS'
3493: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
3494: ----------------------------------------------------+
3495: -- order site use is subject to credit check: |
3496: ----------------------------------------------------|
3497: -- check 1: item limit <-- passed/failed|

Line 3535: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE')

3531: -- in order to disply useful message if two or more checkings fail.
3532: -- l_cc_limit_used := 'Overdue invoices found' || ', order limit exceeded';
3533: -- bug 4153299
3534: /*l_cc_limit_used
3535: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE')
3536: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');*/ --commented ER8880886
3537:
3538: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
3539: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER'); --added ER8880886

Line 3536: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');*/ --commented ER8880886

3532: -- l_cc_limit_used := 'Overdue invoices found' || ', order limit exceeded';
3533: -- bug 4153299
3534: /*l_cc_limit_used
3535: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE')
3536: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');*/ --commented ER8880886
3537:
3538: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
3539: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER'); --added ER8880886
3540:

Line 3538: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '

3534: /*l_cc_limit_used
3535: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE')
3536: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');*/ --commented ER8880886
3537:
3538: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
3539: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER'); --added ER8880886
3540:
3541: --ER8880886
3542: i_hld_rec := i_hld_rec +1;

Line 3539: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER'); --added ER8880886

3535: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE')
3536: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');*/ --commented ER8880886
3537:
3538: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
3539: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER'); --added ER8880886
3540:
3541: --ER8880886
3542: i_hld_rec := i_hld_rec +1;
3543: g_hold_reason_rec.extend;

Line 3569: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

3565: -- Changed IF condition to fix bug 4002820, need to do overall
3566: -- limit checking even order limit checking failed when
3567: -- Credit Management is installed and used.
3568: IF l_cc_trx_result_out = 'PASS'
3569: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
3570: ----------------------------------------------------+
3571: -- order is subject to credit check: |
3572: ----------------------------------------------------|
3573: -- check 1: item limit <-- passed/failed|

Line 3645: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,

3641: END IF;
3642: --Bug 4320650
3643: l_unrounded_exposure := l_total_exposure;
3644:
3645: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,
3646: l_unrounded_exposure,
3647: l_total_exposure);
3648:
3649:

Line 3686: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');

3682: IF INSTR(l_cc_limit_used, ',') >0 THEN
3683: -- l_cc_limit_used := l_cc_limit_used || ', overall limit exceeded';
3684: -- bug 4153299
3685: l_cc_limit_used := l_cc_limit_used || ', '
3686: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3687:
3688: --ER8880886
3689: i_hld_rec := i_hld_rec +1;
3690: g_hold_reason_rec.extend;

Line 3706: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER')

3702: IF l_cc_trx_result_out = 'FAIL' THEN
3703: -- l_cc_limit_used := 'Order limit, overall limit exceeded';
3704: -- bug 4153299
3705: l_cc_limit_used
3706: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER')
3707: ||', '
3708: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3709: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
3710: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded'; --commented ER8880886

Line 3708: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');

3704: -- bug 4153299
3705: l_cc_limit_used
3706: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER')
3707: ||', '
3708: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3709: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
3710: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded'; --commented ER8880886
3711: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
3712: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL'); --ER8880886

Line 3711: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '

3707: ||', '
3708: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3709: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
3710: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded'; --commented ER8880886
3711: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
3712: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL'); --ER8880886
3713:
3714: END IF;
3715: ELSE

Line 3712: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL'); --ER8880886

3708: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3709: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
3710: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded'; --commented ER8880886
3711: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
3712: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL'); --ER8880886
3713:
3714: END IF;
3715: ELSE
3716: l_cc_limit_used := 'OVERALL';

Line 3758: --6616741 l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', l_cc_profile_used);

3754: IF l_cc_result_out = 'FAIL' THEN
3755: IF l_credit_hold_level = 'ORDER' THEN
3756:
3757: -- bug 4153299
3758: --6616741 l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', l_cc_profile_used);
3759:
3760: Apply_Order_CC_Hold
3761: ( p_header_id => p_header_rec.header_id
3762: , p_order_number => p_header_rec.order_number

Line 3782: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

3778: --kadiraju changes End for Bug#13768161
3779: THEN
3780: --IF l_cc_overall_result_out = 'FAIL' --ER8880886
3781: -- THEN --ER8880886
3782: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3783: THEN
3784: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3785: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3786: END IF;

Line 3784: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

3780: --IF l_cc_overall_result_out = 'FAIL' --ER8880886
3781: -- THEN --ER8880886
3782: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3783: THEN
3784: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3785: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3786: END IF;
3787:
3788: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

Line 3788: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

3784: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3785: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3786: END IF;
3787:
3788: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed
3789: THEN
3790: -- bug 5907331
3791: l_review_party_id := p_party_id;
3792: ------check if the credit check level is PARTY, CUSTOMER or SITE

Line 3837: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));-- Bug 12651163

3833: OE_DEBUG_PUB.Add('p_requested_currency= '||
3834: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);-- Bug 12651163
3835: --OE_DEBUG_PUB.Add('p_trx_amount= '||TO_CHAR(g_order));-- Bug 12651163
3836: OE_DEBUG_PUB.Add('p_trx_amount= '||
3837: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));-- Bug 12651163
3838: OE_DEBUG_PUB.Add('p_trx_currency= '||p_header_rec.transactional_curr_code );
3839: OE_DEBUG_PUB.Add('p_credit_type = TRADE' );
3840: OE_DEBUG_PUB.Add('p_term_length = NULL' );
3841: OE_DEBUG_PUB.Add('p_credit_check_rule_id= '||

Line 3883: , p_trx_amount => OE_CREDIT_CHECK_UTIL.g_current_order_value-- Bug 12651163

3879: , p_requested_amount => OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure -- Bug 12651163
3880: --, p_requested_currency => l_limit_curr_code -- Bug 12651163
3881: , p_requested_currency => OE_CREDIT_CHECK_LINES_PVT.G_limit_currency -- Bug 12651163
3882: --, p_trx_amount => g_order -- Bug 12651163
3883: , p_trx_amount => OE_CREDIT_CHECK_UTIL.g_current_order_value-- Bug 12651163
3884: , p_trx_currency => p_header_rec.transactional_curr_code
3885: , p_credit_type => 'TRADE'
3886: , p_term_length => NULL --the unit is no of months
3887: , p_credit_check_rule_id => p_credit_check_rule_rec.credit_check_rule_id

Line 4034: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

4030: , p_calling_action IN VARCHAR2
4031: , p_check_exposure_mode IN VARCHAR2
4032: , p_credit_hold_level IN VARCHAR2
4033: , p_credit_check_rule_rec IN
4034: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4035: , x_cc_result_out OUT NOCOPY VARCHAR2
4036: , x_return_status OUT NOCOPY VARCHAR2
4037: )
4038: IS

Line 4203: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

4199:
4200: PROCEDURE Check_order_lines_credit
4201: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
4202: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
4203: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4204: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
4205: , x_msg_count OUT NOCOPY NUMBER
4206: , x_msg_data OUT NOCOPY VARCHAR2
4207: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 4204: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

4200: PROCEDURE Check_order_lines_credit
4201: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
4202: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
4203: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
4204: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
4205: , x_msg_count OUT NOCOPY NUMBER
4206: , x_msg_data OUT NOCOPY VARCHAR2
4207: , x_cc_result_out OUT NOCOPY VARCHAR2
4208: , x_cc_limit_used OUT NOCOPY VARCHAR2

Line 4733: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

4729: ---------submit AR Credit Review---------
4730: --IF OE_CREDIT_CHECK_LINES_PVT.G_cc_limit_used = 'OVERALL' --ER8880886
4731: --THEN --ER8880886
4732:
4733: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
4734: THEN
4735: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
4736: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
4737: END IF;

Line 4735: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

4731: --THEN --ER8880886
4732:
4733: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
4734: THEN
4735: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
4736: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
4737: END IF;
4738:
4739: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

Line 4739: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

4735: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
4736: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
4737: END IF;
4738:
4739: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed
4740: THEN
4741:
4742: IF G_debug_flag = 'Y'
4743: THEN

Line 4790: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));

4786: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));
4787: OE_DEBUG_PUB.Add('p_requested_currency= '||
4788: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);
4789: OE_DEBUG_PUB.Add('p_trx_amount= '||
4790: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));
4791: OE_DEBUG_PUB.Add('p_trx_currency= '||
4792: p_header_rec.transactional_curr_code );
4793: OE_DEBUG_PUB.Add('p_credit_type = TRADE' );
4794: OE_DEBUG_PUB.Add('p_term_length = NULL' );

Line 4837: OE_CREDIT_CHECK_UTIL.g_current_order_value

4833: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure
4834: , p_requested_currency =>
4835: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency
4836: , p_trx_amount =>
4837: OE_CREDIT_CHECK_UTIL.g_current_order_value
4838: , p_trx_currency => p_header_rec.transactional_curr_code
4839: , p_credit_type => 'TRADE'
4840: , p_term_length => NULL --the unit is no of months
4841: , p_credit_check_rule_id =>

Line 5008: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069

5004: END IF;
5005:
5006: END IF;
5007:
5008: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5009: IF G_debug_flag = 'Y'
5010: THEN
5011: OE_DEBUG_PUB.Add('OEXVCRLB: Out Check_order_lines_credit API',1);
5012: END IF;

Line 5018: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069

5014: EXCEPTION
5015: WHEN FND_API.G_EXC_ERROR THEN
5016: x_return_status := FND_API.G_RET_STS_ERROR;
5017: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5018: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5019: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
5020:
5021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5024: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069

5020:
5021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5023: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5024: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5025: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);
5026: WHEN OTHERS THEN
5027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5028: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706

Line 5029: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069

5025: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);
5026: WHEN OTHERS THEN
5027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5028: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5029: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5030: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);
5031: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
5032: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5033: OE_MSG_PUB.Add_Exc_Msg