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_REV_LOSS_PROV_PVT dependencies on OKL_API

Line 9: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

5:
6: -- this procedure reverses specific loss provision,general loss provision or both transactions
7: PROCEDURE REVERSE_LOSS_PROVISIONS (
8: p_api_version IN NUMBER
9: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
10: ,x_msg_count OUT NOCOPY NUMBER
11: ,x_msg_data OUT NOCOPY VARCHAR2
12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,p_lprv_rec IN lprv_rec_type)

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

12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,p_lprv_rec IN lprv_rec_type)
14:
15: IS
16: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
17:
18: /* variables */
19: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_LOSS_PROVISIONS';
20: l_api_version CONSTANT NUMBER := 1.0;

Line 84: l_return_status := OKL_API.START_ACTIVITY(l_api_name

80: WHERE CONTRACT_NUMBER = p_ctr_num;
81:
82: BEGIN
83:
84: l_return_status := OKL_API.START_ACTIVITY(l_api_name
85: ,G_PKG_NAME
86: ,p_init_msg_list
87: ,l_api_version
88: ,p_api_version

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

88: ,p_api_version
89: ,'_PVT'
90: ,l_return_status);
91:
92: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
95: RAISE OKL_API.G_EXCEPTION_ERROR;
96: END IF;

Line 93: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

89: ,'_PVT'
90: ,l_return_status);
91:
92: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
95: RAISE OKL_API.G_EXCEPTION_ERROR;
96: END IF;
97:

Line 94: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

90: ,l_return_status);
91:
92: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
95: RAISE OKL_API.G_EXCEPTION_ERROR;
96: END IF;
97:
98: /* validate input record parameters */

Line 95: RAISE OKL_API.G_EXCEPTION_ERROR;

91:
92: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
95: RAISE OKL_API.G_EXCEPTION_ERROR;
96: END IF;
97:
98: /* validate input record parameters */
99: IF (p_lprv_rec.cntrct_num IS NULL) THEN

Line 100: Okl_Api.set_message(p_app_name => g_app_name,

96: END IF;
97:
98: /* validate input record parameters */
99: IF (p_lprv_rec.cntrct_num IS NULL) THEN
100: Okl_Api.set_message(p_app_name => g_app_name,
101: p_msg_name => 'OKL_REV_LPV_CNTRCT_ERROR');
102: RAISE OKL_API.G_EXCEPTION_ERROR;
103: END IF;
104:

Line 102: RAISE OKL_API.G_EXCEPTION_ERROR;

98: /* validate input record parameters */
99: IF (p_lprv_rec.cntrct_num IS NULL) THEN
100: Okl_Api.set_message(p_app_name => g_app_name,
101: p_msg_name => 'OKL_REV_LPV_CNTRCT_ERROR');
102: RAISE OKL_API.G_EXCEPTION_ERROR;
103: END IF;
104:
105: -- get the contract number
106: OPEN contract_num_csr(p_lprv_rec.cntrct_num);

Line 110: Okl_Api.set_message(p_app_name => g_app_name,

106: OPEN contract_num_csr(p_lprv_rec.cntrct_num);
107: FETCH contract_num_csr INTO l_cntrct_id;
108: IF contract_num_csr%NOTFOUND THEN
109: CLOSE contract_num_csr;
110: Okl_Api.set_message(p_app_name => g_app_name,
111: p_msg_name => 'OKL_REV_LPV_CNTRCT_NUM_ERROR');
112: RAISE OKL_API.G_EXCEPTION_ERROR;
113: END IF;
114: CLOSE contract_num_csr;

Line 112: RAISE OKL_API.G_EXCEPTION_ERROR;

108: IF contract_num_csr%NOTFOUND THEN
109: CLOSE contract_num_csr;
110: Okl_Api.set_message(p_app_name => g_app_name,
111: p_msg_name => 'OKL_REV_LPV_CNTRCT_NUM_ERROR');
112: RAISE OKL_API.G_EXCEPTION_ERROR;
113: END IF;
114: CLOSE contract_num_csr;
115:
116: /* validate input record parameters */

Line 137: Okl_Api.set_message(p_app_name => g_app_name,

133: l_tcnv_tbl(l_COUNT).transaction_date := l_reverse_trx_csr.transaction_date;
134: l_COUNT := l_COUNT+1;
135: END LOOP;
136: ELSE
137: Okl_Api.set_message(p_app_name => g_app_name,
138: p_msg_name => 'OKL_REV_LPV_TYPE_ERROR');
139: END IF;
140:
141: l_COUNT :=0;

Line 146: OR p_lprv_rec.reversal_date = OKL_API.G_MISS_DATE THEN

142:
143: /* -- Bug 6194225 and 6194204 .. Reversals should be done by the transaction
144: and cannot be the same for all loss provision transactions.
145: IF p_lprv_rec.reversal_date IS NULL
146: OR p_lprv_rec.reversal_date = OKL_API.G_MISS_DATE THEN
147: l_reversal_date := l_sysdate;
148: ELSE
149: l_reversal_date := p_lprv_rec.reversal_date;
150: END IF;

Line 177: IF p_lprv_rec.reversal_date IS NULL OR p_lprv_rec.reversal_date = OKL_API.G_MISS_DATE THEN

173: LOOP
174: l_tcnv_tbl(i).tsu_code := 'CANCELED';
175: --l_tcnv_tbl(i).canceled_date :=l_reversal_date; -- Bugs 6194225 and 6194204 .. logic below
176:
177: IF p_lprv_rec.reversal_date IS NULL OR p_lprv_rec.reversal_date = OKL_API.G_MISS_DATE THEN
178: l_reversal_date := GREATEST(TRUNC(SYSDATE), l_trx_date_tbl(i));
179: ELSE
180: l_reversal_date := GREATEST(l_trx_date_tbl(i), p_lprv_rec.reversal_date);
181: END IF;

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

212: p_source_table => l_source_table,
213: p_acct_date => l_tcnv_tbl(i).canceled_date, -- l_reversal_date,
214: p_source_id_tbl => l_source_id_tbl);
215:
216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
217: Okl_Api.set_message(p_app_name => g_app_name,
218: p_msg_name => 'OKL_AGN_REV_DIST_ERROR',
219: p_token1 => g_contract_number_token,
220: p_token1_value => p_lprv_rec.cntrct_num);

Line 217: Okl_Api.set_message(p_app_name => g_app_name,

213: p_acct_date => l_tcnv_tbl(i).canceled_date, -- l_reversal_date,
214: p_source_id_tbl => l_source_id_tbl);
215:
216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
217: Okl_Api.set_message(p_app_name => g_app_name,
218: p_msg_name => 'OKL_AGN_REV_DIST_ERROR',
219: p_token1 => g_contract_number_token,
220: p_token1_value => p_lprv_rec.cntrct_num);
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

217: Okl_Api.set_message(p_app_name => g_app_name,
218: p_msg_name => 'OKL_AGN_REV_DIST_ERROR',
219: p_token1 => g_contract_number_token,
220: p_token1_value => p_lprv_rec.cntrct_num);
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: Okl_Api.set_message(p_app_name => g_app_name,
224: p_msg_name => 'OKL_AGN_REV_DIST_ERROR',
225: p_token1 => g_contract_number_token,

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

218: p_msg_name => 'OKL_AGN_REV_DIST_ERROR',
219: p_token1 => g_contract_number_token,
220: p_token1_value => p_lprv_rec.cntrct_num);
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: Okl_Api.set_message(p_app_name => g_app_name,
224: p_msg_name => 'OKL_AGN_REV_DIST_ERROR',
225: p_token1 => g_contract_number_token,
226: p_token1_value => p_lprv_rec.cntrct_num);

Line 223: Okl_Api.set_message(p_app_name => g_app_name,

219: p_token1 => g_contract_number_token,
220: p_token1_value => p_lprv_rec.cntrct_num);
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: Okl_Api.set_message(p_app_name => g_app_name,
224: p_msg_name => 'OKL_AGN_REV_DIST_ERROR',
225: p_token1 => g_contract_number_token,
226: p_token1_value => p_lprv_rec.cntrct_num);
227: END IF;

Line 242: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

238: p_tcnv_tbl => l_tcnv_tbl,
239: x_tcnv_tbl => x_tcnv_tbl);
240:
241: -- store the highest degree of error
242: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
243: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
244: -- need to leave
245: Okl_Api.set_message(p_app_name => g_app_name,
246: p_msg_name => 'OKL_AGN_TRX_UPD_ERROR',

Line 243: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

239: x_tcnv_tbl => x_tcnv_tbl);
240:
241: -- store the highest degree of error
242: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
243: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
244: -- need to leave
245: Okl_Api.set_message(p_app_name => g_app_name,
246: p_msg_name => 'OKL_AGN_TRX_UPD_ERROR',
247: p_token1 => g_contract_number_token,

Line 245: Okl_Api.set_message(p_app_name => g_app_name,

241: -- store the highest degree of error
242: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
243: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
244: -- need to leave
245: Okl_Api.set_message(p_app_name => g_app_name,
246: p_msg_name => 'OKL_AGN_TRX_UPD_ERROR',
247: p_token1 => g_contract_number_token,
248: p_token1_value => p_lprv_rec.cntrct_num);
249: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 249: RAISE OKL_API.G_EXCEPTION_ERROR;

245: Okl_Api.set_message(p_app_name => g_app_name,
246: p_msg_name => 'OKL_AGN_TRX_UPD_ERROR',
247: p_token1 => g_contract_number_token,
248: p_token1_value => p_lprv_rec.cntrct_num);
249: RAISE OKL_API.G_EXCEPTION_ERROR;
250: ELSE
251: -- record that there was an error
252: Okl_Api.set_message(p_app_name => g_app_name,
253: p_msg_name => 'OKL_AGN_TRX_UPD_ERROR',

Line 252: Okl_Api.set_message(p_app_name => g_app_name,

248: p_token1_value => p_lprv_rec.cntrct_num);
249: RAISE OKL_API.G_EXCEPTION_ERROR;
250: ELSE
251: -- record that there was an error
252: Okl_Api.set_message(p_app_name => g_app_name,
253: p_msg_name => 'OKL_AGN_TRX_UPD_ERROR',
254: p_token1 => g_contract_number_token,
255: p_token1_value => p_lprv_rec.cntrct_num);
256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

252: Okl_Api.set_message(p_app_name => g_app_name,
253: p_msg_name => 'OKL_AGN_TRX_UPD_ERROR',
254: p_token1 => g_contract_number_token,
255: p_token1_value => p_lprv_rec.cntrct_num);
256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
257: END IF;
258: END IF;
259: END IF; -- for if l_tcnv_tbl.count > 0 condition
260:

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

268: x_msg_count => x_msg_count,
269: x_msg_data => x_msg_data,
270: p_tcnv_tbl => x_tcnv_tbl);
271:
272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;

Line 273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

269: x_msg_data => x_msg_data,
270: p_tcnv_tbl => x_tcnv_tbl);
271:
272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;
277:

Line 274: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

270: p_tcnv_tbl => x_tcnv_tbl);
271:
272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: END IF; -- for if xcnv_tbl.count > 0 condition

Line 275: RAISE OKL_API.G_EXCEPTION_ERROR;

271:
272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: END IF; -- for if xcnv_tbl.count > 0 condition
279:

Line 283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

279:
280: -- set the return status
281: x_return_status := l_return_status;
282:
283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
284:
285: EXCEPTION
286: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
287: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

Line 286: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

282:
283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
284:
285: EXCEPTION
286: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
287: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
288: ,g_pkg_name
289: ,'OKL_API.G_RET_STS_ERROR'
290: ,x_msg_count

Line 287: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
284:
285: EXCEPTION
286: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
287: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
288: ,g_pkg_name
289: ,'OKL_API.G_RET_STS_ERROR'
290: ,x_msg_count
291: ,x_msg_data

Line 289: ,'OKL_API.G_RET_STS_ERROR'

285: EXCEPTION
286: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
287: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
288: ,g_pkg_name
289: ,'OKL_API.G_RET_STS_ERROR'
290: ,x_msg_count
291: ,x_msg_data
292: ,'_PVT');
293:

Line 294: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

290: ,x_msg_count
291: ,x_msg_data
292: ,'_PVT');
293:
294: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
295: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
296: ,g_pkg_name
297: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
298: ,x_msg_count

Line 295: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

291: ,x_msg_data
292: ,'_PVT');
293:
294: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
295: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
296: ,g_pkg_name
297: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
298: ,x_msg_count
299: ,x_msg_data

Line 297: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

293:
294: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
295: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
296: ,g_pkg_name
297: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
298: ,x_msg_count
299: ,x_msg_data
300: ,'_PVT');
301:

Line 303: x_return_status := OKL_API.HANDLE_EXCEPTIONS

299: ,x_msg_data
300: ,'_PVT');
301:
302: WHEN OTHERS THEN
303: x_return_status := OKL_API.HANDLE_EXCEPTIONS
304: (l_api_name,
305: G_PKG_NAME,
306: 'OTHERS',
307: x_msg_count,

Line 316: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

312:
313: -- this procedure reverses specific loss provision,general loss provision or both transactions
314: PROCEDURE REVERSE_LOSS_PROVISIONS (
315: p_api_version IN NUMBER
316: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,x_return_status OUT NOCOPY VARCHAR2
320: ,p_lprv_tbl IN lprv_tbl_type)

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

322:
323: /* variables */
324: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_LOSS_PROVISIONS';
325: l_api_version CONSTANT NUMBER := 1.0;
326: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
327:
328: BEGIN
329:
330: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 330: l_return_status := OKL_API.START_ACTIVITY(l_api_name

326: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
327:
328: BEGIN
329:
330: l_return_status := OKL_API.START_ACTIVITY(l_api_name
331: ,G_PKG_NAME
332: ,p_init_msg_list
333: ,l_api_version
334: ,p_api_version

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

334: ,p_api_version
335: ,'_PVT'
336: ,l_return_status);
337:
338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;

Line 339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

335: ,'_PVT'
336: ,l_return_status);
337:
338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;
343:

Line 340: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

336: ,l_return_status);
337:
338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;
343:
344: -- call recrod level implementation in loop

Line 341: RAISE OKL_API.G_EXCEPTION_ERROR;

337:
338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;
343:
344: -- call recrod level implementation in loop
345: IF p_lprv_tbl.COUNT > 0 THEN

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

352: ,x_msg_count => x_msg_count
353: ,x_msg_data => x_msg_data
354: ,p_lprv_rec => p_lprv_tbl(i));
355:
356: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
359: RAISE OKL_API.G_EXCEPTION_ERROR;
360: END IF;

Line 357: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

353: ,x_msg_data => x_msg_data
354: ,p_lprv_rec => p_lprv_tbl(i));
355:
356: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
359: RAISE OKL_API.G_EXCEPTION_ERROR;
360: END IF;
361: END LOOP;

Line 358: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

354: ,p_lprv_rec => p_lprv_tbl(i));
355:
356: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
359: RAISE OKL_API.G_EXCEPTION_ERROR;
360: END IF;
361: END LOOP;
362: END IF; -- IF p_lprv_tbl.COUNT > 0 THEN

Line 359: RAISE OKL_API.G_EXCEPTION_ERROR;

355:
356: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
359: RAISE OKL_API.G_EXCEPTION_ERROR;
360: END IF;
361: END LOOP;
362: END IF; -- IF p_lprv_tbl.COUNT > 0 THEN
363: -- set the return status

Line 366: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

362: END IF; -- IF p_lprv_tbl.COUNT > 0 THEN
363: -- set the return status
364: x_return_status := l_return_status;
365:
366: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
367:
368: EXCEPTION
369: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

Line 369: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

365:
366: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
367:
368: EXCEPTION
369: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
371: ,g_pkg_name
372: ,'OKL_API.G_RET_STS_ERROR'
373: ,x_msg_count

Line 370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

366: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
367:
368: EXCEPTION
369: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
371: ,g_pkg_name
372: ,'OKL_API.G_RET_STS_ERROR'
373: ,x_msg_count
374: ,x_msg_data

Line 372: ,'OKL_API.G_RET_STS_ERROR'

368: EXCEPTION
369: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
371: ,g_pkg_name
372: ,'OKL_API.G_RET_STS_ERROR'
373: ,x_msg_count
374: ,x_msg_data
375: ,'_PVT');
376:

Line 377: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

373: ,x_msg_count
374: ,x_msg_data
375: ,'_PVT');
376:
377: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
378: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
379: ,g_pkg_name
380: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
381: ,x_msg_count

Line 378: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

374: ,x_msg_data
375: ,'_PVT');
376:
377: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
378: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
379: ,g_pkg_name
380: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
381: ,x_msg_count
382: ,x_msg_data

Line 380: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

376:
377: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
378: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
379: ,g_pkg_name
380: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
381: ,x_msg_count
382: ,x_msg_data
383: ,'_PVT');
384:

Line 386: x_return_status := OKL_API.HANDLE_EXCEPTIONS

382: ,x_msg_data
383: ,'_PVT');
384:
385: WHEN OTHERS THEN
386: x_return_status := OKL_API.HANDLE_EXCEPTIONS
387: (l_api_name,
388: G_PKG_NAME,
389: 'OTHERS',
390: x_msg_count,