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 ZX_AR_POPULATE_PKG

Line 1: PACKAGE BODY ZX_AR_POPULATE_PKG AS

1: PACKAGE BODY ZX_AR_POPULATE_PKG AS
2: /* $Header: zxrirpopulatpvtb.pls 120.41.12010000.4 2008/12/03 19:34:04 bibeura ship $ */
3:
4:
5: --Populate party info into global variables

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 935: 'ZX_AR_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(+)');

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 --
939: gl_mc_info.get_ledger_currency(p_trl_global_variables_rec.ledger_id,

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 1373: 'ZX_AR_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(-)');

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
1377: WHEN OTHERS THEN

Line 1384: 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',

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:
1388: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := G_RETCODE;

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 1459: 'ZX_AR_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(+)');

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;
1463: -- L_CONTROL_ACCOUNT_CCID := P_RA_SUB_ITF_TABLE_REC.al_account_ccid;

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 1596: 'ZX_AR_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(-)');

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
1600: WHEN OTHERS THEN

Line 1607: 'ZX.TRL.ZX_AR_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS',

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:
1611: G_RETCODE := 2;

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 1635: 'ZX_AR_POPULATE_PKG: get_accounting_info(+)' );

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;
1639:

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 1679: 'ZX_AR_POPULATE_PKG: get_accounting_info(-)');

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;
1683:

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 1699: 'ZX_AR_POPULATE_PKG: get_accounting_amounts(+)');

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
1703: inv_actg_amounts(P_TRX_ID,

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 1742: 'ZX_AR_POPULATE_PKG: get_accounting_amounts(-)');

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:
1746: END get_accounting_amounts;

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 1900: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');

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:
1904: END IF;

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 1941: 'ZX_AR_POPULATE_PKG: inv_segment_info(+)');

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
1945: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.inv_segment_info',

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 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 2293: 'ZX_AR_POPULATE_PKG: inv_segment_info(-)');

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;
2297:

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 2471: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(+)');

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;
2475:

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 2473: 'ZX_AR_POPULATE_PKG: inv_actg_amounts :'|| to_char(p_ledger_id));

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
2477: OPEN taxable_amount_hdr(p_trx_id , p_ae_header_id , p_event_id,p_ledger_id );

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 2545: 'ZX_AR_POPULATE_PKG: inv_actg_amounts(-)');

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;
2549:

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 2652: 'ZX_AR_POPULATE_PKG: other_trx_segment_info(+)');

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;
2656: GT_TRX_ARAP_NATURAL_ACCOUNT(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 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 3101: 'ZX_AR_POPULATE_PKG: other_trx_segment_info(-)');

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;
3105:

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 3214: 'ZX_AR_POPULATE_PKG: other_trx_actg_amounts(+)');

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
3218: OPEN taxable_amount_hdr(p_actg_source_id , p_ae_header_id , p_event_id,p_ledger_id );

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 3252: 'ZX_AR_POPULATE_PKG: other_trx_actg_amounts(-)');

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;
3256:

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 3290: 'ZX_AR_POPULATE_PKG: convert_amounts(+)');

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
3294: P_EXEMPT_ENTERED_AMOUNT := P_INPUT_EXEMPT_AMOUNT;

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 3351: 'ZX_AR_POPULATE_PKG: convert_amounts(-)');

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
3355: WHEN OTHERS THEN

Line 3362: 'ZX.TRL.ZX_AR_POPULATE_PKG.convert_amounts',

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:
3366: G_RETCODE := 2;

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 3525: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');

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',
3529: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));

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 3545: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3549: l_bill_ship := 'BILL_TO';

Line 3562: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3566: IF g_cust_bill_ar_tbl.EXISTS(l_tbl_index_cust) THEN

Line 3578: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3582: ELSE

Line 3598: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3602: g_cust_bill_ar_tbl(l_tbl_index_cust).BILLING_TP_NUMBER := GT_BILLING_TP_NUMBER(i);

Line 3619: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3623: --l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_to_party_id)||

Line 3629: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : l_tbl_index_party : '

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:
3633: IF g_party_bill_ar_tbl.EXISTS(l_tbl_index_party) THEN

Line 3636: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : exist : ');

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;
3640: GT_BILLING_TP_NAME(i) := g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NAME;

Line 3649: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : not exist : '||to_char(l_bill_to_party_id));

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),
3653: GT_BILLING_TP_NAME_ALT(i),

Line 3706: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3710: 'trx_id : '||GT_TRX_ID(i));

Line 3709: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3713: 'p_parent_ptp_id : '||p_parent_ptp_id);

Line 3712: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3716: 'p_site_ptp_id : '|| p_site_ptp_id);

Line 3715: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3719: 'p_tax_determine_date : '|| p_tax_determine_date);

Line 3718: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3722: 'p_account_id : '|| p_account_id);

Line 3721: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3725: 'p_account_site_id : '|| p_account_site_id);

Line 3724: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3728: 'p_site_use_id : '|| p_site_use_id);

Line 3727: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3731: 'p_account_Type_Code : '|| p_account_Type_Code);

Line 3730: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3734: ZX_TCM_CONTROL_PKG.Get_Tax_Registration(

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 3761: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3765: 'Registration: '||p_zx_registration_rec.registration_number);

Line 3764: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
3768: 'Registration from structure : '||GT_BILLING_SITE_TAX_REG_NUM(i));

Line 3767: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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
3771: WHEN OTHERS THEN

Line 3778: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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)||
3782: -- l_bill_ship, 1,8192);

Line 3788: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : l_tbl_index_bill_site : '

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:
3792: IF g_site_bill_ar_tbl.EXISTS(l_tbl_index_bill_site) THEN

Line 3796: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : exist : ');

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;
3800: GT_BILLING_TP_STATE(i) := g_site_bill_ar_tbl(l_tbl_index_bill_site).BILLING_TP_STATE;

Line 3811: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Bill : not exist : '||to_char(l_bill_to_pty_site_id));

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),
3815: GT_BILLING_TP_COUNTY(i),

Line 3842: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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;
3846:

Line 3854: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3858: l_bill_ship := 'SHIP_TO';

Line 3885: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3889: ELSE

Line 3915: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
3919: l_ship_to_pty_site_id := GT_SHIP_TO_PARTY_SITE_ID(i);

Line 3929: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : l_tbl_index_party : '

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:
3933: IF g_party_ship_ar_tbl.EXISTS(l_tbl_index_party) THEN

Line 3936: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : exist : ');

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;
3940: GT_SHIPPING_TP_NAME(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME;

Line 3948: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Party : not exist : '||to_char(l_ship_to_party_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),
3952: GT_SHIPPING_TP_NAME_ALT(i),

Line 4003: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4007: 'trx_id : '||GT_TRX_ID(i));

Line 4006: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4010: 'p_parent_ptp_id : '||p_parent_ptp_id);

Line 4009: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4013: 'p_site_ptp_id : '|| p_site_ptp_id);

Line 4012: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4016: 'p_tax_determine_date : '|| p_tax_determine_date);

Line 4015: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4019: 'p_account_id : '|| p_account_id);

Line 4018: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4022: 'p_account_site_id : '|| p_account_site_id);

Line 4021: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4025: 'p_site_use_id : '|| p_site_use_id);

Line 4024: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4028: 'p_account_Type_Code : '|| p_account_Type_Code);

Line 4027: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
4031: ZX_TCM_CONTROL_PKG.Get_Tax_Registration(

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 4058: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4062: 'Registration: '||p_zx_registration_rec.registration_number);

Line 4061: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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',
4065: 'Registration from structure : '||GT_SHIPPING_SITE_TAX_REG_NUM(i));

Line 4064: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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
4068: WHEN OTHERS THEN

Line 4075: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
4079: --l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_ship_to_pty_site_id)||

Line 4085: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : l_tbl_index_ship_site : party site id : acct_site_id : acct_id '

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
4089: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 4091: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : exist : ');

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;
4095: GT_SHIPPING_TP_STATE(i) := g_site_ship_ar_tbl(l_tbl_index_ship_site).SHIPPING_TP_STATE;

Line 4106: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO', 'Ship : not exist in Cache : '||to_char(l_ship_to_pty_site_id));

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),
4110: GT_SHIPPING_TP_COUNTY(i),

Line 4133: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
4137: END IF;

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 4155: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(-)');

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
4159: WHEN OTHERS THEN

Line 4166: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

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:
4170: G_RETCODE := 2;

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 4227: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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);
4231: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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 4234: '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:
4238:

Line 4256: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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',
4260: 'GT_TRX_CLASS_MNG(i) : '||GT_TRX_CLASS_MNG(i));

Line 4259: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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:
4263: IF P_TRL_GLOBAL_VARIABLES_REC.REGISTER_TYPE IS NOT NULL THEN

Line 4283: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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',
4287: 'GT_TAX_RATE_VAT_TRX_TYPE_CODE(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_CODE(i));

Line 4286: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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',
4290: 'GT_TAX_RATE_VAT_TRX_TYPE_DESC(i) : '||GT_TAX_RATE_VAT_TRX_TYPE_DESC(i));

Line 4289: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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:
4293: IF GT_TAX_EXCEPTION_REASON_CODE(i) IS NOT NULL THEN

Line 4305: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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',
4309: 'GT_TAX_EXCEPTION_REASON_MNG(i) : '||GT_TAX_EXCEPTION_REASON_MNG(i));

Line 4308: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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:
4312: IF GT_EXEMPT_REASON_CODE(i) IS NOT NULL THEN

Line 4322: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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',
4326: 'GT_TAX_EXEMPT_REASON_MNG(i) : '||GT_TAX_EXEMPT_REASON_MNG(i));

Line 4325: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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:
4329: --Bug 5671767 :Code added to populate tax_type_mng

Line 4350: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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',
4354: 'GT_TAX_TYPE_MNG(i) : '||GT_TAX_TYPE_MNG(i));

Line 4353: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.BEGIN',

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:
4357: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 4359: 'ZX.TRL.ZX_AR_POPULATE_PKG.populate_meaning.END',

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:
4363: END populate_meaning;

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 4375: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');

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
4379: UPDATE ZX_REP_TRX_DETAIL_T SET

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 4456: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(-)');

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:
4460: EXCEPTION

Line 4468: 'ZX.TRL.ZX_AR_POPULATE_PKG.UPDATE_REP_DETAIL_T',

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:
4472: G_RETCODE := 2;

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 4643: 'ZX_AR_POPULATE_PKG: initialize_variables(+)');

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;
4647:

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 4813: 'ZX_AR_POPULATE_PKG: initialize_variables(-)');

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
4817: WHEN OTHERS THEN

Line 4824: 'ZX.TRL.ZX_AR_POPULATE_PKG.initialize_variables',

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:
4828: END initialize_variables ;

Line 4830: END ZX_AR_POPULATE_PKG;

4826: END IF;
4827:
4828: END initialize_variables ;
4829:
4830: END ZX_AR_POPULATE_PKG;