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_DELIVERY_VALIDATIONS dependencies on WSH_NEW_DELIVERIES

Line 8: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

4: G_ACT_DEPT_DATE DATE;
5:
6: --3509004:public api changes
7: PROCEDURE user_non_updatable_columns
8: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
9: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
10: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
11: x_return_status OUT NOCOPY VARCHAR2);
12:

Line 9: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

5:
6: --3509004:public api changes
7: PROCEDURE user_non_updatable_columns
8: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
9: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
10: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
11: x_return_status OUT NOCOPY VARCHAR2);
12:
13:

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

514: --
515: -- Debug Statements
516: --
517: IF l_debug_on THEN
518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
519: END IF;
520: --
521: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 521: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

517: IF l_debug_on THEN
518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
519: END IF;
520: --
521: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
523: wsh_util_core.add_message(x_return_status);
524: END IF;
525:

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

662: --
663: -- Debug Statements
664: --
665: IF l_debug_on THEN
666: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
667: END IF;
668: --
669: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 669: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

665: IF l_debug_on THEN
666: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
667: END IF;
668: --
669: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
671: wsh_util_core.add_message(x_return_status);
672: END IF;
673:

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

743: --
744: -- Debug Statements
745: --
746: IF l_debug_on THEN
747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
748: END IF;
749: --
750: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
751: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 750: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

746: IF l_debug_on THEN
747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
748: END IF;
749: --
750: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
751: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
752: wsh_util_core.add_message(x_return_status);
753: END IF;
754:

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

824: --
825: -- Debug Statements
826: --
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
829: END IF;
830: --
831: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 831: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

827: IF l_debug_on THEN
828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
829: END IF;
830: --
831: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
833: wsh_util_core.add_message(x_return_status);
834:
835: END IF;

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

905: --
906: -- Debug Statements
907: --
908: IF l_debug_on THEN
909: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
910: END IF;
911: --
912: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
913: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 912: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

908: IF l_debug_on THEN
909: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
910: END IF;
911: --
912: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
913: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
914: wsh_util_core.add_message(x_return_status);
915: END IF;
916:

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

1066: --
1067: -- Debug Statements
1068: --
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1071: END IF;
1072: --
1073: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1074: FND_MESSAGE.SET_TOKEN('SHIP',fnd_date.date_to_chardate(p_ship_date));

Line 1073: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));

1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1071: END IF;
1072: --
1073: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1074: FND_MESSAGE.SET_TOKEN('SHIP',fnd_date.date_to_chardate(p_ship_date));
1075: FND_MESSAGE.SET_TOKEN('SUGGESTED',fnd_date.date_to_chardate(l_suggest_ship_date));
1076: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1077: wsh_util_core.add_message(x_return_status);

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

1086: --
1087: -- Debug Statements
1088: --
1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1091: END IF;
1092: --
1093: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1094: FND_MESSAGE.SET_TOKEN('RECEIVE',fnd_date.date_to_chardate(p_receive_date));

Line 1093: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));

1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1091: END IF;
1092: --
1093: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1094: FND_MESSAGE.SET_TOKEN('RECEIVE',fnd_date.date_to_chardate(p_receive_date));
1095: FND_MESSAGE.SET_TOKEN('SUGGESTED',fnd_date.date_to_chardate(l_suggest_receive_date));
1096: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1097: wsh_util_core.add_message(x_return_status);

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

1102: --
1103: -- Debug Statements
1104: --
1105: IF l_debug_on THEN
1106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1107: END IF;
1108: --
1109: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1110: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1109: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));

1105: IF l_debug_on THEN
1106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1107: END IF;
1108: --
1109: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1110: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1111: wsh_util_core.add_message(x_return_status);
1112: END IF;
1113:

Line 1117: UPDATE wsh_new_deliveries

1113:
1114: IF (p_update_flag = 'Y') THEN
1115:
1116: IF (l_suggest_ship_date <> p_ship_date) THEN
1117: UPDATE wsh_new_deliveries
1118: SET initial_pickup_date = l_suggest_ship_date
1119: WHERE delivery_id = p_entity_id;
1120: END IF;
1121:

Line 1123: UPDATE wsh_new_deliveries

1119: WHERE delivery_id = p_entity_id;
1120: END IF;
1121:
1122: IF (l_suggest_receive_date <> p_receive_date) THEN
1123: UPDATE wsh_new_deliveries
1124: SET ultimate_dropoff_date = l_suggest_receive_date
1125: WHERE delivery_id = p_entity_id;
1126: END IF;
1127:

Line 1181: FROM wsh_new_deliveries

1177: initial_pickup_location_id,
1178: ultimate_dropoff_location_id,
1179: nvl(shipment_direction,'O') shipment_direction,
1180: delivery_type
1181: FROM wsh_new_deliveries
1182: WHERE delivery_id = p_delivery_id;
1183:
1184:
1185: CURSOR delivery_details IS

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

1332: --
1333: -- Debug Statements
1334: --
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1337: END IF;
1338: --
1339: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1340: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1339: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1337: END IF;
1338: --
1339: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1340: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1341: wsh_util_core.add_message(x_return_status);
1342: --
1343: -- Debug Statements

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

1387:
1388: IF NOT (l_valid_flag) THEN
1389: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_SMC_INCOMPLETE');
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1392: END IF;
1393: --
1394: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1394: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1392: END IF;
1393: --
1394: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1396: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1397: END IF;
1398:

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

1424: --
1425: -- Debug Statements
1426: --
1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1429: END IF;
1430: --
1431: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1432: -- End Bug 2429632

Line 1431: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1429: END IF;
1430: --
1431: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1432: -- End Bug 2429632
1433:
1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1435: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 1577: FROM wsh_new_deliveries

1573: CURSOR delivery_status IS
1574: SELECT status_code,
1575: planned_flag,
1576: nvl(shipment_direction,'O') shipment_direction -- J-IB-NPARIKH
1577: FROM wsh_new_deliveries
1578: WHERE delivery_id = p_delivery_id;
1579:
1580: l_status_code VARCHAR2(2);
1581: l_planned_flag VARCHAR2(1);

Line 1694: wsh_new_deliveries dl

1690: dg.weight_uom_code,
1691: dg.volume,
1692: dg.volume_uom_code
1693: FROM wsh_delivery_legs dg,
1694: wsh_new_deliveries dl
1695: WHERE dl.delivery_id = dg.delivery_id AND
1696: dg.delivery_leg_id = p_delivery_leg_id;
1697:
1698: others EXCEPTION;

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

1743: --
1744: -- Debug Statements
1745: --
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1748: END IF;
1749: --
1750: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1750: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));

1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1748: END IF;
1749: --
1750: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1752: wsh_util_core.add_message(x_return_status);
1753: --
1754: -- Debug Statements

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

1765: --
1766: -- Debug Statements
1767: --
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1770: END IF;
1771: --
1772: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1772: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));

1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1770: END IF;
1771: --
1772: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1774: wsh_util_core.add_message(x_return_status);
1775: --
1776: -- Debug Statements

Line 1855: FROM wsh_new_deliveries

1851: organization_id,
1852: ship_method_code,
1853: nvl(shipment_direction,'O') shipment_direction, -- J-IB-NPARIKH
1854: nvl(ignore_for_planning, 'N') ignore_for_planning
1855: FROM wsh_new_deliveries
1856: WHERE delivery_id = p_delivery_id;
1857:
1858: CURSOR trip_status IS
1859: SELECT status_code,ship_method_code, planned_flag,

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

2241: --
2242: -- Debug Statements
2243: --
2244: IF l_debug_on THEN
2245: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2246: END IF;
2247: --
2248: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2249: --

Line 2248: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2244: IF l_debug_on THEN
2245: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2246: END IF;
2247: --
2248: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2249: --
2250: -- Debug Statements
2251: --
2252: IF l_debug_on THEN

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

2270: --
2271: -- Debug Statements
2272: --
2273: IF l_debug_on THEN
2274: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2275: END IF;
2276: --
2277: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2278: --

Line 2277: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2273: IF l_debug_on THEN
2274: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2275: END IF;
2276: --
2277: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2278: --
2279: -- Debug Statements
2280: --
2281: IF l_debug_on THEN

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

2299: --
2300: -- Debug Statements
2301: --
2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2304: END IF;
2305: --
2306: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2307: --

Line 2306: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2304: END IF;
2305: --
2306: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2307: --
2308: -- Debug Statements
2309: --
2310: IF l_debug_on THEN

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

2326:
2327: WHEN trip_firm THEN
2328: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_TR_FIRM');
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2331: END IF;
2332: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2333: IF l_debug_on THEN
2334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2332: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2328: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_TR_FIRM');
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2331: END IF;
2332: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2333: IF l_debug_on THEN
2334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2335: END IF;
2336: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

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

2342: END IF;
2343: WHEN trip_diffignore THEN
2344: FND_MESSAGE.SET_NAME('WSH','WSH_DELASSIGNTR_IGNORE');
2345: IF l_debug_on THEN
2346: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2347: END IF;
2348: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2348: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2344: FND_MESSAGE.SET_NAME('WSH','WSH_DELASSIGNTR_IGNORE');
2345: IF l_debug_on THEN
2346: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2347: END IF;
2348: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2351: END IF;
2352: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

Line 2395: FROM wsh_new_deliveries

2391: x_return_status OUT NOCOPY VARCHAR2) IS
2392:
2393: CURSOR delivery_status IS
2394: SELECT status_code
2395: FROM wsh_new_deliveries
2396: WHERE delivery_id = p_delivery_id;
2397:
2398: CURSOR trip_status IS
2399: SELECT status_code

Line 2547: FROM wsh_new_deliveries

2543: x_return_status OUT NOCOPY VARCHAR2) IS
2544:
2545: CURSOR delivery_status IS
2546: SELECT status_code
2547: FROM wsh_new_deliveries
2548: WHERE delivery_id = p_delivery_id;
2549:
2550: CURSOR detail_info IS
2551: SELECT da.parent_delivery_detail_id

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

2619: --
2620: -- Debug Statements
2621: --
2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2624: END IF;
2625: --
2626: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2626: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2624: END IF;
2625: --
2626: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2628: wsh_util_core.add_message(x_return_status);
2629: --
2630: -- Debug Statements

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

2651: --
2652: -- Debug Statements
2653: --
2654: IF l_debug_on THEN
2655: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2656: END IF;
2657: --
2658: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2659: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2658: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2654: IF l_debug_on THEN
2655: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2656: END IF;
2657: --
2658: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2659: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2660: wsh_util_core.add_message(x_return_status);
2661: --
2662: -- Debug Statements

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

2700: --
2701: -- Debug Statements
2702: --
2703: IF l_debug_on THEN
2704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2705: END IF;
2706: --
2707: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2708: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2707: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2703: IF l_debug_on THEN
2704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2705: END IF;
2706: --
2707: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2708: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2709: wsh_util_core.add_message(x_return_status);
2710: END IF;
2711:

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

2714: --
2715: -- Debug Statements
2716: --
2717: IF l_debug_on THEN
2718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2719: END IF;
2720: --
2721: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2722: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2721: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2717: IF l_debug_on THEN
2718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2719: END IF;
2720: --
2721: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2722: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2723: wsh_util_core.add_message(x_return_status);
2724: END IF;
2725:

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

2729: --
2730: -- Debug Statements
2731: --
2732: IF l_debug_on THEN
2733: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2734: END IF;
2735: --
2736: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2736: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

2732: IF l_debug_on THEN
2733: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2734: END IF;
2735: --
2736: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2738: wsh_util_core.add_message(x_return_status);
2739: --
2740: -- Debug Statements

Line 3370: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

3366: END IF;
3367:
3368: IF NOT (l_valid_flag) THEN
3369: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_SMC_INCOMPLETE');
3370: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3371:
3372: IF l_debug_on THEN
3373: WSH_DEBUG_SV.log(l_module_name,'g_break_smc_severity',g_break_smc_severity);
3374: END IF;

Line 3427: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

3423: END IF;
3424:
3425: IF NOT (l_valid_flag) THEN
3426: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_SHIP_SET_INCOMPLETE');
3427: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3428:
3429: IF l_debug_on THEN
3430: WSH_DEBUG_SV.log(l_module_name,'g_break_ship_set_severity',g_break_ship_set_severity);
3431: END IF;

Line 3562: FROM wsh_new_deliveries

3558: x_return_status OUT NOCOPY VARCHAR2) IS
3559:
3560: CURSOR delivery_status IS
3561: SELECT status_code
3562: FROM wsh_new_deliveries
3563: WHERE delivery_id = p_delivery_id;
3564:
3565: l_del_status VARCHAR2(2);
3566: others EXCEPTION;

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

3606: --
3607: -- Debug Statements
3608: --
3609: IF l_debug_on THEN
3610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3611: END IF;
3612: --
3613: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3614: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3613: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

3609: IF l_debug_on THEN
3610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3611: END IF;
3612: --
3613: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3614: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3615: wsh_util_core.add_message(x_return_status);
3616: --
3617: -- Debug Statements

Line 3664: FROM wsh_new_deliveries

3660: x_return_status OUT NOCOPY VARCHAR2) IS
3661:
3662: CURSOR delivery_status IS
3663: SELECT status_code
3664: FROM wsh_new_deliveries
3665: WHERE delivery_id = p_delivery_id;
3666:
3667: CURSOR stop_status IS
3668: SELECT st.status_code

Line 3671: wsh_new_deliveries dl

3667: CURSOR stop_status IS
3668: SELECT st.status_code
3669: FROM wsh_trip_stops st,
3670: wsh_delivery_legs dg,
3671: wsh_new_deliveries dl
3672: WHERE dl.delivery_id = p_delivery_id AND
3673: dg.delivery_id = dl.delivery_id AND
3674: st.stop_id = dg.pick_up_stop_id AND
3675: dl.initial_pickup_location_id = st.stop_location_id;

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

3722: --
3723: -- Debug Statements
3724: --
3725: IF l_debug_on THEN
3726: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3727: END IF;
3728: --
3729: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3729: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

3725: IF l_debug_on THEN
3726: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3727: END IF;
3728: --
3729: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3731: wsh_util_core.add_message(x_return_status);
3732: --
3733: -- Debug Statements

Line 3815: FROM wsh_new_deliveries dl,

3811:
3812: CURSOR dropoff_stop_info (l_delivery_id NUMBER) IS
3813: SELECT dg.drop_off_stop_id,
3814: st.stop_location_id
3815: FROM wsh_new_deliveries dl,
3816: wsh_delivery_legs dg,
3817: wsh_trip_stops st
3818: WHERE dl.delivery_id = l_delivery_id AND
3819: dl.delivery_id = dg.delivery_id AND

Line 3860: FROM wsh_delivery_legs dg, wsh_new_deliveries nd

3856: AND do_stop.stop_id = dg.drop_off_stop_id;
3857:
3858: CURSOR shared_stops(l_delivery_id NUMBER, l_stop_id NUMBER) IS
3859: SELECT dg.delivery_leg_id
3860: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3861: WHERE dg.pick_up_stop_id = l_stop_id
3862: AND dg.delivery_id <> l_delivery_id
3863: AND dg.delivery_id = nd.delivery_id
3864: AND nd.delivery_type = 'STANDARD'

Line 3867: FROM wsh_delivery_legs dg, wsh_new_deliveries nd

3863: AND dg.delivery_id = nd.delivery_id
3864: AND nd.delivery_type = 'STANDARD'
3865: UNION
3866: SELECT dg.delivery_leg_id
3867: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3868: WHERE dg.drop_off_stop_id = l_stop_id
3869: AND dg.delivery_id <> l_delivery_id
3870: AND dg.delivery_id = nd.delivery_id
3871: AND nd.delivery_type = 'STANDARD';

Line 4217: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd

4213: AND wts.status_code <> 'CL'
4214: AND EXISTS
4215: (
4216: SELECT 1
4217: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd
4218: WHERE wdl1.delivery_id <> p_delivery_id
4219: AND wdl1.delivery_id = wnd.delivery_id
4220: AND wnd.delivery_type = 'STANDARD'
4221: AND (

Line 4298: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));

4294: -- Delivery associated with stops which are not closed
4295: -- Cannot close delivery.
4296: --
4297: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_OPEN_STOP');
4298: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4299: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4300: RAISE wsh_util_core.e_not_allowed;
4301: END IF;
4302: CLOSE stops_not_closed;

Line 4315: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));

4311: -- POD not received
4312: -- Cannot close delivery.
4313: --
4314: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_POD');
4315: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4316: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4317: RAISE wsh_util_core.e_not_allowed;
4318: END IF;
4319: --

Line 4340: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));

4336: -- Delivery has lines
4337: -- Cannot close delivery.
4338: --
4339: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_DETAIL');
4340: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4341: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4342: RAISE wsh_util_core.e_not_allowed;
4343:
4344: END IF;

Line 4360: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));

4356: -- Delivery has legs
4357: -- Cannot close delivery.
4358: --
4359: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_LEGS');
4360: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4361: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4362:
4363: RAISE wsh_util_core.e_not_allowed;
4364: END IF;

Line 4383: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));

4379: IF shared_stops_csr%FOUND
4380: THEN
4381: --CLOSE shared_stops_csr;
4382: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_SHR_STOPS');
4383: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4384: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4385: RAISE wsh_util_core.e_not_allowed;
4386: END IF;
4387: --

Line 4580: FROM wsh_new_deliveries

4576: CURSOR delivery_status IS
4577: SELECT status_code, routing_response_id, --J-IB-NPARIKH
4578: delivery_type,
4579: tms_interface_flag --OTM R12
4580: FROM wsh_new_deliveries
4581: WHERE delivery_id = p_delivery_id;
4582:
4583: CURSOR detail_info IS
4584: SELECT delivery_detail_id

Line 4613: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

4609: PRAGMA EXCEPTION_INIT(record_locked, -54);
4610: --OTM R12
4611: cannot_delete_GC3_delivery EXCEPTION;
4612: l_gc3_is_installed VARCHAR2(1);
4613: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4614: --
4615:
4616:
4617: --

Line 4668: AND l_tms_interface_flag <> WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN

4664: CLOSE delivery_status;
4665:
4666: --OTM R12, can only delete NS flag deliveries when gc3 is installed
4667: IF (l_gc3_is_installed = 'Y'
4668: AND l_tms_interface_flag <> WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
4669:
4670: RAISE cannot_delete_gc3_delivery;
4671: END IF;
4672: --

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

4676: --
4677: -- Debug Statements
4678: --
4679: IF l_debug_on THEN
4680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4681: END IF;
4682: --
4683: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4684: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4683: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

4679: IF l_debug_on THEN
4680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4681: END IF;
4682: --
4683: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4684: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4685: wsh_util_core.add_message(x_return_status);
4686: END IF;
4687: --

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

4695: --
4696: -- Debug Statements
4697: --
4698: IF l_debug_on THEN
4699: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4700: END IF;
4701: --
4702: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4702: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

4698: IF l_debug_on THEN
4699: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4700: END IF;
4701: --
4702: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4704: wsh_util_core.add_message(x_return_status);
4705: END IF;
4706: --} --J-IB-NPARIKH

Line 4714: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));

4710: END LOOP;
4711:
4712: IF (l_flag = 'Y') THEN
4713: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_UNASSIGNED');
4714: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4715: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4716: wsh_util_core.add_message(x_return_status);
4717: END IF;
4718:

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

4728: --
4729: -- Debug Statements
4730: --
4731: IF l_debug_on THEN
4732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4733: END IF;
4734: --
4735: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4736: wsh_util_core.add_message(x_return_status);

Line 4735: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));

4731: IF l_debug_on THEN
4732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4733: END IF;
4734: --
4735: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4736: wsh_util_core.add_message(x_return_status);
4737: END IF;
4738:
4739: -- 3. Checks if freight costs exist for the delivery and locks them

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

4747: --
4748: -- Debug Statements
4749: --
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4752: END IF;
4753: --
4754: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4755: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4754: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));

4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4752: END IF;
4753: --
4754: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4755: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4756: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
4757: END IF;
4758:

Line 4872: FROM wsh_new_deliveries

4868:
4869: CURSOR delivery_status IS
4870: SELECT status_code,
4871: organization_id
4872: FROM wsh_new_deliveries
4873: WHERE delivery_id = p_delivery_id;
4874:
4875: CURSOR detail_info IS
4876: SELECT count(*)

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

4931: --
4932: -- Debug Statements
4933: --
4934: IF l_debug_on THEN
4935: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4936: END IF;
4937: --
4938: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4938: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

4934: IF l_debug_on THEN
4935: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4936: END IF;
4937: --
4938: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4940: wsh_util_core.add_message(x_return_status);
4941: --
4942: -- Debug Statements

Line 5029: FROM wsh_new_deliveries

5025: SELECT status_code, planned_flag, organization_id,
5026: nvl(shipment_direction,'O') shipment_direction -- J-IB-NPARIKH
5027: , INITIAL_PICKUP_LOCATION_ID, --3509004:public api changes
5028: delivery_type -- MDC
5029: FROM wsh_new_deliveries
5030: WHERE delivery_id = p_delivery_id;
5031:
5032: CURSOR has_delivery_lines
5033: IS

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

6069: --
6070: -- Debug Statements
6071: --
6072: IF l_debug_on THEN
6073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6074: END IF;
6075: --
6076: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6077: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);

Line 6076: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

6072: IF l_debug_on THEN
6073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6074: END IF;
6075: --
6076: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6077: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);
6078: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_source_system);
6079: FND_MESSAGE.SET_TOKEN('LINE_NUM',ltrim( rtrim ( l_source_line_number )) );
6080: FND_MESSAGE.SET_TOKEN('MAX_QTY',x_max_quantity);

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

6091: --
6092: -- Debug Statements
6093: --
6094: IF l_debug_on THEN
6095: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6096: END IF;
6097: --
6098: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6099: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);

Line 6098: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

6094: IF l_debug_on THEN
6095: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6096: END IF;
6097: --
6098: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6099: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);
6100: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_source_system);
6101: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',l_source_header_type_name);
6102: FND_MESSAGE.SET_TOKEN('LINE_NUM',ltrim( rtrim ( l_source_line_number )) );

Line 6258: wsh_new_deliveries wnd

6254: from wsh_transactions_history
6255: where transaction_id = (
6256: select max(transaction_id)
6257: from wsh_transactions_history wth,
6258: wsh_new_deliveries wnd
6259: where wth.entity_number = wnd.name
6260: and wth.trading_partner_id = p_tp_id
6261: and wnd.delivery_id = p_delivery_id
6262: )

Line 6285: AND (nvl(wt.ignore_for_planning,'N') <> (select nvl(ignore_for_planning,'N') from wsh_new_deliveries where delivery_id=p_delid)

6281: CURSOR c_isvalidtptrip(p_delid IN NUMBER, p_tripid IN NUMBER) IS
6282: SELECT 'Y'
6283: FROM wsh_trips wt
6284: WHERE wt.trip_id=p_tripid
6285: AND (nvl(wt.ignore_for_planning,'N') <> (select nvl(ignore_for_planning,'N') from wsh_new_deliveries where delivery_id=p_delid)
6286: );
6287:
6288:
6289: --/== Workflow Changes

Line 6293: FROM WSH_NEW_DELIVERIES

6289: --/== Workflow Changes
6290: CURSOR c_get_cntrl_wf_details(p_delivery_id IN NUMBER) IS
6291: SELECT delivery_scpod_wf_process,
6292: del_wf_close_attr
6293: FROM WSH_NEW_DELIVERIES
6294: WHERE delivery_id = p_delivery_id;
6295:
6296: l_override_wf VARCHAR2(1);
6297: l_del_entity_ids WSH_UTIL_CORE.column_tab_type;

Line 6308: FROM wsh_new_deliveries

6304:
6305: -- R12 MDC
6306: CURSOR cur_get_delivery_type (p_delivery_id IN NUMBER) IS
6307: SELECT delivery_type
6308: FROM wsh_new_deliveries
6309: WHERE delivery_id = p_delivery_id;
6310: l_delivery_type wsh_new_deliveries.delivery_type%type;
6311:
6312: CURSOR cur_check_consol_delivery (p_delivery_id IN NUMBER) IS

Line 6310: l_delivery_type wsh_new_deliveries.delivery_type%type;

6306: CURSOR cur_get_delivery_type (p_delivery_id IN NUMBER) IS
6307: SELECT delivery_type
6308: FROM wsh_new_deliveries
6309: WHERE delivery_id = p_delivery_id;
6310: l_delivery_type wsh_new_deliveries.delivery_type%type;
6311:
6312: CURSOR cur_check_consol_delivery (p_delivery_id IN NUMBER) IS
6313: select 1
6314: from wsh_delivery_legs pleg,

Line 6650: AND NVL(l_dlvy_actions_tab(k).tms_interface_flag, NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)) =

6646: AND nvl(l_dlvy_actions_tab(k).shipment_direction, nvl(p_dlvy_rec_tab(j).shipment_direction, 'O'))= nvl(p_dlvy_rec_tab(j).shipment_direction, 'O')
6647: --OTM R12
6648: AND NVL(l_dlvy_actions_tab(k).ignore_for_planning, NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')) =
6649: NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')
6650: AND NVL(l_dlvy_actions_tab(k).tms_interface_flag, NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)) =
6651: NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6652: -- OTM R12 Org Specific changes - 5399341
6653: AND nvl(l_dlvy_actions_tab(k).otm_enabled, nvl(l_param_info.otm_enabled, 'N')) =nvl(l_param_info.otm_enabled, 'N')
6654: --

Line 6651: NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

6647: --OTM R12
6648: AND NVL(l_dlvy_actions_tab(k).ignore_for_planning, NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')) =
6649: NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')
6650: AND NVL(l_dlvy_actions_tab(k).tms_interface_flag, NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)) =
6651: NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6652: -- OTM R12 Org Specific changes - 5399341
6653: AND nvl(l_dlvy_actions_tab(k).otm_enabled, nvl(l_param_info.otm_enabled, 'N')) =nvl(l_param_info.otm_enabled, 'N')
6654: --
6655: )

Line 6980: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));

6976: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;
6977: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
6978: p_caller = 'WSH_TRCON' THEN
6979: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_ACTION_INELIGIBLE');
6980: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
6981: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('DLVY',p_action));
6982: wsh_util_core.add_message('E',l_module_name);
6983: END IF;
6984: WHEN e_tp_record_ineligible THEN

Line 6989: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));

6985: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;
6986: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
6987: p_caller = 'WSH_TRCON' THEN
6988: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_FIRMTRIP_ERROR');
6989: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
6990: FND_MESSAGE.Set_Token('TRIP_NAME',wsh_trips_pvt.get_name(p_tripid));
6991: wsh_util_core.add_message('E',l_module_name);
6992: END IF;
6993: WHEN e_scpod_wf_inprogress THEN --/== Workflow Changes

Line 6998: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));

6994: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;
6995: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
6996: p_caller = 'WSH_TRCON' THEN
6997: FND_MESSAGE.SET_NAME('WSH','WSH_WF_DEL_ACTION_INELIGIBLE');
6998: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
6999: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('DLVY',p_action));
7000: wsh_util_core.add_message('E',l_module_name); --==/
7001: END IF;
7002:

Line 7124: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7120: END populate_external_edf;
7121:
7122:
7123: PROCEDURE eliminate_displayonly_fields (
7124: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7125: --tkt
7126: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
7127: , x_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7128: )

Line 7127: , x_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7123: PROCEDURE eliminate_displayonly_fields (
7124: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7125: --tkt
7126: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
7127: , x_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7128: )
7129: IS
7130: BEGIN
7131:

Line 7697: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7693: -----------------------------------------------------------*/
7694:
7695: PROCEDURE disable_from_list(
7696: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
7697: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7698: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7699: , x_return_status OUT NOCOPY VARCHAR2
7700: , x_field_name OUT NOCOPY VARCHAR2
7701: , p_caller IN VARCHAR2

Line 7698: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7694:
7695: PROCEDURE disable_from_list(
7696: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
7697: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7698: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7699: , x_return_status OUT NOCOPY VARCHAR2
7700: , x_field_name OUT NOCOPY VARCHAR2
7701: , p_caller IN VARCHAR2
7702:

Line 8311: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

8307: -----------------------------------------------------------*/
8308:
8309: PROCEDURE enable_from_list(
8310: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
8311: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8312: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8313: , x_return_status OUT NOCOPY VARCHAR2
8314: , x_field_name OUT NOCOPY VARCHAR2
8315:

Line 8312: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

8308:
8309: PROCEDURE enable_from_list(
8310: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
8311: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8312: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8313: , x_return_status OUT NOCOPY VARCHAR2
8314: , x_field_name OUT NOCOPY VARCHAR2
8315:
8316: ) IS

Line 9287: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

9283: -- Overloaded procedure
9284: -- Replaced p_action with p_in_rec as a parameter
9285: --
9286: PROCEDURE Get_Disabled_List (
9287: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
9288: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
9289: , x_return_status OUT NOCOPY VARCHAR2
9290: , x_msg_count OUT NOCOPY NUMBER
9291: , x_msg_data OUT NOCOPY VARCHAR2

Line 9292: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

9288: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
9289: , x_return_status OUT NOCOPY VARCHAR2
9290: , x_msg_count OUT NOCOPY NUMBER
9291: , x_msg_data OUT NOCOPY VARCHAR2
9292: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
9293: )
9294: IS
9295: l_disabled_list WSH_UTIL_CORE.column_tab_type;
9296: l_db_col_rec WSH_NEW_DELIVERIES_PVT.Delivery_rec_type;

Line 9296: l_db_col_rec WSH_NEW_DELIVERIES_PVT.Delivery_rec_type;

9292: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
9293: )
9294: IS
9295: l_disabled_list WSH_UTIL_CORE.column_tab_type;
9296: l_db_col_rec WSH_NEW_DELIVERIES_PVT.Delivery_rec_type;
9297: l_return_status VARCHAR2(30);
9298: l_field_name VARCHAR2(100);
9299: l_debug_on BOOLEAN;
9300: l_module_name CONSTANT VARCHAR2(100) :=

Line 9474: FROM wsh_new_deliveries

9470: --OTM R12
9471: ,TMS_INTERFACE_FLAG
9472: ,TMS_VERSION_NUMBER
9473: --
9474: FROM wsh_new_deliveries
9475: WHERE delivery_id = p_delivery_rec.delivery_id;
9476:
9477: e_dp_no_entity EXCEPTION;
9478: e_bad_field EXCEPTION;

Line 10215: from wsh_new_deliveries

10211: cursor l_del_org_csr is
10212: select organization_id,
10213: weight_uom_code,
10214: volume_uom_code
10215: from wsh_new_deliveries
10216: where delivery_id = p_delivery_id;
10217: --
10218: CURSOR l_get_classes_csr(p_organization_id NUMBER) IS
10219: SELECT weight_uom_class, volume_uom_class

Line 10581: from wsh_new_deliveries wnd,

10577: -- of Trip to this Delivery.
10578: cursor l_pick_up_leg_csr( p_del_id IN VARCHAR2,
10579: p_pickup_locn_id IN NUMBER) is
10580: select wt.name, wnd.name
10581: from wsh_new_deliveries wnd,
10582: wsh_delivery_legs wdl,
10583: wsh_trip_stops wts,
10584: wsh_trips wt
10585: where wnd.delivery_id = p_del_id

Line 10598: from wsh_new_deliveries wnd,

10594: -- of Trip to this Delivery.
10595: cursor l_drop_off_leg_csr( p_del_id IN VARCHAR2,
10596: p_dropoff_locn_id IN NUMBER) is
10597: select wt.name, wnd.name
10598: from wsh_new_deliveries wnd,
10599: wsh_delivery_legs wdl,
10600: wsh_trip_stops wts,
10601: wsh_trips wt
10602: where wnd.delivery_id = p_del_id

Line 10777: l_strQuery := 'select wnd.delivery_id from wsh_new_deliveries wnd ' ||

10773: -- Build query for this delivery
10774:
10775: --Bug 6676749 Modified the query to Mark the delivery for Export Compliance for Both Outbound transaction('O') and Internal Order ('IO')
10776:
10777: l_strQuery := 'select wnd.delivery_id from wsh_new_deliveries wnd ' ||
10778: -- ' where wnd.shipment_direction = ''O'' ';
10779: ' where wnd.shipment_direction IN (''O'', ''IO'') ';
10780: l_Item_Condn1Tab(1).g_number_val := p_delivery_id;
10781: l_Item_Condn1Tab(1).g_Bind_Literal := ':b_delivery_id';

Line 11386: FROM WSH_NEW_DELIVERIES

11382: -- Get delivery info.
11383: CURSOR dlvy_csr (p_delivery_id NUMBER)
11384: IS
11385: SELECT shipping_control, routing_response_id
11386: FROM WSH_NEW_DELIVERIES
11387: WHERE delivery_id = p_delivery_id;
11388: --
11389: l_dlvy_rec dlvy_csr%ROWTYPE;
11390: --

Line 11541: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

11537: -- J-IB-NPARIKH-}
11538:
11539: --3509004:public api change
11540: PROCEDURE user_non_updatable_columns
11541: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11542: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11543: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
11544: x_return_status OUT NOCOPY VARCHAR2)
11545:

Line 11542: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

11538:
11539: --3509004:public api change
11540: PROCEDURE user_non_updatable_columns
11541: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11542: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11543: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
11544: x_return_status OUT NOCOPY VARCHAR2)
11545:
11546: IS

Line 12676: wsh_new_deliveries wnd

12672: wt.status_code
12673: FROM wsh_trip_stops wts,
12674: wsh_delivery_legs wdl,
12675: wsh_trips wt,
12676: wsh_new_deliveries wnd
12677: WHERE wnd.delivery_id = p_del_id
12678: AND wdl.delivery_id = wnd.delivery_id
12679: AND wdl.pick_up_stop_id = wts.stop_id
12680: AND wnd.initial_pickup_location_id = wts.stop_location_id

Line 12738: -- Description: This procedure will copy the attributes of a delivery in wsh_new_deliveries

12734: -------------------------------------------------------------------------------
12735: -- Procedure: GET_DELIVERY_INFORMATION
12736: -- Parameters: x_delivery_rec: A record of all attributes of a Delivery Record
12737: -- p_delivery_id : delivery_id of the delivery that is to be copied
12738: -- Description: This procedure will copy the attributes of a delivery in wsh_new_deliveries
12739: -- and copy it to a record.
12740: -------------------------------------------------------------------------------
12741:
12742: PROCEDURE GET_DELIVERY_INFORMATION

Line 12744: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

12740: -------------------------------------------------------------------------------
12741:
12742: PROCEDURE GET_DELIVERY_INFORMATION
12743: (p_delivery_id IN NUMBER,
12744: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
12745: x_return_status OUT NOCOPY VARCHAR2) IS
12746:
12747: CURSOR c_get_delivery_info (p_delivery_id IN NUMBER) IS
12748: SELECT DELIVERY_ID

Line 12772: FROM wsh_new_deliveries

12768: ,TP_PLAN_NAME
12769: ,WV_FROZEN_FLAG
12770: ,TMS_INTERFACE_FLAG
12771: ,TMS_VERSION_NUMBER
12772: FROM wsh_new_deliveries
12773: WHERE delivery_id = p_delivery_id;
12774:
12775: l_debug_on BOOLEAN;
12776: --