DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on OKL_SSC_WF

Line 1: PACKAGE BODY OKL_SSC_WF as

1: PACKAGE BODY OKL_SSC_WF as
2: /* $Header: OKLSSWFB.pls 120.21.12010000.6 2010/01/21 05:43:15 nikshah ship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------

Line 6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SSC_WF';

2: /* $Header: OKLSSWFB.pls 120.21.12010000.6 2010/01/21 05:43:15 nikshah ship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SSC_WF';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8: L_MODULE VARCHAR2(40) := 'LEASE.SETUP.FUNCTIONS';
9: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
10: L_LEVEL_PROCEDURE NUMBER;

Line 156: avalue => 'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/'||

152:
153: wf_engine.SetItemAttrText (itemtype => itemtype,
154: itemkey => itemkey,
155: aname => l_doc_attr,
156: avalue => 'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/'||
157: itemtype ||':'||itemkey||':&#NID');
158:
159:
160:

Line 193: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getAssetReturnMessage', itemtype, itemkey,actid,funcmode);

189: end if;
190:
191: exception
192: when others then
193: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getAssetReturnMessage', itemtype, itemkey,actid,funcmode);
194: resultout := 'ERROR';
195: raise;
196:
197:

Line 236: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'

232:
233: BEGIN
234:
235: --the document_id is in the form of
236: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'
237: --we need to get itemtype and itemkey
238:
239: first_index := instr(document_id, '/', 1, 1); --index of the slash '/'
240: second_index := instr(document_id, ':', 1,1); --index of first colon ':'

Line 278: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getAssetReturnDocument', l_itemtype, l_itemkey);

274:
275: EXCEPTION
276:
277: when others then
278: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getAssetReturnDocument', l_itemtype, l_itemkey);
279: raise;
280:
281: END getAssetReturnDocument;
282:

Line 364: avalue => 'PLSQLCLOB:OKL_SSC_WF.getSerialNumDocument/'||

360:
361: wf_engine.SetItemAttrText (itemtype => itemtype,
362: itemkey => itemkey,
363: aname => l_doc_attr,
364: avalue => 'PLSQLCLOB:OKL_SSC_WF.getSerialNumDocument/'||
365: itemtype ||':'||itemkey||':&#NID');
366:
367: resultout := 'COMPLETE';
368:

Line 399: WF_CORE.CONTEXT ('okl_ssc_wf', 'getSerialNumMessage', itemtype, itemkey,actid,funcmode);

395: end if;
396:
397: exception
398: when others then
399: WF_CORE.CONTEXT ('okl_ssc_wf', 'getSerialNumMessage', itemtype, itemkey,actid,funcmode);
400: resultout := 'ERROR';
401: raise;
402:
403:

Line 444: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'

440:
441: BEGIN
442:
443: --the document_id is in the form of
444: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'
445: --we need to get itemtype and itemkey
446:
447: first_index := instr(document_id, '/', 1, 1); --index of the slash '/'
448: second_index := instr(document_id, ':', 1,1); --index of first colon ':'

Line 488: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getSerialNumDocument', l_itemtype, l_itemkey);

484:
485: EXCEPTION
486:
487: when others then
488: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getSerialNumDocument', l_itemtype, l_itemkey);
489: raise;
490:
491: END getSerialNumDocument;
492:

Line 567: WF_CORE.CONTEXT ('okl_ssc_wf', 'update_serial_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);

563: end if;
564:
565: exception
566: when others then
567: WF_CORE.CONTEXT ('okl_ssc_wf', 'update_serial_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);
568: resultout := 'ERROR';
569: raise;
570:
571: end update_serial_fnc;

Line 634: avalue => 'PLSQLCLOB:OKL_SSC_WF.getLocationDocument/'||

630:
631: wf_engine.SetItemAttrText (itemtype => itemtype,
632: itemkey => itemkey,
633: aname => l_doc_attr,
634: avalue => 'PLSQLCLOB:OKL_SSC_WF.getLocationDocument/'||
635: itemtype ||':'||itemkey||':&#NID');
636:
637: resultout := 'COMPLETE';
638:

Line 668: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getLocationMessage', itemtype, itemkey,actid,funcmode);

664: end if;
665:
666: exception
667: when others then
668: WF_CORE.CONTEXT ('OKL_SSC_WF', 'getLocationMessage', itemtype, itemkey,actid,funcmode);
669: resultout := 'ERROR';
670: raise;
671:
672:

Line 764: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'

760:
761: BEGIN
762:
763: --the document_id is in the form of
764: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'
765: --we need to get itemtype and itemkey
766:
767: first_index := instr(document_id, '/', 1, 1); --index of the slash '/'
768: second_index := instr(document_id, ':', 1,1); --index of first colon ':'

Line 888: WF_CORE.CONTEXT ('okl_ssc_wf', 'getLocationDocument', l_itemtype, l_itemkey);

884:
885: EXCEPTION
886:
887: when others then
888: WF_CORE.CONTEXT ('okl_ssc_wf', 'getLocationDocument', l_itemtype, l_itemkey);
889: raise;
890:
891: END getLocationDocument;
892:

Line 1069: WF_CORE.CONTEXT ('OKL_SSC_WF', 'update_location_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);

1065: when others then
1066: --For bug 8933908 by NIKSHAH
1067: MO_GLOBAL.SET_POLICY_CONTEXT(l_orig_access_mode,l_orig_org_id);
1068:
1069: WF_CORE.CONTEXT ('OKL_SSC_WF', 'update_location_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);
1070: resultout := 'ERROR';
1071: raise;
1072:
1073:

Line 1651: WF_CORE.CONTEXT ('okl_ssc_wf', 'set_ins_provider_wf', itemtype, itemkey,actid,funcmode);

1647: end if;
1648:
1649: exception
1650: when others then
1651: WF_CORE.CONTEXT ('okl_ssc_wf', 'set_ins_provider_wf', itemtype, itemkey,actid,funcmode);
1652: raise;
1653: end set_ins_provider_wf;
1654:
1655:

Line 1719: WF_CORE.CONTEXT ('okl_ssc_wf', 'submit_ins_set_notif_wf',itemtype, itemkey,actid,funcmode);

1715: end if;
1716:
1717: exception
1718: when others then
1719: WF_CORE.CONTEXT ('okl_ssc_wf', 'submit_ins_set_notif_wf',itemtype, itemkey,actid,funcmode);
1720: raise;
1721: end submit_ins_set_notif_wf;
1722:
1723:

Line 1870: WF_CORE.CONTEXT ('okl_ssc_wf', 'submit_ins_wf',itemtype, itemkey,actid,funcmode);

1866: p_encoded => FND_API.G_FALSE,
1867: p_count => lx_msg_count,
1868: p_data => lx_msg_data);*/
1869: when others then
1870: WF_CORE.CONTEXT ('okl_ssc_wf', 'submit_ins_wf',itemtype, itemkey,actid,funcmode);
1871: raise;
1872: end submit_insurance_wf;
1873:
1874: procedure req_renewal_quote_wf (itemtype in varchar2,

Line 1960: WF_CORE.CONTEXT ('okl_ssc_wf', 'req_renewal_quote_wf',itemtype, itemkey,actid,funcmode);

1956: end if;
1957:
1958: exception
1959: when others then
1960: WF_CORE.CONTEXT ('okl_ssc_wf', 'req_renewal_quote_wf',itemtype, itemkey,actid,funcmode);
1961: raise;
1962: end req_renewal_quote_wf;
1963:
1964:

Line 2087: WF_CORE.CONTEXT ('okl_ssc_wf'

2083:
2084: exception
2085: when others then
2086: -- default wf error handling
2087: WF_CORE.CONTEXT ('okl_ssc_wf'
2088: , 'set_invoice_format_attributes'
2089: , itemtype
2090: , itemkey
2091: , actid

Line 2193: WF_CORE.CONTEXT ('okl_ssc_wf'

2189: EXCEPTION
2190:
2191: when others then
2192: -- default wf error handling
2193: WF_CORE.CONTEXT ('okl_ssc_wf'
2194: , 'invoice_format_change_wf'
2195: , itemtype
2196: , itemkey,actid,funcmode);
2197: RAISE;

Line 2386: WF_CORE.CONTEXT ('okl_ssc_wf', 'req_billinf_change_getdata_wf', itemtype, itemkey,actid,funcmode);

2382: end if;
2383:
2384: exception
2385: when others then
2386: WF_CORE.CONTEXT ('okl_ssc_wf', 'req_billinf_change_getdata_wf', itemtype, itemkey,actid,funcmode);
2387: raise;
2388: end req_billinf_change_getdata_wf;
2389:
2390:

Line 2498: WF_CORE.CONTEXT ('okl_ssc_wf'

2494: p_encoded => FND_API.G_FALSE,
2495: p_count => l_msg_count,
2496: p_data => l_msg_data);
2497:
2498: WF_CORE.CONTEXT ('okl_ssc_wf'
2499: , 'req_billinf_change_wrapper_wf'
2500: , itemtype, itemkey, actid, funcmode);
2501:
2502: raise;

Line 2504: WF_CORE.CONTEXT ('okl_ssc_wf'

2500: , itemtype, itemkey, actid, funcmode);
2501:
2502: raise;
2503: when others then
2504: WF_CORE.CONTEXT ('okl_ssc_wf'
2505: , 'req_billinf_change_wrapper_wf'
2506: , itemtype, itemkey, actid, funcmode);
2507:
2508: raise;

Line 2706: WF_CORE.CONTEXT ('OKL_SSC_WF', 'cancel_ins_set_attr_wf', itemtype, itemkey,'c','d');

2702: end if;
2703:
2704: exception
2705: when others then
2706: WF_CORE.CONTEXT ('OKL_SSC_WF', 'cancel_ins_set_attr_wf', itemtype, itemkey,'c','d');
2707: raise;
2708: END cancel_ins_set_attr_wf;
2709:
2710: --Cancel Insurance PL/SQL wrapper

Line 2832: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');

2828: x_return_status := l_return_status;
2829: x_msg_count := l_msg_count ;
2830: x_msg_data := l_msg_data ;
2831:
2832: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');
2833: FND_MSG_PUB.count_and_get(
2834: p_count => x_msg_count
2835: ,p_data => x_msg_data);
2836: ROLLBACK TO cancel_insurance;

Line 2942: WF_CORE.CONTEXT ('OKL_SSC_WF', 'set_claim_receiver', itemtype, itemkey,actid,funcmode);

2938: end if;
2939:
2940: exception
2941: when others then
2942: WF_CORE.CONTEXT ('OKL_SSC_WF', 'set_claim_receiver', itemtype, itemkey,actid,funcmode);
2943: resultout := 'ERROR';
2944: raise;
2945:
2946: end set_claim_receiver;

Line 3332: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF Start

3328: End If;
3329: pl_payment_trxn_extension_id := p_payment_trxn_extension_id;
3330: -- End - Payments Uptake
3331:
3332: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF Start
3333:
3334: -- Start of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.get_rec
3335: IF(L_DEBUG_ENABLED='Y') THEN
3336: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line 3367: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF End

3363: ); */
3364:
3365: -- End - Make Payment - varangan
3366:
3367: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF End
3368:
3369: xl_return_status := nvl(xl_return_status,OKL_API.G_RET_STS_UNEXP_ERROR);
3370:
3371: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3503: WF_CORE.CONTEXT ('OKL_SSC_WF', 'make_payment_set_attr_wf', itemtype, itemkey,'actid','funcmode');

3499: end if;
3500:
3501: exception
3502: when others then
3503: WF_CORE.CONTEXT ('OKL_SSC_WF', 'make_payment_set_attr_wf', itemtype, itemkey,'actid','funcmode');
3504: raise;
3505: END make_payment_set_attr_wf;
3506:
3507: --IBYON added on OCT-01-2002 wrapper to call party api and validate parties for termination quote

Line 3814: l_api_name VARCHAR2(40):= 'okl_ssc_wf';

3810: l_api_version NUMBER:=1.0;
3811: x_msg_count NUMBER;
3812: x_msg_data VARCHAR2(4000);
3813: l_parameter_list wf_parameter_list_t;
3814: l_api_name VARCHAR2(40):= 'okl_ssc_wf';
3815:
3816: begin
3817:
3818: -- pass the parameters to the event

Line 3909: END okl_ssc_wf;

3905:
3906: end raise_ser_num_update_event;
3907: --Bug 6018784 end
3908:
3909: END okl_ssc_wf;