80: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered validate_row');
82: END IF;
83:
84: -- Standard Start of API savepoint
85: SAVEPOINT g_validate_row_GRP;
86: -- Standard call to check for call compatibility.
87: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84: -- Standard Start of API savepoint
85: SAVEPOINT g_validate_row_GRP;
86: -- Standard call to check for call compatibility.
87: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
142: RAISE FND_API.G_EXC_ERROR ;
143: END IF;
144: --------------------------------------------
145:
146: -- Standard call to get message count and if count is 1, get message info.
147: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
148:
149: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving validate_row');
238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Entered create_template_usages');
240: END IF;
241:
242: -- Standard Start of API savepoint
243: SAVEPOINT g_insert_row_GRP;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242: -- Standard Start of API savepoint
243: SAVEPOINT g_insert_row_GRP;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248: -- Initialize message list if p_init_msg_list is set to TRUE.
303: RAISE FND_API.G_EXC_ERROR ;
304: END IF;
305: --------------------------------------------
306:
307: -- Standard check of p_commit
308: IF FND_API.To_Boolean( p_commit ) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
307: -- Standard check of p_commit
308: IF FND_API.To_Boolean( p_commit ) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
313:
314: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template_usages');
367: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Entered lock_row');
369: END IF;
370:
371: -- Standard Start of API savepoint
372: SAVEPOINT g_lock_row_GRP;
373: -- Standard call to check for call compatibility.
374: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370:
371: -- Standard Start of API savepoint
372: SAVEPOINT g_lock_row_GRP;
373: -- Standard call to check for call compatibility.
374: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377: -- Initialize message list if p_init_msg_list is set to TRUE.
397: RAISE FND_API.G_EXC_ERROR ;
398: END IF;
399: --------------------------------------------
400:
401: -- Standard call to get message count and if count is 1, get message info.
402: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
403:
404: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');
486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Entered update_template_usages');
487: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1700: Locking row');
488: END IF;
489:
490: -- Standard Start of API savepoint
491: SAVEPOINT g_update_row_GRP;
492: -- Standard call to check for call compatibility.
493: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489:
490: -- Standard Start of API savepoint
491: SAVEPOINT g_update_row_GRP;
492: -- Standard call to check for call compatibility.
493: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496: -- Initialize message list if p_init_msg_list is set to TRUE.
537: RAISE FND_API.G_EXC_ERROR ;
538: END IF;
539: --------------------------------------------
540:
541: -- Standard check of p_commit
542: IF FND_API.To_Boolean( p_commit ) THEN
543: COMMIT WORK;
544: END IF;
545: -- Standard call to get message count and if count is 1, get message info.
541: -- Standard check of p_commit
542: IF FND_API.To_Boolean( p_commit ) THEN
543: COMMIT WORK;
544: END IF;
545: -- Standard call to get message count and if count is 1, get message info.
546: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
547:
548: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template_usages');
603: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
604: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered delete_template_usages');
605: END IF;
606:
607: -- Standard Start of API savepoint
608: SAVEPOINT g_delete_row_GRP;
609: -- Standard call to check for call compatibility.
610: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END IF;
606:
607: -- Standard Start of API savepoint
608: SAVEPOINT g_delete_row_GRP;
609: -- Standard call to check for call compatibility.
610: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613: -- Initialize message list if p_init_msg_list is set to TRUE.
633: RAISE FND_API.G_EXC_ERROR ;
634: END IF;
635: --------------------------------------------
636:
637: -- Standard check of p_commit
638: IF FND_API.To_Boolean( p_commit ) THEN
639: COMMIT WORK;
640: END IF;
641: -- Standard call to get message count and if count is 1, get message info.
637: -- Standard check of p_commit
638: IF FND_API.To_Boolean( p_commit ) THEN
639: COMMIT WORK;
640: END IF;
641: -- Standard call to get message count and if count is 1, get message info.
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
643:
644: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template_usages');
719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered Set_Contract_Source');
721: END IF;
722:
723: -- Standard Start of API savepoint
724: SAVEPOINT g_set_contract_source_GRP;
725:
726: -- Standard call to check for call compatibility.
727: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
722:
723: -- Standard Start of API savepoint
724: SAVEPOINT g_set_contract_source_GRP;
725:
726: -- Standard call to check for call compatibility.
727: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
729: END IF;
730:
821: RAISE FND_API.G_EXC_ERROR ;
822: END IF;
823: --------------------------------------------
824:
825: -- Standard check of p_commit
826: IF FND_API.To_Boolean( p_commit ) THEN
827: COMMIT WORK;
828: END IF;
829: -- Standard call to get message count and if count is 1, get message info.
825: -- Standard check of p_commit
826: IF FND_API.To_Boolean( p_commit ) THEN
827: COMMIT WORK;
828: END IF;
829: -- Standard call to get message count and if count is 1, get message info.
830: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
831:
832: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving Set_Contract_Source');
913: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered Set_Contract_Source');
915: END IF;
916:
917: -- Standard Start of API savepoint
918: SAVEPOINT g_set_contract_src_dtls_GRP;
919:
920: -- Standard call to check for call compatibility.
921: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
916:
917: -- Standard Start of API savepoint
918: SAVEPOINT g_set_contract_src_dtls_GRP;
919:
920: -- Standard call to check for call compatibility.
921: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: END IF;
924:
1026: RAISE FND_API.G_EXC_ERROR ;
1027: END IF;
1028: --------------------------------------------
1029:
1030: -- Standard check of p_commit
1031: IF FND_API.To_Boolean( p_commit ) THEN
1032: COMMIT WORK;
1033: END IF;
1034: -- Standard call to get message count and if count is 1, get message info.
1030: -- Standard check of p_commit
1031: IF FND_API.To_Boolean( p_commit ) THEN
1032: COMMIT WORK;
1033: END IF;
1034: -- Standard call to get message count and if count is 1, get message info.
1035: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1036:
1037: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving Set_Contract_Source_details');