DBA Data[Home] [Help]

APPS.OKL_VSS_WF dependencies on OKL_VSS_WF

Line 1: PACKAGE BODY OKL_VSS_WF AS

1: PACKAGE BODY OKL_VSS_WF AS
2: /* $Header: OKLRVSWB.pls 120.4 2007/08/14 11:45:20 zrehman ship $ */
3:
4:
5: PROCEDURE raise_business_event (

Line 26: 'OKL_VSS_WF.raise_business_event.',

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:
30: SAVEPOINT raise_business_event_sv;

Line 67: 'OKL_VSS_WF.raise_business_event.',

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:
71: EXCEPTION

Line 82: 'OKL_VSS_WF.raise_business_event.',

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:
86: END raise_business_event;

Line 123: 'OKL_VSS_WF.createRepurchaseQuote.',

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:
127: l_qtev_rec.khr_id := p_khr_id;

Line 155: 'OKL_VSS_WF.createRepurchaseQuote.',

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
159:

Line 174: 'OKL_VSS_WF.createRepurchaseQuote.',

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:
178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 184: 'OKL_VSS_WF.createRepurchaseQuote.',

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:
188: WHEN OTHERS THEN

Line 195: 'OKL_VSS_WF.createRepurchaseQuote.',

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:
199:

Line 244: 'OKL_VSS_WF.getCountersMessage.',

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:
248: if ( funcmode = 'RUN' ) then

Line 310: 'OKL_VSS_WF.getCountersMessage.',

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:
314: exception

Line 321: 'OKL_VSS_WF.getCountersMessage.',

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;
325: end getCountersMessage;

Line 391: 'OKL_VSS_WF.getCountersDocument.',

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:
395: --the document_id is in the form of

Line 444: 'OKL_VSS_WF.getCountersDocument.',

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:
448: EXCEPTION

Line 455: 'OKL_VSS_WF.getCountersDocument.',

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

Line 505: 'OKL_VSS_WF.update_counter.',

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:
509: /*

Line 552: 'OKL_VSS_WF.update_counter.',

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:
556: EXCEPTION

Line 564: 'OKL_VSS_WF.update_counter.',

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:
568: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 574: 'OKL_VSS_WF.update_counter.',

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:
578: WHEN OTHERS THEN

Line 586: 'OKL_VSS_WF.update_counter.',

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:
590: END update_counter;

Line 611: 'OKL_VSS_WF.update_counter_fnc.',

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
615: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

Line 666: 'OKL_VSS_WF.update_counter_fnc.',

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:
670: exception

Line 676: 'OKL_VSS_WF.update_counter_fnc.',

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

Line 734: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',

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:
738: IF ( funcmode = 'RUN' ) THEN

Line 847: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',

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:
851: EXCEPTION

Line 857: 'OKL_VSS_WF.populate_req_repqte_attr_wf.',

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

Line 888: 'OKL_VSS_WF.approve_quote_status.',

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:
892: IF (funcmode = 'RUN') THEN

Line 956: 'OKL_VSS_WF.approve_quote_status.',

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:
960: EXCEPTION

Line 964: wf_core.context('OKL_VSS_WF' , 'approve_quote_status', itemtype, itemkey, actid, funcmode);

960: EXCEPTION
961:
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.',

Line 968: 'OKL_VSS_WF.approve_quote_status.',

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

Line 975: wf_core.context('OKL_VSS_WF' , 'approve_quote_status', itemtype, itemkey, actid, funcmode);

971: RAISE;
972:
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.',

Line 979: 'OKL_VSS_WF.approve_quote_status.',

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:
983: RAISE;

Line 1011: 'OKL_VSS_WF.reject_quote_status.',

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:
1015: IF (funcmode = 'RUN') THEN

Line 1076: 'OKL_VSS_WF.reject_quote_status.',

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:
1080: EXCEPTION

Line 1084: wf_core.context('OKL_VSS_WF' , 'reject_quote_status', itemtype, itemkey, actid, funcmode);

1080: EXCEPTION
1081:
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.',

Line 1088: 'OKL_VSS_WF.reject_quote_status.',

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

Line 1095: wf_core.context('OKL_VSS_WF' , 'reject_quote_status', itemtype, itemkey, actid, funcmode);

1091: RAISE;
1092:
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.',

Line 1099: 'OKL_VSS_WF.reject_quote_status.',

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:
1103: RAISE;

Line 1107: END OKL_VSS_WF;

1103: RAISE;
1104:
1105: END reject_quote_status;
1106:
1107: END OKL_VSS_WF;