APPS.MSC_SUPPLY_PKG dependencies on FND_LOG

Line 798: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

794: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
795: retcode :=2;
796: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
797:
798: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
799: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
800: l_api_name,
801: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
802: end if;

Line 799: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

795: retcode :=2;
796: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
797:
798: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
799: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
800: l_api_name,
801: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
802: end if;
803:

Line 809: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

805: when dup_val_on_index then
806: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
807: retcode :=2;
808: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
809: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
810: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
811: l_api_name,
812: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
813: end if;

Line 810: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

806: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
807: retcode :=2;
808: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
809: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
810: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
811: l_api_name,
812: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
813: end if;
814:

Line 819: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

815: when others then
816: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
817: retcode :=2;
818: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
819: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
820: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
821: l_api_name,
822: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
823: end if;

Line 820: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

816: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
817: retcode :=2;
818: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
819: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
820: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
821: l_api_name,
822: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
823: end if;
824:

Line 1164: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1160: exception
1161: when others then
1162: retcode :=2;
1163: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
1164: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1165: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1166: l_api_name,
1167: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1168: end if;

Line 1165: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

1161: when others then
1162: retcode :=2;
1163: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
1164: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1165: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1166: l_api_name,
1167: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1168: end if;
1169: