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 FND_LOG

Line 26: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

22: ) is
23:
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;

Line 27: fnd_log.string (FND_LOG.LEVEL_PROCEDURE,

23:
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:

Line 33: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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
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;

Line 34: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

30: END IF;
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:

Line 42: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

38:
39: -- dbms_aw.execute('AW ATTACH ' || g_aw_space_name || ' RW FIRST WAIT');
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;

Line 43: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

39: -- dbms_aw.execute('AW ATTACH ' || g_aw_space_name || ' RW FIRST WAIT');
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:

Line 87: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

83: ) is
84:
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;

Line 88: fnd_log.string (FND_LOG.LEVEL_PROCEDURE,

84:
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:

Line 94: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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
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;

Line 95: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

91: END IF;
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:

Line 102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

98: END IF;
99:
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;

Line 103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

99:
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:

Line 311: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

307: x_return_status OUT NOCOPY VARCHAR2
308: ) RETURN VARCHAR2 IS
309: BEGIN
310: IF (p_msg_log IS NOT NULL
311: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: FND_LOG.String(
313: FND_LOG.LEVEL_PROCEDURE,
314: 'fpa.sql.'||p_pkg_name||p_api_name,
315: p_msg_log);

Line 312: FND_LOG.String(

308: ) RETURN VARCHAR2 IS
309: BEGIN
310: IF (p_msg_log IS NOT NULL
311: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: FND_LOG.String(
313: FND_LOG.LEVEL_PROCEDURE,
314: 'fpa.sql.'||p_pkg_name||p_api_name,
315: p_msg_log);
316: END IF;

Line 313: FND_LOG.LEVEL_PROCEDURE,

309: BEGIN
310: IF (p_msg_log IS NOT NULL
311: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: FND_LOG.String(
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);

Line 330: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

326: p_msg_log IN VARCHAR2
327: ) IS
328: BEGIN
329: IF (p_msg_log IS NOT NULL
330: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.String(
332: FND_LOG.LEVEL_PROCEDURE,
333: 'fpa.sql.'||p_pkg_name||p_api_name,
334: p_msg_log);

Line 331: FND_LOG.String(

327: ) IS
328: BEGIN
329: IF (p_msg_log IS NOT NULL
330: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.String(
332: FND_LOG.LEVEL_PROCEDURE,
333: 'fpa.sql.'||p_pkg_name||p_api_name,
334: p_msg_log);
335: END IF;

Line 332: FND_LOG.LEVEL_PROCEDURE,

328: BEGIN
329: IF (p_msg_log IS NOT NULL
330: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.String(
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);

Line 353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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,
357: p_exc_name||p_msg_log);

Line 354: FND_LOG.String(

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,
357: p_exc_name||p_msg_log);
358: END IF;

Line 355: FND_LOG.LEVEL_PROCEDURE,

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,
357: p_exc_name||p_msg_log);
358: END IF;
359: l_return_value := FPA_UTILITIES_PVT.G_RET_STS_ERROR;

Line 361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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,
365: p_exc_name||p_msg_log);

Line 362: FND_LOG.String(

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,
365: p_exc_name||p_msg_log);
366: END IF;

Line 363: FND_LOG.LEVEL_PROCEDURE,

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,
365: p_exc_name||p_msg_log);
366: END IF;
367: ELSE -- WHEN OTHERS EXCEPTION

Line 390: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2) IS
388: BEGIN
389: IF (p_msg_log IS NOT NULL
390: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FND_LOG.String(
392: FND_LOG.LEVEL_PROCEDURE,
393: p_pkg_name||p_api_name,
394: p_msg_log);

Line 391: FND_LOG.String(

387: x_msg_data OUT NOCOPY VARCHAR2) IS
388: BEGIN
389: IF (p_msg_log IS NOT NULL
390: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FND_LOG.String(
392: FND_LOG.LEVEL_PROCEDURE,
393: p_pkg_name||p_api_name,
394: p_msg_log);
395: END IF;

Line 392: FND_LOG.LEVEL_PROCEDURE,

388: BEGIN
389: IF (p_msg_log IS NOT NULL
390: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FND_LOG.String(
392: FND_LOG.LEVEL_PROCEDURE,
393: p_pkg_name||p_api_name,
394: p_msg_log);
395: END IF;
396: --- Standard call to get message count and if count is 1, get message info