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 4799: wf_core.context('OKL_AM_QUOTES_WF' , 'pop_gl_quote_att', itemtype, itemkey, actid, funcmode);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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