159:
160: BEGIN
161:
162: -- Insert the ro diagnostic code association
163: CSD_RO_DIAGNOSTIC_CODES_PKG.Insert_Row
164: (px_ro_diagnostic_code_id => x_ro_diagnostic_code_id,
165: p_object_version_number => l_obj_ver_num,
166: p_repair_line_id => p_ro_diagnostic_code_rec.repair_line_id,
167: p_diagnostic_code_id => p_ro_diagnostic_code_rec.diagnostic_code_id,
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: IF ( lc_excep_level >= lc_debug_level) THEN
195: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_DIAGNOSTIC_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
196: END IF;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: END;
199:
568:
569: BEGIN
570:
571: -- Update the ro diagnostic code association
572: CSD_RO_DIAGNOSTIC_CODES_PKG.Update_Row
573: (p_ro_diagnostic_code_id => p_ro_diagnostic_code_rec.ro_diagnostic_code_id,
574: p_object_version_number => l_obj_ver_num + 1,
575: p_repair_line_id => p_ro_diagnostic_code_rec.repair_line_id,
576: p_diagnostic_code_id => p_ro_diagnostic_code_rec.diagnostic_code_id,
602:
603: EXCEPTION
604: WHEN OTHERS THEN
605: IF ( lc_excep_level >= lc_debug_level) THEN
606: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_DIAGNOSTIC_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
607: END IF;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: END;
610:
943:
944: BEGIN
945:
946: -- Delete the ro diagnostic code association
947: CSD_RO_DIAGNOSTIC_CODES_PKG.Delete_Row
948: (p_ro_diagnostic_code_id => p_ro_diagnostic_code_id);
949:
950: EXCEPTION
951: WHEN OTHERS THEN
949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF ( lc_excep_level >= lc_debug_level) THEN
953: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_DIAGNOSTIC_CODES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
954: END IF;
955: x_return_status := FND_API.G_RET_STS_ERROR;
956: END;
957:
1143:
1144: BEGIN
1145:
1146: -- Lock the ro diagnostic code association
1147: CSD_RO_DIAGNOSTIC_CODES_PKG.Lock_Row
1148: (p_ro_diagnostic_code_id => p_ro_diagnostic_code_rec.ro_diagnostic_code_id,
1149: p_object_version_number => p_ro_diagnostic_code_rec.object_version_number
1150:
1151: --commented out the rest of the record
1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: IF ( lc_excep_level >= lc_debug_level) THEN
1183: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_DIAGNOSTIC_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1184: END IF;
1185: x_return_status := FND_API.G_RET_STS_ERROR;
1186: END;
1187: