DBA Data[Home] [Help]

APPS.FEM_MV_REFRESH_PVT dependencies on FND_MSG_PUB

Line 71: FND_MSG_PUB.initialize ;

67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
68: END IF ;
69: --
70: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize ;
72: END IF ;
73: x_return_status := FND_API.G_RET_STS_SUCCESS ;
74:
75: --

Line 86: FND_MSG_PUB.Add;

82: CLOSE l_object_exists_csr ;
83:
84: IF l_object_found_flag = 'N' THEN
85: FND_MESSAGE.Set_Name('FND', 'FEM_MV_INVALID_MV_NAME') ;
86: FND_MSG_PUB.Add;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF ;
89:
90: l_object_found_flag := 'N' ;

Line 97: FND_MSG_PUB.Add;

93: CLOSE l_object_exists_csr ;
94:
95: IF l_object_found_flag = 'N' THEN
96: FND_MESSAGE.Set_Name('FND', 'FEM_MV_INVALID_BASE_TABLE_NAME') ;
97: FND_MSG_PUB.Add;
98: RAISE FND_API.G_EXC_ERROR;
99: END IF ;
100: --
101: -- End validating input parameters.

Line 142: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

138:
139: IF FND_API.To_Boolean ( p_commit ) THEN
140: COMMIT WORK ;
141: END IF ;
142: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
143: p_data => x_msg_data ) ;
144: EXCEPTION
145:
146: WHEN OTHERS THEN

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

147: --
148: ROLLBACK TO Register_MV_Pvt ;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
150: --
151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
153: l_api_name) ;
154: END IF ;
155: --

Line 152: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

148: ROLLBACK TO Register_MV_Pvt ;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
150: --
151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
153: l_api_name) ;
154: END IF ;
155: --
156: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 156: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

152: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
153: l_api_name) ;
154: END IF ;
155: --
156: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
157: p_data => x_msg_data ) ;
158: END Register_MV ;
159: /*---------------------------------------------------------------------------*/
160:

Line 197: FND_MSG_PUB.initialize ;

193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
194: END IF ;
195: --
196: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
197: FND_MSG_PUB.initialize ;
198: END IF ;
199: x_return_status := FND_API.G_RET_STS_SUCCESS ;
200:
201: -- Remove the MV from the repository table.

Line 207: FND_MSG_PUB.Add;

203: WHERE mv_name = p_mv_name ;
204:
205: IF SQL%ROWCOUNT <= 0 THEN
206: FND_MESSAGE.Set_Name('FND', 'FEM_MV_INVALID_MV_NAME') ;
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF ;
210:
211: IF FND_API.To_Boolean ( p_commit ) THEN

Line 215: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

211: IF FND_API.To_Boolean ( p_commit ) THEN
212: COMMIT WORK ;
213: END IF ;
214: --
215: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
216: p_data => x_msg_data ) ;
217: EXCEPTION
218:
219: WHEN OTHERS THEN

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

220: --
221: ROLLBACK TO Unregister_MV_Pvt ;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223: --
224: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
225: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
226: l_api_name) ;
227: END IF ;
228: --

Line 225: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

221: ROLLBACK TO Unregister_MV_Pvt ;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223: --
224: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
225: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
226: l_api_name) ;
227: END IF ;
228: --
229: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 229: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

225: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
226: l_api_name) ;
227: END IF ;
228: --
229: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
230: p_data => x_msg_data ) ;
231: END Unregister_MV;
232: /*---------------------------------------------------------------------------*/
233:

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

274:
275: EXCEPTION
276:
277: WHEN OTHERS THEN
278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
280: l_api_name ) ;
281: END IF ;
282:

Line 279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

275: EXCEPTION
276:
277: WHEN OTHERS THEN
278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
280: l_api_name ) ;
281: END IF ;
282:
283: -- Print the error message stack.

Line 284: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

280: l_api_name ) ;
281: END IF ;
282:
283: -- Print the error message stack.
284: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
285: p_data => l_msg_data ) ;
286: FOR i IN 1..l_msg_count
287: LOOP
288: FND_MSG_PUB.Get( p_msg_index => i ,

Line 288: FND_MSG_PUB.Get( p_msg_index => i ,

284: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
285: p_data => l_msg_data ) ;
286: FOR i IN 1..l_msg_count
287: LOOP
288: FND_MSG_PUB.Get( p_msg_index => i ,
289: p_encoded => FND_API.G_FALSE ,
290: p_data => l_msg_data ,
291: p_msg_index_out => l_msg_count
292: );

Line 338: FND_MSG_PUB.initialize ;

334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
335: END IF ;
336: --
337: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
338: FND_MSG_PUB.initialize ;
339: END IF ;
340: x_return_status := FND_API.G_RET_STS_SUCCESS ;
341:
342: FND_FILE.Put_Line( FND_FILE.LOG, 'The following is the parameter list:') ;

Line 415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

411: IF FND_API.To_Boolean ( p_commit ) THEN
412: COMMIT WORK ;
413: END IF ;
414: --
415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
416: p_data => x_msg_data ) ;
417: EXCEPTION
418:
419: WHEN OTHERS THEN

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

418:
419: WHEN OTHERS THEN
420: --
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
423: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
424: l_api_name) ;
425: END IF ;
426: --

Line 423: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

419: WHEN OTHERS THEN
420: --
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
423: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
424: l_api_name) ;
425: END IF ;
426: --
427: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 427: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

423: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
424: l_api_name) ;
425: END IF ;
426: --
427: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
428: p_data => x_msg_data ) ;
429: END Refresh_MV;
430: /*---------------------------------------------------------------------------*/
431: