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_FREIGHT_RATING_PUB dependencies on FND_MESSAGE

Line 1728: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');

1724: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1725:
1726: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'search_services failed');
1727: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1728: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
1729: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1730: l_fail_group_count := l_fail_group_count + 1;
1731:
1732: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 1729: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

1725:
1726: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'search_services failed');
1727: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1728: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
1729: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1730: l_fail_group_count := l_fail_group_count + 1;
1731:
1732: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1733: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 1732: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

1728: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
1729: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1730: l_fail_group_count := l_fail_group_count + 1;
1731:
1732: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1733: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
1734: FND_MSG_PUB.ADD;
1735:
1736: ELSE -- search services successful

Line 1733: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

1729: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1730: l_fail_group_count := l_fail_group_count + 1;
1731:
1732: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1733: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
1734: FND_MSG_PUB.ADD;
1735:
1736: ELSE -- search services successful
1737:

Line 1743: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');

1739:
1740: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no services found');
1741: -- no services found
1742: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');
1744: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1745: l_fail_group_count := l_fail_group_count + 1;
1746:
1747: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 1744: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

1740: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no services found');
1741: -- no services found
1742: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');
1744: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1745: l_fail_group_count := l_fail_group_count + 1;
1746:
1747: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1748: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 1747: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

1743: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');
1744: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1745: l_fail_group_count := l_fail_group_count + 1;
1746:
1747: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1748: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
1749: FND_MSG_PUB.ADD;
1750:
1751: ELSE -- found services

Line 1748: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

1744: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1745: l_fail_group_count := l_fail_group_count + 1;
1746:
1747: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1748: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
1749: FND_MSG_PUB.ADD;
1750:
1751: ELSE -- found services
1752:

Line 1915: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');

1911: IF (l_all_lane_failed) THEN
1912:
1913: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no rates found');
1914: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1915: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
1916: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1917: l_fail_group_count := l_fail_group_count + 1;
1918:
1919: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 1916: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

1912:
1913: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no rates found');
1914: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1915: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
1916: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1917: l_fail_group_count := l_fail_group_count + 1;
1918:
1919: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1920: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 1919: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

1915: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
1916: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1917: l_fail_group_count := l_fail_group_count + 1;
1918:
1919: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1920: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
1921: FND_MSG_PUB.ADD;
1922:
1923: END IF;

Line 1920: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

1916: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1917: l_fail_group_count := l_fail_group_count + 1;
1918:
1919: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
1920: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
1921: FND_MSG_PUB.ADD;
1922:
1923: END IF;
1924:

Line 1940: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

1936: ELSIF (l_fail_group_count = 0) THEN
1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1938: ELSE
1939: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1940: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
1941: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
1942: FND_MSG_PUB.ADD;
1943: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
1944: FND_MSG_PUB.ADD;

Line 1941: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());

1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1938: ELSE
1939: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1940: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
1941: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
1942: FND_MSG_PUB.ADD;
1943: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
1944: FND_MSG_PUB.ADD;
1945: END IF;

Line 1943: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');

1939: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1940: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
1941: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
1942: FND_MSG_PUB.ADD;
1943: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
1944: FND_MSG_PUB.ADD;
1945: END IF;
1946:
1947: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);

Line 2048: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');

2044: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2045:
2046: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'search_services failed');
2047: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2048: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
2049: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2050: l_fail_group_count := l_fail_group_count + 1;
2051:
2052: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 2049: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

2045:
2046: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'search_services failed');
2047: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2048: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
2049: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2050: l_fail_group_count := l_fail_group_count + 1;
2051:
2052: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2053: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 2052: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

2048: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
2049: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2050: l_fail_group_count := l_fail_group_count + 1;
2051:
2052: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2053: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2054: FND_MSG_PUB.ADD;
2055:
2056: ELSE -- search services successful

Line 2053: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

2049: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2050: l_fail_group_count := l_fail_group_count + 1;
2051:
2052: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2053: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2054: FND_MSG_PUB.ADD;
2055:
2056: ELSE -- search services successful
2057:

Line 2063: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');

2059:
2060: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no services found');
2061: -- no services found
2062: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2063: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');
2064: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2065: l_fail_group_count := l_fail_group_count + 1;
2066:
2067: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 2064: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

2060: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no services found');
2061: -- no services found
2062: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2063: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');
2064: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2065: l_fail_group_count := l_fail_group_count + 1;
2066:
2067: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2068: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 2067: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

2063: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_SERVICES_FOUND');
2064: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2065: l_fail_group_count := l_fail_group_count + 1;
2066:
2067: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2068: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2069: FND_MSG_PUB.ADD;
2070:
2071: ELSE -- found services

Line 2068: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

2064: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2065: l_fail_group_count := l_fail_group_count + 1;
2066:
2067: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2068: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2069: FND_MSG_PUB.ADD;
2070:
2071: ELSE -- found services
2072:

Line 2350: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');

2346: IF (l_all_lane_failed) THEN
2347:
2348: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no rates found');
2349: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2350: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
2351: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2352: l_fail_group_count := l_fail_group_count + 1;
2353:
2354: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 2351: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

2347:
2348: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no rates found');
2349: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2350: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
2351: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2352: l_fail_group_count := l_fail_group_count + 1;
2353:
2354: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2355: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 2354: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

2350: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
2351: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2352: l_fail_group_count := l_fail_group_count + 1;
2353:
2354: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2355: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2356: FND_MSG_PUB.ADD;
2357:
2358: END IF;

Line 2355: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

2351: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2352: l_fail_group_count := l_fail_group_count + 1;
2353:
2354: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2355: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2356: FND_MSG_PUB.ADD;
2357:
2358: END IF;
2359:

Line 2378: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

2374: IF (l_fail_group_count = 0) THEN
2375: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2376: ELSE
2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2378: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2379: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2380: FND_MSG_PUB.ADD;
2381: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
2382: FND_MSG_PUB.ADD;

Line 2379: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());

2375: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2376: ELSE
2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2378: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2379: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2380: FND_MSG_PUB.ADD;
2381: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
2382: FND_MSG_PUB.ADD;
2383: END IF;

Line 2381: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');

2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2378: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2379: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2380: FND_MSG_PUB.ADD;
2381: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
2382: FND_MSG_PUB.ADD;
2383: END IF;
2384:
2385: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);

Line 2646: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');

2642: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2643:
2644: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'search_services failed');
2645: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2646: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
2647: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2648: l_fail_group_count := l_fail_group_count + 1;
2649:
2650: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 2647: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

2643:
2644: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'search_services failed');
2645: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2646: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
2647: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2648: l_fail_group_count := l_fail_group_count + 1;
2649:
2650: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2651: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 2650: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

2646: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_SEARCH_SERVICES_FAIL');
2647: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2648: l_fail_group_count := l_fail_group_count + 1;
2649:
2650: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2651: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2652: FND_MSG_PUB.ADD;
2653:
2654: ELSE -- search services successful

Line 2651: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

2647: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2648: l_fail_group_count := l_fail_group_count + 1;
2649:
2650: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2651: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2652: FND_MSG_PUB.ADD;
2653:
2654: ELSE -- search services successful
2655:

Line 2663: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

2659: -- no services found
2660: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2661: l_fail_group_count := l_fail_group_count + 1;
2662:
2663: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2664: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2665: FND_MSG_PUB.ADD;
2666:
2667: ELSE -- found services

Line 2664: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

2660: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2661: l_fail_group_count := l_fail_group_count + 1;
2662:
2663: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2664: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2665: FND_MSG_PUB.ADD;
2666:
2667: ELSE -- found services
2668:

Line 2821: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');

2817: IF (l_all_lane_failed) THEN
2818:
2819: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no rates found');
2820: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2821: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
2822: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2823: l_fail_group_count := l_fail_group_count + 1;
2824:
2825: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

Line 2822: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

2818:
2819: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no rates found');
2820: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2821: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
2822: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2823: l_fail_group_count := l_fail_group_count + 1;
2824:
2825: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2826: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

Line 2825: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');

2821: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_NO_RATES_FOUND');
2822: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2823: l_fail_group_count := l_fail_group_count + 1;
2824:
2825: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2826: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2827: FND_MSG_PUB.ADD;
2828:
2829: ELSE -- found rate

Line 2826: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);

2822: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
2823: l_fail_group_count := l_fail_group_count + 1;
2824:
2825: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_OMDEL_FL');
2826: FND_MESSAGE.SET_TOKEN('CONSOLIDATION_ID',p_source_header_tab(i).consolidation_id);
2827: FND_MSG_PUB.ADD;
2828:
2829: ELSE -- found rate
2830:

Line 2907: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

2903: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_fail_group_count='||l_fail_group_count);
2904:
2905: IF (l_fail_group_count = l_group_count) THEN
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2907: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2908: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2909: FND_MSG_PUB.ADD;
2910: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
2911: FND_MSG_PUB.ADD;

Line 2908: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());

2904:
2905: IF (l_fail_group_count = l_group_count) THEN
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2907: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2908: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2909: FND_MSG_PUB.ADD;
2910: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
2911: FND_MSG_PUB.ADD;
2912: ELSIF (l_fail_group_count = 0) THEN

Line 2910: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');

2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2907: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2908: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2909: FND_MSG_PUB.ADD;
2910: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
2911: FND_MSG_PUB.ADD;
2912: ELSIF (l_fail_group_count = 0) THEN
2913: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2914: -- Standard check of p_commit.

Line 2922: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

2918: COMMIT WORK;
2919: END IF;
2920: ELSE
2921: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2922: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2923: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2924: FND_MSG_PUB.ADD;
2925: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
2926: FND_MSG_PUB.ADD;

Line 2923: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());

2919: END IF;
2920: ELSE
2921: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2922: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2923: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2924: FND_MSG_PUB.ADD;
2925: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
2926: FND_MSG_PUB.ADD;
2927: -- Standard check of p_commit.

Line 2925: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');

2921: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2922: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2923: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2924: FND_MSG_PUB.ADD;
2925: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_SUC_W');
2926: FND_MSG_PUB.ADD;
2927: -- Standard check of p_commit.
2928: --
2929: IF FND_API.To_Boolean( p_commit )

Line 2980: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

2976: FTE_FREIGHT_PRICING_UTIL.close_logs;
2977:
2978: EXCEPTION
2979: WHEN FND_API.G_EXC_ERROR THEN
2980: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2981: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2982: FND_MSG_PUB.ADD;
2983: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
2984: FND_MSG_PUB.ADD;

Line 2981: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());

2977:
2978: EXCEPTION
2979: WHEN FND_API.G_EXC_ERROR THEN
2980: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2981: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2982: FND_MSG_PUB.ADD;
2983: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
2984: FND_MSG_PUB.ADD;
2985: ROLLBACK TO GET_FREIGHT_COSTS;

Line 2983: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');

2979: WHEN FND_API.G_EXC_ERROR THEN
2980: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2981: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2982: FND_MSG_PUB.ADD;
2983: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
2984: FND_MSG_PUB.ADD;
2985: ROLLBACK TO GET_FREIGHT_COSTS;
2986: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2987: FND_MSG_PUB.Count_And_Get

Line 2997: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

2993: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2994: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2995: FTE_FREIGHT_PRICING_UTIL.close_logs;
2996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2997: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2998: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2999: FND_MSG_PUB.ADD;
3000: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
3001: FND_MSG_PUB.ADD;

Line 2998: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());

2994: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2995: FTE_FREIGHT_PRICING_UTIL.close_logs;
2996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2997: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2998: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2999: FND_MSG_PUB.ADD;
3000: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
3001: FND_MSG_PUB.ADD;
3002: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3000: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');

2996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2997: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
2998: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
2999: FND_MSG_PUB.ADD;
3000: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
3001: FND_MSG_PUB.ADD;
3002: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3003: FND_MSG_PUB.Count_And_Get
3004: (

Line 3015: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

3011: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
3012: FTE_FREIGHT_PRICING_UTIL.close_logs;
3013: ROLLBACK TO GET_FREIGHT_COSTS;
3014: WHEN others THEN
3015: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
3016: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
3017: FND_MSG_PUB.ADD;
3018: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
3019: FND_MSG_PUB.ADD;

Line 3016: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());

3012: FTE_FREIGHT_PRICING_UTIL.close_logs;
3013: ROLLBACK TO GET_FREIGHT_COSTS;
3014: WHEN others THEN
3015: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
3016: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
3017: FND_MSG_PUB.ADD;
3018: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
3019: FND_MSG_PUB.ADD;
3020: ROLLBACK TO GET_FREIGHT_COSTS;

Line 3018: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');

3014: WHEN others THEN
3015: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
3016: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
3017: FND_MSG_PUB.ADD;
3018: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
3019: FND_MSG_PUB.ADD;
3020: ROLLBACK TO GET_FREIGHT_COSTS;
3021: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3022: FND_MSG_PUB.Count_And_Get