DBA Data[Home] [Help]

APPS.ASP_ALERTS_WF dependencies on WF_CORE

Line 138: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

134: return;
135:
136: EXCEPTION
137: When no_data_found Then
138: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
139: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
140: wf_core.token('ORA_ERROR',l_debug_msg);
141: wf_engine.threshold := save_threshold;
142: wf_core.raise('WF_ORA');

Line 140: wf_core.token('ORA_ERROR',l_debug_msg);

136: EXCEPTION
137: When no_data_found Then
138: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
139: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
140: wf_core.token('ORA_ERROR',l_debug_msg);
141: wf_engine.threshold := save_threshold;
142: wf_core.raise('WF_ORA');
143:
144: When others Then

Line 142: wf_core.raise('WF_ORA');

138: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
139: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
140: wf_core.token('ORA_ERROR',l_debug_msg);
141: wf_engine.threshold := save_threshold;
142: wf_core.raise('WF_ORA');
143:
144: When others Then
145: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
146: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);

Line 145: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

141: wf_engine.threshold := save_threshold;
142: wf_core.raise('WF_ORA');
143:
144: When others Then
145: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
146: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
147: wf_core.token('ORA_ERROR',l_debug_msg);
148: wf_engine.threshold := save_threshold;
149: wf_core.raise('WF_ORA');

Line 147: wf_core.token('ORA_ERROR',l_debug_msg);

143:
144: When others Then
145: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
146: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
147: wf_core.token('ORA_ERROR',l_debug_msg);
148: wf_engine.threshold := save_threshold;
149: wf_core.raise('WF_ORA');
150:
151: END Initiate_Bsa_Alerts;

Line 149: wf_core.raise('WF_ORA');

145: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
146: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
147: wf_core.token('ORA_ERROR',l_debug_msg);
148: wf_engine.threshold := save_threshold;
149: wf_core.raise('WF_ORA');
150:
151: END Initiate_Bsa_Alerts;
152:
153: