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

Line 274: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'

270: FETCH c_get_user_id INTO l_user_id;
271: CLOSE c_get_user_id;
272:
273: IF l_user_id Is NULL OR l_user_name IS NULL THEN
274: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'
275: || ' Task Assignment ID :' || l_task_assignment_id
276: || 'UNDO Failed.User Invalid',
277: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );
278: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 295: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'

291: CLOSE c_get_ta_from_acc;
292: --Check if the task assignment has been changed to another user before this UNDO
293: IF l_access_id IS NULL THEN
294: l_markdirty_all := 'N';
295: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'
296: || ' Task Assignment ID :' || l_task_assignment_id
297: || 'is no longer assigned to the user. UNDO Failed',
298: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );
299: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 309: CSM_UTIL_PKG.REJECT_RECORD

305: p_dml => asg_download.upd,
306: p_timestamp => sysdate);
307:
308: END IF;
309: CSM_UTIL_PKG.REJECT_RECORD
310: ( l_user_name
311: , l_tran_id
312: , l_sequence
313: , l_task_assignment_id

Line 321: CSM_UTIL_PKG.REJECT_RECORD

317: , l_process_status
318: );
319: ELSIF l_dml_type = 'I' THEN --insert
320: --Reject the Insert record
321: CSM_UTIL_PKG.REJECT_RECORD
322: ( l_user_name
323: , l_tran_id
324: , l_sequence
325: , l_task_assignment_id

Line 351: CSM_UTIL_PKG.REJECT_RECORD

347: --Task Assignment Audit Markdirty
348: FOR r_get_taa_from_inq IN c_get_taa_from_inq(l_task_assignment_id, l_user_name) LOOP
349: IF r_get_taa_from_inq.ASSIGNMENT_AUDIT_ID IS NOT NULL THEN
350: --Reject the record as it not needed for upload anymore
351: CSM_UTIL_PKG.REJECT_RECORD
352: ( l_user_name
353: , r_get_taa_from_inq.TRANID$$
354: , r_get_taa_from_inq.SEQNO$$
355: , r_get_taa_from_inq.ASSIGNMENT_AUDIT_ID

Line 386: CSM_UTIL_PKG.REJECT_RECORD

382: p_userid => l_user_id,
383: p_dml => asg_download.upd,
384: p_timestamp => sysdate);
385: END IF; --Task Markdirty
386: CSM_UTIL_PKG.REJECT_RECORD
387: ( l_user_name
388: , l_tran_id
389: , l_sequence
390: , l_task_id

Line 398: CSM_UTIL_PKG.REJECT_RECORD

394: , l_process_status
395: );
396: ELSIF l_dml_type = 'I' THEN --insert
397: --Reject the Insert record
398: CSM_UTIL_PKG.REJECT_RECORD
399: ( l_user_name
400: , l_tran_id
401: , l_sequence
402: , l_task_id

Line 437: CSM_UTIL_PKG.REJECT_RECORD

433: p_dml => asg_download.upd,
434: p_timestamp => sysdate);
435: END IF;
436: --Reject the record as it not needed for upload anymore
437: CSM_UTIL_PKG.REJECT_RECORD
438: ( l_user_name
439: , l_tran_id
440: , l_sequence
441: , l_incident_id

Line 449: CSM_UTIL_PKG.REJECT_RECORD

445: , l_process_status
446: );
447: ELSIF l_dml_type = 'I' THEN --insert
448: --Reject the Insert record
449: CSM_UTIL_PKG.REJECT_RECORD
450: ( l_user_name
451: , l_tran_id
452: , l_sequence
453: , l_incident_id

Line 479: CSM_UTIL_PKG.REJECT_RECORD

475: p_dml => asg_download.upd,
476: p_timestamp => sysdate);
477: END IF;
478: --Reject the record as it not needed for upload anymore
479: CSM_UTIL_PKG.REJECT_RECORD
480: ( l_user_name
481: , l_tran_id
482: , l_sequence
483: , l_debrief_header_id

Line 503: CSM_UTIL_PKG.REJECT_RECORD

499: p_dml => asg_download.upd,
500: p_timestamp => sysdate);
501: END IF;
502: --Reject the record as it not needed for upload anymore
503: CSM_UTIL_PKG.REJECT_RECORD
504: ( l_user_name
505: , r_get_debrief_expenses.TRANID$$
506: , r_get_debrief_expenses.SEQNO$$
507: , r_get_debrief_expenses.DEBRIEF_LINE_ID

Line 528: CSM_UTIL_PKG.REJECT_RECORD

524: p_dml => asg_download.upd,
525: p_timestamp => sysdate);
526: END IF;
527: --Reject the record as it not needed for upload anymore
528: CSM_UTIL_PKG.REJECT_RECORD
529: ( l_user_name
530: , r_get_debrief_labor.TRANID$$
531: , r_get_debrief_labor.SEQNO$$
532: , r_get_debrief_labor.DEBRIEF_LINE_ID

Line 553: CSM_UTIL_PKG.REJECT_RECORD

549: p_dml => asg_download.upd,
550: p_timestamp => sysdate);
551: END IF;
552: --Reject the record as it not needed for upload anymore
553: CSM_UTIL_PKG.REJECT_RECORD
554: ( l_user_name
555: , r_get_debrief_parts.TRANID$$
556: , r_get_debrief_parts.SEQNO$$
557: , r_get_debrief_parts.DEBRIEF_LINE_ID

Line 584: CSM_UTIL_PKG.REJECT_RECORD

580: p_dml => asg_download.upd,
581: p_timestamp => sysdate);
582: END IF;
583: --Reject the record as it not needed for upload anymore
584: CSM_UTIL_PKG.REJECT_RECORD
585: ( l_user_name
586: , l_tran_id
587: , l_sequence
588: , l_req_header_id

Line 608: CSM_UTIL_PKG.REJECT_RECORD

604: p_dml => asg_download.upd,
605: p_timestamp => sysdate);
606: END IF;
607: --Reject the record as it not needed for upload anymore
608: CSM_UTIL_PKG.REJECT_RECORD
609: ( l_user_name
610: , r_get_req_line.TRANID$$
611: , r_get_req_line.SEQNO$$
612: , r_get_req_line.requirement_line_id

Line 633: CSM_UTIL_PKG.REJECT_RECORD

629: p_dml => asg_download.upd,
630: p_timestamp => sysdate);
631: END IF;
632: --Reject the record as it not needed for upload anymore
633: CSM_UTIL_PKG.REJECT_RECORD
634: ( l_user_name
635: , r_get_notes.TRANID$$
636: , r_get_notes.SEQNO$$
637: , r_get_notes.jtf_note_id

Line 658: CSM_UTIL_PKG.REJECT_RECORD

654: p_dml => asg_download.upd,
655: p_timestamp => sysdate);
656: END IF;
657: --Reject the record as it not needed for upload anymore
658: CSM_UTIL_PKG.REJECT_RECORD
659: ( l_user_name
660: , r_get_lobs.TRANID$$
661: , r_get_lobs.SEQNO$$
662: , r_get_lobs.FILE_ID

Line 679: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',

675: -- success
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677:
678: EXCEPTION WHEN OTHERS THEN
679: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',
680: FND_LOG.LEVEL_EXCEPTION );
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: END APPLY_UNDO;
683:

Line 702: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_RECORD for PK1 Value ' || p_record.PK1_VALUE ,

698: /*** initialize return status and message list ***/
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: FND_MSG_PUB.INITIALIZE;
701:
702: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_RECORD for PK1 Value ' || p_record.PK1_VALUE ,
703: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
704:
705: IF p_record.dmltype$$='I' THEN
706: -- Process insert

Line 715: CSM_UTIL_PKG.LOG

711: x_return_status
712: );
713: ELSE --Delete and update is not supported for this PI
714: -- invalid dml type
715: CSM_UTIL_PKG.LOG
716: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
717: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
718:
719: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 719: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

715: CSM_UTIL_PKG.LOG
716: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
717: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
718:
719: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
720: (
721: p_message => 'CSM_DML_OPERATION'
722: , p_token_name1 => 'DML'
723: , p_token_value1 => p_record.dmltype$$

Line 729: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_RECORD for Undo Request ID ' || p_record.PK1_VALUE ,

725:
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: END IF;
728:
729: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_RECORD for Undo Request ID ' || p_record.PK1_VALUE ,
730: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
731: EXCEPTION WHEN OTHERS THEN
732: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
733: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 733: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

729: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_RECORD for Undo Request ID ' || p_record.PK1_VALUE ,
730: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
731: EXCEPTION WHEN OTHERS THEN
732: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
733: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
734: (
735: p_api_error => TRUE
736: );
737: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

Line 737: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

733: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
734: (
735: p_api_error => TRUE
736: );
737: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
738: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741:

Line 762: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_CLIENT_CHANGES ',

758: l_process_status VARCHAR2(1);
759: l_error_msg VARCHAR2(4000);
760:
761: BEGIN
762: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_CLIENT_CHANGES ',
763: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
764: g_debug_level := p_debug_level;
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766:

Line 781: CSM_UTIL_PKG.REJECT_RECORD

777:
778: /*** was record processed successfully? ***/
779: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
780: /*** Yes -> Reject record from inqueue ***/
781: CSM_UTIL_PKG.REJECT_RECORD
782: (
783: p_user_name,
784: p_tranid,
785: r_client_undo_rec.seqno$$,

Line 795: CSM_UTIL_PKG.LOG

791: );
792: /*** was delete successful? ***/
793: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
794: /*** no -> rollback ***/
795: CSM_UTIL_PKG.LOG
796: ( 'Reject record failed, rolling back to savepoint'
797: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
798: ROLLBACK TO save_rec;
799: x_return_status := FND_API.G_RET_STS_ERROR;

Line 803: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

799: x_return_status := FND_API.G_RET_STS_ERROR;
800: END IF;
801: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
802: /*** Record was not applied successfully -> defer and reject records ***/
803: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
804: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
805:
806: CSM_UTIL_PKG.REJECT_RECORD
807: (

Line 806: CSM_UTIL_PKG.REJECT_RECORD

802: /*** Record was not applied successfully -> defer and reject records ***/
803: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
804: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
805:
806: CSM_UTIL_PKG.REJECT_RECORD
807: (
808: p_user_name
809: , p_tranid
810: , r_client_undo_rec.seqno$$

Line 821: CSM_UTIL_PKG.LOG

817:
818: /*** Was defer successful? ***/
819: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
820: /*** no -> rollback ***/
821: CSM_UTIL_PKG.LOG
822: ( 'Reject record failed, No rolling back to savepoint'
823: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
824: ROLLBACK TO save_rec;
825: x_return_status := FND_API.G_RET_STS_ERROR;

Line 831: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',

827: END IF;
828:
829: END LOOP;
830:
831: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',
832: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
833:
834: EXCEPTION WHEN OTHERS THEN
835: /*** catch and log exceptions ***/

Line 836: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

832: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
833:
834: EXCEPTION WHEN OTHERS THEN
835: /*** catch and log exceptions ***/
836: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
837: ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
838:
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: