APPS.CSM_USER_PKG dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24: x_return_status IN OUT NOCOPY VARCHAR2
25: ) IS
26:
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: END APPLY_INSERT;
30:
31:
32: /***

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: END;
66: END IF;
67:
68: -- success
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: csm_util_pkg.log
72: ( 'Leaving '|| g_object_name || '.APPLY_UPDATE',
73: g_object_name || '.APPLY_UPDATE',

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79: || ' for PK ' || p_record.user_id,
80: g_object_name || '.APPLY_UPDATE',
81: FND_LOG.LEVEL_EXCEPTION );
82:
83: x_return_status := FND_API.G_RET_STS_ERROR;
84:
85: END APPLY_UPDATE;
86:
87:

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: ) IS
98: BEGIN
99:
100: /*** initialize return status and message list ***/
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102: FND_MSG_PUB.INITIALIZE;
103:
104: IF p_record.dmltype$$='U' THEN
105: -- Process update

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124: , p_token_name1 => 'DML'
125: , p_token_value1 => p_record.dmltype$$
126: );
127:
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: END IF;
130:
131: EXCEPTION
132: WHEN OTHERS THEN

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

142: (
143: p_api_error => TRUE
144: );
145:
146: x_return_status := FND_API.G_RET_STS_ERROR;
147:
148: END APPLY_RECORD;
149:
150:

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
169: g_object_name || '.APPLY_CLIENT_CHANGES',
170: FND_LOG.LEVEL_PROCEDURE);
171: g_debug_level := p_debug_level;
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: OPEN c_USER_inq( p_user_name, p_tranid);
175: FETCH c_user_inq INTO r_user;
176: CLOSE c_user_inq;

Line 191: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

187: , l_process_status
188: );
189:
190: /*** was record processed successfully? ***/
191: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
192: /*** If Yes -> delete record from inqueue ***/
193: CSM_UTIL_PKG.DELETE_RECORD
194: (
195: p_user_name,

Line 206: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

202: l_process_status
203: );
204:
205: /*** was delete successful? ***/
206: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
207: /*** If No -> rollback ***/
208: CSM_UTIL_PKG.LOG
209: ( 'Deleting from inqueue failed, rolling back to savepoint'
210: || ' for PK ' || r_USER.user_id ,

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

210: || ' for PK ' || r_USER.user_id ,
211: g_object_name || '.APPLY_CLIENT_CHANGES',
212: FND_LOG.LEVEL_ERROR); -- put PK column here
213: ROLLBACK TO save_rec;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: END IF;
216: END IF;
217:
218: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 218: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

214: x_return_status := FND_API.G_RET_STS_ERROR;
215: END IF;
216: END IF;
217:
218: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
219: /*** Record was not processed successfully or delete failed
220: -> defer and reject record ***/
221: CSM_UTIL_PKG.LOG
222: ( 'Record not processed successfully, deferring and rejecting record'

Line 240: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

236: , r_USER.dmltype$$
237: );
238:
239: /*** Was defer successful? ***/
240: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
241: /*** no -> rollback ***/
242: CSM_UTIL_PKG.LOG
243: ( 'Defer record failed, rolling back to savepoint'
244: || ' for PK ' || r_USER.user_id ,

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: || ' for PK ' || r_USER.user_id ,
245: g_object_name || '.APPLY_CLIENT_CHANGES',
246: FND_LOG.LEVEL_ERROR); -- put PK column here
247: ROLLBACK TO save_rec;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: END IF;
250: END IF;
251:
252: END IF;

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: CSM_UTIL_PKG.LOG
257: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
258: g_object_name || '.APPLY_CLIENT_CHANGES',
259: FND_LOG.LEVEL_EXCEPTION);
260: x_return_status := FND_API.G_RET_STS_ERROR;
261:
262: END APPLY_CLIENT_CHANGES;
263:
264: END CSM_USER_PKG;