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 308: IF l_debug = Fnd_Api.G_TRUE THEN

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

Line 327: IF l_debug = Fnd_Api.G_TRUE THEN

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

Line 333: IF l_debug = Fnd_Api.G_TRUE THEN

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

Line 343: RAISE Fnd_Api.G_EXC_ERROR;

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

Line 357: IF l_debug = Fnd_Api.G_TRUE THEN

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

Line 390: IF l_debug = Fnd_Api.G_TRUE THEN

386: -- 13638721
387: PUT_LINE('Now create PACKAGE '||p_pkg_type||' : '
388: ||l_new_pkg_name);
389:
390: IF l_debug = Fnd_Api.G_TRUE THEN
391: Oe_Debug_Pub.ADD('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
392:
393: END IF;
394: IF INSTR(ad_ddl.glprogtext(1),p_pkg_name) > 0

Line 403: IF l_debug = Fnd_Api.G_TRUE THEN

399: ,l_new_pkg_name);
400: PUT_LINE('First change : '
401: ||ad_ddl.glprogtext(1));
402:
403: IF l_debug = Fnd_Api.G_TRUE THEN
404: Oe_Debug_Pub.ADD('First change : ' ||ad_ddl.glprogtext(1));
405:
406: END IF;
407: ad_ddl.glprogtext(line_number) :=

Line 414: IF l_debug = Fnd_Api.G_TRUE THEN

410: ,l_new_pkg_name);
411: PUT_LINE('Second change : '
412: ||' '||ad_ddl.glprogtext(line_number));
413:
414: IF l_debug = Fnd_Api.G_TRUE THEN
415: Oe_Debug_Pub.ADD('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
416:
417: END IF;
418: PUT_LINE('Trying to create PACKAGE '||p_pkg_type

Line 421: IF l_debug = Fnd_Api.G_TRUE THEN

417: END IF;
418: PUT_LINE('Trying to create PACKAGE '||p_pkg_type
419: ||' :'||l_new_pkg_name);
420:
421: IF l_debug = Fnd_Api.G_TRUE THEN
422: Oe_Debug_Pub.ADD('Trying to create PACKAGE '||p_pkg_type
423: ||' :'||l_new_pkg_name);
424:
425: END IF;

Line 443: IF l_debug = Fnd_Api.G_TRUE THEN

439: IF n = 0 THEN
440: PUT_LINE('ERROR in creating PACKAGE '
441: ||p_pkg_type||' :'||l_pkg_name);
442:
443: IF l_debug = Fnd_Api.G_TRUE THEN
444: Oe_Debug_Pub.ADD('ERROR in creating PACKAGE '
445: ||p_pkg_type||' :'||l_pkg_name);
446:
447: END IF;

Line 452: IF l_debug = Fnd_Api.G_TRUE THEN

448: END IF;
449: PUT_LINE('LINE :'||error.line||' '
450: ||SUBSTR(error.text,1,200));
451:
452: IF l_debug = Fnd_Api.G_TRUE THEN
453: Oe_Debug_Pub.ADD('LINE :'||error.line||' '
454: ||SUBSTR(error.text,1,200));
455: END IF;
456: n := 1;

Line 462: RAISE Fnd_Api.G_EXC_ERROR;

458:
459: -- if there was an error in compiling the package, raise
460: -- an error
461: IF n > 0 THEN
462: RAISE Fnd_Api.G_EXC_ERROR;
463: END IF;
464: PUT_LINE('Generated PACKAGE '||p_pkg_type
465: ||' :'||l_new_pkg_name
466: ||' Successfully');

Line 468: IF l_debug = Fnd_Api.G_TRUE THEN

464: PUT_LINE('Generated PACKAGE '||p_pkg_type
465: ||' :'||l_new_pkg_name
466: ||' Successfully');
467:
468: IF l_debug = Fnd_Api.G_TRUE THEN
469: Oe_Debug_Pub.ADD('Generated PACKAGE '||p_pkg_type
470: ||' :'||l_new_pkg_name ||' Successfully');
471: END IF;
472:

Line 539: WHEN Fnd_Api.G_EXC_ERROR THEN

535: END IF;--instr
536: END IF;--n=0
537:
538: EXCEPTION
539: WHEN Fnd_Api.G_EXC_ERROR THEN
540: RAISE Fnd_Api.G_EXC_ERROR;
541: WHEN OTHERS THEN
542: RAISE_APPLICATION_ERROR(-20000,SQLERRM||' '||ad_ddl.error_buf);
543: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);

Line 540: RAISE Fnd_Api.G_EXC_ERROR;

536: END IF;--n=0
537:
538: EXCEPTION
539: WHEN Fnd_Api.G_EXC_ERROR THEN
540: RAISE Fnd_Api.G_EXC_ERROR;
541: WHEN OTHERS THEN
542: RAISE_APPLICATION_ERROR(-20000,SQLERRM||' '||ad_ddl.error_buf);
543: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
544: -- RAISE FND_API.G_EXC_ERROR;

Line 544: -- RAISE FND_API.G_EXC_ERROR;

540: RAISE Fnd_Api.G_EXC_ERROR;
541: WHEN OTHERS THEN
542: RAISE_APPLICATION_ERROR(-20000,SQLERRM||' '||ad_ddl.error_buf);
543: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
544: -- RAISE FND_API.G_EXC_ERROR;
545:
546: END Pkg_End;
547:
548: -- Generates the Package Header for the package SPEC and BODY

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

1115: Text('v_attr_value := NULL;',4);
1116: Text('END;',2);
1117: New_Line;
1118: Text('BEGIN',2);
1119: Text('IF v_attr_value = FND_API.G_MISS_NUM THEN',2);
1120: Text('v_attr_value := NULL;',3);
1121: Text('END IF;',2);
1122: Text('EXCEPTION',2);
1123: Text('WHEN VALUE_ERROR THEN',3);

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

1120: Text('v_attr_value := NULL;',3);
1121: Text('END IF;',2);
1122: Text('EXCEPTION',2);
1123: Text('WHEN VALUE_ERROR THEN',3);
1124: Text('IF v_attr_value = FND_API.G_MISS_CHAR THEN',4);
1125: Text('v_attr_value := NULL;',5);
1126: Text('END IF;',4);
1127: Text('WHEN OTHERS THEN',3);
1128: Text('v_attr_value := NULL;',4);

Line 1200: 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);

1196: IF v_context_name = 'MODLIST'
1197: AND
1198: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
1199: THEN
1200: 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);
1201: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
1202: Text ('End If;', 4);
1203: END IF;
1204:

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

1265: Break_Text(v_src_type,v_attr_src_string);
1266: END IF;
1267: Text('EXCEPTION',2);
1268: Text('WHEN OTHERS THEN',3);
1269: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1270: Text('oe_debug_pub.add(''Multirec API error'');',5);
1271: Text('END IF;',4);
1272: Text('END;',2);
1273: New_Line;

Line 1298: 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);

1294: IF v_context_name = 'MODLIST'
1295: AND
1296: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
1297: THEN
1298: 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);
1299: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
1300: Text ('End If;', 4);
1301: END IF;
1302:

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

1738: IF v_context_type <> 'PRODUCT'
1739: AND l_context_type_processed = 'PRODUCT'
1740: AND l_code_release_level > '110508'
1741: THEN
1742: Text('IF l_debug = FND_API.G_TRUE THEN',2);
1743: text('oe_debug_pub.add(''In check to call line_group'');',3);
1744: Text('END IF;',2);
1745: Text('IF QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG = ''Y'' THEN',2);
1746: Text('BEGIN',3);

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

1743: text('oe_debug_pub.add(''In check to call line_group'');',3);
1744: Text('END IF;',2);
1745: Text('IF QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG = ''Y'' THEN',2);
1746: Text('BEGIN',3);
1747: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1748: text('oe_debug_pub.add(''Before call line_group'');',4);
1749: Text('END IF;',3);
1750: Text('QP_ATTR_MAPPING_PUB.Check_line_group_items(p_pricing_type_code);',3);
1751: Text('IF l_debug = FND_API.G_TRUE THEN',3);

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

1747: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1748: text('oe_debug_pub.add(''Before call line_group'');',4);
1749: Text('END IF;',3);
1750: Text('QP_ATTR_MAPPING_PUB.Check_line_group_items(p_pricing_type_code);',3);
1751: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1752: text('oe_debug_pub.add(''After call line_group'');',4);
1753: Text('END IF;',3);
1754: Text('EXCEPTION',3);
1755: Text('WHEN OTHERS THEN',3);

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

1752: text('oe_debug_pub.add(''After call line_group'');',4);
1753: Text('END IF;',3);
1754: Text('EXCEPTION',3);
1755: Text('WHEN OTHERS THEN',3);
1756: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1757: Text('oe_debug_pub.add(''Error in Check_line_group_items'');',5);
1758: Text('END IF;',4);
1759: Text('END;',3);
1760: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);

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

1761: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1762: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1763: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N''',2);
1764: Text(' OR QP_ATTR_MAPPING_PUB.G_IGNORE_PRICE = '||'''Y'''||' THEN',2); --8589909
1765: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1766: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1767: Text('END IF;',3);
1768: Text('x_price_ctxts_result_tbl.delete;',3);
1769: Text('RETURN;',3);

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

1803: Text('v_attr_value := NULL;',4);
1804: Text('END;',2);
1805: New_Line;
1806: Text('BEGIN',2);
1807: Text('IF v_attr_value = FND_API.G_MISS_NUM THEN',2);
1808: Text('v_attr_value := NULL;',3);
1809: Text('END IF;',2);
1810: Text('EXCEPTION',2);
1811: Text('WHEN VALUE_ERROR THEN',3);

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

1808: Text('v_attr_value := NULL;',3);
1809: Text('END IF;',2);
1810: Text('EXCEPTION',2);
1811: Text('WHEN VALUE_ERROR THEN',3);
1812: Text('IF v_attr_value = FND_API.G_MISS_CHAR THEN',4);
1813: Text('v_attr_value := NULL;',5);
1814: Text('END IF;',4);
1815: Text('WHEN OTHERS THEN',3);
1816: Text('v_attr_value := NULL;',4);

Line 1885: 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);

1881: IF v_context_name = 'MODLIST'
1882: AND
1883: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
1884: THEN
1885: 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);
1886: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
1887: Text ('End If;', 4);
1888: END IF;
1889:

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

1923: --added for changed lines performance improvement bug 2491269
1924: IF v_context_type = 'PRODUCT'
1925: AND l_code_release_level > '110508'
1926: THEN
1927: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1928: text('oe_debug_pub.add(''Gathering product details'');',5);
1929: Text('END IF;',4);
1930: l_context_type_processed := v_context_type;
1931: Text('BEGIN',4);

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

1932: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
1933: ||'x_price_ctxts_result_tbl(p_count-1);',5);
1934: Text('Exception',4);
1935: Text('When Others Then',4);
1936: Text('IF l_debug = FND_API.G_TRUE THEN',5);
1937: Text('oe_debug_pub.add(''No product sourced '');',6);
1938: Text('END IF;',5);
1939: Text('END;',4);
1940: END IF;--v_context_type = 'PRODUCT'

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

1937: Text('oe_debug_pub.add(''No product sourced '');',6);
1938: Text('END IF;',5);
1939: Text('END;',4);
1940: END IF;--v_context_type = 'PRODUCT'
1941: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1942: text('oe_debug_pub.add(''After product assigned'');',5);
1943: Text('END IF;',4);
1944:
1945: Text('END IF;--v_attr_(m)value',2);

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

1968: Break_Text(v_src_type,v_attr_src_string);
1969: END IF;
1970: Text('EXCEPTION',2);
1971: Text('WHEN OTHERS THEN',3);
1972: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1973: Text('oe_debug_pub.add(''Multirec API error'');',5);
1974: Text('END IF;',4);
1975: Text('END;',2);
1976: New_Line;

Line 2001: 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);

1997: IF v_context_name = 'MODLIST'
1998: AND
1999: v_attribute_name = 'QUALIFIER_ATTRIBUTE4'
2000: THEN
2001: 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);
2002: Text ('QP_BULK_PREQ_GRP.G_validated_flag(q_count) := ''Y'';', 4);
2003: Text ('End If;', 4);
2004: END IF;
2005:

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

2041: --added for changed lines performance improvement bug 2491269
2042: IF v_context_type = 'PRODUCT'
2043: AND l_code_release_level > '110508'
2044: THEN
2045: Text('IF l_debug = FND_API.G_TRUE THEN',4);
2046: text('oe_debug_pub.add(''Gathering product details'');',5);
2047: Text('END IF;',4);
2048: l_context_type_processed := v_context_type;
2049: Text('BEGIN',4);

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

2050: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
2051: ||'x_price_ctxts_result_tbl(p_count-1);',5);
2052: Text('Exception',4);
2053: Text('When Others Then',4);
2054: Text('IF l_debug = FND_API.G_TRUE THEN',5);
2055: Text('oe_debug_pub.add(''No product sourced '');',6);
2056: Text('END IF;',5);
2057: Text('END;',4);
2058: END IF;--v_context_type = 'PRODUCT'

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

2055: Text('oe_debug_pub.add(''No product sourced '');',6);
2056: Text('END IF;',5);
2057: Text('END;',4);
2058: END IF;--v_context_type = 'PRODUCT'
2059: Text('IF l_debug = FND_API.G_TRUE THEN',4);
2060: text('oe_debug_pub.add(''After product assigned'');',5);
2061: Text('END IF;',4);
2062:
2063:

Line 2111: IF l_debug = Fnd_Api.G_TRUE THEN

2107: BEGIN
2108:
2109: --dbms_output.put_line('............1............');
2110: --l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2111: IF l_debug = Fnd_Api.G_TRUE THEN
2112: Oe_Debug_Pub.ADD('##### Begin Build Sourcing #####');
2113:
2114: END IF;
2115: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);

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

2138: Text('q_count NUMBER := 1;',0);
2139: Text('p_count NUMBER := 1;',0);
2140: Text('v_index NUMBER := 1;',0);
2141: Text('v_tot_time NUMBER := 0;',0);
2142: Text('prev_header_id NUMBER := FND_API.G_MISS_NUM;',0);
2143: New_Line;
2144: Text('l_debug VARCHAR2(3);',0);
2145: Text('BEGIN',0);
2146: Text('qp_debug_util.tstart(''FETCH_ATTRIBUTES'',''Fetching the Attribute Values'');',0);

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

2150:
2151: -- added for g_new_pricing_call for caching - hwong
2152: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2153: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);
2154: Text('IF l_debug = FND_API.G_TRUE THEN',1);
2155: text('oe_debug_pub.add(''hw/src/H: change to g_yes'');',2);
2156: Text('END IF;',1);
2157: text('end if;', 0);
2158: new_line;

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

2195: new_line;
2196: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then');
2197: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 1);
2198: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 2);
2199: Text('IF l_debug = FND_API.G_TRUE THEN',2);
2200: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',3);
2201: Text('END IF;',2);
2202: text('end if;', 1);
2203: Text('End If;');

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

2247: new_line;
2248: Text ('If QP_Util_PUB.HVOP_Pricing_On = ''N'' Then',1);
2249: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 2);
2250: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 3);
2251: Text('IF l_debug = FND_API.G_TRUE THEN',3);
2252: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',4);
2253: Text('END IF;',3);
2254: text('end if;', 2);
2255: Text ('End If;', 1);

Line 2303: IF l_debug = Fnd_Api.G_TRUE THEN

2299: retcode := 0;
2300: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');
2301: err_buff := Fnd_Message.GET;
2302:
2303: IF l_debug = Fnd_Api.G_TRUE THEN
2304: Oe_Debug_Pub.ADD('##### End Build Sourcing #####');
2305:
2306: END IF;
2307: EXCEPTION

Line 2309: WHEN Fnd_Api.G_EXC_ERROR THEN

2305:
2306: END IF;
2307: EXCEPTION
2308:
2309: WHEN Fnd_Api.G_EXC_ERROR THEN
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));

Line 2379: IF l_debug = Fnd_Api.G_TRUE THEN

2375:
2376:
2377: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2378:
2379: IF l_debug = Fnd_Api.G_TRUE THEN
2380: Oe_Debug_Pub.ADD('##### Begin Build Contexts #####');
2381: END IF;
2382: --setting time
2383: l_sourcing_start_time := dbms_utility.get_time;

Line 2544: IF l_debug = Fnd_Api.G_TRUE THEN

2540:
2541: v_count := v_count + 1;
2542: EXIT WHEN v_count > x_qual_contexts_result_tbl.COUNT;
2543:
2544: IF l_debug = Fnd_Api.G_TRUE THEN
2545: Oe_Debug_Pub.ADD('Context Name: ' || x_qual_contexts_result_tbl(v_count).context_name);
2546: Oe_Debug_Pub.ADD('Attribute Name: ' || x_qual_contexts_result_tbl(v_count).attribute_name);
2547: Oe_Debug_Pub.ADD('Attribute Value: ' || x_qual_contexts_result_tbl(v_count).attribute_value);
2548:

Line 2559: IF l_debug = Fnd_Api.G_TRUE THEN

2555:
2556: v_count := v_count + 1;
2557: EXIT WHEN v_count > x_price_contexts_result_tbl.COUNT;
2558:
2559: IF l_debug = Fnd_Api.G_TRUE THEN
2560: Oe_Debug_Pub.ADD('Context Name: ' || x_price_contexts_result_tbl(v_count).context_name);
2561: Oe_Debug_Pub.ADD('Attribute Name: ' || x_price_contexts_result_tbl(v_count).attribute_name);
2562: Oe_Debug_Pub.ADD('Attribute Value: ' || x_price_contexts_result_tbl(v_count).attribute_value);
2563:

Line 2567: IF l_debug = Fnd_Api.G_TRUE THEN

2563:
2564: END IF;
2565: END LOOP;
2566:
2567: IF l_debug = Fnd_Api.G_TRUE THEN
2568: Oe_Debug_Pub.ADD('##### End Build Contexts #####');
2569:
2570: END IF;
2571: --setting time

Line 2575: IF l_debug = Fnd_Api.G_TRUE THEN

2571: --setting time
2572: l_sourcing_end_time := dbms_utility.get_time;
2573: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
2574:
2575: IF l_debug = Fnd_Api.G_TRUE THEN
2576: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');
2577:
2578:
2579: END IF;

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

2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2649: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2650:
2651: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2652: K PLS_INTEGER;
2653:
2654: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');
2655:

Line 2730: IF l_debug = Fnd_Api.G_TRUE THEN

2726: l_LINE_DETAIL_type_CODE_tbl.DELETE;
2727: l_MODIFIER_LEVEL_CODE_tbl.DELETE;
2728: l_PRIMARY_UOM_FLAG_tbl.DELETE;
2729:
2730: IF l_debug = Fnd_Api.G_TRUE THEN
2731: Qp_Preq_Grp.ENGINE_DEBUG('Begin Build contexts');
2732:
2733: END IF;
2734: K := 0;

Line 2738: IF l_debug = Fnd_Api.G_TRUE THEN

2734: K := 0;
2735: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2736:
2737: --Called Build Sourcing at line level
2738: IF l_debug = Fnd_Api.G_TRUE THEN
2739: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at line level----------');
2740:
2741: END IF;
2742: l_pricing_type_code := 'L';

Line 2747: IF l_debug = Fnd_Api.G_TRUE THEN

2743:
2744: IF (p_pricing_type_code = 'L') THEN
2745: --ignore_pricing start
2746: IF ( NVL(Fnd_Profile.value('QP_CUSTOM_IGNORE_PRICING'),'N') = 'Y') THEN
2747: IF l_debug = Fnd_Api.G_TRUE THEN
2748: Oe_Debug_Pub.ADD('ignore_pricing : QP Profile QP_CUSTOM_IGNORE_PRICING is ON' );
2749: END IF;
2750: BEGIN
2751: QP_CUSTOM_IGNORE.IGNORE_ITEMLINE_FOR_PRICING(p_request_type_code,l_ignore,l_default_price_list_id);

Line 2762: IF l_debug = Fnd_Api.G_TRUE THEN

2758: EXCEPTION
2759: WHEN OTHERS THEN
2760: l_ignore := 'N';
2761: G_IGNORE_PRICE := 'N'; --8589909
2762: IF l_debug = Fnd_Api.G_TRUE THEN
2763: Oe_Debug_Pub.ADD('ignore_pricing : Error in custom Code IGNORE_ITEMLINE_FOR_PRICING ' );
2764: Oe_Debug_Pub.ADD('ignore_pricing : Item will be Priced' );
2765: END IF;
2766: END;

Line 2768: IF l_debug = Fnd_Api.G_TRUE THEN

2764: Oe_Debug_Pub.ADD('ignore_pricing : Item will be Priced' );
2765: END IF;
2766: END;
2767: ELSE
2768: IF l_debug = Fnd_Api.G_TRUE THEN
2769: Oe_Debug_Pub.ADD('ignore_pricing : QP Profile QP_CUSTOM_IGNORE_PRICING is OFF');
2770: END IF;
2771: END IF;
2772: -- 13638721

Line 2823: IF l_debug = Fnd_Api.G_TRUE THEN

2819: END IF;
2820: END IF;
2821: -- 13638721
2822: IF (l_ignore = 'Y' AND G_PASS_THIS_LINE = 'Y') THEN --8589909
2823: IF l_debug = Fnd_Api.G_TRUE THEN
2824: Oe_Debug_Pub.ADD('ignore_pricing : Line is NON PRICABLE' );
2825: END IF;
2826: l_qual_contexts_result_tbl(l_ignore_cnt).context_name := 'MODLIST';
2827: l_qual_contexts_result_tbl(l_ignore_cnt).attribute_name := 'QUALIFIER_ATTRIBUTE40';

Line 2853: IF l_debug = Fnd_Api.G_TRUE THEN

2849: Build_Contexts program calls this procedure to pickup custom sourced attributes if the
2850: profile option ' QP_CUSTOM_SOURCED' is set to 'Y' -- GTIPPIRE
2851: */
2852:
2853: IF l_debug = Fnd_Api.G_TRUE THEN
2854: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2855: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2856:
2857: END IF;

Line 2859: IF l_debug = Fnd_Api.G_TRUE THEN

2855: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2856:
2857: END IF;
2858: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2859: IF l_debug = Fnd_Api.G_TRUE THEN
2860: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
2861: END IF;
2862: Begin
2863: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');

Line 2873: IF l_debug = Fnd_Api.G_TRUE THEN

2869: exception
2870: when others then
2871: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
2872: end;
2873: IF l_debug = Fnd_Api.G_TRUE THEN
2874: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2875:
2876: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2877: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );

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

3046: 'QUALIFIER_ATTRIBUTE4'
3047: THEN
3048:
3049: IF Oe_Order_Pub.G_Line.agreement_id IS NOT NULL
3050: AND Oe_Order_Pub.G_Line.agreement_id <> Fnd_Api.g_miss_num
3051: AND NVL(p_price_list_validated_flag,'Y') = 'Y'
3052: THEN
3053: l_validated_flag_tbl(K) := 'Y';
3054: ELSIF NVL(p_price_list_validated_flag,'N') = 'N' THEN

Line 3070: IF l_debug = Fnd_Api.G_TRUE THEN

3066:
3067: END IF;
3068:
3069: --Called Build Sourcing at header level
3070: IF l_debug = Fnd_Api.G_TRUE THEN
3071: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at header level----------');
3072:
3073: END IF;
3074: v_count := 0;

Line 3138: IF l_debug = Fnd_Api.G_TRUE THEN

3134: END IF;
3135: END IF;
3136: -- 13638721
3137:
3138: IF l_debug = Fnd_Api.G_TRUE THEN
3139: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
3140: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
3141:
3142: END IF;

Line 3152: IF l_debug = Fnd_Api.G_TRUE THEN

3148: profile option ' QP_CUSTOM_SOURCED' is set to 'Y' -- GTIPPIRE
3149: */
3150:
3151: IF NVL(l_custom_sourced,'N') = 'Y' THEN
3152: IF l_debug = Fnd_Api.G_TRUE THEN
3153: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
3154: END IF;
3155: Begin
3156: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');

Line 3167: IF l_debug = Fnd_Api.G_TRUE THEN

3163: when others then
3164: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
3165: end;
3166:
3167: IF l_debug = Fnd_Api.G_TRUE THEN
3168: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
3169:
3170: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
3171: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );

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

3339: 'QUALIFIER_ATTRIBUTE4'
3340: THEN
3341:
3342: IF Oe_Order_Pub.G_Line.agreement_id IS NOT NULL
3343: AND Oe_Order_Pub.G_Line.agreement_id <> Fnd_Api.g_miss_num
3344: THEN
3345: l_validated_flag_tbl(K) := 'Y';
3346: ELSE
3347: l_validated_flag_tbl(K) := 'N';

Line 3358: IF l_debug = Fnd_Api.G_TRUE THEN

3354: --END LOOP;
3355:
3356: END IF;
3357:
3358: IF l_debug = Fnd_Api.G_TRUE THEN
3359:
3360: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3361: FOR i IN 1..l_line_index_tbl.COUNT
3362: LOOP

Line 3363: IF l_debug = Fnd_Api.G_TRUE THEN

3359:
3360: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3361: FOR i IN 1..l_line_index_tbl.COUNT
3362: LOOP
3363: IF l_debug = Fnd_Api.G_TRUE THEN
3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));

Line 3379: IF l_debug = Fnd_Api.G_TRUE THEN

3375:
3376: IF l_line_index_tbl.COUNT > 0
3377: THEN
3378: BEGIN
3379: IF l_debug = Fnd_Api.G_TRUE THEN
3380: Qp_Preq_Grp.ENGINE_DEBUG('Tata Inserting line attributes ----------');
3381: END IF;
3382:
3383: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN

Line 3384: IF l_debug = Fnd_Api.G_TRUE THEN

3380: Qp_Preq_Grp.ENGINE_DEBUG('Tata Inserting line attributes ----------');
3381: END IF;
3382:
3383: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3384: IF l_debug = Fnd_Api.G_TRUE THEN
3385: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine not Installed ----------');
3386: END IF;
3387:
3388: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST

Line 3413: IF l_debug = Fnd_Api.G_TRUE THEN

3409: Qp_Preq_Pub.G_STATUS_UNCHANGED,
3410: Qp_Preq_Pub.G_YES
3411: );
3412: ELSE -- Java Engine path added by yangli
3413: IF l_debug = Fnd_Api.G_TRUE THEN
3414: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3415: END IF;
3416: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,
3417: QP_PREQ_PUB.G_LINE_LEVEL,

Line 3469: IF l_status_code = Fnd_Api.G_RET_STS_ERROR THEN

3465: p_MODIFIER_LEVEL_CODE_tbl=> l_MODIFIER_LEVEL_CODE_tbl,
3466: p_PRIMARY_UOM_FLAG_tbl=> l_PRIMARY_UOM_FLAG_tbl,
3467: x_status_code => l_status_code,
3468: x_status_text => l_status_text);
3469: IF l_status_code = Fnd_Api.G_RET_STS_ERROR THEN
3470: RAISE E_ROUTINE_ERRORS;
3471: END IF;
3472: END IF;
3473:

Line 3474: IF l_debug = Fnd_Api.G_TRUE THEN

3470: RAISE E_ROUTINE_ERRORS;
3471: END IF;
3472: END IF;
3473:
3474: IF l_debug = Fnd_Api.G_TRUE THEN
3475: Qp_Preq_Grp.ENGINE_DEBUG('End Inserting line attributes ----------');
3476: END IF;
3477: EXCEPTION
3478: WHEN E_ROUTINE_ERRORS THEN

Line 3479: IF l_debug = Fnd_Api.G_TRUE THEN

3475: Qp_Preq_Grp.ENGINE_DEBUG('End Inserting line attributes ----------');
3476: END IF;
3477: EXCEPTION
3478: WHEN E_ROUTINE_ERRORS THEN
3479: IF l_debug = Fnd_Api.G_TRUE THEN
3480: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3481: END IF;
3482: WHEN OTHERS THEN
3483: IF l_debug = Fnd_Api.G_TRUE THEN

Line 3483: IF l_debug = Fnd_Api.G_TRUE THEN

3479: IF l_debug = Fnd_Api.G_TRUE THEN
3480: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3481: END IF;
3482: WHEN OTHERS THEN
3483: IF l_debug = Fnd_Api.G_TRUE THEN
3484: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||' '||SQLERRM);
3485: END IF;
3486: END;
3487:

Line 3490: IF l_debug = Fnd_Api.G_TRUE THEN

3486: END;
3487:
3488: END IF;
3489:
3490: IF l_debug = Fnd_Api.G_TRUE THEN
3491: Qp_Preq_Grp.ENGINE_DEBUG('End Build contexts');
3492:
3493: END IF;
3494: --setting time

Line 3498: IF l_debug = Fnd_Api.G_TRUE THEN

3494: --setting time
3495: l_sourcing_end_time := dbms_utility.get_time;
3496: l_time_difference := (l_sourcing_end_time - l_sourcing_start_time)/100 ;
3497:
3498: IF l_debug = Fnd_Api.G_TRUE THEN
3499: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');
3500:
3501: END IF;
3502: EXCEPTION

Line 3504: IF l_debug = Fnd_Api.G_TRUE THEN

3500:
3501: END IF;
3502: EXCEPTION
3503: WHEN OTHERS THEN
3504: IF l_debug = Fnd_Api.G_TRUE THEN
3505: Qp_Preq_Grp.ENGINE_DEBUG('Exception in QP_ATTR_MAPPING_PUB.Build_context '||SQLERRM);
3506:
3507: END IF;
3508: END Build_Contexts;

Line 3581: IF l_debug = Fnd_Api.G_TRUE THEN

3577:
3578: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3579: EXIT WHEN l_pricing_attribs%NOTFOUND;
3580:
3581: IF l_debug = Fnd_Api.G_TRUE THEN
3582: Oe_Debug_Pub.ADD('Item Context: ' || v_pricing_attr_ctxt);
3583: Oe_Debug_Pub.ADD('Item Attribute: ' || v_pricing_attr);
3584:
3585: END IF;

Line 3601: IF l_debug = Fnd_Api.G_TRUE THEN

3597: FROM oe_def_condn_elems
3598: WHERE condition_id = l_condition_id
3599: AND attribute_code = 'PRICING_CONTEXT';
3600:
3601: IF l_debug = Fnd_Api.G_TRUE THEN
3602: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);
3603: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3604: END IF;
3605:

Line 3609: IF l_debug = Fnd_Api.G_TRUE THEN

3605:
3606: IF l_context_name = v_pricing_attr_ctxt THEN
3607:
3608: l_found := 1;
3609: IF l_debug = Fnd_Api.G_TRUE THEN
3610: Oe_Debug_Pub.ADD('Found : ' || l_found);
3611:
3612: END IF;
3613: END IF;

Line 3621: IF l_debug = Fnd_Api.G_TRUE THEN

3617: CLOSE l_cond_cursor;
3618:
3619: IF l_found = 0 THEN
3620:
3621: IF l_debug = Fnd_Api.G_TRUE THEN
3622: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);
3623: Oe_Debug_Pub.ADD('Not Found attribute: ' || v_pricing_attr);
3624: END IF;
3625: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3642: IF l_debug = Fnd_Api.G_TRUE THEN

3638:
3639: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3640: EXIT WHEN l_pricing_attribs%NOTFOUND;
3641:
3642: IF l_debug = Fnd_Api.G_TRUE THEN
3643: Oe_Debug_Pub.ADD('Item Context: ' || v_pricing_attr_ctxt);
3644: Oe_Debug_Pub.ADD('Item Attribute: ' || v_pricing_attr);
3645:
3646: END IF;

Line 3657: IF l_debug = Fnd_Api.G_TRUE THEN

3653: FETCH l_cond_cursor_new INTO l_segment_code, l_segment_mapping_column,
3654: l_context_code,l_context_type;
3655: EXIT WHEN l_cond_cursor_new%NOTFOUND;
3656:
3657: IF l_debug = Fnd_Api.G_TRUE THEN
3658: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_code);
3659: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3660: END IF;
3661:

Line 3665: IF l_debug = Fnd_Api.G_TRUE THEN

3661:
3662: IF l_context_code = v_pricing_attr_ctxt THEN
3663:
3664: l_found := 1;
3665: IF l_debug = Fnd_Api.G_TRUE THEN
3666: Oe_Debug_Pub.ADD('Found : ' || l_found);
3667:
3668: END IF;
3669: END IF;

Line 3676: IF l_debug = Fnd_Api.G_TRUE THEN

3672: CLOSE l_cond_cursor_new;
3673:
3674: IF l_found = 1 THEN
3675:
3676: IF l_debug = Fnd_Api.G_TRUE THEN
3677: Oe_Debug_Pub.ADD('Found User Entered context: ' || v_pricing_attr_ctxt);
3678: Oe_Debug_Pub.ADD('Found User Entered attribute: ' || v_pricing_attr);
3679: END IF;
3680: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3714: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR

3710: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3711: FROM qp_pricing_attributes
3712: WHERE pricing_attribute_context IS NOT NULL
3713: AND pricing_attribute_context NOT IN ('VOLUME','ITEM')
3714: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR
3715: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR
3716: AND pricing_attribute IS NOT NULL;
3717:
3718: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS

Line 3715: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR

3711: FROM qp_pricing_attributes
3712: WHERE pricing_attribute_context IS NOT NULL
3713: AND pricing_attribute_context NOT IN ('VOLUME','ITEM')
3714: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR
3715: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR
3716: AND pricing_attribute IS NOT NULL;
3717:
3718: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS
3719: SELECT c.condition_id, d.attr_def_condition_id

Line 3758: IF l_debug = Fnd_Api.G_TRUE THEN

3754:
3755: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3756: EXIT WHEN l_pricing_attribs%NOTFOUND;
3757:
3758: IF l_debug = Fnd_Api.G_TRUE THEN
3759: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));
3760: Oe_Debug_Pub.ADD('Pricing Attribute: ' || v_pricing_attr);
3761:
3762: END IF;

Line 3778: IF l_debug = Fnd_Api.G_TRUE THEN

3774: FROM oe_def_condn_elems
3775: WHERE condition_id = l_condition_id
3776: AND attribute_code = 'PRICING_CONTEXT';
3777:
3778: IF l_debug = Fnd_Api.G_TRUE THEN
3779: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);
3780: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3781: END IF;
3782:

Line 3786: IF l_debug = Fnd_Api.G_TRUE THEN

3782:
3783: IF l_context_name = v_pricing_attr_ctxt THEN
3784:
3785: l_found := 1;
3786: IF l_debug = Fnd_Api.G_TRUE THEN
3787: Oe_Debug_Pub.ADD('Found : ' || l_found);
3788:
3789: END IF;
3790: END IF;

Line 3798: IF l_debug = Fnd_Api.G_TRUE THEN

3794: CLOSE l_cond_cursor;
3795:
3796: IF l_found = 0 THEN
3797:
3798: IF l_debug = Fnd_Api.G_TRUE THEN
3799: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);
3800: Oe_Debug_Pub.ADD('Not Found attribute: ' || v_pricing_attr);
3801: END IF;
3802: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3811: IF l_debug = Fnd_Api.G_TRUE THEN

3807: END LOOP;
3808: CLOSE l_pricing_attribs;
3809:
3810: v_count := v_count - 1;
3811: IF l_debug = Fnd_Api.G_TRUE THEN
3812: Oe_Debug_Pub.ADD('Number of Non-sourced attributes : ' || v_count);
3813: END IF;
3814: ELSIF NVL(G_ATTRMGR_INSTALLED,'N') = 'Y' THEN
3815: OPEN l_pricing_attribs;

Line 3822: IF l_debug = Fnd_Api.G_TRUE THEN

3818:
3819: FETCH l_pricing_attribs INTO v_pricing_attr_ctxt, v_pricing_attr;
3820: EXIT WHEN l_pricing_attribs%NOTFOUND;
3821:
3822: IF l_debug = Fnd_Api.G_TRUE THEN
3823: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));
3824: Oe_Debug_Pub.ADD('Pricing Attribute: ' || v_pricing_attr);
3825:
3826: END IF;

Line 3837: IF l_debug = Fnd_Api.G_TRUE THEN

3833: FETCH l_cond_cursor_new INTO l_segment_code, l_segment_mapping_column,
3834: l_context_code,l_context_type;
3835: EXIT WHEN l_cond_cursor_new%NOTFOUND;
3836:
3837: IF l_debug = Fnd_Api.G_TRUE THEN
3838: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_code);
3839: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3840: END IF;
3841:

Line 3845: IF l_debug = Fnd_Api.G_TRUE THEN

3841:
3842: IF l_context_code = v_pricing_attr_ctxt THEN
3843:
3844: l_found := 1;
3845: IF l_debug = Fnd_Api.G_TRUE THEN
3846: Oe_Debug_Pub.ADD('Found : ' || l_found);
3847:
3848: END IF;
3849: END IF;

Line 3856: IF l_debug = Fnd_Api.G_TRUE THEN

3852: CLOSE l_cond_cursor_new;
3853:
3854: IF l_found = 1 THEN
3855:
3856: IF l_debug = Fnd_Api.G_TRUE THEN
3857: Oe_Debug_Pub.ADD('Found user entered context: ' || v_pricing_attr_ctxt);
3858: Oe_Debug_Pub.ADD('Found user entered attribute: ' || v_pricing_attr);
3859: END IF;
3860: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;

Line 3869: IF l_debug = Fnd_Api.G_TRUE THEN

3865: END LOOP;
3866: CLOSE l_pricing_attribs;
3867:
3868: v_count := v_count - 1;
3869: IF l_debug = Fnd_Api.G_TRUE THEN
3870: Oe_Debug_Pub.ADD('Number of Non-sourced attributes : ' || v_count);
3871: END IF;
3872: END IF;
3873:

Line 3936: IF l_debug = Fnd_Api.G_TRUE THEN

3932:
3933: FETCH l_pricing_contexts INTO v_pricing_attr_ctxt;
3934: EXIT WHEN l_pricing_contexts%NOTFOUND;
3935:
3936: IF l_debug = Fnd_Api.G_TRUE THEN
3937: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));
3938:
3939: END IF;
3940: l_found := 0;

Line 3955: IF l_debug = Fnd_Api.G_TRUE THEN

3951: FROM oe_def_condn_elems
3952: WHERE condition_id = l_condition_id
3953: AND attribute_code = 'PRICING_CONTEXT';
3954:
3955: IF l_debug = Fnd_Api.G_TRUE THEN
3956: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);
3957: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);
3958: END IF;
3959:

Line 3962: IF l_debug = Fnd_Api.G_TRUE THEN

3958: END IF;
3959:
3960: IF (l_context_name = v_pricing_attr_ctxt) THEN
3961: l_found := 1;
3962: IF l_debug = Fnd_Api.G_TRUE THEN
3963: Oe_Debug_Pub.ADD('Found : ' || l_found);
3964: END IF;
3965: END IF;
3966:

Line 3971: IF l_debug = Fnd_Api.G_TRUE THEN

3967: END LOOP;
3968: CLOSE l_sourced_contexts;
3969:
3970: IF l_found = 0 THEN
3971: IF l_debug = Fnd_Api.G_TRUE THEN
3972: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);
3973: END IF;
3974: p_user_attribs_tbl(v_count).context_name := v_pricing_attr_ctxt;
3975: v_count := v_count + 1;

Line 3981: IF l_debug = Fnd_Api.G_TRUE THEN

3977: END LOOP;
3978: CLOSE l_pricing_contexts;
3979:
3980: v_count := v_count - 1;
3981: IF l_debug = Fnd_Api.G_TRUE THEN
3982: Oe_Debug_Pub.ADD('Number of Non-sourced contexts : ' || v_count);
3983: END IF;
3984: ELSIF NVL(G_ATTRMGR_INSTALLED,'N') = 'Y' THEN
3985: OPEN l_non_sourced_contexts;

Line 3991: IF l_debug = Fnd_Api.G_TRUE THEN

3987: LOOP
3988:
3989: FETCH l_non_sourced_contexts INTO l_context_code, l_context_type;
3990: EXIT WHEN l_non_sourced_contexts%NOTFOUND;
3991: IF l_debug = Fnd_Api.G_TRUE THEN
3992: Oe_Debug_Pub.ADD('User Entered Context: ' || l_context_code);
3993: END IF;
3994: p_user_attribs_tbl(v_count).context_name := l_context_code;
3995: v_count := v_count + 1;

Line 4000: IF l_debug = Fnd_Api.G_TRUE THEN

3996: END LOOP;
3997: CLOSE l_non_sourced_contexts;
3998:
3999: v_count := v_count - 1;
4000: IF l_debug = Fnd_Api.G_TRUE THEN
4001: Oe_Debug_Pub.ADD('Number of Non-sourced contexts : ' || v_count);
4002: END IF;
4003: END IF;
4004:

Line 4062: IF l_debug = Fnd_Api.G_TRUE THEN

4058: -- start of 10120089
4059: IF (l_QP_CUSTOM_HOOK4_ADV_MOD='Y') THEN -- for profile on
4060: QP_ADV_MOD_CUSTOM_HOOK.check_line(l_request_type_code, l_pass_line);
4061: G_PASS_THIS_LINE:= l_pass_line;
4062: IF l_debug = Fnd_Api.G_TRUE THEN
4063: Oe_Debug_Pub.ADD('Check_line_group_items custom hook on'
4064: ||'Pass Line: '||G_PASS_THIS_LINE);
4065: END IF;
4066: END IF;

Line 4082: IF l_debug = Fnd_Api.G_TRUE THEN

4078: WHEN NO_DATA_FOUND THEN
4079: l_all_items_exist := 'N';
4080: WHEN OTHERS THEN
4081: l_all_items_exist := 'N';
4082: IF l_debug = Fnd_Api.G_TRUE THEN
4083: Oe_Debug_Pub.ADD('In exception l_all_items_exist:'||SQLERRM);
4084: END IF;
4085: END;
4086:

Line 4087: IF l_debug = Fnd_Api.G_TRUE THEN

4083: Oe_Debug_Pub.ADD('In exception l_all_items_exist:'||SQLERRM);
4084: END IF;
4085: END;
4086:
4087: IF l_debug = Fnd_Api.G_TRUE THEN
4088: Oe_Debug_Pub.ADD('In check_line_group_items l_all_items_exist '
4089: ||l_all_items_exist);
4090: Oe_Debug_Pub.ADD('In check_line_group_items G_Product_Attr_tbl.COUNT '
4091: ||G_Product_Attr_tbl.COUNT);

Line 4106: IF l_debug = Fnd_Api.G_TRUE THEN

4102: G_PASS_THIS_LINE := 'N';
4103: ELSE
4104: FOR i IN G_Product_Attr_tbl.FIRST..G_Product_Attr_tbl.LAST
4105: LOOP
4106: IF l_debug = Fnd_Api.G_TRUE THEN
4107: Oe_Debug_Pub.ADD('Looping thru prod attr '
4108: ||'attribute '||G_Product_Attr_tbl(i).attribute_name
4109: ||' value '||G_Product_Attr_tbl(i).attribute_value);
4110: END IF;

Line 4125: IF l_debug = Fnd_Api.G_TRUE THEN

4121: EXCEPTION
4122: WHEN NO_DATA_FOUND THEN
4123: NULL;
4124: WHEN OTHERS THEN
4125: IF l_debug = Fnd_Api.G_TRUE THEN
4126: Oe_Debug_Pub.ADD('In exception G_PASS_THIS_LINE:'
4127: ||SQLERRM);
4128: END IF;
4129: END;

Line 4130: IF l_debug = Fnd_Api.G_TRUE THEN

4126: Oe_Debug_Pub.ADD('In exception G_PASS_THIS_LINE:'
4127: ||SQLERRM);
4128: END IF;
4129: END;
4130: IF l_debug = Fnd_Api.G_TRUE THEN
4131: Oe_Debug_Pub.ADD('In check_line_group_items loop '
4132: ||l_prod_exists);
4133: END IF;
4134: IF l_prod_exists = 'Y'

Line 4142: IF l_debug = Fnd_Api.G_TRUE THEN

4138: END LOOP;
4139: IF l_prod_exists = 'Y'
4140: THEN
4141: G_PASS_THIS_LINE := 'Y';
4142: IF l_debug = Fnd_Api.G_TRUE THEN
4143: Oe_Debug_Pub.ADD('Check_line_group_items '
4144: ||G_PASS_THIS_LINE);
4145: END IF;
4146: ELSE

Line 4148: IF l_debug = Fnd_Api.G_TRUE THEN

4144: ||G_PASS_THIS_LINE);
4145: END IF;
4146: ELSE
4147: G_PASS_THIS_LINE := 'N';
4148: IF l_debug = Fnd_Api.G_TRUE THEN
4149: Oe_Debug_Pub.ADD('Check_line_group_items '
4150: ||G_PASS_THIS_LINE);
4151: END IF;
4152: END IF;

Line 4155: IF l_debug = Fnd_Api.G_TRUE THEN

4151: END IF;
4152: END IF;
4153:
4154: END IF;
4155: IF l_debug = Fnd_Api.G_TRUE THEN
4156: Oe_Debug_Pub.ADD('Check_line_group_items '
4157: ||'Pass Line: '||G_PASS_THIS_LINE);
4158: END IF;
4159: END IF; -- 10120089

Line 4162: IF l_debug = Fnd_Api.G_TRUE THEN

4158: END IF;
4159: END IF; -- 10120089
4160: EXCEPTION
4161: WHEN OTHERS THEN
4162: IF l_debug = Fnd_Api.G_TRUE THEN
4163: Oe_Debug_Pub.ADD('Error in QP_ATTR_MAPPING_PUB.Check_line_group_items '||SQLERRM);
4164: END IF;
4165: G_PASS_THIS_LINE := 'Y';
4166: END Check_line_group_items;

Line 4185: IF l_debug = Fnd_Api.G_TRUE THEN

4181: --delete all to start with
4182: G_PRODUCT_ATTR_TBL.DELETE;
4183: G_CHECK_LINE_FLAG := p_check_line_flag;
4184: G_PRICING_EVENT := p_pricing_event||',';
4185: IF l_debug = Fnd_Api.G_TRUE THEN
4186: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);
4187: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
4188: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type);
4189: END IF;

Line 4203: IF l_debug = Fnd_Api.G_TRUE THEN

4199:
4200: IF x_price_contexts_result_tbl.COUNT > 0 THEN
4201: FOR i IN x_price_contexts_result_tbl.FIRST..x_price_contexts_result_tbl.LAST
4202: LOOP
4203: IF l_debug = Fnd_Api.G_TRUE THEN
4204: 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);
4205: END IF;
4206: END LOOP;
4207: END IF;

Line 4212: IF l_debug = Fnd_Api.G_TRUE THEN

4208:
4209:
4210: --Indicates to caller that they need to pass this line
4211: x_pass_line := G_PASS_THIS_LINE;
4212: IF l_debug = Fnd_Api.G_TRUE THEN
4213: Oe_Debug_Pub.ADD('Build_contexts pass this line '||x_pass_line);
4214:
4215: END IF;
4216: EXCEPTION

Line 4218: IF l_debug = Fnd_Api.G_TRUE THEN

4214:
4215: END IF;
4216: EXCEPTION
4217: WHEN OTHERS THEN
4218: IF l_debug = Fnd_Api.G_TRUE THEN
4219: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
4220: END IF;
4221: END Build_Contexts;
4222:

Line 4241: IF l_debug = Fnd_Api.G_TRUE THEN

4237: IS
4238: BEGIN
4239: G_CHECK_LINE_FLAG := p_check_line_flag;
4240: G_PRICING_EVENT := p_pricing_event||',';
4241: IF l_debug = Fnd_Api.G_TRUE THEN
4242: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);
4243: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
4244: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type_code);
4245:

Line 4258: IF l_debug = Fnd_Api.G_TRUE THEN

4254: p_org_id => p_org_id
4255: );
4256: --Indicates to caller that they need to pass this line
4257: x_pass_line := G_PASS_THIS_LINE;
4258: IF l_debug = Fnd_Api.G_TRUE THEN
4259: Oe_Debug_Pub.ADD('Build_contexts pass this line '||x_pass_line);
4260:
4261: END IF;
4262: EXCEPTION

Line 4264: IF l_debug = Fnd_Api.G_TRUE THEN

4260:
4261: END IF;
4262: EXCEPTION
4263: WHEN OTHERS THEN
4264: IF l_debug = Fnd_Api.G_TRUE THEN
4265: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
4266: END IF;
4267: END Build_Contexts;
4268:

Line 4292: IF x_return = Fnd_Api.G_MISS_NUM THEN

4288: x_return := Qp_Attr_Mapping_Pub.G_Temp_Value;
4289:
4290: --dbms_output.put_line('Return Value:' || x_return);
4291:
4292: IF x_return = Fnd_Api.G_MISS_NUM THEN
4293: RETURN NULL;
4294: ELSE
4295: RETURN x_return;
4296: END IF;

Line 4300: IF x_return = Fnd_Api.G_MISS_CHAR THEN

4296: END IF;
4297:
4298: EXCEPTION
4299: WHEN VALUE_ERROR THEN
4300: IF x_return = Fnd_Api.G_MISS_CHAR THEN
4301: RETURN NULL;
4302: ELSE
4303: RETURN x_return;
4304: END IF;

Line 4504: IF l_debug = Fnd_Api.G_TRUE THEN

4500: EXIT WHEN l_ctxts_new%NOTFOUND;
4501:
4502: g_dynamic_mapping_count := g_dynamic_mapping_count + 1; -- 7323926
4503:
4504: IF l_debug = Fnd_Api.G_TRUE THEN
4505: Oe_Debug_Pub.ADD('Context = ' || l_context_name);
4506: Oe_Debug_Pub.ADD('Attribute = ' || l_attribute_name);
4507:
4508: END IF;

Line 4514: IF l_debug = Fnd_Api.G_TRUE THEN

4510:
4511: IF l_src_type = 'API' THEN
4512: --dbms_output.put_line('Before Calling Get_API_Value');
4513: l_attribute_value := Get_API_Value(l_value_string, l_successful);
4514: IF l_debug = Fnd_Api.G_TRUE THEN
4515: Oe_Debug_Pub.ADD('Attr Name = '|| l_value_string);
4516: Oe_Debug_Pub.ADD('Attr Value = '|| l_attribute_value);
4517:
4518: END IF;

Line 4522: IF l_debug = Fnd_Api.G_TRUE THEN

4518: END IF;
4519: ELSIF l_src_type = 'API_MULTIREC' THEN
4520: --dbms_output.put_line('Before Calling Get_MULTIREC_API_Value');
4521: l_attribute_mvalue := Get_API_MultiValue(l_value_string, l_successful);
4522: IF l_debug = Fnd_Api.G_TRUE THEN
4523: Oe_Debug_Pub.ADD('Multirec API = '|| l_value_string);
4524:
4525: END IF;
4526: ELSIF l_src_type = 'PROFILE_OPTION' THEN

Line 4529: IF l_debug = Fnd_Api.G_TRUE THEN

4525: END IF;
4526: ELSIF l_src_type = 'PROFILE_OPTION' THEN
4527: --dbms_output.put_line('Before Calling Get_Profile_Option_Value');
4528: l_attribute_value := Get_Profile_Option_Value(l_value_string, l_successful);
4529: IF l_debug = Fnd_Api.G_TRUE THEN
4530: Oe_Debug_Pub.ADD('Profile = '|| l_value_string);
4531: Oe_Debug_Pub.ADD('Profile Value = '|| l_attribute_value);
4532:
4533: END IF;

Line 4537: IF l_debug = Fnd_Api.G_TRUE THEN

4533: END IF;
4534: ELSIF l_src_type = 'SYSTEM' THEN
4535: --dbms_output.put_line('Before Calling Get_System_Variable');
4536: l_attribute_value := Get_System_Variable(l_value_string, l_successful);
4537: IF l_debug = Fnd_Api.G_TRUE THEN
4538: Oe_Debug_Pub.ADD('System Variable = ' || l_value_string);
4539: Oe_Debug_Pub.ADD('System Variable Value = ' || l_attribute_value);
4540:
4541: END IF;

Line 4544: IF l_debug = Fnd_Api.G_TRUE THEN

4540:
4541: END IF;
4542: ELSIF l_src_type = 'CONSTANT' THEN
4543: l_attribute_value := l_value_string;
4544: IF l_debug = Fnd_Api.G_TRUE THEN
4545: Oe_Debug_Pub.ADD('Constant = ' || l_value_string);
4546:
4547: END IF;
4548: ELSE

Line 4549: IF l_debug = Fnd_Api.G_TRUE THEN

4545: Oe_Debug_Pub.ADD('Constant = ' || l_value_string);
4546:
4547: END IF;
4548: ELSE
4549: IF l_debug = Fnd_Api.G_TRUE THEN
4550: Oe_Debug_Pub.ADD('Invalid source type');
4551:
4552: END IF;
4553: END IF;

Line 4563: IF l_debug = Fnd_Api.G_TRUE THEN

4559: l_qual_count := l_qual_count + 1;
4560:
4561: Add_to_Contexts_Results_Table(x_qual_contexts_result_tbl, l_qual_count, l_context_name, l_attribute_name, l_attribute_value);
4562:
4563: IF l_debug = Fnd_Api.G_TRUE THEN
4564: Oe_Debug_Pub.ADD('Context(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).context_name);
4565: Oe_Debug_Pub.ADD('SRC Type(' || l_qual_count || '): ' || l_src_type);
4566: Oe_Debug_Pub.ADD('SRC Value(' || l_qual_count || '): ' || l_attribute_value);
4567: Oe_Debug_Pub.ADD('Attribute Name(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_name);

Line 4578: IF l_debug = Fnd_Api.G_TRUE THEN

4574: l_price_count := l_price_count + 1;
4575:
4576: Add_to_Contexts_Results_Table(x_price_contexts_result_tbl, l_price_count, l_context_name, l_attribute_name, l_attribute_value);
4577:
4578: IF l_debug = Fnd_Api.G_TRUE THEN
4579: Oe_Debug_Pub.ADD('Context(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).context_name);
4580: Oe_Debug_Pub.ADD('SRC Type(' || l_price_count || '): ' || l_src_type);
4581: Oe_Debug_Pub.ADD('SRC Value(' || l_price_count || '): ' || l_attribute_value);
4582: Oe_Debug_Pub.ADD('Attribute Name(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_name);

Line 4588: IF l_debug = Fnd_Api.G_TRUE THEN

4584: Oe_Debug_Pub.ADD('------------------------------');
4585:
4586: END IF;
4587: ELSE
4588: IF l_debug = Fnd_Api.G_TRUE THEN
4589: Oe_Debug_Pub.ADD('Context type invalid');
4590:
4591: END IF;
4592: END IF;

Line 4596: IF l_debug = Fnd_Api.G_TRUE THEN

4592: END IF;
4593:
4594: ELSIF (l_attribute_mvalue IS NOT NULL) AND (l_src_type = 'API_MULTIREC') THEN
4595:
4596: IF l_debug = Fnd_Api.G_TRUE THEN
4597: Oe_Debug_Pub.ADD('Found a MULTIREC for context type: ' || l_context_type);
4598:
4599: END IF;
4600:

Line 4614: IF l_debug = Fnd_Api.G_TRUE THEN

4610: l_qual_count := l_qual_count + 1;
4611:
4612: Add_to_Contexts_Results_Table(x_qual_contexts_result_tbl,l_qual_count,l_context_name,l_attribute_name,l_attribute_mvalue(l_index));
4613:
4614: IF l_debug = Fnd_Api.G_TRUE THEN
4615: Oe_Debug_Pub.ADD('Context(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).context_name);
4616: Oe_Debug_Pub.ADD('SRC Type(' || l_qual_count || '): ' || l_src_type);
4617: Oe_Debug_Pub.ADD('SRC Value(' || l_qual_count || '): ' || l_attribute_value);
4618: Oe_Debug_Pub.ADD('Attribute Name(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_name);

Line 4629: IF l_debug = Fnd_Api.G_TRUE THEN

4625: l_price_count := l_price_count + 1;
4626:
4627: Add_to_Contexts_Results_Table(x_price_contexts_result_tbl,l_price_count,l_context_name,l_attribute_name,l_attribute_mvalue(l_index));
4628:
4629: IF l_debug = Fnd_Api.G_TRUE THEN
4630: Oe_Debug_Pub.ADD('Context(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).context_name);
4631: Oe_Debug_Pub.ADD('SRC Type(' || l_price_count || '): ' || l_src_type);
4632: Oe_Debug_Pub.ADD('SRC Value(' || l_price_count || '): ' || l_attribute_value);
4633: Oe_Debug_Pub.ADD('Attribute Name(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_name);

Line 4639: IF l_debug = Fnd_Api.G_TRUE THEN

4635: Oe_Debug_Pub.ADD('------------------------------');
4636:
4637: END IF;
4638: ELSE
4639: IF l_debug = Fnd_Api.G_TRUE THEN
4640: Oe_Debug_Pub.ADD('Context type invalid');
4641:
4642: END IF;
4643: END IF;

Line 4652: IF l_debug = Fnd_Api.G_TRUE THEN

4648:
4649: END IF;
4650:
4651: ELSE
4652: IF l_debug = Fnd_Api.G_TRUE THEN
4653: Oe_Debug_Pub.ADD('No value was obtained in the mapping process of source type ' || l_src_type);
4654:
4655: END IF;
4656: END IF;

Line 4801: IF l_debug = Fnd_Api.G_TRUE THEN

4797: ELSIF l_src_type = 'CONSTANT' THEN
4798: l_attribute_value := l_value_string;
4799:
4800: ELSE
4801: IF l_debug = Fnd_Api.G_TRUE THEN
4802: Oe_Debug_Pub.ADD('Invalid source type');
4803:
4804: END IF;
4805: END IF;