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_UTIL_PKG

Line 126: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

122:
123: -- validate to check if subinventory code is present
124: IF p_record.issuing_sub_inventory_code IS NULL THEN
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:

Line 186: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

182: -- This could have failed, so we need to check.
183: if x_return_status <> FND_API.G_RET_STS_SUCCESS
184: then
185: /*** exception occurred in API -> return errmsg ***/
186: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
187: (
188: p_api_error => TRUE
189: );
190: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 190: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

186: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
187: (
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;

Line 261: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

257: -- This could have failed, so we need to log the error.
258: if x_return_status <> FND_API.G_RET_STS_SUCCESS
259: then
260: -- exception occurred in API -> return errmsg
261: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
262: (
263: p_api_error => TRUE
264: );
265: CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '

Line 265: CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '

261: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
262: (
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';

Line 359: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

355: );
356: if x_return_status <> FND_API.G_RET_STS_SUCCESS
357: then
358: /*** exception occurred in API -> return errmsg ***/
359: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
360: (
361: p_api_error => TRUE
362: );
363: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 363: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

359: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
360: (
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;

Line 391: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

387:
388: exception
389: when others then
390: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
391: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
392: (
393: p_api_error => TRUE
394: );
395:

Line 396: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

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

Line 426: CSM_UTIL_PKG.LOG

422: x_return_status
423: );
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

Line 430: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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'
433: , p_token_name1 => 'DML'
434: , p_token_value1 => p_record.dmltype$$

Line 442: CSM_UTIL_PKG.LOG

438: END IF;
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);

Line 447: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
449: p_api_error => TRUE
450: );
451:

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

452: x_return_status := FND_API.G_RET_STS_ERROR;
453: END APPLY_RECORD;
454:
455: /***
456: This procedure is called by CSM_UTIL_PKG when publication item
457: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
458: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
459: public APIs.
460: ***/

Line 494: CSM_UTIL_PKG.DELETE_RECORD

490: /*** was record processed successfully? ***/
491: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
492: /*** Yes -> delete record from inqueue ***/
493:
494: CSM_UTIL_PKG.DELETE_RECORD
495: (
496: p_user_name,
497: p_tranid,
498: r_debrief_parts.seqno$$,

Line 509: CSM_UTIL_PKG.LOG

505:
506: /*** was delete successful? ***/
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;

Line 519: CSM_UTIL_PKG.LOG

515: END IF;
516:
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

Line 523: CSM_UTIL_PKG.DEFER_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
526: , p_tranid
527: , r_debrief_parts.seqno$$

Line 539: CSM_UTIL_PKG.LOG

535:
536: /*** Was defer successful? ***/
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;

Line 551: CSM_UTIL_PKG.LOG

547: END LOOP;
548:
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;