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 203: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

199:
200: G_REP_CONTEXT_ID NUMBER := 0;
201: g_retcode NUMBER := 0;
202: g_current_runtime_level NUMBER;
203: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
204: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
205: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
206: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
207: g_error_buffer VARCHAR2(100);

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

200: G_REP_CONTEXT_ID NUMBER := 0;
201: g_retcode NUMBER := 0;
202: g_current_runtime_level NUMBER;
203: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
204: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
205: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
206: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
207: g_error_buffer VARCHAR2(100);
208:

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

201: g_retcode NUMBER := 0;
202: g_current_runtime_level NUMBER;
203: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
204: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
205: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
206: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
207: g_error_buffer VARCHAR2(100);
208:
209: type IPV_PRIORITY_TBL is TABLE OF number

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

202: g_current_runtime_level NUMBER;
203: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
204: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
205: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
206: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
207: g_error_buffer VARCHAR2(100);
208:
209: type IPV_PRIORITY_TBL is TABLE OF number
210: INDEX BY binary_integer;

Line 547: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

543: (zx_dtl.posted_flag = 'A' AND zx_dtl.tax_line_id IS NULL)
544: );
545: BEGIN
546:
547: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
548: g_request_id := P_TRL_GLOBAL_VARIABLES_REC.request_id;
549:
550:
551: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

548: g_request_id := P_TRL_GLOBAL_VARIABLES_REC.request_id;
549:
550:
551: IF (g_level_procedure >= g_current_runtime_level ) THEN
552: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.BEGIN',
553: 'update_additional_info(+)');
554: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
555: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
556: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

550:
551: IF (g_level_procedure >= g_current_runtime_level ) THEN
552: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.BEGIN',
553: 'update_additional_info(+)');
554: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
555: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
556: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
557: 'Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id));
558: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

552: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.BEGIN',
553: 'update_additional_info(+)');
554: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
555: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
556: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
557: 'Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id));
558: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
559: 'Primary Ledger : '||to_char(p_trl_global_variables_rec.ledger_id));
560: END IF;

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

554: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
555: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID));
556: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
557: 'Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id));
558: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
559: 'Primary Ledger : '||to_char(p_trl_global_variables_rec.ledger_id));
560: END IF;
561:
562: gl_mc_info.get_ledger_currency(p_trl_global_variables_rec.ledger_id, G_FUN_CURRENCY_CODE);

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

637: LIMIT C_LINES_PER_COMMIT;
638:
639: l_count := GT_DETAIL_TAX_LINE_ID.count;
640: IF (g_level_procedure >= g_current_runtime_level ) THEN
641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
642: 'Rows fetched by rep_detail_cursor :'||to_char(l_count));
643: END IF;
644:
645: j:=0;

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

651: FOR i in 1..l_count
652: LOOP
653:
654: IF (g_level_procedure >= g_current_runtime_level ) THEN
655: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
656: 'Accouting Cursor Line Number :'||to_char(i));
657: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
658: ' GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

653:
654: IF (g_level_procedure >= g_current_runtime_level ) THEN
655: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
656: 'Accouting Cursor Line Number :'||to_char(i));
657: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
658: ' GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
660: ' GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

655: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
656: 'Accouting Cursor Line Number :'||to_char(i));
657: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
658: ' GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
660: ' GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
662: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

657: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
658: ' GT_BILL_FROM_PTY_TAX_PROF_ID(i) :'||to_char(GT_BILL_FROM_PTY_TAX_PROF_ID(i)));
659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
660: ' GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
662: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
664: ' gt_posted_flag :'||gt_posted_flag(i));
665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
660: ' GT_BILLING_TRADING_PARTNER_ID(i) :'||to_char(GT_BILLING_TRADING_PARTNER_ID(i)));
661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
662: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
664: ' gt_posted_flag :'||gt_posted_flag(i));
665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
666: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
662: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
664: ' gt_posted_flag :'||gt_posted_flag(i));
665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
666: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
668: 'GT_TAX_AMT(i) :'||to_char(GT_TAX_AMT(i)));
669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
664: ' gt_posted_flag :'||gt_posted_flag(i));
665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
666: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
668: 'GT_TAX_AMT(i) :'||to_char(GT_TAX_AMT(i)));
669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
670: 'GT_IPV_PRIORITY(i) :'||to_char(GT_IPV_PRIORITY(i)));
671: END IF;

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

665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
666: 'GT_TAXABLE_AMT(i) :'||to_char(GT_TAXABLE_AMT(i)));
667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
668: 'GT_TAX_AMT(i) :'||to_char(GT_TAX_AMT(i)));
669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
670: 'GT_IPV_PRIORITY(i) :'||to_char(GT_IPV_PRIORITY(i)));
671: END IF;
672:
673: extract_party_info(i);

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

691: --and then include_accounting_segments = 'Y' should bne checked ..
692: IF ( gt_posted_flag(i) = 'A'
693: AND P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' ) THEN
694: IF (g_level_procedure >= g_current_runtime_level ) THEN
695: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
696: ' Accounting API calls :');
697: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
698: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
699: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

693: AND P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' ) THEN
694: IF (g_level_procedure >= g_current_runtime_level ) THEN
695: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
696: ' Accounting API calls :');
697: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
698: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
699: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
700: ' gt_posted_flag :'||gt_posted_flag(i));
701: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',

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

695: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
696: ' Accounting API calls :');
697: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
698: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
699: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
700: ' gt_posted_flag :'||gt_posted_flag(i));
701: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
702: ' GT_actg_EVENT_ID :'||to_char(GT_actg_EVENT_ID(i)));
703: END IF;

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

697: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
698: ' include_accounting_segments :'||p_trl_global_variables_rec.include_accounting_segments);
699: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
700: ' gt_posted_flag :'||gt_posted_flag(i));
701: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
702: ' GT_actg_EVENT_ID :'||to_char(GT_actg_EVENT_ID(i)));
703: END IF;
704:
705: IF p_trl_global_variables_rec.include_accounting_segments='Y' THEN --Bug 5438409

Line 795: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' i : '||to_Char(i)||

791: gt_actg_line_num(i)) ;
792: END IF;
793:
794: IF (g_level_statement >= g_current_runtime_level ) THEN
795: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' i : '||to_Char(i)||
796: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(i)) ||'TAXABLE_AMT_FUNCL_CURR : '||GT_TAXABLE_AMT_FUNCL_CURR(i));
797: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' i : '||to_Char(i)||
798: 'Tax Amt : '|| to_char(GT_TAX_AMT(i)) ||'TAX_AMT_FUNCL_CURR : '||GT_TAX_AMT(i));
799: END IF;

Line 797: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' i : '||to_Char(i)||

793:
794: IF (g_level_statement >= g_current_runtime_level ) THEN
795: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' i : '||to_Char(i)||
796: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(i)) ||'TAXABLE_AMT_FUNCL_CURR : '||GT_TAXABLE_AMT_FUNCL_CURR(i));
797: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' i : '||to_Char(i)||
798: 'Tax Amt : '|| to_char(GT_TAX_AMT(i)) ||'TAX_AMT_FUNCL_CURR : '||GT_TAX_AMT(i));
799: END IF;
800: --GT_TAXABLE_AMT_FUNCL_CURR(i) := null;
801: -- GT_TAX_AMT_FUNCL_CURR(i) := null;

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

823:
824: END LOOP;
825:
826: IF (g_level_procedure >= g_current_runtime_level ) THEN
827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info.END',
828: 'update_additional_info(-)');
829: END IF;
830:
831: EXCEPTION

Line 838: FND_LOG.STRING(g_level_unexpected,

834: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
835: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
836: FND_MSG_PUB.Add;
837: IF (g_level_unexpected >= g_current_runtime_level ) THEN
838: FND_LOG.STRING(g_level_unexpected,
839: 'ZX.TRL.ZX_AP_POPULATE_PKG.update_additional_info',
840: g_error_buffer);
841: END IF;
842:

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

930:
931: BEGIN
932:
933: IF (g_level_procedure >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info.BEGIN',
935: 'extract_party_info(+)'||to_char(i));
936: END IF;
937:
938: OPEN ledger_cur(GT_LEDGER_ID(i));

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

963: l_bill_ship_pty_id := NVL(GT_SHIPPING_TP_ID(i),GT_BILLING_TRADING_PARTNER_ID(i));
964: l_bill_ship_site_id := NVL(GT_SHIPPING_TP_ADDRESS_ID(i), GT_BILLING_TP_ADDRESS_ID(i));
965:
966: IF (g_level_procedure >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
968: ' l_party_id :'||to_char(l_bill_ship_pty_id)||' '||to_char(l_bill_ship_site_id));
969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
970: ' GT_DETAIL_TAX_LINE_ID :'||to_char(l_party_id)||' '||to_char(GT_DETAIL_TAX_LINE_ID(i)));
971: END IF;

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

965:
966: IF (g_level_procedure >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
968: ' l_party_id :'||to_char(l_bill_ship_pty_id)||' '||to_char(l_bill_ship_site_id));
969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
970: ' GT_DETAIL_TAX_LINE_ID :'||to_char(l_party_id)||' '||to_char(GT_DETAIL_TAX_LINE_ID(i)));
971: END IF;
972:
973: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

970: ' GT_DETAIL_TAX_LINE_ID :'||to_char(l_party_id)||' '||to_char(GT_DETAIL_TAX_LINE_ID(i)));
971: END IF;
972:
973: IF (g_level_procedure >= g_current_runtime_level ) THEN
974: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
975: ' l_party_id :'||to_char(l_bill_ship_pty_id)||' '||to_char(l_bill_ship_site_id));
976: END IF;
977:
978:

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

1012: g_party_info_ap_tbl(l_tbl_index_party).BILLING_TP_SIC_CODE := GT_BILLING_TP_SIC_CODE(i);
1013: g_party_info_ap_tbl(l_tbl_index_party).BILL_FROM_PARTY_ID := GT_BILL_FROM_PARTY_ID(i);
1014:
1015: IF (g_level_procedure >= g_current_runtime_level ) THEN
1016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1017: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1019: ' l_party_id : Name :'||to_char(l_party_id)||'-'||GT_BILLING_TP_NAME(i));
1020: END IF;

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

1014:
1015: IF (g_level_procedure >= g_current_runtime_level ) THEN
1016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1017: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1019: ' l_party_id : Name :'||to_char(l_party_id)||'-'||GT_BILLING_TP_NAME(i));
1020: END IF;
1021: END IF;
1022: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

1019: ' l_party_id : Name :'||to_char(l_party_id)||'-'||GT_BILLING_TP_NAME(i));
1020: END IF;
1021: END IF;
1022: IF (g_level_procedure >= g_current_runtime_level ) THEN
1023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1024: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1026: ' l_party_id : Name :'||to_char(l_bill_ship_pty_id)||'-'||GT_BILLING_TP_NAME(i));
1027: END IF;

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

1021: END IF;
1022: IF (g_level_procedure >= g_current_runtime_level ) THEN
1023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1024: ' GT_BILLING_TP_NUMBER(i) :'||GT_BILLING_TP_NUMBER(i));
1025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1026: ' l_party_id : Name :'||to_char(l_bill_ship_pty_id)||'-'||GT_BILLING_TP_NAME(i));
1027: END IF;
1028: l_party_id := GT_BILL_FROM_PARTY_ID(i);
1029: OPEN party_reg_num_cur (l_party_id);

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

1092: g_party_site_tbl(l_tbl_index_site).BILL_FROM_PARTY_SITE_ID := GT_BILL_FROM_PARTY_SITE_ID(i);
1093: -- g_party_site_tbl(l_tbl_index_site).BILLING_SITE_TAX_REG_NUM := GT_BILLING_SITE_TAX_REG_NUM(i);
1094: END IF;
1095: IF (g_level_procedure >= g_current_runtime_level ) THEN
1096: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1097: ' l_party_site_id :'||to_char(l_party_site_id));
1098: END IF;
1099: l_party_site_id := GT_BILL_FROM_PARTY_SITE_ID(i);
1100: OPEN party_site_reg_num_cur(l_party_site_id);

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

1101: FETCH party_site_reg_num_cur INTO GT_BILLING_SITE_TAX_REG_NUM(i);
1102: END IF;
1103:
1104: IF (g_level_procedure >= g_current_runtime_level ) THEN
1105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info.END',
1106: 'extract_party_info(-)');
1107: END IF;
1108:
1109:

Line 1117: FND_LOG.STRING(g_level_unexpected,

1113: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1114: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1115: FND_MSG_PUB.Add;
1116: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1117: FND_LOG.STRING(g_level_unexpected,
1118: 'ZX.TRL.ZX_AP_POPULATE_PKG.extract_party_info',
1119: g_error_buffer);
1120: END IF;
1121: g_retcode := 2;

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

1355:
1356: BEGIN
1357:
1358: IF (g_level_procedure >= g_current_runtime_level ) THEN
1359: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1360: 'get_accounting_info(+)');
1361: END IF;
1362:
1363: GT_TRX_ARAP_BALANCING_SEGMENT(j) := NULL;

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

1407: END IF;
1408:
1409:
1410: IF (g_level_procedure >= g_current_runtime_level ) THEN
1411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1412: 'P_SUMMARY_LEVEL'||P_SUMMARY_LEVEL);
1413: END IF;
1414:
1415: IF P_SUMMARY_LEVEL = 'TRANSACTION' THEN

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

1423: LOOP
1424: FETCH trx_ccid INTO l_ccid;
1425:
1426: IF (g_level_procedure >= g_current_runtime_level ) THEN
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1428: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1429: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1430: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1431: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);

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

1426: IF (g_level_procedure >= g_current_runtime_level ) THEN
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1428: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1429: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1430: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1431: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1432: END IF;
1433:
1434:

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

1435: EXECUTE IMMEDIATE L_SQL_STATEMENT1 INTO L_BAL_SEG_VAL, L_ACCT_SEG_VAL
1436: USING l_ccid;
1437:
1438: IF (g_level_procedure >= g_current_runtime_level ) THEN
1439: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1440: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1441: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1442: END IF;
1443:

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

1598:
1599:
1600: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
1601: IF (g_level_procedure >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1603: 'TRANSACTION_DISTRIBUTION LEVEL');
1604: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1605: 'trx_dist_ccid cursor :');
1606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1600: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
1601: IF (g_level_procedure >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1603: 'TRANSACTION_DISTRIBUTION LEVEL');
1604: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1605: 'trx_dist_ccid cursor :');
1606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1607: 'P_TRX_ID :'||to_char(P_TRX_ID));
1608: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1602: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1603: 'TRANSACTION_DISTRIBUTION LEVEL');
1604: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1605: 'trx_dist_ccid cursor :');
1606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1607: 'P_TRX_ID :'||to_char(P_TRX_ID));
1608: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1609: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1604: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1605: 'trx_dist_ccid cursor :');
1606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1607: 'P_TRX_ID :'||to_char(P_TRX_ID));
1608: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1609: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1611: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1607: 'P_TRX_ID :'||to_char(P_TRX_ID));
1608: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1609: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1611: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1613: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1608: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1609: 'P_TRX_LINE_ID :'||to_char(P_TRX_LINE_ID));
1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1611: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1613: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1615: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1616: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1611: 'P_TAX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1613: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1615: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1616: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1617: 'P_TAX_DIST_ID :'||to_char(P_TAX_DIST_ID));
1618: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1613: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1615: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1616: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1617: 'P_TAX_DIST_ID :'||to_char(P_TAX_DIST_ID));
1618: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1619: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1620:

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

1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1615: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1616: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1617: 'P_TAX_DIST_ID :'||to_char(P_TAX_DIST_ID));
1618: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1619: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1620:
1621: END IF;
1622: OPEN trx_dist_ccid (

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

1637: EXECUTE IMMEDIATE L_SQL_STATEMENT1 INTO L_BAL_SEG_VAL, L_ACCT_SEG_VAL
1638: USING l_ccid;
1639:
1640: IF (g_level_procedure >= g_current_runtime_level ) THEN
1641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1642: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1644: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1645: END IF;

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

1639:
1640: IF (g_level_procedure >= g_current_runtime_level ) THEN
1641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1642: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1644: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1645: END IF;
1646: IF GT_TRX_TAXABLE_BAL_SEG(j) IS NULL then
1647: GT_TRX_TAXABLE_BAL_SEG(j) := L_BAL_SEG_VAL;

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

1671: END LOOP;
1672:
1673:
1674: IF (g_level_procedure >= g_current_runtime_level ) THEN
1675: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.BEGIN',
1676: 'tax_dist_ccid cursor :');
1677: END IF;
1678: OPEN tax_dist_ccid (p_application_id,
1679: p_entity_code,

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

1686: p_ae_header_id);
1687: LOOP
1688: FETCH tax_dist_ccid INTO l_ccid;
1689: IF (g_level_procedure >= g_current_runtime_level ) THEN
1690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1691: 'TRANSACTION_DISTRIBUTION LEVEL');
1692: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1693: 'tax_dist_ccid cursor :');
1694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1688: FETCH tax_dist_ccid INTO l_ccid;
1689: IF (g_level_procedure >= g_current_runtime_level ) THEN
1690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1691: 'TRANSACTION_DISTRIBUTION LEVEL');
1692: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1693: 'tax_dist_ccid cursor :');
1694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1695: 'P_TRX_ID :'||to_char(P_TRX_ID));
1696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1691: 'TRANSACTION_DISTRIBUTION LEVEL');
1692: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1693: 'tax_dist_ccid cursor :');
1694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1695: 'P_TRX_ID :'||to_char(P_TRX_ID));
1696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1697: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1692: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1693: 'tax_dist_ccid cursor :');
1694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1695: 'P_TRX_ID :'||to_char(P_TRX_ID));
1696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1697: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1699: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1695: 'P_TRX_ID :'||to_char(P_TRX_ID));
1696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1697: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1699: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1701: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1697: 'P_TaX_LINE_ID :'||to_char(P_TAX_LINE_ID));
1698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1699: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1701: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1703: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',

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

1698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1699: 'P_TAX_dist_ID :'||to_char(P_TAX_DIST_ID));
1700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1701: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1703: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1705: 'l_ccid :'||to_char(l_ccid));
1706: END IF;

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

1700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1701: 'P_EVENT_ID :'||to_char(P_EVENT_ID));
1702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1703: 'P_AE_HEADER_ID :'||to_char(P_AE_HEADER_ID));
1704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info',
1705: 'l_ccid :'||to_char(l_ccid));
1706: END IF;
1707:
1708: EXIT WHEN tax_dist_ccid%NOTFOUND;

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

1712: USING l_ccid;
1713:
1714:
1715: IF (g_level_procedure >= g_current_runtime_level ) THEN
1716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1717: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1719: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1720: END IF;

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

1714:
1715: IF (g_level_procedure >= g_current_runtime_level ) THEN
1716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1717: 'L_BAL_SEG_VAL :'||L_BAL_SEG_VAL);
1718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_info',
1719: 'L_ACCT_SEG_VAL :'||L_ACCT_SEG_VAL);
1720: END IF;
1721:
1722: IF GT_TRX_TAX_BALANCING_SEGMENT(j) IS NULL then

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

1756: P_QUALIFIER => 'ALL',
1757: P_CCID => l_tax_dist_ccid);
1758:
1759: IF (g_level_procedure >= g_current_runtime_level ) THEN
1760: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1761: 'Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
1762: END IF;
1763:
1764: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

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

1768: P_QUALIFIER => 'ALL',
1769: P_DATA => GT_ACCOUNT_FLEXFIELD(j));
1770:
1771: IF (g_level_procedure >= g_current_runtime_level ) THEN
1772: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1773: 'Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
1774: END IF;
1775:
1776: END IF;

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

1786: P_QUALIFIER => 'ALL',
1787: P_CCID => l_trx_dist_ccid);
1788:
1789: IF (g_level_procedure >= g_current_runtime_level ) THEN
1790: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1791: 'Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
1792: END IF;
1793: --Bug 5650415
1794: GT_TRX_TAXABLE_ACCOUNT_DESC(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

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

1798: P_QUALIFIER => 'ALL',
1799: P_DATA => GT_TRX_CONTROL_ACCFLEXFIELD(j));
1800:
1801: IF (g_level_procedure >= g_current_runtime_level ) THEN
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1803: 'Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
1804: END IF;
1805:
1806: END IF ;

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

1816: P_QUALIFIER => 'GL_BALANCING',
1817: P_CCID => l_trx_dist_ccid);
1818:
1819: IF (g_level_procedure >= g_current_runtime_level ) THEN
1820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1821: ' l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
1822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1823: ' g_chart_of_accounts_id = '||g_chart_of_accounts_id);
1824: END IF;

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

1818:
1819: IF (g_level_procedure >= g_current_runtime_level ) THEN
1820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1821: ' l_balancing_seg_val for TaxableLine = '||l_balancing_seg_val);
1822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1823: ' g_chart_of_accounts_id = '||g_chart_of_accounts_id);
1824: END IF;
1825:
1826: IF ( l_balancing_seg_val IS NOT NULL ) THEN

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

1831: P_QUALIFIER => 'GL_BALANCING',
1832: P_DATA => l_balancing_seg_val);
1833:
1834: IF (g_level_procedure >= g_current_runtime_level ) THEN
1835: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1836: 'Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
1837: END IF;
1838: END IF ;
1839: --Populate the Natural Account desccription after fetching its value

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

1844: P_QUALIFIER => 'GL_ACCOUNT',
1845: P_CCID => l_trx_dist_ccid);
1846:
1847: IF (g_level_procedure >= g_current_runtime_level ) THEN
1848: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1849: ' l_balancing_seg_val for TaxableLine = '||l_natural_acct_val);
1850: END IF;
1851:
1852: IF ( l_balancing_seg_val IS NOT NULL ) THEN

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

1857: P_QUALIFIER => 'GL_ACCOUNT',
1858: P_DATA => l_natural_acct_val);
1859:
1860: IF (g_level_procedure >= g_current_runtime_level ) THEN
1861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
1862: 'Balacing Seg Description for Taxable Line CCID = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
1863: END IF;
1864: END IF ;
1865:

Line 1872: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.END',

1868:
1869: ---- End of accounting flexfield population -----------------------
1870: END IF; -- Summary Level
1871: IF (g_level_procedure >= g_current_runtime_level ) THEN
1872: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_info.END',
1873: 'get_accounting_info(-)');
1874: END IF;
1875:
1876: END get_accounting_info;

Line 2153: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2149:
2150: BEGIN
2151:
2152: IF (g_level_procedure >= g_current_runtime_level ) THEN
2153: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2154: 'get_accounting_amounts(+)');
2155: END IF;
2156:
2157: --Bug 5393051 :

Line 2159: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2155: END IF;
2156:
2157: --Bug 5393051 :
2158: IF (g_level_statement >= g_current_runtime_level ) THEN
2159: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2160: 'p_summary_level : '||p_summary_level);
2161: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2162: 'j : '||to_char(j));
2163: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2161: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2157: --Bug 5393051 :
2158: IF (g_level_statement >= g_current_runtime_level ) THEN
2159: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2160: 'p_summary_level : '||p_summary_level);
2161: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2162: 'j : '||to_char(j));
2163: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2164: 'p_application_id : '||p_application_id);
2165: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2163: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2159: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2160: 'p_summary_level : '||p_summary_level);
2161: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2162: 'j : '||to_char(j));
2163: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2164: 'p_application_id : '||p_application_id);
2165: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2166: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2167: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2165: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2161: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2162: 'j : '||to_char(j));
2163: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2164: 'p_application_id : '||p_application_id);
2165: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2166: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2167: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2168: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2167: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2163: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2164: 'p_application_id : '||p_application_id);
2165: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2166: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2167: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2168: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2170: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2171: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2165: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2166: 'P_ENTITY_CODE : '||P_ENTITY_CODE);
2167: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2168: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2170: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2171: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2172: 'P_TRX_ID : '||P_TRX_ID);
2173: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2171: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2167: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2168: 'P_EVENT_CLASS_CODE : '||P_EVENT_CLASS_CODE);
2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2170: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2171: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2172: 'P_TRX_ID : '||P_TRX_ID);
2173: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2174: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2175: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2173: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2170: 'P_TRX_LEVEL_TYPE : '||P_TRX_LEVEL_TYPE);
2171: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2172: 'P_TRX_ID : '||P_TRX_ID);
2173: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2174: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2175: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2176: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2175: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2171: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2172: 'P_TRX_ID : '||P_TRX_ID);
2173: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2174: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2175: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2176: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2178: 'P_EVENT_ID : '||P_EVENT_ID);
2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2173: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2174: 'P_TRX_LINE_ID : '||P_TRX_LINE_ID);
2175: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2176: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2178: 'P_EVENT_ID : '||P_EVENT_ID);
2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2180: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2175: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2176: 'P_TAX_LINE_ID : '||P_TAX_LINE_ID);
2177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2178: 'P_EVENT_ID : '||P_EVENT_ID);
2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2180: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2182: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2183: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2178: 'P_EVENT_ID : '||P_EVENT_ID);
2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2180: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2182: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2183: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2184: 'P_LEDGER_ID : '||P_LEDGER_ID);
2185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

Line 2183: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2180: 'P_AE_HEADER_ID : '||P_AE_HEADER_ID);
2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2182: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2183: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2184: 'P_LEDGER_ID : '||P_LEDGER_ID);
2185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2186: 'p_ae_line_num : '||p_ae_line_num);
2187:

Line 2185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',

2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2182: 'P_TAX_DIST_ID : '||P_TAX_DIST_ID);
2183: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2184: 'P_LEDGER_ID : '||P_LEDGER_ID);
2185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',
2186: 'p_ae_line_num : '||p_ae_line_num);
2187:
2188: END IF;
2189:

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

2255: FETCH taxable_amount_dist INTO GT_TAXABLE_AMT(j),GT_TAXABLE_AMT_FUNCL_CURR(j);
2256:
2257: IF taxable_amount_dist%NOTFOUND OR GT_TAXABLE_AMT(j) IS NULL OR GT_TAXABLE_AMT_FUNCL_CURR(j) IS NULL THEN
2258: IF (g_level_procedure >= g_current_runtime_level ) THEN
2259: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.get_accounting_amounts',
2260: 'Cursor taxable_amount_dist Not Found, So open cursor taxable_amount_dist1');
2261: OPEN taxable_amount_dist1
2262: (p_application_id,
2263: p_entity_code,

Line 2295: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' j : '||to_Char(j)||

2291: CLOSE tax_amount_dist;
2292: END IF;
2293:
2294: IF (g_level_statement >= g_current_runtime_level ) THEN
2295: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' j : '||to_Char(j)||
2296: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(j)) ||'TAXABLE_AMT_FUNCL_CURR : '||
2297: GT_TAXABLE_AMT_FUNCL_CURR(j));
2298: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' j : '||to_Char(j)||
2299: 'Tax Amt : '|| to_char(GT_TAX_AMT(j)) ||'TAX_AMT_FUNCL_CURR : '||

Line 2298: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' j : '||to_Char(j)||

2294: IF (g_level_statement >= g_current_runtime_level ) THEN
2295: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' j : '||to_Char(j)||
2296: 'Taxable Amt : '|| to_char(GT_TAXABLE_AMT(j)) ||'TAXABLE_AMT_FUNCL_CURR : '||
2297: GT_TAXABLE_AMT_FUNCL_CURR(j));
2298: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.BEGIN',' j : '||to_Char(j)||
2299: 'Tax Amt : '|| to_char(GT_TAX_AMT(j)) ||'TAX_AMT_FUNCL_CURR : '||
2300: GT_TAX_AMT_FUNCL_CURR(j));
2301: END IF;
2302:

Line 2304: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.END',

2300: GT_TAX_AMT_FUNCL_CURR(j));
2301: END IF;
2302:
2303: IF (g_level_procedure >= g_current_runtime_level ) THEN
2304: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_POPULATE_PKG.get_accounting_amounts.END',
2305: 'get_accounting_amounts(-)');
2306: END IF;
2307:
2308: END get_accounting_amounts;

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

2769:
2770: BEGIN
2771:
2772: IF (g_level_procedure >= g_current_runtime_level ) THEN
2773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t.BEGIN',
2774: 'update_zx_rep_detail_t(+)');
2775: END IF;
2776:
2777: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

2774: 'update_zx_rep_detail_t(+)');
2775: END IF;
2776:
2777: IF (g_level_procedure >= g_current_runtime_level ) THEN
2778: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t',
2779: 'Rows Update by update_zx_rep_detail_t :'||to_char(p_count));
2780: END IF;
2781:
2782: FORALL i IN 1 .. p_count

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

2816: TAX_TYPE_MNG = GT_TAX_TYPE_MNG(i)
2817: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
2818:
2819: IF (g_level_procedure >= g_current_runtime_level ) THEN
2820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t.END',
2821: 'update_zx_rep_detail_t(-)');
2822: END IF;
2823:
2824: EXCEPTION

Line 2831: FND_LOG.STRING(g_level_unexpected,

2827: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2828: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2829: FND_MSG_PUB.Add;
2830: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2831: FND_LOG.STRING(g_level_unexpected,
2832: 'ZX.TRL.ZX_AP_POPULATE_PKG.update_zx_rep_detail_t',
2833: g_error_buffer);
2834: END IF;
2835: g_retcode := 2;

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

2861:
2862: BEGIN
2863:
2864: IF (g_level_procedure >= g_current_runtime_level ) THEN
2865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.BEGIN',
2866: 'ZX_AP_ACTG_EXTRACT_PKG: insert_actg_info(+)');
2867: END IF;
2868:
2869: l_count := P_COUNT;

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

2869: l_count := P_COUNT;
2870:
2871:
2872: IF (g_level_procedure >= g_current_runtime_level ) THEN
2873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
2874: ' Record Count = ' ||to_char(P_COUNT));
2875: END IF;
2876:
2877:

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

2980: GT_TRX_TAXABLE_NATURAL_ACCOUNT(i)
2981: );
2982:
2983: IF (g_level_procedure >= g_current_runtime_level ) THEN
2984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
2985: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
2986:
2987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.END',
2988: 'ZX_AP_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

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

2983: IF (g_level_procedure >= g_current_runtime_level ) THEN
2984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
2985: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
2986:
2987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info.END',
2988: 'ZX_AP_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');
2989: END IF;
2990:
2991: EXCEPTION

Line 2998: FND_LOG.STRING(g_level_unexpected,

2994: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2995: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2996: FND_MSG_PUB.Add;
2997: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2998: FND_LOG.STRING(g_level_unexpected,
2999: 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_actg_info',
3000: g_error_buffer);
3001: END IF;
3002:

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

3012:
3013: BEGIN
3014:
3015: IF (g_level_procedure >= g_current_runtime_level ) THEN
3016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables.BEGIN',
3017: 'initialize_variables(+)');
3018: END IF;
3019:
3020: FOR i IN 1.. p_count LOOP

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

3125: GT_BILLING_TRADING_PARTNER_ID.delete;
3126: */
3127:
3128: IF (g_level_procedure >= g_current_runtime_level ) THEN
3129: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables.END',
3130: 'initialize_variables(-)');
3131: END IF;
3132:
3133:

Line 3141: FND_LOG.STRING(g_level_unexpected,

3137: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3138: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3139: FND_MSG_PUB.Add;
3140: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3141: FND_LOG.STRING(g_level_unexpected,
3142: 'ZX.TRL.ZX_AP_POPULATE_PKG.initialize_variables',
3143: g_error_buffer);
3144: END IF;
3145: g_retcode := 2;

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

3173:
3174: BEGIN
3175:
3176: IF (g_level_procedure >= g_current_runtime_level ) THEN
3177: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.BEGIN',
3178: 'populate_tax_reg_num(+)');
3179: END IF;
3180:
3181: OPEN trn_ptp_id_cur (p_org_id,

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

3184: FETCH trn_ptp_id_cur into GT_TAX_REG_NUM(i);
3185: CLOSE trn_ptp_id_cur;
3186:
3187: IF (g_level_procedure >= g_current_runtime_level ) THEN
3188: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.END',
3189: 'populate_tax_reg_num(-)');
3190: END IF;
3191: END populate_tax_reg_num;
3192:

Line 3206: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3202: GT_TAX_RATE_CODE_REG_TYPE_MNG(i) := NULL ;
3203: GT_TAX_TYPE_MNG(i) := NULL ;
3204:
3205: IF (g_level_procedure >= g_current_runtime_level ) THEN
3206: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3207: 'populate_meaning(+)');
3208: END IF;
3209:
3210: IF GT_TRX_LINE_CLASS(i) IS NOT NULL THEN

Line 3219: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3215: GT_TRX_CLASS_MNG(i) := l_meaning;
3216: END IF;
3217:
3218: IF (g_level_statement >= g_current_runtime_level ) THEN
3219: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3220: 'Value of i : '||i);
3221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3222: 'GT_TRX_ID(i) : '||GT_TRX_ID(i));
3223: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

Line 3221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3217:
3218: IF (g_level_statement >= g_current_runtime_level ) THEN
3219: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3220: 'Value of i : '||i);
3221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3222: 'GT_TRX_ID(i) : '||GT_TRX_ID(i));
3223: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3224: 'GT_TRX_CLASS_MNG(i) : '||GT_TRX_CLASS_MNG(i));
3225: END IF;

Line 3223: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3219: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3220: 'Value of i : '||i);
3221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3222: 'GT_TRX_ID(i) : '||GT_TRX_ID(i));
3223: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3224: 'GT_TRX_CLASS_MNG(i) : '||GT_TRX_CLASS_MNG(i));
3225: END IF;
3226:
3227: IF P_TRL_GLOBAL_VARIABLES_REC.REGISTER_TYPE IS NOT NULL THEN

Line 3236: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3232:
3233: GT_TAX_RATE_CODE_REG_TYPE_MNG(i) := l_meaning;
3234: END IF;
3235: IF (g_level_statement >= g_current_runtime_level ) THEN
3236: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3237: 'GT_TAX_RATE_CODE_REG_TYPE_MNG(i) : '||GT_TAX_RATE_CODE_REG_TYPE_MNG(i));
3238: END IF;
3239:
3240: IF GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) IS NOT NULL THEN

Line 3249: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3245: GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) := l_description;
3246: END IF;
3247:
3248: IF (g_level_statement >= g_current_runtime_level ) THEN
3249: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3250: 'GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_DESC(i));
3251: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3252: 'GT_TAX_TYPE_CODE(i) : '||GT_TAX_TYPE_CODE(i));
3253: END IF;

Line 3251: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3247:
3248: IF (g_level_statement >= g_current_runtime_level ) THEN
3249: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3250: 'GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_DESC(i));
3251: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3252: 'GT_TAX_TYPE_CODE(i) : '||GT_TAX_TYPE_CODE(i));
3253: END IF;
3254:
3255: --Bug 5671767 :Code added to populate tax_type_mng

Line 3265: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3261: GT_TAX_TYPE_MNG(i) := l_meaning;
3262: END IF;
3263:
3264: IF (g_level_statement >= g_current_runtime_level ) THEN
3265: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3266: 'GT_TAX_TYPE_MNG(i) : '||GT_TAX_TYPE_MNG(i));
3267: END IF;
3268:
3269: IF gt_tax_recoverable_flag(i) = 'Y' THEN

Line 3276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',

3272: gt_tax_rate_reg_type_code(i) := 'NON-RECOVERABLE';
3273: END IF;
3274:
3275: IF (g_level_procedure >= g_current_runtime_level ) THEN
3276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning.BEGIN',
3277: 'populate_meaning(-)');
3278: END IF;
3279:
3280: EXCEPTION

Line 3287: FND_LOG.STRING(g_level_unexpected,

3283: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3284: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_meaning- '|| g_error_buffer);
3285: FND_MSG_PUB.Add;
3286: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3287: FND_LOG.STRING(g_level_unexpected,
3288: 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_meaning',
3289: g_error_buffer);
3290: END IF;
3291:

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

3309: l_tbl_index_lookup BINARY_INTEGER;
3310: BEGIN
3311:
3312: IF (g_level_procedure >= g_current_runtime_level ) THEN
3313: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning.BEGIN',
3314: 'lookup_desc_meaning(+)');
3315: END IF;
3316:
3317: IF p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL THEN

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

3315: END IF;
3316:
3317: IF p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL THEN
3318: IF (g_level_procedure >= g_current_runtime_level ) THEN
3319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3320: 'Lookup Type and Lookup code are not null '||p_lookup_type||'-'||P_LOOKUP_CODE);
3321: END IF;
3322:
3323: l_tbl_index_lookup := dbms_utility.get_hash_value(p_lookup_type||p_lookup_code, 1,8192);

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

3322:
3323: l_tbl_index_lookup := dbms_utility.get_hash_value(p_lookup_type||p_lookup_code, 1,8192);
3324:
3325: IF (g_level_procedure >= g_current_runtime_level ) THEN
3326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3327: 'Meaning Alredy existed in the Cache');
3328: END IF;
3329:
3330: IF g_lookup_info_tbl.EXISTS(l_tbl_index_lookup) THEN

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

3334:
3335: ELSE
3336:
3337: IF (g_level_procedure >= g_current_runtime_level ) THEN
3338: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3339: 'Before Open lookup_cur');
3340: END IF;
3341:
3342: OPEN lookup_cur (p_lookup_type, p_lookup_code);

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

3344: INTO p_meaning,
3345: p_description;
3346:
3347: IF (g_level_procedure >= g_current_runtime_level ) THEN
3348: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3349: 'p_meaning p_description'||p_meaning||' '||p_description);
3350: END IF;
3351:
3352: g_lookup_info_tbl(l_tbl_index_lookup).lookup_meaning := p_meaning;

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

3357: IF lookup_cur%ISOPEN THEN
3358: CLOSE lookup_cur;
3359: END IF;
3360: IF (g_level_procedure >= g_current_runtime_level ) THEN
3361: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning.END',
3362: 'lookup_desc_meaning(-)');
3363: END IF;
3364:
3365: EXCEPTION

Line 3372: FND_LOG.STRING(g_level_unexpected,

3368: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3369: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3370: FND_MSG_PUB.Add;
3371: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3372: FND_LOG.STRING(g_level_unexpected,
3373: 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3374: g_error_buffer);
3375: END IF;
3376: g_retcode := 2;