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

Line 23: oe_debug_pub.add('Entering proc clear_dependent_attr in FormulaLines Util Pkg');

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('Entering proc clear_dependent_attr in FormulaLines Util Pkg');
24: -- Load out record
25:
26: x_FORMULA_LINES_rec := p_FORMULA_LINES_rec;
27:

Line 332: oe_debug_pub.add('Leaving proc clear_dependent_attr in FormulaLines Util Pkg');

328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_REQD_FLAG;
330: END IF;
331:
332: oe_debug_pub.add('Leaving proc clear_dependent_attr in FormulaLines Util Pkg');
333: END Clear_Dependent_Attr;
334:
335: -- Procedure Apply_Attribute_Changes
336:

Line 346: oe_debug_pub.add('Entering proc apply_attr_Changes in FormulaLines Util Pkg');

342: )
343: IS
344: BEGIN
345:
346: oe_debug_pub.add('Entering proc apply_attr_Changes in FormulaLines Util Pkg');
347: -- Load out record
348:
349: x_FORMULA_LINES_rec := p_FORMULA_LINES_rec;
350:

Line 516: oe_debug_pub.add('Leaving proc apply_attr_Changes in FormulaLines Util Pkg');

512: THEN
513: NULL;
514: END IF;
515:
516: oe_debug_pub.add('Leaving proc apply_attr_Changes in FormulaLines Util Pkg');
517: END Apply_Attribute_Changes;
518:
519: -- Function Complete_Record
520:

Line 529: oe_debug_pub.add('Entering proc Complete_Record in FormulaLines Util Pkg');

525: IS
526: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
527: BEGIN
528:
529: oe_debug_pub.add('Entering proc Complete_Record in FormulaLines Util Pkg');
530: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
531: l_FORMULA_LINES_rec.attribute1 := p_old_FORMULA_LINES_rec.attribute1;
532: END IF;
533:

Line 664: oe_debug_pub.add('Leaving proc Complete_Record in FormulaLines Util Pkg');

660: END IF;
661:
662: RETURN l_FORMULA_LINES_rec;
663:
664: oe_debug_pub.add('Leaving proc Complete_Record in FormulaLines Util Pkg');
665: END Complete_Record;
666:
667: -- Function Convert_Miss_To_Null
668:

Line 676: oe_debug_pub.add('Entering proc Convert_Miss_To_Null in FormulaLines Util Pkg');

672: IS
673: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
674: BEGIN
675:
676: oe_debug_pub.add('Entering proc Convert_Miss_To_Null in FormulaLines Util Pkg');
677: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
678: l_FORMULA_LINES_rec.attribute1 := NULL;
679: END IF;
680:

Line 809: oe_debug_pub.add('Leaving proc Convert_Miss_To_Null in FormulaLines Util Pkg');

805: IF l_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR THEN
806: l_FORMULA_LINES_rec.reqd_flag := NULL;
807: END IF;
808:
809: oe_debug_pub.add('Leaving proc Convert_Miss_To_Null in FormulaLines Util Pkg');
810: RETURN l_FORMULA_LINES_rec;
811:
812: END Convert_Miss_To_Null;
813:

Line 822: oe_debug_pub.add('Entering proc Update_Row in FormulaLines Util Pkg');

818: )
819: IS
820: BEGIN
821:
822: oe_debug_pub.add('Entering proc Update_Row in FormulaLines Util Pkg');
823: UPDATE QP_PRICE_FORMULA_LINES
824: SET ATTRIBUTE1 = p_FORMULA_LINES_rec.attribute1
825: , ATTRIBUTE10 = p_FORMULA_LINES_rec.attribute10
826: , ATTRIBUTE11 = p_FORMULA_LINES_rec.attribute11

Line 860: oe_debug_pub.add('Leaving proc Update_Row in FormulaLines Util Pkg');

856: , REQD_FLAG = p_FORMULA_LINES_rec.reqd_flag
857: WHERE PRICE_FORMULA_LINE_ID = p_FORMULA_LINES_rec.price_formula_line_id
858: ;
859:
860: oe_debug_pub.add('Leaving proc Update_Row in FormulaLines Util Pkg');
861:
862: IF(p_FORMULA_LINES_rec.pricing_attribute_context IS NOT NULL) AND
863: (p_FORMULA_LINES_rec.pricing_attribute IS NOT NULL) THEN
864: UPDATE qp_pte_segments SET used_in_setup='Y'

Line 897: oe_debug_pub.add('Entering proc Insert_Row in FormulaLines Util Pkg');

893: )
894: IS
895: BEGIN
896:
897: oe_debug_pub.add('Entering proc Insert_Row in FormulaLines Util Pkg');
898: INSERT INTO QP_PRICE_FORMULA_LINES
899: ( ATTRIBUTE1
900: , ATTRIBUTE10
901: , ATTRIBUTE11

Line 969: oe_debug_pub.add('Leaving proc Insert_Row in FormulaLines Util Pkg');

965: , p_FORMULA_LINES_rec.step_number
966: , p_FORMULA_LINES_rec.reqd_flag
967: );
968:
969: oe_debug_pub.add('Leaving proc Insert_Row in FormulaLines Util Pkg');
970:
971: IF(p_FORMULA_LINES_rec.pricing_attribute_context IS NOT NULL) AND
972: (p_FORMULA_LINES_rec.pricing_attribute IS NOT NULL) THEN
973: UPDATE qp_pte_segments SET used_in_setup='Y'

Line 1007: oe_debug_pub.add('Entering proc Delete_Row in FormulaLines Util Pkg');

1003: )
1004: IS
1005: BEGIN
1006:
1007: oe_debug_pub.add('Entering proc Delete_Row in FormulaLines Util Pkg');
1008: DELETE FROM QP_PRICE_FORMULA_LINES
1009: WHERE PRICE_FORMULA_LINE_ID = p_price_formula_line_id
1010: ;
1011:

Line 1012: oe_debug_pub.add('Leaving proc Delete_Row in FormulaLines Util Pkg');

1008: DELETE FROM QP_PRICE_FORMULA_LINES
1009: WHERE PRICE_FORMULA_LINE_ID = p_price_formula_line_id
1010: ;
1011:
1012: oe_debug_pub.add('Leaving proc Delete_Row in FormulaLines Util Pkg');
1013:
1014:
1015: EXCEPTION
1016:

Line 1039: oe_debug_pub.add('Entering and Leaving proc Query_Row in FormulaLines Util Pkg');

1035: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1036: IS
1037: BEGIN
1038:
1039: oe_debug_pub.add('Entering and Leaving proc Query_Row in FormulaLines Util Pkg');
1040: RETURN Query_Rows
1041: ( p_price_formula_line_id => p_price_formula_line_id
1042: )(1);
1043:

Line 1102: oe_debug_pub.add('Entering proc Query_Rows in FormulaLines Util Pkg');

1098: );
1099:
1100: BEGIN
1101:
1102: oe_debug_pub.add('Entering proc Query_Rows in FormulaLines Util Pkg');
1103: IF
1104: (p_price_formula_line_id IS NOT NULL
1105: AND
1106: p_price_formula_line_id <> FND_API.G_MISS_NUM)

Line 1182: oe_debug_pub.add('Leaving proc Query_Rows in FormulaLines Util Pkg');

1178: RAISE NO_DATA_FOUND;
1179: END IF;
1180:
1181:
1182: oe_debug_pub.add('Leaving proc Query_Rows in FormulaLines Util Pkg');
1183: -- Return fetched table
1184:
1185: RETURN l_FORMULA_LINES_tbl;
1186:

Line 1219: oe_debug_pub.add('Entering proc Lock_Row in FormulaLines Util Pkg');

1215: IS
1216: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1217: BEGIN
1218:
1219: oe_debug_pub.add('Entering proc Lock_Row in FormulaLines Util Pkg');
1220: SELECT ATTRIBUTE1
1221: , ATTRIBUTE10
1222: , ATTRIBUTE11
1223: , ATTRIBUTE12

Line 1386: oe_debug_pub.add('Leaving proc Lock_Row in FormulaLines Util Pkg');

1382: END IF;
1383:
1384: END IF;
1385:
1386: oe_debug_pub.add('Leaving proc Lock_Row in FormulaLines Util Pkg');
1387: EXCEPTION
1388:
1389: WHEN NO_DATA_FOUND THEN
1390:

Line 1439: oe_debug_pub.add('Entering proc Get_Values in FormulaLines Util Pkg');

1435: IS
1436: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
1437: BEGIN
1438:
1439: oe_debug_pub.add('Entering proc Get_Values in FormulaLines Util Pkg');
1440: IF p_FORMULA_LINES_rec.price_formula_id IS NOT NULL AND
1441: p_FORMULA_LINES_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1442: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
1443: p_old_FORMULA_LINES_rec.price_formula_id)

Line 1490: oe_debug_pub.add('Leaving proc Get_Values in FormulaLines Util Pkg');

1486: ( p_price_modifier_list_id => p_FORMULA_LINES_rec.price_modifier_list_id
1487: );
1488: END IF;
1489:
1490: oe_debug_pub.add('Leaving proc Get_Values in FormulaLines Util Pkg');
1491: RETURN l_FORMULA_LINES_val_rec;
1492:
1493: END Get_Values;
1494:

Line 1505: oe_debug_pub.add('Entering proc Get_Ids in FormulaLines Util Pkg');

1501: IS
1502: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1503: BEGIN
1504:
1505: oe_debug_pub.add('Entering proc Get_Ids in FormulaLines Util Pkg');
1506: -- initialize return_status.
1507:
1508: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1509:

Line 1665: oe_debug_pub.add('Leaving proc Get_Ids in FormulaLines Util Pkg');

1661:
1662: END IF;
1663:
1664:
1665: oe_debug_pub.add('Leaving proc Get_Ids in FormulaLines Util Pkg');
1666: RETURN l_FORMULA_LINES_rec;
1667:
1668: END Get_Ids;
1669: