APPS.CSD_SERVICE_CODES_PVT dependencies on CSD_SERVICE_CODES_PKG

Line 143: CSD_SERVICE_CODES_PKG.Insert_Row

139:
140: Begin
141:
142: -- Insert the new service code
143: CSD_SERVICE_CODES_PKG.Insert_Row
144: (px_rowid => l_rowid,
145: px_service_code_id => x_service_code_id,
146: p_object_version_number => l_obj_ver_num,
147: p_created_by => FND_GLOBAL.USER_ID,

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

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: IF ( lc_excep_level >= lc_debug_level) THEN
178: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SERVICE_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
179: END IF;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END;
182:

Line 524: CSD_SERVICE_CODES_PKG.Update_Row

520:
521: Begin
522:
523: -- Update the service code
524: CSD_SERVICE_CODES_PKG.Update_Row
525: (p_service_code_id => p_service_code_rec.service_code_id,
526: p_object_version_number => l_obj_ver_num + 1,
527: p_created_by => FND_GLOBAL.USER_ID,
528: p_creation_date => SYSDATE,

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

556:
557: EXCEPTION
558: WHEN OTHERS THEN
559: IF ( lc_excep_level >= lc_debug_level) THEN
560: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SERVICE_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
561: END IF;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: END;
564:

Line 894: CSD_SERVICE_CODES_PKG.Lock_Row

890:
891: Begin
892:
893: -- Lock the service code
894: CSD_SERVICE_CODES_PKG.Lock_Row
895: (px_rowid => l_rowid,
896: p_service_code_id => p_service_code_rec.service_code_id,
897: p_object_version_number => p_service_code_rec.object_version_number
898:

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

925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: IF ( lc_excep_level >= lc_debug_level) THEN
929: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SERVICE_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
930: END IF;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: END;
933: