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.12.12010000.4 2010/03/11 07:33:06 sankarun 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.12.12010000.4 2010/03/11 07:33:06 sankarun 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 888: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS',

884: FETCH get_org_code into l_organization_code;
885: CLOSE get_org_code ;
886:
887: IF l_debug_on THEN
888: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS',
889: WSH_DEBUG_SV.C_PROC_LEVEL);
890: END IF;
891:
892: Get_Custom_Wf_Process(p_wf_process => x_wf_process,

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

1010: -- Raise event if a workflow process exists
1011: IF (p_entity_type = 'TRIP' or p_entity_type = 'DELIVERY') THEN
1012:
1013: IF l_debug_on THEN
1014: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.CHECK_WF_EXISTS',
1015: WSH_DEBUG_SV.C_PROC_LEVEL);
1016: END IF;
1017:
1018: check_wf_exists(p_entity_type => p_entity_type,

Line 1943: -- This API must be called only from wsh_wf_std.instance_default_rule

1939: -- and pass the event to those processes which are waiting to receive the
1940: -- corresponding event by calling WF API wf_engine.event.
1941: --
1942: -- The return status could be SUCCESS/ERROR
1943: -- This API must be called only from wsh_wf_std.instance_default_rule
1944: -- SCOPE : PRIVATE
1945: -- PARAMETERS: p_subscription_guid Unique identifier of the subscription for B.Event.
1946: --
1947: -- p_event Event info containing even name,event id , etc.,

Line 1953: -- event system via api wsh_wf_std.instance_default_rule

1949: -- COMMENT : This Function is used to derive the delivery generic/ship to deliver/trip
1950: -- workflow process name and then pass the event information to those processes
1951: -- to receive this event passed.
1952: -- The return status could be SUCCESS/ERROR which will be reported to business
1953: -- event system via api wsh_wf_std.instance_default_rule
1954: --
1955: -- This function is introduced as part of bugfix 8706771 and this is replacement
1956: -- for function wsh_wf_std.instance_default_rule
1957: --========================================================================================

Line 1956: -- for function wsh_wf_std.instance_default_rule

1952: -- The return status could be SUCCESS/ERROR which will be reported to business
1953: -- event system via api wsh_wf_std.instance_default_rule
1954: --
1955: -- This function is introduced as part of bugfix 8706771 and this is replacement
1956: -- for function wsh_wf_std.instance_default_rule
1957: --========================================================================================
1958: FUNCTION WF_ENGINE_EVENT (p_subscription_guid in raw,
1959: p_event in out nocopy WF_EVENT_T) return
1960: VARCHAR2 is

Line 2016: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_WF_NAME', WSH_DEBUG_SV.C_PROC_LEVEL);

2012: l_eventname = 'oracle.apps.wsh.delivery.gen.closed' OR
2013: l_eventname = 'oracle.apps.wsh.delivery.gen.interfaced') THEN -- Events specific to delivery workflow.
2014: --{
2015: IF l_debug_on THEN
2016: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_WF_NAME', WSH_DEBUG_SV.C_PROC_LEVEL);
2017: END IF;
2018:
2019: l_wf_pr_name := GET_WF_NAME('DELIVERY',l_entityid);
2020:

Line 2038: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_WF_NAME', WSH_DEBUG_SV.C_PROC_LEVEL);

2034: process_name => l_wf_pr_name,
2035: event_message => p_event);
2036: ELSE
2037: IF l_debug_on THEN
2038: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_WF_NAME', WSH_DEBUG_SV.C_PROC_LEVEL);
2039: END IF;
2040:
2041: l_wf_pr_name := GET_WF_NAME('DELIVERY_C',l_entityid);
2042:

Line 2063: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_WF_NAME', WSH_DEBUG_SV.C_PROC_LEVEL);

2059: ELSIF (l_eventname = 'oracle.apps.wsh.trip.gen.initialpickupstopclosed' OR
2060: l_eventname = 'oracle.apps.wsh.trip.gen.ultimatedropoffstopclosed') THEN -- Events specific to Trip workflow
2061:
2062: IF l_debug_on THEN
2063: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_WF_NAME', WSH_DEBUG_SV.C_PROC_LEVEL);
2064: END IF;
2065:
2066: l_wf_pr_name := GET_WF_NAME('TRIP',l_entityid);
2067:

Line 2115: WF_CORE.CONTEXT('WSH_WF_STD', 'WF_ENGINE_EVENT',p_event.getEventName( ), p_subscription_guid);

2111: RETURN 'SUCCESS';
2112:
2113: EXCEPTION
2114: WHEN e_entityid_notfound THEN
2115: WF_CORE.CONTEXT('WSH_WF_STD', 'WF_ENGINE_EVENT',p_event.getEventName( ), p_subscription_guid);
2116: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2117:
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'Associated Entity Id not found. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2126: WF_CORE.CONTEXT('WSH_WF_STD', 'WF_ENGINE_EVENT',p_event.getEventName( ), p_subscription_guid);

2122:
2123: RETURN 'ERROR';
2124:
2125: WHEN e_event_error THEN
2126: WF_CORE.CONTEXT('WSH_WF_STD', 'WF_ENGINE_EVENT',p_event.getEventName( ), p_subscription_guid);
2127: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2128:
2129: IF l_debug_on THEN
2130: WSH_DEBUG_SV.logmsg(l_module_name,'Some Entities had errors while raising events. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2137: WF_CORE.CONTEXT('WSH_WF_STD', 'WF_ENGINE_EVENT',p_event.getEventName( ), p_subscription_guid);

2133:
2134: RETURN 'ERROR';
2135:
2136: WHEN others THEN
2137: WF_CORE.CONTEXT('WSH_WF_STD', 'WF_ENGINE_EVENT',p_event.getEventName( ), p_subscription_guid);
2138: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2139:
2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2203: -- From now on this API will just redirect the call to the newly created API WSH_WF_STD.WF_ENGINE_EVENT.

2199:
2200: BEGIN
2201: -- De-supporting the usage of this API code logic due to bug 8706771.
2202: -- Removing all the code inside the begin block and commenting almost all local variables in the declaration part.
2203: -- From now on this API will just redirect the call to the newly created API WSH_WF_STD.WF_ENGINE_EVENT.
2204: -- This API is not removed since the subscription of business event has this one specified.SO instead of making changes there,
2205: -- we are still keeping the skeleton of this API as it is,but redirecting the code logic to new API.
2206: -- For more details refer bug 8706771.
2207:

Line 2219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.WF_ENGINE_EVENT', WSH_DEBUG_SV.C_PROC_LEVEL);

2215: END IF;
2216: --
2217: IF l_debug_on THEN
2218: WSH_DEBUG_SV.push(l_module_name);
2219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.WF_ENGINE_EVENT', WSH_DEBUG_SV.C_PROC_LEVEL);
2220: END IF;
2221:
2222: l_return_status := WF_ENGINE_EVENT( p_subscription_guid => p_subscription_guid,
2223: p_event => p_event);

Line 2249: WSH_WF_STD.G_RESET_APPS_CONTEXT := TRUE;

2245: l_debug_on BOOLEAN;
2246: --
2247: BEGIN
2248:
2249: WSH_WF_STD.G_RESET_APPS_CONTEXT := TRUE;
2250: IF l_debug_on THEN
2251: WSH_DEBUG_SV.push(l_module_name);
2252: WSH_DEBUG_SV.pop(l_module_name);
2253: END IF;

Line 2267: WSH_WF_STD.G_RESET_APPS_CONTEXT := FALSE;

2263: l_debug_on BOOLEAN;
2264: --
2265: BEGIN
2266:
2267: WSH_WF_STD.G_RESET_APPS_CONTEXT := FALSE;
2268: IF l_debug_on THEN
2269: WSH_DEBUG_SV.push(l_module_name);
2270: WSH_DEBUG_SV.pop(l_module_name);
2271: END IF;

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

2335:
2336: EXCEPTION
2337: WHEN OTHERS THEN
2338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2339: wsh_util_core.default_handler('WSH_WF_STD.GET_CARRIER');
2340: IF l_debug_on THEN
2341: --{
2342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2343: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2416:
2417: IF ((p_old_carrier_id IS NULL) AND (p_new_carrier_id IS NOT NULL)) THEN
2418:
2419: --Carrier on the delivery getting assigned for first time.
2420: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2421: p_entity_id => p_delivery_id,
2422: p_event => 'oracle.apps.wsh.delivery.gen.carrierselected',
2423: p_organization_id => l_org_id,
2424: x_return_status => l_wf_rs);

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

2425:
2426: ELSIF ((p_old_carrier_id IS NOT NULL) AND (p_new_carrier_id IS NULL)) THEN
2427:
2428: --Carrier on the Delivery getting nulled out/cancelled.
2429: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2430: p_entity_id => p_delivery_id,
2431: p_event => 'oracle.apps.wsh.delivery.gen.carriercancelled',
2432: p_organization_id => l_org_id,
2433: x_return_status => l_wf_rs);

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

2435: ELSIF ((p_old_carrier_id IS NOT NULL) AND (p_new_carrier_id IS NOT NULL) AND
2436: (p_old_carrier_id <> p_new_carrier_id)) THEN
2437:
2438: --Change in carrier from existing one to a new one.
2439: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2440: p_entity_id => p_delivery_id,
2441: p_event => 'oracle.apps.wsh.delivery.gen.carriercancelled',
2442: p_organization_id => l_org_id,
2443: x_return_status => l_wf_rs);

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

2441: p_event => 'oracle.apps.wsh.delivery.gen.carriercancelled',
2442: p_organization_id => l_org_id,
2443: x_return_status => l_wf_rs);
2444:
2445: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
2446: p_entity_id => p_delivery_id,
2447: p_event => 'oracle.apps.wsh.delivery.gen.carrierselected',
2448: p_organization_id => l_org_id,
2449: x_return_status => l_wf_rs);

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

2467:
2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2471: wsh_util_core.default_handler('WSH_WF_STD.Assign_Unassign_Carrier');
2472: IF l_debug_on THEN
2473: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2474: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2475: END IF;

Line 2505: END WSH_WF_STD;

2501:
2502: END Get_Deliveries;
2503: */
2504:
2505: END WSH_WF_STD;