DBA Data[Home] [Help]

APPS.IEM_EMAIL_CATEGORY_MAPS_PVT dependencies on FND_MSG_PUB

Line 54: FND_MSG_PUB.initialize;

50: END IF;
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.to_Boolean( p_init_msg_list )
53: THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56: -- Initialize API return status to SUCCESS
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:

Line 133: FND_MSG_PUB.Count_And_Get

129: IF FND_API.To_Boolean(p_commit) THEN
130: COMMIT WORK;
131: END IF;
132: -- Standard callto get message count and if count is 1, get message info.
133: FND_MSG_PUB.Count_And_Get
134: ( p_count => x_msg_count,
135: p_data => x_msg_data
136: );
137: EXCEPTION

Line 141: FND_MSG_PUB.Count_And_Get

137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO create_item_PVT;
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get
142: ( p_count => x_msg_count,
143: p_data => x_msg_data
144: );
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 148: FND_MSG_PUB.Count_And_Get

144: );
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK TO create_item_PVT;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: FND_MSG_PUB.Count_And_Get
149: ( p_count => x_msg_count,
150: p_data => x_msg_data
151: );
152: WHEN OTHERS THEN

Line 155: IF FND_MSG_PUB.Check_Msg_Level

151: );
152: WHEN OTHERS THEN
153: ROLLBACK TO create_item_PVT;
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: IF FND_MSG_PUB.Check_Msg_Level
156: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
157: THEN
158: FND_MSG_PUB.Add_Exc_Msg
159: ( G_PKG_NAME ,

Line 156: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

152: WHEN OTHERS THEN
153: ROLLBACK TO create_item_PVT;
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: IF FND_MSG_PUB.Check_Msg_Level
156: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
157: THEN
158: FND_MSG_PUB.Add_Exc_Msg
159: ( G_PKG_NAME ,
160: l_api_name

Line 158: FND_MSG_PUB.Add_Exc_Msg

154: x_return_status := FND_API.G_RET_STS_ERROR;
155: IF FND_MSG_PUB.Check_Msg_Level
156: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
157: THEN
158: FND_MSG_PUB.Add_Exc_Msg
159: ( G_PKG_NAME ,
160: l_api_name
161: );
162: END IF;

Line 163: FND_MSG_PUB.Count_And_Get

159: ( G_PKG_NAME ,
160: l_api_name
161: );
162: END IF;
163: FND_MSG_PUB.Count_And_Get
164: ( p_count => x_msg_count ,
165: p_data => x_msg_data
166: );
167:

Line 196: FND_MSG_PUB.initialize;

192: END IF;
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198: -- Initialize API return status to SUCCESS
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:

Line 210: FND_MSG_PUB.Count_And_Get

206: IF FND_API.To_Boolean(p_commit) THEN
207: COMMIT WORK;
208: END IF;
209: -- Standard callto get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get
211: ( p_count => x_msg_count,
212: p_data => x_msg_data
213: );
214: EXCEPTION

Line 218: FND_MSG_PUB.Count_And_Get

214: EXCEPTION
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO delete_item_PVT;
217: x_return_status := FND_API.G_RET_STS_ERROR ;
218: FND_MSG_PUB.Count_And_Get
219: ( p_count => x_msg_count,
220: p_data => x_msg_data
221: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 225: FND_MSG_PUB.Count_And_Get

221: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO delete_item_PVT;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229: WHEN OTHERS THEN

Line 232: IF FND_MSG_PUB.Check_Msg_Level

228: );
229: WHEN OTHERS THEN
230: ROLLBACK TO delete_item_PVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: IF FND_MSG_PUB.Check_Msg_Level
233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg
236: ( G_PKG_NAME ,

Line 233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

229: WHEN OTHERS THEN
230: ROLLBACK TO delete_item_PVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: IF FND_MSG_PUB.Check_Msg_Level
233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg
236: ( G_PKG_NAME ,
237: l_api_name

Line 235: FND_MSG_PUB.Add_Exc_Msg

231: x_return_status := FND_API.G_RET_STS_ERROR;
232: IF FND_MSG_PUB.Check_Msg_Level
233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg
236: ( G_PKG_NAME ,
237: l_api_name
238: );
239: END IF;

Line 240: FND_MSG_PUB.Count_And_Get

236: ( G_PKG_NAME ,
237: l_api_name
238: );
239: END IF;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count ,
242: p_data => x_msg_data
243: );
244: