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_MLS_UTIL dependencies on WSH_DEBUG_SV

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

2276: PROCEDURE COPY_FTE_ID_TO_WSH_ID (p_fte_id_tab IN FTE_ID_TAB_TYPE,
2277: x_wsh_id_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE)
2278: AS
2279:
2280: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2281: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'COPY_FTE_ID_TO_WSH_ID';
2282:
2283:
2284: BEGIN

Line 2287: wsh_debug_sv.push(l_module_name);

2283:
2284: BEGIN
2285:
2286: IF l_debug_on THEN
2287: wsh_debug_sv.push(l_module_name);
2288: END IF;
2289:
2290:
2291: IF (p_fte_id_tab.count > 0) THEN

Line 2295: WSH_DEBUG_SV.logmsg(l_module_name,' Copying Id ' || x_wsh_id_tab(i));

2291: IF (p_fte_id_tab.count > 0) THEN
2292: FOR i in 1..p_fte_id_tab.count LOOP
2293: x_wsh_id_tab(i) := p_fte_id_tab(i);
2294: IF l_debug_on THEN
2295: WSH_DEBUG_SV.logmsg(l_module_name,' Copying Id ' || x_wsh_id_tab(i));
2296: END IF;
2297: END LOOP;
2298: END IF;
2299:

Line 2301: wsh_debug_sv.pop(l_module_name);

2297: END LOOP;
2298: END IF;
2299:
2300: IF l_debug_on THEN
2301: wsh_debug_sv.pop(l_module_name);
2302: END IF;
2303:
2304:
2305: EXCEPTION

Line 2308: wsh_debug_sv.log (l_module_name,'UTIL ERROR',substr(sqlerrm,1,200));

2304:
2305: EXCEPTION
2306: WHEN OTHERS THEN
2307: IF l_debug_on THEN
2308: wsh_debug_sv.log (l_module_name,'UTIL ERROR',substr(sqlerrm,1,200));
2309: wsh_debug_sv.pop(l_module_name);
2310: END IF;
2311: RAISE;
2312: END COPY_FTE_ID_TO_WSH_ID;

Line 2309: wsh_debug_sv.pop(l_module_name);

2305: EXCEPTION
2306: WHEN OTHERS THEN
2307: IF l_debug_on THEN
2308: wsh_debug_sv.log (l_module_name,'UTIL ERROR',substr(sqlerrm,1,200));
2309: wsh_debug_sv.pop(l_module_name);
2310: END IF;
2311: RAISE;
2312: END COPY_FTE_ID_TO_WSH_ID;
2313: --}

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

2328: PROCEDURE COPY_WSH_ID_TO_FTE_ID (p_wsh_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
2329: x_fte_id_tab IN OUT NOCOPY FTE_ID_TAB_TYPE)
2330: AS
2331:
2332: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2333: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'COPY_FTE_ID_TO_WSH_ID';
2334:
2335:
2336: BEGIN

Line 2339: wsh_debug_sv.push(l_module_name);

2335:
2336: BEGIN
2337:
2338: IF l_debug_on THEN
2339: wsh_debug_sv.push(l_module_name);
2340: END IF;
2341:
2342:
2343: IF (p_wsh_id_tab.count > 0) THEN

Line 2347: WSH_DEBUG_SV.logmsg(l_module_name,' Copying Id ' || p_wsh_id_tab(i));

2343: IF (p_wsh_id_tab.count > 0) THEN
2344: FOR i in 1..p_wsh_id_tab.count LOOP
2345: x_fte_id_tab.EXTEND;
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,' Copying Id ' || p_wsh_id_tab(i));
2348: END IF;
2349: x_fte_id_tab(i) := p_wsh_id_tab(i);
2350: END LOOP;
2351: END IF;

Line 2354: wsh_debug_sv.pop(l_module_name);

2350: END LOOP;
2351: END IF;
2352:
2353: IF l_debug_on THEN
2354: wsh_debug_sv.pop(l_module_name);
2355: END IF;
2356:
2357: EXCEPTION
2358: WHEN OTHERS THEN

Line 2360: wsh_debug_sv.log (l_module_name,'UTIL ERROR',substr(sqlerrm,1,200));

2356:
2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: IF l_debug_on THEN
2360: wsh_debug_sv.log (l_module_name,'UTIL ERROR',substr(sqlerrm,1,200));
2361: wsh_debug_sv.pop(l_module_name);
2362: END IF;
2363: RAISE;
2364: END COPY_WSH_ID_TO_FTE_ID;

Line 2361: wsh_debug_sv.pop(l_module_name);

2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: IF l_debug_on THEN
2360: wsh_debug_sv.log (l_module_name,'UTIL ERROR',substr(sqlerrm,1,200));
2361: wsh_debug_sv.pop(l_module_name);
2362: END IF;
2363: RAISE;
2364: END COPY_WSH_ID_TO_FTE_ID;
2365:

Line 2428: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2424: BEGIN
2425: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2426:
2427: IF l_debug_on IS NULL THEN
2428: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2429: END IF;
2430:
2431: IF l_debug_on THEN
2432: WSH_DEBUG_SV.push(l_module_name);

Line 2432: WSH_DEBUG_SV.push(l_module_name);

2428: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2429: END IF;
2430:
2431: IF l_debug_on THEN
2432: WSH_DEBUG_SV.push(l_module_name);
2433: WSH_DEBUG_SV.log(l_module_name,'p_lookup_type',p_lookup_type);
2434: WSH_DEBUG_SV.log(l_module_name,'P_lookup_code',P_lookup_code);
2435: END IF;
2436:

Line 2433: WSH_DEBUG_SV.log(l_module_name,'p_lookup_type',p_lookup_type);

2429: END IF;
2430:
2431: IF l_debug_on THEN
2432: WSH_DEBUG_SV.push(l_module_name);
2433: WSH_DEBUG_SV.log(l_module_name,'p_lookup_type',p_lookup_type);
2434: WSH_DEBUG_SV.log(l_module_name,'P_lookup_code',P_lookup_code);
2435: END IF;
2436:
2437: OPEN get_meaning;

Line 2434: WSH_DEBUG_SV.log(l_module_name,'P_lookup_code',P_lookup_code);

2430:
2431: IF l_debug_on THEN
2432: WSH_DEBUG_SV.push(l_module_name);
2433: WSH_DEBUG_SV.log(l_module_name,'p_lookup_type',p_lookup_type);
2434: WSH_DEBUG_SV.log(l_module_name,'P_lookup_code',P_lookup_code);
2435: END IF;
2436:
2437: OPEN get_meaning;
2438: FETCH get_meaning INTO l_meaning;

Line 2442: WSH_DEBUG_SV.log(l_module_name,'l_meaning',l_meaning);

2438: FETCH get_meaning INTO l_meaning;
2439: CLOSE get_meaning;
2440:
2441: IF l_debug_on THEN
2442: WSH_DEBUG_SV.log(l_module_name,'l_meaning',l_meaning);
2443: WSH_DEBUG_SV.pop(l_module_name);
2444: END IF;
2445:
2446: IF (l_meaning IS NULL) THEN

Line 2443: WSH_DEBUG_SV.pop(l_module_name);

2439: CLOSE get_meaning;
2440:
2441: IF l_debug_on THEN
2442: WSH_DEBUG_SV.log(l_module_name,'l_meaning',l_meaning);
2443: WSH_DEBUG_SV.pop(l_module_name);
2444: END IF;
2445:
2446: IF (l_meaning IS NULL) THEN
2447: l_meaning := P_lookup_code;

Line 2457: WSH_DEBUG_SV.pop(l_module_name);

2453:
2454: EXCEPTION
2455: WHEN others THEN
2456: IF l_debug_on THEN
2457: WSH_DEBUG_SV.pop(l_module_name);
2458: END IF;
2459: RETURN P_lookup_code;
2460: END Get_Lookup_Meaning;
2461:

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

2490: IS
2491:
2492: l_api_name CONSTANT VARCHAR2(30) := 'GET_CURRENCY_CODE';
2493: l_api_version CONSTANT NUMBER := 1.0;
2494: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2495: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2496:
2497:
2498: l_return_status VARCHAR2(32767);

Line 2569: WSH_DEBUG_SV.push(l_module_name);

2565: BEGIN
2566:
2567:
2568: IF l_debug_on THEN
2569: WSH_DEBUG_SV.push(l_module_name);
2570: END IF;
2571:
2572: IF FND_API.to_Boolean( p_init_msg_list )
2573: THEN

Line 2586: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,

2582: l_number_of_errors := 0;
2583:
2584: IF l_debug_on
2585: THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2587: WSH_DEBUG_SV.C_PROC_LEVEL);
2588: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2589: WSH_DEBUG_SV.C_PROC_LEVEL);
2590: END IF;

Line 2587: WSH_DEBUG_SV.C_PROC_LEVEL);

2583:
2584: IF l_debug_on
2585: THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2587: WSH_DEBUG_SV.C_PROC_LEVEL);
2588: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2589: WSH_DEBUG_SV.C_PROC_LEVEL);
2590: END IF;
2591:

Line 2588: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,

2584: IF l_debug_on
2585: THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2587: WSH_DEBUG_SV.C_PROC_LEVEL);
2588: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2589: WSH_DEBUG_SV.C_PROC_LEVEL);
2590: END IF;
2591:
2592:

Line 2589: WSH_DEBUG_SV.C_PROC_LEVEL);

2585: THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2587: WSH_DEBUG_SV.C_PROC_LEVEL);
2588: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2589: WSH_DEBUG_SV.C_PROC_LEVEL);
2590: END IF;
2591:
2592:
2593:

Line 2603: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id after calling GET_TRIP_ORGANIZATION_ID ' ||

2599: l_organization_id := GET_TRIP_ORGANIZATION_ID(P_ENTITY_ID);
2600:
2601: IF l_debug_on
2602: THEN
2603: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id after calling GET_TRIP_ORGANIZATION_ID ' ||
2604: l_organization_id,
2605: WSH_DEBUG_SV.C_PROC_LEVEL);
2606: END IF;
2607:

Line 2605: WSH_DEBUG_SV.C_PROC_LEVEL);

2601: IF l_debug_on
2602: THEN
2603: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id after calling GET_TRIP_ORGANIZATION_ID ' ||
2604: l_organization_id,
2605: WSH_DEBUG_SV.C_PROC_LEVEL);
2606: END IF;
2607:
2608:
2609: IF (l_organization_id IS NOT NULL)

Line 2677: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id ' ||

2673:
2674:
2675: IF l_debug_on
2676: THEN
2677: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id ' ||
2678: l_organization_id,
2679: WSH_DEBUG_SV.C_PROC_LEVEL);
2680: END IF;
2681:

Line 2679: WSH_DEBUG_SV.C_PROC_LEVEL);

2675: IF l_debug_on
2676: THEN
2677: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id ' ||
2678: l_organization_id,
2679: WSH_DEBUG_SV.C_PROC_LEVEL);
2680: END IF;
2681:
2682: IF (l_organization_id IS NOT NULL AND
2683: l_carrier_id IS NOT NULL)

Line 2694: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier site not found ',

2690: IF (GET_CARRIER_SITE%NOTFOUND)
2691: THEN
2692: IF l_debug_on
2693: THEN
2694: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier site not found ',
2695: WSH_DEBUG_SV.C_PROC_LEVEL);
2696: END IF;
2697:
2698:

Line 2695: WSH_DEBUG_SV.C_PROC_LEVEL);

2691: THEN
2692: IF l_debug_on
2693: THEN
2694: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier site not found ',
2695: WSH_DEBUG_SV.C_PROC_LEVEL);
2696: END IF;
2697:
2698:
2699: ELSE

Line 2702: WSH_DEBUG_SV.logmsg(l_module_name,' Found carrier site id ' || l_carrier_site_id,

2698:
2699: ELSE
2700: IF l_debug_on
2701: THEN
2702: WSH_DEBUG_SV.logmsg(l_module_name,' Found carrier site id ' || l_carrier_site_id,
2703: WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.logmsg(l_module_name,' Found Supplier site id ' || l_vendor_site_id,
2705: WSH_DEBUG_SV.C_PROC_LEVEL);
2706: END IF;

Line 2703: WSH_DEBUG_SV.C_PROC_LEVEL);

2699: ELSE
2700: IF l_debug_on
2701: THEN
2702: WSH_DEBUG_SV.logmsg(l_module_name,' Found carrier site id ' || l_carrier_site_id,
2703: WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.logmsg(l_module_name,' Found Supplier site id ' || l_vendor_site_id,
2705: WSH_DEBUG_SV.C_PROC_LEVEL);
2706: END IF;
2707: END IF;

Line 2704: WSH_DEBUG_SV.logmsg(l_module_name,' Found Supplier site id ' || l_vendor_site_id,

2700: IF l_debug_on
2701: THEN
2702: WSH_DEBUG_SV.logmsg(l_module_name,' Found carrier site id ' || l_carrier_site_id,
2703: WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.logmsg(l_module_name,' Found Supplier site id ' || l_vendor_site_id,
2705: WSH_DEBUG_SV.C_PROC_LEVEL);
2706: END IF;
2707: END IF;
2708:

Line 2705: WSH_DEBUG_SV.C_PROC_LEVEL);

2701: THEN
2702: WSH_DEBUG_SV.logmsg(l_module_name,' Found carrier site id ' || l_carrier_site_id,
2703: WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.logmsg(l_module_name,' Found Supplier site id ' || l_vendor_site_id,
2705: WSH_DEBUG_SV.C_PROC_LEVEL);
2706: END IF;
2707: END IF;
2708:
2709: IF (l_vendor_site_id IS NULL)

Line 2723: WSH_DEBUG_SV.logmsg(l_module_name,'Using Vendor Site to get currency Vendor Site Id ' ||

2719: THEN
2720:
2721: IF l_debug_on
2722: THEN
2723: WSH_DEBUG_SV.logmsg(l_module_name,'Using Vendor Site to get currency Vendor Site Id ' ||
2724: l_vendor_site_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2725: END IF;
2726:
2727: -- Now get teh currency code

Line 2724: l_vendor_site_id,WSH_DEBUG_SV.C_PROC_LEVEL);

2720:
2721: IF l_debug_on
2722: THEN
2723: WSH_DEBUG_SV.logmsg(l_module_name,'Using Vendor Site to get currency Vendor Site Id ' ||
2724: l_vendor_site_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2725: END IF;
2726:
2727: -- Now get teh currency code
2728:

Line 2737: WSH_DEBUG_SV.logmsg(l_module_name,' Using Vendor Id to get currency Vendor Id ' || l_vendor_id,

2733: ELSIF (l_vendor_id IS NOT NULL)
2734: THEN
2735: IF l_debug_on
2736: THEN
2737: WSH_DEBUG_SV.logmsg(l_module_name,' Using Vendor Id to get currency Vendor Id ' || l_vendor_id,
2738: WSH_DEBUG_SV.C_PROC_LEVEL);
2739: END IF;
2740:
2741: -- Now get teh currency code

Line 2738: WSH_DEBUG_SV.C_PROC_LEVEL);

2734: THEN
2735: IF l_debug_on
2736: THEN
2737: WSH_DEBUG_SV.logmsg(l_module_name,' Using Vendor Id to get currency Vendor Id ' || l_vendor_id,
2738: WSH_DEBUG_SV.C_PROC_LEVEL);
2739: END IF;
2740:
2741: -- Now get teh currency code
2742:

Line 2766: WSH_DEBUG_SV.pop(l_module_name);

2762: --
2763: --
2764:
2765: IF l_debug_on THEN
2766: WSH_DEBUG_SV.pop(l_module_name);
2767: END IF;
2768:
2769: --}
2770: EXCEPTION

Line 2781: WSH_DEBUG_SV.pop(l_module_name);

2777: p_data => x_msg_data,
2778: p_encoded => FND_API.G_FALSE
2779: );
2780: IF l_debug_on THEN
2781: WSH_DEBUG_SV.pop(l_module_name);
2782: END IF;
2783:
2784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2793: WSH_DEBUG_SV.pop(l_module_name);

2789: p_data => x_msg_data,
2790: p_encoded => FND_API.G_FALSE
2791: );
2792: IF l_debug_on THEN
2793: WSH_DEBUG_SV.pop(l_module_name);
2794: END IF;
2795: WHEN OTHERS THEN
2796: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CURRENCY_CODE');
2797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2805: WSH_DEBUG_SV.pop(l_module_name);

2801: p_data => x_msg_data,
2802: p_encoded => FND_API.G_FALSE
2803: );
2804: IF l_debug_on THEN
2805: WSH_DEBUG_SV.pop(l_module_name);
2806: END IF;
2807:
2808: END GET_CURRENCY_CODE;
2809:

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

2825: IS
2826:
2827: l_api_name CONSTANT VARCHAR2(30) := 'GET_SUPPLIER_INFO';
2828: l_api_version CONSTANT NUMBER := 1.0;
2829: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2830: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2831:
2832:
2833: l_return_status VARCHAR2(32767);

Line 2880: WSH_DEBUG_SV.push(l_module_name);

2876:
2877:
2878:
2879: IF l_debug_on THEN
2880: WSH_DEBUG_SV.push(l_module_name);
2881: END IF;
2882:
2883: IF FND_API.to_Boolean( p_init_msg_list )
2884: THEN

Line 2901: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,

2897:
2898:
2899: IF l_debug_on
2900: THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2902: WSH_DEBUG_SV.C_PROC_LEVEL);
2903: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2904: WSH_DEBUG_SV.C_PROC_LEVEL);
2905: END IF;

Line 2902: WSH_DEBUG_SV.C_PROC_LEVEL);

2898:
2899: IF l_debug_on
2900: THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2902: WSH_DEBUG_SV.C_PROC_LEVEL);
2903: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2904: WSH_DEBUG_SV.C_PROC_LEVEL);
2905: END IF;
2906:

Line 2903: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,

2899: IF l_debug_on
2900: THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2902: WSH_DEBUG_SV.C_PROC_LEVEL);
2903: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2904: WSH_DEBUG_SV.C_PROC_LEVEL);
2905: END IF;
2906:
2907:

Line 2904: WSH_DEBUG_SV.C_PROC_LEVEL);

2900: THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY TYPE ' || P_ENTITY_TYPE,
2902: WSH_DEBUG_SV.C_PROC_LEVEL);
2903: WSH_DEBUG_SV.logmsg(l_module_name,' ENTITY ID ' || P_ENTITY_ID,
2904: WSH_DEBUG_SV.C_PROC_LEVEL);
2905: END IF;
2906:
2907:
2908:

Line 2918: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id after calling GET_TRIP_ORGANIZATION_ID ' ||

2914: l_organization_id := GET_TRIP_ORGANIZATION_ID(P_ENTITY_ID);
2915:
2916: IF l_debug_on
2917: THEN
2918: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id after calling GET_TRIP_ORGANIZATION_ID ' ||
2919: l_organization_id,
2920: WSH_DEBUG_SV.C_PROC_LEVEL);
2921: END IF;
2922:

Line 2920: WSH_DEBUG_SV.C_PROC_LEVEL);

2916: IF l_debug_on
2917: THEN
2918: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id after calling GET_TRIP_ORGANIZATION_ID ' ||
2919: l_organization_id,
2920: WSH_DEBUG_SV.C_PROC_LEVEL);
2921: END IF;
2922:
2923:
2924: IF (l_organization_id IS NOT NULL)

Line 2976: WSH_DEBUG_SV.logmsg(l_module_name,' Vendor Site Id ' || l_vendor_site_id,

2972: THEN
2973:
2974: IF l_debug_on
2975: THEN
2976: WSH_DEBUG_SV.logmsg(l_module_name,' Vendor Site Id ' || l_vendor_site_id,
2977: WSH_DEBUG_SV.C_PROC_LEVEL);
2978: END IF;
2979:
2980: -- Now get teh currency code

Line 2977: WSH_DEBUG_SV.C_PROC_LEVEL);

2973:
2974: IF l_debug_on
2975: THEN
2976: WSH_DEBUG_SV.logmsg(l_module_name,' Vendor Site Id ' || l_vendor_site_id,
2977: WSH_DEBUG_SV.C_PROC_LEVEL);
2978: END IF;
2979:
2980: -- Now get teh currency code
2981:

Line 3014: WSH_DEBUG_SV.pop(l_module_name);

3010: --
3011: --
3012:
3013: IF l_debug_on THEN
3014: WSH_DEBUG_SV.pop(l_module_name);
3015: END IF;
3016:
3017: --}
3018: EXCEPTION

Line 3029: WSH_DEBUG_SV.pop(l_module_name);

3025: p_data => x_msg_data,
3026: p_encoded => FND_API.G_FALSE
3027: );
3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.pop(l_module_name);
3030: END IF;
3031:
3032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3041: WSH_DEBUG_SV.pop(l_module_name);

3037: p_data => x_msg_data,
3038: p_encoded => FND_API.G_FALSE
3039: );
3040: IF l_debug_on THEN
3041: WSH_DEBUG_SV.pop(l_module_name);
3042: END IF;
3043: WHEN OTHERS THEN
3044: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_SUPPLIER_INFO');
3045: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3053: WSH_DEBUG_SV.pop(l_module_name);

3049: p_data => x_msg_data,
3050: p_encoded => FND_API.G_FALSE
3051: );
3052: IF l_debug_on THEN
3053: WSH_DEBUG_SV.pop(l_module_name);
3054: END IF;
3055:
3056: END GET_SUPPLIER_INFO;
3057:

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

3078: --{
3079:
3080: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRIP_ORGANIZATION_ID';
3081: l_api_version CONSTANT NUMBER := 1.0;
3082: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3083: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3084:
3085:
3086: l_first_stop_loc_id NUMBER;

Line 3122: WSH_DEBUG_SV.push(l_module_name);

3118:
3119: BEGIN
3120:
3121: IF l_debug_on THEN
3122: WSH_DEBUG_SV.push(l_module_name);
3123: END IF;
3124:
3125: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3126: l_number_of_warnings := 0;

Line 3138: WSH_DEBUG_SV.logmsg(l_module_name,' Getting trip stop information ',

3134: -- location, Org Id and the there by carrier site.
3135:
3136: IF l_debug_on
3137: THEN
3138: WSH_DEBUG_SV.logmsg(l_module_name,' Getting trip stop information ',
3139: WSH_DEBUG_SV.C_PROC_LEVEL);
3140: END IF;
3141:
3142: GET_FIRST_LAST_STOP_INFO(x_return_status => l_return_status,

Line 3139: WSH_DEBUG_SV.C_PROC_LEVEL);

3135:
3136: IF l_debug_on
3137: THEN
3138: WSH_DEBUG_SV.logmsg(l_module_name,' Getting trip stop information ',
3139: WSH_DEBUG_SV.C_PROC_LEVEL);
3140: END IF;
3141:
3142: GET_FIRST_LAST_STOP_INFO(x_return_status => l_return_status,
3143: x_arrival_date => l_arrival_date,

Line 3188: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Loc Id ' || l_sel_stop_loc_id

3184:
3185: IF (GET_ORG_ID_BY_LOCATION%NOTFOUND) THEN
3186: IF l_debug_on
3187: THEN
3188: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Loc Id ' || l_sel_stop_loc_id
3189: || ' has no organization. Checking Delivery ',
3190: WSH_DEBUG_SV.C_PROC_LEVEL);
3191: END IF;
3192: END IF;

Line 3190: WSH_DEBUG_SV.C_PROC_LEVEL);

3186: IF l_debug_on
3187: THEN
3188: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Loc Id ' || l_sel_stop_loc_id
3189: || ' has no organization. Checking Delivery ',
3190: WSH_DEBUG_SV.C_PROC_LEVEL);
3191: END IF;
3192: END IF;
3193: CLOSE GET_ORG_ID_BY_LOCATION;
3194: END IF;

Line 3203: WSH_DEBUG_SV.logmsg(l_module_name,' Before Checking Delivery Org: Organizaton Id ' || l_organization_id ||

3199: -- delivery that is getting picked up at the first stop
3200:
3201: IF l_debug_on
3202: THEN
3203: WSH_DEBUG_SV.logmsg(l_module_name,' Before Checking Delivery Org: Organizaton Id ' || l_organization_id ||
3204: ' First Stop Id '||l_first_stop_id,
3205: WSH_DEBUG_SV.C_PROC_LEVEL);
3206: END IF;
3207:

Line 3205: WSH_DEBUG_SV.C_PROC_LEVEL);

3201: IF l_debug_on
3202: THEN
3203: WSH_DEBUG_SV.logmsg(l_module_name,' Before Checking Delivery Org: Organizaton Id ' || l_organization_id ||
3204: ' First Stop Id '||l_first_stop_id,
3205: WSH_DEBUG_SV.C_PROC_LEVEL);
3206: END IF;
3207:
3208: IF (l_organization_id IS NULL
3209: AND l_first_stop_id IS NOT NULL)

Line 3217: WSH_DEBUG_SV.logmsg(l_module_name,' Delivery has no OrgId!',

3213:
3214: IF (GET_ORG_ID_BY_DELIVERY%NOTFOUND) THEN
3215: IF l_debug_on
3216: THEN
3217: WSH_DEBUG_SV.logmsg(l_module_name,' Delivery has no OrgId!',
3218: WSH_DEBUG_SV.C_PROC_LEVEL);
3219: END IF;
3220: END IF;
3221: CLOSE GET_ORG_ID_BY_DELIVERY;

Line 3218: WSH_DEBUG_SV.C_PROC_LEVEL);

3214: IF (GET_ORG_ID_BY_DELIVERY%NOTFOUND) THEN
3215: IF l_debug_on
3216: THEN
3217: WSH_DEBUG_SV.logmsg(l_module_name,' Delivery has no OrgId!',
3218: WSH_DEBUG_SV.C_PROC_LEVEL);
3219: END IF;
3220: END IF;
3221: CLOSE GET_ORG_ID_BY_DELIVERY;
3222:

Line 3227: WSH_DEBUG_SV.logmsg(l_module_name,' After Checking Delivery Org Organizaton Id ' || l_organization_id ||

3223: END IF;
3224:
3225: IF l_debug_on
3226: THEN
3227: WSH_DEBUG_SV.logmsg(l_module_name,' After Checking Delivery Org Organizaton Id ' || l_organization_id ||
3228: ' First Stop Id '||l_first_stop_id,
3229: WSH_DEBUG_SV.C_PROC_LEVEL);
3230: END IF;
3231:

Line 3229: WSH_DEBUG_SV.C_PROC_LEVEL);

3225: IF l_debug_on
3226: THEN
3227: WSH_DEBUG_SV.logmsg(l_module_name,' After Checking Delivery Org Organizaton Id ' || l_organization_id ||
3228: ' First Stop Id '||l_first_stop_id,
3229: WSH_DEBUG_SV.C_PROC_LEVEL);
3230: END IF;
3231:
3232: IF l_debug_on THEN
3233: WSH_DEBUG_SV.pop(l_module_name);

Line 3233: WSH_DEBUG_SV.pop(l_module_name);

3229: WSH_DEBUG_SV.C_PROC_LEVEL);
3230: END IF;
3231:
3232: IF l_debug_on THEN
3233: WSH_DEBUG_SV.pop(l_module_name);
3234: END IF;
3235:
3236: return l_organization_id;
3237:

Line 3243: WSH_DEBUG_SV.pop(l_module_name);

3239: EXCEPTION
3240: --{
3241: WHEN FND_API.G_EXC_ERROR THEN
3242: IF l_debug_on THEN
3243: WSH_DEBUG_SV.pop(l_module_name);
3244: END IF;
3245: return null;
3246:
3247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3249: WSH_DEBUG_SV.pop(l_module_name);

3245: return null;
3246:
3247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3248: IF l_debug_on THEN
3249: WSH_DEBUG_SV.pop(l_module_name);
3250: END IF;
3251: return null;
3252:
3253: WHEN OTHERS THEN

Line 3255: WSH_DEBUG_SV.pop(l_module_name);

3251: return null;
3252:
3253: WHEN OTHERS THEN
3254: IF l_debug_on THEN
3255: WSH_DEBUG_SV.pop(l_module_name);
3256: END IF;
3257: return null;
3258:
3259: END GET_TRIP_ORGANIZATION_ID;

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

3290: --{
3291:
3292: l_api_name CONSTANT VARCHAR2(30) := 'GET_FIRST_LAST_STOP_INFO';
3293: l_api_version CONSTANT NUMBER := 1.0;
3294: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3295: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3296:
3297: l_stop_loc_id_tbl FTE_ID_TAB_TYPE;
3298: l_stop_id_tbl FTE_ID_TAB_TYPE;

Line 3308: WSH_DEBUG_SV.push(l_module_name);

3304: BEGIN
3305:
3306:
3307: IF l_debug_on THEN
3308: WSH_DEBUG_SV.push(l_module_name);
3309: END IF;
3310:
3311: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3312:

Line 3315: WSH_DEBUG_SV.logmsg(l_module_name,' Getting trip stop information ',

3311: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3312:
3313: IF l_debug_on
3314: THEN
3315: WSH_DEBUG_SV.logmsg(l_module_name,' Getting trip stop information ',
3316: WSH_DEBUG_SV.C_PROC_LEVEL);
3317: END IF;
3318:
3319: l_idx := 0;

Line 3316: WSH_DEBUG_SV.C_PROC_LEVEL);

3312:
3313: IF l_debug_on
3314: THEN
3315: WSH_DEBUG_SV.logmsg(l_module_name,' Getting trip stop information ',
3316: WSH_DEBUG_SV.C_PROC_LEVEL);
3317: END IF;
3318:
3319: l_idx := 0;
3320:

Line 3341: WSH_DEBUG_SV.logmsg(l_module_name,' First stop STOP_ID ' || x_first_stop_id,

3337: END LOOP;
3338:
3339: IF l_debug_on
3340: THEN
3341: WSH_DEBUG_SV.logmsg(l_module_name,' First stop STOP_ID ' || x_first_stop_id,
3342: WSH_DEBUG_SV.C_PROC_LEVEL);
3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,
3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,

Line 3342: WSH_DEBUG_SV.C_PROC_LEVEL);

3338:
3339: IF l_debug_on
3340: THEN
3341: WSH_DEBUG_SV.logmsg(l_module_name,' First stop STOP_ID ' || x_first_stop_id,
3342: WSH_DEBUG_SV.C_PROC_LEVEL);
3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,
3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,

3339: IF l_debug_on
3340: THEN
3341: WSH_DEBUG_SV.logmsg(l_module_name,' First stop STOP_ID ' || x_first_stop_id,
3342: WSH_DEBUG_SV.C_PROC_LEVEL);
3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,
3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,

Line 3344: WSH_DEBUG_SV.C_PROC_LEVEL);

3340: THEN
3341: WSH_DEBUG_SV.logmsg(l_module_name,' First stop STOP_ID ' || x_first_stop_id,
3342: WSH_DEBUG_SV.C_PROC_LEVEL);
3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,
3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,

3341: WSH_DEBUG_SV.logmsg(l_module_name,' First stop STOP_ID ' || x_first_stop_id,
3342: WSH_DEBUG_SV.C_PROC_LEVEL);
3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,
3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,

Line 3346: WSH_DEBUG_SV.C_PROC_LEVEL);

3342: WSH_DEBUG_SV.C_PROC_LEVEL);
3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,
3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,
3350: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,

3343: WSH_DEBUG_SV.logmsg(l_module_name,' First stop Stop Loc Id ' || x_first_stop_loc_id,
3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,
3350: WSH_DEBUG_SV.C_PROC_LEVEL);
3351: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop arrival date ' || x_arrival_date,

Line 3348: WSH_DEBUG_SV.C_PROC_LEVEL);

3344: WSH_DEBUG_SV.C_PROC_LEVEL);
3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,
3350: WSH_DEBUG_SV.C_PROC_LEVEL);
3351: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop arrival date ' || x_arrival_date,
3352: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,

3345: WSH_DEBUG_SV.logmsg(l_module_name,' First stop departure date ' || x_departure_date,
3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,
3350: WSH_DEBUG_SV.C_PROC_LEVEL);
3351: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop arrival date ' || x_arrival_date,
3352: WSH_DEBUG_SV.C_PROC_LEVEL);
3353: END IF;

Line 3350: WSH_DEBUG_SV.C_PROC_LEVEL);

3346: WSH_DEBUG_SV.C_PROC_LEVEL);
3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,
3350: WSH_DEBUG_SV.C_PROC_LEVEL);
3351: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop arrival date ' || x_arrival_date,
3352: WSH_DEBUG_SV.C_PROC_LEVEL);
3353: END IF;
3354:

Line 3351: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop arrival date ' || x_arrival_date,

3347: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop STOP_ID ' || x_last_stop_id,
3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,
3350: WSH_DEBUG_SV.C_PROC_LEVEL);
3351: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop arrival date ' || x_arrival_date,
3352: WSH_DEBUG_SV.C_PROC_LEVEL);
3353: END IF;
3354:
3355:

Line 3352: WSH_DEBUG_SV.C_PROC_LEVEL);

3348: WSH_DEBUG_SV.C_PROC_LEVEL);
3349: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop Stop loc id ' || x_last_stop_loc_id,
3350: WSH_DEBUG_SV.C_PROC_LEVEL);
3351: WSH_DEBUG_SV.logmsg(l_module_name,' Last stop arrival date ' || x_arrival_date,
3352: WSH_DEBUG_SV.C_PROC_LEVEL);
3353: END IF;
3354:
3355:
3356:

Line 3363: WSH_DEBUG_SV.pop(l_module_name);

3359: END IF;
3360:
3361:
3362: IF l_debug_on THEN
3363: WSH_DEBUG_SV.pop(l_module_name);
3364: END IF;
3365:
3366: --}
3367: EXCEPTION

Line 3372: WSH_DEBUG_SV.pop(l_module_name);

3368: --{
3369: WHEN FND_API.G_EXC_ERROR THEN
3370: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3371: IF l_debug_on THEN
3372: WSH_DEBUG_SV.pop(l_module_name);
3373: END IF;
3374:
3375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3378: WSH_DEBUG_SV.pop(l_module_name);

3374:
3375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3377: IF l_debug_on THEN
3378: WSH_DEBUG_SV.pop(l_module_name);
3379: END IF;
3380: WHEN OTHERS THEN
3381: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3382:

Line 3384: WSH_DEBUG_SV.pop(l_module_name);

3380: WHEN OTHERS THEN
3381: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3382:
3383: IF l_debug_on THEN
3384: WSH_DEBUG_SV.pop(l_module_name);
3385: END IF;
3386:
3387:
3388: