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_EVT_SHD dependencies on HR_UTILITY

Line 23: hr_utility.set_location('Entering:'||l_proc, 5);

19: --
20: l_proc varchar2(72) := g_package||'return_api_dml_status';
21: --
22: Begin
23: hr_utility.set_location('Entering:'||l_proc, 5);
24: --
25: Return (nvl(g_api_dml, false));
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 27: hr_utility.set_location(' Leaving:'||l_proc, 10);

23: hr_utility.set_location('Entering:'||l_proc, 5);
24: --
25: Return (nvl(g_api_dml, false));
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End return_api_dml_status;
29: --
30: -- ----------------------------------------------------------------------------
31: -- |---------------------------< constraint_error >---------------------------|

Line 42: hr_utility.set_location ('Entering:' || W_PROC, 5);

38: := g_package || 'CONSTRAINT_ERROR';
39: --
40: Begin
41: --
42: hr_utility.set_location ('Entering:' || W_PROC, 5);
43: hr_utility.set_location ('Constrint Name = '||p_constraint_name,5);
44: --
45: -- Key constraints
46: --

Line 43: hr_utility.set_location ('Constrint Name = '||p_constraint_name,5);

39: --
40: Begin
41: --
42: hr_utility.set_location ('Entering:' || W_PROC, 5);
43: hr_utility.set_location ('Constrint Name = '||p_constraint_name,5);
44: --
45: -- Key constraints
46: --
47: If (p_constraint_name = 'OTA_EVENTS_FK1') Then

Line 68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');
65: fnd_message.raise_error;
66: /* 3803613 */
67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', W_PROC);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then

Line 69: hr_utility.set_message_token('PROCEDURE', W_PROC);

65: fnd_message.raise_error;
66: /* 3803613 */
67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', W_PROC);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then
73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');

Line 70: hr_utility.set_message_token('STEP','30');

66: /* 3803613 */
67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', W_PROC);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then
73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');
74: fnd_message.raise_error;

Line 71: hr_utility.raise_error;

67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', W_PROC);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then
73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');
74: fnd_message.raise_error;
75: ElsIf (p_constraint_name = 'OTA_EVENT_UK3') Then

Line 201: hr_utility.raise_error;

197: Else
198: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
199: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
200: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
201: hr_utility.raise_error;
202: End If;
203: --
204: hr_utility.set_location (' Leaving:' || W_PROC, 10);
205: --

Line 204: hr_utility.set_location (' Leaving:' || W_PROC, 10);

200: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
201: hr_utility.raise_error;
202: End If;
203: --
204: hr_utility.set_location (' Leaving:' || W_PROC, 10);
205: --
206: End CONSTRAINT_ERROR;
207: --
208: -- ----------------------------------------------------------------------------

Line 298: hr_utility.set_location('Entering:'||l_proc, 5);

294: l_fct_ret boolean;
295: --
296: Begin
297: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: if ( (P_EVENT_ID is null)
301: and (P_OBJECT_VERSION_NUMBER is null)) then
302: --

Line 309: hr_utility.set_location(l_proc, 10);

305: --
306: l_fct_ret := false;
307: elsif ( (p_event_id = g_old_rec.event_id )
308: and (p_object_version_number = g_old_rec.object_version_number)) then
309: hr_utility.set_location(l_proc, 10);
310: --
311: -- The g_old_rec is current therefore we must
312: -- set the returning function to true
313: --

Line 327: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

323: Close C_Sel1;
324: --
325: -- The primary key is invalid therefore we must error
326: --
327: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
328: hr_utility.raise_error;
329: End If;
330: Close C_Sel1;
331: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 328: hr_utility.raise_error;

324: --
325: -- The primary key is invalid therefore we must error
326: --
327: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
328: hr_utility.raise_error;
329: End If;
330: Close C_Sel1;
331: If (p_object_version_number <> g_old_rec.object_version_number) Then
332: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 332: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

328: hr_utility.raise_error;
329: End If;
330: Close C_Sel1;
331: If (p_object_version_number <> g_old_rec.object_version_number) Then
332: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
333: hr_utility.raise_error;
334: End If;
335: hr_utility.set_location(l_proc, 15);
336: l_fct_ret := true;

Line 333: hr_utility.raise_error;

329: End If;
330: Close C_Sel1;
331: If (p_object_version_number <> g_old_rec.object_version_number) Then
332: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
333: hr_utility.raise_error;
334: End If;
335: hr_utility.set_location(l_proc, 15);
336: l_fct_ret := true;
337: End If;

Line 335: hr_utility.set_location(l_proc, 15);

331: If (p_object_version_number <> g_old_rec.object_version_number) Then
332: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
333: hr_utility.raise_error;
334: End If;
335: hr_utility.set_location(l_proc, 15);
336: l_fct_ret := true;
337: End If;
338: hr_utility.set_location(' Leaving:'||l_proc, 20);
339: Return (l_fct_ret);

Line 338: hr_utility.set_location(' Leaving:'||l_proc, 20);

334: End If;
335: hr_utility.set_location(l_proc, 15);
336: l_fct_ret := true;
337: End If;
338: hr_utility.set_location(' Leaving:'||l_proc, 20);
339: Return (l_fct_ret);
340: --
341: End api_updating;
342: --

Line 430: hr_utility.set_location('Entering:'||l_proc, 5);

426: --
427: l_proc varchar2(72) := g_package||'lck';
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: -- Add any mandatory argument checking here:
433: -- Example:
434: -- hr_api.mandatory_arg_error

Line 446: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

442: Close C_Sel1;
443: --
444: -- The primary key is invalid therefore we must error
445: --
446: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
447: hr_utility.raise_error;
448: End If;
449: Close C_Sel1;
450: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 447: hr_utility.raise_error;

443: --
444: -- The primary key is invalid therefore we must error
445: --
446: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
447: hr_utility.raise_error;
448: End If;
449: Close C_Sel1;
450: If (p_object_version_number <> g_old_rec.object_version_number) Then
451: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 451: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

447: hr_utility.raise_error;
448: End If;
449: Close C_Sel1;
450: If (p_object_version_number <> g_old_rec.object_version_number) Then
451: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
452: hr_utility.raise_error;
453: End If;
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 452: hr_utility.raise_error;

448: End If;
449: Close C_Sel1;
450: If (p_object_version_number <> g_old_rec.object_version_number) Then
451: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
452: hr_utility.raise_error;
453: End If;
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 10);
456: --

Line 455: hr_utility.set_location(' Leaving:'||l_proc, 10);

451: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
452: hr_utility.raise_error;
453: End If;
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 10);
456: --
457: -- We need to trap the ORA LOCK exception
458: --
459: Exception

Line 465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

461: --
462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
466: hr_utility.set_message_token('TABLE_NAME', 'ota_events');
467: hr_utility.raise_error;
468: End lck;
469: -- ----------------------------------------------------------------------------

Line 466: hr_utility.set_message_token('TABLE_NAME', 'ota_events');

462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
466: hr_utility.set_message_token('TABLE_NAME', 'ota_events');
467: hr_utility.raise_error;
468: End lck;
469: -- ----------------------------------------------------------------------------
470: -- |-----------------------------< convert_args >-----------------------------|

Line 467: hr_utility.raise_error;

463: -- error message.
464: --
465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
466: hr_utility.set_message_token('TABLE_NAME', 'ota_events');
467: hr_utility.raise_error;
468: End lck;
469: -- ----------------------------------------------------------------------------
470: -- |-----------------------------< convert_args >-----------------------------|
471: -- ----------------------------------------------------------------------------

Line 550: hr_utility.set_location('Entering:'||l_proc, 5);

546: l_proc varchar2(72) := g_package||'convert_args';
547: --
548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: -- Convert arguments into local l_rec structure.
553: --
554: l_rec.event_id := p_event_id;

Line 625: hr_utility.set_location(' Leaving:'||l_proc, 10);

621: l_rec.event_availability := p_event_availability;
622: --
623: -- Return the plsql record structure.
624: --
625: hr_utility.set_location(' Leaving:'||l_proc, 10);
626: Return(l_rec);
627: --
628: End convert_args;
629: --

Line 720: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);

716: where EVENT_ID = P_EVENT_ID;
717: --
718: begin
719: --
720: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
721: HR_UTILITY.TRACE ('Event id: ' || to_char (P_EVENT_ID));
722: --
723: if (P_EVENT_ID is not null) then
724: open CSR_EVENT;

Line 721: HR_UTILITY.TRACE ('Event id: ' || to_char (P_EVENT_ID));

717: --
718: begin
719: --
720: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
721: HR_UTILITY.TRACE ('Event id: ' || to_char (P_EVENT_ID));
722: --
723: if (P_EVENT_ID is not null) then
724: open CSR_EVENT;
725: fetch CSR_EVENT

Line 735: HR_UTILITY.TRACE ('Fetch, start date: ' || to_char (G_FETCHED_REC.COURSE_START_DATE));

731: G_FETCHED_REC := G_NULL_REC;
732: P_EVENT_EXISTS := false;
733: end if;
734: --
735: HR_UTILITY.TRACE ('Fetch, start date: ' || to_char (G_FETCHED_REC.COURSE_START_DATE));
736: HR_UTILITY.TRACE ('Fetch, end date: ' || to_char (G_FETCHED_REC.COURSE_END_DATE));
737: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);
738: --
739: end FETCH_EVENT_DETAILS;

Line 736: HR_UTILITY.TRACE ('Fetch, end date: ' || to_char (G_FETCHED_REC.COURSE_END_DATE));

732: P_EVENT_EXISTS := false;
733: end if;
734: --
735: HR_UTILITY.TRACE ('Fetch, start date: ' || to_char (G_FETCHED_REC.COURSE_START_DATE));
736: HR_UTILITY.TRACE ('Fetch, end date: ' || to_char (G_FETCHED_REC.COURSE_END_DATE));
737: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);
738: --
739: end FETCH_EVENT_DETAILS;
740: --

Line 737: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);

733: end if;
734: --
735: HR_UTILITY.TRACE ('Fetch, start date: ' || to_char (G_FETCHED_REC.COURSE_START_DATE));
736: HR_UTILITY.TRACE ('Fetch, end date: ' || to_char (G_FETCHED_REC.COURSE_END_DATE));
737: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);
738: --
739: end FETCH_EVENT_DETAILS;
740: --
741: -- ----------------------------------------------------------------------------

Line 762: hr_utility.set_location('Entering '||l_proc,10);

758: and mem.event_id = evt.event_id
759: and evt.event_status = 'P';
760: --
761: begin
762: hr_utility.set_location('Entering '||l_proc,10);
763: --
764: open c1;
765: fetch c1 into l_dummy;
766: if c1%found then

Line 773: hr_utility.set_location('Leaving '||l_proc,10);

769: --
770: end if;
771: close c1;
772: --
773: hr_utility.set_location('Leaving '||l_proc,10);
774: return l_found;
775: --
776: end check_programme_members;
777: -- ----------------------------------------------------------------------------

Line 795: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);

791: := G_PACKAGE || 'GET_EVENT_DETAILS';
792: --
793: begin
794: --
795: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
796: --
797: FETCH_EVENT_DETAILS (P_EVENT_ID, P_EVENT_EXISTS);
798: P_EVENT_REC := G_FETCHED_REC;
799: --

Line 800: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);

796: --
797: FETCH_EVENT_DETAILS (P_EVENT_ID, P_EVENT_EXISTS);
798: P_EVENT_REC := G_FETCHED_REC;
799: --
800: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);
801: --
802: end GET_EVENT_DETAILS;
803: --
804: -- ----------------------------------------------------------------------------

Line 822: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);

818: W_EVENT_EXISTS boolean;
819: --
820: begin
821: --
822: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
823: --
824: HR_API.MANDATORY_ARG_ERROR (
825: P_API_NAME => G_PACKAGE,
826: P_ARGUMENT => 'P_EVENT_ID',

Line 847: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);

843: FND_MESSAGE.RAISE_ERROR;
844: --
845: end if;
846: --
847: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
848: --
849: end GET_COURSE_DATES;
850: --
851: -- ----------------------------------------------------------------------------

Line 868: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC,5);

864: W_EVENT_IS_VALID boolean;
865: --
866: begin
867: --
868: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC,5);
869: --
870: if (P_EVENT_ID is not null) then
871: FETCH_EVENT_DETAILS (
872: P_EVENT_ID => P_EVENT_ID,

Line 879: HR_UTILITY.SET_LOCATION ('Leaving:'||W_PROC,10);

875: CONSTRAINT_ERROR ('OTA_EVT_INVALID_EVENT');
876: end if;
877: end if;
878: --
879: HR_UTILITY.SET_LOCATION ('Leaving:'||W_PROC,10);
880: --
881: end CHECK_EVENT_IS_VALID;
882: --
883: -- ----------------------------------------------------------------------------