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

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

34: WHERE id = p_id;
35:
36: l_okl_agnv_pk okl_agnv_pk_csr%ROWTYPE;
37: l_agnv_rec agnv_rec_type;
38: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
39: BEGIN
40: x_no_data_found := TRUE;
41:
42: -- Get current database values

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

68: EXCEPTION
69: WHEN OTHERS THEN
70:
71: -- store SQL error message on message stack
72: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
73: p_msg_name => G_UNEXPECTED_ERROR,
74: p_token1 => G_SQLCODE_TOKEN,
75: p_token1_value => sqlcode,
76: p_token2 => G_SQLERRM_TOKEN,

Line 79: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

75: p_token1_value => sqlcode,
76: p_token2 => G_SQLERRM_TOKEN,
77: p_token2_value => sqlerrm);
78: -- notify UNEXPECTED error for calling API.
79: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
80:
81: IF (okl_agnv_pk_csr%ISOPEN) THEN
82: CLOSE okl_agnv_pk_csr;
83: END IF;

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

180: l_api_version CONSTANT NUMBER := 1;
181: l_api_name CONSTANT VARCHAR2(30) := 'create_accrual_rules';
182: l_no_data_found BOOLEAN := TRUE;
183: l_valid BOOLEAN := TRUE;
184: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
185: l_agnv_rec agnv_rec_type;
186: l_sysdate DATE := to_date(SYSDATE, 'DD-MM-RRRR');
187: l_line_number NUMBER := 1;
188: l_tot_version NUMBER :=1 ;

Line 202: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

198: WHERE ORG_ID = p_orgID;
199: BEGIN
200: l_agnv_rec := p_agnv_rec;
201:
202: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
203: p_pkg_name => G_PKG_NAME,
204: p_init_msg_list => p_init_msg_list,
205: l_api_version => l_api_version,
206: p_api_version => p_api_version,

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

205: l_api_version => l_api_version,
206: p_api_version => p_api_version,
207: p_api_type => '_PVT',
208: x_return_status => l_return_status);
209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_ERROR;
213: END IF;

Line 210: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

206: p_api_version => p_api_version,
207: p_api_type => '_PVT',
208: x_return_status => l_return_status);
209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_ERROR;
213: END IF;
214:

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

207: p_api_type => '_PVT',
208: x_return_status => l_return_status);
209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_ERROR;
213: END IF;
214:
215: /* validate aro_code */

Line 212: RAISE OKL_API.G_EXCEPTION_ERROR;

208: x_return_status => l_return_status);
209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_ERROR;
213: END IF;
214:
215: /* validate aro_code */
216: IF (l_agnv_rec.aro_code IS NULL OR l_agnv_rec.aro_code = G_MISS_CHAR) THEN

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

213: END IF;
214:
215: /* validate aro_code */
216: IF (l_agnv_rec.aro_code IS NULL OR l_agnv_rec.aro_code = G_MISS_CHAR) THEN
217: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
218: p_msg_name => 'OKL_AGN_ARO_CODE_ERROR');
219: RAISE OKL_API.G_EXCEPTION_ERROR;
220: END IF;
221:

Line 219: RAISE OKL_API.G_EXCEPTION_ERROR;

215: /* validate aro_code */
216: IF (l_agnv_rec.aro_code IS NULL OR l_agnv_rec.aro_code = G_MISS_CHAR) THEN
217: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
218: p_msg_name => 'OKL_AGN_ARO_CODE_ERROR');
219: RAISE OKL_API.G_EXCEPTION_ERROR;
220: END IF;
221:
222: /* validate on acro_code */
223: IF (l_agnv_rec.acro_code IS NULL OR l_agnv_rec.acro_code = G_MISS_CHAR) THEN

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

220: END IF;
221:
222: /* validate on acro_code */
223: IF (l_agnv_rec.acro_code IS NULL OR l_agnv_rec.acro_code = G_MISS_CHAR) THEN
224: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
225: p_msg_name => 'OKL_AGN_ACRO_CODE_ERROR');
226: RAISE OKL_API.G_EXCEPTION_ERROR;
227: END IF;
228:

Line 226: RAISE OKL_API.G_EXCEPTION_ERROR;

222: /* validate on acro_code */
223: IF (l_agnv_rec.acro_code IS NULL OR l_agnv_rec.acro_code = G_MISS_CHAR) THEN
224: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
225: p_msg_name => 'OKL_AGN_ACRO_CODE_ERROR');
226: RAISE OKL_API.G_EXCEPTION_ERROR;
227: END IF;
228:
229: /* validate on right operand literal */
230: IF (l_agnv_rec.right_operand_literal IS NULL OR l_agnv_rec.right_operand_literal = G_MISS_CHAR) THEN

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

227: END IF;
228:
229: /* validate on right operand literal */
230: IF (l_agnv_rec.right_operand_literal IS NULL OR l_agnv_rec.right_operand_literal = G_MISS_CHAR) THEN
231: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
232: p_msg_name => 'OKL_RIGHT_OPD_LITERAL_ERROR');
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:

Line 233: RAISE OKL_API.G_EXCEPTION_ERROR;

229: /* validate on right operand literal */
230: IF (l_agnv_rec.right_operand_literal IS NULL OR l_agnv_rec.right_operand_literal = G_MISS_CHAR) THEN
231: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
232: p_msg_name => 'OKL_RIGHT_OPD_LITERAL_ERROR');
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:
236: /* Assign Start Date for the record */
237: l_agnv_rec.from_date := l_sysdate;

Line 268: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

264: x_msg_data => x_msg_data,
265: p_agnv_rec => l_agnv_rec,
266: x_agnv_rec => x_agnv_rec);
267:
268: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
269: RAISE OKL_API.G_EXCEPTION_ERROR;
270: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: END IF;

Line 269: RAISE OKL_API.G_EXCEPTION_ERROR;

265: p_agnv_rec => l_agnv_rec,
266: x_agnv_rec => x_agnv_rec);
267:
268: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
269: RAISE OKL_API.G_EXCEPTION_ERROR;
270: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: END IF;
273:

Line 270: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

266: x_agnv_rec => x_agnv_rec);
267:
268: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
269: RAISE OKL_API.G_EXCEPTION_ERROR;
270: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: END IF;
273:
274: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 274: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

270: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: END IF;
273:
274: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
275: x_msg_data => x_msg_data);
276: x_return_status := l_return_status;
277: EXCEPTION
278: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 278: WHEN OKL_API.G_EXCEPTION_ERROR THEN

274: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
275: x_msg_data => x_msg_data);
276: x_return_status := l_return_status;
277: EXCEPTION
278: WHEN OKL_API.G_EXCEPTION_ERROR THEN
279: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
280: p_pkg_name => G_PKG_NAME,
281: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
282: x_msg_count => x_msg_count,

Line 279: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

275: x_msg_data => x_msg_data);
276: x_return_status := l_return_status;
277: EXCEPTION
278: WHEN OKL_API.G_EXCEPTION_ERROR THEN
279: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
280: p_pkg_name => G_PKG_NAME,
281: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
282: x_msg_count => x_msg_count,
283: x_msg_data => x_msg_data,

Line 281: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

277: EXCEPTION
278: WHEN OKL_API.G_EXCEPTION_ERROR THEN
279: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
280: p_pkg_name => G_PKG_NAME,
281: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
282: x_msg_count => x_msg_count,
283: x_msg_data => x_msg_data,
284: p_api_type => '_PVT');
285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

281: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
282: x_msg_count => x_msg_count,
283: x_msg_data => x_msg_data,
284: p_api_type => '_PVT');
285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
286: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
287: p_pkg_name => G_PKG_NAME,
288: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
289: x_msg_count => x_msg_count,

Line 286: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

282: x_msg_count => x_msg_count,
283: x_msg_data => x_msg_data,
284: p_api_type => '_PVT');
285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
286: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
287: p_pkg_name => G_PKG_NAME,
288: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
289: x_msg_count => x_msg_count,
290: x_msg_data => x_msg_data,

Line 288: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

284: p_api_type => '_PVT');
285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
286: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
287: p_pkg_name => G_PKG_NAME,
288: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
289: x_msg_count => x_msg_count,
290: x_msg_data => x_msg_data,
291: p_api_type => '_PVT');
292: WHEN OTHERS THEN

Line 293: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

289: x_msg_count => x_msg_count,
290: x_msg_data => x_msg_data,
291: p_api_type => '_PVT');
292: WHEN OTHERS THEN
293: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
294: p_pkg_name => G_PKG_NAME,
295: p_exc_name => 'OTHERS',
296: x_msg_count => x_msg_count,
297: x_msg_data => x_msg_data,

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

319: l_db_agnv_rec agnv_rec_type; /* database copy */
320: l_upd_agnv_rec agnv_rec_type; /* input copy */
321: l_agnv_rec agnv_rec_type := p_agnv_rec; /* latest with the retained changes */
322: l_tmp_agnv_rec agnv_rec_type; /* for any other purposes */
323: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
324: l_action VARCHAR2(1);
325: l_new_version VARCHAR2(100);
326: l_attrib_tbl okl_accounting_util.overlap_attrib_tbl_type;
327: l_line_number NUMBER := 1;

Line 336: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

332: WHERE version = p_version and ORG_ID = p_orgID;
333:
334: BEGIN
335:
336: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
337: p_pkg_name => G_PKG_NAME,
338: p_init_msg_list => p_init_msg_list,
339: l_api_version => l_api_version,
340: p_api_version => p_api_version,

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

339: l_api_version => l_api_version,
340: p_api_version => p_api_version,
341: p_api_type => '_PVT',
342: x_return_status => l_return_status);
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;

Line 344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

340: p_api_version => p_api_version,
341: p_api_type => '_PVT',
342: x_return_status => l_return_status);
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;
348:

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

341: p_api_type => '_PVT',
342: x_return_status => l_return_status);
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;
348:
349:

Line 346: RAISE OKL_API.G_EXCEPTION_ERROR;

342: x_return_status => l_return_status);
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: END IF;
348:
349:
350: /* fetch old details from the database */

Line 356: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR

352: x_return_status => l_return_status,
353: x_no_data_found => l_no_data_found,
354: x_agnv_rec => l_db_agnv_rec);
355:
356: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR
357: l_no_data_found = TRUE THEN
358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: END IF;
360:

Line 358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

354: x_agnv_rec => l_db_agnv_rec);
355:
356: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR
357: l_no_data_found = TRUE THEN
358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: END IF;
360:
361:
362: /* retain the details that has been changed only */

Line 391: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

387: x_msg_data => x_msg_data,
388: p_agnv_rec => l_agnv_rec,
389: x_agnv_rec => x_agnv_rec);
390:
391: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: END IF;

Line 392: RAISE OKL_API.G_EXCEPTION_ERROR;

388: p_agnv_rec => l_agnv_rec,
389: x_agnv_rec => x_agnv_rec);
390:
391: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: END IF;
396:

Line 393: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

389: x_agnv_rec => x_agnv_rec);
390:
391: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: END IF;
396:
397: /* for new version */

Line 394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

390:
391: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: END IF;
396:
397: /* for new version */
398: /* create a temporary record with all relevant details from db and upd records */

Line 430: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

426: x_msg_data => x_msg_data,
427: p_agnv_rec => l_agnv_rec,
428: x_agnv_rec => x_agnv_rec);
429:
430: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
431: RAISE OKL_API.G_EXCEPTION_ERROR;
432: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
434: END IF;

Line 431: RAISE OKL_API.G_EXCEPTION_ERROR;

427: p_agnv_rec => l_agnv_rec,
428: x_agnv_rec => x_agnv_rec);
429:
430: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
431: RAISE OKL_API.G_EXCEPTION_ERROR;
432: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
434: END IF;
435:

Line 432: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

428: x_agnv_rec => x_agnv_rec);
429:
430: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
431: RAISE OKL_API.G_EXCEPTION_ERROR;
432: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
434: END IF;
435:
436: /* copy output to input structure to get the id */

Line 433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

429:
430: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
431: RAISE OKL_API.G_EXCEPTION_ERROR;
432: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
434: END IF;
435:
436: /* copy output to input structure to get the id */
437: l_agnv_rec := x_agnv_rec;

Line 440: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

436: /* copy output to input structure to get the id */
437: l_agnv_rec := x_agnv_rec;
438:
439:
440: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
441: x_msg_data => x_msg_data);
442: x_return_status := l_return_status;
443: EXCEPTION
444: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 444: WHEN OKL_API.G_EXCEPTION_ERROR THEN

440: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
441: x_msg_data => x_msg_data);
442: x_return_status := l_return_status;
443: EXCEPTION
444: WHEN OKL_API.G_EXCEPTION_ERROR THEN
445: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
446: p_pkg_name => G_PKG_NAME,
447: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
448: x_msg_count => x_msg_count,

Line 445: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

441: x_msg_data => x_msg_data);
442: x_return_status := l_return_status;
443: EXCEPTION
444: WHEN OKL_API.G_EXCEPTION_ERROR THEN
445: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
446: p_pkg_name => G_PKG_NAME,
447: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data,

Line 447: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

443: EXCEPTION
444: WHEN OKL_API.G_EXCEPTION_ERROR THEN
445: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
446: p_pkg_name => G_PKG_NAME,
447: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data,
450: p_api_type => '_PVT');
451: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 451: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

447: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data,
450: p_api_type => '_PVT');
451: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
452: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
453: p_pkg_name => G_PKG_NAME,
454: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
455: x_msg_count => x_msg_count,

Line 452: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data,
450: p_api_type => '_PVT');
451: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
452: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
453: p_pkg_name => G_PKG_NAME,
454: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
455: x_msg_count => x_msg_count,
456: x_msg_data => x_msg_data,

Line 454: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

450: p_api_type => '_PVT');
451: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
452: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
453: p_pkg_name => G_PKG_NAME,
454: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
455: x_msg_count => x_msg_count,
456: x_msg_data => x_msg_data,
457: p_api_type => '_PVT');
458: WHEN OTHERS THEN

Line 459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

455: x_msg_count => x_msg_count,
456: x_msg_data => x_msg_data,
457: p_api_type => '_PVT');
458: WHEN OTHERS THEN
459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
460: p_pkg_name => G_PKG_NAME,
461: p_exc_name => 'OTHERS',
462: x_msg_count => x_msg_count,
463: x_msg_data => x_msg_data,

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

528:
529: l_api_version NUMBER := 1;
530: l_api_name CONSTANT VARCHAR2(30) := 'delete_accrual_rules';
531: l_no_data_found BOOLEAN := TRUE;
532: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
533: l_dummy NUMBER;
534: l_oldversion_enddate DATE := to_date(SYSDATE, 'DD-MM-RRRR');
535: l_sysdate DATE := to_date(SYSDATE, 'DD-MM-RRRR');
536: l_db_agnv_rec agnv_rec_type; /* database copy */

Line 551: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

547: AND to_date IS NULL;
548:
549: BEGIN
550:
551: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
552: p_pkg_name => G_PKG_NAME,
553: p_init_msg_list => p_init_msg_list,
554: l_api_version => l_api_version,
555: p_api_version => p_api_version,

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

554: l_api_version => l_api_version,
555: p_api_version => p_api_version,
556: p_api_type => '_PVT',
557: x_return_status => l_return_status);
558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_ERROR;
562: END IF;

Line 559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

555: p_api_version => p_api_version,
556: p_api_type => '_PVT',
557: x_return_status => l_return_status);
558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_ERROR;
562: END IF;
563: /* check if record being deleted is the last */

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

556: p_api_type => '_PVT',
557: x_return_status => l_return_status);
558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_ERROR;
562: END IF;
563: /* check if record being deleted is the last */
564: -- OPEN check_rule_csr(p_agnv_rec.id);

Line 561: RAISE OKL_API.G_EXCEPTION_ERROR;

557: x_return_status => l_return_status);
558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_ERROR;
562: END IF;
563: /* check if record being deleted is the last */
564: -- OPEN check_rule_csr(p_agnv_rec.id);
565: --FETCH check_rule_csr INTO l_dummy;

Line 567: -- OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

563: /* check if record being deleted is the last */
564: -- OPEN check_rule_csr(p_agnv_rec.id);
565: --FETCH check_rule_csr INTO l_dummy;
566: -- IF l_dummy = 1 THEN
567: -- OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
568: -- p_msg_name => 'OKL_AGN_RULE_DEL_ERROR');
569: -- RAISE OKL_API.G_EXCEPTION_ERROR;
570: -- ELSE
571: /* update records with end date */

Line 569: -- RAISE OKL_API.G_EXCEPTION_ERROR;

565: --FETCH check_rule_csr INTO l_dummy;
566: -- IF l_dummy = 1 THEN
567: -- OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
568: -- p_msg_name => 'OKL_AGN_RULE_DEL_ERROR');
569: -- RAISE OKL_API.G_EXCEPTION_ERROR;
570: -- ELSE
571: /* update records with end date */
572: /* fetch old details from the database */
573: get_rec(p_agnv_rec => p_agnv_rec,

Line 578: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR

574: x_return_status => l_return_status,
575: x_no_data_found => l_no_data_found,
576: x_agnv_rec => l_db_agnv_rec);
577:
578: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR
579: l_no_data_found = TRUE THEN
580: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: END IF;
582:

Line 580: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

576: x_agnv_rec => l_db_agnv_rec);
577:
578: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR
579: l_no_data_found = TRUE THEN
580: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: END IF;
582:
583: /* retain the details that has been changed only */
584: get_changes_only(p_agnv_rec => p_agnv_rec,

Line 615: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN RAISE

611: x_msg_data => x_msg_data,
612: p_agnv_rec => l_agnv_rec,
613: x_agnv_rec => x_agnv_rec);
614:
615: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN RAISE
616: OKL_API.G_EXCEPTION_ERROR; ELSIF l_return_status =
617: OKL_API.G_RET_STS_UNEXP_ERROR THEN RAISE
618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=
619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 616: OKL_API.G_EXCEPTION_ERROR; ELSIF l_return_status =

612: p_agnv_rec => l_agnv_rec,
613: x_agnv_rec => x_agnv_rec);
614:
615: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN RAISE
616: OKL_API.G_EXCEPTION_ERROR; ELSIF l_return_status =
617: OKL_API.G_RET_STS_UNEXP_ERROR THEN RAISE
618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=
619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN
620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 617: OKL_API.G_RET_STS_UNEXP_ERROR THEN RAISE

613: x_agnv_rec => x_agnv_rec);
614:
615: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN RAISE
616: OKL_API.G_EXCEPTION_ERROR; ELSIF l_return_status =
617: OKL_API.G_RET_STS_UNEXP_ERROR THEN RAISE
618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=
619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN
620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME, p_exc_name =>

Line 618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=

614:
615: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN RAISE
616: OKL_API.G_EXCEPTION_ERROR; ELSIF l_return_status =
617: OKL_API.G_RET_STS_UNEXP_ERROR THEN RAISE
618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=
619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN
620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME, p_exc_name =>
622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data

Line 619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN

615: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN RAISE
616: OKL_API.G_EXCEPTION_ERROR; ELSIF l_return_status =
617: OKL_API.G_RET_STS_UNEXP_ERROR THEN RAISE
618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=
619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN
620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME, p_exc_name =>
622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data
623: => x_msg_data, p_api_type => '_PVT'); WHEN

Line 620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

616: OKL_API.G_EXCEPTION_ERROR; ELSIF l_return_status =
617: OKL_API.G_RET_STS_UNEXP_ERROR THEN RAISE
618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=
619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN
620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME, p_exc_name =>
622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data
623: => x_msg_data, p_api_type => '_PVT'); WHEN
624: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN x_return_status :=

Line 622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data

618: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; END IF; x_return_status :=
619: l_return_status; END IF; EXCEPTION WHEN OKL_API.G_EXCEPTION_ERROR THEN
620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME, p_exc_name =>
622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data
623: => x_msg_data, p_api_type => '_PVT'); WHEN
624: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN x_return_status :=
625: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name
626: => G_PKG_NAME, p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 624: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN x_return_status :=

620: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME, p_exc_name =>
622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data
623: => x_msg_data, p_api_type => '_PVT'); WHEN
624: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN x_return_status :=
625: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name
626: => G_PKG_NAME, p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
627: x_msg_count => x_msg_count, x_msg_data => x_msg_data,
628: p_api_type => '_PVT'); WHEN OTHERS THEN x_return_status :=

Line 625: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name

621: p_pkg_name => G_PKG_NAME, p_exc_name =>
622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data
623: => x_msg_data, p_api_type => '_PVT'); WHEN
624: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN x_return_status :=
625: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name
626: => G_PKG_NAME, p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
627: x_msg_count => x_msg_count, x_msg_data => x_msg_data,
628: p_api_type => '_PVT'); WHEN OTHERS THEN x_return_status :=
629: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name

Line 626: => G_PKG_NAME, p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

622: 'OKL_API.G_RET_STS_ERROR', x_msg_count => x_msg_count, x_msg_data
623: => x_msg_data, p_api_type => '_PVT'); WHEN
624: OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN x_return_status :=
625: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name
626: => G_PKG_NAME, p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
627: x_msg_count => x_msg_count, x_msg_data => x_msg_data,
628: p_api_type => '_PVT'); WHEN OTHERS THEN x_return_status :=
629: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name
630: => G_PKG_NAME, p_exc_name => 'OTHERS', x_msg_count => x_msg_count,

Line 629: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name

625: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name
626: => G_PKG_NAME, p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
627: x_msg_count => x_msg_count, x_msg_data => x_msg_data,
628: p_api_type => '_PVT'); WHEN OTHERS THEN x_return_status :=
629: OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name, p_pkg_name
630: => G_PKG_NAME, p_exc_name => 'OTHERS', x_msg_count => x_msg_count,
631: x_msg_data => x_msg_data, p_api_type => '_PVT'); END
632: delete_accrual_rules;
633: