DBA Data[Home] [Help]

APPS.HR_CAGR_ENT_ITEM_API dependencies on HR_UTILITY

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

55: WHERE p.cagr_api_param_id = p_cagr_api_param_id;
56: --
57: BEGIN
58: --
59: hr_utility.set_location('Entering:'|| l_proc, 10);
60: --
61: -- Issue a savepoint if operating in validation only mode
62: --
63: SAVEPOINT create_cagr_entitlement_item;

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

61: -- Issue a savepoint if operating in validation only mode
62: --
63: SAVEPOINT create_cagr_entitlement_item;
64: --
65: hr_utility.set_location(l_proc, 20);
66: --
67: l_effective_date := TRUNC(p_effective_date);
68: --
69: -- Validate the language parameter. l_language_code should be passed to functions

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

76: -- Create the option that will be used for this item
77: --
78: BEGIN
79: --
80: hr_utility.set_location(l_proc, 30);
81: --
82: ben_option_definition_api.create_option_definition
83: (p_validate => p_validate
84: ,p_opt_id => l_opt_id

Line 92: hr_utility.set_location(l_proc||'/'||l_opt_id, 40);

88: ,p_business_group_id => p_business_group_id
89: ,p_object_version_number => l_opt_ovn
90: ,p_effective_date => TO_DATE('01-01-1953','DD-MM-YYYY'));
91: --
92: hr_utility.set_location(l_proc||'/'||l_opt_id, 40);
93: --
94: END;
95: --
96: hr_utility.set_location(l_proc, 50);

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

92: hr_utility.set_location(l_proc||'/'||l_opt_id, 40);
93: --
94: END;
95: --
96: hr_utility.set_location(l_proc, 50);
97: --
98: -- Fetch the API ID for the CAGR Parameter
99: -- ID passed into this procedure.
100: --

Line 110: hr_utility.set_message(800, 'HR_289232_CAGR_API_PARAM_ID_IN');

106: IF csr_get_api_id%NOTFOUND THEN
107: --
108: CLOSE csr_get_api_id;
109: --
110: hr_utility.set_message(800, 'HR_289232_CAGR_API_PARAM_ID_IN');
111: hr_utility.raise_error;
112: --
113: ELSE
114: --

Line 111: hr_utility.raise_error;

107: --
108: CLOSE csr_get_api_id;
109: --
110: hr_utility.set_message(800, 'HR_289232_CAGR_API_PARAM_ID_IN');
111: hr_utility.raise_error;
112: --
113: ELSE
114: --
115: CLOSE csr_get_api_id;

Line 121: hr_utility.set_location(l_proc||'/'||l_cagr_api_id, 60);

117: END IF;
118: --
119: END IF;
120: --
121: hr_utility.set_location(l_proc||'/'||l_cagr_api_id, 60);
122: --
123: -- Process Logic
124: --
125: BEGIN

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

160: -- End of API User Hook for the before hook of create_cagr_entitlement_item
161: --
162: END;
163: --
164: hr_utility.set_location(l_proc, 70);
165: --
166: per_cei_ins.ins
167: (p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
168: ,p_effective_date => l_effective_date

Line 235: hr_utility.set_location(l_proc, 80);

231: -- End of API User Hook for the after hook of create_cagr_entitlement_item
232: --
233: end;
234: --
235: hr_utility.set_location(l_proc, 80);
236: --
237: -- When in validation only mode raise the Validate_Enabled exception
238: --
239: if p_validate then

Line 249: hr_utility.set_location(' Leaving:'||l_proc, 999);

245: p_object_version_number := l_object_version_number;
246: p_cagr_entitlement_item_id := l_cagr_entitlement_item_id;
247: p_opt_id := l_opt_id;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 999);
250: --
251: exception
252: --
253: when hr_api.validate_enabled then

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

261: -- (Any key or derived arguments must be set to null
262: -- when validation only mode is being used.)
263: --
264: p_object_version_number := null;
265: hr_utility.set_location(' Leaving:'||l_proc, 80);
266: --
267: when others then
268: --
269: -- A validation or unexpected error has occured

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

313: WHERE p.cagr_api_param_id = p_cagr_api_param_id;
314: --
315: begin
316: --
317: hr_utility.set_location('Entering:'|| l_proc, 10);
318: --
319: -- Issue a savepoint if operating in validation only mode
320: --
321: savepoint update_cagr_entitlement_item;

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

319: -- Issue a savepoint if operating in validation only mode
320: --
321: savepoint update_cagr_entitlement_item;
322: --
323: hr_utility.set_location(l_proc, 20);
324: --
325: l_effective_date := TRUNC(p_effective_date);
326: --
327: -- Validate the language parameter. l_language_code should be passed to functions

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

330: --
331: l_language_code := p_language_code;
332: hr_api.validate_language_code(p_language_code => l_language_code);
333: --
334: hr_utility.set_location(l_proc, 30);
335: --
336: -- Fetch the API ID for the CAGR Parameter
337: -- ID passed into this procedure.
338: --

Line 348: hr_utility.set_message(800, 'HR_289232_CAGR_API_PARAM_ID_IN');

344: IF csr_get_api_id%NOTFOUND THEN
345: --
346: CLOSE csr_get_api_id;
347: --
348: hr_utility.set_message(800, 'HR_289232_CAGR_API_PARAM_ID_IN');
349: hr_utility.raise_error;
350: --
351: ELSE
352: --

Line 349: hr_utility.raise_error;

345: --
346: CLOSE csr_get_api_id;
347: --
348: hr_utility.set_message(800, 'HR_289232_CAGR_API_PARAM_ID_IN');
349: hr_utility.raise_error;
350: --
351: ELSE
352: --
353: CLOSE csr_get_api_id;

Line 359: hr_utility.set_location(l_proc||'/'||l_cagr_api_id, 40);

355: END IF;
356: --
357: END IF;
358: --
359: hr_utility.set_location(l_proc||'/'||l_cagr_api_id, 40);
360: --
361: -- Process Logic
362: --
363: l_object_version_number := p_object_version_number;

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

460: -- End of API User Hook for the after hook of update_cagr_entitlement_item
461: --
462: end;
463: --
464: hr_utility.set_location(l_proc, 60);
465: --
466: -- When in validation only mode raise the Validate_Enabled exception
467: --
468: if p_validate then

Line 476: hr_utility.set_location(' Leaving:'||l_proc, 999);

472: -- Set all output arguments
473: --
474: p_object_version_number := l_object_version_number;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 999);
477: --
478: exception
479: --
480: when hr_api.validate_enabled then

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

487: -- Only set output warning arguments
488: -- (Any key or derived arguments must be set to null
489: -- when validation only mode is being used.)
490: --
491: hr_utility.set_location(' Leaving:'||l_proc, 80);
492: --
493: when others then
494: --
495: -- A validation or unexpected error has occured

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

528: AND cagitems.CAGR_ENTITLEMENT_ITEM_ID = p_cagr_entitlement_item_id;
529: --
530: begin
531: --
532: hr_utility.set_location('Entering:'|| l_proc, 10);
533: --
534: -- Issue a savepoint if operating in validation only mode
535: --
536: savepoint delete_cagr_entitlement_item;

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

534: -- Issue a savepoint if operating in validation only mode
535: --
536: savepoint delete_cagr_entitlement_item;
537: --
538: hr_utility.set_location(l_proc, 20);
539: --
540: l_effective_date := TRUNC(p_effective_date);
541: --
542: -- Process Logic

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

569: -- =============
570: --
571: -- Need to lock main table to maintain the locking ladder order
572: --
573: hr_utility.set_location( l_proc, 30);
574: per_cei_shd.lck ( p_cagr_entitlement_item_id => p_cagr_entitlement_item_id
575: ,p_object_version_number => p_object_version_number);
576: --
577: --

Line 595: hr_utility.set_location( l_proc, 35);

591: end if;
592: --
593: -- Remove all matching translation rows
594: --
595: hr_utility.set_location( l_proc, 35);
596: per_cit_del.del_tl ( p_cagr_entitlement_item_id => p_cagr_entitlement_item_id );
597: --
598: hr_utility.set_location( l_proc, 45);
599: --

Line 598: hr_utility.set_location( l_proc, 45);

594: --
595: hr_utility.set_location( l_proc, 35);
596: per_cit_del.del_tl ( p_cagr_entitlement_item_id => p_cagr_entitlement_item_id );
597: --
598: hr_utility.set_location( l_proc, 45);
599: --
600: per_cei_del.del
601: (p_cagr_entitlement_item_id => p_cagr_entitlement_item_id
602: ,p_effective_date => l_effective_date

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

622: -- End of API User Hook for the after hook of delete_cagr_entitlement_item
623: --
624: end;
625: --
626: hr_utility.set_location(l_proc, 60);
627: --
628: -- When in validation only mode raise the Validate_Enabled exception
629: --
630: if p_validate then

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

630: if p_validate then
631: raise hr_api.validate_enabled;
632: end if;
633: --
634: hr_utility.set_location(' Leaving:'||l_proc, 70);
635: --
636: exception
637: --
638: when hr_api.validate_enabled then