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 1726: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_interface_grp.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);

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

Line 1735: wsh_interface_grp.Delivery_Action(

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

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

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

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

4646: IF l_debug_on THEN
4647: 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);
4648: END IF;
4649:
4650: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
4651: x_dropoff_seq_num := derive_next_ssn(p_trip_id, x_dropoff_stop_id);
4652: IF l_debug_on THEN
4653: WSH_DEBUG_SV.log(l_module_name,'x_dropoff_seq_num adjusted', x_dropoff_seq_num);
4654: END IF;

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

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

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

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

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

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

Line 5066: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

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

Line 7642: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

7638: IF l_debug_on THEN
7639: WSH_DEBUG_SV.logmsg(l_module_name,'p_trip_ids('||i||') ==> '||p_trip_ids(i));
7640: END IF;
7641:
7642: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
7643:
7644: OPEN c_get_stops_PAD(p_trip_ids(i));
7645: FETCH c_get_stops_PAD BULK COLLECT INTO l_getstops_stop_id,
7646: l_getstops_stop_loc_id,

Line 7733: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7729: END IF;
7730: l_getstops_phys_stop_id(j) := l_getstops_stop_id(j+1);
7731: l_getstops_pl_arr_date(j) := l_getstops_pl_arr_date(j+1) - WSH_TRIPS_ACTIONS.C_TEN_SECONDS;
7732: l_getstops_pl_dep_date(j) := l_getstops_pl_arr_date(j);
7733: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7734: l_getstops_stop_seq_num(j) := l_getstops_stop_seq_num(j+1) - 1;
7735: END IF;
7736: l_update_flag := TRUE;
7737: ELSIF l_getstops_stop_id.exists(j-1)

Line 7775: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7771: l_getstops_phys_stop_id(j-1) := l_getstops_stop_id(j); -- link
7772: l_getstops_pl_arr_date(j-1) := l_getstops_pl_arr_date(j) - WSH_TRIPS_ACTIONS.C_TEN_SECONDS;
7773: l_getstops_pl_dep_date(j-1) := l_getstops_pl_arr_date(j-1);
7774:
7775: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7776: -- we need to adjust the sequence numbers of these stops flipped:
7777: -- physical stop should retain the SSN.
7778: -- dummy stop should have SSN subtracted by 1.
7779: l_getstops_stop_seq_num(j) := l_getstops_stop_seq_num(j-1);

Line 7790: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7786: END IF;
7787: END IF;
7788: END LOOP;
7789:
7790: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7791: -- in SSN mode, resequencing a physical stop to be first
7792: -- could cause its linked dummy stop sequence to become 0
7793: -- or negative.
7794: -- Not an issue in PAD because SSNs will be renumbered.

Line 7830: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

7826: IF j > 1 and
7827: (l_getstops_phys_stop_id(j) is not NULL
7828: OR l_push_date_allowed OR l_push_ssn_allowed) THEN
7829:
7830: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
7831:
7832: IF l_getstops_pl_arr_date(j-1) >= l_getstops_pl_arr_date(j) THEN
7833: IF l_debug_on THEN
7834: WSH_DEBUG_SV.log(l_module_name,'arr date of prev stop conflict at stop' , l_getstops_stop_id(j));

Line 7887: AND l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

7883: END IF;
7884: END IF;
7885:
7886: IF j > 1
7887: AND l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
7888: -- bug 4245339: check for non-unique SSN
7889: IF l_getstops_stop_seq_num(j-1)
7890: = l_getstops_stop_seq_num(j) THEN
7891: raise duplicate_stop_seq;

Line 7949: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN

7945:
7946: -- End of Code for DBI Project
7947:
7948: END IF;
7949: IF l_stop_seq_mode = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
7950: -- need to resequence the stops' SSNs and validate their dates.
7951:
7952: l_stop_details_rec.trip_id := p_trip_ids(i);
7953: --l_stop_details_rec.stop_id := NULL;