74: IF (l_debug = 'Y') THEN
75: okc_debug.log('100: Entered Validate_Allowed_Tmpl_Usages', 2);
76: END IF;
77:
78: -- Standard Start of API savepoint
79: SAVEPOINT g_Validate_Allowed_Usages_GRP;
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Standard Start of API savepoint
79: SAVEPOINT g_Validate_Allowed_Usages_GRP;
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84: -- Initialize message list if p_init_msg_list is set to TRUE.
123: RAISE FND_API.G_EXC_ERROR ;
124: END IF;
125: --------------------------------------------
126:
127: -- Standard call to get message count and if count is 1, get message info.
128: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
129:
130: IF (l_debug = 'Y') THEN
131: okc_debug.log('200: Leaving Validate_Allowed_Tmpl_Usages', 2);
214: IF (l_debug = 'Y') THEN
215: okc_debug.log('600: Entered Create_Allowed_Tmpl_Usages', 2);
216: END IF;
217:
218: -- Standard Start of API savepoint
219: SAVEPOINT g_Create_Allowed_Usages_GRP;
220: -- Standard call to check for call compatibility.
221: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: -- Standard Start of API savepoint
219: SAVEPOINT g_Create_Allowed_Usages_GRP;
220: -- Standard call to check for call compatibility.
221: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: -- Initialize message list if p_init_msg_list is set to TRUE.
263: RAISE FND_API.G_EXC_ERROR ;
264: END IF;
265: --------------------------------------------
266:
267: -- Standard check of p_commit
268: IF FND_API.To_Boolean( p_commit ) THEN
269: COMMIT WORK;
270: END IF;
271: -- Standard call to get message count and if count is 1, get message info.
267: -- Standard check of p_commit
268: IF FND_API.To_Boolean( p_commit ) THEN
269: COMMIT WORK;
270: END IF;
271: -- Standard call to get message count and if count is 1, get message info.
272: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
273:
274: IF (l_debug = 'Y') THEN
275: okc_debug.log('700: Leaving Create_Allowed_Tmpl_Usages', 2);
326: IF (l_debug = 'Y') THEN
327: okc_debug.log('1100: Entered Lock_Allowed_Tmpl_Usages', 2);
328: END IF;
329:
330: -- Standard Start of API savepoint
331: SAVEPOINT g_Lock_Allowed_Usages_GRP;
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: -- Standard Start of API savepoint
331: SAVEPOINT g_Lock_Allowed_Usages_GRP;
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336: -- Initialize message list if p_init_msg_list is set to TRUE.
355: RAISE FND_API.G_EXC_ERROR ;
356: END IF;
357: --------------------------------------------
358:
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 (l_debug = 'Y') THEN
363: okc_debug.log('1200: Leaving Lock_Allowed_Tmpl_Usages', 2);
441: okc_debug.log('1600: Entered Update_Allowed_Tmpl_Usages', 2);
442: okc_debug.log('1700: Locking row', 2);
443: END IF;
444:
445: -- Standard Start of API savepoint
446: SAVEPOINT g_Update_Allowed_Usages_GRP;
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Standard Start of API savepoint
446: SAVEPOINT g_Update_Allowed_Usages_GRP;
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
490: RAISE FND_API.G_EXC_ERROR ;
491: END IF;
492: --------------------------------------------
493:
494: -- Standard check of p_commit
495: IF FND_API.To_Boolean( p_commit ) THEN
496: COMMIT WORK;
497: END IF;
498: -- Standard call to get message count and if count is 1, get message info.
494: -- Standard check of p_commit
495: IF FND_API.To_Boolean( p_commit ) THEN
496: COMMIT WORK;
497: END IF;
498: -- Standard call to get message count and if count is 1, get message info.
499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
500:
501: IF (l_debug = 'Y') THEN
502: okc_debug.log('1800: Leaving Update_Allowed_Tmpl_Usages', 2);
555: IF (l_debug = 'Y') THEN
556: okc_debug.log('2200: Entered Delete_Allowed_Tmpl_Usages', 2);
557: END IF;
558:
559: -- Standard Start of API savepoint
560: SAVEPOINT g_Delete_Allowed_Usages_GRP;
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: -- Standard Start of API savepoint
560: SAVEPOINT g_Delete_Allowed_Usages_GRP;
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565: -- Initialize message list if p_init_msg_list is set to TRUE.
584: RAISE FND_API.G_EXC_ERROR ;
585: END IF;
586: --------------------------------------------
587:
588: -- Standard check of p_commit
589: IF FND_API.To_Boolean( p_commit ) THEN
590: COMMIT WORK;
591: END IF;
592: -- Standard call to get message count and if count is 1, get message info.
588: -- Standard check of p_commit
589: IF FND_API.To_Boolean( p_commit ) THEN
590: COMMIT WORK;
591: END IF;
592: -- Standard call to get message count and if count is 1, get message info.
593: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
594:
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('2300: Leaving Delete_Allowed_Tmpl_Usages', 2);