46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: -- Initialize message list if p_init_msg_list is set to TRUE.
49: IF FND_API.to_Boolean( p_init_msg_list ) THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52: -- Initialize API return status to success
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54: -- API Body Begin
75: IF FND_API.To_Boolean( p_commit ) THEN
76: COMMIT WORK;
77: END IF;
78: -- Standard call to get message count and if count is 1, get message info.
79: FND_MSG_PUB.Count_And_Get
80: (p_count => x_msg_count ,
81: p_data => x_msg_data ,
82: p_encoded => FND_API.G_FALSE );
83:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: ROLLBACK TO insert_row_sv;
87: x_return_status := FND_API.G_RET_STS_ERROR ;
88: FND_MSG_PUB.Count_And_Get(
89: p_count => x_msg_count ,
90: p_data => x_msg_data ,
91: p_encoded => FND_API.G_FALSE);
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: p_encoded => FND_API.G_FALSE);
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ROLLBACK TO insert_row_sv;
94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
95: FND_MSG_PUB.Count_And_Get(
96: p_count => x_msg_count ,
97: p_data => x_msg_data ,
98: p_encoded => FND_API.G_FALSE);
99: WHEN OTHERS THEN
98: p_encoded => FND_API.G_FALSE);
99: WHEN OTHERS THEN
100: ROLLBACK TO insert_row_sv;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(
99: WHEN OTHERS THEN
100: ROLLBACK TO insert_row_sv;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(
107: p_count => x_msg_count ,
100: ROLLBACK TO insert_row_sv;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(
107: p_count => x_msg_count ,
108: p_data => x_msg_data ,
102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(
107: p_count => x_msg_count ,
108: p_data => x_msg_data ,
109: p_encoded => FND_API.G_FALSE);
110: END insert_row;
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: -- API Body Begin
166: CLOSE l_ovn_csr;
167:
168: if (l_object_version_number <> p_object_version_number) THEN
169:
170: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
171: THEN
172: fnd_message.set_name('CN', 'CL_INVALID_OVN');
173: fnd_msg_pub.add;
174: END IF;
169:
170: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
171: THEN
172: fnd_message.set_name('CN', 'CL_INVALID_OVN');
173: fnd_msg_pub.add;
174: END IF;
175:
176: RAISE FND_API.G_EXC_ERROR;
177:
201: IF FND_API.To_Boolean( p_commit ) THEN
202: COMMIT WORK;
203: END IF;
204: -- Standard call to get message count and if count is 1, get message info.
205: FND_MSG_PUB.Count_And_Get
206: (p_count => x_msg_count ,
207: p_data => x_msg_data ,
208: p_encoded => FND_API.G_FALSE );
209: EXCEPTION
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO update_row_sv;
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get(
214: p_count => x_msg_count ,
215: p_data => x_msg_data ,
216: p_encoded => FND_API.G_FALSE);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: p_encoded => FND_API.G_FALSE);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: ROLLBACK TO update_row_sv;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: FND_MSG_PUB.Count_And_Get(
221: p_count => x_msg_count ,
222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE);
224: WHEN OTHERS THEN
223: p_encoded => FND_API.G_FALSE);
224: WHEN OTHERS THEN
225: ROLLBACK TO update_row_sv;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(
224: WHEN OTHERS THEN
225: ROLLBACK TO update_row_sv;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
225: ROLLBACK TO update_row_sv;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,
227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,
234: p_encoded => FND_API.G_FALSE);
235: END update_row;
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269: -- Initialize API return status to success
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271: -- API Body Begin
278: IF FND_API.To_Boolean( p_commit ) THEN
279: COMMIT WORK;
280: END IF;
281: -- Standard call to get message count and if count is 1, get message info.
282: FND_MSG_PUB.Count_And_Get
283: (p_count => x_msg_count ,
284: p_data => x_msg_data ,
285: p_encoded => FND_API.G_FALSE );
286: EXCEPTION
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO delete_row_sv;
289: x_return_status := FND_API.G_RET_STS_ERROR ;
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count ,
292: p_data => x_msg_data ,
293: p_encoded => FND_API.G_FALSE);
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: p_encoded => FND_API.G_FALSE);
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO delete_row_sv;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
297: FND_MSG_PUB.Count_And_Get(
298: p_count => x_msg_count ,
299: p_data => x_msg_data ,
300: p_encoded => FND_API.G_FALSE);
301: WHEN OTHERS THEN
300: p_encoded => FND_API.G_FALSE);
301: WHEN OTHERS THEN
302: ROLLBACK TO delete_row_sv;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(
301: WHEN OTHERS THEN
302: ROLLBACK TO delete_row_sv;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(
309: p_count => x_msg_count ,
302: ROLLBACK TO delete_row_sv;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(
309: p_count => x_msg_count ,
310: p_data => x_msg_data ,
304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(
309: p_count => x_msg_count ,
310: p_data => x_msg_data ,
311: p_encoded => FND_API.G_FALSE);
312: