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_LOCATION_BO_PUB dependencies on FND_API

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

1: PACKAGE BODY hz_location_bo_pub AS
2: /*$Header: ARHBLCBB.pls 120.5 2006/05/18 22:25:40 acng noship $ */
3:
4: PROCEDURE do_create_location_bo(
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
7: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
8: p_created_by_module IN VARCHAR2,
9: p_obj_source IN VARCHAR2 := null,

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

2: /*$Header: ARHBLCBB.pls 120.5 2006/05/18 22:25:40 acng noship $ */
3:
4: PROCEDURE do_create_location_bo(
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
7: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
8: p_created_by_module IN VARCHAR2,
9: p_obj_source IN VARCHAR2 := null,
10: x_return_status OUT NOCOPY VARCHAR2,

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

15: x_location_osr OUT NOCOPY VARCHAR2
16: );
17:
18: PROCEDURE do_update_location_bo(
19: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
20: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
21: p_created_by_module IN VARCHAR2,
22: p_obj_source IN VARCHAR2 := null,
23: x_return_status OUT NOCOPY VARCHAR2,

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

28: x_location_osr OUT NOCOPY VARCHAR2
29: );
30:
31: PROCEDURE do_save_location_bo(
32: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
33: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
34: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
35: p_created_by_module IN VARCHAR2,
36: p_obj_source IN VARCHAR2 := null,

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

29: );
30:
31: PROCEDURE do_save_location_bo(
32: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
33: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
34: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
35: p_created_by_module IN VARCHAR2,
36: p_obj_source IN VARCHAR2 := null,
37: x_return_status OUT NOCOPY VARCHAR2,

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

138: --
139: -- DESCRIPTION
140: -- Create a location business object.
141: PROCEDURE do_create_location_bo(
142: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
144: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
145: p_created_by_module IN VARCHAR2,
146: p_obj_source IN VARCHAR2 := null,

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

139: -- DESCRIPTION
140: -- Create a location business object.
141: PROCEDURE do_create_location_bo(
142: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
144: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
145: p_created_by_module IN VARCHAR2,
146: p_obj_source IN VARCHAR2 := null,
147: x_return_status OUT NOCOPY VARCHAR2,

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162: -- Standard start of API savepoint
163: SAVEPOINT do_create_location_bo_pub;
164:
165: -- initialize API return status to success.
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- Initialize message list of p_init_msg_list is set to TRUE.
169: IF FND_API.to_Boolean(p_init_msg_list) THEN
170: FND_MSG_PUB.initialize;

Line 169: IF FND_API.to_Boolean(p_init_msg_list) THEN

165: -- initialize API return status to success.
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- Initialize message list of p_init_msg_list is set to TRUE.
169: IF FND_API.to_Boolean(p_init_msg_list) THEN
170: FND_MSG_PUB.initialize;
171: END IF;
172:
173: -- initialize Global variable

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

188: /* Currently, business object definition cannot be altered. The seeded completeness
189: for LOCATION business object has no mandatory embedded objects. So, comment out
190: this line of code
191: -- Base on p_validate_bo_flag, check the completeness of business objects
192: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
193: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
194: p_bus_object_code => 'LOCATION',
195: x_bus_object => l_bus_object
196: );

Line 203: RAISE fnd_api.g_exc_error;

199: p_ps_objs => p_location_obj,
200: p_bus_object => l_bus_object
201: );
202: IF NOT(l_valid_obj) THEN
203: RAISE fnd_api.g_exc_error;
204: END IF;
205: END IF;
206: */
207: x_location_id := p_location_obj.location_id;

Line 222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

218: x_return_status => x_return_status,
219: x_msg_count => x_msg_count,
220: x_msg_data => x_msg_data);
221:
222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: assign_location_rec(

Line 223: RAISE FND_API.G_EXC_ERROR;

219: x_msg_count => x_msg_count,
220: x_msg_data => x_msg_data);
221:
222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: assign_location_rec(
227: p_location_obj => p_location_obj,

Line 241: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

237: x_msg_count => x_msg_count,
238: x_msg_data => x_msg_data
239: );
240:
241: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: -- assign location_id

Line 242: RAISE FND_API.G_EXC_ERROR;

238: x_msg_data => x_msg_data
239: );
240:
241: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: -- assign location_id
246: p_location_obj.location_id := x_location_id;

Line 263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

259: x_msg_count => x_msg_count,
260: x_msg_data => x_msg_data
261: );
262:
263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: END IF;
267:

Line 264: RAISE FND_API.G_EXC_ERROR;

260: x_msg_data => x_msg_data
261: );
262:
263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: END IF;
267:
268: -- reset Global variable

Line 286: WHEN fnd_api.g_exc_error THEN

282: p_msg_level=>fnd_log.level_procedure);
283: END IF;
284:
285: EXCEPTION
286: WHEN fnd_api.g_exc_error THEN
287: ROLLBACK TO do_create_location_bo_pub;
288:
289: -- reset Global variable
290: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 297: x_return_status := fnd_api.g_ret_sts_error;

293: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
294: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
295: FND_MSG_PUB.ADD;
296:
297: x_return_status := fnd_api.g_ret_sts_error;
298:
299: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data);

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

295: FND_MSG_PUB.ADD;
296:
297: x_return_status := fnd_api.g_ret_sts_error;
298:
299: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302:
303: -- Debug info.

Line 316: WHEN fnd_api.g_exc_unexpected_error THEN

312: p_prefix=>l_debug_prefix,
313: p_msg_level=>fnd_log.level_procedure);
314: END IF;
315:
316: WHEN fnd_api.g_exc_unexpected_error THEN
317: ROLLBACK TO do_create_location_bo_pub;
318:
319: -- reset Global variable
320: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 327: x_return_status := fnd_api.g_ret_sts_unexp_error;

323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
324: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
325: FND_MSG_PUB.ADD;
326:
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328:
329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
330: p_count => x_msg_count,
331: p_data => x_msg_data);

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

325: FND_MSG_PUB.ADD;
326:
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328:
329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
330: p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: -- Debug info.

Line 357: x_return_status := fnd_api.g_ret_sts_unexp_error;

353: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
354: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
355: FND_MSG_PUB.ADD;
356:
357: x_return_status := fnd_api.g_ret_sts_unexp_error;
358:
359: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
360: fnd_message.set_token('ERROR' ,SQLERRM);
361: fnd_msg_pub.add;

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

359: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
360: fnd_message.set_token('ERROR' ,SQLERRM);
361: fnd_msg_pub.add;
362:
363: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
364: p_count => x_msg_count,
365: p_data => x_msg_data);
366:
367: -- Debug info.

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

378: END IF;
379: END do_create_location_bo;
380:
381: PROCEDURE create_location_bo(
382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
383: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
384: p_location_obj IN HZ_LOCATION_OBJ,
385: p_created_by_module IN VARCHAR2,
386: x_return_status OUT NOCOPY VARCHAR2,

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

379: END do_create_location_bo;
380:
381: PROCEDURE create_location_bo(
382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
383: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
384: p_location_obj IN HZ_LOCATION_OBJ,
385: p_created_by_module IN VARCHAR2,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,

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

408: );
409: END create_location_bo;
410:
411: PROCEDURE create_location_bo(
412: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
413: p_location_obj IN HZ_LOCATION_OBJ,
414: p_created_by_module IN VARCHAR2,
415: p_obj_source IN VARCHAR2 := null,
416: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

412: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
413: p_location_obj IN HZ_LOCATION_OBJ,
414: p_created_by_module IN VARCHAR2,
415: p_obj_source IN VARCHAR2 := null,
416: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
417: x_return_status OUT NOCOPY VARCHAR2,
418: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
419: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
420: x_location_id OUT NOCOPY NUMBER,

Line 430: p_init_msg_list => fnd_api.g_true,

426: l_location_obj HZ_LOCATION_OBJ;
427: BEGIN
428: l_location_obj := p_location_obj;
429: do_create_location_bo(
430: p_init_msg_list => fnd_api.g_true,
431: p_validate_bo_flag => p_validate_bo_flag,
432: p_location_obj => l_location_obj,
433: p_created_by_module => p_created_by_module,
434: p_obj_source => null,

Line 446: IF FND_API.to_Boolean(p_return_obj_flag) THEN

442: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
443: x_return_status => x_return_status,
444: x_msg_count => l_msg_count,
445: x_msg_data => l_msg_data);
446: IF FND_API.to_Boolean(p_return_obj_flag) THEN
447: x_return_obj := l_location_obj;
448: END IF;
449: END create_location_bo;
450:

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

452: --
453: -- DESCRIPTION
454: -- Update a location business object.
455: PROCEDURE do_update_location_bo(
456: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
457: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
458: p_created_by_module IN VARCHAR2,
459: p_obj_source IN VARCHAR2 := null,
460: x_return_status OUT NOCOPY VARCHAR2,

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480: -- Standard start of API savepoint
481: SAVEPOINT do_update_location_bo_pub;
482:
483: -- initialize API return status to success.
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: -- Initialize message list of p_init_msg_list is set to TRUE.
487: IF FND_API.to_Boolean(p_init_msg_list) THEN
488: FND_MSG_PUB.initialize;

Line 487: IF FND_API.to_Boolean(p_init_msg_list) THEN

483: -- initialize API return status to success.
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: -- Initialize message list of p_init_msg_list is set to TRUE.
487: IF FND_API.to_Boolean(p_init_msg_list) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- initialize Global variable

Line 522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

518: x_return_status => x_return_status,
519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data);
521:
522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526: OPEN get_ovn(x_location_id);

Line 523: RAISE FND_API.G_EXC_ERROR;

519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data);
521:
522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526: OPEN get_ovn(x_location_id);
527: FETCH get_ovn INTO l_loc_ovn;

Line 551: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

547: x_msg_count => x_msg_count,
548: x_msg_data => x_msg_data
549: );
550:
551: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554:
555: -- assign location_id

Line 552: RAISE FND_API.G_EXC_ERROR;

548: x_msg_data => x_msg_data
549: );
550:
551: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554:
555: -- assign location_id
556: p_location_obj.location_id := x_location_id;

Line 573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

569: x_msg_count => x_msg_count,
570: x_msg_data => x_msg_data
571: );
572:
573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576: END IF;
577:

Line 574: RAISE FND_API.G_EXC_ERROR;

570: x_msg_data => x_msg_data
571: );
572:
573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576: END IF;
577:
578: -- reset Global variable

Line 596: WHEN fnd_api.g_exc_error THEN

592: p_msg_level=>fnd_log.level_procedure);
593: END IF;
594:
595: EXCEPTION
596: WHEN fnd_api.g_exc_error THEN
597: ROLLBACK TO do_update_location_bo_pub;
598:
599: -- reset Global variable
600: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 607: x_return_status := fnd_api.g_ret_sts_error;

603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
604: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
605: FND_MSG_PUB.ADD;
606:
607: x_return_status := fnd_api.g_ret_sts_error;
608:
609: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data);

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

605: FND_MSG_PUB.ADD;
606:
607: x_return_status := fnd_api.g_ret_sts_error;
608:
609: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data);
612:
613: -- Debug info.

Line 626: WHEN fnd_api.g_exc_unexpected_error THEN

622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;
625:
626: WHEN fnd_api.g_exc_unexpected_error THEN
627: ROLLBACK TO do_update_location_bo_pub;
628:
629: -- reset Global variable
630: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 637: x_return_status := fnd_api.g_ret_sts_unexp_error;

633: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
634: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
635: FND_MSG_PUB.ADD;
636:
637: x_return_status := fnd_api.g_ret_sts_unexp_error;
638:
639: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
640: p_count => x_msg_count,
641: p_data => x_msg_data);

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

635: FND_MSG_PUB.ADD;
636:
637: x_return_status := fnd_api.g_ret_sts_unexp_error;
638:
639: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
640: p_count => x_msg_count,
641: p_data => x_msg_data);
642:
643: -- Debug info.

Line 667: x_return_status := fnd_api.g_ret_sts_unexp_error;

663: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
664: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
665: FND_MSG_PUB.ADD;
666:
667: x_return_status := fnd_api.g_ret_sts_unexp_error;
668:
669: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
670: fnd_message.set_token('ERROR' ,SQLERRM);
671: fnd_msg_pub.add;

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

669: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
670: fnd_message.set_token('ERROR' ,SQLERRM);
671: fnd_msg_pub.add;
672:
673: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
674: p_count => x_msg_count,
675: p_data => x_msg_data);
676:
677: -- Debug info.

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

688: END IF;
689: END do_update_location_bo;
690:
691: PROCEDURE update_location_bo(
692: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
693: p_location_obj IN HZ_LOCATION_OBJ,
694: p_created_by_module IN VARCHAR2,
695: x_return_status OUT NOCOPY VARCHAR2,
696: x_msg_count OUT NOCOPY NUMBER,

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

719: PROCEDURE update_location_bo(
720: p_location_obj IN HZ_LOCATION_OBJ,
721: p_created_by_module IN VARCHAR2,
722: p_obj_source IN VARCHAR2 := null,
723: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
726: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
727: x_location_id OUT NOCOPY NUMBER,

Line 737: p_init_msg_list => fnd_api.g_true,

733: l_location_obj HZ_LOCATION_OBJ;
734: BEGIN
735: l_location_obj := p_location_obj;
736: do_update_location_bo(
737: p_init_msg_list => fnd_api.g_true,
738: p_location_obj => l_location_obj,
739: p_created_by_module => p_created_by_module,
740: p_obj_source => p_obj_source,
741: x_return_status => x_return_status,

Line 752: IF FND_API.to_Boolean(p_return_obj_flag) THEN

748: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
749: x_return_status => x_return_status,
750: x_msg_count => l_msg_count,
751: x_msg_data => l_msg_data);
752: IF FND_API.to_Boolean(p_return_obj_flag) THEN
753: x_return_obj := l_location_obj;
754: END IF;
755: END update_location_bo;
756:

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

758: --
759: -- DESCRIPTION
760: -- Create or update a location business object.
761: PROCEDURE do_save_location_bo(
762: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
763: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
764: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
765: p_created_by_module IN VARCHAR2,
766: p_obj_source IN VARCHAR2 := null,

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

759: -- DESCRIPTION
760: -- Create or update a location business object.
761: PROCEDURE do_save_location_bo(
762: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
763: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
764: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
765: p_created_by_module IN VARCHAR2,
766: p_obj_source IN VARCHAR2 := null,
767: x_return_status OUT NOCOPY VARCHAR2,

Line 781: x_return_status := FND_API.G_RET_STS_SUCCESS;

777: l_create_update_flag VARCHAR2(1);
778: l_debug_prefix VARCHAR2(30);
779: BEGIN
780: -- initialize API return status to success.
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: -- Initialize message list of p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean(p_init_msg_list) THEN
785: FND_MSG_PUB.initialize;

Line 784: IF FND_API.to_Boolean(p_init_msg_list) THEN

780: -- initialize API return status to success.
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: -- Initialize message list of p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean(p_init_msg_list) THEN
785: FND_MSG_PUB.initialize;
786: END IF;
787:
788: -- Debug info.

Line 815: RAISE FND_API.G_EXC_ERROR;

811: FND_MSG_PUB.ADD;
812: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
813: FND_MESSAGE.SET_TOKEN('OBJECT', 'LOCATION');
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817:
818: IF(l_create_update_flag = 'C') THEN
819: do_create_location_bo(

Line 820: p_init_msg_list => fnd_api.g_false,

816: END IF;
817:
818: IF(l_create_update_flag = 'C') THEN
819: do_create_location_bo(
820: p_init_msg_list => fnd_api.g_false,
821: p_validate_bo_flag => p_validate_bo_flag,
822: p_location_obj => p_location_obj,
823: p_created_by_module => p_created_by_module,
824: p_obj_source => p_obj_source,

Line 833: p_init_msg_list => fnd_api.g_false,

829: x_location_os => x_location_os,
830: x_location_osr => x_location_osr);
831: ELSIF(l_create_update_flag = 'U') THEN
832: do_update_location_bo(
833: p_init_msg_list => fnd_api.g_false,
834: p_location_obj => p_location_obj,
835: p_created_by_module => p_created_by_module,
836: p_obj_source => p_obj_source,
837: x_return_status => x_return_status,

Line 844: RAISE FND_API.G_EXC_ERROR;

840: x_location_id => x_location_id,
841: x_location_os => x_location_os,
842: x_location_osr => x_location_osr);
843: ELSE
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846:
847: -- Debug info.
848: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 861: WHEN fnd_api.g_exc_error THEN

857: p_msg_level=>fnd_log.level_procedure);
858: END IF;
859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: x_return_status := fnd_api.g_ret_sts_error;
863:
864: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
865: p_count => x_msg_count,

Line 862: x_return_status := fnd_api.g_ret_sts_error;

858: END IF;
859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: x_return_status := fnd_api.g_ret_sts_error;
863:
864: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
865: p_count => x_msg_count,
866: p_data => x_msg_data);

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

860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: x_return_status := fnd_api.g_ret_sts_error;
863:
864: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
865: p_count => x_msg_count,
866: p_data => x_msg_data);
867:
868: -- Debug info.

Line 881: WHEN fnd_api.g_exc_unexpected_error THEN

877: p_prefix=>l_debug_prefix,
878: p_msg_level=>fnd_log.level_procedure);
879: END IF;
880:
881: WHEN fnd_api.g_exc_unexpected_error THEN
882: x_return_status := fnd_api.g_ret_sts_unexp_error;
883:
884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
885: p_count => x_msg_count,

Line 882: x_return_status := fnd_api.g_ret_sts_unexp_error;

878: p_msg_level=>fnd_log.level_procedure);
879: END IF;
880:
881: WHEN fnd_api.g_exc_unexpected_error THEN
882: x_return_status := fnd_api.g_ret_sts_unexp_error;
883:
884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
885: p_count => x_msg_count,
886: p_data => x_msg_data);

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

880:
881: WHEN fnd_api.g_exc_unexpected_error THEN
882: x_return_status := fnd_api.g_ret_sts_unexp_error;
883:
884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
885: p_count => x_msg_count,
886: p_data => x_msg_data);
887:
888: -- Debug info.

Line 901: x_return_status := fnd_api.g_ret_sts_unexp_error;

897: p_prefix=>l_debug_prefix,
898: p_msg_level=>fnd_log.level_procedure);
899: END IF;
900: WHEN OTHERS THEN
901: x_return_status := fnd_api.g_ret_sts_unexp_error;
902:
903: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
904: fnd_message.set_token('ERROR' ,SQLERRM);
905: fnd_msg_pub.add;

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

903: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
904: fnd_message.set_token('ERROR' ,SQLERRM);
905: fnd_msg_pub.add;
906:
907: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
908: p_count => x_msg_count,
909: p_data => x_msg_data);
910:
911: -- Debug info.

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

922: END IF;
923: END do_save_location_bo;
924:
925: PROCEDURE save_location_bo(
926: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
927: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
928: p_location_obj IN HZ_LOCATION_OBJ,
929: p_created_by_module IN VARCHAR2,
930: x_return_status OUT NOCOPY VARCHAR2,

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

923: END do_save_location_bo;
924:
925: PROCEDURE save_location_bo(
926: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
927: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
928: p_location_obj IN HZ_LOCATION_OBJ,
929: p_created_by_module IN VARCHAR2,
930: x_return_status OUT NOCOPY VARCHAR2,
931: x_msg_count OUT NOCOPY NUMBER,

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

954: );
955: END save_location_bo;
956:
957: PROCEDURE save_location_bo(
958: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
959: p_location_obj IN HZ_LOCATION_OBJ,
960: p_created_by_module IN VARCHAR2,
961: p_obj_source IN VARCHAR2 := null,
962: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

958: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
959: p_location_obj IN HZ_LOCATION_OBJ,
960: p_created_by_module IN VARCHAR2,
961: p_obj_source IN VARCHAR2 := null,
962: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
963: x_return_status OUT NOCOPY VARCHAR2,
964: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
965: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
966: x_location_id OUT NOCOPY NUMBER,

Line 976: p_init_msg_list => fnd_api.g_true,

972: l_location_obj HZ_LOCATION_OBJ;
973: BEGIN
974: l_location_obj := p_location_obj;
975: do_save_location_bo(
976: p_init_msg_list => fnd_api.g_true,
977: p_validate_bo_flag => p_validate_bo_flag,
978: p_location_obj => l_location_obj,
979: p_created_by_module => p_created_by_module,
980: p_obj_source => p_obj_source,

Line 992: IF FND_API.to_Boolean(p_return_obj_flag) THEN

988: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
989: x_return_status => x_return_status,
990: x_msg_count => l_msg_count,
991: x_msg_data => l_msg_data);
992: IF FND_API.to_Boolean(p_return_obj_flag) THEN
993: x_return_obj := l_location_obj;
994: END IF;
995: END save_location_bo;
996:

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

1004: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1005: --
1006: -- ARGUMENTS
1007: -- IN:
1008: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
1009: -- p_party_id party ID.
1010: -- p_location_id location ID. If this id is not passed in, multiple site objects will be returned.
1011: -- p_location_os location orig system.
1012: -- p_location_osr location orig system reference.

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

1013: --
1014: -- OUT:
1015: -- x_location_objs Logical location records.
1016: -- x_return_status Return status after the call. The status can
1017: -- be fnd_api.g_ret_sts_success (success),
1018: -- fnd_api.g_ret_sts_error (error),
1019: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1020: -- x_msg_count Number of messages in message stack.
1021: -- x_msg_data Message text if x_msg_count is 1.

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

1014: -- OUT:
1015: -- x_location_objs Logical location records.
1016: -- x_return_status Return status after the call. The status can
1017: -- be fnd_api.g_ret_sts_success (success),
1018: -- fnd_api.g_ret_sts_error (error),
1019: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1020: -- x_msg_count Number of messages in message stack.
1021: -- x_msg_data Message text if x_msg_count is 1.
1022: --

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

1015: -- x_location_objs Logical location records.
1016: -- x_return_status Return status after the call. The status can
1017: -- be fnd_api.g_ret_sts_success (success),
1018: -- fnd_api.g_ret_sts_error (error),
1019: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1020: -- x_msg_count Number of messages in message stack.
1021: -- x_msg_data Message text if x_msg_count is 1.
1022: --
1023: -- NOTES

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

1047: Location Y N HZ_LOCATIONS
1048: */
1049:
1050: PROCEDURE get_location_bo (
1051: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1052: p_location_id IN NUMBER,
1053: p_location_os IN VARCHAR2,
1054: p_location_osr IN VARCHAR2,
1055: x_location_obj OUT NOCOPY HZ_LOCATION_OBJ,

Line 1123: x_return_status := FND_API.G_RET_STS_SUCCESS;

1119: WHERE LOCATION_ID = l_loc_id;
1120:
1121: BEGIN
1122: -- initialize API return status to success.
1123: x_return_status := FND_API.G_RET_STS_SUCCESS;
1124:
1125: -- Initialize message list if p_init_msg_list is set to TRUE
1126: IF FND_API.to_Boolean(p_init_msg_list) THEN
1127: FND_MSG_PUB.initialize;

Line 1126: IF FND_API.to_Boolean(p_init_msg_list) THEN

1122: -- initialize API return status to success.
1123: x_return_status := FND_API.G_RET_STS_SUCCESS;
1124:
1125: -- Initialize message list if p_init_msg_list is set to TRUE
1126: IF FND_API.to_Boolean(p_init_msg_list) THEN
1127: FND_MSG_PUB.initialize;
1128: END IF;
1129:
1130: -- Debug info.

Line 1153: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1149: x_return_status => x_return_status,
1150: x_msg_count => x_msg_count,
1151: x_msg_data => x_msg_data);
1152:
1153: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1154: RAISE fnd_api.g_exc_error;
1155: END IF;
1156:
1157: OPEN c1(l_location_id);

Line 1154: RAISE fnd_api.g_exc_error;

1150: x_msg_count => x_msg_count,
1151: x_msg_data => x_msg_data);
1152:
1153: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1154: RAISE fnd_api.g_exc_error;
1155: END IF;
1156:
1157: OPEN c1(l_location_id);
1158: FETCH c1 into x_location_obj;

Line 1162: p_init_msg_list => fnd_api.g_false,

1158: FETCH c1 into x_location_obj;
1159: CLOSE c1;
1160:
1161: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos(
1162: p_init_msg_list => fnd_api.g_false,
1163: p_ext_object_id => x_location_obj.location_id,
1164: p_ext_object_name => 'HZ_LOCATIONS',
1165: p_action_type => NULL,
1166: x_ext_attribute_objs => x_location_obj.ext_attributes_objs,

Line 1171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1167: x_return_status => x_return_status,
1168: x_msg_count => x_msg_count,
1169: x_msg_data => x_msg_data);
1170:
1171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: END IF;
1174:
1175: -- Debug info.

Line 1172: RAISE FND_API.G_EXC_ERROR;

1168: x_msg_count => x_msg_count,
1169: x_msg_data => x_msg_data);
1170:
1171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1172: RAISE FND_API.G_EXC_ERROR;
1173: END IF;
1174:
1175: -- Debug info.
1176: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1190: WHEN fnd_api.g_exc_error THEN

1186: p_prefix=>l_debug_prefix,
1187: p_msg_level=>fnd_log.level_procedure);
1188: END IF;
1189: EXCEPTION
1190: WHEN fnd_api.g_exc_error THEN
1191: x_return_status := fnd_api.g_ret_sts_error;
1192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1193: p_count => x_msg_count,
1194: p_data => x_msg_data);

Line 1191: x_return_status := fnd_api.g_ret_sts_error;

1187: p_msg_level=>fnd_log.level_procedure);
1188: END IF;
1189: EXCEPTION
1190: WHEN fnd_api.g_exc_error THEN
1191: x_return_status := fnd_api.g_ret_sts_error;
1192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1193: p_count => x_msg_count,
1194: p_data => x_msg_data);
1195:

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

1188: END IF;
1189: EXCEPTION
1190: WHEN fnd_api.g_exc_error THEN
1191: x_return_status := fnd_api.g_ret_sts_error;
1192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1193: p_count => x_msg_count,
1194: p_data => x_msg_data);
1195:
1196: -- Debug info.

Line 1208: WHEN fnd_api.g_exc_unexpected_error THEN

1204: hz_utility_v2pub.debug(p_message=>'hz_location_bo_pub.get_location_bo (-)',
1205: p_prefix=>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_procedure);
1207: END IF;
1208: WHEN fnd_api.g_exc_unexpected_error THEN
1209: x_return_status := fnd_api.g_ret_sts_unexp_error;
1210: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1211: p_count => x_msg_count,
1212: p_data => x_msg_data);

Line 1209: x_return_status := fnd_api.g_ret_sts_unexp_error;

1205: p_prefix=>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_procedure);
1207: END IF;
1208: WHEN fnd_api.g_exc_unexpected_error THEN
1209: x_return_status := fnd_api.g_ret_sts_unexp_error;
1210: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1211: p_count => x_msg_count,
1212: p_data => x_msg_data);
1213:

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

1206: p_msg_level=>fnd_log.level_procedure);
1207: END IF;
1208: WHEN fnd_api.g_exc_unexpected_error THEN
1209: x_return_status := fnd_api.g_ret_sts_unexp_error;
1210: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1211: p_count => x_msg_count,
1212: p_data => x_msg_data);
1213:
1214: -- Debug info.

Line 1227: x_return_status := fnd_api.g_ret_sts_unexp_error;

1223: p_prefix=>l_debug_prefix,
1224: p_msg_level=>fnd_log.level_procedure);
1225: END IF;
1226: WHEN OTHERS THEN
1227: x_return_status := fnd_api.g_ret_sts_unexp_error;
1228: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1229: fnd_message.set_token('ERROR' ,SQLERRM);
1230: fnd_msg_pub.add;
1231:

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

1228: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1229: fnd_message.set_token('ERROR' ,SQLERRM);
1230: fnd_msg_pub.add;
1231:
1232: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1233: p_count => x_msg_count,
1234: p_data => x_msg_data);
1235:
1236: -- Debug info.

Line 1262: p_init_msg_list => FND_API.g_true,

1258: l_msg_count NUMBER;
1259: l_msg_data VARCHAR2(2000);
1260: BEGIN
1261: get_location_bo(
1262: p_init_msg_list => FND_API.g_true,
1263: p_location_id => p_location_id,
1264: p_location_os => p_location_os,
1265: p_location_osr => p_location_osr,
1266: x_location_obj => x_location_obj,