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_FUND_UTILIZED_PUB dependencies on FND_API

Line 166: IF p_adj_rec.fund_id <> fnd_api.g_miss_num AND p_adj_rec.fund_id IS NOT NULL THEN

162:
163: BEGIN
164:
165: --check if the fund id or fund number is valid
166: IF p_adj_rec.fund_id <> fnd_api.g_miss_num AND p_adj_rec.fund_id IS NOT NULL THEN
167: --check if the input fund_id is valid
168: OPEN c_fund_exists (p_adj_rec.fund_id);
169: FETCH c_fund_exists INTO l_fund_exists;
170: CLOSE c_fund_exists;

Line 177: x_return_status := fnd_api.g_ret_sts_error;

173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
174: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_ID');
175: fnd_msg_pub.add;
176: END IF;
177: x_return_status := fnd_api.g_ret_sts_error;
178: RETURN;
179: END IF;
180: ELSIF p_adj_rec.fund_number <> fnd_api.g_miss_num AND p_adj_rec.fund_number IS NOT NULL THEN
181: --check if the input fund_number is valid

Line 180: ELSIF p_adj_rec.fund_number <> fnd_api.g_miss_num AND p_adj_rec.fund_number IS NOT NULL THEN

176: END IF;
177: x_return_status := fnd_api.g_ret_sts_error;
178: RETURN;
179: END IF;
180: ELSIF p_adj_rec.fund_number <> fnd_api.g_miss_num AND p_adj_rec.fund_number IS NOT NULL THEN
181: --check if the input fund_number is valid
182: OPEN c_fund_num_exists (p_adj_rec.fund_number);
183: FETCH c_fund_num_exists INTO l_fund_id;
184: CLOSE c_fund_num_exists;

Line 193: x_return_status := fnd_api.g_ret_sts_error;

189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
190: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_NUM');
191: fnd_msg_pub.add;
192: END IF;
193: x_return_status := fnd_api.g_ret_sts_error;
194: RETURN;
195: END IF;
196: END IF;
197:

Line 198: IF p_adj_rec.adjustment_type = fnd_api.g_miss_char OR p_adj_rec.adjustment_type IS NULL THEN

194: RETURN;
195: END IF;
196: END IF;
197:
198: IF p_adj_rec.adjustment_type = fnd_api.g_miss_char OR p_adj_rec.adjustment_type IS NULL THEN
199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
200: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_TYPE');
201: fnd_msg_pub.add;
202: END IF;

Line 203: x_return_status := fnd_api.g_ret_sts_error;

199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
200: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_TYPE');
201: fnd_msg_pub.add;
202: END IF;
203: x_return_status := fnd_api.g_ret_sts_error;
204: RETURN;
205: END IF;
206:
207: IF p_adj_rec.adjustment_type NOT IN ('DECREASE_COMM_EARNED', 'DECREASE_COMMITTED', 'DECREASE_EARNED',

Line 213: x_return_status := fnd_api.g_ret_sts_error;

209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
210: fnd_message.set_name('OZF', 'OZF_INVALID_ADJ_TYPE');
211: fnd_msg_pub.add;
212: END IF;
213: x_return_status := fnd_api.g_ret_sts_error;
214: RETURN;
215: END IF;
216:
217: mo_global.init('OZF');

Line 223: IF p_adj_rec.amount = fnd_api.g_miss_num OR p_adj_rec.amount IS NULL THEN

219: OPEN c_adj_type_id(p_adj_rec.adjustment_type);
220: FETCH c_adj_type_id INTO p_adj_rec.adjustment_type_id;
221: CLOSE c_adj_type_id;
222:
223: IF p_adj_rec.amount = fnd_api.g_miss_num OR p_adj_rec.amount IS NULL THEN
224: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
225: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_AMT');
226: fnd_msg_pub.add;
227: END IF;

Line 228: x_return_status := fnd_api.g_ret_sts_error;

224: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
225: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_AMT');
226: fnd_msg_pub.add;
227: END IF;
228: x_return_status := fnd_api.g_ret_sts_error;
229: RETURN;
230: END IF;
231:
232: IF p_adj_rec.fund_id IS NOT NULL THEN

Line 243: x_return_status := fnd_api.g_ret_sts_error;

239: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
240: fnd_message.set_name('OZF', 'OZF_INVALID_ACTIVITY_TYPE');
241: fnd_msg_pub.add;
242: END IF;
243: x_return_status := fnd_api.g_ret_sts_error;
244: RETURN;
245: END IF;
246:
247: IF p_adj_rec.activity_type = 'CAMP' THEN

Line 270: x_return_status := fnd_api.g_ret_sts_error;

266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
267: fnd_message.set_name('OZF', 'OZF_INVALID_ACTIVITY_ID');
268: fnd_msg_pub.add;
269: END IF;
270: x_return_status := fnd_api.g_ret_sts_error;
271: RETURN;
272: END IF;
273:
274:

Line 275: IF p_adj_rec.activity_type = 'CAMP' AND p_adj_rec.camp_schedule_id <> fnd_api.g_miss_num

271: RETURN;
272: END IF;
273:
274:
275: IF p_adj_rec.activity_type = 'CAMP' AND p_adj_rec.camp_schedule_id <> fnd_api.g_miss_num
276: AND p_adj_rec.camp_schedule_id IS NOT NULL THEN
277:
278: OPEN c_valid_csch (p_adj_rec.activity_id);
279: FETCH c_valid_csch INTO l_valid_csch;

Line 287: x_return_status := fnd_api.g_ret_sts_error;

283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
284: fnd_message.set_name('OZF', 'OZF_INVALID_CSCH_ID');
285: fnd_msg_pub.add;
286: END IF;
287: x_return_status := fnd_api.g_ret_sts_error;
288: RETURN;
289: END IF;
290: END IF;
291:

Line 292: IF p_adj_rec.customer_type <> fnd_api.g_miss_char AND p_adj_rec.customer_type IS NOT NULL THEN

288: RETURN;
289: END IF;
290: END IF;
291:
292: IF p_adj_rec.customer_type <> fnd_api.g_miss_char AND p_adj_rec.customer_type IS NOT NULL THEN
293:
294: OPEN c_valid_cust_type (p_adj_rec.customer_type);
295: FETCH c_valid_cust_type INTO l_cust_type;
296: CLOSE c_valid_cust_type;

Line 303: x_return_status := fnd_api.g_ret_sts_error;

299: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
300: fnd_message.set_name('OZF', 'OZF_INVALID_CUST_TYPE');
301: fnd_msg_pub.add;
302: END IF;
303: x_return_status := fnd_api.g_ret_sts_error;
304: RETURN;
305: END IF;
306:
307: IF p_adj_rec.customer_type = 'CUSTOMER' THEN

Line 336: IF p_adj_rec.cust_account_id = fnd_api.g_miss_num OR p_adj_rec.cust_account_id IS NULL THEN

332:
333: p_adj_rec.ship_to_site_use_id := p_adj_rec.cust_id;
334: END IF;
335:
336: IF p_adj_rec.cust_account_id = fnd_api.g_miss_num OR p_adj_rec.cust_account_id IS NULL THEN
337:
338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
339: fnd_message.set_name('OZF', 'OZF_INVALID_CUST_ID');
340: fnd_msg_pub.add;

Line 342: x_return_status := fnd_api.g_ret_sts_error;

338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
339: fnd_message.set_name('OZF', 'OZF_INVALID_CUST_ID');
340: fnd_msg_pub.add;
341: END IF;
342: x_return_status := fnd_api.g_ret_sts_error;
343: RETURN;
344: END IF;
345:
346: END IF;

Line 348: IF p_adj_rec.document_type <> fnd_api.g_miss_char AND p_adj_rec.document_type IS NOT NULL THEN

344: END IF;
345:
346: END IF;
347:
348: IF p_adj_rec.document_type <> fnd_api.g_miss_char AND p_adj_rec.document_type IS NOT NULL THEN
349: IF p_adj_rec.document_type NOT IN ('INVOICE', 'ORDER', 'PCHO', 'TP_ORDER') THEN
350:
351: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
352: fnd_message.set_name('OZF', 'OZF_INVALID_DOCUMENT_TYPE');

Line 355: x_return_status := fnd_api.g_ret_sts_error;

351: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
352: fnd_message.set_name('OZF', 'OZF_INVALID_DOCUMENT_TYPE');
353: fnd_msg_pub.add;
354: END IF;
355: x_return_status := fnd_api.g_ret_sts_error;
356: RETURN;
357: END IF;
358:
359: IF p_adj_rec.document_number = fnd_api.g_miss_num OR p_adj_rec.document_number IS NULL THEN

Line 359: IF p_adj_rec.document_number = fnd_api.g_miss_num OR p_adj_rec.document_number IS NULL THEN

355: x_return_status := fnd_api.g_ret_sts_error;
356: RETURN;
357: END IF;
358:
359: IF p_adj_rec.document_number = fnd_api.g_miss_num OR p_adj_rec.document_number IS NULL THEN
360:
361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
362: fnd_message.set_name('OZF', 'OZF_NO_DOCUMENT_NUM');
363: fnd_msg_pub.add;

Line 365: x_return_status := fnd_api.g_ret_sts_error;

361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
362: fnd_message.set_name('OZF', 'OZF_NO_DOCUMENT_NUM');
363: fnd_msg_pub.add;
364: END IF;
365: x_return_status := fnd_api.g_ret_sts_error;
366: RETURN;
367: END IF;
368: END IF;
369:

Line 371: IF p_adj_rec.scan_type_id <> fnd_api.g_miss_num AND p_adj_rec.scan_type_id IS NOT NULL THEN

367: END IF;
368: END IF;
369:
370: -- for SCAN_DATA type of offer
371: IF p_adj_rec.scan_type_id <> fnd_api.g_miss_num AND p_adj_rec.scan_type_id IS NOT NULL THEN
372:
373: OPEN c_valid_scantype_id (p_adj_rec.activity_id, p_adj_rec.scan_type_id);
374: FETCH c_valid_scantype_id INTO l_valid_scantype_id;
375: CLOSE c_valid_scantype_id;

Line 382: x_return_status := fnd_api.g_ret_sts_error;

378: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
379: fnd_message.set_name('OZF', 'OZF_INVALID_SCANTYPE_ID');
380: fnd_msg_pub.add;
381: END IF;
382: x_return_status := fnd_api.g_ret_sts_error;
383: RETURN;
384: END IF;
385: END IF;
386:

Line 388: IF p_adj_rec.product_level_type <> fnd_api.g_miss_char AND p_adj_rec.product_level_type IS NOT NULL THEN

384: END IF;
385: END IF;
386:
387: IF p_adj_rec.activity_type = 'OFFR' THEN
388: IF p_adj_rec.product_level_type <> fnd_api.g_miss_char AND p_adj_rec.product_level_type IS NOT NULL THEN
389:
390: IF p_adj_rec.product_level_type NOT IN ('FAMILY', 'PRODUCT') THEN
391: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
392: fnd_message.set_name('OZF', 'OZF_INVALID_PROD_LEVEL');

Line 395: x_return_status := fnd_api.g_ret_sts_error;

391: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
392: fnd_message.set_name('OZF', 'OZF_INVALID_PROD_LEVEL');
393: fnd_msg_pub.add;
394: END IF;
395: x_return_status := fnd_api.g_ret_sts_error;
396: RETURN;
397: END IF;
398:
399: IF G_DEBUG THEN

Line 405: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN

401: ozf_utility_pvt.debug_message('p_adj_rec.product_name: ' || p_adj_rec.product_name);
402: ozf_utility_pvt.debug_message('p_adj_rec.org_id: ' || p_adj_rec.org_id);
403: END IF;
404:
405: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN
406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
407: fnd_message.set_name('OZF', 'OZF_NO_PROD_NAME');
408: fnd_msg_pub.add;
409: END IF;

Line 410: x_return_status := fnd_api.g_ret_sts_error;

406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
407: fnd_message.set_name('OZF', 'OZF_NO_PROD_NAME');
408: fnd_msg_pub.add;
409: END IF;
410: x_return_status := fnd_api.g_ret_sts_error;
411: RETURN;
412: ELSE
413: IF p_adj_rec.product_level_type = 'FAMILY' THEN
414: OPEN c_valid_prod_family (p_adj_rec.product_name);

Line 428: x_return_status := fnd_api.g_ret_sts_error;

424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
425: fnd_message.set_name('OZF', 'OZF_INVALID_PROD');
426: fnd_msg_pub.add;
427: END IF;
428: x_return_status := fnd_api.g_ret_sts_error;
429: RETURN;
430: END IF;
431: END IF;
432: END IF;

Line 439: IF p_adj_rec.gl_account_credit = fnd_api.g_miss_num OR p_adj_rec.gl_account_credit IS NULL THEN

435: p_adj_rec.product_id := NULL;
436: END IF;
437:
438: IF p_adj_rec.adjustment_type IN ('INCREASE_PAID', 'DECREASE_PAID') THEN
439: IF p_adj_rec.gl_account_credit = fnd_api.g_miss_num OR p_adj_rec.gl_account_credit IS NULL THEN
440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
441: fnd_message.set_name('OZF', 'OZF_NO_GL_CREDIT_ACCT');
442: fnd_msg_pub.add;
443: END IF;

Line 444: x_return_status := fnd_api.g_ret_sts_error;

440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
441: fnd_message.set_name('OZF', 'OZF_NO_GL_CREDIT_ACCT');
442: fnd_msg_pub.add;
443: END IF;
444: x_return_status := fnd_api.g_ret_sts_error;
445: RETURN;
446: END IF;
447:
448: IF p_adj_rec.gl_account_debit = fnd_api.g_miss_num OR p_adj_rec.gl_account_debit IS NULL THEN

Line 448: IF p_adj_rec.gl_account_debit = fnd_api.g_miss_num OR p_adj_rec.gl_account_debit IS NULL THEN

444: x_return_status := fnd_api.g_ret_sts_error;
445: RETURN;
446: END IF;
447:
448: IF p_adj_rec.gl_account_debit = fnd_api.g_miss_num OR p_adj_rec.gl_account_debit IS NULL THEN
449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
450: fnd_message.set_name('OZF', 'OZF_NO_GL_DEBIT_ACCT');
451: fnd_msg_pub.add;
452: END IF;

Line 453: x_return_status := fnd_api.g_ret_sts_error;

449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
450: fnd_message.set_name('OZF', 'OZF_NO_GL_DEBIT_ACCT');
451: fnd_msg_pub.add;
452: END IF;
453: x_return_status := fnd_api.g_ret_sts_error;
454: RETURN;
455: END IF;
456: END IF;
457:

Line 462: IF p_adj_rec.skip_acct_gen_flag <> fnd_api.g_miss_char AND p_adj_rec.skip_acct_gen_flag IS NOT NULL THEN

458: OPEN c_approver_id (p_adj_rec.fund_id);
459: FETCH c_approver_id INTO p_adj_rec.approver_id;
460: CLOSE c_approver_id;
461:
462: IF p_adj_rec.skip_acct_gen_flag <> fnd_api.g_miss_char AND p_adj_rec.skip_acct_gen_flag IS NOT NULL THEN
463:
464: IF p_adj_rec.skip_acct_gen_flag NOT IN ('F', 'T') THEN
465: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
466: fnd_message.set_name('OZF', 'OZF_INVALID_ACCT_GEN_FLAG');

Line 469: x_return_status := fnd_api.g_ret_sts_error;

465: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
466: fnd_message.set_name('OZF', 'OZF_INVALID_ACCT_GEN_FLAG');
467: fnd_msg_pub.add;
468: END IF;
469: x_return_status := fnd_api.g_ret_sts_error;
470: RETURN;
471: END IF;
472: END IF;
473:

Line 475: IF p_adj_rec.order_line_id <> fnd_api.g_miss_num AND p_adj_rec.order_line_id IS NOT NULL THEN

471: END IF;
472: END IF;
473:
474: --Order_Line_Id validation added by Pranay/29.02.08
475: IF p_adj_rec.order_line_id <> fnd_api.g_miss_num AND p_adj_rec.order_line_id IS NOT NULL THEN
476: OPEN c_order_line(p_adj_rec.order_line_id);
477: FETCH c_order_line INTO l_dummy;
478: IF c_order_line%NOTFOUND THEN
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 483: x_return_status := fnd_api.g_ret_sts_error;

479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
480: fnd_message.set_name('OZF', 'OZF_INVALID_ORDER_LINE');
481: fnd_msg_pub.add;
482: END IF;
483: x_return_status := fnd_api.g_ret_sts_error;
484: RETURN;
485: END IF;
486: CLOSE c_order_line;
487: END IF;

Line 506: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

502: -- 03/14/2008 psomyaju ER-6858324
503: ---------------------------------------------------------------------
504: PROCEDURE Create_Fund_Adjustment(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
507: ,p_commit IN VARCHAR2 := fnd_api.g_false
508: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
509: ,p_adj_rec IN OZF_FUND_UTILIZED_PUB.adjustment_rec_type
510: ,x_return_status OUT NOCOPY VARCHAR2

Line 507: ,p_commit IN VARCHAR2 := fnd_api.g_false

503: ---------------------------------------------------------------------
504: PROCEDURE Create_Fund_Adjustment(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
507: ,p_commit IN VARCHAR2 := fnd_api.g_false
508: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
509: ,p_adj_rec IN OZF_FUND_UTILIZED_PUB.adjustment_rec_type
510: ,x_return_status OUT NOCOPY VARCHAR2
511: ,x_msg_count OUT NOCOPY NUMBER

Line 508: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

504: PROCEDURE Create_Fund_Adjustment(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
507: ,p_commit IN VARCHAR2 := fnd_api.g_false
508: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
509: ,p_adj_rec IN OZF_FUND_UTILIZED_PUB.adjustment_rec_type
510: ,x_return_status OUT NOCOPY VARCHAR2
511: ,x_msg_count OUT NOCOPY NUMBER
512: ,x_msg_data OUT NOCOPY VARCHAR2

Line 565: IF l_adj_rec.currency_code = fnd_api.g_miss_char OR l_adj_rec.currency_code IS NULL THEN

561: SAVEPOINT Create_Fund_Adjustment;
562:
563: IF l_adj_rec.fund_id IS NULL THEN
564:
565: IF l_adj_rec.currency_code = fnd_api.g_miss_char OR l_adj_rec.currency_code IS NULL THEN
566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
567: fnd_message.set_name('OZF', 'OZF_FUND_NO_CURR_CODE');
568: fnd_msg_pub.add;
569: END IF;

Line 570: RAISE fnd_api.g_exc_error;

566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
567: fnd_message.set_name('OZF', 'OZF_FUND_NO_CURR_CODE');
568: fnd_msg_pub.add;
569: END IF;
570: RAISE fnd_api.g_exc_error;
571: END IF;
572:
573: --get the budgets from which the object is sourcing to post the adjustment amount proportionately
574: ozf_fund_adjustment_pvt.get_parent_src(p_budget_source_type => l_adj_rec.activity_type

Line 582: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

578: ,x_return_status => x_return_status
579: ,x_parent_src_tbl => l_parent_src_tbl
580: );
581:
582: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
583: RAISE fnd_api.g_exc_unexpected_error;
584: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
585: RAISE fnd_api.g_exc_error;
586: END IF;

Line 583: RAISE fnd_api.g_exc_unexpected_error;

579: ,x_parent_src_tbl => l_parent_src_tbl
580: );
581:
582: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
583: RAISE fnd_api.g_exc_unexpected_error;
584: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
585: RAISE fnd_api.g_exc_error;
586: END IF;
587:

Line 584: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

580: );
581:
582: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
583: RAISE fnd_api.g_exc_unexpected_error;
584: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
585: RAISE fnd_api.g_exc_error;
586: END IF;
587:
588: IF G_DEBUG THEN

Line 585: RAISE fnd_api.g_exc_error;

581:
582: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
583: RAISE fnd_api.g_exc_unexpected_error;
584: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
585: RAISE fnd_api.g_exc_error;
586: END IF;
587:
588: IF G_DEBUG THEN
589: ozf_utility_pvt.debug_message('l_parent_src_tbl.count: ' || l_parent_src_tbl.count);

Line 600: RAISE fnd_api.g_exc_error;

596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
597: fnd_message.set_name('OZF', 'OZF_NO_SRC_BUDGETS');
598: fnd_msg_pub.add;
599: END IF;
600: RAISE fnd_api.g_exc_error;
601: END IF;
602:
603: END IF;
604:

Line 606: IF l_adj_rec.org_id = fnd_api.g_miss_num OR l_adj_rec.org_id IS NULL THEN

602:
603: END IF;
604:
605: --get the org_id
606: IF l_adj_rec.org_id = fnd_api.g_miss_num OR l_adj_rec.org_id IS NULL THEN
607: IF l_adj_rec.document_type = 'ORDER' THEN
608: OPEN c_org_order (l_adj_rec.document_number);
609: FETCH c_org_order INTO l_adj_rec.org_id;
610: CLOSE c_org_order;

Line 621: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

617:
618: validate_items(p_adj_rec => l_adj_rec
619: ,x_return_status => x_return_status);
620:
621: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
622: RAISE fnd_api.g_exc_unexpected_error;
623: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
624: RAISE fnd_api.g_exc_error;
625: END IF;

Line 622: RAISE fnd_api.g_exc_unexpected_error;

618: validate_items(p_adj_rec => l_adj_rec
619: ,x_return_status => x_return_status);
620:
621: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
622: RAISE fnd_api.g_exc_unexpected_error;
623: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
624: RAISE fnd_api.g_exc_error;
625: END IF;
626:

Line 623: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

619: ,x_return_status => x_return_status);
620:
621: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
622: RAISE fnd_api.g_exc_unexpected_error;
623: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
624: RAISE fnd_api.g_exc_error;
625: END IF;
626:
627: l_act_util_rec.adjustment_type_id := l_adj_rec.adjustment_type_id;

Line 624: RAISE fnd_api.g_exc_error;

620:
621: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
622: RAISE fnd_api.g_exc_unexpected_error;
623: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
624: RAISE fnd_api.g_exc_error;
625: END IF;
626:
627: l_act_util_rec.adjustment_type_id := l_adj_rec.adjustment_type_id;
628: l_act_util_rec.adjustment_type := l_adj_rec.adjustment_type;

Line 735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

731: END LOOP;
732:
733: END IF;
734:
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;

Line 736: RAISE FND_API.g_exc_unexpected_error;

732:
733: END IF;
734:
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;
740:

Line 737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

733: END IF;
734:
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;
740:
741: --reset utilization_type for decrease committed amount

Line 738: RAISE FND_API.g_exc_unexpected_error;

734:
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.g_exc_unexpected_error;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;
740:
741: --reset utilization_type for decrease committed amount
742: l_act_util_rec.utilization_type := NULL;

Line 802: RAISE fnd_api.g_exc_error;

798: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
799: fnd_message.set_name('OZF', 'OZF_NO_ORIG_UTIL_ID');
800: fnd_msg_pub.add;
801: END IF;
802: RAISE fnd_api.g_exc_error;
803: END IF;
804:
805: --if the original utilization is not posted to GL(e.g. marketing cost, or off invoice offer
806: --where gl posting is not required), then paid adjustment should not be allowed.

Line 812: RAISE fnd_api.g_exc_error;

808: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
809: fnd_message.set_name('OZF', 'OZF_ADJ_PAID_NOT_ALLOWED');
810: fnd_msg_pub.add;
811: END IF;
812: RAISE fnd_api.g_exc_error;
813: END IF;
814:
815: IF l_act_util_rec.adjustment_type = 'DECREASE_PAID' THEN
816: l_act_budgets_rec.parent_src_apprvd_amt := - l_act_budgets_rec.parent_src_apprvd_amt;

Line 877: RAISE fnd_api.g_exc_error;

873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
874: fnd_message.set_name('OZF', 'OZF_NO_ORIG_UTIL_ID');
875: fnd_msg_pub.add;
876: END IF;
877: RAISE fnd_api.g_exc_error;
878: END IF;
879:
880: --if the original utilization is not posted to GL(e.g. marketing cost, or off invoice offer
881: --where gl posting is not required), then paid adjustment should not be allowed.

Line 887: RAISE fnd_api.g_exc_error;

883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
884: fnd_message.set_name('OZF', 'OZF_ADJ_PAID_NOT_ALLOWED');
885: fnd_msg_pub.add;
886: END IF;
887: RAISE fnd_api.g_exc_error;
888: END IF;
889:
890: IF l_act_util_rec.adjustment_type = 'DECREASE_PAID' THEN
891: l_act_budgets_rec.parent_src_apprvd_amt := - l_act_budgets_rec.parent_src_apprvd_amt;

Line 908: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

904: END IF;
905:
906: END IF;
907:
908: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
909: RAISE fnd_api.g_exc_unexpected_error;
910: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: END IF;

Line 909: RAISE fnd_api.g_exc_unexpected_error;

905:
906: END IF;
907:
908: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
909: RAISE fnd_api.g_exc_unexpected_error;
910: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: END IF;
913:

Line 910: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

906: END IF;
907:
908: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
909: RAISE fnd_api.g_exc_unexpected_error;
910: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: END IF;
913:
914: FND_MSG_PUB.Count_And_Get (

Line 911: RAISE fnd_api.g_exc_error;

907:
908: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
909: RAISE fnd_api.g_exc_unexpected_error;
910: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: END IF;
913:
914: FND_MSG_PUB.Count_And_Get (
915: p_encoded => FND_API.G_FALSE,

Line 915: p_encoded => FND_API.G_FALSE,

911: RAISE fnd_api.g_exc_error;
912: END IF;
913:
914: FND_MSG_PUB.Count_And_Get (
915: p_encoded => FND_API.G_FALSE,
916: p_count => x_msg_count,
917: p_data => x_msg_data
918: );
919:

Line 921: WHEN FND_API.G_EXC_ERROR THEN

917: p_data => x_msg_data
918: );
919:
920: EXCEPTION
921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO Create_Fund_Adjustment;
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919:
920: EXCEPTION
921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO Create_Fund_Adjustment;
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
926: ,p_count => x_msg_count
927: ,p_data => x_msg_data

Line 925: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO Create_Fund_Adjustment;
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
926: ,p_count => x_msg_count
927: ,p_data => x_msg_data
928: );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

925: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
926: ,p_count => x_msg_count
927: ,p_data => x_msg_data
928: );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: ROLLBACK TO Create_Fund_Adjustment;
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

927: ,p_data => x_msg_data
928: );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: ROLLBACK TO Create_Fund_Adjustment;
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
934: ,p_count => x_msg_count
935: ,p_data => x_msg_data

Line 933: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: ROLLBACK TO Create_Fund_Adjustment;
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
934: ,p_count => x_msg_count
935: ,p_data => x_msg_data
936: );
937: WHEN OTHERS THEN

Line 939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

935: ,p_data => x_msg_data
936: );
937: WHEN OTHERS THEN
938: ROLLBACK TO Create_Fund_Adjustment;
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
940: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
941: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
942: END IF;
943: -- Standard call to get message count and if count=1, get the message

Line 944: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

940: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
941: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
942: END IF;
943: -- Standard call to get message count and if count=1, get the message
944: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
945: ,p_count => x_msg_count
946: ,p_data => x_msg_data
947: );
948: END Create_Fund_Adjustment;