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_INTERFACE_GRP

Line 60: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN;

56: -- OTM R12, glog project
57: -- IF GC3 is INSTALLED, Mode should be SSN
58: IF G_STOP_SEQ_MODE IS NULL THEN--{
59: IF l_gc3_is_installed = 'Y' THEN
60: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN;
61: ELSE
62: IF WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y' THEN
63: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;
64: ELSIF fnd_profile.value('WSH_STOP_SEQ_MODE') = ('PAD') THEN

Line 63: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;

59: IF l_gc3_is_installed = 'Y' THEN
60: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN;
61: ELSE
62: IF WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y' THEN
63: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;
64: ELSIF fnd_profile.value('WSH_STOP_SEQ_MODE') = ('PAD') THEN
65: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;
66: ELSE -- non-existent profile or any other value of fnd_profile.value(' WSH_STOP_SEQ_MODE') implies SSN
67: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN;

Line 65: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;

61: ELSE
62: IF WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y' THEN
63: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;
64: ELSIF fnd_profile.value('WSH_STOP_SEQ_MODE') = ('PAD') THEN
65: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;
66: ELSE -- non-existent profile or any other value of fnd_profile.value(' WSH_STOP_SEQ_MODE') implies SSN
67: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN;
68: END IF;
69: END IF;

Line 67: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN;

63: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;
64: ELSIF fnd_profile.value('WSH_STOP_SEQ_MODE') = ('PAD') THEN
65: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD;
66: ELSE -- non-existent profile or any other value of fnd_profile.value(' WSH_STOP_SEQ_MODE') implies SSN
67: G_STOP_SEQ_MODE := WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN;
68: END IF;
69: END IF;
70: END IF;--}
71:

Line 85: RETURN nvl(G_STOP_SEQ_MODE, WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN);

81: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
82: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
83: END IF;
84: -- Bug 4253334, default value is SSN mode
85: RETURN nvl(G_STOP_SEQ_MODE, WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN);
86: END get_stop_seq_mode;
87:
88: PROCEDURE Get_Trip_Defaults(p_trip_id in NUMBER,
89: p_trip_name in VARCHAR2 DEFAULT NULL,

Line 1724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_interface_grp.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);

1720: END LOOP;
1721: --
1722: --
1723: IF l_debug_on THEN
1724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_interface_grp.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
1725: END IF;
1726: --
1727: l_action_prms.caller := p_action_prms.caller;
1728: l_action_prms.phase := p_action_prms.phase;

Line 1733: wsh_interface_grp.Delivery_Action(

1729: l_action_prms.action_code := p_action_prms.action_code;
1730: --
1731: -- Call Delivery group API to generate routing response
1732: --
1733: wsh_interface_grp.Delivery_Action(
1734: p_api_version_number => 1.0,
1735: p_init_msg_list => FND_API.G_FALSE,
1736: p_commit => FND_API.G_FALSE,
1737: p_action_prms => l_action_prms,

Line 3000: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

2996:
2997: -- SSN change
2998: -- Call to reset_stop_planned_dates API should be made
2999: -- only for profile = PAD
3000: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
3001: -- re-set the dates according to sequence number
3002: -- bug 3516052
3003: l_trip_id := x_trip_id;
3004:

Line 4648: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

4644: IF l_debug_on THEN
4645: WSH_DEBUG_SV.log(l_module_name,'Have to create new internal stop as del with physical dropoff has been passed',l_dropoff_location_id);
4646: END IF;
4647:
4648: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
4649: x_dropoff_seq_num := derive_next_ssn(p_trip_id, x_dropoff_stop_id);
4650: IF l_debug_on THEN
4651: WSH_DEBUG_SV.log(l_module_name,'x_dropoff_seq_num adjusted', x_dropoff_seq_num);
4652: END IF;

Line 4677: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

4673: IF l_debug_on THEN
4674: WSH_DEBUG_SV.log(l_module_name,'Have to create new internal stop as existing physical stop has activities',l_dropoff_location_id);
4675: END IF;
4676:
4677: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
4678: x_dropoff_seq_num := derive_next_ssn(p_trip_id, x_dropoff_stop_id);
4679: IF l_debug_on THEN
4680: WSH_DEBUG_SV.log(l_module_name,'x_dropoff_seq_num adjusted', x_dropoff_seq_num);
4681: END IF;

Line 4880: IF (l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD) AND

4876: -- bug 3516052
4877: -- bug 4036204: We relax the restriction so that p_pickup_dep_date = p_dropoff_arr_date
4878: -- as long as p_pickup_arr_date >= p_dropoff_arr_date
4879: -- SSN Change, add conditional check
4880: IF (l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD) AND
4881: ((p_pickup_dep_date > p_dropoff_arr_date) OR
4882: ((p_pickup_dep_date = p_dropoff_arr_date) AND
4883: (p_pickup_arr_date >= p_dropoff_arr_date)
4884: )

Line 4972: IF (l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD) AND

4968: RETURN;
4969: END IF;
4970:
4971: -- SSN Change, add conditional check
4972: IF (l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD) AND
4973: -- Bug 4017507: If we are creating a new stop, we need to resequence.
4974: (l_pickup_stop_id IS NULL OR l_dropoff_stop_id IS NULL)
4975: THEN
4976: l_pickup_stop_seq := NULL;

Line 5064: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

5060: l_stop_details_rec.trip_id := p_trip_id;
5061:
5062: -- SSN change
5063: -- Call Reset_Stop_Seq_Numbers only if mode = PAD
5064: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
5065: -- need to resequence the stops' SSNs and validate their dates.
5066: WSH_TRIP_STOPS_ACTIONS.RESET_STOP_SEQ_NUMBERS(
5067: p_stop_details_rec => l_stop_details_rec,
5068: x_return_status => l_return_status );

Line 7631: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

7627: IF l_debug_on THEN
7628: WSH_DEBUG_SV.logmsg(l_module_name,'p_trip_ids('||i||') ==> '||p_trip_ids(i));
7629: END IF;
7630:
7631: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
7632:
7633: OPEN c_get_stops_PAD(p_trip_ids(i));
7634: FETCH c_get_stops_PAD BULK COLLECT INTO l_getstops_stop_id,
7635: l_getstops_stop_loc_id,

Line 7722: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7718: END IF;
7719: l_getstops_phys_stop_id(j) := l_getstops_stop_id(j+1);
7720: l_getstops_pl_arr_date(j) := l_getstops_pl_arr_date(j+1) - WSH_TRIPS_ACTIONS.C_TEN_SECONDS;
7721: l_getstops_pl_dep_date(j) := l_getstops_pl_arr_date(j);
7722: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7723: l_getstops_stop_seq_num(j) := l_getstops_stop_seq_num(j+1) - 1;
7724: END IF;
7725: l_update_flag := TRUE;
7726: ELSIF l_getstops_stop_id.exists(j-1)

Line 7764: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7760: l_getstops_phys_stop_id(j-1) := l_getstops_stop_id(j); -- link
7761: l_getstops_pl_arr_date(j-1) := l_getstops_pl_arr_date(j) - WSH_TRIPS_ACTIONS.C_TEN_SECONDS;
7762: l_getstops_pl_dep_date(j-1) := l_getstops_pl_arr_date(j-1);
7763:
7764: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7765: -- we need to adjust the sequence numbers of these stops flipped:
7766: -- physical stop should retain the SSN.
7767: -- dummy stop should have SSN subtracted by 1.
7768: l_getstops_stop_seq_num(j) := l_getstops_stop_seq_num(j-1);

Line 7779: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7775: END IF;
7776: END IF;
7777: END LOOP;
7778:
7779: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7780: -- in SSN mode, resequencing a physical stop to be first
7781: -- could cause its linked dummy stop sequence to become 0
7782: -- or negative.
7783: -- Not an issue in PAD because SSNs will be renumbered.

Line 7819: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

7815: IF j > 1 and
7816: (l_getstops_phys_stop_id(j) is not NULL
7817: OR l_push_date_allowed OR l_push_ssn_allowed) THEN
7818:
7819: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
7820:
7821: IF l_getstops_pl_arr_date(j-1) >= l_getstops_pl_arr_date(j) THEN
7822: IF l_debug_on THEN
7823: WSH_DEBUG_SV.log(l_module_name,'arr date of prev stop conflict at stop' , l_getstops_stop_id(j));

Line 7876: AND l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7872: END IF;
7873: END IF;
7874:
7875: IF j > 1
7876: AND l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7877: -- bug 4245339: check for non-unique SSN
7878: IF l_getstops_stop_seq_num(j-1)
7879: = l_getstops_stop_seq_num(j) THEN
7880: raise duplicate_stop_seq;

Line 7938: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

7934:
7935: -- End of Code for DBI Project
7936:
7937: END IF;
7938: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
7939: -- need to resequence the stops' SSNs and validate their dates.
7940:
7941: l_stop_details_rec.trip_id := p_trip_ids(i);
7942: --l_stop_details_rec.stop_id := NULL;