DBA Data[Home] [Help]

APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on ASO_CHECK_TCA_PVT

Line 465: ASO_CHECK_TCA_PVT.Customer_Account(

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

Line 530: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

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

Line 639: ASO_CHECK_TCA_PVT.Customer_Account_Site

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

Line 676: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

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

Line 718: ASO_CHECK_TCA_PVT.Customer_Account_Site

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

Line 757: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

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

Line 797: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

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

Line 828: ASO_CHECK_TCA_PVT.Customer_Account_Site

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

Line 866: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

862: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
863: 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');
864: END IF;
865:
866: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
867: p_api_version => 1.0,
868: p_party_site_id => p_header_shipment_tbl(1).ship_to_party_site_id,
869: p_role_type => 'SHIP_TO',
870: p_cust_account_id => l_ship_cust_account_id,

Line 1436: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

1432: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1433: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
1434: 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');
1435: END IF;
1436: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
1437: p_api_version => 1.0,
1438: p_sold_to_cust_account => l_cust_account_id,
1439: p_related_cust_account =>p_qte_line_tbl(k).invoice_to_cust_account_id,
1440: p_relationship_type => 'BILL_TO',

Line 1469: ASO_CHECK_TCA_PVT.Customer_Account_Site

1465: END IF;
1466: IF p_qte_line_tbl(k).invoice_to_party_site_id is not NULL
1467: AND p_qte_line_tbl(k).invoice_to_party_site_id <> FND_API.G_MISS_NUM THEN
1468:
1469: ASO_CHECK_TCA_PVT.Customer_Account_Site
1470: (
1471: p_api_version => 1.0
1472: ,p_party_site_id => p_qte_line_tbl(k).invoice_to_party_site_id
1473: ,p_acct_site_type => 'BILL_TO'

Line 1505: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

1501: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1502: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1503: END IF;
1504:
1505: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1506: p_api_version => 1.0,
1507: p_party_site_id => p_qte_line_tbl(k).invoice_to_party_site_id,
1508: p_role_type => 'BILL_TO',
1509: p_cust_account_id => l_invoice_cust_account_id,

Line 1544: ASO_CHECK_TCA_PVT.Customer_Account_Site

1540: END IF;
1541: IF p_qte_line_tbl(k).End_Customer_party_site_id is not NULL
1542: AND p_qte_line_tbl(k).End_Customer_party_site_id <> FND_API.G_MISS_NUM THEN
1543:
1544: ASO_CHECK_TCA_PVT.Customer_Account_Site
1545: (
1546: p_api_version => 1.0
1547: ,p_party_site_id => p_qte_line_tbl(k).End_Customer_party_site_id
1548: ,p_acct_site_type => 'END_USER'

Line 1582: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

1578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1579: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1580: END IF;
1581:
1582: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1583: p_api_version => 1.0,
1584: p_party_site_id => p_qte_line_tbl(k).End_Customer_party_site_id,
1585: p_role_type => 'END_USER',
1586: p_cust_account_id => l_End_cust_account_id,

Line 2034: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

2030: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2031: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
2032: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
2033: END IF;
2034: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
2035: p_api_version => 1.0,
2036: p_sold_to_cust_account => l_cust_account_id,
2037: p_related_cust_account =>p_line_shipment_tbl(j).ship_to_cust_account_id,
2038: p_relationship_type => 'SHIP_TO',

Line 2067: ASO_CHECK_TCA_PVT.Customer_Account_Site

2063: END IF;
2064: IF p_line_shipment_tbl(j).ship_to_party_site_id is not NULL AND
2065: p_line_shipment_tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
2066:
2067: ASO_CHECK_TCA_PVT.Customer_Account_Site
2068: (
2069: p_api_version => 1.0
2070: ,p_party_site_id => p_line_shipment_tbl(j).ship_to_party_site_id
2071: ,p_acct_site_type => 'SHIP_TO'

Line 2105: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

2101: 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');
2102: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2103: END IF;
2104:
2105: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
2106: p_api_version => 1.0,
2107: p_party_site_id => p_line_shipment_tbl(j).ship_to_party_site_id,
2108: p_role_type => 'SHIP_TO',
2109: p_cust_account_id => l_ship_cust_account_id,