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 63: G_debug_flag VARCHAR2(1) := NVL(OE_CREDIT_CHECK_UTIL.check_debug_flag,'N');

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

Line 645: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

641: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
642: , p_header_id IN NUMBER
643: , p_line_id IN NUMBER
644: , p_credit_check_rule_rec IN
645: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
646: )
647: RETURN VARCHAR2
648: IS
649: l_hold_release_id NUMBER;

Line 772: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

768: ( p_customer_id IN NUMBER
769: , p_site_use_id IN NUMBER
770: , p_party_id IN NUMBER
771: , p_credit_check_rule_rec IN
772: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
773: , p_system_parameter_rec IN
774: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
775: , p_credit_level IN VARCHAR2
776: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

Line 774: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

770: , p_party_id IN NUMBER
771: , p_credit_check_rule_rec IN
772: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
773: , p_system_parameter_rec IN
774: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
775: , p_credit_level IN VARCHAR2
776: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
777: , p_include_all_flag IN VARCHAR2
778: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 776: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

772: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
773: , p_system_parameter_rec IN
774: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
775: , p_credit_level IN VARCHAR2
776: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
777: , p_include_all_flag IN VARCHAR2
778: , p_global_exposure_flag IN VARCHAR2 := 'N'
779: , x_cc_result_out OUT NOCOPY VARCHAR2
780: , x_return_status OUT NOCOPY VARCHAR2

Line 798: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice

794: x_cc_result_out := 'PASS';
795:
796:
797:
798: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice
799: ( p_customer_id => p_customer_id
800: , p_site_use_id => p_site_use_id
801: , p_party_id => p_party_id
802: , p_credit_check_rule_rec => p_credit_check_rule_rec

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

962: -- FND_API.G_FALSE THEN
963: IF p_cc_limit_used <> 'ITEM' THEN
964: -- bug 4002820
965: IF INSTR(p_cc_limit_used, ',') > 0 THEN
966: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
967: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

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

1177: -- bug 4002820
1178: IF INSTR(p_cc_limit_used, ',') > 0 THEN
1179:
1180: --bug 4153299
1181: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1182:
1183: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

Line 1316: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1312: , p_site_use_id IN NUMBER DEFAULT NULL
1313: , p_item_category_id IN NUMBER DEFAULT NULL
1314: , p_credit_hold_level IN VARCHAR2
1315: , p_credit_check_rule_rec IN
1316: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1317: , x_cc_result_out OUT NOCOPY VARCHAR2
1318: )
1319: IS
1320:

Line 1615: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1611: , p_cc_profile_used IN VARCHAR2
1612: , p_item_category_id IN NUMBER DEFAULT NULL
1613: , p_credit_hold_level IN VARCHAR2
1614: , p_credit_check_rule_rec IN
1615: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1616: , x_cc_result_out OUT NOCOPY VARCHAR2
1617: )
1618: IS
1619:

Line 1874: , p_lines IN OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type

1870:
1871: PROCEDURE Apply_Item_Category_Holds
1872: ( p_header_id IN NUMBER
1873: , p_item_category_id IN NUMBER
1874: , p_lines IN OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type
1875: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
1876: )
1877: IS
1878: i BINARY_INTEGER := 1;

Line 2117: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

2113: , p_customer_id IN NUMBER
2114: , p_site_use_id IN NUMBER
2115: , p_credit_level IN VARCHAR2
2116: , p_credit_check_rule_rec IN
2117: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2118: , p_system_parameter_rec IN
2119: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2120: , p_limit_curr_code IN VARCHAR2
2121: , p_trx_credit_limit IN NUMBER

Line 2119: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

2115: , p_credit_level IN VARCHAR2
2116: , p_credit_check_rule_rec IN
2117: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2118: , p_system_parameter_rec IN
2119: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2120: , p_limit_curr_code IN VARCHAR2
2121: , p_trx_credit_limit IN NUMBER
2122: , x_cc_result_out OUT NOCOPY VARCHAR2
2123: , x_return_status OUT NOCOPY VARCHAR2

Line 2124: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

2120: , p_limit_curr_code IN VARCHAR2
2121: , p_trx_credit_limit IN NUMBER
2122: , x_cc_result_out OUT NOCOPY VARCHAR2
2123: , x_return_status OUT NOCOPY VARCHAR2
2124: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
2125: )
2126: IS
2127:
2128: l_order_value NUMBER;

Line 2177: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

2173: OE_DEBUG_PUB.ADD(' l_customer_id = '|| l_customer_id );
2174: OE_DEBUG_PUB.ADD(' Call GET_transaction_amount ' );
2175: END IF;
2176:
2177: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
2178: ( p_header_id => p_header_rec.header_id
2179: , p_transaction_curr_code => p_header_rec.transactional_curr_code
2180: , p_credit_check_rule_rec => p_credit_check_rule_rec
2181: , p_system_parameter_rec => p_system_parameter_rec

Line 2283: OE_Credit_Check_Util.OE_credit_rules_rec_type

2279: , p_site_use_id IN NUMBER
2280: , p_calling_action IN VARCHAR2 := 'BOOKING'
2281: , p_party_id IN NUMBER
2282: , p_credit_check_rule_rec IN
2283: OE_Credit_Check_Util.OE_credit_rules_rec_type
2284: , x_check_order_flag OUT NOCOPY VARCHAR2
2285: , x_credit_check_lvl_out OUT NOCOPY VARCHAR2
2286: , x_default_limit_flag OUT NOCOPY VARCHAR2
2287: , x_limit_curr_code OUT NOCOPY VARCHAR2

Line 2290: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

2286: , x_default_limit_flag OUT NOCOPY VARCHAR2
2287: , x_limit_curr_code OUT NOCOPY VARCHAR2
2288: , x_overall_credit_limit OUT NOCOPY NUMBER
2289: , x_trx_credit_limit OUT NOCOPY NUMBER
2290: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
2291: , x_include_all_flag OUT NOCOPY VARCHAR2
2292: , x_return_status OUT NOCOPY VARCHAR2
2293: , x_global_exposure_flag OUT NOCOPY VARCHAR2
2294: , x_credit_limit_entity_id OUT NOCOPY NUMBER

Line 2346: OE_CREDIT_CHECK_UTIL.Get_Limit_Info

2342: -- default limits of the operating unit |
2343: -- [a 11.5.3 feature] |
2344: ------------------------------------------------
2345:
2346: OE_CREDIT_CHECK_UTIL.Get_Limit_Info
2347: ( p_header_id => p_header_rec.header_id
2348: , p_entity_type => 'SITE'
2349: , p_entity_id => p_site_use_id
2350: , p_cust_account_id => p_customer_id

Line 2456: OE_CREDIT_CHECK_UTIL.curr_tbl_type

2452: , p_limit_curr_code IN VARCHAR2
2453: , p_overall_credit_limit IN NUMBER
2454: , p_calling_action IN VARCHAR2
2455: , p_usage_curr IN
2456: OE_CREDIT_CHECK_UTIL.curr_tbl_type
2457: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
2458: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
2459: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
2460: , p_credit_check_rule_rec IN

Line 2461: OE_Credit_Check_Util.OE_credit_rules_rec_type

2457: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
2458: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
2459: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
2460: , p_credit_check_rule_rec IN
2461: OE_Credit_Check_Util.OE_credit_rules_rec_type
2462: , p_system_parameter_rec IN
2463: OE_Credit_Check_Util.OE_systems_param_rec_type
2464: , p_global_exposure_flag IN VARCHAR2 := 'N'
2465: , p_party_id IN NUMBER

Line 2463: OE_Credit_Check_Util.OE_systems_param_rec_type

2459: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
2460: , p_credit_check_rule_rec IN
2461: OE_Credit_Check_Util.OE_credit_rules_rec_type
2462: , p_system_parameter_rec IN
2463: OE_Credit_Check_Util.OE_systems_param_rec_type
2464: , p_global_exposure_flag IN VARCHAR2 := 'N'
2465: , p_party_id IN NUMBER
2466: , p_credit_limit_entity_id IN NUMBER
2467: , x_total_exposure OUT NOCOPY NUMBER

Line 2470: OE_CREDIT_CHECK_UTIL.curr_tbl_type

2466: , p_credit_limit_entity_id IN NUMBER
2467: , x_total_exposure OUT NOCOPY NUMBER
2468: , x_cc_result_out OUT NOCOPY VARCHAR2
2469: , x_error_curr_tbl OUT NOCOPY
2470: OE_CREDIT_CHECK_UTIL.curr_tbl_type
2471: , x_return_status OUT NOCOPY VARCHAR2
2472: )
2473: IS
2474: l_customer_id NUMBER;

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

2589: and NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
2590: FND_API.G_FALSE
2591: THEN
2592: l_current_order_value :=
2593: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
2594: ELSE
2595: IF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
2596: THEN
2597: l_current_order_value :=

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

2594: ELSE
2595: IF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
2596: THEN
2597: l_current_order_value :=
2598: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
2599: ELSE
2600: l_current_order_value := 0 ;
2601: END IF;
2602: END IF;

Line 2708: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

2704: , p_customer_id IN NUMBER
2705: , p_site_use_id IN NUMBER
2706: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2707: , p_credit_check_rule_rec IN
2708: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2709: , p_system_parameter_rec IN
2710: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2711: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
2712: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 2710: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

2706: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2707: , p_credit_check_rule_rec IN
2708: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2709: , p_system_parameter_rec IN
2710: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2711: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
2712: , x_cc_result_out OUT NOCOPY VARCHAR2
2713: , x_return_status OUT NOCOPY VARCHAR2
2714: )

Line 2722: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;

2718:
2719: l_return_status VARCHAR2(30);
2720: l_credit_hold_level VARCHAR2(30);
2721: l_include_tax_flag VARCHAR2(1) := 'Y';
2722: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2723: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2724: j BINARY_INTEGER := 1;
2725: i BINARY_INTEGER := 1;
2726: l_cc_result_out VARCHAR2(30);

Line 2723: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;

2719: l_return_status VARCHAR2(30);
2720: l_credit_hold_level VARCHAR2(30);
2721: l_include_tax_flag VARCHAR2(1) := 'Y';
2722: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2723: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2724: j BINARY_INTEGER := 1;
2725: i BINARY_INTEGER := 1;
2726: l_cc_result_out VARCHAR2(30);
2727: l_check_category_id NUMBER;

Line 2745: OE_CREDIT_CHECK_UTIL.Get_Item_Limit

2741: l_include_tax_flag := p_credit_check_rule_rec.include_tax_flag ;
2742:
2743: OE_DEBUG_PUB.Add(' Call Get_Item_Limit ');
2744:
2745: OE_CREDIT_CHECK_UTIL.Get_Item_Limit
2746: ( p_header_id => p_header_rec.header_id
2747: , p_include_tax_flag => p_credit_check_rule_rec.include_tax_flag
2748: , p_site_use_id => p_site_use_id
2749: , p_trx_curr_code => p_header_rec.transactional_curr_code

Line 2801: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2797: l_check_category_id := l_item_limits(i).item_category_id ;
2798: l_limit_currency := l_item_limits(i).limit_curr_code ;
2799:
2800: l_limit_category_sum :=
2801: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2802: ( p_amount => l_category_sum
2803: , p_transactional_currency => p_header_rec.transactional_curr_code
2804: , p_limit_currency => l_item_limits(i).limit_curr_code
2805: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 2934: OE_Credit_Check_Util.OE_credit_rules_rec_type

2930: , p_customer_id IN NUMBER
2931: , p_site_use_id IN NUMBER
2932: , p_calling_action IN VARCHAR2 := 'BOOKING'
2933: , p_credit_check_rule_rec IN
2934: OE_Credit_Check_Util.OE_credit_rules_rec_type
2935: , p_system_parameter_rec IN
2936: OE_Credit_Check_Util.OE_systems_param_rec_type
2937: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
2938: , p_party_id IN NUMBER

Line 2936: OE_Credit_Check_Util.OE_systems_param_rec_type

2932: , p_calling_action IN VARCHAR2 := 'BOOKING'
2933: , p_credit_check_rule_rec IN
2934: OE_Credit_Check_Util.OE_credit_rules_rec_type
2935: , p_system_parameter_rec IN
2936: OE_Credit_Check_Util.OE_systems_param_rec_type
2937: , p_holds_table IN OUT NOCOPY Line_Holds_Tbl_Rectype
2938: , p_party_id IN NUMBER
2939: , x_credit_level OUT NOCOPY VARCHAR2
2940: , x_check_exposure_mode OUT NOCOPY VARCHAR2

Line 2952: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;

2948: l_default_limit_flag VARCHAR2(1);
2949: l_limit_curr_code VARCHAR2(30);
2950: l_overall_credit_limit NUMBER;
2951: l_trx_credit_limit NUMBER;
2952: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;
2953: l_include_all_flag VARCHAR2(1);
2954: l_prev_customer_id NUMBER;
2955: l_customer_result_out VARCHAR2(30) := NULL;
2956: l_total_exposure NUMBER;

Line 2961: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;

2957: l_orders NUMBER;
2958: l_orders_on_hold NUMBER;
2959: l_payments_overdue NUMBER;
2960: l_payments_at_risk NUMBER;
2961: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;
2962: l_cc_profile_used VARCHAR2(30);
2963: l_cc_limit_used VARCHAR2(80);
2964: l_cc_result_out VARCHAR2(30);
2965: l_credit_hold_level VARCHAR2(30);

Line 3131: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

3127: -- Changed IF condition to fix bug 4002820, need to do overall
3128: -- limit checking even order limit checking failed when
3129: -- Credit Management is installed and used.
3130:
3131: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3132: THEN
3133: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3134: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3135: END IF;

Line 3133: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

3129: -- Credit Management is installed and used.
3130:
3131: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3132: THEN
3133: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3134: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3135: END IF;
3136:
3137: IF l_cc_duedate_result_out = 'PASS'

Line 3138: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

3134: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3135: END IF;
3136:
3137: IF l_cc_duedate_result_out = 'PASS'
3138: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
3139: ----------------------------------------------------+
3140: -- order site use is subject to credit check: |
3141: ----------------------------------------------------|
3142: -- check 1: item limit <-- passed/failed|

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

3176: -- in order to disply useful message if two or more checkings fail.
3177: -- l_cc_limit_used := 'Overdue invoices found' || ', order limit exceeded';
3178: -- bug 4153299
3179: l_cc_limit_used
3180: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE')
3181: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');
3182: ELSE
3183: l_cc_limit_used := 'TRX';
3184: END IF;

Line 3181: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');

3177: -- l_cc_limit_used := 'Overdue invoices found' || ', order limit exceeded';
3178: -- bug 4153299
3179: l_cc_limit_used
3180: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE')
3181: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER');
3182: ELSE
3183: l_cc_limit_used := 'TRX';
3184: END IF;
3185: END IF;

Line 3198: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

3194: -- Changed IF condition to fix bug 4002820, need to do overall
3195: -- limit checking even order limit checking failed when
3196: -- Credit Management is installed and used.
3197: IF l_cc_trx_result_out = 'PASS'
3198: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
3199: ----------------------------------------------------+
3200: -- order is subject to credit check: |
3201: ----------------------------------------------------|
3202: -- check 1: item limit <-- passed/failed|

Line 3274: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,

3270: END IF;
3271: --Bug 4320650
3272: l_unrounded_exposure := l_total_exposure;
3273:
3274: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,
3275: l_unrounded_exposure,
3276: l_total_exposure);
3277:
3278:

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

3311: IF INSTR(l_cc_limit_used, ',') >0 THEN
3312: -- l_cc_limit_used := l_cc_limit_used || ', overall limit exceeded';
3313: -- bug 4153299
3314: l_cc_limit_used := l_cc_limit_used || ', '
3315: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3316: ELSIF l_cc_limit_used IS NOT NULL THEN
3317: IF l_cc_trx_result_out = 'FAIL' THEN
3318: -- l_cc_limit_used := 'Order limit, overall limit exceeded';
3319: -- bug 4153299

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

3317: IF l_cc_trx_result_out = 'FAIL' THEN
3318: -- l_cc_limit_used := 'Order limit, overall limit exceeded';
3319: -- bug 4153299
3320: l_cc_limit_used
3321: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER')
3322: ||', '
3323: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3324: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
3325: l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';

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

3319: -- bug 4153299
3320: l_cc_limit_used
3321: := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER')
3322: ||', '
3323: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
3324: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
3325: l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';
3326:
3327: END IF;

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

3360: IF l_cc_result_out = 'FAIL' THEN
3361: IF l_credit_hold_level = 'ORDER' THEN
3362:
3363: -- bug 4153299
3364: --6616741 l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', l_cc_profile_used);
3365:
3366: Apply_Order_CC_Hold
3367: ( p_header_id => p_header_rec.header_id
3368: , p_order_number => p_header_rec.order_number

Line 3385: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

3381: IF l_cc_result_out in ('FAIL_HOLD','FAIL_NONE','FAIL')
3382: THEN
3383: IF l_cc_overall_result_out = 'FAIL'
3384: THEN
3385: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3386: THEN
3387: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3388: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3389: END IF;

Line 3387: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

3383: IF l_cc_overall_result_out = 'FAIL'
3384: THEN
3385: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
3386: THEN
3387: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3388: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3389: END IF;
3390:
3391: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

Line 3391: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

3387: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
3388: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
3389: END IF;
3390:
3391: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed
3392: THEN
3393: -- bug 5907331
3394: l_review_party_id := p_party_id;
3395: ------check if the credit check level is PARTY, CUSTOMER or SITE

Line 3618: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

3614: , p_calling_action IN VARCHAR2
3615: , p_check_exposure_mode IN VARCHAR2
3616: , p_credit_hold_level IN VARCHAR2
3617: , p_credit_check_rule_rec IN
3618: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
3619: , x_cc_result_out OUT NOCOPY VARCHAR2
3620: , x_return_status OUT NOCOPY VARCHAR2
3621: )
3622: IS

Line 3787: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

3783:
3784: PROCEDURE Check_order_lines_credit
3785: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
3786: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
3787: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
3788: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
3789: , x_msg_count OUT NOCOPY NUMBER
3790: , x_msg_data OUT NOCOPY VARCHAR2
3791: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 3788: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

3784: PROCEDURE Check_order_lines_credit
3785: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
3786: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
3787: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
3788: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
3789: , x_msg_count OUT NOCOPY NUMBER
3790: , x_msg_data OUT NOCOPY VARCHAR2
3791: , x_cc_result_out OUT NOCOPY VARCHAR2
3792: , x_cc_limit_used OUT NOCOPY VARCHAR2

Line 4188: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

4184: ---------submit AR Credit Review---------
4185: IF OE_CREDIT_CHECK_LINES_PVT.G_cc_limit_used = 'OVERALL'
4186: THEN
4187:
4188: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
4189: THEN
4190: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
4191: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
4192: END IF;

Line 4190: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

4186: THEN
4187:
4188: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
4189: THEN
4190: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
4191: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
4192: END IF;
4193:
4194: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

Line 4194: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed

4190: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
4191: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
4192: END IF;
4193:
4194: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed
4195: THEN
4196:
4197: IF G_debug_flag = 'Y'
4198: THEN

Line 4245: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));

4241: TO_CHAR(OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure ));
4242: OE_DEBUG_PUB.Add('p_requested_currency= '||
4243: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency);
4244: OE_DEBUG_PUB.Add('p_trx_amount= '||
4245: TO_CHAR(OE_CREDIT_CHECK_UTIL.g_current_order_value));
4246: OE_DEBUG_PUB.Add('p_trx_currency= '||
4247: p_header_rec.transactional_curr_code );
4248: OE_DEBUG_PUB.Add('p_credit_type = TRADE' );
4249: OE_DEBUG_PUB.Add('p_term_length = NULL' );

Line 4292: OE_CREDIT_CHECK_UTIL.g_current_order_value

4288: OE_CREDIT_CHECK_LINES_PVT.G_total_site_exposure
4289: , p_requested_currency =>
4290: OE_CREDIT_CHECK_LINES_PVT.G_limit_currency
4291: , p_trx_amount =>
4292: OE_CREDIT_CHECK_UTIL.g_current_order_value
4293: , p_trx_currency => p_header_rec.transactional_curr_code
4294: , p_credit_type => 'TRADE'
4295: , p_term_length => NULL --the unit is no of months
4296: , p_credit_check_rule_id =>