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 4659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);

4655: --
4656: -- Debug Statements
4657: --
4658: IF l_debug_on THEN
4659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
4660: END IF;
4661: --
4662: WSH_DELIVERY_VALIDATIONS.check_detail_for_confirm
4663: ( p_detail_id => l_shp_dd_ids(dd_count),

Line 4662: WSH_DELIVERY_VALIDATIONS.check_detail_for_confirm

4658: IF l_debug_on THEN
4659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DETAIL_FOR_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
4660: END IF;
4661: --
4662: WSH_DELIVERY_VALIDATIONS.check_detail_for_confirm
4663: ( p_detail_id => l_shp_dd_ids(dd_count),
4664: p_check_credit_init_flag => l_check_credit_init_flag, -- bug 2343058
4665: x_line_inv_flag_rec => l_inv_controls_rec,
4666: x_return_status => l_return_status);

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

5329: IF l_param_info.export_screening_flag IN ('S', 'A') THEN
5330:
5331:
5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
5334: END IF;
5335:
5336: l_itm_exc_flag(p_del_rows(i)) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5337: (p_delivery_id => p_del_rows(i),

Line 5336: l_itm_exc_flag(p_del_rows(i)) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required

5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
5334: END IF;
5335:
5336: l_itm_exc_flag(p_del_rows(i)) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5337: (p_delivery_id => p_del_rows(i),
5338: x_return_status => l_return_status);
5339: IF l_debug_on THEN
5340: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);

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

5336: l_itm_exc_flag(p_del_rows(i)) := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5337: (p_delivery_id => p_del_rows(i),
5338: x_return_status => l_return_status);
5339: IF l_debug_on THEN
5340: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);
5341: WSH_DEBUG_SV.logmsg(l_module_name,'ITM flag: '||l_param_info.export_screening_flag);
5342: wsh_debug_sv.log(l_module_name,'l_itm_exc_flag for delivery: '|| p_del_rows(i),l_itm_exc_flag(p_del_rows(i)));
5343: END IF;
5344:

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

5509: --
5510: -- Debug Statements
5511: --
5512: IF l_debug_on THEN
5513: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
5514: END IF;
5515: --
5516: wsh_delivery_validations.check_confirm(
5517: p_delivery_id => p_del_rows(i),

Line 5516: wsh_delivery_validations.check_confirm(

5512: IF l_debug_on THEN
5513: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
5514: END IF;
5515: --
5516: wsh_delivery_validations.check_confirm(
5517: p_delivery_id => p_del_rows(i),
5518: p_actual_dep_date => p_actual_dep_date,
5519: p_cont_exists_flag => l_cont_exists_flag ,
5520: p_enforce_packing_flag => l_enforce_packing_flag,

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

6461: --
6462: -- Debug Statements
6463: --
6464: IF l_debug_on THEN
6465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCES',WSH_DEBUG_SV.C_PROC_LEVEL);
6466: END IF;
6467: --
6468: wsh_Delivery_validations.check_delivery_for_tolerances (
6469: p_delivery_id => p_del_rows(i) ,

Line 6468: wsh_Delivery_validations.check_delivery_for_tolerances (

6464: IF l_debug_on THEN
6465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_DELIVERY_FOR_TOLERANCES',WSH_DEBUG_SV.C_PROC_LEVEL);
6466: END IF;
6467: --
6468: wsh_Delivery_validations.check_delivery_for_tolerances (
6469: p_delivery_id => p_del_rows(i) ,
6470: x_source_line_id => l_temp_line_id ,
6471: x_source_code => l_temp_source_code ,
6472: x_max_quantity => l_max_quantity ,

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

6778:
6779: IF l_itm_exc_flag(u_del_rows(i)) = 'Y' THEN
6780:
6781: IF l_debug_on THEN
6782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
6783: END IF;
6784:
6785: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception
6786: (p_delivery_id => u_del_rows(i),

Line 6785: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception

6781: IF l_debug_on THEN
6782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
6783: END IF;
6784:
6785: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception
6786: (p_delivery_id => u_del_rows(i),
6787: p_action_type => 'SHIP_CONFIRM',
6788: p_ship_from_location_id => l_ship_from_location,
6789: x_return_status => l_return_status);

Line 7311: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,

7307: --========================================================================
7308: --
7309: PROCEDURE setInTransit
7310: (
7311: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,
7312: x_return_status OUT NOCOPY VARCHAR2
7313: )
7314: IS
7315: --{

Line 7728: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,

7724: --========================================================================
7725: --
7726: PROCEDURE setClose
7727: (
7728: p_in_rec IN WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type,
7729: x_return_status OUT NOCOPY VARCHAR2
7730: )
7731: IS
7732: --{

Line 8083: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;

8079: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CHANGE_STATUS';
8080: --
8081: l_return_status VARCHAR2(30);
8082: l_allowed VARCHAR2(10);
8083: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
8084: --
8085: l_num_warnings NUMBER;
8086: l_num_errors NUMBER;
8087: l_num_dels_processed NUMBER;

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

8175: --
8176: -- Debug Statements
8177: --
8178: IF l_debug_on THEN
8179: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8180: END IF;
8181: --
8182: WSH_DELIVERY_VALIDATIONS.check_inTransit
8183: (

Line 8182: WSH_DELIVERY_VALIDATIONS.check_inTransit

8178: IF l_debug_on THEN
8179: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8180: END IF;
8181: --
8182: WSH_DELIVERY_VALIDATIONS.check_inTransit
8183: (
8184: p_in_rec => l_in_rec,
8185: x_return_status => l_return_status,
8186: x_allowed => l_Allowed

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

8253: --
8254: -- Debug Statements
8255: --
8256: IF l_debug_on THEN
8257: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8258: END IF;
8259: --
8260: WSH_DELIVERY_VALIDATIONS.check_close
8261: (

Line 8260: WSH_DELIVERY_VALIDATIONS.check_close

8256: IF l_debug_on THEN
8257: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
8258: END IF;
8259: --
8260: WSH_DELIVERY_VALIDATIONS.check_close
8261: (
8262: p_in_rec => l_in_rec,
8263: x_return_status => l_return_status,
8264: x_allowed => l_Allowed

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

8323: --
8324: -- Debug Statements
8325: --
8326: IF l_debug_on THEN
8327: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PACK',WSH_DEBUG_SV.C_PROC_LEVEL);
8328: END IF;
8329: --
8330: wsh_delivery_validations.check_pack(p_del_rows(i), l_return_status);
8331: --

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

8326: IF l_debug_on THEN
8327: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_PACK',WSH_DEBUG_SV.C_PROC_LEVEL);
8328: END IF;
8329: --
8330: wsh_delivery_validations.check_pack(p_del_rows(i), l_return_status);
8331: --
8332: WSH_UTIL_CORE.api_post_call
8333: (
8334: p_return_status => l_return_status,

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

8348: --
8349: -- Debug Statements
8350: --
8351: IF l_debug_on THEN
8352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_REOPEN',WSH_DEBUG_SV.C_PROC_LEVEL);
8353: END IF;
8354: --
8355:
8356:

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

8360: -- (This variable is used in further calls)
8361: -- x_return_status is assigned equal to l_return_status before exiting the
8362: -- procedure.
8363:
8364: -- wsh_delivery_validations.check_reopen(p_del_rows(i), x_return_status);
8365:
8366: wsh_delivery_validations.check_reopen(p_del_rows(i), l_return_status);
8367:
8368: --

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

8362: -- procedure.
8363:
8364: -- wsh_delivery_validations.check_reopen(p_del_rows(i), x_return_status);
8365:
8366: wsh_delivery_validations.check_reopen(p_del_rows(i), l_return_status);
8367:
8368: --
8369: WSH_UTIL_CORE.api_post_call
8370: (

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

9520: THEN
9521: --{
9522: --
9523: IF l_debug_on THEN
9524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);
9525: END IF;
9526: --
9527: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
9528: (

Line 9527: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

9523: IF l_debug_on THEN
9524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);
9525: END IF;
9526: --
9527: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
9528: (
9529: p_delivery_id => p_delivery_id
9530: );
9531: --