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 466: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

462: x_pk5_column_type ,
463: x_database_object_name;
464:
465: IF(c_pk%NOTFOUND) THEN
466: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
467: fnd_message.set_token('ROUTINE',
468: g_pkg_name || '.'|| l_api_name);
469: fnd_message.set_token('REASON',
470: 'FND_OBJECTS does not have column obj_name with value:'||

Line 467: fnd_message.set_token('ROUTINE',

463: x_database_object_name;
464:
465: IF(c_pk%NOTFOUND) THEN
466: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
467: fnd_message.set_token('ROUTINE',
468: g_pkg_name || '.'|| l_api_name);
469: fnd_message.set_token('REASON',
470: 'FND_OBJECTS does not have column obj_name with value:'||
471: p_object_name);

Line 469: fnd_message.set_token('REASON',

465: IF(c_pk%NOTFOUND) THEN
466: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
467: fnd_message.set_token('ROUTINE',
468: g_pkg_name || '.'|| l_api_name);
469: fnd_message.set_token('REASON',
470: 'FND_OBJECTS does not have column obj_name with value:'||
471: p_object_name);
472: return G_RETURN_UNEXP_ERR;
473: end if;

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

790: ' - p_user_name: '|| p_user_name
791: );
792:
793: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
794: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
795: fnd_message.set_token('ROUTINE',
796: g_pkg_name || '.'|| l_api_name);
797: fnd_message.set_token('REASON',
798: 'Unsupported version '|| to_char(p_api_version)||

Line 795: fnd_message.set_token('ROUTINE',

791: );
792:
793: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
794: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
795: fnd_message.set_token('ROUTINE',
796: g_pkg_name || '.'|| l_api_name);
797: fnd_message.set_token('REASON',
798: 'Unsupported version '|| to_char(p_api_version)||
799: ' passed to API; expecting version '||

Line 797: fnd_message.set_token('REASON',

793: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
794: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
795: fnd_message.set_token('ROUTINE',
796: g_pkg_name || '.'|| l_api_name);
797: fnd_message.set_token('REASON',
798: 'Unsupported version '|| to_char(p_api_version)||
799: ' passed to API; expecting version '||
800: to_char(l_api_version));
801: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

1262: ,p_message => 'Returning EXCEPTION '||SQLERRM
1263: );
1264: RETURN G_RETURN_UNEXP_ERR;
1265: WHEN OTHERS THEN
1266: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1267: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1268: fnd_message.set_token('ERRNO', SQLCODE);
1269: fnd_message.set_token('REASON', SQLERRM);
1270: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

1263: );
1264: RETURN G_RETURN_UNEXP_ERR;
1265: WHEN OTHERS THEN
1266: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1267: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1268: fnd_message.set_token('ERRNO', SQLCODE);
1269: fnd_message.set_token('REASON', SQLERRM);
1270: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1271: ,p_module => l_api_name

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

1264: RETURN G_RETURN_UNEXP_ERR;
1265: WHEN OTHERS THEN
1266: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1267: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1268: fnd_message.set_token('ERRNO', SQLCODE);
1269: fnd_message.set_token('REASON', SQLERRM);
1270: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1271: ,p_module => l_api_name
1272: ,p_message => 'Returning EXCEPTION '||SQLERRM

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

1265: WHEN OTHERS THEN
1266: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1267: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1268: fnd_message.set_token('ERRNO', SQLCODE);
1269: fnd_message.set_token('REASON', SQLERRM);
1270: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1271: ,p_module => l_api_name
1272: ,p_message => 'Returning EXCEPTION '||SQLERRM
1273: );

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

1378: );
1379:
1380: -- check for call compatibility.
1381: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1382: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1383: fnd_message.set_token('ROUTINE',
1384: g_pkg_name || '.'|| l_api_name);
1385: fnd_message.set_token('REASON',
1386: 'Unsupported version '|| to_char(p_api_version)||

Line 1383: fnd_message.set_token('ROUTINE',

1379:
1380: -- check for call compatibility.
1381: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1382: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1383: fnd_message.set_token('ROUTINE',
1384: g_pkg_name || '.'|| l_api_name);
1385: fnd_message.set_token('REASON',
1386: 'Unsupported version '|| to_char(p_api_version)||
1387: ' passed to API; expecting version '||

Line 1385: fnd_message.set_token('REASON',

1381: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1382: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1383: fnd_message.set_token('ROUTINE',
1384: g_pkg_name || '.'|| l_api_name);
1385: fnd_message.set_token('REASON',
1386: 'Unsupported version '|| to_char(p_api_version)||
1387: ' passed to API; expecting version '||
1388: to_char(l_api_version));
1389: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

1889: END IF; -- End of if l_result is 'X' else clause
1890:
1891: EXCEPTION
1892: WHEN OTHERS THEN
1893: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1894: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1895: fnd_message.set_token('ERRNO', SQLCODE);
1896: fnd_message.set_token('REASON', SQLERRM);
1897: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

1890:
1891: EXCEPTION
1892: WHEN OTHERS THEN
1893: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1894: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1895: fnd_message.set_token('ERRNO', SQLCODE);
1896: fnd_message.set_token('REASON', SQLERRM);
1897: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1898: ,p_module => l_api_name

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

1891: EXCEPTION
1892: WHEN OTHERS THEN
1893: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1894: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1895: fnd_message.set_token('ERRNO', SQLCODE);
1896: fnd_message.set_token('REASON', SQLERRM);
1897: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1898: ,p_module => l_api_name
1899: ,p_message => 'Returning EXCEPTION '||SQLERRM

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

1892: WHEN OTHERS THEN
1893: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1894: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
1895: fnd_message.set_token('ERRNO', SQLCODE);
1896: fnd_message.set_token('REASON', SQLERRM);
1897: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1898: ,p_module => l_api_name
1899: ,p_message => 'Returning EXCEPTION '||SQLERRM
1900: );

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

1992: ' - p_user_name: '|| p_user_name
1993: );
1994: -- check for call compatibility.
1995: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1996: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1997: fnd_message.set_token('ROUTINE',
1998: g_pkg_name || '.'|| l_api_name);
1999: fnd_message.set_token('REASON',
2000: 'Unsupported version '|| to_char(p_api_version)||

Line 1997: fnd_message.set_token('ROUTINE',

1993: );
1994: -- check for call compatibility.
1995: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1996: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1997: fnd_message.set_token('ROUTINE',
1998: g_pkg_name || '.'|| l_api_name);
1999: fnd_message.set_token('REASON',
2000: 'Unsupported version '|| to_char(p_api_version)||
2001: ' passed to API; expecting version '||

Line 1999: fnd_message.set_token('REASON',

1995: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
1996: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1997: fnd_message.set_token('ROUTINE',
1998: g_pkg_name || '.'|| l_api_name);
1999: fnd_message.set_token('REASON',
2000: 'Unsupported version '|| to_char(p_api_version)||
2001: ' passed to API; expecting version '||
2002: to_char(l_api_version));
2003: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

2586:
2587: EXCEPTION
2588: WHEN OTHERS THEN
2589: --dbms_output.put_line('error :' || SQLERRM);
2590: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2591: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2592: fnd_message.set_token('ERRNO', SQLCODE);
2593: fnd_message.set_token('REASON', SQLERRM);
2594: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

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

2587: EXCEPTION
2588: WHEN OTHERS THEN
2589: --dbms_output.put_line('error :' || SQLERRM);
2590: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2591: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2592: fnd_message.set_token('ERRNO', SQLCODE);
2593: fnd_message.set_token('REASON', SQLERRM);
2594: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2595: ,p_module => l_api_name

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

2588: WHEN OTHERS THEN
2589: --dbms_output.put_line('error :' || SQLERRM);
2590: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2591: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2592: fnd_message.set_token('ERRNO', SQLCODE);
2593: fnd_message.set_token('REASON', SQLERRM);
2594: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2595: ,p_module => l_api_name
2596: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

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

2589: --dbms_output.put_line('error :' || SQLERRM);
2590: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2591: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
2592: fnd_message.set_token('ERRNO', SQLCODE);
2593: fnd_message.set_token('REASON', SQLERRM);
2594: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2595: ,p_module => l_api_name
2596: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM
2597: );

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

2706: );
2707:
2708: -- check for call compatibility.
2709: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
2710: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
2711: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
2712: fnd_message.set_token('REASON', 'Unsupported version '||
2713: to_char(p_api_version)||
2714: ' passed to API; expecting version '||

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

2707:
2708: -- check for call compatibility.
2709: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
2710: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
2711: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
2712: fnd_message.set_token('REASON', 'Unsupported version '||
2713: to_char(p_api_version)||
2714: ' passed to API; expecting version '||
2715: to_char(l_api_version));

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

2708: -- check for call compatibility.
2709: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
2710: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
2711: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
2712: fnd_message.set_token('REASON', 'Unsupported version '||
2713: to_char(p_api_version)||
2714: ' passed to API; expecting version '||
2715: to_char(l_api_version));
2716: x_return_status := G_RETURN_UNEXP_ERR;

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

3421: );
3422:
3423: EXCEPTION
3424: WHEN OTHERS THEN
3425: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3426: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3427: fnd_message.set_token('ERRNO', SQLCODE);
3428: fnd_message.set_token('REASON', SQLERRM);
3429: x_return_status := G_RETURN_UNEXP_ERR;

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

3422:
3423: EXCEPTION
3424: WHEN OTHERS THEN
3425: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3426: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3427: fnd_message.set_token('ERRNO', SQLCODE);
3428: fnd_message.set_token('REASON', SQLERRM);
3429: x_return_status := G_RETURN_UNEXP_ERR;
3430: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

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

3423: EXCEPTION
3424: WHEN OTHERS THEN
3425: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3426: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3427: fnd_message.set_token('ERRNO', SQLCODE);
3428: fnd_message.set_token('REASON', SQLERRM);
3429: x_return_status := G_RETURN_UNEXP_ERR;
3430: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
3431: ,p_module => l_api_name

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

3424: WHEN OTHERS THEN
3425: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3426: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3427: fnd_message.set_token('ERRNO', SQLCODE);
3428: fnd_message.set_token('REASON', SQLERRM);
3429: x_return_status := G_RETURN_UNEXP_ERR;
3430: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
3431: ,p_module => l_api_name
3432: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

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

3511: );
3512:
3513: -- check for call compatibility.
3514: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3515: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3516: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3517: fnd_message.set_token('REASON', 'Unsupported version '|| to_char(p_api_version)||
3518: ' passed to API; expecting version '||
3519: to_char(l_api_version));

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

3512:
3513: -- check for call compatibility.
3514: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3515: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3516: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3517: fnd_message.set_token('REASON', 'Unsupported version '|| to_char(p_api_version)||
3518: ' passed to API; expecting version '||
3519: to_char(l_api_version));
3520: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

3513: -- check for call compatibility.
3514: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
3515: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3516: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3517: fnd_message.set_token('REASON', 'Unsupported version '|| to_char(p_api_version)||
3518: ' passed to API; expecting version '||
3519: to_char(l_api_version));
3520: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3521: ,p_module => l_api_name

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

3526: END IF;
3527:
3528: -- Check to make sure we're not using unsupported statement_type
3529: if (p_statement_type NOT IN ('BASE', 'OTHER', 'EXISTS')) then
3530: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3531: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3532: fnd_message.set_token('REASON', 'Unsupported p_statement_type: '|| p_statement_type);
3533: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3534: ,p_module => l_api_name

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

3527:
3528: -- Check to make sure we're not using unsupported statement_type
3529: if (p_statement_type NOT IN ('BASE', 'OTHER', 'EXISTS')) then
3530: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3531: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3532: fnd_message.set_token('REASON', 'Unsupported p_statement_type: '|| p_statement_type);
3533: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3534: ,p_module => l_api_name
3535: ,p_message => 'Returning as statement type is not supported'

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

3528: -- Check to make sure we're not using unsupported statement_type
3529: if (p_statement_type NOT IN ('BASE', 'OTHER', 'EXISTS')) then
3530: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3531: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3532: fnd_message.set_token('REASON', 'Unsupported p_statement_type: '|| p_statement_type);
3533: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3534: ,p_module => l_api_name
3535: ,p_message => 'Returning as statement type is not supported'
3536: );

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

3540:
3541: /* ### We haven't yet added support for NULL (all) function in arg. */
3542: /* ### Add that support since it is in the API. */
3543: if (p_function is NULL) then
3544: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3545: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3546: fnd_message.set_token('REASON', 'Support has not yet been added for passing NULL function.');
3547: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3548: ,p_module => l_api_name

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

3541: /* ### We haven't yet added support for NULL (all) function in arg. */
3542: /* ### Add that support since it is in the API. */
3543: if (p_function is NULL) then
3544: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3545: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3546: fnd_message.set_token('REASON', 'Support has not yet been added for passing NULL function.');
3547: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3548: ,p_module => l_api_name
3549: ,p_message => 'Returning as mand parameter Function is not available '

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

3542: /* ### Add that support since it is in the API. */
3543: if (p_function is NULL) then
3544: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3545: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3546: fnd_message.set_token('REASON', 'Support has not yet been added for passing NULL function.');
3547: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3548: ,p_module => l_api_name
3549: ,p_message => 'Returning as mand parameter Function is not available '
3550: );

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

3559: OR (p_pk3_alias is not NULL)
3560: OR (p_pk4_alias is not NULL)
3561: OR (p_pk5_alias is not NULL))) then
3562:
3563: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3564: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3565: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3566: ' p_grant_instance_type = SET.');
3567: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

3560: OR (p_pk4_alias is not NULL)
3561: OR (p_pk5_alias is not NULL))) then
3562:
3563: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3564: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3565: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3566: ' p_grant_instance_type = SET.');
3567: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3568: ,p_module => l_api_name

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

3561: OR (p_pk5_alias is not NULL))) then
3562:
3563: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3564: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3565: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
3566: ' p_grant_instance_type = SET.');
3567: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3568: ,p_module => l_api_name
3569: ,p_message => 'Returning as incompatible combination for p_grant_instance_type = SET '

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

3574:
3575: /* We don't currently support BASE mode; we will have to change to */
3576: /* a pure OR statement when VPD becomes important. */
3577: if (p_statement_type = 'BASE') then
3578: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3579: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3580: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
3581: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3582: ,p_module => l_api_name

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

3575: /* We don't currently support BASE mode; we will have to change to */
3576: /* a pure OR statement when VPD becomes important. */
3577: if (p_statement_type = 'BASE') then
3578: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3579: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3580: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
3581: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3582: ,p_module => l_api_name
3583: ,p_message => 'Returning as incompatible statement_type = BASE '

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

3576: /* a pure OR statement when VPD becomes important. */
3577: if (p_statement_type = 'BASE') then
3578: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
3579: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
3580: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
3581: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
3582: ,p_module => l_api_name
3583: ,p_message => 'Returning as incompatible statement_type = BASE '
3584: );

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

3910: x_predicate := l_aggregate_predicate;
3911:
3912: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
3913: AND (p_statement_type = 'BASE')) then
3914: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
3915: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
3916: FND_MESSAGE.SET_TOKEN('REASON',
3917: 'The predicate was longer than the database VPD limit of '||
3918: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

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

3911:
3912: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
3913: AND (p_statement_type = 'BASE')) then
3914: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
3915: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
3916: FND_MESSAGE.SET_TOKEN('REASON',
3917: 'The predicate was longer than the database VPD limit of '||
3918: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
3919: x_return_status := 'L'; /* Indicate Error */

Line 3916: FND_MESSAGE.SET_TOKEN('REASON',

3912: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
3913: AND (p_statement_type = 'BASE')) then
3914: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
3915: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
3916: FND_MESSAGE.SET_TOKEN('REASON',
3917: 'The predicate was longer than the database VPD limit of '||
3918: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
3919: x_return_status := 'L'; /* Indicate Error */
3920: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

3932: );
3933:
3934: EXCEPTION
3935: WHEN OTHERS THEN
3936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3937: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3938: fnd_message.set_token('ERRNO', SQLCODE);
3939: fnd_message.set_token('REASON', SQLERRM);
3940: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

3933:
3934: EXCEPTION
3935: WHEN OTHERS THEN
3936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3937: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3938: fnd_message.set_token('ERRNO', SQLCODE);
3939: fnd_message.set_token('REASON', SQLERRM);
3940: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
3941: ,p_module => l_api_name

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

3934: EXCEPTION
3935: WHEN OTHERS THEN
3936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3937: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3938: fnd_message.set_token('ERRNO', SQLCODE);
3939: fnd_message.set_token('REASON', SQLERRM);
3940: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
3941: ,p_module => l_api_name
3942: ,p_message => 'Returning EXCEPTION '||SQLERRM

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

3935: WHEN OTHERS THEN
3936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3937: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
3938: fnd_message.set_token('ERRNO', SQLCODE);
3939: fnd_message.set_token('REASON', SQLERRM);
3940: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
3941: ,p_module => l_api_name
3942: ,p_message => 'Returning EXCEPTION '||SQLERRM
3943: );

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

4030: x_return_status := G_RETURN_SUCCESS; /* Assume Success */
4031:
4032: -- check for call compatibility.
4033: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4034: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4035: fnd_message.set_token('ROUTINE',
4036: g_pkg_name || '.'|| l_api_name);
4037: fnd_message.set_token('REASON',
4038: 'Unsupported version '|| to_char(p_api_version)||

Line 4035: fnd_message.set_token('ROUTINE',

4031:
4032: -- check for call compatibility.
4033: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4034: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4035: fnd_message.set_token('ROUTINE',
4036: g_pkg_name || '.'|| l_api_name);
4037: fnd_message.set_token('REASON',
4038: 'Unsupported version '|| to_char(p_api_version)||
4039: ' passed to API; expecting version '||

Line 4037: fnd_message.set_token('REASON',

4033: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4034: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4035: fnd_message.set_token('ROUTINE',
4036: g_pkg_name || '.'|| l_api_name);
4037: fnd_message.set_token('REASON',
4038: 'Unsupported version '|| to_char(p_api_version)||
4039: ' passed to API; expecting version '||
4040: to_char(l_api_version));
4041: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

4048:
4049: -- Check to make sure we're not using unsupported statement_type
4050: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
4051: AND (p_statement_type <> 'EXISTS')) then
4052: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4053: fnd_message.set_token('ROUTINE',
4054: g_pkg_name || '.'|| l_api_name);
4055: fnd_message.set_token('REASON',
4056: 'Unsupported p_statement_type: '|| p_statement_type);

Line 4053: fnd_message.set_token('ROUTINE',

4049: -- Check to make sure we're not using unsupported statement_type
4050: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
4051: AND (p_statement_type <> 'EXISTS')) then
4052: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4053: fnd_message.set_token('ROUTINE',
4054: g_pkg_name || '.'|| l_api_name);
4055: fnd_message.set_token('REASON',
4056: 'Unsupported p_statement_type: '|| p_statement_type);
4057: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4055: fnd_message.set_token('REASON',

4051: AND (p_statement_type <> 'EXISTS')) then
4052: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4053: fnd_message.set_token('ROUTINE',
4054: g_pkg_name || '.'|| l_api_name);
4055: fnd_message.set_token('REASON',
4056: 'Unsupported p_statement_type: '|| p_statement_type);
4057: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4058: ,p_module => l_api_name
4059: ,p_message => 'Returning as statement type is not supported'

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

4064:
4065: /* ### We haven't yet added support for NULL (all) function in arg. */
4066: /* ### Add that support since it is in the API. */
4067: if (p_function is NULL) then
4068: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4069: fnd_message.set_token('ROUTINE',
4070: g_pkg_name || '.'|| l_api_name);
4071: fnd_message.set_token('REASON',
4072: 'Support has not yet been added for passing NULL function.');

Line 4069: fnd_message.set_token('ROUTINE',

4065: /* ### We haven't yet added support for NULL (all) function in arg. */
4066: /* ### Add that support since it is in the API. */
4067: if (p_function is NULL) then
4068: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4069: fnd_message.set_token('ROUTINE',
4070: g_pkg_name || '.'|| l_api_name);
4071: fnd_message.set_token('REASON',
4072: 'Support has not yet been added for passing NULL function.');
4073: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4071: fnd_message.set_token('REASON',

4067: if (p_function is NULL) then
4068: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4069: fnd_message.set_token('ROUTINE',
4070: g_pkg_name || '.'|| l_api_name);
4071: fnd_message.set_token('REASON',
4072: 'Support has not yet been added for passing NULL function.');
4073: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4074: ,p_module => l_api_name
4075: ,p_message => 'Returning as mand parameter Function is not available '

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

4086: OR (p_pk3_alias is not NULL)
4087: OR (p_pk4_alias is not NULL)
4088: OR (p_pk5_alias is not NULL))) then
4089:
4090: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4091: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4092: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
4093: ' p_grant_instance_type = SET.');
4094: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

4087: OR (p_pk4_alias is not NULL)
4088: OR (p_pk5_alias is not NULL))) then
4089:
4090: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4091: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4092: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
4093: ' p_grant_instance_type = SET.');
4094: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4095: ,p_module => l_api_name

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

4088: OR (p_pk5_alias is not NULL))) then
4089:
4090: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4091: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4092: fnd_message.set_token('REASON', 'Unsupported mode arguments: '||
4093: ' p_grant_instance_type = SET.');
4094: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4095: ,p_module => l_api_name
4096: ,p_message => 'Returning as incompatible combination for p_grant_instance_type = SET '

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

4101:
4102: /* We don't currently support BASE mode; we will have to change to */
4103: /* a pure OR statement when VPD becomes important. */
4104: if (p_statement_type = 'BASE') then
4105: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4106: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4107: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
4108: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4109: ,p_module => l_api_name

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

4102: /* We don't currently support BASE mode; we will have to change to */
4103: /* a pure OR statement when VPD becomes important. */
4104: if (p_statement_type = 'BASE') then
4105: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4106: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4107: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
4108: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4109: ,p_module => l_api_name
4110: ,p_message => 'Returning as incompatible statement_type = BASE '

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

4103: /* a pure OR statement when VPD becomes important. */
4104: if (p_statement_type = 'BASE') then
4105: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4106: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
4107: fnd_message.set_token('REASON', 'Support has not yet been added for '|| 'p_statement_type = BASE.');
4108: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4109: ,p_module => l_api_name
4110: ,p_message => 'Returning as incompatible statement_type = BASE '
4111: );

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

4397: x_predicate := l_aggregate_predicate;
4398:
4399: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4400: AND (p_statement_type = 'BASE'))then
4401: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4402: FND_MESSAGE.SET_TOKEN('ROUTINE',
4403: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4404: FND_MESSAGE.SET_TOKEN('REASON',
4405: 'The predicate was longer than the database VPD limit of '||

Line 4402: FND_MESSAGE.SET_TOKEN('ROUTINE',

4398:
4399: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4400: AND (p_statement_type = 'BASE'))then
4401: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4402: FND_MESSAGE.SET_TOKEN('ROUTINE',
4403: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4404: FND_MESSAGE.SET_TOKEN('REASON',
4405: 'The predicate was longer than the database VPD limit of '||
4406: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

Line 4404: FND_MESSAGE.SET_TOKEN('REASON',

4400: AND (p_statement_type = 'BASE'))then
4401: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4402: FND_MESSAGE.SET_TOKEN('ROUTINE',
4403: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4404: FND_MESSAGE.SET_TOKEN('REASON',
4405: 'The predicate was longer than the database VPD limit of '||
4406: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4407: x_return_status := 'L'; /* Indicate Error */
4408: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

4420: );
4421:
4422: EXCEPTION
4423: WHEN OTHERS THEN
4424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4425: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4426: fnd_message.set_token('ERRNO', SQLCODE);
4427: fnd_message.set_token('REASON', SQLERRM);
4428: x_return_status := G_RETURN_UNEXP_ERR;

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

4421:
4422: EXCEPTION
4423: WHEN OTHERS THEN
4424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4425: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4426: fnd_message.set_token('ERRNO', SQLCODE);
4427: fnd_message.set_token('REASON', SQLERRM);
4428: x_return_status := G_RETURN_UNEXP_ERR;
4429: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

4422: EXCEPTION
4423: WHEN OTHERS THEN
4424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4425: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4426: fnd_message.set_token('ERRNO', SQLCODE);
4427: fnd_message.set_token('REASON', SQLERRM);
4428: x_return_status := G_RETURN_UNEXP_ERR;
4429: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4430: ,p_module => l_api_name

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

4423: WHEN OTHERS THEN
4424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4425: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4426: fnd_message.set_token('ERRNO', SQLCODE);
4427: fnd_message.set_token('REASON', SQLERRM);
4428: x_return_status := G_RETURN_UNEXP_ERR;
4429: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4430: ,p_module => l_api_name
4431: ,p_message => 'Returning EXCEPTION '||SQLERRM

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

4517: );
4518:
4519: -- check for call compatibility.
4520: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4521: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4522: fnd_message.set_token('ROUTINE',
4523: g_pkg_name || '.'|| l_api_name);
4524: fnd_message.set_token('REASON',
4525: 'Unsupported version '|| to_char(p_api_version)||

Line 4522: fnd_message.set_token('ROUTINE',

4518:
4519: -- check for call compatibility.
4520: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4521: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4522: fnd_message.set_token('ROUTINE',
4523: g_pkg_name || '.'|| l_api_name);
4524: fnd_message.set_token('REASON',
4525: 'Unsupported version '|| to_char(p_api_version)||
4526: ' passed to API; expecting version '||

Line 4524: fnd_message.set_token('REASON',

4520: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
4521: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4522: fnd_message.set_token('ROUTINE',
4523: g_pkg_name || '.'|| l_api_name);
4524: fnd_message.set_token('REASON',
4525: 'Unsupported version '|| to_char(p_api_version)||
4526: ' passed to API; expecting version '||
4527: to_char(l_api_version));
4528: x_return_status := G_RETURN_UNEXP_ERR; /* Unexpected Error */

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

4535:
4536: -- Check to make sure we're not using unsupported statement_type
4537: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
4538: AND (p_statement_type <> 'EXISTS')) then
4539: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4540: fnd_message.set_token('ROUTINE',
4541: g_pkg_name || '.'|| l_api_name);
4542: fnd_message.set_token('REASON',
4543: 'Unsupported p_statement_type: '|| p_statement_type);

Line 4540: fnd_message.set_token('ROUTINE',

4536: -- Check to make sure we're not using unsupported statement_type
4537: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
4538: AND (p_statement_type <> 'EXISTS')) then
4539: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4540: fnd_message.set_token('ROUTINE',
4541: g_pkg_name || '.'|| l_api_name);
4542: fnd_message.set_token('REASON',
4543: 'Unsupported p_statement_type: '|| p_statement_type);
4544: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4542: fnd_message.set_token('REASON',

4538: AND (p_statement_type <> 'EXISTS')) then
4539: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4540: fnd_message.set_token('ROUTINE',
4541: g_pkg_name || '.'|| l_api_name);
4542: fnd_message.set_token('REASON',
4543: 'Unsupported p_statement_type: '|| p_statement_type);
4544: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4545: ,p_module => l_api_name
4546: ,p_message => 'Returning as statement type is not supported'

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

4551:
4552: /* ### We haven't yet added support for NULL (all) function in arg. */
4553: /* ### Add that support since it is in the API. */
4554: if (p_function is NULL) then
4555: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4556: fnd_message.set_token('ROUTINE',
4557: g_pkg_name || '.'|| l_api_name);
4558: fnd_message.set_token('REASON',
4559: 'Support has not yet been added for passing NULL function.');

Line 4556: fnd_message.set_token('ROUTINE',

4552: /* ### We haven't yet added support for NULL (all) function in arg. */
4553: /* ### Add that support since it is in the API. */
4554: if (p_function is NULL) then
4555: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4556: fnd_message.set_token('ROUTINE',
4557: g_pkg_name || '.'|| l_api_name);
4558: fnd_message.set_token('REASON',
4559: 'Support has not yet been added for passing NULL function.');
4560: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4558: fnd_message.set_token('REASON',

4554: if (p_function is NULL) then
4555: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4556: fnd_message.set_token('ROUTINE',
4557: g_pkg_name || '.'|| l_api_name);
4558: fnd_message.set_token('REASON',
4559: 'Support has not yet been added for passing NULL function.');
4560: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4561: ,p_module => l_api_name
4562: ,p_message => 'Returning as mand parameter Function is not available '

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

4571: OR (p_pk2_alias is not NULL)
4572: OR (p_pk3_alias is not NULL)
4573: OR (p_pk4_alias is not NULL)
4574: OR (p_pk5_alias is not NULL))) then
4575: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4576: fnd_message.set_token('ROUTINE',
4577: g_pkg_name || '.'|| l_api_name);
4578: fnd_message.set_token('REASON',
4579: 'Unsupported mode arguments: '||

Line 4576: fnd_message.set_token('ROUTINE',

4572: OR (p_pk3_alias is not NULL)
4573: OR (p_pk4_alias is not NULL)
4574: OR (p_pk5_alias is not NULL))) then
4575: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4576: fnd_message.set_token('ROUTINE',
4577: g_pkg_name || '.'|| l_api_name);
4578: fnd_message.set_token('REASON',
4579: 'Unsupported mode arguments: '||
4580: 'p_statement_type = BASE or p_grant_instance_type = SET.');

Line 4578: fnd_message.set_token('REASON',

4574: OR (p_pk5_alias is not NULL))) then
4575: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4576: fnd_message.set_token('ROUTINE',
4577: g_pkg_name || '.'|| l_api_name);
4578: fnd_message.set_token('REASON',
4579: 'Unsupported mode arguments: '||
4580: 'p_statement_type = BASE or p_grant_instance_type = SET.');
4581: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4582: ,p_module => l_api_name

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

4588:
4589: /* We don't currently support BASE mode; we will have to change to */
4590: /* a pure OR statement when VPD becomes important. */
4591: if (p_statement_type = 'BASE') then
4592: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4593: fnd_message.set_token('ROUTINE',
4594: g_pkg_name || '.'|| l_api_name);
4595: fnd_message.set_token('REASON',
4596: 'Support has not yet been added for '||

Line 4593: fnd_message.set_token('ROUTINE',

4589: /* We don't currently support BASE mode; we will have to change to */
4590: /* a pure OR statement when VPD becomes important. */
4591: if (p_statement_type = 'BASE') then
4592: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4593: fnd_message.set_token('ROUTINE',
4594: g_pkg_name || '.'|| l_api_name);
4595: fnd_message.set_token('REASON',
4596: 'Support has not yet been added for '||
4597: 'p_statement_type = BASE.');

Line 4595: fnd_message.set_token('REASON',

4591: if (p_statement_type = 'BASE') then
4592: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
4593: fnd_message.set_token('ROUTINE',
4594: g_pkg_name || '.'|| l_api_name);
4595: fnd_message.set_token('REASON',
4596: 'Support has not yet been added for '||
4597: 'p_statement_type = BASE.');
4598: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
4599: ,p_module => l_api_name

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

4883: x_predicate :=l_aggregate_predicate;
4884:
4885: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4886: AND (p_statement_type = 'BASE'))then
4887: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4888: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4889: FND_MESSAGE.SET_TOKEN('REASON',
4890: 'The predicate was longer than the database VPD limit of '||
4891: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

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

4884:
4885: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4886: AND (p_statement_type = 'BASE'))then
4887: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4888: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4889: FND_MESSAGE.SET_TOKEN('REASON',
4890: 'The predicate was longer than the database VPD limit of '||
4891: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4892: x_return_status := 'L'; /* Indicate Error */

Line 4889: FND_MESSAGE.SET_TOKEN('REASON',

4885: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4886: AND (p_statement_type = 'BASE'))then
4887: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4888: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4889: FND_MESSAGE.SET_TOKEN('REASON',
4890: 'The predicate was longer than the database VPD limit of '||
4891: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4892: x_return_status := 'L'; /* Indicate Error */
4893: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

4906: );
4907:
4908: EXCEPTION
4909: WHEN OTHERS THEN
4910: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4911: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4912: fnd_message.set_token('ERRNO', SQLCODE);
4913: fnd_message.set_token('REASON', SQLERRM);
4914: x_return_status := G_RETURN_UNEXP_ERR;

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

4907:
4908: EXCEPTION
4909: WHEN OTHERS THEN
4910: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4911: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4912: fnd_message.set_token('ERRNO', SQLCODE);
4913: fnd_message.set_token('REASON', SQLERRM);
4914: x_return_status := G_RETURN_UNEXP_ERR;
4915: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

4908: EXCEPTION
4909: WHEN OTHERS THEN
4910: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4911: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4912: fnd_message.set_token('ERRNO', SQLCODE);
4913: fnd_message.set_token('REASON', SQLERRM);
4914: x_return_status := G_RETURN_UNEXP_ERR;
4915: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4916: ,p_module => l_api_name

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

4909: WHEN OTHERS THEN
4910: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4911: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
4912: fnd_message.set_token('ERRNO', SQLCODE);
4913: fnd_message.set_token('REASON', SQLERRM);
4914: x_return_status := G_RETURN_UNEXP_ERR;
4915: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
4916: ,p_module => l_api_name
4917: ,p_message => 'Returning EXCEPTION '||SQLERRM

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

5284: END IF;
5285:
5286: -- check for call compatibility.
5287: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
5288: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5289: fnd_message.set_token('ROUTINE',
5290: g_pkg_name || '.'|| l_api_name);
5291: fnd_message.set_token('REASON',
5292: 'Unsupported version '|| to_char(p_api_version)||

Line 5289: fnd_message.set_token('ROUTINE',

5285:
5286: -- check for call compatibility.
5287: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
5288: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5289: fnd_message.set_token('ROUTINE',
5290: g_pkg_name || '.'|| l_api_name);
5291: fnd_message.set_token('REASON',
5292: 'Unsupported version '|| to_char(p_api_version)||
5293: ' passed to API; expecting version '||

Line 5291: fnd_message.set_token('REASON',

5287: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
5288: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5289: fnd_message.set_token('ROUTINE',
5290: g_pkg_name || '.'|| l_api_name);
5291: fnd_message.set_token('REASON',
5292: 'Unsupported version '|| to_char(p_api_version)||
5293: ' passed to API; expecting version '||
5294: to_char(l_api_version));
5295: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

5302:
5303: -- Check to make sure we're not using unsupported statement_type
5304: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
5305: AND (p_statement_type <> 'EXISTS')) then
5306: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5307: fnd_message.set_token('ROUTINE',
5308: g_pkg_name || '.'|| l_api_name);
5309: fnd_message.set_token('REASON',
5310: 'Unsupported p_statement_type: '|| p_statement_type);

Line 5307: fnd_message.set_token('ROUTINE',

5303: -- Check to make sure we're not using unsupported statement_type
5304: if ((p_statement_type <> 'BASE') and (p_statement_type <> 'OTHER')
5305: AND (p_statement_type <> 'EXISTS')) then
5306: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5307: fnd_message.set_token('ROUTINE',
5308: g_pkg_name || '.'|| l_api_name);
5309: fnd_message.set_token('REASON',
5310: 'Unsupported p_statement_type: '|| p_statement_type);
5311: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 5309: fnd_message.set_token('REASON',

5305: AND (p_statement_type <> 'EXISTS')) then
5306: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5307: fnd_message.set_token('ROUTINE',
5308: g_pkg_name || '.'|| l_api_name);
5309: fnd_message.set_token('REASON',
5310: 'Unsupported p_statement_type: '|| p_statement_type);
5311: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5312: ,p_module => l_api_name
5313: ,p_message => 'Returning as statement type is not supported'

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

5318:
5319: /* ### We haven't yet added support for NULL (all) function in arg. */
5320: /* ### Add that support since it is in the API. */
5321: if (p_function is NULL) then
5322: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5323: fnd_message.set_token('ROUTINE',
5324: g_pkg_name || '.'|| l_api_name);
5325: fnd_message.set_token('REASON',
5326: 'Support has not yet been added for passing NULL function.');

Line 5323: fnd_message.set_token('ROUTINE',

5319: /* ### We haven't yet added support for NULL (all) function in arg. */
5320: /* ### Add that support since it is in the API. */
5321: if (p_function is NULL) then
5322: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5323: fnd_message.set_token('ROUTINE',
5324: g_pkg_name || '.'|| l_api_name);
5325: fnd_message.set_token('REASON',
5326: 'Support has not yet been added for passing NULL function.');
5327: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 5325: fnd_message.set_token('REASON',

5321: if (p_function is NULL) then
5322: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5323: fnd_message.set_token('ROUTINE',
5324: g_pkg_name || '.'|| l_api_name);
5325: fnd_message.set_token('REASON',
5326: 'Support has not yet been added for passing NULL function.');
5327: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5328: ,p_module => l_api_name
5329: ,p_message => 'Returning as mand parameter Function is not available '

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

5339: OR (p_pk3_alias is not NULL)
5340: OR (p_pk4_alias is not NULL)
5341: OR (p_pk5_alias is not NULL))) then
5342:
5343: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5344: fnd_message.set_token('ROUTINE',
5345: g_pkg_name || '.'|| l_api_name);
5346: fnd_message.set_token('REASON',
5347: 'Unsupported mode arguments: '||

Line 5344: fnd_message.set_token('ROUTINE',

5340: OR (p_pk4_alias is not NULL)
5341: OR (p_pk5_alias is not NULL))) then
5342:
5343: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5344: fnd_message.set_token('ROUTINE',
5345: g_pkg_name || '.'|| l_api_name);
5346: fnd_message.set_token('REASON',
5347: 'Unsupported mode arguments: '||
5348: 'p_statement_type = BASE or p_grant_instance_type = SET.');

Line 5346: fnd_message.set_token('REASON',

5342:
5343: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5344: fnd_message.set_token('ROUTINE',
5345: g_pkg_name || '.'|| l_api_name);
5346: fnd_message.set_token('REASON',
5347: 'Unsupported mode arguments: '||
5348: 'p_statement_type = BASE or p_grant_instance_type = SET.');
5349: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5350: ,p_module => l_api_name

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

5356:
5357: /* We don't currently support BASE mode; we will have to change to */
5358: /* a pure OR statement when VPD becomes important. */
5359: if (p_statement_type = 'BASE') then
5360: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5361: fnd_message.set_token('ROUTINE',
5362: g_pkg_name || '.'|| l_api_name);
5363: fnd_message.set_token('REASON',
5364: 'Support has not yet been added for '||

Line 5361: fnd_message.set_token('ROUTINE',

5357: /* We don't currently support BASE mode; we will have to change to */
5358: /* a pure OR statement when VPD becomes important. */
5359: if (p_statement_type = 'BASE') then
5360: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5361: fnd_message.set_token('ROUTINE',
5362: g_pkg_name || '.'|| l_api_name);
5363: fnd_message.set_token('REASON',
5364: 'Support has not yet been added for '||
5365: 'p_statement_type = BASE.');

Line 5363: fnd_message.set_token('REASON',

5359: if (p_statement_type = 'BASE') then
5360: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
5361: fnd_message.set_token('ROUTINE',
5362: g_pkg_name || '.'|| l_api_name);
5363: fnd_message.set_token('REASON',
5364: 'Support has not yet been added for '||
5365: 'p_statement_type = BASE.');
5366: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
5367: ,p_module => l_api_name

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

5903: x_clob_predicate := l_aggregate_predicate;
5904:
5905: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
5906: AND (p_statement_type = 'BASE'))then
5907: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
5908: FND_MESSAGE.SET_TOKEN('ROUTINE',
5909: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
5910: FND_MESSAGE.SET_TOKEN('REASON',
5911: 'The predicate was longer than the database VPD limit of '||

Line 5908: FND_MESSAGE.SET_TOKEN('ROUTINE',

5904:
5905: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
5906: AND (p_statement_type = 'BASE'))then
5907: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
5908: FND_MESSAGE.SET_TOKEN('ROUTINE',
5909: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
5910: FND_MESSAGE.SET_TOKEN('REASON',
5911: 'The predicate was longer than the database VPD limit of '||
5912: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');

Line 5910: FND_MESSAGE.SET_TOKEN('REASON',

5906: AND (p_statement_type = 'BASE'))then
5907: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
5908: FND_MESSAGE.SET_TOKEN('ROUTINE',
5909: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
5910: FND_MESSAGE.SET_TOKEN('REASON',
5911: 'The predicate was longer than the database VPD limit of '||
5912: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
5913: x_return_status := 'L'; /* Indicate Error */
5914: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

5918: end if;
5919:
5920: EXCEPTION
5921: WHEN OTHERS THEN
5922: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5923: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5924: fnd_message.set_token('ERRNO', SQLCODE);
5925: fnd_message.set_token('REASON', SQLERRM);
5926: x_return_status := G_RETURN_UNEXP_ERR;

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

5919:
5920: EXCEPTION
5921: WHEN OTHERS THEN
5922: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5923: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5924: fnd_message.set_token('ERRNO', SQLCODE);
5925: fnd_message.set_token('REASON', SQLERRM);
5926: x_return_status := G_RETURN_UNEXP_ERR;
5927: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

5920: EXCEPTION
5921: WHEN OTHERS THEN
5922: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5923: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5924: fnd_message.set_token('ERRNO', SQLCODE);
5925: fnd_message.set_token('REASON', SQLERRM);
5926: x_return_status := G_RETURN_UNEXP_ERR;
5927: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
5928: ,p_module => l_api_name

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

5921: WHEN OTHERS THEN
5922: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
5923: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
5924: fnd_message.set_token('ERRNO', SQLCODE);
5925: fnd_message.set_token('REASON', SQLERRM);
5926: x_return_status := G_RETURN_UNEXP_ERR;
5927: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
5928: ,p_module => l_api_name
5929: ,p_message => 'Returning EXCEPTION '||SQLERRM

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

6076: return;
6077:
6078: EXCEPTION
6079: WHEN OTHERS THEN
6080: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6081: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6082: fnd_message.set_token('ERRNO', SQLCODE);
6083: fnd_message.set_token('REASON', SQLERRM);
6084: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

6077:
6078: EXCEPTION
6079: WHEN OTHERS THEN
6080: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6081: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6082: fnd_message.set_token('ERRNO', SQLCODE);
6083: fnd_message.set_token('REASON', SQLERRM);
6084: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
6085: ,p_module => l_api_name

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

6078: EXCEPTION
6079: WHEN OTHERS THEN
6080: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6081: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6082: fnd_message.set_token('ERRNO', SQLCODE);
6083: fnd_message.set_token('REASON', SQLERRM);
6084: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
6085: ,p_module => l_api_name
6086: ,p_message => 'Returning EXCEPTION '||SQLERRM

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

6079: WHEN OTHERS THEN
6080: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6081: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6082: fnd_message.set_token('ERRNO', SQLCODE);
6083: fnd_message.set_token('REASON', SQLERRM);
6084: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
6085: ,p_module => l_api_name
6086: ,p_message => 'Returning EXCEPTION '||SQLERRM
6087: );

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

6146: );
6147:
6148: -- check for call compatibility.
6149: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
6150: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6151: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6152: fnd_message.set_token('REASON',
6153: 'Unsupported version '|| to_char(p_api_version)||
6154: ' passed to API; expecting version '||

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

6147:
6148: -- check for call compatibility.
6149: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
6150: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6151: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6152: fnd_message.set_token('REASON',
6153: 'Unsupported version '|| to_char(p_api_version)||
6154: ' passed to API; expecting version '||
6155: to_char(l_api_version));

Line 6152: fnd_message.set_token('REASON',

6148: -- check for call compatibility.
6149: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
6150: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6151: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6152: fnd_message.set_token('REASON',
6153: 'Unsupported version '|| to_char(p_api_version)||
6154: ' passed to API; expecting version '||
6155: to_char(l_api_version));
6156: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

6190: where s.instance_set_name = p_instance_set_name
6191: and s.object_id = o.object_id;
6192: exception
6193: when no_data_found then
6194: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6195: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6196: fnd_message.set_token('REASON',
6197: 'Data Error- couldn''t get predicate and/or object_name from '||
6198: 'fnd_objects and fnd_object_instance_sets for instance set '||

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

6191: and s.object_id = o.object_id;
6192: exception
6193: when no_data_found then
6194: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6195: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6196: fnd_message.set_token('REASON',
6197: 'Data Error- couldn''t get predicate and/or object_name from '||
6198: 'fnd_objects and fnd_object_instance_sets for instance set '||
6199: '"'||p_instance_set_name||'"');

Line 6196: fnd_message.set_token('REASON',

6192: exception
6193: when no_data_found then
6194: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6195: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6196: fnd_message.set_token('REASON',
6197: 'Data Error- couldn''t get predicate and/or object_name from '||
6198: 'fnd_objects and fnd_object_instance_sets for instance set '||
6199: '"'||p_instance_set_name||'"');
6200: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION

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

6305: END IF;
6306:
6307: EXCEPTION
6308: WHEN OTHERS THEN
6309: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6310: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6311: fnd_message.set_token('ERRNO', SQLCODE);
6312: fnd_message.set_token('REASON', SQLERRM);
6313: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

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

6306:
6307: EXCEPTION
6308: WHEN OTHERS THEN
6309: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6310: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6311: fnd_message.set_token('ERRNO', SQLCODE);
6312: fnd_message.set_token('REASON', SQLERRM);
6313: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
6314: ,p_module => l_api_name

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

6307: EXCEPTION
6308: WHEN OTHERS THEN
6309: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6310: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6311: fnd_message.set_token('ERRNO', SQLCODE);
6312: fnd_message.set_token('REASON', SQLERRM);
6313: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
6314: ,p_module => l_api_name
6315: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

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

6308: WHEN OTHERS THEN
6309: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
6310: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
6311: fnd_message.set_token('ERRNO', SQLCODE);
6312: fnd_message.set_token('REASON', SQLERRM);
6313: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
6314: ,p_module => l_api_name
6315: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM
6316: );

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

7116:
7117:
7118: EXCEPTION
7119: WHEN OTHERS THEN
7120: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7121: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7122: fnd_message.set_token('ERRNO', SQLCODE);
7123: fnd_message.set_token('REASON', SQLERRM);
7124: x_return_status := G_RETURN_UNEXP_ERR;

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

7117:
7118: EXCEPTION
7119: WHEN OTHERS THEN
7120: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7121: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7122: fnd_message.set_token('ERRNO', SQLCODE);
7123: fnd_message.set_token('REASON', SQLERRM);
7124: x_return_status := G_RETURN_UNEXP_ERR;
7125: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

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

7118: EXCEPTION
7119: WHEN OTHERS THEN
7120: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7121: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7122: fnd_message.set_token('ERRNO', SQLCODE);
7123: fnd_message.set_token('REASON', SQLERRM);
7124: x_return_status := G_RETURN_UNEXP_ERR;
7125: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7126: ,p_module => l_api_name

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

7119: WHEN OTHERS THEN
7120: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7121: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7122: fnd_message.set_token('ERRNO', SQLCODE);
7123: fnd_message.set_token('REASON', SQLERRM);
7124: x_return_status := G_RETURN_UNEXP_ERR;
7125: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7126: ,p_module => l_api_name
7127: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

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

7233: END LOOP;
7234:
7235: -- check for call compatibility.
7236: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7237: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7238: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
7239: fnd_message.set_token('REASON', 'Unsupported version '||
7240: to_char(p_api_version)||
7241: ' passed to API; expecting version '||

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

7234:
7235: -- check for call compatibility.
7236: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7237: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7238: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
7239: fnd_message.set_token('REASON', 'Unsupported version '||
7240: to_char(p_api_version)||
7241: ' passed to API; expecting version '||
7242: to_char(l_api_version));

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

7235: -- check for call compatibility.
7236: IF TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7237: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7238: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
7239: fnd_message.set_token('REASON', 'Unsupported version '||
7240: to_char(p_api_version)||
7241: ' passed to API; expecting version '||
7242: to_char(l_api_version));
7243: x_return_status := G_RETURN_UNEXP_ERR;

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

7752: );
7753:
7754: EXCEPTION
7755: WHEN OTHERS THEN
7756: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7757: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7758: fnd_message.set_token('ERRNO', SQLCODE);
7759: fnd_message.set_token('REASON', SQLERRM);
7760: x_return_status := G_RETURN_UNEXP_ERR;

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

7753:
7754: EXCEPTION
7755: WHEN OTHERS THEN
7756: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7757: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7758: fnd_message.set_token('ERRNO', SQLCODE);
7759: fnd_message.set_token('REASON', SQLERRM);
7760: x_return_status := G_RETURN_UNEXP_ERR;
7761: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

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

7754: EXCEPTION
7755: WHEN OTHERS THEN
7756: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7757: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7758: fnd_message.set_token('ERRNO', SQLCODE);
7759: fnd_message.set_token('REASON', SQLERRM);
7760: x_return_status := G_RETURN_UNEXP_ERR;
7761: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7762: ,p_module => l_api_name

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

7755: WHEN OTHERS THEN
7756: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
7757: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
7758: fnd_message.set_token('ERRNO', SQLCODE);
7759: fnd_message.set_token('REASON', SQLERRM);
7760: x_return_status := G_RETURN_UNEXP_ERR;
7761: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
7762: ,p_module => l_api_name
7763: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

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

7870: END LOOP;
7871:
7872: -- check for call compatibility.
7873: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7874: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7875: fnd_message.set_token('ROUTINE',
7876: g_pkg_name || '.'|| l_api_name);
7877: fnd_message.set_token('REASON',
7878: 'Unsupported version '|| to_char(p_api_version)||

Line 7875: fnd_message.set_token('ROUTINE',

7871:
7872: -- check for call compatibility.
7873: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7874: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7875: fnd_message.set_token('ROUTINE',
7876: g_pkg_name || '.'|| l_api_name);
7877: fnd_message.set_token('REASON',
7878: 'Unsupported version '|| to_char(p_api_version)||
7879: ' passed to API; expecting version '||

Line 7877: fnd_message.set_token('REASON',

7873: if TRUNC(l_api_version) <> TRUNC(p_api_version) THEN
7874: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
7875: fnd_message.set_token('ROUTINE',
7876: g_pkg_name || '.'|| l_api_name);
7877: fnd_message.set_token('REASON',
7878: 'Unsupported version '|| to_char(p_api_version)||
7879: ' passed to API; expecting version '||
7880: to_char(l_api_version));
7881: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

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

8217: END LOOP;
8218:
8219: EXCEPTION
8220: WHEN OTHERS THEN
8221: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8222: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8223: fnd_message.set_token('ERRNO', SQLCODE);
8224: fnd_message.set_token('REASON', SQLERRM);
8225: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

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

8218:
8219: EXCEPTION
8220: WHEN OTHERS THEN
8221: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8222: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8223: fnd_message.set_token('ERRNO', SQLCODE);
8224: fnd_message.set_token('REASON', SQLERRM);
8225: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
8226: ,p_module => l_api_name

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

8219: EXCEPTION
8220: WHEN OTHERS THEN
8221: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8222: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8223: fnd_message.set_token('ERRNO', SQLCODE);
8224: fnd_message.set_token('REASON', SQLERRM);
8225: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
8226: ,p_module => l_api_name
8227: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM

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

8220: WHEN OTHERS THEN
8221: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
8222: fnd_message.set_token('ROUTINE',G_PKG_NAME||l_api_name);
8223: fnd_message.set_token('ERRNO', SQLCODE);
8224: fnd_message.set_token('REASON', SQLERRM);
8225: code_debug (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
8226: ,p_module => l_api_name
8227: ,p_message => 'Ending: Returning OTHER ERROR '||SQLERRM
8228: );