53: x_external_amount := 0 ;
54:
55: IF G_debug_flag = 'Y'
56: THEN
57: OE_DEBUG_PUB.ADD( 'IN OEXPCRXB: Get_Customer_Exposure ');
58: OE_DEBUG_PUB.ADD(' Calling OE_Credit_Engine_GRP.Get_customer_exposure',1);
59:
60: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
54:
55: IF G_debug_flag = 'Y'
56: THEN
57: OE_DEBUG_PUB.ADD( 'IN OEXPCRXB: Get_Customer_Exposure ');
58: OE_DEBUG_PUB.ADD(' Calling OE_Credit_Engine_GRP.Get_customer_exposure',1);
59:
60: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
62: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
56: THEN
57: OE_DEBUG_PUB.ADD( 'IN OEXPCRXB: Get_Customer_Exposure ');
58: OE_DEBUG_PUB.ADD(' Calling OE_Credit_Engine_GRP.Get_customer_exposure',1);
59:
60: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
62: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
63: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
64: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
57: OE_DEBUG_PUB.ADD( 'IN OEXPCRXB: Get_Customer_Exposure ');
58: OE_DEBUG_PUB.ADD(' Calling OE_Credit_Engine_GRP.Get_customer_exposure',1);
59:
60: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
62: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
63: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
64: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
65: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
58: OE_DEBUG_PUB.ADD(' Calling OE_Credit_Engine_GRP.Get_customer_exposure',1);
59:
60: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
62: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
63: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
64: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
65: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
66: END IF;
59:
60: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
62: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
63: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
64: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
65: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
66: END IF;
67:
60: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
62: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
63: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
64: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
65: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
66: END IF;
67:
68:
61: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
62: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
63: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
64: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
65: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
66: END IF;
67:
68:
69: OE_Credit_Engine_GRP.Get_customer_exposure
82: );
83:
84: IF G_debug_flag = 'Y'
85: THEN
86: OE_DEBUG_PUB.ADD(' x_return_status => '||
87: x_return_status );
88: OE_DEBUG_PUB.ADD(' x_external_amount => '||
89: x_external_amount );
90: OE_DEBUG_PUB.ADD(' x_ar_amount => '||
84: IF G_debug_flag = 'Y'
85: THEN
86: OE_DEBUG_PUB.ADD(' x_return_status => '||
87: x_return_status );
88: OE_DEBUG_PUB.ADD(' x_external_amount => '||
89: x_external_amount );
90: OE_DEBUG_PUB.ADD(' x_ar_amount => '||
91: x_ar_amount );
92: OE_DEBUG_PUB.ADD(' x_order_amount => '||
86: OE_DEBUG_PUB.ADD(' x_return_status => '||
87: x_return_status );
88: OE_DEBUG_PUB.ADD(' x_external_amount => '||
89: x_external_amount );
90: OE_DEBUG_PUB.ADD(' x_ar_amount => '||
91: x_ar_amount );
92: OE_DEBUG_PUB.ADD(' x_order_amount => '||
93: x_order_amount );
94: OE_DEBUG_PUB.ADD (' x_order_hold_amount => '||
88: OE_DEBUG_PUB.ADD(' x_external_amount => '||
89: x_external_amount );
90: OE_DEBUG_PUB.ADD(' x_ar_amount => '||
91: x_ar_amount );
92: OE_DEBUG_PUB.ADD(' x_order_amount => '||
93: x_order_amount );
94: OE_DEBUG_PUB.ADD (' x_order_hold_amount => '||
95: x_order_hold_amount );
96: OE_DEBUG_PUB.ADD (' x_total_exposure => '||
90: OE_DEBUG_PUB.ADD(' x_ar_amount => '||
91: x_ar_amount );
92: OE_DEBUG_PUB.ADD(' x_order_amount => '||
93: x_order_amount );
94: OE_DEBUG_PUB.ADD (' x_order_hold_amount => '||
95: x_order_hold_amount );
96: OE_DEBUG_PUB.ADD (' x_total_exposure => '||
97: x_total_exposure );
98: OE_DEBUG_PUB.ADD( 'OUT OEXPCRXB: Get_Customer_Exposure ');
92: OE_DEBUG_PUB.ADD(' x_order_amount => '||
93: x_order_amount );
94: OE_DEBUG_PUB.ADD (' x_order_hold_amount => '||
95: x_order_hold_amount );
96: OE_DEBUG_PUB.ADD (' x_total_exposure => '||
97: x_total_exposure );
98: OE_DEBUG_PUB.ADD( 'OUT OEXPCRXB: Get_Customer_Exposure ');
99: END IF;
100:
94: OE_DEBUG_PUB.ADD (' x_order_hold_amount => '||
95: x_order_hold_amount );
96: OE_DEBUG_PUB.ADD (' x_total_exposure => '||
97: x_total_exposure );
98: OE_DEBUG_PUB.ADD( 'OUT OEXPCRXB: Get_Customer_Exposure ');
99: END IF;
100:
101: END Get_customer_exposure ;
102: