DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on QP_UTIL_PUB

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

6253:
6254: -- BUG 2670775 Reverse Limits Begin
6255: -- If Limits processing is not installed, no need to proceed further
6256: IF NVL(FND_PROFILE.VALUE('QP_LIMITS_INSTALLED'),'N') = 'N' THEN
6257: oe_debug_pub.add('QP LIMITS NOT installed so no call to QP_UTIL_PUB.Reverse_Limits',1);
6258: RETURN;
6259: END IF;
6260: -- BUG 2670775 Reverse Limits End
6261:

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

6289: END IF;
6290: --bug #7491829
6291:
6292: IF p_action_code = 'RETURN' and l_ret_price_request_code is NULL THEN
6293: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);
6294: OE_DEBUG_PUB.Add('return price_request_code is null so block limits call', 1);
6295: RETURN;
6296: END IF;
6297:

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

6296: END IF;
6297:
6298: --bug#7491829
6299: IF p_action_code = 'SPLIT_NEW' and l_ret_price_request_code is NULL THEN
6300: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);
6301: OE_DEBUG_PUB.Add('split line price_request_code is null so block limits call', 1);
6302: END IF;
6303: --bug#7491829
6304:

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

6302: END IF;
6303: --bug#7491829
6304:
6305: IF l_cons_price_request_code is NULL THEN
6306: OE_Debug_PUB.Add('NO CALL made to QP_UTIL_PUB.Reverse_Limits ', 1);
6307: OE_DEBUG_PUB.Add('consuming price_request_code is null so no limit for reversal', 1);
6308: RETURN;
6309: END IF;
6310:

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

6307: OE_DEBUG_PUB.Add('consuming price_request_code is null so no limit for reversal', 1);
6308: RETURN;
6309: END IF;
6310:
6311: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
6312: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
6313: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
6314: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
6315: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);

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

6308: RETURN;
6309: END IF;
6310:
6311: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
6312: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
6313: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
6314: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
6315: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
6316:

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

6309: END IF;
6310:
6311: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
6312: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
6313: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
6314: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
6315: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
6316:
6317: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,

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

6310:
6311: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
6312: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
6313: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
6314: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
6315: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
6316:
6317: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,
6318: p_cons_price_request_code => l_cons_price_request_code,

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

6311: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: action_code is '||p_action_code, 1);
6312: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: price_request_code is '||l_cons_price_request_code, 1);
6313: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
6314: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
6315: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
6316:
6317: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,
6318: p_cons_price_request_code => l_cons_price_request_code,
6319: p_orig_ordered_qty => l_orig_ordered_qty,

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

6313: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: orig_ordered_qty is '||l_orig_ordered_qty, 1);
6314: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return request code '||l_ret_price_request_code, 1);
6315: OE_Debug_PUB.Add('Call to QP_UTIL_PUB.Reverse_Limits: return qty '||p_returned_qty, 1);
6316:
6317: QP_UTIL_PUB.Reverse_Limits (p_action_code => p_action_code,
6318: p_cons_price_request_code => l_cons_price_request_code,
6319: p_orig_ordered_qty => l_orig_ordered_qty,
6320: p_amended_qty => p_amended_qty,
6321: p_ret_price_request_code => l_ret_price_request_code,

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

6324: x_return_message => l_return_message
6325: );
6326:
6327:
6328: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns status of '|| l_return_status, 1);
6329: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns message of '|| l_return_message , 1);
6330: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6331: OE_Debug_PUB.Add('Error returned by QP_UTIL_PUB.Reverse_Limits',1);
6332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

6325: );
6326:
6327:
6328: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns status of '|| l_return_status, 1);
6329: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns message of '|| l_return_message , 1);
6330: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6331: OE_Debug_PUB.Add('Error returned by QP_UTIL_PUB.Reverse_Limits',1);
6332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6333: RAISE FND_API.G_EXC_ERROR;

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

6327:
6328: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns status of '|| l_return_status, 1);
6329: OE_Debug_PUB.Add('QP_UTIL_PUB.Reverse_Limits returns message of '|| l_return_message , 1);
6330: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6331: OE_Debug_PUB.Add('Error returned by QP_UTIL_PUB.Reverse_Limits',1);
6332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6333: RAISE FND_API.G_EXC_ERROR;
6334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;