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_TOTALS_GRP dependencies on FND_API

Line 47: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

43: l_msg_data VARCHAR2(240);
44:
45: BEGIN
46:
47: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN
48:
49: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
50: THEN
51:

Line 57: RAISE FND_API.G_EXC_ERROR;

53: FND_MESSAGE.SET_TOKEN('PARAMETER','Header_Id');
54: OE_MSG_PUB.Add;
55:
56: END IF;
57: RAISE FND_API.G_EXC_ERROR;
58:
59: END IF;
60:
61: IF p_total_type is NULL OR p_total_type = FND_API.G_MISS_CHAR THEN

Line 61: IF p_total_type is NULL OR p_total_type = FND_API.G_MISS_CHAR THEN

57: RAISE FND_API.G_EXC_ERROR;
58:
59: END IF;
60:
61: IF p_total_type is NULL OR p_total_type = FND_API.G_MISS_CHAR THEN
62:
63: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
64: THEN
65:

Line 71: RAISE FND_API.G_EXC_ERROR;

67: FND_MESSAGE.SET_TOKEN('PARAMETER','Total_Type');
68: OE_MSG_PUB.Add;
69:
70: END IF;
71: RAISE FND_API.G_EXC_ERROR;
72:
73: END IF;
74:
75: -- For Order Level Totals

Line 76: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN

72:
73: END IF;
74:
75: -- For Order Level Totals
76: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
77:
78: OE_OE_TOTALS_SUMMARY.GLOBAL_TOTALS(p_header_id);
79: IF p_total_type = 'ALL' THEN
80:

Line 125: , p_all_charges => FND_API.G_FALSE

121: OE_CHARGE_PVT.GET_CHARGE_AMOUNT(
122: p_api_version_number => 1.0
123: , p_header_id => p_header_id
124: , p_line_id => p_line_id
125: , p_all_charges => FND_API.G_FALSE
126: , x_return_status => l_return_status
127: , x_msg_count => l_msg_count
128: , x_msg_data => l_msg_data
129: , x_charge_amount => l_charge_amount

Line 131: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

127: , x_msg_count => l_msg_count
128: , x_msg_data => l_msg_data
129: , x_charge_amount => l_charge_amount
130: );
131: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;

Line 132: RAISE FND_API.G_EXC_ERROR;

128: , x_msg_data => l_msg_data
129: , x_charge_amount => l_charge_amount
130: );
131: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:

Line 133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

129: , x_charge_amount => l_charge_amount
130: );
131: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: END IF;

Line 134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

130: );
131: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: END IF;
138: IF p_total_type = 'ALL' THEN

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152:
153: WHEN NO_DATA_FOUND THEN
154: RETURN 0;
155: WHEN OTHERS THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157:
158: END Get_Order_Total;
159:
160: FUNCTION Get_Rec_Order_Total

Line 176: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

172: l_msg_data VARCHAR2(240);
173:
174: BEGIN
175:
176: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN
177:
178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
179: THEN
180:

Line 186: RAISE FND_API.G_EXC_ERROR;

182: FND_MESSAGE.SET_TOKEN('PARAMETER','Header_Id');
183: OE_MSG_PUB.Add;
184:
185: END IF;
186: RAISE FND_API.G_EXC_ERROR;
187:
188: END IF;
189:
190: IF p_total_type is NULL OR p_total_type = FND_API.G_MISS_CHAR THEN

Line 190: IF p_total_type is NULL OR p_total_type = FND_API.G_MISS_CHAR THEN

186: RAISE FND_API.G_EXC_ERROR;
187:
188: END IF;
189:
190: IF p_total_type is NULL OR p_total_type = FND_API.G_MISS_CHAR THEN
191:
192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
193: THEN
194:

Line 200: RAISE FND_API.G_EXC_ERROR;

196: FND_MESSAGE.SET_TOKEN('PARAMETER','Total_Type');
197: OE_MSG_PUB.Add;
198:
199: END IF;
200: RAISE FND_API.G_EXC_ERROR;
201:
202: END IF;
203:
204: -- For Order Level Totals

Line 205: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN

201:
202: END IF;
203:
204: -- For Order Level Totals
205: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
206:
207: OE_OE_TOTALS_SUMMARY.GLOBAL_REC_TOTALS(p_header_id,p_charge_periodicity_code);
208: IF p_total_type = 'ALL' THEN
209:

Line 254: , p_all_charges => FND_API.G_FALSE

250: OE_CHARGE_PVT.GET_CHARGE_AMOUNT(
251: p_api_version_number => 1.0
252: , p_header_id => p_header_id
253: , p_line_id => p_line_id
254: , p_all_charges => FND_API.G_FALSE
255: , x_return_status => l_return_status
256: , x_msg_count => l_msg_count
257: , x_msg_data => l_msg_data
258: , x_charge_amount => l_charge_amount

Line 260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

256: , x_msg_count => l_msg_count
257: , x_msg_data => l_msg_data
258: , x_charge_amount => l_charge_amount
259: );
260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE FND_API.G_EXC_ERROR;
262: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;

Line 261: RAISE FND_API.G_EXC_ERROR;

257: , x_msg_data => l_msg_data
258: , x_charge_amount => l_charge_amount
259: );
260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE FND_API.G_EXC_ERROR;
262: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:

Line 262: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

258: , x_charge_amount => l_charge_amount
259: );
260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE FND_API.G_EXC_ERROR;
262: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:
266: END IF;

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: );
260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE FND_API.G_EXC_ERROR;
262: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265:
266: END IF;
267: IF p_total_type = 'ALL' THEN

Line 285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

281:
282: WHEN NO_DATA_FOUND THEN
283: RETURN 0;
284: WHEN OTHERS THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286:
287: END Get_Rec_Order_Total;
288:
289: PROCEDURE GET_RECURRING_TOTALS

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

298: );
299: EXCEPTION
300:
301: WHEN OTHERS THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303:
304: END GET_RECURRING_TOTALS;
305:
306: --Pay Now Pay Later project

Line 342: l_return_status := FND_API.G_RET_STS_SUCCESS;

338: BEGIN
339: IF l_debug_level > 0 THEN
340: oe_debug_pub.add('ENTERING OE_TOTALS_GRP.GET_PAYNOW_TOTAL');
341: END IF;
342: l_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344:
345: IF (p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM) AND
346: (p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM) THEN

Line 345: IF (p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM) AND

341: END IF;
342: l_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344:
345: IF (p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM) AND
346: (p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM) THEN
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add('Both header_id and line_id are either null or FND_API.G_MISS_NUM... Returning from the function');
349: END IF;

Line 346: (p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM) THEN

342: l_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344:
345: IF (p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM) AND
346: (p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM) THEN
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add('Both header_id and line_id are either null or FND_API.G_MISS_NUM... Returning from the function');
349: END IF;
350: RETURN 0;

Line 348: oe_debug_pub.add('Both header_id and line_id are either null or FND_API.G_MISS_NUM... Returning from the function');

344:
345: IF (p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM) AND
346: (p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM) THEN
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add('Both header_id and line_id are either null or FND_API.G_MISS_NUM... Returning from the function');
349: END IF;
350: RETURN 0;
351: END IF;
352:

Line 353: IF p_header_id IS NOT NULL AND p_header_id <> FND_API.G_MISS_NUM THEN

349: END IF;
350: RETURN 0;
351: END IF;
352:
353: IF p_header_id IS NOT NULL AND p_header_id <> FND_API.G_MISS_NUM THEN
354: OE_Order_Cache.load_order_header(p_header_id);
355: l_org_id := OE_Order_Cache.g_header_rec.org_id;
356:
357: ELSE

Line 378: p_line_id <> FND_API.G_MISS_NUM THEN

374: RETURN 0;
375: END IF;
376:
377: IF p_line_id IS NOT NULL AND
378: p_line_id <> FND_API.G_MISS_NUM THEN
379: -- this is for line payment
380: SELECT line_id
381: ,header_id
382: ,payment_term_id

Line 443: p_line_id = FND_API.G_MISS_NUM THEN

439:
440: i := l_pay_now_total_detail_tbl.count + 1;
441: -- append header level charges to the detail line table
442: IF p_line_id IS NULL OR
443: p_line_id = FND_API.G_MISS_NUM THEN
444: l_pay_now_total_detail_tbl(i).line_id := null;
445: l_pay_now_total_detail_tbl(i).line_amount :=0;
446: l_pay_now_total_detail_tbl(i).tax_amount :=0;
447: l_pay_now_total_detail_tbl(i).freight_amount :=

Line 459: ,p_init_msg_list => FND_API.G_TRUE

455: -- calling AR API to get pay now total
456: MO_GLOBAL.set_policy_context('S',l_org_id);
457: AR_VIEW_TERM_GRP.pay_now_amounts
458: (p_api_version => 1.0
459: ,p_init_msg_list => FND_API.G_TRUE
460: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
461: ,p_currency_code => l_currency_code
462: ,p_amounts_tbl => l_pay_now_total_detail_tbl
463: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec

Line 460: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

456: MO_GLOBAL.set_policy_context('S',l_org_id);
457: AR_VIEW_TERM_GRP.pay_now_amounts
458: (p_api_version => 1.0
459: ,p_init_msg_list => FND_API.G_TRUE
460: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
461: ,p_currency_code => l_currency_code
462: ,p_amounts_tbl => l_pay_now_total_detail_tbl
463: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec
464: ,x_return_status => l_return_status

Line 469: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

465: ,x_msg_count => l_msg_count
466: ,x_msg_data => l_msg_data
467: );
468:
469: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
470: IF l_msg_count = 1 THEN
471: IF l_debug_level > 0 THEN
472: oe_debug_pub.add('Error message after calling AR_VIEW_TERM_GRP.pay_now_amounts API: '||l_msg_data , 3 ) ;
473: END IF;

Line 478: l_msg_data := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

474: oe_msg_pub.add_text(p_message_text => l_msg_data);
475: ELSIF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
476: arp_util.enable_debug;
477: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
478: l_msg_data := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( L_MSG_DATA , 3 ) ;
481: END IF;
482: oe_msg_pub.add_text(p_message_text => l_msg_data);

Line 487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

483: END LOOP;
484: END IF;
485: END IF;
486:
487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;

Line 488: RAISE FND_API.G_EXC_ERROR;

484: END IF;
485: END IF;
486:
487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:

Line 489: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

485: END IF;
486:
487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:
493: IF l_debug_level > 0 THEN

Line 490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486:
487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
488: RAISE FND_API.G_EXC_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:
493: IF l_debug_level > 0 THEN
494: oe_debug_pub.add('TOTAL AMOUNT -> ' ||nvl(l_pay_now_total_summary_rec.total_amount, 0));

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

525: (G_PKG_NAME
526: ,l_api_name
527: );
528: END IF;
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530:
531: END Get_PayNow_Total;
532:
533: END OE_Totals_GRP;