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

Line 21: oe_debug_pub.add('Entering get_status');

17: total_count NUMBER;
18: l_flow_status_code VARCHAR2(80);
19: BEGIN
20: --IF l_debug_level > 0 THEN
21: oe_debug_pub.add('Entering get_status');
22: oe_debug_pub.add('Flow Status Code:'||p_flow_status_code);
23: --END IF;
24:
25: l_flow_status_code := p_flow_status_code;

Line 22: oe_debug_pub.add('Flow Status Code:'||p_flow_status_code);

18: l_flow_status_code VARCHAR2(80);
19: BEGIN
20: --IF l_debug_level > 0 THEN
21: oe_debug_pub.add('Entering get_status');
22: oe_debug_pub.add('Flow Status Code:'||p_flow_status_code);
23: --END IF;
24:
25: l_flow_status_code := p_flow_status_code;
26:

Line 69: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

65: ,p_changed_attribute IN VARCHAR2 := NULL
66: ,x_return_status IN OUT NOCOPY VARCHAR2)
67: IS
68: l_api_name VARCHAR2(30) := 'Create_Version_History';
69: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
70: l_version_number NUMBER;
71: l_version_flag VARCHAR2(1);
72: l_instrument_id NUMBER;
73: l_credit_card_number VARCHAR2(10);

Line 140: oe_debug_pub.add( 'p_changed_attr is : ' || p_changed_attribute) ;

136: IF l_instrument_id IS NOT NULL THEN
137: IF p_changed_attribute IS NOT NULL THEN
138:
139: IF l_debug_level > 0 THEN
140: oe_debug_pub.add( 'p_changed_attr is : ' || p_changed_attribute) ;
141: END IF;
142:
143: -- store the instrument_id in column instruemnt_id
144: -- if credit_card_number or credit_card_code is updated.

Line 191: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;

187: **/
188:
189: END IF;
190: IF l_debug_level > 0 THEN
191: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
192: END IF;
193: END IF;
194:
195:

Line 558: oe_debug_pub.add(' No. of History Records for Header ' ||SQL%ROWCOUNT);

554: WHERE a.header_id = b.header_id
555: AND b.version_number = l_version_number
556: AND b.version_flag = l_version_flag);
557: IF l_debug_level > 0 THEN
558: oe_debug_pub.add(' No. of History Records for Header ' ||SQL%ROWCOUNT);
559: END IF;
560:
561: -- Create History Records for Lines
562: l_api_name := 'Create_Line_History';

Line 1281: oe_debug_pub.add(' No. of History Records for Lines ' ||SQL%ROWCOUNT);

1277: AND a.header_id = b.header_id
1278: AND b.version_number = l_version_number
1279: AND b.version_flag = l_version_flag);
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add(' No. of History Records for Lines ' ||SQL%ROWCOUNT);
1282: END IF;
1283:
1284: -- Create History Records for Adjustments
1285: l_api_name := 'Create_Price_Adjs_History';

Line 1514: oe_debug_pub.add(' No. of History Records for PrcAdjs ' ||SQL%ROWCOUNT);

1510: AND b.version_number = l_version_number
1511: AND b.version_flag = l_version_flag);
1512:
1513: IF l_debug_level > 0 THEN
1514: oe_debug_pub.add(' No. of History Records for PrcAdjs ' ||SQL%ROWCOUNT);
1515: END IF;
1516:
1517: -- Create History Records for SalesCredits
1518: l_api_name := 'Create_Sales_Credits_History';

Line 1615: oe_debug_pub.add(' No. of History Records for Sales Credits '||SQL%ROWCOUNT);

1611: AND b.VERSION_NUMBER = l_version_number
1612: AND b.version_flag = l_version_flag);
1613:
1614: IF l_debug_level > 0 THEN
1615: oe_debug_pub.add(' No. of History Records for Sales Credits '||SQL%ROWCOUNT);
1616: END IF;
1617:
1618: EXCEPTION
1619: WHEN OTHERS THEN

Line 1796: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1792: )
1793: IS
1794: l_version_number NUMBER := p_version_number;
1795: l_current_version_number NUMBER;
1796: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1797:
1798: BEGIN
1799: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
1800: l_current_version_number := Get_Version_Number(p_header_id => p_header_id);

Line 1811: oe_debug_pub.add('Entering OE_VERSIONING_UTIL.QUERY_ROW for header', 1);

1807: IF l_version_number IS NULL THEN
1808: OE_Header_Util.Query_Row(p_header_id => p_header_id, x_header_rec => x_header_rec);
1809: ELSE
1810:
1811: oe_debug_pub.add('Entering OE_VERSIONING_UTIL.QUERY_ROW for header', 1);
1812:
1813: SELECT ACCOUNTING_RULE_ID
1814: , ACCOUNTING_RULE_DURATION
1815: , AGREEMENT_ID

Line 2152: oe_debug_pub.add('Calling query card details...');

2148: IF x_header_rec.payment_type_code IS NOT NULL AND
2149: x_header_rec.payment_type_code = 'CREDIT_CARD'
2150: AND x_header_rec.credit_card_number is null THEN
2151: if l_debug_level > 0 then
2152: oe_debug_pub.add('Calling query card details...');
2153: end if;
2154: OE_Header_Util.Query_card_details
2155: ( p_header_id => x_header_rec.header_id,
2156: p_credit_card_code => x_header_rec.credit_card_code,

Line 2192: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2188:
2189: l_version_number NUMBER := p_version_number;
2190: l_current_version_number NUMBER;
2191: --
2192: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2193: --
2194: BEGIN
2195: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2196: l_current_version_number := Get_Version_Number(p_price_adjustment_id => p_price_adjustment_id);

Line 2207: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;

2203: IF l_version_number IS NULL THEN
2204: OE_Header_Adj_Util.Query_Row(p_price_adjustment_id => p_price_adjustment_id, x_header_adj_rec => x_header_adj_rec);
2205: ELSE
2206: IF l_debug_level > 0 THEN
2207: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
2208: END IF;
2209:
2210: G_INTERNAL_QUERY := TRUE;
2211: Query_Rows

Line 2220: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;

2216: x_Header_Adj_Rec := l_Header_Adj_Tbl(1);
2217: G_INTERNAL_QUERY := FALSE;
2218:
2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
2221: END IF;
2222:
2223: END IF;
2224:

Line 2687: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2683: l_version_number NUMBER := p_version_number;
2684: l_current_version_number NUMBER;
2685: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2686: --
2687: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2688: --
2689: BEGIN
2690: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2691: l_current_version_number := Get_Version_Number(p_sales_credit_id => p_sales_credit_id);

Line 4101: oe_debug_pub.add('Entering '||to_char(l_org_id), 1);

4097: OE_GLOBALS.Set_Context;
4098: l_org_id := OE_GLOBALS.G_ORG_ID;
4099: end if;
4100:
4101: oe_debug_pub.add('Entering '||to_char(l_org_id), 1);
4102:
4103:
4104: -- Loop over fetched records
4105:

Line 4427: -- oe_debug_pub.add('OEXULINB -aksingh -- assigning order_source_id value ' || l_rec.order_source_id);

4423: x_line_tbl(l_count).flow_status_code := l_rec.flow_status_code;
4424: -- x_line_tbl(l_count).marketing_source_code_id := l_rec.marketing_source_code_id;
4425: x_line_tbl(l_count).calculate_price_flag := l_rec.calculate_price_flag;
4426: x_line_tbl(l_count).commitment_id := l_rec.commitment_id;
4427: -- oe_debug_pub.add('OEXULINB -aksingh -- assigning order_source_id value ' || l_rec.order_source_id);
4428: x_line_tbl(l_count).order_source_id := l_rec.order_source_id;
4429: -- x_line_tbl(l_count).upgraded_flag := l_rec.upgraded_flag ;
4430: x_line_tbl(l_count).Original_Inventory_Item_Id := l_rec.Original_Inventory_Item_Id ;
4431: x_line_tbl(l_count).Original_item_identifier_Type := l_rec.Original_item_identifier_Type ;

Line 4464: -- oe_debug_pub.add('outside margin x_line_tbl',1);

4460: x_line_tbl(l_count).SUBSCRIPTION_ENABLE_FLAG := l_rec.SUBSCRIPTION_ENABLE_FLAG;
4461: x_line_tbl(l_count).SERVICE_FIRST_PERIOD_ENDDATE := l_rec.SERVICE_FIRST_PERIOD_ENDDATE;
4462: -- sol_ord_er #16014165 end
4463:
4464: -- oe_debug_pub.add('outside margin x_line_tbl',1);
4465: --MRG B
4466: --If OE_FEATURES_PVT.Is_Margin_Avail Then
4467: -- oe_debug_pub.add('inside margin x_line_tbl',1);
4468: --x_line_tbl(l_count).unit_cost:=l_rec.unit_cost;

Line 4467: -- oe_debug_pub.add('inside margin x_line_tbl',1);

4463:
4464: -- oe_debug_pub.add('outside margin x_line_tbl',1);
4465: --MRG B
4466: --If OE_FEATURES_PVT.Is_Margin_Avail Then
4467: -- oe_debug_pub.add('inside margin x_line_tbl',1);
4468: --x_line_tbl(l_count).unit_cost:=l_rec.unit_cost;
4469: --End If;
4470: --MRG E
4471: -- x_line_tbl(l_count).lock_control:= l_rec.lock_control;

Line 4930: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4926:
4927: l_rec l_line_adj_csr_p%ROWTYPE;
4928:
4929: --
4930: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4931: --
4932:
4933: BEGIN
4934: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN

Line 5138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

5134: l_current_version_number NUMBER;
5135:
5136: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5137: --
5138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5139: --
5140: BEGIN
5141: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
5142: l_current_version_number := Get_Version_Number(p_sales_credit_id => p_sales_credit_id);

Line 5154: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.QUERY_ROW' , 1 ) ;

5150: OE_Line_Scredit_Util.Query_Row(p_sales_credit_id => p_sales_credit_id, x_line_scredit_rec => x_line_scredit_rec);
5151: ELSE
5152:
5153: IF l_debug_level > 0 THEN
5154: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.QUERY_ROW' , 1 ) ;
5155: END IF;
5156:
5157: G_INTERNAL_QUERY := TRUE;
5158: Query_Rows

Line 5314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

5310: l_entity NUMBER;
5311: l_count NUMBER;
5312:
5313: --
5314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5315: --
5316: BEGIN
5317: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
5318: l_current_version_number := Get_Version_Number(p_header_id => p_header_id, p_line_id => p_line_id, p_sales_credit_id => p_sales_credit_id);

Line 5431: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.QUERY_ROWS' , 1 ) ;

5427:
5428: -- Return fetched table
5429:
5430: IF l_debug_level > 0 THEN
5431: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.QUERY_ROWS' , 1 ) ;
5432: END IF;
5433:
5434:
5435: END IF;