DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_DELIVERY_VALIDATIONS

Line 524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PLAN',WSH_DEBUG_SV.C_PROC_LEVEL);

520: FOR i IN 1..p_del_rows.count LOOP
521:
522: -- Check if Delivery can be planned
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PLAN',WSH_DEBUG_SV.C_PROC_LEVEL);
525: END IF;
526:
527: wsh_delivery_validations.check_plan( p_del_rows(i), x_return_status);
528:

Line 527: wsh_delivery_validations.check_plan( p_del_rows(i), x_return_status);

523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PLAN',WSH_DEBUG_SV.C_PROC_LEVEL);
525: END IF;
526:
527: wsh_delivery_validations.check_plan( p_del_rows(i), x_return_status);
528:
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:

Line 781: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PLAN',WSH_DEBUG_SV.C_PROC_LEVEL);

777: --
778: -- Debug Statements
779: --
780: IF l_debug_on THEN
781: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PLAN',WSH_DEBUG_SV.C_PROC_LEVEL);
782: END IF;
783: --
784: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);
785:

Line 784: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);

780: IF l_debug_on THEN
781: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PLAN',WSH_DEBUG_SV.C_PROC_LEVEL);
782: END IF;
783: --
784: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);
785:
786: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
787: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_PLAN_ERROR');
788: --

Line 858: l_assigned_to_trip := WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip(

854: IF l_debug_on THEN
855: wsh_debug_sv.logmsg(l_module_name, 'found delivery '|| p_delivery_ids(i) );
856: END IF;
857:
858: l_assigned_to_trip := WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip(
859: p_delivery_id => p_delivery_ids(i),
860: x_return_status => l_return_status);
861:
862: WSH_SHIPPING_PARAMS_PVT.Get(

Line 935: l_assigned_to_trip := WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip(

931: IF l_debug_on THEN
932: wsh_debug_sv.logmsg(l_module_name, 'found delivery '|| p_delivery_ids(i) );
933: END IF;
934:
935: l_assigned_to_trip := WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip(
936: p_delivery_id => p_delivery_ids(i),
937: x_return_status => l_return_status);
938:
939: WSH_SHIPPING_PARAMS_PVT.Get(

Line 1036: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);

1032: END;
1033:
1034: IF l_planned_flag is not NULL THEN
1035: -- prepare to plan the delivery
1036: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);
1037:
1038: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1039: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_PLAN_ERROR');
1040: --

Line 1161: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);

1157:
1158: IF l_planned_flag is not NULL THEN
1159:
1160: -- prepare to plan the delivery
1161: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);
1162:
1163: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1164: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_PLAN_ERROR');
1165: --

Line 1233: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);

1229: FOR UPDATE NOWAIT;
1230:
1231: IF l_planned_flag is not NULL THEN
1232: -- prepare to plan the delivery
1233: wsh_delivery_validations.check_plan( p_delivery_ids(i), x_return_status,p_called_for_sc);
1234:
1235: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1236: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_PLAN_ERROR');
1237: --

Line 1626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN',WSH_DEBUG_SV.C_PROC_LEVEL);

1622: --
1623: -- Debug Statements
1624: --
1625: IF l_debug_on THEN
1626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN',WSH_DEBUG_SV.C_PROC_LEVEL);
1627: END IF;
1628: --
1629: wsh_delivery_validations.check_unplan( p_del_rows(i), x_return_status);
1630:

Line 1629: wsh_delivery_validations.check_unplan( p_del_rows(i), x_return_status);

1625: IF l_debug_on THEN
1626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_UNPLAN',WSH_DEBUG_SV.C_PROC_LEVEL);
1627: END IF;
1628: --
1629: wsh_delivery_validations.check_unplan( p_del_rows(i), x_return_status);
1630:
1631: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1632: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNPLAN_ERROR');
1633: --

Line 4743: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);

4739: --
4740: -- Debug Statements
4741: --
4742: IF l_debug_on THEN
4743: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
4744: END IF;
4745: --
4746: WSH_DELIVERY_VALIDATIONS.check_detail_for_confirm
4747: ( p_detail_id => l_shp_dd_ids(dd_count),

Line 4746: WSH_DELIVERY_VALIDATIONS.check_detail_for_confirm

4742: IF l_debug_on THEN
4743: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
4744: END IF;
4745: --
4746: WSH_DELIVERY_VALIDATIONS.check_detail_for_confirm
4747: ( p_detail_id => l_shp_dd_ids(dd_count),
4748: p_check_credit_init_flag => l_check_credit_init_flag, -- bug 2343058
4749: x_line_inv_flag_rec => l_inv_controls_rec,
4750: x_return_status => l_return_status);

Line 5442: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);

5438: IF l_param_info.export_screening_flag IN ('S', 'A') THEN
5439:
5440:
5441: IF l_debug_on THEN
5442: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
5443: END IF;
5444: --Bug 9326608 Changed l_itm_exc_flag to use i as index
5445: l_itm_exc_flag(i) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5446: (p_delivery_id => p_del_rows(i),

Line 5445: l_itm_exc_flag(i) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required

5441: IF l_debug_on THEN
5442: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
5443: END IF;
5444: --Bug 9326608 Changed l_itm_exc_flag to use i as index
5445: l_itm_exc_flag(i) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5446: (p_delivery_id => p_del_rows(i),
5447: x_return_status => l_return_status);
5448: IF l_debug_on THEN
5449: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);

Line 5449: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);

5445: l_itm_exc_flag(i) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5446: (p_delivery_id => p_del_rows(i),
5447: x_return_status => l_return_status);
5448: IF l_debug_on THEN
5449: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);
5450: WSH_DEBUG_SV.logmsg(l_module_name,'ITM flag: '||l_param_info.export_screening_flag);
5451: wsh_debug_sv.log(l_module_name,'l_itm_exc_flag for delivery: '|| p_del_rows(i),l_itm_exc_flag(i)); --Bug 9326608
5452: END IF;
5453:

Line 5614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);

5610: --
5611: -- Debug Statements
5612: --
5613: IF l_debug_on THEN
5614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
5615: END IF;
5616: --
5617: wsh_delivery_validations.check_confirm(
5618: p_delivery_id => p_del_rows(i),

Line 5617: wsh_delivery_validations.check_confirm(

5613: IF l_debug_on THEN
5614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
5615: END IF;
5616: --
5617: wsh_delivery_validations.check_confirm(
5618: p_delivery_id => p_del_rows(i),
5619: p_actual_dep_date => p_actual_dep_date,
5620: p_cont_exists_flag => l_cont_exists_flag ,
5621: p_enforce_packing_flag => l_enforce_packing_flag,

Line 6605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCES',WSH_DEBUG_SV.C_PROC_LEVEL);

6601: --
6602: -- Debug Statements
6603: --
6604: IF l_debug_on THEN
6605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCES',WSH_DEBUG_SV.C_PROC_LEVEL);
6606: END IF;
6607: --
6608: wsh_Delivery_validations.check_delivery_for_tolerances (
6609: p_delivery_id => p_del_rows(i) ,

Line 6608: wsh_Delivery_validations.check_delivery_for_tolerances (

6604: IF l_debug_on THEN
6605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCES',WSH_DEBUG_SV.C_PROC_LEVEL);
6606: END IF;
6607: --
6608: wsh_Delivery_validations.check_delivery_for_tolerances (
6609: p_delivery_id => p_del_rows(i) ,
6610: x_source_line_id => l_temp_line_id ,
6611: x_source_code => l_temp_source_code ,
6612: x_max_quantity => l_max_quantity ,

Line 6922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);

6918: --Bug 9326608 Changed l_itm_exc_flag to use i as index
6919: IF l_itm_exc_flag(i) = 'Y' THEN
6920:
6921: IF l_debug_on THEN
6922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
6923: END IF;
6924:
6925: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception
6926: (p_delivery_id => u_del_rows(i),

Line 6925: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception

6921: IF l_debug_on THEN
6922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
6923: END IF;
6924:
6925: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception
6926: (p_delivery_id => u_del_rows(i),
6927: p_action_type => 'SHIP_CONFIRM',
6928: p_ship_from_location_id => l_ship_from_location,
6929: x_return_status => l_return_status);

Line 7451: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,

7447: --========================================================================
7448: --
7449: PROCEDURE setInTransit
7450: (
7451: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,
7452: x_return_status OUT NOCOPY VARCHAR2
7453: )
7454: IS
7455: --{

Line 7924: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,

7920: --========================================================================
7921: --
7922: PROCEDURE setClose
7923: (
7924: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,
7925: x_return_status OUT NOCOPY VARCHAR2
7926: )
7927: IS
7928: --{

Line 8279: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;

8275: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CHANGE_STATUS';
8276: --
8277: l_return_status VARCHAR2(30);
8278: l_allowed VARCHAR2(10);
8279: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
8280: --
8281: l_num_warnings NUMBER;
8282: l_num_errors NUMBER;
8283: l_num_dels_processed NUMBER;

Line 8375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);

8371: --
8372: -- Debug Statements
8373: --
8374: IF l_debug_on THEN
8375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8376: END IF;
8377: --
8378: WSH_DELIVERY_VALIDATIONS.check_inTransit
8379: (

Line 8378: WSH_DELIVERY_VALIDATIONS.check_inTransit

8374: IF l_debug_on THEN
8375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8376: END IF;
8377: --
8378: WSH_DELIVERY_VALIDATIONS.check_inTransit
8379: (
8380: p_in_rec => l_in_rec,
8381: x_return_status => l_return_status,
8382: x_allowed => l_Allowed

Line 8453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);

8449: --
8450: -- Debug Statements
8451: --
8452: IF l_debug_on THEN
8453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8454: END IF;
8455: --
8456: WSH_DELIVERY_VALIDATIONS.check_close
8457: (

Line 8456: WSH_DELIVERY_VALIDATIONS.check_close

8452: IF l_debug_on THEN
8453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8454: END IF;
8455: --
8456: WSH_DELIVERY_VALIDATIONS.check_close
8457: (
8458: p_in_rec => l_in_rec,
8459: x_return_status => l_return_status,
8460: x_allowed => l_Allowed

Line 8523: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PACK',WSH_DEBUG_SV.C_PROC_LEVEL);

8519: --
8520: -- Debug Statements
8521: --
8522: IF l_debug_on THEN
8523: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PACK',WSH_DEBUG_SV.C_PROC_LEVEL);
8524: END IF;
8525: --
8526: wsh_delivery_validations.check_pack(p_del_rows(i), l_return_status);
8527: --

Line 8526: wsh_delivery_validations.check_pack(p_del_rows(i), l_return_status);

8522: IF l_debug_on THEN
8523: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PACK',WSH_DEBUG_SV.C_PROC_LEVEL);
8524: END IF;
8525: --
8526: wsh_delivery_validations.check_pack(p_del_rows(i), l_return_status);
8527: --
8528: WSH_UTIL_CORE.api_post_call
8529: (
8530: p_return_status => l_return_status,

Line 8548: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_REOPEN',WSH_DEBUG_SV.C_PROC_LEVEL);

8544: --
8545: -- Debug Statements
8546: --
8547: IF l_debug_on THEN
8548: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_REOPEN',WSH_DEBUG_SV.C_PROC_LEVEL);
8549: END IF;
8550: --
8551:
8552:

Line 8560: -- wsh_delivery_validations.check_reopen(p_del_rows(i), x_return_status);

8556: -- (This variable is used in further calls)
8557: -- x_return_status is assigned equal to l_return_status before exiting the
8558: -- procedure.
8559:
8560: -- wsh_delivery_validations.check_reopen(p_del_rows(i), x_return_status);
8561:
8562: wsh_delivery_validations.check_reopen(p_del_rows(i), l_return_status);
8563:
8564: --

Line 8562: wsh_delivery_validations.check_reopen(p_del_rows(i), l_return_status);

8558: -- procedure.
8559:
8560: -- wsh_delivery_validations.check_reopen(p_del_rows(i), x_return_status);
8561:
8562: wsh_delivery_validations.check_reopen(p_del_rows(i), l_return_status);
8563:
8564: --
8565: WSH_UTIL_CORE.api_post_call
8566: (

Line 9720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);

9716: THEN
9717: --{
9718: --
9719: IF l_debug_on THEN
9720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);
9721: END IF;
9722: --
9723: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
9724: (

Line 9723: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

9719: IF l_debug_on THEN
9720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);
9721: END IF;
9722: --
9723: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
9724: (
9725: p_delivery_id => p_delivery_id
9726: );
9727: --