DBA Data[Home] [Help]

APPS.OKL_AM_QUOTES_WF dependencies on WF_CORE

Line 319: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_qte_partial',

315: IF get_q_assets_no_csr%ISOPEN THEN
316: CLOSE get_q_assets_no_csr;
317: END IF;
318:
319: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_qte_partial',
320: itemtype, itemkey, actid, funcmode);
321: RAISE;
322: WHEN OTHERS THEN
323: IF (is_debug_exception_on) THEN

Line 336: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_qte_partial',

332: IF get_q_assets_no_csr%ISOPEN THEN
333: CLOSE get_q_assets_no_csr;
334: END IF;
335:
336: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_qte_partial',
337: itemtype, itemkey, actid, funcmode);
338: RAISE;
339: END chk_pre_proceeds_qte_partial;
340:

Line 592: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_att',

588:
589: IF okl_pop_pre_proceeds_csr%ISOPEN THEN
590: CLOSE okl_pop_pre_proceeds_csr;
591: END IF;
592: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_att',
593: itemtype, itemkey, actid, funcmode);
594: RAISE;
595: END pop_pre_proceeds_att;
596:

Line 699: WF_CORE.context('OKL_AM_QUOTES_WF' , 'reset_pre_proceeds_att',

695: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
696: || sqlcode || ' , SQLERRM : ' || sqlerrm);
697: END IF;
698:
699: WF_CORE.context('OKL_AM_QUOTES_WF' , 'reset_pre_proceeds_att',
700: itemtype, itemkey, actid, funcmode);
701: RAISE;
702: END reset_pre_proceeds_att;
703:

Line 788: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_qte_approved',

784: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
785: || sqlcode || ' , SQLERRM : ' || sqlerrm);
786: END IF;
787:
788: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_qte_approved',
789: itemtype, itemkey, actid, funcmode);
790: RAISE;
791: END chk_pre_proceeds_qte_approved;
792:

Line 1023: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_noti_att',

1019: END IF;
1020: IF get_assets_in_k_csr%ISOPEN THEN
1021: CLOSE get_assets_in_qte_csr;
1022: END IF;
1023: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_noti_att',
1024: itemtype, itemkey, actid, funcmode);
1025: RAISE;
1026: END pop_pre_proceeds_noti_att;
1027:

Line 1194: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_app_att',

1190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1191: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1192: END IF;
1193:
1194: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_app_att',
1195: itemtype, itemkey, actid, funcmode);
1196: RAISE;
1197: END pop_pre_proceeds_app_att;
1198:

Line 1353: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_doc_att',

1349: END IF;
1350: IF l_message_csr%ISOPEN THEN
1351: CLOSE l_message_csr;
1352: END IF;
1353: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_doc_att',
1354: itemtype, itemkey, actid, funcmode);
1355: RAISE;
1356: END pop_pre_proceeds_doc_att;
1357:

Line 1516: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pre_proceeds_trmnt_contract',

1512: END IF;
1513: IF get_qte_details_csr%ISOPEN THEN
1514: CLOSE get_qte_details_csr;
1515: END IF;
1516: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pre_proceeds_trmnt_contract',
1517: itemtype, itemkey, actid, funcmode);
1518: RAISE;
1519: WHEN OTHERS THEN
1520: IF (is_debug_exception_on) THEN

Line 1528: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pre_proceeds_trmnt_contract',

1524:
1525: IF get_qte_details_csr%ISOPEN THEN
1526: CLOSE get_qte_details_csr;
1527: END IF;
1528: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pre_proceeds_trmnt_contract',
1529: itemtype, itemkey, actid, funcmode);
1530: RAISE;
1531: END pre_proceeds_trmnt_contract;
1532:

Line 1634: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_serv_maint',

1630: IF get_service_lines_csr%ISOPEN THEN
1631: CLOSE get_service_lines_csr;
1632: END IF;
1633:
1634: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_serv_maint',
1635: itemtype, itemkey, actid, funcmode);
1636: RAISE;
1637:
1638: WHEN OTHERS THEN

Line 1648: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_serv_maint',

1644: IF get_service_lines_csr%ISOPEN THEN
1645: CLOSE get_service_lines_csr;
1646: END IF;
1647:
1648: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_serv_maint',
1649: itemtype, itemkey, actid, funcmode);
1650: RAISE;
1651: END chk_pre_proceeds_serv_maint;
1652:

Line 1760: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_serv_maint',

1756: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1757: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1758: END IF;
1759:
1760: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_serv_maint',
1761: itemtype, itemkey, actid, funcmode);
1762: RAISE;
1763: END pop_pre_proceeds_serv_maint;
1764:

Line 2001: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_serv_noti',

1997: IF get_serv_prov_dtl_csr%ISOPEN THEN
1998: CLOSE get_serv_prov_dtl_csr;
1999: END IF;
2000:
2001: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_serv_noti',
2002: itemtype, itemkey, actid, funcmode);
2003: RAISE;
2004: END chk_pre_proceeds_serv_noti;
2005:

Line 2152: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_bill_of_sale',

2148: IF c_qte_csr%ISOPEN THEN
2149: CLOSE c_qte_csr;
2150: END IF;
2151:
2152: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_bill_of_sale',
2153: itemtype, itemkey, actid, funcmode);
2154: RAISE;
2155:
2156: WHEN OTHERS THEN

Line 2166: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_bill_of_sale',

2162: IF c_qte_csr%ISOPEN THEN
2163: CLOSE c_qte_csr;
2164: END IF;
2165:
2166: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_bill_of_sale',
2167: itemtype, itemkey, actid, funcmode);
2168: RAISE;
2169: END chk_pre_proceeds_bill_of_sale;
2170:

Line 2271: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_bill_of_sale',

2267: IF (is_debug_exception_on) THEN
2268: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
2269: || sqlcode || ' , SQLERRM : ' || sqlerrm);
2270: END IF;
2271: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_bill_of_sale',
2272: itemtype, itemkey, actid, funcmode);
2273: RAISE;
2274:
2275: END pop_pre_proceeds_bill_of_sale;

Line 2535: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_bill_noti',

2531: IF l_recipient_csr%ISOPEN THEN
2532: CLOSE l_recipient_csr;
2533: END IF;
2534:
2535: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_bill_noti',
2536: itemtype, itemkey, actid, funcmode);
2537: RAISE;
2538: END chk_pre_proceeds_bill_noti;
2539:

Line 2654: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_title_filing',

2650: IF (is_debug_exception_on) THEN
2651: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
2652: END IF;
2653:
2654: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_title_filing',
2655: itemtype, itemkey, actid, funcmode);
2656: RAISE;
2657: WHEN OTHERS THEN
2658:

Line 2664: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_title_filing',

2660: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
2661: || sqlcode || ' , SQLERRM : ' || sqlerrm);
2662: END IF;
2663:
2664: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_title_filing',
2665: itemtype, itemkey, actid, funcmode);
2666: RAISE;
2667: END chk_pre_proceeds_title_filing;
2668:

Line 2764: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_title_filing',

2760: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
2761: || sqlcode || ' , SQLERRM : ' || sqlerrm);
2762: END IF;
2763:
2764: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_pre_proceeds_title_filing',
2765: itemtype, itemkey, actid, funcmode);
2766: RAISE;
2767: END pop_pre_proceeds_title_filing;
2768:

Line 3062: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_title_noti',

3058: IF get_asset_for_k_csr%ISOPEN THEN
3059: CLOSE get_asset_for_k_csr;
3060: END IF;
3061:
3062: WF_CORE.context('OKL_AM_QUOTES_WF' , 'chk_pre_proceeds_title_noti',
3063: itemtype, itemkey, actid, funcmode);
3064: RAISE;
3065: END chk_pre_proceeds_title_noti;
3066:

Line 3170: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_repurchase_qte_att',

3166: END IF;
3167: IF okl_pop_contract_details_csr%ISOPEN THEN
3168: CLOSE okl_pop_contract_details_csr;
3169: END IF;
3170: WF_CORE.context('OKL_AM_QUOTES_WF' , 'pop_repurchase_qte_att',
3171: itemtype, itemkey, actid, funcmode);
3172: RAISE;
3173:
3174: END pop_repurchase_qte_att;

Line 3426: WF_CORE.context('OKL_AM_QUOTES_WF' , 'repurchase_qte_asset_dispose',

3422: CLOSE fetch_art_id;
3423: END IF;
3424: -- Legal Entity Changes End
3425:
3426: WF_CORE.context('OKL_AM_QUOTES_WF' , 'repurchase_qte_asset_dispose',
3427: itemtype, itemkey, actid, funcmode);
3428: RAISE;
3429:
3430: WHEN OTHERS THEN

Line 3455: WF_CORE.context('OKL_AM_QUOTES_WF' , 'repurchase_qte_asset_dispose',

3451: CLOSE fetch_art_id;
3452: END IF;
3453: -- Legal Entity Changes End
3454:
3455: WF_CORE.context('OKL_AM_QUOTES_WF' , 'repurchase_qte_asset_dispose',
3456: itemtype, itemkey, actid, funcmode);
3457: RAISE;
3458:
3459: END repurchase_qte_asset_dispose;

Line 3589: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_asset_return_status',

3585: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
3586: || sqlcode || ' , SQLERRM : ' || sqlerrm);
3587: END IF;
3588:
3589: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_asset_return_status',
3590: itemtype, itemkey, actid, funcmode);
3591: RAISE;
3592: WHEN OTHERS THEN
3593: IF (is_debug_exception_on) THEN

Line 3596: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_asset_return_status',

3592: WHEN OTHERS THEN
3593: IF (is_debug_exception_on) THEN
3594: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
3595: END IF;
3596: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_asset_return_status',
3597: itemtype, itemkey, actid, funcmode);
3598: RAISE;
3599:
3600: END update_asset_return_status;

Line 3861: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_invoice',

3857: -- RMUNJULU 09-MAY-03 2949544
3858: IF l_qlt_csr%ISOPEN THEN
3859: CLOSE l_qlt_csr;
3860: END IF;
3861: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_invoice',
3862: itemtype, itemkey, actid, funcmode);
3863: RAISE;
3864: WHEN OTHERS THEN
3865:

Line 3894: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_invoice',

3890: -- RMUNJULU 09-MAY-03 2949544
3891: IF l_qlt_csr%ISOPEN THEN
3892: CLOSE l_qlt_csr;
3893: END IF;
3894: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_invoice',
3895: itemtype, itemkey, actid, funcmode);
3896: RAISE;
3897: END create_invoice;
3898:

Line 4033: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',

4029: CLOSE c_tmt_status_code_csr;
4030: END IF;
4031: -- End : PRASJAIN : Bug 6324373
4032:
4033: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',
4034: itemtype, itemkey, actid, funcmode);
4035: RAISE;
4036: WHEN OTHERS THEN
4037:

Line 4048: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',

4044: CLOSE c_tmt_status_code_csr;
4045: END IF;
4046: -- End : PRASJAIN : Bug 6324373
4047:
4048: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',
4049: itemtype, itemkey, actid, funcmode);
4050: RAISE;
4051:
4052: END update_quote_status;

Line 4311: WF_CORE.context('OKL_AM_QUOTES_WF' , 'validate_quote',

4307: IF (is_debug_exception_on) THEN
4308: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
4309: || sqlcode || ' , SQLERRM : ' || sqlerrm);
4310: END IF;
4311: WF_CORE.context('OKL_AM_QUOTES_WF' , 'validate_quote',
4312: itemtype, itemkey, actid, funcmode);
4313: RAISE;
4314:
4315: END validate_quote;

Line 4515: wf_core.context('OKL_AM_QUOTES_WF' , 'pop_partial_quote_att', itemtype, itemkey, actid, funcmode);

4511: IF okl_partial_quote_csr%ISOPEN THEN
4512: CLOSE okl_partial_quote_csr;
4513: END IF;
4514:
4515: wf_core.context('OKL_AM_QUOTES_WF' , 'pop_partial_quote_att', itemtype, itemkey, actid, funcmode);
4516: RAISE;
4517:
4518: END pop_partial_quote_att;
4519:

Line 4644: wf_core.context('OKL_AM_QUOTES_WF' , 'set_quote_approved_yn', itemtype, itemkey, actid, funcmode);

4640: WHEN API_ERROR THEN
4641: IF (is_debug_exception_on) THEN
4642: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
4643: END IF;
4644: wf_core.context('OKL_AM_QUOTES_WF' , 'set_quote_approved_yn', itemtype, itemkey, actid, funcmode);
4645: RAISE;
4646:
4647: WHEN OTHERS THEN
4648:

Line 4654: wf_core.context('OKL_AM_QUOTES_WF' , 'set_quote_approved_yn', itemtype, itemkey, actid, funcmode);

4650: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
4651: || sqlcode || ' , SQLERRM : ' || sqlerrm);
4652: END IF;
4653:
4654: wf_core.context('OKL_AM_QUOTES_WF' , 'set_quote_approved_yn', itemtype, itemkey, actid, funcmode);
4655: RAISE;
4656:
4657: END set_quote_approved_yn;
4658:

Line 4797: wf_core.context('OKL_AM_QUOTES_WF' , 'pop_gl_quote_att', itemtype, itemkey, actid, funcmode);

4793: IF okl_quote_csr%ISOPEN THEN
4794: CLOSE okl_quote_csr;
4795: END IF;
4796:
4797: wf_core.context('OKL_AM_QUOTES_WF' , 'pop_gl_quote_att', itemtype, itemkey, actid, funcmode);
4798: RAISE;
4799:
4800: END pop_gl_quote_att;
4801:

Line 5141: wf_core.context('OKL_AM_QUOTES_WF' , 'VALIDATE_QUOTE_APPROVAL', itemtype, itemkey, actid, funcmode);

5137: IF (is_debug_exception_on) THEN
5138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
5139: END IF;
5140:
5141: wf_core.context('OKL_AM_QUOTES_WF' , 'VALIDATE_QUOTE_APPROVAL', itemtype, itemkey, actid, funcmode);
5142: RAISE;
5143:
5144: WHEN OTHERS THEN
5145:

Line 5155: WF_CORE.context('OKL_AM_QUOTES_WF' , 'VALIDATE_QUOTE_APPROVAL',

5151: IF get_quote_csr%ISOPEN THEN
5152: CLOSE get_quote_csr;
5153: END IF;
5154:
5155: WF_CORE.context('OKL_AM_QUOTES_WF' , 'VALIDATE_QUOTE_APPROVAL',
5156: itemtype, itemkey, actid, funcmode);
5157: RAISE;
5158:
5159: END validate_quote_approval;

Line 5294: wf_core.context('OKL_AM_QUOTES_WF' , 'pop_cp_quote_att', itemtype, itemkey, actid, funcmode);

5290: IF okl_quote_csr%ISOPEN THEN
5291: CLOSE okl_quote_csr;
5292: END IF;
5293:
5294: wf_core.context('OKL_AM_QUOTES_WF' , 'pop_cp_quote_att', itemtype, itemkey, actid, funcmode);
5295: RAISE;
5296:
5297: END pop_cp_quote_att;
5298:

Line 5411: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_PARTIAL_QUOTE', itemtype, itemkey, actid, funcmode);

5407: IF (is_debug_exception_on) THEN
5408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
5409: END IF;
5410:
5411: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_PARTIAL_QUOTE', itemtype, itemkey, actid, funcmode);
5412: RAISE;
5413:
5414: WHEN OTHERS THEN
5415:

Line 5425: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_PARTIAL_QUOTE', itemtype, itemkey, actid, funcmode);

5421: IF c_qte_csr%ISOPEN THEN
5422: CLOSE c_qte_csr;
5423: END IF;
5424:
5425: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_PARTIAL_QUOTE', itemtype, itemkey, actid, funcmode);
5426: RAISE;
5427:
5428: END CHECK_IF_PARTIAL_QUOTE;
5429:

Line 5726: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_QUOTE_GAIN_LOSS', itemtype, itemkey, actid, funcmode);

5722: IF (is_debug_exception_on) THEN
5723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
5724: END IF;
5725:
5726: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_QUOTE_GAIN_LOSS', itemtype, itemkey, actid, funcmode);
5727: RAISE;
5728:
5729: WHEN OTHERS THEN
5730:

Line 5740: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_QUOTE_GAIN_LOSS', itemtype, itemkey, actid, funcmode);

5736: IF c_qte_csr%ISOPEN THEN
5737: CLOSE c_qte_csr;
5738: END IF;
5739:
5740: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_QUOTE_GAIN_LOSS', itemtype, itemkey, actid, funcmode);
5741: RAISE;
5742:
5743: END CHECK_IF_QUOTE_GAIN_LOSS;
5744:

Line 5855: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',

5851: END IF;
5852: IF (is_debug_exception_on) THEN
5853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
5854: END IF;
5855: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',
5856: itemtype, itemkey, actid, funcmode);
5857: WHEN OTHERS THEN
5858: IF (is_debug_exception_on) THEN
5859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '

Line 5863: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_EXT_APPROVAL',

5859: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
5860: || sqlcode || ' , SQLERRM : ' || sqlerrm);
5861: END IF;
5862:
5863: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_EXT_APPROVAL',
5864: itemtype, itemkey, actid, funcmode);
5865: RAISE;
5866: END CHECK_FOR_EXT_APPROVAL;
5867:

Line 6150: WF_CORE.context('OKL_AM_QUOTES_WF' , 'GET_QUOTE_PARTY_DETAILS',

6146: IF (is_debug_exception_on) THEN
6147: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED : MISSING_DETAILS_ERROR');
6148: END IF;
6149:
6150: WF_CORE.context('OKL_AM_QUOTES_WF' , 'GET_QUOTE_PARTY_DETAILS',
6151: itemtype, itemkey, actid, funcmode);
6152:
6153: END GET_QUOTE_PARTY_DETAILS;
6154:

Line 6276: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',

6272: IF (is_debug_exception_on) THEN
6273: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
6274: END IF;
6275:
6276: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',
6277: itemtype, itemkey, actid, funcmode);
6278:
6279: WHEN OTHERS THEN
6280:

Line 6287: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_ADVANCE_NOTICE',

6283: || sqlcode || ' , SQLERRM : ' || sqlerrm);
6284: END IF;
6285:
6286:
6287: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_ADVANCE_NOTICE',
6288: itemtype, itemkey, actid, funcmode);
6289: RAISE;
6290:
6291: END CHECK_FOR_ADVANCE_NOTICE;

Line 6400: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',

6396: WHEN API_ERROR THEN
6397: IF (is_debug_exception_on) THEN
6398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
6399: END IF;
6400: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',
6401: itemtype, itemkey, actid, funcmode);
6402: WHEN OTHERS THEN
6403: IF (is_debug_exception_on) THEN
6404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '

Line 6408: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT',

6404: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
6405: || sqlcode || ' , SQLERRM : ' || sqlerrm);
6406: END IF;
6407:
6408: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT',
6409: itemtype, itemkey, actid, funcmode);
6410: RAISE;
6411:
6412: END CHECK_FOR_RECIPIENT;

Line 6522: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',

6518: IF (is_debug_exception_on) THEN
6519: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
6520: END IF;
6521:
6522: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',
6523: itemtype, itemkey, actid, funcmode);
6524: WHEN OTHERS THEN
6525: IF (is_debug_exception_on) THEN
6526: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '

Line 6529: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_FYI',

6525: IF (is_debug_exception_on) THEN
6526: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
6527: || sqlcode || ' , SQLERRM : ' || sqlerrm);
6528: END IF;
6529: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_FYI',
6530: itemtype, itemkey, actid, funcmode);
6531: RAISE;
6532:
6533: END CHECK_FOR_FYI;

Line 6648: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',

6644: IF (is_debug_exception_on) THEN
6645: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
6646: END IF;
6647:
6648: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',
6649: itemtype, itemkey, actid, funcmode);
6650: WHEN OTHERS THEN
6651:
6652: IF (is_debug_exception_on) THEN

Line 6657: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',

6653: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
6654: || sqlcode || ' , SQLERRM : ' || sqlerrm);
6655: END IF;
6656:
6657: WF_CORE.context('OKL_AM_QUOTES_WF' , 'CHECK_FOR_RECIPIENT_ADD',
6658: itemtype, itemkey, actid, funcmode);
6659: RAISE;
6660:
6661: END CHECK_FOR_RECIPIENT_ADD;

Line 6971: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_CALC_OPTIONS', itemtype, itemkey, actid, funcmode);

6967: IF (is_debug_exception_on) THEN
6968: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
6969: END IF;
6970:
6971: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_CALC_OPTIONS', itemtype, itemkey, actid, funcmode);
6972: RAISE;
6973:
6974: WHEN OTHERS THEN
6975:

Line 6981: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_CALC_OPTIONS', itemtype, itemkey, actid, funcmode);

6977: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
6978: || sqlcode || ' , SQLERRM : ' || sqlerrm);
6979: END IF;
6980:
6981: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_CALC_OPTIONS', itemtype, itemkey, actid, funcmode);
6982: RAISE;
6983:
6984: END CHECK_CALC_OPTIONS;
6985:

Line 7141: WF_CORE.context('OKL_AM_QUOTES_WF' , 'validate_quote_approval',

7137: IF get_quote_csr%ISOPEN THEN
7138: CLOSE get_quote_csr;
7139: END IF;
7140:
7141: WF_CORE.context('OKL_AM_QUOTES_WF' , 'validate_quote_approval',
7142: itemtype, itemkey, actid, funcmode);
7143: RAISE;
7144:
7145: END VALIDATE_MANUAL_QUOTE_REQ;

Line 7277: WF_CORE.context('OKL_AM_QUOTES_WF' , 'VALIDATE_ACCEPT_REST_QTE',

7273: IF get_quote_csr%ISOPEN THEN
7274: CLOSE get_quote_csr;
7275: END IF;
7276:
7277: WF_CORE.context('OKL_AM_QUOTES_WF' , 'VALIDATE_ACCEPT_REST_QTE',
7278: itemtype, itemkey, actid, funcmode);
7279: RAISE;
7280:
7281: END VALIDATE_ACCEPT_REST_QTE;

Line 7406: wf_core.context('OKL_AM_QUOTES_WF' , 'set_rest_qte_approved_yn', itemtype, itemkey, actid, funcmode);

7402: IF (is_debug_exception_on) THEN
7403: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
7404: END IF;
7405:
7406: wf_core.context('OKL_AM_QUOTES_WF' , 'set_rest_qte_approved_yn', itemtype, itemkey, actid, funcmode);
7407: RAISE;
7408:
7409: WHEN OTHERS THEN
7410:

Line 7417: wf_core.context('OKL_AM_QUOTES_WF' , 'set_rest_qte_approved_yn', itemtype, itemkey, actid, funcmode);

7413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
7414: || sqlcode || ' , SQLERRM : ' || sqlerrm);
7415: END IF;
7416:
7417: wf_core.context('OKL_AM_QUOTES_WF' , 'set_rest_qte_approved_yn', itemtype, itemkey, actid, funcmode);
7418: RAISE;
7419:
7420: END set_rest_qte_approved_yn;
7421:

Line 7521: wf_core.context('OKL_AM_QUOTES_WF' , 'check_profile_recipient', itemtype, itemkey, actid, funcmode);

7517: IF c1_csr%ISOPEN THEN
7518: CLOSE c1_csr;
7519: END IF;
7520:
7521: wf_core.context('OKL_AM_QUOTES_WF' , 'check_profile_recipient', itemtype, itemkey, actid, funcmode);
7522: RAISE;
7523:
7524: END check_profile_recipient;
7525:

Line 7848: wf_core.context('OKL_AM_QUOTES_WF' , 'update_partial_quote', itemtype, itemkey, actid, funcmode);

7844: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
7845: || sqlcode || ' , SQLERRM : ' || sqlerrm);
7846: END IF;
7847:
7848: wf_core.context('OKL_AM_QUOTES_WF' , 'update_partial_quote', itemtype, itemkey, actid, funcmode);
7849: RAISE;
7850:
7851: END update_partial_quote;
7852:

Line 7929: wf_core.context('OKL_AM_QUOTES_WF' , 'update_gain_loss_quote', itemtype, itemkey, actid, funcmode);

7925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
7926: || sqlcode || ' , SQLERRM : ' || sqlerrm);
7927: END IF;
7928:
7929: wf_core.context('OKL_AM_QUOTES_WF' , 'update_gain_loss_quote', itemtype, itemkey, actid, funcmode);
7930: RAISE;
7931:
7932: END update_gain_loss_quote;
7933:

Line 8056: wf_core.context('OKL_AM_QUOTES_WF' , 'chk_securitization', itemtype, itemkey, actid, funcmode);

8052: IF get_quote_values_csr%ISOPEN THEN
8053: CLOSE get_quote_values_csr;
8054: END IF;
8055:
8056: wf_core.context('OKL_AM_QUOTES_WF' , 'chk_securitization', itemtype, itemkey, actid, funcmode);
8057: RAISE;
8058:
8059: WHEN OTHERS THEN
8060: IF (is_debug_exception_on) THEN

Line 8069: wf_core.context('OKL_AM_QUOTES_WF' , 'chk_securitization', itemtype, itemkey, actid, funcmode);

8065: IF get_quote_values_csr%ISOPEN THEN
8066: CLOSE get_quote_values_csr;
8067: END IF;
8068:
8069: wf_core.context('OKL_AM_QUOTES_WF' , 'chk_securitization', itemtype, itemkey, actid, funcmode);
8070: RAISE;
8071:
8072: END chk_securitization;
8073:

Line 8177: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',

8173: IF (is_debug_exception_on) THEN
8174: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
8175: END IF;
8176:
8177: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',
8178: itemtype, itemkey, actid, funcmode);
8179: RAISE;
8180: WHEN OTHERS THEN
8181: IF (is_debug_exception_on) THEN

Line 8186: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',

8182: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
8183: || sqlcode || ' , SQLERRM : ' || sqlerrm);
8184: END IF;
8185:
8186: WF_CORE.context('OKL_AM_QUOTES_WF' , 'update_quote_status',
8187: itemtype, itemkey, actid, funcmode);
8188: RAISE;
8189:
8190:

Line 8442: wf_core.context('OKL_AM_QUOTES_WF' , 'check_rollover_amount', itemtype, itemkey, actid, funcmode);

8438: END IF;
8439: IF c_qtl_csr%ISOPEN THEN
8440: CLOSE c_qtl_csr;
8441: END IF;
8442: wf_core.context('OKL_AM_QUOTES_WF' , 'check_rollover_amount', itemtype, itemkey, actid, funcmode);
8443: RAISE;
8444:
8445: END check_rollover_amount;
8446:

Line 8618: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_REPO_QUOTE', itemtype,

8614: WHEN G_EXCEPTION THEN
8615: IF (is_debug_exception_on) THEN
8616: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
8617: END IF;
8618: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_REPO_QUOTE', itemtype,
8619: itemkey, actid, funcmode);
8620: RAISE;
8621: WHEN OTHERS THEN
8622: IF (is_debug_exception_on) THEN

Line 8627: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_REPO_QUOTE', itemtype,

8623: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
8624: || sqlcode || ' , SQLERRM : ' || sqlerrm);
8625: END IF;
8626:
8627: wf_core.context('OKL_AM_QUOTES_WF' , 'CHECK_IF_REPO_QUOTE', itemtype,
8628: itemkey, actid, funcmode);
8629: RAISE;
8630: END CHECK_IF_REPO_QUOTE;
8631:

Line 8882: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_repo_asset_return',

8878:
8879: IF c_asset_return_csr%ISOPEN THEN
8880: CLOSE c_asset_return_csr;
8881: END IF;
8882: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_repo_asset_return',
8883: itemtype, itemkey, actid, funcmode);
8884: RAISE;
8885:
8886: WHEN OTHERS THEN

Line 8900: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_repo_asset_return',

8896:
8897: IF c_asset_return_csr%ISOPEN THEN
8898: CLOSE c_asset_return_csr;
8899: END IF;
8900: WF_CORE.context('OKL_AM_QUOTES_WF' , 'create_repo_asset_return',
8901: itemtype, itemkey, actid, funcmode);
8902: RAISE;
8903:
8904: END create_repo_asset_return;