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 523: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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

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

522: IF l_debug_on THEN
523: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
524: END IF;
525: --
526: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
527: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
528: wsh_util_core.add_message(x_return_status);
529: END IF;
530:

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

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

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

670: IF l_debug_on THEN
671: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
672: END IF;
673: --
674: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
675: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
676: wsh_util_core.add_message(x_return_status);
677: END IF;
678:

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

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

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

751: IF l_debug_on THEN
752: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
753: END IF;
754: --
755: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
756: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
757: wsh_util_core.add_message(x_return_status);
758: END IF;
759:

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

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

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

832: IF l_debug_on THEN
833: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
834: END IF;
835: --
836: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
837: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
838: wsh_util_core.add_message(x_return_status);
839:
840: END IF;

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

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

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

913: IF l_debug_on THEN
914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
915: END IF;
916: --
917: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
919: wsh_util_core.add_message(x_return_status);
920: END IF;
921:

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

1072: --
1073: -- Debug Statements
1074: --
1075: IF l_debug_on THEN
1076: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1077: END IF;
1078: --
1079: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1080: FND_MESSAGE.SET_TOKEN('SHIP',fnd_date.date_to_chardate(p_ship_date,calendar_aware=>FND_DATE.calendar_aware_alt));

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

1075: IF l_debug_on THEN
1076: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1077: END IF;
1078: --
1079: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1080: FND_MESSAGE.SET_TOKEN('SHIP',fnd_date.date_to_chardate(p_ship_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1081: FND_MESSAGE.SET_TOKEN('SUGGESTED',fnd_date.date_to_chardate(l_suggest_ship_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1082: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1083: wsh_util_core.add_message(x_return_status);

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

1096: FND_MESSAGE.SET_NAME('WSH','WSH_REC_DATE_ALT');
1097: ELSE
1098: FND_MESSAGE.SET_NAME('WSH','WSH_REC_DATE_ALT_UPDATE');
1099: END IF;
1100: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1101: FND_MESSAGE.SET_TOKEN('RECEIVE',fnd_date.date_to_chardate(p_receive_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1102: FND_MESSAGE.SET_TOKEN('SUGGESTED',fnd_date.date_to_chardate(l_suggest_receive_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1103: ELSE
1104: IF (p_update_flag <> 'Y') THEN

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

1105: FND_MESSAGE.SET_NAME('WSH','WSH_CAL_REC_DATE_ALT');
1106: ELSE
1107: FND_MESSAGE.SET_NAME('WSH','WSH_CAL_REC_DATE_ALT_UPDATE');
1108: END IF;
1109: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1110: --Bug 8687915: Passing the date validated against Receiving Calendar, instead of p_recv_date.
1111: FND_MESSAGE.SET_TOKEN('RECEIVE',fnd_date.date_to_chardate(l_temp_suggest_receive_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1112: FND_MESSAGE.SET_TOKEN('SUGGESTED',fnd_date.date_to_chardate(l_suggest_receive_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1113: END IF;

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

1114: --
1115: -- Debug Statements
1116: --
1117: IF l_debug_on THEN
1118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1119: END IF;
1120: --
1121: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1122: wsh_util_core.add_message(x_return_status);

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

1127: --
1128: -- Debug Statements
1129: --
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1132: END IF;
1133: --
1134: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1135: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1132: END IF;
1133: --
1134: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1135: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1136: wsh_util_core.add_message(x_return_status);
1137: END IF;
1138:

Line 1142: UPDATE wsh_new_deliveries

1138:
1139: IF (p_update_flag = 'Y') THEN
1140:
1141: IF (l_suggest_ship_date <> p_ship_date) THEN
1142: UPDATE wsh_new_deliveries
1143: SET initial_pickup_date = l_suggest_ship_date
1144: WHERE delivery_id = p_entity_id;
1145: END IF;
1146:

Line 1148: UPDATE wsh_new_deliveries

1144: WHERE delivery_id = p_entity_id;
1145: END IF;
1146:
1147: IF (l_suggest_receive_date <> p_receive_date) THEN
1148: UPDATE wsh_new_deliveries
1149: SET ultimate_dropoff_date = l_suggest_receive_date
1150: WHERE delivery_id = p_entity_id;
1151: END IF;
1152:

Line 1206: FROM wsh_new_deliveries

1202: initial_pickup_location_id,
1203: ultimate_dropoff_location_id,
1204: nvl(shipment_direction,'O') shipment_direction,
1205: delivery_type
1206: FROM wsh_new_deliveries
1207: WHERE delivery_id = p_delivery_id;
1208:
1209:
1210: CURSOR delivery_details IS

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

1359: --
1360: -- Debug Statements
1361: --
1362: IF l_debug_on THEN
1363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1364: END IF;
1365: --
1366: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1362: IF l_debug_on THEN
1363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1364: END IF;
1365: --
1366: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1368: wsh_util_core.add_message(x_return_status);
1369: --
1370: -- Debug Statements

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

1414:
1415: IF NOT (l_valid_flag) THEN
1416: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_SMC_INCOMPLETE');
1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1419: END IF;
1420: --
1421: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1422: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1419: END IF;
1420: --
1421: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1422: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1423: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1424: END IF;
1425:

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

1451: --
1452: -- Debug Statements
1453: --
1454: IF l_debug_on THEN
1455: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1456: END IF;
1457: --
1458: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1459: -- End Bug 2429632

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

1454: IF l_debug_on THEN
1455: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1456: END IF;
1457: --
1458: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1459: -- End Bug 2429632
1460:
1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1462: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 1617: FROM wsh_new_deliveries

1613: CURSOR delivery_status IS
1614: SELECT status_code,
1615: planned_flag,
1616: nvl(shipment_direction,'O') shipment_direction -- J-IB-NPARIKH
1617: FROM wsh_new_deliveries
1618: WHERE delivery_id = p_delivery_id;
1619:
1620: l_status_code VARCHAR2(2);
1621: l_planned_flag VARCHAR2(1);

Line 1734: wsh_new_deliveries dl

1730: dg.weight_uom_code,
1731: dg.volume,
1732: dg.volume_uom_code
1733: FROM wsh_delivery_legs dg,
1734: wsh_new_deliveries dl
1735: WHERE dl.delivery_id = dg.delivery_id AND
1736: dg.delivery_leg_id = p_delivery_leg_id;
1737:
1738: others EXCEPTION;

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

1783: --
1784: -- Debug Statements
1785: --
1786: IF l_debug_on THEN
1787: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1788: END IF;
1789: --
1790: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1786: IF l_debug_on THEN
1787: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1788: END IF;
1789: --
1790: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1792: wsh_util_core.add_message(x_return_status);
1793: --
1794: -- Debug Statements

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

1805: --
1806: -- Debug Statements
1807: --
1808: IF l_debug_on THEN
1809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1810: END IF;
1811: --
1812: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1813: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1808: IF l_debug_on THEN
1809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1810: END IF;
1811: --
1812: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1813: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1814: wsh_util_core.add_message(x_return_status);
1815: --
1816: -- Debug Statements

Line 1895: FROM wsh_new_deliveries

1891: organization_id,
1892: ship_method_code,
1893: nvl(shipment_direction,'O') shipment_direction, -- J-IB-NPARIKH
1894: nvl(ignore_for_planning, 'N') ignore_for_planning
1895: FROM wsh_new_deliveries
1896: WHERE delivery_id = p_delivery_id;
1897:
1898: CURSOR trip_status IS
1899: SELECT status_code,ship_method_code, planned_flag,

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

2281: --
2282: -- Debug Statements
2283: --
2284: IF l_debug_on THEN
2285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2286: END IF;
2287: --
2288: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2289: --

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

2284: IF l_debug_on THEN
2285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2286: END IF;
2287: --
2288: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2289: --
2290: -- Debug Statements
2291: --
2292: IF l_debug_on THEN

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

2310: --
2311: -- Debug Statements
2312: --
2313: IF l_debug_on THEN
2314: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2315: END IF;
2316: --
2317: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2318: --

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

2313: IF l_debug_on THEN
2314: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2315: END IF;
2316: --
2317: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2318: --
2319: -- Debug Statements
2320: --
2321: IF l_debug_on THEN

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

2339: --
2340: -- Debug Statements
2341: --
2342: IF l_debug_on THEN
2343: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2344: END IF;
2345: --
2346: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2347: --

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

2342: IF l_debug_on THEN
2343: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2344: END IF;
2345: --
2346: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2347: --
2348: -- Debug Statements
2349: --
2350: IF l_debug_on THEN

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

2366:
2367: WHEN trip_firm THEN
2368: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_TR_FIRM');
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2371: END IF;
2372: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2373: IF l_debug_on THEN
2374: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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

2368: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_TR_FIRM');
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2371: END IF;
2372: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2373: IF l_debug_on THEN
2374: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2375: END IF;
2376: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

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

2382: END IF;
2383: WHEN trip_diffignore THEN
2384: FND_MESSAGE.SET_NAME('WSH','WSH_DELASSIGNTR_IGNORE');
2385: IF l_debug_on THEN
2386: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2387: END IF;
2388: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2389: IF l_debug_on THEN
2390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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

2384: FND_MESSAGE.SET_NAME('WSH','WSH_DELASSIGNTR_IGNORE');
2385: IF l_debug_on THEN
2386: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2387: END IF;
2388: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2389: IF l_debug_on THEN
2390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2391: END IF;
2392: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

Line 2435: FROM wsh_new_deliveries

2431: x_return_status OUT NOCOPY VARCHAR2) IS
2432:
2433: CURSOR delivery_status IS
2434: SELECT status_code
2435: FROM wsh_new_deliveries
2436: WHERE delivery_id = p_delivery_id;
2437:
2438: CURSOR trip_status IS
2439: SELECT status_code

Line 2587: FROM wsh_new_deliveries

2583: x_return_status OUT NOCOPY VARCHAR2) IS
2584:
2585: CURSOR delivery_status IS
2586: SELECT status_code
2587: FROM wsh_new_deliveries
2588: WHERE delivery_id = p_delivery_id;
2589:
2590: CURSOR detail_info IS
2591: SELECT da.parent_delivery_detail_id

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

2659: --
2660: -- Debug Statements
2661: --
2662: IF l_debug_on THEN
2663: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2664: END IF;
2665: --
2666: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

2662: IF l_debug_on THEN
2663: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2664: END IF;
2665: --
2666: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2668: wsh_util_core.add_message(x_return_status);
2669: --
2670: -- Debug Statements

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

2691: --
2692: -- Debug Statements
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2696: END IF;
2697: --
2698: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2699: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2696: END IF;
2697: --
2698: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2699: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2700: wsh_util_core.add_message(x_return_status);
2701: --
2702: -- Debug Statements

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

2740: --
2741: -- Debug Statements
2742: --
2743: IF l_debug_on THEN
2744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2745: END IF;
2746: --
2747: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2748: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2743: IF l_debug_on THEN
2744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2745: END IF;
2746: --
2747: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2748: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2749: wsh_util_core.add_message(x_return_status);
2750: END IF;
2751:

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

2754: --
2755: -- Debug Statements
2756: --
2757: IF l_debug_on THEN
2758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2759: END IF;
2760: --
2761: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2762: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2757: IF l_debug_on THEN
2758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2759: END IF;
2760: --
2761: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2762: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2763: wsh_util_core.add_message(x_return_status);
2764: END IF;
2765:

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

2769: --
2770: -- Debug Statements
2771: --
2772: IF l_debug_on THEN
2773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2774: END IF;
2775: --
2776: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2777: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

2772: IF l_debug_on THEN
2773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2774: END IF;
2775: --
2776: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2777: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2778: wsh_util_core.add_message(x_return_status);
2779: --
2780: -- Debug Statements

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

3442: END IF;
3443:
3444: IF NOT (l_valid_flag) THEN
3445: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_SMC_INCOMPLETE');
3446: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3447:
3448: IF l_debug_on THEN
3449: WSH_DEBUG_SV.log(l_module_name,'g_break_smc_severity',g_break_smc_severity);
3450: END IF;

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

3499: END IF;
3500:
3501: IF NOT (l_valid_flag) THEN
3502: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_SHIP_SET_INCOMPLETE');
3503: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3504:
3505: IF l_debug_on THEN
3506: WSH_DEBUG_SV.log(l_module_name,'g_break_ship_set_severity',g_break_ship_set_severity);
3507: END IF;

Line 3652: FROM wsh_new_deliveries

3648: x_return_status OUT NOCOPY VARCHAR2) IS
3649:
3650: CURSOR delivery_status IS
3651: SELECT status_code
3652: FROM wsh_new_deliveries
3653: WHERE delivery_id = p_delivery_id;
3654:
3655: l_del_status VARCHAR2(2);
3656: others EXCEPTION;

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

3696: --
3697: -- Debug Statements
3698: --
3699: IF l_debug_on THEN
3700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3701: END IF;
3702: --
3703: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3704: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

3699: IF l_debug_on THEN
3700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3701: END IF;
3702: --
3703: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3704: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3705: wsh_util_core.add_message(x_return_status);
3706: --
3707: -- Debug Statements

Line 3754: FROM wsh_new_deliveries

3750: x_return_status OUT NOCOPY VARCHAR2) IS
3751:
3752: CURSOR delivery_status IS
3753: SELECT status_code
3754: FROM wsh_new_deliveries
3755: WHERE delivery_id = p_delivery_id;
3756:
3757: CURSOR stop_status IS
3758: SELECT st.status_code

Line 3761: wsh_new_deliveries dl

3757: CURSOR stop_status IS
3758: SELECT st.status_code
3759: FROM wsh_trip_stops st,
3760: wsh_delivery_legs dg,
3761: wsh_new_deliveries dl
3762: WHERE dl.delivery_id = p_delivery_id AND
3763: dg.delivery_id = dl.delivery_id AND
3764: st.stop_id = dg.pick_up_stop_id AND
3765: dl.initial_pickup_location_id = st.stop_location_id;

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

3812: --
3813: -- Debug Statements
3814: --
3815: IF l_debug_on THEN
3816: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3817: END IF;
3818: --
3819: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

3815: IF l_debug_on THEN
3816: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3817: END IF;
3818: --
3819: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
3820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3821: wsh_util_core.add_message(x_return_status);
3822: --
3823: -- Debug Statements

Line 3905: FROM wsh_new_deliveries dl,

3901:
3902: CURSOR dropoff_stop_info (l_delivery_id NUMBER) IS
3903: SELECT dg.drop_off_stop_id,
3904: st.stop_location_id
3905: FROM wsh_new_deliveries dl,
3906: wsh_delivery_legs dg,
3907: wsh_trip_stops st
3908: WHERE dl.delivery_id = l_delivery_id AND
3909: dl.delivery_id = dg.delivery_id AND

Line 3950: FROM wsh_delivery_legs dg, wsh_new_deliveries nd

3946: AND do_stop.stop_id = dg.drop_off_stop_id;
3947:
3948: CURSOR shared_stops(l_delivery_id NUMBER, l_stop_id NUMBER) IS
3949: SELECT dg.delivery_leg_id
3950: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3951: WHERE dg.pick_up_stop_id = l_stop_id
3952: AND dg.delivery_id <> l_delivery_id
3953: AND dg.delivery_id = nd.delivery_id
3954: AND nd.delivery_type = 'STANDARD'

Line 3957: FROM wsh_delivery_legs dg, wsh_new_deliveries nd

3953: AND dg.delivery_id = nd.delivery_id
3954: AND nd.delivery_type = 'STANDARD'
3955: UNION
3956: SELECT dg.delivery_leg_id
3957: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3958: WHERE dg.drop_off_stop_id = l_stop_id
3959: AND dg.delivery_id <> l_delivery_id
3960: AND dg.delivery_id = nd.delivery_id
3961: AND nd.delivery_type = 'STANDARD';

Line 4307: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd

4303: AND wts.status_code <> 'CL'
4304: AND EXISTS
4305: (
4306: SELECT 1
4307: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd
4308: WHERE wdl1.delivery_id <> p_delivery_id
4309: AND wdl1.delivery_id = wnd.delivery_id
4310: AND wnd.delivery_type = 'STANDARD'
4311: AND (

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

4384: -- Delivery associated with stops which are not closed
4385: -- Cannot close delivery.
4386: --
4387: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_OPEN_STOP');
4388: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4389: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4390: RAISE wsh_util_core.e_not_allowed;
4391: END IF;
4392: CLOSE stops_not_closed;

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

4401: -- POD not received
4402: -- Cannot close delivery.
4403: --
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_POD');
4405: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4406: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4407: RAISE wsh_util_core.e_not_allowed;
4408: END IF;
4409: --

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

4426: -- Delivery has lines
4427: -- Cannot close delivery.
4428: --
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_DETAIL');
4430: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4431: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4432: RAISE wsh_util_core.e_not_allowed;
4433:
4434: END IF;

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

4446: -- Delivery has legs
4447: -- Cannot close delivery.
4448: --
4449: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_LEGS');
4450: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4451: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4452:
4453: RAISE wsh_util_core.e_not_allowed;
4454: END IF;

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

4469: IF shared_stops_csr%FOUND
4470: THEN
4471: --CLOSE shared_stops_csr;
4472: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_NO_CLOSE_SHR_STOPS');
4473: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_in_rec.delivery_id));
4474: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
4475: RAISE wsh_util_core.e_not_allowed;
4476: END IF;
4477: --

Line 4670: FROM wsh_new_deliveries

4666: CURSOR delivery_status IS
4667: SELECT status_code, routing_response_id, --J-IB-NPARIKH
4668: delivery_type,
4669: tms_interface_flag --OTM R12
4670: FROM wsh_new_deliveries
4671: WHERE delivery_id = p_delivery_id;
4672:
4673: CURSOR detail_info IS
4674: SELECT delivery_detail_id

Line 4703: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

4699: PRAGMA EXCEPTION_INIT(record_locked, -54);
4700: --OTM R12
4701: cannot_delete_GC3_delivery EXCEPTION;
4702: l_gc3_is_installed VARCHAR2(1);
4703: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4704: --
4705:
4706:
4707: --

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

4754: CLOSE delivery_status;
4755:
4756: --OTM R12, can only delete NS flag deliveries when gc3 is installed
4757: IF (l_gc3_is_installed = 'Y'
4758: AND l_tms_interface_flag <> WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
4759:
4760: RAISE cannot_delete_gc3_delivery;
4761: END IF;
4762: --

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

4766: --
4767: -- Debug Statements
4768: --
4769: IF l_debug_on THEN
4770: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4771: END IF;
4772: --
4773: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4774: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

4769: IF l_debug_on THEN
4770: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4771: END IF;
4772: --
4773: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4774: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4775: wsh_util_core.add_message(x_return_status);
4776: END IF;
4777: --

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

4785: --
4786: -- Debug Statements
4787: --
4788: IF l_debug_on THEN
4789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4790: END IF;
4791: --
4792: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

4788: IF l_debug_on THEN
4789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4790: END IF;
4791: --
4792: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4794: wsh_util_core.add_message(x_return_status);
4795: END IF;
4796: --} --J-IB-NPARIKH

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

4800: END LOOP;
4801:
4802: IF (l_flag = 'Y') THEN
4803: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DETAILS_UNASSIGNED');
4804: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4805: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4806: wsh_util_core.add_message(x_return_status);
4807: END IF;
4808:

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

4818: --
4819: -- Debug Statements
4820: --
4821: IF l_debug_on THEN
4822: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4823: END IF;
4824: --
4825: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4826: wsh_util_core.add_message(x_return_status);

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

4821: IF l_debug_on THEN
4822: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4823: END IF;
4824: --
4825: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4826: wsh_util_core.add_message(x_return_status);
4827: END IF;
4828:
4829: -- 3. Checks if freight costs exist for the delivery and locks them

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

4837: --
4838: -- Debug Statements
4839: --
4840: IF l_debug_on THEN
4841: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4842: END IF;
4843: --
4844: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

4840: IF l_debug_on THEN
4841: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4842: END IF;
4843: --
4844: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_delivery_id));
4845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4846: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
4847: END IF;
4848:

Line 4962: FROM wsh_new_deliveries

4958:
4959: CURSOR delivery_status IS
4960: SELECT status_code,
4961: organization_id
4962: FROM wsh_new_deliveries
4963: WHERE delivery_id = p_delivery_id;
4964:
4965: CURSOR detail_info IS
4966: SELECT count(*)

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

5021: --
5022: -- Debug Statements
5023: --
5024: IF l_debug_on THEN
5025: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5026: END IF;
5027: --
5028: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
5029: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

5024: IF l_debug_on THEN
5025: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5026: END IF;
5027: --
5028: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
5029: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5030: wsh_util_core.add_message(x_return_status);
5031: --
5032: -- Debug Statements

Line 5119: FROM wsh_new_deliveries

5115: SELECT status_code, planned_flag, organization_id,
5116: nvl(shipment_direction,'O') shipment_direction -- J-IB-NPARIKH
5117: , INITIAL_PICKUP_LOCATION_ID, --3509004:public api changes
5118: delivery_type -- MDC
5119: FROM wsh_new_deliveries
5120: WHERE delivery_id = p_delivery_id;
5121:
5122: CURSOR has_delivery_lines
5123: IS

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

6208: --
6209: -- Debug Statements
6210: --
6211: IF l_debug_on THEN
6212: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6213: END IF;
6214: --
6215: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6216: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);

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

6211: IF l_debug_on THEN
6212: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6213: END IF;
6214: --
6215: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6216: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);
6217: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_source_system);
6218: FND_MESSAGE.SET_TOKEN('LINE_NUM',ltrim( rtrim ( l_source_line_number )) );
6219: -- muom

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

6245: --
6246: -- Debug Statements
6247: --
6248: IF l_debug_on THEN
6249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6250: END IF;
6251: --
6252: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6253: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);

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

6248: IF l_debug_on THEN
6249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6250: END IF;
6251: --
6252: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
6253: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_source_header_number);
6254: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_source_system);
6255: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',l_source_header_type_name);
6256: FND_MESSAGE.SET_TOKEN('LINE_NUM',ltrim( rtrim ( l_source_line_number )) );

Line 6417: wsh_new_deliveries wnd

6413: from wsh_transactions_history
6414: where transaction_id = (
6415: select max(transaction_id)
6416: from wsh_transactions_history wth,
6417: wsh_new_deliveries wnd
6418: where wth.entity_number = wnd.name
6419: and wth.trading_partner_id = p_tp_id
6420: and wnd.delivery_id = p_delivery_id
6421: )

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

6440: CURSOR c_isvalidtptrip(p_delid IN NUMBER, p_tripid IN NUMBER) IS
6441: SELECT 'Y'
6442: FROM wsh_trips wt
6443: WHERE wt.trip_id=p_tripid
6444: AND (nvl(wt.ignore_for_planning,'N') <> (select nvl(ignore_for_planning,'N') from wsh_new_deliveries where delivery_id=p_delid)
6445: );
6446:
6447:
6448: --/== Workflow Changes

Line 6452: FROM WSH_NEW_DELIVERIES

6448: --/== Workflow Changes
6449: CURSOR c_get_cntrl_wf_details(p_delivery_id IN NUMBER) IS
6450: SELECT delivery_scpod_wf_process,
6451: del_wf_close_attr
6452: FROM WSH_NEW_DELIVERIES
6453: WHERE delivery_id = p_delivery_id;
6454:
6455: l_override_wf VARCHAR2(1);
6456: l_del_entity_ids WSH_UTIL_CORE.column_tab_type;

Line 6467: FROM wsh_new_deliveries

6463:
6464: -- R12 MDC
6465: CURSOR cur_get_delivery_type (p_delivery_id IN NUMBER) IS
6466: SELECT delivery_type
6467: FROM wsh_new_deliveries
6468: WHERE delivery_id = p_delivery_id;
6469: l_delivery_type wsh_new_deliveries.delivery_type%type;
6470:
6471: CURSOR cur_check_consol_delivery (p_delivery_id IN NUMBER) IS

Line 6469: l_delivery_type wsh_new_deliveries.delivery_type%type;

6465: CURSOR cur_get_delivery_type (p_delivery_id IN NUMBER) IS
6466: SELECT delivery_type
6467: FROM wsh_new_deliveries
6468: WHERE delivery_id = p_delivery_id;
6469: l_delivery_type wsh_new_deliveries.delivery_type%type;
6470:
6471: CURSOR cur_check_consol_delivery (p_delivery_id IN NUMBER) IS
6472: select 1
6473: from wsh_delivery_legs pleg,

Line 6825: 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)) =

6821: 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')
6822: --OTM R12
6823: AND NVL(l_dlvy_actions_tab(k).ignore_for_planning, NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')) =
6824: NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')
6825: 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)) =
6826: NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6827: -- OTM R12 Org Specific changes - 5399341
6828: AND nvl(l_dlvy_actions_tab(k).otm_enabled, nvl(l_param_info.otm_enabled, 'N')) =nvl(l_param_info.otm_enabled, 'N')
6829: --

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

6822: --OTM R12
6823: AND NVL(l_dlvy_actions_tab(k).ignore_for_planning, NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')) =
6824: NVL(p_dlvy_rec_tab(j).ignore_for_planning, 'N')
6825: 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)) =
6826: NVL(p_dlvy_rec_tab(j).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6827: -- OTM R12 Org Specific changes - 5399341
6828: AND nvl(l_dlvy_actions_tab(k).otm_enabled, nvl(l_param_info.otm_enabled, 'N')) =nvl(l_param_info.otm_enabled, 'N')
6829: --
6830: )

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

7176: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;
7177: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
7178: p_caller = 'WSH_TRCON' THEN
7179: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_ACTION_INELIGIBLE');
7180: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
7181: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('DLVY',p_action));
7182: wsh_util_core.add_message('E',l_module_name);
7183: END IF;
7184: WHEN e_tp_record_ineligible THEN

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

7185: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;
7186: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
7187: p_caller = 'WSH_TRCON' THEN
7188: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_FIRMTRIP_ERROR');
7189: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
7190: FND_MESSAGE.Set_Token('TRIP_NAME',wsh_trips_pvt.get_name(p_tripid));
7191: wsh_util_core.add_message('E',l_module_name);
7192: END IF;
7193: WHEN e_scpod_wf_inprogress THEN --/== Workflow Changes

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

7194: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;
7195: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
7196: p_caller = 'WSH_TRCON' THEN
7197: FND_MESSAGE.SET_NAME('WSH','WSH_WF_DEL_ACTION_INELIGIBLE');
7198: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
7199: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('DLVY',p_action));
7200: wsh_util_core.add_message('E',l_module_name); --==/
7201: END IF;
7202:

Line 7324: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7320: END populate_external_edf;
7321:
7322:
7323: PROCEDURE eliminate_displayonly_fields (
7324: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7325: --tkt
7326: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
7327: , x_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7328: )

Line 7327: , x_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7323: PROCEDURE eliminate_displayonly_fields (
7324: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7325: --tkt
7326: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
7327: , x_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7328: )
7329: IS
7330: BEGIN
7331:

Line 7919: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7915: -----------------------------------------------------------*/
7916:
7917: PROCEDURE disable_from_list(
7918: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
7919: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7920: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7921: , x_return_status OUT NOCOPY VARCHAR2
7922: , x_field_name OUT NOCOPY VARCHAR2
7923: , p_caller IN VARCHAR2

Line 7920: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

7916:
7917: PROCEDURE disable_from_list(
7918: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
7919: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7920: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
7921: , x_return_status OUT NOCOPY VARCHAR2
7922: , x_field_name OUT NOCOPY VARCHAR2
7923: , p_caller IN VARCHAR2
7924:

Line 8545: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

8541: -----------------------------------------------------------*/
8542:
8543: PROCEDURE enable_from_list(
8544: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
8545: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8546: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8547: , x_return_status OUT NOCOPY VARCHAR2
8548: , x_field_name OUT NOCOPY VARCHAR2
8549:

Line 8546: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

8542:
8543: PROCEDURE enable_from_list(
8544: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
8545: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8546: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type
8547: , x_return_status OUT NOCOPY VARCHAR2
8548: , x_field_name OUT NOCOPY VARCHAR2
8549:
8550: ) IS

Line 9537: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

9533: -- Overloaded procedure
9534: -- Replaced p_action with p_in_rec as a parameter
9535: --
9536: PROCEDURE Get_Disabled_List (
9537: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
9538: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
9539: , x_return_status OUT NOCOPY VARCHAR2
9540: , x_msg_count OUT NOCOPY NUMBER
9541: , x_msg_data OUT NOCOPY VARCHAR2

Line 9542: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

9538: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
9539: , x_return_status OUT NOCOPY VARCHAR2
9540: , x_msg_count OUT NOCOPY NUMBER
9541: , x_msg_data OUT NOCOPY VARCHAR2
9542: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
9543: )
9544: IS
9545: l_disabled_list WSH_UTIL_CORE.column_tab_type;
9546: l_db_col_rec WSH_NEW_DELIVERIES_PVT.Delivery_rec_type;

Line 9546: l_db_col_rec WSH_NEW_DELIVERIES_PVT.Delivery_rec_type;

9542: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
9543: )
9544: IS
9545: l_disabled_list WSH_UTIL_CORE.column_tab_type;
9546: l_db_col_rec WSH_NEW_DELIVERIES_PVT.Delivery_rec_type;
9547: l_return_status VARCHAR2(30);
9548: l_field_name VARCHAR2(100);
9549: l_debug_on BOOLEAN;
9550: l_module_name CONSTANT VARCHAR2(100) :=

Line 9728: FROM wsh_new_deliveries

9724: ,PENDING_ADVICE_FLAG
9725: ,CLIENT_ID -- LSP PROJECT : Added just for compatibility ( not used anywhere). -- Modified R12.1.1 LSP PROJECT (rminocha)
9726: ,p_delivery_rec.client_code -- LSP PROJECT
9727: ,consignee_flag -- RTV changes
9728: FROM wsh_new_deliveries
9729: WHERE delivery_id = p_delivery_rec.delivery_id;
9730:
9731: e_dp_no_entity EXCEPTION;
9732: e_bad_field EXCEPTION;

Line 10469: from wsh_new_deliveries

10465: cursor l_del_org_csr is
10466: select organization_id,
10467: weight_uom_code,
10468: volume_uom_code
10469: from wsh_new_deliveries
10470: where delivery_id = p_delivery_id;
10471: --
10472: -- Bug# 8446283 : Added weight and volume UOM codes
10473: CURSOR l_get_classes_csr(p_organization_id NUMBER) IS

Line 10853: from wsh_new_deliveries wnd,

10849: -- of Trip to this Delivery.
10850: cursor l_pick_up_leg_csr( p_del_id IN VARCHAR2,
10851: p_pickup_locn_id IN NUMBER) is
10852: select wt.name, wnd.name
10853: from wsh_new_deliveries wnd,
10854: wsh_delivery_legs wdl,
10855: wsh_trip_stops wts,
10856: wsh_trips wt
10857: where wnd.delivery_id = p_del_id

Line 10870: from wsh_new_deliveries wnd,

10866: -- of Trip to this Delivery.
10867: cursor l_drop_off_leg_csr( p_del_id IN VARCHAR2,
10868: p_dropoff_locn_id IN NUMBER) is
10869: select wt.name, wnd.name
10870: from wsh_new_deliveries wnd,
10871: wsh_delivery_legs wdl,
10872: wsh_trip_stops wts,
10873: wsh_trips wt
10874: where wnd.delivery_id = p_del_id

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

11045: -- Build query for this delivery
11046:
11047: --Bug 6676749 Modified the query to Mark the delivery for Export Compliance for Both Outbound transaction('O') and Internal Order ('IO')
11048:
11049: l_strQuery := 'select wnd.delivery_id from wsh_new_deliveries wnd ' ||
11050: -- ' where wnd.shipment_direction = ''O'' ';
11051: ' where wnd.shipment_direction IN (''O'', ''IO'') ';
11052: l_Item_Condn1Tab(1).g_number_val := p_delivery_id;
11053: l_Item_Condn1Tab(1).g_Bind_Literal := ':b_delivery_id';

Line 11658: FROM WSH_NEW_DELIVERIES

11654: -- Get delivery info.
11655: CURSOR dlvy_csr (p_delivery_id NUMBER)
11656: IS
11657: SELECT shipping_control, routing_response_id
11658: FROM WSH_NEW_DELIVERIES
11659: WHERE delivery_id = p_delivery_id;
11660: --
11661: l_dlvy_rec dlvy_csr%ROWTYPE;
11662: --

Line 11813: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

11809: -- J-IB-NPARIKH-}
11810:
11811: --3509004:public api change
11812: PROCEDURE user_non_updatable_columns
11813: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11814: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11815: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
11816: x_return_status OUT NOCOPY VARCHAR2)
11817:

Line 11814: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

11810:
11811: --3509004:public api change
11812: PROCEDURE user_non_updatable_columns
11813: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11814: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
11815: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
11816: x_return_status OUT NOCOPY VARCHAR2)
11817:
11818: IS

Line 12955: wsh_new_deliveries wnd

12951: wt.status_code
12952: FROM wsh_trip_stops wts,
12953: wsh_delivery_legs wdl,
12954: wsh_trips wt,
12955: wsh_new_deliveries wnd
12956: WHERE wnd.delivery_id = p_del_id
12957: AND wdl.delivery_id = wnd.delivery_id
12958: AND wdl.pick_up_stop_id = wts.stop_id
12959: AND wnd.initial_pickup_location_id = wts.stop_location_id

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

13013: -------------------------------------------------------------------------------
13014: -- Procedure: GET_DELIVERY_INFORMATION
13015: -- Parameters: x_delivery_rec: A record of all attributes of a Delivery Record
13016: -- p_delivery_id : delivery_id of the delivery that is to be copied
13017: -- Description: This procedure will copy the attributes of a delivery in wsh_new_deliveries
13018: -- and copy it to a record.
13019: -------------------------------------------------------------------------------
13020:
13021: PROCEDURE GET_DELIVERY_INFORMATION

Line 13023: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

13019: -------------------------------------------------------------------------------
13020:
13021: PROCEDURE GET_DELIVERY_INFORMATION
13022: (p_delivery_id IN NUMBER,
13023: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
13024: x_return_status OUT NOCOPY VARCHAR2) IS
13025:
13026: CURSOR c_get_delivery_info (p_delivery_id IN NUMBER) IS
13027: SELECT DELIVERY_ID

Line 13052: FROM wsh_new_deliveries

13048: ,WV_FROZEN_FLAG
13049: ,TMS_INTERFACE_FLAG
13050: ,TMS_VERSION_NUMBER
13051: ,client_id -- LSP PROJECT (used in wshddacb. assign_dd_to_del
13052: FROM wsh_new_deliveries
13053: WHERE delivery_id = p_delivery_id;
13054:
13055: l_debug_on BOOLEAN;
13056: --