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

Line 24: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

20: FROM DUAL;
21:
22: BEGIN
23:
24: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
26: 'OKL_VSS_WF.raise_business_event.',
27: 'Begin(+)');
28: END IF;

Line 25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

21:
22: BEGIN
23:
24: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
26: 'OKL_VSS_WF.raise_business_event.',
27: 'Begin(+)');
28: END IF;
29:

Line 65: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

61: p_parameters => l_parameter_list);
62:
63: l_parameter_list.DELETE;
64:
65: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
67: 'OKL_VSS_WF.raise_business_event.',
68: 'End(-)');
69: END IF;

Line 66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

62:
63: l_parameter_list.DELETE;
64:
65: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
67: 'OKL_VSS_WF.raise_business_event.',
68: 'End(-)');
69: END IF;
70:

Line 80: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

76: IF okl_key_csr%ISOPEN THEN
77: CLOSE okl_key_csr;
78: END IF;
79: ROLLBACK TO raise_business_event_sv;
80: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
82: 'OKL_VSS_WF.raise_business_event.',
83: 'EXP - OTHERS');
84: END IF;

Line 81: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

77: CLOSE okl_key_csr;
78: END IF;
79: ROLLBACK TO raise_business_event_sv;
80: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
82: 'OKL_VSS_WF.raise_business_event.',
83: 'EXP - OTHERS');
84: END IF;
85:

Line 121: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

117: i NUMBER :=0;
118:
119: BEGIN
120:
121: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
123: 'OKL_VSS_WF.createRepurchaseQuote.',
124: 'Begin(+)');
125: END IF;

Line 122: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

118:
119: BEGIN
120:
121: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
123: 'OKL_VSS_WF.createRepurchaseQuote.',
124: 'Begin(+)');
125: END IF;
126:

Line 153: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

149: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: END IF;
152:
153: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
155: 'OKL_VSS_WF.createRepurchaseQuote.',
156: 'End(-)');
157: END IF;

Line 154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: END IF;
152:
153: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
155: 'OKL_VSS_WF.createRepurchaseQuote.',
156: 'End(-)');
157: END IF;
158: -- Raise Event

Line 172: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

168: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
174: 'OKL_VSS_WF.createRepurchaseQuote.',
175: 'EXP - G_EXCEPTION_ERROR');
176: END IF;

Line 173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

169: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
174: 'OKL_VSS_WF.createRepurchaseQuote.',
175: 'EXP - G_EXCEPTION_ERROR');
176: END IF;
177:

Line 182: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
179: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
180: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
181: p_data => x_msg_data);
182: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: 'OKL_VSS_WF.createRepurchaseQuote.',
185: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
186: END IF;

Line 183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

179: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
180: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
181: p_data => x_msg_data);
182: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: 'OKL_VSS_WF.createRepurchaseQuote.',
185: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
186: END IF;
187:

Line 193: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','update_counter');
191: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
192: p_data => x_msg_data);
193: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
195: 'OKL_VSS_WF.createRepurchaseQuote.',
196: 'EXP - OTHERS');
197: END IF;

Line 194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

190: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','update_counter');
191: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
192: p_data => x_msg_data);
193: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
195: 'OKL_VSS_WF.createRepurchaseQuote.',
196: 'EXP - OTHERS');
197: END IF;
198:

Line 242: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

238:
239:
240: BEGIN
241:
242: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
244: 'OKL_VSS_WF.getCountersMessage.',
245: 'Begin(+)');
246: END IF;

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

239:
240: BEGIN
241:
242: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
244: 'OKL_VSS_WF.getCountersMessage.',
245: 'Begin(+)');
246: END IF;
247:

Line 308: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

304: return;
305: end if;
306:
307:
308: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
310: 'OKL_VSS_WF.getCountersMessage.',
311: 'End(-)');
312: END IF;

Line 309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

305: end if;
306:
307:
308: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
310: 'OKL_VSS_WF.getCountersMessage.',
311: 'End(-)');
312: END IF;
313:

Line 319: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

315: when others then
316: WF_CORE.CONTEXT ('okl_ssc_wf', 'getCountersMessage', itemtype, itemkey,actid,funcmode);
317: resultout := 'ERROR';
318:
319: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
321: 'OKL_VSS_WF.getCountersMessage.',
322: 'EXP - OTHERS');
323: END IF;

Line 320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

316: WF_CORE.CONTEXT ('okl_ssc_wf', 'getCountersMessage', itemtype, itemkey,actid,funcmode);
317: resultout := 'ERROR';
318:
319: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
321: 'OKL_VSS_WF.getCountersMessage.',
322: 'EXP - OTHERS');
323: END IF;
324: raise;

Line 389: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

385: NL VARCHAR2(1) := fnd_global.newline;
386:
387: BEGIN
388:
389: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
391: 'OKL_VSS_WF.getCountersDocument.',
392: 'Begin(+)');
393: END IF;

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

386:
387: BEGIN
388:
389: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
391: 'OKL_VSS_WF.getCountersDocument.',
392: 'Begin(+)');
393: END IF;
394:

Line 442: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

438: END IF;-- end to 'text/html' display type
439:
440: wf_notification.WriteToClob( document, l_document);
441:
442: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
444: 'OKL_VSS_WF.getCountersDocument.',
445: 'End(-)');
446: END IF;

Line 443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

439:
440: wf_notification.WriteToClob( document, l_document);
441:
442: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
444: 'OKL_VSS_WF.getCountersDocument.',
445: 'End(-)');
446: END IF;
447:

Line 453: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

449:
450: when others then
451: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getCountersDocument', l_itemtype, l_itemkey);
452:
453: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
455: 'OKL_VSS_WF.getCountersDocument.',
456: 'EXP - OTHERS');
457: END IF;

Line 454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

450: when others then
451: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getCountersDocument', l_itemtype, l_itemkey);
452:
453: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
455: 'OKL_VSS_WF.getCountersDocument.',
456: 'EXP - OTHERS');
457: END IF;
458: raise;

Line 503: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

499:
500:
501: BEGIN
502:
503: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
505: 'OKL_VSS_WF.update_counter.',
506: 'Begin(+)');
507: END IF;

Line 504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

500:
501: BEGIN
502:
503: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
505: 'OKL_VSS_WF.update_counter.',
506: 'Begin(+)');
507: END IF;
508:

Line 550: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

546: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;
549:
550: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
552: 'OKL_VSS_WF.update_counter.',
553: 'End(-)');
554: END IF;

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;
549:
550: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
552: 'OKL_VSS_WF.update_counter.',
553: 'End(-)');
554: END IF;
555:

Line 562: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

558: WHEN OKL_API.G_EXCEPTION_ERROR THEN
559: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
560: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
561: p_data => x_msg_data);
562: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'OKL_VSS_WF.update_counter.',
565: 'EXP - G_EXCEPTION_ERROR');
566: END IF;

Line 563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

559: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
560: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
561: p_data => x_msg_data);
562: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'OKL_VSS_WF.update_counter.',
565: 'EXP - G_EXCEPTION_ERROR');
566: END IF;
567:

Line 572: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

568: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
569: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
571: p_data => x_msg_data);
572: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
574: 'OKL_VSS_WF.update_counter.',
575: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
576: END IF;

Line 573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

569: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
571: p_data => x_msg_data);
572: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
574: 'OKL_VSS_WF.update_counter.',
575: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
576: END IF;
577:

Line 584: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

580: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','update_counter');
581: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
582: p_data => x_msg_data);
583:
584: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
586: 'OKL_VSS_WF.update_counter.',
587: 'EXP - OTHERS');
588: END IF;

Line 585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

581: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
582: p_data => x_msg_data);
583:
584: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
586: 'OKL_VSS_WF.update_counter.',
587: 'EXP - OTHERS');
588: END IF;
589:

Line 609: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

605: error_updating_counters EXCEPTION;
606:
607: begin
608:
609: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
611: 'OKL_VSS_WF.update_counter_fnc.',
612: 'Begin(+)');
613: END IF;

Line 610: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

606:
607: begin
608:
609: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
611: 'OKL_VSS_WF.update_counter_fnc.',
612: 'Begin(+)');
613: END IF;
614: -- assign variable to attribute

Line 664: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

660: else
661: resultout := wf_engine.eng_timedout;
662: return;
663: end if;
664: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
665: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
666: 'OKL_VSS_WF.update_counter_fnc.',
667: 'End(-)');
668: END IF;

Line 665: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

661: resultout := wf_engine.eng_timedout;
662: return;
663: end if;
664: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
665: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
666: 'OKL_VSS_WF.update_counter_fnc.',
667: 'End(-)');
668: END IF;
669:

Line 674: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

670: exception
671: when others then
672: WF_CORE.CONTEXT ('okl_ssc_wf', 'update_counter_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);
673: resultout := 'ERROR';
674: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
676: 'OKL_VSS_WF.update_counter_fnc.',
677: 'EXP - OTHERS');
678: END IF;

Line 675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

671: when others then
672: WF_CORE.CONTEXT ('okl_ssc_wf', 'update_counter_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);
673: resultout := 'ERROR';
674: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
676: 'OKL_VSS_WF.update_counter_fnc.',
677: 'EXP - OTHERS');
678: END IF;
679: raise;

Line 732: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

728: api_exception EXCEPTION;
729:
730: BEGIN
731:
732: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
734: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',
735: 'Begin(+)');
736: END IF;

Line 733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

729:
730: BEGIN
731:
732: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
734: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',
735: 'Begin(+)');
736: END IF;
737:

Line 845: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

841: resultout := wf_engine.eng_timedout;
842: RETURN;
843: END IF;
844:
845: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
847: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',
848: 'End(-)');
849: END IF;

Line 846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

842: RETURN;
843: END IF;
844:
845: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
847: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',
848: 'End(-)');
849: END IF;
850:

Line 855: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

851: EXCEPTION
852: WHEN OTHERS THEN
853: WF_CORE.CONTEXT (G_PKG_NAME, 'populate_req_repqte_attr_wf', itemtype, itemkey);
854:
855: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
856: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
857: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',
858: 'EXP - OTHERS');
859: END IF;

Line 856: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

852: WHEN OTHERS THEN
853: WF_CORE.CONTEXT (G_PKG_NAME, 'populate_req_repqte_attr_wf', itemtype, itemkey);
854:
855: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
856: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
857: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',
858: 'EXP - OTHERS');
859: END IF;
860: RAISE;

Line 886: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

882:
883: l_notify_response VARCHAR2(30);
884: BEGIN
885:
886: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
888: 'OKL_VSS_WF.approve_quote_status.',
889: 'Begin(+)');
890: END IF;

Line 887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

883: l_notify_response VARCHAR2(30);
884: BEGIN
885:
886: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
888: 'OKL_VSS_WF.approve_quote_status.',
889: 'Begin(+)');
890: END IF;
891:

Line 954: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

950: RETURN;
951: --
952: END IF;
953:
954: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
955: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
956: 'OKL_VSS_WF.approve_quote_status.',
957: 'End(-)');
958: END IF;

Line 955: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

951: --
952: END IF;
953:
954: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
955: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
956: 'OKL_VSS_WF.approve_quote_status.',
957: 'End(-)');
958: END IF;
959:

Line 966: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

962: WHEN API_ERROR THEN
963:
964: wf_core.context('OKL_VSS_WF' , 'approve_quote_status', itemtype, itemkey, actid, funcmode);
965:
966: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
968: 'OKL_VSS_WF.approve_quote_status.',
969: 'EXP - API_ERROR');
970: END IF;

Line 967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

963:
964: wf_core.context('OKL_VSS_WF' , 'approve_quote_status', itemtype, itemkey, actid, funcmode);
965:
966: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
968: 'OKL_VSS_WF.approve_quote_status.',
969: 'EXP - API_ERROR');
970: END IF;
971: RAISE;

Line 977: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

973: WHEN OTHERS THEN
974:
975: wf_core.context('OKL_VSS_WF' , 'approve_quote_status', itemtype, itemkey, actid, funcmode);
976:
977: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
979: 'OKL_VSS_WF.approve_quote_status.',
980: 'EXP - OTHERS');
981: END IF;

Line 978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

974:
975: wf_core.context('OKL_VSS_WF' , 'approve_quote_status', itemtype, itemkey, actid, funcmode);
976:
977: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
979: 'OKL_VSS_WF.approve_quote_status.',
980: 'EXP - OTHERS');
981: END IF;
982:

Line 1009: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1005:
1006: l_notify_response VARCHAR2(30);
1007: BEGIN
1008:
1009: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1011: 'OKL_VSS_WF.reject_quote_status.',
1012: 'Begin(+)');
1013: END IF;

Line 1010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1006: l_notify_response VARCHAR2(30);
1007: BEGIN
1008:
1009: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1011: 'OKL_VSS_WF.reject_quote_status.',
1012: 'Begin(+)');
1013: END IF;
1014:

Line 1074: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1070: RETURN;
1071: --
1072: END IF;
1073:
1074: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1076: 'OKL_VSS_WF.reject_quote_status.',
1077: 'End(-)');
1078: END IF;

Line 1075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1071: --
1072: END IF;
1073:
1074: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1076: 'OKL_VSS_WF.reject_quote_status.',
1077: 'End(-)');
1078: END IF;
1079:

Line 1086: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1082: WHEN API_ERROR THEN
1083:
1084: wf_core.context('OKL_VSS_WF' , 'reject_quote_status', itemtype, itemkey, actid, funcmode);
1085:
1086: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: 'OKL_VSS_WF.reject_quote_status.',
1089: 'EXP - API_ERROR');
1090: END IF;

Line 1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1083:
1084: wf_core.context('OKL_VSS_WF' , 'reject_quote_status', itemtype, itemkey, actid, funcmode);
1085:
1086: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: 'OKL_VSS_WF.reject_quote_status.',
1089: 'EXP - API_ERROR');
1090: END IF;
1091: RAISE;

Line 1097: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1093: WHEN OTHERS THEN
1094:
1095: wf_core.context('OKL_VSS_WF' , 'reject_quote_status', itemtype, itemkey, actid, funcmode);
1096:
1097: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1099: 'OKL_VSS_WF.reject_quote_status.',
1100: 'EXP - OTHERS');
1101: END IF;

Line 1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1094:
1095: wf_core.context('OKL_VSS_WF' , 'reject_quote_status', itemtype, itemkey, actid, funcmode);
1096:
1097: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1099: 'OKL_VSS_WF.reject_quote_status.',
1100: 'EXP - OTHERS');
1101: END IF;
1102: