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 FND_LOG

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

23: x_ro_service_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_service_codes_pvt.create_ro_service_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_service_codes_pvt.create_ro_service_code';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_RO_Service_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_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;

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_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:

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

116: p_api_name => lc_api_name);
117:
118: -- Validate the repair line ID
119: if (lc_proc_level >= lc_debug_level) then
120: FND_LOG.STRING(lc_proc_level, lc_mod_name,
121: 'Validate repair line id');
122: end if;
123:
124: -- Validate the repair line ID

Line 133: FND_LOG.STRING(lc_proc_level, lc_mod_name,

129:
130: /*
131: -- Validate the ro association for service code
132: if (lc_proc_level >= lc_debug_level) then
133: FND_LOG.STRING(lc_proc_level, lc_mod_name,
134: 'Validate if the ro association for service code exists');
135: end if;
136:
137: -- Validate the ro association for service code

Line 162: FND_LOG.STRING(lc_stat_level, lc_mod_name,

158: IF (l_dummy = 'X') then
159: RAISE CSD_RSC_ASSOCIATION_EXISTS;
160: ELSE
161: if (lc_stat_level >= lc_debug_level) then
162: FND_LOG.STRING(lc_stat_level, lc_mod_name,
163: 'RO service code association already exists');
164: end if;
165: END IF;
166: */

Line 170: FND_LOG.STRING(lc_proc_level, lc_mod_name,

166: */
167:
168: -- Insert row
169: if (lc_proc_level >= lc_debug_level) then
170: FND_LOG.STRING(lc_proc_level, lc_mod_name,
171: 'Calling Insert_Row table handler');
172: end if;
173:
174: BEGIN

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

220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:
223: if (lc_proc_level >= lc_debug_level) then
224: FND_LOG.STRING(lc_proc_level, lc_mod_name,
225: 'Returned from Insert_Row table handler');
226: end if;
227:
228: -- Api body ends here

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

237: (p_count => x_msg_count,
238: p_data => x_msg_data );
239:
240: IF (lc_proc_level >= lc_debug_level) THEN
241: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
242: 'Leaving Create_RO_Service_Code');
243: END IF;
244:
245: EXCEPTION

Line 255: FND_LOG.STRING(lc_stat_level, lc_mod_name,

251: x_return_status := FND_API.G_RET_STS_ERROR ;
252:
253: -- save message in fnd stack
254: if (lc_stat_level >= lc_debug_level) then
255: FND_LOG.STRING(lc_stat_level, lc_mod_name,
256: 'Adding message CSD_RSC_ASSOCIATION_EXISTS to FND_MSG stack');
257: end if;
258: FND_MESSAGE.SET_NAME('CSD','CSD_RSC_ASSOCIATION_EXISTS');
259: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_ro_service_code_rec.service_code_id);

Line 268: FND_LOG.STRING(lc_excep_level, lc_mod_name,

264: p_data => x_msg_data );
265:
266: -- save message in debug log
267: IF (lc_excep_level >= lc_debug_level) THEN
268: FND_LOG.STRING(lc_excep_level, lc_mod_name,
269: 'RO service code already exists');
270: END IF;
271: */
272:

Line 284: FND_LOG.STRING(lc_excep_level, lc_mod_name,

280: p_data => x_msg_data );
281:
282: -- save message in debug log
283: IF (lc_excep_level >= lc_debug_level) THEN
284: FND_LOG.STRING(lc_excep_level, lc_mod_name,
285: 'EXC_ERROR['||x_msg_data||']');
286: END IF;
287:
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 297: FND_LOG.STRING(lc_stat_level, lc_mod_name,

293: IF FND_MSG_PUB.Check_Msg_Level
294: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: if (lc_stat_level >= lc_debug_level) then
297: FND_LOG.STRING(lc_stat_level, lc_mod_name,
298: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
299: end if;
300: FND_MSG_PUB.Add_Exc_Msg
301: (G_PKG_NAME ,

Line 311: FND_LOG.STRING(lc_excep_level, lc_mod_name,

307: p_data => x_msg_data );
308:
309: -- save message in debug log
310: IF (lc_excep_level >= lc_debug_level) THEN
311: FND_LOG.STRING(lc_excep_level, lc_mod_name,
312: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
313: END IF;
314:
315: WHEN OTHERS THEN

Line 325: FND_LOG.STRING(lc_stat_level, lc_mod_name,

321: IF FND_MSG_PUB.Check_Msg_Level
322: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: if (lc_stat_level >= lc_debug_level) then
325: FND_LOG.STRING(lc_stat_level, lc_mod_name,
326: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
327: end if;
328: FND_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME ,

Line 340: FND_LOG.STRING(lc_excep_level, lc_mod_name,

336:
337: -- save message in debug log
338: IF (lc_excep_level >= lc_debug_level) THEN
339: -- create a seeded message
340: FND_LOG.STRING(lc_excep_level, lc_mod_name,
341: 'SQL Message['||sqlerrm||']' );
342: END IF;
343:
344: END Create_RO_Service_Code;

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

362: x_obj_ver_number OUT NOCOPY NUMBER
363: )IS
364:
365: -- CONSTANTS --
366: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
367: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
368: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
369: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
370: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

363: )IS
364:
365: -- CONSTANTS --
366: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
367: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
368: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

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

364:
365: -- CONSTANTS --
366: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
367: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
368: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

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

365: -- CONSTANTS --
366: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
367: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
368: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

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

366: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
367: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
368: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

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

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

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

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

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

412: FND_MSG_PUB.initialize;
413: END IF;
414:
415: IF (lc_proc_level >= lc_debug_level) THEN
416: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
417: 'Entered Update_RO_Service_Code');
418: END IF;
419:
420: -- log parameters

Line 433: FND_LOG.STRING(lc_proc_level, lc_mod_name,

429: -- Api body starts
430:
431: -- Check the required parameters
432: if (lc_proc_level >= lc_debug_level) then
433: FND_LOG.STRING(lc_proc_level, lc_mod_name,
434: 'Checking required parameters');
435: end if;
436:
437: -- Check the required parameter

Line 471: FND_LOG.STRING(lc_proc_level, lc_mod_name,

467: END IF;
468:
469: -- Validate the ro service code association
470: if (lc_proc_level >= lc_debug_level) then
471: FND_LOG.STRING(lc_proc_level, lc_mod_name,
472: 'Validate the id for ro service code');
473: end if;
474:
475: -- Validate the ro service code association

Line 496: FND_LOG.STRING(lc_stat_level, lc_mod_name,

492: IF (l_dummy <> 'X') then
493: RAISE CSD_RSC_INVALID_ID;
494: ELSE
495: if (lc_stat_level >= lc_debug_level) then
496: FND_LOG.STRING(lc_stat_level, lc_mod_name,
497: 'RO service code association is valid');
498: end if;
499: END IF;
500:

Line 503: FND_LOG.STRING(lc_proc_level, lc_mod_name,

499: END IF;
500:
501: -- Get the object version number for ro service code association
502: if (lc_proc_level >= lc_debug_level) then
503: FND_LOG.STRING(lc_proc_level, lc_mod_name,
504: 'Get object version number for ro service code association');
505: end if;
506:
507: -- Get object version number for ro service code association

Line 526: FND_LOG.STRING(lc_stat_level, lc_mod_name,

522: IF (l_obj_ver_num is null) then
523: RAISE CSD_RSC_GET_OVN_ERROR;
524: ELSE
525: if (lc_stat_level >= lc_debug_level) then
526: FND_LOG.STRING(lc_stat_level, lc_mod_name,
527: 'Retrieved object version number');
528: end if;
529: END IF;
530:

Line 533: FND_LOG.STRING(lc_proc_level, lc_mod_name,

529: END IF;
530:
531: -- Validate the object version number for ro service code association
532: if (lc_proc_level >= lc_debug_level) then
533: FND_LOG.STRING(lc_proc_level, lc_mod_name,
534: 'Validate object version number for ro service code association');
535: end if;
536:
537: -- Validate if object version number for ro service code association is same as the one passed in

Line 542: FND_LOG.STRING(lc_stat_level, lc_mod_name,

538: IF NVL(p_ro_service_code_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN
539: RAISE CSD_RSC_OVN_MISMATCH;
540: ELSE
541: if (lc_stat_level >= lc_debug_level) then
542: FND_LOG.STRING(lc_stat_level, lc_mod_name,
543: 'Object version number is valid');
544: end if;
545: END IF;
546:

Line 549: FND_LOG.STRING(lc_proc_level, lc_mod_name,

545: END IF;
546:
547: -- Validate the repair line id if it is passed in
548: if (lc_proc_level >= lc_debug_level) then
549: FND_LOG.STRING(lc_proc_level, lc_mod_name,
550: 'Validate repair line id if it is passed in');
551: end if;
552:
553: -- Validate the repair line ID

Line 563: FND_LOG.STRING(lc_proc_level, lc_mod_name,

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

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

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

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

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

Line 647: FND_LOG.STRING(lc_stat_level, lc_mod_name,

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

Line 661: FND_LOG.STRING(lc_excep_level, lc_mod_name,

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

Line 672: FND_LOG.STRING(lc_stat_level, lc_mod_name,

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

Line 686: FND_LOG.STRING(lc_excep_level, lc_mod_name,

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

Line 698: FND_LOG.STRING(lc_stat_level, lc_mod_name,

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

Line 712: FND_LOG.STRING(lc_excep_level, lc_mod_name,

708: p_data => x_msg_data );
709:
710: -- save message in debug log
711: IF (lc_excep_level >= lc_debug_level) THEN
712: FND_LOG.STRING(lc_excep_level, lc_mod_name,
713: 'RO service code source type is missing');
714: END IF;
715:
716: WHEN CSD_RSC_APPL_FLAG_MISSING THEN

Line 724: FND_LOG.STRING(lc_stat_level, lc_mod_name,

720: x_return_status := FND_API.G_RET_STS_ERROR ;
721:
722: -- save message in fnd stack
723: if (lc_stat_level >= lc_debug_level) then
724: FND_LOG.STRING(lc_stat_level, lc_mod_name,
725: 'Adding message CSD_RSC_APPL_FLAG_MISSING to FND_MSG stack');
726: end if;
727: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
728: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 738: FND_LOG.STRING(lc_excep_level, lc_mod_name,

734: p_data => x_msg_data );
735:
736: -- save message in debug log
737: IF (lc_excep_level >= lc_debug_level) THEN
738: FND_LOG.STRING(lc_excep_level, lc_mod_name,
739: 'RO service code applicable flag is missing');
740: END IF;
741:
742: WHEN CSD_RSC_APPL_EST_FLAG_MISSING THEN

Line 750: FND_LOG.STRING(lc_stat_level, lc_mod_name,

746: x_return_status := FND_API.G_RET_STS_ERROR ;
747:
748: -- save message in fnd stack
749: if (lc_stat_level >= lc_debug_level) then
750: FND_LOG.STRING(lc_stat_level, lc_mod_name,
751: 'Adding message CSD_RSC_APP_EST_FLAG_MISSING to FND_MSG stack');
752: end if;
753: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
754: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 764: FND_LOG.STRING(lc_excep_level, lc_mod_name,

760: p_data => x_msg_data );
761:
762: -- save message in debug log
763: IF (lc_excep_level >= lc_debug_level) THEN
764: FND_LOG.STRING(lc_excep_level, lc_mod_name,
765: 'RO service code applied to estimate flag is missing');
766: END IF;
767:
768: WHEN CSD_RSC_APPL_WORK_FLAG_MISSING THEN

Line 776: FND_LOG.STRING(lc_stat_level, lc_mod_name,

772: x_return_status := FND_API.G_RET_STS_ERROR ;
773:
774: -- save message in fnd stack
775: if (lc_stat_level >= lc_debug_level) then
776: FND_LOG.STRING(lc_stat_level, lc_mod_name,
777: 'Adding message CSD_RSC_APP_WORK_FLAG_MISSING to FND_MSG stack');
778: end if;
779: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
780: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 790: FND_LOG.STRING(lc_excep_level, lc_mod_name,

786: p_data => x_msg_data );
787:
788: -- save message in debug log
789: IF (lc_excep_level >= lc_debug_level) THEN
790: FND_LOG.STRING(lc_excep_level, lc_mod_name,
791: 'RO service code applied to work flag is missing');
792: END IF;
793:
794: WHEN CSD_RSC_INVALID_ID THEN

Line 802: FND_LOG.STRING(lc_stat_level, lc_mod_name,

798: x_return_status := FND_API.G_RET_STS_ERROR ;
799:
800: -- save message in fnd stack
801: if (lc_stat_level >= lc_debug_level) then
802: FND_LOG.STRING(lc_stat_level, lc_mod_name,
803: 'Adding message CSD_RSC_INVALID_ID to FND_MSG stack');
804: end if;
805: FND_MESSAGE.SET_NAME('CSD','CSD_RSC_INVALID_ID');
806: FND_MESSAGE.SET_TOKEN('RO_SERVICE_CODE_ID',p_ro_service_code_rec.ro_service_code_id);

Line 815: FND_LOG.STRING(lc_excep_level, lc_mod_name,

811: p_data => x_msg_data );
812:
813: -- save message in debug log
814: IF (lc_excep_level >= lc_debug_level) THEN
815: FND_LOG.STRING(lc_excep_level, lc_mod_name,
816: 'RO service code id is invalid');
817: END IF;
818:
819: WHEN CSD_RSC_GET_OVN_ERROR THEN

Line 827: FND_LOG.STRING(lc_stat_level, lc_mod_name,

823: x_return_status := FND_API.G_RET_STS_ERROR ;
824:
825: -- save message in fnd stack
826: if (lc_stat_level >= lc_debug_level) then
827: FND_LOG.STRING(lc_stat_level, lc_mod_name,
828: 'Adding message CSD_RSC_GET_OVN_ERROR to FND_MSG stack');
829: end if;
830: FND_MESSAGE.SET_NAME('CSD','CSD_RSC_GET_OVN_ERROR');
831: FND_MESSAGE.SET_TOKEN('RO_SERVICE_CODE_ID',p_ro_service_code_rec.ro_service_code_id);

Line 840: FND_LOG.STRING(lc_excep_level, lc_mod_name,

836: p_data => x_msg_data );
837:
838: -- save message in debug log
839: IF (lc_excep_level >= lc_debug_level) THEN
840: FND_LOG.STRING(lc_excep_level, lc_mod_name,
841: 'RO service code get object version number error');
842: END IF;
843:
844: WHEN CSD_RSC_OVN_MISMATCH THEN

Line 852: FND_LOG.STRING(lc_stat_level, lc_mod_name,

848: x_return_status := FND_API.G_RET_STS_ERROR ;
849:
850: -- save message in fnd stack
851: if (lc_stat_level >= lc_debug_level) then
852: FND_LOG.STRING(lc_stat_level, lc_mod_name,
853: 'Adding message CSD_RSC_OVN_MISMATCH to FND_MSG stack');
854: end if;
855: FND_MESSAGE.SET_NAME('CSD','CSD_RSC_OVN_MISMATCH');
856: FND_MESSAGE.SET_TOKEN('RO_SERVICE_CODE_ID',p_ro_service_code_rec.ro_service_code_id);

Line 865: FND_LOG.STRING(lc_excep_level, lc_mod_name,

861: p_data => x_msg_data );
862:
863: -- save message in debug log
864: IF (lc_excep_level >= lc_debug_level) THEN
865: FND_LOG.STRING(lc_excep_level, lc_mod_name,
866: 'RO service code object version number mismatch');
867: END IF;
868:
869: WHEN FND_API.G_EXC_ERROR THEN

Line 880: FND_LOG.STRING(lc_excep_level, lc_mod_name,

876: p_data => x_msg_data );
877:
878: -- save message in debug log
879: IF (lc_excep_level >= lc_debug_level) THEN
880: FND_LOG.STRING(lc_excep_level, lc_mod_name,
881: 'EXC_ERROR['||x_msg_data||']');
882: END IF;
883:
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 893: FND_LOG.STRING(lc_stat_level, lc_mod_name,

889: IF FND_MSG_PUB.Check_Msg_Level
890: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
891: THEN
892: if (lc_stat_level >= lc_debug_level) then
893: FND_LOG.STRING(lc_stat_level, lc_mod_name,
894: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
895: end if;
896: FND_MSG_PUB.Add_Exc_Msg
897: (G_PKG_NAME ,

Line 907: FND_LOG.STRING(lc_excep_level, lc_mod_name,

903: p_data => x_msg_data );
904:
905: -- save message in debug log
906: IF (lc_excep_level >= lc_debug_level) THEN
907: FND_LOG.STRING(lc_excep_level, lc_mod_name,
908: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
909: END IF;
910:
911: WHEN OTHERS THEN

Line 921: FND_LOG.STRING(lc_stat_level, lc_mod_name,

917: IF FND_MSG_PUB.Check_Msg_Level
918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: if (lc_stat_level >= lc_debug_level) then
921: FND_LOG.STRING(lc_stat_level, lc_mod_name,
922: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
923: end if;
924: FND_MSG_PUB.Add_Exc_Msg
925: (G_PKG_NAME ,

Line 936: FND_LOG.STRING(lc_excep_level, lc_mod_name,

932:
933: -- save message in debug log
934: IF (lc_excep_level >= lc_debug_level) THEN
935: -- create a seeded message
936: FND_LOG.STRING(lc_excep_level, lc_mod_name,
937: 'SQL Message['||sqlerrm||']' );
938: END IF;
939:
940: END Update_RO_Service_Code;

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

958: p_ro_service_code_id IN NUMBER
959: ) IS
960:
961: -- CONSTANTS --
962: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
963: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
964: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
965: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
966: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

959: ) IS
960:
961: -- CONSTANTS --
962: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
963: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
964: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

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

960:
961: -- CONSTANTS --
962: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
963: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
964: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

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

961: -- CONSTANTS --
962: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
963: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
964: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

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

962: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
963: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
964: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

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

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

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

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

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

993: FND_MSG_PUB.initialize;
994: END IF;
995:
996: IF (lc_proc_level >= lc_debug_level) THEN
997: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
998: 'Entered Delete_RO_Service_Code');
999: END IF;
1000:
1001: -- Initialize API return status to success

Line 1008: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1004: -- Api body starts
1005:
1006: -- Check the required parameters
1007: if (lc_proc_level >= lc_debug_level) then
1008: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1009: 'Checking required parameter');
1010: end if;
1011:
1012: -- Check the required parameter

Line 1020: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1016: p_api_name => lc_api_name);
1017:
1018: -- Delete row
1019: if (lc_proc_level >= lc_debug_level) then
1020: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1021: 'Calling Delete_Row table handler');
1022: end if;
1023:
1024: BEGIN

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

1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040:
1041: if (lc_proc_level >= lc_debug_level) then
1042: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1043: 'Returned from Delete_Row table handler');
1044: end if;
1045:
1046: -- Api body ends here

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

1055: (p_count => x_msg_count,
1056: p_data => x_msg_data );
1057:
1058: IF (lc_proc_level >= lc_debug_level) THEN
1059: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1060: 'Leaving Delete_RO_Service_Code');
1061: END IF;
1062:
1063: EXCEPTION

Line 1075: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1071: p_data => x_msg_data );
1072:
1073: -- save message in debug log
1074: IF (lc_excep_level >= lc_debug_level) THEN
1075: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1076: 'EXC_ERROR['||x_msg_data||']');
1077: END IF;
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1088: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1084: IF FND_MSG_PUB.Check_Msg_Level
1085: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1086: THEN
1087: if (lc_stat_level >= lc_debug_level) then
1088: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1089: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1090: end if;
1091: FND_MSG_PUB.Add_Exc_Msg
1092: (G_PKG_NAME ,

Line 1102: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1098: p_data => x_msg_data );
1099:
1100: -- save message in debug log
1101: IF (lc_excep_level >= lc_debug_level) THEN
1102: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1103: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1104: END IF;
1105:
1106: WHEN OTHERS THEN

Line 1116: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1112: IF FND_MSG_PUB.Check_Msg_Level
1113: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1114: THEN
1115: if (lc_stat_level >= lc_debug_level) then
1116: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1117: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1118: end if;
1119: FND_MSG_PUB.Add_Exc_Msg
1120: (G_PKG_NAME ,

Line 1131: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1127:
1128: -- save message in debug log
1129: IF (lc_excep_level >= lc_debug_level) THEN
1130: -- create a seeded message
1131: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1132: 'SQL Message['||sqlerrm||']' );
1133: END IF;
1134:
1135: END Delete_RO_Service_Code;

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

1152: p_ro_service_code_rec IN RO_SERVICE_CODE_REC_TYPE
1153: )IS
1154:
1155: -- CONSTANTS --
1156: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1157: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1158: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1159: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1160: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

1153: )IS
1154:
1155: -- CONSTANTS --
1156: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1157: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1158: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

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

1154:
1155: -- CONSTANTS --
1156: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1157: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1158: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;

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

1155: -- CONSTANTS --
1156: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1157: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1158: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

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

1156: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1157: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1158: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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';

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

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

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

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

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

1187: FND_MSG_PUB.initialize;
1188: END IF;
1189:
1190: IF (lc_proc_level >= lc_debug_level) THEN
1191: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
1192: 'Entered Lock_RO_Service_Code');
1193: END IF;
1194:
1195: -- Initialize API return status to success

Line 1202: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1198: -- Api body starts
1199:
1200: -- Check the required parameters
1201: if (lc_proc_level >= lc_debug_level) then
1202: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1203: 'Checking required parameters');
1204: end if;
1205:
1206: -- Check the required parameter

Line 1220: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1216: p_api_name => lc_api_name);
1217:
1218: -- Lock row
1219: if (lc_proc_level >= lc_debug_level) then
1220: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1221: 'Calling Lock_Row table handler');
1222: end if;
1223:
1224: BEGIN

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

1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276: if (lc_proc_level >= lc_debug_level) then
1277: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1278: 'Returned from Lock_Row table handler');
1279: end if;
1280:
1281: -- Api body ends here

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

1290: (p_count => x_msg_count,
1291: p_data => x_msg_data );
1292:
1293: IF (lc_proc_level >= lc_debug_level) THEN
1294: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1295: 'Leaving Lock_RO_Service_Code');
1296: END IF;
1297:
1298: EXCEPTION

Line 1310: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1306: p_data => x_msg_data );
1307:
1308: -- save message in debug log
1309: IF (lc_excep_level >= lc_debug_level) THEN
1310: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1311: 'EXC_ERROR['||x_msg_data||']');
1312: END IF;
1313:
1314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1323: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1319: IF FND_MSG_PUB.Check_Msg_Level
1320: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1321: THEN
1322: if (lc_stat_level >= lc_debug_level) then
1323: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1324: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1325: end if;
1326: FND_MSG_PUB.Add_Exc_Msg
1327: (G_PKG_NAME ,

Line 1337: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1333: p_data => x_msg_data );
1334:
1335: -- save message in debug log
1336: IF (lc_excep_level >= lc_debug_level) THEN
1337: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1338: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1339: END IF;
1340:
1341: WHEN OTHERS THEN

Line 1351: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1347: IF FND_MSG_PUB.Check_Msg_Level
1348: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: if (lc_stat_level >= lc_debug_level) then
1351: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1352: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1353: end if;
1354: FND_MSG_PUB.Add_Exc_Msg
1355: (G_PKG_NAME ,

Line 1366: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1362:
1363: -- save message in debug log
1364: IF (lc_excep_level >= lc_debug_level) THEN
1365: -- create a seeded message
1366: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1367: 'SQL Message['||sqlerrm||']' );
1368: END IF;
1369:
1370: END Lock_RO_Service_Code;