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

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

71:
72: ---------------------------
73: -- PRIVATE GLOBAL VARIABLES
74: ---------------------------
75: G_debug_flag VARCHAR2(1) := NVL( OE_CREDIT_CHECK_UTIL.check_debug_flag ,'N') ;
76: G_result_out VARCHAR2(10) := 'PASS' ;
77: G_order NUMBER ;
78:
79: g_hold_exist VARCHAR2(1) := NULL ;

Line 101: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

97: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
98: , p_header_id IN NUMBER
99: , p_line_id IN NUMBER
100: , p_credit_check_rule_rec IN
101: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
102: )
103: RETURN VARCHAR2
104: IS
105: l_hold_release_id NUMBER;

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

377: IF p_calling_action <> 'EXTERNAL'
378: THEN
379: -- bug 4002820
380: IF INSTR(p_cc_limit_used, ',') > 0 THEN
381: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
382: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741

Line 666: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

662: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
663: , p_cc_limit_used IN VARCHAR2
664: , p_cc_profile_used IN VARCHAR2
665: , p_item_category_id IN NUMBER
666: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
667: , p_credit_check_rule_rec IN
668: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
669: , x_cc_hold_comment OUT NOCOPY VARCHAR2
670: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 668: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

664: , p_cc_profile_used IN VARCHAR2
665: , p_item_category_id IN NUMBER
666: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
667: , p_credit_check_rule_rec IN
668: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
669: , x_cc_hold_comment OUT NOCOPY VARCHAR2
670: , x_cc_result_out OUT NOCOPY VARCHAR2
671: )
672: IS

Line 894: , P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

890: PROCEDURE Release_Order_CC_Hold
891: ( p_header_id IN NUMBER
892: , p_order_number IN NUMBER
893: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
894: , P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
895: , x_cc_result_out OUT NOCOPY VARCHAR2
896: )
897: IS
898:

Line 1016: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1012: ( p_customer_id IN NUMBER
1013: , p_site_use_id IN NUMBER
1014: , p_party_id IN NUMBER
1015: , p_credit_check_rule_rec IN
1016: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1017: , p_system_parameter_rec IN
1018: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1019: , p_credit_level IN VARCHAR2
1020: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

Line 1018: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

1014: , p_party_id IN NUMBER
1015: , p_credit_check_rule_rec IN
1016: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1017: , p_system_parameter_rec IN
1018: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1019: , p_credit_level IN VARCHAR2
1020: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
1021: , p_include_all_flag IN VARCHAR2
1022: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 1020: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

1016: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1017: , p_system_parameter_rec IN
1018: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1019: , p_credit_level IN VARCHAR2
1020: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
1021: , p_include_all_flag IN VARCHAR2
1022: , p_global_exposure_flag IN VARCHAR2 := 'N'
1023: , x_cc_result_out OUT NOCOPY VARCHAR2
1024: , x_return_status OUT NOCOPY VARCHAR2

Line 1045: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice

1041:
1042:
1043:
1044:
1045: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice
1046: ( p_customer_id => p_customer_id
1047: , p_site_use_id => p_site_use_id
1048: , p_party_id => p_party_id
1049: , p_credit_check_rule_rec => p_credit_check_rule_rec

Line 1102: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1098: , p_customer_id IN NUMBER
1099: , p_site_use_id IN NUMBER
1100: , p_credit_level IN VARCHAR2
1101: , p_credit_check_rule_rec IN
1102: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1103: , p_system_parameter_rec IN
1104: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1105: , p_limit_curr_code IN VARCHAR2
1106: , p_trx_credit_limit IN NUMBER

Line 1104: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

1100: , p_credit_level IN VARCHAR2
1101: , p_credit_check_rule_rec IN
1102: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1103: , p_system_parameter_rec IN
1104: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1105: , p_limit_curr_code IN VARCHAR2
1106: , p_trx_credit_limit IN NUMBER
1107: , p_calling_action IN VARCHAR2
1108: , p_transaction_amount IN NUMBER

Line 1111: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

1107: , p_calling_action IN VARCHAR2
1108: , p_transaction_amount IN NUMBER
1109: , x_cc_result_out OUT NOCOPY VARCHAR2
1110: , x_return_status OUT NOCOPY VARCHAR2
1111: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1112: )
1113: IS
1114:
1115: l_order_value NUMBER := 0 ;

Line 1152: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

1148: THEN
1149: OE_DEBUG_PUB.ADD(' call GET_transaction_amount ');
1150: END IF;
1151:
1152: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
1153: ( p_header_id => p_header_rec.header_id
1154: , p_transaction_curr_code => p_header_rec.transactional_curr_code
1155: , p_credit_check_rule_rec => p_credit_check_rule_rec
1156: , p_system_parameter_rec => p_system_parameter_rec

Line 1177: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount

1173: THEN
1174: OE_DEBUG_PUB.ADD(' call GET_external_trx_amount ');
1175: END IF;
1176:
1177: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount
1178: ( p_transaction_curr_code => p_header_rec.transactional_curr_code
1179: , p_transaction_amount => p_transaction_amount
1180: , p_credit_check_rule_rec => p_credit_check_rule_rec
1181: , p_system_parameter_rec => p_system_parameter_rec

Line 1385: OE_Credit_Check_Util.OE_credit_rules_rec_type

1381: , p_customer_id IN NUMBER
1382: , p_site_use_id IN NUMBER
1383: , p_calling_action IN VARCHAR2 := 'BOOKING'
1384: , p_credit_check_rule_rec IN
1385: OE_Credit_Check_Util.OE_credit_rules_rec_type
1386: , p_party_id IN NUMBER
1387: , x_check_order_flag OUT NOCOPY VARCHAR2
1388: , x_credit_check_lvl_out OUT NOCOPY VARCHAR2
1389: , x_default_limit_flag OUT NOCOPY VARCHAR2

Line 1393: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

1389: , x_default_limit_flag OUT NOCOPY VARCHAR2
1390: , x_limit_curr_code OUT NOCOPY VARCHAR2
1391: , x_overall_credit_limit OUT NOCOPY NUMBER
1392: , x_trx_credit_limit OUT NOCOPY NUMBER
1393: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1394: , x_include_all_flag OUT NOCOPY VARCHAR2
1395: , x_return_status OUT NOCOPY VARCHAR2
1396: , x_global_exposure_flag OUT NOCOPY VARCHAR2
1397: , x_credit_limit_entity_id OUT NOCOPY NUMBER

Line 1466: OE_CREDIT_CHECK_UTIL.Get_Limit_Info

1462: -- [a 11.5.3 feature] |
1463: ------------------------------------------------
1464:
1465:
1466: OE_CREDIT_CHECK_UTIL.Get_Limit_Info
1467: ( p_header_id => p_header_rec.header_id
1468: , p_entity_type => 'SITE'
1469: , p_entity_id => p_site_use_id
1470: , p_cust_account_id => p_customer_id

Line 1595: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

1591: , p_transaction_amount IN NUMBER DEFAULT 0
1592: , p_limit_curr_code IN VARCHAR2
1593: , p_overall_credit_limit IN NUMBER
1594: , p_calling_action IN VARCHAR2
1595: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
1596: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
1597: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
1598: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
1599: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

Line 1599: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

1595: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
1596: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
1597: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
1598: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
1599: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
1600: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
1601: , p_global_exposure_flag IN VARCHAR2 := 'N'
1602: , p_credit_limit_entity_id IN VARCHAR2
1603: , x_total_exposure OUT NOCOPY NUMBER

Line 1600: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type

1596: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
1597: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
1598: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
1599: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
1600: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
1601: , p_global_exposure_flag IN VARCHAR2 := 'N'
1602: , p_credit_limit_entity_id IN VARCHAR2
1603: , x_total_exposure OUT NOCOPY NUMBER
1604: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 1605: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

1601: , p_global_exposure_flag IN VARCHAR2 := 'N'
1602: , p_credit_limit_entity_id IN VARCHAR2
1603: , x_total_exposure OUT NOCOPY NUMBER
1604: , x_cc_result_out OUT NOCOPY VARCHAR2
1605: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1606: , x_return_status OUT NOCOPY VARCHAR2
1607: )
1608: IS
1609:

Line 1611: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;

1607: )
1608: IS
1609:
1610:
1611: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;
1612: l_customer_id NUMBER;
1613: l_site_id NUMBER;
1614: l_transaction_value NUMBER := 0;
1615: l_current_order_value NUMBER := 0 ;

Line 1691: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount

1687: THEN
1688: OE_DEBUG_PUB.Add('OEXVCRHB GET_external_trx_amount ');
1689: END IF;
1690:
1691: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount
1692: ( p_transaction_curr_code => p_transaction_curr_code
1693: , p_transaction_amount => p_transaction_amount
1694: , p_credit_check_rule_rec => p_credit_check_rule_rec
1695: , p_system_parameter_rec => p_system_parameter_rec

Line 1732: OE_credit_check_util.Get_order_exposure

1728:
1729: IF NVL(p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG,'N') = 'N'
1730: THEN
1731:
1732: OE_credit_check_util.Get_order_exposure
1733: ( p_header_id => p_header_id
1734: , p_transaction_curr_code => p_transaction_curr_code
1735: , p_customer_id => p_customer_id
1736: , p_site_use_id => p_site_use_id

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

1828: NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1829: FND_API.G_FALSE
1830: THEN
1831: l_current_order_value :=
1832: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
1833: IF G_debug_flag = 'Y'
1834: THEN
1835: OE_DEBUG_PUB.Add('Calling action=BOOKING and G_delayed_request=FALSE');
1836: END IF;

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

1863:
1864: IF g_hold_exist = 'Y'
1865: THEN
1866: l_current_order_value :=
1867: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
1868: END IF;
1869: -- add this ELSIF for bug fix 4184524
1870: ELSIF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
1871: THEN

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

1869: -- add this ELSIF for bug fix 4184524
1870: ELSIF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
1871: THEN
1872: l_current_order_value :=
1873: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
1874: END IF; -- end of bug fix 4184524
1875: END IF;
1876: END IF;
1877:

Line 1998: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1994: , p_customer_id IN NUMBER
1995: , p_site_use_id IN NUMBER
1996: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
1997: , p_credit_check_rule_rec IN
1998: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1999: , p_system_parameter_rec IN
2000: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2001: , x_cc_hold_comment OUT NOCOPY VARCHAR2
2002: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 2000: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

1996: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
1997: , p_credit_check_rule_rec IN
1998: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1999: , p_system_parameter_rec IN
2000: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2001: , x_cc_hold_comment OUT NOCOPY VARCHAR2
2002: , x_cc_result_out OUT NOCOPY VARCHAR2
2003: , x_return_status OUT NOCOPY VARCHAR2
2004: )

Line 2011: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;

2007: l_limit_category_sum NUMBER := 0 ; -- Sum converted to Limit currency
2008:
2009: l_return_status VARCHAR2(30);
2010: l_include_tax_flag VARCHAR2(1) := 'Y';
2011: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2012: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2013: j BINARY_INTEGER := 1;
2014: i BINARY_INTEGER := 1;
2015: l_cc_result_out VARCHAR2(30);

Line 2012: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;

2008:
2009: l_return_status VARCHAR2(30);
2010: l_include_tax_flag VARCHAR2(1) := 'Y';
2011: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2012: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2013: j BINARY_INTEGER := 1;
2014: i BINARY_INTEGER := 1;
2015: l_cc_result_out VARCHAR2(30);
2016: l_check_category_id NUMBER;

Line 2038: OE_CREDIT_CHECK_UTIL.Get_Item_Limit

2034:
2035: l_include_tax_flag := p_credit_check_rule_rec.include_tax_flag ;
2036:
2037:
2038: OE_CREDIT_CHECK_UTIL.Get_Item_Limit
2039: ( p_header_id => p_header_rec.header_id
2040: , p_include_tax_flag => p_credit_check_rule_rec.include_tax_flag
2041: , p_site_use_id => NULL
2042: , p_trx_curr_code => p_header_rec.transactional_curr_code

Line 2100: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2096:
2097: l_check_category_id := l_item_limits(i).item_category_id ;
2098: l_limit_curr := l_item_limits(i).limit_curr_code ;
2099: l_limit_category_sum :=
2100: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2101: ( p_amount => l_category_sum
2102: , p_transactional_currency => p_header_rec.transactional_curr_code
2103: , p_limit_currency => l_item_limits(i).limit_curr_code
2104: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 2219: OE_Credit_Check_Util.OE_credit_rules_rec_type

2215: , p_customer_id IN NUMBER
2216: , p_site_use_id IN NUMBER
2217: , p_calling_action IN VARCHAR2 := 'BOOKING'
2218: , p_credit_check_rule_rec IN
2219: OE_Credit_Check_Util.OE_credit_rules_rec_type
2220: , p_system_parameter_rec IN
2221: OE_Credit_Check_Util.OE_systems_param_rec_type
2222: , p_transaction_amount IN NUMBER
2223: , p_party_id IN NUMBER ---------------------new (FPI)

Line 2221: OE_Credit_Check_Util.OE_systems_param_rec_type

2217: , p_calling_action IN VARCHAR2 := 'BOOKING'
2218: , p_credit_check_rule_rec IN
2219: OE_Credit_Check_Util.OE_credit_rules_rec_type
2220: , p_system_parameter_rec IN
2221: OE_Credit_Check_Util.OE_systems_param_rec_type
2222: , p_transaction_amount IN NUMBER
2223: , p_party_id IN NUMBER ---------------------new (FPI)
2224: , x_credit_level OUT NOCOPY VARCHAR2
2225: , x_check_exposure_mode OUT NOCOPY VARCHAR2

Line 2238: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;

2234: l_default_limit_flag VARCHAR2(1);
2235: l_limit_curr_code VARCHAR2(30);
2236: l_overall_credit_limit NUMBER;
2237: l_trx_credit_limit NUMBER;
2238: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;
2239: l_include_all_flag VARCHAR2(1);
2240: l_prev_customer_id NUMBER;
2241: l_customer_result_out VARCHAR2(30) := NULL;
2242: l_total_exposure NUMBER;

Line 2247: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;

2243: l_orders NUMBER;
2244: l_orders_on_hold NUMBER;
2245: l_payments_overdue NUMBER;
2246: l_payments_at_risk NUMBER;
2247: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;
2248: l_cc_profile_used VARCHAR2(30);
2249: l_cc_limit_used VARCHAR2(80);
2250: l_cc_result_out VARCHAR2(30);
2251: l_request_id NUMBER; -----------------------new (FPI)

Line 2392: g_order := OE_CREDIT_CHECK_UTIL.g_current_order_value ;

2388: RAISE FND_API.G_EXC_ERROR;
2389: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2391: END IF;
2392: g_order := OE_CREDIT_CHECK_UTIL.g_current_order_value ;
2393:
2394:
2395: -- IF l_cc_result_out = 'PASS' THEN
2396: -- Changed IF condition to fix bug 4002820, need to do overall

Line 2400: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

2396: -- Changed IF condition to fix bug 4002820, need to do overall
2397: -- limit checking even order limit checking failed when
2398: -- Credit Management is installed and used.
2399:
2400: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2401: THEN
2402: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2403: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2404: END IF;

Line 2402: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

2398: -- Credit Management is installed and used.
2399:
2400: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2401: THEN
2402: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2403: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2404: END IF;
2405:
2406: IF l_cc_trx_result_out = 'PASS'

Line 2407: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

2403: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2404: END IF;
2405:
2406: IF l_cc_trx_result_out = 'PASS'
2407: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
2408: IF G_debug_flag = 'Y' THEN
2409: OE_DEBUG_PUB.Add('Calling Check Past Due Invoice procedure');
2410: END IF;
2411:

Line 2438: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '

2434: IF l_cc_limit_used IS NOT NULL THEN
2435: -- in order to disply useful message if two or more checkings fail.
2436: -- l_cc_limit_used := 'Order limit exceeded' || ', overdue invoices found';
2437: -- bug 4153299
2438: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2439: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE');
2440:
2441: ELSE
2442: l_cc_limit_used := 'DUEDATE';

Line 2439: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE');

2435: -- in order to disply useful message if two or more checkings fail.
2436: -- l_cc_limit_used := 'Order limit exceeded' || ', overdue invoices found';
2437: -- bug 4153299
2438: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2439: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE');
2440:
2441: ELSE
2442: l_cc_limit_used := 'DUEDATE';
2443: END IF;

Line 2457: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

2453: -- Changed IF condition to fix bug 4002813, need to do overall
2454: -- limit checking even order limit checking failed when
2455: -- Credit Management is installed and used.
2456: IF l_cc_duedate_result_out = 'PASS'
2457: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
2458: ----------------------------------------------------+
2459: -- order is subject to credit check: |
2460: ----------------------------------------------------|
2461: -- check 1: item limit <-- passed/failed|

Line 2510: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,

2506: END IF;
2507: --Bug 4320650
2508: l_unrounded_exposure := l_total_exposure;
2509:
2510: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,
2511: l_unrounded_exposure,
2512: l_total_exposure);
2513:
2514: -- bug 4002820

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

2518: IF INSTR(l_cc_limit_used, ',') >0 THEN
2519: -- l_cc_limit_used := l_cc_limit_used || ', overall limit exceeded';
2520: --bug 4153299
2521: l_cc_limit_used := l_cc_limit_used || ', '
2522: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2523:
2524: ELSIF l_cc_limit_used IS NOT NULL THEN
2525: IF l_cc_trx_result_out = 'FAIL' THEN
2526: -- l_cc_limit_used := 'Order limit, overall limit exceeded';

Line 2528: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '

2524: ELSIF l_cc_limit_used IS NOT NULL THEN
2525: IF l_cc_trx_result_out = 'FAIL' THEN
2526: -- l_cc_limit_used := 'Order limit, overall limit exceeded';
2527: -- bug 4153299
2528: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2529: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2530:
2531: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2532: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';

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

2525: IF l_cc_trx_result_out = 'FAIL' THEN
2526: -- l_cc_limit_used := 'Order limit, overall limit exceeded';
2527: -- bug 4153299
2528: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2529: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2530:
2531: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2532: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';
2533: -- bug 4153299

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

2530:
2531: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2532: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';
2533: -- bug 4153299
2534: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
2535: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2536:
2537:
2538: END IF;

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

2531: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2532: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';
2533: -- bug 4153299
2534: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
2535: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2536:
2537:
2538: END IF;
2539: ELSE

Line 2579: OE_CREDIT_CHECK_UTIL.g_current_order_value );

2575: OE_DEBUG_PUB.Add(' OEXVCRHB: l_cc_limit_used ==> '|| l_cc_limit_used );
2576: OE_DEBUG_PUB.Add(' before l_cc_result_out => '|| l_cc_result_out );
2577:
2578: OE_DEBUG_PUB.add(' g_current_order_value => '||
2579: OE_CREDIT_CHECK_UTIL.g_current_order_value );
2580:
2581: OE_DEBUG_PUB.Add('before g_order ==> ' || g_order );
2582: END IF;
2583:

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

2608: OE_DEBUG_PUB.Add('Calling Apply_Order_CC_Hold ');
2609: END IF;
2610:
2611: -- bug 4153299
2612: -- 6616741 l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', l_cc_profile_used);
2613:
2614: Apply_Order_CC_Hold
2615: ( p_header_id => p_header_rec.header_id
2616: , p_order_number => p_header_rec.order_number

Line 2635: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

2631: -- changed IF condition for bug 4002820
2632: -- IF l_cc_limit_used = 'OVERALL'
2633: IF l_cc_overall_result_out = 'FAIL'
2634: THEN
2635: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2636: THEN
2637: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2638: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2639: END IF;

Line 2637: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

2633: IF l_cc_overall_result_out = 'FAIL'
2634: THEN
2635: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2636: THEN
2637: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2638: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2639: END IF;
2640:
2641: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE

Line 2641: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE

2637: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2638: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2639: END IF;
2640:
2641: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE
2642: THEN
2643: --bug 5907331
2644: l_review_party_id := p_party_id;
2645: ------check if the credit check level is PARTY, CUSTOMER or SITE

Line 2842: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

2838:
2839: PROCEDURE Check_order_credit
2840: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
2841: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2842: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2843: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2844: , p_transaction_amount IN NUMBER DEFAULT NULL
2845: , x_msg_count OUT NOCOPY NUMBER
2846: , x_msg_data OUT NOCOPY VARCHAR2

Line 2843: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

2839: PROCEDURE Check_order_credit
2840: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
2841: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2842: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2843: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2844: , p_transaction_amount IN NUMBER DEFAULT NULL
2845: , x_msg_count OUT NOCOPY NUMBER
2846: , x_msg_data OUT NOCOPY VARCHAR2
2847: , x_cc_result_out OUT NOCOPY VARCHAR2