DBA Data[Home] [Help]

APPS.FTE_WSH_INTERFACE_PKG dependencies on WSH_DEBUG_SV

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

1881: --
1882: l_number_of_errors NUMBER := 0;
1883: l_number_of_warnings NUMBER := 0;
1884: --
1885: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1886:
1887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_WSH_INTERFACE_PKG' || '.' || 'segment_stop_change';
1888:
1889: --

Line 1915: wsh_debug_sv.push(l_module_name);

1911: -- Initialize message list if p_init_msg_list is set to TRUE.
1912: --
1913: --
1914: IF l_debug_on THEN
1915: wsh_debug_sv.push(l_module_name);
1916: END IF;
1917:
1918:
1919: IF FND_API.to_Boolean( p_init_msg_list )

Line 2004: WSH_DEBUG_SV.logmsg(l_module_name,'Adding Stop',

2000: --{
2001:
2002: IF l_debug_on THEN
2003:
2004: WSH_DEBUG_SV.logmsg(l_module_name,'Adding Stop',
2005: WSH_DEBUG_SV.C_PROC_LEVEL);
2006: END IF;
2007:
2008: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD';

Line 2005: WSH_DEBUG_SV.C_PROC_LEVEL);

2001:
2002: IF l_debug_on THEN
2003:
2004: WSH_DEBUG_SV.logmsg(l_module_name,'Adding Stop',
2005: WSH_DEBUG_SV.C_PROC_LEVEL);
2006: END IF;
2007:
2008: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD';
2009: --

Line 2046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP',

2042: -- which is TENDERED or ACCEPTED PACK I
2043: --
2044: IF l_debug_on THEN
2045:
2046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP',
2047: WSH_DEBUG_SV.C_PROC_LEVEL);
2048: END IF;
2049:
2050: FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP(

Line 2047: WSH_DEBUG_SV.C_PROC_LEVEL);

2043: --
2044: IF l_debug_on THEN
2045:
2046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP',
2047: WSH_DEBUG_SV.C_PROC_LEVEL);
2048: END IF;
2049:
2050: FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP(
2051: P_api_version => 1.0,

Line 2073: WSH_DEBUG_SV.logmsg(l_module_name,'Updating Stop',

2069: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE';
2070:
2071: IF l_debug_on THEN
2072:
2073: WSH_DEBUG_SV.logmsg(l_module_name,'Updating Stop',
2074: WSH_DEBUG_SV.C_PROC_LEVEL);
2075: END IF;
2076: --
2077: --

Line 2074: WSH_DEBUG_SV.C_PROC_LEVEL);

2070:
2071: IF l_debug_on THEN
2072:
2073: WSH_DEBUG_SV.logmsg(l_module_name,'Updating Stop',
2074: WSH_DEBUG_SV.C_PROC_LEVEL);
2075: END IF;
2076: --
2077: --
2078: validate_stop_update

Line 2098: wsh_debug_sv.log (l_module_name,' After validate stop update');

2094: x_num_errors =>l_number_of_errors);
2095:
2096:
2097: IF l_debug_on THEN
2098: wsh_debug_sv.log (l_module_name,' After validate stop update');
2099: wsh_debug_sv.log (l_module_name,' l_return_status ' || l_return_status);
2100: END IF;
2101:
2102: --

Line 2099: wsh_debug_sv.log (l_module_name,' l_return_status ' || l_return_status);

2095:
2096:
2097: IF l_debug_on THEN
2098: wsh_debug_sv.log (l_module_name,' After validate stop update');
2099: wsh_debug_sv.log (l_module_name,' l_return_status ' || l_return_status);
2100: END IF;
2101:
2102: --
2103: -- Check for the threshold value if this stop belongs to a trip

Line 2108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP',

2104: -- which is TENDERED or ACCEPTED PACK I
2105: --
2106: IF l_debug_on THEN
2107:
2108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP',
2109: WSH_DEBUG_SV.C_PROC_LEVEL);
2110: END IF;
2111:
2112:

Line 2109: WSH_DEBUG_SV.C_PROC_LEVEL);

2105: --
2106: IF l_debug_on THEN
2107:
2108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP',
2109: WSH_DEBUG_SV.C_PROC_LEVEL);
2110: END IF;
2111:
2112:
2113: FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP(

Line 2123: WSH_DEBUG_SV.logmsg(l_module_name,' return status from CHECK_THRESHOLD_FOR_STOP ' ||

2119: P_trip_segment_rec => p_trip_segment_rec,
2120: P_new_segment_stop_rec => l_current_stop_rec);
2121:
2122: IF l_debug_on THEN
2123: WSH_DEBUG_SV.logmsg(l_module_name,' return status from CHECK_THRESHOLD_FOR_STOP ' ||
2124: l_return_status,
2125: WSH_DEBUG_SV.C_PROC_LEVEL);
2126: WSH_DEBUG_SV.logmsg(l_module_name,' message count ' || l_msg_count,
2127: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2125: WSH_DEBUG_SV.C_PROC_LEVEL);

2121:
2122: IF l_debug_on THEN
2123: WSH_DEBUG_SV.logmsg(l_module_name,' return status from CHECK_THRESHOLD_FOR_STOP ' ||
2124: l_return_status,
2125: WSH_DEBUG_SV.C_PROC_LEVEL);
2126: WSH_DEBUG_SV.logmsg(l_module_name,' message count ' || l_msg_count,
2127: WSH_DEBUG_SV.C_PROC_LEVEL);
2128: WSH_DEBUG_SV.logmsg(l_module_name,' message data ' || l_msg_data,
2129: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2126: WSH_DEBUG_SV.logmsg(l_module_name,' message count ' || l_msg_count,

2122: IF l_debug_on THEN
2123: WSH_DEBUG_SV.logmsg(l_module_name,' return status from CHECK_THRESHOLD_FOR_STOP ' ||
2124: l_return_status,
2125: WSH_DEBUG_SV.C_PROC_LEVEL);
2126: WSH_DEBUG_SV.logmsg(l_module_name,' message count ' || l_msg_count,
2127: WSH_DEBUG_SV.C_PROC_LEVEL);
2128: WSH_DEBUG_SV.logmsg(l_module_name,' message data ' || l_msg_data,
2129: WSH_DEBUG_SV.C_PROC_LEVEL);
2130: END IF;

Line 2127: WSH_DEBUG_SV.C_PROC_LEVEL);

2123: WSH_DEBUG_SV.logmsg(l_module_name,' return status from CHECK_THRESHOLD_FOR_STOP ' ||
2124: l_return_status,
2125: WSH_DEBUG_SV.C_PROC_LEVEL);
2126: WSH_DEBUG_SV.logmsg(l_module_name,' message count ' || l_msg_count,
2127: WSH_DEBUG_SV.C_PROC_LEVEL);
2128: WSH_DEBUG_SV.logmsg(l_module_name,' message data ' || l_msg_data,
2129: WSH_DEBUG_SV.C_PROC_LEVEL);
2130: END IF;
2131:

Line 2128: WSH_DEBUG_SV.logmsg(l_module_name,' message data ' || l_msg_data,

2124: l_return_status,
2125: WSH_DEBUG_SV.C_PROC_LEVEL);
2126: WSH_DEBUG_SV.logmsg(l_module_name,' message count ' || l_msg_count,
2127: WSH_DEBUG_SV.C_PROC_LEVEL);
2128: WSH_DEBUG_SV.logmsg(l_module_name,' message data ' || l_msg_data,
2129: WSH_DEBUG_SV.C_PROC_LEVEL);
2130: END IF;
2131:
2132: wsh_util_core.api_post_call(

Line 2129: WSH_DEBUG_SV.C_PROC_LEVEL);

2125: WSH_DEBUG_SV.C_PROC_LEVEL);
2126: WSH_DEBUG_SV.logmsg(l_module_name,' message count ' || l_msg_count,
2127: WSH_DEBUG_SV.C_PROC_LEVEL);
2128: WSH_DEBUG_SV.logmsg(l_module_name,' message data ' || l_msg_data,
2129: WSH_DEBUG_SV.C_PROC_LEVEL);
2130: END IF;
2131:
2132: wsh_util_core.api_post_call(
2133: p_return_status =>l_return_status,

Line 2225: WSH_DEBUG_SV.pop(l_module_name);

2221: --fnd_message.set_name('WSH','END');
2222: --
2223:
2224: IF l_debug_on THEN
2225: WSH_DEBUG_SV.pop(l_module_name);
2226: END IF;
2227:
2228: --
2229: --}

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

2238: p_data => x_msg_data,
2239: p_encoded => FND_API.G_FALSE
2240: );
2241: IF l_debug_on THEN
2242: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2243: WSH_DEBUG_SV.pop(l_module_name);
2244: END IF;
2245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2246: ROLLBACK TO SEGMENT_STOP_CHANGE_PUB;

Line 2243: WSH_DEBUG_SV.pop(l_module_name);

2239: p_encoded => FND_API.G_FALSE
2240: );
2241: IF l_debug_on THEN
2242: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2243: WSH_DEBUG_SV.pop(l_module_name);
2244: END IF;
2245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2246: ROLLBACK TO SEGMENT_STOP_CHANGE_PUB;
2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2255: WSH_DEBUG_SV.pop(l_module_name);

2251: p_data => x_msg_data,
2252: p_encoded => FND_API.G_FALSE
2253: );
2254: IF l_debug_on THEN
2255: WSH_DEBUG_SV.pop(l_module_name);
2256: END IF;
2257: WHEN OTHERS THEN
2258: ROLLBACK TO SEGMENT_STOP_CHANGE_PUB;
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2261: wsh_debug_sv.log (l_module_name,' Unexpected error ');

2257: WHEN OTHERS THEN
2258: ROLLBACK TO SEGMENT_STOP_CHANGE_PUB;
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2260: IF l_debug_on THEN
2261: wsh_debug_sv.log (l_module_name,' Unexpected error ');
2262: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2263: WSH_DEBUG_SV.pop(l_module_name);
2264: END IF;
2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');

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

2258: ROLLBACK TO SEGMENT_STOP_CHANGE_PUB;
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2260: IF l_debug_on THEN
2261: wsh_debug_sv.log (l_module_name,' Unexpected error ');
2262: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2263: WSH_DEBUG_SV.pop(l_module_name);
2264: END IF;
2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2263: WSH_DEBUG_SV.pop(l_module_name);

2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2260: IF l_debug_on THEN
2261: wsh_debug_sv.log (l_module_name,' Unexpected error ');
2262: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2263: WSH_DEBUG_SV.pop(l_module_name);
2264: END IF;
2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2267: --

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

2892: IS
2893:
2894: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRIP_ORG_ORGANIZATION';
2895: l_api_version CONSTANT NUMBER := 1.0;
2896: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2897: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2898:
2899:
2900: l_return_status VARCHAR2(32767);

Line 2927: WSH_DEBUG_SV.push(l_module_name);

2923: BEGIN
2924:
2925:
2926: IF l_debug_on THEN
2927: WSH_DEBUG_SV.push(l_module_name);
2928: END IF;
2929:
2930: IF FND_API.to_Boolean( p_init_msg_list )
2931: THEN

Line 2946: WSH_DEBUG_SV.logmsg(l_module_name,' FTE_MLS_UTIL.GET_TRIP_ORGANIZATION_ID for entity ' ||

2942: l_org_id := NULL;
2943:
2944: IF l_debug_on
2945: THEN
2946: WSH_DEBUG_SV.logmsg(l_module_name,' FTE_MLS_UTIL.GET_TRIP_ORGANIZATION_ID for entity ' ||
2947: p_entity_id,
2948: WSH_DEBUG_SV.C_PROC_LEVEL);
2949: END IF;
2950:

Line 2948: WSH_DEBUG_SV.C_PROC_LEVEL);

2944: IF l_debug_on
2945: THEN
2946: WSH_DEBUG_SV.logmsg(l_module_name,' FTE_MLS_UTIL.GET_TRIP_ORGANIZATION_ID for entity ' ||
2947: p_entity_id,
2948: WSH_DEBUG_SV.C_PROC_LEVEL);
2949: END IF;
2950:
2951: IF (p_entity_type IN ('TRIP', 'STOP'))
2952: THEN

Line 3052: WSH_DEBUG_SV.pop(l_module_name);

3048: --
3049: --
3050:
3051: IF l_debug_on THEN
3052: WSH_DEBUG_SV.pop(l_module_name);
3053: END IF;
3054:
3055: --}
3056: EXCEPTION

Line 3067: WSH_DEBUG_SV.pop(l_module_name);

3063: p_data => x_msg_data,
3064: p_encoded => FND_API.G_FALSE
3065: );
3066: IF l_debug_on THEN
3067: WSH_DEBUG_SV.pop(l_module_name);
3068: END IF;
3069:
3070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3079: WSH_DEBUG_SV.pop(l_module_name);

3075: p_data => x_msg_data,
3076: p_encoded => FND_API.G_FALSE
3077: );
3078: IF l_debug_on THEN
3079: WSH_DEBUG_SV.pop(l_module_name);
3080: END IF;
3081: WHEN OTHERS THEN
3082: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_TRIP_ORG_ORGANIZATION');
3083: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3091: WSH_DEBUG_SV.pop(l_module_name);

3087: p_data => x_msg_data,
3088: p_encoded => FND_API.G_FALSE
3089: );
3090: IF l_debug_on THEN
3091: WSH_DEBUG_SV.pop(l_module_name);
3092: END IF;
3093:
3094: END GET_ORG_ORGANIZATION_INFO;
3095: