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

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

24: l_hd_id NUMBER;
25: l_found BOOLEAN;
26: l_api_version CONSTANT NUMBER := 1;
27: l_api_name CONSTANT VARCHAR2(30) := 'calculate_late_charge';
28: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
29: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
30: l_init_msg_list VARCHAR2(1) ;
31: l_msg_count NUMBER ;
32:

Line 29: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

25: l_found BOOLEAN;
26: l_api_version CONSTANT NUMBER := 1;
27: l_api_name CONSTANT VARCHAR2(30) := 'calculate_late_charge';
28: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
29: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
30: l_init_msg_list VARCHAR2(1) ;
31: l_msg_count NUMBER ;
32:
33: i NUMBER := 0;

Line 615: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

611: ---
612: --- END DECLARE
613: ---
614: BEGIN
615: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
616: G_PKG_NAME,
617: p_init_msg_list,
618: l_api_version,
619: p_api_version,

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

620: '_PVT',
621: x_return_status);
622:
623:
624: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;

Line 625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

621: x_return_status);
622:
623:
624: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;
629:

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

622:
623:
624: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;
629:
630: l_init_msg_list := p_init_msg_list ;

Line 627: RAISE OKL_API.G_EXCEPTION_ERROR;

623:
624: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;
629:
630: l_init_msg_list := p_init_msg_list ;
631:

Line 662: ,p_init_msg_list => OKL_API.G_FALSE

658: l_rec_inv_id := l_inv_cur.CONSOLIDATED_INVOICE_ID;
659: -- Get the amount_due_remaining
660: OKL_BILLING_UTIL_PVT.get_contract_invoice_balance(
661: p_api_version => 1.0
662: ,p_init_msg_list => OKL_API.G_FALSE
663: ,p_contract_number => l_inv_cur.CONTRACT_NUMBER
664: ,p_trx_number => l_inv_cur.consolidated_invoice_number
665: ,x_return_status => x_return_status
666: ,x_msg_count => x_msg_count

Line 669: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

665: ,x_return_status => x_return_status
666: ,x_msg_count => x_msg_count
667: ,x_msg_data => x_msg_data
668: ,x_remaining_amount => l_amt_due_remaining);
669: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
670: l_error_flag := TRUE;
671: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
672: ||l_inv_cur.contract_number
673: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);

Line 874: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

870: --then the parent stm can be invalidated
871: l_late_stm_id := l_stm_id;
872:
873:
874: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
875: l_error_flag := TRUE;
876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
877: ELSE
878: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');

Line 932: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

928: l_sel_id := lx_selv_rec.id;
929:
930: --l_sec_rec_inv_id := lx_selv_rec.source_id;
931:
932: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
933: l_error_flag := TRUE;
934: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
935:
936: ||l_inv_cur.contract_number

Line 1024: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1020: l_stm_id := lx_stmv_rec.id;
1021: l_se_line_number := 1;
1022:
1023: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1024: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1025: l_error_flag := TRUE;
1026: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1027: ELSE
1028: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

Line 1065: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1061: x_msg_data,
1062: l_selv_rec,
1063: lx_selv_rec);
1064:
1065: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1066: l_error_flag := TRUE;
1067: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1068: ||l_inv_cur.contract_number
1069: ||' Stream Purpose: '||cns_late_fee

Line 1174: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1170: l_stm_id := lx_stmv_rec.id;
1171: l_se_line_number := 1;
1172:
1173: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1174: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1175: l_error_flag := TRUE;
1176: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1177: ELSE
1178: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

Line 1216: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1212: x_msg_data,
1213: l_selv_rec,
1214: lx_selv_rec);
1215:
1216: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1217: l_error_flag := TRUE;
1218: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1219: ||l_inv_cur.contract_number
1220: ||' Stream Purpose: '||cns_late_fee

Line 1349: ,p_init_msg_list => OKL_API.G_FALSE

1345: l_rec_inv_id := l_inv_cur.CONSOLIDATED_INVOICE_ID;
1346: -- Get the amount_due_remaining
1347: OKL_BILLING_UTIL_PVT.get_contract_invoice_balance(
1348: p_api_version => 1.0
1349: ,p_init_msg_list => OKL_API.G_FALSE
1350: ,p_contract_number => l_inv_cur.CONTRACT_NUMBER
1351: ,p_trx_number => l_inv_cur.consolidated_invoice_number
1352: ,x_return_status => x_return_status
1353: ,x_msg_count => x_msg_count

Line 1356: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1352: ,x_return_status => x_return_status
1353: ,x_msg_count => x_msg_count
1354: ,x_msg_data => x_msg_data
1355: ,x_remaining_amount => l_amt_due_remaining);
1356: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1357: l_error_flag := TRUE;
1358: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
1359: ||l_inv_cur.contract_number
1360: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);

Line 1576: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1572: --then the parent stm can be invalidated
1573: l_late_stm_id := l_stm_id;
1574:
1575: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1576: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1577: l_error_flag := TRUE;
1578: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1579: ELSE
1580: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');

Line 1630: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1626:
1627: l_sel_id := lx_selv_rec.id;
1628: l_sec_rec_inv_id := lx_selv_rec.source_id;
1629:
1630: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1631: l_error_flag := TRUE;
1632: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
1633:
1634: ||l_inv_cur.contract_number

Line 1726: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1722: l_stm_id := lx_stmv_rec.id;
1723: l_se_line_number := 1;
1724:
1725: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1726: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1727: l_error_flag := TRUE;
1728: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1729: ELSE
1730: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');

Line 1774: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1770: x_msg_data,
1771: l_selv_rec,
1772: lx_selv_rec);
1773:
1774: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1775: l_error_flag := TRUE;
1776: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1777: ||l_inv_cur.contract_number
1778: ||' Stream Purpose: '||cns_late_fee

Line 1885: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1881: l_stm_id := lx_stmv_rec.id;
1882: l_se_line_number := 1;
1883:
1884: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1885: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1886: l_error_flag := TRUE;
1887: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1888: ELSE
1889: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

Line 1928: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1924: x_msg_data,
1925: l_selv_rec,
1926: lx_selv_rec);
1927:
1928: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1929: l_error_flag := TRUE;
1930: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1931: ||l_inv_cur.contract_number
1932: ||' Stream Purpose: '||cns_late_fee

Line 2013: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2009: --dkagrawa bug# 4728636 changes end
2010:
2011:
2012: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End of Calculate charges.');
2013: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2014: x_return_status := l_return_status;
2015:
2016: EXCEPTION
2017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 2017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2013: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2014: x_return_status := l_return_status;
2015:
2016: EXCEPTION
2017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2018: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
2019: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,

Line 2019: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2015:
2016: EXCEPTION
2017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2018: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
2019: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,
2022: G_PKG_NAME,
2023: 'Okl_Api.G_RET_STS_ERROR',

Line 2023: 'Okl_Api.G_RET_STS_ERROR',

2019: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,
2022: G_PKG_NAME,
2023: 'Okl_Api.G_RET_STS_ERROR',
2024: x_msg_count,
2025: x_msg_data,
2026: '_PVT'
2027: );

Line 2028: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2024: x_msg_count,
2025: x_msg_data,
2026: '_PVT'
2027: );
2028: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXCP) => '||SQLERRM);
2030: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2031: (
2032: l_api_name,

Line 2030: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2026: '_PVT'
2027: );
2028: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2029: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXCP) => '||SQLERRM);
2030: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2031: (
2032: l_api_name,
2033: G_PKG_NAME,
2034: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2034: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2030: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2031: (
2032: l_api_name,
2033: G_PKG_NAME,
2034: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2035: x_msg_count,
2036: x_msg_data,
2037: '_PVT'
2038: );

Line 2041: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2037: '_PVT'
2038: );
2039: WHEN OTHERS THEN
2040: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (Other) => '||SQLERRM);
2041: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2042: (
2043: l_api_name,
2044: G_PKG_NAME,
2045: 'OTHERS',