DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on WF_CORE

Line 3765: wf_core.CONTEXT

3761: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
3762: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
3763: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
3764: END IF;
3765: wf_core.CONTEXT
3766: (
3767: pkg_name => G_PKG_NAME,
3768: proc_name => l_api_name,
3769: arg1 => itemtype,

Line 3779: wf_core.CONTEXT

3775: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
3776: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
3777: ||SQLCODE||', sqlerrm = '||SQLERRM);
3778: END IF;
3779: wf_core.CONTEXT
3780: (
3781: pkg_name => G_PKG_NAME,
3782: proc_name => l_api_name,
3783: arg1 => itemtype,

Line 4093: wf_core.CONTEXT

4089: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
4090: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
4091: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
4092: END IF;
4093: wf_core.CONTEXT
4094: (
4095: pkg_name => G_PKG_NAME,
4096: proc_name => l_api_name,
4097: arg1 => itemtype,

Line 4107: wf_core.CONTEXT

4103: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4104: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
4105: ||SQLCODE||', sqlerrm = '||SQLERRM);
4106: END IF;
4107: wf_core.CONTEXT
4108: (
4109: pkg_name => G_PKG_NAME,
4110: proc_name => l_api_name,
4111: arg1 => itemtype,

Line 4240: wf_core.CONTEXT

4236: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
4237: ||SQLCODE||', sqlerrm = '||SQLERRM);
4238: END IF;
4239:
4240: wf_core.CONTEXT
4241: (
4242: pkg_name => G_PKG_NAME,
4243: proc_name => l_api_name,
4244: arg1 => itemtype,

Line 4977: wf_core.CONTEXT

4973: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4974: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
4975: ||SQLCODE||', sqlerrm = '||SQLERRM);
4976: END IF;
4977: wf_core.CONTEXT
4978: (
4979: pkg_name => G_PKG_NAME,
4980: proc_name => l_api_name,
4981: arg1 => itemtype,

Line 5231: wf_core.CONTEXT

5227: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5228: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5229: ||SQLCODE||', sqlerrm = '||SQLERRM);
5230: END IF;
5231: wf_core.CONTEXT
5232: (
5233: pkg_name => G_PKG_NAME,
5234: proc_name => l_api_name,
5235: arg1 => itemtype,

Line 5376: wf_core.CONTEXT

5372: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
5373: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
5374: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
5375: END IF;
5376: wf_core.CONTEXT
5377: (
5378: pkg_name => G_PKG_NAME,
5379: proc_name => l_api_name,
5380: arg1 => itemtype,

Line 5390: wf_core.CONTEXT

5386: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5387: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5388: ||SQLCODE||', sqlerrm = '||SQLERRM);
5389: END IF;
5390: wf_core.CONTEXT
5391: (
5392: pkg_name => G_PKG_NAME,
5393: proc_name => l_api_name,
5394: arg1 => itemtype,

Line 5483: wf_core.CONTEXT

5479: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5480: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
5481: ||SQLCODE||', sqlerrm = '||SQLERRM);
5482: END IF;
5483: wf_core.CONTEXT
5484: (
5485: pkg_name => G_PKG_NAME,
5486: proc_name => l_api_name,
5487: arg1 => itemtype,

Line 6831: wf_core.CONTEXT

6827: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6828: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
6829: ||SQLCODE||', sqlerrm = '||SQLERRM);
6830: END IF;
6831: wf_core.CONTEXT
6832: (
6833: pkg_name => G_PKG_NAME,
6834: proc_name => l_api_name,
6835: arg1 => itemtype,

Line 6975: wf_core.CONTEXT

6971: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
6972: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
6973: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
6974: END IF;
6975: wf_core.CONTEXT
6976: (
6977: pkg_name => G_PKG_NAME,
6978: proc_name => l_api_name,
6979: arg1 => itemtype,

Line 6989: wf_core.CONTEXT

6985: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6986: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
6987: ||SQLCODE||', sqlerrm = '||SQLERRM);
6988: END IF;
6989: wf_core.CONTEXT
6990: (
6991: pkg_name => G_PKG_NAME,
6992: proc_name => l_api_name,
6993: arg1 => itemtype,

Line 7099: wf_core.CONTEXT

7095: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7096: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7097: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7098: END IF;
7099: wf_core.CONTEXT
7100: (
7101: pkg_name => G_PKG_NAME,
7102: proc_name => l_api_name,
7103: arg1 => itemtype,

Line 7113: wf_core.CONTEXT

7109: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7110: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
7111: ||SQLCODE||', sqlerrm = '||SQLERRM);
7112: END IF;
7113: wf_core.CONTEXT
7114: (
7115: pkg_name => G_PKG_NAME,
7116: proc_name => l_api_name,
7117: arg1 => itemtype,

Line 7256: wf_core.CONTEXT

7252: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.NegStatusUpdateException'
7253: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7254: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7255: END IF;
7256: wf_core.CONTEXT
7257: (
7258: pkg_name => G_PKG_NAME,
7259: proc_name => l_api_name,
7260: arg1 => itemtype,

Line 7272: wf_core.CONTEXT

7268: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7269: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7270: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7271: END IF;
7272: wf_core.CONTEXT
7273: (
7274: pkg_name => G_PKG_NAME,
7275: proc_name => l_api_name,
7276: arg1 => itemtype,

Line 7286: wf_core.CONTEXT

7282: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7283: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
7284: ||SQLCODE||', sqlerrm = '||SQLERRM);
7285: END IF;
7286: wf_core.CONTEXT
7287: (
7288: pkg_name => G_PKG_NAME,
7289: proc_name => l_api_name,
7290: arg1 => itemtype,

Line 7691: wf_core.CONTEXT

7687: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7688: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
7689: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
7690: END IF;
7691: wf_core.CONTEXT
7692: (
7693: pkg_name => G_PKG_NAME,
7694: proc_name => l_api_name,
7695: arg1 => itemtype,

Line 7706: wf_core.CONTEXT

7702: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7703: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
7704: ||SQLCODE||', sqlerrm = '||SQLERRM);
7705: END IF;
7706: wf_core.CONTEXT
7707: (
7708: pkg_name => G_PKG_NAME,
7709: proc_name => l_api_name,
7710: arg1 => itemtype,

Line 8501: wf_core.CONTEXT

8497: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
8498: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));
8499: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,l_msg_data);
8500: END IF;
8501: wf_core.CONTEXT
8502: (
8503: pkg_name => G_PKG_NAME,
8504: proc_name => l_api_name,
8505: arg1 => itemtype,

Line 8517: wf_core.CONTEXT

8513: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
8514: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
8515: ||SQLCODE||', sqlerrm = '||SQLERRM);
8516: END IF;
8517: wf_core.CONTEXT
8518: (
8519: pkg_name => G_PKG_NAME,
8520: proc_name => l_api_name,
8521: arg1 => itemtype,

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

8965: WHEN OTHERS THEN
8966: ROLLBACK TO launch_k_process_wf_blk_PVT;
8967:
8968: --since we are calling workflow api's we need to check for workflow errors
8969: WF_CORE.get_error(l_wf_err_name, l_wf_err_msg, l_wf_err_stack, 4000);
8970:
8971: IF (l_wf_err_name IS NOT NULL) THEN
8972: --workflow error
8973: WF_CORE.clear;

Line 8973: WF_CORE.clear;

8969: WF_CORE.get_error(l_wf_err_name, l_wf_err_msg, l_wf_err_stack, 4000);
8970:
8971: IF (l_wf_err_name IS NOT NULL) THEN
8972: --workflow error
8973: WF_CORE.clear;
8974: --set the status to error, so that calling program can handle it
8975: x_return_status := FND_API.g_ret_sts_error ;
8976: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_wf_err_name||' '||l_wf_err_msg);
8977: