1: PACKAGE BODY PO_WF_UTIL_PKG AS
2: /* $Header: POXWUTLB.pls 120.1.12000000.2 2007/04/23 08:05:02 rakchakr 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');
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
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;
56: WHEN OTHERS THEN
57: IF (g_po_wf_debug = 'Y') THEN
58: PO_WF_DEBUG_PKG.insert_debug(itemtype,
59: itemkey,
60: 'PO_WF_UTIL_PKG.SetItemAttrNumber: ' || aname ||
61: ' ' || sqlerrm);
62: END IF;
63:
64: END SetItemAttrNumber;
81: WHEN OTHERS THEN
82: IF (g_po_wf_debug = 'Y') THEN
83: PO_WF_DEBUG_PKG.insert_debug(itemtype,
84: itemkey,
85: 'PO_WF_UTIL_PKG.SetItemAttrDate: ' || aname ||
86: ' ' || sqlerrm);
87: END IF;
88:
89: END SetItemAttrDate;
106: WHEN OTHERS THEN
107: IF (g_po_wf_debug = 'Y') THEN
108: PO_WF_DEBUG_PKG.insert_debug(itemtype,
109: itemkey,
110: 'PO_WF_UTIL_PKG.SetItemAttrDocument: ' || aname ||
111: ' ' || sqlerrm);
112: END IF;
113:
114: END SetItemAttrDocument;
131: WHEN OTHERS THEN
132: IF (g_po_wf_debug = 'Y') THEN
133: PO_WF_DEBUG_PKG.insert_debug(itemtype,
134: itemkey,
135: 'PO_WF_UTIL_PKG.GetItemAttrText: ' || aname ||
136: ' ' || sqlerrm);
137: END IF;
138: return NULL;
139:
157: WHEN OTHERS THEN
158: IF (g_po_wf_debug = 'Y') THEN
159: PO_WF_DEBUG_PKG.insert_debug(itemtype,
160: itemkey,
161: 'PO_WF_UTIL_PKG.GetItemAttrNumber: ' || aname ||
162: ' ' || sqlerrm);
163: END IF;
164: return NULL;
165:
183: WHEN OTHERS THEN
184: IF (g_po_wf_debug = 'Y') THEN
185: PO_WF_DEBUG_PKG.insert_debug(itemtype,
186: itemkey,
187: 'PO_WF_UTIL_PKG.GetItemAttrDate: ' || aname ||
188: ' ' || sqlerrm);
189: END IF;
190: return NULL;
191:
209: WHEN OTHERS THEN
210: IF (g_po_wf_debug = 'Y') THEN
211: PO_WF_DEBUG_PKG.insert_debug(itemtype,
212: itemkey,
213: 'PO_WF_UTIL_PKG.GetItemAttrDocument: ' || aname ||
214: ' ' || sqlerrm);
215: END IF;
216: return NULL;
217:
237: WHEN OTHERS THEN
238: IF (g_po_wf_debug = 'Y') THEN
239: PO_WF_DEBUG_PKG.insert_debug(itemtype,
240: itemkey,
241: 'PO_WF_UTIL_PKG.GetActivityAttrText: ' || aname ||
242: ' ' || sqlerrm);
243: END IF;
244: return NULL;
245:
265: WHEN OTHERS THEN
266: IF (g_po_wf_debug = 'Y') THEN
267: PO_WF_DEBUG_PKG.insert_debug(itemtype,
268: itemkey,
269: 'PO_WF_UTIL_PKG.GetActivityAttrNumber: ' || aname ||
270: ' ' || sqlerrm);
271: END IF;
272: return NULL;
273:
293: WHEN OTHERS THEN
294: IF (g_po_wf_debug = 'Y') THEN
295: PO_WF_DEBUG_PKG.insert_debug(itemtype,
296: itemkey,
297: 'PO_WF_UTIL_PKG.GetActivityAttrDate: ' || aname ||
298: ' ' || sqlerrm);
299: END IF;
300: return NULL;
301:
348:
349: EXCEPTION
350: WHEN OTHERS THEN
351:
352: PO_MESSAGE_S.sql_error ('PO_WF_UTIL_PKG.clear_wf_cache', l_progress, sqlcode);
353: RAISE;
354:
355: END clear_wf_cache;
356:
365: -- bug 4720152 END
366:
367:
368:
369: end PO_WF_UTIL_PKG;