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: --------------------------------------------------------------------------------
209: -- New customized price
210: --p_order_line_id
211: -- The line id of the order document.
212: --x_return_status
213: -- FND_API.G_RET_STS_SUCCESS if API succeeds
214: -- FND_API.G_RET_STS_ERROR if API fails
215: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
216: --Testing:
217: --
210: --p_order_line_id
211: -- The line id of the order document.
212: --x_return_status
213: -- FND_API.G_RET_STS_SUCCESS if API succeeds
214: -- FND_API.G_RET_STS_ERROR if API fails
215: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
216: --Testing:
217: --
218: --End of Comments
211: -- The line id of the order document.
212: --x_return_status
213: -- FND_API.G_RET_STS_SUCCESS if API succeeds
214: -- FND_API.G_RET_STS_ERROR if API fails
215: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
216: --Testing:
217: --
218: --End of Comments
219: -------------------------------------------------------------------------------
235: l_api_version NUMBER := 1.0;
236: l_api_name VARCHAR2(60) := 'GET_CUSTOM_PO_PRICE';
237: BEGIN
238: -- Check for the API version
239: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: END IF;
242:
243: /* This is where the customer will plug in their own custom pricing logic.
236: l_api_name VARCHAR2(60) := 'GET_CUSTOM_PO_PRICE';
237: BEGIN
238: -- Check for the API version
239: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: END IF;
242:
243: /* This is where the customer will plug in their own custom pricing logic.
244: The following lines will have to be replaced with your custom code
243: /* This is where the customer will plug in their own custom pricing logic.
244: The following lines will have to be replaced with your custom code
245: determining the value of the OUT parameters. */
246: x_new_price := NULL;
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248:
249: END GET_CUSTOM_PO_PRICE;
250:
251:
277: -- qp_ldets_v.line_index = p_line_index AND
278: -- qp_ldets_v.automatic_flag = 'Y'
279: --OUT:
280: --x_return_status
281: -- FND_API.G_RET_STS_SUCCESS if API succeeds
282: -- FND_API.G_RET_STS_ERROR if API fails
283: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
284: --Testing:
285: --
278: -- qp_ldets_v.automatic_flag = 'Y'
279: --OUT:
280: --x_return_status
281: -- FND_API.G_RET_STS_SUCCESS if API succeeds
282: -- FND_API.G_RET_STS_ERROR if API fails
283: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
284: --Testing:
285: --
286: --End of Comments
279: --OUT:
280: --x_return_status
281: -- FND_API.G_RET_STS_SUCCESS if API succeeds
282: -- FND_API.G_RET_STS_ERROR if API fails
283: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
284: --Testing:
285: --
286: --End of Comments
287: -------------------------------------------------------------------------------
306: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_index',p_line_index);
307: END IF;
308:
309: -- Check for the API version
310: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
311: THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: END IF;
314:
308:
309: -- Check for the API version
310: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
311: THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: END IF;
314:
315: /* This is where the customer will plug in their own custom logic.
316: The following lines will have to be replaced with your custom code
314:
315: /* This is where the customer will plug in their own custom logic.
316: The following lines will have to be replaced with your custom code
317: determining the value of the OUT parameters. */
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: x_msg_count := 0;
320: x_msg_data := NULL;
321:
322: IF g_debug_stmt THEN
374: -- p_rate_date : date of conversion
375: --
376: -- OUT PARAMETERS
377: -- x_return_status
378: -- FND_API.G_RET_STS_SUCCESS if API succeeds
379: -- FND_API.G_RET_STS_ERROR if API fails
380: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
381: --
382: -- IN OUT PARAMETERS
375: --
376: -- OUT PARAMETERS
377: -- x_return_status
378: -- FND_API.G_RET_STS_SUCCESS if API succeeds
379: -- FND_API.G_RET_STS_ERROR if API fails
380: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
381: --
382: -- IN OUT PARAMETERS
383: -- x_unit_price
376: -- OUT PARAMETERS
377: -- x_return_status
378: -- FND_API.G_RET_STS_SUCCESS if API succeeds
379: -- FND_API.G_RET_STS_ERROR if API fails
380: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
381: --
382: -- IN OUT PARAMETERS
383: -- x_unit_price
384: -- custom price if the custom code is in place
412: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
413: l_progress VARCHAR2(3) := '000';
414: BEGIN
415: -- Check for the API version
416: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: END IF;
419:
420: /* This is where the customer will plug in their own custom logic.
413: l_progress VARCHAR2(3) := '000';
414: BEGIN
415: -- Check for the API version
416: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: END IF;
419:
420: /* This is where the customer will plug in their own custom logic.
421: The following lines will have to be replaced with your custom code
420: /* This is where the customer will plug in their own custom logic.
421: The following lines will have to be replaced with your custom code
422: determining the value of the OUT parameters. Assign the value of
423: the custom price to the IN OUT parameter x_unit_price*/
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425:
426: END GET_CUST_INTERNAL_REQ_PRICE;
427:
428: -- < Bug 7430760 END>