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_CHECK_TCA_PVT dependencies on ASO_CHECK_TCA_PVT

Line 1: PACKAGE BODY ASO_CHECK_TCA_PVT as

1: PACKAGE BODY ASO_CHECK_TCA_PVT as
2: /* $Header: asovctcb.pls 120.13 2006/09/07 18:13:10 bmishra ship $ */
3: -- Start of Comments
4: -- Package name : ASO_CHECK_TCA_PVT
5: -- Purpose :

Line 4: -- Package name : ASO_CHECK_TCA_PVT

1: PACKAGE BODY ASO_CHECK_TCA_PVT as
2: /* $Header: asovctcb.pls 120.13 2006/09/07 18:13:10 bmishra ship $ */
3: -- Start of Comments
4: -- Package name : ASO_CHECK_TCA_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_CHECK_TCA_PVT';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_CHECK_TCA_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovctcb.pls';
13:
14: PROCEDURE check_tca(
15: p_api_version IN NUMBER,

Line 521: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

517: END IF;
518:
519: END IF; -- sold_to_party_site
520:
521: ASO_CHECK_TCA_PVT.Populate_Acct_Party (
522: p_hdr_cust_acct_id => p_qte_rec.cust_account_id,
523: p_hdr_party_id => p_qte_rec.cust_party_id,
524: p_party_site_id => p_qte_rec.invoice_to_party_site_id,
525: p_cust_account_id => p_qte_rec.invoice_to_cust_account_id,

Line 623: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

619: aso_debug_pub.add('chk_hdr: invoice_to_party_site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
620: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
621: END IF;
622:
623: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
624: p_api_version => 1.0,
625: p_party_site_id => p_qte_rec.invoice_to_party_site_id,
626: p_role_type => 'BILL_TO',
627: p_cust_account_id => l_invoice_cust_account_id,

Line 649: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

645: IF aso_debug_pub.g_debug_flag = 'Y' THEN
646: aso_debug_pub.add('chk_hdr:beginning of mapping for header end user ', 1, 'N' );
647: END IF;
648:
649: ASO_CHECK_TCA_PVT.Populate_Acct_Party (
650: p_hdr_cust_acct_id => p_qte_rec.cust_account_id,
651: p_hdr_party_id => p_qte_rec.cust_party_id,
652: p_party_site_id => p_qte_rec.End_Customer_party_site_id,
653: p_cust_account_id => p_qte_rec.End_Customer_cust_account_id,

Line 751: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

747: aso_debug_pub.add('chk_hdr: End_Customer_party_site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
748: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
749: END IF;
750:
751: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
752: p_api_version => 1.0,
753: p_party_site_id => p_qte_rec.End_Customer_party_site_id,
754: p_role_type => 'END_USER',
755: p_cust_account_id => l_End_cust_account_id,

Line 789: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

785: aso_debug_pub.add('Check_Hdr_Acct: p_header_shipment_tbl(1).ship_to_party_site_id: '
786: || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
787: END IF;
788:
789: ASO_CHECK_TCA_PVT.Populate_Acct_Party (
790: p_hdr_cust_acct_id => p_qte_rec.cust_account_id,
791: p_hdr_party_id => p_qte_rec.cust_party_id,
792: p_party_site_id => p_header_shipment_tbl(1).ship_to_party_site_id,
793: p_cust_account_id => p_header_shipment_tbl(1).ship_to_cust_account_id,

Line 893: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

889: aso_debug_pub.add('chk_hdr:beginning of map 2:ship_party_id:' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
890: aso_debug_pub.add('chk_hdr: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
891: END IF;
892:
893: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
894: p_api_version => 1.0,
895: p_party_site_id => p_header_shipment_tbl(1).ship_to_party_site_id,
896: p_role_type => 'SHIP_TO',
897: p_cust_account_id => l_ship_cust_account_id,

Line 1145: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

1141: CLOSE C_Get_Sold_To_Info;
1142:
1143: END IF;
1144:
1145: ASO_CHECK_TCA_PVT.Populate_Acct_Party (
1146: p_hdr_cust_acct_id => l_cust_acct_id,
1147: p_hdr_party_id => l_cust_party_id,
1148: p_party_site_id => p_qte_line_rec.invoice_to_party_site_id,
1149: p_cust_account_id => p_qte_line_rec.invoice_to_cust_account_id,

Line 1248: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

1244: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1245: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1246: END IF;
1247:
1248: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1249: p_api_version => 1.0,
1250: p_party_site_id => p_qte_line_rec.invoice_to_party_site_id,
1251: p_role_type => 'BILL_TO',
1252: p_cust_account_id => l_invoice_cust_account_id,

Line 1289: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

1285: FETCH C_Get_Sold_To_Info INTO l_cust_acct_id, l_cust_party_id;
1286: CLOSE C_Get_Sold_To_Info;
1287:
1288:
1289: ASO_CHECK_TCA_PVT.Populate_Acct_Party (
1290: p_hdr_cust_acct_id => l_cust_acct_id,
1291: p_hdr_party_id => l_cust_party_id,
1292: p_party_site_id => p_qte_line_rec.End_Customer_party_site_id,
1293: p_cust_account_id => p_qte_line_rec.End_Customer_cust_account_id,

Line 1392: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

1388: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1389: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1390: END IF;
1391:
1392: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1393: p_api_version => 1.0,
1394: p_party_site_id => p_qte_line_rec.End_Customer_party_site_id,
1395: p_role_type => 'END_USER',
1396: p_cust_account_id => l_End_cust_account_id,

Line 1425: ASO_CHECK_TCA_PVT.Populate_Acct_Party (

1421: ||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
1422: END IF;
1423: -- bug 5132989
1424: /*
1425: ASO_CHECK_TCA_PVT.Populate_Acct_Party (
1426: p_hdr_cust_acct_id => l_cust_acct_id,
1427: p_hdr_party_id => l_cust_party_id,
1428: p_party_site_id => p_line_shipment_tbl(j).ship_to_party_site_id,
1429: p_cust_account_id => p_line_shipment_tbl(j).ship_to_cust_account_id,

Line 1529: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

1525: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1526: aso_debug_pub.add('chk_ln: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
1527: END IF;
1528:
1529: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1530: p_api_version => 1.0,
1531: p_party_site_id => p_line_shipment_tbl(j).ship_to_party_site_id,
1532: p_role_type => 'SHIP_TO',
1533: p_cust_account_id => l_ship_cust_account_id,

Line 2722: ASO_CHECK_TCA_PVT.Customer_Account(

2718: l_header_check_tca_flag := 'Y';
2719:
2720: IF l_cust_party IS NOT NULL THEN
2721:
2722: ASO_CHECK_TCA_PVT.Customer_Account(
2723: p_api_version => 1.0,
2724: p_Party_Id => l_cust_party,
2725: p_calling_api_flag => p_calling_api_flag,
2726: x_Cust_Acct_Id => l_account_id,

Line 2771: ASO_CHECK_TCA_PVT.Customer_Account(

2767: l_header_check_tca_flag := 'Y';
2768:
2769: IF l_inv_cust_party IS NOT NULL THEN
2770:
2771: ASO_CHECK_TCA_PVT.Customer_Account(
2772: p_api_version => 1.0,
2773: p_Party_Id => l_inv_cust_party,
2774: p_calling_api_flag => p_calling_api_flag,
2775: x_Cust_Acct_Id => l_account_id,

Line 2820: ASO_CHECK_TCA_PVT.Customer_Account(

2816: l_header_check_tca_flag := 'Y';
2817:
2818: IF l_end_cust_party IS NOT NULL THEN
2819:
2820: ASO_CHECK_TCA_PVT.Customer_Account(
2821: p_api_version => 1.0,
2822: p_Party_Id => l_end_cust_party,
2823: p_calling_api_flag => p_calling_api_flag,
2824: x_Cust_Acct_Id => l_account_id,

Line 2870: ASO_CHECK_TCA_PVT.Customer_Account(

2866: IF l_header_shipment_tbl(1).ship_to_cust_account_id IS NULL THEN
2867: l_header_check_tca_flag := 'Y';
2868: IF l_header_shipment_tbl(1).ship_to_cust_party_id IS NOT NULL THEN
2869:
2870: ASO_CHECK_TCA_PVT.Customer_Account(
2871: p_api_version => 1.0,
2872: p_Party_Id => l_header_shipment_tbl(1).ship_to_cust_party_id,
2873: p_calling_api_flag => p_calling_api_flag,
2874: x_Cust_Acct_Id => l_account_id,

Line 2982: ASO_CHECK_TCA_PVT.Customer_Account(

2978:
2979: IF l_qte_line_rec.invoice_to_cust_account_id IS NULL THEN
2980: IF l_qte_line_rec.invoice_to_cust_party_id IS NOT NULL THEN
2981:
2982: ASO_CHECK_TCA_PVT.Customer_Account(
2983: p_api_version => 1.0,
2984: p_Party_Id => l_qte_line_rec.invoice_to_cust_party_id,
2985: p_calling_api_flag => p_calling_api_flag,
2986: x_Cust_Acct_Id => l_account_id,

Line 3029: ASO_CHECK_TCA_PVT.Customer_Account(

3025:
3026: IF l_qte_line_rec.End_Customer_cust_account_id IS NULL THEN
3027: IF l_qte_line_rec.End_Customer_cust_party_id IS NOT NULL THEN
3028:
3029: ASO_CHECK_TCA_PVT.Customer_Account(
3030: p_api_version => 1.0,
3031: p_Party_Id => l_qte_line_rec.End_Customer_cust_party_id,
3032: p_calling_api_flag => p_calling_api_flag,
3033: x_Cust_Acct_Id => l_account_id,

Line 3076: ASO_CHECK_TCA_PVT.Customer_Account(

3072: IF Line_Acct.ship_to_cust_account_id IS NULL THEN
3073:
3074: IF Line_Acct.ship_to_cust_party_id IS NOT NULL THEN
3075:
3076: ASO_CHECK_TCA_PVT.Customer_Account(
3077: p_api_version => 1.0,
3078: p_Party_Id => Line_Acct.ship_to_cust_party_id,
3079: p_calling_api_flag => p_calling_api_flag,
3080: x_Cust_Acct_Id => l_account_id,

Line 3643: END ASO_CHECK_TCA_PVT;

3639: END Check_Customer_Accounts;
3640:
3641:
3642:
3643: END ASO_CHECK_TCA_PVT;