67: l_user_name := fnd_global.user_name;
68: /* Bug 2576222 End */
69:
70: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize ;
72: END IF;
73: --
74: p_return_status := FND_API.G_RET_STS_SUCCESS ;
75: --
145: IF FND_API.To_Boolean ( p_commit ) THEN
146: COMMIT WORK;
147: END IF;
148: --
149: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
150: p_data => p_msg_data );
151: --
152: EXCEPTION
153: --
154: WHEN FND_API.G_EXC_ERROR THEN
155: --
156: ROLLBACK TO Start_Process_Pvt ;
157: p_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
159: p_data => p_msg_data );
160: --
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: --
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: --
163: ROLLBACK TO Start_Process_Pvt ;
164: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
166: p_data => p_msg_data );
167: --
168: WHEN OTHERS THEN
169: --
169: --
170: ROLLBACK TO Start_Process_Pvt ;
171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: --
173: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
174: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
175: l_api_name);
176: END if;
177: --
170: ROLLBACK TO Start_Process_Pvt ;
171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: --
173: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
174: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
175: l_api_name);
176: END if;
177: --
178: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
174: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
175: l_api_name);
176: END if;
177: --
178: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
179: p_data => p_msg_data );
180: --
181: END Start_Process ;
182: /*---------------------------------------------------------------------------*/