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.

[Home] [Help]

APPS.OE_OE_TOTALS_SUMMARY dependencies on FND_API

Line 145: p_init_msg_list => FND_API.G_FALSE ,

141: -- Calling the charges API to get the Order Total for charges.
142:
143: OE_CHARGE_PVT.Get_Charge_Amount(
144: p_api_version_number => 1.1 ,
145: p_init_msg_list => FND_API.G_FALSE ,
146: p_header_id => p_header_id ,
147: p_line_id => NULL,
148: p_all_charges => FND_API.G_TRUE ,
149: x_return_status => l_return_status ,

Line 148: p_all_charges => FND_API.G_TRUE ,

144: p_api_version_number => 1.1 ,
145: p_init_msg_list => FND_API.G_FALSE ,
146: p_header_id => p_header_id ,
147: p_line_id => NULL,
148: p_all_charges => FND_API.G_TRUE ,
149: x_return_status => l_return_status ,
150: x_msg_count => l_msg_count ,
151: x_msg_data => l_msg_data ,
152: x_charge_amount => l_charge_total

Line 154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

150: x_msg_count => l_msg_count ,
151: x_msg_data => l_msg_data ,
152: x_charge_amount => l_charge_total
153: );
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: x_msg_data => l_msg_data ,
152: x_charge_amount => l_charge_total
153: );
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:

Line 156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

152: x_charge_amount => l_charge_total
153: );
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: RETURN l_charge_total;

Line 157: RAISE FND_API.G_EXC_ERROR;

153: );
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: RETURN l_charge_total;
161:

Line 188: p_init_msg_list => FND_API.G_FALSE ,

184: -- Calling the charges API to get the Order Total for charges.
185:
186: OE_CHARGE_PVT.Get_Charge_Amount(
187: p_api_version_number => 1.1 ,
188: p_init_msg_list => FND_API.G_FALSE ,
189: p_header_id => p_header_id ,
190: p_line_id => p_line_id,
191: p_all_charges => FND_API.G_FALSE ,
192: x_return_status => l_return_status ,

Line 191: p_all_charges => FND_API.G_FALSE ,

187: p_api_version_number => 1.1 ,
188: p_init_msg_list => FND_API.G_FALSE ,
189: p_header_id => p_header_id ,
190: p_line_id => p_line_id,
191: p_all_charges => FND_API.G_FALSE ,
192: x_return_status => l_return_status ,
193: x_msg_count => l_msg_count ,
194: x_msg_data => l_msg_data ,
195: x_charge_amount => l_charge_total

Line 197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

193: x_msg_count => l_msg_count ,
194: x_msg_data => l_msg_data ,
195: x_charge_amount => l_charge_total
196: );
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: x_msg_data => l_msg_data ,
195: x_charge_amount => l_charge_total
196: );
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:

Line 199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

195: x_charge_amount => l_charge_total
196: );
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:
203: RETURN l_charge_total;

Line 200: RAISE FND_API.G_EXC_ERROR;

196: );
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:
203: RETURN l_charge_total;
204:

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: EXCEPTION
296: WHEN no_data_found THEN
297: Null;
298: WHEN too_many_rows THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: WHEN others THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END LINE_TOTAL;
303:

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: Null;
298: WHEN too_many_rows THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: WHEN others THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END LINE_TOTAL;
303:
304: /* bug - 1480491 */
305: FUNCTION SERVICE_TOTAL

Line 345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

341: EXCEPTION
342: WHEN no_data_found THEN
343: Null;
344: WHEN too_many_rows THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: WHEN others THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END SERVICE_TOTAL;
349: /* bug - 1480491 */

Line 347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

343: Null;
344: WHEN too_many_rows THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: WHEN others THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END SERVICE_TOTAL;
349: /* bug - 1480491 */
350:
351: PROCEDURE GLOBAL_TOTALS(p_header_id IN NUMBER)

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

397: WHEN too_many_rows THEN
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
400: END IF;
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: WHEN no_data_found THEN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('No Data found'||p_header_id,1) ;
405: END IF;

Line 410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

406: WHEN others THEN
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
409: END IF;
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: END GLOBAL_TOTALS;
412:
413: FUNCTION CONFIG_TOTALS
414: (

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: RETURN(l_config_total);
432:
433: EXCEPTION
434: WHEN too_many_rows THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436:
437: WHEN no_data_found THEN
438: Null;
439:

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

437: WHEN no_data_found THEN
438: Null;
439:
440: WHEN others THEN
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442:
443: END CONFIG_TOTALS;
444:
445: FUNCTION TOTAL_ORDERED_QTY

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473: EXCEPTION
474: WHEN no_data_found THEN
475: Null;
476: WHEN too_many_rows THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: WHEN others THEN
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END TOTAL_ORDERED_QTY;
481:

Line 479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

475: Null;
476: WHEN too_many_rows THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: WHEN others THEN
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END TOTAL_ORDERED_QTY;
481:
482: PROCEDURE ORDER_TOTALS
483: (

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778: WHEN OTHERS THEN
779: IF l_debug_level > 0 THEN
780: oe_debug_pub.add( 'FROM OUTBOUND TOTAL OTHERS' ) ;
781: END IF;
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783:
784: END OUTBOUND_ORDER_TOTAL;
785:
786: FUNCTION OUTBOUND_ORDER_SUBTOTAL

Line 830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

826: WHEN OTHERS THEN
827: IF l_debug_level > 0 THEN
828: oe_debug_pub.add( 'FROM OUTBOUND SUBTOTAL OTHERS' ) ;
829: END IF;
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831:
832: END OUTBOUND_ORDER_SUBTOTAL;
833:
834: --------------------------------------------------------------------------------------

Line 881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

877: WHEN too_many_rows THEN
878: IF l_debug_level > 0 THEN
879: oe_debug_pub.add( ' TOO MANY ROWS' ) ;
880: END IF;
881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882:
883: WHEN no_data_found THEN
884: IF l_debug_level > 0 THEN
885: oe_debug_pub.add( ' FROM NO DATA FOUND' ) ;

Line 893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

889: WHEN others THEN
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add( ' FROM OTHERS' ) ;
892: END IF;
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894:
895: END get_order_amount;
896:
897:

Line 953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

949: ( G_PKG_NAME
950: , 'GET_DISCOUNT'
951: );
952: END IF;
953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
954: END GET_DISCOUNT;
955:
956:
957: /* Recurring charges */

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992: EXCEPTION
993:
994: WHEN too_many_rows THEN
995: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: WHEN no_data_found THEN
998: IF l_debug_level > 0 THEN
999: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1000: END IF;

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: WHEN others THEN
1002: IF l_debug_level > 0 THEN
1003: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
1004: END IF;
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006:
1007: END GLOBAL_REC_TOTALS;
1008:
1009: FUNCTION Rec_TAXES

Line 1069: p_init_msg_list => FND_API.G_FALSE ,

1065: END IF;
1066:
1067: OE_CHARGE_PVT.Get_Rec_Charge_Amount(
1068: p_api_version_number => 1.1 ,
1069: p_init_msg_list => FND_API.G_FALSE ,
1070: p_header_id => p_header_id ,
1071: p_line_id => NULL,
1072: p_all_charges => FND_API.G_TRUE ,
1073: p_charge_periodicity_code =>p_charge_periodicity_code,

Line 1072: p_all_charges => FND_API.G_TRUE ,

1068: p_api_version_number => 1.1 ,
1069: p_init_msg_list => FND_API.G_FALSE ,
1070: p_header_id => p_header_id ,
1071: p_line_id => NULL,
1072: p_all_charges => FND_API.G_TRUE ,
1073: p_charge_periodicity_code =>p_charge_periodicity_code,
1074: x_return_status => l_return_status ,
1075: x_msg_count => l_msg_count ,
1076: x_msg_data => l_msg_data ,

Line 1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1075: x_msg_count => l_msg_count ,
1076: x_msg_data => l_msg_data ,
1077: x_charge_amount => l_charge_total
1078: );
1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;

Line 1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1076: x_msg_data => l_msg_data ,
1077: x_charge_amount => l_charge_total
1078: );
1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:

Line 1081: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1077: x_charge_amount => l_charge_total
1078: );
1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:
1085: RETURN l_charge_total;

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: );
1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:
1085: RETURN l_charge_total;
1086:

Line 1604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1600:
1601: EXCEPTION
1602: WHEN too_many_rows THEN
1603: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
1604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1605: WHEN no_data_found THEN
1606: IF l_debug_level > 0 THEN
1607: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1608: END IF;

Line 1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1609: WHEN others THEN
1610: IF l_debug_level > 0 THEN
1611: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
1612: END IF;
1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614:
1615: END PRN_REC_SUBTOTALS;
1616:
1617: FUNCTION PRN_REC_TAXES

Line 1644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1640:
1641: EXCEPTION
1642: WHEN too_many_rows THEN
1643: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
1644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1645: WHEN no_data_found THEN
1646: IF l_debug_level > 0 THEN
1647: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1648: END IF;

Line 1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1649: WHEN others THEN
1650: IF l_debug_level > 0 THEN
1651: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
1652: END IF;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654:
1655: END PRN_REC_TAXES;
1656:
1657: FUNCTION PRN_REC_TOTALS

Line 1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1689:
1690: EXCEPTION
1691: WHEN too_many_rows THEN
1692: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: WHEN no_data_found THEN
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1697: END IF;

Line 1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1698: WHEN others THEN
1699: IF l_debug_level > 0 THEN
1700: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
1701: END IF;
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703:
1704: END PRN_REC_TOTALS;
1705:
1706: END OE_OE_TOTALS_SUMMARY;