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 FND_API

Line 73: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

69:
70: BEGIN
71: FOR l_count in 1..p_message_count LOOP
72:
73: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
74: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
75: OPEN Get_Appl_Id (l_appl_short_name);
76: FETCH Get_Appl_Id into l_id;
77: CLOSE Get_Appl_Id;

Line 88: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

84: FETCH Get_Message_Num into l_message_num;
85: CLOSE Get_Message_Num;
86: END IF;
87:
88: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
89:
90: IF NVL(l_message_num, 0) <> 0
91: THEN
92: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

Line 100: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

96:
97: IF l_count = 1
98: THEN
99: l_msg_list := l_msg_list || l_temp_msg ||
100: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
101: ELSE
102: l_msg_list := l_msg_list || l_temp_msg ||
103: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
104: END IF;

Line 103: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

99: l_msg_list := l_msg_list || l_temp_msg ||
100: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
101: ELSE
102: l_msg_list := l_msg_list || l_temp_msg ||
103: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
104: END IF;
105:
106: l_msg_list := l_msg_list || '';
107:

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
171:
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173: --set error message,so this will be prefixed before the
174: --actual message, so it makes more sense than displaying an
175: -- OKL message.
176: AddfailMsg(

Line 266: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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');
270: Fnd_Msg_Pub.count_and_get(

Line 309: IF FND_API.to_Boolean( p_init_msg_list )

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
311: FND_MSG_PUB.initialize;
312: END IF;
313:

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310: THEN
311: FND_MSG_PUB.initialize;
312: END IF;
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315: --call refund_workflow
316: invoke_report_wf(
317: p_report_id=>p_report_id
318: ,x_return_status => l_return_status

Line 324: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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
327: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
328: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after calling WF' ||l_message);

Line 331: raise FND_API.G_EXC_ERROR;

327: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
328: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after calling WF' ||l_message);
329: END IF;
330: END IF;
331: raise FND_API.G_EXC_ERROR;
332: ELSE
333: FND_MSG_PUB.initialize;
334: END IF;
335:

Line 363: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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
366: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
367: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating cure reports'

Line 371: raise FND_API.G_EXC_ERROR;

367: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating cure reports'
368: ||l_message);
369: END IF;
370: END IF;
371: raise FND_API.G_EXC_ERROR;
372: ELSE
373: IF PG_DEBUG < 11 THEN
374: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
375: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Success -updated cure refund header' );

Line 381: IF x_return_status =FND_API.G_RET_STS_SUCCESS THEN

377: END IF;
378: FND_MSG_PUB.initialize;
379: END IF;
380:
381: IF x_return_status =FND_API.G_RET_STS_SUCCESS THEN
382: FND_MSG_PUB.initialize;
383: END IF;
384:
385: -- Standard check for p_commit

Line 386: IF FND_API.to_Boolean( p_commit )THEN

382: FND_MSG_PUB.initialize;
383: END IF;
384:
385: -- Standard check for p_commit
386: IF FND_API.to_Boolean( p_commit )THEN
387: COMMIT WORK;
388: END IF;
389:
390: FND_MSG_PUB.Count_And_Get

Line 398: WHEN Fnd_Api.G_EXC_ERROR THEN

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;
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 ;

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 401: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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(
405: p_count => x_msg_count

Line 407: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

403: x_msg_data := l_msg_data ;
404: Fnd_Msg_Pub.count_and_get(
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 ;

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 410: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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(
414: p_count => x_msg_count

Line 419: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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');
423: Fnd_Msg_Pub.count_and_get(

Line 497: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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
500: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
501: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating cure reports'

Line 505: raise FND_API.G_EXC_ERROR;

501: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating cure reports'
502: ||l_message);
503: END IF;
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:

Line 511: WHEN FND_API.G_EXC_ERROR THEN

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:
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',

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 601: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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
604: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating cure reports'

Line 609: raise FND_API.G_EXC_ERROR;

605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error after updating cure reports'
606: ||l_message);
607: END IF;
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:

Line 615: WHEN FND_API.G_EXC_ERROR THEN

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:
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',

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,