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

Line 62: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

58: -- Standard Start of API savepoint
59: SAVEPOINT CREATE_Request_History_PVT;
60:
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
63: p_api_version_number,
64: l_api_name,
65: G_PKG_NAME)
66: THEN

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: p_api_version_number,
64: l_api_name,
65: G_PKG_NAME)
66: THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF FND_API.to_Boolean( p_init_msg_list )

Line 71: IF FND_API.to_Boolean( p_init_msg_list )

67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF FND_API.to_Boolean( p_init_msg_list )
72: THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: --JTF_FM_REQUEST_GRP.PRINT_MESSAGE('Private API: ' || l_api_name || 'start');
78:
79:
80: -- Initialize API return status to SUCCESS
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: -- Local variable initialization
84:
85: IF p_request_history_rec.HIST_REQ_ID IS NULL OR p_request_history_rec.HIST_REQ_ID = FND_API.g_miss_num THEN

Line 85: IF p_request_history_rec.HIST_REQ_ID IS NULL OR p_request_history_rec.HIST_REQ_ID = FND_API.g_miss_num THEN

81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: -- Local variable initialization
84:
85: IF p_request_history_rec.HIST_REQ_ID IS NULL OR p_request_history_rec.HIST_REQ_ID = FND_API.g_miss_num THEN
86: LOOP
87: l_dummy := NULL;
88: OPEN c_id;
89: FETCH c_id INTO l_REQUEST_HISTORY_ID;

Line 109: RAISE FND_API.G_EXC_ERROR;

105:
106: IF FND_GLOBAL.User_Id IS NULL
107: THEN
108: --AMF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111:
112:
113:

Line 184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

180: );
181:
182: x_request_history_id := l_request_history_id ;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: --
188: -- End of API body

Line 185: RAISE FND_API.G_EXC_ERROR;

181:
182: x_request_history_id := l_request_history_id ;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: --
188: -- End of API body
189: --

Line 192: IF FND_API.to_Boolean( p_commit )

188: -- End of API body
189: --
190:
191: -- Standard check for p_commit
192: IF FND_API.to_Boolean( p_commit )
193: THEN
194: COMMIT WORK;
195: END IF;
196:

Line 209: WHEN FND_API.G_EXC_ERROR THEN

205: );
206: EXCEPTION
207:
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Request_History_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207:
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Request_History_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,

Line 214: p_encoded => FND_API.G_FALSE,

210: ROLLBACK TO CREATE_Request_History_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data
217: );
218:

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

215: p_count => x_msg_count,
216: p_data => x_msg_data
217: );
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO CREATE_Request_History_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: );
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO CREATE_Request_History_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,

Line 224: p_encoded => FND_API.G_FALSE,

220: ROLLBACK TO CREATE_Request_History_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
227: );
228:

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

227: );
228:
229: WHEN OTHERS THEN
230: ROLLBACK TO CREATE_Request_History_PVT;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;

Line 238: p_encoded => FND_API.G_FALSE,

234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data
241: );
242: End Create_Request_History;