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

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: l_null_char_val VARCHAR2(1000);
56: BEGIN
57:
58: -- Initialize API return status to success
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: IF (g_debug = 1) THEN
62: print_debug('item_id: '||p_inventory_item_id||', serial_number: '||p_serial_number||
63: ', attribute_category: '||p_attribute_category);

Line 189: RAISE FND_API.G_EXC_ERROR;

185: IF g_debug = 1 THEN
186: print_debug('Req segment is not populated');
187: END IF;
188:
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191: ELSE
192: IF g_debug = 1 THEN
193: print_debug('This segment is not required');

Line 258: RAISE FND_API.G_EXC_ERROR;

254: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
255: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
256: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
257: fnd_msg_pub.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259:
260: IF g_debug = 1 THEN
261: print_debug('Req segment is not populated');
262: END IF;

Line 303: RAISE FND_API.G_EXC_ERROR;

299: fnd_message.set_token('SEGMENT', 'ATTRIBUTE' || v_index1);
300: fnd_message.set_token('CONTEXT', l_context);
301: fnd_msg_pub.ADD;
302: --print_debug('Error out. Correct segmenst are not populated ');
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: v_index1 := p_attributes_tbl.NEXT(v_index1);
307: l_chk_flag := 0;

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

389: END IF;
390:
391: EXCEPTION
392: WHEN serial_not_found THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN errors_received THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;

Line 394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

390:
391: EXCEPTION
392: WHEN serial_not_found THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN errors_received THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: error_msg := fnd_flex_descval.error_message;

Line 397: x_return_status := FND_API.G_RET_STS_ERROR;

393: x_return_status := FND_API.G_RET_STS_ERROR;
394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN errors_received THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: error_msg := fnd_flex_descval.error_message;
399: s := 1;
400: e := 200;
401:

Line 414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

410: e := e + 200;
411: END LOOP;
412:
413: ROLLBACK TO get_serial_attr_information;
414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 415: WHEN FND_API.G_EXC_ERROR THEN

411: END LOOP;
412:
413: ROLLBACK TO get_serial_attr_information;
414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412:
413: ROLLBACK TO get_serial_attr_information;
414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: ROLLBACK TO get_serial_attr_information;
422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: ROLLBACK TO get_serial_attr_information;
422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
423: WHEN OTHERS THEN

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: ROLLBACK TO get_serial_attr_information;
422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: ROLLBACK TO get_serial_attr_information;
422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: ROLLBACK TO get_serial_attr_information;
426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: ROLLBACK TO get_serial_attr_information;
422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: ROLLBACK TO get_serial_attr_information;
426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
427: print_debug('Error ' || SQLERRM);
428: END Update_Serial_number_attr;

Line 426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: ROLLBACK TO get_serial_attr_information;
426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
427: print_debug('Error ' || SQLERRM);
428: END Update_Serial_number_attr;
429:
430: END INV_SERIAL_NUMBER_ATTR;