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.ASO_TAX_INT dependencies on ASO_TAX_INT

Line 1: PACKAGE BODY ASO_TAX_INT as

1: PACKAGE BODY ASO_TAX_INT as
2: /* $Header: asoitaxb.pls 120.29.12020000.2 2012/09/25 05:35:03 akushwah ship $ */
3: -- Start of Comments
4: -- Package name : ASO_TAX_INT
5: -- Purpose :

Line 4: -- Package name : ASO_TAX_INT

1: PACKAGE BODY ASO_TAX_INT as
2: /* $Header: asoitaxb.pls 120.29.12020000.2 2012/09/25 05:35:03 akushwah ship $ */
3: -- Start of Comments
4: -- Package name : ASO_TAX_INT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_TAX_INT';

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:

Line 819: aso_debug_pub.add('ASO_TAX_INT: Begin ASO_TAX_LINE', 1, 'Y');

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:

Line 821: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');

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:

Line 822: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');

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

Line 830: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Header_Row', 1, 'Y');

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:

Line 857: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Before call to ARP_TAX_CRM_INTEGRATION_PKG.tax_method', 1, 'Y');

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:

Line 874: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Exception raised in ARP_TAX_CRM_INTEGRATION_PKG.tax_method', 1, 'Y');

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.';

Line 963: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Before call to get_ra_trx_type_id', 1, 'Y');

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:

Line 1468: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Inside IF cond l_tax_method = VERTEX ', 1, 'Y');

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

Line 1538: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: Inside IF cond l_tax_method = TAXWARE ', 1, 'Y');

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

Line 2177: aso_debug_pub.add('ASO_TAX_INT: End ASO_TAX_LINE', 1, 'Y');

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: *

Line 2199: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_TAX_INT';

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;

Line 2371: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');

2367: x_return_status := FND_API.G_RET_STS_SUCCESS;
2368:
2369: IF aso_debug_pub.g_debug_flag = 'Y'
2370: THEN
2371: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2372: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2373: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2374: END IF;
2375: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

Line 2372: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');

2368:
2369: IF aso_debug_pub.g_debug_flag = 'Y'
2370: THEN
2371: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2372: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2373: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2374: END IF;
2375: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2376: IF aso_debug_pub.g_debug_flag = 'Y'

Line 2373: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');

2369: IF aso_debug_pub.g_debug_flag = 'Y'
2370: THEN
2371: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2372: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2373: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2374: END IF;
2375: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2376: IF aso_debug_pub.g_debug_flag = 'Y'
2377: THEN

Line 2378: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');

2374: END IF;
2375: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2376: IF aso_debug_pub.g_debug_flag = 'Y'
2377: THEN
2378: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');
2379: END IF;
2380:
2381: l_currency_code := l_qte_header_rec.currency_code;
2382: IF aso_debug_pub.g_debug_flag = 'Y'

Line 2384: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_currency_code: '|| l_currency_code, 1, 'Y');

2380:
2381: l_currency_code := l_qte_header_rec.currency_code;
2382: IF aso_debug_pub.g_debug_flag = 'Y'
2383: THEN
2384: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_currency_code: '|| l_currency_code, 1, 'Y');
2385: END IF;
2386:
2387: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2388: IF aso_debug_pub.g_debug_flag = 'Y'

Line 2390: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');

2386:
2387: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2388: IF aso_debug_pub.g_debug_flag = 'Y'
2389: THEN
2390: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');
2391: END IF;
2392:
2393: --Condition added on 20/09/05 by anrajan
2394: IF l_Shipment_header_tbl.count > 0

Line 2405: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_currency cursor ', 1, 'Y');

2401: CLOSE c_currency;
2402:
2403: IF aso_debug_pub.g_debug_flag = 'Y'
2404: THEN
2405: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_currency cursor ', 1, 'Y');
2406: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_minimum_accountable_unit: '||l_minimum_accountable_unit, 1, 'Y');
2407: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_precision: '||l_precision,1,'Y');
2408: END IF;
2409:

Line 2406: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_minimum_accountable_unit: '||l_minimum_accountable_unit, 1, 'Y');

2402:
2403: IF aso_debug_pub.g_debug_flag = 'Y'
2404: THEN
2405: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_currency cursor ', 1, 'Y');
2406: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_minimum_accountable_unit: '||l_minimum_accountable_unit, 1, 'Y');
2407: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_precision: '||l_precision,1,'Y');
2408: END IF;
2409:
2410: open c_ship_to_cust_account_id;

Line 2407: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_precision: '||l_precision,1,'Y');

2403: IF aso_debug_pub.g_debug_flag = 'Y'
2404: THEN
2405: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_currency cursor ', 1, 'Y');
2406: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_minimum_accountable_unit: '||l_minimum_accountable_unit, 1, 'Y');
2407: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_precision: '||l_precision,1,'Y');
2408: END IF;
2409:
2410: open c_ship_to_cust_account_id;
2411: fetch c_ship_to_cust_account_id into l_ship_cust_account_id_header;

Line 2416: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_ship_to_cust_account_id ', 1, 'Y');

2412: close c_ship_to_cust_account_id;
2413:
2414: IF aso_debug_pub.g_debug_flag = 'Y'
2415: THEN
2416: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_ship_to_cust_account_id ', 1, 'Y');
2417: 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');
2418: END IF;
2419:
2420: OPEN c_int_org_location;

Line 2417: 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');

2413:
2414: IF aso_debug_pub.g_debug_flag = 'Y'
2415: THEN
2416: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_ship_to_cust_account_id ', 1, 'Y');
2417: 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');
2418: END IF;
2419:
2420: OPEN c_int_org_location;
2421: Fetch c_int_org_location into l_int_org_location;

Line 2426: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_int_org_location ', 1, 'Y');

2422: close c_int_org_location;
2423:
2424: IF aso_debug_pub.g_debug_flag = 'Y'
2425: THEN
2426: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_int_org_location ', 1, 'Y');
2427: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_int_org_location : '||l_int_org_location, 1, 'Y');
2428: END IF;
2429:
2430: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM

Line 2427: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_int_org_location : '||l_int_org_location, 1, 'Y');

2423:
2424: IF aso_debug_pub.g_debug_flag = 'Y'
2425: THEN
2426: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_int_org_location ', 1, 'Y');
2427: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_int_org_location : '||l_int_org_location, 1, 'Y');
2428: END IF;
2429:
2430: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM
2431: THEN

Line 2436: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');

2432: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2433: IF
2434: aso_debug_pub.g_debug_flag = 'Y'
2435: THEN
2436: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
2437: END IF;
2438: ELSE
2439: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2440: IF

Line 2443: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');

2439: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2440: IF
2441: aso_debug_pub.g_debug_flag = 'Y'
2442: THEN
2443: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');
2444: END IF;
2445: l_qte_line_tbl(1) := l_qte_line_rec;
2446: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Quote Line Id : '||p_qte_line_id, 1, 'Y');
2447: END IF;

Line 2446: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Quote Line Id : '||p_qte_line_id, 1, 'Y');

2442: THEN
2443: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');
2444: END IF;
2445: l_qte_line_tbl(1) := l_qte_line_rec;
2446: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Quote Line Id : '||p_qte_line_id, 1, 'Y');
2447: END IF;
2448:
2449: IF l_qte_line_tbl.count>0
2450: THEN

Line 2455: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT:l_qte_line_tbl.count>0 ', 1, 'Y');

2451: l_qte_line_rec:= l_qte_line_tbl(1);
2452: IF
2453: aso_debug_pub.g_debug_flag = 'Y'
2454: THEN
2455: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT:l_qte_line_tbl.count>0 ', 1, 'Y');
2456: END IF;
2457: ELSE
2458: IF
2459: aso_debug_pub.g_debug_flag = 'Y'

Line 2461: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT:l_qte_line_tbl.count=0 ', 1, 'Y');

2457: ELSE
2458: IF
2459: aso_debug_pub.g_debug_flag = 'Y'
2460: THEN
2461: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT:l_qte_line_tbl.count=0 ', 1, 'Y');
2462: END IF;
2463: END IF;
2464:
2465: /*** Added this SQL for Bug 8474803 and 7408162 ***/

Line 2478: 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');

2474: End;
2475:
2476: IF aso_debug_pub.g_debug_flag = 'Y'
2477: THEN
2478: 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');
2479: END IF;
2480:
2481: Open c_set_of_books_id;
2482: FETCH c_set_of_books_id into l_set_of_books_id;

Line 2486: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');

2482: FETCH c_set_of_books_id into l_set_of_books_id;
2483: close c_set_of_books_id;
2484:
2485: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2486: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');
2487: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_set_of_books_id : '||l_set_of_books_id, 1, 'Y');
2488: END IF;
2489:
2490:

Line 2487: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_set_of_books_id : '||l_set_of_books_id, 1, 'Y');

2483: close c_set_of_books_id;
2484:
2485: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2486: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');
2487: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_set_of_books_id : '||l_set_of_books_id, 1, 'Y');
2488: END IF;
2489:
2490:
2491: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2492: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');

2488: END IF;
2489:
2490:
2491: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2492: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2493: END IF;
2494: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2495: (l_qte_header_rec.quote_header_id,null,l_Shipment_header_rec.shipment_id); -- bug 8228519 passing shipment id for quote header
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2497: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');

2493: END IF;
2494: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2495: (l_qte_header_rec.quote_header_id,null,l_Shipment_header_rec.shipment_id); -- bug 8228519 passing shipment id for quote header
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2497: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2498: 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');
2499: 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');
2500: END IF;
2501: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id

Line 2498: 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');

2494: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2495: (l_qte_header_rec.quote_header_id,null,l_Shipment_header_rec.shipment_id); -- bug 8228519 passing shipment id for quote header
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2497: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2498: 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');
2499: 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');
2500: END IF;
2501: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2502: (l_qte_header_rec.quote_header_id, null);

Line 2499: 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');

2495: (l_qte_header_rec.quote_header_id,null,l_Shipment_header_rec.shipment_id); -- bug 8228519 passing shipment id for quote header
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2497: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2498: 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');
2499: 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');
2500: END IF;
2501: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2502: (l_qte_header_rec.quote_header_id, null);
2503: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2504: 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');

2500: END IF;
2501: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2502: (l_qte_header_rec.quote_header_id, null);
2503: IF aso_debug_pub.g_debug_flag ='Y' THEN
2504: 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');
2505: 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');
2506: END IF;
2507: IF l_site_use_id_ship_header is not null THEN
2508: l_site_use_id:=l_site_use_id_ship_header;

Line 2505: 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');

2501: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2502: (l_qte_header_rec.quote_header_id, null);
2503: IF aso_debug_pub.g_debug_flag ='Y' THEN
2504: 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');
2505: 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');
2506: END IF;
2507: IF l_site_use_id_ship_header is not null THEN
2508: l_site_use_id:=l_site_use_id_ship_header;
2509: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2510: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO c_get_acct_site ', 1, 'Y');

2506: END IF;
2507: IF l_site_use_id_ship_header is not null THEN
2508: l_site_use_id:=l_site_use_id_ship_header;
2509: IF aso_debug_pub.g_debug_flag ='Y' THEN
2510: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO c_get_acct_site ', 1, 'Y');
2511: END IF;
2512:
2513: Open c_get_acct_site(l_site_use_id);
2514: Fetch c_get_acct_site into l_acct_site_id_ship;

Line 2518: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');

2514: Fetch c_get_acct_site into l_acct_site_id_ship;
2515: Close c_get_acct_site;
2516:
2517: IF aso_debug_pub.g_debug_flag ='Y' THEN
2518: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2519: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_ship : '||l_acct_site_id_ship, 1, 'Y');
2520: END IF;
2521: ELSE
2522: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2519: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_ship : '||l_acct_site_id_ship, 1, 'Y');

2515: Close c_get_acct_site;
2516:
2517: IF aso_debug_pub.g_debug_flag ='Y' THEN
2518: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2519: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_ship : '||l_acct_site_id_ship, 1, 'Y');
2520: END IF;
2521: ELSE
2522: IF aso_debug_pub.g_debug_flag ='Y' THEN
2523: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');

Line 2523: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');

2519: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_ship : '||l_acct_site_id_ship, 1, 'Y');
2520: END IF;
2521: ELSE
2522: IF aso_debug_pub.g_debug_flag ='Y' THEN
2523: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2524: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2525: END IF;
2526: l_acct_site_id_ship:=NULL;
2527: END IF;

Line 2524: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');

2520: END IF;
2521: ELSE
2522: IF aso_debug_pub.g_debug_flag ='Y' THEN
2523: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2524: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2525: END IF;
2526: l_acct_site_id_ship:=NULL;
2527: END IF;
2528:

Line 2532: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO c_get_acct_site ', 1, 'Y');

2528:
2529: IF l_site_use_id_bill_header is not null THEN
2530: l_site_use_id:=l_site_use_id_bill_header;
2531: IF aso_debug_pub.g_debug_flag ='Y' THEN
2532: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO c_get_acct_site ', 1, 'Y');
2533: END IF;
2534:
2535: Open c_get_acct_site(l_site_use_id);
2536: Fetch c_get_acct_site into l_acct_site_id_bill;

Line 2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');

2536: Fetch c_get_acct_site into l_acct_site_id_bill;
2537: Close c_get_acct_site;
2538:
2539: IF aso_debug_pub.g_debug_flag ='Y' THEN
2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2541: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_bill : '||l_acct_site_id_bill, 1, 'Y');
2542: END IF;
2543: ELSE
2544: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2541: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_bill : '||l_acct_site_id_bill, 1, 'Y');

2537: Close c_get_acct_site;
2538:
2539: IF aso_debug_pub.g_debug_flag ='Y' THEN
2540: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO c_get_acct_site ', 1, 'Y');
2541: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_bill : '||l_acct_site_id_bill, 1, 'Y');
2542: END IF;
2543: ELSE
2544: IF aso_debug_pub.g_debug_flag ='Y' THEN
2545: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');

Line 2545: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');

2541: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_acct_site_id_bill : '||l_acct_site_id_bill, 1, 'Y');
2542: END IF;
2543: ELSE
2544: IF aso_debug_pub.g_debug_flag ='Y' THEN
2545: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2546: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2547: END IF;
2548: l_acct_site_id_bill:=NULL;
2549: END IF;

Line 2546: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');

2542: END IF;
2543: ELSE
2544: IF aso_debug_pub.g_debug_flag ='Y' THEN
2545: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_site_use_id is null ', 1, 'Y');
2546: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: So l_acct_site_id_ship is also null ', 1, 'Y');
2547: END IF;
2548: l_acct_site_id_bill:=NULL;
2549: END IF;
2550:

Line 2556: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id ', 1, 'Y');

2552: fetch c_invoice_source_id into l_batch_source;
2553: CLOSE c_invoice_source_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 CALL TO the c_invoice_source_id ', 1, 'Y');
2557: 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');
2558: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2559: 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');
2560: END IF;

Line 2557: 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');

2553: CLOSE c_invoice_source_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 CALL TO the c_invoice_source_id ', 1, 'Y');
2557: 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');
2558: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2559: 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');
2560: END IF;
2561:

Line 2558: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');

2554:
2555: IF aso_debug_pub.g_debug_flag ='Y' THEN
2556: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id ', 1, 'Y');
2557: 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');
2558: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2559: 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');
2560: END IF;
2561:
2562: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);

Line 2559: 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');

2555: IF aso_debug_pub.g_debug_flag ='Y' THEN
2556: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: After CALL TO the c_invoice_source_id ', 1, 'Y');
2557: 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');
2558: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2559: 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');
2560: END IF;
2561:
2562: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2563:

Line 2562: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);

2558: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the l_trx_type_id ', 1, 'Y');
2559: 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');
2560: END IF;
2561:
2562: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2563:
2564: IF aso_debug_pub.g_debug_flag ='Y' THEN
2565: 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');
2566: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');

Line 2565: 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');

2561:
2562: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2563:
2564: IF aso_debug_pub.g_debug_flag ='Y' THEN
2565: 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');
2566: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');
2567: 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');
2568: END IF;
2569:

Line 2566: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');

2562: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2563:
2564: IF aso_debug_pub.g_debug_flag ='Y' THEN
2565: 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');
2566: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');
2567: 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');
2568: END IF;
2569:
2570: Open c_cust_trx_type_id(l_trx_type_id);

Line 2567: 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');

2563:
2564: IF aso_debug_pub.g_debug_flag ='Y' THEN
2565: 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');
2566: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_trx_type_id : '||l_trx_type_id , 1, 'Y');
2567: 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');
2568: END IF;
2569:
2570: Open c_cust_trx_type_id(l_trx_type_id);
2571: fetch c_cust_trx_type_id into l_ra_cust_trx_type_id;

Line 2575: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');

2571: fetch c_cust_trx_type_id into l_ra_cust_trx_type_id;
2572: close c_cust_trx_type_id;
2573:
2574: IF aso_debug_pub.g_debug_flag ='Y' THEN
2575: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2576: 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');
2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2578: 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');
2579: 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');

Line 2576: 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');

2572: close c_cust_trx_type_id;
2573:
2574: IF aso_debug_pub.g_debug_flag ='Y' THEN
2575: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2576: 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');
2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2578: 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');
2579: 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');
2580: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID :'||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');

Line 2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');

2573:
2574: IF aso_debug_pub.g_debug_flag ='Y' THEN
2575: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2576: 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');
2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2578: 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');
2579: 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');
2580: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID :'||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID :'||l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID , 1, 'Y');

Line 2578: 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');

2574: IF aso_debug_pub.g_debug_flag ='Y' THEN
2575: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2576: 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');
2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2578: 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');
2579: 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');
2580: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID :'||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID :'||l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID , 1, 'Y');
2582: END IF;

Line 2579: 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');

2575: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: AFTER THE CALL TO c_cust_trx_type_id ' , 1, 'Y');
2576: 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');
2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2578: 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');
2579: 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');
2580: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID :'||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID :'||l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID , 1, 'Y');
2582: END IF;
2583:

Line 2580: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID :'||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');

2576: 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');
2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2578: 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');
2579: 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');
2580: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID :'||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID :'||l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID , 1, 'Y');
2582: END IF;
2583:
2584: /* Added for bug 9558210 */

Line 2581: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID :'||l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID , 1, 'Y');

2577: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE CALL TO the Legal Entity API ', 1, 'Y');
2578: 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');
2579: 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');
2580: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID :'||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');
2581: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID :'||l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID , 1, 'Y');
2582: END IF;
2583:
2584: /* Added for bug 9558210 */
2585:

Line 2590: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID Is Null ', 1, 'Y');

2586: If (l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID Is Null OR
2587: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID = FND_API.G_MISS_NUM) THEN
2588:
2589: IF aso_debug_pub.g_debug_flag ='Y' THEN
2590: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID Is Null ', 1, 'Y');
2591: End if;
2592:
2593: If (l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Null OR
2594: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID = FND_API.G_MISS_NUM) THEN

Line 2597: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Null ', 1, 'Y');

2593: If (l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Null OR
2594: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID = FND_API.G_MISS_NUM) THEN
2595:
2596: IF aso_debug_pub.g_debug_flag ='Y' THEN
2597: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Null ', 1, 'Y');
2598: End if;
2599:
2600: Open C_ACC(p_qte_header_id);
2601: Fetch C_ACC Into l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID;

Line 2605: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Not Null ', 1, 'Y');

2601: Fetch C_ACC Into l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID;
2602: Close C_ACC;
2603: Else
2604: IF aso_debug_pub.g_debug_flag ='Y' THEN
2605: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Not Null ', 1, 'Y');
2606: End if;
2607:
2608: Open C_SHIP(l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID);
2609: Fetch C_SHIP Into l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID;

Line 2614: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: 3 l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID: '||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');

2610: Close C_SHIP;
2611: End If;
2612:
2613: IF aso_debug_pub.g_debug_flag ='Y' THEN
2614: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: 3 l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID: '||l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID, 1, 'Y');
2615: End if;
2616:
2617: End If;
2618:

Line 2635: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');

2631: l_legal_entity_id:= x_legal_entity.legal_entity_id;
2632:
2633:
2634: IF aso_debug_pub.g_debug_flag ='Y' THEN
2635: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2636: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2637: --Added by anrajan on 05/10/2005
2638: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2639: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');

Line 2636: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');

2632:
2633:
2634: IF aso_debug_pub.g_debug_flag ='Y' THEN
2635: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2636: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2637: --Added by anrajan on 05/10/2005
2638: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2639: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');
2640: END IF;

Line 2638: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');

2634: IF aso_debug_pub.g_debug_flag ='Y' THEN
2635: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2636: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2637: --Added by anrajan on 05/10/2005
2638: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2639: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');
2640: END IF;
2641:
2642:

Line 2639: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');

2635: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO the Legal Entity API ', 1, 'Y');
2636: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: LEGAL ENTITY : '||l_legal_entity_id, 1, 'Y');
2637: --Added by anrajan on 05/10/2005
2638: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : RETURN_STATUS : '||x_return_status , 1, 'Y');
2639: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER LEGAL ENTITY API : MESSAGE DATA : '||X_Msg_Data , 1, 'Y');
2640: END IF;
2641:
2642:
2643: /* Added for Bug 9558210*/

Line 2647: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR ', 1, 'Y');

2643: /* Added for Bug 9558210*/
2644:
2645: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2646: IF aso_debug_pub.g_debug_flag ='Y' THEN
2647: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR ', 1, 'Y');
2648: End if;
2649: raise FND_API.G_EXC_ERROR;
2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2651: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2652: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_UNEXPECTED_ERROR ', 1, 'Y');

2648: End if;
2649: raise FND_API.G_EXC_ERROR;
2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2651: IF aso_debug_pub.g_debug_flag ='Y' THEN
2652: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_UNEXPECTED_ERROR ', 1, 'Y');
2653: End if;
2654: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2655: END IF;
2656:

Line 2659: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR for l_legal_entity_id = -1', 1, 'Y');

2655: END IF;
2656:
2657: If l_legal_entity_id = -1 Then
2658: IF aso_debug_pub.g_debug_flag ='Y' THEN
2659: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR for l_legal_entity_id = -1', 1, 'Y');
2660: End if;
2661: raise FND_API.G_EXC_ERROR;
2662: End If;
2663:

Line 2669: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');

2665:
2666: --Insertion into the Header Temporary Table.
2667:
2668: IF aso_debug_pub.g_debug_flag ='Y' THEN
2669: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');
2670: END IF;
2671:
2672: DELETE FROM ZX_TRX_HEADERS_GT where
2673: APPLICATION_ID=697 and

Line 2747: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE THE QUOTE LINES LOOP ', 1, 'Y');

2743: );
2744:
2745: print_tax_info(1,p_qte_header_id);
2746: IF aso_debug_pub.g_debug_flag ='Y' THEN
2747: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE THE QUOTE LINES LOOP ', 1, 'Y');
2748: END IF;
2749:
2750: DELETE FROM Zx_transaction_lines_gt
2751: WHERE APPLICATION_ID= 697

Line 2761: 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');

2757: FOR i in 1..l_qte_line_tbl.count
2758: LOOP
2759: l_qte_line_rec:=l_qte_line_tbl(i);
2760: IF aso_debug_pub.g_debug_flag ='Y' THEN
2761: 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');
2762: 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');
2763: END IF;
2764: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2765:

Line 2762: 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');

2758: LOOP
2759: l_qte_line_rec:=l_qte_line_tbl(i);
2760: IF aso_debug_pub.g_debug_flag ='Y' THEN
2761: 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');
2762: 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');
2763: END IF;
2764: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2765:
2766: --Condition added by anrajan on 06/10/2005 for Bug Number :4656728

Line 2773: 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');

2769: l_Shipment_Rec:=l_shipment_tbl(1);
2770: END IF;
2771:
2772: IF aso_debug_pub.g_debug_flag ='Y' THEN
2773: 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');
2774: END IF;
2775:
2776: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2777: (p_qte_header_id,

Line 2780: 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');

2776: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2777: (p_qte_header_id,
2778: l_qte_line_rec.quote_line_id);
2779: IF aso_debug_pub.g_debug_flag ='Y' THEN
2780: 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');
2781: 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');
2782: END IF;
2783:
2784: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id

Line 2781: 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');

2777: (p_qte_header_id,
2778: l_qte_line_rec.quote_line_id);
2779: IF aso_debug_pub.g_debug_flag ='Y' THEN
2780: 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');
2781: 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');
2782: END IF;
2783:
2784: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id
2785: (p_qte_header_id,

Line 2789: 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');

2785: (p_qte_header_id,
2786: l_qte_line_rec.quote_line_id,
2787: l_Shipment_Rec.SHIPMENT_ID);
2788: IF aso_debug_pub.g_debug_flag ='Y' THEN
2789: 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');
2790: 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');
2791: END IF;
2792:
2793: Open c_getlocinfo(l_site_use_id_bill_lines);

Line 2790: 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');

2786: l_qte_line_rec.quote_line_id,
2787: l_Shipment_Rec.SHIPMENT_ID);
2788: IF aso_debug_pub.g_debug_flag ='Y' THEN
2789: 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');
2790: 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');
2791: END IF;
2792:
2793: Open c_getlocinfo(l_site_use_id_bill_lines);
2794: Fetch c_getlocinfo into l_acct_site_id_bill_lines,l_bill_cust_acct_id_lines;

Line 2802: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');

2798: Fetch c_getlocinfo into l_acct_site_id_ship_lines,l_ship_cust_acct_id_lines;
2799: Close c_getlocinfo;
2800:
2801: IF aso_debug_pub.g_debug_flag ='Y' THEN
2802: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2803: 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');
2804: 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');
2805: 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');
2806: 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');

Line 2803: 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');

2799: Close c_getlocinfo;
2800:
2801: IF aso_debug_pub.g_debug_flag ='Y' THEN
2802: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2803: 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');
2804: 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');
2805: 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');
2806: 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');
2807: END IF;

Line 2804: 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');

2800:
2801: IF aso_debug_pub.g_debug_flag ='Y' THEN
2802: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2803: 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');
2804: 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');
2805: 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');
2806: 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');
2807: END IF;
2808:

Line 2805: 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');

2801: IF aso_debug_pub.g_debug_flag ='Y' THEN
2802: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2803: 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');
2804: 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');
2805: 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');
2806: 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');
2807: END IF;
2808:
2809: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2806: 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');

2802: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_getlocinfo', 1, 'Y');
2803: 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');
2804: 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');
2805: 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');
2806: 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');
2807: END IF;
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 :BEFORE THE CALL TO c_shiplocation', 1, 'Y');

Line 2810: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_shiplocation', 1, 'Y');

2806: 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');
2807: END IF;
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 :BEFORE THE CALL TO c_shiplocation', 1, 'Y');
2811: END IF;
2812:
2813: IF
2814: l_Shipment_Rec.ship_to_party_site_id is not null

Line 2824: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');

2820: FETCH c_shiplocation into l_ship_to_location;
2821: close c_shiplocation;
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_shiplocation', 1, 'Y');
2825: 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');
2826: END IF;
2827:
2828: IF

Line 2825: 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');

2821: close c_shiplocation;
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_shiplocation', 1, 'Y');
2825: 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');
2826: END IF;
2827:
2828: IF
2829: l_qte_line_rec.invoice_to_party_site_id is not null

Line 2840: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');

2836: FETCH c_shiplocation into l_bill_to_location;
2837: close c_shiplocation;
2838:
2839: IF aso_debug_pub.g_debug_flag ='Y' THEN
2840: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2841: 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');
2842: 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');
2843: END IF;
2844:

Line 2841: 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');

2837: close c_shiplocation;
2838:
2839: IF aso_debug_pub.g_debug_flag ='Y' THEN
2840: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2841: 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');
2842: 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');
2843: END IF;
2844:
2845: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);

Line 2842: 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');

2838:
2839: IF aso_debug_pub.g_debug_flag ='Y' THEN
2840: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO c_shiplocation', 1, 'Y');
2841: 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');
2842: 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');
2843: END IF;
2844:
2845: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2846: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2845: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);

2841: 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');
2842: 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');
2843: END IF;
2844:
2845: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2846: IF aso_debug_pub.g_debug_flag ='Y' THEN
2847: 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');
2848: 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');
2849: 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');

Line 2847: 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');

2843: END IF;
2844:
2845: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2846: IF aso_debug_pub.g_debug_flag ='Y' THEN
2847: 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');
2848: 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');
2849: 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');
2850: END IF;
2851:

Line 2848: 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');

2844:
2845: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2846: IF aso_debug_pub.g_debug_flag ='Y' THEN
2847: 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');
2848: 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');
2849: 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');
2850: END IF;
2851:
2852: Open c_product_type;

Line 2849: 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');

2845: l_trx_type_id := ASO_TAX_INT.get_ra_trx_type_id(l_qte_header_rec.order_type_id,l_qte_line_rec);
2846: IF aso_debug_pub.g_debug_flag ='Y' THEN
2847: 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');
2848: 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');
2849: 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');
2850: END IF;
2851:
2852: Open c_product_type;
2853: Fetch c_product_type into l_product_type;

Line 2857: 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');

2853: Fetch c_product_type into l_product_type;
2854: close c_product_type;
2855:
2856: IF aso_debug_pub.g_debug_flag ='Y' THEN
2857: 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');
2858: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_product_type: '||l_product_type, 1, 'Y');
2859: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_tax ', 1, 'Y');
2860: END IF;
2861:

Line 2858: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_product_type: '||l_product_type, 1, 'Y');

2854: close c_product_type;
2855:
2856: IF aso_debug_pub.g_debug_flag ='Y' THEN
2857: 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');
2858: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_product_type: '||l_product_type, 1, 'Y');
2859: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_tax ', 1, 'Y');
2860: END IF;
2861:
2862:

Line 2859: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_tax ', 1, 'Y');

2855:
2856: IF aso_debug_pub.g_debug_flag ='Y' THEN
2857: 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');
2858: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_product_type: '||l_product_type, 1, 'Y');
2859: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_tax ', 1, 'Y');
2860: END IF;
2861:
2862:
2863: Open c_tax;

Line 2868: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');

2864: fetch c_tax into l_hdr_tax_exempt_flag,l_hdr_tax_exempt_number,l_hdr_tax_exempt_reason_code;
2865: close c_tax;
2866:
2867: IF aso_debug_pub.g_debug_flag ='Y' THEN
2868: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2869: 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');
2870: 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');
2871: 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');
2872: 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');

Line 2869: 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');

2865: close c_tax;
2866:
2867: IF aso_debug_pub.g_debug_flag ='Y' THEN
2868: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2869: 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');
2870: 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');
2871: 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');
2872: 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');
2873: END IF;

Line 2870: 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');

2866:
2867: IF aso_debug_pub.g_debug_flag ='Y' THEN
2868: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2869: 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');
2870: 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');
2871: 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');
2872: 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');
2873: END IF;
2874:

Line 2871: 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');

2867: IF aso_debug_pub.g_debug_flag ='Y' THEN
2868: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2869: 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');
2870: 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');
2871: 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');
2872: 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');
2873: END IF;
2874:
2875:

Line 2872: 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');

2868: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_tax ' , 1, 'Y');
2869: 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');
2870: 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');
2871: 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');
2872: 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');
2873: END IF;
2874:
2875:
2876: Open c_cust_trx_type_id(l_trx_type_id);

Line 2881: 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');

2877: fetch c_cust_trx_type_id into l_ra_cust_trx_type_id;
2878: close c_cust_trx_type_id;
2879:
2880: IF aso_debug_pub.g_debug_flag ='Y' THEN
2881: 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');
2882: 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');
2883: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_Shipment_Rec.ship_from_org_id : '||l_Shipment_Rec.ship_from_org_id, 1, 'Y');
2884: -- 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');
2885: END IF;

Line 2882: 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');

2878: close c_cust_trx_type_id;
2879:
2880: IF aso_debug_pub.g_debug_flag ='Y' THEN
2881: 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');
2882: 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');
2883: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_Shipment_Rec.ship_from_org_id : '||l_Shipment_Rec.ship_from_org_id, 1, 'Y');
2884: -- 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');
2885: END IF;
2886:

Line 2883: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_Shipment_Rec.ship_from_org_id : '||l_Shipment_Rec.ship_from_org_id, 1, 'Y');

2879:
2880: IF aso_debug_pub.g_debug_flag ='Y' THEN
2881: 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');
2882: 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');
2883: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_Shipment_Rec.ship_from_org_id : '||l_Shipment_Rec.ship_from_org_id, 1, 'Y');
2884: -- 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');
2885: END IF;
2886:
2887: If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 14340122

Line 2884: -- 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');

2880: IF aso_debug_pub.g_debug_flag ='Y' THEN
2881: 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');
2882: 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');
2883: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_Shipment_Rec.ship_from_org_id : '||l_Shipment_Rec.ship_from_org_id, 1, 'Y');
2884: -- 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');
2885: END IF;
2886:
2887: If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 14340122
2888:

Line 2890: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id Is Not Null ', 1, 'Y');

2886:
2887: If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 14340122
2888:
2889: IF aso_debug_pub.g_debug_flag ='Y' THEN
2890: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id Is Not Null ', 1, 'Y');
2891: 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');
2892: END IF;
2893:
2894: OPEN c_LOCATION_ID;

Line 2891: 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');

2887: If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 14340122
2888:
2889: IF aso_debug_pub.g_debug_flag ='Y' THEN
2890: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id Is Not Null ', 1, 'Y');
2891: 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');
2892: END IF;
2893:
2894: OPEN c_LOCATION_ID;
2895: Fetch c_LOCATION_ID into l_SHIP_FROM_LOCATION_ID;

Line 2899: 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');

2895: Fetch c_LOCATION_ID into l_SHIP_FROM_LOCATION_ID;
2896: close c_LOCATION_ID;
2897:
2898: IF aso_debug_pub.g_debug_flag ='Y' THEN
2899: 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');
2900: 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');
2901: --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');
2902: END IF;
2903:

Line 2900: 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');

2896: close c_LOCATION_ID;
2897:
2898: IF aso_debug_pub.g_debug_flag ='Y' THEN
2899: 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');
2900: 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');
2901: --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');
2902: END IF;
2903:
2904:

Line 2901: --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');

2897:
2898: IF aso_debug_pub.g_debug_flag ='Y' THEN
2899: 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');
2900: 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');
2901: --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');
2902: END IF;
2903:
2904:
2905: -- new code added by suyog bug 5061912

Line 2913: 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');

2909: FETCH c_get_resource_id into l_resource_id;
2910: CLOSE c_get_resource_id;
2911:
2912: IF aso_debug_pub.g_debug_flag ='Y' THEN
2913: 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');
2914: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_resource_id: '|| l_resource_id , 1, 'Y');
2915: END IF;
2916:
2917: -- get the org id based upon the resource id and the trxn date

Line 2914: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_resource_id: '|| l_resource_id , 1, 'Y');

2910: CLOSE c_get_resource_id;
2911:
2912: IF aso_debug_pub.g_debug_flag ='Y' THEN
2913: 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');
2914: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_resource_id: '|| l_resource_id , 1, 'Y');
2915: END IF;
2916:
2917: -- get the org id based upon the resource id and the trxn date
2918: OPEN c_get_org_id(l_resource_id);

Line 2923: 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');

2919: FETCH c_get_org_id into l_poo_party_id;
2920: CLOSE c_get_org_id;
2921:
2922: IF aso_debug_pub.g_debug_flag ='Y' THEN
2923: 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');
2924: 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');
2925: END IF;
2926:
2927: -- get the location based upon the org id

Line 2924: 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');

2920: CLOSE c_get_org_id;
2921:
2922: IF aso_debug_pub.g_debug_flag ='Y' THEN
2923: 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');
2924: 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');
2925: END IF;
2926:
2927: -- get the location based upon the org id
2928: OPEN c_get_location_id(l_poo_party_id);

Line 2933: 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');

2929: FETCH c_get_location_id into l_poo_location_id;
2930: CLOSE c_get_location_id;
2931:
2932: IF aso_debug_pub.g_debug_flag ='Y' THEN
2933: 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');
2934: 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');
2935: END IF;
2936:
2937: -- POA PARTY ID is same as the internal_organization_id

Line 2934: 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');

2930: CLOSE c_get_location_id;
2931:
2932: IF aso_debug_pub.g_debug_flag ='Y' THEN
2933: 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');
2934: 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');
2935: END IF;
2936:
2937: -- POA PARTY ID is same as the internal_organization_id
2938: -- POA LOCATION ID is same as the l_int_org_location

Line 2941: 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');

2937: -- POA PARTY ID is same as the internal_organization_id
2938: -- POA LOCATION ID is same as the l_int_org_location
2939:
2940: IF aso_debug_pub.g_debug_flag ='Y' THEN
2941: 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');
2942: 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');
2943: 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');
2944: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.LINE_QUOTE_PRICE '|| l_qte_line_rec.LINE_QUOTE_PRICE , 1, 'Y');
2945: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.QUANTITY '||l_qte_line_rec.QUANTITY, 1, 'Y');

Line 2942: 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');

2938: -- POA LOCATION ID is same as the l_int_org_location
2939:
2940: IF aso_debug_pub.g_debug_flag ='Y' THEN
2941: 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');
2942: 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');
2943: 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');
2944: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.LINE_QUOTE_PRICE '|| l_qte_line_rec.LINE_QUOTE_PRICE , 1, 'Y');
2945: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.QUANTITY '||l_qte_line_rec.QUANTITY, 1, 'Y');
2946: END IF;

Line 2943: 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');

2939:
2940: IF aso_debug_pub.g_debug_flag ='Y' THEN
2941: 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');
2942: 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');
2943: 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');
2944: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.LINE_QUOTE_PRICE '|| l_qte_line_rec.LINE_QUOTE_PRICE , 1, 'Y');
2945: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.QUANTITY '||l_qte_line_rec.QUANTITY, 1, 'Y');
2946: END IF;
2947:

Line 2944: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.LINE_QUOTE_PRICE '|| l_qte_line_rec.LINE_QUOTE_PRICE , 1, 'Y');

2940: IF aso_debug_pub.g_debug_flag ='Y' THEN
2941: 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');
2942: 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');
2943: 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');
2944: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.LINE_QUOTE_PRICE '|| l_qte_line_rec.LINE_QUOTE_PRICE , 1, 'Y');
2945: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.QUANTITY '||l_qte_line_rec.QUANTITY, 1, 'Y');
2946: END IF;
2947:
2948: -- end of new code added by suyog

Line 2945: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.QUANTITY '||l_qte_line_rec.QUANTITY, 1, 'Y');

2941: 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');
2942: 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');
2943: 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');
2944: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.LINE_QUOTE_PRICE '|| l_qte_line_rec.LINE_QUOTE_PRICE , 1, 'Y');
2945: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.QUANTITY '||l_qte_line_rec.QUANTITY, 1, 'Y');
2946: END IF;
2947:
2948: -- end of new code added by suyog
2949:

Line 3083: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id Is Null ', 1, 'Y');

3079: );
3080:
3081: Else
3082: If aso_debug_pub.g_debug_flag ='Y' Then
3083: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id Is Null ', 1, 'Y');
3084: End If;
3085: End If; -- code change done for Bug 14340122
3086:
3087: END LOOP;

Line 3090: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');

3086:
3087: END LOOP;
3088: print_tax_info(2,p_qte_header_id);
3089: IF aso_debug_pub.g_debug_flag ='Y' THEN
3090: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
3091: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
3092: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');

Line 3091: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');

3087: END LOOP;
3088: print_tax_info(2,p_qte_header_id);
3089: IF aso_debug_pub.g_debug_flag ='Y' THEN
3090: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
3091: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
3092: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
3095: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');

Line 3092: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');

3088: print_tax_info(2,p_qte_header_id);
3089: IF aso_debug_pub.g_debug_flag ='Y' THEN
3090: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
3091: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
3092: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
3095: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
3096: l_tax_start_time := dbms_utility.get_time;

Line 3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');

3089: IF aso_debug_pub.g_debug_flag ='Y' THEN
3090: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
3091: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
3092: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
3095: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
3096: l_tax_start_time := dbms_utility.get_time;
3097: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');

Line 3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');

3090: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE QUOTE LINES LOOP ', 1, 'Y');
3091: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
3092: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
3095: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
3096: l_tax_start_time := dbms_utility.get_time;
3097: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');
3098: END IF;

Line 3095: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');

3091: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE CALL TO TAX ENGINE ', 1, 'Y');
3092: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: p_api_version_number : '||p_api_version_number , 1, 'Y');
3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
3095: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
3096: l_tax_start_time := dbms_utility.get_time;
3097: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');
3098: END IF;
3099:

Line 3097: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');

3093: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_init_msg_list : '||l_init_msg_list , 1, 'Y');
3094: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_commit : '||l_commit , 1, 'Y');
3095: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: l_validation_level : '||l_validation_level , 1, 'Y');
3096: l_tax_start_time := dbms_utility.get_time;
3097: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: CALLED TAX ENGINE AT : '|| l_tax_start_time, 1, 'Y');
3098: END IF;
3099:
3100: --Changes done by anrajan on 20/09/05
3101: l_msg_cnt1:= FND_MSG_PUB.Count_Msg;

Line 3103: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: Message Count Before Tax call : '|| l_msg_cnt1, 1, 'Y');

3099:
3100: --Changes done by anrajan on 20/09/05
3101: l_msg_cnt1:= FND_MSG_PUB.Count_Msg;
3102: IF aso_debug_pub.g_debug_flag ='Y' THEN
3103: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: Message Count Before Tax call : '|| l_msg_cnt1, 1, 'Y');
3104: END IF;
3105:
3106: ZX_API_PUB.calculate_tax(p_api_version => p_api_version_number,
3107: p_init_msg_list => l_init_msg_list,

Line 3117: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: Message Count After Tax call : '|| l_msg_cnt2, 1, 'Y');

3113:
3114: --Changes done by anrajan on 20/09/05
3115: l_msg_cnt2:=FND_MSG_PUB.Count_Msg;
3116: IF aso_debug_pub.g_debug_flag ='Y' THEN
3117: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: Message Count After Tax call : '|| l_msg_cnt2, 1, 'Y');
3118: END IF;
3119:
3120: IF aso_debug_pub.g_debug_flag ='Y' THEN
3121: l_tax_end_time := dbms_utility.get_time;

Line 3122: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');

3118: END IF;
3119:
3120: IF aso_debug_pub.g_debug_flag ='Y' THEN
3121: l_tax_end_time := dbms_utility.get_time;
3122: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3123: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3124: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3125: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3126: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');

Line 3123: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');

3119:
3120: IF aso_debug_pub.g_debug_flag ='Y' THEN
3121: l_tax_end_time := dbms_utility.get_time;
3122: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3123: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3124: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3125: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3126: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');
3127: END IF;

Line 3125: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');

3121: l_tax_end_time := dbms_utility.get_time;
3122: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3123: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3124: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3125: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3126: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');
3127: END IF;
3128:
3129: print_tax_info(3,p_qte_header_id);

Line 3126: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');

3122: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE ', 1, 'Y');
3123: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER CALL TO TAX ENGINE : X_RETURN_STATUS : '||x_return_status , 1, 'Y');
3124: l_tax_total_time := (l_tax_end_time - l_tax_start_time)/100;
3125: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TAX CALL ENDED AT : '|| l_tax_end_time, 1, 'Y');
3126: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: TIME TAKEN BY TAX ENGINE IN SECONDS: '|| l_tax_total_time, 1, 'Y');
3127: END IF;
3128:
3129: print_tax_info(3,p_qte_header_id);
3130:

Line 3135: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');

3131: IF x_return_status='S' THEN
3132:
3133: if p_qte_line_id is not null THEN
3134: IF aso_debug_pub.g_debug_flag ='Y' THEN
3135: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3136: 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');
3137: END IF;
3138: Delete from
3139: ASO_TAX_DETAILS

Line 3136: 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');

3132:
3133: if p_qte_line_id is not null THEN
3134: IF aso_debug_pub.g_debug_flag ='Y' THEN
3135: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3136: 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');
3137: END IF;
3138: Delete from
3139: ASO_TAX_DETAILS
3140: where

Line 3146: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');

3142: and
3143: QUOTE_LINE_ID=p_qte_line_id;
3144: ELSE
3145: IF aso_debug_pub.g_debug_flag ='Y' THEN
3146: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3147: 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');
3148: END IF;
3149: Delete from ASO_TAX_DETAILS
3150: where QUOTE_HEADER_ID=p_qte_header_id

Line 3147: 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');

3143: QUOTE_LINE_ID=p_qte_line_id;
3144: ELSE
3145: IF aso_debug_pub.g_debug_flag ='Y' THEN
3146: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3147: 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');
3148: END IF;
3149: Delete from ASO_TAX_DETAILS
3150: where QUOTE_HEADER_ID=p_qte_header_id
3151: and QUOTE_LINE_ID is not null;

Line 3199: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :Number of rows inserted : '||sql%rowcount, 1, 'Y');

3195: ;
3196:
3197: --Changed by Anoop on 14 Sep 2005.
3198: IF aso_debug_pub.g_debug_flag ='Y' THEN
3199: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :Number of rows inserted : '||sql%rowcount, 1, 'Y');
3200: END IF;
3201:
3202: ELSE
3203: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 3204: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN NOT SUCCESSFUL ', 1, 'Y');

3200: END IF;
3201:
3202: ELSE
3203: IF aso_debug_pub.g_debug_flag ='Y' THEN
3204: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN NOT SUCCESSFUL ', 1, 'Y');
3205: END IF;
3206: --Changes done by anrajan on 20/09/05
3207: for i in 1..(l_msg_cnt2-l_msg_cnt1)
3208: loop

Line 3214: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :X_Msg_Data : '||X_Msg_Data, 1, 'Y');

3210: FND_MSG_PUB.GET(p_msg_index => l_msg_cnt1+1,
3211: p_data =>X_Msg_Data,
3212: p_encoded =>'F',
3213: p_msg_index_out =>X_Msg_Count);
3214: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :X_Msg_Data : '||X_Msg_Data, 1, 'Y');
3215: END IF;
3216: FND_MSG_PUB.Delete_Msg(l_msg_cnt1+1);
3217: END LOOP;
3218: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3490: aso_debug_pub.add(' ASO_TAX_INT :p_order_type_id'||p_order_type_id , 1, 'N');

3486: l_order_type_id NUMBER := p_order_type_id;
3487: BEGIN
3488:
3489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3490: aso_debug_pub.add(' ASO_TAX_INT :p_order_type_id'||p_order_type_id , 1, 'N');
3491: END IF;
3492:
3493: IF p_order_type_id is NULL OR p_order_type_id = FND_API.G_MISS_NUM THEN
3494:

Line 3506: aso_debug_pub.add(' ASO_TAX_INT Porder_type id is null:l_order_type_id'||l_order_type_id , 1, 'N');

3502:
3503: -- Change END
3504:
3505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3506: aso_debug_pub.add(' ASO_TAX_INT Porder_type id is null:l_order_type_id'||l_order_type_id , 1, 'N');
3507: END IF;
3508:
3509: END IF;
3510: OPEN C_OE_trns(l_order_type_id);

Line 3515: 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');

3511: FETCH C_OE_trns INTO l_in_line_type, l_out_line_type, l_cust_trx_type_id;
3512:
3513: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3514:
3515: 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');
3516: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_out_line_type'||l_out_line_type , 1, 'N');
3517: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_cust_trx_type_id'||l_cust_trx_type_id , 1, 'N');
3518:
3519: END IF;

Line 3516: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_out_line_type'||l_out_line_type , 1, 'N');

3512:
3513: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3514:
3515: 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');
3516: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_out_line_type'||l_out_line_type , 1, 'N');
3517: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_cust_trx_type_id'||l_cust_trx_type_id , 1, 'N');
3518:
3519: END IF;
3520:

Line 3517: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_cust_trx_type_id'||l_cust_trx_type_id , 1, 'N');

3513: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3514:
3515: 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');
3516: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_out_line_type'||l_out_line_type , 1, 'N');
3517: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:l_cust_trx_type_id'||l_cust_trx_type_id , 1, 'N');
3518:
3519: END IF;
3520:
3521:

Line 3526: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:NOT FOUND' , 1, 'N');

3522: IF C_OE_trns%NOTFOUND THEN
3523: NULL;
3524:
3525: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3526: aso_debug_pub.add(' ASO_TAX_INT C_OE_trns:NOT FOUND' , 1, 'N');
3527: END IF;
3528:
3529: END IF;
3530: CLOSE C_OE_trns;

Line 3534: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.order_line_type_id is NULL' , 1, 'N');

3530: CLOSE C_OE_trns;
3531: 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
3532:
3533: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3534: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.order_line_type_id is NULL' , 1, 'N');
3535: END IF;
3536:
3537: IF p_qte_line_rec.line_category_code = 'ORDER' THEN
3538: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3539: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.line_category_code '|| p_qte_line_rec.line_category_code , 1, 'N');

3535: END IF;
3536:
3537: IF p_qte_line_rec.line_category_code = 'ORDER' THEN
3538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3539: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.line_category_code '|| p_qte_line_rec.line_category_code , 1, 'N');
3540: END IF;
3541: l_line_type_id := l_out_line_type;
3542:
3543: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3544: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.l_out_line_typ '|| l_out_line_type , 1, 'N');

3540: END IF;
3541: l_line_type_id := l_out_line_type;
3542:
3543: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3544: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.l_out_line_typ '|| l_out_line_type , 1, 'N');
3545: END IF;
3546:
3547: ELSE
3548: l_line_type_id := l_in_line_type;

Line 3550: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.li_n_line_typ '|| l_in_line_type , 1, 'N');

3546:
3547: ELSE
3548: l_line_type_id := l_in_line_type;
3549: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3550: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.li_n_line_typ '|| l_in_line_type , 1, 'N');
3551: END IF;
3552:
3553: END IF;
3554: ELSE

Line 3559: aso_debug_pub.add(' ASO_TAX_INT l_line_type_id '|| l_line_type_id , 1, 'N');

3555: l_line_type_id := p_qte_line_rec.order_line_type_id ;
3556: END IF;
3557:
3558: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3559: aso_debug_pub.add(' ASO_TAX_INT l_line_type_id '|| l_line_type_id , 1, 'N');
3560: END IF;
3561:
3562: IF p_qte_line_rec.line_category_code <> 'RETURN' THEN -- Standard Order Line
3563:

Line 3565: aso_debug_pub.add(' ASO_TAX_INT Line Category return ' , 1, 'N');

3561:
3562: IF p_qte_line_rec.line_category_code <> 'RETURN' THEN -- Standard Order Line
3563:
3564: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3565: aso_debug_pub.add(' ASO_TAX_INT Line Category return ' , 1, 'N');
3566: END IF;
3567:
3568: SELECT NVL(lt.cust_trx_type_id, 0)
3569: INTO l_cust_trx_type_id

Line 3574: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id Category return '||l_cust_trx_type_id , 1, 'N');

3570: FROM oe_line_types_v lt
3571: WHERE lt.line_type_id = l_line_type_id;
3572:
3573: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3574: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id Category return '||l_cust_trx_type_id , 1, 'N');
3575: END IF;
3576:
3577: IF l_cust_trx_type_id = 0 THEN
3578:

Line 3580: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0before '||l_cust_trx_type_id , 1, 'N');

3576:
3577: IF l_cust_trx_type_id = 0 THEN
3578:
3579: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3580: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0before '||l_cust_trx_type_id , 1, 'N');
3581: END IF;
3582:
3583: SELECT NVL(ot.cust_trx_type_id, 0)
3584: INTO l_cust_trx_type_id

Line 3589: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0after '||l_cust_trx_type_id , 1, 'N');

3585: FROM oe_order_types_v ot
3586: WHERE ot.order_type_id =l_order_type_id;
3587:
3588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3589: aso_debug_pub.add(' ASO_TAX_INT l_cust_trx_type_id =0after '||l_cust_trx_type_id , 1, 'N');
3590: END IF;
3591:
3592: IF l_cust_trx_type_id = 0 THEN
3593:

Line 3595: aso_debug_pub.add(' ASO_TAX_INT default from oe_invoice_trans profile ' , 1, 'N');

3591:
3592: IF l_cust_trx_type_id = 0 THEN
3593:
3594: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3595: aso_debug_pub.add(' ASO_TAX_INT default from oe_invoice_trans profile ' , 1, 'N');
3596: END IF;
3597: /* This profile is obsoleted
3598: SELECT NVL(FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID'), 0)
3599: INTO l_cust_trx_type_id

Line 3612: aso_debug_pub.add(' ASO_TAX_INT Non Referenced Return Line ' , 1, 'N');

3608: RETURN(l_cust_trx_type_id);
3609: ELSE -- Non Referenced Return Line
3610:
3611: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3612: aso_debug_pub.add(' ASO_TAX_INT Non Referenced Return Line ' , 1, 'N');
3613: END IF;
3614:
3615: SELECT NVL(lt.cust_trx_type_id, 0)
3616: INTO l_inv_cust_trx_type_id

Line 3622: 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');

3618: WHERE lt.line_type_id = l_line_type_id;
3619:
3620:
3621: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3622: 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');
3623: END IF;
3624:
3625: IF l_inv_cust_trx_type_id = 0 THEN
3626: SELECT NVL(DECODE(ot.order_category_code, 'RETURN',ot.cust_trx_type_id, 0), 0)

Line 3634: aso_debug_pub.add(' ASO_TAX_INT Non Referenced Return Line credit memo ' , 1, 'N');

3630: END IF;
3631: IF l_inv_cust_trx_type_id <> 0 THEN
3632:
3633: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3634: aso_debug_pub.add(' ASO_TAX_INT Non Referenced Return Line credit memo ' , 1, 'N');
3635: END IF;
3636:
3637: SELECT nvl(ctt.credit_memo_type_id, 0)
3638: INTO l_cust_trx_type_id

Line 3663: aso_debug_pub.add(' ASO_TAX_INT GET_RA_TRX In WHEN others ' , 1, 'N');

3659: EXCEPTION
3660: WHEN OTHERS THEN
3661:
3662: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3663: aso_debug_pub.add(' ASO_TAX_INT GET_RA_TRX In WHEN others ' , 1, 'N');
3664: END IF;
3665:
3666: return(0);
3667: END GET_ra_trx_type_ID;

Line 4035: End ASO_TAX_INT;

4031: END IF;
4032:
4033: END print_tax_info;
4034:
4035: End ASO_TAX_INT;