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_EXPENSES_PKG dependencies on CSM_UTIL_PKG

Line 145: csm_util_pkg.log('ABCD Test 03');

141:
142: -- This could have failed, so we need to check.
143: if x_return_status <> FND_API.G_RET_STS_SUCCESS
144: THEN
145: csm_util_pkg.log('ABCD Test 03');
146: /*** exception occurred in API -> return errmsg ***/
147: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
148: (
149: p_api_error => TRUE

Line 147: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

143: if x_return_status <> FND_API.G_RET_STS_SUCCESS
144: THEN
145: csm_util_pkg.log('ABCD Test 03');
146: /*** exception occurred in API -> return errmsg ***/
147: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
148: (
149: p_api_error => TRUE
150: );
151: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

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

147: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
148: (
149: p_api_error => TRUE
150: );
151: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
152: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
153: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: return;

Line 225: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

221: );
222: if x_return_status <> FND_API.G_RET_STS_SUCCESS
223: then
224: /*** exception occurred in API -> return errmsg ***/
225: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
226: (
227: p_api_error => TRUE
228: );
229: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

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

225: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
226: (
227: p_api_error => TRUE
228: );
229: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
230: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
231: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: return;

Line 257: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

253:
254: exception
255: when others then
256: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
257: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
258: (
259: p_api_error => TRUE
260: );
261: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

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

257: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
258: (
259: p_api_error => TRUE
260: );
261: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
262: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: END APPLY_INSERT;
265:

Line 362: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

358: if(r_cdl.last_update_date <> p_record.server_last_update_date) then
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE: P_KEY = '
361: || p_record.debrief_line_id;
362: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
363: return;
364: end if;
365: end if;
366:

Line 382: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

378: );
379: if x_return_status <> FND_API.G_RET_STS_SUCCESS
380: then
381: /*** exception occurred in API -> return errmsg ***/
382: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
383: (
384: p_api_error => TRUE
385: );
386:

Line 387: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

383: (
384: p_api_error => TRUE
385: );
386:
387: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
388: || ' ROOT ERROR: csf_debrief_pub.update_debrief_lines'
389: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
390:
391: x_return_status := FND_API.G_RET_STS_ERROR;

Line 398: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

394:
395: exception
396: when others then
397: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
398: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
399: (
400: p_api_error => TRUE
401: );
402:

Line 403: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

399: (
400: p_api_error => TRUE
401: );
402:
403: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
404: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: END APPLY_UPDATE;
407:

Line 442: CSM_UTIL_PKG.LOG

438: x_return_status
439: );
440: ELSE
441: -- Process delete; not supported for this entity
442: CSM_UTIL_PKG.LOG
443: ( 'Delete is not supported for this entity'
444: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
445:
446: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 446: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

442: CSM_UTIL_PKG.LOG
443: ( 'Delete is not supported for this entity'
444: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
445:
446: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
447: (
448: p_message => 'CSM_DML_OPERATION'
449: , p_token_name1 => 'DML'
450: , p_token_value1 => p_record.dmltype$$

Line 458: CSM_UTIL_PKG.LOG

454: END IF;
455:
456: EXCEPTION WHEN OTHERS THEN
457: /*** defer record when any process exception occurs ***/
458: CSM_UTIL_PKG.LOG
459: ( 'Exception occurred in CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD:' || ' ' || sqlerrm
460: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
461:
462: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);

Line 463: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

459: ( 'Exception occurred in CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD:' || ' ' || sqlerrm
460: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
461:
462: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
463: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
464: (
465: p_api_error => TRUE
466: );
467:

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

468: x_return_status := FND_API.G_RET_STS_ERROR;
469: END APPLY_RECORD;
470:
471: /***
472: This procedure is called by CSM_UTIL_PKG when publication item
473: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
474: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
475: public APIs.
476: ***/

Line 510: CSM_UTIL_PKG.DELETE_RECORD

506: /*** was record processed successfully? ***/
507: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
508: /*** Yes -> delete record from inqueue ***/
509:
510: CSM_UTIL_PKG.DELETE_RECORD
511: (
512: p_user_name,
513: p_tranid,
514: r_debrief_expenses.seqno$$,

Line 525: CSM_UTIL_PKG.LOG

521:
522: /*** was delete successful? ***/
523: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
524: /*** no -> rollback ***/
525: CSM_UTIL_PKG.LOG
526: ( 'Deleting from inqueue failed, rolling back to savepoint'
527: || ' for PK ' || r_debrief_expenses.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
528: ROLLBACK TO save_rec;
529: x_return_status := FND_API.G_RET_STS_ERROR;

Line 535: CSM_UTIL_PKG.LOG

531: END IF;
532:
533: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
534: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
535: CSM_UTIL_PKG.LOG
536: ( 'Record not processed successfully, deferring and rejecting record'
537: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
538:
539: CSM_UTIL_PKG.DEFER_RECORD

Line 539: CSM_UTIL_PKG.DEFER_RECORD

535: CSM_UTIL_PKG.LOG
536: ( 'Record not processed successfully, deferring and rejecting record'
537: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
538:
539: CSM_UTIL_PKG.DEFER_RECORD
540: (
541: p_user_name
542: , p_tranid
543: , r_debrief_expenses.seqno$$

Line 555: CSM_UTIL_PKG.LOG

551:
552: /*** Was defer successful? ***/
553: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
554: /*** no -> rollback ***/
555: CSM_UTIL_PKG.LOG
556: ( 'Defer record failed, rolling back to savepoint'
557: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
558: ROLLBACK TO save_rec;
559: x_return_status := FND_API.G_RET_STS_ERROR;

Line 567: CSM_UTIL_PKG.LOG

563: END LOOP;
564:
565: EXCEPTION WHEN OTHERS THEN
566: /*** catch and log exceptions ***/
567: CSM_UTIL_PKG.LOG
568: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
569: 'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION );
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: END APPLY_CLIENT_CHANGES;