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_ATTR_MAPPING_PUB dependencies on FND_API

Line 305: IF l_debug = Fnd_Api.G_TRUE THEN

301: END IF;
302:
303: PUT_LINE(
304: 'Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
305: IF l_debug = Fnd_Api.G_TRUE THEN
306: Oe_Debug_Pub.ADD('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
307:
308:
309: END IF;

Line 324: IF l_debug = Fnd_Api.G_TRUE THEN

320: FOR error IN errors LOOP
321: IF n= 0 THEN
322: PUT_LINE('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);
323: --dbms_output.put_line('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);
324: IF l_debug = Fnd_Api.G_TRUE THEN
325: Oe_Debug_Pub.ADD('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);
326: END IF;
327: END IF;
328: PUT_LINE( 'LINE :'||error.line||' '||SUBSTR(error.text,1,200));

Line 330: IF l_debug = Fnd_Api.G_TRUE THEN

326: END IF;
327: END IF;
328: PUT_LINE( 'LINE :'||error.line||' '||SUBSTR(error.text,1,200));
329: --dbms_output.put_line( 'LINE :'||error.line||' '||substr(error.text,1,200));
330: IF l_debug = Fnd_Api.G_TRUE THEN
331: Oe_Debug_Pub.ADD('LINE :'||error.line||' '||SUBSTR(error.text,1,200));
332: END IF;
333: n := 1;
334: END LOOP;

Line 340: RAISE Fnd_Api.G_EXC_ERROR;

336: -- if there was an error in compiling the package, raise
337: -- an error
338: IF n > 0 THEN
339: --dbms_output.put_line('Raising Error now.....');
340: RAISE Fnd_Api.G_EXC_ERROR;
341: END IF;
342:
343:
344: --changes by spgopal 15-JUN-2001 for BUILD_SOURCE_TMP

Line 354: IF l_debug = Fnd_Api.G_TRUE THEN

350:
351: PUT_LINE('PACKAGE '||p_pkg_type||' Name to :'
352: ||l_pkg_name||' compiled successfully ');
353:
354: IF l_debug = Fnd_Api.G_TRUE THEN
355: Oe_Debug_Pub.ADD('PACKAGE '||p_pkg_type||' Name to :'
356: || l_pkg_name||' compiled successfully ');
357:
358: END IF;

Line 362: IF l_debug = Fnd_Api.G_TRUE THEN

358: END IF;
359: PUT_LINE('Now create PACKAGE '||p_pkg_type||' : '
360: ||l_new_pkg_name);
361:
362: IF l_debug = Fnd_Api.G_TRUE THEN
363: Oe_Debug_Pub.ADD('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
364:
365: END IF;
366: IF INSTR(ad_ddl.glprogtext(1),p_pkg_name) > 0

Line 375: IF l_debug = Fnd_Api.G_TRUE THEN

371: ,l_new_pkg_name);
372: PUT_LINE('First change : '
373: ||ad_ddl.glprogtext(1));
374:
375: IF l_debug = Fnd_Api.G_TRUE THEN
376: Oe_Debug_Pub.ADD('First change : ' ||ad_ddl.glprogtext(1));
377:
378: END IF;
379: ad_ddl.glprogtext(line_number) :=

Line 386: IF l_debug = Fnd_Api.G_TRUE THEN

382: ,l_new_pkg_name);
383: PUT_LINE('Second change : '
384: ||' '||ad_ddl.glprogtext(line_number));
385:
386: IF l_debug = Fnd_Api.G_TRUE THEN
387: Oe_Debug_Pub.ADD('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
388:
389: END IF;
390: PUT_LINE('Trying to create PACKAGE '||p_pkg_type

Line 393: IF l_debug = Fnd_Api.G_TRUE THEN

389: END IF;
390: PUT_LINE('Trying to create PACKAGE '||p_pkg_type
391: ||' :'||l_new_pkg_name);
392:
393: IF l_debug = Fnd_Api.G_TRUE THEN
394: Oe_Debug_Pub.ADD('Trying to create PACKAGE '||p_pkg_type
395: ||' :'||l_new_pkg_name);
396:
397: END IF;

Line 415: IF l_debug = Fnd_Api.G_TRUE THEN

411: IF n = 0 THEN
412: PUT_LINE('ERROR in creating PACKAGE '
413: ||p_pkg_type||' :'||l_pkg_name);
414:
415: IF l_debug = Fnd_Api.G_TRUE THEN
416: Oe_Debug_Pub.ADD('ERROR in creating PACKAGE '
417: ||p_pkg_type||' :'||l_pkg_name);
418:
419: END IF;

Line 424: IF l_debug = Fnd_Api.G_TRUE THEN

420: END IF;
421: PUT_LINE('LINE :'||error.line||' '
422: ||SUBSTR(error.text,1,200));
423:
424: IF l_debug = Fnd_Api.G_TRUE THEN
425: Oe_Debug_Pub.ADD('LINE :'||error.line||' '
426: ||SUBSTR(error.text,1,200));
427: END IF;
428: n := 1;

Line 434: RAISE Fnd_Api.G_EXC_ERROR;

430:
431: -- if there was an error in compiling the package, raise
432: -- an error
433: IF n > 0 THEN
434: RAISE Fnd_Api.G_EXC_ERROR;
435: END IF;
436: PUT_LINE('Generated PACKAGE '||p_pkg_type
437: ||' :'||l_new_pkg_name
438: ||' Successfully');

Line 440: IF l_debug = Fnd_Api.G_TRUE THEN

436: PUT_LINE('Generated PACKAGE '||p_pkg_type
437: ||' :'||l_new_pkg_name
438: ||' Successfully');
439:
440: IF l_debug = Fnd_Api.G_TRUE THEN
441: Oe_Debug_Pub.ADD('Generated PACKAGE '||p_pkg_type
442: ||' :'||l_new_pkg_name ||' Successfully');
443: END IF;
444:

Line 472: WHEN Fnd_Api.G_EXC_ERROR THEN

468: END IF;--instr
469: END IF;--n=0
470:
471: EXCEPTION
472: WHEN Fnd_Api.G_EXC_ERROR THEN
473: RAISE Fnd_Api.G_EXC_ERROR;
474: WHEN OTHERS THEN
475: RAISE_APPLICATION_ERROR(-20000,SQLERRM||' '||ad_ddl.error_buf);
476: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);

Line 473: RAISE Fnd_Api.G_EXC_ERROR;

469: END IF;--n=0
470:
471: EXCEPTION
472: WHEN Fnd_Api.G_EXC_ERROR THEN
473: RAISE Fnd_Api.G_EXC_ERROR;
474: WHEN OTHERS THEN
475: RAISE_APPLICATION_ERROR(-20000,SQLERRM||' '||ad_ddl.error_buf);
476: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
477: -- RAISE FND_API.G_EXC_ERROR;

Line 477: -- RAISE FND_API.G_EXC_ERROR;

473: RAISE Fnd_Api.G_EXC_ERROR;
474: WHEN OTHERS THEN
475: RAISE_APPLICATION_ERROR(-20000,SQLERRM||' '||ad_ddl.error_buf);
476: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
477: -- RAISE FND_API.G_EXC_ERROR;
478:
479: END Pkg_End;
480:
481: -- Generates the Package Header for the package SPEC and BODY

Line 1052: Text('IF v_attr_value = FND_API.G_MISS_NUM THEN',2);

1048: Text('v_attr_value := NULL;',4);
1049: Text('END;',2);
1050: New_Line;
1051: Text('BEGIN',2);
1052: Text('IF v_attr_value = FND_API.G_MISS_NUM THEN',2);
1053: Text('v_attr_value := NULL;',3);
1054: Text('END IF;',2);
1055: Text('EXCEPTION',2);
1056: Text('WHEN VALUE_ERROR THEN',3);

Line 1057: Text('IF v_attr_value = FND_API.G_MISS_CHAR THEN',4);

1053: Text('v_attr_value := NULL;',3);
1054: Text('END IF;',2);
1055: Text('EXCEPTION',2);
1056: Text('WHEN VALUE_ERROR THEN',3);
1057: Text('IF v_attr_value = FND_API.G_MISS_CHAR THEN',4);
1058: Text('v_attr_value := NULL;',5);
1059: Text('END IF;',4);
1060: Text('WHEN OTHERS THEN',3);
1061: Text('v_attr_value := NULL;',4);

Line 1133: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);

1129: IF v_context_name = 'MODLIST'
1130: AND
1131: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
1132: THEN
1133: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);
1134: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
1135: Text ('End If;', 4);
1136: END IF;
1137:

Line 1202: Text('IF l_debug = FND_API.G_TRUE THEN',4);

1198: Break_Text(v_src_type,v_attr_src_string);
1199: END IF;
1200: Text('EXCEPTION',2);
1201: Text('WHEN OTHERS THEN',3);
1202: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1203: Text('oe_debug_pub.add(''Multirec API error'');',5);
1204: Text('END IF;',4);
1205: Text('END;',2);
1206: New_Line;

Line 1231: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);

1227: IF v_context_name = 'MODLIST'
1228: AND
1229: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
1230: THEN
1231: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);
1232: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
1233: Text ('End If;', 4);
1234: END IF;
1235:

Line 1675: Text('IF l_debug = FND_API.G_TRUE THEN',2);

1671: IF v_context_type <> 'PRODUCT'
1672: AND l_context_type_processed = 'PRODUCT'
1673: AND l_code_release_level > '110508'
1674: THEN
1675: Text('IF l_debug = FND_API.G_TRUE THEN',2);
1676: text('oe_debug_pub.add(''In check to call line_group'');',3);
1677: Text('END IF;',2);
1678: Text('IF QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG = ''Y'' THEN',2);
1679: Text('BEGIN',3);

Line 1680: Text('IF l_debug = FND_API.G_TRUE THEN',3);

1676: text('oe_debug_pub.add(''In check to call line_group'');',3);
1677: Text('END IF;',2);
1678: Text('IF QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG = ''Y'' THEN',2);
1679: Text('BEGIN',3);
1680: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1681: text('oe_debug_pub.add(''Before call line_group'');',4);
1682: Text('END IF;',3);
1683: Text('QP_ATTR_MAPPING_PUB.Check_line_group_items(p_pricing_type_code);',3);
1684: Text('IF l_debug = FND_API.G_TRUE THEN',3);

Line 1684: Text('IF l_debug = FND_API.G_TRUE THEN',3);

1680: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1681: text('oe_debug_pub.add(''Before call line_group'');',4);
1682: Text('END IF;',3);
1683: Text('QP_ATTR_MAPPING_PUB.Check_line_group_items(p_pricing_type_code);',3);
1684: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1685: text('oe_debug_pub.add(''After call line_group'');',4);
1686: Text('END IF;',3);
1687: Text('EXCEPTION',3);
1688: Text('WHEN OTHERS THEN',3);

Line 1689: Text('IF l_debug = FND_API.G_TRUE THEN',4);

1685: text('oe_debug_pub.add(''After call line_group'');',4);
1686: Text('END IF;',3);
1687: Text('EXCEPTION',3);
1688: Text('WHEN OTHERS THEN',3);
1689: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1690: Text('oe_debug_pub.add(''Error in Check_line_group_items'');',5);
1691: Text('END IF;',4);
1692: Text('END;',3);
1693: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);

Line 1697: Text('IF l_debug = FND_API.G_TRUE THEN',3);

1693: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1694: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1695: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1696: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N'''||' THEN',2);
1697: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1698: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1699: Text('END IF;',3);
1700: Text('x_price_ctxts_result_tbl.delete;',3);
1701: Text('RETURN;',3);

Line 1739: Text('IF v_attr_value = FND_API.G_MISS_NUM THEN',2);

1735: Text('v_attr_value := NULL;',4);
1736: Text('END;',2);
1737: New_Line;
1738: Text('BEGIN',2);
1739: Text('IF v_attr_value = FND_API.G_MISS_NUM THEN',2);
1740: Text('v_attr_value := NULL;',3);
1741: Text('END IF;',2);
1742: Text('EXCEPTION',2);
1743: Text('WHEN VALUE_ERROR THEN',3);

Line 1744: Text('IF v_attr_value = FND_API.G_MISS_CHAR THEN',4);

1740: Text('v_attr_value := NULL;',3);
1741: Text('END IF;',2);
1742: Text('EXCEPTION',2);
1743: Text('WHEN VALUE_ERROR THEN',3);
1744: Text('IF v_attr_value = FND_API.G_MISS_CHAR THEN',4);
1745: Text('v_attr_value := NULL;',5);
1746: Text('END IF;',4);
1747: Text('WHEN OTHERS THEN',3);
1748: Text('v_attr_value := NULL;',4);

Line 1817: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);

1813: IF v_context_name = 'MODLIST'
1814: AND
1815: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
1816: THEN
1817: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);
1818: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
1819: Text ('End If;', 4);
1820: END IF;
1821:

Line 1859: Text('IF l_debug = FND_API.G_TRUE THEN',4);

1855: --added for changed lines performance improvement bug 2491269
1856: IF v_context_type = 'PRODUCT'
1857: AND l_code_release_level > '110508'
1858: THEN
1859: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1860: text('oe_debug_pub.add(''Gathering product details'');',5);
1861: Text('END IF;',4);
1862: l_context_type_processed := v_context_type;
1863: Text('BEGIN',4);

Line 1868: Text('IF l_debug = FND_API.G_TRUE THEN',5);

1864: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
1865: ||'x_price_ctxts_result_tbl(p_count-1);',5);
1866: Text('Exception',4);
1867: Text('When Others Then',4);
1868: Text('IF l_debug = FND_API.G_TRUE THEN',5);
1869: Text('oe_debug_pub.add(''No product sourced '');',6);
1870: Text('END IF;',5);
1871: Text('END;',4);
1872: END IF;--v_context_type = 'PRODUCT'

Line 1873: Text('IF l_debug = FND_API.G_TRUE THEN',4);

1869: Text('oe_debug_pub.add(''No product sourced '');',6);
1870: Text('END IF;',5);
1871: Text('END;',4);
1872: END IF;--v_context_type = 'PRODUCT'
1873: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1874: text('oe_debug_pub.add(''After product assigned'');',5);
1875: Text('END IF;',4);
1876:
1877: Text('END IF;--v_attr_(m)value',2);

Line 1904: Text('IF l_debug = FND_API.G_TRUE THEN',4);

1900: Break_Text(v_src_type,v_attr_src_string);
1901: END IF;
1902: Text('EXCEPTION',2);
1903: Text('WHEN OTHERS THEN',3);
1904: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1905: Text('oe_debug_pub.add(''Multirec API error'');',5);
1906: Text('END IF;',4);
1907: Text('END;',2);
1908: New_Line;

Line 1933: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);

1929: IF v_context_name = 'MODLIST'
1930: AND
1931: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
1932: THEN
1933: Text ('If NVL(QP_BULK_PREQ_GRP.G_line_rec.agreement_id(i), FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM Then ', 3);
1934: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
1935: Text ('End If;', 4);
1936: END IF;
1937:

Line 1977: Text('IF l_debug = FND_API.G_TRUE THEN',4);

1973: --added for changed lines performance improvement bug 2491269
1974: IF v_context_type = 'PRODUCT'
1975: AND l_code_release_level > '110508'
1976: THEN
1977: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1978: text('oe_debug_pub.add(''Gathering product details'');',5);
1979: Text('END IF;',4);
1980: l_context_type_processed := v_context_type;
1981: Text('BEGIN',4);

Line 1986: Text('IF l_debug = FND_API.G_TRUE THEN',5);

1982: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
1983: ||'x_price_ctxts_result_tbl(p_count-1);',5);
1984: Text('Exception',4);
1985: Text('When Others Then',4);
1986: Text('IF l_debug = FND_API.G_TRUE THEN',5);
1987: Text('oe_debug_pub.add(''No product sourced '');',6);
1988: Text('END IF;',5);
1989: Text('END;',4);
1990: END IF;--v_context_type = 'PRODUCT'

Line 1991: Text('IF l_debug = FND_API.G_TRUE THEN',4);

1987: Text('oe_debug_pub.add(''No product sourced '');',6);
1988: Text('END IF;',5);
1989: Text('END;',4);
1990: END IF;--v_context_type = 'PRODUCT'
1991: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1992: text('oe_debug_pub.add(''After product assigned'');',5);
1993: Text('END IF;',4);
1994:
1995:

Line 2043: IF l_debug = Fnd_Api.G_TRUE THEN

2039: BEGIN
2040:
2041: --dbms_output.put_line('............1............');
2042: --l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2043: IF l_debug = Fnd_Api.G_TRUE THEN
2044: Oe_Debug_Pub.ADD('##### Begin Build Sourcing #####');
2045:
2046: END IF;
2047: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);

Line 2073: Text('prev_header_id NUMBER := FND_API.G_MISS_NUM;',0);

2069: Text('v_attr_mvalue QP_Attr_Mapping_PUB.t_MultiRecord;',0);
2070: Text('q_count NUMBER := 1;',0);
2071: Text('p_count NUMBER := 1;',0);
2072: Text('v_index NUMBER := 1;',0);
2073: Text('prev_header_id NUMBER := FND_API.G_MISS_NUM;',0);
2074: New_Line;
2075: Text('l_debug VARCHAR2(3);',0);
2076: Text('BEGIN',0);
2077: Text('qp_debug_util.tstart(''FETCH_ATTRIBUTES'',''Fetching the Attribute Values'');',0);

Line 2085: Text('IF l_debug = FND_API.G_TRUE THEN',1);

2081:
2082: -- added for g_new_pricing_call for caching - hwong
2083: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2084: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);
2085: Text('IF l_debug = FND_API.G_TRUE THEN',1);
2086: text('oe_debug_pub.add(''hw/src/H: change to g_yes'');',2);
2087: Text('END IF;',1);
2088: text('end if;', 0);
2089: new_line;

Line 2130: Text('IF l_debug = FND_API.G_TRUE THEN',2);

2126: new_line;
2127: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then');
2128: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 1);
2129: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 2);
2130: Text('IF l_debug = FND_API.G_TRUE THEN',2);
2131: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',3);
2132: Text('END IF;',2);
2133: text('end if;', 1);
2134: Text('End If;');

Line 2181: Text('IF l_debug = FND_API.G_TRUE THEN',3);

2177: new_line;
2178: Text ('If QP_Util_PUB.HVOP_Pricing_On = ''N'' Then',1);
2179: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 2);
2180: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 3);
2181: Text('IF l_debug = FND_API.G_TRUE THEN',3);
2182: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',4);
2183: Text('END IF;',3);
2184: text('end if;', 2);
2185: Text ('End If;', 1);

Line 2232: IF l_debug = Fnd_Api.G_TRUE THEN

2228: retcode := 0;
2229: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');
2230: err_buff := Fnd_Message.GET;
2231:
2232: IF l_debug = Fnd_Api.G_TRUE THEN
2233: Oe_Debug_Pub.ADD('##### End Build Sourcing #####');
2234:
2235: END IF;
2236: EXCEPTION

Line 2238: WHEN Fnd_Api.G_EXC_ERROR THEN

2234:
2235: END IF;
2236: EXCEPTION
2237:
2238: WHEN Fnd_Api.G_EXC_ERROR THEN
2239: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2240: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2241: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2242: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));

Line 2308: IF l_debug = Fnd_Api.G_TRUE THEN

2304:
2305:
2306: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2307:
2308: IF l_debug = Fnd_Api.G_TRUE THEN
2309: Oe_Debug_Pub.ADD('##### Begin Build Contexts #####');
2310: END IF;
2311: --setting time
2312: l_sourcing_start_time := dbms_utility.get_time;

Line 2431: IF l_debug = Fnd_Api.G_TRUE THEN

2427:
2428: v_count := v_count + 1;
2429: EXIT WHEN v_count > x_qual_contexts_result_tbl.COUNT;
2430:
2431: IF l_debug = Fnd_Api.G_TRUE THEN
2432: Oe_Debug_Pub.ADD('Context Name: ' || x_qual_contexts_result_tbl(v_count).context_name);
2433: Oe_Debug_Pub.ADD('Attribute Name: ' || x_qual_contexts_result_tbl(v_count).attribute_name);
2434: Oe_Debug_Pub.ADD('Attribute Value: ' || x_qual_contexts_result_tbl(v_count).attribute_value);
2435:

Line 2446: IF l_debug = Fnd_Api.G_TRUE THEN

2442:
2443: v_count := v_count + 1;
2444: EXIT WHEN v_count > x_price_contexts_result_tbl.COUNT;
2445:
2446: IF l_debug = Fnd_Api.G_TRUE THEN
2447: Oe_Debug_Pub.ADD('Context Name: ' || x_price_contexts_result_tbl(v_count).context_name);
2448: Oe_Debug_Pub.ADD('Attribute Name: ' || x_price_contexts_result_tbl(v_count).attribute_name);
2449: Oe_Debug_Pub.ADD('Attribute Value: ' || x_price_contexts_result_tbl(v_count).attribute_value);
2450:

Line 2454: IF l_debug = Fnd_Api.G_TRUE THEN

2450:
2451: END IF;
2452: END LOOP;
2453:
2454: IF l_debug = Fnd_Api.G_TRUE THEN
2455: Oe_Debug_Pub.ADD('##### End Build Contexts #####');
2456:
2457: END IF;
2458: --setting time

Line 2462: IF l_debug = Fnd_Api.G_TRUE THEN

2458: --setting time
2459: l_sourcing_end_time := dbms_utility.get_time;
2460: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
2461:
2462: IF l_debug = Fnd_Api.G_TRUE THEN
2463: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');
2464:
2465:
2466: END IF;

Line 2538: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;

2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2536: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2537:
2538: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2539: K PLS_INTEGER;
2540:
2541: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');
2542:

Line 2612: IF l_debug = Fnd_Api.G_TRUE THEN

2608: l_LINE_DETAIL_type_CODE_tbl.DELETE;
2609: l_MODIFIER_LEVEL_CODE_tbl.DELETE;
2610: l_PRIMARY_UOM_FLAG_tbl.DELETE;
2611:
2612: IF l_debug = Fnd_Api.G_TRUE THEN
2613: Qp_Preq_Grp.ENGINE_DEBUG('Begin Build contexts');
2614:
2615: END IF;
2616: K := 0;

Line 2620: IF l_debug = Fnd_Api.G_TRUE THEN

2616: K := 0;
2617: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2618:
2619: --Called Build Sourcing at line level
2620: IF l_debug = Fnd_Api.G_TRUE THEN
2621: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at line level----------');
2622:
2623: END IF;
2624: l_pricing_type_code := 'L';

Line 2641: IF l_debug = Fnd_Api.G_TRUE THEN

2637: Build_Contexts program calls this procedure to pickup custom sourced attributes if the
2638: profile option ' QP_CUSTOM_SOURCED' is set to 'Y' -- GTIPPIRE
2639: */
2640:
2641: IF l_debug = Fnd_Api.G_TRUE THEN
2642: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2643: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2644:
2645: END IF;

Line 2647: IF l_debug = Fnd_Api.G_TRUE THEN

2643: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2644:
2645: END IF;
2646: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2647: IF l_debug = Fnd_Api.G_TRUE THEN
2648: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
2649: END IF;
2650: Begin
2651: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');

Line 2661: IF l_debug = Fnd_Api.G_TRUE THEN

2657: exception
2658: when others then
2659: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
2660: end;
2661: IF l_debug = Fnd_Api.G_TRUE THEN
2662: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2663:
2664: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2665: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );

Line 2838: AND Oe_Order_Pub.G_Line.agreement_id <> Fnd_Api.g_miss_num

2834: 'QUALIFIER_ATTRIBUTE4'
2835: THEN
2836:
2837: IF Oe_Order_Pub.G_Line.agreement_id IS NOT NULL
2838: AND Oe_Order_Pub.G_Line.agreement_id <> Fnd_Api.g_miss_num
2839: AND NVL(p_price_list_validated_flag,'Y') = 'Y'
2840: THEN
2841: l_validated_flag_tbl(K) := 'Y';
2842: ELSIF NVL(p_price_list_validated_flag,'N') = 'N' THEN

Line 2858: IF l_debug = Fnd_Api.G_TRUE THEN

2854:
2855: END IF;
2856:
2857: --Called Build Sourcing at header level
2858: IF l_debug = Fnd_Api.G_TRUE THEN
2859: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at header level----------');
2860:
2861: END IF;
2862: v_count := 0;

Line 2880: IF l_debug = Fnd_Api.G_TRUE THEN

2876: p_pricing_type_code => p_pricing_type_code,
2877: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2878: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2879:
2880: IF l_debug = Fnd_Api.G_TRUE THEN
2881: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2882: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2883:
2884: END IF;

Line 2894: IF l_debug = Fnd_Api.G_TRUE THEN

2890: profile option ' QP_CUSTOM_SOURCED' is set to 'Y' -- GTIPPIRE
2891: */
2892:
2893: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2894: IF l_debug = Fnd_Api.G_TRUE THEN
2895: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
2896: END IF;
2897: Begin
2898: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');

Line 2909: IF l_debug = Fnd_Api.G_TRUE THEN

2905: when others then
2906: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
2907: end;
2908:
2909: IF l_debug = Fnd_Api.G_TRUE THEN
2910: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2911:
2912: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2913: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );

Line 3085: AND Oe_Order_Pub.G_Line.agreement_id <> Fnd_Api.g_miss_num

3081: 'QUALIFIER_ATTRIBUTE4'
3082: THEN
3083:
3084: IF Oe_Order_Pub.G_Line.agreement_id IS NOT NULL
3085: AND Oe_Order_Pub.G_Line.agreement_id <> Fnd_Api.g_miss_num
3086: THEN
3087: l_validated_flag_tbl(K) := 'Y';
3088: ELSE
3089: l_validated_flag_tbl(K) := 'N';

Line 3100: IF l_debug = Fnd_Api.G_TRUE THEN

3096: --END LOOP;
3097:
3098: END IF;
3099:
3100: IF l_debug = Fnd_Api.G_TRUE THEN
3101:
3102: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3103: FOR i IN 1..l_line_index_tbl.COUNT
3104: LOOP

Line 3105: IF l_debug = Fnd_Api.G_TRUE THEN

3101:
3102: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3103: FOR i IN 1..l_line_index_tbl.COUNT
3104: LOOP
3105: IF l_debug = Fnd_Api.G_TRUE THEN
3106: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3107: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));

Line 3121: IF l_debug = Fnd_Api.G_TRUE THEN

3117:
3118: IF l_line_index_tbl.COUNT > 0
3119: THEN
3120: BEGIN
3121: IF l_debug = Fnd_Api.G_TRUE THEN
3122: Qp_Preq_Grp.ENGINE_DEBUG('Tata Inserting line attributes ----------');
3123: END IF;
3124:
3125: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN

Line 3126: IF l_debug = Fnd_Api.G_TRUE THEN

3122: Qp_Preq_Grp.ENGINE_DEBUG('Tata Inserting line attributes ----------');
3123: END IF;
3124:
3125: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3126: IF l_debug = Fnd_Api.G_TRUE THEN
3127: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine not Installed ----------');
3128: END IF;
3129:
3130: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST

Line 3155: IF l_debug = Fnd_Api.G_TRUE THEN

3151: Qp_Preq_Pub.G_STATUS_UNCHANGED,
3152: Qp_Preq_Pub.G_YES
3153: );
3154: ELSE -- Java Engine path added by yangli
3155: IF l_debug = Fnd_Api.G_TRUE THEN
3156: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3157: END IF;
3158: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,
3159: QP_PREQ_PUB.G_LINE_LEVEL,

Line 3211: IF l_status_code = Fnd_Api.G_RET_STS_ERROR THEN

3207: p_MODIFIER_LEVEL_CODE_tbl=> l_MODIFIER_LEVEL_CODE_tbl,
3208: p_PRIMARY_UOM_FLAG_tbl=> l_PRIMARY_UOM_FLAG_tbl,
3209: x_status_code => l_status_code,
3210: x_status_text => l_status_text);
3211: IF l_status_code = Fnd_Api.G_RET_STS_ERROR THEN
3212: RAISE E_ROUTINE_ERRORS;
3213: END IF;
3214: END IF;
3215:

Line 3216: IF l_debug = Fnd_Api.G_TRUE THEN

3212: RAISE E_ROUTINE_ERRORS;
3213: END IF;
3214: END IF;
3215:
3216: IF l_debug = Fnd_Api.G_TRUE THEN
3217: Qp_Preq_Grp.ENGINE_DEBUG('End Inserting line attributes ----------');
3218: END IF;
3219: EXCEPTION
3220: WHEN E_ROUTINE_ERRORS THEN

Line 3221: IF l_debug = Fnd_Api.G_TRUE THEN

3217: Qp_Preq_Grp.ENGINE_DEBUG('End Inserting line attributes ----------');
3218: END IF;
3219: EXCEPTION
3220: WHEN E_ROUTINE_ERRORS THEN
3221: IF l_debug = Fnd_Api.G_TRUE THEN
3222: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3223: END IF;
3224: WHEN OTHERS THEN
3225: IF l_debug = Fnd_Api.G_TRUE THEN

Line 3225: IF l_debug = Fnd_Api.G_TRUE THEN

3221: IF l_debug = Fnd_Api.G_TRUE THEN
3222: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3223: END IF;
3224: WHEN OTHERS THEN
3225: IF l_debug = Fnd_Api.G_TRUE THEN
3226: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||' '||SQLERRM);
3227: END IF;
3228: END;
3229:

Line 3232: IF l_debug = Fnd_Api.G_TRUE THEN

3228: END;
3229:
3230: END IF;
3231:
3232: IF l_debug = Fnd_Api.G_TRUE THEN
3233: Qp_Preq_Grp.ENGINE_DEBUG('End Build contexts');
3234:
3235: END IF;
3236: --setting time

Line 3240: IF l_debug = Fnd_Api.G_TRUE THEN

3236: --setting time
3237: l_sourcing_end_time := dbms_utility.get_time;
3238: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
3239:
3240: IF l_debug = Fnd_Api.G_TRUE THEN
3241: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');
3242:
3243: END IF;
3244: EXCEPTION

Line 3246: IF l_debug = Fnd_Api.G_TRUE THEN

3242:
3243: END IF;
3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: IF l_debug = Fnd_Api.G_TRUE THEN
3247: Qp_Preq_Grp.ENGINE_DEBUG('Exception in QP_ATTR_MAPPING_PUB.Build_context '||SQLERRM);
3248:
3249: END IF;
3250: END Build_Contexts;

Line 3323: IF l_debug = Fnd_Api.G_TRUE THEN

3319:
3320: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3321: EXIT WHEN l_pricing_attribs%NOTFOUND;
3322:
3323: IF l_debug = Fnd_Api.G_TRUE THEN
3324: Oe_Debug_Pub.ADD('Item Context: ' || v_pricing_attr_ctxt);
3325: Oe_Debug_Pub.ADD('Item Attribute: ' || v_pricing_attr);
3326:
3327: END IF;

Line 3343: IF l_debug = Fnd_Api.G_TRUE THEN

3339: FROM oe_def_condn_elems
3340: WHERE condition_id = l_condition_id
3341: AND attribute_code = 'PRICING_CONTEXT';
3342:
3343: IF l_debug = Fnd_Api.G_TRUE THEN
3344: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);
3345: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3346: END IF;
3347:

Line 3351: IF l_debug = Fnd_Api.G_TRUE THEN

3347:
3348: IF l_context_name = v_pricing_attr_ctxt THEN
3349:
3350: l_found := 1;
3351: IF l_debug = Fnd_Api.G_TRUE THEN
3352: Oe_Debug_Pub.ADD('Found : ' || l_found);
3353:
3354: END IF;
3355: END IF;

Line 3363: IF l_debug = Fnd_Api.G_TRUE THEN

3359: CLOSE l_cond_cursor;
3360:
3361: IF l_found = 0 THEN
3362:
3363: IF l_debug = Fnd_Api.G_TRUE THEN
3364: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);
3365: Oe_Debug_Pub.ADD('Not Found attribute: ' || v_pricing_attr);
3366: END IF;
3367: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3384: IF l_debug = Fnd_Api.G_TRUE THEN

3380:
3381: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3382: EXIT WHEN l_pricing_attribs%NOTFOUND;
3383:
3384: IF l_debug = Fnd_Api.G_TRUE THEN
3385: Oe_Debug_Pub.ADD('Item Context: ' || v_pricing_attr_ctxt);
3386: Oe_Debug_Pub.ADD('Item Attribute: ' || v_pricing_attr);
3387:
3388: END IF;

Line 3399: IF l_debug = Fnd_Api.G_TRUE THEN

3395: FETCH l_cond_cursor_new INTO l_segment_code, l_segment_mapping_column,
3396: l_context_code,l_context_type;
3397: EXIT WHEN l_cond_cursor_new%NOTFOUND;
3398:
3399: IF l_debug = Fnd_Api.G_TRUE THEN
3400: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_code);
3401: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3402: END IF;
3403:

Line 3407: IF l_debug = Fnd_Api.G_TRUE THEN

3403:
3404: IF l_context_code = v_pricing_attr_ctxt THEN
3405:
3406: l_found := 1;
3407: IF l_debug = Fnd_Api.G_TRUE THEN
3408: Oe_Debug_Pub.ADD('Found : ' || l_found);
3409:
3410: END IF;
3411: END IF;

Line 3418: IF l_debug = Fnd_Api.G_TRUE THEN

3414: CLOSE l_cond_cursor_new;
3415:
3416: IF l_found = 1 THEN
3417:
3418: IF l_debug = Fnd_Api.G_TRUE THEN
3419: Oe_Debug_Pub.ADD('Found User Entered context: ' || v_pricing_attr_ctxt);
3420: Oe_Debug_Pub.ADD('Found User Entered attribute: ' || v_pricing_attr);
3421: END IF;
3422: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3456: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR

3452: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3453: FROM qp_pricing_attributes
3454: WHERE pricing_attribute_context IS NOT NULL
3455: AND pricing_attribute_context NOT IN ('VOLUME','ITEM')
3456: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR
3457: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR
3458: AND pricing_attribute IS NOT NULL;
3459:
3460: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS

Line 3457: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR

3453: FROM qp_pricing_attributes
3454: WHERE pricing_attribute_context IS NOT NULL
3455: AND pricing_attribute_context NOT IN ('VOLUME','ITEM')
3456: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR
3457: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR
3458: AND pricing_attribute IS NOT NULL;
3459:
3460: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS
3461: SELECT c.condition_id, d.attr_def_condition_id

Line 3500: IF l_debug = Fnd_Api.G_TRUE THEN

3496:
3497: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3498: EXIT WHEN l_pricing_attribs%NOTFOUND;
3499:
3500: IF l_debug = Fnd_Api.G_TRUE THEN
3501: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));
3502: Oe_Debug_Pub.ADD('Pricing Attribute: ' || v_pricing_attr);
3503:
3504: END IF;

Line 3520: IF l_debug = Fnd_Api.G_TRUE THEN

3516: FROM oe_def_condn_elems
3517: WHERE condition_id = l_condition_id
3518: AND attribute_code = 'PRICING_CONTEXT';
3519:
3520: IF l_debug = Fnd_Api.G_TRUE THEN
3521: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);
3522: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3523: END IF;
3524:

Line 3528: IF l_debug = Fnd_Api.G_TRUE THEN

3524:
3525: IF l_context_name = v_pricing_attr_ctxt THEN
3526:
3527: l_found := 1;
3528: IF l_debug = Fnd_Api.G_TRUE THEN
3529: Oe_Debug_Pub.ADD('Found : ' || l_found);
3530:
3531: END IF;
3532: END IF;

Line 3540: IF l_debug = Fnd_Api.G_TRUE THEN

3536: CLOSE l_cond_cursor;
3537:
3538: IF l_found = 0 THEN
3539:
3540: IF l_debug = Fnd_Api.G_TRUE THEN
3541: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);
3542: Oe_Debug_Pub.ADD('Not Found attribute: ' || v_pricing_attr);
3543: END IF;
3544: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3553: IF l_debug = Fnd_Api.G_TRUE THEN

3549: END LOOP;
3550: CLOSE l_pricing_attribs;
3551:
3552: v_count := v_count - 1;
3553: IF l_debug = Fnd_Api.G_TRUE THEN
3554: Oe_Debug_Pub.ADD('Number of Non-sourced attributes : ' || v_count);
3555: END IF;
3556: ELSIF NVL(G_ATTRMGR_INSTALLED,'N') = 'Y' THEN
3557: OPEN l_pricing_attribs;

Line 3564: IF l_debug = Fnd_Api.G_TRUE THEN

3560:
3561: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3562: EXIT WHEN l_pricing_attribs%NOTFOUND;
3563:
3564: IF l_debug = Fnd_Api.G_TRUE THEN
3565: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));
3566: Oe_Debug_Pub.ADD('Pricing Attribute: ' || v_pricing_attr);
3567:
3568: END IF;

Line 3579: IF l_debug = Fnd_Api.G_TRUE THEN

3575: FETCH l_cond_cursor_new INTO l_segment_code, l_segment_mapping_column,
3576: l_context_code,l_context_type;
3577: EXIT WHEN l_cond_cursor_new%NOTFOUND;
3578:
3579: IF l_debug = Fnd_Api.G_TRUE THEN
3580: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_code);
3581: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3582: END IF;
3583:

Line 3587: IF l_debug = Fnd_Api.G_TRUE THEN

3583:
3584: IF l_context_code = v_pricing_attr_ctxt THEN
3585:
3586: l_found := 1;
3587: IF l_debug = Fnd_Api.G_TRUE THEN
3588: Oe_Debug_Pub.ADD('Found : ' || l_found);
3589:
3590: END IF;
3591: END IF;

Line 3598: IF l_debug = Fnd_Api.G_TRUE THEN

3594: CLOSE l_cond_cursor_new;
3595:
3596: IF l_found = 1 THEN
3597:
3598: IF l_debug = Fnd_Api.G_TRUE THEN
3599: Oe_Debug_Pub.ADD('Found user entered context: ' || v_pricing_attr_ctxt);
3600: Oe_Debug_Pub.ADD('Found user entered attribute: ' || v_pricing_attr);
3601: END IF;
3602: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3611: IF l_debug = Fnd_Api.G_TRUE THEN

3607: END LOOP;
3608: CLOSE l_pricing_attribs;
3609:
3610: v_count := v_count - 1;
3611: IF l_debug = Fnd_Api.G_TRUE THEN
3612: Oe_Debug_Pub.ADD('Number of Non-sourced attributes : ' || v_count);
3613: END IF;
3614: END IF;
3615:

Line 3678: IF l_debug = Fnd_Api.G_TRUE THEN

3674:
3675: FETCH l_pricing_contexts INTO v_pricing_attr_ctxt;
3676: EXIT WHEN l_pricing_contexts%NOTFOUND;
3677:
3678: IF l_debug = Fnd_Api.G_TRUE THEN
3679: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));
3680:
3681: END IF;
3682: l_found := 0;

Line 3697: IF l_debug = Fnd_Api.G_TRUE THEN

3693: FROM oe_def_condn_elems
3694: WHERE condition_id = l_condition_id
3695: AND attribute_code = 'PRICING_CONTEXT';
3696:
3697: IF l_debug = Fnd_Api.G_TRUE THEN
3698: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);
3699: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3700: END IF;
3701:

Line 3704: IF l_debug = Fnd_Api.G_TRUE THEN

3700: END IF;
3701:
3702: IF (l_context_name = v_pricing_attr_ctxt) THEN
3703: l_found := 1;
3704: IF l_debug = Fnd_Api.G_TRUE THEN
3705: Oe_Debug_Pub.ADD('Found : ' || l_found);
3706: END IF;
3707: END IF;
3708:

Line 3713: IF l_debug = Fnd_Api.G_TRUE THEN

3709: END LOOP;
3710: CLOSE l_sourced_contexts;
3711:
3712: IF l_found = 0 THEN
3713: IF l_debug = Fnd_Api.G_TRUE THEN
3714: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);
3715: END IF;
3716: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;
3717: v_count := v_count + 1;

Line 3723: IF l_debug = Fnd_Api.G_TRUE THEN

3719: END LOOP;
3720: CLOSE l_pricing_contexts;
3721:
3722: v_count := v_count - 1;
3723: IF l_debug = Fnd_Api.G_TRUE THEN
3724: Oe_Debug_Pub.ADD('Number of Non-sourced contexts : ' || v_count);
3725: END IF;
3726: ELSIF NVL(G_ATTRMGR_INSTALLED,'N') = 'Y' THEN
3727: OPEN l_non_sourced_contexts;

Line 3733: IF l_debug = Fnd_Api.G_TRUE THEN

3729: LOOP
3730:
3731: FETCH l_non_sourced_contexts INTO l_context_code, l_context_type;
3732: EXIT WHEN l_non_sourced_contexts%NOTFOUND;
3733: IF l_debug = Fnd_Api.G_TRUE THEN
3734: Oe_Debug_Pub.ADD('User Entered Context: ' || l_context_code);
3735: END IF;
3736: p_user_attribs_tbl(v_count).context_name := l_context_code;
3737: v_count := v_count + 1;

Line 3742: IF l_debug = Fnd_Api.G_TRUE THEN

3738: END LOOP;
3739: CLOSE l_non_sourced_contexts;
3740:
3741: v_count := v_count - 1;
3742: IF l_debug = Fnd_Api.G_TRUE THEN
3743: Oe_Debug_Pub.ADD('Number of Non-sourced contexts : ' || v_count);
3744: END IF;
3745: END IF;
3746:

Line 3810: IF l_debug = Fnd_Api.G_TRUE THEN

3806: WHEN NO_DATA_FOUND THEN
3807: l_all_items_exist := 'N';
3808: WHEN OTHERS THEN
3809: l_all_items_exist := 'N';
3810: IF l_debug = Fnd_Api.G_TRUE THEN
3811: Oe_Debug_Pub.ADD('In exception l_all_items_exist:'||SQLERRM);
3812: END IF;
3813: END;
3814:

Line 3815: IF l_debug = Fnd_Api.G_TRUE THEN

3811: Oe_Debug_Pub.ADD('In exception l_all_items_exist:'||SQLERRM);
3812: END IF;
3813: END;
3814:
3815: IF l_debug = Fnd_Api.G_TRUE THEN
3816: Oe_Debug_Pub.ADD('In check_line_group_items l_all_items_exist '
3817: ||l_all_items_exist);
3818: Oe_Debug_Pub.ADD('In check_line_group_items G_Product_Attr_tbl.COUNT '
3819: ||G_Product_Attr_tbl.COUNT);

Line 3834: IF l_debug = Fnd_Api.G_TRUE THEN

3830: G_PASS_THIS_LINE := 'N';
3831: ELSE
3832: FOR i IN G_Product_Attr_tbl.FIRST..G_Product_Attr_tbl.LAST
3833: LOOP
3834: IF l_debug = Fnd_Api.G_TRUE THEN
3835: Oe_Debug_Pub.ADD('Looping thru prod attr '
3836: ||'attribute '||G_Product_Attr_tbl(i).attribute_name
3837: ||' value '||G_Product_Attr_tbl(i).attribute_value);
3838: END IF;

Line 3853: IF l_debug = Fnd_Api.G_TRUE THEN

3849: EXCEPTION
3850: WHEN NO_DATA_FOUND THEN
3851: NULL;
3852: WHEN OTHERS THEN
3853: IF l_debug = Fnd_Api.G_TRUE THEN
3854: Oe_Debug_Pub.ADD('In exception G_PASS_THIS_LINE:'
3855: ||SQLERRM);
3856: END IF;
3857: END;

Line 3858: IF l_debug = Fnd_Api.G_TRUE THEN

3854: Oe_Debug_Pub.ADD('In exception G_PASS_THIS_LINE:'
3855: ||SQLERRM);
3856: END IF;
3857: END;
3858: IF l_debug = Fnd_Api.G_TRUE THEN
3859: Oe_Debug_Pub.ADD('In check_line_group_items loop '
3860: ||l_prod_exists);
3861: END IF;
3862: IF l_prod_exists = 'Y'

Line 3870: IF l_debug = Fnd_Api.G_TRUE THEN

3866: END LOOP;
3867: IF l_prod_exists = 'Y'
3868: THEN
3869: G_PASS_THIS_LINE := 'Y';
3870: IF l_debug = Fnd_Api.G_TRUE THEN
3871: Oe_Debug_Pub.ADD('Check_line_group_items '
3872: ||G_PASS_THIS_LINE);
3873: END IF;
3874: ELSE

Line 3876: IF l_debug = Fnd_Api.G_TRUE THEN

3872: ||G_PASS_THIS_LINE);
3873: END IF;
3874: ELSE
3875: G_PASS_THIS_LINE := 'N';
3876: IF l_debug = Fnd_Api.G_TRUE THEN
3877: Oe_Debug_Pub.ADD('Check_line_group_items '
3878: ||G_PASS_THIS_LINE);
3879: END IF;
3880: END IF;

Line 3883: IF l_debug = Fnd_Api.G_TRUE THEN

3879: END IF;
3880: END IF;
3881:
3882: END IF;
3883: IF l_debug = Fnd_Api.G_TRUE THEN
3884: Oe_Debug_Pub.ADD('Check_line_group_items '
3885: ||'Pass Line: '||G_PASS_THIS_LINE);
3886: END IF;
3887: EXCEPTION

Line 3889: IF l_debug = Fnd_Api.G_TRUE THEN

3885: ||'Pass Line: '||G_PASS_THIS_LINE);
3886: END IF;
3887: EXCEPTION
3888: WHEN OTHERS THEN
3889: IF l_debug = Fnd_Api.G_TRUE THEN
3890: Oe_Debug_Pub.ADD('Error in QP_ATTR_MAPPING_PUB.Check_line_group_items '||SQLERRM);
3891: END IF;
3892: G_PASS_THIS_LINE := 'Y';
3893: END Check_line_group_items;

Line 3912: IF l_debug = Fnd_Api.G_TRUE THEN

3908: --delete all to start with
3909: G_PRODUCT_ATTR_TBL.DELETE;
3910: G_CHECK_LINE_FLAG := p_check_line_flag;
3911: G_PRICING_EVENT := p_pricing_event||',';
3912: IF l_debug = Fnd_Api.G_TRUE THEN
3913: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);
3914: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
3915: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type);
3916: END IF;

Line 3930: IF l_debug = Fnd_Api.G_TRUE THEN

3926:
3927: IF x_price_contexts_result_tbl.COUNT > 0 THEN
3928: FOR i IN x_price_contexts_result_tbl.FIRST..x_price_contexts_result_tbl.LAST
3929: LOOP
3930: IF l_debug = Fnd_Api.G_TRUE THEN
3931: Oe_Debug_Pub.ADD('After sourcing ret '||x_price_contexts_result_tbl(i).context_name||' '||x_price_contexts_result_tbl(i).attribute_name||' '||x_price_contexts_result_tbl(i).attribute_value);
3932: END IF;
3933: END LOOP;
3934: END IF;

Line 3939: IF l_debug = Fnd_Api.G_TRUE THEN

3935:
3936:
3937: --Indicates to caller that they need to pass this line
3938: x_pass_line := G_PASS_THIS_LINE;
3939: IF l_debug = Fnd_Api.G_TRUE THEN
3940: Oe_Debug_Pub.ADD('Build_contexts pass this line '||x_pass_line);
3941:
3942: END IF;
3943: EXCEPTION

Line 3945: IF l_debug = Fnd_Api.G_TRUE THEN

3941:
3942: END IF;
3943: EXCEPTION
3944: WHEN OTHERS THEN
3945: IF l_debug = Fnd_Api.G_TRUE THEN
3946: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
3947: END IF;
3948: END Build_Contexts;
3949:

Line 3968: IF l_debug = Fnd_Api.G_TRUE THEN

3964: IS
3965: BEGIN
3966: G_CHECK_LINE_FLAG := p_check_line_flag;
3967: G_PRICING_EVENT := p_pricing_event||',';
3968: IF l_debug = Fnd_Api.G_TRUE THEN
3969: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);
3970: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
3971: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type_code);
3972:

Line 3985: IF l_debug = Fnd_Api.G_TRUE THEN

3981: p_org_id => p_org_id
3982: );
3983: --Indicates to caller that they need to pass this line
3984: x_pass_line := G_PASS_THIS_LINE;
3985: IF l_debug = Fnd_Api.G_TRUE THEN
3986: Oe_Debug_Pub.ADD('Build_contexts pass this line '||x_pass_line);
3987:
3988: END IF;
3989: EXCEPTION

Line 3991: IF l_debug = Fnd_Api.G_TRUE THEN

3987:
3988: END IF;
3989: EXCEPTION
3990: WHEN OTHERS THEN
3991: IF l_debug = Fnd_Api.G_TRUE THEN
3992: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
3993: END IF;
3994: END Build_Contexts;
3995:

Line 4019: IF x_return = Fnd_Api.G_MISS_NUM THEN

4015: x_return := Qp_Attr_Mapping_Pub.G_Temp_Value;
4016:
4017: --dbms_output.put_line('Return Value:' || x_return);
4018:
4019: IF x_return = Fnd_Api.G_MISS_NUM THEN
4020: RETURN NULL;
4021: ELSE
4022: RETURN x_return;
4023: END IF;

Line 4027: IF x_return = Fnd_Api.G_MISS_CHAR THEN

4023: END IF;
4024:
4025: EXCEPTION
4026: WHEN VALUE_ERROR THEN
4027: IF x_return = Fnd_Api.G_MISS_CHAR THEN
4028: RETURN NULL;
4029: ELSE
4030: RETURN x_return;
4031: END IF;

Line 4231: IF l_debug = Fnd_Api.G_TRUE THEN

4227: EXIT WHEN l_ctxts_new%NOTFOUND;
4228:
4229: g_dynamic_mapping_count := g_dynamic_mapping_count + 1; -- 7323926
4230:
4231: IF l_debug = Fnd_Api.G_TRUE THEN
4232: Oe_Debug_Pub.ADD('Context = ' || l_context_name);
4233: Oe_Debug_Pub.ADD('Attribute = ' || l_attribute_name);
4234:
4235: END IF;

Line 4241: IF l_debug = Fnd_Api.G_TRUE THEN

4237:
4238: IF l_src_type = 'API' THEN
4239: --dbms_output.put_line('Before Calling Get_API_Value');
4240: l_attribute_value := Get_API_Value(l_value_string, l_successful);
4241: IF l_debug = Fnd_Api.G_TRUE THEN
4242: Oe_Debug_Pub.ADD('Attr Name = '|| l_value_string);
4243: Oe_Debug_Pub.ADD('Attr Value = '|| l_attribute_value);
4244:
4245: END IF;

Line 4249: IF l_debug = Fnd_Api.G_TRUE THEN

4245: END IF;
4246: ELSIF l_src_type = 'API_MULTIREC' THEN
4247: --dbms_output.put_line('Before Calling Get_MULTIREC_API_Value');
4248: l_attribute_mvalue := Get_API_MultiValue(l_value_string, l_successful);
4249: IF l_debug = Fnd_Api.G_TRUE THEN
4250: Oe_Debug_Pub.ADD('Multirec API = '|| l_value_string);
4251:
4252: END IF;
4253: ELSIF l_src_type = 'PROFILE_OPTION' THEN

Line 4256: IF l_debug = Fnd_Api.G_TRUE THEN

4252: END IF;
4253: ELSIF l_src_type = 'PROFILE_OPTION' THEN
4254: --dbms_output.put_line('Before Calling Get_Profile_Option_Value');
4255: l_attribute_value := Get_Profile_Option_Value(l_value_string, l_successful);
4256: IF l_debug = Fnd_Api.G_TRUE THEN
4257: Oe_Debug_Pub.ADD('Profile = '|| l_value_string);
4258: Oe_Debug_Pub.ADD('Profile Value = '|| l_attribute_value);
4259:
4260: END IF;

Line 4264: IF l_debug = Fnd_Api.G_TRUE THEN

4260: END IF;
4261: ELSIF l_src_type = 'SYSTEM' THEN
4262: --dbms_output.put_line('Before Calling Get_System_Variable');
4263: l_attribute_value := Get_System_Variable(l_value_string, l_successful);
4264: IF l_debug = Fnd_Api.G_TRUE THEN
4265: Oe_Debug_Pub.ADD('System Variable = ' || l_value_string);
4266: Oe_Debug_Pub.ADD('System Variable Value = ' || l_attribute_value);
4267:
4268: END IF;

Line 4271: IF l_debug = Fnd_Api.G_TRUE THEN

4267:
4268: END IF;
4269: ELSIF l_src_type = 'CONSTANT' THEN
4270: l_attribute_value := l_value_string;
4271: IF l_debug = Fnd_Api.G_TRUE THEN
4272: Oe_Debug_Pub.ADD('Constant = ' || l_value_string);
4273:
4274: END IF;
4275: ELSE

Line 4276: IF l_debug = Fnd_Api.G_TRUE THEN

4272: Oe_Debug_Pub.ADD('Constant = ' || l_value_string);
4273:
4274: END IF;
4275: ELSE
4276: IF l_debug = Fnd_Api.G_TRUE THEN
4277: Oe_Debug_Pub.ADD('Invalid source type');
4278:
4279: END IF;
4280: END IF;

Line 4290: IF l_debug = Fnd_Api.G_TRUE THEN

4286: l_qual_count := l_qual_count + 1;
4287:
4288: Add_to_Contexts_Results_Table(x_qual_contexts_result_tbl, l_qual_count, l_context_name, l_attribute_name, l_attribute_value);
4289:
4290: IF l_debug = Fnd_Api.G_TRUE THEN
4291: Oe_Debug_Pub.ADD('Context(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).context_name);
4292: Oe_Debug_Pub.ADD('SRC Type(' || l_qual_count || '): ' || l_src_type);
4293: Oe_Debug_Pub.ADD('SRC Value(' || l_qual_count || '): ' || l_attribute_value);
4294: Oe_Debug_Pub.ADD('Attribute Name(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_name);

Line 4305: IF l_debug = Fnd_Api.G_TRUE THEN

4301: l_price_count := l_price_count + 1;
4302:
4303: Add_to_Contexts_Results_Table(x_price_contexts_result_tbl, l_price_count, l_context_name, l_attribute_name, l_attribute_value);
4304:
4305: IF l_debug = Fnd_Api.G_TRUE THEN
4306: Oe_Debug_Pub.ADD('Context(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).context_name);
4307: Oe_Debug_Pub.ADD('SRC Type(' || l_price_count || '): ' || l_src_type);
4308: Oe_Debug_Pub.ADD('SRC Value(' || l_price_count || '): ' || l_attribute_value);
4309: Oe_Debug_Pub.ADD('Attribute Name(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_name);

Line 4315: IF l_debug = Fnd_Api.G_TRUE THEN

4311: Oe_Debug_Pub.ADD('------------------------------');
4312:
4313: END IF;
4314: ELSE
4315: IF l_debug = Fnd_Api.G_TRUE THEN
4316: Oe_Debug_Pub.ADD('Context type invalid');
4317:
4318: END IF;
4319: END IF;

Line 4323: IF l_debug = Fnd_Api.G_TRUE THEN

4319: END IF;
4320:
4321: ELSIF (l_attribute_mvalue IS NOT NULL) AND (l_src_type = 'API_MULTIREC') THEN
4322:
4323: IF l_debug = Fnd_Api.G_TRUE THEN
4324: Oe_Debug_Pub.ADD('Found a MULTIREC for context type: ' || l_context_type);
4325:
4326: END IF;
4327:

Line 4341: IF l_debug = Fnd_Api.G_TRUE THEN

4337: l_qual_count := l_qual_count + 1;
4338:
4339: Add_to_Contexts_Results_Table(x_qual_contexts_result_tbl,l_qual_count,l_context_name,l_attribute_name,l_attribute_mvalue(l_index));
4340:
4341: IF l_debug = Fnd_Api.G_TRUE THEN
4342: Oe_Debug_Pub.ADD('Context(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).context_name);
4343: Oe_Debug_Pub.ADD('SRC Type(' || l_qual_count || '): ' || l_src_type);
4344: Oe_Debug_Pub.ADD('SRC Value(' || l_qual_count || '): ' || l_attribute_value);
4345: Oe_Debug_Pub.ADD('Attribute Name(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_name);

Line 4356: IF l_debug = Fnd_Api.G_TRUE THEN

4352: l_price_count := l_price_count + 1;
4353:
4354: Add_to_Contexts_Results_Table(x_price_contexts_result_tbl,l_price_count,l_context_name,l_attribute_name,l_attribute_mvalue(l_index));
4355:
4356: IF l_debug = Fnd_Api.G_TRUE THEN
4357: Oe_Debug_Pub.ADD('Context(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).context_name);
4358: Oe_Debug_Pub.ADD('SRC Type(' || l_price_count || '): ' || l_src_type);
4359: Oe_Debug_Pub.ADD('SRC Value(' || l_price_count || '): ' || l_attribute_value);
4360: Oe_Debug_Pub.ADD('Attribute Name(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_name);

Line 4366: IF l_debug = Fnd_Api.G_TRUE THEN

4362: Oe_Debug_Pub.ADD('------------------------------');
4363:
4364: END IF;
4365: ELSE
4366: IF l_debug = Fnd_Api.G_TRUE THEN
4367: Oe_Debug_Pub.ADD('Context type invalid');
4368:
4369: END IF;
4370: END IF;

Line 4379: IF l_debug = Fnd_Api.G_TRUE THEN

4375:
4376: END IF;
4377:
4378: ELSE
4379: IF l_debug = Fnd_Api.G_TRUE THEN
4380: Oe_Debug_Pub.ADD('No value was obtained in the mapping process of source type ' || l_src_type);
4381:
4382: END IF;
4383: END IF;

Line 4528: IF l_debug = Fnd_Api.G_TRUE THEN

4524: ELSIF l_src_type = 'CONSTANT' THEN
4525: l_attribute_value := l_value_string;
4526:
4527: ELSE
4528: IF l_debug = Fnd_Api.G_TRUE THEN
4529: Oe_Debug_Pub.ADD('Invalid source type');
4530:
4531: END IF;
4532: END IF;