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
110: Fnd_Log.STRING(Fnd_Log.level_error,
111: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
112: 'EXC_ERROR[' || x_msg_data || ']');
106: p_data => x_msg_data);
107:
108: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
109: THEN
110: Fnd_Log.STRING(Fnd_Log.level_error,
111: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
112: 'EXC_ERROR[' || x_msg_data || ']');
113: END IF;
114: WHEN Fnd_Api.g_exc_unexpected_error THEN
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
122: Fnd_Log.STRING(Fnd_Log.level_exception,
123: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
124: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
118: p_data => x_msg_data);
119:
120: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
121: THEN
122: Fnd_Log.STRING(Fnd_Log.level_exception,
123: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
124: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
125: END IF;
126: WHEN OTHERS THEN
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
140: Fnd_Log.STRING(Fnd_Log.level_exception,
141: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
142: 'SQL MEssage[' || SQLERRM || ']');
136: p_data => x_msg_data);
137:
138: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
139: THEN
140: Fnd_Log.STRING(Fnd_Log.level_exception,
141: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
142: 'SQL MEssage[' || SQLERRM || ']');
143: END IF;
144: END CREATE_ESTIMATE_HEADER;
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
236: Fnd_Log.STRING(Fnd_Log.level_error,
237: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
238: 'EXC_ERROR[' || x_msg_data || ']');
232: p_data => x_msg_data);
233:
234: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
235: THEN
236: Fnd_Log.STRING(Fnd_Log.level_error,
237: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
238: 'EXC_ERROR[' || x_msg_data || ']');
239: END IF;
240: WHEN Fnd_Api.g_exc_unexpected_error THEN
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
248: Fnd_Log.STRING(Fnd_Log.level_exception,
249: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
250: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
244: p_data => x_msg_data);
245:
246: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
247: THEN
248: Fnd_Log.STRING(Fnd_Log.level_exception,
249: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
250: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
251: END IF;
252: WHEN OTHERS THEN
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
266: Fnd_Log.STRING(Fnd_Log.level_exception,
267: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
268: 'SQL MEssage[' || SQLERRM || ']');
262: p_data => x_msg_data);
263:
264: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
265: THEN
266: Fnd_Log.STRING(Fnd_Log.level_exception,
267: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
268: 'SQL MEssage[' || SQLERRM || ']');
269: END IF;
270: END update_estimate_header;
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
364: Fnd_Log.STRING(Fnd_Log.level_error,
365: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
366: 'EXC_ERROR[' || x_msg_data || ']');
360: p_data => x_msg_data);
361:
362: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
363: THEN
364: Fnd_Log.STRING(Fnd_Log.level_error,
365: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
366: 'EXC_ERROR[' || x_msg_data || ']');
367: END IF;
368: WHEN Fnd_Api.g_exc_unexpected_error THEN
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
376: Fnd_Log.STRING(Fnd_Log.level_exception,
377: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
378: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
372: p_data => x_msg_data);
373:
374: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
375: THEN
376: Fnd_Log.STRING(Fnd_Log.level_exception,
377: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
378: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
379: END IF;
380: WHEN OTHERS THEN
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
394: Fnd_Log.STRING(Fnd_Log.level_exception,
395: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
396: 'SQL MEssage[' || SQLERRM || ']');
390: p_data => x_msg_data);
391:
392: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
393: THEN
394: Fnd_Log.STRING(Fnd_Log.level_exception,
395: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
396: 'SQL MEssage[' || SQLERRM || ']');
397: END IF;
398: END create_estimate_line;
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
492: Fnd_Log.STRING(Fnd_Log.level_error,
493: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
494: 'EXC_ERROR[' || x_msg_data || ']');
488: p_data => x_msg_data);
489:
490: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
491: THEN
492: Fnd_Log.STRING(Fnd_Log.level_error,
493: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
494: 'EXC_ERROR[' || x_msg_data || ']');
495: END IF;
496: WHEN Fnd_Api.g_exc_unexpected_error THEN
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
504: Fnd_Log.STRING(Fnd_Log.level_exception,
505: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
506: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
500: p_data => x_msg_data);
501:
502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
503: THEN
504: Fnd_Log.STRING(Fnd_Log.level_exception,
505: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
506: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
507: END IF;
508: WHEN OTHERS THEN
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
522: Fnd_Log.STRING(Fnd_Log.level_exception,
523: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
524: 'SQL MEssage[' || SQLERRM || ']');
518: p_data => x_msg_data);
519:
520: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
521: THEN
522: Fnd_Log.STRING(Fnd_Log.level_exception,
523: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
524: 'SQL MEssage[' || SQLERRM || ']');
525: END IF;
526: END update_estimate_line;