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 2949: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2945: b_tripalreadychecked VARCHAR2(1);
2946: l_count_hashtrip NUMBER;
2947:
2948: --dummy tables for calling validate_constraint_wrapper
2949: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2950: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2951: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2952: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2953: l_cc_in_ids wsh_util_core.id_tab_type;

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

3507: --
3508: -- Debug Statements
3509: --
3510: IF l_debug_on THEN
3511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3512: END IF;
3513: --
3514: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3515: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS);

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

3510: IF l_debug_on THEN
3511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3512: END IF;
3513: --
3514: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3515: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS);
3516: goto loop_end ;
3517: END IF;
3518:

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

3541: --
3542: -- Debug Statements
3543: --
3544: IF l_debug_on THEN
3545: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3546: END IF;
3547: --
3548: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3549: FND_MESSAGE.SET_TOKEN('SHIP_METHOD',l_ship_method_code);

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

3544: IF l_debug_on THEN
3545: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3546: END IF;
3547: --
3548: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3549: FND_MESSAGE.SET_TOKEN('SHIP_METHOD',l_ship_method_code);
3550: FND_MESSAGE.SET_TOKEN('ORG_ID',l_organization_id);
3551: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
3552: x_return_Status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

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

3567: --
3568: -- Debug Statements
3569: --
3570: IF l_debug_on THEN
3571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3572: END IF;
3573: --
3574: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3575: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

3570: IF l_debug_on THEN
3571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3572: END IF;
3573: --
3574: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3575: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3576: wsh_util_core.add_message(x_return_status);
3577:
3578: l_num_warn := l_num_warn + 1;

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_del_rows(i)));
3614: wsh_util_core.add_message(x_return_status);

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

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_del_rows(i)));
3614: wsh_util_core.add_message(x_return_status);
3615: if ( x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR ) then
3616: l_num_error := l_num_error + 1 ;
3617: goto loop_end ;

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

3636: --
3637: -- Debug Statements
3638: --
3639: IF l_debug_on THEN
3640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3641: END IF;
3642: --
3643: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3644: wsh_util_core.add_message(x_return_status);

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

3639: IF l_debug_on THEN
3640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3641: END IF;
3642: --
3643: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3644: wsh_util_core.add_message(x_return_status);
3645: END IF;
3646: --
3647: IF (nvl(l_del_valid_flag,'Y') = 'N') THEN

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

3748: ELSE
3749: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3750: END IF;
3751: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_entity_name);
3752: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3753: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR',l_exc_beh_error);
3754: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3755: wsh_util_core.add_message(x_return_status);
3756: l_num_error := l_num_error + 1 ;

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

3758: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
3759: IF l_exceptions_tab(exp_cnt).entity_name = 'DELIVERY' THEN
3760: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
3761: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_entity_name);
3762: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3763: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR',l_exc_beh_warn);
3764: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3765: wsh_util_core.add_message(x_return_status);
3766: l_num_warn := l_num_warn + 1 ;

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

3766: l_num_warn := l_num_warn + 1 ;
3767: ELSIF NOT (l_exp_logged) THEN
3768: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3769: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_entity_name);
3770: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
3771: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR',l_exc_beh_warn);
3772: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3773: l_exp_logged := TRUE;
3774: wsh_util_core.add_message(x_return_status);

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

4055: --
4056: -- Debug Statements
4057: --
4058: IF l_debug_on THEN
4059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4060: END IF;
4061: --
4062: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

4058: IF l_debug_on THEN
4059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4060: END IF;
4061: --
4062: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4064: wsh_util_core.add_message(x_return_status);
4065: l_num_warn := l_num_warn + 1;
4066:

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(l_delivery_id));
4684: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 4683: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_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(l_delivery_id));
4684: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
4685: l_num_error := l_num_error + 1;
4686: goto confirm_error_no_msg;
4687: ELSE

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

5147: --
5148: -- Debug Statements
5149: --
5150: IF l_debug_on THEN
5151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5152: END IF;
5153: --
5154: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5155: x_return_status := l_return_status;

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

5150: IF l_debug_on THEN
5151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5152: END IF;
5153: --
5154: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5155: x_return_status := l_return_status;
5156: wsh_util_core.add_message(x_return_status);
5157: l_num_error := l_num_error + 1 ;
5158: goto loop_end;

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

5391:
5392: IF (l_param_info.percent_fill_basis_flag = 'W' and l_gross_weight is NULL) THEN
5393: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
5394: IF l_debug_on THEN
5395: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5396: END IF;
5397: --
5398: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5399: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

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

5395: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5396: END IF;
5397: --
5398: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5399: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5400: FND_MESSAGE.SET_TOKEN('WV','Weight');
5401: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5402: wsh_util_core.add_message(x_return_status);
5403: l_num_warn := l_num_warn + 1;

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

5405:
5406: IF (l_param_info.percent_fill_basis_flag = 'V' and l_volume is NULL) THEN
5407: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
5408: IF l_debug_on THEN
5409: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5410: END IF;
5411: --
5412: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5413: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

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

5409: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5410: END IF;
5411: --
5412: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Delivery');
5413: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5414: FND_MESSAGE.SET_TOKEN('WV','Volume');
5415: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5416: wsh_util_core.add_message(x_return_status);
5417: l_num_warn := l_num_warn + 1;

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

5539: --
5540: -- Debug Statements
5541: --
5542: IF l_debug_on THEN
5543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5544: END IF;
5545: --
5546: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5547: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

5542: IF l_debug_on THEN
5543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5544: END IF;
5545: --
5546: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5547: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5548: wsh_util_core.add_message(x_return_status);
5549: goto confirm_error_no_msg;
5550:

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

5625: --
5626: -- Debug Statements
5627: --
5628: IF l_debug_on THEN
5629: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5630: END IF;
5631: --
5632: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5633: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

5628: IF l_debug_on THEN
5629: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5630: END IF;
5631: --
5632: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5633: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5634: wsh_util_core.add_message(x_return_status);
5635: l_num_warn := l_num_warn + 1;
5636: END IF;

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

5728: IF l_cc_failed_records.COUNT>0 THEN
5729:
5730: IF l_debug_on THEN
5731: wsh_debug_sv.logmsg(l_module_name,'all lines errored in compatibility check');
5732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5733: END IF;
5734:
5735: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
5736: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

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

5732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5733: END IF;
5734:
5735: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
5736: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5737: x_return_status := l_return_status;
5738: wsh_util_core.add_message(x_return_status);
5739: goto confirm_error;
5740: ELSE

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

5776: x_return_status := l_return_status;
5777: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AUTOCREATE_TRIP_ERROR');
5778:
5779: IF l_debug_on THEN
5780: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5781: END IF;
5782: --
5783: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5784: wsh_util_core.add_message(x_return_status);

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

5779: IF l_debug_on THEN
5780: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5781: END IF;
5782: --
5783: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5784: wsh_util_core.add_message(x_return_status);
5785: goto confirm_error;
5786: END IF;
5787: END IF;

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

5945:
5946: WHEN app_exception.application_exception OR app_exception.record_lock_exception THEN
5947: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5948: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_STOP_TRIP_LOCK');
5949: FND_MESSAGE.SET_TOKEN('DLVY_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
5950: wsh_util_core.add_message(x_return_status);
5951: goto confirm_error;
5952:
5953: END;

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

6076: IF l_cc_fail_ids.COUNT>0 THEN
6077:
6078: IF l_debug_on THEN
6079: wsh_debug_sv.logmsg(l_module_name,'all lines errored in compatibility check');
6080: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6081: END IF;
6082:
6083: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
6084: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

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

6080: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6081: END IF;
6082:
6083: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_COMP_FAILED');
6084: FND_MESSAGE.SET_TOKEN('DEL_ID',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6085: x_return_status := l_return_status;
6086: wsh_util_core.add_message(x_return_status);
6087: goto confirm_error;
6088: ELSE

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

6286: --
6287: -- Debug Statements
6288: --
6289: IF l_debug_on THEN
6290: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6291: END IF;
6292: --
6293: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6294: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

6289: IF l_debug_on THEN
6290: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6291: END IF;
6292: --
6293: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6294: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6295: wsh_util_core.add_message(x_return_status);
6296: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6297: l_num_warn := l_num_warn + 1;

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

6368: --
6369: -- Debug Statements
6370: --
6371: IF l_debug_on THEN
6372: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6373: END IF;
6374: --
6375: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6376: wsh_util_core.add_message(x_return_status);

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

6371: IF l_debug_on THEN
6372: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6373: END IF;
6374: --
6375: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6376: wsh_util_core.add_message(x_return_status);
6377:
6378: /* H integration: 940/945 wrudge */
6379: <>

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

6612: --
6613: -- Debug Statements
6614: --
6615: IF l_debug_on THEN
6616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6617: END IF;
6618: --
6619:
6620: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));

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

6616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6617: END IF;
6618: --
6619:
6620: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6621: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6622: wsh_util_core.add_message(x_return_status);
6623: l_num_warn := l_num_warn + 1;
6624: END IF;

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

6650: -- Debug Statements
6651: --
6652:
6653: IF l_debug_on THEN
6654: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6655: END IF;
6656: --
6657: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6658: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

6653: IF l_debug_on THEN
6654: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6655: END IF;
6656: --
6657: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6658: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6659: wsh_util_core.add_message(x_return_status);
6660: l_num_warn := l_num_warn + 1;
6661: END IF;

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

6722: --
6723: -- Debug Statements
6724: --
6725: IF l_debug_on THEN
6726: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6727: END IF;
6728: --
6729: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6730: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

6725: IF l_debug_on THEN
6726: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6727: END IF;
6728: --
6729: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6730: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6731: wsh_util_core.add_message(x_return_status);
6732: l_num_warn := l_num_warn + 1;
6733: END IF;

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

6760: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
6761: l_num_error := l_num_error + 1;
6762: ELSE
6763: IF l_debug_on THEN
6764: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6765: END IF;
6766: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6767: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6768: wsh_util_core.add_message(x_return_status);

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

6762: ELSE
6763: IF l_debug_on THEN
6764: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6765: END IF;
6766: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(i)));
6767: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6768: wsh_util_core.add_message(x_return_status);
6769: l_num_warn := l_num_warn + 1;
6770: END IF;

Line 6863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),

6859: --OTM R12, when setting delivery to closed, set the tms flag
6860: TMS_INTERFACE_FLAG = DECODE(l_gc3_is_installed,
6861: 'Y', DECODE(NVL(u_status_code(i), 'XXXXX'),
6862: 'CL', DECODE(NVL(tms_interface_flag,
6863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
6864: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6865: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

Line 6864: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

6860: TMS_INTERFACE_FLAG = DECODE(l_gc3_is_installed,
6861: 'Y', DECODE(NVL(u_status_code(i), 'XXXXX'),
6862: 'CL', DECODE(NVL(tms_interface_flag,
6863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
6864: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6865: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

Line 6865: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

6861: 'Y', DECODE(NVL(u_status_code(i), 'XXXXX'),
6862: 'CL', DECODE(NVL(tms_interface_flag,
6863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
6864: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6865: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
6869: NVL(tms_interface_flag,

Line 6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

6862: 'CL', DECODE(NVL(tms_interface_flag,
6863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
6864: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6865: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
6869: NVL(tms_interface_flag,
6870: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

Line 6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

6863: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
6864: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6865: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
6869: NVL(tms_interface_flag,
6870: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
6871: NVL(tms_interface_flag,

Line 6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

6864: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6865: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
6869: NVL(tms_interface_flag,
6870: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
6871: NVL(tms_interface_flag,
6872: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

Line 6870: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

6866: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6867: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
6869: NVL(tms_interface_flag,
6870: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
6871: NVL(tms_interface_flag,
6872: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
6873: --END OTM R12
6874: last_update_date = SYSDATE ,

Line 6872: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

6868: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
6869: NVL(tms_interface_flag,
6870: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
6871: NVL(tms_interface_flag,
6872: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
6873: --END OTM R12
6874: last_update_date = SYSDATE ,
6875: last_updated_by = l_user_id,
6876: last_update_login = l_login_id,

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

6958: aname => 'ACTUAL_DATE',
6959: avalue => P_ACTUAL_DEP_DATE);
6960:
6961: FND_MESSAGE.SET_NAME('WSH','WSH_WF_SCPOD_LAUNCHED');
6962: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(u_del_rows(l_ctr)));
6963: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS,l_module_name);
6964:
6965: END IF;
6966: END LOOP;

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

7012: --
7013: -- Debug Statements
7014: --
7015: IF l_debug_on THEN
7016: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7017: END IF;
7018: --
7019: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
7020: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

7015: IF l_debug_on THEN
7016: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7017: END IF;
7018: --
7019: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
7020: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7021: wsh_util_core.add_message(x_return_status);
7022: l_num_warn := l_num_warn + 1;
7023: END IF;

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

7201: --
7202: -- Debug Statements
7203: --
7204: IF l_debug_on THEN
7205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7206: END IF;
7207: --
7208: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
7209: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

7204: IF l_debug_on THEN
7205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7206: END IF;
7207: --
7208: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
7209: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7210: wsh_util_core.add_message(x_return_status);
7211: WSH_UTIL_CORE.Store_Msg_In_Table (p_store_flag => FALSE,
7212: x_msg_rec_count => l_msg_rec_count,

Line 7822: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),

7818: status_code = 'CL',
7819: --OTM R12, when setting delivery to closed, set tms flag
7820: tms_interface_flag = DECODE(l_gc3_is_installed,
7821: 'Y', DECODE(NVL(tms_interface_flag,
7822: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7823: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7824: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

Line 7823: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

7819: --OTM R12, when setting delivery to closed, set tms flag
7820: tms_interface_flag = DECODE(l_gc3_is_installed,
7821: 'Y', DECODE(NVL(tms_interface_flag,
7822: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7823: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7824: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7827: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

Line 7824: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

7820: tms_interface_flag = DECODE(l_gc3_is_installed,
7821: 'Y', DECODE(NVL(tms_interface_flag,
7822: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7823: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7824: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7827: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7828: NVL(tms_interface_flag,

Line 7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

7821: 'Y', DECODE(NVL(tms_interface_flag,
7822: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7823: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7824: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7827: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7828: NVL(tms_interface_flag,
7829: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

Line 7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

7822: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT),
7823: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7824: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7827: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7828: NVL(tms_interface_flag,
7829: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7830: --

Line 7827: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),

7823: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7824: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7827: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7828: NVL(tms_interface_flag,
7829: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7830: --
7831: last_update_date = SYSDATE ,

Line 7829: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

7825: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7826: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
7827: WSH_NEW_DELIVERIES_PVT.C_TMS_COMPLETED),
7828: NVL(tms_interface_flag,
7829: WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
7830: --
7831: last_update_date = SYSDATE ,
7832: last_updated_by = l_user_id,
7833: last_update_login = l_login_id

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

8725: CLOSE pickup_delivery_legs;
8726:
8727: IF (p_insert_msg) THEN
8728: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');
8729: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8730: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8731: END IF;
8732:
8733: IF l_debug_on THEN

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

8744:
8745: IF (l_count > 1) THEN
8746: IF (p_insert_msg) THEN
8747: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');
8748: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8749: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8750: END IF;
8751:
8752: IF l_debug_on THEN

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

8764: IF (l_seq_num <> l_leg_count) THEN
8765:
8766: IF (p_insert_msg) THEN
8767: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_INVALID_FLOW');
8768: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8769: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8770: END IF;
8771: --
8772: IF l_debug_on THEN

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

8781: x_leg_complete := 'NW';
8782:
8783: IF (p_insert_msg) THEN
8784: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NO_ULTIMATE_DROPOFF');
8785: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
8786: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8787: END IF;
8788: RETURN;
8789: END IF;

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

9079: --
9080: -- Debug Statements
9081: --
9082: IF l_debug_on THEN
9083: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9084: END IF;
9085: --
9086: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9087: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

9082: IF l_debug_on THEN
9083: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9084: END IF;
9085: --
9086: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9087: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9088: wsh_util_core.add_message(x_return_status);
9089: l_num_error := l_num_error + 1;
9090: goto loop_end;

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

9152: --
9153: -- Debug Statements
9154: --
9155: IF l_debug_on THEN
9156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9157: END IF;
9158: --
9159: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9160: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

9155: IF l_debug_on THEN
9156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9157: END IF;
9158: --
9159: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9160: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9161: wsh_util_core.add_message(x_return_status);
9162: l_num_error := l_num_error + 1;
9163: EXIT;

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

9174: --
9175: -- Debug Statements
9176: --
9177: IF l_debug_on THEN
9178: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9179: END IF;
9180: --
9181: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9182: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

9177: IF l_debug_on THEN
9178: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9179: END IF;
9180: --
9181: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
9182: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9183: wsh_util_core.add_message(x_return_status);
9184: l_num_error := l_num_error + 1;
9185: END IF;

Line 9256: l_del_info wsh_new_deliveries_pvt.delivery_rec_type;

9252: (p_delivery_id IN NUMBER,
9253: p_del_params IN wsh_delivery_autocreate.grp_attr_rec_type,
9254: x_return_status OUT NOCOPY VARCHAR2) IS
9255:
9256: l_del_info wsh_new_deliveries_pvt.delivery_rec_type;
9257:
9258: --
9259: l_debug_on BOOLEAN;
9260: --

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

9282: --
9283: -- Debug Statements
9284: --
9285: IF l_debug_on THEN
9286: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
9287: END IF;
9288: --
9289: wsh_new_deliveries_pvt.populate_record( p_delivery_id, l_del_info, x_return_status);
9290:

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

9285: IF l_debug_on THEN
9286: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
9287: END IF;
9288: --
9289: wsh_new_deliveries_pvt.populate_record( p_delivery_id, l_del_info, x_return_status);
9290:
9291: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
9292: --
9293: -- Debug Statements

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

9324: --
9325: -- Debug Statements
9326: --
9327: IF l_debug_on THEN
9328: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
9329: END IF;
9330: --
9331: wsh_new_deliveries_pvt.update_delivery( null, l_del_info, x_return_status);
9332:

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

9327: IF l_debug_on THEN
9328: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
9329: END IF;
9330: --
9331: wsh_new_deliveries_pvt.update_delivery( null, l_del_info, x_return_status);
9332:
9333: --}
9334: END IF;
9335:

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

11056: -- p_smc_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30 --
11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11059: -- --
11060: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11061: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11062: --
11063: --
11064: -- RETURN: none --

Line 11091: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

11087:
11088: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11089: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11090: p_caller IN VARCHAR2 DEFAULT NULL,
11091: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11092: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11093: x_return_message OUT NOCOPY VARCHAR2,
11094: x_return_status OUT NOCOPY VARCHAR2) IS
11095:

Line 11659: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

11655: --
11656:
11657: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11658: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11659: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11660: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11661: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11662: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11663: l_msg_count NUMBER;

Line 12773: p_del_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

12769: -- x_return_status: status
12770: **/
12771:
12772: Procedure Assign_Del_to_Consol_Del(
12773: p_del_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
12774: p_parent_del_id IN NUMBER,
12775: p_caller IN VARCHAR2,
12776: x_return_status OUT NOCOPY VARCHAR2) IS
12777:

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

13076: EXCEPTION
13077: WHEN OTHERS THEN
13078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13079: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
13080: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_valid_children_tab(i)));
13081: WSH_UTIL_CORE.Add_Message(x_return_status);
13082: --
13083: -- Debug Statements
13084: --

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

13298: EXCEPTION
13299: WHEN OTHERS THEN
13300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13301: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
13302: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_valid_children_tab(i)));
13303: WSH_UTIL_CORE.Add_Message(x_return_status);
13304: --
13305: -- Debug Statements
13306: --

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

13754: FETCH check_consol_lpns INTO l_consol_lpn_dummy;
13755: IF check_consol_lpns%FOUND THEN
13756: CLOSE check_consol_lpns;
13757: FND_MESSAGE.SET_NAME('WSH','WSH_FAIL_UNASSIGN_DEL_LPN');
13758: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));
13759: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13760: wsh_util_core.add_message(l_return_status, l_module_name);
13761: wsh_util_core.api_post_call
13762: (

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

13791: EXCEPTION
13792: WHEN OTHERS THEN
13793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13794: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
13795: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));
13796: WSH_UTIL_CORE.Add_Message(x_return_status);
13797: --
13798: -- Debug Statements
13799: --

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

13861: EXCEPTION
13862: WHEN OTHERS THEN
13863: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13864: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_DEL_LEG_LOCK');
13865: FND_MESSAGE.Set_Token('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_assigned_dels_tab(i)));
13866: WSH_UTIL_CORE.Add_Message(x_return_status);
13867: --
13868: -- Debug Statements
13869: --

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

14264: IF l_debug_on THEN
14265: WSH_DEBUG_SV.log(l_module_name,'l_co_consol_del_tab(l)', l_co_consol_del_tab(l));
14266: END IF;
14267: l_lock_index := l;
14268: WSH_NEW_DELIVERIES_PVT.Lock_Dlvy_No_Compare(l_co_consol_del_tab(l));
14269:
14270: l_lpn_number := 0;
14271: OPEN c_get_child_lpn_number(l_co_consol_del_tab(l));
14272: FETCH c_get_child_lpn_number

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

14287: EXCEPTION
14288: WHEN OTHERS THEN
14289: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14290: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_LOCK_FAILED');
14291: FND_MESSAGE.Set_Token('ENTITY_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(l_co_consol_del_tab(l_lock_index)));
14292: WSH_UTIL_CORE.Add_Message(x_return_status);
14293: --
14294: -- Debug Statements
14295: --