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_GRP dependencies on WSH_TRIPS_PVT

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

153: WHEN trip_action_error THEN
154: FND_MESSAGE.SET_NAME('WSH','WSH_OI_TRIP_ACTION_ERROR');
155: --
156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
158: END IF;
159: --
160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));

Line 160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
158: END IF;
159: --
160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));
162: wsh_util_core.add_message(x_return_status);
163:
164: IF l_debug_on THEN

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

348: --
349: -- Debug Statements
350: --
351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
353: END IF;
354: --
355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
356: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));

Line 355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
353: END IF;
354: --
355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
356: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));
357: wsh_util_core.add_message(x_return_status);
358:
359: --

Line 433: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

429: ( p_api_version_number IN NUMBER,
430: p_init_msg_list IN VARCHAR2,
431: p_commit IN VARCHAR2,
432: p_action_prms IN action_parameters_rectype,
433: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
434: x_trip_out_rec OUT NOCOPY tripActionOutRecType,
435: x_def_rec OUT NOCOPY default_parameters_rectype,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,

Line 447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

443: l_valid_id_tab wsh_util_core.id_tab_type;
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
446: l_error_ids wsh_util_core.id_tab_type;
447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
448: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
449: l_dummy_doc_param WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
450: l_api_version_number CONSTANT NUMBER := 1.0;
451: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';

Line 475: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

471: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
472: l_msg_count NUMBER;
473: l_msg_data VARCHAR2(2000);
474:
475: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
476: l_trip_id_tab_temp wsh_util_core.id_tab_type;
477: l_cc_count_success NUMBER;
478: b_cc_linefailed BOOLEAN;
479:

Line 483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

479:
480: --dummy tables for calling validate_constraint_wrapper
481: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
482: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
484: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
485: l_cc_in_ids wsh_util_core.id_tab_type;
486: l_cc_fail_ids wsh_util_core.id_tab_type;
487:

Line 708: WSH_TRIPS_PVT.lock_trip(p_rec_attr_tab => p_rec_attr_tab,

704: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN
705: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
706: AND p_action_prms.action_code = 'DELETE'
707: ) THEN --BUG 4354579
708: WSH_TRIPS_PVT.lock_trip(p_rec_attr_tab => p_rec_attr_tab,
709: p_caller => p_action_prms.caller,
710: p_valid_index_tab => l_valid_index_tab,
711: x_valid_ids_tab => x_trip_out_rec.valid_ids_tab,
712: x_return_status => l_return_status);

Line 1726: x_pvt_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,

1722:
1723: --Harmonization Project **heali
1724: PROCEDURE map_tripgrp_to_pvt(
1725: p_grp_trip_rec IN TRIP_PUB_REC_TYPE,
1726: x_pvt_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,
1727: x_return_status OUT NOCOPY VARCHAR2) IS
1728:
1729: l_debug_on BOOLEAN;
1730: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'MAP_TRIPPUB_TO_GRP';

Line 1820: (p_trip_info_tab IN OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

1816: --
1817: END map_tripgrp_to_pvt;
1818:
1819: PROCEDURE Validate_Trip
1820: (p_trip_info_tab IN OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
1821: p_action_code IN VARCHAR2,
1822: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
1823: x_return_status OUT NOCOPY VARCHAR2,
1824: p_caller IN VARCHAR2 DEFAULT NULL) IS

Line 1834: l_db_trip_info WSH_TRIPS_PVT.trip_rec_type;

1830: SELECT consolidation_allowed, vehicle_item_id, vehicle_organization_id, ship_method_code, carrier_id, service_level, mode_of_transport, lane_id
1831: FROM wsh_trips
1832: WHERE trip_id= p_trip_id;
1833:
1834: l_db_trip_info WSH_TRIPS_PVT.trip_rec_type;
1835:
1836: l_ship_method_code varchar2(32764);
1837: l_num_errors NUMBER := 0;
1838: l_num_warnings NUMBER := 0;

Line 2373: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

2369: PROCEDURE Create_Update_Trip(
2370: p_api_version_number IN NUMBER,
2371: p_init_msg_list IN VARCHAR2,
2372: p_commit IN VARCHAR2,
2373: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
2374: p_In_rec IN tripInRecType,
2375: x_Out_Tab OUT NOCOPY trip_Out_Tab_Type,
2376: x_return_status OUT NOCOPY VARCHAR2,
2377: x_msg_count OUT NOCOPY NUMBER,

Line 2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2391: l_sp_disabled_list VARCHAR2(30) := 'get_disabled_list';
2392: l_return_status VARCHAR2(1);
2393:
2394: x_valid_index_tab wsh_util_core.id_tab_type;
2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2398:
2399: --Compatibility Changes

Line 2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2392: l_return_status VARCHAR2(1);
2393:
2394: x_valid_index_tab wsh_util_core.id_tab_type;
2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2398:
2399: --Compatibility Changes
2400: l_cc_validate_result VARCHAR2(1);

Line 2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

2393:
2394: x_valid_index_tab wsh_util_core.id_tab_type;
2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2398:
2399: --Compatibility Changes
2400: l_cc_validate_result VARCHAR2(1);
2401: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;

Line 2407: l_trip_info_tab_temp WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2403: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
2404: l_msg_count NUMBER;
2405: l_msg_data VARCHAR2(2000);
2406:
2407: l_trip_info_tab_temp WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2408: l_cc_count_success NUMBER;
2409: b_cc_linefailed BOOLEAN;
2410:
2411: --dummy tables for calling validate_constraint_wrapper

Line 2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2410:
2411: --dummy tables for calling validate_constraint_wrapper
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;
2418:

Line 2672: WSH_TRIPS_PVT.CREATE_TRIP (

2668: WHILE l_index IS NOT NULL LOOP
2669: BEGIN
2670: SAVEPOINT l_trip;
2671: IF (p_in_rec.action_code = 'CREATE' ) THEN
2672: WSH_TRIPS_PVT.CREATE_TRIP (
2673: p_trip_info => l_trip_info_tab(x_valid_index_tab(l_index)),
2674: x_rowid => x_out_Tab(l_index).rowid,
2675: x_trip_id => x_out_Tab(l_index).trip_id,
2676: x_name => x_out_Tab(l_index).trip_name,

Line 2698: WSH_TRIPS_PVT.UPDATE_TRIP(

2694: FROM WSH_TRIPS
2695: WHERE ROWID = l_trip_info_tab(x_valid_index_tab(l_index)).rowid;
2696: END IF;
2697:
2698: WSH_TRIPS_PVT.UPDATE_TRIP(
2699: p_rowid => l_trip_info_tab(x_valid_index_tab(l_index)).rowid,
2700: p_trip_info => l_trip_info_tab(x_valid_index_tab(l_index)),
2701: x_return_status => l_return_status);
2702:

Line 2976: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

2972: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP_NEW';
2973:
2974: l_num_errors NUMBER;
2975: l_num_warnings NUMBER;
2976: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2977: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2978: l_out_tab trip_out_tab_type;
2979: l_commit VARCHAR2(1):='F';
2980: BEGIN

Line 2977: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2973:
2974: l_num_errors NUMBER;
2975: l_num_warnings NUMBER;
2976: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2977: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2978: l_out_tab trip_out_tab_type;
2979: l_commit VARCHAR2(1):='F';
2980: BEGIN
2981: -- Standard call to check for call compatibility

Line 3128: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

3124: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP';
3125:
3126: l_num_errors NUMBER;
3127: l_num_warnings NUMBER;
3128: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
3129: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3130: l_out_tab trip_out_tab_type;
3131: l_in_rec TripInRecType;
3132: l_commit VARCHAR2(1):='F';

Line 3129: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

3125:
3126: l_num_errors NUMBER;
3127: l_num_warnings NUMBER;
3128: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
3129: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3130: l_out_tab trip_out_tab_type;
3131: l_in_rec TripInRecType;
3132: l_commit VARCHAR2(1):='F';
3133: BEGIN

Line 3252: x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,

3248:
3249: -- API to get Trip Details
3250: PROCEDURE get_trip_details_pvt
3251: (p_trip_id IN NUMBER,
3252: x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,
3253: x_return_status OUT NOCOPY VARCHAR2) IS
3254:
3255: CURSOR c_old_trip_details(v_trip_id IN NUMBER) IS
3256: SELECT TRIP_ID,

Line 3312: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;

3308: OPERATOR
3309: FROM wsh_trips
3310: WHERE trip_id = v_trip_id;
3311:
3312: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;
3313:
3314: --
3315: l_debug_on BOOLEAN;
3316: --