86: l_change_sequence VARCHAR2(50) := p_change_sequence;
87: l_orig_sys_line_ref VARCHAR2(50) := p_orig_sys_line_ref;
88: l_orig_sys_shipment_ref VARCHAR2(50) := p_orig_sys_shipment_ref;
89:
90: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
91: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
92:
93: l_msg_index NUMBER;
94:
87: l_orig_sys_line_ref VARCHAR2(50) := p_orig_sys_line_ref;
88: l_orig_sys_shipment_ref VARCHAR2(50) := p_orig_sys_shipment_ref;
89:
90: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
91: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
92:
93: l_msg_index NUMBER;
94:
95: l_api_name CONSTANT VARCHAR2(30) := 'Update_Line_Ack';
104: , orig_sys_document_ref
105: , change_sequence
106: , orig_sys_line_ref
107: , orig_sys_shipment_ref
108: , nvl(org_id, FND_API.G_MISS_NUM)
109: , nvl(line_number, FND_API.G_MISS_NUM)
110: , nvl(shipment_number, FND_API.G_MISS_NUM)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
105: , change_sequence
106: , orig_sys_line_ref
107: , orig_sys_shipment_ref
108: , nvl(org_id, FND_API.G_MISS_NUM)
109: , nvl(line_number, FND_API.G_MISS_NUM)
110: , nvl(shipment_number, FND_API.G_MISS_NUM)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
106: , orig_sys_line_ref
107: , orig_sys_shipment_ref
108: , nvl(org_id, FND_API.G_MISS_NUM)
109: , nvl(line_number, FND_API.G_MISS_NUM)
110: , nvl(shipment_number, FND_API.G_MISS_NUM)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
107: , orig_sys_shipment_ref
108: , nvl(org_id, FND_API.G_MISS_NUM)
109: , nvl(line_number, FND_API.G_MISS_NUM)
110: , nvl(shipment_number, FND_API.G_MISS_NUM)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
108: , nvl(org_id, FND_API.G_MISS_NUM)
109: , nvl(line_number, FND_API.G_MISS_NUM)
110: , nvl(shipment_number, FND_API.G_MISS_NUM)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
116: , nvl(first_ack_date, FND_API.G_MISS_DATE)
109: , nvl(line_number, FND_API.G_MISS_NUM)
110: , nvl(shipment_number, FND_API.G_MISS_NUM)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
116: , nvl(first_ack_date, FND_API.G_MISS_DATE)
117: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
110: , nvl(shipment_number, FND_API.G_MISS_NUM)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
116: , nvl(first_ack_date, FND_API.G_MISS_DATE)
117: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
118: , nvl(last_ack_date, FND_API.G_MISS_DATE)
111: , nvl(line_id, FND_API.G_MISS_NUM)
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
116: , nvl(first_ack_date, FND_API.G_MISS_DATE)
117: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
118: , nvl(last_ack_date, FND_API.G_MISS_DATE)
119: FROM oe_order_lines
112: , nvl(line_type_id, FND_API.G_MISS_NUM)
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
116: , nvl(first_ack_date, FND_API.G_MISS_DATE)
117: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
118: , nvl(last_ack_date, FND_API.G_MISS_DATE)
119: FROM oe_order_lines
120: WHERE order_source_id = l_order_source_id
113: , nvl(item_type_code, FND_API.G_MISS_CHAR)
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
116: , nvl(first_ack_date, FND_API.G_MISS_DATE)
117: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
118: , nvl(last_ack_date, FND_API.G_MISS_DATE)
119: FROM oe_order_lines
120: WHERE order_source_id = l_order_source_id
121: AND orig_sys_document_ref = l_orig_sys_document_ref
114: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
116: , nvl(first_ack_date, FND_API.G_MISS_DATE)
117: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
118: , nvl(last_ack_date, FND_API.G_MISS_DATE)
119: FROM oe_order_lines
120: WHERE order_source_id = l_order_source_id
121: AND orig_sys_document_ref = l_orig_sys_document_ref
122: AND change_sequence = l_change_sequence
298: IF l_debug_level > 0 THEN
299: oe_debug_pub.add( 'RETURN_STATUS: '||P_RETURN_STATUS ) ;
300: END IF;
301:
302: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
299: oe_debug_pub.add( 'RETURN_STATUS: '||P_RETURN_STATUS ) ;
300: END IF;
301:
302: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
307:
300: END IF;
301:
302: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
307:
308:
301:
302: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
307:
308:
309: IF l_debug_level > 0 THEN
310: oe_debug_pub.add( 'ACKNOWLEDGMENT CODE AND DATE UPDATED FOR LINE REF: '|| L_ORIG_SYS_LINE_REF ) ;
311: END IF;
312:
313: /*
314: OE_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
315: p_count => p_msg_count,
316: p_data => p_msg_data);
317: */
318:
340: END IF;
341:
342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: p_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
347: p_data => p_msg_data);
348:
341:
342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: p_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
347: p_data => p_msg_data);
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: p_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
347: p_data => p_msg_data);
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
352: p_data => p_msg_data);
353:
346: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
347: p_data => p_msg_data);
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
352: p_data => p_msg_data);
353:
354: WHEN OTHERS THEN
351: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
352: p_data => p_msg_data);
353:
354: WHEN OTHERS THEN
355: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356:
357: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
358: then
359: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);