112:
113: --
114: -- Add the parameters
115: --
116: wf_event.AddParameterToList( p_name => 'auction_header_id',
117: p_value => l_auction_header_id,
118: p_parameterlist => l_parameter_list);
119:
120: wf_event.AddParameterToList( p_name => 'document_number',
116: wf_event.AddParameterToList( p_name => 'auction_header_id',
117: p_value => l_auction_header_id,
118: p_parameterlist => l_parameter_list);
119:
120: wf_event.AddParameterToList( p_name => 'document_number',
121: p_value => l_document_number,
122: p_parameterlist => l_parameter_list);
123:
124: wf_event.AddParameterToList( p_name => 'auction_title',
120: wf_event.AddParameterToList( p_name => 'document_number',
121: p_value => l_document_number,
122: p_parameterlist => l_parameter_list);
123:
124: wf_event.AddParameterToList( p_name => 'auction_title',
125: p_value => l_auction_title,
126: p_parameterlist => l_parameter_list);
127:
128: wf_event.AddParameterToList( p_name => 'open_bidding_date',
124: wf_event.AddParameterToList( p_name => 'auction_title',
125: p_value => l_auction_title,
126: p_parameterlist => l_parameter_list);
127:
128: wf_event.AddParameterToList( p_name => 'open_bidding_date',
129: p_value => l_open_bidding_date,
130: p_parameterlist => l_parameter_list);
131:
132: wf_event.AddParameterToList( p_name => 'close_bidding_date',
128: wf_event.AddParameterToList( p_name => 'open_bidding_date',
129: p_value => l_open_bidding_date,
130: p_parameterlist => l_parameter_list);
131:
132: wf_event.AddParameterToList( p_name => 'close_bidding_date',
133: p_value => l_close_bidding_date,
134: p_parameterlist => l_parameter_list);
135:
136: wf_event.AddParameterToList( p_name => 'publish_date',
132: wf_event.AddParameterToList( p_name => 'close_bidding_date',
133: p_value => l_close_bidding_date,
134: p_parameterlist => l_parameter_list);
135:
136: wf_event.AddParameterToList( p_name => 'publish_date',
137: p_value => l_publish_date,
138: p_parameterlist => l_parameter_list);
139:
140: RAISE_EVENT (
246:
247: --
248: -- Add the parameters
249: --
250: wf_event.AddParameterToList( p_name => 'bid_number',
251: p_value => l_bid_number,
252: p_parameterlist => l_parameter_list);
253:
254: wf_event.AddParameterToList( p_name => 'auction_header_id',
250: wf_event.AddParameterToList( p_name => 'bid_number',
251: p_value => l_bid_number,
252: p_parameterlist => l_parameter_list);
253:
254: wf_event.AddParameterToList( p_name => 'auction_header_id',
255: p_value => l_auction_header_id,
256: p_parameterlist => l_parameter_list);
257:
258: wf_event.AddParameterToList( p_name => 'document_number',
254: wf_event.AddParameterToList( p_name => 'auction_header_id',
255: p_value => l_auction_header_id,
256: p_parameterlist => l_parameter_list);
257:
258: wf_event.AddParameterToList( p_name => 'document_number',
259: p_value => l_document_number,
260: p_parameterlist => l_parameter_list);
261:
262: wf_event.AddParameterToList( p_name => 'bidder_tp_contact_id',
258: wf_event.AddParameterToList( p_name => 'document_number',
259: p_value => l_document_number,
260: p_parameterlist => l_parameter_list);
261:
262: wf_event.AddParameterToList( p_name => 'bidder_tp_contact_id',
263: p_value => l_trading_partner_contact_id,
264: p_parameterlist => l_parameter_list);
265:
266: wf_event.AddParameterToList( p_name => 'bidder_tp_id',
262: wf_event.AddParameterToList( p_name => 'bidder_tp_contact_id',
263: p_value => l_trading_partner_contact_id,
264: p_parameterlist => l_parameter_list);
265:
266: wf_event.AddParameterToList( p_name => 'bidder_tp_id',
267: p_value => l_trading_partner_id,
268: p_parameterlist => l_parameter_list);
269:
270: wf_event.AddParameterToList( p_name => 'publish_date',
266: wf_event.AddParameterToList( p_name => 'bidder_tp_id',
267: p_value => l_trading_partner_id,
268: p_parameterlist => l_parameter_list);
269:
270: wf_event.AddParameterToList( p_name => 'publish_date',
271: p_value => l_publish_date,
272: p_parameterlist => l_parameter_list);
273:
274: wf_event.AddParameterToList( p_name => 'surrog_tp_contact_id',
270: wf_event.AddParameterToList( p_name => 'publish_date',
271: p_value => l_publish_date,
272: p_parameterlist => l_parameter_list);
273:
274: wf_event.AddParameterToList( p_name => 'surrog_tp_contact_id',
275: p_value => l_surr_bid_created_contct_id,
276: p_parameterlist => l_parameter_list);
277:
278: wf_event.AddParameterToList( p_name => 'surrog_tp_id',
274: wf_event.AddParameterToList( p_name => 'surrog_tp_contact_id',
275: p_value => l_surr_bid_created_contct_id,
276: p_parameterlist => l_parameter_list);
277:
278: wf_event.AddParameterToList( p_name => 'surrog_tp_id',
279: p_value => l_surrog_bid_created_tp_id,
280: p_parameterlist => l_parameter_list);
281:
282:
391:
392: --
393: -- Add the parameters
394: --
395: wf_event.AddParameterToList( p_name => 'bid_number',
396: p_value => l_bid_number,
397: p_parameterlist => l_parameter_list);
398:
399: wf_event.AddParameterToList( p_name => 'auction_header_id',
395: wf_event.AddParameterToList( p_name => 'bid_number',
396: p_value => l_bid_number,
397: p_parameterlist => l_parameter_list);
398:
399: wf_event.AddParameterToList( p_name => 'auction_header_id',
400: p_value => l_auction_header_id,
401: p_parameterlist => l_parameter_list);
402:
403: wf_event.AddParameterToList( p_name => 'document_number',
399: wf_event.AddParameterToList( p_name => 'auction_header_id',
400: p_value => l_auction_header_id,
401: p_parameterlist => l_parameter_list);
402:
403: wf_event.AddParameterToList( p_name => 'document_number',
404: p_value => l_document_number,
405: p_parameterlist => l_parameter_list);
406:
407: wf_event.AddParameterToList( p_name => 'bidder_tp_contact_id',
403: wf_event.AddParameterToList( p_name => 'document_number',
404: p_value => l_document_number,
405: p_parameterlist => l_parameter_list);
406:
407: wf_event.AddParameterToList( p_name => 'bidder_tp_contact_id',
408: p_value => l_trading_partner_contact_id,
409: p_parameterlist => l_parameter_list);
410:
411: wf_event.AddParameterToList( p_name => 'bidder_tp_id',
407: wf_event.AddParameterToList( p_name => 'bidder_tp_contact_id',
408: p_value => l_trading_partner_contact_id,
409: p_parameterlist => l_parameter_list);
410:
411: wf_event.AddParameterToList( p_name => 'bidder_tp_id',
412: p_value => l_trading_partner_id,
413: p_parameterlist => l_parameter_list);
414:
415: wf_event.AddParameterToList( p_name => 'publish_date',
411: wf_event.AddParameterToList( p_name => 'bidder_tp_id',
412: p_value => l_trading_partner_id,
413: p_parameterlist => l_parameter_list);
414:
415: wf_event.AddParameterToList( p_name => 'publish_date',
416: p_value => l_publish_date,
417: p_parameterlist => l_parameter_list);
418:
419: wf_event.AddParameterToList( p_name => 'disqualify_date',
415: wf_event.AddParameterToList( p_name => 'publish_date',
416: p_value => l_publish_date,
417: p_parameterlist => l_parameter_list);
418:
419: wf_event.AddParameterToList( p_name => 'disqualify_date',
420: p_value => l_last_update_date,
421: p_parameterlist => l_parameter_list);
422:
423: wf_event.AddParameterToList( p_name => 'disqualify_reason',
419: wf_event.AddParameterToList( p_name => 'disqualify_date',
420: p_value => l_last_update_date,
421: p_parameterlist => l_parameter_list);
422:
423: wf_event.AddParameterToList( p_name => 'disqualify_reason',
424: p_value => l_disqualify_reason,
425: p_parameterlist => l_parameter_list);
426:
427:
527:
528: --
529: -- Add the parameters
530: --
531: wf_event.AddParameterToList( p_name => 'auction_header_id',
532: p_value => l_auction_header_id,
533: p_parameterlist => l_parameter_list);
534:
535: wf_event.AddParameterToList( p_name => 'document_number',
531: wf_event.AddParameterToList( p_name => 'auction_header_id',
532: p_value => l_auction_header_id,
533: p_parameterlist => l_parameter_list);
534:
535: wf_event.AddParameterToList( p_name => 'document_number',
536: p_value => l_document_number,
537: p_parameterlist => l_parameter_list);
538:
539: wf_event.AddParameterToList( p_name => 'ame_transaction_id',
535: wf_event.AddParameterToList( p_name => 'document_number',
536: p_value => l_document_number,
537: p_parameterlist => l_parameter_list);
538:
539: wf_event.AddParameterToList( p_name => 'ame_transaction_id',
540: p_value => l_award_appr_ame_trans_id,
541: p_parameterlist => l_parameter_list);
542:
543: wf_event.AddParameterToList( p_name => 'ame_last_trans_date',
539: wf_event.AddParameterToList( p_name => 'ame_transaction_id',
540: p_value => l_award_appr_ame_trans_id,
541: p_parameterlist => l_parameter_list);
542:
543: wf_event.AddParameterToList( p_name => 'ame_last_trans_date',
544: p_value => l_award_appr_ame_txn_date,
545: p_parameterlist => l_parameter_list);
546:
547: wf_event.AddParameterToList( p_name => 'award_approval_status',
543: wf_event.AddParameterToList( p_name => 'ame_last_trans_date',
544: p_value => l_award_appr_ame_txn_date,
545: p_parameterlist => l_parameter_list);
546:
547: wf_event.AddParameterToList( p_name => 'award_approval_status',
548: p_value => l_award_approval_status,
549: p_parameterlist => l_parameter_list);
550:
551: wf_event.AddParameterToList( p_name => 'wf_award_appr_item_key',
547: wf_event.AddParameterToList( p_name => 'award_approval_status',
548: p_value => l_award_approval_status,
549: p_parameterlist => l_parameter_list);
550:
551: wf_event.AddParameterToList( p_name => 'wf_award_appr_item_key',
552: p_value => l_wf_award_approval_item_key,
553: p_parameterlist => l_parameter_list);
554:
555: RAISE_EVENT (
662:
663: --
664: -- Add the parameters
665: --
666: wf_event.AddParameterToList( p_name => 'auction_header_id',
667: p_value => l_auction_header_id,
668: p_parameterlist => l_parameter_list);
669:
670: wf_event.AddParameterToList( p_name => 'document_number',
666: wf_event.AddParameterToList( p_name => 'auction_header_id',
667: p_value => l_auction_header_id,
668: p_parameterlist => l_parameter_list);
669:
670: wf_event.AddParameterToList( p_name => 'document_number',
671: p_value => l_document_number,
672: p_parameterlist => l_parameter_list);
673:
674: wf_event.AddParameterToList( p_name => 'outcome_status',
670: wf_event.AddParameterToList( p_name => 'document_number',
671: p_value => l_document_number,
672: p_parameterlist => l_parameter_list);
673:
674: wf_event.AddParameterToList( p_name => 'outcome_status',
675: p_value => l_outcome_status,
676: p_parameterlist => l_parameter_list);
677:
678: wf_event.AddParameterToList( p_name => 'create_po_flag',
674: wf_event.AddParameterToList( p_name => 'outcome_status',
675: p_value => l_outcome_status,
676: p_parameterlist => l_parameter_list);
677:
678: wf_event.AddParameterToList( p_name => 'create_po_flag',
679: p_value => p_create_po_flag,
680: p_parameterlist => l_parameter_list);
681:
682: wf_event.AddParameterToList( p_name => 'has_requisition_flag',
678: wf_event.AddParameterToList( p_name => 'create_po_flag',
679: p_value => p_create_po_flag,
680: p_parameterlist => l_parameter_list);
681:
682: wf_event.AddParameterToList( p_name => 'has_requisition_flag',
683: p_value => l_requisition_based_flag,
684: p_parameterlist => l_parameter_list);
685:
686: wf_event.AddParameterToList( p_name => 'source_backing_req_lines',
682: wf_event.AddParameterToList( p_name => 'has_requisition_flag',
683: p_value => l_requisition_based_flag,
684: p_parameterlist => l_parameter_list);
685:
686: wf_event.AddParameterToList( p_name => 'source_backing_req_lines',
687: p_value => l_source_reqs_flag,
688: p_parameterlist => l_parameter_list);
689:
690: wf_event.AddParameterToList( p_name => 'share_award_decision_flag',
686: wf_event.AddParameterToList( p_name => 'source_backing_req_lines',
687: p_value => l_source_reqs_flag,
688: p_parameterlist => l_parameter_list);
689:
690: wf_event.AddParameterToList( p_name => 'share_award_decision_flag',
691: p_value => l_share_award_decision,
692: p_parameterlist => l_parameter_list);
693:
694: wf_event.AddParameterToList( p_name => 'award_complete_date',
690: wf_event.AddParameterToList( p_name => 'share_award_decision_flag',
691: p_value => l_share_award_decision,
692: p_parameterlist => l_parameter_list);
693:
694: wf_event.AddParameterToList( p_name => 'award_complete_date',
695: p_value => l_award_complete_date,
696: p_parameterlist => l_parameter_list);
697:
698:
821:
822: --
823: -- Add the parameters
824: --
825: wf_event.AddParameterToList( p_name => 'auction_header_id',
826: p_value => l_auction_header_id,
827: p_parameterlist => l_parameter_list);
828:
829: wf_event.AddParameterToList( p_name => 'document_number',
825: wf_event.AddParameterToList( p_name => 'auction_header_id',
826: p_value => l_auction_header_id,
827: p_parameterlist => l_parameter_list);
828:
829: wf_event.AddParameterToList( p_name => 'document_number',
830: p_value => l_document_number,
831: p_parameterlist => l_parameter_list);
832:
833: wf_event.AddParameterToList( p_name => 'doctype_id',
829: wf_event.AddParameterToList( p_name => 'document_number',
830: p_value => l_document_number,
831: p_parameterlist => l_parameter_list);
832:
833: wf_event.AddParameterToList( p_name => 'doctype_id',
834: p_value => l_doctype_id,
835: p_parameterlist => l_parameter_list);
836:
837: wf_event.AddParameterToList( p_name => 'contract_type',
833: wf_event.AddParameterToList( p_name => 'doctype_id',
834: p_value => l_doctype_id,
835: p_parameterlist => l_parameter_list);
836:
837: wf_event.AddParameterToList( p_name => 'contract_type',
838: p_value => l_contract_type,
839: p_parameterlist => l_parameter_list);
840:
841: wf_event.AddParameterToList( p_name => 'user_name',
837: wf_event.AddParameterToList( p_name => 'contract_type',
838: p_value => l_contract_type,
839: p_parameterlist => l_parameter_list);
840:
841: wf_event.AddParameterToList( p_name => 'user_name',
842: p_value => p_user_name,
843: p_parameterlist => l_parameter_list);
844:
845: wf_event.AddParameterToList( p_name => 'outcome_status',
841: wf_event.AddParameterToList( p_name => 'user_name',
842: p_value => p_user_name,
843: p_parameterlist => l_parameter_list);
844:
845: wf_event.AddParameterToList( p_name => 'outcome_status',
846: p_value => l_outcome_status,
847: p_parameterlist => l_parameter_list);
848:
849: wf_event.AddParameterToList( p_name => 'has_requisition_flag',
845: wf_event.AddParameterToList( p_name => 'outcome_status',
846: p_value => l_outcome_status,
847: p_parameterlist => l_parameter_list);
848:
849: wf_event.AddParameterToList( p_name => 'has_requisition_flag',
850: p_value => l_requisition_based_flag,
851: p_parameterlist => l_parameter_list);
852:
853: wf_event.AddParameterToList( p_name => 'wf_poncompl_item_key',
849: wf_event.AddParameterToList( p_name => 'has_requisition_flag',
850: p_value => l_requisition_based_flag,
851: p_parameterlist => l_parameter_list);
852:
853: wf_event.AddParameterToList( p_name => 'wf_poncompl_item_key',
854: p_value => l_wf_poncompl_item_key,
855: p_parameterlist => l_parameter_list);
856:
857: wf_event.AddParameterToList( p_name => 'wf_poncompl_current_round',
853: wf_event.AddParameterToList( p_name => 'wf_poncompl_item_key',
854: p_value => l_wf_poncompl_item_key,
855: p_parameterlist => l_parameter_list);
856:
857: wf_event.AddParameterToList( p_name => 'wf_poncompl_current_round',
858: p_value => l_wf_poncompl_current_round,
859: p_parameterlist => l_parameter_list);
860:
861: wf_event.AddParameterToList( p_name => 'po_initiation_date',
857: wf_event.AddParameterToList( p_name => 'wf_poncompl_current_round',
858: p_value => l_wf_poncompl_current_round,
859: p_parameterlist => l_parameter_list);
860:
861: wf_event.AddParameterToList( p_name => 'po_initiation_date',
862: p_value => l_last_update_date,
863: p_parameterlist => l_parameter_list);
864:
865: wf_event.AddParameterToList( p_name => 'source_backing_req_lines',
861: wf_event.AddParameterToList( p_name => 'po_initiation_date',
862: p_value => l_last_update_date,
863: p_parameterlist => l_parameter_list);
864:
865: wf_event.AddParameterToList( p_name => 'source_backing_req_lines',
866: p_value => l_source_reqs_flag,
867: p_parameterlist => l_parameter_list);
868:
869:
956: g_err_loc := '10.3 Fetched the FND_PROFILE.VALUEs';
957: LOG_MESSAGE('raise_event', g_err_loc);
958:
959: --Check the event is registered and enabled
960: l_exist :=WF_EVENT.TEST(p_event_name);
961:
962: g_err_loc := '10.4 Called the WF_EVENT.TEST';
963: LOG_MESSAGE('raise_event', g_err_loc|| 'l_exist:'||l_exist);
964:
958:
959: --Check the event is registered and enabled
960: l_exist :=WF_EVENT.TEST(p_event_name);
961:
962: g_err_loc := '10.4 Called the WF_EVENT.TEST';
963: LOG_MESSAGE('raise_event', g_err_loc|| 'l_exist:'||l_exist);
964:
965: IF (p_parameter_list IS NULL) THEN
966: l_parameter_list := WF_PARAMETER_LIST_T();
974: IF (l_exist <> 'NONE') THEN
975: --{
976: -- Add extra context values to the list
977:
978: wf_event.AddParameterToList( p_name => 'org_id',
979: p_value => l_org_id,
980: p_parameterlist => l_parameter_list);
981: wf_event.AddParameterToList( p_name => 'user_id',
982: p_value => l_user_id,
977:
978: wf_event.AddParameterToList( p_name => 'org_id',
979: p_value => l_org_id,
980: p_parameterlist => l_parameter_list);
981: wf_event.AddParameterToList( p_name => 'user_id',
982: p_value => l_user_id,
983: p_parameterlist => l_parameter_list);
984: wf_event.AddParameterToList( p_name => 'resp_id',
985: p_value => l_resp_id,
980: p_parameterlist => l_parameter_list);
981: wf_event.AddParameterToList( p_name => 'user_id',
982: p_value => l_user_id,
983: p_parameterlist => l_parameter_list);
984: wf_event.AddParameterToList( p_name => 'resp_id',
985: p_value => l_resp_id,
986: p_parameterlist => l_parameter_list);
987: wf_event.AddParameterToList( p_name => 'resp_appl_id',
988: p_value => l_resp_appl_id,
983: p_parameterlist => l_parameter_list);
984: wf_event.AddParameterToList( p_name => 'resp_id',
985: p_value => l_resp_id,
986: p_parameterlist => l_parameter_list);
987: wf_event.AddParameterToList( p_name => 'resp_appl_id',
988: p_value => l_resp_appl_id,
989: p_parameterlist => l_parameter_list);
990:
991: g_err_loc := '10.6 End of wf_event.AddParameterToList calls';
987: wf_event.AddParameterToList( p_name => 'resp_appl_id',
988: p_value => l_resp_appl_id,
989: p_parameterlist => l_parameter_list);
990:
991: g_err_loc := '10.6 End of wf_event.AddParameterToList calls';
992: LOG_MESSAGE('raise_event', g_err_loc);
993:
994: --
995: -- Set Everything to defer mode for a better performance
993:
994: --
995: -- Set Everything to defer mode for a better performance
996: --
997: WF_EVENT.SetDispatchMode('ASYNC');
998:
999:
1000: -- Raise Event
1001: WF_EVENT.RAISE(p_event_name => p_event_name,
997: WF_EVENT.SetDispatchMode('ASYNC');
998:
999:
1000: -- Raise Event
1001: WF_EVENT.RAISE(p_event_name => p_event_name,
1002: p_event_key => p_event_key,
1003: p_parameters => l_parameter_list
1004: );
1005: g_err_loc := '10.7 Called WF_EVENT.RAISE';
1001: WF_EVENT.RAISE(p_event_name => p_event_name,
1002: p_event_key => p_event_key,
1003: p_parameters => l_parameter_list
1004: );
1005: g_err_loc := '10.7 Called WF_EVENT.RAISE';
1006: LOG_MESSAGE('raise_event', g_err_loc);
1007: --}
1008: ELSE
1009: -- We are not raising any exception if the event does not exist