DBA Data[Home] [Help]

APPS.PQH_DFS_UPD dependencies on HR_UTILITY

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

49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;

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

73: organization_id = p_rec.organization_id
74: where dflt_fund_src_id = p_rec.dflt_fund_src_id;
75: --
76: --
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: --
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated

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

129: --
130: l_proc varchar2(72) := g_package||'pre_update';
131: --
132: Begin
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: hr_utility.set_location(' Leaving:'||l_proc, 10);
136: End pre_update;
137: --

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

131: --
132: Begin
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: hr_utility.set_location(' Leaving:'||l_proc, 10);
136: End pre_update;
137: --
138: -- ----------------------------------------------------------------------------
139: -- |-----------------------------< post_update >------------------------------|

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

181: where dflt_budget_element_id = p_dflt_budget_element_id;
182:
183:
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: --
188: open csr_element(p_dflt_budget_element_id => p_rec.dflt_budget_element_id);
189: fetch csr_element into l_sum;

Line 195: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');

191:
192: if l_sum > 100 then
193: -- sum cannot be more then 100
194: --
195: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');
196: hr_utility.raise_error;
197: --
198: end if;
199: --

Line 196: hr_utility.raise_error;

192: if l_sum > 100 then
193: -- sum cannot be more then 100
194: --
195: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');
196: hr_utility.raise_error;
197: --
198: end if;
199: --
200: -- Start of API User Hook for post_update.

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

236: --
237: -- End of API User Hook for post_update.
238: --
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: End post_update;
242: --
243: -- ----------------------------------------------------------------------------
244: -- |-----------------------------< convert_defs >-----------------------------|

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

288: l_proc varchar2(72) := g_package||'convert_defs';
289: --
290: Begin
291: --
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- We must now examine each argument value in the
295: -- p_rec plsql record structure
296: -- to see if a system default is being used. If a system default

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

328: p_rec.organization_id :=
329: pqh_dfs_shd.g_old_rec.organization_id;
330: End If;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 10);
333: --
334: End convert_defs;
335: --
336: -- ----------------------------------------------------------------------------

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

343: --
344: l_proc varchar2(72) := g_package||'upd';
345: --
346: Begin
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: -- We must lock the row which we need to update.
350: --
351: pqh_dfs_shd.lck

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

396: l_rec pqh_dfs_shd.g_rec_type;
397: l_proc varchar2(72) := g_package||'upd';
398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: -- Call conversion function to turn arguments into the
403: -- l_rec structure.
404: --

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

423: --
424: upd(l_rec);
425: p_object_version_number := l_rec.object_version_number;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: End upd;
429: --
430: end pqh_dfs_upd;