DBA Data[Home] [Help]

APPS.CSD_SC_DOMAINS_PVT dependencies on CSD_SC_DOMAINS_PKG

Line 383: CSD_SC_DOMAINS_PKG.Insert_Row

379:
380: BEGIN
381:
382: -- Insert the new domain
383: CSD_SC_DOMAINS_PKG.Insert_Row
384: (px_sc_domain_id => x_sc_domain_id,
385: p_object_version_number => l_obj_ver_num,
386: p_service_code_id => p_sc_domain_rec.service_code_id,
387: p_inventory_item_id => l_inventory_item_id,

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

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

Line 1303: CSD_SC_DOMAINS_PKG.Update_Row

1299:
1300: BEGIN
1301:
1302: -- Update the service code domain
1303: CSD_SC_DOMAINS_PKG.Update_Row
1304: (p_sc_domain_id => p_sc_domain_rec.sc_domain_id,
1305: p_object_version_number => l_obj_ver_num + 1,
1306: p_service_code_id => p_sc_domain_rec.service_code_id,
1307: p_inventory_item_id => l_inventory_item_id,

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

1335:
1336: EXCEPTION
1337: WHEN OTHERS THEN
1338: IF ( lc_excep_level >= lc_debug_level) THEN
1339: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: END;
1343:

Line 1854: CSD_SC_DOMAINS_PKG.Delete_Row

1850:
1851: BEGIN
1852:
1853: -- Delete the service code domain
1854: CSD_SC_DOMAINS_PKG.Delete_Row
1855: (p_sc_domain_id => p_sc_domain_id );
1856:
1857: EXCEPTION
1858: WHEN OTHERS THEN

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

1856:
1857: EXCEPTION
1858: WHEN OTHERS THEN
1859: IF ( lc_excep_level >= lc_debug_level) THEN
1860: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END;
1864:

Line 2056: CSD_SC_DOMAINS_PKG.Lock_Row

2052:
2053: BEGIN
2054:
2055: -- Lock the sc domain
2056: CSD_SC_DOMAINS_PKG.Lock_Row
2057: (p_sc_domain_id => p_sc_domain_rec.sc_domain_id,
2058: p_object_version_number => p_sc_domain_rec.object_version_number
2059:
2060: --commented out the rest of the record

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

2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: IF ( lc_excep_level >= lc_debug_level) THEN
2095: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
2096: END IF;
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END;
2099: