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.OE_UPDATE_LINE_ACK_UTIL dependencies on FND_API

Line 90: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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:

Line 91: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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';

Line 108: , nvl(org_id, FND_API.G_MISS_NUM)

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)

Line 109: , nvl(line_number, 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)

Line 110: , nvl(shipment_number, FND_API.G_MISS_NUM)

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)

Line 111: , nvl(line_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)

Line 112: , nvl(line_type_id, FND_API.G_MISS_NUM)

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)

Line 113: , nvl(item_type_code, FND_API.G_MISS_CHAR)

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)

Line 114: , nvl(inventory_item_id, 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)
118: , nvl(last_ack_date, FND_API.G_MISS_DATE)

Line 115: , nvl(first_ack_code, FND_API.G_MISS_CHAR)

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

Line 116: , nvl(first_ack_date, FND_API.G_MISS_DATE)

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

Line 117: , nvl(last_ack_code, FND_API.G_MISS_CHAR)

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

Line 118: , nvl(last_ack_date, FND_API.G_MISS_DATE)

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

Line 302: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 304: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 305: RAISE FND_API.G_EXC_ERROR;

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

Line 314: OE_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

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:

Line 344: WHEN FND_API.G_EXC_ERROR THEN

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:

Line 345: p_return_status := FND_API.G_RET_STS_ERROR ;

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

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

Line 350: p_return_status := FND_API.G_RET_STS_UNEXP_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:
354: WHEN OTHERS THEN

Line 355: 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
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);