92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list )
95: THEN
96: FND_MSG_PUB.initialize;
97: END IF;
98:
99: -- Initialize API return status to success
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: --+
151: -- API body
152: --+
153:
154: apps.FND_MSG_PUB.initialize;
155:
156: l_source_id := -1001;
157: l_trans_object_type_id := -1002;
158: l_org_id:=x_org_id;
303: COMMIT WORK;
304: END IF;
305:
306: -- Standard call to get message count and if count is 1, get message info.
307: FND_MSG_PUB.Count_And_Get
308: (p_count => x_msg_count,
309: p_data => x_msg_data
310: );
311: EXCEPTION
316: x_msg_data := l_msg_data;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: ROLLBACK TO get_assignments;
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: FND_MSG_PUB.Count_And_Get
321: (p_count => x_msg_count,
322: p_data => x_msg_data,
323: p_encoded => fnd_api.g_false
324: );
324: );
325: WHEN OTHERS THEN
326: ROLLBACK TO get_assignments;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328: IF FND_MSG_PUB.Check_Msg_Level
329: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg
332: (G_PKG_NAME, l_api_name);
325: WHEN OTHERS THEN
326: ROLLBACK TO get_assignments;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328: IF FND_MSG_PUB.Check_Msg_Level
329: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg
332: (G_PKG_NAME, l_api_name);
333: END IF;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328: IF FND_MSG_PUB.Check_Msg_Level
329: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg
332: (G_PKG_NAME, l_api_name);
333: END IF;
334: FND_MSG_PUB.Count_And_Get
335: (p_count => x_msg_count,
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg
332: (G_PKG_NAME, l_api_name);
333: END IF;
334: FND_MSG_PUB.Count_And_Get
335: (p_count => x_msg_count,
336: p_data => x_msg_data,
337: p_encoded => fnd_api.g_false
338: );