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.WSH_TRIPS_ACTIONS dependencies on WSH_TRIPS_PVT

Line 844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

840: --
841: -- Debug Statements
842: --
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
845: END IF;
846: --
847: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
848: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 847: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

843: IF l_debug_on THEN
844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
845: END IF;
846: --
847: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
848: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
849: wsh_util_core.add_message(x_return_status);
850: l_num_error := l_num_error + 1;
851:

Line 919: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

915: i BINARY_INTEGER;
916: /* H integration for Multi Leg */
917: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
918: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
919: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
920: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
921: l_return_status VARCHAR2(30);
922: l_num_warn NUMBER := 0;
923:

Line 1205: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

1201:
1202:
1203: /* H integration for Multi Leg */
1204: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
1205: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
1206: --
1207: --
1208: l_num_warnings NUMBER;
1209: l_num_errors NUMBER;

Line 1524: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

1520: --========================================================================
1521: PROCEDURE generateRoutingResponse
1522: (
1523: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1524: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
1525: x_return_status OUT NOCOPY VARCHAR2
1526: )
1527: IS
1528: --{

Line 1665: FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name, wsh_trips_pvt.get_name( p_rec_attr_tab(l_index).trip_id)));

1661: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');
1662: ELSE
1663: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1664: --FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name,p_rec_attr_tab(l_index).trip_id));
1665: FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name, wsh_trips_pvt.get_name( p_rec_attr_tab(l_index).trip_id)));
1666: END IF;
1667: --
1668: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning,l_module_name);
1669: l_num_warnings := NVL(l_num_warnings,0) + 1;

Line 2549: l_trip_info WSH_TRIPS_PVT.TRIP_REC_TYPE;

2545:
2546: l_ship_method_flag BOOLEAN := TRUE;
2547:
2548: l_rowid VARCHAR2(30);
2549: l_trip_info WSH_TRIPS_PVT.TRIP_REC_TYPE;
2550: assigned_del_error EXCEPTION;
2551: l_return_status VARCHAR2(1);
2552: l_del_legs WSH_UTIL_CORE.ID_TAB_TYPE;
2553: l_good_dels WSH_UTIL_CORE.ID_TAB_TYPE;

Line 2559: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

2555: /* H integration for Multi Leg */
2556: l_num_warn NUMBER := 0;
2557: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
2558: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
2559: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2560: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
2561: l_grp_trip_rec WSH_TRIPS_GRP.TRIP_PUB_REC_TYPE;
2562: --l_return_status VARCHAR2(30);
2563: l_fte_flag VARCHAR2(1):= 'N';

Line 2778: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.CREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

2774: /* H integration */
2775: /* The trip level call should have been made at parent level */
2776: --
2777: IF l_debug_on THEN
2778: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.CREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
2779: END IF;
2780: --
2781: wsh_trips_pvt.create_trip(l_trip_info, l_rowid, x_trip_id, x_trip_name,x_return_status);
2782: --

Line 2781: wsh_trips_pvt.create_trip(l_trip_info, l_rowid, x_trip_id, x_trip_name,x_return_status);

2777: IF l_debug_on THEN
2778: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.CREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
2779: END IF;
2780: --
2781: wsh_trips_pvt.create_trip(l_trip_info, l_rowid, x_trip_id, x_trip_name,x_return_status);
2782: --
2783: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2784: --
2785: IF l_debug_on THEN

Line 3153: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

3149: l_msg_data VARCHAR2(2000);
3150: --dummy tables for calling validate_constraint_mainper
3151: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
3152: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3153: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3154: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3155: l_cc_in_ids wsh_util_core.id_tab_type;
3156: l_cc_fail_ids wsh_util_core.id_tab_type;
3157:

Line 4794: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

4790: others EXCEPTION;
4791: /* H integration for Multi Leg */
4792: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
4793: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
4794: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
4795: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
4796: l_num_warn NUMBER := 0;
4797: l_num_err NUMBER := 0;
4798: --l_return_status VARCHAR2(30);

Line 5659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

5655: --
5656: -- Debug Statements
5657: --
5658: IF l_debug_on THEN
5659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5660: END IF;
5661: --
5662: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5663: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 5662: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

5658: IF l_debug_on THEN
5659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5660: END IF;
5661: --
5662: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5663: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5664: wsh_util_core.add_message(x_return_status);
5665: goto wt_vol_error;
5666: END IF;

Line 5683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

5679: --
5680: -- Debug Statements
5681: --
5682: IF l_debug_on THEN
5683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5684: END IF;
5685: --
5686: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5687: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 5686: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

5682: IF l_debug_on THEN
5683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5684: END IF;
5685: --
5686: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5687: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5688: wsh_util_core.add_message(x_return_status);
5689: goto wt_vol_error;
5690: END IF;

Line 6233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

6229: --
6230: -- Debug Statements
6231: --
6232: IF l_debug_on THEN
6233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6234: END IF;
6235: --
6236: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
6237: wsh_util_core.add_message(x_return_status);

Line 6236: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

6232: IF l_debug_on THEN
6233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6234: END IF;
6235: --
6236: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
6237: wsh_util_core.add_message(x_return_status);
6238: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6239: l_num_error := l_num_error + 1;
6240: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));

6263: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
6264: -- Bug 3688384 Display separate message for one trip .
6265: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6266: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6268: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6271: ELSIF (p_trip_rows.count > 1) then

Line 6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));

6266: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6268: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6271: ELSIF (p_trip_rows.count > 1) then
6272: -- Bug 3688384 .
6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6274: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);

Line 6407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

6403: --
6404: -- Debug Statements
6405: --
6406: IF l_debug_on THEN
6407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6408: END IF;
6409: --
6410: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
6411: wsh_util_core.add_message(x_return_status);

Line 6410: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

6406: IF l_debug_on THEN
6407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6408: END IF;
6409: --
6410: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
6411: wsh_util_core.add_message(x_return_status);
6412: --
6413: -- Debug Statements
6414: --

Line 6800: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

6796: p_fill_percent IN NUMBER,
6797: x_return_status OUT NOCOPY VARCHAR2) IS
6798:
6799: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
6800: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
6801: l_return_status VARCHAR2(1);
6802:
6803: l_debug_on BOOLEAN;
6804: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'FTE_LOAD_TENDER';

Line 8222: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

8218: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8219: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8220:
8221: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8222: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8223: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
8224:
8225: l_msg_count NUMBER;
8226: l_msg_data VARCHAR2(2000);

Line 8653: WSH_TRIPS_PVT.populate_record(

8649: l_trip_in_rec.caller := 'FTE_ROUTING_GUIDE';
8650: l_trip_in_rec.phase := null;
8651: l_trip_in_rec.action_code := 'UPDATE';
8652:
8653: WSH_TRIPS_PVT.populate_record(
8654: p_trip_id => l_trip_id,
8655: x_trip_info => l_trip_info_tab(1),
8656: x_return_status => l_return_status);
8657: