DBA Data[Home] [Help]

APPS.PO_PA_INTEGRATION_GRP dependencies on FND_API

Line 65: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful

61: -- PO header rate date
62: --x_currency_rate
63: -- PO header currency rate
64: --x_ret_status
65: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
66: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
67: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
68: --x_message_code
69: -- The applicable error message code

Line 66: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs

62: --x_currency_rate
63: -- PO header currency rate
64: --x_ret_status
65: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
66: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
67: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
68: --x_message_code
69: -- The applicable error message code
70: --Testing:

Line 67: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs

63: -- PO header currency rate
64: --x_ret_status
65: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
66: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
67: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
68: --x_message_code
69: -- The applicable error message code
70: --Testing:
71: -- None.

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: l_rcv_close_prf VARCHAR2(1);
107:
108: BEGIN
109: -- Initialise the return status
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: -- check for API version
113: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
114: THEN

Line 113: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )

109: -- Initialise the return status
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: -- check for API version
113: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
114: THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: x_message_code := to_char(sqlcode);
117: return;

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

111:
112: -- check for API version
113: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
114: THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: x_message_code := to_char(sqlcode);
117: return;
118: END IF;
119:

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124: (p_po_number is null and p_po_header_id is null) OR
125: (p_po_line_num is null and p_po_line_id is null) OR
126: p_org_id is null
127: THEN
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: x_message_code := 'PO_SVC_INVALID_PARAMS';
130: return;
131: END IF;
132:

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144: AND org_id = p_org_id;
145:
146: Exception
147: when others then
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: x_message_code := 'PO_SVC_INVALID_PO_NUM';
150: return;
151: End;
152:

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: AND org_id = p_org_id;
167:
168: Exception
169: when others then
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: x_message_code := 'PO_SVC_INVALID_PO_LINE';
172: return;
173: End;
174:

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

175: END IF;
176:
177: -- Check if the line is a rate based line
178: IF not (PO_SERVICES_PVT.is_rate_based_line (p_po_line_id)) THEN
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: x_message_code := 'PO_SVC_INVALID_PO_LINE';
181: return;
182: END IF;
183:

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

194: WHERE po_line_id = p_po_line_id;
195:
196: Exception
197: When others then
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: x_message_code := to_char(sqlcode);
200: return;
201: End;
202:

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: l_status_rec.FROZEN_FLAG(1) = 'Y' OR
228: (l_status_rec.CLOSED_CODE(1) = 'CLOSED FOR RECEIVING' and
229: l_rcv_close_prf = 'N') )
230: THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: x_message_code := 'PO_SVC_INVALID_PO_STATUS';
233: return;
234: END IF;
235:

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: AND psp.VALIDATE_PROJECT_FLAG = 'Y';
263: END IF;
264:
265: if l_distribution_id IS NULL then
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: x_message_code := 'PO_SVC_INVALID_PROJECT_TASK';
268: return;
269: end if;
270:

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: end if;
270:
271: Exception
272: when others then
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_message_code := 'PO_SVC_INVALID_PROJECT_TASK';
275: return;
276: End;
277:

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: not PO_PRICE_DIFFERENTIALS_PVT.is_price_type_enabled(p_price_type => p_price_type,
282: p_entity_type => 'PO LINE',
283: p_entity_id => p_po_line_id)
284: THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: x_message_code := 'PO_SVC_INVALID_PRICE_TYPE';
287: return;
288: END IF;
289:

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300:
301: IF ( (l_person_id is null OR p_person_id <> l_person_id)AND
302: NOT (PO_PA_INTEGRATION_GRP.is_PO_active(p_person_id, p_effective_date,p_po_header_id,p_po_line_id)) )
303: THEN
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: x_message_code := 'PO_SVC_INVALID_PERSON';
306: return;
307: END IF;
308: END IF;

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: AND pod2.po_distribution_id = l_distribution_id;
348:
349: Exception
350: When others then
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_message_code := to_char(sqlcode);
353: return;
354: End;
355:

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

355:
356:
357: EXCEPTION
358: When Others then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: x_message_code := to_char(sqlcode);
361: END;
362:
363: -------------------------------------------------------------------------------

Line 465: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful

461: -- PO header rate date
462: --x_currency_rate
463: -- PO header currency rate
464: --x_ret_status
465: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
466: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
467: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
468: --x_message_code
469: -- The applicable error message code - none in this case

Line 466: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs

462: --x_currency_rate
463: -- PO header currency rate
464: --x_ret_status
465: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
466: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
467: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
468: --x_message_code
469: -- The applicable error message code - none in this case
470: --Testing:

Line 467: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs

463: -- PO header currency rate
464: --x_ret_status
465: -- (a) FND_API.G_RET_STS_SUCCESS - 'S' if successful
466: -- (b) FND_API.G_RET_STS_ERROR - 'E' if known error occurs
467: -- (c) FND_API.G_RET_STS_UNEXP_ERROR - 'U' if unexpected error occurs
468: --x_message_code
469: -- The applicable error message code - none in this case
470: --Testing:
471: -- None.

Line 502: x_return_status := FND_API.G_RET_STS_SUCCESS;

498: l_base_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
499:
500: BEGIN
501: -- Initialise the return status
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:
504: -- check for API version
505: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
506: THEN

Line 505: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )

501: -- Initialise the return status
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:
504: -- check for API version
505: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
506: THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: x_message_code := to_char(sqlcode);
509: END IF;

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503:
504: -- check for API version
505: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) )
506: THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: x_message_code := to_char(sqlcode);
509: END IF;
510:
511: -- Get the price for the price type and line price

Line 539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

535: AND pol.po_line_id = p_po_line_id;
536:
537: Exception
538: When others then
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: x_message_code := to_char(sqlcode);
541: return;
542: End;
543:

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

579: END IF;
580:
581: Exception
582: When others then
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: x_message_code := to_char(sqlcode);
585: return;
586: End;
587:

Line 602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

598: WHERE po_distribution_id = l_distribution_id;
599:
600: Exception
601: When others then
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: x_message_code := to_char(sqlcode);
604: return;
605: End;
606:

Line 620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

616:
617:
618: EXCEPTION
619: When Others then
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: x_message_code := to_char(sqlcode);
622: END;
623:
624: FUNCTION is_PO_active