20: raise_application_error(-20000, SQLERRM);
21: end if;
22:
23: if name is NULL then
24: fnd_message.set_name('OFA', 'FA_SHARED_SERVER_ERROR');
25: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
26: fnd_message.set_token('CALLED_FN', called_fn);
27: fnd_message.set_token('CALLING_FN', calling_fn);
28: fnd_message.set_token('SQLERRM', SUBSTR(SQLERRM, 1, 100));
22:
23: if name is NULL then
24: fnd_message.set_name('OFA', 'FA_SHARED_SERVER_ERROR');
25: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
26: fnd_message.set_token('CALLED_FN', called_fn);
27: fnd_message.set_token('CALLING_FN', calling_fn);
28: fnd_message.set_token('SQLERRM', SUBSTR(SQLERRM, 1, 100));
29: end if;
30: app_exception.raise_exception;
23: if name is NULL then
24: fnd_message.set_name('OFA', 'FA_SHARED_SERVER_ERROR');
25: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
26: fnd_message.set_token('CALLED_FN', called_fn);
27: fnd_message.set_token('CALLING_FN', calling_fn);
28: fnd_message.set_token('SQLERRM', SUBSTR(SQLERRM, 1, 100));
29: end if;
30: app_exception.raise_exception;
31: return;
24: fnd_message.set_name('OFA', 'FA_SHARED_SERVER_ERROR');
25: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
26: fnd_message.set_token('CALLED_FN', called_fn);
27: fnd_message.set_token('CALLING_FN', calling_fn);
28: fnd_message.set_token('SQLERRM', SUBSTR(SQLERRM, 1, 100));
29: end if;
30: app_exception.raise_exception;
31: return;
32: end if;
30: app_exception.raise_exception;
31: return;
32: end if;
33:
34: fnd_message.set_name('OFA', name);
35: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
36: fnd_message.set_token('CALLED_FN', called_fn);
37: fnd_message.set_token('CALLING_FN', calling_fn);
38: end if;
32: end if;
33:
34: fnd_message.set_name('OFA', name);
35: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
36: fnd_message.set_token('CALLED_FN', called_fn);
37: fnd_message.set_token('CALLING_FN', calling_fn);
38: end if;
39: if (token1 is not null) then
40: fnd_message.set_token(token1, value1, translate);
33:
34: fnd_message.set_name('OFA', name);
35: if fnd_profile.value('PRINT_DEBUG') = 'Y' then
36: fnd_message.set_token('CALLED_FN', called_fn);
37: fnd_message.set_token('CALLING_FN', calling_fn);
38: end if;
39: if (token1 is not null) then
40: fnd_message.set_token(token1, value1, translate);
41: end if;
36: fnd_message.set_token('CALLED_FN', called_fn);
37: fnd_message.set_token('CALLING_FN', calling_fn);
38: end if;
39: if (token1 is not null) then
40: fnd_message.set_token(token1, value1, translate);
41: end if;
42: if (token2 is not null) then
43: fnd_message.set_token(token2, value2, translate);
44: end if;
39: if (token1 is not null) then
40: fnd_message.set_token(token1, value1, translate);
41: end if;
42: if (token2 is not null) then
43: fnd_message.set_token(token2, value2, translate);
44: end if;
45: if (token3 is not null) then
46: fnd_message.set_token(token3, value3, translate);
47: end if;
42: if (token2 is not null) then
43: fnd_message.set_token(token2, value2, translate);
44: end if;
45: if (token3 is not null) then
46: fnd_message.set_token(token3, value3, translate);
47: end if;
48: app_exception.raise_exception;
49: end raise_error;
50: