186: WHEN OTHERS THEN
187: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
188: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_project_tax- '||
189: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
190: FND_MSG_PUB.Add;
191:
192: IF (g_level_unexpected >= g_current_runtime_level ) THEN
193: FND_LOG.STRING(g_level_unexpected,
194: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_project_tax',
287: WHEN OTHERS THEN
288: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
289: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_expenditure_tax- '||
290: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
291: FND_MSG_PUB.Add;
292:
293: IF (g_level_unexpected >= g_current_runtime_level ) THEN
294: FND_LOG.STRING(g_level_unexpected,
295: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_expenditure_tax',
357: WHEN OTHERS THEN
358: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
359: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_event_tax- '||
360: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
361: FND_MSG_PUB.Add;
362:
363: IF (g_level_unexpected >= g_current_runtime_level ) THEN
364: FND_LOG.STRING(g_level_unexpected,
365: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_event_tax',
450: WHEN OTHERS THEN
451: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
452: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_pa_default_classification- '||
453: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
454: FND_MSG_PUB.Add;
455:
456: IF (g_level_unexpected >= g_current_runtime_level ) THEN
457: FND_LOG.STRING(g_level_unexpected,
458: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
753: WHEN OTHERS THEN
754: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
755: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_pa_default_classification- '||
756: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
757: FND_MSG_PUB.Add;
758:
759: IF (g_level_unexpected >= g_current_runtime_level ) THEN
760: FND_LOG.STRING(g_level_unexpected,
761: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification',
1459: WHEN OTHERS THEN
1460: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1461: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_default_tax_classification- '||
1462: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1463: FND_MSG_PUB.Add;
1464: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1465: FND_LOG.STRING(g_level_unexpected,
1466: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1467: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1575: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1576: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1577: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1578: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_site_tax- '|| l_error_buffer);
1579: FND_MSG_PUB.Add;
1580:
1581: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1582: FND_LOG.STRING(g_level_unexpected,
1583: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_site_tax',
1718: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1719: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1720: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1721: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_customer_tax- '|| l_error_buffer);
1722: FND_MSG_PUB.Add;
1723:
1724: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1725: FND_LOG.STRING(g_level_unexpected,
1726: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_customer_tax',
1874: WHEN OTHERS THEN
1875: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1876: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_item_tax- '||
1877: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1878: FND_MSG_PUB.Add;
1879:
1880: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1881: FND_LOG.STRING(g_level_unexpected,
1882: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_item_tax',
2026: WHEN OTHERS THEN
2027: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2028: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_tax- '||
2029: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2030: FND_MSG_PUB.Add;
2031:
2032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_unexpected,
2034: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_location_tax',
2122: WHEN OTHERS THEN
2123: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2124: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_natural_acct_tax- '||
2125: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2126: FND_MSG_PUB.Add;
2127:
2128: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2129: FND_LOG.STRING(g_level_unexpected,
2130: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_natural_acct_tax',
2295: WHEN OTHERS THEN
2296: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2297: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_gl_tax_info- '||
2298: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2299: FND_MSG_PUB.Add;
2300:
2301: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2302: FND_LOG.STRING(g_level_unexpected,
2303: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_gl_tax_info',
2448: END IF;
2449: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2450: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_ar_tax_info- '||
2451: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2452: FND_MSG_PUB.Add;
2453:
2454: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2455: FND_LOG.STRING(g_level_unexpected,
2456: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_tax_info',
2600: END IF;
2601: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2602: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_pa_tax_info- '||
2603: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2604: FND_MSG_PUB.Add;
2605:
2606: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2607: FND_LOG.STRING(g_level_unexpected,
2608: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_pa_tax_info',
2675: END IF;
2676: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2677: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_ar_tax_info- '||
2678: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2679: FND_MSG_PUB.Add;
2680:
2681: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2682: FND_LOG.STRING(g_level_unexpected,
2683: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.pop_ar_system_param_info',
2759: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2760: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
2761: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize- '||
2762: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2763: FND_MSG_PUB.Add;
2764:
2765: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2766: FND_LOG.STRING(g_level_unexpected,
2767: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize', 'Error Getting GL Natural Account Segment');