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 OE_DEBUG_PUB

Line 161: -- oe_debug_pub.add(' ');

157: BEGIN
158:
159: line_number := line_number + 1;
160: ad_ddl.build_package(' ',line_number);
161: -- oe_debug_pub.add(' ');
162:
163: END New_Line;
164:
165: PROCEDURE COMMENT

Line 268: -- oe_debug_pub.add(LPAD(p_string,p_level*2+LENGTH(p_string)));

264:
265: line_number := line_number + 1;
266: --dbms_output.put_line(LPAD(p_string,p_level*2+LENGTH(p_string)));
267: ad_ddl.build_package(LPAD(p_string,p_level*2+LENGTH(p_string)),line_number);
268: -- oe_debug_pub.add(LPAD(p_string,p_level*2+LENGTH(p_string)));
269:
270: END text;
271:
272: PROCEDURE Pkg_End

Line 306: Oe_Debug_Pub.ADD('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);

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;
310: ad_ddl.create_package(applsys_schema => g_schema

Line 325: Oe_Debug_Pub.ADD('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);

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));
329: --dbms_output.put_line( 'LINE :'||error.line||' '||substr(error.text,1,200));

Line 331: Oe_Debug_Pub.ADD('LINE :'||error.line||' '||SUBSTR(error.text,1,200));

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;
335:

Line 355: Oe_Debug_Pub.ADD('PACKAGE '||p_pkg_type||' Name to :'

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;
359: PUT_LINE('Now create PACKAGE '||p_pkg_type||' : '

Line 363: Oe_Debug_Pub.ADD('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);

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
367: THEN

Line 376: Oe_Debug_Pub.ADD('First change : ' ||ad_ddl.glprogtext(1));

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) :=
380: REPLACE(ad_ddl.glprogtext(line_number)

Line 387: Oe_Debug_Pub.ADD('Second change : ' ||' '||ad_ddl.glprogtext(line_number));

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
391: ||' :'||l_new_pkg_name);

Line 394: Oe_Debug_Pub.ADD('Trying to create PACKAGE '||p_pkg_type

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;
398: ad_ddl.create_package(applsys_schema => g_schema

Line 416: Oe_Debug_Pub.ADD('ERROR in creating PACKAGE '

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;
420: END IF;

Line 425: Oe_Debug_Pub.ADD('LINE :'||error.line||' '

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;
429: END LOOP;

Line 441: Oe_Debug_Pub.ADD('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:
445: v_count := 1;

Line 718: --oe_debug_pub.add('Attribute = ' || l_attribute_name);

714: l_context_name,
715: l_context_type;
716: EXIT WHEN l_ctxts%NOTFOUND;
717:
718: --oe_debug_pub.add('Attribute = ' || l_attribute_name);
719:
720: --dbms_output.put_line ('#1');
721: v_is_used := 'N';
722:

Line 943: --oe_debug_pub.add('Enable Flag = ' || v_is_used);

939: END;
940: END;
941: END IF;
942: END IF;
943: --oe_debug_pub.add('Enable Flag = ' || v_is_used);
944:
945: --dbms_output.put_line ('#2');
946: IF v_is_used = 'Y' THEN
947:

Line 1203: Text('oe_debug_pub.add(''Multirec API error'');',5);

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;
1207: Text('IF (v_attr_mvalue.count <> 0) AND (v_attr_mvalue(1) IS NOT NULL) THEN',2);

Line 1597: --oe_debug_pub.add('Enable Flag = ' || v_is_used);

1593: END;
1594: END; --bug 7494395
1595: END IF;
1596: END IF;
1597: --oe_debug_pub.add('Enable Flag = ' || v_is_used);
1598: --dbms_output.put_line('Enable Flag = ' || v_is_used);
1599: IF v_is_used = 'Y' THEN
1600: segment_ctr := segment_ctr + 1;
1601: G_New_Sourced_Contexts_Tbl(v_count).attribute_name := l_attribute_name;

Line 1614: --oe_debug_pub.add('Sourced contexts = ' || G_New_Sourced_Contexts_Tbl.COUNT);

1610: END IF;
1611:
1612: END LOOP;
1613:
1614: --oe_debug_pub.add('Sourced contexts = ' || G_New_Sourced_Contexts_Tbl.COUNT);
1615:
1616: CLOSE l_ctxts_new;
1617:
1618:

Line 1632: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');

1628: IF p_pricing_type = 'L' THEN
1629: Text('FOR i in QP_BULK_PREQ_GRP.G_LINE_REC.line_id.first..QP_BULK_PREQ_GRP.G_LINE_REC.line_id.last');
1630: --dbms_output.put_line('FOR i in QP_BULK_PREQ_GRP.G_LINE_REC.line_id.first..QP_BULK_PREQ_GRP.G_LINE_REC.line_id.last');
1631: Text('Loop');
1632: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1633: Text ('--oe_debug_pub.add (''this_header_id: ''|| nvl(QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i),0));');
1634: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2
1635: );
1636: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);

Line 1633: Text ('--oe_debug_pub.add (''this_header_id: ''|| nvl(QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i),0));');

1629: Text('FOR i in QP_BULK_PREQ_GRP.G_LINE_REC.line_id.first..QP_BULK_PREQ_GRP.G_LINE_REC.line_id.last');
1630: --dbms_output.put_line('FOR i in QP_BULK_PREQ_GRP.G_LINE_REC.line_id.first..QP_BULK_PREQ_GRP.G_LINE_REC.line_id.last');
1631: Text('Loop');
1632: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1633: Text ('--oe_debug_pub.add (''this_header_id: ''|| nvl(QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i),0));');
1634: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2
1635: );
1636: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1637: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);

Line 1645: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');

1641: Text ('End If;', 3);
1642: Text ('Else', 2);
1643: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1644: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1645: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1646: Text ('End If;', 3);
1647: Text ('End If;' , 2);
1648: ELSE
1649: Text('FOR i in QP_BULK_PREQ_GRP.G_HEADER_REC.header_id.first..QP_BULK_PREQ_GRP.G_HEADER_REC.header_id.last');

Line 1676: text('oe_debug_pub.add(''In check to call line_group'');',3);

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);
1680: Text('IF l_debug = FND_API.G_TRUE THEN',3);

Line 1681: text('oe_debug_pub.add(''Before call line_group'');',4);

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);
1685: text('oe_debug_pub.add(''After call line_group'');',4);

Line 1685: text('oe_debug_pub.add(''After call line_group'');',4);

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);
1689: Text('IF l_debug = FND_API.G_TRUE THEN',4);

Line 1690: Text('oe_debug_pub.add(''Error in Check_line_group_items'');',5);

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);
1694: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);

Line 1698: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);

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);
1702: Text('END IF;--QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE',2);

Line 1860: text('oe_debug_pub.add(''Gathering product details'');',5);

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);
1864: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '

Line 1869: Text('oe_debug_pub.add(''No product sourced '');',6);

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'
1873: Text('IF l_debug = FND_API.G_TRUE THEN',4);

Line 1874: text('oe_debug_pub.add(''After product assigned'');',5);

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);
1878:

Line 1905: Text('oe_debug_pub.add(''Multirec API error'');',5);

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;
1909: Text('IF (v_attr_mvalue.count <> 0) AND (v_attr_mvalue(1) IS NOT NULL) THEN',2);

Line 1978: text('oe_debug_pub.add(''Gathering product details'');',5);

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);
1982: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '

Line 1987: Text('oe_debug_pub.add(''No product sourced '');',6);

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'
1991: Text('IF l_debug = FND_API.G_TRUE THEN',4);

Line 1992: text('oe_debug_pub.add(''After product assigned'');',5);

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:
1996:

Line 2044: Oe_Debug_Pub.ADD('##### Begin Build Sourcing #####');

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);
2048: --dbms_output.put_line('............11............');

Line 2086: text('oe_debug_pub.add(''hw/src/H: change to g_yes'');',2);

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;
2090:

Line 2131: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',3);

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;');
2135: Text('qp_debug_util.tstop(''FETCH_ATTRIBUTES'');',0);

Line 2182: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',4);

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);
2186:

Line 2233: Oe_Debug_Pub.ADD('##### End Build Sourcing #####');

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
2237:

Line 2309: Oe_Debug_Pub.ADD('##### Begin Build Contexts #####');

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;
2313:

Line 2432: Oe_Debug_Pub.ADD('Context Name: ' || x_qual_contexts_result_tbl(v_count).context_name);

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:
2436: END IF;

Line 2433: Oe_Debug_Pub.ADD('Attribute Name: ' || x_qual_contexts_result_tbl(v_count).attribute_name);

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:
2436: END IF;
2437: END LOOP;

Line 2434: Oe_Debug_Pub.ADD('Attribute Value: ' || x_qual_contexts_result_tbl(v_count).attribute_value);

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:
2436: END IF;
2437: END LOOP;
2438:

Line 2447: Oe_Debug_Pub.ADD('Context Name: ' || x_price_contexts_result_tbl(v_count).context_name);

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:
2451: END IF;

Line 2448: Oe_Debug_Pub.ADD('Attribute Name: ' || x_price_contexts_result_tbl(v_count).attribute_name);

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:
2451: END IF;
2452: END LOOP;

Line 2449: Oe_Debug_Pub.ADD('Attribute Value: ' || x_price_contexts_result_tbl(v_count).attribute_value);

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:
2451: END IF;
2452: END LOOP;
2453:

Line 2455: Oe_Debug_Pub.ADD('##### End Build Contexts #####');

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
2459: l_sourcing_end_time := dbms_utility.get_time;

Line 2463: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');

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;
2467: END Build_Contexts;

Line 3241: Oe_Debug_Pub.ADD('##### Total Time in Build_Contexts(in sec) : ' || l_time_difference || ' #####');

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
3245: WHEN OTHERS THEN

Line 3324: Oe_Debug_Pub.ADD('Item Context: ' || v_pricing_attr_ctxt);

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;
3328: l_found := 0;

Line 3325: Oe_Debug_Pub.ADD('Item Attribute: ' || 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;
3328: l_found := 0;
3329:

Line 3344: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);

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:
3348: IF l_context_name = v_pricing_attr_ctxt THEN

Line 3345: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);

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:
3348: IF l_context_name = v_pricing_attr_ctxt THEN
3349:

Line 3352: Oe_Debug_Pub.ADD('Found : ' || l_found);

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;
3356:

Line 3364: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);

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;
3368: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;

Line 3365: Oe_Debug_Pub.ADD('Not Found attribute: ' || v_pricing_attr);

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;
3368: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;
3369: v_count := v_count + 1;

Line 3385: Oe_Debug_Pub.ADD('Item Context: ' || v_pricing_attr_ctxt);

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;
3389: l_found := 0;

Line 3386: Oe_Debug_Pub.ADD('Item Attribute: ' || 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;
3389: l_found := 0;
3390:

Line 3400: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_code);

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:
3404: IF l_context_code = v_pricing_attr_ctxt THEN

Line 3401: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);

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:
3404: IF l_context_code = v_pricing_attr_ctxt THEN
3405:

Line 3408: Oe_Debug_Pub.ADD('Found : ' || l_found);

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;
3412:

Line 3419: Oe_Debug_Pub.ADD('Found User Entered context: ' || v_pricing_attr_ctxt);

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;
3423: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;

Line 3420: Oe_Debug_Pub.ADD('Found User Entered attribute: ' || v_pricing_attr);

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;
3423: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;
3424: v_count := v_count + 1;

Line 3501: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));

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;
3505: l_found := 0;

Line 3502: Oe_Debug_Pub.ADD('Pricing Attribute: ' || 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;
3505: l_found := 0;
3506:

Line 3521: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);

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:
3525: IF l_context_name = v_pricing_attr_ctxt THEN

Line 3522: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);

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:
3525: IF l_context_name = v_pricing_attr_ctxt THEN
3526:

Line 3529: Oe_Debug_Pub.ADD('Found : ' || l_found);

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;
3533:

Line 3541: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);

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;
3545: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;

Line 3542: Oe_Debug_Pub.ADD('Not Found attribute: ' || v_pricing_attr);

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;
3545: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;
3546: v_count := v_count + 1;

Line 3554: Oe_Debug_Pub.ADD('Number of Non-sourced attributes : ' || v_count);

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;
3558:

Line 3565: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));

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;
3569: l_found := 0;

Line 3566: Oe_Debug_Pub.ADD('Pricing Attribute: ' || 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;
3569: l_found := 0;
3570:

Line 3580: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_code);

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:
3584: IF l_context_code = v_pricing_attr_ctxt THEN

Line 3581: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);

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:
3584: IF l_context_code = v_pricing_attr_ctxt THEN
3585:

Line 3588: Oe_Debug_Pub.ADD('Found : ' || l_found);

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;
3592:

Line 3599: Oe_Debug_Pub.ADD('Found user entered context: ' || v_pricing_attr_ctxt);

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;
3603: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;

Line 3600: Oe_Debug_Pub.ADD('Found user entered attribute: ' || v_pricing_attr);

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;
3603: p_user_attribs_tbl(v_count).attribute_name := v_pricing_attr;
3604: v_count := v_count + 1;

Line 3612: Oe_Debug_Pub.ADD('Number of Non-sourced attributes : ' || v_count);

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:
3616: END Get_User_Item_Pricing_Attribs;

Line 3679: Oe_Debug_Pub.ADD('Pricing Context: ' || NVL(v_pricing_attr_ctxt,'Jeff'));

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;
3683:

Line 3698: Oe_Debug_Pub.ADD('Sourced Context: ' || l_context_name);

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:
3702: IF (l_context_name = v_pricing_attr_ctxt) THEN

Line 3699: Oe_Debug_Pub.ADD('Compared Context: ' || v_pricing_attr_ctxt);

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:
3702: IF (l_context_name = v_pricing_attr_ctxt) THEN
3703: l_found := 1;

Line 3705: Oe_Debug_Pub.ADD('Found : ' || l_found);

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:
3709: END LOOP;

Line 3714: Oe_Debug_Pub.ADD('Not Found context: ' || v_pricing_attr_ctxt);

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;
3718: END IF;

Line 3724: Oe_Debug_Pub.ADD('Number of Non-sourced contexts : ' || v_count);

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;
3728:

Line 3734: Oe_Debug_Pub.ADD('User Entered Context: ' || l_context_code);

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;
3738: END LOOP;

Line 3743: Oe_Debug_Pub.ADD('Number of Non-sourced contexts : ' || v_count);

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:
3747:

Line 3811: Oe_Debug_Pub.ADD('In exception l_all_items_exist:'||SQLERRM);

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

Line 3816: Oe_Debug_Pub.ADD('In check_line_group_items l_all_items_exist '

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);
3820: Oe_Debug_Pub.ADD('In check_line_group_items p_pricing_type_code '

Line 3818: Oe_Debug_Pub.ADD('In check_line_group_items G_Product_Attr_tbl.COUNT '

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);
3820: Oe_Debug_Pub.ADD('In check_line_group_items p_pricing_type_code '
3821: ||p_pricing_type_code||' G_CHECK_LINE_FLAG '||G_CHECK_LINE_FLAG);
3822: END IF;

Line 3820: Oe_Debug_Pub.ADD('In check_line_group_items p_pricing_type_code '

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);
3820: Oe_Debug_Pub.ADD('In check_line_group_items p_pricing_type_code '
3821: ||p_pricing_type_code||' G_CHECK_LINE_FLAG '||G_CHECK_LINE_FLAG);
3822: END IF;
3823: IF G_CHECK_LINE_FLAG = 'N'
3824: OR p_pricing_type_code = 'H'

Line 3835: Oe_Debug_Pub.ADD('Looping thru prod attr '

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;
3839: BEGIN

Line 3854: Oe_Debug_Pub.ADD('In exception G_PASS_THIS_LINE:'

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

Line 3859: Oe_Debug_Pub.ADD('In check_line_group_items loop '

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'
3863: THEN

Line 3871: Oe_Debug_Pub.ADD('Check_line_group_items '

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
3875: G_PASS_THIS_LINE := 'N';

Line 3877: Oe_Debug_Pub.ADD('Check_line_group_items '

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;
3881:

Line 3884: Oe_Debug_Pub.ADD('Check_line_group_items '

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
3888: WHEN OTHERS THEN

Line 3890: Oe_Debug_Pub.ADD('Error in QP_ATTR_MAPPING_PUB.Check_line_group_items '||SQLERRM);

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;
3894:

Line 3913: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);

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;
3917: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

Line 3914: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);

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;
3917: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
3918: Build_Contexts

Line 3915: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type);

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;
3917: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
3918: Build_Contexts
3919: ( p_request_type_code => p_request_type_code

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

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;
3935:

Line 3940: Oe_Debug_Pub.ADD('Build_contexts pass this line '||x_pass_line);

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
3944: WHEN OTHERS THEN

Line 3946: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);

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:
3950: /*Fix for bug 2491269

Line 3969: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);

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:
3973: END IF;

Line 3970: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);

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:
3973: END IF;
3974: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

Line 3971: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type_code);

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:
3973: END IF;
3974: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
3975: Build_Contexts

Line 3986: Oe_Debug_Pub.ADD('Build_contexts pass this line '||x_pass_line);

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
3990: WHEN OTHERS THEN

Line 3992: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);

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:
3996:

Line 4144: -- oe_debug_pub.add('Context(' || p_index || '): ' || p_results_tbl(p_index).context_name);

4140:
4141: BEGIN
4142:
4143: p_results_tbl(p_index).context_name := p_context_name;
4144: -- oe_debug_pub.add('Context(' || p_index || '): ' || p_results_tbl(p_index).context_name);
4145:
4146: p_results_tbl(p_index).attribute_name := p_attribute_name;
4147: -- oe_debug_pub.add('Attribute Name(' || p_index || '): ' || p_results_tbl(p_index).attribute_name);
4148:

Line 4147: -- oe_debug_pub.add('Attribute Name(' || p_index || '): ' || p_results_tbl(p_index).attribute_name);

4143: p_results_tbl(p_index).context_name := p_context_name;
4144: -- oe_debug_pub.add('Context(' || p_index || '): ' || p_results_tbl(p_index).context_name);
4145:
4146: p_results_tbl(p_index).attribute_name := p_attribute_name;
4147: -- oe_debug_pub.add('Attribute Name(' || p_index || '): ' || p_results_tbl(p_index).attribute_name);
4148:
4149: p_results_tbl(p_index).attribute_value := p_attribute_value;
4150: -- oe_debug_pub.add('Attribute Value(' || p_index || '): ' || p_results_tbl(p_index).attribute_value);
4151:

Line 4150: -- oe_debug_pub.add('Attribute Value(' || p_index || '): ' || p_results_tbl(p_index).attribute_value);

4146: p_results_tbl(p_index).attribute_name := p_attribute_name;
4147: -- oe_debug_pub.add('Attribute Name(' || p_index || '): ' || p_results_tbl(p_index).attribute_name);
4148:
4149: p_results_tbl(p_index).attribute_value := p_attribute_value;
4150: -- oe_debug_pub.add('Attribute Value(' || p_index || '): ' || p_results_tbl(p_index).attribute_value);
4151:
4152: END Add_to_Contexts_Results_Table;
4153:
4154: PROCEDURE Map_Used_But_Not_Mapped_Attrs

Line 4232: Oe_Debug_Pub.ADD('Context = ' || l_context_name);

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;
4236: l_successful := TRUE;

Line 4233: Oe_Debug_Pub.ADD('Attribute = ' || l_attribute_name);

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;
4236: l_successful := TRUE;
4237:

Line 4242: Oe_Debug_Pub.ADD('Attr Name = '|| l_value_string);

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;
4246: ELSIF l_src_type = 'API_MULTIREC' THEN

Line 4243: Oe_Debug_Pub.ADD('Attr Value = '|| l_attribute_value);

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;
4246: ELSIF l_src_type = 'API_MULTIREC' THEN
4247: --dbms_output.put_line('Before Calling Get_MULTIREC_API_Value');

Line 4250: Oe_Debug_Pub.ADD('Multirec API = '|| l_value_string);

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
4254: --dbms_output.put_line('Before Calling Get_Profile_Option_Value');

Line 4257: Oe_Debug_Pub.ADD('Profile = '|| l_value_string);

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;
4261: ELSIF l_src_type = 'SYSTEM' THEN

Line 4258: Oe_Debug_Pub.ADD('Profile Value = '|| l_attribute_value);

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;
4261: ELSIF l_src_type = 'SYSTEM' THEN
4262: --dbms_output.put_line('Before Calling Get_System_Variable');

Line 4265: Oe_Debug_Pub.ADD('System Variable = ' || l_value_string);

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;
4269: ELSIF l_src_type = 'CONSTANT' THEN

Line 4266: Oe_Debug_Pub.ADD('System Variable Value = ' || l_attribute_value);

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;
4269: ELSIF l_src_type = 'CONSTANT' THEN
4270: l_attribute_value := l_value_string;

Line 4272: Oe_Debug_Pub.ADD('Constant = ' || l_value_string);

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

Line 4277: Oe_Debug_Pub.ADD('Invalid source type');

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;
4281:

Line 4291: Oe_Debug_Pub.ADD('Context(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).context_name);

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);
4295: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);

Line 4292: Oe_Debug_Pub.ADD('SRC Type(' || l_qual_count || '): ' || l_src_type);

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);
4295: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4296: Oe_Debug_Pub.ADD('------------------------------');

Line 4293: Oe_Debug_Pub.ADD('SRC Value(' || l_qual_count || '): ' || 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);
4295: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4296: Oe_Debug_Pub.ADD('------------------------------');
4297:

Line 4294: Oe_Debug_Pub.ADD('Attribute Name(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_name);

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);
4295: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4296: Oe_Debug_Pub.ADD('------------------------------');
4297:
4298: END IF;

Line 4295: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);

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);
4295: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4296: Oe_Debug_Pub.ADD('------------------------------');
4297:
4298: END IF;
4299: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN

Line 4296: Oe_Debug_Pub.ADD('------------------------------');

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);
4295: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4296: Oe_Debug_Pub.ADD('------------------------------');
4297:
4298: END IF;
4299: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN
4300:

Line 4306: Oe_Debug_Pub.ADD('Context(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).context_name);

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);
4310: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);

Line 4307: Oe_Debug_Pub.ADD('SRC Type(' || l_price_count || '): ' || l_src_type);

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);
4310: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4311: Oe_Debug_Pub.ADD('------------------------------');

Line 4308: Oe_Debug_Pub.ADD('SRC Value(' || l_price_count || '): ' || 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);
4310: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4311: Oe_Debug_Pub.ADD('------------------------------');
4312:

Line 4309: Oe_Debug_Pub.ADD('Attribute Name(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_name);

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);
4310: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4311: Oe_Debug_Pub.ADD('------------------------------');
4312:
4313: END IF;

Line 4310: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);

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);
4310: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4311: Oe_Debug_Pub.ADD('------------------------------');
4312:
4313: END IF;
4314: ELSE

Line 4311: Oe_Debug_Pub.ADD('------------------------------');

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);
4310: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4311: Oe_Debug_Pub.ADD('------------------------------');
4312:
4313: END IF;
4314: ELSE
4315: IF l_debug = Fnd_Api.G_TRUE THEN

Line 4316: Oe_Debug_Pub.ADD('Context type invalid');

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;
4320:

Line 4324: Oe_Debug_Pub.ADD('Found a MULTIREC for context type: ' || l_context_type);

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:
4328: IF (l_attribute_mvalue.COUNT <> 0) AND (l_attribute_mvalue(1) IS NOT NULL) THEN

Line 4342: Oe_Debug_Pub.ADD('Context(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).context_name);

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);
4346: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);

Line 4343: Oe_Debug_Pub.ADD('SRC Type(' || l_qual_count || '): ' || l_src_type);

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);
4346: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4347: Oe_Debug_Pub.ADD('------------------------------');

Line 4344: Oe_Debug_Pub.ADD('SRC Value(' || l_qual_count || '): ' || l_attribute_value);

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);
4346: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4347: Oe_Debug_Pub.ADD('------------------------------');
4348:

Line 4345: Oe_Debug_Pub.ADD('Attribute Name(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_name);

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);
4346: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4347: Oe_Debug_Pub.ADD('------------------------------');
4348:
4349: END IF;

Line 4346: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);

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);
4346: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4347: Oe_Debug_Pub.ADD('------------------------------');
4348:
4349: END IF;
4350: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN

Line 4347: Oe_Debug_Pub.ADD('------------------------------');

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);
4346: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4347: Oe_Debug_Pub.ADD('------------------------------');
4348:
4349: END IF;
4350: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN
4351:

Line 4357: Oe_Debug_Pub.ADD('Context(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).context_name);

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);
4361: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);

Line 4358: Oe_Debug_Pub.ADD('SRC Type(' || l_price_count || '): ' || l_src_type);

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);
4361: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4362: Oe_Debug_Pub.ADD('------------------------------');

Line 4359: Oe_Debug_Pub.ADD('SRC Value(' || l_price_count || '): ' || l_attribute_value);

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);
4361: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4362: Oe_Debug_Pub.ADD('------------------------------');
4363:

Line 4360: Oe_Debug_Pub.ADD('Attribute Name(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_name);

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);
4361: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4362: Oe_Debug_Pub.ADD('------------------------------');
4363:
4364: END IF;

Line 4361: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);

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);
4361: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4362: Oe_Debug_Pub.ADD('------------------------------');
4363:
4364: END IF;
4365: ELSE

Line 4362: Oe_Debug_Pub.ADD('------------------------------');

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);
4361: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4362: Oe_Debug_Pub.ADD('------------------------------');
4363:
4364: END IF;
4365: ELSE
4366: IF l_debug = Fnd_Api.G_TRUE THEN

Line 4367: Oe_Debug_Pub.ADD('Context type invalid');

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;
4371:

Line 4380: Oe_Debug_Pub.ADD('No value was obtained in the mapping process of source type ' || l_src_type);

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;
4384:

Line 4529: Oe_Debug_Pub.ADD('Invalid source type');

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;
4533: