DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_LINES_PVT dependencies on CSD_REPAIR_ACTUAL_LINES_PKG

Line 341: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)

337:
338: BEGIN
339: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
340: -- insert the record into CSD_REPAIR_ACTUAL_LINES
341: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
342: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
343: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
344: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
345: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID

Line 342: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(

338: BEGIN
339: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
340: -- insert the record into CSD_REPAIR_ACTUAL_LINES
341: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
342: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
343: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
344: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
345: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
346: ,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID

Line 408: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
408: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
409: END IF;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: END;
412:

Line 458: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)

454:
455: BEGIN
456: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
457: -- insert the record into CSD_REPAIR_ACTUAL_LINES
458: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
459: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
460: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
461: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
462: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID

Line 459: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(

455: BEGIN
456: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
457: -- insert the record into CSD_REPAIR_ACTUAL_LINES
458: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
459: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
460: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
461: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
462: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
463: ,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID

Line 522: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
522: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
523: END IF;
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END;
526:

Line 783: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)

779:
780: BEGIN
781: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
782: -- insert the record into CSD_REPAIR_ACTUAL_LINES
783: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
784: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
785: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
786: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
787: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID

Line 784: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(

780: BEGIN
781: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
782: -- insert the record into CSD_REPAIR_ACTUAL_LINES
783: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
784: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
785: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
786: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
787: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
788: ,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID

Line 847: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
847: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
848: END IF;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850: END;
851:

Line 1322: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row)

1318: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Update_Row');
1319: END IF;
1320:
1321: BEGIN
1322: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row)
1323: CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row(
1324: p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
1325: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
1326: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID

Line 1323: CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row(

1319: END IF;
1320:
1321: BEGIN
1322: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row)
1323: CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row(
1324: p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
1325: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
1326: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
1327: ,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID

Line 1386: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row Cal:'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1386: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row Cal:'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1387: END IF;
1388: RAISE FND_API.G_EXC_ERROR;
1389: END;
1390: --

Line 1674: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row');

1670: RAISE FND_API.G_EXC_ERROR;
1671: END IF;
1672:
1673: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
1674: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row');
1675: END IF;
1676:
1677: BEGIN
1678:

Line 1679: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row)

1675: END IF;
1676:
1677: BEGIN
1678:
1679: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row)
1680: CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row(
1681: p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
1682: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER);
1683:

Line 1680: CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row(

1676:
1677: BEGIN
1678:
1679: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row)
1680: CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row(
1681: p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
1682: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER);
1683:
1684: EXCEPTION

Line 1687: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1683:
1684: EXCEPTION
1685: WHEN OTHERS THEN
1686: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1687: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1688: END IF;
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: END;
1691:

Line 1851: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row');

1847: --
1848: -- API body
1849: --
1850: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
1851: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row');
1852: END IF;
1853:
1854: BEGIN
1855:

Line 1856: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row)

1852: END IF;
1853:
1854: BEGIN
1855:
1856: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row)
1857: CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row(
1858: p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
1859: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER);
1860:

Line 1857: CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row(

1853:
1854: BEGIN
1855:
1856: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row)
1857: CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row(
1858: p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
1859: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER);
1860:
1861: EXCEPTION

Line 1864: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1860:
1861: EXCEPTION
1862: WHEN OTHERS THEN
1863: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1864: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1865: END IF;
1866: x_return_status := FND_API.G_RET_STS_ERROR;
1867: END;
1868: