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.OE_PRICE_LIST_LINE_UTIL dependencies on OE_DEBUG_PUB

Line 561: oe_debug_pub.add('Entering OE_Price_List_Line_Util.Apply_Attribute_Changes' || p_Price_List_Line_rec.price_list_id || ' ' || p_PRICE_LIST_LINE_rec.price_list_line_id);

557: IS
558: l_primary_exists BOOLEAN;
559: BEGIN
560:
561: oe_debug_pub.add('Entering OE_Price_List_Line_Util.Apply_Attribute_Changes' || p_Price_List_Line_rec.price_list_id || ' ' || p_PRICE_LIST_LINE_rec.price_list_line_id);
562:
563: -- Load out record
564:
565: x_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;

Line 1011: oe_debug_pub.add('price line rec primary ulb is : ' || p_Price_List_Line_rec.primary);

1007: p_Price_List_Line_rec.pricing_attribute15,
1008: p_Price_List_Line_rec.start_date_active ,
1009: p_Price_List_Line_rec.end_date_active );
1010:
1011: oe_debug_pub.add('price line rec primary ulb is : ' || p_Price_List_Line_rec.primary);
1012:
1013: IF p_Price_List_Line_rec.primary = 'Y' THEN
1014:
1015: IF l_primary_exists THEN

Line 1039: oe_debug_pub.add('Exiting OE_Price_List_Line_Util.Apply_Attribute_Changes');

1035: END IF;
1036:
1037: END IF;
1038:
1039: oe_debug_pub.add('Exiting OE_Price_List_Line_Util.Apply_Attribute_Changes');
1040:
1041: END Apply_Attribute_Changes;
1042:
1043:

Line 1588: oe_debug_pub.initialize;

1584: , LIST_LINE_TYPE_CODE = p_PRICE_LIST_LINE_rec.list_line_type_code
1585: WHERE LIST_LINE_ID = p_PRICE_LIST_LINE_rec.price_list_line_id
1586: ;
1587:
1588: oe_debug_pub.initialize;
1589: oe_debug_pub.debug_on;
1590: oe_debug_pub.add ( 'Geresh 6 :: Before Maintain attributes ' );
1591:
1592: maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'UPDATE', x_return_status);

Line 1589: oe_debug_pub.debug_on;

1585: WHERE LIST_LINE_ID = p_PRICE_LIST_LINE_rec.price_list_line_id
1586: ;
1587:
1588: oe_debug_pub.initialize;
1589: oe_debug_pub.debug_on;
1590: oe_debug_pub.add ( 'Geresh 6 :: Before Maintain attributes ' );
1591:
1592: maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'UPDATE', x_return_status);
1593:

Line 1590: oe_debug_pub.add ( 'Geresh 6 :: Before Maintain attributes ' );

1586: ;
1587:
1588: oe_debug_pub.initialize;
1589: oe_debug_pub.debug_on;
1590: oe_debug_pub.add ( 'Geresh 6 :: Before Maintain attributes ' );
1591:
1592: maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'UPDATE', x_return_status);
1593:
1594:

Line 1633: oe_debug_pub.add ( 'Insert Values' || p_PRICE_LIST_LINE_rec.comments );

1629: l_related_modifier_id number;
1630: l_rltd_modifier_grp_no number;
1631: x_return_status varchar2(30);
1632: BEGIN
1633: oe_debug_pub.add ( 'Insert Values' || p_PRICE_LIST_LINE_rec.comments );
1634:
1635: insert into qp_list_lines(
1636: LIST_LINE_ID,
1637: CREATION_DATE,

Line 1803: oe_debug_pub.initialize;

1799: p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE15,
1800: p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE_CATEGORY */ );
1801:
1802:
1803: oe_debug_pub.initialize;
1804: oe_debug_pub.debug_on;
1805: oe_debug_pub.add ( 'Geresh 7 :: Before Maintain attributes ' );
1806:
1807: maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'INSERT', x_return_status);

Line 1804: oe_debug_pub.debug_on;

1800: p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE_CATEGORY */ );
1801:
1802:
1803: oe_debug_pub.initialize;
1804: oe_debug_pub.debug_on;
1805: oe_debug_pub.add ( 'Geresh 7 :: Before Maintain attributes ' );
1806:
1807: maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'INSERT', x_return_status);
1808:

Line 1805: oe_debug_pub.add ( 'Geresh 7 :: Before Maintain attributes ' );

1801:
1802:
1803: oe_debug_pub.initialize;
1804: oe_debug_pub.debug_on;
1805: oe_debug_pub.add ( 'Geresh 7 :: Before Maintain attributes ' );
1806:
1807: maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'INSERT', x_return_status);
1808:
1809: oe_debug_pub.add ( 'Geresh 7 :: Outpiut' || x_return_status );

Line 1809: oe_debug_pub.add ( 'Geresh 7 :: Outpiut' || x_return_status );

1805: oe_debug_pub.add ( 'Geresh 7 :: Before Maintain attributes ' );
1806:
1807: maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'INSERT', x_return_status);
1808:
1809: oe_debug_pub.add ( 'Geresh 7 :: Outpiut' || x_return_status );
1810:
1811:
1812: /********************************************************/
1813: /* insertion into translation table may need to be done */

Line 1847: oe_debug_pub.add ( 'AAA - deleted ');

1843: from qp_rltd_modifiers
1844: where from_rltd_modifier_id = p_price_list_line_id;
1845:
1846: BEGIN
1847: oe_debug_pub.add ( 'AAA - deleted ');
1848:
1849: /* If list_line_type_code = 'PBH', we need to delete all the children
1850: list lines */
1851:

Line 2771: oe_debug_pub.initialize;

2767: begin
2768:
2769: /* get the inventory item context first. */
2770:
2771: oe_debug_pub.initialize;
2772: oe_debug_pub.debug_on;
2773: oe_debug_pub.add ( 'Geresh 9 :: IN Maintain attributes ' );
2774:
2775: QP_UTIL.Get_Context_Attribute('1001', l_product_context, l_product_attr);

Line 2772: oe_debug_pub.debug_on;

2768:
2769: /* get the inventory item context first. */
2770:
2771: oe_debug_pub.initialize;
2772: oe_debug_pub.debug_on;
2773: oe_debug_pub.add ( 'Geresh 9 :: IN Maintain attributes ' );
2774:
2775: QP_UTIL.Get_Context_Attribute('1001', l_product_context, l_product_attr);
2776:

Line 2773: oe_debug_pub.add ( 'Geresh 9 :: IN Maintain attributes ' );

2769: /* get the inventory item context first. */
2770:
2771: oe_debug_pub.initialize;
2772: oe_debug_pub.debug_on;
2773: oe_debug_pub.add ( 'Geresh 9 :: IN Maintain attributes ' );
2774:
2775: QP_UTIL.Get_Context_Attribute('1001', l_product_context, l_product_attr);
2776:
2777: /* get the customer item context */

Line 2778: oe_debug_pub.add ( 'Geresh 10 :: IN Maintain attributes ' );

2774:
2775: QP_UTIL.Get_Context_Attribute('1001', l_product_context, l_product_attr);
2776:
2777: /* get the customer item context */
2778: oe_debug_pub.add ( 'Geresh 10 :: IN Maintain attributes ' );
2779:
2780: QP_UTIL.Get_Context_Attribute('CUSTOMER_ITEM_ID', l_customer_item_context, l_customer_item_attr);
2781:
2782: oe_debug_pub.add ( 'Geresh 11 :: IN Maintain attributes ' );

Line 2782: oe_debug_pub.add ( 'Geresh 11 :: IN Maintain attributes ' );

2778: oe_debug_pub.add ( 'Geresh 10 :: IN Maintain attributes ' );
2779:
2780: QP_UTIL.Get_Context_Attribute('CUSTOMER_ITEM_ID', l_customer_item_context, l_customer_item_attr);
2781:
2782: oe_debug_pub.add ( 'Geresh 11 :: IN Maintain attributes ' );
2783:
2784: QP_UTIL.Get_Context_Attribute('DOLLARS',
2785: l_pb_dollars_attribute_context,
2786: l_pb_dollars_attribute );

Line 2787: oe_debug_pub.add ( 'Geresh 12 :: IN Maintain attributes ' );

2783:
2784: QP_UTIL.Get_Context_Attribute('DOLLARS',
2785: l_pb_dollars_attribute_context,
2786: l_pb_dollars_attribute );
2787: oe_debug_pub.add ( 'Geresh 12 :: IN Maintain attributes ' );
2788:
2789: QP_UTIL.Get_Context_Attribute('UNITS',
2790: l_pb_units_attribute_context,
2791: l_pb_units_attribute );

Line 2792: oe_debug_pub.add ( 'Geresh 13 :: IN Maintain attributes ' );

2788:
2789: QP_UTIL.Get_Context_Attribute('UNITS',
2790: l_pb_units_attribute_context,
2791: l_pb_units_attribute );
2792: oe_debug_pub.add ( 'Geresh 13 :: IN Maintain attributes ' );
2793:
2794:
2795: IF operation = 'UPDATE' THEN
2796: oe_debug_pub.add ( 'Geresh 14 :: Before Query Maintain attributes ' );

Line 2796: oe_debug_pub.add ( 'Geresh 14 :: Before Query Maintain attributes ' );

2792: oe_debug_pub.add ( 'Geresh 13 :: IN Maintain attributes ' );
2793:
2794:
2795: IF operation = 'UPDATE' THEN
2796: oe_debug_pub.add ( 'Geresh 14 :: Before Query Maintain attributes ' );
2797:
2798: l_pricing_attr_tbl := Query_Pricing_Attributes(p_list_line_id => p_PRICE_LIST_LINE_rec.price_list_line_id);
2799:
2800: oe_debug_pub.add ( 'Geresh 15 :: IN Maintain attributes ' );

Line 2800: oe_debug_pub.add ( 'Geresh 15 :: IN Maintain attributes ' );

2796: oe_debug_pub.add ( 'Geresh 14 :: Before Query Maintain attributes ' );
2797:
2798: l_pricing_attr_tbl := Query_Pricing_Attributes(p_list_line_id => p_PRICE_LIST_LINE_rec.price_list_line_id);
2799:
2800: oe_debug_pub.add ( 'Geresh 15 :: IN Maintain attributes ' );
2801:
2802: FOR I in 1..l_pricing_attr_tbl.count LOOP
2803:
2804:

Line 3003: oe_debug_pub.add ( 'Geresh 20 :: Insert Maintain attributes ' );

2999: END IF; /* If operation = UPDATE */
3000:
3001: IF ( operation = 'INSERT') THEN
3002:
3003: oe_debug_pub.add ( 'Geresh 20 :: Insert Maintain attributes ' );
3004: l_pricing_attr_rec.product_attribute_context := l_product_context;
3005: l_pricing_attr_rec.product_attribute := l_product_attr;
3006: l_pricing_attr_rec.product_attr_value := p_PRICE_LIST_LINE_rec.inventory_item_id;
3007: l_pricing_attr_rec.pricing_attribute_context := 'ALL';

Line 3037: oe_debug_pub.add ( 'Geresh 21 :: Insert Maintain attributes ' );

3033: l_pricing_attr_tbl(I) := l_pricing_attr_rec;
3034: I := I + 1;
3035: end if;
3036:
3037: oe_debug_pub.add ( 'Geresh 21 :: Insert Maintain attributes ' );
3038: If p_PRICE_LIST_LINE_rec.pricing_attribute2 is not null then
3039: l_pricing_attr_rec.pricing_attribute_context := p_PRICE_LIST_LINE_rec.pricing_context;
3040: l_pricing_attr_rec.pricing_attribute := 'PRICING_ATTRIBUTE2';
3041: l_pricing_attr_rec.pricing_attr_value_from := p_PRICE_LIST_LINE_rec.pricing_attribute2;

Line 3073: oe_debug_pub.add ( 'Geresh 23 :: Insert Maintain attributes ' );

3069: l_pricing_attr_rec.pricing_attr_value_to := NULL;
3070: l_pricing_attr_tbl(I) := l_pricing_attr_rec;
3071: I := I + 1;
3072: end if;
3073: oe_debug_pub.add ( 'Geresh 23 :: Insert Maintain attributes ' );
3074:
3075: If p_PRICE_LIST_LINE_rec.pricing_attribute6 is not null then
3076: l_pricing_attr_rec.pricing_attribute_context := p_PRICE_LIST_LINE_rec.pricing_context;
3077: l_pricing_attr_rec.pricing_attribute := 'PRICING_ATTRIBUTE6';

Line 3111: oe_debug_pub.add ( 'Geresh 24 :: Insert Maintain attributes ' );

3107: l_pricing_attr_tbl(I) := l_pricing_attr_rec;
3108: I := I + 1;
3109: end if;
3110:
3111: oe_debug_pub.add ( 'Geresh 24 :: Insert Maintain attributes ' );
3112: If p_PRICE_LIST_LINE_rec.pricing_attribute10 is not null then
3113: l_pricing_attr_rec.pricing_attribute_context := p_PRICE_LIST_LINE_rec.pricing_context;
3114: l_pricing_attr_rec.pricing_attribute := 'PRICING_ATTRIBUTE10';
3115: l_pricing_attr_rec.pricing_attr_value_from := p_PRICE_LIST_LINE_rec.pricing_attribute10;

Line 3195: oe_debug_pub.add ( 'Geresh 18 :: Before Insert into Pricing attributes Maintain attributes ' );

3191: SELECT QP_PRICING_ATTR_GROUP_NO_S.nextval
3192: INTO l_pricing_attr_grouping_no
3193: FROM DUAL;
3194:
3195: oe_debug_pub.add ( 'Geresh 18 :: Before Insert into Pricing attributes Maintain attributes ' );
3196:
3197: FOR I in 1..l_pricing_attr_tbl.count loop
3198:
3199: SELECT QP_PRICING_ATTRIBUTES_S.nextval

Line 3248: oe_debug_pub.add ( 'Geresh 31 :: Before Insert into Pricing attributes Maintain attributes ' );

3244: END LOOP;
3245:
3246:
3247:
3248: oe_debug_pub.add ( 'Geresh 31 :: Before Insert into Pricing attributes Maintain attributes ' );
3249:
3250: IF p_PRICE_LIST_LINE_rec.price_break_parent_line is not null THEN
3251:
3252: select qp_rltd_modifier_grp_no_s.nextval

Line 3255: oe_debug_pub.add ( 'Geresh 30 :: Before Insert into Pricing attributes Maintain attributes ' );

3251:
3252: select qp_rltd_modifier_grp_no_s.nextval
3253: into l_rltd_modifier_grp_no
3254: from dual;
3255: oe_debug_pub.add ( 'Geresh 30 :: Before Insert into Pricing attributes Maintain attributes ' );
3256:
3257: select qp_rltd_modifiers_s.nextval
3258: into l_related_modifier_id
3259: from dual;

Line 3260: oe_debug_pub.add ( 'Geresh 31 :: ' || p_PRICE_LIST_LINE_rec.price_break_parent_line );

3256:
3257: select qp_rltd_modifiers_s.nextval
3258: into l_related_modifier_id
3259: from dual;
3260: oe_debug_pub.add ( 'Geresh 31 :: ' || p_PRICE_LIST_LINE_rec.price_break_parent_line );
3261: oe_debug_pub.add ( 'Geresh 31:: 1 ' || p_PRICE_LIST_LINE_rec.price_list_line_id );
3262:
3263: /*
3264: QP_RLTD_MODIFIER_PVT.Insert_Row(

Line 3261: oe_debug_pub.add ( 'Geresh 31:: 1 ' || p_PRICE_LIST_LINE_rec.price_list_line_id );

3257: select qp_rltd_modifiers_s.nextval
3258: into l_related_modifier_id
3259: from dual;
3260: oe_debug_pub.add ( 'Geresh 31 :: ' || p_PRICE_LIST_LINE_rec.price_break_parent_line );
3261: oe_debug_pub.add ( 'Geresh 31:: 1 ' || p_PRICE_LIST_LINE_rec.price_list_line_id );
3262:
3263: /*
3264: QP_RLTD_MODIFIER_PVT.Insert_Row(
3265: X_RLTD_MODIFIER_ID => l_related_modifier_id