DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on MSC_PHUB_UTIL

Line 1366: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;

1362: exception
1363: when no_data_found 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,

Line 1377: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;

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

Line 1386: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

1382: end if;
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);

Line 1732: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||

1728: commit;
1729:
1730: exception
1731: when dup_val_on_index then
1732: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
1733: SQLCODE||' -ERROR- '||SQLERRM;
1734: retcode := 2;
1735: --dbms_output.put_line(errbuf);
1736: when others then

Line 1737: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||

1733: SQLCODE||' -ERROR- '||SQLERRM;
1734: retcode := 2;
1735: --dbms_output.put_line(errbuf);
1736: when others then
1737: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
1738: SQLCODE||' -ERROR- '||SQLERRM;
1739: retcode := 2;
1740: --dbms_output.put_line(errbuf);
1741:

Line 1781: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

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