DBA Data[Home] [Help]

APPS.FTE_WSH_INTERFACE_PKG dependencies on FTE_WSH_INTERFACE_PKG

Line 1: PACKAGE BODY FTE_WSH_INTERFACE_PKG AS

1: PACKAGE BODY FTE_WSH_INTERFACE_PKG AS
2: /* $Header: FTEWSHIB.pls 120.5 2005/07/28 17:07:24 nltan ship $ */
3: --{
4: G_PREVIOUS CONSTANT VARCHAR2(30) := 'PREVIOUS';
5: G_NEXT CONSTANT VARCHAR2(30) := 'NEXT';

Line 197: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_SEGMENT_STOPS');

193: --}
194: EXCEPTION
195: --{
196: WHEN OTHERS THEN
197: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_SEGMENT_STOPS');
198: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
199: --}
200: END get_segment_stops;
201: --

Line 473: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_FIRST_STOP');

469: --}
470: EXCEPTION
471: --{
472: WHEN OTHERS THEN
473: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_FIRST_STOP');
474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
475: --}
476: END validate_first_stop;
477: --

Line 748: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_LAST_STOP');

744: --}
745: EXCEPTION
746: --{
747: WHEN OTHERS THEN
748: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_LAST_STOP');
749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
750: --}
751: END validate_last_stop;
752: --

Line 939: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_INTERMEDIATE_STOP');

935: --}
936: EXCEPTION
937: --{
938: WHEN OTHERS THEN
939: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_INTERMEDIATE_STOP');
940: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
941: --}
942: END validate_intermediate_stop;
943: --

Line 1019: p_api_name => 'FTE_WSH_INTERFACE_PKG.Validate_first_stop',

1015: --
1016: --
1017: FTE_MLS_UTIL.api_post_call
1018: (
1019: p_api_name => 'FTE_WSH_INTERFACE_PKG.Validate_first_stop',
1020: p_api_return_status => l_return_status,
1021: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1022: p_trip_segment_id => p_trip_segment_rec.trip_id,
1023: p_trip_segment_name => p_trip_segment_rec.name,

Line 1061: p_api_name => 'FTE_WSH_INTERFACE_PKG.Validate_last_stop',

1057: --
1058: --
1059: FTE_MLS_UTIL.api_post_call
1060: (
1061: p_api_name => 'FTE_WSH_INTERFACE_PKG.Validate_last_stop',
1062: p_api_return_status => l_return_status,
1063: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1064: p_trip_segment_id => p_trip_segment_rec.trip_id,
1065: p_trip_segment_name => p_trip_segment_rec.name,

Line 1100: p_api_name => 'FTE_WSH_INTERFACE_PKG.Validate_intermediate_stop',

1096: --
1097: --
1098: FTE_MLS_UTIL.api_post_call
1099: (
1100: p_api_name => 'FTE_WSH_INTERFACE_PKG.Validate_intermediate_stop',
1101: p_api_return_status => l_return_status,
1102: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1103: p_trip_segment_id => p_trip_segment_rec.trip_id,
1104: p_trip_segment_name => p_trip_segment_rec.name,

Line 1136: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD');

1132: --}
1133: EXCEPTION
1134: --{
1135: WHEN OTHERS THEN
1136: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD');
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138: --}
1139: END validate_stop_add;
1140: --

Line 1263: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',

1259: --
1260: --
1261: FTE_MLS_UTIL.api_post_call
1262: (
1263: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',
1264: p_api_return_status => l_return_status,
1265: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1266: p_trip_segment_id => p_trip_segment_rec.trip_id,
1267: p_trip_segment_name => p_trip_segment_rec.name,

Line 1320: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',

1316: --
1317: --
1318: FTE_MLS_UTIL.api_post_call
1319: (
1320: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',
1321: p_api_return_status => l_return_status,
1322: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1323: p_trip_segment_id => p_trip_segment_rec.trip_id,
1324: p_trip_segment_name => p_trip_segment_rec.name,

Line 1374: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',

1370: --
1371: --
1372: FTE_MLS_UTIL.api_post_call
1373: (
1374: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',
1375: p_api_return_status => l_return_status,
1376: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1377: p_trip_segment_id => p_trip_segment_rec.trip_id,
1378: p_trip_segment_name => p_trip_segment_rec.name,

Line 1416: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',

1412: --
1413: --
1414: FTE_MLS_UTIL.api_post_call
1415: (
1416: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',
1417: p_api_return_status => l_return_status,
1418: p_message_name => 'FTE_STOP_REPRICING_UNEXP_ERROR',
1419: p_trip_segment_id => p_trip_segment_rec.trip_id,
1420: p_trip_segment_name => p_trip_segment_rec.name,

Line 1454: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',

1450: --
1451: --
1452: FTE_MLS_UTIL.api_post_call
1453: (
1454: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',
1455: p_api_return_status => l_return_status,
1456: p_message_name => 'FTE_TRIP_SEG_STOP_UNEXP_ERROR',
1457: p_trip_segment_id => p_trip_segment_rec.trip_id,
1458: p_trip_segment_name => p_trip_segment_rec.name,

Line 1495: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE');

1491: --}
1492: EXCEPTION
1493: --{
1494: WHEN OTHERS THEN
1495: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE');
1496: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1497: --}
1498: END validate_stop_update;
1499: --

Line 1785: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',

1781: THEN
1782: --{
1783: FTE_MLS_UTIL.api_post_call
1784: (
1785: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',
1786: p_api_return_status => l_return_status,
1787: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1788: p_trip_segment_id => p_trip_segment_rec.trip_id,
1789: p_trip_segment_name => p_trip_segment_rec.name,

Line 1821: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_DELETE');

1817: --}
1818: EXCEPTION
1819: --{
1820: WHEN OTHERS THEN
1821: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_DELETE');
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1823: --}
1824: END validate_stop_delete;
1825: --

Line 1887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_WSH_INTERFACE_PKG' || '.' || 'segment_stop_change';

1883: l_number_of_warnings NUMBER := 0;
1884: --
1885: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1886:
1887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_WSH_INTERFACE_PKG' || '.' || 'segment_stop_change';
1888:
1889: --
1890: --}
1891: BEGIN

Line 1972: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',

1968: --
1969: --
1970: FTE_MLS_UTIL.api_post_call
1971: (
1972: p_api_name => 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD',
1973: p_api_return_status => l_return_status,
1974: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
1975: p_trip_segment_id => p_trip_segment_rec.trip_id,
1976: p_trip_segment_name => p_trip_segment_rec.name,

Line 2008: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD';

2004: WSH_DEBUG_SV.logmsg(l_module_name,'Adding Stop',
2005: WSH_DEBUG_SV.C_PROC_LEVEL);
2006: END IF;
2007:
2008: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD';
2009: --
2010: --
2011: l_stop_full_valid_ctrl_rec := get_stop_full_validn_ctrl_rec;
2012: --

Line 2069: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE';

2065: --}
2066: ELSIF p_action_type = G_UPDATE
2067: THEN
2068: --{
2069: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE';
2070:
2071: IF l_debug_on THEN
2072:
2073: WSH_DEBUG_SV.logmsg(l_module_name,'Updating Stop',

Line 2143: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_DELETE';

2139: --}
2140: ELSIF p_action_type = G_DELETE
2141: THEN
2142: --{
2143: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_DELETE';
2144: --
2145: --
2146: validate_stop_delete
2147: (

Line 2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');

2261: wsh_debug_sv.log (l_module_name,' Unexpected error ');
2262: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2263: WSH_DEBUG_SV.pop(l_module_name);
2264: END IF;
2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2267: --
2268: --
2269: FND_MSG_PUB.Count_And_Get

Line 2510: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_UPDATE');

2506: --}
2507: EXCEPTION
2508: --{
2509: WHEN OTHERS THEN
2510: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_UPDATE');
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2512: --}
2513: END validate_segment_update;
2514: --

Line 2645: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_DELETE');

2641: --}
2642: EXCEPTION
2643: --{
2644: WHEN OTHERS THEN
2645: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_DELETE');
2646: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2647: --}
2648: END validate_segment_delete;
2649: --

Line 2731: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_UPDATE';

2727: --}
2728: ELSIF p_action_type = G_UPDATE
2729: THEN
2730: --{
2731: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_UPDATE';
2732: --
2733: --
2734: validate_segment_update
2735: (

Line 2744: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_DELETE';

2740: --}
2741: ELSIF p_action_type = G_DELETE
2742: THEN
2743: --{
2744: l_program_name := 'FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_DELETE';
2745: --
2746: --
2747: validate_segment_delete
2748: (

Line 2849: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE');

2845: );
2846: WHEN OTHERS THEN
2847: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2849: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE');
2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2851: --
2852: --
2853: FND_MSG_PUB.Count_And_Get

Line 3082: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_TRIP_ORG_ORGANIZATION');

3078: IF l_debug_on THEN
3079: WSH_DEBUG_SV.pop(l_module_name);
3080: END IF;
3081: WHEN OTHERS THEN
3082: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_TRIP_ORG_ORGANIZATION');
3083: x_return_status := FND_API.G_RET_STS_ERROR;
3084: FND_MSG_PUB.Count_And_Get
3085: (
3086: p_count => x_msg_count,

Line 3098: END FTE_WSH_INTERFACE_PKG;

3094: END GET_ORG_ORGANIZATION_INFO;
3095:
3096: --}
3097:
3098: END FTE_WSH_INTERFACE_PKG;