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

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

68: close csr_sec_grp;
69: --
70: -- The primary key is invalid therefore we must error
71: --
72: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
73: hr_multi_message.add
74: (p_associated_column1
75: => nvl(p_associated_column1,'ACTIVITY_VERSION_ID')
76: ,p_associated_column2

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

160: --
161: -- The primary key is invalid therefore we must error
162: --
163: close csr_leg_code;
164: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
165: fnd_message.raise_error;
166: end if;
167: hr_utility.set_location(l_proc,30);
168: --

Line 165: fnd_message.raise_error;

161: -- The primary key is invalid therefore we must error
162: --
163: close csr_leg_code;
164: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
165: fnd_message.raise_error;
166: end if;
167: hr_utility.set_location(l_proc,30);
168: --
169: -- Set the global variables so the values are

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

221: (p_activity_version_id => p_rec.activity_version_id
222: ,p_prerequisite_course_id => p_rec.prerequisite_course_id
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;

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

222: ,p_prerequisite_course_id => p_rec.prerequisite_course_id
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --

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

223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
231: End chk_non_updateable_args;

Line 228: fnd_message.raise_error;

224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
231: End chk_non_updateable_args;
232: --

Line 270: fnd_message.set_name('OTA', 'OTA_443707_DUP_CRS_PREREQ');

266: --
267: if sel_unique_key%found then
268: close sel_unique_key;
269:
270: fnd_message.set_name('OTA', 'OTA_443707_DUP_CRS_PREREQ');
271: fnd_message.raise_error;
272: end if;
273: close sel_unique_key;
274: --

Line 271: fnd_message.raise_error;

267: if sel_unique_key%found then
268: close sel_unique_key;
269:
270: fnd_message.set_name('OTA', 'OTA_443707_DUP_CRS_PREREQ');
271: fnd_message.raise_error;
272: end if;
273: close sel_unique_key;
274: --
275: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 319: fnd_message.set_name('OTA', 'OTA_443751_PREREQ_CRS_EXPIRED');

315: fetch get_prereq_crs_end_date into l_prereq_crs_end_date;
316: close get_prereq_crs_end_date;
317:
318: If ( l_prereq_crs_end_date < trunc(sysdate) ) Then
319: fnd_message.set_name('OTA', 'OTA_443751_PREREQ_CRS_EXPIRED');
320: fnd_message.raise_error;
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 320: fnd_message.raise_error;

316: close get_prereq_crs_end_date;
317:
318: If ( l_prereq_crs_end_date < trunc(sysdate) ) Then
319: fnd_message.set_name('OTA', 'OTA_443751_PREREQ_CRS_EXPIRED');
320: fnd_message.raise_error;
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'|| l_proc, 10);
324:

Line 376: fnd_message.set_name('OTA', 'OTA_443708_CRS_PREREQ_ST_DT_GR');

372: fetch get_course_start_date into l_prereq_course_start_date;
373: close get_course_start_date;
374:
375: If ( l_prereq_course_start_date > l_dest_course_start_date ) Then
376: fnd_message.set_name('OTA', 'OTA_443708_CRS_PREREQ_ST_DT_GR');
377: fnd_message.raise_error;
378: End If;
379: --
380: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 377: fnd_message.raise_error;

373: close get_course_start_date;
374:
375: If ( l_prereq_course_start_date > l_dest_course_start_date ) Then
376: fnd_message.set_name('OTA', 'OTA_443708_CRS_PREREQ_ST_DT_GR');
377: fnd_message.raise_error;
378: End If;
379: --
380: hr_utility.set_location(' Leaving:'|| l_proc, 10);
381:

Line 432: fnd_message.set_name('OTA', 'OTA_443709_CRS_PREREQ_NOVLDCLS');

428:
429: If ( get_valid_classes%notfound ) Then
430: close get_valid_classes;
431:
432: fnd_message.set_name('OTA', 'OTA_443709_CRS_PREREQ_NOVLDCLS');
433: fnd_message.raise_error;
434: End If;
435: close get_valid_classes;
436:

Line 433: fnd_message.raise_error;

429: If ( get_valid_classes%notfound ) Then
430: close get_valid_classes;
431:
432: fnd_message.set_name('OTA', 'OTA_443709_CRS_PREREQ_NOVLDCLS');
433: fnd_message.raise_error;
434: End If;
435: close get_valid_classes;
436:
437: --

Line 487: fnd_message.set_name('OTA', 'OTA_443727_CRS_PREREQ_CHAINING');

483: --
484: hr_utility.set_location('Entering:'|| l_proc, 5);
485: --
486: if ( p_activity_version_id = p_prerequisite_course_id ) then
487: fnd_message.set_name('OTA', 'OTA_443727_CRS_PREREQ_CHAINING');
488: fnd_message.raise_error;
489: else
490: Open is_course_chained;
491: fetch is_course_chained into l_flag;

Line 488: fnd_message.raise_error;

484: hr_utility.set_location('Entering:'|| l_proc, 5);
485: --
486: if ( p_activity_version_id = p_prerequisite_course_id ) then
487: fnd_message.set_name('OTA', 'OTA_443727_CRS_PREREQ_CHAINING');
488: fnd_message.raise_error;
489: else
490: Open is_course_chained;
491: fetch is_course_chained into l_flag;
492:

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

492:
493: If ( is_course_chained%found ) Then
494: close is_course_chained;
495:
496: fnd_message.set_name('OTA', 'OTA_443727_CRS_PREREQ_CHAINING');
497: fnd_message.raise_error;
498: End If;
499: close is_course_chained;
500: end if;

Line 497: fnd_message.raise_error;

493: If ( is_course_chained%found ) Then
494: close is_course_chained;
495:
496: fnd_message.set_name('OTA', 'OTA_443727_CRS_PREREQ_CHAINING');
497: fnd_message.raise_error;
498: End If;
499: close is_course_chained;
500: end if;
501: