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 57: WSH_PICK_LIST.G_BATCH_ID,

53: batch_id,
54: header_id,
55: status )
56: VALUES (
57: WSH_PICK_LIST.G_BATCH_ID,
58: p_header_id,
59: p_status );
60:
61: COMMIT;

Line 1150: AND batch_id = WSH_PICK_LIST.G_BATCH_ID;

1146: CURSOR get_pr_credit_cache IS
1147: SELECT status
1148: FROM wsh_pr_header_holds
1149: WHERE header_id = p_source_header_id
1150: AND batch_id = WSH_PICK_LIST.G_BATCH_ID;
1151:
1152: l_header_id NUMBER := p_source_header_id;
1153: l_line_id NUMBER := p_source_line_id;
1154: -- BUG#: 1549665 hwahdani variable to hold ship_from_location_id

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

1301: l_skip_header_flag := 'Y';
1302: END IF;
1303:
1304: -- Check if Header exists in WSH_PR_HEADER_HOLDS Table for Pick Release process
1305: IF (l_skip_header_flag = 'N') AND (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1306: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1307: OPEN get_pr_credit_cache;
1308: FETCH get_pr_credit_cache INTO l_cache_status;
1309: IF get_pr_credit_cache%NOTFOUND THEN

Line 1306: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1302: END IF;
1303:
1304: -- Check if Header exists in WSH_PR_HEADER_HOLDS Table for Pick Release process
1305: IF (l_skip_header_flag = 'N') AND (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1306: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1307: OPEN get_pr_credit_cache;
1308: FETCH get_pr_credit_cache INTO l_cache_status;
1309: IF get_pr_credit_cache%NOTFOUND THEN
1310: l_cache_status := 'N'; -- not present in cache

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

1370: p_return_status => x_return_status);
1371:
1372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1373: g_bad_header_ids(l_bad_index) := l_header_id;
1374: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1375: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1376: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1377: END IF;
1378: --

Line 1375: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1371:
1372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1373: g_bad_header_ids(l_bad_index) := l_header_id;
1374: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1375: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1376: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1377: END IF;
1378: --
1379: -- Debug Statements

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

1408: -- If hold is found return back
1409:
1410: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1411: g_bad_header_ids(l_bad_index) := l_header_id;
1412: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1413: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1414: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1415: END IF;
1416: --

Line 1413: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1409:
1410: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_result_out = FND_API.G_TRUE) THEN
1411: g_bad_header_ids(l_bad_index) := l_header_id;
1412: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1413: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1414: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'F');
1415: END IF;
1416: --
1417: -- Debug Statements

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

1425: l_request_id := fnd_global.conc_request_id;
1426: -- 1729516
1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.log(l_module_name,'l_request_id', l_request_id );
1429: WSH_DEBUG_SV.log(l_module_name,'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID );
1430: END IF;
1431:
1432: --Bug 14620571: Exception needs to be logged only for PickRelease process
1433: IF ( p_activity_type <> 'PICK' ) THEN

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

1465: p_exception_name => 'WSH_PICK_HOLD',
1466: p_message => l_msg,
1467: p_error_message => l_exception_error_message,
1468: p_request_id => l_request_id,
1469: p_batch_id => WSH_PICK_LIST.g_batch_id -- Bug: 1729516
1470: );
1471:
1472: IF (l_exception_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1473: --

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

1485: END IF;
1486: END IF;
1487:
1488: g_good_header_ids(l_good_index) := l_header_id;
1489: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1490: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1491: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'P');
1492: END IF;
1493:

Line 1490: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN

1486: END IF;
1487:
1488: g_good_header_ids(l_good_index) := l_header_id;
1489: IF (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1490: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1491: Insert_PR_Header_Holds (p_header_id => l_header_id, p_status => 'P');
1492: END IF;
1493:
1494: END IF;

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

1559:
1560: -- 1729516
1561: --Bug 14620571: Exception needs to be logged only for PickRelease process
1562: IF ( p_activity_type <> 'PICK' ) THEN
1563: --IF ( l_request_id = -1 AND WSH_PICK_LIST.G_BATCH_ID IS NULL ) THEN
1564: raise line_hold_error;
1565: ELSE
1566: FND_MESSAGE.SET_NAME('WSH','WSH_PICK_ORDER_LINE_HOLD');
1567: FND_MESSAGE.SET_TOKEN('ORDER',l_order_number);

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

1596: p_exception_name => 'WSH_PICK_HOLD',
1597: p_message => l_msg ,
1598: p_error_message => l_exception_error_message,
1599: p_request_id => l_request_id,
1600: p_batch_id => WSH_PICK_LIST.g_batch_id -- Bug: 1729516
1601: );
1602:
1603: IF (l_exception_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1604: --