DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on FND_MESSAGE

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

499: IF (SQL%NOTFOUND) THEN
500: -- Error, check the msg level and added an error message to the
501: -- API message list
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;

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

979: ,l_rollup_utilized_amt;
980: IF (c_fund_b%NOTFOUND) THEN
981: CLOSE c_fund_b;
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;

Line 1198: l_utilization_rec.adjustment_desc := fnd_message.get_string ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK');

1194:
1195: l_utilization_rec.plan_id := l_utilization_rec.component_id;
1196: l_utilization_rec.plan_type := 'OFFR';
1197: l_utilization_rec.component_type := 'OFFR';
1198: l_utilization_rec.adjustment_desc := fnd_message.get_string ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK');
1199:
1200: -- yzhao: 11/25/2003 11.5.10 populate adjustment_date and time_id
1201: IF l_utilization_rec.adjustment_date IS NULL THEN
1202: l_utilization_rec.adjustment_date := SYSDATE;

Line 1248: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');

1244:
1245: --get amount for universal currency and used to update rollup amount.
1246: IF g_universal_currency IS NULL THEN
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;

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

1458: ,l_mc_col_9;
1459: IF (c_mc_trans%NOTFOUND) THEN
1460: CLOSE c_mc_trans;
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;

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

1540: ozf_utility_pvt.write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record between fund '
1541: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1542: CLOSE c_accrual_budget_reqeust;
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;

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

1568: write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record in utilization table between fund '
1569: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1570: CLOSE c_budget_request_utilrec;
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;

Line 1849: l_act_budgets_rec.justification := fnd_message.get_string ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK');

1845: FETCH c_cust_number INTO l_act_util_rec.billto_cust_account_id, l_act_util_rec.bill_to_site_use_id, l_act_util_rec.ship_to_site_use_id;
1846: CLOSE c_cust_number;
1847: END IF;
1848:
1849: l_act_budgets_rec.justification := fnd_message.get_string ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK');
1850: l_act_budgets_rec.transfer_type := 'UTILIZED';
1851: l_act_budgets_rec.request_date := SYSDATE;
1852: l_act_budgets_rec.status_code := 'APPROVED';
1853: l_act_budgets_rec.user_status_id :=

Line 2080: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');

2076:
2077: --- if this is not funded by a parent campaign or any budget the error OUT NOCOPY saying no budgte found
2078: IF l_fund_amt_tbl.COUNT = 0 THEN
2079: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2080: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2081: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2082: fnd_msg_pub.ADD;
2083: END IF;
2084: IF g_debug_flag = 'Y' THEN

Line 2081: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);

2077: --- if this is not funded by a parent campaign or any budget the error OUT NOCOPY saying no budgte found
2078: IF l_fund_amt_tbl.COUNT = 0 THEN
2079: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2080: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2081: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2082: fnd_msg_pub.ADD;
2083: END IF;
2084: IF g_debug_flag = 'Y' THEN
2085: ozf_utility_pvt.write_conc_log(' D: post_adjust_to_budget() calculation for posting to budget failed. No posting to budget. RETURN');

Line 4010: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');

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');
4011: fnd_msg_pub.ADD;
4012: END IF;
4013: ozf_utility_pvt.write_conc_log;
4014: RETURN;

Line 4150: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

4146: WHEN OTHERS THEN
4147: ROLLBACK TO get_message_loop_savepoint;
4148: ozf_utility_pvt.write_conc_log('FAILED');
4149: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4150: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4151: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4152: FND_MSG_PUB.Add;
4153: END IF;
4154: ozf_utility_pvt.write_conc_log;

Line 4151: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

4147: ROLLBACK TO get_message_loop_savepoint;
4148: ozf_utility_pvt.write_conc_log('FAILED');
4149: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4150: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4151: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4152: FND_MSG_PUB.Add;
4153: END IF;
4154: ozf_utility_pvt.write_conc_log;
4155:

Line 4300: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');

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;
4303: ozf_utility_pvt.write_conc_log;
4304: RETURN;

Line 4429: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

4425: WHEN OTHERS THEN
4426: ROLLBACK TO get_excep_loop_savepoint;
4427: ozf_utility_pvt.write_conc_log('FAILED');
4428: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4429: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4430: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4431: FND_MSG_PUB.Add;
4432: END IF;
4433: ozf_utility_pvt.write_conc_log;

Line 4430: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

4426: ROLLBACK TO get_excep_loop_savepoint;
4427: ozf_utility_pvt.write_conc_log('FAILED');
4428: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4429: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4430: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4431: FND_MSG_PUB.Add;
4432: END IF;
4433: ozf_utility_pvt.write_conc_log;
4434: END;

Line 4755: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');

4751: IF l_gl_posted_flag IN(G_GL_FLAG_YES,G_GL_FLAG_NULL,G_GL_FLAG_NOLIAB) THEN
4752:
4753: IF g_universal_currency IS NULL THEN
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;