DBA Data[Home] [Help]

APPS.CSD_RO_DIAGNOSTIC_CODES_PVT dependencies on CSD_RO_DIAGNOSTIC_CODES_PKG

Line 163: CSD_RO_DIAGNOSTIC_CODES_PKG.Insert_Row

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,

Line 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));

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:

Line 572: CSD_RO_DIAGNOSTIC_CODES_PKG.Update_Row

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,

Line 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));

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:

Line 947: CSD_RO_DIAGNOSTIC_CODES_PKG.Delete_Row

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

Line 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));

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:

Line 1147: CSD_RO_DIAGNOSTIC_CODES_PKG.Lock_Row

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

Line 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));

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: