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_WSH_INTERFACE_PKG dependencies on FND_API

Line 118: l_current_stop_id := NVL(p_current_stop_rec.STOP_ID,FND_API.G_MISS_NUM);

114: order by 3;
115: --}
116: BEGIN
117: --{
118: l_current_stop_id := NVL(p_current_stop_rec.STOP_ID,FND_API.G_MISS_NUM);
119: l_curr_stop_old_position := G_NONE;
120: l_trip_stop_tab_count := 0;
121: l_old_first_stop_id := NULL;
122: l_old_last_stop_id := NULL;

Line 1846: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1842:
1843: PROCEDURE segment_stop_change
1844: (
1845: P_api_version IN NUMBER,
1846: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1847: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1848: X_return_status OUT NOCOPY VARCHAR2,
1849: X_msg_count OUT NOCOPY NUMBER,
1850: X_msg_data OUT NOCOPY VARCHAR2,

Line 1847: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1843: PROCEDURE segment_stop_change
1844: (
1845: P_api_version IN NUMBER,
1846: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1847: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1848: X_return_status OUT NOCOPY VARCHAR2,
1849: X_msg_count OUT NOCOPY NUMBER,
1850: X_msg_data OUT NOCOPY VARCHAR2,
1851: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

Line 1899: IF NOT FND_API.Compatible_API_Call

1895: -- Standard Start of API savepoint
1896: SAVEPOINT SEGMENT_STOP_CHANGE_PUB;
1897: --
1898: -- Standard call to check for call compatibility.
1899: IF NOT FND_API.Compatible_API_Call
1900: (
1901: l_api_version,
1902: p_api_version,
1903: l_api_name,

Line 1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1903: l_api_name,
1904: G_PKG_NAME
1905: )
1906: THEN
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END IF;
1909: --
1910: --
1911: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1919: IF FND_API.to_Boolean( p_init_msg_list )

1915: wsh_debug_sv.push(l_module_name);
1916: END IF;
1917:
1918:
1919: IF FND_API.to_Boolean( p_init_msg_list )
1920: THEN
1921: FND_MSG_PUB.initialize;
1922: END IF;
1923: --

Line 1950: RAISE FND_API.G_EXC_ERROR;

1946: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');
1947: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);
1948: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1949: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1950: RAISE FND_API.G_EXC_ERROR;
1951: --RETURN;
1952: --}
1953: END IF;
1954: --

Line 1988: RAISE FND_API.G_EXC_ERROR;

1984: --
1985: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1986: THEN
1987: --{
1988: RAISE FND_API.G_EXC_ERROR;
1989: --RETURN;
1990: --}
1991: END IF;
1992: --

Line 2052: P_init_msg_list => FND_API.G_FALSE,

2048: END IF;
2049:
2050: FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP(
2051: P_api_version => 1.0,
2052: P_init_msg_list => FND_API.G_FALSE,
2053: X_return_status => l_return_status,
2054: X_msg_count => l_msg_count,
2055: X_msg_data => l_msg_data,
2056: P_trip_segment_rec => p_trip_segment_rec,

Line 2115: P_init_msg_list => FND_API.G_FALSE,

2111:
2112:
2113: FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP(
2114: P_api_version => 1.0,
2115: P_init_msg_list => FND_API.G_FALSE,
2116: X_return_status => l_return_status,
2117: X_msg_count => l_msg_count,
2118: X_msg_data => l_msg_data,
2119: P_trip_segment_rec => p_trip_segment_rec,

Line 2178: RAISE FND_API.G_EXC_ERROR;

2174: --
2175: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2176: THEN
2177: --{
2178: RAISE FND_API.G_EXC_ERROR;
2179: --RETURN;
2180: --}
2181: END IF;
2182: --

Line 2206: IF FND_API.To_Boolean( p_commit )

2202: --
2203: --
2204: -- Standard check of p_commit.
2205: --
2206: IF FND_API.To_Boolean( p_commit )
2207: THEN
2208: COMMIT WORK;
2209: END IF;
2210: --

Line 2219: p_encoded => FND_API.G_FALSE

2215: FND_MSG_PUB.Count_And_Get
2216: (
2217: p_count => x_msg_count,
2218: p_data => x_msg_data,
2219: p_encoded => FND_API.G_FALSE
2220: );
2221: --fnd_message.set_name('WSH','END');
2222: --
2223:

Line 2232: WHEN FND_API.G_EXC_ERROR THEN

2228: --
2229: --}
2230: EXCEPTION
2231: --{
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: ROLLBACK TO SEGMENT_STOP_CHANGE_PUB;
2234: x_return_status := FND_API.G_RET_STS_ERROR ;
2235: FND_MSG_PUB.Count_And_Get
2236: (

Line 2234: x_return_status := FND_API.G_RET_STS_ERROR ;

2230: EXCEPTION
2231: --{
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: ROLLBACK TO SEGMENT_STOP_CHANGE_PUB;
2234: x_return_status := FND_API.G_RET_STS_ERROR ;
2235: FND_MSG_PUB.Count_And_Get
2236: (
2237: p_count => x_msg_count,
2238: p_data => x_msg_data,

Line 2239: p_encoded => FND_API.G_FALSE

2235: FND_MSG_PUB.Count_And_Get
2236: (
2237: p_count => x_msg_count,
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);

Line 2245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;
2248: FND_MSG_PUB.Count_And_Get
2249: (

Line 2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
2248: FND_MSG_PUB.Count_And_Get
2249: (
2250: p_count => x_msg_count,
2251: p_data => x_msg_data,

Line 2252: p_encoded => FND_API.G_FALSE

2248: FND_MSG_PUB.Count_And_Get
2249: (
2250: p_count => x_msg_count,
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;

Line 2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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);

Line 2273: p_encoded => FND_API.G_FALSE

2269: FND_MSG_PUB.Count_And_Get
2270: (
2271: p_count => x_msg_count,
2272: p_data => x_msg_data,
2273: p_encoded => FND_API.G_FALSE
2274: );
2275: --}
2276: END segment_stop_change;
2277: --

Line 2654: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2650: --
2651: PROCEDURE trip_segment_change
2652: (
2653: P_api_version IN NUMBER,
2654: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2655: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2656: X_return_status OUT NOCOPY VARCHAR2,
2657: X_msg_count OUT NOCOPY NUMBER,
2658: X_msg_data OUT NOCOPY VARCHAR2,

Line 2655: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2651: PROCEDURE trip_segment_change
2652: (
2653: P_api_version IN NUMBER,
2654: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2655: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2656: X_return_status OUT NOCOPY VARCHAR2,
2657: X_msg_count OUT NOCOPY NUMBER,
2658: X_msg_data OUT NOCOPY VARCHAR2,
2659: P_old_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

Line 2691: IF NOT FND_API.Compatible_API_Call

2687: -- Standard Start of API savepoint
2688: SAVEPOINT TRIP_SEGMENT_CHANGE_PUB;
2689: --
2690: -- Standard call to check for call compatibility.
2691: IF NOT FND_API.Compatible_API_Call
2692: (
2693: l_api_version,
2694: p_api_version,
2695: l_api_name,

Line 2699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2695: l_api_name,
2696: G_PKG_NAME
2697: )
2698: THEN
2699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2700: END IF;
2701: --
2702: --
2703: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2706: IF FND_API.to_Boolean( p_init_msg_list )

2702: --
2703: -- Initialize message list if p_init_msg_list is set to TRUE.
2704: --
2705: --
2706: IF FND_API.to_Boolean( p_init_msg_list )
2707: THEN
2708: FND_MSG_PUB.initialize;
2709: END IF;
2710: --

Line 2759: RAISE FND_API.G_EXC_ERROR;

2755: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');
2756: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);
2757: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2758: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2759: RAISE FND_API.G_EXC_ERROR;
2760: --RETURN;
2761: --}
2762: END IF;
2763: --

Line 2781: RAISE FND_API.G_EXC_ERROR;

2777: --
2778: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2779: THEN
2780: --{
2781: RAISE FND_API.G_EXC_ERROR;
2782: --RETURN;
2783: --}
2784: END IF;
2785: --

Line 2809: IF FND_API.To_Boolean( p_commit )

2805: --
2806: --
2807: -- Standard check of p_commit.
2808: --
2809: IF FND_API.To_Boolean( p_commit )
2810: THEN
2811: COMMIT WORK;
2812: END IF;
2813: --

Line 2821: p_encoded => FND_API.G_FALSE

2817: FND_MSG_PUB.Count_And_Get
2818: (
2819: p_count => x_msg_count,
2820: p_data => x_msg_data,
2821: p_encoded => FND_API.G_FALSE
2822: );
2823: --
2824: --
2825: --}

Line 2828: WHEN FND_API.G_EXC_ERROR THEN

2824: --
2825: --}
2826: EXCEPTION
2827: --{
2828: WHEN FND_API.G_EXC_ERROR THEN
2829: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2830: x_return_status := FND_API.G_RET_STS_ERROR ;
2831: FND_MSG_PUB.Count_And_Get
2832: (

Line 2830: x_return_status := FND_API.G_RET_STS_ERROR ;

2826: EXCEPTION
2827: --{
2828: WHEN FND_API.G_EXC_ERROR THEN
2829: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2830: x_return_status := FND_API.G_RET_STS_ERROR ;
2831: FND_MSG_PUB.Count_And_Get
2832: (
2833: p_count => x_msg_count,
2834: p_data => x_msg_data,

Line 2835: p_encoded => FND_API.G_FALSE

2831: FND_MSG_PUB.Count_And_Get
2832: (
2833: p_count => x_msg_count,
2834: p_data => x_msg_data,
2835: p_encoded => FND_API.G_FALSE
2836: );
2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2838: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2833: p_count => x_msg_count,
2834: p_data => x_msg_data,
2835: p_encoded => FND_API.G_FALSE
2836: );
2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2838: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2840: FND_MSG_PUB.Count_And_Get
2841: (

Line 2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2835: p_encoded => FND_API.G_FALSE
2836: );
2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2838: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2840: FND_MSG_PUB.Count_And_Get
2841: (
2842: p_count => x_msg_count,
2843: p_data => x_msg_data,

Line 2844: p_encoded => FND_API.G_FALSE

2840: FND_MSG_PUB.Count_And_Get
2841: (
2842: p_count => x_msg_count,
2843: p_data => x_msg_data,
2844: p_encoded => FND_API.G_FALSE
2845: );
2846: WHEN OTHERS THEN
2847: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2844: p_encoded => FND_API.G_FALSE
2845: );
2846: WHEN OTHERS THEN
2847: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2849: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE');
2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2851: --
2852: --

Line 2857: p_encoded => FND_API.G_FALSE

2853: FND_MSG_PUB.Count_And_Get
2854: (
2855: p_count => x_msg_count,
2856: p_data => x_msg_data,
2857: p_encoded => FND_API.G_FALSE
2858: );
2859: --}
2860: END trip_segment_change;
2861: --

Line 2878: -- to FND_API.G_TRUE

2874: -- MODIFIED :
2875: -- DESC: This procedure returns back org and organization id for the
2876: -- entity.
2877: -- To get org id, calling API has to set P_ORG_ID_FLAG
2878: -- to FND_API.G_TRUE
2879: --========================================================================
2880:
2881:
2882: PROCEDURE GET_ORG_ORGANIZATION_INFO(

Line 2891: p_org_id_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE)

2887: x_organization_id OUT NOCOPY NUMBER,
2888: x_org_id OUT NOCOPY NUMBER,
2889: p_entity_id IN NUMBER,
2890: p_entity_type IN VARCHAR2,
2891: p_org_id_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE)
2892: IS
2893:
2894: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRIP_ORG_ORGANIZATION';
2895: l_api_version CONSTANT NUMBER := 1.0;

Line 2930: IF FND_API.to_Boolean( p_init_msg_list )

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
2932: FND_MSG_PUB.initialize;
2933: END IF;
2934:

Line 2971: RAISE FND_API.G_EXC_ERROR;

2967: WHEN NO_DATA_FOUND THEN
2968: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_STOP');
2969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2970: wsh_util_core.add_message(x_return_status);
2971: RAISE FND_API.G_EXC_ERROR;
2972: END;
2973: END IF;
2974:
2975: x_organization_id := FTE_MLS_UTIL.GET_TRIP_ORGANIZATION_ID(l_trip_id);

Line 2994: RAISE FND_API.G_EXC_ERROR;

2990: WHEN NO_DATA_FOUND THEN
2991: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DLVY');
2992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2993: wsh_util_core.add_message(x_return_status);
2994: RAISE FND_API.G_EXC_ERROR;
2995: END;
2996: ELSIF (p_entity_type = 'DETAIL')
2997: THEN
2998: BEGIN

Line 3013: RAISE FND_API.G_EXC_ERROR;

3009: WHEN NO_DATA_FOUND THEN
3010: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DETAIL');
3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3012: wsh_util_core.add_message(x_return_status);
3013: RAISE FND_API.G_EXC_ERROR;
3014: END;
3015: END IF;
3016:
3017:

Line 3019: AND (p_org_id_flag = FND_API.G_TRUE))

3015: END IF;
3016:
3017:
3018: IF ( (X_ORGANIZATION_ID IS NOT NULL)
3019: AND (p_org_id_flag = FND_API.G_TRUE))
3020: THEN
3021: IF (l_org_id IS NOT NULL) THEN
3022: x_org_id := l_org_id;
3023: ELSE

Line 3044: p_encoded => FND_API.G_FALSE

3040: FND_MSG_PUB.Count_And_Get
3041: (
3042: p_count => x_msg_count,
3043: p_data => x_msg_data,
3044: p_encoded => FND_API.G_FALSE
3045: );
3046:
3047:
3048: --

Line 3058: WHEN FND_API.G_EXC_ERROR THEN

3054:
3055: --}
3056: EXCEPTION
3057: --{
3058: WHEN FND_API.G_EXC_ERROR THEN
3059: x_return_status := FND_API.G_RET_STS_ERROR;
3060: FND_MSG_PUB.Count_And_Get
3061: (
3062: p_count => x_msg_count,

Line 3059: x_return_status := FND_API.G_RET_STS_ERROR;

3055: --}
3056: EXCEPTION
3057: --{
3058: WHEN FND_API.G_EXC_ERROR THEN
3059: x_return_status := FND_API.G_RET_STS_ERROR;
3060: FND_MSG_PUB.Count_And_Get
3061: (
3062: p_count => x_msg_count,
3063: p_data => x_msg_data,

Line 3064: p_encoded => FND_API.G_FALSE

3060: FND_MSG_PUB.Count_And_Get
3061: (
3062: p_count => x_msg_count,
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;

Line 3070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;
3072: FND_MSG_PUB.Count_And_Get
3073: (
3074: p_count => x_msg_count,

Line 3071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
3072: FND_MSG_PUB.Count_And_Get
3073: (
3074: p_count => x_msg_count,
3075: p_data => x_msg_data,

Line 3076: p_encoded => FND_API.G_FALSE

3072: FND_MSG_PUB.Count_And_Get
3073: (
3074: p_count => x_msg_count,
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;

Line 3083: x_return_status := FND_API.G_RET_STS_ERROR;

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;
3084: FND_MSG_PUB.Count_And_Get
3085: (
3086: p_count => x_msg_count,
3087: p_data => x_msg_data,

Line 3088: p_encoded => FND_API.G_FALSE

3084: FND_MSG_PUB.Count_And_Get
3085: (
3086: p_count => x_msg_count,
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;