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.OZF_QUOTA_ALLOCATIONS_PVT dependencies on FND_API

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145: l_fact_id c_fact_id%rowtype;
146: BEGIN
147:
148: SAVEPOINT generate_product_spread_sp;
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: for l_fact_id in c_fact_id(p_alloc_id)
152: loop
153: ozf_allocation_engine_pvt.setup_product_spread

Line 156: p_init_msg_list => FND_API.G_FALSE,

152: loop
153: ozf_allocation_engine_pvt.setup_product_spread
154: (
155: p_api_version =>1.0,
156: p_init_msg_list => FND_API.G_FALSE,
157: p_commit => FND_API.G_FALSE,
158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
159: x_return_status => x_return_status,
160: x_error_number => x_msg_count,

Line 157: p_commit => FND_API.G_FALSE,

153: ozf_allocation_engine_pvt.setup_product_spread
154: (
155: p_api_version =>1.0,
156: p_init_msg_list => FND_API.G_FALSE,
157: p_commit => FND_API.G_FALSE,
158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
159: x_return_status => x_return_status,
160: x_error_number => x_msg_count,
161: x_error_message => x_msg_data,

Line 158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

154: (
155: p_api_version =>1.0,
156: p_init_msg_list => FND_API.G_FALSE,
157: p_commit => FND_API.G_FALSE,
158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
159: x_return_status => x_return_status,
160: x_error_number => x_msg_count,
161: x_error_message => x_msg_data,
162: p_mode => p_mode,

Line 168: IF x_return_status = fnd_api.g_ret_sts_error THEN

164: p_context => p_context
165: );
166: end loop;
167:
168: IF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;

Line 169: RAISE fnd_api.g_exc_error;

165: );
166: end loop;
167:
168: IF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:

Line 170: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

166: end loop;
167:
168: IF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: EXCEPTION

Line 171: RAISE fnd_api.g_exc_unexpected_error;

167:
168: IF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: EXCEPTION
175: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 175: WHEN Fnd_Api.G_EXC_ERROR THEN

171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: EXCEPTION
175: WHEN Fnd_Api.G_EXC_ERROR THEN
176: x_return_status := Fnd_Api.g_ret_sts_error ;
177: ROLLBACK TO generate_product_spread_sp;
178: Fnd_Msg_Pub.Count_AND_Get
179: ( p_count => x_msg_count,

Line 176: x_return_status := Fnd_Api.g_ret_sts_error ;

172: END IF;
173:
174: EXCEPTION
175: WHEN Fnd_Api.G_EXC_ERROR THEN
176: x_return_status := Fnd_Api.g_ret_sts_error ;
177: ROLLBACK TO generate_product_spread_sp;
178: Fnd_Msg_Pub.Count_AND_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data,

Line 181: p_encoded => Fnd_Api.G_FALSE

177: ROLLBACK TO generate_product_spread_sp;
178: Fnd_Msg_Pub.Count_AND_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data,
181: p_encoded => Fnd_Api.G_FALSE
182: );
183: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
184: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
185: ROLLBACK TO generate_product_spread_sp;

Line 183: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

179: ( p_count => x_msg_count,
180: p_data => x_msg_data,
181: p_encoded => Fnd_Api.G_FALSE
182: );
183: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
184: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
185: ROLLBACK TO generate_product_spread_sp;
186: Fnd_Msg_Pub.Count_AND_Get
187: ( p_count => x_msg_count,

Line 184: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

180: p_data => x_msg_data,
181: p_encoded => Fnd_Api.G_FALSE
182: );
183: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
184: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
185: ROLLBACK TO generate_product_spread_sp;
186: Fnd_Msg_Pub.Count_AND_Get
187: ( p_count => x_msg_count,
188: p_data => x_msg_data,

Line 189: p_encoded => Fnd_Api.G_FALSE

185: ROLLBACK TO generate_product_spread_sp;
186: Fnd_Msg_Pub.Count_AND_Get
187: ( p_count => x_msg_count,
188: p_data => x_msg_data,
189: p_encoded => Fnd_Api.G_FALSE
190: );
191: WHEN OTHERS THEN
192: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
193: ROLLBACK TO generate_product_spread_sp;

Line 192: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

188: p_data => x_msg_data,
189: p_encoded => Fnd_Api.G_FALSE
190: );
191: WHEN OTHERS THEN
192: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
193: ROLLBACK TO generate_product_spread_sp;
194: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
195: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
196: END IF;

Line 200: p_encoded => Fnd_Api.G_FALSE

196: END IF;
197: Fnd_Msg_Pub.Count_AND_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => Fnd_Api.G_FALSE
201: );
202:
203: END generate_product_spread;
204: ---------------------------------------------------------------------

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

225: l_api_version CONSTANT NUMBER := 1.0;
226: l_api_name CONSTANT VARCHAR2(30) := 'generate_product_spread';
227: BEGIN
228: SAVEPOINT create_quota_alloc_hier_sp;
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: OZF_Fund_allocations_Pvt.create_alloc_hierarchy(
232: p_api_version => p_api_version
233: , p_init_msg_list => p_init_msg_list

Line 241: IF x_return_status = fnd_api.g_ret_sts_error THEN

237: , x_msg_count => x_msg_count
238: , x_msg_data => x_msg_data
239: );
240:
241: IF x_return_status = fnd_api.g_ret_sts_error THEN
242: RAISE fnd_api.g_exc_error;
243: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;

Line 242: RAISE fnd_api.g_exc_error;

238: , x_msg_data => x_msg_data
239: );
240:
241: IF x_return_status = fnd_api.g_ret_sts_error THEN
242: RAISE fnd_api.g_exc_error;
243: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;
246:

Line 243: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

239: );
240:
241: IF x_return_status = fnd_api.g_ret_sts_error THEN
242: RAISE fnd_api.g_exc_error;
243: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;
246:
247: generate_product_spread(

Line 244: RAISE fnd_api.g_exc_unexpected_error;

240:
241: IF x_return_status = fnd_api.g_ret_sts_error THEN
242: RAISE fnd_api.g_exc_error;
243: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;
246:
247: generate_product_spread(
248: p_api_version => p_api_version

Line 259: IF x_return_status = fnd_api.g_ret_sts_error THEN

255: , x_msg_count => x_msg_count
256: , x_msg_data => x_msg_count
257: );
258:
259: IF x_return_status = fnd_api.g_ret_sts_error THEN
260: RAISE fnd_api.g_exc_error;
261: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;

Line 260: RAISE fnd_api.g_exc_error;

256: , x_msg_data => x_msg_count
257: );
258:
259: IF x_return_status = fnd_api.g_ret_sts_error THEN
260: RAISE fnd_api.g_exc_error;
261: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:

Line 261: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

257: );
258:
259: IF x_return_status = fnd_api.g_ret_sts_error THEN
260: RAISE fnd_api.g_exc_error;
261: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:
265: EXCEPTION

Line 262: RAISE fnd_api.g_exc_unexpected_error;

258:
259: IF x_return_status = fnd_api.g_ret_sts_error THEN
260: RAISE fnd_api.g_exc_error;
261: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:
265: EXCEPTION
266: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 266: WHEN Fnd_Api.G_EXC_ERROR THEN

262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:
265: EXCEPTION
266: WHEN Fnd_Api.G_EXC_ERROR THEN
267: x_return_status := Fnd_Api.g_ret_sts_error ;
268: ROLLBACK TO create_quota_alloc_hier_sp;
269: Fnd_Msg_Pub.Count_AND_Get
270: ( p_count => x_msg_count,

Line 267: x_return_status := Fnd_Api.g_ret_sts_error ;

263: END IF;
264:
265: EXCEPTION
266: WHEN Fnd_Api.G_EXC_ERROR THEN
267: x_return_status := Fnd_Api.g_ret_sts_error ;
268: ROLLBACK TO create_quota_alloc_hier_sp;
269: Fnd_Msg_Pub.Count_AND_Get
270: ( p_count => x_msg_count,
271: p_data => x_msg_data,

Line 272: p_encoded => Fnd_Api.G_FALSE

268: ROLLBACK TO create_quota_alloc_hier_sp;
269: Fnd_Msg_Pub.Count_AND_Get
270: ( p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => Fnd_Api.G_FALSE
273: );
274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
276: ROLLBACK TO create_quota_alloc_hier_sp;

Line 274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

270: ( p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => Fnd_Api.G_FALSE
273: );
274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
276: ROLLBACK TO create_quota_alloc_hier_sp;
277: Fnd_Msg_Pub.Count_AND_Get
278: ( p_count => x_msg_count,

Line 275: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

271: p_data => x_msg_data,
272: p_encoded => Fnd_Api.G_FALSE
273: );
274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
276: ROLLBACK TO create_quota_alloc_hier_sp;
277: Fnd_Msg_Pub.Count_AND_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data,

Line 280: p_encoded => Fnd_Api.G_FALSE

276: ROLLBACK TO create_quota_alloc_hier_sp;
277: Fnd_Msg_Pub.Count_AND_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data,
280: p_encoded => Fnd_Api.G_FALSE
281: );
282: WHEN OTHERS THEN
283: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
284: ROLLBACK TO create_quota_alloc_hier_sp;

Line 283: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

279: p_data => x_msg_data,
280: p_encoded => Fnd_Api.G_FALSE
281: );
282: WHEN OTHERS THEN
283: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
284: ROLLBACK TO create_quota_alloc_hier_sp;
285: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
286: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;

Line 291: p_encoded => Fnd_Api.G_FALSE

287: END IF;
288: Fnd_Msg_Pub.Count_AND_Get
289: ( p_count => x_msg_count,
290: p_data => x_msg_data,
291: p_encoded => Fnd_Api.G_FALSE
292: );
293:
294: END create_quota_alloc_hierarchy;
295:

Line 299: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

295:
296:
297: PROCEDURE update_fund_with_extra_fields(
298: p_api_version IN NUMBER DEFAULT 1.0
299: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
300: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
301: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
302: , p_alloc_id IN NUMBER
303: , x_return_status OUT NOCOPY VARCHAR2

Line 300: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

296:
297: PROCEDURE update_fund_with_extra_fields(
298: p_api_version IN NUMBER DEFAULT 1.0
299: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
300: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
301: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
302: , p_alloc_id IN NUMBER
303: , x_return_status OUT NOCOPY VARCHAR2
304: , x_msg_count OUT NOCOPY NUMBER

Line 301: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

297: PROCEDURE update_fund_with_extra_fields(
298: p_api_version IN NUMBER DEFAULT 1.0
299: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
300: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
301: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
302: , p_alloc_id IN NUMBER
303: , x_return_status OUT NOCOPY VARCHAR2
304: , x_msg_count OUT NOCOPY NUMBER
305: , x_msg_data OUT NOCOPY VARCHAR2

Line 326: x_return_status := FND_API.G_RET_STS_SUCCESS;

322: l_spread_time_id NUMBER;
323: BEGIN
324:
325: SAVEPOINT update_fund_sp;
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: OPEN C_extra_fields(p_alloc_id);
329: FETCH C_extra_fields into l_start_period_name, l_end_period_name, l_spread_time_id;
330: CLOSE C_extra_fields;

Line 343: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

339: end loop;
340:
341: EXCEPTION
342: WHEN OTHERS THEN
343: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
344: ROLLBACK TO update_fund_sp;
345: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
346: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;

Line 351: p_encoded => Fnd_Api.G_FALSE

347: END IF;
348: Fnd_Msg_Pub.Count_AND_Get
349: ( p_count => x_msg_count,
350: p_data => x_msg_data,
351: p_encoded => Fnd_Api.G_FALSE
352: );
353: END update_fund_with_extra_fields;
354:
355: PROCEDURE allocate_target (

Line 357: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

353: END update_fund_with_extra_fields;
354:
355: PROCEDURE allocate_target (
356: p_api_version IN NUMBER DEFAULT 1.0
357: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
358: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
359: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
360: , p_mode IN VARCHAR2
361: , p_alloc_id IN NUMBER

Line 358: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

354:
355: PROCEDURE allocate_target (
356: p_api_version IN NUMBER DEFAULT 1.0
357: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
358: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
359: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
360: , p_mode IN VARCHAR2
361: , p_alloc_id IN NUMBER
362: , x_return_status OUT NOCOPY VARCHAR2

Line 359: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

355: PROCEDURE allocate_target (
356: p_api_version IN NUMBER DEFAULT 1.0
357: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
358: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
359: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
360: , p_mode IN VARCHAR2
361: , p_alloc_id IN NUMBER
362: , x_return_status OUT NOCOPY VARCHAR2
363: , x_msg_count OUT NOCOPY NUMBER

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: l_fact_id c_fact_id%rowtype;
390:
391: BEGIN
392: SAVEPOINT allocate_target_sp;
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: for l_fact_id in c_fact_id(p_alloc_id)
396: loop
397: --Added by kvattiku Mar 15, 04

Line 424: IF x_return_status = fnd_api.g_ret_sts_error THEN

420: END IF;
421:
422: end loop;
423:
424: IF x_return_status = fnd_api.g_ret_sts_error THEN
425: RAISE fnd_api.g_exc_error;
426: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: RAISE fnd_api.g_exc_unexpected_error;
428: END IF;

Line 425: RAISE fnd_api.g_exc_error;

421:
422: end loop;
423:
424: IF x_return_status = fnd_api.g_ret_sts_error THEN
425: RAISE fnd_api.g_exc_error;
426: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: RAISE fnd_api.g_exc_unexpected_error;
428: END IF;
429:

Line 426: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

422: end loop;
423:
424: IF x_return_status = fnd_api.g_ret_sts_error THEN
425: RAISE fnd_api.g_exc_error;
426: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: RAISE fnd_api.g_exc_unexpected_error;
428: END IF;
429:
430: EXCEPTION

Line 427: RAISE fnd_api.g_exc_unexpected_error;

423:
424: IF x_return_status = fnd_api.g_ret_sts_error THEN
425: RAISE fnd_api.g_exc_error;
426: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: RAISE fnd_api.g_exc_unexpected_error;
428: END IF;
429:
430: EXCEPTION
431: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 431: WHEN Fnd_Api.G_EXC_ERROR THEN

427: RAISE fnd_api.g_exc_unexpected_error;
428: END IF;
429:
430: EXCEPTION
431: WHEN Fnd_Api.G_EXC_ERROR THEN
432: x_return_status := Fnd_Api.g_ret_sts_error ;
433: ROLLBACK TO allocate_target_sp;
434: Fnd_Msg_Pub.Count_AND_Get
435: ( p_count => x_msg_count,

Line 432: x_return_status := Fnd_Api.g_ret_sts_error ;

428: END IF;
429:
430: EXCEPTION
431: WHEN Fnd_Api.G_EXC_ERROR THEN
432: x_return_status := Fnd_Api.g_ret_sts_error ;
433: ROLLBACK TO allocate_target_sp;
434: Fnd_Msg_Pub.Count_AND_Get
435: ( p_count => x_msg_count,
436: p_data => x_msg_data,

Line 437: p_encoded => Fnd_Api.G_FALSE

433: ROLLBACK TO allocate_target_sp;
434: Fnd_Msg_Pub.Count_AND_Get
435: ( p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => Fnd_Api.G_FALSE
438: );
439: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
440: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
441: ROLLBACK TO allocate_target_sp;

Line 439: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

435: ( p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => Fnd_Api.G_FALSE
438: );
439: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
440: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
441: ROLLBACK TO allocate_target_sp;
442: Fnd_Msg_Pub.Count_AND_Get
443: ( p_count => x_msg_count,

Line 440: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

436: p_data => x_msg_data,
437: p_encoded => Fnd_Api.G_FALSE
438: );
439: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
440: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
441: ROLLBACK TO allocate_target_sp;
442: Fnd_Msg_Pub.Count_AND_Get
443: ( p_count => x_msg_count,
444: p_data => x_msg_data,

Line 445: p_encoded => Fnd_Api.G_FALSE

441: ROLLBACK TO allocate_target_sp;
442: Fnd_Msg_Pub.Count_AND_Get
443: ( p_count => x_msg_count,
444: p_data => x_msg_data,
445: p_encoded => Fnd_Api.G_FALSE
446: );
447: WHEN OTHERS THEN
448: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
449: ROLLBACK TO allocate_target_sp;

Line 448: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

444: p_data => x_msg_data,
445: p_encoded => Fnd_Api.G_FALSE
446: );
447: WHEN OTHERS THEN
448: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
449: ROLLBACK TO allocate_target_sp;
450: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
451: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
452: END IF;

Line 456: p_encoded => Fnd_Api.G_FALSE

452: END IF;
453: Fnd_Msg_Pub.Count_AND_Get
454: ( p_count => x_msg_count,
455: p_data => x_msg_data,
456: p_encoded => Fnd_Api.G_FALSE
457: );
458: END allocate_target;
459:
460: PROCEDURE publish_allocation( p_api_version IN NUMBER DEFAULT 1.0

Line 461: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

457: );
458: END allocate_target;
459:
460: PROCEDURE publish_allocation( p_api_version IN NUMBER DEFAULT 1.0
461: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
462: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
463: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
464: , p_alloc_id IN NUMBER
465: , x_return_status OUT NOCOPY VARCHAR2

Line 462: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

458: END allocate_target;
459:
460: PROCEDURE publish_allocation( p_api_version IN NUMBER DEFAULT 1.0
461: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
462: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
463: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
464: , p_alloc_id IN NUMBER
465: , x_return_status OUT NOCOPY VARCHAR2
466: , x_msg_count OUT NOCOPY NUMBER

Line 463: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

459:
460: PROCEDURE publish_allocation( p_api_version IN NUMBER DEFAULT 1.0
461: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
462: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
463: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
464: , p_alloc_id IN NUMBER
465: , x_return_status OUT NOCOPY VARCHAR2
466: , x_msg_count OUT NOCOPY NUMBER
467: , x_msg_data OUT NOCOPY VARCHAR2

Line 489: IF Fnd_Api.to_boolean(p_init_msg_list) THEN

485: BEGIN
486:
487: SAVEPOINT publish_allocation_sp;
488:
489: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
490: Fnd_Msg_Pub.initialize;
491: END IF;
492:
493: /* IF NOT Fnd_Api.compatible_api_call

Line 493: /* IF NOT Fnd_Api.compatible_api_call

489: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
490: Fnd_Msg_Pub.initialize;
491: END IF;
492:
493: /* IF NOT Fnd_Api.compatible_api_call
494: (
495: l_api_version,
496: p_api_version,
497: l_api_name,

Line 501: RAISE Fnd_Api.g_exc_unexpected_error;

497: l_api_name,
498: g_pkg_name
499: )
500: THEN
501: RAISE Fnd_Api.g_exc_unexpected_error;
502: END IF;
503: */
504: x_return_status := Fnd_Api.g_ret_sts_success;
505:

Line 504: x_return_status := Fnd_Api.g_ret_sts_success;

500: THEN
501: RAISE Fnd_Api.g_exc_unexpected_error;
502: END IF;
503: */
504: x_return_status := Fnd_Api.g_ret_sts_success;
505:
506:
507: open c_alloc_dtls(p_alloc_id);
508: fetch c_alloc_dtls into l_alloc_dtls;

Line 525: IF x_return_status = fnd_api.g_ret_sts_error THEN

521: , x_return_status => x_return_status
522: , x_msg_count => x_msg_count
523: , x_msg_data => x_msg_data
524: );
525: IF x_return_status = fnd_api.g_ret_sts_error THEN
526: RAISE fnd_api.g_exc_error;
527: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
528: RAISE fnd_api.g_exc_unexpected_error;
529: END IF;

Line 526: RAISE fnd_api.g_exc_error;

522: , x_msg_count => x_msg_count
523: , x_msg_data => x_msg_data
524: );
525: IF x_return_status = fnd_api.g_ret_sts_error THEN
526: RAISE fnd_api.g_exc_error;
527: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
528: RAISE fnd_api.g_exc_unexpected_error;
529: END IF;
530: ozf_utility_pvt.debug_message('@Done Calling Publish Allocation: Return :'||x_return_status);

Line 527: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

523: , x_msg_data => x_msg_data
524: );
525: IF x_return_status = fnd_api.g_ret_sts_error THEN
526: RAISE fnd_api.g_exc_error;
527: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
528: RAISE fnd_api.g_exc_unexpected_error;
529: END IF;
530: ozf_utility_pvt.debug_message('@Done Calling Publish Allocation: Return :'||x_return_status);
531: -- update generated funds with the time spread of the allocation

Line 528: RAISE fnd_api.g_exc_unexpected_error;

524: );
525: IF x_return_status = fnd_api.g_ret_sts_error THEN
526: RAISE fnd_api.g_exc_error;
527: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
528: RAISE fnd_api.g_exc_unexpected_error;
529: END IF;
530: ozf_utility_pvt.debug_message('@Done Calling Publish Allocation: Return :'||x_return_status);
531: -- update generated funds with the time spread of the allocation
532: */

Line 546: IF x_return_status = fnd_api.g_ret_sts_error THEN

542: , x_msg_count => x_msg_count
543: , x_msg_data => x_msg_data
544: ); -- dont update directly instead call budget api
545: -- generate product spread for the newly created funds
546: IF x_return_status = fnd_api.g_ret_sts_error THEN
547: RAISE fnd_api.g_exc_error;
548: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;

Line 547: RAISE fnd_api.g_exc_error;

543: , x_msg_data => x_msg_data
544: ); -- dont update directly instead call budget api
545: -- generate product spread for the newly created funds
546: IF x_return_status = fnd_api.g_ret_sts_error THEN
547: RAISE fnd_api.g_exc_error;
548: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: ozf_utility_pvt.debug_message('@Done Calling Update Fund With Time Spread: Return :'||x_return_status);

Line 548: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

544: ); -- dont update directly instead call budget api
545: -- generate product spread for the newly created funds
546: IF x_return_status = fnd_api.g_ret_sts_error THEN
547: RAISE fnd_api.g_exc_error;
548: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: ozf_utility_pvt.debug_message('@Done Calling Update Fund With Time Spread: Return :'||x_return_status);
552: ozf_utility_pvt.debug_message('@Calling generate product spread');

Line 549: RAISE fnd_api.g_exc_unexpected_error;

545: -- generate product spread for the newly created funds
546: IF x_return_status = fnd_api.g_ret_sts_error THEN
547: RAISE fnd_api.g_exc_error;
548: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: ozf_utility_pvt.debug_message('@Done Calling Update Fund With Time Spread: Return :'||x_return_status);
552: ozf_utility_pvt.debug_message('@Calling generate product spread');
553:

Line 567: IF x_return_status = fnd_api.g_ret_sts_error THEN

563: , x_msg_data => x_msg_count
564: );
565:
566: -- generate time allocations for the newly generated funds
567: IF x_return_status = fnd_api.g_ret_sts_error THEN
568: RAISE fnd_api.g_exc_error;
569: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
570: RAISE fnd_api.g_exc_unexpected_error;
571: END IF;

Line 568: RAISE fnd_api.g_exc_error;

564: );
565:
566: -- generate time allocations for the newly generated funds
567: IF x_return_status = fnd_api.g_ret_sts_error THEN
568: RAISE fnd_api.g_exc_error;
569: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
570: RAISE fnd_api.g_exc_unexpected_error;
571: END IF;
572:

Line 569: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

565:
566: -- generate time allocations for the newly generated funds
567: IF x_return_status = fnd_api.g_ret_sts_error THEN
568: RAISE fnd_api.g_exc_error;
569: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
570: RAISE fnd_api.g_exc_unexpected_error;
571: END IF;
572:
573: ozf_utility_pvt.debug_message('@Done Calling generate product spread: Return:'||x_return_status);

Line 570: RAISE fnd_api.g_exc_unexpected_error;

566: -- generate time allocations for the newly generated funds
567: IF x_return_status = fnd_api.g_ret_sts_error THEN
568: RAISE fnd_api.g_exc_error;
569: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
570: RAISE fnd_api.g_exc_unexpected_error;
571: END IF;
572:
573: ozf_utility_pvt.debug_message('@Done Calling generate product spread: Return:'||x_return_status);
574: ozf_utility_pvt.debug_message('@Calling allocate target');

Line 588: IF x_return_status = fnd_api.g_ret_sts_error THEN

584: , x_msg_count => x_msg_count
585: , x_msg_data => x_msg_data
586: );
587:
588: IF x_return_status = fnd_api.g_ret_sts_error THEN
589: RAISE fnd_api.g_exc_error;
590: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
591: RAISE fnd_api.g_exc_unexpected_error;
592: END IF;

Line 589: RAISE fnd_api.g_exc_error;

585: , x_msg_data => x_msg_data
586: );
587:
588: IF x_return_status = fnd_api.g_ret_sts_error THEN
589: RAISE fnd_api.g_exc_error;
590: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
591: RAISE fnd_api.g_exc_unexpected_error;
592: END IF;
593:

Line 590: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

586: );
587:
588: IF x_return_status = fnd_api.g_ret_sts_error THEN
589: RAISE fnd_api.g_exc_error;
590: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
591: RAISE fnd_api.g_exc_unexpected_error;
592: END IF;
593:
594: ozf_utility_pvt.debug_message('@Done Calling allocate target : return :'||x_return_status);

Line 591: RAISE fnd_api.g_exc_unexpected_error;

587:
588: IF x_return_status = fnd_api.g_ret_sts_error THEN
589: RAISE fnd_api.g_exc_error;
590: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
591: RAISE fnd_api.g_exc_unexpected_error;
592: END IF;
593:
594: ozf_utility_pvt.debug_message('@Done Calling allocate target : return :'||x_return_status);
595:

Line 597: WHEN Fnd_Api.G_EXC_ERROR THEN

593:
594: ozf_utility_pvt.debug_message('@Done Calling allocate target : return :'||x_return_status);
595:
596: EXCEPTION
597: WHEN Fnd_Api.G_EXC_ERROR THEN
598: x_return_status := Fnd_Api.g_ret_sts_error ;
599: ROLLBACK TO publish_allocation_sp;
600: Fnd_Msg_Pub.Count_AND_Get
601: ( p_count => x_msg_count,

Line 598: x_return_status := Fnd_Api.g_ret_sts_error ;

594: ozf_utility_pvt.debug_message('@Done Calling allocate target : return :'||x_return_status);
595:
596: EXCEPTION
597: WHEN Fnd_Api.G_EXC_ERROR THEN
598: x_return_status := Fnd_Api.g_ret_sts_error ;
599: ROLLBACK TO publish_allocation_sp;
600: Fnd_Msg_Pub.Count_AND_Get
601: ( p_count => x_msg_count,
602: p_data => x_msg_data,

Line 603: p_encoded => Fnd_Api.G_FALSE

599: ROLLBACK TO publish_allocation_sp;
600: Fnd_Msg_Pub.Count_AND_Get
601: ( p_count => x_msg_count,
602: p_data => x_msg_data,
603: p_encoded => Fnd_Api.G_FALSE
604: );
605: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
606: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
607: ROLLBACK TO publish_allocation_sp;

Line 605: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

601: ( p_count => x_msg_count,
602: p_data => x_msg_data,
603: p_encoded => Fnd_Api.G_FALSE
604: );
605: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
606: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
607: ROLLBACK TO publish_allocation_sp;
608: Fnd_Msg_Pub.Count_AND_Get
609: ( p_count => x_msg_count,

Line 606: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

602: p_data => x_msg_data,
603: p_encoded => Fnd_Api.G_FALSE
604: );
605: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
606: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
607: ROLLBACK TO publish_allocation_sp;
608: Fnd_Msg_Pub.Count_AND_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data,

Line 611: p_encoded => Fnd_Api.G_FALSE

607: ROLLBACK TO publish_allocation_sp;
608: Fnd_Msg_Pub.Count_AND_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => Fnd_Api.G_FALSE
612: );
613: WHEN OTHERS THEN
614: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
615: ROLLBACK TO publish_allocation_sp;

Line 614: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

610: p_data => x_msg_data,
611: p_encoded => Fnd_Api.G_FALSE
612: );
613: WHEN OTHERS THEN
614: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
615: ROLLBACK TO publish_allocation_sp;
616: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
617: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
618: END IF;

Line 622: p_encoded => Fnd_Api.G_FALSE

618: END IF;
619: Fnd_Msg_Pub.Count_AND_Get
620: ( p_count => x_msg_count,
621: p_data => x_msg_data,
622: p_encoded => Fnd_Api.G_FALSE
623: );
624:
625: END;
626:

Line 666: x_return_status := FND_API.G_RET_STS_SUCCESS;

662:
663: BEGIN
664:
665: SAVEPOINT cancel_alloc_hfq_sp;
666: x_return_status := FND_API.G_RET_STS_SUCCESS;
667:
668: --Get all the allocation header records for the fund_id and update the status_code to CANCELLED
669: update ozf_act_metrics_all
670: set status_code = 'CANCELLED'

Line 711: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

707: end loop;
708:
709: EXCEPTION
710: WHEN OTHERS THEN
711: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
712: ROLLBACK TO cancel_alloc_hfq_sp;
713: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
714: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
715: END IF;

Line 719: p_encoded => Fnd_Api.G_FALSE

715: END IF;
716: Fnd_Msg_Pub.Count_AND_Get
717: ( p_count => x_msg_count,
718: p_data => x_msg_data,
719: p_encoded => Fnd_Api.G_FALSE
720: );
721: END cancel_alloc_hfq;
722:
723: