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 OE_DEBUG_PUB

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

14:
15: IS
16: adjustment_total NUMBER;
17: --
18: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19: --
20: BEGIN
21: adjustment_total:=oe_header_adj_util.get_adj_total(p_header_id);
22: RETURN(adjustment_total);

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

37:
38: IS
39: adj_line_total_order_modifier NUMBER;
40: --
41: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
42: --
43: BEGIN
44:
45: SELECT -1 * decode(opa.arithmetic_operator,

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

76:
77: IS
78: ext_line_tot_order_modifier NUMBER;
79: --
80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
81: --
82: BEGIN
83:
84: SELECT -1 * decode(opa.arithmetic_operator,

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

112:
113: IS
114: adjustment_line_total NUMBER;
115: --
116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
117: --
118: BEGIN
119: adjustment_line_total:=oe_header_adj_util.get_adj_total(p_line_id => x_line_id);
120: RETURN(adjustment_line_total);

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

133: l_msg_data VARCHAR2(2000):= NULL;
134: l_return_status VARCHAR2(1);
135:
136: --
137: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
138: --
139: BEGIN
140:
141: -- Calling the charges API to get the Order Total for charges.

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

176: l_msg_data VARCHAR2(2000):= NULL;
177: l_return_status VARCHAR2(1);
178:
179: --
180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
181: --
182: BEGIN
183:
184: -- Calling the charges API to get the Order Total for charges.

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

212:
213: IS
214:
215: --
216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
217: --
218: BEGIN
219:
220: RETURN(nvl(G_TAX_VALUE,0));

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

229:
230: IS
231:
232: --
233: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
234: --
235: BEGIN
236: RETURN(nvl(G_TOTAL_EXTENDED_PRICE,0));
237:

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

277: AND Shipment_Number=shipment_number
278: AND cancelled_flag='N'; */
279:
280: --
281: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
282: --
283: BEGIN
284: FOR Lines IN C1(p_header_id,p_line_number,p_line_id)
285:

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

323: AND NVL(cancelled_flag,'N') ='N'
324: AND item_type_code = 'SERVICE';
325:
326: --
327: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
328: --
329: BEGIN
330: FOR Lines IN C1(p_header_id,p_line_number,p_service_number)
331:

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

352: IS
353: Is_fmt BOOLEAN;
354:
355: --
356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
357: --
358:
359: BEGIN
360:

Line 382: oe_debug_pub.add('unexpected error : '||sqlerrm,1);

378:
379: EXCEPTION
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

Line 387: oe_debug_pub.add('No Data found'||p_header_id,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;
389: WHEN others THEN
390: IF l_debug_level > 0 THEN
391: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

Line 391: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

387: oe_debug_pub.add('No Data found'||p_header_id,1) ;
388: END IF;
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:

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

400: RETURN NUMBER
401: IS
402: l_config_total NUMBER;
403: --
404: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
405: --
406: BEGIN
407: SELECT SUM(nvl(Ordered_Quantity,0)
408: *(unit_selling_price))

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

443: -- And option_number is null
444: and line_id = nvl(top_model_line_id,line_id);
445:
446: --
447: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
448: --
449: BEGIN
450:
451: FOR Lines IN C1(p_header_id,p_line_number)

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

476: )
477: IS
478:
479: --
480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
481: --
482: BEGIN
483: OE_OE_TOTALS_SUMMARY.Global_Totals
484: (

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

520: l_charges NUMBER;
521: l_tax NUMBER;
522:
523: --
524: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
525: --
526: BEGIN
527:
528: OE_OE_TOTALS_SUMMARY.Global_Totals(p_header_id);

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

556: l_commitment_total NUMBER;
557: l_chgs_w_line_id NUMBER := 0;
558: l_chgs_wo_line_id NUMBER := 0;
559: --
560: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
561: --
562: Is_fmt BOOLEAN; --5716270
563: BEGIN
564:

Line 723: oe_debug_pub.add( 'CALCULATING THE TOTAL AMOUNT TO BE AUTHORIZED FOR THIS ORDER ' , 1 ) ;

719: + nvl(l_charges, 0);
720: END IF;
721:
722: IF l_debug_level > 0 THEN
723: oe_debug_pub.add( 'CALCULATING THE TOTAL AMOUNT TO BE AUTHORIZED FOR THIS ORDER ' , 1 ) ;
724: END IF;
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_TOTAL ) , 1 ) ;
727: END IF;

Line 726: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_TOTAL ) , 1 ) ;

722: IF l_debug_level > 0 THEN
723: oe_debug_pub.add( 'CALCULATING THE TOTAL AMOUNT TO BE AUTHORIZED FOR THIS ORDER ' , 1 ) ;
724: END IF;
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_TOTAL ) , 1 ) ;
727: END IF;
728: IF l_debug_level > 0 THEN
729: oe_debug_pub.add( 'TAX TOTAL -> '||TO_CHAR ( L_TAX_TOTAL ) , 1 ) ;
730: END IF;

Line 729: oe_debug_pub.add( 'TAX TOTAL -> '||TO_CHAR ( L_TAX_TOTAL ) , 1 ) ;

725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_TOTAL ) , 1 ) ;
727: END IF;
728: IF l_debug_level > 0 THEN
729: oe_debug_pub.add( 'TAX TOTAL -> '||TO_CHAR ( L_TAX_TOTAL ) , 1 ) ;
730: END IF;
731: IF l_debug_level > 0 THEN
732: oe_debug_pub.add( 'COMMITMENTS -> '||TO_CHAR ( L_COMMITMENT_TOTAL ) , 1 ) ;
733: END IF;

Line 732: oe_debug_pub.add( 'COMMITMENTS -> '||TO_CHAR ( L_COMMITMENT_TOTAL ) , 1 ) ;

728: IF l_debug_level > 0 THEN
729: oe_debug_pub.add( 'TAX TOTAL -> '||TO_CHAR ( L_TAX_TOTAL ) , 1 ) ;
730: END IF;
731: IF l_debug_level > 0 THEN
732: oe_debug_pub.add( 'COMMITMENTS -> '||TO_CHAR ( L_COMMITMENT_TOTAL ) , 1 ) ;
733: END IF;
734: IF l_debug_level > 0 THEN
735: oe_debug_pub.add( 'OTHER CHARGES -> '||TO_CHAR ( L_CHARGES ) , 1 ) ;
736: END IF;

Line 735: oe_debug_pub.add( 'OTHER CHARGES -> '||TO_CHAR ( L_CHARGES ) , 1 ) ;

731: IF l_debug_level > 0 THEN
732: oe_debug_pub.add( 'COMMITMENTS -> '||TO_CHAR ( L_COMMITMENT_TOTAL ) , 1 ) ;
733: END IF;
734: IF l_debug_level > 0 THEN
735: oe_debug_pub.add( 'OTHER CHARGES -> '||TO_CHAR ( L_CHARGES ) , 1 ) ;
736: END IF;
737: IF l_debug_level > 0 THEN
738: oe_debug_pub.add( 'AMOUNT TO BE AUTHORIZED => '||TO_CHAR ( L_OUTBOUND_TOTAL ) , 1 ) ;
739: END IF;

Line 738: oe_debug_pub.add( 'AMOUNT TO BE AUTHORIZED => '||TO_CHAR ( L_OUTBOUND_TOTAL ) , 1 ) ;

734: IF l_debug_level > 0 THEN
735: oe_debug_pub.add( 'OTHER CHARGES -> '||TO_CHAR ( L_CHARGES ) , 1 ) ;
736: END IF;
737: IF l_debug_level > 0 THEN
738: oe_debug_pub.add( 'AMOUNT TO BE AUTHORIZED => '||TO_CHAR ( L_OUTBOUND_TOTAL ) , 1 ) ;
739: END IF;
740:
741: -- bug 4013565
742: IF p_total_type = 'TAXES' THEN

Line 756: oe_debug_pub.add( 'FROM OUTBOUND TOTAL OTHERS' ) ;

752:
753: EXCEPTION
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;

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

765: ) RETURN NUMBER
766: IS
767: l_order_subtotal NUMBER;
768: --
769: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
770: --
771: BEGIN
772: -- Select the Outbound Extended Price
773: BEGIN

Line 796: oe_debug_pub.add( 'CALCULATING THE ORDER SUBTOTAL AMOUNT FOR THIS ORDER ' , 1 ) ;

792: l_order_subtotal := 0;
793: END;
794:
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'CALCULATING THE ORDER SUBTOTAL AMOUNT FOR THIS ORDER ' , 1 ) ;
797: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_SUBTOTAL ) , 1 ) ;
798: END IF;
799: RETURN (nvl(l_order_subtotal,0));
800:

Line 797: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_SUBTOTAL ) , 1 ) ;

793: END;
794:
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'CALCULATING THE ORDER SUBTOTAL AMOUNT FOR THIS ORDER ' , 1 ) ;
797: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_SUBTOTAL ) , 1 ) ;
798: END IF;
799: RETURN (nvl(l_order_subtotal,0));
800:
801: EXCEPTION

Line 804: oe_debug_pub.add( 'FROM OUTBOUND SUBTOTAL OTHERS' ) ;

800:
801: EXCEPTION
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;

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

816: orders_total NUMBER;
817: returns_total NUMBER;
818: l_order_amount NUMBER;
819: --
820: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
821: --
822: BEGIN
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add( 'ENTERING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;

Line 824: oe_debug_pub.add( 'ENTERING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;

820: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
821: --
822: BEGIN
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add( 'ENTERING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
825: END IF;
826:
827: -- combining 2 SQLs into one for performance
828: SELECT SUM(DECODE(line_category_code, 'RETURN', 0, nvl(Ordered_Quantity,0)*(unit_list_price))),

Line 839: oe_debug_pub.add( ' ORDER TOTAL:='||ORDERS_TOTAL ) ;

835:
836: l_order_amount:=NVL(orders_total,0)-NVL(returns_total,0);
837:
838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( ' ORDER TOTAL:='||ORDERS_TOTAL ) ;
840: END IF;
841: IF l_debug_level > 0 THEN
842: oe_debug_pub.add( ' RETURN TOTAL:='||RETURNS_TOTAL ) ;
843: END IF;

Line 842: oe_debug_pub.add( ' RETURN TOTAL:='||RETURNS_TOTAL ) ;

838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( ' ORDER TOTAL:='||ORDERS_TOTAL ) ;
840: END IF;
841: IF l_debug_level > 0 THEN
842: oe_debug_pub.add( ' RETURN TOTAL:='||RETURNS_TOTAL ) ;
843: END IF;
844: IF l_debug_level > 0 THEN
845: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;
846: END IF;

Line 845: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;

841: IF l_debug_level > 0 THEN
842: oe_debug_pub.add( ' RETURN TOTAL:='||RETURNS_TOTAL ) ;
843: END IF;
844: IF l_debug_level > 0 THEN
845: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;
846: END IF;
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( 'LEAVING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
849: END IF;

Line 848: oe_debug_pub.add( 'LEAVING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;

844: IF l_debug_level > 0 THEN
845: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;
846: END IF;
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( 'LEAVING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
849: END IF;
850:
851: return l_order_amount;
852: EXCEPTION

Line 855: oe_debug_pub.add( ' TOO MANY ROWS' ) ;

851: return l_order_amount;
852: EXCEPTION
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

Line 861: oe_debug_pub.add( ' FROM NO DATA FOUND' ) ;

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' ) ;
862: END IF;
863:
864:
865: WHEN others THEN

Line 867: oe_debug_pub.add( ' FROM OTHERS' ) ;

863:
864:
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;

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

883: FUNCTION GET_DISCOUNT(p_unit_list_price IN number,p_unit_selling_price IN NUMBER)
884: RETURN NUMBER IS
885:
886: l_discount_pct NUMBER;
887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
888:
889: BEGIN
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');

Line 891: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');

887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
888:
889: BEGIN
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');
892: oe_debug_pub.add('Unit List Price = '||p_unit_list_price );
893: oe_debug_pub.add('Unit Selling Price = '||p_unit_selling_price );
894: END IF;
895:

Line 892: oe_debug_pub.add('Unit List Price = '||p_unit_list_price );

888:
889: BEGIN
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');
892: oe_debug_pub.add('Unit List Price = '||p_unit_list_price );
893: oe_debug_pub.add('Unit Selling Price = '||p_unit_selling_price );
894: END IF;
895:
896: IF ((p_unit_list_price IS NOT NULL AND p_unit_list_price > 0) AND

Line 893: oe_debug_pub.add('Unit Selling Price = '||p_unit_selling_price );

889: BEGIN
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');
892: oe_debug_pub.add('Unit List Price = '||p_unit_list_price );
893: oe_debug_pub.add('Unit Selling Price = '||p_unit_selling_price );
894: END IF;
895:
896: IF ((p_unit_list_price IS NOT NULL AND p_unit_list_price > 0) AND
897: (p_unit_selling_price IS NOT NULL AND p_unit_selling_price > 0) AND

Line 902: oe_debug_pub.add('Discount Percent = '||l_discount_pct);

898: (p_unit_list_price >= p_unit_selling_price)) THEN
899: l_discount_pct := round(((p_unit_list_price-p_unit_selling_price)/p_unit_list_price)*100);
900:
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add('Discount Percent = '||l_discount_pct);
903: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');
904: END IF;
905: -- IF l_discount_pct < 1 THEN
906: -- RETURN NULL;

Line 903: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');

899: l_discount_pct := round(((p_unit_list_price-p_unit_selling_price)/p_unit_list_price)*100);
900:
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add('Discount Percent = '||l_discount_pct);
903: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');
904: END IF;
905: -- IF l_discount_pct < 1 THEN
906: -- RETURN NULL;
907: -- ELSE

Line 912: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');

908: RETURN l_discount_pct;
909: -- END IF;
910: ELSE
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');
913: END IF;
914:
915: RETURN NULL;
916: END IF;

Line 920: oe_debug_pub.add( 'GET_DISCOUNT: WHEN OTHERS Exception' ) ;

916: END IF;
917: EXCEPTION
918: WHEN OTHERS THEN
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add( 'GET_DISCOUNT: WHEN OTHERS Exception' ) ;
921: END IF;
922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: OE_MSG_PUB.Add_Exc_Msg

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

941:
942: Is_fmt BOOLEAN;
943:
944: --
945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
946: --
947:
948: BEGIN
949:

Line 971: oe_debug_pub.add('unexpected error : '||sqlerrm,1);

967:
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) ;

Line 975: oe_debug_pub.add('No Data found'||p_header_id,1) ;

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;
977: WHEN others THEN
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

Line 979: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

975: oe_debug_pub.add('No Data found'||p_header_id,1) ;
976: END IF;
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;

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

990:
991: IS
992:
993: --
994: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
995: --
996: BEGIN
997:
998: RETURN(nvl(G_REC_TAX_VALUE,0));

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

1007:
1008: IS
1009:
1010: --
1011: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1012: --
1013: BEGIN
1014: RETURN(nvl(G_REC_TOTAL_EXTENDED_PRICE,0));
1015:

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

1028: l_msg_data VARCHAR2(2000):= NULL;
1029: l_return_status VARCHAR2(1);
1030:
1031: --
1032: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1033: --
1034: BEGIN
1035:
1036: IF l_debug_level > 0 THEN

Line 1037: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);

1033: --
1034: BEGIN
1035:
1036: IF l_debug_level > 0 THEN
1037: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1038: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1039: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1040: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1041: END IF;

Line 1038: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);

1034: BEGIN
1035:
1036: IF l_debug_level > 0 THEN
1037: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1038: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1039: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1040: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1041: END IF;
1042:

Line 1039: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);

1035:
1036: IF l_debug_level > 0 THEN
1037: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1038: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1039: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1040: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1041: END IF;
1042:
1043: OE_CHARGE_PVT.Get_Rec_Charge_Amount(

Line 1040: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);

1036: IF l_debug_level > 0 THEN
1037: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1038: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1039: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1040: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1041: END IF;
1042:
1043: OE_CHARGE_PVT.Get_Rec_Charge_Amount(
1044: p_api_version_number => 1.1 ,

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

1071:
1072: IS
1073: adjustment_total NUMBER;
1074: --
1075: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1076: p_line_id NUMBER;
1077: --
1078: BEGIN
1079: adjustment_total:=oe_header_adj_util.get_rec_adj_total(p_header_id,p_line_id,p_charge_periodicity_code);

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

1093: )
1094: IS
1095:
1096: --
1097: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1098: --
1099: BEGIN
1100:
1101: IF l_debug_level > 0 THEN

Line 1102: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);

1098: --
1099: BEGIN
1100:
1101: IF l_debug_level > 0 THEN
1102: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1103: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1104: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1105: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1106: END IF;

Line 1103: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);

1099: BEGIN
1100:
1101: IF l_debug_level > 0 THEN
1102: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1103: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1104: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1105: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1106: END IF;
1107:

Line 1104: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);

1100:
1101: IF l_debug_level > 0 THEN
1102: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1103: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1104: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1105: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1106: END IF;
1107:
1108: OE_OE_TOTALS_SUMMARY.Global_Rec_Totals(p_header_id => p_header_id,

Line 1105: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);

1101: IF l_debug_level > 0 THEN
1102: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1103: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1104: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1105: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1106: END IF;
1107:
1108: OE_OE_TOTALS_SUMMARY.Global_Rec_Totals(p_header_id => p_header_id,
1109: p_charge_periodicity_code => p_charge_periodicity_code);

Line 1129: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);

1125:
1126: x_total := x_tax + x_subtotal + x_charges;
1127:
1128: IF l_debug_level > 0 THEN
1129: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1130: END IF;
1131:
1132: END REC_ORDER_TOTALS;
1133:

Line 1152: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;

1148: i NUMBER;
1149: x_tax NUMBER;
1150: x_subtotal NUMBER;
1151: x_charges NUMBER;
1152: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;
1153:
1154: BEGIN
1155:
1156: IF l_debug_level > 0 THEN

Line 1157: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);

1153:
1154: BEGIN
1155:
1156: IF l_debug_level > 0 THEN
1157: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1158: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1159: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1160: END IF;
1161:

Line 1158: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);

1154: BEGIN
1155:
1156: IF l_debug_level > 0 THEN
1157: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1158: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1159: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1160: END IF;
1161:
1162: i := 1;

Line 1159: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);

1155:
1156: IF l_debug_level > 0 THEN
1157: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1158: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1159: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1160: END IF;
1161:
1162: i := 1;
1163: OPEN C_rec_charge(p_header_id);

Line 1169: OE_DEBUG_PUB.ADD('INSIDE LOOP FOR PERIODICITY_CODE :'||l_code,1);

1165: FETCH C_rec_charge INTO l_code;
1166: EXIT WHEN C_rec_charge%NOTFOUND;
1167:
1168: IF l_debug_level > 0 THEN
1169: OE_DEBUG_PUB.ADD('INSIDE LOOP FOR PERIODICITY_CODE :'||l_code,1);
1170: END IF;
1171:
1172: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1173: x_rec_charges_tbl(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);

Line 1193: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);

1189: x_rec_charges_tbl(i).rec_charges := x_charges;
1190: x_rec_charges_tbl(i).rec_total := x_subtotal + x_tax + x_charges;
1191:
1192: IF l_debug_level > 0 THEN
1193: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1194: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1195: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1196: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1197: END IF;

Line 1194: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);

1190: x_rec_charges_tbl(i).rec_total := x_subtotal + x_tax + x_charges;
1191:
1192: IF l_debug_level > 0 THEN
1193: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1194: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1195: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1196: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1197: END IF;
1198:

Line 1195: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);

1191:
1192: IF l_debug_level > 0 THEN
1193: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1194: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1195: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1196: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1197: END IF;
1198:
1199: i := i+1;

Line 1196: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);

1192: IF l_debug_level > 0 THEN
1193: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1194: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1195: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1196: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1197: END IF;
1198:
1199: i := i+1;
1200: END LOOP;

Line 1204: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');

1200: END LOOP;
1201: CLOSE C_rec_charge;
1202:
1203: IF l_debug_level > 0 THEN
1204: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');
1205: END IF;
1206:
1207: EXCEPTION
1208:

Line 1233: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;

1229: i NUMBER;
1230: x_tax NUMBER;
1231: x_subtotal NUMBER;
1232: x_charges NUMBER;
1233: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;
1234:
1235: BEGIN
1236:
1237: IF l_debug_level > 0 THEN

Line 1238: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);

1234:
1235: BEGIN
1236:
1237: IF l_debug_level > 0 THEN
1238: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1239: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1240: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1241: END IF;
1242:

Line 1239: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);

1235: BEGIN
1236:
1237: IF l_debug_level > 0 THEN
1238: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1239: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1240: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1241: END IF;
1242:
1243: i := 1;

Line 1240: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);

1236:
1237: IF l_debug_level > 0 THEN
1238: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1239: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1240: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1241: END IF;
1242:
1243: i := 1;
1244: OPEN C_rec_charge(p_header_id);

Line 1250: OE_DEBUG_PUB.ADD('INSIDE LOOP FOR PERIODICITY_CODE :'||l_code,1);

1246: FETCH C_rec_charge INTO l_code;
1247: EXIT WHEN C_rec_charge%NOTFOUND;
1248:
1249: IF l_debug_level > 0 THEN
1250: OE_DEBUG_PUB.ADD('INSIDE LOOP FOR PERIODICITY_CODE :'||l_code,1);
1251: END IF;
1252:
1253: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1254: IF (l_code <> 'ONE') THEN

Line 1275: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);

1271: x_rec_charges_tbl(i).rec_charges := x_charges;
1272: x_rec_charges_tbl(i).rec_total := nvl(x_subtotal,0) + nvl(x_tax,0) + nvl(x_charges,0);
1273:
1274: IF l_debug_level > 0 THEN
1275: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1276: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1277: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1278: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1279: END IF;

Line 1276: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);

1272: x_rec_charges_tbl(i).rec_total := nvl(x_subtotal,0) + nvl(x_tax,0) + nvl(x_charges,0);
1273:
1274: IF l_debug_level > 0 THEN
1275: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1276: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1277: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1278: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1279: END IF;
1280:

Line 1277: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);

1273:
1274: IF l_debug_level > 0 THEN
1275: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1276: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1277: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1278: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1279: END IF;
1280:
1281: i := i+1;

Line 1278: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);

1274: IF l_debug_level > 0 THEN
1275: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1276: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1277: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1278: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1279: END IF;
1280:
1281: i := i+1;
1282: END LOOP;

Line 1286: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');

1282: END LOOP;
1283: CLOSE C_rec_charge;
1284:
1285: IF l_debug_level > 0 THEN
1286: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');
1287: END IF;
1288:
1289: EXCEPTION
1290:

Line 1343: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;

1339: x_tax_total NUMBER :=0;
1340: x_total NUMBER :=0;
1341: rec_charges NUMBER :=0;
1342: l_line_id NUMBER;
1343: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;
1344:
1345: BEGIN
1346:
1347: IF l_debug_level > 0 THEN

Line 1348: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);

1344:
1345: BEGIN
1346:
1347: IF l_debug_level > 0 THEN
1348: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1349: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1350: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1351: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1352: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);

Line 1349: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);

1345: BEGIN
1346:
1347: IF l_debug_level > 0 THEN
1348: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1349: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1350: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1351: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1352: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1353: END IF;

Line 1350: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);

1346:
1347: IF l_debug_level > 0 THEN
1348: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1349: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1350: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1351: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1352: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1353: END IF;
1354:

Line 1351: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);

1347: IF l_debug_level > 0 THEN
1348: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1349: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1350: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1351: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1352: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1353: END IF;
1354:
1355: i := 1;

Line 1352: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);

1348: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1349: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1350: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1351: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1352: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1353: END IF;
1354:
1355: i := 1;
1356: OPEN C_rec_charge(p_header_id,p_line_number);

Line 1362: OE_DEBUG_PUB.ADD('INSIDE OUTER LOOP FOR PERIODICITY_CODE :'||l_code,1);

1358: FETCH C_rec_charge INTO l_code;
1359: EXIT WHEN C_rec_charge%NOTFOUND;
1360:
1361: IF l_debug_level > 0 THEN
1362: OE_DEBUG_PUB.ADD('INSIDE OUTER LOOP FOR PERIODICITY_CODE :'||l_code,1);
1363: END IF;
1364:
1365: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1366: IF (l_code <> 'ONE') THEN

Line 1376: OE_DEBUG_PUB.ADD('INSIDE INNER LOOP FOR PERIODICITY_CODE :'||l_code,1);

1372:
1373: FETCH c_extended into x_subtotal,x_tax,x_line_category_code;
1374: EXIT WHEN C_extended%NOTFOUND;
1375: IF l_debug_level > 0 THEN
1376: OE_DEBUG_PUB.ADD('INSIDE INNER LOOP FOR PERIODICITY_CODE :'||l_code,1);
1377: END IF;
1378: IF x_line_category_code <> 'RETURN' THEN
1379: x_total:=x_total+x_subtotal;
1380: x_tax_total:=x_tax_total+x_tax;

Line 1428: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);

1424: x_rec_charges_tbl(i).rec_charges := rec_charges;
1425: x_rec_charges_tbl(i).rec_total := rec_subtotal + rec_tax + rec_charges;
1426:
1427: IF l_debug_level > 0 THEN
1428: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1429: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1430: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1431: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1432: END IF;

Line 1429: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);

1425: x_rec_charges_tbl(i).rec_total := rec_subtotal + rec_tax + rec_charges;
1426:
1427: IF l_debug_level > 0 THEN
1428: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1429: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1430: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1431: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1432: END IF;
1433:

Line 1430: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);

1426:
1427: IF l_debug_level > 0 THEN
1428: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1429: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1430: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1431: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1432: END IF;
1433:
1434: i:=i+1; -- increment counter added abghosh

Line 1431: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);

1427: IF l_debug_level > 0 THEN
1428: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1429: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1430: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1431: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1432: END IF;
1433:
1434: i:=i+1; -- increment counter added abghosh
1435:

Line 1448: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);

1444: END LOOP;
1445: CLOSE C_rec_charge;
1446:
1447: IF l_debug_level > 0 THEN
1448: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1449: END IF;
1450:
1451: END Get_Model_Recurring_Totals;
1452:

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

1467:
1468: l_code VARCHAR2(3);
1469: i PLS_INTEGER;
1470: l_header_id NUMBER;
1471: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1472:
1473: BEGIN
1474:
1475: IF l_debug_level > 0 THEN

Line 1476: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');

1472:
1473: BEGIN
1474:
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');
1477: END IF;
1478: IF p_price_adjustment_id IS NULL THEN
1479: RETURN;
1480: ELSE

Line 1493: oe_debug_pub.add('Exception while querying for the adjustment record : ' || SQLERRM);

1489: END IF;
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: IF l_debug_level > 0 THEN
1493: oe_debug_pub.add('Exception while querying for the adjustment record : ' || SQLERRM);
1494: END IF;
1495: RETURN;
1496: END;
1497: ELSE

Line 1503: oe_debug_pub.add('l_header_id : ' || l_header_id);

1499: END IF;
1500: END IF;
1501:
1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add('l_header_id : ' || l_header_id);
1504: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
1505: END IF;
1506:
1507: G_RECURRING_AMOUNTS_TBL.DELETE;

Line 1504: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);

1500: END IF;
1501:
1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add('l_header_id : ' || l_header_id);
1504: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
1505: END IF;
1506:
1507: G_RECURRING_AMOUNTS_TBL.DELETE;
1508: i := 1;

Line 1518: oe_debug_pub.add('***************************************************************');

1514: G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1515: G_RECURRING_AMOUNTS_TBL(i).recurring_amount := OE_HEADER_ADJ_UTIL.Get_Rec_Order_Adj_Total(l_header_id, p_price_adjustment_id, l_code);
1516:
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('***************************************************************');
1519: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1520: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1521: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1522: oe_debug_pub.add('***************************************************************');

Line 1519: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);

1515: G_RECURRING_AMOUNTS_TBL(i).recurring_amount := OE_HEADER_ADJ_UTIL.Get_Rec_Order_Adj_Total(l_header_id, p_price_adjustment_id, l_code);
1516:
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('***************************************************************');
1519: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1520: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1521: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1522: oe_debug_pub.add('***************************************************************');
1523: END IF;

Line 1520: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);

1516:
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('***************************************************************');
1519: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1520: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1521: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1522: oe_debug_pub.add('***************************************************************');
1523: END IF;
1524: i := i+1;

Line 1521: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);

1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('***************************************************************');
1519: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1520: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1521: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1522: oe_debug_pub.add('***************************************************************');
1523: END IF;
1524: i := i+1;
1525: END LOOP;

Line 1522: oe_debug_pub.add('***************************************************************');

1518: oe_debug_pub.add('***************************************************************');
1519: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1520: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1521: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1522: oe_debug_pub.add('***************************************************************');
1523: END IF;
1524: i := i+1;
1525: END LOOP;
1526: CLOSE c_charge_periodicity;

Line 1529: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');

1525: END LOOP;
1526: CLOSE c_charge_periodicity;
1527:
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');
1530: END IF;
1531:
1532: END SET_ADJ_RECURRING_AMOUNTS;
1533:

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

1533:
1534: PROCEDURE GET_ADJ_RECURRING_AMOUNTS
1535: (x_recurring_amounts_tbl IN OUT NOCOPY /* file.sql.39 change */ Recurring_Amounts_Tbl_Type)
1536: IS
1537: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1538: BEGIN
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1541: END IF;

Line 1540: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');

1536: IS
1537: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1538: BEGIN
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1541: END IF;
1542:
1543: x_recurring_amounts_tbl := G_RECURRING_AMOUNTS_TBL;
1544:

Line 1546: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');

1542:
1543: x_recurring_amounts_tbl := G_RECURRING_AMOUNTS_TBL;
1544:
1545: IF l_debug_level > 0 THEN
1546: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1547: END IF;
1548: END;
1549:
1550: --rc pviprana end

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

1556: p_charge_periodicity_code IN VARCHAR2
1557: )
1558: RETURN NUMBER
1559: IS
1560: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1561: BEGIN
1562:
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');

Line 1564: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');

1560: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1561: BEGIN
1562:
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1565: oe_debug_pub.add('Header_id = '||p_header_id );
1566: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1567: END IF;
1568:

Line 1565: oe_debug_pub.add('Header_id = '||p_header_id );

1561: BEGIN
1562:
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1565: oe_debug_pub.add('Header_id = '||p_header_id );
1566: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1567: END IF;
1568:
1569: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

Line 1566: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );

1562:
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1565: oe_debug_pub.add('Header_id = '||p_header_id );
1566: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1567: END IF;
1568:
1569: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1570: (

Line 1579: oe_debug_pub.add('unexpected error : '||sqlerrm,1);

1575: RETURN(G_REC_TOTAL_EXTENDED_PRICE);
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) ;

Line 1583: oe_debug_pub.add('No Data found'||p_header_id,1) ;

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;
1585: WHEN others THEN
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

Line 1587: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

1583: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1584: END IF;
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;

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

1596: p_charge_periodicity_code IN VARCHAR2
1597: )
1598: RETURN NUMBER
1599: IS
1600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1601: BEGIN
1602:
1603: IF l_debug_level > 0 THEN
1604: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');

Line 1604: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');

1600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1601: BEGIN
1602:
1603: IF l_debug_level > 0 THEN
1604: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1605: oe_debug_pub.add('Header_id = '||p_header_id );
1606: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1607: END IF;
1608:

Line 1605: oe_debug_pub.add('Header_id = '||p_header_id );

1601: BEGIN
1602:
1603: IF l_debug_level > 0 THEN
1604: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1605: oe_debug_pub.add('Header_id = '||p_header_id );
1606: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1607: END IF;
1608:
1609: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

Line 1606: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );

1602:
1603: IF l_debug_level > 0 THEN
1604: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1605: oe_debug_pub.add('Header_id = '||p_header_id );
1606: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1607: END IF;
1608:
1609: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1610: (

Line 1619: oe_debug_pub.add('unexpected error : '||sqlerrm,1);

1615: RETURN(g_rec_tax_value);
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) ;

Line 1623: oe_debug_pub.add('No Data found'||p_header_id,1) ;

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;
1625: WHEN others THEN
1626: IF l_debug_level > 0 THEN
1627: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

Line 1627: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

1623: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1624: END IF;
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;

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

1636: p_charge_periodicity_code IN VARCHAR2
1637: )
1638: RETURN NUMBER
1639: IS
1640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1641: l_taxes NUMBER;
1642: l_subtotals NUMBER;
1643: l_charges NUMBER;
1644:

Line 1648: oe_debug_pub.add('ENTERING REC_TOTALS FUNCTION');

1644:
1645: BEGIN
1646:
1647: IF l_debug_level > 0 THEN
1648: oe_debug_pub.add('ENTERING REC_TOTALS FUNCTION');
1649: oe_debug_pub.add('Header_id = '||p_header_id );
1650: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1651: END IF;
1652:

Line 1649: oe_debug_pub.add('Header_id = '||p_header_id );

1645: BEGIN
1646:
1647: IF l_debug_level > 0 THEN
1648: oe_debug_pub.add('ENTERING REC_TOTALS FUNCTION');
1649: oe_debug_pub.add('Header_id = '||p_header_id );
1650: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1651: END IF;
1652:
1653: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

Line 1650: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );

1646:
1647: IF l_debug_level > 0 THEN
1648: oe_debug_pub.add('ENTERING REC_TOTALS FUNCTION');
1649: oe_debug_pub.add('Header_id = '||p_header_id );
1650: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1651: END IF;
1652:
1653: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1654: (

Line 1668: oe_debug_pub.add('unexpected error : '||sqlerrm,1);

1664: RETURN(l_taxes + l_subtotals + l_charges);
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) ;

Line 1672: oe_debug_pub.add('No Data found'||p_header_id,1) ;

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;
1674: WHEN others THEN
1675: IF l_debug_level > 0 THEN
1676: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

Line 1676: oe_debug_pub.add('Others unexpected error : '||sqlerrm,1);

1672: oe_debug_pub.add('No Data found'||p_header_id,1) ;
1673: END IF;
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;