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

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

122: --
123: -- DESCRIPTION
124: -- Create a party site business object.
125: PROCEDURE do_create_party_site_bo(
126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
127: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
128: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
129: p_created_by_module IN VARCHAR2,
130: p_obj_source IN VARCHAR2 := null,

Line 127: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

123: -- DESCRIPTION
124: -- Create a party site business object.
125: PROCEDURE do_create_party_site_bo(
126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
127: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
128: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
129: p_created_by_module IN VARCHAR2,
130: p_obj_source IN VARCHAR2 := null,
131: x_return_status OUT NOCOPY VARCHAR2,

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

157: -- Standard start of API savepoint
158: SAVEPOINT do_create_party_site_bo_pub;
159:
160: -- initialize API return status to success.
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- Initialize message list of p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean(p_init_msg_list) THEN
165: FND_MSG_PUB.initialize;

Line 164: IF FND_API.to_Boolean(p_init_msg_list) THEN

160: -- initialize API return status to success.
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- Initialize message list of p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean(p_init_msg_list) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167:
168: -- initialize Global variable

Line 184: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

180: p_msg_level=>fnd_log.level_procedure);
181: END IF;
182:
183: -- Base on p_validate_bo_flag, check the completeness of business objects
184: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
185: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
186: p_bus_object_code => 'PARTY_SITE',
187: x_bus_object => l_bus_object
188: );

Line 195: RAISE fnd_api.g_exc_error;

191: p_ps_objs => HZ_PARTY_SITE_BO_TBL(p_party_site_obj),
192: p_bus_object => l_bus_object
193: );
194: IF NOT(l_valid_obj) THEN
195: RAISE fnd_api.g_exc_error;
196: END IF;
197: END IF;
198:
199: -- check pass in parent_id and parent_os+osr

Line 209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

205: x_return_status => x_return_status,
206: x_msg_count => x_msg_count,
207: x_msg_data => x_msg_data);
208:
209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:
213: x_party_site_id := p_party_site_obj.party_site_id;

Line 210: RAISE FND_API.G_EXC_ERROR;

206: x_msg_count => x_msg_count,
207: x_msg_data => x_msg_data);
208:
209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:
213: x_party_site_id := p_party_site_obj.party_site_id;
214: x_party_site_os := p_party_site_obj.orig_system;

Line 228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

224: x_return_status => x_return_status,
225: x_msg_count => x_msg_count,
226: x_msg_data => x_msg_data);
227:
228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: ----------------------------

Line 229: RAISE FND_API.G_EXC_ERROR;

225: x_msg_count => x_msg_count,
226: x_msg_data => x_msg_data);
227:
228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: ----------------------------
233: -- For location record

Line 239: RAISE FND_API.G_EXC_ERROR;

235: IF(p_party_site_obj.location_obj IS NULL) THEN
236: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
237: fnd_message.set_token('ENTITY' ,'LOCATION');
238: fnd_msg_pub.add;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:
242: HZ_LOCATION_BO_PUB.assign_location_rec(
243: p_location_obj => p_party_site_obj.location_obj,

Line 257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

253: x_msg_count => x_msg_count,
254: x_msg_data => x_msg_data
255: );
256:
257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
259: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
260: FND_MSG_PUB.ADD;
261: RAISE FND_API.G_EXC_ERROR;

Line 261: RAISE FND_API.G_EXC_ERROR;

257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
259: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
260: FND_MSG_PUB.ADD;
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: -- assign location_id
265: p_party_site_obj.location_obj.location_id := l_location_id;

Line 282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

278: x_msg_count => x_msg_count,
279: x_msg_data => x_msg_data
280: );
281:
282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285: END IF;
286:

Line 283: RAISE FND_API.G_EXC_ERROR;

279: x_msg_data => x_msg_data
280: );
281:
282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285: END IF;
286:
287: ----------------------------

Line 309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

305: x_msg_count => x_msg_count,
306: x_msg_data => x_msg_data
307: );
308:
309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: -- assign party_site_id

Line 310: RAISE FND_API.G_EXC_ERROR;

306: x_msg_data => x_msg_data
307: );
308:
309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: -- assign party_site_id
314: p_party_site_obj.party_site_id := x_party_site_id;

Line 331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

327: x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data
329: );
330:
331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334: END IF;
335:

Line 332: RAISE FND_API.G_EXC_ERROR;

328: x_msg_data => x_msg_data
329: );
330:
331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334: END IF;
335:
336: ------------------------

Line 349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data
347: );
348:
349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352: END IF;
353:

Line 350: RAISE FND_API.G_EXC_ERROR;

346: x_msg_data => x_msg_data
347: );
348:
349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352: END IF;
353:
354: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

378: x_msg_count => x_msg_count,
379: x_msg_data => x_msg_data
380: );
381:
382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385: END IF;
386:

Line 383: RAISE FND_API.G_EXC_ERROR;

379: x_msg_data => x_msg_data
380: );
381:
382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385: END IF;
386:
387: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

399: x_msg_count => x_msg_count,
400: x_msg_data => x_msg_data
401: );
402:
403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
404: RAISE FND_API.G_EXC_ERROR;
405: END IF;
406: END IF;
407:

Line 404: RAISE FND_API.G_EXC_ERROR;

400: x_msg_data => x_msg_data
401: );
402:
403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
404: RAISE FND_API.G_EXC_ERROR;
405: END IF;
406: END IF;
407:
408: -- reset Global variable

Line 426: WHEN fnd_api.g_exc_error THEN

422: p_msg_level=>fnd_log.level_procedure);
423: END IF;
424:
425: EXCEPTION
426: WHEN fnd_api.g_exc_error THEN
427: ROLLBACK TO do_create_party_site_bo_pub;
428:
429: -- reset Global variable
430: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 437: x_return_status := fnd_api.g_ret_sts_error;

433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
434: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
435: FND_MSG_PUB.ADD;
436:
437: x_return_status := fnd_api.g_ret_sts_error;
438:
439: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
440: p_count => x_msg_count,
441: p_data => x_msg_data);

Line 439: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

435: FND_MSG_PUB.ADD;
436:
437: x_return_status := fnd_api.g_ret_sts_error;
438:
439: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
440: p_count => x_msg_count,
441: p_data => x_msg_data);
442:
443: -- Debug info.

Line 456: WHEN fnd_api.g_exc_unexpected_error THEN

452: p_prefix=>l_debug_prefix,
453: p_msg_level=>fnd_log.level_procedure);
454: END IF;
455:
456: WHEN fnd_api.g_exc_unexpected_error THEN
457: ROLLBACK TO do_create_party_site_bo_pub;
458:
459: -- reset Global variable
460: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 467: x_return_status := fnd_api.g_ret_sts_unexp_error;

463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
464: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
465: FND_MSG_PUB.ADD;
466:
467: x_return_status := fnd_api.g_ret_sts_unexp_error;
468:
469: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data);

Line 469: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

465: FND_MSG_PUB.ADD;
466:
467: x_return_status := fnd_api.g_ret_sts_unexp_error;
468:
469: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data);
472:
473: -- Debug info.

Line 497: x_return_status := fnd_api.g_ret_sts_unexp_error;

493: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
494: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
495: FND_MSG_PUB.ADD;
496:
497: x_return_status := fnd_api.g_ret_sts_unexp_error;
498:
499: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
500: fnd_message.set_token('ERROR' ,SQLERRM);
501: fnd_msg_pub.add;

Line 503: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

499: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
500: fnd_message.set_token('ERROR' ,SQLERRM);
501: fnd_msg_pub.add;
502:
503: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data);
506:
507: -- Debug info.

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

518: END IF;
519: END do_create_party_site_bo;
520:
521: PROCEDURE create_party_site_bo(
522: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
523: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
524: p_party_site_obj IN HZ_PARTY_SITE_BO,
525: p_created_by_module IN VARCHAR2,
526: x_return_status OUT NOCOPY VARCHAR2,

Line 523: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

519: END do_create_party_site_bo;
520:
521: PROCEDURE create_party_site_bo(
522: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
523: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
524: p_party_site_obj IN HZ_PARTY_SITE_BO,
525: p_created_by_module IN VARCHAR2,
526: x_return_status OUT NOCOPY VARCHAR2,
527: x_msg_count OUT NOCOPY NUMBER,

Line 560: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

556: );
557: END create_party_site_bo;
558:
559: PROCEDURE create_party_site_bo(
560: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
561: p_party_site_obj IN HZ_PARTY_SITE_BO,
562: p_created_by_module IN VARCHAR2,
563: p_obj_source IN VARCHAR2 := null,
564: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

Line 564: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

560: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
561: p_party_site_obj IN HZ_PARTY_SITE_BO,
562: p_created_by_module IN VARCHAR2,
563: p_obj_source IN VARCHAR2 := null,
564: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
565: x_return_status OUT NOCOPY VARCHAR2,
566: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
567: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,
568: x_party_site_id OUT NOCOPY NUMBER,

Line 582: p_init_msg_list => fnd_api.g_true,

578: l_ps_obj HZ_PARTY_SITE_BO;
579: BEGIN
580: l_ps_obj := p_party_site_obj;
581: do_create_party_site_bo(
582: p_init_msg_list => fnd_api.g_true,
583: p_validate_bo_flag => p_validate_bo_flag,
584: p_party_site_obj => l_ps_obj,
585: p_created_by_module => p_created_by_module,
586: p_obj_source => p_obj_source,

Line 602: IF FND_API.to_Boolean(p_return_obj_flag) THEN

598: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
599: x_return_status => x_return_status,
600: x_msg_count => l_msg_count,
601: x_msg_data => l_msg_data);
602: IF FND_API.to_Boolean(p_return_obj_flag) THEN
603: x_return_obj := l_ps_obj;
604: END IF;
605: END create_party_site_bo;
606:

Line 617: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

613: --
614: -- ARGUMENTS
615: -- IN:
616: -- p_init_msg_list Initialize message stack if it is set to
617: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
618: -- p_party_site_obj Party site business object.
619: -- p_created_by_module Created by module.
620: -- OUT:
621: -- x_return_status Return status after the call. The status can

Line 622: -- be fnd_api.g_ret_sts_success (success),

618: -- p_party_site_obj Party site business object.
619: -- p_created_by_module Created by module.
620: -- OUT:
621: -- x_return_status Return status after the call. The status can
622: -- be fnd_api.g_ret_sts_success (success),
623: -- fnd_api.g_ret_sts_error (error),
624: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
625: -- x_msg_count Number of messages in message stack.
626: -- x_msg_data Message text if x_msg_count is 1.

Line 623: -- fnd_api.g_ret_sts_error (error),

619: -- p_created_by_module Created by module.
620: -- OUT:
621: -- x_return_status Return status after the call. The status can
622: -- be fnd_api.g_ret_sts_success (success),
623: -- fnd_api.g_ret_sts_error (error),
624: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
625: -- x_msg_count Number of messages in message stack.
626: -- x_msg_data Message text if x_msg_count is 1.
627: -- x_party_site_id Party Site ID.

Line 624: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

620: -- OUT:
621: -- x_return_status Return status after the call. The status can
622: -- be fnd_api.g_ret_sts_success (success),
623: -- fnd_api.g_ret_sts_error (error),
624: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
625: -- x_msg_count Number of messages in message stack.
626: -- x_msg_data Message text if x_msg_count is 1.
627: -- x_party_site_id Party Site ID.
628: -- x_party_site_os Party Site orig system.

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

635: -- 14-DEC-2004 Arnold Ng Created.
636: --
637:
638: PROCEDURE update_party_site_bo(
639: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
640: p_party_site_obj IN HZ_PARTY_SITE_BO,
641: p_created_by_module IN VARCHAR2,
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_msg_count OUT NOCOPY NUMBER,

Line 670: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

666: PROCEDURE update_party_site_bo(
667: p_party_site_obj IN HZ_PARTY_SITE_BO,
668: p_created_by_module IN VARCHAR2,
669: p_obj_source IN VARCHAR2 := null,
670: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
671: x_return_status OUT NOCOPY VARCHAR2,
672: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
673: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,
674: x_party_site_id OUT NOCOPY NUMBER,

Line 684: p_init_msg_list => fnd_api.g_true,

680: l_ps_obj HZ_PARTY_SITE_BO;
681: BEGIN
682: l_ps_obj := p_party_site_obj;
683: do_update_party_site_bo(
684: p_init_msg_list => fnd_api.g_true,
685: p_party_site_obj => l_ps_obj,
686: p_created_by_module => p_created_by_module,
687: p_obj_source => p_obj_source,
688: x_return_status => x_return_status,

Line 700: IF FND_API.to_Boolean(p_return_obj_flag) THEN

696: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
697: x_return_status => x_return_status,
698: x_msg_count => l_msg_count,
699: x_msg_data => l_msg_data);
700: IF FND_API.to_Boolean(p_return_obj_flag) THEN
701: x_return_obj := l_ps_obj;
702: END IF;
703: END update_party_site_bo;
704:

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

706: --
707: -- DESCRIPTION
708: -- Update party site business object.
709: PROCEDURE do_update_party_site_bo(
710: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
711: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
712: p_created_by_module IN VARCHAR2,
713: p_obj_source IN VARCHAR2 := null,
714: x_return_status OUT NOCOPY VARCHAR2,

Line 750: x_return_status := FND_API.G_RET_STS_SUCCESS;

746: -- Standard start of API savepoint
747: SAVEPOINT do_update_party_site_bo_pub;
748:
749: -- initialize API return status to success.
750: x_return_status := FND_API.G_RET_STS_SUCCESS;
751:
752: -- Initialize message list of p_init_msg_list is set to TRUE.
753: IF FND_API.to_Boolean(p_init_msg_list) THEN
754: FND_MSG_PUB.initialize;

Line 753: IF FND_API.to_Boolean(p_init_msg_list) THEN

749: -- initialize API return status to success.
750: x_return_status := FND_API.G_RET_STS_SUCCESS;
751:
752: -- Initialize message list of p_init_msg_list is set to TRUE.
753: IF FND_API.to_Boolean(p_init_msg_list) THEN
754: FND_MSG_PUB.initialize;
755: END IF;
756:
757: -- initialize Global variable

Line 788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

784: x_return_status => x_return_status,
785: x_msg_count => x_msg_count,
786: x_msg_data => x_msg_data);
787:
788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791:
792: OPEN get_ovn(x_party_site_id);

Line 789: RAISE FND_API.G_EXC_ERROR;

785: x_msg_count => x_msg_count,
786: x_msg_data => x_msg_data);
787:
788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791:
792: OPEN get_ovn(x_party_site_id);
793: FETCH get_ovn INTO l_ps_ovn, l_loc_ovn, l_party_id, l_location_id;

Line 818: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

814: x_msg_count => x_msg_count,
815: x_msg_data => x_msg_data
816: );
817:
818: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
819: FND_MSG_PUB.ADD;
820: RAISE FND_API.G_EXC_ERROR;
821: END IF;
822:

Line 820: RAISE FND_API.G_EXC_ERROR;

816: );
817:
818: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
819: FND_MSG_PUB.ADD;
820: RAISE FND_API.G_EXC_ERROR;
821: END IF;
822:
823: -- assign party_site_id
824: p_party_site_obj.party_site_id := x_party_site_id;

Line 841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

837: x_msg_count => x_msg_count,
838: x_msg_data => x_msg_data
839: );
840:
841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: END IF;
845:

Line 842: RAISE FND_API.G_EXC_ERROR;

838: x_msg_data => x_msg_data
839: );
840:
841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: END IF;
845:
846: ----------------------

Line 870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

866: x_msg_count => x_msg_count,
867: x_msg_data => x_msg_data
868: );
869:
870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
871: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
872: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_ERROR;

Line 874: RAISE FND_API.G_EXC_ERROR;

870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
871: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
872: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876:
877: -- assign location_id
878: p_party_site_obj.location_obj.location_id := l_location_id;

Line 895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

891: x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data
893: );
894:
895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898: END IF;
899: END IF;

Line 896: RAISE FND_API.G_EXC_ERROR;

892: x_msg_data => x_msg_data
893: );
894:
895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898: END IF;
899: END IF;
900:

Line 914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

910: x_msg_count => x_msg_count,
911: x_msg_data => x_msg_data
912: );
913:
914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917: END IF;
918:

Line 915: RAISE FND_API.G_EXC_ERROR;

911: x_msg_data => x_msg_data
912: );
913:
914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917: END IF;
918:
919: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

943: x_msg_count => x_msg_count,
944: x_msg_data => x_msg_data
945: );
946:
947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951:

Line 948: RAISE FND_API.G_EXC_ERROR;

944: x_msg_data => x_msg_data
945: );
946:
947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951:
952: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 968: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

964: x_msg_count => x_msg_count,
965: x_msg_data => x_msg_data
966: );
967:
968: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: END IF;
972:

Line 969: RAISE FND_API.G_EXC_ERROR;

965: x_msg_data => x_msg_data
966: );
967:
968: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: END IF;
972:
973: -- reset Global variable

Line 991: WHEN fnd_api.g_exc_error THEN

987: p_msg_level=>fnd_log.level_procedure);
988: END IF;
989:
990: EXCEPTION
991: WHEN fnd_api.g_exc_error THEN
992: ROLLBACK TO do_update_party_site_bo_pub;
993:
994: -- reset Global variable
995: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1002: x_return_status := fnd_api.g_ret_sts_error;

998: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
999: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1000: FND_MSG_PUB.ADD;
1001:
1002: x_return_status := fnd_api.g_ret_sts_error;
1003:
1004: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1005: p_count => x_msg_count,
1006: p_data => x_msg_data);

Line 1004: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1000: FND_MSG_PUB.ADD;
1001:
1002: x_return_status := fnd_api.g_ret_sts_error;
1003:
1004: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1005: p_count => x_msg_count,
1006: p_data => x_msg_data);
1007:
1008: -- Debug info.

Line 1021: WHEN fnd_api.g_exc_unexpected_error THEN

1017: p_prefix=>l_debug_prefix,
1018: p_msg_level=>fnd_log.level_procedure);
1019: END IF;
1020:
1021: WHEN fnd_api.g_exc_unexpected_error THEN
1022: ROLLBACK TO do_update_party_site_bo_pub;
1023:
1024: -- reset Global variable
1025: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1032: x_return_status := fnd_api.g_ret_sts_unexp_error;

1028: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1029: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1030: FND_MSG_PUB.ADD;
1031:
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033:
1034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data);

Line 1034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1030: FND_MSG_PUB.ADD;
1031:
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033:
1034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data);
1037:
1038: -- Debug info.

Line 1062: x_return_status := fnd_api.g_ret_sts_unexp_error;

1058: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1059: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1060: FND_MSG_PUB.ADD;
1061:
1062: x_return_status := fnd_api.g_ret_sts_unexp_error;
1063:
1064: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1065: fnd_message.set_token('ERROR' ,SQLERRM);
1066: fnd_msg_pub.add;

Line 1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1064: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1065: fnd_message.set_token('ERROR' ,SQLERRM);
1066: fnd_msg_pub.add;
1067:
1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1069: p_count => x_msg_count,
1070: p_data => x_msg_data);
1071:
1072: -- Debug info.

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

1087: --
1088: -- DESCRIPTION
1089: -- Create or update a party site business object.
1090: PROCEDURE do_save_party_site_bo(
1091: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1092: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1093: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
1094: p_created_by_module IN VARCHAR2,
1095: p_obj_source IN VARCHAR2 := null,

Line 1092: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1088: -- DESCRIPTION
1089: -- Create or update a party site business object.
1090: PROCEDURE do_save_party_site_bo(
1091: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1092: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1093: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
1094: p_created_by_module IN VARCHAR2,
1095: p_obj_source IN VARCHAR2 := null,
1096: x_return_status OUT NOCOPY VARCHAR2,

Line 1114: x_return_status := FND_API.G_RET_STS_SUCCESS;

1110: l_create_update_flag VARCHAR2(1);
1111: l_debug_prefix VARCHAR2(30);
1112: BEGIN
1113: -- initialize API return status to success.
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:
1116: -- Initialize message list of p_init_msg_list is set to TRUE.
1117: IF FND_API.to_Boolean(p_init_msg_list) THEN
1118: FND_MSG_PUB.initialize;

Line 1117: IF FND_API.to_Boolean(p_init_msg_list) THEN

1113: -- initialize API return status to success.
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:
1116: -- Initialize message list of p_init_msg_list is set to TRUE.
1117: IF FND_API.to_Boolean(p_init_msg_list) THEN
1118: FND_MSG_PUB.initialize;
1119: END IF;
1120:
1121: -- Debug info.

Line 1146: RAISE FND_API.G_EXC_ERROR;

1142: IF(l_create_update_flag = 'E') THEN
1143: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1144: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:
1149: IF(l_create_update_flag = 'C') THEN
1150: do_create_party_site_bo(

Line 1151: p_init_msg_list => fnd_api.g_false,

1147: END IF;
1148:
1149: IF(l_create_update_flag = 'C') THEN
1150: do_create_party_site_bo(
1151: p_init_msg_list => fnd_api.g_false,
1152: p_validate_bo_flag => p_validate_bo_flag,
1153: p_party_site_obj => p_party_site_obj,
1154: p_created_by_module => p_created_by_module,
1155: p_obj_source => p_obj_source,

Line 1169: p_init_msg_list => fnd_api.g_false,

1165: px_parent_obj_type => px_parent_obj_type
1166: );
1167: ELSIF(l_create_update_flag = 'U') THEN
1168: do_update_party_site_bo(
1169: p_init_msg_list => fnd_api.g_false,
1170: p_party_site_obj => p_party_site_obj,
1171: p_created_by_module => p_created_by_module,
1172: p_obj_source => p_obj_source,
1173: x_return_status => x_return_status,

Line 1181: RAISE FND_API.G_EXC_ERROR;

1177: x_party_site_os => x_party_site_os,
1178: x_party_site_osr => x_party_site_osr,
1179: p_parent_os => px_parent_os );
1180: ELSE
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183:
1184: -- Debug info.
1185: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1198: WHEN fnd_api.g_exc_error THEN

1194: p_msg_level=>fnd_log.level_procedure);
1195: END IF;
1196:
1197: EXCEPTION
1198: WHEN fnd_api.g_exc_error THEN
1199: x_return_status := fnd_api.g_ret_sts_error;
1200:
1201: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1202: p_count => x_msg_count,

Line 1199: x_return_status := fnd_api.g_ret_sts_error;

1195: END IF;
1196:
1197: EXCEPTION
1198: WHEN fnd_api.g_exc_error THEN
1199: x_return_status := fnd_api.g_ret_sts_error;
1200:
1201: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data);

Line 1201: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1197: EXCEPTION
1198: WHEN fnd_api.g_exc_error THEN
1199: x_return_status := fnd_api.g_ret_sts_error;
1200:
1201: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data);
1204:
1205: -- Debug info.

Line 1218: WHEN fnd_api.g_exc_unexpected_error THEN

1214: p_prefix=>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_procedure);
1216: END IF;
1217:
1218: WHEN fnd_api.g_exc_unexpected_error THEN
1219: x_return_status := fnd_api.g_ret_sts_unexp_error;
1220:
1221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1222: p_count => x_msg_count,

Line 1219: x_return_status := fnd_api.g_ret_sts_unexp_error;

1215: p_msg_level=>fnd_log.level_procedure);
1216: END IF;
1217:
1218: WHEN fnd_api.g_exc_unexpected_error THEN
1219: x_return_status := fnd_api.g_ret_sts_unexp_error;
1220:
1221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1222: p_count => x_msg_count,
1223: p_data => x_msg_data);

Line 1221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1217:
1218: WHEN fnd_api.g_exc_unexpected_error THEN
1219: x_return_status := fnd_api.g_ret_sts_unexp_error;
1220:
1221: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1222: p_count => x_msg_count,
1223: p_data => x_msg_data);
1224:
1225: -- Debug info.

Line 1238: x_return_status := fnd_api.g_ret_sts_unexp_error;

1234: p_prefix=>l_debug_prefix,
1235: p_msg_level=>fnd_log.level_procedure);
1236: END IF;
1237: WHEN OTHERS THEN
1238: x_return_status := fnd_api.g_ret_sts_unexp_error;
1239:
1240: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1241: fnd_message.set_token('ERROR' ,SQLERRM);
1242: fnd_msg_pub.add;

Line 1244: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1240: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1241: fnd_message.set_token('ERROR' ,SQLERRM);
1242: fnd_msg_pub.add;
1243:
1244: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1245: p_count => x_msg_count,
1246: p_data => x_msg_data);
1247:
1248: -- Debug info.

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

1259: END IF;
1260: END do_save_party_site_bo;
1261:
1262: PROCEDURE save_party_site_bo(
1263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1264: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1265: p_party_site_obj IN HZ_PARTY_SITE_BO,
1266: p_created_by_module IN VARCHAR2,
1267: x_return_status OUT NOCOPY VARCHAR2,

Line 1264: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1260: END do_save_party_site_bo;
1261:
1262: PROCEDURE save_party_site_bo(
1263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1264: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1265: p_party_site_obj IN HZ_PARTY_SITE_BO,
1266: p_created_by_module IN VARCHAR2,
1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,

Line 1301: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,

1297: );
1298: END save_party_site_bo;
1299:
1300: PROCEDURE save_party_site_bo(
1301: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1302: p_party_site_obj IN HZ_PARTY_SITE_BO,
1303: p_created_by_module IN VARCHAR2,
1304: p_obj_source IN VARCHAR2 := null,
1305: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

Line 1305: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

1301: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1302: p_party_site_obj IN HZ_PARTY_SITE_BO,
1303: p_created_by_module IN VARCHAR2,
1304: p_obj_source IN VARCHAR2 := null,
1305: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1306: x_return_status OUT NOCOPY VARCHAR2,
1307: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1308: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,
1309: x_party_site_id OUT NOCOPY NUMBER,

Line 1323: p_init_msg_list => fnd_api.g_true,

1319: l_ps_obj HZ_PARTY_SITE_BO;
1320: BEGIN
1321: l_ps_obj := p_party_site_obj;
1322: do_save_party_site_bo(
1323: p_init_msg_list => fnd_api.g_true,
1324: p_validate_bo_flag => p_validate_bo_flag,
1325: p_party_site_obj => l_ps_obj,
1326: p_created_by_module => p_created_by_module,
1327: x_return_status => x_return_status,

Line 1342: IF FND_API.to_Boolean(p_return_obj_flag) THEN

1338: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1339: x_return_status => x_return_status,
1340: x_msg_count => l_msg_count,
1341: x_msg_data => l_msg_data);
1342: IF FND_API.to_Boolean(p_return_obj_flag) THEN
1343: x_return_obj := l_ps_obj;
1344: END IF;
1345: END save_party_site_bo;
1346:

Line 1358: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.

1354: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1355: --
1356: -- ARGUMENTS
1357: -- IN:
1358: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
1359: -- p_party_id party ID.
1360: -- p_party_site_id party site ID. If this id is not passed in, multiple site objects will be returned.
1361: -- p_party_site_os party site orig system.
1362: -- p_party_site_osr party site orig system reference.

Line 1367: -- be fnd_api.g_ret_sts_success (success),

1363: --
1364: -- OUT:
1365: -- x_party_site_objs Logical party site records.
1366: -- x_return_status Return status after the call. The status can
1367: -- be fnd_api.g_ret_sts_success (success),
1368: -- fnd_api.g_ret_sts_error (error),
1369: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1370: -- x_msg_count Number of messages in message stack.
1371: -- x_msg_data Message text if x_msg_count is 1.

Line 1368: -- fnd_api.g_ret_sts_error (error),

1364: -- OUT:
1365: -- x_party_site_objs Logical party site records.
1366: -- x_return_status Return status after the call. The status can
1367: -- be fnd_api.g_ret_sts_success (success),
1368: -- fnd_api.g_ret_sts_error (error),
1369: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1370: -- x_msg_count Number of messages in message stack.
1371: -- x_msg_data Message text if x_msg_count is 1.
1372: --

Line 1369: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1365: -- x_party_site_objs Logical party site records.
1366: -- x_return_status Return status after the call. The status can
1367: -- be fnd_api.g_ret_sts_success (success),
1368: -- fnd_api.g_ret_sts_error (error),
1369: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1370: -- x_msg_count Number of messages in message stack.
1371: -- x_msg_data Message text if x_msg_count is 1.
1372: --
1373: -- NOTES

Line 1411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1407: */
1408:
1409:
1410: PROCEDURE get_party_site_bo (
1411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1412: p_party_site_id IN NUMBER,
1413: p_party_site_os IN VARCHAR2,
1414: p_party_site_osr IN VARCHAR2,
1415: x_party_site_obj OUT NOCOPY HZ_PARTY_SITE_BO,

Line 1429: x_return_status := FND_API.G_RET_STS_SUCCESS;

1425: l_party_site_objs HZ_PARTY_SITE_BO_TBL;
1426: BEGIN
1427:
1428: -- initialize API return status to success.
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE
1432: IF FND_API.to_Boolean(p_init_msg_list) THEN
1433: FND_MSG_PUB.initialize;

Line 1432: IF FND_API.to_Boolean(p_init_msg_list) THEN

1428: -- initialize API return status to success.
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE
1432: IF FND_API.to_Boolean(p_init_msg_list) THEN
1433: FND_MSG_PUB.initialize;
1434: END IF;
1435:
1436:

Line 1460: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1456: x_return_status => x_return_status,
1457: x_msg_count => x_msg_count,
1458: x_msg_data => x_msg_data);
1459:
1460: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos

Line 1461: RAISE fnd_api.g_exc_error;

1457: x_msg_count => x_msg_count,
1458: x_msg_data => x_msg_data);
1459:
1460: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos
1465: (p_init_msg_list => fnd_api.g_false,

Line 1465: (p_init_msg_list => fnd_api.g_false,

1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos
1465: (p_init_msg_list => fnd_api.g_false,
1466: p_party_id => NULL,
1467: p_party_site_id => l_party_site_id,
1468: p_action_type => NULL,
1469: x_party_site_objs => l_party_site_objs,

Line 1476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1472: x_msg_data => x_msg_data);
1473:
1474: x_party_site_obj := l_party_site_objs(1);
1475:
1476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480:

Line 1477: RAISE FND_API.G_EXC_ERROR;

1473:
1474: x_party_site_obj := l_party_site_objs(1);
1475:
1476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480:
1481: -- Debug info.

Line 1499: WHEN fnd_api.g_exc_error THEN

1495:
1496:
1497: EXCEPTION
1498:
1499: WHEN fnd_api.g_exc_error THEN
1500: x_return_status := fnd_api.g_ret_sts_error;
1501:
1502: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1503: p_count => x_msg_count,

Line 1500: x_return_status := fnd_api.g_ret_sts_error;

1496:
1497: EXCEPTION
1498:
1499: WHEN fnd_api.g_exc_error THEN
1500: x_return_status := fnd_api.g_ret_sts_error;
1501:
1502: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1503: p_count => x_msg_count,
1504: p_data => x_msg_data);

Line 1502: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1498:
1499: WHEN fnd_api.g_exc_error THEN
1500: x_return_status := fnd_api.g_ret_sts_error;
1501:
1502: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1503: p_count => x_msg_count,
1504: p_data => x_msg_data);
1505:
1506: -- Debug info.

Line 1518: WHEN fnd_api.g_exc_unexpected_error THEN

1514: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1518: WHEN fnd_api.g_exc_unexpected_error THEN
1519: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520:
1521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1522: p_count => x_msg_count,

Line 1519: x_return_status := fnd_api.g_ret_sts_unexp_error;

1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1518: WHEN fnd_api.g_exc_unexpected_error THEN
1519: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520:
1521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1522: p_count => x_msg_count,
1523: p_data => x_msg_data);

Line 1521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1517: END IF;
1518: WHEN fnd_api.g_exc_unexpected_error THEN
1519: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520:
1521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1522: p_count => x_msg_count,
1523: p_data => x_msg_data);
1524:
1525: -- Debug info.

Line 1538: x_return_status := fnd_api.g_ret_sts_unexp_error;

1534: p_prefix=>l_debug_prefix,
1535: p_msg_level=>fnd_log.level_procedure);
1536: END IF;
1537: WHEN OTHERS THEN
1538: x_return_status := fnd_api.g_ret_sts_unexp_error;
1539:
1540: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1541: fnd_message.set_token('ERROR' ,SQLERRM);
1542: fnd_msg_pub.add;

Line 1544: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1540: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1541: fnd_message.set_token('ERROR' ,SQLERRM);
1542: fnd_msg_pub.add;
1543:
1544: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1545: p_count => x_msg_count,
1546: p_data => x_msg_data);
1547:
1548: -- Debug info.

Line 1575: p_init_msg_list => fnd_api.g_true,

1571: l_msg_data VARCHAR2(2000);
1572: l_msg_count NUMBER;
1573: BEGIN
1574: get_party_site_bo(
1575: p_init_msg_list => fnd_api.g_true,
1576: p_party_site_id => p_party_site_id,
1577: p_party_site_os => p_party_site_os,
1578: p_party_site_osr => p_party_site_osr,
1579: x_party_site_obj => x_party_site_obj,