DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PUB dependencies on FND_LOG

Line 108: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 110: Fnd_Log.STRING(Fnd_Log.level_error,

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

Line 120: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 122: Fnd_Log.STRING(Fnd_Log.level_exception,

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

Line 138: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 140: Fnd_Log.STRING(Fnd_Log.level_exception,

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;

Line 234: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 236: Fnd_Log.STRING(Fnd_Log.level_error,

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

Line 246: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 248: Fnd_Log.STRING(Fnd_Log.level_exception,

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

Line 264: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 266: Fnd_Log.STRING(Fnd_Log.level_exception,

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;

Line 362: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 364: Fnd_Log.STRING(Fnd_Log.level_error,

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

Line 374: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 376: Fnd_Log.STRING(Fnd_Log.level_exception,

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

Line 392: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 394: Fnd_Log.STRING(Fnd_Log.level_exception,

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;

Line 490: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 492: Fnd_Log.STRING(Fnd_Log.level_error,

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

Line 502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 504: Fnd_Log.STRING(Fnd_Log.level_exception,

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

Line 520: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

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 || ']');

Line 522: Fnd_Log.STRING(Fnd_Log.level_exception,

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;