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

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

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

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

Line 92: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

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

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

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

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

Line 175: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

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

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

Line 195: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

Line 240: CSM_UTIL_PKG.LOG

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

Line 246: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 258: CSM_UTIL_PKG.LOG

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

Line 265: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

Line 312: CSM_UTIL_PKG.DELETE_RECORD

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

Line 327: CSM_UTIL_PKG.LOG

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

Line 339: CSM_UTIL_PKG.LOG

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

Line 345: CSM_UTIL_PKG.DEFER_RECORD

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

Line 361: CSM_UTIL_PKG.LOG

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

Line 375: CSM_UTIL_PKG.LOG

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