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 297: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

Line 327: hr_utility.raise_error;

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

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

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

Line 332: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 445: hr_utility.raise_error;

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

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

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

Line 450: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 465: hr_utility.raise_error;

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

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

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

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

617: l_rec.data_source := p_data_source;
618: --
619: -- Return the plsql record structure.
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 10);
622: Return(l_rec);
623: --
624: End convert_args;
625: --

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

711: where EVENT_ID = P_EVENT_ID;
712: --
713: begin
714: --
715: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
716: HR_UTILITY.TRACE ('Event id: ' || to_char (P_EVENT_ID));
717: --
718: if (P_EVENT_ID is not null) then
719: open CSR_EVENT;

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

712: --
713: begin
714: --
715: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
716: HR_UTILITY.TRACE ('Event id: ' || to_char (P_EVENT_ID));
717: --
718: if (P_EVENT_ID is not null) then
719: open CSR_EVENT;
720: fetch CSR_EVENT

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

726: G_FETCHED_REC := G_NULL_REC;
727: P_EVENT_EXISTS := false;
728: end if;
729: --
730: HR_UTILITY.TRACE ('Fetch, start date: ' || to_char (G_FETCHED_REC.COURSE_START_DATE));
731: HR_UTILITY.TRACE ('Fetch, end date: ' || to_char (G_FETCHED_REC.COURSE_END_DATE));
732: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);
733: --
734: end FETCH_EVENT_DETAILS;

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

727: P_EVENT_EXISTS := false;
728: end if;
729: --
730: HR_UTILITY.TRACE ('Fetch, start date: ' || to_char (G_FETCHED_REC.COURSE_START_DATE));
731: HR_UTILITY.TRACE ('Fetch, end date: ' || to_char (G_FETCHED_REC.COURSE_END_DATE));
732: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);
733: --
734: end FETCH_EVENT_DETAILS;
735: --

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

728: end if;
729: --
730: HR_UTILITY.TRACE ('Fetch, start date: ' || to_char (G_FETCHED_REC.COURSE_START_DATE));
731: HR_UTILITY.TRACE ('Fetch, end date: ' || to_char (G_FETCHED_REC.COURSE_END_DATE));
732: HR_UTILITY.SET_LOCATION ('Leaving:' || W_PROC, 10);
733: --
734: end FETCH_EVENT_DETAILS;
735: --
736: -- ----------------------------------------------------------------------------

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

753: and mem.event_id = evt.event_id
754: and evt.event_status = 'P';
755: --
756: begin
757: hr_utility.set_location('Entering '||l_proc,10);
758: --
759: open c1;
760: fetch c1 into l_dummy;
761: if c1%found then

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

764: --
765: end if;
766: close c1;
767: --
768: hr_utility.set_location('Leaving '||l_proc,10);
769: return l_found;
770: --
771: end check_programme_members;
772: -- ----------------------------------------------------------------------------

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

786: := G_PACKAGE || 'GET_EVENT_DETAILS';
787: --
788: begin
789: --
790: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
791: --
792: FETCH_EVENT_DETAILS (P_EVENT_ID, P_EVENT_EXISTS);
793: P_EVENT_REC := G_FETCHED_REC;
794: --

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

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

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

813: W_EVENT_EXISTS boolean;
814: --
815: begin
816: --
817: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
818: --
819: HR_API.MANDATORY_ARG_ERROR (
820: P_API_NAME => G_PACKAGE,
821: P_ARGUMENT => 'P_EVENT_ID',

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

838: FND_MESSAGE.RAISE_ERROR;
839: --
840: end if;
841: --
842: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
843: --
844: end GET_COURSE_DATES;
845: --
846: -- ----------------------------------------------------------------------------

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

859: W_EVENT_IS_VALID boolean;
860: --
861: begin
862: --
863: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC,5);
864: --
865: if (P_EVENT_ID is not null) then
866: FETCH_EVENT_DETAILS (
867: P_EVENT_ID => P_EVENT_ID,

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

870: CONSTRAINT_ERROR ('OTA_EVT_INVALID_EVENT');
871: end if;
872: end if;
873: --
874: HR_UTILITY.SET_LOCATION ('Leaving:'||W_PROC,10);
875: --
876: end CHECK_EVENT_IS_VALID;
877: --
878: -- ----------------------------------------------------------------------------