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.223.12020000.16 2013/04/16 15:08:26 nbshaik 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.223.12020000.16 2013/04/16 15:08:26 nbshaik 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 170: l_po_ship_to_org_id := AP_ETAX_SERVICES_PKG.g_fsp_attributes(p_org_id).inventory_organization_id;

166:
167: ELSIF (p_inventory_item_id is not null
168: AND p_org_id is not null) then
169:
170: l_po_ship_to_org_id := AP_ETAX_SERVICES_PKG.g_fsp_attributes(p_org_id).inventory_organization_id;
171:
172: ELSIF p_org_id is not null then
173:
174: l_po_ship_to_org_id := p_org_id;

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

322: l_count NUMBER;
323:
324: BEGIN
325:
326: --Print(l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
327: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
329: END IF;
330:

Line 328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');

324: BEGIN
325:
326: --Print(l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
327: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
329: END IF;
330:
331: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate<-' || P_calling_sequence;
332:

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

327: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
329: END IF;
330:
331: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate<-' || P_calling_sequence;
332:
333: l_validation_request_id := ap_approval_pkg.g_validation_request_id;
334:
335: g_invoices_to_process := 0;

Line 342: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(

338: --Bug9436217
339: IF P_Invoice_Id IS NULL THEN
340: --Bug9436217
341:
342: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(
343: p_validation_request_id => l_validation_request_id,
344: p_calling_mode => P_Calling_Mode,
345: p_error_code => p_error_code) THEN
346:

Line 445: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

441: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
442: END IF;
443: --Print(l_api_name,l_debug_info);
444: -----------------------------------------------------------------
445: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
446: P_Invoice_Header_Rec => l_inv_header_rec,
447: P_Calling_Mode => P_Calling_Mode,
448: P_eTax_Already_called_flag => l_tax_already_calculated,
449: P_Event_Class_Code => l_event_class_code,

Line 459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Populate_Headers_GT');

455: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
456: APP_EXCEPTION.RAISE_EXCEPTION;
457: ELSE
458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Populate_Headers_GT');
460: END IF;
461: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Populate_Headers_GT');
462: --Bug15914464: End
463: l_return_status := FALSE;

Line 461: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Populate_Headers_GT');

457: ELSE
458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Populate_Headers_GT');
460: END IF;
461: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Populate_Headers_GT');
462: --Bug15914464: End
463: l_return_status := FALSE;
464: END IF; --Bug15914464
465: END IF;

Line 543: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

539: DELETE FROM ZX_TRANSACTION_LINES_GT;
540: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
541: DELETE FROM ZX_TRX_TAX_LINK_GT;
542:
543: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
544: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
545:
546:
547: OPEN C_SELECTED_INVOICES;

Line 544: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;

540: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
541: DELETE FROM ZX_TRX_TAX_LINK_GT;
542:
543: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
544: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
545:
546:
547: OPEN C_SELECTED_INVOICES;
548: LOOP

Line 621: IF (NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(l_inv_header_rec.party_site_id) OR

617: vendor_site_id if invoice_type_lookup_code ='PAYMENT REQUEST' */
618:
619: l_payment_request_flag :='Y'; --Bug13899981
620:
621: IF (NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(l_inv_header_rec.party_site_id) OR
622: NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(l_inv_header_rec.org_id)) THEN
623:
624:
625: -- Bug 9777752 : Added Begin - Exception - End block

Line 622: NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(l_inv_header_rec.org_id)) THEN

618:
619: l_payment_request_flag :='Y'; --Bug13899981
620:
621: IF (NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(l_inv_header_rec.party_site_id) OR
622: NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(l_inv_header_rec.org_id)) THEN
623:
624:
625: -- Bug 9777752 : Added Begin - Exception - End block
626: BEGIN

Line 640: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');

636: ELSE
637:
638: --Bug15914464: Start
639: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
640: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
641: END IF;
642: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
643: --Bug15914464: End
644:

Line 642: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');

638: --Bug15914464: Start
639: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
640: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
641: END IF;
642: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
643: --Bug15914464: End
644:
645: RETURN FALSE;
646: END IF;

Line 652: IF (NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(l_inv_header_rec.vendor_site_id) OR

648: END IF;
649: ELSE
650:
651: l_payment_request_flag :='N'; --Bug13899981
652: IF (NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(l_inv_header_rec.vendor_site_id) OR
653: NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(l_inv_header_rec.org_id)) THEN
654:
655:
656: -- Bug 9777752 : Added Begin - Exception - End block

Line 653: NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(l_inv_header_rec.org_id)) THEN

649: ELSE
650:
651: l_payment_request_flag :='N'; --Bug13899981
652: IF (NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(l_inv_header_rec.vendor_site_id) OR
653: NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(l_inv_header_rec.org_id)) THEN
654:
655:
656: -- Bug 9777752 : Added Begin - Exception - End block
657: BEGIN

Line 670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');

666: APP_EXCEPTION.RAISE_EXCEPTION;
667: ELSE
668: --Bug15914464: Start
669: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
671: END IF;
672: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
673: --Bug15914464: End
674: RETURN FALSE;

Line 672: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');

668: --Bug15914464: Start
669: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
671: END IF;
672: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults');
673: --Bug15914464: End
674: RETURN FALSE;
675: END IF;
676: END ;

Line 782: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(

778: END IF;
779: --Print(l_api_name,l_debug_info);
780: -----------------------------------------------------------------
781: --Bug7592845
782: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(
783: P_Invoice_Header_Rec => l_inv_header_rec,
784: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
785: P_Event_Class_Code => l_event_class_code,
786: P_All_Error_Messages => P_All_Error_Messages,

Line 795: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions');

791: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
792: APP_EXCEPTION.RAISE_EXCEPTION;
793: ELSE
794: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions');
796: END IF;
797: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions');
798: --Bug15914464: End
799: l_return_status := FALSE;

Line 797: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions');

793: ELSE
794: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error in AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions');
796: END IF;
797: Insert into ap_errors_gt(invoice_id , message_text) values(l_inv_header_rec.invoice_id , 'Error in AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions');
798: --Bug15914464: End
799: l_return_status := FALSE;
800: END IF; --Bug15914464
801: END IF;

Line 821: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

817: END IF;
818: --Print(l_api_name,l_debug_info);
819: -----------------------------------------------------------------
820: IF (l_return_status = TRUE) THEN
821: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
822: P_Invoice_Header_Rec => l_inv_header_rec,
823: P_Calling_Mode => P_Calling_Mode,
824: P_Event_Class_Code => l_event_class_code,
825: P_Line_Number => P_Line_Number,

Line 854: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

850: END IF;
851: --Print(l_api_name,l_debug_info);
852: -----------------------------------------------------------------
853: IF (l_return_status = TRUE) THEN
854: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
855: P_Invoice_Header_Rec => l_inv_header_rec,
856: P_Calling_Mode => P_Calling_Mode,
857: P_Event_Class_Code => l_event_class_code,
858: P_Line_Number => P_Line_Number,

Line 879: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(

875: END IF;
876: --Print(l_api_name,l_debug_info);
877: -----------------------------------------------------------------
878: IF (l_return_status = TRUE) THEN
879: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(
880: P_Invoice_Header_Rec => l_inv_header_rec,
881: P_Calling_Mode => P_Calling_Mode,
882: P_Event_Class_Code => l_event_class_code,
883: P_Tax_only_Flag => 'N',

Line 914: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(

910: END IF;
911: --Print(l_api_name,l_debug_info);
912: -----------------------------------------------------------------
913: IF (l_return_status = TRUE) THEN
914: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(
915: P_Invoice_Header_Rec => l_inv_header_rec,
916: P_Calling_Mode => P_Calling_Mode,
917: P_Event_Class_Code => l_event_class_code,
918: P_Tax_only_Flag => 'Y',

Line 1067: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

1063: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
1064: FETCH Invoice_Header INTO l_inv_header_rec;
1065: CLOSE Invoice_Header;
1066:
1067: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
1068: P_Invoice_header_rec => l_inv_header_rec,
1069: P_Calling_Mode => P_Calling_Mode,
1070: P_All_Error_Messages => P_All_Error_Messages,
1071: P_Error_Code => P_error_code,

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

1188:
1189: BEGIN
1190:
1191:
1192: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate_Import<-' ||
1193: P_calling_sequence;
1194:
1195: -----------------------------------------------------------------
1196: l_debug_info := 'Step 1: Populating invoice header local record';

Line 1278: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

1274: END IF;
1275: --Print(l_api_name, l_debug_info);
1276: -----------------------------------------------------------------
1277:
1278: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
1279: P_Invoice_Header_Rec => l_inv_header_rec,
1280: P_Calling_Mode => 'CALCULATE',
1281: P_eTax_Already_called_flag => 'Y',
1282: P_Event_Class_Code => l_event_class_code,

Line 1328: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

1324: END IF;
1325: --Print(l_api_name, l_debug_info);
1326: -----------------------------------------------------------------
1327:
1328: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
1329: P_Invoice_Header_Rec => l_inv_header_rec,
1330: P_Calling_Mode => 'CALCULATE',
1331: P_Event_Class_Code => l_event_class_code,
1332: P_Error_Code => P_error_code,

Line 1425: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

1421: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1422: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1423: END IF;
1424: -----------------------------------------------------------------
1425: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
1426: P_Invoice_header_rec => l_inv_header_rec,
1427: P_Calling_Mode => P_Calling_Mode,
1428: P_All_Error_Messages => P_All_Error_Messages,
1429: P_Error_Code => P_error_code,

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

1704: --Bug9436217
1705:
1706: BEGIN
1707:
1708: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Distribute<-' ||
1709: P_calling_sequence;
1710:
1711: --Bug9436217
1712:

Line 1768: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

1764: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1765: END IF;
1766: --Print(l_api_name,l_debug_info);
1767: -----------------------------------------------------------------
1768: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
1769: P_Invoice_Header_Rec => l_inv_header_rec,
1770: P_Calling_Mode => P_Calling_Mode,
1771: P_eTax_Already_called_flag => l_tax_already_distributed,
1772: P_Event_Class_Code => l_event_class_code,

Line 1791: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(

1787: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1788: END IF;
1789: --Print(l_api_name,l_debug_info);
1790: -----------------------------------------------------------------
1791: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(
1792: p_validation_request_id => ap_approval_pkg.g_validation_request_id,
1793: p_calling_mode => p_calling_mode,
1794: p_error_code => p_error_code) THEN
1795:

Line 1983: IF NOT (AP_ETAX_SERVICES_PKG.Populate_Distributions_GT(

1979: -----------------------------------------------------------------
1980: IF (l_return_status = TRUE
1981: and l_inv_dist_list.count > 0) THEN
1982:
1983: IF NOT (AP_ETAX_SERVICES_PKG.Populate_Distributions_GT(
1984: P_Invoice_Header_Rec => l_inv_header_rec,
1985: P_Calling_Mode => P_Calling_Mode,
1986: P_Event_Class_Code => l_event_class_code,
1987: P_Event_Type_Code => l_event_type_code,

Line 2076: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

2072: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2073: END IF;
2074: --Print(l_api_name,l_debug_info);
2075: -----------------------------------------------------------------
2076: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
2077: P_Invoice_header_rec => l_inv_header_rec,
2078: P_Calling_Mode => P_Calling_Mode,
2079: P_All_Error_Messages => P_All_Error_Messages,
2080: P_Error_Code => P_error_code,

Line 2143: IF NOT(AP_ETAX_SERVICES_PKG.Update_Distributions(

2139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2140: END IF;
2141: --Print(l_api_name,l_debug_info);
2142: -----------------------------------------------------------------
2143: IF NOT(AP_ETAX_SERVICES_PKG.Update_Distributions(
2144: P_Invoice_header_rec => l_inv_header_rec,
2145: P_Calling_Mode => P_Calling_Mode,
2146: P_All_Error_Messages => P_All_Error_Messages,
2147: P_Error_Code => P_error_code,

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

2245: ai.exchange_rate IS NOT NULL));
2246:
2247: BEGIN
2248:
2249: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Distribute_Import<-' ||
2250: P_calling_sequence;
2251:
2252: --Bug14779241: Start
2253:

Line 2318: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

2314: END IF;
2315: -----------------------------------------------------------------
2316: --print(l_api_name,l_debug_info); -- bug 6321366
2317:
2318: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
2319: P_Invoice_header_rec => l_inv_header_rec,
2320: P_Calling_Mode => P_Calling_Mode,
2321: P_All_Error_Messages => P_All_Error_Messages,
2322: P_Error_Code => P_error_code,

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

2431: AND summary_tax_line_id IS NULL;
2432:
2433: BEGIN
2434:
2435: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Import_Interface<-' ||
2436: P_calling_sequence;
2437:
2438: -----------------------------------------------------------------
2439: l_debug_info := 'Step 1: Populating invoice header local record';

Line 2499: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

2495: END IF;
2496: --Print(l_api_name, l_debug_info);
2497: -----------------------------------------------------------------
2498:
2499: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
2500: P_Invoice_Header_Rec => l_inv_header_rec,
2501: P_Calling_Mode => 'CALCULATE',
2502: P_eTax_Already_called_flag => 'N',
2503: P_Event_Class_Code => l_event_class_code,

Line 2550: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(

2546: END IF;
2547: --Print(l_api_name, l_debug_info);
2548: -----------------------------------------------------------------
2549:
2550: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(
2551: P_Invoice_Header_Rec => l_inv_header_rec,
2552: P_Calling_Mode => P_Calling_Mode,
2553: P_Event_Class_Code => l_event_class_code,
2554: P_Tax_only_Flag => 'Y',

Line 2676: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

2672: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2673: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2674: END IF;
2675: -----------------------------------------------------------------
2676: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
2677: P_Invoice_header_rec => l_inv_header_rec,
2678: P_Calling_Mode => P_Calling_Mode,
2679: P_All_Error_Messages => P_All_Error_Messages,
2680: P_Error_Code => P_error_code,

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

2789:
2790: l_api_name CONSTANT VARCHAR2(100) := 'Reverse_Invoice';
2791:
2792: BEGIN
2793: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Reverse_Invoice<-' ||
2794: P_calling_sequence;
2795:
2796: -----------------------------------------------------------------
2797: l_debug_info := 'Step 1: Populating crediting invoice header';

Line 3046: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

3042: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3043: END IF;
3044: --Print(l_api_name,l_debug_info);
3045: -----------------------------------------------------------------
3046: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
3047: P_Invoice_Header_Rec => l_inv_header_rec,
3048: P_Calling_Mode => P_Calling_Mode,
3049: P_eTax_Already_called_flag => l_tax_already_distributed,
3050: P_Event_Class_Code => l_event_class_code,

Line 3058: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

3054:
3055: l_return_status := FALSE;
3056: END IF;
3057:
3058: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
3059: P_Invoice_header_rec => l_inv_header_rec,
3060: P_Calling_Mode => P_Calling_Mode,
3061: P_All_Error_Messages => P_All_Error_Messages,
3062: P_Error_Code => P_error_code,

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

3190:
3191: l_api_name CONSTANT VARCHAR2(100) := 'Override_Tax';
3192:
3193: BEGIN
3194: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Override_Tax<-' ||
3195: P_calling_sequence;
3196:
3197: IF (P_Override_Status = 'SYNCHRONIZE') THEN
3198: -----------------------------------------------------------------

Line 3364: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

3360: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3361: END IF;
3362: -----------------------------------------------------------------
3363:
3364: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
3365: P_Invoice_Header_Rec => l_inv_header_rec,
3366: P_Calling_Mode => P_Calling_Mode,
3367: P_eTax_Already_called_flag => NULL,
3368: P_Event_Class_Code => l_event_class_code,

Line 3385: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

3381: --Print(l_api_name,l_debug_info);
3382: -----------------------------------------------------------------
3383: DELETE FROM ZX_TRANSACTION_LINES_GT;
3384:
3385: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
3386: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
3387:
3388: IF l_inv_header_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN /* if
3389: condition for bug 5967914 as we need tp pass party_site_id instead of

Line 3386: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;

3382: -----------------------------------------------------------------
3383: DELETE FROM ZX_TRANSACTION_LINES_GT;
3384:
3385: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
3386: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
3387:
3388: IF l_inv_header_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN /* if
3389: condition for bug 5967914 as we need tp pass party_site_id instead of
3390: vendor_site_id if invoice_type_lookup_code ='PAYMENT REQUEST' */

Line 3411: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

3407: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3408: END IF;
3409: -----------------------------------------------------------------
3410: IF ( l_return_status = TRUE ) THEN
3411: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
3412: P_Invoice_Header_Rec => l_inv_header_rec,
3413: P_Calling_Mode => P_Calling_Mode,
3414: P_Event_Class_Code => l_event_class_code,
3415: P_Error_Code => P_error_code,

Line 3466: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

3462: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3463: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3464: END IF;
3465: -----------------------------------------------------------------
3466: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
3467: P_Invoice_header_rec => l_inv_header_rec,
3468: P_Calling_Mode => P_Calling_Mode,
3469: P_All_Error_Messages => P_All_Error_Messages,
3470: P_Error_Code => P_error_code,

Line 3503: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(

3499: END IF;
3500: -----------------------------------------------------------------
3501: IF ( l_return_status = TRUE ) THEN -- Bug 9383712
3502: --Bug7592845
3503: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(
3504: P_Invoice_Header_Rec => l_inv_header_rec,
3505: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
3506: P_Event_Class_Code => l_event_class_code,
3507: P_All_Error_Messages => P_All_Error_Messages,

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

3690: l_return_status BOOLEAN := TRUE;
3691: l_api_name varchar2(30) := 'Override_recovery';
3692:
3693: BEGIN
3694: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Override_Recovery<-' ||
3695: P_calling_sequence;
3696:
3697: -----------------------------------------------------------------
3698: l_debug_info := 'Step 1: Populating invoice header local record';

Line 3746: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

3742: l_return_status := FALSE;
3743: END IF;
3744: END IF;
3745: /* added for 6157052 we need to populate zx_headers_gt in this case.*/
3746: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
3747: P_Invoice_Header_Rec => l_inv_header_rec,
3748: P_Calling_Mode => P_Calling_Mode,
3749: P_eTax_Already_called_flag => 'Y',
3750: P_Event_Class_Code => l_event_class_code,

Line 3764: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_Distributions(

3760: -- are freezing the distributions and after that we are not supposed to change
3761: --the distributons.But here we need to change the tax distributions as we are
3762: --changing the ecovery rate .so we need not make this callhere.
3763: /*
3764: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_Distributions(
3765: P_Invoice_Header_Rec => l_inv_header_rec,
3766: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
3767: P_Event_Class_Code => l_event_class_code,
3768: P_All_Error_Messages => P_All_Error_Messages,

Line 3832: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

3828: -- Debug messages added for 6321366
3829: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3830: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
3831: END IF;
3832: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
3833: P_Invoice_header_rec => l_inv_header_rec,
3834: P_Calling_Mode => P_Calling_Mode,
3835: P_All_Error_Messages => P_All_Error_Messages,
3836: P_Error_Code => P_error_code,

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

3971:
3972: l_err varchar2(2000); --10140354
3973:
3974: BEGIN
3975: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Freeze_Itm_Distributions<-' ||
3976: P_calling_sequence;
3977: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3978: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_curr_calling_sequence);
3979: END IF;

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

4419:
4420: l_api_name CONSTANT VARCHAR2(100) := 'Freeze_Distributions';
4421:
4422: BEGIN
4423: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Freeze_Distributions<-' ||
4424: P_calling_sequence;
4425:
4426: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4427: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

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

4861: l_return_status BOOLEAN := TRUE;
4862: l_api_name VARCHAR2(30) := 'global_document_update'; -- bug 6321366
4863: BEGIN
4864:
4865: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Global_Document_Update<-' ||
4866: P_calling_sequence;
4867:
4868: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4869: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_curr_calling_sequence);

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

4987: l_api_name VARCHAR2(30) := 'Release_Tax_Holds';
4988:
4989: BEGIN
4990:
4991: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Release_Tax_Holds<-' ||
4992: P_calling_sequence;
4993:
4994: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4995: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

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

5212:
5213: l_return_status BOOLEAN := TRUE;
5214:
5215: BEGIN
5216: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Mark_Tax_Lines_Deleted<-' ||
5217: P_calling_sequence;
5218:
5219: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5220: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

Line 5332: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

5328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5329: END IF;
5330: --Print(l_api_name, l_debug_info);
5331: -----------------------------------------------------------------
5332: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(
5333: P_Invoice_header_rec => l_inv_header_rec,
5334: P_Calling_Mode => 'DELETE TAX LINE',
5335: P_All_Error_Messages => P_All_Error_Messages,
5336: P_Error_Code => P_error_code,

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

5505:
5506:
5507: BEGIN
5508:
5509: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Validate_Invoice<-' ||
5510: P_calling_sequence;
5511:
5512: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

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

5824: l_cnt number;
5825: --bug 15862708 ends
5826: BEGIN
5827:
5828: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Validate_Default_Import<-'
5829: ||P_calling_sequence;
5830:
5831: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5832: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

Line 5856: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT(

5852: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5853: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5854: END IF;
5855: -----------------------------------------------------------------
5856: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT(
5857: P_Invoice_Header_Rec => P_Invoice_Rec,
5858: P_Calling_Mode => P_Calling_Mode,
5859: P_Event_Class_Code => l_event_class_code,
5860: P_Event_Type_Code => l_event_type_code,

Line 5877: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT(

5873: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5874: END IF;
5875: -----------------------------------------------------------------
5876: IF ( l_return_status = TRUE ) THEN
5877: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT(
5878: P_Invoice_Header_Rec => P_Invoice_Rec,
5879: P_Inv_Line_List => p_invoice_lines_tabl,
5880: P_Calling_Mode => P_Calling_Mode,
5881: P_Event_Class_Code => l_event_class_code,

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

6102: l_return_status BOOLEAN := TRUE;
6103: l_api_name VARCHAR2(30) := 'Populate_headers_gt'; --bug 6321366
6104: BEGIN
6105:
6106: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Headers_GT<-' ||
6107: P_calling_sequence;
6108:
6109: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6110: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

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

6531: l_api_name VARCHAR2(30) := 'populate_header_import_gt';
6532:
6533: BEGIN
6534:
6535: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT<-'||
6536: P_calling_sequence;
6537:
6538:
6539: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

6975:
6976: l_err varchar2(2000); --10140354
6977: BEGIN
6978:
6979: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_GT<-' ||
6980: P_calling_sequence;
6981:
6982: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6983: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

Line 7037: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes

7033: END IF;
7034: --Print(l_api_name,l_debug_info);
7035: ----------------------------------------------------------------------
7036:
7037: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
7038: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
7039: END IF;
7040:
7041: IF l_payment_request_flag ='Y' THEN ---if condition added for bug 5967914

Line 7051: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes

7047: END IF;
7048: --Print(l_api_name,l_debug_info);
7049: ----------------------------------------------------------------------
7050:
7051: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
7052: (p_invoice_header_rec.party_site_id).location_id;
7053: ELSE
7054:
7055: ----------------------------------------------------------------------

Line 7063: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes

7059: END IF;
7060: --Print(l_api_name,l_debug_info);
7061: ----------------------------------------------------------------------
7062:
7063: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
7064: (p_invoice_header_rec.vendor_site_id).location_id;
7065: END IF;
7066:
7067:

Line 7077: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes

7073: --Print(l_api_name,l_debug_info);
7074: ----------------------------------------------------------------------
7075: --Bug13899981 Added Debug Messages
7076:
7077: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes
7078: (p_invoice_header_rec.org_id).bill_to_location_id;
7079:
7080: ----------------------------------------------------------------------
7081: l_debug_info := 'Go through taxable lines';

Line 7858: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',

7854: p_tax_classification_code => l_dflt_tax_class_code,
7855: p_allow_tax_code_override_flag => l_allow_tax_code_override,
7856: APPL_SHORT_NAME => 'SQLAP',
7857: FUNC_SHORT_NAME => 'NONE',
7858: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
7859: p_event_class_code => P_Event_Class_Code,
7860: p_entity_code => 'AP_INVOICES',
7861: p_application_id => 200,
7862: p_internal_organization_id => P_Invoice_Header_Rec.org_id);

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

8245: l_default_ccid AP_INVOICE_LINES_INTERFACE.default_dist_ccid%TYPE; --Bug9841978
8246:
8247: BEGIN
8248:
8249: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT<-' ||
8250: P_calling_sequence;
8251: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8252: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
8253: END IF;

Line 8757: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',

8753: p_tax_classification_code => l_dflt_tax_class_code,
8754: p_allow_tax_code_override_flag => l_allow_tax_code_override,
8755: APPL_SHORT_NAME => 'SQLAP',
8756: FUNC_SHORT_NAME => 'NONE',
8757: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
8758: p_event_class_code => p_event_class_code,
8759: p_entity_code => 'AP_INVOICES',
8760: p_application_id => 200,
8761: p_internal_organization_id => p_invoice_header_rec.org_id);

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

10058:
10059: l_err varchar2(2000); --bug10140354
10060: BEGIN
10061:
10062: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT<-'||
10063: P_calling_sequence;
10064:
10065: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10066: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

Line 10070: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes

10066: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
10067: END IF;
10068:
10069:
10070: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
10071: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
10072: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
10073: (p_invoice_header_rec.vendor_site_id).location_id;
10074: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes

Line 10072: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes

10068:
10069:
10070: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
10071: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
10072: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
10073: (p_invoice_header_rec.vendor_site_id).location_id;
10074: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes
10075: (p_invoice_header_rec.org_id).bill_to_location_id;
10076:

Line 10074: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes

10070: l_fob_point := AP_ETAX_SERVICES_PKG.g_site_attributes
10071: (p_invoice_header_rec.vendor_site_id).fob_lookup_code;
10072: l_location_id := AP_ETAX_SERVICES_PKG.g_site_attributes
10073: (p_invoice_header_rec.vendor_site_id).location_id;
10074: l_bill_to_location_id := AP_ETAX_SERVICES_PKG.g_org_attributes
10075: (p_invoice_header_rec.org_id).bill_to_location_id;
10076:
10077: IF (P_Tax_only_Flag = 'N') THEN
10078:

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

11080: --bug10621602 ends
11081:
11082: BEGIN
11083:
11084: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Distributions_GT<-'||
11085: P_calling_sequence;
11086:
11087: IF (l_inv_dist_list.COUNT > 0) THEN
11088:

Line 11437: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retainage_rate :=

11433:
11434: trans_dists(j).char5 := l_retainage_rate * l_retainage_release_factor ;
11435:
11436:
11437: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retainage_rate :=
11438: l_retainage_rate * l_retainage_release_factor;
11439: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).amount := l_amount;
11440: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_amount := l_retained_amount;
11441: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).related_retainage_dist_id :=

Line 11439: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).amount := l_amount;

11435:
11436:
11437: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retainage_rate :=
11438: l_retainage_rate * l_retainage_release_factor;
11439: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).amount := l_amount;
11440: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_amount := l_retained_amount;
11441: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).related_retainage_dist_id :=
11442: l_inv_dist_list(i).related_retainage_dist_id;
11443: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_invoice_dist_id :=

Line 11440: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_amount := l_retained_amount;

11436:
11437: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retainage_rate :=
11438: l_retainage_rate * l_retainage_release_factor;
11439: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).amount := l_amount;
11440: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_amount := l_retained_amount;
11441: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).related_retainage_dist_id :=
11442: l_inv_dist_list(i).related_retainage_dist_id;
11443: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_invoice_dist_id :=
11444: l_inv_dist_list(i).retained_invoice_dist_id;

Line 11441: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).related_retainage_dist_id :=

11437: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retainage_rate :=
11438: l_retainage_rate * l_retainage_release_factor;
11439: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).amount := l_amount;
11440: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_amount := l_retained_amount;
11441: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).related_retainage_dist_id :=
11442: l_inv_dist_list(i).related_retainage_dist_id;
11443: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_invoice_dist_id :=
11444: l_inv_dist_list(i).retained_invoice_dist_id;
11445: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).quantity_invoiced := l_quantity_invoiced;

Line 11443: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_invoice_dist_id :=

11439: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).amount := l_amount;
11440: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_amount := l_retained_amount;
11441: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).related_retainage_dist_id :=
11442: l_inv_dist_list(i).related_retainage_dist_id;
11443: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_invoice_dist_id :=
11444: l_inv_dist_list(i).retained_invoice_dist_id;
11445: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).quantity_invoiced := l_quantity_invoiced;
11446: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).unit_price := l_unit_price;
11447:

Line 11445: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).quantity_invoiced := l_quantity_invoiced;

11441: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).related_retainage_dist_id :=
11442: l_inv_dist_list(i).related_retainage_dist_id;
11443: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_invoice_dist_id :=
11444: l_inv_dist_list(i).retained_invoice_dist_id;
11445: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).quantity_invoiced := l_quantity_invoiced;
11446: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).unit_price := l_unit_price;
11447:
11448:
11449: l_debug_info := 'Populating the char4 and char5 value for retainage invoice as '

Line 11446: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).unit_price := l_unit_price;

11442: l_inv_dist_list(i).related_retainage_dist_id;
11443: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).retained_invoice_dist_id :=
11444: l_inv_dist_list(i).retained_invoice_dist_id;
11445: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).quantity_invoiced := l_quantity_invoiced;
11446: ap_etax_services_pkg.ret_dists(l_inv_dist_list(i).invoice_distribution_id).unit_price := l_unit_price;
11447:
11448:
11449: l_debug_info := 'Populating the char4 and char5 value for retainage invoice as '
11450: || trans_dists(j).char4 || ' and ' || trans_dists(j).char5;

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

11675: l_err varchar2(2000); --bug10140354
11676: BEGIN
11677:
11678: l_curr_calling_sequence :=
11679: 'AP_ETAX_SERVICES_PKG.Update_AP<-'||P_calling_sequence;
11680:
11681: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
11683: END IF;

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

11883: AND NVL(zdl.reporting_only_flag, 'N') = 'N';
11884:
11885: BEGIN
11886:
11887: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CALCULATE_QUOTE<-' || P_calling_sequence;
11888:
11889: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
11890: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate_Quote (+)');
11891: END IF;

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

11886:
11887: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CALCULATE_QUOTE<-' || P_calling_sequence;
11888:
11889: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
11890: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ETAX_SERVICES_PKG.Calculate_Quote (+)');
11891: END IF;
11892:
11893: ----------------------------------------------------------------------
11894: l_debug_info := 'Get location_id for vendor site';

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

11929:
11930: END IF;
11931:
11932: -------------------------------------------------------------------------
11933: l_debug_info := 'Step 1: Call AP_ETAX_SERVICES_PKG.Populate_Headers_GT';
11934: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
11936: END IF;
11937: -------------------------------------------------------------------------

Line 11938: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

11934: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
11936: END IF;
11937: -------------------------------------------------------------------------
11938: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
11939: P_Invoice_Header_Rec => P_Invoice_Header_Rec,
11940: P_Calling_Mode => P_Calling_Mode,
11941: P_eTax_Already_called_flag => l_tax_already_calculated,
11942: P_Event_Class_Code => l_event_class_code,

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

13447: -- Bug 10140793 - End
13448:
13449: BEGIN
13450:
13451: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.CANCEL_INVOICE';
13452:
13453: /*Added the following delete statements for bug 12418361 -Begin*/
13454: l_debug_info := 'Purge staging tables of ZX';
13455: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 13465: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

13461: DELETE zx_import_tax_lines_gt;
13462: DELETE zx_trx_tax_link_gt;
13463: DELETE zx_reverse_dist_gt;
13464:
13465: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
13466: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
13467:
13468: /*Added the following delete statements for bug 12418361 -End*/
13469:

Line 13466: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;

13462: DELETE zx_trx_tax_link_gt;
13463: DELETE zx_reverse_dist_gt;
13464:
13465: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
13466: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
13467:
13468: /*Added the following delete statements for bug 12418361 -End*/
13469:
13470:

Line 13926: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

13922: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13923: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13924: END IF;
13925: ----------------------------------------------------------------
13926: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
13927: P_Invoice_Header_Rec => l_inv_header_rec,
13928: P_Calling_Mode => P_Calling_Mode,
13929: P_eTax_Already_called_flag => l_tax_already_calculated,
13930: P_Event_Class_Code => l_event_class_code,

Line 13967: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

13963: END IF;
13964: -----------------------------------------------------------------
13965: IF (l_return_status = TRUE) THEN
13966:
13967: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
13968: P_Invoice_Header_Rec => l_inv_header_rec,
13969: P_Calling_Mode => P_Calling_Mode,
13970: P_Event_Class_Code => l_event_class_code,
13971: P_Line_Number => p_line_number,

Line 13988: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(

13984: FETCH Invoice_Tax_OnlyLines
13985: BULK COLLECT INTO l_inv_tax_list;
13986: CLOSE Invoice_Tax_OnlyLines;
13987: END;
13988: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Tax_Lines_GT(
13989: P_Invoice_Header_Rec => l_inv_header_rec,
13990: P_Calling_Mode => P_Calling_Mode,
13991: P_Event_Class_Code => l_event_class_code,
13992: P_Tax_only_Flag => 'Y',

Line 15961: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

15957: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15959: END IF;
15960: -----------------------------------------------------------------
15961: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
15962: P_Invoice_Header_Rec => l_inv_header_rec
15963: ,P_Calling_Mode => p_calling_mode
15964: ,P_eTax_Already_called_flag => l_tax_already_calculated
15965: ,P_Event_Class_Code => l_event_class_code

Line 15998: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

15994: --Print(l_api_name,l_debug_info);
15995: -----------------------------------------------------------------
15996: DELETE FROM ZX_TRANSACTION_LINES_GT;
15997:
15998: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
15999: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
16000:
16001: -----------------------------------------------------------------
16002: l_debug_info := 'Cache Line Defaults :' ||

Line 15999: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;

15995: -----------------------------------------------------------------
15996: DELETE FROM ZX_TRANSACTION_LINES_GT;
15997:
15998: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
15999: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
16000:
16001: -----------------------------------------------------------------
16002: l_debug_info := 'Cache Line Defaults :' ||
16003: ' Invoice Type Lookup Code = ' || l_inv_header_rec.invoice_type_lookup_code ||

Line 16030: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(

16026: ,p_calling_sequence => l_curr_calling_sequence);
16027: END IF;
16028:
16029:
16030: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Lines_GT(
16031: P_Invoice_Header_Rec => l_inv_header_rec
16032: ,P_Calling_Mode => p_calling_mode
16033: ,P_Event_Class_Code => l_event_class_code
16034: ,P_Line_Number => p_invoice_line_number

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

16173: l_api_name CONSTANT VARCHAR2(100) := 'Delete_Tax_distributions';
16174:
16175: Begin
16176:
16177: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Delete_Tax_Distributions<-' ||
16178: p_calling_sequence;
16179:
16180: IF NOT tax_distributions_exist
16181: (p_invoice_id => p_invoice_id) THEN

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

16589:
16590: l_api_name CONSTANT VARCHAR2(100) := 'Calculate_Tax_Receipt_Match';
16591:
16592: BEGIN
16593: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate_Tax_Receipt_Match<-' ||
16594: P_calling_sequence;
16595:
16596: -----------------------------------------------------------------
16597: l_debug_info := 'Step 1: Populating invoice header local record';

Line 16637: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(

16633: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
16634: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16635: END IF;
16636: -----------------------------------------------------------------
16637: IF NOT(AP_ETAX_SERVICES_PKG.Populate_Headers_GT(
16638: P_Invoice_Header_Rec => l_inv_header_rec,
16639: P_Calling_Mode => P_Calling_Mode,
16640: P_eTax_Already_called_flag => l_tax_already_calculated,
16641: P_Event_Class_Code => l_event_class_code,

Line 16657: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(

16653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16654: END IF;
16655: -------------------------------------------------------------------
16656: IF (l_tax_already_calculated = 'Y') THEN
16657: IF NOT(AP_ETAX_SERVICES_PKG.Freeze_itm_Distributions(
16658: P_Invoice_Header_Rec => l_inv_header_rec,
16659: P_Calling_Mode => 'FREEZE DISTRIBUTIONS',
16660: P_Event_Class_Code => l_event_class_code,
16661: P_All_Error_Messages => P_All_Error_Messages,

Line 16711: IF NOT(AP_ETAX_SERVICES_PKG.Return_Other_Charge_Lines(

16707: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
16708: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16709: END IF;
16710: -----------------------------------------------------------------
16711: IF NOT(AP_ETAX_SERVICES_PKG.Return_Other_Charge_Lines(
16712: P_Invoice_header_rec => l_inv_header_rec,
16713: P_Error_Code => P_error_code,
16714: P_Calling_Sequence => l_curr_calling_sequence)) THEN
16715:

Line 16974: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',

16970: p_tax_classification_code => l_dflt_tax_class_code,
16971: p_allow_tax_code_override_flag => l_allow_tax_code_override,
16972: APPL_SHORT_NAME => 'SQLAP',
16973: FUNC_SHORT_NAME => 'NONE',
16974: p_calling_sequence => 'AP_ETAX_SERVICES_PKG',
16975: p_event_class_code => P_Event_Class_Code,
16976: p_entity_code => 'AP_INVOICES',
16977: p_application_id => 200,
16978: p_internal_organization_id => P_Invoice_Header_Rec.org_id);

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

17927: l_debug_info VARCHAR2(1000);
17928:
17929: BEGIN
17930:
17931: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.'||l_api_name||'<-'||p_calling_sequence;
17932:
17933: IF NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(p_org_id) THEN
17934:
17935: ------------------------------------------------------------

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

17929: BEGIN
17930:
17931: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.'||l_api_name||'<-'||p_calling_sequence;
17932:
17933: IF NOT AP_ETAX_SERVICES_PKG.g_org_attributes.exists(p_org_id) THEN
17934:
17935: ------------------------------------------------------------
17936: l_debug_info := 'Cache Org Attributes';
17937: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

17940: --Print(l_api_name,l_debug_info);
17941: ------------------------------------------------------------
17942:
17943: SELECT location_id
17944: INTO AP_ETAX_SERVICES_PKG.g_org_attributes(p_org_id).bill_to_location_id
17945: FROM hr_all_organization_units
17946: WHERE organization_id = p_org_id;
17947:
17948: END IF;

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

17946: WHERE organization_id = p_org_id;
17947:
17948: END IF;
17949:
17950: IF NOT AP_ETAX_SERVICES_PKG.g_site_attributes.exists(p_vendor_site_id) THEN
17951:
17952: ------------------------------------------------------------
17953: l_debug_info := 'Cache Supplier Site Attributes';
17954: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

17976:
17977: IF l_payment_request_flag = 'Y' THEN --- if condition for bug 5967914
17978:
17979: SELECT hps.location_id
17980: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
17981: FROM hz_party_sites hps
17982: WHERE party_site_id = p_vendor_site_id;
17983:
17984: ELSE

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

17983:
17984: ELSE
17985: SELECT location_id
17986: ,fob_lookup_code
17987: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
17988: ,AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).fob_lookup_code
17989: FROM ap_supplier_sites_all
17990: WHERE vendor_site_id = p_vendor_site_id;
17991: END IF;

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

17984: ELSE
17985: SELECT location_id
17986: ,fob_lookup_code
17987: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
17988: ,AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).fob_lookup_code
17989: FROM ap_supplier_sites_all
17990: WHERE vendor_site_id = p_vendor_site_id;
17991: END IF;
17992:

Line 18823: --Print(l_api_name,'AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq');

18819: AND ai.doc_sequence_id=doc.doc_sequence_id (+);
18820:
18821: BEGIN
18822:
18823: --Print(l_api_name,'AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq');
18824: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq <- '||p_calling_sequence;
18825: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
18826: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
18827: END IF;

Line 18824: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq <- '||p_calling_sequence;

18820:
18821: BEGIN
18822:
18823: --Print(l_api_name,'AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq');
18824: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq <- '||p_calling_sequence;
18825: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
18826: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
18827: END IF;
18828:

Line 19047: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.synchronize_tax_dff <- '||p_calling_sequence;

19043: l_sync_trx_dist_dff_t ZX_NEW_SERVICES_PKG.tax_dist_dff_type%TYPE;
19044:
19045: BEGIN
19046:
19047: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.synchronize_tax_dff <- '||p_calling_sequence;
19048:
19049: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
19050: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
19051: END IF;

Line 19248: END AP_ETAX_SERVICES_PKG;

19244: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||p_api_name,p_debug_info);
19245: END IF;
19246: END Print;
19247:
19248: END AP_ETAX_SERVICES_PKG;