DBA Data[Home] [Help]

APPS.CSM_NOTES_PKG dependencies on FND_LOG

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 126: FND_LOG.LEVEL_PROCEDURE );

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
130: --from jtf_notes_b

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 191: FND_LOG.LEVEL_PROCEDURE );

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);
195: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 203: FND_LOG.LEVEL_ERROR );

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

Line 244: FND_LOG.LEVEL_EVENT );

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: (
248: p_message => 'CSM_DML_OPERATION'

Line 262: FND_LOG.LEVEL_ERROR );

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
266: (

Line 331: FND_LOG.LEVEL_EVENT ); -- put PK column here

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;
335: END IF;

Line 343: FND_LOG.LEVEL_EVENT); -- put PK column here

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: (
347: p_user_name

Line 365: FND_LOG.LEVEL_EVENT ); -- put PK column here

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;
369: END IF;

Line 378: FND_LOG.LEVEL_ERROR

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