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_API

Line 469: raise FND_API.G_EXC_ERROR;

465: x_return_status => l_return_status);
466:
467: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
468: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'currency_conversion_failed');
469: raise FND_API.G_EXC_ERROR;
470: END IF;
471:
472: ELSE
473: l_converted_amount := p_lane_rate;

Line 577: raise FND_API.G_EXC_ERROR;

573: x_return_status => l_return_status);
574:
575: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
576: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'currency_conversion_failed');
577: raise FND_API.G_EXC_ERROR;
578: END IF;
579:
580: ELSE
581: l_converted_amount := p_fc_temp_price(j).unit_amount;

Line 616: raise FND_API.G_EXC_ERROR;

612: x_return_status => l_return_status);
613:
614: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
615: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'currency_conversion_failed');
616: raise FND_API.G_EXC_ERROR;
617: END IF;
618:
619: ELSE
620: l_converted_amount := p_fc_temp_price(j).charge_unit_value;

Line 691: raise FND_API.G_EXC_ERROR;

687: x_return_status => l_return_status);
688:
689: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
690: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'currency_conversion_failed');
691: raise FND_API.G_EXC_ERROR;
692: END IF;
693:
694: ELSE
695: l_converted_amount := l_charge_tab(k).charge;

Line 721: WHEN FND_API.G_EXC_ERROR THEN

717:
718: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
719:
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
723: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
724: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
725: WHEN others THEN

Line 723: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

719:
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
723: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
724: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
725: WHEN others THEN
726: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
727: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 900: WHEN FND_API.G_EXC_ERROR THEN

896:
897: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
898:
899: EXCEPTION
900: WHEN FND_API.G_EXC_ERROR THEN
901: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
902: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
903: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
904: WHEN others THEN

Line 902: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

898:
899: EXCEPTION
900: WHEN FND_API.G_EXC_ERROR THEN
901: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
902: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
903: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
904: WHEN others THEN
905: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
906: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 1167: raise FND_API.G_EXC_ERROR;

1163: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) and
1164: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1165: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'search_lane_failed');
1166: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,l_msg_data);
1167: raise FND_API.G_EXC_ERROR;
1168: END IF;
1169:
1170: /*
1171: -- for testing

Line 1405: WHEN FND_API.G_EXC_ERROR THEN

1401:
1402: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1407: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
1408: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1409: WHEN others THEN

Line 1407: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1407: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
1408: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1409: WHEN others THEN
1410: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1411: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 1760: raise FND_API.G_EXC_ERROR;

1756: x_return_status => l_return_status);
1757:
1758: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1759: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
1760: raise FND_API.G_EXC_ERROR;
1761: END IF;
1762:
1763: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populating shipment...');
1764: populate_shipment(

Line 1772: raise FND_API.G_EXC_ERROR;

1768:
1769: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1770:
1771: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populate_shipment_failed');
1772: raise FND_API.G_EXC_ERROR;
1773:
1774: END IF;
1775:
1776: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'rating on all the lanes...');

Line 1843: raise FND_API.G_EXC_ERROR;

1839:
1840: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1841:
1842: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populate_rate_failed');
1843: raise FND_API.G_EXC_ERROR;
1844:
1845: END IF;
1846:
1847: l_all_lane_failed := false;

Line 1858: raise FND_API.G_EXC_ERROR;

1854:
1855: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1856:
1857: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
1858: raise FND_API.G_EXC_ERROR;
1859:
1860: END IF;
1861:
1862: END IF;

Line 1883: raise FND_API.G_EXC_ERROR;

1879: THEN
1880: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1881: THEN
1882: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'OM_TL_Rate failed');
1883: raise FND_API.G_EXC_ERROR;
1884: END IF;
1885: END IF;
1886:
1887: IF(x_source_header_rates_tab.COUNT > 0)

Line 1905: raise FND_API.G_EXC_ERROR;

1901: THEN
1902: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1903: THEN
1904: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Sort_Source_Rates failed');
1905: raise FND_API.G_EXC_ERROR;
1906: END IF;
1907: END IF;
1908:
1909:

Line 1951: WHEN FND_API.G_EXC_ERROR THEN

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);
1949:
1950: EXCEPTION
1951: WHEN FND_API.G_EXC_ERROR THEN
1952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1953: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
1954: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1953: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

1949:
1950: EXCEPTION
1951: WHEN FND_API.G_EXC_ERROR THEN
1952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1953: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
1954: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1957: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);

Line 1955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1951: WHEN FND_API.G_EXC_ERROR THEN
1952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1953: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
1954: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1957: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1958: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
1959: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 1958: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');

1954: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1957: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1958: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
1959: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1960: WHEN others THEN
1961: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1962: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 2080: raise FND_API.G_EXC_ERROR;

2076: x_return_status => l_return_status);
2077:
2078: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2079: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2080: raise FND_API.G_EXC_ERROR;
2081: END IF;
2082: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'>>>1');
2083: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_source_header_tab(i).mode_of_transport='
2084: ||p_source_header_tab(i).mode_of_transport);

Line 2271: raise FND_API.G_EXC_ERROR;

2267:
2268: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2269:
2270: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populate_shipment_failed');
2271: raise FND_API.G_EXC_ERROR;
2272:
2273: END IF;
2274:
2275: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'rating on all the lanes...');

Line 2323: raise FND_API.G_EXC_ERROR;

2319:
2320: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2321:
2322: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populate_rate_failed');
2323: raise FND_API.G_EXC_ERROR;
2324:
2325: END IF;
2326:
2327: l_all_lane_failed := false;

Line 2338: raise FND_API.G_EXC_ERROR;

2334:
2335: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2336:
2337: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2338: raise FND_API.G_EXC_ERROR;
2339:
2340: END IF;
2341:
2342: END IF;

Line 2389: WHEN FND_API.G_EXC_ERROR THEN

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);
2387:
2388: EXCEPTION
2389: WHEN FND_API.G_EXC_ERROR THEN
2390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2391: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2392: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2391: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

2387:
2388: EXCEPTION
2389: WHEN FND_API.G_EXC_ERROR THEN
2390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2391: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2392: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2395: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);

Line 2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2389: WHEN FND_API.G_EXC_ERROR THEN
2390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2391: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2392: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2395: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2396: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
2397: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 2396: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');

2392: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2395: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2396: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
2397: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2398: WHEN others THEN
2399: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2400: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 2409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2405:
2406:
2407: PROCEDURE Get_Freight_Costs(
2408: p_api_version IN NUMBER DEFAULT 1.0,
2409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2411: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
2412: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
2413: p_source_type IN VARCHAR2,

Line 2410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2406:
2407: PROCEDURE Get_Freight_Costs(
2408: p_api_version IN NUMBER DEFAULT 1.0,
2409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2411: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
2412: p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
2413: p_source_type IN VARCHAR2,
2414: p_action IN VARCHAR2,

Line 2466: IF NOT FND_API.Compatible_API_Call

2462:
2463: SAVEPOINT GET_FREIGHT_COSTS;
2464:
2465: -- Standard call to check for call compatibility.
2466: IF NOT FND_API.Compatible_API_Call
2467: (
2468: l_api_version,
2469: p_api_version,
2470: l_api_name,

Line 2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2470: l_api_name,
2471: G_PKG_NAME
2472: )
2473: THEN
2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
2476:
2477: -- Initialize message list if p_init_msg_list is set to TRUE.
2478: IF FND_API.to_Boolean( p_init_msg_list )

Line 2478: IF FND_API.to_Boolean( p_init_msg_list )

2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
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:

Line 2490: raise FND_API.G_EXC_ERROR;

2486:
2487: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) and
2488: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2489: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'init_log_failed');
2490: raise FND_API.G_EXC_ERROR;
2491: ELSE
2492: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Initialize Logging successful ');
2493: END IF;
2494:

Line 2508: p_encoded => FND_API.G_FALSE

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
2509: );
2510: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_count='||x_msg_count);
2511: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_data='||x_msg_data);
2512:

Line 2516: raise FND_API.G_EXC_ERROR;

2512:
2513: IF (p_source_header_tab.COUNT < 1) THEN
2514:
2515: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no_source_header');
2516: raise FND_API.G_EXC_ERROR;
2517:
2518: END IF;
2519:
2520: IF (p_source_line_tab.COUNT < 1) THEN

Line 2523: raise FND_API.G_EXC_ERROR;

2519:
2520: IF (p_source_line_tab.COUNT < 1) THEN
2521:
2522: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'no_source_line');
2523: raise FND_API.G_EXC_ERROR;
2524:
2525: END IF;
2526:
2527: print_source_line_tab(

Line 2533: raise FND_API.G_EXC_ERROR;

2529: x_return_status => l_return_status);
2530:
2531: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2532: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2533: raise FND_API.G_EXC_ERROR;
2534: END IF;
2535:
2536: print_source_header_tab(
2537: p_source_header_tab => p_source_header_tab,

Line 2542: raise FND_API.G_EXC_ERROR;

2538: x_return_status => l_return_status);
2539:
2540: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2541: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2542: raise FND_API.G_EXC_ERROR;
2543: END IF;
2544:
2545: -- Generate comparison request_id here and populate it into l_request_id
2546: OPEN c_get_req_id;

Line 2556: p_encoded => FND_API.G_FALSE

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
2557: );
2558: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_count='||x_msg_count);
2559: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_data='||x_msg_data);
2560:

Line 2576: raise FND_API.G_EXC_ERROR;

2572: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2573: and (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
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,

Line 2582: p_encoded => FND_API.G_FALSE

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
2583: );
2584: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_count='||x_msg_count);
2585: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_data='||x_msg_data);
2586:

Line 2589: IF FND_API.To_Boolean( p_commit )

2585: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_data='||x_msg_data);
2586:
2587: -- Standard check of p_commit.
2588: --
2589: IF FND_API.To_Boolean( p_commit )
2590: THEN
2591: COMMIT WORK;
2592: END IF;
2593: x_return_status := l_return_status;

Line 2608: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2604:
2605: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2606: and (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2607: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2608: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2609: ELSE
2610: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Get_FTE_Estimate_Rates failed');
2611: raise FND_API.G_EXC_ERROR;
2612: END IF;

Line 2611: raise FND_API.G_EXC_ERROR;

2607: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2608: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2609: ELSE
2610: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Get_FTE_Estimate_Rates failed');
2611: raise FND_API.G_EXC_ERROR;
2612: END IF;
2613: ELSE
2614: -- Standard check of p_commit.
2615: --

Line 2616: IF FND_API.To_Boolean( p_commit )

2612: END IF;
2613: ELSE
2614: -- Standard check of p_commit.
2615: --
2616: IF FND_API.To_Boolean( p_commit )
2617: THEN
2618: COMMIT WORK;
2619: END IF;
2620: x_return_status := l_return_status;

Line 2676: raise FND_API.G_EXC_ERROR;

2672: x_return_status => l_return_status);
2673:
2674: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2675: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2676: raise FND_API.G_EXC_ERROR;
2677: END IF;
2678:
2679: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populating shipment...');
2680: populate_shipment(

Line 2688: raise FND_API.G_EXC_ERROR;

2684:
2685: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2686:
2687: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populate_shipment_failed');
2688: raise FND_API.G_EXC_ERROR;
2689:
2690: END IF;
2691:
2692: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'rating on all the lanes...');

Line 2761: raise FND_API.G_EXC_ERROR;

2757: x_return_status => l_return_status);
2758:
2759: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2760: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'currency_conversion_failed');
2761: raise FND_API.G_EXC_ERROR;
2762: END IF;
2763:
2764: ELSE
2765: l_converted_amount := l_lane_rate;

Line 2803: raise FND_API.G_EXC_ERROR;

2799: THEN
2800: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2801: THEN
2802: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'OM_TL_Rate failed');
2803: raise FND_API.G_EXC_ERROR;
2804: END IF;
2805: END IF;
2806:
2807:

Line 2858: raise FND_API.G_EXC_ERROR;

2854:
2855: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2856:
2857: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'populate_rate_failed');
2858: raise FND_API.G_EXC_ERROR;
2859:
2860: END IF;
2861: ELSE
2862:

Line 2873: raise FND_API.G_EXC_ERROR;

2869:
2870: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2871:
2872: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Append_Rates');
2873: raise FND_API.G_EXC_ERROR;
2874:
2875: END IF;
2876:
2877: END IF;

Line 2890: raise FND_API.G_EXC_ERROR;

2886:
2887: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2888:
2889: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2890: raise FND_API.G_EXC_ERROR;
2891:
2892: END IF;
2893:
2894: END IF; -- found rate

Line 2916: IF FND_API.To_Boolean( p_commit )

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: --
2916: IF FND_API.To_Boolean( p_commit )
2917: THEN
2918: COMMIT WORK;
2919: END IF;
2920: ELSE

Line 2929: IF FND_API.To_Boolean( p_commit )

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
2931: COMMIT WORK;
2932: END IF;
2933: END IF;

Line 2949: raise FND_API.G_EXC_ERROR;

2945:
2946: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2947:
2948: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2949: raise FND_API.G_EXC_ERROR;
2950:
2951: END IF;
2952:
2953: print_source_header_tab(

Line 2959: raise FND_API.G_EXC_ERROR;

2955: x_return_status => l_return_status);
2956:
2957: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2958: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'print_failed');
2959: raise FND_API.G_EXC_ERROR;
2960: END IF;
2961:
2962: --
2963: --

Line 2970: p_encoded => FND_API.G_FALSE

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
2971: );
2972: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_count='||x_msg_count);
2973: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_msg_data='||x_msg_data);
2974:

Line 2979: WHEN FND_API.G_EXC_ERROR THEN

2975: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_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');

Line 2991: p_encoded => FND_API.G_FALSE

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

Line 2993: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

2989: p_count => x_msg_count,
2990: p_data => x_msg_data,
2991: p_encoded => FND_API.G_FALSE
2992: );
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');

Line 2996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2992: );
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');

Line 3007: p_encoded => FND_API.G_FALSE

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
3008: );
3009: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3010: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3011: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 3026: p_encoded => FND_API.G_FALSE

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
3027: );
3028: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3029: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3030: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);