DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on FND_API

Line 281: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

277: , p_doc_id => l_doc_id
278: , x_return_status => l_return_status
279: , x_approved_date => l_approved_date
280: );
281: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
282: RAISE FND_API.g_exc_unexpected_error;
283: END IF;
284: --< Bug 3554754 End >
285:

Line 282: RAISE FND_API.g_exc_unexpected_error;

278: , x_return_status => l_return_status
279: , x_approved_date => l_approved_date
280: );
281: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
282: RAISE FND_API.g_exc_unexpected_error;
283: END IF;
284: --< Bug 3554754 End >
285:
286: /* If the doc does not have an approved date, then it's new */

Line 1297: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1293: , x_unreservable_flag => p_action_flag);
1294:
1295: l_progress := '030';
1296:
1297: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1300: RAISE FND_API.G_EXC_ERROR;
1301: END IF;

Line 1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1294:
1295: l_progress := '030';
1296:
1297: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1300: RAISE FND_API.G_EXC_ERROR;
1301: END IF;
1302:

Line 1299: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

1295: l_progress := '030';
1296:
1297: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1300: RAISE FND_API.G_EXC_ERROR;
1301: END IF;
1302:
1303: l_progress := '040';

Line 1300: RAISE FND_API.G_EXC_ERROR;

1296:
1297: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1300: RAISE FND_API.G_EXC_ERROR;
1301: END IF;
1302:
1303: l_progress := '040';
1304:

Line 1323: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1319: , x_reservable_flag => p_action_flag);
1320:
1321: l_progress := '050';
1322:
1323: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;

Line 1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1320:
1321: l_progress := '050';
1322:
1323: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328:

Line 1325: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

1321: l_progress := '050';
1322:
1323: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328:
1329: l_progress := '060';

Line 1326: RAISE FND_API.G_EXC_ERROR;

1322:
1323: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328:
1329: l_progress := '060';
1330:

Line 2015: -- FND_API.g_ret_sts_success - on success

2011: -- 'PO', 'PA', or 'RELEASE'.
2012: --p_doc_id
2013: --OUT:
2014: --x_return_status
2015: -- FND_API.g_ret_sts_success - on success
2016: -- FND_API.g_ret_sts_error - when p_doc_type is not 'PO', 'PA', or 'RELEASE'.
2017: -- FND_API.g_ret_sts_unexp_error - unexpected error
2018: --x_approved_date
2019: --End of Comments

Line 2016: -- FND_API.g_ret_sts_error - when p_doc_type is not 'PO', 'PA', or 'RELEASE'.

2012: --p_doc_id
2013: --OUT:
2014: --x_return_status
2015: -- FND_API.g_ret_sts_success - on success
2016: -- FND_API.g_ret_sts_error - when p_doc_type is not 'PO', 'PA', or 'RELEASE'.
2017: -- FND_API.g_ret_sts_unexp_error - unexpected error
2018: --x_approved_date
2019: --End of Comments
2020: --------------------------------------------------------------------------------

Line 2017: -- FND_API.g_ret_sts_unexp_error - unexpected error

2013: --OUT:
2014: --x_return_status
2015: -- FND_API.g_ret_sts_success - on success
2016: -- FND_API.g_ret_sts_error - when p_doc_type is not 'PO', 'PA', or 'RELEASE'.
2017: -- FND_API.g_ret_sts_unexp_error - unexpected error
2018: --x_approved_date
2019: --End of Comments
2020: --------------------------------------------------------------------------------
2021: PROCEDURE get_approved_date

Line 2029: x_return_status := FND_API.g_ret_sts_success;

2025: , x_approved_date OUT NOCOPY DATE
2026: )
2027: IS
2028: BEGIN
2029: x_return_status := FND_API.g_ret_sts_success;
2030:
2031: -- Validate the input parameters
2032: IF (p_doc_type NOT IN ('PO','PA','RELEASE')) OR
2033: (p_doc_id IS NULL)

Line 2035: RAISE FND_API.g_exc_error;

2031: -- Validate the input parameters
2032: IF (p_doc_type NOT IN ('PO','PA','RELEASE')) OR
2033: (p_doc_id IS NULL)
2034: THEN
2035: RAISE FND_API.g_exc_error;
2036: END IF;
2037:
2038: IF (p_doc_type = 'RELEASE') THEN
2039: SELECT approved_date

Line 2055: WHEN FND_API.g_exc_error THEN

2051: PO_DEBUG.debug_var(g_module_prefix||'get_approved_date','END','x_approved_date',x_approved_date);
2052: END IF;
2053:
2054: EXCEPTION
2055: WHEN FND_API.g_exc_error THEN
2056: x_return_status := FND_API.g_ret_sts_error;
2057: IF g_debug_stmt THEN
2058: PO_DEBUG.debug_stmt(g_module_prefix||'get_approved_date','ERROR','Invalid input params');
2059: END IF;

Line 2056: x_return_status := FND_API.g_ret_sts_error;

2052: END IF;
2053:
2054: EXCEPTION
2055: WHEN FND_API.g_exc_error THEN
2056: x_return_status := FND_API.g_ret_sts_error;
2057: IF g_debug_stmt THEN
2058: PO_DEBUG.debug_stmt(g_module_prefix||'get_approved_date','ERROR','Invalid input params');
2059: END IF;
2060: WHEN OTHERS THEN

Line 2061: x_return_status := FND_API.g_ret_sts_unexp_error;

2057: IF g_debug_stmt THEN
2058: PO_DEBUG.debug_stmt(g_module_prefix||'get_approved_date','ERROR','Invalid input params');
2059: END IF;
2060: WHEN OTHERS THEN
2061: x_return_status := FND_API.g_ret_sts_unexp_error;
2062: PO_DEBUG.handle_unexp_error( p_pkg_name => g_pkg_name
2063: , p_proc_name => 'get_approved_date'
2064: );
2065: END get_approved_date;