77: /*
78: ** Initialize Processing
79: */
80:
81: x_return_status := Fnd_Api.G_Ret_Sts_Success;
82:
83: Fnd_Msg_Pub.Initialize;
84:
85: /*
192: */
193:
194: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
195:
196: RAISE Fnd_Api.G_Exc_Error;
197:
198: END IF;
199:
200: Igw_Budgets_Pvt.Create_Budget_Version
198: END IF;
199:
200: Igw_Budgets_Pvt.Create_Budget_Version
201: (
202: p_init_msg_list => Fnd_Api.G_True,
203: p_commit => Fnd_Api.G_False,
204: p_validate_only => p_validate_only,
205: p_proposal_id => l_proposal_id,
206: p_version_id => null,
199:
200: Igw_Budgets_Pvt.Create_Budget_Version
201: (
202: p_init_msg_list => Fnd_Api.G_True,
203: p_commit => Fnd_Api.G_False,
204: p_validate_only => p_validate_only,
205: p_proposal_id => l_proposal_id,
206: p_version_id => null,
207: p_start_date => p_start_date,
246: );
247:
248: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
249:
250: RAISE Fnd_Api.G_Exc_Error;
251:
252: END IF;
253:
254:
255: /*
256: ** Commit data if API invoked in commit mode
257: */
258:
259: IF Fnd_Api.To_Boolean(p_commit) THEN
260:
261: COMMIT;
262:
263: END IF;
263: END IF;
264:
265: EXCEPTION
266:
267: WHEN Fnd_Api.G_Exc_Error THEN
268:
269: ROLLBACK TO Create_Budget_Version_Pub;
270:
271: x_return_status := Fnd_Api.G_Ret_Sts_Error;
267: WHEN Fnd_Api.G_Exc_Error THEN
268:
269: ROLLBACK TO Create_Budget_Version_Pub;
270:
271: x_return_status := Fnd_Api.G_Ret_Sts_Error;
272:
273: Fnd_Msg_Pub.Count_And_Get
274: (
275: p_encoded => Fnd_Api.G_False,
271: x_return_status := Fnd_Api.G_Ret_Sts_Error;
272:
273: Fnd_Msg_Pub.Count_And_Get
274: (
275: p_encoded => Fnd_Api.G_False,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279:
280: WHEN others THEN
281:
282: ROLLBACK TO Create_Budget_Version_Pub;
283:
284: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
285:
286: Fnd_Msg_Pub.Add_Exc_Msg
287: (
288: p_pkg_name => G_PKG_NAME,
290: );
291:
292: Fnd_Msg_Pub.Count_And_Get
293: (
294: p_encoded => Fnd_Api.G_False,
295: p_count => x_msg_count,
296: p_data => x_msg_data
297: );
298: