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_UTIL_PKG

Line 147: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

143: -- This could have failed, so we need to check.
144: if x_return_status <> FND_API.G_RET_STS_SUCCESS
145: then
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_LABOR_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: return;

Line 227: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

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

254: CLOSE c_chk_task_status;
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

Line 262: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
264: p_api_error => TRUE
265: );
266:

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 387: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

383: );
384: if x_return_status <> FND_API.G_RET_STS_SUCCESS
385: then
386: /*** exception occurred in API -> return errmsg ***/
387: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
388: (
389: p_api_error => TRUE
390: );
391: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

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

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

Line 401: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

Line 445: CSM_UTIL_PKG.LOG

441: x_return_status
442: );
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

Line 449: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 461: CSM_UTIL_PKG.LOG

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

Line 466: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
468: p_api_error => TRUE
469: );
470:

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

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

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 512: CSM_UTIL_PKG.DELETE_RECORD

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

Line 527: CSM_UTIL_PKG.LOG

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

Line 537: CSM_UTIL_PKG.LOG

533: END IF;
534:
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

Line 541: CSM_UTIL_PKG.DEFER_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
544: , p_tranid
545: , r_debrief_labor.seqno$$

Line 557: CSM_UTIL_PKG.LOG

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

Line 569: CSM_UTIL_PKG.LOG

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