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.AME_ACA_BUS dependencies on FND_APPLICATION

Line 11: -- |-----------------------< CHK_FND_APPLICATION_ID >-------------------------|

7: --
8: g_package varchar2(33) := ' ame_aca_bus.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |-----------------------< CHK_FND_APPLICATION_ID >-------------------------|
12: -- ----------------------------------------------------------------------------
13: -- {Start Of Comments}
14: --
15: -- Description:

Line 16: -- This procedure checks whether a valid FND Application ID has been

12: -- ----------------------------------------------------------------------------
13: -- {Start Of Comments}
14: --
15: -- Description:
16: -- This procedure checks whether a valid FND Application ID has been
17: -- provided. The ID must be defined in the FND_APPLICATION table.
18: --
19: -- Pre-Requisites:
20: -- None

Line 17: -- provided. The ID must be defined in the FND_APPLICATION table.

13: -- {Start Of Comments}
14: --
15: -- Description:
16: -- This procedure checks whether a valid FND Application ID has been
17: -- provided. The ID must be defined in the FND_APPLICATION table.
18: --
19: -- Pre-Requisites:
20: -- None
21: --

Line 23: -- p_fnd_application_id

19: -- Pre-Requisites:
20: -- None
21: --
22: -- In Parameters:
23: -- p_fnd_application_id
24: --
25: -- Post Success:
26: -- Processing continues if a valid FND Application ID is found.
27: --

Line 26: -- Processing continues if a valid FND Application ID is found.

22: -- In Parameters:
23: -- p_fnd_application_id
24: --
25: -- Post Success:
26: -- Processing continues if a valid FND Application ID is found.
27: --
28: -- Post Failure:
29: -- An application error is raised either if the p_fnd_application_id is not
30: -- defined or if the value is not found in FND_APPLICATION table.

Line 29: -- An application error is raised either if the p_fnd_application_id is not

25: -- Post Success:
26: -- Processing continues if a valid FND Application ID is found.
27: --
28: -- Post Failure:
29: -- An application error is raised either if the p_fnd_application_id is not
30: -- defined or if the value is not found in FND_APPLICATION table.
31: --
32: -- Access Status:
33: -- Internal Row Handler Use Only.

Line 30: -- defined or if the value is not found in FND_APPLICATION table.

26: -- Processing continues if a valid FND Application ID is found.
27: --
28: -- Post Failure:
29: -- An application error is raised either if the p_fnd_application_id is not
30: -- defined or if the value is not found in FND_APPLICATION table.
31: --
32: -- Access Status:
33: -- Internal Row Handler Use Only.
34: --

Line 37: procedure chk_fnd_application_id(p_fnd_application_id in number) IS

33: -- Internal Row Handler Use Only.
34: --
35: -- {End Of Comments}
36: -- ----------------------------------------------------------------------------
37: procedure chk_fnd_application_id(p_fnd_application_id in number) IS
38: --
39: cursor csr_fnd_application_id is
40: select null
41: from fnd_application

Line 39: cursor csr_fnd_application_id is

35: -- {End Of Comments}
36: -- ----------------------------------------------------------------------------
37: procedure chk_fnd_application_id(p_fnd_application_id in number) IS
38: --
39: cursor csr_fnd_application_id is
40: select null
41: from fnd_application
42: where application_id = p_fnd_application_id;
43: l_proc varchar2(72) := g_package || 'CHK_FND_APPLICATION_ID';

Line 41: from fnd_application

37: procedure chk_fnd_application_id(p_fnd_application_id in number) IS
38: --
39: cursor csr_fnd_application_id is
40: select null
41: from fnd_application
42: where application_id = p_fnd_application_id;
43: l_proc varchar2(72) := g_package || 'CHK_FND_APPLICATION_ID';
44: l_key varchar2(1);
45: --

Line 42: where application_id = p_fnd_application_id;

38: --
39: cursor csr_fnd_application_id is
40: select null
41: from fnd_application
42: where application_id = p_fnd_application_id;
43: l_proc varchar2(72) := g_package || 'CHK_FND_APPLICATION_ID';
44: l_key varchar2(1);
45: --
46: Begin

Line 43: l_proc varchar2(72) := g_package || 'CHK_FND_APPLICATION_ID';

39: cursor csr_fnd_application_id is
40: select null
41: from fnd_application
42: where application_id = p_fnd_application_id;
43: l_proc varchar2(72) := g_package || 'CHK_FND_APPLICATION_ID';
44: l_key varchar2(1);
45: --
46: Begin
47: hr_utility.set_location('Entering:'||l_proc,10);

Line 49: ,p_argument => 'FND_APPLICATION_ID'

45: --
46: Begin
47: hr_utility.set_location('Entering:'||l_proc,10);
48: hr_api.mandatory_arg_error(p_api_name => l_proc
49: ,p_argument => 'FND_APPLICATION_ID'
50: ,p_argument_value => p_fnd_application_id
51: );
52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;

Line 50: ,p_argument_value => p_fnd_application_id

46: Begin
47: hr_utility.set_location('Entering:'||l_proc,10);
48: hr_api.mandatory_arg_error(p_api_name => l_proc
49: ,p_argument => 'FND_APPLICATION_ID'
50: ,p_argument_value => p_fnd_application_id
51: );
52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then

Line 52: open csr_fnd_application_id;

48: hr_api.mandatory_arg_error(p_api_name => l_proc
49: ,p_argument => 'FND_APPLICATION_ID'
50: ,p_argument_value => p_fnd_application_id
51: );
52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then
55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');

Line 53: fetch csr_fnd_application_id into l_key;

49: ,p_argument => 'FND_APPLICATION_ID'
50: ,p_argument_value => p_fnd_application_id
51: );
52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then
55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');
57: fnd_message.raise_error;

Line 54: if(csr_fnd_application_id%notfound) then

50: ,p_argument_value => p_fnd_application_id
51: );
52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then
55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');
57: fnd_message.raise_error;
58: else

Line 55: close csr_fnd_application_id;

51: );
52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then
55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');
57: fnd_message.raise_error;
58: else
59: close csr_fnd_application_id;

Line 56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');

52: open csr_fnd_application_id;
53: fetch csr_fnd_application_id into l_key;
54: if(csr_fnd_application_id%notfound) then
55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');
57: fnd_message.raise_error;
58: else
59: close csr_fnd_application_id;
60: end if;

Line 59: close csr_fnd_application_id;

55: close csr_fnd_application_id;
56: fnd_message.set_name('AME', 'INVALID_FND_APPLICATION_ID');
57: fnd_message.raise_error;
58: else
59: close csr_fnd_application_id;
60: end if;
61: hr_utility.set_location(' Leaving:'||l_proc,30);
62: exception
63: when app_exception.application_exception then

Line 65: (p_associated_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID'

61: hr_utility.set_location(' Leaving:'||l_proc,30);
62: exception
63: when app_exception.application_exception then
64: if hr_multi_message.exception_add
65: (p_associated_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID'
66: ) then
67: hr_utility.set_location(' Leaving:'||l_proc, 40);
68: raise;
69: end if;

Line 71: End chk_fnd_application_id;

67: hr_utility.set_location(' Leaving:'||l_proc, 40);
68: raise;
69: end if;
70: hr_utility.set_location(' Leaving:'||l_proc,50);
71: End chk_fnd_application_id;
72: --
73: -- ----------------------------------------------------------------------------
74: -- |------------------------< CHK_APPLICATION_NAME >--------------------------|
75: -- ----------------------------------------------------------------------------

Line 147: -- This procedure checks the uniqueness of the FND_APPLICATION_ID -

143: -- ----------------------------------------------------------------------------
144: -- {Start Of Comments}
145: --
146: -- Description:
147: -- This procedure checks the uniqueness of the FND_APPLICATION_ID -
148: -- TRANSACTION_TYPE_ID combination.TRANSACTION_TYPE_ID cannot be null if an
149: -- existing transaction type already exists for the same application with a
150: -- null TRANSACTION_TYPE_ID
151: --

Line 153: -- chk_fnd_application_id must have been evaluated.

149: -- existing transaction type already exists for the same application with a
150: -- null TRANSACTION_TYPE_ID
151: --
152: -- Pre-Requisites:
153: -- chk_fnd_application_id must have been evaluated.
154: --
155: -- In Parameters:
156: -- p_fnd_application_id
157: -- p_transaction_type_id

Line 156: -- p_fnd_application_id

152: -- Pre-Requisites:
153: -- chk_fnd_application_id must have been evaluated.
154: --
155: -- In Parameters:
156: -- p_fnd_application_id
157: -- p_transaction_type_id
158: --
159: -- Post Success:
160: -- Processing continues if the combination is found unique.

Line 171: procedure chk_fnd_app_id_tx_type_id(p_fnd_application_id in number

167: -- Internal Row Handler Use Only.
168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: procedure chk_fnd_app_id_tx_type_id(p_fnd_application_id in number
172: ,p_transaction_type_id in varchar2
173: ) IS
174: --
175: cursor csr_fnd_app_tx_type is

Line 178: where fnd_application_id=p_fnd_application_id

174: --
175: cursor csr_fnd_app_tx_type is
176: select null
177: from ame_calling_apps
178: where fnd_application_id=p_fnd_application_id
179: and ((transaction_type_id is null and p_transaction_type_id is null)
180: or (transaction_type_id = p_transaction_type_id)
181: );
182: -- and sysdate between start_date and nvl(end_date-(1/84600),sysdate);

Line 189: (p_check_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID') then

185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc,10);
188: if hr_multi_message.no_all_inclusive_error
189: (p_check_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID') then
190: open csr_fnd_app_tx_type;
191: fetch csr_fnd_app_tx_type into l_key;
192: if(csr_fnd_app_tx_type%found) then
193: close csr_fnd_app_tx_type;

Line 364: -- FND_APPLICATION_ID is non-updateable

360: --
361: -- EDIT_HERE: Add checks to ensure non-updateable args have
362: -- not been updated.
363: --
364: -- FND_APPLICATION_ID is non-updateable
365: --
366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>
367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then
368: hr_api.argument_changed_error

Line 366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>

362: -- not been updated.
363: --
364: -- FND_APPLICATION_ID is non-updateable
365: --
366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>
367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then
368: hr_api.argument_changed_error
369: (p_api_name => l_proc
370: ,p_argument => 'FND_APPLICATION_ID'

Line 367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then

363: --
364: -- FND_APPLICATION_ID is non-updateable
365: --
366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>
367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then
368: hr_api.argument_changed_error
369: (p_api_name => l_proc
370: ,p_argument => 'FND_APPLICATION_ID'
371: ,p_base_table => ame_aca_shd.g_tab_nam

Line 370: ,p_argument => 'FND_APPLICATION_ID'

366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>
367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then
368: hr_api.argument_changed_error
369: (p_api_name => l_proc
370: ,p_argument => 'FND_APPLICATION_ID'
371: ,p_base_table => ame_aca_shd.g_tab_nam
372: );
373: end if;
374: --

Line 593: chk_fnd_application_id

589: --
590: chk_is_tty_id_null
591: (p_transaction_type_id => p_rec.transaction_type_id);
592: --
593: chk_fnd_application_id
594: (p_fnd_application_id => p_rec.fnd_application_id);
595: --
596: chk_application_name
597: (p_application_name => p_rec.application_name

Line 594: (p_fnd_application_id => p_rec.fnd_application_id);

590: chk_is_tty_id_null
591: (p_transaction_type_id => p_rec.transaction_type_id);
592: --
593: chk_fnd_application_id
594: (p_fnd_application_id => p_rec.fnd_application_id);
595: --
596: chk_application_name
597: (p_application_name => p_rec.application_name
598: ,p_effective_date => p_effective_date

Line 602: (p_fnd_application_id => p_rec.fnd_application_id

598: ,p_effective_date => p_effective_date
599: );
600: --
601: chk_fnd_app_id_tx_type_id
602: (p_fnd_application_id => p_rec.fnd_application_id
603: ,p_transaction_type_id => p_rec.transaction_type_id
604: );
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 10);