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

Line 95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

91: l_api_name CONSTANT VARCHAR2(30) := 'g_validate_row';
92:
93: BEGIN
94:
95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered validate_row');
97: END IF;
98:
99: -- Standard Start of API savepoint

Line 96: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered validate_row');

92:
93: BEGIN
94:
95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered validate_row');
97: END IF;
98:
99: -- Standard Start of API savepoint
100: SAVEPOINT g_validate_row_GRP;

Line 173: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

169:
170: -- Standard call to get message count and if count is 1, get message info.
171: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
172:
173: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving validate_row');
175: END IF;
176:
177: EXCEPTION

Line 174: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving validate_row');

170: -- Standard call to get message count and if count is 1, get message info.
171: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
172:
173: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving validate_row');
175: END IF;
176:
177: EXCEPTION
178: WHEN FND_API.G_EXC_ERROR THEN

Line 179: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

175: END IF;
176:
177: EXCEPTION
178: WHEN FND_API.G_EXC_ERROR THEN
179: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
180: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception');
181: END IF;
182: ROLLBACK TO g_validate_row_GRP;
183: x_return_status := G_RET_STS_ERROR ;

Line 180: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception');

176:
177: EXCEPTION
178: WHEN FND_API.G_EXC_ERROR THEN
179: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
180: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception');
181: END IF;
182: ROLLBACK TO g_validate_row_GRP;
183: x_return_status := G_RET_STS_ERROR ;
184: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 187: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

183: x_return_status := G_RET_STS_ERROR ;
184: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
188: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
189: END IF;
190: ROLLBACK TO g_validate_row_GRP;
191: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 188: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

184: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
188: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
189: END IF;
190: ROLLBACK TO g_validate_row_GRP;
191: x_return_status := G_RET_STS_UNEXP_ERROR ;
192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 195: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

191: x_return_status := G_RET_STS_UNEXP_ERROR ;
192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
193:
194: WHEN OTHERS THEN
195: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
197: END IF;
198:
199: ROLLBACK TO g_validate_row_GRP;

Line 196: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);

192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
193:
194: WHEN OTHERS THEN
195: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
197: END IF;
198:
199: ROLLBACK TO g_validate_row_GRP;
200: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

276: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
277:
278: BEGIN
279:
280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Entered create_template');
282: END IF;
283:
284: -- Standard Start of API savepoint

Line 281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Entered create_template');

277:
278: BEGIN
279:
280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Entered create_template');
282: END IF;
283:
284: -- Standard Start of API savepoint
285: SAVEPOINT g_insert_row_GRP;

Line 362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

358: END IF;
359: -- Standard call to get message count and if count is 1, get message info.
360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
361:
362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template');
364: END IF;
365:
366: EXCEPTION

Line 363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template');

359: -- Standard call to get message count and if count is 1, get message info.
360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
361:
362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template');
364: END IF;
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN

Line 368: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

364: END IF;
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving create_template: OKC_API.G_EXCEPTION_ERROR Exception');
370: END IF;
371: ROLLBACK TO g_insert_row_GRP;
372: x_return_status := G_RET_STS_ERROR ;

Line 369: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving create_template: OKC_API.G_EXCEPTION_ERROR Exception');

365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving create_template: OKC_API.G_EXCEPTION_ERROR Exception');
370: END IF;
371: ROLLBACK TO g_insert_row_GRP;
372: x_return_status := G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 376: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

372: x_return_status := G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
377: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving create_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
378: END IF;
379: ROLLBACK TO g_insert_row_GRP;
380: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 377: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving create_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
377: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving create_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
378: END IF;
379: ROLLBACK TO g_insert_row_GRP;
380: x_return_status := G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 384: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

380: x_return_status := G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN OTHERS THEN
384: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
385: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving create_template because of EXCEPTION: '||sqlerrm);
386: END IF;
387:
388: ROLLBACK TO g_insert_row_GRP;

Line 385: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving create_template because of EXCEPTION: '||sqlerrm);

381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN OTHERS THEN
384: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
385: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving create_template because of EXCEPTION: '||sqlerrm);
386: END IF;
387:
388: ROLLBACK TO g_insert_row_GRP;
389: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 414: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

410: l_api_version CONSTANT NUMBER := 1;
411: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
412: BEGIN
413:
414: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Entered lock_row');
416: END IF;
417:
418: -- Standard Start of API savepoint

Line 415: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Entered lock_row');

411: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
412: BEGIN
413:
414: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Entered lock_row');
416: END IF;
417:
418: -- Standard Start of API savepoint
419: SAVEPOINT g_lock_row_GRP;

Line 450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

446:
447: -- Standard call to get message count and if count is 1, get message info.
448: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
449:
450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');
452: END IF;
453:
454: EXCEPTION

Line 451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');

447: -- Standard call to get message count and if count is 1, get message info.
448: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
449:
450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');
452: END IF;
453:
454: EXCEPTION
455: WHEN FND_API.G_EXC_ERROR THEN

Line 456: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

452: END IF;
453:
454: EXCEPTION
455: WHEN FND_API.G_EXC_ERROR THEN
456: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
457: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');
458: END IF;
459: ROLLBACK TO g_lock_row_GRP;
460: x_return_status := G_RET_STS_ERROR ;

Line 457: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');

453:
454: EXCEPTION
455: WHEN FND_API.G_EXC_ERROR THEN
456: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
457: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');
458: END IF;
459: ROLLBACK TO g_lock_row_GRP;
460: x_return_status := G_RET_STS_ERROR ;
461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 464: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

460: x_return_status := G_RET_STS_ERROR ;
461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
466: END IF;
467: ROLLBACK TO g_lock_row_GRP;
468: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 465: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
466: END IF;
467: ROLLBACK TO g_lock_row_GRP;
468: x_return_status := G_RET_STS_UNEXP_ERROR ;
469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 472: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

468: x_return_status := G_RET_STS_UNEXP_ERROR ;
469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
470:
471: WHEN OTHERS THEN
472: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm);
474: END IF;
475:
476: ROLLBACK TO g_lock_row_GRP;

Line 473: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm);

469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
470:
471: WHEN OTHERS THEN
472: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm);
474: END IF;
475:
476: ROLLBACK TO g_lock_row_GRP;
477: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

547:
548:
549: BEGIN
550:
551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Entered update_template');
553: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1700: Locking row');
554: END IF;
555:

Line 552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Entered update_template');

548:
549: BEGIN
550:
551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Entered update_template');
553: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1700: Locking row');
554: END IF;
555:
556: -- Standard Start of API savepoint

Line 553: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1700: Locking row');

549: BEGIN
550:
551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Entered update_template');
553: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1700: Locking row');
554: END IF;
555:
556: -- Standard Start of API savepoint
557: SAVEPOINT g_update_row_GRP;

Line 635: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

631: END IF;
632: -- Standard call to get message count and if count is 1, get message info.
633: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
634:
635: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
636: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template');
637: END IF;
638:
639: EXCEPTION

Line 636: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template');

632: -- Standard call to get message count and if count is 1, get message info.
633: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
634:
635: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
636: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template');
637: END IF;
638:
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN

Line 641: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

637: END IF;
638:
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN
641: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template: OKC_API.G_EXCEPTION_ERROR Exception');
643: END IF;
644: ROLLBACK TO g_update_row_GRP;
645: x_return_status := G_RET_STS_ERROR ;

Line 642: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template: OKC_API.G_EXCEPTION_ERROR Exception');

638:
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN
641: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template: OKC_API.G_EXCEPTION_ERROR Exception');
643: END IF;
644: ROLLBACK TO g_update_row_GRP;
645: x_return_status := G_RET_STS_ERROR ;
646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 649: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

645: x_return_status := G_RET_STS_ERROR ;
646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
651: END IF;
652: ROLLBACK TO g_update_row_GRP;
653: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
651: END IF;
652: ROLLBACK TO g_update_row_GRP;
653: x_return_status := G_RET_STS_UNEXP_ERROR ;
654: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 657: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

653: x_return_status := G_RET_STS_UNEXP_ERROR ;
654: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
655:
656: WHEN OTHERS THEN
657: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2100: Leaving update_template because of EXCEPTION: '||sqlerrm);
659: END IF;
660:
661: ROLLBACK TO g_update_row_GRP;

Line 658: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2100: Leaving update_template because of EXCEPTION: '||sqlerrm);

654: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
655:
656: WHEN OTHERS THEN
657: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2100: Leaving update_template because of EXCEPTION: '||sqlerrm);
659: END IF;
660:
661: ROLLBACK TO g_update_row_GRP;
662: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 689: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

685: l_api_version CONSTANT NUMBER := 1;
686: l_api_name CONSTANT VARCHAR2(30) := 'g_delete_template';
687: BEGIN
688:
689: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered delete_template');
691: END IF;
692:
693: -- Standard Start of API savepoint

Line 690: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered delete_template');

686: l_api_name CONSTANT VARCHAR2(30) := 'g_delete_template';
687: BEGIN
688:
689: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered delete_template');
691: END IF;
692:
693: -- Standard Start of API savepoint
694: SAVEPOINT g_delete_row_GRP;

Line 729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

725: END IF;
726: -- Standard call to get message count and if count is 1, get message info.
727: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
728:
729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
730: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template');
731: END IF;
732:
733: EXCEPTION

Line 730: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template');

726: -- Standard call to get message count and if count is 1, get message info.
727: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
728:
729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
730: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template');
731: END IF;
732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN

Line 735: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

731: END IF;
732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
736: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template: OKC_API.G_EXCEPTION_ERROR Exception');
737: END IF;
738: ROLLBACK TO g_delete_row_GRP;
739: x_return_status := G_RET_STS_ERROR ;

Line 736: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template: OKC_API.G_EXCEPTION_ERROR Exception');

732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
736: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template: OKC_API.G_EXCEPTION_ERROR Exception');
737: END IF;
738: ROLLBACK TO g_delete_row_GRP;
739: x_return_status := G_RET_STS_ERROR ;
740: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 743: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

739: x_return_status := G_RET_STS_ERROR ;
740: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
744: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
745: END IF;
746: ROLLBACK TO g_delete_row_GRP;
747: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 744: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

740: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
744: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
745: END IF;
746: ROLLBACK TO g_delete_row_GRP;
747: x_return_status := G_RET_STS_UNEXP_ERROR ;
748: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 751: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

747: x_return_status := G_RET_STS_UNEXP_ERROR ;
748: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
749:
750: WHEN OTHERS THEN
751: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving delete_template because of EXCEPTION: '||sqlerrm);
753: END IF;
754:
755: ROLLBACK TO g_delete_row_GRP;

Line 752: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving delete_template because of EXCEPTION: '||sqlerrm);

748: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
749:
750: WHEN OTHERS THEN
751: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving delete_template because of EXCEPTION: '||sqlerrm);
753: END IF;
754:
755: ROLLBACK TO g_delete_row_GRP;
756: x_return_status := G_RET_STS_UNEXP_ERROR ;