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

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

117:
118: --
119: begin
120: --
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
123: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
124: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
125:

Line 122: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);

118: --
119: begin
120: --
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
123: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
124: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
125:
126: --

Line 123: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);

119: begin
120: --
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
123: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
124: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
125:
126: --
127: -- Issue a savepoint if operating in validation only mode

Line 124: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);

120: --
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
123: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
124: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
125:
126: --
127: -- Issue a savepoint if operating in validation only mode
128: --

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

127: -- Issue a savepoint if operating in validation only mode
128: --
129: savepoint create_Benefit_Prvdd_Ledger;
130: --
131: hr_utility.set_location(l_proc, 20);
132: --
133: -- Process Logic
134: --
135: -- if dummy flex credit result id is passed as null then go get it.

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

506: -- End of API User Hook for the after hook of create_Benefit_Prvdd_Ledger
507: --
508: end;
509: --
510: hr_utility.set_location(l_proc, 60);
511: --
512: -- When in validation only mode raise the Validate_Enabled exception
513: --
514: if p_validate then

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

521: p_effective_start_date := l_effective_start_date;
522: p_effective_end_date := l_effective_end_date;
523: p_object_version_number := l_object_version_number;
524: --
525: hr_utility.set_location(' Leaving:'||l_proc, 70);
526: --
527: exception
528: --
529: when hr_api.validate_enabled then

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

540: p_bnft_prvdd_ldgr_id := null;
541: p_effective_start_date := null;
542: p_effective_end_date := null;
543: p_object_version_number := null;
544: hr_utility.set_location(' Leaving:'||l_proc, 80);
545: --
546: when others then
547: --
548: -- A validation or unexpected error has occured

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

551: p_bnft_prvdd_ldgr_id := null;
552: p_effective_start_date := null;
553: p_effective_end_date := null;
554: p_object_version_number := null;
555: hr_utility.set_location(' Leaving:'||l_proc, 90);
556: raise;
557: --
558: end create_Benefit_Prvdd_Ledger;
559: --

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

608: l_proc varchar2(72) := g_package||'create_Benefit_Prvdd_Ledger_w';
609: --
610: begin
611: --
612: hr_utility.set_location('Entering:'|| l_proc, 10);
613: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
614: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
615: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
616: --

Line 613: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);

609: --
610: begin
611: --
612: hr_utility.set_location('Entering:'|| l_proc, 10);
613: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
614: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
615: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
616: --
617: hr_utility.set_location(l_proc, 20);

Line 614: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);

610: begin
611: --
612: hr_utility.set_location('Entering:'|| l_proc, 10);
613: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
614: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
615: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
616: --
617: hr_utility.set_location(l_proc, 20);
618: --

Line 615: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);

611: --
612: hr_utility.set_location('Entering:'|| l_proc, 10);
613: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
614: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
615: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
616: --
617: hr_utility.set_location(l_proc, 20);
618: --
619: if upper(p_validate) = 'TRUE'

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

613: hr_utility.set_location('p_acty_base_rt_id:'||to_char(p_acty_base_rt_id), 11);
614: hr_utility.set_location('p_person_id:'||to_char(p_person_id), 11);
615: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 11);
616: --
617: hr_utility.set_location(l_proc, 20);
618: --
619: if upper(p_validate) = 'TRUE'
620: then
621: l_validate := TRUE;

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

622: else
623: l_validate := FALSE;
624: end if;
625: --
626: hr_utility.set_location(l_proc, 30);
627: --
628: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger
629: (
630: p_validate => l_validate

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

661: p_ann_used_val => p_ann_used_val,
662: p_ann_cash_recd_val => p_ann_cash_recd_val
663: );
664: --
665: hr_utility.set_location(l_proc, 40);
666: --
667: -- Set all output arguments
668: --
669: p_bnft_prvdd_ldgr_id := l_bnft_prvdd_ldgr_id;

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

670: p_effective_start_date := l_effective_start_date;
671: p_effective_end_date := l_effective_end_date;
672: p_object_version_number := l_object_version_number;
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 50);
675: --
676: exception
677: --
678: when others then

Line 683: hr_utility.set_location(' Leaving:'||l_proc, 60);

679: p_bnft_prvdd_ldgr_id := null;
680: p_effective_start_date := null;
681: p_effective_end_date := null;
682: p_object_version_number := null;
683: hr_utility.set_location(' Leaving:'||l_proc, 60);
684: fnd_msg_pub.add;
685: --
686: end create_Benefit_Prvdd_Ledger_w;
687: --

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

820: l_bnft_prvdd_ldgr_updated boolean := FALSE;
821:
822: begin
823: --
824: hr_utility.set_location('Entering:'|| l_proc, 10);
825:
826: -- Issue a savepoint if operating in validation only mode
827: savepoint update_Benefit_Prvdd_Ledger;
828:

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

825:
826: -- Issue a savepoint if operating in validation only mode
827: savepoint update_Benefit_Prvdd_Ledger;
828:
829: hr_utility.set_location(l_proc, 20);
830:
831: -- Process Logic
832: l_object_version_number := p_object_version_number;
833:

Line 883: hr_utility.set_location('p_bnft_prvdd_ldgr_id :'||p_bnft_prvdd_ldgr_id, 20);

879: -- If create_rollover_enrollment calls update_Benefit_Prvdd_Ledger internally,
880: -- then fetch the new object_version_number.
881: -- If the bnft_prvdd_ldgr row is updated, then avoid calling the ben_bpl_upd.upd.
882: --
883: hr_utility.set_location('p_bnft_prvdd_ldgr_id :'||p_bnft_prvdd_ldgr_id, 20);
884: open c1;
885: fetch c1 into l_dup_object_version_number;
886: close c1;
887: --

Line 888: hr_utility.set_location('l_dup_object_version_number :'||l_dup_object_version_number, 20);

884: open c1;
885: fetch c1 into l_dup_object_version_number;
886: close c1;
887: --
888: hr_utility.set_location('l_dup_object_version_number :'||l_dup_object_version_number, 20);
889: --
890: -- bug 10649653. Only call update the ledger if it is found.
891: --
892: if (l_dup_object_version_number IS NOT NULL

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

1168: end;
1169: --
1170: end if; -- Bug: 3611160/4169180.
1171: --
1172: hr_utility.set_location(l_proc, 60);
1173: --
1174: -- When in validation only mode raise the Validate_Enabled exception
1175: --
1176: if p_validate then

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

1182: p_object_version_number := l_object_version_number;
1183: p_effective_start_date := l_effective_start_date;
1184: p_effective_end_date := l_effective_end_date;
1185: --
1186: hr_utility.set_location(' Leaving:'||l_proc, 70);
1187: --
1188: exception
1189: --
1190: when hr_api.validate_enabled then

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

1197: -- Only set output warning arguments
1198: -- (Any key or derived arguments must be set to null
1199: -- when validation only mode is being used.)
1200: --
1201: hr_utility.set_location(' Leaving:'||l_proc, 80);
1202: --
1203: when others then
1204: --
1205: -- A validation or unexpected error has occured

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

1206: --
1207: ROLLBACK TO update_Benefit_Prvdd_Ledger;
1208: p_effective_start_date := null;
1209: p_effective_end_date := null;
1210: hr_utility.set_location(' Leaving:'||l_proc, 90);
1211: raise;
1212: --
1213: end update_Benefit_Prvdd_Ledger;
1214: --

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

1261: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger_w';
1262: --
1263: begin
1264: --
1265: hr_utility.set_location('Entering:'|| l_proc, 10);
1266: --
1267: l_object_version_number := p_object_version_number;
1268: --
1269: if upper(p_validate) = 'TRUE'

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

1272: else
1273: l_validate := FALSE;
1274: end if;
1275: --
1276: hr_utility.set_location(l_proc, 20);
1277: --
1278: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger
1279: (
1280: p_validate => l_validate

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

1310: p_ann_used_val => p_ann_used_val,
1311: p_ann_cash_recd_val => p_ann_cash_recd_val
1312: );
1313: --
1314: hr_utility.set_location(l_proc, 30);
1315: --
1316: -- Set all output arguments
1317: --
1318: p_object_version_number := l_object_version_number;

Line 1322: hr_utility.set_location(' Leaving:'||l_proc, 40);

1318: p_object_version_number := l_object_version_number;
1319: p_effective_start_date := l_effective_start_date;
1320: p_effective_end_date := l_effective_end_date;
1321: --
1322: hr_utility.set_location(' Leaving:'||l_proc, 40);
1323: --
1324: exception
1325: --
1326: when others then

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

1325: --
1326: when others then
1327: p_effective_start_date := null;
1328: p_effective_end_date := null;
1329: hr_utility.set_location(' Leaving:'||l_proc, 50);
1330: fnd_msg_pub.add;
1331: --
1332: end update_Benefit_Prvdd_Ledger_w;
1333: --

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

1403: --
1404: l_curr_pil_id NUMBER;
1405: begin
1406: --
1407: hr_utility.set_location('Entering:'|| l_proc, 10);
1408: --
1409: -- Issue a savepoint if operating in validation only mode
1410: --
1411: savepoint delete_Benefit_Prvdd_Ledger;

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

1409: -- Issue a savepoint if operating in validation only mode
1410: --
1411: savepoint delete_Benefit_Prvdd_Ledger;
1412: --
1413: hr_utility.set_location(l_proc, 20);
1414: --
1415: -- Process Logic
1416: --
1417: l_object_version_number := p_object_version_number;

Line 1470: hr_utility.set_location('Delete Ledger Row ' || p_bnft_prvdd_ldgr_id, 10);

1466: end if;
1467: --
1468: -- do the real delete
1469: --
1470: hr_utility.set_location('Delete Ledger Row ' || p_bnft_prvdd_ldgr_id, 10);
1471: hr_utility.set_location('Ledger created in PIL_ID ' || l_per_in_ler_id, 10);
1472: --
1473: ben_bpl_del.del
1474: (

Line 1471: hr_utility.set_location('Ledger created in PIL_ID ' || l_per_in_ler_id, 10);

1467: --
1468: -- do the real delete
1469: --
1470: hr_utility.set_location('Delete Ledger Row ' || p_bnft_prvdd_ldgr_id, 10);
1471: hr_utility.set_location('Ledger created in PIL_ID ' || l_per_in_ler_id, 10);
1472: --
1473: ben_bpl_del.del
1474: (
1475: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id

Line 1487: hr_utility.set_location('Previous l_per_in_ler_id' || l_per_in_ler_id, 10);

1483: --
1484: -- Create/update the enrollment to include the rollover amount.
1485: --
1486: -- 5612091 Use latest pil, if avlb
1487: hr_utility.set_location('Previous l_per_in_ler_id' || l_per_in_ler_id, 10);
1488:
1489: l_curr_pil_id := null;
1490: open c_cur_pil;
1491: fetch c_cur_pil into l_curr_pil_id;

Line 1496: hr_utility.set_location('Create Rollover PIL_ID' || l_per_in_ler_id, 10);

1492: close c_cur_pil;
1493: l_per_in_ler_id := NVL(l_curr_pil_id, l_per_in_ler_id);
1494: --
1495:
1496: hr_utility.set_location('Create Rollover PIL_ID' || l_per_in_ler_id, 10);
1497:
1498: /*
1499: Bug 5645366 : Commeneted the following ben_provider_pools.create_rollover_enrollment.
1500:

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

1548: -- End of API User Hook for the after hook of delete_Benefit_Prvdd_Ledger
1549: --
1550: end;
1551: --
1552: hr_utility.set_location(l_proc, 60);
1553: --
1554: -- When in validation only mode raise the Validate_Enabled exception
1555: --
1556: if p_validate then

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

1556: if p_validate then
1557: raise hr_api.validate_enabled;
1558: end if;
1559: --
1560: hr_utility.set_location(' Leaving:'||l_proc, 70);
1561: --
1562: exception
1563: --
1564: when hr_api.validate_enabled then

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

1581: --
1582: ROLLBACK TO delete_Benefit_Prvdd_Ledger;
1583: p_effective_start_date := null;
1584: p_effective_end_date := null;
1585: hr_utility.set_location(' Leaving:'||l_proc, 80);
1586: raise;
1587: --
1588: end delete_Benefit_Prvdd_Ledger;
1589: --

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

1614: l_proc varchar2(72) := g_package||'delete_Benefit_Prvdd_Ledger';
1615: --
1616: begin
1617: --
1618: hr_utility.set_location('Entering:'|| l_proc, 10);
1619: --
1620: l_object_version_number := p_object_version_number;
1621: --
1622: if upper(p_validate) = 'TRUE'

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

1625: else
1626: l_validate := FALSE;
1627: end if;
1628: --
1629: hr_utility.set_location(l_proc, 20);
1630: --
1631: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger
1632: (
1633: p_validate => l_validate

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

1641: ,p_process_enrt_flag => p_process_enrt_flag
1642: ,p_from_reinstate_enrt_flag => p_from_reinstate_enrt_flag
1643: );
1644: --
1645: hr_utility.set_location(l_proc, 30);
1646: --
1647: -- Set all output arguments
1648: --
1649: p_object_version_number := l_object_version_number;

Line 1653: hr_utility.set_location(' Leaving:'||l_proc, 40);

1649: p_object_version_number := l_object_version_number;
1650: p_effective_start_date := l_effective_start_date;
1651: p_effective_end_date := l_effective_end_date;
1652: --
1653: hr_utility.set_location(' Leaving:'||l_proc, 40);
1654: --
1655: exception
1656: --
1657: when others then

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

1656: --
1657: when others then
1658: p_effective_start_date := null;
1659: p_effective_end_date := null;
1660: hr_utility.set_location(' Leaving:'||l_proc, 50);
1661: fnd_msg_pub.add;
1662: --
1663: end delete_Benefit_Prvdd_Ledger_w;
1664: --

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

1684: l_validation_end_date date;
1685: --
1686: begin
1687: --
1688: hr_utility.set_location('Entering:'|| l_proc, 10);
1689: --
1690: ben_bpl_shd.lck
1691: (
1692: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id

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

1696: ,p_effective_date => p_effective_date
1697: ,p_datetrack_mode => p_datetrack_mode
1698: );
1699: --
1700: hr_utility.set_location(' Leaving:'||l_proc, 70);
1701: --
1702: end lck;
1703: --
1704: end ben_Benefit_Prvdd_Ledger_api;