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

Line 8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

4: -------------------------------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';

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

11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16: ------------------------------------------------------------------------------------
17: -- GLOBAL EXCEPTION
18: ------------------------------------------------------------------------------------
19: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

84: -- in the following signature x_trxH_rec is
85: -- introduced as part of Sales Tax Project to return transaction record
86: Procedure generate_journal_entries(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
89: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
90: p_contract_id IN NUMBER,
91: p_transaction_type IN VARCHAR2,
92: p_transaction_date IN DATE,

Line 89: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

85: -- introduced as part of Sales Tax Project to return transaction record
86: Procedure generate_journal_entries(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
89: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
90: p_contract_id IN NUMBER,
91: p_transaction_type IN VARCHAR2,
92: p_transaction_date IN DATE,
93: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,

Line 93: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,

89: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
90: p_contract_id IN NUMBER,
91: p_transaction_type IN VARCHAR2,
92: p_transaction_date IN DATE,
93: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,
94: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,

Line 94: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

90: p_contract_id IN NUMBER,
91: p_transaction_type IN VARCHAR2,
92: p_transaction_date IN DATE,
93: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,
94: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: x_trxH_rec OUT NOCOPY tcnv_rec_type) IS

Line 110: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

106:
107: -- Define variables
108: l_sysdate DATE;
109: l_sysdate_trunc DATE;
110: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
111: l_post_to_gl_yn VARCHAR2(1);
112:
113: i NUMBER;
114: l_amount NUMBER;

Line 115: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

111: l_post_to_gl_yn VARCHAR2(1);
112:
113: i NUMBER;
114: l_amount NUMBER;
115: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
116: l_msg_count NUMBER;
117: l_msg_data VARCHAR2(2000);
118: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;
119: l_fnd_profile VARCHAR2(256);

Line 349: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

345: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
346: END IF;
347: --Bug# 5964482 End
348:
349: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
350: l_sysdate := SYSDATE;
351: l_sysdate_trunc := trunc(SYSDATE);
352: i := 0;
353:

Line 355: x_return_status := OKL_API.START_ACTIVITY(

351: l_sysdate_trunc := trunc(SYSDATE);
352: i := 0;
353:
354:
355: x_return_status := OKL_API.START_ACTIVITY(
356: p_api_name => l_api_name,
357: p_pkg_name => g_pkg_name,
358: p_init_msg_list => p_init_msg_list,
359: l_api_version => l_api_version,

Line 365: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

361: p_api_type => G_API_TYPE,
362: x_return_status => x_return_status);
363:
364: -- check if activity started successfully
365: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
366: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
367: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
368: raise OKL_API.G_EXCEPTION_ERROR;
369: End If;

Line 366: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

362: x_return_status => x_return_status);
363:
364: -- check if activity started successfully
365: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
366: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
367: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
368: raise OKL_API.G_EXCEPTION_ERROR;
369: End If;
370:

Line 367: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

363:
364: -- check if activity started successfully
365: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
366: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
367: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
368: raise OKL_API.G_EXCEPTION_ERROR;
369: End If;
370:
371: --Bug# 5964482 : Disable draft Accounting

Line 368: raise OKL_API.G_EXCEPTION_ERROR;

364: -- check if activity started successfully
365: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
366: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
367: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
368: raise OKL_API.G_EXCEPTION_ERROR;
369: End If;
370:
371: --Bug# 5964482 : Disable draft Accounting
372: If (p_draft_yn = OKL_API.G_TRUE) Then

Line 372: If (p_draft_yn = OKL_API.G_TRUE) Then

368: raise OKL_API.G_EXCEPTION_ERROR;
369: End If;
370:
371: --Bug# 5964482 : Disable draft Accounting
372: If (p_draft_yn = OKL_API.G_TRUE) Then
373: Null; -- do not do anything
374: ELSE --do normal accounting
375:
376: -- Get product_id

Line 380: Okl_Api.SET_MESSAGE(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, 'Product');

376: -- Get product_id
377: OPEN Product_csr(p_contract_id);
378: FETCH Product_csr INTO l_Product_rec;
379: IF Product_csr%NOTFOUND THEN
380: Okl_Api.SET_MESSAGE(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, 'Product');
381: CLOSE Product_csr;
382: RAISE Okl_Api.G_EXCEPTION_ERROR;
383: END IF;
384: CLOSE Product_csr;

Line 382: RAISE Okl_Api.G_EXCEPTION_ERROR;

378: FETCH Product_csr INTO l_Product_rec;
379: IF Product_csr%NOTFOUND THEN
380: Okl_Api.SET_MESSAGE(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, 'Product');
381: CLOSE Product_csr;
382: RAISE Okl_Api.G_EXCEPTION_ERROR;
383: END IF;
384: CLOSE Product_csr;
385:
386: If ( p_transaction_date IS NULL ) Then

Line 419: IF ((p_draft_yn = OKL_API.G_TRUE) AND (l_Product_rec.contract_status <> 'BOOKED')) Then

415: End If;
416:
417: End If;
418:
419: IF ((p_draft_yn = OKL_API.G_TRUE) AND (l_Product_rec.contract_status <> 'BOOKED')) Then
420: /*--Bug# 5964482 Commenting the code as Draft Accounting is being disabled
421: okl_contract_status_pub.get_contract_status(l_api_version,
422: p_init_msg_list,
423: x_return_status,

Line 434: x_return_status := OKL_API.G_RET_STS_ERROR;

430: p_chr_id);
431:
432:
433: If ( l_isJrnlGenAllowed = FALSE ) then
434: x_return_status := OKL_API.G_RET_STS_ERROR;
435: okl_api.set_message(
436: p_app_name => G_APP_NAME,
437: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_CANNOT_GENJRNL);
438: raise OKL_API.G_EXCEPTION_ERROR;

Line 435: okl_api.set_message(

431:
432:
433: If ( l_isJrnlGenAllowed = FALSE ) then
434: x_return_status := OKL_API.G_RET_STS_ERROR;
435: okl_api.set_message(
436: p_app_name => G_APP_NAME,
437: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_CANNOT_GENJRNL);
438: raise OKL_API.G_EXCEPTION_ERROR;
439: ElsIf (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

Line 438: raise OKL_API.G_EXCEPTION_ERROR;

434: x_return_status := OKL_API.G_RET_STS_ERROR;
435: okl_api.set_message(
436: p_app_name => G_APP_NAME,
437: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_CANNOT_GENJRNL);
438: raise OKL_API.G_EXCEPTION_ERROR;
439: ElsIf (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
442: raise OKL_API.G_EXCEPTION_ERROR;

Line 439: ElsIf (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

435: okl_api.set_message(
436: p_app_name => G_APP_NAME,
437: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_CANNOT_GENJRNL);
438: raise OKL_API.G_EXCEPTION_ERROR;
439: ElsIf (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
442: raise OKL_API.G_EXCEPTION_ERROR;
443: End If;

Line 440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

436: p_app_name => G_APP_NAME,
437: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_CANNOT_GENJRNL);
438: raise OKL_API.G_EXCEPTION_ERROR;
439: ElsIf (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
442: raise OKL_API.G_EXCEPTION_ERROR;
443: End If;
444: -----Bug# 5964482 End of comments - Draft Accounting Disabled*/

Line 441: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

437: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_CANNOT_GENJRNL);
438: raise OKL_API.G_EXCEPTION_ERROR;
439: ElsIf (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
442: raise OKL_API.G_EXCEPTION_ERROR;
443: End If;
444: -----Bug# 5964482 End of comments - Draft Accounting Disabled*/
445: Null;

Line 442: raise OKL_API.G_EXCEPTION_ERROR;

438: raise OKL_API.G_EXCEPTION_ERROR;
439: ElsIf (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
442: raise OKL_API.G_EXCEPTION_ERROR;
443: End If;
444: -----Bug# 5964482 End of comments - Draft Accounting Disabled*/
445: Null;
446:

Line 450: IF ( p_contract_id = Okl_Api.G_MISS_NUM )

446:
447: End If;
448:
449: -- Validate passed parameters
450: IF ( p_contract_id = Okl_Api.G_MISS_NUM )
451: OR ( p_contract_id IS NULL ) THEN
452: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, 'contract');
453: RAISE Okl_Api.G_EXCEPTION_ERROR;
454: END IF;

Line 452: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, 'contract');

448:
449: -- Validate passed parameters
450: IF ( p_contract_id = Okl_Api.G_MISS_NUM )
451: OR ( p_contract_id IS NULL ) THEN
452: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, 'contract');
453: RAISE Okl_Api.G_EXCEPTION_ERROR;
454: END IF;
455:
456: --Bug 5909373

Line 453: RAISE Okl_Api.G_EXCEPTION_ERROR;

449: -- Validate passed parameters
450: IF ( p_contract_id = Okl_Api.G_MISS_NUM )
451: OR ( p_contract_id IS NULL ) THEN
452: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, 'contract');
453: RAISE Okl_Api.G_EXCEPTION_ERROR;
454: END IF;
455:
456: --Bug 5909373
457: /*

Line 463: IF ( l_transaction_type = Okl_Api.G_MISS_CHAR )

459: l_transaction_type := 'Release';
460: End If;*/
461: --Bug 5909373
462:
463: IF ( l_transaction_type = Okl_Api.G_MISS_CHAR )
464: OR ( l_transaction_type IS NULL ) THEN
465: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
466: RAISE Okl_Api.G_EXCEPTION_ERROR;
467: END IF;

Line 465: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, l_transaction_type);

461: --Bug 5909373
462:
463: IF ( l_transaction_type = Okl_Api.G_MISS_CHAR )
464: OR ( l_transaction_type IS NULL ) THEN
465: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
466: RAISE Okl_Api.G_EXCEPTION_ERROR;
467: END IF;
468:
469: -- set POST_TO_GL and MEMO_YN flag always to YES !!!!

Line 466: RAISE Okl_Api.G_EXCEPTION_ERROR;

462:
463: IF ( l_transaction_type = Okl_Api.G_MISS_CHAR )
464: OR ( l_transaction_type IS NULL ) THEN
465: Okl_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
466: RAISE Okl_Api.G_EXCEPTION_ERROR;
467: END IF;
468:
469: -- set POST_TO_GL and MEMO_YN flag always to YES !!!!
470: l_memo_yn := OKL_API.G_MISS_CHAR;

Line 470: l_memo_yn := OKL_API.G_MISS_CHAR;

466: RAISE Okl_Api.G_EXCEPTION_ERROR;
467: END IF;
468:
469: -- set POST_TO_GL and MEMO_YN flag always to YES !!!!
470: l_memo_yn := OKL_API.G_MISS_CHAR;
471:
472: --ndani - 18-Mar-2013, Start - Rebook accounting fix
473: --Bug# 16511024, Start
474: IF l_trans_type = 'Rebook-Release' THEN

Line 483: IF (p_draft_yn = OKL_API.G_TRUE) THEN

479: END IF;
480: --Bug# 16511024, End
481: --ndani - 18-Mar-2013, End - Rebook accounting fix
482:
483: IF (p_draft_yn = OKL_API.G_TRUE) THEN
484: --Bug# 5964482 : Disable Draft Accounting
485: --l_post_to_gl_yn := 'N';
486: --l_memo_yn := 'Y';
487: Null;

Line 499: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);

495: -- Check Transaction_Type
496: OPEN Transaction_Type_csr(l_transaction_type);
497: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
498: IF Transaction_Type_csr%NOTFOUND THEN
499: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
500: CLOSE Transaction_Type_csr;
501: RAISE Okl_Api.G_EXCEPTION_ERROR;
502: END IF;
503: CLOSE Transaction_Type_csr;

Line 501: RAISE Okl_Api.G_EXCEPTION_ERROR;

497: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
498: IF Transaction_Type_csr%NOTFOUND THEN
499: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
500: CLOSE Transaction_Type_csr;
501: RAISE Okl_Api.G_EXCEPTION_ERROR;
502: END IF;
503: CLOSE Transaction_Type_csr;
504:
505: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);

Line 512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);

508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN
512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
513: CLOSE fnd_lookups_csr;
514: RAISE Okl_Api.G_EXCEPTION_ERROR;
515: End If;
516: END IF;

Line 514: RAISE Okl_Api.G_EXCEPTION_ERROR;

510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN
512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
513: CLOSE fnd_lookups_csr;
514: RAISE Okl_Api.G_EXCEPTION_ERROR;
515: End If;
516: END IF;
517: CLOSE fnd_lookups_csr;
518:

Line 522: l_has_trans := OKL_API.G_FALSE;

518:
519: OPEN trx_csr(p_contract_id,l_fnd_rec.lookup_code);
520: FETCH trx_csr INTO l_trx_rec;
521: IF (l_fnd_rec.lookup_code = 'TRBK') THEN -- For Rebook, create a new trans always
522: l_has_trans := OKL_API.G_FALSE;
523: ELSIF (trx_csr%FOUND AND l_trx_rec.tsu_code = 'ENTERED') THEN -- Otherwise use existing transaction, if it is in Entered status
524: l_has_trans := OKL_API.G_TRUE;
525: ELSE
526: l_has_trans := OKL_API.G_FALSE; -- In all other cases, create a new trans

Line 524: l_has_trans := OKL_API.G_TRUE;

520: FETCH trx_csr INTO l_trx_rec;
521: IF (l_fnd_rec.lookup_code = 'TRBK') THEN -- For Rebook, create a new trans always
522: l_has_trans := OKL_API.G_FALSE;
523: ELSIF (trx_csr%FOUND AND l_trx_rec.tsu_code = 'ENTERED') THEN -- Otherwise use existing transaction, if it is in Entered status
524: l_has_trans := OKL_API.G_TRUE;
525: ELSE
526: l_has_trans := OKL_API.G_FALSE; -- In all other cases, create a new trans
527: END IF;
528: CLOSE trx_csr;

Line 526: l_has_trans := OKL_API.G_FALSE; -- In all other cases, create a new trans

522: l_has_trans := OKL_API.G_FALSE;
523: ELSIF (trx_csr%FOUND AND l_trx_rec.tsu_code = 'ENTERED') THEN -- Otherwise use existing transaction, if it is in Entered status
524: l_has_trans := OKL_API.G_TRUE;
525: ELSE
526: l_has_trans := OKL_API.G_FALSE; -- In all other cases, create a new trans
527: END IF;
528: CLOSE trx_csr;
529:
530: l_trxH_in_rec.khr_id := p_contract_id;

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

541: -- get the contract number
542: OPEN contract_num_csr(p_contract_id);
543: FETCH contract_num_csr INTO l_cntrct_number;
544: CLOSE contract_num_csr;
545: Okl_Api.set_message(p_app_name => g_app_name,
546: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
547: p_token1 => 'CONTRACT_NUMBER',
548: p_token1_value => l_cntrct_number);
549: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 549: RAISE OKL_API.G_EXCEPTION_ERROR;

545: Okl_Api.set_message(p_app_name => g_app_name,
546: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
547: p_token1 => 'CONTRACT_NUMBER',
548: p_token1_value => l_cntrct_number);
549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551: If ( p_draft_yn = OKL_API.G_TRUE ) Then
552: --Bug# 5964482 : Disable draft Accounting
553: Null;

Line 551: If ( p_draft_yn = OKL_API.G_TRUE ) Then

547: p_token1 => 'CONTRACT_NUMBER',
548: p_token1_value => l_cntrct_number);
549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551: If ( p_draft_yn = OKL_API.G_TRUE ) Then
552: --Bug# 5964482 : Disable draft Accounting
553: Null;
554: --l_trxH_in_rec.description := 'Draft Journals - ' || l_transaction_type;
555: Else

Line 569: If ( p_draft_yn = OKL_API.G_TRUE ) Then

565: -- changes for accounting CR.
566: l_trxL_in_rec.khr_id := p_contract_id;
567: l_trxL_in_rec.line_number := 1;
568: l_trxL_in_rec.currency_code := l_currency_code;
569: If ( p_draft_yn = OKL_API.G_TRUE ) Then
570: -- Bug# 5964482 : Disable draft accounting
571: Null;
572: --l_trxL_in_rec.description := 'Draft Journals - ' || l_transaction_type;
573: Else

Line 595: If ( l_has_trans = OKL_API.G_FALSE ) Then

591: l_trxL_in_rec.tcl_type := l_fnd_rec1.lookup_code;
592: END IF;
593: CLOSE fnd_lookups_csr;
594:
595: If ( l_has_trans = OKL_API.G_FALSE ) Then
596:
597: If (UPPER(l_fnd_rec.lookup_code) = 'TRBK') THEN
598: l_trxH_in_rec.rbr_code := ''; -- lokup 'OKL_REBOOK_REASON'
599: l_trxH_in_rec.rpy_code := ''; -- lokup 'OKL_REBOOK_PROCESS_TYPE'

Line 605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);

601:
602: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
603: FETCH fnd_lookups_csr INTO l_fnd_rec;
604: IF fnd_lookups_csr%NOTFOUND THEN
605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
606: CLOSE fnd_lookups_csr;
607: RAISE Okl_Api.G_EXCEPTION_ERROR;
608: END IF;
609: CLOSE fnd_lookups_csr;

Line 607: RAISE Okl_Api.G_EXCEPTION_ERROR;

603: FETCH fnd_lookups_csr INTO l_fnd_rec;
604: IF fnd_lookups_csr%NOTFOUND THEN
605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
606: CLOSE fnd_lookups_csr;
607: RAISE Okl_Api.G_EXCEPTION_ERROR;
608: END IF;
609: CLOSE fnd_lookups_csr;
610:
611: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;

Line 645: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

641: ,x_msg_data => l_msg_data
642: ,p_tcnv_rec => l_trxH_in_rec
643: ,x_tcnv_rec => l_trxH_out_rec);
644:
645: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
648: RAISE Okl_Api.G_EXCEPTION_ERROR;
649: END IF;

Line 646: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

642: ,p_tcnv_rec => l_trxH_in_rec
643: ,x_tcnv_rec => l_trxH_out_rec);
644:
645: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
648: RAISE Okl_Api.G_EXCEPTION_ERROR;
649: END IF;
650:

Line 647: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

643: ,x_tcnv_rec => l_trxH_out_rec);
644:
645: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
648: RAISE Okl_Api.G_EXCEPTION_ERROR;
649: END IF;
650:
651: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR

Line 648: RAISE Okl_Api.G_EXCEPTION_ERROR;

644:
645: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
648: RAISE Okl_Api.G_EXCEPTION_ERROR;
649: END IF;
650:
651: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR
652: (l_trxH_out_rec.id IS NULL) ) THEN

Line 651: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR

647: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
648: RAISE Okl_Api.G_EXCEPTION_ERROR;
649: END IF;
650:
651: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR
652: (l_trxH_out_rec.id IS NULL) ) THEN
653: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;

Line 653: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');

649: END IF;
650:
651: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR
652: (l_trxH_out_rec.id IS NULL) ) THEN
653: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656:
657: -- populate the output transaction record

Line 654: RAISE OKL_API.G_EXCEPTION_ERROR;

650:
651: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR
652: (l_trxH_out_rec.id IS NULL) ) THEN
653: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656:
657: -- populate the output transaction record
658: x_trxH_rec := l_trxH_out_rec;

Line 677: --IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

673: --,x_msg_data => l_msg_data
674: --,p_tclv_rec => l_trxL_in_rec
675: --,x_tclv_rec => l_trxL_out_rec);
676:
677: --IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
678: -- RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
679: --ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
680: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
681: --END IF;

Line 678: -- RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

674: --,p_tclv_rec => l_trxL_in_rec
675: --,x_tclv_rec => l_trxL_out_rec);
676:
677: --IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
678: -- RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
679: --ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
680: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
681: --END IF;
682: --IF ((l_trxL_out_rec.id = OKL_API.G_MISS_NUM) OR

Line 679: --ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

675: --,x_tclv_rec => l_trxL_out_rec);
676:
677: --IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
678: -- RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
679: --ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
680: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
681: --END IF;
682: --IF ((l_trxL_out_rec.id = OKL_API.G_MISS_NUM) OR
683: -- (l_trxL_out_rec.id IS NULL) ) THEN

Line 680: -- RAISE Okl_Api.G_EXCEPTION_ERROR;

676:
677: --IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
678: -- RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
679: --ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
680: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
681: --END IF;
682: --IF ((l_trxL_out_rec.id = OKL_API.G_MISS_NUM) OR
683: -- (l_trxL_out_rec.id IS NULL) ) THEN
684: -- OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');

Line 682: --IF ((l_trxL_out_rec.id = OKL_API.G_MISS_NUM) OR

678: -- RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
679: --ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
680: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
681: --END IF;
682: --IF ((l_trxL_out_rec.id = OKL_API.G_MISS_NUM) OR
683: -- (l_trxL_out_rec.id IS NULL) ) THEN
684: -- OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
685: -- RAISE OKL_API.G_EXCEPTION_ERROR;
686: --END IF;

Line 684: -- OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');

680: -- RAISE Okl_Api.G_EXCEPTION_ERROR;
681: --END IF;
682: --IF ((l_trxL_out_rec.id = OKL_API.G_MISS_NUM) OR
683: -- (l_trxL_out_rec.id IS NULL) ) THEN
684: -- OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
685: -- RAISE OKL_API.G_EXCEPTION_ERROR;
686: --END IF;
687:
688: --l_dist_info_rec.SOURCE_ID := l_trxL_out_rec.id;

Line 685: -- RAISE OKL_API.G_EXCEPTION_ERROR;

681: --END IF;
682: --IF ((l_trxL_out_rec.id = OKL_API.G_MISS_NUM) OR
683: -- (l_trxL_out_rec.id IS NULL) ) THEN
684: -- OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
685: -- RAISE OKL_API.G_EXCEPTION_ERROR;
686: --END IF;
687:
688: --l_dist_info_rec.SOURCE_ID := l_trxL_out_rec.id;
689: --l_dist_info_rec.ACCOUNTING_DATE := l_trxH_out_rec.date_transaction_occurred;

Line 708: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

704: ,x_msg_data => l_msg_data
705: ,p_tcnv_rec => l_upd_trxH_rec
706: ,x_tcnv_rec => lx_upd_trxH_rec);
707:
708: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
709: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
711: RAISE Okl_Api.G_EXCEPTION_ERROR;
712: END IF;

Line 709: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

705: ,p_tcnv_rec => l_upd_trxH_rec
706: ,x_tcnv_rec => lx_upd_trxH_rec);
707:
708: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
709: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
711: RAISE Okl_Api.G_EXCEPTION_ERROR;
712: END IF;
713:

Line 710: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

706: ,x_tcnv_rec => lx_upd_trxH_rec);
707:
708: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
709: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
711: RAISE Okl_Api.G_EXCEPTION_ERROR;
712: END IF;
713:
714: IF ((lx_upd_trxH_rec.id = OKL_API.G_MISS_NUM) OR

Line 711: RAISE Okl_Api.G_EXCEPTION_ERROR;

707:
708: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
709: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
711: RAISE Okl_Api.G_EXCEPTION_ERROR;
712: END IF;
713:
714: IF ((lx_upd_trxH_rec.id = OKL_API.G_MISS_NUM) OR
715: (lx_upd_trxH_rec.id IS NULL) ) THEN

Line 714: IF ((lx_upd_trxH_rec.id = OKL_API.G_MISS_NUM) OR

710: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
711: RAISE Okl_Api.G_EXCEPTION_ERROR;
712: END IF;
713:
714: IF ((lx_upd_trxH_rec.id = OKL_API.G_MISS_NUM) OR
715: (lx_upd_trxH_rec.id IS NULL) ) THEN
716: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
717: RAISE OKL_API.G_EXCEPTION_ERROR;
718: END IF;

Line 716: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');

712: END IF;
713:
714: IF ((lx_upd_trxH_rec.id = OKL_API.G_MISS_NUM) OR
715: (lx_upd_trxH_rec.id IS NULL) ) THEN
716: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
717: RAISE OKL_API.G_EXCEPTION_ERROR;
718: END IF;
719:
720: -- populate the output transaction record

Line 717: RAISE OKL_API.G_EXCEPTION_ERROR;

713:
714: IF ((lx_upd_trxH_rec.id = OKL_API.G_MISS_NUM) OR
715: (lx_upd_trxH_rec.id IS NULL) ) THEN
716: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
717: RAISE OKL_API.G_EXCEPTION_ERROR;
718: END IF;
719:
720: -- populate the output transaction record
721: x_trxH_rec := lx_upd_trxH_rec;

Line 754: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

750: x_msg_count => l_msg_count,
751: x_msg_data => l_msg_data,
752: p_tclv_tbl => l_trxl_del_tbl);
753:
754: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
757: RAISE Okl_Api.G_EXCEPTION_ERROR;
758: END IF;

Line 755: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

751: x_msg_data => l_msg_data,
752: p_tclv_tbl => l_trxl_del_tbl);
753:
754: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
757: RAISE Okl_Api.G_EXCEPTION_ERROR;
758: END IF;
759: --End delete existing lines

Line 756: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

752: p_tclv_tbl => l_trxl_del_tbl);
753:
754: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
757: RAISE Okl_Api.G_EXCEPTION_ERROR;
758: END IF;
759: --End delete existing lines
760: ---------------------------

Line 757: RAISE Okl_Api.G_EXCEPTION_ERROR;

753:
754: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
755: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
757: RAISE Okl_Api.G_EXCEPTION_ERROR;
758: END IF;
759: --End delete existing lines
760: ---------------------------
761: --End Bug# 5964482

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

780: x_fact_synd_code => l_fact_synd_code,
781: x_inv_acct_code => l_inv_acct_code
782: );
783:
784: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;

Line 785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

781: x_inv_acct_code => l_inv_acct_code
782: );
783:
784: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;
789:

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

782: );
783:
784: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;
789:
790: l_tmpl_identify_rec.factoring_synd_flag := l_fact_synd_code;

Line 787: RAISE OKL_API.G_EXCEPTION_ERROR;

783:
784: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;
789:
790: l_tmpl_identify_rec.factoring_synd_flag := l_fact_synd_code;
791: l_tmpl_identify_rec.investor_code := l_inv_acct_code;

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

808: p_validity_date => l_trxH_out_rec.date_transaction_occurred);
809: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
810: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Call to OKL_ACCOUNT_DIST_PUB.GET_TEMPLATE_INFO : '||x_return_status);
811: END IF;
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;

Line 813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

809: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
810: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Call to OKL_ACCOUNT_DIST_PUB.GET_TEMPLATE_INFO : '||x_return_status);
811: END IF;
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;
817: -- gboomina Bug 6151201 - Start

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

810: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Call to OKL_ACCOUNT_DIST_PUB.GET_TEMPLATE_INFO : '||x_return_status);
811: END IF;
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;
817: -- gboomina Bug 6151201 - Start
818: -- check whether templates present or not. If not throw error.

Line 815: RAISE OKL_API.G_EXCEPTION_ERROR;

811: END IF;
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;
817: -- gboomina Bug 6151201 - Start
818: -- check whether templates present or not. If not throw error.
819: IF l_template_tbl.COUNT = 0 THEN

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

816: END IF;
817: -- gboomina Bug 6151201 - Start
818: -- check whether templates present or not. If not throw error.
819: IF l_template_tbl.COUNT = 0 THEN
820: Okl_Api.set_message(p_app_name => g_app_name,
821: p_msg_name => 'OKL_LA_NO_ACCOUNTING_TMPLTS',
822: p_token1 => 'TRANSACTION_TYPE',
823: p_token1_value => l_transaction_type);
824: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 824: RAISE OKL_API.G_EXCEPTION_ERROR;

820: Okl_Api.set_message(p_app_name => g_app_name,
821: p_msg_name => 'OKL_LA_NO_ACCOUNTING_TMPLTS',
822: p_token1 => 'TRANSACTION_TYPE',
823: p_token1_value => l_transaction_type);
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826: -- gboomina Bug 6151201 - End
827:
828: --Build the transaction line table of records

Line 835: If ( p_draft_yn = OKL_API.G_TRUE ) Then

831: l_tclv_tbl(i).line_number := i;
832: l_tclv_tbl(i).khr_id := p_contract_id;
833: l_tclv_tbl(i).sty_id := l_template_tbl(i).sty_id;
834: l_tclv_tbl(i).tcl_type := l_trxl_in_rec.tcl_type;
835: If ( p_draft_yn = OKL_API.G_TRUE ) Then
836: --Bug# 5964482 : disbale draft accounting
837: Null;
838: --l_tclv_tbl(i).description := 'Draft Journals - ' || l_transaction_type;
839: Else

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

858: ,x_tclv_tbl => x_tclv_tbl);
859: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);
861: END IF;
862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;

Line 863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

859: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);
861: END IF;
862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:

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

860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);
861: END IF;
862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:
868: /* Populating the tmpl_identify_tbl from the template_tbl returned by get_template_info*/

Line 865: RAISE OKL_API.G_EXCEPTION_ERROR;

861: END IF;
862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:
868: /* Populating the tmpl_identify_tbl from the template_tbl returned by get_template_info*/
869:

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

881: l_tmpl_identify_tbl(i).FACTORING_CODE := l_template_tbl(i).fac_code;
882: --ndani - 27-Mar-2013 - Bug# 16558722 - Start, Added condition to raise error when l_memo_yn is not same as l_template_tbl(i).memo_yn flag
883: IF l_transaction_type = 'Rebook' THEN
884: IF l_template_tbl(i).memo_yn <> l_memo_yn THEN
885: Okl_Api.set_message(p_app_name => g_app_name,
886: p_msg_name => 'OKL_LA_NO_ACCOUNTING_TMPLTS',
887: p_token1 => 'TRANSACTION_TYPE',
888: p_token1_value => l_transaction_type);
889: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 889: RAISE OKL_API.G_EXCEPTION_ERROR;

885: Okl_Api.set_message(p_app_name => g_app_name,
886: p_msg_name => 'OKL_LA_NO_ACCOUNTING_TMPLTS',
887: p_token1 => 'TRANSACTION_TYPE',
888: p_token1_value => l_transaction_type);
889: RAISE OKL_API.G_EXCEPTION_ERROR;
890: END IF;
891: END IF;
892: --ndani - 27-Mar-2013 - Bug# 16558722 - End
893: END LOOP;

Line 1021: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1017: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1018: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After accounting engine OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST call :'|| x_return_status);
1019: END IF;
1020:
1021: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;

Line 1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1018: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After accounting engine OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST call :'|| x_return_status);
1019: END IF;
1020:
1021: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;
1026:

Line 1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1019: END IF;
1020:
1021: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: /* --Bug# 5964482 : Code commented

Line 1024: RAISE Okl_Api.G_EXCEPTION_ERROR;

1020:
1021: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: /* --Bug# 5964482 : Code commented
1028: --If ( l_has_trans = OKL_API.G_TRUE ) Then

Line 1028: --If ( l_has_trans = OKL_API.G_TRUE ) Then

1024: RAISE Okl_Api.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: /* --Bug# 5964482 : Code commented
1028: --If ( l_has_trans = OKL_API.G_TRUE ) Then
1029: -- l_trxH_in_rec.id := l_trx_rec.HeaderTransId;
1030: --Else
1031: -- l_trxH_in_rec.id := l_trxH_out_rec.id;
1032: --End If;

Line 1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);

1036:
1037: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1038: FETCH fnd_lookups_csr INTO l_fnd_rec;
1039: IF fnd_lookups_csr%NOTFOUND THEN
1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1041: CLOSE fnd_lookups_csr;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044: CLOSE fnd_lookups_csr;

Line 1042: RAISE Okl_Api.G_EXCEPTION_ERROR;

1038: FETCH fnd_lookups_csr INTO l_fnd_rec;
1039: IF fnd_lookups_csr%NOTFOUND THEN
1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1041: CLOSE fnd_lookups_csr;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044: CLOSE fnd_lookups_csr;
1045:
1046: --From the l_amount_out_tbl returned , the transaction line amount and header amount need to be updated back on the contract

Line 1085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1081: ,p_tclv_tbl => l_tclv_tbl
1082: ,x_tcnv_rec => x_tcnv_rec
1083: ,x_tclv_tbl => x_tclv_tbl );
1084:
1085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1088: RAISE Okl_Api.G_EXCEPTION_ERROR;
1089: END IF;

Line 1086: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1082: ,x_tcnv_rec => x_tcnv_rec
1083: ,x_tclv_tbl => x_tclv_tbl );
1084:
1085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1088: RAISE Okl_Api.G_EXCEPTION_ERROR;
1089: END IF;
1090:

Line 1087: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1083: ,x_tclv_tbl => x_tclv_tbl );
1084:
1085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1088: RAISE Okl_Api.G_EXCEPTION_ERROR;
1089: END IF;
1090:
1091: OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX

Line 1088: RAISE Okl_Api.G_EXCEPTION_ERROR;

1084:
1085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1086: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1088: RAISE Okl_Api.G_EXCEPTION_ERROR;
1089: END IF;
1090:
1091: OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX
1092: (p_api_version => p_api_version

Line 1103: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1099: ,p_ctxt_val_tbl => l_ctxt_tbl
1100: ,p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
1101:
1102:
1103: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1104: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1105: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1106: RAISE Okl_Api.G_EXCEPTION_ERROR;
1107: END IF;

Line 1104: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1100: ,p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
1101:
1102:
1103: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1104: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1105: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1106: RAISE Okl_Api.G_EXCEPTION_ERROR;
1107: END IF;
1108: /*-------Bug# 5964482 : Commented code to update header and Lines with Amount--------------------

Line 1105: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1101:
1102:
1103: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1104: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1105: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1106: RAISE Okl_Api.G_EXCEPTION_ERROR;
1107: END IF;
1108: /*-------Bug# 5964482 : Commented code to update header and Lines with Amount--------------------
1109: --as new code has been incorporated above-----------------------------------------------------

Line 1106: RAISE Okl_Api.G_EXCEPTION_ERROR;

1102:
1103: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1104: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1105: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1106: RAISE Okl_Api.G_EXCEPTION_ERROR;
1107: END IF;
1108: /*-------Bug# 5964482 : Commented code to update header and Lines with Amount--------------------
1109: --as new code has been incorporated above-----------------------------------------------------
1110: -- Check Status

Line 1111: IF(x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

1107: END IF;
1108: /*-------Bug# 5964482 : Commented code to update header and Lines with Amount--------------------
1109: --as new code has been incorporated above-----------------------------------------------------
1110: -- Check Status
1111: IF(x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
1112:
1113: l_trxH_in_rec.amount := 0;
1114: FOR i in 1..l_amount_tbl.COUNT
1115: LOOP

Line 1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);

1119:
1120: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1121: FETCH fnd_lookups_csr INTO l_fnd_rec;
1122: IF fnd_lookups_csr%NOTFOUND THEN
1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1124: CLOSE fnd_lookups_csr;
1125: RAISE Okl_Api.G_EXCEPTION_ERROR;
1126: END IF;
1127: CLOSE fnd_lookups_csr;

Line 1125: RAISE Okl_Api.G_EXCEPTION_ERROR;

1121: FETCH fnd_lookups_csr INTO l_fnd_rec;
1122: IF fnd_lookups_csr%NOTFOUND THEN
1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1124: CLOSE fnd_lookups_csr;
1125: RAISE Okl_Api.G_EXCEPTION_ERROR;
1126: END IF;
1127: CLOSE fnd_lookups_csr;
1128: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1129:

Line 1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);

1139:
1140: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1141: FETCH fnd_lookups_csr INTO l_fnd_rec;
1142: IF fnd_lookups_csr%NOTFOUND THEN
1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1144: CLOSE fnd_lookups_csr;
1145: RAISE Okl_Api.G_EXCEPTION_ERROR;
1146: END IF;
1147: CLOSE fnd_lookups_csr;

Line 1145: RAISE Okl_Api.G_EXCEPTION_ERROR;

1141: FETCH fnd_lookups_csr INTO l_fnd_rec;
1142: IF fnd_lookups_csr%NOTFOUND THEN
1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1144: CLOSE fnd_lookups_csr;
1145: RAISE Okl_Api.G_EXCEPTION_ERROR;
1146: END IF;
1147: CLOSE fnd_lookups_csr;
1148: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1149: l_trxH_in_rec.amount := null;

Line 1174: IF (p_draft_yn = OKL_API.G_TRUE) Then

1170: ,p_tclv_rec => l_trxL_in_rec
1171: ,x_tclv_rec => l_trxL_out_rec);
1172: -------Bug# 5964482 : End of comments ------------------------------------------------------*/
1173:
1174: IF (p_draft_yn = OKL_API.G_TRUE) Then
1175: --Bug# 5964482: disable draft Accounting
1176: Null;
1177: /*-----------Commented Code-----------------------
1178: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

Line 1178: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

1174: IF (p_draft_yn = OKL_API.G_TRUE) Then
1175: --Bug# 5964482: disable draft Accounting
1176: Null;
1177: /*-----------Commented Code-----------------------
1178: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
1179:
1180: okl_contract_status_pub.update_contract_status(
1181: l_api_version,
1182: p_init_msg_list,

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

1194: x_msg_count => x_msg_count,
1195: x_msg_data => x_msg_data,
1196: p_chr_id => p_contract_id);
1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;

Line 1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1195: x_msg_data => x_msg_data,
1196: p_chr_id => p_contract_id);
1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;
1203:

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

1196: p_chr_id => p_contract_id);
1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;
1203:
1204: ELSE

Line 1201: RAISE OKL_API.G_EXCEPTION_ERROR;

1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;
1203:
1204: ELSE
1205: okl_contract_status_pub.update_contract_status(

Line 1213: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1209: x_msg_count,
1210: x_msg_data,
1211: l_failStatus,
1212: p_chr_id );
1213: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1216: RAISE Okl_Api.G_EXCEPTION_ERROR;
1217: END IF;

Line 1214: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1210: x_msg_data,
1211: l_failStatus,
1212: p_chr_id );
1213: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1216: RAISE Okl_Api.G_EXCEPTION_ERROR;
1217: END IF;
1218:

Line 1215: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1211: l_failStatus,
1212: p_chr_id );
1213: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1216: RAISE Okl_Api.G_EXCEPTION_ERROR;
1217: END IF;
1218:
1219: --call to cascade status on to lines

Line 1216: RAISE Okl_Api.G_EXCEPTION_ERROR;

1212: p_chr_id );
1213: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1216: RAISE Okl_Api.G_EXCEPTION_ERROR;
1217: END IF;
1218:
1219: --call to cascade status on to lines
1220: OKL_CONTRACT_STATUS_PUB.cascade_lease_status

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

1224: x_msg_count => x_msg_count,
1225: x_msg_data => x_msg_data,
1226: p_chr_id => p_contract_id);
1227:
1228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_ERROR;
1232: END IF;

Line 1229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1225: x_msg_data => x_msg_data,
1226: p_chr_id => p_contract_id);
1227:
1228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_ERROR;
1232: END IF;
1233:

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

1226: p_chr_id => p_contract_id);
1227:
1228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_ERROR;
1232: END IF;
1233:
1234: END IF;

Line 1231: RAISE OKL_API.G_EXCEPTION_ERROR;

1227:
1228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_ERROR;
1232: END IF;
1233:
1234: END IF;
1235: ----------End of commented Code-----------------------*/

Line 1240: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1236: --Bug# 5964482
1237: End If; --Bug# 5964482 Disable Draft Accounting
1238: End If; --Bug# 5964482 Disable Draft Accounting
1239:
1240: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1241:
1242: Exception
1243: when OKL_API.G_EXCEPTION_ERROR then
1244: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1243: when OKL_API.G_EXCEPTION_ERROR then

1239:
1240: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1241:
1242: Exception
1243: when OKL_API.G_EXCEPTION_ERROR then
1244: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1245: p_api_name => l_api_name,
1246: p_pkg_name => g_pkg_name,
1247: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1244: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1240: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1241:
1242: Exception
1243: when OKL_API.G_EXCEPTION_ERROR then
1244: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1245: p_api_name => l_api_name,
1246: p_pkg_name => g_pkg_name,
1247: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1248: x_msg_count => x_msg_count,

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

1243: when OKL_API.G_EXCEPTION_ERROR then
1244: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1245: p_api_name => l_api_name,
1246: p_pkg_name => g_pkg_name,
1247: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1248: x_msg_count => x_msg_count,
1249: x_msg_data => x_msg_data,
1250: p_api_type => g_api_type);
1251:

Line 1252: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1248: x_msg_count => x_msg_count,
1249: x_msg_data => x_msg_data,
1250: p_api_type => g_api_type);
1251:
1252: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1253: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1254: p_api_name => l_api_name,
1255: p_pkg_name => g_pkg_name,
1256: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1253: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1249: x_msg_data => x_msg_data,
1250: p_api_type => g_api_type);
1251:
1252: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1253: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1254: p_api_name => l_api_name,
1255: p_pkg_name => g_pkg_name,
1256: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1257: x_msg_count => x_msg_count,

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

1252: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1253: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1254: p_api_name => l_api_name,
1255: p_pkg_name => g_pkg_name,
1256: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1257: x_msg_count => x_msg_count,
1258: x_msg_data => x_msg_data,
1259: p_api_type => g_api_type);
1260:

Line 1262: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1258: x_msg_data => x_msg_data,
1259: p_api_type => g_api_type);
1260:
1261: when OTHERS then
1262: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1263: p_api_name => l_api_name,
1264: p_pkg_name => g_pkg_name,
1265: p_exc_name => 'OTHERS',
1266: x_msg_count => x_msg_count,

Line 1275: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1271: END generate_journal_entries;
1272:
1273: Procedure generate_journal_entries(
1274: p_api_version IN NUMBER,
1275: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1276: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1277: p_contract_id IN NUMBER,
1278: p_transaction_type IN VARCHAR2,
1279: p_transaction_date IN DATE,

Line 1276: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1272:
1273: Procedure generate_journal_entries(
1274: p_api_version IN NUMBER,
1275: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1276: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1277: p_contract_id IN NUMBER,
1278: p_transaction_type IN VARCHAR2,
1279: p_transaction_date IN DATE,
1280: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,

Line 1280: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,

1276: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1277: p_contract_id IN NUMBER,
1278: p_transaction_type IN VARCHAR2,
1279: p_transaction_date IN DATE,
1280: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,
1281: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1282: x_return_status OUT NOCOPY VARCHAR2,
1283: x_msg_count OUT NOCOPY NUMBER,
1284: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1281: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1277: p_contract_id IN NUMBER,
1278: p_transaction_type IN VARCHAR2,
1279: p_transaction_date IN DATE,
1280: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,
1281: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1282: x_return_status OUT NOCOPY VARCHAR2,
1283: x_msg_count OUT NOCOPY NUMBER,
1284: x_msg_data OUT NOCOPY VARCHAR2) IS
1285:

Line 1309: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1305: End generate_journal_entries;
1306:
1307: Procedure generate_journal_entries(
1308: p_api_version IN NUMBER,
1309: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1310: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1311: p_contract_id IN NUMBER,
1312: p_transaction_type IN VARCHAR2,
1313: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,

Line 1310: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1306:
1307: Procedure generate_journal_entries(
1308: p_api_version IN NUMBER,
1309: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1310: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1311: p_contract_id IN NUMBER,
1312: p_transaction_type IN VARCHAR2,
1313: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,
1314: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1313: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,

1309: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1310: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1311: p_contract_id IN NUMBER,
1312: p_transaction_type IN VARCHAR2,
1313: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,
1314: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1315: x_return_status OUT NOCOPY VARCHAR2,
1316: x_msg_count OUT NOCOPY NUMBER,
1317: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1314: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1310: p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1311: p_contract_id IN NUMBER,
1312: p_transaction_type IN VARCHAR2,
1313: p_draft_yn IN VARCHAR2 DEFAULT Okl_Api.G_TRUE,
1314: p_memo_yn IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1315: x_return_status OUT NOCOPY VARCHAR2,
1316: x_msg_count OUT NOCOPY NUMBER,
1317: x_msg_data OUT NOCOPY VARCHAR2) IS
1318: