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_MSG_PUB

Line 66: l_count := FND_MSG_PUB.Count_Msg;

62: l_msg_index_out NUMBER := 0;
63: j NUMBER;
64: BEGIN
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,

Line 68: FND_MSG_PUB.Get(p_msg_index => l_count,

64: BEGIN
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;

Line 138: FND_MSG_PUB.initialize;

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
142: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');

Line 141: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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
142: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
143: FND_MESSAGE.Set_Token('ARG1', l_full_name||': Start');
144: FND_MSG_PUB.Add;
145: END IF;

Line 144: FND_MSG_PUB.Add;

140:
141: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
142: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
143: FND_MESSAGE.Set_Token('ARG1', l_full_name||': Start');
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;

Line 163: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

159: FETCH VALIDATE_CONTENT INTO l_content_id;
160: IF (VALIDATE_CONTENT%NOTFOUND)
161: THEN
162: l_Error_Msg := p_content_id || ' is not a valid content_id';
163: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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;

Line 166: FND_MSG_PUB.Add;

162: l_Error_Msg := p_content_id || ' is not a valid content_id';
163: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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:

Line 178: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

174: FETCH VALIDATE_QUERY INTO l_query_id;
175: IF (VALIDATE_QUERY%NOTFOUND)
176: THEN
177: l_Error_Msg := p_query_id || ' is not a valid query_id';
178: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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;

Line 181: FND_MSG_PUB.Add;

177: l_Error_Msg := p_query_id || ' is not a valid query_id';
178: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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:

Line 210: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

206: ELSE
207: l_Error_Msg := 'A Link already exists between content_id ';
208: l_Error_Msg := l_Error_Msg || p_content_id || ' and query_id ';
209: l_Error_Msg := l_Error_Msg || p_query_id;
210: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
211: FND_MESSAGE.Set_NAme('JTF', 'JTF_FM_API_CONT_QRY_LNK_EXISTS');
212: FND_MESSAGE.Set_Token('ARG1', p_content_id);
213: FND_MESSAGE.Set_Token('ARG2', p_query_id);
214: FND_MSG_PUB.Add;

Line 214: FND_MSG_PUB.Add;

210: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
211: FND_MESSAGE.Set_NAme('JTF', 'JTF_FM_API_CONT_QRY_LNK_EXISTS');
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:

Line 232: FND_MSG_PUB.count_and_get(

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,
234: p_count => x_msg_count,
235: p_data => x_msg_data
236: );

Line 243: FND_MSG_PUB.count_and_get(

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,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );

Line 253: IF FND_MSG_PUB.Check_Msg_Level

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
256: FND_MSG_PUB.Add_Exc_Msg
257: (G_PKG_NAME, l_api_name);

Line 254: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
256: FND_MSG_PUB.Add_Exc_Msg
257: (G_PKG_NAME, l_api_name);
258: END IF;

Line 256: FND_MSG_PUB.Add_Exc_Msg

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
256: FND_MSG_PUB.Add_Exc_Msg
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(

Line 260: FND_MSG_PUB.count_and_get(

256: FND_MSG_PUB.Add_Exc_Msg
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: );

Line 331: FND_MSG_PUB.initialize;

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
335: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');

Line 334: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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
335: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
336: FND_MESSAGE.Set_Token('ARG1', l_full_name||': Start');
337: FND_MSG_PUB.Add;
338: END IF;

Line 337: FND_MSG_PUB.Add;

333:
334: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
335: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_DEBUG_MESSAGE');
336: FND_MESSAGE.Set_Token('ARG1', l_full_name||': Start');
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;

Line 375: FND_MSG_PUB.count_and_get(

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,
377: p_count => x_msg_count,
378: p_data => x_msg_data
379: );

Line 386: FND_MSG_PUB.count_and_get(

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,
388: p_count => x_msg_count,
389: p_data => x_msg_data
390: );

Line 396: IF FND_MSG_PUB.Check_Msg_Level

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
399: FND_MSG_PUB.Add_Exc_Msg
400: (G_PKG_NAME, l_api_name);

Line 397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
399: FND_MSG_PUB.Add_Exc_Msg
400: (G_PKG_NAME, l_api_name);
401: END IF;

Line 399: FND_MSG_PUB.Add_Exc_Msg

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
399: FND_MSG_PUB.Add_Exc_Msg
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(

Line 403: FND_MSG_PUB.count_and_get(

399: FND_MSG_PUB.Add_Exc_Msg
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: );