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.PON_AWARD_APPROVAL_PKG dependencies on WF_ENGINE

Line 22: | Added call to wf_engine.SetItemOwner

18: | -------------------------------------------------------------------------------------------
19: | ? ? Created
20: |
21: | 25-Aug-05 sparames Bug 4295915: Missing owner in Sourcing notifications
22: | Added call to wf_engine.SetItemOwner
23: |
24: =========================================================================+*/
25:
26:

Line 388: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

384: l_document_number,
385: l_trading_partner_contact_name);
386:
387: -- set other core attributes
388: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
389: itemkey => p_item_key,
390: aname => 'AUCTION_HEADER_ID',
391: avalue => p_auction_header_id);
392:

Line 393: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

389: itemkey => p_item_key,
390: aname => 'AUCTION_HEADER_ID',
391: avalue => p_auction_header_id);
392:
393: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
394: itemkey => p_item_key,
395: aname => 'FIRST_AUTHORITY_APPROVER_ID',
396: avalue => p_first_authority_approver_id);
397:

Line 398: wf_engine.SetItemAttrText(itemtype => p_item_type,

394: itemkey => p_item_key,
395: aname => 'FIRST_AUTHORITY_APPROVER_ID',
396: avalue => p_first_authority_approver_id);
397:
398: wf_engine.SetItemAttrText(itemtype => p_item_type,
399: itemkey => p_item_key,
400: aname => 'AME_TRANSACTION_ID',
401: avalue => l_transaction_id);
402:

Line 403: wf_engine.SetItemAttrText(itemtype => p_item_type,

399: itemkey => p_item_key,
400: aname => 'AME_TRANSACTION_ID',
401: avalue => l_transaction_id);
402:
403: wf_engine.SetItemAttrText(itemtype => p_item_type,
404: itemkey => p_item_key,
405: aname => 'NOTE_TO_APPROVERS',
406: avalue => PON_AUCTION_PKG.replaceHtmlChars(p_note_to_approvers));
407:

Line 408: wf_engine.SetItemAttrText(itemtype => p_item_type,

404: itemkey => p_item_key,
405: aname => 'NOTE_TO_APPROVERS',
406: avalue => PON_AUCTION_PKG.replaceHtmlChars(p_note_to_approvers));
407:
408: wf_engine.SetItemAttrText(itemtype => p_item_type,
409: itemkey => p_item_key,
410: aname => 'AWARD_SUMMARY_URL',
411: avalue => PON_WF_UTL_PKG.get_dest_page_url('PON_AWARD_SUMM', 'BUYER'));
412:

Line 413: wf_engine.SetItemAttrText(itemtype => p_item_type,

409: itemkey => p_item_key,
410: aname => 'AWARD_SUMMARY_URL',
411: avalue => PON_WF_UTL_PKG.get_dest_page_url('PON_AWARD_SUMM', 'BUYER'));
412:
413: wf_engine.SetItemAttrText(itemtype => p_item_type,
414: itemkey => p_item_key,
415: aname => 'MESSAGE_SUFFIX',
416: avalue => l_msg_suffix);
417:

Line 418: wf_engine.SetItemAttrDate(itemtype => p_item_type,

414: itemkey => p_item_key,
415: aname => 'MESSAGE_SUFFIX',
416: avalue => l_msg_suffix);
417:
418: wf_engine.SetItemAttrDate(itemtype => p_item_type,
419: itemkey => p_item_key,
420: aname => 'OPEN_BIDDING_DATE',
421: avalue => l_open_bidding_date);
422:

Line 423: wf_engine.SetItemAttrDate(itemtype => p_item_type,

419: itemkey => p_item_key,
420: aname => 'OPEN_BIDDING_DATE',
421: avalue => l_open_bidding_date);
422:
423: wf_engine.SetItemAttrDate(itemtype => p_item_type,
424: itemkey => p_item_key,
425: aname => 'CLOSE_BIDDING_DATE',
426: avalue => l_close_bidding_date);
427:

Line 428: wf_engine.SetItemAttrDate(itemtype => p_item_type,

424: itemkey => p_item_key,
425: aname => 'CLOSE_BIDDING_DATE',
426: avalue => l_close_bidding_date);
427:
428: wf_engine.SetItemAttrDate(itemtype => p_item_type,
429: itemkey => p_item_key,
430: aname => 'AWARD_BY_DATE',
431: avalue => l_award_by_date);
432:

Line 433: wf_engine.SetItemAttrDate (itemtype => p_item_type,

429: itemkey => p_item_key,
430: aname => 'AWARD_BY_DATE',
431: avalue => l_award_by_date);
432:
433: wf_engine.SetItemAttrDate (itemtype => p_item_type,
434: itemkey => p_item_key,
435: aname => 'PREVIEW_DATE',
436: avalue => l_preview_date);
437:

Line 438: wf_engine.SetItemAttrText(itemtype => p_item_type,

434: itemkey => p_item_key,
435: aname => 'PREVIEW_DATE',
436: avalue => l_preview_date);
437:
438: wf_engine.SetItemAttrText(itemtype => p_item_type,
439: itemkey => p_item_key,
440: aname => 'ORIGIN_USER_NAME',
441: avalue => fnd_global.user_name);
442:

Line 485: l_msg_suffix := wf_engine.getItemAttrText(itemtype => p_item_type,

481: -- set the db session language
482: PON_PROFILE_UTIL_PKG.get_wf_language(p_user_name, l_language_code);
483: PON_AUCTION_PKG.set_session_language(null, l_language_code);
484:
485: l_msg_suffix := wf_engine.getItemAttrText(itemtype => p_item_type,
486: itemkey => p_item_key,
487: aname => 'MESSAGE_SUFFIX');
488:
489: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,

Line 489: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,

485: l_msg_suffix := wf_engine.getItemAttrText(itemtype => p_item_type,
486: itemkey => p_item_key,
487: aname => 'MESSAGE_SUFFIX');
488:
489: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,
490: itemkey => p_item_key,
491: aname => 'AUCTION_TITLE');
492:
493: l_document_number := wf_engine.getItemAttrText(itemtype => p_item_type,

Line 493: l_document_number := wf_engine.getItemAttrText(itemtype => p_item_type,

489: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,
490: itemkey => p_item_key,
491: aname => 'AUCTION_TITLE');
492:
493: l_document_number := wf_engine.getItemAttrText(itemtype => p_item_type,
494: itemkey => p_item_key,
495: aname => 'DOC_NUMBER');
496:
497: -- set the notification subject

Line 502: wf_engine.SetItemAttrText(itemtype => p_item_type,

498: IF p_notification_type = APPROVAL_REQUEST THEN
499: -- if the notification type is APPROVAL_REQUEST
500: -- set the notification subject for the initial approval request notification
501: -- as well as the subject for the reminder notification
502: wf_engine.SetItemAttrText(itemtype => p_item_type,
503: itemkey => p_item_key,
504: aname => 'APPROVAL_REQUEST_SUBJECT',
505: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVAL_1',
506: l_msg_suffix,

Line 511: wf_engine.SetItemAttrText(itemtype => p_item_type,

507: 'DOC_NUMBER',
508: l_document_number,
509: 'DOC_TITLE',
510: l_auction_title));
511: wf_engine.SetItemAttrText(itemtype => p_item_type,
512: itemkey => p_item_key,
513: aname => 'REQUEST_REMINDER_SUBJECT',
514: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVAL_2',
515: l_msg_suffix,

Line 521: wf_engine.SetItemAttrText(itemtype => p_item_type,

517: l_document_number,
518: 'DOC_TITLE',
519: l_auction_title));
520: ELSIF p_notification_type = AWARD_APPROVED THEN
521: wf_engine.SetItemAttrText(itemtype => p_item_type,
522: itemkey => p_item_key,
523: aname => 'APPROVAL_SUBJECT',
524: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVED_1',
525: l_msg_suffix,

Line 531: wf_engine.SetItemAttrText(itemtype => p_item_type,

527: l_document_number,
528: 'DOC_TITLE',
529: l_auction_title));
530: ELSIF p_notification_type = AWARD_REJECTED THEN
531: wf_engine.SetItemAttrText(itemtype => p_item_type,
532: itemkey => p_item_key,
533: aname => 'REJECTION_SUBJECT',
534: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_REJECTED_1',
535: l_msg_suffix,

Line 541: wf_engine.SetItemAttrText(itemtype => p_item_type,

537: l_document_number,
538: 'DOC_TITLE',
539: l_auction_title));
540: ELSIF p_notification_type = ERROR THEN
541: wf_engine.SetItemAttrText(itemtype => p_item_type,
542: itemkey => p_item_key,
543: aname => 'ERROR_SUBJECT',
544: avalue => PON_AUCTION_PKG.getMessage('PON_AWARD_REJECTED_ERROR_1',
545: l_msg_suffix,

Line 551: wf_engine.SetItemAttrText(itemtype => p_item_type,

547: l_document_number,
548: 'DOC_TITLE',
549: l_auction_title));
550: ELSIF p_notification_type = ERROR_FOR_ADMIN THEN
551: wf_engine.SetItemAttrText(itemtype => p_item_type,
552: itemkey => p_item_key,
553: aname => 'ERROR_SUBJECT_FOR_ADMIN',
554: avalue => PON_AUCTION_PKG.getMessage('PON_AWARD_REJECTED_ERROR_2',
555: l_msg_suffix,

Line 567: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

563: -- to dates in the user's timezone
564: l_user_timezone := PON_AUCTION_PKG.get_time_zone(p_user_name);
565: l_server_timezone := PON_AUCTION_PKG.get_oex_time_zone;
566:
567: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
568: itemkey => p_item_key,
569: aname => 'OPEN_BIDDING_DATE');
570:
571: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

Line 571: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

567: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
568: itemkey => p_item_key,
569: aname => 'OPEN_BIDDING_DATE');
570:
571: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
572: itemkey => p_item_key,
573: aname => 'CLOSE_BIDDING_DATE');
574:
575: l_award_by_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

Line 575: l_award_by_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

571: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
572: itemkey => p_item_key,
573: aname => 'CLOSE_BIDDING_DATE');
574:
575: l_award_by_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
576: itemkey => p_item_key,
577: aname => 'AWARD_BY_DATE');
578:
579: IF p_set_approval_date THEN

Line 580: l_approval_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

576: itemkey => p_item_key,
577: aname => 'AWARD_BY_DATE');
578:
579: IF p_set_approval_date THEN
580: l_approval_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
581: itemkey => p_item_key,
582: aname => 'APPROVAL_DATE');
583: END IF;
584:

Line 586: l_rejection_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

582: aname => 'APPROVAL_DATE');
583: END IF;
584:
585: IF p_set_rejection_date THEN
586: l_rejection_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
587: itemkey => p_item_key,
588: aname => 'REJECTION_DATE');
589: END IF;
590:

Line 591: l_preview_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

587: itemkey => p_item_key,
588: aname => 'REJECTION_DATE');
589: END IF;
590:
591: l_preview_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
592: itemkey => p_item_key,
593: aname => 'PREVIEW_DATE');
594:
595: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN

Line 635: wf_engine.setItemAttrText(itemtype => p_item_type,

631: END IF;
632:
633: l_user_timezone_desc := PON_AUCTION_PKG.get_timezone_description(l_user_timezone, l_language_code);
634:
635: wf_engine.setItemAttrText(itemtype => p_item_type,
636: itemkey => p_item_key,
637: aname => 'USER_TIMEZONE',
638: avalue => l_user_timezone_desc);
639:

Line 640: wf_engine.setItemAttrDate(itemtype => p_item_type,

636: itemkey => p_item_key,
637: aname => 'USER_TIMEZONE',
638: avalue => l_user_timezone_desc);
639:
640: wf_engine.setItemAttrDate(itemtype => p_item_type,
641: itemkey => p_item_key,
642: aname => 'OPEN_BIDDING_DATE_TZ',
643: avalue => l_open_bidding_date_tz);
644:

Line 645: wf_engine.setItemAttrDate(itemtype => p_item_type,

641: itemkey => p_item_key,
642: aname => 'OPEN_BIDDING_DATE_TZ',
643: avalue => l_open_bidding_date_tz);
644:
645: wf_engine.setItemAttrDate(itemtype => p_item_type,
646: itemkey => p_item_key,
647: aname => 'CLOSE_BIDDING_DATE_TZ',
648: avalue => l_close_bidding_date_tz);
649:

Line 650: wf_engine.setItemAttrDate(itemtype => p_item_type,

646: itemkey => p_item_key,
647: aname => 'CLOSE_BIDDING_DATE_TZ',
648: avalue => l_close_bidding_date_tz);
649:
650: wf_engine.setItemAttrDate(itemtype => p_item_type,
651: itemkey => p_item_key,
652: aname => 'AWARD_BY_DATE_TZ',
653: avalue => l_award_by_date_tz);
654:

Line 659: wf_engine.setItemAttrText(itemtype => p_item_type,

655: -- if the award by date is not null, the timezone attribute associated with the date
656: -- must have the same value as the user's timezone attribute
657: -- otherwise, then the timezone attribute associated with the date must be null
658: IF l_award_by_date_tz IS NOT NULL THEN
659: wf_engine.setItemAttrText(itemtype => p_item_type,
660: itemkey => p_item_key,
661: aname => 'USER_TIMEZONE_AWARD_BY_DATE',
662: avalue => l_user_timezone_desc);
663: ELSE

Line 664: wf_engine.setItemAttrText(itemtype => p_item_type,

660: itemkey => p_item_key,
661: aname => 'USER_TIMEZONE_AWARD_BY_DATE',
662: avalue => l_user_timezone_desc);
663: ELSE
664: wf_engine.setItemAttrText(itemtype => p_item_type,
665: itemkey => p_item_key,
666: aname => 'USER_TIMEZONE_AWARD_BY_DATE',
667: avalue => NULL);
668: END IF;

Line 671: wf_engine.setItemAttrDate(itemtype => p_item_type,

667: avalue => NULL);
668: END IF;
669:
670: IF p_set_approval_date THEN
671: wf_engine.setItemAttrDate(itemtype => p_item_type,
672: itemkey => p_item_key,
673: aname => 'APPROVAL_DATE_TZ',
674: avalue => l_approval_date_tz);
675: END IF;

Line 678: wf_engine.setItemAttrDate(itemtype => p_item_type,

674: avalue => l_approval_date_tz);
675: END IF;
676:
677: IF p_set_rejection_date THEN
678: wf_engine.setItemAttrDate(itemtype => p_item_type,
679: itemkey => p_item_key,
680: aname => 'REJECTION_DATE_TZ',
681: avalue => l_rejection_date_tz);
682: END IF;

Line 685: wf_engine.SetItemAttrText (itemtype => p_item_type,

681: avalue => l_rejection_date_tz);
682: END IF;
683:
684: IF l_preview_date_tz IS NOT NULL THEN
685: wf_engine.SetItemAttrText (itemtype => p_item_type,
686: itemkey => p_item_key,
687: aname => 'TP_TIME_ZONE1',
688: avalue => l_user_timezone_desc);
689:

Line 690: wf_engine.SetItemAttrText (itemtype => p_item_type,

686: itemkey => p_item_key,
687: aname => 'TP_TIME_ZONE1',
688: avalue => l_user_timezone_desc);
689:
690: wf_engine.SetItemAttrText (itemtype => p_item_type,
691: itemkey => p_item_key,
692: aname => 'PREVIEW_DATE_NOTSPECIFIED',
693: avalue => null);
694: ELSE

Line 695: wf_engine.SetItemAttrText (itemtype => p_item_type,

691: itemkey => p_item_key,
692: aname => 'PREVIEW_DATE_NOTSPECIFIED',
693: avalue => null);
694: ELSE
695: wf_engine.SetItemAttrText (itemtype => p_item_type,
696: itemkey => p_item_key,
697: aname => 'TP_TIME_ZONE1',
698: avalue => null);
699:

Line 700: wf_engine.SetItemAttrText (itemtype => p_item_type,

696: itemkey => p_item_key,
697: aname => 'TP_TIME_ZONE1',
698: avalue => null);
699:
700: wf_engine.SetItemAttrText (itemtype => p_item_type,
701: itemkey => p_item_key,
702: aname => 'PREVIEW_DATE_NOTSPECIFIED',
703: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
704: END IF;

Line 733: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,

729: p_item_key IN VARCHAR2) IS
730: l_tp_contact_user_name VARCHAR2(100);
731: BEGIN
732:
733: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,
734: itemkey => p_item_key,
735: aname => 'PREPARER_TP_CONTACT_NAME');
736:
737: set_common_user_attributes(p_item_type,

Line 754: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,

750: p_item_key IN VARCHAR2) IS
751: l_tp_contact_user_name VARCHAR2(100);
752: BEGIN
753:
754: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,
755: itemkey => p_item_key,
756: aname => 'PREPARER_TP_CONTACT_NAME');
757:
758: set_common_user_attributes(p_item_type,

Line 775: l_approver_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,

771: p_item_key IN VARCHAR2) IS
772: l_approver_user_name VARCHAR2(100);
773: BEGIN
774:
775: l_approver_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,
776: itemkey => p_item_key,
777: aname => 'APPROVER_USER');
778:
779: -- reset notification's Respond attributes

Line 780: wf_engine.setItemAttrText(itemtype => p_item_type,

776: itemkey => p_item_key,
777: aname => 'APPROVER_USER');
778:
779: -- reset notification's Respond attributes
780: wf_engine.setItemAttrText(itemtype => p_item_type,
781: itemkey => p_item_key,
782: aname => 'APPROVER_FORWARDEE_USER',
783: avalue => NULL);
784:

Line 785: wf_engine.setItemAttrText(itemtype => p_item_type,

781: itemkey => p_item_key,
782: aname => 'APPROVER_FORWARDEE_USER',
783: avalue => NULL);
784:
785: wf_engine.setItemAttrText(itemtype => p_item_type,
786: itemkey => p_item_key,
787: aname => 'NOTE_TO_BUYER',
788: avalue => NULL);
789:

Line 791: wf_engine.SetItemAttrDate(itemtype => p_item_type,

787: aname => 'NOTE_TO_BUYER',
788: avalue => NULL);
789:
790: -- reset approval-related attributes
791: wf_engine.SetItemAttrDate(itemtype => p_item_type,
792: itemkey => p_item_key,
793: aname => 'APPROVAL_DATE',
794: avalue => NULL);
795:

Line 796: wf_engine.SetItemAttrDate(itemtype => p_item_type,

792: itemkey => p_item_key,
793: aname => 'APPROVAL_DATE',
794: avalue => NULL);
795:
796: wf_engine.SetItemAttrDate(itemtype => p_item_type,
797: itemkey => p_item_key,
798: aname => 'REJECTION_DATE',
799: avalue => NULL);
800:

Line 823: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

819: l_tp_contact_user_id NUMBER;
820: l_tp_contact_user_name VARCHAR2(100);
821: BEGIN
822:
823: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
824: itemkey => itemkey,
825: aname => 'AUCTION_HEADER_ID');
826:
827: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 827: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

823: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
824: itemkey => itemkey,
825: aname => 'AUCTION_HEADER_ID');
826:
827: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
828: itemkey => itemkey,
829: aname => 'AME_TRANSACTION_ID');
830:
831: l_tp_contact_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 831: l_tp_contact_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

827: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
828: itemkey => itemkey,
829: aname => 'AME_TRANSACTION_ID');
830:
831: l_tp_contact_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,
832: itemkey => itemkey,
833: aname => 'PREPARER_TP_CONTACT_NAME');
834:
835: SELECT user_id

Line 894: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

890: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
891: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
892: BEGIN
893:
894: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
895: itemkey => itemkey,
896: aname => 'AME_TRANSACTION_ID');
897: l_success_flag := TRUE;
898:

Line 919: wf_engine.SetItemAttrText(itemtype => itemtype,

915:
916: -- if the OAM API call raises an exception,
917: -- set the Application Error and OAM Error workflow attributes
918: -- this message is internal and can be seen only by the OAM administrator
919: wf_engine.SetItemAttrText(itemtype => itemtype,
920: itemkey => itemkey,
921: aname => 'OAM_ERROR',
922: avalue => SQLERRM);
923:

Line 925: wf_engine.SetItemAttrText(itemtype => itemtype,

921: aname => 'OAM_ERROR',
922: avalue => SQLERRM);
923:
924: -- this message can be seen by any buyer
925: wf_engine.SetItemAttrText(itemtype => itemtype,
926: itemkey => itemkey,
927: aname => 'APPLICATION_ERROR',
928: avalue => PON_AUCTION_PKG.getMessage('PON_OAM_ERROR_OCCURRED'));
929:

Line 939: wf_engine.SetItemAttrText(itemtype => itemtype,

935: resultout := 'OAM_API_ERROR';
936: l_success_flag := FALSE;
937:
938: -- this message can be seen only by admin.
939: wf_engine.SetItemAttrText(itemtype => itemtype,
940: itemkey => itemkey,
941: aname => 'OAM_ERROR',
942: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
943:

Line 945: wf_engine.SetItemAttrText(itemtype => itemtype,

941: aname => 'OAM_ERROR',
942: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
943:
944: -- this message can be seen by any buyer.
945: wf_engine.SetItemAttrText(itemtype => itemtype,
946: itemkey => itemkey,
947: aname => 'APPLICATION_ERROR',
948: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
949:

Line 974: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

970: ruleIdListOut => l_idList);
971:
972: IF( l_next_approver.api_insertion = ame_util.apiAuthorityInsertion AND
973: l_source_type_out <> ame_util.forwardeeSource ) THEN
974: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
975: itemkey => itemkey,
976: aname => 'FIRST_AUTHORITY_APPROVER_ID');
977: END IF;
978: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN

Line 1002: wf_engine.SetItemAttrText(itemtype => itemtype,

998: resultout := 'OAM_API_ERROR';
999: l_success_flag := FALSE;
1000:
1001: -- this message can be seen only by admin.
1002: wf_engine.SetItemAttrText(itemtype => itemtype,
1003: itemkey => itemkey,
1004: aname => 'OAM_ERROR',
1005: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1006:

Line 1008: wf_engine.SetItemAttrText(itemtype => itemtype,

1004: aname => 'OAM_ERROR',
1005: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1006:
1007: -- this message can be seen by any buyer.
1008: wf_engine.SetItemAttrText(itemtype => itemtype,
1009: itemkey => itemkey,
1010: aname => 'APPLICATION_ERROR',
1011: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1012:

Line 1033: wf_engine.SetItemAttrText(itemtype => itemtype,

1029: -- if next approver is valid
1030: IF l_next_approver_employee.user_id IS NOT NULL AND l_next_approver_employee.person_id IS NOT NULL THEN
1031:
1032: -- set the approver username attribute
1033: wf_engine.SetItemAttrText(itemtype => itemtype,
1034: itemkey => itemkey,
1035: aname => 'APPROVER_USER',
1036: avalue => l_next_approver_employee.user_name);
1037:

Line 1041: wf_engine.SetItemAttrText(itemtype => itemtype,

1037:
1038: l_next_approver_string := format_ame_approver(l_next_approver);
1039:
1040: -- set the approver record string atttribute
1041: wf_engine.SetItemAttrText(itemtype => itemtype,
1042: itemkey => itemkey,
1043: aname => 'APPROVER_STRING',
1044: avalue => l_next_approver_string);
1045:

Line 1050: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1046: -- set attributes specific to approval request notification
1047: set_notify_approver_attributes(itemtype, itemkey);
1048:
1049: -- get the auction header id workflow attribute
1050: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1051: itemkey => itemkey,
1052: aname => 'AUCTION_HEADER_ID');
1053:
1054: -- record that approval response is pending for this approver

Line 1076: wf_engine.SetItemAttrText(itemtype => itemtype,

1072: l_next_approver_name := get_display_name_for_person(l_next_approver.orig_system_id);
1073: ELSE
1074: l_next_approver_name := get_display_name_for_user(l_next_approver.orig_system_id);
1075: END IF;
1076: wf_engine.SetItemAttrText(itemtype => itemtype,
1077: itemkey => itemkey,
1078: aname => 'APPLICATION_ERROR',
1079: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_NEXT_APPROVER',
1080: NULL,

Line 1109: wf_engine.SetItemAttrDate(itemtype => itemtype,

1105:
1106: -- set rejection date attribute
1107: l_error_date := SYSDATE;
1108:
1109: wf_engine.SetItemAttrDate(itemtype => itemtype,
1110: itemkey => itemkey,
1111: aname => 'REJECTION_DATE',
1112: avalue => l_error_date);
1113:

Line 1115: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => itemtype,

1111: aname => 'REJECTION_DATE',
1112: avalue => l_error_date);
1113:
1114: -- set attributes specific to OAM error notification
1115: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => itemtype,
1116: itemkey => itemkey,
1117: aname => 'PREPARER_TP_CONTACT_NAME');
1118:
1119: set_common_user_attributes(itemtype,

Line 1126: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1122: ERROR,
1123: FALSE,
1124: TRUE);
1125:
1126: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'AUCTION_HEADER_ID');
1129:
1130: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1130: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1126: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'AUCTION_HEADER_ID');
1129:
1130: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1131: itemkey => itemkey,
1132: aname => 'AME_TRANSACTION_ID');
1133:
1134: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1134: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,

1130: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1131: itemkey => itemkey,
1132: aname => 'AME_TRANSACTION_ID');
1133:
1134: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,
1135: itemkey => itemkey,
1136: aname => 'APPLICATION_ERROR');
1137:
1138: SELECT user_id

Line 1172: IF wf_engine.GetItemAttrText(itemtype => itemtype,

1168: funcmode IN VARCHAR2,
1169: resultout OUT NOCOPY VARCHAR2) IS
1170: BEGIN
1171:
1172: IF wf_engine.GetItemAttrText(itemtype => itemtype,
1173: itemkey => itemkey,
1174: aname => 'OAM_ERROR') <> 'NO' THEN
1175: resultout := 'Y';
1176: ELSE

Line 1232: wf_engine.setItemAttrText(itemtype => itemtype,

1228:
1229: -- if the OAM administrator could be determined
1230: IF l_oam_admin_user_name IS NOT NULL THEN
1231: -- set OAM Administrator attribute
1232: wf_engine.setItemAttrText(itemtype => itemtype,
1233: itemkey => itemkey,
1234: aname => 'OAM_ADMIN_USER',
1235: avalue => l_oam_admin_user_name);
1236:

Line 1266: IF wf_engine.GetItemAttrDate(itemtype => itemtype,

1262: l_transaction_id VARCHAR2(80);
1263: BEGIN
1264:
1265: -- if the rejection date is null, set it to the current date
1266: IF wf_engine.GetItemAttrDate(itemtype => itemtype,
1267: itemkey => itemkey,
1268: aname => 'REJECTION_DATE') IS NULL THEN
1269: wf_engine.SetItemAttrDate(itemtype => itemtype,
1270: itemkey => itemkey,

Line 1269: wf_engine.SetItemAttrDate(itemtype => itemtype,

1265: -- if the rejection date is null, set it to the current date
1266: IF wf_engine.GetItemAttrDate(itemtype => itemtype,
1267: itemkey => itemkey,
1268: aname => 'REJECTION_DATE') IS NULL THEN
1269: wf_engine.SetItemAttrDate(itemtype => itemtype,
1270: itemkey => itemkey,
1271: aname => 'REJECTION_DATE',
1272: avalue => SYSDATE);
1273: END IF;

Line 1278: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1274:
1275: -- set attributes specific to award rejected notification
1276: set_award_rejected_attributes(itemtype, itemkey);
1277:
1278: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1279: itemkey => itemkey,
1280: aname => 'AUCTION_HEADER_ID');
1281:
1282: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1282: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1278: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1279: itemkey => itemkey,
1280: aname => 'AUCTION_HEADER_ID');
1281:
1282: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'AME_TRANSACTION_ID');
1285:
1286: -- change the approval status of the transaction to REJECTED

Line 1310: l_approval_date := wf_engine.GetItemAttrDate(itemtype => itemtype,

1306: l_approval_date DATE;
1307: BEGIN
1308:
1309: -- if the approval date is null, set it to the current date
1310: l_approval_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
1311: itemkey => itemkey,
1312: aname => 'APPROVAL_DATE');
1313:
1314: IF l_approval_date IS NULL THEN

Line 1317: wf_engine.SetItemAttrDate(itemtype => itemtype,

1313:
1314: IF l_approval_date IS NULL THEN
1315: l_approval_date := SYSDATE;
1316:
1317: wf_engine.SetItemAttrDate(itemtype => itemtype,
1318: itemkey => itemkey,
1319: aname => 'APPROVAL_DATE',
1320: avalue => l_approval_date);
1321: END IF;

Line 1326: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1322:
1323: -- set attributes specific to award approved notification
1324: set_award_approved_attributes(itemtype, itemkey);
1325:
1326: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1327: itemkey => itemkey,
1328: aname => 'AUCTION_HEADER_ID');
1329:
1330: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1330: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1326: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1327: itemkey => itemkey,
1328: aname => 'AUCTION_HEADER_ID');
1329:
1330: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => 'AME_TRANSACTION_ID');
1333:
1334: -- record that document as been approved (by all required approvers, if any)

Line 1391: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,

1387: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1388: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1389: BEGIN
1390:
1391: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1392: itemkey => itemkey,
1393: aname => 'RESULT');
1394:
1395: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1395: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1391: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1392: itemkey => itemkey,
1393: aname => 'RESULT');
1394:
1395: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1396: itemkey => itemkey,
1397: aname => 'AUCTION_HEADER_ID');
1398:
1399: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1399: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1395: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1396: itemkey => itemkey,
1397: aname => 'AUCTION_HEADER_ID');
1398:
1399: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1400: itemkey => itemkey,
1401: aname => 'AME_TRANSACTION_ID');
1402:
1403: l_approver_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1403: l_approver_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

1399: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1400: itemkey => itemkey,
1401: aname => 'AME_TRANSACTION_ID');
1402:
1403: l_approver_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,
1404: itemkey => itemkey,
1405: aname => 'APPROVER_USER');
1406:
1407: -- get the note to buyer attribute

Line 1408: l_note_to_buyer := wf_engine.GetItemAttrText(itemtype => itemtype,

1404: itemkey => itemkey,
1405: aname => 'APPROVER_USER');
1406:
1407: -- get the note to buyer attribute
1408: l_note_to_buyer := wf_engine.GetItemAttrText(itemtype => itemtype,
1409: itemkey => itemkey,
1410: aname => 'NOTE_TO_BUYER');
1411:
1412: l_response_date := SYSDATE;

Line 1426: l_approver_string := wf_engine.GetItemAttrText( itemtype => itemtype,

1422: l_action_type := 'AWARD_APPROVE_AND_FORWARD';
1423: END IF;
1424:
1425:
1426: l_approver_string := wf_engine.GetItemAttrText( itemtype => itemtype,
1427: itemkey => itemkey,
1428: aname => 'APPROVER_STRING');
1429:
1430: log_string( l_statement_log_level,

Line 1465: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1461: ruleIdListOut => l_idList);
1462:
1463: IF( l_approver.api_insertion = ame_util.apiAuthorityInsertion AND
1464: l_source_type_out <> ame_util.forwardeeSource ) THEN
1465: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1466: itemkey => itemkey,
1467: aname => 'FIRST_AUTHORITY_APPROVER_ID');
1468: END IF;
1469: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN

Line 1492: wf_engine.SetItemAttrText( itemtype => itemtype,

1488: resultout := 'OAM_API_ERROR';
1489: l_success_flag := FALSE;
1490:
1491: -- this message can be seen only by admin.
1492: wf_engine.SetItemAttrText( itemtype => itemtype,
1493: itemkey => itemkey,
1494: aname => 'OAM_ERROR',
1495: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1496:

Line 1498: wf_engine.SetItemAttrText( itemtype => itemtype,

1494: aname => 'OAM_ERROR',
1495: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1496:
1497: -- this message can be seen by any buyer.
1498: wf_engine.SetItemAttrText( itemtype => itemtype,
1499: itemkey => itemkey,
1500: aname => 'APPLICATION_ERROR',
1501: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1502:

Line 1533: wf_engine.SetItemAttrDate(itemtype => itemtype,

1529: l_approver_employee.user_id);
1530:
1531: -- set the appropriate attributes depending on response type
1532: IF l_response_type IN ('APPROVE', 'APPROVE_AND_FORWARD') THEN
1533: wf_engine.SetItemAttrDate(itemtype => itemtype,
1534: itemkey => itemkey,
1535: aname => 'APPROVAL_DATE',
1536: avalue => l_response_date);
1537: ELSIF l_response_type = 'REJECT' THEN

Line 1538: wf_engine.SetItemAttrDate(itemtype => itemtype,

1534: itemkey => itemkey,
1535: aname => 'APPROVAL_DATE',
1536: avalue => l_response_date);
1537: ELSIF l_response_type = 'REJECT' THEN
1538: wf_engine.SetItemAttrDate(itemtype => itemtype,
1539: itemkey => itemkey,
1540: aname => 'REJECTION_DATE',
1541: avalue => l_response_date);
1542: END IF;

Line 1556: l_forwardee_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

1552: ELSIF l_response_type = 'REJECT' THEN
1553: resultout := 'REJECTION';
1554: -- if the approver is forwarding, validate the forwardee
1555: ELSIF l_response_type IN ('FORWARD', 'APPROVE_AND_FORWARD') THEN
1556: l_forwardee_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,
1557: itemkey => itemkey,
1558: aname => 'APPROVER_FORWARDEE_USER');
1559:
1560: -- if no forwardee was specified

Line 1566: wf_engine.SetItemAttrText(itemtype => itemtype,

1562: resultout := 'INVALID_FORWARD';
1563: l_valid_response := FALSE;
1564:
1565: -- set the Application Error workflow attribute
1566: wf_engine.SetItemAttrText(itemtype => itemtype,
1567: itemkey => itemkey,
1568: aname => 'APPLICATION_ERROR',
1569: avalue => PON_AUCTION_PKG.getMessage('PON_NO_FORWARDEE_SPECIFIED'));
1570: -- otherwise

Line 1584: wf_engine.SetItemAttrText(itemtype => itemtype,

1580: resultout := 'INVALID_FORWARD';
1581: l_valid_response := FALSE;
1582:
1583: -- set the Application Error workflow attribute
1584: wf_engine.SetItemAttrText(itemtype => itemtype,
1585: itemkey => itemkey,
1586: aname => 'APPLICATION_ERROR',
1587: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME', get_display_name_for_user(l_forwardee_user_name)));
1588: END IF;

Line 1640: wf_engine.SetItemAttrText( itemtype => itemtype,

1636: resultout := 'INVALID_FORWARD';
1637: l_success_flag := FALSE;
1638:
1639: -- this message can be seen only by admin.
1640: wf_engine.SetItemAttrText( itemtype => itemtype,
1641: itemkey => itemkey,
1642: aname => 'OAM_ERROR',
1643: avalue => PON_AUCTION_PKG.getMessage('PON_NO_POSITION_FOR_PERSON', '', 'PERSON_NAME', l_forwardee.display_name ));
1644:

Line 1646: wf_engine.SetItemAttrText( itemtype => itemtype,

1642: aname => 'OAM_ERROR',
1643: avalue => PON_AUCTION_PKG.getMessage('PON_NO_POSITION_FOR_PERSON', '', 'PERSON_NAME', l_forwardee.display_name ));
1644:
1645: -- this message can be seen by any buyer.
1646: wf_engine.SetItemAttrText( itemtype => itemtype,
1647: itemkey => itemkey,
1648: aname => 'APPLICATION_ERROR',
1649: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1650:

Line 1670: wf_engine.SetItemAttrText( itemtype => itemtype,

1666: resultout := 'INVALID_FORWARD';
1667: l_success_flag := FALSE;
1668:
1669: -- this message can be seen only by admin.
1670: wf_engine.SetItemAttrText( itemtype => itemtype,
1671: itemkey => itemkey,
1672: aname => 'OAM_ERROR',
1673: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1674:

Line 1676: wf_engine.SetItemAttrText( itemtype => itemtype,

1672: aname => 'OAM_ERROR',
1673: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1674:
1675: -- this message can be seen by any buyer.
1676: wf_engine.SetItemAttrText( itemtype => itemtype,
1677: itemkey => itemkey,
1678: aname => 'APPLICATION_ERROR',
1679: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME', l_forwardee.display_name ));
1680:

Line 1714: wf_engine.SetItemAttrText(itemtype => itemtype,

1710:
1711: -- if the OAM API call raises an exception,
1712: -- set the Application Error and OAM Error workflow attributes
1713: -- this message is internal and can be seen only by the OAM administrator
1714: wf_engine.SetItemAttrText(itemtype => itemtype,
1715: itemkey => itemkey,
1716: aname => 'OAM_ERROR',
1717: avalue => SQLERRM);
1718:

Line 1720: wf_engine.SetItemAttrText(itemtype => itemtype,

1716: aname => 'OAM_ERROR',
1717: avalue => SQLERRM);
1718:
1719: -- this message can be seen by any buyer
1720: wf_engine.SetItemAttrText(itemtype => itemtype,
1721: itemkey => itemkey,
1722: aname => 'APPLICATION_ERROR',
1723: avalue => PON_AUCTION_PKG.getMessage('PON_OAM_ERROR_OCCURRED'));
1724:

Line 1741: wf_engine.createProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,

1737: p_note_to_approvers IN VARCHAR2,
1738: p_first_authority_approver_id IN NUMBER ) IS
1739: BEGIN
1740:
1741: wf_engine.createProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1742: itemkey => p_item_key,
1743: process => 'AWARD_APPROVAL');
1744:
1745: -- set main language-independent workflow attributes

Line 1750: wf_engine.SetItemOwner(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,

1746: set_core_attributes(AWARD_APPROVAL_WF_ITEM_TYPE, p_item_key, p_auction_header_id, p_note_to_approvers, p_first_authority_approver_id);
1747:
1748:
1749: -- Bug 4295915: Set the workflow owner
1750: wf_engine.SetItemOwner(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1751: itemkey => p_item_key,
1752: owner => fnd_global.user_name);
1753:
1754: -- start workflow process

Line 1755: wf_engine.StartProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,

1751: itemkey => p_item_key,
1752: owner => fnd_global.user_name);
1753:
1754: -- start workflow process
1755: wf_engine.StartProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1756: itemkey => p_item_key);
1757:
1758: END start_workflow_process;
1759: