34: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Ct_Rule';
35: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
36: l_pvt_ct_rule_rec AMS_Ct_Rule_PVT.ct_rule_rec_type;
37: BEGIN
38: -- Standard Start of API savepoint
39: SAVEPOINT CREATE_Ct_Rule_PUB;
40:
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
37: BEGIN
38: -- Standard Start of API savepoint
39: SAVEPOINT CREATE_Ct_Rule_PUB;
40:
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
43: p_api_version_number,
44: l_api_name,
45: G_PKG_NAME)
86: --
87: -- End of API body.
88: --
89:
90: -- Standard check for p_commit
91: IF FND_API.to_Boolean( p_commit )
92: THEN
93: COMMIT WORK;
94: END IF;
96:
97: -- Debug Message
98: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
99:
100: -- Standard call to get message count and if count is 1, get message info.
101: FND_MSG_PUB.Count_And_Get
102: (p_count => x_msg_count,
103: p_data => x_msg_data
104: );
110:
111: WHEN FND_API.G_EXC_ERROR THEN
112: ROLLBACK TO CREATE_Ct_Rule_PUB;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: -- Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data
120:
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: ROLLBACK TO CREATE_Ct_Rule_PUB;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: -- Standard call to get message count and if count=1, get the message
125: FND_MSG_PUB.Count_And_Get (
126: p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
128: p_data => x_msg_data
134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
135: THEN
136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
137: END IF;
138: -- Standard call to get message count and if count=1, get the message
139: FND_MSG_PUB.Count_And_Get (
140: p_encoded => FND_API.G_FALSE,
141: p_count => x_msg_count,
142: p_data => x_msg_data
162: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
163: l_object_version_number NUMBER;
164: l_pvt_ct_rule_rec AMS_Ct_Rule_PVT.ct_rule_rec_type;
165: BEGIN
166: -- Standard Start of API savepoint
167: SAVEPOINT UPDATE_Ct_Rule_PUB;
168:
169: -- Standard call to check for call compatibility.
170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
165: BEGIN
166: -- Standard Start of API savepoint
167: SAVEPOINT UPDATE_Ct_Rule_PUB;
168:
169: -- Standard call to check for call compatibility.
170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
212: --
213: -- End of API body
214: --
215:
216: -- Standard check for p_commit
217: IF FND_API.to_Boolean( p_commit )
218: THEN
219: COMMIT WORK;
220: END IF;
222:
223: -- Debug Message
224: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
225:
226: -- Standard call to get message count and if count is 1, get message info.
227: FND_MSG_PUB.Count_And_Get
228: (p_count => x_msg_count,
229: p_data => x_msg_data
230: );
236:
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO UPDATE_Ct_Rule_PUB;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: -- Standard call to get message count and if count=1, get the message
241: FND_MSG_PUB.Count_And_Get (
242: p_encoded => FND_API.G_FALSE,
243: p_count => x_msg_count,
244: p_data => x_msg_data
246:
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
248: ROLLBACK TO UPDATE_Ct_Rule_PUB;
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data
260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
263: END IF;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => x_msg_count,
268: p_data => x_msg_data
287: l_CONTENT_RULE_ID NUMBER := p_CONTENT_RULE_ID;
288: l_object_version_number NUMBER := p_object_version_number;
289: l_pvt_ct_rule_rec AMS_Ct_Rule_PVT.ct_rule_rec_type;
290: BEGIN
291: -- Standard Start of API savepoint
292: SAVEPOINT DELETE_Ct_Rule_PUB;
293:
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
290: BEGIN
291: -- Standard Start of API savepoint
292: SAVEPOINT DELETE_Ct_Rule_PUB;
293:
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
337: --
338: -- End of API body
339: --
340:
341: -- Standard check for p_commit
342: IF FND_API.to_Boolean( p_commit )
343: THEN
344: COMMIT WORK;
345: END IF;
347:
348: -- Debug Message
349: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
350:
351: -- Standard call to get message count and if count is 1, get message info.
352: FND_MSG_PUB.Count_And_Get
353: (p_count => x_msg_count,
354: p_data => x_msg_data
355: );
361:
362: WHEN FND_API.G_EXC_ERROR THEN
363: ROLLBACK TO DELETE_Ct_Rule_PUB;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: -- Standard call to get message count and if count=1, get the message
366: FND_MSG_PUB.Count_And_Get (
367: p_encoded => FND_API.G_FALSE,
368: p_count => x_msg_count,
369: p_data => x_msg_data
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: ROLLBACK TO DELETE_Ct_Rule_PUB;
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: -- Standard call to get message count and if count=1, get the message
376: FND_MSG_PUB.Count_And_Get (
377: p_encoded => FND_API.G_FALSE,
378: p_count => x_msg_count,
379: p_data => x_msg_data
385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
388: END IF;
389: -- Standard call to get message count and if count=1, get the message
390: FND_MSG_PUB.Count_And_Get (
391: p_encoded => FND_API.G_FALSE,
392: p_count => x_msg_count,
393: p_data => x_msg_data
411: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
412: l_pvt_ct_rule_rec AMS_Ct_Rule_PVT.ct_rule_rec_type;
413: BEGIN
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
417: p_api_version_number,
418: l_api_name,
419: G_PKG_NAME)
470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO LOCK_Ct_Rule_PUB;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data
480:
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO LOCK_Ct_Rule_PUB;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: -- Standard call to get message count and if count=1, get the message
485: FND_MSG_PUB.Count_And_Get (
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data