DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_TAB_PAGES_API dependencies on HR_UTILITY

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

52: l_object_version_number number;
53: l_template_item_Tab_page_id number;
54: l_proc varchar2(72) := g_package||'create_template_item_tab_page';
55: begin
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint create_template_item_tab_page;

Line 86: hr_utility.set_location('At:'|| l_proc, 15);

82: --
83: -- Validation in addition to Row Handlers
84: --
85:
86: hr_utility.set_location('At:'|| l_proc, 15);
87:
88: OPEN cur_api_val;
89: FETCH cur_api_val INTO l_temp;
90: IF (cur_api_val%NOTFOUND AND

Line 120: hr_utility.set_location('At:'|| l_proc, 20);

116: );
117: end loop;
118: end if;
119:
120: hr_utility.set_location('At:'|| l_proc, 20);
121:
122: hr_tip_ins.ins( p_template_item_id => p_template_item_id
123: ,p_template_tab_page_id => p_template_tab_page_id
124: ,p_template_item_tab_page_id => l_template_item_tab_page_id

Line 129: hr_utility.set_location('At:'|| l_proc, 25);

125: ,p_object_version_number => l_object_version_number);
126: --
127: -- Call After Process User Hook
128: --
129: hr_utility.set_location('At:'|| l_proc, 25);
130:
131: begin
132: hr_template_item_tab_pages_bk1.create_tip_a
133: (p_effective_date => TRUNC(p_effective_date)

Line 159: hr_utility.set_location(' Leaving:'||l_proc, 70);

155: --
156: p_template_item_tab_page_id := l_template_item_tab_page_id;
157: p_object_version_number := l_object_version_number;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 70);
160: exception
161: when hr_api.validate_enabled then
162: --
163: -- As the Validate_Enabled exception has been raised

Line 174: hr_utility.set_location(' Leaving:'||l_proc, 80);

170: -- when validation only mode is being used.)
171: --
172: p_template_item_tab_page_id := null;
173: p_object_version_number := null;
174: hr_utility.set_location(' Leaving:'||l_proc, 80);
175: when others then
176: --
177: -- A validation or unexpected error has occured
178: --

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

179: p_template_item_tab_page_id := null;
180: p_object_version_number := null;
181:
182: rollback to create_template_item_tab_page;
183: hr_utility.set_location(' Leaving:'||l_proc, 90);
184: raise;
185: end create_template_item_tab_page;
186: --
187: -- ----------------------------------------------------------------------------

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

225: l_template_item_context_page csr_template_item_context_page%ROWTYPE;
226:
227: l_proc varchar2(72) := g_package||'delete_template_item_tab_page';
228: begin
229: hr_utility.set_location('Entering:'|| l_proc, 10);
230: --
231: -- Issue a savepoint
232: --
233: savepoint delete_template_item_tab_page;

Line 254: hr_utility.set_location('At:'|| l_proc, 15);

250: end;
251: --
252: -- Validation in addition to Row Handlers
253: --
254: hr_utility.set_location('At:'|| l_proc, 15);
255:
256: OPEN cur_api_val;
257: FETCH cur_api_val INTO l_temp;
258: IF (cur_api_val%NOTFOUND AND

Line 285: hr_utility.set_location('At:'|| l_proc, 20);

281: );
282: end loop;
283: end if;
284:
285: hr_utility.set_location('At:'|| l_proc, 20);
286:
287: hr_tip_del.del( p_template_item_tab_page_id => p_template_item_tab_page_id
288: ,p_object_version_number => p_object_version_number);
289:

Line 290: hr_utility.set_location('At:'|| l_proc, 30);

286:
287: hr_tip_del.del( p_template_item_tab_page_id => p_template_item_tab_page_id
288: ,p_object_version_number => p_object_version_number);
289:
290: hr_utility.set_location('At:'|| l_proc, 30);
291:
292: --
293: -- Call After Process User Hook
294: --

Line 315: hr_utility.set_location(' Leaving:'||l_proc, 70);

311: if p_validate then
312: raise hr_api.validate_enabled;
313: end if;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 70);
316: exception
317: when hr_api.validate_enabled then
318: --
319: -- As the Validate_Enabled exception has been raised

Line 328: hr_utility.set_location(' Leaving:'||l_proc, 80);

324: -- Only set output warning arguments
325: -- (Any key or derived arguments must be set to null
326: -- when validation only mode is being used.)
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 80);
329: when others then
330: --
331: -- A validation or unexpected error has occured
332: --

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

330: --
331: -- A validation or unexpected error has occured
332: --
333: rollback to delete_template_item_tab_page;
334: hr_utility.set_location(' Leaving:'||l_proc, 90);
335: raise;
336: end delete_template_item_tab_page;
337: --
338: end hr_template_item_tab_pages_api;