DBA Data[Home] [Help]

APPS.FTE_TRACKING_WRAPPER dependencies on WSH_UTIL_CORE

Line 79: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

75: END IF;
76: --
77: --
78: -- Initialize API return status to success
79: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
80: x_msg_count := 0;
81: x_msg_data := '';
82:
83:

Line 1995: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;

1991:
1992: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
1993:
1994: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1995: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
1996:
1997: --For Workflow Impact on ITM
1998: l_parameter_list wf_parameter_list_t;
1999:

Line 2046: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2042: FND_MSG_PUB.initialize;
2043: END IF;
2044:
2045:
2046: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2047: x_msg_count := 0;
2048: x_msg_data := 0;
2049: l_number_of_warnings := 0;
2050: l_number_of_errors := 0;

Line 2120: wsh_util_core.api_post_call(

2116: x_return_status => l_return_status,
2117: x_msg_count => l_msg_count,
2118: x_msg_data => l_msg_data);
2119:
2120: wsh_util_core.api_post_call(
2121: p_return_status =>l_return_status,
2122: x_num_warnings =>l_number_of_warnings,
2123: x_num_errors =>l_number_of_errors,
2124: p_msg_data =>l_msg_data);

Line 2130: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2126:
2127:
2128: IF l_number_of_errors > 0
2129: THEN
2130: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2131: ELSIF l_number_of_warnings > 0
2132: THEN
2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2134: ELSE

Line 2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2129: THEN
2130: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2131: ELSIF l_number_of_warnings > 0
2132: THEN
2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2134: ELSE
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2136: END IF;
2137:

Line 2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2131: ELSIF l_number_of_warnings > 0
2132: THEN
2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2134: ELSE
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2136: END IF;
2137:
2138: --Release 12 WF Impact on POD
2139: --Raise POD received event for Tracking workflow

Line 2219: wsh_util_core.api_post_call(

2215:
2216: END IF;
2217:
2218:
2219: wsh_util_core.api_post_call(
2220: p_return_status =>l_return_status,
2221: x_num_warnings =>l_number_of_warnings,
2222: x_num_errors =>l_number_of_errors,
2223: p_msg_data =>l_msg_data);

Line 2229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2225:
2226:
2227: IF l_number_of_errors > 0
2228: THEN
2229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2230: ELSIF l_number_of_warnings > 0
2231: THEN
2232: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2233: ELSE

Line 2232: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2228: THEN
2229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2230: ELSIF l_number_of_warnings > 0
2231: THEN
2232: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2233: ELSE
2234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2235: END IF;
2236:

Line 2234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2230: ELSIF l_number_of_warnings > 0
2231: THEN
2232: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2233: ELSE
2234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2235: END IF;
2236:
2237:
2238: END IF;

Line 2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2269: END IF;
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;
2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2274: FND_MSG_PUB.Count_And_Get
2275: (
2276: p_count => x_msg_count,
2277: p_data => x_msg_data,

Line 2287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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