DBA Data[Home] [Help]

APPS.PO_XML_UTILS_GRP dependencies on WF_CORE

Line 91: wf_core.context('PO_XML_UTILS_GRP','splitforids',SQLERRM);

87: x_appl_id := to_number(substr(l_resp_appl, instr(l_resp_appl,':')+1));
88:
89: exception
90: when others then
91: wf_core.context('PO_XML_UTILS_GRP','splitforids',SQLERRM);
92: raise;
93:
94: end splitforids;
95:

Line 118: wf_core.context('PO_XML_UTILS_GRP','splitforids',SQLERRM);

114: end if;
115:
116: exception
117: when others then
118: wf_core.context('PO_XML_UTILS_GRP','splitforids',SQLERRM);
119: -- raise; we don't want to raise exception here as it will lead to failure in XML gen.
120:
121:
122: end getBlanketPONumber;

Line 252: wf_core.context('PO_ECX_UTIL_PKG','regenandsend',x_progress);

248: INVALID_TXN_TYPE EXCEPTION;
249: BEGIN
250:
251:
252: wf_core.context('PO_ECX_UTIL_PKG','regenandsend',x_progress);
253:
254: -- Create EVENT_KEY and EVENT_NAME
255: select PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;
256: l_event_key := to_char(p_po_header_id) || '-' || to_char(l_wf_item_seq);

Line 259: wf_core.context('POM_ECX_UTIL_PKG','regenandsend',x_progress);

255: select PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;
256: l_event_key := to_char(p_po_header_id) || '-' || to_char(l_wf_item_seq);
257:
258: x_progress := '001';
259: wf_core.context('POM_ECX_UTIL_PKG','regenandsend',x_progress);
260:
261: if (upper(p_po_type) = 'RELEASE') then
262: select pha.segment1, pha.org_id
263: into l_po_number, l_org_id

Line 281: wf_core.context('POM_ECX_UTIL_PKG','regenandsend',x_progress);

277:
278:
279: end if;
280: x_progress := '002';
281: wf_core.context('POM_ECX_UTIL_PKG','regenandsend',x_progress);
282:
283: -- Add Parameters
284: wf_event.AddParameterToList(p_name =>'DOCUMENT_ID',
285: p_value => p_po_header_id,

Line 321: wf_core.context('PO_ECX_UTIL_PKG','regenandsend',x_progress);

317:
318: -- dbms_output.put_line (l_event_key);
319:
320: x_progress := '002';
321: wf_core.context('PO_ECX_UTIL_PKG','regenandsend',x_progress);
322: wf_event.raise( p_event_name => l_event_name,
323: p_event_key => l_event_key,
324: p_parameters => l_parameter_list);
325: x_progress := '002';

Line 335: wf_core.context('PO_ECX_UTIL_PKG','regenandsend',x_progress);

331: commit;
332: EXCEPTION
333: when others then
334: x_progress := x_progress || SQLERRM;
335: wf_core.context('PO_ECX_UTIL_PKG','regenandsend',x_progress);
336:
337: --dbms_output.put_line (SQLERRM);
338: raise;
339: