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.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');

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 60: 'PO_WF_UTIL_PKG.SetItemAttrNumber: ' || aname ||

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;

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

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;

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

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;

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

Line 369: end PO_WF_UTIL_PKG;

365: -- bug 4720152 END
366:
367:
368:
369: end PO_WF_UTIL_PKG;