DBA Data[Home] [Help]

APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_STREAM_INTERFACES_PUB

Line 617: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

613: j NUMBER := 0;
614: p_line_number NUMBER := 1;
615: p_first_line_number NUMBER := 1;
616: l_yield_data_flag NUMBER := 0;
617: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
618: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
619: l_sirv_rec sirv_rec_type;
620: p_sirv_rec sirv_rec_type;
621: l_no_data_found BOOLEAN := FALSE;

Line 618: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

614: p_line_number NUMBER := 1;
615: p_first_line_number NUMBER := 1;
616: l_yield_data_flag NUMBER := 0;
617: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
618: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
619: l_sirv_rec sirv_rec_type;
620: p_sirv_rec sirv_rec_type;
621: l_no_data_found BOOLEAN := FALSE;
622: l_exception_data_found BOOLEAN := FALSE;

Line 1783: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

1779: lp_sifv_rec.log_file := 'OKLSTXMLG_' || p_transaction_number || '.log ';
1780: ELSE
1781: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
1782: END IF;
1783: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1784: IF(IS_DEBUG_PROCEDURE_ON) THEN
1785: BEGIN
1786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1787: END;

Line 1786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

1782: END IF;
1783: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1784: IF(IS_DEBUG_PROCEDURE_ON) THEN
1785: BEGIN
1786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1787: END;
1788: END IF;
1789: --Added by kthiruva for Debug Logging
1790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');

1787: END;
1788: END IF;
1789: --Added by kthiruva for Debug Logging
1790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1792: END IF;
1793: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1794: p_api_version => p_api_version
1795: ,p_init_msg_list => p_init_msg_list

Line 1793: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(

1789: --Added by kthiruva for Debug Logging
1790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1792: END IF;
1793: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1794: p_api_version => p_api_version
1795: ,p_init_msg_list => p_init_msg_list
1796: ,x_return_status => l_return_status
1797: ,x_msg_count => x_msg_count

Line 1803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces, return status is :'|| x_return_status);

1799: ,p_sifv_rec => lp_sifv_rec
1800: ,x_sifv_rec => lx_sifv_rec);
1801: --Added by kthiruva for Debug Logging
1802: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces, return status is :'|| x_return_status);
1804: END IF;
1805:
1806: IF(IS_DEBUG_PROCEDURE_ON) THEN
1807: BEGIN

Line 1808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

1804: END IF;
1805:
1806: IF(IS_DEBUG_PROCEDURE_ON) THEN
1807: BEGIN
1808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1809: END;
1810: END IF;
1811: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1812: IF l_return_status = G_RET_STS_ERROR THEN

Line 1811: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

1807: BEGIN
1808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1809: END;
1810: END IF;
1811: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1812: IF l_return_status = G_RET_STS_ERROR THEN
1813: RAISE G_EXCEPTION_ERROR;
1814: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1815: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 2044: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

2040: lp_init_msg_list VARCHAR2(1) := 'F';
2041: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2042: l_exception_data_found BOOLEAN := FALSE;
2043: lx_msg_count NUMBER;
2044: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2045: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2046: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
2047: SELECT
2048: ID,

Line 2045: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

2041: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2042: l_exception_data_found BOOLEAN := FALSE;
2043: lx_msg_count NUMBER;
2044: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2045: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2046: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
2047: SELECT
2048: ID,
2049: TRANSACTION_NUMBER,

Line 2167: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

2163: lp_sifv_rec.stream_interface_attribute03 := 'OKLSTXMLG_' || p_transaction_number || '.log ';
2164: ELSE
2165: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
2166: END IF;
2167: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2168: IF(IS_DEBUG_PROCEDURE_ON) THEN
2169: BEGIN
2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2171: END;

Line 2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

2166: END IF;
2167: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2168: IF(IS_DEBUG_PROCEDURE_ON) THEN
2169: BEGIN
2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2171: END;
2172: END IF;
2173: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2174: ,p_init_msg_list => lp_init_msg_list

Line 2173: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version

2169: BEGIN
2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2171: END;
2172: END IF;
2173: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2174: ,p_init_msg_list => lp_init_msg_list
2175: ,x_return_status => l_return_status
2176: ,x_msg_count => lx_msg_count
2177: ,x_msg_data => lx_msg_data

Line 2183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

2179: ,x_sifv_rec => lx_sifv_rec);
2180:
2181: IF(IS_DEBUG_PROCEDURE_ON) THEN
2182: BEGIN
2183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2184: END;
2185: END IF;
2186: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2187: IF l_return_status = G_RET_STS_ERROR THEN

Line 2186: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

2182: BEGIN
2183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2184: END;
2185: END IF;
2186: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2187: IF l_return_status = G_RET_STS_ERROR THEN
2188: RAISE G_EXCEPTION_ERROR;
2189: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2190: RAISE G_EXCEPTION_UNEXPECTED_ERROR;