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.OTA_TFH_API_BUSINESS_RULES dependencies on OTA_GENERAL

Line 31: ota_general.check_domain_value( 'FINANCE_HEADER_TYPE', p_type);

27: hr_utility.set_location('Entering:'||v_proc, 5);
28: --
29: If p_type is not null Then
30: --
31: ota_general.check_domain_value( 'FINANCE_HEADER_TYPE', p_type);
32: --
33: Else
34: -- column is a not null field **** change message later
35: --

Line 66: ota_general.check_domain_value( 'GL_TRANSFER_STATUS', p_transfer_status);

62: hr_utility.set_location('Entering:'|| v_proc, 5);
63: --
64: If p_transfer_status is not null Then
65: --
66: ota_general.check_domain_value( 'GL_TRANSFER_STATUS', p_transfer_status);
67: --
68: Else
69: --
70: ota_tfh_api_shd.constraint_error( 'OTA_TFH_TRANSFER_STATUS_CHK');

Line 177: If NOT ota_general.check_fnd_user( p_person_id) Then

173: Begin
174: hr_utility.set_location('Entering:'|| v_proc, 5);
175: --
176: If p_person_id is not null Then
177: If NOT ota_general.check_fnd_user( p_person_id) Then
178: fnd_message.set_name('OTA','OTA_13281_TFH_AUTHORIZER');
179: fnd_message.raise_error;
180: End if;
181: End if;

Line 1689: ota_general.check_domain_value( 'PAYMENT_METHOD', p_payment_method);

1685: hr_utility.set_location('Entering:'|| v_proc, 5);
1686: --
1687: If p_payment_method is not null Then
1688: --
1689: ota_general.check_domain_value( 'PAYMENT_METHOD', p_payment_method);
1690: --
1691: End If;
1692: --
1693: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1748: := ota_general.value_changed( p_rec_old.superceding_header_id

1744: --
1745: v_proc varchar2(72) := g_package||'check_update01_header';
1746: --
1747: l_super_header_id_changed boolean
1748: := ota_general.value_changed( p_rec_old.superceding_header_id
1749: , p_rec_new.superceding_header_id );
1750: --
1751: l_authorizer_person_id_changed boolean
1752: := ota_general.value_changed( p_rec_old.authorizer_person_id

Line 1752: := ota_general.value_changed( p_rec_old.authorizer_person_id

1748: := ota_general.value_changed( p_rec_old.superceding_header_id
1749: , p_rec_new.superceding_header_id );
1750: --
1751: l_authorizer_person_id_changed boolean
1752: := ota_general.value_changed( p_rec_old.authorizer_person_id
1753: , p_rec_new.authorizer_person_id );
1754: --
1755: l_organization_id_changed boolean
1756: := ota_general.value_changed( p_rec_old.organization_id

Line 1756: := ota_general.value_changed( p_rec_old.organization_id

1752: := ota_general.value_changed( p_rec_old.authorizer_person_id
1753: , p_rec_new.authorizer_person_id );
1754: --
1755: l_organization_id_changed boolean
1756: := ota_general.value_changed( p_rec_old.organization_id
1757: , p_rec_new.organization_id );
1758: --
1759: l_administrator_changed boolean
1760: := ota_general.value_changed( p_rec_old.administrator

Line 1760: := ota_general.value_changed( p_rec_old.administrator

1756: := ota_general.value_changed( p_rec_old.organization_id
1757: , p_rec_new.organization_id );
1758: --
1759: l_administrator_changed boolean
1760: := ota_general.value_changed( p_rec_old.administrator
1761: , p_rec_new.administrator );
1762: --
1763: l_cancelled_flag_changed boolean
1764: := ota_general.value_changed( p_rec_old.cancelled_flag

Line 1764: := ota_general.value_changed( p_rec_old.cancelled_flag

1760: := ota_general.value_changed( p_rec_old.administrator
1761: , p_rec_new.administrator );
1762: --
1763: l_cancelled_flag_changed boolean
1764: := ota_general.value_changed( p_rec_old.cancelled_flag
1765: , p_rec_new.cancelled_flag );
1766: --
1767: l_currency_code_changed boolean
1768: := ota_general.value_changed( p_rec_old.currency_code

Line 1768: := ota_general.value_changed( p_rec_old.currency_code

1764: := ota_general.value_changed( p_rec_old.cancelled_flag
1765: , p_rec_new.cancelled_flag );
1766: --
1767: l_currency_code_changed boolean
1768: := ota_general.value_changed( p_rec_old.currency_code
1769: , p_rec_new.currency_code );
1770: --
1771: l_date_raised_changed boolean
1772: := ota_general.value_changed( p_rec_old.date_raised

Line 1772: := ota_general.value_changed( p_rec_old.date_raised

1768: := ota_general.value_changed( p_rec_old.currency_code
1769: , p_rec_new.currency_code );
1770: --
1771: l_date_raised_changed boolean
1772: := ota_general.value_changed( p_rec_old.date_raised
1773: , p_rec_new.date_raised );
1774: --
1775: l_transfer_status_changed boolean
1776: := ota_general.value_changed( p_rec_old.transfer_status

Line 1776: := ota_general.value_changed( p_rec_old.transfer_status

1772: := ota_general.value_changed( p_rec_old.date_raised
1773: , p_rec_new.date_raised );
1774: --
1775: l_transfer_status_changed boolean
1776: := ota_general.value_changed( p_rec_old.transfer_status
1777: , p_rec_new.transfer_status );
1778: --
1779: l_type_changed boolean
1780: := ota_general.value_changed( p_rec_old.type

Line 1780: := ota_general.value_changed( p_rec_old.type

1776: := ota_general.value_changed( p_rec_old.transfer_status
1777: , p_rec_new.transfer_status );
1778: --
1779: l_type_changed boolean
1780: := ota_general.value_changed( p_rec_old.type
1781: , p_rec_new.type );
1782: --
1783: l_comments_changed boolean
1784: := ota_general.value_changed( p_rec_old.comments

Line 1784: := ota_general.value_changed( p_rec_old.comments

1780: := ota_general.value_changed( p_rec_old.type
1781: , p_rec_new.type );
1782: --
1783: l_comments_changed boolean
1784: := ota_general.value_changed( p_rec_old.comments
1785: , p_rec_new.comments );
1786: --
1787: l_external_reference_changed boolean
1788: := ota_general.value_changed( p_rec_old.external_reference

Line 1788: := ota_general.value_changed( p_rec_old.external_reference

1784: := ota_general.value_changed( p_rec_old.comments
1785: , p_rec_new.comments );
1786: --
1787: l_external_reference_changed boolean
1788: := ota_general.value_changed( p_rec_old.external_reference
1789: , p_rec_new.external_reference );
1790: --
1791: l_invoice_address_changed boolean
1792: := ota_general.value_changed( p_rec_old.invoice_address

Line 1792: := ota_general.value_changed( p_rec_old.invoice_address

1788: := ota_general.value_changed( p_rec_old.external_reference
1789: , p_rec_new.external_reference );
1790: --
1791: l_invoice_address_changed boolean
1792: := ota_general.value_changed( p_rec_old.invoice_address
1793: , p_rec_new.invoice_address );
1794: --
1795: l_invoice_contact_changed boolean
1796: := ota_general.value_changed( p_rec_old.invoice_contact

Line 1796: := ota_general.value_changed( p_rec_old.invoice_contact

1792: := ota_general.value_changed( p_rec_old.invoice_address
1793: , p_rec_new.invoice_address );
1794: --
1795: l_invoice_contact_changed boolean
1796: := ota_general.value_changed( p_rec_old.invoice_contact
1797: , p_rec_new.invoice_contact );
1798: --
1799: l_payment_method_changed boolean
1800: := ota_general.value_changed( p_rec_old.payment_method

Line 1800: := ota_general.value_changed( p_rec_old.payment_method

1796: := ota_general.value_changed( p_rec_old.invoice_contact
1797: , p_rec_new.invoice_contact );
1798: --
1799: l_payment_method_changed boolean
1800: := ota_general.value_changed( p_rec_old.payment_method
1801: , p_rec_new.payment_method );
1802: --
1803: l_transfer_date_changed boolean
1804: := ota_general.value_changed( p_rec_old.transfer_date

Line 1804: := ota_general.value_changed( p_rec_old.transfer_date

1800: := ota_general.value_changed( p_rec_old.payment_method
1801: , p_rec_new.payment_method );
1802: --
1803: l_transfer_date_changed boolean
1804: := ota_general.value_changed( p_rec_old.transfer_date
1805: , p_rec_new.transfer_date );
1806: --
1807: l_transfer_message_changed boolean
1808: := ota_general.value_changed( p_rec_old.transfer_message

Line 1808: := ota_general.value_changed( p_rec_old.transfer_message

1804: := ota_general.value_changed( p_rec_old.transfer_date
1805: , p_rec_new.transfer_date );
1806: --
1807: l_transfer_message_changed boolean
1808: := ota_general.value_changed( p_rec_old.transfer_message
1809: , p_rec_new.transfer_message );
1810: --
1811: l_vendor_id_changed boolean
1812: := ota_general.value_changed( p_rec_old.vendor_id

Line 1812: := ota_general.value_changed( p_rec_old.vendor_id

1808: := ota_general.value_changed( p_rec_old.transfer_message
1809: , p_rec_new.transfer_message );
1810: --
1811: l_vendor_id_changed boolean
1812: := ota_general.value_changed( p_rec_old.vendor_id
1813: , p_rec_new.vendor_id );
1814: --
1815: l_contact_id_changed boolean
1816: := ota_general.value_changed( p_rec_old.contact_id

Line 1816: := ota_general.value_changed( p_rec_old.contact_id

1812: := ota_general.value_changed( p_rec_old.vendor_id
1813: , p_rec_new.vendor_id );
1814: --
1815: l_contact_id_changed boolean
1816: := ota_general.value_changed( p_rec_old.contact_id
1817: , p_rec_new.contact_id );
1818: --
1819: l_address_id_changed boolean
1820: := ota_general.value_changed( p_rec_old.address_id

Line 1820: := ota_general.value_changed( p_rec_old.address_id

1816: := ota_general.value_changed( p_rec_old.contact_id
1817: , p_rec_new.contact_id );
1818: --
1819: l_address_id_changed boolean
1820: := ota_general.value_changed( p_rec_old.address_id
1821: , p_rec_new.address_id );
1822: --
1823: l_customer_id_changed boolean
1824: := ota_general.value_changed( p_rec_old.customer_id

Line 1824: := ota_general.value_changed( p_rec_old.customer_id

1820: := ota_general.value_changed( p_rec_old.address_id
1821: , p_rec_new.address_id );
1822: --
1823: l_customer_id_changed boolean
1824: := ota_general.value_changed( p_rec_old.customer_id
1825: , p_rec_new.customer_id );
1826: --
1827: l_payment_status_changed boolean
1828: := ota_general.value_changed( p_rec_old.payment_status_flag

Line 1828: := ota_general.value_changed( p_rec_old.payment_status_flag

1824: := ota_general.value_changed( p_rec_old.customer_id
1825: , p_rec_new.customer_id );
1826: --
1827: l_payment_status_changed boolean
1828: := ota_general.value_changed( p_rec_old.payment_status_flag
1829: , p_rec_new.payment_status_flag );
1830: --
1831: Begin
1832: --

Line 1883: := ota_general.value_changed( p_rec_old.pym_information_category

1879: --
1880: v_proc varchar2(72) := g_package||'check_update02_header';
1881: --
1882: l_pym_info_category_changed boolean
1883: := ota_general.value_changed( p_rec_old.pym_information_category
1884: , p_rec_new.pym_information_category );
1885: --
1886: l_pym_attribute1_changed boolean
1887: := ota_general.value_changed( p_rec_old.pym_attribute1

Line 1887: := ota_general.value_changed( p_rec_old.pym_attribute1

1883: := ota_general.value_changed( p_rec_old.pym_information_category
1884: , p_rec_new.pym_information_category );
1885: --
1886: l_pym_attribute1_changed boolean
1887: := ota_general.value_changed( p_rec_old.pym_attribute1
1888: , p_rec_new.pym_attribute1 );
1889: --
1890: l_pym_attribute2_changed boolean
1891: := ota_general.value_changed( p_rec_old.pym_attribute2

Line 1891: := ota_general.value_changed( p_rec_old.pym_attribute2

1887: := ota_general.value_changed( p_rec_old.pym_attribute1
1888: , p_rec_new.pym_attribute1 );
1889: --
1890: l_pym_attribute2_changed boolean
1891: := ota_general.value_changed( p_rec_old.pym_attribute2
1892: , p_rec_new.pym_attribute2 );
1893: --
1894: l_pym_attribute3_changed boolean
1895: := ota_general.value_changed( p_rec_old.pym_attribute3

Line 1895: := ota_general.value_changed( p_rec_old.pym_attribute3

1891: := ota_general.value_changed( p_rec_old.pym_attribute2
1892: , p_rec_new.pym_attribute2 );
1893: --
1894: l_pym_attribute3_changed boolean
1895: := ota_general.value_changed( p_rec_old.pym_attribute3
1896: , p_rec_new.pym_attribute3 );
1897: --
1898: l_pym_attribute4_changed boolean
1899: := ota_general.value_changed( p_rec_old.pym_attribute4

Line 1899: := ota_general.value_changed( p_rec_old.pym_attribute4

1895: := ota_general.value_changed( p_rec_old.pym_attribute3
1896: , p_rec_new.pym_attribute3 );
1897: --
1898: l_pym_attribute4_changed boolean
1899: := ota_general.value_changed( p_rec_old.pym_attribute4
1900: , p_rec_new.pym_attribute4 );
1901: --
1902: l_pym_attribute5_changed boolean
1903: := ota_general.value_changed( p_rec_old.pym_attribute5

Line 1903: := ota_general.value_changed( p_rec_old.pym_attribute5

1899: := ota_general.value_changed( p_rec_old.pym_attribute4
1900: , p_rec_new.pym_attribute4 );
1901: --
1902: l_pym_attribute5_changed boolean
1903: := ota_general.value_changed( p_rec_old.pym_attribute5
1904: , p_rec_new.pym_attribute5 );
1905: --
1906: l_pym_attribute6_changed boolean
1907: := ota_general.value_changed( p_rec_old.pym_attribute6

Line 1907: := ota_general.value_changed( p_rec_old.pym_attribute6

1903: := ota_general.value_changed( p_rec_old.pym_attribute5
1904: , p_rec_new.pym_attribute5 );
1905: --
1906: l_pym_attribute6_changed boolean
1907: := ota_general.value_changed( p_rec_old.pym_attribute6
1908: , p_rec_new.pym_attribute6 );
1909: --
1910: l_pym_attribute7_changed boolean
1911: := ota_general.value_changed( p_rec_old.pym_attribute7

Line 1911: := ota_general.value_changed( p_rec_old.pym_attribute7

1907: := ota_general.value_changed( p_rec_old.pym_attribute6
1908: , p_rec_new.pym_attribute6 );
1909: --
1910: l_pym_attribute7_changed boolean
1911: := ota_general.value_changed( p_rec_old.pym_attribute7
1912: , p_rec_new.pym_attribute7 );
1913: --
1914: l_pym_attribute8_changed boolean
1915: := ota_general.value_changed( p_rec_old.pym_attribute8

Line 1915: := ota_general.value_changed( p_rec_old.pym_attribute8

1911: := ota_general.value_changed( p_rec_old.pym_attribute7
1912: , p_rec_new.pym_attribute7 );
1913: --
1914: l_pym_attribute8_changed boolean
1915: := ota_general.value_changed( p_rec_old.pym_attribute8
1916: , p_rec_new.pym_attribute8 );
1917: --
1918: l_pym_attribute9_changed boolean
1919: := ota_general.value_changed( p_rec_old.pym_attribute9

Line 1919: := ota_general.value_changed( p_rec_old.pym_attribute9

1915: := ota_general.value_changed( p_rec_old.pym_attribute8
1916: , p_rec_new.pym_attribute8 );
1917: --
1918: l_pym_attribute9_changed boolean
1919: := ota_general.value_changed( p_rec_old.pym_attribute9
1920: , p_rec_new.pym_attribute9 );
1921: --
1922: l_pym_attribute10_changed boolean
1923: := ota_general.value_changed( p_rec_old.pym_attribute10

Line 1923: := ota_general.value_changed( p_rec_old.pym_attribute10

1919: := ota_general.value_changed( p_rec_old.pym_attribute9
1920: , p_rec_new.pym_attribute9 );
1921: --
1922: l_pym_attribute10_changed boolean
1923: := ota_general.value_changed( p_rec_old.pym_attribute10
1924: , p_rec_new.pym_attribute10 );
1925: --
1926: l_pym_attribute11_changed boolean
1927: := ota_general.value_changed( p_rec_old.pym_attribute11

Line 1927: := ota_general.value_changed( p_rec_old.pym_attribute11

1923: := ota_general.value_changed( p_rec_old.pym_attribute10
1924: , p_rec_new.pym_attribute10 );
1925: --
1926: l_pym_attribute11_changed boolean
1927: := ota_general.value_changed( p_rec_old.pym_attribute11
1928: , p_rec_new.pym_attribute11 );
1929: --
1930: l_pym_attribute12_changed boolean
1931: := ota_general.value_changed( p_rec_old.pym_attribute12

Line 1931: := ota_general.value_changed( p_rec_old.pym_attribute12

1927: := ota_general.value_changed( p_rec_old.pym_attribute11
1928: , p_rec_new.pym_attribute11 );
1929: --
1930: l_pym_attribute12_changed boolean
1931: := ota_general.value_changed( p_rec_old.pym_attribute12
1932: , p_rec_new.pym_attribute12 );
1933: --
1934: l_pym_attribute13_changed boolean
1935: := ota_general.value_changed( p_rec_old.pym_attribute13

Line 1935: := ota_general.value_changed( p_rec_old.pym_attribute13

1931: := ota_general.value_changed( p_rec_old.pym_attribute12
1932: , p_rec_new.pym_attribute12 );
1933: --
1934: l_pym_attribute13_changed boolean
1935: := ota_general.value_changed( p_rec_old.pym_attribute13
1936: , p_rec_new.pym_attribute13 );
1937: --
1938: l_pym_attribute14_changed boolean
1939: := ota_general.value_changed( p_rec_old.pym_attribute14

Line 1939: := ota_general.value_changed( p_rec_old.pym_attribute14

1935: := ota_general.value_changed( p_rec_old.pym_attribute13
1936: , p_rec_new.pym_attribute13 );
1937: --
1938: l_pym_attribute14_changed boolean
1939: := ota_general.value_changed( p_rec_old.pym_attribute14
1940: , p_rec_new.pym_attribute14 );
1941: --
1942: l_pym_attribute15_changed boolean
1943: := ota_general.value_changed( p_rec_old.pym_attribute15

Line 1943: := ota_general.value_changed( p_rec_old.pym_attribute15

1939: := ota_general.value_changed( p_rec_old.pym_attribute14
1940: , p_rec_new.pym_attribute14 );
1941: --
1942: l_pym_attribute15_changed boolean
1943: := ota_general.value_changed( p_rec_old.pym_attribute15
1944: , p_rec_new.pym_attribute15 );
1945: --
1946: l_pym_attribute16_changed boolean
1947: := ota_general.value_changed( p_rec_old.pym_attribute16

Line 1947: := ota_general.value_changed( p_rec_old.pym_attribute16

1943: := ota_general.value_changed( p_rec_old.pym_attribute15
1944: , p_rec_new.pym_attribute15 );
1945: --
1946: l_pym_attribute16_changed boolean
1947: := ota_general.value_changed( p_rec_old.pym_attribute16
1948: , p_rec_new.pym_attribute16 );
1949: --
1950: l_pym_attribute17_changed boolean
1951: := ota_general.value_changed( p_rec_old.pym_attribute17

Line 1951: := ota_general.value_changed( p_rec_old.pym_attribute17

1947: := ota_general.value_changed( p_rec_old.pym_attribute16
1948: , p_rec_new.pym_attribute16 );
1949: --
1950: l_pym_attribute17_changed boolean
1951: := ota_general.value_changed( p_rec_old.pym_attribute17
1952: , p_rec_new.pym_attribute17 );
1953: --
1954: l_pym_attribute18_changed boolean
1955: := ota_general.value_changed( p_rec_old.pym_attribute18

Line 1955: := ota_general.value_changed( p_rec_old.pym_attribute18

1951: := ota_general.value_changed( p_rec_old.pym_attribute17
1952: , p_rec_new.pym_attribute17 );
1953: --
1954: l_pym_attribute18_changed boolean
1955: := ota_general.value_changed( p_rec_old.pym_attribute18
1956: , p_rec_new.pym_attribute18 );
1957: --
1958: l_pym_attribute19_changed boolean
1959: := ota_general.value_changed( p_rec_old.pym_attribute19

Line 1959: := ota_general.value_changed( p_rec_old.pym_attribute19

1955: := ota_general.value_changed( p_rec_old.pym_attribute18
1956: , p_rec_new.pym_attribute18 );
1957: --
1958: l_pym_attribute19_changed boolean
1959: := ota_general.value_changed( p_rec_old.pym_attribute19
1960: , p_rec_new.pym_attribute19 );
1961: --
1962: l_pym_attribute20_changed boolean
1963: := ota_general.value_changed( p_rec_old.pym_attribute20

Line 1963: := ota_general.value_changed( p_rec_old.pym_attribute20

1959: := ota_general.value_changed( p_rec_old.pym_attribute19
1960: , p_rec_new.pym_attribute19 );
1961: --
1962: l_pym_attribute20_changed boolean
1963: := ota_general.value_changed( p_rec_old.pym_attribute20
1964: , p_rec_new.pym_attribute20 );
1965: --
1966: l_tfh_info_category_changed boolean
1967: := ota_general.value_changed( p_rec_old.tfh_information_category

Line 1967: := ota_general.value_changed( p_rec_old.tfh_information_category

1963: := ota_general.value_changed( p_rec_old.pym_attribute20
1964: , p_rec_new.pym_attribute20 );
1965: --
1966: l_tfh_info_category_changed boolean
1967: := ota_general.value_changed( p_rec_old.tfh_information_category
1968: , p_rec_new.tfh_information_category );
1969: --
1970: l_tfh_info1_changed boolean
1971: := ota_general.value_changed( p_rec_old.tfh_information1

Line 1971: := ota_general.value_changed( p_rec_old.tfh_information1

1967: := ota_general.value_changed( p_rec_old.tfh_information_category
1968: , p_rec_new.tfh_information_category );
1969: --
1970: l_tfh_info1_changed boolean
1971: := ota_general.value_changed( p_rec_old.tfh_information1
1972: , p_rec_new.tfh_information1 );
1973: --
1974: l_tfh_info2_changed boolean
1975: := ota_general.value_changed( p_rec_old.tfh_information2

Line 1975: := ota_general.value_changed( p_rec_old.tfh_information2

1971: := ota_general.value_changed( p_rec_old.tfh_information1
1972: , p_rec_new.tfh_information1 );
1973: --
1974: l_tfh_info2_changed boolean
1975: := ota_general.value_changed( p_rec_old.tfh_information2
1976: , p_rec_new.tfh_information2 );
1977: --
1978: l_tfh_info3_changed boolean
1979: := ota_general.value_changed( p_rec_old.tfh_information3

Line 1979: := ota_general.value_changed( p_rec_old.tfh_information3

1975: := ota_general.value_changed( p_rec_old.tfh_information2
1976: , p_rec_new.tfh_information2 );
1977: --
1978: l_tfh_info3_changed boolean
1979: := ota_general.value_changed( p_rec_old.tfh_information3
1980: , p_rec_new.tfh_information3 );
1981: --
1982: l_tfh_info4_changed boolean
1983: := ota_general.value_changed( p_rec_old.tfh_information4

Line 1983: := ota_general.value_changed( p_rec_old.tfh_information4

1979: := ota_general.value_changed( p_rec_old.tfh_information3
1980: , p_rec_new.tfh_information3 );
1981: --
1982: l_tfh_info4_changed boolean
1983: := ota_general.value_changed( p_rec_old.tfh_information4
1984: , p_rec_new.tfh_information4 );
1985: --
1986: l_tfh_info5_changed boolean
1987: := ota_general.value_changed( p_rec_old.tfh_information5

Line 1987: := ota_general.value_changed( p_rec_old.tfh_information5

1983: := ota_general.value_changed( p_rec_old.tfh_information4
1984: , p_rec_new.tfh_information4 );
1985: --
1986: l_tfh_info5_changed boolean
1987: := ota_general.value_changed( p_rec_old.tfh_information5
1988: , p_rec_new.tfh_information5 );
1989: --
1990: l_tfh_info6_changed boolean
1991: := ota_general.value_changed( p_rec_old.tfh_information6

Line 1991: := ota_general.value_changed( p_rec_old.tfh_information6

1987: := ota_general.value_changed( p_rec_old.tfh_information5
1988: , p_rec_new.tfh_information5 );
1989: --
1990: l_tfh_info6_changed boolean
1991: := ota_general.value_changed( p_rec_old.tfh_information6
1992: , p_rec_new.tfh_information6 );
1993: --
1994: l_tfh_info7_changed boolean
1995: := ota_general.value_changed( p_rec_old.tfh_information7

Line 1995: := ota_general.value_changed( p_rec_old.tfh_information7

1991: := ota_general.value_changed( p_rec_old.tfh_information6
1992: , p_rec_new.tfh_information6 );
1993: --
1994: l_tfh_info7_changed boolean
1995: := ota_general.value_changed( p_rec_old.tfh_information7
1996: , p_rec_new.tfh_information7 );
1997: --
1998: l_tfh_info8_changed boolean
1999: := ota_general.value_changed( p_rec_old.tfh_information8

Line 1999: := ota_general.value_changed( p_rec_old.tfh_information8

1995: := ota_general.value_changed( p_rec_old.tfh_information7
1996: , p_rec_new.tfh_information7 );
1997: --
1998: l_tfh_info8_changed boolean
1999: := ota_general.value_changed( p_rec_old.tfh_information8
2000: , p_rec_new.tfh_information8 );
2001: --
2002: l_tfh_info9_changed boolean
2003: := ota_general.value_changed( p_rec_old.tfh_information9

Line 2003: := ota_general.value_changed( p_rec_old.tfh_information9

1999: := ota_general.value_changed( p_rec_old.tfh_information8
2000: , p_rec_new.tfh_information8 );
2001: --
2002: l_tfh_info9_changed boolean
2003: := ota_general.value_changed( p_rec_old.tfh_information9
2004: , p_rec_new.tfh_information9 );
2005: --
2006: l_tfh_info10_changed boolean
2007: := ota_general.value_changed( p_rec_old.tfh_information10

Line 2007: := ota_general.value_changed( p_rec_old.tfh_information10

2003: := ota_general.value_changed( p_rec_old.tfh_information9
2004: , p_rec_new.tfh_information9 );
2005: --
2006: l_tfh_info10_changed boolean
2007: := ota_general.value_changed( p_rec_old.tfh_information10
2008: , p_rec_new.tfh_information10 );
2009: --
2010: l_tfh_info11_changed boolean
2011: := ota_general.value_changed( p_rec_old.tfh_information11

Line 2011: := ota_general.value_changed( p_rec_old.tfh_information11

2007: := ota_general.value_changed( p_rec_old.tfh_information10
2008: , p_rec_new.tfh_information10 );
2009: --
2010: l_tfh_info11_changed boolean
2011: := ota_general.value_changed( p_rec_old.tfh_information11
2012: , p_rec_new.tfh_information11 );
2013: --
2014: l_tfh_info12_changed boolean
2015: := ota_general.value_changed( p_rec_old.tfh_information12

Line 2015: := ota_general.value_changed( p_rec_old.tfh_information12

2011: := ota_general.value_changed( p_rec_old.tfh_information11
2012: , p_rec_new.tfh_information11 );
2013: --
2014: l_tfh_info12_changed boolean
2015: := ota_general.value_changed( p_rec_old.tfh_information12
2016: , p_rec_new.tfh_information12 );
2017: --
2018: l_tfh_info13_changed boolean
2019: := ota_general.value_changed( p_rec_old.tfh_information13

Line 2019: := ota_general.value_changed( p_rec_old.tfh_information13

2015: := ota_general.value_changed( p_rec_old.tfh_information12
2016: , p_rec_new.tfh_information12 );
2017: --
2018: l_tfh_info13_changed boolean
2019: := ota_general.value_changed( p_rec_old.tfh_information13
2020: , p_rec_new.tfh_information13 );
2021: --
2022: l_tfh_info14_changed boolean
2023: := ota_general.value_changed( p_rec_old.tfh_information14

Line 2023: := ota_general.value_changed( p_rec_old.tfh_information14

2019: := ota_general.value_changed( p_rec_old.tfh_information13
2020: , p_rec_new.tfh_information13 );
2021: --
2022: l_tfh_info14_changed boolean
2023: := ota_general.value_changed( p_rec_old.tfh_information14
2024: , p_rec_new.tfh_information14 );
2025: --
2026: l_tfh_info15_changed boolean
2027: := ota_general.value_changed( p_rec_old.tfh_information15

Line 2027: := ota_general.value_changed( p_rec_old.tfh_information15

2023: := ota_general.value_changed( p_rec_old.tfh_information14
2024: , p_rec_new.tfh_information14 );
2025: --
2026: l_tfh_info15_changed boolean
2027: := ota_general.value_changed( p_rec_old.tfh_information15
2028: , p_rec_new.tfh_information15 );
2029: --
2030: l_tfh_info16_changed boolean
2031: := ota_general.value_changed( p_rec_old.tfh_information16

Line 2031: := ota_general.value_changed( p_rec_old.tfh_information16

2027: := ota_general.value_changed( p_rec_old.tfh_information15
2028: , p_rec_new.tfh_information15 );
2029: --
2030: l_tfh_info16_changed boolean
2031: := ota_general.value_changed( p_rec_old.tfh_information16
2032: , p_rec_new.tfh_information16 );
2033: --
2034: l_tfh_info17_changed boolean
2035: := ota_general.value_changed( p_rec_old.tfh_information17

Line 2035: := ota_general.value_changed( p_rec_old.tfh_information17

2031: := ota_general.value_changed( p_rec_old.tfh_information16
2032: , p_rec_new.tfh_information16 );
2033: --
2034: l_tfh_info17_changed boolean
2035: := ota_general.value_changed( p_rec_old.tfh_information17
2036: , p_rec_new.tfh_information17 );
2037: --
2038: l_tfh_info18_changed boolean
2039: := ota_general.value_changed( p_rec_old.tfh_information18

Line 2039: := ota_general.value_changed( p_rec_old.tfh_information18

2035: := ota_general.value_changed( p_rec_old.tfh_information17
2036: , p_rec_new.tfh_information17 );
2037: --
2038: l_tfh_info18_changed boolean
2039: := ota_general.value_changed( p_rec_old.tfh_information18
2040: , p_rec_new.tfh_information18 );
2041: --
2042: l_tfh_info19_changed boolean
2043: := ota_general.value_changed( p_rec_old.tfh_information19

Line 2043: := ota_general.value_changed( p_rec_old.tfh_information19

2039: := ota_general.value_changed( p_rec_old.tfh_information18
2040: , p_rec_new.tfh_information18 );
2041: --
2042: l_tfh_info19_changed boolean
2043: := ota_general.value_changed( p_rec_old.tfh_information19
2044: , p_rec_new.tfh_information19 );
2045: --
2046: l_tfh_info20_changed boolean
2047: := ota_general.value_changed( p_rec_old.tfh_information20

Line 2047: := ota_general.value_changed( p_rec_old.tfh_information20

2043: := ota_general.value_changed( p_rec_old.tfh_information19
2044: , p_rec_new.tfh_information19 );
2045: --
2046: l_tfh_info20_changed boolean
2047: := ota_general.value_changed( p_rec_old.tfh_information20
2048: , p_rec_new.tfh_information20 );
2049: --
2050: Begin
2051: --

Line 2136: ota_general.value_changed( p_rec_old.payment_status_flag

2132: p_transaction_type = 'REINSTATE_HEADER' then
2133: --
2134: if check_update01_header( p_rec_old, p_rec_new ) or
2135: check_update02_header( p_rec_old, p_rec_new ) or
2136: ota_general.value_changed( p_rec_old.payment_status_flag
2137: , p_rec_new.payment_status_flag) then
2138: --
2139: fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');
2140: fnd_message.set_token('STEP','1');

Line 2148: ota_general.value_changed(p_rec_old.cancelled_flag

2144: else
2145: if p_rec_old.transfer_status = 'ST' then
2146: if check_update01_header( p_rec_old, p_rec_new ) or
2147: check_update02_header( p_rec_old, p_rec_new ) or
2148: ota_general.value_changed(p_rec_old.cancelled_flag
2149: ,p_rec_new.cancelled_flag) then
2150: --
2151: fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');
2152: fnd_message.set_token('STEP','2');

Line 2159: ota_general.value_changed( p_rec_old.payment_status_flag

2155: end if;
2156: if p_rec_old.cancelled_flag = 'Y' then
2157: if check_update01_header( p_rec_old, p_rec_new ) or
2158: check_update02_header( p_rec_old, p_rec_new ) or
2159: ota_general.value_changed( p_rec_old.payment_status_flag
2160: , p_rec_new.payment_status_flag) or
2161: ota_general.value_changed(p_rec_old.cancelled_flag
2162: ,p_rec_new.cancelled_flag) then
2163: --

Line 2161: ota_general.value_changed(p_rec_old.cancelled_flag

2157: if check_update01_header( p_rec_old, p_rec_new ) or
2158: check_update02_header( p_rec_old, p_rec_new ) or
2159: ota_general.value_changed( p_rec_old.payment_status_flag
2160: , p_rec_new.payment_status_flag) or
2161: ota_general.value_changed(p_rec_old.cancelled_flag
2162: ,p_rec_new.cancelled_flag) then
2163: --
2164: fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');
2165: fnd_message.set_token('STEP','3');

Line 2226: if not ota_general.check_fnd_user(p_administrator) then

2222: hr_utility.set_location('Entering:'|| v_proc, 5);
2223: --
2224: If p_administrator is NOT null Then
2225: --
2226: if not ota_general.check_fnd_user(p_administrator) then
2227: fnd_message.set_name('OTA','OTA_13291_TFH_ADMINISTRATOR');
2228: fnd_message.raise_error;
2229: end if;
2230: End if;