DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on FND_MESSAGE

Line 368: fnd_message.set_name('OZF', 'OZF_COMMAMT_LESS_REQAMT');

364: END IF;
365: --Raise error message if committed amount is less then
366: IF l_util_amount > l_utilized_amount AND l_utilized_amount = 0 THEN
367: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
368: fnd_message.set_name('OZF', 'OZF_COMMAMT_LESS_REQAMT');
369: fnd_msg_pub.ADD;
370: END IF;
371: END IF;
372:

Line 748: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');

744: SAVEPOINT create_utilization;
745:
746: l_total_amount := 0;
747: --Added for bug 7425189
748: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
749: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
750:
751:
752: IF l_fund_transfer_flag = 'N' THEN

Line 749: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');

745:
746: l_total_amount := 0;
747: --Added for bug 7425189
748: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
749: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
750:
751:
752: IF l_fund_transfer_flag = 'N' THEN
753: -- 01/02/2002 mpande changed for utilization changes

Line 807: fnd_message.set_name ('OZF', 'OZF_FUND_OFFR_ADJ');

803: --05/06/2004 kdass fix for bug 3586046
804: --08/18/2005 feliu fix for third party accrual.
805: /* IF l_accrual_basis ='CUSTOMER' THEN
806: IF p_act_budget_rec.parent_source_id <> l_fund_id THEN
807: fnd_message.set_name ('OZF', 'OZF_FUND_OFFR_ADJ');
808: fnd_msg_pub.ADD;
809: RAISE fnd_api.g_exc_error;
810: END IF;
811: */

Line 1313: fnd_message.set_name ('OZF', 'OZF_NO_RATE');

1309: RETURN l_returned_amount;
1310: EXCEPTION
1311: WHEN gl_currency_api.no_rate THEN
1312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1313: fnd_message.set_name ('OZF', 'OZF_NO_RATE');
1314: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1315: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1316: fnd_msg_pub.ADD;
1317: RETURN 0;

Line 1314: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);

1310: EXCEPTION
1311: WHEN gl_currency_api.no_rate THEN
1312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1313: fnd_message.set_name ('OZF', 'OZF_NO_RATE');
1314: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1315: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1316: fnd_msg_pub.ADD;
1317: RETURN 0;
1318: END IF;

Line 1315: fnd_message.set_token ('CURRENCY_TO', p_to_currency);

1311: WHEN gl_currency_api.no_rate THEN
1312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1313: fnd_message.set_name ('OZF', 'OZF_NO_RATE');
1314: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1315: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1316: fnd_msg_pub.ADD;
1317: RETURN 0;
1318: END IF;
1319: WHEN gl_currency_api.invalid_currency THEN

Line 1321: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');

1317: RETURN 0;
1318: END IF;
1319: WHEN gl_currency_api.invalid_currency THEN
1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1321: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');
1322: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1323: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1324: fnd_msg_pub.ADD;
1325: RETURN 0;

Line 1322: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);

1318: END IF;
1319: WHEN gl_currency_api.invalid_currency THEN
1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1321: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');
1322: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1323: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1324: fnd_msg_pub.ADD;
1325: RETURN 0;
1326: END IF;

Line 1323: fnd_message.set_token ('CURRENCY_TO', p_to_currency);

1319: WHEN gl_currency_api.invalid_currency THEN
1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1321: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');
1322: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1323: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1324: fnd_msg_pub.ADD;
1325: RETURN 0;
1326: END IF;
1327: WHEN OTHERS THEN

Line 1414: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');

1410: END IF;
1411:
1412: IF l_lumpsum_offer.distribution_type = 'AMT' THEN
1413: IF l_total_distribution <> l_lumpsum_offer.lumpsum_amount THEN
1414: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1415: fnd_msg_pub.ADD;
1416: RAISE fnd_api.g_exc_error;
1417: ELSIF l_total_distribution > l_lumpsum_offer.lumpsum_amount THEN
1418: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');

Line 1418: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');

1414: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1415: fnd_msg_pub.ADD;
1416: RAISE fnd_api.g_exc_error;
1417: ELSIF l_total_distribution > l_lumpsum_offer.lumpsum_amount THEN
1418: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1419: fnd_msg_pub.ADD;
1420: RAISE fnd_api.g_exc_error;
1421: END IF;
1422: ELSIF l_lumpsum_offer.distribution_type = '%' THEN

Line 1424: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');

1420: RAISE fnd_api.g_exc_error;
1421: END IF;
1422: ELSIF l_lumpsum_offer.distribution_type = '%' THEN
1423: IF l_total_distribution <> 100 THEN
1424: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1425: fnd_msg_pub.ADD;
1426: RAISE fnd_api.g_exc_error;
1427: ELSIF l_total_distribution > 100 THEN
1428: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');

Line 1428: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');

1424: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1425: fnd_msg_pub.ADD;
1426: RAISE fnd_api.g_exc_error;
1427: ELSIF l_total_distribution > 100 THEN
1428: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1429: fnd_msg_pub.ADD;
1430: RAISE fnd_api.g_exc_error;
1431: END IF;
1432: END IF;

Line 2073: fnd_message.get_string ('OZF', 'OZF_ACT_BUDGET_SCANDATA_UTIL');

2069: l_act_budgets_rec.approver_id := l_offer_owner;
2070: END IF;
2071:
2072: l_act_budgets_rec.justification :=
2073: fnd_message.get_string ('OZF', 'OZF_ACT_BUDGET_SCANDATA_UTIL');
2074: l_act_budgets_rec.parent_source_id := l_prod_budget_rec.fund_id;
2075: l_act_budgets_rec.parent_src_curr := l_prod_budget_rec.currency_code;
2076: l_act_budgets_rec.parent_src_apprvd_amt := l_converted_amt; -- in budget currency.
2077: l_act_util_rec.product_id := l_product_id ;

Line 2574: fnd_message.get_string ('OZF', 'OZF_ACT_BUDGET_LUMPSUM_UTIL');

2570: IF l_act_budgets_rec.approver_id = -1 THEN
2571: l_act_budgets_rec.approver_id := l_offer_owner;
2572: END IF;
2573: l_act_budgets_rec.justification :=
2574: fnd_message.get_string ('OZF', 'OZF_ACT_BUDGET_LUMPSUM_UTIL');
2575: l_act_budgets_rec.parent_source_id := l_prod_budget_rec.fund_id;
2576: l_act_budgets_rec.parent_src_curr := l_prod_budget_rec.currency_code;
2577: l_act_budgets_rec.parent_src_apprvd_amt := l_converted_amt; -- in budget currency.
2578: l_act_util_rec.product_id := l_itemId_tbl(i) ;

Line 3179: fnd_message.set_name ('OZF', 'OZF_ACT_BUDGET_INCR_UTIL');

3175: );
3176: l_act_budgets_rec.transfer_type := 'UTILIZED';
3177: l_act_budgets_rec.approval_date := SYSDATE;
3178: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3179: fnd_message.set_name ('OZF', 'OZF_ACT_BUDGET_INCR_UTIL');
3180: fnd_message.set_token ('CLAIM_ID', p_claim_id, FALSE);
3181: l_act_budgets_rec.justification := fnd_message.get;
3182: l_act_budgets_rec.parent_source_id := l_fund_rec.fund_id;
3183: l_act_budgets_rec.parent_src_curr := l_fund_rec.fund_currency;

Line 3180: fnd_message.set_token ('CLAIM_ID', p_claim_id, FALSE);

3176: l_act_budgets_rec.transfer_type := 'UTILIZED';
3177: l_act_budgets_rec.approval_date := SYSDATE;
3178: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3179: fnd_message.set_name ('OZF', 'OZF_ACT_BUDGET_INCR_UTIL');
3180: fnd_message.set_token ('CLAIM_ID', p_claim_id, FALSE);
3181: l_act_budgets_rec.justification := fnd_message.get;
3182: l_act_budgets_rec.parent_source_id := l_fund_rec.fund_id;
3183: l_act_budgets_rec.parent_src_curr := l_fund_rec.fund_currency;
3184: l_act_util_rec.product_id := l_product_id ;

Line 3181: l_act_budgets_rec.justification := fnd_message.get;

3177: l_act_budgets_rec.approval_date := SYSDATE;
3178: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3179: fnd_message.set_name ('OZF', 'OZF_ACT_BUDGET_INCR_UTIL');
3180: fnd_message.set_token ('CLAIM_ID', p_claim_id, FALSE);
3181: l_act_budgets_rec.justification := fnd_message.get;
3182: l_act_budgets_rec.parent_source_id := l_fund_rec.fund_id;
3183: l_act_budgets_rec.parent_src_curr := l_fund_rec.fund_currency;
3184: l_act_util_rec.product_id := l_product_id ;
3185: l_act_util_rec.product_level_type := l_level_type_code;

Line 3324: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

3320: IF (SQL%NOTFOUND) THEN
3321: -- Error, check the msg level and added an error message to the
3322: -- API message list
3323: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3324: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3325: fnd_msg_pub.ADD;
3326: END IF;
3327: RAISE fnd_api.g_exc_unexpected_error;
3328: END IF;

Line 3338: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

3334: IF (SQL%NOTFOUND) THEN
3335: -- Error, check the msg level and added an error message to the
3336: -- API message list
3337: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3338: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3339: fnd_msg_pub.ADD;
3340: END IF;
3341: RAISE fnd_api.g_exc_unexpected_error;
3342: END IF;

Line 3623: fnd_message.get_string ('OZF', 'OZF_SF_BUDGET_LUMPSUM_UTIL');

3619: IF l_act_budgets_rec.approver_id = -1 THEN
3620: l_act_budgets_rec.approver_id := l_req_owner;
3621: END IF;
3622: l_act_budgets_rec.justification :=
3623: fnd_message.get_string ('OZF', 'OZF_SF_BUDGET_LUMPSUM_UTIL');
3624: l_act_budgets_rec.parent_source_id := l_req_budgets.fund_id;
3625: l_act_budgets_rec.parent_src_curr := l_req_budgets.currency_code;
3626: l_act_budgets_rec.parent_src_apprvd_amt := l_converted_amt; -- in budget currency.
3627: l_act_util_rec.product_id := l_media_id ;