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.12010000.2 2009/04/17 14:23:18 ngoutam ship $
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 269: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 276: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 283: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 320: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;

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

Line 418: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 425: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 432: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 467: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;

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

Line 601: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 608: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 615: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 646: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;

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

Line 736: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 743: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 750: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;

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

Line 957: END CS_CTR_CAPTURE_READING_PUB;

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