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