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

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

Line 102: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

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

Line 416: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); --ER8880886

412: OE_DEBUG_PUB.Add('p_order_number => '||
413: p_order_number );
414: END IF;
415:
416: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); --ER8880886
417: -- Write to message stack anyway regardless of the calling action
418: IF p_cc_limit_used <> 'ITEM' THEN
419: IF p_calling_action <> 'EXTERNAL'
420: THEN

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

419: IF p_calling_action <> 'EXTERNAL'
420: THEN
421: -- bug 4002820
422: IF INSTR(p_cc_limit_used, ',') > 0 THEN
423: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
425: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741

Line 657: OE_DEBUG_PUB.ADD('OEXVCRHB: Call OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');

653: --ER 12363706 start
654:
655: IF G_debug_flag = 'Y'
656: THEN
657: OE_DEBUG_PUB.ADD('OEXVCRHB: Call OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');
658: END IF;
659:
660: IF p_hold_source_rec.hold_entity_code = 'O' AND p_hold_source_rec.hold_id = 1 THEN
661: OE_DEBUG_PUB.ADD('OEXVCRHB: calling Update_Credit_Profile_Level');

Line 662: OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level(p_hold_source_rec);

658: END IF;
659:
660: IF p_hold_source_rec.hold_entity_code = 'O' AND p_hold_source_rec.hold_id = 1 THEN
661: OE_DEBUG_PUB.ADD('OEXVCRHB: calling Update_Credit_Profile_Level');
662: OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level(p_hold_source_rec);
663: END IF;
664:
665: IF G_debug_flag = 'Y'
666: THEN

Line 667: OE_DEBUG_PUB.ADD('OEXVCRHB: Out OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');

663: END IF;
664:
665: IF G_debug_flag = 'Y'
666: THEN
667: OE_DEBUG_PUB.ADD('OEXVCRHB: Out OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');
668: END IF;
669:
670: --ER 12363706 end
671:

Line 731: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

727: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
728: , p_cc_limit_used IN VARCHAR2
729: , p_cc_profile_used IN VARCHAR2
730: , p_item_category_id IN NUMBER
731: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
732: , p_credit_check_rule_rec IN
733: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
734: , x_cc_hold_comment OUT NOCOPY VARCHAR2
735: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 733: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

729: , p_cc_profile_used IN VARCHAR2
730: , p_item_category_id IN NUMBER
731: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
732: , p_credit_check_rule_rec IN
733: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
734: , x_cc_hold_comment OUT NOCOPY VARCHAR2
735: , x_cc_result_out OUT NOCOPY VARCHAR2
736: )
737: IS

Line 842: OE_DEBUG_PUB.ADD('OEXVCRHB: Call OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');

838:
839: --ER 12363706 start
840: IF G_debug_flag = 'Y'
841: THEN
842: OE_DEBUG_PUB.ADD('OEXVCRHB: Call OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');
843: END IF;
844:
845: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used;
846:

Line 849: OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level(l_hold_source_rec);

845: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used;
846:
847: IF l_hold_source_rec.hold_entity_code = 'O' AND l_hold_source_rec.hold_id = 1 THEN
848: OE_DEBUG_PUB.ADD('OEXVCRHB: calling Update_Credit_Profile_Level');
849: OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level(l_hold_source_rec);
850: END IF;
851:
852: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL;
853:

Line 856: OE_DEBUG_PUB.ADD('OEXVCRHB: Out OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');

852: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL;
853:
854: IF G_debug_flag = 'Y'
855: THEN
856: OE_DEBUG_PUB.ADD('OEXVCRHB: Out OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');
857: END IF;
858: --ER 12363706 end
859:
860: END IF; -- Calling Action

Line 996: , P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

992: PROCEDURE Release_Order_CC_Hold
993: ( p_header_id IN NUMBER
994: , p_order_number IN NUMBER
995: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
996: , P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
997: , x_cc_result_out OUT NOCOPY VARCHAR2
998: )
999: IS
1000:

Line 1118: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1114: ( p_customer_id IN NUMBER
1115: , p_site_use_id IN NUMBER
1116: , p_party_id IN NUMBER
1117: , p_credit_check_rule_rec IN
1118: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1119: , p_system_parameter_rec IN
1120: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1121: , p_credit_level IN VARCHAR2
1122: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

Line 1120: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

1116: , p_party_id IN NUMBER
1117: , p_credit_check_rule_rec IN
1118: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1119: , p_system_parameter_rec IN
1120: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1121: , p_credit_level IN VARCHAR2
1122: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
1123: , p_include_all_flag IN VARCHAR2
1124: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 1122: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

1118: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1119: , p_system_parameter_rec IN
1120: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1121: , p_credit_level IN VARCHAR2
1122: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
1123: , p_include_all_flag IN VARCHAR2
1124: , p_global_exposure_flag IN VARCHAR2 := 'N'
1125: , x_cc_result_out OUT NOCOPY VARCHAR2
1126: , x_return_status OUT NOCOPY VARCHAR2

Line 1147: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice

1143:
1144:
1145:
1146:
1147: OE_CREDIT_CHECK_UTIL.Get_Past_Due_Invoice
1148: ( p_customer_id => p_customer_id
1149: , p_site_use_id => p_site_use_id
1150: , p_party_id => p_party_id
1151: , p_credit_check_rule_rec => p_credit_check_rule_rec

Line 1204: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

1200: , p_customer_id IN NUMBER
1201: , p_site_use_id IN NUMBER
1202: , p_credit_level IN VARCHAR2
1203: , p_credit_check_rule_rec IN
1204: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1205: , p_system_parameter_rec IN
1206: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1207: , p_limit_curr_code IN VARCHAR2
1208: , p_trx_credit_limit IN NUMBER

Line 1206: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

1202: , p_credit_level IN VARCHAR2
1203: , p_credit_check_rule_rec IN
1204: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
1205: , p_system_parameter_rec IN
1206: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
1207: , p_limit_curr_code IN VARCHAR2
1208: , p_trx_credit_limit IN NUMBER
1209: , p_calling_action IN VARCHAR2
1210: , p_transaction_amount IN NUMBER

Line 1213: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

1209: , p_calling_action IN VARCHAR2
1210: , p_transaction_amount IN NUMBER
1211: , x_cc_result_out OUT NOCOPY VARCHAR2
1212: , x_return_status OUT NOCOPY VARCHAR2
1213: , x_conversion_status OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1214: )
1215: IS
1216:
1217: l_order_value NUMBER := 0 ;

Line 1254: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

1250: THEN
1251: OE_DEBUG_PUB.ADD(' call GET_transaction_amount ');
1252: END IF;
1253:
1254: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
1255: ( p_header_id => p_header_rec.header_id
1256: , p_transaction_curr_code => p_header_rec.transactional_curr_code
1257: , p_credit_check_rule_rec => p_credit_check_rule_rec
1258: , p_system_parameter_rec => p_system_parameter_rec

Line 1279: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount

1275: THEN
1276: OE_DEBUG_PUB.ADD(' call GET_external_trx_amount ');
1277: END IF;
1278:
1279: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount
1280: ( p_transaction_curr_code => p_header_rec.transactional_curr_code
1281: , p_transaction_amount => p_transaction_amount
1282: , p_credit_check_rule_rec => p_credit_check_rule_rec
1283: , p_system_parameter_rec => p_system_parameter_rec

Line 1487: OE_Credit_Check_Util.OE_credit_rules_rec_type

1483: , p_customer_id IN NUMBER
1484: , p_site_use_id IN NUMBER
1485: , p_calling_action IN VARCHAR2 := 'BOOKING'
1486: , p_credit_check_rule_rec IN
1487: OE_Credit_Check_Util.OE_credit_rules_rec_type
1488: , p_party_id IN NUMBER
1489: , x_check_order_flag OUT NOCOPY VARCHAR2
1490: , x_credit_check_lvl_out OUT NOCOPY VARCHAR2
1491: , x_default_limit_flag OUT NOCOPY VARCHAR2

Line 1495: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

1491: , x_default_limit_flag OUT NOCOPY VARCHAR2
1492: , x_limit_curr_code OUT NOCOPY VARCHAR2
1493: , x_overall_credit_limit OUT NOCOPY NUMBER
1494: , x_trx_credit_limit OUT NOCOPY NUMBER
1495: , x_usage_curr OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1496: , x_include_all_flag OUT NOCOPY VARCHAR2
1497: , x_return_status OUT NOCOPY VARCHAR2
1498: , x_global_exposure_flag OUT NOCOPY VARCHAR2
1499: , x_credit_limit_entity_id OUT NOCOPY NUMBER

Line 1568: OE_CREDIT_CHECK_UTIL.Get_Limit_Info

1564: -- [a 11.5.3 feature] |
1565: ------------------------------------------------
1566:
1567:
1568: OE_CREDIT_CHECK_UTIL.Get_Limit_Info
1569: ( p_header_id => p_header_rec.header_id
1570: , p_entity_type => 'SITE'
1571: , p_entity_id => p_site_use_id
1572: , p_cust_account_id => p_customer_id

Line 1697: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

1693: , p_transaction_amount IN NUMBER DEFAULT 0
1694: , p_limit_curr_code IN VARCHAR2
1695: , p_overall_credit_limit IN NUMBER
1696: , p_calling_action IN VARCHAR2
1697: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
1698: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
1699: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
1700: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
1701: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

Line 1701: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type

1697: , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
1698: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
1699: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
1700: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
1701: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
1702: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
1703: , p_global_exposure_flag IN VARCHAR2 := 'N'
1704: , p_credit_limit_entity_id IN VARCHAR2
1705: , x_total_exposure OUT NOCOPY NUMBER

Line 1702: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type

1698: , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
1699: , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
1700: , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
1701: , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
1702: , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
1703: , p_global_exposure_flag IN VARCHAR2 := 'N'
1704: , p_credit_limit_entity_id IN VARCHAR2
1705: , x_total_exposure OUT NOCOPY NUMBER
1706: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 1707: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

1703: , p_global_exposure_flag IN VARCHAR2 := 'N'
1704: , p_credit_limit_entity_id IN VARCHAR2
1705: , x_total_exposure OUT NOCOPY NUMBER
1706: , x_cc_result_out OUT NOCOPY VARCHAR2
1707: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1708: , x_return_status OUT NOCOPY VARCHAR2
1709: )
1710: IS
1711:

Line 1713: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;

1709: )
1710: IS
1711:
1712:
1713: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE ;
1714: l_customer_id NUMBER;
1715: l_site_id NUMBER;
1716: l_transaction_value NUMBER := 0;
1717: l_current_order_value NUMBER := 0 ;

Line 1793: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount

1789: THEN
1790: OE_DEBUG_PUB.Add('OEXVCRHB GET_external_trx_amount ');
1791: END IF;
1792:
1793: OE_CREDIT_CHECK_UTIL.GET_external_trx_amount
1794: ( p_transaction_curr_code => p_transaction_curr_code
1795: , p_transaction_amount => p_transaction_amount
1796: , p_credit_check_rule_rec => p_credit_check_rule_rec
1797: , p_system_parameter_rec => p_system_parameter_rec

Line 1834: OE_credit_check_util.Get_order_exposure

1830:
1831: IF NVL(p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG,'N') = 'N'
1832: THEN
1833:
1834: OE_credit_check_util.Get_order_exposure
1835: ( p_header_id => p_header_id
1836: , p_transaction_curr_code => p_transaction_curr_code
1837: , p_customer_id => p_customer_id
1838: , p_site_use_id => p_site_use_id

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

1930: NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1931: FND_API.G_FALSE
1932: THEN
1933: l_current_order_value :=
1934: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
1935: IF G_debug_flag = 'Y'
1936: THEN
1937: OE_DEBUG_PUB.Add('Calling action=BOOKING and G_delayed_request=FALSE');
1938: END IF;

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

1965:
1966: IF g_hold_exist = 'Y'
1967: THEN
1968: l_current_order_value :=
1969: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
1970: END IF;
1971: -- add this ELSIF for bug fix 4184524
1972: ELSIF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
1973: THEN

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

1971: -- add this ELSIF for bug fix 4184524
1972: ELSIF NVL(p_credit_check_rule_rec.uninvoiced_orders_flag,'N') = 'N'
1973: THEN
1974: l_current_order_value :=
1975: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
1976: END IF; -- end of bug fix 4184524
1977: END IF;
1978: END IF;
1979:

Line 2100: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

2096: , p_customer_id IN NUMBER
2097: , p_site_use_id IN NUMBER
2098: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2099: , p_credit_check_rule_rec IN
2100: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2101: , p_system_parameter_rec IN
2102: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2103: , x_cc_hold_comment OUT NOCOPY VARCHAR2
2104: , x_cc_result_out OUT NOCOPY VARCHAR2

Line 2102: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

2098: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
2099: , p_credit_check_rule_rec IN
2100: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
2101: , p_system_parameter_rec IN
2102: OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
2103: , x_cc_hold_comment OUT NOCOPY VARCHAR2
2104: , x_cc_result_out OUT NOCOPY VARCHAR2
2105: , x_return_status OUT NOCOPY VARCHAR2
2106: )

Line 2113: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;

2109: l_limit_category_sum NUMBER := 0 ; -- Sum converted to Limit currency
2110:
2111: l_return_status VARCHAR2(30);
2112: l_include_tax_flag VARCHAR2(1) := 'Y';
2113: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2114: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2115: j BINARY_INTEGER := 1;
2116: i BINARY_INTEGER := 1;
2117: l_cc_result_out VARCHAR2(30);

Line 2114: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;

2110:
2111: l_return_status VARCHAR2(30);
2112: l_include_tax_flag VARCHAR2(1) := 'Y';
2113: l_item_limits OE_CREDIT_CHECK_UTIL.item_limits_tbl_type;
2114: l_lines OE_CREDIT_CHECK_UTIL.lines_Rec_tbl_type;
2115: j BINARY_INTEGER := 1;
2116: i BINARY_INTEGER := 1;
2117: l_cc_result_out VARCHAR2(30);
2118: l_check_category_id NUMBER;

Line 2140: OE_CREDIT_CHECK_UTIL.Get_Item_Limit

2136:
2137: l_include_tax_flag := p_credit_check_rule_rec.include_tax_flag ;
2138:
2139:
2140: OE_CREDIT_CHECK_UTIL.Get_Item_Limit
2141: ( p_header_id => p_header_rec.header_id
2142: , p_include_tax_flag => p_credit_check_rule_rec.include_tax_flag
2143: , p_site_use_id => NULL
2144: , p_trx_curr_code => p_header_rec.transactional_curr_code

Line 2202: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2198:
2199: l_check_category_id := l_item_limits(i).item_category_id ;
2200: l_limit_curr := l_item_limits(i).limit_curr_code ;
2201: l_limit_category_sum :=
2202: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2203: ( p_amount => l_category_sum
2204: , p_transactional_currency => p_header_rec.transactional_curr_code
2205: , p_limit_currency => l_item_limits(i).limit_curr_code
2206: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 2321: OE_Credit_Check_Util.OE_credit_rules_rec_type

2317: , p_customer_id IN NUMBER
2318: , p_site_use_id IN NUMBER
2319: , p_calling_action IN VARCHAR2 := 'BOOKING'
2320: , p_credit_check_rule_rec IN
2321: OE_Credit_Check_Util.OE_credit_rules_rec_type
2322: , p_system_parameter_rec IN
2323: OE_Credit_Check_Util.OE_systems_param_rec_type
2324: , p_transaction_amount IN NUMBER
2325: , p_party_id IN NUMBER ---------------------new (FPI)

Line 2323: OE_Credit_Check_Util.OE_systems_param_rec_type

2319: , p_calling_action IN VARCHAR2 := 'BOOKING'
2320: , p_credit_check_rule_rec IN
2321: OE_Credit_Check_Util.OE_credit_rules_rec_type
2322: , p_system_parameter_rec IN
2323: OE_Credit_Check_Util.OE_systems_param_rec_type
2324: , p_transaction_amount IN NUMBER
2325: , p_party_id IN NUMBER ---------------------new (FPI)
2326: , x_credit_level OUT NOCOPY VARCHAR2
2327: , x_check_exposure_mode OUT NOCOPY VARCHAR2

Line 2340: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;

2336: l_default_limit_flag VARCHAR2(1);
2337: l_limit_curr_code VARCHAR2(30);
2338: l_overall_credit_limit NUMBER;
2339: l_trx_credit_limit NUMBER;
2340: l_usage_curr OE_CREDIT_CHECK_UTIL.curr_tbl_type;
2341: l_include_all_flag VARCHAR2(1);
2342: l_prev_customer_id NUMBER;
2343: l_customer_result_out VARCHAR2(30) := NULL;
2344: l_total_exposure NUMBER;

Line 2349: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;

2345: l_orders NUMBER;
2346: l_orders_on_hold NUMBER;
2347: l_payments_overdue NUMBER;
2348: l_payments_at_risk NUMBER;
2349: l_error_curr_tbl OE_CREDIT_CHECK_UTIL. curr_tbl_type ;
2350: l_cc_profile_used VARCHAR2(30);
2351: l_cc_limit_used VARCHAR2(80);
2352: l_cc_result_out VARCHAR2(30);
2353: l_request_id NUMBER; -----------------------new (FPI)

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

2480: l_credit_profile_level := NULL;
2481: END;
2482: END IF;
2483:
2484: FOR i IN 1 .. OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.count
2485: LOOP
2486: OE_DEBUG_PUB.Add('Bill to site changed to: ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id || ' from: ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id);
2487: OE_DEBUG_PUB.Add('slagiset: x_credit_level ' || x_credit_level);
2488: OE_DEBUG_PUB.Add('slagiset: l_credit_profile_level ' || l_credit_profile_level);

Line 2486: OE_DEBUG_PUB.Add('Bill to site changed to: ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id || ' from: ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id);

2482: END IF;
2483:
2484: FOR i IN 1 .. OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.count
2485: LOOP
2486: OE_DEBUG_PUB.Add('Bill to site changed to: ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id || ' from: ' || OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id);
2487: OE_DEBUG_PUB.Add('slagiset: x_credit_level ' || x_credit_level);
2488: OE_DEBUG_PUB.Add('slagiset: l_credit_profile_level ' || l_credit_profile_level);
2489: IF x_credit_level = 'CUSTOMER' AND l_credit_profile_level ='CUSTOMER' THEN
2490: SELECT acct_site.cust_account_id

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

2491: INTO l_new_cust_account_id
2492: FROM HZ_CUST_SITE_USES_ALL SITE,
2493: HZ_PARTY_SITES PARTY_SITE,
2494: HZ_CUST_ACCT_SITES ACCT_SITE
2495: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id
2496: AND SITE.SITE_USE_CODE = 'BILL_TO'
2497: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2498: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2499: AND SITE.ORG_ID = ACCT_SITE.ORG_ID;

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

2502: INTO l_old_cust_account_id
2503: FROM HZ_CUST_SITE_USES_ALL SITE,
2504: HZ_PARTY_SITES PARTY_SITE,
2505: HZ_CUST_ACCT_SITES ACCT_SITE
2506: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id
2507: AND SITE.SITE_USE_CODE = 'BILL_TO'
2508: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2509: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2510: AND SITE.ORG_ID = ACCT_SITE.ORG_ID;

Line 2536: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete;

2532: END IF;
2533: ELSE
2534: oe_debug_pub.ADD('slagiset: No tolerance check is required. Since, there is no released hold for this order.');
2535: END IF;
2536: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete;
2537: --ER 12363706 end
2538: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2539: RAISE FND_API.G_EXC_ERROR;
2540: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2606: g_order := OE_CREDIT_CHECK_UTIL.g_current_order_value ;

2602: RAISE FND_API.G_EXC_ERROR;
2603: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2605: END IF;
2606: g_order := OE_CREDIT_CHECK_UTIL.g_current_order_value ;
2607:
2608:
2609: -- IF l_cc_result_out = 'PASS' THEN
2610: -- Changed IF condition to fix bug 4002820, need to do overall

Line 2614: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

2610: -- Changed IF condition to fix bug 4002820, need to do overall
2611: -- limit checking even order limit checking failed when
2612: -- Credit Management is installed and used.
2613:
2614: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2615: THEN
2616: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2617: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2618: END IF;

Line 2616: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

2612: -- Credit Management is installed and used.
2613:
2614: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2615: THEN
2616: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2617: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2618: END IF;
2619:
2620: IF l_cc_trx_result_out = 'PASS'

Line 2621: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

2617: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2618: END IF;
2619:
2620: IF l_cc_trx_result_out = 'PASS'
2621: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
2622: IF G_debug_flag = 'Y' THEN
2623: OE_DEBUG_PUB.Add('Calling Check Past Due Invoice procedure');
2624: END IF;
2625:

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

2648: IF l_cc_limit_used IS NOT NULL THEN
2649: -- in order to disply useful message if two or more checkings fail.
2650: -- l_cc_limit_used := 'Order limit exceeded' || ', overdue invoices found';
2651: -- bug 4153299
2652: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2653: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE');
2654:
2655: --ER8880886
2656: i_hld_rec := i_hld_rec +1;

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

2649: -- in order to disply useful message if two or more checkings fail.
2650: -- l_cc_limit_used := 'Order limit exceeded' || ', overdue invoices found';
2651: -- bug 4153299
2652: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2653: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE');
2654:
2655: --ER8880886
2656: i_hld_rec := i_hld_rec +1;
2657: l_hold_reason_rec.extend;

Line 2683: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN

2679: -- Changed IF condition to fix bug 4002813, need to do overall
2680: -- limit checking even order limit checking failed when
2681: -- Credit Management is installed and used.
2682: IF l_cc_duedate_result_out = 'PASS'
2683: OR OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE THEN
2684: ----------------------------------------------------+
2685: -- order is subject to credit check: |
2686: ----------------------------------------------------|
2687: -- check 1: item limit <-- passed/failed|

Line 2736: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,

2732: END IF;
2733: --Bug 4320650
2734: l_unrounded_exposure := l_total_exposure;
2735:
2736: OE_CREDIT_CHECK_UTIL.Rounded_Amount(l_limit_curr_code,
2737: l_unrounded_exposure,
2738: l_total_exposure);
2739:
2740: -- bug 4002820

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

2744: IF INSTR(l_cc_limit_used, ',') >0 THEN
2745: -- l_cc_limit_used := l_cc_limit_used || ', overall limit exceeded';
2746: --bug 4153299
2747: l_cc_limit_used := l_cc_limit_used || ', '
2748: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2749:
2750: --ER8880886
2751: i_hld_rec := i_hld_rec +1;
2752: l_hold_reason_rec.extend;

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

2761: --ER8880886
2762: IF l_cc_trx_result_out = 'FAIL' THEN
2763: -- l_cc_limit_used := 'Order limit, overall limit exceeded';
2764: -- bug 4153299
2765: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2766: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2767:
2768: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2769: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';

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

2762: IF l_cc_trx_result_out = 'FAIL' THEN
2763: -- l_cc_limit_used := 'Order limit, overall limit exceeded';
2764: -- bug 4153299
2765: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'ORDER') || ', '
2766: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2767:
2768: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2769: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';
2770: -- bug 4153299

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

2767:
2768: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2769: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';
2770: -- bug 4153299
2771: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
2772: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2773:
2774:
2775: END IF;

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

2768: ELSIF l_cc_duedate_result_out = 'FAIL' THEN
2769: -- l_cc_limit_used := 'Overdue invoices found'||', overall limit exceeded';
2770: -- bug 4153299
2771: l_cc_limit_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERDUE') || ', '
2772: || OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_LIMIT', 'OVERALL');
2773:
2774:
2775: END IF;
2776: ELSE

Line 2822: OE_CREDIT_CHECK_UTIL.g_current_order_value );

2818: OE_DEBUG_PUB.Add(' OEXVCRHB: l_cc_limit_used ==> '|| l_cc_limit_used );
2819: OE_DEBUG_PUB.Add(' before l_cc_result_out => '|| l_cc_result_out );
2820:
2821: OE_DEBUG_PUB.add(' g_current_order_value => '||
2822: OE_CREDIT_CHECK_UTIL.g_current_order_value );
2823:
2824: OE_DEBUG_PUB.Add('before g_order ==> ' || g_order );
2825: END IF;
2826:

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

2851: OE_DEBUG_PUB.Add('Calling Apply_Order_CC_Hold ');
2852: END IF;
2853:
2854: -- bug 4153299
2855: -- 6616741 l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', l_cc_profile_used);
2856:
2857: Apply_Order_CC_Hold
2858: ( p_header_id => p_header_rec.header_id
2859: , p_order_number => p_header_rec.order_number

Line 2881: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL

2877: -- changed IF condition for bug 4002820
2878: -- IF l_cc_limit_used = 'OVERALL'
2879: --IF l_cc_overall_result_out = 'FAIL' --commented for ER8880886
2880: --THEN --commented for ER8880886
2881: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2882: THEN
2883: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2884: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2885: END IF;

Line 2883: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=

2879: --IF l_cc_overall_result_out = 'FAIL' --commented for ER8880886
2880: --THEN --commented for ER8880886
2881: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed is NULL
2882: THEN
2883: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2884: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2885: END IF;
2886:
2887: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE

Line 2887: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE

2883: OE_CREDIT_CHECK_UTIL.G_crmgmt_installed :=
2884: AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed ;
2885: END IF;
2886:
2887: IF OE_CREDIT_CHECK_UTIL.G_crmgmt_installed = TRUE
2888: THEN
2889: --bug 5907331
2890: l_review_party_id := p_party_id;
2891: ------check if the credit check level is PARTY, CUSTOMER or SITE

Line 3089: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

3085:
3086: PROCEDURE Check_order_credit
3087: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
3088: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
3089: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
3090: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
3091: , p_transaction_amount IN NUMBER DEFAULT NULL
3092: , x_msg_count OUT NOCOPY NUMBER
3093: , x_msg_data OUT NOCOPY VARCHAR2

Line 3090: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type

3086: PROCEDURE Check_order_credit
3087: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
3088: , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
3089: , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
3090: , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
3091: , p_transaction_amount IN NUMBER DEFAULT NULL
3092: , x_msg_count OUT NOCOPY NUMBER
3093: , x_msg_data OUT NOCOPY VARCHAR2
3094: , x_cc_result_out OUT NOCOPY VARCHAR2