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.12020000.2 2013/04/09 11:04:25 saradhak 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 82: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

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

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

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

Line 125: 'CSM_NOTES_PKG.APPLY_UPDATE',

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

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

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

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

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

Line 190: 'CSM_NOTES_PKG.APPLY_UPDATE',

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

Line 202: 'CSM_NOTES_PKG.APPLY_UPDATE',

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

Line 243: 'CSM_NOTES_PKG.APPLY_RECORD',

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

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

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

Line 261: 'CSM_NOTES_PKG.APPLY_RECORD',

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

Line 330: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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

Line 342: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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
344:
345: CSM_UTIL_PKG.DEFER_RECORD
346: (

Line 364: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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

Line 377: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',

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

Line 383: END CSM_NOTES_PKG;

379: );
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: END APPLY_CLIENT_CHANGES;
382:
383: END CSM_NOTES_PKG;
384: