DBA Data[Home] [Help]

APPS.CSM_INVENTORY_PKG dependencies on FND_API

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: l_process_status VARCHAR2(1);
37: l_error_msg VARCHAR2(4000);
38: BEGIN
39: g_debug_level := p_debug_level;
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: /*** loop through debrief labor records in inqueue ***/
43: FOR r_inventory IN c_inventory( p_user_name, p_tranid) LOOP
44:

Line 60: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

56: l_process_status
57: );
58:
59: /*** was delete successful? ***/
60: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
61: /*** no -> rollback ***/
62: CSM_UTIL_PKG.LOG
63: ( 'Deleting from inqueue failed, rolling back to savepoint'
64: || ' for PK ' || r_inventory.gen_pk ,'CSM_INVENTORY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 66: x_return_status := FND_API.G_RET_STS_ERROR;

62: CSM_UTIL_PKG.LOG
63: ( 'Deleting from inqueue failed, rolling back to savepoint'
64: || ' for PK ' || r_inventory.gen_pk ,'CSM_INVENTORY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
65: ROLLBACK TO save_rec;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: END IF;
68:
69: END LOOP;
70:

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71: EXCEPTION WHEN OTHERS THEN
72: /*** catch and log exceptions ***/
73: CSM_UTIL_PKG.LOG
74: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM ,'CSM_INVENTORY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: END APPLY_CLIENT_CHANGES;
77:
78: END CSM_INVENTORY_PKG;