103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
107: FND_MSG_PUB.initialize;
108: END IF;
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
167: END IF;
168: --------------------------------------------
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;
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 );
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');
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 );
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 ;
201: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
203: END IF;
204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
205:
198:
199: ROLLBACK TO g_validate_row_GRP;
200: x_return_status := G_RET_STS_UNEXP_ERROR ;
201: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
203: END IF;
204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
205:
206: END validate_row;
200: x_return_status := G_RET_STS_UNEXP_ERROR ;
201: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
203: END IF;
204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
205:
206: END validate_row;
207:
208: -------------------------------------
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: -- Initialize message list if p_init_msg_list is set to TRUE.
292: IF FND_API.to_Boolean( p_init_msg_list ) THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295: -- Initialize API return status to success
296: x_return_status := FND_API.G_RET_STS_SUCCESS;
297:
358: IF FND_API.To_Boolean( p_commit ) THEN
359: COMMIT WORK;
360: END IF;
361: -- Standard call to get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
363:
364: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
365: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template');
366: END IF;
371: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving create_template: OKC_API.G_EXCEPTION_ERROR Exception');
372: END IF;
373: ROLLBACK TO g_insert_row_GRP;
374: x_return_status := G_RET_STS_ERROR ;
375: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
379: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving create_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
379: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving create_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
380: END IF;
381: ROLLBACK TO g_insert_row_GRP;
382: x_return_status := G_RET_STS_UNEXP_ERROR ;
383: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
384:
385: WHEN OTHERS THEN
386: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
387: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving create_template because of EXCEPTION: '||sqlerrm);
388: END IF;
389:
390: ROLLBACK TO g_insert_row_GRP;
391: x_return_status := G_RET_STS_UNEXP_ERROR ;
392: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
394: END IF;
395: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
396:
389:
390: ROLLBACK TO g_insert_row_GRP;
391: x_return_status := G_RET_STS_UNEXP_ERROR ;
392: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
394: END IF;
395: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
396:
397: END create_template;
391: x_return_status := G_RET_STS_UNEXP_ERROR ;
392: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
394: END IF;
395: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
396:
397: END create_template;
398: ---------------------------------------------------------------------------
399: -- PROCEDURE lock_row
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427: IF FND_API.to_Boolean( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430: -- Initialize API return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
446: END IF;
447: --------------------------------------------
448:
449: -- Standard call to get message count and if count is 1, get message info.
450: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
451:
452: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
453: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');
454: END IF;
459: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');
460: END IF;
461: ROLLBACK TO g_lock_row_GRP;
462: x_return_status := G_RET_STS_ERROR ;
463: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
467: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
468: END IF;
469: ROLLBACK TO g_lock_row_GRP;
470: x_return_status := G_RET_STS_UNEXP_ERROR ;
471: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
472:
473: WHEN OTHERS THEN
474: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
475: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm);
476: END IF;
477:
478: ROLLBACK TO g_lock_row_GRP;
479: x_return_status := G_RET_STS_UNEXP_ERROR ;
480: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
482: END IF;
483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
484:
477:
478: ROLLBACK TO g_lock_row_GRP;
479: x_return_status := G_RET_STS_UNEXP_ERROR ;
480: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
482: END IF;
483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
484:
485: END lock_row;
479: x_return_status := G_RET_STS_UNEXP_ERROR ;
480: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
482: END IF;
483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
484:
485: END lock_row;
486: ---------------------------------------------------------------------------
487: -- PROCEDURE update_template
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566: IF FND_API.to_Boolean( p_init_msg_list ) THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569: -- Initialize API return status to success
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571:
633: IF FND_API.To_Boolean( p_commit ) THEN
634: COMMIT WORK;
635: END IF;
636: -- Standard call to get message count and if count is 1, get message info.
637: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
638:
639: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
640: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template');
641: END IF;
646: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template: OKC_API.G_EXCEPTION_ERROR Exception');
647: END IF;
648: ROLLBACK TO g_update_row_GRP;
649: x_return_status := G_RET_STS_ERROR ;
650: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
651:
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
654: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
655: END IF;
656: ROLLBACK TO g_update_row_GRP;
657: x_return_status := G_RET_STS_UNEXP_ERROR ;
658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
659:
660: WHEN OTHERS THEN
661: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2100: Leaving update_template because of EXCEPTION: '||sqlerrm);
663: END IF;
664:
665: ROLLBACK TO g_update_row_GRP;
666: x_return_status := G_RET_STS_UNEXP_ERROR ;
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
669: END IF;
670: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
671:
664:
665: ROLLBACK TO g_update_row_GRP;
666: x_return_status := G_RET_STS_UNEXP_ERROR ;
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
669: END IF;
670: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
671:
672: END update_template;
666: x_return_status := G_RET_STS_UNEXP_ERROR ;
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
669: END IF;
670: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
671:
672: END update_template;
673:
674: ---------------------------------------------------------------------------
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707: -- Initialize API return status to success
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709:
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730: -- Standard call to get message count and if count is 1, get message info.
731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
732:
733: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template');
735: END IF;
740: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template: OKC_API.G_EXCEPTION_ERROR Exception');
741: END IF;
742: ROLLBACK TO g_delete_row_GRP;
743: x_return_status := G_RET_STS_ERROR ;
744: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
745:
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
748: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
748: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
749: END IF;
750: ROLLBACK TO g_delete_row_GRP;
751: x_return_status := G_RET_STS_UNEXP_ERROR ;
752: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
753:
754: WHEN OTHERS THEN
755: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
756: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving delete_template because of EXCEPTION: '||sqlerrm);
757: END IF;
758:
759: ROLLBACK TO g_delete_row_GRP;
760: x_return_status := G_RET_STS_UNEXP_ERROR ;
761: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
762: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
763: END IF;
764: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
765:
758:
759: ROLLBACK TO g_delete_row_GRP;
760: x_return_status := G_RET_STS_UNEXP_ERROR ;
761: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
762: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
763: END IF;
764: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
765:
766: END delete_template;
760: x_return_status := G_RET_STS_UNEXP_ERROR ;
761: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
762: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
763: END IF;
764: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
765:
766: END delete_template;
767:
768: END OKC_TERMS_TEMPLATES_GRP;