APPS.MSC_DEMANTRA_PKG dependencies on DBMS_OUTPUT

Line 32: --dbms_output.put_line(l_api_name||'('||p_plan_id||', '||p_plan_run_id||')');

28: null;
29: end;
30:
31:
32: --dbms_output.put_line(l_api_name||'('||p_plan_id||', '||p_plan_run_id||')');
33: insert into msc_demantra_f (
34: ods_plan_id,
35: plan_id,
36: plan_run_id,

Line 146: --dbms_output.put_line('rowcount='||SQL%ROWCOUNT);

142: and mpc.customer_site_id = t.customer_site_id
143: and mpc.region_id = decode(t.customer_id, -23453, t.zone_id, mpc.region_id);
144:
145: commit;
146: --dbms_output.put_line('rowcount='||SQL%ROWCOUNT);
147:
148: populate_summary(errbuf, retcode, p_plan_id, p_plan_run_id);
149:
150: exception

Line 152: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM);

148: populate_summary(errbuf, retcode, p_plan_id, p_plan_run_id);
149:
150: exception
151: when dup_val_on_index then
152: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM);
153: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
154: SQLCODE||' -ERROR- '||SQLERRM;
155: retcode := 2;
156:

Line 163: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM);

159: end if;
160:
161:
162: when others then
163: --dbms_output.put_line(to_char(SQLCODE) || ':' || SQLERRM);
164: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
165: SQLCODE||' -ERROR- '||SQLERRM;
166: retcode := 2;
167:

Line 239: dbms_output.put_line(errbuf);

235: when dup_val_on_index then
236: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
237: SQLCODE||' -ERROR- '||SQLERRM;
238: retcode := 2;
239: dbms_output.put_line(errbuf);
240: when others then
241: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
242: SQLCODE||' -ERROR- '||SQLERRM;
243: retcode := 2;

Line 244: dbms_output.put_line(errbuf);

240: when others then
241: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
242: SQLCODE||' -ERROR- '||SQLERRM;
243: retcode := 2;
244: dbms_output.put_line(errbuf);
245:
246: end populate_summary;
247:
248: procedure purge_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,