DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_API dependencies on HR_UTILITY

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

115: l_employer_subtype per_previous_employers.employer_subtype%type;
116: l_all_assignments per_previous_employers.all_assignments%type
117: := p_all_assignments;
118: begin
119: hr_utility.set_location('Entering:'||l_proc, 10);
120: --
121: -- Issue a savepoint
122: --
123: savepoint create_previous_employer;

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

427: --
428: p_previous_employer_id := l_previous_employer_id;
429: p_object_version_number := l_object_version_number;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 70);
432: exception
433: when hr_api.validate_enabled then
434: --
435: -- As the Validate_Enabled exception has been raised

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

442: -- when validation only mode is being used.)
443: --
444: p_previous_employer_id := null;
445: p_object_version_number := null;
446: hr_utility.set_location(' Leaving:'||l_proc, 80);
447: when others then
448: --
449: -- A validation or unexpected error has occured
450: --

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

454: --
455: p_previous_employer_id := null;
456: p_object_version_number := null;
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 90);
459: raise;
460: end create_previous_employer;
461: --
462: -- -----------------------------------------------------------------------

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

568: l_employer_subtype per_previous_employers.employer_subtype%type;
569: l_all_assignments per_previous_employers.all_assignments%type
570: := p_all_assignments;
571: begin
572: hr_utility.set_location('Entering:'|| l_proc, 10);
573: --
574: -- Issue a savepoint
575: --
576: savepoint update_previous_employer;

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

871: -- Set all output arguments
872: --
873: p_object_version_number := l_object_version_number;
874: --
875: hr_utility.set_location(' Leaving:'||l_proc, 70);
876: exception
877: when hr_api.validate_enabled then
878: --
879: -- As the Validate_Enabled exception has been raised

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

886: -- when validation only mode is being used.)
887: --
888: -- IN OUT parameter should be reset to its IN value
889: -- therefore no need to reset p_object_version_number
890: hr_utility.set_location(' Leaving:'||l_proc, 80);
891: when others then
892: --
893: -- A validation or unexpected error has occured
894: --

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

897: -- set in out parameters and set out parameters
898: --
899: p_object_version_number := l_ovn;
900: --
901: hr_utility.set_location(' Leaving:'||l_proc, 90);
902: raise;
903: end update_previous_employer;
904: --
905: -- -----------------------------------------------------------------------

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

934: from per_previous_job_usages
935: where previous_employer_id = t_previous_employer_id;
936: --
937: begin
938: hr_utility.set_location('Entering:'|| l_proc, 10);
939: --
940: -- Issue a savepoint
941: --
942: savepoint delete_previous_employer;

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

1015: -- Set all output arguments
1016: --
1017: p_object_version_number := l_object_version_number;
1018: --
1019: hr_utility.set_location(' Leaving:'||l_proc, 70);
1020: --
1021: exception
1022: when hr_api.validate_enabled then
1023: --

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

1032: --
1033: -- IN OUT parameter should be reset to its IN value therefore
1034: -- no need to set p_object_version_number
1035: --
1036: hr_utility.set_location(' Leaving:'||l_proc, 80);
1037: when others then
1038: --
1039: -- A validation or unexpected error has occured
1040: --

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

1042: --
1043: -- set in out parameters and set out parameters
1044: --
1045: p_object_version_number := l_ovn;
1046: hr_utility.set_location(' Leaving:'||l_proc, 90);
1047: raise;
1048: end delete_previous_employer;
1049: --
1050: -- -----------------------------------------------------------------------

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

1146: l_period_days per_previous_employers.period_days%type;
1147: --
1148: l_all_assignments per_previous_jobs.all_assignments%type;
1149: begin
1150: hr_utility.set_location('Entering:'||l_proc, 10);
1151: --
1152: -- Issue a savepoint
1153: --
1154: savepoint create_previous_job;

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

1439: --
1440: p_previous_job_id := l_previous_job_id;
1441: p_object_version_number := l_object_version_number;
1442: --
1443: hr_utility.set_location(' Leaving:'||l_proc, 70);
1444: exception
1445: when hr_api.validate_enabled then
1446: --
1447: -- As the Validate_Enabled exception has been raised

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

1454: -- when validation only mode is being used.)
1455: --
1456: p_previous_job_id := null;
1457: p_object_version_number := null;
1458: hr_utility.set_location(' Leaving:'||l_proc, 80);
1459: when others then
1460: --
1461: -- A validation or unexpected error has occured
1462: --

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

1466: --
1467: p_previous_job_id := null;
1468: p_object_version_number := null;
1469: --
1470: hr_utility.set_location(' Leaving:'||l_proc, 90);
1471: raise;
1472: end create_previous_job;
1473: --
1474: -- -----------------------------------------------------------------------

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

1568: l_period_days Number(10); --per_previous_jobs.period_days%type;
1569: --
1570: l_all_assignments per_previous_jobs.all_assignments%type;
1571: begin
1572: hr_utility.set_location('Entering:'|| l_proc, 10);
1573: --
1574: -- Issue a savepoint
1575: --
1576: savepoint update_previous_job;

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

1855: -- Set all output arguments
1856: --
1857: p_object_version_number := l_object_version_number;
1858: --
1859: hr_utility.set_location(' Leaving:'||l_proc, 70);
1860: exception
1861: when hr_api.validate_enabled then
1862: --
1863: -- As the Validate_Enabled exception has been raised

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

1870: -- when validation only mode is being used.)
1871: --
1872: -- IN OUT parameter should be reset to its IN value
1873: -- therefore no need to reset p_object_version_number
1874: hr_utility.set_location(' Leaving:'||l_proc, 80);
1875: when others then
1876: --
1877: -- A validation or unexpected error has occured
1878: --

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

1880: --
1881: -- set in out parameters and set out parameters
1882: --
1883: p_object_version_number := l_ovn;
1884: hr_utility.set_location(' Leaving:'||l_proc, 90);
1885: raise;
1886: end update_previous_job;
1887: --
1888: -- -----------------------------------------------------------------------

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

1914: from per_prev_job_extra_info
1915: where previous_job_id = p_previous_job_id;
1916: --
1917: begin
1918: hr_utility.set_location('Entering:'|| l_proc, 10);
1919: --
1920: -- Issue a savepoint
1921: --
1922: savepoint delete_previous_job;

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

1988: -- Set all output arguments
1989: --
1990: p_object_version_number := l_object_version_number;
1991: --
1992: hr_utility.set_location(' Leaving:'||l_proc, 70);
1993: --
1994: exception
1995: when hr_api.validate_enabled then
1996: --

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

2005: --
2006: -- IN OUT parameter should be reset to its IN value therefore
2007: -- no need to set p_object_version_number
2008: --
2009: hr_utility.set_location(' Leaving:'||l_proc, 80);
2010: when others then
2011: --
2012: -- A validation or unexpected error has occured
2013: --

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

2015: --
2016: -- set in out parameters and set out parameters
2017: --
2018: p_object_version_number := l_ovn;
2019: hr_utility.set_location(' Leaving:'||l_proc, 90);
2020: raise;
2021: end delete_previous_job;
2022: --
2023: --

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

2104: per_prev_job_extra_info.object_version_number%type;
2105: l_proc varchar2(72) := g_package||'create_prev_job_extra_info';
2106: --
2107: begin
2108: hr_utility.set_location('Entering:'|| l_proc, 10);
2109: --
2110: -- Issue a savepoint
2111: --
2112: savepoint create_prev_job_extra_info;

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

2348: --
2349: p_object_version_number := l_object_version_number;
2350: p_previous_job_extra_info_id := l_previous_job_extra_info_id;
2351: --
2352: hr_utility.set_location(' Leaving:'||l_proc, 70);
2353: exception
2354: when hr_api.validate_enabled then
2355: --
2356: -- As the Validate_Enabled exception has been raised

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

2363: -- when validation only mode is being used.)
2364: --
2365: p_previous_job_extra_info_id := null;
2366: p_object_version_number := null;
2367: hr_utility.set_location(' Leaving:'||l_proc, 80);
2368: when others then
2369: --
2370: -- A validation or unexpected error has occured
2371: --

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

2374: -- set in out parameters and set out parameters
2375: --
2376: p_previous_job_extra_info_id := null;
2377: p_object_version_number := null;
2378: hr_utility.set_location(' Leaving:'||l_proc, 90);
2379: raise;
2380: end create_prev_job_extra_info;
2381: --
2382: -- -----------------------------------------------------------------------

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

2457: per_prev_job_extra_info.object_version_number%type
2458: := p_object_version_number;
2459: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;
2460: begin
2461: hr_utility.set_location('Entering:'|| l_proc, 10);
2462: --
2463: -- Issue a savepoint
2464: --
2465: savepoint update_prev_job_extra_info;

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

2702: -- Set all output arguments
2703: --
2704: p_object_version_number := l_object_version_number;
2705: --
2706: hr_utility.set_location(' Leaving:'||l_proc, 70);
2707: exception
2708: when hr_api.validate_enabled then
2709: --
2710: -- As the Validate_Enabled exception has been raised

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

2714: --
2715: -- Only set output warning arguments
2716: -- (Any key or derived arguments must be set to null
2717: -- when validation only mode is being used.)
2718: hr_utility.set_location(' Leaving:'||l_proc, 80);
2719: when others then
2720: --
2721: -- A validation or unexpected error has occured
2722: --

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

2724: --
2725: -- set in out parameters and set out parameters
2726: --
2727: p_object_version_number := l_ovn;
2728: hr_utility.set_location(' Leaving:'||l_proc, 90);
2729: raise;
2730: end update_prev_job_extra_info;
2731: --
2732: -- -----------------------------------------------------------------------

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

2747: per_prev_job_extra_info.object_version_number%type
2748: := p_object_version_number;
2749: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;
2750: begin
2751: hr_utility.set_location('Entering:'|| l_proc, 10);
2752: --
2753: -- Issue a savepoint
2754: --
2755: savepoint delete_prev_job_extra_info;

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

2802: -- Set all output arguments
2803: --
2804: p_object_version_number := l_object_version_number;
2805: --
2806: hr_utility.set_location(' Leaving:'||l_proc, 70);
2807: --
2808: exception
2809: when hr_api.validate_enabled then
2810: --

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

2816: -- Only set output warning arguments
2817: -- (Any key or derived arguments must be set to null
2818: -- when validation only mode is being used.)
2819: --
2820: hr_utility.set_location(' Leaving:'||l_proc, 80);
2821: when others then
2822: --
2823: -- A validation or unexpected error has occured
2824: --

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

2826: --
2827: -- set in out parameters and set out parameters
2828: --
2829: p_object_version_number := l_ovn;
2830: hr_utility.set_location(' Leaving:'||l_proc, 90);
2831: raise;
2832: end delete_prev_job_extra_info;
2833: --
2834: -- -----------------------------------------------------------------------

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

2905: per_previous_job_usages.object_version_number%type;
2906: l_proc varchar2(72) := g_package||'create_prev_job_extra_info';
2907: --
2908: begin
2909: hr_utility.set_location('Entering:'|| l_proc, 10);
2910: --
2911: -- Issue a savepoint
2912: --
2913: savepoint create_previous_job_usage;

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

3140: --
3141: p_object_version_number := l_object_version_number;
3142: p_previous_job_usage_id := l_previous_job_usage_id;
3143: --
3144: hr_utility.set_location(' Leaving:'||l_proc, 70);
3145: exception
3146: when hr_api.validate_enabled then
3147: --
3148: -- As the Validate_Enabled exception has been raised

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

3155: -- when validation only mode is being used.)
3156: --
3157: p_previous_job_usage_id := null;
3158: p_object_version_number := null;
3159: hr_utility.set_location(' Leaving:'||l_proc, 80);
3160: when others then
3161: --
3162: -- A validation or unexpected error has occured
3163: --

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

3166: -- set in out parameters and set out parameters
3167: --
3168: p_previous_job_usage_id := null;
3169: p_object_version_number := null;
3170: hr_utility.set_location(' Leaving:'||l_proc, 90);
3171: raise;
3172: end create_previous_job_usage;
3173: --
3174: -- -----------------------------------------------------------------------

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

3244: per_previous_job_usages.object_version_number%type
3245: := p_object_version_number;
3246: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;
3247: begin
3248: hr_utility.set_location('Entering:'|| l_proc, 10);
3249: --
3250: -- Issue a savepoint
3251: --
3252: savepoint update_previous_job_usage;

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

3479: -- Set all output arguments
3480: --
3481: p_object_version_number := l_object_version_number;
3482: --
3483: hr_utility.set_location(' Leaving:'||l_proc, 70);
3484: exception
3485: when hr_api.validate_enabled then
3486: --
3487: -- As the Validate_Enabled exception has been raised

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

3491: --
3492: -- Only set output warning arguments
3493: -- (Any key or derived arguments must be set to null
3494: -- when validation only mode is being used.)
3495: hr_utility.set_location(' Leaving:'||l_proc, 80);
3496: when others then
3497: --
3498: -- A validation or unexpected error has occured
3499: --

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

3501: --
3502: -- set in out parameters and set out parameters
3503: --
3504: p_object_version_number := l_ovn;
3505: hr_utility.set_location(' Leaving:'||l_proc, 90);
3506: raise;
3507: end update_previous_job_usage;
3508: --
3509: -- -----------------------------------------------------------------------

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

3524: per_previous_job_usages.object_version_number%type
3525: := p_object_version_number;
3526: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;
3527: begin
3528: hr_utility.set_location('Entering:'|| l_proc, 10);
3529: --
3530: -- Issue a savepoint
3531: --
3532: savepoint delete_previous_job_usage;

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

3579: -- Set all output arguments
3580: --
3581: p_object_version_number := l_object_version_number;
3582: --
3583: hr_utility.set_location(' Leaving:'||l_proc, 70);
3584: --
3585: exception
3586: when hr_api.validate_enabled then
3587: --

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

3593: -- Only set output warning arguments
3594: -- (Any key or derived arguments must be set to null
3595: -- when validation only mode is being used.)
3596: --
3597: hr_utility.set_location(' Leaving:'||l_proc, 80);
3598: when others then
3599: --
3600: -- A validation or unexpected error has occured
3601: --

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

3603: --
3604: -- set in out parameters and set out parameters
3605: --
3606: p_object_version_number := l_ovn;
3607: hr_utility.set_location(' Leaving:'||l_proc, 90);
3608: raise;
3609: end delete_previous_job_usage;
3610: --
3611: end hr_previous_employment_api;