125: p_error_msg := 'Issuing Subinventory Code not present';
126: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
127: || ' ROOT ERROR: ' || p_error_msg
128: || ' for PK ' ||
129: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
130:
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: RETURN;
133: END IF;
188: p_api_error => TRUE
189: );
190: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
191: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
192: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: return;
195: end if;
196: end if;
263: p_api_error => TRUE
264: );
265: CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '
266: || 'Root cause csp_transactions_pub.transact_material failed: '
267: || 'for Debrief Line Id: ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
268:
269: l_spare_update_status := 'FAILED';
270: else
271: l_spare_update_status := 'SUCCEEDED';
361: p_api_error => TRUE
362: );
363: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
364: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
365: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: return;
368: end if;
369:
393: p_api_error => TRUE
394: );
395:
396: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
397: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: END APPLY_INSERT;
400:
401:
424: ELSE
425: -- Process delete and updates; not supported for this entity
426: CSM_UTIL_PKG.LOG
427: ( 'Delete and Update is not supported for this entity'
428: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
429:
430: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
431: (
432: p_message => 'CSM_DML_OPERATION'
440: EXCEPTION WHEN OTHERS THEN
441: /*** defer record when any process exception occurs ***/
442: CSM_UTIL_PKG.LOG
443: ( 'Exception occurred in CSM_DEBRIEF_parts_PKG.APPLY_RECORD:' || ' ' || sqlerrm
444: || ' for PK ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
445:
446: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
447: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
448: (
507: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
508: /*** no -> rollback ***/
509: CSM_UTIL_PKG.LOG
510: ( 'Deleting from inqueue failed, rolling back to savepoint'
511: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
512: ROLLBACK TO save_rec;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515: END IF;
517: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
518: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
519: CSM_UTIL_PKG.LOG
520: ( 'Record not processed successfully, deferring and rejecting record'
521: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
522:
523: CSM_UTIL_PKG.DEFER_RECORD
524: (
525: p_user_name
537: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
538: /*** no -> rollback ***/
539: CSM_UTIL_PKG.LOG
540: ( 'Defer record failed, rolling back to savepoint'
541: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
542: ROLLBACK TO save_rec;
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: END IF;
545: END IF;
549: EXCEPTION WHEN OTHERS THEN
550: /*** catch and log exceptions ***/
551: CSM_UTIL_PKG.LOG
552: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
553: ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: END APPLY_CLIENT_CHANGES;
556: END CSM_DEBRIEF_PARTS_PKG;