DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_WF_DEBUG_PKG

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

2850: l_preserved_ctx := 'FALSE';
2851: end if;
2852: l_progress := 'notif callback l_is_ame_approval preserved_ctx : '||l_preserved_ctx || 'l_is_ame_approval :' || l_is_ame_approval ;
2853: IF (g_po_wf_debug = 'Y') THEN
2854: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2855: END IF;
2856: --
2857:
2858:

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

2865:
2866: --
2867: l_progress := '010 notif callback -responder id : '||l_responder_id;
2868: IF (g_po_wf_debug = 'Y') THEN
2869: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2870: END IF;
2871: --
2872:
2873: --Bug 5389914

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

2885:
2886: if ( l_is_ame_approval = 'Y' ) then
2887: l_progress := 'notif callback watch for l_is_ame_approval p_itemtype,'||p_itemtype ||' p_itemkey ' || p_itemkey ;
2888: IF (g_po_wf_debug = 'Y') THEN
2889: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2890: END IF;
2891: else
2892: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => p_itemtype,
2893: itemkey => p_itemkey,

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

2896: l_progress := 'notif callback l_is_ame_approval was not Y hence get this from parent wf now p_itemtype,'
2897: ||p_itemtype || 'p_itemkey ' || p_itemkey || 'l_is_ame_approval :'|| l_is_ame_approval ;
2898:
2899: IF (g_po_wf_debug = 'Y') THEN
2900: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2901: END IF;
2902: end if;
2903:
2904:

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

2918: l_progress :='020 notification callback ses_userid: '||l_session_user_id
2919: ||' sess_resp_id '||l_session_resp_id||' sess_appl_id '
2920: ||l_session_appl_id;
2921: IF (g_po_wf_debug = 'Y') THEN
2922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2923: END IF;
2924: --
2925:
2926: -- bug 4901406 : need to shift the setting of the preparer resp and appl id

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

2939:
2940: l_progress := '030 notif callback prep resp_id:'||l_preparer_resp_id
2941: ||' prep appl id '||l_preparer_appl_id;
2942: IF (g_po_wf_debug = 'Y') THEN
2943: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2944: END IF;
2945:
2946: -- bug 4901406
2947:

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

2954:
2955: --
2956: l_progress := '050 notif setting RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
2957: IF (g_po_wf_debug = 'Y') THEN
2958: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2959: END IF;
2960: --
2961:
2962: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

Line 2978: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

2974:
2975: if( l_is_ame_approval = 'Y' ) then
2976: l_progress := '05A notif setting for parent wf RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
2977: IF (g_po_wf_debug = 'Y') THEN
2978: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
2979: END IF;
2980:
2981: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
2982: itemkey => p_itemkey,

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

2999:
3000:
3001: l_progress := '055 notif setting l_session_resp_id is null RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
3002: IF (g_po_wf_debug = 'Y') THEN
3003: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3004: END IF;
3005:
3006: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3007: itemkey => itemkey,

Line 3021: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3017: avalue => l_preparer_appl_id);
3018: if( l_is_ame_approval = 'Y' ) then
3019: l_progress := '05B notif setting for parent wf RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
3020: IF (g_po_wf_debug = 'Y') THEN
3021: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3022: END IF;
3023:
3024: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3025: itemkey => p_itemkey,

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

3046:
3047: --
3048: l_progress := '060 notif setting l_session_resp_id is not null RESPONDER_USER_ID l_responder_id:'|| l_responder_id || 'l_preserved_ctx :' || l_preserved_ctx ;
3049: IF (g_po_wf_debug = 'Y') THEN
3050: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3051: END IF;
3052: --
3053: if ( l_preserved_ctx = 'TRUE') then
3054:

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

3054:
3055:
3056: l_progress := '070 notif setting l_session_resp_id is null RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
3057: IF (g_po_wf_debug = 'Y') THEN
3058: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3059: END IF;
3060:
3061: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3062: itemkey => itemkey,

Line 3076: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3072: avalue => l_session_appl_id);
3073: if( l_is_ame_approval = 'Y' ) then
3074: l_progress := '05C notif setting for parent wf RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
3075: IF (g_po_wf_debug = 'Y') THEN
3076: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3077: END IF;
3078:
3079:
3080: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

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

3094: else
3095: --
3096: l_progress := '080 notif setting l_session_resp_id is null RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
3097: IF (g_po_wf_debug = 'Y') THEN
3098: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3099: END IF;
3100: --
3101:
3102: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

Line 3117: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3113: avalue => l_preparer_appl_id);
3114: if( l_is_ame_approval = 'Y' ) then
3115: l_progress := '05D notif setting for parent wf RESPONDER_USER_ID l_responder_id:'|| l_responder_id;
3116: IF (g_po_wf_debug = 'Y') THEN
3117: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3118: END IF;
3119:
3120:
3121: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

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

3336:
3337: BEGIN
3338: l_progress := 'GetDisplayValue: 001, user name: ' || username;
3339: IF (g_po_wf_debug = 'Y') THEN
3340: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3341: END IF;
3342:
3343: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3344: itemkey => itemkey,

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

3353: l_territory);
3354:
3355: l_progress := 'GetDisplayValue: 002, language: ' || l_language;
3356: IF (g_po_wf_debug = 'Y') THEN
3357: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3358: END IF;
3359:
3360: -- MIPR changes
3361: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');

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

3373: END IF;
3374:
3375: l_progress := 'GetDisplayValue: 003, subtype disp: ' || l_doc_disp;
3376: IF (g_po_wf_debug = 'Y') THEN
3377: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3378: END IF;
3379:
3380: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
3381: itemkey => itemkey,

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

3384: EXCEPTION
3385: WHEN OTHERS THEN
3386: l_progress := 'GetDisplayValue: sql err: ' || sqlerrm;
3387: IF (g_po_wf_debug = 'Y') THEN
3388: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3389: END IF;
3390: IF (c_lookup_value%ISOPEN) THEN
3391: CLOSE c_lookup_value;
3392: END IF;

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

3420: end if;
3421:
3422: l_progress := 'Get_req_approver_msg_attribute: 001';
3423: IF (g_po_wf_debug = 'Y') THEN
3424: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3425: END IF;
3426:
3427: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3428: itemkey => itemkey,

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

3442: GetDisplayValue(itemtype, itemkey, l_approver_user_name);
3443:
3444: l_progress := 'Get_req_approver_msg_attribute: 002';
3445: IF (g_po_wf_debug = 'Y') THEN
3446: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3447: END IF;
3448:
3449: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3450:

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

3482: end if;
3483:
3484: l_progress := 'Get_req_preparer_msg_attribute: 001';
3485: IF (g_po_wf_debug = 'Y') THEN
3486: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3487: END IF;
3488:
3489: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3490: itemkey => itemkey,

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

3505: GetDisplayValue(itemtype, itemkey, l_preparer_user_name);
3506:
3507: l_progress := 'Get_req_preparer_msg_attribute: 002';
3508: IF (g_po_wf_debug = 'Y') THEN
3509: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3510: END IF;
3511:
3512: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3513:

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

3571: end if;
3572:
3573: l_progress := 'Get_req_fwdfrom_msg_attribute: 001';
3574: IF (g_po_wf_debug = 'Y') THEN
3575: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3576: END IF;
3577:
3578: l_fwdfrom_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3579: itemkey => itemkey,

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

3590: GetDisplayValue(itemtype, itemkey, l_fwdfrom_user_name);
3591:
3592: l_progress := 'Get_req_fwdfrom_msg_attribute: 002';
3593: IF (g_po_wf_debug = 'Y') THEN
3594: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3595: END IF;
3596:
3597: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3598:

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

3675: end;
3676: end if;
3677:
3678: IF (g_po_wf_debug = 'Y') THEN
3679: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_WF_REQ_NOTIFICATION.get_item_info nid='||nid);
3680: END IF;
3681:
3682: end;
3683: