DBA Data[Home] [Help]

APPS.PSB_WS_LINE_YEAR_L_PVT dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.initialize ;

94: END IF;
95: --
96:
97: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
98: FND_MSG_PUB.initialize ;
99: END IF;
100: --
101: p_row_locked := FND_API.G_TRUE;
102: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 166: FND_MSG_PUB.Add;

162: FETCH C INTO Recinfo;
163: IF (C%NOTFOUND) then
164: CLOSE C;
165: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR ;
168: END IF;
169: CLOSE C;
170: --Check for Amount change removed for performance reasons

Line 181: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

177: IF FND_API.To_Boolean ( p_commit ) THEN
178: COMMIT WORK;
179: END iF;
180: --
181: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
182: p_data => p_msg_data );
183: --
184: EXCEPTION
185: --

Line 190: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

186: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
187: ROLLBACK TO Lock_Row_Pvt ;
188: p_row_locked := FND_API.G_FALSE;
189: p_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
191: p_data => p_msg_data );
192: WHEN FND_API.G_EXC_ERROR THEN
193: --
194: ROLLBACK TO Lock_Row_Pvt ;

Line 196: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

192: WHEN FND_API.G_EXC_ERROR THEN
193: --
194: ROLLBACK TO Lock_Row_Pvt ;
195: p_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
197: p_data => p_msg_data );
198: --
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: --

Line 203: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: --
201: ROLLBACK TO Lock_Row_Pvt ;
202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
204: p_data => p_msg_data );
205: --
206: WHEN OTHERS THEN
207: --

Line 211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

207: --
208: ROLLBACK TO Lock_Row_Pvt ;
209: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: --
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
212: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
213: l_api_name);
214: END if;
215: --

Line 212: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

208: ROLLBACK TO Lock_Row_Pvt ;
209: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: --
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
212: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
213: l_api_name);
214: END if;
215: --
216: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 216: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

212: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
213: l_api_name);
214: END if;
215: --
216: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
217: p_data => p_msg_data );
218: --
219: END Lock_Row;
220: /* ----------------------------------------------------------------------- */