APPS.CS_COUNTERS_EXT_PVT dependencies on CS_COUNTERS_EXT_PVT

Line 1: PACKAGE BODY CS_COUNTERS_EXT_PVT AS

1: PACKAGE BODY CS_COUNTERS_EXT_PVT AS
2: -- $Header: csxvcteb.pls 120.2 2005/07/25 14:02:35 appldev ship $
3:
4: -- ---------------------------------------------------------
5: -- Define global variables

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_Counters_EXT_PVT';

3:
4: -- ---------------------------------------------------------
5: -- Define global variables
6: -- ---------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_Counters_EXT_PVT';
8: --G_USER CONSTANT VARCHAR2(30) := FND_GLOBAL.USER_ID;
9: --------------------------------------------------------------------------
10:
11: -- ---------------------------------------------------------

Line 195: SAVEPOINT CS_COUNTERS_EXT_PVT;

191: l_bind_var_value NUMBER;
192: l_bind_var_name VARCHAR2(255);
193: BEGIN
194: -- Standard Start of API savepoint
195: SAVEPOINT CS_COUNTERS_EXT_PVT;
196: -- Standard call to check for call compatibility.
197: IF NOT FND_API.Compatible_API_Call ( l_api_version,
198: p_api_version,
199: l_api_name,

Line 296: ROLLBACK TO CS_COUNTERS_EXT_PVT;

292: );
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: disp('4');
296: ROLLBACK TO CS_COUNTERS_EXT_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count,
300: p_data => x_msg_data

Line 304: ROLLBACK TO CS_COUNTERS_EXT_PVT;

300: p_data => x_msg_data
301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: disp('5');
304: ROLLBACK TO CS_COUNTERS_EXT_PVT;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306: FND_MSG_PUB.Count_And_Get
307: (
308: p_count => x_msg_count,

Line 313: ROLLBACK TO CS_COUNTERS_EXT_PVT;

309: p_data => x_msg_data
310: );
311: WHEN OTHERS THEN
312: disp('6'||sqlerrm);
313: ROLLBACK TO CS_COUNTERS_EXT_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
316: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
317: END IF;

Line 383: SAVEPOINT CS_COUNTERS_EXT_PVT;

379: l_bind_varvaln NUMBER;
380:
381: BEGIN
382: -- Standard Start of API savepoint
383: SAVEPOINT CS_COUNTERS_EXT_PVT;
384: -- Standard call to check for call compatibility.
385: IF NOT FND_API.Compatible_API_Call ( l_api_version,
386: p_api_version,
387: l_api_name,

Line 547: ROLLBACK TO CS_COUNTERS_EXT_PVT;

543: );
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: disp('4');
547: ROLLBACK TO CS_COUNTERS_EXT_PVT;
548: x_return_status := FND_API.G_RET_STS_ERROR ;
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count,
551: p_data => x_msg_data

Line 555: ROLLBACK TO CS_COUNTERS_EXT_PVT;

551: p_data => x_msg_data
552: );
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: disp('5');
555: ROLLBACK TO CS_COUNTERS_EXT_PVT;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: FND_MSG_PUB.Count_And_Get
558: (
559: p_count => x_msg_count,

Line 564: ROLLBACK TO CS_COUNTERS_EXT_PVT;

560: p_data => x_msg_data
561: );
562: WHEN OTHERS THEN
563: disp('6'||sqlerrm);
564: ROLLBACK TO CS_COUNTERS_EXT_PVT;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
567: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
568: END IF;

Line 842: END CS_COUNTERS_EXT_PVT;

838: x_return_status := fnd_api.g_ret_sts_error;
839: END IF;
840: END Validate_Desc_Flex;
841:
842: END CS_COUNTERS_EXT_PVT;