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

Line 24: oe_debug_pub.add('BEGIN clear_dependent_attr in QPXUMLHB');

20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23:
24: oe_debug_pub.add('BEGIN clear_dependent_attr in QPXUMLHB');
25:
26: -- Load out record
27:
28: x_MODIFIER_LIST_rec := p_MODIFIER_LIST_rec;

Line 554: oe_debug_pub.add('END clear_dependent_attr in QPXUMLHB');

550: ELSIF p_attr_id = G_ORG_ID THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORG_ID;
553: END IF;
554: oe_debug_pub.add('END clear_dependent_attr in QPXUMLHB');
555:
556: END Clear_Dependent_Attr;
557:
558: -- Procedure Apply_Attribute_Changes

Line 574: oe_debug_pub.add('BEGIN apply_attribute_changes in QPXUMLHB');

570: select distinct pricing_phase_id from qp_list_lines
571: where list_header_id = l_list_header_id;
572: BEGIN
573:
574: oe_debug_pub.add('BEGIN apply_attribute_changes in QPXUMLHB');
575: -- Load out record
576:
577: x_MODIFIER_LIST_rec := p_MODIFIER_LIST_rec;
578:

Line 1081: oe_debug_pub.add('END apply_attribute_changes in QPXUMLHB');

1077: THEN
1078: NULL;
1079: END IF;
1080:
1081: oe_debug_pub.add('END apply_attribute_changes in QPXUMLHB');
1082: END Apply_Attribute_Changes;
1083:
1084:
1085: -- Function Complete_Record

Line 1095: oe_debug_pub.add('BEGIN complete_record in QPXUMLHB');

1091: IS
1092: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1093: BEGIN
1094:
1095: oe_debug_pub.add('BEGIN complete_record in QPXUMLHB');
1096:
1097: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1098: l_MODIFIER_LIST_rec.attribute1 := p_old_MODIFIER_LIST_rec.attribute1;
1099: END IF;

Line 1332: oe_debug_pub.add('version QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);

1328: IF l_MODIFIER_LIST_rec.org_id = FND_API.G_MISS_NUM THEN
1329: l_MODIFIER_LIST_rec.org_id := p_old_MODIFIER_LIST_rec.org_id;
1330: END IF;
1331:
1332: oe_debug_pub.add('version QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);
1333: oe_debug_pub.add('END complete_record in QPXUMLHB');
1334: RETURN l_MODIFIER_LIST_rec;
1335:
1336: END Complete_Record;

Line 1333: oe_debug_pub.add('END complete_record in QPXUMLHB');

1329: l_MODIFIER_LIST_rec.org_id := p_old_MODIFIER_LIST_rec.org_id;
1330: END IF;
1331:
1332: oe_debug_pub.add('version QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);
1333: oe_debug_pub.add('END complete_record in QPXUMLHB');
1334: RETURN l_MODIFIER_LIST_rec;
1335:
1336: END Complete_Record;
1337:

Line 1347: oe_debug_pub.add('BEGIN convert_miss_to_null in QPXUMLHB');

1343: IS
1344: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1345: BEGIN
1346:
1347: oe_debug_pub.add('BEGIN convert_miss_to_null in QPXUMLHB');
1348:
1349: IF l_MODIFIER_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1350: l_MODIFIER_LIST_rec.attribute1 := NULL;
1351: END IF;

Line 1562: oe_debug_pub.add('END convert_miss_to_null in QPXUMLHB');

1558: IF l_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR THEN
1559: l_MODIFIER_LIST_rec.description := NULL;
1560: END IF;
1561:
1562: oe_debug_pub.add('END convert_miss_to_null in QPXUMLHB');
1563:
1564: RETURN l_MODIFIER_LIST_rec;
1565:
1566: END Convert_Miss_To_Null;

Line 1582: oe_debug_pub.add('BEGIN update_row in QPXUMLHB');

1578: l_start_date_active_second DATE;
1579: l_end_date_active_second DATE;
1580: BEGIN
1581:
1582: oe_debug_pub.add('BEGIN update_row in QPXUMLHB');
1583:
1584: -- MKARYA - Correct the first and second active dates value, for bug 1744890
1585: l_active_date_first_type := p_MODIFIER_LIST_rec.active_date_first_type;
1586: l_start_date_active_first := p_MODIFIER_LIST_rec.start_date_active_first;

Line 1793: oe_debug_pub.add('BEGIN insert_row in QPXUMLHB');

1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1790:
1791: End;
1792:
1793: oe_debug_pub.add('BEGIN insert_row in QPXUMLHB');
1794:
1795: -- MKARYA - Correct the first and second active dates value, for bug 1744890
1796: l_active_date_first_type := p_MODIFIER_LIST_rec.active_date_first_type;
1797: l_start_date_active_first := p_MODIFIER_LIST_rec.start_date_active_first;

Line 1934: oe_debug_pub.add('insert QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));

1930: QP_Security.create_default_grants( p_instance_type => QP_Security.G_MODIFIER_OBJECT,
1931: p_instance_pk1 => p_MODIFIER_LIST_rec.list_header_id,
1932: x_return_status => x_result);
1933:
1934: oe_debug_pub.add('insert QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
1935:
1936:
1937: IF p_MODIFIER_LIST_rec.gsa_indicator = 'Y'
1938: THEN

Line 1947: oe_debug_pub.add('l_ret_sts'||l_return_status);

1943: 'GSA',
1944: l_return_status );
1945: END IF;
1946:
1947: oe_debug_pub.add('l_ret_sts'||l_return_status);
1948: /*added this code to raise exception if qualifier does not get created-spgopal*/
1949:
1950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1951: oe_debug_pub.add('l_ret_sts if'||l_return_status);

Line 1951: oe_debug_pub.add('l_ret_sts if'||l_return_status);

1947: oe_debug_pub.add('l_ret_sts'||l_return_status);
1948: /*added this code to raise exception if qualifier does not get created-spgopal*/
1949:
1950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1951: oe_debug_pub.add('l_ret_sts if'||l_return_status);
1952: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1953: OE_MSG_PUB.Add;
1954:
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1957: oe_debug_pub.add('l_ret_sts else '||l_return_status);

1953: OE_MSG_PUB.Add;
1954:
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1957: oe_debug_pub.add('l_ret_sts else '||l_return_status);
1958: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1959: OE_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;
1961: END IF;

Line 1965: oe_debug_pub.add('insert after QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));

1961: END IF;
1962:
1963:
1964:
1965: oe_debug_pub.add('insert after QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
1966: oe_debug_pub.add('END insert_row in QPXUMLHB');
1967: EXCEPTION
1968:
1969: WHEN FND_API.G_EXC_ERROR THEN

Line 1966: oe_debug_pub.add('END insert_row in QPXUMLHB');

1962:
1963:
1964:
1965: oe_debug_pub.add('insert after QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
1966: oe_debug_pub.add('END insert_row in QPXUMLHB');
1967: EXCEPTION
1968:
1969: WHEN FND_API.G_EXC_ERROR THEN
1970:

Line 2048: oe_debug_pub.add('BEGIN delete_row in QPXUMLHB');

2044: WHERE list_header_id = a_list_header_id;
2045:
2046: BEGIN
2047:
2048: oe_debug_pub.add('BEGIN delete_row in QPXUMLHB');
2049:
2050: FOR list_lines in C1(p_list_header_id)
2051: LOOP
2052:

Line 2073: oe_debug_pub.add('END delete_row in QPXUMLHB');

2069:
2070: DELETE FROM QP_LIST_HEADERS_B
2071: WHERE LIST_HEADER_ID = p_list_header_id ;
2072:
2073: oe_debug_pub.add('END delete_row in QPXUMLHB');
2074: EXCEPTION
2075:
2076: WHEN OTHERS THEN
2077:

Line 2099: oe_debug_pub.add('BEGIN query_row in QPXUMLHB');

2095: IS
2096: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2097: BEGIN
2098:
2099: oe_debug_pub.add('BEGIN query_row in QPXUMLHB');
2100:
2101: SELECT ATTRIBUTE1
2102: , ATTRIBUTE10
2103: , ATTRIBUTE11

Line 2227: oe_debug_pub.add('version_no QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);

2223: FROM qp_list_headers_tl
2224: WHERE LIST_HEADER_ID = p_list_header_id
2225: AND LANGUAGE = userenv('LANG');
2226:
2227: oe_debug_pub.add('version_no QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);
2228: oe_debug_pub.add('END query_row in QPXUMLHB');
2229: RETURN l_MODIFIER_LIST_rec;
2230:
2231: EXCEPTION

Line 2228: oe_debug_pub.add('END query_row in QPXUMLHB');

2224: WHERE LIST_HEADER_ID = p_list_header_id
2225: AND LANGUAGE = userenv('LANG');
2226:
2227: oe_debug_pub.add('version_no QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);
2228: oe_debug_pub.add('END query_row in QPXUMLHB');
2229: RETURN l_MODIFIER_LIST_rec;
2230:
2231: EXCEPTION
2232:

Line 2262: oe_debug_pub.add('BEGIN lock_row in QPXUMLHB');

2258: IS
2259: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2260: BEGIN
2261:
2262: oe_debug_pub.add('BEGIN lock_row in QPXUMLHB');
2263:
2264: SELECT ATTRIBUTE1
2265: , ATTRIBUTE10
2266: , ATTRIBUTE11

Line 2529: oe_debug_pub.add('END lock_row in QPXUMLHB');

2525: END IF;
2526:
2527: END IF;
2528:
2529: oe_debug_pub.add('END lock_row in QPXUMLHB');
2530: EXCEPTION
2531:
2532: WHEN NO_DATA_FOUND THEN
2533:

Line 2582: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');

2578: IS
2579: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2580: BEGIN
2581:
2582: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2583: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND
2584: p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2585: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2586: p_old_MODIFIER_LIST_rec.automatic_flag)

Line 2675: oe_debug_pub.add('END get_values in QPXUMLHB');

2671: END IF;
2672:
2673: RETURN l_MODIFIER_LIST_val_rec;
2674:
2675: oe_debug_pub.add('END get_values in QPXUMLHB');
2676: END Get_Values;
2677:
2678: -- Function Get_Ids
2679:

Line 2688: oe_debug_pub.add('BEGIN get_ids in QPXUMLHB');

2684: IS
2685: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2686: BEGIN
2687:
2688: oe_debug_pub.add('BEGIN get_ids in QPXUMLHB');
2689: -- initialize return_status.
2690:
2691: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2692:

Line 2968: oe_debug_pub.add('END get_ids in QPXUMLHB');

2964:
2965: END IF;
2966:
2967:
2968: oe_debug_pub.add('END get_ids in QPXUMLHB');
2969: RETURN l_MODIFIER_LIST_rec;
2970:
2971: END Get_Ids;
2972:

Line 2992: oe_debug_pub.add('Begin Get_Segment_Level_for_Group');

2988: l_final_segment_level VARCHAR2(30) := NULL;
2989:
2990:
2991: BEGIN
2992: oe_debug_pub.add('Begin Get_Segment_Level_for_Group');
2993: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2994: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2995: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2996: FOR l_rec in c_qualifiers

Line 2993: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);

2989:
2990:
2991: BEGIN
2992: oe_debug_pub.add('Begin Get_Segment_Level_for_Group');
2993: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2994: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2995: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2996: FOR l_rec in c_qualifiers
2997: LOOP

Line 2994: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);

2990:
2991: BEGIN
2992: oe_debug_pub.add('Begin Get_Segment_Level_for_Group');
2993: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2994: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2995: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2996: FOR l_rec in c_qualifiers
2997: LOOP
2998: l_current_segment_level := qp_util.get_segment_level(p_list_header_id

Line 2995: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);

2991: BEGIN
2992: oe_debug_pub.add('Begin Get_Segment_Level_for_Group');
2993: oe_debug_pub.add('p_list_header_id = ' || p_list_header_id);
2994: oe_debug_pub.add('p_list_line_id = ' || p_list_line_id);
2995: oe_debug_pub.add('p_qualifier_grouping_no = ' || p_qualifier_grouping_no);
2996: FOR l_rec in c_qualifiers
2997: LOOP
2998: l_current_segment_level := qp_util.get_segment_level(p_list_header_id
2999: ,l_rec.qualifier_context

Line 3057: oe_debug_pub.add('End Get_Segment_Level_for_Group');

3053: END LOOP;
3054:
3055: return(l_final_segment_level);
3056:
3057: oe_debug_pub.add('End Get_Segment_Level_for_Group');
3058: EXCEPTION
3059: WHEN FND_API.G_EXC_ERROR THEN
3060: return(null);
3061: