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 610: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

606: ---
607: --- END DECLARE
608: ---
609: BEGIN
610: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
611: G_PKG_NAME,
612: p_init_msg_list,
613: l_api_version,
614: p_api_version,

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

615: '_PVT',
616: x_return_status);
617:
618:
619: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_ERROR;
623: END IF;

Line 620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

616: x_return_status);
617:
618:
619: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_ERROR;
623: END IF;
624:

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

617:
618:
619: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_ERROR;
623: END IF;
624:
625: l_init_msg_list := p_init_msg_list ;

Line 622: RAISE OKL_API.G_EXCEPTION_ERROR;

618:
619: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
622: RAISE OKL_API.G_EXCEPTION_ERROR;
623: END IF;
624:
625: l_init_msg_list := p_init_msg_list ;
626:

Line 655: ,p_init_msg_list => OKL_API.G_FALSE

651: l_rec_inv_id := l_inv_cur.CONSOLIDATED_INVOICE_ID;
652: -- Get the amount_due_remaining
653: OKL_BILLING_UTIL_PVT.get_contract_invoice_balance(
654: p_api_version => 1.0
655: ,p_init_msg_list => OKL_API.G_FALSE
656: ,p_contract_number => l_inv_cur.CONTRACT_NUMBER
657: ,p_trx_number => l_inv_cur.consolidated_invoice_number
658: ,x_return_status => x_return_status
659: ,x_msg_count => x_msg_count

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

658: ,x_return_status => x_return_status
659: ,x_msg_count => x_msg_count
660: ,x_msg_data => x_msg_data
661: ,x_remaining_amount => l_amt_due_remaining);
662: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
663: l_error_flag := TRUE;
664: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
665: ||l_inv_cur.contract_number
666: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);

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

863: --then the parent stm can be invalidated
864: l_late_stm_id := l_stm_id;
865:
866:
867: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
868: l_error_flag := TRUE;
869: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for LATE FEE');
870: ELSE
871: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for LATE FEE');

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

921: l_sel_id := lx_selv_rec.id;
922:
923: --l_sec_rec_inv_id := lx_selv_rec.source_id;
924:
925: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
926: l_error_flag := TRUE;
927: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
928:
929: ||l_inv_cur.contract_number

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

1013: l_stm_id := lx_stmv_rec.id;
1014: l_se_line_number := 1;
1015:
1016: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1017: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1018: l_error_flag := TRUE;
1019: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1020: ELSE
1021: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

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

1054: x_msg_data,
1055: l_selv_rec,
1056: lx_selv_rec);
1057:
1058: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1059: l_error_flag := TRUE;
1060: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1061: ||l_inv_cur.contract_number
1062: ||' Stream Purpose: '||cns_late_fee

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

1163: l_stm_id := lx_stmv_rec.id;
1164: l_se_line_number := 1;
1165:
1166: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1167: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1168: l_error_flag := TRUE;
1169: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1170: ELSE
1171: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

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

1205: x_msg_data,
1206: l_selv_rec,
1207: lx_selv_rec);
1208:
1209: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1210: l_error_flag := TRUE;
1211: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1212: ||l_inv_cur.contract_number
1213: ||' Stream Purpose: '||cns_late_fee

Line 1341: ,p_init_msg_list => OKL_API.G_FALSE

1337: l_rec_inv_id := l_inv_cur.CONSOLIDATED_INVOICE_ID;
1338: -- Get the amount_due_remaining
1339: OKL_BILLING_UTIL_PVT.get_contract_invoice_balance(
1340: p_api_version => 1.0
1341: ,p_init_msg_list => OKL_API.G_FALSE
1342: ,p_contract_number => l_inv_cur.CONTRACT_NUMBER
1343: ,p_trx_number => l_inv_cur.consolidated_invoice_number
1344: ,x_return_status => x_return_status
1345: ,x_msg_count => x_msg_count

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

1344: ,x_return_status => x_return_status
1345: ,x_msg_count => x_msg_count
1346: ,x_msg_data => x_msg_data
1347: ,x_remaining_amount => l_amt_due_remaining);
1348: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1349: l_error_flag := TRUE;
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error fetching Consolidated Invoice Balance for contract: '
1351: ||l_inv_cur.contract_number
1352: ||' consolidated_invoice_number: '||l_inv_cur.consolidated_invoice_number);

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

1564: --then the parent stm can be invalidated
1565: l_late_stm_id := l_stm_id;
1566:
1567: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1568: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1569: l_error_flag := TRUE;
1570: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for LATE FEE');
1571: ELSE
1572: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for LATE FEE');

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

1618:
1619: l_sel_id := lx_selv_rec.id;
1620: l_sec_rec_inv_id := lx_selv_rec.source_id;
1621:
1622: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1623: l_error_flag := TRUE;
1624: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Stream Element for Contract: '
1625:
1626: ||l_inv_cur.contract_number

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

1714: l_stm_id := lx_stmv_rec.id;
1715: l_se_line_number := 1;
1716:
1717: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1718: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1719: l_error_flag := TRUE;
1720: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Streams for INVESTOR LATE FEE PAYABLE');
1721: ELSE
1722: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Streams for INVESTOR LATE FEE PAYABLE');

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

1762: x_msg_data,
1763: l_selv_rec,
1764: lx_selv_rec);
1765:
1766: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1767: l_error_flag := TRUE;
1768: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1769: ||l_inv_cur.contract_number
1770: ||' Stream Purpose: '||cns_late_fee

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

1873: l_stm_id := lx_stmv_rec.id;
1874: l_se_line_number := 1;
1875:
1876: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Stream element line number => ' || l_se_line_number);
1877: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1878: l_error_flag := TRUE;
1879: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Creating Stream for INVESTOR LATE FEE PAYABLE');
1880: ELSE
1881: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- SUCCESS: Creating Stream for INVESTOR LATE FEE PAYABLE');

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

1916: x_msg_data,
1917: l_selv_rec,
1918: lx_selv_rec);
1919:
1920: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1921: l_error_flag := TRUE;
1922: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Error Creating Payable Stream Element for Contract: '
1923: ||l_inv_cur.contract_number
1924: ||' Stream Purpose: '||cns_late_fee

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

2001: --dkagrawa bug# 4728636 changes end
2002:
2003:
2004: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End of Calculate charges.');
2005: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2006: x_return_status := l_return_status;
2007:
2008: EXCEPTION
2009: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 2009: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2005: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2006: x_return_status := l_return_status;
2007:
2008: EXCEPTION
2009: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2010: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
2011: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2012: (
2013: l_api_name,

Line 2011: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2007:
2008: EXCEPTION
2009: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2010: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
2011: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2012: (
2013: l_api_name,
2014: G_PKG_NAME,
2015: 'Okl_Api.G_RET_STS_ERROR',

Line 2015: 'Okl_Api.G_RET_STS_ERROR',

2011: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2012: (
2013: l_api_name,
2014: G_PKG_NAME,
2015: 'Okl_Api.G_RET_STS_ERROR',
2016: x_msg_count,
2017: x_msg_data,
2018: '_PVT'
2019: );

Line 2020: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2016: x_msg_count,
2017: x_msg_data,
2018: '_PVT'
2019: );
2020: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXCP) => '||SQLERRM);
2022: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2023: (
2024: l_api_name,

Line 2022: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2018: '_PVT'
2019: );
2020: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2021: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXCP) => '||SQLERRM);
2022: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2023: (
2024: l_api_name,
2025: G_PKG_NAME,
2026: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2026: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2022: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2023: (
2024: l_api_name,
2025: G_PKG_NAME,
2026: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2027: x_msg_count,
2028: x_msg_data,
2029: '_PVT'
2030: );

Line 2033: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2029: '_PVT'
2030: );
2031: WHEN OTHERS THEN
2032: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (Other) => '||SQLERRM);
2033: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2034: (
2035: l_api_name,
2036: G_PKG_NAME,
2037: 'OTHERS',