DBA Data[Home] [Help]

APPS.CSD_SC_WORK_ENTITIES_PVT dependencies on CSD_SC_WORK_ENTITIES_PKG

Line 299: CSD_SC_WORK_ENTITIES_PKG.Insert_Row

295:
296: BEGIN
297:
298: -- Insert the new work entity
299: CSD_SC_WORK_ENTITIES_PKG.Insert_Row
300: (px_sc_work_entity_id => x_sc_work_entity_id,
301: p_object_version_number => l_obj_ver_num,
302: p_service_code_id => p_sc_work_entity_rec.service_code_id,
303: p_work_entity_id1 => p_sc_work_entity_rec.work_entity_id1,

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

329:
330: EXCEPTION
331: WHEN OTHERS THEN
332: IF ( lc_excep_level >= lc_debug_level) THEN
333: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
334: END IF;
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: END;
337:

Line 950: CSD_SC_WORK_ENTITIES_PKG.Update_Row

946:
947: BEGIN
948:
949: -- Update the sc work entity
950: CSD_SC_WORK_ENTITIES_PKG.Update_Row
951: (p_sc_work_entity_id => p_sc_work_entity_rec.sc_work_entity_id,
952: p_object_version_number => l_obj_ver_num + 1,
953: p_service_code_id => p_sc_work_entity_rec.service_code_id,
954: p_work_entity_id1 => p_sc_work_entity_rec.work_entity_id1,

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

982:
983: EXCEPTION
984: WHEN OTHERS THEN
985: IF ( lc_excep_level >= lc_debug_level) THEN
986: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
987: END IF;
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: END;
990:

Line 1427: CSD_SC_WORK_ENTITIES_PKG.Delete_Row

1423:
1424: BEGIN
1425:
1426: -- Delete the work entity
1427: CSD_SC_WORK_ENTITIES_PKG.Delete_Row
1428: (p_sc_work_entity_id => p_sc_work_entity_id );
1429:
1430: EXCEPTION
1431: WHEN OTHERS THEN

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

1429:
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: IF ( lc_excep_level >= lc_debug_level) THEN
1433: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1434: END IF;
1435: x_return_status := FND_API.G_RET_STS_ERROR;
1436: END;
1437:

Line 1629: CSD_SC_WORK_ENTITIES_PKG.Lock_Row

1625:
1626: BEGIN
1627:
1628: -- Lock the work entity
1629: CSD_SC_WORK_ENTITIES_PKG.Lock_Row
1630: (p_sc_work_entity_id => p_sc_work_entity_rec.sc_work_entity_id,
1631: p_object_version_number => p_sc_work_entity_rec.object_version_number
1632:
1633: --commented out the rest of the record

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

1664:
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: IF ( lc_excep_level >= lc_debug_level) THEN
1668: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1669: END IF;
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: END;
1672: