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 357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

395:
396: EXCEPTION
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

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

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

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

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

417: RETURN NUMBER
418: IS
419: l_config_total NUMBER;
420: --
421: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
422: --
423: BEGIN
424: SELECT SUM(nvl(Ordered_Quantity,0)
425: *(unit_selling_price))

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

460: -- And option_number is null
461: and line_id = nvl(top_model_line_id,line_id);
462:
463: --
464: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
465: --
466: BEGIN
467:
468: FOR Lines IN C1(p_header_id,p_line_number)

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

493: )
494: IS
495:
496: --
497: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
498: --
499: BEGIN
500: OE_OE_TOTALS_SUMMARY.Global_Totals
501: (

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

537: l_charges NUMBER;
538: l_tax NUMBER;
539:
540: --
541: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
542: --
543: BEGIN
544:
545: OE_OE_TOTALS_SUMMARY.Global_Totals(p_header_id);

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

573: l_commitment_total NUMBER;
574: l_chgs_w_line_id NUMBER := 0;
575: l_chgs_wo_line_id NUMBER := 0;
576: --
577: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
578: --
579: Is_fmt BOOLEAN; --5716270
580: BEGIN
581:

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

743: + nvl(l_charges, 0);
744: END IF;
745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'CALCULATING THE TOTAL AMOUNT TO BE AUTHORIZED FOR THIS ORDER ' , 1 ) ;
748: END IF;
749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_TOTAL ) , 1 ) ;
751: END IF;

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

746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'CALCULATING THE TOTAL AMOUNT TO BE AUTHORIZED FOR THIS ORDER ' , 1 ) ;
748: END IF;
749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_TOTAL ) , 1 ) ;
751: END IF;
752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add( 'TAX TOTAL -> '||TO_CHAR ( L_TAX_TOTAL ) , 1 ) ;
754: END IF;

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

749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_TOTAL ) , 1 ) ;
751: END IF;
752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add( 'TAX TOTAL -> '||TO_CHAR ( L_TAX_TOTAL ) , 1 ) ;
754: END IF;
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'COMMITMENTS -> '||TO_CHAR ( L_COMMITMENT_TOTAL ) , 1 ) ;
757: END IF;

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

752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add( 'TAX TOTAL -> '||TO_CHAR ( L_TAX_TOTAL ) , 1 ) ;
754: END IF;
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'COMMITMENTS -> '||TO_CHAR ( L_COMMITMENT_TOTAL ) , 1 ) ;
757: END IF;
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'OTHER CHARGES -> '||TO_CHAR ( L_CHARGES ) , 1 ) ;
760: END IF;

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

755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'COMMITMENTS -> '||TO_CHAR ( L_COMMITMENT_TOTAL ) , 1 ) ;
757: END IF;
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'OTHER CHARGES -> '||TO_CHAR ( L_CHARGES ) , 1 ) ;
760: END IF;
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'AMOUNT TO BE AUTHORIZED => '||TO_CHAR ( L_OUTBOUND_TOTAL ) , 1 ) ;
763: END IF;

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

758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'OTHER CHARGES -> '||TO_CHAR ( L_CHARGES ) , 1 ) ;
760: END IF;
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'AMOUNT TO BE AUTHORIZED => '||TO_CHAR ( L_OUTBOUND_TOTAL ) , 1 ) ;
763: END IF;
764:
765: -- bug 4013565
766: IF p_total_type = 'TAXES' THEN

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

776:
777: EXCEPTION
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;

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

789: ) RETURN NUMBER
790: IS
791: l_order_subtotal NUMBER;
792: --
793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
794: --
795: BEGIN
796: -- Select the Outbound Extended Price
797: BEGIN

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

816: l_order_subtotal := 0;
817: END;
818:
819: IF l_debug_level > 0 THEN
820: oe_debug_pub.add( 'CALCULATING THE ORDER SUBTOTAL AMOUNT FOR THIS ORDER ' , 1 ) ;
821: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_SUBTOTAL ) , 1 ) ;
822: END IF;
823: RETURN (nvl(l_order_subtotal,0));
824:

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

817: END;
818:
819: IF l_debug_level > 0 THEN
820: oe_debug_pub.add( 'CALCULATING THE ORDER SUBTOTAL AMOUNT FOR THIS ORDER ' , 1 ) ;
821: oe_debug_pub.add( 'ORDER TOTAL -> '||TO_CHAR ( L_ORDER_SUBTOTAL ) , 1 ) ;
822: END IF;
823: RETURN (nvl(l_order_subtotal,0));
824:
825: EXCEPTION

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

824:
825: EXCEPTION
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;

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

840: orders_total NUMBER;
841: returns_total NUMBER;
842: l_order_amount NUMBER;
843: --
844: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
845: --
846: BEGIN
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( 'ENTERING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;

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

844: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
845: --
846: BEGIN
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( 'ENTERING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
849: END IF;
850:
851: -- combining 2 SQLs into one for performance
852: SELECT SUM(DECODE(line_category_code, 'RETURN', 0, nvl(Ordered_Quantity,0)*(unit_list_price))),

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

859:
860: l_order_amount:=NVL(orders_total,0)-NVL(returns_total,0);
861:
862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add( ' ORDER TOTAL:='||ORDERS_TOTAL ) ;
864: END IF;
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add( ' RETURN TOTAL:='||RETURNS_TOTAL ) ;
867: END IF;

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

862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add( ' ORDER TOTAL:='||ORDERS_TOTAL ) ;
864: END IF;
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add( ' RETURN TOTAL:='||RETURNS_TOTAL ) ;
867: END IF;
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;
870: END IF;

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

865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add( ' RETURN TOTAL:='||RETURNS_TOTAL ) ;
867: END IF;
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;
870: END IF;
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'LEAVING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
873: END IF;

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

868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;
870: END IF;
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'LEAVING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
873: END IF;
874:
875: return l_order_amount;
876: EXCEPTION

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

875: return l_order_amount;
876: EXCEPTION
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

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

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' ) ;
886: END IF;
887:
888:
889: WHEN others THEN

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

887:
888:
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;

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

907: FUNCTION GET_DISCOUNT(p_unit_list_price IN number,p_unit_selling_price IN NUMBER)
908: RETURN NUMBER IS
909:
910: l_discount_pct NUMBER;
911: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
912:
913: BEGIN
914: IF l_debug_level > 0 THEN
915: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');

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

911: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
912:
913: BEGIN
914: IF l_debug_level > 0 THEN
915: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');
916: oe_debug_pub.add('Unit List Price = '||p_unit_list_price );
917: oe_debug_pub.add('Unit Selling Price = '||p_unit_selling_price );
918: END IF;
919:

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

912:
913: BEGIN
914: IF l_debug_level > 0 THEN
915: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');
916: oe_debug_pub.add('Unit List Price = '||p_unit_list_price );
917: oe_debug_pub.add('Unit Selling Price = '||p_unit_selling_price );
918: END IF;
919:
920: IF ((p_unit_list_price IS NOT NULL AND p_unit_list_price > 0) AND

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

913: BEGIN
914: IF l_debug_level > 0 THEN
915: oe_debug_pub.add('ENTER GET_DISCOUNT PROCEDURE');
916: oe_debug_pub.add('Unit List Price = '||p_unit_list_price );
917: oe_debug_pub.add('Unit Selling Price = '||p_unit_selling_price );
918: END IF;
919:
920: IF ((p_unit_list_price IS NOT NULL AND p_unit_list_price > 0) AND
921: (p_unit_selling_price IS NOT NULL AND p_unit_selling_price > 0) AND

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

922: (p_unit_list_price >= p_unit_selling_price)) THEN
923: l_discount_pct := round(((p_unit_list_price-p_unit_selling_price)/p_unit_list_price)*100);
924:
925: IF l_debug_level > 0 THEN
926: oe_debug_pub.add('Discount Percent = '||l_discount_pct);
927: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');
928: END IF;
929: -- IF l_discount_pct < 1 THEN
930: -- RETURN NULL;

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

923: l_discount_pct := round(((p_unit_list_price-p_unit_selling_price)/p_unit_list_price)*100);
924:
925: IF l_debug_level > 0 THEN
926: oe_debug_pub.add('Discount Percent = '||l_discount_pct);
927: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');
928: END IF;
929: -- IF l_discount_pct < 1 THEN
930: -- RETURN NULL;
931: -- ELSE

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

932: RETURN l_discount_pct;
933: -- END IF;
934: ELSE
935: IF l_debug_level > 0 THEN
936: oe_debug_pub.add('EXIT GET_DISCOUNT PROCEDURE');
937: END IF;
938:
939: RETURN NULL;
940: END IF;

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

940: END IF;
941: EXCEPTION
942: WHEN OTHERS THEN
943: IF l_debug_level > 0 THEN
944: oe_debug_pub.add( 'GET_DISCOUNT: WHEN OTHERS Exception' ) ;
945: END IF;
946: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: OE_MSG_PUB.Add_Exc_Msg

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

965:
966: Is_fmt BOOLEAN;
967:
968: --
969: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
970: --
971:
972: BEGIN
973:

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

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

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

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

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

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

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

1014:
1015: IS
1016:
1017: --
1018: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1019: --
1020: BEGIN
1021:
1022: RETURN(nvl(G_REC_TAX_VALUE,0));

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

1031:
1032: IS
1033:
1034: --
1035: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1036: --
1037: BEGIN
1038: RETURN(nvl(G_REC_TOTAL_EXTENDED_PRICE,0));
1039:

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

1052: l_msg_data VARCHAR2(2000):= NULL;
1053: l_return_status VARCHAR2(1);
1054:
1055: --
1056: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1057: --
1058: BEGIN
1059:
1060: IF l_debug_level > 0 THEN

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

1057: --
1058: BEGIN
1059:
1060: IF l_debug_level > 0 THEN
1061: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1062: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1063: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1064: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1065: END IF;

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

1058: BEGIN
1059:
1060: IF l_debug_level > 0 THEN
1061: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1062: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1063: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1064: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1065: END IF;
1066:

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

1059:
1060: IF l_debug_level > 0 THEN
1061: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1062: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1063: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1064: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1065: END IF;
1066:
1067: OE_CHARGE_PVT.Get_Rec_Charge_Amount(

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

1060: IF l_debug_level > 0 THEN
1061: OE_DEBUG_PUB.ADD('CALLING THE CHARGES API TO GET THE ORDER TOTAL FOR CHARGES',1);
1062: OE_DEBUG_PUB.ADD('INPUTS PASSED',1);
1063: OE_DEBUG_PUB.ADD('p_header_id : '||p_header_id,1);
1064: OE_DEBUG_PUB.ADD('p_charge_periodicity_code : '||p_charge_periodicity_code,1);
1065: END IF;
1066:
1067: OE_CHARGE_PVT.Get_Rec_Charge_Amount(
1068: p_api_version_number => 1.1 ,

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

1095:
1096: IS
1097: adjustment_total NUMBER;
1098: --
1099: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1100: p_line_id NUMBER;
1101: --
1102: BEGIN
1103: adjustment_total:=oe_header_adj_util.get_rec_adj_total(p_header_id,p_line_id,p_charge_periodicity_code);

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

1117: )
1118: IS
1119:
1120: --
1121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1122: --
1123: BEGIN
1124:
1125: IF l_debug_level > 0 THEN

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

1122: --
1123: BEGIN
1124:
1125: IF l_debug_level > 0 THEN
1126: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1127: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1128: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1129: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1130: END IF;

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

1123: BEGIN
1124:
1125: IF l_debug_level > 0 THEN
1126: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1127: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1128: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1129: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1130: END IF;
1131:

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

1124:
1125: IF l_debug_level > 0 THEN
1126: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1127: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1128: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1129: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1130: END IF;
1131:
1132: OE_OE_TOTALS_SUMMARY.Global_Rec_Totals(p_header_id => p_header_id,

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

1125: IF l_debug_level > 0 THEN
1126: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1127: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1128: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1129: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1130: END IF;
1131:
1132: OE_OE_TOTALS_SUMMARY.Global_Rec_Totals(p_header_id => p_header_id,
1133: p_charge_periodicity_code => p_charge_periodicity_code);

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

1149:
1150: x_total := x_tax + x_subtotal + x_charges;
1151:
1152: IF l_debug_level > 0 THEN
1153: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1154: END IF;
1155:
1156: END REC_ORDER_TOTALS;
1157:

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

1172: i NUMBER;
1173: x_tax NUMBER;
1174: x_subtotal NUMBER;
1175: x_charges NUMBER;
1176: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;
1177:
1178: BEGIN
1179:
1180: IF l_debug_level > 0 THEN

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

1177:
1178: BEGIN
1179:
1180: IF l_debug_level > 0 THEN
1181: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1182: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1183: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1184: END IF;
1185:

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

1178: BEGIN
1179:
1180: IF l_debug_level > 0 THEN
1181: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1182: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1183: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1184: END IF;
1185:
1186: i := 1;

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

1179:
1180: IF l_debug_level > 0 THEN
1181: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1182: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1183: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1184: END IF;
1185:
1186: i := 1;
1187: OPEN C_rec_charge(p_header_id);

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

1189: FETCH C_rec_charge INTO l_code;
1190: EXIT WHEN C_rec_charge%NOTFOUND;
1191:
1192: IF l_debug_level > 0 THEN
1193: OE_DEBUG_PUB.ADD('INSIDE LOOP FOR PERIODICITY_CODE :'||l_code,1);
1194: END IF;
1195:
1196: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1197: x_rec_charges_tbl(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);

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

1213: x_rec_charges_tbl(i).rec_charges := x_charges;
1214: x_rec_charges_tbl(i).rec_total := x_subtotal + x_tax + x_charges;
1215:
1216: IF l_debug_level > 0 THEN
1217: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1218: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1219: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1220: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1221: END IF;

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

1214: x_rec_charges_tbl(i).rec_total := x_subtotal + x_tax + x_charges;
1215:
1216: IF l_debug_level > 0 THEN
1217: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1218: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1219: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1220: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1221: END IF;
1222:

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

1215:
1216: IF l_debug_level > 0 THEN
1217: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1218: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1219: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1220: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1221: END IF;
1222:
1223: i := i+1;

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

1216: IF l_debug_level > 0 THEN
1217: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1218: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1219: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1220: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1221: END IF;
1222:
1223: i := i+1;
1224: END LOOP;

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

1224: END LOOP;
1225: CLOSE C_rec_charge;
1226:
1227: IF l_debug_level > 0 THEN
1228: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');
1229: END IF;
1230:
1231: EXCEPTION
1232:

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

1253: i NUMBER;
1254: x_tax NUMBER;
1255: x_subtotal NUMBER;
1256: x_charges NUMBER;
1257: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;
1258:
1259: BEGIN
1260:
1261: IF l_debug_level > 0 THEN

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

1258:
1259: BEGIN
1260:
1261: IF l_debug_level > 0 THEN
1262: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1263: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1264: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1265: END IF;
1266:

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

1259: BEGIN
1260:
1261: IF l_debug_level > 0 THEN
1262: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1263: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1264: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1265: END IF;
1266:
1267: i := 1;

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

1260:
1261: IF l_debug_level > 0 THEN
1262: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1263: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1264: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1265: END IF;
1266:
1267: i := 1;
1268: OPEN C_rec_charge(p_header_id);

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

1270: FETCH C_rec_charge INTO l_code;
1271: EXIT WHEN C_rec_charge%NOTFOUND;
1272:
1273: IF l_debug_level > 0 THEN
1274: OE_DEBUG_PUB.ADD('INSIDE LOOP FOR PERIODICITY_CODE :'||l_code,1);
1275: END IF;
1276:
1277: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1278: IF (l_code <> 'ONE') THEN

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

1295: x_rec_charges_tbl(i).rec_charges := x_charges;
1296: x_rec_charges_tbl(i).rec_total := nvl(x_subtotal,0) + nvl(x_tax,0) + nvl(x_charges,0);
1297:
1298: IF l_debug_level > 0 THEN
1299: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1300: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1301: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1302: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1303: END IF;

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

1296: x_rec_charges_tbl(i).rec_total := nvl(x_subtotal,0) + nvl(x_tax,0) + nvl(x_charges,0);
1297:
1298: IF l_debug_level > 0 THEN
1299: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1300: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1301: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1302: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1303: END IF;
1304:

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

1297:
1298: IF l_debug_level > 0 THEN
1299: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1300: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1301: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1302: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1303: END IF;
1304:
1305: i := i+1;

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

1298: IF l_debug_level > 0 THEN
1299: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1300: OE_DEBUG_PUB.ADD('TAX :'||x_tax,1);
1301: OE_DEBUG_PUB.ADD('SUBTOTAL :'||x_subtotal,1);
1302: OE_DEBUG_PUB.ADD('CHARGES :'||x_charges,1);
1303: END IF;
1304:
1305: i := i+1;
1306: END LOOP;

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

1306: END LOOP;
1307: CLOSE C_rec_charge;
1308:
1309: IF l_debug_level > 0 THEN
1310: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');
1311: END IF;
1312:
1313: EXCEPTION
1314:

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

1363: x_tax_total NUMBER :=0;
1364: x_total NUMBER :=0;
1365: rec_charges NUMBER :=0;
1366: l_line_id NUMBER;
1367: l_debug_level CONSTANT NUMBER := Oe_Debug_Pub.g_debug_level;
1368:
1369: BEGIN
1370:
1371: IF l_debug_level > 0 THEN

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

1368:
1369: BEGIN
1370:
1371: IF l_debug_level > 0 THEN
1372: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1373: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1374: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1375: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1376: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);

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

1369: BEGIN
1370:
1371: IF l_debug_level > 0 THEN
1372: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1373: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1374: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1375: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1376: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1377: END IF;

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

1370:
1371: IF l_debug_level > 0 THEN
1372: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1373: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1374: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1375: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1376: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1377: END IF;
1378:

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

1371: IF l_debug_level > 0 THEN
1372: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1373: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1374: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1375: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1376: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1377: END IF;
1378:
1379: i := 1;

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

1372: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1373: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1374: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1375: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1376: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);
1377: END IF;
1378:
1379: i := 1;
1380: OPEN C_rec_charge(p_header_id,p_line_number);

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

1382: FETCH C_rec_charge INTO l_code;
1383: EXIT WHEN C_rec_charge%NOTFOUND;
1384:
1385: IF l_debug_level > 0 THEN
1386: OE_DEBUG_PUB.ADD('INSIDE OUTER LOOP FOR PERIODICITY_CODE :'||l_code,1);
1387: END IF;
1388:
1389: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1390: IF (l_code <> 'ONE') THEN

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

1396:
1397: FETCH c_extended into x_subtotal,x_tax,x_line_category_code;
1398: EXIT WHEN C_extended%NOTFOUND;
1399: IF l_debug_level > 0 THEN
1400: OE_DEBUG_PUB.ADD('INSIDE INNER LOOP FOR PERIODICITY_CODE :'||l_code,1);
1401: END IF;
1402: IF x_line_category_code <> 'RETURN' THEN
1403: x_total:=x_total+x_subtotal;
1404: x_tax_total:=x_tax_total+x_tax;

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

1448: x_rec_charges_tbl(i).rec_charges := rec_charges;
1449: x_rec_charges_tbl(i).rec_total := rec_subtotal + rec_tax + rec_charges;
1450:
1451: IF l_debug_level > 0 THEN
1452: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1453: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1454: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1455: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1456: END IF;

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

1449: x_rec_charges_tbl(i).rec_total := rec_subtotal + rec_tax + rec_charges;
1450:
1451: IF l_debug_level > 0 THEN
1452: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1453: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1454: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1455: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1456: END IF;
1457:

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

1450:
1451: IF l_debug_level > 0 THEN
1452: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1453: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1454: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1455: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1456: END IF;
1457:
1458: i:=i+1; -- increment counter added abghosh

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

1451: IF l_debug_level > 0 THEN
1452: OE_DEBUG_PUB.ADD('TOTALS FOR PERIODICITY_CODE :'||l_code,1);
1453: OE_DEBUG_PUB.ADD('TAX :'||rec_tax,1);
1454: OE_DEBUG_PUB.ADD('SUBTOTAL :'||rec_subtotal,1);
1455: OE_DEBUG_PUB.ADD('CHARGES :'||rec_charges,1);
1456: END IF;
1457:
1458: i:=i+1; -- increment counter added abghosh
1459:

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

1468: END LOOP;
1469: CLOSE C_rec_charge;
1470:
1471: IF l_debug_level > 0 THEN
1472: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1473: END IF;
1474:
1475: END Get_Model_Recurring_Totals;
1476:

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

1491:
1492: l_code VARCHAR2(3);
1493: i PLS_INTEGER;
1494: l_header_id NUMBER;
1495: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1496:
1497: BEGIN
1498:
1499: IF l_debug_level > 0 THEN

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

1496:
1497: BEGIN
1498:
1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');
1501: END IF;
1502: IF p_price_adjustment_id IS NULL THEN
1503: RETURN;
1504: ELSE

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

1513: END IF;
1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: IF l_debug_level > 0 THEN
1517: oe_debug_pub.add('Exception while querying for the adjustment record : ' || SQLERRM);
1518: END IF;
1519: RETURN;
1520: END;
1521: ELSE

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

1523: END IF;
1524: END IF;
1525:
1526: IF l_debug_level > 0 THEN
1527: oe_debug_pub.add('l_header_id : ' || l_header_id);
1528: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
1529: END IF;
1530:
1531: G_RECURRING_AMOUNTS_TBL.DELETE;

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

1524: END IF;
1525:
1526: IF l_debug_level > 0 THEN
1527: oe_debug_pub.add('l_header_id : ' || l_header_id);
1528: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
1529: END IF;
1530:
1531: G_RECURRING_AMOUNTS_TBL.DELETE;
1532: i := 1;

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

1538: G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1539: 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);
1540:
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('***************************************************************');
1543: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1544: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1545: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1546: oe_debug_pub.add('***************************************************************');

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

1539: 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);
1540:
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('***************************************************************');
1543: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1544: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1545: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1546: oe_debug_pub.add('***************************************************************');
1547: END IF;

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

1540:
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('***************************************************************');
1543: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1544: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1545: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1546: oe_debug_pub.add('***************************************************************');
1547: END IF;
1548: i := i+1;

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

1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('***************************************************************');
1543: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1544: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1545: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1546: oe_debug_pub.add('***************************************************************');
1547: END IF;
1548: i := i+1;
1549: END LOOP;

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

1542: oe_debug_pub.add('***************************************************************');
1543: oe_debug_pub.add('charge_periodicity_code : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_code);
1544: oe_debug_pub.add('charge_periodicity_meaning : ' || G_RECURRING_AMOUNTS_TBL(i).charge_periodicity_meaning);
1545: oe_debug_pub.add('recurring amount : ' || G_RECURRING_AMOUNTS_TBL(i).recurring_amount);
1546: oe_debug_pub.add('***************************************************************');
1547: END IF;
1548: i := i+1;
1549: END LOOP;
1550: CLOSE c_charge_periodicity;

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

1549: END LOOP;
1550: CLOSE c_charge_periodicity;
1551:
1552: IF l_debug_level > 0 THEN
1553: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');
1554: END IF;
1555:
1556: END SET_ADJ_RECURRING_AMOUNTS;
1557:

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

1557:
1558: PROCEDURE GET_ADJ_RECURRING_AMOUNTS
1559: (x_recurring_amounts_tbl IN OUT NOCOPY /* file.sql.39 change */ Recurring_Amounts_Tbl_Type)
1560: IS
1561: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1562: BEGIN
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1565: END IF;

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

1560: IS
1561: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1562: BEGIN
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1565: END IF;
1566:
1567: x_recurring_amounts_tbl := G_RECURRING_AMOUNTS_TBL;
1568:

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

1566:
1567: x_recurring_amounts_tbl := G_RECURRING_AMOUNTS_TBL;
1568:
1569: IF l_debug_level > 0 THEN
1570: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1571: END IF;
1572: END;
1573:
1574: --rc pviprana end

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

1580: p_charge_periodicity_code IN VARCHAR2
1581: )
1582: RETURN NUMBER
1583: IS
1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1585: BEGIN
1586:
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');

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

1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1585: BEGIN
1586:
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1589: oe_debug_pub.add('Header_id = '||p_header_id );
1590: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1591: END IF;
1592:

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

1585: BEGIN
1586:
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1589: oe_debug_pub.add('Header_id = '||p_header_id );
1590: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1591: END IF;
1592:
1593: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

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

1586:
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1589: oe_debug_pub.add('Header_id = '||p_header_id );
1590: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1591: END IF;
1592:
1593: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1594: (

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

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

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

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

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

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

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

1620: p_charge_periodicity_code IN VARCHAR2
1621: )
1622: RETURN NUMBER
1623: IS
1624: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1625: BEGIN
1626:
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');

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

1624: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1625: BEGIN
1626:
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1629: oe_debug_pub.add('Header_id = '||p_header_id );
1630: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1631: END IF;
1632:

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

1625: BEGIN
1626:
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1629: oe_debug_pub.add('Header_id = '||p_header_id );
1630: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1631: END IF;
1632:
1633: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

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

1626:
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add('ENTERING REC_SUBTOTALS FUNCTION');
1629: oe_debug_pub.add('Header_id = '||p_header_id );
1630: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1631: END IF;
1632:
1633: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1634: (

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

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

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

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

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

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

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

1660: p_charge_periodicity_code IN VARCHAR2
1661: )
1662: RETURN NUMBER
1663: IS
1664: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1665: l_taxes NUMBER;
1666: l_subtotals NUMBER;
1667: l_charges NUMBER;
1668:

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

1668:
1669: BEGIN
1670:
1671: IF l_debug_level > 0 THEN
1672: oe_debug_pub.add('ENTERING REC_TOTALS FUNCTION');
1673: oe_debug_pub.add('Header_id = '||p_header_id );
1674: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1675: END IF;
1676:

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

1669: BEGIN
1670:
1671: IF l_debug_level > 0 THEN
1672: oe_debug_pub.add('ENTERING REC_TOTALS FUNCTION');
1673: oe_debug_pub.add('Header_id = '||p_header_id );
1674: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1675: END IF;
1676:
1677: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

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

1670:
1671: IF l_debug_level > 0 THEN
1672: oe_debug_pub.add('ENTERING REC_TOTALS FUNCTION');
1673: oe_debug_pub.add('Header_id = '||p_header_id );
1674: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1675: END IF;
1676:
1677: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1678: (

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

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

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

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

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

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