DBA Data[Home] [Help]

APPS.CSD_DIAGNOSTIC_CODES_PVT dependencies on CSD_DIAGNOSTIC_CODES_PKG

Line 142: CSD_DIAGNOSTIC_CODES_PKG.Insert_Row

138:
139: Begin
140:
141: -- Insert the new diagnostic code
142: CSD_DIAGNOSTIC_CODES_PKG.Insert_Row
143: (px_rowid => l_rowid,
144: px_diagnostic_code_id => x_diagnostic_code_id,
145: p_object_version_number => l_obj_ver_num,
146: p_created_by => FND_GLOBAL.USER_ID,

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

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

Line 521: CSD_DIAGNOSTIC_CODES_PKG.Update_Row

517:
518: Begin
519:
520: -- Update the diagnostic code
521: CSD_DIAGNOSTIC_CODES_PKG.Update_Row
522: (p_diagnostic_code_id => p_diagnostic_code_rec.diagnostic_code_id,
523: p_object_version_number => l_obj_ver_num + 1,
524: p_created_by => FND_GLOBAL.USER_ID,
525: p_creation_date => SYSDATE,

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

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

Line 891: CSD_DIAGNOSTIC_CODES_PKG.Lock_Row

887:
888: Begin
889:
890: -- Lock the diagnostic code
891: CSD_DIAGNOSTIC_CODES_PKG.Lock_Row
892: (px_rowid => l_rowid,
893: p_diagnostic_code_id => p_diagnostic_code_rec.diagnostic_code_id,
894: p_object_version_number => p_diagnostic_code_rec.object_version_number
895:

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

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