19:
20: BEGIN
21: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
22:
23: -- Standard Start of API savepoint
24: SAVEPOINT Insert_SQL_Rule_PVT;
25:
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
22:
23: -- Standard Start of API savepoint
24: SAVEPOINT Insert_SQL_Rule_PVT;
25:
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
28: p_api_version,
29: L_API_NAME,
30: G_PKG_NAME )
78: IF (l_debug = 'Y') THEN
79: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_SQL_Rule(-)');
80: END IF;
81:
82: -- Standard check of p_commit.
83: IF FND_API.To_Boolean( p_commit ) THEN
84: COMMIT WORK;
85: END IF;
86:
83: IF FND_API.To_Boolean( p_commit ) THEN
84: COMMIT WORK;
85: END IF;
86:
87: -- Standard call to get message count and if count is 1, get message info.
88: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
89: p_count => x_msg_count ,
90: p_data => x_msg_data );
91:
143:
144: BEGIN
145: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
146:
147: -- Standard Start of API savepoint
148: SAVEPOINT Insert_Mapping_Rules_PVT;
149:
150: -- Standard call to check for call compatibility.
151: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
146:
147: -- Standard Start of API savepoint
148: SAVEPOINT Insert_Mapping_Rules_PVT;
149:
150: -- Standard call to check for call compatibility.
151: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
152: p_api_version,
153: L_API_NAME,
154: G_PKG_NAME )
255: IF (l_debug = 'Y') THEN
256: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_Mapping_Rules(-)');
257: END IF;
258:
259: -- Standard check of p_commit.
260: IF FND_API.To_Boolean( p_commit ) THEN
261: COMMIT WORK;
262: END IF;
263:
260: IF FND_API.To_Boolean( p_commit ) THEN
261: COMMIT WORK;
262: END IF;
263:
264: -- Standard call to get message count and if count is 1, get message info.
265: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count ,
267: p_data => x_msg_data );
268:
314:
315: BEGIN
316: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
317:
318: -- Standard Start of API savepoint
319: SAVEPOINT Update_Rule_PVT;
320:
321: -- Standard call to check for call compatibility.
322: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
317:
318: -- Standard Start of API savepoint
319: SAVEPOINT Update_Rule_PVT;
320:
321: -- Standard call to check for call compatibility.
322: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
323: p_api_version,
324: L_API_NAME,
325: G_PKG_NAME )
367: IF (l_debug = 'Y') THEN
368: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Update_Rule(-)');
369: END IF;
370:
371: -- Standard check of p_commit.
372: IF FND_API.To_Boolean( p_commit ) THEN
373: COMMIT WORK;
374: END IF;
375:
372: IF FND_API.To_Boolean( p_commit ) THEN
373: COMMIT WORK;
374: END IF;
375:
376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
378: p_count => x_msg_count ,
379: p_data => x_msg_data );
380: EXCEPTION
424:
425: BEGIN
426: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
427:
428: -- Standard Start of API savepoint
429: SAVEPOINT Delete_Rule_PVT;
430:
431: -- Standard call to check for call compatibility.
432: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
427:
428: -- Standard Start of API savepoint
429: SAVEPOINT Delete_Rule_PVT;
430:
431: -- Standard call to check for call compatibility.
432: IF NOT FND_API.Compatible_API_Call( L_API_VERSION,
433: p_api_version,
434: L_API_NAME,
435: G_PKG_NAME )
483: IF (l_debug = 'Y') THEN
484: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Delete_Rule(-)');
485: END IF;
486:
487: -- Standard check of p_commit.
488: IF FND_API.To_Boolean( p_commit ) THEN
489: COMMIT WORK;
490: END IF;
491:
488: IF FND_API.To_Boolean( p_commit ) THEN
489: COMMIT WORK;
490: END IF;
491:
492: -- Standard call to get message count and if count is 1, get message info.
493: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count ,
495: p_data => x_msg_data );
496: EXCEPTION