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.ZX_AP_POPULATE_PKG dependencies on FND_LOG

Line 216: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

212:
213: G_REP_CONTEXT_ID NUMBER := 0;
214: g_retcode NUMBER := 0;
215: g_current_runtime_level NUMBER;
216: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
217: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
218: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
219: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
220: g_error_buffer VARCHAR2(100);

Line 217: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

213: G_REP_CONTEXT_ID NUMBER := 0;
214: g_retcode NUMBER := 0;
215: g_current_runtime_level NUMBER;
216: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
217: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
218: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
219: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
220: g_error_buffer VARCHAR2(100);
221:

Line 218: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

214: g_retcode NUMBER := 0;
215: g_current_runtime_level NUMBER;
216: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
217: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
218: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
219: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
220: g_error_buffer VARCHAR2(100);
221:
222: -- l_balancing_segment VARCHAR2(25);

Line 219: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

215: g_current_runtime_level NUMBER;
216: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
217: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
218: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
219: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
220: g_error_buffer VARCHAR2(100);
221:
222: -- l_balancing_segment VARCHAR2(25);
223: -- l_accounting_segment VARCHAR2(25);

Line 604: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

600: );
601:
602: BEGIN
603:
604: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
605: G_REQUEST_ID := P_TRL_GLOBAL_VARIABLES_REC.request_id;
606:
607:
608: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 609: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.BEGIN',

605: G_REQUEST_ID := P_TRL_GLOBAL_VARIABLES_REC.request_id;
606:
607:
608: IF (g_level_procedure >= g_current_runtime_level ) THEN
609: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.BEGIN',
610: 'update_additional_info(+)');
611: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
612: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 611: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

607:
608: IF (g_level_procedure >= g_current_runtime_level ) THEN
609: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.BEGIN',
610: 'update_additional_info(+)');
611: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
612: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
614: 'Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id));
615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

609: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.BEGIN',
610: 'update_additional_info(+)');
611: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
612: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
614: 'Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id));
615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
616: 'Primary Ledger : '||to_char(p_trl_global_variables_rec.ledger_id));
617: END IF;

Line 615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

611: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
612: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
614: 'Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id));
615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
616: 'Primary Ledger : '||to_char(p_trl_global_variables_rec.ledger_id));
617: END IF;
618:
619: gl_mc_info.get_ledger_currency(NVL(p_trl_global_variables_rec.reporting_ledger_id,

Line 748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

744: LIMIT C_LINES_PER_COMMIT;
745:
746: l_count := GT_DETAIL_TAX_LINE_ID.count;
747: IF (g_level_procedure >= g_current_runtime_level ) THEN
748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
749: 'Rows fetched by rep_detail_cursor :'||to_char(l_count));
750: END IF;
751:
752: j:=0;

Line 761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

757: FOR i in 1..l_count
758: LOOP
759:
760: IF (g_level_procedure >= g_current_runtime_level ) THEN
761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
762: 'Populate Cursor Line Number :'||to_char(i));
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
764: 'GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

759:
760: IF (g_level_procedure >= g_current_runtime_level ) THEN
761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
762: 'Populate Cursor Line Number :'||to_char(i));
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
764: 'GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
766: 'GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
762: 'Populate Cursor Line Number :'||to_char(i));
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
764: 'GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
766: 'GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
768: 'include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
764: 'GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
766: 'GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
768: 'include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
770: 'gt_posted_flag :'||gt_posted_flag(i));
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
766: 'GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
768: 'include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
770: 'gt_posted_flag :'||gt_posted_flag(i));
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
772: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
768: 'include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
770: 'gt_posted_flag :'||gt_posted_flag(i));
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
772: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
774: 'GT_TAX_AMT(i) :'||to_char(GT_TAX_AMT(i)));
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
770: 'gt_posted_flag :'||gt_posted_flag(i));
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
772: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
774: 'GT_TAX_AMT(i) :'||to_char(GT_TAX_AMT(i)));
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
776: 'GT_IPV_PRIORITY(i) :'||to_char(GT_IPV_PRIORITY(i)));
777: END IF;

Line 775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
772: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
774: 'GT_TAX_AMT(i) :'||to_char(GT_TAX_AMT(i)));
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
776: 'GT_IPV_PRIORITY(i) :'||to_char(GT_IPV_PRIORITY(i)));
777: END IF;
778:
779: -- Intialize discount amount variables --

Line 808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

804: IF ( gt_posted_flag(i) IN ('A','Y')
805: AND
806: P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' ) THEN
807: IF (g_level_procedure >= g_current_runtime_level ) THEN
808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
809: ' Accounting API calls :');
810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
811: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

806: P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' ) THEN
807: IF (g_level_procedure >= g_current_runtime_level ) THEN
808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
809: ' Accounting API calls :');
810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
811: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
813: ' gt_posted_flag :'||gt_posted_flag(i));
814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

Line 812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
809: ' Accounting API calls :');
810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
811: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
813: ' gt_posted_flag :'||gt_posted_flag(i));
814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
815: ' GT_actg_EVENT_ID :'||to_char(GT_actg_EVENT_ID(i)));
816: END IF;

Line 814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
811: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
813: ' gt_posted_flag :'||gt_posted_flag(i));
814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
815: ' GT_actg_EVENT_ID :'||to_char(GT_actg_EVENT_ID(i)));
816: END IF;
817:
818: IF p_trl_global_variables_rec.include_accounting_segments='Y' THEN --Bug 5438409

Line 900: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',' i : '||to_Char(i)||

896: GT_TRX_LINE_DIST_ID(i)) ;
897: END IF;
898:
899: IF (g_level_statement >= g_current_runtime_level ) THEN
900: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',' i : '||to_Char(i)||
901: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(i)) ||'TAXABLE_AMT_FUNCL_CURR : '||GT_TAXABLE_AMT_FUNCL_CURR(i));
902: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',' i : '||to_Char(i)||
903: 'Tax Amt : '|| to_char(GT_TAX_AMT(i)) ||'TAX_AMT_FUNCL_CURR : '||GT_TAX_AMT_FUNCL_CURR(i));
904: END IF;

Line 902: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',' i : '||to_Char(i)||

898:
899: IF (g_level_statement >= g_current_runtime_level ) THEN
900: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',' i : '||to_Char(i)||
901: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(i)) ||'TAXABLE_AMT_FUNCL_CURR : '||GT_TAXABLE_AMT_FUNCL_CURR(i));
902: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',' i : '||to_Char(i)||
903: 'Tax Amt : '|| to_char(GT_TAX_AMT(i)) ||'TAX_AMT_FUNCL_CURR : '||GT_TAX_AMT_FUNCL_CURR(i));
904: END IF;
905:
906: ELSE -- Discounts API Call --

Line 964: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.END',

960:
961: bulk_populate_zx_dtl (p_register_type => P_TRL_GLOBAL_VARIABLES_REC.REGISTER_TYPE);
962:
963: IF (g_level_procedure >= g_current_runtime_level ) THEN
964: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.END',
965: 'update_additional_info(-)');
966: END IF;
967:
968: EXCEPTION

Line 975: FND_LOG.STRING(g_level_unexpected,

971: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
972: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
973: FND_MSG_PUB.Add;
974: IF (g_level_unexpected >= g_current_runtime_level ) THEN
975: FND_LOG.STRING(g_level_unexpected,
976: 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
977: g_error_buffer);
978: END IF;
979:

Line 1075: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info.BEGIN',

1071:
1072: BEGIN
1073:
1074: IF (g_level_procedure >= g_current_runtime_level ) THEN
1075: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info.BEGIN',
1076: 'extract_party_info(+)'||to_char(i));
1077: END IF;
1078:
1079: -- OPEN ledger_cur(GT_LEDGER_ID(i));

Line 1109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1105: l_bill_ship_pty_id := NVL(GT_SHIPPING_TP_ID(i),GT_BILLING_TRADING_PARTNER_ID(i));
1106: l_bill_ship_site_id := NVL(GT_SHIPPING_TP_ADDRESS_ID(i), GT_BILLING_TP_ADDRESS_ID(i));
1107:
1108: IF (g_level_procedure >= g_current_runtime_level ) THEN
1109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1110: ' l_party_id :'||to_char(l_bill_ship_pty_id)||' '||to_char(l_bill_ship_site_id));
1111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1112: ' GT_DETAIL_TAX_LINE_ID :'||to_char(l_party_id)||' '||to_char(GT_DETAIL_TAX_LINE_ID(i)));
1113: END IF;

Line 1111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1107:
1108: IF (g_level_procedure >= g_current_runtime_level ) THEN
1109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1110: ' l_party_id :'||to_char(l_bill_ship_pty_id)||' '||to_char(l_bill_ship_site_id));
1111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1112: ' GT_DETAIL_TAX_LINE_ID :'||to_char(l_party_id)||' '||to_char(GT_DETAIL_TAX_LINE_ID(i)));
1113: END IF;
1114:
1115: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1112: ' GT_DETAIL_TAX_LINE_ID :'||to_char(l_party_id)||' '||to_char(GT_DETAIL_TAX_LINE_ID(i)));
1113: END IF;
1114:
1115: IF (g_level_procedure >= g_current_runtime_level ) THEN
1116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1117: ' l_party_id :'||to_char(l_bill_ship_pty_id)||' '||to_char(l_bill_ship_site_id));
1118: END IF;
1119:
1120:

Line 1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1154: g_party_info_ap_tbl(l_tbl_index_party).BILLING_TP_SIC_CODE := GT_BILLING_TP_SIC_CODE(i);
1155: g_party_info_ap_tbl(l_tbl_index_party).BILL_FROM_PARTY_ID := GT_BILL_FROM_PARTY_ID(i);
1156:
1157: IF (g_level_procedure >= g_current_runtime_level ) THEN
1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1159: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1161: ' l_party_id : Name :'||to_char(l_party_id)||'-'||GT_BILLING_TP_NAME(i));
1162: END IF;

Line 1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1156:
1157: IF (g_level_procedure >= g_current_runtime_level ) THEN
1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1159: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1161: ' l_party_id : Name :'||to_char(l_party_id)||'-'||GT_BILLING_TP_NAME(i));
1162: END IF;
1163: END IF;
1164: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1165: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1161: ' l_party_id : Name :'||to_char(l_party_id)||'-'||GT_BILLING_TP_NAME(i));
1162: END IF;
1163: END IF;
1164: IF (g_level_procedure >= g_current_runtime_level ) THEN
1165: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1166: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1167: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1168: ' l_party_id : Name :'||to_char(l_bill_ship_pty_id)||'-'||GT_BILLING_TP_NAME(i));
1169: END IF;

Line 1167: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1163: END IF;
1164: IF (g_level_procedure >= g_current_runtime_level ) THEN
1165: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1166: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1167: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1168: ' l_party_id : Name :'||to_char(l_bill_ship_pty_id)||'-'||GT_BILLING_TP_NAME(i));
1169: END IF;
1170: l_party_id := GT_BILL_FROM_PARTY_ID(i);
1171: OPEN party_reg_num_cur (l_party_id);

Line 1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',

1234: g_party_site_tbl(l_tbl_index_site).BILL_FROM_PARTY_SITE_ID := GT_BILL_FROM_PARTY_SITE_ID(i);
1235: -- g_party_site_tbl(l_tbl_index_site).BILLING_SITE_TAX_REG_NUM := GT_BILLING_SITE_TAX_REG_NUM(i);
1236: END IF;
1237: IF (g_level_procedure >= g_current_runtime_level ) THEN
1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1239: ' l_party_site_id :'||to_char(l_party_site_id));
1240: END IF;
1241: l_party_site_id := GT_BILL_FROM_PARTY_SITE_ID(i);
1242: OPEN party_site_reg_num_cur(l_party_site_id);

Line 1247: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info.END',

1243: FETCH party_site_reg_num_cur INTO GT_BILLING_SITE_TAX_REG_NUM(i);
1244: END IF;
1245:
1246: IF (g_level_procedure >= g_current_runtime_level ) THEN
1247: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info.END',
1248: 'extract_party_info(-)');
1249: END IF;
1250:
1251:

Line 1259: FND_LOG.STRING(g_level_unexpected,

1255: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1256: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1257: FND_MSG_PUB.Add;
1258: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1259: FND_LOG.STRING(g_level_unexpected,
1260: 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1261: g_error_buffer);
1262: END IF;
1263: g_retcode := 2;

Line 1537: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info.BEGIN',

1533:
1534: BEGIN
1535:
1536: IF (g_level_procedure >= g_current_runtime_level ) THEN
1537: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info.BEGIN',
1538: 'get_accounting_info(+)');
1539: END IF;
1540:
1541: GT_TRX_ARAP_BALANCING_SEGMENT(j) := NULL;

Line 1571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',

1567: l_liability_post_lookup_code;
1568: CLOSE get_system_info_cur;
1569:
1570: IF (g_level_procedure >= g_current_runtime_level ) THEN
1571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1572: 'l_disc_distribution_method : '||l_disc_distribution_method);
1573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1574: 'l_disc_is_inv_less_tax_flag : '||l_disc_is_inv_less_tax_flag);
1575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',

Line 1573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',

1569:
1570: IF (g_level_procedure >= g_current_runtime_level ) THEN
1571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1572: 'l_disc_distribution_method : '||l_disc_distribution_method);
1573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1574: 'l_disc_is_inv_less_tax_flag : '||l_disc_is_inv_less_tax_flag);
1575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1576: 'l_liability_post_lookup_code : '||l_liability_post_lookup_code);
1577: END IF;

Line 1575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',

1571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1572: 'l_disc_distribution_method : '||l_disc_distribution_method);
1573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1574: 'l_disc_is_inv_less_tax_flag : '||l_disc_is_inv_less_tax_flag);
1575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1576: 'l_liability_post_lookup_code : '||l_liability_post_lookup_code);
1577: END IF;
1578:
1579: IF NVL(l_disc_is_inv_less_tax_flag, 'N') = 'N' AND

Line 1603: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1599: END IF;
1600:
1601:
1602: IF (g_level_procedure >= g_current_runtime_level ) THEN
1603: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1604: 'P_SUMMARY_LEVEL'||P_SUMMARY_LEVEL);
1605: END IF;
1606:
1607: IF P_SUMMARY_LEVEL = 'TRANSACTION' THEN

Line 1619: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1615: LOOP
1616: FETCH trx_ccid INTO l_ccid;
1617:
1618: IF (g_level_procedure >= g_current_runtime_level ) THEN
1619: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1620: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1621: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1622: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1623: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);

Line 1622: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1618: IF (g_level_procedure >= g_current_runtime_level ) THEN
1619: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1620: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1621: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1622: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1623: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1624: END IF;
1625:
1626:

Line 1631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1627: EXECUTE IMMEDIATE L_SQL_STATEMENT1 INTO L_BAL_SEG_VAL, L_ACCT_SEG_VAL
1628: USING l_ccid;
1629:
1630: IF (g_level_procedure >= g_current_runtime_level ) THEN
1631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1632: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1633: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1634: END IF;
1635:

Line 1792: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1788: END LOOP;
1789:
1790: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
1791: IF (g_level_procedure >= g_current_runtime_level ) THEN
1792: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1793: 'TRANSACTION_DISTRIBUTION LEVEL');
1794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1795: 'trx_dist_ccid cursor :');
1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1790: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
1791: IF (g_level_procedure >= g_current_runtime_level ) THEN
1792: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1793: 'TRANSACTION_DISTRIBUTION LEVEL');
1794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1795: 'trx_dist_ccid cursor :');
1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1797: 'P_TRX_ID :'||to_char(P_TRX_ID));
1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1792: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1793: 'TRANSACTION_DISTRIBUTION LEVEL');
1794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1795: 'trx_dist_ccid cursor :');
1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1797: 'P_TRX_ID :'||to_char(P_TRX_ID));
1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1799: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1795: 'trx_dist_ccid cursor :');
1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1797: 'P_TRX_ID :'||to_char(P_TRX_ID));
1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1799: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1801: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1797: 'P_TRX_ID :'||to_char(P_TRX_ID));
1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1799: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1801: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1803: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1799: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1801: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1803: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1805: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1806: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1801: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1803: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1805: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1806: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1807: 'P_TAX_DIST_ID :'||to_char(P_TAX_DIST_ID));
1808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1806: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1803: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1805: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1806: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1807: 'P_TAX_DIST_ID :'||to_char(P_TAX_DIST_ID));
1808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1809: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1810:

Line 1808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1805: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1806: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1807: 'P_TAX_DIST_ID :'||to_char(P_TAX_DIST_ID));
1808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1809: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1810:
1811: END IF;
1812: OPEN trx_dist_ccid (

Line 1827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1823: FETCH trx_dist_ccid INTO l_ccid;
1824:
1825: IF trx_dist_ccid%NOTFOUND OR l_ccid IS NULL THEN
1826: IF (g_level_procedure >= g_current_runtime_level ) THEN
1827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1828: 'Cursor trx_dist_ccid Not Found, So open cursor trx_dist_ccid_tax_event');
1829: END IF;
1830:
1831: OPEN trx_dist_ccid_tax_event (

Line 1852: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1848:
1849: l_trx_dist_ccid := l_ccid ; --Bug 5510907
1850:
1851: IF (g_level_procedure >= g_current_runtime_level ) THEN
1852: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1853: 'l_trx_dist_ccid :'||l_trx_dist_ccid);
1854: END IF;
1855:
1856: IF l_trx_dist_ccid IS NOT NULL THEN

Line 1862: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1858: USING l_ccid;
1859: END IF;
1860:
1861: IF (g_level_procedure >= g_current_runtime_level ) THEN
1862: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1863: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1864: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1865: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1866: END IF;

Line 1864: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1860:
1861: IF (g_level_procedure >= g_current_runtime_level ) THEN
1862: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1863: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1864: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1865: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1866: END IF;
1867: IF GT_TRX_TAXABLE_BAL_SEG(j) IS NULL then
1868: GT_TRX_TAXABLE_BAL_SEG(j) := L_BAL_SEG_VAL;

Line 1895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info.BEGIN',

1891: GT_TRX_ARAP_NATURAL_ACCOUNT(j) := GT_TRX_TAXABLE_NATURAL_ACCOUNT(j);
1892: -- END LOOP;
1893:
1894: IF (g_level_procedure >= g_current_runtime_level ) THEN
1895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info.BEGIN',
1896: 'tax_dist_ccid cursor :');
1897: END IF;
1898:
1899: OPEN tax_dist_ccid (p_application_id,

Line 1911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1907: p_ae_header_id);
1908: LOOP
1909: FETCH tax_dist_ccid INTO l_ccid;
1910: IF (g_level_procedure >= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1912: 'TRANSACTION_DISTRIBUTION LEVEL');
1913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1914: 'tax_dist_ccid cursor :');
1915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1909: FETCH tax_dist_ccid INTO l_ccid;
1910: IF (g_level_procedure >= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1912: 'TRANSACTION_DISTRIBUTION LEVEL');
1913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1914: 'tax_dist_ccid cursor :');
1915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1916: 'P_TRX_ID :'||to_char(P_TRX_ID));
1917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1912: 'TRANSACTION_DISTRIBUTION LEVEL');
1913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1914: 'tax_dist_ccid cursor :');
1915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1916: 'P_TRX_ID :'||to_char(P_TRX_ID));
1917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1918: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1914: 'tax_dist_ccid cursor :');
1915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1916: 'P_TRX_ID :'||to_char(P_TRX_ID));
1917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1918: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1920: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1916: 'P_TRX_ID :'||to_char(P_TRX_ID));
1917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1918: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1920: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1922: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1918: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1920: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1922: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1924: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

Line 1923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1920: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1922: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1924: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1926: 'l_ccid :'||to_char(l_ccid));
1927: END IF;

Line 1925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1922: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1924: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1926: 'l_ccid :'||to_char(l_ccid));
1927: END IF;
1928:
1929: EXIT WHEN tax_dist_ccid%NOTFOUND;

Line 1937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1933: USING l_ccid;
1934:
1935:
1936: IF (g_level_procedure >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1938: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1940: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1941: END IF;

Line 1939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',

1935:
1936: IF (g_level_procedure >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1938: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1940: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1941: END IF;
1942:
1943: IF GT_TRX_TAX_BALANCING_SEGMENT(j) IS NULL then

Line 1980: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

1976: GT_ACCOUNT_FLEXFIELD(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_VAL;
1977: GT_ACCOUNT_DESCRIPTION(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_DESC;
1978:
1979: IF (g_level_procedure >= g_current_runtime_level ) THEN
1980: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1981: 'From Cache :: Hash = '||l_tbl_index_ccid);
1982: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1983: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
1984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 1982: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

1978:
1979: IF (g_level_procedure >= g_current_runtime_level ) THEN
1980: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1981: 'From Cache :: Hash = '||l_tbl_index_ccid);
1982: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1983: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
1984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1985: 'From Cache :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
1986: END IF;

Line 1984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

1980: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1981: 'From Cache :: Hash = '||l_tbl_index_ccid);
1982: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1983: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
1984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1985: 'From Cache :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
1986: END IF;
1987: ELSE
1988:

Line 2012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2008: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).BALSEG_VAL := NULL;
2009: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := NULL;
2010:
2011: IF (g_level_procedure >= g_current_runtime_level ) THEN
2012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2013: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2015: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2010:
2011: IF (g_level_procedure >= g_current_runtime_level ) THEN
2012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2013: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2015: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2017: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2018: END IF;

Line 2016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2013: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2015: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2017: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2018: END IF;
2019: END IF; --Cache Exists Check
2020: END IF; --TAX CCID Null Check

Line 2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2030: GT_TRX_TAXABLE_BALSEG_DESC(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).BALSEG_DESC;
2031: GT_TRX_TAXABLE_NATACCT_DESC(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_DESC;
2032:
2033: IF (g_level_procedure >= g_current_runtime_level ) THEN
2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2035: 'From Cache :: Hash = '||l_tbl_index_ccid);
2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2037: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2032:
2033: IF (g_level_procedure >= g_current_runtime_level ) THEN
2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2035: 'From Cache :: Hash = '||l_tbl_index_ccid);
2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2037: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2039: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2035: 'From Cache :: Hash = '||l_tbl_index_ccid);
2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2037: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2039: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2041: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2037: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2039: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2041: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2043: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2044: END IF;

Line 2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2039: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2041: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2043: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2044: END IF;
2045: ELSE
2046:

Line 2107: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2103: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).BALSEG_VAL := NULL;
2104: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := NULL;
2105:
2106: IF (g_level_procedure >= g_current_runtime_level ) THEN
2107: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2108: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2105:
2106: IF (g_level_procedure >= g_current_runtime_level ) THEN
2107: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2108: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2107: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2108: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2110: 'From FA_RX_FLEX_PKG :: Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2112: 'From FA_RX_FLEX_PKG :: Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);
2119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

Line 2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2114: 'From FA_RX_FLEX_PKG :: l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);
2119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2120: 'From FA_RX_FLEX_PKG :: Natural Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2121: END IF;

Line 2119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',

2115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2116: 'From FA_RX_FLEX_PKG :: Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2118: 'From FA_RX_FLEX_PKG :: l_natural_acct_val for TaxableLine = '||l_natural_acct_val);
2119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2120: 'From FA_RX_FLEX_PKG :: Natural Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2121: END IF;
2122: END IF; -- Cache Exists Check
2123: END IF ; -- TRX CCID Null Check

Line 2129: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info.END',

2125: ---- End of accounting flexfield population -----------------------
2126: END IF; -- Summary Level
2127:
2128: IF (g_level_procedure >= g_current_runtime_level ) THEN
2129: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info.END',
2130: 'get_accounting_info(-)');
2131: END IF;
2132:
2133: END get_accounting_info;

Line 2479: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts.BEGIN',

2475:
2476: BEGIN
2477:
2478: IF (g_level_procedure >= g_current_runtime_level ) THEN
2479: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts.BEGIN',
2480: 'get_accounting_amounts(+)');
2481: END IF;
2482:
2483: --Bug 5393051 :

Line 2485: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2481: END IF;
2482:
2483: --Bug 5393051 :
2484: IF (g_level_statement >= g_current_runtime_level ) THEN
2485: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2486: 'p_summary_level : '||p_summary_level);
2487: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2488: 'p_report_name : '||p_report_name);
2489: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2487: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2483: --Bug 5393051 :
2484: IF (g_level_statement >= g_current_runtime_level ) THEN
2485: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2486: 'p_summary_level : '||p_summary_level);
2487: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2488: 'p_report_name : '||p_report_name);
2489: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2490: 'j : '||to_char(j));
2491: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2489: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2485: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2486: 'p_summary_level : '||p_summary_level);
2487: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2488: 'p_report_name : '||p_report_name);
2489: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2490: 'j : '||to_char(j));
2491: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2492: 'p_application_id : '||p_application_id);
2493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2491: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2487: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2488: 'p_report_name : '||p_report_name);
2489: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2490: 'j : '||to_char(j));
2491: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2492: 'p_application_id : '||p_application_id);
2493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2494: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2495: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2489: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2490: 'j : '||to_char(j));
2491: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2492: 'p_application_id : '||p_application_id);
2493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2494: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2495: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2496: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2497: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2495: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2491: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2492: 'p_application_id : '||p_application_id);
2493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2494: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2495: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2496: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2497: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2498: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2499: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2497: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2494: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2495: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2496: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2497: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2498: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2499: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2500: 'P_TRX_ID : '||P_TRX_ID);
2501: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2499: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2495: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2496: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2497: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2498: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2499: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2500: 'P_TRX_ID : '||P_TRX_ID);
2501: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2502: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2503: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2501: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2497: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2498: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2499: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2500: 'P_TRX_ID : '||P_TRX_ID);
2501: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2502: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2503: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2504: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2505: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2503: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2499: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2500: 'P_TRX_ID : '||P_TRX_ID);
2501: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2502: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2503: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2504: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2505: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2506: 'P_EVENT_ID : '||P_EVENT_ID);
2507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2505: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2501: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2502: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2503: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2504: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2505: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2506: 'P_EVENT_ID : '||P_EVENT_ID);
2507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2508: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2503: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2504: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2505: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2506: 'P_EVENT_ID : '||P_EVENT_ID);
2507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2508: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2510: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2505: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2506: 'P_EVENT_ID : '||P_EVENT_ID);
2507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2508: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2510: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2512: 'P_LEDGER_ID : '||P_LEDGER_ID);
2513: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

Line 2511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2508: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2510: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2512: 'P_LEDGER_ID : '||P_LEDGER_ID);
2513: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2514: 'p_ae_line_num : '||p_ae_line_num);
2515:

Line 2513: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2510: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2512: 'P_LEDGER_ID : '||P_LEDGER_ID);
2513: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2514: 'p_ae_line_num : '||p_ae_line_num);
2515:
2516: END IF;
2517:

Line 2591: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2587: GT_TAXABLE_AMT_FUNCL_CURR(j) := GT_TAXABLE_AMT_FUNCL_CURR(j) + NVL(l_erv_accounted_amt,0) ;
2588:
2589: IF taxable_amount_dist%NOTFOUND OR GT_TAXABLE_AMT(j) IS NULL OR GT_TAXABLE_AMT_FUNCL_CURR(j) IS NULL THEN
2590: IF (g_level_procedure >= g_current_runtime_level ) THEN
2591: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2592: 'Cursor taxable_amount_dist Not Found, So open cursor taxable_amount_dist1');
2593: END IF;
2594: OPEN taxable_amount_dist1 (p_application_id,
2595: p_entity_code,

Line 2607: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2603: FETCH taxable_amount_dist1 INTO GT_TAXABLE_AMT(j),GT_TAXABLE_AMT_FUNCL_CURR(j);
2604:
2605: IF taxable_amount_dist1%NOTFOUND OR GT_TAXABLE_AMT(j) IS NULL OR GT_TAXABLE_AMT_FUNCL_CURR(j) IS NULL THEN
2606: IF (g_level_procedure >= g_current_runtime_level ) THEN
2607: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2608: 'Cursor taxable_amount_dist1 Not Found, So open cursor taxable_amount_dist2');
2609: END IF;
2610:
2611: OPEN taxable_amount_dist2(p_application_id,

Line 2628: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',

2624:
2625: IF (p_report_name = 'ZXXTATAT' AND (taxable_amount_dist2%NOTFOUND
2626: OR GT_TAXABLE_AMT(j) IS NULL OR GT_TAXABLE_AMT_FUNCL_CURR(j) IS NULL )) THEN
2627: IF (g_level_procedure >= g_current_runtime_level ) THEN
2628: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2629: 'Cursor taxable_amount_dist2 Not Found, So open cursor taxable_amount_dist_no_tax');
2630: END IF;
2631: OPEN taxable_amount_dist_no_tax(p_trx_id,
2632: p_trx_line_id,

Line 2656: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',' j : '||to_Char(j)||

2652: CLOSE tax_amount_dist;
2653: END IF;
2654:
2655: IF (g_level_statement >= g_current_runtime_level ) THEN
2656: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',' j : '||to_Char(j)||
2657: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(j)) ||'TAXABLE_AMT_FUNCL_CURR : '||
2658: GT_TAXABLE_AMT_FUNCL_CURR(j));
2659: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',' j : '||to_Char(j)||
2660: 'Tax Amt : '|| to_char(GT_TAX_AMT(j)) ||'TAX_AMT_FUNCL_CURR : '||

Line 2659: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',' j : '||to_Char(j)||

2655: IF (g_level_statement >= g_current_runtime_level ) THEN
2656: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',' j : '||to_Char(j)||
2657: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(j)) ||'TAXABLE_AMT_FUNCL_CURR : '||
2658: GT_TAXABLE_AMT_FUNCL_CURR(j));
2659: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',' j : '||to_Char(j)||
2660: 'Tax Amt : '|| to_char(GT_TAX_AMT(j)) ||'TAX_AMT_FUNCL_CURR : '||
2661: GT_TAX_AMT_FUNCL_CURR(j));
2662: END IF;
2663:

Line 2665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts.END',

2661: GT_TAX_AMT_FUNCL_CURR(j));
2662: END IF;
2663:
2664: IF (g_level_procedure >= g_current_runtime_level ) THEN
2665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts.END',
2666: 'get_accounting_amounts(-)');
2667: END IF;
2668:
2669: END get_accounting_amounts;

Line 3090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',

3086:
3087: BEGIN
3088:
3089: IF (g_level_procedure >= g_current_runtime_level ) THEN
3090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3091: 'get_discount_info(+)');
3092: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3093: 'P_DISC_DISTRIBUTION_METHOD :'||P_DISC_DISTRIBUTION_METHOD);
3094: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',

Line 3092: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',

3088:
3089: IF (g_level_procedure >= g_current_runtime_level ) THEN
3090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3091: 'get_discount_info(+)');
3092: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3093: 'P_DISC_DISTRIBUTION_METHOD :'||P_DISC_DISTRIBUTION_METHOD);
3094: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3095: 'P_LIABILITY_POST_LOOKUP_CODE : '||P_LIABILITY_POST_LOOKUP_CODE);
3096: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',

Line 3094: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',

3090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3091: 'get_discount_info(+)');
3092: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3093: 'P_DISC_DISTRIBUTION_METHOD :'||P_DISC_DISTRIBUTION_METHOD);
3094: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3095: 'P_LIABILITY_POST_LOOKUP_CODE : '||P_LIABILITY_POST_LOOKUP_CODE);
3096: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3097: 'P_TRX_ID : '||to_char(P_TRX_ID));
3098: END IF;

Line 3096: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',

3092: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3093: 'P_DISC_DISTRIBUTION_METHOD :'||P_DISC_DISTRIBUTION_METHOD);
3094: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3095: 'P_LIABILITY_POST_LOOKUP_CODE : '||P_LIABILITY_POST_LOOKUP_CODE);
3096: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info.BEGIN',
3097: 'P_TRX_ID : '||to_char(P_TRX_ID));
3098: END IF;
3099: i := j;
3100: --P_INDEX_TO_GLOBAL_TABLES;

Line 3137: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3133: NULL;
3134: END IF; -- tax_discount_cur
3135:
3136: IF (g_level_procedure >= g_current_runtime_level ) THEN
3137: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3138: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3139: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3140: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3141: END IF;

Line 3139: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3135:
3136: IF (g_level_procedure >= g_current_runtime_level ) THEN
3137: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3138: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3139: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3140: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3141: END IF;
3142:
3143: CLOSE taxable_dist_csr;

Line 3163: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3159: --(p_trx_line_id);
3160: FETCH taxable_hdr_csr INTO l_taxable_entered_disc_amt, l_taxable_acct_disc_amt;
3161:
3162: IF (g_level_procedure >= g_current_runtime_level ) THEN
3163: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3164: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3165: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3166: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3167: END IF;

Line 3165: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3161:
3162: IF (g_level_procedure >= g_current_runtime_level ) THEN
3163: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3164: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3165: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3166: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3167: END IF;
3168: IF taxable_hdr_csr%NOTFOUND THEN
3169: NULL;

Line 3192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3188: NULL;
3189: END IF;
3190:
3191: IF (g_level_procedure >= g_current_runtime_level ) THEN
3192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3193: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3195: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3196: END IF;

Line 3194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3190:
3191: IF (g_level_procedure >= g_current_runtime_level ) THEN
3192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3193: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3195: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3196: END IF;
3197: CLOSE taxable_dist_csr;
3198: ELSE

Line 3200: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info', ' Dist method TAX : ');

3196: END IF;
3197: CLOSE taxable_dist_csr;
3198: ELSE
3199: IF (g_level_procedure >= g_current_runtime_level ) THEN
3200: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info', ' Dist method TAX : ');
3201: END IF;
3202: OPEN taxable_hdr_csr;
3203: FETCH taxable_hdr_csr INTO l_taxable_entered_disc_amt, l_taxable_acct_disc_amt;
3204: IF taxable_hdr_csr%NOTFOUND THEN

Line 3212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3208: END IF; -- taxable_disc_sys_cur
3209: close taxable_hdr_csr;
3210:
3211: IF (g_level_procedure >= g_current_runtime_level ) THEN
3212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3213: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3215: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3216: END IF;

Line 3214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3210:
3211: IF (g_level_procedure >= g_current_runtime_level ) THEN
3212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3213: 'l_taxable_entered_disc_amt : '||to_char(l_taxable_entered_disc_amt));
3214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3215: 'l_taxable_acct_disc_amt : '||to_char(l_taxable_acct_disc_amt));
3216: END IF;
3217: END IF;
3218: GT_TAXABLE_DISC_AMT(j) := l_taxable_entered_disc_amt;

Line 3237: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3233:
3234: CLOSE tax_dist_csr;
3235:
3236: IF (g_level_procedure >= g_current_runtime_level ) THEN
3237: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3238: 'l_tax_entered_disc_amt : '||to_char(l_tax_entered_disc_amt));
3239: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3240: 'l_tax_acct_disc_amt : '||to_char(l_tax_acct_disc_amt));
3241: END IF;

Line 3239: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3235:
3236: IF (g_level_procedure >= g_current_runtime_level ) THEN
3237: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3238: 'l_tax_entered_disc_amt : '||to_char(l_tax_entered_disc_amt));
3239: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3240: 'l_tax_acct_disc_amt : '||to_char(l_tax_acct_disc_amt));
3241: END IF;
3242:
3243: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_LINE' THEN

Line 3263: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3259: IF tax_hdr_csr%NOTFOUND THEN
3260: NULL; -- Message
3261: END IF; -- tax_discount_cur
3262: IF (g_level_procedure >= g_current_runtime_level ) THEN
3263: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3264: 'l_tax_entered_disc_amt : '||to_char(l_tax_entered_disc_amt));
3265: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3266: 'l_tax_acct_disc_amt : '||to_char(l_tax_acct_disc_amt));
3267: END IF;

Line 3265: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3261: END IF; -- tax_discount_cur
3262: IF (g_level_procedure >= g_current_runtime_level ) THEN
3263: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3264: 'l_tax_entered_disc_amt : '||to_char(l_tax_entered_disc_amt));
3265: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3266: 'l_tax_acct_disc_amt : '||to_char(l_tax_acct_disc_amt));
3267: END IF;
3268:
3269: END IF; --summary level

Line 3283: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',

3279: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3280: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_discount_info- '|| g_error_buffer);
3281: FND_MSG_PUB.Add;
3282: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3283: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3284: g_error_buffer);
3285: END IF;
3286:
3287: WHEN OTHERS THEN

Line 3293: FND_LOG.STRING(g_level_unexpected,

3289: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3290: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_discount_info- '|| g_error_buffer);
3291: FND_MSG_PUB.Add;
3292: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3293: FND_LOG.STRING(g_level_unexpected,
3294: 'ZX.TRL.ZX_AP_POPULATE_PKG.get_discount_info',
3295: g_error_buffer);
3296: END IF;
3297:

Line 3309: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t.BEGIN',

3305:
3306: BEGIN
3307:
3308: IF (g_level_procedure >= g_current_runtime_level ) THEN
3309: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t.BEGIN',
3310: 'update_zx_rep_detail_t(+)');
3311: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t',
3312: 'Rows Update by update_zx_rep_detail_t :'||to_char(p_count));
3313: END IF;

Line 3311: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t',

3307:
3308: IF (g_level_procedure >= g_current_runtime_level ) THEN
3309: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t.BEGIN',
3310: 'update_zx_rep_detail_t(+)');
3311: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t',
3312: 'Rows Update by update_zx_rep_detail_t :'||to_char(p_count));
3313: END IF;
3314:
3315: FORALL i IN 1 .. p_count

Line 3354: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t.END',

3350: TAXABLE_AMT_FUNCL_CURR = GT_TAXABLE_AMT_FUNCL_CURR(i)
3351: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
3352:
3353: IF (g_level_procedure >= g_current_runtime_level ) THEN
3354: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t.END',
3355: 'update_zx_rep_detail_t(-)');
3356: END IF;
3357:
3358: EXCEPTION

Line 3365: FND_LOG.STRING(g_level_unexpected,

3361: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3362: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3363: FND_MSG_PUB.Add;
3364: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3365: FND_LOG.STRING(g_level_unexpected,
3366: 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t',
3367: g_error_buffer);
3368: END IF;
3369: g_retcode := 2;

Line 3399: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.BEGIN',

3395:
3396: BEGIN
3397:
3398: IF (g_level_procedure >= g_current_runtime_level ) THEN
3399: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.BEGIN',
3400: 'ZX_AP_ACTG_EXTRACT_PKG: insert_actg_info(+)');
3401: END IF;
3402:
3403: l_count := P_COUNT;

Line 3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',

3403: l_count := P_COUNT;
3404:
3405:
3406: IF (g_level_procedure >= g_current_runtime_level ) THEN
3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
3408: ' Record Count = ' ||to_char(P_COUNT));
3409: END IF;
3410:
3411:

Line 3518: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',

3514: GT_TRX_TAXABLE_NATURAL_ACCOUNT(i)
3515: );
3516:
3517: IF (g_level_procedure >= g_current_runtime_level ) THEN
3518: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
3519: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3520:
3521: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.END',
3522: 'ZX_AP_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

Line 3521: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.END',

3517: IF (g_level_procedure >= g_current_runtime_level ) THEN
3518: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
3519: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3520:
3521: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.END',
3522: 'ZX_AP_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');
3523: END IF;
3524:
3525: EXCEPTION

Line 3532: FND_LOG.STRING(g_level_unexpected,

3528: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3529: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3530: FND_MSG_PUB.Add;
3531: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3532: FND_LOG.STRING(g_level_unexpected,
3533: 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
3534: g_error_buffer);
3535: END IF;
3536:

Line 3550: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables.BEGIN',

3546:
3547: BEGIN
3548:
3549: IF (g_level_procedure >= g_current_runtime_level ) THEN
3550: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables.BEGIN',
3551: 'initialize_variables(+)');
3552: END IF;
3553:
3554: FOR i IN 1.. p_count LOOP

Line 3619: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables.END',

3615: -- GT_SHIPPING_TP_ID.delete;
3616: -- GT_BILLING_TRADING_PARTNER_ID.delete;
3617:
3618: IF (g_level_procedure >= g_current_runtime_level ) THEN
3619: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables.END',
3620: 'initialize_variables(-)');
3621: END IF;
3622:
3623:

Line 3631: FND_LOG.STRING(g_level_unexpected,

3627: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3628: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3629: FND_MSG_PUB.Add;
3630: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3631: FND_LOG.STRING(g_level_unexpected,
3632: 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables',
3633: g_error_buffer);
3634: END IF;
3635: g_retcode := 2;

Line 3667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.BEGIN',

3663:
3664: BEGIN
3665:
3666: IF (g_level_procedure >= g_current_runtime_level ) THEN
3667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.BEGIN',
3668: 'populate_tax_reg_num(+)');
3669: END IF;
3670:
3671: OPEN trn_ptp_id_cur (p_org_id,

Line 3678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.END',

3674: FETCH trn_ptp_id_cur into GT_TAX_REG_NUM(i);
3675: CLOSE trn_ptp_id_cur;
3676:
3677: IF (g_level_procedure >= g_current_runtime_level ) THEN
3678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.END',
3679: 'populate_tax_reg_num(-)');
3680: END IF;
3681: END populate_tax_reg_num;
3682:

Line 3700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning.BEGIN',

3696: l_tbl_index_lookup BINARY_INTEGER;
3697: BEGIN
3698:
3699: IF (g_level_procedure >= g_current_runtime_level ) THEN
3700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning.BEGIN',
3701: 'lookup_desc_meaning(+)');
3702: END IF;
3703:
3704: IF p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL THEN

Line 3706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',

3702: END IF;
3703:
3704: IF p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL THEN
3705: IF (g_level_procedure >= g_current_runtime_level ) THEN
3706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3707: 'Lookup Type and Lookup code are not null '||p_lookup_type||'-'||P_LOOKUP_CODE);
3708: END IF;
3709:
3710: l_tbl_index_lookup := dbms_utility.get_hash_value(p_lookup_type||p_lookup_code, 1,8192);

Line 3713: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',

3709:
3710: l_tbl_index_lookup := dbms_utility.get_hash_value(p_lookup_type||p_lookup_code, 1,8192);
3711:
3712: IF (g_level_procedure >= g_current_runtime_level ) THEN
3713: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3714: 'Meaning Alredy existed in the Cache');
3715: END IF;
3716:
3717: IF g_lookup_info_tbl.EXISTS(l_tbl_index_lookup) THEN

Line 3722: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',

3718: p_meaning := g_lookup_info_tbl(l_tbl_index_lookup).lookup_meaning;
3719: p_description := g_lookup_info_tbl(l_tbl_index_lookup).lookup_description;
3720: ELSE
3721: IF (g_level_procedure >= g_current_runtime_level ) THEN
3722: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3723: 'Before Open lookup_cur');
3724: END IF;
3725:
3726: OPEN lookup_cur (p_lookup_type, p_lookup_code);

Line 3732: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',

3728: INTO p_meaning,
3729: p_description;
3730:
3731: IF (g_level_procedure >= g_current_runtime_level ) THEN
3732: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3733: 'p_meaning p_description'||p_meaning||' '||p_description);
3734: END IF;
3735:
3736: g_lookup_info_tbl(l_tbl_index_lookup).lookup_meaning := p_meaning;

Line 3745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning.END',

3741: IF lookup_cur%ISOPEN THEN
3742: CLOSE lookup_cur;
3743: END IF;
3744: IF (g_level_procedure >= g_current_runtime_level ) THEN
3745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning.END',
3746: 'lookup_desc_meaning(-)');
3747: END IF;
3748:
3749: EXCEPTION

Line 3756: FND_LOG.STRING(g_level_unexpected,

3752: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3753: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3754: FND_MSG_PUB.Add;
3755: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3756: FND_LOG.STRING(g_level_unexpected,
3757: 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3758: g_error_buffer);
3759: END IF;
3760: g_retcode := 2;