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 2473: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');

2469: END IF;
2470:
2471:
2472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2473: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2474: END IF;
2475: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2475: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id

2471:
2472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2473: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2474: END IF;
2475: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2479: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_ship_header : '||l_site_use_id_ship_header, 1,'Y');

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

2474: END IF;
2475: l_site_use_id_ship_header := aso_shipment_pvt.get_ship_to_site_id
2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2479: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_ship_header : '||l_site_use_id_ship_header, 1,'Y');
2480: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id

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

2476: (l_qte_header_rec.quote_header_id,null,null);
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2479: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_ship_header : '||l_site_use_id_ship_header, 1,'Y');
2480: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2483: (l_qte_header_rec.quote_header_id, null);
2484: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id

2478: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2479: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_ship_header : '||l_site_use_id_ship_header, 1,'Y');
2480: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Before call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2483: (l_qte_header_rec.quote_header_id, null);
2484: IF aso_debug_pub.g_debug_flag ='Y' THEN
2485: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2486: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_bill_header : '||l_site_use_id_bill_header, 1,'Y');

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

2481: END IF;
2482: l_site_use_id_bill_header := aso_shipment_pvt.get_cust_to_party_site_id
2483: (l_qte_header_rec.quote_header_id, null);
2484: IF aso_debug_pub.g_debug_flag ='Y' THEN
2485: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2486: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_site_use_id_bill_header : '||l_site_use_id_bill_header, 1,'Y');
2487: END IF;
2488: IF l_site_use_id_ship_header is not null THEN
2489: l_site_use_id:=l_site_use_id_ship_header;

Line 2694: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id

2690: IF aso_debug_pub.g_debug_flag ='Y' THEN
2691: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');
2692: END IF;
2693:
2694: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2695: (p_qte_header_id,
2696: l_qte_line_rec.quote_line_id);
2697: IF aso_debug_pub.g_debug_flag ='Y' THEN
2698: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');

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

2694: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2695: (p_qte_header_id,
2696: l_qte_line_rec.quote_line_id);
2697: IF aso_debug_pub.g_debug_flag ='Y' THEN
2698: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2699: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_site_use_id_bill_lines : '||l_site_use_id_bill_lines , 1, 'Y');
2700: END IF;
2701:
2702: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id

Line 2702: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id

2698: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_cust_to_party_site_id', 1, 'Y');
2699: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_site_use_id_bill_lines : '||l_site_use_id_bill_lines , 1, 'Y');
2700: END IF;
2701:
2702: l_site_use_id_ship_lines:= aso_shipment_pvt.get_ship_to_site_id
2703: (p_qte_header_id,
2704: l_qte_line_rec.quote_line_id,
2705: l_Shipment_Rec.SHIPMENT_ID);
2706: IF aso_debug_pub.g_debug_flag ='Y' THEN

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

2703: (p_qte_header_id,
2704: l_qte_line_rec.quote_line_id,
2705: l_Shipment_Rec.SHIPMENT_ID);
2706: IF aso_debug_pub.g_debug_flag ='Y' THEN
2707: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_shipment_pvt.get_ship_to_site_id', 1, 'Y');
2708: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :l_site_use_id_ship_lines '||l_site_use_id_ship_lines , 1, 'Y');
2709: END IF;
2710:
2711: Open c_getlocinfo(l_site_use_id_bill_lines);