APPS.JTF_FM_QUERY_LINK_PKG dependencies on STANDARD

Line 124: -- Standard begin of API savepoint

120: where query_id = p_query_id
121: and mes_doc_id = p_content_id;
122:
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,

Line 220: --Standard check of commit

216: RAISE FND_API.G_EXC_ERROR;
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:

Line 231: -- Standard call to get message count and if count=1, get the message

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

Line 242: -- Standard call to get message count and if count=1, get the message

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

Line 259: -- Standard call to get message count and if count=1, get the message

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(
261: p_encoded => FND_API.g_false,
262: p_count => x_msg_count,
263: p_data => x_msg_data

Line 317: -- Standard begin of API savepoint

313: where query_id = p_query_id
314: and mes_doc_id = p_content_id;
315:
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,

Line 363: --Standard check of commit

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

Line 374: -- Standard call to get message count and if count=1, get the message

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

Line 385: -- Standard call to get message count and if count=1, get the message

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

Line 402: -- Standard call to get message count and if count=1, get the message

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(
404: p_encoded => FND_API.g_false,
405: p_count => x_msg_count,
406: p_data => x_msg_data