401: l_login_id NUMBER;
402: l_LanguageCode VARCHAR2(20);
403:
404: --Added for Raising tracking Workflows
405: l_wf_event_name VARCHAR2(1000);
406: l_wf_return_status VARCHAR2(1);
407: l_num_organization_id_tab DBMS_SQL.Number_Table;
408: l_parameter_list wf_parameter_list_t;
409: --BUG 6700736 Added variable to store master_organization_id
661: l_exception_message := 'Delivery has been submitted for export screening';
662:
663: IF p_event_name = G_PICK_RELEASE_EVENT THEN
664: l_exception_name := G_SUB_PICK_RELEASE_EXCEPTION;
665: l_wf_event_name := G_WF_PICK_RELEASE_EVENT_NAME;
666: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
667: l_exception_name := G_SUB_SHIP_CONFIRM_EXCEPTION;
668: l_wf_event_name := G_WF_SHIP_CONFIRM_EVENT_NAME;
669: END IF;
664: l_exception_name := G_SUB_PICK_RELEASE_EXCEPTION;
665: l_wf_event_name := G_WF_PICK_RELEASE_EVENT_NAME;
666: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
667: l_exception_name := G_SUB_SHIP_CONFIRM_EXCEPTION;
668: l_wf_event_name := G_WF_SHIP_CONFIRM_EVENT_NAME;
669: END IF;
670:
671:
672: WSH_XC_UTIL.log_exception(
719: END IF;
720:
721: RAISE_ITM_EVENT
722: (
723: p_event_name => l_wf_event_name ,
724: p_delivery_id => l_num_delivery_id_tab(j),
725: p_organization_id => l_num_organization_id_tab(j),
726: x_return_status => l_wf_return_status
727: );
905: | PROCEDURE |
906: | RAISE_ITM_EVENT |
907: | PARAMETERS |
908: | |
909: | p_event_name => The WF event name that has to be raised |
910: | by the procedure |
911: | p_organization_id => This parameter is used to indiate the organization|
912: | of the delivery. |
913: | |
950: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
951: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
952: END IF;
953:
954: wf_event.AddParameterToList(
955: p_name=>'ORGANIZATION_ID',
956: p_value => p_organization_id,
957: p_parameterlist=> l_parameter_list);
958: