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 846: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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

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

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

Line 921: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

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

Line 1207: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

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

Line 1526: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

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

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

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

Line 2551: l_trip_info WSH_TRIPS_PVT.TRIP_REC_TYPE;

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

Line 2561: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

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

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

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

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

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

Line 3155: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

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

Line 4796: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

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

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

5661: --
5662: -- Debug Statements
5663: --
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5666: END IF;
5667: --
5668: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5666: END IF;
5667: --
5668: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5670: wsh_util_core.add_message(x_return_status);
5671: goto wt_vol_error;
5672: END IF;

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

5685: --
5686: -- Debug Statements
5687: --
5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5690: END IF;
5691: --
5692: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5690: END IF;
5691: --
5692: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5694: wsh_util_core.add_message(x_return_status);
5695: goto wt_vol_error;
5696: END IF;

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

6240: --
6241: -- Debug Statements
6242: --
6243: IF l_debug_on THEN
6244: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6245: END IF;
6246: --
6247: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
6248: wsh_util_core.add_message(x_return_status);

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

6243: IF l_debug_on THEN
6244: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6245: END IF;
6246: --
6247: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
6248: wsh_util_core.add_message(x_return_status);
6249: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6250: l_num_error := l_num_error + 1;
6251: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

6274: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
6275: -- Bug 3688384 Display separate message for one trip .
6276: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6277: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6278: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6279: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6280: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6282: ELSIF (p_trip_rows.count > 1) then

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

6277: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6278: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6279: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6280: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6282: ELSIF (p_trip_rows.count > 1) then
6283: -- Bug 3688384 .
6284: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6285: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);

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

6414: --
6415: -- Debug Statements
6416: --
6417: IF l_debug_on THEN
6418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6419: END IF;
6420: --
6421: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
6422: wsh_util_core.add_message(x_return_status);

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

6417: IF l_debug_on THEN
6418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6419: END IF;
6420: --
6421: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
6422: wsh_util_core.add_message(x_return_status);
6423: --
6424: -- Debug Statements
6425: --

Line 6811: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

6807: p_fill_percent IN NUMBER,
6808: x_return_status OUT NOCOPY VARCHAR2) IS
6809:
6810: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
6811: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
6812: l_return_status VARCHAR2(1);
6813:
6814: l_debug_on BOOLEAN;
6815: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'FTE_LOAD_TENDER';

Line 8233: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

8229: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8230: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8231:
8232: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8233: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8234: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
8235:
8236: l_msg_count NUMBER;
8237: l_msg_data VARCHAR2(2000);

Line 8664: WSH_TRIPS_PVT.populate_record(

8660: l_trip_in_rec.caller := 'FTE_ROUTING_GUIDE';
8661: l_trip_in_rec.phase := null;
8662: l_trip_in_rec.action_code := 'UPDATE';
8663:
8664: WSH_TRIPS_PVT.populate_record(
8665: p_trip_id => l_trip_id,
8666: x_trip_info => l_trip_info_tab(1),
8667: x_return_status => l_return_status);
8668: