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;
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:
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;
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:
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;
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);
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;
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: