DBA Data[Home] [Help]

APPS.CSM_INVENTORY_PKG dependencies on CSM_UTIL_PKG

Line 23: This procedure is called by CSM_UTIL_PKG when publication item

19: WHERE tranid$$ = b_tranid
20: AND clid$$cs = b_user_name;
21:
22: /***
23: This procedure is called by CSM_UTIL_PKG when publication item
24: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
25: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
26: public APIs.
27: ***/

Line 47: CSM_UTIL_PKG.DELETE_RECORD

43: FOR r_inventory IN c_inventory( p_user_name, p_tranid) LOOP
44:
45: SAVEPOINT save_rec;
46:
47: CSM_UTIL_PKG.DELETE_RECORD
48: (
49: p_user_name,
50: p_tranid,
51: r_inventory.seqno$$,

Line 62: CSM_UTIL_PKG.LOG

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
65: ROLLBACK TO save_rec;
66: x_return_status := FND_API.G_RET_STS_ERROR;

Line 73: CSM_UTIL_PKG.LOG

69: END LOOP;
70:
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: