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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 7124: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

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

Line 7127: , x_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

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

Line 7697: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

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

Line 7698: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

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

Line 8311: , p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

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

Line 8312: , x_out_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_rec_type

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

Line 9287: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

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

Line 9292: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

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

Line 9296: l_db_col_rec WSH_NEW_DELIVERIES_PVT.Delivery_rec_type;

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

Line 11541: (p_user_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

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

Line 11542: p_out_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

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

Line 12744: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

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