eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on FND_MESSAGE

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

768: l_from_date, l_to_date, l_status_code, l_method_code, l_basis_year, l_ex_start_node;
769: IF c_get_alloc_details%NOTFOUND THEN
770: CLOSE c_get_alloc_details;
771: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
772: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
773: fnd_msg_pub.add;
774: END IF;
775: RAISE fnd_api.g_exc_error;
776: END IF;

Line 1421: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCACTIVE_ERROR');

1417: IF l_fund_status_code <> 'ACTIVE' THEN
1418: -- can not make allocaiton active if root budget is not active
1419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1420: IF (l_fund_type = 'QUOTA') THEN
1421: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCACTIVE_ERROR');
1422: ELSE
1423: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCACTIVE_ERROR');
1424: END IF;
1425: FND_MSG_PUB.Add;

Line 1423: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCACTIVE_ERROR');

1419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1420: IF (l_fund_type = 'QUOTA') THEN
1421: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCACTIVE_ERROR');
1422: ELSE
1423: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCACTIVE_ERROR');
1424: END IF;
1425: FND_MSG_PUB.Add;
1426: END IF;
1427: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1617: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_SUB');

1613: p_lookup_code => 'BUDGET',
1614: x_return_status => l_temp_status,
1615: x_meaning => l_fund_meaning);
1616: END IF;
1617: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_SUB');
1618: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);
1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);

Line 1618: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);

1614: x_return_status => l_temp_status,
1615: x_meaning => l_fund_meaning);
1616: END IF;
1617: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_SUB');
1618: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);
1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');

Line 1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);

1615: x_meaning => l_fund_meaning);
1616: END IF;
1617: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_SUB');
1618: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);
1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);

Line 1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

1616: END IF;
1617: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_SUB');
1618: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);
1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);

Line 1621: l_notif_subject := substrb(fnd_message.get, 1, 400);

1617: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_SUB');
1618: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);
1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);

Line 1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');

1618: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);
1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);
1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);

1619: fnd_message.set_token('ALLOC_ID', p_alloc_id);
1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);
1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1627: l_notif_body := substrb(fnd_message.get, 1, 4000);

Line 1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);

1620: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);
1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1627: l_notif_body := substrb(fnd_message.get, 1, 4000);
1628:

Line 1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);

1621: l_notif_subject := substrb(fnd_message.get, 1, 400);
1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);
1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1627: l_notif_body := substrb(fnd_message.get, 1, 4000);
1628:
1629: ozf_utility_pvt.send_wf_standalone_message(

Line 1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

1622: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_PUBLISH_BODY');
1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);
1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1627: l_notif_body := substrb(fnd_message.get, 1, 4000);
1628:
1629: ozf_utility_pvt.send_wf_standalone_message(
1630: p_subject => l_notif_subject

Line 1627: l_notif_body := substrb(fnd_message.get, 1, 4000);

1623: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
1624: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);
1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1627: l_notif_body := substrb(fnd_message.get, 1, 4000);
1628:
1629: ozf_utility_pvt.send_wf_standalone_message(
1630: p_subject => l_notif_subject
1631: , p_body => l_notif_body

Line 1718: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');

1714: -- dbms_output.put_line('top level: budget available amount=' || l_avail_amount || ' recommend total=' || p_alloc_amount);
1715: IF p_alloc_amount > l_avail_amount THEN
1716: -- top level allocation amount can not exceed fund's available amount
1717: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1718: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
1719: FND_MESSAGE.Set_Token('SUMAMT', p_alloc_amount);
1720: FND_MESSAGE.Set_Token('NODEVALUE', 'FUND');
1721: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
1722: FND_MSG_PUB.Add;

Line 1719: FND_MESSAGE.Set_Token('SUMAMT', p_alloc_amount);

1715: IF p_alloc_amount > l_avail_amount THEN
1716: -- top level allocation amount can not exceed fund's available amount
1717: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1718: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
1719: FND_MESSAGE.Set_Token('SUMAMT', p_alloc_amount);
1720: FND_MESSAGE.Set_Token('NODEVALUE', 'FUND');
1721: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
1722: FND_MSG_PUB.Add;
1723: END IF;

Line 1720: FND_MESSAGE.Set_Token('NODEVALUE', 'FUND');

1716: -- top level allocation amount can not exceed fund's available amount
1717: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1718: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
1719: FND_MESSAGE.Set_Token('SUMAMT', p_alloc_amount);
1720: FND_MESSAGE.Set_Token('NODEVALUE', 'FUND');
1721: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
1722: FND_MSG_PUB.Add;
1723: END IF;
1724: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1721: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);

1717: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1718: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
1719: FND_MESSAGE.Set_Token('SUMAMT', p_alloc_amount);
1720: FND_MESSAGE.Set_Token('NODEVALUE', 'FUND');
1721: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
1722: FND_MSG_PUB.Add;
1723: END IF;
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: RAISE FND_API.G_EXC_ERROR;

Line 1731: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');

1727:
1728: IF p_hb_amount > p_alloc_amount THEN
1729: -- holdback amount can not exceed allocation amount
1730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1731: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
1732: FND_MESSAGE.Set_Token('HOLDBACK', p_hb_amount);
1733: FND_MESSAGE.Set_Token('ALLOCAMT', p_alloc_amount);
1734: FND_MSG_PUB.Add;
1735: END IF;

Line 1732: FND_MESSAGE.Set_Token('HOLDBACK', p_hb_amount);

1728: IF p_hb_amount > p_alloc_amount THEN
1729: -- holdback amount can not exceed allocation amount
1730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1731: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
1732: FND_MESSAGE.Set_Token('HOLDBACK', p_hb_amount);
1733: FND_MESSAGE.Set_Token('ALLOCAMT', p_alloc_amount);
1734: FND_MSG_PUB.Add;
1735: END IF;
1736: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1733: FND_MESSAGE.Set_Token('ALLOCAMT', p_alloc_amount);

1729: -- holdback amount can not exceed allocation amount
1730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1731: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
1732: FND_MESSAGE.Set_Token('HOLDBACK', p_hb_amount);
1733: FND_MESSAGE.Set_Token('ALLOCAMT', p_alloc_amount);
1734: FND_MSG_PUB.Add;
1735: END IF;
1736: x_return_status := FND_API.G_RET_STS_ERROR;
1737: RAISE FND_API.G_EXC_ERROR;

Line 2007: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');

2003: -- we're not checking top level node against root budget as update_worksheet_amount() already does that before calling cascade
2004: -- holdback amount can not exceed allocation amount
2005: IF l_recommend_hb > l_recommend_total THEN
2006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2007: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
2008: FND_MESSAGE.Set_Token('HOLDBACK', l_recommend_hb);
2009: FND_MESSAGE.Set_Token('ALLOCAMT', l_recommend_total);
2010: FND_MSG_PUB.Add;
2011: END IF;

Line 2008: FND_MESSAGE.Set_Token('HOLDBACK', l_recommend_hb);

2004: -- holdback amount can not exceed allocation amount
2005: IF l_recommend_hb > l_recommend_total THEN
2006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2007: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
2008: FND_MESSAGE.Set_Token('HOLDBACK', l_recommend_hb);
2009: FND_MESSAGE.Set_Token('ALLOCAMT', l_recommend_total);
2010: FND_MSG_PUB.Add;
2011: END IF;
2012: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2009: FND_MESSAGE.Set_Token('ALLOCAMT', l_recommend_total);

2005: IF l_recommend_hb > l_recommend_total THEN
2006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2007: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
2008: FND_MESSAGE.Set_Token('HOLDBACK', l_recommend_hb);
2009: FND_MESSAGE.Set_Token('ALLOCAMT', l_recommend_total);
2010: FND_MSG_PUB.Add;
2011: END IF;
2012: x_return_status := FND_API.G_RET_STS_ERROR;
2013: RAISE FND_API.G_EXC_ERROR;

Line 2036: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');

2032: , x_return_status => l_return_status
2033: , x_msg_count => x_msg_count
2034: , x_msg_data => x_msg_data
2035: );
2036: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2037: FND_MESSAGE.Set_Token('SUMAMT', l_sibling_sum_amount);
2038: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2039: FND_MESSAGE.Set_Token('PAMT', l_parent_amount);
2040: FND_MSG_PUB.Add;

Line 2037: FND_MESSAGE.Set_Token('SUMAMT', l_sibling_sum_amount);

2033: , x_msg_count => x_msg_count
2034: , x_msg_data => x_msg_data
2035: );
2036: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2037: FND_MESSAGE.Set_Token('SUMAMT', l_sibling_sum_amount);
2038: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2039: FND_MESSAGE.Set_Token('PAMT', l_parent_amount);
2040: FND_MSG_PUB.Add;
2041: END IF;

Line 2038: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);

2034: , x_msg_data => x_msg_data
2035: );
2036: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2037: FND_MESSAGE.Set_Token('SUMAMT', l_sibling_sum_amount);
2038: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2039: FND_MESSAGE.Set_Token('PAMT', l_parent_amount);
2040: FND_MSG_PUB.Add;
2041: END IF;
2042: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2039: FND_MESSAGE.Set_Token('PAMT', l_parent_amount);

2035: );
2036: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2037: FND_MESSAGE.Set_Token('SUMAMT', l_sibling_sum_amount);
2038: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2039: FND_MESSAGE.Set_Token('PAMT', l_parent_amount);
2040: FND_MSG_PUB.Add;
2041: END IF;
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: RAISE FND_API.G_EXC_ERROR;

Line 2206: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');

2202: ELSE
2203: -- for each node: holdback amount can not exceed allocation amount
2204: IF worksheet_rec.recommend_hb_amount > worksheet_rec.recommend_total_amount THEN
2205: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2206: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
2207: FND_MESSAGE.Set_Token('HOLDBACK', worksheet_rec.recommend_hb_amount);
2208: FND_MESSAGE.Set_Token('ALLOCAMT', worksheet_rec.recommend_total_amount);
2209: FND_MSG_PUB.Add;
2210: END IF;

Line 2207: FND_MESSAGE.Set_Token('HOLDBACK', worksheet_rec.recommend_hb_amount);

2203: -- for each node: holdback amount can not exceed allocation amount
2204: IF worksheet_rec.recommend_hb_amount > worksheet_rec.recommend_total_amount THEN
2205: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2206: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
2207: FND_MESSAGE.Set_Token('HOLDBACK', worksheet_rec.recommend_hb_amount);
2208: FND_MESSAGE.Set_Token('ALLOCAMT', worksheet_rec.recommend_total_amount);
2209: FND_MSG_PUB.Add;
2210: END IF;
2211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2208: FND_MESSAGE.Set_Token('ALLOCAMT', worksheet_rec.recommend_total_amount);

2204: IF worksheet_rec.recommend_hb_amount > worksheet_rec.recommend_total_amount THEN
2205: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2206: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_HOLDBACKAMT_ERROR');
2207: FND_MESSAGE.Set_Token('HOLDBACK', worksheet_rec.recommend_hb_amount);
2208: FND_MESSAGE.Set_Token('ALLOCAMT', worksheet_rec.recommend_total_amount);
2209: FND_MSG_PUB.Add;
2210: END IF;
2211: x_return_status := FND_API.G_RET_STS_ERROR;
2212: RAISE FND_API.G_EXC_ERROR;

Line 2232: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');

2228: , x_return_status => l_return_status
2229: , x_msg_count => x_msg_count
2230: , x_msg_data => x_msg_data
2231: );
2232: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2233: FND_MESSAGE.Set_Token('SUMAMT', l_child_sum_amount);
2234: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2235: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
2236: FND_MSG_PUB.Add;

Line 2233: FND_MESSAGE.Set_Token('SUMAMT', l_child_sum_amount);

2229: , x_msg_count => x_msg_count
2230: , x_msg_data => x_msg_data
2231: );
2232: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2233: FND_MESSAGE.Set_Token('SUMAMT', l_child_sum_amount);
2234: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2235: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
2236: FND_MSG_PUB.Add;
2237: END IF;

Line 2234: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);

2230: , x_msg_data => x_msg_data
2231: );
2232: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2233: FND_MESSAGE.Set_Token('SUMAMT', l_child_sum_amount);
2234: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2235: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
2236: FND_MSG_PUB.Add;
2237: END IF;
2238: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2235: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);

2231: );
2232: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_INV_CHILD_AMT');
2233: FND_MESSAGE.Set_Token('SUMAMT', l_child_sum_amount);
2234: FND_MESSAGE.Set_Token('NODEVALUE', l_node_info.node_name);
2235: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
2236: FND_MSG_PUB.Add;
2237: END IF;
2238: x_return_status := FND_API.G_RET_STS_ERROR;
2239: RAISE FND_API.G_EXC_ERROR;

Line 2339: fnd_message.set_name('OZF', 'OZF_FUND_ALLOCAMT_NEG_ERROR');

2335:
2336: -- kdass: 01/19/2004 fix bug 3379926 - the allocation worksheet should not accept negative amounts for allocation
2337: IF NVL(p_fact_table(l_index).recommend_total_amount,0) < 0 THEN -- check for recommended total amount
2338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2339: fnd_message.set_name('OZF', 'OZF_FUND_ALLOCAMT_NEG_ERROR');
2340: fnd_msg_pub.add;
2341: END IF;
2342: x_return_status := fnd_api.g_ret_sts_error;
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2349: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');

2345:
2346: -- kdass: 01/23/2004 fix bug 3392738 - the allocation worksheet should not accept negative amounts for holdback amounts
2347: IF NVL(p_fact_table(l_index).recommend_hb_amount,0) < 0 THEN -- check for recommended holdback amount
2348: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2349: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');
2350: fnd_msg_pub.add;
2351: END IF;
2352: x_return_status := fnd_api.g_ret_sts_error;
2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2656: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_SUB');

2652: p_lookup_code => 'BUDGET',
2653: x_return_status => l_temp_status,
2654: x_meaning => l_fund_meaning);
2655: END IF;
2656: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_SUB');
2657: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);
2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);

Line 2657: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);

2653: x_return_status => l_temp_status,
2654: x_meaning => l_fund_meaning);
2655: END IF;
2656: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_SUB');
2657: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);
2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');

Line 2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);

2654: x_meaning => l_fund_meaning);
2655: END IF;
2656: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_SUB');
2657: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);
2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);

Line 2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

2655: END IF;
2656: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_SUB');
2657: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);
2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);

Line 2660: l_notif_subject := substrb(fnd_message.get, 1, 400);

2656: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_SUB');
2657: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);
2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');

Line 2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');

2657: fnd_message.set_token('BUDGET_NAME', l_child_fund_name);
2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);
2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);

Line 2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);

2658: fnd_message.set_token('ALLOC_ID', p_alloc_id);
2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));

Line 2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);

2659: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));
2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));

Line 2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');

2660: l_notif_subject := substrb(fnd_message.get, 1, 400);
2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));
2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));
2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);

2661: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_APPROVAL_BODY');
2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));
2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));
2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2669: l_notif_body := substrb(fnd_message.get, 1, 4000);

Line 2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));

2662: fnd_message.set_token ('BUDGET_NAME', l_child_fund_name);
2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));
2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));
2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2669: l_notif_body := substrb(fnd_message.get, 1, 4000);
2670:

Line 2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));

2663: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));
2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));
2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2669: l_notif_body := substrb(fnd_message.get, 1, 4000);
2670:
2671: ozf_utility_pvt.send_wf_standalone_message(

Line 2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

2664: fnd_message.set_token ('ALLOC_STATUS', 'ACTIVE');
2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));
2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));
2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2669: l_notif_body := substrb(fnd_message.get, 1, 4000);
2670:
2671: ozf_utility_pvt.send_wf_standalone_message(
2672: p_subject => l_notif_subject

Line 2669: l_notif_body := substrb(fnd_message.get, 1, 4000);

2665: fnd_message.set_token ('CURRENCY_CODE', l_child_fund_currency);
2666: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(l_child_requested_total,0),l_child_fund_currency));
2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));
2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2669: l_notif_body := substrb(fnd_message.get, 1, 4000);
2670:
2671: ozf_utility_pvt.send_wf_standalone_message(
2672: p_subject => l_notif_subject
2673: , p_body => l_notif_body

Line 2778: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCNOTOWNER_ERROR');

2774: -- only the allocation creator can activate allocation
2775: IF l_alloc_creator <> NVL(fnd_global.user_id, -1) THEN
2776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2777: IF l_fund_type = 'QUOTA' THEN
2778: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCNOTOWNER_ERROR');
2779: ELSE
2780: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCNOTOWNER_ERROR');
2781: END IF;
2782: FND_MSG_PUB.Add;

Line 2780: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCNOTOWNER_ERROR');

2776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2777: IF l_fund_type = 'QUOTA' THEN
2778: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCNOTOWNER_ERROR');
2779: ELSE
2780: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCNOTOWNER_ERROR');
2781: END IF;
2782: FND_MSG_PUB.Add;
2783: END IF;
2784: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2791: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCSTATUS_ERROR');

2787:
2788: -- statuses other than PLANNED are not allowed changed to ACTIVE
2789: IF l_alloc_old_status <> 'PLANNED' THEN
2790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2791: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCSTATUS_ERROR');
2792: FND_MSG_PUB.Add;
2793: END IF;
2794: x_return_status := FND_API.G_RET_STS_ERROR;
2795: RAISE FND_API.G_EXC_ERROR;

Line 2804: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCACTIVE_ERROR');

2800: -- can not make allocaiton active if root budget is not active
2801: IF l_fund_status_code <> 'ACTIVE' THEN
2802: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2803: IF l_fund_type = 'QUOTA' THEN
2804: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCACTIVE_ERROR');
2805: ELSE
2806: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCACTIVE_ERROR');
2807: END IF;
2808: FND_MSG_PUB.Add;

Line 2806: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCACTIVE_ERROR');

2802: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2803: IF l_fund_type = 'QUOTA' THEN
2804: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCACTIVE_ERROR');
2805: ELSE
2806: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCACTIVE_ERROR');
2807: END IF;
2808: FND_MSG_PUB.Add;
2809: END IF;
2810: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2967: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCNOTOWNER_ERROR');

2963: -- only the allocation creator can activate allocation
2964: IF l_alloc_creator <> NVL(fnd_global.user_id, -1) THEN
2965: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2966: IF l_root_fund_type = 'QUOTA' THEN
2967: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCNOTOWNER_ERROR');
2968: ELSE
2969: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCNOTOWNER_ERROR');
2970: END IF;
2971: FND_MSG_PUB.Add;

Line 2969: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCNOTOWNER_ERROR');

2965: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2966: IF l_root_fund_type = 'QUOTA' THEN
2967: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_ALLOCNOTOWNER_ERROR');
2968: ELSE
2969: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCNOTOWNER_ERROR');
2970: END IF;
2971: FND_MSG_PUB.Add;
2972: END IF;
2973: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2980: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCSTATUS_ERROR');

2976:
2977: -- statuses other than NEW or PLANNED are not allowed changed to CANCELLED
2978: IF l_alloc_old_status <> 'NEW' AND l_alloc_old_status <> 'PLANNED' THEN
2979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2980: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCSTATUS_ERROR');
2981: FND_MSG_PUB.Add;
2982: END IF;
2983: x_return_status := FND_API.G_RET_STS_ERROR;
2984: RAISE FND_API.G_EXC_ERROR;

Line 3067: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_SUB');

3063: p_lookup_code => 'BUDGET',
3064: x_return_status => l_temp_status,
3065: x_meaning => l_fund_meaning);
3066: END IF;
3067: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_SUB');
3068: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);
3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);

Line 3068: fnd_message.set_token('BUDGET_NAME', l_fund_name);

3064: x_return_status => l_temp_status,
3065: x_meaning => l_fund_meaning);
3066: END IF;
3067: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_SUB');
3068: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);
3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');

Line 3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);

3065: x_meaning => l_fund_meaning);
3066: END IF;
3067: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_SUB');
3068: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);
3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);

Line 3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

3066: END IF;
3067: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_SUB');
3068: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);
3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);

Line 3071: l_notif_subject := substrb(fnd_message.get, 1, 400);

3067: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_SUB');
3068: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);
3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');

Line 3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');

3068: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);
3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');
3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);

3069: fnd_message.set_token('ALLOC_ID', p_alloc_id);
3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');
3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3077: l_notif_body := substrb(fnd_message.get, 1, 4000);

Line 3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);

3070: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');
3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3077: l_notif_body := substrb(fnd_message.get, 1, 4000);
3078:

Line 3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');

3071: l_notif_subject := substrb(fnd_message.get, 1, 400);
3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');
3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3077: l_notif_body := substrb(fnd_message.get, 1, 4000);
3078:
3079: ozf_utility_pvt.send_wf_standalone_message(

Line 3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

3072: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_CANCEL_BODY');
3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');
3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3077: l_notif_body := substrb(fnd_message.get, 1, 4000);
3078:
3079: ozf_utility_pvt.send_wf_standalone_message(
3080: p_subject => l_notif_subject

Line 3077: l_notif_body := substrb(fnd_message.get, 1, 4000);

3073: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3074: fnd_message.set_token ('ALLOC_ID', p_alloc_id);
3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');
3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3077: l_notif_body := substrb(fnd_message.get, 1, 4000);
3078:
3079: ozf_utility_pvt.send_wf_standalone_message(
3080: p_subject => l_notif_subject
3081: , p_body => l_notif_body

Line 3192: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCSTATUS_ERROR');

3188: END IF;
3189:
3190: IF not l_valid_change THEN
3191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3192: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCSTATUS_ERROR');
3193: FND_MSG_PUB.Add;
3194: END IF;
3195: x_return_status := FND_API.G_RET_STS_ERROR;
3196: RAISE FND_API.G_EXC_ERROR;

Line 3315: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCAPPROVE_ERROR');

3311:
3312: -- approver's status must be active to approve allocation
3313: IF l_approver_status <> 'ACTIVE' THEN
3314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3315: FND_MESSAGE.Set_Name ('OZF', 'OZF_FUND_ALLOCAPPROVE_ERROR');
3316: FND_MSG_PUB.Add;
3317: END IF;
3318: x_return_status := FND_API.G_RET_STS_ERROR;
3319: RAISE FND_API.G_EXC_ERROR;

Line 3556: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_SUB');

3552: x_return_status => l_temp_status,
3553: x_meaning => l_fund_meaning);
3554: END IF;
3555: l_notif_body := NULL;
3556: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_SUB');
3557: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);

Line 3557: fnd_message.set_token('BUDGET_NAME', l_fund_name);

3553: x_meaning => l_fund_meaning);
3554: END IF;
3555: l_notif_body := NULL;
3556: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_SUB');
3557: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');

Line 3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);

3554: END IF;
3555: l_notif_body := NULL;
3556: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_SUB');
3557: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);

Line 3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

3555: l_notif_body := NULL;
3556: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_SUB');
3557: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);

Line 3560: l_notif_subject := substrb(fnd_message.get, 1, 400);

3556: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_SUB');
3557: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);

Line 3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');

3557: fnd_message.set_token('BUDGET_NAME', l_fund_name);
3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);

Line 3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);

3558: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);
3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);

Line 3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);

3559: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);
3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);
3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);

3560: l_notif_subject := substrb(fnd_message.get, 1, 400);
3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);
3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);
3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3568: l_notif_body := substrb(fnd_message.get, 1, 4000);

Line 3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);

3561: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_SUBMIT_BODY');
3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);
3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);
3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3568: l_notif_body := substrb(fnd_message.get, 1, 4000);
3569:

Line 3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);

3562: fnd_message.set_token ('BUDGET_NAME', l_fund_name);
3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);
3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);
3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3568: l_notif_body := substrb(fnd_message.get, 1, 4000);
3569:
3570: ozf_utility_pvt.send_wf_standalone_message(

Line 3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

3563: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);
3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);
3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3568: l_notif_body := substrb(fnd_message.get, 1, 4000);
3569:
3570: ozf_utility_pvt.send_wf_standalone_message(
3571: p_subject => l_notif_subject

Line 3568: l_notif_body := substrb(fnd_message.get, 1, 4000);

3564: fnd_message.set_token ('CURRENCY_CODE', l_currency_code);
3565: fnd_message.set_token ('TOTAL_AMOUNT', l_request_total);
3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);
3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3568: l_notif_body := substrb(fnd_message.get, 1, 4000);
3569:
3570: ozf_utility_pvt.send_wf_standalone_message(
3571: p_subject => l_notif_subject
3572: , p_body => l_notif_body

Line 3699: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_SUB');

3695: p_lookup_code => 'BUDGET',
3696: x_return_status => l_temp_status,
3697: x_meaning => l_fund_meaning);
3698: END IF;
3699: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_SUB');
3700: fnd_message.set_token('BUDGET_NAME', l_budget_name);
3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);

Line 3700: fnd_message.set_token('BUDGET_NAME', l_budget_name);

3696: x_return_status => l_temp_status,
3697: x_meaning => l_fund_meaning);
3698: END IF;
3699: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_SUB');
3700: fnd_message.set_token('BUDGET_NAME', l_budget_name);
3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');

Line 3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);

3697: x_meaning => l_fund_meaning);
3698: END IF;
3699: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_SUB');
3700: fnd_message.set_token('BUDGET_NAME', l_budget_name);
3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);

Line 3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

3698: END IF;
3699: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_SUB');
3700: fnd_message.set_token('BUDGET_NAME', l_budget_name);
3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);

Line 3703: l_notif_subject := substrb(fnd_message.get, 1, 400);

3699: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_SUB');
3700: fnd_message.set_token('BUDGET_NAME', l_budget_name);
3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');

Line 3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');

3700: fnd_message.set_token('BUDGET_NAME', l_budget_name);
3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);

Line 3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);

3701: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);
3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));

Line 3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);

3702: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);
3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));
3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');

3703: l_notif_subject := substrb(fnd_message.get, 1, 400);
3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);
3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));
3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3711: l_notif_body := substrb(fnd_message.get, 1, 4000);

Line 3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);

3704: fnd_message.set_name('OZF', 'OZF_NTF_ALLOC_REJECT_BODY');
3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);
3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));
3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3711: l_notif_body := substrb(fnd_message.get, 1, 4000);
3712:

Line 3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));

3705: fnd_message.set_token ('BUDGET_NAME', l_budget_name);
3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);
3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));
3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3711: l_notif_body := substrb(fnd_message.get, 1, 4000);
3712:
3713: ozf_utility_pvt.send_wf_standalone_message(

Line 3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

3706: fnd_message.set_token('ALLOC_ID', l_alloc_id);
3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);
3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));
3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3711: l_notif_body := substrb(fnd_message.get, 1, 4000);
3712:
3713: ozf_utility_pvt.send_wf_standalone_message(
3714: p_subject => l_notif_subject

Line 3711: l_notif_body := substrb(fnd_message.get, 1, 4000);

3707: fnd_message.set_token ('ALLOC_STATUS', 'REJECTED');
3708: fnd_message.set_token ('CURRENCY_CODE', l_budget_currency);
3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));
3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3711: l_notif_body := substrb(fnd_message.get, 1, 4000);
3712:
3713: ozf_utility_pvt.send_wf_standalone_message(
3714: p_subject => l_notif_subject
3715: , p_body => l_notif_body