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.CSD_PARTIES_UTIL dependencies on FND_API

Line 39: p_commit IN VARCHAR2 := fnd_api.g_false,

35: /*----------------------------------------------------------------*/
36: PROCEDURE Get_EmailDetails
37: (
38: p_api_version IN NUMBER,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
42: p_party_id IN NUMBER,
43: x_email_cnt_point_id OUT NOCOPY NUMBER,

Line 40: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

36: PROCEDURE Get_EmailDetails
37: (
38: p_api_version IN NUMBER,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
42: p_party_id IN NUMBER,
43: x_email_cnt_point_id OUT NOCOPY NUMBER,
44: x_email_last_update_date OUT NOCOPY DATE,

Line 41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

37: (
38: p_api_version IN NUMBER,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
41: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
42: p_party_id IN NUMBER,
43: x_email_cnt_point_id OUT NOCOPY NUMBER,
44: x_email_last_update_date OUT NOCOPY DATE,
45: x_return_status OUT NOCOPY VARCHAR2,

Line 66: IF NOT FND_API.Compatible_API_Call (l_api_version,

62: -- Standard Start of API savepoint
63: SAVEPOINT Get_EmailDetails_Utl;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call (l_api_version,
67: p_api_version,
68: l_api_name,
69: G_PKG_NAME)
70: THEN

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: p_api_version,
68: l_api_name,
69: G_PKG_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 75: IF FND_API.to_Boolean(p_init_msg_list) THEN

71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean(p_init_msg_list) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to success

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: --
83: -- Begin API Body
84: --

Line 95: IF FND_API.To_Boolean( p_commit ) THEN

91: -- End API Body
92: --
93:
94: -- Standard check of p_commit.
95: IF FND_API.To_Boolean( p_commit ) THEN
96: COMMIT WORK;
97: END IF;
98:
99: -- Standard call to get message count and IF count is get message info.

Line 104: WHEN FND_API.G_EXC_ERROR THEN

100: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
101: p_data => x_msg_data );
102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO Get_EmailDetails_Utl;
106: x_return_status := FND_API.G_RET_STS_ERROR ;
107: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
108: p_data => x_msg_data);

Line 106: x_return_status := FND_API.G_RET_STS_ERROR ;

102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO Get_EmailDetails_Utl;
106: x_return_status := FND_API.G_RET_STS_ERROR ;
107: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
108: p_data => x_msg_data);
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO Get_EmailDetails_Utl;

Line 109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

105: ROLLBACK TO Get_EmailDetails_Utl;
106: x_return_status := FND_API.G_RET_STS_ERROR ;
107: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
108: p_data => x_msg_data);
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO Get_EmailDetails_Utl;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
113: p_data => x_msg_data );

Line 111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

107: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
108: p_data => x_msg_data);
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO Get_EmailDetails_Utl;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
113: p_data => x_msg_data );
114: WHEN OTHERS THEN
115: ROLLBACK TO Get_EmailDetails_Utl;

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

112: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
113: p_data => x_msg_data );
114: WHEN OTHERS THEN
115: ROLLBACK TO Get_EmailDetails_Utl;
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
118: THEN
119: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
120: l_api_name );

Line 151: p_commit IN VARCHAR2 := fnd_api.g_false,

147: /*----------------------------------------------------------------*/
148: PROCEDURE Get_AddrDetails
149: (
150: p_api_version IN NUMBER,
151: p_commit IN VARCHAR2 := fnd_api.g_false,
152: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
153: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
154: p_party_id IN NUMBER,
155: x_addr_location_id OUT NOCOPY NUMBER,

Line 152: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

148: PROCEDURE Get_AddrDetails
149: (
150: p_api_version IN NUMBER,
151: p_commit IN VARCHAR2 := fnd_api.g_false,
152: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
153: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
154: p_party_id IN NUMBER,
155: x_addr_location_id OUT NOCOPY NUMBER,
156: x_party_site_id OUT NOCOPY NUMBER,

Line 153: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

149: (
150: p_api_version IN NUMBER,
151: p_commit IN VARCHAR2 := fnd_api.g_false,
152: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
153: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
154: p_party_id IN NUMBER,
155: x_addr_location_id OUT NOCOPY NUMBER,
156: x_party_site_id OUT NOCOPY NUMBER,
157: x_addr_last_update_date OUT NOCOPY DATE,

Line 182: IF NOT FND_API.Compatible_API_Call (l_api_version,

178: -- Standard Start of API savepoint
179: SAVEPOINT Get_AddrDetails_Utl;
180:
181: -- Standard call to check for call compatibility.
182: IF NOT FND_API.Compatible_API_Call (l_api_version,
183: p_api_version,
184: l_api_name,
185: G_PKG_NAME)
186: THEN

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183: p_api_version,
184: l_api_name,
185: G_PKG_NAME)
186: THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: -- Initialize message list if p_init_msg_list is set to TRUE.
191: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 191: IF FND_API.to_Boolean(p_init_msg_list) THEN

187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: -- Initialize message list if p_init_msg_list is set to TRUE.
191: IF FND_API.to_Boolean(p_init_msg_list) THEN
192: FND_MSG_PUB.initialize;
193: END IF;
194:
195: -- Initialize API return status to success

Line 196: x_return_status := FND_API.G_RET_STS_SUCCESS;

192: FND_MSG_PUB.initialize;
193: END IF;
194:
195: -- Initialize API return status to success
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197:
198: --
199: -- Begin API Body
200: --

Line 213: IF FND_API.To_Boolean( p_commit ) THEN

209: -- End API Body
210: --
211:
212: -- Standard check of p_commit.
213: IF FND_API.To_Boolean( p_commit ) THEN
214: COMMIT WORK;
215: END IF;
216:
217: -- Standard call to get message count and IF count is get message info.

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
219: p_data => x_msg_data );
220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Get_AddrDetails_Utl;
224: x_return_status := FND_API.G_RET_STS_ERROR ;
225: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
226: p_data => x_msg_data);

Line 224: x_return_status := FND_API.G_RET_STS_ERROR ;

220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Get_AddrDetails_Utl;
224: x_return_status := FND_API.G_RET_STS_ERROR ;
225: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
226: p_data => x_msg_data);
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Get_AddrDetails_Utl;

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

223: ROLLBACK TO Get_AddrDetails_Utl;
224: x_return_status := FND_API.G_RET_STS_ERROR ;
225: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
226: p_data => x_msg_data);
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Get_AddrDetails_Utl;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
231: p_data => x_msg_data );

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

225: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
226: p_data => x_msg_data);
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Get_AddrDetails_Utl;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
231: p_data => x_msg_data );
232: WHEN OTHERS THEN
233: ROLLBACK TO Get_AddrDetails_Utl;

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

230: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
231: p_data => x_msg_data );
232: WHEN OTHERS THEN
233: ROLLBACK TO Get_AddrDetails_Utl;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
238: l_api_name );

Line 265: p_commit IN VARCHAR2 := fnd_api.g_false,

261: /*----------------------------------------------------------------*/
262: PROCEDURE Get_PhoneDetails
263: (
264: p_api_version IN NUMBER,
265: p_commit IN VARCHAR2 := fnd_api.g_false,
266: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
267: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
268: p_phone_cnt_point_id IN NUMBER,
269: x_phone_last_update_date OUT NOCOPY DATE,

Line 266: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

262: PROCEDURE Get_PhoneDetails
263: (
264: p_api_version IN NUMBER,
265: p_commit IN VARCHAR2 := fnd_api.g_false,
266: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
267: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
268: p_phone_cnt_point_id IN NUMBER,
269: x_phone_last_update_date OUT NOCOPY DATE,
270: x_return_status OUT NOCOPY VARCHAR2,

Line 267: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

263: (
264: p_api_version IN NUMBER,
265: p_commit IN VARCHAR2 := fnd_api.g_false,
266: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
267: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
268: p_phone_cnt_point_id IN NUMBER,
269: x_phone_last_update_date OUT NOCOPY DATE,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,

Line 288: IF NOT FND_API.Compatible_API_Call (l_api_version,

284: -- Standard Start of API savepoint
285: SAVEPOINT Get_PhoneDetails_Utl;
286:
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call (l_api_version,
289: p_api_version,
290: l_api_name,
291: G_PKG_NAME)
292: THEN

Line 293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

289: p_api_version,
290: l_api_name,
291: G_PKG_NAME)
292: THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 297: IF FND_API.to_Boolean(p_init_msg_list) THEN

293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297: IF FND_API.to_Boolean(p_init_msg_list) THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301: -- Initialize API return status to success

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298: FND_MSG_PUB.initialize;
299: END IF;
300:
301: -- Initialize API return status to success
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: --
305: -- Begin API Body
306: --

Line 316: IF FND_API.To_Boolean( p_commit ) THEN

312: -- End API Body
313: --
314:
315: -- Standard check of p_commit.
316: IF FND_API.To_Boolean( p_commit ) THEN
317: COMMIT WORK;
318: END IF;
319:
320: -- Standard call to get message count and IF count is get message info.

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
322: p_data => x_msg_data );
323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO Get_PhoneDetails_Utl;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
329: p_data => x_msg_data);

Line 327: x_return_status := FND_API.G_RET_STS_ERROR ;

323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO Get_PhoneDetails_Utl;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: ROLLBACK TO Get_PhoneDetails_Utl;

Line 330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

326: ROLLBACK TO Get_PhoneDetails_Utl;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: ROLLBACK TO Get_PhoneDetails_Utl;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
334: p_data => x_msg_data );

Line 332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

328: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: ROLLBACK TO Get_PhoneDetails_Utl;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
334: p_data => x_msg_data );
335: WHEN OTHERS THEN
336: ROLLBACK TO Get_PhoneDetails_Utl;

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

333: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
334: p_data => x_msg_data );
335: WHEN OTHERS THEN
336: ROLLBACK TO Get_PhoneDetails_Utl;
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
341: l_api_name );

Line 367: p_commit IN VARCHAR2 := fnd_api.g_false,

363: /*----------------------------------------------------------------*/
364: PROCEDURE Get_PartyDetails
365: (
366: p_api_version IN NUMBER,
367: p_commit IN VARCHAR2 := fnd_api.g_false,
368: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
369: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
370: p_party_id IN NUMBER,
371: x_last_update_date OUT NOCOPY DATE,

Line 368: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

364: PROCEDURE Get_PartyDetails
365: (
366: p_api_version IN NUMBER,
367: p_commit IN VARCHAR2 := fnd_api.g_false,
368: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
369: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
370: p_party_id IN NUMBER,
371: x_last_update_date OUT NOCOPY DATE,
372: x_return_status OUT NOCOPY VARCHAR2,

Line 369: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

365: (
366: p_api_version IN NUMBER,
367: p_commit IN VARCHAR2 := fnd_api.g_false,
368: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
369: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
370: p_party_id IN NUMBER,
371: x_last_update_date OUT NOCOPY DATE,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,

Line 389: IF NOT FND_API.Compatible_API_Call (l_api_version,

385: -- Standard Start of API savepoint
386: SAVEPOINT Get_PartyDetails_Utl;
387:
388: -- Standard call to check for call compatibility.
389: IF NOT FND_API.Compatible_API_Call (l_api_version,
390: p_api_version,
391: l_api_name,
392: G_PKG_NAME)
393: THEN

Line 394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

390: p_api_version,
391: l_api_name,
392: G_PKG_NAME)
393: THEN
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE.
398: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 398: IF FND_API.to_Boolean(p_init_msg_list) THEN

394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE.
398: IF FND_API.to_Boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Initialize API return status to success

Line 403: x_return_status := FND_API.G_RET_STS_SUCCESS;

399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Initialize API return status to success
403: x_return_status := FND_API.G_RET_STS_SUCCESS;
404:
405: --
406: -- Begin API Body
407: --

Line 418: IF FND_API.To_Boolean( p_commit ) THEN

414: -- End API Body
415: --
416:
417: -- Standard check of p_commit.
418: IF FND_API.To_Boolean( p_commit ) THEN
419: COMMIT WORK;
420: END IF;
421:
422: -- Standard call to get message count and IF count is get message info.

Line 427: WHEN FND_API.G_EXC_ERROR THEN

423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
424: p_data => x_msg_data );
425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Get_PartyDetails_Utl;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
431: p_data => x_msg_data);

Line 429: x_return_status := FND_API.G_RET_STS_ERROR ;

425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Get_PartyDetails_Utl;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
431: p_data => x_msg_data);
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO Get_PartyDetails_Utl;

Line 432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

428: ROLLBACK TO Get_PartyDetails_Utl;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
431: p_data => x_msg_data);
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO Get_PartyDetails_Utl;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
436: p_data => x_msg_data );

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

430: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
431: p_data => x_msg_data);
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO Get_PartyDetails_Utl;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
436: p_data => x_msg_data );
437: WHEN OTHERS THEN
438: ROLLBACK TO Get_PartyDetails_Utl;

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

435: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
436: p_data => x_msg_data );
437: WHEN OTHERS THEN
438: ROLLBACK TO Get_PartyDetails_Utl;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
443: l_api_name );