48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55: -- Initialize API return status to SUCCESS
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: COMMIT WORK;
94: END IF;
95:
96: -- Standard callto get message count and if count is 1, get message info.
97: FND_MSG_PUB.Count_And_Get
98: ( p_count => x_msg_count,
99: p_data => x_msg_data
100: );
101: EXCEPTION
101: EXCEPTION
102: WHEN FND_API.G_EXC_ERROR THEN
103: ROLLBACK TO startOPStats_pvt;
104: x_return_status := FND_API.G_RET_STS_ERROR ;
105: FND_MSG_PUB.Count_And_Get(
106: p_count => x_msg_count,
107: p_data => x_msg_data);
108:
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108:
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO startOPStats_pvt;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: FND_MSG_PUB.Count_And_Get(
113: p_count => x_msg_count,
114: p_data => x_msg_data);
115: WHEN OTHERS THEN
116: ROLLBACK TO startOPStats_pvt;
114: p_data => x_msg_data);
115: WHEN OTHERS THEN
116: ROLLBACK TO startOPStats_pvt;
117: x_return_status := FND_API.G_RET_STS_ERROR;
118: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
119: THEN
120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
121: END IF;
122: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
116: ROLLBACK TO startOPStats_pvt;
117: x_return_status := FND_API.G_RET_STS_ERROR;
118: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
119: THEN
120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
121: END IF;
122: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
123: p_data => x_msg_data);
124:
118: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
119: THEN
120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
121: END IF;
122: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
123: p_data => x_msg_data);
124:
125: END startOPStats;
126:
172:
173: -- Initialize message list if p_init_msg_list is set to TRUE.
174: IF FND_API.to_Boolean( p_init_msg_list )
175: THEN
176: FND_MSG_PUB.initialize;
177: END IF;
178:
179: -- Initialize API return status to SUCCESS
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: COMMIT WORK;
241: END IF;
242:
243: -- Standard callto get message count and if count is 1, get message info.
244: FND_MSG_PUB.Count_And_Get
245: ( p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: EXCEPTION
248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO recordOPStats_pvt;
251: x_return_status := FND_API.G_RET_STS_ERROR ;
252: FND_MSG_PUB.Count_And_Get(
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: ROLLBACK TO recordOPStats_pvt;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259: FND_MSG_PUB.Count_And_Get(
260: p_count => x_msg_count,
261: p_data => x_msg_data);
262: WHEN OTHERS THEN
263: ROLLBACK TO recordOPStats_pvt;
261: p_data => x_msg_data);
262: WHEN OTHERS THEN
263: ROLLBACK TO recordOPStats_pvt;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
266: THEN
267: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
268: END IF;
269: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
263: ROLLBACK TO recordOPStats_pvt;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
266: THEN
267: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
268: END IF;
269: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
270: p_data => x_msg_data);
271:
265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
266: THEN
267: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
268: END IF;
269: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
270: p_data => x_msg_data);
271:
272: END recordOPStats;
273: