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

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

148: l_dummy_ovn number;
149: --
150: begin
151: --
152: hr_utility.set_location('Entering:'|| l_proc, 10);
153: --
154: -- Check for PLIP level eligibility
155: --
156: if p_pgm_id is not null

Line 267: hr_utility.set_location('Leaving - Defer'||l_proc,11);

263: g_pepinsplip.p_program_update_date := p_program_update_date;
264: g_pepinsplip.p_effective_date := p_effective_date;
265: g_pepinsplip.p_override_validation := p_override_validation;
266: --
267: hr_utility.set_location('Leaving - Defer'||l_proc,11);
268: return;
269: -- Check for deferred PLIP transactions
270: --
271: elsif p_pgm_id is not null

Line 556: hr_utility.set_location('Insert: '||l_proc, 5);

552: ben_pep_shd.g_api_dml := true; -- Set the api dml status
553: --
554: -- Insert the row into: ben_elig_per_f
555: --
556: hr_utility.set_location('Insert: '||l_proc, 5);
557: insert into ben_elig_per_f
558: (
559: elig_per_id,
560: effective_start_date,

Line 769: hr_utility.set_location('Dn Insert: '||l_proc, 5);

765: l_last_update_date,
766: l_last_updated_by,
767: l_last_update_login
768: ) RETURNING elig_per_id into l_elig_per_id;
769: hr_utility.set_location('Dn Insert: '||l_proc, 5);
770: --
771: -----------------------------------------------------------------------------
772: --Bug 12732878 changes start
773: --If the comp object is First Elig then inserting the elig_per_id of comp object into

Line 776: hr_utility.set_location('uxx l_elig_per_id '||l_elig_per_id,10);

772: --Bug 12732878 changes start
773: --If the comp object is First Elig then inserting the elig_per_id of comp object into
774: --global vaiables to check whether the same compensation object is having any future records
775: --in ben_elig_per_f table
776: hr_utility.set_location('uxx l_elig_per_id '||l_elig_per_id,10);
777: hr_utility.set_location('uxx p_per_in_ler_id '||p_per_in_ler_id,10);
778: ben_determine_eligibility2.g_cache_first_elig_object.extend;
779: ben_determine_eligibility2.g_cache_first_elig_object(ben_determine_eligibility2.g_cache_first_elig_object.last).rowno
780: := ben_determine_eligibility2.g_cache_first_elig_object.last;

Line 777: hr_utility.set_location('uxx p_per_in_ler_id '||p_per_in_ler_id,10);

773: --If the comp object is First Elig then inserting the elig_per_id of comp object into
774: --global vaiables to check whether the same compensation object is having any future records
775: --in ben_elig_per_f table
776: hr_utility.set_location('uxx l_elig_per_id '||l_elig_per_id,10);
777: hr_utility.set_location('uxx p_per_in_ler_id '||p_per_in_ler_id,10);
778: ben_determine_eligibility2.g_cache_first_elig_object.extend;
779: ben_determine_eligibility2.g_cache_first_elig_object(ben_determine_eligibility2.g_cache_first_elig_object.last).rowno
780: := ben_determine_eligibility2.g_cache_first_elig_object.last;
781: ben_determine_eligibility2.g_cache_first_elig_object(ben_determine_eligibility2.g_cache_first_elig_object.last).elig_per_id :=l_elig_per_id;

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

799: p_effective_start_date := l_effective_start_date;
800: p_effective_end_date := l_effective_end_date;
801: p_object_version_number := l_object_version_number;
802: --
803: hr_utility.set_location(' Leaving:'||l_proc, 70);
804: --
805: exception
806: --
807: when hr_api.validate_enabled then

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

818: p_elig_per_id := null;
819: p_effective_start_date := null;
820: p_effective_end_date := null;
821: p_object_version_number := null;
822: hr_utility.set_location(' Leaving:'||l_proc, 80);
823: --
824: when others then
825: --
826: -- A validation or unexpected error has occured

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

842: l_proc varchar2(72) := g_package||'convert_defs';
843: --
844: Begin
845: --
846: hr_utility.set_location('Entering:'||l_proc, 5);
847: --
848: -- We must now examine each argument value in the
849: -- p_rec plsql record structure
850: -- to see if a system default is being used. If a system default

Line 1243: hr_utility.set_location(' Leaving:'||l_proc, 10);

1239: p_rec.program_update_date :=
1240: ben_pep_shd.g_old_rec.program_update_date;
1241: End If;
1242: --
1243: hr_utility.set_location(' Leaving:'||l_proc, 10);
1244: --
1245: End convert_defs;
1246: --
1247: -- ----------------------------------------------------------------------------

Line 1403: hr_utility.set_location(l_proc, 15);

1399: then
1400: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1401: fnd_message.raise_error;
1402: End If;
1403: hr_utility.set_location(l_proc, 15);
1404: --
1405: -- Validate the datetrack mode mode getting the validation start
1406: -- and end dates for the specified datetrack operation.
1407: --

Line 1435: hr_utility.set_location(' Leaving:'||l_proc, 30);

1431: --
1432: p_validation_start_date := l_validation_start_date;
1433: p_validation_end_date := l_validation_end_date;
1434: --
1435: hr_utility.set_location(' Leaving:'||l_proc, 30);
1436: --
1437: Exception
1438: When HR_Api.Object_Locked then
1439: --

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

1753: l_dummy_ovn number;
1754: --
1755: begin
1756: --
1757: hr_utility.set_location('Entering:'|| l_proc, 10);
1758: --
1759: -- Issue a savepoint if operating in validation only mode
1760: --
1761: savepoint update_perf_Eligible_Person;

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

1759: -- Issue a savepoint if operating in validation only mode
1760: --
1761: savepoint update_perf_Eligible_Person;
1762: --
1763: hr_utility.set_location(l_proc, 20);
1764: --
1765: --bug#3974928 - to take care of wrong setup of track ineligible flag at plan
1766: --level and not at plip level
1767: if g_pepinsplip.p_pgm_id is not null

Line 2146: hr_utility.set_location(l_proc, 15);

2142: If (p_object_version_number <> ben_pep_shd.g_old_rec.object_version_number) Then
2143: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
2144: fnd_message.raise_error;
2145: End If;
2146: hr_utility.set_location(l_proc, 15);
2147: --
2148: -- Validate the datetrack mode mode getting the validation start
2149: -- and end dates for the specified datetrack operation.
2150: --

Line 2173: hr_utility.set_location(' Leaving:'||l_proc, 30);

2169: fnd_message.raise_error;
2170: --
2171: End If;
2172: --
2173: hr_utility.set_location(' Leaving:'||l_proc, 30);
2174: convert_defs(l_rec);
2175: --
2176: if ben_manage_life_events.g_modified_mode in ('S','U','D') then --ICM
2177: --compare values to decide whether to update or not

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

2267: end if;
2268: -- Call the supporting pre-update operation
2269:
2270: If (p_datetrack_mode <> 'CORRECTION') then
2271: hr_utility.set_location(l_proc, 10);
2272: --
2273: open c_getovn
2274: (c_pep_id => p_elig_per_id
2275: );

Line 2294: hr_utility.set_location(l_proc, 15);

2290: --
2291: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2292: --
2293: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
2294: hr_utility.set_location(l_proc, 15);
2295: --
2296: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
2297: -- delete any future rows
2298: --

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

2296: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
2297: -- delete any future rows
2298: --
2299: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
2300: hr_utility.set_location(l_proc, 10);
2301: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2302: --
2303: -- Delete the where the effective start date is equal
2304: -- to the validation end date.

Line 2312: hr_utility.set_location(l_proc, 15);

2308: and effective_start_date = l_validation_start_date;
2309: --
2310: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2311: Else
2312: hr_utility.set_location(l_proc, 15);
2313: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2314: --
2315: -- Delete the row(s) where the effective start date is greater than
2316: -- or equal to the validation start date.

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

2322: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
2323: End If;
2324: --
2325: End If;
2326: hr_utility.set_location(l_proc, 20);
2327: --
2328: -- We must now insert the updated row (insert_dml)
2329: --
2330: -- Get the object version number for the insert

Line 2338: hr_utility.set_location('Dn DTAPI_GOVN:'||l_proc, 5);

2334: );
2335: fetch c_getovn into l_rec.object_version_number;
2336: close c_getovn;
2337: --
2338: hr_utility.set_location('Dn DTAPI_GOVN:'||l_proc, 5);
2339: --
2340: -- Set the effective start and end dates to the corresponding
2341: -- validation start and end dates
2342: --

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

2346: -- If the datetrack_mode is not INSERT then we must populate the WHO
2347: -- columns with the 'old' creation values and 'new' updated values.
2348: --
2349: If (p_datetrack_mode <> 'INSERT') then
2350: hr_utility.set_location(l_proc, 10);
2351: --
2352: -- Select the 'old' created values
2353: --
2354: Open C_Sel1;

Line 2380: hr_utility.set_location('Ins PEP:'||l_proc, 5);

2376: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2377: --
2378: -- Insert the row into: ben_elig_per_f
2379: --
2380: hr_utility.set_location('Ins PEP:'||l_proc, 5);
2381: insert into ben_elig_per_f
2382: (
2383: elig_per_id,
2384: effective_start_date,

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

2602: --
2603: -- update_dml
2604: --
2605: If (p_datetrack_mode = 'CORRECTION') then
2606: hr_utility.set_location(l_proc, 10);
2607: --
2608: -- Because we are updating a row we must get the next object
2609: -- version number.
2610: --

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

2851: -- End of API User Hook for the after hook of update_Eligible_Person
2852: --
2853: end;
2854: --
2855: hr_utility.set_location(l_proc, 60);
2856: --
2857: -- When in validation only mode raise the Validate_Enabled exception
2858: --
2859: if p_validate then

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

2865: p_object_version_number := l_rec.object_version_number;
2866: p_effective_start_date := l_rec.effective_start_date;
2867: p_effective_end_date := l_rec.effective_end_date;
2868: --
2869: hr_utility.set_location(' Leaving:'||l_proc, 70);
2870: --
2871: exception
2872: --
2873: when hr_api.validate_enabled then

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

2880: -- Only set output warning arguments
2881: -- (Any key or derived arguments must be set to null
2882: -- when validation only mode is being used.)
2883: --
2884: hr_utility.set_location(' Leaving:'||l_proc, 80);
2885: --
2886: when others then
2887: --
2888: -- A validation or unexpected error has occured

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

3015: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
3016: --
3017: begin
3018: --
3019: hr_utility.set_location('Entering:'|| l_proc, 10);
3020: --
3021: -- Issue a savepoint if operating in validation only mode
3022: --
3023: savepoint create_perf_Elig_Person_Option;

Line 3067: hr_utility.set_location('Insert: '||l_proc, 5);

3063: Close C_Sel1;
3064: --
3065: -- Insert the row into: ben_elig_per_f
3066: --
3067: hr_utility.set_location('Insert: '||l_proc, 5);
3068: hr_utility.set_location('Ins EPO:'||l_proc, 5);
3069: insert into ben_elig_per_opt_f
3070: ( elig_per_opt_id,
3071: elig_per_id,

Line 3068: hr_utility.set_location('Ins EPO:'||l_proc, 5);

3064: --
3065: -- Insert the row into: ben_elig_per_f
3066: --
3067: hr_utility.set_location('Insert: '||l_proc, 5);
3068: hr_utility.set_location('Ins EPO:'||l_proc, 5);
3069: insert into ben_elig_per_opt_f
3070: ( elig_per_opt_id,
3071: elig_per_id,
3072: effective_start_date,

Line 3261: hr_utility.set_location('Dn Insert: '||l_proc, 5);

3257: l_last_update_date,
3258: l_last_updated_by,
3259: l_last_update_login
3260: );
3261: hr_utility.set_location('Dn Insert: '||l_proc, 5);
3262: --
3263: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
3264: --
3265: -- When in validation only mode raise the Validate_Enabled exception

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

3274: p_effective_start_date := l_effective_start_date;
3275: p_effective_end_date := l_effective_end_date;
3276: p_object_version_number := l_object_version_number;
3277: --
3278: hr_utility.set_location(' Leaving:'||l_proc, 70);
3279: --
3280: exception
3281: --
3282: when hr_api.validate_enabled then

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

3293: p_elig_per_opt_id := null;
3294: p_effective_start_date := null;
3295: p_effective_end_date := null;
3296: p_object_version_number := null;
3297: hr_utility.set_location(' Leaving:'||l_proc, 80);
3298: --
3299: when others then
3300: --
3301: -- A validation or unexpected error has occured

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

3305: p_elig_per_opt_id := null;
3306: p_effective_start_date := null;
3307: p_effective_end_date := null;
3308: p_object_version_number := null;
3309: hr_utility.set_location(' Leaving:'||l_proc, 80);
3310: --
3311: raise;
3312: --
3313: end create_perf_Elig_Person_Option;

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

3433: and p_effective_date
3434: between effective_start_date and effective_end_date;
3435: --
3436: Begin
3437: hr_utility.set_location('Entering:'||l_proc, 5);
3438: --
3439: -- Ensure that all the mandatory arguments are not null
3440: --
3441: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 3478: hr_utility.set_location(l_proc, 15);

3474: If (p_object_version_number <> ben_epo_shd.g_old_rec.object_version_number) Then
3475: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
3476: fnd_message.raise_error;
3477: End If;
3478: hr_utility.set_location(l_proc, 15);
3479: --
3480: --
3481: -- Validate the datetrack mode mode getting the validation start
3482: -- and end dates for the specified datetrack operation.

Line 3519: hr_utility.set_location(' Leaving:'||l_proc, 30);

3515: --
3516: p_validation_start_date := l_validation_start_date;
3517: p_validation_end_date := l_validation_end_date;
3518: --
3519: hr_utility.set_location(' Leaving:'||l_proc, 30);
3520: --
3521: -- We need to trap the ORA LOCK exception
3522: --
3523: Exception

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

3549: l_proc varchar2(72) := g_package||'epo_convert_defs';
3550: --
3551: Begin
3552: --
3553: hr_utility.set_location('Entering:'||l_proc, 5);
3554: --
3555: -- We must now examine each argument value in the
3556: -- p_rec plsql record structure
3557: -- to see if a system default is being used. If a system default

Line 3904: hr_utility.set_location(' Leaving:'||l_proc, 10);

3900: ben_epo_shd.g_old_rec.program_update_date;
3901: End If;
3902:
3903: --
3904: hr_utility.set_location(' Leaving:'||l_proc, 10);
3905: --
3906: End epo_convert_defs;
3907: -- ----------------------------------------------------------------------------
3908: -- |----------------------------< dt_pre_update >-----------------------------|

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

3920: l_proc varchar2(72) := g_package||'dt_pre_update';
3921: l_dummy_version_number number;
3922: --
3923: Begin
3924: hr_utility.set_location('Entering:'||l_proc, 5);
3925: If (p_datetrack_mode <> 'CORRECTION') then
3926: hr_utility.set_location(l_proc, 10);
3927: --
3928: -- Update the current effective end date

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

3922: --
3923: Begin
3924: hr_utility.set_location('Entering:'||l_proc, 5);
3925: If (p_datetrack_mode <> 'CORRECTION') then
3926: hr_utility.set_location(l_proc, 10);
3927: --
3928: -- Update the current effective end date
3929: --
3930: ben_epo_shd.upd_effective_end_date

Line 3939: hr_utility.set_location(l_proc, 15);

3935: p_validation_end_date => p_validation_end_date,
3936: p_object_version_number => l_dummy_version_number);
3937: --
3938: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
3939: hr_utility.set_location(l_proc, 15);
3940: --
3941: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
3942: -- delete any future rows
3943: --

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

3947: p_datetrack_mode => p_datetrack_mode,
3948: p_validation_start_date => p_validation_start_date,
3949: p_validation_end_date => p_validation_end_date);
3950: End If;
3951: hr_utility.set_location(l_proc, 20);
3952: --
3953: -- We must now insert the updated row
3954: --
3955: ben_epo_ins.insert_dml

Line 3962: hr_utility.set_location(' Leaving:'||l_proc, 20);

3958: p_datetrack_mode => p_datetrack_mode,
3959: p_validation_start_date => p_validation_start_date,
3960: p_validation_end_date => p_validation_end_date);
3961: End If;
3962: hr_utility.set_location(' Leaving:'||l_proc, 20);
3963: End dt_pre_update;
3964: --
3965: -- ----------------------------------------------------------------------------
3966: -- |------------------------------< pre_update >------------------------------|

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

3976: --
3977: l_proc varchar2(72) := g_package||'pre_update';
3978: --
3979: Begin
3980: hr_utility.set_location('Entering:'||l_proc, 5);
3981: --
3982: --
3983: --
3984: dt_pre_update

Line 3991: hr_utility.set_location(' Leaving:'||l_proc, 10);

3987: p_datetrack_mode => p_datetrack_mode,
3988: p_validation_start_date => p_validation_start_date,
3989: p_validation_end_date => p_validation_end_date);
3990: --
3991: hr_utility.set_location(' Leaving:'||l_proc, 10);
3992: End pre_update;
3993: -- ----------------------------------------------------------------------------
3994: -- |----------------------------< dt_update_dml >-----------------------------|
3995: -- ----------------------------------------------------------------------------

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

4005: --
4006: l_proc varchar2(72) := g_package||'dt_update_dml';
4007: --
4008: Begin
4009: hr_utility.set_location('Entering:'||l_proc, 5);
4010: --
4011: If (p_datetrack_mode = 'CORRECTION') then
4012: hr_utility.set_location(l_proc, 10);
4013: --

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

4008: Begin
4009: hr_utility.set_location('Entering:'||l_proc, 5);
4010: --
4011: If (p_datetrack_mode = 'CORRECTION') then
4012: hr_utility.set_location(l_proc, 10);
4013: --
4014: -- Because we are updating a row we must get the next object
4015: -- version number.
4016: --

Line 4128: hr_utility.set_location(' Leaving:'||l_proc, 15);

4124: p_rec.effective_start_date := p_validation_start_date;
4125: p_rec.effective_end_date := p_validation_end_date;
4126: End If;
4127: --
4128: hr_utility.set_location(' Leaving:'||l_proc, 15);
4129: Exception
4130: When hr_api.check_integrity_violated Then
4131: -- A check constraint has been violated
4132: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

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

4157: --
4158: l_proc varchar2(72) := g_package||'update_dml';
4159: --
4160: Begin
4161: hr_utility.set_location('Entering:'||l_proc, 5);
4162: --
4163: dt_update_dml(p_rec => p_rec,
4164: p_effective_date => p_effective_date,
4165: p_datetrack_mode => p_datetrack_mode,

Line 4169: hr_utility.set_location(' Leaving:'||l_proc, 10);

4165: p_datetrack_mode => p_datetrack_mode,
4166: p_validation_start_date => p_validation_start_date,
4167: p_validation_end_date => p_validation_end_date);
4168: --
4169: hr_utility.set_location(' Leaving:'||l_proc, 10);
4170: End update_dml;
4171: --
4172: -- ----------------------------------------------------------------------------
4173: -- |---------------------------------< upd >----------------------------------|

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

4183: l_validation_start_date date;
4184: l_validation_end_date date;
4185: --
4186: Begin
4187: hr_utility.set_location('Entering:'||l_proc, 5);
4188: --
4189: -- We must lock the row which we need to update.
4190: --
4191: lck

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

4393: l_rec ben_epo_shd.g_rec_type;
4394: l_proc varchar2(72) := g_package||'upd';
4395: --
4396: Begin
4397: hr_utility.set_location('Entering:'||l_proc, 5);
4398: --
4399: -- Call conversion function to turn arguments into the
4400: -- l_rec structure.
4401: --

Line 4506: hr_utility.set_location(' Leaving:'||l_proc, 10);

4502: p_effective_start_date := l_rec.effective_start_date;
4503: p_effective_end_date := l_rec.effective_end_date;
4504: --
4505: --
4506: hr_utility.set_location(' Leaving:'||l_proc, 10);
4507: End upd;
4508: --
4509: procedure update_perf_Elig_Person_Option
4510: (p_validate in boolean default false

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

4609: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
4610: --
4611: begin
4612: --
4613: hr_utility.set_location('Entering:'|| l_proc, 10);
4614: --
4615: -- Issue a savepoint if operating in validation only mode
4616: --
4617: savepoint update_perf_Elig_Person_Option;

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

4939: p_object_version_number := l_object_version_number;
4940: p_effective_start_date := l_effective_start_date;
4941: p_effective_end_date := l_effective_end_date;
4942: --
4943: hr_utility.set_location(' Leaving:'||l_proc, 70);
4944: --
4945: exception
4946: --
4947: when hr_api.validate_enabled then

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

4954: -- Only set output warning arguments
4955: -- (Any key or derived arguments must be set to null
4956: -- when validation only mode is being used.)
4957: --
4958: hr_utility.set_location(' Leaving:'||l_proc, 80);
4959: --
4960: when others then
4961: --
4962: -- A validation or unexpected error has occured