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_TFH_API_SHD

Line 36: ota_tfh_api_shd.constraint_error( 'OTA_TFH_TYPE_CHK');

32: --
33: Else
34: -- column is a not null field **** change message later
35: --
36: ota_tfh_api_shd.constraint_error( 'OTA_TFH_TYPE_CHK');
37: --
38: End If;
39: --
40: hr_utility.set_location(' Leaving:'||v_proc, 10);

Line 70: ota_tfh_api_shd.constraint_error( 'OTA_TFH_TRANSFER_STATUS_CHK');

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');
71: --
72: End If;
73: --
74: --

Line 268: ota_tfh_api_shd.constraint_error( 'OTA_TFH_RECEIVABLE_ATTRIBUTES');

264: p_vendor_id is NOT null OR
265: p_vendor_contact_id is NOT null OR
266: p_vendor_address_id is NOT null Then
267: --
268: ota_tfh_api_shd.constraint_error( 'OTA_TFH_RECEIVABLE_ATTRIBUTES');
269: --
270: End if;
271: --
272: End If;

Line 597: ota_tfh_api_shd.constraint_error( 'OTA_TFH_PAYABLE_ATTRIBUTES');

593: p_customer_id is NOT null OR
594: p_customer_contact_id is NOT null OR
595: p_customer_address_id is NOT null Then
596: --
597: ota_tfh_api_shd.constraint_error( 'OTA_TFH_PAYABLE_ATTRIBUTES');
598: --
599: End if;
600: --
601: End If;

Line 628: ota_tfh_api_shd.constraint_error( 'OTA_TFH_CANCELLED_FLAG_CHK');

624: hr_utility.set_location('Entering:'|| v_proc, 5);
625: --
626: If NOT (p_flag in ('N', 'Y')) then
627: --
628: ota_tfh_api_shd.constraint_error( 'OTA_TFH_CANCELLED_FLAG_CHK');
629: --
630: End If;
631: --
632: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 694: p_rec_finance in out nocopy ota_tfh_api_shd.g_rec_type

690: -- will then be called.
691: --
692: Procedure cancel_header
693: (
694: p_rec_finance in out nocopy ota_tfh_api_shd.g_rec_type
695: ,p_cancel_header_id out nocopy number
696: ,p_date_raised in date
697: ,p_validate in boolean
698: ) is

Line 700: l_rec_cancel ota_tfh_api_shd.g_rec_type;

696: ,p_date_raised in date
697: ,p_validate in boolean
698: ) is
699: --
700: l_rec_cancel ota_tfh_api_shd.g_rec_type;
701: v_proc varchar2(72) := g_package||'cancel_header';
702: --
703: Begin
704: --

Line 833: l_rec_cancel ota_tfh_api_shd.g_rec_type;

829: ,p_validate in boolean
830: ,p_commit in boolean default FALSE
831: ) is
832: --
833: l_rec_cancel ota_tfh_api_shd.g_rec_type;
834: v_proc varchar2(72) := g_package||'cancel_header';
835: --
836: cursor sel_finance_header is
837: select finance_header_id,

Line 1067: l_rec_cancel ota_tfh_api_shd.g_rec_type;

1063: ,p_commit in boolean default FALSE
1064: ) is
1065: --
1066: v_rec_header ota_finance_headers%rowtype;
1067: l_rec_cancel ota_tfh_api_shd.g_rec_type;
1068: v_proc varchar2(72) := g_package||'recancel_header';
1069: --
1070: cursor sel_finance_header is
1071: select *

Line 1205: ota_tfh_api_shd.constraint_error( 'OTA_TFH_CANCELLED_ATTRIBUTES');

1201: p_customer_address_id is NOT null OR
1202: p_invoice_address is NOT null OR
1203: p_invoice_contact is NOT null Then
1204: --
1205: ota_tfh_api_shd.constraint_error( 'OTA_TFH_CANCELLED_ATTRIBUTES');
1206: --
1207: End if;
1208: --
1209: End If;

Line 1377: p_rec_finance in out nocopy ota_tfh_api_shd.g_rec_type

1373: -- 'N' by default.
1374: --
1375: Procedure cancel_and_recreate
1376: (
1377: p_rec_finance in out nocopy ota_tfh_api_shd.g_rec_type
1378: ,p_date_raised in date
1379: ,p_validate in boolean
1380: ) is
1381: --

Line 1382: l_rec_new ota_tfh_api_shd.g_rec_type;

1378: ,p_date_raised in date
1379: ,p_validate in boolean
1380: ) is
1381: --
1382: l_rec_new ota_tfh_api_shd.g_rec_type;
1383: l_cancel_header_id number;
1384: v_proc varchar2(72) := g_package||'cancel_and_recreate';
1385: --
1386: Begin

Line 1484: v_rec_header ota_tfh_api_shd.g_rec_type;

1480: ,p_validate in boolean
1481: ,p_commit in boolean default FALSE
1482: ) is
1483: --
1484: v_rec_header ota_tfh_api_shd.g_rec_type;
1485: v_cursor_boolean boolean;
1486: v_validate boolean;
1487: v_date_raised date;
1488: v_proc varchar2(72) := g_package||'cancel_and_recreate';

Line 1722: ota_tfh_api_shd.constraint_error( 'OTA_TFH_CHECK_TRANSFER_ATTRIBUTES');

1718: If p_transfer_status <> 'NT' Then
1719: --
1720: If p_payment_method is null Then
1721: --
1722: ota_tfh_api_shd.constraint_error( 'OTA_TFH_CHECK_TRANSFER_ATTRIBUTES');
1723: --
1724: End if;
1725: --
1726: End If;

Line 1741: p_rec_old in ota_tfh_api_shd.g_rec_type

1737: -- Description:
1738: --
1739: Function check_update01_header
1740: (
1741: p_rec_old in ota_tfh_api_shd.g_rec_type
1742: ,p_rec_new in ota_tfh_api_shd.g_rec_type
1743: ) Return Boolean is
1744: --
1745: v_proc varchar2(72) := g_package||'check_update01_header';

Line 1742: ,p_rec_new in ota_tfh_api_shd.g_rec_type

1738: --
1739: Function check_update01_header
1740: (
1741: p_rec_old in ota_tfh_api_shd.g_rec_type
1742: ,p_rec_new in ota_tfh_api_shd.g_rec_type
1743: ) Return Boolean is
1744: --
1745: v_proc varchar2(72) := g_package||'check_update01_header';
1746: --

Line 1876: p_rec_old in ota_tfh_api_shd.g_rec_type

1872: -- Description:
1873: --
1874: Function check_update02_header
1875: (
1876: p_rec_old in ota_tfh_api_shd.g_rec_type
1877: ,p_rec_new in ota_tfh_api_shd.g_rec_type
1878: ) Return Boolean is
1879: --
1880: v_proc varchar2(72) := g_package||'check_update02_header';

Line 1877: ,p_rec_new in ota_tfh_api_shd.g_rec_type

1873: --
1874: Function check_update02_header
1875: (
1876: p_rec_old in ota_tfh_api_shd.g_rec_type
1877: ,p_rec_new in ota_tfh_api_shd.g_rec_type
1878: ) Return Boolean is
1879: --
1880: v_proc varchar2(72) := g_package||'check_update02_header';
1881: --

Line 2120: p_rec_old in ota_tfh_api_shd.g_rec_type

2116: -- Enforced by the constraint 'OTA_TFH_CHECK_UPDATE'
2117: --
2118: Procedure check_update_header
2119: (
2120: p_rec_old in ota_tfh_api_shd.g_rec_type
2121: ,p_rec_new in ota_tfh_api_shd.g_rec_type
2122: ,p_transaction_type in varchar2
2123: ) is
2124: --

Line 2121: ,p_rec_new in ota_tfh_api_shd.g_rec_type

2117: --
2118: Procedure check_update_header
2119: (
2120: p_rec_old in ota_tfh_api_shd.g_rec_type
2121: ,p_rec_new in ota_tfh_api_shd.g_rec_type
2122: ,p_transaction_type in varchar2
2123: ) is
2124: --
2125: v_proc varchar2(72) := g_package||'check_update_header';

Line 2197: ota_tfh_api_shd.constraint_error( 'OTA_TFH_PAYMENT_STATUS_FLA_CHK');

2193: hr_utility.set_location('Entering:'|| v_proc, 5);
2194: --
2195: If NOT (p_flag in ('N', 'Y')) then
2196: --
2197: ota_tfh_api_shd.constraint_error( 'OTA_TFH_PAYMENT_STATUS_FLA_CHK');
2198: --
2199: End If;
2200: --
2201: hr_utility.set_location(' Leaving:'|| v_proc, 10);