APPS.CSD_ESTIMATES_FROM_BOM_PVT dependencies on FND_LOG

Line 49: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

45: exploder_error exception;
46:
47: BEGIN
48:
49: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
50: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
51: 'Entering explode_bom_items');
52: END IF;
53: --bug#6930575, subhat.

Line 50: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',

46:
47: BEGIN
48:
49: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
50: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
51: 'Entering explode_bom_items');
52: END IF;
53: --bug#6930575, subhat.
54: -- we will use exploder_userexit API no need for profile_id

Line 85: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

81: SELECT bom_explosion_temp_s.nextval INTO l_group_id from dual;
82: -- clear the bom temporary table
83: delete from bom_small_expl_temp;
84: -- calling exploder_userexit API.
85: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
86: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
87: 'Calling exploder_userexit');
88: end if;
89:

Line 86: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',

82: -- clear the bom temporary table
83: delete from bom_small_expl_temp;
84: -- calling exploder_userexit API.
85: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
86: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
87: 'Calling exploder_userexit');
88: end if;
89:
90: bompxinq.exploder_userexit (

Line 490: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

486:
487:
488: EXCEPTION
489: when exploder_error then
490: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
491: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Exploder_error',
492: 'Error occured while executing bom_exploder'||l_err_msg);
493: END IF;
494: rollback;

Line 491: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Exploder_error',

487:
488: EXCEPTION
489: when exploder_error then
490: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
491: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Exploder_error',
492: 'Error occured while executing bom_exploder'||l_err_msg);
493: END IF;
494: rollback;
495: WHEN OTHERS THEN

Line 496: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

492: 'Error occured while executing bom_exploder'||l_err_msg);
493: END IF;
494: rollback;
495: WHEN OTHERS THEN
496: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
497: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'others exception',
498: 'an unknown error occured');
499: end if;
500: rollback;

Line 497: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'others exception',

493: END IF;
494: rollback;
495: WHEN OTHERS THEN
496: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
497: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'others exception',
498: 'an unknown error occured');
499: end if;
500: rollback;
501: END explode_bom_items;

Line 552: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

548:
549: l_estimate_lines_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC := csd_process_util.ui_estimate_line_rec;
550:
551: BEGIN
552: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
553: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
554: 'Entering create_estimate_lines');
555: END IF;
556:

Line 553: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',

549: l_estimate_lines_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC := csd_process_util.ui_estimate_line_rec;
550:
551: BEGIN
552: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
553: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
554: 'Entering create_estimate_lines');
555: END IF;
556:
557: -- if message init is passed as yes initialize message stack.

Line 827: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

823: l_estimate_lines_rec.pricing_attribute98 := null;
824: l_estimate_lines_rec.pricing_attribute99 := null;
825: l_estimate_lines_rec.pricing_attribute100 := null;
826:
827: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
828: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
829: 'calling create_repair_estimate_lines API');
830: END IF;
831: -- call estimate lines API.

Line 828: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',

824: l_estimate_lines_rec.pricing_attribute99 := null;
825: l_estimate_lines_rec.pricing_attribute100 := null;
826:
827: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
828: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'begin',
829: 'calling create_repair_estimate_lines API');
830: END IF;
831: -- call estimate lines API.
832: csd_repair_estimate_pvt.create_repair_estimate_lines(

Line 845: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

841: x_msg_data => x_msg_data);
842: --dbms_output.put_line(x_return_status||' - '||x_message_Data);
843: IF x_return_status <> 'S' THEN
844: x_return_Status := 'E';
845: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
846: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Error',
847: 'An error occured during execution of create_repair_estimate API'||x_msg_data);
848: END IF;
849: --RAISE FND_API.G_EXC_ERROR;

Line 846: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Error',

842: --dbms_output.put_line(x_return_status||' - '||x_message_Data);
843: IF x_return_status <> 'S' THEN
844: x_return_Status := 'E';
845: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
846: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Error',
847: 'An error occured during execution of create_repair_estimate API'||x_msg_data);
848: END IF;
849: --RAISE FND_API.G_EXC_ERROR;
850: RETURN;