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.AP_ETAX_SERVICES_PKG dependencies on AP_ETAX_SERVICES_PKG

Line 1: PACKAGE BODY AP_ETAX_SERVICES_PKG AS

1: PACKAGE BODY AP_ETAX_SERVICES_PKG AS
2: /* $Header: apetxsrb.pls 120.115.12010000.18 2008/12/16 07:15:34 hchaudha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_ETAX_SERVICES_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_ETAX_SERVICES_PKG';

1: PACKAGE BODY AP_ETAX_SERVICES_PKG AS
2: /* $Header: apetxsrb.pls 120.115.12010000.18 2008/12/16 07:15:34 hchaudha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_ETAX_SERVICES_PKG';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_ETAX_SERVICES_PKG.';

16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_ETAX_SERVICES_PKG.';
21:
22: -- Define the structures for lines and distributions
23: TYPE Inv_Lines_Tab_Type IS TABLE OF ap_invoice_lines_all%ROWTYPE;
24: TYPE Inv_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;

Line 243: Print(l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');

239: l_count NUMBER;
240:
241: BEGIN
242:
243: Print(l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
244:
245: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate<-' || P_calling_sequence;
246:
247: l_validation_request_id := ap_approval_pkg.g_validation_request_id;

Line 245: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate<-' || P_calling_sequence;

241: BEGIN
242:
243: Print(l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
244:
245: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate<-' || P_calling_sequence;
246:
247: l_validation_request_id := ap_approval_pkg.g_validation_request_id;
248:
249: g_invoices_to_process := 0;

Line 253: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(

249: g_invoices_to_process := 0;
250:
251: IF l_validation_request_id IS NOT NULL THEN
252:
253: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(
254: p_validation_request_id => l_validation_request_id,
255: p_calling_mode => p_calling_mode,
256: p_error_code => p_error_code) THEN
257:

Line 332: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

328: -----------------------------------------------------------------
329: l_debug_info := 'Populate Header';
330: Print(l_api_name,l_debug_info);
331: -----------------------------------------------------------------
332: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
333: P_Invoice_Header_Rec => l_inv_header_rec,
334: P_Calling_Mode => P_Calling_Mode,
335: P_eTax_Already_called_flag => l_tax_already_calculated,
336: P_Event_Class_Code => l_event_class_code,

Line 400: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

396: DELETE FROM ZX_TRANSACTION_LINES_GT;
397: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
398: DELETE FROM ZX_TRX_TAX_LINK_GT;
399:
400: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
401: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
402:
403:
404: OPEN C_SELECTED_INVOICES;

Line 401: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;

397: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
398: DELETE FROM ZX_TRX_TAX_LINK_GT;
399:
400: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
401: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
402:
403:
404: OPEN C_SELECTED_INVOICES;
405: LOOP

Line 552: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(

548: l_debug_info := 'If tax already calculated call freeze distributions';
549: Print(l_api_name,l_debug_info);
550: -----------------------------------------------------------------
551: --Bug7592845
552: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(
553: P_Invoice_Header_Rec => l_inv_header_rec,
554: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
555: P_Event_Class_Code => l_event_class_code,
556: P_All_Error_Messages => P_All_Error_Messages,

Line 578: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

574: l_debug_info := 'Populate TRX lines. No tax lines exist';
575: Print(l_api_name,l_debug_info);
576: -----------------------------------------------------------------
577: IF (l_return_status = TRUE) THEN
578: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
579: P_Invoice_Header_Rec => l_inv_header_rec,
580: P_Calling_Mode => P_Calling_Mode,
581: P_Event_Class_Code => l_event_class_code,
582: P_Line_Number => P_Line_Number,

Line 603: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

599: l_debug_info := 'Populate TRX Lines. IMPORT';
600: Print(l_api_name,l_debug_info);
601: -----------------------------------------------------------------
602: IF (l_return_status = TRUE) THEN
603: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
604: P_Invoice_Header_Rec => l_inv_header_rec,
605: P_Calling_Mode => P_Calling_Mode,
606: P_Event_Class_Code => l_event_class_code,
607: P_Line_Number => P_Line_Number,

Line 620: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(

616: l_debug_info := 'Populate TAX lines to be imported';
617: Print(l_api_name,l_debug_info);
618: -----------------------------------------------------------------
619: IF (l_return_status = TRUE) THEN
620: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(
621: P_Invoice_Header_Rec => l_inv_header_rec,
622: P_Calling_Mode => P_Calling_Mode,
623: P_Event_Class_Code => l_event_class_code,
624: P_Tax_only_Flag => 'N',

Line 646: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(

642: l_debug_info := 'Populate pseudo TRX line, TAX lines to be imported';
643: Print(l_api_name,l_debug_info);
644: -----------------------------------------------------------------
645: IF (l_return_status = TRUE) THEN
646: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(
647: P_Invoice_Header_Rec => l_inv_header_rec,
648: P_Calling_Mode => P_Calling_Mode,
649: P_Event_Class_Code => l_event_class_code,
650: P_Tax_only_Flag => 'Y',

Line 764: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

760: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
761: FETCH Invoice_Header INTO l_inv_header_rec;
762: CLOSE Invoice_Header;
763:
764: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
765: P_Invoice_header_rec => l_inv_header_rec,
766: P_Calling_Mode => P_Calling_Mode,
767: P_All_Error_Messages => P_All_Error_Messages,
768: P_Error_Code => P_error_code,

Line 884: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate_Import<-' ||

880:
881: l_api_name CONSTANT VARCHAR2(100) := 'Calculate_Import';
882:
883: BEGIN
884: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate_Import<-' ||
885: P_calling_sequence;
886:
887: -----------------------------------------------------------------
888: l_debug_info := 'Step 1: Populating invoice header local record';

Line 943: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

939: l_debug_info := 'Populate Headers';
940: Print(l_api_name, l_debug_info);
941: -----------------------------------------------------------------
942:
943: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
944: P_Invoice_Header_Rec => l_inv_header_rec,
945: P_Calling_Mode => 'CALCULATE',
946: P_eTax_Already_called_flag => 'Y',
947: P_Event_Class_Code => l_event_class_code,

Line 987: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

983: l_debug_info := 'Populate Lines';
984: Print(l_api_name, l_debug_info);
985: -----------------------------------------------------------------
986:
987: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
988: P_Invoice_Header_Rec => l_inv_header_rec,
989: P_Calling_Mode => 'CALCULATE',
990: P_Event_Class_Code => l_event_class_code,
991: P_Error_Code => P_error_code,

Line 1066: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

1062:
1063: -----------------------------------------------------------------
1064: l_debug_info := 'Step 8: Handle return of tax lines';
1065: -----------------------------------------------------------------
1066: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
1067: P_Invoice_header_rec => l_inv_header_rec,
1068: P_Calling_Mode => P_Calling_Mode,
1069: P_All_Error_Messages => P_All_Error_Messages,
1070: P_Error_Code => P_error_code,

Line 1282: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Distribute<-' ||

1278:
1279:
1280: BEGIN
1281:
1282: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Distribute<-' ||
1283: P_calling_sequence;
1284:
1285: IF ap_approval_pkg.g_validation_request_id IS NULL THEN
1286:

Line 1320: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

1316: -----------------------------------------------------------------
1317: l_debug_info := 'Populate Header';
1318: Print(l_api_name,l_debug_info);
1319: -----------------------------------------------------------------
1320: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
1321: P_Invoice_Header_Rec => l_inv_header_rec,
1322: P_Calling_Mode => P_Calling_Mode,
1323: P_eTax_Already_called_flag => l_tax_already_distributed,
1324: P_Event_Class_Code => l_event_class_code,

Line 1340: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(

1336: -----------------------------------------------------------------
1337: l_debug_info := 'Batch: Bulk Populate Header';
1338: Print(l_api_name,l_debug_info);
1339: -----------------------------------------------------------------
1340: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(
1341: p_validation_request_id => ap_approval_pkg.g_validation_request_id,
1342: p_calling_mode => p_calling_mode,
1343: p_error_code => p_error_code) THEN
1344:

Line 1506: IF NOT (AP_ETAX_SERVICES_PKG.Populate_Distributions_GT(

1502: -----------------------------------------------------------------
1503: IF (l_return_status = TRUE
1504: and l_inv_dist_list.count > 0) THEN
1505:
1506: IF NOT (AP_ETAX_SERVICES_PKG.Populate_Distributions_GT(
1507: P_Invoice_Header_Rec => l_inv_header_rec,
1508: P_Calling_Mode => P_Calling_Mode,
1509: P_Event_Class_Code => l_event_class_code,
1510: P_Event_Type_Code => l_event_type_code,

Line 1589: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

1585: -----------------------------------------------------------------
1586: l_debug_info := 'Handle return of tax distributions';
1587: Print(l_api_name,l_debug_info);
1588: -----------------------------------------------------------------
1589: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
1590: P_Invoice_header_rec => l_inv_header_rec,
1591: P_Calling_Mode => P_Calling_Mode,
1592: P_All_Error_Messages => P_All_Error_Messages,
1593: P_Error_Code => P_error_code,

Line 1646: IF NOT(AP_ETAX_SERVICES_PKG.Update_Distributions(

1642: -----------------------------------------------------------------
1643: l_debug_info := 'Update Invoice Distributions';
1644: Print(l_api_name,l_debug_info);
1645: -----------------------------------------------------------------
1646: IF NOT(AP_ETAX_SERVICES_PKG.Update_Distributions(
1647: P_Invoice_header_rec => l_inv_header_rec,
1648: P_Calling_Mode => P_Calling_Mode,
1649: P_All_Error_Messages => P_All_Error_Messages,
1650: P_Error_Code => P_error_code,

Line 1741: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Distribute_Import<-' ||

1737: WHERE invoice_id = P_Invoice_Id;
1738:
1739: BEGIN
1740:
1741: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Distribute_Import<-' ||
1742: P_calling_sequence;
1743:
1744: -----------------------------------------------------------------
1745: l_debug_info := 'Step 1: Populating invoice header local record';

Line 1784: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

1780: l_debug_info := 'Step 5: Handle return of tax lines';
1781: -----------------------------------------------------------------
1782: print(l_api_name,l_debug_info); -- bug 6321366
1783:
1784: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
1785: P_Invoice_header_rec => l_inv_header_rec,
1786: P_Calling_Mode => P_Calling_Mode,
1787: P_All_Error_Messages => P_All_Error_Messages,
1788: P_Error_Code => P_error_code,

Line 1885: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Import_Interface<-' ||

1881: FROM ap_invoices_all
1882: WHERE invoice_id = P_Invoice_Id;
1883:
1884: BEGIN
1885: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Import_Interface<-' ||
1886: P_calling_sequence;
1887:
1888: -----------------------------------------------------------------
1889: l_debug_info := 'Step 1: Populating invoice header local record';

Line 1997: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

1993:
1994: -----------------------------------------------------------------
1995: l_debug_info := 'Step 10: Handle return of tax lines';
1996: -----------------------------------------------------------------
1997: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
1998: P_Invoice_header_rec => l_inv_header_rec,
1999: P_Calling_Mode => P_Calling_Mode,
2000: P_All_Error_Messages => P_All_Error_Messages,
2001: P_Error_Code => P_error_code,

Line 2111: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Reverse_Invoice<-' ||

2107:
2108: l_api_name CONSTANT VARCHAR2(100) := 'Reverse_Invoice';
2109:
2110: BEGIN
2111: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Reverse_Invoice<-' ||
2112: P_calling_sequence;
2113:
2114: -----------------------------------------------------------------
2115: l_debug_info := 'Step 1: Populating crediting invoice header';

Line 2356: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

2352: -----------------------------------------------------------------
2353: l_debug_info := 'Populate Header';
2354: Print(l_api_name,l_debug_info);
2355: -----------------------------------------------------------------
2356: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
2357: P_Invoice_Header_Rec => l_inv_header_rec,
2358: P_Calling_Mode => P_Calling_Mode,
2359: P_eTax_Already_called_flag => l_tax_already_distributed,
2360: P_Event_Class_Code => l_event_class_code,

Line 2368: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

2364:
2365: l_return_status := FALSE;
2366: END IF;
2367:
2368: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
2369: P_Invoice_header_rec => l_inv_header_rec,
2370: P_Calling_Mode => P_Calling_Mode,
2371: P_All_Error_Messages => P_All_Error_Messages,
2372: P_Error_Code => P_error_code,

Line 2493: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Override_Tax<-' ||

2489:
2490: l_api_name CONSTANT VARCHAR2(100) := 'Override_Tax';
2491:
2492: BEGIN
2493: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Override_Tax<-' ||
2494: P_calling_sequence;
2495:
2496: IF (P_Override_Status = 'SYNCHRONIZE') THEN
2497: -----------------------------------------------------------------

Line 2658: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

2654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2655: END IF;
2656: -----------------------------------------------------------------
2657:
2658: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
2659: P_Invoice_Header_Rec => l_inv_header_rec,
2660: P_Calling_Mode => P_Calling_Mode,
2661: P_eTax_Already_called_flag => NULL,
2662: P_Event_Class_Code => l_event_class_code,

Line 2676: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

2672: Print(l_api_name,l_debug_info);
2673: -----------------------------------------------------------------
2674: DELETE FROM ZX_TRANSACTION_LINES_GT;
2675:
2676: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
2677: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
2678:
2679: IF l_inv_header_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN /* if
2680: condition for bug 5967914 as we need tp pass party_site_id instead of

Line 2677: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;

2673: -----------------------------------------------------------------
2674: DELETE FROM ZX_TRANSACTION_LINES_GT;
2675:
2676: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
2677: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
2678:
2679: IF l_inv_header_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN /* if
2680: condition for bug 5967914 as we need tp pass party_site_id instead of
2681: vendor_site_id if invoice_type_lookup_code ='PAYMENT REQUEST' */

Line 2702: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

2698: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2699: END IF;
2700: -----------------------------------------------------------------
2701: IF ( l_return_status = TRUE ) THEN
2702: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
2703: P_Invoice_Header_Rec => l_inv_header_rec,
2704: P_Calling_Mode => P_Calling_Mode,
2705: P_Event_Class_Code => l_event_class_code,
2706: P_Error_Code => P_error_code,

Line 2757: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

2753: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2754: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2755: END IF;
2756: -----------------------------------------------------------------
2757: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
2758: P_Invoice_header_rec => l_inv_header_rec,
2759: P_Calling_Mode => P_Calling_Mode,
2760: P_All_Error_Messages => P_All_Error_Messages,
2761: P_Error_Code => P_error_code,

Line 2793: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(

2789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2790: END IF;
2791: -----------------------------------------------------------------
2792: --Bug7592845
2793: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(
2794: P_Invoice_Header_Rec => l_inv_header_rec,
2795: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
2796: P_Event_Class_Code => l_event_class_code,
2797: P_All_Error_Messages => P_All_Error_Messages,

Line 2924: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Override_Recovery<-' ||

2920: l_return_status BOOLEAN := TRUE;
2921: l_api_name varchar2(30) := 'Override_recovery';
2922:
2923: BEGIN
2924: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Override_Recovery<-' ||
2925: P_calling_sequence;
2926:
2927: -----------------------------------------------------------------
2928: l_debug_info := 'Step 1: Populating invoice header local record';

Line 2967: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

2963: l_return_status := FALSE;
2964: END IF;
2965: END IF;
2966: /* added for 6157052 we need to populate zx_headers_gt in this case.*/
2967: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
2968: P_Invoice_Header_Rec => l_inv_header_rec,
2969: P_Calling_Mode => P_Calling_Mode,
2970: P_eTax_Already_called_flag => 'Y',
2971: P_Event_Class_Code => l_event_class_code,

Line 2985: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_Distributions(

2981: -- are freezing the distributions and after that we are not supposed to change
2982: --the distributons.But here we need to change the tax distributions as we are
2983: --changing the ecovery rate .so we need not make this callhere.
2984: /*
2985: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_Distributions(
2986: P_Invoice_Header_Rec => l_inv_header_rec,
2987: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
2988: P_Event_Class_Code => l_event_class_code,
2989: P_All_Error_Messages => P_All_Error_Messages,

Line 3044: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

3040: -- Debug messages added for 6321366
3041: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3042: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
3043: END IF;
3044: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
3045: P_Invoice_header_rec => l_inv_header_rec,
3046: P_Calling_Mode => P_Calling_Mode,
3047: P_All_Error_Messages => P_All_Error_Messages,
3048: P_Error_Code => P_error_code,

Line 3184: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Freeze_Itm_Distributions<-' ||

3180:
3181: l_api_name CONSTANT VARCHAR2(100) := 'Freeze_Itm_Distributions';
3182:
3183: BEGIN
3184: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Freeze_Itm_Distributions<-' ||
3185: P_calling_sequence;
3186: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3187: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_curr_calling_sequence);
3188: END IF;

Line 3576: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Freeze_Distributions<-' ||

3572:
3573: l_api_name CONSTANT VARCHAR2(100) := 'Freeze_Distributions';
3574:
3575: BEGIN
3576: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Freeze_Distributions<-' ||
3577: P_calling_sequence;
3578:
3579: -----------------------------------------------------------------
3580: l_debug_info := 'Step 1: Populating tax distributions collection';

Line 3959: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Global_Document_Update<-' ||

3955: l_return_status BOOLEAN := TRUE;
3956: l_api_name VARCHAR2(30) := 'global_document_update'; -- bug 6321366
3957: BEGIN
3958:
3959: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Global_Document_Update<-' ||
3960: P_calling_sequence;
3961:
3962: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3963: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_curr_calling_sequence);

Line 4007: l_success := AP_ETAX_SERVICES_PKG.Calculate(

4003:
4004: --bugfix:5697764
4005: ELSIF P_Calling_Mode = 'UNAPPLY PREPAY' THEN
4006:
4007: l_success := AP_ETAX_SERVICES_PKG.Calculate(
4008: P_Invoice_id => P_Invoice_Id,
4009: P_Line_Number => P_Line_Number,
4010: P_Calling_Mode => P_Calling_Mode,
4011: P_All_Error_Messages => P_All_Error_Messages,

Line 4311: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Release_Tax_Holds<-' ||

4307: l_return_status BOOLEAN := TRUE;
4308:
4309: BEGIN
4310:
4311: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Release_Tax_Holds<-' ||
4312: P_calling_sequence;
4313:
4314: IF (P_Tax_Hold_Code.COUNT = 0 ) THEN
4315:

Line 4507: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Mark_Tax_Lines_Deleted<-' ||

4503:
4504: l_return_status BOOLEAN := TRUE;
4505:
4506: BEGIN
4507: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Mark_Tax_Lines_Deleted<-' ||
4508: P_calling_sequence;
4509:
4510: -----------------------------------------------------------------
4511: l_debug_info := 'Step 1: Populating invoice header local record';

Line 4692: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Validate_Invoice<-' ||

4688:
4689:
4690: BEGIN
4691:
4692: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Validate_Invoice<-' ||
4693: P_calling_sequence;
4694:
4695: l_api_name := 'Validate_Invoice';
4696: -----------------------------------------------------------------

Line 4973: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Validate_Default_Import<-'

4969:
4970: l_return_status BOOLEAN := TRUE;
4971:
4972: BEGIN
4973: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Validate_Default_Import<-'
4974: ||P_calling_sequence;
4975:
4976: -----------------------------------------------------------------
4977: l_debug_info := 'Step 1: Populate Header';

Line 4979: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT(

4975:
4976: -----------------------------------------------------------------
4977: l_debug_info := 'Step 1: Populate Header';
4978: -----------------------------------------------------------------
4979: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT(
4980: P_Invoice_Header_Rec => P_Invoice_Rec,
4981: P_Calling_Mode => P_Calling_Mode,
4982: P_Event_Class_Code => l_event_class_code,
4983: P_Event_Type_Code => l_event_type_code,

Line 4995: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT(

4991: l_debug_info := 'Step 2: Populate Trx and Tax Lines and allocation '||
4992: 'structure ';
4993: -----------------------------------------------------------------
4994: IF ( l_return_status = TRUE ) THEN
4995: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT(
4996: P_Invoice_Header_Rec => P_Invoice_Rec,
4997: P_Inv_Line_List => p_invoice_lines_tab,
4998: P_Calling_Mode => P_Calling_Mode,
4999: P_Event_Class_Code => l_event_class_code,

Line 5155: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Headers_GT<-' ||

5151: l_return_status BOOLEAN := TRUE;
5152: l_api_name VARCHAR2(30) := 'Populate_headers_gt'; --bug 6321366
5153: BEGIN
5154:
5155: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Headers_GT<-' ||
5156: P_calling_sequence;
5157:
5158: -------------------------------------------------------------------
5159: l_debug_info := 'Step 1: Get event class code';

Line 5551: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT<-'||

5547: l_api_name VARCHAR2(30) := 'populate_header_import_gt';
5548:
5549: BEGIN
5550:
5551: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT<-'||
5552: P_calling_sequence;
5553:
5554: -------------------------------------------------------------------
5555: l_debug_info := 'Step 1: Get event class code';

Line 5966: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_GT<-' ||

5962: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
5963:
5964: BEGIN
5965:
5966: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_GT<-' ||
5967: P_calling_sequence;
5968:
5969: ----------------------------------------------------------------------
5970: l_debug_info := 'Set line defaults from cache';

Line 5974: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes

5970: l_debug_info := 'Set line defaults from cache';
5971: Print(l_api_name,l_debug_info);
5972: ----------------------------------------------------------------------
5973: IF l_payment_request_flag ='N' THEN ---for bug 5967914
5974: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
5975: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
5976: END IF;
5977:
5978: IF l_payment_request_flag ='Y' THEN ---if condition added for bug 5967914

Line 5979: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes

5975: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
5976: END IF;
5977:
5978: IF l_payment_request_flag ='Y' THEN ---if condition added for bug 5967914
5979: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
5980: (p_invoice_header_rec.party_site_id).location_id;
5981: ELSE
5982: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
5983: (p_invoice_header_rec.vendor_site_id).location_id;

Line 5982: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes

5978: IF l_payment_request_flag ='Y' THEN ---if condition added for bug 5967914
5979: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
5980: (p_invoice_header_rec.party_site_id).location_id;
5981: ELSE
5982: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
5983: (p_invoice_header_rec.vendor_site_id).location_id;
5984: END IF;
5985:
5986: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes

Line 5986: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes

5982: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
5983: (p_invoice_header_rec.vendor_site_id).location_id;
5984: END IF;
5985:
5986: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes
5987: (p_invoice_header_rec.org_id).bill_to_location_id;
5988:
5989: ----------------------------------------------------------------------
5990: l_debug_info := 'Go through taxable lines';

Line 6498: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',

6494: p_tax_classification_code => l_dflt_tax_class_code,
6495: p_allow_tax_code_override_flag => l_allow_tax_code_override,
6496: APPL_SHORT_NAME => 'SQLAP',
6497: FUNC_SHORT_NAME => 'NONE',
6498: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
6499: p_event_class_code => P_Event_Class_Code,
6500: p_entity_code => 'AP_INVOICES',
6501: p_application_id => 200,
6502: p_internal_organization_id => P_Invoice_Header_Rec.org_id);

Line 6818: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT<-' ||

6814: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Lines_Import_GT';
6815:
6816: BEGIN
6817:
6818: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT<-' ||
6819: P_calling_sequence;
6820:
6821: ----------------------------------------------------------------------
6822: l_debug_info := 'Step 1: Get location_id for org_id';

Line 7067: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',

7063: p_tax_classification_code => l_dflt_tax_class_code,
7064: p_allow_tax_code_override_flag => l_allow_tax_code_override,
7065: APPL_SHORT_NAME => 'SQLAP',
7066: FUNC_SHORT_NAME => 'NONE',
7067: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
7068: p_event_class_code => p_event_class_code,
7069: p_entity_code => 'AP_INVOICES',
7070: p_application_id => 200,
7071: p_internal_organization_id => p_invoice_header_rec.org_id);

Line 7955: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT<-'||

7951: l_prorating_total number; ---for bug 6064593
7952: l_total_prorated number; ---for bug 6064593
7953: BEGIN
7954:
7955: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT<-'||
7956: P_calling_sequence;
7957:
7958:
7959: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes

Line 7959: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes

7955: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT<-'||
7956: P_calling_sequence;
7957:
7958:
7959: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
7960: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
7961: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
7962: (p_invoice_header_rec.vendor_site_id).location_id;
7963: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes

Line 7961: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes

7957:
7958:
7959: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
7960: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
7961: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
7962: (p_invoice_header_rec.vendor_site_id).location_id;
7963: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes
7964: (p_invoice_header_rec.org_id).bill_to_location_id;
7965:

Line 7963: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes

7959: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
7960: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
7961: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
7962: (p_invoice_header_rec.vendor_site_id).location_id;
7963: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes
7964: (p_invoice_header_rec.org_id).bill_to_location_id;
7965:
7966: IF (P_Tax_only_Flag = 'N') THEN
7967:

Line 8691: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Distributions_GT<-'||

8687: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Distributions_GT';
8688:
8689: BEGIN
8690:
8691: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Distributions_GT<-'||
8692: P_calling_sequence;
8693:
8694: IF (l_inv_dist_list.COUNT > 0) THEN
8695:

Line 9120: 'AP_ETAX_SERVICES_PKG.Update_AP<-'||P_calling_sequence;

9116:
9117: BEGIN
9118:
9119: l_curr_calling_sequence :=
9120: 'AP_ETAX_SERVICES_PKG.Update_AP<-'||P_calling_sequence;
9121:
9122: ------------------------------------------------------------------
9123: l_debug_info := 'Step 1: Calling_Mode is:'||P_Calling_Mode;
9124: ------------------------------------------------------------------

Line 9299: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CALCULATE_QUOTE<-' || P_calling_sequence;

9295: AND NVL(zdl.reporting_only_flag, 'N') = 'N';
9296:
9297: BEGIN
9298:
9299: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CALCULATE_QUOTE<-' || P_calling_sequence;
9300:
9301: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
9302: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate_Quote (+)');
9303: END IF;

Line 9302: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate_Quote (+)');

9298:
9299: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CALCULATE_QUOTE<-' || P_calling_sequence;
9300:
9301: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
9302: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate_Quote (+)');
9303: END IF;
9304:
9305: ----------------------------------------------------------------------
9306: l_debug_info := 'Get location_id for vendor site';

Line 9340: l_debug_info := 'Step 1: Call AP_ETAX_SERVICES_PKG.Populate_Headers_GT';

9336:
9337: END IF;
9338:
9339: -------------------------------------------------------------------------
9340: l_debug_info := 'Step 1: Call AP_ETAX_SERVICES_PKG.Populate_Headers_GT';
9341: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
9343: END IF;
9344: -------------------------------------------------------------------------

Line 9345: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

9341: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
9343: END IF;
9344: -------------------------------------------------------------------------
9345: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
9346: P_Invoice_Header_Rec => P_Invoice_Header_Rec,
9347: P_Calling_Mode => P_Calling_Mode,
9348: P_eTax_Already_called_flag => l_tax_already_calculated,
9349: P_Event_Class_Code => l_event_class_code,

Line 10637: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CANCEL_INVOICE';

10633: l_reverse_dist_count NUMBER;
10634: l_Error_Code ZX_ERRORS_GT.message_text%TYPE;
10635: BEGIN
10636:
10637: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CANCEL_INVOICE';
10638:
10639:
10640: l_tax_distributions_exist := tax_distributions_exist (p_invoice_id=>p_invoice_id);
10641:

Line 12405: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

12401: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12402: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
12403: END IF;
12404: -----------------------------------------------------------------
12405: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
12406: P_Invoice_Header_Rec => l_inv_header_rec
12407: ,P_Calling_Mode => p_calling_mode
12408: ,P_eTax_Already_called_flag => l_tax_already_calculated
12409: ,P_Event_Class_Code => l_event_class_code

Line 12439: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

12435: Print(l_api_name,l_debug_info);
12436: -----------------------------------------------------------------
12437: DELETE FROM ZX_TRANSACTION_LINES_GT;
12438:
12439: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
12440: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
12441:
12442: IF l_inv_header_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN /* if
12443: condition for bug 5967914 as we need tp pass party_site_id instead of

Line 12440: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;

12436: -----------------------------------------------------------------
12437: DELETE FROM ZX_TRANSACTION_LINES_GT;
12438:
12439: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
12440: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
12441:
12442: IF l_inv_header_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN /* if
12443: condition for bug 5967914 as we need tp pass party_site_id instead of
12444: vendor_site_id if invoice_type_lookup_code ='PAYMENT REQUEST' */

Line 12459: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

12455: ,p_calling_sequence => l_curr_calling_sequence);
12456: END IF;
12457:
12458:
12459: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
12460: P_Invoice_Header_Rec => l_inv_header_rec
12461: ,P_Calling_Mode => p_calling_mode
12462: ,P_Event_Class_Code => l_event_class_code
12463: ,P_Line_Number => p_invoice_line_number

Line 12615: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Delete_Tax_Distributions<-' ||

12611: l_api_name CONSTANT VARCHAR2(100) := 'Delete_Tax_distributions';
12612:
12613: Begin
12614:
12615: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Delete_Tax_Distributions<-' ||
12616: p_calling_sequence;
12617:
12618: IF NOT tax_distributions_exist
12619: (p_invoice_id => p_invoice_id) THEN

Line 12964: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate_Tax_Receipt_Match<-' ||

12960:
12961: l_api_name CONSTANT VARCHAR2(100) := 'Calculate_Tax_Receipt_Match';
12962:
12963: BEGIN
12964: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate_Tax_Receipt_Match<-' ||
12965: P_calling_sequence;
12966:
12967: -----------------------------------------------------------------
12968: l_debug_info := 'Step 1: Populating invoice header local record';

Line 13008: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

13004: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13005: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13006: END IF;
13007: -----------------------------------------------------------------
13008: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
13009: P_Invoice_Header_Rec => l_inv_header_rec,
13010: P_Calling_Mode => P_Calling_Mode,
13011: P_eTax_Already_called_flag => l_tax_already_calculated,
13012: P_Event_Class_Code => l_event_class_code,

Line 13028: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(

13024: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13025: END IF;
13026: -------------------------------------------------------------------
13027: IF (l_tax_already_calculated = 'Y') THEN
13028: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(
13029: P_Invoice_Header_Rec => l_inv_header_rec,
13030: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
13031: P_Event_Class_Code => l_event_class_code,
13032: P_All_Error_Messages => P_All_Error_Messages,

Line 13082: IF NOT(AP_ETAX_SERVICES_PKG.Return_Other_Charge_Lines(

13078: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13079: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13080: END IF;
13081: -----------------------------------------------------------------
13082: IF NOT(AP_ETAX_SERVICES_PKG.Return_Other_Charge_Lines(
13083: P_Invoice_header_rec => l_inv_header_rec,
13084: P_Error_Code => P_error_code,
13085: P_Calling_Sequence => l_curr_calling_sequence)) THEN
13086:

Line 13335: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',

13331: p_tax_classification_code => l_dflt_tax_class_code,
13332: p_allow_tax_code_override_flag => l_allow_tax_code_override,
13333: APPL_SHORT_NAME => 'SQLAP',
13334: FUNC_SHORT_NAME => 'NONE',
13335: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
13336: p_event_class_code => P_Event_Class_Code,
13337: p_entity_code => 'AP_INVOICES',
13338: p_application_id => 200,
13339: p_internal_organization_id => P_Invoice_Header_Rec.org_id);

Line 14130: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.'||l_api_name||'<-'||p_calling_sequence;

14126: l_debug_info VARCHAR2(1000);
14127:
14128: BEGIN
14129:
14130: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.'||l_api_name||'<-'||p_calling_sequence;
14131:
14132: IF NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(p_org_id) THEN
14133:
14134: ------------------------------------------------------------

Line 14132: IF NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(p_org_id) THEN

14128: BEGIN
14129:
14130: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.'||l_api_name||'<-'||p_calling_sequence;
14131:
14132: IF NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(p_org_id) THEN
14133:
14134: ------------------------------------------------------------
14135: l_debug_info := 'Cache Org Attributes';
14136: Print(l_api_name,l_debug_info);

Line 14140: INTO AP_ETAX_SERVICES_PKG.g_org_attributes(p_org_id).bill_to_location_id

14136: Print(l_api_name,l_debug_info);
14137: ------------------------------------------------------------
14138:
14139: SELECT location_id
14140: INTO AP_ETAX_SERVICES_PKG.g_org_attributes(p_org_id).bill_to_location_id
14141: FROM hr_all_organization_units
14142: WHERE organization_id = p_org_id;
14143:
14144: END IF;

Line 14146: IF NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(p_vendor_site_id) THEN

14142: WHERE organization_id = p_org_id;
14143:
14144: END IF;
14145:
14146: IF NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(p_vendor_site_id) THEN
14147:
14148: ------------------------------------------------------------
14149: l_debug_info := 'Cache Supplier Site Attributes';
14150: Print(l_api_name,l_debug_info);

Line 14156: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id

14152:
14153: IF l_payment_request_flag = 'Y' THEN --- if condition for bug 5967914
14154:
14155: SELECT hps.location_id
14156: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
14157: FROM hz_party_sites hps
14158: WHERE party_site_id = p_vendor_site_id;
14159:
14160: ELSE

Line 14163: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id

14159:
14160: ELSE
14161: SELECT location_id
14162: ,fob_lookup_code
14163: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
14164: ,AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).fob_lookup_code
14165: FROM ap_supplier_sites_all
14166: WHERE vendor_site_id = p_vendor_site_id;
14167: END IF;

Line 14164: ,AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).fob_lookup_code

14160: ELSE
14161: SELECT location_id
14162: ,fob_lookup_code
14163: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
14164: ,AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).fob_lookup_code
14165: FROM ap_supplier_sites_all
14166: WHERE vendor_site_id = p_vendor_site_id;
14167: END IF;
14168:

Line 14896: END AP_ETAX_SERVICES_PKG;

14892: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||p_api_name,p_debug_info);
14893: END IF;
14894: END Print;
14895:
14896: END AP_ETAX_SERVICES_PKG;