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

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

23: x_sc_domain_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_sc_domains_pvt.create_sc_domain';

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_sc_domains_pvt.create_sc_domain';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_SC_Domain';

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_sc_domains_pvt.create_sc_domain';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_SC_Domain';
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_sc_domains_pvt.create_sc_domain';
35: lc_api_name CONSTANT VARCHAR2(30) := 'Create_SC_Domain';
36: lc_api_version CONSTANT NUMBER := 1.0;
37:

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

74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: IF (lc_proc_level >= lc_debug_level) THEN
78: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
79: 'Entered Create_SC_Domain');
80: END IF;
81:
82: -- log parameters

Line 95: FND_LOG.STRING(lc_proc_level, lc_mod_name,

91: -- Api body starts
92:
93: -- Check the required parameters
94: if (lc_proc_level >= lc_debug_level) then
95: FND_LOG.STRING(lc_proc_level, lc_mod_name,
96: 'Checking required parameters');
97: end if;
98:
99: -- Check the required parameter

Line 113: FND_LOG.STRING(lc_proc_level, lc_mod_name,

109: p_api_name => lc_api_name);
110:
111: -- Check if required parameter is passed in as G_MISS
112: if (lc_proc_level >= lc_debug_level) then
113: FND_LOG.STRING(lc_proc_level, lc_mod_name,
114: 'Checking if required parameters are passed in as G_MISS');
115: end if;
116:
117: -- Check if required parameter is passed in as G_MISS

Line 138: FND_LOG.STRING(lc_proc_level, lc_mod_name,

134: END IF;
135:
136: -- Validate the domain for service code
137: if (lc_proc_level >= lc_debug_level) then
138: FND_LOG.STRING(lc_proc_level, lc_mod_name,
139: 'Validate if the service code domain already exists');
140: end if;
141:
142: -- Validate the domain for service code

Line 184: FND_LOG.STRING(lc_stat_level, lc_mod_name,

180: IF (l_dummy = 'X') then
181: RAISE CSD_SCD_DOMAIN_EXISTS;
182: ELSE
183: if (lc_stat_level >= lc_debug_level) then
184: FND_LOG.STRING(lc_stat_level, lc_mod_name,
185: 'Service code domain does not exist');
186: end if;
187: END IF;
188:

Line 192: FND_LOG.STRING(lc_proc_level, lc_mod_name,

188:
189:
190: -- Validate the inventory item id if domain is ITEM
191: if (lc_proc_level >= lc_debug_level) then
192: FND_LOG.STRING(lc_proc_level, lc_mod_name,
193: 'Validate the inventory item id if domain is ITEM');
194: end if;
195:
196: -- Validate the inventory item id if domain is ITEM

Line 219: FND_LOG.STRING(lc_stat_level, lc_mod_name,

215: IF (l_dummy <> 'X') then
216: RAISE CSD_SCD_INVALID_ITEM;
217: ELSE
218: if (lc_stat_level >= lc_debug_level) then
219: FND_LOG.STRING(lc_stat_level, lc_mod_name,
220: 'Item for service code domain is valid');
221: end if;
222: END IF;
223: END IF; -- if domain type is ITEM

Line 232: FND_LOG.STRING(lc_proc_level, lc_mod_name,

228: IF (p_sc_domain_rec.domain_type_code = 'CAT' ) THEN
229:
230: -- Validate the category set id if domain is CAT
231: if (lc_proc_level >= lc_debug_level) then
232: FND_LOG.STRING(lc_proc_level, lc_mod_name,
233: 'Validate the category set id if domain is CATEGORY');
234: end if;
235:
236: -- Validate the category set id if domain is CAT

Line 257: FND_LOG.STRING(lc_stat_level, lc_mod_name,

253: IF (l_dummy <> 'X') then
254: RAISE CSD_SCD_INVALID_CAT_SET;
255: ELSE
256: if (lc_stat_level >= lc_debug_level) then
257: FND_LOG.STRING(lc_stat_level, lc_mod_name,
258: 'Category set for service code domain is valid');
259: end if;
260: END IF;
261:

Line 264: FND_LOG.STRING(lc_proc_level, lc_mod_name,

260: END IF;
261:
262: -- Get the validate flag for the category set
263: if (lc_proc_level >= lc_debug_level) then
264: FND_LOG.STRING(lc_proc_level, lc_mod_name,
265: 'Get the validate flag for the category set');
266: end if;
267:
268: Begin

Line 286: FND_LOG.STRING(lc_stat_level, lc_mod_name,

282: IF (l_valid_cat_flag is null) then
283: RAISE CSD_SCD_INVALID_CATSET_FLAG;
284: ELSE
285: if (lc_stat_level >= lc_debug_level) then
286: FND_LOG.STRING(lc_stat_level, lc_mod_name,
287: 'Retrieved validate flag for category set');
288: end if;
289: END IF;
290:

Line 300: FND_LOG.STRING(lc_proc_level, lc_mod_name,

296: Begin
297: l_dummy := null;
298:
299: if (lc_proc_level >= lc_debug_level) then
300: FND_LOG.STRING(lc_proc_level, lc_mod_name,
301: 'Validate category for the category set');
302: end if;
303:
304: IF (l_valid_cat_flag = 'Y') then

Line 307: FND_LOG.STRING(lc_proc_level, lc_mod_name,

303:
304: IF (l_valid_cat_flag = 'Y') then
305:
306: if (lc_proc_level >= lc_debug_level) then
307: FND_LOG.STRING(lc_proc_level, lc_mod_name,
308: 'Category set validate flag is Yes');
309: end if;
310:
311: select 'X'

Line 319: FND_LOG.STRING(lc_proc_level, lc_mod_name,

315: and category_id = p_sc_domain_rec.category_id;
316:
317: ELSIF (l_valid_cat_flag = 'N') then
318: if (lc_proc_level >= lc_debug_level) then
319: FND_LOG.STRING(lc_proc_level, lc_mod_name,
320: 'Category set validate flag is No');
321: end if;
322:
323: select 'X'

Line 343: FND_LOG.STRING(lc_stat_level, lc_mod_name,

339: IF (l_dummy <>'X') then
340: RAISE CSD_SCD_INVALID_CATEGORY;
341: ELSE
342: if (lc_stat_level >= lc_debug_level) then
343: FND_LOG.STRING(lc_stat_level, lc_mod_name,
344: 'Category is valid');
345: end if;
346: END IF;
347:

Line 354: FND_LOG.STRING(lc_proc_level, lc_mod_name,

350: -- Set G_MISS parameters according to domain type
351: IF (p_sc_domain_rec.domain_type_code = 'CAT') then
352:
353: if (lc_proc_level >= lc_debug_level) then
354: FND_LOG.STRING(lc_proc_level, lc_mod_name,
355: 'Domain type is CATEGORY, setting item id to G_MISS_NUM');
356: end if;
357:
358: l_inventory_item_id := FND_API.G_MISS_NUM;

Line 365: FND_LOG.STRING(lc_proc_level, lc_mod_name,

361:
362: ELSIF (p_sc_domain_rec.domain_type_code = 'ITEM') then
363:
364: if (lc_proc_level >= lc_debug_level) then
365: FND_LOG.STRING(lc_proc_level, lc_mod_name,
366: 'Domain type is ITEM, setting category set and category ids to G_MISS_NUM');
367: end if;
368:
369: l_category_id := FND_API.G_MISS_NUM;

Line 376: FND_LOG.STRING(lc_proc_level, lc_mod_name,

372: END IF;
373:
374: -- Insert row
375: if (lc_proc_level >= lc_debug_level) then
376: FND_LOG.STRING(lc_proc_level, lc_mod_name,
377: 'Calling Insert_Row table handler');
378: end if;
379:
380: BEGIN

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

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: IF ( lc_excep_level >= lc_debug_level) THEN
417: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
418: END IF;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: END;
421:

Line 427: FND_LOG.STRING(lc_proc_level, lc_mod_name,

423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: if (lc_proc_level >= lc_debug_level) then
427: FND_LOG.STRING(lc_proc_level, lc_mod_name,
428: 'Returned from Insert_Row table handler');
429: end if;
430:
431: -- Api body ends here

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

440: (p_count => x_msg_count,
441: p_data => x_msg_data );
442:
443: IF (lc_proc_level >= lc_debug_level) THEN
444: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
445: 'Leaving Create_SC_Domain');
446: END IF;
447:
448: EXCEPTION

Line 457: FND_LOG.STRING(lc_stat_level, lc_mod_name,

453: x_return_status := FND_API.G_RET_STS_ERROR ;
454:
455: -- save message in fnd stack
456: if (lc_stat_level >= lc_debug_level) then
457: FND_LOG.STRING(lc_stat_level, lc_mod_name,
458: 'Adding message CSD_SCD_ITEM_MISSING to FND_MSG stack');
459: end if;
460: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
461: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 471: FND_LOG.STRING(lc_excep_level, lc_mod_name,

467: p_data => x_msg_data );
468:
469: -- save message in debug log
470: IF (lc_excep_level >= lc_debug_level) THEN
471: FND_LOG.STRING(lc_excep_level, lc_mod_name,
472: 'Service code domain item is missing');
473: END IF;
474:
475: WHEN CSD_SCD_CATEGORY_SET_MISSING THEN

Line 483: FND_LOG.STRING(lc_stat_level, lc_mod_name,

479: x_return_status := FND_API.G_RET_STS_ERROR ;
480:
481: -- save message in fnd stack
482: if (lc_stat_level >= lc_debug_level) then
483: FND_LOG.STRING(lc_stat_level, lc_mod_name,
484: 'Adding message CSD_SCD_CATEGORY_SET_MISSING to FND_MSG stack');
485: end if;
486: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
487: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 497: FND_LOG.STRING(lc_excep_level, lc_mod_name,

493: p_data => x_msg_data );
494:
495: -- save message in debug log
496: IF (lc_excep_level >= lc_debug_level) THEN
497: FND_LOG.STRING(lc_excep_level, lc_mod_name,
498: 'Service code domain category set is missing');
499: END IF;
500:
501: WHEN CSD_SCD_CATEGORY_MISSING THEN

Line 509: FND_LOG.STRING(lc_stat_level, lc_mod_name,

505: x_return_status := FND_API.G_RET_STS_ERROR ;
506:
507: -- save message in fnd stack
508: if (lc_stat_level >= lc_debug_level) then
509: FND_LOG.STRING(lc_stat_level, lc_mod_name,
510: 'Adding message CSD_SCD_CATEGORY_MISSING to FND_MSG stack');
511: end if;
512: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
513: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 523: FND_LOG.STRING(lc_excep_level, lc_mod_name,

519: p_data => x_msg_data );
520:
521: -- save message in debug log
522: IF (lc_excep_level >= lc_debug_level) THEN
523: FND_LOG.STRING(lc_excep_level, lc_mod_name,
524: 'Service code domain category is missing');
525: END IF;
526:
527: WHEN CSD_SCD_DOMAIN_EXISTS THEN

Line 535: FND_LOG.STRING(lc_stat_level, lc_mod_name,

531: x_return_status := FND_API.G_RET_STS_ERROR ;
532:
533: -- save message in fnd stack
534: if (lc_stat_level >= lc_debug_level) then
535: FND_LOG.STRING(lc_stat_level, lc_mod_name,
536: 'Adding message CSD_SCD_DOMAIN_EXISTS to FND_MSG stack');
537: end if;
538: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_DOMAIN_EXISTS');
539: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_domain_rec.service_code_id);

Line 548: FND_LOG.STRING(lc_excep_level, lc_mod_name,

544: p_data => x_msg_data );
545:
546: -- save message in debug log
547: IF (lc_excep_level >= lc_debug_level) THEN
548: FND_LOG.STRING(lc_excep_level, lc_mod_name,
549: 'Service code domain already exists');
550: END IF;
551:
552: WHEN CSD_SCD_INVALID_ITEM THEN

Line 560: FND_LOG.STRING(lc_stat_level, lc_mod_name,

556: x_return_status := FND_API.G_RET_STS_ERROR ;
557:
558: -- save message in fnd stack
559: if (lc_stat_level >= lc_debug_level) then
560: FND_LOG.STRING(lc_stat_level, lc_mod_name,
561: 'Adding message CSD_SCD_INVALID_ITEM to FND_MSG stack');
562: end if;
563: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ITEM');
564: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_sc_domain_rec.inventory_item_id);

Line 573: FND_LOG.STRING(lc_excep_level, lc_mod_name,

569: p_data => x_msg_data );
570:
571: -- save message in debug log
572: IF (lc_excep_level >= lc_debug_level) THEN
573: FND_LOG.STRING(lc_excep_level, lc_mod_name,
574: 'Service code domain item is invalid');
575: END IF;
576:
577: WHEN CSD_SCD_INVALID_CAT_SET THEN

Line 585: FND_LOG.STRING(lc_stat_level, lc_mod_name,

581: x_return_status := FND_API.G_RET_STS_ERROR ;
582:
583: -- save message in fnd stack
584: if (lc_stat_level >= lc_debug_level) then
585: FND_LOG.STRING(lc_stat_level, lc_mod_name,
586: 'Adding message CSD_SCD_INVALID_CAT_SET to FND_MSG stack');
587: end if;
588: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CAT_SET');
589: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);

Line 598: FND_LOG.STRING(lc_excep_level, lc_mod_name,

594: p_data => x_msg_data );
595:
596: -- save message in debug log
597: IF (lc_excep_level >= lc_debug_level) THEN
598: FND_LOG.STRING(lc_excep_level, lc_mod_name,
599: 'Service code domain category set is invalid');
600: END IF;
601:
602: WHEN CSD_SCD_INVALID_CATSET_FLAG THEN

Line 610: FND_LOG.STRING(lc_stat_level, lc_mod_name,

606: x_return_status := FND_API.G_RET_STS_ERROR ;
607:
608: -- save message in fnd stack
609: if (lc_stat_level >= lc_debug_level) then
610: FND_LOG.STRING(lc_stat_level, lc_mod_name,
611: 'Adding message CSD_SCD_INVALID_CATSET_FLAG to FND_MSG stack');
612: end if;
613: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATSET_FLAG');
614: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);

Line 623: FND_LOG.STRING(lc_excep_level, lc_mod_name,

619: p_data => x_msg_data );
620:
621: -- save message in debug log
622: IF (lc_excep_level >= lc_debug_level) THEN
623: FND_LOG.STRING(lc_excep_level, lc_mod_name,
624: 'Service code domain category set validate flag is invalid');
625: END IF;
626:
627: WHEN CSD_SCD_INVALID_CATEGORY THEN

Line 635: FND_LOG.STRING(lc_stat_level, lc_mod_name,

631: x_return_status := FND_API.G_RET_STS_ERROR ;
632:
633: -- save message in fnd stack
634: if (lc_stat_level >= lc_debug_level) then
635: FND_LOG.STRING(lc_stat_level, lc_mod_name,
636: 'Adding message CSD_SCD_INVALID_CATEGORY to FND_MSG stack');
637: end if;
638: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATEGORY');
639: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_sc_domain_rec.category_id);

Line 648: FND_LOG.STRING(lc_excep_level, lc_mod_name,

644: p_data => x_msg_data );
645:
646: -- save message in debug log
647: IF (lc_excep_level >= lc_debug_level) THEN
648: FND_LOG.STRING(lc_excep_level, lc_mod_name,
649: 'Service code domain category is invalid');
650: END IF;
651:
652: WHEN FND_API.G_EXC_ERROR THEN

Line 663: FND_LOG.STRING(lc_excep_level, lc_mod_name,

659: p_data => x_msg_data );
660:
661: -- save message in debug log
662: IF (lc_excep_level >= lc_debug_level) THEN
663: FND_LOG.STRING(lc_excep_level, lc_mod_name,
664: 'EXC_ERROR['||x_msg_data||']');
665: END IF;
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 676: FND_LOG.STRING(lc_stat_level, lc_mod_name,

672: IF FND_MSG_PUB.Check_Msg_Level
673: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
674: THEN
675: if (lc_stat_level >= lc_debug_level) then
676: FND_LOG.STRING(lc_stat_level, lc_mod_name,
677: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
678: end if;
679: FND_MSG_PUB.Add_Exc_Msg
680: (G_PKG_NAME ,

Line 690: FND_LOG.STRING(lc_excep_level, lc_mod_name,

686: p_data => x_msg_data );
687:
688: -- save message in debug log
689: IF (lc_excep_level >= lc_debug_level) THEN
690: FND_LOG.STRING(lc_excep_level, lc_mod_name,
691: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
692: END IF;
693:
694: WHEN OTHERS THEN

Line 704: FND_LOG.STRING(lc_stat_level, lc_mod_name,

700: IF FND_MSG_PUB.Check_Msg_Level
701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: if (lc_stat_level >= lc_debug_level) then
704: FND_LOG.STRING(lc_stat_level, lc_mod_name,
705: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
706: end if;
707: FND_MSG_PUB.Add_Exc_Msg
708: (G_PKG_NAME ,

Line 719: FND_LOG.STRING(lc_excep_level, lc_mod_name,

715:
716: -- save message in debug log
717: IF (lc_excep_level >= lc_debug_level) THEN
718: -- create a seeded message
719: FND_LOG.STRING(lc_excep_level, lc_mod_name,
720: 'SQL Message['||sqlerrm||']' );
721: END IF;
722:
723: END Create_SC_Domain;

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

742: x_obj_ver_number OUT NOCOPY NUMBER
743: ) IS
744:
745: -- CONSTANTS --
746: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
748: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

743: ) IS
744:
745: -- CONSTANTS --
746: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
748: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
751: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

744:
745: -- CONSTANTS --
746: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
748: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
751: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
752: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

745: -- CONSTANTS --
746: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
748: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
751: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
752: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
753: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.update_sc_domain';

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

746: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
748: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
751: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
752: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
753: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.update_sc_domain';
754: lc_api_name CONSTANT VARCHAR2(30) := 'Update_SC_Domain';

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

747: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
748: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
751: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
752: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
753: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.update_sc_domain';
754: lc_api_name CONSTANT VARCHAR2(30) := 'Update_SC_Domain';
755: lc_api_version CONSTANT NUMBER := 1.0;

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

748: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
749: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
750: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
751: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
752: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
753: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.update_sc_domain';
754: lc_api_name CONSTANT VARCHAR2(30) := 'Update_SC_Domain';
755: lc_api_version CONSTANT NUMBER := 1.0;
756:

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

801: FND_MSG_PUB.initialize;
802: END IF;
803:
804: IF (lc_proc_level >= lc_debug_level) THEN
805: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
806: 'Entered Update_SC_Domain');
807: END IF;
808:
809: -- log parameters

Line 822: FND_LOG.STRING(lc_proc_level, lc_mod_name,

818: -- Api body starts
819:
820: -- Check the required parameters
821: if (lc_proc_level >= lc_debug_level) then
822: FND_LOG.STRING(lc_proc_level, lc_mod_name,
823: 'Checking required parameter');
824: end if;
825:
826: -- Check the required parameter

Line 834: FND_LOG.STRING(lc_proc_level, lc_mod_name,

830: p_api_name => lc_api_name);
831:
832: -- Check if required parameter is passed in as G_MISS
833: if (lc_proc_level >= lc_debug_level) then
834: FND_LOG.STRING(lc_proc_level, lc_mod_name,
835: 'Checking if required parameters are passed in as G_MISS');
836: end if;
837:
838: -- Check if required parameter is passed in as G_MISS

Line 867: FND_LOG.STRING(lc_proc_level, lc_mod_name,

863: END IF;
864:
865: -- Validate the domain for service code
866: if (lc_proc_level >= lc_debug_level) then
867: FND_LOG.STRING(lc_proc_level, lc_mod_name,
868: 'Validate the service code domain id');
869: end if;
870:
871: -- Validate the service code domain id

Line 889: FND_LOG.STRING(lc_stat_level, lc_mod_name,

885: IF (l_dummy <> 'X') then
886: RAISE CSD_SCD_INVALID_ID;
887: ELSE
888: if (lc_stat_level >= lc_debug_level) then
889: FND_LOG.STRING(lc_stat_level, lc_mod_name,
890: 'Service code domain id is valid');
891: end if;
892: END IF;
893:

Line 896: FND_LOG.STRING(lc_proc_level, lc_mod_name,

892: END IF;
893:
894: -- Get the object version number for service code domain
895: if (lc_proc_level >= lc_debug_level) then
896: FND_LOG.STRING(lc_proc_level, lc_mod_name,
897: 'Get object version number for service code domain');
898: end if;
899:
900: -- Get object version number for service code domain

Line 919: FND_LOG.STRING(lc_stat_level, lc_mod_name,

915: IF (l_obj_ver_num is null) then
916: RAISE CSD_SCD_GET_OVN_ERROR;
917: ELSE
918: if (lc_stat_level >= lc_debug_level) then
919: FND_LOG.STRING(lc_stat_level, lc_mod_name,
920: 'Retrieved object version number');
921: end if;
922: END IF;
923:

Line 926: FND_LOG.STRING(lc_proc_level, lc_mod_name,

922: END IF;
923:
924: -- Validate the object version number for service code domain
925: if (lc_proc_level >= lc_debug_level) then
926: FND_LOG.STRING(lc_proc_level, lc_mod_name,
927: 'Validate object version number for service code domain');
928: end if;
929:
930: -- Validate if object version number for service code domain is same as the one passed in

Line 935: FND_LOG.STRING(lc_stat_level, lc_mod_name,

931: IF NVL(p_sc_domain_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN
932: RAISE CSD_SCD_OVN_MISMATCH;
933: ELSE
934: if (lc_stat_level >= lc_debug_level) then
935: FND_LOG.STRING(lc_stat_level, lc_mod_name,
936: 'Object version number is valid');
937: end if;
938: END IF;
939:

Line 942: FND_LOG.STRING(lc_proc_level, lc_mod_name,

938: END IF;
939:
940: -- Validate the code for service code
941: if (lc_proc_level >= lc_debug_level) then
942: FND_LOG.STRING(lc_proc_level, lc_mod_name,
943: 'Validate if the service code domain already exists ');
944: end if;
945:
946: -- Validate the domain for service code

Line 989: FND_LOG.STRING(lc_stat_level, lc_mod_name,

985: IF (l_dummy = 'X') then
986: RAISE CSD_SCD_DOMAIN_EXISTS;
987: ELSE
988: if (lc_stat_level >= lc_debug_level) then
989: FND_LOG.STRING(lc_stat_level, lc_mod_name,
990: 'Service code domain does not exist');
991: end if;
992: END IF;
993:

Line 999: FND_LOG.STRING(lc_proc_level, lc_mod_name,

995: IF (p_sc_domain_rec.domain_type_code = 'ITEM') then
996:
997: -- Validate the inventory item id if domain is ITEM
998: if (lc_proc_level >= lc_debug_level) then
999: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1000: 'Domain type is ITEM, perform validations');
1001: end if;
1002:
1003: IF (p_sc_domain_rec.inventory_item_id is null) THEN

Line 1007: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1003: IF (p_sc_domain_rec.inventory_item_id is null) THEN
1004:
1005: -- inventory item id is null, get the existing one
1006: if (lc_proc_level >= lc_debug_level) then
1007: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1008: 'Retrieve existing inventory item id since nothing is passed in');
1009: end if;
1010:
1011: Begin

Line 1029: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1025: IF (l_inventory_item_id is null) then
1026: RAISE CSD_SCD_GET_ITEM_ERROR;
1027: ELSE
1028: if (lc_stat_level >= lc_debug_level) then
1029: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1030: 'Item for service code domain is retrieved');
1031: end if;
1032: END IF;
1033:

Line 1038: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1034: ELSE -- if inventory item id is passed in
1035:
1036: -- Validate the inventory item id
1037: if (lc_proc_level >= lc_debug_level) then
1038: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1039: 'Validate the inventory item id passed in');
1040: end if;
1041:
1042: Begin

Line 1060: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1056: IF (l_inventory_item_id is null) then
1057: RAISE CSD_SCD_INVALID_ITEM;
1058: ELSE
1059: if (lc_stat_level >= lc_debug_level) then
1060: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1061: 'Item for service code domain is valid');
1062: end if;
1063: END IF;
1064: END IF; -- inventory item id is null

Line 1075: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1071: IF (p_sc_domain_rec.domain_type_code = 'CAT' ) THEN
1072:
1073: -- Validate the category set id if domain is CAT
1074: if (lc_proc_level >= lc_debug_level) then
1075: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1076: 'Domain type is CATEGORY, perform validations');
1077: end if;
1078:
1079: -- Validate the category set id if it is passed in

Line 1084: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1080: IF (p_sc_domain_rec.category_set_id is null) THEN
1081:
1082: -- If category set is null, get the existing category set id
1083: if (lc_proc_level >= lc_debug_level) then
1084: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1085: 'Get the existing category set id since nothing is passed in');
1086: end if;
1087:
1088: Begin

Line 1107: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1103: IF (l_category_set_id is null) then
1104: RAISE CSD_SCD_GET_CAT_SET_ERROR;
1105: ELSE
1106: if (lc_stat_level >= lc_debug_level) then
1107: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1108: 'Error retrieving existing category set for service code domain');
1109: end if;
1110: END IF;
1111:

Line 1116: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1112: ELSE
1113:
1114: -- Validate the category set id passed in
1115: if (lc_proc_level >= lc_debug_level) then
1116: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1117: 'Validate the category set id passed in');
1118: end if;
1119:
1120: Begin

Line 1138: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1134: IF (l_category_set_id is null) then
1135: RAISE CSD_SCD_INVALID_CAT_SET;
1136: ELSE
1137: if (lc_stat_level >= lc_debug_level) then
1138: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1139: 'Category set for service code domain is valid');
1140: end if;
1141: END IF;
1142:

Line 1148: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1144: END IF;
1145:
1146: -- Get the validate flag for the category set
1147: if (lc_proc_level >= lc_debug_level) then
1148: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1149: 'Get the validate flag for the category set');
1150: end if;
1151:
1152: -- Get the validate flag for the category set

Line 1171: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1167: IF (l_valid_cat_flag is null) then
1168: RAISE CSD_SCD_GET_CATSET_FLAG_ERROR;
1169: ELSE
1170: if (lc_stat_level >= lc_debug_level) then
1171: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1172: 'Retrieved validate flag for category set');
1173: end if;
1174: END IF;
1175:

Line 1180: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1176: -- If category id is null, get the existing one
1177: IF (p_sc_domain_rec.category_id is null) THEN
1178:
1179: if (lc_stat_level >= lc_debug_level) then
1180: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1181: 'Retrieved existing category id since nothing is passed in');
1182: end if;
1183:
1184: Begin

Line 1203: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1199: IF (l_category_id is null) then
1200: RAISE CSD_SCD_GET_CATEGORY_ERROR;
1201: ELSE
1202: if (lc_stat_level >= lc_debug_level) then
1203: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1204: 'Retrieved category for service code domain');
1205: end if;
1206: END IF;
1207:

Line 1223: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1219: Begin
1220: l_dummy := null;
1221:
1222: if (lc_proc_level >= lc_debug_level) then
1223: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1224: 'Validate category for the category set');
1225: end if;
1226:
1227: IF (l_valid_cat_flag = 'Y') then

Line 1230: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1226:
1227: IF (l_valid_cat_flag = 'Y') then
1228:
1229: if (lc_proc_level >= lc_debug_level) then
1230: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1231: 'Category set validate flag is Yes');
1232: end if;
1233:
1234: select 'X'

Line 1242: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1238: and category_id = l_category_id;
1239:
1240: ELSIF (l_valid_cat_flag = 'N') then
1241: if (lc_proc_level >= lc_debug_level) then
1242: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1243: 'Category set validate flag is No');
1244: end if;
1245:
1246: select 'X'

Line 1266: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1262: IF (l_dummy <>'X') then
1263: RAISE CSD_SCD_INVALID_CATEGORY;
1264: ELSE
1265: if (lc_stat_level >= lc_debug_level) then
1266: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1267: 'Category is valid');
1268: end if;
1269: END IF;
1270:

Line 1277: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1273: -- Set G_MISS parameters according to domain type
1274: IF (p_sc_domain_rec.domain_type_code = 'CAT') then
1275:
1276: if (lc_proc_level >= lc_debug_level) then
1277: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1278: 'Domain type is CATEGORY, setting item id to G_MISS_NUM');
1279: end if;
1280:
1281: l_inventory_item_id := FND_API.G_MISS_NUM;

Line 1286: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1282:
1283: ELSIF (p_sc_domain_rec.domain_type_code = 'ITEM') then
1284:
1285: if (lc_proc_level >= lc_debug_level) then
1286: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1287: 'Domain type is ITEM, setting category set and category ids to G_MISS_NUM');
1288: end if;
1289:
1290: l_category_id := FND_API.G_MISS_NUM;

Line 1296: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1292: END IF;
1293:
1294: -- Update row
1295: if (lc_proc_level >= lc_debug_level) then
1296: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1297: 'Calling Update_Row table handler');
1298: end if;
1299:
1300: BEGIN

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

1335:
1336: EXCEPTION
1337: WHEN OTHERS THEN
1338: IF ( lc_excep_level >= lc_debug_level) THEN
1339: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: END;
1343:

Line 1349: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:
1348: if (lc_proc_level >= lc_debug_level) then
1349: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1350: 'Returned from Update_Row table handler');
1351: end if;
1352:
1353: -- Api body ends here

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

1362: (p_count => x_msg_count,
1363: p_data => x_msg_data );
1364:
1365: IF (lc_proc_level >= lc_debug_level) THEN
1366: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1367: 'Leaving Update_SC_Domain');
1368: END IF;
1369:
1370: EXCEPTION

Line 1378: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1374: x_return_status := FND_API.G_RET_STS_ERROR ;
1375:
1376: -- save message in fnd stack
1377: if (lc_stat_level >= lc_debug_level) then
1378: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1379: 'Adding message CSD_SCD_SC_ID_MISSING to FND_MSG stack');
1380: end if;
1381: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1382: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 1392: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1388: p_data => x_msg_data );
1389:
1390: -- save message in debug log
1391: IF (lc_excep_level >= lc_debug_level) THEN
1392: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1393: 'Service code id is missing');
1394: END IF;
1395:
1396: WHEN CSD_SCD_DOMAIN_TYPE_MISSING THEN

Line 1404: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401:
1402: -- save message in fnd stack
1403: if (lc_stat_level >= lc_debug_level) then
1404: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1405: 'Adding message CSD_SCD_DOMAIN_TYPE_MISSING to FND_MSG stack');
1406: end if;
1407: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1408: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 1418: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1414: p_data => x_msg_data );
1415:
1416: -- save message in debug log
1417: IF (lc_excep_level >= lc_debug_level) THEN
1418: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1419: 'Service code domain type is missing');
1420: END IF;
1421:
1422: WHEN CSD_SCD_INVALID_ID THEN

Line 1430: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1426: x_return_status := FND_API.G_RET_STS_ERROR ;
1427:
1428: -- save message in fnd stack
1429: if (lc_stat_level >= lc_debug_level) then
1430: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1431: 'Adding message CSD_SCD_INVALID_ID to FND_MSG stack');
1432: end if;
1433: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ID');
1434: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);

Line 1443: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1439: p_data => x_msg_data );
1440:
1441: -- save message in debug log
1442: IF (lc_excep_level >= lc_debug_level) THEN
1443: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1444: 'Service code domain id is invalid');
1445: END IF;
1446:
1447: WHEN CSD_SCD_GET_OVN_ERROR THEN

Line 1455: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1451: x_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: -- save message in fnd stack
1454: if (lc_stat_level >= lc_debug_level) then
1455: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1456: 'Adding message CSD_SCD_GET_OVN_ERROR to FND_MSG stack');
1457: end if;
1458: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_OVN_ERROR');
1459: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);

Line 1468: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1464: p_data => x_msg_data );
1465:
1466: -- save message in debug log
1467: IF (lc_excep_level >= lc_debug_level) THEN
1468: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1469: 'Service code domain get object version number error');
1470: END IF;
1471:
1472: WHEN CSD_SCD_OVN_MISMATCH THEN

Line 1480: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1476: x_return_status := FND_API.G_RET_STS_ERROR ;
1477:
1478: -- save message in fnd stack
1479: if (lc_stat_level >= lc_debug_level) then
1480: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1481: 'Adding message CSD_SCD_OVN_MISMATCH to FND_MSG stack');
1482: end if;
1483: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_OVN_MISMATCH');
1484: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);

Line 1493: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1489: p_data => x_msg_data );
1490:
1491: -- save message in debug log
1492: IF (lc_excep_level >= lc_debug_level) THEN
1493: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1494: 'Service code domain object version number mismatch');
1495: END IF;
1496:
1497: WHEN CSD_SCD_DOMAIN_EXISTS THEN

Line 1505: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1501: x_return_status := FND_API.G_RET_STS_ERROR ;
1502:
1503: -- save message in fnd stack
1504: if (lc_stat_level >= lc_debug_level) then
1505: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1506: 'Adding message CSD_SCD_DOMAIN_EXISTS to FND_MSG stack');
1507: end if;
1508: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_DOMAIN_EXISTS');
1509: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_domain_rec.service_code_id);

Line 1518: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1514: p_data => x_msg_data );
1515:
1516: -- save message in debug log
1517: IF (lc_excep_level >= lc_debug_level) THEN
1518: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1519: 'Service code domain already exists');
1520: END IF;
1521:
1522: WHEN CSD_SCD_GET_ITEM_ERROR THEN

Line 1530: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1526: x_return_status := FND_API.G_RET_STS_ERROR ;
1527:
1528: -- save message in fnd stack
1529: if (lc_stat_level >= lc_debug_level) then
1530: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1531: 'Adding message CSD_SCD_GET_ITEM_ERROR to FND_MSG stack');
1532: end if;
1533: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_ITEM_ERROR');
1534: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);

Line 1543: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1539: p_data => x_msg_data );
1540:
1541: -- save message in debug log
1542: IF (lc_excep_level >= lc_debug_level) THEN
1543: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1544: 'Service code domain get item error');
1545: END IF;
1546:
1547: WHEN CSD_SCD_INVALID_ITEM THEN

Line 1555: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1551: x_return_status := FND_API.G_RET_STS_ERROR ;
1552:
1553: -- save message in fnd stack
1554: if (lc_stat_level >= lc_debug_level) then
1555: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1556: 'Adding message CSD_SCD_INVALID_ITEM to FND_MSG stack');
1557: end if;
1558: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ITEM');
1559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_sc_domain_rec.inventory_item_id);

Line 1568: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1564: p_data => x_msg_data );
1565:
1566: -- save message in debug log
1567: IF (lc_excep_level >= lc_debug_level) THEN
1568: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1569: 'Service code domain item is invalid');
1570: END IF;
1571:
1572: WHEN CSD_SCD_GET_CAT_SET_ERROR THEN

Line 1580: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1576: x_return_status := FND_API.G_RET_STS_ERROR ;
1577:
1578: -- save message in fnd stack
1579: if (lc_stat_level >= lc_debug_level) then
1580: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1581: 'Adding message CSD_SCD_GET_CAT_SET_ERROR to FND_MSG stack');
1582: end if;
1583: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CAT_SET_ERROR');
1584: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);

Line 1593: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1589: p_data => x_msg_data );
1590:
1591: -- save message in debug log
1592: IF (lc_excep_level >= lc_debug_level) THEN
1593: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1594: 'Service code domain get category set error');
1595: END IF;
1596:
1597: WHEN CSD_SCD_INVALID_CAT_SET THEN

Line 1605: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1601: x_return_status := FND_API.G_RET_STS_ERROR ;
1602:
1603: -- save message in fnd stack
1604: if (lc_stat_level >= lc_debug_level) then
1605: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1606: 'Adding message CSD_SCD_INVALID_CAT_SET to FND_MSG stack');
1607: end if;
1608: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CAT_SET');
1609: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);

Line 1618: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1614: p_data => x_msg_data );
1615:
1616: -- save message in debug log
1617: IF (lc_excep_level >= lc_debug_level) THEN
1618: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1619: 'Service code domain category set is invalid');
1620: END IF;
1621:
1622: WHEN CSD_SCD_GET_CATSET_FLAG_ERROR THEN

Line 1630: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1626: x_return_status := FND_API.G_RET_STS_ERROR ;
1627:
1628: -- save message in fnd stack
1629: if (lc_stat_level >= lc_debug_level) then
1630: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1631: 'Adding message CSD_SCD_GET_CATSET_FLAG_ERROR to FND_MSG stack');
1632: end if;
1633: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CATSET_FLAG_ERROR');
1634: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);

Line 1643: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1639: p_data => x_msg_data );
1640:
1641: -- save message in debug log
1642: IF (lc_excep_level >= lc_debug_level) THEN
1643: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1644: 'Service code domain category set validate flag is invalid');
1645: END IF;
1646:
1647: WHEN CSD_SCD_GET_CATEGORY_ERROR THEN

Line 1655: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1651: x_return_status := FND_API.G_RET_STS_ERROR ;
1652:
1653: -- save message in fnd stack
1654: if (lc_stat_level >= lc_debug_level) then
1655: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1656: 'Adding message CSD_SCD_GET_CATEGORY_ERROR to FND_MSG stack');
1657: end if;
1658: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CATEGORY_ERROR');
1659: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);

Line 1668: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1664: p_data => x_msg_data );
1665:
1666: -- save message in debug log
1667: IF (lc_excep_level >= lc_debug_level) THEN
1668: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1669: 'Service code domain get category error');
1670: END IF;
1671:
1672: WHEN CSD_SCD_INVALID_CATEGORY THEN

Line 1680: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1676: x_return_status := FND_API.G_RET_STS_ERROR ;
1677:
1678: -- save message in fnd stack
1679: if (lc_stat_level >= lc_debug_level) then
1680: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1681: 'Adding message CSD_SCD_INVALID_CATEGORY to FND_MSG stack');
1682: end if;
1683: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATEGORY');
1684: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_sc_domain_rec.category_id);

Line 1693: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1689: p_data => x_msg_data );
1690:
1691: -- save message in debug log
1692: IF (lc_excep_level >= lc_debug_level) THEN
1693: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1694: 'Service code domain category is invalid');
1695: END IF;
1696:
1697: WHEN FND_API.G_EXC_ERROR THEN

Line 1708: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1704: p_data => x_msg_data );
1705:
1706: -- save message in debug log
1707: IF (lc_excep_level >= lc_debug_level) THEN
1708: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1709: 'EXC_ERROR['||x_msg_data||']');
1710: END IF;
1711:
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1721: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1717: IF FND_MSG_PUB.Check_Msg_Level
1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: if (lc_stat_level >= lc_debug_level) then
1721: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1722: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1723: end if;
1724: FND_MSG_PUB.Add_Exc_Msg
1725: (G_PKG_NAME ,

Line 1735: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1731: p_data => x_msg_data );
1732:
1733: -- save message in debug log
1734: IF (lc_excep_level >= lc_debug_level) THEN
1735: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1736: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1737: END IF;
1738:
1739: WHEN OTHERS THEN

Line 1749: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1745: IF FND_MSG_PUB.Check_Msg_Level
1746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1747: THEN
1748: if (lc_stat_level >= lc_debug_level) then
1749: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1750: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1751: end if;
1752: FND_MSG_PUB.Add_Exc_Msg
1753: (G_PKG_NAME ,

Line 1764: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1760:
1761: -- save message in debug log
1762: IF (lc_excep_level >= lc_debug_level) THEN
1763: -- create a seeded message
1764: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1765: 'SQL Message['||sqlerrm||']' );
1766: END IF;
1767:
1768: END Update_SC_Domain;

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

1785: p_sc_domain_id IN NUMBER
1786: ) IS
1787:
1788: -- CONSTANTS --
1789: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1790: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1791: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

1786: ) IS
1787:
1788: -- CONSTANTS --
1789: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1790: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1791: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1794: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

1787:
1788: -- CONSTANTS --
1789: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1790: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1791: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1794: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1795: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

1788: -- CONSTANTS --
1789: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1790: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1791: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1794: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1795: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1796: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.delete_sc_domain';

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

1789: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1790: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1791: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1794: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1795: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1796: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.delete_sc_domain';
1797: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_SC_Domain';

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

1790: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1791: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1794: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1795: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1796: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.delete_sc_domain';
1797: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_SC_Domain';
1798: lc_api_version CONSTANT NUMBER := 1.0;

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

1791: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1792: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1793: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1794: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1795: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1796: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.delete_sc_domain';
1797: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_SC_Domain';
1798: lc_api_version CONSTANT NUMBER := 1.0;
1799:

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

1820: FND_MSG_PUB.initialize;
1821: END IF;
1822:
1823: IF (lc_proc_level >= lc_debug_level) THEN
1824: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
1825: 'Entered Delete_SC_Domain');
1826: END IF;
1827:
1828: -- Initialize API return status to success

Line 1835: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1831: -- Api body starts
1832:
1833: -- Check the required parameters
1834: if (lc_proc_level >= lc_debug_level) then
1835: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1836: 'Checking required parameter');
1837: end if;
1838:
1839: -- Check the required parameter

Line 1847: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1843: p_api_name => lc_api_name);
1844:
1845: -- Delete row
1846: if (lc_proc_level >= lc_debug_level) then
1847: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1848: 'Calling Delete_Row table handler');
1849: end if;
1850:
1851: BEGIN

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

1856:
1857: EXCEPTION
1858: WHEN OTHERS THEN
1859: IF ( lc_excep_level >= lc_debug_level) THEN
1860: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END;
1864:

Line 1870: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: if (lc_proc_level >= lc_debug_level) then
1870: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1871: 'Returned from Delete_Row table handler');
1872: end if;
1873:
1874: -- Api body ends here

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

1883: (p_count => x_msg_count,
1884: p_data => x_msg_data );
1885:
1886: IF (lc_proc_level >= lc_debug_level) THEN
1887: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1888: 'Leaving Delete_SC_Domain');
1889: END IF;
1890:
1891: EXCEPTION

Line 1904: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1900: p_data => x_msg_data );
1901:
1902: -- save message in debug log
1903: IF (lc_excep_level >= lc_debug_level) THEN
1904: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1905: 'EXC_ERROR['||x_msg_data||']');
1906: END IF;
1907:
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1917: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1913: IF FND_MSG_PUB.Check_Msg_Level
1914: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1915: THEN
1916: if (lc_stat_level >= lc_debug_level) then
1917: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1918: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1919: end if;
1920: FND_MSG_PUB.Add_Exc_Msg
1921: (G_PKG_NAME ,

Line 1931: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1927: p_data => x_msg_data );
1928:
1929: -- save message in debug log
1930: IF (lc_excep_level >= lc_debug_level) THEN
1931: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1932: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1933: END IF;
1934:
1935: WHEN OTHERS THEN

Line 1945: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1941: IF FND_MSG_PUB.Check_Msg_Level
1942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1943: THEN
1944: if (lc_stat_level >= lc_debug_level) then
1945: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1946: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1947: end if;
1948: FND_MSG_PUB.Add_Exc_Msg
1949: (G_PKG_NAME ,

Line 1960: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1956:
1957: -- save message in debug log
1958: IF (lc_excep_level >= lc_debug_level) THEN
1959: -- create a seeded message
1960: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1961: 'SQL Message['||sqlerrm||']' );
1962: END IF;
1963:
1964: END Delete_SC_Domain;

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

1981: p_sc_domain_rec IN SC_DOMAIN_REC_TYPE
1982: ) IS
1983:
1984: -- CONSTANTS --
1985: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1986: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1987: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

1982: ) IS
1983:
1984: -- CONSTANTS --
1985: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1986: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1987: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1990: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

1983:
1984: -- CONSTANTS --
1985: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1986: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1987: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1990: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1991: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

1984: -- CONSTANTS --
1985: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1986: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1987: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1990: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1991: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1992: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.lock_sc_domain';

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

1985: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1986: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1987: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1990: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1991: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1992: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.lock_sc_domain';
1993: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_SC_Domain';

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

1986: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1987: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1990: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1991: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1992: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.lock_sc_domain';
1993: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_SC_Domain';
1994: lc_api_version CONSTANT NUMBER := 1.0;

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

1987: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1988: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1989: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1990: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1991: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1992: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_domains_pvt.lock_sc_domain';
1993: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_SC_Domain';
1994: lc_api_version CONSTANT NUMBER := 1.0;
1995:

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

2016: FND_MSG_PUB.initialize;
2017: END IF;
2018:
2019: IF (lc_proc_level >= lc_debug_level) THEN
2020: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
2021: 'Entered Lock_SC_Domain');
2022: END IF;
2023:
2024: -- Initialize API return status to success

Line 2031: FND_LOG.STRING(lc_proc_level, lc_mod_name,

2027: -- Api body starts
2028:
2029: -- Check the required parameters
2030: if (lc_proc_level >= lc_debug_level) then
2031: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2032: 'Checking required parameters');
2033: end if;
2034:
2035: -- Check the required parameter

Line 2049: FND_LOG.STRING(lc_proc_level, lc_mod_name,

2045: p_api_name => lc_api_name);
2046:
2047: -- Lock row
2048: if (lc_proc_level >= lc_debug_level) then
2049: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2050: 'Calling Lock_Row table handler');
2051: end if;
2052:
2053: BEGIN

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

2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: IF ( lc_excep_level >= lc_debug_level) THEN
2095: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
2096: END IF;
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END;
2099:

Line 2105: FND_LOG.STRING(lc_proc_level, lc_mod_name,

2101: RAISE FND_API.G_EXC_ERROR;
2102: END IF;
2103:
2104: if (lc_proc_level >= lc_debug_level) then
2105: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2106: 'Returned from Lock_Row table handler');
2107: end if;
2108:
2109: -- Api body ends here

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

2118: (p_count => x_msg_count,
2119: p_data => x_msg_data );
2120:
2121: IF (lc_proc_level >= lc_debug_level) THEN
2122: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
2123: 'Leaving Lock_SC_Domain');
2124: END IF;
2125:
2126: EXCEPTION

Line 2139: FND_LOG.STRING(lc_excep_level, lc_mod_name,

2135: p_data => x_msg_data );
2136:
2137: -- save message in debug log
2138: IF (lc_excep_level >= lc_debug_level) THEN
2139: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2140: 'EXC_ERROR['||x_msg_data||']');
2141: END IF;
2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2152: FND_LOG.STRING(lc_stat_level, lc_mod_name,

2148: IF FND_MSG_PUB.Check_Msg_Level
2149: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2150: THEN
2151: if (lc_stat_level >= lc_debug_level) then
2152: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2153: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
2154: end if;
2155: FND_MSG_PUB.Add_Exc_Msg
2156: (G_PKG_NAME ,

Line 2166: FND_LOG.STRING(lc_excep_level, lc_mod_name,

2162: p_data => x_msg_data );
2163:
2164: -- save message in debug log
2165: IF (lc_excep_level >= lc_debug_level) THEN
2166: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2167: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
2168: END IF;
2169:
2170: WHEN OTHERS THEN

Line 2180: FND_LOG.STRING(lc_stat_level, lc_mod_name,

2176: IF FND_MSG_PUB.Check_Msg_Level
2177: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2178: THEN
2179: if (lc_stat_level >= lc_debug_level) then
2180: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2181: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
2182: end if;
2183: FND_MSG_PUB.Add_Exc_Msg
2184: (G_PKG_NAME ,

Line 2195: FND_LOG.STRING(lc_excep_level, lc_mod_name,

2191:
2192: -- save message in debug log
2193: IF (lc_excep_level >= lc_debug_level) THEN
2194: -- create a seeded message
2195: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2196: 'SQL Message['||sqlerrm||']' );
2197: END IF;
2198:
2199: END Lock_SC_Domain;