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_USA_CATEGORIES_PVT dependencies on FND_API

Line 38: FND_API.G_MISS_NUM, FND_API.G_MISS_NUM,

34: latest_dropoff_date,
35: mode_of_transport,
36: service_level,
37: decode(p_delivery_detail_id,
38: FND_API.G_MISS_NUM, FND_API.G_MISS_NUM,
39: delivery_detail_id) delivery_detail_id,
40: 'Y' cache_flag,
41: project_id,
42: task_id

Line 46: AND delivery_detail_id = DECODE(p_delivery_detail_id, FND_API.G_MISS_NUM,

42: task_id
43: FROM wsh_delivery_details
44: WHERE source_line_id = p_source_line_id
45: AND source_code = p_source_code
46: AND delivery_detail_id = DECODE(p_delivery_detail_id, FND_API.G_MISS_NUM,
47: delivery_detail_id, p_delivery_detail_id)
48: AND released_status in ('R', 'N', 'X')
49: AND rownum = 1
50: ORDER BY decode (released_status,

Line 88: FND_API.G_MISS_NUM, FND_API.G_MISS_NUM,

84: latest_dropoff_date,
85: mode_of_transport,
86: service_level,
87: decode(p_delivery_detail_id,
88: FND_API.G_MISS_NUM, FND_API.G_MISS_NUM,
89: delivery_detail_id) delivery_detail_id,
90: 'Y' cache_flag,
91: project_id,
92: task_id

Line 96: AND delivery_detail_id = DECODE(p_delivery_detail_id, FND_API.G_MISS_NUM,

92: task_id
93: FROM wsh_delivery_details
94: WHERE source_line_id = p_source_line_id
95: AND source_code = p_source_code
96: AND delivery_detail_id = DECODE(p_delivery_detail_id, FND_API.G_MISS_NUM,
97: delivery_detail_id, p_delivery_detail_id)
98: AND released_status in ('B', 'Y', 'S')
99: AND rownum = 1
100: ORDER BY decode (released_status,

Line 256: p_delivery_detail_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

252: END Log_Exception;
253:
254: PROCEDURE Cache_Changed_Attributes(p_source_line_id IN NUMBER,
255: p_source_code IN VARCHAR2,
256: p_delivery_detail_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
257: x_return_status OUT NOCOPY VARCHAR2) IS
258:
259:
260: --

Line 836: IF ( (p_attributes_rec.ordered_quantity <> FND_API.G_MISS_NUM)

832: --bug#6407943
833: -- There is a possibility of having quantity change on delivery lines when there is a change in org
834: -- value on sales order line and item's primary uom is different in old and new orgs.
835: --BUG#11893915
836: IF ( (p_attributes_rec.ordered_quantity <> FND_API.G_MISS_NUM)
837: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))
838: OR
839: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
840: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id)

Line 837: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))

833: -- There is a possibility of having quantity change on delivery lines when there is a change in org
834: -- value on sales order line and item's primary uom is different in old and new orgs.
835: --BUG#11893915
836: IF ( (p_attributes_rec.ordered_quantity <> FND_API.G_MISS_NUM)
837: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))
838: OR
839: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
840: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id)
841: AND ((p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) OR (p_attributes_rec.inventory_item_id = g_cache_detail_rec.inventory_item_id)) ) THEN

Line 839: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)

835: --BUG#11893915
836: IF ( (p_attributes_rec.ordered_quantity <> FND_API.G_MISS_NUM)
837: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))
838: OR
839: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
840: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id)
841: AND ((p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) OR (p_attributes_rec.inventory_item_id = g_cache_detail_rec.inventory_item_id)) ) THEN
842:
843: g_cache_detail_rec.cache_flag := 'N';

Line 841: AND ((p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) OR (p_attributes_rec.inventory_item_id = g_cache_detail_rec.inventory_item_id)) ) THEN

837: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))
838: OR
839: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
840: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id)
841: AND ((p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) OR (p_attributes_rec.inventory_item_id = g_cache_detail_rec.inventory_item_id)) ) THEN
842:
843: g_cache_detail_rec.cache_flag := 'N';
844: WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity(
845: p_changed_attribute => p_attributes_rec,

Line 1113: -- 2071048. ADDED the check condition g_cache_detail_rec.subinventory <> FND_API.G_MISS_CHAR to

1109: -- HW OPMCONV. Removed branching
1110:
1111: -- HW end of OM changes
1112:
1113: -- 2071048. ADDED the check condition g_cache_detail_rec.subinventory <> FND_API.G_MISS_CHAR to
1114: -- avoid looping through the delivery_details if the released_status of the lines is either
1115: -- 'B' or 'Y' or 'S'.
1116:
1117: --bug# 6689448 (replenishment project): begin

Line 1118: IF ( ( p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.subinventory IS NULL) )

1114: -- avoid looping through the delivery_details if the released_status of the lines is either
1115: -- 'B' or 'Y' or 'S'.
1116:
1117: --bug# 6689448 (replenishment project): begin
1118: IF ( ( p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.subinventory IS NULL) )
1119: AND
1120: ( NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.subinventory, FND_API.G_MISS_CHAR )) THEN
1121: l_sub_change := 'Y';
1122: END IF;

Line 1120: ( NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.subinventory, FND_API.G_MISS_CHAR )) THEN

1116:
1117: --bug# 6689448 (replenishment project): begin
1118: IF ( ( p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.subinventory IS NULL) )
1119: AND
1120: ( NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.subinventory, FND_API.G_MISS_CHAR )) THEN
1121: l_sub_change := 'Y';
1122: END IF;
1123: --bug# 6689448 (replenishment project): end
1124:

Line 1125: IF ((p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) AND

1121: l_sub_change := 'Y';
1122: END IF;
1123: --bug# 6689448 (replenishment project): end
1124:
1125: IF ((p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) AND
1126: (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id))
1127: OR (p_attributes_rec.date_scheduled IS NULL AND g_cache_detail_rec.date_scheduled IS NOT NULL)
1128: THEN
1129:

Line 1134: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND

1130: l_change_sub_only := 'N';
1131:
1132: ELSIF ( (l_sub_change = 'Y')
1133: OR
1134: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1135: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1136: OR
1137: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1138: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))

Line 1135: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))

1131:
1132: ELSIF ( (l_sub_change = 'Y')
1133: OR
1134: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1135: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1136: OR
1137: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1138: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))
1139: )

Line 1137: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND

1133: OR
1134: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1135: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1136: OR
1137: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1138: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))
1139: )
1140: THEN
1141: l_change_sub_only := 'Y';

Line 1138: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))

1134: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1135: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1136: OR
1137: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1138: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))
1139: )
1140: THEN
1141: l_change_sub_only := 'Y';
1142: END IF;

Line 1151: IF ( (p_attributes_rec.inventory_item_id <> FND_API.G_MISS_NUM)

1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name, 'Old inventory_item_id '||g_cache_detail_rec.inventory_item_id ||
1149: ' New inventory_item_id '||p_attributes_rec.inventory_item_id);
1150: END IF;
1151: IF ( (p_attributes_rec.inventory_item_id <> FND_API.G_MISS_NUM)
1152: and(p_attributes_rec.inventory_item_id <> g_cache_detail_rec.inventory_item_id) ) THEN
1153: --{
1154:
1155: l_change_item := 'Y';

Line 1169: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)

1165: RAISE item_update_not_allowed;
1166: --}
1167: END IF;
1168: --check for new org.
1169: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
1170: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id) ) THEN
1171: --{
1172: l_final_org_id:= p_attributes_rec.ship_from_org_id;
1173: IF INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_final_org_id) THEN

Line 1250: IF ( (p_attributes_rec.src_requested_quantity <> FND_API.G_MISS_NUM)

1246: --}
1247: END IF;
1248:
1249: --8. Check if UOM conversion (from order UOM to primary uom) is different. if so - do not allow update of item.
1250: IF ( (p_attributes_rec.src_requested_quantity <> FND_API.G_MISS_NUM)
1251: AND (p_attributes_rec.src_requested_quantity <> g_cache_detail_rec.src_requested_quantity) ) THEN
1252: l_ordered_quantity := p_attributes_rec.src_requested_quantity;
1253: ELSE
1254: l_ordered_quantity := g_cache_detail_rec.src_requested_quantity;

Line 1256: IF ( (p_attributes_rec.src_requested_quantity_uom <> FND_API.G_MISS_CHAR)

1252: l_ordered_quantity := p_attributes_rec.src_requested_quantity;
1253: ELSE
1254: l_ordered_quantity := g_cache_detail_rec.src_requested_quantity;
1255: END IF;
1256: IF ( (p_attributes_rec.src_requested_quantity_uom <> FND_API.G_MISS_CHAR)
1257: AND (p_attributes_rec.src_requested_quantity_uom <> g_cache_detail_rec.src_requested_quantity_uom) ) THEN
1258: l_ordered_quantity_uom := p_attributes_rec.src_requested_quantity_uom;
1259: ELSE
1260: l_ordered_quantity_uom := g_cache_detail_rec.src_requested_quantity_uom;

Line 1445: (NVL(l_orig_sub, FND_API.G_MISS_CHAR) <> NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR))

1441: x_pickable_flag => l_pickable_flag);
1442:
1443: IF l_reservable_flag = 'N'
1444: AND
1445: (NVL(l_orig_sub, FND_API.G_MISS_CHAR) <> NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR))
1446: AND
1447: (l_status = 'Y' OR (l_status = 'S' AND l_pickable_flag = 'N'))
1448: THEN
1449:

Line 1974: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)

1970: --item's primary uom value is different in new organization.
1971: --BUG#11893915
1972: IF (l_count > 0) THEN
1973: --{
1974: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
1975: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id) )
1976: and ((p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) or
1977: (p_attributes_rec.inventory_item_id = g_cache_detail_rec.inventory_item_id) )THEN
1978: --{

Line 1976: and ((p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) or

1972: IF (l_count > 0) THEN
1973: --{
1974: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
1975: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id) )
1976: and ((p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) or
1977: (p_attributes_rec.inventory_item_id = g_cache_detail_rec.inventory_item_id) )THEN
1978: --{
1979: OPEN C_item_details(p_attributes_rec.ship_from_org_id,g_cache_detail_rec.inventory_item_id);
1980: FETCH C_item_details INTO l_primary_uom;

Line 2092: /* l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;

2088: -- bug 5333667: clear attributes for WIP/supply source
2089: -- pass "g_miss_xxx" because we don't care.
2090: -- Bug 14011139 : Commenting the changes done for bug 5333667 as they
2091: -- resulted in regressions.
2092: /* l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
2093: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
2094: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
2095: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
2096: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;

Line 2093: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;

2089: -- pass "g_miss_xxx" because we don't care.
2090: -- Bug 14011139 : Commenting the changes done for bug 5333667 as they
2091: -- resulted in regressions.
2092: /* l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
2093: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
2094: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
2095: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
2096: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
2097: */

Line 2094: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;

2090: -- Bug 14011139 : Commenting the changes done for bug 5333667 as they
2091: -- resulted in regressions.
2092: /* l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
2093: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
2094: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
2095: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
2096: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
2097: */
2098: END IF;

Line 2095: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;

2091: -- resulted in regressions.
2092: /* l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
2093: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
2094: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
2095: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
2096: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
2097: */
2098: END IF;
2099: --

Line 2096: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;

2092: /* l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
2093: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
2094: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
2095: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
2096: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
2097: */
2098: END IF;
2099: --
2100: IF l_debug_on THEN

Line 2297: IF (p_attributes_rec.date_scheduled <> FND_API.G_MISS_DATE) AND

2293: -- in order to change the Date_Required on MO Line,whenever there is a
2294: -- change in the Dat_Scheduled on SO Line.
2295: -- The call should be made only if the delivery detail is 'Released to Warehouse'
2296: -- and a Move Order line exists.
2297: IF (p_attributes_rec.date_scheduled <> FND_API.G_MISS_DATE) AND
2298: (g_cache_detail_rec.date_scheduled <> p_attributes_rec.date_scheduled) THEN
2299:
2300:
2301: OPEN c_delivery_detail;

Line 2327: p_commit => FND_API.G_FALSE,

2323: END IF;
2324:
2325: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(
2326: p_api_version_number => 1.0,
2327: p_commit => FND_API.G_FALSE,
2328: x_return_status => x_return_status,
2329: x_msg_count => l_msg_count,
2330: x_msg_data => l_msg_data,
2331: p_trolin_tbl => l_trolin_tbl,

Line 2494: IF ((p_attributes_rec.ship_set_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.ship_set_id IS NULL))AND

2490: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FLAG',P_WMS_FLAG);
2491: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2492: END IF;
2493:
2494: IF ((p_attributes_rec.ship_set_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.ship_set_id IS NULL))AND
2495: (NVL(p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.ship_set_id, FND_API.G_MISS_NUM))
2496: THEN
2497:
2498: g_cache_detail_rec.cache_flag := 'N';

Line 2495: (NVL(p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.ship_set_id, FND_API.G_MISS_NUM))

2491: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2492: END IF;
2493:
2494: IF ((p_attributes_rec.ship_set_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.ship_set_id IS NULL))AND
2495: (NVL(p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.ship_set_id, FND_API.G_MISS_NUM))
2496: THEN
2497:
2498: g_cache_detail_rec.cache_flag := 'N';
2499:

Line 2500: IF p_attributes_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN

2496: THEN
2497:
2498: g_cache_detail_rec.cache_flag := 'N';
2499:
2500: IF p_attributes_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
2501: l_organization_id := g_cache_detail_rec.organization_id;
2502: ELSE
2503: l_organization_id := p_attributes_rec.ship_from_org_id;
2504: END IF;

Line 2530: AND p_attributes_rec.ship_set_id <> NVL(g_cache_detail_rec.ship_set_id, FND_API.G_MISS_NUM) THEN

2526: FETCH c_get_details into l_del_det, l_status, l_mo_line_id;
2527: EXIT WHEN c_get_details%NOTFOUND;
2528:
2529: IF p_attributes_rec.ship_set_id IS NOT NULL
2530: AND p_attributes_rec.ship_set_id <> NVL(g_cache_detail_rec.ship_set_id, FND_API.G_MISS_NUM) THEN
2531:
2532: -- Planned for Crossdocking scenario, ECO 4497224
2533: IF l_status = 'S' AND l_mo_line_id IS NULL THEN
2534: FND_MESSAGE.SET_NAME('WSH','WSH_CHANGE_SET_XDOCK_ERROR');

Line 2587: p_commit => FND_API.G_FALSE,

2583: END IF;
2584:
2585: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(
2586: p_api_version_number => 1.0,
2587: p_commit => FND_API.G_FALSE,
2588: x_return_status => x_return_status,
2589: x_msg_count => l_msg_count,
2590: x_msg_data => l_msg_data,
2591: p_trolin_tbl => l_trolin_tbl,

Line 2756: IF p_attributes_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN

2752: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2753: END IF;
2754: --
2755: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2756: IF p_attributes_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
2757: l_attr_tab(1).organization_id := g_cache_detail_rec.organization_id;
2758: l_attr_tab(1).ship_from_location_id := g_cache_detail_rec.organization_id;
2759: ELSE
2760: l_attr_tab(1).organization_id := p_attributes_rec.ship_from_org_id;

Line 2766: IF p_attributes_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN

2762: END IF;
2763: l_attr_tab(2).organization_id := g_cache_detail_rec.organization_id;
2764: l_attr_tab(2).ship_from_location_id := g_cache_detail_rec.organization_id;
2765:
2766: IF p_attributes_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN
2767:
2768: l_attr_tab(1).ship_to_location_id := g_cache_detail_rec.ship_to_site_use_id;
2769: ELSE
2770: l_attr_tab(1).ship_to_location_id := p_attributes_rec.ship_to_org_id;

Line 2779: IF p_attributes_rec.intmed_ship_to_org_id = FND_API.G_MISS_NUM THEN

2775: IF l_debug_on THEN
2776: WSH_DEBUG_SV.log(l_module_name,'p_attributes_rec.intmed_ship_to_org_id',p_attributes_rec.intmed_ship_to_org_id);
2777: END IF;
2778:
2779: IF p_attributes_rec.intmed_ship_to_org_id = FND_API.G_MISS_NUM THEN
2780:
2781: l_intmed_ship_to_location_id := g_cache_detail_rec.intmed_ship_to_location_id;
2782:
2783: ELSIF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL) THEN

Line 2798: IF p_attributes_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

2794:
2795: l_attr_tab(1).intmed_ship_to_location_id := l_intmed_ship_to_location_id;
2796: l_attr_tab(2).intmed_ship_to_location_id := g_cache_detail_rec.intmed_ship_to_location_id;
2797:
2798: IF p_attributes_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2799: l_attr_tab(1).customer_id := g_cache_detail_rec.customer_id;
2800: ELSE
2801: l_attr_tab(1).customer_id := p_attributes_rec.sold_to_org_id;
2802:

Line 2803: IF (NVL(p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.customer_id, FND_API.G_MISS_NUM)) THEN

2799: l_attr_tab(1).customer_id := g_cache_detail_rec.customer_id;
2800: ELSE
2801: l_attr_tab(1).customer_id := p_attributes_rec.sold_to_org_id;
2802:
2803: IF (NVL(p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.customer_id, FND_API.G_MISS_NUM)) THEN
2804:
2805: l_shipment_changed_flag := 'Y';
2806:
2807: END IF;

Line 2813: IF p_attributes_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

2809: END IF;
2810: l_attr_tab(2).customer_id := g_cache_detail_rec.customer_id;
2811:
2812:
2813: IF p_attributes_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2814: l_attr_tab(1).freight_terms_code := g_cache_detail_rec.freight_terms_code;
2815: ELSE
2816: l_attr_tab(1).freight_terms_code := p_attributes_rec.freight_terms_code;
2817:

Line 2818: IF (NVL(p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.freight_terms_code, FND_API.G_MISS_CHAR)) THEN

2814: l_attr_tab(1).freight_terms_code := g_cache_detail_rec.freight_terms_code;
2815: ELSE
2816: l_attr_tab(1).freight_terms_code := p_attributes_rec.freight_terms_code;
2817:
2818: IF (NVL(p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.freight_terms_code, FND_API.G_MISS_CHAR)) THEN
2819:
2820: l_shipment_changed_flag := 'Y';
2821:
2822: END IF;

Line 2831: IF p_attributes_rec.fob_code = FND_API.G_MISS_CHAR THEN

2827: WSH_DEBUG_SV.logmsg(l_module_name, 'freight_terms_code 1: '||p_attributes_rec.freight_terms_code );
2828: WSH_DEBUG_SV.logmsg(l_module_name, 'freight_terms_code 2: '||g_cache_detail_rec.freight_terms_code );
2829: END IF;
2830:
2831: IF p_attributes_rec.fob_code = FND_API.G_MISS_CHAR THEN
2832: l_attr_tab(1).fob_code := g_cache_detail_rec.fob_code;
2833: ELSE
2834: l_attr_tab(1).fob_code := p_attributes_rec.fob_code;
2835:

Line 2836: IF (NVL(p_attributes_rec.fob_code, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.fob_code, FND_API.G_MISS_CHAR)) THEN

2832: l_attr_tab(1).fob_code := g_cache_detail_rec.fob_code;
2833: ELSE
2834: l_attr_tab(1).fob_code := p_attributes_rec.fob_code;
2835:
2836: IF (NVL(p_attributes_rec.fob_code, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.fob_code, FND_API.G_MISS_CHAR)) THEN
2837:
2838: l_shipment_changed_flag := 'Y';
2839:
2840: END IF;

Line 2845: IF ((p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.shipping_method_code IS NULL)) AND

2841:
2842: END IF;
2843: l_attr_tab(2).fob_code := g_cache_detail_rec.fob_code;
2844:
2845: IF ((p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.shipping_method_code IS NULL)) AND
2846: (NVL(p_attributes_rec.shipping_method_code, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.ship_method_code,FND_API.G_MISS_CHAR)) THEN
2847:
2848: l_shipment_changed_flag := 'Y';
2849: l_sm_changed_flag := 'Y';

Line 2846: (NVL(p_attributes_rec.shipping_method_code, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.ship_method_code,FND_API.G_MISS_CHAR)) THEN

2842: END IF;
2843: l_attr_tab(2).fob_code := g_cache_detail_rec.fob_code;
2844:
2845: IF ((p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.shipping_method_code IS NULL)) AND
2846: (NVL(p_attributes_rec.shipping_method_code, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.ship_method_code,FND_API.G_MISS_CHAR)) THEN
2847:
2848: l_shipment_changed_flag := 'Y';
2849: l_sm_changed_flag := 'Y';
2850:

Line 3120: p_init_msg_list => FND_API.G_FALSE,

3116: l_del_in_rec.caller := 'WSH';
3117: l_del_in_rec.action_code := 'UPDATE';
3118:
3119: WSH_INTERFACE_GRP.Create_Update_Delivery(p_api_version_number => 1.0,
3120: p_init_msg_list => FND_API.G_FALSE,
3121: p_commit => FND_API.G_FALSE,
3122: p_in_rec => l_del_in_rec,
3123: p_rec_attr_tab => l_delivery_info_tab,
3124: x_del_out_rec_tab => l_del_out_rec_tab,

Line 3121: p_commit => FND_API.G_FALSE,

3117: l_del_in_rec.action_code := 'UPDATE';
3118:
3119: WSH_INTERFACE_GRP.Create_Update_Delivery(p_api_version_number => 1.0,
3120: p_init_msg_list => FND_API.G_FALSE,
3121: p_commit => FND_API.G_FALSE,
3122: p_in_rec => l_del_in_rec,
3123: p_rec_attr_tab => l_delivery_info_tab,
3124: x_del_out_rec_tab => l_del_out_rec_tab,
3125: x_return_status => x_return_status,

Line 3206: p_init_msg_list => FND_API.G_FALSE,

3202: l_detail_in_rec.action_code := 'UPDATE';
3203:
3204: WSH_INTERFACE_GRP.Create_Update_Delivery_Detail(
3205: p_api_version_number => 1.0,
3206: p_init_msg_list => FND_API.G_FALSE,
3207: p_commit => FND_API.G_FALSE,
3208: x_return_status => x_return_status,
3209: x_msg_count => l_msg_count,
3210: x_msg_data => l_msg_data,

Line 3207: p_commit => FND_API.G_FALSE,

3203:
3204: WSH_INTERFACE_GRP.Create_Update_Delivery_Detail(
3205: p_api_version_number => 1.0,
3206: p_init_msg_list => FND_API.G_FALSE,
3207: p_commit => FND_API.G_FALSE,
3208: x_return_status => x_return_status,
3209: x_msg_count => l_msg_count,
3210: x_msg_data => l_msg_data,
3211: p_detail_info_tab => l_detail_info_tab,

Line 3270: WHEN FND_API.G_EXC_ERROR THEN

3266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_NOT_ALLOWED');
3267: END IF;
3268: --
3269: RETURN;
3270: WHEN FND_API.G_EXC_ERROR THEN
3271: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3272: IF l_debug_on THEN
3273: wsh_debug_sv.logmsg(l_module_name,'G_EXC_ERROR');
3274: WSH_DEBUG_SV.pop(l_module_name);

Line 3276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3272: IF l_debug_on THEN
3273: wsh_debug_sv.logmsg(l_module_name,'G_EXC_ERROR');
3274: WSH_DEBUG_SV.pop(l_module_name);
3275: END IF;
3276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3277: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3278: IF l_debug_on THEN
3279: wsh_debug_sv.logmsg(l_module_name,'G_EXC_UNEXPECTED_ERROR');
3280: WSH_DEBUG_SV.pop(l_module_name);

Line 3371: (((p_attributes_rec.ship_tolerance_above <> FND_API.G_MISS_NUM)

3367: -- Consult with PM if the tolerance check is Required or not.
3368: -- ******************
3369:
3370: IF (
3371: (((p_attributes_rec.ship_tolerance_above <> FND_API.G_MISS_NUM)
3372: OR (p_attributes_rec.ship_tolerance_above IS NULL))
3373: AND
3374: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3375: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))

Line 3374: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>

3370: IF (
3371: (((p_attributes_rec.ship_tolerance_above <> FND_API.G_MISS_NUM)
3372: OR (p_attributes_rec.ship_tolerance_above IS NULL))
3373: AND
3374: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3375: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))
3376: OR
3377: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3378: OR (p_attributes_rec.ship_tolerance_below IS NULL))

Line 3375: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))

3371: (((p_attributes_rec.ship_tolerance_above <> FND_API.G_MISS_NUM)
3372: OR (p_attributes_rec.ship_tolerance_above IS NULL))
3373: AND
3374: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3375: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))
3376: OR
3377: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3378: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3379: AND

Line 3377: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)

3373: AND
3374: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3375: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))
3376: OR
3377: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3378: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3379: AND
3380: NVL(p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM) <>
3381: NVL(g_cache_detail_rec.ship_tolerance_below, FND_API.G_MISS_NUM))

Line 3380: NVL(p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM) <>

3376: OR
3377: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3378: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3379: AND
3380: NVL(p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM) <>
3381: NVL(g_cache_detail_rec.ship_tolerance_below, FND_API.G_MISS_NUM))
3382: ) THEN
3383:
3384: IF l_debug_on THEN

Line 3381: NVL(g_cache_detail_rec.ship_tolerance_below, FND_API.G_MISS_NUM))

3377: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3378: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3379: AND
3380: NVL(p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM) <>
3381: NVL(g_cache_detail_rec.ship_tolerance_below, FND_API.G_MISS_NUM))
3382: ) THEN
3383:
3384: IF l_debug_on THEN
3385: WSH_DEBUG_SV.log(l_module_name,'Tolerance Values are different');