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_MLS_UTIL dependencies on FND_API

Line 1493: l_msg := substrb(FND_MSG_PUB.GET( p_encoded => FND_API.G_FALSE ),1,240);

1489:
1490: FOR l_count IN 1..NVL(p_msg_count,0)
1491: LOOP
1492: --{
1493: l_msg := substrb(FND_MSG_PUB.GET( p_encoded => FND_API.G_FALSE ),1,240);
1494: l_msg_string := l_msg_string || ' : ' || l_msg;
1495: --}
1496: END LOOP;
1497: ELSE

Line 1670: (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1666:
1667:
1668: -- get the carrier information
1669: PROCEDURE GET_CARRIER_CONTACT_INFO
1670: (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1671: p_tender_number IN NUMBER,
1672: x_return_status OUT NOCOPY VARCHAR2,
1673: x_msg_count OUT NOCOPY NUMBER,
1674: x_msg_data OUT NOCOPY VARCHAR2,

Line 1728: IF FND_API.to_Boolean( p_init_msg_list )

1724: --
1725: -- Initialize message list if p_init_msg_list is set to TRUE.
1726: --
1727: --
1728: IF FND_API.to_Boolean( p_init_msg_list )
1729: THEN
1730: FND_MSG_PUB.initialize;
1731: END IF;
1732: --

Line 1761: RAISE FND_API.G_EXC_ERROR;

1757: THEN
1758: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_CARRIER_CONTACT');
1759: FND_MESSAGE.SET_TOKEN('TENDER_NUMBER',p_tender_number);
1760: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1761: RAISE FND_API.G_EXC_ERROR;
1762: END IF;
1763:
1764: ---
1765: -- get the contact info

Line 1787: p_encoded => FND_API.G_FALSE

1783: FND_MSG_PUB.Count_And_Get
1784: (
1785: p_count => x_msg_count,
1786: p_data => x_msg_data,
1787: p_encoded => FND_API.G_FALSE
1788: );
1789: --
1790: --
1791:

Line 1798: WHEN FND_API.G_EXC_ERROR THEN

1794:
1795: --}
1796: EXCEPTION
1797: --{
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: ROLLBACK TO GET_CARRIER_CONTACT_INFO_PUB;
1800: x_return_status := FND_API.G_RET_STS_ERROR ;
1801: FND_MSG_PUB.Count_And_Get
1802: (

Line 1800: x_return_status := FND_API.G_RET_STS_ERROR ;

1796: EXCEPTION
1797: --{
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: ROLLBACK TO GET_CARRIER_CONTACT_INFO_PUB;
1800: x_return_status := FND_API.G_RET_STS_ERROR ;
1801: FND_MSG_PUB.Count_And_Get
1802: (
1803: p_count => x_msg_count,
1804: p_data => x_msg_data,

Line 1805: p_encoded => FND_API.G_FALSE

1801: FND_MSG_PUB.Count_And_Get
1802: (
1803: p_count => x_msg_count,
1804: p_data => x_msg_data,
1805: p_encoded => FND_API.G_FALSE
1806: );
1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1808: ROLLBACK TO GET_CARRIER_CONTACT_INFO_PUB;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1803: p_count => x_msg_count,
1804: p_data => x_msg_data,
1805: p_encoded => FND_API.G_FALSE
1806: );
1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1808: ROLLBACK TO GET_CARRIER_CONTACT_INFO_PUB;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1810: FND_MSG_PUB.Count_And_Get
1811: (

Line 1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1805: p_encoded => FND_API.G_FALSE
1806: );
1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1808: ROLLBACK TO GET_CARRIER_CONTACT_INFO_PUB;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1810: FND_MSG_PUB.Count_And_Get
1811: (
1812: p_count => x_msg_count,
1813: p_data => x_msg_data,

Line 1814: p_encoded => FND_API.G_FALSE

1810: FND_MSG_PUB.Count_And_Get
1811: (
1812: p_count => x_msg_count,
1813: p_data => x_msg_data,
1814: p_encoded => FND_API.G_FALSE
1815: );
1816: WHEN OTHERS THEN
1817: ROLLBACK TO GET_CARRIER_CONTACT_INFO_PUB;
1818: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CARRIER_CONTACT_INFO');

Line 1824: p_encoded => FND_API.G_FALSE

1820: FND_MSG_PUB.Count_And_Get
1821: (
1822: p_count => x_msg_count,
1823: p_data => x_msg_data,
1824: p_encoded => FND_API.G_FALSE
1825: );
1826:
1827: --}
1828:

Line 1954: (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1950:
1951: END GET_PICKUP_DLVY_ORGID_BY_TRIP;
1952:
1953: PROCEDURE GET_SHIPPER_CONTACT_INFO
1954: (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1955: p_shipper_name IN VARCHAR2,
1956: x_return_status OUT NOCOPY VARCHAR2,
1957: x_msg_count OUT NOCOPY NUMBER,
1958: x_msg_data OUT NOCOPY VARCHAR2,

Line 1998: IF FND_API.to_Boolean( p_init_msg_list )

1994: --
1995: -- Initialize message list if p_init_msg_list is set to TRUE.
1996: --
1997: --
1998: IF FND_API.to_Boolean( p_init_msg_list )
1999: THEN
2000: FND_MSG_PUB.initialize;
2001: END IF;
2002: --

Line 2057: p_encoded => FND_API.G_FALSE

2053: FND_MSG_PUB.Count_And_Get
2054: (
2055: p_count => x_msg_count,
2056: p_data => x_msg_data,
2057: p_encoded => FND_API.G_FALSE
2058: );
2059: --
2060: --
2061:

Line 2066: WHEN FND_API.G_EXC_ERROR THEN

2062:
2063: --}
2064: EXCEPTION
2065: --{
2066: WHEN FND_API.G_EXC_ERROR THEN
2067: ROLLBACK TO GET_SHIPPER_CONTACT_INFO_PUB;
2068: x_return_status := FND_API.G_RET_STS_ERROR ;
2069: FND_MSG_PUB.Count_And_Get
2070: (

Line 2068: x_return_status := FND_API.G_RET_STS_ERROR ;

2064: EXCEPTION
2065: --{
2066: WHEN FND_API.G_EXC_ERROR THEN
2067: ROLLBACK TO GET_SHIPPER_CONTACT_INFO_PUB;
2068: x_return_status := FND_API.G_RET_STS_ERROR ;
2069: FND_MSG_PUB.Count_And_Get
2070: (
2071: p_count => x_msg_count,
2072: p_data => x_msg_data,

Line 2073: p_encoded => FND_API.G_FALSE

2069: FND_MSG_PUB.Count_And_Get
2070: (
2071: p_count => x_msg_count,
2072: p_data => x_msg_data,
2073: p_encoded => FND_API.G_FALSE
2074: );
2075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2076: ROLLBACK TO GET_SHIPPER_CONTACT_INFO_PUB;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2071: p_count => x_msg_count,
2072: p_data => x_msg_data,
2073: p_encoded => FND_API.G_FALSE
2074: );
2075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2076: ROLLBACK TO GET_SHIPPER_CONTACT_INFO_PUB;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2078: FND_MSG_PUB.Count_And_Get
2079: (

Line 2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2073: p_encoded => FND_API.G_FALSE
2074: );
2075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2076: ROLLBACK TO GET_SHIPPER_CONTACT_INFO_PUB;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2078: FND_MSG_PUB.Count_And_Get
2079: (
2080: p_count => x_msg_count,
2081: p_data => x_msg_data,

Line 2082: p_encoded => FND_API.G_FALSE

2078: FND_MSG_PUB.Count_And_Get
2079: (
2080: p_count => x_msg_count,
2081: p_data => x_msg_data,
2082: p_encoded => FND_API.G_FALSE
2083: );
2084: WHEN OTHERS THEN
2085: ROLLBACK TO GET_SHIPPER_CONTACT_INFO_PUB;
2086: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_SHIPPER_CONTACT_INFO');

Line 2092: p_encoded => FND_API.G_FALSE

2088: FND_MSG_PUB.Count_And_Get
2089: (
2090: p_count => x_msg_count,
2091: p_data => x_msg_data,
2092: p_encoded => FND_API.G_FALSE
2093: );
2094:
2095: --}
2096:

Line 2572: IF FND_API.to_Boolean( p_init_msg_list )

2568: IF l_debug_on THEN
2569: WSH_DEBUG_SV.push(l_module_name);
2570: END IF;
2571:
2572: IF FND_API.to_Boolean( p_init_msg_list )
2573: THEN
2574: FND_MSG_PUB.initialize;
2575: END IF;
2576:

Line 2758: p_encoded => FND_API.G_FALSE

2754: FND_MSG_PUB.Count_And_Get
2755: (
2756: p_count => x_msg_count,
2757: p_data => x_msg_data,
2758: p_encoded => FND_API.G_FALSE
2759: );
2760:
2761:
2762: --

Line 2772: WHEN FND_API.G_EXC_ERROR THEN

2768:
2769: --}
2770: EXCEPTION
2771: --{
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774: FND_MSG_PUB.Count_And_Get
2775: (
2776: p_count => x_msg_count,

Line 2773: x_return_status := FND_API.G_RET_STS_ERROR;

2769: --}
2770: EXCEPTION
2771: --{
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774: FND_MSG_PUB.Count_And_Get
2775: (
2776: p_count => x_msg_count,
2777: p_data => x_msg_data,

Line 2778: p_encoded => FND_API.G_FALSE

2774: FND_MSG_PUB.Count_And_Get
2775: (
2776: p_count => x_msg_count,
2777: p_data => x_msg_data,
2778: p_encoded => FND_API.G_FALSE
2779: );
2780: IF l_debug_on THEN
2781: WSH_DEBUG_SV.pop(l_module_name);
2782: END IF;

Line 2784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2780: IF l_debug_on THEN
2781: WSH_DEBUG_SV.pop(l_module_name);
2782: END IF;
2783:
2784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2786: FND_MSG_PUB.Count_And_Get
2787: (
2788: p_count => x_msg_count,

Line 2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2781: WSH_DEBUG_SV.pop(l_module_name);
2782: END IF;
2783:
2784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2786: FND_MSG_PUB.Count_And_Get
2787: (
2788: p_count => x_msg_count,
2789: p_data => x_msg_data,

Line 2790: p_encoded => FND_API.G_FALSE

2786: FND_MSG_PUB.Count_And_Get
2787: (
2788: p_count => x_msg_count,
2789: p_data => x_msg_data,
2790: p_encoded => FND_API.G_FALSE
2791: );
2792: IF l_debug_on THEN
2793: WSH_DEBUG_SV.pop(l_module_name);
2794: END IF;

Line 2797: x_return_status := FND_API.G_RET_STS_ERROR;

2793: WSH_DEBUG_SV.pop(l_module_name);
2794: END IF;
2795: WHEN OTHERS THEN
2796: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_CURRENCY_CODE');
2797: x_return_status := FND_API.G_RET_STS_ERROR;
2798: FND_MSG_PUB.Count_And_Get
2799: (
2800: p_count => x_msg_count,
2801: p_data => x_msg_data,

Line 2802: p_encoded => FND_API.G_FALSE

2798: FND_MSG_PUB.Count_And_Get
2799: (
2800: p_count => x_msg_count,
2801: p_data => x_msg_data,
2802: p_encoded => FND_API.G_FALSE
2803: );
2804: IF l_debug_on THEN
2805: WSH_DEBUG_SV.pop(l_module_name);
2806: END IF;

Line 2883: IF FND_API.to_Boolean( p_init_msg_list )

2879: IF l_debug_on THEN
2880: WSH_DEBUG_SV.push(l_module_name);
2881: END IF;
2882:
2883: IF FND_API.to_Boolean( p_init_msg_list )
2884: THEN
2885: FND_MSG_PUB.initialize;
2886: END IF;
2887:

Line 3006: p_encoded => FND_API.G_FALSE

3002: FND_MSG_PUB.Count_And_Get
3003: (
3004: p_count => x_msg_count,
3005: p_data => x_msg_data,
3006: p_encoded => FND_API.G_FALSE
3007: );
3008:
3009:
3010: --

Line 3020: WHEN FND_API.G_EXC_ERROR THEN

3016:
3017: --}
3018: EXCEPTION
3019: --{
3020: WHEN FND_API.G_EXC_ERROR THEN
3021: x_return_status := FND_API.G_RET_STS_ERROR;
3022: FND_MSG_PUB.Count_And_Get
3023: (
3024: p_count => x_msg_count,

Line 3021: x_return_status := FND_API.G_RET_STS_ERROR;

3017: --}
3018: EXCEPTION
3019: --{
3020: WHEN FND_API.G_EXC_ERROR THEN
3021: x_return_status := FND_API.G_RET_STS_ERROR;
3022: FND_MSG_PUB.Count_And_Get
3023: (
3024: p_count => x_msg_count,
3025: p_data => x_msg_data,

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: IF l_debug_on THEN
3029: WSH_DEBUG_SV.pop(l_module_name);
3030: END IF;

Line 3032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.pop(l_module_name);
3030: END IF;
3031:
3032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3034: FND_MSG_PUB.Count_And_Get
3035: (
3036: p_count => x_msg_count,

Line 3033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3029: WSH_DEBUG_SV.pop(l_module_name);
3030: END IF;
3031:
3032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3034: FND_MSG_PUB.Count_And_Get
3035: (
3036: p_count => x_msg_count,
3037: p_data => x_msg_data,

Line 3038: p_encoded => FND_API.G_FALSE

3034: FND_MSG_PUB.Count_And_Get
3035: (
3036: p_count => x_msg_count,
3037: p_data => x_msg_data,
3038: p_encoded => FND_API.G_FALSE
3039: );
3040: IF l_debug_on THEN
3041: WSH_DEBUG_SV.pop(l_module_name);
3042: END IF;

Line 3045: x_return_status := FND_API.G_RET_STS_ERROR;

3041: WSH_DEBUG_SV.pop(l_module_name);
3042: END IF;
3043: WHEN OTHERS THEN
3044: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_SUPPLIER_INFO');
3045: x_return_status := FND_API.G_RET_STS_ERROR;
3046: FND_MSG_PUB.Count_And_Get
3047: (
3048: p_count => x_msg_count,
3049: p_data => x_msg_data,

Line 3050: p_encoded => FND_API.G_FALSE

3046: FND_MSG_PUB.Count_And_Get
3047: (
3048: p_count => x_msg_count,
3049: p_data => x_msg_data,
3050: p_encoded => FND_API.G_FALSE
3051: );
3052: IF l_debug_on THEN
3053: WSH_DEBUG_SV.pop(l_module_name);
3054: END IF;

Line 3161: RAISE FND_API.G_EXC_ERROR;

3157:
3158: IF ( (l_return_status = 'E')
3159: OR (l_return_status = 'U') )
3160: THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: END IF;
3163:
3164: SELECT shipments_type_flag INTO l_typeflag
3165: FROM WSH_TRIPS

Line 3241: WHEN FND_API.G_EXC_ERROR THEN

3237:
3238: --}
3239: EXCEPTION
3240: --{
3241: WHEN FND_API.G_EXC_ERROR THEN
3242: IF l_debug_on THEN
3243: WSH_DEBUG_SV.pop(l_module_name);
3244: END IF;
3245: return null;

Line 3247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3243: WSH_DEBUG_SV.pop(l_module_name);
3244: END IF;
3245: return null;
3246:
3247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3248: IF l_debug_on THEN
3249: WSH_DEBUG_SV.pop(l_module_name);
3250: END IF;
3251: return null;

Line 3369: WHEN FND_API.G_EXC_ERROR THEN

3365:
3366: --}
3367: EXCEPTION
3368: --{
3369: WHEN FND_API.G_EXC_ERROR THEN
3370: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3371: IF l_debug_on THEN
3372: WSH_DEBUG_SV.pop(l_module_name);
3373: END IF;

Line 3375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3371: IF l_debug_on THEN
3372: WSH_DEBUG_SV.pop(l_module_name);
3373: END IF;
3374:
3375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3377: IF l_debug_on THEN
3378: WSH_DEBUG_SV.pop(l_module_name);
3379: END IF;

Line 3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3372: WSH_DEBUG_SV.pop(l_module_name);
3373: END IF;
3374:
3375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3377: IF l_debug_on THEN
3378: WSH_DEBUG_SV.pop(l_module_name);
3379: END IF;
3380: WHEN OTHERS THEN