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 908: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj

904: /*J inbound logistics new column jckwok*/
905: NVL(wnd.shipment_direction, 'O') shipment_direction,
906: wnd.delivery_type, --MDC
907: NVL(wnd.ignore_for_planning, 'N') ignore_for_planning, --OTM R12, glog proj
908: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj
909: wsp.otm_enabled
910: from wsh_new_deliveries wnd,
911: wsh_delivery_legs wdl,
912: wsh_shipping_parameters wsp

Line 1283: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1279:
1280:
1281:
1282: PROCEDURE eliminate_displayonly_fields (
1283: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1284: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1285: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1286: )
1287: IS

Line 1285: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

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

Line 1587: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1583: -----------------------------------------------------------*/
1584:
1585: PROCEDURE disable_from_list(
1586: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1587: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1588: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1589: , x_return_status OUT NOCOPY VARCHAR2
1590: , x_field_name OUT NOCOPY VARCHAR2
1591:

Line 1588: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1584:
1585: PROCEDURE disable_from_list(
1586: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1587: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1588: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1589: , x_return_status OUT NOCOPY VARCHAR2
1590: , x_field_name OUT NOCOPY VARCHAR2
1591:
1592: ) IS

Line 1773: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1769: -----------------------------------------------------------*/
1770:
1771: PROCEDURE enable_from_list(
1772: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1773: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1774: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1775: , x_return_status OUT NOCOPY VARCHAR2
1776: , x_field_name OUT NOCOPY VARCHAR2
1777:

Line 1774: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1770:
1771: PROCEDURE enable_from_list(
1772: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1773: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1774: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1775: , x_return_status OUT NOCOPY VARCHAR2
1776: , x_field_name OUT NOCOPY VARCHAR2
1777:
1778: ) IS

Line 1980: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

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

Line 1986: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1982: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1983: , x_return_status OUT NOCOPY VARCHAR2
1984: , x_msg_count OUT NOCOPY NUMBER
1985: , x_msg_data OUT NOCOPY VARCHAR2
1986: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1987: )
1988: IS
1989: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1990: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

Line 1990: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

1986: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1987: )
1988: IS
1989: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1990: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
1991: l_return_status VARCHAR2(30);
1992: l_field_name VARCHAR2(100);
1993: l_parent_entity_id NUMBER;
1994: l_debug_on BOOLEAN;

Line 2173: WSH_TRIP_STOPS_PVT.Get_Disabled_List( p_stop_rec.stop_id

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

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

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

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

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

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

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

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

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

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

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

Line 5237: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

5233:
5234:
5235: --3509004:public api change
5236: PROCEDURE user_non_updatable_columns
5237: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5238: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5239: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
5240: x_return_status OUT NOCOPY VARCHAR2)
5241:

Line 5238: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

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