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.FPA_UTILITIES_PVT dependencies on FPA_UTILITIES_PVT

Line 1: package body FPA_Utilities_PVT as

1: package body FPA_Utilities_PVT as
2: /* $Header: FPAVUTLB.pls 120.1 2005/08/18 11:03:53 appldev ship $ */
3:
4: g_aw_space_name VARCHAR2(30) := fpa_global_pvt.aw_space_name;
5:

Line 28: 'fpa.sql.fpa_utilities_pvt.attach_aw.begin',

24: begin
25:
26: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
27: fnd_log.string (FND_LOG.LEVEL_PROCEDURE,
28: 'fpa.sql.fpa_utilities_pvt.attach_aw.begin',
29: 'Entering fpa_utilities_pvt.attach_aw');
30: END IF;
31:
32: -- Attach the AW space read write.

Line 29: 'Entering fpa_utilities_pvt.attach_aw');

25:
26: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
27: fnd_log.string (FND_LOG.LEVEL_PROCEDURE,
28: 'fpa.sql.fpa_utilities_pvt.attach_aw.begin',
29: 'Entering fpa_utilities_pvt.attach_aw');
30: END IF;
31:
32: -- Attach the AW space read write.
33: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 35: 'fpa.sql.fpa_utilities_pvt.attach_aw',

31:
32: -- Attach the AW space read write.
33: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
34: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
35: 'fpa.sql.fpa_utilities_pvt.attach_aw',
36: 'Attaching OLAP workspace: ' || g_aw_space_name);
37: END IF;
38:
39: -- dbms_aw.execute('AW ATTACH ' || g_aw_space_name || ' RW FIRST WAIT');

Line 44: 'fpa.sql.fpa_utilities_pvt.attach_aw.end',

40: dbms_aw.execute('AW ATTACH ' || g_aw_space_name || ' ' || p_attach_mode || ' FIRST WAIT');
41:
42: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
43: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
44: 'fpa.sql.fpa_utilities_pvt.attach_aw.end',
45: 'Exiting fpa_utilities_pvt.attach_aw');
46: END IF;
47:
48: EXCEPTION

Line 45: 'Exiting fpa_utilities_pvt.attach_aw');

41:
42: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
43: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
44: 'fpa.sql.fpa_utilities_pvt.attach_aw.end',
45: 'Exiting fpa_utilities_pvt.attach_aw');
46: END IF;
47:
48: EXCEPTION
49: WHEN FND_API.G_EXC_ERROR THEN

Line 89: 'fpa.sql.fpa_utilities_pvt.detach_aw.begin',

85: begin
86:
87: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
88: fnd_log.string (FND_LOG.LEVEL_PROCEDURE,
89: 'fpa.sql.fpa_utilities_pvt.detach_aw.begin',
90: 'Entering fpa_utilities_pvt.detach_aw');
91: END IF;
92:
93: -- Detach the AW space.

Line 90: 'Entering fpa_utilities_pvt.detach_aw');

86:
87: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
88: fnd_log.string (FND_LOG.LEVEL_PROCEDURE,
89: 'fpa.sql.fpa_utilities_pvt.detach_aw.begin',
90: 'Entering fpa_utilities_pvt.detach_aw');
91: END IF;
92:
93: -- Detach the AW space.
94: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 96: 'fpa.sql.fpa_utilities_pvt.detach_aw',

92:
93: -- Detach the AW space.
94: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
95: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
96: 'fpa.sql.fpa_utilities_pvt.detach_aw',
97: 'Detaching OLAP workspace: ' || g_aw_space_name);
98: END IF;
99:
100: dbms_aw.execute('AW DETACH ' || g_aw_space_name);

Line 104: 'fpa.sql.fpa_utilities_pvt.detach_aw.end',

100: dbms_aw.execute('AW DETACH ' || g_aw_space_name);
101:
102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
104: 'fpa.sql.fpa_utilities_pvt.detach_aw.end',
105: 'Exiting fpa_utilities_pvt.detach_aw');
106: END IF;
107:
108:

Line 105: 'Exiting fpa_utilities_pvt.detach_aw');

101:
102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
104: 'fpa.sql.fpa_utilities_pvt.detach_aw.end',
105: 'Exiting fpa_utilities_pvt.detach_aw');
106: END IF;
107:
108:
109: EXCEPTION

Line 281: --G_MSG_LEVEL_THRESHOLD CONSTANT NUMBER := FPA_UTILITIES_PVT.G_MISS_NUM;

277:
278:
279: -- MESSAGE CONSTANTS
280:
281: --G_MSG_LEVEL_THRESHOLD CONSTANT NUMBER := FPA_UTILITIES_PVT.G_MISS_NUM;
282: --------------------------------------------------------------------------------
283: -- PROCEDURE init_msg_list
284: --------------------------------------------------------------------------------
285: PROCEDURE init_msg_list (

Line 294: RAISE FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

290: FND_MSG_PUB.initialize;
291: END IF;
292: EXCEPTION
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: RAISE FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
295: END init_msg_list;
296: --------------------------------------------------------------------------------
297: -- FUNCTION start_activity
298: --------------------------------------------------------------------------------

Line 317: FPA_UTILITIES_PVT.init_msg_list(p_init_msg_list);

313: FND_LOG.LEVEL_PROCEDURE,
314: 'fpa.sql.'||p_pkg_name||p_api_name,
315: p_msg_log);
316: END IF;
317: FPA_UTILITIES_PVT.init_msg_list(p_init_msg_list);
318: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
319: RETURN(FPA_UTILITIES_PVT.G_RET_STS_SUCCESS);
320: END start_activity;
321:

Line 318: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

314: 'fpa.sql.'||p_pkg_name||p_api_name,
315: p_msg_log);
316: END IF;
317: FPA_UTILITIES_PVT.init_msg_list(p_init_msg_list);
318: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
319: RETURN(FPA_UTILITIES_PVT.G_RET_STS_SUCCESS);
320: END start_activity;
321:
322: PROCEDURE start_activity(

Line 319: RETURN(FPA_UTILITIES_PVT.G_RET_STS_SUCCESS);

315: p_msg_log);
316: END IF;
317: FPA_UTILITIES_PVT.init_msg_list(p_init_msg_list);
318: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
319: RETURN(FPA_UTILITIES_PVT.G_RET_STS_SUCCESS);
320: END start_activity;
321:
322: PROCEDURE start_activity(
323: p_api_name IN VARCHAR2,

Line 336: FPA_UTILITIES_PVT.init_msg_list(p_init_msg_list);

332: FND_LOG.LEVEL_PROCEDURE,
333: 'fpa.sql.'||p_pkg_name||p_api_name,
334: p_msg_log);
335: END IF;
336: FPA_UTILITIES_PVT.init_msg_list(p_init_msg_list);
337: END start_activity;
338: --------------------------------------------------------------------------------
339: -- FUNCTION handle_exceptions
340: --------------------------------------------------------------------------------

Line 350: l_return_value VARCHAR2(200) := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;

346: x_msg_count OUT NOCOPY NUMBER,
347: x_msg_data OUT NOCOPY VARCHAR2,
348: p_api_type IN VARCHAR2
349: ) RETURN VARCHAR2 IS
350: l_return_value VARCHAR2(200) := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;
351: BEGIN
352: IF p_exc_name = 'FPA_UTILITIES_PVT.G_RET_STS_ERROR' THEN
353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
354: FND_LOG.String(

Line 352: IF p_exc_name = 'FPA_UTILITIES_PVT.G_RET_STS_ERROR' THEN

348: p_api_type IN VARCHAR2
349: ) RETURN VARCHAR2 IS
350: l_return_value VARCHAR2(200) := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;
351: BEGIN
352: IF p_exc_name = 'FPA_UTILITIES_PVT.G_RET_STS_ERROR' THEN
353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
354: FND_LOG.String(
355: FND_LOG.LEVEL_PROCEDURE,
356: 'fpa.sql.'||p_pkg_name||p_api_name,

Line 359: l_return_value := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

355: FND_LOG.LEVEL_PROCEDURE,
356: 'fpa.sql.'||p_pkg_name||p_api_name,
357: p_exc_name||p_msg_log);
358: END IF;
359: l_return_value := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
360: ELSIF p_exc_name = 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR' THEN
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.String(
363: FND_LOG.LEVEL_PROCEDURE,

Line 360: ELSIF p_exc_name = 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR' THEN

356: 'fpa.sql.'||p_pkg_name||p_api_name,
357: p_exc_name||p_msg_log);
358: END IF;
359: l_return_value := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
360: ELSIF p_exc_name = 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR' THEN
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.String(
363: FND_LOG.LEVEL_PROCEDURE,
364: 'fpa.sql.'||p_pkg_name||p_api_name,

Line 429: FND_MESSAGE.SET_NAME( FPA_UTILITIES_PVT.G_APP_NAME, P_MSG_NAME);

425: p_token10 IN VARCHAR2,
426: p_token10_value IN VARCHAR2
427: ) IS
428: BEGIN
429: FND_MESSAGE.SET_NAME( FPA_UTILITIES_PVT.G_APP_NAME, P_MSG_NAME);
430: IF (p_token1 IS NOT NULL) AND (p_token1_value IS NOT NULL) THEN
431: FND_MESSAGE.SET_TOKEN( TOKEN => p_token1,
432: VALUE => p_token1_value);
433: END IF;

Line 476: end FPA_Utilities_PVT;

472:
473: /****END: Section for common API messages, exception handling and logging.******
474: ********************************************************************************/
475:
476: end FPA_Utilities_PVT;