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_ESG_TRANSPORT_PVT dependencies on FND_LOG

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 83: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling UTL_HTTP.SET_WALLET');

79: utl_http.set_transfer_timeout(l_max_timeout);
80: -- bug8209104 start
81: IF upper(rec2.protocol_type) = 'HTTPS' THEN
82: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
83: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling UTL_HTTP.SET_WALLET');
84: END IF;
85:
86: l_path := 'file:' || fnd_profile.value('FND_DB_WALLET_DIR');
87: l_password := fnd_preference.eget('#INTERNAL','WF_WEBSERVICES','EWALLETPWD', 'WFWS_PWD');

Line 96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');

92: -- bug8209104 end
93:
94: -- request := utl_http.begin_request(l_url, 'POST', 'HTTP/1.0'); -- commented bug8209104
95: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');
97: END IF;
98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104
99: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');

Line 100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');

96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');
97: END IF;
98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104
99: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');
101: END IF;
102: utl_http.set_header(request, 'Content-Type', 'application/x-www-form-urlencoded');
103: utl_http.set_header(request, 'Content-Length', lengthb(l_parameter_data));
104: utl_http.write_text(request, l_parameter_data);

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 165: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);

161: BEGIN
162: x_return_status := G_RET_STS_SUCCESS;
163:
164: IF(G_DEBUG_ENABLED = 'Y') THEN
165: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
166: END IF;
167:
168: IF(G_DEBUG_ENABLED = 'Y') THEN
169: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

Line 169: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

165: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
166: END IF;
167:
168: IF(G_DEBUG_ENABLED = 'Y') THEN
169: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
170: END IF;
171:
172: IF(G_DEBUG_ENABLED = 'Y') THEN
173: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

Line 173: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

169: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
170: END IF;
171:
172: IF(G_DEBUG_ENABLED = 'Y') THEN
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');

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 202: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_ERROR, l_module, p_transaction_number||': '||SQLERRM(SQLCODE));

198:
199: EXCEPTION
200: WHEN OTHERS THEN
201: IF(G_IS_DEBUG_ERROR_ON) THEN
202: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_ERROR, l_module, p_transaction_number||': '||SQLERRM(SQLCODE));
203: END IF;
204:
205: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
206: p_msg_name => G_UNEXPECTED_ERROR,