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 1730: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

1726: lp_sifv_rec.log_file := 'OKLSTXMLG_' || p_transaction_number || '.log ';
1727: ELSE
1728: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
1729: END IF;
1730: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1731: IF(IS_DEBUG_PROCEDURE_ON) THEN
1732: BEGIN
1733: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1734: END;

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

1729: END IF;
1730: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1731: IF(IS_DEBUG_PROCEDURE_ON) THEN
1732: BEGIN
1733: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1734: END;
1735: END IF;
1736: --Added by kthiruva for Debug Logging
1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

1734: END;
1735: END IF;
1736: --Added by kthiruva for Debug Logging
1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1739: END IF;
1740: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1741: p_api_version => p_api_version
1742: ,p_init_msg_list => p_init_msg_list

Line 1740: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(

1736: --Added by kthiruva for Debug Logging
1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1739: END IF;
1740: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1741: p_api_version => p_api_version
1742: ,p_init_msg_list => p_init_msg_list
1743: ,x_return_status => l_return_status
1744: ,x_msg_count => x_msg_count

Line 1750: 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);

1746: ,p_sifv_rec => lp_sifv_rec
1747: ,x_sifv_rec => lx_sifv_rec);
1748: --Added by kthiruva for Debug Logging
1749: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1750: 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);
1751: END IF;
1752:
1753: IF(IS_DEBUG_PROCEDURE_ON) THEN
1754: BEGIN

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

1751: END IF;
1752:
1753: IF(IS_DEBUG_PROCEDURE_ON) THEN
1754: BEGIN
1755: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1756: END;
1757: END IF;
1758: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1759: IF l_return_status = G_RET_STS_ERROR THEN

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

1754: BEGIN
1755: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1756: END;
1757: END IF;
1758: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1759: IF l_return_status = G_RET_STS_ERROR THEN
1760: RAISE G_EXCEPTION_ERROR;
1761: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1762: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 1991: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

1987: lp_init_msg_list VARCHAR2(1) := 'F';
1988: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1989: l_exception_data_found BOOLEAN := FALSE;
1990: lx_msg_count NUMBER;
1991: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1992: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1993: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
1994: SELECT
1995: ID,

Line 1992: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

1988: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1989: l_exception_data_found BOOLEAN := FALSE;
1990: lx_msg_count NUMBER;
1991: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1992: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1993: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
1994: SELECT
1995: ID,
1996: TRANSACTION_NUMBER,

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

2110: lp_sifv_rec.stream_interface_attribute03 := 'OKLSTXMLG_' || p_transaction_number || '.log ';
2111: ELSE
2112: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
2113: END IF;
2114: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2115: IF(IS_DEBUG_PROCEDURE_ON) THEN
2116: BEGIN
2117: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2118: END;

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

2113: END IF;
2114: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2115: IF(IS_DEBUG_PROCEDURE_ON) THEN
2116: BEGIN
2117: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2118: END;
2119: END IF;
2120: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2121: ,p_init_msg_list => lp_init_msg_list

Line 2120: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version

2116: BEGIN
2117: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2118: END;
2119: END IF;
2120: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2121: ,p_init_msg_list => lp_init_msg_list
2122: ,x_return_status => l_return_status
2123: ,x_msg_count => lx_msg_count
2124: ,x_msg_data => lx_msg_data

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

2126: ,x_sifv_rec => lx_sifv_rec);
2127:
2128: IF(IS_DEBUG_PROCEDURE_ON) THEN
2129: BEGIN
2130: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2131: END;
2132: END IF;
2133: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2134: IF l_return_status = G_RET_STS_ERROR THEN

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

2129: BEGIN
2130: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2131: END;
2132: END IF;
2133: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2134: IF l_return_status = G_RET_STS_ERROR THEN
2135: RAISE G_EXCEPTION_ERROR;
2136: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2137: RAISE G_EXCEPTION_UNEXPECTED_ERROR;