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_AR_POPULATE_PKG dependencies on FND_LOG

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

256: C_LINES_PER_COMMIT CONSTANT NUMBER := 5000;
257: L_MSG VARCHAR2(500);
258: G_REP_CONTEXT_ID NUMBER;
259: g_current_runtime_level NUMBER;
260: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
261: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
262: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
263: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
264: g_error_buffer VARCHAR2(100);

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

257: L_MSG VARCHAR2(500);
258: G_REP_CONTEXT_ID NUMBER;
259: g_current_runtime_level NUMBER;
260: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
261: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
262: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
263: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
264: g_error_buffer VARCHAR2(100);
265:

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

258: G_REP_CONTEXT_ID NUMBER;
259: g_current_runtime_level NUMBER;
260: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
261: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
262: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
263: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
264: g_error_buffer VARCHAR2(100);
265:
266: PROCEDURE convert_amounts(P_CURRENCY_CODE IN VARCHAR2,

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

259: g_current_runtime_level NUMBER;
260: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
261: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
262: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
263: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
264: g_error_buffer VARCHAR2(100);
265:
266: PROCEDURE convert_amounts(P_CURRENCY_CODE IN VARCHAR2,
267: P_EXCHANGE_RATE IN NUMBER,

Line 982: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

978: j NUMBER;
979:
980: BEGIN
981:
982: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
983: g_request_id := P_TRL_GLOBAL_VARIABLES_REC.request_id;
984: g_coa_id := P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id;
985:
986: G_REP_CONTEXT_ID := ZX_EXTRACT_PKG.GET_REP_CONTEXT_ID(P_TRL_GLOBAL_VARIABLES_REC.LEGAL_ENTITY_ID,

Line 999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info.BEGIN',

995: g_program_id := fnd_global.conc_program_id;
996: g_program_login_id := fnd_global.conc_login_id;
997:
998: IF (g_level_procedure >= g_current_runtime_level ) THEN
999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info.BEGIN',
1000: 'ZX_AR_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(+)');
1001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1002: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID) ||
1003: ' ; Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) ||

Line 1001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

997:
998: IF (g_level_procedure >= g_current_runtime_level ) THEN
999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info.BEGIN',
1000: 'ZX_AR_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(+)');
1001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1002: 'Request ID : '||to_char(P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID) ||
1003: ' ; Reporting Ledger : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) ||
1004: ' ; Primary Ledger : '||to_char(p_trl_global_variables_rec.ledger_id)
1005: );

Line 1105: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1101: AND dtl1.APPLIED_FROM_EVENT_CLASS_CODE = 'APP'
1102: AND dtl1.application_id = 222 ;
1103:
1104: IF (g_level_statement >= g_current_runtime_level ) THEN
1105: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1106: 'Duplicate rows deleted using 1st Query: '|| to_char(SQL%ROWCOUNT));
1107: END IF;
1108:
1109: -- This query deletes duplicate rows returned by receipts due to 'UNEARN'--

Line 1134: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1130: AND dtl1.APPLIED_FROM_EVENT_CLASS_CODE = 'APP'
1131: AND dtl1.application_id = 222;
1132:
1133: IF (g_level_statement >= g_current_runtime_level ) THEN
1134: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1135: 'Duplicate rows deleted using 2nd Query: '|| to_char(SQL%ROWCOUNT));
1136: END IF;
1137:
1138: END IF; --Include check for discounts --

Line 1177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1173: --AND dtl1.APPLIED_FROM_EVENT_CLASS_CODE = 'ADJ'
1174: AND dtl1.application_id = 222;
1175:
1176: IF (g_level_statement >= g_current_runtime_level ) THEN
1177: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1178: 'Before Dist cursor Opened -- Delete Duplicate rows for AR Adjustments : '||to_char(l_count));
1179: END IF;
1180: l_count := 0;
1181: END IF; -- Include flag check for ADJ --

Line 1329: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1325: GT_DEF_REC_SETTLEMENT_OPT_CODE
1326: LIMIT C_LINES_PER_COMMIT;
1327:
1328: IF (g_level_statement >= g_current_runtime_level ) THEN
1329: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1330: 'Dist cursor Opened -- detail_t_cur : ');
1331: END IF;
1332:
1333: ELSE

Line 1431: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',

1427: GT_DEF_REC_SETTLEMENT_OPT_CODE
1428: LIMIT C_LINES_PER_COMMIT;
1429:
1430: IF (g_level_statement >= g_current_runtime_level ) THEN
1431: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1432: 'Trx / Line cursor Opened -- detail_t_cur_trx_line : ');
1433: END IF;
1434: END IF;
1435:

Line 1443: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1439: -- Initialize j value for accounting records count --
1440: j:=0;
1441:
1442: IF (g_level_statement >= g_current_runtime_level ) THEN
1443: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1444: 'Row Count After fetch : ' ||to_char(l_count));
1445: END IF;
1446:
1447: IF l_count >0 THEN

Line 1458: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1454: LOOP
1455: L_TRX_CLASS := GT_TRX_CLASS(i);
1456: GT_LEDGER_NAME(i) := l_gl_name;
1457: IF (g_level_statement >= g_current_runtime_level ) THEN
1458: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1459: 'Inside Loop : i : '||to_char(i)||' ; ' ||
1460: 'detail tax line id:'||to_char(gt_detail_tax_line_id(i))||' ; ' ||
1461: ' L_TRX_CLASS : '||L_TRX_CLASS
1462: );

Line 1502: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1498:
1499: IF p_trl_global_variables_rec.include_accounting_segments='Y' THEN
1500:
1501: IF (g_level_statement >= g_current_runtime_level ) THEN
1502: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1503: 'get_accounting_info Call for detail tax line id:'||to_char(gt_detail_tax_line_id(i))
1504: );
1505: END IF;
1506:

Line 1567: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',

1563: p_trl_global_variables_rec.reporting_ledger_id,
1564: i) ;
1565: END IF;
1566: IF (g_level_statement >= g_current_runtime_level ) THEN
1567: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1568: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR'||to_char(GT_TAXABLE_AMT(i))||
1569: 'i='||to_char(i)||' j='||to_char(i)
1570: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(i)));
1571: END IF;

Line 1646: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.END',

1642: CLOSE detail_t_cur_trx_line;
1643: END IF;
1644:
1645: IF (g_level_procedure >= g_current_runtime_level ) THEN
1646: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.END',
1647: 'ZX_AR_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(-)');
1648: END IF;
1649:
1650: EXCEPTION

Line 1657: FND_LOG.STRING(g_level_unexpected,

1653: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1654: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1655: FND_MSG_PUB.Add;
1656: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1657: FND_LOG.STRING(g_level_unexpected,
1658: 'ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info',
1659: g_error_buffer);
1660: END IF;
1661:

Line 1710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.BEGIN',

1706:
1707: BEGIN
1708:
1709: IF (g_level_procedure >= g_current_runtime_level ) THEN
1710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.BEGIN',
1711: 'ZX_AR_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(+)');
1712: END IF;
1713:
1714: IF UPPER(P_SUMMARY_LEVEL) = 'TRANSACTION' THEN

Line 1727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS',

1723: L_ROUNDING_TAX_AMT, L_ROUNDING_TAXABLE_AMT ;
1724: CLOSE ROUNDING_AMTS_CURSOR;
1725:
1726: IF (g_level_procedure >= g_current_runtime_level ) THEN
1727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS',
1728: 'Reconciliation Amt : Taxable Amt | Tax Amt :'||L_ROUNDING_TAXABLE_AMT||' | '||L_ROUNDING_TAX_AMT);
1729: END IF;
1730:
1731: P_INPUT_TAX_AMOUNT := P_INPUT_TAX_AMOUNT + nvl(L_ROUNDING_TAX_AMT,0);

Line 1768: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.END',

1764:
1765: END IF;
1766:
1767: IF (g_level_procedure >= g_current_runtime_level ) THEN
1768: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.END',
1769: 'ZX_AR_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(-)');
1770: END IF;
1771:
1772: EXCEPTION

Line 1779: FND_LOG.STRING(g_level_unexpected,

1775: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1776: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1777: FND_MSG_PUB.Add;
1778: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1779: FND_LOG.STRING(g_level_unexpected,
1780: 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS',
1781: g_error_buffer);
1782: END IF;
1783:

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

1804:
1805: BEGIN
1806:
1807: IF (g_level_procedure >= g_current_runtime_level ) THEN
1808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info.BEGIN',
1809: 'ZX_AR_POPULATE_PKG: get_accounting_info(+)' );
1810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',
1811: 'j := '||to_char(j));
1812: END IF;

Line 1810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',

1806:
1807: IF (g_level_procedure >= g_current_runtime_level ) THEN
1808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info.BEGIN',
1809: 'ZX_AR_POPULATE_PKG: get_accounting_info(+)' );
1810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',
1811: 'j := '||to_char(j));
1812: END IF;
1813:
1814: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',

1811: 'j := '||to_char(j));
1812: END IF;
1813:
1814: IF (g_level_procedure >= g_current_runtime_level ) THEN
1815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',
1816: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
1817: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
1818: ||'-'||to_char(p_trx_line_id));
1819: END IF;

Line 1853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info.END',

1849: P_TRX_CLASS,
1850: j);
1851: END IF;
1852: IF (g_level_procedure >= g_current_runtime_level ) THEN
1853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info.END',
1854: 'ZX_AR_POPULATE_PKG: get_accounting_info(-)');
1855: END IF;
1856:
1857: END get_accounting_info;

Line 1873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts.BEGIN',

1869: j IN binary_integer) IS
1870: BEGIN
1871:
1872: IF (g_level_procedure >= g_current_runtime_level ) THEN
1873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts.BEGIN',
1874: 'ZX_AR_POPULATE_PKG: get_accounting_amounts(+)');
1875: END IF;
1876:
1877: IF p_trx_class in ('INVOICE','CREDIT_MEMO','DEBIT_MEMO') THEN

Line 1890: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',

1886: P_TRX_CLASS,
1887: P_LEDGER_ID,
1888: j);
1889: IF (g_level_procedure >= g_current_runtime_level ) THEN
1890: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1891: 'trx_id : '||p_trx_id||' tax_line_id : '||P_TAX_LINE_ID||' j : ' ||j);
1892: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1893: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1894: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));

Line 1892: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',

1888: j);
1889: IF (g_level_procedure >= g_current_runtime_level ) THEN
1890: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1891: 'trx_id : '||p_trx_id||' tax_line_id : '||P_TAX_LINE_ID||' j : ' ||j);
1892: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1893: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1894: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
1895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1896: 'inv_actg_amounts call :GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR ::: '||to_char(GT_TAX_AMT(j))

Line 1895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',

1891: 'trx_id : '||p_trx_id||' tax_line_id : '||P_TAX_LINE_ID||' j : ' ||j);
1892: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1893: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1894: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
1895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1896: 'inv_actg_amounts call :GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR ::: '||to_char(GT_TAX_AMT(j))
1897: ||'-'||to_char(GT_TAX_AMT_FUNCL_CURR(j)));
1898: END IF;
1899:

Line 1903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',

1899:
1900: ELSIF p_trx_class IN ('APP','EDISC','UNEDISC','ADJ','FINCHRG',
1901: 'MISC_CASH_RECEIPT') THEN
1902: IF (g_level_procedure >= g_current_runtime_level ) THEN
1903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1904: 'p_trx_class: '||to_char(p_trx_class)|| 'so calling other_trx_actg_amounts ' );
1905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts',
1906: 'p_trx_id - p_event_id - p_ae_header_id- p_actg_source_id- p_ledger_id '
1907: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)

Line 1905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts',

1901: 'MISC_CASH_RECEIPT') THEN
1902: IF (g_level_procedure >= g_current_runtime_level ) THEN
1903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1904: 'p_trx_class: '||to_char(p_trx_class)|| 'so calling other_trx_actg_amounts ' );
1905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts',
1906: 'p_trx_id - p_event_id - p_ae_header_id- p_actg_source_id- p_ledger_id '
1907: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
1908: ||'-'||to_char(p_actg_source_id)||'-'||to_char(p_ledger_id));
1909: END IF;

Line 1922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',

1918: P_TRX_CLASS,
1919: P_LEDGER_ID,
1920: j);
1921: IF (g_level_procedure >= g_current_runtime_level ) THEN
1922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1923: 'other_trx_actg_amounts: trx_id : '||p_trx_id||' j : ' ||j);
1924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1925: 'other_trx_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1926: ||' - '||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));

Line 1924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',

1920: j);
1921: IF (g_level_procedure >= g_current_runtime_level ) THEN
1922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1923: 'other_trx_actg_amounts: trx_id : '||p_trx_id||' j : ' ||j);
1924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1925: 'other_trx_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1926: ||' - '||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
1927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1928: 'other_trx_actg_amounts call :GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR ::: '||to_char(GT_TAX_AMT(j))

Line 1927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',

1923: 'other_trx_actg_amounts: trx_id : '||p_trx_id||' j : ' ||j);
1924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1925: 'other_trx_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1926: ||' - '||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
1927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts',
1928: 'other_trx_actg_amounts call :GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR ::: '||to_char(GT_TAX_AMT(j))
1929: ||' - '||to_char(GT_TAX_AMT_FUNCL_CURR(j)));
1930: END IF;
1931: END IF;

Line 1934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts.END',

1930: END IF;
1931: END IF;
1932:
1933: IF (g_level_procedure >= g_current_runtime_level ) THEN
1934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts.END',
1935: 'ZX_AR_POPULATE_PKG: get_accounting_amounts(-)');
1936: END IF;
1937:
1938:

Line 2138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',

2134: L_TRX_DIST_CCID NUMBER ;
2135: l_tbl_index_ccid BINARY_INTEGER;
2136: BEGIN
2137: IF (g_level_procedure >= g_current_runtime_level ) THEN
2138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',
2139: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
2140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2141: 'j := '||to_char(j));
2142:

Line 2140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2136: BEGIN
2137: IF (g_level_procedure >= g_current_runtime_level ) THEN
2138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',
2139: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
2140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2141: 'j := '||to_char(j));
2142:
2143: END IF;
2144:

Line 2174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',

2170: LOOP
2171: FETCH trx_ccid INTO l_ccid;
2172:
2173: IF (g_level_procedure >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',
2175: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
2176: END IF;
2177:
2178: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2175: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
2176: END IF;
2177:
2178: IF (g_level_statement >= g_current_runtime_level ) THEN
2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2180: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
2181: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
2182: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2183: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);

Line 2182: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2178: IF (g_level_statement >= g_current_runtime_level ) THEN
2179: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2180: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
2181: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
2182: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2183: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
2184: END IF;
2185: EXIT WHEN trx_ccid%NOTFOUND;
2186:

Line 2323: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2319: END LOOP;
2320:
2321: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
2322: IF (g_level_statement >= g_current_runtime_level ) THEN
2323: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2324: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
2325: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2326: ||'-'||to_char(p_trx_line_id)||'-'||to_char(l_ccid));
2327: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

Line 2327: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2323: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2324: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
2325: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2326: ||'-'||to_char(p_trx_line_id)||'-'||to_char(l_ccid));
2327: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2328: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
2329: END IF;
2330:
2331: OPEN trx_dist_ccid (p_trx_id, p_trx_line_id, p_event_id, p_ae_header_id);

Line 2337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2333: FETCH trx_dist_ccid INTO l_ccid;
2334:
2335: IF trx_dist_ccid%NOTFOUND OR l_ccid IS NULL THEN
2336: IF (g_level_procedure >= g_current_runtime_level ) THEN
2337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2338: 'Cursor trx_dist_ccid Not Found, So open cursor trx_dist_ccid_tax_event');
2339: END IF;
2340: OPEN trx_dist_ccid_tax_event (p_trx_id, p_trx_line_id,p_ledger_id);
2341: FETCH trx_dist_ccid_tax_event INTO l_ccid;

Line 2345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2341: FETCH trx_dist_ccid_tax_event INTO l_ccid;
2342:
2343: IF trx_dist_ccid_tax_event%NOTFOUND OR l_ccid IS NULL THEN
2344: IF (g_level_procedure >= g_current_runtime_level ) THEN
2345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2346: 'Cursor trx_dist_ccid_tax_event Not Found, So open cursor trx_dist_unrev_ccid');
2347: END IF;
2348:
2349: OPEN trx_dist_unrev_ccid (p_trx_id, p_trx_line_id, p_event_id, p_ae_header_id);

Line 2369: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2365:
2366: OPEN tax_dist_ccid (p_trx_id, P_ACTG_SOURCE_ID, p_event_id, p_ae_header_id);
2367: LOOP
2368: IF (g_level_statement >= g_current_runtime_level ) THEN
2369: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2370: 'TRANSACTION DIST LEVEL - tax_dist_ccid : p_trx_id - p_event_id - p_ae_header_id- p_tax_line_id'
2371: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2372: ||'-'||to_char(p_tax_line_id)||'-'||to_char(P_ACTG_SOURCE_ID)||'-'||to_char(l_ccid));
2373: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

Line 2373: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

2369: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2370: 'TRANSACTION DIST LEVEL - tax_dist_ccid : p_trx_id - p_event_id - p_ae_header_id- p_tax_line_id'
2371: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2372: ||'-'||to_char(p_tax_line_id)||'-'||to_char(P_ACTG_SOURCE_ID)||'-'||to_char(l_ccid));
2373: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2374: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
2375: END IF;
2376:
2377: FETCH tax_dist_ccid INTO l_ccid;

Line 2417: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2413: GT_ACCOUNT_FLEXFIELD(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_VAL;
2414: GT_ACCOUNT_DESCRIPTION(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_DESC;
2415:
2416: IF (g_level_procedure >= g_current_runtime_level ) THEN
2417: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2418: 'From Cache :: Hash = '||l_tbl_index_ccid);
2419: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2420: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2419: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2415:
2416: IF (g_level_procedure >= g_current_runtime_level ) THEN
2417: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2418: 'From Cache :: Hash = '||l_tbl_index_ccid);
2419: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2420: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2422: 'From Cache :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2423: END IF;

Line 2421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2417: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2418: 'From Cache :: Hash = '||l_tbl_index_ccid);
2419: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2420: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2422: 'From Cache :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2423: END IF;
2424: ELSE
2425:

Line 2449: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2445: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).BALSEG_VAL := NULL;
2446: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := NULL;
2447:
2448: IF (g_level_procedure >= g_current_runtime_level ) THEN
2449: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2450: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2451: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2452: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2451: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2447:
2448: IF (g_level_procedure >= g_current_runtime_level ) THEN
2449: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2450: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2451: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2452: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2454: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2455: END IF;

Line 2453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2449: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2450: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2451: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2452: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2454: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2455: END IF;
2456:
2457: END IF; --Cache Exists Check

Line 2478: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2474: GT_TRX_ARAP_BALANCING_SEGMENT(j) := GT_TRX_TAXABLE_BAL_SEG(j);
2475: GT_TRX_ARAP_NATURAL_ACCOUNT(j) := GT_TRX_TAXABLE_NATURAL_ACCOUNT(j);
2476:
2477: IF (g_level_procedure >= g_current_runtime_level ) THEN
2478: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2479: 'From Cache :: Hash = '||l_tbl_index_ccid);
2480: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2481: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2480: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2476:
2477: IF (g_level_procedure >= g_current_runtime_level ) THEN
2478: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2479: 'From Cache :: Hash = '||l_tbl_index_ccid);
2480: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2481: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2483: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2484: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2478: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2479: 'From Cache :: Hash = '||l_tbl_index_ccid);
2480: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2481: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2483: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2484: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2485: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2486: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2484: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2480: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2481: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2483: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2484: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2485: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2486: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2487: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2488: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2486: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2483: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2484: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2485: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2486: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2487: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2488: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2489: 'From Cache :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
2490: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2488: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2484: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2485: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2486: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2487: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2488: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2489: 'From Cache :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
2490: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2491: 'From Cache :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
2492: END IF;

Line 2490: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2486: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2487: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2488: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2489: 'From Cache :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
2490: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2491: 'From Cache :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
2492: END IF;
2493: ELSE
2494:

Line 2565: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2561: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := GT_TRX_TAXABLE_NATURAL_ACCOUNT(j);
2562: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_DESC := GT_TRX_TAXABLE_NATACCT_DESC(j);
2563:
2564: IF (g_level_procedure >= g_current_runtime_level ) THEN
2565: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2566: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2567: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2568: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2569: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2567: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2563:
2564: IF (g_level_procedure >= g_current_runtime_level ) THEN
2565: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2566: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2567: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2568: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2569: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2570: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2569: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2565: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2566: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
2567: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2568: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2569: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2570: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2572: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
2573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2567: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2568: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2569: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2570: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2572: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
2573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2574: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2569: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2570: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2572: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
2573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2574: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2576: 'From FA_RX_FLEX_PKG :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
2577: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

Line 2575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2572: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
2573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2574: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2576: 'From FA_RX_FLEX_PKG :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
2577: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2578: 'From FA_RX_FLEX_PKG :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2579: END IF;

Line 2577: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',

2573: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2574: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
2575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2576: 'From FA_RX_FLEX_PKG :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
2577: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2578: 'From FA_RX_FLEX_PKG :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
2579: END IF;
2580: END IF; --Cache Exists Check
2581: END IF ; --TRX CCID Null Check

Line 2586: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.END',

2582:
2583: END IF; -- Summary Level
2584:
2585: IF (g_level_procedure >= g_current_runtime_level ) THEN
2586: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.END',
2587: 'ZX_AR_POPULATE_PKG: inv_segment_info(-)');
2588: END IF;
2589:
2590: END inv_segment_info;

Line 2774: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.BEGIN',

2770:
2771: BEGIN
2772:
2773: IF (g_level_procedure >= g_current_runtime_level ) THEN
2774: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.BEGIN',
2775: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(+)');
2776: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2777: 'ZX_AR_POPULATE_PKG: inv_actg_amounts :'|| to_char(p_ledger_id));
2778: END IF;

Line 2776: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',

2772:
2773: IF (g_level_procedure >= g_current_runtime_level ) THEN
2774: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.BEGIN',
2775: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(+)');
2776: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2777: 'ZX_AR_POPULATE_PKG: inv_actg_amounts :'|| to_char(p_ledger_id));
2778: END IF;
2779:
2780: IF p_summary_level = 'TRANSACTION' THEN

Line 2786: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',

2782: FETCH taxable_amount_hdr INTO GT_TAXABLE_AMT(j),GT_TAXABLE_AMT_FUNCL_CURR(j);
2783: -- EXIT WHEN taxable_amount_hdr%NOTFOUND;
2784: CLOSE taxable_amount_hdr;
2785: IF (g_level_statement >= g_current_runtime_level ) THEN
2786: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2787: 'GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR'||to_char(GT_TAXABLE_AMT(j))
2788: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
2789: END IF;
2790:

Line 2797: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',

2793: FETCH tax_amount_hdr INTO GT_TAX_AMT(j),GT_TAX_AMT_FUNCL_CURR(j);
2794: -- EXIT WHEN tax_amount_hdr%NOTFOUND;
2795: CLOSE tax_amount_hdr;
2796: IF (g_level_statement >= g_current_runtime_level ) THEN
2797: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2798: 'GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR'||to_char(GT_TAX_AMT(j))
2799: ||'-'||to_char(GT_TAX_AMT_FUNCL_CURR(j)));
2800: END IF;
2801:

Line 2816: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',

2812:
2813: ELSIF p_summary_level = 'TRANSACTION_DISTRIBUTION' THEN
2814:
2815: IF (g_level_statement >= g_current_runtime_level ) THEN
2816: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2817: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
2818: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2819: ||'-'||to_char(p_trx_line_id));
2820: END IF;

Line 2828: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',

2824: -- EXIT WHEN taxable_amount_dist%NOTFOUND;
2825: CLOSE taxable_amount_dist;
2826:
2827: IF (g_level_statement >= g_current_runtime_level ) THEN
2828: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2829: 'GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR'||to_char(GT_TAXABLE_AMT(j))
2830: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
2831: END IF;
2832:

Line 2840: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',

2836: -- EXIT WHEN tax_amount_dist%NOTFOUND;
2837: CLOSE tax_amount_dist;
2838:
2839: IF (g_level_statement >= g_current_runtime_level ) THEN
2840: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2841: 'GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR'||to_char(GT_TAX_AMT(j))
2842: ||'-'||to_char(GT_TAX_AMT_FUNCL_CURR(j)));
2843: END IF;
2844:

Line 2848: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.END',

2844:
2845: END IF;
2846:
2847: IF (g_level_procedure >= g_current_runtime_level ) THEN
2848: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.END',
2849: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(-)');
2850: END IF;
2851:
2852: END inv_actg_amounts;

Line 3009: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info.BEGIN',

3005: l_tbl_index_ccid BINARY_INTEGER;
3006: BEGIN
3007:
3008: IF (g_level_procedure >= g_current_runtime_level ) THEN
3009: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info.BEGIN',
3010: 'ZX_AR_POPULATE_PKG: other_trx_segment_info(+)');
3011: END IF;
3012:
3013: GT_TRX_ARAP_BALANCING_SEGMENT(j) := NULL;

Line 3104: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',

3100:
3101: END LOOP;
3102: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
3103: IF (g_level_statement >= g_current_runtime_level ) THEN
3104: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',
3105: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
3106: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
3107: ||'-'||to_char(p_trx_line_id)||'-'||to_char(l_ccid));
3108: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',

Line 3108: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',

3104: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',
3105: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
3106: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
3107: ||'-'||to_char(p_trx_line_id)||'-'||to_char(l_ccid));
3108: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',
3109: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
3110: END IF;
3111:
3112: IF p_event_id IS NOT NULL AND p_ae_header_id IS NOT NULL THEN

Line 3150: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',

3146: CLOSE trx_dist_ccid_adj;
3147: END IF;
3148:
3149: IF (g_level_statement >= g_current_runtime_level ) THEN
3150: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',
3151: 'Done Closing trx_dist_ccid_ cursors');
3152: END IF;
3153:
3154: BEGIN

Line 3211: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',

3207: EXECUTE IMMEDIATE L_SQL_STATEMENT1 INTO L_BAL_SEG_VAL, L_ACCT_SEG_VAL
3208: USING l_ccid;
3209:
3210: IF (g_level_statement >= g_current_runtime_level ) THEN
3211: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',
3212: 'Tax Line : trx id - P_ACTG_SOURCE_ID- ccid :' ||to_char(p_trx_id)
3213: ||'-'||to_char(P_ACTG_SOURCE_ID)||'-'||to_char(l_ccid)||'-'||L_BAL_SEG_VAL);
3214: END IF;
3215:

Line 3256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3252: GT_ACCOUNT_FLEXFIELD(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_VAL;
3253: GT_ACCOUNT_DESCRIPTION(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_DESC;
3254:
3255: IF (g_level_procedure >= g_current_runtime_level ) THEN
3256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3257: 'From Cache :: Hash = '||l_tbl_index_ccid);
3258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3259: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3254:
3255: IF (g_level_procedure >= g_current_runtime_level ) THEN
3256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3257: 'From Cache :: Hash = '||l_tbl_index_ccid);
3258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3259: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3261: 'From Cache :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
3262: END IF;

Line 3260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3257: 'From Cache :: Hash = '||l_tbl_index_ccid);
3258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3259: 'From Cache :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3261: 'From Cache :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
3262: END IF;
3263: ELSE
3264:

Line 3287: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3283: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).BALSEG_VAL := NULL;
3284: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := NULL;
3285:
3286: IF (g_level_procedure >= g_current_runtime_level ) THEN
3287: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3288: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
3289: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3290: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3289: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3285:
3286: IF (g_level_procedure >= g_current_runtime_level ) THEN
3287: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3288: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
3289: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3290: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3292: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
3293: END IF;

Line 3291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3287: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3288: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
3289: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3290: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3292: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
3293: END IF;
3294:
3295: END IF; --Cache Exists Check

Line 3316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3312: GT_TRX_ARAP_BALANCING_SEGMENT(j) := GT_TRX_TAXABLE_BAL_SEG(j);
3313: GT_TRX_ARAP_NATURAL_ACCOUNT(j) := GT_TRX_TAXABLE_NATURAL_ACCOUNT(j);
3314:
3315: IF (g_level_procedure >= g_current_runtime_level ) THEN
3316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3317: 'From Cache :: Hash = '||l_tbl_index_ccid);
3318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3319: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3314:
3315: IF (g_level_procedure >= g_current_runtime_level ) THEN
3316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3317: 'From Cache :: Hash = '||l_tbl_index_ccid);
3318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3319: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3321: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3317: 'From Cache :: Hash = '||l_tbl_index_ccid);
3318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3319: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3321: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3323: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3319: 'From Cache :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3321: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3323: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3325: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
3326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3321: 'From Cache :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3323: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3325: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
3326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3327: 'From Cache :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
3328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3323: 'From Cache :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3325: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
3326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3327: 'From Cache :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
3328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3329: 'From Cache :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
3330: END IF;

Line 3328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3325: 'From Cache :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
3326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3327: 'From Cache :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
3328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3329: 'From Cache :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
3330: END IF;
3331: ELSE
3332:

Line 3403: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3399: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_VAL := GT_TRX_TAXABLE_NATURAL_ACCOUNT(j);
3400: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).NATACCT_DESC := GT_TRX_TAXABLE_NATACCT_DESC(j);
3401:
3402: IF (g_level_procedure >= g_current_runtime_level ) THEN
3403: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3404: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
3405: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3406: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3405: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3401:
3402: IF (g_level_procedure >= g_current_runtime_level ) THEN
3403: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3404: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
3405: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3406: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3408: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3409: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3403: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3404: 'From FA_RX_FLEX_PKG :: Hash = '||l_tbl_index_ccid);
3405: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3406: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3408: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3409: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3410: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
3411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3409: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3405: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3406: 'From FA_RX_FLEX_PKG :: Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3408: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3409: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3410: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
3411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3412: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3407: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3408: 'From FA_RX_FLEX_PKG :: Account Description = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
3409: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3410: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
3411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3412: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3414: 'From FA_RX_FLEX_PKG :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
3415: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

Line 3413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3409: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3410: 'From FA_RX_FLEX_PKG :: Balancing Seg Val = '||GT_TRX_TAXABLE_BAL_SEG(j));
3411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3412: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3414: 'From FA_RX_FLEX_PKG :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
3415: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3416: 'From FA_RX_FLEX_PKG :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
3417: END IF;

Line 3415: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',

3411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3412: 'From FA_RX_FLEX_PKG :: Balancing Seg Description = '||GT_TRX_TAXABLE_BALSEG_DESC(j));
3413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3414: 'From FA_RX_FLEX_PKG :: Natural Seg Val = '||GT_TRX_TAXABLE_NATURAL_ACCOUNT(j));
3415: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3416: 'From FA_RX_FLEX_PKG :: Natural Seg Description = '||GT_TRX_TAXABLE_NATACCT_DESC(j));
3417: END IF;
3418: END IF; --Cache Exists Check
3419: END IF; --l_trx_dist_ccid not null Check

Line 3434: -- FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.other_trx_segment_info',

3430: -- P_QUALIFIER => 'ALL',
3431: -- P_CCID => l_trx_dist_ccid);
3432: --
3433: -- IF (g_level_statement >= g_current_runtime_level ) THEN
3434: -- FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.other_trx_segment_info',
3435: -- 'other_trx_segment_info : GT_TRX_CONTROL_ACCFLEXFIELD(j) = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3436: -- END IF;
3437: -- END IF ;
3438:

Line 3443: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info.END',

3439: ---- End of accounting flexfield population -----------------------
3440:
3441: END IF; -- Summary Level
3442: IF (g_level_procedure >= g_current_runtime_level ) THEN
3443: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info.END',
3444: 'ZX_AR_POPULATE_PKG: other_trx_segment_info(-)');
3445: END IF;
3446:
3447: END other_trx_segment_info;

Line 3600: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts.BEGIN',

3596: AND ael.application_id = aeh.application_id;
3597:
3598: BEGIN
3599: IF (g_level_procedure >= g_current_runtime_level ) THEN
3600: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts.BEGIN',
3601: 'ZX_AR_POPULATE_PKG: other_trx_actg_amounts(+)');
3602: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts',
3603: 'p_trx_id - p_event_id - p_ae_header_id- p_actg_source_id- p_ledger_id '
3604: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)

Line 3602: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts',

3598: BEGIN
3599: IF (g_level_procedure >= g_current_runtime_level ) THEN
3600: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts.BEGIN',
3601: 'ZX_AR_POPULATE_PKG: other_trx_actg_amounts(+)');
3602: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts',
3603: 'p_trx_id - p_event_id - p_ae_header_id- p_actg_source_id- p_ledger_id '
3604: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
3605: ||'-'||to_char(p_actg_source_id)||'-'||to_char(p_ledger_id));
3606: END IF;

Line 3649: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.other_trx_actg_amounts',

3645:
3646: -- EXIT WHEN taxable_amount_dist%NOTFOUND;
3647: IF GT_TAXABLE_AMT(j) IS NULL OR GT_TAXABLE_AMT_FUNCL_CURR(j) IS NULL THEN
3648: IF (g_level_statement >= g_current_runtime_level ) THEN
3649: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_POPULATE_PKG.other_trx_actg_amounts',
3650: 'GT_TAXABLE_AMT(j) IS NULL OR GT_TAXABLE_AMT_FUNCL_CURR(j) IS NULL');
3651: END IF;
3652: END IF;
3653:

Line 3662: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts.END',

3658: CLOSE tax_amount_dist;
3659: END IF;
3660:
3661: IF (g_level_procedure >= g_current_runtime_level ) THEN
3662: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts.END',
3663: 'ZX_AR_POPULATE_PKG: other_trx_actg_amounts(-)');
3664: END IF;
3665:
3666: END other_trx_actg_amounts;

Line 3700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts.BEGIN',

3696: l_TAX_ACCOUNTED_AMOUNT number;
3697: BEGIN
3698:
3699: IF (g_level_procedure >= g_current_runtime_level ) THEN
3700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts.BEGIN',
3701: 'ZX_AR_POPULATE_PKG: convert_amounts(+)');
3702: END IF;
3703:
3704: BEGIN

Line 3709: FND_LOG.STRING(g_level_unexpected,

3705: mo_global.set_policy_context('S',GT_INTERNAL_ORGANIZATION_ID(i));
3706: EXCEPTION WHEN OTHERS THEN
3707: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3708: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3709: FND_LOG.STRING(g_level_unexpected,
3710: 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts-Exception Setting Policy Context ',
3711: g_error_buffer);
3712: END IF;
3713: END;

Line 3773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts.END',

3769: GT_TAXABLE_AMT_FUNCL_CURR(i) := l_TAXABLE_ACCOUNTED_AMOUNT;
3770:
3771:
3772: IF (g_level_procedure >= g_current_runtime_level ) THEN
3773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts.END',
3774: 'ZX_AR_POPULATE_PKG: convert_amounts(-)');
3775: END IF;
3776:
3777: EXCEPTION

Line 3784: FND_LOG.STRING(g_level_unexpected,

3780: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3781: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3782: FND_MSG_PUB.Add;
3783: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3784: FND_LOG.STRING(g_level_unexpected,
3785: 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts',
3786: g_error_buffer);
3787: END IF;
3788:

Line 3909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',

3905:
3906: BEGIN
3907:
3908: IF (g_level_procedure >= g_current_runtime_level ) THEN
3909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
3910: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
3911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3912: 'gt_historical_flag :' ||gt_historical_flag(i));
3913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

3907:
3908: IF (g_level_procedure >= g_current_runtime_level ) THEN
3909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
3910: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
3911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3912: 'gt_historical_flag :' ||gt_historical_flag(i));
3913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3914: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
3915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

3909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
3910: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
3911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3912: 'gt_historical_flag :' ||gt_historical_flag(i));
3913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3914: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
3915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3916: 'GT_BILLING_TP_SITE_ID :' ||to_char(GT_BILLING_TP_SITE_ID(i)));
3917: END IF;

Line 3915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

3911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3912: 'gt_historical_flag :' ||gt_historical_flag(i));
3913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3914: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
3915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3916: 'GT_BILLING_TP_SITE_ID :' ||to_char(GT_BILLING_TP_SITE_ID(i)));
3917: END IF;
3918:
3919:

Line 3929: FND_LOG.STRING(g_level_statement,

3925: l_bill_to_acct_site_id := GT_BILLING_TP_SITE_ID(i);
3926: l_bill_to_acct_id := GT_BILLING_TP_ID(i);
3927:
3928: IF (g_level_statement >= g_current_runtime_level ) THEN
3929: FND_LOG.STRING(g_level_statement,
3930: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3931: 'party_site_id_cur : l_bill_to_site_id '||to_char(l_bill_to_acct_site_id));
3932: END IF;
3933:

Line 3946: FND_LOG.STRING(g_level_statement,

3942:
3943: l_tbl_index_cust := to_char(l_bill_to_acct_site_id);
3944: --|| to_char(l_bill_to_acct_id);
3945: IF (g_level_statement >= g_current_runtime_level ) THEN
3946: FND_LOG.STRING(g_level_statement,
3947: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3948: 'Before Open cust_acct_cur :'||to_char(l_bill_to_acct_site_id)||'-'||to_char(l_bill_to_acct_id));
3949: END IF;
3950:

Line 3962: FND_LOG.STRING(g_level_statement,

3958: GT_BILL_TO_PARTY_ID(i) := g_cust_bill_ar_tbl(l_tbl_index_cust).BILL_TO_PARTY_ID;
3959: GT_BILL_TO_PARTY_SITE_ID(i) := g_cust_bill_ar_tbl(l_tbl_index_cust).BILL_TO_PARTY_SITE_ID;
3960:
3961: IF (g_level_statement >= g_current_runtime_level ) THEN
3962: FND_LOG.STRING(g_level_statement,
3963: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3964: 'If g_cust_bill_ar_tbl.EXISTS :'||GT_BILLING_TP_NUMBER(i));
3965: END IF;
3966:

Line 3982: FND_LOG.STRING(g_level_statement,

3978: GT_BILL_TO_PARTY_ID(i),
3979: GT_BILL_TO_PARTY_SITE_ID(i);
3980:
3981: IF (g_level_statement >= g_current_runtime_level ) THEN
3982: FND_LOG.STRING(g_level_statement,
3983: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3984: 'After fetch of cust_acct_cur'||GT_BILLING_TP_NUMBER(i)||'-'||GT_BILLING_TP_TAX_REG_NUM(i));
3985: END IF;
3986:

Line 4003: FND_LOG.STRING(g_level_statement,

3999: l_bill_to_pty_site_id := GT_BILL_TO_PARTY_SITE_ID(i);
4000: l_bill_to_party_id := GT_BILL_TO_PARTY_ID(i);
4001:
4002: IF (g_level_statement >= g_current_runtime_level ) THEN
4003: FND_LOG.STRING(g_level_statement,
4004: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4005: 'After assign to g_cust_bill_ar_tbl ');
4006: END IF;
4007:

Line 4013: FND_LOG.STRING(g_level_statement,

4009: -- l_bill_ship, 1,8192);
4010: l_tbl_index_party := to_char(l_bill_to_party_id);
4011:
4012: IF (g_level_statement >= g_current_runtime_level ) THEN
4013: FND_LOG.STRING(g_level_statement,
4014: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : l_tbl_index_party : '
4015: ||to_char(l_tbl_index_party));
4016: END IF;
4017:

Line 4020: FND_LOG.STRING(g_level_statement,

4016: END IF;
4017:
4018: IF g_party_bill_ar_tbl.EXISTS(l_tbl_index_party) THEN
4019: IF (g_level_statement >= g_current_runtime_level ) THEN
4020: FND_LOG.STRING(g_level_statement,
4021: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : exist : ');
4022: END IF;
4023:
4024: GT_BILLING_TP_NAME_ALT(i) := g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NAME_ALT;

Line 4033: FND_LOG.STRING(g_level_statement,

4029: -- GT_BILLING_TP_TAX_REG_NUM(i) := g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_TAX_REG_NUM;
4030:
4031: ELSE
4032: IF (g_level_statement >= g_current_runtime_level ) THEN
4033: FND_LOG.STRING(g_level_statement,
4034: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : not exist : '||to_char(l_bill_to_party_id));
4035: END IF;
4036: OPEN party_cur (l_bill_to_party_id);
4037: FETCH party_cur INTO GT_BILLING_TP_NAME(i),

Line 4087: FND_LOG.STRING(g_level_procedure,

4083: p_account_site_id := GT_BILLING_TP_ADDRESS_ID(i);
4084: p_site_use_id := GT_BILLING_TP_SITE_ID(i);
4085:
4086: IF (g_level_procedure >= g_current_runtime_level ) THEN
4087: FND_LOG.STRING(g_level_procedure,
4088: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4089: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number ');
4090: FND_LOG.STRING(g_level_procedure,
4091: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4090: FND_LOG.STRING(g_level_procedure,

4086: IF (g_level_procedure >= g_current_runtime_level ) THEN
4087: FND_LOG.STRING(g_level_procedure,
4088: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4089: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number ');
4090: FND_LOG.STRING(g_level_procedure,
4091: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4092: 'trx_id : '||GT_TRX_ID(i));
4093: FND_LOG.STRING(g_level_procedure,
4094: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4093: FND_LOG.STRING(g_level_procedure,

4089: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number ');
4090: FND_LOG.STRING(g_level_procedure,
4091: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4092: 'trx_id : '||GT_TRX_ID(i));
4093: FND_LOG.STRING(g_level_procedure,
4094: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4095: 'p_parent_ptp_id : '||p_parent_ptp_id);
4096: FND_LOG.STRING(g_level_procedure,
4097: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4096: FND_LOG.STRING(g_level_procedure,

4092: 'trx_id : '||GT_TRX_ID(i));
4093: FND_LOG.STRING(g_level_procedure,
4094: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4095: 'p_parent_ptp_id : '||p_parent_ptp_id);
4096: FND_LOG.STRING(g_level_procedure,
4097: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4098: 'p_site_ptp_id : '|| p_site_ptp_id);
4099: FND_LOG.STRING(g_level_procedure,
4100: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4099: FND_LOG.STRING(g_level_procedure,

4095: 'p_parent_ptp_id : '||p_parent_ptp_id);
4096: FND_LOG.STRING(g_level_procedure,
4097: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4098: 'p_site_ptp_id : '|| p_site_ptp_id);
4099: FND_LOG.STRING(g_level_procedure,
4100: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4101: 'p_tax_determine_date : '|| p_tax_determine_date);
4102: FND_LOG.STRING(g_level_procedure,
4103: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4102: FND_LOG.STRING(g_level_procedure,

4098: 'p_site_ptp_id : '|| p_site_ptp_id);
4099: FND_LOG.STRING(g_level_procedure,
4100: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4101: 'p_tax_determine_date : '|| p_tax_determine_date);
4102: FND_LOG.STRING(g_level_procedure,
4103: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4104: 'p_account_id : '|| p_account_id);
4105: FND_LOG.STRING(g_level_procedure,
4106: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4105: FND_LOG.STRING(g_level_procedure,

4101: 'p_tax_determine_date : '|| p_tax_determine_date);
4102: FND_LOG.STRING(g_level_procedure,
4103: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4104: 'p_account_id : '|| p_account_id);
4105: FND_LOG.STRING(g_level_procedure,
4106: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4107: 'p_account_site_id : '|| p_account_site_id);
4108: FND_LOG.STRING(g_level_procedure,
4109: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4108: FND_LOG.STRING(g_level_procedure,

4104: 'p_account_id : '|| p_account_id);
4105: FND_LOG.STRING(g_level_procedure,
4106: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4107: 'p_account_site_id : '|| p_account_site_id);
4108: FND_LOG.STRING(g_level_procedure,
4109: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4110: 'p_site_use_id : '|| p_site_use_id);
4111: FND_LOG.STRING(g_level_procedure,
4112: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4111: FND_LOG.STRING(g_level_procedure,

4107: 'p_account_site_id : '|| p_account_site_id);
4108: FND_LOG.STRING(g_level_procedure,
4109: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4110: 'p_site_use_id : '|| p_site_use_id);
4111: FND_LOG.STRING(g_level_procedure,
4112: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4113: 'p_account_Type_Code : '|| p_account_Type_Code);
4114: END IF;
4115:

Line 4139: FND_LOG.STRING(g_level_procedure,

4135: GT_BILLING_SITE_TAX_REG_NUM(i) := GT_BILLING_TP_TAX_REG_NUM(i) ;
4136: END IF;
4137:
4138: IF (g_level_procedure >= g_current_runtime_level ) THEN
4139: FND_LOG.STRING(g_level_procedure,
4140: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4141: 'Stauts: '|| p_return_status);
4142: FND_LOG.STRING(g_level_procedure,
4143: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4142: FND_LOG.STRING(g_level_procedure,

4138: IF (g_level_procedure >= g_current_runtime_level ) THEN
4139: FND_LOG.STRING(g_level_procedure,
4140: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4141: 'Stauts: '|| p_return_status);
4142: FND_LOG.STRING(g_level_procedure,
4143: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4144: 'Registration from API : '||p_zx_registration_rec.registration_number);
4145: FND_LOG.STRING(g_level_procedure,
4146: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4145: FND_LOG.STRING(g_level_procedure,

4141: 'Stauts: '|| p_return_status);
4142: FND_LOG.STRING(g_level_procedure,
4143: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4144: 'Registration from API : '||p_zx_registration_rec.registration_number);
4145: FND_LOG.STRING(g_level_procedure,
4146: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4147: 'GT_BILLING_SITE_TAX_REG_NUM : '||GT_BILLING_SITE_TAX_REG_NUM(i));
4148: END IF ;
4149: EXCEPTION

Line 4156: FND_LOG.STRING(g_level_statement,

4152: End;
4153: END IF; -- GT_BILLING_SITE_TAX_REG_NUM IS NULL
4154:
4155: IF (g_level_statement >= g_current_runtime_level ) THEN
4156: FND_LOG.STRING(g_level_statement,
4157: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4158: 'After assign to g_party_bill_ar_tbl '||g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NUMBER);
4159: END IF;
4160: -- l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_pty_site_id)||

Line 4166: FND_LOG.STRING(g_level_statement,

4162:
4163: l_tbl_index_bill_site := to_char(l_bill_to_pty_site_id);
4164:
4165: IF (g_level_statement >= g_current_runtime_level ) THEN
4166: FND_LOG.STRING(g_level_statement,
4167: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : l_tbl_index_bill_site : '
4168: ||to_char(l_tbl_index_bill_site));
4169: END IF;
4170:

Line 4174: FND_LOG.STRING(g_level_statement,

4170:
4171: IF g_site_bill_ar_tbl.EXISTS(l_tbl_index_bill_site) THEN
4172:
4173: IF (g_level_statement >= g_current_runtime_level ) THEN
4174: FND_LOG.STRING(g_level_statement,
4175: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : exist : ');
4176: END IF;
4177: GT_BILLING_TP_CITY(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_CITY;
4178: GT_BILLING_TP_COUNTY(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_COUNTY;

Line 4189: FND_LOG.STRING(g_level_statement,

4185: GT_BILLING_TP_COUNTRY(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_COUNTRY;
4186: GT_BILLING_TP_POSTAL_CODE(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_POSTAL_CODE;
4187: ELSE
4188: IF (g_level_statement >= g_current_runtime_level ) THEN
4189: FND_LOG.STRING(g_level_statement,
4190: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : not exist : '||to_char(l_bill_to_pty_site_id));
4191: END IF;
4192: OPEN party_site_cur (l_bill_to_pty_site_id);
4193: FETCH party_site_cur INTO GT_BILLING_TP_CITY(i),

Line 4220: FND_LOG.STRING(g_level_statement,

4216:
4217:
4218:
4219: IF (g_level_statement >= g_current_runtime_level ) THEN
4220: FND_LOG.STRING(g_level_statement,
4221: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4222: 'After assign to g_site_bill_ar_tbl '||g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_CITY);
4223: END IF;
4224: END IF;

Line 4232: FND_LOG.STRING(g_level_statement,

4228: l_ship_to_acct_site_id := GT_SHIPPING_TP_SITE_ID(i);
4229: l_ship_to_acct_id := GT_SHIPPING_TP_ID(i);
4230:
4231: IF (g_level_statement >= g_current_runtime_level ) THEN
4232: FND_LOG.STRING(g_level_statement,
4233: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4234: 'party_site_id_cur : l_ship_to_site_id '||to_char(l_ship_to_acct_site_id));
4235: END IF;
4236:

Line 4263: FND_LOG.STRING(g_level_statement,

4259:
4260: -- GT_SHIPPING_SITE_TAX_REG_NUM(i) := g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_SITE_TAX_REG_NUM;
4261:
4262: IF (g_level_statement >= g_current_runtime_level ) THEN
4263: FND_LOG.STRING(g_level_statement,
4264: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4265: 'Exists in the cache g_cust_ship_ar_tbl '||g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER);
4266: END IF;
4267:

Line 4293: FND_LOG.STRING(g_level_statement,

4289:
4290: CLOSE cust_acct_cur;
4291: END IF;
4292: IF (g_level_statement >= g_current_runtime_level ) THEN
4293: FND_LOG.STRING(g_level_statement,
4294: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4295: 'After assign to g_cust_ship_ar_tbl '||g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER);
4296: END IF;
4297:

Line 4307: FND_LOG.STRING(g_level_statement,

4303: -- l_bill_ship, 1,8192);
4304: l_tbl_index_party := to_char(l_ship_to_party_id);
4305:
4306: IF (g_level_statement >= g_current_runtime_level ) THEN
4307: FND_LOG.STRING(g_level_statement,
4308: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : l_tbl_index_party : '
4309: ||to_char(l_tbl_index_party));
4310: END IF;
4311:

Line 4314: FND_LOG.STRING(g_level_statement,

4310: END IF;
4311:
4312: IF g_party_ship_ar_tbl.EXISTS(l_tbl_index_party) THEN
4313: IF (g_level_statement >= g_current_runtime_level ) THEN
4314: FND_LOG.STRING(g_level_statement,
4315: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : exist : ');
4316: END IF;
4317:
4318: GT_SHIPPING_TP_NAME_ALT(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME_ALT;

Line 4326: FND_LOG.STRING(g_level_statement,

4322: GT_SHIPPING_TP_TAXPAYER_ID(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_TAXPAYER_ID;
4323: -- GT_SHIPPING_TP_TAX_REG_NUM(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_TAX_REG_NUM;
4324: ELSE
4325: IF (g_level_statement >= g_current_runtime_level ) THEN
4326: FND_LOG.STRING(g_level_statement,
4327: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : not exist : '||to_char(l_ship_to_party_id));
4328: END IF;
4329: OPEN party_cur (l_ship_to_party_id);
4330: FETCH party_cur INTO GT_SHIPPING_TP_NAME(i),

Line 4399: FND_LOG.STRING(g_level_procedure,

4395: p_account_site_id := GT_SHIPPING_TP_ADDRESS_ID(i);
4396: p_site_use_id := GT_SHIPPING_TP_SITE_ID(i);
4397:
4398: IF (g_level_procedure >= g_current_runtime_level ) THEN
4399: FND_LOG.STRING(g_level_procedure,
4400: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4401: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number : SHIP_TO');
4402: FND_LOG.STRING(g_level_procedure,
4403: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4402: FND_LOG.STRING(g_level_procedure,

4398: IF (g_level_procedure >= g_current_runtime_level ) THEN
4399: FND_LOG.STRING(g_level_procedure,
4400: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4401: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number : SHIP_TO');
4402: FND_LOG.STRING(g_level_procedure,
4403: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4404: 'trx_id : '||GT_TRX_ID(i));
4405: FND_LOG.STRING(g_level_procedure,
4406: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4405: FND_LOG.STRING(g_level_procedure,

4401: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number : SHIP_TO');
4402: FND_LOG.STRING(g_level_procedure,
4403: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4404: 'trx_id : '||GT_TRX_ID(i));
4405: FND_LOG.STRING(g_level_procedure,
4406: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4407: 'p_parent_ptp_id : '||p_parent_ptp_id);
4408: FND_LOG.STRING(g_level_procedure,
4409: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4408: FND_LOG.STRING(g_level_procedure,

4404: 'trx_id : '||GT_TRX_ID(i));
4405: FND_LOG.STRING(g_level_procedure,
4406: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4407: 'p_parent_ptp_id : '||p_parent_ptp_id);
4408: FND_LOG.STRING(g_level_procedure,
4409: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4410: 'p_site_ptp_id : '|| p_site_ptp_id);
4411: FND_LOG.STRING(g_level_procedure,
4412: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4411: FND_LOG.STRING(g_level_procedure,

4407: 'p_parent_ptp_id : '||p_parent_ptp_id);
4408: FND_LOG.STRING(g_level_procedure,
4409: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4410: 'p_site_ptp_id : '|| p_site_ptp_id);
4411: FND_LOG.STRING(g_level_procedure,
4412: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4413: 'p_tax_determine_date : '|| p_tax_determine_date);
4414: FND_LOG.STRING(g_level_procedure,
4415: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4414: FND_LOG.STRING(g_level_procedure,

4410: 'p_site_ptp_id : '|| p_site_ptp_id);
4411: FND_LOG.STRING(g_level_procedure,
4412: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4413: 'p_tax_determine_date : '|| p_tax_determine_date);
4414: FND_LOG.STRING(g_level_procedure,
4415: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4416: 'p_account_id : '|| p_account_id);
4417: FND_LOG.STRING(g_level_procedure,
4418: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4417: FND_LOG.STRING(g_level_procedure,

4413: 'p_tax_determine_date : '|| p_tax_determine_date);
4414: FND_LOG.STRING(g_level_procedure,
4415: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4416: 'p_account_id : '|| p_account_id);
4417: FND_LOG.STRING(g_level_procedure,
4418: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4419: 'p_account_site_id : '|| p_account_site_id);
4420: FND_LOG.STRING(g_level_procedure,
4421: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4420: FND_LOG.STRING(g_level_procedure,

4416: 'p_account_id : '|| p_account_id);
4417: FND_LOG.STRING(g_level_procedure,
4418: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4419: 'p_account_site_id : '|| p_account_site_id);
4420: FND_LOG.STRING(g_level_procedure,
4421: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4422: 'p_site_use_id : '|| p_site_use_id);
4423: FND_LOG.STRING(g_level_procedure,
4424: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4423: FND_LOG.STRING(g_level_procedure,

4419: 'p_account_site_id : '|| p_account_site_id);
4420: FND_LOG.STRING(g_level_procedure,
4421: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4422: 'p_site_use_id : '|| p_site_use_id);
4423: FND_LOG.STRING(g_level_procedure,
4424: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4425: 'p_account_Type_Code : '|| p_account_Type_Code);
4426: END IF;
4427:

Line 4448: FND_LOG.STRING(g_level_procedure,'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

4444: GT_SHIPPING_SITE_TAX_REG_NUM(i) := ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference;
4445: ELSE
4446: GT_SHIPPING_SITE_TAX_REG_NUM(i) := null ;
4447: IF (g_level_procedure >= g_current_runtime_level ) THEN
4448: FND_LOG.STRING(g_level_procedure,'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4449: 'Could not fetch a value for registration number ');
4450: END IF;
4451: END IF;
4452:

Line 4454: FND_LOG.STRING(g_level_procedure,

4450: END IF;
4451: END IF;
4452:
4453: IF (g_level_procedure >= g_current_runtime_level ) THEN
4454: FND_LOG.STRING(g_level_procedure,
4455: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4456: 'Stauts: '|| p_return_status);
4457: FND_LOG.STRING(g_level_procedure,
4458: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4457: FND_LOG.STRING(g_level_procedure,

4453: IF (g_level_procedure >= g_current_runtime_level ) THEN
4454: FND_LOG.STRING(g_level_procedure,
4455: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4456: 'Stauts: '|| p_return_status);
4457: FND_LOG.STRING(g_level_procedure,
4458: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4459: 'Registration: '||p_zx_registration_rec.registration_number);
4460: FND_LOG.STRING(g_level_procedure,
4461: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4460: FND_LOG.STRING(g_level_procedure,

4456: 'Stauts: '|| p_return_status);
4457: FND_LOG.STRING(g_level_procedure,
4458: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4459: 'Registration: '||p_zx_registration_rec.registration_number);
4460: FND_LOG.STRING(g_level_procedure,
4461: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4462: 'Registration from structure : '||GT_SHIPPING_SITE_TAX_REG_NUM(i));
4463: END IF ;
4464: EXCEPTION

Line 4471: FND_LOG.STRING(g_level_statement,

4467: END;
4468: END IF; -- GT_SHIPPING_SITE_TAX_REG_NUM IS NULL
4469:
4470: IF (g_level_statement >= g_current_runtime_level ) THEN
4471: FND_LOG.STRING(g_level_statement,
4472: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4473: 'After assign to g_party_ship_ar_tbl '||g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME);
4474: END IF;
4475:

Line 4481: FND_LOG.STRING(g_level_statement,

4477: -- l_bill_ship, 1,8192);
4478: l_tbl_index_ship_site := to_char(l_ship_to_pty_site_id);
4479:
4480: IF (g_level_statement >= g_current_runtime_level ) THEN
4481: FND_LOG.STRING(g_level_statement,
4482: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : l_tbl_index_ship_site : party site id : acct_site_id : acct_id '
4483: ||l_tbl_index_ship_site ||'-'||to_char(l_ship_to_pty_site_id)||'-'||to_char(l_ship_to_acct_site_id)||'-'||to_char(l_ship_to_acct_id));
4484: END IF;
4485: IF g_site_ship_ar_tbl.EXISTS(l_tbl_index_ship_site) THEN

Line 4487: FND_LOG.STRING(g_level_statement,

4483: ||l_tbl_index_ship_site ||'-'||to_char(l_ship_to_pty_site_id)||'-'||to_char(l_ship_to_acct_site_id)||'-'||to_char(l_ship_to_acct_id));
4484: END IF;
4485: IF g_site_ship_ar_tbl.EXISTS(l_tbl_index_ship_site) THEN
4486: IF (g_level_statement >= g_current_runtime_level ) THEN
4487: FND_LOG.STRING(g_level_statement,
4488: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : exist : ');
4489: END IF;
4490: GT_SHIPPING_TP_CITY(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_CITY;
4491: GT_SHIPPING_TP_COUNTY(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_COUNTY;

Line 4502: FND_LOG.STRING(g_level_statement,

4498: GT_SHIPPING_TP_COUNTRY(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_COUNTRY;
4499: GT_SHIPPING_TP_POSTAL_CODE(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_POSTAL_CODE;
4500: ELSE
4501: IF (g_level_statement >= g_current_runtime_level ) THEN
4502: FND_LOG.STRING(g_level_statement,
4503: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : not exist in Cache : '||to_char(l_ship_to_pty_site_id));
4504: END IF;
4505: OPEN party_site_cur (l_ship_to_pty_site_id);
4506: FETCH party_site_cur INTO GT_SHIPPING_TP_CITY(i),

Line 4529: FND_LOG.STRING(g_level_statement,

4525: g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_POSTAL_CODE := GT_SHIPPING_TP_POSTAL_CODE(i);
4526: CLOSE party_site_cur;
4527: END IF;
4528: IF (g_level_statement >= g_current_runtime_level ) THEN
4529: FND_LOG.STRING(g_level_statement,
4530: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4531: 'After assign to g_site_ship_ar_tbl '||g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_CITY);
4532: END IF;
4533:

Line 4551: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.END',

4547: GT_DOC_SEQ_NAME(i) := NULL;
4548: END IF;
4549:
4550: IF (g_level_procedure >= g_current_runtime_level ) THEN
4551: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.END',
4552: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(-)');
4553: END IF;
4554:
4555: EXCEPTION

Line 4562: FND_LOG.STRING(g_level_unexpected,

4558: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4559: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
4560: FND_MSG_PUB.Add;
4561: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4562: FND_LOG.STRING(g_level_unexpected,
4563: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4564: g_error_buffer);
4565: END IF;
4566:

Line 4599: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_tax_reg_num.BEGIN',

4595: AND c_tax_date between rel.effective_from and nvl(rel.effective_to,c_tax_date);
4596:
4597: BEGIN
4598: IF (g_level_procedure >= g_current_runtime_level ) THEN
4599: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_tax_reg_num.BEGIN',
4600: 'populate_tax_reg_num(+)');
4601: END IF;
4602: OPEN trn_ptp_id_cur (p_org_id,
4603: P_TRL_GLOBAL_VARIABLES_REC.legal_entity_id,

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

4605: FETCH trn_ptp_id_cur into GT_TAX_REG_NUM(i);
4606: CLOSE trn_ptp_id_cur;
4607:
4608: IF (g_level_procedure >= g_current_runtime_level ) THEN
4609: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.END',
4610: 'populate_tax_reg_num(-)');
4611: END IF;
4612: END populate_tax_reg_num;
4613:

Line 4624: FND_LOG.STRING(g_level_procedure,

4620:
4621: BEGIN
4622:
4623: IF (g_level_procedure >= g_current_runtime_level ) THEN
4624: FND_LOG.STRING(g_level_procedure,
4625: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4626: 'populate_meaning(+) ');
4627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4628: 'Value of i : '||i ||' ; '||

Line 4627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

4623: IF (g_level_procedure >= g_current_runtime_level ) THEN
4624: FND_LOG.STRING(g_level_procedure,
4625: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4626: 'populate_meaning(+) ');
4627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4628: 'Value of i : '||i ||' ; '||
4629: 'GT_TRX_ID(i) : '||GT_TRX_ID(i)||' ; '||
4630: 'REGISTER_TYPE : '||GT_TAX_RATE_REG_TYPE_CODE(i)
4631: );

Line 4652: FND_LOG.STRING(g_level_statement,

4648: GT_TRX_CLASS_MNG(i) := l_meaning;
4649: END IF;
4650:
4651: IF (g_level_statement >= g_current_runtime_level ) THEN
4652: FND_LOG.STRING(g_level_statement,
4653: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4654: 'GT_TRX_CLASS : '||GT_TRX_CLASS(i));
4655: FND_LOG.STRING(g_level_statement,
4656: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

Line 4655: FND_LOG.STRING(g_level_statement,

4651: IF (g_level_statement >= g_current_runtime_level ) THEN
4652: FND_LOG.STRING(g_level_statement,
4653: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4654: 'GT_TRX_CLASS : '||GT_TRX_CLASS(i));
4655: FND_LOG.STRING(g_level_statement,
4656: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4657: 'GT_TRX_CLASS_MNG(i) : '||GT_TRX_CLASS_MNG(i));
4658: END IF;
4659:

Line 4680: FND_LOG.STRING(g_level_statement,

4676: GT_TAX_RATE_VAT_TRX_TYPE_MNG(i) := l_meaning;
4677: END IF;
4678:
4679: IF (g_level_statement >= g_current_runtime_level ) THEN
4680: FND_LOG.STRING(g_level_statement,
4681: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4682: 'GT_TAX_RATE_CODE_REG_TYPE_MNG(i) : '||GT_TAX_RATE_CODE_REG_TYPE_MNG(i));
4683: FND_LOG.STRING(g_level_statement,
4684: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

Line 4683: FND_LOG.STRING(g_level_statement,

4679: IF (g_level_statement >= g_current_runtime_level ) THEN
4680: FND_LOG.STRING(g_level_statement,
4681: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4682: 'GT_TAX_RATE_CODE_REG_TYPE_MNG(i) : '||GT_TAX_RATE_CODE_REG_TYPE_MNG(i));
4683: FND_LOG.STRING(g_level_statement,
4684: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4685: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4686: FND_LOG.STRING(g_level_statement,
4687: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

Line 4686: FND_LOG.STRING(g_level_statement,

4682: 'GT_TAX_RATE_CODE_REG_TYPE_MNG(i) : '||GT_TAX_RATE_CODE_REG_TYPE_MNG(i));
4683: FND_LOG.STRING(g_level_statement,
4684: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4685: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4686: FND_LOG.STRING(g_level_statement,
4687: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4688: 'GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_DESC(i));
4689: FND_LOG.STRING(g_level_statement,
4690: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

Line 4689: FND_LOG.STRING(g_level_statement,

4685: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4686: FND_LOG.STRING(g_level_statement,
4687: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4688: 'GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_DESC(i));
4689: FND_LOG.STRING(g_level_statement,
4690: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4691: 'GT_TAX_RATE_VAT_TRX_TYPE_MNG(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_MNG(i));
4692: END IF;
4693:

Line 4705: FND_LOG.STRING(g_level_statement,

4701: END IF;
4702:
4703:
4704: IF (g_level_statement >= g_current_runtime_level ) THEN
4705: FND_LOG.STRING(g_level_statement,
4706: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4707: 'GT_TAX_EXCEPTION_REASON_CODE(i) : '||GT_TAX_EXCEPTION_REASON_CODE(i));
4708: FND_LOG.STRING(g_level_statement,
4709: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

Line 4708: FND_LOG.STRING(g_level_statement,

4704: IF (g_level_statement >= g_current_runtime_level ) THEN
4705: FND_LOG.STRING(g_level_statement,
4706: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4707: 'GT_TAX_EXCEPTION_REASON_CODE(i) : '||GT_TAX_EXCEPTION_REASON_CODE(i));
4708: FND_LOG.STRING(g_level_statement,
4709: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4710: 'GT_TAX_EXCEPTION_REASON_MNG(i) : '||GT_TAX_EXCEPTION_REASON_MNG(i));
4711: END IF;
4712:

Line 4722: FND_LOG.STRING(g_level_statement,

4718: GT_TAX_EXEMPT_REASON_MNG(i) := l_meaning;
4719: END IF;
4720:
4721: IF (g_level_statement >= g_current_runtime_level ) THEN
4722: FND_LOG.STRING(g_level_statement,
4723: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4724: 'GT_EXEMPT_REASON_CODE : '||GT_EXEMPT_REASON_CODE(i));
4725: FND_LOG.STRING(g_level_statement,
4726: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

Line 4725: FND_LOG.STRING(g_level_statement,

4721: IF (g_level_statement >= g_current_runtime_level ) THEN
4722: FND_LOG.STRING(g_level_statement,
4723: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4724: 'GT_EXEMPT_REASON_CODE : '||GT_EXEMPT_REASON_CODE(i));
4725: FND_LOG.STRING(g_level_statement,
4726: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4727: 'GT_TAX_EXEMPT_REASON_MNG(i) : '||GT_TAX_EXEMPT_REASON_MNG(i));
4728: END IF;
4729:

Line 4750: FND_LOG.STRING(g_level_statement,

4746: GT_TAX_TYPE_MNG(i) := l_meaning;
4747: END IF;
4748:
4749: IF (g_level_statement >= g_current_runtime_level ) THEN
4750: FND_LOG.STRING(g_level_statement,
4751: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4752: 'GT_TAX_TYPE_CODE(i) : '||GT_TAX_TYPE_CODE(i));
4753: FND_LOG.STRING(g_level_statement,
4754: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',

Line 4753: FND_LOG.STRING(g_level_statement,

4749: IF (g_level_statement >= g_current_runtime_level ) THEN
4750: FND_LOG.STRING(g_level_statement,
4751: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4752: 'GT_TAX_TYPE_CODE(i) : '||GT_TAX_TYPE_CODE(i));
4753: FND_LOG.STRING(g_level_statement,
4754: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning',
4755: 'GT_TAX_TYPE_MNG(i) : '||GT_TAX_TYPE_MNG(i));
4756: END IF;
4757:

Line 4759: FND_LOG.STRING(g_level_procedure,

4755: 'GT_TAX_TYPE_MNG(i) : '||GT_TAX_TYPE_MNG(i));
4756: END IF;
4757:
4758: IF (g_level_procedure >= g_current_runtime_level ) THEN
4759: FND_LOG.STRING(g_level_procedure,
4760: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.END',
4761: 'populate_meaning(-) ');
4762: END IF;
4763:

Line 4786: FND_LOG.STRING(g_level_procedure,'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj.BEGIN',

4782: WHERE tax_rate_id = c_tax_rate_id;
4783:
4784: BEGIN
4785: IF (g_level_procedure >= g_current_runtime_level ) THEN
4786: FND_LOG.STRING(g_level_procedure,'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj.BEGIN',
4787: 'get_tax_rate_info_dist_adj(+) ');
4788: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4789: 'Value of i : '||i ||' ; '||
4790: 'GT_TRX_ID(i) : '||GT_TRX_ID(i)||' ; '||

Line 4788: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4784: BEGIN
4785: IF (g_level_procedure >= g_current_runtime_level ) THEN
4786: FND_LOG.STRING(g_level_procedure,'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj.BEGIN',
4787: 'get_tax_rate_info_dist_adj(+) ');
4788: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4789: 'Value of i : '||i ||' ; '||
4790: 'GT_TRX_ID(i) : '||GT_TRX_ID(i)||' ; '||
4791: 'GT_TAX_RATE_ID(i) : '||GT_TAX_RATE_ID(i));
4792: END IF;

Line 4808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4804: GT_TAX_JURISDICTION_CODE(i);
4805: CLOSE tax_rate_name_cur;
4806:
4807: IF (g_level_procedure >= g_current_runtime_level ) THEN
4808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4809: 'GT_TAX_RATE_CODE(i) : '||GT_TAX_RATE_CODE(i));
4810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4811: 'GT_TAX_RATE_CODE_NAME(i) : '||GT_TAX_RATE_CODE_NAME(i));
4812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4806:
4807: IF (g_level_procedure >= g_current_runtime_level ) THEN
4808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4809: 'GT_TAX_RATE_CODE(i) : '||GT_TAX_RATE_CODE(i));
4810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4811: 'GT_TAX_RATE_CODE_NAME(i) : '||GT_TAX_RATE_CODE_NAME(i));
4812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4813: 'GT_TAX_RATE_CODE_DESCRIPTION(i) : '||GT_TAX_RATE_CODE_DESCRIPTION(i));
4814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4808: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4809: 'GT_TAX_RATE_CODE(i) : '||GT_TAX_RATE_CODE(i));
4810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4811: 'GT_TAX_RATE_CODE_NAME(i) : '||GT_TAX_RATE_CODE_NAME(i));
4812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4813: 'GT_TAX_RATE_CODE_DESCRIPTION(i) : '||GT_TAX_RATE_CODE_DESCRIPTION(i));
4814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4815: 'GT_TAX_RATE(i) : '||GT_TAX_RATE(i));
4816: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4810: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4811: 'GT_TAX_RATE_CODE_NAME(i) : '||GT_TAX_RATE_CODE_NAME(i));
4812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4813: 'GT_TAX_RATE_CODE_DESCRIPTION(i) : '||GT_TAX_RATE_CODE_DESCRIPTION(i));
4814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4815: 'GT_TAX_RATE(i) : '||GT_TAX_RATE(i));
4816: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4817: 'GT_DEF_REC_SETTLEMENT_OPT_CODE(i) : '||GT_DEF_REC_SETTLEMENT_OPT_CODE(i));
4818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4816: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4813: 'GT_TAX_RATE_CODE_DESCRIPTION(i) : '||GT_TAX_RATE_CODE_DESCRIPTION(i));
4814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4815: 'GT_TAX_RATE(i) : '||GT_TAX_RATE(i));
4816: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4817: 'GT_DEF_REC_SETTLEMENT_OPT_CODE(i) : '||GT_DEF_REC_SETTLEMENT_OPT_CODE(i));
4818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4819: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4815: 'GT_TAX_RATE(i) : '||GT_TAX_RATE(i));
4816: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4817: 'GT_DEF_REC_SETTLEMENT_OPT_CODE(i) : '||GT_DEF_REC_SETTLEMENT_OPT_CODE(i));
4818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4819: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4821: 'GT_TAX_REGIME_CODE(i) : '||GT_TAX_REGIME_CODE(i));
4822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4816: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4817: 'GT_DEF_REC_SETTLEMENT_OPT_CODE(i) : '||GT_DEF_REC_SETTLEMENT_OPT_CODE(i));
4818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4819: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4821: 'GT_TAX_REGIME_CODE(i) : '||GT_TAX_REGIME_CODE(i));
4822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4823: 'GT_TAX(i) : '||GT_TAX(i));
4824: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4819: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4821: 'GT_TAX_REGIME_CODE(i) : '||GT_TAX_REGIME_CODE(i));
4822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4823: 'GT_TAX(i) : '||GT_TAX(i));
4824: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4825: 'GT_TAX_STATUS_CODE(i) : '||GT_TAX_STATUS_CODE(i));
4826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

Line 4824: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4821: 'GT_TAX_REGIME_CODE(i) : '||GT_TAX_REGIME_CODE(i));
4822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4823: 'GT_TAX(i) : '||GT_TAX(i));
4824: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4825: 'GT_TAX_STATUS_CODE(i) : '||GT_TAX_STATUS_CODE(i));
4826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4827: 'GT_TAX_JURISDICTION_CODE(i) : '||GT_TAX_JURISDICTION_CODE(i));
4828: END IF;

Line 4826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',

4822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4823: 'GT_TAX(i) : '||GT_TAX(i));
4824: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4825: 'GT_TAX_STATUS_CODE(i) : '||GT_TAX_STATUS_CODE(i));
4826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_tax_rate_info_dist_adj',
4827: 'GT_TAX_JURISDICTION_CODE(i) : '||GT_TAX_JURISDICTION_CODE(i));
4828: END IF;
4829: END get_tax_rate_info_dist_adj;
4830:

Line 4837: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T.BEGIN',

4833: i number;
4834: BEGIN
4835:
4836: IF (g_level_procedure >= g_current_runtime_level ) THEN
4837: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T.BEGIN',
4838: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');
4839: END IF;
4840:
4841: FORALL i in 1..p_count

Line 4930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T.END',

4926: TAX_RATE_CODE_DESCRIPTION = nvl(TAX_RATE_CODE_DESCRIPTION,GT_TAX_RATE_CODE_DESCRIPTION(i))
4927: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
4928:
4929: IF (g_level_procedure >= g_current_runtime_level ) THEN
4930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T.END',
4931: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(-)');
4932: END IF;
4933:
4934:

Line 4942: FND_LOG.STRING(g_level_unexpected,

4938: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4939: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
4940: FND_MSG_PUB.Add;
4941: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4942: FND_LOG.STRING(g_level_unexpected,
4943: 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T',
4944: g_error_buffer);
4945: END IF;
4946:

Line 4977: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info.BEGIN',

4973:
4974: BEGIN
4975:
4976: IF (g_level_procedure >= g_current_runtime_level ) THEN
4977: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info.BEGIN',
4978: 'ZX_AR_ACTG_EXTRACT_PKG: insert_actg_info(+)');
4979: END IF;
4980:
4981: l_count := P_COUNT;

Line 4984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info',

4980:
4981: l_count := P_COUNT;
4982:
4983: IF (g_level_procedure >= g_current_runtime_level ) THEN
4984: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info',
4985: ' Record Count = ' ||to_char(P_COUNT));
4986: END IF;
4987:
4988:

Line 5087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info',

5083: g_request_id,
5084: GT_TRX_CONTROL_ACCFLEXFIELD(i)); --Bug 5510907
5085:
5086: IF (g_level_procedure >= g_current_runtime_level ) THEN
5087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info',
5088: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
5089:
5090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info.END',
5091: 'ZX_AR_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

Line 5090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info.END',

5086: IF (g_level_procedure >= g_current_runtime_level ) THEN
5087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info',
5088: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
5089:
5090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info.END',
5091: 'ZX_AR_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');
5092: END IF;
5093:
5094: EXCEPTION

Line 5101: FND_LOG.STRING(g_level_unexpected,

5097: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
5098: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
5099: FND_MSG_PUB.Add;
5100: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5101: FND_LOG.STRING(g_level_unexpected,
5102: 'ZX.TRL.ZX_AR_POPULATE_PKG.insert_actg_info',
5103: g_error_buffer);
5104: END IF;
5105:

Line 5117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.BEGIN',

5113:
5114: BEGIN
5115:
5116: IF (g_level_procedure >= g_current_runtime_level ) THEN
5117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.BEGIN',
5118: 'ZX_AR_POPULATE_PKG: initialize_variables(+)');
5119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',
5120: 'p_count : '||to_char(p_count));
5121: END IF;

Line 5119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',

5115:
5116: IF (g_level_procedure >= g_current_runtime_level ) THEN
5117: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.BEGIN',
5118: 'ZX_AR_POPULATE_PKG: initialize_variables(+)');
5119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',
5120: 'p_count : '||to_char(p_count));
5121: END IF;
5122:
5123: FOR i IN 1.. p_count LOOP

Line 5286: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.END',

5282:
5283: END LOOP;
5284:
5285: IF (g_level_procedure >= g_current_runtime_level ) THEN
5286: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.END',
5287: 'ZX_AR_POPULATE_PKG: initialize_variables(-)');
5288: END IF;
5289:
5290: EXCEPTION

Line 5297: FND_LOG.STRING(g_level_unexpected,

5293: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
5294: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
5295: FND_MSG_PUB.Add;
5296: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5297: FND_LOG.STRING(g_level_unexpected,
5298: 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',
5299: g_error_buffer);
5300: END IF;
5301: