33: IS
34: l_rowid VARCHAR2(100);
35: BEGIN
36:
37: FND_MSG_PUB.Initialize;
38: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
39:
40: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW
41: ( X_ROWID => l_rowid
63:
64: EXCEPTION
65: WHEN FND_API.G_EXC_ERROR THEN
66: IF (x_msg_data IS NULL) THEN
67: FND_MSG_PUB.Count_And_Get
68: ( p_encoded => FND_API.G_FALSE
69: , p_count => x_msg_count
70: , p_data => x_msg_data
71: );
72: END IF;
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: IF (x_msg_data IS NULL) THEN
76: FND_MSG_PUB.Count_And_Get
77: ( p_encoded => FND_API.G_FALSE
78: , p_count => x_msg_count
79: , p_data => x_msg_data
80: );
110:
111: IS
112: BEGIN
113:
114: FND_MSG_PUB.Initialize;
115: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
116:
117: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW
118: ( X_CUSTOMIZATION_APPLICATION_ID => p_Custom_Region_Items_Rec.customization_application_id
137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: IF (x_msg_data IS NULL) THEN
141: FND_MSG_PUB.Count_And_Get
142: ( p_encoded => FND_API.G_FALSE
143: , p_count => x_msg_count
144: , p_data => x_msg_data
145: );
146: END IF;
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: IF (x_msg_data IS NULL) THEN
150: FND_MSG_PUB.Count_And_Get
151: ( p_encoded => FND_API.G_FALSE
152: , p_count => x_msg_count
153: , p_data => x_msg_data
154: );
180: , x_msg_count OUT NOCOPY NUMBER
181: , x_msg_data OUT NOCOPY VARCHAR2
182: ) IS
183: BEGIN
184: FND_MSG_PUB.Initialize;
185: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
186:
187: AK_CUSTOM_REGION_ITEMS_PKG.Delete_ROW
188: ( X_CUSTOMIZATION_APPLICATION_ID => p_Custom_Region_Items_Rec.customization_application_id
200:
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: IF (x_msg_data IS NULL) THEN
204: FND_MSG_PUB.Count_And_Get
205: ( p_encoded => FND_API.G_FALSE
206: , p_count => x_msg_count
207: , p_data => x_msg_data
208: );
209: END IF;
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: IF (x_msg_data IS NULL) THEN
213: FND_MSG_PUB.Count_And_Get
214: ( p_encoded => FND_API.G_FALSE
215: , p_count => x_msg_count
216: , p_data => x_msg_data
217: );
244: IS
245:
246: l_row_id VARCHAR2(32000);
247: BEGIN
248: FND_MSG_PUB.Initialize;
249: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
250:
251: INSERT INTO ak_customizations (
252: customization_application_id
342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: IF (x_msg_data IS NULL) THEN
346: FND_MSG_PUB.Count_And_Get
347: ( p_encoded => FND_API.G_FALSE
348: , p_count => x_msg_count
349: , p_data => x_msg_data
350: );
352:
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: IF (x_msg_data IS NULL) THEN
356: FND_MSG_PUB.Count_And_Get
357: ( p_encoded => FND_API.G_FALSE
358: , p_count => x_msg_count
359: , p_data => x_msg_data
360: );
390: , x_msg_data OUT NOCOPY VARCHAR2
391: )
392: IS
393: BEGIN
394: FND_MSG_PUB.Initialize;
395: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
396:
397: UPDATE ak_customizations SET
398: customization_application_id = p_Customizations_Rec.customization_application_id
440:
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443: IF (x_msg_data IS NULL) THEN
444: FND_MSG_PUB.Count_And_Get
445: ( p_encoded => FND_API.G_FALSE
446: , p_count => x_msg_count
447: , p_data => x_msg_data
448: );
449: END IF;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: IF (x_msg_data IS NULL) THEN
453: FND_MSG_PUB.Count_And_Get
454: ( p_encoded => FND_API.G_FALSE
455: , p_count => x_msg_count
456: , p_data => x_msg_data
457: );