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_LABOR_PKG dependencies on CSM_DEBRIEF_LABOR_PKG

Line 1: PACKAGE BODY CSM_DEBRIEF_LABOR_PKG AS

1: PACKAGE BODY CSM_DEBRIEF_LABOR_PKG AS
2: /* $Header: csmudblb.pls 120.4 2008/03/24 08:59:20 ptomar ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

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

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

Line 153: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_LABOR_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_LABOR_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 233: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_LABOR_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

229: p_api_error => TRUE
230: );
231: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
232: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
233: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_LABOR_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: return;
236: end if;
237:

Line 259: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_LABOR_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

255:
256: exception
257: when others then
258: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
259: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_LABOR_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
260:
261: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
262: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
263: (

Line 365: 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE: P_KEY = '

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

Line 367: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

363: x_return_status := FND_API.G_RET_STS_ERROR;
364: p_error_msg :=
365: 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE: P_KEY = '
366: || p_record.debrief_line_id;
367: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
368: return;
369: end if;
370: end if;
371:

Line 393: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

389: p_api_error => TRUE
390: );
391: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
392: || ' ROOT ERROR: csf_debrief_pub.update_debrief_lines'
393: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: return;
396: end if;
397:

Line 407: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );

403: p_api_error => TRUE
404: );
405:
406: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
407: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
408:
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: END APPLY_UPDATE;
411:

Line 447: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

443: ELSE
444: -- Process delete; not supported for this entity
445: CSM_UTIL_PKG.LOG
446: ( 'Delete is not supported for this entity'
447: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
448:
449: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
450: (
451: p_message => 'CSM_DML_OPERATION'

Line 462: ( 'Exception occurred in CSM_DEBRIEF_labor_PKG.APPLY_RECORD:' || ' ' || sqlerrm

458:
459: EXCEPTION WHEN OTHERS THEN
460: /*** defer record when any process exception occurs ***/
461: CSM_UTIL_PKG.LOG
462: ( 'Exception occurred in CSM_DEBRIEF_labor_PKG.APPLY_RECORD:' || ' ' || sqlerrm
463: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
464:
465: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
466: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 463: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

459: EXCEPTION WHEN OTHERS THEN
460: /*** defer record when any process exception occurs ***/
461: CSM_UTIL_PKG.LOG
462: ( 'Exception occurred in CSM_DEBRIEF_labor_PKG.APPLY_RECORD:' || ' ' || sqlerrm
463: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
464:
465: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
466: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
467: (

Line 491: csm_util_pkg.log('csm_debrief_labor_pkg.apply_client_changes entered','CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

487:
488: l_process_status VARCHAR2(1);
489: l_error_msg VARCHAR2(4000);
490: BEGIN
491: csm_util_pkg.log('csm_debrief_labor_pkg.apply_client_changes entered','CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
492: g_debug_level := p_debug_level;
493: x_return_status := FND_API.G_RET_STS_SUCCESS;
494:
495: /*** loop through debrief labor records in inqueue ***/

Line 529: || ' for PK ' || r_debrief_labor.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

525: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
526: /*** no -> rollback ***/
527: CSM_UTIL_PKG.LOG
528: ( 'Deleting from inqueue failed, rolling back to savepoint'
529: || ' for PK ' || r_debrief_labor.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
530: ROLLBACK TO save_rec;
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: END IF;

Line 539: || ' for PK ' || r_debrief_labor.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

535: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
536: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
537: CSM_UTIL_PKG.LOG
538: ( 'Record not processed successfully, deferring and rejecting record'
539: || ' for PK ' || r_debrief_labor.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
540:
541: CSM_UTIL_PKG.DEFER_RECORD
542: (
543: p_user_name

Line 559: || ' for PK ' || r_debrief_labor.debrief_line_id,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

555: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
556: /*** no -> rollback ***/
557: CSM_UTIL_PKG.LOG
558: ( 'Defer record failed, rolling back to savepoint'
559: || ' for PK ' || r_debrief_labor.debrief_line_id,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
560: ROLLBACK TO save_rec;
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: END IF;
563: END IF;

Line 570: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

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

Line 574: END CSM_DEBRIEF_LABOR_PKG;

570: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: END APPLY_CLIENT_CHANGES;
573:
574: END CSM_DEBRIEF_LABOR_PKG;