DBA Data[Home] [Help]

APPS.OKL_INS_CLAIM_ASSET_PUB dependencies on OKL_API

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

41: px_clmv_tbl => l_clmv_tbl,
42: px_acdv_tbl => l_acdv_tbl,
43: px_acnv_tbl => l_acnv_tbl
44: );
45: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
46: x_return_status := l_return_status;
47: --return(l_return_status);
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 48: RAISE OKL_API.G_EXCEPTION_ERROR;

44: );
45: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
46: x_return_status := l_return_status;
47: --return(l_return_status);
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: x_return_status := l_return_status;
51: --return(l_return_status);
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

45: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
46: x_return_status := l_return_status;
47: --return(l_return_status);
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: x_return_status := l_return_status;
51: --return(l_return_status);
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: END IF;

Line 52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: x_return_status := l_return_status;
51: --return(l_return_status);
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: END IF;
54: ------------ End Call to Private Process API--------------
55:
56: px_clmv_tbl := l_clmv_tbl;

Line 63: WHEN OKL_API.G_EXCEPTION_ERROR THEN

59: x_return_status := l_return_status;
60:
61: --return(l_return_status);
62: EXCEPTION
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: --ROLLBACK TO create_fulfillment;
65: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);

Line 65: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

61: --return(l_return_status);
62: EXCEPTION
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: --ROLLBACK TO create_fulfillment;
65: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: --ROLLBACK TO create_fulfillment;

Line 68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

64: --ROLLBACK TO create_fulfillment;
65: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: --ROLLBACK TO create_fulfillment;
70: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
71: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
72: p_data => l_msg_data);

Line 70: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: --ROLLBACK TO create_fulfillment;
70: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
71: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
72: p_data => l_msg_data);
73: WHEN OTHERS THEN
74: --ROLLBACK TO create_fulfillment;

Line 75: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

71: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
72: p_data => l_msg_data);
73: WHEN OTHERS THEN
74: --ROLLBACK TO create_fulfillment;
75: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
76: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLAIM_ASSET_PUB','create_lease_claim');
77: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
78: p_data => l_msg_data);
79: x_return_status:=l_return_status;

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

110: x_msg_count => l_msg_count,
111: x_msg_data => l_msg_data,
112: p_lsm_id => l_lsm_id
113: );
114: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
115: x_return_status := l_return_status;
116: --return(l_return_status);
117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 117: RAISE OKL_API.G_EXCEPTION_ERROR;

113: );
114: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
115: x_return_status := l_return_status;
116: --return(l_return_status);
117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: x_return_status := l_return_status;
120: --return(l_return_status);
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

114: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
115: x_return_status := l_return_status;
116: --return(l_return_status);
117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: x_return_status := l_return_status;
120: --return(l_return_status);
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: END IF;

Line 121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: x_return_status := l_return_status;
120: --return(l_return_status);
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: END IF;
123: ------------ End Call to Private Process API--------------
124: x_return_status := l_return_status;
125: --return(l_return_status);

Line 127: WHEN OKL_API.G_EXCEPTION_ERROR THEN

123: ------------ End Call to Private Process API--------------
124: x_return_status := l_return_status;
125: --return(l_return_status);
126: EXCEPTION
127: WHEN OKL_API.G_EXCEPTION_ERROR THEN
128: --ROLLBACK TO create_fulfillment;
129: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);

Line 129: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

125: --return(l_return_status);
126: EXCEPTION
127: WHEN OKL_API.G_EXCEPTION_ERROR THEN
128: --ROLLBACK TO create_fulfillment;
129: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);
132: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
133: --ROLLBACK TO create_fulfillment;

Line 132: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

128: --ROLLBACK TO create_fulfillment;
129: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);
132: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
133: --ROLLBACK TO create_fulfillment;
134: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
136: p_data => l_msg_data);

Line 134: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);
132: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
133: --ROLLBACK TO create_fulfillment;
134: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
136: p_data => l_msg_data);
137: WHEN OTHERS THEN
138: --ROLLBACK TO create_fulfillment;

Line 139: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

135: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
136: p_data => l_msg_data);
137: WHEN OTHERS THEN
138: --ROLLBACK TO create_fulfillment;
139: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
140: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLAIM_ASSET_PUB','hold_streams');
141: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
142: p_data => l_msg_data);
143: x_return_status := l_return_status;