153: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
154: SQLCODE||' -ERROR- '||SQLERRM;
155: retcode := 2;
156:
157: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
158: fnd_log.string(fnd_log.level_unexpected, l_api_name, to_char(SQLCODE)||':'||SQLERRM);
159: end if;
160:
161:
154: SQLCODE||' -ERROR- '||SQLERRM;
155: retcode := 2;
156:
157: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
158: fnd_log.string(fnd_log.level_unexpected, l_api_name, to_char(SQLCODE)||':'||SQLERRM);
159: end if;
160:
161:
162: when others then
164: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
165: SQLCODE||' -ERROR- '||SQLERRM;
166: retcode := 2;
167:
168: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
169: fnd_log.string(fnd_log.level_unexpected, l_api_name, to_char(SQLCODE)||':'||SQLERRM);
170: end if;
171:
172: end populate_details;
165: SQLCODE||' -ERROR- '||SQLERRM;
166: retcode := 2;
167:
168: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
169: fnd_log.string(fnd_log.level_unexpected, l_api_name, to_char(SQLCODE)||':'||SQLERRM);
170: end if;
171:
172: end populate_details;
173:
264: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
265: SQLCODE||' -ERROR- '||SQLERRM;
266: retcode := 2;
267:
268: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
269: fnd_log.string(fnd_log.level_unexpected, l_api_name, to_char(SQLCODE)||':'||SQLERRM);
270: end if;
271:
272: end purge_details;
265: SQLCODE||' -ERROR- '||SQLERRM;
266: retcode := 2;
267:
268: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
269: fnd_log.string(fnd_log.level_unexpected, l_api_name, to_char(SQLCODE)||':'||SQLERRM);
270: end if;
271:
272: end purge_details;
273: