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 FND_LOG

Line 27: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

23: x_ro_diagnostic_code_id OUT NOCOPY NUMBER
24: ) IS
25:
26: -- CONSTANTS --
27: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
30: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
31: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 28: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

24: ) IS
25:
26: -- CONSTANTS --
27: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

25:
26: -- CONSTANTS --
27: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 30: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

26: -- CONSTANTS --
27: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 31: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

27: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 32: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

28: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 33: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

29: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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:

Line 67: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF (lc_proc_level >= lc_debug_level) THEN
67: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
68: 'Entered Create_RO_Diagnostic_Code');
69: END IF;
70:
71: -- log parameters

Line 84: FND_LOG.STRING(lc_proc_level, lc_mod_name,

80: -- Api body starts
81:
82: -- Check the required parameters
83: if (lc_proc_level >= lc_debug_level) then
84: FND_LOG.STRING(lc_proc_level, lc_mod_name,
85: 'Checking required parameters');
86: end if;
87:
88: -- Check the required parameter

Line 108: FND_LOG.STRING(lc_proc_level, lc_mod_name,

104: p_api_name => lc_api_name);
105:
106: -- Validate the repair line ID
107: if (lc_proc_level >= lc_debug_level) then
108: FND_LOG.STRING(lc_proc_level, lc_mod_name,
109: 'Validate repair line id');
110: end if;
111:
112: -- Validate the repair line ID

Line 120: FND_LOG.STRING(lc_proc_level, lc_mod_name,

116: END IF;
117:
118: -- Validate the ro association for diagnostic code
119: if (lc_proc_level >= lc_debug_level) then
120: FND_LOG.STRING(lc_proc_level, lc_mod_name,
121: 'Validate if the ro association for diagnostic code exists');
122: end if;
123:
124: -- Validate the ro association for diagnostic code

Line 149: FND_LOG.STRING(lc_stat_level, lc_mod_name,

145: IF (l_dummy = 'X') then
146: RAISE CSD_RDC_ASSOCIATION_EXISTS;
147: ELSE
148: if (lc_stat_level >= lc_debug_level) then
149: FND_LOG.STRING(lc_stat_level, lc_mod_name,
150: 'RO diagnostic code association already exists');
151: end if;
152: END IF;
153:

Line 156: FND_LOG.STRING(lc_proc_level, lc_mod_name,

152: END IF;
153:
154: -- Insert row
155: if (lc_proc_level >= lc_debug_level) then
156: FND_LOG.STRING(lc_proc_level, lc_mod_name,
157: 'Calling Insert_Row table handler');
158: end if;
159:
160: BEGIN

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 205: FND_LOG.STRING(lc_proc_level, lc_mod_name,

201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: if (lc_proc_level >= lc_debug_level) then
205: FND_LOG.STRING(lc_proc_level, lc_mod_name,
206: 'Returned from Insert_Row table handler');
207: end if;
208:
209: -- Api body ends here

Line 222: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

218: (p_count => x_msg_count,
219: p_data => x_msg_data );
220:
221: IF (lc_proc_level >= lc_debug_level) THEN
222: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
223: 'Leaving Create_RO_Diagnostic_Code');
224: END IF;
225:
226: EXCEPTION

Line 235: FND_LOG.STRING(lc_stat_level, lc_mod_name,

231: x_return_status := FND_API.G_RET_STS_ERROR ;
232:
233: -- save message in fnd stack
234: if (lc_stat_level >= lc_debug_level) then
235: FND_LOG.STRING(lc_stat_level, lc_mod_name,
236: 'Adding message CSD_RDC_ASSOCIATION_EXISTS to FND_MSG stack');
237: end if;
238: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_ASSOCIATION_EXISTS');
239: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.diagnostic_code_id);

Line 248: FND_LOG.STRING(lc_excep_level, lc_mod_name,

244: p_data => x_msg_data );
245:
246: -- save message in debug log
247: IF (lc_excep_level >= lc_debug_level) THEN
248: FND_LOG.STRING(lc_excep_level, lc_mod_name,
249: 'RO diagnostic code already exists');
250: END IF;
251:
252: WHEN FND_API.G_EXC_ERROR THEN

Line 263: FND_LOG.STRING(lc_excep_level, lc_mod_name,

259: p_data => x_msg_data );
260:
261: -- save message in debug log
262: IF (lc_excep_level >= lc_debug_level) THEN
263: FND_LOG.STRING(lc_excep_level, lc_mod_name,
264: 'EXC_ERROR['||x_msg_data||']');
265: END IF;
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 276: FND_LOG.STRING(lc_stat_level, lc_mod_name,

272: IF FND_MSG_PUB.Check_Msg_Level
273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
274: THEN
275: if (lc_stat_level >= lc_debug_level) then
276: FND_LOG.STRING(lc_stat_level, lc_mod_name,
277: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
278: end if;
279: FND_MSG_PUB.Add_Exc_Msg
280: (G_PKG_NAME ,

Line 290: FND_LOG.STRING(lc_excep_level, lc_mod_name,

286: p_data => x_msg_data );
287:
288: -- save message in debug log
289: IF (lc_excep_level >= lc_debug_level) THEN
290: FND_LOG.STRING(lc_excep_level, lc_mod_name,
291: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
292: END IF;
293:
294: WHEN OTHERS THEN

Line 304: FND_LOG.STRING(lc_stat_level, lc_mod_name,

300: IF FND_MSG_PUB.Check_Msg_Level
301: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
302: THEN
303: if (lc_stat_level >= lc_debug_level) then
304: FND_LOG.STRING(lc_stat_level, lc_mod_name,
305: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
306: end if;
307: FND_MSG_PUB.Add_Exc_Msg
308: (G_PKG_NAME ,

Line 319: FND_LOG.STRING(lc_excep_level, lc_mod_name,

315:
316: -- save message in debug log
317: IF (lc_excep_level >= lc_debug_level) THEN
318: -- create a seeded message
319: FND_LOG.STRING(lc_excep_level, lc_mod_name,
320: 'SQL Message['||sqlerrm||']' );
321: END IF;
322:
323: END Create_RO_Diagnostic_Code;

Line 345: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

341: x_obj_ver_number OUT NOCOPY NUMBER
342: )IS
343:
344: -- CONSTANTS --
345: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
346: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
348: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
349: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 346: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

342: )IS
343:
344: -- CONSTANTS --
345: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
346: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

343:
344: -- CONSTANTS --
345: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
346: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 348: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

344: -- CONSTANTS --
345: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
346: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 349: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

345: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
346: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 350: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

346: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 351: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

347: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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:

Line 390: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: IF (lc_proc_level >= lc_debug_level) THEN
390: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
391: 'Entered Update_RO_Diagnostic_Code');
392: END IF;
393:
394: -- log parameters

Line 407: FND_LOG.STRING(lc_proc_level, lc_mod_name,

403: -- Api body starts
404:
405: -- Check the required parameters
406: if (lc_proc_level >= lc_debug_level) then
407: FND_LOG.STRING(lc_proc_level, lc_mod_name,
408: 'Checking required parameters');
409: end if;
410:
411: -- Check the required parameter

Line 435: FND_LOG.STRING(lc_proc_level, lc_mod_name,

431: END IF;
432:
433: -- Validate the ro diagnostic code association
434: if (lc_proc_level >= lc_debug_level) then
435: FND_LOG.STRING(lc_proc_level, lc_mod_name,
436: 'Validate the id for ro diagnostic code');
437: end if;
438:
439: -- Validate the ro diagnostic code association

Line 460: FND_LOG.STRING(lc_stat_level, lc_mod_name,

456: IF (l_dummy <> 'X') then
457: RAISE CSD_RDC_INVALID_ID;
458: ELSE
459: if (lc_stat_level >= lc_debug_level) then
460: FND_LOG.STRING(lc_stat_level, lc_mod_name,
461: 'RO diagnostic code association is valid');
462: end if;
463: END IF;
464:

Line 467: FND_LOG.STRING(lc_proc_level, lc_mod_name,

463: END IF;
464:
465: -- Get the object version number for ro diagnostic code association
466: if (lc_proc_level >= lc_debug_level) then
467: FND_LOG.STRING(lc_proc_level, lc_mod_name,
468: 'Get object version number for ro diagnostic code association');
469: end if;
470:
471: -- Get object version number for ro diagnostic code

Line 490: FND_LOG.STRING(lc_stat_level, lc_mod_name,

486: IF (l_obj_ver_num is null) then
487: RAISE CSD_RDC_GET_OVN_ERROR;
488: ELSE
489: if (lc_stat_level >= lc_debug_level) then
490: FND_LOG.STRING(lc_stat_level, lc_mod_name,
491: 'Retrieved object version number');
492: end if;
493: END IF;
494:

Line 497: FND_LOG.STRING(lc_proc_level, lc_mod_name,

493: END IF;
494:
495: -- Validate the object version number for ro diagnostic code association
496: if (lc_proc_level >= lc_debug_level) then
497: FND_LOG.STRING(lc_proc_level, lc_mod_name,
498: 'Validate object version number for ro diagnostic code association');
499: end if;
500:
501: -- Validate if object version number for ro diagnostic code is same as the one passed in

Line 506: FND_LOG.STRING(lc_stat_level, lc_mod_name,

502: IF NVL(p_ro_diagnostic_code_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN
503: RAISE CSD_RDC_OVN_MISMATCH;
504: ELSE
505: if (lc_stat_level >= lc_debug_level) then
506: FND_LOG.STRING(lc_stat_level, lc_mod_name,
507: 'Object version number is valid');
508: end if;
509: END IF;
510:

Line 513: FND_LOG.STRING(lc_proc_level, lc_mod_name,

509: END IF;
510:
511: -- Validate the repair line id if it is passed in
512: if (lc_proc_level >= lc_debug_level) then
513: FND_LOG.STRING(lc_proc_level, lc_mod_name,
514: 'Validate repair line id if it is passed in');
515: end if;
516:
517: -- Validate the repair line ID

Line 527: FND_LOG.STRING(lc_proc_level, lc_mod_name,

523: END IF;
524:
525: -- Validate the ro association for diagnostic code
526: if (lc_proc_level >= lc_debug_level) then
527: FND_LOG.STRING(lc_proc_level, lc_mod_name,
528: 'Validate if the ro association for diagnostic code exists');
529: end if;
530:
531: -- Validate the ro association for diagnostic code

Line 558: FND_LOG.STRING(lc_stat_level, lc_mod_name,

554: IF (l_dummy = 'X') then
555: RAISE CSD_RDC_ASSOCIATION_EXISTS;
556: ELSE
557: if (lc_stat_level >= lc_debug_level) then
558: FND_LOG.STRING(lc_stat_level, lc_mod_name,
559: 'RO diagnostic code association already exists');
560: end if;
561: END IF;
562:

Line 565: FND_LOG.STRING(lc_proc_level, lc_mod_name,

561: END IF;
562:
563: -- Update row
564: if (lc_proc_level >= lc_debug_level) then
565: FND_LOG.STRING(lc_proc_level, lc_mod_name,
566: 'Calling Update_Row table handler');
567: end if;
568:
569: BEGIN

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 616: FND_LOG.STRING(lc_proc_level, lc_mod_name,

612: RAISE FND_API.G_EXC_ERROR;
613: END IF;
614:
615: if (lc_proc_level >= lc_debug_level) then
616: FND_LOG.STRING(lc_proc_level, lc_mod_name,
617: 'Returned from Update_Row table handler');
618: end if;
619:
620: -- Api body ends here

Line 633: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

629: (p_count => x_msg_count,
630: p_data => x_msg_data );
631:
632: IF (lc_proc_level >= lc_debug_level) THEN
633: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
634: 'Leaving Update_RO_Diagnostic_Code');
635: END IF;
636:
637: EXCEPTION

Line 646: FND_LOG.STRING(lc_stat_level, lc_mod_name,

642: x_return_status := FND_API.G_RET_STS_ERROR ;
643:
644: -- save message in fnd stack
645: if (lc_stat_level >= lc_debug_level) then
646: FND_LOG.STRING(lc_stat_level, lc_mod_name,
647: 'Adding message CSD_RDC_RO_ID_MISSING to FND_MSG stack');
648: end if;
649: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
650: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 660: FND_LOG.STRING(lc_excep_level, lc_mod_name,

656: p_data => x_msg_data );
657:
658: -- save message in debug log
659: IF (lc_excep_level >= lc_debug_level) THEN
660: FND_LOG.STRING(lc_excep_level, lc_mod_name,
661: 'Repair line id is missing');
662: END IF;
663:
664: WHEN CSD_RDC_DC_ID_MISSING THEN

Line 671: FND_LOG.STRING(lc_stat_level, lc_mod_name,

667: x_return_status := FND_API.G_RET_STS_ERROR ;
668:
669: -- save message in fnd stack
670: if (lc_stat_level >= lc_debug_level) then
671: FND_LOG.STRING(lc_stat_level, lc_mod_name,
672: 'Adding message CSD_RDC_DC_ID_MISSING to FND_MSG stack');
673: end if;
674: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
675: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 685: FND_LOG.STRING(lc_excep_level, lc_mod_name,

681: p_data => x_msg_data );
682:
683: -- save message in debug log
684: IF (lc_excep_level >= lc_debug_level) THEN
685: FND_LOG.STRING(lc_excep_level, lc_mod_name,
686: 'Diagnostic code id is missing');
687: END IF;
688:
689: WHEN CSD_RDC_ASSOCIATION_EXISTS THEN

Line 697: FND_LOG.STRING(lc_stat_level, lc_mod_name,

693: x_return_status := FND_API.G_RET_STS_ERROR ;
694:
695: -- save message in fnd stack
696: if (lc_stat_level >= lc_debug_level) then
697: FND_LOG.STRING(lc_stat_level, lc_mod_name,
698: 'Adding message CSD_RDC_ASSOCIATION_EXISTS to FND_MSG stack');
699: end if;
700: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_ASSOCIATION_EXISTS');
701: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.diagnostic_code_id);

Line 710: FND_LOG.STRING(lc_excep_level, lc_mod_name,

706: p_data => x_msg_data );
707:
708: -- save message in debug log
709: IF (lc_excep_level >= lc_debug_level) THEN
710: FND_LOG.STRING(lc_excep_level, lc_mod_name,
711: 'RO diagnostic code already exists');
712: END IF;
713:
714: WHEN CSD_RDC_INVALID_ID THEN

Line 722: FND_LOG.STRING(lc_stat_level, lc_mod_name,

718: x_return_status := FND_API.G_RET_STS_ERROR ;
719:
720: -- save message in fnd stack
721: if (lc_stat_level >= lc_debug_level) then
722: FND_LOG.STRING(lc_stat_level, lc_mod_name,
723: 'Adding message CSD_RDC_INVALID_ID to FND_MSG stack');
724: end if;
725: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_INVALID_ID');
726: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);

Line 735: FND_LOG.STRING(lc_excep_level, lc_mod_name,

731: p_data => x_msg_data );
732:
733: -- save message in debug log
734: IF (lc_excep_level >= lc_debug_level) THEN
735: FND_LOG.STRING(lc_excep_level, lc_mod_name,
736: 'RO diagnostic code id is invalid');
737: END IF;
738:
739: WHEN CSD_RDC_GET_OVN_ERROR THEN

Line 747: FND_LOG.STRING(lc_stat_level, lc_mod_name,

743: x_return_status := FND_API.G_RET_STS_ERROR ;
744:
745: -- save message in fnd stack
746: if (lc_stat_level >= lc_debug_level) then
747: FND_LOG.STRING(lc_stat_level, lc_mod_name,
748: 'Adding message CSD_RDC_GET_OVN_ERROR to FND_MSG stack');
749: end if;
750: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_GET_OVN_ERROR');
751: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);

Line 760: FND_LOG.STRING(lc_excep_level, lc_mod_name,

756: p_data => x_msg_data );
757:
758: -- save message in debug log
759: IF (lc_excep_level >= lc_debug_level) THEN
760: FND_LOG.STRING(lc_excep_level, lc_mod_name,
761: 'RO diagnostic code get object version number error');
762: END IF;
763:
764: WHEN CSD_RDC_OVN_MISMATCH THEN

Line 772: FND_LOG.STRING(lc_stat_level, lc_mod_name,

768: x_return_status := FND_API.G_RET_STS_ERROR ;
769:
770: -- save message in fnd stack
771: if (lc_stat_level >= lc_debug_level) then
772: FND_LOG.STRING(lc_stat_level, lc_mod_name,
773: 'Adding message CSD_RDC_OVN_MISMATCH to FND_MSG stack');
774: end if;
775: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_OVN_MISMATCH');
776: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);

Line 785: FND_LOG.STRING(lc_excep_level, lc_mod_name,

781: p_data => x_msg_data );
782:
783: -- save message in debug log
784: IF (lc_excep_level >= lc_debug_level) THEN
785: FND_LOG.STRING(lc_excep_level, lc_mod_name,
786: 'RO diagnostic code object version number mismatch');
787: END IF;
788:
789: WHEN FND_API.G_EXC_ERROR THEN

Line 800: FND_LOG.STRING(lc_excep_level, lc_mod_name,

796: p_data => x_msg_data );
797:
798: -- save message in debug log
799: IF (lc_excep_level >= lc_debug_level) THEN
800: FND_LOG.STRING(lc_excep_level, lc_mod_name,
801: 'EXC_ERROR['||x_msg_data||']');
802: END IF;
803:
804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 813: FND_LOG.STRING(lc_stat_level, lc_mod_name,

809: IF FND_MSG_PUB.Check_Msg_Level
810: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: if (lc_stat_level >= lc_debug_level) then
813: FND_LOG.STRING(lc_stat_level, lc_mod_name,
814: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
815: end if;
816: FND_MSG_PUB.Add_Exc_Msg
817: (G_PKG_NAME ,

Line 827: FND_LOG.STRING(lc_excep_level, lc_mod_name,

823: p_data => x_msg_data );
824:
825: -- save message in debug log
826: IF (lc_excep_level >= lc_debug_level) THEN
827: FND_LOG.STRING(lc_excep_level, lc_mod_name,
828: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
829: END IF;
830:
831: WHEN OTHERS THEN

Line 841: FND_LOG.STRING(lc_stat_level, lc_mod_name,

837: IF FND_MSG_PUB.Check_Msg_Level
838: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: if (lc_stat_level >= lc_debug_level) then
841: FND_LOG.STRING(lc_stat_level, lc_mod_name,
842: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
843: end if;
844: FND_MSG_PUB.Add_Exc_Msg
845: (G_PKG_NAME ,

Line 856: FND_LOG.STRING(lc_excep_level, lc_mod_name,

852:
853: -- save message in debug log
854: IF (lc_excep_level >= lc_debug_level) THEN
855: -- create a seeded message
856: FND_LOG.STRING(lc_excep_level, lc_mod_name,
857: 'SQL Message['||sqlerrm||']' );
858: END IF;
859:
860: END Update_RO_Diagnostic_Code;

Line 882: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

878: p_ro_diagnostic_code_id IN NUMBER
879: ) IS
880:
881: -- CONSTANTS --
882: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
883: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
885: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
886: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 883: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

879: ) IS
880:
881: -- CONSTANTS --
882: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
883: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

880:
881: -- CONSTANTS --
882: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
883: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 885: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

881: -- CONSTANTS --
882: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
883: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 886: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

882: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
883: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 887: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

883: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 888: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

884: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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:

Line 917: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

913: FND_MSG_PUB.initialize;
914: END IF;
915:
916: IF (lc_proc_level >= lc_debug_level) THEN
917: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
918: 'Entered Delete_RO_Diagnostic_Code');
919: END IF;
920:
921: -- Initialize API return status to success

Line 928: FND_LOG.STRING(lc_proc_level, lc_mod_name,

924: -- Api body starts
925:
926: -- Check the required parameters
927: if (lc_proc_level >= lc_debug_level) then
928: FND_LOG.STRING(lc_proc_level, lc_mod_name,
929: 'Checking required parameter');
930: end if;
931:
932: -- Check the required parameter

Line 940: FND_LOG.STRING(lc_proc_level, lc_mod_name,

936: p_api_name => lc_api_name);
937:
938: -- Delete row
939: if (lc_proc_level >= lc_debug_level) then
940: FND_LOG.STRING(lc_proc_level, lc_mod_name,
941: 'Calling Delete_Row table handler');
942: end if;
943:
944: BEGIN

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 963: FND_LOG.STRING(lc_proc_level, lc_mod_name,

959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961:
962: if (lc_proc_level >= lc_debug_level) then
963: FND_LOG.STRING(lc_proc_level, lc_mod_name,
964: 'Returned from Delete_Row table handler');
965: end if;
966:
967: -- Api body ends here

Line 980: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

976: (p_count => x_msg_count,
977: p_data => x_msg_data );
978:
979: IF (lc_proc_level >= lc_debug_level) THEN
980: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
981: 'Leaving Delete_RO_Diagnostic_Code');
982: END IF;
983:
984: EXCEPTION

Line 996: FND_LOG.STRING(lc_excep_level, lc_mod_name,

992: p_data => x_msg_data );
993:
994: -- save message in debug log
995: IF (lc_excep_level >= lc_debug_level) THEN
996: FND_LOG.STRING(lc_excep_level, lc_mod_name,
997: 'EXC_ERROR['||x_msg_data||']');
998: END IF;
999:
1000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1009: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1005: IF FND_MSG_PUB.Check_Msg_Level
1006: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: if (lc_stat_level >= lc_debug_level) then
1009: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1010: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1011: end if;
1012: FND_MSG_PUB.Add_Exc_Msg
1013: (G_PKG_NAME ,

Line 1023: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1019: p_data => x_msg_data );
1020:
1021: -- save message in debug log
1022: IF (lc_excep_level >= lc_debug_level) THEN
1023: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1024: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1025: END IF;
1026:
1027: WHEN OTHERS THEN

Line 1037: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1033: IF FND_MSG_PUB.Check_Msg_Level
1034: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1035: THEN
1036: if (lc_stat_level >= lc_debug_level) then
1037: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1038: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1039: end if;
1040: FND_MSG_PUB.Add_Exc_Msg
1041: (G_PKG_NAME ,

Line 1052: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1048:
1049: -- save message in debug log
1050: IF (lc_excep_level >= lc_debug_level) THEN
1051: -- create a seeded message
1052: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1053: 'SQL Message['||sqlerrm||']' );
1054: END IF;
1055:
1056: END Delete_RO_Diagnostic_Code;

Line 1077: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1073: p_ro_diagnostic_code_rec IN RO_DIAGNOSTIC_CODE_REC_TYPE
1074: )IS
1075:
1076: -- CONSTANTS --
1077: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1078: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1080: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1081: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 1078: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1074: )IS
1075:
1076: -- CONSTANTS --
1077: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1078: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

1075:
1076: -- CONSTANTS --
1077: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1078: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 1080: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

1076: -- CONSTANTS --
1077: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1078: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 1081: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

1077: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1078: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

Line 1082: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

1078: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

Line 1083: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1079: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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:

Line 1112: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

1108: FND_MSG_PUB.initialize;
1109: END IF;
1110:
1111: IF (lc_proc_level >= lc_debug_level) THEN
1112: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
1113: 'Entered Lock_RO_Diagnostic_Code');
1114: END IF;
1115:
1116: -- Initialize API return status to success

Line 1123: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1119: -- Api body starts
1120:
1121: -- Check the required parameters
1122: if (lc_proc_level >= lc_debug_level) then
1123: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1124: 'Checking required parameters');
1125: end if;
1126: -- Check the required parameter
1127: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 1140: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1136: p_api_name => lc_api_name);
1137:
1138: -- Lock row
1139: if (lc_proc_level >= lc_debug_level) then
1140: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1141: 'Calling Lock_Row table handler');
1142: end if;
1143:
1144: BEGIN

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 1193: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1189: RAISE FND_API.G_EXC_ERROR;
1190: END IF;
1191:
1192: if (lc_proc_level >= lc_debug_level) then
1193: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1194: 'Returned from Lock_Row table handler');
1195: end if;
1196:
1197: -- Api body ends here

Line 1210: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

1206: (p_count => x_msg_count,
1207: p_data => x_msg_data );
1208:
1209: IF (lc_proc_level >= lc_debug_level) THEN
1210: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1211: 'Leaving Lock_RO_Diagnostic_Code');
1212: END IF;
1213:
1214: EXCEPTION

Line 1226: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1222: p_data => x_msg_data );
1223:
1224: -- save message in debug log
1225: IF (lc_excep_level >= lc_debug_level) THEN
1226: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1227: 'EXC_ERROR['||x_msg_data||']');
1228: END IF;
1229:
1230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1239: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1235: IF FND_MSG_PUB.Check_Msg_Level
1236: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: THEN
1238: if (lc_stat_level >= lc_debug_level) then
1239: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1240: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1241: end if;
1242: FND_MSG_PUB.Add_Exc_Msg
1243: (G_PKG_NAME ,

Line 1253: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1249: p_data => x_msg_data );
1250:
1251: -- save message in debug log
1252: IF (lc_excep_level >= lc_debug_level) THEN
1253: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1254: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1255: END IF;
1256:
1257: WHEN OTHERS THEN

Line 1267: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1263: IF FND_MSG_PUB.Check_Msg_Level
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: if (lc_stat_level >= lc_debug_level) then
1267: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1268: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1269: end if;
1270: FND_MSG_PUB.Add_Exc_Msg
1271: (G_PKG_NAME ,

Line 1282: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1278:
1279: -- save message in debug log
1280: IF (lc_excep_level >= lc_debug_level) THEN
1281: -- create a seeded message
1282: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1283: 'SQL Message['||sqlerrm||']' );
1284: END IF;
1285:
1286: END Lock_RO_Diagnostic_Code;