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

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

83: l_orig_sys_document_ref VARCHAR2(50);
84: l_orig_sys_line_ref VARCHAR2(50);
85: l_orig_sys_shipment_ref VARCHAR2(50);
86:
87: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
88: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
89:
90: l_msg_index NUMBER;
91:

Line 88: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

84: l_orig_sys_line_ref VARCHAR2(50);
85: l_orig_sys_shipment_ref VARCHAR2(50);
86:
87: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
88: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
89:
90: l_msg_index NUMBER;
91:
92: l_api_name CONSTANT VARCHAR2(30) := 'Update_Header_Ack';

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

95: CURSOR l_header_cursor IS
96: SELECT order_source_id
97: , orig_sys_document_ref
98: , change_sequence
99: , nvl(org_id, FND_API.G_MISS_NUM)
100: , nvl(header_id, FND_API.G_MISS_NUM)
101: , nvl(order_number, FND_API.G_MISS_NUM)
102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)

Line 100: , nvl(header_id, FND_API.G_MISS_NUM)

96: SELECT order_source_id
97: , orig_sys_document_ref
98: , change_sequence
99: , nvl(org_id, FND_API.G_MISS_NUM)
100: , nvl(header_id, FND_API.G_MISS_NUM)
101: , nvl(order_number, FND_API.G_MISS_NUM)
102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)

Line 101: , nvl(order_number, FND_API.G_MISS_NUM)

97: , orig_sys_document_ref
98: , change_sequence
99: , nvl(org_id, FND_API.G_MISS_NUM)
100: , nvl(header_id, FND_API.G_MISS_NUM)
101: , nvl(order_number, FND_API.G_MISS_NUM)
102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
105: , nvl(first_ack_date, FND_API.G_MISS_DATE)

Line 102: , nvl(ordered_date, FND_API.G_MISS_DATE)

98: , change_sequence
99: , nvl(org_id, FND_API.G_MISS_NUM)
100: , nvl(header_id, FND_API.G_MISS_NUM)
101: , nvl(order_number, FND_API.G_MISS_NUM)
102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
105: , nvl(first_ack_date, FND_API.G_MISS_DATE)
106: , nvl(last_ack_code, FND_API.G_MISS_CHAR)

Line 103: , nvl(order_type_id, FND_API.G_MISS_NUM)

99: , nvl(org_id, FND_API.G_MISS_NUM)
100: , nvl(header_id, FND_API.G_MISS_NUM)
101: , nvl(order_number, FND_API.G_MISS_NUM)
102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
105: , nvl(first_ack_date, FND_API.G_MISS_DATE)
106: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
107: , nvl(last_ack_date, FND_API.G_MISS_DATE)

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

100: , nvl(header_id, FND_API.G_MISS_NUM)
101: , nvl(order_number, FND_API.G_MISS_NUM)
102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
105: , nvl(first_ack_date, FND_API.G_MISS_DATE)
106: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
107: , nvl(last_ack_date, FND_API.G_MISS_DATE)
108: FROM oe_order_headers

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

101: , nvl(order_number, FND_API.G_MISS_NUM)
102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
105: , nvl(first_ack_date, FND_API.G_MISS_DATE)
106: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
107: , nvl(last_ack_date, FND_API.G_MISS_DATE)
108: FROM oe_order_headers
109: WHERE order_source_id = l_order_source_id

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

102: , nvl(ordered_date, FND_API.G_MISS_DATE)
103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
105: , nvl(first_ack_date, FND_API.G_MISS_DATE)
106: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
107: , nvl(last_ack_date, FND_API.G_MISS_DATE)
108: FROM oe_order_headers
109: WHERE order_source_id = l_order_source_id
110: AND orig_sys_document_ref = l_orig_sys_document_ref

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

103: , nvl(order_type_id, FND_API.G_MISS_NUM)
104: , nvl(first_ack_code, FND_API.G_MISS_CHAR)
105: , nvl(first_ack_date, FND_API.G_MISS_DATE)
106: , nvl(last_ack_code, FND_API.G_MISS_CHAR)
107: , nvl(last_ack_date, FND_API.G_MISS_DATE)
108: FROM oe_order_headers
109: WHERE order_source_id = l_order_source_id
110: AND orig_sys_document_ref = l_orig_sys_document_ref
111: ;

Line 276: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

272: IF l_debug_level > 0 THEN
273: oe_debug_pub.add( 'RETURN_STATUS: '||P_RETURN_STATUS ) ;
274: END IF;
275:
276: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

273: oe_debug_pub.add( 'RETURN_STATUS: '||P_RETURN_STATUS ) ;
274: END IF;
275:
276: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:

Line 278: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

274: END IF;
275:
276: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282:

Line 279: RAISE FND_API.G_EXC_ERROR;

275:
276: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282:
283: IF l_debug_level > 0 THEN

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

284: oe_debug_pub.add( 'ACKNOWLEDGMENT CODE AND DATE UPDATED FOR REF: '|| L_HEADER_REC_NEW.ORIG_SYS_DOCUMENT_REF ) ;
285: END IF;
286:
287: /*
288: OE_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
289: p_count => p_msg_count,
290: p_data => p_msg_data);
291: */
292:

Line 317: WHEN FND_API.G_EXC_ERROR THEN

313: END IF;
314:
315:
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: p_return_status := FND_API.G_RET_STS_ERROR ;
319: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
320: p_data => p_msg_data);
321:

Line 318: p_return_status := FND_API.G_RET_STS_ERROR ;

314:
315:
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: p_return_status := FND_API.G_RET_STS_ERROR ;
319: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
320: p_data => p_msg_data);
321:
322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

318: p_return_status := FND_API.G_RET_STS_ERROR ;
319: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
320: p_data => p_msg_data);
321:
322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
324: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
325: p_data => p_msg_data);
326:

Line 323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

319: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
320: p_data => p_msg_data);
321:
322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
324: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
325: p_data => p_msg_data);
326:
327: WHEN OTHERS THEN

Line 328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

324: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
325: p_data => p_msg_data);
326:
327: WHEN OTHERS THEN
328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
329:
330: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
331: then
332: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);