369: x_return_status := Fnd_Api.G_RET_STS_ERROR;
370: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
372: p_data => x_msg_data);
373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
374: THEN
375: Fnd_Log.STRING(Fnd_Log.level_error,
376: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
377: 'EXC_ERROR[' || x_msg_data || ']');
371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
372: p_data => x_msg_data);
373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
374: THEN
375: Fnd_Log.STRING(Fnd_Log.level_error,
376: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
377: 'EXC_ERROR[' || x_msg_data || ']');
378: END IF;
379:
381: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
382: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data);
385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
386: THEN
387: Fnd_Log.STRING(Fnd_Log.level_exception,
388: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
389: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data);
385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
386: THEN
387: Fnd_Log.STRING(Fnd_Log.level_exception,
388: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
389: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
390: END IF;
391: WHEN OTHERS THEN
396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
397: END IF;
398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
399: p_data => x_msg_data);
400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
401: THEN
402: Fnd_Log.STRING(Fnd_Log.level_exception,
403: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
404: 'SQL MEssage[' || SQLERRM || ']');
398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
399: p_data => x_msg_data);
400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
401: THEN
402: Fnd_Log.STRING(Fnd_Log.level_exception,
403: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
404: 'SQL MEssage[' || SQLERRM || ']');
405: END IF;
406:
492: x_return_status := Fnd_Api.G_RET_STS_ERROR;
493: ROLLBACK TO UPDATE_RO_STATUS_PUB;
494: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
495: p_data => x_msg_data);
496: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
497: THEN
498: Fnd_Log.STRING(Fnd_Log.level_error,
499: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
500: 'EXC_ERROR[' || x_msg_data || ']');
494: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
495: p_data => x_msg_data);
496: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
497: THEN
498: Fnd_Log.STRING(Fnd_Log.level_error,
499: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
500: 'EXC_ERROR[' || x_msg_data || ']');
501: END IF;
502:
504: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
505: ROLLBACK TO UPDATE_RO_STATUS_PUB;
506: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
507: p_data => x_msg_data);
508: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
509: THEN
510: Fnd_Log.STRING(Fnd_Log.level_exception,
511: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
512: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
506: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
507: p_data => x_msg_data);
508: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
509: THEN
510: Fnd_Log.STRING(Fnd_Log.level_exception,
511: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
512: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
513: END IF;
514: WHEN OTHERS THEN
519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
520: END IF;
521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
522: p_data => x_msg_data);
523: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
524: THEN
525: Fnd_Log.STRING(Fnd_Log.level_exception,
526: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
527: 'SQL MEssage[' || SQLERRM || ']');
521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
522: p_data => x_msg_data);
523: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
524: THEN
525: Fnd_Log.STRING(Fnd_Log.level_exception,
526: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
527: 'SQL MEssage[' || SQLERRM || ']');
528: END IF;
529: