APPS.CN_CNSYTC_TABLES_PVT dependencies on FND_API

Line 197: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

193: SAVEPOINT cn_obj_tables ;
194: --+
195: -- Standard call to check for call compatibility.
196: --+
197: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
198: p_api_version ,
199: l_api_name ,
200: G_PKG_NAME )
201: THEN

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198: p_api_version ,
199: l_api_name ,
200: G_PKG_NAME )
201: THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204: --+
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: -- +

Line 207: IF FND_API.to_Boolean( p_init_msg_list ) THEN

203: END IF;
204: --+
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: -- +
207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210: -- +
211: -- Initialize API return status to success

Line 213: x_return_status := FND_API.G_RET_STS_SUCCESS;

209: END IF;
210: -- +
211: -- Initialize API return status to success
212: -- +
213: x_return_status := FND_API.G_RET_STS_SUCCESS;
214: x_loading_status := 'CN_INSERTED';
215: -- +
216: --+
217: -- +

Line 231: IF( FND_API.to_boolean(p_commit)) THEN

227: -- +
228: -- Standard Check to p_commit
229: --+
230:
231: IF( FND_API.to_boolean(p_commit)) THEN
232: COMMIT WORK;
233: END IF ;
234:
235: -- +

Line 242: p_encoded => FND_API.G_FALSE

238: FND_MSG_PUB.count_and_get
239: (
240: p_count => x_msg_count ,
241: p_data => x_msg_data ,
242: p_encoded => FND_API.G_FALSE
243: );
244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN

Line 246: WHEN FND_API.G_EXC_ERROR THEN

242: p_encoded => FND_API.G_FALSE
243: );
244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO cn_obj_tables ;
248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get
250: (

Line 248: x_return_status := FND_API.G_RET_STS_ERROR ;

244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO cn_obj_tables ;
248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get
250: (
251: p_count => x_msg_count ,
252: p_data => x_msg_data ,

Line 253: p_encoded => FND_API.G_FALSE

249: FND_MSG_PUB.Count_And_Get
250: (
251: p_count => x_msg_count ,
252: p_data => x_msg_data ,
253: p_encoded => FND_API.G_FALSE
254: );
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO cn_obj_tables ;
257: x_loading_status := 'UNEXPECTED_ERR';

Line 255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

251: p_count => x_msg_count ,
252: p_data => x_msg_data ,
253: p_encoded => FND_API.G_FALSE
254: );
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO cn_obj_tables ;
257: x_loading_status := 'UNEXPECTED_ERR';
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259: FND_MSG_PUB.Count_And_Get

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

254: );
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO cn_obj_tables ;
257: x_loading_status := 'UNEXPECTED_ERR';
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,
262: p_data => x_msg_data ,

Line 263: p_encoded => FND_API.G_FALSE

259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: p_encoded => FND_API.G_FALSE
264: );
265: WHEN OTHERS THEN
266: ROLLBACK TO cn_obj_tables ;
267: x_loading_status := 'UNEXPECTED_ERR';

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

264: );
265: WHEN OTHERS THEN
266: ROLLBACK TO cn_obj_tables ;
267: x_loading_status := 'UNEXPECTED_ERR';
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
270: THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
272: END IF;

Line 277: p_encoded => FND_API.G_FALSE

273: FND_MSG_PUB.Count_And_Get
274: (
275: p_count => x_msg_count ,
276: p_data => x_msg_data ,
277: p_encoded => FND_API.G_FALSE
278: );
279:
280: END create_tables;
281: --