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

Line 40: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

36: -- *********************
37: -- GLOBAL VARIABLES
38: -- *********************
39: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_BAL_WRITEOFF_PVT';
40: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
41: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
42: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 42: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

38: -- *********************
39: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_BAL_WRITEOFF_PVT';
40: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
41: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
42: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: G_API_VERSION CONSTANT NUMBER := 1;
46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

Line 43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

39: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_BAL_WRITEOFF_PVT';
40: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
41: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
42: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: G_API_VERSION CONSTANT NUMBER := 1;
46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;

Line 44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

40: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
41: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
42: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: G_API_VERSION CONSTANT NUMBER := 1;
46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
48: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

Line 46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

42: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: G_API_VERSION CONSTANT NUMBER := 1;
46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
48: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
49: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
50: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

Line 47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;

43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: G_API_VERSION CONSTANT NUMBER := 1;
46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
48: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
49: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
50: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
51: G_YES CONSTANT VARCHAR2(1) := 'Y';

Line 48: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

44: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: G_API_VERSION CONSTANT NUMBER := 1;
46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
48: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
49: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
50: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
51: G_YES CONSTANT VARCHAR2(1) := 'Y';
52: G_NO CONSTANT VARCHAR2(1) := 'N';

Line 49: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;

45: G_API_VERSION CONSTANT NUMBER := 1;
46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
48: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
49: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
50: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
51: G_YES CONSTANT VARCHAR2(1) := 'Y';
52: G_NO CONSTANT VARCHAR2(1) := 'N';
53: G_FIRST CONSTANT NUMBER := FND_MSG_PUB.G_FIRST;

Line 50: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

46: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
47: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
48: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
49: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
50: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
51: G_YES CONSTANT VARCHAR2(1) := 'Y';
52: G_NO CONSTANT VARCHAR2(1) := 'N';
53: G_FIRST CONSTANT NUMBER := FND_MSG_PUB.G_FIRST;
54: G_NEXT CONSTANT NUMBER := FND_MSG_PUB.G_NEXT;

Line 89: lx_error_rec OKL_API.error_rec_type;

85: PROCEDURE fnd_output (
86: p_khr_rec IN khr_rec_type,
87: p_control_flag IN VARCHAR2 ) IS
88:
89: lx_error_rec OKL_API.error_rec_type;
90: l_msg_idx INTEGER := G_FIRST;
91:
92: BEGIN
93:

Line 144: OKL_API.set_message(

140: EXCEPTION
141:
142: WHEN OTHERS THEN
143: -- Set the oracle error message
144: OKL_API.set_message(
145: p_app_name => G_APP_NAME_1,
146: p_msg_name => G_UNEXPECTED_ERROR,
147: p_token1 => G_SQLCODE_TOKEN,
148: p_token1_value => SQLCODE,

Line 431: OKL_API.set_message(

427: EXCEPTION
428:
429: WHEN OTHERS THEN
430: -- Set the oracle error message
431: OKL_API.set_message(
432: p_app_name => G_APP_NAME_1,
433: p_msg_name => G_UNEXPECTED_ERROR,
434: p_token1 => G_SQLCODE_TOKEN,
435: p_token1_value => SQLCODE,

Line 513: OKL_API.set_message(

509:
510: WHEN OTHERS THEN
511: ROLLBACK TO populate_khr_trx;
512: -- Set the oracle error message
513: OKL_API.set_message(
514: p_app_name => G_APP_NAME_1,
515: p_msg_name => G_UNEXPECTED_ERROR,
516: p_token1 => G_SQLCODE_TOKEN,
517: p_token1_value => SQLCODE,

Line 589: OR p_khr_rec.id = OKL_API.G_MISS_NUM THEN

585: IF p_control_flag = 'BATCH_SINGLE' THEN -- Do additional checks
586:
587: -- Check for ID
588: IF p_khr_rec.id IS NULL
589: OR p_khr_rec.id = OKL_API.G_MISS_NUM THEN
590:
591: -- Message:
592: OKL_API.set_message(
593: p_app_name => G_APP_NAME,

Line 592: OKL_API.set_message(

588: IF p_khr_rec.id IS NULL
589: OR p_khr_rec.id = OKL_API.G_MISS_NUM THEN
590:
591: -- Message:
592: OKL_API.set_message(
593: p_app_name => G_APP_NAME,
594: p_msg_name => 'OKL_AM_BWR_KHR_ID_INV');
595:
596: RAISE G_EXCEPTION_ERROR;

Line 603: OKL_API.set_message(

599: -- Check for type
600: IF p_khr_rec.scs_code NOT IN ('LEASE','LOAN') THEN -- *** CHECK
601:
602: -- Message:
603: OKL_API.set_message(
604: p_app_name => G_APP_NAME,
605: p_msg_name => 'OKL_AM_BWR_KHR_TYPE_INV',
606: p_token1 => 'CONTRACT_NUMBER',
607: p_token1_value => p_khr_rec.contract_number);

Line 616: OKL_API.set_message(

612: -- Check for status
613: IF p_khr_rec.sts_code NOT IN ('TERMINATED', 'EXPIRED') THEN
614:
615: -- Message:
616: OKL_API.set_message(
617: p_app_name => G_APP_NAME,
618: p_msg_name => 'OKL_AM_BWR_KHR_STATUS_INV',
619: p_token1 => 'CONTRACT_NUMBER',
620: p_token1_value => p_khr_rec.contract_number);

Line 629: OKL_API.set_message(

625: -- Check for end date
626: IF p_khr_rec.end_date IS NULL THEN
627:
628: -- Message:
629: OKL_API.set_message(
630: p_app_name => G_APP_NAME,
631: p_msg_name => 'OKL_AM_BWR_KHR_END_DATE_INV',
632: p_token1 => 'CONTRACT_NUMBER',
633: p_token1_value => p_khr_rec.contract_number);

Line 644: AND l_trn_id <> OKL_API.G_MISS_NUM THEN

640: FETCH get_termination_trn_csr INTO l_trn_id;
641: CLOSE get_termination_trn_csr;
642:
643: IF l_trn_id IS NOT NULL
644: AND l_trn_id <> OKL_API.G_MISS_NUM THEN
645:
646: -- Message:
647: OKL_API.set_message(
648: p_app_name => G_APP_NAME,

Line 647: OKL_API.set_message(

643: IF l_trn_id IS NOT NULL
644: AND l_trn_id <> OKL_API.G_MISS_NUM THEN
645:
646: -- Message:
647: OKL_API.set_message(
648: p_app_name => G_APP_NAME,
649: p_msg_name => 'OKL_AM_BWR_KHR_DONE',
650: p_token1 => 'CONTRACT_NUMBER',
651: p_token1_value => p_khr_rec.contract_number);

Line 663: AND l_trn_id <> OKL_API.G_MISS_NUM THEN

659: FETCH get_writeoff_trn_csr INTO l_trn_id;
660: CLOSE get_writeoff_trn_csr;
661:
662: IF l_trn_id IS NOT NULL
663: AND l_trn_id <> OKL_API.G_MISS_NUM THEN
664:
665: -- Message:
666: OKL_API.set_message(
667: p_app_name => G_APP_NAME,

Line 666: OKL_API.set_message(

662: IF l_trn_id IS NOT NULL
663: AND l_trn_id <> OKL_API.G_MISS_NUM THEN
664:
665: -- Message:
666: OKL_API.set_message(
667: p_app_name => G_APP_NAME,
668: p_msg_name => 'OKL_AM_BWR_KHR_DONE',
669: p_token1 => 'CONTRACT_NUMBER',
670: p_token1_value => p_khr_rec.contract_number);

Line 712: OKL_API.set_message(

708:
709: WHEN OTHERS THEN
710: ROLLBACK TO validate_khr_trx;
711: -- Set the oracle error message
712: OKL_API.set_message(
713: p_app_name => G_APP_NAME_1,
714: p_msg_name => G_UNEXPECTED_ERROR,
715: p_token1 => G_SQLCODE_TOKEN,
716: p_token1_value => SQLCODE,

Line 743: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

739: --
740: -- End of comments
741: PROCEDURE write_off_balances(
742: p_api_version IN NUMBER,
743: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
744: x_return_status OUT NOCOPY VARCHAR2,
745: x_msg_count OUT NOCOPY NUMBER,
746: x_msg_data OUT NOCOPY VARCHAR2,
747: p_khr_rec IN khr_rec_type,

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

845: FROM fnd_profile_options_vl
846: WHERE profile_option_name = 'OKL_SMALL_BALANCE_TOLERANCE';
847:
848: k_bal_lns_rec k_bal_lns_csr%ROWTYPE;
849: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
850: lp_adjv_rec OKL_TRX_AR_ADJSTS_PUB.adjv_rec_type;
851: lx_adjv_rec OKL_TRX_AR_ADJSTS_PUB.adjv_rec_type;
852: l_early_termination_yn VARCHAR2(1) := OKL_API.G_FALSE;
853: l_total_amount_due NUMBER := -1;

Line 852: l_early_termination_yn VARCHAR2(1) := OKL_API.G_FALSE;

848: k_bal_lns_rec k_bal_lns_csr%ROWTYPE;
849: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
850: lp_adjv_rec OKL_TRX_AR_ADJSTS_PUB.adjv_rec_type;
851: lx_adjv_rec OKL_TRX_AR_ADJSTS_PUB.adjv_rec_type;
852: l_early_termination_yn VARCHAR2(1) := OKL_API.G_FALSE;
853: l_total_amount_due NUMBER := -1;
854: l_code_combination_id NUMBER := -1;
855: i NUMBER := 1;
856: l_tolerance_amt NUMBER := -1;

Line 886: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

882:
883: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
884: --Bug 6316320 dpsingh end
885:
886: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
887: l_writeoff_try_id NUMBER;
888: l_trn_try_id NUMBER;
889: l_trans_meaning VARCHAR2(200);
890: l_currency_code VARCHAR2(200);

Line 941: l_return_status := OKL_API.start_activity(

937:
938: -- *************
939: -- Check API version, initialize message list and create savepoint
940: -- *************
941: l_return_status := OKL_API.start_activity(
942: p_api_name => l_api_name,
943: p_pkg_name => G_PKG_NAME,
944: p_init_msg_list => p_init_msg_list,
945: l_api_version => l_api_version,

Line 970: ,p_init_msg_list => OKL_API.G_FALSE

966:
967: -- rmunjulu 4622198 SPECIAL_ACCNT Get special accounting details
968: OKL_SECURITIZATION_PVT.check_khr_ia_associated(
969: p_api_version => p_api_version
970: ,p_init_msg_list => OKL_API.G_FALSE
971: ,x_return_status => l_return_status
972: ,x_msg_count => x_msg_count
973: ,x_msg_data => x_msg_data
974: ,p_khr_id => p_khr_rec.id

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

1000: FETCH get_profile_name_csr INTO l_tol_profile_name;
1001: CLOSE get_profile_name_csr;
1002:
1003: -- No tolerance amount found for closing of balances.
1004: OKL_API.set_message( p_app_name => G_APP_NAME,
1005: p_msg_name => 'OKL_AM_NO_TOL_AMT');
1006:
1007: -- To set tolerance amount, set value for profile option PROFILE_NAME.
1008: OKL_API.set_message( p_app_name => G_APP_NAME,

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

1004: OKL_API.set_message( p_app_name => G_APP_NAME,
1005: p_msg_name => 'OKL_AM_NO_TOL_AMT');
1006:
1007: -- To set tolerance amount, set value for profile option PROFILE_NAME.
1008: OKL_API.set_message( p_app_name => G_APP_NAME,
1009: p_msg_name => 'OKL_AM_TOL_AMT',
1010: p_token1 => 'PROFILE_NAME',
1011: p_token1_value => l_tol_profile_name);
1012:

Line 1019: RAISE OKL_API.G_EXCEPTION_ERROR;

1015: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1016: 'NO TOLERANCE');
1017: END IF;
1018:
1019: RAISE OKL_API.G_EXCEPTION_ERROR;
1020:
1021: END IF;
1022:
1023: -- IF total balance amount within the tolerance limit and amount due>0 then

Line 1034: OKL_API.set_message(

1030: -- raise error message if no pdt_id
1031: IF l_pdt_id IS NULL OR l_pdt_id = 0 THEN
1032: -- Error: Unable to create accounting entries because of a missing
1033: -- Product Type for the contract CONTRACT_NUMBER.
1034: OKL_API.set_message(
1035: p_app_name => G_APP_NAME,
1036: p_msg_name => 'OKL_AM_PRODUCT_ID_ERROR',
1037: p_token1 => 'CONTRACT_NUMBER',
1038: p_token1_value=> p_khr_rec.contract_number);

Line 1046: RAISE OKL_API.G_EXCEPTION_ERROR;

1042: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1043: 'product_id_error = '||l_return_status );
1044: END IF;
1045:
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: END IF;
1048:
1049: -- ******** GET PRODUCT ID *************** END ****************
1050:

Line 1065: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1061: p_lookup_type => 'OKL_ACCOUNTING_EVENT_TYPE',
1062: p_lookup_code=> 'BALANCE_WRITE_OFF',
1063: p_validate_yn => 'Y');
1064:
1065: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1066:
1067: -- Message: Unable to find a transaction type for
1068: -- the transaction TRY_NAME
1069: OKL_API.set_message(

Line 1069: OKL_API.set_message(

1065: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1066:
1067: -- Message: Unable to find a transaction type for
1068: -- the transaction TRY_NAME
1069: OKL_API.set_message(
1070: p_app_name => G_APP_NAME,
1071: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
1072: p_token1 => 'TRY_NAME',
1073: p_token1_value => l_trans_meaning);

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

1080:
1081: END IF;
1082:
1083: -- Raise exception to rollback this whole block
1084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;

Line 1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1081: END IF;
1082:
1083: -- Raise exception to rollback this whole block
1084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;
1089:

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

1082:
1083: -- Raise exception to rollback this whole block
1084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;
1089:
1090: -- *** GET CURRENCY CODES ***************************** START ****

Line 1087: RAISE OKL_API.G_EXCEPTION_ERROR;

1083: -- Raise exception to rollback this whole block
1084: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;
1089:
1090: -- *** GET CURRENCY CODES ***************************** START ****
1091:

Line 1115: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1111: x_currency_conversion_rate => l_currency_conversion_rate,
1112: x_currency_conversion_date => l_currency_conversion_date,
1113: x_converted_amount => l_converted_amount);
1114: -- If error from OKL_ACCOUNTING_UTIL
1115: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1116:
1117: -- Error occurred when creating accounting entries for
1118: -- transaction TRX_TYPE.
1119: OKL_API.set_message(

Line 1119: OKL_API.set_message(

1115: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1116:
1117: -- Error occurred when creating accounting entries for
1118: -- transaction TRX_TYPE.
1119: OKL_API.set_message(
1120: p_app_name => G_APP_NAME,
1121: p_msg_name => 'OKL_AM_ERR_ACC_ENT',
1122: p_token1 => 'TRX_TYPE',
1123: p_token1_value => l_trans_meaning);

Line 1131: RAISE OKL_API.G_EXCEPTION_ERROR;

1127: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1128: 'currency_conv_error = '||l_return_status );
1129: END IF;
1130:
1131: RAISE OKL_API.G_EXCEPTION_ERROR;
1132:
1133: END IF;
1134:
1135: -- *** CONVERT CURRENCIES **************************** END ****

Line 1151: p_init_msg_list=> OKL_API.G_FALSE,

1147: lp_tcnv_rec.date_transaction_occurred := p_sys_date;
1148:
1149: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
1150: p_api_version=> p_api_version,
1151: p_init_msg_list=> OKL_API.G_FALSE,
1152: x_return_status => l_return_status,
1153: x_msg_count => x_msg_count,
1154: x_msg_data => x_msg_data,
1155: p_tcnv_rec => lp_tcnv_rec,

Line 1158: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1154: x_msg_data => x_msg_data,
1155: p_tcnv_rec => lp_tcnv_rec,
1156: x_tcnv_rec => lx_tcnv_rec);
1157:
1158: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1159:
1160: -- Error occurred when creating adjustment records to write off balances.
1161: OKL_API.set_message( p_app_name => G_APP_NAME,
1162: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');

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

1157:
1158: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1159:
1160: -- Error occurred when creating adjustment records to write off balances.
1161: OKL_API.set_message( p_app_name => G_APP_NAME,
1162: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1163:
1164: END IF;
1165:

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

1169: 'OKL_TRX_CONTRACTS_PUB.create_trx_contracts = '||l_return_status );
1170: END IF;
1171:
1172: -- Raise exception to rollback this whole block
1173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1176: RAISE OKL_API.G_EXCEPTION_ERROR;
1177: END IF;

Line 1174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1170: END IF;
1171:
1172: -- Raise exception to rollback this whole block
1173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1176: RAISE OKL_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:

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

1171:
1172: -- Raise exception to rollback this whole block
1173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1176: RAISE OKL_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:
1179: -- *** CREATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS ** END **

Line 1176: RAISE OKL_API.G_EXCEPTION_ERROR;

1172: -- Raise exception to rollback this whole block
1173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1176: RAISE OKL_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:
1179: -- *** CREATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS ** END **
1180:

Line 1195: p_init_msg_list => OKL_API.G_FALSE,

1191: --Bug 6316320 dpsingh end
1192: -- call the adjusts api
1193: OKL_TRX_AR_ADJSTS_PUB.insert_trx_ar_adjsts(
1194: p_api_version => p_api_version,
1195: p_init_msg_list => OKL_API.G_FALSE,
1196: x_return_status => l_return_status,
1197: x_msg_count => x_msg_count,
1198: x_msg_data => x_msg_data,
1199: p_adjv_rec => lp_adjv_rec,

Line 1201: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1197: x_msg_count => x_msg_count,
1198: x_msg_data => x_msg_data,
1199: p_adjv_rec => lp_adjv_rec,
1200: x_adjv_rec => lx_adjv_rec);
1201: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1202:
1203: -- Error occurred when creating adjustment records to write off balances.
1204: OKL_API.set_message( p_app_name => G_APP_NAME,
1205: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');

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

1200: x_adjv_rec => lx_adjv_rec);
1201: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1202:
1203: -- Error occurred when creating adjustment records to write off balances.
1204: OKL_API.set_message( p_app_name => G_APP_NAME,
1205: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1206:
1207: END IF;
1208:

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

1212: 'OKL_TRX_AR_ADJSTS_PUB.insert_trx_ar_adjsts = '||l_return_status );
1213: END IF;
1214:
1215: -- Raise exception to rollback this whole block
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;

Line 1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1213: END IF;
1214:
1215: -- Raise exception to rollback this whole block
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221:

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

1214:
1215: -- Raise exception to rollback this whole block
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221:
1222: -- *** CREATE ADJUSTMENT HEADER TRN IN OKL_TRX_ADJSTS ** END ****

Line 1219: RAISE OKL_API.G_EXCEPTION_ERROR;

1215: -- Raise exception to rollback this whole block
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221:
1222: -- *** CREATE ADJUSTMENT HEADER TRN IN OKL_TRX_ADJSTS ** END ****
1223:

Line 1239: AND k_bal_lns_rec.tld_id <> OKL_API.G_MISS_NUM THEN

1235: lp_ajlv_rec.sty_id := k_bal_lns_rec.stream_type_id;
1236: --Bug 6316320 dpsingh end
1237: IF k_bal_lns_rec.tld_id <> -999
1238: AND k_bal_lns_rec.tld_id IS NOT NULL
1239: AND k_bal_lns_rec.tld_id <> OKL_API.G_MISS_NUM THEN
1240: lp_ajlv_rec.tld_id := k_bal_lns_rec.tld_id;
1241: END IF;
1242:
1243: lp_ajlv_rec.amount := k_bal_lns_rec.amount;

Line 1251: p_init_msg_list => OKL_API.G_FALSE,

1247:
1248: --call the txl_lns_adjsts
1249: OKL_TXL_ADJSTS_LNS_PUB.insert_txl_adjsts_lns(
1250: p_api_version => p_api_version,
1251: p_init_msg_list => OKL_API.G_FALSE,
1252: x_return_status => l_return_status,
1253: x_msg_count => x_msg_count,
1254: x_msg_data => x_msg_data,
1255: p_ajlv_rec => lp_ajlv_rec,

Line 1258: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1254: x_msg_data => x_msg_data,
1255: p_ajlv_rec => lp_ajlv_rec,
1256: x_ajlv_rec => lx_ajlv_rec);
1257:
1258: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1259: -- Error occurred when creating adjustment records to write
1260: -- off balances.
1261: OKL_API.set_message( p_app_name => G_APP_NAME,
1262: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');

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

1257:
1258: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1259: -- Error occurred when creating adjustment records to write
1260: -- off balances.
1261: OKL_API.set_message( p_app_name => G_APP_NAME,
1262: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1263: END IF;
1264:
1265: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1268: 'OKL_TRX_AR_ADJSTS_PUB.insert_txl_adjsts_lns = '||l_return_status );
1269: END IF;
1270:
1271: -- Raise exception to rollback this whole block
1272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1275: RAISE OKL_API.G_EXCEPTION_ERROR;
1276: END IF;

Line 1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1269: END IF;
1270:
1271: -- Raise exception to rollback this whole block
1272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1275: RAISE OKL_API.G_EXCEPTION_ERROR;
1276: END IF;
1277:

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

1270:
1271: -- Raise exception to rollback this whole block
1272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1275: RAISE OKL_API.G_EXCEPTION_ERROR;
1276: END IF;
1277:
1278: -- *** CREATE TRN LINE IN OKL_TXL_ADJSTS_LN ***** END *******

Line 1275: RAISE OKL_API.G_EXCEPTION_ERROR;

1271: -- Raise exception to rollback this whole block
1272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1275: RAISE OKL_API.G_EXCEPTION_ERROR;
1276: END IF;
1277:
1278: -- *** CREATE TRN LINE IN OKL_TXL_ADJSTS_LN ***** END *******
1279:

Line 1322: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1318: p_contract_line_id => NULL,
1319: x_acc_gen_tbl => lp_acc_gen_primary_key_tbl,
1320: x_return_status => l_return_status);
1321:
1322: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1323:
1324: -- Error occurred when creating adjustment records to write off balances.
1325: OKL_API.set_message( p_app_name => G_APP_NAME,
1326: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');

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

1321:
1322: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1323:
1324: -- Error occurred when creating adjustment records to write off balances.
1325: OKL_API.set_message( p_app_name => G_APP_NAME,
1326: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1327:
1328: END IF;
1329:

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

1333: 'OKL_ACC_CALL_PVT.okl_populate_acc_gen = '||l_return_status );
1334: END IF;
1335:
1336: -- Raise exception to rollback to savepoint for this block
1337: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1339: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_ERROR;
1341: END IF;

Line 1338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1334: END IF;
1335:
1336: -- Raise exception to rollback to savepoint for this block
1337: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1339: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_ERROR;
1341: END IF;
1342:

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

1335:
1336: -- Raise exception to rollback to savepoint for this block
1337: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1339: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_ERROR;
1341: END IF;
1342:
1343: l_acc_gen_tbl(i).acc_gen_key_tbl := lp_acc_gen_primary_key_tbl;

Line 1340: RAISE OKL_API.G_EXCEPTION_ERROR;

1336: -- Raise exception to rollback to savepoint for this block
1337: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1339: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_ERROR;
1341: END IF;
1342:
1343: l_acc_gen_tbl(i).acc_gen_key_tbl := lp_acc_gen_primary_key_tbl;
1344: l_acc_gen_tbl(i).source_id := lx_ajlv_rec.id;

Line 1357: p_init_msg_list => OKL_API.G_FALSE,

1353: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction
1354: -- Call new signature
1355: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
1356: p_api_version => p_api_version,
1357: p_init_msg_list => OKL_API.G_FALSE,
1358: x_return_status => l_return_status,
1359: x_msg_count => x_msg_count,
1360: x_msg_data => x_msg_data,
1361: p_tmpl_identify_tbl => l_tmpl_identify_tbl,

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

1367: p_trx_header_id => lx_adjv_rec.id,
1368: p_trx_header_table =>'OKL_TRX_AR_ADJSTS_B');
1369:
1370: -- store the highest degree of error
1371: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1372: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1373: -- need to leave
1374: Okl_Api.set_message(p_app_name => g_app_name,
1375: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',

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

1368: p_trx_header_table =>'OKL_TRX_AR_ADJSTS_B');
1369:
1370: -- store the highest degree of error
1371: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1372: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1373: -- need to leave
1374: Okl_Api.set_message(p_app_name => g_app_name,
1375: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',
1376: p_token1 => g_contract_number_token,

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

1370: -- store the highest degree of error
1371: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1372: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1373: -- need to leave
1374: Okl_Api.set_message(p_app_name => g_app_name,
1375: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',
1376: p_token1 => g_contract_number_token,
1377: p_token1_value => p_khr_rec.contract_number);
1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1374: Okl_Api.set_message(p_app_name => g_app_name,
1375: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',
1376: p_token1 => g_contract_number_token,
1377: p_token1_value => p_khr_rec.contract_number);
1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1379: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1380: -- record that there was an error
1381: Okl_Api.set_message(p_app_name => g_app_name,
1382: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',

Line 1379: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1375: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',
1376: p_token1 => g_contract_number_token,
1377: p_token1_value => p_khr_rec.contract_number);
1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1379: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1380: -- record that there was an error
1381: Okl_Api.set_message(p_app_name => g_app_name,
1382: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',
1383: p_token1 => g_contract_number_token,

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

1377: p_token1_value => p_khr_rec.contract_number);
1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1379: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1380: -- record that there was an error
1381: Okl_Api.set_message(p_app_name => g_app_name,
1382: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',
1383: p_token1 => g_contract_number_token,
1384: p_token1_value => p_khr_rec.contract_number);
1385: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1385: RAISE OKL_API.G_EXCEPTION_ERROR;

1381: Okl_Api.set_message(p_app_name => g_app_name,
1382: p_msg_name => 'OKL_AGN_CRE_DIST_ERROR',
1383: p_token1 => g_contract_number_token,
1384: p_token1_value => p_khr_rec.contract_number);
1385: RAISE OKL_API.G_EXCEPTION_ERROR;
1386: END IF;
1387: END IF;
1388:
1389: -- rmunjulu 4917286 update writeoff transaction with total amount

Line 1396: p_init_msg_list=> OKL_API.G_FALSE,

1392: lpp_tcnv_rec.amount := l_total_amount;
1393:
1394: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
1395: p_api_version=> p_api_version,
1396: p_init_msg_list=> OKL_API.G_FALSE,
1397: x_return_status => l_return_status,
1398: x_msg_count => x_msg_count,
1399: x_msg_data => x_msg_data,
1400: p_tcnv_rec => lpp_tcnv_rec,

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

1400: p_tcnv_rec => lpp_tcnv_rec,
1401: x_tcnv_rec => lxx_tcnv_rec);
1402:
1403: -- Raise exception to rollback this whole block
1404: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1407: RAISE OKL_API.G_EXCEPTION_ERROR;
1408: END IF;

Line 1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1401: x_tcnv_rec => lxx_tcnv_rec);
1402:
1403: -- Raise exception to rollback this whole block
1404: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1407: RAISE OKL_API.G_EXCEPTION_ERROR;
1408: END IF;
1409:

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

1402:
1403: -- Raise exception to rollback this whole block
1404: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1407: RAISE OKL_API.G_EXCEPTION_ERROR;
1408: END IF;
1409:
1410: OPEN get_account_derivation_meth;

Line 1407: RAISE OKL_API.G_EXCEPTION_ERROR;

1403: -- Raise exception to rollback this whole block
1404: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1407: RAISE OKL_API.G_EXCEPTION_ERROR;
1408: END IF;
1409:
1410: OPEN get_account_derivation_meth;
1411: FETCH get_account_derivation_meth INTO l_account_derivation;

Line 1430: OKL_API.set_message(

1426:
1427: -- Error: Unable to process small balance
1428: -- adjustments because of a missing Code Combination ID for the
1429: -- contract CONTRACT_NUMBER.
1430: OKL_API.set_message(
1431: p_app_name => G_APP_NAME,
1432: p_msg_name => 'OKL_AM_CODE_CMB_ERROR',
1433: p_token1 => 'CONTRACT_NUMBER',
1434: p_token1_value=> p_khr_rec.contract_number);

Line 1442: RAISE OKL_API.G_EXCEPTION_ERROR;

1438: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1439: 'code_comb_err = '||l_return_status );
1440: END IF;
1441:
1442: RAISE OKL_API.G_EXCEPTION_ERROR;
1443:
1444: END IF;
1445:
1446: -- *** GET CCID FROM ACCOUNTING DISTRIBUTIONS **** END *******

Line 1461: p_init_msg_list => OKL_API.G_FALSE,

1457:
1458: --call the txl_lns_adjsts
1459: OKL_TXL_ADJSTS_LNS_PUB.update_txl_adjsts_lns(
1460: p_api_version => p_api_version,
1461: p_init_msg_list => OKL_API.G_FALSE,
1462: x_return_status => l_return_status,
1463: x_msg_count => x_msg_count,
1464: x_msg_data => x_msg_data,
1465: p_ajlv_rec => lp_ajlv_rec,

Line 1468: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1464: x_msg_data => x_msg_data,
1465: p_ajlv_rec => lp_ajlv_rec,
1466: x_ajlv_rec => lx_ajlv_rec);
1467:
1468: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1469: -- Error occurred when creating adjustment records to write
1470: -- off balances.
1471: OKL_API.set_message( p_app_name => G_APP_NAME,
1472: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');

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

1467:
1468: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1469: -- Error occurred when creating adjustment records to write
1470: -- off balances.
1471: OKL_API.set_message( p_app_name => G_APP_NAME,
1472: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1473: END IF;
1474:
1475: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1478: 'OKL_TXL_ADJSTS_LNS_PUB.update_txl_adjsts_lns = '||l_return_status );
1479: END IF;
1480:
1481: -- Raise exception to rollback this whole block
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;

Line 1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1479: END IF;
1480:
1481: -- Raise exception to rollback this whole block
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: END IF;

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

1480:
1481: -- Raise exception to rollback this whole block
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: END IF;
1488: -- ******** UPDATE TRN LINE WITH CCID ************* END ******

Line 1485: RAISE OKL_API.G_EXCEPTION_ERROR;

1481: -- Raise exception to rollback this whole block
1482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1485: RAISE OKL_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: END IF;
1488: -- ******** UPDATE TRN LINE WITH CCID ************* END ******
1489: -- Format the adjustment amt

Line 1499: OKL_API.set_message(

1495: l_formatted_adj_amt := l_formatted_adj_amt || ' ' ||l_currency_code;
1496:
1497: -- Adjustment transaction for AR invoice AR_INVOICE_NUM of amount AMOUNT
1498: -- has been created.
1499: OKL_API.set_message(
1500: p_app_name => G_APP_NAME,
1501: p_msg_name => 'OKL_AM_ACC_ENT_AR_INV_MSG',
1502: p_token1 => 'AR_INVOICE_NUM',
1503: p_token1_value => ajlv_id_tbl(i).ar_invoice_number,

Line 1509: OKL_API.set_message(

1505: p_token2_value => l_formatted_adj_amt);
1506:
1507: -- Accounting entries created for transaction type TRX_TYPE
1508: -- and stream type STREAM_TYPE.
1509: OKL_API.set_message(
1510: p_app_name => G_APP_NAME,
1511: p_msg_name => 'OKL_AM_ACC_ENT_CREATED_MSG',
1512: p_token1 => 'TRX_TYPE',
1513: p_token1_value => l_trans_meaning,

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

1537: -- Append tolerance amt with currency code
1538: l_formatted_tol_amt := l_formatted_tol_amt || ' ' ||l_currency_code;
1539:
1540: -- Outstanding balance BALANCE_AMT exceeds Tolerance Amount TOLERANCE_AMT.
1541: OKL_API.set_message( p_app_name => G_APP_NAME,
1542: p_msg_name => 'OKL_AM_BAL_GTR_TOL',
1543: p_token1 => 'BALANCE_AMT',
1544: p_token1_value => l_formatted_bal_amt,
1545: p_token2 => 'TOLERANCE_AMT',

Line 1548: RAISE OKL_API.G_EXCEPTION_ERROR;

1544: p_token1_value => l_formatted_bal_amt,
1545: p_token2 => 'TOLERANCE_AMT',
1546: p_token2_value => l_formatted_tol_amt);
1547:
1548: RAISE OKL_API.G_EXCEPTION_ERROR;
1549: END IF;
1550: ELSE
1551:
1552: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1555: 'no_balance = '||'E' );
1556: END IF;
1557:
1558: -- No outstanding balance.
1559: OKL_API.set_message( p_app_name => G_APP_NAME,
1560: p_msg_name => 'OKL_AM_BAL_TOT_ZERO');
1561:
1562: RAISE OKL_API.G_EXCEPTION_ERROR;
1563: END IF;

Line 1562: RAISE OKL_API.G_EXCEPTION_ERROR;

1558: -- No outstanding balance.
1559: OKL_API.set_message( p_app_name => G_APP_NAME,
1560: p_msg_name => 'OKL_AM_BAL_TOT_ZERO');
1561:
1562: RAISE OKL_API.G_EXCEPTION_ERROR;
1563: END IF;
1564:
1565: x_return_status := l_return_status;
1566:

Line 1568: OKL_API.end_activity (x_msg_count, x_msg_data);

1564:
1565: x_return_status := l_return_status;
1566:
1567: -- End Activity
1568: OKL_API.end_activity (x_msg_count, x_msg_data);
1569:
1570: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1572: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',

Line 1577: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1573: 'End(-)');
1574: END IF;
1575:
1576: EXCEPTION
1577: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1578: IF k_balances_csr%ISOPEN THEN
1579: CLOSE k_balances_csr;
1580: END IF;
1581: IF k_bal_lns_csr%ISOPEN THEN

Line 1588: x_return_status := OKL_API.handle_exceptions(

1584: IF code_combination_id_csr%ISOPEN THEN
1585: CLOSE code_combination_id_csr;
1586: END IF;
1587:
1588: x_return_status := OKL_API.handle_exceptions(
1589: p_api_name => l_api_name,
1590: p_pkg_name => G_PKG_NAME,
1591: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1592: x_msg_count => x_msg_count,

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

1587:
1588: x_return_status := OKL_API.handle_exceptions(
1589: p_api_name => l_api_name,
1590: p_pkg_name => G_PKG_NAME,
1591: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1592: x_msg_count => x_msg_count,
1593: x_msg_data => x_msg_data,
1594: p_api_type => '_PVT');
1595:

Line 1603: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1599: 'EXP - ERROR');
1600: END IF;
1601:
1602:
1603: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1604: IF k_balances_csr%ISOPEN THEN
1605: CLOSE k_balances_csr;
1606: END IF;
1607: IF k_bal_lns_csr%ISOPEN THEN

Line 1614: x_return_status := OKL_API.handle_exceptions(

1610: IF code_combination_id_csr%ISOPEN THEN
1611: CLOSE code_combination_id_csr;
1612: END IF;
1613:
1614: x_return_status := OKL_API.handle_exceptions(
1615: p_api_name => l_api_name,
1616: p_pkg_name => G_PKG_NAME,
1617: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1618: x_msg_count => x_msg_count,

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

1613:
1614: x_return_status := OKL_API.handle_exceptions(
1615: p_api_name => l_api_name,
1616: p_pkg_name => G_PKG_NAME,
1617: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1618: x_msg_count => x_msg_count,
1619: x_msg_data => x_msg_data,
1620: p_api_type => '_PVT');
1621:

Line 1639: x_return_status := OKL_API.handle_exceptions(

1635: IF code_combination_id_csr%ISOPEN THEN
1636: CLOSE code_combination_id_csr;
1637: END IF;
1638:
1639: x_return_status := OKL_API.handle_exceptions(
1640: p_api_name => l_api_name,
1641: p_pkg_name => G_PKG_NAME,
1642: p_exc_name => 'OTHERS',
1643: x_msg_count => x_msg_count,

Line 1667: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1663: --
1664: -- End of comments
1665: PROCEDURE do_write_off_balances(
1666: p_api_version IN NUMBER,
1667: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1668: x_return_status OUT NOCOPY VARCHAR2,
1669: x_msg_count OUT NOCOPY NUMBER,
1670: x_msg_data OUT NOCOPY VARCHAR2,
1671: p_khr_rec IN khr_rec_type,

Line 1691: lx_error_rec OKL_API.error_rec_type;

1687: l_step VARCHAR2(50);
1688: l_validate_status VARCHAR2(3);
1689: l_update_status VARCHAR2(3);
1690:
1691: lx_error_rec OKL_API.error_rec_type;
1692: l_msg_idx INTEGER := G_FIRST;
1693: l_msg_tbl msg_tbl_type;
1694: l_api_name VARCHAR2(30) := 'do_write_off_balances';
1695: l_api_version CONSTANT NUMBER := G_API_VERSION;

Line 1710: l_return_status := OKL_API.start_activity(

1706:
1707: -- *************
1708: -- Check API version, initialize message list and create savepoint
1709: -- *************
1710: l_return_status := OKL_API.start_activity(
1711: p_api_name => l_api_name,
1712: p_pkg_name => G_PKG_NAME,
1713: p_init_msg_list => p_init_msg_list,
1714: l_api_version => l_api_version,

Line 1773: p_init_msg_list => OKL_API.G_FALSE,

1769:
1770: -- write off balances
1771: write_off_balances(
1772: p_api_version => p_api_version,
1773: p_init_msg_list => OKL_API.G_FALSE,
1774: x_return_status => l_return_status,
1775: x_msg_count => x_msg_count,
1776: x_msg_data => x_msg_data,
1777: p_khr_rec => l_khr_rec,

Line 1807: OKL_API.end_activity (x_msg_count, x_msg_data);

1803: -- set return status
1804: x_return_status := l_return_status;
1805:
1806: -- End Activity
1807: OKL_API.end_activity (x_msg_count, x_msg_data);
1808:
1809: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1811: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',

Line 1826: x_return_status := OKL_API.handle_exceptions(

1822: p_khr_rec => l_khr_rec,
1823: p_control_flag => 'ERROR');
1824: END IF;
1825:
1826: x_return_status := OKL_API.handle_exceptions(
1827: p_api_name => l_api_name,
1828: p_pkg_name => G_PKG_NAME,
1829: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1830: x_msg_count => x_msg_count,

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

1825:
1826: x_return_status := OKL_API.handle_exceptions(
1827: p_api_name => l_api_name,
1828: p_pkg_name => G_PKG_NAME,
1829: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1830: x_msg_count => x_msg_count,
1831: x_msg_data => x_msg_data,
1832: p_api_type => '_PVT');
1833:

Line 1849: x_return_status := OKL_API.handle_exceptions(

1845: p_khr_rec => l_khr_rec,
1846: p_control_flag => 'ERROR');
1847: END IF;
1848:
1849: x_return_status := OKL_API.handle_exceptions(
1850: p_api_name => l_api_name,
1851: p_pkg_name => G_PKG_NAME,
1852: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1853: x_msg_count => x_msg_count,

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

1848:
1849: x_return_status := OKL_API.handle_exceptions(
1850: p_api_name => l_api_name,
1851: p_pkg_name => G_PKG_NAME,
1852: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1853: x_msg_count => x_msg_count,
1854: x_msg_data => x_msg_data,
1855: p_api_type => '_PVT');
1856:

Line 1872: x_return_status := OKL_API.handle_exceptions(

1868: p_khr_rec => l_khr_rec,
1869: p_control_flag => 'ERROR');
1870: END IF;
1871:
1872: x_return_status := OKL_API.handle_exceptions(
1873: p_api_name => l_api_name,
1874: p_pkg_name => G_PKG_NAME,
1875: p_exc_name => 'OTHERS',
1876: x_msg_count => x_msg_count,

Line 1906: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1902: PROCEDURE concurrent_bal_writeoff_prg(
1903: errbuf OUT NOCOPY VARCHAR2,
1904: retcode OUT NOCOPY VARCHAR2,
1905: p_api_version IN VARCHAR2,
1906: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1907: p_khr_id IN VARCHAR2 DEFAULT NULL,
1908: p_date IN VARCHAR2 DEFAULT NULL) IS
1909:
1910: -- Get the terminated/expired contracts for the org

Line 1964: OKL_API.init_msg_list('T');

1960:
1961: BEGIN
1962:
1963: -- Initialize message list
1964: OKL_API.init_msg_list('T');
1965:
1966: -- Set Processing date
1967: IF p_date IS NULL THEN
1968: l_date := sysdate;

Line 2035: OKL_API.set_message(

2031: EXCEPTION
2032:
2033: WHEN OTHERS THEN
2034: -- Set the oracle error message
2035: OKL_API.set_message(
2036: p_app_name => G_APP_NAME_1,
2037: p_msg_name => G_UNEXPECTED_ERROR,
2038: p_token1 => G_SQLCODE_TOKEN,
2039: p_token1_value => SQLCODE,