DBA Data[Home] [Help]

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 attach_trx_state(p_trx_num number) is

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

274: l_purpose_code varchar2(20);
275:
276: BEGIN
277: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
278: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.store_outxml');
279: END IF;
280:
281: -- get the current contract_id. this could be a copy_contract_id
282: select khr_id

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

328:
329: commit;
330:
331: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.store_outxml');
333: END IF;
334:
335: END store_outxml;
336:

Line 357: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);

353: BEGIN
354: x_return_status := G_RET_STS_SUCCESS;
355:
356: IF(G_DEBUG_ENABLED = 'Y') THEN
357: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
358: END IF;
359:
360: IF(G_DEBUG_ENABLED = 'Y') THEN
361: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

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

357: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
358: END IF;
359:
360: IF(G_DEBUG_ENABLED = 'Y') THEN
361: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
362: END IF;
363:
364: IF(G_DEBUG_ENABLED = 'Y') THEN
365: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

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

361: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
362: END IF;
363:
364: IF(G_DEBUG_ENABLED = 'Y') THEN
365: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
366: END IF;
367:
368: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
369: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.process_esg');

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

365: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
366: END IF;
367:
368: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
369: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': begin okl_esg_transport_pvt.process_esg');
370: END IF;
371:
372: ----------------------------------------------------------------------------------
373: -- 1. Generate an outbound xml document from XML Gateway

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

384: ----------------------------------------------------------------------------------
385: transport(p_transaction_number);
386:
387: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
388: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.process_esg');
389: END IF;
390:
391: EXCEPTION
392: WHEN OTHERS THEN

Line 394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_ERROR, l_module, p_transaction_number||': '||SQLERRM(SQLCODE));

390:
391: EXCEPTION
392: WHEN OTHERS THEN
393: IF(G_IS_DEBUG_ERROR_ON) THEN
394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_ERROR, l_module, p_transaction_number||': '||SQLERRM(SQLCODE));
395: END IF;
396:
397: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
398: p_msg_name => G_UNEXPECTED_ERROR,