DBA Data[Home] [Help]

APPS.PQH_DST_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_dst_shd.api_updating
47: (p_dflt_budget_set_id => p_dflt_budget_set_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_dflt_budget_set_id;
75: --
76: -- ----------------------------------------------------------------------------

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

90: and dflt_budget_set_id <> nvl(p_dflt_budget_set_id,0);
91:
92: Begin
93: --
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: --
96: open csr_budget_set_name;
97: fetch csr_budget_set_name into l_dummy;
98: close csr_budget_set_name;

Line 102: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SET_NAME');

98: close csr_budget_set_name;
99:
100: if nvl(l_dummy ,'Y') = 'X' then
101: --
102: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SET_NAME');
103: hr_utility.raise_error;
104: --
105: end if;
106:

Line 103: hr_utility.raise_error;

99:
100: if nvl(l_dummy ,'Y') = 'X' then
101: --
102: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SET_NAME');
103: hr_utility.raise_error;
104: --
105: end if;
106:
107: --

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

104: --
105: end if;
106:
107: --
108: hr_utility.set_location('Leaving:'||l_proc,10);
109: --
110: end chk_budget_set_name;
111:
112: -- ----------------------------------------------------------------------------

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

116: --
117: l_proc varchar2(72) := g_package||'insert_validate';
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: -- Call all supporting business operations
123: --
124: chk_dflt_budget_set_id

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

130: p_dflt_budget_set_name => p_rec.dflt_budget_set_name);
131: --
132: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 10);
135: End insert_validate;
136: --
137: -- ----------------------------------------------------------------------------
138: -- |---------------------------< update_validate >----------------------------|

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

141: --
142: l_proc varchar2(72) := g_package||'update_validate';
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: -- Call all supporting business operations
148: --
149: chk_dflt_budget_set_id

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

156: --
157:
158: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: End update_validate;
162: --
163: -- ----------------------------------------------------------------------------
164: -- |---------------------------< delete_validate >----------------------------|

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

167: --
168: l_proc varchar2(72) := g_package||'delete_validate';
169: --
170: Begin
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: -- Call all supporting business operations
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: -- Call all supporting business operations
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: End delete_validate;
177: --
178: --
179: -- ---------------------------------------------------------------------------

Line 202: hr_utility.set_location('Entering:'|| l_proc, 10);

198: l_proc varchar2(72) := g_package||'return_legislation_code';
199: --
200: begin
201: --
202: hr_utility.set_location('Entering:'|| l_proc, 10);
203: --
204: -- Ensure that all the mandatory parameter are not null
205: --
206: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 220: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

216: close csr_leg_code;
217: --
218: -- The primary key is invalid therefore we must error
219: --
220: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
221: hr_utility.raise_error;
222: --
223: end if;
224: --

Line 221: hr_utility.raise_error;

217: --
218: -- The primary key is invalid therefore we must error
219: --
220: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
221: hr_utility.raise_error;
222: --
223: end if;
224: --
225: close csr_leg_code;

Line 227: hr_utility.set_location(' Leaving:'|| l_proc, 20);

223: end if;
224: --
225: close csr_leg_code;
226: --
227: hr_utility.set_location(' Leaving:'|| l_proc, 20);
228: --
229: return l_legislation_code;
230: --
231: end return_legislation_code;