DBA Data[Home] [Help]

APPS.PO_WF_UTIL_PKG dependencies on PO_WF_UTIL_PKG

Line 1: PACKAGE BODY PO_WF_UTIL_PKG AS

1: PACKAGE BODY PO_WF_UTIL_PKG AS
2: /* $Header: POXWUTLB.pls 120.2.12020000.2 2013/02/10 23:54:32 vegajula ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 11: | PL/SQL body for package: PO_WF_UTIL_PKG

7: | FILENAME
8: | POXWUTLB.pls
9: |
10: | DESCRIPTION
11: | PL/SQL body for package: PO_WF_UTIL_PKG
12: |
13: | NOTES
14: | CREATE
15: | MODIFIED

Line 35: 'PO_WF_UTIL_PKG.SetItemAttrText: ' || aname ||

31: WHEN OTHERS THEN
32: IF (g_po_wf_debug = 'Y') THEN
33: PO_WF_DEBUG_PKG.insert_debug(itemtype,
34: itemkey,
35: 'PO_WF_UTIL_PKG.SetItemAttrText: ' || aname ||
36: ' ' || sqlerrm);
37: END IF;
38:
39: END SetItemAttrText;

Line 55: 'PO_WF_UTIL_PKG.SetItemAttrText: ' || aname ||

51: WHEN OTHERS THEN
52: IF (g_po_wf_debug = 'Y') THEN
53: PO_WF_DEBUG_PKG.insert_debug(G_ITEM_TYPE,
54: G_ITEM_KEY,
55: 'PO_WF_UTIL_PKG.SetItemAttrText: ' || aname ||
56: ' ' || sqlerrm);
57: END IF;
58:
59: END SetItemAttrText;

Line 79: 'PO_WF_UTIL_PKG.SetItemAttrNumber: ' || aname ||

75: WHEN OTHERS THEN
76: IF (g_po_wf_debug = 'Y') THEN
77: PO_WF_DEBUG_PKG.insert_debug(itemtype,
78: itemkey,
79: 'PO_WF_UTIL_PKG.SetItemAttrNumber: ' || aname ||
80: ' ' || sqlerrm);
81: END IF;
82:
83: END SetItemAttrNumber;

Line 101: 'PO_WF_UTIL_PKG.SetItemAttrNumber: ' || aname ||

97: WHEN OTHERS THEN
98: IF (g_po_wf_debug = 'Y') THEN
99: PO_WF_DEBUG_PKG.insert_debug(G_ITEM_TYPE,
100: G_ITEM_KEY,
101: 'PO_WF_UTIL_PKG.SetItemAttrNumber: ' || aname ||
102: ' ' || sqlerrm);
103: END IF;
104:
105: END SetItemAttrNumber;

Line 125: 'PO_WF_UTIL_PKG.SetItemAttrDate: ' || aname ||

121: WHEN OTHERS THEN
122: IF (g_po_wf_debug = 'Y') THEN
123: PO_WF_DEBUG_PKG.insert_debug(itemtype,
124: itemkey,
125: 'PO_WF_UTIL_PKG.SetItemAttrDate: ' || aname ||
126: ' ' || sqlerrm);
127: END IF;
128:
129: END SetItemAttrDate;

Line 150: 'PO_WF_UTIL_PKG.SetItemAttrDocument: ' || aname ||

146: WHEN OTHERS THEN
147: IF (g_po_wf_debug = 'Y') THEN
148: PO_WF_DEBUG_PKG.insert_debug(itemtype,
149: itemkey,
150: 'PO_WF_UTIL_PKG.SetItemAttrDocument: ' || aname ||
151: ' ' || sqlerrm);
152: END IF;
153:
154: END SetItemAttrDocument;

Line 175: 'PO_WF_UTIL_PKG.GetItemAttrText: ' || aname ||

171: WHEN OTHERS THEN
172: IF (g_po_wf_debug = 'Y') THEN
173: PO_WF_DEBUG_PKG.insert_debug(itemtype,
174: itemkey,
175: 'PO_WF_UTIL_PKG.GetItemAttrText: ' || aname ||
176: ' ' || sqlerrm);
177: END IF;
178: return NULL;
179:

Line 198: 'PO_WF_UTIL_PKG.GetItemAttrText: ' || aname ||

194: WHEN OTHERS THEN
195: IF (g_po_wf_debug = 'Y') THEN
196: PO_WF_DEBUG_PKG.insert_debug(G_ITEM_TYPE,
197: G_ITEM_KEY,
198: 'PO_WF_UTIL_PKG.GetItemAttrText: ' || aname ||
199: ' ' || sqlerrm);
200: END IF;
201: return NULL;
202:

Line 222: 'PO_WF_UTIL_PKG.GetItemAttrNumber: ' || aname ||

218: WHEN OTHERS THEN
219: IF (g_po_wf_debug = 'Y') THEN
220: PO_WF_DEBUG_PKG.insert_debug(itemtype,
221: itemkey,
222: 'PO_WF_UTIL_PKG.GetItemAttrNumber: ' || aname ||
223: ' ' || sqlerrm);
224: END IF;
225: return NULL;
226:

Line 246: 'PO_WF_UTIL_PKG.GetItemAttrNumber: ' || aname ||

242: WHEN OTHERS THEN
243: IF (g_po_wf_debug = 'Y') THEN
244: PO_WF_DEBUG_PKG.insert_debug(G_ITEM_TYPE,
245: G_ITEM_KEY,
246: 'PO_WF_UTIL_PKG.GetItemAttrNumber: ' || aname ||
247: ' ' || sqlerrm);
248: END IF;
249: return NULL;
250:

Line 270: 'PO_WF_UTIL_PKG.GetItemAttrDate: ' || aname ||

266: WHEN OTHERS THEN
267: IF (g_po_wf_debug = 'Y') THEN
268: PO_WF_DEBUG_PKG.insert_debug(itemtype,
269: itemkey,
270: 'PO_WF_UTIL_PKG.GetItemAttrDate: ' || aname ||
271: ' ' || sqlerrm);
272: END IF;
273: return NULL;
274:

Line 296: 'PO_WF_UTIL_PKG.GetItemAttrDocument: ' || aname ||

292: WHEN OTHERS THEN
293: IF (g_po_wf_debug = 'Y') THEN
294: PO_WF_DEBUG_PKG.insert_debug(itemtype,
295: itemkey,
296: 'PO_WF_UTIL_PKG.GetItemAttrDocument: ' || aname ||
297: ' ' || sqlerrm);
298: END IF;
299: return NULL;
300:

Line 324: 'PO_WF_UTIL_PKG.GetActivityAttrText: ' || aname ||

320: WHEN OTHERS THEN
321: IF (g_po_wf_debug = 'Y') THEN
322: PO_WF_DEBUG_PKG.insert_debug(itemtype,
323: itemkey,
324: 'PO_WF_UTIL_PKG.GetActivityAttrText: ' || aname ||
325: ' ' || sqlerrm);
326: END IF;
327: return NULL;
328:

Line 352: 'PO_WF_UTIL_PKG.GetActivityAttrNumber: ' || aname ||

348: WHEN OTHERS THEN
349: IF (g_po_wf_debug = 'Y') THEN
350: PO_WF_DEBUG_PKG.insert_debug(itemtype,
351: itemkey,
352: 'PO_WF_UTIL_PKG.GetActivityAttrNumber: ' || aname ||
353: ' ' || sqlerrm);
354: END IF;
355: return NULL;
356:

Line 380: 'PO_WF_UTIL_PKG.GetActivityAttrDate: ' || aname ||

376: WHEN OTHERS THEN
377: IF (g_po_wf_debug = 'Y') THEN
378: PO_WF_DEBUG_PKG.insert_debug(itemtype,
379: itemkey,
380: 'PO_WF_UTIL_PKG.GetActivityAttrDate: ' || aname ||
381: ' ' || sqlerrm);
382: END IF;
383: return NULL;
384:

Line 435: PO_MESSAGE_S.sql_error ('PO_WF_UTIL_PKG.clear_wf_cache', l_progress, sqlcode);

431:
432: EXCEPTION
433: WHEN OTHERS THEN
434:
435: PO_MESSAGE_S.sql_error ('PO_WF_UTIL_PKG.clear_wf_cache', l_progress, sqlcode);
436: RAISE;
437:
438: END clear_wf_cache;
439:

Line 449: end PO_WF_UTIL_PKG;

445: BEGIN
446: return wf_core.error_message;
447: END GetWorkflowErrorMessage;
448: -- bug 4720152 END
449: end PO_WF_UTIL_PKG;