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

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

38: where trb.resource_booking_id = p_resource_booking_id;
39: --
40: Begin
41: --
42: hr_utility.set_location('Entering:'|| v_proc, 5);
43: --
44: Open sel_type_V_amounts;
45: Fetch sel_type_V_amounts into v_absolute_price;
46: --

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

65: End if;
66: --
67: End if;
68: --
69: hr_utility.set_location(' Leaving:'|| v_proc, 10);
70: --
71: End set_type_V_amounts;
72: --
73: -- ----------------------------------------------------------------------------

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

100: and trb.resource_booking_id = tra.equipment_resource_booking_id;
101: --
102: Begin
103: --
104: hr_utility.set_location('Entering:'|| v_proc, 5);
105: --
106: Open sel_type_R_amounts;
107: Fetch sel_type_R_amounts into v_absolute_price;
108: --

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

127: End if;
128: --
129: End if;
130: --
131: hr_utility.set_location(' Leaving:'|| v_proc, 10);
132: --
133: End set_type_R_amounts;
134: --
135: -- ----------------------------------------------------------------------------

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

167: and tpl.price_list_id = tbd.price_list_id;
168: --
169: Begin
170: --
171: hr_utility.set_location('Entering:'|| v_proc, 5);
172: --
173: Open sel_type_P_amounts;
174: Fetch sel_type_P_amounts into v_discount_percentage
175: , v_price_list_type

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

212: End if;
213: --
214: End if;
215: --
216: hr_utility.set_location(' Leaving:'|| v_proc, 10);
217: --
218: End set_type_P_amounts;
219: --
220: -- ----------------------------------------------------------------------------

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

262: and nvl(tbd.end_date,evt.course_start_date);
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'|| v_proc, 5);
267: --
268: Open sel_book_deal_info;
269: Fetch sel_book_deal_info into p_book_deal_type
270: , p_discount_percentage

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

285: End if;
286: --
287: Close sel_book_deal_info;
288: --
289: hr_utility.set_location(' Leaving:'|| v_proc, 10);
290: --
291: End get_booking_deal_info;
292: --
293: -- ----------------------------------------------------------------------------

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

370: ));
371: --
372: Begin
373: --
374: hr_utility.set_location('Entering:'|| v_proc, 5);
375: --
376: -- Values of parameters
377: --
378: hr_utility.trace(p_price_list_type);

Line 378: hr_utility.trace(p_price_list_type);

374: hr_utility.set_location('Entering:'|| v_proc, 5);
375: --
376: -- Values of parameters
377: --
378: hr_utility.trace(p_price_list_type);
379: hr_utility.trace(p_price_list_id);
380: hr_utility.trace(p_event_id);
381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);

Line 379: hr_utility.trace(p_price_list_id);

375: --
376: -- Values of parameters
377: --
378: hr_utility.trace(p_price_list_type);
379: hr_utility.trace(p_price_list_id);
380: hr_utility.trace(p_event_id);
381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);

Line 380: hr_utility.trace(p_event_id);

376: -- Values of parameters
377: --
378: hr_utility.trace(p_price_list_type);
379: hr_utility.trace(p_price_list_id);
380: hr_utility.trace(p_event_id);
381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);

Line 381: hr_utility.trace(p_activity_version_id);

377: --
378: hr_utility.trace(p_price_list_type);
379: hr_utility.trace(p_price_list_id);
380: hr_utility.trace(p_event_id);
381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);

Line 382: hr_utility.trace(p_price_basis);

378: hr_utility.trace(p_price_list_type);
379: hr_utility.trace(p_price_list_id);
380: hr_utility.trace(p_event_id);
381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);

Line 383: hr_utility.trace(p_standard_amount);

379: hr_utility.trace(p_price_list_id);
380: hr_utility.trace(p_event_id);
381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);

Line 384: hr_utility.trace(p_unitary_amount);

380: hr_utility.trace(p_event_id);
381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);

Line 385: hr_utility.trace(p_money_amount);

381: hr_utility.trace(p_activity_version_id);
382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);
389: hr_utility.trace(p_discount_percentage);

Line 386: hr_utility.trace(p_single_unit_price);

382: hr_utility.trace(p_price_basis);
383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);
389: hr_utility.trace(p_discount_percentage);
390: hr_utility.trace(p_number_of_places);

Line 387: hr_utility.trace(p_currency_code);

383: hr_utility.trace(p_standard_amount);
384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);
389: hr_utility.trace(p_discount_percentage);
390: hr_utility.trace(p_number_of_places);
391: hr_utility.trace(p_cust_no_places);

Line 388: hr_utility.trace(p_currency_precision);

384: hr_utility.trace(p_unitary_amount);
385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);
389: hr_utility.trace(p_discount_percentage);
390: hr_utility.trace(p_number_of_places);
391: hr_utility.trace(p_cust_no_places);
392: --

Line 389: hr_utility.trace(p_discount_percentage);

385: hr_utility.trace(p_money_amount);
386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);
389: hr_utility.trace(p_discount_percentage);
390: hr_utility.trace(p_number_of_places);
391: hr_utility.trace(p_cust_no_places);
392: --
393: --

Line 390: hr_utility.trace(p_number_of_places);

386: hr_utility.trace(p_single_unit_price);
387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);
389: hr_utility.trace(p_discount_percentage);
390: hr_utility.trace(p_number_of_places);
391: hr_utility.trace(p_cust_no_places);
392: --
393: --
394: Open sel_type_E_tpe_event;

Line 391: hr_utility.trace(p_cust_no_places);

387: hr_utility.trace(p_currency_code);
388: hr_utility.trace(p_currency_precision);
389: hr_utility.trace(p_discount_percentage);
390: hr_utility.trace(p_number_of_places);
391: hr_utility.trace(p_cust_no_places);
392: --
393: --
394: Open sel_type_E_tpe_event;
395: Fetch sel_type_E_tpe_event into v_tpe_price, v_evt_price;

Line 460: hr_utility.trace(p_price_list_type);

456: End if;
457: --
458: End if;
459: --
460: hr_utility.trace(p_price_list_type);
461: hr_utility.trace(p_price_list_id);
462: hr_utility.trace(p_event_id);
463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);

Line 461: hr_utility.trace(p_price_list_id);

457: --
458: End if;
459: --
460: hr_utility.trace(p_price_list_type);
461: hr_utility.trace(p_price_list_id);
462: hr_utility.trace(p_event_id);
463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);

Line 462: hr_utility.trace(p_event_id);

458: End if;
459: --
460: hr_utility.trace(p_price_list_type);
461: hr_utility.trace(p_price_list_id);
462: hr_utility.trace(p_event_id);
463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);

Line 463: hr_utility.trace(p_activity_version_id);

459: --
460: hr_utility.trace(p_price_list_type);
461: hr_utility.trace(p_price_list_id);
462: hr_utility.trace(p_event_id);
463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);

Line 464: hr_utility.trace(p_price_basis);

460: hr_utility.trace(p_price_list_type);
461: hr_utility.trace(p_price_list_id);
462: hr_utility.trace(p_event_id);
463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);

Line 465: hr_utility.trace(p_standard_amount);

461: hr_utility.trace(p_price_list_id);
462: hr_utility.trace(p_event_id);
463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);

Line 466: hr_utility.trace(p_unitary_amount);

462: hr_utility.trace(p_event_id);
463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);

Line 467: hr_utility.trace(p_money_amount);

463: hr_utility.trace(p_activity_version_id);
464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);
471: hr_utility.trace(p_discount_percentage);

Line 468: hr_utility.trace(p_single_unit_price);

464: hr_utility.trace(p_price_basis);
465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);
471: hr_utility.trace(p_discount_percentage);
472: hr_utility.trace(p_number_of_places);

Line 469: hr_utility.trace(p_currency_code);

465: hr_utility.trace(p_standard_amount);
466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);
471: hr_utility.trace(p_discount_percentage);
472: hr_utility.trace(p_number_of_places);
473: hr_utility.trace(p_cust_no_places);

Line 470: hr_utility.trace(p_currency_precision);

466: hr_utility.trace(p_unitary_amount);
467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);
471: hr_utility.trace(p_discount_percentage);
472: hr_utility.trace(p_number_of_places);
473: hr_utility.trace(p_cust_no_places);
474: --

Line 471: hr_utility.trace(p_discount_percentage);

467: hr_utility.trace(p_money_amount);
468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);
471: hr_utility.trace(p_discount_percentage);
472: hr_utility.trace(p_number_of_places);
473: hr_utility.trace(p_cust_no_places);
474: --
475: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 472: hr_utility.trace(p_number_of_places);

468: hr_utility.trace(p_single_unit_price);
469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);
471: hr_utility.trace(p_discount_percentage);
472: hr_utility.trace(p_number_of_places);
473: hr_utility.trace(p_cust_no_places);
474: --
475: hr_utility.set_location(' Leaving:'|| v_proc, 10);
476: --

Line 473: hr_utility.trace(p_cust_no_places);

469: hr_utility.trace(p_currency_code);
470: hr_utility.trace(p_currency_precision);
471: hr_utility.trace(p_discount_percentage);
472: hr_utility.trace(p_number_of_places);
473: hr_utility.trace(p_cust_no_places);
474: --
475: hr_utility.set_location(' Leaving:'|| v_proc, 10);
476: --
477: End set_type_E_tpe_amounts;

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

471: hr_utility.trace(p_discount_percentage);
472: hr_utility.trace(p_number_of_places);
473: hr_utility.trace(p_cust_no_places);
474: --
475: hr_utility.set_location(' Leaving:'|| v_proc, 10);
476: --
477: End set_type_E_tpe_amounts;
478: --
479: --

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

513: and evt.currency_code = p_currency_code;
514: --
515: Begin
516: --
517: hr_utility.set_location('Entering:'|| v_proc, 5);
518: --
519: -- * Take Event for searching
520: --
521: If p_event_id is NOT null Then

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

591: and evt.currency_code = p_currency_code;
592: --
593: Begin
594: --
595: hr_utility.set_location('Entering:'|| v_proc, 5);
596: --
597: --
598: Open sel_type_E_tav_event;
599: Fetch sel_type_E_tav_event into v_standard_price;

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

626: End if;
627: --
628: End if;
629: --
630: hr_utility.set_location(' Leaving:'|| v_proc, 10);
631: --
632: End set_type_E_tav_amounts;
633: --
634: -- ----------------------------------------------------------------------------

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

669: and evt.currency_code = p_currency_code;
670: --
671: Begin
672: --
673: hr_utility.set_location('Entering:'|| v_proc, 5);
674: --
675: -- Take Event and Activity Version for searching
676: --
677: Open sel_type_E_cat_event;

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

705: End if;
706: --
707: End if;
708: --
709: hr_utility.set_location(' Leaving:'|| v_proc, 10);
710: --
711: End set_type_E_cat_amounts;
712: --
713: -- ----------------------------------------------------------------------------

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

741: and evt.currency_code = p_currency_code;
742: --
743: Begin
744: --
745: hr_utility.set_location('Entering:'|| v_proc, 5);
746: --
747: --
748: If p_event_id is not null then
749: Open sel_event_no_deal;

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

776: End if;
777: --
778: End if;
779: --
780: hr_utility.set_location(' Leaving:'|| v_proc, 10);
781: --
782: End set_no_deal_amounts;
783: --
784: -- ----------------------------------------------------------------------------

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

838: and tdb.event_id = evt.event_id;
839:
840: Begin
841: --
842: hr_utility.set_location('Entering:'|| v_proc, 5);
843: --
844: open get_currency_precision;
845: fetch get_currency_precision into v_currency_precision;
846: close get_currency_precision;

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

1030: End if;
1031: --
1032: End if;
1033: --
1034: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1035: --
1036: End set_all_amounts;
1037: --
1038: -- ----------------------------------------------------------------------------

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

1058: --Bug 1664464
1059: --
1060: Begin
1061: --
1062: hr_utility.set_location('Entering:'|| v_proc, 5);
1063: --
1064: -- For 7.3.2
1065: -- p_rec_finance_line.finance_header_id := p_finance_header_id_to;
1066: -- p_rec_finance_line.finance_line_id := null;

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

1130: , p_rec_finance_line.tfl_information20
1131: , p_validate => false
1132: , p_transaction_type => p_transaction_type);
1133: --
1134: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1135: --
1136: End copy_finance_line;
1137: --
1138: -- ----------------------------------------------------------------------------

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

1162: order by sequence_number;
1163: --
1164: Begin
1165: --
1166: hr_utility.set_location('Entering:'|| v_proc, 5);
1167: --
1168: If p_finance_header_id_from is NOT null Then
1169: --
1170: If p_finance_header_id_to is null OR

Line 1191: hr_utility.trace('Finance Line ID = '||to_char(l_rec_finance_line.finance_line_id)) ;

1187: Loop
1188: --
1189: Exit when sel_finance_lines%notfound;
1190: --
1191: hr_utility.trace('Finance Line ID = '||to_char(l_rec_finance_line.finance_line_id)) ;
1192: copy_finance_line( p_finance_header_id_to
1193: , l_rec_finance_line
1194: ,p_transaction_type => 'COPY');
1195: --

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

1202: End if;
1203: --
1204: End if;
1205: --
1206: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1207: --
1208: End copy_lines_to_new_header;
1209: --
1210: -- ----------------------------------------------------------------------------

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

1228: v_proc varchar2(72) := g_package||'update_cancel_flag';
1229: --
1230: Begin
1231: --
1232: hr_utility.set_location('Entering:'|| v_proc, 5);
1233: --
1234: If p_rec_cancel.finance_line_id is null Then
1235: --
1236: fnd_message.set_name('OTA','OTA_13360_TFL_CANCEL_LINES');

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

1235: --
1236: fnd_message.set_name('OTA','OTA_13360_TFL_CANCEL_LINES');
1237: fnd_message.raise_error;
1238: --
1239: hr_utility.set_location('Entering:'|| v_proc, 5);
1240: Else
1241: --
1242: -- Cancel the finance_lines record
1243: --

Line 1246: hr_utility.set_location('Entering:'|| v_proc, 15);

1242: -- Cancel the finance_lines record
1243: --
1244: p_rec_cancel.cancelled_flag := p_new_cancelled_flag;
1245: --
1246: hr_utility.set_location('Entering:'|| v_proc, 15);
1247: ota_tfl_api_upd.upd
1248: ( p_finance_line_id => p_rec_cancel.finance_line_id
1249: , p_date_raised => p_rec_cancel.date_raised
1250: , p_cancelled_flag => p_rec_cancel.cancelled_flag

Line 1260: hr_utility.set_location(' Leaving:'|| v_proc, 15);

1256: p_object_version_number := p_rec_cancel.object_version_number;
1257: --
1258: End if;
1259: --
1260: hr_utility.set_location(' Leaving:'|| v_proc, 15);
1261: --
1262: End update_cancel_flag;
1263: --
1264: -- ----------------------------------------------------------------------------

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

1287: where tfl.finance_header_id = p_finance_header_id;
1288: --
1289: Begin
1290: --
1291: hr_utility.set_location('Entering:'|| v_proc, 5);
1292: --
1293: If p_finance_header_id is NOT null Then
1294: --
1295: Open sel_finance_lines;

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

1332: End if;
1333: --
1334: End if;
1335: --
1336: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1337: --
1338: End set_cancel_flag_for_header;
1339: -- ----------------------------------------------------------------------------
1340: -- |------------------------< cancel_finance_line >---------------------------|

Line 1375: hr_utility.set_location('Entering:'|| v_proc, 1);

1371: where tfh.finance_header_id = p_finance_header_id;
1372: --
1373: Begin
1374: --
1375: hr_utility.set_location('Entering:'|| v_proc, 1);
1376: --
1377: If p_finance_line_id is null Then
1378: hr_utility.set_location('Entering:'|| v_proc, 2);
1379: --

Line 1378: hr_utility.set_location('Entering:'|| v_proc, 2);

1374: --
1375: hr_utility.set_location('Entering:'|| v_proc, 1);
1376: --
1377: If p_finance_line_id is null Then
1378: hr_utility.set_location('Entering:'|| v_proc, 2);
1379: --
1380: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1381: fnd_message.set_token('STEP','1');
1382: fnd_message.raise_error;

Line 1385: hr_utility.set_location('Entering:'|| v_proc, 3);

1381: fnd_message.set_token('STEP','1');
1382: fnd_message.raise_error;
1383: --
1384: ElsIf p_cancelled_flag = 'Y' Then
1385: hr_utility.set_location('Entering:'|| v_proc, 3);
1386: --
1387: -- * Line is cancelled
1388: --
1389: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

Line 1395: hr_utility.set_location('Entering:'|| v_proc, 4);

1391: fnd_message.raise_error;
1392: --
1393: /*
1394: ElsIf p_transfer_status = 'ST' Then
1395: hr_utility.set_location('Entering:'|| v_proc, 4);
1396: --
1397: -- * Line has been successful transferred
1398: --
1399: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

Line 1412: hr_utility.set_location('Entering:'|| v_proc, 6);

1408: Open sel_finance_header;
1409: Fetch sel_finance_header into v_header_transfer_status;
1410: --
1411: If sel_finance_header%notfound then
1412: hr_utility.set_location('Entering:'|| v_proc, 6);
1413: --
1414: Close sel_finance_header;
1415: --
1416: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

Line 1421: hr_utility.set_location('Entering:'|| v_proc, 7);

1417: fnd_message.set_token('STEP','4');
1418: fnd_message.raise_error;
1419: --
1420: ElsIf v_header_transfer_status = 'ST' Then
1421: hr_utility.set_location('Entering:'|| v_proc, 7);
1422: --
1423: -- * Finance Header has been successfull transferred
1424: --
1425: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

Line 1438: hr_utility.set_location('Entering:'|| v_proc, 8);

1434: Open sel_finance_line;
1435: Fetch sel_finance_line into v_rec_finance_line;
1436: --
1437: If sel_finance_line%notfound then
1438: hr_utility.set_location('Entering:'|| v_proc, 8);
1439: --
1440: Close sel_finance_line;
1441: --
1442: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

Line 1470: hr_utility.set_location(' Leaving:'|| v_proc, 20);

1466: --
1467: if p_commit then
1468: commit;
1469: end if;
1470: hr_utility.set_location(' Leaving:'|| v_proc, 20);
1471: --
1472: End cancel_finance_line;
1473: --
1474: -- ----------------------------------------------------------------------------

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

1494: v_proc varchar2(72) := g_package||'cancel_finance_line';
1495: l_ovn number;
1496: --
1497: begin
1498: hr_utility.set_location('Entering:'|| v_proc, 5);
1499: --
1500: cancel_finance_line(p_finance_line_id
1501: ,p_cancelled_flag
1502: ,p_transfer_status

Line 1508: hr_utility.set_location('Entering:'|| v_proc, 10);

1504: ,l_ovn
1505: ,p_validate
1506: ,p_commit);
1507: --
1508: hr_utility.set_location('Entering:'|| v_proc, 10);
1509: end cancel_finance_line;
1510: --
1511: --
1512: -- ----------------------------------------------------------------------------

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

1544: where tfh.finance_header_id = p_finance_header_id;
1545: --
1546: Begin
1547: --
1548: hr_utility.set_location('Entering:'|| v_proc, 5);
1549: --
1550: If p_finance_line_id is null Then
1551: --
1552: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');

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

1634: --
1635: if p_commit then
1636: commit;
1637: end if;
1638: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1639: --
1640: End recancel_finance_line;
1641: --
1642: -- ----------------------------------------------------------------------------

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

1681: or (p_include_cancelled <> 'N'));
1682: --
1683: Begin
1684: --
1685: hr_utility.set_location('Entering:'|| v_proc, 5);
1686: --
1687: open get_finance_line;
1688: fetch get_finance_line into l_finance_line_id
1689: , l_date_raised

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

1711: end loop;
1712: --
1713: close get_finance_line;
1714: --
1715: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1716: --
1717: End change_line_for_header;
1718: --
1719: --