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 FND_MESSAGE

Line 41: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');

37: if p_tfh_type = 'C' then
38: --
39: -- Finance header of type Cancellation
40: --
41: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');
42: fnd_message.raise_error;
43: --
44: elsIf p_tfh_type is null then
45: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');

Line 42: fnd_message.raise_error;

38: --
39: -- Finance header of type Cancellation
40: --
41: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');
42: fnd_message.raise_error;
43: --
44: elsIf p_tfh_type is null then
45: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');
46: fnd_message.raise_error;

Line 45: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');

41: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');
42: fnd_message.raise_error;
43: --
44: elsIf p_tfh_type is null then
45: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');
46: fnd_message.raise_error;
47: --
48: end if;
49: --

Line 46: fnd_message.raise_error;

42: fnd_message.raise_error;
43: --
44: elsIf p_tfh_type is null then
45: fnd_message.set_name('OTA','OTA_13412_TFL_NO_HEADER');
46: fnd_message.raise_error;
47: --
48: end if;
49: --
50: End check_valid_header;

Line 74: fnd_message.set_name('OTA','OTA_13459_TFL_TYPE_NOT_FOUND');

70: If p_type is not null Then
71: ota_general.check_domain_value( 'FINANCE_LINE_TYPE', p_type);
72: --
73: Else
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);

Line 75: fnd_message.raise_error;

71: ota_general.check_domain_value( 'FINANCE_LINE_TYPE', p_type);
72: --
73: Else
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: --

Line 134: fnd_message.set_name('OTA','OTA_13460_TFL_WRONG_LINE_TYPE');

130: p_finance_line_type <> 'P'
131: )
132: Then
133: --
134: fnd_message.set_name('OTA','OTA_13460_TFL_WRONG_LINE_TYPE');
135: fnd_message.raise_error;
136: End if;
137: End if;
138: --

Line 135: fnd_message.raise_error;

131: )
132: Then
133: --
134: fnd_message.set_name('OTA','OTA_13460_TFL_WRONG_LINE_TYPE');
135: fnd_message.raise_error;
136: End if;
137: End if;
138: --
139: hr_utility.set_location(' Leaving:'||v_proc, 10);

Line 193: fnd_message.set_name('OTA','OTA_13456_TFL_WRONG_DEAL_TYPE');

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');
194: fnd_message.raise_error;
195: --
196: elsif p_receivable_type in (g_standard,g_pre_payment)
197: and p_booking_deal_type <> 'D' then

Line 194: fnd_message.raise_error;

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');
194: fnd_message.raise_error;
195: --
196: elsif p_receivable_type in (g_standard,g_pre_payment)
197: and p_booking_deal_type <> 'D' then
198: fnd_message.set_name('OTA','OTA_13456_TFL_WRONG_DEAL_TYPE');

Line 198: fnd_message.set_name('OTA','OTA_13456_TFL_WRONG_DEAL_TYPE');

194: fnd_message.raise_error;
195: --
196: elsif p_receivable_type in (g_standard,g_pre_payment)
197: and p_booking_deal_type <> 'D' then
198: fnd_message.set_name('OTA','OTA_13456_TFL_WRONG_DEAL_TYPE');
199: fnd_message.raise_error;
200: --
201: end if;
202: --

Line 199: fnd_message.raise_error;

195: --
196: elsif p_receivable_type in (g_standard,g_pre_payment)
197: and p_booking_deal_type <> 'D' then
198: fnd_message.set_name('OTA','OTA_13456_TFL_WRONG_DEAL_TYPE');
199: fnd_message.raise_error;
200: --
201: end if;
202: --
203: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 252: fnd_message.set_name('OTA','OTA_13458_TFL_DEAL_NOT_FOUND');

248: ,v_limit_each_event_flag;
249: Close csr_tbd;
250: --
251: If v_deal_type is null then
252: fnd_message.set_name('OTA','OTA_13458_TFL_DEAL_NOT_FOUND');
253: fnd_message.raise_error;
254: end if;
255: --
256: If v_book_deal_customer_id is NOT null Then

Line 253: fnd_message.raise_error;

249: Close csr_tbd;
250: --
251: If v_deal_type is null then
252: fnd_message.set_name('OTA','OTA_13458_TFL_DEAL_NOT_FOUND');
253: fnd_message.raise_error;
254: end if;
255: --
256: If v_book_deal_customer_id is NOT null Then
257: Open csr_tfh;

Line 313: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');

309: If sel_resource_vendor%notfound Then
310: --
311: Close sel_resource_vendor;
312: --
313: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');
314: fnd_message.raise_error;
315: --
316: Else
317: --

Line 314: fnd_message.raise_error;

310: --
311: Close sel_resource_vendor;
312: --
313: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');
314: fnd_message.raise_error;
315: --
316: Else
317: --
318: Close sel_resource_vendor;

Line 326: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');

322: If sel_finance_vendor%notfound Then
323: --
324: Close sel_finance_vendor;
325: --
326: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');
327: fnd_message.raise_error;
328: --
329: Else
330: --

Line 327: fnd_message.raise_error;

323: --
324: Close sel_finance_vendor;
325: --
326: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');
327: fnd_message.raise_error;
328: --
329: Else
330: --
331: If v_resource_vendor_id <> v_finance_vendor_id OR

Line 336: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');

332: v_finance_vendor_id is null Then
333: --
334: Close sel_finance_vendor;
335: --
336: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');
337: fnd_message.raise_error;
338: --
339: End if;
340: --

Line 337: fnd_message.raise_error;

333: --
334: Close sel_finance_vendor;
335: --
336: fnd_message.set_name('OTA','OTA_13345_TFL_VENDOR');
337: fnd_message.raise_error;
338: --
339: End if;
340: --
341: End if;

Line 402: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');

398: If sel_booking_customer%notfound then
399: --
400: Close sel_booking_customer;
401: --
402: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');
403: fnd_message.raise_error;
404: --
405: Else
406: --

Line 403: fnd_message.raise_error;

399: --
400: Close sel_booking_customer;
401: --
402: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');
403: fnd_message.raise_error;
404: --
405: Else
406: --
407: Close sel_booking_customer;

Line 415: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');

411: If sel_finance_customer%notfound then
412: --
413: Close sel_finance_customer;
414: --
415: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');
416: fnd_message.raise_error;
417: --
418: Else
419: --

Line 416: fnd_message.raise_error;

412: --
413: Close sel_finance_customer;
414: --
415: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');
416: fnd_message.raise_error;
417: --
418: Else
419: --
420: Close sel_finance_customer;

Line 433: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');

429: v_booking_customer_id is NOT null ) OR
430: ( v_booking_customer_id is null AND
431: v_finance_customer_id is NOT null ) Then
432: --
433: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');
434: fnd_message.raise_error;
435: --
436: End if;
437: --

Line 434: fnd_message.raise_error;

430: ( v_booking_customer_id is null AND
431: v_finance_customer_id is NOT null ) Then
432: --
433: fnd_message.set_name('OTA','OTA_13347_TFL_RES_CHARGE');
434: fnd_message.raise_error;
435: --
436: End if;
437: --
438: End if;

Line 500: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');

496: If sel_booking_customer%notfound then
497: --
498: Close sel_booking_customer;
499: --
500: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');
501: fnd_message.raise_error;
502: --
503: Else
504: --

Line 501: fnd_message.raise_error;

497: --
498: Close sel_booking_customer;
499: --
500: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');
501: fnd_message.raise_error;
502: --
503: Else
504: --
505: Close sel_booking_customer;

Line 513: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');

509: If sel_finance_customer%notfound then
510: --
511: Close sel_finance_customer;
512: --
513: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');
514: fnd_message.raise_error;
515: --
516: Else
517: --

Line 514: fnd_message.raise_error;

510: --
511: Close sel_finance_customer;
512: --
513: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');
514: fnd_message.raise_error;
515: --
516: Else
517: --
518: Close sel_finance_customer;

Line 532: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');

528: v_booking_customer_id is NOT null ) OR
529: ( v_booking_customer_id is null AND
530: v_finance_customer_id is NOT null ) Then
531: --
532: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');
533: fnd_message.raise_error;
534: --
535: End if;
536: --

Line 533: fnd_message.raise_error;

529: ( v_booking_customer_id is null AND
530: v_finance_customer_id is NOT null ) Then
531: --
532: fnd_message.set_name('OTA','OTA_13346_TFL_DELEGATE');
533: fnd_message.raise_error;
534: --
535: End if;
536: --
537: End if;

Line 590: fnd_message.set_name('OTA','OTA_13351_TFL_PRE_PURCH_UNIT');

586: If sel_pricelist_type%notfound then
587: --
588: Close sel_pricelist_type;
589: --
590: fnd_message.set_name('OTA','OTA_13351_TFL_PRE_PURCH_UNIT');
591: fnd_message.raise_error;
592: --
593: Else
594: --

Line 591: fnd_message.raise_error;

587: --
588: Close sel_pricelist_type;
589: --
590: fnd_message.set_name('OTA','OTA_13351_TFL_PRE_PURCH_UNIT');
591: fnd_message.raise_error;
592: --
593: Else
594: --
595: Close sel_pricelist_type;

Line 610: fnd_message.set_name('OTA','OTA_13351_TFL_PRE_PURCH_UNIT');

606: p_unitary_amount is null
607: OR (v_price_list_type = 'M' and
608: p_unitary_amount is NOT null)) Then
609: --
610: fnd_message.set_name('OTA','OTA_13351_TFL_PRE_PURCH_UNIT');
611: fnd_message.raise_error;
612: --
613: End if;
614: --

Line 611: fnd_message.raise_error;

607: OR (v_price_list_type = 'M' and
608: p_unitary_amount is NOT null)) Then
609: --
610: fnd_message.set_name('OTA','OTA_13351_TFL_PRE_PURCH_UNIT');
611: fnd_message.raise_error;
612: --
613: End if;
614: --
615: End if;

Line 655: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');

651: if p_booking_id is null
652: or p_resource_booking_id is not null
653: or p_resource_allocation_id is not null
654: then
655: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
656: fnd_message.raise_error;
657: end if;
658: if p_receivable_type = g_pre_purchase_use
659: and p_booking_deal_id is null then

Line 656: fnd_message.raise_error;

652: or p_resource_booking_id is not null
653: or p_resource_allocation_id is not null
654: then
655: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
656: fnd_message.raise_error;
657: end if;
658: if p_receivable_type = g_pre_purchase_use
659: and p_booking_deal_id is null then
660: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');

Line 660: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');

656: fnd_message.raise_error;
657: end if;
658: if p_receivable_type = g_pre_purchase_use
659: and p_booking_deal_id is null then
660: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
661: fnd_message.raise_error;
662: end if;
663:
664: --

Line 661: fnd_message.raise_error;

657: end if;
658: if p_receivable_type = g_pre_purchase_use
659: and p_booking_deal_id is null then
660: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
661: fnd_message.raise_error;
662: end if;
663:
664: --
665: elsif p_finance_line_type = 'V' then

Line 671: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');

667: or p_booking_id is not null
668: or p_booking_deal_id is not null
669: or p_resource_allocation_id is not null
670: then
671: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
672: fnd_message.raise_error;
673: end if;
674: --
675: elsif p_finance_line_type = 'P' then

Line 672: fnd_message.raise_error;

668: or p_booking_deal_id is not null
669: or p_resource_allocation_id is not null
670: then
671: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
672: fnd_message.raise_error;
673: end if;
674: --
675: elsif p_finance_line_type = 'P' then
676: if p_booking_deal_id is null

Line 681: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');

677: or p_booking_id is not null
678: or p_resource_booking_id is not null
679: or p_resource_allocation_id is not null
680: then
681: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
682: fnd_message.raise_error;
683: end if;
684: --
685: elsif p_finance_line_type = 'R' then

Line 682: fnd_message.raise_error;

678: or p_resource_booking_id is not null
679: or p_resource_allocation_id is not null
680: then
681: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
682: fnd_message.raise_error;
683: end if;
684: --
685: elsif p_finance_line_type = 'R' then
686: fnd_message.set_name('OTA','OTA_13352_TFL_RES_CHARGE_ATTR');

Line 686: fnd_message.set_name('OTA','OTA_13352_TFL_RES_CHARGE_ATTR');

682: fnd_message.raise_error;
683: end if;
684: --
685: elsif p_finance_line_type = 'R' then
686: fnd_message.set_name('OTA','OTA_13352_TFL_RES_CHARGE_ATTR');
687: fnd_message.raise_error;
688: --
689: else
690: if p_booking_deal_id is not null

Line 687: fnd_message.raise_error;

683: end if;
684: --
685: elsif p_finance_line_type = 'R' then
686: fnd_message.set_name('OTA','OTA_13352_TFL_RES_CHARGE_ATTR');
687: fnd_message.raise_error;
688: --
689: else
690: if p_booking_deal_id is not null
691: or p_booking_id is not null

Line 694: fnd_message.set_name('OTA','OTA_13590_USER_FIN_TYPE_KEY');

690: if p_booking_deal_id is not null
691: or p_booking_id is not null
692: or p_resource_booking_id is not null
693: or p_resource_allocation_id is not null then
694: fnd_message.set_name('OTA','OTA_13590_USER_FIN_TYPE_KEY');
695: fnd_message.raise_error;
696: end if;
697: end if;
698: --

Line 695: fnd_message.raise_error;

691: or p_booking_id is not null
692: or p_resource_booking_id is not null
693: or p_resource_allocation_id is not null then
694: fnd_message.set_name('OTA','OTA_13590_USER_FIN_TYPE_KEY');
695: fnd_message.raise_error;
696: end if;
697: end if;
698: --
699: --

Line 752: fnd_message.set_name('OTA','OTA_13454_TFL_ST_AMNT_REQ');

748: close csr_header_type;
749: end if;
750: --
751: If p_finance_line_type in ('E','R') and p_standard_amount is null Then
752: fnd_message.set_name('OTA','OTA_13454_TFL_ST_AMNT_REQ');
753: fnd_message.raise_error;
754: elsif p_finance_line_type in ('V','P') and p_standard_amount is not null then
755: fnd_message.set_name('OTA','OTA_13464_TFL_ST_AMNT_NULL');
756: fnd_message.raise_error;

Line 753: fnd_message.raise_error;

749: end if;
750: --
751: If p_finance_line_type in ('E','R') and p_standard_amount is null Then
752: fnd_message.set_name('OTA','OTA_13454_TFL_ST_AMNT_REQ');
753: fnd_message.raise_error;
754: elsif p_finance_line_type in ('V','P') and p_standard_amount is not null then
755: fnd_message.set_name('OTA','OTA_13464_TFL_ST_AMNT_NULL');
756: fnd_message.raise_error;
757: end if;

Line 755: fnd_message.set_name('OTA','OTA_13464_TFL_ST_AMNT_NULL');

751: If p_finance_line_type in ('E','R') and p_standard_amount is null Then
752: fnd_message.set_name('OTA','OTA_13454_TFL_ST_AMNT_REQ');
753: fnd_message.raise_error;
754: elsif p_finance_line_type in ('V','P') and p_standard_amount is not null then
755: fnd_message.set_name('OTA','OTA_13464_TFL_ST_AMNT_NULL');
756: fnd_message.raise_error;
757: end if;
758: --
759: if p_money_amount is null then

Line 756: fnd_message.raise_error;

752: fnd_message.set_name('OTA','OTA_13454_TFL_ST_AMNT_REQ');
753: fnd_message.raise_error;
754: elsif p_finance_line_type in ('V','P') and p_standard_amount is not null then
755: fnd_message.set_name('OTA','OTA_13464_TFL_ST_AMNT_NULL');
756: fnd_message.raise_error;
757: end if;
758: --
759: if p_money_amount is null then
760: fnd_message.set_name('OTA','OTA_13455_TFL_MONEY_AMNT_REQ');

Line 760: fnd_message.set_name('OTA','OTA_13455_TFL_MONEY_AMNT_REQ');

756: fnd_message.raise_error;
757: end if;
758: --
759: if p_money_amount is null then
760: fnd_message.set_name('OTA','OTA_13455_TFL_MONEY_AMNT_REQ');
761: fnd_message.raise_error;
762: end if;
763: --
764: if p_finance_line_type in ('R','V') and p_unitary_amount is not null then

Line 761: fnd_message.raise_error;

757: end if;
758: --
759: if p_money_amount is null then
760: fnd_message.set_name('OTA','OTA_13455_TFL_MONEY_AMNT_REQ');
761: fnd_message.raise_error;
762: end if;
763: --
764: if p_finance_line_type in ('R','V') and p_unitary_amount is not null then
765: fnd_message.set_name('OTA','OTA_13465_UNIT_AMNT_NULL');

Line 765: fnd_message.set_name('OTA','OTA_13465_UNIT_AMNT_NULL');

761: fnd_message.raise_error;
762: end if;
763: --
764: if p_finance_line_type in ('R','V') and p_unitary_amount is not null then
765: fnd_message.set_name('OTA','OTA_13465_UNIT_AMNT_NULL');
766: fnd_message.raise_error;
767: end if;
768: --
769: if p_finance_line_type in ('E','P') and p_booking_deal_id is not null then

Line 766: fnd_message.raise_error;

762: end if;
763: --
764: if p_finance_line_type in ('R','V') and p_unitary_amount is not null then
765: fnd_message.set_name('OTA','OTA_13465_UNIT_AMNT_NULL');
766: fnd_message.raise_error;
767: end if;
768: --
769: if p_finance_line_type in ('E','P') and p_booking_deal_id is not null then
770: check_pre_purchase_units(p_finance_line_type

Line 784: fnd_message.set_name('OTA','OTA_13589_USER_FIN_TYPE_ERROR');

780: p_finance_line_type not in ('E','P','R','V') and
781: ( p_unitary_amount is not null
782: or p_standard_amount is not null
783: or p_money_amount is null) then
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);

Line 785: fnd_message.raise_error;

781: ( p_unitary_amount is not null
782: or p_standard_amount is not null
783: or p_money_amount is null) then
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: --

Line 813: fnd_message.set_name('OTA','OTA_13355_TFL_UPDATE');

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');
814: fnd_message.raise_error;
815: --
816: End if;
817: --

Line 814: fnd_message.raise_error;

810: --
811: If p_transfer_status = 'ST' Then
812: --
813: fnd_message.set_name('OTA','OTA_13355_TFL_UPDATE');
814: fnd_message.raise_error;
815: --
816: End if;
817: --
818: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 880: fnd_message.set_name('OTA','OTA_13364_TFL_SEQUENCE');

876: --
877: If p_sequence_number <= 0 OR
878: p_sequence_number is NULL Then
879: --
880: fnd_message.set_name('OTA','OTA_13364_TFL_SEQUENCE');
881: fnd_message.raise_error;
882: --
883: Else
884: --

Line 881: fnd_message.raise_error;

877: If p_sequence_number <= 0 OR
878: p_sequence_number is NULL Then
879: --
880: fnd_message.set_name('OTA','OTA_13364_TFL_SEQUENCE');
881: fnd_message.raise_error;
882: --
883: Else
884: --
885: Open sel_sequence_number;

Line 892: fnd_message.set_name('OTA','OTA_13364_TFL_SEQUENCE');

888: If sel_sequence_number%found then
889: --
890: Close sel_sequence_number;
891: --
892: fnd_message.set_name('OTA','OTA_13364_TFL_SEQUENCE');
893: fnd_message.raise_error;
894: --
895: End if;
896: --

Line 893: fnd_message.raise_error;

889: --
890: Close sel_sequence_number;
891: --
892: fnd_message.set_name('OTA','OTA_13364_TFL_SEQUENCE');
893: fnd_message.raise_error;
894: --
895: End if;
896: --
897: Close sel_sequence_number;

Line 998: fnd_message.set_name('OTA','OTA_13365_TFL_DATE_RAISED');

994: If sel_date_raised%notfound then
995: --
996: Close sel_date_raised;
997: --
998: fnd_message.set_name('OTA','OTA_13365_TFL_DATE_RAISED');
999: fnd_message.raise_error;
1000: --
1001: End if;
1002: --

Line 999: fnd_message.raise_error;

995: --
996: Close sel_date_raised;
997: --
998: fnd_message.set_name('OTA','OTA_13365_TFL_DATE_RAISED');
999: fnd_message.raise_error;
1000: --
1001: End if;
1002: --
1003: Close sel_date_raised;

Line 1038: fnd_message.set_name('OTA','OTA_13357_TFL_DELETE');

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: --
1041: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1042: --

Line 1039: fnd_message.raise_error;

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: --
1041: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1042: --
1043: End check_delete_attempt;

Line 1120: fnd_message.set_name('OTA','OTA_13297_TFL_NO_CURRENCY');

1116: If sel_finance_currency%notfound then
1117: --
1118: Close sel_finance_currency;
1119: --
1120: fnd_message.set_name('OTA','OTA_13297_TFL_NO_CURRENCY');
1121: fnd_message.raise_error;
1122: --
1123: End if;
1124: --

Line 1121: fnd_message.raise_error;

1117: --
1118: Close sel_finance_currency;
1119: --
1120: fnd_message.set_name('OTA','OTA_13297_TFL_NO_CURRENCY');
1121: fnd_message.raise_error;
1122: --
1123: End if;
1124: --
1125: Close sel_finance_currency;

Line 1141: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1137: v_line_currency_code is null Then
1138: --
1139: Close sel_resource_book_currency;
1140: --
1141: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1142: fnd_message.raise_error;
1143: --
1144: End if;
1145: --

Line 1142: fnd_message.raise_error;

1138: --
1139: Close sel_resource_book_currency;
1140: --
1141: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1142: fnd_message.raise_error;
1143: --
1144: End if;
1145: --
1146: Close sel_resource_book_currency;

Line 1163: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1159: v_line_currency_code is null Then
1160: --
1161: Close sel_event_currency;
1162: --
1163: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1164: fnd_message.raise_error;
1165: --
1166: End if;
1167: --

Line 1164: fnd_message.raise_error;

1160: --
1161: Close sel_event_currency;
1162: --
1163: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1164: fnd_message.raise_error;
1165: --
1166: End if;
1167: --
1168: Close sel_event_currency;

Line 1183: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1179: v_line_currency_code is null Then
1180: --
1181: Close sel_price_list_currency;
1182: --
1183: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1184: fnd_message.raise_error;
1185: --
1186: End if;
1187: --

Line 1184: fnd_message.raise_error;

1180: --
1181: Close sel_price_list_currency;
1182: --
1183: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1184: fnd_message.raise_error;
1185: --
1186: End if;
1187: --
1188: Close sel_price_list_currency;

Line 1205: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1201: v_line_currency_code is null Then
1202: --
1203: Close sel_resource_alloc_currency;
1204: --
1205: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1206: fnd_message.raise_error;
1207: --
1208: End if;
1209: --

Line 1206: fnd_message.raise_error;

1202: --
1203: Close sel_resource_alloc_currency;
1204: --
1205: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1206: fnd_message.raise_error;
1207: --
1208: End if;
1209: --
1210: Close sel_resource_alloc_currency;

Line 1286: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1282: v_line_currency_code is null Then
1283: --
1284: Close sel_resource_book_currency;
1285: --
1286: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1287: fnd_message.raise_error;
1288: --
1289: End if;
1290: --

Line 1287: fnd_message.raise_error;

1283: --
1284: Close sel_resource_book_currency;
1285: --
1286: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1287: fnd_message.raise_error;
1288: --
1289: End if;
1290: --
1291: Close sel_resource_book_currency;

Line 1305: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1301: v_line_currency_code is null Then
1302: --
1303: Close sel_event_currency;
1304: --
1305: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1306: fnd_message.raise_error;
1307: --
1308: End if;
1309: --

Line 1306: fnd_message.raise_error;

1302: --
1303: Close sel_event_currency;
1304: --
1305: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1306: fnd_message.raise_error;
1307: --
1308: End if;
1309: --
1310: Close sel_event_currency;

Line 1324: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1320: v_line_currency_code is null Then
1321: --
1322: Close sel_price_list_currency;
1323: --
1324: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1325: fnd_message.raise_error;
1326: --
1327: End if;
1328: --

Line 1325: fnd_message.raise_error;

1321: --
1322: Close sel_price_list_currency;
1323: --
1324: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1325: fnd_message.raise_error;
1326: --
1327: End if;
1328: --
1329: Close sel_price_list_currency;

Line 1343: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');

1339: v_line_currency_code is null Then
1340: --
1341: Close sel_resource_alloc_currency;
1342: --
1343: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1344: fnd_message.raise_error;
1345: --
1346: End if;
1347: --

Line 1344: fnd_message.raise_error;

1340: --
1341: Close sel_resource_alloc_currency;
1342: --
1343: fnd_message.set_name('OTA','OTA_13358_TFL_CURRENCY');
1344: fnd_message.raise_error;
1345: --
1346: End if;
1347: --
1348: Close sel_resource_alloc_currency;

Line 1452: fnd_message.set_name('OTA','OTA_13384_TFL_NO_DUPLICATES');

1448: fetch find_other_lines into l_finance_line_id;
1449: if find_other_lines%found then
1450: close find_other_lines;
1451: --
1452: fnd_message.set_name('OTA','OTA_13384_TFL_NO_DUPLICATES');
1453: fnd_message.raise_error;
1454: end if;
1455: close find_other_lines;
1456: end if;

Line 1453: fnd_message.raise_error;

1449: if find_other_lines%found then
1450: close find_other_lines;
1451: --
1452: fnd_message.set_name('OTA','OTA_13384_TFL_NO_DUPLICATES');
1453: fnd_message.raise_error;
1454: end if;
1455: close find_other_lines;
1456: end if;
1457: --

Line 1536: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');

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;
1539: end if;
1540: --

Line 1537: fnd_message.set_token('STEP','1');

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;
1539: end if;
1540: --
1541: /* N.B. p_check_successful_transfer indicates that the mode currently running

Line 1538: fnd_message.raise_error;

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;
1539: end if;
1540: --
1541: /* N.B. p_check_successful_transfer indicates that the mode currently running
1542: is CANCEL_HEADER_LINE. When performing this process the Finance Header

Line 1551: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');

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;
1554: end if;
1555: end if;

Line 1552: fnd_message.set_token('STEP','2');

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;
1554: end if;
1555: end if;
1556: --

Line 1553: fnd_message.raise_error;

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;
1554: end if;
1555: end if;
1556: --
1557: if p_check_successful_transfer then

Line 1560: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');

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;
1563: end if;
1564: hr_utility.trace('After Transfer Status Check');

Line 1561: fnd_message.set_token('STEP','3');

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;
1563: end if;
1564: hr_utility.trace('After Transfer Status Check');
1565: end if;

Line 1562: fnd_message.raise_error;

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;
1563: end if;
1564: hr_utility.trace('After Transfer Status Check');
1565: end if;
1566: --

Line 1570: fnd_message.set_name('OTA','OTA_13490_TFL_INVALID_TFH');

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;
1573: end if;
1574: end if;

Line 1571: fnd_message.set_token('STEP','4');

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;
1573: end if;
1574: end if;
1575: --

Line 1572: fnd_message.raise_error;

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;
1573: end if;
1574: end if;
1575: --
1576: hr_utility.set_location('Leaving:'||l_proc, 10);