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_TDB_BUS dependencies on FND_MESSAGE

Line 83: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

79: IF NOT ota_tdb_shd.api_updating
80: (p_booking_id => p_rec.booking_id
81: ,p_object_version_number => p_rec.object_version_number
82: ) THEN
83: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE ', l_proc);
85: fnd_message.set_token('STEP ', '5');
86: fnd_message.raise_error;
87: END IF;

Line 84: fnd_message.set_token('PROCEDURE ', l_proc);

80: (p_booking_id => p_rec.booking_id
81: ,p_object_version_number => p_rec.object_version_number
82: ) THEN
83: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE ', l_proc);
85: fnd_message.set_token('STEP ', '5');
86: fnd_message.raise_error;
87: END IF;
88:

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

81: ,p_object_version_number => p_rec.object_version_number
82: ) THEN
83: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE ', l_proc);
85: fnd_message.set_token('STEP ', '5');
86: fnd_message.raise_error;
87: END IF;
88:
89: if nvl(p_rec.business_group_id,hr_api.g_number) <>

Line 86: fnd_message.raise_error;

82: ) THEN
83: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE ', l_proc);
85: fnd_message.set_token('STEP ', '5');
86: fnd_message.raise_error;
87: END IF;
88:
89: if nvl(p_rec.business_group_id,hr_api.g_number) <>
90: nvl(ota_tdb_shd.g_old_rec.business_group_id,hr_api.g_number)

Line 185: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

181: close csr_sec_grp;
182: --
183: -- The primary key is invalid therefore we must error
184: --
185: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
186: hr_multi_message.add
187: (p_associated_column1
188: => nvl(p_associated_column1,'BOOKING_ID')
189: );

Line 290: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

286: --
287: -- The primary key is invalid therefore we must error
288: --
289: close csr_leg_code;
290: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
291: fnd_message.raise_error;
292: end if;
293: hr_utility.set_location(l_proc,30);
294: --

Line 291: fnd_message.raise_error;

287: -- The primary key is invalid therefore we must error
288: --
289: close csr_leg_code;
290: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
291: fnd_message.raise_error;
292: end if;
293: hr_utility.set_location(l_proc,30);
294: --
295: -- Set the global variables so the values are

Line 344: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');

340: l_event_exists);
341: --
342: if not l_event_exists then
343: --
344: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
345: fnd_message.set_token ('TABLE_NAME', 'OTA_EVENTS');
346: fnd_message.set_token ('COLUMN_NAME', 'EVENT_ID');
347: fnd_message.raise_error;
348: --

Line 345: fnd_message.set_token ('TABLE_NAME', 'OTA_EVENTS');

341: --
342: if not l_event_exists then
343: --
344: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
345: fnd_message.set_token ('TABLE_NAME', 'OTA_EVENTS');
346: fnd_message.set_token ('COLUMN_NAME', 'EVENT_ID');
347: fnd_message.raise_error;
348: --
349: end if;

Line 346: fnd_message.set_token ('COLUMN_NAME', 'EVENT_ID');

342: if not l_event_exists then
343: --
344: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
345: fnd_message.set_token ('TABLE_NAME', 'OTA_EVENTS');
346: fnd_message.set_token ('COLUMN_NAME', 'EVENT_ID');
347: fnd_message.raise_error;
348: --
349: end if;
350: --

Line 347: fnd_message.raise_error;

343: --
344: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
345: fnd_message.set_token ('TABLE_NAME', 'OTA_EVENTS');
346: fnd_message.set_token ('COLUMN_NAME', 'EVENT_ID');
347: fnd_message.raise_error;
348: --
349: end if;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

421: procedure check_authorizer (p_person_id in number) is
422: begin
423: if p_person_id is not null then
424: if not ota_general.check_fnd_user(p_person_id) then
425: fnd_message.set_name ('OTA', 'OTA_13281_TFH_AUTHORIZER');
426: fnd_message.raise_error;
427: end if;
428: end if;
429: end;

Line 426: fnd_message.raise_error;

422: begin
423: if p_person_id is not null then
424: if not ota_general.check_fnd_user(p_person_id) then
425: fnd_message.set_name ('OTA', 'OTA_13281_TFH_AUTHORIZER');
426: fnd_message.raise_error;
427: end if;
428: end if;
429: end;
430: -- ---------------------------------------------------------------------

Line 820: fnd_message.set_name ('OTA', 'OTA_13200_TDB_SINGLE_BOOKING');

816: -- check that if the delegate is specified then the number of places is one
817: --
818: if p_delegate_person_id is not null and p_number_of_places > 1 then
819: --
820: fnd_message.set_name ('OTA', 'OTA_13200_TDB_SINGLE_BOOKING');
821: fnd_message.raise_error;
822: --
823: end if;
824: --

Line 821: fnd_message.raise_error;

817: --
818: if p_delegate_person_id is not null and p_number_of_places > 1 then
819: --
820: fnd_message.set_name ('OTA', 'OTA_13200_TDB_SINGLE_BOOKING');
821: fnd_message.raise_error;
822: --
823: end if;
824: --
825: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 867: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');

863: if l_booking is not null then
864: --
865: if l_booking <> nvl(p_booking_id, hr_api.g_number) then
866: --
867: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');
868: fnd_message.raise_error;
869: --
870: end if;
871: --

Line 868: fnd_message.raise_error;

864: --
865: if l_booking <> nvl(p_booking_id, hr_api.g_number) then
866: --
867: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');
868: fnd_message.raise_error;
869: --
870: end if;
871: --
872: end if;

Line 890: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');

886: if l_booking is not null then
887: --
888: if l_booking <> nvl(p_booking_id, hr_api.g_number) then
889: --
890: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');
891: fnd_message.raise_error;
892: --
893: end if;
894: --

Line 891: fnd_message.raise_error;

887: --
888: if l_booking <> nvl(p_booking_id, hr_api.g_number) then
889: --
890: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');
891: fnd_message.raise_error;
892: --
893: end if;
894: --
895: end if;

Line 922: fnd_message.set_name ('OTA', 'OTA_13466_TDB_SUCC_FAIL_EXCL');

918: hr_utility.set_location('Entering:'||l_proc, 5);
919: --
920: if p_failure_reason is not null and p_successful_attendance_flag = 'Y' then
921: --
922: fnd_message.set_name ('OTA', 'OTA_13466_TDB_SUCC_FAIL_EXCL');
923: fnd_message.raise_error;
924: --
925: --
926: end if;

Line 923: fnd_message.raise_error;

919: --
920: if p_failure_reason is not null and p_successful_attendance_flag = 'Y' then
921: --
922: fnd_message.set_name ('OTA', 'OTA_13466_TDB_SUCC_FAIL_EXCL');
923: fnd_message.raise_error;
924: --
925: --
926: end if;
927: --

Line 1003: fnd_message.set_name ('OTA','OTA_13580_MAX_INT_EXCEEDED');

999: -- Check if number of places available is exceeded by number required
1000: --
1001: if p_number_of_places > (l_max_internal - l_number_taken) then
1002: --
1003: fnd_message.set_name ('OTA','OTA_13580_MAX_INT_EXCEEDED');
1004: fnd_message.raise_error;
1005: --
1006: end if;
1007: --

Line 1004: fnd_message.raise_error;

1000: --
1001: if p_number_of_places > (l_max_internal - l_number_taken) then
1002: --
1003: fnd_message.set_name ('OTA','OTA_13580_MAX_INT_EXCEEDED');
1004: fnd_message.raise_error;
1005: --
1006: end if;
1007: --
1008: end if;

Line 1037: fnd_message.set_name ('OTA', 'OTA_13237_TDB_SUCCESS_CONFIRM');

1033: if booking_status_type (p_booking_status_type_id) not in
1034: (g_attended_booking,g_cancelled_booking)
1035: then
1036: --
1037: fnd_message.set_name ('OTA', 'OTA_13237_TDB_SUCCESS_CONFIRM');
1038: fnd_message.raise_error;
1039: --
1040: end if;
1041: --

Line 1038: fnd_message.raise_error;

1034: (g_attended_booking,g_cancelled_booking)
1035: then
1036: --
1037: fnd_message.set_name ('OTA', 'OTA_13237_TDB_SUCCESS_CONFIRM');
1038: fnd_message.raise_error;
1039: --
1040: end if;
1041: --
1042: end if;

Line 1069: fnd_message.set_name ('OTA', 'OTA_13252_TDB_FUTURE_STATUS');

1065: -- do not allow update if status has been changed after the session date
1066: --
1067: if p_date_status_changed < p_previous_status_change then
1068: --
1069: fnd_message.set_name ('OTA', 'OTA_13252_TDB_FUTURE_STATUS');
1070: fnd_message.raise_error;
1071: --
1072: --
1073: end if;

Line 1070: fnd_message.raise_error;

1066: --
1067: if p_date_status_changed < p_previous_status_change then
1068: --
1069: fnd_message.set_name ('OTA', 'OTA_13252_TDB_FUTURE_STATUS');
1070: fnd_message.raise_error;
1071: --
1072: --
1073: end if;
1074: --

Line 1220: fnd_message.set_name ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');

1216: if c_details%found then
1217: --
1218: close c_details;
1219: -- bug 4499950
1220: fnd_message.set_name ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
1221: fnd_message.raise_error;
1222: --
1223: --
1224: end if;

Line 1221: fnd_message.raise_error;

1217: --
1218: close c_details;
1219: -- bug 4499950
1220: fnd_message.set_name ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
1221: fnd_message.raise_error;
1222: --
1223: --
1224: end if;
1225: --

Line 1266: fnd_message.set_name ('OTA', 'OTA_13609_TDB_CHK_TFL');

1262: hr_utility.set_location('Leaving:'|| l_proc, 10);
1263: --
1264: if l_finance_line_exists <> 0 then
1265: --
1266: fnd_message.set_name ('OTA', 'OTA_13609_TDB_CHK_TFL');
1267: fnd_message.raise_error;
1268: --
1269: end if;
1270: --

Line 1267: fnd_message.raise_error;

1263: --
1264: if l_finance_line_exists <> 0 then
1265: --
1266: fnd_message.set_name ('OTA', 'OTA_13609_TDB_CHK_TFL');
1267: fnd_message.raise_error;
1268: --
1269: end if;
1270: --
1271: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1307: fnd_message.set_name ('OTA', 'OTA_13822_TBD_NO_DEL_TPC_EXIST');

1303: fetch Csr_chk_tpc_rows into v_exists;
1304: close Csr_chk_tpc_rows;
1305: --
1306: if v_exists = 'Y' then
1307: fnd_message.set_name ('OTA', 'OTA_13822_TBD_NO_DEL_TPC_EXIST');
1308: fnd_message.raise_error;
1309: end if;
1310: --
1311: hr_utility.set_location('Leaving:' || l_proc, 10);

Line 1308: fnd_message.raise_error;

1304: close Csr_chk_tpc_rows;
1305: --
1306: if v_exists = 'Y' then
1307: fnd_message.set_name ('OTA', 'OTA_13822_TBD_NO_DEL_TPC_EXIST');
1308: fnd_message.raise_error;
1309: end if;
1310: --
1311: hr_utility.set_location('Leaving:' || l_proc, 10);
1312: --

Line 1347: fnd_message.set_name ('OTA', 'OTA_13592_BUS_GROUP_DEL_BST');

1343: open c_same_business_group;
1344: fetch c_same_business_group into l_dummy;
1345: if c_same_business_group%notfound then
1346: --
1347: fnd_message.set_name ('OTA', 'OTA_13592_BUS_GROUP_DEL_BST');
1348: fnd_message.raise_error;
1349: --
1350: --
1351: end if;

Line 1348: fnd_message.raise_error;

1344: fetch c_same_business_group into l_dummy;
1345: if c_same_business_group%notfound then
1346: --
1347: fnd_message.set_name ('OTA', 'OTA_13592_BUS_GROUP_DEL_BST');
1348: fnd_message.raise_error;
1349: --
1350: --
1351: end if;
1352: --

Line 1414: fnd_message.set_name ('OTA', 'OTA_13591_BUS_GROUP_DEL_EVT');

1410: get_event (p_event_id, p_event_record_use);
1411: --
1412: if g_event_rec.business_group_id <> p_business_group_id then
1413: --
1414: fnd_message.set_name ('OTA', 'OTA_13591_BUS_GROUP_DEL_EVT');
1415: fnd_message.raise_error;
1416: --
1417: end if;
1418: --

Line 1415: fnd_message.raise_error;

1411: --
1412: if g_event_rec.business_group_id <> p_business_group_id then
1413: --
1414: fnd_message.set_name ('OTA', 'OTA_13591_BUS_GROUP_DEL_EVT');
1415: fnd_message.raise_error;
1416: --
1417: end if;
1418: --
1419: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1686: fnd_message.set_name ('OTA','OTA_13623_TDB_NO_STATUS');

1682: hr_utility.set_location('Entering:'||l_proc, 5);
1683: --
1684: if booking_status_type (p_booking_status_type_id) is null then
1685: --
1686: fnd_message.set_name ('OTA','OTA_13623_TDB_NO_STATUS');
1687: fnd_message.raise_error;
1688: --
1689: else
1690: /* bug 3677661 */

Line 1687: fnd_message.raise_error;

1683: --
1684: if booking_status_type (p_booking_status_type_id) is null then
1685: --
1686: fnd_message.set_name ('OTA','OTA_13623_TDB_NO_STATUS');
1687: fnd_message.raise_error;
1688: --
1689: else
1690: /* bug 3677661 */
1691:

Line 1702: fnd_message.set_name('OTA','OTA_443469_TDB_ATTENDED_STATUS');

1698: fetch csr_booking_sts into l_status;
1699: close csr_booking_sts;
1700: --
1701: if l_status is not null then
1702: fnd_message.set_name('OTA','OTA_443469_TDB_ATTENDED_STATUS');
1703: fnd_message.set_token('STATUS', l_status);
1704: fnd_message.raise_error;
1705:
1706: end if;

Line 1703: fnd_message.set_token('STATUS', l_status);

1699: close csr_booking_sts;
1700: --
1701: if l_status is not null then
1702: fnd_message.set_name('OTA','OTA_443469_TDB_ATTENDED_STATUS');
1703: fnd_message.set_token('STATUS', l_status);
1704: fnd_message.raise_error;
1705:
1706: end if;
1707: end if;

Line 1704: fnd_message.raise_error;

1700: --
1701: if l_status is not null then
1702: fnd_message.set_name('OTA','OTA_443469_TDB_ATTENDED_STATUS');
1703: fnd_message.set_token('STATUS', l_status);
1704: fnd_message.raise_error;
1705:
1706: end if;
1707: end if;
1708: /* bug 3677661 */

Line 1890: fnd_message.set_name ('OTA','OTA_13239_TDB_NO_EVENT_ASSOC');

1886: p_parent_offering_id => l_parent_offering_id);
1887: close event_details;
1888:
1889: if l_learner_can_enroll = 'N' then
1890: fnd_message.set_name ('OTA','OTA_13239_TDB_NO_EVENT_ASSOC');
1891: fnd_message.raise_error;
1892: end if;
1893: else
1894: /* Bug No. 4201444 */

Line 1891: fnd_message.raise_error;

1887: close event_details;
1888:
1889: if l_learner_can_enroll = 'N' then
1890: fnd_message.set_name ('OTA','OTA_13239_TDB_NO_EVENT_ASSOC');
1891: fnd_message.raise_error;
1892: end if;
1893: else
1894: /* Bug No. 4201444 */
1895: open c_event_association(l_party_id); /* bug 3463908 */

Line 1902: fnd_message.set_name ('OTA','OTA_13239_TDB_NO_EVENT_ASSOC');

1898: if c_event_association%notfound then
1899: --
1900: close c_event_association;
1901: --
1902: fnd_message.set_name ('OTA','OTA_13239_TDB_NO_EVENT_ASSOC');
1903: fnd_message.raise_error;
1904: --
1905: end if;
1906: --

Line 1903: fnd_message.raise_error;

1899: --
1900: close c_event_association;
1901: --
1902: fnd_message.set_name ('OTA','OTA_13239_TDB_NO_EVENT_ASSOC');
1903: fnd_message.raise_error;
1904: --
1905: end if;
1906: --
1907: close c_event_association;

Line 1932: fnd_message.set_name ('OTA','OTA_13524_DELEGATE_ASSOCIATION');

1928: p_max_internal => l_max_internal ,
1929: p_event_start_date => l_event_start_date ,
1930: p_parent_offering_id => l_parent_offering_id);
1931: if l_learner_can_enroll = 'N' then
1932: fnd_message.set_name ('OTA','OTA_13524_DELEGATE_ASSOCIATION');
1933: fnd_message.raise_error;
1934: end if;
1935: end if;
1936: /* bug no 3460968 */

Line 1933: fnd_message.raise_error;

1929: p_event_start_date => l_event_start_date ,
1930: p_parent_offering_id => l_parent_offering_id);
1931: if l_learner_can_enroll = 'N' then
1932: fnd_message.set_name ('OTA','OTA_13524_DELEGATE_ASSOCIATION');
1933: fnd_message.raise_error;
1934: end if;
1935: end if;
1936: /* bug no 3460968 */
1937: --

Line 1987: fnd_message.set_name ('OTA','OTA_13524_DELEGATE_ASSOCIATION');

1983: if not l_found then
1984: --
1985: -- Display error message
1986: --
1987: fnd_message.set_name ('OTA','OTA_13524_DELEGATE_ASSOCIATION');
1988: fnd_message.raise_error;
1989: --
1990: end if;
1991: --

Line 1988: fnd_message.raise_error;

1984: --
1985: -- Display error message
1986: --
1987: fnd_message.set_name ('OTA','OTA_13524_DELEGATE_ASSOCIATION');
1988: fnd_message.raise_error;
1989: --
1990: end if;
1991: --
1992: end if;

Line 2205: fnd_message.set_name ('OTA','OTA_13581_TDB_NO_PROGRAMME');

2201: if c_customer_parent_booking%notfound then
2202: --
2203: close c_customer_parent_booking;
2204: --
2205: fnd_message.set_name ('OTA','OTA_13581_TDB_NO_PROGRAMME');
2206: fnd_message.raise_error;
2207: --
2208: end if;
2209: --

Line 2206: fnd_message.raise_error;

2202: --
2203: close c_customer_parent_booking;
2204: --
2205: fnd_message.set_name ('OTA','OTA_13581_TDB_NO_PROGRAMME');
2206: fnd_message.raise_error;
2207: --
2208: end if;
2209: --
2210: close c_customer_parent_booking;

Line 2222: fnd_message.set_name ('OTA','OTA_13581_TDB_NO_PROGRAMME');

2218: if c_organization_parent_booking%notfound then
2219: --
2220: close c_organization_parent_booking;
2221: --
2222: fnd_message.set_name ('OTA','OTA_13581_TDB_NO_PROGRAMME');
2223: fnd_message.raise_error;
2224: --
2225: end if;
2226: --

Line 2223: fnd_message.raise_error;

2219: --
2220: close c_organization_parent_booking;
2221: --
2222: fnd_message.set_name ('OTA','OTA_13581_TDB_NO_PROGRAMME');
2223: fnd_message.raise_error;
2224: --
2225: end if;
2226: --
2227: close c_organization_parent_booking;

Line 2549: fnd_message.set_name ('OTA', 'OTA_13599_EVT_VALID_BOOKINGS');

2545: and nvl(l_enrollment_ed, to_date ('31/12/4712','DD/MM/YYYY'))) THEN
2546: RETURN 'N';
2547: ELSE
2548: IF p_throw_error = 'Y' THEN
2549: fnd_message.set_name ('OTA', 'OTA_13599_EVT_VALID_BOOKINGS');
2550: fnd_message.raise_error;
2551: ELSE
2552: RETURN 'Y';
2553: END IF;

Line 2550: fnd_message.raise_error;

2546: RETURN 'N';
2547: ELSE
2548: IF p_throw_error = 'Y' THEN
2549: fnd_message.set_name ('OTA', 'OTA_13599_EVT_VALID_BOOKINGS');
2550: fnd_message.raise_error;
2551: ELSE
2552: RETURN 'Y';
2553: END IF;
2554: END IF;

Line 2615: fnd_message.set_name ('OTA', 'OTA_13249_TDB_CLOSED_EVENT');

2611: --
2612: if closed_event (p_event_id, 'SAME EVENT') then
2613: --
2614: --
2615: fnd_message.set_name ('OTA', 'OTA_13249_TDB_CLOSED_EVENT');
2616: fnd_message.raise_error;
2617: --
2618: --
2619: --

Line 2616: fnd_message.raise_error;

2612: if closed_event (p_event_id, 'SAME EVENT') then
2613: --
2614: --
2615: fnd_message.set_name ('OTA', 'OTA_13249_TDB_CLOSED_EVENT');
2616: fnd_message.raise_error;
2617: --
2618: --
2619: --
2620: -- check if the enrolment dates of the event are given

Line 2625: fnd_message.set_name ('OTA', 'OTA_13250_TDB_NO_ENROLMENT');

2621: -- if not given then no bookings are allowed
2622: --
2623: elsif not enrolling (p_event_id, 'SAME EVENT') then
2624: --
2625: fnd_message.set_name ('OTA', 'OTA_13250_TDB_NO_ENROLMENT');
2626: fnd_message.raise_error;
2627: --
2628: --
2629: -- check if the booking date falls between the enrolment dates of the event

Line 2626: fnd_message.raise_error;

2622: --
2623: elsif not enrolling (p_event_id, 'SAME EVENT') then
2624: --
2625: fnd_message.set_name ('OTA', 'OTA_13250_TDB_NO_ENROLMENT');
2626: fnd_message.raise_error;
2627: --
2628: --
2629: -- check if the booking date falls between the enrolment dates of the event
2630: --

Line 2635: fnd_message.set_name ('OTA', 'OTA_13583_TDB_NO_ENROLL_DATE');

2631: elsif not enrolling_on_date (p_event_id,p_date_booking_placed,'SAME EVENT')
2632: then
2633: --
2634: --
2635: fnd_message.set_name ('OTA', 'OTA_13583_TDB_NO_ENROLL_DATE');
2636: fnd_message.raise_error;
2637: --
2638: --
2639: end if;

Line 2636: fnd_message.raise_error;

2632: then
2633: --
2634: --
2635: fnd_message.set_name ('OTA', 'OTA_13583_TDB_NO_ENROLL_DATE');
2636: fnd_message.raise_error;
2637: --
2638: --
2639: end if;
2640: --

Line 3069: fnd_message.set_name('OTA', 'OTA_13685_TDB_PMM_EXISTS');

3065: fetch c_pmm_ext_enrollments into l_result;
3066: if c_pmm_ext_enrollments%found then
3067: --
3068: close c_pmm_ext_enrollments;
3069: fnd_message.set_name('OTA', 'OTA_13685_TDB_PMM_EXISTS');
3070: fnd_message.raise_error;
3071: --
3072: else
3073: --

Line 3070: fnd_message.raise_error;

3066: if c_pmm_ext_enrollments%found then
3067: --
3068: close c_pmm_ext_enrollments;
3069: fnd_message.set_name('OTA', 'OTA_13685_TDB_PMM_EXISTS');
3070: fnd_message.raise_error;
3071: --
3072: else
3073: --
3074: close c_pmm_ext_enrollments;

Line 3085: fnd_message.set_name('OTA', 'OTA_13685_TDB_PMM_EXISTS');

3081: fetch c_pmm_int_enrollments into l_result;
3082: if c_pmm_int_enrollments%found then
3083: --
3084: close c_pmm_int_enrollments;
3085: fnd_message.set_name('OTA', 'OTA_13685_TDB_PMM_EXISTS');
3086: fnd_message.raise_error;
3087: --
3088: else
3089: --

Line 3086: fnd_message.raise_error;

3082: if c_pmm_int_enrollments%found then
3083: --
3084: close c_pmm_int_enrollments;
3085: fnd_message.set_name('OTA', 'OTA_13685_TDB_PMM_EXISTS');
3086: fnd_message.raise_error;
3087: --
3088: else
3089: --
3090: close c_pmm_int_enrollments;

Line 3137: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');

3133: open csr_order_line;
3134: fetch csr_order_line into l_exists;
3135: if csr_order_line%notfound then
3136: close csr_order_line;
3137: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');
3138: fnd_message.raise_error;
3139: end if;
3140: close csr_order_line;
3141: hr_utility.set_location('Entering:'||l_proc, 20);

Line 3138: fnd_message.raise_error;

3134: fetch csr_order_line into l_exists;
3135: if csr_order_line%notfound then
3136: close csr_order_line;
3137: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');
3138: fnd_message.raise_error;
3139: end if;
3140: close csr_order_line;
3141: hr_utility.set_location('Entering:'||l_proc, 20);
3142: end if;

Line 3162: fnd_message.set_name('OTA','OTA_13885_TDB_ORDER_LINE_EXIST');

3158: Begin
3159: hr_utility.set_location('Entering:'||l_proc, 5);
3160:
3161: if p_line_id is not null then
3162: fnd_message.set_name('OTA','OTA_13885_TDB_ORDER_LINE_EXIST');
3163: fnd_message.raise_error;
3164: hr_utility.set_location('Entering:'||l_proc, 20);
3165:
3166: end if;

Line 3163: fnd_message.raise_error;

3159: hr_utility.set_location('Entering:'||l_proc, 5);
3160:
3161: if p_line_id is not null then
3162: fnd_message.set_name('OTA','OTA_13885_TDB_ORDER_LINE_EXIST');
3163: fnd_message.raise_error;
3164: hr_utility.set_location('Entering:'||l_proc, 20);
3165:
3166: end if;
3167: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 3385: fnd_message.set_name('OTA','OTA_443939_SECURE_EVT_LRN_ERR');

3381: FETCH csr_is_secure_event INTO l_organization_id;
3382: IF csr_is_secure_event%FOUND THEN
3383: l_is_match := ota_utility.check_organization_match(p_delegate_person_id,l_organization_id);
3384: IF l_is_match = 'N' THEN
3385: fnd_message.set_name('OTA','OTA_443939_SECURE_EVT_LRN_ERR');
3386: fnd_message.raise_error;
3387: END IF;
3388: END IF;
3389: CLOSE csr_is_secure_event;

Line 3386: fnd_message.raise_error;

3382: IF csr_is_secure_event%FOUND THEN
3383: l_is_match := ota_utility.check_organization_match(p_delegate_person_id,l_organization_id);
3384: IF l_is_match = 'N' THEN
3385: fnd_message.set_name('OTA','OTA_443939_SECURE_EVT_LRN_ERR');
3386: fnd_message.raise_error;
3387: END IF;
3388: END IF;
3389: CLOSE csr_is_secure_event;
3390: END check_secure_event;

Line 3490: fnd_message.set_name ('OTA','OTA_443964_TDB_STATUS_CHG_ERR');

3486: FETCH csr_get_performance_data INTO l_player_status;
3487: CLOSE csr_get_performance_data;
3488:
3489: IF l_player_status = 'P' OR l_player_status = 'C' THEN
3490: fnd_message.set_name ('OTA','OTA_443964_TDB_STATUS_CHG_ERR');
3491: fnd_message.raise_error;
3492: END IF;
3493:
3494:

Line 3491: fnd_message.raise_error;

3487: CLOSE csr_get_performance_data;
3488:
3489: IF l_player_status = 'P' OR l_player_status = 'C' THEN
3490: fnd_message.set_name ('OTA','OTA_443964_TDB_STATUS_CHG_ERR');
3491: fnd_message.raise_error;
3492: END IF;
3493:
3494:
3495: END IF;

Line 3790: fnd_message.set_name ('OTA','OTA_13506_ADDRESS_TYPE_NOT_I');

3786: --
3787: -- Person address type should be external
3788: -- show error
3789: --
3790: fnd_message.set_name ('OTA','OTA_13506_ADDRESS_TYPE_NOT_I');
3791: fnd_message.raise_error;
3792: --
3793: -- Address must be a valid one for the correspondent
3794: --

Line 3791: fnd_message.raise_error;

3787: -- Person address type should be external
3788: -- show error
3789: --
3790: fnd_message.set_name ('OTA','OTA_13506_ADDRESS_TYPE_NOT_I');
3791: fnd_message.raise_error;
3792: --
3793: -- Address must be a valid one for the correspondent
3794: --
3795: else

Line 4174: fnd_message.set_name ('OTA','OTA_13506_ADDRESS_TYPE_NOT_I');

4170: --
4171: -- Person address type should be internal
4172: -- show error
4173: --
4174: fnd_message.set_name ('OTA','OTA_13506_ADDRESS_TYPE_NOT_I');
4175: fnd_message.raise_error;
4176: --
4177: -- Address must be a valid one for the correspondent
4178: --

Line 4175: fnd_message.raise_error;

4171: -- Person address type should be internal
4172: -- show error
4173: --
4174: fnd_message.set_name ('OTA','OTA_13506_ADDRESS_TYPE_NOT_I');
4175: fnd_message.raise_error;
4176: --
4177: -- Address must be a valid one for the correspondent
4178: --
4179: if p_rec.corespondent = 'S' then

Line 4415: fnd_message.set_name ('OTA','OTA_443887_TDB_OM_CHK_UPD');

4411: END IF;
4412: /*Enhancement 1823602*/
4413: /* Bug 4401588 */
4414: IF p_rec.line_id IS NOT NULL AND l_number_of_places_changed THEN
4415: fnd_message.set_name ('OTA','OTA_443887_TDB_OM_CHK_UPD');
4416: fnd_message.raise_error;
4417: END IF;
4418:
4419: /* Bug 4401588*/

Line 4416: fnd_message.raise_error;

4412: /*Enhancement 1823602*/
4413: /* Bug 4401588 */
4414: IF p_rec.line_id IS NOT NULL AND l_number_of_places_changed THEN
4415: fnd_message.set_name ('OTA','OTA_443887_TDB_OM_CHK_UPD');
4416: fnd_message.raise_error;
4417: END IF;
4418:
4419: /* Bug 4401588*/
4420: /* bug no 4509873 */

Line 4430: fnd_message.set_name ('OTA','OTA_443905_TDB_TRN_ENR_DIF_INV');

4426: OPEN get_inv_id (p_rec.event_id);
4427: FETCH get_inv_id INTO l_new_inv_id;
4428: CLOSE get_inv_id ;
4429: IF l_new_inv_id <> l_old_inv_id then
4430: fnd_message.set_name ('OTA','OTA_443905_TDB_TRN_ENR_DIF_INV');
4431: fnd_message.raise_error;
4432: END IF;
4433: --END IF;
4434:

Line 4431: fnd_message.raise_error;

4427: FETCH get_inv_id INTO l_new_inv_id;
4428: CLOSE get_inv_id ;
4429: IF l_new_inv_id <> l_old_inv_id then
4430: fnd_message.set_name ('OTA','OTA_443905_TDB_TRN_ENR_DIF_INV');
4431: fnd_message.raise_error;
4432: END IF;
4433: --END IF;
4434:
4435: --Added for bug#4650304