DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on QP_UTIL_PUB

Line 5900: oe_debug_pub.add('QP LIMITS NOT installed so no call to QP_UTIL_PUB.Reverse_Limits',1);

5896:
5897: -- BUG 2670775 Reverse Limits Begin
5898: -- If Limits processing is not installed, no need to proceed further
5899: IF NVL(FND_PROFILE.VALUE('QP_LIMITS_INSTALLED'),'N') = 'N' THEN
5900: oe_debug_pub.add('QP LIMITS NOT installed so no call to QP_UTIL_PUB.Reverse_Limits',1);
5901: RETURN;
5902: END IF;
5903: -- BUG 2670775 Reverse Limits End
5904:

Line 5936: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);

5932: END IF;
5933: --bug #7491829
5934:
5935: IF p_action_code = 'RETURN' and l_ret_price_request_code is NULL THEN
5936: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);
5937: OE_DEBUG_PUB.Add('return price_request_code is null so block limits call', 1);
5938: RETURN;
5939: END IF;
5940:

Line 5943: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);

5939: END IF;
5940:
5941: --bug#7491829
5942: IF p_action_code = 'SPLIT_NEW' and l_ret_price_request_code is NULL THEN
5943: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);
5944: OE_DEBUG_PUB.Add('split line price_request_code is null so block limits call', 1);
5945: END IF;
5946: --bug#7491829
5947:

Line 5949: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);

5945: END IF;
5946: --bug#7491829
5947:
5948: IF l_cons_price_request_code is NULL THEN
5949: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);
5950: OE_DEBUG_PUB.Add('consuming price_request_code is null so no limit for reversal', 1);
5951: RETURN;
5952: END IF;
5953:

Line 5954: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);

5950: OE_DEBUG_PUB.Add('consuming price_request_code is null so no limit for reversal', 1);
5951: RETURN;
5952: END IF;
5953:
5954: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
5955: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
5956: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
5957: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
5958: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);

Line 5955: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);

5951: RETURN;
5952: END IF;
5953:
5954: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
5955: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
5956: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
5957: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
5958: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
5959:

Line 5956: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);

5952: END IF;
5953:
5954: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
5955: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
5956: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
5957: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
5958: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
5959:
5960: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,

Line 5957: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);

5953:
5954: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
5955: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
5956: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
5957: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
5958: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
5959:
5960: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,
5961: p_cons_price_request_code => l_cons_price_request_code,

Line 5958: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);

5954: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
5955: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
5956: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
5957: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
5958: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
5959:
5960: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,
5961: p_cons_price_request_code => l_cons_price_request_code,
5962: p_orig_ordered_qty => l_orig_ordered_qty,

Line 5960: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,

5956: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
5957: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
5958: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
5959:
5960: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,
5961: p_cons_price_request_code => l_cons_price_request_code,
5962: p_orig_ordered_qty => l_orig_ordered_qty,
5963: p_amended_qty => p_amended_qty,
5964: p_ret_price_request_code => l_ret_price_request_code,

Line 5971: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns status of '|| l_return_status, 1);

5967: x_return_message => l_return_message
5968: );
5969:
5970:
5971: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns status of '|| l_return_status, 1);
5972: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns message of '|| l_return_message , 1);
5973: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5974: OE_Debug_PUB.Add('Error returned by QP_UTIL_PUB.Reverse_Limits',1);
5975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 5972: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns message of '|| l_return_message , 1);

5968: );
5969:
5970:
5971: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns status of '|| l_return_status, 1);
5972: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns message of '|| l_return_message , 1);
5973: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5974: OE_Debug_PUB.Add('Error returned by QP_UTIL_PUB.Reverse_Limits',1);
5975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5976: RAISE FND_API.G_EXC_ERROR;

Line 5974: OE_Debug_PUB.Add('Error returned by QP_UTIL_PUB.Reverse_Limits',1);

5970:
5971: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns status of '|| l_return_status, 1);
5972: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns message of '|| l_return_message , 1);
5973: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5974: OE_Debug_PUB.Add('Error returned by QP_UTIL_PUB.Reverse_Limits',1);
5975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5976: RAISE FND_API.G_EXC_ERROR;
5977: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;