DBA Data[Home] [Help]

APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on ASO_CHECK_TCA_PVT

Line 467: ASO_CHECK_TCA_PVT.Customer_Account(

463: AND p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
464: IF aso_debug_pub.g_debug_flag = 'Y' THEN
465: aso_debug_pub.add('deriving cust account id:p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
466: END IF;
467: ASO_CHECK_TCA_PVT.Customer_Account(
468: p_api_version => 1.0,
469: p_Party_Id => p_qte_rec.party_id,
470: p_calling_api_flag => 0,
471: x_Cust_Acct_Id => l_cust_account_id,

Line 532: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

528: IF aso_debug_pub.g_debug_flag = 'Y' THEN
529: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id, 1, 'N');
530: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_qte_rec.invoice_to_cust_account_id, 1, 'N');
531: END IF;
532: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
533: p_api_version => 1.0,
534: p_sold_to_cust_account => l_cust_account_id,
535: p_related_cust_account =>p_qte_rec.invoice_to_cust_account_id,
536: p_relationship_type => 'BILL_TO',

Line 641: ASO_CHECK_TCA_PVT.Customer_Account_Site

637: END IF;
638: IF p_qte_rec.invoice_to_party_site_id is not NULL
639: AND p_qte_rec.invoice_to_party_site_id <> FND_API.G_MISS_NUM THEN
640:
641: ASO_CHECK_TCA_PVT.Customer_Account_Site
642: (
643: p_api_version => 1.0
644: ,p_party_site_id => p_qte_rec.invoice_to_party_site_id
645: ,p_acct_site_type => 'BILL_TO'

Line 678: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

674: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
675: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_invoice_cust_acccount = ' ||l_invoice_cust_account_id ,1,'Y');
676: END IF;
677:
678: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
679: p_api_version => 1.0,
680: p_party_site_id => p_qte_rec.invoice_to_party_site_id,
681: p_role_type => 'BILL_TO',
682: p_cust_account_id => l_invoice_cust_account_id,

Line 720: ASO_CHECK_TCA_PVT.Customer_Account_Site

716: END IF;
717: IF p_qte_rec.End_Customer_party_site_id is not NULL
718: AND p_qte_rec.End_Customer_party_site_id <> FND_API.G_MISS_NUM THEN
719:
720: ASO_CHECK_TCA_PVT.Customer_Account_Site
721: (
722: p_api_version => 1.0
723: ,p_party_site_id => p_qte_rec.End_Customer_party_site_id
724: ,p_acct_site_type => 'END_USER'

Line 759: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

755: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
756: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_End_cust_acccount = ' ||l_End_cust_account_id ,1,'Y');
757: END IF;
758:
759: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
760: p_api_version => 1.0,
761: p_party_site_id => p_qte_rec.End_Customer_party_site_id,
762: p_role_type => 'END_USER',
763: p_cust_account_id => l_End_cust_account_id,

Line 799: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

795: p_header_shipment_tbl(1).ship_to_cust_account_id <> l_cust_account_id THEN
796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
797: aso_debug_pub.add('before cust_acct_relationship ', 1, 'N' );
798: END IF;
799: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
800: p_api_version => 1.0,
801: p_sold_to_cust_account => l_cust_account_id,
802: p_related_cust_account => p_header_shipment_tbl(1).ship_to_cust_account_id,
803: p_relationship_type => 'SHIP_TO',

Line 830: ASO_CHECK_TCA_PVT.Customer_Account_Site

826: IF p_header_shipment_tbl(1).ship_to_party_site_id is not NULL
827: AND p_header_shipment_tbl(1).ship_to_party_site_id <> FND_API.G_MISS_NUM
828: THEN
829:
830: ASO_CHECK_TCA_PVT.Customer_Account_Site
831: (
832: p_api_version => 1.0
833: ,p_party_site_id => p_header_shipment_tbl(1).ship_to_party_site_id
834: ,p_acct_site_type => 'SHIP_TO'

Line 868: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

864: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
865: aso_debug_pub.add('before Cust_Acct_Contact_Addr:p_header_shipment_tbl(1).ship_to_party_site_id: '||p_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
866: END IF;
867:
868: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
869: p_api_version => 1.0,
870: p_party_site_id => p_header_shipment_tbl(1).ship_to_party_site_id,
871: p_role_type => 'SHIP_TO',
872: p_cust_account_id => l_ship_cust_account_id,

Line 1480: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

1476: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1477: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
1478: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_related_cust_account: '||p_qte_line_tbl(k).invoice_to_cust_account_id,1,'N');
1479: END IF;
1480: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
1481: p_api_version => 1.0,
1482: p_sold_to_cust_account => l_cust_account_id,
1483: p_related_cust_account =>p_qte_line_tbl(k).invoice_to_cust_account_id,
1484: p_relationship_type => 'BILL_TO',

Line 1513: ASO_CHECK_TCA_PVT.Customer_Account_Site

1509: END IF;
1510: IF p_qte_line_tbl(k).invoice_to_party_site_id is not NULL
1511: AND p_qte_line_tbl(k).invoice_to_party_site_id <> FND_API.G_MISS_NUM THEN
1512:
1513: ASO_CHECK_TCA_PVT.Customer_Account_Site
1514: (
1515: p_api_version => 1.0
1516: ,p_party_site_id => p_qte_line_tbl(k).invoice_to_party_site_id
1517: ,p_acct_site_type => 'BILL_TO'

Line 1549: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

1545: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1546: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1547: END IF;
1548:
1549: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1550: p_api_version => 1.0,
1551: p_party_site_id => p_qte_line_tbl(k).invoice_to_party_site_id,
1552: p_role_type => 'BILL_TO',
1553: p_cust_account_id => l_invoice_cust_account_id,

Line 1588: ASO_CHECK_TCA_PVT.Customer_Account_Site

1584: END IF;
1585: IF p_qte_line_tbl(k).End_Customer_party_site_id is not NULL
1586: AND p_qte_line_tbl(k).End_Customer_party_site_id <> FND_API.G_MISS_NUM THEN
1587:
1588: ASO_CHECK_TCA_PVT.Customer_Account_Site
1589: (
1590: p_api_version => 1.0
1591: ,p_party_site_id => p_qte_line_tbl(k).End_Customer_party_site_id
1592: ,p_acct_site_type => 'END_USER'

Line 1626: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

1622: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1623: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1624: END IF;
1625:
1626: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1627: p_api_version => 1.0,
1628: p_party_site_id => p_qte_line_tbl(k).End_Customer_party_site_id,
1629: p_role_type => 'END_USER',
1630: p_cust_account_id => l_End_cust_account_id,

Line 2086: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

2082: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2083: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
2084: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
2085: END IF;
2086: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
2087: p_api_version => 1.0,
2088: p_sold_to_cust_account => l_cust_account_id,
2089: p_related_cust_account =>p_line_shipment_tbl(j).ship_to_cust_account_id,
2090: p_relationship_type => 'SHIP_TO',

Line 2119: ASO_CHECK_TCA_PVT.Customer_Account_Site

2115: END IF;
2116: IF p_line_shipment_tbl(j).ship_to_party_site_id is not NULL AND
2117: p_line_shipment_tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
2118:
2119: ASO_CHECK_TCA_PVT.Customer_Account_Site
2120: (
2121: p_api_version => 1.0
2122: ,p_party_site_id => p_line_shipment_tbl(j).ship_to_party_site_id
2123: ,p_acct_site_type => 'SHIP_TO'

Line 2157: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

2153: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2154: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2155: END IF;
2156:
2157: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
2158: p_api_version => 1.0,
2159: p_party_site_id => p_line_shipment_tbl(j).ship_to_party_site_id,
2160: p_role_type => 'SHIP_TO',
2161: p_cust_account_id => l_ship_cust_account_id,