eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MISC_TRANS_PUB dependencies on OKL_API

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

21: l_api_version NUMBER := 1.0;
22: l_api_name VARCHAR2(30) := 'CREATE_MISC_DSTR_LINE';
23:
24: l_tclv_rec tclv_rec_type := p_tclv_rec;
25: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26:
27: BEGIN
28:
29: SAVEPOINT CREATE_MISC_DSTR_LINE;

Line 66: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

62: END IF;
63: -- End of wraper code generated automatically by Debug code generator for OKL_MISC_TRANS_PVT.CREATE_MISC_DSTR_LINE
64:
65:
66: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;

Line 68: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

64:
65:
66: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;
71:
72: l_tclv_rec := x_tclv_rec;

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

80: WHEN FND_API.G_EXC_ERROR THEN
81: ROLLBACK TO CREATE_MISC_DSTR_LINE;
82: x_return_status := FND_API.G_RET_STS_ERROR;
83:
84: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
85: ,p_count => x_msg_count
86: ,p_data => x_msg_data);
87:
88: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

87:
88: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
89: ROLLBACK TO CREATE_MISC_DSTR_LINE;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
92: ,p_count => x_msg_count
93: ,p_data => x_msg_data);
94:
95: WHEN OTHERS THEN

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

94:
95: WHEN OTHERS THEN
96:
97: FND_MSG_PUB.ADD_EXC_MSG('OKL_MISC_TRANS_PUB','CREATE_MISC_DSTR_LINE');
98: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
99: ,p_count => x_msg_count
100: ,p_data => x_msg_data);
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102:

Line 157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

153: p_jrnl_line_tbl => l_jrnl_line_tbl,
154: x_jrnl_hdr_rec => lx_jrnl_hdr_rec);
155:
156: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
158: ELSIF lx_return_status = G_RET_STS_ERROR THEN
159: RAISE OKL_API.G_EXCEPTION_ERROR;
160: END IF;
161: -- return record

Line 159: RAISE OKL_API.G_EXCEPTION_ERROR;

155:
156: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
158: ELSIF lx_return_status = G_RET_STS_ERROR THEN
159: RAISE OKL_API.G_EXCEPTION_ERROR;
160: END IF;
161: -- return record
162: x_jrnl_hdr_rec := lx_jrnl_hdr_rec;
163: -- return the status

Line 168: WHEN OKL_API.G_EXCEPTION_ERROR THEN

164: x_return_status := lx_return_status;
165:
166: EXCEPTION
167:
168: WHEN OKL_API.G_EXCEPTION_ERROR THEN
169: fnd_msg_pub.count_and_get(p_count => x_msg_count,
170: p_data => x_msg_data);
171: x_return_status := G_RET_STS_ERROR;
172:

Line 173: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

169: fnd_msg_pub.count_and_get(p_count => x_msg_count,
170: p_data => x_msg_data);
171: x_return_status := G_RET_STS_ERROR;
172:
173: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
174: fnd_msg_pub.count_and_get(p_count => x_msg_count,
175: p_data => x_msg_data);
176: x_return_status := G_RET_STS_UNEXP_ERROR;
177:

Line 179: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

175: p_data => x_msg_data);
176: x_return_status := G_RET_STS_UNEXP_ERROR;
177:
178: WHEN OTHERS THEN
179: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
180: p_msg_name => G_DB_ERROR,
181: p_token1 => G_PROG_NAME_TOKEN,
182: p_token1_value => l_prog_name,
183: p_token2 => G_SQLCODE_TOKEN,

Line 238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

234: p_jrnl_hdr_rec => l_jrnl_hdr_rec,
235: p_jrnl_line_tbl => l_jrnl_line_tbl);
236:
237: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
239: ELSIF lx_return_status = G_RET_STS_ERROR THEN
240: RAISE OKL_API.G_EXCEPTION_ERROR;
241: END IF;
242:

Line 240: RAISE OKL_API.G_EXCEPTION_ERROR;

236:
237: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
239: ELSIF lx_return_status = G_RET_STS_ERROR THEN
240: RAISE OKL_API.G_EXCEPTION_ERROR;
241: END IF;
242:
243: -- return the status
244: x_return_status := lx_return_status;

Line 248: WHEN OKL_API.G_EXCEPTION_ERROR THEN

244: x_return_status := lx_return_status;
245:
246: EXCEPTION
247:
248: WHEN OKL_API.G_EXCEPTION_ERROR THEN
249: fnd_msg_pub.count_and_get(p_count => x_msg_count,
250: p_data => x_msg_data);
251: x_return_status := G_RET_STS_ERROR;
252:

Line 253: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

249: fnd_msg_pub.count_and_get(p_count => x_msg_count,
250: p_data => x_msg_data);
251: x_return_status := G_RET_STS_ERROR;
252:
253: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
254: fnd_msg_pub.count_and_get(p_count => x_msg_count,
255: p_data => x_msg_data);
256: x_return_status := G_RET_STS_UNEXP_ERROR;
257:

Line 259: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

255: p_data => x_msg_data);
256: x_return_status := G_RET_STS_UNEXP_ERROR;
257:
258: WHEN OTHERS THEN
259: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
260: p_msg_name => G_DB_ERROR,
261: p_token1 => G_PROG_NAME_TOKEN,
262: p_token1_value => l_prog_name,
263: p_token2 => G_SQLCODE_TOKEN,