41:
42: /* If it's Req or PO approval then get some of the info that we want to log.
43: ** If the profile option is set , then log debug messages.
44: */
45: /* Bug 2834040 fixed. replaced the wf_engine call with po_wf_util_pkg
46: wrapper call so that debug messages will get logged inspite of
47: the workflow attributes not being set.
48: */
49: fnd_profile.get('PO_SET_DEBUG_WORKFLOW_ON',x_option_value);
51: IF x_option_value = 'Y' THEN
52:
53: IF itemtype IN ('REQAPPRV','POAPPRV') THEN
54:
55: l_document_number:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'DOCUMENT_NUMBER');
58: --
59: l_document_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType,
55: l_document_number:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'DOCUMENT_NUMBER');
58: --
59: l_document_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType,
60: itemkey => itemkey,
61: aname => 'DOCUMENT_ID');
62:
63: l_preparer_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType,
59: l_document_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType,
60: itemkey => itemkey,
61: aname => 'DOCUMENT_ID');
62:
63: l_preparer_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType,
64: itemkey => itemkey,
65: aname => 'PREPARER_ID');
66: --
67: l_Forward_to_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
63: l_preparer_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType,
64: itemkey => itemkey,
65: aname => 'PREPARER_ID');
66: --
67: l_Forward_to_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
68: itemkey => itemkey,
69: aname => 'FORWARD_TO_ID');
70: --
71: l_Forward_from_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
67: l_Forward_to_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
68: itemkey => itemkey,
69: aname => 'FORWARD_TO_ID');
70: --
71: l_Forward_from_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
72: itemkey => itemkey,
73: aname => 'FORWARD_FROM_ID');
74: --
75: l_Forward_to_username:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemType,
71: l_Forward_from_id:= PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
72: itemkey => itemkey,
73: aname => 'FORWARD_FROM_ID');
74: --
75: l_Forward_to_username:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemType,
76: itemkey => itemkey,
77: aname => 'FORWARD_TO_USERNAME');
78:
79: l_Forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemType,
75: l_Forward_to_username:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemType,
76: itemkey => itemkey,
77: aname => 'FORWARD_TO_USERNAME');
78:
79: l_Forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemType,
80: itemkey => itemkey,
81: aname => 'FORWARD_FROM_USER_NAME');
82:
83: l_approver_empid:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
79: l_Forward_from_username:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemType,
80: itemkey => itemkey,
81: aname => 'FORWARD_FROM_USER_NAME');
82:
83: l_approver_empid:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'APPROVER_EMPID');
86:
87: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
83: l_approver_empid:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'APPROVER_EMPID');
86:
87: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'AUTHORIZATION_STATUS');
90: END IF;
91: