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 1739: FND_MSG_PUB.initialize;

1735: AND rc.adjustment_reason_code = rlk_adj.lookup_code(+)
1736: AND rlk_adj.lookup_type(+) = 'ADJUST_REASON';
1737:
1738: BEGIN
1739: FND_MSG_PUB.initialize;
1740:
1741: l_activity_id := WF_ENGINE.getitemattrnumber(
1742: itemtype => itemtype
1743: ,itemkey => itemkey

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

1791: END IF;
1792:
1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1796: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1797: FND_MSG_PUB.add;
1798: END IF;
1799: IF OZF_DEBUG_LOW_ON THEN

Line 1797: FND_MSG_PUB.add;

1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1796: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1797: FND_MSG_PUB.add;
1798: END IF;
1799: IF OZF_DEBUG_LOW_ON THEN
1800: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1801: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1802: FND_MSG_PUB.Add;

1798: END IF;
1799: IF OZF_DEBUG_LOW_ON THEN
1800: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1801: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1802: FND_MSG_PUB.Add;
1803: END IF;
1804: RAISE FND_API.g_exc_unexpected_error;
1805: END;
1806:

Line 1973: FND_MSG_PUB.count_and_get(

1969: );
1970:
1971: resultout := 'COMPLETE:SUCCESS';
1972: ELSE
1973: FND_MSG_PUB.count_and_get(
1974: p_encoded => fnd_api.g_false
1975: ,p_count => l_msg_count
1976: ,p_data => l_msg_data
1977: );

Line 2036: FND_MSG_PUB.Add;

2032: --RAISE;
2033: WHEN OTHERS THEN
2034: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2035: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2036: FND_MSG_PUB.Add;
2037:
2038: FND_MSG_PUB.count_and_get (
2039: p_encoded => fnd_api.g_false
2040: ,p_count => l_msg_count

Line 2038: FND_MSG_PUB.count_and_get (

2034: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2035: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2036: FND_MSG_PUB.Add;
2037:
2038: FND_MSG_PUB.count_and_get (
2039: p_encoded => fnd_api.g_false
2040: ,p_count => l_msg_count
2041: ,p_data => l_msg_data
2042: );

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

2122: SET OBJECT_VERSION_NUMBER = l_object_version_number
2123: WHERE claim_id = p_claim_id;
2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2127: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2128: FND_MSG_PUB.add;
2129: END IF;
2130: IF OZF_DEBUG_LOW_ON THEN

Line 2128: FND_MSG_PUB.add;

2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2127: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2128: FND_MSG_PUB.add;
2129: END IF;
2130: IF OZF_DEBUG_LOW_ON THEN
2131: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2132: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 2133: FND_MSG_PUB.Add;

2129: END IF;
2130: IF OZF_DEBUG_LOW_ON THEN
2131: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2132: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2133: FND_MSG_PUB.Add;
2134: END IF;
2135: RAISE FND_API.g_exc_unexpected_error;
2136: END;
2137:

Line 2160: FND_MSG_PUB.Add;

2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2159: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');
2160: FND_MSG_PUB.Add;
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2162:
2163: END Start_Approval_Process;
2164:

Line 2295: FND_MSG_PUB.count_and_get (

2291: ,itemkey => itemkey
2292: ,aname => 'UPDATE_GEN_STATUS'
2293: ,avalue => l_update_status
2294: );
2295: FND_MSG_PUB.count_and_get (
2296: p_encoded => fnd_api.g_false
2297: ,p_count => l_msg_count
2298: ,p_data => l_msg_data
2299: );

Line 2482: FND_MSG_PUB.ADD;

2478: --set message.
2479: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2480: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2481: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2482: FND_MSG_PUB.ADD;
2483: FND_MSG_PUB.count_and_get (
2484: p_encoded => fnd_api.g_false
2485: ,p_count => l_msg_count
2486: ,p_data => l_msg_data

Line 2483: FND_MSG_PUB.count_and_get (

2479: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2480: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2481: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2482: FND_MSG_PUB.ADD;
2483: FND_MSG_PUB.count_and_get (
2484: p_encoded => fnd_api.g_false
2485: ,p_count => l_msg_count
2486: ,p_data => l_msg_data
2487: );

Line 2640: FND_MSG_PUB.count_and_get (

2636:
2637: IF l_return_status = fnd_api.g_ret_sts_success THEN
2638: resultout := 'COMPLETE:SUCCESS';
2639: ELSE
2640: FND_MSG_PUB.count_and_get (
2641: p_encoded => fnd_api.g_false
2642: ,p_count => l_msg_count
2643: ,p_data => l_msg_data
2644: );

Line 2681: fnd_msg_pub.count_and_get(

2677: resultout := 'COMPLETE:';
2678: RETURN;
2679: END IF;
2680:
2681: fnd_msg_pub.count_and_get(
2682: p_encoded => fnd_api.g_false
2683: ,p_count => l_msg_count
2684: ,p_data => l_msg_data
2685: );

Line 2703: FND_MSG_PUB.Add;

2699:
2700: WHEN OTHERS THEN
2701: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2702: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2703: FND_MSG_PUB.Add;
2704:
2705: fnd_msg_pub.count_and_get(
2706: p_encoded => fnd_api.g_false
2707: ,p_count => l_msg_count

Line 2705: fnd_msg_pub.count_and_get(

2701: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2702: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2703: FND_MSG_PUB.Add;
2704:
2705: fnd_msg_pub.count_and_get(
2706: p_encoded => fnd_api.g_false
2707: ,p_count => l_msg_count
2708: ,p_data => l_msg_data
2709: );