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 831: IF ( (p_attributes_rec.ordered_quantity <> FND_API.G_MISS_NUM)

827: END IF;
828: --bug#6407943
829: -- There is a possibility of having quantity change on delivery lines when there is a change in org
830: -- value on sales order line and item's primary uom is different in old and new orgs.
831: IF ( (p_attributes_rec.ordered_quantity <> FND_API.G_MISS_NUM)
832: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))
833: OR
834: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
835: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id)

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

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

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

830: -- value on sales order line and item's primary uom is different in old and new orgs.
831: IF ( (p_attributes_rec.ordered_quantity <> FND_API.G_MISS_NUM)
832: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))
833: OR
834: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
835: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id)
836: AND (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) ) THEN
837:
838: g_cache_detail_rec.cache_flag := 'N';

Line 836: AND (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) ) THEN

832: AND (p_attributes_rec.order_quantity_uom <> FND_API.G_MISS_CHAR))
833: OR
834: ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
835: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id)
836: AND (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) ) THEN
837:
838: g_cache_detail_rec.cache_flag := 'N';
839: WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity(
840: p_changed_attribute => p_attributes_rec,

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

1082: -- HW OPMCONV. Removed branching
1083:
1084: -- HW end of OM changes
1085:
1086: -- 2071048. ADDED the check condition g_cache_detail_rec.subinventory <> FND_API.G_MISS_CHAR to
1087: -- avoid looping through the delivery_details if the released_status of the lines is either
1088: -- 'B' or 'Y' or 'S'.
1089:
1090: --bug# 6689448 (replenishment project): begin

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

1087: -- avoid looping through the delivery_details if the released_status of the lines is either
1088: -- 'B' or 'Y' or 'S'.
1089:
1090: --bug# 6689448 (replenishment project): begin
1091: IF ( ( p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.subinventory IS NULL) )
1092: AND
1093: ( NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.subinventory, FND_API.G_MISS_CHAR )) THEN
1094: l_sub_change := 'Y';
1095: END IF;

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

1089:
1090: --bug# 6689448 (replenishment project): begin
1091: IF ( ( p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.subinventory IS NULL) )
1092: AND
1093: ( NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR) <> NVL(g_cache_detail_rec.subinventory, FND_API.G_MISS_CHAR )) THEN
1094: l_sub_change := 'Y';
1095: END IF;
1096: --bug# 6689448 (replenishment project): end
1097:

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

1094: l_sub_change := 'Y';
1095: END IF;
1096: --bug# 6689448 (replenishment project): end
1097:
1098: IF ((p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) AND
1099: (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id))
1100: OR (p_attributes_rec.date_scheduled IS NULL AND g_cache_detail_rec.date_scheduled IS NOT NULL)
1101: THEN
1102:

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

1103: l_change_sub_only := 'N';
1104:
1105: ELSIF ( (l_sub_change = 'Y')
1106: OR
1107: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1108: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1109: OR
1110: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1111: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))

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

1104:
1105: ELSIF ( (l_sub_change = 'Y')
1106: OR
1107: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1108: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1109: OR
1110: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1111: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))
1112: )

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

1106: OR
1107: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1108: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1109: OR
1110: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1111: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))
1112: )
1113: THEN
1114: l_change_sub_only := 'Y';

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

1107: ((p_attributes_rec.project_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.project_id IS NULL)) AND
1108: (NVL(p_attributes_rec.project_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.project_id, FND_API.G_MISS_NUM))
1109: OR
1110: ((p_attributes_rec.task_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.task_id IS NULL)) AND
1111: (NVL(p_attributes_rec.task_id, FND_API.G_MISS_NUM) <> NVL(g_cache_detail_rec.task_id, FND_API.G_MISS_NUM))
1112: )
1113: THEN
1114: l_change_sub_only := 'Y';
1115: END IF;

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

1120: IF l_debug_on THEN
1121: WSH_DEBUG_SV.logmsg(l_module_name, 'Old inventory_item_id '||g_cache_detail_rec.inventory_item_id ||
1122: ' New inventory_item_id '||p_attributes_rec.inventory_item_id);
1123: END IF;
1124: IF ( (p_attributes_rec.inventory_item_id <> FND_API.G_MISS_NUM)
1125: AND (p_attributes_rec.inventory_item_id <> g_cache_detail_rec.inventory_item_id) ) THEN
1126: --{
1127:
1128: l_change_item := 'Y';

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

1138: RAISE item_update_not_allowed;
1139: --}
1140: END IF;
1141: --check for new org.
1142: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
1143: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id) ) THEN
1144: --{
1145: l_final_org_id:= p_attributes_rec.ship_from_org_id;
1146: IF INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_final_org_id) THEN

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

1219: --}
1220: END IF;
1221:
1222: --8. Check if UOM conversion (from order UOM to primary uom) is different. if so - do not allow update of item.
1223: IF ( (p_attributes_rec.src_requested_quantity <> FND_API.G_MISS_NUM)
1224: AND (p_attributes_rec.src_requested_quantity <> g_cache_detail_rec.src_requested_quantity) ) THEN
1225: l_ordered_quantity := p_attributes_rec.src_requested_quantity;
1226: ELSE
1227: l_ordered_quantity := g_cache_detail_rec.src_requested_quantity;

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

1225: l_ordered_quantity := p_attributes_rec.src_requested_quantity;
1226: ELSE
1227: l_ordered_quantity := g_cache_detail_rec.src_requested_quantity;
1228: END IF;
1229: IF ( (p_attributes_rec.src_requested_quantity_uom <> FND_API.G_MISS_CHAR)
1230: AND (p_attributes_rec.src_requested_quantity_uom <> g_cache_detail_rec.src_requested_quantity_uom) ) THEN
1231: l_ordered_quantity_uom := p_attributes_rec.src_requested_quantity_uom;
1232: ELSE
1233: l_ordered_quantity_uom := g_cache_detail_rec.src_requested_quantity_uom;

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

1368: x_pickable_flag => l_pickable_flag);
1369:
1370: IF l_reservable_flag = 'N'
1371: AND
1372: (NVL(l_orig_sub, FND_API.G_MISS_CHAR) <> NVL(p_attributes_rec.subinventory, FND_API.G_MISS_CHAR))
1373: AND
1374: (l_status = 'Y' OR (l_status = 'S' AND l_pickable_flag = 'N'))
1375: THEN
1376:

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

1867: --Creation of reservations should be stopped when
1868: --item's primary uom value is different in new organization.
1869: IF (l_count > 0) THEN
1870: --{
1871: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
1872: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id) )
1873: and (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN
1874: --{
1875: OPEN C_item_details(p_attributes_rec.ship_from_org_id,g_cache_detail_rec.inventory_item_id);

Line 1873: and (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN

1869: IF (l_count > 0) THEN
1870: --{
1871: IF ( (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
1872: AND (p_attributes_rec.ship_from_org_id <> g_cache_detail_rec.organization_id) )
1873: and (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM ) THEN
1874: --{
1875: OPEN C_item_details(p_attributes_rec.ship_from_org_id,g_cache_detail_rec.inventory_item_id);
1876: FETCH C_item_details INTO l_primary_uom;
1877: CLOSE C_item_details;

Line 1986: l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;

1982: l_resv_tbl(i).task_id := p_attributes_rec.task_id;
1983:
1984: -- bug 5333667: clear attributes for WIP/supply source
1985: -- pass "g_miss_xxx" because we don't care.
1986: l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
1987: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
1988: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
1989: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
1990: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;

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

1983:
1984: -- bug 5333667: clear attributes for WIP/supply source
1985: -- pass "g_miss_xxx" because we don't care.
1986: l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
1987: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
1988: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
1989: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
1990: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
1991:

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

1984: -- bug 5333667: clear attributes for WIP/supply source
1985: -- pass "g_miss_xxx" because we don't care.
1986: l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
1987: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
1988: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
1989: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
1990: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
1991:
1992: END IF;

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

1985: -- pass "g_miss_xxx" because we don't care.
1986: l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
1987: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
1988: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
1989: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
1990: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
1991:
1992: END IF;
1993: --

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

1986: l_resv_tbl(i).supply_source_type_id := FND_API.G_MISS_NUM;
1987: l_resv_tbl(i).supply_source_header_id := FND_API.G_MISS_NUM;
1988: l_resv_tbl(i).supply_source_line_id := FND_API.G_MISS_NUM;
1989: l_resv_tbl(i).supply_source_name := FND_API.G_MISS_CHAR;
1990: l_resv_tbl(i).supply_source_line_detail := FND_API.G_MISS_NUM;
1991:
1992: END IF;
1993: --
1994: IF l_debug_on THEN

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

2171: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FLAG',P_WMS_FLAG);
2172: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2173: END IF;
2174: --
2175: IF (p_attributes_rec.date_scheduled <> FND_API.G_MISS_DATE) AND
2176: (g_cache_detail_rec.date_scheduled < p_attributes_rec.date_scheduled) THEN
2177:
2178: g_cache_detail_rec.cache_flag := 'N';
2179: --

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

2332: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FLAG',P_WMS_FLAG);
2333: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2334: END IF;
2335:
2336: IF ((p_attributes_rec.ship_set_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.ship_set_id IS NULL))AND
2337: (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))
2338: THEN
2339:
2340: g_cache_detail_rec.cache_flag := 'N';

Line 2337: (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))

2333: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2334: END IF;
2335:
2336: IF ((p_attributes_rec.ship_set_id <> FND_API.G_MISS_NUM) OR (p_attributes_rec.ship_set_id IS NULL))AND
2337: (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))
2338: THEN
2339:
2340: g_cache_detail_rec.cache_flag := 'N';
2341:

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

2338: THEN
2339:
2340: g_cache_detail_rec.cache_flag := 'N';
2341:
2342: IF p_attributes_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
2343: l_organization_id := g_cache_detail_rec.organization_id;
2344: ELSE
2345: l_organization_id := p_attributes_rec.ship_from_org_id;
2346: END IF;

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

2368: FETCH c_get_details into l_del_det, l_status, l_mo_line_id;
2369: EXIT WHEN c_get_details%NOTFOUND;
2370:
2371: IF p_attributes_rec.ship_set_id IS NOT NULL
2372: AND p_attributes_rec.ship_set_id <> NVL(g_cache_detail_rec.ship_set_id, FND_API.G_MISS_NUM) THEN
2373:
2374: -- Planned for Crossdocking scenario, ECO 4497224
2375: IF l_status = 'S' AND l_mo_line_id IS NULL THEN
2376: FND_MESSAGE.SET_NAME('WSH','WSH_CHANGE_SET_XDOCK_ERROR');

Line 2429: p_commit => FND_API.G_FALSE,

2425: END IF;
2426:
2427: INV_MOVE_ORDER_PUB.Process_Move_Order_Line(
2428: p_api_version_number => 1.0,
2429: p_commit => FND_API.G_FALSE,
2430: x_return_status => x_return_status,
2431: x_msg_count => l_msg_count,
2432: x_msg_data => l_msg_data,
2433: p_trolin_tbl => l_trolin_tbl,

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

2594: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2595: END IF;
2596: --
2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2598: IF p_attributes_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
2599: l_attr_tab(1).organization_id := g_cache_detail_rec.organization_id;
2600: l_attr_tab(1).ship_from_location_id := g_cache_detail_rec.organization_id;
2601: ELSE
2602: l_attr_tab(1).organization_id := p_attributes_rec.ship_from_org_id;

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

2604: END IF;
2605: l_attr_tab(2).organization_id := g_cache_detail_rec.organization_id;
2606: l_attr_tab(2).ship_from_location_id := g_cache_detail_rec.organization_id;
2607:
2608: IF p_attributes_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN
2609:
2610: l_attr_tab(1).ship_to_location_id := g_cache_detail_rec.ship_to_site_use_id;
2611: ELSE
2612: l_attr_tab(1).ship_to_location_id := p_attributes_rec.ship_to_org_id;

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

2617: IF l_debug_on THEN
2618: WSH_DEBUG_SV.log(l_module_name,'p_attributes_rec.intmed_ship_to_org_id',p_attributes_rec.intmed_ship_to_org_id);
2619: END IF;
2620:
2621: IF p_attributes_rec.intmed_ship_to_org_id = FND_API.G_MISS_NUM THEN
2622:
2623: l_intmed_ship_to_location_id := g_cache_detail_rec.intmed_ship_to_location_id;
2624:
2625: ELSIF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL) THEN

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

2636:
2637: l_attr_tab(1).intmed_ship_to_location_id := l_intmed_ship_to_location_id;
2638: l_attr_tab(2).intmed_ship_to_location_id := g_cache_detail_rec.intmed_ship_to_location_id;
2639:
2640: IF p_attributes_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2641: l_attr_tab(1).customer_id := g_cache_detail_rec.customer_id;
2642: ELSE
2643: l_attr_tab(1).customer_id := p_attributes_rec.sold_to_org_id;
2644:

Line 2645: 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

2641: l_attr_tab(1).customer_id := g_cache_detail_rec.customer_id;
2642: ELSE
2643: l_attr_tab(1).customer_id := p_attributes_rec.sold_to_org_id;
2644:
2645: 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
2646:
2647: l_shipment_changed_flag := 'Y';
2648:
2649: END IF;

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

2651: END IF;
2652: l_attr_tab(2).customer_id := g_cache_detail_rec.customer_id;
2653:
2654:
2655: IF p_attributes_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
2656: l_attr_tab(1).freight_terms_code := g_cache_detail_rec.freight_terms_code;
2657: ELSE
2658: l_attr_tab(1).freight_terms_code := p_attributes_rec.freight_terms_code;
2659:

Line 2660: 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

2656: l_attr_tab(1).freight_terms_code := g_cache_detail_rec.freight_terms_code;
2657: ELSE
2658: l_attr_tab(1).freight_terms_code := p_attributes_rec.freight_terms_code;
2659:
2660: 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
2661:
2662: l_shipment_changed_flag := 'Y';
2663:
2664: END IF;

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

2669: WSH_DEBUG_SV.logmsg(l_module_name, 'freight_terms_code 1: '||p_attributes_rec.freight_terms_code );
2670: WSH_DEBUG_SV.logmsg(l_module_name, 'freight_terms_code 2: '||g_cache_detail_rec.freight_terms_code );
2671: END IF;
2672:
2673: IF p_attributes_rec.fob_code = FND_API.G_MISS_CHAR THEN
2674: l_attr_tab(1).fob_code := g_cache_detail_rec.fob_code;
2675: ELSE
2676: l_attr_tab(1).fob_code := p_attributes_rec.fob_code;
2677:

Line 2678: 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

2674: l_attr_tab(1).fob_code := g_cache_detail_rec.fob_code;
2675: ELSE
2676: l_attr_tab(1).fob_code := p_attributes_rec.fob_code;
2677:
2678: 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
2679:
2680: l_shipment_changed_flag := 'Y';
2681:
2682: END IF;

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

2683:
2684: END IF;
2685: l_attr_tab(2).fob_code := g_cache_detail_rec.fob_code;
2686:
2687: IF ((p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.shipping_method_code IS NULL)) AND
2688: (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
2689:
2690: l_shipment_changed_flag := 'Y';
2691: l_sm_changed_flag := 'Y';

Line 2688: (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

2684: END IF;
2685: l_attr_tab(2).fob_code := g_cache_detail_rec.fob_code;
2686:
2687: IF ((p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) OR (p_attributes_rec.shipping_method_code IS NULL)) AND
2688: (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
2689:
2690: l_shipment_changed_flag := 'Y';
2691: l_sm_changed_flag := 'Y';
2692:

Line 2962: p_init_msg_list => FND_API.G_FALSE,

2958: l_del_in_rec.caller := 'WSH';
2959: l_del_in_rec.action_code := 'UPDATE';
2960:
2961: WSH_INTERFACE_GRP.Create_Update_Delivery(p_api_version_number => 1.0,
2962: p_init_msg_list => FND_API.G_FALSE,
2963: p_commit => FND_API.G_FALSE,
2964: p_in_rec => l_del_in_rec,
2965: p_rec_attr_tab => l_delivery_info_tab,
2966: x_del_out_rec_tab => l_del_out_rec_tab,

Line 2963: p_commit => FND_API.G_FALSE,

2959: l_del_in_rec.action_code := 'UPDATE';
2960:
2961: WSH_INTERFACE_GRP.Create_Update_Delivery(p_api_version_number => 1.0,
2962: p_init_msg_list => FND_API.G_FALSE,
2963: p_commit => FND_API.G_FALSE,
2964: p_in_rec => l_del_in_rec,
2965: p_rec_attr_tab => l_delivery_info_tab,
2966: x_del_out_rec_tab => l_del_out_rec_tab,
2967: x_return_status => x_return_status,

Line 3048: p_init_msg_list => FND_API.G_FALSE,

3044: l_detail_in_rec.action_code := 'UPDATE';
3045:
3046: WSH_INTERFACE_GRP.Create_Update_Delivery_Detail(
3047: p_api_version_number => 1.0,
3048: p_init_msg_list => FND_API.G_FALSE,
3049: p_commit => FND_API.G_FALSE,
3050: x_return_status => x_return_status,
3051: x_msg_count => l_msg_count,
3052: x_msg_data => l_msg_data,

Line 3049: p_commit => FND_API.G_FALSE,

3045:
3046: WSH_INTERFACE_GRP.Create_Update_Delivery_Detail(
3047: p_api_version_number => 1.0,
3048: p_init_msg_list => FND_API.G_FALSE,
3049: p_commit => FND_API.G_FALSE,
3050: x_return_status => x_return_status,
3051: x_msg_count => l_msg_count,
3052: x_msg_data => l_msg_data,
3053: p_detail_info_tab => l_detail_info_tab,

Line 3112: WHEN FND_API.G_EXC_ERROR THEN

3108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_NOT_ALLOWED');
3109: END IF;
3110: --
3111: RETURN;
3112: WHEN FND_API.G_EXC_ERROR THEN
3113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3114: IF l_debug_on THEN
3115: wsh_debug_sv.logmsg(l_module_name,'G_EXC_ERROR');
3116: WSH_DEBUG_SV.pop(l_module_name);

Line 3118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3114: IF l_debug_on THEN
3115: wsh_debug_sv.logmsg(l_module_name,'G_EXC_ERROR');
3116: WSH_DEBUG_SV.pop(l_module_name);
3117: END IF;
3118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3119: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3120: IF l_debug_on THEN
3121: wsh_debug_sv.logmsg(l_module_name,'G_EXC_UNEXPECTED_ERROR');
3122: WSH_DEBUG_SV.pop(l_module_name);

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

3209: -- Consult with PM if the tolerance check is Required or not.
3210: -- ******************
3211:
3212: IF (
3213: (((p_attributes_rec.ship_tolerance_above <> FND_API.G_MISS_NUM)
3214: OR (p_attributes_rec.ship_tolerance_above IS NULL))
3215: AND
3216: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3217: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))

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

3212: IF (
3213: (((p_attributes_rec.ship_tolerance_above <> FND_API.G_MISS_NUM)
3214: OR (p_attributes_rec.ship_tolerance_above IS NULL))
3215: AND
3216: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3217: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))
3218: OR
3219: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3220: OR (p_attributes_rec.ship_tolerance_below IS NULL))

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

3213: (((p_attributes_rec.ship_tolerance_above <> FND_API.G_MISS_NUM)
3214: OR (p_attributes_rec.ship_tolerance_above IS NULL))
3215: AND
3216: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3217: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))
3218: OR
3219: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3220: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3221: AND

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

3215: AND
3216: NVL(p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM) <>
3217: NVL(g_cache_detail_rec.ship_tolerance_above, FND_API.G_MISS_NUM))
3218: OR
3219: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3220: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3221: AND
3222: NVL(p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM) <>
3223: NVL(g_cache_detail_rec.ship_tolerance_below, FND_API.G_MISS_NUM))

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

3218: OR
3219: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3220: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3221: AND
3222: NVL(p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM) <>
3223: NVL(g_cache_detail_rec.ship_tolerance_below, FND_API.G_MISS_NUM))
3224: ) THEN
3225:
3226: IF l_debug_on THEN

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

3219: (((p_attributes_rec.ship_tolerance_below <> FND_API.G_MISS_NUM)
3220: OR (p_attributes_rec.ship_tolerance_below IS NULL))
3221: AND
3222: NVL(p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM) <>
3223: NVL(g_cache_detail_rec.ship_tolerance_below, FND_API.G_MISS_NUM))
3224: ) THEN
3225:
3226: IF l_debug_on THEN
3227: WSH_DEBUG_SV.log(l_module_name,'Tolerance Values are different');