eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SIGNATURE_PVT dependencies on WF_ENGINE

Line 115: if (funcmode <> WF_ENGINE.eng_run) then

111: END IF;
112:
113: -- Do nothing in cancel or timeout mode
114: --
115: if (funcmode <> WF_ENGINE.eng_run) then
116: resultout := WF_ENGINE.eng_null;
117: return;
118: END if;
119:

Line 116: resultout := WF_ENGINE.eng_null;

112:
113: -- Do nothing in cancel or timeout mode
114: --
115: if (funcmode <> WF_ENGINE.eng_run) then
116: resultout := WF_ENGINE.eng_null;
117: return;
118: END if;
119:
120: -- Set the multi-org context

Line 138: WF_ENGINE.SetItemOwner (itemtype => itemtype,

134: PO_REQAPPROVAL_INIT1.get_user_name(p_employee_id => l_preparer_id,
135: x_username => l_username,
136: x_user_display_name => l_user_display_name);
137:
138: WF_ENGINE.SetItemOwner (itemtype => itemtype,
139: itemkey => itemkey,
140: owner => l_username);
141:
142: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

Line 626: if (funcmode <> WF_ENGINE.eng_run) then

622: END IF;
623:
624: -- Do nothing in cancel or timeout mode
625: --
626: if (funcmode <> WF_ENGINE.eng_run) then
627: resultout := WF_ENGINE.eng_null;
628: return;
629: END if;
630:

Line 627: resultout := WF_ENGINE.eng_null;

623:
624: -- Do nothing in cancel or timeout mode
625: --
626: if (funcmode <> WF_ENGINE.eng_run) then
627: resultout := WF_ENGINE.eng_null;
628: return;
629: END if;
630:
631: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

Line 979: if (funcmode <> WF_ENGINE.eng_run) then

975: END IF;
976:
977: -- Do nothing in cancel or timeout mode
978: --
979: if (funcmode <> WF_ENGINE.eng_run) then
980: resultout := WF_ENGINE.eng_null;
981: return;
982: END if;
983: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 980: resultout := WF_ENGINE.eng_null;

976:
977: -- Do nothing in cancel or timeout mode
978: --
979: if (funcmode <> WF_ENGINE.eng_run) then
980: resultout := WF_ENGINE.eng_null;
981: return;
982: END if;
983: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
984: itemkey => itemkey,

Line 1434: if (funcmode <> WF_ENGINE.eng_run) then

1430: END IF;
1431:
1432: -- Do nothing in cancel or timeout mode
1433: --
1434: if (funcmode <> WF_ENGINE.eng_run) then
1435: resultout := WF_ENGINE.eng_null;
1436: return;
1437: END if;
1438:

Line 1435: resultout := WF_ENGINE.eng_null;

1431:
1432: -- Do nothing in cancel or timeout mode
1433: --
1434: if (funcmode <> WF_ENGINE.eng_run) then
1435: resultout := WF_ENGINE.eng_null;
1436: return;
1437: END if;
1438:
1439: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

Line 1562: if (funcmode <> WF_ENGINE.eng_run) then

1558: END IF;
1559:
1560: -- Do nothing in cancel or timeout mode
1561: --
1562: if (funcmode <> WF_ENGINE.eng_run) then
1563: resultout := WF_ENGINE.eng_null;
1564: return;
1565: END if;
1566:

Line 1563: resultout := WF_ENGINE.eng_null;

1559:
1560: -- Do nothing in cancel or timeout mode
1561: --
1562: if (funcmode <> WF_ENGINE.eng_run) then
1563: resultout := WF_ENGINE.eng_null;
1564: return;
1565: END if;
1566:
1567: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

Line 1935: if (funcmode <> WF_ENGINE.eng_run) then

1931: END IF;
1932:
1933: -- Do nothing in cancel or timeout mode
1934: --
1935: if (funcmode <> WF_ENGINE.eng_run) then
1936: resultout := WF_ENGINE.eng_null;
1937: return;
1938: END if;
1939:

Line 1936: resultout := WF_ENGINE.eng_null;

1932:
1933: -- Do nothing in cancel or timeout mode
1934: --
1935: if (funcmode <> WF_ENGINE.eng_run) then
1936: resultout := WF_ENGINE.eng_null;
1937: return;
1938: END if;
1939:
1940: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

Line 2290: if (funcmode <> WF_ENGINE.eng_run) then

2286: END IF;
2287:
2288: -- Do nothing in cancel or timeout mode
2289: --
2290: if (funcmode <> WF_ENGINE.eng_run) then
2291: resultout := WF_ENGINE.eng_null;
2292: return;
2293: END if;
2294:

Line 2291: resultout := WF_ENGINE.eng_null;

2287:
2288: -- Do nothing in cancel or timeout mode
2289: --
2290: if (funcmode <> WF_ENGINE.eng_run) then
2291: resultout := WF_ENGINE.eng_null;
2292: return;
2293: END if;
2294:
2295: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

Line 2401: if (funcmode <> WF_ENGINE.eng_run) then

2397: END IF;
2398:
2399: -- Do nothing in cancel or timeout mode
2400: --
2401: if (funcmode <> WF_ENGINE.eng_run) then
2402: resultout := WF_ENGINE.eng_null;
2403: return;
2404: END if;
2405:

Line 2402: resultout := WF_ENGINE.eng_null;

2398:
2399: -- Do nothing in cancel or timeout mode
2400: --
2401: if (funcmode <> WF_ENGINE.eng_run) then
2402: resultout := WF_ENGINE.eng_null;
2403: return;
2404: END if;
2405:
2406: --

Line 2417: resultout := WF_ENGINE.eng_completed || ':' || l_req_signature;

2413: END IF;
2414: --
2415: --
2416:
2417: resultout := WF_ENGINE.eng_completed || ':' || l_req_signature;
2418:
2419: IF (g_po_wf_debug = 'Y') THEN
2420: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 02. Result= ' || l_req_signature;
2421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 2653: l_notification_id := WF_ENGINE.context_nid;

2649: l_preparer_user_name WF_USERS.name%TYPE;
2650:
2651: BEGIN
2652: IF (funcmode = 'RESPOND') THEN
2653: l_notification_id := WF_ENGINE.context_nid;
2654:
2655: PO_WF_UTIL_PKG.SetItemAttrNumber(
2656: itemtype => itemtype,
2657: itemkey => itemkey,

Line 2718: l_notification_id := WF_ENGINE.context_nid;

2714:
2715: BEGIN
2716:
2717: IF (funcmode = 'RESPOND') THEN
2718: l_notification_id := WF_ENGINE.context_nid;
2719: PO_WF_UTIL_PKG.SetItemAttrNumber(
2720: itemtype => itemtype,
2721: itemkey => itemkey,
2722: aname => 'NOTIFICATION_ID',

Line 2736: avalue => WF_ENGINE.context_new_role);

2732: PO_WF_UTIL_PKG.SetItemAttrText(
2733: itemtype => itemtype,
2734: itemkey => itemkey,
2735: aname => 'KO_USER_NAME',
2736: avalue => WF_ENGINE.context_new_role);
2737:
2738: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2739: itemkey => itemkey,
2740: aname => 'DRAFT_ID');

Line 2750: WHERE user_name = WF_ENGINE.context_new_role;

2746: BEGIN
2747: SELECT employee_id
2748: INTO l_contracting_officer
2749: FROM fnd_user
2750: WHERE user_name = WF_ENGINE.context_new_role;
2751: EXCEPTION
2752: when no_data_found then
2753: l_contracting_officer := null;
2754: end;

Line 2830: l_notification_id := WF_ENGINE.context_nid;

2826:
2827: BEGIN
2828:
2829: IF (funcmode = 'RESPOND') THEN
2830: l_notification_id := WF_ENGINE.context_nid;
2831: PO_WF_UTIL_PKG.SetItemAttrNumber(
2832: itemtype => itemtype,
2833: itemkey => itemkey,
2834: aname => 'NOTIFICATION_ID',

Line 2848: avalue => WF_ENGINE.context_new_role);

2844: PO_WF_UTIL_PKG.SetItemAttrText(
2845: itemtype => itemtype,
2846: itemkey => itemkey,
2847: aname => 'KO_USER_NAME',
2848: avalue => WF_ENGINE.context_new_role);
2849:
2850: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2851: itemkey => itemkey,
2852: aname => 'DRAFT_ID');

Line 2862: WHERE user_name = WF_ENGINE.context_new_role;

2858: BEGIN
2859: SELECT employee_id
2860: INTO l_contracting_officer
2861: FROM fnd_user
2862: WHERE user_name = WF_ENGINE.context_new_role;
2863: EXCEPTION
2864: when no_data_found then
2865: l_contracting_officer := null;
2866: end;

Line 3408: WF_ENGINE.AbortProcess(itemtype => 'POAPPRV',

3404: AND item_key = p_itemkey
3405: AND end_date IS NULL;
3406:
3407: IF l_itemkey IS NOT NULL THEN
3408: WF_ENGINE.AbortProcess(itemtype => 'POAPPRV',
3409: itemkey => l_itemkey,
3410: process => '',
3411: result => WF_ENGINE.eng_force);
3412: END IF;

Line 3411: result => WF_ENGINE.eng_force);

3407: IF l_itemkey IS NOT NULL THEN
3408: WF_ENGINE.AbortProcess(itemtype => 'POAPPRV',
3409: itemkey => l_itemkey,
3410: process => '',
3411: result => WF_ENGINE.eng_force);
3412: END IF;
3413: x_result := 'S';
3414: EXCEPTION
3415: WHEN NO_DATA_FOUND THEN

Line 3472: WF_ENGINE.CompleteActivity('POAPPRV', p_itemkey, l_activity_name, p_status);

3468: x_result := 'S';
3469: END;
3470:
3471: IF l_activity_name IS NOT NULL THEN
3472: WF_ENGINE.CompleteActivity('POAPPRV', p_itemkey, l_activity_name, p_status);
3473: END IF;
3474: END COMPLETE_BLOCK_ACTIVITIES;
3475:
3476: -------------------------------------------------------------------------------

Line 4284: if (funcmode <> WF_ENGINE.eng_run) then

4280: END IF;
4281:
4282: -- Do nothing in cancel or timeout mode
4283: --
4284: if (funcmode <> WF_ENGINE.eng_run) then
4285: resultout := WF_ENGINE.eng_null;
4286: return;
4287: END if;
4288:

Line 4285: resultout := WF_ENGINE.eng_null;

4281:
4282: -- Do nothing in cancel or timeout mode
4283: --
4284: if (funcmode <> WF_ENGINE.eng_run) then
4285: resultout := WF_ENGINE.eng_null;
4286: return;
4287: END if;
4288:
4289:

Line 4346: resultout := WF_ENGINE.eng_completed || ':' || l_is_doc_signed ;

4342: end;
4343: end if;
4344:
4345:
4346: resultout := WF_ENGINE.eng_completed || ':' || l_is_doc_signed ;
4347:
4348: IF (g_po_wf_debug = 'Y') THEN
4349: l_progress := 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed: 03. Result= ' || l_is_doc_signed;
4350: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 4413: if (funcmode <> WF_ENGINE.eng_run) then

4409: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress);
4410:
4411: -- Do nothing in cancel or timeout mode
4412: --
4413: if (funcmode <> WF_ENGINE.eng_run) then
4414: resultout := WF_ENGINE.eng_null;
4415: return;
4416: END if;
4417:

Line 4414: resultout := WF_ENGINE.eng_null;

4410:
4411: -- Do nothing in cancel or timeout mode
4412: --
4413: if (funcmode <> WF_ENGINE.eng_run) then
4414: resultout := WF_ENGINE.eng_null;
4415: return;
4416: END if;
4417:
4418: -- Get the Document Type and ID from the Workflow Attributes.

Line 4482: resultout := WF_ENGINE.eng_completed || ':' || l_acceptance_mode ;

4478: l_acceptance_mode := 'SIGNATURE_PROXY';
4479: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' l_acceptance_mode = '||l_acceptance_mode);
4480: END IF;
4481:
4482: resultout := WF_ENGINE.eng_completed || ':' || l_acceptance_mode ;
4483:
4484: EXCEPTION
4485:
4486: WHEN OTHERS THEN

Line 4546: if (funcmode <> WF_ENGINE.eng_run) then

4542: END IF;
4543:
4544: -- Do nothing in cancel or timeout mode
4545: --
4546: if (funcmode <> WF_ENGINE.eng_run) then
4547: resultout := WF_ENGINE.eng_null;
4548: return;
4549: END if;
4550: --l_ko_sign_required := NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');

Line 4547: resultout := WF_ENGINE.eng_null;

4543:
4544: -- Do nothing in cancel or timeout mode
4545: --
4546: if (funcmode <> WF_ENGINE.eng_run) then
4547: resultout := WF_ENGINE.eng_null;
4548: return;
4549: END if;
4550: --l_ko_sign_required := NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');
4551: l_ko_sign_required := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 4558: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');

4554: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4555: itemkey => itemkey,
4556: aname => 'KO_RESPONSE');
4557:
4558: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4559: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
4560: -- CLM Apprvl
4561: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');
4562:

Line 4559: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');

4555: itemkey => itemkey,
4556: aname => 'KO_RESPONSE');
4557:
4558: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4559: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
4560: -- CLM Apprvl
4561: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');
4562:
4563: --We need to check for both the profile and the ko_response to determine if the ko signature is required. the check for co response will eliminate the routing for co signature multiple times.

Line 4565: resultout := WF_ENGINE.eng_completed || ':' || 'Y' ;

4561: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');
4562:
4563: --We need to check for both the profile and the ko_response to determine if the ko signature is required. the check for co response will eliminate the routing for co signature multiple times.
4564: IF l_ko_sign_required = 'Y' AND l_ko_response IS NULL THEN
4565: resultout := WF_ENGINE.eng_completed || ':' || 'Y' ;
4566:
4567: -- Bug 12757491:
4568: -- Adding this code to init 'EDIT_DOC_URL' attribute in contracting officer approval notification message.
4569: -- Edit document link in the message is based on this attribute.

Line 4581: resultout := WF_ENGINE.eng_completed || ':' || 'N' ;

4577:
4578: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);
4579:
4580: ELSE
4581: resultout := WF_ENGINE.eng_completed || ':' || 'N' ;
4582: END IF;
4583: EXCEPTION
4584: WHEN others THEN
4585: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||SQLERRM);

Line 4648: if (funcmode <> WF_ENGINE.eng_run) then

4644: END IF;
4645:
4646: -- Do nothing in cancel or timeout mode
4647: --
4648: if (funcmode <> WF_ENGINE.eng_run) then
4649: resultout := WF_ENGINE.eng_null;
4650: return;
4651: END if;
4652:

Line 4649: resultout := WF_ENGINE.eng_null;

4645:
4646: -- Do nothing in cancel or timeout mode
4647: --
4648: if (funcmode <> WF_ENGINE.eng_run) then
4649: resultout := WF_ENGINE.eng_null;
4650: return;
4651: END if;
4652:
4653: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

Line 4734: resultout := WF_ENGINE.eng_completed || ':' || 'VALID_ACTION' ;

4730: aname => 'PO_SUP_INFO_MSG_BODY',
4731: avalue =>
4732: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
4733:
4734: resultout := WF_ENGINE.eng_completed || ':' || 'VALID_ACTION' ;
4735: ELSE
4736: resultout := WF_ENGINE.eng_completed || ':' || 'INVALID_ACTION' ;
4737: END IF;
4738:

Line 4736: resultout := WF_ENGINE.eng_completed || ':' || 'INVALID_ACTION' ;

4732: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
4733:
4734: resultout := WF_ENGINE.eng_completed || ':' || 'VALID_ACTION' ;
4735: ELSE
4736: resultout := WF_ENGINE.eng_completed || ':' || 'INVALID_ACTION' ;
4737: END IF;
4738:
4739: IF (g_po_wf_debug = 'Y') THEN
4740: l_progress := 'PO_SIGNATURE_PVT.set_accepted_ko_response: 02';

Line 4805: if (funcmode <> WF_ENGINE.eng_run) then

4801: END IF;
4802:
4803: -- Do nothing in cancel or timeout mode
4804: --
4805: if (funcmode <> WF_ENGINE.eng_run) then
4806: resultout := WF_ENGINE.eng_null;
4807: return;
4808: END if;
4809:

Line 4806: resultout := WF_ENGINE.eng_null;

4802:
4803: -- Do nothing in cancel or timeout mode
4804: --
4805: if (funcmode <> WF_ENGINE.eng_run) then
4806: resultout := WF_ENGINE.eng_null;
4807: return;
4808: END if;
4809:
4810: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

Line 4920: IF (funcmode <> WF_ENGINE.eng_run) THEN

4916: END IF;
4917:
4918: -- Do nothing in cancel or timeout mode
4919: --
4920: IF (funcmode <> WF_ENGINE.eng_run) THEN
4921: resultout := WF_ENGINE.eng_null;
4922: return;
4923: END if;
4924: /* Contracting Officer Signature ER. When a KO doesn't have enough warrant to sign the document, he will forrward the document to another KO with sufficient warrants. */

Line 4921: resultout := WF_ENGINE.eng_null;

4917:
4918: -- Do nothing in cancel or timeout mode
4919: --
4920: IF (funcmode <> WF_ENGINE.eng_run) THEN
4921: resultout := WF_ENGINE.eng_null;
4922: return;
4923: END if;
4924: /* Contracting Officer Signature ER. When a KO doesn't have enough warrant to sign the document, he will forrward the document to another KO with sufficient warrants. */
4925: --The logic to determine if the KO has warrant to sign the document will be included here.