APPS.QP_UPDATE_FORMULAPRICE_PVT dependencies on DBMS_OUTPUT

Line 86: dbms_output.put_line('looping through the qp_price_formulas_cur');

82:
83: /* Select the Price Formulas which are to be used to update list prices. */
84: /* Select all or a specific formula depending on the option selected. */
85:
86: dbms_output.put_line('looping through the qp_price_formulas_cur');
87:
88: FOR l_formulas_rec IN qp_price_formulas_cur(p_price_formula_id,
89: p_retrieve_all_flag)
90: LOOP

Line 91: --dbms_output.put_line('inside qp_price_formulas_cur formula_id: '||l_formulas_rec.price_formula_id);

87:
88: FOR l_formulas_rec IN qp_price_formulas_cur(p_price_formula_id,
89: p_retrieve_all_flag)
90: LOOP
91: --dbms_output.put_line('inside qp_price_formulas_cur formula_id: '||l_formulas_rec.price_formula_id);
92:
93: Qp_Formula_Price_Calc_Pvt.Parse_Formula(l_formulas_rec.formula,
94: x_return_status);
95:

Line 99: --dbms_output.put_line('error in formula parsing ' || l_error_message);

95:
96: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
97: l_error_message := Fnd_Message.GET;
98: Fnd_File.put_line(Fnd_File.LOG,l_error_message);
99: --dbms_output.put_line('error in formula parsing ' || l_error_message);
100: END IF;
101:
102: IF p_update_flagged_items = 'Y' THEN
103: OPEN qp_list_lines_cursor FOR

Line 120: --DBMS_OUTPUT.PUT_LINE ('>>>>>>>>>>>> inside qp_list_lines_cursor loop list_line_id: '||l_lines_rec.list_line_id);

116:
117: FETCH qp_list_lines_cursor INTO l_lines_rec;
118: WHILE qp_list_lines_cursor%FOUND LOOP
119:
120: --DBMS_OUTPUT.PUT_LINE ('>>>>>>>>>>>> inside qp_list_lines_cursor loop list_line_id: '||l_lines_rec.list_line_id);
121:
122:
123: Qp_Number.canonical_mask :=
124: '00999999999999999999999.99999999999999999999999999999999999999'; --Added for 2884567

Line 129: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');

125: l_req_line_attrs_tbl.DELETE; /* Empty the plsql table for each list line */
126:
127: --Delete already existing rows from formula tmp table
128: --DELETE FROM qp_preq_line_attrs_formula_tmp;
129: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');
130:
131: FOR l_attributes_rec IN qp_pricing_attributes_cur(l_lines_rec.list_line_id)
132: LOOP
133:

Line 271: --dbms_output.put_line('value returned by the formula calculation engine ' || l_list_price);

267: p_line_index => 0,
268: p_list_line_type_code => 'PLL',
269: x_return_status => x_return_status,
270: p_modifier_value => NULL);
271: --dbms_output.put_line('value returned by the formula calculation engine ' || l_list_price);
272:
273: --Delete the temp table records inserted above
274: DELETE FROM qp_preq_line_attrs_formula_tmp; -- no need since it is done at the beginning of processing each line
275: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');

Line 275: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');

271: --dbms_output.put_line('value returned by the formula calculation engine ' || l_list_price);
272:
273: --Delete the temp table records inserted above
274: DELETE FROM qp_preq_line_attrs_formula_tmp; -- no need since it is done at the beginning of processing each line
275: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');
276:
277: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
278: l_error_message := Fnd_Message.GET;
279: Fnd_File.put_line(Fnd_File.LOG,l_error_message);

Line 315: --dbms_output.put_line('updated qp_list_lines ');

311: last_update_date = l_sysdate,
312: last_update_login = l_conc_login_id,
313: operand = l_list_price
314: WHERE list_line_id = l_lines_rec.list_line_id;
315: --dbms_output.put_line('updated qp_list_lines ');
316: END IF;
317: -- further fix 4090315 retrieve the next row,
318: -- the %found condition will be checked bfe the loop continues again
319: FETCH qp_list_lines_cursor INTO l_lines_rec;