DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_TRIP_STOPS_PVT

Line 9: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_VALIDATIONS';
6:
7: --3509004 :public api changes
8: PROCEDURE user_non_updatable_columns
9: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
10: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
11: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
12: x_return_status OUT NOCOPY VARCHAR2);
13:

Line 10: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

6:
7: --3509004 :public api changes
8: PROCEDURE user_non_updatable_columns
9: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
10: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
11: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
12: x_return_status OUT NOCOPY VARCHAR2);
13:
14:

Line 909: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj

905: /*J inbound logistics new column jckwok*/
906: NVL(wnd.shipment_direction, 'O') shipment_direction,
907: wnd.delivery_type, --MDC
908: NVL(wnd.ignore_for_planning, 'N') ignore_for_planning, --OTM R12, glog proj
909: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj
910: NVL(mcp.otm_enabled,wsp.otm_enabled) otm_enabled, -- LSP PROJECT : checking OTM enabled flag on client parameters.
911: wnd.client_id -- LSP PROJECT
912: from wsh_new_deliveries wnd,
913: wsh_delivery_legs wdl,

Line 1287: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1283:
1284:
1285:
1286: PROCEDURE eliminate_displayonly_fields (
1287: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1288: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1289: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1290: )
1291: IS

Line 1289: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1285:
1286: PROCEDURE eliminate_displayonly_fields (
1287: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1288: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1289: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1290: )
1291: IS
1292: BEGIN
1293:

Line 1591: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1587: -----------------------------------------------------------*/
1588:
1589: PROCEDURE disable_from_list(
1590: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1591: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1592: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_field_name OUT NOCOPY VARCHAR2
1595:

Line 1592: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1588:
1589: PROCEDURE disable_from_list(
1590: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1591: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1592: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_field_name OUT NOCOPY VARCHAR2
1595:
1596: ) IS

Line 1777: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1773: -----------------------------------------------------------*/
1774:
1775: PROCEDURE enable_from_list(
1776: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1777: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1778: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1779: , x_return_status OUT NOCOPY VARCHAR2
1780: , x_field_name OUT NOCOPY VARCHAR2
1781:

Line 1778: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1774:
1775: PROCEDURE enable_from_list(
1776: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1777: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1778: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1779: , x_return_status OUT NOCOPY VARCHAR2
1780: , x_field_name OUT NOCOPY VARCHAR2
1781:
1782: ) IS

Line 1984: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1980: --
1981: -- Bug 2678363 - Added p_in_rec as a parameter instead of p_action
1982: --
1983: PROCEDURE Get_Disabled_List (
1984: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1985: , p_parent_entity_id IN NUMBER
1986: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1987: , x_return_status OUT NOCOPY VARCHAR2
1988: , x_msg_count OUT NOCOPY NUMBER

Line 1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1986: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1987: , x_return_status OUT NOCOPY VARCHAR2
1988: , x_msg_count OUT NOCOPY NUMBER
1989: , x_msg_data OUT NOCOPY VARCHAR2
1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1991: )
1992: IS
1993: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1994: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

Line 1994: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1991: )
1992: IS
1993: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1994: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
1995: l_return_status VARCHAR2(30);
1996: l_field_name VARCHAR2(100);
1997: l_parent_entity_id NUMBER;
1998: l_debug_on BOOLEAN;

Line 2177: WSH_TRIP_STOPS_PVT.Get_Disabled_List( p_stop_rec.stop_id

2173: l_caller := p_in_rec.caller;
2174: IF (l_caller like 'FTE%' AND l_caller <> 'FTE_TMS_INTEGRATION') THEN
2175: l_caller := 'WSH_PUB';
2176: END IF;
2177: WSH_TRIP_STOPS_PVT.Get_Disabled_List( p_stop_rec.stop_id
2178: ,l_parent_entity_id
2179: , 'FORM'
2180: , x_return_status
2181: , l_disabled_list

Line 3446: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trip_stops_pvt.get_name(l_exceptions_tbl(exp_cnt).entity_id)); --BugFix #3925590

3442: ELSIF l_exceptions_tbl(exp_cnt).exception_behavior = 'WARNING' THEN
3443: IF l_exceptions_tbl(exp_cnt).entity_name = 'STOP' THEN
3444: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
3445: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Stop');
3446: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trip_stops_pvt.get_name(l_exceptions_tbl(exp_cnt).entity_id)); --BugFix #3925590
3447: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
3448: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3449: wsh_util_core.add_message(x_return_status);
3450: l_stop_warnings := l_stop_warnings + 1;

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

4369:
4370: IF (l_param_info.percent_fill_basis_flag = 'W' and l_stop_info_rec.departure_gross_weight is NULL) THEN
4371: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
4372: IF l_debug_on THEN
4373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4374: END IF;
4375: --
4376: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

Line 4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

4373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4374: END IF;
4375: --
4376: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4378: FND_MESSAGE.SET_TOKEN('WV','Weight');
4379: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4380: wsh_util_core.add_message(x_return_status);
4381: l_stop_warnings := l_stop_warnings + 1;

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

4383:
4384: IF (l_param_info.percent_fill_basis_flag = 'V' and l_stop_info_rec.departure_volume is NULL) THEN
4385: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
4386: IF l_debug_on THEN
4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4388: END IF;
4389: --
4390: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

Line 4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4388: END IF;
4389: --
4390: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4392: FND_MESSAGE.SET_TOKEN('WV','Volume');
4393: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4394: wsh_util_core.add_message(x_return_status);
4395: l_stop_warnings := l_stop_warnings + 1;

Line 5241: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

5237:
5238:
5239: --3509004:public api change
5240: PROCEDURE user_non_updatable_columns
5241: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5242: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5243: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
5244: x_return_status OUT NOCOPY VARCHAR2)
5245:

Line 5242: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

5238:
5239: --3509004:public api change
5240: PROCEDURE user_non_updatable_columns
5241: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5242: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5243: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
5244: x_return_status OUT NOCOPY VARCHAR2)
5245:
5246: IS