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 FND_MESSAGE

Line 51: fnd_message.set_name('OTA','OTA_13400_TFL_AMOUNT_V');

47: If sel_type_V_amounts%notfound then
48: --
49: Close sel_type_V_amounts;
50: --
51: fnd_message.set_name('OTA','OTA_13400_TFL_AMOUNT_V');
52: fnd_message.raise_error;
53: --
54: Else
55: --

Line 52: fnd_message.raise_error;

48: --
49: Close sel_type_V_amounts;
50: --
51: fnd_message.set_name('OTA','OTA_13400_TFL_AMOUNT_V');
52: fnd_message.raise_error;
53: --
54: Else
55: --
56: Close sel_type_V_amounts;

Line 113: fnd_message.set_name('OTA','OTA_13401_TFL_AMOUNT_R');

109: If sel_type_R_amounts%notfound then
110: --
111: Close sel_type_R_amounts;
112: --
113: fnd_message.set_name('OTA','OTA_13401_TFL_AMOUNT_R');
114: fnd_message.raise_error;
115: --
116: Else
117: --

Line 114: fnd_message.raise_error;

110: --
111: Close sel_type_R_amounts;
112: --
113: fnd_message.set_name('OTA','OTA_13401_TFL_AMOUNT_R');
114: fnd_message.raise_error;
115: --
116: Else
117: --
118: Close sel_type_R_amounts;

Line 182: fnd_message.set_name('OTA','OTA_13402_TFL_AMOUNT_P');

178: If sel_type_P_amounts%notfound then
179: --
180: Close sel_type_P_amounts;
181: --
182: fnd_message.set_name('OTA','OTA_13402_TFL_AMOUNT_P');
183: fnd_message.raise_error;
184: --
185: Else
186: --

Line 183: fnd_message.raise_error;

179: --
180: Close sel_type_P_amounts;
181: --
182: fnd_message.set_name('OTA','OTA_13402_TFL_AMOUNT_P');
183: fnd_message.raise_error;
184: --
185: Else
186: --
187: Close sel_type_P_amounts;

Line 282: fnd_message.set_name('OTA','OTA_13403_TFL_BOOK_DEAL');

278: If sel_book_deal_info%notfound then
279: --
280: Close sel_book_deal_info;
281: --
282: fnd_message.set_name('OTA','OTA_13403_TFL_BOOK_DEAL');
283: fnd_message.raise_error;
284: --
285: End if;
286: --

Line 283: fnd_message.raise_error;

279: --
280: Close sel_book_deal_info;
281: --
282: fnd_message.set_name('OTA','OTA_13403_TFL_BOOK_DEAL');
283: fnd_message.raise_error;
284: --
285: End if;
286: --
287: Close sel_book_deal_info;

Line 403: fnd_message.set_name('OTA','OTA_13404_TFL_AMOUNT_EP');

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

Line 404: fnd_message.raise_error;

400: --
401: Close sel_type_E_tpe_event;
402: --
403: fnd_message.set_name('OTA','OTA_13404_TFL_AMOUNT_EP');
404: fnd_message.raise_error;
405: --
406: Else
407: --
408: Close sel_type_E_tpe_event;

Line 530: fnd_message.set_name('OTA','OTA_13405_TFL_SET_AMOUNT_E');

526: If sel_type_E_evt_event%notfound then
527: --
528: Close sel_type_E_evt_event;
529: --
530: fnd_message.set_name('OTA','OTA_13405_TFL_SET_AMOUNT_E');
531: fnd_message.raise_error;
532: --
533: Else
534: --

Line 531: fnd_message.raise_error;

527: --
528: Close sel_type_E_evt_event;
529: --
530: fnd_message.set_name('OTA','OTA_13405_TFL_SET_AMOUNT_E');
531: fnd_message.raise_error;
532: --
533: Else
534: --
535: Close sel_type_E_evt_event;

Line 605: fnd_message.set_name('OTA','OTA_13406_TFL_SET_AMOUNT_A');

601: If sel_type_E_tav_event%notfound then
602: --
603: Close sel_type_E_tav_event;
604: --
605: fnd_message.set_name('OTA','OTA_13406_TFL_SET_AMOUNT_A');
606: fnd_message.raise_error;
607: --
608: Else
609: --

Line 606: fnd_message.raise_error;

602: --
603: Close sel_type_E_tav_event;
604: --
605: fnd_message.set_name('OTA','OTA_13406_TFL_SET_AMOUNT_A');
606: fnd_message.raise_error;
607: --
608: Else
609: --
610: Close sel_type_E_tav_event;

Line 684: fnd_message.set_name('OTA','OTA_13407_TFL_SET_AMOUNT_C');

680: If sel_type_E_cat_event%notfound then
681: --
682: Close sel_type_E_cat_event;
683: --
684: fnd_message.set_name('OTA','OTA_13407_TFL_SET_AMOUNT_C');
685: fnd_message.raise_error;
686: --
687: Else
688: --

Line 685: fnd_message.raise_error;

681: --
682: Close sel_type_E_cat_event;
683: --
684: fnd_message.set_name('OTA','OTA_13407_TFL_SET_AMOUNT_C');
685: fnd_message.raise_error;
686: --
687: Else
688: --
689: Close sel_type_E_cat_event;

Line 756: fnd_message.set_name('OTA','OTA_13408_TFL_SET_AMOUNT');

752: If sel_event_no_deal%notfound then
753: --
754: Close sel_event_no_deal;
755: --
756: fnd_message.set_name('OTA','OTA_13408_TFL_SET_AMOUNT');
757: fnd_message.raise_error;
758: --
759: Else
760: --

Line 757: fnd_message.raise_error;

753: --
754: Close sel_event_no_deal;
755: --
756: fnd_message.set_name('OTA','OTA_13408_TFL_SET_AMOUNT');
757: fnd_message.raise_error;
758: --
759: Else
760: --
761: Close sel_event_no_deal;

Line 1173: fnd_message.set_name('OTA','OTA_13359_TFL_COPY_LINES');

1169: --
1170: If p_finance_header_id_to is null OR
1171: p_finance_header_id_to = p_finance_header_id_from Then
1172: --
1173: fnd_message.set_name('OTA','OTA_13359_TFL_COPY_LINES');
1174: fnd_message.raise_error;
1175: --
1176: End if;
1177: --

Line 1174: fnd_message.raise_error;

1170: If p_finance_header_id_to is null OR
1171: p_finance_header_id_to = p_finance_header_id_from Then
1172: --
1173: fnd_message.set_name('OTA','OTA_13359_TFL_COPY_LINES');
1174: fnd_message.raise_error;
1175: --
1176: End if;
1177: --
1178: Open sel_finance_lines;

Line 1236: fnd_message.set_name('OTA','OTA_13360_TFL_CANCEL_LINES');

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');
1237: fnd_message.raise_error;
1238: --
1239: hr_utility.set_location('Entering:'|| v_proc, 5);
1240: Else

Line 1237: fnd_message.raise_error;

1233: --
1234: If p_rec_cancel.finance_line_id is null Then
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: --

Line 1302: fnd_message.set_name('OTA','OTA_13409_TFL_SET_CANCEL');

1298: If sel_finance_lines%notfound then
1299: --
1300: Close sel_finance_lines;
1301: --
1302: fnd_message.set_name('OTA','OTA_13409_TFL_SET_CANCEL');
1303: fnd_message.raise_error;
1304: --
1305: Else
1306: --

Line 1303: fnd_message.raise_error;

1299: --
1300: Close sel_finance_lines;
1301: --
1302: fnd_message.set_name('OTA','OTA_13409_TFL_SET_CANCEL');
1303: fnd_message.raise_error;
1304: --
1305: Else
1306: --
1307: Loop

Line 1380: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

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;
1383: --
1384: ElsIf p_cancelled_flag = 'Y' Then

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

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;
1383: --
1384: ElsIf p_cancelled_flag = 'Y' Then
1385: hr_utility.set_location('Entering:'|| v_proc, 3);

Line 1382: fnd_message.raise_error;

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;
1383: --
1384: ElsIf p_cancelled_flag = 'Y' Then
1385: hr_utility.set_location('Entering:'|| v_proc, 3);
1386: --

Line 1389: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

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');
1390: fnd_message.set_token('STEP','2');
1391: fnd_message.raise_error;
1392: --
1393: /*

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

1386: --
1387: -- * Line is cancelled
1388: --
1389: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1390: fnd_message.set_token('STEP','2');
1391: fnd_message.raise_error;
1392: --
1393: /*
1394: ElsIf p_transfer_status = 'ST' Then

Line 1391: fnd_message.raise_error;

1387: -- * Line is cancelled
1388: --
1389: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1390: fnd_message.set_token('STEP','2');
1391: fnd_message.raise_error;
1392: --
1393: /*
1394: ElsIf p_transfer_status = 'ST' Then
1395: hr_utility.set_location('Entering:'|| v_proc, 4);

Line 1399: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

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');
1400: fnd_message.set_token('STEP','3');
1401: fnd_message.raise_error;
1402: */
1403: Else

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

1396: --
1397: -- * Line has been successful transferred
1398: --
1399: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1400: fnd_message.set_token('STEP','3');
1401: fnd_message.raise_error;
1402: */
1403: Else
1404: --

Line 1401: fnd_message.raise_error;

1397: -- * Line has been successful transferred
1398: --
1399: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1400: fnd_message.set_token('STEP','3');
1401: fnd_message.raise_error;
1402: */
1403: Else
1404: --
1405: /*

Line 1416: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

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');
1417: fnd_message.set_token('STEP','4');
1418: fnd_message.raise_error;
1419: --
1420: ElsIf v_header_transfer_status = 'ST' Then

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

1413: --
1414: Close sel_finance_header;
1415: --
1416: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
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);

Line 1418: fnd_message.raise_error;

1414: Close sel_finance_header;
1415: --
1416: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
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: --

Line 1425: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

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');
1426: fnd_message.set_token('STEP','5');
1427: fnd_message.raise_error;
1428: --
1429: End if;

Line 1426: fnd_message.set_token('STEP','5');

1422: --
1423: -- * Finance Header has been successfull transferred
1424: --
1425: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1426: fnd_message.set_token('STEP','5');
1427: fnd_message.raise_error;
1428: --
1429: End if;
1430: --

Line 1427: fnd_message.raise_error;

1423: -- * Finance Header has been successfull transferred
1424: --
1425: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1426: fnd_message.set_token('STEP','5');
1427: fnd_message.raise_error;
1428: --
1429: End if;
1430: --
1431: End if;

Line 1442: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');

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');
1443: fnd_message.set_token('STEP','6');
1444: fnd_message.raise_error;
1445: --
1446: Else

Line 1443: fnd_message.set_token('STEP','6');

1439: --
1440: Close sel_finance_line;
1441: --
1442: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1443: fnd_message.set_token('STEP','6');
1444: fnd_message.raise_error;
1445: --
1446: Else
1447: --

Line 1444: fnd_message.raise_error;

1440: Close sel_finance_line;
1441: --
1442: fnd_message.set_name('OTA','OTA_13410_TFL_CANCEL_LINES');
1443: fnd_message.set_token('STEP','6');
1444: fnd_message.raise_error;
1445: --
1446: Else
1447: --
1448: Close sel_finance_line;

Line 1552: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');

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');
1553: fnd_message.set_token('STEP','1');
1554: fnd_message.raise_error;
1555: --
1556: ElsIf p_cancelled_flag = 'N' Then

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

1549: --
1550: If p_finance_line_id is null Then
1551: --
1552: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1553: fnd_message.set_token('STEP','1');
1554: fnd_message.raise_error;
1555: --
1556: ElsIf p_cancelled_flag = 'N' Then
1557: --

Line 1554: fnd_message.raise_error;

1550: If p_finance_line_id is null Then
1551: --
1552: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1553: fnd_message.set_token('STEP','1');
1554: fnd_message.raise_error;
1555: --
1556: ElsIf p_cancelled_flag = 'N' Then
1557: --
1558: -- * Line is not cancelled

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

1556: ElsIf p_cancelled_flag = 'N' Then
1557: --
1558: -- * Line is not cancelled
1559: --
1560: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1561: fnd_message.set_token('STEP','2');
1562: fnd_message.raise_error;
1563: --
1564: /*

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

1557: --
1558: -- * Line is not cancelled
1559: --
1560: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1561: fnd_message.set_token('STEP','2');
1562: fnd_message.raise_error;
1563: --
1564: /*
1565: ElsIf p_transfer_status = 'ST' Then

Line 1562: fnd_message.raise_error;

1558: -- * Line is not cancelled
1559: --
1560: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1561: fnd_message.set_token('STEP','2');
1562: fnd_message.raise_error;
1563: --
1564: /*
1565: ElsIf p_transfer_status = 'ST' Then
1566: --

Line 1569: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');

1565: ElsIf p_transfer_status = 'ST' Then
1566: --
1567: -- * Line has been successful transferred
1568: --
1569: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1570: fnd_message.set_token('STEP','3');
1571: fnd_message.raise_error;
1572: --
1573: */

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

1566: --
1567: -- * Line has been successful transferred
1568: --
1569: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1570: fnd_message.set_token('STEP','3');
1571: fnd_message.raise_error;
1572: --
1573: */
1574: Else

Line 1571: fnd_message.raise_error;

1567: -- * Line has been successful transferred
1568: --
1569: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1570: fnd_message.set_token('STEP','3');
1571: fnd_message.raise_error;
1572: --
1573: */
1574: Else
1575: --

Line 1586: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');

1582: If sel_finance_header%notfound then
1583: --
1584: Close sel_finance_header;
1585: --
1586: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1587: fnd_message.set_token('STEP','4');
1588: fnd_message.raise_error;
1589: --
1590: ElsIf v_header_transfer_status = 'ST' Then

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

1583: --
1584: Close sel_finance_header;
1585: --
1586: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1587: fnd_message.set_token('STEP','4');
1588: fnd_message.raise_error;
1589: --
1590: ElsIf v_header_transfer_status = 'ST' Then
1591: --

Line 1588: fnd_message.raise_error;

1584: Close sel_finance_header;
1585: --
1586: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1587: fnd_message.set_token('STEP','4');
1588: fnd_message.raise_error;
1589: --
1590: ElsIf v_header_transfer_status = 'ST' Then
1591: --
1592: -- * Finance Header has been successfull transferred

Line 1594: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');

1590: ElsIf v_header_transfer_status = 'ST' Then
1591: --
1592: -- * Finance Header has been successfull transferred
1593: --
1594: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1595: fnd_message.set_token('STEP','5');
1596: fnd_message.raise_error;
1597: --
1598: End if;

Line 1595: fnd_message.set_token('STEP','5');

1591: --
1592: -- * Finance Header has been successfull transferred
1593: --
1594: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1595: fnd_message.set_token('STEP','5');
1596: fnd_message.raise_error;
1597: --
1598: End if;
1599: --

Line 1596: fnd_message.raise_error;

1592: -- * Finance Header has been successfull transferred
1593: --
1594: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1595: fnd_message.set_token('STEP','5');
1596: fnd_message.raise_error;
1597: --
1598: End if;
1599: --
1600: End if;

Line 1610: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');

1606: If sel_finance_line%notfound then
1607: --
1608: Close sel_finance_line;
1609: --
1610: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1611: fnd_message.set_token('STEP','6');
1612: fnd_message.raise_error;
1613: --
1614: Else

Line 1611: fnd_message.set_token('STEP','6');

1607: --
1608: Close sel_finance_line;
1609: --
1610: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1611: fnd_message.set_token('STEP','6');
1612: fnd_message.raise_error;
1613: --
1614: Else
1615: --

Line 1612: fnd_message.raise_error;

1608: Close sel_finance_line;
1609: --
1610: fnd_message.set_name('OTA','OTA_13361_TFL_RECANCEL_LINES');
1611: fnd_message.set_token('STEP','6');
1612: fnd_message.raise_error;
1613: --
1614: Else
1615: --
1616: Close sel_finance_line;