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_ASSIGNMENT_API dependencies on HR_UTILITY

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

272: -- End of bug 1925131
273: --
274: l_entries_changed varchar2(200) := null;
275: begin
276: hr_utility.set_location('Entering:'|| l_proc, 5);
277: --
278: -- Issue a savepoint.
279: --
280: -- Truncate the parameter p_effective_date and p_date_probation_end

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

297: -- End of API User Hook for the before hook of create_secondary_emp_asg
298: --
299: end;
300: --
301: hr_utility.set_location(l_proc, 10);
302: --
303: -- Validation in addition to Table Handlers
304: --
305: -- Get person details.

Line 331: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');

327: if csr_get_derived_details%NOTFOUND then
328: --
329: close csr_get_derived_details;
330: --
331: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
332: hr_utility.raise_error;
333: --
334: end if;
335: close csr_get_derived_details;

Line 332: hr_utility.raise_error;

328: --
329: close csr_get_derived_details;
330: --
331: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
332: hr_utility.raise_error;
333: --
334: end if;
335: close csr_get_derived_details;
336: --- check for whther the Business group allows

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

336: --- check for whther the Business group allows
337: --- creation of benefits assignments
338: ---
339: if not check__benasg_allow(l_business_group_id) then
340: hr_utility.set_location('Leaving:'|| l_proc, 999);
341: return ;
342: end if ;
343: hr_utility.set_location(l_proc, 20);
344:

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

339: if not check__benasg_allow(l_business_group_id) then
340: hr_utility.set_location('Leaving:'|| l_proc, 999);
341: return ;
342: end if ;
343: hr_utility.set_location(l_proc, 20);
344:
345: --
346: -- Remove this edit as it is not relevant for reduction of hours.
347: --

Line 366: hr_utility.set_message(805,'BEN_92114_ACTEMPASGEXISTS');

362: --
363: -- A benefit assignment cannot be created for a person with an
364: -- active employee assignment
365: --
366: hr_utility.set_message(805,'BEN_92114_ACTEMPASGEXISTS');
367: hr_utility.raise_error;
368: --
369: end if;
370: close csr_getactempasg;

Line 367: hr_utility.raise_error;

363: -- A benefit assignment cannot be created for a person with an
364: -- active employee assignment
365: --
366: hr_utility.set_message(805,'BEN_92114_ACTEMPASGEXISTS');
367: hr_utility.raise_error;
368: --
369: end if;
370: close csr_getactempasg;
371: hr_utility.set_location(l_proc, 25);

Line 371: hr_utility.set_location(l_proc, 25);

367: hr_utility.raise_error;
368: --
369: end if;
370: close csr_getactempasg;
371: hr_utility.set_location(l_proc, 25);
372: --
373: end if; */
374: --
375: -- Default the payroll from the business group

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

373: end if; */
374: --
375: -- Default the payroll from the business group
376: --
377: hr_utility.set_location(l_proc, 35);
378: --
379: -- Get the default payroll
380: --
381: open c_getdefmthpaydets

Line 390: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');

386: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and
387: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then --Bug 1539414
388: close c_getdefmthpaydets;
389: --
390: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');
391: hr_utility.raise_error;
392: --
393: end if;
394: close c_getdefmthpaydets;

Line 391: hr_utility.raise_error;

387: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then --Bug 1539414
388: close c_getdefmthpaydets;
389: --
390: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');
391: hr_utility.raise_error;
392: --
393: end if;
394: close c_getdefmthpaydets;
395:

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

392: --
393: end if;
394: close c_getdefmthpaydets;
395:
396: hr_utility.set_location(l_proc, 45);
397: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);
398: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);
399: --
400: -- Check if existing payroll is set

Line 397: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);

393: end if;
394: close c_getdefmthpaydets;
395:
396: hr_utility.set_location(l_proc, 45);
397: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);
398: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);
399: --
400: -- Check if existing payroll is set
401: --

Line 398: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);

394: close c_getdefmthpaydets;
395:
396: hr_utility.set_location(l_proc, 45);
397: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);
398: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);
399: --
400: -- Check if existing payroll is set
401: --
402: if p_payroll_id is not null then

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

497: -- Create the benefits assignment
498: --
499: l_assignment_number := null;
500: --
501: hr_utility.set_location(l_proc, 40);
502:
503: --
504: -- Call per_asg_ins.ins when p_called_from = 'FORM', (called from BENEBNAS.pld)
505: -- to create benefits assignment with HR api validations.

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

680: ,p_object_version_number => l_object_version_number
681: ,p_hourly_salaried_warning => l_boolean_dummy2
682: );
683: end if;
684: hr_utility.set_location(l_proc, 50);
685: --
686: -- Bug 5355232
687: --
688: hr_utility.set_location('ACE : Before : hrentmnt.adjust_entries_asg_criteria', 9999);

Line 688: hr_utility.set_location('ACE : Before : hrentmnt.adjust_entries_asg_criteria', 9999);

684: hr_utility.set_location(l_proc, 50);
685: --
686: -- Bug 5355232
687: --
688: hr_utility.set_location('ACE : Before : hrentmnt.adjust_entries_asg_criteria', 9999);
689: --
690: begin
691: --
692: hrentmnt.maintain_entries_asg

Line 715: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);

711: exception
712: --
713: when others then
714: --
715: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
716: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
717: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
718: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
719: --

Line 716: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);

712: --
713: when others then
714: --
715: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
716: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
717: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
718: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
719: --
720: raise;

Line 717: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);

713: when others then
714: --
715: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
716: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
717: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
718: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
719: --
720: raise;
721: --

Line 718: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);

714: --
715: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
716: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
717: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
718: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
719: --
720: raise;
721: --
722: end;

Line 724: hr_utility.set_location('ACE : After : hrentmnt.adjust_entries_asg_criteria', 9999);

720: raise;
721: --
722: end;
723: --
724: hr_utility.set_location('ACE : After : hrentmnt.adjust_entries_asg_criteria', 9999);
725: --
726: --
727: -- Bug 5355232
728: --

Line 732: hr_utility.set_location('p_called_from '||p_called_from, 9999);

728: --
729: --
730: -- Create the assignment extra info for the assignment
731: --
732: hr_utility.set_location('p_called_from '||p_called_from, 9999);
733:
734: /* Added for Bug 7597322 */
735: if(p_called_from is null ) then
736: open c_ptyp_id;

Line 739: hr_utility.set_location('l_org_ptyp_id '||l_org_ptyp_id, 9999);

735: if(p_called_from is null ) then
736: open c_ptyp_id;
737: fetch c_ptyp_id into l_org_ptyp_id;
738: close c_ptyp_id;
739: hr_utility.set_location('l_org_ptyp_id '||l_org_ptyp_id, 9999);
740: end if;
741: /* Ended for Bug 7597322 */
742:
743: hr_assignment_extra_info_api.create_assignment_extra_info

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

762: --
763: ,p_assignment_extra_info_id => l_aei_id
764: ,p_object_version_number => l_aei_ovn
765: );
766: hr_utility.set_location(l_proc, 60);
767: begin
768: null;
769: exception
770: when hr_api.cannot_find_prog_unit then

Line 795: hr_utility.set_location(' Leaving:'||l_proc, 50);

791: p_effective_end_date := l_asg_eed;
792: p_assignment_extra_info_id := l_aei_id;
793: p_aei_object_version_number := l_aei_ovn;
794: --
795: hr_utility.set_location(' Leaving:'||l_proc, 50);
796: exception
797: when hr_api.validate_enabled then
798: --
799: -- As the Validate_Enabled exception has been raised

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

1001: where ori.organization_id = c_bgp_id
1002: and ori.ORG_INFORMATION_CONTEXT = 'Benefits Defaults';
1003: l_mthpayroll_id number := null;
1004: begin
1005: hr_utility.set_location('Entering:'|| l_proc, 10);
1006: hr_utility.set_location('OVN:'||p_object_version_number||' '||l_proc, 10);
1007: --
1008: -- Truncate date and date_probation_end values, effectively removing time element.
1009: --

Line 1006: hr_utility.set_location('OVN:'||p_object_version_number||' '||l_proc, 10);

1002: and ori.ORG_INFORMATION_CONTEXT = 'Benefits Defaults';
1003: l_mthpayroll_id number := null;
1004: begin
1005: hr_utility.set_location('Entering:'|| l_proc, 10);
1006: hr_utility.set_location('OVN:'||p_object_version_number||' '||l_proc, 10);
1007: --
1008: -- Truncate date and date_probation_end values, effectively removing time element.
1009: --
1010: l_effective_date := trunc(p_effective_date);

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

1015: -- Issue a savepoint.
1016: --
1017: savepoint update_ben_asg;
1018: --
1019: hr_utility.set_location(l_proc, 20);
1020: --
1021: -- Validation in addition to Table Handlers
1022: --
1023: -- Get assignment type.

Line 1034: hr_utility.set_location('ASG ID: '||p_assignment_id||' '||l_proc, 25);

1030: hr_api.mandatory_arg_error
1031: (p_api_name => l_proc
1032: ,p_argument => 'effective_date'
1033: ,p_argument_value => l_effective_date);
1034: hr_utility.set_location('ASG ID: '||p_assignment_id||' '||l_proc, 25);
1035: hr_utility.set_location('ESD: '||l_effective_date||' '||l_proc, 25);
1036: --
1037: -- Get assignment details
1038: --

Line 1035: hr_utility.set_location('ESD: '||l_effective_date||' '||l_proc, 25);

1031: (p_api_name => l_proc
1032: ,p_argument => 'effective_date'
1033: ,p_argument_value => l_effective_date);
1034: hr_utility.set_location('ASG ID: '||p_assignment_id||' '||l_proc, 25);
1035: hr_utility.set_location('ESD: '||l_effective_date||' '||l_proc, 25);
1036: --
1037: -- Get assignment details
1038: --
1039: open csr_get_asg_dets

Line 1056: hr_utility.set_message(805,'BEN_????_BENASGNOTEXISTS ');

1052: -- Temporary - BEN_????_BENASGNOTEXISTS
1053: --
1054: -- - The benefit assignment cannot be modified because it does not exist
1055: --
1056: hr_utility.set_message(805,'BEN_????_BENASGNOTEXISTS ');
1057: hr_utility.raise_error;
1058: --
1059: end if;
1060: close csr_get_asg_dets;

Line 1057: hr_utility.raise_error;

1053: --
1054: -- - The benefit assignment cannot be modified because it does not exist
1055: --
1056: hr_utility.set_message(805,'BEN_????_BENASGNOTEXISTS ');
1057: hr_utility.raise_error;
1058: --
1059: end if;
1060: close csr_get_asg_dets;
1061: hr_utility.set_location(l_proc, 20);

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

1057: hr_utility.raise_error;
1058: --
1059: end if;
1060: close csr_get_asg_dets;
1061: hr_utility.set_location(l_proc, 20);
1062: --- check for whether the Business group allows
1063: --- creation of benefits assignments
1064: ---
1065: if not check__benasg_allow(l_business_group_id) then

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

1062: --- check for whether the Business group allows
1063: --- creation of benefits assignments
1064: ---
1065: if not check__benasg_allow(l_business_group_id) then
1066: hr_utility.set_location('Leaving:'|| l_proc, 999);
1067: return ;
1068: end if ;
1069:
1070: --

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

1077: l_assignment_extra_info_ovn,
1078: l_aei_origpayroll_id;
1079: --
1080: close csr_get_aei_dets;
1081: hr_utility.set_location(l_proc, 30);
1082: --
1083: -- Check for a assignment type of B
1084: --
1085: if l_assignment_type <> 'B'

Line 1092: hr_utility.set_message(805,'BEN_????_NOTBENASG');

1088: -- Temporary - BEN_????_NOTBENASG
1089: --
1090: -- - The assignment being modified should be a benefits assignment.
1091: --
1092: hr_utility.set_message(805,'BEN_????_NOTBENASG');
1093: hr_utility.raise_error;
1094: --
1095: end if;
1096: --

Line 1093: hr_utility.raise_error;

1089: --
1090: -- - The assignment being modified should be a benefits assignment.
1091: --
1092: hr_utility.set_message(805,'BEN_????_NOTBENASG');
1093: hr_utility.raise_error;
1094: --
1095: end if;
1096: --
1097: -- Update assignment.

Line 1213: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');

1209: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and
1210: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then -- Bug 1539414
1211: close c_getdefmthpaydets;
1212: --
1213: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');
1214: hr_utility.raise_error;
1215: --
1216: end if;
1217: close c_getdefmthpaydets;

Line 1214: hr_utility.raise_error;

1210: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then -- Bug 1539414
1211: close c_getdefmthpaydets;
1212: --
1213: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');
1214: hr_utility.raise_error;
1215: --
1216: end if;
1217: close c_getdefmthpaydets;
1218: hr_utility.set_location(l_proc, 45);

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

1214: hr_utility.raise_error;
1215: --
1216: end if;
1217: close c_getdefmthpaydets;
1218: hr_utility.set_location(l_proc, 45);
1219: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);
1220: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);
1221: --
1222: -- Check if existing payroll is set

Line 1219: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);

1215: --
1216: end if;
1217: close c_getdefmthpaydets;
1218: hr_utility.set_location(l_proc, 45);
1219: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);
1220: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);
1221: --
1222: -- Check if existing payroll is set
1223: if p_payroll_id is not null then

Line 1220: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);

1216: end if;
1217: close c_getdefmthpaydets;
1218: hr_utility.set_location(l_proc, 45);
1219: hr_utility.set_location('p_payroll_id: '||p_payroll_id||' '||l_proc, 45);
1220: hr_utility.set_location('l_mthpayroll_id: '||l_mthpayroll_id||' '||l_proc, 45);
1221: --
1222: -- Check if existing payroll is set
1223: if p_payroll_id is not null then
1224: if p_payroll_id <> l_mthpayroll_id then

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

1322: ,p_validate => FALSE
1323: ,p_hourly_salaried_warning => l_boolean_dummy2
1324: );
1325: end if;
1326: hr_utility.set_location(l_proc, 30);
1327: --
1328: -- Bug 5355232
1329: --
1330: hr_utility.set_location('ACE : Before : hrentmnt.adjust_entries_asg_criteria', 9999);

Line 1330: hr_utility.set_location('ACE : Before : hrentmnt.adjust_entries_asg_criteria', 9999);

1326: hr_utility.set_location(l_proc, 30);
1327: --
1328: -- Bug 5355232
1329: --
1330: hr_utility.set_location('ACE : Before : hrentmnt.adjust_entries_asg_criteria', 9999);
1331: --
1332: begin
1333: --
1334: hrentmnt.maintain_entries_asg

Line 1357: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);

1353: exception
1354: --
1355: when others then
1356: --
1357: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
1358: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
1359: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
1360: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
1361: --

Line 1358: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);

1354: --
1355: when others then
1356: --
1357: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
1358: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
1359: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
1360: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
1361: --
1362: raise;

Line 1359: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);

1355: when others then
1356: --
1357: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
1358: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
1359: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
1360: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
1361: --
1362: raise;
1363: --

Line 1360: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);

1356: --
1357: hr_utility.set_location('EXC : ' || substr(SQLERRM, 1, 50), 9999);
1358: hr_utility.set_location('EXC : ' || substr(SQLERRM, 51, 100), 9999);
1359: hr_utility.set_location('EXC : ' || substr(SQLERRM, 101, 150), 9999);
1360: hr_utility.set_location('EXC : ' || substr(SQLERRM, 151, 200), 9999);
1361: --
1362: raise;
1363: --
1364: end;

Line 1366: hr_utility.set_location('ACE : After : hrentmnt.adjust_entries_asg_criteria', 9999);

1362: raise;
1363: --
1364: end;
1365: --
1366: hr_utility.set_location('ACE : After : hrentmnt.adjust_entries_asg_criteria', 9999);
1367: --
1368: --
1369: -- Bug 5355232
1370: --

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

1374: /*
1375: if l_payroll_id_updated
1376: then
1377: --
1378: hr_utility.set_location(l_proc, 50);
1379: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1380: --
1381: -- Check if the original payroll is already set
1382: --

Line 1379: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);

1375: if l_payroll_id_updated
1376: then
1377: --
1378: hr_utility.set_location(l_proc, 50);
1379: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1380: --
1381: -- Check if the original payroll is already set
1382: --
1383: if l_aei_origpayroll_id is null then

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

1393: end if;
1394: --
1395: else
1396: --
1397: hr_utility.set_location(l_proc, 60);
1398: --
1399: -- Unchanged
1400: --
1401: l_orig_payroll_id := hr_api.g_varchar2;

Line 1416: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);

1412: -- p_adjusted_service_date, p_original_hire_date, p_termination_date
1413: -- p_leave_of_absence_date are defaulted to dates, when they are defaulted
1414: -- they have to go as hr_api.g_varchar2.
1415: --
1416: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1417: if p_age = hr_api.g_number then
1418: --
1419: l_char_age := hr_api.g_varchar2;
1420: --

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

1492: ,p_aei_information12 => p_absence_reason
1493: ,p_aei_information13 => l_char_date_of_hire -- fnd_date.date_to_canonical(p_date_of_hire)
1494: ,p_aei_information14 => p_original_person_type_id -- Bug:7562768, store the person_type_id in addition to system_person_type
1495: );
1496: hr_utility.set_location(l_proc, 70);
1497: --
1498: -- When in validation only mode raise the Validate_Enabled exception
1499: --
1500: if p_validate then

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

1506: p_object_version_number := l_object_version_number;
1507: p_effective_start_date := l_effective_start_date;
1508: p_effective_end_date := l_effective_end_date;
1509: --
1510: hr_utility.set_location(' Leaving:'||l_proc, 30);
1511: exception
1512: when hr_api.validate_enabled then
1513: --
1514: -- As the Validate_Enabled exception has been raised

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

1611: l_ovn number;
1612: --
1613: begin
1614: --
1615: hr_utility.set_location('Entering:'|| l_proc, 10);
1616: begin
1617: select asg.business_group_id
1618: into l_business_group_id
1619: from per_all_assignments_f asg

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

1633: /*
1634: -- This restrict to delete the asg which is created
1635: -- whne the prfile allows to create the asg
1636: if not check__benasg_allow(l_business_group_id) then
1637: hr_utility.set_location('Leaving:'|| l_proc, 999);
1638: return ;
1639: end if ;
1640: */
1641: --

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

1642: -- Issue a savepoint if operating in validation only mode
1643: --
1644: savepoint delete_ben_asg;
1645: --
1646: hr_utility.set_location(l_proc, 20);
1647: --
1648: -- Check the datetrack mode
1649: --
1650: if p_datetrack_mode = hr_api.g_zap then

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

1810: end loop;
1811: --
1812: end if;
1813: --
1814: hr_utility.set_location(l_proc, 30);
1815: --
1816: l_object_version_number := p_object_version_number;
1817: --
1818: per_asg_del.del

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

1829: ,p_validation_end_date => l_validation_end_date
1830: ,p_org_now_no_manager_warning => l_dummy_warning
1831: );
1832: --
1833: hr_utility.set_location(l_proc, 60);
1834: --
1835: -- When in validation only mode raise the Validate_Enabled exception
1836: --
1837: if p_validate then

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

1843: p_effective_start_date := l_effective_start_date;
1844: p_effective_end_date := l_effective_end_date;
1845: p_object_version_number := l_object_version_number;
1846: --
1847: hr_utility.set_location(' Leaving:'||l_proc, 70);
1848: --
1849: exception
1850: --
1851: when hr_api.validate_enabled then