DBA Data[Home] [Help]

APPS.CSI_CTR_EST_CTR_READING_GRP dependencies on FND_API

Line 20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

16:
17: PROCEDURE estimate_counter_reading
18: (
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: p_counter_id IN NUMBER,
24: p_estimation_period_start_date IN DATE,

Line 21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

17: PROCEDURE estimate_counter_reading
18: (
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: p_counter_id IN NUMBER,
24: p_estimation_period_start_date IN DATE,
25: p_estimation_period_end_date IN DATE,

Line 22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

18: (
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: p_counter_id IN NUMBER,
24: p_estimation_period_start_date IN DATE,
25: p_estimation_period_end_date IN DATE,
26: p_avg_calculation_start_date IN DATE,

Line 46: IF NOT FND_API.Compatible_API_Call (l_api_version_number ,

42: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
43: csi_ctr_gen_utility_pvt.check_ib_active;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call (l_api_version_number ,
47: p_api_version_number ,
48: l_api_name ,
49: G_PKG_NAME )
50: THEN

Line 51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

47: p_api_version_number ,
48: l_api_name ,
49: G_PKG_NAME )
50: THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53:
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 55: IF FND_API.to_Boolean( p_init_msg_list ) THEN

51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53:
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Initialize API return status to SUCCESS

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Initialize API return status to SUCCESS
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: -- Read the debug profiles values in to global variable 7197402
63: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
64:

Line 100: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

96: x_return_status => x_return_status,
97: x_msg_count => x_msg_count,
98: x_msg_data => x_msg_data
99: );
100: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
101: ROLLBACK TO ESTIMATE_COUNTER_READING;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:

Line 102: RAISE FND_API.G_EXC_ERROR;

98: x_msg_data => x_msg_data
99: );
100: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
101: ROLLBACK TO ESTIMATE_COUNTER_READING;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:
105: -- End of API Body.
106: IF FND_API.To_Boolean(p_commit) THEN

Line 106: IF FND_API.To_Boolean(p_commit) THEN

102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:
105: -- End of API Body.
106: IF FND_API.To_Boolean(p_commit) THEN
107: COMMIT WORK;
108: END IF;
109:
110: FND_MSG_PUB.Count_And_Get

Line 116: WHEN FND_API.G_EXC_ERROR THEN

112: p_data => x_msg_data
113: );
114:
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: ROLLBACK TO ESTIMATE_COUNTER_READING;
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: (p_count => x_msg_count ,

Line 118: x_return_status := FND_API.G_RET_STS_ERROR ;

114:
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: ROLLBACK TO ESTIMATE_COUNTER_READING;
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: (p_count => x_msg_count ,
121: p_data => x_msg_data
122: );

Line 123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

119: FND_MSG_PUB.Count_And_Get
120: (p_count => x_msg_count ,
121: p_data => x_msg_data
122: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: ROLLBACK TO ESTIMATE_COUNTER_READING;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: (p_count => x_msg_count ,

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

121: p_data => x_msg_data
122: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: ROLLBACK TO ESTIMATE_COUNTER_READING;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: (p_count => x_msg_count ,
128: p_data => x_msg_data
129: );

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

128: p_data => x_msg_data
129: );
130: WHEN OTHERS THEN
131: ROLLBACK TO ESTIMATE_COUNTER_READING;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
135: END IF;
136: FND_MSG_PUB.Count_And_Get