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.AP_NOTES_PUB dependencies on FND_LOG

Line 107: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

103:
104: l_note_id NUMBER;
105:
106: BEGIN
107: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
108: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);
109: end if;
110:
111: -- Standard Start of API savepoint

Line 108: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);

104: l_note_id NUMBER;
105:
106: BEGIN
107: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
108: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);
109: end if;
110:
111: -- Standard Start of API savepoint
112: SAVEPOINT Create_Note_PUB;

Line 131: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129:
130: -- Start of API body
131: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
132: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
133: end if;
134:
135: select ap_notes_s.nextval into l_note_id from dual;

Line 132: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');

128:
129:
130: -- Start of API body
131: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
132: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
133: end if;
134:
135: select ap_notes_s.nextval into l_note_id from dual;
136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

132: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
133: end if;
134:
135: select ap_notes_s.nextval into l_note_id from dual;
136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
137: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'l_note_id='||l_note_id);
138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
139: end if;
140: insert into AP_NOTES (

Line 137: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'l_note_id='||l_note_id);

133: end if;
134:
135: select ap_notes_s.nextval into l_note_id from dual;
136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
137: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'l_note_id='||l_note_id);
138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
139: end if;
140: insert into AP_NOTES (
141: NOTE_ID,

Line 138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');

134:
135: select ap_notes_s.nextval into l_note_id from dual;
136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
137: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'l_note_id='||l_note_id);
138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
139: end if;
140: insert into AP_NOTES (
141: NOTE_ID,
142: SOURCE_OBJECT_CODE,

Line 170: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

166: nvl(p_entered_by,-1),--Bug#6768560
167: nvl(p_last_update_login,-1)
168: );
169:
170: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
171: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_notes_detail='||p_notes_detail);
172: end if;
173: IF p_notes_detail is not null THEN
174: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 171: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_notes_detail='||p_notes_detail);

167: nvl(p_last_update_login,-1)
168: );
169:
170: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
171: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_notes_detail='||p_notes_detail);
172: end if;
173: IF p_notes_detail is not null THEN
174: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
175: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling writedatatolob()');

Line 174: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

170: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
171: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_notes_detail='||p_notes_detail);
172: end if;
173: IF p_notes_detail is not null THEN
174: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
175: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling writedatatolob()');
176: end if;
177: writeDatatoLob(l_note_id,p_notes_detail);
178: END IF;

Line 175: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling writedatatolob()');

171: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_notes_detail='||p_notes_detail);
172: end if;
173: IF p_notes_detail is not null THEN
174: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
175: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling writedatatolob()');
176: end if;
177: writeDatatoLob(l_note_id,p_notes_detail);
178: END IF;
179:

Line 180: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

176: end if;
177: writeDatatoLob(l_note_id,p_notes_detail);
178: END IF;
179:
180: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'End of API body');
182: end if;
183: -- End of API body.
184:

Line 181: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'End of API body');

177: writeDatatoLob(l_note_id,p_notes_detail);
178: END IF;
179:
180: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'End of API body');
182: end if;
183: -- End of API body.
184:
185:

Line 195: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

191: -- Standard call to get message count and if count is 1, get message info.
192: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
193: p_data => x_msg_data);
194:
195: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
196: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);
197: end if;
198: EXCEPTION
199:

Line 196: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);

192: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
193: p_data => x_msg_data);
194:
195: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
196: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);
197: end if;
198: EXCEPTION
199:
200: WHEN FND_API.G_EXC_ERROR THEN

Line 201: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

197: end if;
198: EXCEPTION
199:
200: WHEN FND_API.G_EXC_ERROR THEN
201: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
202: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
203: end if;
204: ROLLBACK TO Create_Note_PUB;
205: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 202: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');

198: EXCEPTION
199:
200: WHEN FND_API.G_EXC_ERROR THEN
201: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
202: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
203: end if;
204: ROLLBACK TO Create_Note_PUB;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 210: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
207: p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
211: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
212: end if;
213: ROLLBACK TO Create_Note_PUB;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 211: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');

207: p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
211: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
212: end if;
213: ROLLBACK TO Create_Note_PUB;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 219: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
220: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
221: end if;
222: ROLLBACK TO Create_Note_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 220: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);

216: p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
220: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
221: end if;
222: ROLLBACK TO Create_Note_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 286: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

282: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Notes';
283: l_api_version CONSTANT NUMBER := 1.0;
284:
285: BEGIN
286: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
287: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);
288: end if;
289:
290:

Line 287: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);

283: l_api_version CONSTANT NUMBER := 1.0;
284:
285: BEGIN
286: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
287: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);
288: end if;
289:
290:
291: -- Standard Start of API savepoint

Line 311: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308:
309:
310: -- Start of API body
311: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
312: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
313: end if;
314:
315:

Line 312: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');

308:
309:
310: -- Start of API body
311: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
312: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
313: end if;
314:
315:
316: IF p_note_type is null THEN

Line 317: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

313: end if;
314:
315:
316: IF p_note_type is null THEN
317: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
318: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type is null');
319: end if;
320: delete from AP_NOTES
321: where SOURCE_OBJECT_CODE = p_source_object_code

Line 318: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type is null');

314:
315:
316: IF p_note_type is null THEN
317: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
318: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type is null');
319: end if;
320: delete from AP_NOTES
321: where SOURCE_OBJECT_CODE = p_source_object_code
322: and SOURCE_OBJECT_ID = p_source_object_id

Line 325: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

321: where SOURCE_OBJECT_CODE = p_source_object_code
322: and SOURCE_OBJECT_ID = p_source_object_id
323: and NOTE_TYPE is null;
324: ELSIF p_note_type = G_ALL_NOTE_TYPES THEN
325: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
326: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting all notes');
327: end if;
328: delete from AP_NOTES
329: where SOURCE_OBJECT_CODE = p_source_object_code

Line 326: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting all notes');

322: and SOURCE_OBJECT_ID = p_source_object_id
323: and NOTE_TYPE is null;
324: ELSIF p_note_type = G_ALL_NOTE_TYPES THEN
325: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
326: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting all notes');
327: end if;
328: delete from AP_NOTES
329: where SOURCE_OBJECT_CODE = p_source_object_code
330: and SOURCE_OBJECT_ID = p_source_object_id;

Line 332: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

328: delete from AP_NOTES
329: where SOURCE_OBJECT_CODE = p_source_object_code
330: and SOURCE_OBJECT_ID = p_source_object_id;
331: ELSE
332: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
333: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting specific notes');
334: end if;
335: delete from AP_NOTES
336: where SOURCE_OBJECT_CODE = p_source_object_code

Line 333: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting specific notes');

329: where SOURCE_OBJECT_CODE = p_source_object_code
330: and SOURCE_OBJECT_ID = p_source_object_id;
331: ELSE
332: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
333: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting specific notes');
334: end if;
335: delete from AP_NOTES
336: where SOURCE_OBJECT_CODE = p_source_object_code
337: and SOURCE_OBJECT_ID = p_source_object_id

Line 341: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

337: and SOURCE_OBJECT_ID = p_source_object_id
338: and NOTE_TYPE = p_note_type;
339: END IF;
340:
341: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
342: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'End of API body');
343: end if;
344: -- End of API body.
345:

Line 342: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'End of API body');

338: and NOTE_TYPE = p_note_type;
339: END IF;
340:
341: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
342: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'End of API body');
343: end if;
344: -- End of API body.
345:
346:

Line 356: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

352: -- Standard call to get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
354: p_data => x_msg_data);
355:
356: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
357: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);
358: end if;
359: EXCEPTION
360:

Line 357: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);

353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
354: p_data => x_msg_data);
355:
356: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
357: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);
358: end if;
359: EXCEPTION
360:
361: WHEN FND_API.G_EXC_ERROR THEN

Line 362: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

358: end if;
359: EXCEPTION
360:
361: WHEN FND_API.G_EXC_ERROR THEN
362: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
363: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
364: end if;
365: ROLLBACK TO Delete_Notes;
366: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 363: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');

359: EXCEPTION
360:
361: WHEN FND_API.G_EXC_ERROR THEN
362: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
363: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
364: end if;
365: ROLLBACK TO Delete_Notes;
366: x_return_status := FND_API.G_RET_STS_ERROR ;
367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 371: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
368: p_data => x_msg_data);
369:
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
372: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
373: end if;
374: ROLLBACK TO Delete_Notes;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 372: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');

368: p_data => x_msg_data);
369:
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
372: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
373: end if;
374: ROLLBACK TO Delete_Notes;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 380: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
377: p_data => x_msg_data);
378:
379: WHEN OTHERS THEN
380: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
381: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
382: end if;
383: ROLLBACK TO Delete_Notes;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 381: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);

377: p_data => x_msg_data);
378:
379: WHEN OTHERS THEN
380: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
381: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
382: end if;
383: ROLLBACK TO Delete_Notes;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 451: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

447: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Notes';
448: l_api_version CONSTANT NUMBER := 1.0;
449:
450: BEGIN
451: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
452: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);
453: end if;
454:
455:

Line 452: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);

448: l_api_version CONSTANT NUMBER := 1.0;
449:
450: BEGIN
451: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
452: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_ENTER);
453: end if;
454:
455:
456: -- Standard Start of API savepoint

Line 476: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474:
475: -- Start of API body
476: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
477: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
478: end if;
479:
480: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 477: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');

473:
474:
475: -- Start of API body
476: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
477: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
478: end if;
479:
480: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
481: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,

Line 480: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

476: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
477: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
478: end if;
479:
480: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
481: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,
482: ' p_old_source_object_code='||p_old_source_object_code||
483: ':p_old_source_object_id='||p_old_source_object_id||
484: ':p_new_source_object_code='||p_new_source_object_code||

Line 481: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,

477: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
478: end if;
479:
480: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
481: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,
482: ' p_old_source_object_code='||p_old_source_object_code||
483: ':p_old_source_object_id='||p_old_source_object_id||
484: ':p_new_source_object_code='||p_new_source_object_code||
485: ':p_new_source_object_id='||p_new_source_object_id);

Line 492: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

488: --verify old and new source objects are not same
489: IF p_old_source_object_code = p_new_source_object_code AND
490: p_old_source_object_id = p_new_source_object_id
491: THEN
492: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
493: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'old and new source objects are same!');
494: end if;
495: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_COPY_ON_ITSELF_ERR');
496: FND_MSG_PUB.Add;

Line 493: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'old and new source objects are same!');

489: IF p_old_source_object_code = p_new_source_object_code AND
490: p_old_source_object_id = p_new_source_object_id
491: THEN
492: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
493: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'old and new source objects are same!');
494: end if;
495: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_COPY_ON_ITSELF_ERR');
496: FND_MSG_PUB.Add;
497: RAISE FND_API.G_EXC_ERROR;

Line 500: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

496: FND_MSG_PUB.Add;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
501: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
502: end if;
503: insert into AP_NOTES (
504: NOTE_ID,

Line 501: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');

497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
501: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
502: end if;
503: insert into AP_NOTES (
504: NOTE_ID,
505: SOURCE_OBJECT_CODE,

Line 536: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

532: from AP_NOTES
533: where source_object_code = p_old_source_object_code
534: and source_object_id = p_old_source_object_id;
535:
536: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
537: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
538: end if;
539: -- End of API body.
540:

Line 537: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');

533: where source_object_code = p_old_source_object_code
534: and source_object_id = p_old_source_object_id;
535:
536: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
537: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
538: end if;
539: -- End of API body.
540:
541:

Line 551: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

547: -- Standard call to get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
549: p_data => x_msg_data);
550:
551: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
552: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);
553: end if;
554: EXCEPTION
555:

Line 552: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);

548: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
549: p_data => x_msg_data);
550:
551: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
552: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);
553: end if;
554: EXCEPTION
555:
556: WHEN FND_API.G_EXC_ERROR THEN

Line 557: if ( FND_LOG.LEVEL_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

553: end if;
554: EXCEPTION
555:
556: WHEN FND_API.G_EXC_ERROR THEN
557: if ( FND_LOG.LEVEL_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
558: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
559: end if;
560: ROLLBACK TO Copy_Notes;
561: x_return_status := FND_API.G_RET_STS_ERROR;

Line 558: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');

554: EXCEPTION
555:
556: WHEN FND_API.G_EXC_ERROR THEN
557: if ( FND_LOG.LEVEL_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
558: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
559: end if;
560: ROLLBACK TO Copy_Notes;
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 566: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
563: p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
567: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
568: end if;
569: ROLLBACK TO Copy_Notes;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 567: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');

563: p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
567: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
568: end if;
569: ROLLBACK TO Copy_Notes;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 575: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: WHEN OTHERS THEN
575: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
576: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
577: end if;
578: ROLLBACK TO Copy_Notes;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 576: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);

572: p_data => x_msg_data);
573:
574: WHEN OTHERS THEN
575: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
576: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
577: end if;
578: ROLLBACK TO Copy_Notes;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN