eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_ENGINE_GRP dependencies on OE_CREDIT_CHECK_UTIL

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

43:
44: --=========================================================================
45: -- PRIVATE GLOBAL VARIABLES
46: --=========================================================================
47: G_debug_flag VARCHAR2(1) := NVL(OE_CREDIT_CHECK_UTIL.check_debug_flag ,'N');
48:
49: --=========================================================================
50: -- PROCEDURES AND FUNCTIONS
51: --=========================================================================

Line 228: p_credit_check_rule_rec OUT NOCOPY OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

224:
225: --ER 12363706 start
226: FUNCTION Is_Tolerance_Enabled
227: ( p_header_id IN NUMBER,
228: p_credit_check_rule_rec OUT NOCOPY OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
229: )
230: RETURN BOOLEAN
231: IS
232: l_credit_check_rule_id NUMBER;

Line 233: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;

229: )
230: RETURN BOOLEAN
231: IS
232: l_credit_check_rule_id NUMBER;
233: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
234: l_header_rec OE_Order_PUB.Header_Rec_Type;
235: l_released_order_amount NUMBER;
236: l_curr_order_amount NUMBER;
237: l_tolerance_percentage NUMBER;

Line 262: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

258: , x_credit_rule_id => l_credit_check_rule_id
259: );
260:
261:
262: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
263: ( p_header_id => p_header_id
264: , p_credit_check_rule_id => l_credit_check_rule_id
265: , x_credit_check_rules_rec => l_credit_check_rule_rec
266: );

Line 304: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;

300: )
301: RETURN BOOLEAN
302: IS
303: l_credit_check_rule_id NUMBER;
304: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
305: l_header_rec OE_Order_PUB.Header_Rec_Type;
306: l_released_order_amount NUMBER;
307: l_released_curr_code VARCHAR2(15);
308: l_released_order_amount_conv NUMBER;

Line 314: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

310: l_tolerance_amount_conv NUMBER;
311: l_tolerance_amount_per NUMBER;
312: l_tolerance_amount_fin NUMBER;
313: l_return_status VARCHAR2(30);
314: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
315:
316: CURSOR res_det IS
317: SELECT OHR.Released_Order_Amount,OHR.Released_Curr_code
318: FROM OE_ORDER_HOLDS OOH,

Line 344: OE_CREDIT_CHECK_UTIL.GET_transaction_amount

340: x_header_rec => l_header_rec);
341:
342: l_credit_check_rule_rec.credit_check_level_code := 'ORDER';
343:
344: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
345: ( p_header_id => p_header_id
346: , p_transaction_curr_code => l_header_rec.transactional_curr_code
347: , p_credit_check_rule_rec => l_credit_check_rule_rec
348: , p_system_parameter_rec => NULL

Line 365: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

361:
362: IF l_released_curr_code <> l_header_rec.transactional_curr_code
363: THEN
364: l_released_order_amount_conv :=
365: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
366: ( p_amount => l_released_order_amount
367: , p_transactional_currency => l_released_curr_code
368: , p_limit_currency => l_header_rec.transactional_curr_code
369: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 391: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

387:
388: IF l_credit_check_rule_rec.tolerance_curr_code <> l_header_rec.transactional_curr_code
389: THEN
390: l_tolerance_amount_conv :=
391: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
392: ( p_amount => l_credit_check_rule_rec.tolerance_amount
393: , p_transactional_currency => l_credit_check_rule_rec.tolerance_curr_code
394: , p_limit_currency => l_header_rec.transactional_curr_code
395: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

Line 803: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;

799:
800:
801: l_msg_count NUMBER := 0 ;
802: l_msg_data VARCHAR2(2000):= NULL ;
803: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
804: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
805: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
806: l_total_exposure NUMBER;
807: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 804: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;

800:
801: l_msg_count NUMBER := 0 ;
802: l_msg_data VARCHAR2(2000):= NULL ;
803: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
804: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
805: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
806: l_total_exposure NUMBER;
807: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
808: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 805: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

801: l_msg_count NUMBER := 0 ;
802: l_msg_data VARCHAR2(2000):= NULL ;
803: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
804: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
805: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
806: l_total_exposure NUMBER;
807: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
808: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
809: l_return_status VARCHAR2(50);

Line 807: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

803: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
804: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
805: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
806: l_total_exposure NUMBER;
807: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
808: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
809: l_return_status VARCHAR2(50);
810: l_include_all_flag VARCHAR2(15);
811: i INTEGER:=0;

Line 808: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

804: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
805: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
806: l_total_exposure NUMBER;
807: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
808: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
809: l_return_status VARCHAR2(50);
810: l_include_all_flag VARCHAR2(15);
811: i INTEGER:=0;
812: j INTEGER:=0;

Line 839: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

835: l_global_exposure_flag := 'N' ;
836:
837:
838: ---get credit check rule record
839: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
840: ( p_credit_check_rule_id => p_credit_check_rule_id
841: , x_credit_check_rules_rec => l_credit_check_rule_rec
842: );
843:

Line 845: OE_CREDIT_CHECK_UTIL.GET_System_parameters

841: , x_credit_check_rules_rec => l_credit_check_rule_rec
842: );
843:
844: -----Get system parameters record
845: OE_CREDIT_CHECK_UTIL.GET_System_parameters
846: ( x_system_parameter_rec=>l_system_parameters_rec
847: );
848:
849: OE_DEBUG_PUB.ADD('Check entity type ');

Line 868: OE_CREDIT_CHECK_UTIL.Get_Usages

864: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for PARTY level ');
865: END IF;
866:
867: ----get table of usages
868: OE_CREDIT_CHECK_UTIL.Get_Usages
869: ( p_entity_type => 'PARTY'
870: , p_entity_id => p_party_id
871: , p_limit_curr_code => p_limit_curr_code
872: , p_suppress_unused_usages_flag => 'Y'

Line 881: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');

877: );
878:
879: IF G_debug_flag = 'Y'
880: THEN
881: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
882: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
883: OE_DEBUG_PUB.ADD('---------------------------------------');
884: END IF;
885:

Line 987: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

983: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
984: END IF;
985:
986: l_global_exposure_flag :=
987: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
988: ( p_entity_type => 'CUSTOMER'
989: , p_entity_id => p_customer_id
990: , p_limit_curr_code => p_limit_curr_code
991: );

Line 1008: OE_CREDIT_CHECK_UTIL.Get_Usages

1004: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for CUSTOMER level ');
1005: END IF;
1006:
1007: ----get table of usages
1008: OE_CREDIT_CHECK_UTIL.Get_Usages
1009: ( p_entity_type => 'CUSTOMER'
1010: , p_entity_id => p_customer_id
1011: , p_limit_curr_code => p_limit_curr_code
1012: , p_suppress_unused_usages_flag => 'Y'

Line 1021: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');

1017: );
1018:
1019: IF G_debug_flag = 'Y'
1020: THEN
1021: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
1022: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
1023: OE_DEBUG_PUB.ADD('---------------------------------------');
1024: END IF;
1025:

Line 1122: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1118: ----non pre-calculate exposure
1119: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'
1120: THEN
1121:
1122: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1123: ( p_header_id => NULL
1124: , p_transaction_curr_code => NULL
1125: , p_customer_id => p_customer_id
1126: , p_site_use_id => NULL

Line 1224: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;

1220: END ;
1221:
1222: MO_GLOBAL.Set_Policy_Context('S', l_org_id) ;
1223:
1224: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;
1225:
1226: /* End MOAC CREDIT CHECK CHANGE */
1227:
1228: IF G_debug_flag = 'Y'

Line 1234: OE_CREDIT_CHECK_UTIL.Get_Usages

1230: OE_DEBUG_PUB.ADD('Site level exposure ');
1231: END IF;
1232:
1233: ----get table of usages
1234: OE_CREDIT_CHECK_UTIL.Get_Usages
1235: ( p_entity_type => 'SITE'
1236: , p_entity_id => p_site_id
1237: , p_limit_curr_code => p_limit_curr_code
1238: , p_suppress_unused_usages_flag => 'Y'

Line 1346: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1342: ----non pre-calculate exposure
1343: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'
1344: THEN
1345:
1346: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1347: ( p_header_id => NULL
1348: , p_transaction_curr_code => NULL
1349: , p_customer_id => p_customer_id
1350: , p_site_use_id => p_site_id

Line 1546: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;

1542:
1543: l_msg_count NUMBER := 0 ;
1544: l_msg_data VARCHAR2(2000):= NULL ;
1545: l_credit_check_rule_id NUMBER;
1546: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1547: l_system_parameter_rec OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ;
1548: l_cc_limit_used NUMBER;
1549: l_cc_profile_used VARCHAR2(30);
1550: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 1547: l_system_parameter_rec OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ;

1543: l_msg_count NUMBER := 0 ;
1544: l_msg_data VARCHAR2(2000):= NULL ;
1545: l_credit_check_rule_id NUMBER;
1546: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1547: l_system_parameter_rec OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ;
1548: l_cc_limit_used NUMBER;
1549: l_cc_profile_used VARCHAR2(30);
1550: l_header_rec OE_Order_PUB.Header_Rec_Type;
1551:

Line 1578: OE_CREDIT_CHECK_UTIL.G_org_id := p_org_id ;

1574: --ER#7479609 end
1575:
1576: --bug# 4967828
1577: IF p_org_id IS NOT NULL THEN
1578: OE_CREDIT_CHECK_UTIL.G_org_id := p_org_id ;
1579: END IF;
1580:
1581: -- Get Gl currency if calling action is not EXTERNAL
1582: --

Line 1593: OE_CREDIT_CHECK_UTIL.G_org_id := l_header_rec.org_id ;

1589: );
1590:
1591: --bug# 4967828
1592: IF p_org_id IS NULL THEN
1593: OE_CREDIT_CHECK_UTIL.G_org_id := l_header_rec.org_id ;
1594: END IF;
1595:
1596: IF G_debug_flag = 'Y'
1597: THEN

Line 1661: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

1657: -- Initialize the G_cc_hold_item_type and G_cc_hold_activity_name
1658: -- global variables
1659: Set_G_CC_Hold_Info;
1660:
1661: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
1662: ( p_credit_check_rule_id => l_credit_check_rule_id
1663: , x_credit_check_rules_rec => l_credit_check_rule_rec
1664: );
1665:

Line 1666: OE_CREDIT_CHECK_UTIL.GET_System_parameters

1662: ( p_credit_check_rule_id => l_credit_check_rule_id
1663: , x_credit_check_rules_rec => l_credit_check_rule_rec
1664: );
1665:
1666: OE_CREDIT_CHECK_UTIL.GET_System_parameters
1667: ( x_system_parameter_rec => l_system_parameter_rec
1668: );
1669:
1670: IF G_debug_flag = 'Y'

Line 1802: OE_credit_check_util.send_credit_hold_ntf

1798: NVL(p_calling_action, 'BOOKING') NOT IN ('EXTERNAL', 'AUTO RELEASE')
1799: THEN
1800: IF l_credit_check_rule_rec.send_hold_notifications_flag = 'Y'
1801: THEN
1802: OE_credit_check_util.send_credit_hold_ntf
1803: ( p_header_rec => l_header_rec
1804: , p_credit_hold_level => l_credit_check_rule_rec.credit_hold_level_code
1805: , p_cc_hold_comment => x_cc_hold_comment
1806: , x_return_status => x_return_status

Line 1929: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;

1925: END IF;
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: END IF;
1928:
1929: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;
1930:
1931: IF l_org_id IS NULL THEN
1932: Fnd_Message.set_name('FND','MO_ORG_REQUIRED');
1933: Oe_Msg_Pub.Add;

Line 1942: OE_CREDIT_CHECK_UTIL.G_org_id := NULL ;

1938: WHEN NO_DATA_FOUND
1939: THEN
1940: l_org_id := NULL ;
1941:
1942: OE_CREDIT_CHECK_UTIL.G_org_id := NULL ;
1943:
1944: OE_DEBUG_PUB.ADD(' Exception Set context');
1945: END ;
1946: