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

Line 118: oe_debug_pub.ADD('Profile OM: Party Total Currency is not set', 2);

114: -- Open the HZ_PARTY cursor for update;
115: l_cust_currency_code := fnd_profile.value('OM_CUST_TOTAL_CURRENCY');
116:
117: IF l_cust_currency_code IS NULL THEN
118: oe_debug_pub.ADD('Profile OM: Party Total Currency is not set', 2);
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121: oe_debug_pub.ADD('The Party Total Currency is '||l_cust_currency_code, 2);
122: FOR C1 IN C_PARTIES LOOP

Line 121: oe_debug_pub.ADD('The Party Total Currency is '||l_cust_currency_code, 2);

117: IF l_cust_currency_code IS NULL THEN
118: oe_debug_pub.ADD('Profile OM: Party Total Currency is not set', 2);
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121: oe_debug_pub.ADD('The Party Total Currency is '||l_cust_currency_code, 2);
122: FOR C1 IN C_PARTIES LOOP
123: BEGIN
124: -- Open the Order Header Cursor
125: l_party_total := 0;

Line 149: oe_debug_pub.ADD('Set Of Books currency does not exist for order '||to_char(c2.order_number), 2);

145: -- Get the Set Of Books currency
146: l_sob_currency_code := OE_Upgrade_Misc.GET_SOB_CURRENCY(c2.org_id);
147:
148: IF l_sob_currency_code IS NULL THEN
149: oe_debug_pub.ADD('Set Of Books currency does not exist for order '||to_char(c2.order_number), 2);
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: l_converted_total := NVL(l_line_total,0) +

Line 175: oe_debug_pub.ADD('Error in currency conversion from Order to SOB currency for order '||to_char(c2.order_number), 2);

171: l_return_status,
172: l_converted_total_new
173: );
174: IF l_return_status <> 'S' THEN
175: oe_debug_pub.ADD('Error in currency conversion from Order to SOB currency for order '||to_char(c2.order_number), 2);
176: RAISE ERROR_IN_CURRENCY_CONVERSION;
177: END IF;
178:
179: if l_converted_total_new is not null then

Line 210: oe_debug_pub.ADD('Error in currency conversion from SOB to Party Total currency for order '||to_char(c2.order_number), 2);

206: l_return_status,
207: l_converted_total_new
208: );
209: IF l_return_status <> 'S' THEN
210: oe_debug_pub.ADD('Error in currency conversion from SOB to Party Total currency for order '||to_char(c2.order_number), 2);
211: RAISE ERROR_IN_CURRENCY_CONVERSION;
212: END IF;
213: if l_converted_total_new is not null then
214: l_converted_total := l_converted_total_new;

Line 241: oe_debug_pub.ADD('Error in processing Order '||to_char(c2.order_number) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);

237: EXCEPTION
238: WHEN OTHERS THEN
239: v_errcode := SQLCODE;
240: v_errmsg := SQLERRM;
241: oe_debug_pub.ADD('Error in processing Order '||to_char(c2.order_number) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);
242: END;
243: END LOOP; -- End Loop For C_ORDER_HEADER
244:
245: IF NOT (l_party_total = 0 AND l_order_count = 0 AND

Line 253: oe_debug_pub.ADD('The Party Total was '||to_char(l_party_total), 2);

249: IF l_order_count = 0 THEN
250: l_order_count := NULL;
251: END IF;
252:
253: oe_debug_pub.ADD('The Party Total was '||to_char(l_party_total), 2);
254: Update_HZ_Parties(p_party_id => C1.party_id
255: , p_party_type => C1.party_type
256: , p_last_update_date => C1.last_update_date
257: , p_party_total => l_party_total

Line 263: oe_debug_pub.ADD('Error in updating the Party record for party '||to_char(c1.party_id), 2);

259: , p_last_order_date => l_last_order_date
260: , x_return_status => l_return_status
261: );
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: oe_debug_pub.ADD('Error in updating the Party record for party '||to_char(c1.party_id), 2);
264: END IF;
265: END IF;
266:
267: EXCEPTION

Line 269: oe_debug_pub.ADD('No Order for PARTY '||to_char(C1.party_id), 2);

265: END IF;
266:
267: EXCEPTION
268: WHEN NO_DATA_FOUND THEN
269: oe_debug_pub.ADD('No Order for PARTY '||to_char(C1.party_id), 2);
270:
271: WHEN OTHERS THEN
272: v_errcode := SQLCODE;
273: v_errmsg := SQLERRM;

Line 274: oe_debug_pub.ADD('Error in processing Party '||to_char(c1.party_id) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);

270:
271: WHEN OTHERS THEN
272: v_errcode := SQLCODE;
273: v_errmsg := SQLERRM;
274: oe_debug_pub.ADD('Error in processing Party '||to_char(c1.party_id) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);
275: END;
276: l_commit_ctr := l_commit_ctr + 1;
277: IF l_commit_ctr > 500 THEN
278: commit;

Line 292: oe_debug_pub.ADD('Error in processing Parties '|| ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);

288: EXCEPTION
289: WHEN OTHERS THEN
290: v_errcode := SQLCODE;
291: v_errmsg := SQLERRM;
292: oe_debug_pub.ADD('Error in processing Parties '|| ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);
293: retcode := 2;
294: END Update_Party_Totals;
295:
296: PROCEDURE Update_HZ_Parties(p_party_id IN NUMBER

Line 330: oe_debug_pub.ADD('Invalid Party type for PARTY '||to_char(p_party_id), 2);

326: last_ordered_date = p_last_order_date
327: WHERE party_id = p_party_id;
328:
329: ELSE
330: oe_debug_pub.ADD('Invalid Party type for PARTY '||to_char(p_party_id), 2);
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: END IF;
333:
334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 341: oe_debug_pub.add(substr(l_msg_data,1,255),2);

337:
338: FOR k in 1 .. l_msg_count LOOP
339: l_msg_data := fnd_msg_pub.get( p_msg_index => k,
340: p_encoded => 'F');
341: oe_debug_pub.add(substr(l_msg_data,1,255),2);
342: END LOOP;
343:
344: END IF;
345: ELSE

Line 346: oe_debug_pub.ADD('Success in Processing PARTY '||to_char(p_party_id), 2);

342: END LOOP;
343:
344: END IF;
345: ELSE
346: oe_debug_pub.ADD('Success in Processing PARTY '||to_char(p_party_id), 2);
347: END IF;
348: x_return_status := l_return_status;
349: EXCEPTION
350: WHEN OTHERS THEN

Line 353: oe_debug_pub.ADD('Error in updating the Party '||to_char(p_party_id) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);

349: EXCEPTION
350: WHEN OTHERS THEN
351: v_errcode := SQLCODE;
352: v_errmsg := SQLERRM;
353: oe_debug_pub.ADD('Error in updating the Party '||to_char(p_party_id) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);
354: x_return_status := FND_API.G_RET_STS_ERROR;
355:
356: END Update_HZ_Parties;
357: