APPS.ENG_SUB_COMPONENT_UTIL dependencies on DBMS_OUTPUT

Line 174: dbms_output.put_line('Within Update Row . . .');

170: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
171: BEGIN
172:
173: -- Lock the row before updating the row
174: dbms_output.put_line('Within Update Row . . .');
175: dbms_output.put_line('Comp.SeqId : ' ||
176: to_Char(p_sub_comp_Unexp_rec.component_sequence_id)
177: );
178: dbms_output.put_line('Sub. Comp : ' ||

Line 175: dbms_output.put_line('Comp.SeqId : ' ||

171: BEGIN
172:
173: -- Lock the row before updating the row
174: dbms_output.put_line('Within Update Row . . .');
175: dbms_output.put_line('Comp.SeqId : ' ||
176: to_Char(p_sub_comp_Unexp_rec.component_sequence_id)
177: );
178: dbms_output.put_line('Sub. Comp : ' ||
179: to_Char(p_sub_comp_Unexp_rec.substitute_component_id)

Line 178: dbms_output.put_line('Sub. Comp : ' ||

174: dbms_output.put_line('Within Update Row . . .');
175: dbms_output.put_line('Comp.SeqId : ' ||
176: to_Char(p_sub_comp_Unexp_rec.component_sequence_id)
177: );
178: dbms_output.put_line('Sub. Comp : ' ||
179: to_Char(p_sub_comp_Unexp_rec.substitute_component_id)
180: );
181: dbms_output.put_line('Acd_Type : ' || to_Char(p_sub_component_rec.acd_type));
182:

Line 181: dbms_output.put_line('Acd_Type : ' || to_Char(p_sub_component_rec.acd_type));

177: );
178: dbms_output.put_line('Sub. Comp : ' ||
179: to_Char(p_sub_comp_Unexp_rec.substitute_component_id)
180: );
181: dbms_output.put_line('Acd_Type : ' || to_Char(p_sub_component_rec.acd_type));
182:
183:
184: UPDATE BOM_SUBSTITUTE_COMPONENTS
185: SET SUBSTITUTE_ITEM_QUANTITY =

Line 211: dbms_output.put_line('Update Row successful . . . ');

207: AND COMPONENT_SEQUENCE_ID = p_sub_comp_Unexp_rec.component_sequence_id
208: AND ACD_TYPE = p_sub_component_rec.acd_type
209: ;
210: -- end if;
211: dbms_output.put_line('Update Row successful . . . ');
212:
213: x_return_status := FND_API.G_RET_STS_SUCCESS;
214: EXCEPTION
215:

Line 236: dbms_output.put_line('Update Row Unexpected Error: ' || l_err_text);

232: THEN
233: l_err_text := G_PKG_NAME ||
234: 'Utility (SubStitute Component Update)' ||
235: SUBSTR(SQLERRM, 1, 100);
236: dbms_output.put_line('Update Row Unexpected Error: ' || l_err_text);
237:
238: Error_Handler.Add_Error_Token
239: ( p_Message_Name => NULL
240: , p_Message_Text => l_err_text