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

Line 35: hr_utility.set_location('Entering:'|| v_proc, 5);

31: v_proc varchar2(72) := g_package||'check_valid_header';
32: -----------------
33: Begin
34: --
35: hr_utility.set_location('Entering:'|| v_proc, 5);
36: --
37: if p_tfh_type = 'C' then
38: --
39: -- Finance header of type Cancellation

Line 68: hr_utility.set_location('Entering:'||v_proc, 5);

64: v_proc varchar2(72) := g_package||'check_type';
65: --
66: Begin
67: --
68: hr_utility.set_location('Entering:'||v_proc, 5);
69: --
70: If p_type is not null Then
71: ota_general.check_domain_value( 'FINANCE_LINE_TYPE', p_type);
72: --

Line 78: hr_utility.set_location(' Leaving:'||v_proc, 10);

74: fnd_message.set_name('OTA','OTA_13459_TFL_TYPE_NOT_FOUND');
75: fnd_message.raise_error;
76: End If;
77: --
78: hr_utility.set_location(' Leaving:'||v_proc, 10);
79: --
80: End check_line_type_domain;
81: --
82: -- ----------------------------------------------------------------------------

Line 108: hr_utility.set_location('Entering:'|| v_proc, 5);

104: v_proc varchar2(72) := g_package||'check_line_type';
105: -----------------
106: Begin
107: --
108: hr_utility.set_location('Entering:'|| v_proc, 5);
109: --
110: check_valid_header(p_finance_header_type,p_receivable_type);
111: --
112: check_line_type_domain(p_finance_line_type);

Line 139: hr_utility.set_location(' Leaving:'||v_proc, 10);

135: fnd_message.raise_error;
136: End if;
137: End if;
138: --
139: hr_utility.set_location(' Leaving:'||v_proc, 10);
140: --
141: end check_line_type;
142: --
143: -- ----------------------------------------------------------------------------

Line 161: hr_utility.set_location('Entering:'|| v_proc, 5);

157: v_proc varchar2(72) := g_package||'check_transfer_status';
158: --
159: Begin
160: --
161: hr_utility.set_location('Entering:'|| v_proc, 5);
162: --
163: If p_transfer_status is not null Then
164: --
165: ota_general.check_domain_value( 'GL_TRANSFER_STATUS', p_transfer_status);

Line 172: hr_utility.set_location(' Leaving:'|| v_proc, 10);

168: ota_tfl_api_shd.constraint_error( 'OTA_TFL_TRANSFER_STATUS_CHK');
169: --
170: End If;
171: --
172: hr_utility.set_location(' Leaving:'|| v_proc, 10);
173: --
174: End check_transfer_status;
175: --
176: -- ----------------------------------------------------------------------------

Line 189: hr_utility.set_location('Entering:'|| v_proc, 5);

185: v_proc varchar2(72) := g_package||'check_booking_deal_type';
186: ---------------
187: Begin
188: --
189: hr_utility.set_location('Entering:'|| v_proc, 5);
190: --
191: if p_receivable_type in (g_pre_purchase_payment,g_pre_purchase_use)
192: and p_booking_deal_type <> 'P' then
193: fnd_message.set_name('OTA','OTA_13456_TFL_WRONG_DEAL_TYPE');

Line 203: hr_utility.set_location(' Leaving:'|| v_proc, 10);

199: fnd_message.raise_error;
200: --
201: end if;
202: --
203: hr_utility.set_location(' Leaving:'|| v_proc, 10);
204: --
205: end check_booking_deal_type;
206: --
207: -- ----------------------------------------------------------------------------

Line 242: hr_utility.set_location('Entering:'|| v_proc, 5);

238: where booking_deal_id = p_booking_deal_id;
239: ---------------
240: Begin
241: --
242: hr_utility.set_location('Entering:'|| v_proc, 5);
243: --
244: Open csr_tbd;
245: Fetch csr_tbd into v_book_deal_customer_id
246: ,v_deal_type

Line 264: hr_utility.set_location(' Leaving:'|| v_proc, 10);

260: End if;
261: --
262: check_booking_deal_type(v_deal_type,v_receivable_type);
263: --
264: hr_utility.set_location(' Leaving:'|| v_proc, 10);
265: --
266: end check_booking_deal;
267: --
268: -- ----------------------------------------------------------------------------

Line 301: hr_utility.set_location('Entering:'|| v_proc, 5);

297: where tfh.finance_header_id = p_finance_header_id;
298: --
299: Begin
300: --
301: hr_utility.set_location('Entering:'|| v_proc, 5);
302: --
303: If p_resource_booking_id is NOT null AND
304: p_finance_header_id is NOT null Then
305: --

Line 349: hr_utility.set_location(' Leaving:'|| v_proc, 10);

345: End if;
346: --
347: End if;
348: --
349: hr_utility.set_location(' Leaving:'|| v_proc, 10);
350: --
351: End check_vendor;
352: --
353: -- ----------------------------------------------------------------------------

Line 389: hr_utility.set_location('Entering:'|| v_proc, 5);

385: where tfh.finance_header_id = p_finance_header_id;
386: --
387: Begin
388: --
389: hr_utility.set_location('Entering:'|| v_proc, 5);
390: --
391: if p_finance_header_id is not null and p_resource_allocation_id is not null
392: then
393: --

Line 446: hr_utility.set_location(' Leaving:'|| v_proc, 10);

442: End if;
443: --
444: End if;
445: --
446: hr_utility.set_location(' Leaving:'|| v_proc, 10);
447: --
448: End check_resource_charge;
449: --
450: -- ----------------------------------------------------------------------------

Line 484: hr_utility.set_location('Entering:'|| v_proc, 5);

480: where tfh.finance_header_id = p_finance_header_id;
481: --
482: Begin
483: --
484: hr_utility.set_location('Entering:'|| v_proc, 5);
485: null;
486: /**********************
487: This procedure has been omitted until further clarification is received
488: --

Line 580: hr_utility.set_location('Entering:'|| v_proc, 5);

576: and tpl.price_list_id (+) = tbd.price_list_id;
577: --
578: Begin
579: --
580: hr_utility.set_location('Entering:'|| v_proc, 5);
581: --
582: Open sel_pricelist_type;
583: Fetch sel_pricelist_type into v_book_deal_type
584: , v_price_list_type;

Line 619: hr_utility.set_location(' Leaving:'|| v_proc, 10);

615: End if;
616: --
617: End if;
618: --
619: hr_utility.set_location(' Leaving:'|| v_proc, 10);
620: --
621: End check_pre_purchase_units;
622: --
623: -- ----------------------------------------------------------------------------

Line 743: hr_utility.set_location('Entering:'|| v_proc, 5);

739: --
740: v_finance_header_type varchar2(30);
741: Begin
742: --
743: hr_utility.set_location('Entering:'|| v_proc, 5);
744: --
745: if p_finance_header_id is not null then
746: open csr_header_type;
747: fetch csr_header_type into v_finance_header_type;

Line 788: hr_utility.set_location('Entering:'|| v_proc, 5);

784: fnd_message.set_name('OTA','OTA_13589_USER_FIN_TYPE_ERROR');
785: fnd_message.raise_error;
786: end if;
787:
788: hr_utility.set_location('Entering:'|| v_proc, 5);
789: --
790: end check_type_and_amounts;
791: --
792: -- ----------------------------------------------------------------------------

Line 809: hr_utility.set_location('Entering:'|| v_proc, 5);

805: v_proc varchar2(72) := g_package||'check_update_attributes';
806: --
807: Begin
808: --
809: hr_utility.set_location('Entering:'|| v_proc, 5);
810: --
811: If p_transfer_status = 'ST' Then
812: --
813: fnd_message.set_name('OTA','OTA_13355_TFL_UPDATE');

Line 818: hr_utility.set_location(' Leaving:'|| v_proc, 10);

814: fnd_message.raise_error;
815: --
816: End if;
817: --
818: hr_utility.set_location(' Leaving:'|| v_proc, 10);
819: --
820: End check_update_attributes;
821: --
822: -- ----------------------------------------------------------------------------

Line 839: hr_utility.set_location('Entering:'|| v_proc, 5);

835: v_proc varchar2(72) := g_package||'check_cancelled_flag';
836: --
837: Begin
838: --
839: hr_utility.set_location('Entering:'|| v_proc, 5);
840: --
841: ota_general.check_domain_value('YES_NO',p_cancelled_flag);
842: --
843: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 843: hr_utility.set_location(' Leaving:'|| v_proc, 10);

839: hr_utility.set_location('Entering:'|| v_proc, 5);
840: --
841: ota_general.check_domain_value('YES_NO',p_cancelled_flag);
842: --
843: hr_utility.set_location(' Leaving:'|| v_proc, 10);
844: --
845: End check_cancelled_flag;
846: --
847: -- ----------------------------------------------------------------------------

Line 873: hr_utility.set_location('Entering:'|| v_proc, 5);

869: and tfl.sequence_number = p_sequence_number;
870: --
871: Begin
872: --
873: hr_utility.set_location('Entering:'|| v_proc, 5);
874: --
875: If p_finance_header_id is not null Then
876: --
877: If p_sequence_number <= 0 OR

Line 903: hr_utility.set_location(' Leaving:'|| v_proc, 10);

899: End if;
900: --
901: End if;
902: --
903: hr_utility.set_location(' Leaving:'|| v_proc, 10);
904: --
905: End check_sequence_number;
906: --
907: -- ----------------------------------------------------------------------------

Line 931: hr_utility.set_location('Entering:'|| v_proc, 5);

927: where tfl.finance_header_id = p_finance_header_id;
928: --
929: Begin
930: --
931: hr_utility.set_location('Entering:'|| v_proc, 5);
932: --
933: If p_finance_header_id is not null Then
934: --
935: Open get_sequence_number;

Line 958: hr_utility.set_location(' Leaving:'|| v_proc, 10);

954: p_sequence_number := 10;
955: --
956: End if;
957: --
958: hr_utility.set_location(' Leaving:'|| v_proc, 10);
959: --
960: End get_next_sequence_number;
961: --
962: -- ----------------------------------------------------------------------------

Line 986: hr_utility.set_location('Entering:'|| v_proc, 5);

982: where tfh.finance_header_id = p_finance_header_id;
983: --
984: Begin
985: --
986: hr_utility.set_location('Entering:'|| v_proc, 5);
987: if p_date_raised is null then
988: --
989: If p_finance_header_id is not null Then
990: --

Line 1014: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1010: --
1011: End if;
1012: end if;
1013: --
1014: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1015: --
1016: End get_date_raised;
1017: --
1018: -- ----------------------------------------------------------------------------

Line 1036: hr_utility.set_location('Entering:'|| v_proc, 5);

1032: v_proc varchar2(72) := g_package||'check_delete_attempt';
1033: --
1034: Begin
1035: --
1036: hr_utility.set_location('Entering:'|| v_proc, 5);
1037: --
1038: fnd_message.set_name('OTA','OTA_13357_TFL_DELETE');
1039: fnd_message.raise_error;
1040: --

Line 1041: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1037: --
1038: fnd_message.set_name('OTA','OTA_13357_TFL_DELETE');
1039: fnd_message.raise_error;
1040: --
1041: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1042: --
1043: End check_delete_attempt;
1044: --
1045: -- ----------------------------------------------------------------------------

Line 1111: hr_utility.set_location('Entering:'|| v_proc, 5);

1107: and evt.event_id(+) = trb.event_id;*/
1108: --
1109: Begin
1110: --
1111: hr_utility.set_location('Entering:'|| v_proc, 5);
1112: --
1113: Open sel_finance_currency;
1114: Fetch sel_finance_currency into v_header_currency_code,v_type;
1115: --

Line 1215: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1211: --
1212: End if;
1213: --
1214: End if;
1215: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1216: --
1217: End check_currency_code;
1218: --
1219: -- ----------------------------------------------------------------------------

Line 1271: hr_utility.set_location('Entering:'|| v_proc, 5);

1267: and evt.event_id = trb.event_id;
1268: --
1269: Begin
1270: --
1271: hr_utility.set_location('Entering:'|| v_proc, 5);
1272: --
1273: --
1274: If p_finance_line_type = 'V' Then
1275: --

Line 1356: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1352: p_currency_code := v_line_currency_code;
1353: --
1354: End if;
1355: --
1356: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1357: --
1358: End get_currency_code;
1359: --
1360: -- ----------------------------------------------------------------------------

Line 1388: hr_utility.set_location('Entering:'|| v_proc, 5);

1384: l_tfh_receivable_type varchar2(30);
1385: --------------
1386: begin
1387: --
1388: hr_utility.set_location('Entering:'|| v_proc, 5);
1389: --
1390: Open csr_tfh;
1391: Fetch csr_tfh into l_tfh_type,l_tfh_receivable_type;
1392: Close csr_tfh;

Line 1444: hr_utility.set_location('Entering:'|| v_proc, 5);

1440: or (p_line_type = 'V' and
1441: resource_booking_id = p_resource_booking_id));
1442: --
1443: begin
1444: hr_utility.set_location('Entering:'|| v_proc, 5);
1445: --
1446: if p_line_type in ('E','R','V','CT') then
1447: open find_other_lines;
1448: fetch find_other_lines into l_finance_line_id;

Line 1458: hr_utility.set_location('Leaving:'|| v_proc, 10);

1454: end if;
1455: close find_other_lines;
1456: end if;
1457: --
1458: hr_utility.set_location('Leaving:'|| v_proc, 10);
1459: end;
1460:
1461: --
1462: -- ---------------------------------------------------------------------------

Line 1497: hr_utility.set_location('Entering:'||l_proc, 5);

1493: from ota_finance_headers
1494: where superceding_header_id = p_finance_header_id;
1495: --
1496: begin
1497: hr_utility.set_location('Entering:'||l_proc, 5);
1498: --
1499: open get_finance_header;
1500: fetch get_finance_header into p_tfh_type,
1501: p_customer_id,

Line 1515: hr_utility.set_location('Leaving:'||l_proc, 10);

1511: p_tfh_superseded_flag := 'N';
1512: close get_superseding_header;
1513: end if;
1514: --
1515: hr_utility.set_location('Leaving:'||l_proc, 10);
1516: end get_finance_header;
1517: --
1518: --
1519: -- ---------------------------------------------------------------------------

Line 1534: hr_utility.set_location('Entering:'||l_proc, 5);

1530: ,p_check_cancelled_flag in boolean
1531: ,p_check_successful_transfer in boolean) is
1532: l_proc varchar2(72) := g_package||'check_finance_header';
1533: begin
1534: hr_utility.set_location('Entering:'||l_proc, 5);
1535: if p_type = 'C' then
1536: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');
1537: fnd_message.set_token('STEP','1');
1538: fnd_message.raise_error;

Line 1549: hr_utility.trace('Superseded Flag = '||p_superseded_flag);

1545: Superseded_flag = 'Y'. We therefore do not want to repeat checks on
1546: these attributes.
1547: */
1548: if p_check_successful_transfer then
1549: hr_utility.trace('Superseded Flag = '||p_superseded_flag);
1550: if p_superseded_flag = 'Y' then
1551: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');
1552: fnd_message.set_token('STEP','2');
1553: fnd_message.raise_error;

Line 1558: hr_utility.trace('Transfer Status = '||p_transfer_status);

1554: end if;
1555: end if;
1556: --
1557: if p_check_successful_transfer then
1558: hr_utility.trace('Transfer Status = '||p_transfer_status);
1559: if p_transfer_status = 'ST' then
1560: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');
1561: fnd_message.set_token('STEP','3');
1562: fnd_message.raise_error;

Line 1564: hr_utility.trace('After Transfer Status Check');

1560: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');
1561: fnd_message.set_token('STEP','3');
1562: fnd_message.raise_error;
1563: end if;
1564: hr_utility.trace('After Transfer Status Check');
1565: end if;
1566: --
1567: if p_check_cancelled_flag then
1568: hr_utility.trace('Cancelled Flag = '||p_cancelled_flag);

Line 1568: hr_utility.trace('Cancelled Flag = '||p_cancelled_flag);

1564: hr_utility.trace('After Transfer Status Check');
1565: end if;
1566: --
1567: if p_check_cancelled_flag then
1568: hr_utility.trace('Cancelled Flag = '||p_cancelled_flag);
1569: if p_cancelled_flag = 'Y' then
1570: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');
1571: fnd_message.set_token('STEP','4');
1572: fnd_message.raise_error;

Line 1576: hr_utility.set_location('Leaving:'||l_proc, 10);

1572: fnd_message.raise_error;
1573: end if;
1574: end if;
1575: --
1576: hr_utility.set_location('Leaving:'||l_proc, 10);
1577: end check_finance_header;
1578:
1579: end ota_tfl_api_business_rules;