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 306: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');

302: l_rows number := 0;
303: l_effdates boolean := FALSE;
304: BEGIN
305:
306: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: l_status := QP_VALIDATE_PRICING_ATTR.Mod_Dup(p_Start_Date_Active,

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

319:
320: IF l_status = FALSE then
321:
322:
323: oe_debug_pub.add('Ren: check_duplicate_modifiers status is false ');
324:
325: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_LINES');
326: oe_msg_pub.Add;
327:

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

330: END IF;
331:
332:
333:
334: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.mod_dup');
335:
336:
337: EXCEPTION
338:

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

376: l_effdates boolean := FALSE;
377: l_blank_text VARCHAR2(2000);
378: BEGIN
379:
380: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_list_lines');
381:
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383:
384: l_status := QP_VALIDATE_PLL_PRICING_ATTR.Check_Dup_Pra(p_Start_Date_Active,

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

396:
397: IF l_revision = FALSE then
398:
399:
400: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
401:
402: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
403: oe_msg_pub.Add;
404:

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

406:
407: ELSIF l_effdates = FALSE then
408:
409:
410: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
411:
412: FND_MESSAGE.SET_NAME('QP', 'QP_BLANK');
413: l_blank_text := FND_MESSAGE.get;
414:

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

431: RAISE FND_API.G_EXC_ERROR;
432:
433: ELSE
434:
435: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
436:
437: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
438: oe_msg_pub.Add;
439:

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

442: END IF;
443:
444: END IF;
445:
446: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
447:
448:
449: EXCEPTION
450:

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

510: l_parent varchar2(30);
511:
512: BEGIN
513:
514: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
515: oe_debug_pub.add('passed rule id is'||p_list_line_id);
516:
517: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
518: --dbms_output.put_line('passed rule id is'||p_list_line_id);

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

511:
512: BEGIN
513:
514: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
515: oe_debug_pub.add('passed rule id is'||p_list_line_id);
516:
517: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
518: --dbms_output.put_line('passed rule id is'||p_list_line_id);
519:

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

523: open c_check_for_parent(p_list_line_id);
524: fetch c_check_for_parent into l_parent;
525: close c_check_for_parent;
526:
527: oe_debug_pub.add('check parent for ' ||p_list_line_id);
528: oe_debug_pub.add('parent is ' ||l_parent);
529:
530: If l_parent = 'FOUND' then
531:

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

524: fetch c_check_for_parent into l_parent;
525: close c_check_for_parent;
526:
527: oe_debug_pub.add('check parent for ' ||p_list_line_id);
528: oe_debug_pub.add('parent is ' ||l_parent);
529:
530: If l_parent = 'FOUND' then
531:
532: IF p_list_line_type_code = 'PBH' THEN

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

551: IF l_status < 1 then
552:
553: --Raise MULTIPLE_BREAK_CHILD_EXCEPTION;
554:
555: oe_debug_pub.add('status is more than 1');
556: --dbms_output.put_line('status is more than 1');
557: x_return_status := FND_API.G_RET_STS_ERROR;
558:
559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

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

569: END IF;
570: RAISE NO_CHILD_EXCEPTION;
571: END IF;
572:
573: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
574: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
575: else
576:
577: null;

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

574: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
575: else
576:
577: null;
578: oe_debug_pub.add('Exiting no parent found');
579:
580: END IF;
581:
582: EXCEPTION

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

652: l_to_number := 0;
653: --End Bug No: 7321885
654:
655:
656: oe_debug_pub.add('Before overlapping breaks select stmt');
657:
658: --Begin Bug No: 7321885
659: for l_break_lines_rec in C_break_lines(p_list_line_id)
660: LOOP

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

670: l_to_number := l_break_lines_rec.pricing_attr_value_to_number;
671: END LOOP;
672: --End Bug No: 7321885
673:
674: oe_debug_pub.add('After overlapping breaks select stmt');
675: --dbms_output.put_line('status is '||l_status);
676:
677: --Begin Bug No: 7321885
678: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

690: END IF;
691: Raise OVERLAPPING_BREAKS_EXCEPTION;
692: END IF;
693:
694: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
695: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
696:
697: EXCEPTION
698: WHEN NO_DATA_FOUND THEN

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

713: WHEN OTHERS THEN
714:
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716:
717: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));
718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: OE_MSG_PUB.Add_Exc_Msg
721: ( G_PKG_NAME

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

750:
751: BEGIN
752: x_return_status := FND_API.G_RET_STS_SUCCESS;
753:
754: oe_debug_pub.add('Before continuous breaks loop');
755:
756: FOR c_break_lines_attr_val_rec in c_break_lines_attr_values(p_list_line_id)
757: LOOP
758:

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

786:
787:
788: l_break_count := l_break_count+1;
789: END LOOP;
790: oe_debug_pub.add('After continuous breaks loop');
791:
792: IF l_status IS NOT NULL THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794:

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

808: Raise CONTINUOUS_BREAKS_EXCEPTION;
809: END IF;
810: END IF;
811:
812: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks');
813:
814: EXCEPTION
815: WHEN NO_DATA_FOUND THEN
816: NULL;

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

830: WHEN OTHERS THEN
831:
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833:
834: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME

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

928: raise UPGRADE_PRICE_BREAKS_EXCEPTION;
929: END;
930: END LOOP;
931:
932: --oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks');
933:
934: EXCEPTION
935:
936: WHEN UPGRADE_PRICE_BREAKS_EXCEPTION

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

948: WHEN OTHERS THEN
949:
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951:
952: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));
953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
954: THEN
955: OE_MSG_PUB.Add_Exc_Msg
956: ( G_PKG_NAME

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

976: into l_count
977: from qp_price_breaks_v
978: where parent_list_line_id = p_parent_list_line_id;
979:
980: oe_debug_pub.add('price break groups '|| to_char(l_count) );
981: IF l_count > 1 THEN
982: RAISE e_mult_price_break_attrs;
983: END IF;
984:

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

984:
985: EXCEPTION
986: WHEN e_mult_price_break_attrs THEN
987:
988: oe_debug_pub.add('In relevant exception ');
989: FND_MESSAGE.SET_NAME('QP','QP_MULT_PRICE_BREAK_ATTRS');
990: oe_msg_pub.Add;
991:
992: x_return_status := FND_API.G_RET_STS_ERROR;

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

1057:
1058: GROUP BY a.qualifier_grouping_no;
1059:
1060: BEGIN
1061: oe_debug_pub.add('Check_Mixed_Qual_Seg_Levels');
1062: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
1063:
1064: if l_pte_code is null then
1065: l_pte_code := 'ORDFUL';

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

1077:
1078: EXCEPTION
1079: WHEN e_mixed_qual_seg_levels THEN
1080:
1081: oe_debug_pub.add('Mixed Segment Levels for Qualifiers Attributes with ' ||
1082: 'qualifier_rule_id = ' || p_qualifier_rule_id ||
1083: 'and qualifier_grouping_no = ' || l_qualifier_grouping_no);
1084:
1085: FND_MESSAGE.SET_NAME('QP','QP_MIXED_QUAL_SEG_LEVELS');

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

1137: close C_modifier;
1138:
1139: If l_status > 1 Then
1140:
1141: --oe_debug_pub.add('status is duplicate');
1142: --dbms_output.put_line('status is duplicate');
1143:
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145:

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

1151: END IF;
1152: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1153: END IF;
1154:
1155: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1156: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1157:
1158: EXCEPTION
1159: WHEN MULTIPLE_PRICE_LIST_EXCEPTION

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

1295: BEGIN
1296:
1297: x_return_status := FND_API.G_RET_STS_SUCCESS;
1298:
1299: oe_debug_pub.add('list_line_id is NULL');
1300:
1301: BEGIN
1302: select list_type_code
1303: into l_list_type_code

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

1528: ,x_return_status_text => l_return_status_text);
1529:
1530: IF x_return_status = FND_API.G_RET_STS_ERROR
1531: THEN
1532: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
1533: raise Phase_exception;
1534: END IF;
1535: END IF;
1536:

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

1533: raise Phase_exception;
1534: END IF;
1535: END IF;
1536:
1537: oe_debug_pub.add('end update_pricing_phase begin');
1538:
1539: EXCEPTION
1540: WHEN Phase_Exception THEN
1541: x_return_status := FND_API.G_RET_STS_ERROR;

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

1571: BEGIN
1572:
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1576:
1577: BEGIN
1578: select list_type_code, list_header_id
1579: into l_list_type_code, l_list_header_id

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

1742: -- l_price_break_type := p_price_break_type;
1743:
1744: x_return_status := FND_API.G_RET_STS_SUCCESS;
1745:
1746: oe_debug_pub.add('list_line_id is '||p_list_line_id);
1747:
1748: select price_break_type_code,pricing_phase_id, arithmetic_operator -- 4936019
1749: into l_price_break_type,l_pricing_phase_id, l_arithmetic_operator -- 4936019
1750: from qp_list_lines

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

1990: Phase_Exception Exception;
1991: l_return_status_text VARCHAR2(300);
1992:
1993: BEGIN
1994: oe_debug_pub.add('update_pricing_phase begin'||p_pricing_phase_id);--||' '||p_parent_line_id||' '||p_modifier_level_code);
1995:
1996: /*
1997: IF p_list_line_type = 'OID' THEN
1998: l_line := 'Y';

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

2011: IF p_modifier_level_code = 'LINEGROUP' THEN
2012: l_level := 'Y';
2013: END IF;
2014:
2015: -- oe_debug_pub.add('update_pricing_phase l_line '||l_line||' l_rltd '||l_rltd||' l_level '||l_level);
2016:
2017: update qp_pricing_phases PH set
2018: PH.oid_exists = decode(l_line,'N',PH.oid_exists,'Y',l_line)
2019: , PH.rltd_exists = decode(l_rltd,'N',PH.rltd_exists,'Y',l_rltd)

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

2031: ,x_return_status_text => l_return_status_text);
2032:
2033: IF x_return_status = FND_API.G_RET_STS_ERROR
2034: THEN
2035: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
2036: raise Phase_exception;
2037: END IF;
2038:
2039: oe_debug_pub.add('end update_pricing_phase begin');

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

2035: oe_debug_pub.add('error update_pricing_phase begin'||l_return_status_text);
2036: raise Phase_exception;
2037: END IF;
2038:
2039: oe_debug_pub.add('end update_pricing_phase begin');
2040: EXCEPTION
2041: WHEN Phase_Exception THEN
2042:
2043: x_return_status := FND_API.G_RET_STS_ERROR;

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

2077: l_manual_modifier_flag VARCHAR2(1);
2078: l_set_manual_flag VARCHAR2(1);
2079: BEGIN
2080:
2081: oe_debug_pub.add('Update manual modifier flag Begin ');
2082: oe_debug_pub.add('Pricing Phase Id : '||p_pricing_phase_id);
2083: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2084:
2085: l_set_manual_flag := NULL;

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

2078: l_set_manual_flag VARCHAR2(1);
2079: BEGIN
2080:
2081: oe_debug_pub.add('Update manual modifier flag Begin ');
2082: oe_debug_pub.add('Pricing Phase Id : '||p_pricing_phase_id);
2083: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2084:
2085: l_set_manual_flag := NULL;
2086: select manual_modifier_flag into l_manual_modifier_flag

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

2079: BEGIN
2080:
2081: oe_debug_pub.add('Update manual modifier flag Begin ');
2082: oe_debug_pub.add('Pricing Phase Id : '||p_pricing_phase_id);
2083: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2084:
2085: l_set_manual_flag := NULL;
2086: select manual_modifier_flag into l_manual_modifier_flag
2087: from qp_pricing_phases

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

2111: set manual_modifier_flag = l_set_manual_flag
2112: where pricing_phase_id = p_pricing_phase_id;
2113: end if;
2114:
2115: oe_debug_pub.add('Update manual modifier flag End');
2116: EXCEPTION
2117: WHEN FND_API.G_EXC_ERROR THEN
2118:
2119: x_return_status := FND_API.G_RET_STS_ERROR;

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

2149:
2150: l_first_record varchar2(10);
2151: l_first_selling_rounding number;
2152: BEGIN
2153: oe_debug_pub.add('validate_selling_price begin '||p_currency_header_id||' '||p_to_currency_code);
2154:
2155: x_return_status := FND_API.G_RET_STS_SUCCESS;
2156: l_first_record := 'TRUE';
2157:

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

2156: l_first_record := 'TRUE';
2157:
2158: for selling_rounding_rec in c_selling_rounding
2159: LOOP
2160: oe_debug_pub.add('IN LOOP selling_rounding_factor = '||selling_rounding_rec.selling_rounding_factor);
2161: if l_first_record = 'TRUE' then
2162: l_first_selling_rounding := selling_rounding_rec.selling_rounding_factor;
2163: l_first_record := 'FALSE';
2164: end if;

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

2162: l_first_selling_rounding := selling_rounding_rec.selling_rounding_factor;
2163: l_first_record := 'FALSE';
2164: end if;
2165:
2166: oe_debug_pub.add('l_first_selling_rounding = '||l_first_selling_rounding);
2167: if selling_rounding_rec.selling_rounding_factor <> l_first_selling_rounding then
2168: oe_debug_pub.add('selling_rounding_factor NOT EQUAL ');
2169:
2170: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

2164: end if;
2165:
2166: oe_debug_pub.add('l_first_selling_rounding = '||l_first_selling_rounding);
2167: if selling_rounding_rec.selling_rounding_factor <> l_first_selling_rounding then
2168: oe_debug_pub.add('selling_rounding_factor NOT EQUAL ');
2169:
2170: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2171: fnd_message.set_name('QP', 'QP_SELLING_ROUNDING_NOT_SAME');
2172: fnd_message.set_token('CURRENCY_CODE', p_to_currency_code);

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

2177: end if;
2178:
2179: END LOOP;
2180:
2181: oe_debug_pub.add('end validate_selling_rounding ');
2182:
2183: EXCEPTION
2184: WHEN FND_API.G_EXC_ERROR THEN
2185:

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

2219: l_final_segment_level VARCHAR2(30) := NULL;
2220:
2221:
2222: BEGIN
2223: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2224: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2225: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2226: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2227: FOR l_rec in c_qualifiers

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

2220:
2221:
2222: BEGIN
2223: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2224: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2225: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2226: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2227: FOR l_rec in c_qualifiers
2228: LOOP

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

2221:
2222: BEGIN
2223: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2224: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2225: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2226: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2227: FOR l_rec in c_qualifiers
2228: LOOP
2229: l_current_segment_level := qp_util.get_segment_level(p_list_header_id

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

2222: BEGIN
2223: oe_debug_pub.add('Begin Check_Segment_Level_in_Group');
2224: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2225: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2226: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2227: FOR l_rec in c_qualifiers
2228: LOOP
2229: l_current_segment_level := qp_util.get_segment_level(p_list_header_id
2230: ,l_rec.qualifier_context

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

2314: end if; -- l_final_segment_level is NULL
2315:
2316: END LOOP;
2317:
2318: oe_debug_pub.add('End Check_Segment_Level_in_Group');
2319: EXCEPTION
2320: WHEN FND_API.G_EXC_ERROR THEN
2321:
2322: x_return_status := FND_API.G_RET_STS_ERROR;

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

2365:
2366: l_segment_level VARCHAR2(30) := NULL;
2367:
2368: BEGIN
2369: oe_debug_pub.add('Begin Check_Line_for_Header_Qual');
2370: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2371: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2372: for l_mod_rec in c_mod_level
2373: LOOP

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

2366: l_segment_level VARCHAR2(30) := NULL;
2367:
2368: BEGIN
2369: oe_debug_pub.add('Begin Check_Line_for_Header_Qual');
2370: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2371: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2372: for l_mod_rec in c_mod_level
2373: LOOP
2374: if l_mod_rec.modifier_level = 'ORDER' then

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

2367:
2368: BEGIN
2369: oe_debug_pub.add('Begin Check_Line_for_Header_Qual');
2370: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2371: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2372: for l_mod_rec in c_mod_level
2373: LOOP
2374: if l_mod_rec.modifier_level = 'ORDER' then
2375: l_order_modifier_exists := 'Y';

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

2414: end if; -- l_header_qual_exists = 'N'
2415:
2416: if l_header_qual_exists = 'Y' then
2417: if l_line_modifier_exists = 'Y' and l_qual_exist_for_line_modifier = 'N' then
2418: oe_debug_pub.add('mkarya - Modifier Lines of level ''LINE'' or ''LINEGROUP''
2419: will not be applied to an order as no header qualifier exist');
2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2421: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_LINE');
2422: OE_MSG_PUB.Add;

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

2424: --raise FND_API.G_EXC_ERROR;
2425: end if;
2426:
2427: if l_order_modifier_exists = 'Y' and l_qual_exist_for_ord_modifier = 'N' then
2428: oe_debug_pub.add('mkarya - Modifier Lines of level ''ORDER'' will not be applied
2429: to an order as no header qualifier exist');
2430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2431: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_ORD');
2432: OE_MSG_PUB.Add;

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

2436:
2437: end if; -- l_header_qual_exists = 'Y'
2438: end if; -- l_line_modifier_exists = 'Y' or l_order_modifier_exists = 'Y'
2439:
2440: oe_debug_pub.add('End Check_Line_for_Header_Qual');
2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN
2443:
2444: x_return_status := FND_API.G_RET_STS_ERROR;

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

2469: x_return_status out NOCOPY varchar2
2470: ) is
2471: begin
2472:
2473: oe_debug_pub.add('process update_changed_lines_add');
2474:
2475: --please note that this is being done from concurrent program
2476: --QP: Maintain denormalised data in qp_qualifiers also in which
2477: --case the procedure update_changed_lines_product in QPXDENOB.pls

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

2517: x_return_status out NOCOPY varchar2
2518: ) is
2519: begin
2520:
2521: oe_debug_pub.add('process update_changed_lines_del');
2522:
2523: --please note that this is being done from concurrent program
2524: --QP: Maintain denormalised data in qp_qualifiers also in which
2525: --case the procedure update_changed_lines_product in QPXDENOB.pls

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

2588: l_product_attr_value varchar2(240);
2589: l_pricing_phase_id number;
2590: begin
2591:
2592: oe_debug_pub.add('process update_changed_lines_ph');
2593:
2594: --please note that this is being done from concurrent program
2595: --QP: Maintain denormalised data in qp_qualifiers also in which
2596: --case the procedure update_changed_lines_product in QPXDENOB.pls

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

2703: and qpa.list_line_id = qpl.list_line_id;
2704:
2705: begin
2706:
2707: oe_debug_pub.add('process update_changed_lines_act');
2708: --please note that this is being done from concurrent program
2709: --QP: Maintain denormalised data in qp_qualifiers also in which
2710: --case the procedure update_changed_lines_product in QPXDENOB.pls
2711: --is called. Any changes made to this routine needs to be