APPS.SOA_REMOVE dependencies on DBMS_OUTPUT

Line 19: --dbms_output.put_line('STARTING Removal Process');

15: ) IS
16:
17: c_irep_base_name fnd_irep_classes .irep_name%type;
18: c_class_type fnd_irep_classes .class_type%type;
19: --dbms_output.put_line('STARTING Removal Process');
20: cursor c_derived_class_entry(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number , c_service_type in fnd_irep_classes .class_type%type) is
21: select class_id,class_type from fnd_irep_classes where irep_name = c_irep_name and assoc_class_id = c_base_class_id and class_type = c_service_type;
22:
23: cursor c_derived_class_entry1(c_irep_name in fnd_irep_classes .irep_name%type , c_base_class_id in number, c_service_type in fnd_irep_classes. class_type%type) is

Line 67: --dbms_output.put_line('classId to delete' || c_derived_class_entry_rec1.class_id);

63: remove_derived_function_entry(c_derived_class_entry_rec1.class_id,p_err_code ,p_err_message );
64:
65: begin
66: delete from fnd_irep_classes where class_id = c_derived_class_entry_rec1.class_id;
67: --dbms_output.put_line('classId to delete' || c_derived_class_entry_rec1.class_id);
68: exception
69: when program_exit then
70: raise program_exit;
71: when others then

Line 132: DBMS_OUTPUT.PUT_LINE('XMLGateway service exempted from fnd_form_functions check ');

128: if c_function_rec.l_count = 0 then
129: select assoc_class_id into base_class_id from fnd_irep_classes where class_id=p_derived_class_id;
130: select class_type into c_class_type from fnd_irep_classes where class_id=base_class_id;
131: if c_class_type = 'XMLGATEWAY' then
132: DBMS_OUTPUT.PUT_LINE('XMLGateway service exempted from fnd_form_functions check ');
133: else
134: p_err_code := -1;
135: p_err_message := wf_core.translate('WF_WS_DERIVED_FUNC_NOT_EXIST');
136: raise program_exit;

Line 151: --dbms_output.put_line('functionId to delete' || c_derived_function_entry_rec.function_id );

147: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');
148: raise program_exit;
149: end if;
150: remove_function_lang_entries(c_derived_function_entry_rec.function_id ,p_derived_class_id ,p_err_code ,p_err_message );
151: --dbms_output.put_line('functionId to delete' || c_derived_function_entry_rec.function_id );
152: delete from fnd_form_functions where function_id = c_derived_function_entry_rec.function_id;
153: f_count := f_count -1;
154: END LOOP;
155: if(f_count = 0) then

Line 192: dbms_output.put_line(c_derived_function_tl_rec.language);

188: raise program_exit;
189: end if ;
190: /*FOR c_derived_function_tl_rec IN c_derived_function_tl(p_derived_function_id)
191: LOOP
192: dbms_output.put_line(c_derived_function_tl_rec.language);
193: END LOOP;*/
194: remove_class_lang_entry(p_derived_class_id,p_err_code,p_err_message);
195: delete from fnd_form_functions_tl where function_id = p_derived_function_id;
196: p_err_code := 0;

Line 234: dbms_output.put_line(c_derived_class_tl_rec.language);

230: end if;
231:
232: /* FOR c_derived_class_tl_rec IN c_derived_class_tl(p_derived_class_id)
233: LOOP
234: dbms_output.put_line(c_derived_class_tl_rec.language);
235: END LOOP;*/
236: delete from fnd_irep_classes_tl where class_id = p_derived_class_id ;
237: p_err_code := 0;
238: p_err_message := wf_core.translate('WF_WS_DELETE_SUCCESS');