DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_TPA_DELIVERY_PKG

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

1394: --
1395: -- Debug Statements
1396: --
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
1399: END IF;
1400: --
1401: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
1402:

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

1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
1399: END IF;
1400: --
1401: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
1402:
1403: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1404: x_return_status := l_return_status;
1405: --

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

1426: --
1427: -- Debug Statements
1428: --
1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
1431: END IF;
1432: --
1433: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
1434:

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

1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
1431: END IF;
1432: --
1433: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
1434:
1435: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1436: x_return_status := l_return_status;
1437: --

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

1538: --
1539: -- Debug Statements
1540: --
1541: IF l_debug_on THEN
1542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
1543: END IF;
1544: --
1545: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',
1546: p_entity_id => p_delivery_id,

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

1541: IF l_debug_on THEN
1542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
1543: END IF;
1544: --
1545: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',
1546: p_entity_id => p_delivery_id,
1547: -- p_ship_date => l_ship_date,--6156495
1548: p_ship_date => l_temp_ship_date,
1549: p_ship_assoc_type => l_ship_assoc_type, --'ORG',

Line 2064: 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);

2060: --
2061: -- Debug Statements
2062: --
2063: IF l_debug_on THEN
2064: 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);
2065: END IF;
2066: --
2067: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, l_return_status);
2068:

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

2063: IF l_debug_on THEN
2064: 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);
2065: END IF;
2066: --
2067: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, l_return_status);
2068:
2069: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2070: x_return_status := l_return_status;
2071: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 2503: 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);

2499: --
2500: -- Debug Statements
2501: --
2502: IF l_debug_on THEN
2503: 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);
2504: END IF;
2505: --
2506: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, x_return_status);
2507:

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

2502: IF l_debug_on THEN
2503: 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);
2504: END IF;
2505: --
2506: wsh_tpa_delivery_pkg.check_del_not_i_t(p_delivery_id, l_del_status, x_return_status);
2507:
2508: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2509: --
2510: -- Debug Statements

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

3375: --
3376: -- Debug Statements
3377: --
3378: IF l_debug_on THEN
3379: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_OVERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3380: END IF;
3381: --
3382: wsh_tpa_delivery_pkg.check_del_overfilled(p_delivery_id, p_cont_exists_flag, p_overfilled_flag, l_return_status);
3383:

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

3378: IF l_debug_on THEN
3379: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_OVERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3380: END IF;
3381: --
3382: wsh_tpa_delivery_pkg.check_del_overfilled(p_delivery_id, p_cont_exists_flag, p_overfilled_flag, l_return_status);
3383:
3384: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3385: x_return_status := l_return_status;
3386: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

3399: --
3400: -- Debug Statements
3401: --
3402: IF l_debug_on THEN
3403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_UNDERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3404: END IF;
3405: --
3406: wsh_tpa_delivery_pkg.check_del_underfilled(p_delivery_id, p_cont_exists_flag, p_underfilled_flag, l_return_status);
3407:

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

3402: IF l_debug_on THEN
3403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_DEL_UNDERFILLED',WSH_DEBUG_SV.C_PROC_LEVEL);
3404: END IF;
3405: --
3406: wsh_tpa_delivery_pkg.check_del_underfilled(p_delivery_id, p_cont_exists_flag, p_underfilled_flag, l_return_status);
3407:
3408: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3409: x_return_status := l_return_status;
3410: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

3423: --
3424: -- Debug Statements
3425: --
3426: IF l_debug_on THEN
3427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
3428: END IF;
3429: --
3430: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
3431:

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

3426: IF l_debug_on THEN
3427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SMC',WSH_DEBUG_SV.C_PROC_LEVEL);
3428: END IF;
3429: --
3430: wsh_tpa_delivery_pkg.check_smc( p_delivery_id, l_valid_flag, l_return_status);
3431:
3432: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3433: x_return_status := l_return_status;
3434: --

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

3480: --
3481: -- Debug Statements
3482: --
3483: IF l_debug_on THEN
3484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
3485: END IF;
3486: --
3487: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
3488:

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

3483: IF l_debug_on THEN
3484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
3485: END IF;
3486: --
3487: wsh_tpa_delivery_pkg.check_ship_set( p_delivery_id, l_valid_flag, l_return_status);
3488:
3489: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3490: x_return_status := l_return_status;
3491: --

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

3576: -- TPA Change
3577: --
3578: -- Debug Statements
3579: --
3580: --Bug 6156495 (Determining the date to be passed to the API wsh_tpa_delivery_pkg.check_calendar)
3581: IF p_ultimate_dropoff_date > P_ACTUAL_DEP_DATE
3582: THEN
3583: l_temp_date := p_ultimate_dropoff_date;
3584: ELSE

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

3587: --Bug 6156495 -End of code addition
3588:
3589:
3590: IF l_debug_on THEN
3591: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
3592: END IF;
3593: -- modified ship_assoc type to 'HR_LOCATION' and receive_assoc_type to 'CUSTOMER_SITE' for bug 5880742
3594: --
3595: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',

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

3591: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_DELIVERY_PKG.CHECK_CALENDAR',WSH_DEBUG_SV.C_PROC_LEVEL);
3592: END IF;
3593: -- modified ship_assoc type to 'HR_LOCATION' and receive_assoc_type to 'CUSTOMER_SITE' for bug 5880742
3594: --
3595: wsh_tpa_delivery_pkg.check_calendar(p_entity_type => 'DELIVERY',
3596: p_entity_id => p_delivery_id,
3597: -- p_ship_date => p_initial_pickup_date ,--6156495
3598: p_ship_date => P_ACTUAL_DEP_DATE ,
3599: p_ship_assoc_type => 'HR_LOCATION',