DBA Data[Home] [Help]

APPS.CSD_DC_DOMAINS_PVT dependencies on CSD_DC_DOMAINS_PKG

Line 379: CSD_DC_DOMAINS_PKG.Insert_Row

375: end if;
376:
377: BEGIN
378: -- Insert the new domain
379: CSD_DC_DOMAINS_PKG.Insert_Row
380: (px_dc_domain_id => x_dc_domain_id,
381: p_object_version_number => l_obj_ver_num,
382: p_diagnostic_code_id => p_dc_domain_rec.diagnostic_code_id,
383: p_inventory_item_id => l_inventory_item_id,

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

409:
410: EXCEPTION
411: WHEN OTHERS THEN
412: IF ( lc_excep_level >= lc_debug_level) THEN
413: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DC_DOMAINS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
414: END IF;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: END;
417:

Line 1289: CSD_DC_DOMAINS_PKG.Update_Row

1285: end if;
1286:
1287: BEGIN
1288: -- Update the diagnostic code domain
1289: CSD_DC_DOMAINS_PKG.Update_Row
1290: (p_dc_domain_id => p_dc_domain_rec.dc_domain_id,
1291: p_object_version_number => l_obj_ver_num + 1,
1292: p_diagnostic_code_id => p_dc_domain_rec.diagnostic_code_id,
1293: p_inventory_item_id => l_inventory_item_id,

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

1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: IF ( lc_excep_level >= lc_debug_level) THEN
1325: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DC_DOMAINS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1326: END IF;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: END;
1329:

Line 1840: CSD_DC_DOMAINS_PKG.Delete_Row

1836:
1837: BEGIN
1838:
1839: -- Delete the diagnostic code domain
1840: CSD_DC_DOMAINS_PKG.Delete_Row
1841: ( p_dc_domain_id => p_dc_domain_id );
1842:
1843: EXCEPTION
1844: WHEN OTHERS THEN

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

1842:
1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: IF ( lc_excep_level >= lc_debug_level) THEN
1846: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DC_DOMAINS_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1847: END IF;
1848: x_return_status := FND_API.G_RET_STS_ERROR;
1849: END;
1850:

Line 2042: CSD_DC_DOMAINS_PKG.Lock_Row

2038:
2039: BEGIN
2040:
2041: -- Lock the dc domain
2042: CSD_DC_DOMAINS_PKG.Lock_Row
2043: (p_dc_domain_id => p_dc_domain_rec.dc_domain_id,
2044: p_object_version_number => p_dc_domain_rec.object_version_number
2045:
2046: --commented out the rest of the record

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

2077:
2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: IF ( lc_excep_level >= lc_debug_level) THEN
2081: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DC_DOMAINS_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
2082: END IF;
2083: x_return_status := FND_API.G_RET_STS_ERROR;
2084: END;
2085: