DBA Data[Home] [Help]

APPS.AMS_MULTIMEDIA_PVT dependencies on FND_API

Line 20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

16:
17:
18: PROCEDURE Process_Multimedia(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT VARCHAR2,

Line 21: p_commit IN VARCHAR2 := FND_API.g_false,

17:
18: PROCEDURE Process_Multimedia(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT VARCHAR2,
25: x_msg_count OUT NUMBER,

Line 22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

18: PROCEDURE Process_Multimedia(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT VARCHAR2,
25: x_msg_count OUT NUMBER,
26: x_msg_data OUT VARCHAR2,

Line 49: IF NOT FND_API.Compatible_API_Call ( l_api_version,

45: -- Standard Start of API savepoint
46: SAVEPOINT Process_Multimedia;
47:
48: -- Standard call to check for call compatibility.
49: IF NOT FND_API.Compatible_API_Call ( l_api_version,
50: p_api_version,
51: l_api_name,
52: G_PKG_NAME)
53: THEN

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50: p_api_version,
51: l_api_name,
52: G_PKG_NAME)
53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list )

Line 58: IF FND_API.to_Boolean( p_init_msg_list )

54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list )
59: THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: -- AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
65:
66:
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70:
71: -- ******************************************************************
72: -- Validate Environment

Line 81: RAISE FND_API.G_EXC_ERROR;

77: THEN
78: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
79: FND_MSG_PUB.ADD;
80: END IF;
81: RAISE FND_API.G_EXC_ERROR;
82: END IF;
83:
84: --
85: -- get the default image if default falg is 'Y'

Line 92: transaction_type := FND_API.g_true;

88: transaction_type := p_multi_rec.create_delete_flag;
89:
90: if (p_multi_rec.default_flag = 'Y') then
91:
92: transaction_type := FND_API.g_true;
93:
94: end if;
95:
96: l_multimedia_tbl(1).obj_lgl_ctnt_delete := transaction_type ;

Line 117: IF FND_API.to_Boolean( p_commit )

113: p_lgl_ctnt_tbl => l_multimedia_tbl );
114:
115:
116: -- Standard check for p_commit
117: IF FND_API.to_Boolean( p_commit )
118: THEN
119: COMMIT WORK;
120: END IF;
121:

Line 132: WHEN FND_API.G_EXC_ERROR THEN

128: (p_count => x_msg_count,
129: p_data => x_msg_data
130: );
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133:
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: -- Standard call to get message count and if count=1, get the message
136: FND_MSG_PUB.Count_And_Get (

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

130: );
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133:
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: -- Standard call to get message count and if count=1, get the message
136: FND_MSG_PUB.Count_And_Get (
137: p_encoded => FND_API.G_FALSE,
138: p_count => x_msg_count,

Line 137: p_encoded => FND_API.G_FALSE,

133:
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: -- Standard call to get message count and if count=1, get the message
136: FND_MSG_PUB.Count_And_Get (
137: p_encoded => FND_API.G_FALSE,
138: p_count => x_msg_count,
139: p_data => x_msg_data
140: );
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

137: p_encoded => FND_API.G_FALSE,
138: p_count => x_msg_count,
139: p_data => x_msg_data
140: );
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142:
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: -- Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139: p_data => x_msg_data
140: );
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142:
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: -- Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,

Line 146: p_encoded => FND_API.G_FALSE,

142:
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: -- Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data
149: );
150: WHEN OTHERS THEN

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

148: p_data => x_msg_data
149: );
150: WHEN OTHERS THEN
151:
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN
155: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
156: END IF;

Line 159: p_encoded => FND_API.G_FALSE,

155: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
156: END IF;
157: -- Standard call to get message count and if count=1, get the message
158: FND_MSG_PUB.Count_And_Get (
159: p_encoded => FND_API.G_FALSE,
160: p_count => x_msg_count,
161: p_data => x_msg_data
162: );
163: END;