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

Line 40: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'

36: l_jtf_note_id number;
37:
38: BEGIN
39:
40: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
41: || ' for PK ' || p_record.jtf_note_id ,
42: 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
43:
44: --create the note

Line 45: CSM_UTIL_PKG.log( 'Creating Note ' || g_object_name || '.APPLY_INSERT:'

41: || ' for PK ' || p_record.jtf_note_id ,
42: 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
43:
44: --create the note
45: CSM_UTIL_PKG.log( 'Creating Note ' || g_object_name || '.APPLY_INSERT:'
46: || ' for PK ' || p_record.jtf_note_id ,
47: 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
48: jtf_notes_pub.Create_note
49: ( p_api_version => 1.0

Line 75: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

71:
72: if x_return_status <> FND_API.G_RET_STS_SUCCESS
73: then
74: /*** exception occurred in API -> return errmsg ***/
75: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
76: (
77: p_api_error => TRUE
78: );
79: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

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

75: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
76: (
77: p_api_error => TRUE
78: );
79: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
80: || ' ROOT ERROR: jtf_notes_pub.create_note'
81: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
82:
83: x_return_status := FND_API.G_RET_STS_ERROR;

Line 91: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

87:
88: exception
89: when others then
90: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
91: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
92: (
93: p_api_error => TRUE
94: );
95: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

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

91: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
92: (
93: p_api_error => TRUE
94: );
95: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
96: || ' for PK ' || p_record.jtf_note_id , 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
97: x_return_status := FND_API.G_RET_STS_ERROR;
98:
99: END APPLY_INSERT;

Line 122: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'

118: select last_update_date from jtf_notes_b
119: where jtf_note_id = p_jtf_note_id;
120:
121: BEGIN
122: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
123: || ' for PK ' || p_record.jtf_note_id,
124: 'CSM_NOTES_PKG.APPLY_UPDATE',
125: FND_LOG.LEVEL_PROCEDURE );
126: --get the last update date of the note

Line 144: csm_util_pkg.log(p_error_msg,'CSM_NOTES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EVENT );

140: if(l_server_last_update_date <> p_record.server_last_update_date) then
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_NOTES_PKG.APPLY_UPDATE: P_KEY = '
143: || p_record.jtf_note_id;
144: csm_util_pkg.log(p_error_msg,'CSM_NOTES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EVENT );
145: return;
146: end if;
147: end if;
148:

Line 173: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

169:
170: if x_return_status <> FND_API.G_RET_STS_SUCCESS
171: then
172: /*** exception occurred in API -> return errmsg ***/
173: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
174: (
175: p_api_error => TRUE
176: );
177: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

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

173: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
174: (
175: p_api_error => TRUE
176: );
177: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
178: || ' ROOT ERROR: jtf_notes_pub.update_note'
179: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
180:
181: x_return_status := FND_API.G_RET_STS_ERROR;

Line 186: CSM_UTIL_PKG.log( 'Exiting ' || g_object_name || '.APPLY_UPDATE:'

182: else
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: end if;
185:
186: CSM_UTIL_PKG.log( 'Exiting ' || g_object_name || '.APPLY_UPDATE:'
187: || ' for PK ' || p_record.jtf_note_id,
188: 'CSM_NOTES_PKG.APPLY_UPDATE',
189: FND_LOG.LEVEL_PROCEDURE );
190: exception

Line 193: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

189: FND_LOG.LEVEL_PROCEDURE );
190: exception
191: when others then
192: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
193: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
194: (
195: p_api_error => TRUE
196: );
197:

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

194: (
195: p_api_error => TRUE
196: );
197:
198: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
199: || ' for PK ' || p_record.jtf_note_id,
200: 'CSM_NOTES_PKG.APPLY_UPDATE',
201: FND_LOG.LEVEL_ERROR );
202:

Line 238: CSM_UTIL_PKG.LOG

234: x_return_status
235: );
236: ELSE*/
237: -- Process delete; not supported for this entity
238: CSM_UTIL_PKG.LOG
239: ( 'Update and Delete is not supported for this entity'
240: || ' for PK ' || p_record.jtf_note_id,
241: 'CSM_NOTES_PKG.APPLY_RECORD',
242: FND_LOG.LEVEL_EVENT );

Line 244: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

240: || ' for PK ' || p_record.jtf_note_id,
241: 'CSM_NOTES_PKG.APPLY_RECORD',
242: FND_LOG.LEVEL_EVENT );
243:
244: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
245: (
246: p_message => 'CSM_DML_OPERATION'
247: , p_token_name1 => 'DML'
248: , p_token_value1 => p_record.dmltype$$

Line 256: CSM_UTIL_PKG.LOG

252: END IF;
253:
254: EXCEPTION WHEN OTHERS THEN
255: /*** defer record when any process exception occurs ***/
256: CSM_UTIL_PKG.LOG
257: ( 'Exception occurred in CSM_notes_PKG.APPLY_RECORD:' || ' ' || sqlerrm
258: || ' for PK ' || p_record.jtf_note_id,
259: 'CSM_NOTES_PKG.APPLY_RECORD',
260: FND_LOG.LEVEL_ERROR );

Line 263: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

259: 'CSM_NOTES_PKG.APPLY_RECORD',
260: FND_LOG.LEVEL_ERROR );
261:
262: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
263: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
264: (
265: p_api_error => TRUE
266: );
267:

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

268: x_return_status := FND_API.G_RET_STS_ERROR;
269: END APPLY_RECORD;
270:
271: /***
272: This procedure is called by CSM_UTIL_PKG when publication item
273: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
274: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
275: public APIs.
276: ***/

Line 310: CSM_UTIL_PKG.DELETE_RECORD

306: /*** was record processed successfully? ***/
307: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
308: /*** Yes -> delete record from inqueue ***/
309:
310: CSM_UTIL_PKG.DELETE_RECORD
311: (
312: p_user_name,
313: p_tranid,
314: r_notes.seqno$$,

Line 325: CSM_UTIL_PKG.LOG

321:
322: /*** was delete successful? ***/
323: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
324: /*** no -> rollback ***/
325: CSM_UTIL_PKG.LOG
326: ( 'Deleting from inqueue failed, rolling back to savepoint'
327: || ' for PK ' || r_notes.jtf_note_id,
328: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
329: FND_LOG.LEVEL_EVENT ); -- put PK column here

Line 337: CSM_UTIL_PKG.LOG

333: END IF;
334:
335: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
336: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
337: CSM_UTIL_PKG.LOG
338: ( 'Record not processed successfully, deferring and rejecting record'
339: || ' for PK ' || r_notes.jtf_note_id,
340: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
341: FND_LOG.LEVEL_EVENT); -- put PK column here

Line 343: CSM_UTIL_PKG.DEFER_RECORD

339: || ' for PK ' || r_notes.jtf_note_id,
340: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
341: FND_LOG.LEVEL_EVENT); -- put PK column here
342:
343: CSM_UTIL_PKG.DEFER_RECORD
344: (
345: p_user_name
346: , p_tranid
347: , r_notes.seqno$$

Line 359: CSM_UTIL_PKG.LOG

355:
356: /*** Was defer successful? ***/
357: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
358: /*** no -> rollback ***/
359: CSM_UTIL_PKG.LOG
360: ( 'Defer record failed, rolling back to savepoint'
361: || ' for PK ' || r_notes.jtf_note_id,
362: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
363: FND_LOG.LEVEL_EVENT ); -- put PK column here

Line 373: CSM_UTIL_PKG.LOG

369: END LOOP;
370:
371: EXCEPTION WHEN OTHERS THEN
372: /*** catch and log exceptions ***/
373: CSM_UTIL_PKG.LOG
374: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ,
375: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
376: FND_LOG.LEVEL_ERROR
377: );