[Home] [Help]
17: | Date UserName Description
18: | -------------------------------------------------------------------------------------------
19: |
20: | 25-Aug-05 sparames Bug 4295915: Missing owner in Sourcing notifications
21: | Added call to wf_engine.SetItemOwner
22: |
23: | 09-Sep-05 120.25 sparames ECO 4456420: Added setting of ORIGIN_USER_NAME to the
24: | current user for most operations
25: |
113:
114: END IF;
115:
116: IF (p_itemtype = 'PONAPPRV' or p_itemtype = 'PONAWAPR') THEN
117: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
118: itemkey => p_itemkey,
119: aname => 'AUCTION_HEADER_ID');
120: END IF;
121:
166: end;
167: -- time to move the parent activity to the approved state
168: if l_activity_status = 'WAITFOR APPROVALS' then
169: if (l_auction_approval_status = 'APPROVED') then
170: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'APPROVED');
171: else wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'NOT_REQUIRED');
172: end if;
173: end if;
174: end if; -- APPROVED
167: -- time to move the parent activity to the approved state
168: if l_activity_status = 'WAITFOR APPROVALS' then
169: if (l_auction_approval_status = 'APPROVED') then
170: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'APPROVED');
171: else wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'NOT_REQUIRED');
172: end if;
173: end if;
174: end if; -- APPROVED
175: End Process_If_Doc_Approved;
186: l_is_federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id);
187: if ( l_is_federal = 1 ) THEN
188: l_is_amendment := PON_CLM_UTIL_PKG.IS_AMENDMENT(p_auction_header_id);
189: if ( l_is_amendment = 'Y' ) THEN
190: l_signed_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'SIGNED_DATE');
193: if ( l_signed_date is null ) THEN
194: l_signed_date := sysdate;
213: l_activity_status := 'DO Nothing';
214: end;
215: -- time to move the parent activity to the rejected state
216: if l_activity_status = 'WAITFOR APPROVALS' then
217: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'REJECTED');
218: end if;
219: End Process_Doc_Rejected;
220:
221: PROCEDURE CANCEL_NOTIFICATION(p_auction_header_id number,
345: WHERE auction_header_id = p_auction_header_id;
346:
347: --added by amundhra for Federal CLM
348: --added signed date setting the item attribute date.
349: wf_engine.SetItemAttrDate(l_itemType,l_itemKey, 'SIGNED_DATE', p_signed_date);
350:
351: wf_engine.SetItemAttrDate(l_itemType,l_item_key_main_process, 'SIGNED_DATE', p_signed_date);
352:
353: WF_Notification.respond(l_nid,p_result,p_user_name);
347: --added by amundhra for Federal CLM
348: --added signed date setting the item attribute date.
349: wf_engine.SetItemAttrDate(l_itemType,l_itemKey, 'SIGNED_DATE', p_signed_date);
350:
351: wf_engine.SetItemAttrDate(l_itemType,l_item_key_main_process, 'SIGNED_DATE', p_signed_date);
352:
353: WF_Notification.respond(l_nid,p_result,p_user_name);
354: exception
355: when others then
374: --Bug 9386801
375: --Uncommenting the CompleteActivity because of which
376: --workflow was not ending and resulting in unneeded reminder
377: --notifications after one approver rejects
378: wf_engine.CompleteActivity(l_item_type,r1.item_key,
379: r1.activity_label,'CLOSE');
380:
381: exception when others then null;
382: end;
391: resultout out nocopy varchar2) is
392:
393: l_auction_header_id NUMBER;
394: begin
395: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'AUCTION_HEADER_ID');
398: update pon_auction_headers_all
399: set auction_status = 'CANCELLED'
518: into l_seq from sys.dual;
519:
520: l_itemKey := to_char (p_auction_header_id)|| '-' || l_seq;
521:
522: wf_engine.createProcess ( itemType => l_itemType,
523: itemKey => l_itemKey,
524: process => 'SOURCINGAPPROVAL');
525:
526:
546: * 2. Super large neg.
547: */
548: l_manage_draft_url := pon_wf_utl_pkg.get_dest_page_url (p_dest_func => 'PON_MANAGE_DRAFT_NEG',
549: p_notif_performer => 'BUYER');
550: wf_engine.SetItemAttrText (itemtype => l_itemType,
551: itemkey => l_itemKey,
552: aname => 'MAN_DRAFT_NEG_URL',
553: avalue => l_manage_draft_url);
554:
553: avalue => l_manage_draft_url);
554:
555: -- new item attribute to hold the redirect Function. Attribute value is going
556: -- to be used as a parameter to access Review and Submit page
557: wf_engine.SetItemAttrText (itemtype => l_itemType,
558: itemkey => l_itemKey,
559: aname => 'REVIEWPG_REDIRECTFUNC',
560: avalue => p_redirect_func);
561:
558: itemkey => l_itemKey,
559: aname => 'REVIEWPG_REDIRECTFUNC',
560: avalue => p_redirect_func);
561:
562: wf_engine.SetItemAttrText (itemtype => l_itemType,
563: itemkey => l_itemKey,
564: aname => 'REVIEW_CHANGES_URL',
565: avalue => l_review_changes_url);
566:
563: itemkey => l_itemKey,
564: aname => 'REVIEW_CHANGES_URL',
565: avalue => l_review_changes_url);
566:
567: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
568: itemkey => l_itemKey,
569: aname => 'TRADING_PARTNER_CONTACT_ID',
570: avalue => l_auction_contact_id);
571:
568: itemkey => l_itemKey,
569: aname => 'TRADING_PARTNER_CONTACT_ID',
570: avalue => l_auction_contact_id);
571:
572: wf_engine.SetItemAttrDate (itemtype => l_itemType,
573: itemkey => l_itemKey,
574: aname => 'AUCTION_START_DATE',
575: avalue => l_open_bidding_date);
576:
573: itemkey => l_itemKey,
574: aname => 'AUCTION_START_DATE',
575: avalue => l_open_bidding_date);
576:
577: wf_engine.SetItemAttrDate (itemtype => l_itemType,
578: itemkey => l_itemKey,
579: aname => 'AUCTION_END_DATE',
580: avalue => l_close_bidding_date);
581:
578: itemkey => l_itemKey,
579: aname => 'AUCTION_END_DATE',
580: avalue => l_close_bidding_date);
581:
582: wf_engine.SetItemAttrText (itemtype => l_itemType,
583: itemkey => l_itemKey,
584: aname => 'TOP_PROCESS_ITEM_KEY',
585: avalue => l_itemKey);
586:
583: itemkey => l_itemKey,
584: aname => 'TOP_PROCESS_ITEM_KEY',
585: avalue => l_itemKey);
586:
587: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
588: itemkey => l_itemKey,
589: aname => 'AUCTION_HEADER_ID',
590: avalue => p_auction_header_id);
591:
588: itemkey => l_itemKey,
589: aname => 'AUCTION_HEADER_ID',
590: avalue => p_auction_header_id);
591:
592: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
593: itemkey => l_itemKey,
594: aname => 'DOC_ROUND_NUMBER',
595: avalue => l_round_number);
596:
593: itemkey => l_itemKey,
594: aname => 'DOC_ROUND_NUMBER',
595: avalue => l_round_number);
596:
597: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
598: itemkey => l_itemKey,
599: aname => 'DOC_AMENDMENT_NUMBER',
600: avalue => l_amendment_number);
601:
599: aname => 'DOC_AMENDMENT_NUMBER',
600: avalue => l_amendment_number);
601:
602:
603: wf_engine.SetItemAttrDate (itemtype => l_itemType,
604: itemkey => l_itemKey,
605: aname => 'TIMEOUT_MAINPROCESS',
606: avalue => l_close_bidding_date);
607:
604: itemkey => l_itemKey,
605: aname => 'TIMEOUT_MAINPROCESS',
606: avalue => l_close_bidding_date);
607:
608: wf_engine.SetItemAttrText (itemtype => l_itemType,
609: itemkey => l_itemKey,
610: aname => 'CREATOR_USER_NAME',
611: avalue => l_creator_user_name);
612:
609: itemkey => l_itemKey,
610: aname => 'CREATOR_USER_NAME',
611: avalue => l_creator_user_name);
612:
613: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
614: itemkey => l_itemKey,
615: aname => 'CREATOR_USER_ID',
616: avalue => l_creator_user_id);
617:
626: */
627: if PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 then
628: l_is_federal := 1;
629: End if;
630: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
631: itemkey => l_itemKey,
632: aname => 'IS_FEDERAL',
633: avalue => l_is_federal);
634: -- End of Federal Code changes
634: -- End of Federal Code changes
635:
636: l_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (l_doctype_group_name);
637:
638: wf_engine.SetItemAttrText (itemtype => l_itemType,
639: itemkey => l_itemKey,
640: aname => 'MSG_SUFFIX',
641: avalue => l_msg_suffix);
642: -- Get the user's timezone
661: END IF;
662:
663: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
664:
665: wf_engine.SetItemAttrText (itemtype => l_itemType,
666: itemkey => l_itemKey,
667: aname => 'TIMEZONE',
668: avalue => l_timezone_disp);
669:
669:
670: IF (l_preview_date IS NULL) THEN
671: l_timezone1_disp := null;
672:
673: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
674: itemkey => l_itemkey,
675: aname => 'PREVIEW_DATE',
676: avalue => null);
677:
674: itemkey => l_itemkey,
675: aname => 'PREVIEW_DATE',
676: avalue => null);
677:
678: wf_engine.SetItemAttrText (itemtype => l_itemtype,
679: itemkey => l_itemkey,
680: aname => 'TP_TIME_ZONE1',
681: avalue => l_timezone1_disp);
682:
679: itemkey => l_itemkey,
680: aname => 'TP_TIME_ZONE1',
681: avalue => l_timezone1_disp);
682:
683: wf_engine.SetItemAttrText (itemtype => l_itemtype,
684: itemkey => l_itemkey,
685: aname => 'PREVIEW_DATE_NOTSPECIFIED',
686: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix));
687: ELSE
686: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix));
687: ELSE
688: l_timezone1_disp := l_timezone_disp;
689:
690: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
691: itemkey => l_itemkey,
692: aname => 'PREVIEW_DATE',
693: avalue => l_preview_date_in_tz);
694:
691: itemkey => l_itemkey,
692: aname => 'PREVIEW_DATE',
693: avalue => l_preview_date_in_tz);
694:
695: wf_engine.SetItemAttrText (itemtype => l_itemtype,
696: itemkey => l_itemkey,
697: aname => 'TP_TIME_ZONE1',
698: avalue => l_timezone1_disp);
699:
696: itemkey => l_itemkey,
697: aname => 'TP_TIME_ZONE1',
698: avalue => l_timezone1_disp);
699:
700: wf_engine.SetItemAttrText (itemtype => l_itemtype,
701: itemkey => l_itemkey,
702: aname => 'PREVIEW_DATE_NOTSPECIFIED',
703: avalue => null);
704: END IF;
703: avalue => null);
704: END IF;
705:
706:
707: wf_engine.SetItemAttrDate (itemtype => l_itemType,
708: itemkey => l_itemKey,
709: aname => 'AUCTION_START_DATE',
710: avalue => l_open_date_in_tz);
711: if (l_open_auction_now_flag = 'Y') then
708: itemkey => l_itemKey,
709: aname => 'AUCTION_START_DATE',
710: avalue => l_open_date_in_tz);
711: if (l_open_auction_now_flag = 'Y') then
712: wf_engine.SetItemAttrText (itemtype => l_itemType,
713: itemkey => l_itemKey,
714: aname => 'OPEN_IMMEDIATELY',
715: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
716:
713: itemkey => l_itemKey,
714: aname => 'OPEN_IMMEDIATELY',
715: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
716:
717: wf_engine.SetItemAttrText (itemtype => l_itemType,
718: itemkey => l_itemKey,
719: aname => 'O_TIMEZONE',
720: avalue => null);
721: else
718: itemkey => l_itemKey,
719: aname => 'O_TIMEZONE',
720: avalue => null);
721: else
722: wf_engine.SetItemAttrText (itemtype => l_itemType,
723: itemkey => l_itemKey,
724: aname => 'OPEN_IMMEDIATELY',
725: avalue =>null);
726: wf_engine.SetItemAttrText (itemtype => l_itemType,
722: wf_engine.SetItemAttrText (itemtype => l_itemType,
723: itemkey => l_itemKey,
724: aname => 'OPEN_IMMEDIATELY',
725: avalue =>null);
726: wf_engine.SetItemAttrText (itemtype => l_itemType,
727: itemkey => l_itemKey,
728: aname => 'O_TIMEZONE',
729: avalue => l_timezone_disp);
730: end if;
728: aname => 'O_TIMEZONE',
729: avalue => l_timezone_disp);
730: end if;
731:
732: wf_engine.SetItemAttrDate (itemtype => l_itemType,
733: itemkey => l_itemKey,
734: aname => 'AUCTION_END_DATE',
735: avalue => l_close_date_in_tz);
736:
734: aname => 'AUCTION_END_DATE',
735: avalue => l_close_date_in_tz);
736:
737:
738: wf_engine.SetItemAttrText (itemtype => l_itemType,
739: itemkey => l_itemKey,
740: aname => 'NOTE_TO_APPROVERS',
741: avalue => p_note_to_approvers);
742: select document_number
754: where fnd.employee_id=emp.person_id and
755: fnd.user_id = l_creator_user_id and
756: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;
757:
758: wf_engine.SetItemAttrText (itemtype => l_itemType,
759: itemkey => l_itemKey,
760: aname => 'AUCTIONEER_NAME',
761: avalue => l_creator_full_name);
762:
760: aname => 'AUCTIONEER_NAME',
761: avalue => l_creator_full_name);
762:
763:
764: wf_engine.SetItemAttrText (itemtype => l_itemType,
765: itemkey => l_itemKey,
766: aname => 'ORIGIN_USER_NAME',
767: avalue => fnd_global.user_name);
768:
768:
769: -- bug 11732401 start
770: l_resp_id := fnd_global.RESP_ID;
771: l_appl_id := fnd_global.RESP_APPL_ID;
772: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
773: itemkey => l_itemKey,
774: aname => 'PREPARER_RESP_ID',
775: avalue => l_resp_id);
776:
773: itemkey => l_itemKey,
774: aname => 'PREPARER_RESP_ID',
775: avalue => l_resp_id);
776:
777: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
778: itemkey => l_itemKey,
779: aname => 'PREPARER_APPL_ID',
780: avalue => l_appl_id);
781: -- bug 11732401 end
795: NULL); -- Adding by amundhra for Federal CLM, signed date will be null here
796:
797:
798: -- Bug 4295915: Set the workflow owner
799: wf_engine.SetItemOwner(itemtype => l_itemtype,
800: itemkey => l_itemkey,
801: owner => fnd_global.user_name);
802:
803: wf_engine.StartProcess (itemType => l_itemType,
799: wf_engine.SetItemOwner(itemtype => l_itemtype,
800: itemkey => l_itemkey,
801: owner => fnd_global.user_name);
802:
803: wf_engine.StartProcess (itemType => l_itemType,
804: itemKey => l_itemKey );
805:
806: /* Update Headers table */
807: UPDATE pon_auction_headers_all set
893: if l_timeout_factor <= 0 or l_timeout_factor >=1 then
894: l_timeout_factor := .5;
895: end if;
896:
897: l_preparer_tp_name := wf_engine.GetItemAttrText (itemtype => itemType,
898: itemkey => itemKey,
899: aname => 'PREPARER_TP_NAME');
900:
901: l_auction_title := wf_engine.GetItemAttrText (itemtype => itemType,
897: l_preparer_tp_name := wf_engine.GetItemAttrText (itemtype => itemType,
898: itemkey => itemKey,
899: aname => 'PREPARER_TP_NAME');
900:
901: l_auction_title := wf_engine.GetItemAttrText (itemtype => itemType,
902: itemkey => itemKey,
903: aname => 'AUCTION_TITLE');
904:
905: l_doc_number := wf_engine.GetItemAttrText (itemtype => itemType,
901: l_auction_title := wf_engine.GetItemAttrText (itemtype => itemType,
902: itemkey => itemKey,
903: aname => 'AUCTION_TITLE');
904:
905: l_doc_number := wf_engine.GetItemAttrText (itemtype => itemType,
906: itemkey => itemKey,
907: aname => 'DOC_NUMBER');
908:
909: l_preparer_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemType,
905: l_doc_number := wf_engine.GetItemAttrText (itemtype => itemType,
906: itemkey => itemKey,
907: aname => 'DOC_NUMBER');
908:
909: l_preparer_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemType,
910: itemkey => itemKey,
911: aname => 'PREPARER_TP_CONTACT_NAME');
912:
913: l_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemType,
909: l_preparer_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemType,
910: itemkey => itemKey,
911: aname => 'PREPARER_TP_CONTACT_NAME');
912:
913: l_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemType,
914: itemkey => itemKey,
915: aname => 'AUCTION_START_DATE');
916:
917: l_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemType,
913: l_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemType,
914: itemkey => itemKey,
915: aname => 'AUCTION_START_DATE');
916:
917: l_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemType,
918: itemkey => itemKey,
919: aname => 'AUCTION_END_DATE');
920:
921: l_timezone_dsp := wf_engine.GetItemAttrText (itemtype => itemType,
917: l_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemType,
918: itemkey => itemKey,
919: aname => 'AUCTION_END_DATE');
920:
921: l_timezone_dsp := wf_engine.GetItemAttrText (itemtype => itemType,
922: itemkey => itemKey,
923: aname => 'TIMEZONE');
924:
925:
923: aname => 'TIMEZONE');
924:
925:
926:
927: l_note_to_approvers := wf_engine.GetItemAttrText (itemtype => itemType,
928: itemkey => itemKey,
929: aname => 'NOTE_TO_APPROVERS');
930:
931: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
927: l_note_to_approvers := wf_engine.GetItemAttrText (itemtype => itemType,
928: itemkey => itemKey,
929: aname => 'NOTE_TO_APPROVERS');
930:
931: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
932: itemkey => itemKey,
933: aname => 'PREVIEW_DATE');
934: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
935: itemkey => itemKey,
930:
931: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
932: itemkey => itemKey,
933: aname => 'PREVIEW_DATE');
934: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
935: itemkey => itemKey,
936: aname => 'TP_TIME_ZONE1');
937:
938: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
934: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
935: itemkey => itemKey,
936: aname => 'TP_TIME_ZONE1');
937:
938: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
939: itemkey => itemKey,
940: aname => 'PREVIEW_DATE_NOTSPECIFIED');
941: l_msg_suffix := wf_engine.GetItemAttrText (itemtype => itemType,
942: itemkey => itemKey,
937:
938: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
939: itemkey => itemKey,
940: aname => 'PREVIEW_DATE_NOTSPECIFIED');
941: l_msg_suffix := wf_engine.GetItemAttrText (itemtype => itemType,
942: itemkey => itemKey,
943: aname => 'MSG_SUFFIX');
944:
945: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
941: l_msg_suffix := wf_engine.GetItemAttrText (itemtype => itemType,
942: itemkey => itemKey,
943: aname => 'MSG_SUFFIX');
944:
945: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
946: itemkey => itemKey,
947: aname => 'AUCTION_HEADER_ID');
948:
949: l_round_number := wf_engine.GetItemAttrNumber (itemtype => itemType,
945: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
946: itemkey => itemKey,
947: aname => 'AUCTION_HEADER_ID');
948:
949: l_round_number := wf_engine.GetItemAttrNumber (itemtype => itemType,
950: itemkey => itemKey,
951: aname => 'DOC_ROUND_NUMBER');
952:
953:
951: aname => 'DOC_ROUND_NUMBER');
952:
953:
954:
955: l_amendment_number := wf_engine.GetItemAttrNumber (itemtype => itemType,
956: itemkey => itemKey,
957: aname => 'DOC_AMENDMENT_NUMBER');
958:
959: l_creator_full_name:= wf_engine.GetItemAttrText (itemtype => itemType,
955: l_amendment_number := wf_engine.GetItemAttrNumber (itemtype => itemType,
956: itemkey => itemKey,
957: aname => 'DOC_AMENDMENT_NUMBER');
958:
959: l_creator_full_name:= wf_engine.GetItemAttrText (itemtype => itemType,
960: itemkey => itemKey,
961: aname => 'AUCTIONEER_NAME');
962:
963: l_redirect_func:= wf_engine.GetItemAttrText (itemtype => itemType,
959: l_creator_full_name:= wf_engine.GetItemAttrText (itemtype => itemType,
960: itemkey => itemKey,
961: aname => 'AUCTIONEER_NAME');
962:
963: l_redirect_func:= wf_engine.GetItemAttrText (itemtype => itemType,
964: itemkey => itemKey,
965: aname => 'REVIEWPG_REDIRECTFUNC');
966:
967: /* Preserve creator's session language */
964: itemkey => itemKey,
965: aname => 'REVIEWPG_REDIRECTFUNC');
966:
967: /* Preserve creator's session language */
968: l_creator_user_name := wf_engine.GetItemAttrText (itemtype => itemType,
969: itemkey => itemKey,
970: aname => 'CREATOR_USER_NAME');
971:
972: l_creator_user_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
968: l_creator_user_name := wf_engine.GetItemAttrText (itemtype => itemType,
969: itemkey => itemKey,
970: aname => 'CREATOR_USER_NAME');
971:
972: l_creator_user_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
973: itemkey => itemKey,
974: aname => 'CREATOR_USER_ID');
975:
976: -- bug 11732401
973: itemkey => itemKey,
974: aname => 'CREATOR_USER_ID');
975:
976: -- bug 11732401
977: l_is_federal := wf_engine.GetItemAttrNumber (itemtype => itemType,
978: itemkey => itemKey,
979: aname => 'IS_FEDERAL');
980:
981: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
977: l_is_federal := wf_engine.GetItemAttrNumber (itemtype => itemType,
978: itemkey => itemKey,
979: aname => 'IS_FEDERAL');
980:
981: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
982: itemkey => itemKey,
983: aname => 'PREPARER_RESP_ID');
984:
985: l_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
981: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
982: itemkey => itemKey,
983: aname => 'PREPARER_RESP_ID');
984:
985: l_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
986: itemkey => itemKey,
987: aname => 'PREPARER_APPL_ID');
988: -- bug 11732401 end
989:
1026:
1027: l_itemKey := itemkey || '_' || r1.user_id;
1028:
1029:
1030: wf_engine.createProcess ( itemType => l_itemType,
1031: itemKey => l_itemKey,
1032: process => 'USERAPPROVALS');
1033:
1034:
1043: select sysdate+((l_reminder_date - sysdate) * l_timeout_factor)
1044: into l_reminder_date
1045: from dual;
1046:
1047: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1048: itemkey => l_itemKey,
1049: aname => 'TIMEOUT_USERPROCESS',
1050: avalue => l_reminder_date);
1051:
1048: itemkey => l_itemKey,
1049: aname => 'TIMEOUT_USERPROCESS',
1050: avalue => l_reminder_date);
1051:
1052: wf_engine.SetItemAttrText (itemtype => l_itemType,
1053: itemkey => l_itemKey,
1054: aname => 'CREATOR_USER_NAME',
1055: avalue => l_creator_user_name);
1056:
1053: itemkey => l_itemKey,
1054: aname => 'CREATOR_USER_NAME',
1055: avalue => l_creator_user_name);
1056:
1057: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1058: itemkey => l_itemKey,
1059: aname => 'CREATOR_USER_ID',
1060: avalue => l_creator_user_id);
1061:
1058: itemkey => l_itemKey,
1059: aname => 'CREATOR_USER_ID',
1060: avalue => l_creator_user_id);
1061:
1062: wf_engine.SetItemAttrText (itemtype => l_itemType,
1063: itemkey => l_itemKey,
1064: aname => 'REVIEWPG_REDIRECTFUNC',
1065: avalue => l_redirect_func);
1066:
1063: itemkey => l_itemKey,
1064: aname => 'REVIEWPG_REDIRECTFUNC',
1065: avalue => l_redirect_func);
1066:
1067: wf_engine.SetItemAttrText (itemtype => l_itemType,
1068: itemkey => l_itemKey,
1069: aname => 'PREPARER_TP_NAME',
1070: avalue => l_preparer_tp_name);
1071:
1068: itemkey => l_itemKey,
1069: aname => 'PREPARER_TP_NAME',
1070: avalue => l_preparer_tp_name);
1071:
1072: wf_engine.SetItemAttrText (itemtype => l_itemType,
1073: itemkey => l_itemKey,
1074: aname => 'AUCTION_TITLE',
1075: avalue => l_auction_title);
1076:
1073: itemkey => l_itemKey,
1074: aname => 'AUCTION_TITLE',
1075: avalue => l_auction_title);
1076:
1077: wf_engine.SetItemAttrText (itemtype => l_itemType,
1078: itemkey => l_itemKey,
1079: aname => 'DOC_NUMBER',
1080: avalue => l_doc_number);
1081:
1078: itemkey => l_itemKey,
1079: aname => 'DOC_NUMBER',
1080: avalue => l_doc_number);
1081:
1082: wf_engine.SetItemAttrText (itemtype => l_itemType,
1083: itemkey => l_itemKey,
1084: aname => 'PREPARER_TP_CONTACT_NAME',
1085: avalue => l_preparer_tp_contact_name);
1086:
1083: itemkey => l_itemKey,
1084: aname => 'PREPARER_TP_CONTACT_NAME',
1085: avalue => l_preparer_tp_contact_name);
1086:
1087: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1088: itemkey => l_itemKey,
1089: aname => 'AUCTION_START_DATE',
1090: avalue => l_auction_start_date);
1091:
1088: itemkey => l_itemKey,
1089: aname => 'AUCTION_START_DATE',
1090: avalue => l_auction_start_date);
1091:
1092: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1093: itemkey => l_itemKey,
1094: aname => 'AUCTION_END_DATE',
1095: avalue => l_auction_end_date);
1096:
1093: itemkey => l_itemKey,
1094: aname => 'AUCTION_END_DATE',
1095: avalue => l_auction_end_date);
1096:
1097: wf_engine.SetItemAttrText (itemtype => l_itemType,
1098: itemkey => l_itemKey,
1099: aname => 'TIMEZONE',
1100: avalue => l_timezone_dsp);
1101:
1098: itemkey => l_itemKey,
1099: aname => 'TIMEZONE',
1100: avalue => l_timezone_dsp);
1101:
1102: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1103: itemkey => l_itemKey,
1104: aname => 'PREVIEW_DATE',
1105: avalue => l_preview_date_in_tz);
1106:
1103: itemkey => l_itemKey,
1104: aname => 'PREVIEW_DATE',
1105: avalue => l_preview_date_in_tz);
1106:
1107: wf_engine.SetItemAttrText (itemtype => l_itemType,
1108: itemkey => l_itemKey,
1109: aname => 'TP_TIME_ZONE1',
1110: avalue => l_timezone1_disp);
1111:
1109: aname => 'TP_TIME_ZONE1',
1110: avalue => l_timezone1_disp);
1111:
1112:
1113: wf_engine.SetItemAttrText (itemtype => l_itemType,
1114: itemkey => l_itemKey,
1115: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1116: avalue => l_preview_date_nspec);
1117:
1114: itemkey => l_itemKey,
1115: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1116: avalue => l_preview_date_nspec);
1117:
1118: wf_engine.SetItemAttrText (itemtype => l_itemType,
1119: itemkey => l_itemKey,
1120: aname => 'NOTE_TO_APPROVERS',
1121: avalue => l_note_to_approvers);
1122:
1119: itemkey => l_itemKey,
1120: aname => 'NOTE_TO_APPROVERS',
1121: avalue => l_note_to_approvers);
1122:
1123: wf_engine.SetItemAttrText (itemtype => l_itemType,
1124: itemkey => l_itemKey,
1125: aname => 'TOP_PROCESS_ITEM_KEY',
1126: avalue =>
1127: wf_engine.GetItemAttrText (itemtype => l_itemType,
1123: wf_engine.SetItemAttrText (itemtype => l_itemType,
1124: itemkey => l_itemKey,
1125: aname => 'TOP_PROCESS_ITEM_KEY',
1126: avalue =>
1127: wf_engine.GetItemAttrText (itemtype => l_itemType,
1128: itemkey => itemKey,
1129: aname => 'TOP_PROCESS_ITEM_KEY')
1130: );
1131:
1128: itemkey => itemKey,
1129: aname => 'TOP_PROCESS_ITEM_KEY')
1130: );
1131:
1132: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1133: itemkey => l_itemKey,
1134: aname => 'AUCTION_HEADER_ID',
1135: avalue => l_auction_header_id);
1136:
1133: itemkey => l_itemKey,
1134: aname => 'AUCTION_HEADER_ID',
1135: avalue => l_auction_header_id);
1136:
1137: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1138: itemkey => l_itemKey,
1139: aname => 'DOC_ROUND_NUMBER',
1140: avalue => l_round_number);
1141:
1138: itemkey => l_itemKey,
1139: aname => 'DOC_ROUND_NUMBER',
1140: avalue => l_round_number);
1141:
1142: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1143: itemkey => l_itemKey,
1144: aname => 'DOC_AMENDMENT_NUMBER',
1145: avalue => l_amendment_number);
1146:
1152: --Modifying the language_code in the URL with that of the recipient
1153: --The profile "ICX_LANGUAGE" needs to be set for the recipient for this fix
1154: l_review_changes_url:=regexp_replace(l_review_changes_url , 'language_code='||fnd_global.current_language, 'language_code='||l_language_code);
1155:
1156: wf_engine.SetItemAttrText (itemtype => l_itemType,
1157: itemkey => l_itemKey,
1158: aname => 'REVIEW_CHANGES_URL',
1159: avalue => l_review_changes_url);
1160:
1158: aname => 'REVIEW_CHANGES_URL',
1159: avalue => l_review_changes_url);
1160:
1161:
1162: wf_engine.SetItemAttrText (itemtype => l_itemType,
1163: itemkey => l_itemKey,
1164: aname => 'APPOVER',
1165: avalue => r1.user_name);
1166:
1163: itemkey => l_itemKey,
1164: aname => 'APPOVER',
1165: avalue => r1.user_name);
1166:
1167: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1168: itemkey => l_itemKey,
1169: aname => 'APPOVER_ID',
1170: avalue => r1.user_id);
1171:
1169: aname => 'APPOVER_ID',
1170: avalue => r1.user_id);
1171:
1172:
1173: wf_engine.SetItemAttrText (itemtype => l_itemType,
1174: itemkey => l_itemKey,
1175: aname => 'ORIGIN_USER_NAME',
1176: avalue => fnd_global.user_name);
1177:
1184: end if;
1185:
1186: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1187:
1188: wf_engine.SetItemAttrText (itemtype => l_itemType,
1189: itemkey => l_itemKey,
1190: aname => 'TIMEZONE',
1191: avalue => l_timezone_disp);
1192:
1192:
1193: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.open_bidding_date,l_oex_timezone,l_timezone);
1194: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.close_bidding_date,l_oex_timezone,l_timezone);
1195:
1196: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1197: itemkey => l_itemKey,
1198: aname => 'AUCTION_START_DATE',
1199: avalue => l_open_date_in_tz);
1200: if (r1.open_auction_now_flag = 'Y') then
1197: itemkey => l_itemKey,
1198: aname => 'AUCTION_START_DATE',
1199: avalue => l_open_date_in_tz);
1200: if (r1.open_auction_now_flag = 'Y') then
1201: wf_engine.SetItemAttrText (itemtype => l_itemType,
1202: itemkey => l_itemKey,
1203: aname => 'OPEN_IMMEDIATELY',
1204: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
1205:
1202: itemkey => l_itemKey,
1203: aname => 'OPEN_IMMEDIATELY',
1204: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
1205:
1206: wf_engine.SetItemAttrText (itemtype => l_itemType,
1207: itemkey => l_itemKey,
1208: aname => 'O_TIMEZONE',
1209: avalue => null);
1210: else
1207: itemkey => l_itemKey,
1208: aname => 'O_TIMEZONE',
1209: avalue => null);
1210: else
1211: wf_engine.SetItemAttrText (itemtype => l_itemType,
1212: itemkey => l_itemKey,
1213: aname => 'OPEN_IMMEDIATELY',
1214: avalue =>null);
1215:
1212: itemkey => l_itemKey,
1213: aname => 'OPEN_IMMEDIATELY',
1214: avalue =>null);
1215:
1216: wf_engine.SetItemAttrText (itemtype => l_itemType,
1217: itemkey => l_itemKey,
1218: aname => 'O_TIMEZONE',
1219: avalue => l_timezone_disp);
1220: end if;
1218: aname => 'O_TIMEZONE',
1219: avalue => l_timezone_disp);
1220: end if;
1221:
1222: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1223: itemkey => l_itemKey,
1224: aname => 'AUCTION_END_DATE',
1225: avalue => l_close_date_in_tz);
1226:
1224: aname => 'AUCTION_END_DATE',
1225: avalue => l_close_date_in_tz);
1226:
1227:
1228: wf_engine.SetItemAttrText (itemtype => l_itemType,
1229: itemkey => l_itemKey,
1230: aname => 'NOTE_TO_APPROVERS',
1231: avalue => l_note_to_approvers);
1232:
1230: aname => 'NOTE_TO_APPROVERS',
1231: avalue => l_note_to_approvers);
1232:
1233: -- bug 11732401
1234: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1235: itemkey => l_itemKey,
1236: aname => 'IS_FEDERAL',
1237: avalue => l_is_federal);
1238:
1235: itemkey => l_itemKey,
1236: aname => 'IS_FEDERAL',
1237: avalue => l_is_federal);
1238:
1239: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1240: itemkey => l_itemKey,
1241: aname => 'PREPARER_RESP_ID',
1242: avalue => l_resp_id);
1243:
1240: itemkey => l_itemKey,
1241: aname => 'PREPARER_RESP_ID',
1242: avalue => l_resp_id);
1243:
1244: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
1245: itemkey => l_itemKey,
1246: aname => 'PREPARER_APPL_ID',
1247: avalue => l_appl_id);
1248: -- bug 11732401 end
1255: -- set notification subjects
1256: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);
1257:
1258: -- Bug 4295915: Set the workflow owner
1259: wf_engine.SetItemOwner(itemtype => l_itemtype,
1260: itemkey => l_itemkey,
1261: owner => fnd_global.user_name);
1262:
1263: wf_engine.StartProcess (itemType => l_itemType,
1259: wf_engine.SetItemOwner(itemtype => l_itemtype,
1260: itemkey => l_itemkey,
1261: owner => fnd_global.user_name);
1262:
1263: wf_engine.StartProcess (itemType => l_itemType,
1264: itemKey => l_itemKey );
1265: end loop;
1266:
1267: /* Reset to creator's language */
1348: l_prep_appl_id NUMBER;
1349:
1350: begin
1351: /* Get auction header id from the workflow */
1352: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1353: itemkey => itemkey,
1354: aname => 'AUCTION_HEADER_ID');
1355:
1356: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1352: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1353: itemkey => itemkey,
1354: aname => 'AUCTION_HEADER_ID');
1355:
1356: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'APPOVER');
1359:
1360: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1356: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'APPOVER');
1359:
1360: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'APPOVER_ID');
1363:
1364: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1360: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'APPOVER_ID');
1363:
1364: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => 'APPROVER_NOTES');
1367:
1368: -- bug 11732401
1365: itemkey => itemkey,
1366: aname => 'APPROVER_NOTES');
1367:
1368: -- bug 11732401
1369: l_is_federal := wf_engine.getItemAttrNumber (itemtype => itemType,
1370: itemkey => itemKey,
1371: aname => 'IS_FEDERAL');
1372:
1373: IF l_is_federal = 1 THEN
1373: IF l_is_federal = 1 THEN
1374: l_resp_id := fnd_global.RESP_ID;
1375: l_appl_id := fnd_global.RESP_APPL_ID;
1376:
1377: l_prep_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1378: itemkey => itemkey,
1379: aname => 'PREPARER_RESP_ID');
1380:
1381: l_prep_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1377: l_prep_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1378: itemkey => itemkey,
1379: aname => 'PREPARER_RESP_ID');
1380:
1381: l_prep_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1382: itemkey => itemkey,
1383: aname => 'PREPARER_APPL_ID');
1384: fnd_global.APPS_INITIALIZE (l_user_id, l_prep_resp_id, l_prep_appl_id);
1385: END IF;
1388: --added by amundhra for Federal CLM
1389:
1390:
1391:
1392: -- l_is_federal := wf_engine.getItemAttrNumber (itemtype => itemType,
1393: -- itemkey => itemKey,
1394: -- aname => 'IS_FEDERAL');
1395:
1396: l_signed_date := Get_Signed_Date(l_auction_header_id, itemtype, itemkey);
1395:
1396: l_signed_date := Get_Signed_Date(l_auction_header_id, itemtype, itemkey);
1397:
1398:
1399: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1400: itemkey => itemKey,
1401: aname => 'TOP_PROCESS_ITEM_KEY');
1402:
1403: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1399: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1400: itemkey => itemKey,
1401: aname => 'TOP_PROCESS_ITEM_KEY');
1402:
1403: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1404: itemkey => l_top_process_item_key,
1405: aname => 'APPOVER_ID',
1406: avalue => l_user_id);
1407:
1404: itemkey => l_top_process_item_key,
1405: aname => 'APPOVER_ID',
1406: avalue => l_user_id);
1407:
1408: wf_engine.SetItemAttrText (itemtype => itemtype,
1409: itemkey => l_top_process_item_key,
1410: aname => 'APPOVER',
1411: avalue => l_user_name);
1412:
1491:
1492: begin
1493:
1494: -- bug 11732401
1495: l_is_federal := wf_engine.getItemAttrNumber (itemtype => itemType,
1496: itemkey => itemKey,
1497: aname => 'IS_FEDERAL');
1498:
1499: IF l_is_federal = 1 THEN
1500: l_resp_id := fnd_global.RESP_ID;
1501: l_appl_id := fnd_global.RESP_APPL_ID;
1502:
1503:
1504: l_prep_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1505: itemkey => itemkey,
1506: aname => 'PREPARER_RESP_ID');
1507:
1508: l_prep_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1504: l_prep_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1505: itemkey => itemkey,
1506: aname => 'PREPARER_RESP_ID');
1507:
1508: l_prep_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1509: itemkey => itemkey,
1510: aname => 'PREPARER_APPL_ID');
1511: fnd_global.APPS_INITIALIZE (l_user_id, l_prep_resp_id, l_prep_appl_id);
1512: END IF;
1512: END IF;
1513: -- bug 11732401 end
1514:
1515: /* Get auction header id from the workflow */
1516: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1517: itemkey => itemkey,
1518: aname => 'AUCTION_HEADER_ID');
1519:
1520: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1516: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1517: itemkey => itemkey,
1518: aname => 'AUCTION_HEADER_ID');
1519:
1520: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1521: itemkey => itemkey,
1522: aname => 'APPOVER');
1523:
1524: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1520: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1521: itemkey => itemkey,
1522: aname => 'APPOVER');
1523:
1524: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1525: itemkey => itemkey,
1526: aname => 'APPOVER_ID');
1527:
1528: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1524: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1525: itemkey => itemkey,
1526: aname => 'APPOVER_ID');
1527:
1528: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1529: itemkey => itemkey,
1530: aname => 'APPROVER_NOTES');
1531:
1532: --added by amundhra for Federal CLM
1533: l_signed_date := Get_Signed_Date(l_auction_header_id, itemtype, itemkey);
1534:
1535:
1536:
1537: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1538: itemkey => itemKey,
1539: aname => 'TOP_PROCESS_ITEM_KEY');
1540:
1541: wf_engine.SetItemAttrText (itemtype => itemtype,
1537: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1538: itemkey => itemKey,
1539: aname => 'TOP_PROCESS_ITEM_KEY');
1540:
1541: wf_engine.SetItemAttrText (itemtype => itemtype,
1542: itemkey => l_top_process_item_key,
1543: aname => 'APPOVER',
1544: avalue => l_user_name);
1545:
1542: itemkey => l_top_process_item_key,
1543: aname => 'APPOVER',
1544: avalue => l_user_name);
1545:
1546: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1547: itemkey => l_top_process_item_key,
1548: aname => 'APPOVER_ID',
1549: avalue => l_user_id);
1550:
1552: if (Is_Valid_Response(l_auction_header_id,l_user_id) = 'N') then
1553: /* Responder is not a valid approver. Ignore this response */
1554: return;
1555: end if;
1556: wf_engine.SetItemAttrText (itemtype => itemtype,
1557: itemkey => l_top_process_item_key,
1558: aname => 'NOTE_TO_BUYER_ON_REJECT',
1559: avalue => l_notes);
1560:
1639: l_signed_date DATE;
1640: l_is_amendment varchar2(1);
1641:
1642: Begin
1643: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1644: itemkey => itemkey,
1645: aname => 'AUCTION_HEADER_ID');
1646:
1647: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1643: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1644: itemkey => itemkey,
1645: aname => 'AUCTION_HEADER_ID');
1646:
1647: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1648: itemkey => itemkey,
1649: aname => 'CREATOR_USER_ID');
1650:
1651: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1647: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1648: itemkey => itemkey,
1649: aname => 'CREATOR_USER_ID');
1650:
1651: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1652: itemkey => itemkey,
1653: aname => 'TRADING_PARTNER_CONTACT_ID');
1654:
1655:
1652: itemkey => itemkey,
1653: aname => 'TRADING_PARTNER_CONTACT_ID');
1654:
1655:
1656: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
1657: itemkey => itemKey,
1658: aname => 'PREVIEW_DATE');
1659: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1660: itemkey => itemKey,
1655:
1656: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
1657: itemkey => itemKey,
1658: aname => 'PREVIEW_DATE');
1659: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1660: itemkey => itemKey,
1661: aname => 'TP_TIME_ZONE1');
1662:
1663: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
1659: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1660: itemkey => itemKey,
1661: aname => 'TP_TIME_ZONE1');
1662:
1663: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
1664: itemkey => itemKey,
1665: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1666: SELECT max(action_date)
1667: INTO l_approve_date
1692:
1693: -- Set the dates based on the user's time zone
1694: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1695:
1696: wf_engine.SetItemAttrDate (itemtype => itemType,
1697: itemkey => itemKey,
1698: aname => 'APPROVE_DATE',
1699: avalue => l_approve_date_in_tz);
1700:
1697: itemkey => itemKey,
1698: aname => 'APPROVE_DATE',
1699: avalue => l_approve_date_in_tz);
1700:
1701: wf_engine.SetItemAttrText (itemtype => itemType,
1702: itemkey => itemKey,
1703: aname => 'TIMEZONE',
1704: avalue => l_timezone_disp);
1705:
1703: aname => 'TIMEZONE',
1704: avalue => l_timezone_disp);
1705:
1706: --added BY amundhra for federal CLM
1707: -- l_is_federal := wf_engine.getItemAttrNumber (itemtype => itemType,
1708: -- itemkey => itemKey,
1709: -- aname => 'IS_FEDERAL');
1710:
1711: /* For CLM ST bug 9766460 : Commented below line
1757: --added by amundhra for Federal CLM
1758: l_signed_date DATE;
1759:
1760: Begin
1761: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1762: itemkey => itemkey,
1763: aname => 'AUCTION_HEADER_ID');
1764:
1765: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1761: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1762: itemkey => itemkey,
1763: aname => 'AUCTION_HEADER_ID');
1764:
1765: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1766: itemkey => itemkey,
1767: aname => 'CREATOR_USER_ID');
1768:
1769: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1765: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1766: itemkey => itemkey,
1767: aname => 'CREATOR_USER_ID');
1768:
1769: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1770: itemkey => itemkey,
1771: aname => 'NOTE_TO_BUYER_ON_REJECT');
1772:
1773: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1769: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1770: itemkey => itemkey,
1771: aname => 'NOTE_TO_BUYER_ON_REJECT');
1772:
1773: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1774: itemkey => itemkey,
1775: aname => 'TRADING_PARTNER_CONTACT_ID');
1776:
1777:
1774: itemkey => itemkey,
1775: aname => 'TRADING_PARTNER_CONTACT_ID');
1776:
1777:
1778: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
1779: itemkey => itemKey,
1780: aname => 'PREVIEW_DATE');
1781:
1782:
1779: itemkey => itemKey,
1780: aname => 'PREVIEW_DATE');
1781:
1782:
1783: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1784: itemkey => itemKey,
1785: aname => 'TP_TIME_ZONE1');
1786:
1787: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
1783: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1784: itemkey => itemKey,
1785: aname => 'TP_TIME_ZONE1');
1786:
1787: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
1788: itemkey => itemKey,
1789: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1790:
1791: SELECT max(action_date)
1817:
1818: -- Set the dates based on the user's time zone
1819: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1820:
1821: wf_engine.SetItemAttrDate (itemtype => itemType,
1822: itemkey => itemKey,
1823: aname => 'REJECT_DATE',
1824: avalue => l_reject_date_in_tz);
1825:
1822: itemkey => itemKey,
1823: aname => 'REJECT_DATE',
1824: avalue => l_reject_date_in_tz);
1825:
1826: wf_engine.SetItemAttrText (itemtype => itemType,
1827: itemkey => itemKey,
1828: aname => 'TIMEZONE',
1829: avalue => l_timezone_disp);
1830:
1865: l_status Varchar2(30) := 'TIMEOUT';
1866: l_user_id Number;
1867: l_rejection_note Varchar2(2000);
1868: Begin
1869: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1870: itemkey => itemkey,
1871: aname => 'AUCTION_HEADER_ID');
1872:
1873: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1869: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1870: itemkey => itemkey,
1871: aname => 'AUCTION_HEADER_ID');
1872:
1873: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1874: itemkey => itemkey,
1875: aname => 'CREATOR_USER_ID');
1876:
1877: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1873: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1874: itemkey => itemkey,
1875: aname => 'CREATOR_USER_ID');
1876:
1877: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1878: itemkey => itemkey,
1879: aname => 'NOTE_TO_BUYER_ON_REJECT');
1880:
1881: UPD_AUCTION_STATUSHISTORY(l_auction_header_id,
2032: BEGIN
2033:
2034:
2035: if (p_amendment_number is not null and p_amendment_number > 0) then
2036: wf_engine.SetItemAttrText (itemtype => p_itemType,
2037: itemkey => p_itemKey,
2038: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
2039: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2040:
2037: itemkey => p_itemKey,
2038: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
2039: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2040:
2041: wf_engine.SetItemAttrText (itemtype => p_itemType,
2042: itemkey => p_itemKey,
2043: aname => 'PON_AUC_APPR_REMINDER_SUB',
2044: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
2045:
2043: aname => 'PON_AUC_APPR_REMINDER_SUB',
2044: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
2045:
2046: --added for eric test,begin
2047: wf_engine.SetItemAttrText (itemtype => p_itemType,
2048: itemkey => p_itemKey,
2049: aname => 'EMD_REQ_FOR_APPROVALS_SUBJECT',
2050: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2051:
2048: itemkey => p_itemKey,
2049: aname => 'EMD_REQ_FOR_APPROVALS_SUBJECT',
2050: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2051:
2052: wf_engine.SetItemAttrText (itemtype => p_itemType,
2053: itemkey => p_itemKey,
2054: aname => 'EMD_PON_AUC_APPR_REMINDER_SUB',
2055: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
2056:
2056:
2057: --added for eric test,end
2058:
2059:
2060: wf_engine.SetItemAttrText (itemtype => p_itemType,
2061: itemkey => p_itemKey,
2062: aname => 'DOC_APPROVED_MAIL_SUBJECT',
2063: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_APPRD_SUBJECT',p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2064:
2061: itemkey => p_itemKey,
2062: aname => 'DOC_APPROVED_MAIL_SUBJECT',
2063: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_APPRD_SUBJECT',p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2064:
2065: wf_engine.SetItemAttrText (itemtype => p_itemType,
2066: itemkey => p_itemKey,
2067: aname => 'DOC_REJECTED_MAIL_SUBJECT',
2068: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REJ_SUBJECT', p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2069:
2067: aname => 'DOC_REJECTED_MAIL_SUBJECT',
2068: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REJ_SUBJECT', p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2069:
2070: else
2071: wf_engine.SetItemAttrText (itemtype => p_itemType,
2072: itemkey => p_itemKey,
2073: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
2074: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
2075:
2073: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
2074: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
2075:
2076:
2077: wf_engine.SetItemAttrText (itemtype => p_itemType,
2078: itemkey => p_itemKey,
2079: aname => 'PON_AUC_APPR_REMINDER_SUB',
2080: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
2081:
2080: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
2081:
2082:
2083: --added for eric test,begin
2084: wf_engine.SetItemAttrText (itemtype => p_itemType,
2085: itemkey => p_itemKey,
2086: aname => 'EMD_REQ_FOR_APPROVALS_SUBJECT',
2087: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
2088:
2085: itemkey => p_itemKey,
2086: aname => 'EMD_REQ_FOR_APPROVALS_SUBJECT',
2087: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
2088:
2089: wf_engine.SetItemAttrText (itemtype => p_itemType,
2090: itemkey => p_itemKey,
2091: aname => 'EMD_PON_AUC_APPR_REMINDER_SUB',
2092: avalue => 'EMD '|| PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
2093:
2093:
2094: --added for eric test,end
2095:
2096:
2097: wf_engine.SetItemAttrText (itemtype => p_itemType,
2098: itemkey => p_itemKey,
2099: aname => 'DOC_APPROVED_MAIL_SUBJECT',
2100: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_APPRD_SUBJECT',p_msg_suffix, 'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
2101:
2098: itemkey => p_itemKey,
2099: aname => 'DOC_APPROVED_MAIL_SUBJECT',
2100: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_APPRD_SUBJECT',p_msg_suffix, 'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
2101:
2102: wf_engine.SetItemAttrText (itemtype => p_itemType,
2103: itemkey => p_itemKey,
2104: aname => 'DOC_REJECTED_MAIL_SUBJECT',
2105: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REJ_SUBJECT', p_msg_suffix,'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
2106: end if;
2188: BEGIN
2189: --INSERT INTO ERIC_LOG VALUES ('INTO StartEmdApprovalProcess','','','','','','','');--for eric test only
2190: l_timeout_factor := .5; -- use to get this value from an item attribute
2191:
2192: l_preparer_tp_name := wf_engine.GetItemAttrText( itemtype => itemType
2193: , itemkey => itemKey
2194: , aname => 'PREPARER_TP_NAME');
2195:
2196: l_auction_title := wf_engine.GetItemAttrText( itemtype => itemType
2192: l_preparer_tp_name := wf_engine.GetItemAttrText( itemtype => itemType
2193: , itemkey => itemKey
2194: , aname => 'PREPARER_TP_NAME');
2195:
2196: l_auction_title := wf_engine.GetItemAttrText( itemtype => itemType
2197: , itemkey => itemKey
2198: , aname => 'AUCTION_TITLE');
2199:
2200: l_doc_number := wf_engine.GetItemAttrText( itemtype => itemType
2196: l_auction_title := wf_engine.GetItemAttrText( itemtype => itemType
2197: , itemkey => itemKey
2198: , aname => 'AUCTION_TITLE');
2199:
2200: l_doc_number := wf_engine.GetItemAttrText( itemtype => itemType
2201: , itemkey => itemKey
2202: , aname => 'DOC_NUMBER');
2203:
2204: l_preparer_tp_contact_name := wf_engine.GetItemAttrText( itemtype => itemType
2200: l_doc_number := wf_engine.GetItemAttrText( itemtype => itemType
2201: , itemkey => itemKey
2202: , aname => 'DOC_NUMBER');
2203:
2204: l_preparer_tp_contact_name := wf_engine.GetItemAttrText( itemtype => itemType
2205: , itemkey => itemKey
2206: , aname => 'PREPARER_TP_CONTACT_NAME');
2207:
2208: l_auction_start_date := wf_engine.GetItemAttrDate( itemtype => itemType
2204: l_preparer_tp_contact_name := wf_engine.GetItemAttrText( itemtype => itemType
2205: , itemkey => itemKey
2206: , aname => 'PREPARER_TP_CONTACT_NAME');
2207:
2208: l_auction_start_date := wf_engine.GetItemAttrDate( itemtype => itemType
2209: , itemkey => itemKey
2210: , aname => 'AUCTION_START_DATE');
2211:
2212: l_auction_end_date := wf_engine.GetItemAttrDate( itemtype => itemType
2208: l_auction_start_date := wf_engine.GetItemAttrDate( itemtype => itemType
2209: , itemkey => itemKey
2210: , aname => 'AUCTION_START_DATE');
2211:
2212: l_auction_end_date := wf_engine.GetItemAttrDate( itemtype => itemType
2213: , itemkey => itemKey
2214: , aname => 'AUCTION_END_DATE');
2215:
2216: l_timezone_dsp := wf_engine.GetItemAttrText( itemtype => itemType
2212: l_auction_end_date := wf_engine.GetItemAttrDate( itemtype => itemType
2213: , itemkey => itemKey
2214: , aname => 'AUCTION_END_DATE');
2215:
2216: l_timezone_dsp := wf_engine.GetItemAttrText( itemtype => itemType
2217: , itemkey => itemKey
2218: , aname => 'TIMEZONE');
2219:
2220: l_note_to_approvers := wf_engine.GetItemAttrText( itemtype => itemType
2216: l_timezone_dsp := wf_engine.GetItemAttrText( itemtype => itemType
2217: , itemkey => itemKey
2218: , aname => 'TIMEZONE');
2219:
2220: l_note_to_approvers := wf_engine.GetItemAttrText( itemtype => itemType
2221: , itemkey => itemKey
2222: , aname => 'NOTE_TO_APPROVERS');
2223:
2224: l_preview_date_in_tz := wf_engine.GetItemAttrDate( itemtype => itemType
2220: l_note_to_approvers := wf_engine.GetItemAttrText( itemtype => itemType
2221: , itemkey => itemKey
2222: , aname => 'NOTE_TO_APPROVERS');
2223:
2224: l_preview_date_in_tz := wf_engine.GetItemAttrDate( itemtype => itemType
2225: , itemkey => itemKey
2226: , aname => 'PREVIEW_DATE');
2227: l_timezone1_disp := wf_engine.GetItemAttrText( itemtype => itemType
2228: , itemkey => itemKey
2223:
2224: l_preview_date_in_tz := wf_engine.GetItemAttrDate( itemtype => itemType
2225: , itemkey => itemKey
2226: , aname => 'PREVIEW_DATE');
2227: l_timezone1_disp := wf_engine.GetItemAttrText( itemtype => itemType
2228: , itemkey => itemKey
2229: , aname => 'TP_TIME_ZONE1');
2230:
2231: l_preview_date_nspec := wf_engine.GetItemAttrText( itemtype => itemType
2227: l_timezone1_disp := wf_engine.GetItemAttrText( itemtype => itemType
2228: , itemkey => itemKey
2229: , aname => 'TP_TIME_ZONE1');
2230:
2231: l_preview_date_nspec := wf_engine.GetItemAttrText( itemtype => itemType
2232: , itemkey => itemKey
2233: , aname => 'PREVIEW_DATE_NOTSPECIFIED');
2234: l_msg_suffix := wf_engine.GetItemAttrText( itemtype => itemType
2235: , itemkey => itemKey
2230:
2231: l_preview_date_nspec := wf_engine.GetItemAttrText( itemtype => itemType
2232: , itemkey => itemKey
2233: , aname => 'PREVIEW_DATE_NOTSPECIFIED');
2234: l_msg_suffix := wf_engine.GetItemAttrText( itemtype => itemType
2235: , itemkey => itemKey
2236: , aname => 'MSG_SUFFIX');
2237:
2238: l_auction_header_id := wf_engine.GetItemAttrNumber( itemtype => itemType
2234: l_msg_suffix := wf_engine.GetItemAttrText( itemtype => itemType
2235: , itemkey => itemKey
2236: , aname => 'MSG_SUFFIX');
2237:
2238: l_auction_header_id := wf_engine.GetItemAttrNumber( itemtype => itemType
2239: , itemkey => itemKey
2240: , aname => 'AUCTION_HEADER_ID');
2241:
2242: l_round_number := wf_engine.GetItemAttrNumber( itemtype => itemType
2238: l_auction_header_id := wf_engine.GetItemAttrNumber( itemtype => itemType
2239: , itemkey => itemKey
2240: , aname => 'AUCTION_HEADER_ID');
2241:
2242: l_round_number := wf_engine.GetItemAttrNumber( itemtype => itemType
2243: , itemkey => itemKey
2244: , aname => 'DOC_ROUND_NUMBER');
2245:
2246: l_amendment_number := wf_engine.GetItemAttrNumber( itemtype => itemType
2242: l_round_number := wf_engine.GetItemAttrNumber( itemtype => itemType
2243: , itemkey => itemKey
2244: , aname => 'DOC_ROUND_NUMBER');
2245:
2246: l_amendment_number := wf_engine.GetItemAttrNumber( itemtype => itemType
2247: , itemkey => itemKey
2248: , aname => 'DOC_AMENDMENT_NUMBER');
2249:
2250: l_creator_full_name := wf_engine.GetItemAttrText( itemtype => itemType
2246: l_amendment_number := wf_engine.GetItemAttrNumber( itemtype => itemType
2247: , itemkey => itemKey
2248: , aname => 'DOC_AMENDMENT_NUMBER');
2249:
2250: l_creator_full_name := wf_engine.GetItemAttrText( itemtype => itemType
2251: , itemkey => itemKey
2252: , aname => 'AUCTIONEER_NAME');
2253:
2254: l_redirect_func := wf_engine.GetItemAttrText( itemtype => itemType
2250: l_creator_full_name := wf_engine.GetItemAttrText( itemtype => itemType
2251: , itemkey => itemKey
2252: , aname => 'AUCTIONEER_NAME');
2253:
2254: l_redirect_func := wf_engine.GetItemAttrText( itemtype => itemType
2255: , itemkey => itemKey
2256: , aname => 'REVIEWPG_REDIRECTFUNC');
2257:
2258: /* Preserve creator's session language */
2255: , itemkey => itemKey
2256: , aname => 'REVIEWPG_REDIRECTFUNC');
2257:
2258: /* Preserve creator's session language */
2259: l_creator_user_name := wf_engine.GetItemAttrText( itemtype => itemType
2260: , itemkey => itemKey
2261: , aname => 'CREATOR_USER_NAME');
2262:
2263: l_creator_user_id := wf_engine.GetItemAttrNumber( itemtype => itemType
2259: l_creator_user_name := wf_engine.GetItemAttrText( itemtype => itemType
2260: , itemkey => itemKey
2261: , aname => 'CREATOR_USER_NAME');
2262:
2263: l_creator_user_id := wf_engine.GetItemAttrNumber( itemtype => itemType
2264: , itemkey => itemKey
2265: , aname => 'CREATOR_USER_ID');
2266:
2267: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE( l_creator_user_id
2311: END IF;
2312:
2313: l_itemKey := itemkey || '_EMD_' || r1.user_id;
2314:
2315: wf_engine.createProcess( itemType => l_itemType
2316: , itemKey => l_itemKey
2317: , process => 'EMDAPPROVALS');
2318:
2319: IF (r1.view_by_date IS NOT NULL)
2330: INTO l_reminder_date
2331: FROM dual;
2332:
2333:
2334: wf_engine.SetItemAttrDate( itemtype => l_itemType
2335: , itemkey => l_itemKey
2336: , aname => 'TIMEOUT_USERPROCESS'
2337: , avalue => l_reminder_date);
2338: wf_engine.SetItemAttrText( itemtype => l_itemType
2334: wf_engine.SetItemAttrDate( itemtype => l_itemType
2335: , itemkey => l_itemKey
2336: , aname => 'TIMEOUT_USERPROCESS'
2337: , avalue => l_reminder_date);
2338: wf_engine.SetItemAttrText( itemtype => l_itemType
2339: , itemkey => l_itemKey
2340: , aname => 'CREATOR_USER_NAME'
2341: , avalue => l_creator_user_name);
2342: wf_engine.SetItemAttrNumber( itemtype => l_itemType
2338: wf_engine.SetItemAttrText( itemtype => l_itemType
2339: , itemkey => l_itemKey
2340: , aname => 'CREATOR_USER_NAME'
2341: , avalue => l_creator_user_name);
2342: wf_engine.SetItemAttrNumber( itemtype => l_itemType
2343: , itemkey => l_itemKey
2344: , aname => 'CREATOR_USER_ID'
2345: , avalue => l_creator_user_id);
2346: wf_engine.SetItemAttrText( itemtype => l_itemType
2342: wf_engine.SetItemAttrNumber( itemtype => l_itemType
2343: , itemkey => l_itemKey
2344: , aname => 'CREATOR_USER_ID'
2345: , avalue => l_creator_user_id);
2346: wf_engine.SetItemAttrText( itemtype => l_itemType
2347: , itemkey => l_itemKey
2348: , aname => 'REVIEWPG_REDIRECTFUNC'
2349: , avalue => l_redirect_func);
2350: wf_engine.SetItemAttrText( itemtype => l_itemType
2346: wf_engine.SetItemAttrText( itemtype => l_itemType
2347: , itemkey => l_itemKey
2348: , aname => 'REVIEWPG_REDIRECTFUNC'
2349: , avalue => l_redirect_func);
2350: wf_engine.SetItemAttrText( itemtype => l_itemType
2351: , itemkey => l_itemKey
2352: , aname => 'PREPARER_TP_NAME'
2353: , avalue => l_preparer_tp_name);
2354: wf_engine.SetItemAttrText( itemtype => l_itemType
2350: wf_engine.SetItemAttrText( itemtype => l_itemType
2351: , itemkey => l_itemKey
2352: , aname => 'PREPARER_TP_NAME'
2353: , avalue => l_preparer_tp_name);
2354: wf_engine.SetItemAttrText( itemtype => l_itemType
2355: , itemkey => l_itemKey
2356: , aname => 'AUCTION_TITLE'
2357: , avalue => l_auction_title);
2358: wf_engine.SetItemAttrText( itemtype => l_itemType
2354: wf_engine.SetItemAttrText( itemtype => l_itemType
2355: , itemkey => l_itemKey
2356: , aname => 'AUCTION_TITLE'
2357: , avalue => l_auction_title);
2358: wf_engine.SetItemAttrText( itemtype => l_itemType
2359: , itemkey => l_itemKey
2360: , aname => 'DOC_NUMBER'
2361: , avalue => l_doc_number);
2362: wf_engine.SetItemAttrText( itemtype => l_itemType
2358: wf_engine.SetItemAttrText( itemtype => l_itemType
2359: , itemkey => l_itemKey
2360: , aname => 'DOC_NUMBER'
2361: , avalue => l_doc_number);
2362: wf_engine.SetItemAttrText( itemtype => l_itemType
2363: , itemkey => l_itemKey
2364: , aname => 'PREPARER_TP_CONTACT_NAME'
2365: , avalue => l_preparer_tp_contact_name);
2366: wf_engine.SetItemAttrDate( itemtype => l_itemType
2362: wf_engine.SetItemAttrText( itemtype => l_itemType
2363: , itemkey => l_itemKey
2364: , aname => 'PREPARER_TP_CONTACT_NAME'
2365: , avalue => l_preparer_tp_contact_name);
2366: wf_engine.SetItemAttrDate( itemtype => l_itemType
2367: , itemkey => l_itemKey
2368: , aname => 'AUCTION_START_DATE'
2369: , avalue => l_auction_start_date);
2370: wf_engine.SetItemAttrDate( itemtype => l_itemType
2366: wf_engine.SetItemAttrDate( itemtype => l_itemType
2367: , itemkey => l_itemKey
2368: , aname => 'AUCTION_START_DATE'
2369: , avalue => l_auction_start_date);
2370: wf_engine.SetItemAttrDate( itemtype => l_itemType
2371: , itemkey => l_itemKey
2372: , aname => 'AUCTION_END_DATE'
2373: , avalue => l_auction_end_date);
2374: wf_engine.SetItemAttrText( itemtype => l_itemType
2370: wf_engine.SetItemAttrDate( itemtype => l_itemType
2371: , itemkey => l_itemKey
2372: , aname => 'AUCTION_END_DATE'
2373: , avalue => l_auction_end_date);
2374: wf_engine.SetItemAttrText( itemtype => l_itemType
2375: , itemkey => l_itemKey
2376: , aname => 'TIMEZONE'
2377: , avalue => l_timezone_dsp);
2378: wf_engine.SetItemAttrDate( itemtype => l_itemType
2374: wf_engine.SetItemAttrText( itemtype => l_itemType
2375: , itemkey => l_itemKey
2376: , aname => 'TIMEZONE'
2377: , avalue => l_timezone_dsp);
2378: wf_engine.SetItemAttrDate( itemtype => l_itemType
2379: , itemkey => l_itemKey
2380: , aname => 'PREVIEW_DATE'
2381: , avalue => l_preview_date_in_tz);
2382: wf_engine.SetItemAttrText( itemtype => l_itemType
2378: wf_engine.SetItemAttrDate( itemtype => l_itemType
2379: , itemkey => l_itemKey
2380: , aname => 'PREVIEW_DATE'
2381: , avalue => l_preview_date_in_tz);
2382: wf_engine.SetItemAttrText( itemtype => l_itemType
2383: , itemkey => l_itemKey
2384: , aname => 'TP_TIME_ZONE1'
2385: , avalue => l_timezone1_disp);
2386: wf_engine.SetItemAttrText( itemtype => l_itemType
2382: wf_engine.SetItemAttrText( itemtype => l_itemType
2383: , itemkey => l_itemKey
2384: , aname => 'TP_TIME_ZONE1'
2385: , avalue => l_timezone1_disp);
2386: wf_engine.SetItemAttrText( itemtype => l_itemType
2387: , itemkey => l_itemKey
2388: , aname => 'PREVIEW_DATE_NOTSPECIFIED'
2389: , avalue => l_preview_date_nspec);
2390: wf_engine.SetItemAttrText( itemtype => l_itemType
2386: wf_engine.SetItemAttrText( itemtype => l_itemType
2387: , itemkey => l_itemKey
2388: , aname => 'PREVIEW_DATE_NOTSPECIFIED'
2389: , avalue => l_preview_date_nspec);
2390: wf_engine.SetItemAttrText( itemtype => l_itemType
2391: , itemkey => l_itemKey
2392: , aname => 'NOTE_TO_APPROVERS'
2393: , avalue => l_note_to_approvers);
2394: wf_engine.SetItemAttrText( itemtype => l_itemType
2390: wf_engine.SetItemAttrText( itemtype => l_itemType
2391: , itemkey => l_itemKey
2392: , aname => 'NOTE_TO_APPROVERS'
2393: , avalue => l_note_to_approvers);
2394: wf_engine.SetItemAttrText( itemtype => l_itemType
2395: , itemkey => l_itemKey
2396: , aname => 'TOP_PROCESS_ITEM_KEY'
2397: , avalue => wf_engine.GetItemAttrText( itemtype => l_itemType
2398: , itemkey => itemKey
2393: , avalue => l_note_to_approvers);
2394: wf_engine.SetItemAttrText( itemtype => l_itemType
2395: , itemkey => l_itemKey
2396: , aname => 'TOP_PROCESS_ITEM_KEY'
2397: , avalue => wf_engine.GetItemAttrText( itemtype => l_itemType
2398: , itemkey => itemKey
2399: , aname => 'TOP_PROCESS_ITEM_KEY'
2400: )
2401: );
2398: , itemkey => itemKey
2399: , aname => 'TOP_PROCESS_ITEM_KEY'
2400: )
2401: );
2402: wf_engine.SetItemAttrNumber( itemtype => l_itemType
2403: , itemkey => l_itemKey
2404: , aname => 'AUCTION_HEADER_ID'
2405: , avalue => l_auction_header_id);
2406: /*
2403: , itemkey => l_itemKey
2404: , aname => 'AUCTION_HEADER_ID'
2405: , avalue => l_auction_header_id);
2406: /*
2407: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
2408: itemkey => l_itemKey,
2409: aname => 'DOC_ROUND_NUMBER',
2410: avalue => l_round_number);
2411:
2408: itemkey => l_itemKey,
2409: aname => 'DOC_ROUND_NUMBER',
2410: avalue => l_round_number);
2411:
2412: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
2413: itemkey => l_itemKey,
2414: aname => 'DOC_AMENDMENT_NUMBER',
2415: avalue => l_amendment_number);
2416: */
2421: p_dest_func => 'PON_NEG_CRT_HEADER'
2422: ,p_notif_performer => 'BUYER');*/
2423:
2424:
2425: wf_engine.SetItemAttrText( itemtype => l_itemType
2426: , itemkey => l_itemKey
2427: , aname => 'REVIEW_EMD_CHANGES_URL'
2428: , avalue => l_review_emd_changes_url);
2429:
2431: l_review_changes_url := pon_wf_utl_pkg.get_dest_page_url (
2432: p_dest_func => 'PON_NEG_CRT_HEADER'
2433: ,p_notif_performer => 'BUYER');
2434:
2435: wf_engine.SetItemAttrText (itemtype => l_itemType,
2436: itemkey => l_itemKey,
2437: aname => 'REVIEW_CHANGES_URL',
2438: avalue => l_review_changes_url);
2439:
2436: itemkey => l_itemKey,
2437: aname => 'REVIEW_CHANGES_URL',
2438: avalue => l_review_changes_url);
2439:
2440: wf_engine.SetItemAttrText( itemtype => l_itemType
2441: , itemkey => l_itemKey
2442: , aname => 'EMD_APPROVER'
2443: , avalue => r1.user_name);
2444:
2441: , itemkey => l_itemKey
2442: , aname => 'EMD_APPROVER'
2443: , avalue => r1.user_name);
2444:
2445: wf_engine.SetItemAttrNumber( itemtype => l_itemType
2446: , itemkey => l_itemKey
2447: , aname => 'EMD_APPROVER_ID'
2448: , avalue => r1.user_id);
2449:
2446: , itemkey => l_itemKey
2447: , aname => 'EMD_APPROVER_ID'
2448: , avalue => r1.user_id);
2449:
2450: wf_engine.SetItemAttrText( itemtype => l_itemType
2451: , itemkey => l_itemKey
2452: , aname => 'ORIGIN_USER_NAME'
2453: , avalue => fnd_global.user_name);
2454:
2462: END IF;
2463:
2464: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone,l_language_code);
2465:
2466: wf_engine.SetItemAttrText( itemtype => l_itemType
2467: , itemkey => l_itemKey
2468: , aname => 'TIMEZONE'
2469: , avalue => l_timezone_disp);
2470:
2474: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME( r1.close_bidding_date
2475: , l_oex_timezone
2476: , l_timezone);
2477:
2478: wf_engine.SetItemAttrDate(itemtype => l_itemType
2479: ,itemkey => l_itemKey
2480: ,aname => 'AUCTION_START_DATE'
2481: ,avalue => l_open_date_in_tz);
2482: IF (r1.open_auction_now_flag = 'Y')
2480: ,aname => 'AUCTION_START_DATE'
2481: ,avalue => l_open_date_in_tz);
2482: IF (r1.open_auction_now_flag = 'Y')
2483: THEN
2484: wf_engine.SetItemAttrText( itemtype => l_itemType
2485: , itemkey => l_itemKey
2486: , aname => 'OPEN_IMMEDIATELY'
2487: , avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB'
2488: ,l_msg_suffix));
2486: , aname => 'OPEN_IMMEDIATELY'
2487: , avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB'
2488: ,l_msg_suffix));
2489:
2490: wf_engine.SetItemAttrText( itemtype => l_itemType
2491: , itemkey => l_itemKey
2492: , aname => 'O_TIMEZONE'
2493: , avalue => NULL);
2494: ELSE
2491: , itemkey => l_itemKey
2492: , aname => 'O_TIMEZONE'
2493: , avalue => NULL);
2494: ELSE
2495: wf_engine.SetItemAttrText( itemtype => l_itemType
2496: , itemkey => l_itemKey
2497: , aname => 'OPEN_IMMEDIATELY'
2498: , avalue => NULL);
2499:
2496: , itemkey => l_itemKey
2497: , aname => 'OPEN_IMMEDIATELY'
2498: , avalue => NULL);
2499:
2500: wf_engine.SetItemAttrText( itemtype => l_itemType
2501: , itemkey => l_itemKey
2502: , aname => 'O_TIMEZONE'
2503: , avalue => l_timezone_disp);
2504: END IF;
2502: , aname => 'O_TIMEZONE'
2503: , avalue => l_timezone_disp);
2504: END IF;
2505:
2506: wf_engine.SetItemAttrDate( itemtype => l_itemType
2507: , itemkey => l_itemKey
2508: , aname => 'AUCTION_END_DATE'
2509: , avalue => l_close_date_in_tz);
2510:
2507: , itemkey => l_itemKey
2508: , aname => 'AUCTION_END_DATE'
2509: , avalue => l_close_date_in_tz);
2510:
2511: wf_engine.SetItemAttrText( itemtype => l_itemType
2512: , itemkey => l_itemKey
2513: , aname => 'NOTE_TO_APPROVERS'
2514: , avalue => l_note_to_approvers);
2515:
2527: , l_amendment_number
2528: , l_auction_title);
2529:
2530: -- Bug 4295915: Set the workflow owner
2531: wf_engine.SetItemOwner( itemtype => l_itemtype
2532: , itemkey => l_itemkey
2533: , owner => fnd_global.user_name);
2534:
2535: wf_engine.StartProcess( itemType => l_itemType
2531: wf_engine.SetItemOwner( itemtype => l_itemtype
2532: , itemkey => l_itemkey
2533: , owner => fnd_global.user_name);
2534:
2535: wf_engine.StartProcess( itemType => l_itemType
2536: , itemKey => l_itemKey);
2537:
2538: --dbms_output.put_line('EMDAPPROVALS: Started: '||l_itemType ||l_itemKey);-- for eric test only
2539: END LOOP;
2562: lv_wf_source VARCHAR2(10) := 'EMD'; --FOR ERIC TEST ONLY
2563: BEGIN
2564: --INSERT INTO ERIC_LOG VALUES ('INTO Emd_User_Approved','','','','','','','');--for eric test only
2565: /* Get auction header id from the workflow */
2566: l_auction_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype
2567: , itemkey => itemkey
2568: , aname => 'AUCTION_HEADER_ID');
2569:
2570: l_user_name := wf_engine.GetItemAttrText( itemtype => itemtype
2566: l_auction_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype
2567: , itemkey => itemkey
2568: , aname => 'AUCTION_HEADER_ID');
2569:
2570: l_user_name := wf_engine.GetItemAttrText( itemtype => itemtype
2571: , itemkey => itemkey
2572: , aname => 'EMD_APPROVER');
2573:
2574: l_user_id := wf_engine.GetItemAttrNumber( itemtype => itemtype
2570: l_user_name := wf_engine.GetItemAttrText( itemtype => itemtype
2571: , itemkey => itemkey
2572: , aname => 'EMD_APPROVER');
2573:
2574: l_user_id := wf_engine.GetItemAttrNumber( itemtype => itemtype
2575: , itemkey => itemkey
2576: , aname => 'EMD_APPROVER_ID');
2577:
2578: l_notes := wf_engine.GetItemAttrText( itemtype => itemtype
2574: l_user_id := wf_engine.GetItemAttrNumber( itemtype => itemtype
2575: , itemkey => itemkey
2576: , aname => 'EMD_APPROVER_ID');
2577:
2578: l_notes := wf_engine.GetItemAttrText( itemtype => itemtype
2579: , itemkey => itemkey
2580: , aname => 'APPROVER_NOTES');
2581:
2582: l_top_process_item_key := wf_engine.GetItemAttrText( itemtype => itemType
2578: l_notes := wf_engine.GetItemAttrText( itemtype => itemtype
2579: , itemkey => itemkey
2580: , aname => 'APPROVER_NOTES');
2581:
2582: l_top_process_item_key := wf_engine.GetItemAttrText( itemtype => itemType
2583: , itemkey => itemKey
2584: , aname => 'TOP_PROCESS_ITEM_KEY');
2585:
2586: wf_engine.SetItemAttrNumber( itemtype => itemtype
2582: l_top_process_item_key := wf_engine.GetItemAttrText( itemtype => itemType
2583: , itemkey => itemKey
2584: , aname => 'TOP_PROCESS_ITEM_KEY');
2585:
2586: wf_engine.SetItemAttrNumber( itemtype => itemtype
2587: , itemkey => l_top_process_item_key
2588: , aname => 'EMD_APPROVER_ID'
2589: , avalue => l_user_id
2590: );
2588: , aname => 'EMD_APPROVER_ID'
2589: , avalue => l_user_id
2590: );
2591:
2592: wf_engine.SetItemAttrText( itemtype => itemtype
2593: , itemkey => l_top_process_item_key
2594: , aname => 'EMD_APPROVER'
2595: , avalue => l_user_name
2596: );
2643: lv_wf_source VARCHAR2(10) := 'EMD'; --FOR ERIC TEST ONLY
2644: BEGIN
2645:
2646: /* Get auction header id from the workflow */
2647: l_auction_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype
2648: , itemkey => itemkey
2649: , aname => 'AUCTION_HEADER_ID'
2650: );
2651:
2648: , itemkey => itemkey
2649: , aname => 'AUCTION_HEADER_ID'
2650: );
2651:
2652: l_user_name := wf_engine.GetItemAttrText( itemtype => itemtype
2653: , itemkey => itemkey
2654: , aname => 'EMD_APPROVER'
2655: );
2656:
2653: , itemkey => itemkey
2654: , aname => 'EMD_APPROVER'
2655: );
2656:
2657: l_user_id := wf_engine.GetItemAttrNumber( itemtype => itemtype
2658: , itemkey => itemkey
2659: , aname => 'EMD_APPROVER_ID'
2660: );
2661:
2658: , itemkey => itemkey
2659: , aname => 'EMD_APPROVER_ID'
2660: );
2661:
2662: l_notes := wf_engine.GetItemAttrText( itemtype => itemtype
2663: , itemkey => itemkey
2664: , aname => 'APPROVER_NOTES');
2665:
2666: l_top_process_item_key := wf_engine.GetItemAttrText( itemtype => itemType
2662: l_notes := wf_engine.GetItemAttrText( itemtype => itemtype
2663: , itemkey => itemkey
2664: , aname => 'APPROVER_NOTES');
2665:
2666: l_top_process_item_key := wf_engine.GetItemAttrText( itemtype => itemType
2667: , itemkey => itemKey
2668: , aname => 'TOP_PROCESS_ITEM_KEY'
2669: );
2670:
2667: , itemkey => itemKey
2668: , aname => 'TOP_PROCESS_ITEM_KEY'
2669: );
2670:
2671: wf_engine.SetItemAttrText( itemtype => itemtype
2672: , itemkey => l_top_process_item_key
2673: , aname => 'EMD_APPROVER'
2674: , avalue => l_user_name
2675: );
2673: , aname => 'EMD_APPROVER'
2674: , avalue => l_user_name
2675: );
2676:
2677: wf_engine.SetItemAttrNumber( itemtype => itemtype
2678: , itemkey => l_top_process_item_key
2679: , aname => 'EMD_APPROVER_ID'
2680: , avalue => l_user_id
2681: );
2688: /* Responder is not a valid approver. Ignore this response */
2689: RETURN;
2690: END IF;
2691:
2692: wf_engine.SetItemAttrText( itemtype => itemtype
2693: , itemkey => l_top_process_item_key
2694: , aname => 'NOTE_TO_BUYER_ON_REJECT'
2695: , avalue => l_notes);
2696:
2758:
2759: l_unexp_error VARCHAR2(1) := 'N';
2760:
2761: Begin
2762: l_source_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
2763: itemkey => itemKey,
2764: aname => 'AUCTION_HEADER_ID');
2765:
2766: --print_debug_messages('Start of procedure Create_Cnf_Doc_CLM l_source_auction_header_id : '||l_source_auction_header_id);
2793: FND_MESSAGE.SET_TOKEN('DOC_GROUP','Amendment');
2794: FND_MESSAGE.SET_TOKEN('NUMBER','11111');
2795: FND_MSG_PUB.ADD;*/
2796:
2797: wf_engine.SetItemAttrText (itemtype => itemType,
2798: itemkey => itemKey,
2799: aname => 'IS_COPY_SUCCESS_FED',
2800: avalue => l_return_status);
2801: -- If conc. request is submitted to create conformed document.
2800: avalue => l_return_status);
2801: -- If conc. request is submitted to create conformed document.
2802: if l_return_status = 'CONC_REQ_SUBMITTED' then
2803:
2804: wf_engine.SetItemAttrText (itemtype => itemType,
2805: itemkey => itemKey,
2806: aname => 'IS_CONC_REQUEST',
2807: avalue => 'Y');
2808: wf_engine.SetItemAttrNumber (itemtype => itemType,
2804: wf_engine.SetItemAttrText (itemtype => itemType,
2805: itemkey => itemKey,
2806: aname => 'IS_CONC_REQUEST',
2807: avalue => 'Y');
2808: wf_engine.SetItemAttrNumber (itemtype => itemType,
2809: itemkey => itemKey,
2810: aname => 'CONC_REQUEST_ID_FED',
2811: avalue => l_request_id);
2812: wf_engine.SetItemAttrNumber(itemtype => itemType,
2808: wf_engine.SetItemAttrNumber (itemtype => itemType,
2809: itemkey => itemKey,
2810: aname => 'CONC_REQUEST_ID_FED',
2811: avalue => l_request_id);
2812: wf_engine.SetItemAttrNumber(itemtype => itemType,
2813: itemkey => itemKey,
2814: aname => 'CONF_DOC_AUC_HEAD_ID',
2815: avalue => l_auction_header_id);
2816: wf_engine.SetItemAttrNumber(itemtype => itemType,
2812: wf_engine.SetItemAttrNumber(itemtype => itemType,
2813: itemkey => itemKey,
2814: aname => 'CONF_DOC_AUC_HEAD_ID',
2815: avalue => l_auction_header_id);
2816: wf_engine.SetItemAttrNumber(itemtype => itemType,
2817: itemkey => itemKey,
2818: aname => 'CONF_DOC_REVISION',
2819: avalue => l_revision);
2820: wf_engine.SetItemAttrText(itemtype => itemType,
2816: wf_engine.SetItemAttrNumber(itemtype => itemType,
2817: itemkey => itemKey,
2818: aname => 'CONF_DOC_REVISION',
2819: avalue => l_revision);
2820: wf_engine.SetItemAttrText(itemtype => itemType,
2821: itemkey => itemKey,
2822: aname => 'CONF_DOC_NUMBER',
2823: avalue => l_document_number);
2824:
2821: itemkey => itemKey,
2822: aname => 'CONF_DOC_NUMBER',
2823: avalue => l_document_number);
2824:
2825: l_msg_suffix := wf_engine.GetItemAttrText(itemtype => itemType,
2826: itemkey => itemKey,
2827: aname => 'MSG_SUFFIX');
2828: fnd_message.set_name('PON', 'PON_REVISION_CLM');
2829: fnd_message.set_token('REVISION',to_char(l_revision));
2829: fnd_message.set_token('REVISION',to_char(l_revision));
2830: l_rev_message := fnd_message.get;
2831: fnd_message.set_name('PON','PON_AUCTION_AUCTION'||l_msg_suffix);
2832: l_success_msg := fnd_message.get||' '||l_document_number||l_rev_message;
2833: wf_engine.SetItemAttrText(itemtype => itemType,
2834: itemkey => itemKey,
2835: aname => 'NEW_CONF_DOC_CLM',
2836: avalue => l_success_msg);
2837: else -- If normal copy
2838:
2839: -- If conformed doc copy returned success
2840: if l_return_status = 'S' then
2841:
2842: wf_engine.SetItemAttrNumber(itemtype => itemType,
2843: itemkey => itemKey,
2844: aname => 'CONF_DOC_AUC_HEAD_ID',
2845: avalue => l_auction_header_id);
2846: wf_engine.SetItemAttrNumber(itemtype => itemType,
2842: wf_engine.SetItemAttrNumber(itemtype => itemType,
2843: itemkey => itemKey,
2844: aname => 'CONF_DOC_AUC_HEAD_ID',
2845: avalue => l_auction_header_id);
2846: wf_engine.SetItemAttrNumber(itemtype => itemType,
2847: itemkey => itemKey,
2848: aname => 'CONF_DOC_REVISION',
2849: avalue => l_revision);
2850: wf_engine.SetItemAttrText(itemtype => itemType,
2846: wf_engine.SetItemAttrNumber(itemtype => itemType,
2847: itemkey => itemKey,
2848: aname => 'CONF_DOC_REVISION',
2849: avalue => l_revision);
2850: wf_engine.SetItemAttrText(itemtype => itemType,
2851: itemkey => itemKey,
2852: aname => 'CONF_DOC_NUMBER',
2853: avalue => l_document_number);
2854:
2851: itemkey => itemKey,
2852: aname => 'CONF_DOC_NUMBER',
2853: avalue => l_document_number);
2854:
2855: l_msg_suffix := wf_engine.GetItemAttrText(itemtype => itemType,
2856: itemkey => itemKey,
2857: aname => 'MSG_SUFFIX');
2858:
2859: fnd_message.set_name('PON', 'PON_REVISION_CLM');
2860: fnd_message.set_token('REVISION',to_char(l_revision));
2861: l_rev_message := fnd_message.get;
2862: fnd_message.set_name('PON','PON_AUCTION_AUCTION'||l_msg_suffix);
2863: l_success_msg := fnd_message.get||' '||l_document_number||l_rev_message;
2864: wf_engine.SetItemAttrText(itemtype => itemType,
2865: itemkey => itemKey,
2866: aname => 'NEW_CONF_DOC_CLM',
2867: avalue => l_success_msg);
2868: else
2867: avalue => l_success_msg);
2868: else
2869: -- If conformed doc copy failed with error
2870: if l_return_status = 'E' then
2871: wf_engine.SetItemAttrText(itemtype => itemType,
2872: itemkey => itemKey,
2873: aname => 'CONF_DOC_ERROR_MESSAGE',
2874: avalue => PON_CLM_UTIL_PKG.GET_COPY_ERR_MSGS(l_msg_count,l_unexp_error));
2875: wf_engine.SetItemAttrText(itemtype => itemType,
2871: wf_engine.SetItemAttrText(itemtype => itemType,
2872: itemkey => itemKey,
2873: aname => 'CONF_DOC_ERROR_MESSAGE',
2874: avalue => PON_CLM_UTIL_PKG.GET_COPY_ERR_MSGS(l_msg_count,l_unexp_error));
2875: wf_engine.SetItemAttrText(itemtype => itemType,
2876: itemkey => itemKey,
2877: aname => 'CONF_DOC_IS_UNEXP_ERROR',
2878: avalue => l_unexp_error);
2879: else -- If conformed doc copy done with warnings.
2906: into l_itemKey
2907: from pon_auction_headers_all
2908: where auction_header_id = p_auction_header_id;
2909: --Get the attributes from workflow
2910: x_return_status := wf_engine.GetItemAttrText (itemtype => l_itemType,
2911: itemkey => l_itemKey,
2912: aname => 'IS_COPY_SUCCESS_FED');
2913:
2914: x_cnf_doc_auc_head_id := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
2910: x_return_status := wf_engine.GetItemAttrText (itemtype => l_itemType,
2911: itemkey => l_itemKey,
2912: aname => 'IS_COPY_SUCCESS_FED');
2913:
2914: x_cnf_doc_auc_head_id := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
2915: itemkey => l_itemKey,
2916: aname => 'CONF_DOC_AUC_HEAD_ID');
2917: x_cnf_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemType,
2918: itemkey => l_itemKey,
2913:
2914: x_cnf_doc_auc_head_id := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
2915: itemkey => l_itemKey,
2916: aname => 'CONF_DOC_AUC_HEAD_ID');
2917: x_cnf_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemType,
2918: itemkey => l_itemKey,
2919: aname => 'CONF_DOC_NUMBER');
2920: x_cnf_doc_rev := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
2921: itemkey => l_itemKey,
2916: aname => 'CONF_DOC_AUC_HEAD_ID');
2917: x_cnf_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemType,
2918: itemkey => l_itemKey,
2919: aname => 'CONF_DOC_NUMBER');
2920: x_cnf_doc_rev := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
2921: itemkey => l_itemKey,
2922: aname => 'CONF_DOC_REVISION');
2923:
2924: x_message := wf_engine.GetItemAttrText(itemtype => l_itemType,
2920: x_cnf_doc_rev := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
2921: itemkey => l_itemKey,
2922: aname => 'CONF_DOC_REVISION');
2923:
2924: x_message := wf_engine.GetItemAttrText(itemtype => l_itemType,
2925: itemkey => l_itemKey,
2926: aname => 'NEW_CONF_DOC_CLM');
2927: select document_number
2928: into x_amend_doc_number
2930: where
2931: auction_header_id = p_auction_header_id;
2932:
2933: if x_return_status = 'CONC_REQ_SUBMITTED' then
2934: x_request_id := wf_engine.GetItemAttrNumber (itemtype => l_itemType,
2935: itemkey => l_itemKey,
2936: aname => 'CONC_REQUEST_ID_FED');
2937: else
2938: if x_return_status = 'E' then
2935: itemkey => l_itemKey,
2936: aname => 'CONC_REQUEST_ID_FED');
2937: else
2938: if x_return_status = 'E' then
2939: x_error_messages := wf_engine.GetItemAttrText(itemtype => l_itemType,
2940: itemkey => l_itemKey,
2941: aname => 'CONF_DOC_ERROR_MESSAGE');
2942: x_is_unexp_error := wf_engine.GetItemAttrText(itemtype => l_itemType,
2943: itemkey => l_itemKey,
2938: if x_return_status = 'E' then
2939: x_error_messages := wf_engine.GetItemAttrText(itemtype => l_itemType,
2940: itemkey => l_itemKey,
2941: aname => 'CONF_DOC_ERROR_MESSAGE');
2942: x_is_unexp_error := wf_engine.GetItemAttrText(itemtype => l_itemType,
2943: itemkey => l_itemKey,
2944: aname => 'CONF_DOC_IS_UNEXP_ERROR');
2945: else
2946: null;
2975: from pon_auction_headers_all
2976: where auction_header_id = p_auction_header_id;
2977:
2978: --set workflow item attribute CANCELNOTETOSUPPLIERS.
2979: wf_engine.SetItemAttrText (itemtype => l_itemType,
2980: itemkey => l_itemKey,
2981: aname => 'CANCEL_NOTE_TO_SUPPLIERS',
2982: avalue => p_cancel_supplier_note);
2983:
2992: uncmode in varchar2,
2993: resultout out nocopy varchar2) IS
2994: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2995: Begin
2996: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2997: itemkey => itemkey,
2998: aname => 'AUCTION_HEADER_ID');
2999: select nvl(cancel_amendment,'N')
3000: into resultout
3027: l_rev_message VARCHAR2(30);
3028: l_success_msg VARCHAR2(1000);
3029:
3030: Begin
3031: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3032: itemkey => itemkey,
3033: aname => 'AUCTION_HEADER_ID');
3034:
3035: l_cancel_note_to_supplier := wf_engine.GetItemAttrText (itemtype => itemtype,
3031: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3032: itemkey => itemkey,
3033: aname => 'AUCTION_HEADER_ID');
3034:
3035: l_cancel_note_to_supplier := wf_engine.GetItemAttrText (itemtype => itemtype,
3036: itemkey => itemkey,
3037: aname => 'CANCEL_NOTE_TO_SUPPLIERS');
3038:
3039: PON_NEG_UPDATE_PKG.CANCEL_FEDERAL_NEGOTIATION(l_auction_header_id,
3058: l_msg_count,
3059: l_return_status);
3060:
3061: -- Set the conformed doc details, so that they can be used later.
3062: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3063: itemkey => itemkey,
3064: aname => 'CONF_DOC_AUC_HEAD_ID',
3065: avalue => l_auction_id_prev_doc);
3066:
3063: itemkey => itemkey,
3064: aname => 'CONF_DOC_AUC_HEAD_ID',
3065: avalue => l_auction_id_prev_doc);
3066:
3067: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3068: itemkey => itemkey,
3069: aname => 'CONF_DOC_REVISION',
3070: avalue => l_revision);
3071:
3068: itemkey => itemkey,
3069: aname => 'CONF_DOC_REVISION',
3070: avalue => l_revision);
3071:
3072: wf_engine.SetItemAttrText(itemtype => itemtype,
3073: itemkey => itemkey,
3074: aname => 'CONF_DOC_NUMBER',
3075: avalue => l_document_number);
3076:
3074: aname => 'CONF_DOC_NUMBER',
3075: avalue => l_document_number);
3076:
3077:
3078: l_msg_suffix := wf_engine.GetItemAttrText(itemtype => itemtype,
3079: itemkey => itemkey,
3080: aname => 'MSG_SUFFIX');
3081:
3082: fnd_message.set_name('PON', 'PON_REVISION_CLM');
3083: fnd_message.set_token('REVISION',to_char(l_revision));
3084: l_rev_message := fnd_message.get;
3085: fnd_message.set_name('PON','PON_AUCTION_AUCTION'||l_msg_suffix);
3086: l_success_msg := fnd_message.get||' '||l_document_number||l_rev_message;
3087: wf_engine.SetItemAttrText(itemtype => itemType,
3088: itemkey => itemKey,
3089: aname => 'NEW_CONF_DOC_CLM',
3090: avalue => l_success_msg);
3091: end if;
3110: into l_itemKey
3111: from pon_auction_headers_all
3112: where auction_header_id = p_auction_header_id;
3113: --Get the attributes from workflow
3114: x_cnf_doc_auc_head_id := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
3115: itemkey => l_itemKey,
3116: aname => 'CONF_DOC_AUC_HEAD_ID');
3117: x_cnf_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemType,
3118: itemkey => l_itemKey,
3113: --Get the attributes from workflow
3114: x_cnf_doc_auc_head_id := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
3115: itemkey => l_itemKey,
3116: aname => 'CONF_DOC_AUC_HEAD_ID');
3117: x_cnf_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemType,
3118: itemkey => l_itemKey,
3119: aname => 'CONF_DOC_NUMBER');
3120: x_cnf_doc_rev := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
3121: itemkey => l_itemKey,
3116: aname => 'CONF_DOC_AUC_HEAD_ID');
3117: x_cnf_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemType,
3118: itemkey => l_itemKey,
3119: aname => 'CONF_DOC_NUMBER');
3120: x_cnf_doc_rev := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
3121: itemkey => l_itemKey,
3122: aname => 'CONF_DOC_REVISION');
3123:
3124: x_message := wf_engine.GetItemAttrText(itemtype => l_itemType,
3120: x_cnf_doc_rev := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
3121: itemkey => l_itemKey,
3122: aname => 'CONF_DOC_REVISION');
3123:
3124: x_message := wf_engine.GetItemAttrText(itemtype => l_itemType,
3125: itemkey => l_itemKey,
3126: aname => 'NEW_CONF_DOC_CLM');
3127: select document_number
3128: into x_amend_doc_number