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_DETAILS_VALIDATIONS dependencies on WSH_PICK_LIST

Line 51: WSH_PICK_LIST.G_BATCH_ID,

47: batch_id,
48: header_id,
49: status )
50: VALUES (
51: WSH_PICK_LIST.G_BATCH_ID,
52: p_header_id,
53: p_status );
54:
55: COMMIT;

Line 1109: AND batch_id = WSH_PICK_LIST.G_BATCH_ID;

1105: CURSOR get_pr_credit_cache IS
1106: SELECT status
1107: FROM wsh_pr_header_holds
1108: WHERE header_id = p_source_header_id
1109: AND batch_id = WSH_PICK_LIST.G_BATCH_ID;
1110:
1111: l_header_id NUMBER := p_source_header_id;
1112: l_line_id NUMBER := p_source_line_id;
1113: -- BUG#: 1549665 hwahdani variable to hold ship_from_location_id

Line 1253: IF (l_skip_header_flag = 'N') AND (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)

1249: l_skip_header_flag := 'Y';
1250: END IF;
1251:
1252: -- Check if Header exists in WSH_PR_HEADER_HOLDS Table for Pick Release process
1253: IF (l_skip_header_flag = 'N') AND (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1254: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1255: OPEN get_pr_credit_cache;
1256: FETCH get_pr_credit_cache INTO l_cache_status;
1257: IF get_pr_credit_cache%NOTFOUND THEN

Line 1254: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1250: END IF;
1251:
1252: -- Check if Header exists in WSH_PR_HEADER_HOLDS Table for Pick Release process
1253: IF (l_skip_header_flag = 'N') AND (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1254: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1255: OPEN get_pr_credit_cache;
1256: FETCH get_pr_credit_cache INTO l_cache_status;
1257: IF get_pr_credit_cache%NOTFOUND THEN
1258: l_cache_status := 'N'; -- not present in cache

Line 1321: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)

1317: p_return_status => x_return_status);
1318:
1319: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1320: g_bad_header_ids(l_bad_index) := l_header_id;
1321: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1322: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1323: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1324: END IF;
1325: --

Line 1322: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1318:
1319: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1320: g_bad_header_ids(l_bad_index) := l_header_id;
1321: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1322: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1323: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1324: END IF;
1325: --
1326: -- Debug Statements

Line 1359: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)

1355: -- If hold is found return back
1356:
1357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1358: g_bad_header_ids(l_bad_index) := l_header_id;
1359: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1360: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1361: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1362: END IF;
1363: --

Line 1360: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1356:
1357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1358: g_bad_header_ids(l_bad_index) := l_header_id;
1359: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1360: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1361: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1362: END IF;
1363: --
1364: -- Debug Statements

Line 1376: WSH_DEBUG_SV.log(l_module_name,'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID );

1372: l_request_id := fnd_global.conc_request_id;
1373: -- 1729516
1374: IF l_debug_on THEN
1375: WSH_DEBUG_SV.log(l_module_name,'l_request_id', l_request_id );
1376: WSH_DEBUG_SV.log(l_module_name,'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID );
1377: END IF;
1378:
1379: IF ( l_request_id = -1 AND WSH_PICK_LIST.G_BATCH_ID IS NULL ) THEN
1380: raise header_hold_error;

Line 1379: IF ( l_request_id = -1 AND WSH_PICK_LIST.G_BATCH_ID IS NULL ) THEN

1375: WSH_DEBUG_SV.log(l_module_name,'l_request_id', l_request_id );
1376: WSH_DEBUG_SV.log(l_module_name,'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID );
1377: END IF;
1378:
1379: IF ( l_request_id = -1 AND WSH_PICK_LIST.G_BATCH_ID IS NULL ) THEN
1380: raise header_hold_error;
1381: ELSE
1382: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_HOLD');
1383: FND_MESSAGE.SET_TOKEN('ORDER',l_order_number);

Line 1415: p_batch_id => WSH_PICK_LIST.g_batch_id -- Bug: 1729516

1411: p_exception_name => 'WSH_PICK_HOLD',
1412: p_message => l_msg,
1413: p_error_message => l_exception_error_message,
1414: p_request_id => l_request_id,
1415: p_batch_id => WSH_PICK_LIST.g_batch_id -- Bug: 1729516
1416: );
1417:
1418: IF (l_exception_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1419: --

Line 1435: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)

1431: END IF;
1432: END IF;
1433:
1434: g_good_header_ids(l_good_index) := l_header_id;
1435: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1436: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1437: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'P');
1438: END IF;
1439:

Line 1436: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1432: END IF;
1433:
1434: g_good_header_ids(l_good_index) := l_header_id;
1435: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1436: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1437: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'P');
1438: END IF;
1439:
1440: END IF;

Line 1502: IF ( l_request_id = -1 AND WSH_PICK_LIST.G_BATCH_ID IS NULL ) THEN

1498:
1499: l_request_id := fnd_global.conc_request_id;
1500:
1501: -- 1729516
1502: IF ( l_request_id = -1 AND WSH_PICK_LIST.G_BATCH_ID IS NULL ) THEN
1503: raise line_hold_error;
1504: ELSE
1505: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_ORDER_LINE_HOLD');
1506: FND_MESSAGE.SET_TOKEN('ORDER',l_order_number);

Line 1539: p_batch_id => WSH_PICK_LIST.g_batch_id -- Bug: 1729516

1535: p_exception_name => 'WSH_PICK_HOLD',
1536: p_message => l_msg ,
1537: p_error_message => l_exception_error_message,
1538: p_request_id => l_request_id,
1539: p_batch_id => WSH_PICK_LIST.g_batch_id -- Bug: 1729516
1540: );
1541:
1542: IF (l_exception_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1543: --