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.

[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on WF_ENGINE

Line 320: IF (funcmode <> wf_engine.eng_run)

316: END IF;
317:
318:
319: -- : Do nothing in cancel or timeout modes.
320: IF (funcmode <> wf_engine.eng_run)
321: THEN
322: resultout := wf_engine.eng_null;
323: return;
324: END IF;

Line 322: resultout := wf_engine.eng_null;

318:
319: -- : Do nothing in cancel or timeout modes.
320: IF (funcmode <> wf_engine.eng_run)
321: THEN
322: resultout := wf_engine.eng_null;
323: return;
324: END IF;
325: --
326:

Line 349: resultout := wf_engine.eng_completed || ':' || 'Y';

345:
346: IF PO_COMMUNICATION_PROFILE = 'T' THEN
347: IF l_document_type in ('PO','PA') and l_document_subtype in ('STANDARD','BLANKET','CONTRACT')
348: or (l_document_type = 'RELEASE' and l_document_subtype = 'BLANKET' ) THEN
349: resultout := wf_engine.eng_completed || ':' || 'Y';
350: ELSE
351: resultout := wf_engine.eng_completed || ':' || 'N';
352: END IF;
353:

Line 351: resultout := wf_engine.eng_completed || ':' || 'N';

347: IF l_document_type in ('PO','PA') and l_document_subtype in ('STANDARD','BLANKET','CONTRACT')
348: or (l_document_type = 'RELEASE' and l_document_subtype = 'BLANKET' ) THEN
349: resultout := wf_engine.eng_completed || ':' || 'Y';
350: ELSE
351: resultout := wf_engine.eng_completed || ':' || 'N';
352: END IF;
353:
354: Else
355: resultout := wf_engine.eng_completed || ':' || 'N';

Line 355: resultout := wf_engine.eng_completed || ':' || 'N';

351: resultout := wf_engine.eng_completed || ':' || 'N';
352: END IF;
353:
354: Else
355: resultout := wf_engine.eng_completed || ':' || 'N';
356: END IF;
357:
358: EXCEPTION
359:

Line 392: IF (funcmode <> wf_engine.eng_run)

388: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
389: END IF;
390:
391: -- : Do nothing in cancel or timeout modes.
392: IF (funcmode <> wf_engine.eng_run)
393: THEN
394: resultout := wf_engine.eng_null;
395: return;
396: END IF;

Line 394: resultout := wf_engine.eng_null;

390:
391: -- : Do nothing in cancel or timeout modes.
392: IF (funcmode <> wf_engine.eng_run)
393: THEN
394: resultout := wf_engine.eng_null;
395: return;
396: END IF;
397: --
398:

Line 580: resultout := wf_engine.eng_completed || ':' || 'Y';

576: END ;
577:
578:
579: IF l_count >0 THEN
580: resultout := wf_engine.eng_completed || ':' || 'Y';
581: Else
582: resultout := wf_engine.eng_completed || ':' || 'N';
583: End if;
584:

Line 582: resultout := wf_engine.eng_completed || ':' || 'N';

578:
579: IF l_count >0 THEN
580: resultout := wf_engine.eng_completed || ':' || 'Y';
581: Else
582: resultout := wf_engine.eng_completed || ':' || 'N';
583: End if;
584:
585: EXCEPTION
586: When others then

Line 592: resultout := wf_engine.eng_completed || ':' || 'N';

588: IF (g_po_wf_debug = 'Y') THEN
589: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
590: END IF;
591: wf_core.context('PO_COMMUNICATION_PVT','PO_PDF_EXISTS',x_progress);
592: resultout := wf_engine.eng_completed || ':' || 'N';
593: raise;
594:
595: END PO_PDF_EXISTS;
596:

Line 656: wf_engine.CreateProcess( ItemType => l_itemtype,

652:
653:
654: l_workflow_process := 'EMAIL_PO_PDF';
655:
656: wf_engine.CreateProcess( ItemType => l_itemtype,
657: ItemKey => l_itemkey,
658: process => l_workflow_process );
659:
660:

Line 743: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

739: select segment1,global_agreement_flag into l_docNumber,l_ga_flag
740: from po_headers_all
741: where po_header_id = l_document_id;
742:
743: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
744: itemkey => l_itemkey,
745: aname => 'DOCUMENT_NUMBER',
746: avalue => l_docNumber);
747:

Line 764: wf_engine.SetItemAttrText (itemtype => l_itemtype,

760: else
761: l_doc_num_rel := l_docNumber;
762: end if;
763: if l_doc_num_rel is not null then
764: wf_engine.SetItemAttrText (itemtype => l_itemtype,
765: itemkey => l_itemkey,
766: aname => 'DOCUMENT_NUM_REL',
767: avalue => l_doc_num_rel);
768: end if;

Line 778: wf_engine.SetItemAttrText (itemtype => l_itemtype,

774:
775: END IF;
776:
777:
778: wf_engine.SetItemAttrText (itemtype => l_itemtype,
779: itemkey => l_itemkey,
780: aname => 'DOCUMENT_DISPLAY_NAME',
781: avalue => l_doc_display_name );
782: -- Bug # 3290385 End

Line 907: wf_engine. StartProcess (itemtype => l_itemtype, itemkey => l_itemkey);

903: IF (g_po_wf_debug = 'Y') THEN
904: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);
905: END IF;
906:
907: wf_engine. StartProcess (itemtype => l_itemtype, itemkey => l_itemkey);
908:
909:
910: EXCEPTION
911: WHEN OTHERS THEN

Line 1248: IF (funcmode <> wf_engine.eng_run)

1244: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1245: END IF;
1246:
1247: -- : Do nothing in cancel or timeout modes.
1248: IF (funcmode <> wf_engine.eng_run)
1249: THEN
1250: resultout := wf_engine.eng_null;
1251: return;
1252: END IF;

Line 1250: resultout := wf_engine.eng_null;

1246:
1247: -- : Do nothing in cancel or timeout modes.
1248: IF (funcmode <> wf_engine.eng_run)
1249: THEN
1250: resultout := wf_engine.eng_null;
1251: return;
1252: END IF;
1253: --
1254:

Line 3117: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3113: IF (g_po_wf_debug = 'Y') THEN
3114: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3115: END IF;
3116:
3117: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3118: itemkey => l_itemkey,
3119: aname => 'DOCUMENT_ID');
3120:
3121: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3121: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3117: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3118: itemkey => l_itemkey,
3119: aname => 'DOCUMENT_ID');
3120:
3121: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3122: itemkey => l_itemkey,
3123: aname => 'ORG_ID');
3124:
3125: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3125: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3121: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3122: itemkey => l_itemkey,
3123: aname => 'ORG_ID');
3124:
3125: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3126: itemkey => l_itemkey,
3127: aname => 'DOCUMENT_TYPE');
3128:
3129: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3129: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3125: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3126: itemkey => l_itemkey,
3127: aname => 'DOCUMENT_TYPE');
3128:
3129: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3130: itemkey => l_itemkey,
3131: aname => 'LANGUAGE_CODE');
3132:
3133: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3133: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3129: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3130: itemkey => l_itemkey,
3131: aname => 'LANGUAGE_CODE');
3132:
3133: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3134: itemkey => l_itemkey,
3135: aname => 'REVISION_NUMBER');
3136:
3137: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3137: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3133: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3134: itemkey => l_itemkey,
3135: aname => 'REVISION_NUMBER');
3136:
3137: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3138: itemkey => l_itemkey,
3139: aname => 'WITH_TERMS');
3140:
3141:

Line 3233: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3229: IF (g_po_wf_debug = 'Y') THEN
3230: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3231: END IF;
3232:
3233: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3234: itemkey => l_itemkey,
3235: aname => 'DOCUMENT_ID');
3236:
3237: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3237: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3233: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3234: itemkey => l_itemkey,
3235: aname => 'DOCUMENT_ID');
3236:
3237: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3238: itemkey => l_itemkey,
3239: aname => 'ORG_ID');
3240:
3241: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3241: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3237: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3238: itemkey => l_itemkey,
3239: aname => 'ORG_ID');
3240:
3241: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3242: itemkey => l_itemkey,
3243: aname => 'DOCUMENT_TYPE');
3244:
3245: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3245: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3241: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3242: itemkey => l_itemkey,
3243: aname => 'DOCUMENT_TYPE');
3244:
3245: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3246: itemkey => l_itemkey,
3247: aname => 'LANGUAGE_CODE');
3248:
3249: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3249: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3245: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3246: itemkey => l_itemkey,
3247: aname => 'LANGUAGE_CODE');
3248:
3249: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3250: itemkey => l_itemkey,
3251: aname => 'REVISION_NUMBER');
3252:
3253: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3253: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3249: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3250: itemkey => l_itemkey,
3251: aname => 'REVISION_NUMBER');
3252:
3253: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3254: itemkey => l_itemkey,
3255: aname => 'WITH_TERMS');
3256:
3257: IF l_withTerms ='Y' THEN

Line 3347: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3343: IF (g_po_wf_debug = 'Y') THEN
3344: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3345: END IF;
3346:
3347: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3348: itemkey => l_itemkey,
3349: aname => 'DOCUMENT_ID');
3350:
3351: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3351: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3347: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3348: itemkey => l_itemkey,
3349: aname => 'DOCUMENT_ID');
3350:
3351: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3352: itemkey => l_itemkey,
3353: aname => 'ORG_ID');
3354:
3355: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3355: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3351: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3352: itemkey => l_itemkey,
3353: aname => 'ORG_ID');
3354:
3355: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3356: itemkey => l_itemkey,
3357: aname => 'DOCUMENT_TYPE');
3358:
3359: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3359: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3355: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3356: itemkey => l_itemkey,
3357: aname => 'DOCUMENT_TYPE');
3358:
3359: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3360: itemkey => l_itemkey,
3361: aname => 'LANGUAGE_CODE');
3362:
3363: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3363: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3359: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3360: itemkey => l_itemkey,
3361: aname => 'LANGUAGE_CODE');
3362:
3363: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3364: itemkey => l_itemkey,
3365: aname => 'REVISION_NUMBER');
3366:
3367: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3367: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3363: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3364: itemkey => l_itemkey,
3365: aname => 'REVISION_NUMBER');
3366:
3367: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3368: itemkey => l_itemkey,
3369: aname => 'WITH_TERMS');
3370:
3371: if l_withTerms ='Y' then

Line 3708: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3704: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,l_progress);
3705: END IF;
3706:
3707: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Get item attributes';
3708: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3709: itemkey => l_itemkey,
3710: aname => 'DOCUMENT_ID');
3711:
3712: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3712: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3708: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3709: itemkey => l_itemkey,
3710: aname => 'DOCUMENT_ID');
3711:
3712: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3713: itemkey => l_itemkey,
3714: aname => 'ORG_ID');
3715:
3716: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3716: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3712: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3713: itemkey => l_itemkey,
3714: aname => 'ORG_ID');
3715:
3716: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3717: itemkey => l_itemkey,
3718: aname => 'DOCUMENT_TYPE');
3719:
3720: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3720: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3716: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3717: itemkey => l_itemkey,
3718: aname => 'DOCUMENT_TYPE');
3719:
3720: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3721: itemkey => l_itemkey,
3722: aname => 'LANGUAGE_CODE');
3723:
3724: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3724: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3720: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3721: itemkey => l_itemkey,
3722: aname => 'LANGUAGE_CODE');
3723:
3724: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3725: itemkey => l_itemkey,
3726: aname => 'REVISION_NUMBER');
3727:
3728: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Decide Entity to query';

Line 3871: resultout := wf_engine.eng_completed || ':' ||resultout;

3867: resultout := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
3868: itemkey => itemkey,
3869: aname => 'ZIP_ERROR_CODE');
3870: l_progress := 'PO_COMMUNICATION_PVT.get_zip_error_code: 02';
3871: resultout := wf_engine.eng_completed || ':' ||resultout;
3872: EXCEPTION when others THEN
3873: WF_CORE.context('PO_COMMUNICATION_PVT', 'get_zip_error_code', l_progress);
3874: raise;
3875: END get_zip_error_code;