eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WF_STD dependencies on WSH_WF_STD

Line 1: PACKAGE BODY WSH_WF_STD AS

1: PACKAGE BODY WSH_WF_STD AS
2: /* $Header: WSHWSTDB.pls 120.11.12000000.2 2007/01/23 18:40:15 rlanka ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='WSH_WF_STD';
5: G_NO_WORKFLOW CONSTANT VARCHAR2(30):='NO_WORLFLOW_98';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='WSH_WF_STD';

1: PACKAGE BODY WSH_WF_STD AS
2: /* $Header: WSHWSTDB.pls 120.11.12000000.2 2007/01/23 18:40:15 rlanka ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='WSH_WF_STD';
5: G_NO_WORKFLOW CONSTANT VARCHAR2(30):='NO_WORLFLOW_98';
6:
7: /*PROCEDURE Test_Events(p_entity_type IN VARCHAR2,
8: p_entity_id IN NUMBER,

Line 177: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',

173: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
174: SAVEPOINT START_WF_PROCESS_UPDATE;
175:
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',
178: WSH_DEBUG_SV.C_PROC_LEVEL);
179: END IF;
180:
181: Check_Wf_Exists(p_entity_type => p_entity_type,

Line 207: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CONFIRM_START_WF_PROCESS',

203: RETURN;
204: END IF;
205:
206: IF l_debug_on THEN
207: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CONFIRM_START_WF_PROCESS',
208: WSH_DEBUG_SV.C_PROC_LEVEL);
209: END IF;
210:
211: Confirm_Start_Wf_Process(p_entity_type => p_entity_type,

Line 239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.PROCESS_SELECTOR',

235: -- invoke the workflow
236: l_itemkey:=p_entity_id;
237:
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.PROCESS_SELECTOR',
240: WSH_DEBUG_SV.C_PROC_LEVEL);
241: END IF;
242:
243: Process_Selector(p_entity_type => p_entity_type,

Line 466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',

462: RETURN;
463: END IF;
464:
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',
467: WSH_DEBUG_SV.C_PROC_LEVEL);
468: END IF;
469:
470: check_wf_exists(p_entity_type => 'DELIVERY_C',

Line 544: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS',

540: FETCH get_org_code into l_organization_code;
541: CLOSE get_org_code ;
542:
543: IF l_debug_on THEN
544: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS',
545: WSH_DEBUG_SV.C_PROC_LEVEL);
546: END IF;
547:
548: Get_Custom_Wf_Process(p_wf_process => 'R_SCPOD_C',

Line 623: WSH_WF_STD.Log_Wf_Exception(p_entity_type => 'DELIVERY',

619: END IF;
620:
621: EXCEPTION
622: WHEN others THEN
623: WSH_WF_STD.Log_Wf_Exception(p_entity_type => 'DELIVERY',
624: p_entity_id => p_entity_id,
625: p_logging_entity => 'SHIPPER',
626: p_exception_name => 'WSH_LAUNCH_WF_FAILED',
627: x_return_status => l_return_status);

Line 882: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS',

878: FETCH get_org_code into l_organization_code;
879: CLOSE get_org_code ;
880:
881: IF l_debug_on THEN
882: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS',
883: WSH_DEBUG_SV.C_PROC_LEVEL);
884: END IF;
885:
886: Get_Custom_Wf_Process(p_wf_process => x_wf_process,

Line 1008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',

1004: -- Raise event if a workflow process exists
1005: IF (p_entity_type = 'TRIP' or p_entity_type = 'DELIVERY') THEN
1006:
1007: IF l_debug_on THEN
1008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',
1009: WSH_DEBUG_SV.C_PROC_LEVEL);
1010: END IF;
1011:
1012: check_wf_exists(p_entity_type => p_entity_type,

Line 1908: WF_CORE.CONTEXT('WSH_WF_STD', 'INSTANCE_DEFAULT_RULE',p_event.getEventName( ), p_subscription_guid);

1904: RETURN 'SUCCESS';
1905:
1906: EXCEPTION
1907: WHEN e_entityid_notfound THEN
1908: WF_CORE.CONTEXT('WSH_WF_STD', 'INSTANCE_DEFAULT_RULE',p_event.getEventName( ), p_subscription_guid);
1909: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Associated Entity Id not found. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_ENTITYID_NOTFOUND');

Line 1917: WF_CORE.CONTEXT('WSH_WF_STD', 'INSTANCE_DEFAULT_RULE',p_event.getEventName( ), p_subscription_guid);

1913: END IF;
1914: RETURN 'ERROR';
1915:
1916: WHEN e_event_error THEN
1917: WF_CORE.CONTEXT('WSH_WF_STD', 'INSTANCE_DEFAULT_RULE',p_event.getEventName( ), p_subscription_guid);
1918: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1919: IF l_debug_on THEN
1920: WSH_DEBUG_SV.logmsg(l_module_name,'Some Entities had errors while raising events. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_EVENT_ERROR');

Line 1926: WF_CORE.CONTEXT('WSH_WF_STD', 'INSTANCE_DEFAULT_RULE',p_event.getEventName( ), p_subscription_guid);

1922: END IF;
1923: RETURN 'ERROR';
1924:
1925: WHEN others THEN
1926: WF_CORE.CONTEXT('WSH_WF_STD', 'INSTANCE_DEFAULT_RULE',p_event.getEventName( ), p_subscription_guid);
1927: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1928: IF l_debug_on THEN
1929: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1930: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1944: WSH_WF_STD.G_RESET_APPS_CONTEXT := TRUE;

1940: l_debug_on BOOLEAN;
1941: --
1942: BEGIN
1943:
1944: WSH_WF_STD.G_RESET_APPS_CONTEXT := TRUE;
1945: IF l_debug_on THEN
1946: WSH_DEBUG_SV.push(l_module_name);
1947: WSH_DEBUG_SV.pop(l_module_name);
1948: END IF;

Line 1962: WSH_WF_STD.G_RESET_APPS_CONTEXT := FALSE;

1958: l_debug_on BOOLEAN;
1959: --
1960: BEGIN
1961:
1962: WSH_WF_STD.G_RESET_APPS_CONTEXT := FALSE;
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.push(l_module_name);
1965: WSH_DEBUG_SV.pop(l_module_name);
1966: END IF;

Line 2034: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');

2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2034: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');
2035: IF l_debug_on THEN
2036: --{
2037: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2038: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2115: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',

2111:
2112: IF ((p_old_carrier_id IS NULL) AND (p_new_carrier_id IS NOT NULL)) THEN
2113:
2114: --Carrier on the delivery getting assigned for first time.
2115: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2116: p_entity_id => p_delivery_id,
2117: p_event => 'oracle.apps.wsh.delivery.gen.carrierselected',
2118: p_organization_id => l_org_id,
2119: x_return_status => l_wf_rs);

Line 2124: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',

2120:
2121: ELSIF ((p_old_carrier_id IS NOT NULL) AND (p_new_carrier_id IS NULL)) THEN
2122:
2123: --Carrier on the Delivery getting nulled out/cancelled.
2124: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2125: p_entity_id => p_delivery_id,
2126: p_event => 'oracle.apps.wsh.delivery.gen.carriercancelled',
2127: p_organization_id => l_org_id,
2128: x_return_status => l_wf_rs);

Line 2134: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',

2130: ELSIF ((p_old_carrier_id IS NOT NULL) AND (p_new_carrier_id IS NOT NULL) AND
2131: (p_old_carrier_id <> p_new_carrier_id)) THEN
2132:
2133: --Change in carrier from existing one to a new one.
2134: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2135: p_entity_id => p_delivery_id,
2136: p_event => 'oracle.apps.wsh.delivery.gen.carriercancelled',
2137: p_organization_id => l_org_id,
2138: x_return_status => l_wf_rs);

Line 2140: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',

2136: p_event => 'oracle.apps.wsh.delivery.gen.carriercancelled',
2137: p_organization_id => l_org_id,
2138: x_return_status => l_wf_rs);
2139:
2140: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2141: p_entity_id => p_delivery_id,
2142: p_event => 'oracle.apps.wsh.delivery.gen.carrierselected',
2143: p_organization_id => l_org_id,
2144: x_return_status => l_wf_rs);

Line 2166: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');

2162:
2163: EXCEPTION
2164: WHEN OTHERS THEN
2165: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2166: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');
2167: IF l_debug_on THEN
2168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2170: END IF;

Line 2199: END WSH_WF_STD;

2195: CLOSE c_dels;
2196:
2197: END Get_Deliveries;
2198: */
2199: END WSH_WF_STD;