DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on FND_MESSAGE

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

689: IF (SQL%NOTFOUND) THEN
690: -- Error, check the msg level and added an error message to the
691: -- API message list
692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
693: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
694: fnd_msg_pub.ADD;
695: END IF;
696: RAISE fnd_api.g_exc_unexpected_error;
697: END IF;

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

1230: ,l_rollup_utilized_amt;
1231: IF (c_fund_b%NOTFOUND) THEN
1232: CLOSE c_fund_b;
1233: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1234: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1235: fnd_msg_pub.ADD;
1236: END IF;
1237: RAISE fnd_api.g_exc_error;
1238: END IF;

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

1521:
1522: l_utilization_rec.plan_id := l_utilization_rec.component_id;
1523: l_utilization_rec.plan_type := 'OFFR';
1524: l_utilization_rec.component_type := 'OFFR';
1525: l_utilization_rec.adjustment_desc := fnd_message.get_string ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK');
1526:
1527: -- yzhao: 11/25/2003 11.5.10 populate adjustment_date and time_id
1528: IF l_utilization_rec.adjustment_date IS NULL THEN
1529: l_utilization_rec.adjustment_date := SYSDATE;

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

1580:
1581: --get amount for universal currency and used to update rollup amount.
1582: IF g_universal_currency IS NULL THEN
1583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1584: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
1585: fnd_msg_pub.add;
1586: END IF;
1587: RAISE fnd_api.g_exc_error;
1588: END IF;

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

1864: ,l_mc_col_9;
1865: IF (c_mc_trans%NOTFOUND) THEN
1866: CLOSE c_mc_trans;
1867: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1868: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1869: fnd_msg_pub.ADD;
1870: END IF;
1871: RAISE fnd_api.g_exc_error;
1872: END IF;

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

1948: ozf_utility_pvt.write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record between fund '
1949: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1950: CLOSE c_accrual_budget_reqeust;
1951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1952: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1953: fnd_msg_pub.ADD;
1954: END IF;
1955: RAISE fnd_api.g_exc_error;
1956: END IF;

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

1976: write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record in utilization table between fund '
1977: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1978: CLOSE c_budget_request_utilrec;
1979: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1980: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1981: fnd_msg_pub.ADD;
1982: END IF;
1983: RAISE fnd_api.g_exc_error;
1984: END IF;

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

2262: 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;
2263: CLOSE c_cust_number;
2264: END IF;
2265:
2266: l_act_budgets_rec.justification := fnd_message.get_string ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK');
2267: l_act_budgets_rec.transfer_type := 'UTILIZED';
2268: l_act_budgets_rec.request_date := SYSDATE;
2269: l_act_budgets_rec.status_code := 'APPROVED';
2270: l_act_budgets_rec.user_status_id :=

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

2505:
2506: --- if this is not funded by a parent campaign or any budget the error OUT NOCOPY saying no budgte found
2507: IF l_fund_amt_tbl.COUNT = 0 THEN
2508: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2509: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2510: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2511: fnd_msg_pub.ADD;
2512: END IF;
2513: IF g_debug_flag = 'Y' THEN

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

2506: --- if this is not funded by a parent campaign or any budget the error OUT NOCOPY saying no budgte found
2507: IF l_fund_amt_tbl.COUNT = 0 THEN
2508: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2509: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2510: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2511: fnd_msg_pub.ADD;
2512: END IF;
2513: IF g_debug_flag = 'Y' THEN
2514: ozf_utility_pvt.write_conc_log(' D: post_adjust_to_budget() calculation for posting to budget failed. No posting to budget. RETURN');

Line 3143: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');

3139: -- Catch Weight ER - end
3140:
3141: IF (l_cost_price = -1) THEN
3142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3143: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3147: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?

3140:
3141: IF (l_cost_price = -1) THEN
3142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3143: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3147: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3148: fnd_msg_pub.add;

Line 3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);

3141: IF (l_cost_price = -1) THEN
3142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3143: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3147: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3148: fnd_msg_pub.add;
3149: END IF;

Line 3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);

3142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3143: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3147: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3148: fnd_msg_pub.add;
3149: END IF;
3150: GOTO l_endoflineadjloop;

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

3143: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3147: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3148: fnd_msg_pub.add;
3149: END IF;
3150: GOTO l_endoflineadjloop;
3151: END IF;

Line 3342: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');

3338: END IF;
3339:
3340: IF (l_cost_price = -1) THEN
3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3342: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3346: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);

3339:
3340: IF (l_cost_price = -1) THEN
3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3342: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3346: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3347: fnd_msg_pub.add;

Line 3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);

3340: IF (l_cost_price = -1) THEN
3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3342: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3346: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3347: fnd_msg_pub.add;
3348: END IF;

Line 3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);

3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3342: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3346: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3347: fnd_msg_pub.add;
3348: END IF;
3349: GOTO l_endoflineadjloop;

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

3342: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3346: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3347: fnd_msg_pub.add;
3348: END IF;
3349: GOTO l_endoflineadjloop;
3350: END IF;

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

5133: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5134: ozf_utility_pvt.write_conc_log ('Queue Return Error ');
5135:
5136: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5137: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5138: fnd_msg_pub.ADD;
5139: END IF;
5140: ozf_utility_pvt.write_conc_log;
5141: RETURN;

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

5274: WHEN OTHERS THEN
5275: ROLLBACK TO get_message_loop_savepoint;
5276: ozf_utility_pvt.write_conc_log('FAILED');
5277: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5278: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5279: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5280: FND_MSG_PUB.Add;
5281: END IF;
5282: ozf_utility_pvt.write_conc_log;

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

5275: ROLLBACK TO get_message_loop_savepoint;
5276: ozf_utility_pvt.write_conc_log('FAILED');
5277: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5278: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5279: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5280: FND_MSG_PUB.Add;
5281: END IF;
5282: ozf_utility_pvt.write_conc_log;
5283:

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

5424: --///added by mpande to write a error message to the list
5425: --if not sucess add a error message to th emessage list
5426: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5427: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5428: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5429: fnd_msg_pub.ADD;
5430: END IF;
5431: ozf_utility_pvt.write_conc_log;
5432: RETURN;

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

5534:
5535: --added for bug 8435487
5536: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5538: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5539: fnd_msg_pub.ADD;
5540: END IF;
5541: ozf_utility_pvt.write_conc_log('again exception happened');
5542: RETURN;

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

5563: WHEN OTHERS THEN
5564: ROLLBACK TO get_excep_loop_savepoint;
5565: ozf_utility_pvt.write_conc_log('FAILED');
5566: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5567: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5568: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5569: FND_MSG_PUB.Add;
5570: END IF;
5571: ozf_utility_pvt.write_conc_log;

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

5564: ROLLBACK TO get_excep_loop_savepoint;
5565: ozf_utility_pvt.write_conc_log('FAILED');
5566: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5567: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5568: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5569: FND_MSG_PUB.Add;
5570: END IF;
5571: ozf_utility_pvt.write_conc_log;
5572: END;

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

6001: IF l_gl_posted_flag IN(G_GL_FLAG_YES,G_GL_FLAG_NULL,G_GL_FLAG_NOLIAB) THEN
6002:
6003: IF g_universal_currency IS NULL THEN
6004: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6005: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
6006: fnd_msg_pub.add;
6007: END IF;
6008: RAISE fnd_api.g_exc_error;
6009: END IF;