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 FND_MESSAGE

Line 120: fnd_message.set_name('OTA','OTA_13414_TFH_TRANS_RULES');

116: or (p_old_transfer_status = 'ST' and p_new_transfer_status = 'UT')
117: or (p_old_transfer_status = 'AT' and p_new_transfer_status = 'ST'))
118: then null;
119: else
120: fnd_message.set_name('OTA','OTA_13414_TFH_TRANS_RULES');
121: fnd_message.raise_error;
122: end if;
123: --
124: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 121: fnd_message.raise_error;

117: or (p_old_transfer_status = 'AT' and p_new_transfer_status = 'ST'))
118: then null;
119: else
120: fnd_message.set_name('OTA','OTA_13414_TFH_TRANS_RULES');
121: fnd_message.raise_error;
122: end if;
123: --
124: hr_utility.set_location(' Leaving:'|| v_proc, 10);
125: --

Line 150: fnd_message.set_name('OTA','OTA_13280_TFH_UNAUTHORIZED');

146: hr_utility.set_location('Entering:'|| v_proc, 5);
147: --
148: If p_authorized_person_id is null Then
149: If p_status <> 'NT' Then
150: fnd_message.set_name('OTA','OTA_13280_TFH_UNAUTHORIZED');
151: fnd_message.raise_error;
152: End if;
153: End If;
154: --

Line 151: fnd_message.raise_error;

147: --
148: If p_authorized_person_id is null Then
149: If p_status <> 'NT' Then
150: fnd_message.set_name('OTA','OTA_13280_TFH_UNAUTHORIZED');
151: fnd_message.raise_error;
152: End if;
153: End If;
154: --
155: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 178: fnd_message.set_name('OTA','OTA_13281_TFH_AUTHORIZER');

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;
182: --

Line 179: fnd_message.raise_error;

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

Line 207: fnd_message.set_name('OTA','OTA_13313_TFH_DATE_RAISED');

203: Begin
204: hr_utility.set_location('Entering:'|| v_proc, 5);
205: --
206: If p_session_date is null Then
207: fnd_message.set_name('OTA','OTA_13313_TFH_DATE_RAISED');
208: fnd_message.raise_error;
209: Else
210: p_date_raised := p_session_date;
211: End If;

Line 208: fnd_message.raise_error;

204: hr_utility.set_location('Entering:'|| v_proc, 5);
205: --
206: If p_session_date is null Then
207: fnd_message.set_name('OTA','OTA_13313_TFH_DATE_RAISED');
208: fnd_message.raise_error;
209: Else
210: p_date_raised := p_session_date;
211: End If;
212: --

Line 311: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');

307: fetch sel_customer_contact into v_exists;
308: --
309: if sel_customer_contact%notfound then
310: close sel_customer_contact;
311: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');
312: fnd_message.raise_error;
313: end if;
314: --
315: close sel_customer_contact;

Line 312: fnd_message.raise_error;

308: --
309: if sel_customer_contact%notfound then
310: close sel_customer_contact;
311: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');
312: fnd_message.raise_error;
313: end if;
314: --
315: close sel_customer_contact;
316: End if;

Line 354: fnd_message.set_name('OTA','OTA_13284_TFH_CUSTOMER_ADDRESS');

350: fetch sel_customer_address into v_exists;
351: --
352: if sel_customer_address%notfound then
353: close sel_customer_address;
354: fnd_message.set_name('OTA','OTA_13284_TFH_CUSTOMER_ADDRESS');
355: fnd_message.raise_error;
356: end if;
357: --
358: close sel_customer_address;

Line 355: fnd_message.raise_error;

351: --
352: if sel_customer_address%notfound then
353: close sel_customer_address;
354: fnd_message.set_name('OTA','OTA_13284_TFH_CUSTOMER_ADDRESS');
355: fnd_message.raise_error;
356: end if;
357: --
358: close sel_customer_address;
359: End if;

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

398: fetch sel_invoice_address into v_address;
399: --
400: if sel_invoice_address%notfound then
401: close sel_invoice_address;
402: fnd_message.set_name('OTA','OTA_13284_TFH_CUSTOMER_ADDRESS');
403: fnd_message.raise_error;
404: end if;
405: --
406: p_invoice_address := v_address;

Line 403: fnd_message.raise_error;

399: --
400: if sel_invoice_address%notfound then
401: close sel_invoice_address;
402: fnd_message.set_name('OTA','OTA_13284_TFH_CUSTOMER_ADDRESS');
403: fnd_message.raise_error;
404: end if;
405: --
406: p_invoice_address := v_address;
407: --

Line 446: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');

442: fetch sel_invoice_contact into v_contact;
443: --
444: if sel_invoice_contact%notfound then
445: close sel_invoice_contact;
446: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');
447: fnd_message.raise_error;
448: end if;
449: --
450: p_invoice_contact := v_contact;

Line 447: fnd_message.raise_error;

443: --
444: if sel_invoice_contact%notfound then
445: close sel_invoice_contact;
446: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');
447: fnd_message.raise_error;
448: end if;
449: --
450: p_invoice_contact := v_contact;
451: --

Line 496: fnd_message.set_name('OTA','OTA_13285_TFH_VENDOR_CONTACT');

492: fetch sel_vendor_contact into v_exists;
493: --
494: if sel_vendor_contact%notfound then
495: close sel_vendor_contact;
496: fnd_message.set_name('OTA','OTA_13285_TFH_VENDOR_CONTACT');
497: fnd_message.raise_error;
498: end if;
499: --
500: close sel_vendor_contact;

Line 497: fnd_message.raise_error;

493: --
494: if sel_vendor_contact%notfound then
495: close sel_vendor_contact;
496: fnd_message.set_name('OTA','OTA_13285_TFH_VENDOR_CONTACT');
497: fnd_message.raise_error;
498: end if;
499: --
500: close sel_vendor_contact;
501: End if;

Line 539: fnd_message.set_name('OTA','OTA_13286_TFH_VENDOR_ADDRESS');

535: fetch sel_vendor_address into v_exists;
536: --
537: if sel_vendor_address%notfound then
538: close sel_vendor_address;
539: fnd_message.set_name('OTA','OTA_13286_TFH_VENDOR_ADDRESS');
540: fnd_message.raise_error;
541: end if;
542: --
543: close sel_vendor_address;

Line 540: fnd_message.raise_error;

536: --
537: if sel_vendor_address%notfound then
538: close sel_vendor_address;
539: fnd_message.set_name('OTA','OTA_13286_TFH_VENDOR_ADDRESS');
540: fnd_message.raise_error;
541: end if;
542: --
543: close sel_vendor_address;
544: End if;

Line 711: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');

707: -- * Finance Header has already been cancelled
708: --
709: If p_rec_finance.cancelled_flag = 'Y' Then
710: --
711: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
712: fnd_message.set_token('STEP','1');
713: fnd_message.raise_error;
714: --
715: -- * Finance Header is type CANCELLATION

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

708: --
709: If p_rec_finance.cancelled_flag = 'Y' Then
710: --
711: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
712: fnd_message.set_token('STEP','1');
713: fnd_message.raise_error;
714: --
715: -- * Finance Header is type CANCELLATION
716: --

Line 713: fnd_message.raise_error;

709: If p_rec_finance.cancelled_flag = 'Y' Then
710: --
711: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
712: fnd_message.set_token('STEP','1');
713: fnd_message.raise_error;
714: --
715: -- * Finance Header is type CANCELLATION
716: --
717: ElsIf p_rec_finance.type = 'C' Then

Line 719: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');

715: -- * Finance Header is type CANCELLATION
716: --
717: ElsIf p_rec_finance.type = 'C' Then
718: --
719: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
720: fnd_message.set_token('STEP','2');
721: fnd_message.raise_error;
722: --
723: Else

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

716: --
717: ElsIf p_rec_finance.type = 'C' Then
718: --
719: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
720: fnd_message.set_token('STEP','2');
721: fnd_message.raise_error;
722: --
723: Else
724: --

Line 721: fnd_message.raise_error;

717: ElsIf p_rec_finance.type = 'C' Then
718: --
719: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
720: fnd_message.set_token('STEP','2');
721: fnd_message.raise_error;
722: --
723: Else
724: --
725: -- * The Finance Line for cancelling has been transfered

Line 983: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');

979: Fetch sel_finance_header into l_rec_cancel;
980: --
981: If sel_finance_header%notfound then
982: Close sel_finance_header;
983: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
984: fnd_message.set_token('STEP','3');
985: fnd_message.raise_error;
986: --
987: End if;

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

980: --
981: If sel_finance_header%notfound then
982: Close sel_finance_header;
983: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
984: fnd_message.set_token('STEP','3');
985: fnd_message.raise_error;
986: --
987: End if;
988: --

Line 985: fnd_message.raise_error;

981: If sel_finance_header%notfound then
982: Close sel_finance_header;
983: fnd_message.set_name('OTA','OTA_13486_TFH_CANCEL_HEADER2');
984: fnd_message.set_token('STEP','3');
985: fnd_message.raise_error;
986: --
987: End if;
988: --
989: Close sel_finance_header;

Line 1036: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');

1032: Fetch sel_for_deletion into v_exists;
1033: --
1034: If sel_for_deletion%found then
1035: close sel_for_deletion;
1036: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');
1037: fnd_message.raise_error;
1038: End if;
1039: --
1040: close sel_for_deletion;

Line 1037: fnd_message.raise_error;

1033: --
1034: If sel_for_deletion%found then
1035: close sel_for_deletion;
1036: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');
1037: fnd_message.raise_error;
1038: End if;
1039: --
1040: close sel_for_deletion;
1041: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1084: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');

1080: Fetch sel_finance_header into v_rec_header;
1081: --
1082: If sel_finance_header%notfound then
1083: Close sel_finance_header;
1084: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1085: fnd_message.set_token('STEP','3');
1086: fnd_message.raise_error;
1087: End if;
1088: --

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

1081: --
1082: If sel_finance_header%notfound then
1083: Close sel_finance_header;
1084: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1085: fnd_message.set_token('STEP','3');
1086: fnd_message.raise_error;
1087: End if;
1088: --
1089: Close sel_finance_header;

Line 1086: fnd_message.raise_error;

1082: If sel_finance_header%notfound then
1083: Close sel_finance_header;
1084: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1085: fnd_message.set_token('STEP','3');
1086: fnd_message.raise_error;
1087: End if;
1088: --
1089: Close sel_finance_header;
1090: --

Line 1094: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');

1090: --
1091: -- * Finance Header has already been cancelled
1092: --
1093: If v_rec_header.cancelled_flag = 'N' Then
1094: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1095: fnd_message.set_token('STEP','1');
1096: fnd_message.raise_error;
1097: --
1098: -- * Finance Header of type CANCELLATION

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

1091: -- * Finance Header has already been cancelled
1092: --
1093: If v_rec_header.cancelled_flag = 'N' Then
1094: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1095: fnd_message.set_token('STEP','1');
1096: fnd_message.raise_error;
1097: --
1098: -- * Finance Header of type CANCELLATION
1099: --

Line 1096: fnd_message.raise_error;

1092: --
1093: If v_rec_header.cancelled_flag = 'N' Then
1094: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1095: fnd_message.set_token('STEP','1');
1096: fnd_message.raise_error;
1097: --
1098: -- * Finance Header of type CANCELLATION
1099: --
1100: ElsIf v_rec_header.type = 'C' Then

Line 1101: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');

1097: --
1098: -- * Finance Header of type CANCELLATION
1099: --
1100: ElsIf v_rec_header.type = 'C' Then
1101: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1102: fnd_message.set_token('STEP','2');
1103: fnd_message.raise_error;
1104: Else
1105: --

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

1098: -- * Finance Header of type CANCELLATION
1099: --
1100: ElsIf v_rec_header.type = 'C' Then
1101: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1102: fnd_message.set_token('STEP','2');
1103: fnd_message.raise_error;
1104: Else
1105: --
1106: -- * Checks whether the Finance Header is superceded by another one

Line 1103: fnd_message.raise_error;

1099: --
1100: ElsIf v_rec_header.type = 'C' Then
1101: fnd_message.set_name('OTA','OTA_13487_TFH_REINST_HEADER');
1102: fnd_message.set_token('STEP','2');
1103: fnd_message.raise_error;
1104: Else
1105: --
1106: -- * Checks whether the Finance Header is superceded by another one
1107: -- or not

Line 1250: fnd_message.set_name('OTA','OTA_13287_TFH_SUPERSEDED_HEAD');

1246: fetch sel_superseding_header into v_exists;
1247: --
1248: if sel_superseding_header%notfound then
1249: close sel_superseding_header;
1250: fnd_message.set_name('OTA','OTA_13287_TFH_SUPERSEDED_HEAD');
1251: fnd_message.raise_error;
1252: end if;
1253: --
1254: close sel_superseding_header;

Line 1251: fnd_message.raise_error;

1247: --
1248: if sel_superseding_header%notfound then
1249: close sel_superseding_header;
1250: fnd_message.set_name('OTA','OTA_13287_TFH_SUPERSEDED_HEAD');
1251: fnd_message.raise_error;
1252: end if;
1253: --
1254: close sel_superseding_header;
1255: --

Line 1257: fnd_message.set_name('OTA','OTA_13287_TFH_SUPERSEDED_HEAD');

1253: --
1254: close sel_superseding_header;
1255: --
1256: Else
1257: fnd_message.set_name('OTA','OTA_13287_TFH_SUPERSEDED_HEAD');
1258: fnd_message.raise_error;
1259: End if;
1260: End if;
1261: --

Line 1258: fnd_message.raise_error;

1254: close sel_superseding_header;
1255: --
1256: Else
1257: fnd_message.set_name('OTA','OTA_13287_TFH_SUPERSEDED_HEAD');
1258: fnd_message.raise_error;
1259: End if;
1260: End if;
1261: --
1262: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1287: fnd_message.set_name('OTA','OTA_13324_TFH_CUSTOMER_VENDOR');

1283: Begin
1284: hr_utility.set_location('Entering:'|| v_proc, 5);
1285: --
1286: If p_customer_id is NOT null AND p_vendor_id is NOT null Then
1287: fnd_message.set_name('OTA','OTA_13324_TFH_CUSTOMER_VENDOR');
1288: fnd_message.raise_error;
1289: --
1290: ElsIf p_customer_id is NOT null Then
1291: --

Line 1288: fnd_message.raise_error;

1284: hr_utility.set_location('Entering:'|| v_proc, 5);
1285: --
1286: If p_customer_id is NOT null AND p_vendor_id is NOT null Then
1287: fnd_message.set_name('OTA','OTA_13324_TFH_CUSTOMER_VENDOR');
1288: fnd_message.raise_error;
1289: --
1290: ElsIf p_customer_id is NOT null Then
1291: --
1292: -- Reference check Customer and Address

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

1301: --
1302: ElsIf p_vendor_id is null AND
1303: (p_address_id is NOT null OR p_contact_id is NOT null) Then
1304: --
1305: fnd_message.set_name('OTA','OTA_13321_TFH_CUSTOMER_NAME');
1306: fnd_message.raise_error;
1307: End if;
1308: --
1309: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1306: fnd_message.raise_error;

1302: ElsIf p_vendor_id is null AND
1303: (p_address_id is NOT null OR p_contact_id is NOT null) Then
1304: --
1305: fnd_message.set_name('OTA','OTA_13321_TFH_CUSTOMER_NAME');
1306: fnd_message.raise_error;
1307: End if;
1308: --
1309: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1310: --

Line 1335: fnd_message.set_name('OTA','OTA_13324_TFH_CUSTOMER_VENDOR');

1331: Begin
1332: hr_utility.set_location('Entering:'|| v_proc, 5);
1333: --
1334: If p_vendor_id is NOT null AND p_customer_id is NOT null Then
1335: fnd_message.set_name('OTA','OTA_13324_TFH_CUSTOMER_VENDOR');
1336: fnd_message.raise_error;
1337: ElsIf p_vendor_id is NOT null Then
1338: --
1339: -- Reference check Vendor and Address

Line 1336: fnd_message.raise_error;

1332: hr_utility.set_location('Entering:'|| v_proc, 5);
1333: --
1334: If p_vendor_id is NOT null AND p_customer_id is NOT null Then
1335: fnd_message.set_name('OTA','OTA_13324_TFH_CUSTOMER_VENDOR');
1336: fnd_message.raise_error;
1337: ElsIf p_vendor_id is NOT null Then
1338: --
1339: -- Reference check Vendor and Address
1340: --

Line 1352: fnd_message.set_name('OTA','OTA_13322_TFH_VENDOR_NAME');

1348: --
1349: ElsIf p_customer_id is null AND
1350: (p_address_id is NOT null OR p_contact_id is NOT null) Then
1351: --
1352: fnd_message.set_name('OTA','OTA_13322_TFH_VENDOR_NAME');
1353: fnd_message.raise_error;
1354: End if;
1355: --
1356: --

Line 1353: fnd_message.raise_error;

1349: ElsIf p_customer_id is null AND
1350: (p_address_id is NOT null OR p_contact_id is NOT null) Then
1351: --
1352: fnd_message.set_name('OTA','OTA_13322_TFH_VENDOR_NAME');
1353: fnd_message.raise_error;
1354: End if;
1355: --
1356: --
1357: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1394: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');

1390: -- * Finance Header has already been cancelled
1391: --
1392: If p_rec_finance.cancelled_flag = 'Y' Then
1393: --
1394: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1395: fnd_message.set_token('STEP','1');
1396: fnd_message.raise_error;
1397: --
1398: -- * Finance Header is type CANCELLATION

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

1391: --
1392: If p_rec_finance.cancelled_flag = 'Y' Then
1393: --
1394: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1395: fnd_message.set_token('STEP','1');
1396: fnd_message.raise_error;
1397: --
1398: -- * Finance Header is type CANCELLATION
1399: --

Line 1396: fnd_message.raise_error;

1392: If p_rec_finance.cancelled_flag = 'Y' Then
1393: --
1394: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1395: fnd_message.set_token('STEP','1');
1396: fnd_message.raise_error;
1397: --
1398: -- * Finance Header is type CANCELLATION
1399: --
1400: ElsIf p_rec_finance.type = 'C' Then

Line 1402: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');

1398: -- * Finance Header is type CANCELLATION
1399: --
1400: ElsIf p_rec_finance.type = 'C' Then
1401: --
1402: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1403: fnd_message.set_token('STEP','2');
1404: fnd_message.raise_error;
1405: --
1406: -- * The Finance Header for cancelling and recreating must be transfered

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

1399: --
1400: ElsIf p_rec_finance.type = 'C' Then
1401: --
1402: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1403: fnd_message.set_token('STEP','2');
1404: fnd_message.raise_error;
1405: --
1406: -- * The Finance Header for cancelling and recreating must be transfered
1407: --

Line 1404: fnd_message.raise_error;

1400: ElsIf p_rec_finance.type = 'C' Then
1401: --
1402: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1403: fnd_message.set_token('STEP','2');
1404: fnd_message.raise_error;
1405: --
1406: -- * The Finance Header for cancelling and recreating must be transfered
1407: --
1408: ElsIf p_rec_finance.transfer_status <> 'ST' Then

Line 1410: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');

1406: -- * The Finance Header for cancelling and recreating must be transfered
1407: --
1408: ElsIf p_rec_finance.transfer_status <> 'ST' Then
1409: --
1410: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1411: fnd_message.set_token('STEP','3');
1412: fnd_message.raise_error;
1413: --
1414: Else

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

1407: --
1408: ElsIf p_rec_finance.transfer_status <> 'ST' Then
1409: --
1410: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1411: fnd_message.set_token('STEP','3');
1412: fnd_message.raise_error;
1413: --
1414: Else
1415: --

Line 1412: fnd_message.raise_error;

1408: ElsIf p_rec_finance.transfer_status <> 'ST' Then
1409: --
1410: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1411: fnd_message.set_token('STEP','3');
1412: fnd_message.raise_error;
1413: --
1414: Else
1415: --
1416: l_rec_new := p_rec_finance;

Line 1647: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');

1643: close sel_finance_header;
1644: --
1645: If v_cursor_boolean then --the header_id was invalid and no rows returned
1646: --
1647: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1648: fnd_message.set_token('STEP','4');
1649: fnd_message.raise_error;
1650: --
1651: End if; --end check for cursor returning no rows.

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

1644: --
1645: If v_cursor_boolean then --the header_id was invalid and no rows returned
1646: --
1647: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1648: fnd_message.set_token('STEP','4');
1649: fnd_message.raise_error;
1650: --
1651: End if; --end check for cursor returning no rows.
1652: --

Line 1649: fnd_message.raise_error;

1645: If v_cursor_boolean then --the header_id was invalid and no rows returned
1646: --
1647: fnd_message.set_name('OTA','OTA_13315_TFH_CANCEL_HEADER');
1648: fnd_message.set_token('STEP','4');
1649: fnd_message.raise_error;
1650: --
1651: End if; --end check for cursor returning no rows.
1652: --
1653: ota_tfh_api_business_rules.cancel_and_recreate

Line 2139: fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');

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');
2141: fnd_message.raise_error;
2142: end if;
2143:

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

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');
2141: fnd_message.raise_error;
2142: end if;
2143:
2144: else

Line 2141: fnd_message.raise_error;

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');
2141: fnd_message.raise_error;
2142: end if;
2143:
2144: else
2145: if p_rec_old.transfer_status = 'ST' then

Line 2151: fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');

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');
2153: fnd_message.raise_error;
2154: end if;
2155: end if;

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

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');
2153: fnd_message.raise_error;
2154: end if;
2155: end if;
2156: if p_rec_old.cancelled_flag = 'Y' then

Line 2153: fnd_message.raise_error;

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');
2153: fnd_message.raise_error;
2154: end if;
2155: end if;
2156: if p_rec_old.cancelled_flag = 'Y' then
2157: if check_update01_header( p_rec_old, p_rec_new ) or

Line 2164: fnd_message.set_name('OTA','OTA_13290_TFH_UPDATE');

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');
2166: fnd_message.raise_error;
2167: --
2168: end if;

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

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');
2166: fnd_message.raise_error;
2167: --
2168: end if;
2169: end if;

Line 2166: fnd_message.raise_error;

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');
2166: fnd_message.raise_error;
2167: --
2168: end if;
2169: end if;
2170: end if;

Line 2227: fnd_message.set_name('OTA','OTA_13291_TFH_ADMINISTRATOR');

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;
2231: --

Line 2228: fnd_message.raise_error;

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

Line 2276: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');

2272: If sel_for_deletion%notfound then
2273: --
2274: close sel_for_deletion;
2275: --
2276: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');
2277: fnd_message.raise_error;
2278: End if;
2279: --
2280: close sel_for_deletion;

Line 2277: fnd_message.raise_error;

2273: --
2274: close sel_for_deletion;
2275: --
2276: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');
2277: fnd_message.raise_error;
2278: End if;
2279: --
2280: close sel_for_deletion;
2281: --

Line 2286: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');

2282: -- Only NOT TRANSFERED Finance Headers can be deleted
2283: --
2284: If p_transfer_status = 'ST' then
2285: --
2286: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');
2287: fnd_message.raise_error;
2288: End if;
2289: --
2290: End if;

Line 2287: fnd_message.raise_error;

2283: --
2284: If p_transfer_status = 'ST' then
2285: --
2286: fnd_message.set_name('OTA','OTA_13323_TFH_DELETION');
2287: fnd_message.raise_error;
2288: End if;
2289: --
2290: End if;
2291: --

Line 2328: fnd_message.set_name('OTA','OTA_443876_TFH_DELETE_CHK');

2324: If sel_for_deletion%found then
2325: --
2326: close sel_for_deletion;
2327: --
2328: fnd_message.set_name('OTA','OTA_443876_TFH_DELETE_CHK');
2329: fnd_message.raise_error;
2330: --
2331: End if;
2332: --

Line 2329: fnd_message.raise_error;

2325: --
2326: close sel_for_deletion;
2327: --
2328: fnd_message.set_name('OTA','OTA_443876_TFH_DELETE_CHK');
2329: fnd_message.raise_error;
2330: --
2331: End if;
2332: --
2333: close sel_for_deletion;

Line 2496: fnd_message.set_name('OTA','OTA_13320_TFH_SUPERSEDED');

2492: close get_superseding_header;
2493: return;
2494: else
2495: close get_superseding_header;
2496: fnd_message.set_name('OTA','OTA_13320_TFH_SUPERSEDED');
2497: fnd_message.raise_error;
2498: --
2499: end if;
2500: --

Line 2497: fnd_message.raise_error;

2493: return;
2494: else
2495: close get_superseding_header;
2496: fnd_message.set_name('OTA','OTA_13320_TFH_SUPERSEDED');
2497: fnd_message.raise_error;
2498: --
2499: end if;
2500: --
2501: hr_utility.set_location('Entering:'|| v_proc, 5);