DBA Data[Home] [Help]

APPS.BEN_CWB_STOCK_OPTN_DTLS_API dependencies on HR_UTILITY

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

76: l_cwb_stock_optn_dtls_id ben_cwb_stock_optn_dtls.cwb_stock_optn_dtls_id%TYPE;
77: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;
78: l_proc varchar2(72) := g_package||'create_cwb_stock_optn_dtls';
79: begin
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81: --
82: -- Issue a savepoint
83: --
84: savepoint create_cwb_stock_optn_dtls;

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

308: --
309: p_cwb_stock_optn_dtls_id := l_cwb_stock_optn_dtls_id;
310: p_object_version_number := l_object_version_number;
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 70);
313: exception
314: when hr_api.validate_enabled then
315: --
316: -- As the Validate_Enabled exception has been raised

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

324: --
325:
326: p_cwb_stock_optn_dtls_id := null;
327: p_object_version_number := null;
328: hr_utility.set_location(' Leaving:'||l_proc, 80);
329: when others then
330: --
331: -- A validation or unexpected error has occured
332: --

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

336: -- OUT parameters, including warnings, to null
337: --
338: p_cwb_stock_optn_dtls_id := null;
339: p_object_version_number := null;
340: hr_utility.set_location(' Leaving:'||l_proc, 90);
341: raise;
342: end create_cwb_stock_optn_dtls;
343: --
344: -- ----------------------------------------------------------------------------

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

411: --
412: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;
413: l_proc varchar2(72) := g_package||'update_cwb_stock_optn_dtls';
414: begin
415: hr_utility.set_location('Entering:'|| l_proc, 10);
416: --
417: -- Issue a savepoint
418: --
419: savepoint update_cwb_stock_optn_dtls;

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

417: -- Issue a savepoint
418: --
419: savepoint update_cwb_stock_optn_dtls;
420: --
421: hr_utility.set_location(l_proc, 20);
422: --
423: -- Process Logic
424: --
425: l_object_version_number := p_object_version_number;

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

646: -- Set all IN OUT and OUT parameters with out values
647: --
648: p_object_version_number := l_object_version_number;
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 70);
651: exception
652: when hr_api.validate_enabled then
653: --
654: -- As the Validate_Enabled exception has been raised

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

659: -- Only set output warning arguments
660: -- (Any key or derived arguments must be set to null
661: -- when validation only mode is being used.)
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 80);
664: --
665: when others then
666: --
667: -- A validation or unexpected error has occured

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

667: -- A validation or unexpected error has occured
668: --
669: rollback to update_cwb_stock_optn_dtls;
670: p_object_version_number := l_object_version_number;
671: hr_utility.set_location(' Leaving:'||l_proc, 90);
672: raise;
673: end update_cwb_stock_optn_dtls;
674: --
675: -- ----------------------------------------------------------------------------

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

687: --
688: l_object_version_number ben_cwb_stock_optn_dtls.object_version_number%TYPE;
689: l_proc varchar2(72) := g_package||'delete_cwb_stock_optn_dtls';
690: begin
691: hr_utility.set_location('Entering:'|| l_proc, 10);
692: --
693: -- Issue a savepoint
694: --
695: savepoint delete_cwb_stock_optn_dtls;

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

693: -- Issue a savepoint
694: --
695: savepoint delete_cwb_stock_optn_dtls;
696: --
697: hr_utility.set_location(l_proc, 20);
698: --
699: -- Process Logic
700: --
701: l_object_version_number := p_object_version_number;

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

752: if p_validate then
753: raise hr_api.validate_enabled;
754: end if;
755: --
756: hr_utility.set_location(' Leaving:'||l_proc, 70);
757: exception
758: when hr_api.validate_enabled then
759: --
760: -- As the Validate_Enabled exception has been raised

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

765: -- Only set output warning arguments
766: -- (Any key or derived arguments must be set to null
767: -- when validation only mode is being used.)
768: --
769: hr_utility.set_location(' Leaving:'||l_proc, 80);
770: --
771: when others then
772: --
773: -- A validation or unexpected error has occured

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

773: -- A validation or unexpected error has occured
774: --
775: rollback to delete_cwb_stock_optn_dtls;
776: p_object_version_number := l_object_version_number;
777: hr_utility.set_location(' Leaving:'||l_proc, 90);
778: raise;
779: end delete_cwb_stock_optn_dtls;
780: --
781: -- ----------------------------------------------------------------------------

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

793: l_proc varchar2(72) := g_package||'lck';
794: --
795: begin
796: --
797: hr_utility.set_location('Entering:'|| l_proc, 10);
798: --
799: ben_cso_shd.lck
800: (p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
801: ,p_object_version_number => p_object_version_number

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

800: (p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
801: ,p_object_version_number => p_object_version_number
802: );
803: --
804: hr_utility.set_location(' Leaving:'||l_proc, 70);
805: --
806: end lck;
807: --
808: end BEN_CWB_STOCK_OPTN_DTLS_API;