DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on FND_LOG

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

1364:
1365: retcode :=2;
1366: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
1367:
1368: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1369: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1370: l_api_name,
1371: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1372: end if;

Line 1369: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

1365: retcode :=2;
1366: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
1367:
1368: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1369: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1370: l_api_name,
1371: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1372: end if;
1373:

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

1374:
1375: when dup_val_on_index then
1376: retcode :=2;
1377: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
1378: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1379: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1380: l_api_name,
1381: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1382: end if;

Line 1379: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

1375: when dup_val_on_index then
1376: retcode :=2;
1377: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
1378: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1379: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1380: l_api_name,
1381: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1382: end if;
1383:

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

1383:
1384: when others then
1385: retcode :=2;
1386: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
1387: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1388: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1389: l_api_name,
1390: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1391: end if;

Line 1388: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

1384: when others then
1385: retcode :=2;
1386: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
1387: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1388: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1389: l_api_name,
1390: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1391: end if;
1392: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);

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

1778: when others then
1779:
1780: retcode :=2;
1781: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
1782: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1783: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1784: l_api_name,
1785: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1786: end if;

Line 1783: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

1779:
1780: retcode :=2;
1781: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
1782: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1783: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1784: l_api_name,
1785: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);
1786: end if;
1787: