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

Line 10: TYPE planned_flag_tab_type IS TABLE OF WSH_TRIPS.PLANNED_FLAG%TYPE INDEX BY BINARY_INTEGER;

6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TP_RELEASE_INT';
7:
8:
9: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
10: TYPE planned_flag_tab_type IS TABLE OF WSH_TRIPS.PLANNED_FLAG%TYPE INDEX BY BINARY_INTEGER;
11:
12:
13: -- This cursor c_map_lines is used by generate_lock_candidates
14: -- It needs to be internally global because of reference

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 323: -- WSH_TRIPS_INTERFACE records and

319: --
320: -- Procedure: release_plan
321: -- Parameters:
322: -- p_group_ids list of group_ids to process their
323: -- WSH_TRIPS_INTERFACE records and
324: -- their associated tables' records.
325: -- p_commit_flag FND_API.G_TRUE - commit changes; FND_API.G_FALSE - do not commit
326: -- x_return_status return status
327: -- success means all groups have been released.

Line 654: -- WSH_TRIPS_INTERFACE records and

650: --
651: -- Procedure: purge_interface_tables
652: -- Parameters:
653: -- p_group_ids list of group_ids to purge their
654: -- WSH_TRIPS_INTERFACE records and
655: -- their associated tables' records.
656: -- WSH_INTERFACE_ERRORS will be purged.
657: -- p_commit_flag FND_API.G_TRUE - commit changes; FND_API.G_FALSE - do not commit
658: -- x_return_status return status

Line 694: from wsh_trips_interface wti,

690: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
691: delete from wsh_del_details_interface wddi
692: where wddi.delivery_detail_interface_id in (
693: select wdai.delivery_detail_interface_id
694: from wsh_trips_interface wti,
695: wsh_trip_stops_interface wtsi,
696: wsh_del_legs_interface wdli,
697: wsh_del_assgn_interface wdai
698: where wti.group_id = p_group_ids(i)

Line 715: from wsh_trips_interface wti,

711: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
712: delete from wsh_del_assgn_interface wdai
713: where wdai.delivery_interface_id in (
714: select wdli.delivery_interface_id
715: from wsh_trips_interface wti,
716: wsh_trip_stops_interface wtsi,
717: wsh_del_legs_interface wdli
718: where wti.group_id = p_group_ids(i)
719: and wti.trip_interface_id = wtsi.trip_interface_id

Line 733: from wsh_trips_interface wti,

729: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
730: delete from wsh_new_del_interface wndi
731: where wndi.delivery_interface_id in (
732: select wdli.delivery_interface_id
733: from wsh_trips_interface wti,
734: wsh_trip_stops_interface wtsi,
735: wsh_del_legs_interface wdli
736: where wti.group_id = p_group_ids(i)
737: and wti.trip_interface_id = wtsi.trip_interface_id

Line 750: from wsh_trips_interface wti,

746: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
747: delete from wsh_del_legs_interface wdli
748: where wdli.pick_up_stop_interface_id in (
749: select wtsi.stop_interface_id
750: from wsh_trips_interface wti,
751: wsh_trip_stops_interface wtsi
752: where wti.group_id = p_group_ids(i)
753: and wti.trip_interface_id = wtsi.trip_interface_id
754: and wti.interface_action_code = G_TP_RELEASE_CODE

Line 764: from wsh_trips_interface wti

760: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
761: delete from wsh_trip_stops_interface wtsi
762: where wtsi.trip_interface_id in (
763: select wtsi.stop_interface_id
764: from wsh_trips_interface wti
765: where wti.group_id = p_group_ids(i)
766: and wti.interface_action_code = G_TP_RELEASE_CODE)
767: and wtsi.interface_action_code = G_TP_RELEASE_CODE;
768:

Line 786: -- Purge wsh_trips_interface

782: RETURN;
783: END IF;
784:
785:
786: -- Purge wsh_trips_interface
787: -- (Trips have to be the last entity interface table purged
788: -- because this is the only entity interface table having GROUP_ID.)
789:
790: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST

Line 791: delete from wsh_trips_interface wti

787: -- (Trips have to be the last entity interface table purged
788: -- because this is the only entity interface table having GROUP_ID.)
789:
790: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
791: delete from wsh_trips_interface wti
792: where wti.group_id = p_group_ids(i)
793: and wti.INTERFACE_ACTION_CODE = G_TP_RELEASE_CODE;
794:
795:

Line 993: from wsh_trips_interface wti,

989: wddi.source_header_id,
990: wddi.source_line_id,
991: wddi.source_line_set_id,
992: wndi.tp_delivery_number
993: from wsh_trips_interface wti,
994: wsh_trip_stops_interface wtsi,
995: wsh_del_legs_interface wdli,
996: wsh_del_assgn_interface wdai,
997: wsh_del_details_interface wddi,

Line 1124: from wsh_trips_interface wti,

1120: -- this cursor checks for existence of interface (dangling) containers
1121: -- Bug 4274651: It also checks for existence of cancelled lines.
1122: cursor c_tp_dangling_conts (p_group_id in number) is
1123: select wddi.delivery_detail_id
1124: from wsh_trips_interface wti,
1125: wsh_trip_stops_interface wtsi,
1126: wsh_del_legs_interface wdli,
1127: wsh_del_assgn_interface wdai,
1128: wsh_del_details_interface wddi,

Line 1591: FROM wsh_trips_interface wti,

1587: wddi.src_requested_quantity,
1588: wddi.src_requested_quantity_uom,
1589: wndi.delivery_id,
1590: wndi.delivery_interface_id
1591: FROM wsh_trips_interface wti,
1592: wsh_trip_stops_interface wtsi,
1593: wsh_del_legs_interface wdli,
1594: wsh_new_del_interface wndi,
1595: wsh_del_assgn_interface wdai,

Line 1684: FROM wsh_trips_interface wti,

1680: wndi.volume_uom_code,
1681: wndi.pooled_ship_to_location_id,
1682: wndi.dock_code,
1683: wnd.wv_frozen_flag -- WV changes
1684: FROM wsh_trips_interface wti,
1685: wsh_trip_stops_interface wtsi,
1686: wsh_del_legs_interface wdli,
1687: wsh_new_del_interface wndi,
1688: wsh_new_deliveries wnd

Line 1747: FROM wsh_trips_interface wti,

1743: wti.shipper_wait_time,
1744: wti.wait_time_uom,
1745: wti.carrier_response,
1746: wti.operator
1747: FROM wsh_trips_interface wti,
1748: wsh_trips wt
1749: WHERE wti.group_id = p_group_id
1750: AND wti.interface_action_code = G_TP_RELEASE_CODE
1751: AND wt.trip_id(+) = wti.trip_id

Line 1748: wsh_trips wt

1744: wti.wait_time_uom,
1745: wti.carrier_response,
1746: wti.operator
1747: FROM wsh_trips_interface wti,
1748: wsh_trips wt
1749: WHERE wti.group_id = p_group_id
1750: AND wti.interface_action_code = G_TP_RELEASE_CODE
1751: AND wt.trip_id(+) = wti.trip_id
1752: ORDER BY wti.trip_interface_id

Line 1839: wsh_trips wt

1835: wts_do.wv_frozen_flag do_wv_flag
1836: FROM wsh_delivery_legs wdl,
1837: wsh_trip_stops wts_pu,
1838: wsh_trip_stops wts_do,
1839: wsh_trips wt
1840: WHERE wdl.delivery_id = p_delivery_id
1841: AND wts_pu.stop_id = wdl.pick_up_stop_id
1842: AND wts_do.stop_id = wdl.drop_off_stop_id
1843: AND wt.trip_id = wts_pu.trip_id

Line 3512: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

3508: <> NVL(itrip.vehicle_item_id, FND_API.G_MISS_NUM))
3509: ) THEN
3510: stamp_interface_error(
3511: p_group_id => x_context.group_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),

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 3551: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

3547: EXCEPTION
3548: WHEN OTHERS THEN
3549: stamp_interface_error(
3550: p_group_id => x_context.group_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),

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 3596: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

3592: WSH_UTIL_CORE.G_RET_STS_ERROR,
3593: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3594: stamp_interface_error(
3595: p_group_id => x_context.group_id,
3596: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
3597: p_entity_interface_id => itrip.trip_interface_id,
3598: p_message_name => 'WSH_TP_F_INVALID_FC',
3599: p_token_1_name => 'PLAN_TRIP_NUM',
3600: p_token_1_value => itrip.tp_trip_number,

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 3702: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

3698: -- if wsh trip is firmed and plan does not find matching stop, fail plan
3699: IF itrip.wsh_planned_flag IN ('Y', 'F') THEN --[
3700: stamp_interface_error(
3701: p_group_id => x_context.group_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),

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 4082: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

4078: EXCEPTION
4079: WHEN OTHERS THEN
4080: stamp_interface_error(
4081: p_group_id => x_context.group_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),

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 4176: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

4172:
4173: ELSIF (x_plan_trips(l_trip_index).wsh_planned_flag = 'F') THEN --[
4174: stamp_interface_error(
4175: p_group_id => x_context.group_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),

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 4268: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

4264: -- fail plan if delivery is routing/contents firmed
4265: IF x_plan_deliveries(l_plan_del_index).wsh_planned_flag = 'F' THEN
4266: stamp_interface_error(
4267: p_group_id => x_context.group_id,
4268: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
4269: p_entity_interface_id => x_plan_deliveries(l_plan_del_index).del_interface_id,
4270: p_message_name => 'WSH_TP_F_DEL_FIRM_LEG_DIFF',
4271: p_token_1_name => 'DELIVERY_NAME',
4272: p_token_1_value => wsh_new_deliveries_pvt.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),

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 4722: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

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;
4726: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;

Line 4723: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

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;
4726: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
4727:

Line 4724: l_trip_defaults WSH_TRIPS_GRP.default_parameters_rectype;

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;
4726: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
4727:
4728: -- WV changes

Line 4725: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

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;
4726: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
4727:
4728: -- WV changes
4729: -- Checks if the delivery has wv_frozen flag set to 'Y'

Line 4726: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_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;
4726: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
4727:
4728: -- WV changes
4729: -- Checks if the delivery has wv_frozen flag set to 'Y'
4730: -- Used when unassigning from delivery not in plan.

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 6136: wsh_trips_grp.trip_action(

6132:
6133: l_trip_action_prms.caller := 'WSH_TP_RELEASE';
6134: l_trip_action_prms.action_code := 'PLAN';
6135:
6136: wsh_trips_grp.trip_action(
6137: p_api_version_number => 1.0,
6138: p_init_msg_list => FND_API.G_TRUE,
6139: p_commit => FND_API.G_FALSE,
6140: p_action_prms => l_trip_action_prms,

Line 6182: wsh_trips_grp.trip_action(

6178:
6179: l_trip_action_prms.caller := 'WSH_TP_RELEASE';
6180: l_trip_action_prms.action_code := 'FIRM';
6181:
6182: wsh_trips_grp.trip_action(
6183: p_api_version_number => 1.0,
6184: p_init_msg_list => FND_API.G_TRUE,
6185: p_commit => FND_API.G_FALSE,
6186: p_action_prms => l_trip_action_prms,

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 6737: l_trip_action_prms WSH_TRIPS_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;
6741: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;

Line 6738: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

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;
6741: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
6742:

Line 6739: l_trip_defaults WSH_TRIPS_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;
6741: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
6742:
6743: WSH_EMPTY_TRIP EXCEPTION;

Line 6740: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

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;
6741: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
6742:
6743: WSH_EMPTY_TRIP EXCEPTION;
6744:

Line 6741: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_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;
6741: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
6742:
6743: WSH_EMPTY_TRIP EXCEPTION;
6744:
6745:

Line 7305: wsh_trips_grp.trip_action(

7301:
7302: l_trip_action_prms.caller := 'WSH_TP_RELEASE';
7303: l_trip_action_prms.action_code := 'DELETE';
7304:
7305: wsh_trips_grp.trip_action(
7306: p_api_version_number => 1.0,
7307: p_init_msg_list => FND_API.G_TRUE,
7308: p_commit => FND_API.G_FALSE,
7309: p_action_prms => l_trip_action_prms,

Line 7419: UPDATE wsh_trips_interface

7415: WSH_DEBUG_SV.log(l_module_name, 'Bulk update trips: count', l_interface_ids.COUNT);
7416: END IF;
7417:
7418: FORALL i in 1..l_interface_ids.count
7419: UPDATE wsh_trips_interface
7420: SET trip_id = l_ids(i)
7421: WHERE trip_interface_id = l_interface_ids(i);
7422:
7423: -- update stops

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 9051: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

9047: WSH_DEBUG_SV.logmsg(l_module_name,'plan does not match firmed trip having stop_id', s.stop_id);
9048: END IF;
9049:
9050: Stamp_Interface_Error(p_group_id => x_context.group_id,
9051: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
9052: p_entity_interface_id => x_plan_trips(i).trip_interface_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,

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 9152: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

9148: END IF;
9149:
9150: IF NVL(x_plan_trips(i).wsh_planned_flag,'N') = 'F' THEN
9151: Stamp_Interface_Error(p_group_id => x_context.group_id,
9152: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
9153: p_entity_interface_id => x_plan_trips(i).trip_interface_id,
9154: p_message_name => 'WSH_TP_F_PLAN_TRIP_NOT_MATCH',
9155: x_errors_tab => x_errors_tab,
9156: x_return_status => x_return_status);

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 9908: FROM wsh_trips

9904: SELECT name,
9905: operator,
9906: load_tender_status,
9907: load_tender_number
9908: FROM wsh_trips
9909: WHERE trip_id = x_trip_id;
9910:
9911: l_trip_info c_trip_info%ROWTYPE;
9912: BEGIN

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;

Line 10179: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

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;
10183: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;

Line 10180: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

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;
10183: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
10184:

Line 10181: l_trip_defaults WSH_TRIPS_GRP.default_parameters_rectype;

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;
10183: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
10184:
10185: BEGIN

Line 10182: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

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;
10183: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
10184:
10185: BEGIN
10186: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 10183: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_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;
10183: l_trip_out_tab WSH_TRIPS_GRP.trip_out_tab_type;
10184:
10185: BEGIN
10186: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
10187: --

Line 10246: wsh_trips_grp.Create_Update_Trip(

10242: OR (p_phase = 2 AND x_plan_trips(l_index).lane_id IS NOT NULL) THEN
10243: -- phase 1: always call this API
10244: -- phase 2: call this API only if lane_id needs to be populated.
10245:
10246: wsh_trips_grp.Create_Update_Trip(
10247: p_api_version_number => 1.0,
10248: p_init_msg_list => FND_API.G_FALSE,
10249: p_commit => FND_API.G_FALSE,
10250: p_trip_info_tab => l_trip_attrs,

Line 10257: l_interface_entity := 'WSH_TRIPS_INTERFACE';

10253: x_return_status => l_return_status,
10254: x_msg_count => l_msg_count,
10255: x_msg_data => l_msg_data);
10256:
10257: l_interface_entity := 'WSH_TRIPS_INTERFACE';
10258: l_interface_id := x_plan_trips(l_index).trip_interface_id;
10259: wsh_util_core.api_post_call(
10260: p_return_status => l_return_status,
10261: x_num_warnings => l_number_of_warnings,

Line 10624: l_plan_trip_num WSH_TRIPS.TP_TRIP_NUMBER%TYPE := '';

10620: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_PLAN_TRIP_NUM';
10621: --
10622: l_debug_on BOOLEAN;
10623: --
10624: l_plan_trip_num WSH_TRIPS.TP_TRIP_NUMBER%TYPE := '';
10625:
10626: -- c_tp_interface_trips makes a list of interface trips,
10627: -- mapping shipping trips that were snapshot;
10628: -- code will later validate these shipping trips can be mapped.

Line 10631: FROM wsh_trips_interface wti

10627: -- mapping shipping trips that were snapshot;
10628: -- code will later validate these shipping trips can be mapped.
10629: CURSOR c_name(p_group_id IN NUMBER) IS
10630: SELECT wti.tp_trip_number
10631: FROM wsh_trips_interface wti
10632: WHERE wti.group_id = p_group_id
10633: AND wti.interface_action_code = G_TP_RELEASE_CODE
10634: AND rownum = 1
10635: ;