APPS.QP_BUILD_SOURCING_PVT_TMP dependencies on FND_API

Line 39: prev_header_id NUMBER := FND_API.G_MISS_NUM;

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

Line 48: IF l_debug = FND_API.G_TRUE THEN

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

Line 225: IF v_attr_value = FND_API.G_MISS_NUM THEN

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

Line 230: IF v_attr_value = FND_API.G_MISS_CHAR THEN

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

Line 243: IF l_debug = FND_API.G_TRUE THEN

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

Line 310: IF v_attr_value = FND_API.G_MISS_NUM THEN

306: v_attr_value := NULL;
307: END;
308:
309: BEGIN
310: IF v_attr_value = FND_API.G_MISS_NUM THEN
311: v_attr_value := NULL;
312: END IF;
313: EXCEPTION
314: WHEN VALUE_ERROR THEN

Line 315: IF v_attr_value = FND_API.G_MISS_CHAR THEN

311: v_attr_value := NULL;
312: END IF;
313: EXCEPTION
314: WHEN VALUE_ERROR THEN
315: IF v_attr_value = FND_API.G_MISS_CHAR THEN
316: v_attr_value := NULL;
317: END IF;
318: WHEN OTHERS THEN
319: v_attr_value := NULL;

Line 328: IF l_debug = FND_API.G_TRUE THEN

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

Line 529: IF v_attr_value = FND_API.G_MISS_NUM THEN

525: v_attr_value := NULL;
526: END;
527:
528: BEGIN
529: IF v_attr_value = FND_API.G_MISS_NUM THEN
530: v_attr_value := NULL;
531: END IF;
532: EXCEPTION
533: WHEN VALUE_ERROR THEN

Line 534: IF v_attr_value = FND_API.G_MISS_CHAR THEN

530: v_attr_value := NULL;
531: END IF;
532: EXCEPTION
533: WHEN VALUE_ERROR THEN
534: IF v_attr_value = FND_API.G_MISS_CHAR THEN
535: v_attr_value := NULL;
536: END IF;
537: WHEN OTHERS THEN
538: v_attr_value := NULL;

Line 547: IF l_debug = FND_API.G_TRUE THEN

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

Line 620: IF v_attr_value = FND_API.G_MISS_NUM THEN

616: v_attr_value := NULL;
617: END;
618:
619: BEGIN
620: IF v_attr_value = FND_API.G_MISS_NUM THEN
621: v_attr_value := NULL;
622: END IF;
623: EXCEPTION
624: WHEN VALUE_ERROR THEN

Line 625: IF v_attr_value = FND_API.G_MISS_CHAR THEN

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

Line 638: IF l_debug = FND_API.G_TRUE THEN

634: x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
635: x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
636: x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
637: q_count := q_count + 1;
638: IF l_debug = FND_API.G_TRUE THEN
639: oe_debug_pub.add('After product assigned');
640: END IF;
641: END IF;--v_attr_(m)value
642: END IF;

Line 826: IF l_debug = FND_API.G_TRUE THEN

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