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.FTE_TRACKING_WRAPPER dependencies on WSH_DEBUG_SV

Line 2000: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1996:
1997: --For Workflow Impact on ITM
1998: l_parameter_list wf_parameter_list_t;
1999:
2000: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2001: --
2002: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'call_last_delivery_leg';
2003:
2004:

Line 2033: wsh_debug_sv.push(l_module_name);

2029: SAVEPOINT CALL_LAST_DELIVERY_LEG_PUB;
2030:
2031:
2032: IF l_debug_on THEN
2033: wsh_debug_sv.push(l_module_name);
2034: END IF;
2035:
2036:
2037: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2087: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || l_last_stop_id);

2083: CLOSE get_last_delivery_leg;
2084:
2085: IF l_debug_on THEN
2086:
2087: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || l_last_stop_id);
2088: WSH_DEBUG_SV.logmsg(l_module_name,' Stop status ' || l_last_stop_status);
2089: WSH_DEBUG_SV.logmsg(l_module_name,' Last dleg id ' || l_last_delivery_leg);
2090: WSH_DEBUG_SV.logmsg(l_module_name,' Dlvy UD LocatioId ' || l_dlvy_ud_location_id);
2091: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Location Id ' || l_last_stop_location_id);

Line 2088: WSH_DEBUG_SV.logmsg(l_module_name,' Stop status ' || l_last_stop_status);

2084:
2085: IF l_debug_on THEN
2086:
2087: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || l_last_stop_id);
2088: WSH_DEBUG_SV.logmsg(l_module_name,' Stop status ' || l_last_stop_status);
2089: WSH_DEBUG_SV.logmsg(l_module_name,' Last dleg id ' || l_last_delivery_leg);
2090: WSH_DEBUG_SV.logmsg(l_module_name,' Dlvy UD LocatioId ' || l_dlvy_ud_location_id);
2091: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Location Id ' || l_last_stop_location_id);
2092: END IF;

Line 2089: WSH_DEBUG_SV.logmsg(l_module_name,' Last dleg id ' || l_last_delivery_leg);

2085: IF l_debug_on THEN
2086:
2087: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || l_last_stop_id);
2088: WSH_DEBUG_SV.logmsg(l_module_name,' Stop status ' || l_last_stop_status);
2089: WSH_DEBUG_SV.logmsg(l_module_name,' Last dleg id ' || l_last_delivery_leg);
2090: WSH_DEBUG_SV.logmsg(l_module_name,' Dlvy UD LocatioId ' || l_dlvy_ud_location_id);
2091: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Location Id ' || l_last_stop_location_id);
2092: END IF;
2093:

Line 2090: WSH_DEBUG_SV.logmsg(l_module_name,' Dlvy UD LocatioId ' || l_dlvy_ud_location_id);

2086:
2087: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || l_last_stop_id);
2088: WSH_DEBUG_SV.logmsg(l_module_name,' Stop status ' || l_last_stop_status);
2089: WSH_DEBUG_SV.logmsg(l_module_name,' Last dleg id ' || l_last_delivery_leg);
2090: WSH_DEBUG_SV.logmsg(l_module_name,' Dlvy UD LocatioId ' || l_dlvy_ud_location_id);
2091: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Location Id ' || l_last_stop_location_id);
2092: END IF;
2093:
2094: IF l_last_delivery_leg IS NOT NULL THEN

Line 2091: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Location Id ' || l_last_stop_location_id);

2087: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || l_last_stop_id);
2088: WSH_DEBUG_SV.logmsg(l_module_name,' Stop status ' || l_last_stop_status);
2089: WSH_DEBUG_SV.logmsg(l_module_name,' Last dleg id ' || l_last_delivery_leg);
2090: WSH_DEBUG_SV.logmsg(l_module_name,' Dlvy UD LocatioId ' || l_dlvy_ud_location_id);
2091: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Location Id ' || l_last_stop_location_id);
2092: END IF;
2093:
2094: IF l_last_delivery_leg IS NOT NULL THEN
2095:

Line 2175: WSH_DEBUG_SV.logmsg(l_module_name,' Stop is closed nothing to update ' || l_last_stop_id);

2171:
2172: IF (l_last_stop_status = 'CL') THEN
2173: IF l_debug_on THEN
2174:
2175: WSH_DEBUG_SV.logmsg(l_module_name,' Stop is closed nothing to update ' || l_last_stop_id);
2176: WSH_DEBUG_SV.pop(l_module_name);
2177: END IF;
2178:
2179: RETURN;

Line 2176: WSH_DEBUG_SV.pop(l_module_name);

2172: IF (l_last_stop_status = 'CL') THEN
2173: IF l_debug_on THEN
2174:
2175: WSH_DEBUG_SV.logmsg(l_module_name,' Stop is closed nothing to update ' || l_last_stop_id);
2176: WSH_DEBUG_SV.pop(l_module_name);
2177: END IF;
2178:
2179: RETURN;
2180: ELSE

Line 2185: WSH_DEBUG_SV.logmsg(l_module_name,' Calling stop action with ARRIVE ' || l_last_stop_id);

2181:
2182:
2183: IF l_debug_on THEN
2184:
2185: WSH_DEBUG_SV.logmsg(l_module_name,' Calling stop action with ARRIVE ' || l_last_stop_id);
2186: END IF;
2187:
2188:
2189: p_entity_id_tab(1):= l_last_stop_id;

Line 2211: WSH_DEBUG_SV.logmsg(l_module_name,'After calling stop action');

2207:
2208: );
2209:
2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.logmsg(l_module_name,'After calling stop action');
2212: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
2213: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
2215:

Line 2212: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);

2208: );
2209:
2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.logmsg(l_module_name,'After calling stop action');
2212: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
2213: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
2215:
2216: END IF;

Line 2213: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);

2209:
2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.logmsg(l_module_name,'After calling stop action');
2212: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
2213: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
2215:
2216: END IF;
2217:

Line 2214: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);

2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.logmsg(l_module_name,'After calling stop action');
2212: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
2213: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
2215:
2216: END IF;
2217:
2218:

Line 2245: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);

2241:
2242: END IF;
2243:
2244: IF l_debug_on THEN
2245: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2246: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2247: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
2248:
2249: END IF;

Line 2246: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);

2242: END IF;
2243:
2244: IF l_debug_on THEN
2245: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2246: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2247: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
2248:
2249: END IF;
2250:

Line 2247: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);

2243:
2244: IF l_debug_on THEN
2245: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2246: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2247: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
2248:
2249: END IF;
2250:
2251:

Line 2253: WSH_DEBUG_SV.pop(l_module_name);

2249: END IF;
2250:
2251:
2252: IF l_debug_on THEN
2253: WSH_DEBUG_SV.pop(l_module_name);
2254: END IF;
2255: EXCEPTION
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;

Line 2266: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);

2262: p_data => x_msg_data,
2263: p_encoded => FND_API.G_FALSE
2264: );
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2268: WSH_DEBUG_SV.pop(l_module_name);
2269: END IF;
2270:

Line 2267: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);

2263: p_encoded => FND_API.G_FALSE
2264: );
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2268: WSH_DEBUG_SV.pop(l_module_name);
2269: END IF;
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2268: WSH_DEBUG_SV.pop(l_module_name);

2264: );
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2268: WSH_DEBUG_SV.pop(l_module_name);
2269: END IF;
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;

Line 2281: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);

2277: p_data => x_msg_data,
2278: p_encoded => FND_API.G_FALSE
2279: );
2280: IF l_debug_on THEN
2281: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2282: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2283: WSH_DEBUG_SV.pop(l_module_name);
2284: END IF;
2285: WHEN OTHERS THEN

Line 2282: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);

2278: p_encoded => FND_API.G_FALSE
2279: );
2280: IF l_debug_on THEN
2281: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2282: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2283: WSH_DEBUG_SV.pop(l_module_name);
2284: END IF;
2285: WHEN OTHERS THEN
2286: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;

Line 2283: WSH_DEBUG_SV.pop(l_module_name);

2279: );
2280: IF l_debug_on THEN
2281: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2282: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2283: WSH_DEBUG_SV.pop(l_module_name);
2284: END IF;
2285: WHEN OTHERS THEN
2286: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;
2287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2290: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));

2286: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;
2287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2288: x_msg_data := substr(sqlerrm,1,200);
2289: IF l_debug_on THEN
2290: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2291: WSH_DEBUG_SV.pop(l_module_name);
2292: END IF;
2293:
2294: FND_MSG_PUB.Count_And_Get

Line 2291: WSH_DEBUG_SV.pop(l_module_name);

2287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2288: x_msg_data := substr(sqlerrm,1,200);
2289: IF l_debug_on THEN
2290: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2291: WSH_DEBUG_SV.pop(l_module_name);
2292: END IF;
2293:
2294: FND_MSG_PUB.Count_And_Get
2295: (