APPS.OKL_ESG_TRANSPORT_PVT dependencies on OKL_ESG_TRANSPORT_PVT

Line 1: PACKAGE BODY OKL_ESG_TRANSPORT_PVT AS

1: PACKAGE BODY OKL_ESG_TRANSPORT_PVT AS
2: /* $Header: OKLESTRB.pls 120.0.12010000.2 2009/02/19 20:21:59 djanaswa ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PRIVATE MEMBER VARIABLES

Line 7: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';

3:
4: ---------------------------------------------------------------------------
5: -- PRIVATE MEMBER VARIABLES
6: ---------------------------------------------------------------------------
7: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
8: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
9: G_IS_DEBUG_EXCEPTION_ON BOOLEAN;
10: G_IS_DEBUG_ERROR_ON BOOLEAN;
11: G_IS_DEBUG_PROCEDURE_ON BOOLEAN;

Line 51: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.transport');

47: l_api_name CONSTANT VARCHAR2(30) := 'transport';
48: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||p_transaction_number;
49: BEGIN
50: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
51: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.transport');
52: END IF;
53:
54: OPEN c_tp;
55: FETCH c_tp INTO rec;

Line 114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.transport');

110: utl_http.read_text(response, inbound_buffer);
111: utl_http.end_response(response);
112:
113: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.transport');
115: END IF;
116: END transport;
117:
118: PROCEDURE store_outxml(p_transaction_number IN NUMBER, p_xml IN CLOB)

Line 126: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.store_outxml');

122: l_api_name CONSTANT VARCHAR2(30) := 'store_outxml';
123: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||p_transaction_number;
124: BEGIN
125: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
126: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.store_outxml');
127: END IF;
128:
129: INSERT INTO OKL_STREAM_TRX_DATA
130: (id, transaction_number, out_xml)

Line 140: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.store_outxml');

136:
137: COMMIT;
138:
139: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
140: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.store_outxml');
141: END IF;
142:
143: END store_outxml;
144:

Line 177: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.process_esg');

173: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
174: END IF;
175:
176: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
177: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.process_esg');
178: END IF;
179:
180: ----------------------------------------------------------------------------------
181: -- 1. Generate an outbound xml document from XML Gateway

Line 196: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.process_esg');

192: ----------------------------------------------------------------------------------
193: transport(p_transaction_number);
194:
195: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
196: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.process_esg');
197: END IF;
198:
199: EXCEPTION
200: WHEN OTHERS THEN

Line 215: END OKL_ESG_TRANSPORT_PVT;

211: );
212: x_return_status := G_RET_STS_UNEXP_ERROR;
213: END process_esg;
214:
215: END OKL_ESG_TRANSPORT_PVT;