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.PAY_WCI_OCCUPATIONS_API dependencies on HR_UTILITY

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

31: where rate_id = p_rate_id;
32:
33: begin
34:
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Derive necessary parameters
38: --
39: open csr_business_group_id;

Line 46: hr_utility.set_location(l_proc, 20);

42: --
43: -- Issue a savepoint
44: --
45: savepoint create_wci_occupation;
46: hr_utility.set_location(l_proc, 20);
47: --
48: -- Truncate the time portion from all IN date parameters
49: --
50: l_effective_date := trunc(p_effective_date);

Line 70: hr_utility.set_location(l_proc, 30);

66: (p_module_name => 'create_wci_occupation'
67: ,p_hook_type => 'BP'
68: );
69: end;
70: hr_utility.set_location(l_proc, 30);
71: --
72: -- Validation in addition to Row Handlers
73: --
74: hr_utility.set_location(l_proc, 40);

Line 74: hr_utility.set_location(l_proc, 40);

70: hr_utility.set_location(l_proc, 30);
71: --
72: -- Validation in addition to Row Handlers
73: --
74: hr_utility.set_location(l_proc, 40);
75: --
76: -- Process Logic
77: --
78: -- Call the row handler

Line 89: hr_utility.set_location(l_proc, 50);

85: ,p_object_version_number => p_object_version_number
86: ,p_occupation_id => p_occupation_id
87: );
88:
89: hr_utility.set_location(l_proc, 50);
90: --
91: -- Call After Process User Hook
92: --
93: begin

Line 110: hr_utility.set_location(l_proc, 60);

106: (p_module_name => 'create_wci_occupation'
107: ,p_hook_type => 'AP'
108: );
109: end;
110: hr_utility.set_location(l_proc, 60);
111: --
112: -- When in validation only mode raise the Validate_Enabled exception
113: --
114: if p_validate then

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

116: end if;
117: --
118: -- Set all output arguments
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121:
122: exception
123:
124: when hr_api.validate_enabled then

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

133: -- when validation only mode is being used.)
134: --
135: p_occupation_id := null;
136: p_object_version_number := null;
137: hr_utility.set_location(' Leaving:'||l_proc, 80);
138: when others then
139: --
140: -- A validation or unexpected error has occured
141: --

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

146: --
147: p_occupation_id := null;
148: p_object_version_number := null;
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 90);
151: raise;
152: end create_wci_occupation;
153: --
154: -- ----------------------------------------------------------------------------

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

178: where occupation_id = p_occupation_id;
179:
180: begin
181:
182: hr_utility.set_location('Entering:'|| l_proc, 10);
183: --
184: -- Store in out parameters
185: --
186: l_object_version_number := p_object_version_number;

Line 191: hr_utility.set_location(l_proc, 20);

187: --
188: -- Issue a savepoint
189: --
190: savepoint update_wci_occupation;
191: hr_utility.set_location(l_proc, 20);
192: --
193: -- Truncate the time portion from all IN date parameters
194: --
195: l_effective_date := trunc(p_effective_date);

Line 222: hr_utility.set_location(l_proc, 30);

218: (p_module_name => 'update_wci_occupation'
219: ,p_hook_type => 'BP'
220: );
221: end;
222: hr_utility.set_location(l_proc, 30);
223: --
224: -- Validation in addition to Row Handlers
225: --
226: hr_utility.set_location(l_proc, 40);

Line 226: hr_utility.set_location(l_proc, 40);

222: hr_utility.set_location(l_proc, 30);
223: --
224: -- Validation in addition to Row Handlers
225: --
226: hr_utility.set_location(l_proc, 40);
227: --
228: -- Process Logic
229: --
230: -- Call the row handler

Line 239: hr_utility.set_location(l_proc, 50);

235: ,p_comments => p_comments
236: ,p_object_version_number => p_object_version_number
237: );
238:
239: hr_utility.set_location(l_proc, 50);
240: --
241: -- Call After Process User Hook
242: --
243: begin

Line 260: hr_utility.set_location(l_proc, 60);

256: (p_module_name => 'update_wci_occupation'
257: ,p_hook_type => 'AP'
258: );
259: end;
260: hr_utility.set_location(l_proc, 60);
261: --
262: -- When in validation only mode raise the Validate_Enabled exception
263: --
264: if p_validate then

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

266: end if;
267: --
268: -- Set all output arguments
269: --
270: hr_utility.set_location(' Leaving:'||l_proc, 70);
271:
272: exception
273:
274: when hr_api.validate_enabled then

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

282: -- (Any key or derived arguments must be set to null
283: -- when validation only mode is being used.)
284: --
285: p_object_version_number := l_object_version_number;
286: hr_utility.set_location(' Leaving:'||l_proc, 80);
287: when others then
288: --
289: -- A validation or unexpected error has occured
290: --

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

294: -- Reset all OUT/IN OUT parameters
295: --
296: p_object_version_number := l_object_version_number;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 90);
299: raise;
300: end update_wci_occupation;
301: --
302: -- ----------------------------------------------------------------------------

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

321: where occupation_id = p_occupation_id;
322:
323: begin
324:
325: hr_utility.set_location('Entering:'|| l_proc, 10);
326: --
327: -- Issue a savepoint
328: --
329: savepoint delete_wci_occupation;

Line 330: hr_utility.set_location(l_proc, 20);

326: --
327: -- Issue a savepoint
328: --
329: savepoint delete_wci_occupation;
330: hr_utility.set_location(l_proc, 20);
331: --
332: -- Truncate the time portion from all IN date parameters
333: --
334: -- Derive necessary parameters

Line 355: hr_utility.set_location(l_proc, 30);

351: (p_module_name => 'delete_wci_occupation'
352: ,p_hook_type => 'BP'
353: );
354: end;
355: hr_utility.set_location(l_proc, 30);
356: --
357: -- Validation in addition to Row Handlers
358: --
359: hr_utility.set_location(l_proc, 40);

Line 359: hr_utility.set_location(l_proc, 40);

355: hr_utility.set_location(l_proc, 30);
356: --
357: -- Validation in addition to Row Handlers
358: --
359: hr_utility.set_location(l_proc, 40);
360: --
361: -- Process Logic
362: --
363: -- Call the row handler

Line 370: hr_utility.set_location(l_proc, 50);

366: (p_occupation_id => p_occupation_id
367: ,p_object_version_number => p_object_version_number
368: );
369:
370: hr_utility.set_location(l_proc, 50);
371: --
372: -- Call After Process User Hook
373: --
374: begin

Line 387: hr_utility.set_location(l_proc, 60);

383: (p_module_name => 'delete_wci_occupation'
384: ,p_hook_type => 'AP'
385: );
386: end;
387: hr_utility.set_location(l_proc, 60);
388: --
389: -- When in validation only mode raise the Validate_Enabled exception
390: --
391: if p_validate then

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

393: end if;
394: --
395: -- Set all output arguments
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 70);
398:
399: exception
400:
401: when hr_api.validate_enabled then

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

408: -- Only set output warning arguments
409: -- (Any key or derived arguments must be set to null
410: -- when validation only mode is being used.)
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 80);
413: when others then
414: --
415: -- A validation or unexpected error has occured
416: --

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

414: --
415: -- A validation or unexpected error has occured
416: --
417: rollback to delete_wci_occupation;
418: hr_utility.set_location(' Leaving:'||l_proc, 90);
419: raise;
420:
421: end delete_wci_occupation;
422: --