eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_DEBRIEF_PARTS_PKG dependencies on CSM_DEBRIEF_PARTS_PKG

Line 1: PACKAGE BODY CSM_DEBRIEF_PARTS_PKG AS

1: PACKAGE BODY CSM_DEBRIEF_PARTS_PKG AS
2: /* $Header: csmudbpb.pls 120.4 2008/02/06 10:29:48 saradhak ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

Line 12: g_object_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_PARTS_PKG'; -- package name

8: -- Enter procedure, function bodies as shown below
9:
10:
11: /*** Globals ***/
12: g_object_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_PARTS_PKG'; -- package name
13: g_pub_name CONSTANT VARCHAR2(30) := 'CSF_M_DEBRIEF_PARTS'; -- publication item name
14: g_debug_level NUMBER; -- debug level
15:
16: CURSOR c_debrief_parts( b_user_name VARCHAR2, b_tranid NUMBER) is

Line 129: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;

Line 192: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;

Line 267: || 'for Debrief Line Id: ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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';

Line 365: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

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:

Line 397: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );

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:

Line 428: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

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'

Line 443: ( 'Exception occurred in CSM_DEBRIEF_parts_PKG.APPLY_RECORD:' || ' ' || sqlerrm

439:
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

Line 444: || ' for PK ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );

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: (

Line 511: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

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;

Line 521: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

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

Line 541: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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;

Line 553: ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

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;

Line 556: END CSM_DEBRIEF_PARTS_PKG;

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;