40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_bgm_shd.api_updating
47: (p_budget_gl_flex_map_id => p_budget_gl_flex_map_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_budget_gl_flex_map_id;
75: --
76: -- ----------------------------------------------------------------------------
99: AND budget_gl_flex_map_id <> p_budget_gl_flex_map_id;
100: --
101: Begin
102: --
103: hr_utility.set_location('Entering:'||l_proc, 5);
104: --
105:
106: OPEN csr_map_count;
107: FETCH csr_map_count INTO l_count;
108: CLOSE csr_map_count;
109:
110: IF NVL(l_count,0) <> 0 THEN
111: -- raise error as combination already exists
112: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_GL_MAP');
113: hr_utility.raise_error;
114: END IF;
115:
116:
109:
110: IF NVL(l_count,0) <> 0 THEN
111: -- raise error as combination already exists
112: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_GL_MAP');
113: hr_utility.raise_error;
114: END IF;
115:
116:
117: hr_utility.set_location('Leaving:'||l_proc, 10);
113: hr_utility.raise_error;
114: END IF;
115:
116:
117: hr_utility.set_location('Leaving:'||l_proc, 10);
118: --
119: End chk_mapped_segments;
120: --
121: --
135:
136: --
137: Begin
138: --
139: hr_utility.set_location('Entering:'||l_proc, 5);
140: --
141: IF p_gl_account_segment IS NULL OR
142: p_payroll_cost_segment IS NULL THEN
143:
141: IF p_gl_account_segment IS NULL OR
142: p_payroll_cost_segment IS NULL THEN
143:
144: -- raise error as combination already exists
145: hr_utility.set_message(8302,'PQH_COST_GL_MAP_NULL');
146: hr_utility.raise_error;
147: END IF;
148:
149: hr_utility.set_location('Leaving:'||l_proc, 10);
142: p_payroll_cost_segment IS NULL THEN
143:
144: -- raise error as combination already exists
145: hr_utility.set_message(8302,'PQH_COST_GL_MAP_NULL');
146: hr_utility.raise_error;
147: END IF;
148:
149: hr_utility.set_location('Leaving:'||l_proc, 10);
150: --
145: hr_utility.set_message(8302,'PQH_COST_GL_MAP_NULL');
146: hr_utility.raise_error;
147: END IF;
148:
149: hr_utility.set_location('Leaving:'||l_proc, 10);
150: --
151: End chk_cost_segments;
152: --
153: -- ----------------------------------------------------------------------------
157: --
158: l_proc varchar2(72) := g_package||'insert_validate';
159: --
160: Begin
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: --
163: -- Call all supporting business operations
164: --
165: chk_budget_gl_flex_map_id
173: );
174: --
175: --
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: End insert_validate;
179: --
180: -- ----------------------------------------------------------------------------
181: -- |---------------------------< update_validate >----------------------------|
184: --
185: l_proc varchar2(72) := g_package||'update_validate';
186: --
187: Begin
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: -- Call all supporting business operations
191: --
192: chk_budget_gl_flex_map_id
205: p_payroll_cost_segment => p_rec.payroll_cost_segment
206: );
207: --
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: End update_validate;
211: --
212: -- ----------------------------------------------------------------------------
213: -- |---------------------------< delete_validate >----------------------------|
216: --
217: l_proc varchar2(72) := g_package||'delete_validate';
218: --
219: Begin
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: -- Call all supporting business operations
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: -- Call all supporting business operations
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: End delete_validate;
226: --
227: end pqh_bgm_bus;