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_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 384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

380: WHEN too_many_rows THEN
381: IF l_debug_level > 0 THEN
382: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
383: END IF;
384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385: WHEN no_data_found THEN
386: IF l_debug_level > 0 THEN
387: oe_debug_pub.add('No Data found'||p_header_id,1) ;
388: END IF;

Line 393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

389: WHEN others THEN
390: IF l_debug_level > 0 THEN
391: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
392: END IF;
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END GLOBAL_TOTALS;
395:
396: FUNCTION CONFIG_TOTALS
397: (

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: RETURN(l_config_total);
415:
416: EXCEPTION
417: WHEN too_many_rows THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419:
420: WHEN no_data_found THEN
421: Null;
422:

Line 424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

420: WHEN no_data_found THEN
421: Null;
422:
423: WHEN others THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425:
426: END CONFIG_TOTALS;
427:
428: FUNCTION TOTAL_ORDERED_QTY

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456: EXCEPTION
457: WHEN no_data_found THEN
458: Null;
459: WHEN too_many_rows THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: WHEN others THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END TOTAL_ORDERED_QTY;
464:

Line 462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

458: Null;
459: WHEN too_many_rows THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: WHEN others THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END TOTAL_ORDERED_QTY;
464:
465: PROCEDURE ORDER_TOTALS
466: (

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: WHEN OTHERS THEN
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'FROM OUTBOUND TOTAL OTHERS' ) ;
757: END IF;
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759:
760: END OUTBOUND_ORDER_TOTAL;
761:
762: FUNCTION OUTBOUND_ORDER_SUBTOTAL

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: WHEN OTHERS THEN
803: IF l_debug_level > 0 THEN
804: oe_debug_pub.add( 'FROM OUTBOUND SUBTOTAL OTHERS' ) ;
805: END IF;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807:
808: END OUTBOUND_ORDER_SUBTOTAL;
809:
810: --------------------------------------------------------------------------------------

Line 857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

853: WHEN too_many_rows THEN
854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add( ' TOO MANY ROWS' ) ;
856: END IF;
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858:
859: WHEN no_data_found THEN
860: IF l_debug_level > 0 THEN
861: oe_debug_pub.add( ' FROM NO DATA FOUND' ) ;

Line 869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

865: WHEN others THEN
866: IF l_debug_level > 0 THEN
867: oe_debug_pub.add( ' FROM OTHERS' ) ;
868: END IF;
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870:
871: END get_order_amount;
872:
873:

Line 929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

925: ( G_PKG_NAME
926: , 'GET_DISCOUNT'
927: );
928: END IF;
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END GET_DISCOUNT;
931:
932:
933: /* Recurring charges */

Line 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

968: EXCEPTION
969:
970: WHEN too_many_rows THEN
971: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: WHEN no_data_found THEN
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('No Data found'||p_header_id,1) ;
976: END IF;

Line 981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

977: WHEN others THEN
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
980: END IF;
981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
982:
983: END GLOBAL_REC_TOTALS;
984:
985: FUNCTION Rec_TAXES

Line 1045: p_init_msg_list => FND_API.G_FALSE ,

1041: END IF;
1042:
1043: OE_CHARGE_PVT.Get_Rec_Charge_Amount(
1044: p_api_version_number => 1.1 ,
1045: p_init_msg_list => FND_API.G_FALSE ,
1046: p_header_id => p_header_id ,
1047: p_line_id => NULL,
1048: p_all_charges => FND_API.G_TRUE ,
1049: p_charge_periodicity_code =>p_charge_periodicity_code,

Line 1048: p_all_charges => FND_API.G_TRUE ,

1044: p_api_version_number => 1.1 ,
1045: p_init_msg_list => FND_API.G_FALSE ,
1046: p_header_id => p_header_id ,
1047: p_line_id => NULL,
1048: p_all_charges => FND_API.G_TRUE ,
1049: p_charge_periodicity_code =>p_charge_periodicity_code,
1050: x_return_status => l_return_status ,
1051: x_msg_count => l_msg_count ,
1052: x_msg_data => l_msg_data ,

Line 1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1051: x_msg_count => l_msg_count ,
1052: x_msg_data => l_msg_data ,
1053: x_charge_amount => l_charge_total
1054: );
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;

Line 1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1052: x_msg_data => l_msg_data ,
1053: x_charge_amount => l_charge_total
1054: );
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:

Line 1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1053: x_charge_amount => l_charge_total
1054: );
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:
1061: RETURN l_charge_total;

Line 1058: RAISE FND_API.G_EXC_ERROR;

1054: );
1055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:
1061: RETURN l_charge_total;
1062:

Line 1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1576:
1577: EXCEPTION
1578: WHEN too_many_rows THEN
1579: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1581: WHEN no_data_found THEN
1582: IF l_debug_level > 0 THEN
1583: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1584: END IF;

Line 1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1585: WHEN others THEN
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
1588: END IF;
1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1590:
1591: END PRN_REC_SUBTOTALS;
1592:
1593: FUNCTION PRN_REC_TAXES

Line 1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1616:
1617: EXCEPTION
1618: WHEN too_many_rows THEN
1619: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1621: WHEN no_data_found THEN
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1624: END IF;

Line 1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1625: WHEN others THEN
1626: IF l_debug_level > 0 THEN
1627: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
1628: END IF;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630:
1631: END PRN_REC_TAXES;
1632:
1633: FUNCTION PRN_REC_TOTALS

Line 1669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1665:
1666: EXCEPTION
1667: WHEN too_many_rows THEN
1668: oe_debug_pub.add('unexpected error : '||sqlerrm,1);
1669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1670: WHEN no_data_found THEN
1671: IF l_debug_level > 0 THEN
1672: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1673: END IF;

Line 1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1674: WHEN others THEN
1675: IF l_debug_level > 0 THEN
1676: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);
1677: END IF;
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679:
1680: END PRN_REC_TOTALS;
1681:
1682: END OE_OE_TOTALS_SUMMARY;