APPS.PAY_EXA_BUS dependencies on HR_UTILITY

Line 38: hr_utility.set_location('Entering:'||l_proc, 5);

34: l_territory_code pay_external_accounts.territory_code%type;
35: l_dummy number;
36: --
37: begin
38: hr_utility.set_location('Entering:'||l_proc, 5);
39: --
40: -- true if PK exists, false if PK does not exist
41: -- stub - not required
42: --

Line 62: hr_utility.trace('| fresh combination, validate territory_code');

58: -- nb. territory code can be assumed to be not null as it is a mandatory
59: -- parameter
60: --
61: if l_territory_code is null then
62: hr_utility.trace('| fresh combination, validate territory_code');
63: --
64: hr_utility.set_location(l_proc, 10);
65: --
66: open csr_chk_territory_code;

Line 64: hr_utility.set_location(l_proc, 10);

60: --
61: if l_territory_code is null then
62: hr_utility.trace('| fresh combination, validate territory_code');
63: --
64: hr_utility.set_location(l_proc, 10);
65: --
66: open csr_chk_territory_code;
67: fetch csr_chk_territory_code into l_dummy;
68: --

Line 71: hr_utility.set_message(801, 'HR_7727_EXA_TERR_CODE_INVALID');

67: fetch csr_chk_territory_code into l_dummy;
68: --
69: if csr_chk_territory_code%notfound then
70: close csr_chk_territory_code;
71: hr_utility.set_message(801, 'HR_7727_EXA_TERR_CODE_INVALID');
72: hr_utility.raise_error;
73: end if;
74: --
75: close csr_chk_territory_code;

Line 72: hr_utility.raise_error;

68: --
69: if csr_chk_territory_code%notfound then
70: close csr_chk_territory_code;
71: hr_utility.set_message(801, 'HR_7727_EXA_TERR_CODE_INVALID');
72: hr_utility.raise_error;
73: end if;
74: --
75: close csr_chk_territory_code;
76: --

Line 81: hr_utility.trace('| old combination, chk territory_code is not mutating');

77: -- territory code exists, therefore using an existing combination record,
78: -- check that territory code has not being changed
79: --
80: else
81: hr_utility.trace('| old combination, chk territory_code is not mutating');
82: if ( nvl(p_territory_code, hr_api.g_varchar2) <>
83: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) ) then
84: hr_api.argument_changed_error(
85: p_api_name => l_proc,

Line 90: hr_utility.set_location(' Leaving:'||l_proc, 15);

86: p_argument => 'TERRITORY_CODE');
87: end if;
88: end if;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 15);
91: end chk_territory_code;
92: -- [end of change: 40.1, Dave Harris]
93: --
94: -- ----------------------------------------------------------------------------

Line 105: hr_utility.set_location('Entering:'||l_proc, 5);

101: --
102: l_proc varchar2(72) := g_package||'insert_validate';
103: --
104: begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Call all supporting business operations
108: --
109: -- [start of change: 40.1, Dave Harris]

Line 115: hr_utility.set_location(' Leaving:'||l_proc, 10);

111: p_external_account_id => p_rec.external_account_id,
112: p_object_version_number => p_rec.object_version_number);
113: -- [end of change: 40.1, Dave Harris]
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: end insert_validate;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |---------------------------< update_validate >----------------------------|

Line 128: hr_utility.set_location('Entering:'||l_proc, 5);

124: --
125: l_proc varchar2(72) := g_package||'update_validate';
126: --
127: begin
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: -- Call all supporting business operations
131: --
132: -- [start of change: 40.1, Dave Harris]

Line 139: hr_utility.set_location(' Leaving:'||l_proc, 10);

135: p_object_version_number => p_rec.object_version_number);
136: --
137: -- [end of change: 40.1, Dave Harris]
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: end update_validate;
141: --
142: END pay_exa_bus;