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 309: Oe_Debug_Pub.ADD('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);

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

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

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

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

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

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

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;
362: -- 13638721

Line 364: oe_debug_pub.add('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);

360:
361: END IF;
362: -- 13638721
363: PUT_LINE('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
364: oe_debug_pub.add('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
365: IF (L_MAINT_DYN_SRC_VER='Y') THEN
366: BEGIN
367: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
368: IF (l_pkg_ver='5') THEN

Line 374: oe_debug_pub.add('found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);

370: ELSE
371: l_new_pkg_name := l_new_pkg_name || To_Char(To_Number(l_pkg_ver)+1);
372: END IF;
373: PUT_LINE('found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
374: oe_debug_pub.add('found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
375: EXCEPTION
376: WHEN No_Data_Found THEN
377: l_insert_row := 'Y';
378: l_new_pkg_name := l_new_pkg_name || '1';

Line 380: oe_debug_pub.add('no data found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);

376: WHEN No_Data_Found THEN
377: l_insert_row := 'Y';
378: l_new_pkg_name := l_new_pkg_name || '1';
379: PUT_LINE('no data found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
380: oe_debug_pub.add('no data found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
381: WHEN OTHERS THEN
382: PUT_LINE('when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
383: oe_debug_pub.add('when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
384: END;

Line 383: oe_debug_pub.add('when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);

379: PUT_LINE('no data found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
380: oe_debug_pub.add('no data found row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
381: WHEN OTHERS THEN
382: PUT_LINE('when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
383: oe_debug_pub.add('when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER new pkg name: ' || l_new_pkg_name);
384: END;
385: END IF;
386: -- 13638721
387: PUT_LINE('Now create PACKAGE '||p_pkg_type||' : '

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 497: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));

493: IF (l_insert_row = 'N') THEN
494:
495: PUT_LINE('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
496:
497: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
498: UPDATE qp_parameters_b
499: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)) ,
500: LAST_UPDATE_DATE = sysdate,
501: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,

Line 514: oe_debug_pub.add('found row in qp_params but no row updated so insert: ');

510: 'N','1',SYSDATE,
511: -1,SYSDATE,-1,-1);
512: PUT_LINE('found row in qp_params but no row updated so insert: ' );
513:
514: oe_debug_pub.add('found row in qp_params but no row updated so insert: ');
515: END IF;
516: ELSE
517: PUT_LINE('insert row flag is Y ' );
518:

Line 519: oe_debug_pub.add('insert row flag is Y ');

515: END IF;
516: ELSE
517: PUT_LINE('insert row flag is Y ' );
518:
519: oe_debug_pub.add('insert row flag is Y ');
520: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,
521: ADVANCED_PRICING_ONLY,SEEDED_VALUE,CREATION_DATE,CREATED_BY,
522: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
523: VALUES (-9999,'CONC','BLD_SRC_ATTR_ACTV_VER',-9999,

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

781: l_context_name,
782: l_context_type;
783: EXIT WHEN l_ctxts%NOTFOUND;
784:
785: --oe_debug_pub.add('Attribute = ' || l_attribute_name);
786:
787: --dbms_output.put_line ('#1');
788: v_is_used := 'N';
789:

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

1006: END;
1007: END;
1008: END IF;
1009: END IF;
1010: --oe_debug_pub.add('Enable Flag = ' || v_is_used);
1011:
1012: --dbms_output.put_line ('#2');
1013: IF v_is_used = 'Y' THEN
1014:

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

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

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

1660: END;
1661: END; --bug 7494395
1662: END IF;
1663: END IF;
1664: --oe_debug_pub.add('Enable Flag = ' || v_is_used);
1665: --dbms_output.put_line('Enable Flag = ' || v_is_used);
1666: IF v_is_used = 'Y' THEN
1667: segment_ctr := segment_ctr + 1;
1668: G_New_Sourced_Contexts_Tbl(v_count).attribute_name := l_attribute_name;

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

1677: END IF;
1678:
1679: END LOOP;
1680:
1681: --oe_debug_pub.add('Sourced contexts = ' || G_New_Sourced_Contexts_Tbl.COUNT);
1682:
1683: CLOSE l_ctxts_new;
1684:
1685:

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

1695: IF p_pricing_type = 'L' THEN
1696: Text('FOR i in QP_BULK_PREQ_GRP.G_LINE_REC.line_id.first..QP_BULK_PREQ_GRP.G_LINE_REC.line_id.last');
1697: --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');
1698: Text('Loop');
1699: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1700: Text ('--oe_debug_pub.add (''this_header_id: ''|| nvl(QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i),0));');
1701: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2
1702: );
1703: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);

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

1696: Text('FOR i in QP_BULK_PREQ_GRP.G_LINE_REC.line_id.first..QP_BULK_PREQ_GRP.G_LINE_REC.line_id.last');
1697: --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');
1698: Text('Loop');
1699: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1700: Text ('--oe_debug_pub.add (''this_header_id: ''|| nvl(QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i),0));');
1701: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2
1702: );
1703: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1704: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);

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

1708: Text ('End If;', 3);
1709: Text ('Else', 2);
1710: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1711: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1712: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1713: Text ('End If;', 3);
1714: Text ('End If;' , 2);
1715: ELSE
1716: 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 1743: text('oe_debug_pub.add(''In check to call line_group'');',3);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2387: oe_debug_pub.add('Maintain Dynamic pkgs profile is 1:'||L_MAINT_DYN_SRC_VER);

2383: l_sourcing_start_time := dbms_utility.get_time;
2384:
2385: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2386: -- 13638721
2387: oe_debug_pub.add('Maintain Dynamic pkgs profile is 1:'||L_MAINT_DYN_SRC_VER);
2388: IF (L_MAINT_DYN_SRC_VER='N') THEN
2389: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2390: p_pricing_type_code => p_pricing_type,
2391: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,

Line 2396: oe_debug_pub.add('1. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);

2392: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2393: ELSE
2394: BEGIN
2395: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
2396: oe_debug_pub.add('1. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: l_pkg_ver:='0';
2400: oe_debug_pub.add('1. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);

Line 2400: oe_debug_pub.add('1. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);

2396: oe_debug_pub.add('1. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: l_pkg_ver:='0';
2400: oe_debug_pub.add('1. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);
2401: END;
2402: IF (l_pkg_ver='5') THEN
2403: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2404: p_pricing_type_code => p_pricing_type,

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

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

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

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:
2549: END IF;
2550: END LOOP;

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

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:
2549: END IF;
2550: END LOOP;
2551:

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

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

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

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:
2564: END IF;
2565: END LOOP;

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

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:
2564: END IF;
2565: END LOOP;
2566:

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

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

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

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

Line 2748: Oe_Debug_Pub.ADD('ignore_pricing : QP Profile QP_CUSTOM_IGNORE_PRICING is ON' );

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);
2752: IF l_ignore = 'Y' THEN --8589909

Line 2757: Oe_Debug_Pub.ADD('G_IGNORE_PRICE after custom procedure call: ' || G_IGNORE_PRICE);

2753: G_IGNORE_PRICE := 'Y';
2754: ELSE
2755: G_IGNORE_PRICE := 'N';
2756: END if;
2757: Oe_Debug_Pub.ADD('G_IGNORE_PRICE after custom procedure call: ' || G_IGNORE_PRICE);
2758: EXCEPTION
2759: WHEN OTHERS THEN
2760: l_ignore := 'N';
2761: G_IGNORE_PRICE := 'N'; --8589909

Line 2763: Oe_Debug_Pub.ADD('ignore_pricing : Error in custom Code IGNORE_ITEMLINE_FOR_PRICING ' );

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;
2767: ELSE

Line 2764: Oe_Debug_Pub.ADD('ignore_pricing : Item will be Priced' );

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

Line 2769: Oe_Debug_Pub.ADD('ignore_pricing : QP Profile QP_CUSTOM_IGNORE_PRICING is OFF');

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
2773: oe_debug_pub.add('Maintain Dynamic pkgs profile is 2:'||L_MAINT_DYN_SRC_VER);

Line 2773: oe_debug_pub.add('Maintain Dynamic pkgs profile is 2:'||L_MAINT_DYN_SRC_VER);

2769: Oe_Debug_Pub.ADD('ignore_pricing : QP Profile QP_CUSTOM_IGNORE_PRICING is OFF');
2770: END IF;
2771: END IF;
2772: -- 13638721
2773: oe_debug_pub.add('Maintain Dynamic pkgs profile is 2:'||L_MAINT_DYN_SRC_VER);
2774: IF (L_MAINT_DYN_SRC_VER='N') THEN
2775: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2776: p_pricing_type_code => p_pricing_type_code,
2777: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,

Line 2782: oe_debug_pub.add('2. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);

2778: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2779: ELSE
2780: BEGIN
2781: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
2782: oe_debug_pub.add('2. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
2783: EXCEPTION
2784: WHEN OTHERS THEN
2785: l_pkg_ver:='0';
2786: oe_debug_pub.add('2. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);

Line 2786: oe_debug_pub.add('2. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);

2782: oe_debug_pub.add('2. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
2783: EXCEPTION
2784: WHEN OTHERS THEN
2785: l_pkg_ver:='0';
2786: oe_debug_pub.add('2. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);
2787: END;
2788: IF (l_pkg_ver='5') THEN
2789: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2790: p_pricing_type_code => p_pricing_type_code,

Line 2824: Oe_Debug_Pub.ADD('ignore_pricing : Line is NON PRICABLE' );

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';
2828: l_qual_contexts_result_tbl(l_ignore_cnt).attribute_value := l_ignore;

Line 3088: oe_debug_pub.add('Maintain Dynamic pkgs profile is 3:'||L_MAINT_DYN_SRC_VER);

3084:
3085: IF (p_pricing_type_code = 'H') THEN
3086:
3087: -- 13638721
3088: oe_debug_pub.add('Maintain Dynamic pkgs profile is 3:'||L_MAINT_DYN_SRC_VER);
3089: IF (L_MAINT_DYN_SRC_VER='N') THEN
3090: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3091: p_pricing_type_code => p_pricing_type_code,
3092: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,

Line 3097: oe_debug_pub.add('3. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);

3093: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3094: ELSE
3095: BEGIN
3096: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_SRC_ATTR_ACTV_VER' AND ROWNUM=1;
3097: oe_debug_pub.add('3. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: l_pkg_ver:='0';
3101: oe_debug_pub.add('3. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);

Line 3101: oe_debug_pub.add('3. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);

3097: oe_debug_pub.add('3. found row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver : ' || l_pkg_ver);
3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: l_pkg_ver:='0';
3101: oe_debug_pub.add('3. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);
3102: END;
3103: IF (l_pkg_ver='5') THEN
3104: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3105: p_pricing_type_code => p_pricing_type_code,

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

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

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

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

Line 3583: Oe_Debug_Pub.ADD('Item Attribute: ' || 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;
3586: l_found := 0;
3587:

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

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

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

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

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

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

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

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

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

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

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

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

Line 3644: Oe_Debug_Pub.ADD('Item Attribute: ' || 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;
3647: l_found := 0;
3648:

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

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

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

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

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

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

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

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

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

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

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

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

Line 3760: Oe_Debug_Pub.ADD('Pricing Attribute: ' || 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;
3763: l_found := 0;
3764:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3824: Oe_Debug_Pub.ADD('Pricing Attribute: ' || 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;
3827: l_found := 0;
3828:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4063: Oe_Debug_Pub.ADD('Check_line_group_items custom hook on'

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;
4067: -- end of 10120089

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

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

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

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

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

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);
4092: Oe_Debug_Pub.ADD('In check_line_group_items p_pricing_type_code '
4093: ||p_pricing_type_code||' G_CHECK_LINE_FLAG '||G_CHECK_LINE_FLAG);
4094: END IF;

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

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);
4092: Oe_Debug_Pub.ADD('In check_line_group_items p_pricing_type_code '
4093: ||p_pricing_type_code||' G_CHECK_LINE_FLAG '||G_CHECK_LINE_FLAG);
4094: END IF;
4095: IF G_CHECK_LINE_FLAG = 'N'
4096: OR p_pricing_type_code = 'H'

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

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

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

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

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

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

Line 4143: Oe_Debug_Pub.ADD('Check_line_group_items '

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

Line 4149: Oe_Debug_Pub.ADD('Check_line_group_items '

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

Line 4156: Oe_Debug_Pub.ADD('Check_line_group_items '

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
4160: EXCEPTION

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

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

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

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

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

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

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

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;
4190: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
4191: Build_Contexts
4192: ( p_request_type_code => p_request_type_code

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

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

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

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

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

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

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

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

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

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

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

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:
4246: END IF;
4247: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
4248: Build_Contexts

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

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

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

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

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

4413:
4414: BEGIN
4415:
4416: p_results_tbl(p_index).context_name := p_context_name;
4417: -- oe_debug_pub.add('Context(' || p_index || '): ' || p_results_tbl(p_index).context_name);
4418:
4419: p_results_tbl(p_index).attribute_name := p_attribute_name;
4420: -- oe_debug_pub.add('Attribute Name(' || p_index || '): ' || p_results_tbl(p_index).attribute_name);
4421:

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

4416: p_results_tbl(p_index).context_name := p_context_name;
4417: -- oe_debug_pub.add('Context(' || p_index || '): ' || p_results_tbl(p_index).context_name);
4418:
4419: p_results_tbl(p_index).attribute_name := p_attribute_name;
4420: -- oe_debug_pub.add('Attribute Name(' || p_index || '): ' || p_results_tbl(p_index).attribute_name);
4421:
4422: p_results_tbl(p_index).attribute_value := p_attribute_value;
4423: -- oe_debug_pub.add('Attribute Value(' || p_index || '): ' || p_results_tbl(p_index).attribute_value);
4424:

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

4419: p_results_tbl(p_index).attribute_name := p_attribute_name;
4420: -- oe_debug_pub.add('Attribute Name(' || p_index || '): ' || p_results_tbl(p_index).attribute_name);
4421:
4422: p_results_tbl(p_index).attribute_value := p_attribute_value;
4423: -- oe_debug_pub.add('Attribute Value(' || p_index || '): ' || p_results_tbl(p_index).attribute_value);
4424:
4425: END Add_to_Contexts_Results_Table;
4426:
4427: PROCEDURE Map_Used_But_Not_Mapped_Attrs

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4566: Oe_Debug_Pub.ADD('SRC Value(' || l_qual_count || '): ' || 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);
4568: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4569: Oe_Debug_Pub.ADD('------------------------------');
4570:

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

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);
4568: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4569: Oe_Debug_Pub.ADD('------------------------------');
4570:
4571: END IF;

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

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);
4568: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4569: Oe_Debug_Pub.ADD('------------------------------');
4570:
4571: END IF;
4572: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN

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

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);
4568: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4569: Oe_Debug_Pub.ADD('------------------------------');
4570:
4571: END IF;
4572: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN
4573:

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

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

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

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

Line 4581: Oe_Debug_Pub.ADD('SRC Value(' || l_price_count || '): ' || 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);
4583: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4584: Oe_Debug_Pub.ADD('------------------------------');
4585:

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

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);
4583: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4584: Oe_Debug_Pub.ADD('------------------------------');
4585:
4586: END IF;

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

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);
4583: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4584: Oe_Debug_Pub.ADD('------------------------------');
4585:
4586: END IF;
4587: ELSE

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

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);
4583: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4584: Oe_Debug_Pub.ADD('------------------------------');
4585:
4586: END IF;
4587: ELSE
4588: IF l_debug = Fnd_Api.G_TRUE THEN

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

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

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

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

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

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

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

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

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

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

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

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);
4619: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4620: Oe_Debug_Pub.ADD('------------------------------');
4621:
4622: END IF;

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

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);
4619: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4620: Oe_Debug_Pub.ADD('------------------------------');
4621:
4622: END IF;
4623: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN

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

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);
4619: Oe_Debug_Pub.ADD('Attribute Value(' || l_qual_count || '): ' || x_qual_contexts_result_tbl(l_qual_count).attribute_value);
4620: Oe_Debug_Pub.ADD('------------------------------');
4621:
4622: END IF;
4623: ELSIF l_context_type = 'PRICING_ATTRIBUTE' OR l_context_type = 'PRODUCT' THEN
4624:

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

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

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

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

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

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

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

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);
4634: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4635: Oe_Debug_Pub.ADD('------------------------------');
4636:
4637: END IF;

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

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);
4634: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4635: Oe_Debug_Pub.ADD('------------------------------');
4636:
4637: END IF;
4638: ELSE

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

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);
4634: Oe_Debug_Pub.ADD('Attribute Value(' || l_price_count || '): ' || x_price_contexts_result_tbl(l_price_count).attribute_value);
4635: Oe_Debug_Pub.ADD('------------------------------');
4636:
4637: END IF;
4638: ELSE
4639: IF l_debug = Fnd_Api.G_TRUE THEN

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

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

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

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

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

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