DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on FND_MESSAGE

Line 569: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

565:
566: EXCEPTION
567: WHEN OTHERS THEN
568: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
569: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
570: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
571: FND_MSG_PUB.Add;
572: IF (g_level_unexpected >= g_current_runtime_level ) THEN
573: FND_LOG.STRING(g_level_unexpected,

Line 570: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);

566: EXCEPTION
567: WHEN OTHERS THEN
568: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
569: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
570: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
571: FND_MSG_PUB.Add;
572: IF (g_level_unexpected >= g_current_runtime_level ) THEN
573: FND_LOG.STRING(g_level_unexpected,
574: 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',

Line 1098: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1094:
1095: EXCEPTION
1096: WHEN OTHERS THEN
1097: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1098: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1099: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1100: FND_MSG_PUB.Add;
1101: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_unexpected,

Line 1099: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);

1095: EXCEPTION
1096: WHEN OTHERS THEN
1097: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1098: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1099: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1100: FND_MSG_PUB.Add;
1101: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_unexpected,
1103: 'ZX.TRL.ZX_EXTRACT_PKG.initialize',

Line 1316: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1316: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1317: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1318: FND_MSG_PUB.Add;
1319: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1320: FND_LOG.STRING(g_level_unexpected,

Line 1317: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);

1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1316: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1317: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1318: FND_MSG_PUB.Add;
1319: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1320: FND_LOG.STRING(g_level_unexpected,
1321: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',

Line 1364: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1364: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1365: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1366: FND_MSG_PUB.Add;
1367: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1368: FND_LOG.STRING(g_level_unexpected,

Line 1365: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);

1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1364: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1365: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1366: FND_MSG_PUB.Add;
1367: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1368: FND_LOG.STRING(g_level_unexpected,
1369: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',

Line 1387: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1383:
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1387: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1388: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1389: FND_MSG_PUB.Add;
1390: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1391: FND_LOG.STRING(g_level_unexpected,

Line 1388: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);

1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1387: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1388: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1389: FND_MSG_PUB.Add;
1390: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1391: FND_LOG.STRING(g_level_unexpected,
1392: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',

Line 1454: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1450:
1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1454: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1455: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1456: FND_MSG_PUB.Add;
1457: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1458: FND_LOG.STRING(g_level_unexpected,

Line 1455: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);

1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1454: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1455: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1456: FND_MSG_PUB.Add;
1457: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1458: FND_LOG.STRING(g_level_unexpected,
1459: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',

Line 1562: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1558: FETCH ledger_ou_cursor INTO l_operating_unit_id;
1559:
1560: IF ledger_ou_cursor%NOTFOUND THEN
1561: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1562: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1563: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1564: -- FND_MSG_PUB.Add;
1565: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1566: FND_LOG.STRING(g_level_unexpected,

Line 1563: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);

1559:
1560: IF ledger_ou_cursor%NOTFOUND THEN
1561: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1562: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1563: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1564: -- FND_MSG_PUB.Add;
1565: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1566: FND_LOG.STRING(g_level_unexpected,
1567: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',

Line 1598: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1594:
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1598: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1599: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1600: FND_MSG_PUB.Add;
1601: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_unexpected,

Line 1599: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);

1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1598: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1599: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1600: FND_MSG_PUB.Add;
1601: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_unexpected,
1603: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',

Line 1730: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1726:
1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1730: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1731: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1732: FND_MSG_PUB.Add;
1733: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1734: FND_LOG.STRING(g_level_unexpected,

Line 1731: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);

1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1730: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1731: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1732: FND_MSG_PUB.Add;
1733: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1734: FND_LOG.STRING(g_level_unexpected,
1735: 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info',

Line 1841: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1837:
1838: EXCEPTION
1839: WHEN OTHERS THEN
1840: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1841: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
1843: FND_MSG_PUB.Add;
1844: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1845: FND_LOG.STRING(g_level_unexpected,

Line 1842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);

1838: EXCEPTION
1839: WHEN OTHERS THEN
1840: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1841: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
1843: FND_MSG_PUB.Add;
1844: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1845: FND_LOG.STRING(g_level_unexpected,
1846: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',

Line 1971: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1967:
1968: EXCEPTION
1969: WHEN OTHERS THEN
1970: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1971: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1972: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1973: FND_MSG_PUB.Add;
1974: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1975: FND_LOG.STRING(g_level_unexpected,

Line 1972: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);

1968: EXCEPTION
1969: WHEN OTHERS THEN
1970: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1971: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1972: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1973: FND_MSG_PUB.Add;
1974: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1975: FND_LOG.STRING(g_level_unexpected,
1976: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',

Line 2103: L_MSG := FND_MESSAGE.GET;

2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: STACK_ERROR('FND','SQL_PLSQL_ERROR','ERRNO',SQLCODE,'REASON',SQLERRM,
2102: 'ROUTINE','ZX_EXTRACT_PKG.CLEANUP');
2103: L_MSG := FND_MESSAGE.GET;
2104:
2105: END;
2106:
2107: declarer_id_lookup_table.delete;

Line 2682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2678:
2679: EXCEPTION
2680: WHEN OTHERS THEN
2681: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
2684: FND_MSG_PUB.Add;
2685: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2686: FND_LOG.STRING(g_level_unexpected,

Line 2683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);

2679: EXCEPTION
2680: WHEN OTHERS THEN
2681: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
2684: FND_MSG_PUB.Add;
2685: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2686: FND_LOG.STRING(g_level_unexpected,
2687: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',

Line 2763: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2759:
2760: EXCEPTION
2761: WHEN OTHERS THEN
2762: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2763: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2764: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
2765: FND_MSG_PUB.Add;
2766: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2767: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',

Line 2764: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);

2760: EXCEPTION
2761: WHEN OTHERS THEN
2762: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2763: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2764: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
2765: FND_MSG_PUB.Add;
2766: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2767: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',
2768: g_error_buffer);

Line 2877: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2873:
2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2877: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2878: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
2879: FND_MSG_PUB.Add;
2880: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2881: FND_LOG.STRING(g_level_unexpected,

Line 2878: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);

2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2877: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2878: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
2879: FND_MSG_PUB.Add;
2880: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2881: FND_LOG.STRING(g_level_unexpected,
2882: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',

Line 2921: fnd_message.set_name(nvl(p_application,'AR'),nvl(p_msgname,'GENERIC_MESSAGE'));

2917: p_token3 VARCHAR2 DEFAULT NULL,
2918: p_value3 VARCHAR2 DEFAULT NULL ) IS
2919: BEGIN
2920:
2921: fnd_message.set_name(nvl(p_application,'AR'),nvl(p_msgname,'GENERIC_MESSAGE'));
2922:
2923: IF ( p_token1 IS NOT NULL ) THEN
2924: fnd_message.set_token(p_token1, p_value1);
2925: END IF;

Line 2924: fnd_message.set_token(p_token1, p_value1);

2920:
2921: fnd_message.set_name(nvl(p_application,'AR'),nvl(p_msgname,'GENERIC_MESSAGE'));
2922:
2923: IF ( p_token1 IS NOT NULL ) THEN
2924: fnd_message.set_token(p_token1, p_value1);
2925: END IF;
2926:
2927: IF ( p_token2 IS NOT NULL ) THEN
2928: fnd_message.set_token(p_token2, p_value2);

Line 2928: fnd_message.set_token(p_token2, p_value2);

2924: fnd_message.set_token(p_token1, p_value1);
2925: END IF;
2926:
2927: IF ( p_token2 IS NOT NULL ) THEN
2928: fnd_message.set_token(p_token2, p_value2);
2929: END IF;
2930:
2931:
2932: IF ( p_token3 IS NOT NULL ) THEN

Line 2933: fnd_message.set_token(p_token3, p_value3);

2929: END IF;
2930:
2931:
2932: IF ( p_token3 IS NOT NULL ) THEN
2933: fnd_message.set_token(p_token3, p_value3);
2934: END IF;
2935:
2936: END stack_error;
2937: