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_CURE_WF dependencies on OKL_CURE_WF

Line 1: PACKAGE BODY OKL_CURE_WF as

1: PACKAGE BODY OKL_CURE_WF as
2: /* $Header: OKLCOWFB.pls 120.4 2007/06/18 19:31:28 pdevaraj noship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 166: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : START');

162:
163:
164: BEGIN
165:
166: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : START');
167:
168: IF (G_DEBUG_ENABLED = 'Y') THEN
169: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
170: END IF;

Line 186: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_key : '|| l_key);

182: FETCH okl_key_csr INTO l_seq;
183: CLOSE okl_key_csr;
184: l_key := l_event_name ||'-'||l_seq;
185:
186: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_key : '|| l_key);
187:
188: IF PG_DEBUG < 11 THEN
189: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
190: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Event Key ' ||l_key);

Line 201: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_report_number : '|| l_report_number);

197: l_vendor_name;
198:
199: CLOSE c_get_ref_details;
200:
201: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_report_number : '|| l_report_number);
202: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_vendor_name : '|| l_vendor_name);
203:
204: OPEN c_get_agent (l_user_id);
205: FETCH c_get_agent INTO l_notification_agent;

Line 202: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_vendor_name : '|| l_vendor_name);

198:
199: CLOSE c_get_ref_details;
200:
201: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_report_number : '|| l_report_number);
202: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_vendor_name : '|| l_vendor_name);
203:
204: OPEN c_get_agent (l_user_id);
205: FETCH c_get_agent INTO l_notification_agent;
206: CLOSE c_get_Agent;

Line 212: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_notification_agent : '|| l_notification_agent);

208: IF l_notification_agent IS NULL THEN
209: l_notification_agent := 'SYSADMIN';
210: END IF;
211:
212: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : l_notification_agent : '|| l_notification_agent);
213:
214: wf_event.AddParameterToList('NOTIFY_AGENT',
215: l_notification_agent,
216: l_parameter_list);

Line 246: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : after launching cure request wf');

242:
243: COMMIT ;
244: l_parameter_list.DELETE;
245:
246: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : after launching cure request wf');
247:
248: IF PG_DEBUG < 11 THEN
249: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Successfully launched Cure REPORT workflow');

Line 260: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : END');

256: ( p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259:
260: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : END');
261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: ROLLBACK TO INVOKE_REPORT_WF;

Line 265: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : error launching cure request wf');

261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: ROLLBACK TO INVOKE_REPORT_WF;
265: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : error launching cure request wf');
266: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
267: x_msg_count := l_msg_count ;
268: x_msg_data := l_msg_data ;
269: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_WF','INVOKE_REPORT_WF');

Line 269: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_WF','INVOKE_REPORT_WF');

265: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : error launching cure request wf');
266: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
267: x_msg_count := l_msg_count ;
268: x_msg_data := l_msg_data ;
269: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_WF','INVOKE_REPORT_WF');
270: Fnd_Msg_Pub.count_and_get(
271: p_count => x_msg_count
272: ,p_data => x_msg_data);
273:

Line 305: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : START');

301:
302:
303: BEGIN
304:
305: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : START');
306: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : p_report_id : '||p_report_id);
307: SAVEPOINT APPROVE_CURE_REPORTS;
308: -- Initialize message list if p_init_msg_list is set to TRUE.
309: IF FND_API.to_Boolean( p_init_msg_list )

Line 306: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : p_report_id : '||p_report_id);

302:
303: BEGIN
304:
305: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : START');
306: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : p_report_id : '||p_report_id);
307: SAVEPOINT APPROVE_CURE_REPORTS;
308: -- Initialize message list if p_init_msg_list is set to TRUE.
309: IF FND_API.to_Boolean( p_init_msg_list )
310: THEN

Line 322: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : invoke_report_wf : '||l_return_status);

318: ,x_return_status => l_return_status
319: ,x_msg_count => l_msg_count
320: ,x_msg_data => l_msg_data );
321:
322: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : invoke_report_wf : '||l_return_status);
323:
324: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
325: Get_Messages (l_msg_count,l_message);
326: IF PG_DEBUG < 11 THEN

Line 361: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);

357: ,x_msg_data => l_msg_data
358: ,p_crtv_rec => lp_crtv_rec
359: ,x_crtv_rec => lx_crtv_rec);
360:
361: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);
362:
363: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
364: Get_Messages (l_msg_count,l_message);
365: IF PG_DEBUG < 11 THEN

Line 395: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : END');

391: ( p_count => x_msg_count,
392: p_data => x_msg_data
393: );
394:
395: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : END');
396:
397: EXCEPTION
398: WHEN Fnd_Api.G_EXC_ERROR THEN
399: ROLLBACK TO APPROVE_CURE_REPORTS;

Line 400: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : Fnd_Api.G_EXC_ERROR');

396:
397: EXCEPTION
398: WHEN Fnd_Api.G_EXC_ERROR THEN
399: ROLLBACK TO APPROVE_CURE_REPORTS;
400: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : Fnd_Api.G_EXC_ERROR');
401: x_return_status := Fnd_Api.G_RET_STS_ERROR;
402: x_msg_count := l_msg_count ;
403: x_msg_data := l_msg_data ;
404: Fnd_Msg_Pub.count_and_get(

Line 409: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : Fnd_Api.G_EXC_UNEXPECTED_ERROR');

405: p_count => x_msg_count
406: ,p_data => x_msg_data);
407: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO APPROVE_CURE_REPORTS;
409: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : Fnd_Api.G_EXC_UNEXPECTED_ERROR');
410: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
411: x_msg_count := l_msg_count ;
412: x_msg_data := l_msg_data ;
413: Fnd_Msg_Pub.count_and_get(

Line 418: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : OTHERS');

414: p_count => x_msg_count
415: ,p_data => x_msg_data);
416: WHEN OTHERS THEN
417: ROLLBACK TO APPROVE_CURE_REPORTS;
418: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : OTHERS');
419: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
420: x_msg_count := l_msg_count ;
421: x_msg_data := l_msg_data ;
422: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_WF','APPROVE_CURE_REPORTS');

Line 422: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_WF','APPROVE_CURE_REPORTS');

418: okl_debug_pub.logmessage('OKL_CURE_WF: approve_cure_reports : OTHERS');
419: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
420: x_msg_count := l_msg_count ;
421: x_msg_data := l_msg_data ;
422: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_WF','APPROVE_CURE_REPORTS');
423: Fnd_Msg_Pub.count_and_get(
424: p_count => x_msg_count
425: ,p_data => x_msg_data);
426:

Line 461: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : START');

457:
458:
459: BEGIN
460:
461: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : START');
462:
463: IF (G_DEBUG_ENABLED = 'Y') THEN
464: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
465: END IF;

Line 477: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : l_cure_report_id : '||l_cure_report_id);

473: itemtype => itemtype,
474: itemkey => itemkey,
475: aname => 'REPORT_ID');
476:
477: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : l_cure_report_id : '||l_cure_report_id);
478:
479: lp_crtv_rec.cure_report_id :=l_cure_report_id;
480: lp_crtv_rec.approval_status :='APPROVED';
481:

Line 495: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);

491: ,x_msg_data => l_msg_data
492: ,p_crtv_rec => lp_crtv_rec
493: ,x_crtv_rec => lx_crtv_rec);
494:
495: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);
496:
497: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
498: Get_Messages (l_msg_count,l_message);
499: IF PG_DEBUG < 11 THEN

Line 508: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : END');

504: END IF;
505: raise FND_API.G_EXC_ERROR;
506: END IF;
507:
508: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : END');
509:
510: EXCEPTION
511: WHEN FND_API.G_EXC_ERROR THEN
512:

Line 513: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : FND_API.G_EXC_ERROR');

509:
510: EXCEPTION
511: WHEN FND_API.G_EXC_ERROR THEN
512:
513: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : FND_API.G_EXC_ERROR');
514: --resultout := wf_engine.eng_completed ||':'||wf_no;
515: wf_core.context('OKL_CURE_WF',
516: 'set_approval_status',
517: itemtype,

Line 515: wf_core.context('OKL_CURE_WF',

511: WHEN FND_API.G_EXC_ERROR THEN
512:
513: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : FND_API.G_EXC_ERROR');
514: --resultout := wf_engine.eng_completed ||':'||wf_no;
515: wf_core.context('OKL_CURE_WF',
516: 'set_approval_status',
517: itemtype,
518: itemkey,
519: to_char(actid),

Line 524: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : OTHERS');

520: funcmode);
521: raise;
522:
523: when others then
524: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : OTHERS');
525: --resultout := wf_engine.eng_completed ||':'||wf_no;
526: wf_core.context('OKL_CURE_WF',
527: 'set_approval_status',
528: itemtype,

Line 526: wf_core.context('OKL_CURE_WF',

522:
523: when others then
524: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : OTHERS');
525: --resultout := wf_engine.eng_completed ||':'||wf_no;
526: wf_core.context('OKL_CURE_WF',
527: 'set_approval_status',
528: itemtype,
529: itemkey,
530: to_char(actid),

Line 564: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : START');

560:
561:
562: BEGIN
563:
564: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : START');
565:
566: IF (G_DEBUG_ENABLED = 'Y') THEN
567: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
568: END IF;

Line 581: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : l_cure_report_id : '||l_cure_report_id);

577: itemkey => itemkey,
578: aname => 'REPORT_ID');
579:
580:
581: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : l_cure_report_id : '||l_cure_report_id);
582:
583: lp_crtv_rec.cure_report_id :=l_cure_report_id;
584: lp_crtv_rec.approval_status :='REJECTED';
585:

Line 599: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);

595: ,x_msg_data => l_msg_data
596: ,p_crtv_rec => lp_crtv_rec
597: ,x_crtv_rec => lx_crtv_rec);
598:
599: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);
600:
601: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
602: Get_Messages (l_msg_count,l_message);
603: IF PG_DEBUG < 11 THEN

Line 612: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : END');

608: END IF;
609: raise FND_API.G_EXC_ERROR;
610: END IF;
611:
612: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : END');
613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616:

Line 617: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : FND_API.G_EXC_ERROR');

613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616:
617: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : FND_API.G_EXC_ERROR');
618: --resultout := wf_engine.eng_completed ||':'||wf_no;
619: wf_core.context('OKL_CURE_WF',
620: 'set_reject_status',
621: itemtype,

Line 619: wf_core.context('OKL_CURE_WF',

615: WHEN FND_API.G_EXC_ERROR THEN
616:
617: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : FND_API.G_EXC_ERROR');
618: --resultout := wf_engine.eng_completed ||':'||wf_no;
619: wf_core.context('OKL_CURE_WF',
620: 'set_reject_status',
621: itemtype,
622: itemkey,
623: to_char(actid),

Line 629: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : OTHERS');

625: raise;
626:
627: when others then
628:
629: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : OTHERS');
630: --resultout := wf_engine.eng_completed ||':'||wf_no;
631: wf_core.context('OKL_CURE_WF',
632: 'set_reject_status',
633: itemtype,

Line 631: wf_core.context('OKL_CURE_WF',

627: when others then
628:
629: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : OTHERS');
630: --resultout := wf_engine.eng_completed ||':'||wf_no;
631: wf_core.context('OKL_CURE_WF',
632: 'set_reject_status',
633: itemtype,
634: itemkey,
635: to_char(actid),

Line 641: END OKL_CURE_WF;

637: raise;
638:
639: END set_reject_status;
640:
641: END OKL_CURE_WF;