APPS.AMS_THRESHOLD_NOTIFY dependencies on FND_API

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38:
39: l_person_id number;
40:
41: BEGIN
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43:
44: OPEN c_resource ;
45: FETCH c_resource INTO l_person_id ;
46: IF c_resource%NOTFOUND THEN

Line 47: x_return_status := FND_API.G_RET_STS_ERROR;

43:
44: OPEN c_resource ;
45: FETCH c_resource INTO l_person_id ;
46: IF c_resource%NOTFOUND THEN
47: x_return_status := FND_API.G_RET_STS_ERROR;
48: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
49: FND_MSG_PUB.Add;
50: END IF;
51: CLOSE c_resource ;

Line 60: x_return_status := FND_API.G_RET_STS_ERROR;

56: p_name => x_role_name,
57: p_display_name => x_role_display_name );
58:
59: IF x_role_name is NULL THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
62: FND_MSG_PUB.Add;
63: END IF;
64: END Get_User_Role;

Line 109: IF NOT fnd_api.compatible_api_call(

105:
106: BEGIN
107: AMS_UTILITY_PVT.debug_message('Entering ams_threshold_notify.Start_process : ');
108:
109: IF NOT fnd_api.compatible_api_call(
110: l_api_version_number
111: ,p_api_version_number
112: ,l_api_name
113: ,g_pkg_name) THEN

Line 114: RAISE fnd_api.g_exc_unexpected_error;

110: l_api_version_number
111: ,p_api_version_number
112: ,l_api_name
113: ,g_pkg_name) THEN
114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
116:
117: -- Initialize API return status to SUCCESS
118: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
116:
117: -- Initialize API return status to SUCCESS
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120:
121: fnd_message.set_name('AMS', 'AMS_THRESHOLD_SUBJECT');
122: l_strSubject := fnd_message.get;

Line 133: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

129: x_role_name => l_owner_role,
130: x_role_display_name => l_owner_disp_name,
131: x_return_status => l_return_status);
132:
133: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137:

Line 134: RAISE FND_API.G_EXC_ERROR;

130: x_role_display_name => l_owner_disp_name,
131: x_return_status => l_return_status);
132:
133: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137:
138: -- we need to start 2 process here one for parent owner , other for budget owner

Line 156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

152: x_role_display_name => l_parent_disp_name,
153: x_return_status => l_return_status
154: );
155:
156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- Start process for parent owner.

Line 157: RAISE FND_API.G_EXC_ERROR;

153: x_return_status => l_return_status
154: );
155:
156: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- Start process for parent owner.
161: ams_generic_ntfy_pvt.StartProcess(p_activity_type => 'FTHO',

Line 175: WHEN FND_API.G_EXC_ERROR THEN

171: -- what about exception for above call?
172:
173: EXCEPTION
174:
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: -- Standard call to get message count and if count=1, get the message
178: FND_MSG_PUB.Count_And_Get (
179: p_encoded => FND_API.G_FALSE,

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172:
173: EXCEPTION
174:
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: -- Standard call to get message count and if count=1, get the message
178: FND_MSG_PUB.Count_And_Get (
179: p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,

Line 179: p_encoded => FND_API.G_FALSE,

175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: -- Standard call to get message count and if count=1, get the message
178: FND_MSG_PUB.Count_And_Get (
179: p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data
182: );
183:

Line 184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

180: p_count => x_msg_count,
181: p_data => x_msg_data
182: );
183:
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

181: p_data => x_msg_data
182: );
183:
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,

Line 188: p_encoded => FND_API.G_FALSE,

184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );
192:

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

190: p_data => x_msg_data
191: );
192:
193: WHEN OTHERS THEN
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN
197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
198: END IF;

Line 201: p_encoded => FND_API.G_FALSE,

197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
198: END IF;
199: -- Standard call to get message count and if count=1, get the message
200: FND_MSG_PUB.Count_And_Get (
201: p_encoded => FND_API.G_FALSE,
202: p_count => x_msg_count,
203: p_data => x_msg_data
204: );
205: