81: END Get_Data;
82:
83: PROCEDURE Update_Data
84: (p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_name IN VARCHAR2,
89: p_rev_class_hierarchy_id IN NUMBER,
82:
83: PROCEDURE Update_Data
84: (p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_name IN VARCHAR2,
89: p_rev_class_hierarchy_id IN NUMBER,
90: p_set_of_books_id IN NUMBER,
83: PROCEDURE Update_Data
84: (p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_name IN VARCHAR2,
89: p_rev_class_hierarchy_id IN NUMBER,
90: p_set_of_books_id IN NUMBER,
91: p_batch_size IN NUMBER,
118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT Update_Data;
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call
123: (l_api_version ,
124: p_api_version ,
125: l_api_name ,
126: G_PKG_NAME )
124: p_api_version ,
125: l_api_name ,
126: G_PKG_NAME )
127: THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
132: FND_MSG_PUB.initialize;
127: THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
132: FND_MSG_PUB.initialize;
133: END IF;
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
132: FND_MSG_PUB.initialize;
133: END IF;
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: -- API body
138: -- locking
139: open c;
141: if (c%notfound) then
142: close c;
143: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
144: fnd_msg_pub.add;
145: raise fnd_api.g_exc_unexpected_error;
146: end if;
147: close c;
148:
149: if (tlinfo.object_version_number <> p_object_version_number) then
148:
149: if (tlinfo.object_version_number <> p_object_version_number) then
150: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
151: fnd_msg_pub.add;
152: raise fnd_api.g_exc_unexpected_error;
153: end if;
154:
155: -- updating
156: update cn_repositories
220:
221: -- End of API body.
222:
223: -- Standard check of p_commit.
224: IF FND_API.To_Boolean( p_commit ) THEN
225: COMMIT WORK;
226: END IF;
227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get
227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get
229: (p_count => x_msg_count ,
230: p_data => x_msg_data ,
231: p_encoded => FND_API.G_FALSE );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Update_Data;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
229: (p_count => x_msg_count ,
230: p_data => x_msg_data ,
231: p_encoded => FND_API.G_FALSE );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Update_Data;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
231: p_encoded => FND_API.G_FALSE );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Update_Data;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE );
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Update_Data;
242:
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Update_Data;
242:
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.count_and_get
239: p_encoded => FND_API.G_FALSE );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Update_Data;
242:
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.count_and_get
245: (p_count => x_msg_count ,
246: p_data => x_msg_data ,
247: p_encoded => FND_API.G_FALSE );
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.count_and_get
245: (p_count => x_msg_count ,
246: p_data => x_msg_data ,
247: p_encoded => FND_API.G_FALSE );
248: WHEN OTHERS THEN
249: ROLLBACK TO Update_Data;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: IF FND_MSG_PUB.check_msg_level
246: p_data => x_msg_data ,
247: p_encoded => FND_API.G_FALSE );
248: WHEN OTHERS THEN
249: ROLLBACK TO Update_Data;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: IF FND_MSG_PUB.check_msg_level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.add_exc_msg
257: END IF;
258: FND_MSG_PUB.count_and_get
259: (p_count => x_msg_count ,
260: p_data => x_msg_data ,
261: p_encoded => FND_API.G_FALSE );
262: END Update_Data;
263: END CN_SYSTEM_PARAMETERS_PVT;