64: and evt2.event_status = 'P');
65: --
66: begin
67: --
68: hr_utility.set_location('Entering :'||l_proc,10);
69: --
70: open c1;
71: --
72: fetch c1 into l_dummy;
86: fnd_message.raise_error;
87: --
88: end if;
89: --
90: hr_utility.set_location('Leaving :'||l_proc,10);
91: --
92: end event_status_ok;
93: --
94: -- ----------------------------------------------------------------------------
99: --
100: l_proc varchar2(72) := g_package||'insert_validate';
101: --
102: Begin
103: hr_utility.set_location('Entering:'||l_proc, 5);
104: --
105: -- Call all supporting business operations
106: --
107: CHECK_DUPLICATE_MEMBER(p_program_membership_id => p_rec.program_membership_id
110: --
111: event_status_ok(p_rec.event_id,
112: p_rec.program_event_id);
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: End insert_validate;
116: --
117: -- ----------------------------------------------------------------------------
118: -- |---------------------------< update_validate >----------------------------|
121: --
122: l_proc varchar2(72) := g_package||'update_validate';
123: --
124: Begin
125: hr_utility.set_location('Entering:'||l_proc, 5);
126: --
127: -- Call all supporting business operations
128: --
129: CHECK_DUPLICATE_MEMBER(p_program_membership_id => p_rec.program_membership_id
132: --
133: event_status_ok(p_rec.event_id,
134: p_rec.program_event_id);
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: End update_validate;
138: --
139: -- ----------------------------------------------------------------------------
140: -- |---------------------------< delete_validate >----------------------------|
143: --
144: l_proc varchar2(72) := g_package||'delete_validate';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- Call all supporting business operations
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- Call all supporting business operations
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: End delete_validate;
153: --
154: end ota_pmm_bus;