DBA Data[Home] [Help]

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 1166: hr_utility.set_location(l_proc, 60);

1162: end;
1163: --
1164: end if; -- Bug: 3611160/4169180.
1165: --
1166: hr_utility.set_location(l_proc, 60);
1167: --
1168: -- When in validation only mode raise the Validate_Enabled exception
1169: --
1170: if p_validate then

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

1176: p_object_version_number := l_object_version_number;
1177: p_effective_start_date := l_effective_start_date;
1178: p_effective_end_date := l_effective_end_date;
1179: --
1180: hr_utility.set_location(' Leaving:'||l_proc, 70);
1181: --
1182: exception
1183: --
1184: when hr_api.validate_enabled then

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

1191: -- Only set output warning arguments
1192: -- (Any key or derived arguments must be set to null
1193: -- when validation only mode is being used.)
1194: --
1195: hr_utility.set_location(' Leaving:'||l_proc, 80);
1196: --
1197: when others then
1198: --
1199: -- A validation or unexpected error has occured

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

1200: --
1201: ROLLBACK TO update_Benefit_Prvdd_Ledger;
1202: p_effective_start_date := null;
1203: p_effective_end_date := null;
1204: hr_utility.set_location(' Leaving:'||l_proc, 90);
1205: raise;
1206: --
1207: end update_Benefit_Prvdd_Ledger;
1208: --

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

1255: l_proc varchar2(72) := g_package||'update_Benefit_Prvdd_Ledger_w';
1256: --
1257: begin
1258: --
1259: hr_utility.set_location('Entering:'|| l_proc, 10);
1260: --
1261: l_object_version_number := p_object_version_number;
1262: --
1263: if upper(p_validate) = 'TRUE'

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

1266: else
1267: l_validate := FALSE;
1268: end if;
1269: --
1270: hr_utility.set_location(l_proc, 20);
1271: --
1272: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger
1273: (
1274: p_validate => l_validate

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

1304: p_ann_used_val => p_ann_used_val,
1305: p_ann_cash_recd_val => p_ann_cash_recd_val
1306: );
1307: --
1308: hr_utility.set_location(l_proc, 30);
1309: --
1310: -- Set all output arguments
1311: --
1312: p_object_version_number := l_object_version_number;

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

1312: p_object_version_number := l_object_version_number;
1313: p_effective_start_date := l_effective_start_date;
1314: p_effective_end_date := l_effective_end_date;
1315: --
1316: hr_utility.set_location(' Leaving:'||l_proc, 40);
1317: --
1318: exception
1319: --
1320: when others then

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

1319: --
1320: when others then
1321: p_effective_start_date := null;
1322: p_effective_end_date := null;
1323: hr_utility.set_location(' Leaving:'||l_proc, 50);
1324: fnd_msg_pub.add;
1325: --
1326: end update_Benefit_Prvdd_Ledger_w;
1327: --

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

1397: --
1398: l_curr_pil_id NUMBER;
1399: begin
1400: --
1401: hr_utility.set_location('Entering:'|| l_proc, 10);
1402: --
1403: -- Issue a savepoint if operating in validation only mode
1404: --
1405: savepoint delete_Benefit_Prvdd_Ledger;

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

1403: -- Issue a savepoint if operating in validation only mode
1404: --
1405: savepoint delete_Benefit_Prvdd_Ledger;
1406: --
1407: hr_utility.set_location(l_proc, 20);
1408: --
1409: -- Process Logic
1410: --
1411: l_object_version_number := p_object_version_number;

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

1460: end if;
1461: --
1462: -- do the real delete
1463: --
1464: hr_utility.set_location('Delete Ledger Row ' || p_bnft_prvdd_ldgr_id, 10);
1465: hr_utility.set_location('Ledger created in PIL_ID ' || l_per_in_ler_id, 10);
1466: --
1467: ben_bpl_del.del
1468: (

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

1461: --
1462: -- do the real delete
1463: --
1464: hr_utility.set_location('Delete Ledger Row ' || p_bnft_prvdd_ldgr_id, 10);
1465: hr_utility.set_location('Ledger created in PIL_ID ' || l_per_in_ler_id, 10);
1466: --
1467: ben_bpl_del.del
1468: (
1469: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id

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

1477: --
1478: -- Create/update the enrollment to include the rollover amount.
1479: --
1480: -- 5612091 Use latest pil, if avlb
1481: hr_utility.set_location('Previous l_per_in_ler_id' || l_per_in_ler_id, 10);
1482:
1483: l_curr_pil_id := null;
1484: open c_cur_pil;
1485: fetch c_cur_pil into l_curr_pil_id;

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

1486: close c_cur_pil;
1487: l_per_in_ler_id := NVL(l_curr_pil_id, l_per_in_ler_id);
1488: --
1489:
1490: hr_utility.set_location('Create Rollover PIL_ID' || l_per_in_ler_id, 10);
1491:
1492: /*
1493: Bug 5645366 : Commeneted the following ben_provider_pools.create_rollover_enrollment.
1494:

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

1542: -- End of API User Hook for the after hook of delete_Benefit_Prvdd_Ledger
1543: --
1544: end;
1545: --
1546: hr_utility.set_location(l_proc, 60);
1547: --
1548: -- When in validation only mode raise the Validate_Enabled exception
1549: --
1550: if p_validate then

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

1550: if p_validate then
1551: raise hr_api.validate_enabled;
1552: end if;
1553: --
1554: hr_utility.set_location(' Leaving:'||l_proc, 70);
1555: --
1556: exception
1557: --
1558: when hr_api.validate_enabled then

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

1575: --
1576: ROLLBACK TO delete_Benefit_Prvdd_Ledger;
1577: p_effective_start_date := null;
1578: p_effective_end_date := null;
1579: hr_utility.set_location(' Leaving:'||l_proc, 80);
1580: raise;
1581: --
1582: end delete_Benefit_Prvdd_Ledger;
1583: --

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

1608: l_proc varchar2(72) := g_package||'delete_Benefit_Prvdd_Ledger';
1609: --
1610: begin
1611: --
1612: hr_utility.set_location('Entering:'|| l_proc, 10);
1613: --
1614: l_object_version_number := p_object_version_number;
1615: --
1616: if upper(p_validate) = 'TRUE'

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

1619: else
1620: l_validate := FALSE;
1621: end if;
1622: --
1623: hr_utility.set_location(l_proc, 20);
1624: --
1625: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger
1626: (
1627: p_validate => l_validate

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

1635: ,p_process_enrt_flag => p_process_enrt_flag
1636: ,p_from_reinstate_enrt_flag => p_from_reinstate_enrt_flag
1637: );
1638: --
1639: hr_utility.set_location(l_proc, 30);
1640: --
1641: -- Set all output arguments
1642: --
1643: p_object_version_number := l_object_version_number;

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

1643: p_object_version_number := l_object_version_number;
1644: p_effective_start_date := l_effective_start_date;
1645: p_effective_end_date := l_effective_end_date;
1646: --
1647: hr_utility.set_location(' Leaving:'||l_proc, 40);
1648: --
1649: exception
1650: --
1651: when others then

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

1650: --
1651: when others then
1652: p_effective_start_date := null;
1653: p_effective_end_date := null;
1654: hr_utility.set_location(' Leaving:'||l_proc, 50);
1655: fnd_msg_pub.add;
1656: --
1657: end delete_Benefit_Prvdd_Ledger_w;
1658: --

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

1678: l_validation_end_date date;
1679: --
1680: begin
1681: --
1682: hr_utility.set_location('Entering:'|| l_proc, 10);
1683: --
1684: ben_bpl_shd.lck
1685: (
1686: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id

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

1690: ,p_effective_date => p_effective_date
1691: ,p_datetrack_mode => p_datetrack_mode
1692: );
1693: --
1694: hr_utility.set_location(' Leaving:'||l_proc, 70);
1695: --
1696: end lck;
1697: --
1698: end ben_Benefit_Prvdd_Ledger_api;