62: END IF;
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF Fnd_Api.to_Boolean(p_init_msg_list)
65: THEN
66: Fnd_Msg_Pub.initialize;
67: END IF;
68: -- Initialize API return status to success
69: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
70: --
94: THEN
95: COMMIT WORK;
96: END IF;
97: -- Standard call to get message count and if count is 1, get message info.
98: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
99: p_data => x_msg_data);
100: --
101: EXCEPTION
102: WHEN Fnd_Api.g_exc_error THEN
101: EXCEPTION
102: WHEN Fnd_Api.g_exc_error THEN
103: x_return_status := Fnd_Api.g_ret_sts_error;
104: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
105: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
106: p_data => x_msg_data);
107:
108: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
109: THEN
113: END IF;
114: WHEN Fnd_Api.g_exc_unexpected_error THEN
115: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
116: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
117: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
118: p_data => x_msg_data);
119:
120: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
121: THEN
126: WHEN OTHERS THEN
127: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
128: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
129:
130: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
131: THEN
132: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
133: END IF;
134:
128: ROLLBACK TO CREATE_ESTIMATE_HEADER_PUB;
129:
130: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
131: THEN
132: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
133: END IF;
134:
135: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);
131: THEN
132: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
133: END IF;
134:
135: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);
137:
138: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
139: THEN
187: END IF;
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF Fnd_Api.to_Boolean(p_init_msg_list)
190: THEN
191: Fnd_Msg_Pub.initialize;
192: END IF;
193: -- Initialize API return status to success
194: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
195: --
220: THEN
221: COMMIT WORK;
222: END IF;
223: -- Standard call to get message count and if count is 1, get message info.
224: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
225: p_data => x_msg_data);
226: --
227: EXCEPTION
228: WHEN Fnd_Api.g_exc_error THEN
227: EXCEPTION
228: WHEN Fnd_Api.g_exc_error THEN
229: x_return_status := Fnd_Api.g_ret_sts_error;
230: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
231: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
235: THEN
239: END IF;
240: WHEN Fnd_Api.g_exc_unexpected_error THEN
241: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
242: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
243: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
244: p_data => x_msg_data);
245:
246: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
247: THEN
252: WHEN OTHERS THEN
253: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
254: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
255:
256: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
257: THEN
258: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
254: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;
255:
256: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
257: THEN
258: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
262: p_data => x_msg_data);
257: THEN
258: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
262: p_data => x_msg_data);
263:
264: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
265: THEN
316: END IF;
317: -- Initialize message list if p_init_msg_list is set to TRUE.
318: IF Fnd_Api.to_Boolean(p_init_msg_list)
319: THEN
320: Fnd_Msg_Pub.initialize;
321: END IF;
322: -- Initialize API return status to success
323: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
324: --
348: THEN
349: COMMIT WORK;
350: END IF;
351: -- Standard call to get message count and if count is 1, get message info.
352: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
353: p_data => x_msg_data);
354: --
355: EXCEPTION
356: WHEN Fnd_Api.g_exc_error THEN
355: EXCEPTION
356: WHEN Fnd_Api.g_exc_error THEN
357: x_return_status := Fnd_Api.g_ret_sts_error;
358: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
359: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
360: p_data => x_msg_data);
361:
362: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
363: THEN
367: END IF;
368: WHEN Fnd_Api.g_exc_unexpected_error THEN
369: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
370: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
371: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
372: p_data => x_msg_data);
373:
374: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
375: THEN
380: WHEN OTHERS THEN
381: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
382: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
383:
384: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
385: THEN
386: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
387: END IF;
388:
382: ROLLBACK TO CREATE_ESTIMATE_LINE_PUB;
383:
384: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
385: THEN
386: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
387: END IF;
388:
389: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
390: p_data => x_msg_data);
385: THEN
386: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
387: END IF;
388:
389: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
390: p_data => x_msg_data);
391:
392: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
393: THEN
444: END IF;
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF Fnd_Api.to_Boolean(p_init_msg_list)
447: THEN
448: Fnd_Msg_Pub.initialize;
449: END IF;
450: -- Initialize API return status to success
451: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
452: --
476: THEN
477: COMMIT WORK;
478: END IF;
479: -- Standard call to get message count and if count is 1, get message info.
480: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
481: p_data => x_msg_data);
482: --
483: EXCEPTION
484: WHEN Fnd_Api.g_exc_error THEN
483: EXCEPTION
484: WHEN Fnd_Api.g_exc_error THEN
485: x_return_status := Fnd_Api.g_ret_sts_error;
486: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
487: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
491: THEN
495: END IF;
496: WHEN Fnd_Api.g_exc_unexpected_error THEN
497: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
498: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
499: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
503: THEN
508: WHEN OTHERS THEN
509: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
510: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
511:
512: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
513: THEN
514: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
510: ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;
511:
512: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
513: THEN
514: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
517: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
518: p_data => x_msg_data);
513: THEN
514: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
517: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
518: p_data => x_msg_data);
519:
520: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
521: THEN