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 2007/11/30 13:07:19 rajnisku noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------

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

2: /* $Header: OKLSSWFB.pls 120.21 2007/11/30 13:07:19 rajnisku noship $ */
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 752: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'

748:
749: BEGIN
750:
751: --the document_id is in the form of
752: --'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/itemtyp:itemkey:#NID'
753: --we need to get itemtype and itemkey
754:
755: first_index := instr(document_id, '/', 1, 1); --index of the slash '/'
756: second_index := instr(document_id, ':', 1,1); --index of first colon ':'

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

835:
836: EXCEPTION
837:
838: when others then
839: WF_CORE.CONTEXT ('okl_ssc_wf', 'getLocationDocument', l_itemtype, l_itemkey);
840: raise;
841:
842: END getLocationDocument;
843:

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

979: end if;
980:
981: exception
982: when others then
983: WF_CORE.CONTEXT ('OKL_SSC_WF', 'update_location_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);
984: resultout := 'ERROR';
985: raise;
986:
987:

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

1561: end if;
1562:
1563: exception
1564: when others then
1565: WF_CORE.CONTEXT ('okl_ssc_wf', 'set_ins_provider_wf', itemtype, itemkey,actid,funcmode);
1566: raise;
1567: end set_ins_provider_wf;
1568:
1569:

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

1629: end if;
1630:
1631: exception
1632: when others then
1633: WF_CORE.CONTEXT ('okl_ssc_wf', 'submit_ins_set_notif_wf',itemtype, itemkey,actid,funcmode);
1634: raise;
1635: end submit_ins_set_notif_wf;
1636:
1637:

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

1780: p_encoded => FND_API.G_FALSE,
1781: p_count => lx_msg_count,
1782: p_data => lx_msg_data);*/
1783: when others then
1784: WF_CORE.CONTEXT ('okl_ssc_wf', 'submit_ins_wf',itemtype, itemkey,actid,funcmode);
1785: raise;
1786: end submit_insurance_wf;
1787:
1788: procedure req_renewal_quote_wf (itemtype in varchar2,

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

1870: end if;
1871:
1872: exception
1873: when others then
1874: WF_CORE.CONTEXT ('okl_ssc_wf', 'req_renewal_quote_wf',itemtype, itemkey,actid,funcmode);
1875: raise;
1876: end req_renewal_quote_wf;
1877:
1878:

Line 2001: WF_CORE.CONTEXT ('okl_ssc_wf'

1997:
1998: exception
1999: when others then
2000: -- default wf error handling
2001: WF_CORE.CONTEXT ('okl_ssc_wf'
2002: , 'set_invoice_format_attributes'
2003: , itemtype
2004: , itemkey
2005: , actid

Line 2107: WF_CORE.CONTEXT ('okl_ssc_wf'

2103: EXCEPTION
2104:
2105: when others then
2106: -- default wf error handling
2107: WF_CORE.CONTEXT ('okl_ssc_wf'
2108: , 'invoice_format_change_wf'
2109: , itemtype
2110: , itemkey,actid,funcmode);
2111: RAISE;

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

2296: end if;
2297:
2298: exception
2299: when others then
2300: WF_CORE.CONTEXT ('okl_ssc_wf', 'req_billinf_change_getdata_wf', itemtype, itemkey,actid,funcmode);
2301: raise;
2302: end req_billinf_change_getdata_wf;
2303:
2304:

Line 2412: WF_CORE.CONTEXT ('okl_ssc_wf'

2408: p_encoded => FND_API.G_FALSE,
2409: p_count => l_msg_count,
2410: p_data => l_msg_data);
2411:
2412: WF_CORE.CONTEXT ('okl_ssc_wf'
2413: , 'req_billinf_change_wrapper_wf'
2414: , itemtype, itemkey, actid, funcmode);
2415:
2416: raise;

Line 2418: WF_CORE.CONTEXT ('okl_ssc_wf'

2414: , itemtype, itemkey, actid, funcmode);
2415:
2416: raise;
2417: when others then
2418: WF_CORE.CONTEXT ('okl_ssc_wf'
2419: , 'req_billinf_change_wrapper_wf'
2420: , itemtype, itemkey, actid, funcmode);
2421:
2422: raise;

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

2616: end if;
2617:
2618: exception
2619: when others then
2620: WF_CORE.CONTEXT ('OKL_SSC_WF', 'cancel_ins_set_attr_wf', itemtype, itemkey,'c','d');
2621: raise;
2622: END cancel_ins_set_attr_wf;
2623:
2624: --Cancel Insurance PL/SQL wrapper

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

2742: x_return_status := l_return_status;
2743: x_msg_count := l_msg_count ;
2744: x_msg_data := l_msg_data ;
2745:
2746: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');
2747: FND_MSG_PUB.count_and_get(
2748: p_count => x_msg_count
2749: ,p_data => x_msg_data);
2750: ROLLBACK TO cancel_insurance;

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

2852: end if;
2853:
2854: exception
2855: when others then
2856: WF_CORE.CONTEXT ('OKL_SSC_WF', 'set_claim_receiver', itemtype, itemkey,actid,funcmode);
2857: resultout := 'ERROR';
2858: raise;
2859:
2860: end set_claim_receiver;

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

3242: End If;
3243: pl_payment_trxn_extension_id := p_payment_trxn_extension_id;
3244: -- End - Payments Uptake
3245:
3246: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF Start
3247:
3248: -- Start of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.get_rec
3249: IF(L_DEBUG_ENABLED='Y') THEN
3250: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

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

3277: ); */
3278:
3279: -- End - Make Payment - varangan
3280:
3281: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF End
3282:
3283: xl_return_status := nvl(xl_return_status,OKL_API.G_RET_STS_UNEXP_ERROR);
3284:
3285: IF(IS_DEBUG_PROCEDURE_ON) THEN

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

3413: end if;
3414:
3415: exception
3416: when others then
3417: WF_CORE.CONTEXT ('OKL_SSC_WF', 'make_payment_set_attr_wf', itemtype, itemkey,'actid','funcmode');
3418: raise;
3419: END make_payment_set_attr_wf;
3420:
3421: --IBYON added on OCT-01-2002 wrapper to call party api and validate parties for termination quote

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

3724: l_api_version NUMBER:=1.0;
3725: x_msg_count NUMBER;
3726: x_msg_data VARCHAR2(4000);
3727: l_parameter_list wf_parameter_list_t;
3728: l_api_name VARCHAR2(40):= 'okl_ssc_wf';
3729:
3730: begin
3731:
3732: -- pass the parameters to the event

Line 3766: END okl_ssc_wf;

3762: ''
3763: );
3764: end raise_assets_return_event;
3765:
3766: END okl_ssc_wf;