APPS.MSC_ITEM_PKG dependencies on FND_LOG

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

1908: when no_data_found then
1909:
1910: retcode :=2;
1911: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1912: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1913: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1914: l_api_name,
1915: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1916: end if;

Line 1913: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

1909:
1910: retcode :=2;
1911: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1912: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1913: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1914: l_api_name,
1915: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1916: end if;
1917:

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

1918: errbuf := SQLERRM;
1919: when others then
1920: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1921: retcode :=2;
1922: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1923: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1924: l_api_name,
1925: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1926:

Line 1923: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

1919: when others then
1920: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1921: retcode :=2;
1922: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1923: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1924: l_api_name,
1925: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1926:
1927: end if;

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

2188: exception
2189: when others then
2190: retcode :=2;
2191: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
2192: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2193: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
2194: l_api_name,
2195: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
2196: end if;

Line 2193: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

2189: when others then
2190: retcode :=2;
2191: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
2192: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2193: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
2194: l_api_name,
2195: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
2196: end if;
2197: