DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on PO_WF_DEBUG_PKG

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

101:
102: IF (funcmode = 'RUN') THEN
103: l_progress := '001';
104: IF (g_po_wf_debug = 'Y') THEN
105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
106: END IF;
107:
108: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
109: itemkey => itemkey,

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

125: itemkey => itemkey,
126: aname => 'FORWARD_TO_ID');
127: l_progress := '002';
128: IF (g_po_wf_debug = 'Y') THEN
129: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
130: END IF;
131:
132: If ( l_forward_to is not null ) then
133: por_ame_approval_list.change_first_approver ( pReqHeaderId => l_document_id,

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

138: pFieldDelimiter => l_FieldDelimiter );
139:
140: l_progress := '003';
141: IF (g_po_wf_debug = 'Y') THEN
142: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
143: END IF;
144:
145: -- return the req to requester if forwarding fails
146: if ( l_ApprovalListCount = 0 or l_ApprovalListStr = 'NO_DATA_FOUND' or l_ApprovalListStr = 'EXCEPTION' ) then

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

161: END IF;
162:
163: l_progress := '004';
164: IF (g_po_wf_debug = 'Y') THEN
165: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
166: END IF;
167:
168: END IF; -- FOR 'RUN' MODE
169:

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

223:
224: IF (funcmode = 'RUN') THEN
225: l_progress := 'Is_Ame_For_Approval: 001';
226: IF (g_po_wf_debug = 'Y') THEN
227: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
228: END IF;
229:
230: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
231: itemkey => itemkey,

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

319:
320: IF (funcmode = 'RUN') THEN
321: l_progress := 'Is_Ame_For_Rco_Approval: 001';
322: IF (g_po_wf_debug = 'Y') THEN
323: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
324: END IF;
325:
326:
327: begin

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

340: end;
341:
342: l_progress := 'Is_Ame_For_Rco_Approval: 002';
343: IF (g_po_wf_debug = 'Y') THEN
344: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
345: END IF;
346:
347: if (l_transaction_type is not null) then
348:

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

434: IF (funcmode = 'RUN') THEN
435:
436: l_progress := 'Get_Next_Approver: 001';
437: IF (g_po_wf_debug = 'Y') THEN
438: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
439: END IF;
440:
441: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
442: itemkey => itemkey,

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

457:
458: l_progress := 'Get_Next_Approver: 002-'||to_char(l_document_id)||'-'||
459: l_document_type||'-'||l_document_subtype;
460: IF (g_po_wf_debug = 'Y') THEN
461: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
462: END IF;
463: ame_api.getNextApprover(applicationIdIn=>applicationId,
464: transactionIdIn=>l_document_id,
465: transactionTypeIn=>l_transaction_type,

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

465: transactionTypeIn=>l_transaction_type,
466: nextApproverOut=>l_next_approver);
467: l_progress := ('l_next_approver=' || to_char(l_next_approver.person_id));
468: IF (g_po_wf_debug = 'Y') THEN
469: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
470: END IF;
471:
472: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
473: raise E_FAILURE;

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

487: l_progress := 'Get_Next_Approver: 003- get_next_approver - '||
488: to_char(l_next_approver_id);
489:
490: IF (g_po_wf_debug = 'Y') THEN
491: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
492: END IF;
493:
494: wf_engine.SetItemAttrNumber ( itemtype => itemType,
495: itemkey => itemkey,

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

520:
521: l_progress := 'Get_Next_Approver: 004- GetUserName - '||
522: l_next_approver_user_name;
523: IF (g_po_wf_debug = 'Y') THEN
524: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
525: END IF;
526:
527:
528: wf_engine.SetItemAttrText( itemtype => itemType,

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

613: BEGIN
614:
615: l_progress := ' Update_Approval_List_Response: 001- at beginning of function';
616: IF (g_po_wf_debug = 'Y') THEN
617: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
618: END IF;
619:
620: IF (funcmode='RUN') THEN
621:

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

657: ' RESPONSE' || l_value || ' INSERTION? '||
658: l_insertion_type|| ' AUTHORITY? ' || l_authority_type;
659:
660: IF (g_po_wf_debug = 'Y') THEN
661: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
662: END IF;
663:
664: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
665: itemkey => itemkey,

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

675: p_forward_to_id=>l_forward_to_id,
676: p_response=>l_value);
677:
678: IF (g_po_wf_debug = 'Y') THEN
679: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
680: END IF;
681:
682: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
683: RETURN;

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

738: BEGIN
739:
740: l_progress := ' Update_Approver_timeout: 001- at beginning of function';
741: IF (g_po_wf_debug = 'Y') THEN
742: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
743: END IF;
744:
745: IF (funcmode='RUN') THEN
746: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

770: p_response=>'TIMEOUT');
771:
772: l_progress := ' Update_Approver_timeout: 002- at end of function';
773: IF (g_po_wf_debug = 'Y') THEN
774: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
775: END IF;
776:
777: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
778: RETURN;