DBA Data[Home] [Help]

APPS.OKL_FULFILLMENT_PUB dependencies on OKL_API

Line 16: p_commit IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

12: p_email IN VARCHAR2,
13: p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
14: p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
15: p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
16: p_commit IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
17: x_request_id OUT NOCOPY NUMBER,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 57: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

53: x_return_status => l_return_status,
54: x_msg_count => l_msg_count,
55: x_msg_data => l_msg_data);
56:
57: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
58: RAISE OKL_API.G_EXCEPTION_ERROR;
59: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
60: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
61: END IF;

Line 58: RAISE OKL_API.G_EXCEPTION_ERROR;

54: x_msg_count => l_msg_count,
55: x_msg_data => l_msg_data);
56:
57: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
58: RAISE OKL_API.G_EXCEPTION_ERROR;
59: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
60: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
61: END IF;
62:

Line 59: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

55: x_msg_data => l_msg_data);
56:
57: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
58: RAISE OKL_API.G_EXCEPTION_ERROR;
59: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
60: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
61: END IF;
62:
63: ------------ End Call to Private Process API--------------

Line 60: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

56:
57: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
58: RAISE OKL_API.G_EXCEPTION_ERROR;
59: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
60: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
61: END IF;
62:
63: ------------ End Call to Private Process API--------------
64:

Line 75: WHEN OKL_API.G_EXCEPTION_ERROR THEN

71: x_return_status := l_return_status;
72:
73: EXCEPTION
74:
75: WHEN OKL_API.G_EXCEPTION_ERROR THEN
76: -- ROLLBACK TO create_fulfillment;
77: x_return_status := OKL_API.G_RET_STS_ERROR;
78: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
79: p_data => x_msg_data);

Line 77: x_return_status := OKL_API.G_RET_STS_ERROR;

73: EXCEPTION
74:
75: WHEN OKL_API.G_EXCEPTION_ERROR THEN
76: -- ROLLBACK TO create_fulfillment;
77: x_return_status := OKL_API.G_RET_STS_ERROR;
78: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
79: p_data => x_msg_data);
80:
81: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 81: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

77: x_return_status := OKL_API.G_RET_STS_ERROR;
78: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
79: p_data => x_msg_data);
80:
81: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
82: -- ROLLBACK TO create_fulfillment;
83: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
84: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
85: p_data => x_msg_data);

Line 83: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

79: p_data => x_msg_data);
80:
81: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
82: -- ROLLBACK TO create_fulfillment;
83: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
84: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
85: p_data => x_msg_data);
86:
87: WHEN OTHERS THEN

Line 89: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

85: p_data => x_msg_data);
86:
87: WHEN OTHERS THEN
88: -- ROLLBACK TO create_fulfillment;
89: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
90: FND_MSG_PUB.ADD_EXC_MSG('OKL_FULFILLMENT_PUB','create_fulfillment');
91: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
92: p_data => x_msg_data);
93: