16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_Attachment_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'AMWvatcb.pls';
19:
20: AMW_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMW_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMW_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: -- Hint: Primary key needs to be returned.
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_Attachment_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'AMWvatcb.pls';
19:
20: AMW_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMW_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMW_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: -- Hint: Primary key needs to be returned.
25: PROCEDURE Create_Fnd_Attachment(
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'AMWvatcb.pls';
19:
20: AMW_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMW_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMW_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: -- Hint: Primary key needs to be returned.
25: PROCEDURE Create_Fnd_Attachment(
26: p_api_version_number IN NUMBER,
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:
81: -- Debug Message
82: IF (AMW_DEBUG_HIGH_ON) THEN
254: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
255: END IF;
256:
257: -- Standard call to get message count and if count is 1, get message info.
258: FND_MSG_PUB.Count_And_Get
259: (p_count => x_msg_count,
260: p_data => x_msg_data
261: );
262:
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,
277: p_data => x_msg_data
278: );
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,
287: p_data => x_msg_data
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;
297: -- Standard call to get message count and if count=1, get the message
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;
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,
294: THEN
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: );