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_MSG_PUB

Line 1734: FND_MSG_PUB.ADD;

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:
1738: IF (l_matched_services.COUNT < 1) THEN

Line 1749: FND_MSG_PUB.ADD;

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:
1753: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'found following services');

Line 1921: FND_MSG_PUB.ADD;

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:
1925: END IF; -- found services

Line 1942: FND_MSG_PUB.ADD;

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;
1946:

Line 1944: FND_MSG_PUB.ADD;

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);
1948: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 2054: FND_MSG_PUB.ADD;

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:
2058: IF (l_matched_services.COUNT < 1) THEN

Line 2069: FND_MSG_PUB.ADD;

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:
2073: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'found following services');

Line 2356: FND_MSG_PUB.ADD;

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:
2360: END IF; -- 'TRUCK'

Line 2380: FND_MSG_PUB.ADD;

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;
2384:

Line 2382: FND_MSG_PUB.ADD;

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);
2386: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 2480: FND_MSG_PUB.initialize;

2476:
2477: -- Initialize message list if p_init_msg_list is set to TRUE.
2478: IF FND_API.to_Boolean( p_init_msg_list )
2479: THEN
2480: FND_MSG_PUB.initialize;
2481: END IF;
2482:
2483: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2484:

Line 2504: FND_MSG_PUB.Count_And_Get

2500: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_commit='||p_commit);
2501: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_source_type='||p_source_type);
2502: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_action='||p_action);
2503:
2504: FND_MSG_PUB.Count_And_Get
2505: (
2506: p_count => x_msg_count,
2507: p_data => x_msg_data,
2508: p_encoded => FND_API.G_FALSE

Line 2552: FND_MSG_PUB.Count_And_Get

2548: CLOSE c_get_req_id;
2549: x_request_id := l_request_id;
2550: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'*** Request Id :'||l_request_id);
2551:
2552: FND_MSG_PUB.Count_And_Get
2553: (
2554: p_count => x_msg_count,
2555: p_data => x_msg_data,
2556: p_encoded => FND_API.G_FALSE

Line 2578: FND_MSG_PUB.Count_And_Get

2574:
2575: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'get_services_failed');
2576: raise FND_API.G_EXC_ERROR;
2577: ELSE
2578: FND_MSG_PUB.Count_And_Get
2579: (
2580: p_count => x_msg_count,
2581: p_data => x_msg_data,
2582: p_encoded => FND_API.G_FALSE

Line 2652: FND_MSG_PUB.ADD;

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:
2656: IF (l_matched_services.COUNT < 1) THEN

Line 2665: FND_MSG_PUB.ADD;

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:
2669: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'found following services');

Line 2827: FND_MSG_PUB.ADD;

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:
2831: -- Pick minimum of TL and non-TL all rates are in target currency

Line 2909: FND_MSG_PUB.ADD;

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
2913: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2911: FND_MSG_PUB.ADD;

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.
2915: --

Line 2924: FND_MSG_PUB.ADD;

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.
2928: --

Line 2926: FND_MSG_PUB.ADD;

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 )
2930: THEN

Line 2966: FND_MSG_PUB.Count_And_Get

2962: --
2963: --
2964: -- Standard call to get message count and if count is 1,get message info.
2965: --
2966: FND_MSG_PUB.Count_And_Get
2967: (
2968: p_count => x_msg_count,
2969: p_data => x_msg_data,
2970: p_encoded => FND_API.G_FALSE

Line 2982: FND_MSG_PUB.ADD;

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;
2986: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2984: FND_MSG_PUB.ADD;

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
2988: (

Line 2987: FND_MSG_PUB.Count_And_Get

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
2988: (
2989: p_count => x_msg_count,
2990: p_data => x_msg_data,
2991: p_encoded => FND_API.G_FALSE

Line 2999: FND_MSG_PUB.ADD;

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;
3003: FND_MSG_PUB.Count_And_Get

Line 3001: FND_MSG_PUB.ADD;

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: (
3005: p_count => x_msg_count,

Line 3003: FND_MSG_PUB.Count_And_Get

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: (
3005: p_count => x_msg_count,
3006: p_data => x_msg_data,
3007: p_encoded => FND_API.G_FALSE

Line 3017: FND_MSG_PUB.ADD;

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;
3021: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3019: FND_MSG_PUB.ADD;

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
3023: (

Line 3022: FND_MSG_PUB.Count_And_Get

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
3023: (
3024: p_count => x_msg_count,
3025: p_data => x_msg_data,
3026: p_encoded => FND_API.G_FALSE