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_NOTES_PKG

Line 1: PACKAGE BODY CSM_NOTES_PKG AS

1: PACKAGE BODY CSM_NOTES_PKG AS
2: /* $Header: csmunotb.pls 120.4 2008/03/24 09:00:13 ptomar ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

Line 12: g_object_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_PKG'; -- package name

8: -- Enter procedure, function bodies as shown below
9:
10:
11: /*** Globals ***/
12: g_object_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_PKG'; -- package name
13: g_pub_name CONSTANT VARCHAR2(30) := 'CSF_M_NOTES'; -- publication item name
14: g_debug_level NUMBER; -- debug level
15:
16: CURSOR c_notes( b_user_name VARCHAR2, b_tranid NUMBER) is

Line 42: 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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
45: CSM_UTIL_PKG.log( 'Creating Note ' || g_object_name || '.APPLY_INSERT:'
46: || ' for PK ' || p_record.jtf_note_id ,

Line 47: 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);

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
50: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
51: , p_init_msg_list => FND_API.G_TRUE

Line 81: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

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;
84: else
85: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 96: || ' for PK ' || p_record.jtf_note_id , 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;
100:

Line 124: 'CSM_NOTES_PKG.APPLY_UPDATE',

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
127:
128: --select last_update_date into l_server_last_update_date

Line 142: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_NOTES_PKG.APPLY_UPDATE: P_KEY = '

138: if(fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE)
139: = csm_profile_pkg.g_SERVER_WINS) then
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;

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 179: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

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;
182: else
183: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 188: 'CSM_NOTES_PKG.APPLY_UPDATE',

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
191: when others then
192: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);

Line 200: 'CSM_NOTES_PKG.APPLY_UPDATE',

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:
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END APPLY_UPDATE;

Line 241: 'CSM_NOTES_PKG.APPLY_RECORD',

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 );
243:
244: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
245: (

Line 257: ( 'Exception occurred in CSM_notes_PKG.APPLY_RECORD:' || ' ' || sqlerrm

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 );
261:

Line 259: 'CSM_NOTES_PKG.APPLY_RECORD',

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 );
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

Line 328: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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
330: ROLLBACK TO save_rec;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: END IF;

Line 340: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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
342:
343: CSM_UTIL_PKG.DEFER_RECORD
344: (

Line 362: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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
364: ROLLBACK TO save_rec;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: END IF;

Line 375: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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: );
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END APPLY_CLIENT_CHANGES;

Line 381: END CSM_NOTES_PKG;

377: );
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END APPLY_CLIENT_CHANGES;
380:
381: END CSM_NOTES_PKG;