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.19 2010/12/06 17:18:43 rassharm 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.19 2010/12/06 17:18:43 rassharm 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 2756: ASO_CHECK_TCA_PVT.Customer_Account(

2752: l_header_check_tca_flag := 'Y';
2753:
2754: IF l_cust_party IS NOT NULL THEN
2755:
2756: ASO_CHECK_TCA_PVT.Customer_Account(
2757: p_api_version => 1.0,
2758: p_Party_Id => l_cust_party,
2759: p_calling_api_flag => p_calling_api_flag,
2760: x_Cust_Acct_Id => l_account_id,

Line 2807: ASO_CHECK_TCA_PVT.Customer_Account(

2803: l_header_check_tca_flag := 'Y';
2804:
2805: IF l_inv_cust_party IS NOT NULL THEN
2806:
2807: ASO_CHECK_TCA_PVT.Customer_Account(
2808: p_api_version => 1.0,
2809: p_Party_Id => l_inv_cust_party,
2810: p_calling_api_flag => p_calling_api_flag,
2811: x_Cust_Acct_Id => l_account_id,

Line 2858: ASO_CHECK_TCA_PVT.Customer_Account(

2854: l_header_check_tca_flag := 'Y';
2855:
2856: IF l_end_cust_party IS NOT NULL THEN
2857:
2858: ASO_CHECK_TCA_PVT.Customer_Account(
2859: p_api_version => 1.0,
2860: p_Party_Id => l_end_cust_party,
2861: p_calling_api_flag => p_calling_api_flag,
2862: x_Cust_Acct_Id => l_account_id,

Line 2910: ASO_CHECK_TCA_PVT.Customer_Account(

2906: IF l_header_shipment_tbl(1).ship_to_cust_account_id IS NULL THEN
2907: l_header_check_tca_flag := 'Y';
2908: IF l_header_shipment_tbl(1).ship_to_cust_party_id IS NOT NULL THEN
2909:
2910: ASO_CHECK_TCA_PVT.Customer_Account(
2911: p_api_version => 1.0,
2912: p_Party_Id => l_header_shipment_tbl(1).ship_to_cust_party_id,
2913: p_calling_api_flag => p_calling_api_flag,
2914: x_Cust_Acct_Id => l_account_id,

Line 3024: ASO_CHECK_TCA_PVT.Customer_Account(

3020:
3021: IF l_qte_line_rec.invoice_to_cust_account_id IS NULL THEN
3022: IF l_qte_line_rec.invoice_to_cust_party_id IS NOT NULL THEN
3023:
3024: ASO_CHECK_TCA_PVT.Customer_Account(
3025: p_api_version => 1.0,
3026: p_Party_Id => l_qte_line_rec.invoice_to_cust_party_id,
3027: p_calling_api_flag => p_calling_api_flag,
3028: x_Cust_Acct_Id => l_account_id,

Line 3073: ASO_CHECK_TCA_PVT.Customer_Account(

3069:
3070: IF l_qte_line_rec.End_Customer_cust_account_id IS NULL THEN
3071: IF l_qte_line_rec.End_Customer_cust_party_id IS NOT NULL THEN
3072:
3073: ASO_CHECK_TCA_PVT.Customer_Account(
3074: p_api_version => 1.0,
3075: p_Party_Id => l_qte_line_rec.End_Customer_cust_party_id,
3076: p_calling_api_flag => p_calling_api_flag,
3077: x_Cust_Acct_Id => l_account_id,

Line 3122: ASO_CHECK_TCA_PVT.Customer_Account(

3118: IF Line_Acct.ship_to_cust_account_id IS NULL THEN
3119:
3120: IF Line_Acct.ship_to_cust_party_id IS NOT NULL THEN
3121:
3122: ASO_CHECK_TCA_PVT.Customer_Account(
3123: p_api_version => 1.0,
3124: p_Party_Id => Line_Acct.ship_to_cust_party_id,
3125: p_calling_api_flag => p_calling_api_flag,
3126: x_Cust_Acct_Id => l_account_id,

Line 3691: END ASO_CHECK_TCA_PVT;

3687: END Check_Customer_Accounts;
3688:
3689:
3690:
3691: END ASO_CHECK_TCA_PVT;