43: --OUT:
44: --x_pricing_date
45: -- New customized price date
46: --x_return_status
47: -- FND_API.G_RET_STS_SUCCESS if API succeeds
48: -- FND_API.G_RET_STS_ERROR if API fails
49: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
50: -- Bug5598011 Added new parameter p_order_type which will indicate whether the
51: -- order document is REQUISITION or PO.
44: --x_pricing_date
45: -- New customized price date
46: --x_return_status
47: -- FND_API.G_RET_STS_SUCCESS if API succeeds
48: -- FND_API.G_RET_STS_ERROR if API fails
49: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
50: -- Bug5598011 Added new parameter p_order_type which will indicate whether the
51: -- order document is REQUISITION or PO.
52: --Testing:
45: -- New customized price date
46: --x_return_status
47: -- FND_API.G_RET_STS_SUCCESS if API succeeds
48: -- FND_API.G_RET_STS_ERROR if API fails
49: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
50: -- Bug5598011 Added new parameter p_order_type which will indicate whether the
51: -- order document is REQUISITION or PO.
52: --Testing:
53: --
71: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
72: l_progress VARCHAR2(3) := '000';
73: BEGIN
74: -- Check for the API version
75: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: END IF;
78:
79: /* This is where the customer will plug in their own custom logic.
72: l_progress VARCHAR2(3) := '000';
73: BEGIN
74: -- Check for the API version
75: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: END IF;
78:
79: /* This is where the customer will plug in their own custom logic.
80: The following lines will have to be replaced with your custom code
79: /* This is where the customer will plug in their own custom logic.
80: The following lines will have to be replaced with your custom code
81: determining the value of the OUT parameters. */
82: x_pricing_date := NULL;
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: END GET_CUSTOM_PRICE_DATE;
86:
87: --------------------------------------------------------------------------------
126: --OUT:
127: --x_new_currency_price
128: -- New customized currency price
129: --x_return_status
130: -- FND_API.G_RET_STS_SUCCESS if API succeeds
131: -- FND_API.G_RET_STS_ERROR if API fails
132: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
133: --Testing:
134: --
127: --x_new_currency_price
128: -- New customized currency price
129: --x_return_status
130: -- FND_API.G_RET_STS_SUCCESS if API succeeds
131: -- FND_API.G_RET_STS_ERROR if API fails
132: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
133: --Testing:
134: --
135: --End of Comments
128: -- New customized currency price
129: --x_return_status
130: -- FND_API.G_RET_STS_SUCCESS if API succeeds
131: -- FND_API.G_RET_STS_ERROR if API fails
132: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
133: --Testing:
134: --
135: --End of Comments
136: -------------------------------------------------------------------------------
153: l_api_version NUMBER := 1.0;
154: l_api_name VARCHAR2(60) := 'GET_CUSTOM_REQ_PRICE';
155: BEGIN
156: -- Check for the API version
157: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: END IF;
160:
161: /* This is where the customer will plug in their own custom pricing logic.
154: l_api_name VARCHAR2(60) := 'GET_CUSTOM_REQ_PRICE';
155: BEGIN
156: -- Check for the API version
157: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: END IF;
160:
161: /* This is where the customer will plug in their own custom pricing logic.
162: The following lines will have to be replaced with your custom code
161: /* This is where the customer will plug in their own custom pricing logic.
162: The following lines will have to be replaced with your custom code
163: determining the value of the OUT parameters. */
164: x_new_currency_price := NULL;
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: END GET_CUSTOM_REQ_PRICE;
168:
169: --------------------------------------------------------------------------------
207: --OUT:
208: --x_new_price
209: -- New customized price
210: --x_return_status
211: -- FND_API.G_RET_STS_SUCCESS if API succeeds
212: -- FND_API.G_RET_STS_ERROR if API fails
213: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
214: --Testing:
215: --
208: --x_new_price
209: -- New customized price
210: --x_return_status
211: -- FND_API.G_RET_STS_SUCCESS if API succeeds
212: -- FND_API.G_RET_STS_ERROR if API fails
213: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
214: --Testing:
215: --
216: --End of Comments
209: -- New customized price
210: --x_return_status
211: -- FND_API.G_RET_STS_SUCCESS if API succeeds
212: -- FND_API.G_RET_STS_ERROR if API fails
213: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
214: --Testing:
215: --
216: --End of Comments
217: -------------------------------------------------------------------------------
232: l_api_version NUMBER := 1.0;
233: l_api_name VARCHAR2(60) := 'GET_CUSTOM_PO_PRICE';
234: BEGIN
235: -- Check for the API version
236: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: END IF;
239:
240: /* This is where the customer will plug in their own custom pricing logic.
233: l_api_name VARCHAR2(60) := 'GET_CUSTOM_PO_PRICE';
234: BEGIN
235: -- Check for the API version
236: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: END IF;
239:
240: /* This is where the customer will plug in their own custom pricing logic.
241: The following lines will have to be replaced with your custom code
240: /* This is where the customer will plug in their own custom pricing logic.
241: The following lines will have to be replaced with your custom code
242: determining the value of the OUT parameters. */
243: x_new_price := NULL;
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: END GET_CUSTOM_PO_PRICE;
247:
248:
274: -- qp_ldets_v.line_index = p_line_index AND
275: -- qp_ldets_v.automatic_flag = 'Y'
276: --OUT:
277: --x_return_status
278: -- FND_API.G_RET_STS_SUCCESS if API succeeds
279: -- FND_API.G_RET_STS_ERROR if API fails
280: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
281: --Testing:
282: --
275: -- qp_ldets_v.automatic_flag = 'Y'
276: --OUT:
277: --x_return_status
278: -- FND_API.G_RET_STS_SUCCESS if API succeeds
279: -- FND_API.G_RET_STS_ERROR if API fails
280: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
281: --Testing:
282: --
283: --End of Comments
276: --OUT:
277: --x_return_status
278: -- FND_API.G_RET_STS_SUCCESS if API succeeds
279: -- FND_API.G_RET_STS_ERROR if API fails
280: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
281: --Testing:
282: --
283: --End of Comments
284: -------------------------------------------------------------------------------
303: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_index',p_line_index);
304: END IF;
305:
306: -- Check for the API version
307: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
308: THEN
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: END IF;
311:
305:
306: -- Check for the API version
307: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
308: THEN
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: END IF;
311:
312: /* This is where the customer will plug in their own custom logic.
313: The following lines will have to be replaced with your custom code
311:
312: /* This is where the customer will plug in their own custom logic.
313: The following lines will have to be replaced with your custom code
314: determining the value of the OUT parameters. */
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: x_msg_count := 0;
317: x_msg_data := NULL;
318:
319: IF g_debug_stmt THEN
371: -- p_rate_date : date of conversion
372: --
373: -- OUT PARAMETERS
374: -- x_return_status
375: -- FND_API.G_RET_STS_SUCCESS if API succeeds
376: -- FND_API.G_RET_STS_ERROR if API fails
377: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
378: --
379: -- IN OUT PARAMETERS
372: --
373: -- OUT PARAMETERS
374: -- x_return_status
375: -- FND_API.G_RET_STS_SUCCESS if API succeeds
376: -- FND_API.G_RET_STS_ERROR if API fails
377: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
378: --
379: -- IN OUT PARAMETERS
380: -- x_unit_price
373: -- OUT PARAMETERS
374: -- x_return_status
375: -- FND_API.G_RET_STS_SUCCESS if API succeeds
376: -- FND_API.G_RET_STS_ERROR if API fails
377: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
378: --
379: -- IN OUT PARAMETERS
380: -- x_unit_price
381: -- custom price if the custom code is in place
409: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
410: l_progress VARCHAR2(3) := '000';
411: BEGIN
412: -- Check for the API version
413: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: END IF;
416:
417: /* This is where the customer will plug in their own custom logic.
410: l_progress VARCHAR2(3) := '000';
411: BEGIN
412: -- Check for the API version
413: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: END IF;
416:
417: /* This is where the customer will plug in their own custom logic.
418: The following lines will have to be replaced with your custom code
417: /* This is where the customer will plug in their own custom logic.
418: The following lines will have to be replaced with your custom code
419: determining the value of the OUT parameters. Assign the value of
420: the custom price to the IN OUT parameter x_unit_price*/
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422:
423: END GET_CUST_INTERNAL_REQ_PRICE;
424:
425: -- < Bug 7430760 END>