47: END IF;
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE
50: IF FND_API.To_Boolean(p_init_msg_list) THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: -- Initialize API return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: -- check for errors
131: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
132: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CREATE_NOTE');
133: FND_MSG_PUB.Add;
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: -- END OF BODY OF API
147:
148: x_return_status := l_return_status;
149:
150: -- Standard call to get message count and if count is 1, get message info
151: FND_MSG_PUB.Count_And_Get(
152: p_encoded => FND_API.G_FALSE,
153: p_count => x_msg_count,
154: p_data => x_msg_data);
155:
156: EXCEPTION
157: WHEN FND_API.G_EXC_ERROR THEN
158: ROLLBACK TO Create_Note_PVT;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: ROLLBACK TO Create_Note_PVT;
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: ROLLBACK TO Create_Note_PVT;
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
166:
167: WHEN OTHERS THEN
168: ROLLBACK TO Create_Note_PVT;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166:
167: WHEN OTHERS THEN
168: ROLLBACK TO Create_Note_PVT;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
171: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
172: END IF;
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
174:
167: WHEN OTHERS THEN
168: ROLLBACK TO Create_Note_PVT;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
171: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
172: END IF;
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
174:
175: END Create_Note;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
171: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
172: END IF;
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
174:
175: END Create_Note;
176:
177: -- create by jypark for notes form's getting notes summary functionality