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_PARTS_PKG dependencies on FND_LOG

Line 175: CSM_UTIL_PKG.log( 'Entered APPLY_INSERT for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

171: l_mat_billable_flag VARCHAR2(30);
172: l_uom_code VARCHAR2(3);
173: BEGIN
174:
175: CSM_UTIL_PKG.log( 'Entered APPLY_INSERT for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
176:
177: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
178: G_REJECT_ROW := true;
179:

Line 184: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

180: -- validate to check if subinventory code is present
181: IF p_record.issuing_sub_inventory_code IS NULL THEN
182: p_error_msg := 'Issuing Subinventory Code not present';
183: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'|| ' ROOT ERROR: ' || p_error_msg|| ' for PK ' ||
184: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
185:
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: RETURN;
188: END IF;

Line 244: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

240: p_api_error => TRUE
241: );
242: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
243: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
244: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: return;
247: end if;
248: end if;

Line 319: || 'for Debrief Line Id: ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

315: p_api_error => TRUE
316: );
317: CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '
318: || 'Root cause csp_transactions_pub.transact_material failed: '
319: || 'for Debrief Line Id: ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
320:
321: l_spare_update_status := 'FAILED';
322: else
323: l_spare_update_status := 'SUCCEEDED';

Line 390: 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

386: p_error_msg := 'Item entered through Free form is Invalid.Please check if the item is valid in the Service Inventory Validation org.';
387: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
388: || ' ROOT ERROR: ' || p_error_msg
389: || ' for PK ' ||p_record.DEBRIEF_LINE_ID,
390: 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
391:
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: RETURN;
394: END IF;

Line 501: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

497: p_api_error => TRUE
498: );
499: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
500: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
501: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: return;
504: end if;
505:

Line 536: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );

532: p_api_error => TRUE
533: );
534:
535: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
536: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END APPLY_INSERT;
539:
540: /***

Line 596: CSM_UTIL_PKG.log( 'Entered APPLY_UPDATE for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

592: l_mat_billable_flag VARCHAR2(30);
593: L_UOM_CODE varchar2(3);
594: l_debrief_line_id NUMBER;
595: BEGIN
596: CSM_UTIL_PKG.log( 'Entered APPLY_UPDATE for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
597:
598: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
599: G_REJECT_ROW := FALSE;
600:

Line 607: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

603: p_error_msg := 'Issuing Subinventory Code not present';
604: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
605: || ' ROOT ERROR: ' || p_error_msg
606: || ' for PK ' ||
607: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
608:
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: RETURN;
611: END IF;

Line 632: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

628: p_error_msg := 'The Debrief Header is Missing for the Given Debrief lind id.Please verify';
629: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
630: || ' ROOT ERROR: ' || p_error_msg
631: || ' for PK ' ||
632: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: RETURN;
635: END IF;
636: --check for the stale data

Line 645: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

641: x_return_status := FND_API.G_RET_STS_ERROR;
642: p_error_msg :=
643: 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE: P_KEY = '
644: || p_record.debrief_line_id;
645: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
646: RETURN;
647: END IF;
648: END IF;
649:

Line 732: 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

728: p_error_msg := 'Item entered through Free form is Invalid.Please check if the item is valid in the Service Inventory Validation org.';
729: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
730: || ' ROOT ERROR: ' || p_error_msg
731: || ' for PK ' ||p_record.DEBRIEF_LINE_ID,
732: 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
733:
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: RETURN;
736: END IF;

Line 841: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

837: /*** exception occurred in API -> return errmsg ***/
838: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error=> TRUE);
839: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
840: || ' ROOT ERROR: csf_debrief_pub.update_debrief_line'
841: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: RETURN;
844: END IF;
845:

Line 868: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );

864: WHEN OTHERS THEN
865: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
866: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE);
867: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
868: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: END APPLY_UPDATE;
871:
872:

Line 907: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

903: ELSE
904: -- Process delete ; not supported for this entity
905: CSM_UTIL_PKG.LOG
906: ( 'Delete is not supported for this entity'
907: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
908:
909: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
910: (
911: p_message => 'CSM_DML_OPERATION'

Line 923: || ' for PK ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );

919: EXCEPTION WHEN OTHERS THEN
920: /*** defer record when any process exception occurs ***/
921: CSM_UTIL_PKG.LOG
922: ( 'Exception occurred in CSM_DEBRIEF_parts_PKG.APPLY_RECORD:' || ' ' || sqlerrm
923: || ' for PK ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
924:
925: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
926: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
927: (

Line 956: csm_util_pkg.log('csm_debrief_parts_pkg.apply_client_changes entered','CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

952: c_cur c_curtype;
953: r_debrief_parts c_debrief_parts%rowtype;
954: BEGIN
955:
956: csm_util_pkg.log('csm_debrief_parts_pkg.apply_client_changes entered','CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
957:
958: g_debug_level := p_debug_level;
959: x_return_status := FND_API.G_RET_STS_SUCCESS;
960:

Line 1029: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

1025: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
1026: /*** no -> rollback ***/
1027: CSM_UTIL_PKG.LOG
1028: ( 'Deleting from inqueue failed, rolling back to savepoint'
1029: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
1030: ROLLBACK TO save_rec;
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: END IF;
1033: END IF;

Line 1039: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

1035: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
1036: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
1037: CSM_UTIL_PKG.LOG
1038: ( 'Record not processed successfully, deferring and rejecting record'
1039: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
1040:
1041: CSM_UTIL_PKG.DEFER_RECORD
1042: (
1043: p_user_name

Line 1059: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

1055: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
1056: /*** no -> rollback ***/
1057: CSM_UTIL_PKG.LOG
1058: ( 'Defer record failed, rolling back to savepoint'
1059: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
1060: ROLLBACK TO save_rec;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: END IF;
1063: END IF;

Line 1072: ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

1068: EXCEPTION WHEN OTHERS THEN
1069: /*** catch and log exceptions ***/
1070: CSM_UTIL_PKG.LOG
1071: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
1072: ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: END APPLY_CLIENT_CHANGES;
1075: END CSM_DEBRIEF_PARTS_PKG;