DBA Data[Home] [Help]

APPS.OZF_CLAIM_APPROVAL_PVT dependencies on FND_MSG_PUB

Line 7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_Claim_Approval_PVT';
5: g_file_name CONSTANT VARCHAR2(15) := 'ozfvcawb.pls';
6:
7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
8: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9:
10: --------------------------------------------------------------------------
11: function find_org_id (p_claim_id IN NUMBER)

Line 8: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

4: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_Claim_Approval_PVT';
5: g_file_name CONSTANT VARCHAR2(15) := 'ozfvcawb.pls';
6:
7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
8: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9:
10: --------------------------------------------------------------------------
11: function find_org_id (p_claim_id IN NUMBER)
12: return number is

Line 1728: FND_MSG_PUB.initialize;

1724: AND rc.adjustment_reason_code = rlk_adj.lookup_code(+)
1725: AND rlk_adj.lookup_type(+) = 'ADJUST_REASON';
1726:
1727: BEGIN
1728: FND_MSG_PUB.initialize;
1729:
1730: l_activity_id := WF_ENGINE.getitemattrnumber(
1731: itemtype => itemtype
1732: ,itemkey => itemkey

Line 1784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1780: END IF;
1781:
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1785: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1786: FND_MSG_PUB.add;
1787: END IF;
1788: IF OZF_DEBUG_LOW_ON THEN

Line 1786: FND_MSG_PUB.add;

1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1785: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1786: FND_MSG_PUB.add;
1787: END IF;
1788: IF OZF_DEBUG_LOW_ON THEN
1789: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1790: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1791: FND_MSG_PUB.Add;

1787: END IF;
1788: IF OZF_DEBUG_LOW_ON THEN
1789: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1790: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1791: FND_MSG_PUB.Add;
1792: END IF;
1793: RAISE FND_API.g_exc_unexpected_error;
1794: END;
1795:

Line 1953: FND_MSG_PUB.count_and_get(

1949: );
1950:
1951: resultout := 'COMPLETE:SUCCESS';
1952: ELSE
1953: FND_MSG_PUB.count_and_get(
1954: p_encoded => fnd_api.g_false
1955: ,p_count => l_msg_count
1956: ,p_data => l_msg_data
1957: );

Line 2016: FND_MSG_PUB.Add;

2012: --RAISE;
2013: WHEN OTHERS THEN
2014: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2015: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2016: FND_MSG_PUB.Add;
2017:
2018: FND_MSG_PUB.count_and_get (
2019: p_encoded => fnd_api.g_false
2020: ,p_count => l_msg_count

Line 2018: FND_MSG_PUB.count_and_get (

2014: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2015: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2016: FND_MSG_PUB.Add;
2017:
2018: FND_MSG_PUB.count_and_get (
2019: p_encoded => fnd_api.g_false
2020: ,p_count => l_msg_count
2021: ,p_data => l_msg_data
2022: );

Line 2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2102: SET OBJECT_VERSION_NUMBER = l_object_version_number
2103: WHERE claim_id = p_claim_id;
2104: EXCEPTION
2105: WHEN OTHERS THEN
2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2107: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2108: FND_MSG_PUB.add;
2109: END IF;
2110: IF OZF_DEBUG_LOW_ON THEN

Line 2108: FND_MSG_PUB.add;

2104: EXCEPTION
2105: WHEN OTHERS THEN
2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2107: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2108: FND_MSG_PUB.add;
2109: END IF;
2110: IF OZF_DEBUG_LOW_ON THEN
2111: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2112: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 2113: FND_MSG_PUB.Add;

2109: END IF;
2110: IF OZF_DEBUG_LOW_ON THEN
2111: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2112: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2113: FND_MSG_PUB.Add;
2114: END IF;
2115: RAISE FND_API.g_exc_unexpected_error;
2116: END;
2117:

Line 2140: FND_MSG_PUB.Add;

2136: EXCEPTION
2137: WHEN OTHERS THEN
2138: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2139: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');
2140: FND_MSG_PUB.Add;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142:
2143: END Start_Approval_Process;
2144:

Line 2258: FND_MSG_PUB.count_and_get (

2254: ,itemkey => itemkey
2255: ,aname => 'UPDATE_GEN_STATUS'
2256: ,avalue => l_update_status
2257: );
2258: FND_MSG_PUB.count_and_get (
2259: p_encoded => fnd_api.g_false
2260: ,p_count => l_msg_count
2261: ,p_data => l_msg_data
2262: );

Line 2445: FND_MSG_PUB.ADD;

2441: --set message.
2442: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2443: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2444: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2445: FND_MSG_PUB.ADD;
2446: FND_MSG_PUB.count_and_get (
2447: p_encoded => fnd_api.g_false
2448: ,p_count => l_msg_count
2449: ,p_data => l_msg_data

Line 2446: FND_MSG_PUB.count_and_get (

2442: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2443: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2444: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2445: FND_MSG_PUB.ADD;
2446: FND_MSG_PUB.count_and_get (
2447: p_encoded => fnd_api.g_false
2448: ,p_count => l_msg_count
2449: ,p_data => l_msg_data
2450: );

Line 2572: FND_MSG_PUB.count_and_get (

2568:
2569: IF l_return_status = fnd_api.g_ret_sts_success THEN
2570: resultout := 'COMPLETE:SUCCESS';
2571: ELSE
2572: FND_MSG_PUB.count_and_get (
2573: p_encoded => fnd_api.g_false
2574: ,p_count => l_msg_count
2575: ,p_data => l_msg_data
2576: );

Line 2613: fnd_msg_pub.count_and_get(

2609: resultout := 'COMPLETE:';
2610: RETURN;
2611: END IF;
2612:
2613: fnd_msg_pub.count_and_get(
2614: p_encoded => fnd_api.g_false
2615: ,p_count => l_msg_count
2616: ,p_data => l_msg_data
2617: );

Line 2635: FND_MSG_PUB.Add;

2631:
2632: WHEN OTHERS THEN
2633: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2634: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2635: FND_MSG_PUB.Add;
2636:
2637: fnd_msg_pub.count_and_get(
2638: p_encoded => fnd_api.g_false
2639: ,p_count => l_msg_count

Line 2637: fnd_msg_pub.count_and_get(

2633: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2634: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2635: FND_MSG_PUB.Add;
2636:
2637: fnd_msg_pub.count_and_get(
2638: p_encoded => fnd_api.g_false
2639: ,p_count => l_msg_count
2640: ,p_data => l_msg_data
2641: );