DBA Data[Home] [Help]

APPS.HZ_DUP_PVT dependencies on FND_FILE

Line 1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Merge Batch concurrent program');

1646: savepoint create_merge_pvt;
1647:
1648: FND_MSG_PUB.initialize;
1649:
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Merge Batch concurrent program');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Merge ID : '||p_dup_set_id);
1654: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 1651: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1647:
1648: FND_MSG_PUB.initialize;
1649:
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Merge Batch concurrent program');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Merge ID : '||p_dup_set_id);
1654: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1655:

Line 1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');

1648: FND_MSG_PUB.initialize;
1649:
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Merge Batch concurrent program');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Merge ID : '||p_dup_set_id);
1654: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1655:
1656: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: validate_overlapping_merge_req');

Line 1653: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Merge ID : '||p_dup_set_id);

1649:
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Merge Batch concurrent program');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Merge ID : '||p_dup_set_id);
1654: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1655:
1656: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: validate_overlapping_merge_req');
1657: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(

Line 1654: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Merge Batch concurrent program');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Merge ID : '||p_dup_set_id);
1654: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1655:
1656: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: validate_overlapping_merge_req');
1657: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(
1658: p_dup_set_id => p_dup_set_id,

Line 1656: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: validate_overlapping_merge_req');

1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');
1653: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Merge ID : '||p_dup_set_id);
1654: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1655:
1656: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: validate_overlapping_merge_req');
1657: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(
1658: p_dup_set_id => p_dup_set_id,
1659: p_merge_batch_id => null,
1660: p_init_msg_list => FND_API.G_FALSE,

Line 1666: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: validate_overlapping_merge_req');

1662: x_return_status => l_return_status,
1663: x_msg_count => l_msg_count,
1664: x_msg_data => l_msg_data);
1665:
1666: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: validate_overlapping_merge_req');
1667: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1668:
1669: /* error messages have been pushed into message stack in above procedure */
1670: IF l_return_status = 'E' THEN

Line 1667: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1663: x_msg_count => l_msg_count,
1664: x_msg_data => l_msg_data);
1665:
1666: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: validate_overlapping_merge_req');
1667: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1668:
1669: /* error messages have been pushed into message stack in above procedure */
1670: IF l_return_status = 'E' THEN
1671: RAISE FND_API.G_EXC_ERROR;

Line 1693: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1689: if(check_merge_batch%NOTFOUND) then
1690:
1691: BEGIN
1692:
1693: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1694: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Checking Profile Value for HZ_DL_DQM_MERGE_SUGG');
1695: --Bug 5635453
1696: fnd_profile.get(
1697: name => 'HZ_DL_DQM_MERGE_SUGG',

Line 1694: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Checking Profile Value for HZ_DL_DQM_MERGE_SUGG');

1690:
1691: BEGIN
1692:
1693: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1694: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Checking Profile Value for HZ_DL_DQM_MERGE_SUGG');
1695: --Bug 5635453
1696: fnd_profile.get(
1697: name => 'HZ_DL_DQM_MERGE_SUGG',
1698: val => l_default_mapping

Line 1706: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: create_merge_batch');

1702: l_default_mapping := 'Y';
1703: END IF;
1704:
1705: --Bug 5635453
1706: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: create_merge_batch');
1707: HZ_MERGE_DUP_PVT.create_merge_batch (
1708: p_dup_set_id => l_dup_set_id
1709: ,p_default_mapping => l_default_mapping--Bug 5635453
1710: ,p_object_version_number => l_set_obj_version_number

Line 1716: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: create_merge_batch');

1712: ,x_return_status => l_return_status
1713: ,x_msg_count => l_msg_count
1714: ,x_msg_data => l_msg_data
1715: );
1716: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: create_merge_batch');
1717: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1718:
1719: EXCEPTION
1720: WHEN OTHERS THEN

Line 1717: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1713: ,x_msg_count => l_msg_count
1714: ,x_msg_data => l_msg_data
1715: );
1716: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: create_merge_batch');
1717: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1718:
1719: EXCEPTION
1720: WHEN OTHERS THEN
1721: l_return_status := 'U';

Line 1732: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1728: l_set_obj_version_number := l_set_obj_version_number + 1;
1729: END IF;
1730:
1731: IF (l_return_status = 'E') THEN
1732: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1733: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge expected error. ');
1734: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1735: RAISE FND_API.G_EXC_ERROR;
1736: ELSIF (l_return_status = 'U') THEN

Line 1733: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge expected error. ');

1729: END IF;
1730:
1731: IF (l_return_status = 'E') THEN
1732: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1733: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge expected error. ');
1734: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1735: RAISE FND_API.G_EXC_ERROR;
1736: ELSIF (l_return_status = 'U') THEN
1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 1734: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1730:
1731: IF (l_return_status = 'E') THEN
1732: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1733: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge expected error. ');
1734: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1735: RAISE FND_API.G_EXC_ERROR;
1736: ELSIF (l_return_status = 'U') THEN
1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');

Line 1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1733: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge expected error. ');
1734: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1735: RAISE FND_API.G_EXC_ERROR;
1736: ELSIF (l_return_status = 'U') THEN
1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');
1739: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF (l_return_status = 'S') THEN

Line 1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');

1734: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1735: RAISE FND_API.G_EXC_ERROR;
1736: ELSIF (l_return_status = 'U') THEN
1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');
1739: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF (l_return_status = 'S') THEN
1742: UPDATE HZ_DUP_SETS

Line 1739: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1735: RAISE FND_API.G_EXC_ERROR;
1736: ELSIF (l_return_status = 'U') THEN
1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');
1739: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF (l_return_status = 'S') THEN
1742: UPDATE HZ_DUP_SETS
1743: set status = 'REQUESTED'

Line 1748: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1744: , last_update_date = hz_utility_v2pub.last_update_date
1745: , last_updated_by = hz_utility_v2pub.last_updated_by
1746: , last_update_login = hz_utility_v2pub.last_update_login
1747: where dup_set_id = l_dup_set_id;
1748: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1749: FND_FILE.PUT_LINE (FND_FILE.LOG, 'call create_merge_batch without error. ');
1750: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1751: COMMIT;
1752: END IF; -- return_status

Line 1749: FND_FILE.PUT_LINE (FND_FILE.LOG, 'call create_merge_batch without error. ');

1745: , last_updated_by = hz_utility_v2pub.last_updated_by
1746: , last_update_login = hz_utility_v2pub.last_update_login
1747: where dup_set_id = l_dup_set_id;
1748: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1749: FND_FILE.PUT_LINE (FND_FILE.LOG, 'call create_merge_batch without error. ');
1750: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1751: COMMIT;
1752: END IF; -- return_status
1753: else

Line 1750: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1746: , last_update_login = hz_utility_v2pub.last_update_login
1747: where dup_set_id = l_dup_set_id;
1748: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1749: FND_FILE.PUT_LINE (FND_FILE.LOG, 'call create_merge_batch without error. ');
1750: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1751: COMMIT;
1752: END IF; -- return_status
1753: else
1754: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 1754: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1750: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1751: COMMIT;
1752: END IF; -- return_status
1753: else
1754: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1755: FND_FILE.PUT_LINE (FND_FILE.LOG, 'merge batch/parties exists. ');
1756: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1757: RAISE FND_API.G_EXC_ERROR;
1758: end if; -- check_merge_batch

Line 1755: FND_FILE.PUT_LINE (FND_FILE.LOG, 'merge batch/parties exists. ');

1751: COMMIT;
1752: END IF; -- return_status
1753: else
1754: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1755: FND_FILE.PUT_LINE (FND_FILE.LOG, 'merge batch/parties exists. ');
1756: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1757: RAISE FND_API.G_EXC_ERROR;
1758: end if; -- check_merge_batch
1759: close check_merge_batch;

Line 1756: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1752: END IF; -- return_status
1753: else
1754: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1755: FND_FILE.PUT_LINE (FND_FILE.LOG, 'merge batch/parties exists. ');
1756: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1757: RAISE FND_API.G_EXC_ERROR;
1758: end if; -- check_merge_batch
1759: close check_merge_batch;
1760:

Line 1761: FND_FILE.PUT_LINE (FND_FILE.LOG, 'validate_overlapping_merge_req second try');

1757: RAISE FND_API.G_EXC_ERROR;
1758: end if; -- check_merge_batch
1759: close check_merge_batch;
1760:
1761: FND_FILE.PUT_LINE (FND_FILE.LOG, 'validate_overlapping_merge_req second try');
1762: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(
1763: p_dup_set_id => p_dup_set_id,
1764: p_merge_batch_id => null,
1765: p_init_msg_list => FND_API.G_FALSE,

Line 1771: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: validate_overlapping_merge_req second try');

1767: x_return_status => l_return_status,
1768: x_msg_count => l_msg_count,
1769: x_msg_data => l_msg_data);
1770:
1771: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: validate_overlapping_merge_req second try');
1772: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1773:
1774: /* error messages have been pushed into message stack in above procedure */
1775: IF l_return_status = 'E' THEN

Line 1772: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

1768: x_msg_count => l_msg_count,
1769: x_msg_data => l_msg_data);
1770:
1771: FND_FILE.PUT_LINE (FND_FILE.LOG, 'End: validate_overlapping_merge_req second try');
1772: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1773:
1774: /* error messages have been pushed into message stack in above procedure */
1775: IF l_return_status = 'E' THEN
1776: RAISE FND_API.G_EXC_ERROR;

Line 1824: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1820: newline IN BOOLEAN DEFAULT TRUE
1821: ) IS
1822: BEGIN
1823: IF message = 'NEWLINE' THEN
1824: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1825: ELSIF (newline) THEN
1826: FND_FILE.put_line(fnd_file.log,message);
1827: ELSE
1828: FND_FILE.put(fnd_file.log,message);

Line 1826: FND_FILE.put_line(fnd_file.log,message);

1822: BEGIN
1823: IF message = 'NEWLINE' THEN
1824: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1825: ELSIF (newline) THEN
1826: FND_FILE.put_line(fnd_file.log,message);
1827: ELSE
1828: FND_FILE.put(fnd_file.log,message);
1829: END IF;
1830: END log;

Line 1828: FND_FILE.put(fnd_file.log,message);

1824: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1825: ELSIF (newline) THEN
1826: FND_FILE.put_line(fnd_file.log,message);
1827: ELSE
1828: FND_FILE.put(fnd_file.log,message);
1829: END IF;
1830: END log;
1831:
1832: /*-----------------------------------------------------------------------