[Home] [Help]
414: l_login_id NUMBER;
415: l_LanguageCode VARCHAR2(20);
416:
417: --Added for Raising tracking Workflows
418: l_wf_event_name VARCHAR2(1000);
419: l_wf_return_status VARCHAR2(1);
420: l_num_organization_id_tab DBMS_SQL.Number_Table;
421: l_parameter_list wf_parameter_list_t;
422: --BUG 6700736 Added variable to store master_organization_id
674: l_exception_message := 'Delivery has been submitted for export screening';
675:
676: IF p_event_name = G_PICK_RELEASE_EVENT THEN
677: l_exception_name := G_SUB_PICK_RELEASE_EXCEPTION;
678: l_wf_event_name := G_WF_PICK_RELEASE_EVENT_NAME;
679: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
680: l_exception_name := G_SUB_SHIP_CONFIRM_EXCEPTION;
681: l_wf_event_name := G_WF_SHIP_CONFIRM_EVENT_NAME;
682: END IF;
677: l_exception_name := G_SUB_PICK_RELEASE_EXCEPTION;
678: l_wf_event_name := G_WF_PICK_RELEASE_EVENT_NAME;
679: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
680: l_exception_name := G_SUB_SHIP_CONFIRM_EXCEPTION;
681: l_wf_event_name := G_WF_SHIP_CONFIRM_EVENT_NAME;
682: END IF;
683:
684:
685: WSH_XC_UTIL.log_exception(
732: END IF;
733:
734: RAISE_ITM_EVENT
735: (
736: p_event_name => l_wf_event_name ,
737: p_delivery_id => l_num_delivery_id_tab(j),
738: p_organization_id => l_num_organization_id_tab(j),
739: x_return_status => l_wf_return_status
740: );
918: | PROCEDURE |
919: | RAISE_ITM_EVENT |
920: | PARAMETERS |
921: | |
922: | p_event_name => The WF event name that has to be raised |
923: | by the procedure |
924: | p_organization_id => This parameter is used to indiate the organization|
925: | of the delivery. |
926: | |
963: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
964: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
965: END IF;
966:
967: wf_event.AddParameterToList(
968: p_name=>'ORGANIZATION_ID',
969: p_value => p_organization_id,
970: p_parameterlist=> l_parameter_list);
971: