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_RO_SERVICE_CODES_PVT dependencies on CSD_RO_SERVICE_CODES

Line 1: PACKAGE BODY CSD_RO_SERVICE_CODES_PVT as

1: PACKAGE BODY CSD_RO_SERVICE_CODES_PVT as
2: /* $Header: csdvrscb.pls 120.2 2006/09/27 00:29:49 rfieldma noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_SERVICE_CODES_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrscb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_SERVICE_CODES_PVT';

1: PACKAGE BODY CSD_RO_SERVICE_CODES_PVT as
2: /* $Header: csdvrscb.pls 120.2 2006/09/27 00:29:49 rfieldma noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_SERVICE_CODES_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrscb.pls';
6:
7: /*--------------------------------------------------*/
8: /* procedure name: Create_RO_Service_Code */

Line 34: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.create_ro_service_code';

30: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
31: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
33: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
34: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.create_ro_service_code';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_RO_Service_Code';
36: lc_api_version CONSTANT NUMBER := 1.0;
37:
38: -- VARIABLES --

Line 143: from csd_ro_service_codes

139: l_dummy := null;
140:
141: select 'X'
142: into l_dummy
143: from csd_ro_service_codes
144: where repair_line_id = p_ro_service_code_rec.repair_line_id
145: and service_code_id = p_ro_service_code_rec.service_code_id;
146:
147: Exception

Line 177: CSD_RO_SERVICE_CODES_PKG.Insert_Row

173:
174: BEGIN
175:
176: -- Insert the new ro service code association
177: CSD_RO_SERVICE_CODES_PKG.Insert_Row
178: (px_ro_service_code_id => x_ro_service_code_id,
179: p_object_version_number => l_obj_ver_num,
180: p_repair_line_id => p_ro_service_code_rec.repair_line_id,
181: p_service_code_id => p_ro_service_code_rec.service_code_id,

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

210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF ( lc_excep_level >= lc_debug_level) THEN
214: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
215: END IF;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END;
218:

Line 373: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.update_ro_service_code';

369: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
370: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
371: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
372: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
373: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.update_ro_service_code';
374: lc_api_name CONSTANT VARCHAR2(30) := 'Update_RO_Service_Code';
375: lc_api_version CONSTANT NUMBER := 1.0;
376:
377: -- VARIABLES --

Line 481: from csd_ro_service_codes

477: l_dummy := null;
478:
479: select 'X'
480: into l_dummy
481: from csd_ro_service_codes
482: where ro_service_code_id = p_ro_service_code_rec.ro_service_code_id;
483:
484: Exception
485:

Line 511: from csd_ro_service_codes

507: -- Get object version number for ro service code association
508: Begin
509: select object_version_number
510: into l_obj_ver_num
511: from csd_ro_service_codes
512: where ro_service_code_id = p_ro_service_code_rec.ro_service_code_id;
513:
514: Exception
515:

Line 569: CSD_RO_SERVICE_CODES_PKG.Update_Row

565: end if;
566:
567: BEGIN
568:
569: CSD_RO_SERVICE_CODES_PKG.Update_Row
570: (p_ro_service_code_id => p_ro_service_code_rec.ro_service_code_id,
571: p_object_version_number => l_obj_ver_num + 1,
572: p_repair_line_id => p_ro_service_code_rec.repair_line_id,
573: p_service_code_id => p_ro_service_code_rec.service_code_id,

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

604:
605: EXCEPTION
606: WHEN OTHERS THEN
607: IF ( lc_excep_level >= lc_debug_level) THEN
608: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
609: END IF;
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: END;
612:

Line 969: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.delete_ro_service_code';

965: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
966: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
967: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
968: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
969: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.delete_ro_service_code';
970: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_RO_Service_Code';
971: lc_api_version CONSTANT NUMBER := 1.0;
972:
973: -- VARIABLES --

Line 1026: CSD_RO_SERVICE_CODES_PKG.Delete_Row

1022: end if;
1023:
1024: BEGIN
1025:
1026: CSD_RO_SERVICE_CODES_PKG.Delete_Row
1027: (p_ro_service_code_id => p_ro_service_code_id);
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN

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

1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF ( lc_excep_level >= lc_debug_level) THEN
1032: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1033: END IF;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END;
1036:

Line 1163: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.lock_ro_service_code';

1159: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1160: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1161: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1162: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1163: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_service_codes_pvt.lock_ro_service_code';
1164: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_RO_Service_Code';
1165: lc_api_version CONSTANT NUMBER := 1.0;
1166:
1167: -- VARIABLES --

Line 1226: CSD_RO_SERVICE_CODES_PKG.Lock_Row

1222: end if;
1223:
1224: BEGIN
1225:
1226: CSD_RO_SERVICE_CODES_PKG.Lock_Row
1227: (p_ro_service_code_id => p_ro_service_code_rec.ro_service_code_id,
1228: p_object_version_number => p_ro_service_code_rec.object_version_number
1229:
1230: --commented out the rest of the record

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

1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: IF ( lc_excep_level >= lc_debug_level) THEN
1267: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_SERVICE_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1268: END IF;
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: END;
1271:

Line 1372: End CSD_RO_SERVICE_CODES_PVT;

1368: END IF;
1369:
1370: END Lock_RO_Service_Code;
1371:
1372: End CSD_RO_SERVICE_CODES_PVT;