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: +=========================================================================+
22: API Name : GME_SUPPLY_RES_PVT
23: Type : Private
24: Function : This package contains Private procedures used for change management
600: , p_organization_id => l_organization_id
601: , p_action_code => l_action_code );
602: */
603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
601: , p_action_code => l_action_code );
602: */
603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
602: */
603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
616: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
616: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
617: End if;
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
616: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
617: End if;
618: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
619: p_event_key => l_session_id,
620: p_parameters => l_parameter_list);
621:
622: IF(l_last_updated_by <> l_created_by) THEN
635: , p_fpo_id => NULL
636: , p_organization_id => l_organization_id
637: , p_action_code => l_action_code );
638: */
639: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
640: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
641: p_event_key => l_session_id,
642: p_parameters => l_parameter_list);
643: END IF;
636: , p_organization_id => l_organization_id
637: , p_action_code => l_action_code );
638: */
639: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
640: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
641: p_event_key => l_session_id,
642: p_parameters => l_parameter_list);
643: END IF;
644: /* check to see when FPO converts to batches, the CSR for each new batch will get a notification*/
669: , p_fpo_id => NULL
670: , p_organization_id => l_organization_id
671: , p_action_code => l_action_code );
672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,
670: , p_organization_id => l_organization_id
671: , p_action_code => l_action_code );
672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,
678: p_parameters => l_parameter_list);
671: , p_action_code => l_action_code );
672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,
678: p_parameters => l_parameter_list);
679:
672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,
678: p_parameters => l_parameter_list);
679:
680: IF(l_last_updated_by <> l_created_by) THEN
693: , p_fpo_id => NULL
694: , p_organization_id => l_organization_id
695: , p_action_code => l_action_code );
696: */
697: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
698: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
699: p_event_key => l_session_id,
700: p_parameters => l_parameter_list);
701: END IF;
694: , p_organization_id => l_organization_id
695: , p_action_code => l_action_code );
696: */
697: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
698: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
699: p_event_key => l_session_id,
700: p_parameters => l_parameter_list);
701: END IF;
702: END IF;
725: , p_fpo_id => NULL
726: , p_organization_id => l_organization_id
727: , p_action_code => l_action_code );
728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,
726: , p_organization_id => l_organization_id
727: , p_action_code => l_action_code );
728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,
734: p_parameters => l_parameter_list);
727: , p_action_code => l_action_code );
728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,
734: p_parameters => l_parameter_list);
735:
728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,
734: p_parameters => l_parameter_list);
735:
736: IF(l_last_updated_by <> l_created_by) THEN
749: , p_fpo_id => NULL
750: , p_organization_id => l_organization_id
751: , p_action_code => l_action_code );
752: */
753: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
754: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
755: p_event_key => l_session_id,
756: p_parameters => l_parameter_list);
757: END IF;
750: , p_organization_id => l_organization_id
751: , p_action_code => l_action_code );
752: */
753: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
754: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
755: p_event_key => l_session_id,
756: p_parameters => l_parameter_list);
757: END IF;
758: END IF;