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

Line 286: x_trip_attrs_rec OUT NOCOPY wsh_trips_pvt.trip_rec_type

282: );
283:
284: PROCEDURE copy_trip_record(
285: p_plan_trip_rec IN plan_trip_rec_type,
286: x_trip_attrs_rec OUT NOCOPY wsh_trips_pvt.trip_rec_type
287: );
288:
289: PROCEDURE copy_stop_record(
290: p_plan_stop_rec IN plan_stop_rec_type,

Line 3516: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),

3512: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
3513: p_entity_interface_id => itrip.trip_interface_id,
3514: p_message_name => 'WSH_TP_F_TRIP_DIFF_ATTR',
3515: p_token_1_name => 'TRIP_NAME',
3516: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),
3517: x_errors_tab => x_errors_tab,
3518: x_return_status => l_return_status);
3519: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3520: IF l_debug_on THEN

Line 3545: wsh_trips_pvt.lock_trip_no_compare(

3541:
3542: IF x_plan_trips(l_new_index).trip_id IS NOT NULL THEN
3543: -- lock trip
3544: BEGIN
3545: wsh_trips_pvt.lock_trip_no_compare(
3546: p_trip_id => x_plan_trips(l_new_index).trip_id);
3547: EXCEPTION
3548: WHEN OTHERS THEN
3549: stamp_interface_error(

Line 3555: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),

3551: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
3552: p_entity_interface_id => itrip.trip_interface_id,
3553: p_message_name => 'WSH_TP_F_NO_LOCK_TRIP',
3554: p_token_1_name => 'TRIP_NAME',
3555: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),
3556: x_errors_tab => x_errors_tab,
3557: x_return_status => l_return_status);
3558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3559: IF l_debug_on THEN

Line 3684: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),

3680: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',
3681: p_entity_interface_id => istop.stop_interface_id,
3682: p_message_name => 'WSH_TP_F_NO_LOCK_STOP',
3683: p_token_1_name => 'TRIP_NAME',
3684: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),
3685: x_errors_tab => x_errors_tab,
3686: x_return_status => l_return_status);
3687: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3688: IF l_debug_on THEN

Line 3706: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),

3702: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
3703: p_entity_interface_id => x_plan_trips(l_new_index).trip_interface_id,
3704: p_message_name => 'WSH_TP_F_TRIP_FIRM_NO_STOP',
3705: p_token_1_name => 'TRIP_NAME',
3706: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),
3707: p_token_2_name => 'PLAN_TRIP_NUM',
3708: p_token_2_value => x_plan_trips(l_new_index).tp_trip_number,
3709: x_errors_tab => x_errors_tab,
3710: x_return_status => l_return_status);

Line 4076: wsh_trips_pvt.lock_trip_no_compare(

4072: x_plan_legs(l_new_index).delivery_leg_id := l_snapshot_leg_ids(l_used_index);
4073:
4074: -- lock the newly mapped trip and map the plan stops to the trip's existing stops.
4075: BEGIN
4076: wsh_trips_pvt.lock_trip_no_compare(
4077: p_trip_id => x_plan_trips(l_trip_index).trip_id);
4078: EXCEPTION
4079: WHEN OTHERS THEN
4080: stamp_interface_error(

Line 4086: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),

4082: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
4083: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
4084: p_message_name => 'WSH_TP_F_NO_LOCK_TRIP',
4085: p_token_1_name => 'TRIP_NAME',
4086: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),
4087: x_errors_tab => x_errors_tab,
4088: x_return_status => l_return_status);
4089: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4090: IF l_debug_on THEN

Line 4134: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),

4130: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',
4131: p_entity_interface_id => x_plan_stops(l_stop_index).stop_interface_id,
4132: p_message_name => 'WSH_TP_F_NO_LOCK_STOP',
4133: p_token_1_name => 'TRIP_NAME',
4134: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),
4135: p_token_2_name => 'STOP_SEQUENCE',
4136: p_token_2_value => x_plan_stops(l_stop_index).stop_sequence_number,
4137: x_errors_tab => x_errors_tab,
4138: x_return_status => l_return_status);

Line 4180: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),

4176: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
4177: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
4178: p_message_name => 'WSH_TP_F_TRIP_FIRM_NO_STOP',
4179: p_token_1_name => 'TRIP_NAME',
4180: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),
4181: x_errors_tab => x_errors_tab,
4182: x_return_status => l_return_status);
4183: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4184: IF l_debug_on THEN

Line 4721: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;

4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
4719: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
4720:
4721: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
4722: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
4723: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
4724: l_trip_defaults WSH_TRIPS_GRP.default_parameters_rectype;
4725: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

Line 6101: l_rf_trips WSH_TRIPS_PVT.trip_attr_tbl_type;

6097: END IF;
6098:
6099: DECLARE
6100: -- list of trips to become routing firmed.
6101: l_rf_trips WSH_TRIPS_PVT.trip_attr_tbl_type;
6102: -- list of trips to become routing and contents firmed.
6103: l_rcf_trips WSH_TRIPS_PVT.trip_attr_tbl_type;
6104: BEGIN --{
6105:

Line 6103: l_rcf_trips WSH_TRIPS_PVT.trip_attr_tbl_type;

6099: DECLARE
6100: -- list of trips to become routing firmed.
6101: l_rf_trips WSH_TRIPS_PVT.trip_attr_tbl_type;
6102: -- list of trips to become routing and contents firmed.
6103: l_rcf_trips WSH_TRIPS_PVT.trip_attr_tbl_type;
6104: BEGIN --{
6105:
6106: l_index := x_plan_trips.FIRST;
6107: WHILE l_index IS NOT NULL LOOP

Line 6736: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;

6732: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
6733: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
6734: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
6735:
6736: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
6737: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
6738: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
6739: l_trip_defaults WSH_TRIPS_GRP.default_parameters_rectype;
6740: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

Line 9030: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(i).trip_id),

9026: p_entity_table_name => 'WSH_TRIP_INTERFACE',
9027: p_entity_interface_id => x_plan_trips(i).trip_interface_id,
9028: p_message_name => 'WSH_TP_F_NO_LOCK_STOP',
9029: p_token_1_name => 'TRIP_NAME',
9030: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(i).trip_id),
9031: x_errors_tab => x_errors_tab,
9032: x_return_status => x_return_status);
9033: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9034: IF l_debug_on THEN

Line 9057: p_token_2_value => WSH_TRIPS_PVT.get_name(x_plan_trips(i).trip_id),

9053: p_message_name => 'WSH_TP_F_PLAN_TRIP_NOT_MATCH',
9054: p_token_1_name => 'PLAN_TRIP_NUM',
9055: p_token_1_value => x_plan_trips(i).tp_trip_number,
9056: p_token_2_name => 'TRIP_NAME',
9057: p_token_2_value => WSH_TRIPS_PVT.get_name(x_plan_trips(i).trip_id),
9058: x_errors_tab => x_errors_tab,
9059: x_return_status => x_return_status);
9060:
9061: RAISE WSH_PLANNED_TRIP_NOT_MATCH;

Line 9077: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(i).trip_id),

9073: p_entity_table_name => 'WSH_TRIP_INTERFACE',
9074: p_entity_interface_id => x_plan_trips(i).trip_interface_id,
9075: p_message_name => 'WSH_TP_F_NO_LOCK_STOP_UNASSIGN',
9076: p_token_1_name => 'TRIP_NAME',
9077: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(i).trip_id),
9078: x_errors_tab => x_errors_tab,
9079: x_return_status => x_return_status);
9080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9081: IF l_debug_on THEN

Line 9897: x_trip_attrs_rec OUT NOCOPY wsh_trips_pvt.trip_rec_type

9893: -- transforms plan data structure into group api data structure for trip.
9894: --
9895: PROCEDURE copy_trip_record(
9896: p_plan_trip_rec IN plan_trip_rec_type,
9897: x_trip_attrs_rec OUT NOCOPY wsh_trips_pvt.trip_rec_type
9898: ) IS
9899: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'COPY_TRIP_RECORD';
9900: --
9901: l_debug_on BOOLEAN;

Line 10178: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;

10174: l_msg_count NUMBER;
10175: l_interface_entity WSH_INTERFACE_ERRORS.INTERFACE_TABLE_NAME%TYPE;
10176: l_interface_id NUMBER;
10177: --
10178: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
10179: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
10180: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
10181: l_trip_defaults WSH_TRIPS_GRP.default_parameters_rectype;
10182: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;