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_API

Line 48: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE

44: --
45: -- PARAMETERS :
46: -- IN -
47: -- p_api_version NUMBER Required
48: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
49: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
50: -- p_source_object_code VARCHAR2 Required
51: -- p_source_object_id NUMBER Required
52: -- p_note_type VARCHAR2 Required

Line 49: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE

45: -- PARAMETERS :
46: -- IN -
47: -- p_api_version NUMBER Required
48: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
49: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
50: -- p_source_object_code VARCHAR2 Required
51: -- p_source_object_id NUMBER Required
52: -- p_note_type VARCHAR2 Required
53: -- p_notes_detail VARCHAR2 Required

Line 81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

77: -- End of comments
78: /*===========================================================================*/
79: procedure Create_Note (
80: p_api_version IN NUMBER ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
84: x_msg_count OUT NOCOPY NUMBER ,
85: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

78: /*===========================================================================*/
79: procedure Create_Note (
80: p_api_version IN NUMBER ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
84: x_msg_count OUT NOCOPY NUMBER ,
85: x_msg_data OUT NOCOPY VARCHAR2 ,
86: p_source_object_code IN VARCHAR2 ,

Line 115: IF NOT FND_API.

111: -- Standard Start of API savepoint
112: SAVEPOINT Create_Note_PUB;
113:
114: -- Standard call to check for call compatibility.
115: IF NOT FND_API.
116: Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
117: THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

114: -- Standard call to check for call compatibility.
115: IF NOT FND_API.
116: Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
117: THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE.
122: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 122: IF FND_API.to_Boolean( p_init_msg_list ) THEN

118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE.
122: IF FND_API.to_Boolean( p_init_msg_list ) THEN
123: FND_MSG_PUB.initialize;
124: END IF;
125:
126: -- Initialize API return status to success

Line 127: x_return_status := FND_API.G_RET_STS_SUCCESS;

123: FND_MSG_PUB.initialize;
124: END IF;
125:
126: -- Initialize API return status to success
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

Line 187: IF FND_API.To_Boolean(p_commit) THEN

183: -- End of API body.
184:
185:
186: -- Standard check of p_commit.
187: IF FND_API.To_Boolean(p_commit) THEN
188: COMMIT WORK;
189: END IF;
190:
191: -- Standard call to get message count and if count is 1, get message info.

Line 200: WHEN FND_API.G_EXC_ERROR 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
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;

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

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,
207: p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
216: p_data => x_msg_data);
217:
218: WHEN OTHERS THEN

Line 223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
225: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
226: END IF;
227: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 247: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE

243: --
244: -- PARAMETERS :
245: -- IN -
246: -- p_api_version NUMBER Required
247: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
248: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
249: -- p_source_object_code VARCHAR2 Required
250: -- p_source_object_id NUMBER Required
251: -- p_note_type VARCHAR2 Optional default = G_ALL_NOTE_TYPES

Line 248: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE

244: -- PARAMETERS :
245: -- IN -
246: -- p_api_version NUMBER Required
247: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
248: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
249: -- p_source_object_code VARCHAR2 Required
250: -- p_source_object_id NUMBER Required
251: -- p_note_type VARCHAR2 Optional default = G_ALL_NOTE_TYPES
252: -- OUT -

Line 271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

267: -- End of comments
268: /*===========================================================================*/
269: procedure Delete_Notes (
270: p_api_version IN NUMBER ,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
273: x_return_status OUT NOCOPY VARCHAR2 ,
274: x_msg_count OUT NOCOPY NUMBER ,
275: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 272: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

268: /*===========================================================================*/
269: procedure Delete_Notes (
270: p_api_version IN NUMBER ,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
273: x_return_status OUT NOCOPY VARCHAR2 ,
274: x_msg_count OUT NOCOPY NUMBER ,
275: x_msg_data OUT NOCOPY VARCHAR2 ,
276: p_source_object_code IN VARCHAR2 ,

Line 295: IF NOT FND_API.

291: -- Standard Start of API savepoint
292: SAVEPOINT Delete_Notes;
293:
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.
296: Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
297: THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;

Line 298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.
296: Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
297: THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 302: IF FND_API.to_Boolean( p_init_msg_list ) THEN

298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302: IF FND_API.to_Boolean( p_init_msg_list ) THEN
303: FND_MSG_PUB.initialize;
304: END IF;
305:
306: -- Initialize API return status to success

Line 307: x_return_status := FND_API.G_RET_STS_SUCCESS;

303: FND_MSG_PUB.initialize;
304: END IF;
305:
306: -- Initialize API return status to success
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

Line 348: IF FND_API.To_Boolean(p_commit) THEN

344: -- End of API body.
345:
346:
347: -- Standard check of p_commit.
348: IF FND_API.To_Boolean(p_commit) THEN
349: COMMIT WORK;
350: END IF;
351:
352: -- Standard call to get message count and if count is 1, get message info.

Line 361: WHEN FND_API.G_EXC_ERROR 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
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;

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 366: x_return_status := FND_API.G_RET_STS_ERROR ;

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,
368: p_data => x_msg_data);
369:
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

366: x_return_status := FND_API.G_RET_STS_ERROR ;
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;

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 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
377: p_data => x_msg_data);
378:
379: WHEN OTHERS THEN

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
387: END IF;
388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 408: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE

404: --
405: -- PARAMETERS :
406: -- IN -
407: -- p_api_version NUMBER Required
408: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
409: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
410: -- p_old_source_object_code VARCHAR2 Required
411: -- p_old_source_object_id NUMBER Required
412: -- p_new_source_object_code VARCHAR2 Required

Line 409: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE

405: -- PARAMETERS :
406: -- IN -
407: -- p_api_version NUMBER Required
408: -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
409: -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
410: -- p_old_source_object_code VARCHAR2 Required
411: -- p_old_source_object_id NUMBER Required
412: -- p_new_source_object_code VARCHAR2 Required
413: -- p_new_source_object_id NUMBER Required

Line 435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

431: -- End of comments
432: /*===========================================================================*/
433: procedure Copy_Notes (
434: p_api_version IN NUMBER ,
435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
436: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
437: x_return_status OUT NOCOPY VARCHAR2 ,
438: x_msg_count OUT NOCOPY NUMBER ,
439: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 436: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

432: /*===========================================================================*/
433: procedure Copy_Notes (
434: p_api_version IN NUMBER ,
435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
436: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
437: x_return_status OUT NOCOPY VARCHAR2 ,
438: x_msg_count OUT NOCOPY NUMBER ,
439: x_msg_data OUT NOCOPY VARCHAR2 ,
440: p_old_source_object_code IN VARCHAR2 ,

Line 460: IF NOT FND_API.

456: -- Standard Start of API savepoint
457: SAVEPOINT Copy_Notes;
458:
459: -- Standard call to check for call compatibility.
460: IF NOT FND_API.
461: Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
462: THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: -- Standard call to check for call compatibility.
460: IF NOT FND_API.
461: Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
462: THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 467: IF FND_API.to_Boolean( p_init_msg_list ) THEN

463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list ) THEN
468: FND_MSG_PUB.initialize;
469: END IF;
470:
471: -- Initialize API return status to success

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: FND_MSG_PUB.initialize;
469: END IF;
470:
471: -- Initialize API return status to success
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

Line 497: RAISE FND_API.G_EXC_ERROR;

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

Line 543: IF FND_API.To_Boolean(p_commit) THEN

539: -- End of API body.
540:
541:
542: -- Standard check of p_commit.
543: IF FND_API.To_Boolean(p_commit) THEN
544: COMMIT WORK;
545: END IF;
546:
547: -- Standard call to get message count and if count is 1, get message info.

Line 556: WHEN FND_API.G_EXC_ERROR 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
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;

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 561: x_return_status := FND_API.G_RET_STS_ERROR;

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,
563: p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

561: x_return_status := FND_API.G_RET_STS_ERROR;
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;

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 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
572: p_data => x_msg_data);
573:
574: WHEN OTHERS THEN

Line 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
582: END IF;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,