DBA Data[Home] [Help]

APPS.GMD_FORMULA_DETAIL_PVT dependencies on GMD_DEBUG

Line 78: gmd_debug.put_line(' ');

74: /* Later on this insert should be changed to */
75: /* make insert on business view as opposed to tables directly. */
76:
77: IF (l_debug = 'Y') THEN
78: gmd_debug.put_line(' ');
79: END IF;
80:
81: IF (l_debug = 'Y') THEN
82: gmd_debug.put_line(' In formula detail Pvt - About to insert formulaline id = '

Line 82: gmd_debug.put_line(' In formula detail Pvt - About to insert formulaline id = '

78: gmd_debug.put_line(' ');
79: END IF;
80:
81: IF (l_debug = 'Y') THEN
82: gmd_debug.put_line(' In formula detail Pvt - About to insert formulaline id = '
83: ||p_formula_detail_rec.formulaline_id);
84: END IF;
85:
86: INSERT INTO fm_matl_dtl

Line 190: gmd_debug.put_line(' In formula detail Pvt - After insert formulaline insert ');

186: p_formula_detail_rec.attribute_category,
187: p_formula_detail_rec.prod_percent);
188: /* END API Body */
189: IF (l_debug = 'Y') THEN
190: gmd_debug.put_line(' In formula detail Pvt - After insert formulaline insert ');
191: END IF;
192:
193: IF (l_debug = 'Y') THEN
194: gmd_debug.put_line(' In formula detail Pvt - About to recalculate TOQ ');

Line 194: gmd_debug.put_line(' In formula detail Pvt - About to recalculate TOQ ');

190: gmd_debug.put_line(' In formula detail Pvt - After insert formulaline insert ');
191: END IF;
192:
193: IF (l_debug = 'Y') THEN
194: gmd_debug.put_line(' In formula detail Pvt - About to recalculate TOQ ');
195: END IF;
196: /* Recalculate the TOQ and TIQ */
197: GMD_COMMON_VAL.calculate_total_qty(
198: formula_id => p_formula_detail_rec.formula_id,

Line 207: gmd_debug.put_line(' In formula detail Pvt - Update header with TOQ '

203: x_msg_count => X_msg_cnt ,
204: x_msg_data => x_msg_dat );
205:
206: IF (l_debug = 'Y') THEN
207: gmd_debug.put_line(' In formula detail Pvt - Update header with TOQ '
208: ||' TIQ = '
209: ||l_ing_qty
210: ||' TOQ = '
211: ||l_product_qty);

Line 249: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '

245: ROLLBACK to Insert_FormulaDetail_PVT;
246: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF (l_debug = 'Y') THEN
249: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '
250: ||' - '
251: ||x_return_status);
252: END IF;
253:

Line 335: gmd_debug.put_line(' In Formula Detail PVT - '

331: /* API body */
332: /* Later on to be changed to update a business view */
333: /* and not a table. */
334: IF (l_debug = 'Y') THEN
335: gmd_debug.put_line(' In Formula Detail PVT - '
336: ||' Before the update of fm_matl_dtl '
337: ||' formulaline id - '
338: ||p_formula_detail_rec.formulaline_id
339: ||' line no '

Line 415: gmd_debug.put_line(' In Formula Detail PVT - '

411:
412: /* End API body */
413: /* Calculate the total input and output qty and update the formula header table */
414: IF (l_debug = 'Y') THEN
415: gmd_debug.put_line(' In Formula Detail PVT - '
416: ||' Before the TOQ calculation '
417: ||' - '
418: ||x_return_status);
419: END IF;

Line 430: gmd_debug.put_line(' In Formula Detail PVT - '

426: X_MSG_COUNT => X_msg_cnt ,
427: X_MSG_DATA => x_msg_dat );
428:
429: IF (l_debug = 'Y') THEN
430: gmd_debug.put_line(' In Formula Detail PVT - '
431: ||' Before the update of fm header with toq and tiq = '
432: ||' TOQ = '
433: ||l_product_qty
434: ||' TIQ = '

Line 477: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '

473: ROLLBACK to Update_FormulaDetail_PVT;
474: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF (l_debug = 'Y') THEN
477: gmd_debug.put_line(' In Formula Detail Pvt - In OTHERS Exception Section '
478: ||' - '
479: ||x_return_status);
480: END IF;
481: END Update_FormulaDetail;