DBA Data[Home] [Help]

APPS.GME_SUPPLY_RES_PVT dependencies on WF_EVENT

Line 20: | WF event names such as 'oracle.apps.gme...' |

16: | HISTORY |
17: | Aug-18-2003 Liping Gao Created |
18: | Archana Mundhe Bug 5763818 Modified the code to use constants |
19: | that are added to gme_common_pvt instead of using the hardcoded |
20: | WF event names such as 'oracle.apps.gme...' |
21: | srpuri FP Bug 7422975 Added the condition to convert the transaction |
22: | quantity to the secondary only when the secondary uom code is not null |
23: | srpuri FP Bug 8343517 Modified procedure |
24: | transfer_reservation_to_inv. Assigned l_mmt_rec.transfer_lpn_id to |

Line 620: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);

616: , p_organization_id => l_organization_id
617: , p_action_code => l_action_code );
618: */
619: wf_log_pkg.wf_debug_flag:=TRUE;
620: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
621: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);

Line 621: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);

617: , p_action_code => l_action_code );
618: */
619: wf_log_pkg.wf_debug_flag:=TRUE;
620: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
621: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);

Line 622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);

618: */
619: wf_log_pkg.wf_debug_flag:=TRUE;
620: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
621: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);

Line 623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);

619: wf_log_pkg.wf_debug_flag:=TRUE;
620: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
621: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);

Line 624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);

620: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
621: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);

Line 625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);

621: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);

Line 626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);

622: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
630: IF g_debug <= gme_debug.g_log_procedure THEN

Line 627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);

623: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');

Line 628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);

624: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );

Line 629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);

625: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
633: End if;

Line 634: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
633: End if;
634: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
635: p_event_key => l_session_id,
636: p_parameters => l_parameter_list);
637:
638: IF(l_last_updated_by <> l_created_by) THEN

Line 655: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);

651: , p_fpo_id => NULL
652: , p_organization_id => l_organization_id
653: , p_action_code => l_action_code );
654: */
655: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
656: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
657: p_event_key => l_session_id,
658: p_parameters => l_parameter_list);
659: END IF;

Line 656: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

652: , p_organization_id => l_organization_id
653: , p_action_code => l_action_code );
654: */
655: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
656: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
657: p_event_key => l_session_id,
658: p_parameters => l_parameter_list);
659: END IF;
660: /* check to see when FPO converts to batches, the CSR for each new batch will get a notification*/

Line 689: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);

685: , p_fpo_id => NULL
686: , p_organization_id => l_organization_id
687: , p_action_code => l_action_code );
688: */
689: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
690: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
691: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
692: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
693: p_event_key => l_session_id,

Line 690: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);

686: , p_organization_id => l_organization_id
687: , p_action_code => l_action_code );
688: */
689: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
690: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
691: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
692: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
693: p_event_key => l_session_id,
694: p_parameters => l_parameter_list);

Line 691: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);

687: , p_action_code => l_action_code );
688: */
689: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
690: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
691: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
692: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
693: p_event_key => l_session_id,
694: p_parameters => l_parameter_list);
695:

Line 692: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

688: */
689: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
690: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
691: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
692: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
693: p_event_key => l_session_id,
694: p_parameters => l_parameter_list);
695:
696: IF(l_last_updated_by <> l_created_by) THEN

Line 713: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);

709: , p_fpo_id => NULL
710: , p_organization_id => l_organization_id
711: , p_action_code => l_action_code );
712: */
713: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
714: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
715: p_event_key => l_session_id,
716: p_parameters => l_parameter_list);
717: END IF;

Line 714: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

710: , p_organization_id => l_organization_id
711: , p_action_code => l_action_code );
712: */
713: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
714: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
715: p_event_key => l_session_id,
716: p_parameters => l_parameter_list);
717: END IF;
718: END IF;

Line 745: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);

741: , p_fpo_id => NULL
742: , p_organization_id => l_organization_id
743: , p_action_code => l_action_code );
744: */
745: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
746: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
747: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
748: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
749: p_event_key => l_session_id,

Line 746: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);

742: , p_organization_id => l_organization_id
743: , p_action_code => l_action_code );
744: */
745: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
746: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
747: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
748: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
749: p_event_key => l_session_id,
750: p_parameters => l_parameter_list);

Line 747: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);

743: , p_action_code => l_action_code );
744: */
745: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
746: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
747: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
748: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
749: p_event_key => l_session_id,
750: p_parameters => l_parameter_list);
751:

Line 748: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

744: */
745: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
746: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
747: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
748: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
749: p_event_key => l_session_id,
750: p_parameters => l_parameter_list);
751:
752: IF(l_last_updated_by <> l_created_by) THEN

Line 769: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);

765: , p_fpo_id => NULL
766: , p_organization_id => l_organization_id
767: , p_action_code => l_action_code );
768: */
769: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
770: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
771: p_event_key => l_session_id,
772: p_parameters => l_parameter_list);
773: END IF;

Line 770: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

766: , p_organization_id => l_organization_id
767: , p_action_code => l_action_code );
768: */
769: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
770: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
771: p_event_key => l_session_id,
772: p_parameters => l_parameter_list);
773: END IF;
774: END IF;