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_PR_CRITERIA dependencies on WSH_PR_CRITERIA

Line 1: PACKAGE BODY WSH_PR_CRITERIA AS

1: PACKAGE BODY WSH_PR_CRITERIA AS
2: /* $Header: WSHPRCRB.pls 120.17 2008/01/08 01:33:53 mvudugul ship $ */
3: --
4: -- PACKAGE TYPES
5: --

Line 154: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PR_CRITERIA';

150:
151: -- FORWARD DECLARATIONS
152: --
153:
154: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PR_CRITERIA';
155:
156: PROCEDURE Insert_RL_Row(
157: p_enforce_ship_set_and_smc IN VARCHAR2,
158: x_skip_detail OUT NOCOPY VARCHAR2, --Bug# 3248578

Line 411: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');

407: --
408: EXCEPTION
409: --
410: WHEN OTHERS THEN
411: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');
412: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 1454: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN WSH_PR_CRITERIA.INIT');

1450: CLOSE get_inner_items;
1451: END IF;
1452:
1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN WSH_PR_CRITERIA.INIT');
1455: WSH_DEBUG_SV.logmsg(l_module_name,'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1456: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1457: END IF;
1458:

Line 1932: IF ((g_use_trip_stop_date) OR (WSH_PR_CRITERIA.g_trip_id > 0)) THEN

1928: 'u', ' WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER,' );
1929:
1930: -- Bug 2040002: Need PLANNED_DEPARTURE_DATE only if released by trip or
1931: -- is part of release sequence rule
1932: IF ((g_use_trip_stop_date) OR (WSH_PR_CRITERIA.g_trip_id > 0)) THEN
1933: Process_Buffer(p_print_flag,
1934: 'u', ' WTS.PLANNED_DEPARTURE_DATE,');
1935: ELSE
1936: Process_Buffer(p_print_flag,

Line 1994: IF ((g_use_trip_stop_date) OR (WSH_PR_CRITERIA.g_trip_id > 0)) THEN

1990: END IF;
1991:
1992: -- Bug 2040002: Need Trip/Stop info only if released by trip/stop or if
1993: -- Departure Date is part of release sequence rule
1994: IF ((g_use_trip_stop_date) OR (WSH_PR_CRITERIA.g_trip_id > 0)) THEN
1995: Process_Buffer(p_print_flag,
1996: 'u', ' WSH_DELIVERY_LEGS WLG,');
1997: Process_Buffer(p_print_flag,
1998: 'u', ' WSH_TRIP_STOPS WTS,');

Line 2031: IF (WSH_PR_CRITERIA.g_trip_id > 0) THEN

2027:
2028: -- Bug 2040002: Can do hard join only when released by trip
2029: -- Do outer join when Departure Date is part of release sequence rule
2030: -- Otherwise we don't need to access these tables
2031: IF (WSH_PR_CRITERIA.g_trip_id > 0) THEN
2032: Process_Buffer(p_print_flag,
2033: 'u', ' AND WTS.STOP_ID = WLG.PICK_UP_STOP_ID ');
2034: Process_Buffer(p_print_flag,
2035: 'u', ' AND WLG.DELIVERY_ID = WDE.DELIVERY_ID ');

Line 3001: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_CRITERIA.Init_Cursor', WSH_DEBUG_SV.C_PROC_LEVEL);

2997: -- Open Cursor for Organization - Item combination, only if called for new Organization OR
2998: -- if the previous call was for SMC and now for regular item as Item Bind Variable changes
2999: IF ( v_cursorID IS NULL ) OR ( v_prev_item_id IS NULL ) THEN
3000: IF l_debug_on THEN
3001: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_CRITERIA.Init_Cursor', WSH_DEBUG_SV.C_PROC_LEVEL);
3002: END IF;
3003: Init_Cursor (
3004: p_organization_id => v_pr_org_id,
3005: p_mode => l_mode,

Line 3520: IF (WSH_PR_CRITERIA.g_credit_check_option = 'A') OR

3516: --}
3517: END IF;
3518:
3519: -- Check if Credit Check needs to be called
3520: IF (WSH_PR_CRITERIA.g_credit_check_option = 'A') OR
3521: (WSH_PR_CRITERIA.g_credit_check_option = 'R' AND v_released_status = 'R') OR
3522: (WSH_PR_CRITERIA.g_credit_check_option = 'B' AND v_released_status = 'B') THEN --{
3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING FOR CREDIT CHECK/HOLDS' );

Line 3521: (WSH_PR_CRITERIA.g_credit_check_option = 'R' AND v_released_status = 'R') OR

3517: END IF;
3518:
3519: -- Check if Credit Check needs to be called
3520: IF (WSH_PR_CRITERIA.g_credit_check_option = 'A') OR
3521: (WSH_PR_CRITERIA.g_credit_check_option = 'R' AND v_released_status = 'R') OR
3522: (WSH_PR_CRITERIA.g_credit_check_option = 'B' AND v_released_status = 'B') THEN --{
3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING FOR CREDIT CHECK/HOLDS' );
3525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3522: (WSH_PR_CRITERIA.g_credit_check_option = 'B' AND v_released_status = 'B') THEN --{

3518:
3519: -- Check if Credit Check needs to be called
3520: IF (WSH_PR_CRITERIA.g_credit_check_option = 'A') OR
3521: (WSH_PR_CRITERIA.g_credit_check_option = 'R' AND v_released_status = 'R') OR
3522: (WSH_PR_CRITERIA.g_credit_check_option = 'B' AND v_released_status = 'B') THEN --{
3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING FOR CREDIT CHECK/HOLDS' );
3525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
3526: END IF;

Line 3925: END WSH_PR_CRITERIA;

3921: END IF;
3922:
3923: END Process_Buffer;
3924:
3925: END WSH_PR_CRITERIA;