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

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

23: x_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_diagnostic_codes_pvt.create_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_diagnostic_codes_pvt.create_diagnostic_code';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_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_diagnostic_codes_pvt.create_diagnostic_code';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_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_diagnostic_codes_pvt.create_diagnostic_code';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_Diagnostic_Code';
36: lc_api_version CONSTANT NUMBER := 1.0;
37:

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

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

Line 85: FND_LOG.STRING(lc_proc_level, lc_mod_name,

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

Line 103: FND_LOG.STRING(lc_proc_level, lc_mod_name,

99: p_api_name => lc_api_name);
100:
101: -- Validate the code for diagnostic code
102: if (lc_proc_level >= lc_debug_level) then
103: FND_LOG.STRING(lc_proc_level, lc_mod_name,
104: 'Validate if the code of diagnostic code already exists');
105: end if;
106:
107: Begin

Line 128: FND_LOG.STRING(lc_stat_level, lc_mod_name,

124: IF (l_dummy = 'X') then
125: RAISE CSD_DC_CODE_EXISTS;
126: ELSE
127: if (lc_stat_level >= lc_debug_level) then
128: FND_LOG.STRING(lc_stat_level, lc_mod_name,
129: 'Diagnostic code does not exist');
130: end if;
131: END IF;
132:

Line 135: FND_LOG.STRING(lc_proc_level, lc_mod_name,

131: END IF;
132:
133: -- Insert row
134: if (lc_proc_level >= lc_debug_level) then
135: FND_LOG.STRING(lc_proc_level, lc_mod_name,
136: 'Calling Insert_Row table handler');
137: end if;
138:
139: Begin

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

173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: IF ( lc_excep_level >= lc_debug_level) THEN
177: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DIAGNOSTIC_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
178: END IF;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: END;
181:

Line 187: FND_LOG.STRING(lc_proc_level, lc_mod_name,

183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: if (lc_proc_level >= lc_debug_level) then
187: FND_LOG.STRING(lc_proc_level, lc_mod_name,
188: 'Returned from Insert_Row table handler');
189: end if;
190:
191: -- Api body ends here

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

200: (p_count => x_msg_count,
201: p_data => x_msg_data );
202:
203: IF (lc_proc_level >= lc_debug_level) THEN
204: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
205: 'Leaving Create_Diagnostic_Code');
206: END IF;
207:
208: EXCEPTION

Line 216: FND_LOG.STRING(lc_stat_level, lc_mod_name,

212: x_return_status := FND_API.G_RET_STS_ERROR ;
213:
214: -- save message in fnd stack
215: if (lc_stat_level >= lc_debug_level) then
216: FND_LOG.STRING(lc_stat_level, lc_mod_name,
217: 'Adding message CSD_DC_CODE_EXISTS to FND_MSG stack');
218: end if;
219: FND_MESSAGE.SET_NAME('CSD','CSD_DC_CODE_EXISTS');
220: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE',p_diagnostic_code_rec.diagnostic_code);

Line 228: FND_LOG.STRING(lc_excep_level, lc_mod_name,

224: p_data => x_msg_data );
225:
226: -- save message in debug log
227: IF (lc_excep_level >= lc_debug_level) THEN
228: FND_LOG.STRING(lc_excep_level, lc_mod_name,
229: 'Diagnostic code already exists');
230: END IF;
231:
232: WHEN FND_API.G_EXC_ERROR THEN

Line 242: FND_LOG.STRING(lc_excep_level, lc_mod_name,

238: p_data => x_msg_data );
239:
240: -- save message in debug log
241: IF (lc_excep_level >= lc_debug_level) THEN
242: FND_LOG.STRING(lc_excep_level, lc_mod_name,
243: 'EXC_ERROR['||x_msg_data||']');
244: END IF;
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 255: FND_LOG.STRING(lc_stat_level, lc_mod_name,

251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: if (lc_stat_level >= lc_debug_level) then
255: FND_LOG.STRING(lc_stat_level, lc_mod_name,
256: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
257: end if;
258: FND_MSG_PUB.Add_Exc_Msg
259: (G_PKG_NAME ,

Line 269: FND_LOG.STRING(lc_excep_level, lc_mod_name,

265: p_data => x_msg_data );
266:
267: -- save message in debug log
268: IF (lc_excep_level >= lc_debug_level) THEN
269: FND_LOG.STRING(lc_excep_level, lc_mod_name,
270: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
271: END IF;
272:
273: WHEN OTHERS THEN

Line 282: FND_LOG.STRING(lc_stat_level, lc_mod_name,

278: IF FND_MSG_PUB.Check_Msg_Level
279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: if (lc_stat_level >= lc_debug_level) then
282: FND_LOG.STRING(lc_stat_level, lc_mod_name,
283: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
284: end if;
285: FND_MSG_PUB.Add_Exc_Msg
286: (G_PKG_NAME ,

Line 297: FND_LOG.STRING(lc_excep_level, lc_mod_name,

293:
294: -- save message in debug log
295: IF (lc_excep_level >= lc_debug_level) THEN
296: -- create a seeded message
297: FND_LOG.STRING(lc_excep_level, lc_mod_name,
298: 'SQL Message['||sqlerrm||']' );
299: END IF;
300:
301: END Create_Diagnostic_Code;

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

320: x_obj_ver_number OUT NOCOPY NUMBER
321: ) IS
322:
323: -- CONSTANTS --
324: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
325: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
326: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
327: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
328: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

321: ) IS
322:
323: -- CONSTANTS --
324: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
325: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
326: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
327: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
328: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
329: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

322:
323: -- CONSTANTS --
324: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
325: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
326: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
327: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
328: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
329: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
330: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

323: -- CONSTANTS --
324: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
325: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
326: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
327: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
328: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
329: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
330: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
331: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.update_diagnostic_code';

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

324: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
325: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
326: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
327: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
328: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
329: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
330: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
331: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.update_diagnostic_code';
332: lc_api_name CONSTANT VARCHAR2(30) := 'Update_Diagnostic_Code';

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

325: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
326: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
327: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
328: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
329: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
330: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
331: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.update_diagnostic_code';
332: lc_api_name CONSTANT VARCHAR2(30) := 'Update_Diagnostic_Code';
333: lc_api_version CONSTANT NUMBER := 1.0;

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

326: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
327: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
328: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
329: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
330: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
331: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.update_diagnostic_code';
332: lc_api_name CONSTANT VARCHAR2(30) := 'Update_Diagnostic_Code';
333: lc_api_version CONSTANT NUMBER := 1.0;
334:

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

366: FND_MSG_PUB.initialize;
367: END IF;
368:
369: IF (lc_proc_level >= lc_debug_level) THEN
370: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
371: 'Entered Update_Diagnostic_Code');
372: END IF;
373:
374: -- log parameters

Line 387: FND_LOG.STRING(lc_proc_level, lc_mod_name,

383: -- Api body starts
384:
385: -- Check the required parameters
386: if (lc_proc_level >= lc_debug_level) then
387: FND_LOG.STRING(lc_proc_level, lc_mod_name,
388: 'Checking required parameters');
389: end if;
390:
391: -- Check the required parameter

Line 399: FND_LOG.STRING(lc_proc_level, lc_mod_name,

395: p_api_name => lc_api_name);
396:
397: -- Check if required parameter is passed in as G_MISS
398: if (lc_proc_level >= lc_debug_level) then
399: FND_LOG.STRING(lc_proc_level, lc_mod_name,
400: 'Checking if required parameters are passed in as G_MISS');
401: end if;
402:
403: IF (p_diagnostic_code_rec.diagnostic_code = FND_API.G_MISS_CHAR) THEN

Line 414: FND_LOG.STRING(lc_proc_level, lc_mod_name,

410: END IF;
411:
412: -- Validate the id for diagnostic code
413: if (lc_proc_level >= lc_debug_level) then
414: FND_LOG.STRING(lc_proc_level, lc_mod_name,
415: 'Validate the ID for diagnostic code');
416: end if;
417:
418: -- Validate the diagnostic code id

Line 437: FND_LOG.STRING(lc_stat_level, lc_mod_name,

433: IF (l_dummy <> 'X') then
434: RAISE CSD_DC_ID_INVALID;
435: ELSE
436: if (lc_stat_level >= lc_debug_level) then
437: FND_LOG.STRING(lc_stat_level, lc_mod_name,
438: 'Diagnostic code id is valid');
439: end if;
440: END IF;
441:

Line 444: FND_LOG.STRING(lc_proc_level, lc_mod_name,

440: END IF;
441:
442: -- Get the object version number for diagnostic code
443: if (lc_proc_level >= lc_debug_level) then
444: FND_LOG.STRING(lc_proc_level, lc_mod_name,
445: 'Get object version number for diagnostic code');
446: end if;
447:
448: Begin

Line 466: FND_LOG.STRING(lc_stat_level, lc_mod_name,

462: IF (l_obj_ver_num is null) then
463: RAISE CSD_DC_GET_OVN_ERROR;
464: ELSE
465: if (lc_stat_level >= lc_debug_level) then
466: FND_LOG.STRING(lc_stat_level, lc_mod_name,
467: 'Retrieved object version number');
468: end if;
469: END IF;
470:

Line 478: FND_LOG.STRING(lc_proc_level, lc_mod_name,

474: END IF;
475:
476: -- Validate the code for diagnostic code
477: if (lc_proc_level >= lc_debug_level) then
478: FND_LOG.STRING(lc_proc_level, lc_mod_name,
479: 'Validate if the code of the diagnostic code already exists ');
480: end if;
481:
482: Begin

Line 507: FND_LOG.STRING(lc_stat_level, lc_mod_name,

503: IF (l_dummy = 'X') then
504: RAISE CSD_DC_CODE_EXISTS;
505: ELSE
506: if (lc_stat_level >= lc_debug_level) then
507: FND_LOG.STRING(lc_stat_level, lc_mod_name,
508: 'Diagnostic code does not exist');
509: end if;
510: END IF;
511:

Line 514: FND_LOG.STRING(lc_proc_level, lc_mod_name,

510: END IF;
511:
512: -- Update row
513: if (lc_proc_level >= lc_debug_level) then
514: FND_LOG.STRING(lc_proc_level, lc_mod_name,
515: 'Calling Update_Row table handler');
516: end if;
517:
518: Begin

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

553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF ( lc_excep_level >= lc_debug_level) THEN
557: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DIAGNOSTIC_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
558: END IF;
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END;
561:

Line 567: FND_LOG.STRING(lc_proc_level, lc_mod_name,

563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566: if (lc_proc_level >= lc_debug_level) then
567: FND_LOG.STRING(lc_proc_level, lc_mod_name,
568: 'Returned from Update_Row table handler');
569: end if;
570:
571: -- Api body ends here

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

580: (p_count => x_msg_count,
581: p_data => x_msg_data );
582:
583: IF (lc_proc_level >= lc_debug_level) THEN
584: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
585: 'Leaving Update_Diagnostic_Code');
586: END IF;
587:
588: EXCEPTION

Line 597: FND_LOG.STRING(lc_stat_level, lc_mod_name,

593: x_return_status := FND_API.G_RET_STS_ERROR ;
594:
595: -- save message in fnd stack
596: if (lc_stat_level >= lc_debug_level) then
597: FND_LOG.STRING(lc_stat_level, lc_mod_name,
598: 'Adding message CSD_DC_CODE_MISSING to FND_MSG stack');
599: end if;
600: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
601: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 610: FND_LOG.STRING(lc_proc_level, lc_mod_name,

606: p_data => x_msg_data );
607:
608: -- save message in debug log
609: if (lc_proc_level >= lc_debug_level) then
610: FND_LOG.STRING(lc_proc_level, lc_mod_name,
611: 'Required parameter Diagnostic Code is passed in as G_MISS_CHAR');
612: end if;
613:
614: WHEN CSD_DC_NAME_MISSING THEN

Line 621: FND_LOG.STRING(lc_stat_level, lc_mod_name,

617: x_return_status := FND_API.G_RET_STS_ERROR ;
618:
619: -- save message in fnd stack
620: if (lc_stat_level >= lc_debug_level) then
621: FND_LOG.STRING(lc_stat_level, lc_mod_name,
622: 'Adding message CSD_DC_CODE_MISSING to FND_MSG stack');
623: end if;
624: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
625: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 634: FND_LOG.STRING(lc_proc_level, lc_mod_name,

630: p_data => x_msg_data );
631:
632: -- save message in debug log
633: if (lc_proc_level >= lc_debug_level) then
634: FND_LOG.STRING(lc_proc_level, lc_mod_name,
635: 'Required parameter Name is passed in as G_MISS_CHAR');
636: end if;
637:
638: WHEN CSD_DC_ID_INVALID THEN

Line 645: FND_LOG.STRING(lc_stat_level, lc_mod_name,

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

Line 657: FND_LOG.STRING(lc_proc_level, lc_mod_name,

653: p_data => x_msg_data );
654:
655: -- save message in debug log
656: if (lc_proc_level >= lc_debug_level) then
657: FND_LOG.STRING(lc_proc_level, lc_mod_name,
658: 'Diagnostic code id is invalid');
659: end if;
660:
661: WHEN CSD_DC_GET_OVN_ERROR THEN

Line 668: FND_LOG.STRING(lc_stat_level, lc_mod_name,

664: x_return_status := FND_API.G_RET_STS_ERROR ;
665:
666: -- save message in fnd stack
667: if (lc_stat_level >= lc_debug_level) then
668: FND_LOG.STRING(lc_stat_level, lc_mod_name,
669: 'Adding message CSD_DC_GET_OVN_ERROR to FND_MSG stack');
670: end if;
671: FND_MESSAGE.SET_NAME('CSD','CSD_DC_GET_OVN_ERROR');
672: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE',p_diagnostic_code_rec.diagnostic_code);

Line 680: FND_LOG.STRING(lc_proc_level, lc_mod_name,

676: p_data => x_msg_data );
677:
678: -- save message in debug log
679: if (lc_proc_level >= lc_debug_level) then
680: FND_LOG.STRING(lc_proc_level, lc_mod_name,
681: 'Error retrieving object version number');
682: end if;
683:
684: WHEN CSD_DC_OVN_MISMATCH THEN

Line 691: FND_LOG.STRING(lc_stat_level, lc_mod_name,

687: x_return_status := FND_API.G_RET_STS_ERROR ;
688:
689: -- save message in fnd stack
690: if (lc_stat_level >= lc_debug_level) then
691: FND_LOG.STRING(lc_stat_level, lc_mod_name,
692: 'Adding message CSD_DC_OVN_MISMATCH to FND_MSG stack');
693: end if;
694: FND_MESSAGE.SET_NAME('CSD','CSD_DC_OVN_MISMATCH');
695: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE',p_diagnostic_code_rec.diagnostic_code);

Line 703: FND_LOG.STRING(lc_proc_level, lc_mod_name,

699: p_data => x_msg_data );
700:
701: -- save message in debug log
702: if (lc_proc_level >= lc_debug_level) then
703: FND_LOG.STRING(lc_proc_level, lc_mod_name,
704: 'Object version number passed in does not match the existing one');
705: end if;
706:
707: WHEN CSD_DC_CODE_EXISTS THEN

Line 714: FND_LOG.STRING(lc_stat_level, lc_mod_name,

710: x_return_status := FND_API.G_RET_STS_ERROR ;
711:
712: -- save message in fnd stack
713: if (lc_stat_level >= lc_debug_level) then
714: FND_LOG.STRING(lc_stat_level, lc_mod_name,
715: 'Adding message CSD_DC_CODE_EXISTS to FND_MSG stack');
716: end if;
717: FND_MESSAGE.SET_NAME('CSD','CSD_DC_CODE_EXISTS');
718: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE',p_diagnostic_code_rec.diagnostic_code);

Line 726: FND_LOG.STRING(lc_excep_level, lc_mod_name,

722: p_data => x_msg_data );
723:
724: -- save message in debug log
725: IF (lc_excep_level >= lc_debug_level) THEN
726: FND_LOG.STRING(lc_excep_level, lc_mod_name,
727: 'Diagnostic code already exists');
728: END IF;
729:
730: WHEN FND_API.G_EXC_ERROR THEN

Line 740: FND_LOG.STRING(lc_excep_level, lc_mod_name,

736: p_data => x_msg_data );
737:
738: -- save message in debug log
739: IF (lc_excep_level >= lc_debug_level) THEN
740: FND_LOG.STRING(lc_excep_level, lc_mod_name,
741: 'EXC_ERROR['||x_msg_data||']');
742: END IF;
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 752: FND_LOG.STRING(lc_stat_level, lc_mod_name,

748: IF FND_MSG_PUB.Check_Msg_Level
749: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
750: THEN
751: if (lc_stat_level >= lc_debug_level) then
752: FND_LOG.STRING(lc_stat_level, lc_mod_name,
753: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
754: end if;
755: FND_MSG_PUB.Add_Exc_Msg
756: (G_PKG_NAME ,

Line 766: FND_LOG.STRING(lc_excep_level, lc_mod_name,

762: p_data => x_msg_data );
763:
764: -- save message in debug log
765: IF (lc_excep_level >= lc_debug_level) THEN
766: FND_LOG.STRING(lc_excep_level, lc_mod_name,
767: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
768: END IF;
769:
770: WHEN OTHERS THEN

Line 779: FND_LOG.STRING(lc_stat_level, lc_mod_name,

775: IF FND_MSG_PUB.Check_Msg_Level
776: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
777: THEN
778: if (lc_stat_level >= lc_debug_level) then
779: FND_LOG.STRING(lc_stat_level, lc_mod_name,
780: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
781: end if;
782: FND_MSG_PUB.Add_Exc_Msg
783: (G_PKG_NAME ,

Line 794: FND_LOG.STRING(lc_excep_level, lc_mod_name,

790:
791: -- save message in debug log
792: IF (lc_excep_level >= lc_debug_level) THEN
793: -- create a seeded message
794: FND_LOG.STRING(lc_excep_level, lc_mod_name,
795: 'SQL Message['||sqlerrm||']' );
796: END IF;
797:
798: END Update_Diagnostic_Code;

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

815: p_diagnostic_code_rec IN DIAGNOSTIC_CODE_REC_TYPE
816: ) IS
817:
818: -- CONSTANTS --
819: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
820: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
821: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
822: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
823: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

816: ) IS
817:
818: -- CONSTANTS --
819: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
820: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
821: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
822: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
823: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
824: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

817:
818: -- CONSTANTS --
819: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
820: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
821: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
822: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
823: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
824: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
825: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

818: -- CONSTANTS --
819: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
820: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
821: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
822: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
823: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
824: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
825: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
826: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.lock_diagnostic_code';

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

819: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
820: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
821: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
822: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
823: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
824: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
825: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
826: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.lock_diagnostic_code';
827: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_Diagnostic_Code';

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

820: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
821: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
822: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
823: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
824: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
825: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
826: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.lock_diagnostic_code';
827: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_Diagnostic_Code';
828: lc_api_version CONSTANT NUMBER := 1.0;

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

821: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
822: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
823: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
824: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
825: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
826: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_diagnostic_codes_pvt.lock_diagnostic_code';
827: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_Diagnostic_Code';
828: lc_api_version CONSTANT NUMBER := 1.0;
829:

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

851: FND_MSG_PUB.initialize;
852: END IF;
853:
854: IF (lc_proc_level >= lc_debug_level) THEN
855: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
856: 'Entered Lock_Diagnostic_Code');
857: END IF;
858:
859: -- Initialize API return status to success

Line 866: FND_LOG.STRING(lc_proc_level, lc_mod_name,

862: -- Api body starts
863:
864: -- Check the required parameters
865: if (lc_proc_level >= lc_debug_level) then
866: FND_LOG.STRING(lc_proc_level, lc_mod_name,
867: 'Checking required parameters');
868: end if;
869:
870: -- Check the required parameter

Line 884: FND_LOG.STRING(lc_proc_level, lc_mod_name,

880: p_api_name => lc_api_name);
881:
882: -- Lock row
883: if (lc_proc_level >= lc_debug_level) then
884: FND_LOG.STRING(lc_proc_level, lc_mod_name,
885: 'Calling Lock_Row table handler');
886: end if;
887:
888: Begin

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

922:
923: EXCEPTION
924: WHEN OTHERS THEN
925: IF ( lc_excep_level >= lc_debug_level) THEN
926: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DIAGNOSTIC_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
927: END IF;
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: END;
930:

Line 936: FND_LOG.STRING(lc_proc_level, lc_mod_name,

932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: if (lc_proc_level >= lc_debug_level) then
936: FND_LOG.STRING(lc_proc_level, lc_mod_name,
937: 'Returned from Lock_Row table handler');
938: end if;
939:
940: -- Api body ends here

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

949: (p_count => x_msg_count,
950: p_data => x_msg_data );
951:
952: IF (lc_proc_level >= lc_debug_level) THEN
953: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
954: 'Leaving Lock_Diagnostic_Code');
955: END IF;
956:
957: EXCEPTION

Line 969: FND_LOG.STRING(lc_excep_level, lc_mod_name,

965: p_data => x_msg_data );
966:
967: -- save message in debug log
968: IF (lc_excep_level >= lc_debug_level) THEN
969: FND_LOG.STRING(lc_excep_level, lc_mod_name,
970: 'EXC_ERROR['||x_msg_data||']');
971: END IF;
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 981: FND_LOG.STRING(lc_stat_level, lc_mod_name,

977: IF FND_MSG_PUB.Check_Msg_Level
978: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
979: THEN
980: if (lc_stat_level >= lc_debug_level) then
981: FND_LOG.STRING(lc_stat_level, lc_mod_name,
982: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
983: end if;
984: FND_MSG_PUB.Add_Exc_Msg
985: (G_PKG_NAME ,

Line 995: FND_LOG.STRING(lc_excep_level, lc_mod_name,

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

Line 1008: FND_LOG.STRING(lc_stat_level, lc_mod_name,

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

Line 1023: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1019:
1020: -- save message in debug log
1021: IF (lc_excep_level >= lc_debug_level) THEN
1022: -- create a seeded message
1023: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1024: 'SQL Message['||sqlerrm||']' );
1025: END IF;
1026:
1027: END Lock_Diagnostic_Code;