DBA Data[Home] [Help]

APPS.CSD_RO_SERVICE_CODES_PVT dependencies on CSD_RO_SERVICE_CODES_PKG

Line 177: CSD_RO_SERVICE_CODES_PKG.Insert_Row

173:
174: BEGIN
175:
176: -- Insert the new ro service code association
177: CSD_RO_SERVICE_CODES_PKG.Insert_Row
178: (px_ro_service_code_id => x_ro_service_code_id,
179: p_object_version_number => l_obj_ver_num,
180: p_repair_line_id => p_ro_service_code_rec.repair_line_id,
181: p_service_code_id => p_ro_service_code_rec.service_code_id,

Line 214: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF ( lc_excep_level >= lc_debug_level) THEN
214: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
215: END IF;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END;
218:

Line 569: CSD_RO_SERVICE_CODES_PKG.Update_Row

565: end if;
566:
567: BEGIN
568:
569: CSD_RO_SERVICE_CODES_PKG.Update_Row
570: (p_ro_service_code_id => p_ro_service_code_rec.ro_service_code_id,
571: p_object_version_number => l_obj_ver_num + 1,
572: p_repair_line_id => p_ro_service_code_rec.repair_line_id,
573: p_service_code_id => p_ro_service_code_rec.service_code_id,

Line 608: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

604:
605: EXCEPTION
606: WHEN OTHERS THEN
607: IF ( lc_excep_level >= lc_debug_level) THEN
608: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
609: END IF;
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: END;
612:

Line 1026: CSD_RO_SERVICE_CODES_PKG.Delete_Row

1022: end if;
1023:
1024: BEGIN
1025:
1026: CSD_RO_SERVICE_CODES_PKG.Delete_Row
1027: (p_ro_service_code_id => p_ro_service_code_id);
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN

Line 1032: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF ( lc_excep_level >= lc_debug_level) THEN
1032: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1033: END IF;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END;
1036:

Line 1226: CSD_RO_SERVICE_CODES_PKG.Lock_Row

1222: end if;
1223:
1224: BEGIN
1225:
1226: CSD_RO_SERVICE_CODES_PKG.Lock_Row
1227: (p_ro_service_code_id => p_ro_service_code_rec.ro_service_code_id,
1228: p_object_version_number => p_ro_service_code_rec.object_version_number
1229:
1230: --commented out the rest of the record

Line 1267: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: IF ( lc_excep_level >= lc_debug_level) THEN
1267: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1268: END IF;
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: END;
1271: