DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on WF_ENGINE

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

210: END IF;
211:
212: --Start of code changes for the bug 12403413
213: -- Do nothing in cancel or timeout modes. Similar to the bug 4100416
214: IF (funcmode <> wf_engine.eng_run)
215: THEN
216: resultout := wf_engine.eng_null;
217: return;
218: END IF;

Line 216: resultout := wf_engine.eng_null;

212: --Start of code changes for the bug 12403413
213: -- Do nothing in cancel or timeout modes. Similar to the bug 4100416
214: IF (funcmode <> wf_engine.eng_run)
215: THEN
216: resultout := wf_engine.eng_null;
217: return;
218: END IF;
219: --End of code changes for the bug 12403413
220:

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

402: END IF;
403:
404:
405: -- : Do nothing in cancel or timeout modes.
406: IF (funcmode <> wf_engine.eng_run)
407: THEN
408: resultout := wf_engine.eng_null;
409: return;
410: END IF;

Line 408: resultout := wf_engine.eng_null;

404:
405: -- : Do nothing in cancel or timeout modes.
406: IF (funcmode <> wf_engine.eng_run)
407: THEN
408: resultout := wf_engine.eng_null;
409: return;
410: END IF;
411: --
412:

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

431:
432: IF PO_COMMUNICATION_PROFILE = 'T' THEN
433: IF l_document_type in ('PO', 'PA') and l_document_subtype in ('STANDARD', 'BLANKET', 'CONTRACT')
434: or (l_document_type = 'RELEASE' and l_document_subtype = 'BLANKET' ) THEN
435: resultout := wf_engine.eng_completed || ':' || 'Y';
436: ELSE
437: resultout := wf_engine.eng_completed || ':' || 'N';
438: END IF;
439:

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

433: IF l_document_type in ('PO', 'PA') and l_document_subtype in ('STANDARD', 'BLANKET', 'CONTRACT')
434: or (l_document_type = 'RELEASE' and l_document_subtype = 'BLANKET' ) THEN
435: resultout := wf_engine.eng_completed || ':' || 'Y';
436: ELSE
437: resultout := wf_engine.eng_completed || ':' || 'N';
438: END IF;
439:
440: Else
441: resultout := wf_engine.eng_completed || ':' || 'N';

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

437: resultout := wf_engine.eng_completed || ':' || 'N';
438: END IF;
439:
440: Else
441: resultout := wf_engine.eng_completed || ':' || 'N';
442: END IF;
443:
444: EXCEPTION
445:

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

476: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
477: END IF;
478:
479: -- : Do nothing in cancel or timeout modes.
480: IF (funcmode <> wf_engine.eng_run)
481: THEN
482: resultout := wf_engine.eng_null;
483: return;
484: END IF;

Line 482: resultout := wf_engine.eng_null;

478:
479: -- : Do nothing in cancel or timeout modes.
480: IF (funcmode <> wf_engine.eng_run)
481: THEN
482: resultout := wf_engine.eng_null;
483: return;
484: END IF;
485: --
486:

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

678: END ;
679:
680:
681: IF l_count >0 THEN
682: resultout := wf_engine.eng_completed || ':' || 'Y';
683: Else
684: resultout := wf_engine.eng_completed || ':' || 'N';
685: End if;
686:

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

680:
681: IF l_count >0 THEN
682: resultout := wf_engine.eng_completed || ':' || 'Y';
683: Else
684: resultout := wf_engine.eng_completed || ':' || 'N';
685: End if;
686:
687: EXCEPTION
688: When others then

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

690: IF (g_po_wf_debug = 'Y') THEN
691: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
692: END IF;
693: wf_core.context('PO_COMMUNICATION_PVT', 'PO_PDF_EXISTS', x_progress);
694: resultout := wf_engine.eng_completed || ':' || 'N';
695: raise;
696:
697: END PO_PDF_EXISTS;
698:

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

761:
762:
763: l_workflow_process := 'EMAIL_PO_PDF';
764:
765: wf_engine.CreateProcess(ItemType => l_itemtype,
766: ItemKey => l_itemkey,
767: process => l_workflow_process );
768:
769:

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

848: select segment1, global_agreement_flag into l_docNumber, l_ga_flag
849: from po_headers_all
850: where po_header_id = l_document_id;
851:
852: wf_engine.SetItemAttrText (itemtype => l_itemtype,
853: itemkey => l_itemkey,
854: aname => 'DOCUMENT_NUMBER',
855: avalue => l_docNumber);
856:

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

869: else
870: l_doc_num_rel := l_docNumber;
871: end if;
872: if l_doc_num_rel is not null then
873: wf_engine.SetItemAttrText (itemtype => l_itemtype,
874: itemkey => l_itemkey,
875: aname => 'DOCUMENT_NUM_REL',
876: avalue => l_doc_num_rel);
877: end if;

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

883:
884: END IF;
885:
886:
887: wf_engine.SetItemAttrText (itemtype => l_itemtype,
888: itemkey => l_itemkey,
889: aname => 'DOCUMENT_DISPLAY_NAME',
890: avalue => l_doc_display_name );
891: -- Bug # 3290385 End

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

1048: IF (g_po_wf_debug = 'Y') THEN
1049: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);
1050: END IF;
1051:
1052: wf_engine. StartProcess (itemtype => l_itemtype, itemkey => l_itemkey);
1053:
1054:
1055: EXCEPTION
1056: WHEN OTHERS THEN

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

1104: END IF;
1105:
1106: --Start of code changes for the bug 12403413
1107: -- Do nothing in cancel or timeout modes. Similar to the bug 4100416
1108: IF (funcmode <> wf_engine.eng_run)
1109: THEN
1110: resultout := wf_engine.eng_null;
1111: return;
1112: END IF;

Line 1110: resultout := wf_engine.eng_null;

1106: --Start of code changes for the bug 12403413
1107: -- Do nothing in cancel or timeout modes. Similar to the bug 4100416
1108: IF (funcmode <> wf_engine.eng_run)
1109: THEN
1110: resultout := wf_engine.eng_null;
1111: return;
1112: END IF;
1113: --End of code changes for the bug 12403413
1114:

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

1464: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, l_progress);
1465: END IF;
1466:
1467: -- : Do nothing in cancel or timeout modes.
1468: IF (funcmode <> wf_engine.eng_run)
1469: THEN
1470: resultout := wf_engine.eng_null;
1471: return;
1472: END IF;

Line 1470: resultout := wf_engine.eng_null;

1466:
1467: -- : Do nothing in cancel or timeout modes.
1468: IF (funcmode <> wf_engine.eng_run)
1469: THEN
1470: resultout := wf_engine.eng_null;
1471: return;
1472: END IF;
1473: --
1474:

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

1927: END IF;
1928:
1929: --Start of code changes for the bug 12403413
1930: -- Do nothing in cancel or timeout modes. Similar to the bug 4100416
1931: IF (funcmode <> wf_engine.eng_run)
1932: THEN
1933: resultout := wf_engine.eng_null;
1934: return;
1935: END IF;

Line 1933: resultout := wf_engine.eng_null;

1929: --Start of code changes for the bug 12403413
1930: -- Do nothing in cancel or timeout modes. Similar to the bug 4100416
1931: IF (funcmode <> wf_engine.eng_run)
1932: THEN
1933: resultout := wf_engine.eng_null;
1934: return;
1935: END IF;
1936: --End of code changes for the bug 12403413
1937:

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

3540: IF (g_po_wf_debug = 'Y') THEN
3541: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, x_progress);
3542: END IF;
3543:
3544: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3545: itemkey => l_itemkey,
3546: aname => 'DOCUMENT_ID');
3547:
3548: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

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

3544: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3545: itemkey => l_itemkey,
3546: aname => 'DOCUMENT_ID');
3547:
3548: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3549: itemkey => l_itemkey,
3550: aname => 'ORG_ID');
3551:
3552: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

3548: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3549: itemkey => l_itemkey,
3550: aname => 'ORG_ID');
3551:
3552: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3553: itemkey => l_itemkey,
3554: aname => 'DOCUMENT_TYPE');
3555:
3556: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

3552: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3553: itemkey => l_itemkey,
3554: aname => 'DOCUMENT_TYPE');
3555:
3556: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3557: itemkey => l_itemkey,
3558: aname => 'LANGUAGE_CODE');
3559:
3560: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

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

3556: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3557: itemkey => l_itemkey,
3558: aname => 'LANGUAGE_CODE');
3559:
3560: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3561: itemkey => l_itemkey,
3562: aname => 'REVISION_NUMBER');
3563:
3564: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

3560: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3561: itemkey => l_itemkey,
3562: aname => 'REVISION_NUMBER');
3563:
3564: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3565: itemkey => l_itemkey,
3566: aname => 'WITH_TERMS');
3567:
3568: l_draft_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3568: l_draft_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3564: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3565: itemkey => l_itemkey,
3566: aname => 'WITH_TERMS');
3567:
3568: l_draft_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3569: itemkey => l_itemkey,
3570: aname => 'DRAFT_ID');
3571:
3572: /* Bug 7424634

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

3706: IF (g_po_wf_debug = 'Y') THEN
3707: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, x_progress);
3708: END IF;
3709:
3710: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3711: itemkey => l_itemkey,
3712: aname => 'DOCUMENT_ID');
3713:
3714: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

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

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

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

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

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

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

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

3722: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3723: itemkey => l_itemkey,
3724: aname => 'LANGUAGE_CODE');
3725:
3726: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3727: itemkey => l_itemkey,
3728: aname => 'REVISION_NUMBER');
3729:
3730: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

3726: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3727: itemkey => l_itemkey,
3728: aname => 'REVISION_NUMBER');
3729:
3730: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3731: itemkey => l_itemkey,
3732: aname => 'WITH_TERMS');
3733:
3734: IF l_withTerms = 'Y' THEN

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

3823: IF (g_po_wf_debug = 'Y') THEN
3824: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, x_progress);
3825: END IF;
3826:
3827: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3828: itemkey => l_itemkey,
3829: aname => 'DOCUMENT_ID');
3830:
3831: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

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

3827: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3828: itemkey => l_itemkey,
3829: aname => 'DOCUMENT_ID');
3830:
3831: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3832: itemkey => l_itemkey,
3833: aname => 'ORG_ID');
3834:
3835: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

3831: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3832: itemkey => l_itemkey,
3833: aname => 'ORG_ID');
3834:
3835: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3836: itemkey => l_itemkey,
3837: aname => 'DOCUMENT_TYPE');
3838:
3839: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

3835: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3836: itemkey => l_itemkey,
3837: aname => 'DOCUMENT_TYPE');
3838:
3839: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3840: itemkey => l_itemkey,
3841: aname => 'LANGUAGE_CODE');
3842:
3843: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

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

3839: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3840: itemkey => l_itemkey,
3841: aname => 'LANGUAGE_CODE');
3842:
3843: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3844: itemkey => l_itemkey,
3845: aname => 'REVISION_NUMBER');
3846:
3847: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

3843: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3844: itemkey => l_itemkey,
3845: aname => 'REVISION_NUMBER');
3846:
3847: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3848: itemkey => l_itemkey,
3849: aname => 'WITH_TERMS');
3850:
3851: l_draft_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3851: l_draft_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

3847: l_withTerms := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3848: itemkey => l_itemkey,
3849: aname => 'WITH_TERMS');
3850:
3851: l_draft_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3852: itemkey => l_itemkey,
3853: aname => 'DRAFT_ID');
3854:
3855: /* Bug 13330239. Below block of code is common for both With and Without contract terms */

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

4258: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, l_progress);
4259: END IF;
4260:
4261: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Get item attributes';
4262: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
4263: itemkey => l_itemkey,
4264: aname => 'DOCUMENT_ID');
4265:
4266: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

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

4262: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
4263: itemkey => l_itemkey,
4264: aname => 'DOCUMENT_ID');
4265:
4266: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
4267: itemkey => l_itemkey,
4268: aname => 'ORG_ID');
4269:
4270: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

4266: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
4267: itemkey => l_itemkey,
4268: aname => 'ORG_ID');
4269:
4270: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
4271: itemkey => l_itemkey,
4272: aname => 'DOCUMENT_TYPE');
4273:
4274: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,

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

4270: l_document_type := wf_engine.GetItemAttrText (itemtype => l_itemtype,
4271: itemkey => l_itemkey,
4272: aname => 'DOCUMENT_TYPE');
4273:
4274: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
4275: itemkey => l_itemkey,
4276: aname => 'LANGUAGE_CODE');
4277:
4278: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

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

4274: l_language := wf_engine.GetItemAttrText (itemtype => l_itemtype,
4275: itemkey => l_itemkey,
4276: aname => 'LANGUAGE_CODE');
4277:
4278: l_revision_number := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
4279: itemkey => l_itemkey,
4280: aname => 'REVISION_NUMBER');
4281:
4282: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Decide Entity to query';

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

4421: resultout := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4422: itemkey => itemkey,
4423: aname => 'ZIP_ERROR_CODE');
4424: l_progress := 'PO_COMMUNICATION_PVT.get_zip_error_code: 02';
4425: resultout := wf_engine.eng_completed || ':' || resultout;
4426: EXCEPTION when others THEN
4427: WF_CORE.context('PO_COMMUNICATION_PVT', 'get_zip_error_code', l_progress);
4428: raise;
4429: END get_zip_error_code;