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_SS_INTERFACE dependencies on WSH_UTIL_CORE

Line 27: wsh_util_core.default_handler('FTE_SS_INTERFACE.RATE_SORT_WRAPPER');

23:
24: EXCEPTION
25:
26: WHEN OTHERS THEN
27: wsh_util_core.default_handler('FTE_SS_INTERFACE.RATE_SORT_WRAPPER');
28:
29: END RATE_SORT_WRAPPER;
30: --}
31:

Line 307: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

303: THEN
304: FND_MSG_PUB.initialize;
305: END IF;
306:
307: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
308: x_msg_count := 0;
309: x_msg_data := 0;
310: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
311: l_number_of_warnings := 0;

Line 310: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

306:
307: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
308: x_msg_count := 0;
309: x_msg_data := 0;
310: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
311: l_number_of_warnings := 0;
312: l_number_of_errors := 0;
313:
314:

Line 618: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_WF');

614: WSH_DEBUG_SV.pop(l_module_name);
615: END IF;
616: WHEN OTHERS THEN
617: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;
618: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_WF');
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MSG_PUB.Count_And_Get
621: (
622: p_count => x_msg_count,

Line 714: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

710: THEN
711: FND_MSG_PUB.initialize;
712: END IF;
713:
714: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
715: x_msg_count := 0;
716: x_msg_data := 0;
717: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
718: l_number_of_warnings := 0;

Line 717: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

713:
714: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
715: x_msg_count := 0;
716: x_msg_data := 0;
717: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
718: l_number_of_warnings := 0;
719: l_number_of_errors := 0;
720:
721:

Line 945: wsh_util_core.api_post_call(

941: p_ranklist => l_temp_rank_tbl,
942: p_trip_id => P_FTE_SS_ATTR_REC.trip_id,
943: p_rank_id => null);
944:
945: wsh_util_core.api_post_call(
946: p_return_status =>l_return_status,
947: x_num_warnings =>l_number_of_warnings,
948: x_num_errors =>l_number_of_errors,
949: p_msg_data =>l_msg_data);

Line 994: wsh_util_core.api_post_call(

990: l_return_status,
991: WSH_DEBUG_SV.C_PROC_LEVEL);
992: END IF;
993:
994: wsh_util_core.api_post_call(
995: p_return_status =>l_return_status,
996: x_num_warnings =>l_number_of_warnings,
997: x_num_errors =>l_number_of_errors,
998: p_msg_data =>l_msg_data);

Line 1003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

999:
1000:
1001: IF l_number_of_errors > 0
1002: THEN
1003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1004: RAISE FND_API.G_EXC_ERROR;
1005: ELSIF l_number_of_warnings > 0
1006: THEN
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1004: RAISE FND_API.G_EXC_ERROR;
1005: ELSIF l_number_of_warnings > 0
1006: THEN
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1008: ELSE
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1010: END IF;
1011:

Line 1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1005: ELSIF l_number_of_warnings > 0
1006: THEN
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1008: ELSE
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1010: END IF;
1011:
1012:
1013:

Line 1292: wsh_util_core.api_post_call(

1288: l_return_status,
1289: WSH_DEBUG_SV.C_PROC_LEVEL);
1290: END IF;
1291:
1292: wsh_util_core.api_post_call(
1293: p_return_status =>l_return_status,
1294: x_num_warnings =>l_number_of_warnings,
1295: x_num_errors =>l_number_of_errors,
1296: p_msg_data =>l_msg_data);

Line 1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1296: p_msg_data =>l_msg_data);
1297:
1298: IF l_number_of_errors > 0
1299: THEN
1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_number_of_warnings > 0
1303: THEN
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_number_of_warnings > 0
1303: THEN
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1305: ELSE
1306: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1307: END IF;
1308:

Line 1306: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1302: ELSIF l_number_of_warnings > 0
1303: THEN
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1305: ELSE
1306: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1307: END IF;
1308:
1309:
1310: END IF;

Line 1425: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_UI');

1421: WSH_DEBUG_SV.pop(l_module_name);
1422: END IF;
1423: WHEN OTHERS THEN
1424: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;
1425: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_UI');
1426: x_return_status := FND_API.G_RET_STS_ERROR;
1427: FND_MSG_PUB.Count_And_Get
1428: (
1429: p_count => x_msg_count,

Line 1516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1512: THEN
1513: FND_MSG_PUB.initialize;
1514: END IF;
1515:
1516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1517: x_msg_count := 0;
1518: x_msg_data := 0;
1519: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1520: l_number_of_warnings := 0;

Line 1519: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1515:
1516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1517: x_msg_count := 0;
1518: x_msg_data := 0;
1519: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1520: l_number_of_warnings := 0;
1521: l_number_of_errors := 0;
1522:
1523:

Line 1578: wsh_util_core.api_post_call(

1574: l_return_status,
1575: WSH_DEBUG_SV.C_PROC_LEVEL);
1576: END IF;
1577:
1578: wsh_util_core.api_post_call(
1579: p_return_status =>l_return_status,
1580: x_num_warnings =>l_number_of_warnings,
1581: x_num_errors =>l_number_of_errors,
1582: p_msg_data =>l_msg_data);

Line 1623: wsh_util_core.api_post_call(

1619: WSH_DEBUG_SV.C_PROC_LEVEL);
1620:
1621: END IF;
1622:
1623: wsh_util_core.api_post_call(
1624: p_return_status =>l_return_status,
1625: x_num_warnings =>l_number_of_warnings,
1626: x_num_errors =>l_number_of_errors,
1627: p_msg_data =>l_msg_data);

Line 1719: wsh_util_core.api_post_call(

1715: WSH_DEBUG_SV.C_PROC_LEVEL);
1716: END IF;
1717:
1718:
1719: wsh_util_core.api_post_call(
1720: p_return_status =>l_return_status,
1721: x_num_warnings =>l_number_of_warnings,
1722: x_num_errors =>l_number_of_errors,
1723: p_msg_data =>l_msg_data);

Line 1966: wsh_util_core.api_post_call(

1962: p_ranklist => l_rank_list_in_param_tbl,
1963: p_trip_id => P_FTE_SS_ATTR_REC.trip_id,
1964: p_rank_id => null);
1965:
1966: wsh_util_core.api_post_call(
1967: p_return_status =>l_return_status,
1968: x_num_warnings =>l_number_of_warnings,
1969: x_num_errors =>l_number_of_errors,
1970: p_msg_data =>l_msg_data);

Line 1975: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1971:
1972:
1973: IF l_number_of_errors > 0
1974: THEN
1975: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1976: RAISE FND_API.G_EXC_ERROR;
1977: ELSIF l_number_of_warnings > 0
1978: THEN
1979: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1979: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1975: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1976: RAISE FND_API.G_EXC_ERROR;
1977: ELSIF l_number_of_warnings > 0
1978: THEN
1979: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1980: ELSE
1981: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1982: END IF;
1983: --}

Line 1981: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1977: ELSIF l_number_of_warnings > 0
1978: THEN
1979: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1980: ELSE
1981: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1982: END IF;
1983: --}
1984: END IF;
1985:

Line 2074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2070: END IF;
2071:
2072: IF l_number_of_errors > 0
2073: THEN
2074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2075: RAISE FND_API.G_EXC_ERROR;
2076: ELSIF l_number_of_warnings > 0
2077: THEN
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2075: RAISE FND_API.G_EXC_ERROR;
2076: ELSIF l_number_of_warnings > 0
2077: THEN
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2079: ELSE
2080: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2081: END IF;
2082:

Line 2080: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2076: ELSIF l_number_of_warnings > 0
2077: THEN
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2079: ELSE
2080: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2081: END IF;
2082:
2083:
2084:

Line 2133: wsh_util_core.api_post_call(

2129: l_return_status,
2130: WSH_DEBUG_SV.C_PROC_LEVEL);
2131: END IF;
2132:
2133: wsh_util_core.api_post_call(
2134: p_return_status =>l_return_status,
2135: x_num_warnings =>l_number_of_warnings,
2136: x_num_errors =>l_number_of_errors,
2137: p_msg_data =>l_msg_data);

Line 2142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2138:
2139:
2140: IF l_number_of_errors > 0
2141: THEN
2142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2143: RAISE FND_API.G_EXC_ERROR;
2144: ELSIF l_number_of_warnings > 0
2145: THEN
2146: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2146: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2143: RAISE FND_API.G_EXC_ERROR;
2144: ELSIF l_number_of_warnings > 0
2145: THEN
2146: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2147: ELSE
2148: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2149: END IF;
2150: END IF;

Line 2148: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2144: ELSIF l_number_of_warnings > 0
2145: THEN
2146: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2147: ELSE
2148: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2149: END IF;
2150: END IF;
2151:
2152: IF l_debug_on

Line 2244: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES');

2240: WSH_DEBUG_SV.pop(l_module_name);
2241: END IF;
2242: WHEN OTHERS THEN
2243: ROLLBACK TO SEARCH_SERVICES_PUB;
2244: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES');
2245: x_return_status := FND_API.G_RET_STS_ERROR;
2246: FND_MSG_PUB.Count_And_Get
2247: (
2248: p_count => x_msg_count,

Line 2313: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2309: THEN
2310: FND_MSG_PUB.initialize;
2311: END IF;
2312:
2313: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2314: x_msg_count := 0;
2315: x_msg_data := 0;
2316: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2317: l_number_of_warnings := 0;

Line 2316: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2312:
2313: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2314: x_msg_count := 0;
2315: x_msg_data := 0;
2316: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2317: l_number_of_warnings := 0;
2318: l_number_of_errors := 0;
2319:
2320:

Line 2346: wsh_util_core.api_post_call(

2342: x_return_status => l_return_status,
2343: x_msg_count => l_msg_count,
2344: x_msg_data => l_msg_data);
2345:
2346: wsh_util_core.api_post_call(
2347: p_return_status =>l_return_status,
2348: x_num_warnings =>l_number_of_warnings,
2349: x_num_errors =>l_number_of_errors,
2350: p_msg_data =>l_msg_data);

Line 2355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2351:
2352:
2353: IF l_number_of_errors > 0
2354: THEN
2355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2356: RAISE FND_API.G_EXC_ERROR;
2357: ELSIF l_number_of_warnings > 0
2358: THEN
2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2356: RAISE FND_API.G_EXC_ERROR;
2357: ELSIF l_number_of_warnings > 0
2358: THEN
2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2360: ELSE
2361: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2362: END IF;
2363:

Line 2361: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2357: ELSIF l_number_of_warnings > 0
2358: THEN
2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2360: ELSE
2361: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2362: END IF;
2363:
2364: -- Update trip append flag to N
2365:

Line 2471: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES_UIWRAPPER');

2467: WSH_DEBUG_SV.pop(l_module_name);
2468: END IF;
2469: WHEN OTHERS THEN
2470: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;
2471: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES_UIWRAPPER');
2472: x_return_status := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get
2474: (
2475: p_count => x_msg_count,

Line 2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2539: THEN
2540: FND_MSG_PUB.initialize;
2541: END IF;
2542:
2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2544: x_msg_count := 0;
2545: x_msg_data := 0;
2546: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2547: l_number_of_warnings := 0;

Line 2546: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2542:
2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2544: x_msg_count := 0;
2545: x_msg_data := 0;
2546: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2547: l_number_of_warnings := 0;
2548: l_number_of_errors := 0;
2549:
2550:

Line 2569: wsh_util_core.api_post_call(

2565: LOG(l_module_name,' return status from GET_RANKED_RESULTS ' || l_return_status,
2566: WSH_DEBUG_SV.C_PROC_LEVEL);
2567: END IF;
2568:
2569: wsh_util_core.api_post_call(
2570: p_return_status =>l_return_status,
2571: x_num_warnings =>l_number_of_warnings,
2572: x_num_errors =>l_number_of_errors,
2573: p_msg_data =>'');

Line 2588: l_service := WSH_UTIL_CORE.GET_LOOKUP_MEANING('WSH_SERVICE_LEVELS',

2584: l_service := null;
2585:
2586: IF (l_routing_results(i).SERVICE_LEVEL IS NOT NULL)
2587: THEN
2588: l_service := WSH_UTIL_CORE.GET_LOOKUP_MEANING('WSH_SERVICE_LEVELS',
2589: l_routing_results(i).SERVICE_LEVEL);
2590: END IF;
2591:
2592: l_mode := null;

Line 2595: l_mode := WSH_UTIL_CORE.GET_LOOKUP_MEANING('WSH_MODE_OF_TRANSPORT',

2591:
2592: l_mode := null;
2593: IF (l_routing_results(i).MODE_OF_TRANSPORT IS NOT NULL)
2594: THEN
2595: l_mode := WSH_UTIL_CORE.GET_LOOKUP_MEANING('WSH_MODE_OF_TRANSPORT',
2596: l_routing_results(i).MODE_OF_TRANSPORT);
2597: END IF;
2598:
2599: l_carrierName := null;

Line 2636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2632: END LOOP;
2633:
2634: IF l_number_of_errors > 0
2635: THEN
2636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2637: RAISE FND_API.G_EXC_ERROR;
2638: ELSIF l_number_of_warnings > 0
2639: THEN
2640: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2640: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2636: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2637: RAISE FND_API.G_EXC_ERROR;
2638: ELSIF l_number_of_warnings > 0
2639: THEN
2640: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2641: ELSE
2642: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2643: END IF;
2644:

Line 2642: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2638: ELSIF l_number_of_warnings > 0
2639: THEN
2640: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2641: ELSE
2642: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2643: END IF;
2644:
2645: -- Update trip append flag to N
2646:

Line 2693: wsh_util_core.default_handler('FTE_SS_INTERFACE.GET_RANKED_RESULTS_WRAPPER');

2689: WSH_DEBUG_SV.pop(l_module_name);
2690: END IF;
2691: WHEN OTHERS THEN
2692: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;
2693: wsh_util_core.default_handler('FTE_SS_INTERFACE.GET_RANKED_RESULTS_WRAPPER');
2694: x_return_status := FND_API.G_RET_STS_ERROR;
2695: FND_MSG_PUB.Count_And_Get
2696: (
2697: p_count => x_msg_count,

Line 2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2777: wsh_debug_sv.push(l_module_name);
2778: END IF;
2779: --
2780: --
2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2782: x_msg_count := 0;
2783:
2784: -- local variables used to check API return values
2785: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2785: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2782: x_msg_count := 0;
2783:
2784: -- local variables used to check API return values
2785: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2786: l_number_of_warnings := 0;
2787: l_number_of_errors := 0;
2788:
2789: l_trip_id := p_ss_attr_rec.trip_id;

Line 2816: WSH_UTIL_CORE.API_POST_CALL(

2812: p_trip_id => l_trip_id,
2813: x_return_status => l_return_status);
2814:
2815:
2816: WSH_UTIL_CORE.API_POST_CALL(
2817: p_return_status =>l_return_status,
2818: x_num_warnings =>l_number_of_warnings,
2819: x_num_errors =>l_number_of_errors,
2820: p_msg_data =>l_msg_data);

Line 2890: WSH_UTIL_CORE.API_POST_CALL(

2886: x_MSG_COUNT => l_msg_count,
2887: x_MSG_DATA => l_msg_data);
2888: END IF;
2889:
2890: WSH_UTIL_CORE.API_POST_CALL(
2891: p_return_status => l_return_status,
2892: x_num_warnings => l_number_of_warnings,
2893: x_num_errors => l_number_of_errors,
2894: p_msg_data => l_msg_data);

Line 2952: WSH_UTIL_CORE.API_POST_CALL(

2948: x_RETURN_STATUS => l_return_status,
2949: x_MSG_COUNT => l_msg_count,
2950: x_MSG_DATA => l_msg_data);
2951:
2952: WSH_UTIL_CORE.API_POST_CALL(
2953: p_return_status =>l_return_status,
2954: x_num_warnings =>l_number_of_warnings,
2955: x_num_errors =>l_number_of_errors,
2956: p_msg_data =>l_msg_data);

Line 2982: WSH_UTIL_CORE.API_POST_CALL(

2978: x_RETURN_STATUS => l_return_status,
2979: x_MSG_COUNT => l_msg_count,
2980: x_MSG_DATA => l_msg_data);
2981:
2982: WSH_UTIL_CORE.API_POST_CALL(
2983: p_return_status =>l_return_status,
2984: x_num_warnings =>l_number_of_warnings,
2985: x_num_errors =>l_number_of_errors,
2986: p_msg_data =>l_msg_data);

Line 3033: WSH_UTIL_CORE.API_POST_CALL(

3029: */
3030:
3031: END IF;
3032:
3033: WSH_UTIL_CORE.API_POST_CALL(
3034: p_return_status =>l_return_status,
3035: x_num_warnings =>l_number_of_warnings,
3036: x_num_errors =>l_number_of_errors,
3037: p_msg_data =>l_msg_data);

Line 3071: WSH_UTIL_CORE.API_POST_CALL(

3067: x_return_status => l_return_status,
3068: x_msg_count => l_msg_count,
3069: x_msg_data => l_msg_data);
3070:
3071: WSH_UTIL_CORE.API_POST_CALL(
3072: p_return_status =>l_return_status,
3073: x_num_warnings =>l_number_of_warnings,
3074: x_num_errors =>l_number_of_errors,
3075: p_msg_data =>l_msg_data);

Line 3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3076: END IF;
3077:
3078: IF l_number_of_errors > 0
3079: THEN
3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3081: RAISE FND_API.G_EXC_ERROR;
3082: ELSIF l_number_of_warnings > 0 THEN
3083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3084: ELSE

Line 3083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3079: THEN
3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3081: RAISE FND_API.G_EXC_ERROR;
3082: ELSIF l_number_of_warnings > 0 THEN
3083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3084: ELSE
3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3086: END IF;
3087:

Line 3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3081: RAISE FND_API.G_EXC_ERROR;
3082: ELSIF l_number_of_warnings > 0 THEN
3083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3084: ELSE
3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3086: END IF;
3087:
3088:
3089: FND_MSG_PUB.Count_And_Get

Line 3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3108: p_encoded => FND_API.G_FALSE
3109: );
3110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3111: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3113: FND_MSG_PUB.Count_And_Get
3114: (
3115: p_count => x_msg_count,
3116: p_data => x_msg_data,

Line 3121: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3117: p_encoded => FND_API.G_FALSE
3118: );
3119: WHEN OTHERS THEN
3120: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
3121: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3122: FND_MSG_PUB.Count_And_Get
3123: (
3124: p_count => x_msg_count,
3125: p_data => x_msg_data,