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

Line 7: token_name VARCHAR2(50) := OKL_API.G_MISS_CHAR,

3: --------------------------------------------------------------------------------
4: --LOCAL DATASTRUCTURES
5: --------------------------------------------------------------------------------
6: TYPE msg_token_rec IS RECORD (
7: token_name VARCHAR2(50) := OKL_API.G_MISS_CHAR,
8: token_value VARCHAR2(300) := OKL_API.G_MISS_CHAR);
9:
10: TYPE msg_token_tbl IS TABLE OF msg_token_rec
11: INDEX BY BINARY_INTEGER;

Line 8: token_value VARCHAR2(300) := OKL_API.G_MISS_CHAR);

4: --LOCAL DATASTRUCTURES
5: --------------------------------------------------------------------------------
6: TYPE msg_token_rec IS RECORD (
7: token_name VARCHAR2(50) := OKL_API.G_MISS_CHAR,
8: token_value VARCHAR2(300) := OKL_API.G_MISS_CHAR);
9:
10: TYPE msg_token_tbl IS TABLE OF msg_token_rec
11: INDEX BY BINARY_INTEGER;
12:

Line 16: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

12:
13: -------------------------------------------------------------------------------------------------
14: -- GLOBAL MESSAGE CONSTANTS
15: -------------------------------------------------------------------------------------------------
16: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
19:
20:

Line 17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

13: -------------------------------------------------------------------------------------------------
14: -- GLOBAL MESSAGE CONSTANTS
15: -------------------------------------------------------------------------------------------------
16: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
19:
20:
21: -----------------------------------------------------------------------------

Line 229: x_return_status := OKL_API.G_RET_STS_SUCCESS;

225: lx_batch_number NUMBER;
226:
227: BEGIN
228: x_batch_number := null;
229: x_return_status := OKL_API.G_RET_STS_SUCCESS;
230:
231: x_return_status := OKL_API.START_ACTIVITY(
232: p_api_name => l_api_name,
233: p_pkg_name => g_pkg_name,

Line 231: x_return_status := OKL_API.START_ACTIVITY(

227: BEGIN
228: x_batch_number := null;
229: x_return_status := OKL_API.G_RET_STS_SUCCESS;
230:
231: x_return_status := OKL_API.START_ACTIVITY(
232: p_api_name => l_api_name,
233: p_pkg_name => g_pkg_name,
234: p_init_msg_list => p_init_msg_list,
235: l_api_version => l_api_version,

Line 241: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

237: p_api_type => g_api_type,
238: x_return_status => x_return_status);
239:
240: -- check if activity started successfully
241: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: RAISE OKL_API.G_EXCEPTION_ERROR;
245: END IF;

Line 242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

238: x_return_status => x_return_status);
239:
240: -- check if activity started successfully
241: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: RAISE OKL_API.G_EXCEPTION_ERROR;
245: END IF;
246:

Line 243: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

239:
240: -- check if activity started successfully
241: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: RAISE OKL_API.G_EXCEPTION_ERROR;
245: END IF;
246:
247: -- Initialize records in okl_book_controller_trx table

Line 244: RAISE OKL_API.G_EXCEPTION_ERROR;

240: -- check if activity started successfully
241: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: RAISE OKL_API.G_EXCEPTION_ERROR;
245: END IF;
246:
247: -- Initialize records in okl_book_controller_trx table
248:

Line 258: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

254: x_msg_data => x_msg_data,
255: p_khr_id => p_khr_id,
256: x_batch_number => lx_batch_number);
257:
258: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_ERROR;
262: END IF;

Line 259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

255: p_khr_id => p_khr_id,
256: x_batch_number => lx_batch_number);
257:
258: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_ERROR;
262: END IF;
263:

Line 260: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

256: x_batch_number => lx_batch_number);
257:
258: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_ERROR;
262: END IF;
263:
264: OPEN c_book_ctrl_trx(p_khr_id => p_khr_id);

Line 261: RAISE OKL_API.G_EXCEPTION_ERROR;

257:
258: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_ERROR;
262: END IF;
263:
264: OPEN c_book_ctrl_trx(p_khr_id => p_khr_id);
265: LOOP

Line 286: IF(l_batch_num IS NULL OR l_batch_num = OKL_API.G_MISS_NUM) THEN

282: OR l_bk_progress_status <> 'COMPLETE') THEN
283: l_batch_num := get_batch_id;
284: END IF;
285:
286: IF(l_batch_num IS NULL OR l_batch_num = OKL_API.G_MISS_NUM) THEN
287: --raise error if batch number could not be generated from seq.
288: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: batch number could not be generated');
289: RAISE OKL_API.G_EXCEPTION_ERROR;
290: END IF;

Line 289: RAISE OKL_API.G_EXCEPTION_ERROR;

285:
286: IF(l_batch_num IS NULL OR l_batch_num = OKL_API.G_MISS_NUM) THEN
287: --raise error if batch number could not be generated from seq.
288: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: batch number could not be generated');
289: RAISE OKL_API.G_EXCEPTION_ERROR;
290: END IF;
291:
292: i := 0;
293: IF (p_cont_stage IN ('OKLBCTQA','OKLBCTUT','OKLBCTST','OKLBCTBK') AND l_qa_progress_status <> 'COMPLETE') THEN

Line 364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

360: x_msg_data => x_msg_data,
361: p_bct_tbl => l_bct_tbl,
362: x_bct_tbl => lx_bct_tbl);
363:
364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
367: RAISE OKL_API.G_EXCEPTION_ERROR;
368: END IF;

Line 365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

361: p_bct_tbl => l_bct_tbl,
362: x_bct_tbl => lx_bct_tbl);
363:
364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
367: RAISE OKL_API.G_EXCEPTION_ERROR;
368: END IF;
369: COMMIT;

Line 366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

362: x_bct_tbl => lx_bct_tbl);
363:
364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
367: RAISE OKL_API.G_EXCEPTION_ERROR;
368: END IF;
369: COMMIT;
370: ELSE

Line 367: RAISE OKL_API.G_EXCEPTION_ERROR;

363:
364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
367: RAISE OKL_API.G_EXCEPTION_ERROR;
368: END IF;
369: COMMIT;
370: ELSE
371: FND_FILE.PUT_LINE(FND_FILE.LOG,'contract already in desired status');

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

372: END IF;
373:
374: x_batch_number := l_batch_num;
375:
376: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
377: x_msg_data => x_msg_data);
378:
379: EXCEPTION
380: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 380: WHEN OKL_API.G_EXCEPTION_ERROR THEN

376: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
377: x_msg_data => x_msg_data);
378:
379: EXCEPTION
380: WHEN OKL_API.G_EXCEPTION_ERROR THEN
381: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
382: p_api_name => l_api_name,
383: p_pkg_name => g_pkg_name,
384: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 381: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

377: x_msg_data => x_msg_data);
378:
379: EXCEPTION
380: WHEN OKL_API.G_EXCEPTION_ERROR THEN
381: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
382: p_api_name => l_api_name,
383: p_pkg_name => g_pkg_name,
384: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
385: x_msg_count => x_msg_count,

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

380: WHEN OKL_API.G_EXCEPTION_ERROR THEN
381: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
382: p_api_name => l_api_name,
383: p_pkg_name => g_pkg_name,
384: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data,
387: p_api_type => g_api_type);
388:

Line 389: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data,
387: p_api_type => g_api_type);
388:
389: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
390: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
391: p_api_name => l_api_name,
392: p_pkg_name => g_pkg_name,
393: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 390: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

386: x_msg_data => x_msg_data,
387: p_api_type => g_api_type);
388:
389: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
390: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
391: p_api_name => l_api_name,
392: p_pkg_name => g_pkg_name,
393: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
394: x_msg_count => x_msg_count,

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

389: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
390: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
391: p_api_name => l_api_name,
392: p_pkg_name => g_pkg_name,
393: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
394: x_msg_count => x_msg_count,
395: x_msg_data => x_msg_data,
396: p_api_type => g_api_type);
397:

Line 399: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

395: x_msg_data => x_msg_data,
396: p_api_type => g_api_type);
397:
398: WHEN OTHERS THEN
399: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
400: p_api_name => l_api_name,
401: p_pkg_name => g_pkg_name,
402: p_exc_name => 'OTHERS',
403: x_msg_count => x_msg_count,

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

431: x_return_status OUT NOCOPY VARCHAR2) IS
432:
433: l_api_name CONSTANT VARCHAR2(30) := 'update_book_ctrl_trx';
434: l_api_version CONSTANT NUMBER := 1.0;
435: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
436: l_init_msg_list VARCHAR2(1) := 'T';
437: l_msg_count NUMBER;
438: l_msg_data VARCHAR2(2000);
439: l_bct_rec bct_rec_type;

Line 443: x_return_status := OKL_API.G_RET_STS_SUCCESS;

439: l_bct_rec bct_rec_type;
440: x_bct_rec bct_rec_type;
441:
442: BEGIN
443: x_return_status := OKL_API.G_RET_STS_SUCCESS;
444: --start activity
445: x_return_status := OKL_API.START_ACTIVITY(
446: p_api_name => l_api_name,
447: p_pkg_name => g_pkg_name,

Line 445: x_return_status := OKL_API.START_ACTIVITY(

441:
442: BEGIN
443: x_return_status := OKL_API.G_RET_STS_SUCCESS;
444: --start activity
445: x_return_status := OKL_API.START_ACTIVITY(
446: p_api_name => l_api_name,
447: p_pkg_name => g_pkg_name,
448: p_init_msg_list => l_init_msg_list,
449: l_api_version => l_api_version,

Line 455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

451: p_api_type => g_api_type,
452: x_return_status => l_return_status);
453:
454: --raise exception if error during start activity
455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
458: RAISE OKL_API.G_EXCEPTION_ERROR;
459: END IF;

Line 456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

452: x_return_status => l_return_status);
453:
454: --raise exception if error during start activity
455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
458: RAISE OKL_API.G_EXCEPTION_ERROR;
459: END IF;
460:

Line 457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

453:
454: --raise exception if error during start activity
455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
458: RAISE OKL_API.G_EXCEPTION_ERROR;
459: END IF;
460:
461: --check batch number is not null

Line 458: RAISE OKL_API.G_EXCEPTION_ERROR;

454: --raise exception if error during start activity
455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
458: RAISE OKL_API.G_EXCEPTION_ERROR;
459: END IF;
460:
461: --check batch number is not null
462: IF (p_batch_num IS NULL OR p_batch_num = OKL_API.G_MISS_NUM) THEN

Line 462: IF (p_batch_num IS NULL OR p_batch_num = OKL_API.G_MISS_NUM) THEN

458: RAISE OKL_API.G_EXCEPTION_ERROR;
459: END IF;
460:
461: --check batch number is not null
462: IF (p_batch_num IS NULL OR p_batch_num = OKL_API.G_MISS_NUM) THEN
463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:batch number is null in call to update okl_book_controller_trx');
464: RAISE OKL_API.G_EXCEPTION_ERROR;
465: ELSE
466: l_bct_rec.batch_number := p_batch_num;

Line 464: RAISE OKL_API.G_EXCEPTION_ERROR;

460:
461: --check batch number is not null
462: IF (p_batch_num IS NULL OR p_batch_num = OKL_API.G_MISS_NUM) THEN
463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:batch number is null in call to update okl_book_controller_trx');
464: RAISE OKL_API.G_EXCEPTION_ERROR;
465: ELSE
466: l_bct_rec.batch_number := p_batch_num;
467: END IF;
468:

Line 470: IF (p_srl_num IS NULL OR p_srl_num = OKL_API.G_MISS_NUM) THEN

466: l_bct_rec.batch_number := p_batch_num;
467: END IF;
468:
469: --check processing serial number is not null
470: IF (p_srl_num IS NULL OR p_srl_num = OKL_API.G_MISS_NUM) THEN
471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:processing srl number is null in call to update okl_book_controller_trx');
472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: ELSE
474: l_bct_rec.processing_srl_number := p_srl_num;

Line 472: RAISE OKL_API.G_EXCEPTION_ERROR;

468:
469: --check processing serial number is not null
470: IF (p_srl_num IS NULL OR p_srl_num = OKL_API.G_MISS_NUM) THEN
471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:processing srl number is null in call to update okl_book_controller_trx');
472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: ELSE
474: l_bct_rec.processing_srl_number := p_srl_num;
475: END IF;
476:

Line 478: IF (p_prog_status IS NOT NULL AND p_prog_status <> OKL_API.G_MISS_CHAR) THEN

474: l_bct_rec.processing_srl_number := p_srl_num;
475: END IF;
476:
477: --if request status is not null, update request status
478: IF (p_prog_status IS NOT NULL AND p_prog_status <> OKL_API.G_MISS_CHAR) THEN
479: l_bct_rec.progress_status := p_prog_status;
480: END IF;
481:
482: --if request id is not null, update request id

Line 483: IF (p_request_id IS NOT NULL AND p_request_id <> OKL_API.G_MISS_NUM) THEN

479: l_bct_rec.progress_status := p_prog_status;
480: END IF;
481:
482: --if request id is not null, update request id
483: IF (p_request_id IS NOT NULL AND p_request_id <> OKL_API.G_MISS_NUM) THEN
484: l_bct_rec.conc_req_id := p_request_id;
485: END IF;
486:
487: --call TAPI to update okl_book_controller_trx

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

493: x_msg_data => l_msg_data,
494: p_bct_rec => l_bct_rec,
495: x_bct_rec => x_bct_rec);
496:
497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_ERROR;
501: END IF;

Line 498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

494: p_bct_rec => l_bct_rec,
495: x_bct_rec => x_bct_rec);
496:
497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_ERROR;
501: END IF;
502: COMMIT;

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

495: x_bct_rec => x_bct_rec);
496:
497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_ERROR;
501: END IF;
502: COMMIT;
503:

Line 500: RAISE OKL_API.G_EXCEPTION_ERROR;

496:
497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_ERROR;
501: END IF;
502: COMMIT;
503:
504: --end activity

Line 505: OKL_API.END_ACTIVITY(x_msg_count => l_msg_count,

501: END IF;
502: COMMIT;
503:
504: --end activity
505: OKL_API.END_ACTIVITY(x_msg_count => l_msg_count,
506: x_msg_data => l_msg_data);
507:
508: EXCEPTION
509: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 509: WHEN OKL_API.G_EXCEPTION_ERROR THEN

505: OKL_API.END_ACTIVITY(x_msg_count => l_msg_count,
506: x_msg_data => l_msg_data);
507:
508: EXCEPTION
509: WHEN OKL_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
511: p_api_name => l_api_name,
512: p_pkg_name => g_pkg_name,
513: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 510: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

506: x_msg_data => l_msg_data);
507:
508: EXCEPTION
509: WHEN OKL_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
511: p_api_name => l_api_name,
512: p_pkg_name => g_pkg_name,
513: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
514: x_msg_count => l_msg_count,

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

509: WHEN OKL_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
511: p_api_name => l_api_name,
512: p_pkg_name => g_pkg_name,
513: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
514: x_msg_count => l_msg_count,
515: x_msg_data => l_msg_data,
516: p_api_type => g_api_type);
517:

Line 518: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

514: x_msg_count => l_msg_count,
515: x_msg_data => l_msg_data,
516: p_api_type => g_api_type);
517:
518: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
519: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
520: p_api_name => l_api_name,
521: p_pkg_name => g_pkg_name,
522: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 519: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

515: x_msg_data => l_msg_data,
516: p_api_type => g_api_type);
517:
518: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
519: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
520: p_api_name => l_api_name,
521: p_pkg_name => g_pkg_name,
522: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
523: x_msg_count => l_msg_count,

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

518: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
519: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
520: p_api_name => l_api_name,
521: p_pkg_name => g_pkg_name,
522: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
523: x_msg_count => l_msg_count,
524: x_msg_data => l_msg_data,
525: p_api_type => g_api_type);
526:

Line 528: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

524: x_msg_data => l_msg_data,
525: p_api_type => g_api_type);
526:
527: WHEN OTHERS THEN
528: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
529: p_api_name => l_api_name,
530: p_pkg_name => g_pkg_name,
531: p_exc_name => 'OTHERS',
532: x_msg_count => l_msg_count,

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

561: l_api_name CONSTANT VARCHAR2(30) := 'submit_controller_prg1';
562: l_api_version CONSTANT NUMBER := 1.0;
563: l_req_id NUMBER := 0;
564:
565: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
566: l_init_msg_list VARCHAR2(1) := 'T';
567: l_batch_number okl_book_controller_trx.batch_number%TYPE;
568: l_msg_count NUMBER;
569: l_msg_data VARCHAR2(2000);

Line 580: x_return_status := OKL_API.G_RET_STS_SUCCESS;

576: WHERE id = p_khr_id;
577:
578:
579: BEGIN
580: x_return_status := OKL_API.G_RET_STS_SUCCESS;
581: x_return_status := OKL_API.START_ACTIVITY(
582: p_api_name => l_api_name,
583: p_pkg_name => g_pkg_name,
584: p_init_msg_list => p_init_msg_list,

Line 581: x_return_status := OKL_API.START_ACTIVITY(

577:
578:
579: BEGIN
580: x_return_status := OKL_API.G_RET_STS_SUCCESS;
581: x_return_status := OKL_API.START_ACTIVITY(
582: p_api_name => l_api_name,
583: p_pkg_name => g_pkg_name,
584: p_init_msg_list => p_init_msg_list,
585: l_api_version => l_api_version,

Line 591: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

587: p_api_type => g_api_type,
588: x_return_status => x_return_status);
589:
590: --raise exception if error during start activity
591: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
594: RAISE OKL_API.G_EXCEPTION_ERROR;
595: END IF;

Line 592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

588: x_return_status => x_return_status);
589:
590: --raise exception if error during start activity
591: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
594: RAISE OKL_API.G_EXCEPTION_ERROR;
595: END IF;
596:

Line 593: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

589:
590: --raise exception if error during start activity
591: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
594: RAISE OKL_API.G_EXCEPTION_ERROR;
595: END IF;
596:
597: --fetch the current status of the contract

Line 594: RAISE OKL_API.G_EXCEPTION_ERROR;

590: --raise exception if error during start activity
591: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
594: RAISE OKL_API.G_EXCEPTION_ERROR;
595: END IF;
596:
597: --fetch the current status of the contract
598: OPEN get_curr_sts_code(p_khr_id);

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

615: p_draft_journal_entry => p_draft_journal_entry,
616: p_curr_sts_code => l_curr_sts_code,
617: x_batch_number => l_batch_number);
618:
619: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
620: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');

Line 621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

617: x_batch_number => l_batch_number);
618:
619: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
620: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF;

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

618:
619: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
620: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF;
626:

Line 624: RAISE OKL_API.G_EXCEPTION_ERROR;

620: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF;
626:
627: --submit concurrent request for Controller Program 1
628: FND_REQUEST.set_org_id(mo_global.get_current_org_id); --MOAC- Concurrent request

Line 640: okl_api.set_message(p_app_name => 'OKL',

636: argument4 => 'UI');
637:
638: --Raise Error if the request has not been submitted successfully.
639: IF l_req_id = 0 THEN
640: okl_api.set_message(p_app_name => 'OKL',
641: p_msg_name => 'OKL_CONC_REQ_ERROR',
642: p_token1 => 'PROG_NAME',
643: p_token1_value => 'Controller Program 1',
644: p_token2 => 'REQUEST_ID',

Line 646: RAISE OKL_API.G_EXCEPTION_ERROR;

642: p_token1 => 'PROG_NAME',
643: p_token1_value => 'Controller Program 1',
644: p_token2 => 'REQUEST_ID',
645: p_token2_value => l_req_id);
646: RAISE OKL_API.G_EXCEPTION_ERROR;
647: END IF;
648:
649: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
650: x_msg_data => x_msg_data);

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

645: p_token2_value => l_req_id);
646: RAISE OKL_API.G_EXCEPTION_ERROR;
647: END IF;
648:
649: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
650: x_msg_data => x_msg_data);
651:
652: EXCEPTION
653: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 653: WHEN OKL_API.G_EXCEPTION_ERROR THEN

649: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
650: x_msg_data => x_msg_data);
651:
652: EXCEPTION
653: WHEN OKL_API.G_EXCEPTION_ERROR THEN
654: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
655: p_api_name => l_api_name,
656: p_pkg_name => g_pkg_name,
657: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 654: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

650: x_msg_data => x_msg_data);
651:
652: EXCEPTION
653: WHEN OKL_API.G_EXCEPTION_ERROR THEN
654: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
655: p_api_name => l_api_name,
656: p_pkg_name => g_pkg_name,
657: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
658: x_msg_count => x_msg_count,

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

653: WHEN OKL_API.G_EXCEPTION_ERROR THEN
654: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
655: p_api_name => l_api_name,
656: p_pkg_name => g_pkg_name,
657: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
658: x_msg_count => x_msg_count,
659: x_msg_data => x_msg_data,
660: p_api_type => g_api_type);
661:

Line 662: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

658: x_msg_count => x_msg_count,
659: x_msg_data => x_msg_data,
660: p_api_type => g_api_type);
661:
662: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
663: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
664: p_api_name => l_api_name,
665: p_pkg_name => g_pkg_name,
666: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 663: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

659: x_msg_data => x_msg_data,
660: p_api_type => g_api_type);
661:
662: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
663: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
664: p_api_name => l_api_name,
665: p_pkg_name => g_pkg_name,
666: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
667: x_msg_count => x_msg_count,

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

662: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
663: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
664: p_api_name => l_api_name,
665: p_pkg_name => g_pkg_name,
666: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
667: x_msg_count => x_msg_count,
668: x_msg_data => x_msg_data,
669: p_api_type => g_api_type);
670:

Line 672: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

668: x_msg_data => x_msg_data,
669: p_api_type => g_api_type);
670:
671: WHEN OTHERS THEN
672: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
673: p_api_name => l_api_name,
674: p_pkg_name => g_pkg_name,
675: p_exc_name => 'OTHERS',
676: x_msg_count => x_msg_count,

Line 722: x_return_status := OKL_API.G_RET_STS_SUCCESS;

718: l_dummy VARCHAR2(1);
719: l_conc_req_activate BOOLEAN;
720:
721: BEGIN
722: x_return_status := OKL_API.G_RET_STS_SUCCESS;
723: x_return_status := OKL_API.START_ACTIVITY(
724: p_api_name => l_api_name,
725: p_pkg_name => g_pkg_name,
726: p_init_msg_list => p_init_msg_list,

Line 723: x_return_status := OKL_API.START_ACTIVITY(

719: l_conc_req_activate BOOLEAN;
720:
721: BEGIN
722: x_return_status := OKL_API.G_RET_STS_SUCCESS;
723: x_return_status := OKL_API.START_ACTIVITY(
724: p_api_name => l_api_name,
725: p_pkg_name => g_pkg_name,
726: p_init_msg_list => p_init_msg_list,
727: l_api_version => l_api_version,

Line 733: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

729: p_api_type => g_api_type,
730: x_return_status => x_return_status);
731:
732: -- check if activity started successfully
733: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
736: RAISE OKL_API.G_EXCEPTION_ERROR;
737: END IF;

Line 734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

730: x_return_status => x_return_status);
731:
732: -- check if activity started successfully
733: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
736: RAISE OKL_API.G_EXCEPTION_ERROR;
737: END IF;
738:

Line 735: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

731:
732: -- check if activity started successfully
733: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
736: RAISE OKL_API.G_EXCEPTION_ERROR;
737: END IF;
738:
739: l_conc_req_activate := FALSE;

Line 736: RAISE OKL_API.G_EXCEPTION_ERROR;

732: -- check if activity started successfully
733: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
736: RAISE OKL_API.G_EXCEPTION_ERROR;
737: END IF;
738:
739: l_conc_req_activate := FALSE;
740:

Line 761: Okl_Api.set_message(p_app_name => 'OKL',

757: argument1 => p_khr_id);
758:
759: IF l_req_id = 0 THEN
760: -- Raise Error if the request has not been submitted successfully.
761: Okl_Api.set_message(p_app_name => 'OKL',
762: p_msg_name => 'OKL_CONC_REQ_ERROR',
763: p_token1 => 'PROG_NAME',
764: p_token1_value => 'Controller Program 2',
765: p_token2 => 'REQUEST_ID',

Line 767: RAISE OKL_API.G_EXCEPTION_ERROR;

763: p_token1 => 'PROG_NAME',
764: p_token1_value => 'Controller Program 2',
765: p_token2 => 'REQUEST_ID',
766: p_token2_value => l_req_id);
767: RAISE OKL_API.G_EXCEPTION_ERROR;
768: END IF;
769: END IF;
770:
771: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

767: RAISE OKL_API.G_EXCEPTION_ERROR;
768: END IF;
769: END IF;
770:
771: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
772: x_msg_data => x_msg_data);
773:
774: EXCEPTION
775: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 775: WHEN OKL_API.G_EXCEPTION_ERROR THEN

771: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
772: x_msg_data => x_msg_data);
773:
774: EXCEPTION
775: WHEN OKL_API.G_EXCEPTION_ERROR THEN
776:
777: --close all open cursors
778: IF book_ctrl_trx_csr%ISOPEN THEN
779: CLOSE book_ctrl_trx_csr;

Line 781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

777: --close all open cursors
778: IF book_ctrl_trx_csr%ISOPEN THEN
779: CLOSE book_ctrl_trx_csr;
780: END IF;
781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
782: p_api_name => l_api_name,
783: p_pkg_name => g_pkg_name,
784: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
785: x_msg_count => x_msg_count,

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

780: END IF;
781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
782: p_api_name => l_api_name,
783: p_pkg_name => g_pkg_name,
784: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
785: x_msg_count => x_msg_count,
786: x_msg_data => x_msg_data,
787: p_api_type => g_api_type);
788:

Line 789: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

785: x_msg_count => x_msg_count,
786: x_msg_data => x_msg_data,
787: p_api_type => g_api_type);
788:
789: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
790:
791: --close all open cursors
792: IF book_ctrl_trx_csr%ISOPEN THEN
793: CLOSE book_ctrl_trx_csr;

Line 795: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

791: --close all open cursors
792: IF book_ctrl_trx_csr%ISOPEN THEN
793: CLOSE book_ctrl_trx_csr;
794: END IF;
795: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
796: p_api_name => l_api_name,
797: p_pkg_name => g_pkg_name,
798: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
799: x_msg_count => x_msg_count,

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

794: END IF;
795: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
796: p_api_name => l_api_name,
797: p_pkg_name => g_pkg_name,
798: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
799: x_msg_count => x_msg_count,
800: x_msg_data => x_msg_data,
801: p_api_type => g_api_type);
802:

Line 809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

805: --close all open cursors
806: IF book_ctrl_trx_csr%ISOPEN THEN
807: CLOSE book_ctrl_trx_csr;
808: END IF;
809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
810: p_api_name => l_api_name,
811: p_pkg_name => g_pkg_name,
812: p_exc_name => 'OTHERS',
813: x_msg_count => x_msg_count,

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

838: p_serial_num IN NUMBER,
839: x_req_status OUT NOCOPY VARCHAR2) IS
840:
841: l_request_id NUMBER := 0;
842: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
843: --parameters for wait logic
844: l_req_status BOOLEAN;
845: l_phase VARCHAR2(10);
846: l_status VARCHAR2(10);

Line 855: l_init_msg_list VARCHAR2(1) := OKL_API.G_TRUE;

851: l_msg_index_out NUMBER;
852: l_msg_count NUMBER;
853: l_msg_data VARCHAR2(2000);
854: l_api_version NUMBER := 1.0;
855: l_init_msg_list VARCHAR2(1) := OKL_API.G_TRUE;
856: l_program_name OKL_BOOK_CONTROL_TRX_ALL.prog_short_name%TYPE;
857:
858: BEGIN
859: x_req_status := 'S';

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

887: p_prog_short_name => l_program_name,
888: p_conc_req_id => NULL,
889: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
890:
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;

Line 892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

888: p_conc_req_id => NULL,
889: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
890:
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896:

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

889: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
890:
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896:
897: update_book_ctrl_trx(

Line 894: RAISE OKL_API.G_EXCEPTION_ERROR;

890:
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896:
897: update_book_ctrl_trx(
898: p_batch_num => p_batch_number,

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

900: p_prog_status => 'ERROR',
901: p_request_id => null,
902: x_return_status => l_return_status);
903:
904: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_ERROR;
908: END IF;

Line 905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

901: p_request_id => null,
902: x_return_status => l_return_status);
903:
904: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_ERROR;
908: END IF;
909:

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

902: x_return_status => l_return_status);
903:
904: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_ERROR;
908: END IF;
909:
910: x_req_status := 'E';

Line 907: RAISE OKL_API.G_EXCEPTION_ERROR;

903:
904: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
907: RAISE OKL_API.G_EXCEPTION_ERROR;
908: END IF;
909:
910: x_req_status := 'E';
911: --if request is submitted successfully

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

925: p_prog_short_name => l_program_name,
926: p_conc_req_id => l_request_id,
927: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING);
928:
929: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
932: RAISE OKL_API.G_EXCEPTION_ERROR;
933: END IF;

Line 930: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

926: p_conc_req_id => l_request_id,
927: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING);
928:
929: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
932: RAISE OKL_API.G_EXCEPTION_ERROR;
933: END IF;
934:

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

927: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING);
928:
929: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
932: RAISE OKL_API.G_EXCEPTION_ERROR;
933: END IF;
934:
935: update_book_ctrl_trx(

Line 932: RAISE OKL_API.G_EXCEPTION_ERROR;

928:
929: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
932: RAISE OKL_API.G_EXCEPTION_ERROR;
933: END IF;
934:
935: update_book_ctrl_trx(
936: p_batch_num => p_batch_number,

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

938: p_prog_status => 'RUNNING',
939: p_request_id => l_request_id,
940: x_return_status => l_return_status);
941:
942: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;

Line 943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

939: p_request_id => l_request_id,
940: x_return_status => l_return_status);
941:
942: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;
947:

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

940: x_return_status => l_return_status);
941:
942: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;
947:
948: --wait logic to wait for concurrent request to complete.

Line 945: RAISE OKL_API.G_EXCEPTION_ERROR;

941:
942: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;
947:
948: --wait logic to wait for concurrent request to complete.
949: l_req_status := fnd_concurrent.wait_for_request(

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

970: p_khr_id => p_khr_id,
971: p_prog_short_name => l_program_name,
972: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
973:
974: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
976: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
977: RAISE OKL_API.G_EXCEPTION_ERROR;
978: END IF;

Line 975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

971: p_prog_short_name => l_program_name,
972: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
973:
974: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
976: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
977: RAISE OKL_API.G_EXCEPTION_ERROR;
978: END IF;
979:

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

972: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
973:
974: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
976: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
977: RAISE OKL_API.G_EXCEPTION_ERROR;
978: END IF;
979:
980: update_book_ctrl_trx(

Line 977: RAISE OKL_API.G_EXCEPTION_ERROR;

973:
974: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
976: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
977: RAISE OKL_API.G_EXCEPTION_ERROR;
978: END IF;
979:
980: update_book_ctrl_trx(
981: p_batch_num => p_batch_number,

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

983: p_prog_status => 'ERROR',
984: p_request_id => null,
985: x_return_status => l_return_status);
986:
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;

Line 988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

984: p_request_id => null,
985: x_return_status => l_return_status);
986:
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992:

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

985: x_return_status => l_return_status);
986:
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992:
993: x_req_status := 'E';

Line 990: RAISE OKL_API.G_EXCEPTION_ERROR;

986:
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992:
993: x_req_status := 'E';
994:

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

1006: p_khr_id => p_khr_id,
1007: p_prog_short_name => l_program_name,
1008: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
1009:
1010: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1013: RAISE OKL_API.G_EXCEPTION_ERROR;
1014: END IF;

Line 1011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1007: p_prog_short_name => l_program_name,
1008: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
1009:
1010: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1013: RAISE OKL_API.G_EXCEPTION_ERROR;
1014: END IF;
1015:

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

1008: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
1009:
1010: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1013: RAISE OKL_API.G_EXCEPTION_ERROR;
1014: END IF;
1015:
1016: update_book_ctrl_trx(

Line 1013: RAISE OKL_API.G_EXCEPTION_ERROR;

1009:
1010: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1013: RAISE OKL_API.G_EXCEPTION_ERROR;
1014: END IF;
1015:
1016: update_book_ctrl_trx(
1017: p_batch_num => p_batch_number,

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

1019: p_prog_status => 'COMPLETE',
1020: p_request_id => null,
1021: x_return_status => l_return_status);
1022:
1023: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;

Line 1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1020: p_request_id => null,
1021: x_return_status => l_return_status);
1022:
1023: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;
1028:

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

1021: x_return_status => l_return_status);
1022:
1023: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;
1028:
1029: END IF;

Line 1026: RAISE OKL_API.G_EXCEPTION_ERROR;

1022:
1023: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;
1028:
1029: END IF;
1030: END IF;

Line 1033: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1029: END IF;
1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1034: -- print the error message in the output file
1035: IF (fnd_msg_pub.count_msg > 0) THEN
1036: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1037: LOOP

Line 1048: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1044: END LOOP;
1045: END IF;
1046: x_req_status := 'E';
1047:
1048: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1049: -- print the error message in the output file
1050: IF (fnd_msg_pub.count_msg > 0) THEN
1051: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1052: LOOP

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

1101:
1102: l_api_name CONSTANT VARCHAR2(30) := 'exec_controller_prg1';
1103: l_api_version CONSTANT NUMBER := 1.0;
1104: --p_api_version CONSTANT NUMBER := 1.0;
1105: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1106: l_init_msg_list VARCHAR2(1) := 'T';
1107: l_msg_count NUMBER;
1108: l_msg_data VARCHAR2(2000);
1109: l_batch_number okl_book_controller_trx.batch_number%TYPE;

Line 1135: /*l_return_status := OKL_API.START_ACTIVITY(l_api_name

1131: WHERE id = p_khr_id;
1132:
1133: BEGIN
1134: p_retcode := 0;
1135: /*l_return_status := OKL_API.START_ACTIVITY(l_api_name
1136: ,G_PKG_NAME
1137: ,l_init_msg_list
1138: ,l_api_version
1139: ,p_api_version

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

1139: ,p_api_version
1140: ,'_PVT'
1141: ,l_return_status);
1142:
1143: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1141: ,l_return_status);
1142:
1143: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1148: RAISE OKL_API.G_EXCEPTION_ERROR;
1149: END IF;*/

Line 1146: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1142:
1143: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1148: RAISE OKL_API.G_EXCEPTION_ERROR;
1149: END IF;*/
1150:

Line 1148: RAISE OKL_API.G_EXCEPTION_ERROR;

1144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1148: RAISE OKL_API.G_EXCEPTION_ERROR;
1149: END IF;*/
1150:
1151: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKL: Contract Booking Controller Started');
1152: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

1174: p_draft_journal_entry => p_draft_journal_entry,
1175: p_curr_sts_code => l_curr_sts_code,
1176: x_batch_number => l_batch_number);
1177:
1178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');

Line 1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1176: x_batch_number => l_batch_number);
1177:
1178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');
1183: RAISE OKL_API.G_EXCEPTION_ERROR;
1184: END IF;

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

1177:
1178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');
1183: RAISE OKL_API.G_EXCEPTION_ERROR;
1184: END IF;
1185:

Line 1183: RAISE OKL_API.G_EXCEPTION_ERROR;

1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to populate_book_ctrl_trx');
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to populate_book_ctrl_trx');
1183: RAISE OKL_API.G_EXCEPTION_ERROR;
1184: END IF;
1185:
1186: --check for batch number to be not null.
1187: --Raise exception if batch number is not generated

Line 1188: IF(l_batch_number IS NULL OR l_batch_number = OKL_API.G_MISS_NUM) THEN

1184: END IF;
1185:
1186: --check for batch number to be not null.
1187: --Raise exception if batch number is not generated
1188: IF(l_batch_number IS NULL OR l_batch_number = OKL_API.G_MISS_NUM) THEN
1189: FND_FILE.PUT_LINE(FND_FILE.LOG,'batch number could not be generated');
1190: RAISE OKL_API.G_EXCEPTION_ERROR;
1191: END IF;
1192: COMMIT;

Line 1190: RAISE OKL_API.G_EXCEPTION_ERROR;

1186: --check for batch number to be not null.
1187: --Raise exception if batch number is not generated
1188: IF(l_batch_number IS NULL OR l_batch_number = OKL_API.G_MISS_NUM) THEN
1189: FND_FILE.PUT_LINE(FND_FILE.LOG,'batch number could not be generated');
1190: RAISE OKL_API.G_EXCEPTION_ERROR;
1191: END IF;
1192: COMMIT;
1193:
1194: END IF; --p_called_from = 'FORM'

Line 1347: --OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

1343: --concurrent request for Activate..end
1344:
1345: END LOOP;--end submitting all requests
1346:
1347: --OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
1348: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKL: Contract Booking Controller Completed with Status 0');
1349:
1350: EXCEPTION
1351: WHEN USER_EXCEPTION THEN

Line 1374: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1370: p_request_id => null,
1371: x_return_status => l_return_status);
1372: END LOOP;
1373:
1374: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1375: p_retcode := 2;
1376:
1377: --close all open cursors
1378: IF book_ctrl_trx_csr%ISOPEN THEN

Line 1385: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1381: IF get_curr_sts_code%ISOPEN THEN
1382: CLOSE get_curr_sts_code;
1383: END IF;
1384:
1385: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1386: p_api_name => l_api_name,
1387: p_pkg_name => g_pkg_name,
1388: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1389: x_msg_count => l_msg_count,

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

1384:
1385: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1386: p_api_name => l_api_name,
1387: p_pkg_name => g_pkg_name,
1388: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1389: x_msg_count => l_msg_count,
1390: x_msg_data => l_msg_data,
1391: p_api_type => g_api_type);*/
1392:

Line 1406: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_data);
1403: END LOOP;
1404: END IF;
1405:
1406: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1407: p_retcode := 2;
1408:
1409: --close all open cursors
1410: IF book_ctrl_trx_csr%ISOPEN THEN

Line 1417: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1413: IF get_curr_sts_code%ISOPEN THEN
1414: CLOSE get_curr_sts_code;
1415: END IF;
1416:
1417: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1418: p_api_name => l_api_name,
1419: p_pkg_name => g_pkg_name,
1420: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1421: x_msg_count => l_msg_count,

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

1416:
1417: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1418: p_api_name => l_api_name,
1419: p_pkg_name => g_pkg_name,
1420: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1421: x_msg_count => l_msg_count,
1422: x_msg_data => l_msg_data,
1423: p_api_type => g_api_type);*/
1424:

Line 1450: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1446: IF get_curr_sts_code%ISOPEN THEN
1447: CLOSE get_curr_sts_code;
1448: END IF;
1449:
1450: /*l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1451: p_api_name => l_api_name,
1452: p_pkg_name => g_pkg_name,
1453: p_exc_name => 'OTHERS',
1454: x_msg_count => l_msg_count,

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

1493:
1494: l_api_name CONSTANT VARCHAR2(30) := 'exec_controller_prg2';
1495: /*l_api_version CONSTANT NUMBER := 1.0;
1496: p_api_version CONSTANT NUMBER := 1.0;
1497: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1498: l_init_msg_list VARCHAR2(1) := 'T';
1499: l_msg_count NUMBER;
1500: l_msg_data VARCHAR2(2000);*/
1501: l_req_status VARCHAR2(1);

Line 1519: /*l_return_status := OKL_API.START_ACTIVITY(l_api_name

1515:
1516:
1517: BEGIN
1518: p_retcode := 0;
1519: /*l_return_status := OKL_API.START_ACTIVITY(l_api_name
1520: ,G_PKG_NAME
1521: ,l_init_msg_list
1522: ,l_api_version
1523: ,p_api_version

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

1523: ,p_api_version
1524: ,'_PVT'
1525: ,l_return_status);
1526:
1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1528: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 1529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1525: ,l_return_status);
1526:
1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1528: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1532: RAISE OKL_API.G_EXCEPTION_ERROR;
1533: END IF;*/

Line 1530: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1526:
1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1528: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1532: RAISE OKL_API.G_EXCEPTION_ERROR;
1533: END IF;*/
1534:

Line 1532: RAISE OKL_API.G_EXCEPTION_ERROR;

1528: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1532: RAISE OKL_API.G_EXCEPTION_ERROR;
1533: END IF;*/
1534:
1535: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKL: Contract Booking Controller Started');
1536: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 1564: --OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

1560: END IF;
1561: --concurrent request for Activation..end
1562: END LOOP;
1563:
1564: --OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
1565: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKL: Contract Booking Controller Completed with Status 0');
1566:
1567: EXCEPTION
1568: WHEN USER_EXCEPTION THEN

Line 1573: /*WHEN OKL_API.G_EXCEPTION_ERROR THEN

1569: p_retcode := 0;
1570: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract Activation Failed');
1571: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKL: Contract Booking Controller Completed with Errors');
1572:
1573: /*WHEN OKL_API.G_EXCEPTION_ERROR THEN
1574: p_retcode := 2;
1575:
1576: IF book_ctrl_trx_csr%ISOPEN THEN
1577: CLOSE book_ctrl_trx_csr;

Line 1580: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1576: IF book_ctrl_trx_csr%ISOPEN THEN
1577: CLOSE book_ctrl_trx_csr;
1578: END IF;
1579:
1580: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1581: p_api_name => l_api_name,
1582: p_pkg_name => g_pkg_name,
1583: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1584: x_msg_count => l_msg_count,

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

1579:
1580: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1581: p_api_name => l_api_name,
1582: p_pkg_name => g_pkg_name,
1583: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1584: x_msg_count => l_msg_count,
1585: x_msg_data => l_msg_data,
1586: p_api_type => g_api_type);
1587:

Line 1597: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1593: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, g_error_msg(i));
1594: END LOOP;
1595: END IF;
1596:
1597: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1598: p_retcode := 2;
1599:
1600: IF book_ctrl_trx_csr%ISOPEN THEN
1601: CLOSE book_ctrl_trx_csr;

Line 1604: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1600: IF book_ctrl_trx_csr%ISOPEN THEN
1601: CLOSE book_ctrl_trx_csr;
1602: END IF;
1603:
1604: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1605: p_api_name => l_api_name,
1606: p_pkg_name => g_pkg_name,
1607: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1608: x_msg_count => l_msg_count,

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

1603:
1604: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1605: p_api_name => l_api_name,
1606: p_pkg_name => g_pkg_name,
1607: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1608: x_msg_count => l_msg_count,
1609: x_msg_data => l_msg_data,
1610: p_api_type => g_api_type);
1611:

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

1664:
1665: l_api_name CONSTANT VARCHAR2(30) := 'execute_qa_check_list';
1666: l_api_version CONSTANT NUMBER := 1.0;
1667: p_api_version CONSTANT NUMBER := 1.0;
1668: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1669: l_init_msg_list VARCHAR2(1) := 'T';
1670: l_msg_count NUMBER;
1671: l_msg_data VARCHAR2(2000);
1672: l_qcl_id NUMBER;

Line 1711: l_return_status := OKL_API.START_ACTIVITY(l_api_name

1707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1708: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
1709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1710:
1711: l_return_status := OKL_API.START_ACTIVITY(l_api_name
1712: ,G_PKG_NAME
1713: ,l_init_msg_list
1714: ,l_api_version
1715: ,p_api_version

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

1715: ,p_api_version
1716: ,'_PVT'
1717: ,l_return_status);
1718:
1719: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1722: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1717: ,l_return_status);
1718:
1719: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1722: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1724: RAISE OKL_API.G_EXCEPTION_ERROR;
1725: END IF;

Line 1722: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1718:
1719: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1722: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1724: RAISE OKL_API.G_EXCEPTION_ERROR;
1725: END IF;
1726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 1724: RAISE OKL_API.G_EXCEPTION_ERROR;

1720: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1722: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
1724: RAISE OKL_API.G_EXCEPTION_ERROR;
1725: END IF;
1726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
1727: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1728:

Line 1735: l_return_status := OKL_API.G_RET_STS_ERROR;

1731: FETCH get_qcl_id INTO l_qcl_id;
1732: IF get_qcl_id%NOTFOUND THEN
1733: --error : contract does not exist
1734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Contract Number is not valid.');
1735: l_return_status := OKL_API.G_RET_STS_ERROR;
1736: RAISE OKL_API.G_EXCEPTION_ERROR;
1737: END IF;
1738: CLOSE get_qcl_id;
1739:

Line 1736: RAISE OKL_API.G_EXCEPTION_ERROR;

1732: IF get_qcl_id%NOTFOUND THEN
1733: --error : contract does not exist
1734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Contract Number is not valid.');
1735: l_return_status := OKL_API.G_RET_STS_ERROR;
1736: RAISE OKL_API.G_EXCEPTION_ERROR;
1737: END IF;
1738: CLOSE get_qcl_id;
1739:
1740: --call QA validate program

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

1747: p_qcl_id => l_qcl_id,
1748: p_chr_id => p_khr_id,
1749: x_msg_tbl => l_msg_tbl);
1750:
1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1752: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.execute_qa_check_list');
1753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1754: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in call to okl_contract_book_pub.execute_qa_check_list');

Line 1753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1749: x_msg_tbl => l_msg_tbl);
1750:
1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1752: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.execute_qa_check_list');
1753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1754: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in call to okl_contract_book_pub.execute_qa_check_list');
1756: RAISE OKL_API.G_EXCEPTION_ERROR;
1757: END IF;

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

1750:
1751: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1752: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.execute_qa_check_list');
1753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1754: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in call to okl_contract_book_pub.execute_qa_check_list');
1756: RAISE OKL_API.G_EXCEPTION_ERROR;
1757: END IF;
1758:

Line 1756: RAISE OKL_API.G_EXCEPTION_ERROR;

1752: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.execute_qa_check_list');
1753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1754: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in call to okl_contract_book_pub.execute_qa_check_list');
1756: RAISE OKL_API.G_EXCEPTION_ERROR;
1757: END IF;
1758:
1759: --print QA validation checklist into the output file
1760: IF (l_msg_tbl.COUNT > 0) THEN

Line 1793: l_return_status := OKL_API.G_RET_STS_ERROR;

1789: OPEN get_severity(l_error_sts);
1790: FETCH get_severity INTO l_severity;
1791: IF get_severity%NOTFOUND THEN
1792: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Invalid error status code '||l_error_sts);
1793: l_return_status := OKL_API.G_RET_STS_ERROR;
1794: RAISE OKL_API.G_EXCEPTION_ERROR;
1795: END IF;
1796: CLOSE get_severity;
1797:

Line 1794: RAISE OKL_API.G_EXCEPTION_ERROR;

1790: FETCH get_severity INTO l_severity;
1791: IF get_severity%NOTFOUND THEN
1792: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Invalid error status code '||l_error_sts);
1793: l_return_status := OKL_API.G_RET_STS_ERROR;
1794: RAISE OKL_API.G_EXCEPTION_ERROR;
1795: END IF;
1796: CLOSE get_severity;
1797:
1798: --printing checklist

Line 1828: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

1824:
1825: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QA validation completed successfully....');
1826: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1827:
1828: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
1829: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
1830:
1831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1832: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

Line 1840: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1838:
1839: EXCEPTION
1840: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1841: p_retcode := 2;
1842:
1843: --close open cursors
1844: IF get_qcl_id%ISOPEN THEN

Line 1851: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1847: IF get_severity%ISOPEN THEN
1848: CLOSE get_severity;
1849: END IF;
1850:
1851: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1852: p_api_name => l_api_name,
1853: p_pkg_name => g_pkg_name,
1854: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1855: x_msg_count => l_msg_count,

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

1850:
1851: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1852: p_api_name => l_api_name,
1853: p_pkg_name => g_pkg_name,
1854: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1855: x_msg_count => l_msg_count,
1856: x_msg_data => l_msg_data,
1857: p_api_type => g_api_type);
1858:

Line 1880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1878: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1879:
1880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1881: p_retcode := 2;
1882:
1883: --close open cursors
1884: IF get_qcl_id%ISOPEN THEN

Line 1891: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1887: IF get_severity%ISOPEN THEN
1888: CLOSE get_severity;
1889: END IF;
1890:
1891: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1892: p_api_name => l_api_name,
1893: p_pkg_name => g_pkg_name,
1894: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1895: x_msg_count => l_msg_count,

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

1890:
1891: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1892: p_api_name => l_api_name,
1893: p_pkg_name => g_pkg_name,
1894: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1895: x_msg_count => l_msg_count,
1896: x_msg_data => l_msg_data,
1897: p_api_type => g_api_type);
1898:

Line 1932: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1928: IF get_severity%ISOPEN THEN
1929: CLOSE get_severity;
1930: END IF;
1931:
1932: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1933: p_api_name => l_api_name,
1934: p_pkg_name => g_pkg_name,
1935: p_exc_name => 'OTHERS',
1936: x_msg_count => l_msg_count,

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

1982:
1983: l_api_name CONSTANT VARCHAR2(30) := 'generate_streams';
1984: l_api_version CONSTANT NUMBER := 1.0;
1985: p_api_version CONSTANT NUMBER := 1.0;
1986: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1987: l_init_msg_list VARCHAR2(1) := 'T';
1988: l_msg_count NUMBER;
1989: l_msg_data VARCHAR2(2000);
1990: l_pricing_engine VARCHAR2(30);

Line 2039: l_return_status := OKL_API.START_ACTIVITY(l_api_name

2035: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2036: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2037: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2038:
2039: l_return_status := OKL_API.START_ACTIVITY(l_api_name
2040: ,G_PKG_NAME
2041: ,l_init_msg_list
2042: ,l_api_version
2043: ,p_api_version

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

2043: ,p_api_version
2044: ,'_PVT'
2045: ,l_return_status);
2046:
2047: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2050: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2051: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 2049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2045: ,l_return_status);
2046:
2047: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2050: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2051: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2052: RAISE OKL_API.G_EXCEPTION_ERROR;
2053: END IF;

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

2046:
2047: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2050: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2051: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2052: RAISE OKL_API.G_EXCEPTION_ERROR;
2053: END IF;
2054: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 2052: RAISE OKL_API.G_EXCEPTION_ERROR;

2048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2050: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2051: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2052: RAISE OKL_API.G_EXCEPTION_ERROR;
2053: END IF;
2054: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
2055: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2056:

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

2059: p_khr_id => p_khr_id,
2060: x_pricing_engine => l_pricing_engine,
2061: x_return_status => l_return_status);
2062:
2063: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2064: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_stream_util.get_pricing_engine');
2065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2067: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_stream_util.get_pricing_engine');

Line 2065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2061: x_return_status => l_return_status);
2062:
2063: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2064: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_stream_util.get_pricing_engine');
2065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2067: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_stream_util.get_pricing_engine');
2068: RAISE OKL_API.G_EXCEPTION_ERROR;
2069: END IF;

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

2062:
2063: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2064: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_stream_util.get_pricing_engine');
2065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2067: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_stream_util.get_pricing_engine');
2068: RAISE OKL_API.G_EXCEPTION_ERROR;
2069: END IF;
2070:

Line 2068: RAISE OKL_API.G_EXCEPTION_ERROR;

2064: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_stream_util.get_pricing_engine');
2065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2067: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_stream_util.get_pricing_engine');
2068: RAISE OKL_API.G_EXCEPTION_ERROR;
2069: END IF;
2070:
2071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_STREAM_GEN_METHOD','ST_GEN_METHOD',l_pricing_engine));
2072:

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

2084: x_msg_data => l_msg_data,
2085: x_trx_number => l_trx_number,
2086: x_trx_status => l_trx_status);
2087:
2088: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_contract_book_pvt.generate_streams');
2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2091: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2092: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_contract_book_pvt.generate_streams');

Line 2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2086: x_trx_status => l_trx_status);
2087:
2088: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_contract_book_pvt.generate_streams');
2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2091: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2092: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_contract_book_pvt.generate_streams');
2093: RAISE OKL_API.G_EXCEPTION_ERROR;
2094: END IF;

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

2087:
2088: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_contract_book_pvt.generate_streams');
2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2091: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2092: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_contract_book_pvt.generate_streams');
2093: RAISE OKL_API.G_EXCEPTION_ERROR;
2094: END IF;
2095:

Line 2093: RAISE OKL_API.G_EXCEPTION_ERROR;

2089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in okl_contract_book_pvt.generate_streams');
2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2091: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2092: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in okl_contract_book_pvt.generate_streams');
2093: RAISE OKL_API.G_EXCEPTION_ERROR;
2094: END IF;
2095:
2096: ELSE
2097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stream Generation failed. Pricing engine not set');

Line 2098: RAISE OKL_API.G_EXCEPTION_ERROR;

2094: END IF;
2095:
2096: ELSE
2097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stream Generation failed. Pricing engine not set');
2098: RAISE OKL_API.G_EXCEPTION_ERROR;
2099: END IF;
2100:
2101: IF (l_pricing_engine = 'EXTERNAL') THEN
2102: COMMIT;

Line 2147: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

2143:
2144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stream Generation completed....');
2145: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2146:
2147: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
2148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2149:
2150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2151: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

Line 2159: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2157:
2158: EXCEPTION
2159: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2160: p_retcode := 2;
2161:
2162: --close all open cursors
2163: IF extr_strm_gen_status%ISOPEN THEN

Line 2173: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2169: IF get_trx_number%ISOPEN THEN
2170: CLOSE get_trx_number;
2171: END IF;
2172:
2173: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2174: p_api_name => l_api_name,
2175: p_pkg_name => g_pkg_name,
2176: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2177: x_msg_count => l_msg_count,

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

2172:
2173: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2174: p_api_name => l_api_name,
2175: p_pkg_name => g_pkg_name,
2176: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2177: x_msg_count => l_msg_count,
2178: x_msg_data => l_msg_data,
2179: p_api_type => g_api_type);
2180:

Line 2202: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2201:
2202: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2203: p_retcode := 2;
2204:
2205: --close all open cursors
2206: IF extr_strm_gen_status%ISOPEN THEN

Line 2216: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2212: IF get_trx_number%ISOPEN THEN
2213: CLOSE get_trx_number;
2214: END IF;
2215:
2216: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2217: p_api_name => l_api_name,
2218: p_pkg_name => g_pkg_name,
2219: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2220: x_msg_count => l_msg_count,

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

2215:
2216: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2217: p_api_name => l_api_name,
2218: p_pkg_name => g_pkg_name,
2219: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2220: x_msg_count => l_msg_count,
2221: x_msg_data => l_msg_data,
2222: p_api_type => g_api_type);
2223:

Line 2260: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2256: IF get_trx_number%ISOPEN THEN
2257: CLOSE get_trx_number;
2258: END IF;
2259:
2260: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2261: p_api_name => l_api_name,
2262: p_pkg_name => g_pkg_name,
2263: p_exc_name => 'OTHERS',
2264: x_msg_count => l_msg_count,

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

2310:
2311: l_api_name CONSTANT VARCHAR2(30) := 'generate_journal_entries';
2312: l_api_version CONSTANT NUMBER := 1.0;
2313: p_api_version CONSTANT NUMBER := 1.0;
2314: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2315: l_init_msg_list VARCHAR2(1) := 'T';
2316: l_msg_count NUMBER;
2317: l_msg_data VARCHAR2(2000);
2318: l_orig_syst_code okc_k_headers_b.orig_system_source_code%TYPE;

Line 2345: l_return_status := OKL_API.START_ACTIVITY(l_api_name

2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2344:
2345: l_return_status := OKL_API.START_ACTIVITY(l_api_name
2346: ,G_PKG_NAME
2347: ,l_init_msg_list
2348: ,l_api_version
2349: ,p_api_version

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

2349: ,p_api_version
2350: ,'_PVT'
2351: ,l_return_status);
2352:
2353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2357: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2351: ,l_return_status);
2352:
2353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2357: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2358: RAISE OKL_API.G_EXCEPTION_ERROR;
2359: END IF;

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

2352:
2353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2357: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2358: RAISE OKL_API.G_EXCEPTION_ERROR;
2359: END IF;
2360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 2358: RAISE OKL_API.G_EXCEPTION_ERROR;

2354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
2357: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2358: RAISE OKL_API.G_EXCEPTION_ERROR;
2359: END IF;
2360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
2361: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2362:

Line 2369: l_return_status := OKL_API.G_RET_STS_ERROR;

2365: FETCH orig_syst_csr INTO l_orig_syst_code,l_orig_syst_id;
2366: IF orig_syst_csr%NOTFOUND THEN
2367: --error : contract does not exist
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Contract Number is not valid.');
2369: l_return_status := OKL_API.G_RET_STS_ERROR;
2370: RAISE OKL_API.G_EXCEPTION_ERROR;
2371: END IF;
2372: CLOSE orig_syst_csr;
2373:

Line 2370: RAISE OKL_API.G_EXCEPTION_ERROR;

2366: IF orig_syst_csr%NOTFOUND THEN
2367: --error : contract does not exist
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Contract Number is not valid.');
2369: l_return_status := OKL_API.G_RET_STS_ERROR;
2370: RAISE OKL_API.G_EXCEPTION_ERROR;
2371: END IF;
2372: CLOSE orig_syst_csr;
2373:
2374: --if contract is in rebook process

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

2384: x_return_status => l_return_status,
2385: x_msg_count => l_msg_count,
2386: x_msg_data => l_msg_data);
2387:
2388: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2389: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2392: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');

Line 2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2386: x_msg_data => l_msg_data);
2387:
2388: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2389: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2392: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');
2393: RAISE OKL_API.G_EXCEPTION_ERROR;
2394: END IF;

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

2387:
2388: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2389: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2392: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');
2393: RAISE OKL_API.G_EXCEPTION_ERROR;
2394: END IF;
2395:

Line 2393: RAISE OKL_API.G_EXCEPTION_ERROR;

2389: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2392: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');
2393: RAISE OKL_API.G_EXCEPTION_ERROR;
2394: END IF;
2395:
2396: END IF; --end entries for rebook
2397:

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

2406: x_return_status => l_return_status,
2407: x_msg_count => l_msg_count,
2408: x_msg_data => l_msg_data);
2409:
2410: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');

Line 2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2408: x_msg_data => l_msg_data);
2409:
2410: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');
2415: RAISE OKL_API.G_EXCEPTION_ERROR;
2416: END IF;

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

2409:
2410: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');
2415: RAISE OKL_API.G_EXCEPTION_ERROR;
2416: END IF;
2417:

Line 2415: RAISE OKL_API.G_EXCEPTION_ERROR;

2411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.generate_journal_entries');
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.generate_journal_entries');
2415: RAISE OKL_API.G_EXCEPTION_ERROR;
2416: END IF;
2417:
2418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Journal Entries generated successfully....');
2419: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2421: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

2417:
2418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Journal Entries generated successfully....');
2419: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2420:
2421: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
2422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2423:
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

Line 2433: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2431:
2432: EXCEPTION
2433: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2434: p_retcode := 2;
2435:
2436: --close open cursors
2437: IF orig_syst_csr%ISOPEN THEN

Line 2441: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2437: IF orig_syst_csr%ISOPEN THEN
2438: CLOSE orig_syst_csr;
2439: END IF;
2440:
2441: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2442: p_api_name => l_api_name,
2443: p_pkg_name => g_pkg_name,
2444: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2445: x_msg_count => l_msg_count,

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

2440:
2441: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2442: p_api_name => l_api_name,
2443: p_pkg_name => g_pkg_name,
2444: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2445: x_msg_count => l_msg_count,
2446: x_msg_data => l_msg_data,
2447: p_api_type => g_api_type);
2448:

Line 2470: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2469:
2470: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2471: p_retcode := 2;
2472:
2473: --close open cursors
2474: IF orig_syst_csr%ISOPEN THEN

Line 2478: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2474: IF orig_syst_csr%ISOPEN THEN
2475: CLOSE orig_syst_csr;
2476: END IF;
2477:
2478: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2479: p_api_name => l_api_name,
2480: p_pkg_name => g_pkg_name,
2481: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2482: x_msg_count => l_msg_count,

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

2477:
2478: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2479: p_api_name => l_api_name,
2480: p_pkg_name => g_pkg_name,
2481: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2482: x_msg_count => l_msg_count,
2483: x_msg_data => l_msg_data,
2484: p_api_type => g_api_type);
2485:

Line 2516: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2512: IF orig_syst_csr%ISOPEN THEN
2513: CLOSE orig_syst_csr;
2514: END IF;
2515:
2516: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2517: p_api_name => l_api_name,
2518: p_pkg_name => g_pkg_name,
2519: p_exc_name => 'OTHERS',
2520: x_msg_count => l_msg_count,

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

2565:
2566: l_api_name CONSTANT VARCHAR2(30) := 'submit_for_approval';
2567: l_api_version CONSTANT NUMBER := 1.0;
2568: p_api_version CONSTANT NUMBER := 1.0;
2569: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2570: l_init_msg_list VARCHAR2(1) := 'T';
2571: l_msg_count NUMBER;
2572: l_msg_data VARCHAR2(2000);
2573: l_msg_token_tbl msg_token_tbl;

Line 2591: l_return_status := OKL_API.START_ACTIVITY(l_api_name

2587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2590:
2591: l_return_status := OKL_API.START_ACTIVITY(l_api_name
2592: ,G_PKG_NAME
2593: ,l_init_msg_list
2594: ,l_api_version
2595: ,p_api_version

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

2595: ,p_api_version
2596: ,'_PVT'
2597: ,l_return_status);
2598:
2599: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2602: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2603: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 2601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2597: ,l_return_status);
2598:
2599: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2602: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2603: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2604: RAISE OKL_API.G_EXCEPTION_ERROR;
2605: END IF;

Line 2602: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2598:
2599: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2602: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2603: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2604: RAISE OKL_API.G_EXCEPTION_ERROR;
2605: END IF;
2606: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 2604: RAISE OKL_API.G_EXCEPTION_ERROR;

2600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2602: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2603: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2604: RAISE OKL_API.G_EXCEPTION_ERROR;
2605: END IF;
2606: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
2607: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2608:

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

2614: x_msg_count => l_msg_count,
2615: x_msg_data => l_msg_data,
2616: p_chr_id => p_khr_id);
2617:
2618: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.submit_for_approval');
2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2622: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.submit_for_approval');

Line 2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2616: p_chr_id => p_khr_id);
2617:
2618: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.submit_for_approval');
2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2622: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.submit_for_approval');
2623: RAISE OKL_API.G_EXCEPTION_ERROR;
2624: END IF;

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

2617:
2618: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.submit_for_approval');
2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2622: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.submit_for_approval');
2623: RAISE OKL_API.G_EXCEPTION_ERROR;
2624: END IF;
2625:

Line 2623: RAISE OKL_API.G_EXCEPTION_ERROR;

2619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pub.submit_for_approval');
2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2622: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pub.submit_for_approval');
2623: RAISE OKL_API.G_EXCEPTION_ERROR;
2624: END IF;
2625:
2626: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract Approved successfully....');
2627: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2629: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

2625:
2626: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract Approved successfully....');
2627: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2628:
2629: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
2630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2631:
2632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

Line 2641: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2639:
2640: EXCEPTION
2641: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2642: p_retcode := 2;
2643: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2644: p_api_name => l_api_name,
2645: p_pkg_name => g_pkg_name,

Line 2643: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2639:
2640: EXCEPTION
2641: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2642: p_retcode := 2;
2643: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2644: p_api_name => l_api_name,
2645: p_pkg_name => g_pkg_name,
2646: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2647: x_msg_count => l_msg_count,

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

2642: p_retcode := 2;
2643: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2644: p_api_name => l_api_name,
2645: p_pkg_name => g_pkg_name,
2646: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2647: x_msg_count => l_msg_count,
2648: x_msg_data => l_msg_data,
2649: p_api_type => g_api_type);
2650:

Line 2672: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2671:
2672: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2673: p_retcode := 2;
2674: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2675: p_api_name => l_api_name,
2676: p_pkg_name => g_pkg_name,

Line 2674: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2671:
2672: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2673: p_retcode := 2;
2674: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2675: p_api_name => l_api_name,
2676: p_pkg_name => g_pkg_name,
2677: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2678: x_msg_count => l_msg_count,

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

2673: p_retcode := 2;
2674: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2675: p_api_name => l_api_name,
2676: p_pkg_name => g_pkg_name,
2677: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2678: x_msg_count => l_msg_count,
2679: x_msg_data => l_msg_data,
2680: p_api_type => g_api_type);
2681:

Line 2706: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2702:
2703: WHEN OTHERS THEN
2704: p_retcode := 2;
2705: p_errbuf := SQLERRM;
2706: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2707: p_api_name => l_api_name,
2708: p_pkg_name => g_pkg_name,
2709: p_exc_name => 'OTHERS',
2710: x_msg_count => l_msg_count,

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

2755:
2756: l_api_name CONSTANT VARCHAR2(30) := 'activate_contract';
2757: l_api_version CONSTANT NUMBER := 1.0;
2758: p_api_version CONSTANT NUMBER := 1.0;
2759: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2760: l_init_msg_list VARCHAR2(1) := 'T';
2761: l_msg_count NUMBER;
2762: l_msg_data VARCHAR2(2000);
2763: l_rem_amt NUMBER;

Line 2785: l_return_status := OKL_API.START_ACTIVITY(l_api_name

2781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2784:
2785: l_return_status := OKL_API.START_ACTIVITY(l_api_name
2786: ,G_PKG_NAME
2787: ,l_init_msg_list
2788: ,l_api_version
2789: ,p_api_version

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

2789: ,p_api_version
2790: ,'_PVT'
2791: ,l_return_status);
2792:
2793: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 2795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2791: ,l_return_status);
2792:
2793: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2798: RAISE OKL_API.G_EXCEPTION_ERROR;
2799: END IF;

Line 2796: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2792:
2793: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2798: RAISE OKL_API.G_EXCEPTION_ERROR;
2799: END IF;
2800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 2798: RAISE OKL_API.G_EXCEPTION_ERROR;

2794: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
2795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
2798: RAISE OKL_API.G_EXCEPTION_ERROR;
2799: END IF;
2800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
2801: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2802:

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

2809: x_msg_data => l_msg_data,
2810: p_chr_id => p_khr_id,
2811: x_process_status => l_process_status);
2812:
2813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.approve_activate_contract');
2815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.approve_activate_contract');

Line 2815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2811: x_process_status => l_process_status);
2812:
2813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.approve_activate_contract');
2815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.approve_activate_contract');
2818: RAISE OKL_API.G_EXCEPTION_ERROR;
2819: END IF;

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

2812:
2813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.approve_activate_contract');
2815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.approve_activate_contract');
2818: RAISE OKL_API.G_EXCEPTION_ERROR;
2819: END IF;
2820:

Line 2818: RAISE OKL_API.G_EXCEPTION_ERROR;

2814: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.approve_activate_contract');
2815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.approve_activate_contract');
2818: RAISE OKL_API.G_EXCEPTION_ERROR;
2819: END IF;
2820:
2821: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN
2822: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

Line 2821: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN

2817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.approve_activate_contract');
2818: RAISE OKL_API.G_EXCEPTION_ERROR;
2819: END IF;
2820:
2821: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN
2822: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2825: -- print the error message in the output file

Line 2841: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN

2837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2839: END IF;
2840:
2841: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN
2842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract Activated successfully....');
2843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');

Line 2852: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN

2848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2849: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2850: END IF;
2851:
2852: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN
2853: p_retcode := 2;
2854: END IF;
2855:
2856: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 2856: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

2852: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN
2853: p_retcode := 2;
2854: END IF;
2855:
2856: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
2857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2858:
2859:
2860: EXCEPTION

Line 2861: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2858:
2859:
2860: EXCEPTION
2861: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2862: p_retcode := 2;
2863: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2864: p_api_name => l_api_name,
2865: p_pkg_name => g_pkg_name,

Line 2863: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2859:
2860: EXCEPTION
2861: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2862: p_retcode := 2;
2863: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2864: p_api_name => l_api_name,
2865: p_pkg_name => g_pkg_name,
2866: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2867: x_msg_count => l_msg_count,

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

2862: p_retcode := 2;
2863: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2864: p_api_name => l_api_name,
2865: p_pkg_name => g_pkg_name,
2866: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2867: x_msg_count => l_msg_count,
2868: x_msg_data => l_msg_data,
2869: p_api_type => g_api_type);
2870:

Line 2892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2888: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2889: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2890: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2891:
2892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2893: p_retcode := 2;
2894: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2895: p_api_name => l_api_name,
2896: p_pkg_name => g_pkg_name,

Line 2894: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2890: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2891:
2892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2893: p_retcode := 2;
2894: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2895: p_api_name => l_api_name,
2896: p_pkg_name => g_pkg_name,
2897: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2898: x_msg_count => l_msg_count,

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

2893: p_retcode := 2;
2894: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2895: p_api_name => l_api_name,
2896: p_pkg_name => g_pkg_name,
2897: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2898: x_msg_count => l_msg_count,
2899: x_msg_data => l_msg_data,
2900: p_api_type => g_api_type);
2901:

Line 2926: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2922:
2923: WHEN OTHERS THEN
2924: p_retcode := 2;
2925: p_errbuf := SQLERRM;
2926: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2927: p_api_name => l_api_name,
2928: p_pkg_name => g_pkg_name,
2929: p_exc_name => 'OTHERS',
2930: x_msg_count => l_msg_count,

Line 3014: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'Begin(+)');
3011: END IF;
3012:
3013: x_batch_number := null;
3014: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3015:
3016: x_return_status := OKL_API.START_ACTIVITY(
3017: p_api_name => l_api_name,
3018: p_pkg_name => g_pkg_name,

Line 3016: x_return_status := OKL_API.START_ACTIVITY(

3012:
3013: x_batch_number := null;
3014: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3015:
3016: x_return_status := OKL_API.START_ACTIVITY(
3017: p_api_name => l_api_name,
3018: p_pkg_name => g_pkg_name,
3019: p_init_msg_list => p_init_msg_list,
3020: l_api_version => l_api_version,

Line 3026: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3022: p_api_type => g_api_type,
3023: x_return_status => x_return_status);
3024:
3025: -- check if activity started successfully
3026: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3027: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3028: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3029: RAISE OKL_API.G_EXCEPTION_ERROR;
3030: END IF;

Line 3027: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3023: x_return_status => x_return_status);
3024:
3025: -- check if activity started successfully
3026: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3027: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3028: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3029: RAISE OKL_API.G_EXCEPTION_ERROR;
3030: END IF;
3031:

Line 3028: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3024:
3025: -- check if activity started successfully
3026: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3027: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3028: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3029: RAISE OKL_API.G_EXCEPTION_ERROR;
3030: END IF;
3031:
3032: OPEN c_book_ctrl_trx(p_khr_id => p_khr_id);

Line 3029: RAISE OKL_API.G_EXCEPTION_ERROR;

3025: -- check if activity started successfully
3026: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3027: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3028: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3029: RAISE OKL_API.G_EXCEPTION_ERROR;
3030: END IF;
3031:
3032: OPEN c_book_ctrl_trx(p_khr_id => p_khr_id);
3033: FETCH c_book_ctrl_trx INTO l_exists;

Line 3039: IF(l_batch_num IS NULL OR l_batch_num = OKL_API.G_MISS_NUM) THEN

3035:
3036: IF (l_exists = 'N') THEN
3037: --get new batch number from sequence
3038: l_batch_num := get_batch_id;
3039: IF(l_batch_num IS NULL OR l_batch_num = OKL_API.G_MISS_NUM) THEN
3040: --raise error if batch number could not be generated from seq.
3041: RAISE OKL_API.G_EXCEPTION_ERROR;
3042: END IF;
3043:

Line 3041: RAISE OKL_API.G_EXCEPTION_ERROR;

3037: --get new batch number from sequence
3038: l_batch_num := get_batch_id;
3039: IF(l_batch_num IS NULL OR l_batch_num = OKL_API.G_MISS_NUM) THEN
3040: --raise error if batch number could not be generated from seq.
3041: RAISE OKL_API.G_EXCEPTION_ERROR;
3042: END IF;
3043:
3044: --fetch the current status of the contract
3045: OPEN get_curr_sts_code(p_khr_id);

Line 3127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3123: x_msg_data => x_msg_data,
3124: p_bct_tbl => l_bct_tbl,
3125: x_bct_tbl => lx_bct_tbl);
3126:
3127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3130: RAISE OKL_API.G_EXCEPTION_ERROR;
3131: END IF;

Line 3128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3124: p_bct_tbl => l_bct_tbl,
3125: x_bct_tbl => lx_bct_tbl);
3126:
3127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3130: RAISE OKL_API.G_EXCEPTION_ERROR;
3131: END IF;
3132:

Line 3129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3125: x_bct_tbl => lx_bct_tbl);
3126:
3127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3130: RAISE OKL_API.G_EXCEPTION_ERROR;
3131: END IF;
3132:
3133: x_batch_number := l_batch_num;

Line 3130: RAISE OKL_API.G_EXCEPTION_ERROR;

3126:
3127: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3130: RAISE OKL_API.G_EXCEPTION_ERROR;
3131: END IF;
3132:
3133: x_batch_number := l_batch_num;
3134:

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

3136:
3137: END IF;
3138:
3139:
3140: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3141: x_msg_data => x_msg_data);
3142:
3143: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');

Line 3148: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');
3145: END IF;
3146:
3147: EXCEPTION
3148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3150: p_api_name => l_api_name,
3151: p_pkg_name => g_pkg_name,
3152: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3145: END IF;
3146:
3147: EXCEPTION
3148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3150: p_api_name => l_api_name,
3151: p_pkg_name => g_pkg_name,
3152: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3153: x_msg_count => x_msg_count,

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

3148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3150: p_api_name => l_api_name,
3151: p_pkg_name => g_pkg_name,
3152: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3153: x_msg_count => x_msg_count,
3154: x_msg_data => x_msg_data,
3155: p_api_type => g_api_type);
3156:

Line 3161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3157: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');
3159: END IF;
3160:
3161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3162: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3163: p_api_name => l_api_name,
3164: p_pkg_name => g_pkg_name,
3165: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3162: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');
3159: END IF;
3160:
3161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3162: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3163: p_api_name => l_api_name,
3164: p_pkg_name => g_pkg_name,
3165: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3166: x_msg_count => x_msg_count,

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

3161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3162: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3163: p_api_name => l_api_name,
3164: p_pkg_name => g_pkg_name,
3165: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3166: x_msg_count => x_msg_count,
3167: x_msg_data => x_msg_data,
3168: p_api_type => g_api_type);
3169:

Line 3175: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3171: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - UNEXCP ERROR');
3172: END IF;
3173:
3174: WHEN OTHERS THEN
3175: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3176: p_api_name => l_api_name,
3177: p_pkg_name => g_pkg_name,
3178: p_exc_name => 'OTHERS',
3179: x_msg_count => x_msg_count,

Line 3211: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,

3207: x_msg_count OUT NOCOPY NUMBER,
3208: x_msg_data OUT NOCOPY VARCHAR2,
3209: p_khr_id IN okc_k_headers_b.id%TYPE,
3210: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
3211: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
3212: p_progress_status IN okl_book_controller_trx.progress_status%TYPE) IS
3213:
3214: l_api_name CONSTANT VARCHAR2(30) := 'update_book_controller_trx';
3215: l_api_version CONSTANT NUMBER := 1.0;

Line 3232: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3228: BEGIN
3229: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3230: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
3231: END IF;
3232: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3233:
3234: x_return_status := OKL_API.START_ACTIVITY(
3235: p_api_name => l_api_name,
3236: p_pkg_name => g_pkg_name,

Line 3234: x_return_status := OKL_API.START_ACTIVITY(

3230: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
3231: END IF;
3232: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3233:
3234: x_return_status := OKL_API.START_ACTIVITY(
3235: p_api_name => l_api_name,
3236: p_pkg_name => g_pkg_name,
3237: p_init_msg_list => p_init_msg_list,
3238: l_api_version => l_api_version,

Line 3244: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3240: p_api_type => g_api_type,
3241: x_return_status => x_return_status);
3242:
3243: -- check if activity started successfully
3244: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3247: RAISE OKL_API.G_EXCEPTION_ERROR;
3248: END IF;

Line 3245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3241: x_return_status => x_return_status);
3242:
3243: -- check if activity started successfully
3244: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3247: RAISE OKL_API.G_EXCEPTION_ERROR;
3248: END IF;
3249:

Line 3246: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3242:
3243: -- check if activity started successfully
3244: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3247: RAISE OKL_API.G_EXCEPTION_ERROR;
3248: END IF;
3249:
3250: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN

Line 3247: RAISE OKL_API.G_EXCEPTION_ERROR;

3243: -- check if activity started successfully
3244: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3247: RAISE OKL_API.G_EXCEPTION_ERROR;
3248: END IF;
3249:
3250: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3251: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3250: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN

3246: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3247: RAISE OKL_API.G_EXCEPTION_ERROR;
3248: END IF;
3249:
3250: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3251: RAISE OKL_API.G_EXCEPTION_ERROR;
3252: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3253: RAISE OKL_API.G_EXCEPTION_ERROR;
3254: END IF;

Line 3251: RAISE OKL_API.G_EXCEPTION_ERROR;

3247: RAISE OKL_API.G_EXCEPTION_ERROR;
3248: END IF;
3249:
3250: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3251: RAISE OKL_API.G_EXCEPTION_ERROR;
3252: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3253: RAISE OKL_API.G_EXCEPTION_ERROR;
3254: END IF;
3255:

Line 3252: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN

3248: END IF;
3249:
3250: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3251: RAISE OKL_API.G_EXCEPTION_ERROR;
3252: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3253: RAISE OKL_API.G_EXCEPTION_ERROR;
3254: END IF;
3255:
3256: OPEN c_book_ctrl_trx(p_khr_id,p_prog_short_name);

Line 3253: RAISE OKL_API.G_EXCEPTION_ERROR;

3249:
3250: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3251: RAISE OKL_API.G_EXCEPTION_ERROR;
3252: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3253: RAISE OKL_API.G_EXCEPTION_ERROR;
3254: END IF;
3255:
3256: OPEN c_book_ctrl_trx(p_khr_id,p_prog_short_name);
3257: LOOP

Line 3267: IF (p_conc_req_id = OKL_API.G_MISS_NUM) THEN

3263: l_bct_rec.processing_srl_number := l_book_ctrl_trx.processing_srl_number;
3264: l_bct_rec.khr_id := l_book_ctrl_trx.khr_id;
3265: l_bct_rec.program_name := l_book_ctrl_trx.program_name;
3266: l_bct_rec.prog_short_name := l_book_ctrl_trx.prog_short_name;
3267: IF (p_conc_req_id = OKL_API.G_MISS_NUM) THEN
3268: l_bct_rec.conc_req_id := l_book_ctrl_trx.conc_req_id;
3269: ELSE
3270: l_bct_rec.conc_req_id := p_conc_req_id;
3271: END IF;

Line 3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3281: x_msg_data => x_msg_data,
3282: p_bct_rec => l_bct_rec,
3283: x_bct_rec => x_bct_rec);
3284:
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3288: RAISE OKL_API.G_EXCEPTION_ERROR;
3289: END IF;

Line 3286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3282: p_bct_rec => l_bct_rec,
3283: x_bct_rec => x_bct_rec);
3284:
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3288: RAISE OKL_API.G_EXCEPTION_ERROR;
3289: END IF;
3290: END LOOP;

Line 3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3283: x_bct_rec => x_bct_rec);
3284:
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3288: RAISE OKL_API.G_EXCEPTION_ERROR;
3289: END IF;
3290: END LOOP;
3291: CLOSE c_book_ctrl_trx;

Line 3288: RAISE OKL_API.G_EXCEPTION_ERROR;

3284:
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3288: RAISE OKL_API.G_EXCEPTION_ERROR;
3289: END IF;
3290: END LOOP;
3291: CLOSE c_book_ctrl_trx;
3292:

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

3289: END IF;
3290: END LOOP;
3291: CLOSE c_book_ctrl_trx;
3292:
3293: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3294: x_msg_data => x_msg_data);
3295:
3296: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');

Line 3301: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');
3298: END IF;
3299:
3300: EXCEPTION
3301: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3302: IF (c_book_ctrl_trx%ISOPEN) THEN
3303: CLOSE c_book_ctrl_trx;
3304: END IF;
3305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3301: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3302: IF (c_book_ctrl_trx%ISOPEN) THEN
3303: CLOSE c_book_ctrl_trx;
3304: END IF;
3305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3306: p_api_name => l_api_name,
3307: p_pkg_name => g_pkg_name,
3308: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3309: x_msg_count => x_msg_count,

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

3304: END IF;
3305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3306: p_api_name => l_api_name,
3307: p_pkg_name => g_pkg_name,
3308: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3309: x_msg_count => x_msg_count,
3310: x_msg_data => x_msg_data,
3311: p_api_type => g_api_type);
3312:

Line 3317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3313: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');
3315: END IF;
3316:
3317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3318: IF (c_book_ctrl_trx%ISOPEN) THEN
3319: CLOSE c_book_ctrl_trx;
3320: END IF;
3321: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3321: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3318: IF (c_book_ctrl_trx%ISOPEN) THEN
3319: CLOSE c_book_ctrl_trx;
3320: END IF;
3321: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3322: p_api_name => l_api_name,
3323: p_pkg_name => g_pkg_name,
3324: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3325: x_msg_count => x_msg_count,

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

3320: END IF;
3321: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3322: p_api_name => l_api_name,
3323: p_pkg_name => g_pkg_name,
3324: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3325: x_msg_count => x_msg_count,
3326: x_msg_data => x_msg_data,
3327: p_api_type => g_api_type);
3328:

Line 3337: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3333: WHEN OTHERS THEN
3334: IF (c_book_ctrl_trx%ISOPEN) THEN
3335: CLOSE c_book_ctrl_trx;
3336: END IF;
3337: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3338: p_api_name => l_api_name,
3339: p_pkg_name => g_pkg_name,
3340: p_exc_name => 'OTHERS',
3341: x_msg_count => x_msg_count,

Line 3379: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3375: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'Begin(+)');
3377: END IF;
3378:
3379: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3380:
3381: x_return_status := OKL_API.START_ACTIVITY(
3382: p_api_name => l_api_name,
3383: p_pkg_name => g_pkg_name,

Line 3381: x_return_status := OKL_API.START_ACTIVITY(

3377: END IF;
3378:
3379: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3380:
3381: x_return_status := OKL_API.START_ACTIVITY(
3382: p_api_name => l_api_name,
3383: p_pkg_name => g_pkg_name,
3384: p_init_msg_list => p_init_msg_list,
3385: l_api_version => l_api_version,

Line 3391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3387: p_api_type => g_api_type,
3388: x_return_status => x_return_status);
3389:
3390: -- check if activity started successfully
3391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3394: RAISE OKL_API.G_EXCEPTION_ERROR;
3395: END IF;

Line 3392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3388: x_return_status => x_return_status);
3389:
3390: -- check if activity started successfully
3391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3394: RAISE OKL_API.G_EXCEPTION_ERROR;
3395: END IF;
3396:

Line 3393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3389:
3390: -- check if activity started successfully
3391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3394: RAISE OKL_API.G_EXCEPTION_ERROR;
3395: END IF;
3396:
3397: okl_contract_status_pub.update_contract_status(

Line 3394: RAISE OKL_API.G_EXCEPTION_ERROR;

3390: -- check if activity started successfully
3391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3394: RAISE OKL_API.G_EXCEPTION_ERROR;
3395: END IF;
3396:
3397: okl_contract_status_pub.update_contract_status(
3398: p_api_version => p_api_version,

Line 3405: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3401: x_msg_count => x_msg_count,
3402: x_msg_data => x_msg_data,
3403: p_khr_status => 'INCOMPLETE',
3404: p_chr_id => p_khr_id);
3405: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3407: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3408: RAISE OKL_API.G_EXCEPTION_ERROR;
3409: END IF;

Line 3406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3402: x_msg_data => x_msg_data,
3403: p_khr_status => 'INCOMPLETE',
3404: p_chr_id => p_khr_id);
3405: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3407: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3408: RAISE OKL_API.G_EXCEPTION_ERROR;
3409: END IF;
3410:

Line 3407: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3403: p_khr_status => 'INCOMPLETE',
3404: p_chr_id => p_khr_id);
3405: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3407: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3408: RAISE OKL_API.G_EXCEPTION_ERROR;
3409: END IF;
3410:
3411: okl_contract_status_pub.cascade_lease_status

Line 3408: RAISE OKL_API.G_EXCEPTION_ERROR;

3404: p_chr_id => p_khr_id);
3405: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3406: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3407: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3408: RAISE OKL_API.G_EXCEPTION_ERROR;
3409: END IF;
3410:
3411: okl_contract_status_pub.cascade_lease_status
3412: (p_api_version => p_api_version,

Line 3419: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3415: x_msg_count => x_msg_count,
3416: x_msg_data => x_msg_data,
3417: p_chr_id => p_khr_id);
3418:
3419: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3421: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3422: RAISE OKL_API.G_EXCEPTION_ERROR;
3423: END IF;

Line 3420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3416: x_msg_data => x_msg_data,
3417: p_chr_id => p_khr_id);
3418:
3419: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3421: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3422: RAISE OKL_API.G_EXCEPTION_ERROR;
3423: END IF;
3424:

Line 3421: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3417: p_chr_id => p_khr_id);
3418:
3419: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3421: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3422: RAISE OKL_API.G_EXCEPTION_ERROR;
3423: END IF;
3424:
3425: FOR i in 1..4

Line 3422: RAISE OKL_API.G_EXCEPTION_ERROR;

3418:
3419: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3420: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3421: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3422: RAISE OKL_API.G_EXCEPTION_ERROR;
3423: END IF;
3424:
3425: FOR i in 1..4
3426: LOOP

Line 3448: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3444: p_prog_short_name => l_prog_short_name,
3445: p_conc_req_id => NULL,
3446: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
3447:
3448: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3450: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3451: RAISE OKL_API.G_EXCEPTION_ERROR;
3452: END IF;

Line 3449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3445: p_conc_req_id => NULL,
3446: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
3447:
3448: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3450: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3451: RAISE OKL_API.G_EXCEPTION_ERROR;
3452: END IF;
3453:

Line 3450: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3446: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
3447:
3448: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3450: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3451: RAISE OKL_API.G_EXCEPTION_ERROR;
3452: END IF;
3453:
3454: END LOOP;

Line 3451: RAISE OKL_API.G_EXCEPTION_ERROR;

3447:
3448: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3450: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3451: RAISE OKL_API.G_EXCEPTION_ERROR;
3452: END IF;
3453:
3454: END LOOP;
3455:

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

3453:
3454: END LOOP;
3455:
3456:
3457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3458: x_msg_data => x_msg_data);
3459:
3460: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3461: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');

Line 3465: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3461: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');
3462: END IF;
3463:
3464: EXCEPTION
3465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3467: p_api_name => l_api_name,
3468: p_pkg_name => g_pkg_name,
3469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3462: END IF;
3463:
3464: EXCEPTION
3465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3467: p_api_name => l_api_name,
3468: p_pkg_name => g_pkg_name,
3469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3470: x_msg_count => x_msg_count,

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

3465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3467: p_api_name => l_api_name,
3468: p_pkg_name => g_pkg_name,
3469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3470: x_msg_count => x_msg_count,
3471: x_msg_data => x_msg_data,
3472: p_api_type => g_api_type);
3473:

Line 3478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3474: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');
3476: END IF;
3477:
3478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3479: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3480: p_api_name => l_api_name,
3481: p_pkg_name => g_pkg_name,
3482: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3479: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');
3476: END IF;
3477:
3478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3479: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3480: p_api_name => l_api_name,
3481: p_pkg_name => g_pkg_name,
3482: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3483: x_msg_count => x_msg_count,

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

3478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3479: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3480: p_api_name => l_api_name,
3481: p_pkg_name => g_pkg_name,
3482: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3483: x_msg_count => x_msg_count,
3484: x_msg_data => x_msg_data,
3485: p_api_type => g_api_type);
3486:

Line 3492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3488: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - UNEXCP ERROR');
3489: END IF;
3490:
3491: WHEN OTHERS THEN
3492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3493: p_api_name => l_api_name,
3494: p_pkg_name => g_pkg_name,
3495: p_exc_name => 'OTHERS',
3496: x_msg_count => x_msg_count,

Line 3543: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3539: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'Begin(+)');
3541: END IF;
3542:
3543: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3544:
3545: x_return_status := OKL_API.START_ACTIVITY(
3546: p_api_name => l_api_name,
3547: p_pkg_name => g_pkg_name,

Line 3545: x_return_status := OKL_API.START_ACTIVITY(

3541: END IF;
3542:
3543: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3544:
3545: x_return_status := OKL_API.START_ACTIVITY(
3546: p_api_name => l_api_name,
3547: p_pkg_name => g_pkg_name,
3548: p_init_msg_list => p_init_msg_list,
3549: l_api_version => l_api_version,

Line 3555: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3551: p_api_type => g_api_type,
3552: x_return_status => x_return_status);
3553:
3554: -- check if activity started successfully
3555: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3557: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3558: RAISE OKL_API.G_EXCEPTION_ERROR;
3559: END IF;

Line 3556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3552: x_return_status => x_return_status);
3553:
3554: -- check if activity started successfully
3555: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3557: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3558: RAISE OKL_API.G_EXCEPTION_ERROR;
3559: END IF;
3560:

Line 3557: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3553:
3554: -- check if activity started successfully
3555: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3557: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3558: RAISE OKL_API.G_EXCEPTION_ERROR;
3559: END IF;
3560:
3561: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_validate_contract);

Line 3558: RAISE OKL_API.G_EXCEPTION_ERROR;

3554: -- check if activity started successfully
3555: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3557: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3558: RAISE OKL_API.G_EXCEPTION_ERROR;
3559: END IF;
3560:
3561: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_validate_contract);
3562: FETCH c_book_ctrl_trx INTO l_progress_status;

Line 3578: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3574: x_msg_count => x_msg_count,
3575: x_msg_data => x_msg_data,
3576: p_chr_id => p_khr_id,
3577: x_process_status => x_process_status);
3578: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3579: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3580: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3581: RAISE OKL_API.G_EXCEPTION_ERROR;
3582: END IF;

Line 3579: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3575: x_msg_data => x_msg_data,
3576: p_chr_id => p_khr_id,
3577: x_process_status => x_process_status);
3578: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3579: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3580: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3581: RAISE OKL_API.G_EXCEPTION_ERROR;
3582: END IF;
3583: END IF;

Line 3580: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3576: p_chr_id => p_khr_id,
3577: x_process_status => x_process_status);
3578: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3579: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3580: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3581: RAISE OKL_API.G_EXCEPTION_ERROR;
3582: END IF;
3583: END IF;
3584:

Line 3581: RAISE OKL_API.G_EXCEPTION_ERROR;

3577: x_process_status => x_process_status);
3578: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3579: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3580: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3581: RAISE OKL_API.G_EXCEPTION_ERROR;
3582: END IF;
3583: END IF;
3584:
3585: ELSE

Line 3587: OKL_API.set_message(p_app_name => G_APP_NAME,

3583: END IF;
3584:
3585: ELSE
3586: -- The Contract must pass validation before upfront tax can be calculated.
3587: OKL_API.set_message(p_app_name => G_APP_NAME,
3588: p_msg_name => 'OKL_LLA_NOT_VALIDATED');
3589: RAISE OKL_API.G_EXCEPTION_ERROR;
3590: END IF;
3591:

Line 3589: RAISE OKL_API.G_EXCEPTION_ERROR;

3585: ELSE
3586: -- The Contract must pass validation before upfront tax can be calculated.
3587: OKL_API.set_message(p_app_name => G_APP_NAME,
3588: p_msg_name => 'OKL_LLA_NOT_VALIDATED');
3589: RAISE OKL_API.G_EXCEPTION_ERROR;
3590: END IF;
3591:
3592: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3593: x_msg_data => x_msg_data);

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

3588: p_msg_name => 'OKL_LLA_NOT_VALIDATED');
3589: RAISE OKL_API.G_EXCEPTION_ERROR;
3590: END IF;
3591:
3592: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3593: x_msg_data => x_msg_data);
3594:
3595: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');

Line 3600: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');
3597: END IF;
3598:
3599: EXCEPTION
3600: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3601: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3602: p_api_name => l_api_name,
3603: p_pkg_name => g_pkg_name,
3604: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3601: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3597: END IF;
3598:
3599: EXCEPTION
3600: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3601: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3602: p_api_name => l_api_name,
3603: p_pkg_name => g_pkg_name,
3604: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3605: x_msg_count => x_msg_count,

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

3600: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3601: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3602: p_api_name => l_api_name,
3603: p_pkg_name => g_pkg_name,
3604: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3605: x_msg_count => x_msg_count,
3606: x_msg_data => x_msg_data,
3607: p_api_type => g_api_type);
3608:

Line 3613: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3609: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3611: END IF;
3612:
3613: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3614: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3615: p_api_name => l_api_name,
3616: p_pkg_name => g_pkg_name,
3617: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3614: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3611: END IF;
3612:
3613: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3614: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3615: p_api_name => l_api_name,
3616: p_pkg_name => g_pkg_name,
3617: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3618: x_msg_count => x_msg_count,

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

3613: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3614: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3615: p_api_name => l_api_name,
3616: p_pkg_name => g_pkg_name,
3617: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3618: x_msg_count => x_msg_count,
3619: x_msg_data => x_msg_data,
3620: p_api_type => g_api_type);
3621:

Line 3627: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3624: END IF;
3625:
3626: WHEN OTHERS THEN
3627: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3628: p_api_name => l_api_name,
3629: p_pkg_name => g_pkg_name,
3630: p_exc_name => 'OTHERS',
3631: x_msg_count => x_msg_count,

Line 3678: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3674: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'Begin(+)');
3676: END IF;
3677:
3678: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3679:
3680: x_return_status := OKL_API.START_ACTIVITY(
3681: p_api_name => l_api_name,
3682: p_pkg_name => g_pkg_name,

Line 3680: x_return_status := OKL_API.START_ACTIVITY(

3676: END IF;
3677:
3678: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3679:
3680: x_return_status := OKL_API.START_ACTIVITY(
3681: p_api_name => l_api_name,
3682: p_pkg_name => g_pkg_name,
3683: p_init_msg_list => p_init_msg_list,
3684: l_api_version => l_api_version,

Line 3690: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3686: p_api_type => g_api_type,
3687: x_return_status => x_return_status);
3688:
3689: -- check if activity started successfully
3690: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3692: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3693: RAISE OKL_API.G_EXCEPTION_ERROR;
3694: END IF;

Line 3691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3687: x_return_status => x_return_status);
3688:
3689: -- check if activity started successfully
3690: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3692: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3693: RAISE OKL_API.G_EXCEPTION_ERROR;
3694: END IF;
3695:

Line 3692: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3688:
3689: -- check if activity started successfully
3690: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3692: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3693: RAISE OKL_API.G_EXCEPTION_ERROR;
3694: END IF;
3695:
3696: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);

Line 3693: RAISE OKL_API.G_EXCEPTION_ERROR;

3689: -- check if activity started successfully
3690: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3692: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3693: RAISE OKL_API.G_EXCEPTION_ERROR;
3694: END IF;
3695:
3696: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);
3697: FETCH c_book_ctrl_trx INTO l_progress_status;

Line 3708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3704: x_return_status => x_return_status,
3705: x_msg_count => x_msg_count,
3706: x_msg_data => x_msg_data,
3707: p_chr_id => p_khr_id);
3708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;

Line 3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3705: x_msg_count => x_msg_count,
3706: x_msg_data => x_msg_data,
3707: p_chr_id => p_khr_id);
3708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;
3713: END IF;

Line 3710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3706: x_msg_data => x_msg_data,
3707: p_chr_id => p_khr_id);
3708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;
3713: END IF;
3714:

Line 3711: RAISE OKL_API.G_EXCEPTION_ERROR;

3707: p_chr_id => p_khr_id);
3708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;
3713: END IF;
3714:
3715: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;
3713: END IF;
3714:
3715: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3716: x_msg_data => x_msg_data);
3717:
3718: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');

Line 3723: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');
3720: END IF;
3721:
3722: EXCEPTION
3723: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3724: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3725: p_api_name => l_api_name,
3726: p_pkg_name => g_pkg_name,
3727: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3724: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3720: END IF;
3721:
3722: EXCEPTION
3723: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3724: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3725: p_api_name => l_api_name,
3726: p_pkg_name => g_pkg_name,
3727: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3728: x_msg_count => x_msg_count,

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

3723: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3724: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3725: p_api_name => l_api_name,
3726: p_pkg_name => g_pkg_name,
3727: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3728: x_msg_count => x_msg_count,
3729: x_msg_data => x_msg_data,
3730: p_api_type => g_api_type);
3731:

Line 3736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3732: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3734: END IF;
3735:
3736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3738: p_api_name => l_api_name,
3739: p_pkg_name => g_pkg_name,
3740: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3734: END IF;
3735:
3736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3738: p_api_name => l_api_name,
3739: p_pkg_name => g_pkg_name,
3740: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3741: x_msg_count => x_msg_count,

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

3736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3738: p_api_name => l_api_name,
3739: p_pkg_name => g_pkg_name,
3740: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3741: x_msg_count => x_msg_count,
3742: x_msg_data => x_msg_data,
3743: p_api_type => g_api_type);
3744:

Line 3750: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3747: END IF;
3748:
3749: WHEN OTHERS THEN
3750: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3751: p_api_name => l_api_name,
3752: p_pkg_name => g_pkg_name,
3753: p_exc_name => 'OTHERS',
3754: x_msg_count => x_msg_count,

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

3780:
3781: l_api_name CONSTANT VARCHAR2(30) := 'calculate_upfront_tax';
3782: l_api_version CONSTANT NUMBER := 1.0;
3783: p_api_version CONSTANT NUMBER := 1.0;
3784: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3785: l_init_msg_list VARCHAR2(1) := 'T';
3786: l_msg_count NUMBER;
3787: l_msg_data VARCHAR2(2000);
3788: l_msg_token_tbl msg_token_tbl;

Line 3808: l_return_status := OKL_API.START_ACTIVITY(l_api_name

3804: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3805: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
3806: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3807:
3808: l_return_status := OKL_API.START_ACTIVITY(l_api_name
3809: ,G_PKG_NAME
3810: ,l_init_msg_list
3811: ,l_api_version
3812: ,p_api_version

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

3812: ,p_api_version
3813: ,'_PVT'
3814: ,l_return_status);
3815:
3816: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 3818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3814: ,l_return_status);
3815:
3816: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
3821: RAISE OKL_API.G_EXCEPTION_ERROR;
3822: END IF;

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

3815:
3816: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
3821: RAISE OKL_API.G_EXCEPTION_ERROR;
3822: END IF;
3823: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 3821: RAISE OKL_API.G_EXCEPTION_ERROR;

3817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
3821: RAISE OKL_API.G_EXCEPTION_ERROR;
3822: END IF;
3823: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
3824: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
3825:

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

3832: x_msg_data => l_msg_data,
3833: p_chr_id => p_khr_id,
3834: x_process_status => l_process_status);
3835:
3836: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3838: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3839: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');

Line 3838: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3834: x_process_status => l_process_status);
3835:
3836: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3838: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3839: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');
3841: RAISE OKL_API.G_EXCEPTION_ERROR;
3842: END IF;

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

3835:
3836: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3838: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3839: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');
3841: RAISE OKL_API.G_EXCEPTION_ERROR;
3842: END IF;
3843:

Line 3841: RAISE OKL_API.G_EXCEPTION_ERROR;

3837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3838: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3839: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');
3841: RAISE OKL_API.G_EXCEPTION_ERROR;
3842: END IF;
3843:
3844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

Line 3849: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN

3845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3848:
3849: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN
3850: -- print the error message in the output file
3851: IF (fnd_msg_pub.count_msg > 0) THEN
3852: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3853: LOOP

Line 3864: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN

3860: END LOOP;
3861: END IF;
3862: END IF;
3863:
3864: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN
3865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Upfront Tax was calculated successfully....');
3866: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
3868: END IF;

Line 3870: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN

3866: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
3868: END IF;
3869:
3870: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN
3871: p_retcode := 2;
3872: END IF;
3873:
3874: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

Line 3877: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

3873:
3874: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3875: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3876:
3877: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
3878: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
3879:
3880: EXCEPTION
3881: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3881: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3877: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
3878: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
3879:
3880: EXCEPTION
3881: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3882: p_retcode := 2;
3883:
3884: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3885: p_api_name => l_api_name,

Line 3884: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

3880: EXCEPTION
3881: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3882: p_retcode := 2;
3883:
3884: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3885: p_api_name => l_api_name,
3886: p_pkg_name => g_pkg_name,
3887: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3888: x_msg_count => l_msg_count,

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

3883:
3884: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3885: p_api_name => l_api_name,
3886: p_pkg_name => g_pkg_name,
3887: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3888: x_msg_count => l_msg_count,
3889: x_msg_data => l_msg_data,
3890: p_api_type => g_api_type);
3891:

Line 3913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3910: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3911: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3912:
3913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3914: p_retcode := 2;
3915:
3916: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3917: p_api_name => l_api_name,

Line 3916: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

3912:
3913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3914: p_retcode := 2;
3915:
3916: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3917: p_api_name => l_api_name,
3918: p_pkg_name => g_pkg_name,
3919: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3920: x_msg_count => l_msg_count,

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

3915:
3916: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3917: p_api_name => l_api_name,
3918: p_pkg_name => g_pkg_name,
3919: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3920: x_msg_count => l_msg_count,
3921: x_msg_data => l_msg_data,
3922: p_api_type => g_api_type);
3923:

Line 3949: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

3945: WHEN OTHERS THEN
3946: p_retcode := 2;
3947: p_errbuf := SQLERRM;
3948:
3949: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3950: p_api_name => l_api_name,
3951: p_pkg_name => g_pkg_name,
3952: p_exc_name => 'OTHERS',
3953: x_msg_count => l_msg_count,