DBA Data[Home] [Help]

APPS.FND_PII_UTILITY_PVT dependencies on FND_API

Line 60: x_return_status := fnd_api.g_ret_sts_success;

56:
57: r_default c_default%rowtype;
58:
59: BEGIN
60: x_return_status := fnd_api.g_ret_sts_success;
61: l_ret_value := 'I';
62: l_api_name := 'GET_PURPOSE_OPTION';
63:
64: if(p_privacy_attribute_code is not null and p_party_id is not null and p_purpose_code is not null)

Line 109: WHEN FND_API.G_EXC_ERROR THEN

105:
106: return l_ret_value;
107:
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110: x_return_status := FND_API.G_RET_STS_ERROR ;
111: FND_MSG_PUB.Count_And_Get
112: (
113: p_count => x_msg_count,

Line 110: x_return_status := FND_API.G_RET_STS_ERROR ;

106: return l_ret_value;
107:
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110: x_return_status := FND_API.G_RET_STS_ERROR ;
111: FND_MSG_PUB.Count_And_Get
112: (
113: p_count => x_msg_count,
114: p_data => x_msg_data

Line 117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

113: p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116:
117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: (
121: p_count => x_msg_count,

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

114: p_data => x_msg_data
115: );
116:
117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: (
121: p_count => x_msg_count,
122: p_data => x_msg_data

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

128: fnd_message.set_token('P_SQLERRM',SQLERRM);
129: fnd_message.set_token('P_API_NAME',l_api_name);
130: FND_MSG_PUB.add;
131:
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
134: FND_MSG_PUB.Add_Exc_Msg
135: (
136: G_PKG_NAME,

Line 197: x_return_status := fnd_api.g_ret_sts_success;

193:
194:
195:
196: BEGIN
197: x_return_status := fnd_api.g_ret_sts_success;
198: l_ret_value := 'I';
199: l_api_name := 'GET_ATTRIBUTES';
200:
201: if(p_privacy_attribute_code is not null and p_party_id is not null)

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234:
235: return l_ret_value;
236:
237: EXCEPTION
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: FND_MSG_PUB.Count_And_Get
241: (
242: p_count => x_msg_count,

Line 239: x_return_status := FND_API.G_RET_STS_ERROR ;

235: return l_ret_value;
236:
237: EXCEPTION
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: FND_MSG_PUB.Count_And_Get
241: (
242: p_count => x_msg_count,
243: p_data => x_msg_data

Line 246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: FND_MSG_PUB.Count_And_Get
249: (
250: p_count => x_msg_count,

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

243: p_data => x_msg_data
244: );
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: FND_MSG_PUB.Count_And_Get
249: (
250: p_count => x_msg_count,
251: p_data => x_msg_data

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

257: fnd_message.set_token('P_SQLERRM',SQLERRM);
258: fnd_message.set_token('P_API_NAME',l_api_name);
259: FND_MSG_PUB.add;
260:
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
263: FND_MSG_PUB.Add_Exc_Msg
264: (
265: G_PKG_NAME,

Line 316: x_return_status := fnd_api.g_ret_sts_success;

312:
313: r_default c_default%rowtype;
314:
315: BEGIN
316: x_return_status := fnd_api.g_ret_sts_success;
317: l_ret_value := 'I';
318: l_api_name := 'GET_PURPOSE__ATTR_OPTION';
319:
320: if(p_purpose_code is not null and p_party_id is not null)

Line 347: WHEN FND_API.G_EXC_ERROR THEN

343:
344: return l_ret_value;
345:
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: x_return_status := FND_API.G_RET_STS_ERROR ;
349: FND_MSG_PUB.Count_And_Get
350: (
351: p_count => x_msg_count,

Line 348: x_return_status := FND_API.G_RET_STS_ERROR ;

344: return l_ret_value;
345:
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: x_return_status := FND_API.G_RET_STS_ERROR ;
349: FND_MSG_PUB.Count_And_Get
350: (
351: p_count => x_msg_count,
352: p_data => x_msg_data

Line 355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

351: p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
357: FND_MSG_PUB.Count_And_Get
358: (
359: p_count => x_msg_count,

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

352: p_data => x_msg_data
353: );
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
357: FND_MSG_PUB.Count_And_Get
358: (
359: p_count => x_msg_count,
360: p_data => x_msg_data

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

366: fnd_message.set_token('P_SQLERRM',SQLERRM);
367: fnd_message.set_token('P_API_NAME',l_api_name);
368: FND_MSG_PUB.add;
369:
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
372: FND_MSG_PUB.Add_Exc_Msg
373: (
374: G_PKG_NAME,