64: EXCEPTION
65:
66: WHEN OTHERS THEN
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
69: THEN
70: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
71: , 'Create_Period_Final_Status'
72: );
66: WHEN OTHERS THEN
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
69: THEN
70: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
71: , 'Create_Period_Final_Status'
72: );
73: END IF;
74: RAISE;
105:
106: -- Initialize message stack if required
107: IF FND_API.to_Boolean(p_init_msg_list)
108: THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111:
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113:
165: WHERE Organization_ID = l_historical_infl_adj_rec.organization_id
166: AND Acct_Period_ID = l_historical_infl_adj_rec.acct_period_id;
167:
168: -- Get message count and data
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count
171: , p_data => x_msg_data
172: );
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: WHERE Organization_ID = l_historical_infl_adj_rec.organization_id
177: AND Acct_Period_ID = l_historical_infl_adj_rec.acct_period_id;
178:
179: -- Get message count and data
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count
182: , p_data => x_msg_data
183: );
184: WHEN OTHERS THEN
186: DELETE FROM CST_MGD_INFL_ADJUSTED_COSTS
187: WHERE Organization_ID = l_historical_infl_adj_rec.organization_id
188: AND Acct_Period_ID = l_historical_infl_adj_rec.acct_period_id;
189:
190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg
193: ( G_PKG_NAME
194: , 'Create_Historical_Cost'
188: AND Acct_Period_ID = l_historical_infl_adj_rec.acct_period_id;
189:
190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg
193: ( G_PKG_NAME
194: , 'Create_Historical_Cost'
195: );
196: END IF;
194: , 'Create_Historical_Cost'
195: );
196: END IF;
197: -- Get message count and data
198: FND_MSG_PUB.Count_And_Get
199: ( p_count => x_msg_count
200: , p_data => x_msg_data
201: );
202:
241:
242: -- Initialize message stack if required
243: IF FND_API.to_Boolean(p_init_msg_list)
244: THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: DELETE FROM CST_MGD_INFL_ADJUSTED_COSTS;
249:
255:
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: -- Get message count and data
259: FND_MSG_PUB.Count_And_Get
260: ( p_count => x_msg_count
261: , p_data => x_msg_data
262: );
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
262: );
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
265: -- Get message count and data
266: FND_MSG_PUB.Count_And_Get
267: ( p_count => x_msg_count
268: , p_data => x_msg_data
269: );
270: WHEN OTHERS THEN
268: , p_data => x_msg_data
269: );
270: WHEN OTHERS THEN
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg
275: ( G_PKG_NAME
276: , 'Delete_All_Historical_Costs'
270: WHEN OTHERS THEN
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg
275: ( G_PKG_NAME
276: , 'Delete_All_Historical_Costs'
277: );
278: END IF;
276: , 'Delete_All_Historical_Costs'
277: );
278: END IF;
279: -- Get message count and data
280: FND_MSG_PUB.Count_And_Get
281: ( p_count => x_msg_count
282: , p_data => x_msg_data
283: );
284: