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

Line 205: x_return_status := fnd_api.g_ret_sts_success;

201: AND object_type = 'OFFR'
202: AND object_id = p_offer_id;
203:
204: BEGIN
205: x_return_status := fnd_api.g_ret_sts_success;
206:
207: IF g_debug_flag = 'Y' THEN
208: ozf_utility_pvt.write_conc_log(' D: ENTER calculate_accrual_amount offer_id=' || p_src_id || ' p_earned_amt=' || p_earned_amt);
209: END IF;

Line 311: IF l_return_status <> fnd_api.g_ret_sts_success THEN

307:
308: IF g_debug_flag = 'Y' THEN
309: ozf_utility_pvt.write_conc_log (' D: calculate_accrual_amount(): check_budget_qualification status: ' || l_return_status);
310: END IF;
311: IF l_return_status <> fnd_api.g_ret_sts_success THEN
312: l_eligible_flag := false;
313: END IF;
314: ELSE
315: l_eligible_flag := true;

Line 356: x_return_status := fnd_api.g_ret_sts_error;

352:
353: -- Note that the amounts are in one currency
354: IF l_total_amount = 0 THEN
355: IF g_recal_flag = 'N' and p_earned_amt < 0 THEN -- ??? really needed ???
356: x_return_status := fnd_api.g_ret_sts_error;
357: RETURN;
358: END IF;
359: END IF;
360:

Line 400: x_return_status := fnd_api.g_ret_sts_unexp_error;

396: END IF;
397: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
398: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Calculate Accrual');
399: END IF;
400: x_return_status := fnd_api.g_ret_sts_unexp_error;
401: END calculate_accrual_amount;
402:
403: /*****************************************************************************************/
404: -- Start of Comments

Line 470: x_return_status := fnd_api.g_ret_sts_success;

466: -- Standard Start of API savepoint
467: SAVEPOINT create_actbudgets_rec;
468:
469: -- Initialize API return status to success
470: x_return_status := fnd_api.g_ret_sts_success;
471:
472:
473: OPEN c_act_util_rec (
474: p_act_budgets_rec.act_budget_used_by_id,

Line 506: RAISE fnd_api.g_exc_unexpected_error;

502: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
503: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
504: fnd_msg_pub.ADD;
505: END IF;
506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;
508:
509: RETURN; -- exit from program.
510: END IF;

Line 514: x_return_status := fnd_api.g_ret_sts_error;

510: END IF;
511:
512: IF l_act_budgets_rec.request_currency IS NULL THEN
513: ozf_utility_pvt.write_conc_log ('OZF_ACT_BUDG_NO_CURRENCY');
514: x_return_status := fnd_api.g_ret_sts_error;
515: END IF;
516:
517: /* Added for bug 7030415
518: This currency conversion is for approved_amount_fc column in ozf_act_budgets table.

Line 551: IF l_return_status = fnd_api.g_ret_sts_error THEN

547: IF g_debug_flag = 'Y' THEN
548: ozf_utility_pvt.write_conc_log(l_full_name || 'calculate_functional_curr: ' || l_return_status);
549: END IF;
550:
551: IF l_return_status = fnd_api.g_ret_sts_error THEN
552: RAISE fnd_api.g_exc_error;
553: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
554: RAISE fnd_api.g_exc_unexpected_error;
555: END IF;

Line 552: RAISE fnd_api.g_exc_error;

548: ozf_utility_pvt.write_conc_log(l_full_name || 'calculate_functional_curr: ' || l_return_status);
549: END IF;
550:
551: IF l_return_status = fnd_api.g_ret_sts_error THEN
552: RAISE fnd_api.g_exc_error;
553: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
554: RAISE fnd_api.g_exc_unexpected_error;
555: END IF;
556: END IF;

Line 553: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

549: END IF;
550:
551: IF l_return_status = fnd_api.g_ret_sts_error THEN
552: RAISE fnd_api.g_exc_error;
553: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
554: RAISE fnd_api.g_exc_unexpected_error;
555: END IF;
556: END IF;
557:

Line 554: RAISE fnd_api.g_exc_unexpected_error;

550:
551: IF l_return_status = fnd_api.g_ret_sts_error THEN
552: RAISE fnd_api.g_exc_error;
553: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
554: RAISE fnd_api.g_exc_unexpected_error;
555: END IF;
556: END IF;
557:
558: OPEN c_act_budget_id;

Line 640: p_encoded=> fnd_api.g_false

636: -- Standard call to get message count AND IF count is 1, get message info.
637: fnd_msg_pub.count_and_get (
638: p_count=> x_msg_count,
639: p_data=> x_msg_data,
640: p_encoded=> fnd_api.g_false
641: );
642:
643: EXCEPTION
644: WHEN fnd_api.g_exc_error THEN

Line 644: WHEN fnd_api.g_exc_error THEN

640: p_encoded=> fnd_api.g_false
641: );
642:
643: EXCEPTION
644: WHEN fnd_api.g_exc_error THEN
645: ROLLBACK TO create_actbudgets_rec;
646: x_return_status := fnd_api.g_ret_sts_error;
647: fnd_msg_pub.count_and_get (
648: p_count=> x_msg_count,

Line 646: x_return_status := fnd_api.g_ret_sts_error;

642:
643: EXCEPTION
644: WHEN fnd_api.g_exc_error THEN
645: ROLLBACK TO create_actbudgets_rec;
646: x_return_status := fnd_api.g_ret_sts_error;
647: fnd_msg_pub.count_and_get (
648: p_count=> x_msg_count,
649: p_data=> x_msg_data,
650: p_encoded=> fnd_api.g_false

Line 650: p_encoded=> fnd_api.g_false

646: x_return_status := fnd_api.g_ret_sts_error;
647: fnd_msg_pub.count_and_get (
648: p_count=> x_msg_count,
649: p_data=> x_msg_data,
650: p_encoded=> fnd_api.g_false
651: );
652:
653: WHEN fnd_api.g_exc_unexpected_error THEN
654: ROLLBACK TO create_actbudgets_rec;

Line 653: WHEN fnd_api.g_exc_unexpected_error THEN

649: p_data=> x_msg_data,
650: p_encoded=> fnd_api.g_false
651: );
652:
653: WHEN fnd_api.g_exc_unexpected_error THEN
654: ROLLBACK TO create_actbudgets_rec;
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656: fnd_msg_pub.count_and_get (
657: p_count=> x_msg_count,

Line 655: x_return_status := fnd_api.g_ret_sts_unexp_error;

651: );
652:
653: WHEN fnd_api.g_exc_unexpected_error THEN
654: ROLLBACK TO create_actbudgets_rec;
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656: fnd_msg_pub.count_and_get (
657: p_count=> x_msg_count,
658: p_data=> x_msg_data,
659: p_encoded=>fnd_api.g_false

Line 659: p_encoded=>fnd_api.g_false

655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656: fnd_msg_pub.count_and_get (
657: p_count=> x_msg_count,
658: p_data=> x_msg_data,
659: p_encoded=>fnd_api.g_false
660: );
661:
662: WHEN OTHERS THEN
663: ROLLBACK TO create_actbudgets_rec;

Line 664: x_return_status := fnd_api.g_ret_sts_unexp_error;

660: );
661:
662: WHEN OTHERS THEN
663: ROLLBACK TO create_actbudgets_rec;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: fnd_msg_pub.count_and_get (
667: p_count=> x_msg_count,
668: p_data=> x_msg_data,

Line 669: p_encoded=> fnd_api.g_false

665:
666: fnd_msg_pub.count_and_get (
667: p_count=> x_msg_count,
668: p_data=> x_msg_data,
669: p_encoded=> fnd_api.g_false
670: );
671:
672: END create_actbudgets_rec;
673:

Line 955: x_return_status := fnd_api.g_ret_sts_success;

951: ozf_utility_pvt.write_conc_log( l_full_name
952: || ': start' || p_utilization_rec.utilization_type);
953: END IF;
954:
955: x_return_status := fnd_api.g_ret_sts_success;
956:
957: -- Get the identifier
958: OPEN c_utilization_seq;
959: FETCH c_utilization_seq INTO l_utilization_rec.utilization_id;

Line 986: RAISE fnd_api.g_exc_error;

982: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
983: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
984: fnd_msg_pub.ADD;
985: END IF;
986: RAISE fnd_api.g_exc_error;
987: END IF;
988: CLOSE c_fund_b;
989:
990: OPEN c_offinv_flag(l_utilization_rec.org_id);

Line 1117: IF l_return_status = fnd_api.g_ret_sts_error THEN

1113: ,x_exchange_rate=> l_utilization_rec.exchange_rate
1114: ,x_return_status=> l_return_status
1115: );
1116:
1117: IF l_return_status = fnd_api.g_ret_sts_error THEN
1118: RAISE fnd_api.g_exc_error;
1119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1120: RAISE fnd_api.g_exc_unexpected_error;
1121: END IF;

Line 1118: RAISE fnd_api.g_exc_error;

1114: ,x_return_status=> l_return_status
1115: );
1116:
1117: IF l_return_status = fnd_api.g_ret_sts_error THEN
1118: RAISE fnd_api.g_exc_error;
1119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1120: RAISE fnd_api.g_exc_unexpected_error;
1121: END IF;
1122: END IF;

Line 1119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1115: );
1116:
1117: IF l_return_status = fnd_api.g_ret_sts_error THEN
1118: RAISE fnd_api.g_exc_error;
1119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1120: RAISE fnd_api.g_exc_unexpected_error;
1121: END IF;
1122: END IF;
1123:

Line 1120: RAISE fnd_api.g_exc_unexpected_error;

1116:
1117: IF l_return_status = fnd_api.g_ret_sts_error THEN
1118: RAISE fnd_api.g_exc_error;
1119: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1120: RAISE fnd_api.g_exc_unexpected_error;
1121: END IF;
1122: END IF;
1123:
1124: -- yzhao: 10/20/2003 when object sources from sales accrual budget, the budget behaves like fixed budget.

Line 1251: RAISE fnd_api.g_exc_error;

1247: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1248: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
1249: fnd_msg_pub.add;
1250: END IF;
1251: RAISE fnd_api.g_exc_error;
1252: END IF;
1253:
1254: --rimehrot for R12, populate universal currency amount column
1255: IF g_universal_currency = l_utilization_rec.currency_code THEN

Line 1286: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1282: IF g_debug_flag = 'Y' THEN
1283: ozf_utility_pvt.write_conc_log(l_api_name||' Converted Amount l_utilization_rec.univ_curr_amount: '|| l_utilization_rec.univ_curr_amount);
1284: ozf_utility_pvt.write_conc_log('Utilization amount is converted from request curr to universal curr to populate univ_curr_amount column in izf_funds_utilized_all_b');
1285: END IF;
1286: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1287: RAISE fnd_api.g_exc_unexpected_error;
1288: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1289: RAISE fnd_api.g_exc_error;
1290: END IF;

Line 1287: RAISE fnd_api.g_exc_unexpected_error;

1283: ozf_utility_pvt.write_conc_log(l_api_name||' Converted Amount l_utilization_rec.univ_curr_amount: '|| l_utilization_rec.univ_curr_amount);
1284: ozf_utility_pvt.write_conc_log('Utilization amount is converted from request curr to universal curr to populate univ_curr_amount column in izf_funds_utilized_all_b');
1285: END IF;
1286: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1287: RAISE fnd_api.g_exc_unexpected_error;
1288: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1289: RAISE fnd_api.g_exc_error;
1290: END IF;
1291: /* Send the exchange rate for bug 7030415 */

Line 1288: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1284: ozf_utility_pvt.write_conc_log('Utilization amount is converted from request curr to universal curr to populate univ_curr_amount column in izf_funds_utilized_all_b');
1285: END IF;
1286: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1287: RAISE fnd_api.g_exc_unexpected_error;
1288: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1289: RAISE fnd_api.g_exc_error;
1290: END IF;
1291: /* Send the exchange rate for bug 7030415 */
1292: ozf_utility_pvt.convert_currency (

Line 1289: RAISE fnd_api.g_exc_error;

1285: END IF;
1286: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1287: RAISE fnd_api.g_exc_unexpected_error;
1288: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1289: RAISE fnd_api.g_exc_error;
1290: END IF;
1291: /* Send the exchange rate for bug 7030415 */
1292: ozf_utility_pvt.convert_currency (
1293: p_from_currency=> l_utilization_rec.currency_code

Line 1307: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1303: ozf_utility_pvt.write_conc_log(l_api_name||' Converted Amount l_utilization_rec.univ_curr_amount_remaining: '|| l_utilization_rec.univ_curr_amount_remaining);
1304: ozf_utility_pvt.write_conc_log('Utilization amount is converted from request curr to universal curr to populate univ_curr_amount column in izf_funds_utilized_all_b');
1305: ozf_utility_pvt.write_conc_log('***************************END******************************');
1306: END IF;
1307: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1308: RAISE fnd_api.g_exc_unexpected_error;
1309: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1310: RAISE fnd_api.g_exc_error;
1311: END IF;

Line 1308: RAISE fnd_api.g_exc_unexpected_error;

1304: ozf_utility_pvt.write_conc_log('Utilization amount is converted from request curr to universal curr to populate univ_curr_amount column in izf_funds_utilized_all_b');
1305: ozf_utility_pvt.write_conc_log('***************************END******************************');
1306: END IF;
1307: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1308: RAISE fnd_api.g_exc_unexpected_error;
1309: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1310: RAISE fnd_api.g_exc_error;
1311: END IF;
1312: END IF; -- g_universal_currency = l_utilization_rec.currency_code

Line 1309: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1305: ozf_utility_pvt.write_conc_log('***************************END******************************');
1306: END IF;
1307: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1308: RAISE fnd_api.g_exc_unexpected_error;
1309: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1310: RAISE fnd_api.g_exc_error;
1311: END IF;
1312: END IF; -- g_universal_currency = l_utilization_rec.currency_code
1313:

Line 1310: RAISE fnd_api.g_exc_error;

1306: END IF;
1307: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1308: RAISE fnd_api.g_exc_unexpected_error;
1309: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1310: RAISE fnd_api.g_exc_error;
1311: END IF;
1312: END IF; -- g_universal_currency = l_utilization_rec.currency_code
1313:
1314: INSERT INTO ozf_funds_utilized_all_b

Line 1465: RAISE fnd_api.g_exc_error;

1461: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1462: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1463: fnd_msg_pub.ADD;
1464: END IF;
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467: CLOSE c_mc_trans;
1468: */
1469: -- rimehrot changed for R12, Populate new table ozf_object_fund_summary

Line 1547: RAISE fnd_api.g_exc_error;

1543: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1544: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1545: fnd_msg_pub.ADD;
1546: END IF;
1547: RAISE fnd_api.g_exc_error;
1548: END IF;
1549: CLOSE c_accrual_budget_reqeust;
1550:
1551: UPDATE ozf_act_budgets

Line 1575: RAISE fnd_api.g_exc_error;

1571: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1572: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1573: fnd_msg_pub.ADD;
1574: END IF;
1575: RAISE fnd_api.g_exc_error;
1576: END IF;
1577: CLOSE c_budget_request_utilrec;
1578:
1579: -- populate request amount in ozf_funds_utilized_all_b record

Line 1692: p_init_msg_list => Fnd_Api.G_FALSE,

1688: l_objfundsum_rec.object_type := l_utilization_rec.component_type;
1689: l_objfundsum_rec.object_id := l_utilization_rec.component_id;
1690: ozf_objfundsum_pvt.create_objfundsum(
1691: p_api_version => 1.0,
1692: p_init_msg_list => Fnd_Api.G_FALSE,
1693: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
1694: p_objfundsum_rec => l_objfundsum_rec,
1695: x_return_status => l_return_status,
1696: x_msg_count => x_msg_count,

Line 1693: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,

1689: l_objfundsum_rec.object_id := l_utilization_rec.component_id;
1690: ozf_objfundsum_pvt.create_objfundsum(
1691: p_api_version => 1.0,
1692: p_init_msg_list => Fnd_Api.G_FALSE,
1693: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
1694: p_objfundsum_rec => l_objfundsum_rec,
1695: x_return_status => l_return_status,
1696: x_msg_count => x_msg_count,
1697: x_msg_data => x_msg_data,

Line 1700: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1696: x_msg_count => x_msg_count,
1697: x_msg_data => x_msg_data,
1698: x_objfundsum_id => l_objfundsum_id
1699: );
1700: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1701: RAISE fnd_api.g_exc_unexpected_error;
1702: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1703: RAISE fnd_api.g_exc_error;
1704: END IF;

Line 1701: RAISE fnd_api.g_exc_unexpected_error;

1697: x_msg_data => x_msg_data,
1698: x_objfundsum_id => l_objfundsum_id
1699: );
1700: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1701: RAISE fnd_api.g_exc_unexpected_error;
1702: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1703: RAISE fnd_api.g_exc_error;
1704: END IF;
1705: ELSE

Line 1702: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1698: x_objfundsum_id => l_objfundsum_id
1699: );
1700: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1701: RAISE fnd_api.g_exc_unexpected_error;
1702: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1703: RAISE fnd_api.g_exc_error;
1704: END IF;
1705: ELSE
1706: ozf_objfundsum_pvt.update_objfundsum(

Line 1703: RAISE fnd_api.g_exc_error;

1699: );
1700: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1701: RAISE fnd_api.g_exc_unexpected_error;
1702: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1703: RAISE fnd_api.g_exc_error;
1704: END IF;
1705: ELSE
1706: ozf_objfundsum_pvt.update_objfundsum(
1707: p_api_version => 1.0,

Line 1708: p_init_msg_list => Fnd_Api.G_FALSE,

1704: END IF;
1705: ELSE
1706: ozf_objfundsum_pvt.update_objfundsum(
1707: p_api_version => 1.0,
1708: p_init_msg_list => Fnd_Api.G_FALSE,
1709: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
1710: p_objfundsum_rec => l_objfundsum_rec,
1711: x_return_status => l_return_status,
1712: x_msg_count => x_msg_count,

Line 1709: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,

1705: ELSE
1706: ozf_objfundsum_pvt.update_objfundsum(
1707: p_api_version => 1.0,
1708: p_init_msg_list => Fnd_Api.G_FALSE,
1709: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
1710: p_objfundsum_rec => l_objfundsum_rec,
1711: x_return_status => l_return_status,
1712: x_msg_count => x_msg_count,
1713: x_msg_data => x_msg_data

Line 1715: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1711: x_return_status => l_return_status,
1712: x_msg_count => x_msg_count,
1713: x_msg_data => x_msg_data
1714: );
1715: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1716: RAISE fnd_api.g_exc_unexpected_error;
1717: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1718: RAISE fnd_api.g_exc_error;
1719: END IF;

Line 1716: RAISE fnd_api.g_exc_unexpected_error;

1712: x_msg_count => x_msg_count,
1713: x_msg_data => x_msg_data
1714: );
1715: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1716: RAISE fnd_api.g_exc_unexpected_error;
1717: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1718: RAISE fnd_api.g_exc_error;
1719: END IF;
1720: END IF;

Line 1717: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1713: x_msg_data => x_msg_data
1714: );
1715: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1716: RAISE fnd_api.g_exc_unexpected_error;
1717: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1718: RAISE fnd_api.g_exc_error;
1719: END IF;
1720: END IF;
1721: -- rimehrot: end changes for R12

Line 1718: RAISE fnd_api.g_exc_error;

1714: );
1715: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1716: RAISE fnd_api.g_exc_unexpected_error;
1717: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1718: RAISE fnd_api.g_exc_error;
1719: END IF;
1720: END IF;
1721: -- rimehrot: end changes for R12
1722:

Line 1747: p_encoded=> fnd_api.g_false

1743:
1744: fnd_msg_pub.count_and_get (
1745: p_count=> x_msg_count,
1746: p_data=> x_msg_data,
1747: p_encoded=> fnd_api.g_false
1748: );
1749:
1750: EXCEPTION
1751: WHEN fnd_api.g_exc_error THEN

Line 1751: WHEN fnd_api.g_exc_error THEN

1747: p_encoded=> fnd_api.g_false
1748: );
1749:
1750: EXCEPTION
1751: WHEN fnd_api.g_exc_error THEN
1752: ROLLBACK TO create_utilized_rec;
1753: x_return_status := fnd_api.g_ret_sts_error;
1754: fnd_msg_pub.count_and_get (
1755: p_count=> x_msg_count,

Line 1753: x_return_status := fnd_api.g_ret_sts_error;

1749:
1750: EXCEPTION
1751: WHEN fnd_api.g_exc_error THEN
1752: ROLLBACK TO create_utilized_rec;
1753: x_return_status := fnd_api.g_ret_sts_error;
1754: fnd_msg_pub.count_and_get (
1755: p_count=> x_msg_count,
1756: p_data=> x_msg_data,
1757: p_encoded=> fnd_api.g_false

Line 1757: p_encoded=> fnd_api.g_false

1753: x_return_status := fnd_api.g_ret_sts_error;
1754: fnd_msg_pub.count_and_get (
1755: p_count=> x_msg_count,
1756: p_data=> x_msg_data,
1757: p_encoded=> fnd_api.g_false
1758: );
1759:
1760: WHEN fnd_api.g_exc_unexpected_error THEN
1761: ROLLBACK TO create_utilized_rec;

Line 1760: WHEN fnd_api.g_exc_unexpected_error THEN

1756: p_data=> x_msg_data,
1757: p_encoded=> fnd_api.g_false
1758: );
1759:
1760: WHEN fnd_api.g_exc_unexpected_error THEN
1761: ROLLBACK TO create_utilized_rec;
1762: x_return_status := fnd_api.g_ret_sts_unexp_error;
1763: fnd_msg_pub.count_and_get (
1764: p_count=> x_msg_count,

Line 1762: x_return_status := fnd_api.g_ret_sts_unexp_error;

1758: );
1759:
1760: WHEN fnd_api.g_exc_unexpected_error THEN
1761: ROLLBACK TO create_utilized_rec;
1762: x_return_status := fnd_api.g_ret_sts_unexp_error;
1763: fnd_msg_pub.count_and_get (
1764: p_count=> x_msg_count,
1765: p_data=> x_msg_data,
1766: p_encoded=> fnd_api.g_false

Line 1766: p_encoded=> fnd_api.g_false

1762: x_return_status := fnd_api.g_ret_sts_unexp_error;
1763: fnd_msg_pub.count_and_get (
1764: p_count=> x_msg_count,
1765: p_data=> x_msg_data,
1766: p_encoded=> fnd_api.g_false
1767: );
1768:
1769: WHEN OTHERS THEN
1770: ROLLBACK TO create_utilized_rec;

Line 1771: x_return_status := fnd_api.g_ret_sts_unexp_error;

1767: );
1768:
1769: WHEN OTHERS THEN
1770: ROLLBACK TO create_utilized_rec;
1771: x_return_status := fnd_api.g_ret_sts_unexp_error;
1772: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1773: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1774: END IF;
1775: fnd_msg_pub.count_and_get (

Line 1778: p_encoded=> fnd_api.g_false

1774: END IF;
1775: fnd_msg_pub.count_and_get (
1776: p_count=> x_msg_count,
1777: p_data=> x_msg_data,
1778: p_encoded=> fnd_api.g_false
1779: );
1780:
1781:
1782: END create_utilized_rec;

Line 1837: x_return_status := fnd_api.g_ret_sts_success;

1833: WHERE header_id = p_order_header_id;
1834:
1835: BEGIN
1836: SAVEPOINT create_fund_utilization_acr;
1837: x_return_status := fnd_api.g_ret_sts_success;
1838: IF g_debug_flag = 'Y' THEN
1839: ozf_utility_pvt.write_conc_log (' D: Enter create_fund_utilization() ');
1840: END IF;
1841: l_act_util_rec.product_level_type := 'PRODUCT';

Line 1886: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1882: ,p_ledger_id => l_ledger_id -- yzhao: added for R12
1883: ,p_org_id =>l_act_util_rec.org_id -- nirprasa added to get conversion type for bug 7030415
1884: );
1885:
1886: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1887: ozf_utility_pvt.write_conc_log (': create Act Budgets Failed '||x_return_status);
1888: IF x_return_status = fnd_api.g_ret_sts_error THEN
1889: RAISE fnd_api.g_exc_error;
1890: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1888: IF x_return_status = fnd_api.g_ret_sts_error THEN

1884: );
1885:
1886: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1887: ozf_utility_pvt.write_conc_log (': create Act Budgets Failed '||x_return_status);
1888: IF x_return_status = fnd_api.g_ret_sts_error THEN
1889: RAISE fnd_api.g_exc_error;
1890: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;

Line 1889: RAISE fnd_api.g_exc_error;

1885:
1886: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1887: ozf_utility_pvt.write_conc_log (': create Act Budgets Failed '||x_return_status);
1888: IF x_return_status = fnd_api.g_ret_sts_error THEN
1889: RAISE fnd_api.g_exc_error;
1890: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893: END IF;

Line 1890: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1886: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1887: ozf_utility_pvt.write_conc_log (': create Act Budgets Failed '||x_return_status);
1888: IF x_return_status = fnd_api.g_ret_sts_error THEN
1889: RAISE fnd_api.g_exc_error;
1890: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893: END IF;
1894:

Line 1891: RAISE fnd_api.g_exc_unexpected_error;

1887: ozf_utility_pvt.write_conc_log (': create Act Budgets Failed '||x_return_status);
1888: IF x_return_status = fnd_api.g_ret_sts_error THEN
1889: RAISE fnd_api.g_exc_error;
1890: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893: END IF;
1894:
1895: l_act_util_rec.ams_activity_budget_id := l_activity_id;

Line 1906: IF x_return_status <>fnd_api.g_ret_sts_success THEN

1902: );
1903:
1904: x_utilization_id := l_utilization_id;
1905:
1906: IF x_return_status <>fnd_api.g_ret_sts_success THEN
1907: ozf_utility_pvt.write_conc_log (': create utilization Failed '||x_return_status);
1908: IF x_return_status = fnd_api.g_ret_sts_error THEN
1909: RAISE fnd_api.g_exc_error;
1910: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1908: IF x_return_status = fnd_api.g_ret_sts_error THEN

1904: x_utilization_id := l_utilization_id;
1905:
1906: IF x_return_status <>fnd_api.g_ret_sts_success THEN
1907: ozf_utility_pvt.write_conc_log (': create utilization Failed '||x_return_status);
1908: IF x_return_status = fnd_api.g_ret_sts_error THEN
1909: RAISE fnd_api.g_exc_error;
1910: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;

Line 1909: RAISE fnd_api.g_exc_error;

1905:
1906: IF x_return_status <>fnd_api.g_ret_sts_success THEN
1907: ozf_utility_pvt.write_conc_log (': create utilization Failed '||x_return_status);
1908: IF x_return_status = fnd_api.g_ret_sts_error THEN
1909: RAISE fnd_api.g_exc_error;
1910: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;
1913: END IF;

Line 1910: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1906: IF x_return_status <>fnd_api.g_ret_sts_success THEN
1907: ozf_utility_pvt.write_conc_log (': create utilization Failed '||x_return_status);
1908: IF x_return_status = fnd_api.g_ret_sts_error THEN
1909: RAISE fnd_api.g_exc_error;
1910: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;
1913: END IF;
1914:

Line 1911: RAISE fnd_api.g_exc_unexpected_error;

1907: ozf_utility_pvt.write_conc_log (': create utilization Failed '||x_return_status);
1908: IF x_return_status = fnd_api.g_ret_sts_error THEN
1909: RAISE fnd_api.g_exc_error;
1910: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;
1913: END IF;
1914:
1915: fnd_msg_pub.count_and_get (

Line 1918: p_encoded=> fnd_api.g_false

1914:
1915: fnd_msg_pub.count_and_get (
1916: p_count=> x_msg_count,
1917: p_data=>x_msg_data,
1918: p_encoded=> fnd_api.g_false
1919: );
1920: EXCEPTION
1921: WHEN fnd_api.g_exc_error THEN
1922: ROLLBACK TO create_fund_utilization_acr;

Line 1921: WHEN fnd_api.g_exc_error THEN

1917: p_data=>x_msg_data,
1918: p_encoded=> fnd_api.g_false
1919: );
1920: EXCEPTION
1921: WHEN fnd_api.g_exc_error THEN
1922: ROLLBACK TO create_fund_utilization_acr;
1923: x_return_status := fnd_api.g_ret_sts_error;
1924: fnd_msg_pub.count_and_get (
1925: p_count=> x_msg_count

Line 1923: x_return_status := fnd_api.g_ret_sts_error;

1919: );
1920: EXCEPTION
1921: WHEN fnd_api.g_exc_error THEN
1922: ROLLBACK TO create_fund_utilization_acr;
1923: x_return_status := fnd_api.g_ret_sts_error;
1924: fnd_msg_pub.count_and_get (
1925: p_count=> x_msg_count
1926: ,p_data=> x_msg_data
1927: ,p_encoded=> fnd_api.g_false

Line 1927: ,p_encoded=> fnd_api.g_false

1923: x_return_status := fnd_api.g_ret_sts_error;
1924: fnd_msg_pub.count_and_get (
1925: p_count=> x_msg_count
1926: ,p_data=> x_msg_data
1927: ,p_encoded=> fnd_api.g_false
1928: );
1929: WHEN fnd_api.g_exc_unexpected_error THEN
1930: ROLLBACK TO create_fund_utilization_acr;
1931: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1929: WHEN fnd_api.g_exc_unexpected_error THEN

1925: p_count=> x_msg_count
1926: ,p_data=> x_msg_data
1927: ,p_encoded=> fnd_api.g_false
1928: );
1929: WHEN fnd_api.g_exc_unexpected_error THEN
1930: ROLLBACK TO create_fund_utilization_acr;
1931: x_return_status := fnd_api.g_ret_sts_unexp_error;
1932: fnd_msg_pub.count_and_get (
1933: p_count=> x_msg_count

Line 1931: x_return_status := fnd_api.g_ret_sts_unexp_error;

1927: ,p_encoded=> fnd_api.g_false
1928: );
1929: WHEN fnd_api.g_exc_unexpected_error THEN
1930: ROLLBACK TO create_fund_utilization_acr;
1931: x_return_status := fnd_api.g_ret_sts_unexp_error;
1932: fnd_msg_pub.count_and_get (
1933: p_count=> x_msg_count
1934: ,p_data=> x_msg_data
1935: ,p_encoded=> fnd_api.g_false

Line 1935: ,p_encoded=> fnd_api.g_false

1931: x_return_status := fnd_api.g_ret_sts_unexp_error;
1932: fnd_msg_pub.count_and_get (
1933: p_count=> x_msg_count
1934: ,p_data=> x_msg_data
1935: ,p_encoded=> fnd_api.g_false
1936: );
1937: WHEN OTHERS THEN
1938: ROLLBACK TO create_fund_utilization_acr;
1939: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1939: x_return_status := fnd_api.g_ret_sts_unexp_error;

1935: ,p_encoded=> fnd_api.g_false
1936: );
1937: WHEN OTHERS THEN
1938: ROLLBACK TO create_fund_utilization_acr;
1939: x_return_status := fnd_api.g_ret_sts_unexp_error;
1940:
1941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1943: END IF;

Line 1948: ,p_encoded=> fnd_api.g_false

1944:
1945: fnd_msg_pub.count_and_get (
1946: p_count=> x_msg_count
1947: ,p_data=> x_msg_data
1948: ,p_encoded=> fnd_api.g_false
1949: );
1950: END create_fund_utilization;
1951:
1952: /*----------------------------------------------------------------------------

Line 1987: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR ;

1983: l_ship_to_site_use_id NUMBER;
1984: l_utilization_id NUMBER;
1985:
1986: l_order_org_id NUMBER;
1987: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR ;
1988:
1989: -- Added by rimehrot for R12
1990: CURSOR c_get_price_adj_dtl (p_price_adjustment_id IN NUMBER) IS
1991: SELECT creation_date

Line 2035: x_return_status := fnd_api.g_ret_sts_success;

2031: l_offer_type c_offer_type%ROWTYPE;
2032:
2033:
2034: BEGIN
2035: x_return_status := fnd_api.g_ret_sts_success;
2036:
2037: IF g_debug_flag = 'Y' THEN
2038: ozf_utility_pvt.write_conc_log(' D: Enter post_accrual_to_budget p_adj_amt_tbl count=' || p_adj_amt_tbl.count);
2039: END IF;

Line 2069: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2065: IF g_debug_flag = 'Y' THEN
2066: ozf_utility_pvt.write_conc_log (' D: post_adjust_to_budget(): Calculate Accrual Amount returns' || l_return_status);
2067: END IF;
2068:
2069: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2073: RAISE fnd_api.g_exc_unexpected_error;

Line 2070: IF l_return_status = fnd_api.g_ret_sts_error THEN

2066: ozf_utility_pvt.write_conc_log (' D: post_adjust_to_budget(): Calculate Accrual Amount returns' || l_return_status);
2067: END IF;
2068:
2069: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF;

Line 2071: RAISE fnd_api.g_exc_error;

2067: END IF;
2068:
2069: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF;
2075: END IF;

Line 2072: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2068:
2069: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF;
2075: END IF;
2076:

Line 2073: RAISE fnd_api.g_exc_unexpected_error;

2069: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF;
2075: END IF;
2076:
2077: --- if this is not funded by a parent campaign or any budget the error OUT NOCOPY saying no budgte found

Line 2177: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2173: ozf_utility_pvt.write_conc_log('Adjustment amount is converted from offer curr to budgets curr to populate parent_src_apprvd_amt column in izf_act_budgets table and amount column of ozf_funds_utilized_all_b table');
2174: ozf_utility_pvt.write_conc_log('***************************END******************************');
2175: END IF;
2176:
2177: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2178: IF g_debug_flag = 'Y' THEN
2179: ozf_utility_pvt.write_conc_log (' D: post_adjust_to_budget() convert currency failed. No posting to budget. Return');
2180: END IF;
2181: RAISE fnd_api.g_exc_unexpected_error;

Line 2181: RAISE fnd_api.g_exc_unexpected_error;

2177: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2178: IF g_debug_flag = 'Y' THEN
2179: ozf_utility_pvt.write_conc_log (' D: post_adjust_to_budget() convert currency failed. No posting to budget. Return');
2180: END IF;
2181: RAISE fnd_api.g_exc_unexpected_error;
2182: END IF;
2183: l_act_budgets_rec.parent_src_apprvd_amt :=l_converted_adj_amount;
2184: END IF;
2185:

Line 2229: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2225: x_return_status => l_return_status,
2226: x_msg_count => x_msg_count,
2227: x_msg_data => x_msg_data
2228: );
2229: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2230: IF g_debug_flag = 'Y' THEN
2231: ozf_utility_pvt.write_conc_log ('D: post_adjust_to_budget() create_fund_utilization() returns error. Exception');
2232: END IF;
2233: RAISE fnd_api.g_exc_unexpected_error;

Line 2233: RAISE fnd_api.g_exc_unexpected_error;

2229: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2230: IF g_debug_flag = 'Y' THEN
2231: ozf_utility_pvt.write_conc_log ('D: post_adjust_to_budget() create_fund_utilization() returns error. Exception');
2232: END IF;
2233: RAISE fnd_api.g_exc_unexpected_error;
2234: END IF;
2235:
2236: <>
2237:

Line 2260: x_return_status := fnd_api.g_ret_sts_success;

2256: IF g_debug_flag = 'Y' THEN
2257: ozf_utility_pvt.write_conc_log('D: Ends of post_accrual_to_budget');
2258: END IF;
2259:
2260: x_return_status := fnd_api.g_ret_sts_success;
2261:
2262: fnd_msg_pub.count_and_get (
2263: p_count=> x_msg_count,
2264: p_data=> x_msg_data,

Line 2265: p_encoded=> fnd_api.g_false

2261:
2262: fnd_msg_pub.count_and_get (
2263: p_count=> x_msg_count,
2264: p_data=> x_msg_data,
2265: p_encoded=> fnd_api.g_false
2266: );
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN

Line 2270: x_return_status := fnd_api.g_ret_sts_unexp_error;

2266: );
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: x_return_status := fnd_api.g_ret_sts_unexp_error;
2271: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2272: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2273: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2274: END IF;

Line 2278: p_encoded=> fnd_api.g_false

2274: END IF;
2275: fnd_msg_pub.count_and_get (
2276: p_count=> x_msg_count,
2277: p_data=> x_msg_data,
2278: p_encoded=> fnd_api.g_false
2279: );
2280: END post_accrual_to_budget;
2281:
2282: ------------------------------------------------------------------------------

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

2292: -- updated mpande 12/28/2001 -- added line and header info also
2293: ------------------------------------------------------------------------------
2294: PROCEDURE adjust_accrual (
2295: p_api_version IN NUMBER,
2296: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2297: p_commit IN VARCHAR2 := fnd_api.g_false,
2298: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2299: x_return_status OUT NOCOPY VARCHAR2,
2300: x_msg_count OUT NOCOPY NUMBER,

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

2293: ------------------------------------------------------------------------------
2294: PROCEDURE adjust_accrual (
2295: p_api_version IN NUMBER,
2296: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2297: p_commit IN VARCHAR2 := fnd_api.g_false,
2298: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2299: x_return_status OUT NOCOPY VARCHAR2,
2300: x_msg_count OUT NOCOPY NUMBER,
2301: x_msg_data OUT NOCOPY VARCHAR2,

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

2294: PROCEDURE adjust_accrual (
2295: p_api_version IN NUMBER,
2296: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2297: p_commit IN VARCHAR2 := fnd_api.g_false,
2298: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2299: x_return_status OUT NOCOPY VARCHAR2,
2300: x_msg_count OUT NOCOPY NUMBER,
2301: x_msg_data OUT NOCOPY VARCHAR2,
2302: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,

Line 2305: p_exception_queue IN VARCHAR2 := fnd_api.g_false

2301: x_msg_data OUT NOCOPY VARCHAR2,
2302: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2303: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2304: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2305: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2306:
2307: ) IS
2308: l_return_status VARCHAR2 (10) := fnd_api.g_ret_sts_success;
2309: l_api_name CONSTANT VARCHAR2 (30) := 'Adjust_Accrual';

Line 2308: l_return_status VARCHAR2 (10) := fnd_api.g_ret_sts_success;

2304: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2305: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2306:
2307: ) IS
2308: l_return_status VARCHAR2 (10) := fnd_api.g_ret_sts_success;
2309: l_api_name CONSTANT VARCHAR2 (30) := 'Adjust_Accrual';
2310: l_api_version CONSTANT NUMBER := 1.0;
2311: l_earned_amount NUMBER;
2312: l_old_earned_amount NUMBER;

Line 2348: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

2344: l_util_exists NUMBER;
2345: l_new_line_id NUMBER;
2346:
2347: l_order_org_id NUMBER;
2348: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
2349:
2350: CURSOR c_line_info (p_line_id IN NUMBER) IS
2351: SELECT line.inventory_item_id,
2352: line.ordered_quantity,

Line 2432: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

2428:
2429: BEGIN
2430: SAVEPOINT adjust_accrual;
2431: -- Standard call to check for call compatibility.
2432: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2433: RAISE fnd_api.g_exc_unexpected_error;
2434: END IF;
2435: -- Initialize message list IF p_init_msg_list is set to TRUE.
2436: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2433: RAISE fnd_api.g_exc_unexpected_error;

2429: BEGIN
2430: SAVEPOINT adjust_accrual;
2431: -- Standard call to check for call compatibility.
2432: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2433: RAISE fnd_api.g_exc_unexpected_error;
2434: END IF;
2435: -- Initialize message list IF p_init_msg_list is set to TRUE.
2436: IF fnd_api.to_boolean (p_init_msg_list) THEN
2437: fnd_msg_pub.initialize;

Line 2436: IF fnd_api.to_boolean (p_init_msg_list) THEN

2432: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2433: RAISE fnd_api.g_exc_unexpected_error;
2434: END IF;
2435: -- Initialize message list IF p_init_msg_list is set to TRUE.
2436: IF fnd_api.to_boolean (p_init_msg_list) THEN
2437: fnd_msg_pub.initialize;
2438: END IF;
2439: -- Initialize API return status to success
2440: x_return_status := fnd_api.g_ret_sts_success;

Line 2440: x_return_status := fnd_api.g_ret_sts_success;

2436: IF fnd_api.to_boolean (p_init_msg_list) THEN
2437: fnd_msg_pub.initialize;
2438: END IF;
2439: -- Initialize API return status to success
2440: x_return_status := fnd_api.g_ret_sts_success;
2441:
2442: <>
2443:
2444: IF g_debug_flag = 'Y' THEN

Line 2452: x_return_status := fnd_api.g_ret_sts_success;

2448: l_adj_amt_tbl.DELETE;
2449:
2450: FOR i IN NVL (p_line_adj_tbl.FIRST, 1) .. NVL (p_line_adj_tbl.LAST, 0)
2451: LOOP
2452: x_return_status := fnd_api.g_ret_sts_success;
2453: SAVEPOINT line_adjustment;
2454:
2455: IF g_debug_flag = 'Y' THEN
2456: ozf_utility_pvt.write_conc_log (' /++++++++ ADJUSTMENT DEBUG MESSAGE START +++++++++/' );

Line 2503: IF p_exception_queue = fnd_api.g_true AND p_line_adj_tbl (i).operation = 'CREATE' THEN

2499: OPEN c_get_conversion_type(l_order_org_id);
2500: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2501: CLOSE c_get_conversion_type;
2502:
2503: IF p_exception_queue = fnd_api.g_true AND p_line_adj_tbl (i).operation = 'CREATE' THEN
2504: l_operation := 'UPDATE' ;
2505: ELSE
2506: l_operation := p_line_adj_tbl (i).operation;
2507: END IF;

Line 2608: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2604: ozf_utility_pvt.write_conc_log('***************************END******************************');
2605: ozf_utility_pvt.write_conc_log('x_return_status: ' || x_return_status);
2606: END IF;
2607:
2608: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2609: GOTO l_endoflineadjloop;
2610: END IF;
2611:
2612: l_earned_amount := l_conv_earned_amount;

Line 2670: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2666: );
2667:
2668: ozf_utility_pvt.write_conc_log('x_return_status: ' || x_return_status);
2669:
2670: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2671: GOTO l_endoflineadjloop;
2672: END IF;
2673:
2674: l_new_adjustment_amount := l_conv_adjustment_amount;

Line 2752: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2748: 'create utlization from cancelled order returns '|| l_return_status
2749: );
2750: END IF;
2751:
2752: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2753: GOTO l_endoflineadjloop;
2754: END IF;
2755:
2756: -- If gl_posted_flag of original accrual has been posted, call post_accrual_to_gl

Line 2836: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2832: l_adj_amt_tbl (l_count).offer_currency:= l_offer_curr;
2833: END IF;
2834: <>
2835:
2836: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2837: IF g_debug_flag = 'Y' THEN
2838: ozf_utility_pvt.write_conc_log (
2839: ' /****** Adjustment Failure *******/ Offer Id: "'|| p_line_adj_tbl(i).list_header_id ||'"' || 'Price Adjustment Id'||p_line_adj_tbl (i).price_adjustment_id);
2840: END IF;

Line 2843: x_return_status := fnd_api.g_ret_sts_error ;

2839: ' /****** Adjustment Failure *******/ Offer Id: "'|| p_line_adj_tbl(i).list_header_id ||'"' || 'Price Adjustment Id'||p_line_adj_tbl (i).price_adjustment_id);
2840: END IF;
2841: -- Initialize the Message list for Next Processing
2842: ROLLBACK TO line_adjustment;
2843: x_return_status := fnd_api.g_ret_sts_error ;
2844: EXIT;
2845: ELSE
2846: IF g_debug_flag = 'Y' THEN
2847: ozf_utility_pvt.write_conc_log(

Line 2871: p_encoded=> fnd_api.g_false

2867: x_return_status := l_return_status;
2868: fnd_msg_pub.count_and_get (
2869: p_count=> x_msg_count,
2870: p_data=> x_msg_data,
2871: p_encoded=> fnd_api.g_false
2872: );
2873:
2874: EXCEPTION
2875: WHEN OTHERS THEN

Line 2877: x_return_status := fnd_api.g_ret_sts_unexp_error;

2873:
2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: --ROLLBACK TO adjust_accrual;
2877: x_return_status := fnd_api.g_ret_sts_unexp_error;
2878: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
2879: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2880: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2881: END IF;

Line 2885: p_encoded=> fnd_api.g_false

2881: END IF;
2882: fnd_msg_pub.count_and_get (
2883: p_count=> x_msg_count,
2884: p_data=> x_msg_data,
2885: p_encoded=> fnd_api.g_false
2886: );
2887: END adjust_accrual;
2888:
2889: ------------------------------------------------------------------------------

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

2897: -- modified yzhao 03/19/2003 added posting to GL for shipped order lines
2898: ------------------------------------------------------------------------------
2899: PROCEDURE adjust_changed_order (
2900: p_api_version IN NUMBER,
2901: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2902: p_commit IN VARCHAR2 := fnd_api.g_false,
2903: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2904: x_return_status OUT NOCOPY VARCHAR2,
2905: x_msg_count OUT NOCOPY NUMBER,

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

2898: ------------------------------------------------------------------------------
2899: PROCEDURE adjust_changed_order (
2900: p_api_version IN NUMBER,
2901: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2902: p_commit IN VARCHAR2 := fnd_api.g_false,
2903: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2904: x_return_status OUT NOCOPY VARCHAR2,
2905: x_msg_count OUT NOCOPY NUMBER,
2906: x_msg_data OUT NOCOPY VARCHAR2,

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

2899: PROCEDURE adjust_changed_order (
2900: p_api_version IN NUMBER,
2901: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2902: p_commit IN VARCHAR2 := fnd_api.g_false,
2903: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2904: x_return_status OUT NOCOPY VARCHAR2,
2905: x_msg_count OUT NOCOPY NUMBER,
2906: x_msg_data OUT NOCOPY VARCHAR2,
2907: p_header_rec IN oe_order_pub.header_rec_type,

Line 3224: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

3220:
3221: BEGIN
3222: SAVEPOINT adjust_changed_order;
3223: -- Standard call to check for call compatibility.
3224: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3225: RAISE fnd_api.g_exc_unexpected_error;
3226: END IF;
3227: -- Initialize message list IF p_init_msg_list is set to TRUE.
3228: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 3225: RAISE fnd_api.g_exc_unexpected_error;

3221: BEGIN
3222: SAVEPOINT adjust_changed_order;
3223: -- Standard call to check for call compatibility.
3224: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3225: RAISE fnd_api.g_exc_unexpected_error;
3226: END IF;
3227: -- Initialize message list IF p_init_msg_list is set to TRUE.
3228: IF fnd_api.to_boolean (p_init_msg_list) THEN
3229: fnd_msg_pub.initialize;

Line 3228: IF fnd_api.to_boolean (p_init_msg_list) THEN

3224: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3225: RAISE fnd_api.g_exc_unexpected_error;
3226: END IF;
3227: -- Initialize message list IF p_init_msg_list is set to TRUE.
3228: IF fnd_api.to_boolean (p_init_msg_list) THEN
3229: fnd_msg_pub.initialize;
3230: END IF;
3231: -- Initialize API return status to success
3232: x_return_status := fnd_api.g_ret_sts_success;

Line 3232: x_return_status := fnd_api.g_ret_sts_success;

3228: IF fnd_api.to_boolean (p_init_msg_list) THEN
3229: fnd_msg_pub.initialize;
3230: END IF;
3231: -- Initialize API return status to success
3232: x_return_status := fnd_api.g_ret_sts_success;
3233: <>
3234:
3235: IF g_debug_flag = 'Y' THEN
3236: ozf_utility_pvt.write_conc_log (

Line 3329: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3325: ozf_utility_pvt.write_conc_log (
3326: ' D: create utlization from cancelled order returns '|| l_return_status);
3327: END IF;
3328:
3329: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3330: GOTO l_endoflineadjloop;
3331: END IF;
3332: --- quit when the total earned amount is adjusted
3333: <>

Line 3411: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3407: ozf_utility_pvt.write_conc_log (
3408: ' D: create utlization from RMA order: ' || l_return_status);
3409: END IF;
3410:
3411: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3412: GOTO l_endoflineadjloop;
3413: END IF;
3414: --- quit when the total earned amount is adjusted
3415: <>

Line 3583: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3579: ozf_utility_pvt.write_conc_log (' retrun status for create _fund_utilization of '|| l_return_status ||
3580: ' when partial shipping. ' );
3581: END IF;
3582:
3583: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3584: GOTO l_endoflineadjloop;
3585: END IF;
3586: /* yzhao: fix bug 3778200 - partial shipment after offer adjustment.
3587: if line is splitted to have new line for unshipped quantity, new price adjustment need to pass to the offer adjustment

Line 3629: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3625: x_msg_count=> x_msg_count,
3626: x_msg_data=> x_msg_data
3627: );
3628:
3629: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3630: GOTO l_endoflineadjloop;
3631: END IF;
3632:
3633: END IF;-- end loop of old_adjustment_rec.utilization_type

Line 3750: ,p_init_msg_list => FND_API.G_FALSE

3746: END IF;
3747:
3748: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction (
3749: p_api_version => 1.0
3750: ,p_init_msg_list => FND_API.G_FALSE
3751: ,p_commit => FND_API.G_FALSE
3752: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3753: ,p_transaction_rec => l_sales_transaction_rec
3754: ,x_sales_transaction_id => l_sales_transaction_id

Line 3751: ,p_commit => FND_API.G_FALSE

3747:
3748: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction (
3749: p_api_version => 1.0
3750: ,p_init_msg_list => FND_API.G_FALSE
3751: ,p_commit => FND_API.G_FALSE
3752: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3753: ,p_transaction_rec => l_sales_transaction_rec
3754: ,x_sales_transaction_id => l_sales_transaction_id
3755: ,x_return_status => l_return_status

Line 3752: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3748: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction (
3749: p_api_version => 1.0
3750: ,p_init_msg_list => FND_API.G_FALSE
3751: ,p_commit => FND_API.G_FALSE
3752: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3753: ,p_transaction_rec => l_sales_transaction_rec
3754: ,x_sales_transaction_id => l_sales_transaction_id
3755: ,x_return_status => l_return_status
3756: ,x_msg_data => x_msg_data

Line 3764: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3760: IF g_debug_flag = 'Y' THEN
3761: ozf_utility_pvt.write_conc_log(' Create_Transaction' || l_return_status);
3762: END IF;
3763:
3764: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3765: GOTO l_endoflineadjloop;
3766: END IF;
3767: END IF; -- NVL(l_sales_trans,0)
3768:

Line 3806: IF l_return_status = fnd_api.g_ret_sts_success AND l_gl_posted_flag = G_GL_FLAG_YES THEN

3802: || ' post_accrual_to_gl(util_id=' || l_utilIdTbl(t_i) || ') returns ' || l_return_status
3803: || ' x_gl_posted_flag=' || l_gl_posted_flag);
3804: END IF;
3805: -- yzhao: 03/04/2004 post gl for related accruals from offer adjustment or object reconcile
3806: IF l_return_status = fnd_api.g_ret_sts_success AND l_gl_posted_flag = G_GL_FLAG_YES THEN
3807: post_related_accrual_to_gl(
3808: p_utilization_id => l_utilIdTbl(t_i)
3809: , p_utilization_type => l_utilTypeTbl(t_i)
3810: , p_gl_date => l_gl_date

Line 3825: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3821:
3822: END IF; -- IF l_gl_date IS NOT NULL
3823:
3824: <>
3825: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3826: -- Write Relelvant Messages
3827: IF g_debug_flag = 'Y' THEN
3828: ozf_utility_pvt.write_conc_log (
3829: ' /*************************** DEBUG MESSAGE END *************************/' ||

Line 3839: x_return_status := fnd_api.g_ret_sts_error ;

3835: -- Initialize the Message list for NExt Processing
3836: fnd_msg_pub.initialize;
3837: ROLLBACK TO line_adjustment;
3838: -- return a status error
3839: x_return_status := fnd_api.g_ret_sts_error ;
3840: --5/30/2002 Added to exit the loop because we want to perform handle exception to put the me
3841: -- go out of the loop because we put this message in the exception queue
3842: EXIT;
3843: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN

Line 3843: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN

3839: x_return_status := fnd_api.g_ret_sts_error ;
3840: --5/30/2002 Added to exit the loop because we want to perform handle exception to put the me
3841: -- go out of the loop because we put this message in the exception queue
3842: EXIT;
3843: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN
3844: IF g_debug_flag = 'Y' THEN
3845: ozf_utility_pvt.write_conc_log (' /*************************** DEBUG MESSAGE END *********************/'||
3846: ' /****** Line Adjustment Success *******/ p_line_tbl(i).line_id ' || p_line_tbl(i).line_id );
3847: END IF;

Line 3861: p_encoded=> fnd_api.g_false

3857: -- Standard call to get message count and IF count is 1, get message info.
3858: fnd_msg_pub.count_and_get (
3859: p_count=> x_msg_count,
3860: p_data=> x_msg_data,
3861: p_encoded=> fnd_api.g_false
3862: );
3863: EXCEPTION
3864: WHEN OTHERS THEN
3865: --ROLLBACK TO adjust_accrual;

Line 3866: x_return_status := fnd_api.g_ret_sts_unexp_error;

3862: );
3863: EXCEPTION
3864: WHEN OTHERS THEN
3865: --ROLLBACK TO adjust_accrual;
3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION*************/');
3868: ozf_utility_pvt.write_conc_log(' D: adjust_changed_order: exception. errcode=' || sqlcode || ' msg: ' || substr(sqlerrm, 1, 3000));
3869:
3870: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3876: p_encoded=> fnd_api.g_false

3872: END IF;
3873: fnd_msg_pub.count_and_get (
3874: p_count=> x_msg_count,
3875: p_data=> x_msg_data,
3876: p_encoded=> fnd_api.g_false
3877: );
3878: END adjust_changed_order;
3879:
3880: ------------------------------------------------------------------------------

Line 4006: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

4002: );
4003: --
4004: --///added by mpande to write a error message to the list
4005: --if not sucess add a error message to th emessage listx
4006: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4007: ozf_utility_pvt.write_conc_log ('Queue Return Error ');
4008:
4009: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4010: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');

Line 4019: IF l_return_status = fnd_api.g_ret_sts_success THEN

4015: END IF;
4016: -- Check return status
4017: -- if success call adjust_accrual
4018: --
4019: IF l_return_status = fnd_api.g_ret_sts_success THEN
4020: IF (l_line_adj_tbl.COUNT <> 0) THEN
4021: IF g_debug_flag = 'Y' THEN
4022: ozf_utility_pvt.write_conc_log ('ADJUSTMENT ');
4023: END IF;

Line 4027: ,p_init_msg_list=> fnd_api.g_true

4023: END IF;
4024:
4025: adjust_accrual (
4026: p_api_version=> 1.0
4027: ,p_init_msg_list=> fnd_api.g_true
4028: ,x_return_status=> l_return_status
4029: ,x_msg_count=> l_msg_count
4030: ,x_msg_data=> l_msg_data
4031: ,p_line_adj_tbl=> l_line_adj_tbl

Line 4040: --l_return_status := fnd_api.g_ret_sts_success;

4036: ozf_utility_pvt.write_conc_log ( 'ADJUSTMENT STATUS ' || l_return_status);
4037: END IF;
4038: END IF;
4039: END IF;
4040: --l_return_status := fnd_api.g_ret_sts_success;
4041: IF l_return_status = fnd_api.g_ret_sts_success THEN
4042: IF (l_line_tbl.COUNT <> 0) THEN
4043: IF g_debug_flag = 'Y' THEN
4044: ozf_utility_pvt.write_conc_log ('LINE');

Line 4041: IF l_return_status = fnd_api.g_ret_sts_success THEN

4037: END IF;
4038: END IF;
4039: END IF;
4040: --l_return_status := fnd_api.g_ret_sts_success;
4041: IF l_return_status = fnd_api.g_ret_sts_success THEN
4042: IF (l_line_tbl.COUNT <> 0) THEN
4043: IF g_debug_flag = 'Y' THEN
4044: ozf_utility_pvt.write_conc_log ('LINE');
4045: END IF;

Line 4048: ,p_init_msg_list=> fnd_api.g_true

4044: ozf_utility_pvt.write_conc_log ('LINE');
4045: END IF;
4046: adjust_changed_order (
4047: p_api_version=> 1.0
4048: ,p_init_msg_list=> fnd_api.g_true
4049: ,x_return_status=> l_return_status
4050: ,x_msg_count=> l_msg_count
4051: ,x_msg_data=> l_msg_data
4052: ,p_header_rec=> l_header_rec

Line 4073: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

4069: -- Check return status of functional process,
4070: -- rollback to undo processing
4071: -- if not success write the error message to the log file
4072:
4073: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4074: --fnd_file.put_line(--fnd_file.log, 'before writinf concurrenct log '||l_return_status);
4075: ozf_utility_pvt.write_conc_log ('D: Error in one of the process');
4076:
4077: ROLLBACK TO get_message_loop_savepoint;

Line 4082: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

4078: x_retcode := 1;
4079: x_errbuf := l_msg_data;
4080: END IF;
4081:
4082: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4083: /*Enqueue the failed message into the Order Feedback Exception Queue. This data
4084: can be dequeued subsequently by using the GET_EXCEPTION API */
4085: IF g_debug_flag = 'Y' THEN
4086: ozf_utility_pvt.write_conc_log ('In handle queue exception ');

Line 4090: p_init_msg_list=> fnd_api.g_false,

4086: ozf_utility_pvt.write_conc_log ('In handle queue exception ');
4087: END IF;
4088: aso_order_feedback_pub.handle_exception (
4089: p_api_version=> 1.0,
4090: p_init_msg_list=> fnd_api.g_false,
4091: p_commit=> fnd_api.g_false,
4092: x_return_status=> l_return_status,
4093: x_msg_count=> l_msg_count,
4094: x_msg_data=> l_msg_data,

Line 4091: p_commit=> fnd_api.g_false,

4087: END IF;
4088: aso_order_feedback_pub.handle_exception (
4089: p_api_version=> 1.0,
4090: p_init_msg_list=> fnd_api.g_false,
4091: p_commit=> fnd_api.g_false,
4092: x_return_status=> l_return_status,
4093: x_msg_count=> l_msg_count,
4094: x_msg_data=> l_msg_data,
4095: p_app_short_name=> 'OZF',

Line 4128: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;

4124: END IF;
4125: -- Quit the procedure IF the queue is empty
4126: ozf_utility_pvt.write_conc_log (' /*************************** END OF QUEUE MESSAGE *************************/');
4127:
4128: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;
4129: EXIT WHEN l_no_more_messages = fnd_api.g_true;
4130: l_que_msg_count := l_que_msg_count + 1 ;
4131: IF l_return_status = fnd_api.g_ret_sts_success THEN
4132: COMMIT;

Line 4129: EXIT WHEN l_no_more_messages = fnd_api.g_true;

4125: -- Quit the procedure IF the queue is empty
4126: ozf_utility_pvt.write_conc_log (' /*************************** END OF QUEUE MESSAGE *************************/');
4127:
4128: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;
4129: EXIT WHEN l_no_more_messages = fnd_api.g_true;
4130: l_que_msg_count := l_que_msg_count + 1 ;
4131: IF l_return_status = fnd_api.g_ret_sts_success THEN
4132: COMMIT;
4133: x_retcode := 0;

Line 4131: IF l_return_status = fnd_api.g_ret_sts_success THEN

4127:
4128: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;
4129: EXIT WHEN l_no_more_messages = fnd_api.g_true;
4130: l_que_msg_count := l_que_msg_count + 1 ;
4131: IF l_return_status = fnd_api.g_ret_sts_success THEN
4132: COMMIT;
4133: x_retcode := 0;
4134: END IF;
4135: EXCEPTION

Line 4136: WHEN FND_API.G_EXC_ERROR THEN

4132: COMMIT;
4133: x_retcode := 0;
4134: END IF;
4135: EXCEPTION
4136: WHEN FND_API.G_EXC_ERROR THEN
4137: ROLLBACK TO get_message_loop_savepoint;
4138: ozf_utility_pvt.write_conc_log('FALIED');
4139: ozf_utility_pvt.write_conc_log;
4140:

Line 4141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4137: ROLLBACK TO get_message_loop_savepoint;
4138: ozf_utility_pvt.write_conc_log('FALIED');
4139: ozf_utility_pvt.write_conc_log;
4140:
4141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4142: ROLLBACK TO get_message_loop_savepoint;
4143: ozf_utility_pvt.write_conc_log('FALIED');
4144: ozf_utility_pvt.write_conc_log;
4145:

Line 4178: WHEN fnd_api.g_exc_error THEN

4174: END IF;
4175:
4176:
4177: EXCEPTION
4178: WHEN fnd_api.g_exc_error THEN
4179: ozf_utility_pvt.write_conc_log ('QUEUE PROCESSED ' ||to_char(l_que_msg_count) ||'MESSAGES' );
4180: x_retcode := 1;
4181: WHEN fnd_api.g_exc_unexpected_error THEN
4182: ozf_utility_pvt.write_conc_log ('QUEUE PROCESSED ' ||to_char(l_que_msg_count) || 'MESSAGES' );

Line 4181: WHEN fnd_api.g_exc_unexpected_error THEN

4177: EXCEPTION
4178: WHEN fnd_api.g_exc_error THEN
4179: ozf_utility_pvt.write_conc_log ('QUEUE PROCESSED ' ||to_char(l_que_msg_count) ||'MESSAGES' );
4180: x_retcode := 1;
4181: WHEN fnd_api.g_exc_unexpected_error THEN
4182: ozf_utility_pvt.write_conc_log ('QUEUE PROCESSED ' ||to_char(l_que_msg_count) || 'MESSAGES' );
4183: x_retcode := 1;
4184: WHEN OTHERS THEN
4185: ozf_utility_pvt.write_conc_log ('QUEUE PROCESSED '|| to_char(l_que_msg_count) ||'MESSAGES' );

Line 4298: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

4294: --
4295: --ozf_utility_pvt.debug_message('l_return_status ='||l_return_status );
4296: --///added by mpande to write a error message to the list
4297: --if not sucess add a error message to th emessage list
4298: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4300: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
4301: fnd_msg_pub.ADD;
4302: END IF;

Line 4309: IF l_return_status = fnd_api.g_ret_sts_success THEN

4305: END IF;
4306: -- Check return status
4307: -- if success call adjust_accrual
4308: --
4309: IF l_return_status = fnd_api.g_ret_sts_success THEN
4310: IF (l_line_adj_tbl.COUNT <> 0) THEN
4311: ozf_utility_pvt.write_conc_log ('In get exception adjustment');
4312:
4313: adjust_accrual (

Line 4315: p_init_msg_list=> fnd_api.g_true,

4311: ozf_utility_pvt.write_conc_log ('In get exception adjustment');
4312:
4313: adjust_accrual (
4314: p_api_version=> 1.0,
4315: p_init_msg_list=> fnd_api.g_true,
4316: x_return_status=> l_return_status,
4317: x_msg_count=> l_msg_count,
4318: x_msg_data=> l_msg_data,
4319: p_line_adj_tbl=> l_line_adj_tbl,

Line 4322: p_exception_queue => fnd_api.g_true

4318: x_msg_data=> l_msg_data,
4319: p_line_adj_tbl=> l_line_adj_tbl,
4320: p_old_line_adj_tbl=> l_old_line_adj_tbl,
4321: p_header_rec=> l_header_rec,
4322: p_exception_queue => fnd_api.g_true
4323: );
4324: ozf_utility_pvt.write_conc_log ('ADJUSTMENT EXCEPTION STATUS'||l_return_status);
4325:
4326: END IF;

Line 4328: IF l_return_status = fnd_api.g_ret_sts_success THEN

4324: ozf_utility_pvt.write_conc_log ('ADJUSTMENT EXCEPTION STATUS'||l_return_status);
4325:
4326: END IF;
4327: END IF;
4328: IF l_return_status = fnd_api.g_ret_sts_success THEN
4329: IF (l_line_tbl.COUNT <> 0) THEN
4330: ozf_utility_pvt.write_conc_log (' D: EXCEPTON QUEUE Start processing line');
4331:
4332: adjust_changed_order (

Line 4334: p_init_msg_list=> fnd_api.g_true,

4330: ozf_utility_pvt.write_conc_log (' D: EXCEPTON QUEUE Start processing line');
4331:
4332: adjust_changed_order (
4333: p_api_version=> 1.0,
4334: p_init_msg_list=> fnd_api.g_true,
4335: x_return_status=> l_return_status,
4336: x_msg_count=> l_msg_count,
4337: x_msg_data=> l_msg_data,
4338: p_header_rec=> l_header_rec,

Line 4357: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

4353: --
4354: -- Check return status of functional process,
4355: -- rollback to undo processing
4356: -- if not success write the error message to the log file
4357: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4358: l_navigation := DBMS_AQ.NEXT_MESSAGE;
4359: ROLLBACK TO get_excep_loop_savepoint;
4360: --x_retcode := 1;
4361: x_errbuf := l_msg_data;

Line 4364: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;

4360: --x_retcode := 1;
4361: x_errbuf := l_msg_data;
4362: END IF;
4363: -- Quit the procedure IF the queue is empty
4364: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;
4365: EXIT WHEN l_no_more_messages = fnd_api.g_true;
4366:
4367: IF l_return_status = fnd_api.g_ret_sts_success THEN
4368:

Line 4365: EXIT WHEN l_no_more_messages = fnd_api.g_true;

4361: x_errbuf := l_msg_data;
4362: END IF;
4363: -- Quit the procedure IF the queue is empty
4364: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;
4365: EXIT WHEN l_no_more_messages = fnd_api.g_true;
4366:
4367: IF l_return_status = fnd_api.g_ret_sts_success THEN
4368:
4369: aso_order_feedback_pub.get_exception (

Line 4367: IF l_return_status = fnd_api.g_ret_sts_success THEN

4363: -- Quit the procedure IF the queue is empty
4364: EXIT WHEN l_return_status = fnd_api.g_ret_sts_unexp_error;
4365: EXIT WHEN l_no_more_messages = fnd_api.g_true;
4366:
4367: IF l_return_status = fnd_api.g_ret_sts_success THEN
4368:
4369: aso_order_feedback_pub.get_exception (
4370: p_api_version=> 1.0,
4371: x_return_status=> l_return_status,

Line 4415: WHEN FND_API.G_EXC_ERROR THEN

4411: ozf_utility_pvt.write_conc_log;
4412: FND_MSG_PUB.INITIALIZE;
4413: END IF;
4414: EXCEPTION
4415: WHEN FND_API.G_EXC_ERROR THEN
4416: ROLLBACK TO get_excep_loop_savepoint;
4417: ozf_utility_pvt.write_conc_log('FALIED');
4418: ozf_utility_pvt.write_conc_log;
4419:

Line 4420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4416: ROLLBACK TO get_excep_loop_savepoint;
4417: ozf_utility_pvt.write_conc_log('FALIED');
4418: ozf_utility_pvt.write_conc_log;
4419:
4420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4421: ROLLBACK TO get_excep_loop_savepoint;
4422: ozf_utility_pvt.write_conc_log('FALIED');
4423: ozf_utility_pvt.write_conc_log;
4424:

Line 4437: WHEN fnd_api.g_exc_error THEN

4433: ozf_utility_pvt.write_conc_log;
4434: END;
4435: END LOOP exception_loop;
4436: EXCEPTION
4437: WHEN fnd_api.g_exc_error THEN
4438: x_retcode := 1;
4439: WHEN fnd_api.g_exc_unexpected_error THEN
4440: x_retcode := 1;
4441: WHEN OTHERS THEN

Line 4439: WHEN fnd_api.g_exc_unexpected_error THEN

4435: END LOOP exception_loop;
4436: EXCEPTION
4437: WHEN fnd_api.g_exc_error THEN
4438: x_retcode := 1;
4439: WHEN fnd_api.g_exc_unexpected_error THEN
4440: x_retcode := 1;
4441: WHEN OTHERS THEN
4442: x_retcode := 1;
4443: END get_exception_message;

Line 4598: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR; --nirprasa

4594: l_earned_amt NUMBER;
4595: l_rollup_earned_amt NUMBER;
4596: l_liability_flag VARCHAR2(1);
4597: l_accrual_basis VARCHAR2(30);
4598: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR; --nirprasa
4599:
4600: --nirprasa, added for bug 7030415.
4601: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
4602: SELECT exchange_rate_type

Line 4702: , p_init_msg_list => fnd_api.g_false

4698:
4699: IF l_gl_posted_flag = G_GL_FLAG_NO THEN
4700: OZF_GL_INTERFACE_PVT.Post_Accrual_To_GL (
4701: p_api_version => 1.0
4702: , p_init_msg_list => fnd_api.g_false
4703: , p_commit => fnd_api.g_false
4704: , p_validation_level => fnd_api.g_valid_level_full
4705:
4706: ,p_utilization_id => p_util_utilization_id

Line 4703: , p_commit => fnd_api.g_false

4699: IF l_gl_posted_flag = G_GL_FLAG_NO THEN
4700: OZF_GL_INTERFACE_PVT.Post_Accrual_To_GL (
4701: p_api_version => 1.0
4702: , p_init_msg_list => fnd_api.g_false
4703: , p_commit => fnd_api.g_false
4704: , p_validation_level => fnd_api.g_valid_level_full
4705:
4706: ,p_utilization_id => p_util_utilization_id
4707: ,p_utilization_type => l_event_type_code

Line 4704: , p_validation_level => fnd_api.g_valid_level_full

4700: OZF_GL_INTERFACE_PVT.Post_Accrual_To_GL (
4701: p_api_version => 1.0
4702: , p_init_msg_list => fnd_api.g_false
4703: , p_commit => fnd_api.g_false
4704: , p_validation_level => fnd_api.g_valid_level_full
4705:
4706: ,p_utilization_id => p_util_utilization_id
4707: ,p_utilization_type => l_event_type_code
4708: ,p_adjustment_type => l_adjustment_type

Line 4721: IF l_return_status = fnd_api.g_ret_sts_success THEN

4717: ozf_utility_pvt.write_conc_log (' D: post_accrual_to_gl() create_gl_entry for utilization id '
4718: || p_util_utilization_id || ' returns ' || l_return_status);
4719: END IF;
4720:
4721: IF l_return_status = fnd_api.g_ret_sts_success THEN
4722: l_gl_posted_flag := G_GL_FLAG_YES; -- 'Y';
4723: ELSE
4724: -- do not raise exception for gl posting error. Just mark it as failed and deal with it later
4725: l_gl_posted_flag := G_GL_FLAG_FAIL; -- 'F';

Line 4730: p_encoded => fnd_api.g_false

4726: -- 07/17/2003 yzhao: log error message
4727: fnd_msg_pub.count_and_get (
4728: p_count => x_msg_count,
4729: p_data => x_msg_data,
4730: p_encoded => fnd_api.g_false
4731: );
4732: ozf_utility_pvt.write_conc_log(' /****** Failed to post to GL ******/ for utilization id ' || p_util_utilization_id);
4733:
4734: ozf_utility_pvt.write_conc_log;

Line 4758: RAISE fnd_api.g_exc_error;

4754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4755: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
4756: fnd_msg_pub.add;
4757: END IF;
4758: RAISE fnd_api.g_exc_error;
4759: END IF;
4760:
4761: --Added for bug 7030415
4762: OPEN c_get_conversion_type(p_util_org_id);

Line 4789: IF l_return_status = fnd_api.g_ret_sts_error THEN

4785: ozf_utility_pvt.write_conc_log('Utilization amount is converted from fund curr to universal curr');
4786: ozf_utility_pvt.write_conc_log('***************************END******************************');
4787: END IF;
4788:
4789: IF l_return_status = fnd_api.g_ret_sts_error THEN
4790: RAISE fnd_api.g_exc_error;
4791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4792: RAISE fnd_api.g_exc_unexpected_error;
4793: END IF;

Line 4790: RAISE fnd_api.g_exc_error;

4786: ozf_utility_pvt.write_conc_log('***************************END******************************');
4787: END IF;
4788:
4789: IF l_return_status = fnd_api.g_ret_sts_error THEN
4790: RAISE fnd_api.g_exc_error;
4791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4792: RAISE fnd_api.g_exc_unexpected_error;
4793: END IF;
4794:

Line 4791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4787: END IF;
4788:
4789: IF l_return_status = fnd_api.g_ret_sts_error THEN
4790: RAISE fnd_api.g_exc_error;
4791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4792: RAISE fnd_api.g_exc_unexpected_error;
4793: END IF;
4794:
4795: IF l_gl_posted_flag = G_GL_FLAG_NOLIAB THEN

Line 4792: RAISE fnd_api.g_exc_unexpected_error;

4788:
4789: IF l_return_status = fnd_api.g_ret_sts_error THEN
4790: RAISE fnd_api.g_exc_error;
4791: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4792: RAISE fnd_api.g_exc_unexpected_error;
4793: END IF;
4794:
4795: IF l_gl_posted_flag = G_GL_FLAG_NOLIAB THEN
4796: l_orig_amt := p_util_amount;

Line 4839: p_init_msg_list => Fnd_Api.G_FALSE,

4835: + NVL(l_new_univ_amt, 0);
4836: --rimehrot, for R12
4837: ozf_objfundsum_pvt.update_objfundsum(
4838: p_api_version => 1.0,
4839: p_init_msg_list => Fnd_Api.G_FALSE,
4840: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
4841: p_objfundsum_rec => l_objfundsum_rec,
4842: x_return_status => l_return_status,
4843: x_msg_count => x_msg_count,

Line 4840: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,

4836: --rimehrot, for R12
4837: ozf_objfundsum_pvt.update_objfundsum(
4838: p_api_version => 1.0,
4839: p_init_msg_list => Fnd_Api.G_FALSE,
4840: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
4841: p_objfundsum_rec => l_objfundsum_rec,
4842: x_return_status => l_return_status,
4843: x_msg_count => x_msg_count,
4844: x_msg_data => x_msg_data

Line 4846: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4842: x_return_status => l_return_status,
4843: x_msg_count => x_msg_count,
4844: x_msg_data => x_msg_data
4845: );
4846: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4847: RAISE fnd_api.g_exc_unexpected_error;
4848: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4849: RAISE fnd_api.g_exc_error;
4850: END IF;

Line 4847: RAISE fnd_api.g_exc_unexpected_error;

4843: x_msg_count => x_msg_count,
4844: x_msg_data => x_msg_data
4845: );
4846: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4847: RAISE fnd_api.g_exc_unexpected_error;
4848: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4849: RAISE fnd_api.g_exc_error;
4850: END IF;
4851: -- end R12 changes

Line 4848: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

4844: x_msg_data => x_msg_data
4845: );
4846: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4847: RAISE fnd_api.g_exc_unexpected_error;
4848: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4849: RAISE fnd_api.g_exc_error;
4850: END IF;
4851: -- end R12 changes
4852:

Line 4849: RAISE fnd_api.g_exc_error;

4845: );
4846: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4847: RAISE fnd_api.g_exc_unexpected_error;
4848: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4849: RAISE fnd_api.g_exc_error;
4850: END IF;
4851: -- end R12 changes
4852:
4853: END IF; -- p_util_utilization_type = 'SALES_ACCRUAL'

Line 4899: x_return_status := fnd_api.g_ret_sts_success;

4895: END IF; -- end of plan_type
4896:
4897:
4898: x_gl_posted_flag := l_gl_posted_flag;
4899: x_return_status := fnd_api.g_ret_sts_success;
4900:
4901: IF g_debug_flag = 'Y' THEN
4902: ozf_utility_pvt.write_conc_log (' D: post_accrual_to_gl() ENDs for utilization id ' || p_util_utilization_id
4903: || ' final gl_posted_flag=' || x_gl_posted_flag);

Line 4910: x_return_status := fnd_api.g_ret_sts_unexp_error;

4906: EXCEPTION
4907: WHEN OTHERS THEN
4908: ROLLBACK TO post_accrual_to_gl_sp;
4909: ozf_utility_pvt.write_conc_log(' D: post_accrual_to_gl(): exception ');
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911: fnd_msg_pub.count_and_get (
4912: p_count => x_msg_count,
4913: p_data => x_msg_data,
4914: p_encoded => fnd_api.g_false

Line 4914: p_encoded => fnd_api.g_false

4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911: fnd_msg_pub.count_and_get (
4912: p_count => x_msg_count,
4913: p_data => x_msg_data,
4914: p_encoded => fnd_api.g_false
4915: );
4916: END post_accrual_to_gl;
4917:
4918:

Line 4984: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4980: , x_msg_count => l_msg_count
4981: , x_msg_data => l_msg_data
4982: );
4983:
4984: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4985: -- failed again. Leave as it is.
4986: ozf_utility_pvt.write_conc_log(' /****** Failed to post to GL ******/ for utilization id ' || l_utilIdTbl(i));
4987: ELSE
4988: IF g_debug_flag = 'Y' THEN

Line 5159: IF l_return_status = fnd_api.g_ret_sts_success AND l_gl_posted_flag = G_GL_FLAG_YES THEN

5155: || ') returns ' || l_return_status || ' x_gl_posted_flag' || l_gl_posted_flag);
5156: END IF;
5157:
5158: -- yzhao: 03/04/2004 post gl for related accruals from offer adjustment or object reconcile
5159: IF l_return_status = fnd_api.g_ret_sts_success AND l_gl_posted_flag = G_GL_FLAG_YES THEN
5160: post_related_accrual_to_gl(
5161: p_utilization_id => l_utilIdTbl(i)
5162: , p_utilization_type => 'UTILIZED'
5163: , p_gl_date => l_gl_date

Line 5190: p_encoded => fnd_api.g_false

5186: ozf_utility_pvt.write_conc_log(' D: post_offinvoice_to_gl(): exception ');
5187: fnd_msg_pub.count_and_get (
5188: p_count => l_msg_count,
5189: p_data => l_msg_data,
5190: p_encoded => fnd_api.g_false
5191: );
5192: x_errbuf := l_msg_data;
5193: END post_offinvoice_to_gl;
5194:

Line 5289: x_return_status := fnd_api.g_ret_sts_success;

5285: EXIT WHEN c_get_related_accrual%NOTFOUND;
5286: END LOOP; -- bulk fetch
5287: CLOSE c_get_related_accrual;
5288:
5289: x_return_status := fnd_api.g_ret_sts_success;
5290: IF g_debug_flag = 'Y' THEN
5291: ozf_utility_pvt.write_conc_log (' D: post_related_accrual_to_gl() ENDs for utilization id ' || p_utilization_id);
5292: END IF;
5293:

Line 5298: x_return_status := fnd_api.g_ret_sts_unexp_error;

5294: EXCEPTION
5295: WHEN OTHERS THEN
5296: ROLLBACK TO post_related_accrual_to_gl_sp;
5297: ozf_utility_pvt.write_conc_log(' D: post_related_accrual_to_gl(): exception ');
5298: x_return_status := fnd_api.g_ret_sts_unexp_error;
5299: fnd_msg_pub.count_and_get (
5300: p_count => x_msg_count,
5301: p_data => x_msg_data,
5302: p_encoded => fnd_api.g_false

Line 5302: p_encoded => fnd_api.g_false

5298: x_return_status := fnd_api.g_ret_sts_unexp_error;
5299: fnd_msg_pub.count_and_get (
5300: p_count => x_msg_count,
5301: p_data => x_msg_data,
5302: p_encoded => fnd_api.g_false
5303: );
5304:
5305: END post_related_accrual_to_gl;
5306: