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 3134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3130: x_msg_data => x_msg_data,
3131: p_bct_tbl => l_bct_tbl,
3132: x_bct_tbl => lx_bct_tbl);
3133:
3134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3137: RAISE OKL_API.G_EXCEPTION_ERROR;
3138: END IF;

Line 3135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3131: p_bct_tbl => l_bct_tbl,
3132: x_bct_tbl => lx_bct_tbl);
3133:
3134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3137: RAISE OKL_API.G_EXCEPTION_ERROR;
3138: END IF;
3139:

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

3132: x_bct_tbl => lx_bct_tbl);
3133:
3134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3137: RAISE OKL_API.G_EXCEPTION_ERROR;
3138: END IF;
3139:
3140: x_batch_number := l_batch_num;

Line 3137: RAISE OKL_API.G_EXCEPTION_ERROR;

3133:
3134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3137: RAISE OKL_API.G_EXCEPTION_ERROR;
3138: END IF;
3139:
3140: x_batch_number := l_batch_num;
3141:

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

3143:
3144: END IF;
3145:
3146:
3147: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3148: x_msg_data => x_msg_data);
3149:
3150: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');

Line 3155: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');
3152: END IF;
3153:
3154: EXCEPTION
3155: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3156: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3157: p_api_name => l_api_name,
3158: p_pkg_name => g_pkg_name,
3159: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3156: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3152: END IF;
3153:
3154: EXCEPTION
3155: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3156: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3157: p_api_name => l_api_name,
3158: p_pkg_name => g_pkg_name,
3159: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3160: x_msg_count => x_msg_count,

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

3155: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3156: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3157: p_api_name => l_api_name,
3158: p_pkg_name => g_pkg_name,
3159: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3160: x_msg_count => x_msg_count,
3161: x_msg_data => x_msg_data,
3162: p_api_type => g_api_type);
3163:

Line 3168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3164: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');
3166: END IF;
3167:
3168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3169: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3170: p_api_name => l_api_name,
3171: p_pkg_name => g_pkg_name,
3172: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3169: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');
3166: END IF;
3167:
3168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3169: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3170: p_api_name => l_api_name,
3171: p_pkg_name => g_pkg_name,
3172: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3173: x_msg_count => x_msg_count,

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

3168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3169: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3170: p_api_name => l_api_name,
3171: p_pkg_name => g_pkg_name,
3172: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3173: x_msg_count => x_msg_count,
3174: x_msg_data => x_msg_data,
3175: p_api_type => g_api_type);
3176:

Line 3182: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - UNEXCP ERROR');
3179: END IF;
3180:
3181: WHEN OTHERS THEN
3182: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3183: p_api_name => l_api_name,
3184: p_pkg_name => g_pkg_name,
3185: p_exc_name => 'OTHERS',
3186: x_msg_count => x_msg_count,

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

3214: x_msg_count OUT NOCOPY NUMBER,
3215: x_msg_data OUT NOCOPY VARCHAR2,
3216: p_khr_id IN okc_k_headers_b.id%TYPE,
3217: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
3218: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
3219: p_progress_status IN okl_book_controller_trx.progress_status%TYPE) IS
3220:
3221: l_api_name CONSTANT VARCHAR2(30) := 'update_book_controller_trx';
3222: l_api_version CONSTANT NUMBER := 1.0;

Line 3239: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3235: BEGIN
3236: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
3238: END IF;
3239: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3240:
3241: x_return_status := OKL_API.START_ACTIVITY(
3242: p_api_name => l_api_name,
3243: p_pkg_name => g_pkg_name,

Line 3241: x_return_status := OKL_API.START_ACTIVITY(

3237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
3238: END IF;
3239: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3240:
3241: x_return_status := OKL_API.START_ACTIVITY(
3242: p_api_name => l_api_name,
3243: p_pkg_name => g_pkg_name,
3244: p_init_msg_list => p_init_msg_list,
3245: l_api_version => l_api_version,

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

3247: p_api_type => g_api_type,
3248: x_return_status => x_return_status);
3249:
3250: -- check if activity started successfully
3251: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3253: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3254: RAISE OKL_API.G_EXCEPTION_ERROR;
3255: END IF;

Line 3252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3248: x_return_status => x_return_status);
3249:
3250: -- check if activity started successfully
3251: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3253: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3254: RAISE OKL_API.G_EXCEPTION_ERROR;
3255: END IF;
3256:

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

3249:
3250: -- check if activity started successfully
3251: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3253: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3254: RAISE OKL_API.G_EXCEPTION_ERROR;
3255: END IF;
3256:
3257: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN

Line 3254: RAISE OKL_API.G_EXCEPTION_ERROR;

3250: -- check if activity started successfully
3251: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3253: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3254: RAISE OKL_API.G_EXCEPTION_ERROR;
3255: END IF;
3256:
3257: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3258: RAISE OKL_API.G_EXCEPTION_ERROR;

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

3253: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3254: RAISE OKL_API.G_EXCEPTION_ERROR;
3255: END IF;
3256:
3257: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3258: RAISE OKL_API.G_EXCEPTION_ERROR;
3259: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3260: RAISE OKL_API.G_EXCEPTION_ERROR;
3261: END IF;

Line 3258: RAISE OKL_API.G_EXCEPTION_ERROR;

3254: RAISE OKL_API.G_EXCEPTION_ERROR;
3255: END IF;
3256:
3257: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3258: RAISE OKL_API.G_EXCEPTION_ERROR;
3259: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3260: RAISE OKL_API.G_EXCEPTION_ERROR;
3261: END IF;
3262:

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

3255: END IF;
3256:
3257: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3258: RAISE OKL_API.G_EXCEPTION_ERROR;
3259: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3260: RAISE OKL_API.G_EXCEPTION_ERROR;
3261: END IF;
3262:
3263: OPEN c_book_ctrl_trx(p_khr_id,p_prog_short_name);

Line 3260: RAISE OKL_API.G_EXCEPTION_ERROR;

3256:
3257: IF (p_khr_id IS NULL OR p_khr_id = OKL_API.G_MISS_NUM) THEN
3258: RAISE OKL_API.G_EXCEPTION_ERROR;
3259: ELSIF (p_progress_status IS NULL OR p_progress_status = OKL_API.G_MISS_CHAR) THEN
3260: RAISE OKL_API.G_EXCEPTION_ERROR;
3261: END IF;
3262:
3263: OPEN c_book_ctrl_trx(p_khr_id,p_prog_short_name);
3264: LOOP

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

3270: l_bct_rec.processing_srl_number := l_book_ctrl_trx.processing_srl_number;
3271: l_bct_rec.khr_id := l_book_ctrl_trx.khr_id;
3272: l_bct_rec.program_name := l_book_ctrl_trx.program_name;
3273: l_bct_rec.prog_short_name := l_book_ctrl_trx.prog_short_name;
3274: IF (p_conc_req_id = OKL_API.G_MISS_NUM) THEN
3275: l_bct_rec.conc_req_id := l_book_ctrl_trx.conc_req_id;
3276: ELSE
3277: l_bct_rec.conc_req_id := p_conc_req_id;
3278: END IF;

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

3288: x_msg_data => x_msg_data,
3289: p_bct_rec => l_bct_rec,
3290: x_bct_rec => x_bct_rec);
3291:
3292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3295: RAISE OKL_API.G_EXCEPTION_ERROR;
3296: END IF;

Line 3293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3289: p_bct_rec => l_bct_rec,
3290: x_bct_rec => x_bct_rec);
3291:
3292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3295: RAISE OKL_API.G_EXCEPTION_ERROR;
3296: END IF;
3297: END LOOP;

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

3290: x_bct_rec => x_bct_rec);
3291:
3292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3295: RAISE OKL_API.G_EXCEPTION_ERROR;
3296: END IF;
3297: END LOOP;
3298: CLOSE c_book_ctrl_trx;

Line 3295: RAISE OKL_API.G_EXCEPTION_ERROR;

3291:
3292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3295: RAISE OKL_API.G_EXCEPTION_ERROR;
3296: END IF;
3297: END LOOP;
3298: CLOSE c_book_ctrl_trx;
3299:

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

3296: END IF;
3297: END LOOP;
3298: CLOSE c_book_ctrl_trx;
3299:
3300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3301: x_msg_data => x_msg_data);
3302:
3303: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');

Line 3308: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');
3305: END IF;
3306:
3307: EXCEPTION
3308: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3309: IF (c_book_ctrl_trx%ISOPEN) THEN
3310: CLOSE c_book_ctrl_trx;
3311: END IF;
3312: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3312: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3308: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3309: IF (c_book_ctrl_trx%ISOPEN) THEN
3310: CLOSE c_book_ctrl_trx;
3311: END IF;
3312: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3313: p_api_name => l_api_name,
3314: p_pkg_name => g_pkg_name,
3315: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3316: x_msg_count => x_msg_count,

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

3311: END IF;
3312: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3313: p_api_name => l_api_name,
3314: p_pkg_name => g_pkg_name,
3315: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3316: x_msg_count => x_msg_count,
3317: x_msg_data => x_msg_data,
3318: p_api_type => g_api_type);
3319:

Line 3324: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3320: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');
3322: END IF;
3323:
3324: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3325: IF (c_book_ctrl_trx%ISOPEN) THEN
3326: CLOSE c_book_ctrl_trx;
3327: END IF;
3328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3324: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3325: IF (c_book_ctrl_trx%ISOPEN) THEN
3326: CLOSE c_book_ctrl_trx;
3327: END IF;
3328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3329: p_api_name => l_api_name,
3330: p_pkg_name => g_pkg_name,
3331: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3332: x_msg_count => x_msg_count,

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

3327: END IF;
3328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3329: p_api_name => l_api_name,
3330: p_pkg_name => g_pkg_name,
3331: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3332: x_msg_count => x_msg_count,
3333: x_msg_data => x_msg_data,
3334: p_api_type => g_api_type);
3335:

Line 3344: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3340: WHEN OTHERS THEN
3341: IF (c_book_ctrl_trx%ISOPEN) THEN
3342: CLOSE c_book_ctrl_trx;
3343: END IF;
3344: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3345: p_api_name => l_api_name,
3346: p_pkg_name => g_pkg_name,
3347: p_exc_name => 'OTHERS',
3348: x_msg_count => x_msg_count,

Line 3386: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3382: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'Begin(+)');
3384: END IF;
3385:
3386: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3387:
3388: x_return_status := OKL_API.START_ACTIVITY(
3389: p_api_name => l_api_name,
3390: p_pkg_name => g_pkg_name,

Line 3388: x_return_status := OKL_API.START_ACTIVITY(

3384: END IF;
3385:
3386: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3387:
3388: x_return_status := OKL_API.START_ACTIVITY(
3389: p_api_name => l_api_name,
3390: p_pkg_name => g_pkg_name,
3391: p_init_msg_list => p_init_msg_list,
3392: l_api_version => l_api_version,

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

3394: p_api_type => g_api_type,
3395: x_return_status => x_return_status);
3396:
3397: -- check if activity started successfully
3398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3401: RAISE OKL_API.G_EXCEPTION_ERROR;
3402: END IF;

Line 3399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3395: x_return_status => x_return_status);
3396:
3397: -- check if activity started successfully
3398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3401: RAISE OKL_API.G_EXCEPTION_ERROR;
3402: END IF;
3403:

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

3396:
3397: -- check if activity started successfully
3398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3401: RAISE OKL_API.G_EXCEPTION_ERROR;
3402: END IF;
3403:
3404: okl_contract_status_pub.update_contract_status(

Line 3401: RAISE OKL_API.G_EXCEPTION_ERROR;

3397: -- check if activity started successfully
3398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3401: RAISE OKL_API.G_EXCEPTION_ERROR;
3402: END IF;
3403:
3404: okl_contract_status_pub.update_contract_status(
3405: p_api_version => p_api_version,

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

3408: x_msg_count => x_msg_count,
3409: x_msg_data => x_msg_data,
3410: p_khr_status => 'INCOMPLETE',
3411: p_chr_id => p_khr_id);
3412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3415: RAISE OKL_API.G_EXCEPTION_ERROR;
3416: END IF;

Line 3413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3409: x_msg_data => x_msg_data,
3410: p_khr_status => 'INCOMPLETE',
3411: p_chr_id => p_khr_id);
3412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3415: RAISE OKL_API.G_EXCEPTION_ERROR;
3416: END IF;
3417:

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

3410: p_khr_status => 'INCOMPLETE',
3411: p_chr_id => p_khr_id);
3412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3415: RAISE OKL_API.G_EXCEPTION_ERROR;
3416: END IF;
3417:
3418: okl_contract_status_pub.cascade_lease_status

Line 3415: RAISE OKL_API.G_EXCEPTION_ERROR;

3411: p_chr_id => p_khr_id);
3412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3414: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3415: RAISE OKL_API.G_EXCEPTION_ERROR;
3416: END IF;
3417:
3418: okl_contract_status_pub.cascade_lease_status
3419: (p_api_version => p_api_version,

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

3422: x_msg_count => x_msg_count,
3423: x_msg_data => x_msg_data,
3424: p_chr_id => p_khr_id);
3425:
3426: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3428: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3429: RAISE OKL_API.G_EXCEPTION_ERROR;
3430: END IF;

Line 3427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3423: x_msg_data => x_msg_data,
3424: p_chr_id => p_khr_id);
3425:
3426: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3428: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3429: RAISE OKL_API.G_EXCEPTION_ERROR;
3430: END IF;
3431:

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

3424: p_chr_id => p_khr_id);
3425:
3426: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3428: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3429: RAISE OKL_API.G_EXCEPTION_ERROR;
3430: END IF;
3431:
3432: FOR i in 1..4

Line 3429: RAISE OKL_API.G_EXCEPTION_ERROR;

3425:
3426: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3428: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3429: RAISE OKL_API.G_EXCEPTION_ERROR;
3430: END IF;
3431:
3432: FOR i in 1..4
3433: LOOP

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

3451: p_prog_short_name => l_prog_short_name,
3452: p_conc_req_id => NULL,
3453: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
3454:
3455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3458: RAISE OKL_API.G_EXCEPTION_ERROR;
3459: END IF;

Line 3456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3452: p_conc_req_id => NULL,
3453: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
3454:
3455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3458: RAISE OKL_API.G_EXCEPTION_ERROR;
3459: END IF;
3460:

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

3453: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
3454:
3455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3458: RAISE OKL_API.G_EXCEPTION_ERROR;
3459: END IF;
3460:
3461: END LOOP;

Line 3458: RAISE OKL_API.G_EXCEPTION_ERROR;

3454:
3455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3458: RAISE OKL_API.G_EXCEPTION_ERROR;
3459: END IF;
3460:
3461: END LOOP;
3462:

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

3460:
3461: END LOOP;
3462:
3463:
3464: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3465: x_msg_data => x_msg_data);
3466:
3467: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');

Line 3472: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');
3469: END IF;
3470:
3471: EXCEPTION
3472: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3473: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3474: p_api_name => l_api_name,
3475: p_pkg_name => g_pkg_name,
3476: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3473: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3469: END IF;
3470:
3471: EXCEPTION
3472: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3473: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3474: p_api_name => l_api_name,
3475: p_pkg_name => g_pkg_name,
3476: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3477: x_msg_count => x_msg_count,

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

3472: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3473: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3474: p_api_name => l_api_name,
3475: p_pkg_name => g_pkg_name,
3476: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3477: x_msg_count => x_msg_count,
3478: x_msg_data => x_msg_data,
3479: p_api_type => g_api_type);
3480:

Line 3485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3481: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');
3483: END IF;
3484:
3485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3487: p_api_name => l_api_name,
3488: p_pkg_name => g_pkg_name,
3489: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');
3483: END IF;
3484:
3485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3487: p_api_name => l_api_name,
3488: p_pkg_name => g_pkg_name,
3489: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3490: x_msg_count => x_msg_count,

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

3485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3487: p_api_name => l_api_name,
3488: p_pkg_name => g_pkg_name,
3489: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3490: x_msg_count => x_msg_count,
3491: x_msg_data => x_msg_data,
3492: p_api_type => g_api_type);
3493:

Line 3499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - UNEXCP ERROR');
3496: END IF;
3497:
3498: WHEN OTHERS THEN
3499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3500: p_api_name => l_api_name,
3501: p_pkg_name => g_pkg_name,
3502: p_exc_name => 'OTHERS',
3503: x_msg_count => x_msg_count,

Line 3550: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3546: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3547: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'Begin(+)');
3548: END IF;
3549:
3550: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3551:
3552: x_return_status := OKL_API.START_ACTIVITY(
3553: p_api_name => l_api_name,
3554: p_pkg_name => g_pkg_name,

Line 3552: x_return_status := OKL_API.START_ACTIVITY(

3548: END IF;
3549:
3550: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3551:
3552: x_return_status := OKL_API.START_ACTIVITY(
3553: p_api_name => l_api_name,
3554: p_pkg_name => g_pkg_name,
3555: p_init_msg_list => p_init_msg_list,
3556: l_api_version => l_api_version,

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

3558: p_api_type => g_api_type,
3559: x_return_status => x_return_status);
3560:
3561: -- check if activity started successfully
3562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3565: RAISE OKL_API.G_EXCEPTION_ERROR;
3566: END IF;

Line 3563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3559: x_return_status => x_return_status);
3560:
3561: -- check if activity started successfully
3562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3565: RAISE OKL_API.G_EXCEPTION_ERROR;
3566: END IF;
3567:

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

3560:
3561: -- check if activity started successfully
3562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3565: RAISE OKL_API.G_EXCEPTION_ERROR;
3566: END IF;
3567:
3568: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_validate_contract);

Line 3565: RAISE OKL_API.G_EXCEPTION_ERROR;

3561: -- check if activity started successfully
3562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3565: RAISE OKL_API.G_EXCEPTION_ERROR;
3566: END IF;
3567:
3568: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_validate_contract);
3569: FETCH c_book_ctrl_trx INTO l_progress_status;

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

3581: x_msg_count => x_msg_count,
3582: x_msg_data => x_msg_data,
3583: p_chr_id => p_khr_id,
3584: x_process_status => x_process_status);
3585: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3586: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3587: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3588: RAISE OKL_API.G_EXCEPTION_ERROR;
3589: END IF;

Line 3586: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3582: x_msg_data => x_msg_data,
3583: p_chr_id => p_khr_id,
3584: x_process_status => x_process_status);
3585: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3586: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3587: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3588: RAISE OKL_API.G_EXCEPTION_ERROR;
3589: END IF;
3590: END IF;

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

3583: p_chr_id => p_khr_id,
3584: x_process_status => x_process_status);
3585: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3586: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3587: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3588: RAISE OKL_API.G_EXCEPTION_ERROR;
3589: END IF;
3590: END IF;
3591:

Line 3588: RAISE OKL_API.G_EXCEPTION_ERROR;

3584: x_process_status => x_process_status);
3585: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3586: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3587: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3588: RAISE OKL_API.G_EXCEPTION_ERROR;
3589: END IF;
3590: END IF;
3591:
3592: ELSE

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

3590: END IF;
3591:
3592: ELSE
3593: -- The Contract must pass validation before upfront tax can be calculated.
3594: OKL_API.set_message(p_app_name => G_APP_NAME,
3595: p_msg_name => 'OKL_LLA_NOT_VALIDATED');
3596: RAISE OKL_API.G_EXCEPTION_ERROR;
3597: END IF;
3598:

Line 3596: RAISE OKL_API.G_EXCEPTION_ERROR;

3592: ELSE
3593: -- The Contract must pass validation before upfront tax can be calculated.
3594: OKL_API.set_message(p_app_name => G_APP_NAME,
3595: p_msg_name => 'OKL_LLA_NOT_VALIDATED');
3596: RAISE OKL_API.G_EXCEPTION_ERROR;
3597: END IF;
3598:
3599: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3600: x_msg_data => x_msg_data);

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

3595: p_msg_name => 'OKL_LLA_NOT_VALIDATED');
3596: RAISE OKL_API.G_EXCEPTION_ERROR;
3597: END IF;
3598:
3599: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3600: x_msg_data => x_msg_data);
3601:
3602: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3603: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');

Line 3607: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3603: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');
3604: END IF;
3605:
3606: EXCEPTION
3607: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3608: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3609: p_api_name => l_api_name,
3610: p_pkg_name => g_pkg_name,
3611: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3608: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3604: END IF;
3605:
3606: EXCEPTION
3607: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3608: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3609: p_api_name => l_api_name,
3610: p_pkg_name => g_pkg_name,
3611: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3612: x_msg_count => x_msg_count,

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

3607: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3608: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3609: p_api_name => l_api_name,
3610: p_pkg_name => g_pkg_name,
3611: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3612: x_msg_count => x_msg_count,
3613: x_msg_data => x_msg_data,
3614: p_api_type => g_api_type);
3615:

Line 3620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3616: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3618: END IF;
3619:
3620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3621: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3622: p_api_name => l_api_name,
3623: p_pkg_name => g_pkg_name,
3624: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3621: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3618: END IF;
3619:
3620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3621: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3622: p_api_name => l_api_name,
3623: p_pkg_name => g_pkg_name,
3624: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3625: x_msg_count => x_msg_count,

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

3620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3621: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3622: p_api_name => l_api_name,
3623: p_pkg_name => g_pkg_name,
3624: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3625: x_msg_count => x_msg_count,
3626: x_msg_data => x_msg_data,
3627: p_api_type => g_api_type);
3628:

Line 3634: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3631: END IF;
3632:
3633: WHEN OTHERS THEN
3634: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3635: p_api_name => l_api_name,
3636: p_pkg_name => g_pkg_name,
3637: p_exc_name => 'OTHERS',
3638: x_msg_count => x_msg_count,

Line 3685: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3681: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3682: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'Begin(+)');
3683: END IF;
3684:
3685: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3686:
3687: x_return_status := OKL_API.START_ACTIVITY(
3688: p_api_name => l_api_name,
3689: p_pkg_name => g_pkg_name,

Line 3687: x_return_status := OKL_API.START_ACTIVITY(

3683: END IF;
3684:
3685: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3686:
3687: x_return_status := OKL_API.START_ACTIVITY(
3688: p_api_name => l_api_name,
3689: p_pkg_name => g_pkg_name,
3690: p_init_msg_list => p_init_msg_list,
3691: l_api_version => l_api_version,

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

3693: p_api_type => g_api_type,
3694: x_return_status => x_return_status);
3695:
3696: -- check if activity started successfully
3697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3700: RAISE OKL_API.G_EXCEPTION_ERROR;
3701: END IF;

Line 3698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3694: x_return_status => x_return_status);
3695:
3696: -- check if activity started successfully
3697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3700: RAISE OKL_API.G_EXCEPTION_ERROR;
3701: END IF;
3702:

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

3695:
3696: -- check if activity started successfully
3697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3700: RAISE OKL_API.G_EXCEPTION_ERROR;
3701: END IF;
3702:
3703: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);

Line 3700: RAISE OKL_API.G_EXCEPTION_ERROR;

3696: -- check if activity started successfully
3697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3700: RAISE OKL_API.G_EXCEPTION_ERROR;
3701: END IF;
3702:
3703: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);
3704: FETCH c_book_ctrl_trx INTO l_progress_status;

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

3711: x_return_status => x_return_status,
3712: x_msg_count => x_msg_count,
3713: x_msg_data => x_msg_data,
3714: p_chr_id => p_khr_id);
3715: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3717: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;

Line 3716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3712: x_msg_count => x_msg_count,
3713: x_msg_data => x_msg_data,
3714: p_chr_id => p_khr_id);
3715: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3717: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;
3720: END IF;

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

3713: x_msg_data => x_msg_data,
3714: p_chr_id => p_khr_id);
3715: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3717: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;
3720: END IF;
3721:

Line 3718: RAISE OKL_API.G_EXCEPTION_ERROR;

3714: p_chr_id => p_khr_id);
3715: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3717: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;
3720: END IF;
3721:
3722: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;
3720: END IF;
3721:
3722: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3723: x_msg_data => x_msg_data);
3724:
3725: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');

Line 3730: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');
3727: END IF;
3728:
3729: EXCEPTION
3730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3731: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3732: p_api_name => l_api_name,
3733: p_pkg_name => g_pkg_name,
3734: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3731: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3727: END IF;
3728:
3729: EXCEPTION
3730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3731: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3732: p_api_name => l_api_name,
3733: p_pkg_name => g_pkg_name,
3734: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3735: x_msg_count => x_msg_count,

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

3730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3731: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3732: p_api_name => l_api_name,
3733: p_pkg_name => g_pkg_name,
3734: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3735: x_msg_count => x_msg_count,
3736: x_msg_data => x_msg_data,
3737: p_api_type => g_api_type);
3738:

Line 3743: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3739: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3741: END IF;
3742:
3743: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3744: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3745: p_api_name => l_api_name,
3746: p_pkg_name => g_pkg_name,
3747: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3744: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3741: END IF;
3742:
3743: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3744: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3745: p_api_name => l_api_name,
3746: p_pkg_name => g_pkg_name,
3747: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3748: x_msg_count => x_msg_count,

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

3743: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3744: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3745: p_api_name => l_api_name,
3746: p_pkg_name => g_pkg_name,
3747: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3748: x_msg_count => x_msg_count,
3749: x_msg_data => x_msg_data,
3750: p_api_type => g_api_type);
3751:

Line 3757: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3753: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3754: END IF;
3755:
3756: WHEN OTHERS THEN
3757: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3758: p_api_name => l_api_name,
3759: p_pkg_name => g_pkg_name,
3760: p_exc_name => 'OTHERS',
3761: x_msg_count => x_msg_count,

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

3787:
3788: l_api_name CONSTANT VARCHAR2(30) := 'calculate_upfront_tax';
3789: l_api_version CONSTANT NUMBER := 1.0;
3790: p_api_version CONSTANT NUMBER := 1.0;
3791: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3792: l_init_msg_list VARCHAR2(1) := 'T';
3793: l_msg_count NUMBER;
3794: l_msg_data VARCHAR2(2000);
3795: l_msg_token_tbl msg_token_tbl;

Line 3815: l_return_status := OKL_API.START_ACTIVITY(l_api_name

3811: 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'));
3812: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
3813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3814:
3815: l_return_status := OKL_API.START_ACTIVITY(l_api_name
3816: ,G_PKG_NAME
3817: ,l_init_msg_list
3818: ,l_api_version
3819: ,p_api_version

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

3819: ,p_api_version
3820: ,'_PVT'
3821: ,l_return_status);
3822:
3823: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3824: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3826: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3827: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 3825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3821: ,l_return_status);
3822:
3823: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3824: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3826: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3827: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
3828: RAISE OKL_API.G_EXCEPTION_ERROR;
3829: END IF;

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

3822:
3823: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3824: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3826: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3827: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
3828: RAISE OKL_API.G_EXCEPTION_ERROR;
3829: END IF;
3830: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 3828: RAISE OKL_API.G_EXCEPTION_ERROR;

3824: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
3825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3826: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
3827: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
3828: RAISE OKL_API.G_EXCEPTION_ERROR;
3829: END IF;
3830: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
3831: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
3832:

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

3839: x_msg_data => l_msg_data,
3840: p_chr_id => p_khr_id,
3841: x_process_status => l_process_status);
3842:
3843: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');

Line 3845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3841: x_process_status => l_process_status);
3842:
3843: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');
3848: RAISE OKL_API.G_EXCEPTION_ERROR;
3849: END IF;

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

3842:
3843: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');
3848: RAISE OKL_API.G_EXCEPTION_ERROR;
3849: END IF;
3850:

Line 3848: RAISE OKL_API.G_EXCEPTION_ERROR;

3844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in call to okl_contract_book_pvt.calculate_upfront_tax');
3845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in call to okl_contract_book_pvt.calculate_upfront_tax');
3848: RAISE OKL_API.G_EXCEPTION_ERROR;
3849: END IF;
3850:
3851: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

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

3852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3855:
3856: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN
3857: -- print the error message in the output file
3858: IF (fnd_msg_pub.count_msg > 0) THEN
3859: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3860: LOOP

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

3867: END LOOP;
3868: END IF;
3869: END IF;
3870:
3871: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN
3872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Upfront Tax was calculated successfully....');
3873: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
3874: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
3875: END IF;

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

3873: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
3874: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
3875: END IF;
3876:
3877: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN
3878: p_retcode := 2;
3879: END IF;
3880:
3881: 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 3884: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

3880:
3881: 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'));
3882: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3883:
3884: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
3885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
3886:
3887: EXCEPTION
3888: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3888: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3884: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
3885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
3886:
3887: EXCEPTION
3888: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3889: p_retcode := 2;
3890:
3891: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3892: p_api_name => l_api_name,

Line 3891: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

3887: EXCEPTION
3888: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3889: p_retcode := 2;
3890:
3891: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3892: p_api_name => l_api_name,
3893: p_pkg_name => g_pkg_name,
3894: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3895: x_msg_count => l_msg_count,

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

3890:
3891: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3892: p_api_name => l_api_name,
3893: p_pkg_name => g_pkg_name,
3894: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3895: x_msg_count => l_msg_count,
3896: x_msg_data => l_msg_data,
3897: p_api_type => g_api_type);
3898:

Line 3920: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3916: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3917: 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'));
3918: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3919:
3920: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3921: p_retcode := 2;
3922:
3923: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3924: p_api_name => l_api_name,

Line 3923: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

3919:
3920: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3921: p_retcode := 2;
3922:
3923: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3924: p_api_name => l_api_name,
3925: p_pkg_name => g_pkg_name,
3926: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3927: x_msg_count => l_msg_count,

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

3922:
3923: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3924: p_api_name => l_api_name,
3925: p_pkg_name => g_pkg_name,
3926: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3927: x_msg_count => l_msg_count,
3928: x_msg_data => l_msg_data,
3929: p_api_type => g_api_type);
3930:

Line 3956: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

3952: WHEN OTHERS THEN
3953: p_retcode := 2;
3954: p_errbuf := SQLERRM;
3955:
3956: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3957: p_api_name => l_api_name,
3958: p_pkg_name => g_pkg_name,
3959: p_exc_name => 'OTHERS',
3960: x_msg_count => l_msg_count,

Line 4100: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4096: -- History : XX-XXX-XXXX rpillay Created
4097: -- End of comments
4098: PROCEDURE submit_prb_upgrade(
4099: p_api_version IN NUMBER,
4100: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4101: x_return_status OUT NOCOPY VARCHAR2,
4102: x_msg_count OUT NOCOPY NUMBER,
4103: x_msg_data OUT NOCOPY VARCHAR2,
4104: p_khr_id IN NUMBER,

Line 4143: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4139: l_request_numbers_token VARCHAR2(1000);
4140:
4141: BEGIN
4142:
4143: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4144: x_request_numbers := NULL;
4145:
4146: x_return_status := OKL_API.START_ACTIVITY(
4147: p_api_name => l_api_name,

Line 4146: x_return_status := OKL_API.START_ACTIVITY(

4142:
4143: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4144: x_request_numbers := NULL;
4145:
4146: x_return_status := OKL_API.START_ACTIVITY(
4147: p_api_name => l_api_name,
4148: p_pkg_name => g_pkg_name,
4149: p_init_msg_list => p_init_msg_list,
4150: l_api_version => l_api_version,

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

4152: p_api_type => g_api_type,
4153: x_return_status => x_return_status);
4154:
4155: -- check if activity started successfully
4156: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4159: RAISE OKL_API.G_EXCEPTION_ERROR;
4160: END IF;

Line 4157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4153: x_return_status => x_return_status);
4154:
4155: -- check if activity started successfully
4156: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4159: RAISE OKL_API.G_EXCEPTION_ERROR;
4160: END IF;
4161:

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

4154:
4155: -- check if activity started successfully
4156: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4159: RAISE OKL_API.G_EXCEPTION_ERROR;
4160: END IF;
4161:
4162: OPEN l_chr_csr(p_khr_id => p_khr_id);

Line 4159: RAISE OKL_API.G_EXCEPTION_ERROR;

4155: -- check if activity started successfully
4156: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4159: RAISE OKL_API.G_EXCEPTION_ERROR;
4160: END IF;
4161:
4162: OPEN l_chr_csr(p_khr_id => p_khr_id);
4163: FETCH l_chr_csr INTO l_chr_rec;

Line 4175: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

4171: CLOSE l_chk_upg_req_csr;
4172:
4173: IF (l_upg_req_exists_yn = 'Y') THEN
4174:
4175: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
4176: p_msg_name => 'OKL_LLA_RBK_UPG_IN_PROG',
4177: p_token1 => 'CONTRACT_NUMBER',
4178: p_token1_value => l_chr_rec.contract_number);
4179:

Line 4180: RAISE OKL_API.G_EXCEPTION_ERROR;

4176: p_msg_name => 'OKL_LLA_RBK_UPG_IN_PROG',
4177: p_token1 => 'CONTRACT_NUMBER',
4178: p_token1_value => l_chr_rec.contract_number);
4179:
4180: RAISE OKL_API.G_EXCEPTION_ERROR;
4181:
4182: ELSE
4183: -- establish the external_id values for the contracts, if they don't have one.
4184: OKL_LLA_UTIL_PVT.update_external_id(p_chr_id => l_chr_rec.orig_chr_id,

Line 4187: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS

4183: -- establish the external_id values for the contracts, if they don't have one.
4184: OKL_LLA_UTIL_PVT.update_external_id(p_chr_id => l_chr_rec.orig_chr_id,
4185: x_return_status => x_return_status);
4186:
4187: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS
4188: THEN
4189: RAISE OKL_API.G_EXCEPTION_ERROR;
4190: END IF;
4191:

Line 4189: RAISE OKL_API.G_EXCEPTION_ERROR;

4185: x_return_status => x_return_status);
4186:
4187: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS
4188: THEN
4189: RAISE OKL_API.G_EXCEPTION_ERROR;
4190: END IF;
4191:
4192: OKL_LA_STREAM_PVT.upgrade_esg_khr_for_prb(
4193: p_chr_id => l_chr_rec.orig_chr_id

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

4198: ,x_trans_status => l_trans_status
4199: ,x_rep_request_id => l_rep_request_id
4200: ,x_rep_trans_status => l_rep_trans_status );
4201:
4202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4205: RAISE OKL_API.G_EXCEPTION_ERROR;
4206: END IF;

Line 4203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4199: ,x_rep_request_id => l_rep_request_id
4200: ,x_rep_trans_status => l_rep_trans_status );
4201:
4202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4205: RAISE OKL_API.G_EXCEPTION_ERROR;
4206: END IF;
4207:

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

4200: ,x_rep_trans_status => l_rep_trans_status );
4201:
4202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4205: RAISE OKL_API.G_EXCEPTION_ERROR;
4206: END IF;
4207:
4208: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4205: RAISE OKL_API.G_EXCEPTION_ERROR;

4201:
4202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4205: RAISE OKL_API.G_EXCEPTION_ERROR;
4206: END IF;
4207:
4208: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
4209:

Line 4208: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

4204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4205: RAISE OKL_API.G_EXCEPTION_ERROR;
4206: END IF;
4207:
4208: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
4209:
4210: l_request_numbers_token := TO_CHAR(l_request_id);
4211: IF ( NVL(l_rep_request_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM ) THEN
4212: l_request_numbers_token := l_request_numbers_token || ', '|| TO_CHAR(l_rep_request_id);

Line 4211: IF ( NVL(l_rep_request_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM ) THEN

4207:
4208: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
4209:
4210: l_request_numbers_token := TO_CHAR(l_request_id);
4211: IF ( NVL(l_rep_request_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM ) THEN
4212: l_request_numbers_token := l_request_numbers_token || ', '|| TO_CHAR(l_rep_request_id);
4213: END IF;
4214:
4215: x_request_numbers := l_request_numbers_token;

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

4217: END IF;
4218: END IF;
4219: END IF;
4220:
4221: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
4222: x_msg_data => x_msg_data);
4223:
4224: EXCEPTION
4225: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 4225: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4221: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
4222: x_msg_data => x_msg_data);
4223:
4224: EXCEPTION
4225: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4226: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4227: p_api_name => l_api_name,
4228: p_pkg_name => g_pkg_name,
4229: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 4226: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4222: x_msg_data => x_msg_data);
4223:
4224: EXCEPTION
4225: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4226: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4227: p_api_name => l_api_name,
4228: p_pkg_name => g_pkg_name,
4229: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4230: x_msg_count => x_msg_count,

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

4225: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4226: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4227: p_api_name => l_api_name,
4228: p_pkg_name => g_pkg_name,
4229: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4230: x_msg_count => x_msg_count,
4231: x_msg_data => x_msg_data,
4232: p_api_type => g_api_type);
4233:

Line 4234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4230: x_msg_count => x_msg_count,
4231: x_msg_data => x_msg_data,
4232: p_api_type => g_api_type);
4233:
4234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4235: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4236: p_api_name => l_api_name,
4237: p_pkg_name => g_pkg_name,
4238: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4235: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4231: x_msg_data => x_msg_data,
4232: p_api_type => g_api_type);
4233:
4234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4235: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4236: p_api_name => l_api_name,
4237: p_pkg_name => g_pkg_name,
4238: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4239: x_msg_count => x_msg_count,

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

4234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4235: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4236: p_api_name => l_api_name,
4237: p_pkg_name => g_pkg_name,
4238: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4239: x_msg_count => x_msg_count,
4240: x_msg_data => x_msg_data,
4241: p_api_type => g_api_type);
4242:

Line 4244: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4240: x_msg_data => x_msg_data,
4241: p_api_type => g_api_type);
4242:
4243: WHEN OTHERS THEN
4244: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4245: p_api_name => l_api_name,
4246: p_pkg_name => g_pkg_name,
4247: p_exc_name => 'OTHERS',
4248: x_msg_count => x_msg_count,