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_PVT

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 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 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 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 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 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 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 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 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 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 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 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 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 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