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

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

23:
24: -- Hint: Primary key needs to be returned.
25: PROCEDURE Create_Fnd_Attachment(
26: p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: x_return_status OUT NOCOPY VARCHAR2,

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

24: -- Hint: Primary key needs to be returned.
25: PROCEDURE Create_Fnd_Attachment(
26: p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,

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

25: PROCEDURE Create_Fnd_Attachment(
26: p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,

Line 67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Fnd_Attachment_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
68: p_api_version_number,
69: l_api_name,
70: G_PKG_NAME)
71: THEN

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

68: p_api_version_number,
69: l_api_name,
70: G_PKG_NAME)
71: THEN
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )

Line 76: IF FND_API.to_Boolean( p_init_msg_list )

72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )
77: THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: END IF;
85:
86:
87: -- Initialize API return status to SUCCESS
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: -- Local variable initialization
91:
92: -- =========================================================================

Line 99: RAISE FND_API.G_EXC_ERROR;

95:
96: IF FND_GLOBAL.User_Id IS NULL
97: THEN
98: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: -- Debug Message
103: IF (AMW_DEBUG_HIGH_ON) THEN

Line 145: Update fnd_documents_tl because FND_API inserts newly generated

141: p_Fnd_Attachment_rec.short_text
142: );
143: else
144: /*
145: Update fnd_documents_tl because FND_API inserts newly generated
146: media_id into that table.
147: */
148: update fnd_documents_tl
149: set media_id = p_Fnd_Attachment_rec.media_id

Line 246: IF FND_API.to_Boolean( p_commit )

242: end if;
243:
244:
245: -- Standard check for p_commit
246: IF FND_API.to_Boolean( p_commit )
247: THEN
248: COMMIT WORK;
249: END IF;
250:

Line 267: x_return_status := FND_API.g_ret_sts_error;

263:
264: EXCEPTION
265:
266: WHEN AMW_Utility_PVT.resource_locked THEN
267: x_return_status := FND_API.g_ret_sts_error;
268: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;

Line 270: WHEN FND_API.G_EXC_ERROR THEN

266: WHEN AMW_Utility_PVT.resource_locked THEN
267: x_return_status := FND_API.g_ret_sts_error;
268: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

268: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,

Line 275: p_encoded => FND_API.G_FALSE,

271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279:

Line 280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: );
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,

Line 285: p_encoded => FND_API.G_FALSE,

281: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289:

Line 292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

288: );
289:
290: WHEN OTHERS THEN
291: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
294: THEN
295: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
296: END IF;

Line 299: p_encoded => FND_API.G_FALSE,

295: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
296: END IF;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: End Create_Fnd_Attachment;