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_FM_QUERY_LINK_PKG dependencies on FND_API

Line 6: G_VALID_LEVEL_LOGIN CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;

2: /* $Header: jtffmgqb.pls 120.0 2005/05/11 08:14:18 appldev ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_FM_QUERY_LINK_PKG';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtffmgqb.pls';
5: --
6: G_VALID_LEVEL_LOGIN CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
7: --
8: ----------------------------- Private Portion ---------------------------------
9: --------------------------------------------------------------------------------
10: -- We use the following private utility procedures

Line 69: p_encoded => FND_API.G_FALSE,

65: x_msg_data := NULL;
66: l_count := FND_MSG_PUB.Count_Msg;
67: IF l_count > 0 THEN
68: FND_MSG_PUB.Get(p_msg_index => l_count,
69: p_encoded => FND_API.G_FALSE,
70: p_data => x_msg_data,
71: p_msg_index_out => l_msg_index_out);
72: END IF;
73: END Get_Error_Message;

Line 86: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

82:
83: PROCEDURE Link_Content_To_Query
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,

Line 87: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

83: PROCEDURE Link_Content_To_Query
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,

Line 88: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_content_id IN NUMBER,

Line 127: IF NOT FND_API.Compatible_API_Call (

123: BEGIN
124: -- Standard begin of API savepoint
125: SAVEPOINT LINK_CONTENT;
126:
127: IF NOT FND_API.Compatible_API_Call (
128: l_api_version,
129: p_api_version,
130: l_api_name,
131: G_PKG_NAME)

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: p_api_version,
130: l_api_name,
131: G_PKG_NAME)
132: THEN
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135:
136: --Initialize message list if p_init_msg_list is TRUE.
137: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 137: IF FND_API.To_Boolean (p_init_msg_list) THEN

133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135:
136: --Initialize message list if p_init_msg_list is TRUE.
137: IF FND_API.To_Boolean (p_init_msg_list) THEN
138: FND_MSG_PUB.initialize;
139: END IF;
140:
141: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144: FND_MSG_PUB.Add;
145: END IF;
146:
147: -- Initialize API return status to success
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: PRINT_MESSAGE('Link_Content_to_Query called by ' || to_number(FND_GLOBAL.USER_ID));
151:
152:

Line 168: RAISE FND_API.G_EXC_ERROR;

164: FND_MESSAGE.Set_NAme('JTF', 'JTF_FM_API_CONTENT_INVALID');
165: FND_MESSAGE.Set_Token('ARG1', p_content_id);
166: FND_MSG_PUB.Add;
167: END IF;
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171: CLOSE VALIDATE_CONTENT;
172:

Line 183: RAISE FND_API.G_EXC_ERROR;

179: FND_MESSAGE.Set_NAme('JTF', 'JTF_FM_API_QUERY_INVALID');
180: FND_MESSAGE.Set_Token('ARG1', p_query_id);
181: FND_MSG_PUB.Add;
182: END IF;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: CLOSE VALIDATE_QUERY;
187:

Line 216: RAISE FND_API.G_EXC_ERROR;

212: FND_MESSAGE.Set_Token('ARG1', p_content_id);
213: FND_MESSAGE.Set_Token('ARG2', p_query_id);
214: FND_MSG_PUB.Add;
215: END IF;
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: CLOSE VALIDATE_UNIQUE;
220: --Standard check of commit

Line 221: IF FND_API.To_Boolean ( p_commit ) THEN

217: END IF;
218:
219: CLOSE VALIDATE_UNIQUE;
220: --Standard check of commit
221: IF FND_API.To_Boolean ( p_commit ) THEN
222: COMMIT WORK;
223: END IF;
224:
225:

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

223: END IF;
224:
225:
226: EXCEPTION
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO LINK_CONTENT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: Add_Error_Message (l_api_name, l_Error_Msg);
231: -- Standard call to get message count and if count=1, get the message

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225:
226: EXCEPTION
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO LINK_CONTENT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: Add_Error_Message (l_api_name, l_Error_Msg);
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.count_and_get(
233: p_encoded => FND_API.g_false,

Line 233: p_encoded => FND_API.g_false,

229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: Add_Error_Message (l_api_name, l_Error_Msg);
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.count_and_get(
233: p_encoded => FND_API.g_false,
234: p_count => x_msg_count,
235: p_data => x_msg_data
236: );
237: Get_Error_Message(x_msg_data);

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234: p_count => x_msg_count,
235: p_data => x_msg_data
236: );
237: Get_Error_Message(x_msg_data);
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO LINK_CONTENT;
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: Add_Error_Message (l_api_name, l_Error_Msg);
242: -- Standard call to get message count and if count=1, get the message

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236: );
237: Get_Error_Message(x_msg_data);
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO LINK_CONTENT;
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: Add_Error_Message (l_api_name, l_Error_Msg);
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.count_and_get(
244: p_encoded => FND_API.g_false,

Line 244: p_encoded => FND_API.g_false,

240: x_return_status := FND_API.G_RET_STS_ERROR;
241: Add_Error_Message (l_api_name, l_Error_Msg);
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.count_and_get(
244: p_encoded => FND_API.g_false,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: Get_Error_Message(x_msg_data);

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: );
248: Get_Error_Message(x_msg_data);
249: WHEN OTHERS THEN
250: ROLLBACK TO LINK_CONTENT;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: Add_Error_Message (l_api_name, SQLERRM);
253: IF FND_MSG_PUB.Check_Msg_Level
254: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN

Line 261: p_encoded => FND_API.g_false,

257: (G_PKG_NAME, l_api_name);
258: END IF;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.count_and_get(
261: p_encoded => FND_API.g_false,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265: Get_Error_Message(x_msg_data);

Line 279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

275:
276: PROCEDURE UnLink_Content_To_Query
277: (
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,

Line 280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

276: PROCEDURE UnLink_Content_To_Query
277: (
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,

Line 281: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

277: (
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: p_content_id IN NUMBER,

Line 320: IF NOT FND_API.Compatible_API_Call (

316: BEGIN
317: -- Standard begin of API savepoint
318: SAVEPOINT UNLINK_CONTENT;
319:
320: IF NOT FND_API.Compatible_API_Call (
321: l_api_version,
322: p_api_version,
323: l_api_name,
324: G_PKG_NAME)

Line 326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

322: p_api_version,
323: l_api_name,
324: G_PKG_NAME)
325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: --Initialize message list if p_init_msg_list is TRUE.
330: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 330: IF FND_API.To_Boolean (p_init_msg_list) THEN

326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: --Initialize message list if p_init_msg_list is TRUE.
330: IF FND_API.To_Boolean (p_init_msg_list) THEN
331: FND_MSG_PUB.initialize;
332: END IF;
333:
334: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337: FND_MSG_PUB.Add;
338: END IF;
339:
340: -- Initialize API return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: PRINT_MESSAGE('Unlink_Content_to_query called by ' || to_number(FND_GLOBAL.USER_ID));
344:
345:

Line 364: IF FND_API.To_Boolean ( p_commit ) THEN

360:
361: CLOSE VALIDATE_UNIQUE;
362:
363: --Standard check of commit
364: IF FND_API.To_Boolean ( p_commit ) THEN
365: COMMIT WORK;
366: END IF;
367:
368:

Line 370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

366: END IF;
367:
368:
369: EXCEPTION
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: ROLLBACK TO UNLINK_CONTENT;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: Add_Error_Message (l_api_name, l_Error_Msg);
374: -- Standard call to get message count and if count=1, get the message

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368:
369: EXCEPTION
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: ROLLBACK TO UNLINK_CONTENT;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: Add_Error_Message (l_api_name, l_Error_Msg);
374: -- Standard call to get message count and if count=1, get the message
375: FND_MSG_PUB.count_and_get(
376: p_encoded => FND_API.g_false,

Line 376: p_encoded => FND_API.g_false,

372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: Add_Error_Message (l_api_name, l_Error_Msg);
374: -- Standard call to get message count and if count=1, get the message
375: FND_MSG_PUB.count_and_get(
376: p_encoded => FND_API.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data
379: );
380: Get_Error_Message(x_msg_data);

Line 381: WHEN FND_API.G_EXC_ERROR THEN

377: p_count => x_msg_count,
378: p_data => x_msg_data
379: );
380: Get_Error_Message(x_msg_data);
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO UNLINK_CONTENT;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: Add_Error_Message (l_api_name, l_Error_Msg);
385: -- Standard call to get message count and if count=1, get the message

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: );
380: Get_Error_Message(x_msg_data);
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO UNLINK_CONTENT;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: Add_Error_Message (l_api_name, l_Error_Msg);
385: -- Standard call to get message count and if count=1, get the message
386: FND_MSG_PUB.count_and_get(
387: p_encoded => FND_API.g_false,

Line 387: p_encoded => FND_API.g_false,

383: x_return_status := FND_API.G_RET_STS_ERROR;
384: Add_Error_Message (l_api_name, l_Error_Msg);
385: -- Standard call to get message count and if count=1, get the message
386: FND_MSG_PUB.count_and_get(
387: p_encoded => FND_API.g_false,
388: p_count => x_msg_count,
389: p_data => x_msg_data
390: );
391: Get_Error_Message(x_msg_data);

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

390: );
391: Get_Error_Message(x_msg_data);
392: WHEN OTHERS THEN
393: ROLLBACK TO UNLINK_CONTENT;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: Add_Error_Message (l_api_name, SQLERRM);
396: IF FND_MSG_PUB.Check_Msg_Level
397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN

Line 404: p_encoded => FND_API.g_false,

400: (G_PKG_NAME, l_api_name);
401: END IF;
402: -- Standard call to get message count and if count=1, get the message
403: FND_MSG_PUB.count_and_get(
404: p_encoded => FND_API.g_false,
405: p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408: Get_Error_Message(x_msg_data);