[Home] [Help]
1: PACKAGE BODY ASO_TAX_INT as
2: /* $Header: asoitaxb.pls 120.23.12010000.2 2008/11/11 07:36:48 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_TAX_INT
5: -- Purpose :
1: PACKAGE BODY ASO_TAX_INT as
2: /* $Header: asoitaxb.pls 120.23.12010000.2 2008/11/11 07:36:48 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_TAX_INT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments
6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_TAX_INT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoitaxb.pls';
12: l_sys_date date := SYSDATE;
13:
14:
815: x_return_status := FND_API.G_RET_STS_SUCCESS;
816:
817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
818:
819: aso_debug_pub.add('ASO_TAX_INT: Begin ASO_TAX_LINE', 1, 'Y');
820:
821: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
822: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
823:
817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
818:
819: aso_debug_pub.add('ASO_TAX_INT: Begin ASO_TAX_LINE', 1, 'Y');
820:
821: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
822: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
823:
824: END IF;
825:
818:
819: aso_debug_pub.add('ASO_TAX_INT: Begin ASO_TAX_LINE', 1, 'Y');
820:
821: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
822: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
823:
824: END IF;
825:
826: -- Retrieve Quote header and line information from database
826: -- Retrieve Quote header and line information from database
827: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
828:
829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
830: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Header_Row', 1, 'Y');
831: END IF;
832:
833: If p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM then
834:
853:
854: Begin
855:
856: IF aso_debug_pub.g_debug_flag = 'Y' THEN
857: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Before call to ARP_TAX_CRM_INTEGRATION_PKG.tax_method', 1, 'Y');
858: END IF;
859:
860: arp_tax_crm_integration_pkg.tax_method (l_tax_method,l_vendor_installed);
861:
870: WHEN OTHERS THEN
871:
872: IF aso_debug_pub.g_debug_flag = 'Y' THEN
873:
874: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Exception raised in ARP_TAX_CRM_INTEGRATION_PKG.tax_method', 1, 'Y');
875:
876: END IF;
877:
878: l_reason := 'ARP_TAX_CRM_INTEGRATION_PKG.tax_method is raising an exception.';
959: END IF;
960:
961: --Get Line type info
962: IF aso_debug_pub.g_debug_flag = 'Y' THEN
963: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Before call to get_ra_trx_type_id', 1, 'Y');
964: END IF;
965:
966: l_trx_type_id := get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
967:
1464:
1465: Begin
1466:
1467: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1468: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Inside IF cond l_tax_method = VERTEX ', 1, 'Y');
1469: END IF;
1470:
1471: L_POO_ADDRESS_CODE := ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE('ASO_TAX_LINES_SUMMARY_V_V',
1472: P_QTE_HEADER_ID, L_SHIPMENT_REC.SHIPMENT_ID);
1534:
1535: Begin
1536:
1537: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1538: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Inside IF cond l_tax_method = TAXWARE ', 1, 'Y');
1539: END IF;
1540:
1541: L_POO_ADDRESS_CODE := ARP_TAX_VIEW_TAXWARE.POO_ADDRESS_CODE('ASO_TAX_LINES_SUMMARY_V_A',
1542: P_QTE_HEADER_ID,L_SHIPMENT_REC.SHIPMENT_ID,L_SALESREP_ID);
2173: l_tax_total_time := l_tax_total_time/100;
2174:
2175: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2176: aso_debug_pub.add('ASO_TAX_LINE: Total time Tax Engine took after dividing by 100: l_tax_total_time: '|| l_tax_total_time, 1,'Y');
2177: aso_debug_pub.add('ASO_TAX_INT: End ASO_TAX_LINE', 1, 'Y');
2178: END IF;
2179:
2180: End aso_tax_line;
2181: *
2195: X_Msg_Data OUT NOCOPY VARCHAR2
2196:
2197: )
2198: is
2199: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_TAX_INT';
2200: L_API_NAME CONSTANT VARCHAR2(50):='CALCULATE_TAX_WITH_GTT';
2201: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
2202: l_currency_code VARCHAR2(15);
2203: l_minimum_accountable_unit NUMBER;
2348: x_return_status := FND_API.G_RET_STS_SUCCESS;
2349:
2350: IF aso_debug_pub.g_debug_flag = 'Y'
2351: THEN
2352: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2353: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2354: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2355: END IF;
2356: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2349:
2350: IF aso_debug_pub.g_debug_flag = 'Y'
2351: THEN
2352: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2353: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2354: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2355: END IF;
2356: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2357: IF aso_debug_pub.g_debug_flag = 'Y'
2350: IF aso_debug_pub.g_debug_flag = 'Y'
2351: THEN
2352: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2353: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2354: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2355: END IF;
2356: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2357: IF aso_debug_pub.g_debug_flag = 'Y'
2358: THEN
2355: END IF;
2356: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2357: IF aso_debug_pub.g_debug_flag = 'Y'
2358: THEN
2359: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');
2360: END IF;
2361:
2362: l_currency_code := l_qte_header_rec.currency_code;
2363: IF aso_debug_pub.g_debug_flag = 'Y'
2361:
2362: l_currency_code := l_qte_header_rec.currency_code;
2363: IF aso_debug_pub.g_debug_flag = 'Y'
2364: THEN
2365: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_currency_code: '|| l_currency_code, 1, 'Y');
2366: END IF;
2367:
2368: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2369: IF aso_debug_pub.g_debug_flag = 'Y'
2367:
2368: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2369: IF aso_debug_pub.g_debug_flag = 'Y'
2370: THEN
2371: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');
2372: END IF;
2373:
2374: --Condition added on 20/09/05 by anrajan
2375: IF l_Shipment_header_tbl.count > 0
2382: CLOSE c_currency;
2383:
2384: IF aso_debug_pub.g_debug_flag = 'Y'
2385: THEN
2386: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_currency cursor ', 1, 'Y');
2387: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_minimum_accountable_unit: '||l_minimum_accountable_unit, 1, 'Y');
2388: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_precision: '||l_precision,1,'Y');
2389: END IF;
2390:
2383:
2384: IF aso_debug_pub.g_debug_flag = 'Y'
2385: THEN
2386: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_currency cursor ', 1, 'Y');
2387: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_minimum_accountable_unit: '||l_minimum_accountable_unit, 1, 'Y');
2388: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_precision: '||l_precision,1,'Y');
2389: END IF;
2390:
2391: open c_ship_to_cust_account_id;
2384: IF aso_debug_pub.g_debug_flag = 'Y'
2385: THEN
2386: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_currency cursor ', 1, 'Y');
2387: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_minimum_accountable_unit: '||l_minimum_accountable_unit, 1, 'Y');
2388: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_precision: '||l_precision,1,'Y');
2389: END IF;
2390:
2391: open c_ship_to_cust_account_id;
2392: fetch c_ship_to_cust_account_id into l_ship_cust_account_id_header;
2393: close c_ship_to_cust_account_id;
2394:
2395: IF aso_debug_pub.g_debug_flag = 'Y'
2396: THEN
2397: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_ship_to_cust_account_id ', 1, 'Y');
2398: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_ship_cust_account_id_header: '||l_ship_cust_account_id_header, 1, 'Y');
2399: END IF;
2400:
2401: OPEN c_int_org_location;
2394:
2395: IF aso_debug_pub.g_debug_flag = 'Y'
2396: THEN
2397: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_ship_to_cust_account_id ', 1, 'Y');
2398: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_ship_cust_account_id_header: '||l_ship_cust_account_id_header, 1, 'Y');
2399: END IF;
2400:
2401: OPEN c_int_org_location;
2402: Fetch c_int_org_location into l_int_org_location;
2403: close c_int_org_location;
2404:
2405: IF aso_debug_pub.g_debug_flag = 'Y'
2406: THEN
2407: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_int_org_location ', 1, 'Y');
2408: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_int_org_location : '||l_int_org_location, 1, 'Y');
2409: END IF;
2410:
2411: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM
2404:
2405: IF aso_debug_pub.g_debug_flag = 'Y'
2406: THEN
2407: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_int_org_location ', 1, 'Y');
2408: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_int_org_location : '||l_int_org_location, 1, 'Y');
2409: END IF;
2410:
2411: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM
2412: THEN
2413: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2414: IF
2415: aso_debug_pub.g_debug_flag = 'Y'
2416: THEN
2417: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
2418: END IF;
2419: ELSE
2420: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2421: IF
2420: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2421: IF
2422: aso_debug_pub.g_debug_flag = 'Y'
2423: THEN
2424: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');
2425: END IF;
2426: l_qte_line_tbl(1) := l_qte_line_rec;
2427: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Quote Line Id : '||p_qte_line_id, 1, 'Y');
2428: END IF;
2423: THEN
2424: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');
2425: END IF;
2426: l_qte_line_tbl(1) := l_qte_line_rec;
2427: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Quote Line Id : '||p_qte_line_id, 1, 'Y');
2428: END IF;
2429:
2430: IF l_qte_line_tbl.count>0
2431: THEN
2432: l_qte_line_rec:= l_qte_line_tbl(1);
2433: IF
2434: aso_debug_pub.g_debug_flag = 'Y'
2435: THEN
2436: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT:l_qte_line_tbl.count>0 ', 1, 'Y');
2437: END IF;
2438: ELSE
2439: IF
2440: aso_debug_pub.g_debug_flag = 'Y'
2438: ELSE
2439: IF
2440: aso_debug_pub.g_debug_flag = 'Y'
2441: THEN
2442: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT:l_qte_line_tbl.count=0 ', 1, 'Y');
2443: END IF;
2444: END IF;
2445:
2446: --bug7408162
2455: End;
2456:
2457: IF aso_debug_pub.g_debug_flag = 'Y'
2458: THEN
2459: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: value for l_bill_from_location_id'||l_bill_from_location_id, 1, 'Y');
2460: END IF;
2461:
2462: Open c_set_of_books_id;
2463: FETCH c_set_of_books_id into l_set_of_books_id;
2463: FETCH c_set_of_books_id into l_set_of_books_id;
2464: close c_set_of_books_id;
2465:
2466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2467: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');
2468: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_set_of_books_id : '||l_set_of_books_id, 1, 'Y');
2469: END IF;
2470:
2471:
2464: close c_set_of_books_id;
2465:
2466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2467: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');
2468: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_set_of_books_id : '||l_set_of_books_id, 1, 'Y');
2469: END IF;
2470:
2471:
2472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2469: END IF;
2470:
2471:
2472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2473: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2474: END IF;
2475: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2474: END IF;
2475: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2479: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_ship_header : '||l_site_use_id_ship_header, 1,'Y');
2480: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2475: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2479: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_ship_header : '||l_site_use_id_ship_header, 1,'Y');
2480: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2483: (l_qte_header_rec.quote_header_id, null);
2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2479: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_ship_header : '||l_site_use_id_ship_header, 1,'Y');
2480: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2483: (l_qte_header_rec.quote_header_id, null);
2484: IF aso_debug_pub.g_debug_flag ='Y' THEN
2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2483: (l_qte_header_rec.quote_header_id, null);
2484: IF aso_debug_pub.g_debug_flag ='Y' THEN
2485: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2486: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_bill_header : '||l_site_use_id_bill_header, 1,'Y');
2487: END IF;
2488: IF l_site_use_id_ship_header is not null THEN
2489: l_site_use_id:=l_site_use_id_ship_header;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2483: (l_qte_header_rec.quote_header_id, null);
2484: IF aso_debug_pub.g_debug_flag ='Y' THEN
2485: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2486: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_bill_header : '||l_site_use_id_bill_header, 1,'Y');
2487: END IF;
2488: IF l_site_use_id_ship_header is not null THEN
2489: l_site_use_id:=l_site_use_id_ship_header;
2490: IF aso_debug_pub.g_debug_flag ='Y' THEN
2487: END IF;
2488: IF l_site_use_id_ship_header is not null THEN
2489: l_site_use_id:=l_site_use_id_ship_header;
2490: IF aso_debug_pub.g_debug_flag ='Y' THEN
2491: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO c_get_acct_site ', 1, 'Y');
2492: END IF;
2493:
2494: Open c_get_acct_site(l_site_use_id);
2495: Fetch c_get_acct_site into l_acct_site_id_ship;
2495: Fetch c_get_acct_site into l_acct_site_id_ship;
2496: Close c_get_acct_site;
2497:
2498: IF aso_debug_pub.g_debug_flag ='Y' THEN
2499: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2500: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_ship : '||l_acct_site_id_ship, 1, 'Y');
2501: END IF;
2502: ELSE
2503: IF aso_debug_pub.g_debug_flag ='Y' THEN
2496: Close c_get_acct_site;
2497:
2498: IF aso_debug_pub.g_debug_flag ='Y' THEN
2499: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2500: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_ship : '||l_acct_site_id_ship, 1, 'Y');
2501: END IF;
2502: ELSE
2503: IF aso_debug_pub.g_debug_flag ='Y' THEN
2504: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2500: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_ship : '||l_acct_site_id_ship, 1, 'Y');
2501: END IF;
2502: ELSE
2503: IF aso_debug_pub.g_debug_flag ='Y' THEN
2504: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2505: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2506: END IF;
2507: l_acct_site_id_ship:=NULL;
2508: END IF;
2501: END IF;
2502: ELSE
2503: IF aso_debug_pub.g_debug_flag ='Y' THEN
2504: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2505: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2506: END IF;
2507: l_acct_site_id_ship:=NULL;
2508: END IF;
2509:
2509:
2510: IF l_site_use_id_bill_header is not null THEN
2511: l_site_use_id:=l_site_use_id_bill_header;
2512: IF aso_debug_pub.g_debug_flag ='Y' THEN
2513: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO c_get_acct_site ', 1, 'Y');
2514: END IF;
2515:
2516: Open c_get_acct_site(l_site_use_id);
2517: Fetch c_get_acct_site into l_acct_site_id_bill;
2517: Fetch c_get_acct_site into l_acct_site_id_bill;
2518: Close c_get_acct_site;
2519:
2520: IF aso_debug_pub.g_debug_flag ='Y' THEN
2521: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2522: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_bill : '||l_acct_site_id_bill, 1, 'Y');
2523: END IF;
2524: ELSE
2525: IF aso_debug_pub.g_debug_flag ='Y' THEN
2518: Close c_get_acct_site;
2519:
2520: IF aso_debug_pub.g_debug_flag ='Y' THEN
2521: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2522: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_bill : '||l_acct_site_id_bill, 1, 'Y');
2523: END IF;
2524: ELSE
2525: IF aso_debug_pub.g_debug_flag ='Y' THEN
2526: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2522: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_bill : '||l_acct_site_id_bill, 1, 'Y');
2523: END IF;
2524: ELSE
2525: IF aso_debug_pub.g_debug_flag ='Y' THEN
2526: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2527: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2528: END IF;
2529: l_acct_site_id_bill:=NULL;
2530: END IF;
2523: END IF;
2524: ELSE
2525: IF aso_debug_pub.g_debug_flag ='Y' THEN
2526: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2527: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2528: END IF;
2529: l_acct_site_id_bill:=NULL;
2530: END IF;
2531:
2533: fetch c_invoice_source_id into l_batch_source;
2534: CLOSE c_invoice_source_id;
2535:
2536: IF aso_debug_pub.g_debug_flag ='Y' THEN
2537: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id ', 1, 'Y');
2538: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id :l_batch_source '||l_batch_source, 1, 'Y');
2539: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id : x_return_status : '||x_return_status, 1, 'Y');
2541: END IF;
2534: CLOSE c_invoice_source_id;
2535:
2536: IF aso_debug_pub.g_debug_flag ='Y' THEN
2537: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id ', 1, 'Y');
2538: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id :l_batch_source '||l_batch_source, 1, 'Y');
2539: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id : x_return_status : '||x_return_status, 1, 'Y');
2541: END IF;
2542:
2535:
2536: IF aso_debug_pub.g_debug_flag ='Y' THEN
2537: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id ', 1, 'Y');
2538: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id :l_batch_source '||l_batch_source, 1, 'Y');
2539: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id : x_return_status : '||x_return_status, 1, 'Y');
2541: END IF;
2542:
2543: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2536: IF aso_debug_pub.g_debug_flag ='Y' THEN
2537: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id ', 1, 'Y');
2538: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id :l_batch_source '||l_batch_source, 1, 'Y');
2539: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id : x_return_status : '||x_return_status, 1, 'Y');
2541: END IF;
2542:
2543: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2544:
2539: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id : x_return_status : '||x_return_status, 1, 'Y');
2541: END IF;
2542:
2543: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2544:
2545: IF aso_debug_pub.g_debug_flag ='Y' THEN
2546: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2547: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');
2542:
2543: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2544:
2545: IF aso_debug_pub.g_debug_flag ='Y' THEN
2546: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2547: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');
2548: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2549: END IF;
2550:
2543: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2544:
2545: IF aso_debug_pub.g_debug_flag ='Y' THEN
2546: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2547: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');
2548: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2549: END IF;
2550:
2551: Open c_cust_trx_type_id(l_trx_type_id);
2544:
2545: IF aso_debug_pub.g_debug_flag ='Y' THEN
2546: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2547: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');
2548: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2549: END IF;
2550:
2551: Open c_cust_trx_type_id(l_trx_type_id);
2552: fetch c_cust_trx_type_id into l_ra_cust_trx_type_id;
2552: fetch c_cust_trx_type_id into l_ra_cust_trx_type_id;
2553: close c_cust_trx_type_id;
2554:
2555: IF aso_debug_pub.g_debug_flag ='Y' THEN
2556: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2557: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2558: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2559: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_return_status : '||x_return_status, 1, 'Y');
2560: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_msg_data : '||x_msg_data, 1, 'Y');
2553: close c_cust_trx_type_id;
2554:
2555: IF aso_debug_pub.g_debug_flag ='Y' THEN
2556: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2557: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2558: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2559: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_return_status : '||x_return_status, 1, 'Y');
2560: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_msg_data : '||x_msg_data, 1, 'Y');
2561: END IF;
2554:
2555: IF aso_debug_pub.g_debug_flag ='Y' THEN
2556: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2557: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2558: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2559: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_return_status : '||x_return_status, 1, 'Y');
2560: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_msg_data : '||x_msg_data, 1, 'Y');
2561: END IF;
2562:
2555: IF aso_debug_pub.g_debug_flag ='Y' THEN
2556: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2557: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2558: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2559: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_return_status : '||x_return_status, 1, 'Y');
2560: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_msg_data : '||x_msg_data, 1, 'Y');
2561: END IF;
2562:
2563: XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info(
2556: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2557: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2558: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2559: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_return_status : '||x_return_status, 1, 'Y');
2560: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API : x_msg_data : '||x_msg_data, 1, 'Y');
2561: END IF;
2562:
2563: XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info(
2564: x_return_status=>x_return_status,
2573: l_legal_entity_id:= x_legal_entity.legal_entity_id;
2574:
2575:
2576: IF aso_debug_pub.g_debug_flag ='Y' THEN
2577: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2578: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2579: --Added by anrajan on 05/10/2005
2580: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');
2574:
2575:
2576: IF aso_debug_pub.g_debug_flag ='Y' THEN
2577: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2578: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2579: --Added by anrajan on 05/10/2005
2580: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');
2582: END IF;
2576: IF aso_debug_pub.g_debug_flag ='Y' THEN
2577: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2578: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2579: --Added by anrajan on 05/10/2005
2580: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');
2582: END IF;
2583:
2584: --Insertion into the Header Temporary Table.
2577: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2578: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2579: --Added by anrajan on 05/10/2005
2580: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');
2582: END IF;
2583:
2584: --Insertion into the Header Temporary Table.
2585:
2583:
2584: --Insertion into the Header Temporary Table.
2585:
2586: IF aso_debug_pub.g_debug_flag ='Y' THEN
2587: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');
2588: END IF;
2589:
2590: DELETE FROM ZX_TRX_HEADERS_GT where
2591: APPLICATION_ID=697 and
2661: );
2662:
2663: print_tax_info(1,p_qte_header_id);
2664: IF aso_debug_pub.g_debug_flag ='Y' THEN
2665: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE THE QUOTE LINES LOOP ', 1, 'Y');
2666: END IF;
2667:
2668: DELETE FROM Zx_transaction_lines_gt
2669: WHERE APPLICATION_ID= 697
2675: FOR i in 1..l_qte_line_tbl.count
2676: LOOP
2677: l_qte_line_rec:=l_qte_line_tbl(i);
2678: IF aso_debug_pub.g_debug_flag ='Y' THEN
2679: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP : QUOTE LINE ID :'||l_qte_line_rec.QUOTE_LINE_ID, 1, 'Y');
2680: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');
2681: END IF;
2682: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2683:
2676: LOOP
2677: l_qte_line_rec:=l_qte_line_tbl(i);
2678: IF aso_debug_pub.g_debug_flag ='Y' THEN
2679: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP : QUOTE LINE ID :'||l_qte_line_rec.QUOTE_LINE_ID, 1, 'Y');
2680: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');
2681: END IF;
2682: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2683:
2684: --Condition added by anrajan on 06/10/2005 for Bug Number :4656728
2687: l_Shipment_Rec:=l_shipment_tbl(1);
2688: END IF;
2689:
2690: IF aso_debug_pub.g_debug_flag ='Y' THEN
2691: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');
2692: END IF;
2693:
2694: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2695: (p_qte_header_id,
2694: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2695: (p_qte_header_id,
2696: l_qte_line_rec.quote_line_id);
2697: IF aso_debug_pub.g_debug_flag ='Y' THEN
2698: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2699: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_site_use_id_bill_lines : '||l_site_use_id_bill_lines , 1, 'Y');
2700: END IF;
2701:
2702: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id
2695: (p_qte_header_id,
2696: l_qte_line_rec.quote_line_id);
2697: IF aso_debug_pub.g_debug_flag ='Y' THEN
2698: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2699: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_site_use_id_bill_lines : '||l_site_use_id_bill_lines , 1, 'Y');
2700: END IF;
2701:
2702: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id
2703: (p_qte_header_id,
2703: (p_qte_header_id,
2704: l_qte_line_rec.quote_line_id,
2705: l_Shipment_Rec.SHIPMENT_ID);
2706: IF aso_debug_pub.g_debug_flag ='Y' THEN
2707: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2708: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_site_use_id_ship_lines '||l_site_use_id_ship_lines , 1, 'Y');
2709: END IF;
2710:
2711: Open c_getlocinfo(l_site_use_id_bill_lines);
2704: l_qte_line_rec.quote_line_id,
2705: l_Shipment_Rec.SHIPMENT_ID);
2706: IF aso_debug_pub.g_debug_flag ='Y' THEN
2707: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2708: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_site_use_id_ship_lines '||l_site_use_id_ship_lines , 1, 'Y');
2709: END IF;
2710:
2711: Open c_getlocinfo(l_site_use_id_bill_lines);
2712: Fetch c_getlocinfo into l_acct_site_id_bill_lines,l_bill_cust_acct_id_lines;
2716: Fetch c_getlocinfo into l_acct_site_id_ship_lines,l_ship_cust_acct_id_lines;
2717: Close c_getlocinfo;
2718:
2719: IF aso_debug_pub.g_debug_flag ='Y' THEN
2720: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2721: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_bill_lines '||l_acct_site_id_bill_lines , 1, 'Y');
2722: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_cust_acct_id_lines '||l_bill_cust_acct_id_lines , 1, 'Y');
2723: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_ship_lines '||l_acct_site_id_ship_lines , 1, 'Y');
2724: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_cust_acct_id_lines '||l_ship_cust_acct_id_lines , 1, 'Y');
2717: Close c_getlocinfo;
2718:
2719: IF aso_debug_pub.g_debug_flag ='Y' THEN
2720: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2721: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_bill_lines '||l_acct_site_id_bill_lines , 1, 'Y');
2722: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_cust_acct_id_lines '||l_bill_cust_acct_id_lines , 1, 'Y');
2723: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_ship_lines '||l_acct_site_id_ship_lines , 1, 'Y');
2724: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_cust_acct_id_lines '||l_ship_cust_acct_id_lines , 1, 'Y');
2725: END IF;
2718:
2719: IF aso_debug_pub.g_debug_flag ='Y' THEN
2720: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2721: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_bill_lines '||l_acct_site_id_bill_lines , 1, 'Y');
2722: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_cust_acct_id_lines '||l_bill_cust_acct_id_lines , 1, 'Y');
2723: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_ship_lines '||l_acct_site_id_ship_lines , 1, 'Y');
2724: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_cust_acct_id_lines '||l_ship_cust_acct_id_lines , 1, 'Y');
2725: END IF;
2726:
2719: IF aso_debug_pub.g_debug_flag ='Y' THEN
2720: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2721: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_bill_lines '||l_acct_site_id_bill_lines , 1, 'Y');
2722: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_cust_acct_id_lines '||l_bill_cust_acct_id_lines , 1, 'Y');
2723: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_ship_lines '||l_acct_site_id_ship_lines , 1, 'Y');
2724: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_cust_acct_id_lines '||l_ship_cust_acct_id_lines , 1, 'Y');
2725: END IF;
2726:
2727: IF aso_debug_pub.g_debug_flag ='Y' THEN
2720: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2721: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_bill_lines '||l_acct_site_id_bill_lines , 1, 'Y');
2722: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_cust_acct_id_lines '||l_bill_cust_acct_id_lines , 1, 'Y');
2723: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_acct_site_id_ship_lines '||l_acct_site_id_ship_lines , 1, 'Y');
2724: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_cust_acct_id_lines '||l_ship_cust_acct_id_lines , 1, 'Y');
2725: END IF;
2726:
2727: IF aso_debug_pub.g_debug_flag ='Y' THEN
2728: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_shiplocation', 1, 'Y');
2724: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_cust_acct_id_lines '||l_ship_cust_acct_id_lines , 1, 'Y');
2725: END IF;
2726:
2727: IF aso_debug_pub.g_debug_flag ='Y' THEN
2728: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_shiplocation', 1, 'Y');
2729: END IF;
2730:
2731: IF
2732: l_Shipment_Rec.ship_to_party_site_id is not null
2738: FETCH c_shiplocation into l_ship_to_location;
2739: close c_shiplocation;
2740:
2741: IF aso_debug_pub.g_debug_flag ='Y' THEN
2742: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2743: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_to_location '||l_ship_to_location , 1, 'Y');
2744: END IF;
2745:
2746: IF
2739: close c_shiplocation;
2740:
2741: IF aso_debug_pub.g_debug_flag ='Y' THEN
2742: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2743: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_ship_to_location '||l_ship_to_location , 1, 'Y');
2744: END IF;
2745:
2746: IF
2747: l_qte_line_rec.invoice_to_party_site_id is not null
2754: FETCH c_shiplocation into l_bill_to_location;
2755: close c_shiplocation;
2756:
2757: IF aso_debug_pub.g_debug_flag ='Y' THEN
2758: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2759: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_to_location '||l_bill_to_location , 1, 'Y');
2760: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2761: END IF;
2762:
2755: close c_shiplocation;
2756:
2757: IF aso_debug_pub.g_debug_flag ='Y' THEN
2758: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2759: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_to_location '||l_bill_to_location , 1, 'Y');
2760: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2761: END IF;
2762:
2763: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2756:
2757: IF aso_debug_pub.g_debug_flag ='Y' THEN
2758: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2759: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_to_location '||l_bill_to_location , 1, 'Y');
2760: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2761: END IF;
2762:
2763: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2764: IF aso_debug_pub.g_debug_flag ='Y' THEN
2759: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_bill_to_location '||l_bill_to_location , 1, 'Y');
2760: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2761: END IF;
2762:
2763: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2764: IF aso_debug_pub.g_debug_flag ='Y' THEN
2765: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2766: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_trx_type_id '||l_trx_type_id , 1, 'Y');
2767: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_product_type ', 1, 'Y');
2761: END IF;
2762:
2763: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2764: IF aso_debug_pub.g_debug_flag ='Y' THEN
2765: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2766: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_trx_type_id '||l_trx_type_id , 1, 'Y');
2767: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_product_type ', 1, 'Y');
2768: END IF;
2769:
2762:
2763: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2764: IF aso_debug_pub.g_debug_flag ='Y' THEN
2765: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2766: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_trx_type_id '||l_trx_type_id , 1, 'Y');
2767: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_product_type ', 1, 'Y');
2768: END IF;
2769:
2770: Open c_product_type;
2763: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2764: IF aso_debug_pub.g_debug_flag ='Y' THEN
2765: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO ASO_TAX_INT.get_ra_trx_type_id ', 1, 'Y');
2766: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_trx_type_id '||l_trx_type_id , 1, 'Y');
2767: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_product_type ', 1, 'Y');
2768: END IF;
2769:
2770: Open c_product_type;
2771: Fetch c_product_type into l_product_type;
2771: Fetch c_product_type into l_product_type;
2772: close c_product_type;
2773:
2774: IF aso_debug_pub.g_debug_flag ='Y' THEN
2775: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_product_type ' , 1, 'Y');
2776: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_product_type: '||l_product_type, 1, 'Y');
2777: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_tax ', 1, 'Y');
2778: END IF;
2779:
2772: close c_product_type;
2773:
2774: IF aso_debug_pub.g_debug_flag ='Y' THEN
2775: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_product_type ' , 1, 'Y');
2776: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_product_type: '||l_product_type, 1, 'Y');
2777: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_tax ', 1, 'Y');
2778: END IF;
2779:
2780:
2773:
2774: IF aso_debug_pub.g_debug_flag ='Y' THEN
2775: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_product_type ' , 1, 'Y');
2776: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_product_type: '||l_product_type, 1, 'Y');
2777: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_tax ', 1, 'Y');
2778: END IF;
2779:
2780:
2781: Open c_tax;
2782: fetch c_tax into l_hdr_tax_exempt_flag,l_hdr_tax_exempt_number,l_hdr_tax_exempt_reason_code;
2783: close c_tax;
2784:
2785: IF aso_debug_pub.g_debug_flag ='Y' THEN
2786: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2787: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_FLAG: '||l_hdr_tax_exempt_flag , 1, 'Y');
2788: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_NUMBER : '||l_hdr_tax_exempt_number , 1, 'Y');
2789: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_REASON_CODE : '||l_hdr_tax_exempt_reason_code , 1, 'Y');
2790: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2783: close c_tax;
2784:
2785: IF aso_debug_pub.g_debug_flag ='Y' THEN
2786: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2787: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_FLAG: '||l_hdr_tax_exempt_flag , 1, 'Y');
2788: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_NUMBER : '||l_hdr_tax_exempt_number , 1, 'Y');
2789: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_REASON_CODE : '||l_hdr_tax_exempt_reason_code , 1, 'Y');
2790: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2791: END IF;
2784:
2785: IF aso_debug_pub.g_debug_flag ='Y' THEN
2786: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2787: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_FLAG: '||l_hdr_tax_exempt_flag , 1, 'Y');
2788: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_NUMBER : '||l_hdr_tax_exempt_number , 1, 'Y');
2789: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_REASON_CODE : '||l_hdr_tax_exempt_reason_code , 1, 'Y');
2790: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2791: END IF;
2792:
2785: IF aso_debug_pub.g_debug_flag ='Y' THEN
2786: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2787: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_FLAG: '||l_hdr_tax_exempt_flag , 1, 'Y');
2788: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_NUMBER : '||l_hdr_tax_exempt_number , 1, 'Y');
2789: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_REASON_CODE : '||l_hdr_tax_exempt_reason_code , 1, 'Y');
2790: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2791: END IF;
2792:
2793:
2786: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2787: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_FLAG: '||l_hdr_tax_exempt_flag , 1, 'Y');
2788: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_NUMBER : '||l_hdr_tax_exempt_number , 1, 'Y');
2789: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_HDR_TAX_EXEMPT_REASON_CODE : '||l_hdr_tax_exempt_reason_code , 1, 'Y');
2790: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_cust_trx_type_id ', 1, 'Y');
2791: END IF;
2792:
2793:
2794: Open c_cust_trx_type_id(l_trx_type_id);
2795: fetch c_cust_trx_type_id into l_ra_cust_trx_type_id;
2796: close c_cust_trx_type_id;
2797:
2798: IF aso_debug_pub.g_debug_flag ='Y' THEN
2799: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2800: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2801: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_LOCATION_ID ', 1, 'Y');
2802: END IF;
2803:
2796: close c_cust_trx_type_id;
2797:
2798: IF aso_debug_pub.g_debug_flag ='Y' THEN
2799: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2800: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2801: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_LOCATION_ID ', 1, 'Y');
2802: END IF;
2803:
2804:
2797:
2798: IF aso_debug_pub.g_debug_flag ='Y' THEN
2799: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2800: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id : '||l_ra_cust_trx_type_id , 1, 'Y');
2801: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_LOCATION_ID ', 1, 'Y');
2802: END IF;
2803:
2804:
2805: OPEN c_LOCATION_ID;
2806: Fetch c_LOCATION_ID into l_SHIP_FROM_LOCATION_ID;
2807: close c_LOCATION_ID;
2808:
2809: IF aso_debug_pub.g_debug_flag ='Y' THEN
2810: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_LOCATION_ID ', 1, 'Y');
2811: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_SHIP_FROM_LOCATION_ID : '||l_SHIP_FROM_LOCATION_ID , 1, 'Y');
2812: --aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2813: END IF;
2814:
2807: close c_LOCATION_ID;
2808:
2809: IF aso_debug_pub.g_debug_flag ='Y' THEN
2810: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_LOCATION_ID ', 1, 'Y');
2811: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_SHIP_FROM_LOCATION_ID : '||l_SHIP_FROM_LOCATION_ID , 1, 'Y');
2812: --aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2813: END IF;
2814:
2815:
2808:
2809: IF aso_debug_pub.g_debug_flag ='Y' THEN
2810: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_LOCATION_ID ', 1, 'Y');
2811: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_SHIP_FROM_LOCATION_ID : '||l_SHIP_FROM_LOCATION_ID , 1, 'Y');
2812: --aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2813: END IF;
2814:
2815:
2816: -- new code added by suyog bug 5061912
2820: FETCH c_get_resource_id into l_resource_id;
2821: CLOSE c_get_resource_id;
2822:
2823: IF aso_debug_pub.g_debug_flag ='Y' THEN
2824: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_get_resource_id ', 1, 'Y');
2825: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_resource_id: '|| l_resource_id , 1, 'Y');
2826: END IF;
2827:
2828: -- get the org id based upon the resource id and the trxn date
2821: CLOSE c_get_resource_id;
2822:
2823: IF aso_debug_pub.g_debug_flag ='Y' THEN
2824: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_get_resource_id ', 1, 'Y');
2825: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_resource_id: '|| l_resource_id , 1, 'Y');
2826: END IF;
2827:
2828: -- get the org id based upon the resource id and the trxn date
2829: OPEN c_get_org_id(l_resource_id);
2830: FETCH c_get_org_id into l_poo_party_id;
2831: CLOSE c_get_org_id;
2832:
2833: IF aso_debug_pub.g_debug_flag ='Y' THEN
2834: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_get_org_id ', 1, 'Y');
2835: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_poo_party_id: '|| l_poo_party_id , 1, 'Y');
2836: END IF;
2837:
2838: -- get the location based upon the org id
2831: CLOSE c_get_org_id;
2832:
2833: IF aso_debug_pub.g_debug_flag ='Y' THEN
2834: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_get_org_id ', 1, 'Y');
2835: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_poo_party_id: '|| l_poo_party_id , 1, 'Y');
2836: END IF;
2837:
2838: -- get the location based upon the org id
2839: OPEN c_get_location_id(l_poo_party_id);
2840: FETCH c_get_location_id into l_poo_location_id;
2841: CLOSE c_get_location_id;
2842:
2843: IF aso_debug_pub.g_debug_flag ='Y' THEN
2844: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_get_location_id ', 1, 'Y');
2845: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_poo_location_id: '|| l_poo_location_id , 1, 'Y');
2846: END IF;
2847:
2848: -- POA PARTY ID is same as the internal_organization_id
2841: CLOSE c_get_location_id;
2842:
2843: IF aso_debug_pub.g_debug_flag ='Y' THEN
2844: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_get_location_id ', 1, 'Y');
2845: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_poo_location_id: '|| l_poo_location_id , 1, 'Y');
2846: END IF;
2847:
2848: -- POA PARTY ID is same as the internal_organization_id
2849: -- POA LOCATION ID is same as the l_int_org_location
2848: -- POA PARTY ID is same as the internal_organization_id
2849: -- POA LOCATION ID is same as the l_int_org_location
2850:
2851: IF aso_debug_pub.g_debug_flag ='Y' THEN
2852: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_party_id: '|| l_qte_header_rec.ORG_ID , 1, 'Y');
2853: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_location_id: '|| l_int_org_location , 1, 'Y');
2854: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2855: END IF;
2856:
2849: -- POA LOCATION ID is same as the l_int_org_location
2850:
2851: IF aso_debug_pub.g_debug_flag ='Y' THEN
2852: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_party_id: '|| l_qte_header_rec.ORG_ID , 1, 'Y');
2853: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_location_id: '|| l_int_org_location , 1, 'Y');
2854: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2855: END IF;
2856:
2857: -- end of new code added by suyog
2850:
2851: IF aso_debug_pub.g_debug_flag ='Y' THEN
2852: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_party_id: '|| l_qte_header_rec.ORG_ID , 1, 'Y');
2853: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_location_id: '|| l_int_org_location , 1, 'Y');
2854: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2855: END IF;
2856:
2857: -- end of new code added by suyog
2858:
2988:
2989: END LOOP;
2990: print_tax_info(2,p_qte_header_id);
2991: IF aso_debug_pub.g_debug_flag ='Y' THEN
2992: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
2993: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
2994: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
2995: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
2996: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
2989: END LOOP;
2990: print_tax_info(2,p_qte_header_id);
2991: IF aso_debug_pub.g_debug_flag ='Y' THEN
2992: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
2993: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
2994: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
2995: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
2996: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
2997: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
2990: print_tax_info(2,p_qte_header_id);
2991: IF aso_debug_pub.g_debug_flag ='Y' THEN
2992: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
2993: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
2994: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
2995: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
2996: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
2997: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
2998: l_tax_start_time := dbms_utility.get_time;
2991: IF aso_debug_pub.g_debug_flag ='Y' THEN
2992: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
2993: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
2994: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
2995: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
2996: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
2997: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
2998: l_tax_start_time := dbms_utility.get_time;
2999: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');
2992: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
2993: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
2994: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
2995: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
2996: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
2997: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
2998: l_tax_start_time := dbms_utility.get_time;
2999: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');
3000: END IF;
2993: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
2994: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
2995: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
2996: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
2997: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
2998: l_tax_start_time := dbms_utility.get_time;
2999: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');
3000: END IF;
3001:
2995: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
2996: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
2997: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
2998: l_tax_start_time := dbms_utility.get_time;
2999: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');
3000: END IF;
3001:
3002: --Changes done by anrajan on 20/09/05
3003: l_msg_cnt1:= FND_MSG_PUB.Count_Msg;
3001:
3002: --Changes done by anrajan on 20/09/05
3003: l_msg_cnt1:= FND_MSG_PUB.Count_Msg;
3004: IF aso_debug_pub.g_debug_flag ='Y' THEN
3005: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: Message Count Before Tax call : '|| l_msg_cnt1, 1, 'Y');
3006: END IF;
3007:
3008: ZX_API_PUB.calculate_tax(p_api_version => p_api_version_number,
3009: p_init_msg_list => l_init_msg_list,
3015:
3016: --Changes done by anrajan on 20/09/05
3017: l_msg_cnt2:=FND_MSG_PUB.Count_Msg;
3018: IF aso_debug_pub.g_debug_flag ='Y' THEN
3019: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: Message Count After Tax call : '|| l_msg_cnt2, 1, 'Y');
3020: END IF;
3021:
3022: IF aso_debug_pub.g_debug_flag ='Y' THEN
3023: l_tax_end_time := dbms_utility.get_time;
3020: END IF;
3021:
3022: IF aso_debug_pub.g_debug_flag ='Y' THEN
3023: l_tax_end_time := dbms_utility.get_time;
3024: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3025: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3026: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3027: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3028: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');
3021:
3022: IF aso_debug_pub.g_debug_flag ='Y' THEN
3023: l_tax_end_time := dbms_utility.get_time;
3024: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3025: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3026: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3027: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3028: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');
3029: END IF;
3023: l_tax_end_time := dbms_utility.get_time;
3024: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3025: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3026: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3027: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3028: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');
3029: END IF;
3030:
3031: print_tax_info(3,p_qte_header_id);
3024: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3025: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3026: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3027: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3028: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');
3029: END IF;
3030:
3031: print_tax_info(3,p_qte_header_id);
3032:
3033: IF x_return_status='S' THEN
3034:
3035: if p_qte_line_id is not null THEN
3036: IF aso_debug_pub.g_debug_flag ='Y' THEN
3037: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3038: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id||'; QUOTE LINE ID : '||p_qte_line_id , 1, 'Y');
3039: END IF;
3040: Delete from
3041: ASO_TAX_DETAILS
3034:
3035: if p_qte_line_id is not null THEN
3036: IF aso_debug_pub.g_debug_flag ='Y' THEN
3037: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3038: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id||'; QUOTE LINE ID : '||p_qte_line_id , 1, 'Y');
3039: END IF;
3040: Delete from
3041: ASO_TAX_DETAILS
3042: where
3044: and
3045: QUOTE_LINE_ID=p_qte_line_id;
3046: ELSE
3047: IF aso_debug_pub.g_debug_flag ='Y' THEN
3048: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3049: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id,1, 'Y');
3050: END IF;
3051: Delete from ASO_TAX_DETAILS
3052: where QUOTE_HEADER_ID=p_qte_header_id
3045: QUOTE_LINE_ID=p_qte_line_id;
3046: ELSE
3047: IF aso_debug_pub.g_debug_flag ='Y' THEN
3048: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3049: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id,1, 'Y');
3050: END IF;
3051: Delete from ASO_TAX_DETAILS
3052: where QUOTE_HEADER_ID=p_qte_header_id
3053: and QUOTE_LINE_ID is not null;
3097: ;
3098:
3099: --Changed by Anoop on 14 Sep 2005.
3100: IF aso_debug_pub.g_debug_flag ='Y' THEN
3101: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :Number of rows inserted : '||sql%rowcount, 1, 'Y');
3102: END IF;
3103:
3104: ELSE
3105: IF aso_debug_pub.g_debug_flag ='Y' THEN
3102: END IF;
3103:
3104: ELSE
3105: IF aso_debug_pub.g_debug_flag ='Y' THEN
3106: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN NOT SUCCESSFUL ', 1, 'Y');
3107: END IF;
3108: --Changes done by anrajan on 20/09/05
3109: for i in 1..(l_msg_cnt2-l_msg_cnt1)
3110: loop
3112: FND_MSG_PUB.GET(p_msg_index => l_msg_cnt1+1,
3113: p_data =>X_Msg_Data,
3114: p_encoded =>'F',
3115: p_msg_index_out =>X_Msg_Count);
3116: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :X_Msg_Data : '||X_Msg_Data, 1, 'Y');
3117: END IF;
3118: FND_MSG_PUB.Delete_Msg(l_msg_cnt1+1);
3119: END LOOP;
3120: x_return_status := FND_API.G_RET_STS_SUCCESS;
3388: l_order_type_id NUMBER := p_order_type_id;
3389: BEGIN
3390:
3391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3392: aso_debug_pub.add(' ASO_TAX_INT :p_order_type_id'||p_order_type_id , 1, 'N');
3393: END IF;
3394:
3395: IF p_order_type_id is NULL OR p_order_type_id = FND_API.G_MISS_NUM THEN
3396:
3404:
3405: -- Change END
3406:
3407: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3408: aso_debug_pub.add(' ASO_TAX_INT Porder_type id is null:l_order_type_id'||l_order_type_id , 1, 'N');
3409: END IF;
3410:
3411: END IF;
3412: OPEN C_OE_trns(l_order_type_id);
3413: FETCH C_OE_trns INTO l_in_line_type, l_out_line_type, l_cust_trx_type_id;
3414:
3415: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3416:
3417: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_in_line_type,l_out_line_type,l_cust_trx_type_id'||l_in_line_type , 1, 'N');
3418: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_out_line_type'||l_out_line_type , 1, 'N');
3419: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_cust_trx_type_id'||l_cust_trx_type_id , 1, 'N');
3420:
3421: END IF;
3414:
3415: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3416:
3417: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_in_line_type,l_out_line_type,l_cust_trx_type_id'||l_in_line_type , 1, 'N');
3418: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_out_line_type'||l_out_line_type , 1, 'N');
3419: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_cust_trx_type_id'||l_cust_trx_type_id , 1, 'N');
3420:
3421: END IF;
3422:
3415: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3416:
3417: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_in_line_type,l_out_line_type,l_cust_trx_type_id'||l_in_line_type , 1, 'N');
3418: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_out_line_type'||l_out_line_type , 1, 'N');
3419: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_cust_trx_type_id'||l_cust_trx_type_id , 1, 'N');
3420:
3421: END IF;
3422:
3423:
3424: IF C_OE_trns%NOTFOUND THEN
3425: NULL;
3426:
3427: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3428: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:NOT FOUND' , 1, 'N');
3429: END IF;
3430:
3431: END IF;
3432: CLOSE C_OE_trns;
3432: CLOSE C_OE_trns;
3433: IF p_qte_line_rec.order_line_type_id is NULL or p_qte_line_rec.order_line_type_id = FND_API.G_MISS_NUM THEN
3434:
3435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3436: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.order_line_type_id is NULL' , 1, 'N');
3437: END IF;
3438:
3439: IF p_qte_line_rec.line_category_code = 'ORDER' THEN
3440: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3437: END IF;
3438:
3439: IF p_qte_line_rec.line_category_code = 'ORDER' THEN
3440: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3441: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.line_category_code '|| p_qte_line_rec.line_category_code , 1, 'N');
3442: END IF;
3443: l_line_type_id := l_out_line_type;
3444:
3445: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3442: END IF;
3443: l_line_type_id := l_out_line_type;
3444:
3445: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3446: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.l_out_line_typ '|| l_out_line_type , 1, 'N');
3447: END IF;
3448:
3449: ELSE
3450: l_line_type_id := l_in_line_type;
3448:
3449: ELSE
3450: l_line_type_id := l_in_line_type;
3451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3452: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.li_n_line_typ '|| l_in_line_type , 1, 'N');
3453: END IF;
3454:
3455: END IF;
3456: ELSE
3457: l_line_type_id := p_qte_line_rec.order_line_type_id ;
3458: END IF;
3459:
3460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3461: aso_debug_pub.add(' ASO_TAX_INT l_line_type_id '|| l_line_type_id , 1, 'N');
3462: END IF;
3463:
3464: IF p_qte_line_rec.line_category_code <> 'RETURN' THEN -- Standard Order Line
3465:
3463:
3464: IF p_qte_line_rec.line_category_code <> 'RETURN' THEN -- Standard Order Line
3465:
3466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3467: aso_debug_pub.add(' ASO_TAX_INT Line Category return ' , 1, 'N');
3468: END IF;
3469:
3470: SELECT NVL(lt.cust_trx_type_id, 0)
3471: INTO l_cust_trx_type_id
3472: FROM oe_line_types_v lt
3473: WHERE lt.line_type_id = l_line_type_id;
3474:
3475: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3476: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id Category return '||l_cust_trx_type_id , 1, 'N');
3477: END IF;
3478:
3479: IF l_cust_trx_type_id = 0 THEN
3480:
3478:
3479: IF l_cust_trx_type_id = 0 THEN
3480:
3481: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3482: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0before '||l_cust_trx_type_id , 1, 'N');
3483: END IF;
3484:
3485: SELECT NVL(ot.cust_trx_type_id, 0)
3486: INTO l_cust_trx_type_id
3487: FROM oe_order_types_v ot
3488: WHERE ot.order_type_id =l_order_type_id;
3489:
3490: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3491: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0after '||l_cust_trx_type_id , 1, 'N');
3492: END IF;
3493:
3494: IF l_cust_trx_type_id = 0 THEN
3495:
3493:
3494: IF l_cust_trx_type_id = 0 THEN
3495:
3496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3497: aso_debug_pub.add(' ASO_TAX_INT default from oe_invoice_trans profile ' , 1, 'N');
3498: END IF;
3499:
3500: SELECT NVL(FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID'), 0)
3501: INTO l_cust_trx_type_id
3505: RETURN(l_cust_trx_type_id);
3506: ELSE -- Non Referenced Return Line
3507:
3508: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3509: aso_debug_pub.add(' ASO_TAX_INT Non Referenced Return Line ' , 1, 'N');
3510: END IF;
3511:
3512: SELECT NVL(lt.cust_trx_type_id, 0)
3513: INTO l_inv_cust_trx_type_id
3515: WHERE lt.line_type_id = l_line_type_id;
3516:
3517:
3518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3519: aso_debug_pub.add(' ASO_TAX_INT Non Referenced Return Line l_inv_cust_trx_type_id '||l_inv_cust_trx_type_id , 1, 'N');
3520: END IF;
3521:
3522: IF l_inv_cust_trx_type_id = 0 THEN
3523: SELECT NVL(DECODE(ot.order_category_code, 'RETURN',ot.cust_trx_type_id, 0), 0)
3527: END IF;
3528: IF l_inv_cust_trx_type_id <> 0 THEN
3529:
3530: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3531: aso_debug_pub.add(' ASO_TAX_INT Non Referenced Return Line credit memo ' , 1, 'N');
3532: END IF;
3533:
3534: SELECT nvl(ctt.credit_memo_type_id, 0)
3535: INTO l_cust_trx_type_id
3556: EXCEPTION
3557: WHEN OTHERS THEN
3558:
3559: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3560: aso_debug_pub.add(' ASO_TAX_INT GET_RA_TRX In WHEN others ' , 1, 'N');
3561: END IF;
3562:
3563: return(0);
3564: END GET_ra_trx_type_ID;
3928: END IF;
3929:
3930: END print_tax_info;
3931:
3932: End ASO_TAX_INT;