DBA Data[Home] [Help]

APPS.CSM_ORDERS_PKG dependencies on FND_API

Line 121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_data IS NOT NULL OR l_msg_count<>0 THEN

117: x_msg_count => l_msg_count,
118: x_msg_data => l_msg_data
119: );
120:
121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_data IS NOT NULL OR l_msg_count<>0 THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
124: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
125: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: x_msg_data => l_msg_data
119: );
120:
121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_data IS NOT NULL OR l_msg_count<>0 THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
124: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
125: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
126: RETURN ;

Line 182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

178: x_return_status => x_return_status,
179: x_error_message => p_error_msg
180: );
181:
182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: /*** exception occurred in API -> return errmsg ***/
184: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
185: (
186: p_api_error => TRUE

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209: (
210: p_api_error => TRUE
211: );
212:
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: END APPLY_UPDATE;
215:
216: /***
217: This procedure is called by APPLY_CLIENT_CHANGES for every record in inqueue that needs to be processed.

Line 228: x_return_status := FND_API.G_RET_STS_SUCCESS;

224: , x_reject_row OUT NOCOPY BOOLEAN
225: ) IS
226: BEGIN
227: /*** initialize return status and message list ***/
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229:
230: FND_MSG_PUB.INITIALIZE;
231:
232: CSM_UTIL_PKG.LOG

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: , p_token_name1 => 'DML'
263: , p_token_value1 => p_record.dmltype$$
264: );
265:
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: END IF;
268:
269: CSM_UTIL_PKG.LOG
270: ( 'Leaving CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id,

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284: (
285: p_api_error => TRUE
286: );
287:
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: END APPLY_RECORD;
290:
291: /***
292: This procedure is called by CSM_SERVICEP_WRAPPER_PKG when publication item CSM_REQ_LINES

Line 318: x_return_status := FND_API.G_RET_STS_SUCCESS;

314: p_debug_level); -- put PK column here
315:
316: g_debug_level := p_debug_level;
317: g_user_name := p_user_name;
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: /*** loop through records in inqueue ***/
321: FOR r_order_lines IN c_order_lines( p_user_name, p_tranid) LOOP
322:

Line 335: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

331: , l_reject_row
332: );
333:
334: /*** was record processed successfully? ***/
335: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
336: /*** If Yes -> delete record from inqueue ***/
337: IF l_reject_row THEN
338: CSM_UTIL_PKG.REJECT_RECORD
339: (

Line 364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

360: ); --process doesn't depend on this delete_record API
361: END IF;
362:
363: /*** was delete/reject successful? ***/
364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
365: /*** If No -> rollback ***/
366: CSM_UTIL_PKG.LOG
367: ( 'Deleting from inqueue failed, rolling back to savepoint'
368: || ' for PK ' || r_order_lines.line_id ,

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: || ' for PK ' || r_order_lines.line_id ,
369: g_object_name || '.APPLY_CLIENT_CHANGES',
370: FND_LOG.LEVEL_ERROR); -- put PK column here
371: ROLLBACK TO save_rec;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
375:
376: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 374: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/

370: FND_LOG.LEVEL_ERROR); -- put PK column here
371: ROLLBACK TO save_rec;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
375:
376: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
377: /*** Record was not processed successfully or delete failed
378: -> defer and reject record ***/

Line 376: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

372: x_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
375:
376: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
377: /*** Record was not processed successfully or delete failed
378: -> defer and reject record ***/
379: CSM_UTIL_PKG.LOG
380: ( 'Record not processed successfully, deferring and rejecting record'

Line 398: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

394: , r_order_lines.dmltype$$
395: );
396:
397: /*** Was defer successful? ***/
398: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
399: /*** no -> rollback ***/
400: CSM_UTIL_PKG.LOG
401: ( 'Defer record failed, rolling back to savepoint'
402: || ' for PK ' || r_order_lines.line_id ,

Line 406: x_return_status := FND_API.G_RET_STS_ERROR;

402: || ' for PK ' || r_order_lines.line_id ,
403: g_object_name || '.APPLY_CLIENT_CHANGES',
404: FND_LOG.LEVEL_ERROR); -- put PK column here
405: ROLLBACK TO save_rec;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: END IF;
408: END IF;
409:
410: END LOOP;