eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_MV_REFRESH_PVT dependencies on FND_API

Line 30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

26: -- API to register an MV.
27: PROCEDURE Register_MV
28: (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,

Line 31: p_commit IN VARCHAR2 := FND_API.G_FALSE,

27: PROCEDURE Register_MV
28: (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: --

Line 62: IF NOT FND_API.Compatible_API_Call ( l_api_version,

58:
59: BEGIN
60:
61: SAVEPOINT Register_MV_Pvt ;
62: IF NOT FND_API.Compatible_API_Call ( l_api_version,
63: p_api_version,
64: l_api_name,
65: G_PKG_NAME )
66: THEN

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

63: p_api_version,
64: l_api_name,
65: G_PKG_NAME )
66: THEN
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 ;

Line 70: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

66: THEN
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:

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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: --
76: -- Validate input parameters. Note we do not validate if the base table
77: -- is indeed being used by the MV or not.

Line 87: RAISE FND_API.G_EXC_ERROR;

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' ;
91: OPEN l_object_exists_csr ( p_base_table_name , 'SYNONYM' ) ;

Line 98: RAISE FND_API.G_EXC_ERROR;

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.
102: --

Line 139: IF FND_API.To_Boolean ( p_commit ) THEN

135: g_sys_date ,
136: g_user_id
137: ) ;
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 ) ;

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

145:
146: WHEN OTHERS 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) ;

Line 169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

165: -- API to unregister an MV.
166: PROCEDURE Unregister_MV
167: (
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,

Line 170: p_commit IN VARCHAR2 := FND_API.G_FALSE,

166: PROCEDURE Unregister_MV
167: (
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: --

Line 188: IF NOT FND_API.Compatible_API_Call ( l_api_version,

184:
185: BEGIN
186:
187: SAVEPOINT Unregister_MV_Pvt ;
188: IF NOT FND_API.Compatible_API_Call ( l_api_version,
189: p_api_version,
190: l_api_name,
191: G_PKG_NAME )
192: THEN

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

189: p_api_version,
190: l_api_name,
191: G_PKG_NAME )
192: THEN
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 ;

Line 196: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

192: THEN
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:

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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.
202: DELETE fem_mv_refresh_objects
203: WHERE mv_name = p_mv_name ;

Line 208: RAISE FND_API.G_EXC_ERROR;

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
212: COMMIT WORK ;

Line 211: IF FND_API.To_Boolean ( p_commit ) THEN

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
212: COMMIT WORK ;
213: END IF ;
214: --
215: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

218:
219: WHEN OTHERS 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) ;

Line 259: p_init_msg_list => FND_API.G_TRUE,

255: retcode := 2 ;
256: FEM_MV_Refresh_Pvt.Refresh_MV
257: (
258: p_api_version => 1.0,
259: p_init_msg_list => FND_API.G_TRUE,
260: p_commit => FND_API.G_FALSE,
261: x_return_status => l_return_status,
262: x_msg_count => l_msg_count,
263: x_msg_data => l_msg_data,

Line 260: p_commit => FND_API.G_FALSE,

256: FEM_MV_Refresh_Pvt.Refresh_MV
257: (
258: p_api_version => 1.0,
259: p_init_msg_list => FND_API.G_TRUE,
260: p_commit => FND_API.G_FALSE,
261: x_return_status => l_return_status,
262: x_msg_count => l_msg_count,
263: x_msg_data => l_msg_data,
264: --

Line 268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

264: --
265: p_base_table_name => p_base_table_name
266: ) ;
267: --
268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
269: RAISE FND_API.G_EXC_ERROR;
270: END IF ;
271:
272: retcode := 0 ;

Line 269: RAISE FND_API.G_EXC_ERROR;

265: p_base_table_name => p_base_table_name
266: ) ;
267: --
268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
269: RAISE FND_API.G_EXC_ERROR;
270: END IF ;
271:
272: retcode := 0 ;
273: COMMIT WORK ;

Line 289: p_encoded => FND_API.G_FALSE ,

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: );
293: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_msg_data ) ;

Line 307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

303: -- API to refresh MVs.
304: PROCEDURE Refresh_MV
305: (
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,

Line 308: p_commit IN VARCHAR2 := FND_API.G_FALSE,

304: PROCEDURE Refresh_MV
305: (
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
312: --

Line 329: IF NOT FND_API.Compatible_API_Call ( l_api_version,

325:
326: BEGIN
327:
328: -- No savepoints applicable as refresh seems to perform an implicit commit.
329: IF NOT FND_API.Compatible_API_Call ( l_api_version,
330: p_api_version,
331: l_api_name,
332: G_PKG_NAME )
333: THEN

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

330: p_api_version,
331: l_api_name,
332: G_PKG_NAME )
333: THEN
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 ;

Line 337: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

333: THEN
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:

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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:') ;
343: FND_FILE.Put_Line( FND_FILE.LOG, 'p_base_table_name: ' || p_base_table_name );
344:

Line 411: IF FND_API.To_Boolean ( p_commit ) THEN

407: ) ;
408:
409: END IF ;
410:
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,

Line 421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

417: EXCEPTION
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 ;