DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on FND_MESSAGE

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

942:
943: EXCEPTION
944: WHEN OTHERS THEN
945: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
946: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
947: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
948: FND_MSG_PUB.Add;
949: IF (g_level_unexpected >= g_current_runtime_level ) THEN
950: FND_LOG.STRING(g_level_unexpected,

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

943: EXCEPTION
944: WHEN OTHERS THEN
945: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
946: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
947: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
948: FND_MSG_PUB.Add;
949: IF (g_level_unexpected >= g_current_runtime_level ) THEN
950: FND_LOG.STRING(g_level_unexpected,
951: 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',

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

1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1553: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1554: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1555: FND_MSG_PUB.Add;
1556: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1557: FND_LOG.STRING(g_level_unexpected,

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

1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1553: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1554: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1555: FND_MSG_PUB.Add;
1556: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1557: FND_LOG.STRING(g_level_unexpected,
1558: 'ZX.TRL.ZX_EXTRACT_PKG.initialize',

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

1781:
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1785: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1786: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1787: FND_MSG_PUB.Add;
1788: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1789: FND_LOG.STRING(g_level_unexpected,

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

1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1785: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1786: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1787: FND_MSG_PUB.Add;
1788: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1789: FND_LOG.STRING(g_level_unexpected,
1790: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',

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

1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1832: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1833: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1834: FND_MSG_PUB.Add;
1835: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1836: FND_LOG.STRING(g_level_unexpected,

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

1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1832: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1833: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1834: FND_MSG_PUB.Add;
1835: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1836: FND_LOG.STRING(g_level_unexpected,
1837: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',

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

1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1855: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1856: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1857: FND_MSG_PUB.Add;
1858: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_unexpected,

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

1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1855: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1856: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1857: FND_MSG_PUB.Add;
1858: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_unexpected,
1860: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',

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

1917:
1918: EXCEPTION
1919: WHEN OTHERS THEN
1920: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1921: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1923: FND_MSG_PUB.Add;
1924: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1925: FND_LOG.STRING(g_level_unexpected,

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

1918: EXCEPTION
1919: WHEN OTHERS THEN
1920: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1921: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1923: FND_MSG_PUB.Add;
1924: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1925: FND_LOG.STRING(g_level_unexpected,
1926: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',

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

2025: FETCH ledger_ou_cursor INTO l_operating_unit_id;
2026:
2027: IF ledger_ou_cursor%NOTFOUND THEN
2028: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2029: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2030: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2031: -- FND_MSG_PUB.Add;
2032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_unexpected,

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

2026:
2027: IF ledger_ou_cursor%NOTFOUND THEN
2028: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2029: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2030: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2031: -- FND_MSG_PUB.Add;
2032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_unexpected,
2034: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',

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

2061:
2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2065: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2066: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2067: FND_MSG_PUB.Add;
2068: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2069: FND_LOG.STRING(g_level_unexpected,

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

2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2065: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2066: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2067: FND_MSG_PUB.Add;
2068: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2069: FND_LOG.STRING(g_level_unexpected,
2070: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',

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

2193:
2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2197: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2198: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2199: FND_MSG_PUB.Add;
2200: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2201: FND_LOG.STRING(g_level_unexpected,

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

2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2197: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2198: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2199: FND_MSG_PUB.Add;
2200: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2201: FND_LOG.STRING(g_level_unexpected,
2202: 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info',

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

2303:
2304: EXCEPTION
2305: WHEN OTHERS THEN
2306: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2307: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2308: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
2309: FND_MSG_PUB.Add;
2310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_unexpected,

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

2304: EXCEPTION
2305: WHEN OTHERS THEN
2306: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2307: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2308: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
2309: FND_MSG_PUB.Add;
2310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_unexpected,
2312: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',

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

2428:
2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2432: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2433: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2434: FND_MSG_PUB.Add;
2435: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2436: FND_LOG.STRING(g_level_unexpected,

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

2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2432: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2433: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2434: FND_MSG_PUB.Add;
2435: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2436: FND_LOG.STRING(g_level_unexpected,
2437: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',

Line 2564: L_MSG := FND_MESSAGE.GET;

2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: STACK_ERROR('FND','SQL_PLSQL_ERROR','ERRNO',SQLCODE,'REASON',SQLERRM,
2563: 'ROUTINE','ZX_EXTRACT_PKG.CLEANUP');
2564: L_MSG := FND_MESSAGE.GET;
2565:
2566: END;
2567:
2568: declarer_id_lookup_table.delete;

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

3137:
3138: EXCEPTION
3139: WHEN OTHERS THEN
3140: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3141: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
3143: FND_MSG_PUB.Add;
3144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3145: FND_LOG.STRING(g_level_unexpected,

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

3138: EXCEPTION
3139: WHEN OTHERS THEN
3140: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3141: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
3143: FND_MSG_PUB.Add;
3144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3145: FND_LOG.STRING(g_level_unexpected,
3146: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',

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

3218:
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3222: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3223: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
3224: FND_MSG_PUB.Add;
3225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3226: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',

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

3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3222: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3223: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
3224: FND_MSG_PUB.Add;
3225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3226: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',
3227: g_error_buffer);

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

3332:
3333: EXCEPTION
3334: WHEN OTHERS THEN
3335: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
3338: FND_MSG_PUB.Add;
3339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_unexpected,

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

3333: EXCEPTION
3334: WHEN OTHERS THEN
3335: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
3338: FND_MSG_PUB.Add;
3339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_unexpected,
3341: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',

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

3376: p_token3 VARCHAR2 DEFAULT NULL,
3377: p_value3 VARCHAR2 DEFAULT NULL ) IS
3378: BEGIN
3379:
3380: fnd_message.set_name(nvl(p_application,'AR'),nvl(p_msgname,'GENERIC_MESSAGE'));
3381:
3382: IF ( p_token1 IS NOT NULL ) THEN
3383: fnd_message.set_token(p_token1, p_value1);
3384: END IF;

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

3379:
3380: fnd_message.set_name(nvl(p_application,'AR'),nvl(p_msgname,'GENERIC_MESSAGE'));
3381:
3382: IF ( p_token1 IS NOT NULL ) THEN
3383: fnd_message.set_token(p_token1, p_value1);
3384: END IF;
3385:
3386: IF ( p_token2 IS NOT NULL ) THEN
3387: fnd_message.set_token(p_token2, p_value2);

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

3383: fnd_message.set_token(p_token1, p_value1);
3384: END IF;
3385:
3386: IF ( p_token2 IS NOT NULL ) THEN
3387: fnd_message.set_token(p_token2, p_value2);
3388: END IF;
3389:
3390:
3391: IF ( p_token3 IS NOT NULL ) THEN

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

3388: END IF;
3389:
3390:
3391: IF ( p_token3 IS NOT NULL ) THEN
3392: fnd_message.set_token(p_token3, p_value3);
3393: END IF;
3394:
3395: END stack_error;
3396: