DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_TPA_DELIVERY_PKG

Line 1371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);

1367: --
1368: -- Debug Statements
1369: --
1370: IF l_debug_on THEN
1371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
1372: END IF;
1373: --
1374: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
1375:

Line 1374: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);

1370: IF l_debug_on THEN
1371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
1372: END IF;
1373: --
1374: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
1375:
1376: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1377: x_return_status := l_return_status;
1378: --

Line 1403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);

1399: --
1400: -- Debug Statements
1401: --
1402: IF l_debug_on THEN
1403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
1404: END IF;
1405: --
1406: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
1407:

Line 1406: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);

1402: IF l_debug_on THEN
1403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
1404: END IF;
1405: --
1406: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
1407:
1408: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1409: x_return_status := l_return_status;
1410: --

Line 1503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);

1499: --
1500: -- Debug Statements
1501: --
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
1504: END IF;
1505: --
1506: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',
1507: p_entity_id => p_delivery_id,

Line 1506: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',

1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
1504: END IF;
1505: --
1506: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',
1507: p_entity_id => p_delivery_id,
1508: -- p_ship_date => l_ship_date,--6156495
1509: p_ship_date => l_temp_ship_date,
1510: p_ship_assoc_type => l_ship_assoc_type, --'ORG',

Line 2024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_NOT_I_T',WSH_DEBUG_SV.C_PROC_LEVEL);

2020: --
2021: -- Debug Statements
2022: --
2023: IF l_debug_on THEN
2024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_NOT_I_T',WSH_DEBUG_SV.C_PROC_LEVEL);
2025: END IF;
2026: --
2027: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, l_return_status);
2028:

Line 2027: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, l_return_status);

2023: IF l_debug_on THEN
2024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_NOT_I_T',WSH_DEBUG_SV.C_PROC_LEVEL);
2025: END IF;
2026: --
2027: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, l_return_status);
2028:
2029: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2030: x_return_status := l_return_status;
2031: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 2463: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_NOT_I_T',WSH_DEBUG_SV.C_PROC_LEVEL);

2459: --
2460: -- Debug Statements
2461: --
2462: IF l_debug_on THEN
2463: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_NOT_I_T',WSH_DEBUG_SV.C_PROC_LEVEL);
2464: END IF;
2465: --
2466: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, x_return_status);
2467:

Line 2466: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, x_return_status);

2462: IF l_debug_on THEN
2463: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_NOT_I_T',WSH_DEBUG_SV.C_PROC_LEVEL);
2464: END IF;
2465: --
2466: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, x_return_status);
2467:
2468: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2469: --
2470: -- Debug Statements

Line 3303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_OVERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);

3299: --
3300: -- Debug Statements
3301: --
3302: IF l_debug_on THEN
3303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_OVERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3304: END IF;
3305: --
3306: wsh_tpa_delivery_pkg.check_del_overfilled(p_delivery_id, p_cont_exists_flag, p_overfilled_flag, l_return_status);
3307:

Line 3306: wsh_tpa_delivery_pkg.check_del_overfilled(p_delivery_id, p_cont_exists_flag, p_overfilled_flag, l_return_status);

3302: IF l_debug_on THEN
3303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_OVERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3304: END IF;
3305: --
3306: wsh_tpa_delivery_pkg.check_del_overfilled(p_delivery_id, p_cont_exists_flag, p_overfilled_flag, l_return_status);
3307:
3308: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3309: x_return_status := l_return_status;
3310: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 3327: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_UNDERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);

3323: --
3324: -- Debug Statements
3325: --
3326: IF l_debug_on THEN
3327: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_UNDERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3328: END IF;
3329: --
3330: wsh_tpa_delivery_pkg.check_del_underfilled(p_delivery_id, p_cont_exists_flag, p_underfilled_flag, l_return_status);
3331:

Line 3330: wsh_tpa_delivery_pkg.check_del_underfilled(p_delivery_id, p_cont_exists_flag, p_underfilled_flag, l_return_status);

3326: IF l_debug_on THEN
3327: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_UNDERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3328: END IF;
3329: --
3330: wsh_tpa_delivery_pkg.check_del_underfilled(p_delivery_id, p_cont_exists_flag, p_underfilled_flag, l_return_status);
3331:
3332: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3333: x_return_status := l_return_status;
3334: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 3351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);

3347: --
3348: -- Debug Statements
3349: --
3350: IF l_debug_on THEN
3351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
3352: END IF;
3353: --
3354: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
3355:

Line 3354: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);

3350: IF l_debug_on THEN
3351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
3352: END IF;
3353: --
3354: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
3355:
3356: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3357: x_return_status := l_return_status;
3358: --

Line 3408: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);

3404: --
3405: -- Debug Statements
3406: --
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
3409: END IF;
3410: --
3411: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
3412:

Line 3411: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);

3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
3409: END IF;
3410: --
3411: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
3412:
3413: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3414: x_return_status := l_return_status;
3415: --

Line 3492: --Bug 6156495 (Determining the date to be passed to the API wsh_tpa_delivery_pkg.check_calendar)

3488: -- TPA Change
3489: --
3490: -- Debug Statements
3491: --
3492: --Bug 6156495 (Determining the date to be passed to the API wsh_tpa_delivery_pkg.check_calendar)
3493: IF p_ultimate_dropoff_date > P_ACTUAL_DEP_DATE
3494: THEN
3495: l_temp_date := p_ultimate_dropoff_date;
3496: ELSE

Line 3503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);

3499: --Bug 6156495 -End of code addition
3500:
3501:
3502: IF l_debug_on THEN
3503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
3504: END IF;
3505: -- modified ship_assoc type to 'HR_LOCATION' and receive_assoc_type to 'CUSTOMER_SITE' for bug 5880742
3506: --
3507: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',

Line 3507: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',

3503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
3504: END IF;
3505: -- modified ship_assoc type to 'HR_LOCATION' and receive_assoc_type to 'CUSTOMER_SITE' for bug 5880742
3506: --
3507: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',
3508: p_entity_id => p_delivery_id,
3509: -- p_ship_date => p_initial_pickup_date ,--6156495
3510: p_ship_date => P_ACTUAL_DEP_DATE ,
3511: p_ship_assoc_type => 'HR_LOCATION',