[Home] [Help]
259:
260: --
261: -- Check conditionally required attributes here.
262: --
263: OE_Debug_Pub.add ( 'Geresh :: Price Line ID Check '|| p_PRICING_ATTR_rec.list_line_id ) ;
264:
265: -- Functional Area Validation for Hierarchical Categories (sfiresto)
266: IF p_PRICING_ATTR_rec.product_attribute_context = 'ITEM' AND
267: p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE2' THEN
384: nvl(l_End_Date_Active,l_max_date) )
385:
386: THEN
387: l_count:=1;
388: oe_debug_pub.add('Dates Overlapping' );
389: exit;
390: end if;
391:
392: end loop;
628: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
629: from qp_list_lines
630: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
631: */
632: OE_Debug_Pub.add ( 'Geresh :: Value Set 1' || l_start_date_active || l_end_date_active );
633:
634: OE_Debug_Pub.add ( 'Geresh :: Value Set 2' || l_revision );
635: /*
636: if NOT( QP_CHECK_DUP_PRA.Check_Dup_Pra (
630: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
631: */
632: OE_Debug_Pub.add ( 'Geresh :: Value Set 1' || l_start_date_active || l_end_date_active );
633:
634: OE_Debug_Pub.add ( 'Geresh :: Value Set 2' || l_revision );
635: /*
636: if NOT( QP_CHECK_DUP_PRA.Check_Dup_Pra (
637: l_start_date_active,
638: l_end_date_active,
641: l_list_header_id ,
642: l_x_rows )
643: ) then
644:
645: OE_Debug_Pub.add ( 'Geresh :: Result ' || l_x_rows );
646: if l_x_rows > 0 THEN
647:
648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
655:
656:
657: end if;
658: */
659: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
660: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
661: THEN --5018856 , 5024919 only log request if not N or null
662: oe_debug_pub.add('about to log a request to check duplicate list lines ');
663:
658: */
659: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
660: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
661: THEN --5018856 , 5024919 only log request if not N or null
662: oe_debug_pub.add('about to log a request to check duplicate list lines ');
663:
664: QP_DELAYED_REQUESTS_PVT.Log_Request
665: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
666: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
675: );
676:
677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
678:
679: oe_debug_pub.add('failed in logging a delayed request ');
680:
681: RAISE FND_API.G_EXC_ERROR;
682:
683: END IF;
681: RAISE FND_API.G_EXC_ERROR;
682:
683: END IF;
684:
685: oe_debug_pub.add('after logging delayed request ');
686: END IF;-- end IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or null-- 5108856
687:
688: IF (p_Pricing_Attr_rec.pricing_attribute_context IS NOT NULL
689: OR p_Pricing_Attr_rec.pricing_attribute IS NOT NULL
775: End If;
776:
777:
778: --dbms_output.put_line('for attributr '||l_return_status);
779: oe_debug_pub.add('for context '||l_return_status);
780:
781:
782: --- validate qualifier_attr_value only if comparison operator is
783: -- '='
801: END IF;
802:
803:
804: --dbms_output.put_line('for value,'||l_return_status);
805: oe_debug_pub.add('for value,'||l_return_status);
806:
807: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
808: --dbms_output.put_line('n precede '||l_precedence);
809:
842: END IF;
843:
844:
845: --dbms_output.put_line('for datatype,'||l_return_status);
846: oe_debug_pub.add('qualifier datatype,'||l_return_status);
847:
848:
849:
850: --validation for canonical form
979: END IF; /* context or atttribute is not null */
980:
981:
982: --dbms_output.put_line('entity validation for compa2 '||l_return_status);
983: oe_debug_pub.add('entity validation for compa2 '||l_return_status);
984:
985:
986:
987: --Validate Qualifier_Context , Qualifier_attribute ,Qualifier_Attr Value
1049: End If;
1050:
1051:
1052: --dbms_output.put_line('for attributr '||l_return_status);
1053: oe_debug_pub.add('for context '||l_return_status);
1054:
1055:
1056: --- validate qualifier_attr_value only if comparison operator is
1057: -- '='
1075: END IF;
1076:
1077:
1078: --dbms_output.put_line('for value,'||l_return_status);
1079: oe_debug_pub.add('for value,'||l_return_status);
1080:
1081: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
1082: --dbms_output.put_line('n precede '||l_precedence);
1083:
1100:
1101:
1102:
1103: --dbms_output.put_line('for datatype,'||l_return_status);
1104: oe_debug_pub.add('qualifier datatype,'||l_return_status);
1105:
1106:
1107:
1108: --validation for canonical form
1164: /* if context, attribute, value_from or value_to is not null */
1165:
1166: -- End of validation for canonical form on value to
1167:
1168: OE_Debug_Pub.add ( 'before logging delayed request for Price Break Child Line ');
1169:
1170: /* First Delayed Request to ensure that only one price break pricing attribute
1171: is allowed for a given Price Break Header.
1172: Second Delayed Request to prevent overlapping Price Break Ranges for a given
1196:
1197: IF p_Pricing_Attr_rec.pricing_attribute_context = 'VOLUME' AND
1198: l_from_rltd_modifier_id IS NOT NULL
1199: THEN
1200: OE_Debug_Pub.add ( 'Logging delayed request for Price Break Child Line ');
1201: QP_DELAYED_REQUESTS_PVT.Log_Request
1202: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1203: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1204: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1221: x_return_status => l_return_status
1222: );
1223:
1224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1225: oe_debug_pub.add('failed in logging a delayed request ');
1226: RAISE FND_API.G_EXC_ERROR;
1227: END IF;
1228:
1229:
1927: THEN
1928: p_x_dup_sdate := l_sdate;
1929: p_x_dup_edate := l_edate;
1930:
1931: oe_debug_pub.add('Dates Overlapping' );
1932: p_x_effdates := FALSE;
1933: RETURN FALSE;
1934: end if;
1935: