DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_WF_DEBUG_PKG

Line 2702: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2698: l_preserved_ctx := 'FALSE';
2699: end if;
2700: l_progress := 'notif callback preserved_ctx : '||l_preserved_ctx;
2701: IF (g_po_wf_debug = 'Y') THEN
2702: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2703: END IF;
2704: --
2705:
2706:

Line 2717: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2713:
2714: --
2715: l_progress := '010 notif callback -responder id : '||l_responder_id;
2716: IF (g_po_wf_debug = 'Y') THEN
2717: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2718: END IF;
2719: --
2720:
2721: --Bug 5389914

Line 2746: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2742: l_progress :='020 notification callback ses_userid: '||l_session_user_id
2743: ||' sess_resp_id '||l_session_resp_id||' sess_appl_id '
2744: ||l_session_appl_id;
2745: IF (g_po_wf_debug = 'Y') THEN
2746: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2747: END IF;
2748: --
2749:
2750: -- bug 4901406 : need to shift the setting of the preparer resp and appl id

Line 2767: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2763: --
2764: l_progress := '030 notif callback prep resp_id:'||l_preparer_resp_id
2765: ||' prep appl id '||l_preparer_appl_id;
2766: IF (g_po_wf_debug = 'Y') THEN
2767: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2768: END IF;
2769: --
2770:
2771: -- bug 4901406

Line 3038: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3034:
3035: BEGIN
3036: l_progress := 'GetDisplayValue: 001, user name: ' || username;
3037: IF (g_po_wf_debug = 'Y') THEN
3038: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3039: END IF;
3040:
3041: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3042: itemkey => itemkey,

Line 3055: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3051: l_territory);
3052:
3053: l_progress := 'GetDisplayValue: 002, language: ' || l_language;
3054: IF (g_po_wf_debug = 'Y') THEN
3055: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3056: END IF;
3057:
3058: OPEN c_lookup_value(l_doc_subtype, l_language);
3059: FETCH c_lookup_value into l_doc_disp;

Line 3064: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3060: CLOSE c_lookup_value;
3061:
3062: l_progress := 'GetDisplayValue: 003, subtype disp: ' || l_doc_disp;
3063: IF (g_po_wf_debug = 'Y') THEN
3064: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3065: END IF;
3066:
3067: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
3068: itemkey => itemkey,

Line 3075: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3071: EXCEPTION
3072: WHEN OTHERS THEN
3073: l_progress := 'GetDisplayValue: sql err: ' || sqlerrm;
3074: IF (g_po_wf_debug = 'Y') THEN
3075: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3076: END IF;
3077: IF (c_lookup_value%ISOPEN) THEN
3078: CLOSE c_lookup_value;
3079: END IF;

Line 3111: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3107: end if;
3108:
3109: l_progress := 'Get_req_approver_msg_attribute: 001';
3110: IF (g_po_wf_debug = 'Y') THEN
3111: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3112: END IF;
3113:
3114: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3115: itemkey => itemkey,

Line 3133: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3129: GetDisplayValue(itemtype, itemkey, l_approver_user_name);
3130:
3131: l_progress := 'Get_req_approver_msg_attribute: 002';
3132: IF (g_po_wf_debug = 'Y') THEN
3133: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3134: END IF;
3135:
3136: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3137:

Line 3173: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3169: end if;
3170:
3171: l_progress := 'Get_req_preparer_msg_attribute: 001';
3172: IF (g_po_wf_debug = 'Y') THEN
3173: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3174: END IF;
3175:
3176: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3177: itemkey => itemkey,

Line 3196: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3192: GetDisplayValue(itemtype, itemkey, l_preparer_user_name);
3193:
3194: l_progress := 'Get_req_preparer_msg_attribute: 002';
3195: IF (g_po_wf_debug = 'Y') THEN
3196: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3197: END IF;
3198:
3199: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3200:

Line 3262: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3258: end if;
3259:
3260: l_progress := 'Get_req_fwdfrom_msg_attribute: 001';
3261: IF (g_po_wf_debug = 'Y') THEN
3262: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3263: END IF;
3264:
3265: l_fwdfrom_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3266: itemkey => itemkey,

Line 3281: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3277: GetDisplayValue(itemtype, itemkey, l_fwdfrom_user_name);
3278:
3279: l_progress := 'Get_req_fwdfrom_msg_attribute: 002';
3280: IF (g_po_wf_debug = 'Y') THEN
3281: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3282: END IF;
3283:
3284: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3285:

Line 3366: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_WF_REQ_NOTIFICATION.get_item_info nid='||nid);

3362: end;
3363: end if;
3364:
3365: IF (g_po_wf_debug = 'Y') THEN
3366: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_WF_REQ_NOTIFICATION.get_item_info nid='||nid);
3367: END IF;
3368:
3369: end;
3370: