APPS.OKL_TRANS_ACCT_OPT_PUB dependencies on OKL_API

Line 18: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

14:
15:
16: l_api_version CONSTANT NUMBER := 1.0;
17: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_ACCT_OPT';
18: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: l_taov_rec taov_rec_type := p_taov_rec;
20:
21:
22:

Line 46: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

42: p_taov_rec => l_taov_rec,
43: x_taov_rec => x_taov_rec);
44:
45:
46: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
47:
48: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
49:
50: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 48: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 50: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

46: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
47:
48: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
49:
50: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
51:
52: RAISE OKL_API.G_EXCEPTION_ERROR;
53:
54: END IF;

Line 52: RAISE OKL_API.G_EXCEPTION_ERROR;

48: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
49:
50: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
51:
52: RAISE OKL_API.G_EXCEPTION_ERROR;
53:
54: END IF;
55:
56:

Line 66: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

62: WHEN FND_API.G_EXC_ERROR THEN
63: ROLLBACK TO GET_TRX_ACCT_OPT;
64: x_return_status := FND_API.G_RET_STS_ERROR;
65:
66: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69:
70: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 73: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

69:
70: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
71: ROLLBACK TO GET_TRX_ACCT_OPT;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76:
77: WHEN OTHERS THEN

Line 80: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

76:
77: WHEN OTHERS THEN
78:
79: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_ACCT_OPT_PUB','GET_TRX_ACCT_OPT');
80: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
81: ,p_count => x_msg_count
82: ,p_data => x_msg_data);
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84:

Line 104: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

100:
101:
102: l_api_version CONSTANT NUMBER := 1.0;
103: l_api_name CONSTANT VARCHAR2(30) := 'UPDT_TRX_ACCT_OPT';
104: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
105: l_taov_rec taov_rec_type := p_taov_rec;
106:
107:
108:

Line 133: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

129: p_taov_rec => l_taov_rec,
130: x_taov_rec => x_taov_rec);
131:
132:
133: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
134:
135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

131:
132:
133: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
134:
135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
138:
139: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 137: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

133: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
134:
135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
138:
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140:
141: END IF;

Line 139: RAISE OKL_API.G_EXCEPTION_ERROR;

135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
138:
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140:
141: END IF;
142:
143:

Line 152: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO UPDT_TRX_ACCT_OPT;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
153: ,p_count => x_msg_count
154: ,p_data => x_msg_data);
155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 159: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO UPDT_TRX_ACCT_OPT;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162:
163: WHEN OTHERS THEN

Line 166: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

162:
163: WHEN OTHERS THEN
164:
165: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRANS_ACCT_OPT_PUB','UPDT_TRX_ACCT_OPT');
166: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: