eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIR_ACTUAL_LINES_PVT dependencies on CSD_REPAIR_ACTUAL_LINES

Line 1: PACKAGE BODY CSD_REPAIR_ACTUAL_LINES_PVT as

1: PACKAGE BODY CSD_REPAIR_ACTUAL_LINES_PVT as
2: /* $Header: csdvalnb.pls 120.9.12020000.2 2013/01/30 22:38:26 yvchen ship $ */
3:
4:
5: --G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_ACTUAL_LINES_PVT';

Line 5: --G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_ACTUAL_LINES_PVT';

1: PACKAGE BODY CSD_REPAIR_ACTUAL_LINES_PVT as
2: /* $Header: csdvalnb.pls 120.9.12020000.2 2013/01/30 22:38:26 yvchen ship $ */
3:
4:
5: --G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_ACTUAL_LINES_PVT';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvclnb.pls';
7:
8: -- Global variable for storing the debug level
9: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 55: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.create_repair_actual_lines';

51: l_event_level number := FND_LOG.LEVEL_EVENT;
52: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
53: l_error_level number := FND_LOG.LEVEL_ERROR;
54: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
55: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.create_repair_actual_lines';
56:
57: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REPAIR_ACTUAL_LINES';
58: l_api_version CONSTANT NUMBER := 1.0;
59: l_msg_count NUMBER;

Line 324: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');

320: --
321: -- API body
322: --
323: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
324: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
325: END IF;
326:
327: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
328: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Required columns: ');

Line 340: -- insert the record into CSD_REPAIR_ACTUAL_LINES

336: END IF;
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

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 402: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Returned from CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');

398: ,p_LOC_SEGMENT19 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT19
399: ,p_LOC_SEGMENT20 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT20);
400:
401: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
402: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Returned from CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
403: END IF;
404:
405: EXCEPTION
406: WHEN OTHERS THEN

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 441: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');

437: --
438: -- API body
439: --
440: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
441: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
442: END IF;
443:
444: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
445: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Required columns: ');

Line 457: -- insert the record into CSD_REPAIR_ACTUAL_LINES

453: END IF;
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

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 777: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');

773: --
774: -- API body
775: --
776: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
777: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
778: END IF;
779:
780: BEGIN
781: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to

Line 782: -- insert the record into CSD_REPAIR_ACTUAL_LINES

778: END IF;
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

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 957: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.update_repair_actual_lines';

953: l_event_level number := FND_LOG.LEVEL_EVENT;
954: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
955: l_error_level number := FND_LOG.LEVEL_ERROR;
956: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
957: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.update_repair_actual_lines';
958:
959: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REPAIR_ACTUAL_LINES';
960: l_api_version CONSTANT NUMBER := 1.0;
961: l_msg_count NUMBER;

Line 988: FROM csd_repair_actual_lines a,

984: WHERE estimate_detail_id = p_est_det_id;
985:
986: CURSOR repair_actual_lines(p_actual_line_id IN NUMBER) IS
987: SELECT a.object_version_number
988: FROM csd_repair_actual_lines a,
989: csd_repairs b
990: WHERE a.repair_line_id = b.repair_line_id
991: and a.repair_actual_line_id = p_actual_line_id;
992:

Line 1069: -- Validate the repair actual line id against csd_repair_actual_lines

1065: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1066: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');
1067: END IF;
1068:
1069: -- Validate the repair actual line id against csd_repair_actual_lines
1070: -- If it is invalid then raise FND_API.G_EXC_ERROR
1071: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1072:
1073: OPEN repair_actual_lines(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id);

Line 1177: from csd_repair_actual_lines

1173: from csd_product_transactions
1174: where repair_line_id = px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
1175: union
1176: select estimate_detail_id
1177: from csd_repair_actual_lines
1178: where repair_actual_id=px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID)
1179: and ced.order_header_id is not null
1180: and ooh.open_flag = 'Y'
1181: and nvl(ooh.cancelled_flag,'N') = 'N'

Line 1207: from csd_repair_actual_lines

1203: from csd_product_transactions
1204: where repair_line_id = px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
1205: union
1206: select estimate_detail_id
1207: from csd_repair_actual_lines
1208: where repair_actual_id=px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID)
1209: and ced.order_header_id is not null
1210: and ooh.open_flag = 'Y'
1211: and nvl(ooh.cancelled_flag,'N') = 'N'

Line 1318: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Update_Row');

1314: RAISE FND_API.G_EXC_ERROR;
1315: END;
1316:
1317: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
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)

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 1488: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.delete_repair_actual_lines';

1484: l_event_level number := FND_LOG.LEVEL_EVENT;
1485: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
1486: l_error_level number := FND_LOG.LEVEL_ERROR;
1487: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
1488: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.delete_repair_actual_lines';
1489:
1490:
1491: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REPAIR_ACTUAL_LINES';
1492: l_api_version CONSTANT NUMBER := 1.0;

Line 1513: FROM csd_repair_actual_lines a,

1509: CURSOR repair_actual_lines(p_actual_line_id IN NUMBER) IS
1510: SELECT
1511: a.repair_actual_line_id,
1512: a.object_version_number
1513: FROM csd_repair_actual_lines a,
1514: csd_repairs b
1515: WHERE a.repair_line_id = b.repair_line_id
1516: and a.repair_actual_line_id = p_actual_line_id;
1517:

Line 1590: -- Validate the repair actual line id against csd_repair_actual_lines

1586: -- Check the actual_source_code in Repair_Actual_Lines_Rec
1587:
1588: IF (px_CSD_ACTUAL_LINES_REC.actual_source_code in ('MANUAL', 'ESTIMATE')) then
1589:
1590: -- Validate the repair actual line id against csd_repair_actual_lines
1591: -- If it is interfaced then raise FND_API.G_EXC_ERROR
1592: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1593:
1594: OPEN repair_actual_lines(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id);

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 1792: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.lock_repair_actual_lines';

1788: l_event_level number := FND_LOG.LEVEL_EVENT;
1789: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
1790: l_error_level number := FND_LOG.LEVEL_ERROR;
1791: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
1792: l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.lock_repair_actual_lines';
1793:
1794: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_REPAIR_ACTUAL_LINES';
1795: l_api_version CONSTANT NUMBER := 1.0;
1796: l_msg_count NUMBER;

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:

Line 1925: End CSD_REPAIR_ACTUAL_LINES_PVT;

1921: p_data => x_msg_data );
1922:
1923: End LOCK_REPAIR_ACTUAL_LINES;
1924:
1925: End CSD_REPAIR_ACTUAL_LINES_PVT;