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.AHL_UC_UTILIZATION_PUB dependencies on FND_API

Line 21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

17: -- Pre-reqs :
18: -- Parameters :
19: -- Standard IN Parameters :
20: -- p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
24: --
25: -- Standard OUT Parameters :

Line 22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

18: -- Parameters :
19: -- Standard IN Parameters :
20: -- p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
24: --
25: -- Standard OUT Parameters :
26: -- x_return_status OUT VARCHAR2 Required

Line 23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

19: -- Standard IN Parameters :
20: -- p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
24: --
25: -- Standard OUT Parameters :
26: -- x_return_status OUT VARCHAR2 Required
27: -- x_msg_count OUT NUMBER Required

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

53: -- End of Comments --
54:
55:
56: PROCEDURE Update_Utilization(p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_Utilization_tbl IN AHL_UC_Utilization_PVT.Utilization_Tbl_Type,
61: x_return_status OUT NOCOPY VARCHAR2,

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

54:
55:
56: PROCEDURE Update_Utilization(p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_Utilization_tbl IN AHL_UC_Utilization_PVT.Utilization_Tbl_Type,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,

Line 59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

55:
56: PROCEDURE Update_Utilization(p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_Utilization_tbl IN AHL_UC_Utilization_PVT.Utilization_Tbl_Type,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 73: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

69:
70: -- Standard start of API savepoint
71: SAVEPOINT Update_Utilization_Pub;
72: -- Standard call to check for call compatibility
73: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
74: G_PKG_NAME) THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:

Line 75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

71: SAVEPOINT Update_Utilization_Pub;
72: -- Standard call to check for call compatibility
73: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
74: G_PKG_NAME) THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 79: IF FND_API.To_Boolean(p_init_msg_list) THEN

75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.To_Boolean(p_init_msg_list) THEN
80: FND_MSG_PUB.Initialize;
81: END IF;
82:
83: -- Initialize Procedure return status to success

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: FND_MSG_PUB.Initialize;
81: END IF;
82:
83: -- Initialize Procedure return status to success
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: -- Call Private API.
87: AHL_UC_UTILIZATION_PVT.Update_Utilization(
88: p_api_version => 1.0,

Line 95: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

91: x_msg_count => x_msg_count,
92: x_msg_data => x_msg_data);
93:
94: -- Raise errors if exceptions occur
95: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;

Line 96: RAISE FND_API.G_EXC_ERROR;

92: x_msg_data => x_msg_data);
93:
94: -- Raise errors if exceptions occur
95: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:

Line 97: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

93:
94: -- Raise errors if exceptions occur
95: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: -- Standard check of p_commit

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: -- Raise errors if exceptions occur
95: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
96: RAISE FND_API.G_EXC_ERROR;
97: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: -- Standard check of p_commit
102: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 102: IF FND_API.TO_BOOLEAN(p_commit) THEN

98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: -- Standard check of p_commit
102: IF FND_API.TO_BOOLEAN(p_commit) THEN
103: COMMIT WORK;
104: END IF;
105:
106: -- Standard call to get message count and if count is 1, get message info

Line 110: p_encoded => fnd_api.g_false);

106: -- Standard call to get message count and if count is 1, get message info
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,
109: p_data => x_msg_data,
110: p_encoded => fnd_api.g_false);
111:
112:
113:
114: --

Line 116: WHEN FND_API.G_EXC_ERROR THEN

112:
113:
114: --
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_ERROR;
118: Rollback to Update_Utilization_Pub;
119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
120: p_data => x_msg_data,

Line 117: x_return_status := FND_API.G_RET_STS_ERROR;

113:
114: --
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_ERROR;
118: Rollback to Update_Utilization_Pub;
119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
120: p_data => x_msg_data,
121: p_encoded => fnd_api.g_false);

Line 121: p_encoded => fnd_api.g_false);

117: x_return_status := FND_API.G_RET_STS_ERROR;
118: Rollback to Update_Utilization_Pub;
119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
120: p_data => x_msg_data,
121: p_encoded => fnd_api.g_false);
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125: Rollback to Update_Utilization_Pub;

Line 123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
120: p_data => x_msg_data,
121: p_encoded => fnd_api.g_false);
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125: Rollback to Update_Utilization_Pub;
126: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
127: p_data => x_msg_data,

Line 124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

120: p_data => x_msg_data,
121: p_encoded => fnd_api.g_false);
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125: Rollback to Update_Utilization_Pub;
126: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
127: p_data => x_msg_data,
128: p_encoded => fnd_api.g_false);

Line 128: p_encoded => fnd_api.g_false);

124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125: Rollback to Update_Utilization_Pub;
126: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
127: p_data => x_msg_data,
128: p_encoded => fnd_api.g_false);
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: Rollback to Update_Utilization_Pub;

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

127: p_data => x_msg_data,
128: p_encoded => fnd_api.g_false);
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: Rollback to Update_Utilization_Pub;
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
135: p_procedure_name => 'Update_Utilization',

Line 140: p_encoded => fnd_api.g_false);

136: p_error_text => SUBSTR(SQLERRM,1,240));
137: END IF;
138: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
139: p_data => x_msg_data,
140: p_encoded => fnd_api.g_false);
141:
142: END Update_Utilization;
143:
144: END AHL_UC_Utilization_PUB;