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_NEW_DELIVERY_ACTIONS dependencies on WSH_NEW_DELIVERIES_PVT

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

445: IF (nvl(l_del_valid_flag,'Y') = 'N') THEN
446: --
447: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_SC_CNT_ERROR');
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
450: END IF;
451:
452: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
453: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);

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

448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
450: END IF;
451:
452: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
453: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
454: --
455: END IF;
456: --

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

529: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
530: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_FIRM_ERROR');
531:
532: IF l_debug_on THEN
533: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
534: END IF;
535:
536: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
537: wsh_util_core.add_message(x_return_status);

Line 536: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

532: IF l_debug_on THEN
533: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
534: END IF;
535:
536: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
537: wsh_util_core.add_message(x_return_status);
538: l_num_error := l_num_error + 1;
539: goto loop_end;
540: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 698: l_auto_rate_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

694: l_num_of_staged_lines NUMBER := 0;
695: l_ignore_count NUMBER := 0;
696: l_delivery_detail_count NUMBER := 0;
697: l_delivery_id NUMBER := 0;
698: l_auto_rate_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
699: l_select_carrier_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
700: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
701: l_return_status VARCHAR2(1);
702: l_status_code VARCHAR2(30) := 'OP';

Line 699: l_select_carrier_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

695: l_ignore_count NUMBER := 0;
696: l_delivery_detail_count NUMBER := 0;
697: l_delivery_id NUMBER := 0;
698: l_auto_rate_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
699: l_select_carrier_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
700: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
701: l_return_status VARCHAR2(1);
702: l_status_code VARCHAR2(30) := 'OP';
703: l_dels_to_update WSH_UTIL_CORE.Id_Tab_Type;

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

788: --
789: -- Debug Statements
790: --
791: IF l_debug_on THEN
792: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
793: END IF;
794: --
795: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
796: wsh_util_core.add_message(x_return_status);

Line 795: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));

791: IF l_debug_on THEN
792: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
793: END IF;
794: --
795: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
796: wsh_util_core.add_message(x_return_status);
797: l_num_error := l_num_error + 1;
798: goto loop_end;
799: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

1040: --
1041: -- Debug Statements
1042: --
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1045: END IF;
1046: --
1047: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
1048: wsh_util_core.add_message(x_return_status);

Line 1047: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));

1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1045: END IF;
1046: --
1047: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
1048: wsh_util_core.add_message(x_return_status);
1049: l_num_error := l_num_error + 1;
1050: goto end_of_loop;
1051: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

1165: --
1166: -- Debug Statements
1167: --
1168: IF l_debug_on THEN
1169: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1170: END IF;
1171: --
1172: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
1173: wsh_util_core.add_message(x_return_status);

Line 1172: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));

1168: IF l_debug_on THEN
1169: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1170: END IF;
1171: --
1172: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
1173: wsh_util_core.add_message(x_return_status);
1174: l_num_error := l_num_error + 1;
1175: goto end_of_loop;
1176: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

1237: --
1238: -- Debug Statements
1239: --
1240: IF l_debug_on THEN
1241: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1242: END IF;
1243: --
1244: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
1245: wsh_util_core.add_message(x_return_status);

Line 1244: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));

1240: IF l_debug_on THEN
1241: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1242: END IF;
1243: --
1244: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_ids(i)));
1245: wsh_util_core.add_message(x_return_status);
1246: l_num_error := l_num_error + 1;
1247: goto end_of_loop;
1248: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

1633: --
1634: -- Debug Statements
1635: --
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1638: END IF;
1639: --
1640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
1641: wsh_util_core.add_message(x_return_status);

Line 1640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1638: END IF;
1639: --
1640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
1641: wsh_util_core.add_message(x_return_status);
1642: l_num_error := l_num_error + 1;
1643: ELSE
1644:

Line 2987: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2983: b_tripalreadychecked VARCHAR2(1);
2984: l_count_hashtrip NUMBER;
2985:
2986: --dummy tables for calling validate_constraint_wrapper
2987: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2988: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2989: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2990: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2991: l_cc_in_ids wsh_util_core.id_tab_type;

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

3560: --
3561: -- Debug Statements
3562: --
3563: IF l_debug_on THEN
3564: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3565: END IF;
3566: --
3567: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3568: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS);

Line 3567: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3563: IF l_debug_on THEN
3564: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3565: END IF;
3566: --
3567: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3568: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS);
3569: goto loop_end ;
3570: END IF;
3571:

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

3594: --
3595: -- Debug Statements
3596: --
3597: IF l_debug_on THEN
3598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3599: END IF;
3600: --
3601: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3602: FND_MESSAGE.SET_TOKEN('SHIP_METHOD',l_ship_method_code);

Line 3601: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3597: IF l_debug_on THEN
3598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3599: END IF;
3600: --
3601: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3602: FND_MESSAGE.SET_TOKEN('SHIP_METHOD',l_ship_method_code);
3603: FND_MESSAGE.SET_TOKEN('ORG_ID',l_organization_id);
3604: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
3605: x_return_Status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

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

3620: --
3621: -- Debug Statements
3622: --
3623: IF l_debug_on THEN
3624: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3625: END IF;
3626: --
3627: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3628: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3627: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3623: IF l_debug_on THEN
3624: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3625: END IF;
3626: --
3627: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3628: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3629: wsh_util_core.add_message(x_return_status);
3630:
3631: l_num_warn := l_num_warn + 1;

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

3659: --
3660: -- Debug Statements
3661: --
3662: IF l_debug_on THEN
3663: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3664: END IF;
3665: --
3666: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3667: wsh_util_core.add_message(x_return_status);

Line 3666: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3662: IF l_debug_on THEN
3663: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3664: END IF;
3665: --
3666: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3667: wsh_util_core.add_message(x_return_status);
3668: if ( x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR ) then
3669: l_num_error := l_num_error + 1 ;
3670: goto loop_end ;

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

3689: --
3690: -- Debug Statements
3691: --
3692: IF l_debug_on THEN
3693: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3694: END IF;
3695: --
3696: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3697: wsh_util_core.add_message(x_return_status);

Line 3696: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3692: IF l_debug_on THEN
3693: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3694: END IF;
3695: --
3696: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3697: wsh_util_core.add_message(x_return_status);
3698: END IF;
3699: --
3700: IF (nvl(l_del_valid_flag,'Y') = 'N') THEN

Line 3805: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3801: ELSE
3802: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3803: END IF;
3804: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_entity_name);
3805: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3806: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR',l_exc_beh_error);
3807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3808: wsh_util_core.add_message(x_return_status);
3809: l_num_error := l_num_error + 1 ;

Line 3815: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3811: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
3812: IF l_exceptions_tab(exp_cnt).entity_name = 'DELIVERY' THEN
3813: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
3814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_entity_name);
3815: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3816: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR',l_exc_beh_warn);
3817: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3818: wsh_util_core.add_message(x_return_status);
3819: l_num_warn := l_num_warn + 1 ;

Line 3823: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

3819: l_num_warn := l_num_warn + 1 ;
3820: ELSIF NOT (l_exp_logged) THEN
3821: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3822: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_entity_name);
3823: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3824: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR',l_exc_beh_warn);
3825: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3826: l_exp_logged := TRUE;
3827: wsh_util_core.add_message(x_return_status);

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

4108: --
4109: -- Debug Statements
4110: --
4111: IF l_debug_on THEN
4112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4113: END IF;
4114: --
4115: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4116: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4115: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

4111: IF l_debug_on THEN
4112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4113: END IF;
4114: --
4115: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4116: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4117: wsh_util_core.add_message(x_return_status);
4118: l_num_warn := l_num_warn + 1;
4119:

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

4760: --
4761: -- Debug Statements
4762: --
4763: IF l_debug_on THEN
4764: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4765: END IF;
4766: --
4767: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
4768: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);

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

4763: IF l_debug_on THEN
4764: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4765: END IF;
4766: --
4767: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
4768: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
4769: l_num_error := l_num_error + 1;
4770: goto confirm_error_no_msg;
4771: ELSE

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

5231: --
5232: -- Debug Statements
5233: --
5234: IF l_debug_on THEN
5235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5236: END IF;
5237: --
5238: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5239: x_return_status := l_return_status;

Line 5238: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

5234: IF l_debug_on THEN
5235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5236: END IF;
5237: --
5238: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5239: x_return_status := l_return_status;
5240: wsh_util_core.add_message(x_return_status);
5241: l_num_error := l_num_error + 1 ;
5242: goto loop_end;

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

5492:
5493: IF (l_param_info.percent_fill_basis_flag = 'W' and l_gross_weight is NULL) THEN
5494: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
5495: IF l_debug_on THEN
5496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5497: END IF;
5498: --
5499: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5500: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

Line 5500: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

5496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5497: END IF;
5498: --
5499: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5500: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5501: FND_MESSAGE.SET_TOKEN('WV','Weight');
5502: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5503: wsh_util_core.add_message(x_return_status);
5504: l_num_warn := l_num_warn + 1;

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

5506:
5507: IF (l_param_info.percent_fill_basis_flag = 'V' and l_volume is NULL) THEN
5508: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
5509: IF l_debug_on THEN
5510: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5511: END IF;
5512: --
5513: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5514: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

Line 5514: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

5510: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5511: END IF;
5512: --
5513: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5514: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5515: FND_MESSAGE.SET_TOKEN('WV','Volume');
5516: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5517: wsh_util_core.add_message(x_return_status);
5518: l_num_warn := l_num_warn + 1;

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

5640: --
5641: -- Debug Statements
5642: --
5643: IF l_debug_on THEN
5644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5645: END IF;
5646: --
5647: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5648: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5647: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

5643: IF l_debug_on THEN
5644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5645: END IF;
5646: --
5647: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5648: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5649: wsh_util_core.add_message(x_return_status);
5650: goto confirm_error_no_msg;
5651:

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

5726: --
5727: -- Debug Statements
5728: --
5729: IF l_debug_on THEN
5730: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5731: END IF;
5732: --
5733: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5734: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5733: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

5729: IF l_debug_on THEN
5730: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5731: END IF;
5732: --
5733: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5734: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5735: wsh_util_core.add_message(x_return_status);
5736: l_num_warn := l_num_warn + 1;
5737: END IF;

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

5829: IF l_cc_failed_records.COUNT>0 THEN
5830:
5831: IF l_debug_on THEN
5832: wsh_debug_sv.logmsg(l_module_name,'all lines errored in compatibility check');
5833: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5834: END IF;
5835:
5836: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
5837: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

Line 5837: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

5833: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5834: END IF;
5835:
5836: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
5837: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5838: x_return_status := l_return_status;
5839: wsh_util_core.add_message(x_return_status);
5840: goto confirm_error;
5841: ELSE

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

5877: x_return_status := l_return_status;
5878: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AUTOCREATE_TRIP_ERROR');
5879:
5880: IF l_debug_on THEN
5881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5882: END IF;
5883: --
5884: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5885: wsh_util_core.add_message(x_return_status);

Line 5884: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

5880: IF l_debug_on THEN
5881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5882: END IF;
5883: --
5884: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5885: wsh_util_core.add_message(x_return_status);
5886: goto confirm_error;
5887: END IF;
5888: END IF;

Line 6050: FND_MESSAGE.SET_TOKEN('DLVY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

6046:
6047: WHEN app_exception.application_exception OR app_exception.record_lock_exception THEN
6048: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6049: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_STOP_TRIP_LOCK');
6050: FND_MESSAGE.SET_TOKEN('DLVY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6051: wsh_util_core.add_message(x_return_status);
6052: goto confirm_error;
6053:
6054: END;

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

6177: IF l_cc_fail_ids.COUNT>0 THEN
6178:
6179: IF l_debug_on THEN
6180: wsh_debug_sv.logmsg(l_module_name,'all lines errored in compatibility check');
6181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6182: END IF;
6183:
6184: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
6185: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

Line 6185: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

6181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6182: END IF;
6183:
6184: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
6185: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6186: x_return_status := l_return_status;
6187: wsh_util_core.add_message(x_return_status);
6188: goto confirm_error;
6189: ELSE

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

6426: --
6427: -- Debug Statements
6428: --
6429: IF l_debug_on THEN
6430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6431: END IF;
6432: --
6433: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 6433: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

6429: IF l_debug_on THEN
6430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6431: END IF;
6432: --
6433: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6435: wsh_util_core.add_message(x_return_status);
6436: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6437: l_num_warn := l_num_warn + 1;

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

6508: --
6509: -- Debug Statements
6510: --
6511: IF l_debug_on THEN
6512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6513: END IF;
6514: --
6515: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6516: wsh_util_core.add_message(x_return_status);

Line 6515: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

6511: IF l_debug_on THEN
6512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6513: END IF;
6514: --
6515: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6516: wsh_util_core.add_message(x_return_status);
6517:
6518: /* H integration: 940/945 wrudge */
6519: <>

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

6752: --
6753: -- Debug Statements
6754: --
6755: IF l_debug_on THEN
6756: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6757: END IF;
6758: --
6759:
6760: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));

Line 6760: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));

6756: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6757: END IF;
6758: --
6759:
6760: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6762: wsh_util_core.add_message(x_return_status);
6763: l_num_warn := l_num_warn + 1;
6764: END IF;

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

6790: -- Debug Statements
6791: --
6792:
6793: IF l_debug_on THEN
6794: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6795: END IF;
6796: --
6797: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6798: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 6797: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));

6793: IF l_debug_on THEN
6794: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6795: END IF;
6796: --
6797: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6798: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6799: wsh_util_core.add_message(x_return_status);
6800: l_num_warn := l_num_warn + 1;
6801: END IF;

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

6862: --
6863: -- Debug Statements
6864: --
6865: IF l_debug_on THEN
6866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6867: END IF;
6868: --
6869: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6870: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 6869: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));

6865: IF l_debug_on THEN
6866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6867: END IF;
6868: --
6869: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6870: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6871: wsh_util_core.add_message(x_return_status);
6872: l_num_warn := l_num_warn + 1;
6873: END IF;

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

6900: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
6901: l_num_error := l_num_error + 1;
6902: ELSE
6903: IF l_debug_on THEN
6904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6905: END IF;
6906: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6907: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6908: wsh_util_core.add_message(x_return_status);

Line 6906: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));

6902: ELSE
6903: IF l_debug_on THEN
6904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6905: END IF;
6906: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6907: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6908: wsh_util_core.add_message(x_return_status);
6909: l_num_warn := l_num_warn + 1;
6910: END IF;

Line 7003: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),

6999: --OTM R12, when setting delivery to closed, set the tms flag
7000: TMS_INTERFACE_FLAG = DECODE(l_gc3_is_installed,
7001: 'Y', DECODE(NVL(u_status_code(i), 'XXXXX'),
7002: 'CL', DECODE(NVL(tms_interface_flag,
7003: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7004: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7005: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

Line 7004: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

7000: TMS_INTERFACE_FLAG = DECODE(l_gc3_is_installed,
7001: 'Y', DECODE(NVL(u_status_code(i), 'XXXXX'),
7002: 'CL', DECODE(NVL(tms_interface_flag,
7003: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7004: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7005: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

Line 7005: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

7001: 'Y', DECODE(NVL(u_status_code(i), 'XXXXX'),
7002: 'CL', DECODE(NVL(tms_interface_flag,
7003: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7004: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7005: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7009: NVL(tms_interface_flag,

Line 7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

7002: 'CL', DECODE(NVL(tms_interface_flag,
7003: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7004: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7005: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7009: NVL(tms_interface_flag,
7010: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

Line 7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

7003: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7004: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7005: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7009: NVL(tms_interface_flag,
7010: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7011: NVL(tms_interface_flag,

Line 7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

7004: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7005: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7009: NVL(tms_interface_flag,
7010: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7011: NVL(tms_interface_flag,
7012: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

Line 7010: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

7006: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7007: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7009: NVL(tms_interface_flag,
7010: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7011: NVL(tms_interface_flag,
7012: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7013: --END OTM R12
7014: last_update_date = SYSDATE ,

Line 7012: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

7008: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7009: NVL(tms_interface_flag,
7010: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7011: NVL(tms_interface_flag,
7012: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7013: --END OTM R12
7014: last_update_date = SYSDATE ,
7015: last_updated_by = l_user_id,
7016: last_update_login = l_login_id,

Line 7102: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(l_ctr)));

7098: aname => 'ACTUAL_DATE',
7099: avalue => P_ACTUAL_DEP_DATE);
7100:
7101: FND_MESSAGE.SET_NAME('WSH','WSH_WF_SCPOD_LAUNCHED');
7102: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(l_ctr)));
7103: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS,l_module_name);
7104:
7105: END IF;
7106: END LOOP;

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

7152: --
7153: -- Debug Statements
7154: --
7155: IF l_debug_on THEN
7156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7157: END IF;
7158: --
7159: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
7160: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 7159: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

7155: IF l_debug_on THEN
7156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7157: END IF;
7158: --
7159: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
7160: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7161: wsh_util_core.add_message(x_return_status);
7162: l_num_warn := l_num_warn + 1;
7163: END IF;

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

7341: --
7342: -- Debug Statements
7343: --
7344: IF l_debug_on THEN
7345: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7346: END IF;
7347: --
7348: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
7349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

7344: IF l_debug_on THEN
7345: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7346: END IF;
7347: --
7348: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
7349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7350: wsh_util_core.add_message(x_return_status);
7351: WSH_UTIL_CORE.Store_Msg_In_Table (p_store_flag => FALSE,
7352: x_msg_rec_count => l_msg_rec_count,

Line 8018: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),

8014: status_code = 'CL',
8015: --OTM R12, when setting delivery to closed, set tms flag
8016: tms_interface_flag = DECODE(l_gc3_is_installed,
8017: 'Y', DECODE(NVL(tms_interface_flag,
8018: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
8019: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8020: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

Line 8019: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

8015: --OTM R12, when setting delivery to closed, set tms flag
8016: tms_interface_flag = DECODE(l_gc3_is_installed,
8017: 'Y', DECODE(NVL(tms_interface_flag,
8018: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
8019: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8020: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8023: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

Line 8020: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

8016: tms_interface_flag = DECODE(l_gc3_is_installed,
8017: 'Y', DECODE(NVL(tms_interface_flag,
8018: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
8019: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8020: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8023: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
8024: NVL(tms_interface_flag,

Line 8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

8017: 'Y', DECODE(NVL(tms_interface_flag,
8018: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
8019: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8020: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8023: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
8024: NVL(tms_interface_flag,
8025: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

Line 8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

8018: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
8019: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8020: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8023: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
8024: NVL(tms_interface_flag,
8025: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
8026: --

Line 8023: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

8019: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8020: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8023: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
8024: NVL(tms_interface_flag,
8025: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
8026: --
8027: last_update_date = SYSDATE ,

Line 8025: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

8021: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8022: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
8023: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
8024: NVL(tms_interface_flag,
8025: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
8026: --
8027: last_update_date = SYSDATE ,
8028: last_updated_by = l_user_id,
8029: last_update_login = l_login_id

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

8921: CLOSE pickup_delivery_legs;
8922:
8923: IF (p_insert_msg) THEN
8924: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');
8925: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8926: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8927: END IF;
8928:
8929: IF l_debug_on THEN

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

8940:
8941: IF (l_count > 1) THEN
8942: IF (p_insert_msg) THEN
8943: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');
8944: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8945: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8946: END IF;
8947:
8948: IF l_debug_on THEN

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

8960: IF (l_seq_num <> l_leg_count) THEN
8961:
8962: IF (p_insert_msg) THEN
8963: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_INVALID_FLOW');
8964: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8965: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8966: END IF;
8967: --
8968: IF l_debug_on THEN

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

8977: x_leg_complete := 'NW';
8978:
8979: IF (p_insert_msg) THEN
8980: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NO_ULTIMATE_DROPOFF');
8981: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8982: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8983: END IF;
8984: RETURN;
8985: END IF;

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

9275: --
9276: -- Debug Statements
9277: --
9278: IF l_debug_on THEN
9279: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9280: END IF;
9281: --
9282: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9283: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 9282: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

9278: IF l_debug_on THEN
9279: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9280: END IF;
9281: --
9282: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9283: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9284: wsh_util_core.add_message(x_return_status);
9285: l_num_error := l_num_error + 1;
9286: goto loop_end;

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

9348: --
9349: -- Debug Statements
9350: --
9351: IF l_debug_on THEN
9352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9353: END IF;
9354: --
9355: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9356: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 9355: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

9351: IF l_debug_on THEN
9352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9353: END IF;
9354: --
9355: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9356: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9357: wsh_util_core.add_message(x_return_status);
9358: l_num_error := l_num_error + 1;
9359: EXIT;

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

9370: --
9371: -- Debug Statements
9372: --
9373: IF l_debug_on THEN
9374: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9375: END IF;
9376: --
9377: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 9377: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

9373: IF l_debug_on THEN
9374: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9375: END IF;
9376: --
9377: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9379: wsh_util_core.add_message(x_return_status);
9380: l_num_error := l_num_error + 1;
9381: END IF;

Line 9452: l_del_info wsh_new_deliveries_pvt.delivery_rec_type;

9448: (p_delivery_id IN NUMBER,
9449: p_del_params IN wsh_delivery_autocreate.grp_attr_rec_type,
9450: x_return_status OUT NOCOPY VARCHAR2) IS
9451:
9452: l_del_info wsh_new_deliveries_pvt.delivery_rec_type;
9453:
9454: --
9455: l_debug_on BOOLEAN;
9456: --

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

9478: --
9479: -- Debug Statements
9480: --
9481: IF l_debug_on THEN
9482: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
9483: END IF;
9484: --
9485: wsh_new_deliveries_pvt.populate_record( p_delivery_id, l_del_info, x_return_status);
9486:

Line 9485: wsh_new_deliveries_pvt.populate_record( p_delivery_id, l_del_info, x_return_status);

9481: IF l_debug_on THEN
9482: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
9483: END IF;
9484: --
9485: wsh_new_deliveries_pvt.populate_record( p_delivery_id, l_del_info, x_return_status);
9486:
9487: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
9488: --
9489: -- Debug Statements

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

9520: --
9521: -- Debug Statements
9522: --
9523: IF l_debug_on THEN
9524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
9525: END IF;
9526: --
9527: wsh_new_deliveries_pvt.update_delivery( null, l_del_info, x_return_status);
9528:

Line 9527: wsh_new_deliveries_pvt.update_delivery( null, l_del_info, x_return_status);

9523: IF l_debug_on THEN
9524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
9525: END IF;
9526: --
9527: wsh_new_deliveries_pvt.update_delivery( null, l_del_info, x_return_status);
9528:
9529: --}
9530: END IF;
9531:

Line 11256: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --

11252: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11255: -- --
11256: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11257: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11258: --
11259: --
11260: -- RETURN: none --

Line 11287: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

11283:
11284: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11285: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11286: p_caller IN VARCHAR2 DEFAULT NULL,
11287: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11288: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11289: x_return_message OUT NOCOPY VARCHAR2,
11290: x_return_status OUT NOCOPY VARCHAR2) IS
11291:

Line 11855: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

11851: --
11852:
11853: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11854: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11855: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11856: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11857: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11858: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11859: l_msg_count NUMBER;

Line 12970: p_del_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

12966: -- x_return_status: status
12967: **/
12968:
12969: Procedure Assign_Del_to_Consol_Del(
12970: p_del_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
12971: p_parent_del_id IN NUMBER,
12972: p_caller IN VARCHAR2,
12973: x_return_status OUT NOCOPY VARCHAR2) IS
12974:

Line 13277: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_valid_children_tab(i)));

13273: EXCEPTION
13274: WHEN OTHERS THEN
13275: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13276: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
13277: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_valid_children_tab(i)));
13278: WSH_UTIL_CORE.Add_Message(x_return_status);
13279: --
13280: -- Debug Statements
13281: --

Line 13499: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_valid_children_tab(i)));

13495: EXCEPTION
13496: WHEN OTHERS THEN
13497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13498: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
13499: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_valid_children_tab(i)));
13500: WSH_UTIL_CORE.Add_Message(x_return_status);
13501: --
13502: -- Debug Statements
13503: --

Line 13955: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));

13951: FETCH check_consol_lpns INTO l_consol_lpn_dummy;
13952: IF check_consol_lpns%FOUND THEN
13953: CLOSE check_consol_lpns;
13954: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_UNASSIGN_DEL_LPN');
13955: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));
13956: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13957: wsh_util_core.add_message(l_return_status, l_module_name);
13958: wsh_util_core.api_post_call
13959: (

Line 13992: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));

13988: EXCEPTION
13989: WHEN OTHERS THEN
13990: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13991: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
13992: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));
13993: WSH_UTIL_CORE.Add_Message(x_return_status);
13994: --
13995: -- Debug Statements
13996: --

Line 14062: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));

14058: EXCEPTION
14059: WHEN OTHERS THEN
14060: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14061: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_DEL_LEG_LOCK');
14062: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));
14063: WSH_UTIL_CORE.Add_Message(x_return_status);
14064: --
14065: -- Debug Statements
14066: --

Line 14465: WSH_NEW_DELIVERIES_PVT.Lock_Dlvy_No_Compare(l_co_consol_del_tab(l));

14461: IF l_debug_on THEN
14462: WSH_DEBUG_SV.log(l_module_name,'l_co_consol_del_tab(l)', l_co_consol_del_tab(l));
14463: END IF;
14464: l_lock_index := l;
14465: WSH_NEW_DELIVERIES_PVT.Lock_Dlvy_No_Compare(l_co_consol_del_tab(l));
14466:
14467: l_lpn_number := 0;
14468: OPEN c_get_child_lpn_number(l_co_consol_del_tab(l));
14469: FETCH c_get_child_lpn_number

Line 14488: FND_MESSAGE.Set_Token('ENTITY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_co_consol_del_tab(l_lock_index)));

14484: EXCEPTION
14485: WHEN OTHERS THEN
14486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14487: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
14488: FND_MESSAGE.Set_Token('ENTITY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_co_consol_del_tab(l_lock_index)));
14489: WSH_UTIL_CORE.Add_Message(x_return_status);
14490: --
14491: -- Debug Statements
14492: --