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

Line 23: oe_debug_pub.add('BEGIN Clear_Dependent_Attr in QPXUPRAB');

19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: oe_debug_pub.add('BEGIN Clear_Dependent_Attr in QPXUPRAB');
24:
25: -- Load out record
26:
27: x_PRICING_ATTR_rec := p_PRICING_ATTR_rec;

Line 421: oe_debug_pub.add('END Clear_Dependent_Attr in QPXUPRAB');

417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_COMPARISON_OPERATOR;
419: END IF;
420:
421: oe_debug_pub.add('END Clear_Dependent_Attr in QPXUPRAB');
422:
423: END Clear_Dependent_Attr;
424:
425: -- Procedure Apply_Attribute_Changes

Line 446: oe_debug_pub.add('BEGIN Apply_Attribute_Changes in QPXUPRAB');

442: l_rltd_modifier_grp_type VARCHAR2(30);
443:
444: BEGIN
445:
446: oe_debug_pub.add('BEGIN Apply_Attribute_Changes in QPXUPRAB');
447:
448: -- Load out record
449:
450: x_PRICING_ATTR_rec := p_PRICING_ATTR_rec;

Line 524: oe_debug_pub.add('11');

520: THEN
521: NULL;
522: END IF;
523:
524: oe_debug_pub.add('11');
525: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,p_old_PRICING_ATTR_rec.attribute10)
526: THEN
527: NULL;
528: END IF;

Line 540: oe_debug_pub.add('22');

536: THEN
537: NULL;
538: END IF;
539:
540: oe_debug_pub.add('22');
541: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,p_old_PRICING_ATTR_rec.attribute13)
542: THEN
543: NULL;
544: END IF;

Line 556: oe_debug_pub.add('33');

552: THEN
553: NULL;
554: END IF;
555:
556: oe_debug_pub.add('33');
557: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,p_old_PRICING_ATTR_rec.attribute2)
558: THEN
559: NULL;
560: END IF;

Line 577: oe_debug_pub.add('44');

573: THEN
574: NULL;
575: END IF;
576:
577: oe_debug_pub.add('44');
578: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,p_old_PRICING_ATTR_rec.attribute6)
579: THEN
580: NULL;
581: END IF;

Line 603: oe_debug_pub.add('55');

599: THEN
600: NULL;
601: END IF;
602:
603: oe_debug_pub.add('55');
604: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)
605: THEN
606: NULL;
607: END IF;

Line 648: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));

644: p_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
645:
646: BEGIN
647:
648: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));
649: select list_header_id into x_PRICING_ATTR_rec.list_header_id
650: from qp_list_lines
651: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
652: EXCEPTION

Line 672: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));

668: IF p_PRICING_ATTR_rec.pricing_phase_id IS NULL OR
669: p_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
670:
671: BEGIN
672: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));
673: select pricing_phase_id into x_PRICING_ATTR_rec.pricing_phase_id
674: from qp_list_lines
675: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
676: EXCEPTION

Line 858: oe_debug_pub.add('END Apply_Attribute_Changes in QPXUPRAB');

854: THEN
855: NULL;
856: END IF;
857:
858: oe_debug_pub.add('END Apply_Attribute_Changes in QPXUPRAB');
859:
860: END Apply_Attribute_Changes;
861:
862: -- Function Complete_Record

Line 872: oe_debug_pub.add('BEGIN Complete_Record in QPXUPRAB');

868: IS
869: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type := p_PRICING_ATTR_rec;
870: BEGIN
871:
872: oe_debug_pub.add('BEGIN Complete_Record in QPXUPRAB');
873:
874: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
875: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
876: END IF;

Line 1048: oe_debug_pub.add('END Complete_Record in QPXUPRAB');

1044: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1045: l_PRICING_ATTR_rec.comparison_operator_code := p_old_PRICING_ATTR_rec.comparison_operator_code;
1046: END IF;
1047:
1048: oe_debug_pub.add('END Complete_Record in QPXUPRAB');
1049:
1050: RETURN l_PRICING_ATTR_rec;
1051:
1052: END Complete_Record;

Line 1063: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUPRAB');

1059: IS
1060: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type := p_PRICING_ATTR_rec;
1061: BEGIN
1062:
1063: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUPRAB');
1064:
1065: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
1066: l_PRICING_ATTR_rec.accumulate_flag := NULL;
1067: END IF;

Line 1239: oe_debug_pub.add('END Convert_Miss_To_Null in QPXUPRAB');

1235: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1236: l_PRICING_ATTR_rec.comparison_operator_code := NULL;
1237: END IF;
1238:
1239: oe_debug_pub.add('END Convert_Miss_To_Null in QPXUPRAB');
1240:
1241: RETURN l_PRICING_ATTR_rec;
1242:
1243: END Convert_Miss_To_Null;

Line 1442: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');

1438: INTO l_active_flag
1439: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll
1440: WHERE lh.LIST_HEADER_ID = ll.LIST_HEADER_ID and ll.LIST_LINE_ID = p_PRICING_ATTR_rec.list_line_id and rownum = 1;
1441:
1442: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
1443:
1444: IF p_PRICING_ATTR_rec.pricing_attribute_datatype = 'N'
1445: then
1446:

Line 1572: oe_debug_pub.add('END Update_Row in QPXUPRAB');

1568: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1569: x_return_status => l_return_status);
1570: END IF;
1571:
1572: oe_debug_pub.add('END Update_Row in QPXUPRAB');
1573:
1574: EXCEPTION
1575:
1576: WHEN OTHERS THEN

Line 1614: oe_debug_pub.add('SMITHA LIST_HEADER_ID'||p_PRICING_ATTR_rec.list_header_id);

1610: l_rltd_modifier_grp_type VARCHAR2(30);
1611: BEGIN
1612:
1613:
1614: oe_debug_pub.add('SMITHA LIST_HEADER_ID'||p_PRICING_ATTR_rec.list_header_id);
1615:
1616: --Fetch modfier group type (Bug 4706180) Start
1617: BEGIN
1618: SELECT RLTD_MODIFIER_GRP_TYPE

Line 1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');

1638: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
1639: WHERE b.list_line_id=p_PRICING_ATTR_rec.list_line_id
1640: AND b.LIST_HEADER_ID = a.list_header_id;
1641: END IF;
1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');
1643: oe_debug_pub.add(p_PRICING_ATTR_rec.attribute_grouping_no);
1644: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute_context);
1645: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute);
1646: oe_debug_pub.add(p_PRICING_ATTR_rec.pricing_attribute);

Line 1643: oe_debug_pub.add(p_PRICING_ATTR_rec.attribute_grouping_no);

1639: WHERE b.list_line_id=p_PRICING_ATTR_rec.list_line_id
1640: AND b.LIST_HEADER_ID = a.list_header_id;
1641: END IF;
1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');
1643: oe_debug_pub.add(p_PRICING_ATTR_rec.attribute_grouping_no);
1644: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute_context);
1645: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute);
1646: oe_debug_pub.add(p_PRICING_ATTR_rec.pricing_attribute);
1647: oe_debug_pub.add(p_PRICING_ATTR_rec.excluder_flag);

Line 1644: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute_context);

1640: AND b.LIST_HEADER_ID = a.list_header_id;
1641: END IF;
1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');
1643: oe_debug_pub.add(p_PRICING_ATTR_rec.attribute_grouping_no);
1644: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute_context);
1645: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute);
1646: oe_debug_pub.add(p_PRICING_ATTR_rec.pricing_attribute);
1647: oe_debug_pub.add(p_PRICING_ATTR_rec.excluder_flag);
1648:

Line 1645: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute);

1641: END IF;
1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');
1643: oe_debug_pub.add(p_PRICING_ATTR_rec.attribute_grouping_no);
1644: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute_context);
1645: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute);
1646: oe_debug_pub.add(p_PRICING_ATTR_rec.pricing_attribute);
1647: oe_debug_pub.add(p_PRICING_ATTR_rec.excluder_flag);
1648:
1649: --If Price Break value to is null and value from is not (the last price break) set

Line 1646: oe_debug_pub.add(p_PRICING_ATTR_rec.pricing_attribute);

1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');
1643: oe_debug_pub.add(p_PRICING_ATTR_rec.attribute_grouping_no);
1644: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute_context);
1645: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute);
1646: oe_debug_pub.add(p_PRICING_ATTR_rec.pricing_attribute);
1647: oe_debug_pub.add(p_PRICING_ATTR_rec.excluder_flag);
1648:
1649: --If Price Break value to is null and value from is not (the last price break) set
1650: --value to 999..99 (15 digit) to incorporate infinite values

Line 1647: oe_debug_pub.add(p_PRICING_ATTR_rec.excluder_flag);

1643: oe_debug_pub.add(p_PRICING_ATTR_rec.attribute_grouping_no);
1644: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute_context);
1645: oe_debug_pub.add(p_PRICING_ATTR_rec.product_attribute);
1646: oe_debug_pub.add(p_PRICING_ATTR_rec.pricing_attribute);
1647: oe_debug_pub.add(p_PRICING_ATTR_rec.excluder_flag);
1648:
1649: --If Price Break value to is null and value from is not (the last price break) set
1650: --value to 999..99 (15 digit) to incorporate infinite values
1651: IF(p_Pricing_Attr_rec.pricing_attr_value_to IS NULL

Line 1843: oe_debug_pub.add('END Insert_Row in QPXUPRAB');

1839: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1840: x_return_status => l_return_status);
1841: END IF;
1842:
1843: oe_debug_pub.add('END Insert_Row in QPXUPRAB');
1844:
1845: EXCEPTION
1846:
1847: WHEN OTHERS THEN

Line 1870: oe_debug_pub.add('BEGIN Delete_Row in QPXUPRAB');

1866: IS
1867: l_list_line_id NUMBER;
1868: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1869: BEGIN
1870: oe_debug_pub.add('BEGIN Delete_Row in QPXUPRAB');
1871:
1872:
1873: DELETE FROM QP_PRICING_ATTRIBUTES
1874: WHERE PRICING_ATTRIBUTE_ID = p_pricing_attribute_id

Line 1886: oe_debug_pub.add('END Delete_Row in QPXUPRAB');

1882: p_requesting_entity_id => l_list_line_id,
1883: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1884: x_return_status => l_return_status);
1885:
1886: oe_debug_pub.add('END Delete_Row in QPXUPRAB');
1887: EXCEPTION
1888:
1889: WHEN OTHERS THEN
1890:

Line 1986: oe_debug_pub.add('BEGIN Query_rows in QPXUPRAB');

1982: );
1983:
1984: BEGIN
1985:
1986: oe_debug_pub.add('BEGIN Query_rows in QPXUPRAB');
1987:
1988: IF
1989: (p_pricing_attribute_id IS NOT NULL
1990: AND

Line 2080: oe_debug_pub.add('END Query_rows in QPXUPRAB');

2076: RAISE NO_DATA_FOUND;
2077: END IF;
2078:
2079:
2080: oe_debug_pub.add('END Query_rows in QPXUPRAB');
2081:
2082: -- Return fetched table
2083:
2084: RETURN l_PRICING_ATTR_tbl;

Line 2121: oe_debug_pub.add('BEGIN Lock_row in QPXUPRAB');

2117: IS
2118: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2119: BEGIN
2120:
2121: oe_debug_pub.add('BEGIN Lock_row in QPXUPRAB');
2122:
2123: SELECT
2124: --ACCUMULATE_FLAG
2125: ATTRIBUTE1

Line 2340: oe_debug_pub.add('END Lock_row in QPXUPRAB');

2336: END IF;
2337:
2338: END IF;
2339:
2340: oe_debug_pub.add('END Lock_row in QPXUPRAB');
2341:
2342: EXCEPTION
2343:
2344: WHEN NO_DATA_FOUND THEN

Line 2394: oe_debug_pub.add('BEGIN Get_Values in QPXUPRAB');

2390: IS
2391: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
2392: BEGIN
2393:
2394: oe_debug_pub.add('BEGIN Get_Values in QPXUPRAB');
2395:
2396: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
2397: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
2398: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,

Line 2465: oe_debug_pub.add('END Get_Values in QPXUPRAB');

2461: ( p_product_uom_code => p_PRICING_ATTR_rec.product_uom_code
2462: );
2463: END IF;
2464:
2465: oe_debug_pub.add('END Get_Values in QPXUPRAB');
2466:
2467: RETURN l_PRICING_ATTR_val_rec;
2468:
2469: END Get_Values;

Line 2481: oe_debug_pub.add('BEGIN Get_Ids in QPXUPRAB');

2477: IS
2478: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2479: BEGIN
2480:
2481: oe_debug_pub.add('BEGIN Get_Ids in QPXUPRAB');
2482:
2483: -- initialize return_status.
2484:
2485: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;

Line 2770: oe_debug_pub.add('END Get_Ids in QPXUPRAB');

2766: END IF;
2767:
2768: END IF;
2769:
2770: oe_debug_pub.add('END Get_Ids in QPXUPRAB');
2771:
2772: RETURN l_PRICING_ATTR_rec;
2773:
2774: END Get_Ids;

Line 2789: oe_debug_pub.Add('Entering QP_PRICING_ATTR_Util.pre_write_process', 1);

2785: l_list_header_id number;
2786:
2787: BEGIN
2788:
2789: oe_debug_pub.Add('Entering QP_PRICING_ATTR_Util.pre_write_process', 1);
2790: -- mkarya for pattern - get the list_header_id as it is not populated yet in the record
2791: -- added for bug No 3384576 in discussion with mkarya
2792:
2793: IF l_PRICING_ATTR_rec.list_header_id IS NOT NULL THEN

Line 2809: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);

2805: x_PRICING_ATTR_rec.list_header_id := l_list_header_id;
2806:
2807: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2808:
2809: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);
2810:
2811: --hw
2812: -- delayed request for changed lines
2813: if QP_PERF_PVT.enabled = 'Y' then