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

Line 9: p_commit IN VARCHAR2:= FND_API.G_FALSE

5: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_ITEM_PVT';
6:
7: PROCEDURE insert_item
8: (
9: p_commit IN VARCHAR2:= FND_API.G_FALSE
10: , x_return_status OUT NOCOPY VARCHAR2
11: , x_msg_count OUT NOCOPY NUMBER
12: , x_msg_data OUT NOCOPY VARCHAR2
13: , x_item_id OUT NOCOPY NUMBER

Line 188: IF (l_x_master_item_return_status = FND_API.G_RET_STS_SUCCESS) THEN

184: 'Comms_NL_Trackable_Flag: '||l_x_master_item_rec.comms_nl_trackable_flag||
185: ' Inventory_Item_Flag: '||l_x_master_item_rec.Inventory_item_flag);
186: END IF;
187:
188: IF (l_x_master_item_return_status = FND_API.G_RET_STS_SUCCESS) THEN
189:
190: IF (l_master_org_id <> p_organization_id) THEN
191: l_asset_group.organization_id := p_organization_id;
192:

Line 217: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

213: ' Inventory_Item_Flag: '||l_x_curr_item_rec.Inventory_item_flag);
214: END IF;
215:
216:
217: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
218: x_return_status := 'S';
219: ELSE
220:
221: v_row := l_x_curr_item_error_tbl.FIRST;

Line 250: IF fnd_api.to_boolean(p_commit) THEN

246: x_return_status := 'E';
247:
248: END IF;
249:
250: IF fnd_api.to_boolean(p_commit) THEN
251: commit;
252: END IF;
253:
254: x_item_id := l_x_curr_item_rec.inventory_item_id;

Line 264: p_commit IN VARCHAR2:= FND_API.G_FALSE

260: END INSERT_ITEM;
261:
262: PROCEDURE update_item
263: (
264: p_commit IN VARCHAR2:= FND_API.G_FALSE
265: , x_return_status OUT NOCOPY VARCHAR2
266: , x_msg_count OUT NOCOPY NUMBER
267: , x_msg_data OUT NOCOPY VARCHAR2
268: , p_inventory_item_id IN NUMBER

Line 346: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

342: x_return_status => l_x_return_status,
343: x_Error_tbl => l_x_curr_item_error_tbl
344: );
345:
346: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
347: v_row := l_x_master_item_error_tbl.FIRST;
348: LOOP
349: EXIT WHEN v_row IS NULL;
350:

Line 380: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

376: 'Comms_NL_Trackable_Flag: '||l_x_curr_item_rec.comms_nl_trackable_flag||
377: ' Inventory_Item_Flag: '||l_x_curr_item_rec.Inventory_item_flag);
378: END IF;
379:
380: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
381: x_return_status := 'S';
382: ELSE
383:
384: v_row := l_x_curr_item_error_tbl.FIRST;

Line 397: IF fnd_api.to_boolean(p_commit) THEN

393:
394: x_return_status := 'E';
395: END IF;
396:
397: IF fnd_api.to_boolean(p_commit) THEN
398: commit;
399: END IF;
400:
401: IF (l_plog) THEN

Line 408: p_commit IN VARCHAR2:= FND_API.G_FALSE , x_return_status OUT NOCOPY VARCHAR2

404: END IF;
405: END UPDATE_ITEM;
406:
407: PROCEDURE Lock_Item(
408: p_commit IN VARCHAR2:= FND_API.G_FALSE , x_return_status OUT NOCOPY VARCHAR2
409: , x_msg_count OUT NOCOPY NUMBER
410: , x_msg_data OUT NOCOPY VARCHAR2
411: , p_inventory_item_id IN NUMBER
412: , p_organization_id IN NUMBER

Line 470: IF fnd_api.to_boolean(p_commit) THEN

466: end if;
467:
468: -- End of API body.
469: -- Standard check of p_commit.
470: IF fnd_api.to_boolean(p_commit) THEN
471: COMMIT WORK;
472: IF (l_plog) THEN
473: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
474: 'Commiting Work');

Line 482: WHEN fnd_api.g_exc_error THEN

478: -- Standard call to get message count and if count is 1, get message info.
479: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
480:
481: EXCEPTION
482: WHEN fnd_api.g_exc_error THEN
483: ROLLBACK TO lock_ITEM;
484: IF (l_plog) THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
486: 'Rollback To Lock_Item.....');

Line 490: x_return_status := fnd_api.g_ret_sts_error;

486: 'Rollback To Lock_Item.....');
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
488: '==============INV_ITEM_GRP.Lock_Item :EXPECTED ERROR===================');
489: END IF;
490: x_return_status := fnd_api.g_ret_sts_error;
491: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
492: WHEN fnd_api.g_exc_unexpected_error THEN
493: ROLLBACK TO lock_ITEM;
494: IF (l_plog) THEN

Line 492: WHEN fnd_api.g_exc_unexpected_error THEN

488: '==============INV_ITEM_GRP.Lock_Item :EXPECTED ERROR===================');
489: END IF;
490: x_return_status := fnd_api.g_ret_sts_error;
491: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
492: WHEN fnd_api.g_exc_unexpected_error THEN
493: ROLLBACK TO lock_ITEM;
494: IF (l_plog) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
496: 'Rollback To Lock_Item.....');

Line 500: x_return_status := fnd_api.g_ret_sts_unexp_error;

496: 'Rollback To Lock_Item.....');
497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
498: '==============INV_ITEM_GRP.Lock_Item :UNEXPECTED ERROR===================');
499: END IF;
500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: fnd_msg_pub.count_and_get(
502: p_count => x_msg_count
503: ,p_data => x_msg_data);
504: WHEN OTHERS THEN

Line 512: x_return_status := fnd_api.g_ret_sts_unexp_error;

508: 'Rollback To Lock_Item.....');
509: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
510: '==============INV_ITEM_GRP.Lock_Item :OTHER ERROR===================');
511: END IF;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;
513:
514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
515: fnd_msg_pub.add_exc_msg(g_pkg_name, 'LOCK_ITEM');
516: END IF;