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

Line 269: OE_Debug_Pub.add ( 'Geresh :: Price Line ID Check '|| p_PRICING_ATTR_rec.list_line_id ) ;

265:
266: --
267: -- Check conditionally required attributes here.
268: --
269: OE_Debug_Pub.add ( 'Geresh :: Price Line ID Check '|| p_PRICING_ATTR_rec.list_line_id ) ;
270:
271: -- Functional Area Validation for Hierarchical Categories (sfiresto)
272: IF p_PRICING_ATTR_rec.product_attribute_context = 'ITEM' AND
273: p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE2' THEN

Line 394: oe_debug_pub.add('Dates Overlapping' );

390: nvl(l_End_Date_Active,l_max_date) )
391:
392: THEN
393: l_count:=1;
394: oe_debug_pub.add('Dates Overlapping' );
395: oe_debug_pub.add('Product and UOM match hence check for Pricing attributes' );
396: exit;
397: end if;
398:

Line 395: oe_debug_pub.add('Product and UOM match hence check for Pricing attributes' );

391:
392: THEN
393: l_count:=1;
394: oe_debug_pub.add('Dates Overlapping' );
395: oe_debug_pub.add('Product and UOM match hence check for Pricing attributes' );
396: exit;
397: end if;
398:
399: end loop;

Line 408: OE_Debug_Pub.add ( 'smbalara :: Value Set 1' || l_start_date_active || l_end_date_active );

404: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
405: from qp_list_lines
406: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
407:
408: OE_Debug_Pub.add ( 'smbalara :: Value Set 1' || l_start_date_active || l_end_date_active );
409:
410: OE_Debug_Pub.add ( 'smbalara :: Value Set 2' || l_revision );
411:
412: if NOT( Qp_Validate_pll_pricing_attr.Check_Dup_Pra (l_start_date_active,

Line 410: OE_Debug_Pub.add ( 'smbalara :: Value Set 2' || l_revision );

406: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
407:
408: OE_Debug_Pub.add ( 'smbalara :: Value Set 1' || l_start_date_active || l_end_date_active );
409:
410: OE_Debug_Pub.add ( 'smbalara :: Value Set 2' || l_revision );
411:
412: if NOT( Qp_Validate_pll_pricing_attr.Check_Dup_Pra (l_start_date_active,
413: l_end_date_active,
414: l_revision,

Line 424: OE_Debug_Pub.add ( 'smbalara :: l_x_rows ' || l_x_rows );

420: l_x_dup_sdate,
421: l_x_dup_edate )
422: ) then
423:
424: OE_Debug_Pub.add ( 'smbalara :: l_x_rows ' || l_x_rows );
425: if l_x_rows > 0 THEN
426: OE_Debug_Pub.add ( 'smbalara :: PA match hence duplicate lines');
427: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
428: THEN

Line 426: OE_Debug_Pub.add ( 'smbalara :: PA match hence duplicate lines');

422: ) then
423:
424: OE_Debug_Pub.add ( 'smbalara :: l_x_rows ' || l_x_rows );
425: if l_x_rows > 0 THEN
426: OE_Debug_Pub.add ( 'smbalara :: PA match hence duplicate lines');
427: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
428: THEN
429: l_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MESSAGE.SET_NAME('QP','QP_DUP_PRICING_ATTR');

Line 436: OE_Debug_Pub.add ( 'smbalara :: Only one primary uom allowed');

432: end if;
433: END If;
434: ELSE
435: --End check for Pricing attributes 8359896
436: OE_Debug_Pub.add ( 'smbalara :: Only one primary uom allowed');
437: l_return_status := FND_API.G_RET_STS_ERROR;
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
440: OE_MSG_PUB.Add;

Line 689: OE_Debug_Pub.add ( 'Geresh :: Value Set 1' || l_start_date_active || l_end_date_active );

685: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
686: from qp_list_lines
687: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
688: */
689: OE_Debug_Pub.add ( 'Geresh :: Value Set 1' || l_start_date_active || l_end_date_active );
690:
691: OE_Debug_Pub.add ( 'Geresh :: Value Set 2' || l_revision );
692: /*
693: if NOT( QP_CHECK_DUP_PRA.Check_Dup_Pra (

Line 691: OE_Debug_Pub.add ( 'Geresh :: Value Set 2' || l_revision );

687: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
688: */
689: OE_Debug_Pub.add ( 'Geresh :: Value Set 1' || l_start_date_active || l_end_date_active );
690:
691: OE_Debug_Pub.add ( 'Geresh :: Value Set 2' || l_revision );
692: /*
693: if NOT( QP_CHECK_DUP_PRA.Check_Dup_Pra (
694: l_start_date_active,
695: l_end_date_active,

Line 702: OE_Debug_Pub.add ( 'Geresh :: Result ' || l_x_rows );

698: l_list_header_id ,
699: l_x_rows )
700: ) then
701:
702: OE_Debug_Pub.add ( 'Geresh :: Result ' || l_x_rows );
703: if l_x_rows > 0 THEN
704:
705: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
706: THEN

Line 716: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919

712:
713:
714: end if;
715: */
716: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
717: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
718: THEN --5018856 , 5024919 only log request if not N or null
719: oe_debug_pub.add('about to log a request to check duplicate list lines ');
720:

Line 719: oe_debug_pub.add('about to log a request to check duplicate list lines ');

715: */
716: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
717: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
718: THEN --5018856 , 5024919 only log request if not N or null
719: oe_debug_pub.add('about to log a request to check duplicate list lines ');
720:
721: QP_DELAYED_REQUESTS_PVT.Log_Request
722: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
723: , p_entity_id => p_PRICING_ATTR_rec.list_line_id

Line 736: oe_debug_pub.add('failed in logging a delayed request ');

732: );
733:
734: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
735:
736: oe_debug_pub.add('failed in logging a delayed request ');
737:
738: RAISE FND_API.G_EXC_ERROR;
739:
740: END IF;

Line 742: oe_debug_pub.add('after logging delayed request ');

738: RAISE FND_API.G_EXC_ERROR;
739:
740: END IF;
741:
742: oe_debug_pub.add('after logging delayed request ');
743: END IF;-- end IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or null-- 5108856
744:
745: IF (p_Pricing_Attr_rec.pricing_attribute_context IS NOT NULL
746: OR p_Pricing_Attr_rec.pricing_attribute IS NOT NULL

Line 836: oe_debug_pub.add('for context '||l_return_status);

832: End If;
833:
834:
835: --dbms_output.put_line('for attributr '||l_return_status);
836: oe_debug_pub.add('for context '||l_return_status);
837:
838:
839: --- validate qualifier_attr_value only if comparison operator is
840: -- '='

Line 862: oe_debug_pub.add('for value,'||l_return_status);

858: END IF;
859:
860:
861: --dbms_output.put_line('for value,'||l_return_status);
862: oe_debug_pub.add('for value,'||l_return_status);
863:
864: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
865: --dbms_output.put_line('n precede '||l_precedence);
866:

Line 903: oe_debug_pub.add('qualifier datatype,'||l_return_status);

899: END IF;
900:
901:
902: --dbms_output.put_line('for datatype,'||l_return_status);
903: oe_debug_pub.add('qualifier datatype,'||l_return_status);
904:
905:
906:
907: --validation for canonical form

Line 1040: oe_debug_pub.add('entity validation for compa2 '||l_return_status);

1036: END IF; /* context or atttribute is not null */
1037:
1038:
1039: --dbms_output.put_line('entity validation for compa2 '||l_return_status);
1040: oe_debug_pub.add('entity validation for compa2 '||l_return_status);
1041:
1042:
1043:
1044: --Validate Qualifier_Context , Qualifier_attribute ,Qualifier_Attr Value

Line 1110: oe_debug_pub.add('for context '||l_return_status);

1106: End If;
1107:
1108:
1109: --dbms_output.put_line('for attributr '||l_return_status);
1110: oe_debug_pub.add('for context '||l_return_status);
1111:
1112:
1113: --- validate qualifier_attr_value only if comparison operator is
1114: -- '='

Line 1136: oe_debug_pub.add('for value,'||l_return_status);

1132: END IF;
1133:
1134:
1135: --dbms_output.put_line('for value,'||l_return_status);
1136: oe_debug_pub.add('for value,'||l_return_status);
1137:
1138: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
1139: --dbms_output.put_line('n precede '||l_precedence);
1140:

Line 1161: oe_debug_pub.add('qualifier datatype,'||l_return_status);

1157:
1158:
1159:
1160: --dbms_output.put_line('for datatype,'||l_return_status);
1161: oe_debug_pub.add('qualifier datatype,'||l_return_status);
1162:
1163:
1164:
1165: --validation for canonical form

Line 1225: OE_Debug_Pub.add ( 'before logging delayed request for Price Break Child Line ');

1221: /* if context, attribute, value_from or value_to is not null */
1222:
1223: -- End of validation for canonical form on value to
1224:
1225: OE_Debug_Pub.add ( 'before logging delayed request for Price Break Child Line ');
1226:
1227: /* First Delayed Request to ensure that only one price break pricing attribute
1228: is allowed for a given Price Break Header.
1229: Second Delayed Request to prevent overlapping Price Break Ranges for a given

Line 1257: OE_Debug_Pub.add ( 'Logging delayed request for Price Break Child Line ');

1253:
1254: IF p_Pricing_Attr_rec.pricing_attribute_context = 'VOLUME' AND
1255: l_from_rltd_modifier_id IS NOT NULL
1256: THEN
1257: OE_Debug_Pub.add ( 'Logging delayed request for Price Break Child Line ');
1258: QP_DELAYED_REQUESTS_PVT.Log_Request
1259: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1260: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1261: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

Line 1282: oe_debug_pub.add('failed in logging a delayed request ');

1278: x_return_status => l_return_status
1279: );
1280:
1281: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1282: oe_debug_pub.add('failed in logging a delayed request ');
1283: RAISE FND_API.G_EXC_ERROR;
1284: END IF;
1285:
1286:

Line 1996: oe_debug_pub.add('Dates Overlapping' );

1992: THEN
1993: p_x_dup_sdate := l_sdate;
1994: p_x_dup_edate := l_edate;
1995:
1996: oe_debug_pub.add('Dates Overlapping' );
1997: p_x_effdates := FALSE;
1998: RETURN FALSE;
1999: end if;
2000: