DBA Data[Home] [Help]

APPS.PAY_BALANCE_CATEGORY_API dependencies on HR_UTILITY

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

66: l_effective_start_date pay_balance_categories_f.effective_start_date%TYPE;
67: l_effective_end_date pay_balance_categories_f.effective_end_date%TYPE;
68: --
69: begin
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: --
72: -- Issue a savepoint
73: --
74: savepoint create_balance_category;

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

75: --
76: -- Truncate the time portion from all IN date parameters
77: --
78: l_effective_date := trunc(p_effective_date);
79: hr_utility.set_location(l_proc, 20);
80: --
81: -- Call Before Process User Hook
82: --
83: begin

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

126: (p_module_name => 'create_balance_category'
127: ,p_hook_type => 'BP'
128: );
129: end;
130: hr_utility.set_location(l_proc, 30);
131: --
132: -- Validation in addition to Row Handlers
133: --
134: hr_utility.set_location(l_proc, 40);

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

130: hr_utility.set_location(l_proc, 30);
131: --
132: -- Validation in addition to Row Handlers
133: --
134: hr_utility.set_location(l_proc, 40);
135: --
136: -- Process Logic
137: --
138: pay_pbc_ins.ins

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

178: ,p_effective_start_date => l_effective_start_date
179: ,p_effective_end_date => l_effective_end_date
180: );
181: --
182: hr_utility.set_location(l_proc, 50);
183: --
184: -- Call After Process User Hook
185: --
186: begin

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

233: (p_module_name => 'create_balance_category_a'
234: ,p_hook_type => 'AP'
235: );
236: end;
237: hr_utility.set_location(l_proc, 60);
238: --
239: -- When in validation only mode raise the Validate_Enabled exception
240: --
241: if p_validate then

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

253: --For MLS-----------------------------------------------------------------------
254: pay_tbc_ins.ins_tl(userenv('lang'),p_balance_category_id,p_user_category_name);
255: --------------------------------------------------------------------------------
256: g_dml_status := FALSE;
257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: exception
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised

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

270: p_balance_category_id := null;
271: p_object_version_number := null;
272: p_effective_start_date := null;
273: p_effective_end_date := null;
274: hr_utility.set_location(' Leaving:'||l_proc, 80);
275: when others then
276: --
277: -- A validation or unexpected error has occured
278: --

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

276: --
277: -- A validation or unexpected error has occured
278: --
279: rollback to create_balance_category;
280: hr_utility.set_location(' Leaving:'||l_proc, 90);
281: g_dml_status := FALSE;
282: raise;
283: end create_balance_category;
284: --

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

344: --
345: l_object_version_number pay_run_types_f.object_version_number%TYPE;
346: --
347: begin
348: hr_utility.set_location('Entering:'|| l_proc, 10);
349: --
350: -- Issue a savepoint
351: --
352: l_object_version_number := p_object_version_number;

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

354: --
355: -- Truncate the time portion from all IN date parameters
356: --
357: l_effective_date := trunc(p_effective_date);
358: hr_utility.set_location(l_proc, 20);
359: --
360: -- Call Before Process User Hook
361: --
362: begin

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

405: (p_module_name => 'update_balance_category'
406: ,p_hook_type => 'BP'
407: );
408: end;
409: hr_utility.set_location(l_proc, 30);
410: --
411: -- Validation in addition to Row Handlers
412: --
413: hr_utility.set_location(l_proc, 40);

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

409: hr_utility.set_location(l_proc, 30);
410: --
411: -- Validation in addition to Row Handlers
412: --
413: hr_utility.set_location(l_proc, 40);
414: --
415: -- Process Logic
416: --
417: -- Call the row handler

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

457: ,p_effective_start_date => l_effective_start_date
458: ,p_effective_end_date => l_effective_end_date
459: );
460: --
461: hr_utility.set_location(l_proc, 50);
462: --
463: -- Call After Process User Hook
464: --
465: begin

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

510: (p_module_name => 'update_balance_category'
511: ,p_hook_type => 'AP'
512: );
513: end;
514: hr_utility.set_location(l_proc, 60);
515: --
516: -- When in validation only mode raise the Validate_Enabled exception
517: --
518: if p_validate then

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

529: --For MLS-----------------------------------------------------------------------
530: pay_tbc_upd.upd_tl(userenv('lang'),p_balance_category_id,p_user_category_name);
531: --------------------------------------------------------------------------------
532: g_dml_status := FALSE;
533: hr_utility.set_location(' Leaving:'||l_proc, 70);
534: exception
535: when hr_api.validate_enabled then
536: --
537: -- As the Validate_Enabled exception has been raised

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

545: --
546: p_object_version_number := l_object_version_number;
547: p_effective_start_date := null;
548: p_effective_end_date := null;
549: hr_utility.set_location(' Leaving:'||l_proc, 80);
550: when others then
551: --
552: -- A validation or unexpected error has occured
553: --

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

551: --
552: -- A validation or unexpected error has occured
553: --
554: rollback to update_balance_category;
555: hr_utility.set_location(' Leaving:'||l_proc, 90);
556: g_dml_status := FALSE;
557: raise;
558: end update_balance_category;
559: --

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

585: l_validation_start_date date;
586: l_validation_end_date date;
587: l_object_version_number pay_balance_categories_f.object_version_number%type;
588: begin
589: hr_utility.set_location('Entering:'|| l_proc, 5);
590: --
591: -- Issue a savepoint and assign in-out parameters to local variable
592: --
593: savepoint delete_balance_category;

Line 596: hr_utility.set_location(l_proc, 10);

592: --
593: savepoint delete_balance_category;
594: l_object_version_number := p_object_version_number;
595: --
596: hr_utility.set_location(l_proc, 10);
597: --
598: l_effective_date := trunc(p_effective_date);
599: --
600: -- Call Before Process User Hook

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

615: ,p_hook_type => 'BP'
616: );
617: end;
618: --
619: hr_utility.set_location(l_proc, 20);
620: --
621: -- Validation in addition to Row Handlers
622: --
623: hr_utility.set_location(l_proc, 30);

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

619: hr_utility.set_location(l_proc, 20);
620: --
621: -- Validation in addition to Row Handlers
622: --
623: hr_utility.set_location(l_proc, 30);
624: --
625: begin
626: g_dml_status := TRUE;
627: --For MLS-----------------------------------------------------------------------

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

644: ,p_effective_start_date => l_effective_start_date
645: ,p_effective_end_date => l_effective_end_date
646: );
647: --
648: hr_utility.set_location(l_proc, 40);
649: --
650: -- Call After Process User Hook
651: --
652: begin

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

666: (p_module_name => 'delete_balance_category'
667: ,p_hook_type => 'AP'
668: );
669: end;
670: hr_utility.set_location(l_proc, 60);
671: --
672: -- When in validation only mode raise the Validate_Enabled exception
673: --
674: if p_validate then

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

680: p_object_version_number := p_object_version_number;
681: p_effective_start_date := l_effective_start_date;
682: p_effective_end_date := l_effective_end_date;
683: --
684: hr_utility.set_location(' Leaving:'||l_proc, 70);
685: exception
686: when hr_api.validate_enabled then
687: --
688: -- As the Validate_Enabled exception has been raised

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

697: p_object_version_number := l_object_version_number;
698: p_effective_start_date := null;
699: p_effective_end_date := null;
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 80);
702: when others then
703: --
704: -- A validation or unexpected error has occured
705: --

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

703: --
704: -- A validation or unexpected error has occured
705: --
706: rollback to delete_balance_category;
707: hr_utility.set_location(' Leaving:'||l_proc, 90);
708: raise;
709: end delete_balance_category;
710: --
711: function return_dml_status