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

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

282: --
283: -- DESCRIPTION
284: -- Creates org contact business object.
285: PROCEDURE do_create_org_contact_bo(
286: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
287: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
288: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
289: p_created_by_module IN VARCHAR2,
290: p_obj_source IN VARCHAR2 := null,

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

283: -- DESCRIPTION
284: -- Creates org contact business object.
285: PROCEDURE do_create_org_contact_bo(
286: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
287: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
288: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
289: p_created_by_module IN VARCHAR2,
290: p_obj_source IN VARCHAR2 := null,
291: x_return_status OUT NOCOPY VARCHAR2,

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: -- Standard start of API savepoint
342: SAVEPOINT do_create_org_contact_bo_pub;
343:
344: -- initialize API return status to success.
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;

Line 348: IF FND_API.to_Boolean(p_init_msg_list) THEN

344: -- initialize API return status to success.
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- initialize Global variable

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

364: p_msg_level=>fnd_log.level_procedure);
365: END IF;
366:
367: -- Base on p_validate_bo_flag check completeness of business object
368: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
369: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
370: p_bus_object_code => 'ORG_CONTACT',
371: x_bus_object => l_bus_object
372: );

Line 378: RAISE fnd_api.g_exc_error;

374: p_oc_objs => HZ_ORG_CONTACT_BO_TBL(p_org_contact_obj),
375: p_bus_object => l_bus_object
376: );
377: IF NOT(l_valid_obj) THEN
378: RAISE fnd_api.g_exc_error;
379: END IF;
380: END IF;
381:
382: -- check pass in parent_id and parent_os+osr

Line 393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

389: x_return_status => x_return_status,
390: x_msg_count => x_msg_count,
391: x_msg_data => x_msg_data);
392:
393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: x_org_contact_id := p_org_contact_obj.org_contact_id;

Line 394: RAISE FND_API.G_EXC_ERROR;

390: x_msg_count => x_msg_count,
391: x_msg_data => x_msg_data);
392:
393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: x_org_contact_id := p_org_contact_obj.org_contact_id;
398: x_org_contact_os := p_org_contact_obj.orig_system;

Line 412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

408: x_return_status => x_return_status,
409: x_msg_count => x_msg_count,
410: x_msg_data => x_msg_data);
411:
412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;
415:
416: IF(p_org_contact_obj.person_profile_obj IS NULL) THEN

Line 413: RAISE FND_API.G_EXC_ERROR;

409: x_msg_count => x_msg_count,
410: x_msg_data => x_msg_data);
411:
412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;
415:
416: IF(p_org_contact_obj.person_profile_obj IS NULL) THEN
417: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');

Line 420: RAISE FND_API.G_EXC_ERROR;

416: IF(p_org_contact_obj.person_profile_obj IS NULL) THEN
417: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
418: fnd_message.set_token('ENTITY' ,'PERSON_CONTACT');
419: fnd_msg_pub.add;
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422:
423: l_per_party_id := p_org_contact_obj.person_profile_obj.person_id;
424: l_per_party_os := p_org_contact_obj.person_profile_obj.orig_system;

Line 438: RAISE FND_API.G_EXC_ERROR;

434: CLOSE validate_per_id;
435: IF(l_valid_per IS NULL) THEN
436: FND_MESSAGE.SET_NAME('AR','HZ_API_CANNOT_PASS_PK');
437: FND_MSG_PUB.ADD;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: END IF;
441:
442: -- IF l_per_party_id does not exist, can create person

Line 466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

462: x_msg_count => x_msg_count,
463: x_msg_data => x_msg_data
464: );
465:
466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:
470: -- assign person_id

Line 467: RAISE FND_API.G_EXC_ERROR;

463: x_msg_data => x_msg_data
464: );
465:
466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:
470: -- assign person_id
471: p_org_contact_obj.person_profile_obj.person_id := l_per_party_id;

Line 488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

484: x_msg_count => x_msg_count,
485: x_msg_data => x_msg_data
486: );
487:
488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491: END IF;
492: END IF;

Line 489: RAISE FND_API.G_EXC_ERROR;

485: x_msg_data => x_msg_data
486: );
487:
488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491: END IF;
492: END IF;
493:

Line 518: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

514: x_msg_count => x_msg_count,
515: x_msg_data => x_msg_data
516: );
517:
518: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
519: RAISE FND_API.G_EXC_ERROR;
520: END IF;
521:
522: -- assign org_contact_id

Line 519: RAISE FND_API.G_EXC_ERROR;

515: x_msg_data => x_msg_data
516: );
517:
518: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
519: RAISE FND_API.G_EXC_ERROR;
520: END IF;
521:
522: -- assign org_contact_id
523: p_org_contact_obj.org_contact_id := x_org_contact_id;

Line 537: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data
535: );
536:
537: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540: END IF;
541:

Line 538: RAISE FND_API.G_EXC_ERROR;

534: x_msg_data => x_msg_data
535: );
536:
537: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540: END IF;
541:
542: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

558: p_parent_osr => l_party_osr,
559: p_parent_obj_type => 'ORG_CONTACT'
560: );
561:
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565: END IF;
566:

Line 563: RAISE FND_API.G_EXC_ERROR;

559: p_parent_obj_type => 'ORG_CONTACT'
560: );
561:
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565: END IF;
566:
567: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 596: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

592: x_msg_count => x_msg_count,
593: x_msg_data => x_msg_data
594: );
595:
596: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599: END IF;
600:

Line 597: RAISE FND_API.G_EXC_ERROR;

593: x_msg_data => x_msg_data
594: );
595:
596: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599: END IF;
600:
601: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 617: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

613: x_msg_count => x_msg_count,
614: x_msg_data => x_msg_data
615: );
616:
617: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;
621:

Line 618: RAISE FND_API.G_EXC_ERROR;

614: x_msg_data => x_msg_data
615: );
616:
617: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;
621:
622: -- reset Global variable

Line 640: WHEN fnd_api.g_exc_error THEN

636: p_msg_level=>fnd_log.level_procedure);
637: END IF;
638:
639: EXCEPTION
640: WHEN fnd_api.g_exc_error THEN
641: ROLLBACK TO do_create_org_contact_bo_pub;
642:
643: -- reset Global variable
644: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 651: x_return_status := fnd_api.g_ret_sts_error;

647: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
648: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
649: FND_MSG_PUB.ADD;
650:
651: x_return_status := fnd_api.g_ret_sts_error;
652:
653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
654: p_count => x_msg_count,
655: p_data => x_msg_data);

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

649: FND_MSG_PUB.ADD;
650:
651: x_return_status := fnd_api.g_ret_sts_error;
652:
653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
654: p_count => x_msg_count,
655: p_data => x_msg_data);
656:
657: -- Debug info.

Line 670: WHEN fnd_api.g_exc_unexpected_error THEN

666: p_prefix=>l_debug_prefix,
667: p_msg_level=>fnd_log.level_procedure);
668: END IF;
669:
670: WHEN fnd_api.g_exc_unexpected_error THEN
671: ROLLBACK TO do_create_org_contact_bo_pub;
672:
673: -- reset Global variable
674: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 681: x_return_status := fnd_api.g_ret_sts_unexp_error;

677: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
678: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
679: FND_MSG_PUB.ADD;
680:
681: x_return_status := fnd_api.g_ret_sts_unexp_error;
682:
683: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
684: p_count => x_msg_count,
685: p_data => x_msg_data);

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

679: FND_MSG_PUB.ADD;
680:
681: x_return_status := fnd_api.g_ret_sts_unexp_error;
682:
683: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686:
687: -- Debug info.

Line 711: x_return_status := fnd_api.g_ret_sts_unexp_error;

707: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
708: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
709: FND_MSG_PUB.ADD;
710:
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712:
713: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
714: fnd_message.set_token('ERROR' ,SQLERRM);
715: fnd_msg_pub.add;

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

713: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
714: fnd_message.set_token('ERROR' ,SQLERRM);
715: fnd_msg_pub.add;
716:
717: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
718: p_count => x_msg_count,
719: p_data => x_msg_data);
720:
721: -- Debug info.

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

732: END IF;
733: END do_create_org_contact_bo;
734:
735: PROCEDURE create_org_contact_bo(
736: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
737: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
738: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
739: p_created_by_module IN VARCHAR2,
740: x_return_status OUT NOCOPY VARCHAR2,

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

733: END do_create_org_contact_bo;
734:
735: PROCEDURE create_org_contact_bo(
736: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
737: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
738: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
739: p_created_by_module IN VARCHAR2,
740: x_return_status OUT NOCOPY VARCHAR2,
741: x_msg_count OUT NOCOPY NUMBER,

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

768: );
769: END create_org_contact_bo;
770:
771: PROCEDURE create_org_contact_bo(
772: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
773: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
774: p_created_by_module IN VARCHAR2,
775: p_obj_source IN VARCHAR2 := null,
776: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

772: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
773: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
774: p_created_by_module IN VARCHAR2,
775: p_obj_source IN VARCHAR2 := null,
776: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
777: x_return_status OUT NOCOPY VARCHAR2,
778: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
779: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
780: x_org_contact_id OUT NOCOPY NUMBER,

Line 793: p_init_msg_list => fnd_api.g_true,

789: l_oc_obj HZ_ORG_CONTACT_BO;
790: BEGIN
791: l_oc_obj := p_org_contact_obj;
792: do_create_org_contact_bo(
793: p_init_msg_list => fnd_api.g_true,
794: p_validate_bo_flag => p_validate_bo_flag,
795: p_org_contact_obj => l_oc_obj,
796: p_created_by_module => p_created_by_module,
797: p_obj_source => p_obj_source,

Line 812: IF FND_API.to_Boolean(p_return_obj_flag) THEN

808: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
809: x_return_status => x_return_status,
810: x_msg_count => l_msg_count,
811: x_msg_data => l_msg_data);
812: IF FND_API.to_Boolean(p_return_obj_flag) THEN
813: x_return_obj := l_oc_obj;
814: END IF;
815: END create_org_contact_bo;
816:

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

818: --
819: -- DESCRIPTION
820: -- Update org contact business object.
821: PROCEDURE update_org_contact_bo(
822: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
823: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
824: p_created_by_module IN VARCHAR2,
825: x_return_status OUT NOCOPY VARCHAR2,
826: x_msg_count OUT NOCOPY NUMBER,

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

850: PROCEDURE update_org_contact_bo(
851: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
852: p_created_by_module IN VARCHAR2,
853: p_obj_source IN VARCHAR2 := null,
854: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
855: x_return_status OUT NOCOPY VARCHAR2,
856: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
857: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
858: x_org_contact_id OUT NOCOPY NUMBER,

Line 868: p_init_msg_list => fnd_api.g_true,

864: l_oc_obj HZ_ORG_CONTACT_BO;
865: BEGIN
866: l_oc_obj := p_org_contact_obj;
867: do_update_org_contact_bo(
868: p_init_msg_list => fnd_api.g_true,
869: p_org_contact_obj => l_oc_obj,
870: p_created_by_module => p_created_by_module,
871: x_return_status => x_return_status,
872: x_msg_count => l_msg_count,

Line 883: IF FND_API.to_Boolean(p_return_obj_flag) THEN

879: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
880: x_return_status => x_return_status,
881: x_msg_count => l_msg_count,
882: x_msg_data => l_msg_data);
883: IF FND_API.to_Boolean(p_return_obj_flag) THEN
884: x_return_obj := l_oc_obj;
885: END IF;
886: END update_org_contact_bo;
887:

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

889: --
890: -- DESCRIPTION
891: -- Update org contact business object.
892: PROCEDURE do_update_org_contact_bo(
893: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
894: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
895: p_created_by_module IN VARCHAR2,
896: p_obj_source IN VARCHAR2 := null,
897: x_return_status OUT NOCOPY VARCHAR2,

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

947: -- Standard start of API savepoint
948: SAVEPOINT do_update_org_contact_bo_pub;
949:
950: -- initialize API return status to success.
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: -- Initialize message list if p_init_msg_list is set to TRUE.
954: IF FND_API.to_Boolean(p_init_msg_list) THEN
955: FND_MSG_PUB.initialize;

Line 954: IF FND_API.to_Boolean(p_init_msg_list) THEN

950: -- initialize API return status to success.
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: -- Initialize message list if p_init_msg_list is set to TRUE.
954: IF FND_API.to_Boolean(p_init_msg_list) THEN
955: FND_MSG_PUB.initialize;
956: END IF;
957:
958: -- initialize Global variable

Line 989: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

985: x_return_status => x_return_status,
986: x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data);
988:
989: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: OPEN get_ovn(x_org_contact_id);

Line 990: RAISE FND_API.G_EXC_ERROR;

986: x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data);
988:
989: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: OPEN get_ovn(x_org_contact_id);
994: FETCH get_ovn INTO l_oc_ovn, l_rel_ovn, l_pty_ovn, l_oc_party_id, l_related_org_id, l_person_id;

Line 1018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1014: x_return_status => x_return_status,
1015: x_msg_count => x_msg_count,
1016: x_msg_data => x_msg_data);
1017:
1018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1021:
1022: -- call v2api to update

Line 1019: RAISE FND_API.G_EXC_ERROR;

1015: x_msg_count => x_msg_count,
1016: x_msg_data => x_msg_data);
1017:
1018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1021:
1022: -- call v2api to update
1023: assign_person_profile_rec(

Line 1045: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1041: x_msg_count => x_msg_count,
1042: x_msg_data => x_msg_data
1043: );
1044:
1045: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048:
1049: -----------------------

Line 1046: RAISE FND_API.G_EXC_ERROR;

1042: x_msg_data => x_msg_data
1043: );
1044:
1045: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048:
1049: -----------------------
1050: -- For Person Ext Attrs

Line 1065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data
1063: );
1064:
1065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: END IF;
1069: END IF;

Line 1066: RAISE FND_API.G_EXC_ERROR;

1062: x_msg_data => x_msg_data
1063: );
1064:
1065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: END IF;
1069: END IF;
1070: END IF;

Line 1097: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1093: x_msg_count => x_msg_count,
1094: x_msg_data => x_msg_data
1095: );
1096:
1097: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100:
1101: -- assign org_contact_id

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: x_msg_data => x_msg_data
1095: );
1096:
1097: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100:
1101: -- assign org_contact_id
1102: p_org_contact_obj.org_contact_id := x_org_contact_id;

Line 1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1112: x_msg_count => x_msg_count,
1113: x_msg_data => x_msg_data
1114: );
1115:
1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119: END IF;
1120:

Line 1117: RAISE FND_API.G_EXC_ERROR;

1113: x_msg_data => x_msg_data
1114: );
1115:
1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119: END IF;
1120:
1121: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 1141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1137: p_parent_osr => NULL,
1138: p_parent_obj_type => 'ORG_CONTACT'
1139: );
1140:
1141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: END IF;
1145:

Line 1142: RAISE FND_API.G_EXC_ERROR;

1138: p_parent_obj_type => 'ORG_CONTACT'
1139: );
1140:
1141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: END IF;
1145:
1146: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1174: x_msg_count => x_msg_count,
1175: x_msg_data => x_msg_data
1176: );
1177:
1178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF;
1182:

Line 1179: RAISE FND_API.G_EXC_ERROR;

1175: x_msg_data => x_msg_data
1176: );
1177:
1178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF;
1182:
1183: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1195: x_msg_count => x_msg_count,
1196: x_msg_data => x_msg_data
1197: );
1198:
1199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1200: RAISE FND_API.G_EXC_ERROR;
1201: END IF;
1202: END IF;
1203:

Line 1200: RAISE FND_API.G_EXC_ERROR;

1196: x_msg_data => x_msg_data
1197: );
1198:
1199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1200: RAISE FND_API.G_EXC_ERROR;
1201: END IF;
1202: END IF;
1203:
1204: -- reset Global variable

Line 1221: WHEN fnd_api.g_exc_error THEN

1217: p_prefix=>l_debug_prefix,
1218: p_msg_level=>fnd_log.level_procedure);
1219: END IF;
1220: EXCEPTION
1221: WHEN fnd_api.g_exc_error THEN
1222: ROLLBACK TO do_update_org_contact_bo_pub;
1223:
1224: -- reset Global variable
1225: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1232: x_return_status := fnd_api.g_ret_sts_error;

1228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1229: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1230: FND_MSG_PUB.ADD;
1231:
1232: x_return_status := fnd_api.g_ret_sts_error;
1233:
1234: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1235: p_count => x_msg_count,
1236: p_data => x_msg_data);

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

1230: FND_MSG_PUB.ADD;
1231:
1232: x_return_status := fnd_api.g_ret_sts_error;
1233:
1234: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1235: p_count => x_msg_count,
1236: p_data => x_msg_data);
1237:
1238: -- Debug info.

Line 1251: WHEN fnd_api.g_exc_unexpected_error THEN

1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;
1250:
1251: WHEN fnd_api.g_exc_unexpected_error THEN
1252: ROLLBACK TO do_update_org_contact_bo_pub;
1253:
1254: -- reset Global variable
1255: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1262: x_return_status := fnd_api.g_ret_sts_unexp_error;

1258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1259: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1260: FND_MSG_PUB.ADD;
1261:
1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263:
1264: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data);

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

1260: FND_MSG_PUB.ADD;
1261:
1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263:
1264: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data);
1267:
1268: -- Debug info.

Line 1292: x_return_status := fnd_api.g_ret_sts_unexp_error;

1288: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1289: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1290: FND_MSG_PUB.ADD;
1291:
1292: x_return_status := fnd_api.g_ret_sts_unexp_error;
1293:
1294: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1295: fnd_message.set_token('ERROR' ,SQLERRM);
1296: fnd_msg_pub.add;

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

1294: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1295: fnd_message.set_token('ERROR' ,SQLERRM);
1296: fnd_msg_pub.add;
1297:
1298: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data);
1301:
1302: -- Debug info.

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

1317: --
1318: -- DESCRIPTION
1319: -- Creates or update org contact business object.
1320: PROCEDURE do_save_org_contact_bo(
1321: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1322: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1323: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
1324: p_created_by_module IN VARCHAR2,
1325: p_obj_source IN VARCHAR2 := null,

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

1318: -- DESCRIPTION
1319: -- Creates or update org contact business object.
1320: PROCEDURE do_save_org_contact_bo(
1321: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1322: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1323: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
1324: p_created_by_module IN VARCHAR2,
1325: p_obj_source IN VARCHAR2 := null,
1326: x_return_status OUT NOCOPY VARCHAR2,

Line 1343: x_return_status := FND_API.G_RET_STS_SUCCESS;

1339: l_create_update_flag VARCHAR2(1);
1340: l_debug_prefix VARCHAR2(30);
1341: BEGIN
1342: -- initialize API return status to success.
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;
1344:
1345: -- Initialize message list if p_init_msg_list is set to TRUE.
1346: IF FND_API.to_Boolean(p_init_msg_list) THEN
1347: FND_MSG_PUB.initialize;

Line 1346: IF FND_API.to_Boolean(p_init_msg_list) THEN

1342: -- initialize API return status to success.
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;
1344:
1345: -- Initialize message list if p_init_msg_list is set to TRUE.
1346: IF FND_API.to_Boolean(p_init_msg_list) THEN
1347: FND_MSG_PUB.initialize;
1348: END IF;
1349:
1350: -- Debug info.

Line 1376: RAISE FND_API.G_EXC_ERROR;

1372: IF(l_create_update_flag = 'E') THEN
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1374: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1375: FND_MSG_PUB.ADD;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: IF(l_create_update_flag = 'C') THEN
1380: do_create_org_contact_bo(

Line 1381: p_init_msg_list => fnd_api.g_false,

1377: END IF;
1378:
1379: IF(l_create_update_flag = 'C') THEN
1380: do_create_org_contact_bo(
1381: p_init_msg_list => fnd_api.g_false,
1382: p_validate_bo_flag => p_validate_bo_flag,
1383: p_org_contact_obj => p_org_contact_obj,
1384: p_created_by_module => p_created_by_module,
1385: p_obj_source => p_obj_source,

Line 1398: p_init_msg_list => fnd_api.g_false,

1394: px_parent_org_osr => px_parent_org_osr
1395: );
1396: ELSIF(l_create_update_flag = 'U') THEN
1397: do_update_org_contact_bo(
1398: p_init_msg_list => fnd_api.g_false,
1399: p_org_contact_obj => p_org_contact_obj,
1400: p_created_by_module => p_created_by_module,
1401: p_obj_source => p_obj_source,
1402: x_return_status => x_return_status,

Line 1410: RAISE FND_API.G_EXC_ERROR;

1406: x_org_contact_os => x_org_contact_os,
1407: x_org_contact_osr => x_org_contact_osr,
1408: p_parent_os => px_parent_org_os );
1409: ELSE
1410: RAISE FND_API.G_EXC_ERROR;
1411: END IF;
1412:
1413: -- Debug info.
1414: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1427: WHEN fnd_api.g_exc_error THEN

1423: p_msg_level=>fnd_log.level_procedure);
1424: END IF;
1425:
1426: EXCEPTION
1427: WHEN fnd_api.g_exc_error THEN
1428: x_return_status := fnd_api.g_ret_sts_error;
1429:
1430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1431: p_count => x_msg_count,

Line 1428: x_return_status := fnd_api.g_ret_sts_error;

1424: END IF;
1425:
1426: EXCEPTION
1427: WHEN fnd_api.g_exc_error THEN
1428: x_return_status := fnd_api.g_ret_sts_error;
1429:
1430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);

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

1426: EXCEPTION
1427: WHEN fnd_api.g_exc_error THEN
1428: x_return_status := fnd_api.g_ret_sts_error;
1429:
1430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: -- Debug info.

Line 1446: WHEN fnd_api.g_exc_unexpected_error THEN

1442: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN
1447: x_return_status := fnd_api.g_ret_sts_unexp_error;
1448:
1449: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1450: p_count => x_msg_count,

Line 1447: x_return_status := fnd_api.g_ret_sts_unexp_error;

1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN
1447: x_return_status := fnd_api.g_ret_sts_unexp_error;
1448:
1449: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1450: p_count => x_msg_count,
1451: p_data => x_msg_data);

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

1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN
1447: x_return_status := fnd_api.g_ret_sts_unexp_error;
1448:
1449: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1450: p_count => x_msg_count,
1451: p_data => x_msg_data);
1452:
1453: -- Debug info.

Line 1466: x_return_status := fnd_api.g_ret_sts_unexp_error;

1462: p_prefix=>l_debug_prefix,
1463: p_msg_level=>fnd_log.level_procedure);
1464: END IF;
1465: WHEN OTHERS THEN
1466: x_return_status := fnd_api.g_ret_sts_unexp_error;
1467:
1468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1469: fnd_message.set_token('ERROR' ,SQLERRM);
1470: fnd_msg_pub.add;

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

1468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1469: fnd_message.set_token('ERROR' ,SQLERRM);
1470: fnd_msg_pub.add;
1471:
1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475:
1476: -- Debug info.

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

1487: END IF;
1488: END do_save_org_contact_bo;
1489:
1490: PROCEDURE save_org_contact_bo(
1491: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1492: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1493: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
1494: p_created_by_module IN VARCHAR2,
1495: x_return_status OUT NOCOPY VARCHAR2,

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

1488: END do_save_org_contact_bo;
1489:
1490: PROCEDURE save_org_contact_bo(
1491: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1492: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1493: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
1494: p_created_by_module IN VARCHAR2,
1495: x_return_status OUT NOCOPY VARCHAR2,
1496: x_msg_count OUT NOCOPY NUMBER,

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

1523: );
1524: END save_org_contact_bo;
1525:
1526: PROCEDURE save_org_contact_bo(
1527: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1528: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
1529: p_created_by_module IN VARCHAR2,
1530: p_obj_source IN VARCHAR2 := null,
1531: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

1527: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1528: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
1529: p_created_by_module IN VARCHAR2,
1530: p_obj_source IN VARCHAR2 := null,
1531: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1532: x_return_status OUT NOCOPY VARCHAR2,
1533: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1534: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
1535: x_org_contact_id OUT NOCOPY NUMBER,

Line 1548: p_init_msg_list => fnd_api.g_true,

1544: l_oc_obj HZ_ORG_CONTACT_BO;
1545: BEGIN
1546: l_oc_obj := p_org_contact_obj;
1547: do_save_org_contact_bo(
1548: p_init_msg_list => fnd_api.g_true,
1549: p_validate_bo_flag => p_validate_bo_flag,
1550: p_org_contact_obj => l_oc_obj,
1551: p_created_by_module => p_created_by_module,
1552: p_obj_source => p_obj_source,

Line 1566: IF FND_API.to_Boolean(p_return_obj_flag) THEN

1562: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1563: x_return_status => x_return_status,
1564: x_msg_count => l_msg_count,
1565: x_msg_data => l_msg_data);
1566: IF FND_API.to_Boolean(p_return_obj_flag) THEN
1567: x_return_obj := l_oc_obj;
1568: END IF;
1569: END save_org_contact_bo;
1570:

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

1578: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1579: --
1580: -- ARGUMENTS
1581: -- IN:
1582: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
1583: -- p_org_contact_id Org Contact id.
1584: -- p_org_contact_os Org contact orig system.
1585: -- p_org_contact_osr Org contact orig system reference.
1586: --

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

1586: --
1587: -- OUT:
1588: -- x_org contact_objs Table of org contact objects.
1589: -- x_return_status Return status after the call. The status can
1590: -- be fnd_api.g_ret_sts_success (success),
1591: -- fnd_api.g_ret_sts_error (error),
1592: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1593: -- x_msg_count Number of messages in message stack.
1594: -- x_msg_data Message text if x_msg_count is 1.

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

1587: -- OUT:
1588: -- x_org contact_objs Table of org contact objects.
1589: -- x_return_status Return status after the call. The status can
1590: -- be fnd_api.g_ret_sts_success (success),
1591: -- fnd_api.g_ret_sts_error (error),
1592: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1593: -- x_msg_count Number of messages in message stack.
1594: -- x_msg_data Message text if x_msg_count is 1.
1595: --

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

1588: -- x_org contact_objs Table of org contact objects.
1589: -- x_return_status Return status after the call. The status can
1590: -- be fnd_api.g_ret_sts_success (success),
1591: -- fnd_api.g_ret_sts_error (error),
1592: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1593: -- x_msg_count Number of messages in message stack.
1594: -- x_msg_data Message text if x_msg_count is 1.
1595: --
1596: -- NOTES

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

1603:
1604:
1605:
1606: PROCEDURE get_org_contact_bo(
1607: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1608: p_org_contact_id IN NUMBER,
1609: p_org_contact_os IN VARCHAR2,
1610: p_org_contact_osr IN VARCHAR2,
1611: x_org_contact_obj OUT NOCOPY HZ_ORG_CONTACT_BO,

Line 1625: x_return_status := FND_API.G_RET_STS_SUCCESS;

1621: l_org_contact_objs HZ_ORG_CONTACT_BO_TBL;
1622: BEGIN
1623:
1624: -- initialize API return status to success.
1625: x_return_status := FND_API.G_RET_STS_SUCCESS;
1626:
1627: -- Initialize message list if p_init_msg_list is set to TRUE
1628: IF FND_API.to_Boolean(p_init_msg_list) THEN
1629: FND_MSG_PUB.initialize;

Line 1628: IF FND_API.to_Boolean(p_init_msg_list) THEN

1624: -- initialize API return status to success.
1625: x_return_status := FND_API.G_RET_STS_SUCCESS;
1626:
1627: -- Initialize message list if p_init_msg_list is set to TRUE
1628: IF FND_API.to_Boolean(p_init_msg_list) THEN
1629: FND_MSG_PUB.initialize;
1630: END IF;
1631:
1632:

Line 1656: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1652: x_return_status => x_return_status,
1653: x_msg_count => x_msg_count,
1654: x_msg_data => x_msg_data);
1655:
1656: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1657: RAISE fnd_api.g_exc_error;
1658: END IF;
1659:
1660: HZ_EXTRACT_ORG_CONT_BO_PVT.get_org_contact_bos

Line 1657: RAISE fnd_api.g_exc_error;

1653: x_msg_count => x_msg_count,
1654: x_msg_data => x_msg_data);
1655:
1656: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1657: RAISE fnd_api.g_exc_error;
1658: END IF;
1659:
1660: HZ_EXTRACT_ORG_CONT_BO_PVT.get_org_contact_bos
1661: (p_init_msg_list => fnd_api.g_false,

Line 1661: (p_init_msg_list => fnd_api.g_false,

1657: RAISE fnd_api.g_exc_error;
1658: END IF;
1659:
1660: HZ_EXTRACT_ORG_CONT_BO_PVT.get_org_contact_bos
1661: (p_init_msg_list => fnd_api.g_false,
1662: p_organization_id => NULL,
1663: p_org_contact_id => l_org_contact_id,
1664: p_action_type => NULL,
1665: x_org_contact_objs => l_org_contact_objs,

Line 1671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1667: x_msg_count => x_msg_count,
1668: x_msg_data => x_msg_data);
1669:
1670: x_org_contact_obj := l_org_contact_objs(1);
1671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: END IF;
1674:
1675:

Line 1672: RAISE FND_API.G_EXC_ERROR;

1668: x_msg_data => x_msg_data);
1669:
1670: x_org_contact_obj := l_org_contact_objs(1);
1671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: END IF;
1674:
1675:
1676: -- Debug info.

Line 1694: WHEN fnd_api.g_exc_error THEN

1690:
1691:
1692: EXCEPTION
1693:
1694: WHEN fnd_api.g_exc_error THEN
1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1698: p_count => x_msg_count,

Line 1695: x_return_status := fnd_api.g_ret_sts_error;

1691:
1692: EXCEPTION
1693:
1694: WHEN fnd_api.g_exc_error THEN
1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1698: p_count => x_msg_count,
1699: p_data => x_msg_data);

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

1693:
1694: WHEN fnd_api.g_exc_error THEN
1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1698: p_count => x_msg_count,
1699: p_data => x_msg_data);
1700:
1701: -- Debug info.

Line 1713: WHEN fnd_api.g_exc_unexpected_error THEN

1709: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1710: p_prefix=>l_debug_prefix,
1711: p_msg_level=>fnd_log.level_procedure);
1712: END IF;
1713: WHEN fnd_api.g_exc_unexpected_error THEN
1714: x_return_status := fnd_api.g_ret_sts_unexp_error;
1715:
1716: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1717: p_count => x_msg_count,

Line 1714: x_return_status := fnd_api.g_ret_sts_unexp_error;

1710: p_prefix=>l_debug_prefix,
1711: p_msg_level=>fnd_log.level_procedure);
1712: END IF;
1713: WHEN fnd_api.g_exc_unexpected_error THEN
1714: x_return_status := fnd_api.g_ret_sts_unexp_error;
1715:
1716: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);

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

1712: END IF;
1713: WHEN fnd_api.g_exc_unexpected_error THEN
1714: x_return_status := fnd_api.g_ret_sts_unexp_error;
1715:
1716: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: -- Debug info.

Line 1733: x_return_status := fnd_api.g_ret_sts_unexp_error;

1729: p_prefix=>l_debug_prefix,
1730: p_msg_level=>fnd_log.level_procedure);
1731: END IF;
1732: WHEN OTHERS THEN
1733: x_return_status := fnd_api.g_ret_sts_unexp_error;
1734:
1735: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1736: fnd_message.set_token('ERROR' ,SQLERRM);
1737: fnd_msg_pub.add;

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

1735: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1736: fnd_message.set_token('ERROR' ,SQLERRM);
1737: fnd_msg_pub.add;
1738:
1739: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data);
1742:
1743: -- Debug info.

Line 1770: p_init_msg_list => fnd_api.g_true,

1766: l_msg_data VARCHAR2(2000);
1767: l_msg_count NUMBER;
1768: BEGIN
1769: get_org_contact_bo(
1770: p_init_msg_list => fnd_api.g_true,
1771: p_org_contact_id => p_org_contact_id,
1772: p_org_contact_os => p_org_contact_os,
1773: p_org_contact_osr => p_org_contact_osr,
1774: x_org_contact_obj => x_org_contact_obj,