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_DEBRIEF_EXPENSES_PKG

Line 1: PACKAGE BODY CSM_DEBRIEF_EXPENSES_PKG AS

1: PACKAGE BODY CSM_DEBRIEF_EXPENSES_PKG AS
2: /* $Header: csmudbeb.pls 120.4 2008/03/24 08:57:46 ptomar ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

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

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

Line 153: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

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;
156: end if;
157: end if;

Line 231: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;
234: end if;
235:

Line 262: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

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:
266: /***

Line 360: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE: P_KEY = '

356: if(fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE)
357: = csm_profile_pkg.g_SERVER_WINS) then
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;

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 389: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

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;
392: return;
393: end if;

Line 404: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );

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

Line 444: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

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
447: (
448: p_message => 'CSM_DML_OPERATION'

Line 459: ( 'Exception occurred in CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD:' || ' ' || sqlerrm

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);
463: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 460: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );

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);
463: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
464: (

Line 527: || ' for PK ' || r_debrief_expenses.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

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;
530: END IF;
531: END IF;

Line 537: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

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
540: (
541: p_user_name

Line 557: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

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;
560: END IF;
561: END IF;

Line 569: 'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION );

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;
572:
573: END CSM_DEBRIEF_EXPENSES_PKG;

Line 573: END CSM_DEBRIEF_EXPENSES_PKG;

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;
572:
573: END CSM_DEBRIEF_EXPENSES_PKG;