DBA Data[Home] [Help]

APPS.ASO_TAX_INT dependencies on ASO_SHIPMENT_PVT

Line 943: l_ship_from_org_id := ASO_SHIPMENT_PVT.get_ship_from_org_id(p_qte_header_id,

939: l_shipment_rec := l_shipment_tbl(1);
940: l_qte_line_rec := l_qte_line_tbl(i);
941:
942: -- Get ship_from_org_id
943: l_ship_from_org_id := ASO_SHIPMENT_PVT.get_ship_from_org_id(p_qte_header_id,
944: l_qte_line_tbl(i).quote_line_id);
945:
946: IF aso_debug_pub.g_debug_flag = 'Y' THEN
947: aso_debug_pub.add('ASO_TAX_LINE: After call to Get_ship_from_org_id: l_ship_from_org_id: '||l_ship_from_org_id, 1, 'Y');

Line 986: aso_debug_pub.add('ASO_TAX_LINE: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');

982:
983:
984: --Get site use information
985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
986: aso_debug_pub.add('ASO_TAX_LINE: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
987: END IF;
988:
989: l_site_use_id_ship := aso_shipment_pvt.get_ship_to_site_id( l_shipment_rec.quote_header_id,
990: l_shipment_rec.quote_line_id,

Line 989: l_site_use_id_ship := aso_shipment_pvt.get_ship_to_site_id( l_shipment_rec.quote_header_id,

985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
986: aso_debug_pub.add('ASO_TAX_LINE: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
987: END IF;
988:
989: l_site_use_id_ship := aso_shipment_pvt.get_ship_to_site_id( l_shipment_rec.quote_header_id,
990: l_shipment_rec.quote_line_id,
991: l_shipment_rec.shipment_id );
992:
993: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 995: aso_debug_pub.add('Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');

991: l_shipment_rec.shipment_id );
992:
993: IF aso_debug_pub.g_debug_flag = 'Y' THEN
994: aso_debug_pub.add('After call: l_site_use_id_ship: ' || l_site_use_id_ship, 1, 'Y');
995: aso_debug_pub.add('Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
996: END IF;
997:
998: l_site_use_id_bill := aso_shipment_pvt.get_cust_to_party_site_id
999: ( l_qte_line_tbl(i).quote_header_id,

Line 998: l_site_use_id_bill := aso_shipment_pvt.get_cust_to_party_site_id

994: aso_debug_pub.add('After call: l_site_use_id_ship: ' || l_site_use_id_ship, 1, 'Y');
995: aso_debug_pub.add('Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
996: END IF;
997:
998: l_site_use_id_bill := aso_shipment_pvt.get_cust_to_party_site_id
999: ( l_qte_line_tbl(i).quote_header_id,
1000: l_qte_line_tbl(i).quote_line_id );
1001:
1002: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1353: aso_debug_pub.add('ASO_TAX_LINE: Before call to ASO_SHIPMENT_PVT.Get_ship_to_party_site_id', 1, 'Y');

1349: (l_site_use_id_bill is null OR l_site_use_id_bill = FND_API.G_MISS_NUM) THEN
1350:
1351: -- Ship to party_site information
1352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1353: aso_debug_pub.add('ASO_TAX_LINE: Before call to ASO_SHIPMENT_PVT.Get_ship_to_party_site_id', 1, 'Y');
1354: END IF;
1355:
1356: l_party_site_id_ship := ASO_SHIPMENT_PVT.Get_ship_to_party_site_id(l_shipment_rec.quote_header_id, l_shipment_rec.quote_line_id, l_shipment_rec.shipment_id);
1357:

Line 1356: l_party_site_id_ship := ASO_SHIPMENT_PVT.Get_ship_to_party_site_id(l_shipment_rec.quote_header_id, l_shipment_rec.quote_line_id, l_shipment_rec.shipment_id);

1352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1353: aso_debug_pub.add('ASO_TAX_LINE: Before call to ASO_SHIPMENT_PVT.Get_ship_to_party_site_id', 1, 'Y');
1354: END IF;
1355:
1356: l_party_site_id_ship := ASO_SHIPMENT_PVT.Get_ship_to_party_site_id(l_shipment_rec.quote_header_id, l_shipment_rec.quote_line_id, l_shipment_rec.shipment_id);
1357:
1358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1359: aso_debug_pub.add('ASO_TAX_LINE: After call to Get_ship_to_party_site_id: l_party_site_id_ship: '|| l_party_site_id_ship, 1, 'Y');
1360: END IF;

Line 1392: aso_debug_pub.add('ASO_TAX_LINE: Before call to ASO_SHIPMENT_PVT.Get_invoice_to_party_site_id', 1,'Y');

1388: END IF; --l_party_site_id_ship
1389:
1390: -- Bill to party_site information
1391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1392: aso_debug_pub.add('ASO_TAX_LINE: Before call to ASO_SHIPMENT_PVT.Get_invoice_to_party_site_id', 1,'Y');
1393: END IF;
1394:
1395: l_party_site_id_bill := ASO_SHIPMENT_PVT.Get_invoice_to_party_site_id( l_shipment_rec.quote_header_id, l_shipment_rec.quote_line_id);
1396:

Line 1395: l_party_site_id_bill := ASO_SHIPMENT_PVT.Get_invoice_to_party_site_id( l_shipment_rec.quote_header_id, l_shipment_rec.quote_line_id);

1391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1392: aso_debug_pub.add('ASO_TAX_LINE: Before call to ASO_SHIPMENT_PVT.Get_invoice_to_party_site_id', 1,'Y');
1393: END IF;
1394:
1395: l_party_site_id_bill := ASO_SHIPMENT_PVT.Get_invoice_to_party_site_id( l_shipment_rec.quote_header_id, l_shipment_rec.quote_line_id);
1396:
1397: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1398: aso_debug_pub.add('ASO_TAX_LINE: After call to Get_invoice_to_party_site_id: l_party_site_id_bill: '|| l_party_site_id_bill,1,'Y');
1399: END IF;

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 2494: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id

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

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 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 2501: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id

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

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 2776: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id

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

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 2784: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id

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,
2786: l_qte_line_rec.quote_line_id,
2787: l_Shipment_Rec.SHIPMENT_ID);
2788: IF aso_debug_pub.g_debug_flag ='Y' THEN

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