eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_PREQ_GRP dependencies on OE_DEBUG_PUB

Line 59: oe_debug_pub.add ('in bulk_preq, line_index : '|| p_line_rec.line_index(i));

55: --instead of line_id as line_id may be null
56: while i is not null
57: loop
58: --for i in 1..p_line_rec.line_id.count loop
59: oe_debug_pub.add ('in bulk_preq, line_index : '|| p_line_rec.line_index(i));
60: i := p_line_rec.line_id.next(i);
61: end loop;
62: End If;--debug
63: G_HVOP_pricing_ON := 'Y';

Line 148: oe_debug_pub.add('bulk.l_preq_count := ' || l_preq_count);

144:
145: If l_debug = 'T' Then
146: select count(*) into l_preq_count
147: from qp_int_lines ;
148: oe_debug_pub.add('bulk.l_preq_count := ' || l_preq_count);
149: oe_debug_pub.add('QP_PREQ_GRP.G_INT_LINES_NO='||QP_PREQ_GRP.G_INT_LINES_NO);
150: End If;
151:
152: G_line_index.delete;

Line 149: oe_debug_pub.add('QP_PREQ_GRP.G_INT_LINES_NO='||QP_PREQ_GRP.G_INT_LINES_NO);

145: If l_debug = 'T' Then
146: select count(*) into l_preq_count
147: from qp_int_lines ;
148: oe_debug_pub.add('bulk.l_preq_count := ' || l_preq_count);
149: oe_debug_pub.add('QP_PREQ_GRP.G_INT_LINES_NO='||QP_PREQ_GRP.G_INT_LINES_NO);
150: End If;
151:
152: G_line_index.delete;
153:

Line 161: oe_debug_pub.add('Before QP_BUILD_SOURCING_PVT.get_attribute_values (H)');

157: G_attr_value.delete;
158: G_validated_flag.delete;
159:
160: If l_debug = 'T' Then
161: oe_debug_pub.add('Before QP_BUILD_SOURCING_PVT.get_attribute_values (H)');
162: oe_debug_pub.add ('G_line_index.count := ' || G_line_index.count);
163: oe_debug_pub.add ('G_line_rec.line_id.count := ' || G_line_rec.line_id.count);
164: End If;
165:

Line 162: oe_debug_pub.add ('G_line_index.count := ' || G_line_index.count);

158: G_validated_flag.delete;
159:
160: If l_debug = 'T' Then
161: oe_debug_pub.add('Before QP_BUILD_SOURCING_PVT.get_attribute_values (H)');
162: oe_debug_pub.add ('G_line_index.count := ' || G_line_index.count);
163: oe_debug_pub.add ('G_line_rec.line_id.count := ' || G_line_rec.line_id.count);
164: End If;
165:
166:

Line 163: oe_debug_pub.add ('G_line_rec.line_id.count := ' || G_line_rec.line_id.count);

159:
160: If l_debug = 'T' Then
161: oe_debug_pub.add('Before QP_BUILD_SOURCING_PVT.get_attribute_values (H)');
162: oe_debug_pub.add ('G_line_index.count := ' || G_line_index.count);
163: oe_debug_pub.add ('G_line_rec.line_id.count := ' || G_line_rec.line_id.count);
164: End If;
165:
166:
167: Begin

Line 175: oe_debug_pub.add ('Build Sourcing Errored Out with: ' || sqlerrm);

171: Exception
172: when others then
173: Null;
174: If l_debug = 'T' Then
175: oe_debug_pub.add ('Build Sourcing Errored Out with: ' || sqlerrm);
176: End If;
177: End;
178:
179:

Line 183: oe_debug_pub.add('GlineCOUNT = '||G_line_index.COUNT);

179:
180: END IF;--p_header_rec.line_id.COUNT
181:
182: If l_debug = 'T' Then
183: oe_debug_pub.add('GlineCOUNT = '||G_line_index.COUNT);
184:
185: if G_line_index.count > 0 then
186: null;
187: oe_debug_pub.add('Glinelast = '||G_line_index.last);

Line 187: oe_debug_pub.add('Glinelast = '||G_line_index.last);

183: oe_debug_pub.add('GlineCOUNT = '||G_line_index.COUNT);
184:
185: if G_line_index.count > 0 then
186: null;
187: oe_debug_pub.add('Glinelast = '||G_line_index.last);
188: end if;
189:
190: --need to populate the new columns added to lines_tmp
191: --which are columns on ctrl rec for java engine

Line 193: oe_debug_pub.add ('*Bulk Debug Holes');

189:
190: --need to populate the new columns added to lines_tmp
191: --which are columns on ctrl rec for java engine
192:
193: oe_debug_pub.add ('*************Bulk Debug Holes************');
194:
195:
196: for i in G_line_index.first..G_line_index.last loop
197: oe_debug_pub.add ('i := ' || i);

Line 197: oe_debug_pub.add ('i := ' || i);

193: oe_debug_pub.add ('*************Bulk Debug Holes************');
194:
195:
196: for i in G_line_index.first..G_line_index.last loop
197: oe_debug_pub.add ('i := ' || i);
198: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));

Line 198: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));

194:
195:
196: for i in G_line_index.first..G_line_index.last loop
197: oe_debug_pub.add ('i := ' || i);
198: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));

Line 199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));

195:
196: for i in G_line_index.first..G_line_index.last loop
197: oe_debug_pub.add ('i := ' || i);
198: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
203: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));

Line 200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));

196: for i in G_line_index.first..G_line_index.last loop
197: oe_debug_pub.add ('i := ' || i);
198: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
203: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
204: end loop;

Line 201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));

197: oe_debug_pub.add ('i := ' || i);
198: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
203: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
204: end loop;
205: oe_debug_pub.add ('*************Bulk Debug Holes************');

Line 202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));

198: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
203: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
204: end loop;
205: oe_debug_pub.add ('*************Bulk Debug Holes************');
206: End If; --debug

Line 203: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));

199: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
200: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
203: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
204: end loop;
205: oe_debug_pub.add ('*************Bulk Debug Holes************');
206: End If; --debug
207:

Line 205: oe_debug_pub.add ('*Bulk Debug Holes');

201: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
202: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
203: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
204: end loop;
205: oe_debug_pub.add ('*************Bulk Debug Holes************');
206: End If; --debug
207:
208:
209: BEGIN

Line 238: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);

234: );
235:
236: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;
237: IF l_debug = 'T' THEN
238: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);
239: END IF;
240: End If;
241: EXCEPTION
242: WHEN OTHERS THEN

Line 244: oe_debug_pub.add('Error inserting to qp_preq_line_attrs_temp' || sqlerrm);

240: End If;
241: EXCEPTION
242: WHEN OTHERS THEN
243: If l_debug = 'T' Then
244: oe_debug_pub.add('Error inserting to qp_preq_line_attrs_temp' || sqlerrm);
245: End If;
246: END;
247:
248:

Line 348: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LINES_NO :=' || QP_PREQ_GRP.G_INT_LINES_NO);

344:
345: QP_PREQ_GRP.G_INT_LINES_NO := QP_PREQ_GRP.G_INT_LINES_NO + p_line_rec.LINE_ID.count;
346:
347: if l_debug = 'T' then
348: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LINES_NO :=' || QP_PREQ_GRP.G_INT_LINES_NO);
349: end if; --debug
350:
351: END IF;--p_line_rec.line_id.COUNT
352:

Line 362: oe_debug_pub.add ('Checking header_id on lines.....');

358: G_validated_flag.delete;
359:
360:
361: If l_debug = 'T' Then
362: oe_debug_pub.add ('Checking header_id on lines.....');
363: IF p_line_rec.line_id.count > 0 THEN
364: for i in p_line_rec.line_id.first..p_line_rec.line_id.last
365: loop
366: IF p_line_rec.header_id.exists(i) THEN

Line 367: oe_debug_pub.add ('header_id ' ||i || ': ' || p_line_rec.header_id(i));

363: IF p_line_rec.line_id.count > 0 THEN
364: for i in p_line_rec.line_id.first..p_line_rec.line_id.last
365: loop
366: IF p_line_rec.header_id.exists(i) THEN
367: oe_debug_pub.add ('header_id ' ||i || ': ' || p_line_rec.header_id(i));
368: oe_debug_pub.add ('header_index ' ||i || ': ' || p_line_rec.header_index(i));
369: END IF;
370: end loop;
371: oe_debug_pub.add('Before get_attributes code=L');

Line 368: oe_debug_pub.add ('header_index ' ||i || ': ' || p_line_rec.header_index(i));

364: for i in p_line_rec.line_id.first..p_line_rec.line_id.last
365: loop
366: IF p_line_rec.header_id.exists(i) THEN
367: oe_debug_pub.add ('header_id ' ||i || ': ' || p_line_rec.header_id(i));
368: oe_debug_pub.add ('header_index ' ||i || ': ' || p_line_rec.header_index(i));
369: END IF;
370: end loop;
371: oe_debug_pub.add('Before get_attributes code=L');
372: END IF;

Line 371: oe_debug_pub.add('Before get_attributes code=L');

367: oe_debug_pub.add ('header_id ' ||i || ': ' || p_line_rec.header_id(i));
368: oe_debug_pub.add ('header_index ' ||i || ': ' || p_line_rec.header_index(i));
369: END IF;
370: end loop;
371: oe_debug_pub.add('Before get_attributes code=L');
372: END IF;
373: End If;
374:
375: QP_BUILD_SOURCING_PVT.get_attribute_values

Line 380: oe_debug_pub.add('After get_attributes code=L');

376: ('ONT', 'L',
377: l_qual_ctxts_result_tbl, l_price_ctxts_result_tbl);
378:
379: If l_debug = 'T' Then
380: oe_debug_pub.add('After get_attributes code=L');
381: oe_debug_pub.add ('*************Bulk Debug Holes Lines Begin************');
382: for i in G_line_index.first..G_line_index.last loop
383: Null;
384: oe_debug_pub.add ('i := ' || i);

Line 381: oe_debug_pub.add ('*Bulk Debug Holes Lines Begin');

377: l_qual_ctxts_result_tbl, l_price_ctxts_result_tbl);
378:
379: If l_debug = 'T' Then
380: oe_debug_pub.add('After get_attributes code=L');
381: oe_debug_pub.add ('*************Bulk Debug Holes Lines Begin************');
382: for i in G_line_index.first..G_line_index.last loop
383: Null;
384: oe_debug_pub.add ('i := ' || i);
385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));

Line 384: oe_debug_pub.add ('i := ' || i);

380: oe_debug_pub.add('After get_attributes code=L');
381: oe_debug_pub.add ('*************Bulk Debug Holes Lines Begin************');
382: for i in G_line_index.first..G_line_index.last loop
383: Null;
384: oe_debug_pub.add ('i := ' || i);
385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));

Line 385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));

381: oe_debug_pub.add ('*************Bulk Debug Holes Lines Begin************');
382: for i in G_line_index.first..G_line_index.last loop
383: Null;
384: oe_debug_pub.add ('i := ' || i);
385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));

Line 386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));

382: for i in G_line_index.first..G_line_index.last loop
383: Null;
384: oe_debug_pub.add ('i := ' || i);
385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
390: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));

Line 387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));

383: Null;
384: oe_debug_pub.add ('i := ' || i);
385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
390: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
391: end loop;

Line 388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));

384: oe_debug_pub.add ('i := ' || i);
385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
390: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
391: end loop;
392: oe_debug_pub.add ('*************Bulk Debug Holes Lines End************');

Line 389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));

385: oe_debug_pub.add ('G_line_index(i)+l_line_count '|| (G_line_index(i)+l_line_count));
386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
390: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
391: end loop;
392: oe_debug_pub.add ('*************Bulk Debug Holes Lines End************');
393: End If;

Line 390: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));

386: oe_debug_pub.add ('G_attr_type(i) '|| G_attr_type(i));
387: oe_debug_pub.add ('G_attr_context(i) '|| G_attr_context(i));
388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
390: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
391: end loop;
392: oe_debug_pub.add ('*************Bulk Debug Holes Lines End************');
393: End If;
394:

Line 392: oe_debug_pub.add ('*Bulk Debug Holes Lines End');

388: oe_debug_pub.add ('G_attr_attr(i) '|| G_attr_attr(i));
389: oe_debug_pub.add ('G_attr_value(i) '|| G_attr_value(i));
390: oe_debug_pub.add ('G_validated_flag(i) '|| NVL (G_validated_flag(i), 'N'));
391: end loop;
392: oe_debug_pub.add ('*************Bulk Debug Holes Lines End************');
393: End If;
394:
395: if G_line_index.count > 0 then
396: forall i in G_line_index.first..G_line_index.last

Line 422: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);

418: QP_PREQ_PUB.G_YES
419: );
420: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;
421: IF l_debug = FND_API.G_TRUE THEN
422: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);
423: END IF;
424: end if;--G_line_index.count
425:
426: If l_debug = 'T' Then

Line 427: oe_debug_pub.add ('Finished QPBGPREB lines: Success');

423: END IF;
424: end if;--G_line_index.count
425:
426: If l_debug = 'T' Then
427: oe_debug_pub.add ('Finished QPBGPREB lines: Success');
428: End If;
429: COMMIT;
430:
431: EXCEPTION

Line 436: oe_debug_pub.add ('Finished QPBGPREB lines:' ||SQLERRM);

432: When OTHERS Then
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: x_return_status_text := 'Exception in Bulk_insert_lines '||SQLERRM;
435: If l_debug = 'T' Then
436: oe_debug_pub.add ('Finished QPBGPREB lines:' ||SQLERRM);
437: End If;
438: END Bulk_insert_lines;
439:
440: Procedure Bulk_insert_adj(x_return_status OUT NOCOPY VARCHAR2,

Line 448: oe_debug_pub.add ('Started QPBGPREB Adjs:' ||SQLERRM);

444: PRAGMA AUTONOMOUS_TRANSACTION;
445: BEGIN
446:
447: If l_debug = 'T' Then
448: oe_debug_pub.add ('Started QPBGPREB Adjs:' ||SQLERRM);
449: End If;
450: insert into qp_int_ldets
451: (LINE_DETAIL_INDEX,
452: LINE_DETAIL_TYPE_CODE,

Line 545: oe_debug_pub.add('Number of line level adjustments are '||line_ldet_count);

541:
542: select nvl(max(line_detail_index),0) into line_ldet_count from qp_int_ldets; -- fix for bug 3406218
543:
544: If l_debug = 'T' Then
545: oe_debug_pub.add('Number of line level adjustments are '||line_ldet_count);
546: End if;
547:
548: --UNION --split the insert statement for bug 3406218
549: insert into qp_int_ldets

Line 643: oe_debug_pub.add ('QP_BULK_PREQ_GRP.bulk_insert_adj inserted adj count='||SQL%ROWCOUNT);

639: and ll.list_line_id = adj_iface.list_line_id
640: and lhdr.list_header_id = ll.list_header_id);
641:
642: IF l_debug = FND_API.G_TRUE THEN
643: oe_debug_pub.add ('QP_BULK_PREQ_GRP.bulk_insert_adj inserted adj count='||SQL%ROWCOUNT);
644: END IF;
645:
646: --added for java engine stats accumulation on li's request
647: select count(*) into ldet_count

Line 661: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LDETS_NO='||QP_PREQ_GRP.G_INT_LDETS_NO);

657: and lhdr.list_header_id = ll.list_header_id;
658:
659: QP_PREQ_GRP.G_INT_LDETS_NO := QP_PREQ_GRP.G_INT_LDETS_NO + ldet_count;
660: IF l_debug = FND_API.G_TRUE THEN
661: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LDETS_NO='||QP_PREQ_GRP.G_INT_LDETS_NO);
662: END IF;
663:
664: IF l_debug = FND_API.G_TRUE THEN
665: FOR cl in (select line_index, line_detail_index, operand_value, operand_calculation_code, updated_flag, applied_flag

Line 668: oe_debug_pub.add('Inserted ldet details: line_index '||cl.line_index||' line_detail_index '||cl.line_detail_index

664: IF l_debug = FND_API.G_TRUE THEN
665: FOR cl in (select line_index, line_detail_index, operand_value, operand_calculation_code, updated_flag, applied_flag
666: ,created_from_list_line_id, automatic_flag, override_flag from qp_int_ldets)
667: LOOP
668: oe_debug_pub.add('Inserted ldet details: line_index '||cl.line_index||' line_detail_index '||cl.line_detail_index
669: ||' created_from_list_line_id '||cl.created_from_list_line_id||' operand_value '||cl.operand_value||' arithmetic_operator '
670: ||cl.operand_calculation_code||' updated_flag '||cl.updated_flag||' applied_flag '||cl.applied_flag||' automatic_flag '
671: ||cl.automatic_flag||' override_flag '||cl.override_flag);
672: END LOOP;

Line 678: oe_debug_pub.add ('Finished QPBGPREB adjs: Success') ;

674:
675: COMMIT;
676:
677: If l_debug = 'T' Then
678: oe_debug_pub.add ('Finished QPBGPREB adjs: Success') ;
679: End If;
680: EXCEPTION
681: When OTHERS Then
682: x_return_status := FND_API.G_RET_STS_ERROR;

Line 685: oe_debug_pub.add ('Finished QPBGPREB adjs:' ||SQLERRM);

681: When OTHERS Then
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: x_return_status_text := 'Exception in Bulk_insert_adj '||SQLERRM;
684: If l_debug = 'T' Then
685: oe_debug_pub.add ('Finished QPBGPREB adjs:' ||SQLERRM);
686: End If;
687: End Bulk_insert_adj;
688:
689: END QP_BULK_PREQ_GRP;