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_DELAYED_REQUESTS_UTIL dependencies on OE_DEBUG_PUB

Line 27: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check dup');

23: and a.qualifier_id <> b.qualifier_id;
24:
25: BEGIN
26:
27: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
28: oe_debug_pub.add('passed rule id is'||p_qualifier_rule_id);
29: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
30: --dbms_output.put_line('passed rule id is'||p_qualifier_rule_id);
31:

Line 28: oe_debug_pub.add('passed rule id is'||p_qualifier_rule_id);

24:
25: BEGIN
26:
27: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
28: oe_debug_pub.add('passed rule id is'||p_qualifier_rule_id);
29: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
30: --dbms_output.put_line('passed rule id is'||p_qualifier_rule_id);
31:
32: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 40: oe_debug_pub.add('status is duplicate');

36:
37: --dbms_output.put_line('status is '||l_status);
38: If l_status = 'DUPLICATE' Then
39:
40: oe_debug_pub.add('status is duplicate');
41: --dbms_output.put_line('status is duplicate');
42: x_return_status := FND_API.G_RET_STS_ERROR;
43:
44: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

Line 53: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

49: END IF;
50: RAISE DUPLICATE_DISCOUNT;
51: END IF;
52:
53: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
54: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
55:
56: EXCEPTION
57: WHEN DUPLICATE_DISCOUNT

Line 314: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');

310: l_rows number := 0;
311: l_effdates boolean := FALSE;
312: BEGIN
313:
314: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: l_status := QP_VALIDATE_PRICING_ATTR.Mod_Dup(p_Start_Date_Active,

Line 331: oe_debug_pub.add('Ren: check_duplicate_modifiers status is false ');

327:
328: IF l_status = FALSE then
329:
330:
331: oe_debug_pub.add('Ren: check_duplicate_modifiers status is false ');
332:
333: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_LINES');
334: oe_msg_pub.Add;
335:

Line 342: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.mod_dup');

338: END IF;
339:
340:
341:
342: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.mod_dup');
343:
344:
345: EXCEPTION
346:

Line 388: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_list_lines');

384: l_effdates boolean := FALSE;
385: l_blank_text VARCHAR2(2000);
386: BEGIN
387:
388: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_list_lines');
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: l_status := QP_VALIDATE_PLL_PRICING_ATTR.Check_Dup_Pra(p_Start_Date_Active,

Line 408: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');

404:
405: IF l_revision = FALSE then
406:
407:
408: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
409:
410: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
411: oe_msg_pub.Add;
412:

Line 418: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');

414:
415: ELSIF l_effdates = FALSE then
416:
417:
418: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
419:
420: FND_MESSAGE.SET_NAME('QP', 'QP_BLANK');
421: l_blank_text := FND_MESSAGE.get;
422:

Line 443: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');

439: RAISE FND_API.G_EXC_ERROR;
440:
441: ELSE
442:
443: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
444:
445: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
446: oe_msg_pub.Add;
447:

Line 454: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

450: END IF;
451:
452: END IF;
453:
454: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
455:
456:
457: EXCEPTION
458:

Line 522: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');

518: l_parent varchar2(30);
519:
520: BEGIN
521:
522: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
523: oe_debug_pub.add('passed rule id is'||p_list_line_id);
524:
525: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
526: --dbms_output.put_line('passed rule id is'||p_list_line_id);

Line 523: oe_debug_pub.add('passed rule id is'||p_list_line_id);

519:
520: BEGIN
521:
522: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
523: oe_debug_pub.add('passed rule id is'||p_list_line_id);
524:
525: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
526: --dbms_output.put_line('passed rule id is'||p_list_line_id);
527:

Line 535: oe_debug_pub.add('check parent for ' ||p_list_line_id);

531: open c_check_for_parent(p_list_line_id);
532: fetch c_check_for_parent into l_parent;
533: close c_check_for_parent;
534:
535: oe_debug_pub.add('check parent for ' ||p_list_line_id);
536: oe_debug_pub.add('parent is ' ||l_parent);
537:
538: If l_parent = 'FOUND' then
539:

Line 536: oe_debug_pub.add('parent is ' ||l_parent);

532: fetch c_check_for_parent into l_parent;
533: close c_check_for_parent;
534:
535: oe_debug_pub.add('check parent for ' ||p_list_line_id);
536: oe_debug_pub.add('parent is ' ||l_parent);
537:
538: If l_parent = 'FOUND' then
539:
540: IF p_list_line_type_code = 'PBH' THEN

Line 563: oe_debug_pub.add('status is more than 1');

559: IF l_status < 1 then
560:
561: --Raise MULTIPLE_BREAK_CHILD_EXCEPTION;
562:
563: oe_debug_pub.add('status is more than 1');
564: --dbms_output.put_line('status is more than 1');
565: x_return_status := FND_API.G_RET_STS_ERROR;
566:
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

Line 581: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');

577: END IF;
578: RAISE NO_CHILD_EXCEPTION;
579: END IF;
580:
581: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
582: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
583: else
584:
585: null;

Line 586: oe_debug_pub.add('Exiting no parent found');

582: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
583: else
584:
585: null;
586: oe_debug_pub.add('Exiting no parent found');
587:
588: END IF;
589:
590: EXCEPTION

Line 664: oe_debug_pub.add('Before overlapping breaks select stmt');

660: l_to_number := 0;
661: --End Bug No: 7321885
662:
663:
664: oe_debug_pub.add('Before overlapping breaks select stmt');
665:
666: --Begin Bug No: 7321885
667: for l_break_lines_rec in C_break_lines(p_list_line_id)
668: LOOP

Line 682: oe_debug_pub.add('After overlapping breaks select stmt');

678: l_to_number := l_break_lines_rec.pricing_attr_value_to_number;
679: END LOOP;
680: --End Bug No: 7321885
681:
682: oe_debug_pub.add('After overlapping breaks select stmt');
683: --dbms_output.put_line('status is '||l_status);
684:
685: --Begin Bug No: 7321885
686: IF x_return_status = FND_API.G_RET_STS_ERROR then

Line 702: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');

698: END IF;
699: Raise OVERLAPPING_BREAKS_EXCEPTION;
700: END IF;
701:
702: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
703: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
704:
705: EXCEPTION
706: WHEN NO_DATA_FOUND THEN

Line 725: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));

721: WHEN OTHERS THEN
722:
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724:
725: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));
726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
727: THEN
728: OE_MSG_PUB.Add_Exc_Msg
729: ( G_PKG_NAME

Line 762: oe_debug_pub.add('Before continuous breaks loop');

758:
759: BEGIN
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: oe_debug_pub.add('Before continuous breaks loop');
763:
764: FOR c_break_lines_attr_val_rec in c_break_lines_attr_values(p_list_line_id)
765: LOOP
766:

Line 798: oe_debug_pub.add('After continuous breaks loop');

794:
795:
796: l_break_count := l_break_count+1;
797: END LOOP;
798: oe_debug_pub.add('After continuous breaks loop');
799:
800: IF l_status IS NOT NULL THEN
801: x_return_status := FND_API.G_RET_STS_ERROR;
802:

Line 820: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks');

816: Raise CONTINUOUS_BREAKS_EXCEPTION;
817: END IF;
818: END IF;
819:
820: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks');
821:
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN
824: NULL;

Line 842: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));

838: WHEN OTHERS THEN
839:
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841:
842: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME

Line 940: --oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks');

936: raise UPGRADE_PRICE_BREAKS_EXCEPTION;
937: END;
938: END LOOP;
939:
940: --oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks');
941:
942: EXCEPTION
943:
944: WHEN UPGRADE_PRICE_BREAKS_EXCEPTION

Line 960: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));

956: WHEN OTHERS THEN
957:
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));
961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
962: THEN
963: OE_MSG_PUB.Add_Exc_Msg
964: ( G_PKG_NAME

Line 988: oe_debug_pub.add('price break groups '|| to_char(l_count) );

984: into l_count
985: from qp_price_breaks_v
986: where parent_list_line_id = p_parent_list_line_id;
987:
988: oe_debug_pub.add('price break groups '|| to_char(l_count) );
989: IF l_count > 1 THEN
990: RAISE e_mult_price_break_attrs;
991: END IF;
992:

Line 996: oe_debug_pub.add('In relevant exception ');

992:
993: EXCEPTION
994: WHEN e_mult_price_break_attrs THEN
995:
996: oe_debug_pub.add('In relevant exception ');
997: FND_MESSAGE.SET_NAME('QP','QP_MULT_PRICE_BREAK_ATTRS');
998: oe_msg_pub.Add;
999:
1000: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1069: oe_debug_pub.add('Check_Mixed_Qual_Seg_Levels');

1065:
1066: GROUP BY a.qualifier_grouping_no;
1067:
1068: BEGIN
1069: oe_debug_pub.add('Check_Mixed_Qual_Seg_Levels');
1070: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
1071:
1072: if l_pte_code is null then
1073: l_pte_code := 'ORDFUL';

Line 1089: oe_debug_pub.add('Mixed Segment Levels for Qualifiers Attributes with ' ||

1085:
1086: EXCEPTION
1087: WHEN e_mixed_qual_seg_levels THEN
1088:
1089: oe_debug_pub.add('Mixed Segment Levels for Qualifiers Attributes with ' ||
1090: 'qualifier_rule_id = ' || p_qualifier_rule_id ||
1091: 'and qualifier_grouping_no = ' || l_qualifier_grouping_no);
1092:
1093: FND_MESSAGE.SET_NAME('QP','QP_MIXED_QUAL_SEG_LEVELS');

Line 1149: --oe_debug_pub.add('status is duplicate');

1145: close C_modifier;
1146:
1147: If l_status > 1 Then
1148:
1149: --oe_debug_pub.add('status is duplicate');
1150: --dbms_output.put_line('status is duplicate');
1151:
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:

Line 1163: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

1159: END IF;
1160: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1161: END IF;
1162:
1163: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1164: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1165:
1166: EXCEPTION
1167: WHEN MULTIPLE_PRICE_LIST_EXCEPTION

Line 1307: oe_debug_pub.add('list_line_id is NULL');

1303: BEGIN
1304:
1305: x_return_status := FND_API.G_RET_STS_SUCCESS;
1306:
1307: oe_debug_pub.add('list_line_id is NULL');
1308:
1309: BEGIN
1310: select list_type_code
1311: into l_list_type_code

Line 1540: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);

1536: ,x_return_status_text => l_return_status_text);
1537:
1538: IF x_return_status = FND_API.G_RET_STS_ERROR
1539: THEN
1540: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
1541: raise Phase_exception;
1542: END IF;
1543: END IF;
1544:

Line 1545: oe_debug_pub.add('end update_pricing_phase begin');

1541: raise Phase_exception;
1542: END IF;
1543: END IF;
1544:
1545: oe_debug_pub.add('end update_pricing_phase begin');
1546:
1547: EXCEPTION
1548: WHEN Phase_Exception THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1583: oe_debug_pub.add('list_line_id is '||p_list_line_id);

1579: BEGIN
1580:
1581: x_return_status := FND_API.G_RET_STS_SUCCESS;
1582:
1583: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1584:
1585: BEGIN
1586: select list_type_code, list_header_id
1587: into l_list_type_code, l_list_header_id

Line 1754: oe_debug_pub.add('list_line_id is '||p_list_line_id);

1750: -- l_price_break_type := p_price_break_type;
1751:
1752: x_return_status := FND_API.G_RET_STS_SUCCESS;
1753:
1754: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1755:
1756: select price_break_type_code,pricing_phase_id, arithmetic_operator -- 4936019
1757: into l_price_break_type,l_pricing_phase_id, l_arithmetic_operator -- 4936019
1758: from qp_list_lines

Line 2002: oe_debug_pub.add('update_pricing_phase begin'||p_pricing_phase_id);--||' '||p_parent_line_id||' '||p_modifier_level_code);

1998: Phase_Exception Exception;
1999: l_return_status_text VARCHAR2(300);
2000:
2001: BEGIN
2002: oe_debug_pub.add('update_pricing_phase begin'||p_pricing_phase_id);--||' '||p_parent_line_id||' '||p_modifier_level_code);
2003:
2004: /*
2005: IF p_list_line_type = 'OID' THEN
2006: l_line := 'Y';

Line 2023: -- oe_debug_pub.add('update_pricing_phase l_line '||l_line||' l_rltd '||l_rltd||' l_level '||l_level);

2019: IF p_modifier_level_code = 'LINEGROUP' THEN
2020: l_level := 'Y';
2021: END IF;
2022:
2023: -- oe_debug_pub.add('update_pricing_phase l_line '||l_line||' l_rltd '||l_rltd||' l_level '||l_level);
2024:
2025: update qp_pricing_phases PH set
2026: PH.oid_exists = decode(l_line,'N',PH.oid_exists,'Y',l_line)
2027: , PH.rltd_exists = decode(l_rltd,'N',PH.rltd_exists,'Y',l_rltd)

Line 2043: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);

2039: ,x_return_status_text => l_return_status_text);
2040:
2041: IF x_return_status = FND_API.G_RET_STS_ERROR
2042: THEN
2043: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
2044: raise Phase_exception;
2045: END IF;
2046:
2047: oe_debug_pub.add('end update_pricing_phase begin');

Line 2047: oe_debug_pub.add('end update_pricing_phase begin');

2043: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
2044: raise Phase_exception;
2045: END IF;
2046:
2047: oe_debug_pub.add('end update_pricing_phase begin');
2048: EXCEPTION
2049: WHEN Phase_Exception THEN
2050:
2051: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2089: oe_debug_pub.add('Update manual modifier flag Begin ');

2085: l_manual_modifier_flag VARCHAR2(1);
2086: l_set_manual_flag VARCHAR2(1);
2087: BEGIN
2088:
2089: oe_debug_pub.add('Update manual modifier flag Begin ');
2090: oe_debug_pub.add('Pricing Phase Id : '||p_pricing_phase_id);
2091: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2092:
2093: l_set_manual_flag := NULL;

Line 2090: oe_debug_pub.add('Pricing Phase Id : '||p_pricing_phase_id);

2086: l_set_manual_flag VARCHAR2(1);
2087: BEGIN
2088:
2089: oe_debug_pub.add('Update manual modifier flag Begin ');
2090: oe_debug_pub.add('Pricing Phase Id : '||p_pricing_phase_id);
2091: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2092:
2093: l_set_manual_flag := NULL;
2094: select manual_modifier_flag into l_manual_modifier_flag

Line 2091: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);

2087: BEGIN
2088:
2089: oe_debug_pub.add('Update manual modifier flag Begin ');
2090: oe_debug_pub.add('Pricing Phase Id : '||p_pricing_phase_id);
2091: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2092:
2093: l_set_manual_flag := NULL;
2094: select manual_modifier_flag into l_manual_modifier_flag
2095: from qp_pricing_phases

Line 2126: oe_debug_pub.add('Update manual modifier flag End');

2122: set manual_modifier_flag = l_set_manual_flag
2123: where pricing_phase_id = p_pricing_phase_id;
2124: end if;
2125:
2126: oe_debug_pub.add('Update manual modifier flag End');
2127: EXCEPTION
2128: WHEN FND_API.G_EXC_ERROR THEN
2129:
2130: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2164: oe_debug_pub.add('validate_selling_price begin '||p_currency_header_id||' '||p_to_currency_code);

2160:
2161: l_first_record varchar2(10);
2162: l_first_selling_rounding number;
2163: BEGIN
2164: oe_debug_pub.add('validate_selling_price begin '||p_currency_header_id||' '||p_to_currency_code);
2165:
2166: x_return_status := FND_API.G_RET_STS_SUCCESS;
2167: l_first_record := 'TRUE';
2168:

Line 2171: oe_debug_pub.add('IN LOOP selling_rounding_factor = '||selling_rounding_rec.selling_rounding_factor);

2167: l_first_record := 'TRUE';
2168:
2169: for selling_rounding_rec in c_selling_rounding
2170: LOOP
2171: oe_debug_pub.add('IN LOOP selling_rounding_factor = '||selling_rounding_rec.selling_rounding_factor);
2172: if l_first_record = 'TRUE' then
2173: l_first_selling_rounding := selling_rounding_rec.selling_rounding_factor;
2174: l_first_record := 'FALSE';
2175: end if;

Line 2177: oe_debug_pub.add('l_first_selling_rounding = '||l_first_selling_rounding);

2173: l_first_selling_rounding := selling_rounding_rec.selling_rounding_factor;
2174: l_first_record := 'FALSE';
2175: end if;
2176:
2177: oe_debug_pub.add('l_first_selling_rounding = '||l_first_selling_rounding);
2178: if selling_rounding_rec.selling_rounding_factor <> l_first_selling_rounding then
2179: oe_debug_pub.add('selling_rounding_factor NOT EQUAL ');
2180:
2181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2179: oe_debug_pub.add('selling_rounding_factor NOT EQUAL ');

2175: end if;
2176:
2177: oe_debug_pub.add('l_first_selling_rounding = '||l_first_selling_rounding);
2178: if selling_rounding_rec.selling_rounding_factor <> l_first_selling_rounding then
2179: oe_debug_pub.add('selling_rounding_factor NOT EQUAL ');
2180:
2181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2182: fnd_message.set_name('QP', 'QP_SELLING_ROUNDING_NOT_SAME');
2183: fnd_message.set_token('CURRENCY_CODE', p_to_currency_code);

Line 2192: oe_debug_pub.add('end validate_selling_rounding ');

2188: end if;
2189:
2190: END LOOP;
2191:
2192: oe_debug_pub.add('end validate_selling_rounding ');
2193:
2194: EXCEPTION
2195: WHEN FND_API.G_EXC_ERROR THEN
2196:

Line 2234: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');

2230: l_final_segment_level VARCHAR2(30) := NULL;
2231:
2232:
2233: BEGIN
2234: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2235: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2236: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2237: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2238: FOR l_rec in c_qualifiers

Line 2235: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);

2231:
2232:
2233: BEGIN
2234: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2235: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2236: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2237: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2238: FOR l_rec in c_qualifiers
2239: LOOP

Line 2236: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);

2232:
2233: BEGIN
2234: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2235: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2236: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2237: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2238: FOR l_rec in c_qualifiers
2239: LOOP
2240: l_current_segment_level := qp_util.get_segment_level(p_list_header_id

Line 2237: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);

2233: BEGIN
2234: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2235: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2236: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2237: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2238: FOR l_rec in c_qualifiers
2239: LOOP
2240: l_current_segment_level := qp_util.get_segment_level(p_list_header_id
2241: ,l_rec.qualifier_context

Line 2329: oe_debug_pub.add('End Check_Segment_Level_in_Group');

2325: end if; -- l_final_segment_level is NULL
2326:
2327: END LOOP;
2328:
2329: oe_debug_pub.add('End Check_Segment_Level_in_Group');
2330: EXCEPTION
2331: WHEN FND_API.G_EXC_ERROR THEN
2332:
2333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2380: oe_debug_pub.add('Begin Check_Line_for_Header_Qual');

2376:
2377: l_segment_level VARCHAR2(30) := NULL;
2378:
2379: BEGIN
2380: oe_debug_pub.add('Begin Check_Line_for_Header_Qual');
2381: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2382: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2383: for l_mod_rec in c_mod_level
2384: LOOP

Line 2381: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);

2377: l_segment_level VARCHAR2(30) := NULL;
2378:
2379: BEGIN
2380: oe_debug_pub.add('Begin Check_Line_for_Header_Qual');
2381: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2382: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2383: for l_mod_rec in c_mod_level
2384: LOOP
2385: if l_mod_rec.modifier_level = 'ORDER' then

Line 2382: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);

2378:
2379: BEGIN
2380: oe_debug_pub.add('Begin Check_Line_for_Header_Qual');
2381: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2382: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2383: for l_mod_rec in c_mod_level
2384: LOOP
2385: if l_mod_rec.modifier_level = 'ORDER' then
2386: l_order_modifier_exists := 'Y';

Line 2429: oe_debug_pub.add('mkarya - Modifier Lines of level ''LINE'' or ''LINEGROUP''

2425: end if; -- l_header_qual_exists = 'N'
2426:
2427: if l_header_qual_exists = 'Y' then
2428: if l_line_modifier_exists = 'Y' and l_qual_exist_for_line_modifier = 'N' then
2429: oe_debug_pub.add('mkarya - Modifier Lines of level ''LINE'' or ''LINEGROUP''
2430: will not be applied to an order as no header qualifier exist');
2431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2432: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_LINE');
2433: OE_MSG_PUB.Add;

Line 2439: oe_debug_pub.add('mkarya - Modifier Lines of level ''ORDER'' will not be applied

2435: --raise FND_API.G_EXC_ERROR;
2436: end if;
2437:
2438: if l_order_modifier_exists = 'Y' and l_qual_exist_for_ord_modifier = 'N' then
2439: oe_debug_pub.add('mkarya - Modifier Lines of level ''ORDER'' will not be applied
2440: to an order as no header qualifier exist');
2441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2442: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_ORD');
2443: OE_MSG_PUB.Add;

Line 2451: oe_debug_pub.add('End Check_Line_for_Header_Qual');

2447:
2448: end if; -- l_header_qual_exists = 'Y'
2449: end if; -- l_line_modifier_exists = 'Y' or l_order_modifier_exists = 'Y'
2450:
2451: oe_debug_pub.add('End Check_Line_for_Header_Qual');
2452: EXCEPTION
2453: WHEN FND_API.G_EXC_ERROR THEN
2454:
2455: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2484: oe_debug_pub.add('process update_changed_lines_add');

2480: x_return_status out NOCOPY varchar2
2481: ) is
2482: begin
2483:
2484: oe_debug_pub.add('process update_changed_lines_add');
2485:
2486: --please note that this is being done from concurrent program
2487: --QP: Maintain denormalised data in qp_qualifiers also in which
2488: --case the procedure update_changed_lines_product in QPXDENOB.pls

Line 2532: oe_debug_pub.add('process update_changed_lines_del');

2528: x_return_status out NOCOPY varchar2
2529: ) is
2530: begin
2531:
2532: oe_debug_pub.add('process update_changed_lines_del');
2533:
2534: --please note that this is being done from concurrent program
2535: --QP: Maintain denormalised data in qp_qualifiers also in which
2536: --case the procedure update_changed_lines_product in QPXDENOB.pls

Line 2603: oe_debug_pub.add('process update_changed_lines_ph');

2599: l_product_attr_value varchar2(240);
2600: l_pricing_phase_id number;
2601: begin
2602:
2603: oe_debug_pub.add('process update_changed_lines_ph');
2604:
2605: --please note that this is being done from concurrent program
2606: --QP: Maintain denormalised data in qp_qualifiers also in which
2607: --case the procedure update_changed_lines_product in QPXDENOB.pls

Line 2718: oe_debug_pub.add('process update_changed_lines_act');

2714: and qpa.list_line_id = qpl.list_line_id;
2715:
2716: begin
2717:
2718: oe_debug_pub.add('process update_changed_lines_act');
2719: --please note that this is being done from concurrent program
2720: --QP: Maintain denormalised data in qp_qualifiers also in which
2721: --case the procedure update_changed_lines_product in QPXDENOB.pls
2722: --is called. Any changes made to this routine needs to be

Line 2863: oe_debug_pub.add('calling new jagan ' || p_list_header_id);

2859: QP_PS_ATTR_GRP_PVT.Header_Pattern_Main(
2860: p_list_header_id => p_list_header_id,
2861: p_qualifier_group => p_qualifier_group,
2862: p_setup_action => p_setup_action);
2863: oe_debug_pub.add('calling new jagan ' || p_list_header_id);
2864: ELSE
2865: QP_ATTR_GRP_PVT.Header_Pattern_Main(
2866: p_list_header_id => p_list_header_id,
2867: p_qualifier_group => p_qualifier_group,

Line 2869: oe_debug_pub.add('calling old jagan ' || p_list_header_id);

2865: QP_ATTR_GRP_PVT.Header_Pattern_Main(
2866: p_list_header_id => p_list_header_id,
2867: p_qualifier_group => p_qualifier_group,
2868: p_setup_action => p_setup_action);
2869: oe_debug_pub.add('calling old jagan ' || p_list_header_id);
2870: END IF;
2871: EXCEPTION
2872: WHEN FND_API.G_EXC_ERROR THEN
2873: x_return_status := FND_API.G_RET_STS_ERROR;