APPS.QP_BUILD_SOURCING_PVT_TMP dependencies on FND_API

Line 40: prev_header_id NUMBER := FND_API.G_MISS_NUM;

36: q_count NUMBER := 1;
37: p_count NUMBER := 1;
38: v_index NUMBER := 1;
39: v_tot_time NUMBER := 0;
40: prev_header_id NUMBER := FND_API.G_MISS_NUM;
41:
42: l_debug VARCHAR2(3);
43: BEGIN
44: qp_debug_util.tstart('FETCH_ATTRIBUTES','Fetching the Attribute Values');

Line 49: IF l_debug = FND_API.G_TRUE THEN

45:
46: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
47: if p_pricing_type_code = 'H' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then
48: qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;
49: IF l_debug = FND_API.G_TRUE THEN
50: oe_debug_pub.add('hw/src/H: change to g_yes');
51: END IF;
52: end if;
53:

Line 227: IF v_attr_value = FND_API.G_MISS_NUM THEN

223: v_attr_value := NULL;
224: END;
225:
226: BEGIN
227: IF v_attr_value = FND_API.G_MISS_NUM THEN
228: v_attr_value := NULL;
229: END IF;
230: EXCEPTION
231: WHEN VALUE_ERROR THEN

Line 232: IF v_attr_value = FND_API.G_MISS_CHAR THEN

228: v_attr_value := NULL;
229: END IF;
230: EXCEPTION
231: WHEN VALUE_ERROR THEN
232: IF v_attr_value = FND_API.G_MISS_CHAR THEN
233: v_attr_value := NULL;
234: END IF;
235: WHEN OTHERS THEN
236: v_attr_value := NULL;

Line 245: IF l_debug = FND_API.G_TRUE THEN

241: x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
242: x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
243: x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
244: q_count := q_count + 1;
245: IF l_debug = FND_API.G_TRUE THEN
246: oe_debug_pub.add('After product assigned');
247: END IF;
248: END IF;--v_attr_(m)value
249: END IF;

Line 313: IF v_attr_value = FND_API.G_MISS_NUM THEN

309: v_attr_value := NULL;
310: END;
311:
312: BEGIN
313: IF v_attr_value = FND_API.G_MISS_NUM THEN
314: v_attr_value := NULL;
315: END IF;
316: EXCEPTION
317: WHEN VALUE_ERROR THEN

Line 318: IF v_attr_value = FND_API.G_MISS_CHAR THEN

314: v_attr_value := NULL;
315: END IF;
316: EXCEPTION
317: WHEN VALUE_ERROR THEN
318: IF v_attr_value = FND_API.G_MISS_CHAR THEN
319: v_attr_value := NULL;
320: END IF;
321: WHEN OTHERS THEN
322: v_attr_value := NULL;

Line 331: IF l_debug = FND_API.G_TRUE THEN

327: x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
328: x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
329: x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
330: q_count := q_count + 1;
331: IF l_debug = FND_API.G_TRUE THEN
332: oe_debug_pub.add('After product assigned');
333: END IF;
334: END IF;--v_attr_(m)value
335: END IF;

Line 533: IF v_attr_value = FND_API.G_MISS_NUM THEN

529: v_attr_value := NULL;
530: END;
531:
532: BEGIN
533: IF v_attr_value = FND_API.G_MISS_NUM THEN
534: v_attr_value := NULL;
535: END IF;
536: EXCEPTION
537: WHEN VALUE_ERROR THEN

Line 538: IF v_attr_value = FND_API.G_MISS_CHAR THEN

534: v_attr_value := NULL;
535: END IF;
536: EXCEPTION
537: WHEN VALUE_ERROR THEN
538: IF v_attr_value = FND_API.G_MISS_CHAR THEN
539: v_attr_value := NULL;
540: END IF;
541: WHEN OTHERS THEN
542: v_attr_value := NULL;

Line 551: IF l_debug = FND_API.G_TRUE THEN

547: x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
548: x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
549: x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
550: q_count := q_count + 1;
551: IF l_debug = FND_API.G_TRUE THEN
552: oe_debug_pub.add('After product assigned');
553: END IF;
554: END IF;--v_attr_(m)value
555: END IF;

Line 625: IF v_attr_value = FND_API.G_MISS_NUM THEN

621: v_attr_value := NULL;
622: END;
623:
624: BEGIN
625: IF v_attr_value = FND_API.G_MISS_NUM THEN
626: v_attr_value := NULL;
627: END IF;
628: EXCEPTION
629: WHEN VALUE_ERROR THEN

Line 630: IF v_attr_value = FND_API.G_MISS_CHAR THEN

626: v_attr_value := NULL;
627: END IF;
628: EXCEPTION
629: WHEN VALUE_ERROR THEN
630: IF v_attr_value = FND_API.G_MISS_CHAR THEN
631: v_attr_value := NULL;
632: END IF;
633: WHEN OTHERS THEN
634: v_attr_value := NULL;

Line 643: IF l_debug = FND_API.G_TRUE THEN

639: x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
640: x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
641: x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
642: q_count := q_count + 1;
643: IF l_debug = FND_API.G_TRUE THEN
644: oe_debug_pub.add('After product assigned');
645: END IF;
646: END IF;--v_attr_(m)value
647: END IF;

Line 831: IF l_debug = FND_API.G_TRUE THEN

827:
828: If QP_Util_PUB.HVOP_Pricing_On = 'N' Then
829: if p_pricing_type_code = 'L' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
830: qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;
831: IF l_debug = FND_API.G_TRUE THEN
832: oe_debug_pub.add('hw/src/L: change to g_no');
833: END IF;
834: end if;
835: End If;