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.26.12020000.4 2013/04/08 10:57:22 suppal ship $ */
3: --
4: -- PACKAGE TYPES
5: --

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

161:
162: -- FORWARD DECLARATIONS
163: --
164:
165: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PR_CRITERIA';
166:
167: PROCEDURE Insert_RL_Row(
168: p_enforce_ship_set_and_smc IN VARCHAR2,
169: x_skip_detail OUT NOCOPY VARCHAR2, --Bug# 3248578

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

418: --
419: EXCEPTION
420: --
421: WHEN OTHERS THEN
422: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');
423: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
424: --
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

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

1511: CLOSE get_inner_items;
1512: END IF;
1513:
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN WSH_PR_CRITERIA.INIT');
1516: WSH_DEBUG_SV.logmsg(l_module_name,'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1518: END IF;
1519:

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

2003: 'u', ' WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER,' );
2004:
2005: -- Bug 2040002: Need PLANNED_DEPARTURE_DATE only if released by trip or
2006: -- is part of release sequence rule
2007: IF ((g_use_trip_stop_date) OR (WSH_PR_CRITERIA.g_trip_id > 0)) THEN
2008: Process_Buffer(p_print_flag,
2009: 'u', ' WTS.PLANNED_DEPARTURE_DATE,');
2010: ELSE
2011: Process_Buffer(p_print_flag,

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

2072: END IF;
2073:
2074: -- Bug 2040002: Need Trip/Stop info only if released by trip/stop or if
2075: -- Departure Date is part of release sequence rule
2076: IF ((g_use_trip_stop_date) OR (WSH_PR_CRITERIA.g_trip_id > 0)) THEN
2077: Process_Buffer(p_print_flag,
2078: 'u', ' WSH_DELIVERY_LEGS WLG,');
2079: Process_Buffer(p_print_flag,
2080: 'u', ' WSH_TRIP_STOPS WTS,');

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

2109:
2110: -- Bug 2040002: Can do hard join only when released by trip
2111: -- Do outer join when Departure Date is part of release sequence rule
2112: -- Otherwise we don't need to access these tables
2113: IF (WSH_PR_CRITERIA.g_trip_id > 0) THEN
2114: Process_Buffer(p_print_flag,
2115: 'u', ' AND WTS.STOP_ID = WLG.PICK_UP_STOP_ID ');
2116: Process_Buffer(p_print_flag,
2117: 'u', ' AND WLG.DELIVERY_ID = WDE.DELIVERY_ID ');

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

3103: -- Open Cursor for Organization - Item combination, only if called for new Organization OR
3104: -- if the previous call was for SMC and now for regular item as Item Bind Variable changes
3105: IF ( v_cursorID IS NULL ) OR ( v_prev_item_id IS NULL ) THEN
3106: IF l_debug_on THEN
3107: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_CRITERIA.Init_Cursor', WSH_DEBUG_SV.C_PROC_LEVEL);
3108: END IF;
3109: Init_Cursor (
3110: p_organization_id => v_pr_org_id,
3111: p_mode => l_mode,

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

3653: --}
3654: END IF;
3655:
3656: -- Check if Credit Check needs to be called
3657: IF (WSH_PR_CRITERIA.g_credit_check_option = 'A') OR
3658: (WSH_PR_CRITERIA.g_credit_check_option = 'R' AND v_released_status = 'R') OR
3659: (WSH_PR_CRITERIA.g_credit_check_option = 'B' AND v_released_status = 'B') THEN --{
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING FOR CREDIT CHECK/HOLDS' );

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

3654: END IF;
3655:
3656: -- Check if Credit Check needs to be called
3657: IF (WSH_PR_CRITERIA.g_credit_check_option = 'A') OR
3658: (WSH_PR_CRITERIA.g_credit_check_option = 'R' AND v_released_status = 'R') OR
3659: (WSH_PR_CRITERIA.g_credit_check_option = 'B' AND v_released_status = 'B') THEN --{
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING FOR CREDIT CHECK/HOLDS' );
3662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);

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

3655:
3656: -- Check if Credit Check needs to be called
3657: IF (WSH_PR_CRITERIA.g_credit_check_option = 'A') OR
3658: (WSH_PR_CRITERIA.g_credit_check_option = 'R' AND v_released_status = 'R') OR
3659: (WSH_PR_CRITERIA.g_credit_check_option = 'B' AND v_released_status = 'B') THEN --{
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING FOR CREDIT CHECK/HOLDS' );
3662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
3663: END IF;

Line 4086: END WSH_PR_CRITERIA;

4082: END IF;
4083:
4084: END Process_Buffer;
4085:
4086: END WSH_PR_CRITERIA;