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.IEX_REPOSSESS_PVT dependencies on OKL_API

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

20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2) AS
23:
24: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
25: l_api_version CONSTANT NUMBER := 1;
26: l_api_name CONSTANT VARCHAR2(30) := 'create_repossess_request';
27:
28: G_REPOS_REQUEST_EXCEPTION EXCEPTION;

Line 70: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

66: and irp.repossession_id = cp_repossession_id
67: and alv.dnz_chr_id = irp.contract_id;
68:
69: BEGIN
70: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
71: G_PKG_NAME,
72: p_init_msg_list,
73: l_api_version,
74: p_api_version,

Line 78: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

74: p_api_version,
75: '_PVT',
76: l_return_status);
77:
78: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
79: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
80: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_ERROR;
82: END IF;

Line 79: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

75: '_PVT',
76: l_return_status);
77:
78: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
79: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
80: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_ERROR;
82: END IF;
83:

Line 80: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

76: l_return_status);
77:
78: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
79: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
80: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_ERROR;
82: END IF;
83:
84: -- Processing starts

Line 81: RAISE OKL_API.G_EXCEPTION_ERROR;

77:
78: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
79: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
80: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_ERROR;
82: END IF;
83:
84: -- Processing starts
85: lp_repv_rec := p_repv_rec;

Line 117: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN

113: IEX_DEBUG_PUB.logMessage('EEEEE === '||l_return_status);
114:
115:
116: /*
117: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN
118: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
119: p_msg_name => G_RET_REQ_ERROR);
120: RAISE G_REPOS_REQUEST_EXCEPTION;
121: END IF;

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

114:
115:
116: /*
117: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN
118: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
119: p_msg_name => G_RET_REQ_ERROR);
120: RAISE G_REPOS_REQUEST_EXCEPTION;
121: END IF;
122: */

Line 142: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

138: ,x_repv_rec => lx_repv_rec);
139:
140: x_repv_rec := lx_repv_rec;
141:
142: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
143: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
145: RAISE okl_api.G_EXCEPTION_ERROR;
146: END IF;

Line 143: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

139:
140: x_repv_rec := lx_repv_rec;
141:
142: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
143: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
145: RAISE okl_api.G_EXCEPTION_ERROR;
146: END IF;
147:

Line 144: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

140: x_repv_rec := lx_repv_rec;
141:
142: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
143: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
145: RAISE okl_api.G_EXCEPTION_ERROR;
146: END IF;
147:
148: -- Processing ends

Line 145: RAISE okl_api.G_EXCEPTION_ERROR;

141:
142: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
143: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
145: RAISE okl_api.G_EXCEPTION_ERROR;
146: END IF;
147:
148: -- Processing ends
149:

Line 151: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

147:
148: -- Processing ends
149:
150: x_return_status := l_return_status;
151: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
152: EXCEPTION
153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
154: x_return_status := OKL_API.HANDLE_EXCEPTIONS
155: (

Line 153: WHEN OKL_API.G_EXCEPTION_ERROR THEN

149:
150: x_return_status := l_return_status;
151: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
152: EXCEPTION
153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
154: x_return_status := OKL_API.HANDLE_EXCEPTIONS
155: (
156: l_api_name,
157: G_PKG_NAME,

Line 154: x_return_status := OKL_API.HANDLE_EXCEPTIONS

150: x_return_status := l_return_status;
151: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
152: EXCEPTION
153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
154: x_return_status := OKL_API.HANDLE_EXCEPTIONS
155: (
156: l_api_name,
157: G_PKG_NAME,
158: 'OKL_API.G_RET_STS_ERROR',

Line 158: 'OKL_API.G_RET_STS_ERROR',

154: x_return_status := OKL_API.HANDLE_EXCEPTIONS
155: (
156: l_api_name,
157: G_PKG_NAME,
158: 'OKL_API.G_RET_STS_ERROR',
159: x_msg_count,
160: x_msg_data,
161: '_PVT'
162: );

Line 163: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

159: x_msg_count,
160: x_msg_data,
161: '_PVT'
162: );
163: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
164: x_return_status := OKL_API.HANDLE_EXCEPTIONS
165: (
166: l_api_name,
167: G_PKG_NAME,

Line 164: x_return_status := OKL_API.HANDLE_EXCEPTIONS

160: x_msg_data,
161: '_PVT'
162: );
163: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
164: x_return_status := OKL_API.HANDLE_EXCEPTIONS
165: (
166: l_api_name,
167: G_PKG_NAME,
168: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 168: 'OKL_API.G_RET_STS_UNEXP_ERROR',

164: x_return_status := OKL_API.HANDLE_EXCEPTIONS
165: (
166: l_api_name,
167: G_PKG_NAME,
168: 'OKL_API.G_RET_STS_UNEXP_ERROR',
169: x_msg_count,
170: x_msg_data,
171: '_PVT'
172: );

Line 174: x_return_status := OKL_API.HANDLE_EXCEPTIONS

170: x_msg_data,
171: '_PVT'
172: );
173: WHEN OTHERS THEN
174: x_return_status := OKL_API.HANDLE_EXCEPTIONS
175: (
176: l_api_name,
177: G_PKG_NAME,
178: 'OTHERS',

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

196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2) IS
199:
200: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
201: l_api_version CONSTANT NUMBER := 1;
202: l_api_name CONSTANT VARCHAR2(30) := 'create_repossess_request';
203:
204: lp_repv_tbl repv_tbl_type;

Line 212: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

208: lx_repv_rec repv_rec_type;
209:
210: i NUMBER := 0;
211: BEGIN
212: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
213: G_PKG_NAME,
214: p_init_msg_list,
215: l_api_version,
216: p_api_version,

Line 220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

216: p_api_version,
217: '_PVT',
218: l_return_status);
219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;

Line 221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

217: '_PVT',
218: l_return_status);
219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:

Line 222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

218: l_return_status);
219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:
226: -- Processing starts

Line 223: RAISE OKL_API.G_EXCEPTION_ERROR;

219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:
226: -- Processing starts
227: lp_repv_tbl := p_repv_tbl;

Line 246: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN

242: x_return_status => l_return_status,
243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data);
245:
246: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN
247: exit;
248: END IF;
249:
250: i := lp_repv_tbl.next(i);

Line 254: IF (l_return_status = okl_api.G_RET_STS_SUCCESS) THEN

250: i := lp_repv_tbl.next(i);
251: exit when i IS NULL;
252: end loop;
253:
254: IF (l_return_status = okl_api.G_RET_STS_SUCCESS) THEN
255: commit;
256: END IF;
257: END IF;
258:

Line 262: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

258:
259: -- Processing ends
260:
261: x_return_status := l_return_status;
262: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
263: EXCEPTION
264: WHEN OKL_API.G_EXCEPTION_ERROR THEN
265: x_return_status := OKL_API.HANDLE_EXCEPTIONS
266: (

Line 264: WHEN OKL_API.G_EXCEPTION_ERROR THEN

260:
261: x_return_status := l_return_status;
262: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
263: EXCEPTION
264: WHEN OKL_API.G_EXCEPTION_ERROR THEN
265: x_return_status := OKL_API.HANDLE_EXCEPTIONS
266: (
267: l_api_name,
268: G_PKG_NAME,

Line 265: x_return_status := OKL_API.HANDLE_EXCEPTIONS

261: x_return_status := l_return_status;
262: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
263: EXCEPTION
264: WHEN OKL_API.G_EXCEPTION_ERROR THEN
265: x_return_status := OKL_API.HANDLE_EXCEPTIONS
266: (
267: l_api_name,
268: G_PKG_NAME,
269: 'OKL_API.G_RET_STS_ERROR',

Line 269: 'OKL_API.G_RET_STS_ERROR',

265: x_return_status := OKL_API.HANDLE_EXCEPTIONS
266: (
267: l_api_name,
268: G_PKG_NAME,
269: 'OKL_API.G_RET_STS_ERROR',
270: x_msg_count,
271: x_msg_data,
272: '_PVT'
273: );

Line 274: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

270: x_msg_count,
271: x_msg_data,
272: '_PVT'
273: );
274: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
275: x_return_status := OKL_API.HANDLE_EXCEPTIONS
276: (
277: l_api_name,
278: G_PKG_NAME,

Line 275: x_return_status := OKL_API.HANDLE_EXCEPTIONS

271: x_msg_data,
272: '_PVT'
273: );
274: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
275: x_return_status := OKL_API.HANDLE_EXCEPTIONS
276: (
277: l_api_name,
278: G_PKG_NAME,
279: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 279: 'OKL_API.G_RET_STS_UNEXP_ERROR',

275: x_return_status := OKL_API.HANDLE_EXCEPTIONS
276: (
277: l_api_name,
278: G_PKG_NAME,
279: 'OKL_API.G_RET_STS_UNEXP_ERROR',
280: x_msg_count,
281: x_msg_data,
282: '_PVT'
283: );

Line 285: x_return_status := OKL_API.HANDLE_EXCEPTIONS

281: x_msg_data,
282: '_PVT'
283: );
284: WHEN OTHERS THEN
285: x_return_status := OKL_API.HANDLE_EXCEPTIONS
286: (
287: l_api_name,
288: G_PKG_NAME,
289: 'OTHERS',