DBA Data[Home] [Help]

APPS.CS_CTR_CAPTURE_READING_PUB dependencies on CS_CTR_CAPTURE_READING_PUB

Line 1: PACKAGE BODY CS_CTR_CAPTURE_READING_PUB as

1: PACKAGE BODY CS_CTR_CAPTURE_READING_PUB as
2: -- $Header: csxpcrdb.pls 120.2 2005/06/15 10:31:58 appldev $
3: -- Start of Comments
4: -- Package name : CS_CAPTURE_READING_PUB
5: -- Purpose : Capture readings for counters

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CS_CTR_CAPTURE_READING_PUB';

5: -- Purpose : Capture readings for counters
6: -- History :
7: -- NOTE :
8: -- End of Comments
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CS_CTR_CAPTURE_READING_PUB';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csxpcrdb.pls';
11:
12: PROCEDURE Capture_Counter_Reading(
13: P_Api_Version_Number IN NUMBER,

Line 46: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;

42: l_src_obj_id NUMBER;
43:
44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
49: p_api_version_number,
50: l_api_name,

Line 268: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

264: p_data => x_msg_data
265: );
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
269: x_return_status := FND_API.G_RET_STS_ERROR ;
270: FND_MSG_PUB.Count_And_Get
271: (p_count => x_msg_count ,
272: p_data => x_msg_data

Line 275: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

271: (p_count => x_msg_count ,
272: p_data => x_msg_data
273: );
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get
278: (p_count => x_msg_count ,
279: p_data => x_msg_data

Line 282: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

278: (p_count => x_msg_count ,
279: p_data => x_msg_data
280: );
281: WHEN OTHERS THEN
282: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
285: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
286: END IF;

Line 319: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;

315: l_msg_index NUMBER;
316: l_msg_count NUMBER;
317: BEGIN
318: -- Standard Start of API savepoint
319: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
322: p_api_version_number,
323: l_api_name,

Line 417: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

413: p_data => x_msg_data
414: );
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
418: x_return_status := FND_API.G_RET_STS_ERROR ;
419: FND_MSG_PUB.Count_And_Get
420: (p_count => x_msg_count ,
421: p_data => x_msg_data

Line 424: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

420: (p_count => x_msg_count ,
421: p_data => x_msg_data
422: );
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: FND_MSG_PUB.Count_And_Get
427: (p_count => x_msg_count ,
428: p_data => x_msg_data

Line 431: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

427: (p_count => x_msg_count ,
428: p_data => x_msg_data
429: );
430: WHEN OTHERS THEN
431: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
435: END IF;

Line 466: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;

462: l_msg_index NUMBER;
463: l_msg_count NUMBER;
464: BEGIN
465: -- Standard Start of API savepoint
466: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
469: p_api_version_number,
470: l_api_name,

Line 600: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

596: p_data => x_msg_data
597: );
598: EXCEPTION
599: WHEN FND_API.G_EXC_ERROR THEN
600: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
601: x_return_status := FND_API.G_RET_STS_ERROR ;
602: FND_MSG_PUB.Count_And_Get
603: (p_count => x_msg_count ,
604: p_data => x_msg_data

Line 607: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

603: (p_count => x_msg_count ,
604: p_data => x_msg_data
605: );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: FND_MSG_PUB.Count_And_Get
610: (p_count => x_msg_count ,
611: p_data => x_msg_data

Line 614: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

610: (p_count => x_msg_count ,
611: p_data => x_msg_data
612: );
613: WHEN OTHERS THEN
614: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
617: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
618: END IF;

Line 645: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;

641: l_msg_index NUMBER;
642: l_msg_count NUMBER;
643: BEGIN
644: -- Standard Start of API savepoint
645: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
646: -- Standard call to check for call compatibility.
647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
648: p_api_version_number,
649: l_api_name,

Line 735: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

731: p_data => x_msg_data
732: );
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737: FND_MSG_PUB.Count_And_Get
738: (p_count => x_msg_count ,
739: p_data => x_msg_data

Line 742: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

738: (p_count => x_msg_count ,
739: p_data => x_msg_data
740: );
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: FND_MSG_PUB.Count_And_Get
745: (p_count => x_msg_count ,
746: p_data => x_msg_data

Line 749: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

745: (p_count => x_msg_count ,
746: p_data => x_msg_data
747: );
748: WHEN OTHERS THEN
749: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
751: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
753: END IF;

Line 956: END CS_CTR_CAPTURE_READING_PUB;

952: l_api_version_number CONSTANT NUMBER := 1.0;
953: BEGIN
954: x_return_status := FND_API.G_RET_STS_SUCCESS;
955: END Update_CTR_Prop_Reading;
956: END CS_CTR_CAPTURE_READING_PUB;