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.EGO_DATA_SECURITY dependencies on FND_MESSAGE

Line 455: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

451: x_pk5_column_type ,
452: x_database_object_name;
453:
454: IF(c_pk%NOTFOUND) THEN
455: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
456: fnd_message.set_token('ROUTINE',
457: g_pkg_name || '.'|| l_api_name);
458: fnd_message.set_token('REASON',
459: 'FND_OBJECTS does not have column obj_name with value:'||

Line 456: fnd_message.set_token('ROUTINE',

452: x_database_object_name;
453:
454: IF(c_pk%NOTFOUND) THEN
455: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
456: fnd_message.set_token('ROUTINE',
457: g_pkg_name || '.'|| l_api_name);
458: fnd_message.set_token('REASON',
459: 'FND_OBJECTS does not have column obj_name with value:'||
460: p_object_name);

Line 458: fnd_message.set_token('REASON',

454: IF(c_pk%NOTFOUND) THEN
455: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
456: fnd_message.set_token('ROUTINE',
457: g_pkg_name || '.'|| l_api_name);
458: fnd_message.set_token('REASON',
459: 'FND_OBJECTS does not have column obj_name with value:'||
460: p_object_name);
461: return G_RETURN_UNEXP_ERR;
462: end if;

Line 760: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

756: ' - p_user_name: '|| p_user_name
757: );
758:
759: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
760: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
761: fnd_message.set_token('ROUTINE',
762: g_pkg_name || '.'|| l_api_name);
763: fnd_message.set_token('REASON',
764: 'Unsupported version '|| to_char(p_api_version)||

Line 761: fnd_message.set_token('ROUTINE',

757: );
758:
759: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
760: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
761: fnd_message.set_token('ROUTINE',
762: g_pkg_name || '.'|| l_api_name);
763: fnd_message.set_token('REASON',
764: 'Unsupported version '|| to_char(p_api_version)||
765: ' passed to API; expecting version '||

Line 763: fnd_message.set_token('REASON',

759: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
760: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
761: fnd_message.set_token('ROUTINE',
762: g_pkg_name || '.'|| l_api_name);
763: fnd_message.set_token('REASON',
764: 'Unsupported version '|| to_char(p_api_version)||
765: ' passed to API; expecting version '||
766: to_char(l_api_version));
767: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 1166: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1162: ,p_message => 'Returning EXCEPTION '||SQLERRM
1163: );
1164: RETURN G_RETURN_UNEXP_ERR;
1165: WHEN OTHERS THEN
1166: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1167: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1168: fnd_message.set_token('ERRNO', SQLCODE);
1169: fnd_message.set_token('REASON', SQLERRM);
1170: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 1167: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

1163: );
1164: RETURN G_RETURN_UNEXP_ERR;
1165: WHEN OTHERS THEN
1166: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1167: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1168: fnd_message.set_token('ERRNO', SQLCODE);
1169: fnd_message.set_token('REASON', SQLERRM);
1170: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1171: ,p_module => l_api_name

Line 1168: fnd_message.set_token('ERRNO', SQLCODE);

1164: RETURN G_RETURN_UNEXP_ERR;
1165: WHEN OTHERS THEN
1166: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1167: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1168: fnd_message.set_token('ERRNO', SQLCODE);
1169: fnd_message.set_token('REASON', SQLERRM);
1170: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1171: ,p_module => l_api_name
1172: ,p_message => 'Returning EXCEPTION '||SQLERRM

Line 1169: fnd_message.set_token('REASON', SQLERRM);

1165: WHEN OTHERS THEN
1166: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1167: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1168: fnd_message.set_token('ERRNO', SQLCODE);
1169: fnd_message.set_token('REASON', SQLERRM);
1170: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1171: ,p_module => l_api_name
1172: ,p_message => 'Returning EXCEPTION '||SQLERRM
1173: );

Line 1282: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

1278: );
1279:
1280: -- check for call compatibility.
1281: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1282: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1283: fnd_message.set_token('ROUTINE',
1284: g_pkg_name || '.'|| l_api_name);
1285: fnd_message.set_token('REASON',
1286: 'Unsupported version '|| to_char(p_api_version)||

Line 1283: fnd_message.set_token('ROUTINE',

1279:
1280: -- check for call compatibility.
1281: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1282: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1283: fnd_message.set_token('ROUTINE',
1284: g_pkg_name || '.'|| l_api_name);
1285: fnd_message.set_token('REASON',
1286: 'Unsupported version '|| to_char(p_api_version)||
1287: ' passed to API; expecting version '||

Line 1285: fnd_message.set_token('REASON',

1281: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1282: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1283: fnd_message.set_token('ROUTINE',
1284: g_pkg_name || '.'|| l_api_name);
1285: fnd_message.set_token('REASON',
1286: 'Unsupported version '|| to_char(p_api_version)||
1287: ' passed to API; expecting version '||
1288: to_char(l_api_version));
1289: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 1791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1787: END IF; -- End of if l_result is 'X' else clause
1788:
1789: EXCEPTION
1790: WHEN OTHERS THEN
1791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1792: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1793: fnd_message.set_token('ERRNO', SQLCODE);
1794: fnd_message.set_token('REASON', SQLERRM);
1795: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 1792: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

1788:
1789: EXCEPTION
1790: WHEN OTHERS THEN
1791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1792: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1793: fnd_message.set_token('ERRNO', SQLCODE);
1794: fnd_message.set_token('REASON', SQLERRM);
1795: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1796: ,p_module => l_api_name

Line 1793: fnd_message.set_token('ERRNO', SQLCODE);

1789: EXCEPTION
1790: WHEN OTHERS THEN
1791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1792: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1793: fnd_message.set_token('ERRNO', SQLCODE);
1794: fnd_message.set_token('REASON', SQLERRM);
1795: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1796: ,p_module => l_api_name
1797: ,p_message => 'Returning EXCEPTION '||SQLERRM

Line 1794: fnd_message.set_token('REASON', SQLERRM);

1790: WHEN OTHERS THEN
1791: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1792: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1793: fnd_message.set_token('ERRNO', SQLCODE);
1794: fnd_message.set_token('REASON', SQLERRM);
1795: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1796: ,p_module => l_api_name
1797: ,p_message => 'Returning EXCEPTION '||SQLERRM
1798: );

Line 1894: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

1890: ' - p_user_name: '|| p_user_name
1891: );
1892: -- check for call compatibility.
1893: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1894: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1895: fnd_message.set_token('ROUTINE',
1896: g_pkg_name || '.'|| l_api_name);
1897: fnd_message.set_token('REASON',
1898: 'Unsupported version '|| to_char(p_api_version)||

Line 1895: fnd_message.set_token('ROUTINE',

1891: );
1892: -- check for call compatibility.
1893: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1894: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1895: fnd_message.set_token('ROUTINE',
1896: g_pkg_name || '.'|| l_api_name);
1897: fnd_message.set_token('REASON',
1898: 'Unsupported version '|| to_char(p_api_version)||
1899: ' passed to API; expecting version '||

Line 1897: fnd_message.set_token('REASON',

1893: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1894: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1895: fnd_message.set_token('ROUTINE',
1896: g_pkg_name || '.'|| l_api_name);
1897: fnd_message.set_token('REASON',
1898: 'Unsupported version '|| to_char(p_api_version)||
1899: ' passed to API; expecting version '||
1900: to_char(l_api_version));
1901: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 2488: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2484:
2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: --dbms_output.put_line('error :' || SQLERRM);
2488: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2489: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2490: fnd_message.set_token('ERRNO', SQLCODE);
2491: fnd_message.set_token('REASON', SQLERRM);
2492: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 2489: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: --dbms_output.put_line('error :' || SQLERRM);
2488: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2489: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2490: fnd_message.set_token('ERRNO', SQLCODE);
2491: fnd_message.set_token('REASON', SQLERRM);
2492: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2493: ,p_module => l_api_name

Line 2490: fnd_message.set_token('ERRNO', SQLCODE);

2486: WHEN OTHERS THEN
2487: --dbms_output.put_line('error :' || SQLERRM);
2488: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2489: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2490: fnd_message.set_token('ERRNO', SQLCODE);
2491: fnd_message.set_token('REASON', SQLERRM);
2492: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2493: ,p_module => l_api_name
2494: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

Line 2491: fnd_message.set_token('REASON', SQLERRM);

2487: --dbms_output.put_line('error :' || SQLERRM);
2488: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2489: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2490: fnd_message.set_token('ERRNO', SQLCODE);
2491: fnd_message.set_token('REASON', SQLERRM);
2492: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2493: ,p_module => l_api_name
2494: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM
2495: );

Line 2608: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

2604: );
2605:
2606: -- check for call compatibility.
2607: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
2608: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
2609: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
2610: fnd_message.set_token('REASON', 'Unsupported version '||
2611: to_char(p_api_version)||
2612: ' passed to API; expecting version '||

Line 2609: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

2605:
2606: -- check for call compatibility.
2607: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
2608: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
2609: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
2610: fnd_message.set_token('REASON', 'Unsupported version '||
2611: to_char(p_api_version)||
2612: ' passed to API; expecting version '||
2613: to_char(l_api_version));

Line 2610: fnd_message.set_token('REASON', 'Unsupported version '||

2606: -- check for call compatibility.
2607: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
2608: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
2609: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
2610: fnd_message.set_token('REASON', 'Unsupported version '||
2611: to_char(p_api_version)||
2612: ' passed to API; expecting version '||
2613: to_char(l_api_version));
2614: x_return_status := G_RETURN_UNEXP_ERR;

Line 3323: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

3319: );
3320:
3321: EXCEPTION
3322: WHEN OTHERS THEN
3323: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3324: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3325: fnd_message.set_token('ERRNO', SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: x_return_status := G_RETURN_UNEXP_ERR;

Line 3324: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

3320:
3321: EXCEPTION
3322: WHEN OTHERS THEN
3323: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3324: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3325: fnd_message.set_token('ERRNO', SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: x_return_status := G_RETURN_UNEXP_ERR;
3328: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 3325: fnd_message.set_token('ERRNO', SQLCODE);

3321: EXCEPTION
3322: WHEN OTHERS THEN
3323: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3324: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3325: fnd_message.set_token('ERRNO', SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: x_return_status := G_RETURN_UNEXP_ERR;
3328: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
3329: ,p_module => l_api_name

Line 3326: fnd_message.set_token('REASON', SQLERRM);

3322: WHEN OTHERS THEN
3323: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3324: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3325: fnd_message.set_token('ERRNO', SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: x_return_status := G_RETURN_UNEXP_ERR;
3328: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
3329: ,p_module => l_api_name
3330: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

Line 3413: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3409: );
3410:
3411: -- check for call compatibility.
3412: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3413: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3414: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3415: fnd_message.set_token('REASON', 'Unsupported version '|| to_char(p_api_version)||
3416: ' passed to API; expecting version '||
3417: to_char(l_api_version));

Line 3414: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

3410:
3411: -- check for call compatibility.
3412: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3413: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3414: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3415: fnd_message.set_token('REASON', 'Unsupported version '|| to_char(p_api_version)||
3416: ' passed to API; expecting version '||
3417: to_char(l_api_version));
3418: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3415: fnd_message.set_token('REASON', 'Unsupported version '|| to_char(p_api_version)||

3411: -- check for call compatibility.
3412: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3413: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3414: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3415: fnd_message.set_token('REASON', 'Unsupported version '|| to_char(p_api_version)||
3416: ' passed to API; expecting version '||
3417: to_char(l_api_version));
3418: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3419: ,p_module => l_api_name

Line 3428: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3424: END IF;
3425:
3426: -- Check to make sure we're not using unsupported statement_type
3427: if (p_statement_type NOT IN ('BASE', 'OTHER', 'EXISTS')) then
3428: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3429: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3430: fnd_message.set_token('REASON', 'Unsupported p_statement_type: '|| p_statement_type);
3431: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3432: ,p_module => l_api_name

Line 3429: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

3425:
3426: -- Check to make sure we're not using unsupported statement_type
3427: if (p_statement_type NOT IN ('BASE', 'OTHER', 'EXISTS')) then
3428: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3429: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3430: fnd_message.set_token('REASON', 'Unsupported p_statement_type: '|| p_statement_type);
3431: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3432: ,p_module => l_api_name
3433: ,p_message => 'Returning as statement type is not supported'

Line 3430: fnd_message.set_token('REASON', 'Unsupported p_statement_type: '|| p_statement_type);

3426: -- Check to make sure we're not using unsupported statement_type
3427: if (p_statement_type NOT IN ('BASE', 'OTHER', 'EXISTS')) then
3428: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3429: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3430: fnd_message.set_token('REASON', 'Unsupported p_statement_type: '|| p_statement_type);
3431: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3432: ,p_module => l_api_name
3433: ,p_message => 'Returning as statement type is not supported'
3434: );

Line 3442: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3438:
3439: /* ### We haven't yet added support for NULL (all) function in arg. */
3440: /* ### Add that support since it is in the API. */
3441: if (p_function is NULL) then
3442: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3443: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3444: fnd_message.set_token('REASON', 'Support has not yet been added for passing NULL function.');
3445: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3446: ,p_module => l_api_name

Line 3443: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

3439: /* ### We haven't yet added support for NULL (all) function in arg. */
3440: /* ### Add that support since it is in the API. */
3441: if (p_function is NULL) then
3442: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3443: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3444: fnd_message.set_token('REASON', 'Support has not yet been added for passing NULL function.');
3445: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3446: ,p_module => l_api_name
3447: ,p_message => 'Returning as mand parameter Function is not available '

Line 3444: fnd_message.set_token('REASON', 'Support has not yet been added for passing NULL function.');

3440: /* ### Add that support since it is in the API. */
3441: if (p_function is NULL) then
3442: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3443: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3444: fnd_message.set_token('REASON', 'Support has not yet been added for passing NULL function.');
3445: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3446: ,p_module => l_api_name
3447: ,p_message => 'Returning as mand parameter Function is not available '
3448: );

Line 3461: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3457: OR (p_pk3_alias is not NULL)
3458: OR (p_pk4_alias is not NULL)
3459: OR (p_pk5_alias is not NULL))) then
3460:
3461: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3462: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3463: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3464: ' p_grant_instance_type = SET.');
3465: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3462: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

3458: OR (p_pk4_alias is not NULL)
3459: OR (p_pk5_alias is not NULL))) then
3460:
3461: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3462: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3463: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3464: ' p_grant_instance_type = SET.');
3465: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3466: ,p_module => l_api_name

Line 3463: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||

3459: OR (p_pk5_alias is not NULL))) then
3460:
3461: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3462: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3463: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3464: ' p_grant_instance_type = SET.');
3465: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3466: ,p_module => l_api_name
3467: ,p_message => 'Returning as incompatible combination for p_grant_instance_type = SET '

Line 3476: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3472:
3473: /* We don't currently support BASE mode; we will have to change to */
3474: /* a pure OR statement when VPD becomes important. */
3475: if (p_statement_type = 'BASE') then
3476: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3477: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3478: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
3479: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3480: ,p_module => l_api_name

Line 3477: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

3473: /* We don't currently support BASE mode; we will have to change to */
3474: /* a pure OR statement when VPD becomes important. */
3475: if (p_statement_type = 'BASE') then
3476: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3477: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3478: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
3479: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3480: ,p_module => l_api_name
3481: ,p_message => 'Returning as incompatible statement_type = BASE '

Line 3478: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');

3474: /* a pure OR statement when VPD becomes important. */
3475: if (p_statement_type = 'BASE') then
3476: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3477: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3478: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
3479: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3480: ,p_module => l_api_name
3481: ,p_message => 'Returning as incompatible statement_type = BASE '
3482: );

Line 3812: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');

3808: x_predicate := l_aggregate_predicate;
3809:
3810: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
3811: AND (p_statement_type = 'BASE')) then
3812: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
3813: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
3814: FND_MESSAGE.SET_TOKEN('REASON',
3815: 'The predicate was longer than the database VPD limit of '||
3816: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

Line 3813: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');

3809:
3810: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
3811: AND (p_statement_type = 'BASE')) then
3812: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
3813: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
3814: FND_MESSAGE.SET_TOKEN('REASON',
3815: 'The predicate was longer than the database VPD limit of '||
3816: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
3817: x_return_status := 'L'; /* Indicate Error */

Line 3814: FND_MESSAGE.SET_TOKEN('REASON',

3810: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
3811: AND (p_statement_type = 'BASE')) then
3812: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
3813: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
3814: FND_MESSAGE.SET_TOKEN('REASON',
3815: 'The predicate was longer than the database VPD limit of '||
3816: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
3817: x_return_status := 'L'; /* Indicate Error */
3818: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3834: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

3830: );
3831:
3832: EXCEPTION
3833: WHEN OTHERS THEN
3834: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3835: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3836: fnd_message.set_token('ERRNO', SQLCODE);
3837: fnd_message.set_token('REASON', SQLERRM);
3838: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 3835: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

3831:
3832: EXCEPTION
3833: WHEN OTHERS THEN
3834: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3835: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3836: fnd_message.set_token('ERRNO', SQLCODE);
3837: fnd_message.set_token('REASON', SQLERRM);
3838: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
3839: ,p_module => l_api_name

Line 3836: fnd_message.set_token('ERRNO', SQLCODE);

3832: EXCEPTION
3833: WHEN OTHERS THEN
3834: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3835: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3836: fnd_message.set_token('ERRNO', SQLCODE);
3837: fnd_message.set_token('REASON', SQLERRM);
3838: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
3839: ,p_module => l_api_name
3840: ,p_message => 'Returning EXCEPTION '||SQLERRM

Line 3837: fnd_message.set_token('REASON', SQLERRM);

3833: WHEN OTHERS THEN
3834: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3835: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3836: fnd_message.set_token('ERRNO', SQLCODE);
3837: fnd_message.set_token('REASON', SQLERRM);
3838: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
3839: ,p_module => l_api_name
3840: ,p_message => 'Returning EXCEPTION '||SQLERRM
3841: );

Line 3932: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3928: x_return_status := G_RETURN_SUCCESS; /* Assume Success */
3929:
3930: -- check for call compatibility.
3931: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3932: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3933: fnd_message.set_token('ROUTINE',
3934: g_pkg_name || '.'|| l_api_name);
3935: fnd_message.set_token('REASON',
3936: 'Unsupported version '|| to_char(p_api_version)||

Line 3933: fnd_message.set_token('ROUTINE',

3929:
3930: -- check for call compatibility.
3931: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3932: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3933: fnd_message.set_token('ROUTINE',
3934: g_pkg_name || '.'|| l_api_name);
3935: fnd_message.set_token('REASON',
3936: 'Unsupported version '|| to_char(p_api_version)||
3937: ' passed to API; expecting version '||

Line 3935: fnd_message.set_token('REASON',

3931: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3932: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3933: fnd_message.set_token('ROUTINE',
3934: g_pkg_name || '.'|| l_api_name);
3935: fnd_message.set_token('REASON',
3936: 'Unsupported version '|| to_char(p_api_version)||
3937: ' passed to API; expecting version '||
3938: to_char(l_api_version));
3939: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3950: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3946:
3947: -- Check to make sure we're not using unsupported statement_type
3948: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
3949: AND (p_statement_type <> 'EXISTS')) then
3950: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3951: fnd_message.set_token('ROUTINE',
3952: g_pkg_name || '.'|| l_api_name);
3953: fnd_message.set_token('REASON',
3954: 'Unsupported p_statement_type: '|| p_statement_type);

Line 3951: fnd_message.set_token('ROUTINE',

3947: -- Check to make sure we're not using unsupported statement_type
3948: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
3949: AND (p_statement_type <> 'EXISTS')) then
3950: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3951: fnd_message.set_token('ROUTINE',
3952: g_pkg_name || '.'|| l_api_name);
3953: fnd_message.set_token('REASON',
3954: 'Unsupported p_statement_type: '|| p_statement_type);
3955: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3953: fnd_message.set_token('REASON',

3949: AND (p_statement_type <> 'EXISTS')) then
3950: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3951: fnd_message.set_token('ROUTINE',
3952: g_pkg_name || '.'|| l_api_name);
3953: fnd_message.set_token('REASON',
3954: 'Unsupported p_statement_type: '|| p_statement_type);
3955: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3956: ,p_module => l_api_name
3957: ,p_message => 'Returning as statement type is not supported'

Line 3966: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3962:
3963: /* ### We haven't yet added support for NULL (all) function in arg. */
3964: /* ### Add that support since it is in the API. */
3965: if (p_function is NULL) then
3966: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3967: fnd_message.set_token('ROUTINE',
3968: g_pkg_name || '.'|| l_api_name);
3969: fnd_message.set_token('REASON',
3970: 'Support has not yet been added for passing NULL function.');

Line 3967: fnd_message.set_token('ROUTINE',

3963: /* ### We haven't yet added support for NULL (all) function in arg. */
3964: /* ### Add that support since it is in the API. */
3965: if (p_function is NULL) then
3966: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3967: fnd_message.set_token('ROUTINE',
3968: g_pkg_name || '.'|| l_api_name);
3969: fnd_message.set_token('REASON',
3970: 'Support has not yet been added for passing NULL function.');
3971: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3969: fnd_message.set_token('REASON',

3965: if (p_function is NULL) then
3966: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3967: fnd_message.set_token('ROUTINE',
3968: g_pkg_name || '.'|| l_api_name);
3969: fnd_message.set_token('REASON',
3970: 'Support has not yet been added for passing NULL function.');
3971: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3972: ,p_module => l_api_name
3973: ,p_message => 'Returning as mand parameter Function is not available '

Line 3988: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3984: OR (p_pk3_alias is not NULL)
3985: OR (p_pk4_alias is not NULL)
3986: OR (p_pk5_alias is not NULL))) then
3987:
3988: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3989: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3990: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3991: ' p_grant_instance_type = SET.');
3992: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3989: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

3985: OR (p_pk4_alias is not NULL)
3986: OR (p_pk5_alias is not NULL))) then
3987:
3988: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3989: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3990: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3991: ' p_grant_instance_type = SET.');
3992: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3993: ,p_module => l_api_name

Line 3990: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||

3986: OR (p_pk5_alias is not NULL))) then
3987:
3988: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3989: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3990: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3991: ' p_grant_instance_type = SET.');
3992: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3993: ,p_module => l_api_name
3994: ,p_message => 'Returning as incompatible combination for p_grant_instance_type = SET '

Line 4003: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

3999:
4000: /* We don't currently support BASE mode; we will have to change to */
4001: /* a pure OR statement when VPD becomes important. */
4002: if (p_statement_type = 'BASE') then
4003: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4004: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4005: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
4006: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4007: ,p_module => l_api_name

Line 4004: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

4000: /* We don't currently support BASE mode; we will have to change to */
4001: /* a pure OR statement when VPD becomes important. */
4002: if (p_statement_type = 'BASE') then
4003: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4004: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4005: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
4006: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4007: ,p_module => l_api_name
4008: ,p_message => 'Returning as incompatible statement_type = BASE '

Line 4005: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');

4001: /* a pure OR statement when VPD becomes important. */
4002: if (p_statement_type = 'BASE') then
4003: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4004: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4005: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
4006: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4007: ,p_module => l_api_name
4008: ,p_message => 'Returning as incompatible statement_type = BASE '
4009: );

Line 4299: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');

4295: x_predicate := l_aggregate_predicate;
4296:
4297: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4298: AND (p_statement_type = 'BASE'))then
4299: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4300: FND_MESSAGE.SET_TOKEN('ROUTINE',
4301: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4302: FND_MESSAGE.SET_TOKEN('REASON',
4303: 'The predicate was longer than the database VPD limit of '||

Line 4300: FND_MESSAGE.SET_TOKEN('ROUTINE',

4296:
4297: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4298: AND (p_statement_type = 'BASE'))then
4299: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4300: FND_MESSAGE.SET_TOKEN('ROUTINE',
4301: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4302: FND_MESSAGE.SET_TOKEN('REASON',
4303: 'The predicate was longer than the database VPD limit of '||
4304: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

Line 4302: FND_MESSAGE.SET_TOKEN('REASON',

4298: AND (p_statement_type = 'BASE'))then
4299: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4300: FND_MESSAGE.SET_TOKEN('ROUTINE',
4301: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4302: FND_MESSAGE.SET_TOKEN('REASON',
4303: 'The predicate was longer than the database VPD limit of '||
4304: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4305: x_return_status := 'L'; /* Indicate Error */
4306: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4322: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

4318: );
4319:
4320: EXCEPTION
4321: WHEN OTHERS THEN
4322: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4323: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4324: fnd_message.set_token('ERRNO', SQLCODE);
4325: fnd_message.set_token('REASON', SQLERRM);
4326: x_return_status := G_RETURN_UNEXP_ERR;

Line 4323: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

4319:
4320: EXCEPTION
4321: WHEN OTHERS THEN
4322: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4323: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4324: fnd_message.set_token('ERRNO', SQLCODE);
4325: fnd_message.set_token('REASON', SQLERRM);
4326: x_return_status := G_RETURN_UNEXP_ERR;
4327: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 4324: fnd_message.set_token('ERRNO', SQLCODE);

4320: EXCEPTION
4321: WHEN OTHERS THEN
4322: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4323: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4324: fnd_message.set_token('ERRNO', SQLCODE);
4325: fnd_message.set_token('REASON', SQLERRM);
4326: x_return_status := G_RETURN_UNEXP_ERR;
4327: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4328: ,p_module => l_api_name

Line 4325: fnd_message.set_token('REASON', SQLERRM);

4321: WHEN OTHERS THEN
4322: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4323: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4324: fnd_message.set_token('ERRNO', SQLCODE);
4325: fnd_message.set_token('REASON', SQLERRM);
4326: x_return_status := G_RETURN_UNEXP_ERR;
4327: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4328: ,p_module => l_api_name
4329: ,p_message => 'Returning EXCEPTION '||SQLERRM

Line 4419: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

4415: );
4416:
4417: -- check for call compatibility.
4418: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4419: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4420: fnd_message.set_token('ROUTINE',
4421: g_pkg_name || '.'|| l_api_name);
4422: fnd_message.set_token('REASON',
4423: 'Unsupported version '|| to_char(p_api_version)||

Line 4420: fnd_message.set_token('ROUTINE',

4416:
4417: -- check for call compatibility.
4418: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4419: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4420: fnd_message.set_token('ROUTINE',
4421: g_pkg_name || '.'|| l_api_name);
4422: fnd_message.set_token('REASON',
4423: 'Unsupported version '|| to_char(p_api_version)||
4424: ' passed to API; expecting version '||

Line 4422: fnd_message.set_token('REASON',

4418: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4419: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4420: fnd_message.set_token('ROUTINE',
4421: g_pkg_name || '.'|| l_api_name);
4422: fnd_message.set_token('REASON',
4423: 'Unsupported version '|| to_char(p_api_version)||
4424: ' passed to API; expecting version '||
4425: to_char(l_api_version));
4426: x_return_status := G_RETURN_UNEXP_ERR; /* Unexpected Error */

Line 4437: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

4433:
4434: -- Check to make sure we're not using unsupported statement_type
4435: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
4436: AND (p_statement_type <> 'EXISTS')) then
4437: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4438: fnd_message.set_token('ROUTINE',
4439: g_pkg_name || '.'|| l_api_name);
4440: fnd_message.set_token('REASON',
4441: 'Unsupported p_statement_type: '|| p_statement_type);

Line 4438: fnd_message.set_token('ROUTINE',

4434: -- Check to make sure we're not using unsupported statement_type
4435: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
4436: AND (p_statement_type <> 'EXISTS')) then
4437: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4438: fnd_message.set_token('ROUTINE',
4439: g_pkg_name || '.'|| l_api_name);
4440: fnd_message.set_token('REASON',
4441: 'Unsupported p_statement_type: '|| p_statement_type);
4442: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4440: fnd_message.set_token('REASON',

4436: AND (p_statement_type <> 'EXISTS')) then
4437: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4438: fnd_message.set_token('ROUTINE',
4439: g_pkg_name || '.'|| l_api_name);
4440: fnd_message.set_token('REASON',
4441: 'Unsupported p_statement_type: '|| p_statement_type);
4442: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4443: ,p_module => l_api_name
4444: ,p_message => 'Returning as statement type is not supported'

Line 4453: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

4449:
4450: /* ### We haven't yet added support for NULL (all) function in arg. */
4451: /* ### Add that support since it is in the API. */
4452: if (p_function is NULL) then
4453: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4454: fnd_message.set_token('ROUTINE',
4455: g_pkg_name || '.'|| l_api_name);
4456: fnd_message.set_token('REASON',
4457: 'Support has not yet been added for passing NULL function.');

Line 4454: fnd_message.set_token('ROUTINE',

4450: /* ### We haven't yet added support for NULL (all) function in arg. */
4451: /* ### Add that support since it is in the API. */
4452: if (p_function is NULL) then
4453: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4454: fnd_message.set_token('ROUTINE',
4455: g_pkg_name || '.'|| l_api_name);
4456: fnd_message.set_token('REASON',
4457: 'Support has not yet been added for passing NULL function.');
4458: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4456: fnd_message.set_token('REASON',

4452: if (p_function is NULL) then
4453: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4454: fnd_message.set_token('ROUTINE',
4455: g_pkg_name || '.'|| l_api_name);
4456: fnd_message.set_token('REASON',
4457: 'Support has not yet been added for passing NULL function.');
4458: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4459: ,p_module => l_api_name
4460: ,p_message => 'Returning as mand parameter Function is not available '

Line 4473: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

4469: OR (p_pk2_alias is not NULL)
4470: OR (p_pk3_alias is not NULL)
4471: OR (p_pk4_alias is not NULL)
4472: OR (p_pk5_alias is not NULL))) then
4473: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4474: fnd_message.set_token('ROUTINE',
4475: g_pkg_name || '.'|| l_api_name);
4476: fnd_message.set_token('REASON',
4477: 'Unsupported mode arguments: '||

Line 4474: fnd_message.set_token('ROUTINE',

4470: OR (p_pk3_alias is not NULL)
4471: OR (p_pk4_alias is not NULL)
4472: OR (p_pk5_alias is not NULL))) then
4473: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4474: fnd_message.set_token('ROUTINE',
4475: g_pkg_name || '.'|| l_api_name);
4476: fnd_message.set_token('REASON',
4477: 'Unsupported mode arguments: '||
4478: 'p_statement_type = BASE or p_grant_instance_type = SET.');

Line 4476: fnd_message.set_token('REASON',

4472: OR (p_pk5_alias is not NULL))) then
4473: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4474: fnd_message.set_token('ROUTINE',
4475: g_pkg_name || '.'|| l_api_name);
4476: fnd_message.set_token('REASON',
4477: 'Unsupported mode arguments: '||
4478: 'p_statement_type = BASE or p_grant_instance_type = SET.');
4479: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4480: ,p_module => l_api_name

Line 4490: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

4486:
4487: /* We don't currently support BASE mode; we will have to change to */
4488: /* a pure OR statement when VPD becomes important. */
4489: if (p_statement_type = 'BASE') then
4490: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4491: fnd_message.set_token('ROUTINE',
4492: g_pkg_name || '.'|| l_api_name);
4493: fnd_message.set_token('REASON',
4494: 'Support has not yet been added for '||

Line 4491: fnd_message.set_token('ROUTINE',

4487: /* We don't currently support BASE mode; we will have to change to */
4488: /* a pure OR statement when VPD becomes important. */
4489: if (p_statement_type = 'BASE') then
4490: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4491: fnd_message.set_token('ROUTINE',
4492: g_pkg_name || '.'|| l_api_name);
4493: fnd_message.set_token('REASON',
4494: 'Support has not yet been added for '||
4495: 'p_statement_type = BASE.');

Line 4493: fnd_message.set_token('REASON',

4489: if (p_statement_type = 'BASE') then
4490: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4491: fnd_message.set_token('ROUTINE',
4492: g_pkg_name || '.'|| l_api_name);
4493: fnd_message.set_token('REASON',
4494: 'Support has not yet been added for '||
4495: 'p_statement_type = BASE.');
4496: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4497: ,p_module => l_api_name

Line 4785: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');

4781: x_predicate :=l_aggregate_predicate;
4782:
4783: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4784: AND (p_statement_type = 'BASE'))then
4785: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4786: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4787: FND_MESSAGE.SET_TOKEN('REASON',
4788: 'The predicate was longer than the database VPD limit of '||
4789: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

Line 4786: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');

4782:
4783: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4784: AND (p_statement_type = 'BASE'))then
4785: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4786: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4787: FND_MESSAGE.SET_TOKEN('REASON',
4788: 'The predicate was longer than the database VPD limit of '||
4789: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4790: x_return_status := 'L'; /* Indicate Error */

Line 4787: FND_MESSAGE.SET_TOKEN('REASON',

4783: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4784: AND (p_statement_type = 'BASE'))then
4785: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4786: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4787: FND_MESSAGE.SET_TOKEN('REASON',
4788: 'The predicate was longer than the database VPD limit of '||
4789: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4790: x_return_status := 'L'; /* Indicate Error */
4791: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

4804: );
4805:
4806: EXCEPTION
4807: WHEN OTHERS THEN
4808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4809: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4810: fnd_message.set_token('ERRNO', SQLCODE);
4811: fnd_message.set_token('REASON', SQLERRM);
4812: x_return_status := G_RETURN_UNEXP_ERR;

Line 4809: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

4805:
4806: EXCEPTION
4807: WHEN OTHERS THEN
4808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4809: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4810: fnd_message.set_token('ERRNO', SQLCODE);
4811: fnd_message.set_token('REASON', SQLERRM);
4812: x_return_status := G_RETURN_UNEXP_ERR;
4813: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 4810: fnd_message.set_token('ERRNO', SQLCODE);

4806: EXCEPTION
4807: WHEN OTHERS THEN
4808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4809: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4810: fnd_message.set_token('ERRNO', SQLCODE);
4811: fnd_message.set_token('REASON', SQLERRM);
4812: x_return_status := G_RETURN_UNEXP_ERR;
4813: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4814: ,p_module => l_api_name

Line 4811: fnd_message.set_token('REASON', SQLERRM);

4807: WHEN OTHERS THEN
4808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4809: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4810: fnd_message.set_token('ERRNO', SQLCODE);
4811: fnd_message.set_token('REASON', SQLERRM);
4812: x_return_status := G_RETURN_UNEXP_ERR;
4813: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4814: ,p_module => l_api_name
4815: ,p_message => 'Returning EXCEPTION '||SQLERRM

Line 5186: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

5182: END IF;
5183:
5184: -- check for call compatibility.
5185: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
5186: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5187: fnd_message.set_token('ROUTINE',
5188: g_pkg_name || '.'|| l_api_name);
5189: fnd_message.set_token('REASON',
5190: 'Unsupported version '|| to_char(p_api_version)||

Line 5187: fnd_message.set_token('ROUTINE',

5183:
5184: -- check for call compatibility.
5185: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
5186: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5187: fnd_message.set_token('ROUTINE',
5188: g_pkg_name || '.'|| l_api_name);
5189: fnd_message.set_token('REASON',
5190: 'Unsupported version '|| to_char(p_api_version)||
5191: ' passed to API; expecting version '||

Line 5189: fnd_message.set_token('REASON',

5185: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
5186: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5187: fnd_message.set_token('ROUTINE',
5188: g_pkg_name || '.'|| l_api_name);
5189: fnd_message.set_token('REASON',
5190: 'Unsupported version '|| to_char(p_api_version)||
5191: ' passed to API; expecting version '||
5192: to_char(l_api_version));
5193: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 5204: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

5200:
5201: -- Check to make sure we're not using unsupported statement_type
5202: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
5203: AND (p_statement_type <> 'EXISTS')) then
5204: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5205: fnd_message.set_token('ROUTINE',
5206: g_pkg_name || '.'|| l_api_name);
5207: fnd_message.set_token('REASON',
5208: 'Unsupported p_statement_type: '|| p_statement_type);

Line 5205: fnd_message.set_token('ROUTINE',

5201: -- Check to make sure we're not using unsupported statement_type
5202: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
5203: AND (p_statement_type <> 'EXISTS')) then
5204: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5205: fnd_message.set_token('ROUTINE',
5206: g_pkg_name || '.'|| l_api_name);
5207: fnd_message.set_token('REASON',
5208: 'Unsupported p_statement_type: '|| p_statement_type);
5209: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 5207: fnd_message.set_token('REASON',

5203: AND (p_statement_type <> 'EXISTS')) then
5204: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5205: fnd_message.set_token('ROUTINE',
5206: g_pkg_name || '.'|| l_api_name);
5207: fnd_message.set_token('REASON',
5208: 'Unsupported p_statement_type: '|| p_statement_type);
5209: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5210: ,p_module => l_api_name
5211: ,p_message => 'Returning as statement type is not supported'

Line 5220: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

5216:
5217: /* ### We haven't yet added support for NULL (all) function in arg. */
5218: /* ### Add that support since it is in the API. */
5219: if (p_function is NULL) then
5220: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5221: fnd_message.set_token('ROUTINE',
5222: g_pkg_name || '.'|| l_api_name);
5223: fnd_message.set_token('REASON',
5224: 'Support has not yet been added for passing NULL function.');

Line 5221: fnd_message.set_token('ROUTINE',

5217: /* ### We haven't yet added support for NULL (all) function in arg. */
5218: /* ### Add that support since it is in the API. */
5219: if (p_function is NULL) then
5220: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5221: fnd_message.set_token('ROUTINE',
5222: g_pkg_name || '.'|| l_api_name);
5223: fnd_message.set_token('REASON',
5224: 'Support has not yet been added for passing NULL function.');
5225: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 5223: fnd_message.set_token('REASON',

5219: if (p_function is NULL) then
5220: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5221: fnd_message.set_token('ROUTINE',
5222: g_pkg_name || '.'|| l_api_name);
5223: fnd_message.set_token('REASON',
5224: 'Support has not yet been added for passing NULL function.');
5225: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5226: ,p_module => l_api_name
5227: ,p_message => 'Returning as mand parameter Function is not available '

Line 5241: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

5237: OR (p_pk3_alias is not NULL)
5238: OR (p_pk4_alias is not NULL)
5239: OR (p_pk5_alias is not NULL))) then
5240:
5241: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5242: fnd_message.set_token('ROUTINE',
5243: g_pkg_name || '.'|| l_api_name);
5244: fnd_message.set_token('REASON',
5245: 'Unsupported mode arguments: '||

Line 5242: fnd_message.set_token('ROUTINE',

5238: OR (p_pk4_alias is not NULL)
5239: OR (p_pk5_alias is not NULL))) then
5240:
5241: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5242: fnd_message.set_token('ROUTINE',
5243: g_pkg_name || '.'|| l_api_name);
5244: fnd_message.set_token('REASON',
5245: 'Unsupported mode arguments: '||
5246: 'p_statement_type = BASE or p_grant_instance_type = SET.');

Line 5244: fnd_message.set_token('REASON',

5240:
5241: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5242: fnd_message.set_token('ROUTINE',
5243: g_pkg_name || '.'|| l_api_name);
5244: fnd_message.set_token('REASON',
5245: 'Unsupported mode arguments: '||
5246: 'p_statement_type = BASE or p_grant_instance_type = SET.');
5247: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5248: ,p_module => l_api_name

Line 5258: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

5254:
5255: /* We don't currently support BASE mode; we will have to change to */
5256: /* a pure OR statement when VPD becomes important. */
5257: if (p_statement_type = 'BASE') then
5258: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5259: fnd_message.set_token('ROUTINE',
5260: g_pkg_name || '.'|| l_api_name);
5261: fnd_message.set_token('REASON',
5262: 'Support has not yet been added for '||

Line 5259: fnd_message.set_token('ROUTINE',

5255: /* We don't currently support BASE mode; we will have to change to */
5256: /* a pure OR statement when VPD becomes important. */
5257: if (p_statement_type = 'BASE') then
5258: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5259: fnd_message.set_token('ROUTINE',
5260: g_pkg_name || '.'|| l_api_name);
5261: fnd_message.set_token('REASON',
5262: 'Support has not yet been added for '||
5263: 'p_statement_type = BASE.');

Line 5261: fnd_message.set_token('REASON',

5257: if (p_statement_type = 'BASE') then
5258: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5259: fnd_message.set_token('ROUTINE',
5260: g_pkg_name || '.'|| l_api_name);
5261: fnd_message.set_token('REASON',
5262: 'Support has not yet been added for '||
5263: 'p_statement_type = BASE.');
5264: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5265: ,p_module => l_api_name

Line 5805: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');

5801: x_clob_predicate := l_aggregate_predicate;
5802:
5803: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
5804: AND (p_statement_type = 'BASE'))then
5805: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
5806: FND_MESSAGE.SET_TOKEN('ROUTINE',
5807: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
5808: FND_MESSAGE.SET_TOKEN('REASON',
5809: 'The predicate was longer than the database VPD limit of '||

Line 5806: FND_MESSAGE.SET_TOKEN('ROUTINE',

5802:
5803: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
5804: AND (p_statement_type = 'BASE'))then
5805: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
5806: FND_MESSAGE.SET_TOKEN('ROUTINE',
5807: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
5808: FND_MESSAGE.SET_TOKEN('REASON',
5809: 'The predicate was longer than the database VPD limit of '||
5810: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

Line 5808: FND_MESSAGE.SET_TOKEN('REASON',

5804: AND (p_statement_type = 'BASE'))then
5805: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
5806: FND_MESSAGE.SET_TOKEN('ROUTINE',
5807: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
5808: FND_MESSAGE.SET_TOKEN('REASON',
5809: 'The predicate was longer than the database VPD limit of '||
5810: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
5811: x_return_status := 'L'; /* Indicate Error */
5812: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 5820: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

5816: end if;
5817:
5818: EXCEPTION
5819: WHEN OTHERS THEN
5820: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5821: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5822: fnd_message.set_token('ERRNO', SQLCODE);
5823: fnd_message.set_token('REASON', SQLERRM);
5824: x_return_status := G_RETURN_UNEXP_ERR;

Line 5821: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

5817:
5818: EXCEPTION
5819: WHEN OTHERS THEN
5820: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5821: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5822: fnd_message.set_token('ERRNO', SQLCODE);
5823: fnd_message.set_token('REASON', SQLERRM);
5824: x_return_status := G_RETURN_UNEXP_ERR;
5825: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 5822: fnd_message.set_token('ERRNO', SQLCODE);

5818: EXCEPTION
5819: WHEN OTHERS THEN
5820: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5821: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5822: fnd_message.set_token('ERRNO', SQLCODE);
5823: fnd_message.set_token('REASON', SQLERRM);
5824: x_return_status := G_RETURN_UNEXP_ERR;
5825: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
5826: ,p_module => l_api_name

Line 5823: fnd_message.set_token('REASON', SQLERRM);

5819: WHEN OTHERS THEN
5820: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5821: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5822: fnd_message.set_token('ERRNO', SQLCODE);
5823: fnd_message.set_token('REASON', SQLERRM);
5824: x_return_status := G_RETURN_UNEXP_ERR;
5825: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
5826: ,p_module => l_api_name
5827: ,p_message => 'Returning EXCEPTION '||SQLERRM

Line 5978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

5974: return;
5975:
5976: EXCEPTION
5977: WHEN OTHERS THEN
5978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5979: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5980: fnd_message.set_token('ERRNO', SQLCODE);
5981: fnd_message.set_token('REASON', SQLERRM);
5982: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 5979: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

5975:
5976: EXCEPTION
5977: WHEN OTHERS THEN
5978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5979: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5980: fnd_message.set_token('ERRNO', SQLCODE);
5981: fnd_message.set_token('REASON', SQLERRM);
5982: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
5983: ,p_module => l_api_name

Line 5980: fnd_message.set_token('ERRNO', SQLCODE);

5976: EXCEPTION
5977: WHEN OTHERS THEN
5978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5979: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5980: fnd_message.set_token('ERRNO', SQLCODE);
5981: fnd_message.set_token('REASON', SQLERRM);
5982: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
5983: ,p_module => l_api_name
5984: ,p_message => 'Returning EXCEPTION '||SQLERRM

Line 5981: fnd_message.set_token('REASON', SQLERRM);

5977: WHEN OTHERS THEN
5978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5979: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5980: fnd_message.set_token('ERRNO', SQLCODE);
5981: fnd_message.set_token('REASON', SQLERRM);
5982: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
5983: ,p_module => l_api_name
5984: ,p_message => 'Returning EXCEPTION '||SQLERRM
5985: );

Line 6048: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

6044: );
6045:
6046: -- check for call compatibility.
6047: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
6048: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6049: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6050: fnd_message.set_token('REASON',
6051: 'Unsupported version '|| to_char(p_api_version)||
6052: ' passed to API; expecting version '||

Line 6049: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

6045:
6046: -- check for call compatibility.
6047: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
6048: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6049: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6050: fnd_message.set_token('REASON',
6051: 'Unsupported version '|| to_char(p_api_version)||
6052: ' passed to API; expecting version '||
6053: to_char(l_api_version));

Line 6050: fnd_message.set_token('REASON',

6046: -- check for call compatibility.
6047: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
6048: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6049: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6050: fnd_message.set_token('REASON',
6051: 'Unsupported version '|| to_char(p_api_version)||
6052: ' passed to API; expecting version '||
6053: to_char(l_api_version));
6054: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 6092: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

6088: where s.instance_set_name = p_instance_set_name
6089: and s.object_id = o.object_id;
6090: exception
6091: when no_data_found then
6092: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6093: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6094: fnd_message.set_token('REASON',
6095: 'Data Error- couldn''t get predicate and/or object_name from '||
6096: 'fnd_objects and fnd_object_instance_sets for instance set '||

Line 6093: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

6089: and s.object_id = o.object_id;
6090: exception
6091: when no_data_found then
6092: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6093: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6094: fnd_message.set_token('REASON',
6095: 'Data Error- couldn''t get predicate and/or object_name from '||
6096: 'fnd_objects and fnd_object_instance_sets for instance set '||
6097: '"'||p_instance_set_name||'"');

Line 6094: fnd_message.set_token('REASON',

6090: exception
6091: when no_data_found then
6092: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6093: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6094: fnd_message.set_token('REASON',
6095: 'Data Error- couldn''t get predicate and/or object_name from '||
6096: 'fnd_objects and fnd_object_instance_sets for instance set '||
6097: '"'||p_instance_set_name||'"');
6098: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 6207: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

6203: END IF;
6204:
6205: EXCEPTION
6206: WHEN OTHERS THEN
6207: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6208: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6209: fnd_message.set_token('ERRNO', SQLCODE);
6210: fnd_message.set_token('REASON', SQLERRM);
6211: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 6208: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

6204:
6205: EXCEPTION
6206: WHEN OTHERS THEN
6207: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6208: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6209: fnd_message.set_token('ERRNO', SQLCODE);
6210: fnd_message.set_token('REASON', SQLERRM);
6211: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
6212: ,p_module => l_api_name

Line 6209: fnd_message.set_token('ERRNO', SQLCODE);

6205: EXCEPTION
6206: WHEN OTHERS THEN
6207: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6208: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6209: fnd_message.set_token('ERRNO', SQLCODE);
6210: fnd_message.set_token('REASON', SQLERRM);
6211: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
6212: ,p_module => l_api_name
6213: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

Line 6210: fnd_message.set_token('REASON', SQLERRM);

6206: WHEN OTHERS THEN
6207: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6208: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6209: fnd_message.set_token('ERRNO', SQLCODE);
6210: fnd_message.set_token('REASON', SQLERRM);
6211: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
6212: ,p_module => l_api_name
6213: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM
6214: );

Line 7018: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

7014:
7015:
7016: EXCEPTION
7017: WHEN OTHERS THEN
7018: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7019: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7020: fnd_message.set_token('ERRNO', SQLCODE);
7021: fnd_message.set_token('REASON', SQLERRM);
7022: x_return_status := G_RETURN_UNEXP_ERR;

Line 7019: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

7015:
7016: EXCEPTION
7017: WHEN OTHERS THEN
7018: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7019: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7020: fnd_message.set_token('ERRNO', SQLCODE);
7021: fnd_message.set_token('REASON', SQLERRM);
7022: x_return_status := G_RETURN_UNEXP_ERR;
7023: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 7020: fnd_message.set_token('ERRNO', SQLCODE);

7016: EXCEPTION
7017: WHEN OTHERS THEN
7018: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7019: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7020: fnd_message.set_token('ERRNO', SQLCODE);
7021: fnd_message.set_token('REASON', SQLERRM);
7022: x_return_status := G_RETURN_UNEXP_ERR;
7023: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7024: ,p_module => l_api_name

Line 7021: fnd_message.set_token('REASON', SQLERRM);

7017: WHEN OTHERS THEN
7018: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7019: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7020: fnd_message.set_token('ERRNO', SQLCODE);
7021: fnd_message.set_token('REASON', SQLERRM);
7022: x_return_status := G_RETURN_UNEXP_ERR;
7023: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7024: ,p_module => l_api_name
7025: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

Line 7135: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

7131: END LOOP;
7132:
7133: -- check for call compatibility.
7134: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7135: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7136: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
7137: fnd_message.set_token('REASON', 'Unsupported version '||
7138: to_char(p_api_version)||
7139: ' passed to API; expecting version '||

Line 7136: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);

7132:
7133: -- check for call compatibility.
7134: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7135: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7136: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
7137: fnd_message.set_token('REASON', 'Unsupported version '||
7138: to_char(p_api_version)||
7139: ' passed to API; expecting version '||
7140: to_char(l_api_version));

Line 7137: fnd_message.set_token('REASON', 'Unsupported version '||

7133: -- check for call compatibility.
7134: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7135: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7136: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
7137: fnd_message.set_token('REASON', 'Unsupported version '||
7138: to_char(p_api_version)||
7139: ' passed to API; expecting version '||
7140: to_char(l_api_version));
7141: x_return_status := G_RETURN_UNEXP_ERR;

Line 7654: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

7650: );
7651:
7652: EXCEPTION
7653: WHEN OTHERS THEN
7654: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7655: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7656: fnd_message.set_token('ERRNO', SQLCODE);
7657: fnd_message.set_token('REASON', SQLERRM);
7658: x_return_status := G_RETURN_UNEXP_ERR;

Line 7655: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

7651:
7652: EXCEPTION
7653: WHEN OTHERS THEN
7654: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7655: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7656: fnd_message.set_token('ERRNO', SQLCODE);
7657: fnd_message.set_token('REASON', SQLERRM);
7658: x_return_status := G_RETURN_UNEXP_ERR;
7659: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 7656: fnd_message.set_token('ERRNO', SQLCODE);

7652: EXCEPTION
7653: WHEN OTHERS THEN
7654: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7655: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7656: fnd_message.set_token('ERRNO', SQLCODE);
7657: fnd_message.set_token('REASON', SQLERRM);
7658: x_return_status := G_RETURN_UNEXP_ERR;
7659: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7660: ,p_module => l_api_name

Line 7657: fnd_message.set_token('REASON', SQLERRM);

7653: WHEN OTHERS THEN
7654: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7655: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7656: fnd_message.set_token('ERRNO', SQLCODE);
7657: fnd_message.set_token('REASON', SQLERRM);
7658: x_return_status := G_RETURN_UNEXP_ERR;
7659: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7660: ,p_module => l_api_name
7661: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

Line 7772: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

7768: END LOOP;
7769:
7770: -- check for call compatibility.
7771: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7772: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7773: fnd_message.set_token('ROUTINE',
7774: g_pkg_name || '.'|| l_api_name);
7775: fnd_message.set_token('REASON',
7776: 'Unsupported version '|| to_char(p_api_version)||

Line 7773: fnd_message.set_token('ROUTINE',

7769:
7770: -- check for call compatibility.
7771: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7772: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7773: fnd_message.set_token('ROUTINE',
7774: g_pkg_name || '.'|| l_api_name);
7775: fnd_message.set_token('REASON',
7776: 'Unsupported version '|| to_char(p_api_version)||
7777: ' passed to API; expecting version '||

Line 7775: fnd_message.set_token('REASON',

7771: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7772: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7773: fnd_message.set_token('ROUTINE',
7774: g_pkg_name || '.'|| l_api_name);
7775: fnd_message.set_token('REASON',
7776: 'Unsupported version '|| to_char(p_api_version)||
7777: ' passed to API; expecting version '||
7778: to_char(l_api_version));
7779: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 8117: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

8113: END LOOP;
8114:
8115: EXCEPTION
8116: WHEN OTHERS THEN
8117: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8118: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8119: fnd_message.set_token('ERRNO', SQLCODE);
8120: fnd_message.set_token('REASON', SQLERRM);
8121: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 8118: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);

8114:
8115: EXCEPTION
8116: WHEN OTHERS THEN
8117: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8118: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8119: fnd_message.set_token('ERRNO', SQLCODE);
8120: fnd_message.set_token('REASON', SQLERRM);
8121: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
8122: ,p_module => l_api_name

Line 8119: fnd_message.set_token('ERRNO', SQLCODE);

8115: EXCEPTION
8116: WHEN OTHERS THEN
8117: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8118: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8119: fnd_message.set_token('ERRNO', SQLCODE);
8120: fnd_message.set_token('REASON', SQLERRM);
8121: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
8122: ,p_module => l_api_name
8123: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

Line 8120: fnd_message.set_token('REASON', SQLERRM);

8116: WHEN OTHERS THEN
8117: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8118: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8119: fnd_message.set_token('ERRNO', SQLCODE);
8120: fnd_message.set_token('REASON', SQLERRM);
8121: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
8122: ,p_module => l_api_name
8123: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM
8124: );