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

247: C_LINES_PER_COMMIT CONSTANT NUMBER := 5000;
248: L_MSG VARCHAR2(500);
249: G_REP_CONTEXT_ID NUMBER;
250: g_current_runtime_level NUMBER;
251: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
252: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
253: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
254: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
255: g_error_buffer VARCHAR2(100);

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

248: L_MSG VARCHAR2(500);
249: G_REP_CONTEXT_ID NUMBER;
250: g_current_runtime_level NUMBER;
251: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
252: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
253: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
254: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
255: g_error_buffer VARCHAR2(100);
256:

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

249: G_REP_CONTEXT_ID NUMBER;
250: g_current_runtime_level NUMBER;
251: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
252: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
253: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
254: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
255: g_error_buffer VARCHAR2(100);
256:
257: PROCEDURE convert_amounts(P_CURRENCY_CODE IN VARCHAR2,

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

250: g_current_runtime_level NUMBER;
251: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
252: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
253: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
254: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
255: g_error_buffer VARCHAR2(100);
256:
257: PROCEDURE convert_amounts(P_CURRENCY_CODE IN VARCHAR2,
258: P_EXCHANGE_RATE IN NUMBER,

Line 928: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

924: j number;
925:
926: BEGIN
927:
928: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
929: g_request_id := P_TRL_GLOBAL_VARIABLES_REC.request_id;
930: l_ledger_id := P_TRL_GLOBAL_VARIABLES_REC.ledger_id;
931: g_coa_id := P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id;
932:

Line 934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.BEGIN',

930: l_ledger_id := P_TRL_GLOBAL_VARIABLES_REC.ledger_id;
931: g_coa_id := P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id;
932:
933: IF (g_level_procedure >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.BEGIN',
935: 'ZX_AR_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(+)');
936: END IF;
937:
938: -- get functional currency code code --

Line 1076: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.Dist cursor Opened',

1072: gt_tax_determine_date
1073: LIMIT C_LINES_PER_COMMIT;
1074:
1075: IF (g_level_procedure >= g_current_runtime_level ) THEN
1076: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.Dist cursor Opened',
1077: 'detail_t_cur : ');
1078: END IF;
1079:
1080: ELSE

Line 1176: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.Trx / Line cursor Opened',

1172: gt_tax_determine_date
1173: LIMIT C_LINES_PER_COMMIT;
1174:
1175: IF (g_level_procedure >= g_current_runtime_level ) THEN
1176: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.Trx / Line cursor Opened',
1177: 'detail_t_cur_trx_line : ');
1178: END IF;
1179: END IF;
1180:

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

1183:
1184: -- Initialize j value for accounting records count --
1185: j:=0;
1186: IF (g_level_procedure >= g_current_runtime_level ) THEN
1187: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',
1188: 'Row Count After fetch : ' ||to_char(l_count));
1189: END IF;
1190:
1191: IF l_count >0 THEN

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

1198: LOOP
1199: L_TRX_CLASS := GT_TRX_CLASS(i);
1200:
1201: IF (g_level_procedure >= g_current_runtime_level ) THEN
1202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1203: 'Inside Loop : detail tax line id:'||to_char(gt_detail_tax_line_id(i)));
1204: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1205: 'i : '||to_char(i)||' L_TRX_CLASS : '||L_TRX_CLASS);
1206: END IF;

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

1200:
1201: IF (g_level_procedure >= g_current_runtime_level ) THEN
1202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1203: 'Inside Loop : detail tax line id:'||to_char(gt_detail_tax_line_id(i)));
1204: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1205: 'i : '||to_char(i)||' L_TRX_CLASS : '||L_TRX_CLASS);
1206: END IF;
1207:
1208: IF P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION'

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

1238:
1239: IF p_trl_global_variables_rec.include_accounting_segments='Y' THEN
1240:
1241: IF (g_level_procedure >= g_current_runtime_level ) THEN
1242: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1243: 'get_accounting_info Call:');
1244: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1245: 'detail tax line id:'||to_char(gt_detail_tax_line_id(i)));
1246: END IF;

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

1240:
1241: IF (g_level_procedure >= g_current_runtime_level ) THEN
1242: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1243: 'get_accounting_info Call:');
1244: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1245: 'detail tax line id:'||to_char(gt_detail_tax_line_id(i)));
1246: END IF;
1247:
1248: j:=j+1;

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

1303: p_trl_global_variables_rec.reporting_ledger_id, --l_ledger_id,
1304: i) ;
1305: END IF;
1306: IF (g_level_procedure >= g_current_runtime_level ) THEN
1307: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1308: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR'||to_char(GT_TAXABLE_AMT(i))||
1309: 'i='||to_char(i)||' j='||to_char(i)
1310: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(i)));
1311: END IF;

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

1368:
1369: CLOSE detail_t_cur;
1370:
1371: IF (g_level_procedure >= g_current_runtime_level ) THEN
1372: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.END',
1373: 'ZX_AR_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(-)');
1374: END IF;
1375:
1376: EXCEPTION

Line 1383: FND_LOG.STRING(g_level_unexpected,

1379: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1380: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1381: FND_MSG_PUB.Add;
1382: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1383: FND_LOG.STRING(g_level_unexpected,
1384: 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
1385: g_error_buffer);
1386: END IF;
1387:

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

1454:
1455: BEGIN
1456:
1457: IF (g_level_procedure >= g_current_runtime_level ) THEN
1458: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.BEGIN',
1459: 'ZX_AR_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(+)');
1460: END IF;
1461:
1462: -- L_ORG_ID := P_RA_SUB_ITF_TABLE_REC.org_id;

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

1591:
1592: END IF; -- P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION'
1593:
1594: IF (g_level_procedure >= g_current_runtime_level ) THEN
1595: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.END',
1596: 'ZX_AR_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(-)');
1597: END IF;
1598:
1599: EXCEPTION

Line 1606: FND_LOG.STRING(g_level_unexpected,

1602: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1603: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1604: FND_MSG_PUB.Add;
1605: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1606: FND_LOG.STRING(g_level_unexpected,
1607: 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS',
1608: g_error_buffer);
1609: END IF;
1610:

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

1630:
1631: BEGIN
1632:
1633: IF (g_level_procedure >= g_current_runtime_level ) THEN
1634: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info.BEGIN',
1635: 'ZX_AR_POPULATE_PKG: get_accounting_info(+)' );
1636: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',
1637: 'j := '||to_char(j));
1638: END IF;

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

1632:
1633: IF (g_level_procedure >= g_current_runtime_level ) THEN
1634: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info.BEGIN',
1635: 'ZX_AR_POPULATE_PKG: get_accounting_info(+)' );
1636: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',
1637: 'j := '||to_char(j));
1638: END IF;
1639:
1640: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

1637: 'j := '||to_char(j));
1638: END IF;
1639:
1640: IF (g_level_procedure >= g_current_runtime_level ) THEN
1641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info',
1642: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
1643: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
1644: ||'-'||to_char(p_trx_line_id));
1645: END IF;

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

1674: P_TRX_CLASS,
1675: j);
1676: END IF;
1677: IF (g_level_procedure >= g_current_runtime_level ) THEN
1678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_info.END',
1679: 'ZX_AR_POPULATE_PKG: get_accounting_info(-)');
1680: END IF;
1681:
1682: END get_accounting_info;

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

1694: j IN binary_integer) IS
1695: BEGIN
1696:
1697: IF (g_level_procedure >= g_current_runtime_level ) THEN
1698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts.BEGIN',
1699: 'ZX_AR_POPULATE_PKG: get_accounting_amounts(+)');
1700: END IF;
1701:
1702: IF p_trx_class in ('INVOICE','CREDIT_MEMO','DEBIT_MEMO') THEN

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

1711: P_TRX_CLASS,
1712: P_LEDGER_ID,
1713: j);
1714: IF (g_level_procedure >= g_current_runtime_level ) THEN
1715: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1716: 'trx_id : '||p_trx_id||' tax_line_id : '||P_TAX_LINE_ID||' j : ' ||j);
1717: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1718: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1719: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));

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

1713: j);
1714: IF (g_level_procedure >= g_current_runtime_level ) THEN
1715: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1716: 'trx_id : '||p_trx_id||' tax_line_id : '||P_TAX_LINE_ID||' j : ' ||j);
1717: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1718: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1719: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
1720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1721: 'inv_actg_amounts call :GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR ::: '||to_char(GT_TAX_AMT(j))

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

1716: 'trx_id : '||p_trx_id||' tax_line_id : '||P_TAX_LINE_ID||' j : ' ||j);
1717: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1718: 'inv_actg_amounts call :GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR ::: '||to_char(GT_TAXABLE_AMT(j))
1719: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
1720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
1721: 'inv_actg_amounts call :GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR ::: '||to_char(GT_TAX_AMT(j))
1722: ||'-'||to_char(GT_TAX_AMT_FUNCL_CURR(j)));
1723: END IF;
1724:

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

1737: j);
1738: END IF;
1739:
1740: IF (g_level_procedure >= g_current_runtime_level ) THEN
1741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.get_accounting_amounts.END',
1742: 'ZX_AR_POPULATE_PKG: get_accounting_amounts(-)');
1743: END IF;
1744:
1745:

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

1895: l_tax_dist_ccid number;
1896: L_TRX_DIST_CCID NUMBER ;
1897: BEGIN
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN
1899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',
1900: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
1901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1902: 'j := '||to_char(j));
1903:

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

1897: BEGIN
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN
1899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',
1900: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
1901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1902: 'j := '||to_char(j));
1903:
1904: END IF;
1905:

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

1936: LOOP
1937: FETCH trx_ccid INTO l_ccid;
1938:
1939: IF (g_level_procedure >= g_current_runtime_level ) THEN
1940: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.BEGIN',
1941: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
1942: END IF;
1943:
1944: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

1941: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');
1942: END IF;
1943:
1944: IF (g_level_procedure >= g_current_runtime_level ) THEN
1945: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1946: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1947: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1948: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1949: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);

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

1944: IF (g_level_procedure >= g_current_runtime_level ) THEN
1945: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1946: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1947: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1948: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1949: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1950: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1951: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT2);
1952: END IF;

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

1946: 'TRANSACTION LEVEL : p_trx_id - p_event_id - p_ae_header_id'||to_char(p_trx_id)
1947: ||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)||'-'||to_char(l_ccid));
1948: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1949: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
1950: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
1951: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT2);
1952: END IF;
1953:
1954:

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

2102:
2103:
2104: ELSIF P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
2105: IF (g_level_procedure >= g_current_runtime_level ) THEN
2106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2107: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
2108: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2109: ||'-'||to_char(p_trx_line_id)||'-'||to_char(l_ccid));
2110: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

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

2106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2107: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
2108: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2109: ||'-'||to_char(p_trx_line_id)||'-'||to_char(l_ccid));
2110: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2111: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
2112: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2113: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT2);
2114: END IF;

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

2108: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2109: ||'-'||to_char(p_trx_line_id)||'-'||to_char(l_ccid));
2110: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2111: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
2112: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2113: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT2);
2114: END IF;
2115:
2116: OPEN trx_dist_ccid (p_trx_id, p_trx_line_id, p_event_id, p_ae_header_id);

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

2179:
2180: OPEN tax_dist_ccid (p_trx_id, P_ACTG_SOURCE_ID, p_event_id, p_ae_header_id);
2181: LOOP
2182: IF (g_level_procedure >= g_current_runtime_level ) THEN
2183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2184: 'TRANSACTION DIST LEVEL - tax_dist_ccid : p_trx_id - p_event_id - p_ae_header_id- p_tax_line_id'
2185: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2186: ||'-'||to_char(p_tax_line_id)||'-'||to_char(P_ACTG_SOURCE_ID)||'-'||to_char(l_ccid));
2187: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

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

2183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2184: 'TRANSACTION DIST LEVEL - tax_dist_ccid : p_trx_id - p_event_id - p_ae_header_id- p_tax_line_id'
2185: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2186: ||'-'||to_char(p_tax_line_id)||'-'||to_char(P_ACTG_SOURCE_ID)||'-'||to_char(l_ccid));
2187: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2188: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
2189: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2190: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT2);
2191: END IF;

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

2185: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2186: ||'-'||to_char(p_tax_line_id)||'-'||to_char(P_ACTG_SOURCE_ID)||'-'||to_char(l_ccid));
2187: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2188: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT1);
2189: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2190: 'L_SQL_STATEMENT1: ' ||L_SQL_STATEMENT2);
2191: END IF;
2192:
2193: FETCH tax_dist_ccid INTO l_ccid;

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

2236: P_QUALIFIER => 'ALL',
2237: P_CCID => l_tax_dist_ccid);
2238:
2239: IF (g_level_procedure >= g_current_runtime_level ) THEN
2240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2241: 'Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
2242: END IF;
2243:
2244: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

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

2248: P_QUALIFIER => 'ALL',
2249: P_DATA => GT_ACCOUNT_FLEXFIELD(j));
2250:
2251: IF (g_level_procedure >= g_current_runtime_level ) THEN
2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.INV_SEGMENT_INFO',
2253: 'Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
2254: END IF;
2255:
2256: END IF;

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

2266: P_QUALIFIER => 'ALL',
2267: P_CCID => l_trx_dist_ccid);
2268:
2269: IF (g_level_procedure >= g_current_runtime_level ) THEN
2270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2271: 'inv_segment_info : Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
2272: END IF;
2273:
2274: --Bug 5650415

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

2279: P_QUALIFIER => 'ALL',
2280: P_DATA => GT_TRX_CONTROL_ACCFLEXFIELD(j));
2281:
2282: IF (g_level_procedure >= g_current_runtime_level ) THEN
2283: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
2284: 'Account Description for Taxable Line CCID = '||GT_TRX_TAXABLE_ACCOUNT_DESC(j));
2285: END IF;
2286:
2287: END IF ;

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

2288: ---- End of accounting flexfield population -----------------------
2289:
2290: END IF; -- Summary Level
2291: IF (g_level_procedure >= g_current_runtime_level ) THEN
2292: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info.END',
2293: 'ZX_AR_POPULATE_PKG: inv_segment_info(-)');
2294: END IF;
2295:
2296: END inv_segment_info;

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

2466:
2467: BEGIN
2468:
2469: IF (g_level_procedure >= g_current_runtime_level ) THEN
2470: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.BEGIN',
2471: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(+)');
2472: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2473: 'ZX_AR_POPULATE_PKG: inv_actg_amounts :'|| to_char(p_ledger_id));
2474: END IF;

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

2468:
2469: IF (g_level_procedure >= g_current_runtime_level ) THEN
2470: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.BEGIN',
2471: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(+)');
2472: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2473: 'ZX_AR_POPULATE_PKG: inv_actg_amounts :'|| to_char(p_ledger_id));
2474: END IF;
2475:
2476: IF p_summary_level = 'TRANSACTION' THEN

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

2478: FETCH taxable_amount_hdr INTO GT_TAXABLE_AMT(j),GT_TAXABLE_AMT_FUNCL_CURR(j);
2479: -- EXIT WHEN taxable_amount_hdr%NOTFOUND;
2480: CLOSE taxable_amount_hdr;
2481: IF (g_level_procedure >= g_current_runtime_level ) THEN
2482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2483: 'GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR'||to_char(GT_TAXABLE_AMT(j))
2484: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
2485: END IF;
2486:

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

2489: FETCH tax_amount_hdr INTO GT_TAX_AMT(j),GT_TAX_AMT_FUNCL_CURR(j);
2490: -- EXIT WHEN tax_amount_hdr%NOTFOUND;
2491: CLOSE tax_amount_hdr;
2492: IF (g_level_procedure >= g_current_runtime_level ) THEN
2493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2494: 'GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR'||to_char(GT_TAX_AMT(j))
2495: ||'-'||to_char(GT_TAX_AMT_FUNCL_CURR(j)));
2496: END IF;
2497:

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

2508:
2509: ELSIF p_summary_level = 'TRANSACTION_DISTRIBUTION' THEN
2510:
2511: IF (g_level_procedure >= g_current_runtime_level ) THEN
2512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',
2513: 'TRANSACTION DIST LEVEL : p_trx_id - p_event_id - p_ae_header_id- p_trx_line_id'
2514: ||to_char(p_trx_id)||'-'||to_char(p_event_id)||'-'||to_char(p_ae_header_id)
2515: ||'-'||to_char(p_trx_line_id));
2516: END IF;

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

2520: -- EXIT WHEN taxable_amount_dist%NOTFOUND;
2521: CLOSE taxable_amount_dist;
2522:
2523: IF (g_level_procedure >= g_current_runtime_level ) THEN
2524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2525: 'GT_TAXABLE_AMT, GT_TAXABLE_AMT_FUNCL_CURR'||to_char(GT_TAXABLE_AMT(j))
2526: ||'-'||to_char(GT_TAXABLE_AMT_FUNCL_CURR(j)));
2527: END IF;
2528:

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

2532: -- EXIT WHEN tax_amount_dist%NOTFOUND;
2533: CLOSE tax_amount_dist;
2534:
2535: IF (g_level_procedure >= g_current_runtime_level ) THEN
2536: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts',
2537: 'GT_TAX_AMT, GT_TAX_AMT_FUNCL_CURR'||to_char(GT_TAX_AMT(j))
2538: ||'-'||to_char(GT_TAX_AMT_FUNCL_CURR(j)));
2539: END IF;
2540:

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

2540:
2541: END IF;
2542:
2543: IF (g_level_procedure >= g_current_runtime_level ) THEN
2544: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_actg_amounts.END',
2545: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(-)');
2546: END IF;
2547:
2548: END inv_actg_amounts;

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

2647: L_TRX_DIST_CCID NUMBER ;
2648: BEGIN
2649:
2650: IF (g_level_procedure >= g_current_runtime_level ) THEN
2651: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info.BEGIN',
2652: 'ZX_AR_POPULATE_PKG: other_trx_segment_info(+)');
2653: END IF;
2654:
2655: GT_TRX_ARAP_BALANCING_SEGMENT(j) := NULL;

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

2936: EXECUTE IMMEDIATE L_SQL_STATEMENT2 INTO L_ACCT_SEG_VAL
2937: USING l_ccid;
2938:
2939: IF (g_level_procedure >= g_current_runtime_level ) THEN
2940: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',
2941: 'Tax Line : trx id - P_ACTG_SOURCE_ID- ccid :' ||to_char(p_trx_id)
2942: ||'-'||to_char(P_ACTG_SOURCE_ID)||'-'||to_char(l_ccid)||'-'||L_BAL_SEG_VAL);
2943: END IF;
2944:

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

2997: EXECUTE IMMEDIATE L_SQL_STATEMENT2 INTO L_ACCT_SEG_VAL
2998: USING l_ccid;
2999:
3000: IF (g_level_procedure >= g_current_runtime_level ) THEN
3001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info',
3002: 'Taxable line : - trx id - P_ACTG_SOURCE_ID- ccid :' ||to_char(p_trx_id)
3003: ||'-'||to_char(P_TRX_LINE_ID)||'-'||to_char(l_ccid)||'-'||L_BAL_SEG_VAL);
3004: END IF;
3005:

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

3058: P_QUALIFIER => 'ALL',
3059: P_CCID => l_tax_dist_ccid);
3060:
3061: IF (g_level_procedure >= g_current_runtime_level ) THEN
3062: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3063: 'Account Flexfield = '||GT_ACCOUNT_FLEXFIELD(j));
3064: END IF;
3065:
3066: GT_ACCOUNT_DESCRIPTION(j) := FA_RX_FLEX_PKG.GET_DESCRIPTION(

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

3070: P_QUALIFIER => 'ALL',
3071: P_DATA => GT_ACCOUNT_FLEXFIELD(j));
3072:
3073: IF (g_level_procedure >= g_current_runtime_level ) THEN
3074: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.OTHER_TRX_SEGMENT_INFO',
3075: 'Account Description = '||GT_ACCOUNT_DESCRIPTION(j));
3076: END IF;
3077:
3078: END IF;

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

3088: P_QUALIFIER => 'ALL',
3089: P_CCID => l_trx_dist_ccid);
3090:
3091: IF (g_level_procedure >= g_current_runtime_level ) THEN
3092: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.GET_ACCOUNTING_INFO',
3093: 'other_trx_segment_info : Taxable Line Account Flexfield = '||GT_TRX_CONTROL_ACCFLEXFIELD(j));
3094: END IF;
3095: END IF ;
3096: ---- End of accounting flexfield population -----------------------

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

3096: ---- End of accounting flexfield population -----------------------
3097:
3098: END IF; -- Summary Level
3099: IF (g_level_procedure >= g_current_runtime_level ) THEN
3100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_segment_info.END',
3101: 'ZX_AR_POPULATE_PKG: other_trx_segment_info(-)');
3102: END IF;
3103:
3104: END other_trx_segment_info;

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

3209: AND ael.application_id = aeh.application_id;
3210:
3211: BEGIN
3212: IF (g_level_procedure >= g_current_runtime_level ) THEN
3213: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts.BEGIN',
3214: 'ZX_AR_POPULATE_PKG: other_trx_actg_amounts(+)');
3215: END IF;
3216:
3217: IF p_summary_level = 'TRANSACTION' THEN

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

3247: CLOSE tax_amount_dist;
3248: END IF;
3249:
3250: IF (g_level_procedure >= g_current_runtime_level ) THEN
3251: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.other_trx_actg_amounts.END',
3252: 'ZX_AR_POPULATE_PKG: other_trx_actg_amounts(-)');
3253: END IF;
3254:
3255: END other_trx_actg_amounts;

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

3285: l_TAX_ACCOUNTED_AMOUNT number;
3286: BEGIN
3287:
3288: IF (g_level_procedure >= g_current_runtime_level ) THEN
3289: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts.BEGIN',
3290: 'ZX_AR_POPULATE_PKG: convert_amounts(+)');
3291: END IF;
3292: /*
3293: IF P_INPUT_EXEMPT_AMOUNT IS NOT NULL THEN

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

3346: GT_TAXABLE_AMT_FUNCL_CURR(i) := l_TAXABLE_ACCOUNTED_AMOUNT;
3347:
3348:
3349: IF (g_level_procedure >= g_current_runtime_level ) THEN
3350: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts.END',
3351: 'ZX_AR_POPULATE_PKG: convert_amounts(-)');
3352: END IF;
3353:
3354: EXCEPTION

Line 3361: FND_LOG.STRING(g_level_unexpected,

3357: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3358: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3359: FND_MSG_PUB.Add;
3360: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3361: FND_LOG.STRING(g_level_unexpected,
3362: 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts',
3363: g_error_buffer);
3364: END IF;
3365:

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

3520: BEGIN
3521:
3522:
3523: IF (g_level_procedure >= g_current_runtime_level ) THEN
3524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
3525: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
3526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3527: 'gt_historical_flag :' ||gt_historical_flag(i));
3528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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

3522:
3523: IF (g_level_procedure >= g_current_runtime_level ) THEN
3524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
3525: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
3526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3527: 'gt_historical_flag :' ||gt_historical_flag(i));
3528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3529: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
3530: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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

3524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
3525: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
3526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3527: 'gt_historical_flag :' ||gt_historical_flag(i));
3528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3529: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
3530: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3531: 'GT_BILLING_TP_SITE_ID :' ||to_char(GT_BILLING_TP_SITE_ID(i)));
3532: END IF;

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

3526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3527: 'gt_historical_flag :' ||gt_historical_flag(i));
3528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3529: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
3530: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3531: 'GT_BILLING_TP_SITE_ID :' ||to_char(GT_BILLING_TP_SITE_ID(i)));
3532: END IF;
3533:
3534:

Line 3544: FND_LOG.STRING(g_level_procedure,

3540: l_bill_to_acct_site_id := GT_BILLING_TP_SITE_ID(i);
3541: l_bill_to_acct_id := GT_BILLING_TP_ID(i);
3542:
3543: IF (g_level_procedure >= g_current_runtime_level ) THEN
3544: FND_LOG.STRING(g_level_procedure,
3545: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3546: 'party_site_id_cur : l_bill_to_site_id '||to_char(l_bill_to_acct_site_id));
3547: END IF;
3548:

Line 3561: FND_LOG.STRING(g_level_procedure,

3557:
3558: l_tbl_index_cust := to_char(l_bill_to_acct_site_id);
3559: --|| to_char(l_bill_to_acct_id);
3560: IF (g_level_procedure >= g_current_runtime_level ) THEN
3561: FND_LOG.STRING(g_level_procedure,
3562: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3563: 'Before Open cust_acct_cur :'||to_char(l_bill_to_acct_site_id)||'-'||to_char(l_bill_to_acct_id));
3564: END IF;
3565:

Line 3577: FND_LOG.STRING(g_level_procedure,

3573: GT_BILL_TO_PARTY_ID(i) := g_cust_bill_ar_tbl(l_tbl_index_cust).BILL_TO_PARTY_ID;
3574: GT_BILL_TO_PARTY_SITE_ID(i) := g_cust_bill_ar_tbl(l_tbl_index_cust).BILL_TO_PARTY_SITE_ID;
3575:
3576: IF (g_level_procedure >= g_current_runtime_level ) THEN
3577: FND_LOG.STRING(g_level_procedure,
3578: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3579: 'If g_cust_bill_ar_tbl.EXISTS :'||GT_BILLING_TP_NUMBER(i));
3580: END IF;
3581:

Line 3597: FND_LOG.STRING(g_level_procedure,

3593: GT_BILL_TO_PARTY_ID(i),
3594: GT_BILL_TO_PARTY_SITE_ID(i);
3595:
3596: IF (g_level_procedure >= g_current_runtime_level ) THEN
3597: FND_LOG.STRING(g_level_procedure,
3598: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3599: 'After fetch of cust_acct_cur'||GT_BILLING_TP_NUMBER(i)||'-'||GT_BILLING_TP_TAX_REG_NUM(i));
3600: END IF;
3601:

Line 3618: FND_LOG.STRING(g_level_procedure,

3614: l_bill_to_pty_site_id := GT_BILL_TO_PARTY_SITE_ID(i);
3615: l_bill_to_party_id := GT_BILL_TO_PARTY_ID(i);
3616:
3617: IF (g_level_procedure >= g_current_runtime_level ) THEN
3618: FND_LOG.STRING(g_level_procedure,
3619: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3620: 'After assign to g_cust_bill_ar_tbl ');
3621: END IF;
3622:

Line 3628: FND_LOG.STRING(g_level_procedure,

3624: -- l_bill_ship, 1,8192);
3625: l_tbl_index_party := to_char(l_bill_to_party_id);
3626:
3627: IF (g_level_procedure >= g_current_runtime_level ) THEN
3628: FND_LOG.STRING(g_level_procedure,
3629: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : l_tbl_index_party : '
3630: ||to_char(l_tbl_index_party));
3631: END IF;
3632:

Line 3635: FND_LOG.STRING(g_level_procedure,

3631: END IF;
3632:
3633: IF g_party_bill_ar_tbl.EXISTS(l_tbl_index_party) THEN
3634: IF (g_level_procedure >= g_current_runtime_level ) THEN
3635: FND_LOG.STRING(g_level_procedure,
3636: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : exist : ');
3637: END IF;
3638:
3639: GT_BILLING_TP_NAME_ALT(i) := g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NAME_ALT;

Line 3648: FND_LOG.STRING(g_level_procedure,

3644: -- GT_BILLING_TP_TAX_REG_NUM(i) := g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_TAX_REG_NUM;
3645:
3646: ELSE
3647: IF (g_level_procedure >= g_current_runtime_level ) THEN
3648: FND_LOG.STRING(g_level_procedure,
3649: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : not exist : '||to_char(l_bill_to_party_id));
3650: END IF;
3651: OPEN party_cur (l_bill_to_party_id);
3652: FETCH party_cur INTO GT_BILLING_TP_NAME(i),

Line 3705: FND_LOG.STRING(g_level_procedure,

3701: p_account_site_id := GT_BILLING_TP_ADDRESS_ID(i);
3702: p_site_use_id := GT_BILLING_TP_SITE_ID(i);
3703:
3704: IF (g_level_procedure >= g_current_runtime_level ) THEN
3705: FND_LOG.STRING(g_level_procedure,
3706: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3707: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number ');
3708: FND_LOG.STRING(g_level_procedure,
3709: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3708: FND_LOG.STRING(g_level_procedure,

3704: IF (g_level_procedure >= g_current_runtime_level ) THEN
3705: FND_LOG.STRING(g_level_procedure,
3706: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3707: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number ');
3708: FND_LOG.STRING(g_level_procedure,
3709: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3710: 'trx_id : '||GT_TRX_ID(i));
3711: FND_LOG.STRING(g_level_procedure,
3712: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3711: FND_LOG.STRING(g_level_procedure,

3707: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number ');
3708: FND_LOG.STRING(g_level_procedure,
3709: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3710: 'trx_id : '||GT_TRX_ID(i));
3711: FND_LOG.STRING(g_level_procedure,
3712: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3713: 'p_parent_ptp_id : '||p_parent_ptp_id);
3714: FND_LOG.STRING(g_level_procedure,
3715: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3714: FND_LOG.STRING(g_level_procedure,

3710: 'trx_id : '||GT_TRX_ID(i));
3711: FND_LOG.STRING(g_level_procedure,
3712: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3713: 'p_parent_ptp_id : '||p_parent_ptp_id);
3714: FND_LOG.STRING(g_level_procedure,
3715: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3716: 'p_site_ptp_id : '|| p_site_ptp_id);
3717: FND_LOG.STRING(g_level_procedure,
3718: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3717: FND_LOG.STRING(g_level_procedure,

3713: 'p_parent_ptp_id : '||p_parent_ptp_id);
3714: FND_LOG.STRING(g_level_procedure,
3715: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3716: 'p_site_ptp_id : '|| p_site_ptp_id);
3717: FND_LOG.STRING(g_level_procedure,
3718: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3719: 'p_tax_determine_date : '|| p_tax_determine_date);
3720: FND_LOG.STRING(g_level_procedure,
3721: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3720: FND_LOG.STRING(g_level_procedure,

3716: 'p_site_ptp_id : '|| p_site_ptp_id);
3717: FND_LOG.STRING(g_level_procedure,
3718: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3719: 'p_tax_determine_date : '|| p_tax_determine_date);
3720: FND_LOG.STRING(g_level_procedure,
3721: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3722: 'p_account_id : '|| p_account_id);
3723: FND_LOG.STRING(g_level_procedure,
3724: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3723: FND_LOG.STRING(g_level_procedure,

3719: 'p_tax_determine_date : '|| p_tax_determine_date);
3720: FND_LOG.STRING(g_level_procedure,
3721: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3722: 'p_account_id : '|| p_account_id);
3723: FND_LOG.STRING(g_level_procedure,
3724: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3725: 'p_account_site_id : '|| p_account_site_id);
3726: FND_LOG.STRING(g_level_procedure,
3727: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3726: FND_LOG.STRING(g_level_procedure,

3722: 'p_account_id : '|| p_account_id);
3723: FND_LOG.STRING(g_level_procedure,
3724: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3725: 'p_account_site_id : '|| p_account_site_id);
3726: FND_LOG.STRING(g_level_procedure,
3727: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3728: 'p_site_use_id : '|| p_site_use_id);
3729: FND_LOG.STRING(g_level_procedure,
3730: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3729: FND_LOG.STRING(g_level_procedure,

3725: 'p_account_site_id : '|| p_account_site_id);
3726: FND_LOG.STRING(g_level_procedure,
3727: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3728: 'p_site_use_id : '|| p_site_use_id);
3729: FND_LOG.STRING(g_level_procedure,
3730: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3731: 'p_account_Type_Code : '|| p_account_Type_Code);
3732: END IF;
3733:

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

3750: GT_BILLING_SITE_TAX_REG_NUM(i) := ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference;
3751: else
3752: GT_BILLING_SITE_TAX_REG_NUM(i) := null ;
3753: IF (g_level_procedure >= g_current_runtime_level ) THEN
3754: FND_LOG.STRING(g_level_procedure,'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3755: 'Could not fetch a value for registration number ');
3756: end if ;
3757: end if;
3758:

Line 3760: FND_LOG.STRING(g_level_procedure,

3756: end if ;
3757: end if;
3758:
3759: IF (g_level_procedure >= g_current_runtime_level ) THEN
3760: FND_LOG.STRING(g_level_procedure,
3761: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3762: 'Stauts: '|| p_return_status);
3763: FND_LOG.STRING(g_level_procedure,
3764: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3763: FND_LOG.STRING(g_level_procedure,

3759: IF (g_level_procedure >= g_current_runtime_level ) THEN
3760: FND_LOG.STRING(g_level_procedure,
3761: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3762: 'Stauts: '|| p_return_status);
3763: FND_LOG.STRING(g_level_procedure,
3764: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3765: 'Registration: '||p_zx_registration_rec.registration_number);
3766: FND_LOG.STRING(g_level_procedure,
3767: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 3766: FND_LOG.STRING(g_level_procedure,

3762: 'Stauts: '|| p_return_status);
3763: FND_LOG.STRING(g_level_procedure,
3764: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3765: 'Registration: '||p_zx_registration_rec.registration_number);
3766: FND_LOG.STRING(g_level_procedure,
3767: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3768: 'Registration from structure : '||GT_BILLING_SITE_TAX_REG_NUM(i));
3769: END IF ;
3770: EXCEPTION

Line 3777: FND_LOG.STRING(g_level_procedure,

3773: End;
3774: END IF; -- GT_BILLING_SITE_TAX_REG_NUM IS NULL
3775:
3776: IF (g_level_procedure >= g_current_runtime_level ) THEN
3777: FND_LOG.STRING(g_level_procedure,
3778: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3779: 'After assign to g_party_bill_ar_tbl '||g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NUMBER);
3780: END IF;
3781: -- l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_pty_site_id)||

Line 3787: FND_LOG.STRING(g_level_procedure,

3783:
3784: l_tbl_index_bill_site := to_char(l_bill_to_pty_site_id);
3785:
3786: IF (g_level_procedure >= g_current_runtime_level ) THEN
3787: FND_LOG.STRING(g_level_procedure,
3788: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : l_tbl_index_bill_site : '
3789: ||to_char(l_tbl_index_bill_site));
3790: END IF;
3791:

Line 3795: FND_LOG.STRING(g_level_procedure,

3791:
3792: IF g_site_bill_ar_tbl.EXISTS(l_tbl_index_bill_site) THEN
3793:
3794: IF (g_level_procedure >= g_current_runtime_level ) THEN
3795: FND_LOG.STRING(g_level_procedure,
3796: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : exist : ');
3797: END IF;
3798: GT_BILLING_TP_CITY(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_CITY;
3799: GT_BILLING_TP_COUNTY(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_COUNTY;

Line 3810: FND_LOG.STRING(g_level_procedure,

3806: GT_BILLING_TP_COUNTRY(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_COUNTRY;
3807: GT_BILLING_TP_POSTAL_CODE(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_POSTAL_CODE;
3808: ELSE
3809: IF (g_level_procedure >= g_current_runtime_level ) THEN
3810: FND_LOG.STRING(g_level_procedure,
3811: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : not exist : '||to_char(l_bill_to_pty_site_id));
3812: END IF;
3813: OPEN party_site_cur (l_bill_to_pty_site_id);
3814: FETCH party_site_cur INTO GT_BILLING_TP_CITY(i),

Line 3841: FND_LOG.STRING(g_level_procedure,

3837:
3838:
3839:
3840: IF (g_level_procedure >= g_current_runtime_level ) THEN
3841: FND_LOG.STRING(g_level_procedure,
3842: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3843: 'After assign to g_site_bill_ar_tbl '||g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_CITY);
3844: END IF;
3845: END IF;

Line 3853: FND_LOG.STRING(g_level_procedure,

3849: l_ship_to_acct_site_id := GT_SHIPPING_TP_SITE_ID(i);
3850: l_ship_to_acct_id := GT_SHIPPING_TP_ID(i);
3851:
3852: IF (g_level_procedure >= g_current_runtime_level ) THEN
3853: FND_LOG.STRING(g_level_procedure,
3854: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3855: 'party_site_id_cur : l_ship_to_site_id '||to_char(l_ship_to_acct_site_id));
3856: END IF;
3857:

Line 3884: FND_LOG.STRING(g_level_procedure,

3880:
3881: -- GT_SHIPPING_SITE_TAX_REG_NUM(i) := g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_SITE_TAX_REG_NUM;
3882:
3883: IF (g_level_procedure >= g_current_runtime_level ) THEN
3884: FND_LOG.STRING(g_level_procedure,
3885: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3886: 'Exists in the cache g_cust_ship_ar_tbl '||g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER);
3887: END IF;
3888:

Line 3914: FND_LOG.STRING(g_level_procedure,

3910:
3911: CLOSE cust_acct_cur;
3912: END IF;
3913: IF (g_level_procedure >= g_current_runtime_level ) THEN
3914: FND_LOG.STRING(g_level_procedure,
3915: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3916: 'After assign to g_cust_ship_ar_tbl '||g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER);
3917: END IF;
3918:

Line 3928: FND_LOG.STRING(g_level_procedure,

3924: -- l_bill_ship, 1,8192);
3925: l_tbl_index_party := to_char(l_ship_to_party_id);
3926:
3927: IF (g_level_procedure >= g_current_runtime_level ) THEN
3928: FND_LOG.STRING(g_level_procedure,
3929: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : l_tbl_index_party : '
3930: ||to_char(l_tbl_index_party));
3931: END IF;
3932:

Line 3935: FND_LOG.STRING(g_level_procedure,

3931: END IF;
3932:
3933: IF g_party_ship_ar_tbl.EXISTS(l_tbl_index_party) THEN
3934: IF (g_level_procedure >= g_current_runtime_level ) THEN
3935: FND_LOG.STRING(g_level_procedure,
3936: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : exist : ');
3937: END IF;
3938:
3939: GT_SHIPPING_TP_NAME_ALT(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME_ALT;

Line 3947: FND_LOG.STRING(g_level_procedure,

3943: GT_SHIPPING_TP_TAXPAYER_ID(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_TAXPAYER_ID;
3944: -- GT_SHIPPING_TP_TAX_REG_NUM(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_TAX_REG_NUM;
3945: ELSE
3946: IF (g_level_procedure >= g_current_runtime_level ) THEN
3947: FND_LOG.STRING(g_level_procedure,
3948: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : not exist : '||to_char(l_ship_to_party_id));
3949: END IF;
3950: OPEN party_cur (l_ship_to_party_id);
3951: FETCH party_cur INTO GT_SHIPPING_TP_NAME(i),

Line 4002: FND_LOG.STRING(g_level_procedure,

3998: p_account_site_id := GT_SHIPPING_TP_ADDRESS_ID(i);
3999: p_site_use_id := GT_SHIPPING_TP_SITE_ID(i);
4000:
4001: IF (g_level_procedure >= g_current_runtime_level ) THEN
4002: FND_LOG.STRING(g_level_procedure,
4003: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4004: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number : SHIP_TO');
4005: FND_LOG.STRING(g_level_procedure,
4006: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4005: FND_LOG.STRING(g_level_procedure,

4001: IF (g_level_procedure >= g_current_runtime_level ) THEN
4002: FND_LOG.STRING(g_level_procedure,
4003: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4004: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number : SHIP_TO');
4005: FND_LOG.STRING(g_level_procedure,
4006: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4007: 'trx_id : '||GT_TRX_ID(i));
4008: FND_LOG.STRING(g_level_procedure,
4009: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4008: FND_LOG.STRING(g_level_procedure,

4004: 'Before call to ZX_TCM_CONTROL_PKG.Get_Tax_Registration api to get the registration number : SHIP_TO');
4005: FND_LOG.STRING(g_level_procedure,
4006: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4007: 'trx_id : '||GT_TRX_ID(i));
4008: FND_LOG.STRING(g_level_procedure,
4009: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4010: 'p_parent_ptp_id : '||p_parent_ptp_id);
4011: FND_LOG.STRING(g_level_procedure,
4012: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4011: FND_LOG.STRING(g_level_procedure,

4007: 'trx_id : '||GT_TRX_ID(i));
4008: FND_LOG.STRING(g_level_procedure,
4009: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4010: 'p_parent_ptp_id : '||p_parent_ptp_id);
4011: FND_LOG.STRING(g_level_procedure,
4012: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4013: 'p_site_ptp_id : '|| p_site_ptp_id);
4014: FND_LOG.STRING(g_level_procedure,
4015: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4014: FND_LOG.STRING(g_level_procedure,

4010: 'p_parent_ptp_id : '||p_parent_ptp_id);
4011: FND_LOG.STRING(g_level_procedure,
4012: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4013: 'p_site_ptp_id : '|| p_site_ptp_id);
4014: FND_LOG.STRING(g_level_procedure,
4015: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4016: 'p_tax_determine_date : '|| p_tax_determine_date);
4017: FND_LOG.STRING(g_level_procedure,
4018: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4017: FND_LOG.STRING(g_level_procedure,

4013: 'p_site_ptp_id : '|| p_site_ptp_id);
4014: FND_LOG.STRING(g_level_procedure,
4015: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4016: 'p_tax_determine_date : '|| p_tax_determine_date);
4017: FND_LOG.STRING(g_level_procedure,
4018: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4019: 'p_account_id : '|| p_account_id);
4020: FND_LOG.STRING(g_level_procedure,
4021: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4020: FND_LOG.STRING(g_level_procedure,

4016: 'p_tax_determine_date : '|| p_tax_determine_date);
4017: FND_LOG.STRING(g_level_procedure,
4018: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4019: 'p_account_id : '|| p_account_id);
4020: FND_LOG.STRING(g_level_procedure,
4021: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4022: 'p_account_site_id : '|| p_account_site_id);
4023: FND_LOG.STRING(g_level_procedure,
4024: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4023: FND_LOG.STRING(g_level_procedure,

4019: 'p_account_id : '|| p_account_id);
4020: FND_LOG.STRING(g_level_procedure,
4021: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4022: 'p_account_site_id : '|| p_account_site_id);
4023: FND_LOG.STRING(g_level_procedure,
4024: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4025: 'p_site_use_id : '|| p_site_use_id);
4026: FND_LOG.STRING(g_level_procedure,
4027: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4026: FND_LOG.STRING(g_level_procedure,

4022: 'p_account_site_id : '|| p_account_site_id);
4023: FND_LOG.STRING(g_level_procedure,
4024: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4025: 'p_site_use_id : '|| p_site_use_id);
4026: FND_LOG.STRING(g_level_procedure,
4027: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4028: 'p_account_Type_Code : '|| p_account_Type_Code);
4029: END IF;
4030:

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

4047: GT_SHIPPING_SITE_TAX_REG_NUM(i) := ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference;
4048: ELSE
4049: GT_SHIPPING_SITE_TAX_REG_NUM(i) := null ;
4050: IF (g_level_procedure >= g_current_runtime_level ) THEN
4051: FND_LOG.STRING(g_level_procedure,'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4052: 'Could not fetch a value for registration number ');
4053: END IF;
4054: END IF;
4055:

Line 4057: FND_LOG.STRING(g_level_procedure,

4053: END IF;
4054: END IF;
4055:
4056: IF (g_level_procedure >= g_current_runtime_level ) THEN
4057: FND_LOG.STRING(g_level_procedure,
4058: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4059: 'Stauts: '|| p_return_status);
4060: FND_LOG.STRING(g_level_procedure,
4061: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4060: FND_LOG.STRING(g_level_procedure,

4056: IF (g_level_procedure >= g_current_runtime_level ) THEN
4057: FND_LOG.STRING(g_level_procedure,
4058: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4059: 'Stauts: '|| p_return_status);
4060: FND_LOG.STRING(g_level_procedure,
4061: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4062: 'Registration: '||p_zx_registration_rec.registration_number);
4063: FND_LOG.STRING(g_level_procedure,
4064: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 4063: FND_LOG.STRING(g_level_procedure,

4059: 'Stauts: '|| p_return_status);
4060: FND_LOG.STRING(g_level_procedure,
4061: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4062: 'Registration: '||p_zx_registration_rec.registration_number);
4063: FND_LOG.STRING(g_level_procedure,
4064: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4065: 'Registration from structure : '||GT_SHIPPING_SITE_TAX_REG_NUM(i));
4066: END IF ;
4067: EXCEPTION

Line 4074: FND_LOG.STRING(g_level_procedure,

4070: END;
4071: END IF; -- GT_SHIPPING_SITE_TAX_REG_NUM IS NULL
4072:
4073: IF (g_level_procedure >= g_current_runtime_level ) THEN
4074: FND_LOG.STRING(g_level_procedure,
4075: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4076: 'After assign to g_party_ship_ar_tbl '||g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME);
4077: END IF;
4078:

Line 4084: FND_LOG.STRING(g_level_procedure,

4080: -- l_bill_ship, 1,8192);
4081: l_tbl_index_ship_site := to_char(l_ship_to_pty_site_id);
4082:
4083: IF (g_level_procedure >= g_current_runtime_level ) THEN
4084: FND_LOG.STRING(g_level_procedure,
4085: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : l_tbl_index_ship_site : party site id : acct_site_id : acct_id '
4086: ||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));
4087: END IF;
4088: IF g_site_ship_ar_tbl.EXISTS(l_tbl_index_ship_site) THEN

Line 4090: FND_LOG.STRING(g_level_procedure,

4086: ||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));
4087: END IF;
4088: IF g_site_ship_ar_tbl.EXISTS(l_tbl_index_ship_site) THEN
4089: IF (g_level_procedure >= g_current_runtime_level ) THEN
4090: FND_LOG.STRING(g_level_procedure,
4091: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : exist : ');
4092: END IF;
4093: GT_SHIPPING_TP_CITY(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_CITY;
4094: GT_SHIPPING_TP_COUNTY(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_COUNTY;

Line 4105: FND_LOG.STRING(g_level_procedure,

4101: GT_SHIPPING_TP_COUNTRY(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_COUNTRY;
4102: GT_SHIPPING_TP_POSTAL_CODE(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_POSTAL_CODE;
4103: ELSE
4104: IF (g_level_procedure >= g_current_runtime_level ) THEN
4105: FND_LOG.STRING(g_level_procedure,
4106: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : not exist in Cache : '||to_char(l_ship_to_pty_site_id));
4107: END IF;
4108: OPEN party_site_cur (l_ship_to_pty_site_id);
4109: FETCH party_site_cur INTO GT_SHIPPING_TP_CITY(i),

Line 4132: FND_LOG.STRING(g_level_procedure,

4128: g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_POSTAL_CODE := GT_SHIPPING_TP_POSTAL_CODE(i);
4129: CLOSE party_site_cur;
4130: END IF;
4131: IF (g_level_procedure >= g_current_runtime_level ) THEN
4132: FND_LOG.STRING(g_level_procedure,
4133: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4134: 'After assign to g_site_ship_ar_tbl '||g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_CITY);
4135: END IF;
4136:

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

4150: GT_DOC_SEQ_NAME(i) := NULL;
4151: END IF;
4152:
4153: IF (g_level_procedure >= g_current_runtime_level ) THEN
4154: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.END',
4155: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(-)');
4156: END IF;
4157:
4158: EXCEPTION

Line 4165: FND_LOG.STRING(g_level_unexpected,

4161: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4162: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
4163: FND_MSG_PUB.Add;
4164: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4165: FND_LOG.STRING(g_level_unexpected,
4166: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4167: g_error_buffer);
4168: END IF;
4169:

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

4198: AND c_tax_date between rel.effective_from and nvl(rel.effective_to,c_tax_date);
4199:
4200: BEGIN
4201: IF (g_level_procedure >= g_current_runtime_level ) THEN
4202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_tax_reg_num.BEGIN',
4203: 'populate_tax_reg_num(+)');
4204: END IF;
4205: OPEN trn_ptp_id_cur (p_org_id,
4206: P_TRL_GLOBAL_VARIABLES_REC.legal_entity_id,

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

4208: FETCH trn_ptp_id_cur into GT_TAX_REG_NUM(i);
4209: CLOSE trn_ptp_id_cur;
4210:
4211: IF (g_level_procedure >= g_current_runtime_level ) THEN
4212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.populate_tax_reg_num.END',
4213: 'populate_tax_reg_num(-)');
4214: END IF;
4215: END populate_tax_reg_num;
4216:

Line 4226: FND_LOG.STRING(g_level_unexpected,

4222: l_meaning VARCHAR2(80);
4223: BEGIN
4224:
4225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4226: FND_LOG.STRING(g_level_unexpected,
4227: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4228: 'populate_meaning(+) ');
4229: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4230: 'Value of i : '||i);

Line 4229: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

4225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4226: FND_LOG.STRING(g_level_unexpected,
4227: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4228: 'populate_meaning(+) ');
4229: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4230: 'Value of i : '||i);
4231: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4232: 'GT_TRX_ID(i) : '||GT_TRX_ID(i));
4233: FND_LOG.STRING(g_level_unexpected,

Line 4231: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

4227: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4228: 'populate_meaning(+) ');
4229: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4230: 'Value of i : '||i);
4231: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4232: 'GT_TRX_ID(i) : '||GT_TRX_ID(i));
4233: FND_LOG.STRING(g_level_unexpected,
4234: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4235: 'REGISTER_TYPE : '||GT_TAX_RATE_REG_TYPE_CODE(i));

Line 4233: FND_LOG.STRING(g_level_unexpected,

4229: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4230: 'Value of i : '||i);
4231: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4232: 'GT_TRX_ID(i) : '||GT_TRX_ID(i));
4233: FND_LOG.STRING(g_level_unexpected,
4234: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4235: 'REGISTER_TYPE : '||GT_TAX_RATE_REG_TYPE_CODE(i));
4236: END IF;
4237:

Line 4255: FND_LOG.STRING(g_level_unexpected,

4251: GT_TRX_CLASS_MNG(i) := l_meaning;
4252: END IF;
4253:
4254: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4255: FND_LOG.STRING(g_level_unexpected,
4256: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4257: 'GT_TRX_CLASS : '||GT_TRX_CLASS(i));
4258: FND_LOG.STRING(g_level_unexpected,
4259: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

Line 4258: FND_LOG.STRING(g_level_unexpected,

4254: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4255: FND_LOG.STRING(g_level_unexpected,
4256: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4257: 'GT_TRX_CLASS : '||GT_TRX_CLASS(i));
4258: FND_LOG.STRING(g_level_unexpected,
4259: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4260: 'GT_TRX_CLASS_MNG(i) : '||GT_TRX_CLASS_MNG(i));
4261: END IF;
4262:

Line 4282: FND_LOG.STRING(g_level_unexpected,

4278: GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) := l_description;
4279: END IF;
4280:
4281: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4282: FND_LOG.STRING(g_level_unexpected,
4283: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4284: 'GT_TAX_RATE_CODE_REG_TYPE_MNG(i) : '||GT_TAX_RATE_CODE_REG_TYPE_MNG(i));
4285: FND_LOG.STRING(g_level_unexpected,
4286: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

Line 4285: FND_LOG.STRING(g_level_unexpected,

4281: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4282: FND_LOG.STRING(g_level_unexpected,
4283: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4284: 'GT_TAX_RATE_CODE_REG_TYPE_MNG(i) : '||GT_TAX_RATE_CODE_REG_TYPE_MNG(i));
4285: FND_LOG.STRING(g_level_unexpected,
4286: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4287: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4288: FND_LOG.STRING(g_level_unexpected,
4289: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

Line 4288: FND_LOG.STRING(g_level_unexpected,

4284: 'GT_TAX_RATE_CODE_REG_TYPE_MNG(i) : '||GT_TAX_RATE_CODE_REG_TYPE_MNG(i));
4285: FND_LOG.STRING(g_level_unexpected,
4286: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4287: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));
4288: FND_LOG.STRING(g_level_unexpected,
4289: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4290: 'GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_DESC(i));
4291: END IF;
4292:

Line 4304: FND_LOG.STRING(g_level_unexpected,

4300: END IF;
4301:
4302:
4303: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4304: FND_LOG.STRING(g_level_unexpected,
4305: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4306: 'GT_TAX_EXCEPTION_REASON_CODE(i) : '||GT_TAX_EXCEPTION_REASON_CODE(i));
4307: FND_LOG.STRING(g_level_unexpected,
4308: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

Line 4307: FND_LOG.STRING(g_level_unexpected,

4303: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4304: FND_LOG.STRING(g_level_unexpected,
4305: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4306: 'GT_TAX_EXCEPTION_REASON_CODE(i) : '||GT_TAX_EXCEPTION_REASON_CODE(i));
4307: FND_LOG.STRING(g_level_unexpected,
4308: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4309: 'GT_TAX_EXCEPTION_REASON_MNG(i) : '||GT_TAX_EXCEPTION_REASON_MNG(i));
4310: END IF;
4311:

Line 4321: FND_LOG.STRING(g_level_unexpected,

4317: GT_TAX_EXEMPT_REASON_MNG(i) := l_meaning;
4318: END IF;
4319:
4320: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4321: FND_LOG.STRING(g_level_unexpected,
4322: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4323: 'GT_EXEMPT_REASON_CODE : '||GT_EXEMPT_REASON_CODE(i));
4324: FND_LOG.STRING(g_level_unexpected,
4325: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

Line 4324: FND_LOG.STRING(g_level_unexpected,

4320: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4321: FND_LOG.STRING(g_level_unexpected,
4322: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4323: 'GT_EXEMPT_REASON_CODE : '||GT_EXEMPT_REASON_CODE(i));
4324: FND_LOG.STRING(g_level_unexpected,
4325: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4326: 'GT_TAX_EXEMPT_REASON_MNG(i) : '||GT_TAX_EXEMPT_REASON_MNG(i));
4327: END IF;
4328:

Line 4349: FND_LOG.STRING(g_level_unexpected,

4345: GT_TAX_TYPE_MNG(i) := l_meaning;
4346: END IF;
4347:
4348: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4349: FND_LOG.STRING(g_level_unexpected,
4350: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4351: 'GT_TAX_TYPE_CODE(i) : '||GT_TAX_TYPE_CODE(i));
4352: FND_LOG.STRING(g_level_unexpected,
4353: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

Line 4352: FND_LOG.STRING(g_level_unexpected,

4348: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4349: FND_LOG.STRING(g_level_unexpected,
4350: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4351: 'GT_TAX_TYPE_CODE(i) : '||GT_TAX_TYPE_CODE(i));
4352: FND_LOG.STRING(g_level_unexpected,
4353: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',
4354: 'GT_TAX_TYPE_MNG(i) : '||GT_TAX_TYPE_MNG(i));
4355: END IF;
4356:

Line 4358: FND_LOG.STRING(g_level_unexpected,

4354: 'GT_TAX_TYPE_MNG(i) : '||GT_TAX_TYPE_MNG(i));
4355: END IF;
4356:
4357: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4358: FND_LOG.STRING(g_level_unexpected,
4359: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.END',
4360: 'populate_meaning(-) ');
4361: END IF;
4362:

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

4370: i number;
4371: BEGIN
4372:
4373: IF (g_level_procedure >= g_current_runtime_level ) THEN
4374: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T.BEGIN',
4375: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');
4376: END IF;
4377:
4378: FORALL i in 1..p_count

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

4451: TAX_TYPE_MNG = GT_TAX_TYPE_MNG(i)
4452: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
4453:
4454: IF (g_level_procedure >= g_current_runtime_level ) THEN
4455: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T.END',
4456: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(-)');
4457: END IF;
4458:
4459:

Line 4467: FND_LOG.STRING(g_level_unexpected,

4463: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4464: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
4465: FND_MSG_PUB.Add;
4466: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4467: FND_LOG.STRING(g_level_unexpected,
4468: 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T',
4469: g_error_buffer);
4470: END IF;
4471:

Line 4502: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info.BEGIN',

4498:
4499: BEGIN
4500:
4501: IF (g_level_procedure >= g_current_runtime_level ) THEN
4502: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info.BEGIN',
4503: 'ZX_AR_ACTG_EXTRACT_PKG: insert_actg_info(+)');
4504: END IF;
4505:
4506: l_count := P_COUNT;

Line 4509: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info',

4505:
4506: l_count := P_COUNT;
4507:
4508: IF (g_level_procedure >= g_current_runtime_level ) THEN
4509: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info',
4510: ' Record Count = ' ||to_char(P_COUNT));
4511: END IF;
4512:
4513:

Line 4612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info',

4608: g_request_id,
4609: GT_TRX_CONTROL_ACCFLEXFIELD(i)); --Bug 5510907
4610:
4611: IF (g_level_procedure >= g_current_runtime_level ) THEN
4612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info',
4613: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
4614:
4615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info.END',
4616: 'ZX_AR_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

Line 4615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info.END',

4611: IF (g_level_procedure >= g_current_runtime_level ) THEN
4612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info',
4613: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
4614:
4615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info.END',
4616: 'ZX_AR_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');
4617: END IF;
4618:
4619: EXCEPTION

Line 4626: FND_LOG.STRING(g_level_unexpected,

4622: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4623: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
4624: FND_MSG_PUB.Add;
4625: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4626: FND_LOG.STRING(g_level_unexpected,
4627: 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.insert_actg_info',
4628: g_error_buffer);
4629: END IF;
4630:

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

4638:
4639: BEGIN
4640:
4641: IF (g_level_procedure >= g_current_runtime_level ) THEN
4642: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.BEGIN',
4643: 'ZX_AR_POPULATE_PKG: initialize_variables(+)');
4644: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',
4645: 'p_count : '||to_char(p_count));
4646: END IF;

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

4640:
4641: IF (g_level_procedure >= g_current_runtime_level ) THEN
4642: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.BEGIN',
4643: 'ZX_AR_POPULATE_PKG: initialize_variables(+)');
4644: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',
4645: 'p_count : '||to_char(p_count));
4646: END IF;
4647:
4648: FOR i IN 1.. p_count LOOP

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

4808:
4809: END LOOP;
4810:
4811: IF (g_level_procedure >= g_current_runtime_level ) THEN
4812: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables.END',
4813: 'ZX_AR_POPULATE_PKG: initialize_variables(-)');
4814: END IF;
4815:
4816: EXCEPTION

Line 4823: FND_LOG.STRING(g_level_unexpected,

4819: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4820: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
4821: FND_MSG_PUB.Add;
4822: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4823: FND_LOG.STRING(g_level_unexpected,
4824: 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',
4825: g_error_buffer);
4826: END IF;
4827: