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 555: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;

551:
552:
553: l_msg_count NUMBER := 0 ;
554: l_msg_data VARCHAR2(2000):= NULL ;
555: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
556: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
557: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
558: l_total_exposure NUMBER;
559: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 556: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;

552:
553: l_msg_count NUMBER := 0 ;
554: l_msg_data VARCHAR2(2000):= NULL ;
555: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
556: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
557: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
558: l_total_exposure NUMBER;
559: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
560: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 557: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

553: l_msg_count NUMBER := 0 ;
554: l_msg_data VARCHAR2(2000):= NULL ;
555: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
556: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
557: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
558: l_total_exposure NUMBER;
559: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
560: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
561: l_return_status VARCHAR2(50);

Line 559: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

555: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
556: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
557: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
558: l_total_exposure NUMBER;
559: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
560: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
561: l_return_status VARCHAR2(50);
562: l_include_all_flag VARCHAR2(15);
563: i INTEGER:=0;

Line 560: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

556: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
557: l_usage_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
558: l_total_exposure NUMBER;
559: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
560: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
561: l_return_status VARCHAR2(50);
562: l_include_all_flag VARCHAR2(15);
563: i INTEGER:=0;
564: j INTEGER:=0;

Line 591: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

587: l_global_exposure_flag := 'N' ;
588:
589:
590: ---get credit check rule record
591: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
592: ( p_credit_check_rule_id => p_credit_check_rule_id
593: , x_credit_check_rules_rec => l_credit_check_rule_rec
594: );
595:

Line 597: OE_CREDIT_CHECK_UTIL.GET_System_parameters

593: , x_credit_check_rules_rec => l_credit_check_rule_rec
594: );
595:
596: -----Get system parameters record
597: OE_CREDIT_CHECK_UTIL.GET_System_parameters
598: ( x_system_parameter_rec=>l_system_parameters_rec
599: );
600:
601: OE_DEBUG_PUB.ADD('Check entity type ');

Line 620: OE_CREDIT_CHECK_UTIL.Get_Usages

616: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for PARTY level ');
617: END IF;
618:
619: ----get table of usages
620: OE_CREDIT_CHECK_UTIL.Get_Usages
621: ( p_entity_type => 'PARTY'
622: , p_entity_id => p_party_id
623: , p_limit_curr_code => p_limit_curr_code
624: , p_suppress_unused_usages_flag => 'Y'

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

629: );
630:
631: IF G_debug_flag = 'Y'
632: THEN
633: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
634: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
635: OE_DEBUG_PUB.ADD('---------------------------------------');
636: END IF;
637:

Line 739: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

735: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
736: END IF;
737:
738: l_global_exposure_flag :=
739: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
740: ( p_entity_type => 'CUSTOMER'
741: , p_entity_id => p_customer_id
742: , p_limit_curr_code => p_limit_curr_code
743: );

Line 760: OE_CREDIT_CHECK_UTIL.Get_Usages

756: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for CUSTOMER level ');
757: END IF;
758:
759: ----get table of usages
760: OE_CREDIT_CHECK_UTIL.Get_Usages
761: ( p_entity_type => 'CUSTOMER'
762: , p_entity_id => p_customer_id
763: , p_limit_curr_code => p_limit_curr_code
764: , p_suppress_unused_usages_flag => 'Y'

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

769: );
770:
771: IF G_debug_flag = 'Y'
772: THEN
773: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
774: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
775: OE_DEBUG_PUB.ADD('---------------------------------------');
776: END IF;
777:

Line 874: OE_CREDIT_CHECK_UTIL.Get_order_exposure

870: ----non pre-calculate exposure
871: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'
872: THEN
873:
874: OE_CREDIT_CHECK_UTIL.Get_order_exposure
875: ( p_header_id => NULL
876: , p_transaction_curr_code => NULL
877: , p_customer_id => p_customer_id
878: , p_site_use_id => NULL

Line 976: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;

972: END ;
973:
974: MO_GLOBAL.Set_Policy_Context('S', l_org_id) ;
975:
976: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;
977:
978: /* End MOAC CREDIT CHECK CHANGE */
979:
980: IF G_debug_flag = 'Y'

Line 986: OE_CREDIT_CHECK_UTIL.Get_Usages

982: OE_DEBUG_PUB.ADD('Site level exposure ');
983: END IF;
984:
985: ----get table of usages
986: OE_CREDIT_CHECK_UTIL.Get_Usages
987: ( p_entity_type => 'SITE'
988: , p_entity_id => p_site_id
989: , p_limit_curr_code => p_limit_curr_code
990: , p_suppress_unused_usages_flag => 'Y'

Line 1098: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1094: ----non pre-calculate exposure
1095: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'
1096: THEN
1097:
1098: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1099: ( p_header_id => NULL
1100: , p_transaction_curr_code => NULL
1101: , p_customer_id => p_customer_id
1102: , p_site_use_id => p_site_id

Line 1298: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;

1294:
1295: l_msg_count NUMBER := 0 ;
1296: l_msg_data VARCHAR2(2000):= NULL ;
1297: l_credit_check_rule_id NUMBER;
1298: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1299: l_system_parameter_rec OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ;
1300: l_cc_limit_used NUMBER;
1301: l_cc_profile_used VARCHAR2(30);
1302: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 1299: l_system_parameter_rec OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ;

1295: l_msg_count NUMBER := 0 ;
1296: l_msg_data VARCHAR2(2000):= NULL ;
1297: l_credit_check_rule_id NUMBER;
1298: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1299: l_system_parameter_rec OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type ;
1300: l_cc_limit_used NUMBER;
1301: l_cc_profile_used VARCHAR2(30);
1302: l_header_rec OE_Order_PUB.Header_Rec_Type;
1303:

Line 1330: OE_CREDIT_CHECK_UTIL.G_org_id := p_org_id ;

1326: --ER#7479609 end
1327:
1328: --bug# 4967828
1329: IF p_org_id IS NOT NULL THEN
1330: OE_CREDIT_CHECK_UTIL.G_org_id := p_org_id ;
1331: END IF;
1332:
1333: -- Get Gl currency if calling action is not EXTERNAL
1334: --

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

1341: );
1342:
1343: --bug# 4967828
1344: IF p_org_id IS NULL THEN
1345: OE_CREDIT_CHECK_UTIL.G_org_id := l_header_rec.org_id ;
1346: END IF;
1347:
1348: IF G_debug_flag = 'Y'
1349: THEN

Line 1413: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

1409: -- Initialize the G_cc_hold_item_type and G_cc_hold_activity_name
1410: -- global variables
1411: Set_G_CC_Hold_Info;
1412:
1413: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
1414: ( p_credit_check_rule_id => l_credit_check_rule_id
1415: , x_credit_check_rules_rec => l_credit_check_rule_rec
1416: );
1417:

Line 1418: OE_CREDIT_CHECK_UTIL.GET_System_parameters

1414: ( p_credit_check_rule_id => l_credit_check_rule_id
1415: , x_credit_check_rules_rec => l_credit_check_rule_rec
1416: );
1417:
1418: OE_CREDIT_CHECK_UTIL.GET_System_parameters
1419: ( x_system_parameter_rec => l_system_parameter_rec
1420: );
1421:
1422: IF G_debug_flag = 'Y'

Line 1547: OE_credit_check_util.send_credit_hold_ntf

1543: NVL(p_calling_action, 'BOOKING') NOT IN ('EXTERNAL', 'AUTO RELEASE')
1544: THEN
1545: IF l_credit_check_rule_rec.send_hold_notifications_flag = 'Y'
1546: THEN
1547: OE_credit_check_util.send_credit_hold_ntf
1548: ( p_header_rec => l_header_rec
1549: , p_credit_hold_level => l_credit_check_rule_rec.credit_hold_level_code
1550: , p_cc_hold_comment => x_cc_hold_comment
1551: , x_return_status => x_return_status

Line 1669: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;

1665: END IF;
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668:
1669: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;
1670:
1671: IF l_org_id IS NULL THEN
1672: Fnd_Message.set_name('FND','MO_ORG_REQUIRED');
1673: Oe_Msg_Pub.Add;

Line 1682: OE_CREDIT_CHECK_UTIL.G_org_id := NULL ;

1678: WHEN NO_DATA_FOUND
1679: THEN
1680: l_org_id := NULL ;
1681:
1682: OE_CREDIT_CHECK_UTIL.G_org_id := NULL ;
1683:
1684: OE_DEBUG_PUB.ADD(' Exception Set context');
1685: END ;
1686: