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_DIAGNOSTIC_CODES_PVT dependencies on CSD_RO_DIAGNOSTIC_CODES

Line 1: PACKAGE BODY CSD_RO_DIAGNOSTIC_CODES_PVT as

1: PACKAGE BODY CSD_RO_DIAGNOSTIC_CODES_PVT as
2: /* $Header: csdvrdcb.pls 120.1 2006/09/20 00:18:42 rfieldma noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_DIAGNOSTIC_CODES_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrdcb.pls';

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

1: PACKAGE BODY CSD_RO_DIAGNOSTIC_CODES_PVT as
2: /* $Header: csdvrdcb.pls 120.1 2006/09/20 00:18:42 rfieldma noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_DIAGNOSTIC_CODES_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrdcb.pls';
6:
7: /*--------------------------------------------------*/
8: /* procedure name: Create_RO_Diagnostic_Code */

Line 34: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_diagnostic_codes_pvt.create_ro_diagnostic_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_diagnostic_codes_pvt.create_ro_diagnostic_code';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_RO_Diagnostic_Code';
36: lc_api_version CONSTANT NUMBER := 1.0;
37:
38: -- VARIABLES --

Line 130: from csd_ro_diagnostic_codes

126: l_dummy := null;
127:
128: select 'X'
129: into l_dummy
130: from csd_ro_diagnostic_codes
131: where repair_line_id = p_ro_diagnostic_code_rec.repair_line_id
132: and diagnostic_code_id = p_ro_diagnostic_code_rec.diagnostic_code_id;
133:
134: Exception

Line 163: CSD_RO_DIAGNOSTIC_CODES_PKG.Insert_Row

159:
160: BEGIN
161:
162: -- Insert the ro diagnostic code association
163: CSD_RO_DIAGNOSTIC_CODES_PKG.Insert_Row
164: (px_ro_diagnostic_code_id => x_ro_diagnostic_code_id,
165: p_object_version_number => l_obj_ver_num,
166: p_repair_line_id => p_ro_diagnostic_code_rec.repair_line_id,
167: p_diagnostic_code_id => p_ro_diagnostic_code_rec.diagnostic_code_id,

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

191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: IF ( lc_excep_level >= lc_debug_level) THEN
195: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_DIAGNOSTIC_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
196: END IF;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: END;
199:

Line 352: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_diagnostic_codes_pvt.update_ro_diagnostic_code';

348: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
349: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
350: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
351: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
352: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_diagnostic_codes_pvt.update_ro_diagnostic_code';
353: lc_api_name CONSTANT VARCHAR2(30) := 'Update_RO_Diagnostic_Code';
354: lc_api_version CONSTANT NUMBER := 1.0;
355:
356: -- VARIABLES --

Line 445: from csd_ro_diagnostic_codes

441: l_dummy := null;
442:
443: select 'X'
444: into l_dummy
445: from csd_ro_diagnostic_codes
446: where ro_diagnostic_code_id = p_ro_diagnostic_code_rec.ro_diagnostic_code_id;
447:
448: Exception
449:

Line 475: from csd_ro_diagnostic_codes

471: -- Get object version number for ro diagnostic code
472: Begin
473: select object_version_number
474: into l_obj_ver_num
475: from csd_ro_diagnostic_codes
476: where ro_diagnostic_code_id = p_ro_diagnostic_code_rec.ro_diagnostic_code_id;
477:
478: Exception
479:

Line 538: from csd_ro_diagnostic_codes

534: l_dummy := null;
535:
536: select 'X'
537: into l_dummy
538: from csd_ro_diagnostic_codes
539: where ro_diagnostic_code_id <> p_ro_diagnostic_code_rec.ro_diagnostic_code_id
540: and repair_line_id = p_ro_diagnostic_code_rec.repair_line_id
541: and diagnostic_code_id = p_ro_diagnostic_code_rec.diagnostic_code_id;
542:

Line 572: CSD_RO_DIAGNOSTIC_CODES_PKG.Update_Row

568:
569: BEGIN
570:
571: -- Update the ro diagnostic code association
572: CSD_RO_DIAGNOSTIC_CODES_PKG.Update_Row
573: (p_ro_diagnostic_code_id => p_ro_diagnostic_code_rec.ro_diagnostic_code_id,
574: p_object_version_number => l_obj_ver_num + 1,
575: p_repair_line_id => p_ro_diagnostic_code_rec.repair_line_id,
576: p_diagnostic_code_id => p_ro_diagnostic_code_rec.diagnostic_code_id,

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

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

Line 889: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_diagnostic_codes_pvt.delete_ro_diagnostic_code';

885: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
886: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
887: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
888: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
889: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_diagnostic_codes_pvt.delete_ro_diagnostic_code';
890: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_RO_Diagnostic_Code';
891: lc_api_version CONSTANT NUMBER := 1.0;
892:
893: -- VARIABLES --

Line 947: CSD_RO_DIAGNOSTIC_CODES_PKG.Delete_Row

943:
944: BEGIN
945:
946: -- Delete the ro diagnostic code association
947: CSD_RO_DIAGNOSTIC_CODES_PKG.Delete_Row
948: (p_ro_diagnostic_code_id => p_ro_diagnostic_code_id);
949:
950: EXCEPTION
951: WHEN OTHERS THEN

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

949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF ( lc_excep_level >= lc_debug_level) THEN
953: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_DIAGNOSTIC_CODES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
954: END IF;
955: x_return_status := FND_API.G_RET_STS_ERROR;
956: END;
957:

Line 1084: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_diagnostic_codes_pvt.lock_ro_diagnostic_code';

1080: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1081: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1082: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1083: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1084: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_ro_diagnostic_codes_pvt.lock_ro_diagnostic_code';
1085: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_RO_Diagnostic_Code';
1086: lc_api_version CONSTANT NUMBER := 1.0;
1087:
1088: -- VARIABLES --

Line 1147: CSD_RO_DIAGNOSTIC_CODES_PKG.Lock_Row

1143:
1144: BEGIN
1145:
1146: -- Lock the ro diagnostic code association
1147: CSD_RO_DIAGNOSTIC_CODES_PKG.Lock_Row
1148: (p_ro_diagnostic_code_id => p_ro_diagnostic_code_rec.ro_diagnostic_code_id,
1149: p_object_version_number => p_ro_diagnostic_code_rec.object_version_number
1150:
1151: --commented out the rest of the record

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

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: IF ( lc_excep_level >= lc_debug_level) THEN
1183: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_RO_DIAGNOSTIC_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1184: END IF;
1185: x_return_status := FND_API.G_RET_STS_ERROR;
1186: END;
1187:

Line 1288: End CSD_RO_DIAGNOSTIC_CODES_PVT;

1284: END IF;
1285:
1286: END Lock_RO_Diagnostic_Code;
1287:
1288: End CSD_RO_DIAGNOSTIC_CODES_PVT;