DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on WF_CORE

Line 3883: wf_core.CONTEXT

3879: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
3880: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
3881: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
3882: END IF;
3883: wf_core.CONTEXT
3884: (
3885: pkg_name => G_PKG_NAME,
3886: proc_name => l_api_name,
3887: arg1 => itemtype,

Line 3897: wf_core.CONTEXT

3893: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
3894: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
3895: ||SQLCODE||', sqlerrm = '||SQLERRM);
3896: END IF;
3897: wf_core.CONTEXT
3898: (
3899: pkg_name => G_PKG_NAME,
3900: proc_name => l_api_name,
3901: arg1 => itemtype,

Line 4211: wf_core.CONTEXT

4207: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
4208: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
4209: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
4210: END IF;
4211: wf_core.CONTEXT
4212: (
4213: pkg_name => G_PKG_NAME,
4214: proc_name => l_api_name,
4215: arg1 => itemtype,

Line 4225: wf_core.CONTEXT

4221: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4222: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
4223: ||SQLCODE||', sqlerrm = '||SQLERRM);
4224: END IF;
4225: wf_core.CONTEXT
4226: (
4227: pkg_name => G_PKG_NAME,
4228: proc_name => l_api_name,
4229: arg1 => itemtype,

Line 4358: wf_core.CONTEXT

4354: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
4355: ||SQLCODE||', sqlerrm = '||SQLERRM);
4356: END IF;
4357:
4358: wf_core.CONTEXT
4359: (
4360: pkg_name => G_PKG_NAME,
4361: proc_name => l_api_name,
4362: arg1 => itemtype,

Line 5143: wf_core.CONTEXT

5139: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5140: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5141: ||SQLCODE||', sqlerrm = '||SQLERRM);
5142: END IF;
5143: wf_core.CONTEXT
5144: (
5145: pkg_name => G_PKG_NAME,
5146: proc_name => l_api_name,
5147: arg1 => itemtype,

Line 5397: wf_core.CONTEXT

5393: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5394: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5395: ||SQLCODE||', sqlerrm = '||SQLERRM);
5396: END IF;
5397: wf_core.CONTEXT
5398: (
5399: pkg_name => G_PKG_NAME,
5400: proc_name => l_api_name,
5401: arg1 => itemtype,

Line 5542: wf_core.CONTEXT

5538: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
5539: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
5540: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
5541: END IF;
5542: wf_core.CONTEXT
5543: (
5544: pkg_name => G_PKG_NAME,
5545: proc_name => l_api_name,
5546: arg1 => itemtype,

Line 5556: wf_core.CONTEXT

5552: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5553: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5554: ||SQLCODE||', sqlerrm = '||SQLERRM);
5555: END IF;
5556: wf_core.CONTEXT
5557: (
5558: pkg_name => G_PKG_NAME,
5559: proc_name => l_api_name,
5560: arg1 => itemtype,

Line 5679: wf_core.CONTEXT

5675: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
5676: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
5677: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
5678: END IF;
5679: wf_core.CONTEXT
5680: (
5681: pkg_name => G_PKG_NAME,
5682: proc_name => l_api_name,
5683: arg1 => itemtype,

Line 5693: wf_core.CONTEXT

5689: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5690: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5691: ||SQLCODE||', sqlerrm = '||SQLERRM);
5692: END IF;
5693: wf_core.CONTEXT
5694: (
5695: pkg_name => G_PKG_NAME,
5696: proc_name => l_api_name,
5697: arg1 => itemtype,

Line 5787: wf_core.CONTEXT

5783: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5784: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5785: ||SQLCODE||', sqlerrm = '||SQLERRM);
5786: END IF;
5787: wf_core.CONTEXT
5788: (
5789: pkg_name => G_PKG_NAME,
5790: proc_name => l_api_name,
5791: arg1 => itemtype,

Line 7135: wf_core.CONTEXT

7131: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7132: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
7133: ||SQLCODE||', sqlerrm = '||SQLERRM);
7134: END IF;
7135: wf_core.CONTEXT
7136: (
7137: pkg_name => G_PKG_NAME,
7138: proc_name => l_api_name,
7139: arg1 => itemtype,

Line 7279: wf_core.CONTEXT

7275: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7276: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7277: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7278: END IF;
7279: wf_core.CONTEXT
7280: (
7281: pkg_name => G_PKG_NAME,
7282: proc_name => l_api_name,
7283: arg1 => itemtype,

Line 7293: wf_core.CONTEXT

7289: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7290: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
7291: ||SQLCODE||', sqlerrm = '||SQLERRM);
7292: END IF;
7293: wf_core.CONTEXT
7294: (
7295: pkg_name => G_PKG_NAME,
7296: proc_name => l_api_name,
7297: arg1 => itemtype,

Line 7403: wf_core.CONTEXT

7399: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7400: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7401: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7402: END IF;
7403: wf_core.CONTEXT
7404: (
7405: pkg_name => G_PKG_NAME,
7406: proc_name => l_api_name,
7407: arg1 => itemtype,

Line 7417: wf_core.CONTEXT

7413: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7414: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
7415: ||SQLCODE||', sqlerrm = '||SQLERRM);
7416: END IF;
7417: wf_core.CONTEXT
7418: (
7419: pkg_name => G_PKG_NAME,
7420: proc_name => l_api_name,
7421: arg1 => itemtype,

Line 7560: wf_core.CONTEXT

7556: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.NegStatusUpdateException'
7557: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7558: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7559: END IF;
7560: wf_core.CONTEXT
7561: (
7562: pkg_name => G_PKG_NAME,
7563: proc_name => l_api_name,
7564: arg1 => itemtype,

Line 7576: wf_core.CONTEXT

7572: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7573: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7574: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7575: END IF;
7576: wf_core.CONTEXT
7577: (
7578: pkg_name => G_PKG_NAME,
7579: proc_name => l_api_name,
7580: arg1 => itemtype,

Line 7590: wf_core.CONTEXT

7586: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7587: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
7588: ||SQLCODE||', sqlerrm = '||SQLERRM);
7589: END IF;
7590: wf_core.CONTEXT
7591: (
7592: pkg_name => G_PKG_NAME,
7593: proc_name => l_api_name,
7594: arg1 => itemtype,

Line 7995: wf_core.CONTEXT

7991: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7992: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7993: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7994: END IF;
7995: wf_core.CONTEXT
7996: (
7997: pkg_name => G_PKG_NAME,
7998: proc_name => l_api_name,
7999: arg1 => itemtype,

Line 8010: wf_core.CONTEXT

8006: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
8007: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
8008: ||SQLCODE||', sqlerrm = '||SQLERRM);
8009: END IF;
8010: wf_core.CONTEXT
8011: (
8012: pkg_name => G_PKG_NAME,
8013: proc_name => l_api_name,
8014: arg1 => itemtype,

Line 8805: wf_core.CONTEXT

8801: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
8802: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
8803: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
8804: END IF;
8805: wf_core.CONTEXT
8806: (
8807: pkg_name => G_PKG_NAME,
8808: proc_name => l_api_name,
8809: arg1 => itemtype,

Line 8821: wf_core.CONTEXT

8817: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
8818: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
8819: ||SQLCODE||', sqlerrm = '||SQLERRM);
8820: END IF;
8821: wf_core.CONTEXT
8822: (
8823: pkg_name => G_PKG_NAME,
8824: proc_name => l_api_name,
8825: arg1 => itemtype,

Line 9273: WF_CORE.get_error(l_wf_err_name, l_wf_err_msg, l_wf_err_stack, 4000);

9269: WHEN OTHERS THEN
9270: ROLLBACK TO launch_k_process_wf_blk_PVT;
9271:
9272: --since we are calling workflow api's we need to check for workflow errors
9273: WF_CORE.get_error(l_wf_err_name, l_wf_err_msg, l_wf_err_stack, 4000);
9274:
9275: IF (l_wf_err_name IS NOT NULL) THEN
9276: --workflow error
9277: WF_CORE.clear;

Line 9277: WF_CORE.clear;

9273: WF_CORE.get_error(l_wf_err_name, l_wf_err_msg, l_wf_err_stack, 4000);
9274:
9275: IF (l_wf_err_name IS NOT NULL) THEN
9276: --workflow error
9277: WF_CORE.clear;
9278: --set the status to error, so that calling program can handle it
9279: x_return_status := FND_API.g_ret_sts_error ;
9280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_wf_err_name||' '||l_wf_err_msg);
9281: