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

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

213: -- p_interest_obj Person interest object.
214: -- p_party_id Party ID.
215: -- OUT:
216: -- x_return_status Return status after the call. The status can
217: -- be fnd_api.g_ret_sts_success (success),
218: -- fnd_api.g_ret_sts_error (error),
219: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
220: -- x_msg_count Number of messages in message stack.
221: -- x_msg_data Message text if x_msg_count is 1.

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

214: -- p_party_id Party ID.
215: -- OUT:
216: -- x_return_status Return status after the call. The status can
217: -- be fnd_api.g_ret_sts_success (success),
218: -- fnd_api.g_ret_sts_error (error),
219: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
220: -- x_msg_count Number of messages in message stack.
221: -- x_msg_data Message text if x_msg_count is 1.
222: --

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

215: -- OUT:
216: -- x_return_status Return status after the call. The status can
217: -- be fnd_api.g_ret_sts_success (success),
218: -- fnd_api.g_ret_sts_error (error),
219: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
220: -- x_msg_count Number of messages in message stack.
221: -- x_msg_data Message text if x_msg_count is 1.
222: --
223: -- NOTES

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

256: -- p_interest_obj Person interest object.
257: -- p_party_id Party ID.
258: -- OUT:
259: -- x_return_status Return status after the call. The status can
260: -- be fnd_api.g_ret_sts_success (success),
261: -- fnd_api.g_ret_sts_error (error),
262: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
263: -- x_msg_count Number of messages in message stack.
264: -- x_msg_data Message text if x_msg_count is 1.

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

257: -- p_party_id Party ID.
258: -- OUT:
259: -- x_return_status Return status after the call. The status can
260: -- be fnd_api.g_ret_sts_success (success),
261: -- fnd_api.g_ret_sts_error (error),
262: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
263: -- x_msg_count Number of messages in message stack.
264: -- x_msg_data Message text if x_msg_count is 1.
265: --

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

258: -- OUT:
259: -- x_return_status Return status after the call. The status can
260: -- be fnd_api.g_ret_sts_success (success),
261: -- fnd_api.g_ret_sts_error (error),
262: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
263: -- x_msg_count Number of messages in message stack.
264: -- x_msg_data Message text if x_msg_count is 1.
265: --
266: -- NOTES

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

668: --
669: -- DESCRIPTION
670: -- Create a person business object.
671: PROCEDURE do_create_person_bo(
672: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
673: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
674: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
675: p_created_by_module IN VARCHAR2,
676: p_obj_source IN VARCHAR2 := null,

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

669: -- DESCRIPTION
670: -- Create a person business object.
671: PROCEDURE do_create_person_bo(
672: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
673: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
674: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
675: p_created_by_module IN VARCHAR2,
676: p_obj_source IN VARCHAR2 := null,
677: x_return_status OUT NOCOPY VARCHAR2,

Line 732: x_return_status := FND_API.G_RET_STS_SUCCESS;

728: -- Standard start of API savepoint
729: SAVEPOINT do_create_person_bo_pub;
730:
731: -- initialize API return status to success.
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean(p_init_msg_list) THEN
736: FND_MSG_PUB.initialize;

Line 735: IF FND_API.to_Boolean(p_init_msg_list) THEN

731: -- initialize API return status to success.
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean(p_init_msg_list) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- initialize Global variable

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

751: p_msg_level=>fnd_log.level_procedure);
752: END IF;
753:
754: -- Base on p_validate_bo_flag, check the completeness of business objects
755: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
756: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
757: p_bus_object_code => 'PERSON',
758: x_bus_object => l_bus_object
759: );

Line 766: RAISE fnd_api.g_exc_error;

762: p_person_obj => p_person_obj,
763: p_bus_object => l_bus_object
764: );
765: IF NOT(l_valid_obj) THEN
766: RAISE fnd_api.g_exc_error;
767: END IF;
768:
769: -- find out if raise event at the end
770: l_raise_event := HZ_PARTY_BO_PVT.is_raising_create_event(

Line 799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

795: x_return_status => x_return_status,
796: x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798:
799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802:
803: ---------------------------------

Line 800: RAISE FND_API.G_EXC_ERROR;

796: x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798:
799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802:
803: ---------------------------------
804: -- Assign person and party record

Line 824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

820: x_msg_count => x_msg_count,
821: x_msg_data => x_msg_data
822: );
823:
824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828: -- assign person party_id

Line 825: RAISE FND_API.G_EXC_ERROR;

821: x_msg_data => x_msg_data
822: );
823:
824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828: -- assign person party_id
829: p_person_obj.person_id := x_person_id;

Line 847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

843: x_msg_count => x_msg_count,
844: x_msg_data => x_msg_data
845: );
846:
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: END IF;
851:

Line 848: RAISE FND_API.G_EXC_ERROR;

844: x_msg_data => x_msg_data
845: );
846:
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: END IF;
851:
852: ----------------------------

Line 872: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

868: x_msg_count => x_msg_count,
869: x_msg_data => x_msg_data
870: );
871:
872: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875: END IF;
876:

Line 873: RAISE FND_API.G_EXC_ERROR;

869: x_msg_data => x_msg_data
870: );
871:
872: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875: END IF;
876:
877: ----------------------------

Line 890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

886: x_msg_count => x_msg_count,
887: x_msg_data => x_msg_data
888: );
889:
890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893: END IF;
894:

Line 891: RAISE FND_API.G_EXC_ERROR;

887: x_msg_data => x_msg_data
888: );
889:
890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893: END IF;
894:
895: ----------------------------

Line 909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

905: x_msg_count => x_msg_count,
906: x_msg_data => x_msg_data
907: );
908:
909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: END IF;
913:

Line 910: RAISE FND_API.G_EXC_ERROR;

906: x_msg_data => x_msg_data
907: );
908:
909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: END IF;
913:
914: ----------------------------

Line 928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

924: x_msg_count => x_msg_count,
925: x_msg_data => x_msg_data
926: );
927:
928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;
931: END IF;
932:

Line 929: RAISE FND_API.G_EXC_ERROR;

925: x_msg_data => x_msg_data
926: );
927:
928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;
931: END IF;
932:
933: ----------------------------

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: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

968: p_parent_osr => x_person_osr,
969: p_parent_obj_type => 'PERSON'
970: );
971:
972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: END IF;
976:

Line 973: RAISE FND_API.G_EXC_ERROR;

969: p_parent_obj_type => 'PERSON'
970: );
971:
972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: END IF;
976:
977: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1001: x_msg_count => x_msg_count,
1002: x_msg_data => x_msg_data
1003: );
1004:
1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: END IF;
1009:

Line 1006: RAISE FND_API.G_EXC_ERROR;

1002: x_msg_data => x_msg_data
1003: );
1004:
1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: END IF;
1009:
1010: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1025: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1021: x_msg_count => x_msg_count,
1022: x_msg_data => x_msg_data
1023: );
1024:
1025: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: END IF;
1029:

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022: x_msg_data => x_msg_data
1023: );
1024:
1025: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: END IF;
1029:
1030: ----------------------------

Line 1043: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1044: RAISE FND_API.G_EXC_ERROR;

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

Line 1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1056: x_return_status => x_return_status,
1057: x_msg_count => x_msg_count,
1058: x_msg_data => x_msg_data
1059: );
1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063: END IF;
1064:

Line 1061: RAISE FND_API.G_EXC_ERROR;

1057: x_msg_count => x_msg_count,
1058: x_msg_data => x_msg_data
1059: );
1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063: END IF;
1064:
1065:

Line 1408: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1404: ,x_msg_count => x_msg_count
1405: ,x_msg_data => x_msg_data );
1406:
1407:
1408: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;
1411:
1412: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1409: RAISE FND_API.G_EXC_ERROR;

1405: ,x_msg_data => x_msg_data );
1406:
1407:
1408: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;
1411:
1412: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1413: hz_utility_v2pub.debug(p_message=>'Created dup batch: dup_set_id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

Line 1495: WHEN fnd_api.g_exc_error THEN

1491: p_msg_level=>fnd_log.level_procedure);
1492: END IF;
1493:
1494: EXCEPTION
1495: WHEN fnd_api.g_exc_error THEN
1496: ROLLBACK TO do_create_person_bo_pub;
1497:
1498: -- reset Global variable
1499: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1506: x_return_status := fnd_api.g_ret_sts_error;

1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1503: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1504: FND_MSG_PUB.ADD;
1505:
1506: x_return_status := fnd_api.g_ret_sts_error;
1507:
1508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1509: p_count => x_msg_count,
1510: p_data => x_msg_data);

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

1504: FND_MSG_PUB.ADD;
1505:
1506: x_return_status := fnd_api.g_ret_sts_error;
1507:
1508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1509: p_count => x_msg_count,
1510: p_data => x_msg_data);
1511:
1512: -- Debug info.

Line 1525: WHEN fnd_api.g_exc_unexpected_error THEN

1521: p_prefix=>l_debug_prefix,
1522: p_msg_level=>fnd_log.level_procedure);
1523: END IF;
1524:
1525: WHEN fnd_api.g_exc_unexpected_error THEN
1526: ROLLBACK TO do_create_person_bo_pub;
1527:
1528: -- reset Global variable
1529: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1536: x_return_status := fnd_api.g_ret_sts_unexp_error;

1532: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1533: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1534: FND_MSG_PUB.ADD;
1535:
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537:
1538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1539: p_count => x_msg_count,
1540: p_data => x_msg_data);

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

1534: FND_MSG_PUB.ADD;
1535:
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537:
1538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1539: p_count => x_msg_count,
1540: p_data => x_msg_data);
1541:
1542: -- Debug info.

Line 1566: x_return_status := fnd_api.g_ret_sts_unexp_error;

1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1563: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1564: FND_MSG_PUB.ADD;
1565:
1566: x_return_status := fnd_api.g_ret_sts_unexp_error;
1567:
1568: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1569: fnd_message.set_token('ERROR' ,SQLERRM);
1570: fnd_msg_pub.add;

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

1568: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1569: fnd_message.set_token('ERROR' ,SQLERRM);
1570: fnd_msg_pub.add;
1571:
1572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1573: p_count => x_msg_count,
1574: p_data => x_msg_data);
1575:
1576: -- Debug info.

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

1587: END IF;
1588: END do_create_person_bo;
1589:
1590: PROCEDURE create_person_bo(
1591: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1592: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1593: p_person_obj IN HZ_PERSON_BO,
1594: p_created_by_module IN VARCHAR2,
1595: x_return_status OUT NOCOPY VARCHAR2,

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

1588: END do_create_person_bo;
1589:
1590: PROCEDURE create_person_bo(
1591: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1592: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1593: p_person_obj IN HZ_PERSON_BO,
1594: p_created_by_module IN VARCHAR2,
1595: x_return_status OUT NOCOPY VARCHAR2,
1596: x_msg_count OUT NOCOPY NUMBER,

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

1617: );
1618: END create_person_bo;
1619:
1620: PROCEDURE create_person_bo(
1621: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1622: p_person_obj IN HZ_PERSON_BO,
1623: p_created_by_module IN VARCHAR2,
1624: p_obj_source IN VARCHAR2 := NULL,
1625: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

1621: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1622: p_person_obj IN HZ_PERSON_BO,
1623: p_created_by_module IN VARCHAR2,
1624: p_obj_source IN VARCHAR2 := NULL,
1625: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1626: x_return_status OUT NOCOPY VARCHAR2,
1627: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1628: x_return_obj OUT NOCOPY HZ_PERSON_BO,
1629: x_person_id OUT NOCOPY NUMBER,

Line 1639: p_init_msg_list => FND_API.G_TRUE,

1635: l_per_obj HZ_PERSON_BO;
1636: BEGIN
1637: l_per_obj := p_person_obj;
1638: do_create_person_bo(
1639: p_init_msg_list => FND_API.G_TRUE,
1640: p_validate_bo_flag => p_validate_bo_flag,
1641: p_person_obj => l_per_obj,
1642: p_created_by_module => p_created_by_module,
1643: p_obj_source => p_obj_source,

Line 1655: IF FND_API.to_Boolean(p_return_obj_flag) THEN

1651: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1652: x_return_status => x_return_status,
1653: x_msg_count => l_msg_count,
1654: x_msg_data => l_msg_data);
1655: IF FND_API.to_Boolean(p_return_obj_flag) THEN
1656: x_return_obj := l_per_obj;
1657: END IF;
1658: END create_person_bo;
1659:

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

1661: --
1662: -- DESCRIPTION
1663: -- Update a person business object.
1664: PROCEDURE do_update_person_bo(
1665: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1666: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
1667: p_created_by_module IN VARCHAR2,
1668: p_obj_source IN VARCHAR2 := NULL,
1669: x_return_status OUT NOCOPY VARCHAR2,

Line 1705: x_return_status := FND_API.G_RET_STS_SUCCESS;

1701: -- Standard start of API savepoint
1702: SAVEPOINT do_update_person_bo_pub;
1703:
1704: -- initialize API return status to success.
1705: x_return_status := FND_API.G_RET_STS_SUCCESS;
1706:
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean(p_init_msg_list) THEN
1709: FND_MSG_PUB.initialize;

Line 1708: IF FND_API.to_Boolean(p_init_msg_list) THEN

1704: -- initialize API return status to success.
1705: x_return_status := FND_API.G_RET_STS_SUCCESS;
1706:
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean(p_init_msg_list) THEN
1709: FND_MSG_PUB.initialize;
1710: END IF;
1711:
1712: -- initialize Global variable

Line 1742: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1738: x_return_status => x_return_status,
1739: x_msg_count => x_msg_count,
1740: x_msg_data => x_msg_data);
1741:
1742: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;
1745:
1746: -- must check after calling validate_ssm_id because

Line 1743: RAISE FND_API.G_EXC_ERROR;

1739: x_msg_count => x_msg_count,
1740: x_msg_data => x_msg_data);
1741:
1742: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;
1745:
1746: -- must check after calling validate_ssm_id because
1747: -- if user pass os+osr and no id, validate_ssm_id will

Line 1808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1804: x_msg_count => x_msg_count,
1805: x_msg_data => x_msg_data
1806: );
1807:
1808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1809: RAISE FND_API.G_EXC_ERROR;
1810: END IF;
1811:
1812: -- assign person party_id

Line 1809: RAISE FND_API.G_EXC_ERROR;

1805: x_msg_data => x_msg_data
1806: );
1807:
1808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1809: RAISE FND_API.G_EXC_ERROR;
1810: END IF;
1811:
1812: -- assign person party_id
1813: p_person_obj.person_id := x_person_id;

Line 1831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1827: x_msg_count => x_msg_count,
1828: x_msg_data => x_msg_data
1829: );
1830:
1831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: END IF;
1834: END IF;
1835:

Line 1832: RAISE FND_API.G_EXC_ERROR;

1828: x_msg_data => x_msg_data
1829: );
1830:
1831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: END IF;
1834: END IF;
1835:
1836: ------------------

Line 1856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1852: x_msg_count => x_msg_count,
1853: x_msg_data => x_msg_data
1854: );
1855:
1856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1857: RAISE FND_API.G_EXC_ERROR;
1858: END IF;
1859: END IF;
1860:

Line 1857: RAISE FND_API.G_EXC_ERROR;

1853: x_msg_data => x_msg_data
1854: );
1855:
1856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1857: RAISE FND_API.G_EXC_ERROR;
1858: END IF;
1859: END IF;
1860:
1861: ----------------------------

Line 1874: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1870: x_msg_count => x_msg_count,
1871: x_msg_data => x_msg_data
1872: );
1873:
1874: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1875: RAISE FND_API.G_EXC_ERROR;
1876: END IF;
1877: END IF;
1878:

Line 1875: RAISE FND_API.G_EXC_ERROR;

1871: x_msg_data => x_msg_data
1872: );
1873:
1874: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1875: RAISE FND_API.G_EXC_ERROR;
1876: END IF;
1877: END IF;
1878:
1879: ----------------------------

Line 1893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1889: x_msg_count => x_msg_count,
1890: x_msg_data => x_msg_data
1891: );
1892:
1893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1894: RAISE FND_API.G_EXC_ERROR;
1895: END IF;
1896: END IF;
1897:

Line 1894: RAISE FND_API.G_EXC_ERROR;

1890: x_msg_data => x_msg_data
1891: );
1892:
1893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1894: RAISE FND_API.G_EXC_ERROR;
1895: END IF;
1896: END IF;
1897:
1898: ----------------------------

Line 1912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1908: x_msg_count => x_msg_count,
1909: x_msg_data => x_msg_data
1910: );
1911:
1912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915: END IF;
1916:

Line 1913: RAISE FND_API.G_EXC_ERROR;

1909: x_msg_data => x_msg_data
1910: );
1911:
1912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915: END IF;
1916:
1917: ----------------------------

Line 1931: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1927: x_msg_count => x_msg_count,
1928: x_msg_data => x_msg_data
1929: );
1930:
1931: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: END IF;
1935:

Line 1932: RAISE FND_API.G_EXC_ERROR;

1928: x_msg_data => x_msg_data
1929: );
1930:
1931: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: END IF;
1935:
1936: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 1956: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1952: p_parent_osr => x_person_osr,
1953: p_parent_obj_type => 'PERSON'
1954: );
1955:
1956: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959: END IF;
1960:

Line 1957: RAISE FND_API.G_EXC_ERROR;

1953: p_parent_obj_type => 'PERSON'
1954: );
1955:
1956: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959: END IF;
1960:
1961: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1989: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1985: x_msg_count => x_msg_count,
1986: x_msg_data => x_msg_data
1987: );
1988:
1989: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: END IF;
1992: END IF;
1993:

Line 1990: RAISE FND_API.G_EXC_ERROR;

1986: x_msg_data => x_msg_data
1987: );
1988:
1989: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: END IF;
1992: END IF;
1993:
1994: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 2009: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2005: x_msg_count => x_msg_count,
2006: x_msg_data => x_msg_data
2007: );
2008:
2009: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: END IF;
2012: END IF;
2013:

Line 2010: RAISE FND_API.G_EXC_ERROR;

2006: x_msg_data => x_msg_data
2007: );
2008:
2009: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: END IF;
2012: END IF;
2013:
2014: ---------------------

Line 2027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2023: x_msg_count => x_msg_count,
2024: x_msg_data => x_msg_data
2025: );
2026:
2027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2028: RAISE FND_API.G_EXC_ERROR;
2029: END IF;
2030: END IF;
2031:

Line 2028: RAISE FND_API.G_EXC_ERROR;

2024: x_msg_data => x_msg_data
2025: );
2026:
2027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2028: RAISE FND_API.G_EXC_ERROR;
2029: END IF;
2030: END IF;
2031:
2032: ----------------------------------

Line 2044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2040: x_return_status => x_return_status,
2041: x_msg_count => x_msg_count,
2042: x_msg_data => x_msg_data
2043: );
2044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2045: RAISE FND_API.G_EXC_ERROR;
2046: END IF;
2047: END IF;
2048:

Line 2045: RAISE FND_API.G_EXC_ERROR;

2041: x_msg_count => x_msg_count,
2042: x_msg_data => x_msg_data
2043: );
2044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2045: RAISE FND_API.G_EXC_ERROR;
2046: END IF;
2047: END IF;
2048:
2049:

Line 2088: WHEN fnd_api.g_exc_error THEN

2084: p_prefix=>l_debug_prefix,
2085: p_msg_level=>fnd_log.level_procedure);
2086: END IF;
2087: EXCEPTION
2088: WHEN fnd_api.g_exc_error THEN
2089: ROLLBACK TO do_update_person_bo_pub;
2090:
2091: -- reset Global variable
2092: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2099: x_return_status := fnd_api.g_ret_sts_error;

2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2096: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2097: FND_MSG_PUB.ADD;
2098:
2099: x_return_status := fnd_api.g_ret_sts_error;
2100:
2101: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2102: p_count => x_msg_count,
2103: p_data => x_msg_data);

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

2097: FND_MSG_PUB.ADD;
2098:
2099: x_return_status := fnd_api.g_ret_sts_error;
2100:
2101: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2102: p_count => x_msg_count,
2103: p_data => x_msg_data);
2104:
2105: -- Debug info.

Line 2119: WHEN fnd_api.g_exc_unexpected_error THEN

2115: p_msg_level=>fnd_log.level_procedure);
2116: END IF;
2117:
2118:
2119: WHEN fnd_api.g_exc_unexpected_error THEN
2120: ROLLBACK TO do_update_person_bo_pub;
2121:
2122: -- reset Global variable
2123: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2130: x_return_status := fnd_api.g_ret_sts_unexp_error;

2126: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2127: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2128: FND_MSG_PUB.ADD;
2129:
2130: x_return_status := fnd_api.g_ret_sts_unexp_error;
2131:
2132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2133: p_count => x_msg_count,
2134: p_data => x_msg_data);

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

2128: FND_MSG_PUB.ADD;
2129:
2130: x_return_status := fnd_api.g_ret_sts_unexp_error;
2131:
2132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2133: p_count => x_msg_count,
2134: p_data => x_msg_data);
2135:
2136: -- Debug info.

Line 2159: x_return_status := fnd_api.g_ret_sts_unexp_error;

2155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2156: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2157: FND_MSG_PUB.ADD;
2158:
2159: x_return_status := fnd_api.g_ret_sts_unexp_error;
2160:
2161: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2162: fnd_message.set_token('ERROR' ,SQLERRM);
2163: fnd_msg_pub.add;

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

2161: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2162: fnd_message.set_token('ERROR' ,SQLERRM);
2163: fnd_msg_pub.add;
2164:
2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2166: p_count => x_msg_count,
2167: p_data => x_msg_data);
2168:
2169: -- Debug info.

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

2180: END IF;
2181: END do_update_person_bo;
2182:
2183: PROCEDURE update_person_bo(
2184: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2185: p_person_obj IN HZ_PERSON_BO,
2186: p_created_by_module IN VARCHAR2,
2187: x_return_status OUT NOCOPY VARCHAR2,
2188: x_msg_count OUT NOCOPY NUMBER,

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

2211: PROCEDURE update_person_bo(
2212: p_person_obj IN HZ_PERSON_BO,
2213: p_created_by_module IN VARCHAR2,
2214: p_obj_source IN VARCHAR2 := null,
2215: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2216: x_return_status OUT NOCOPY VARCHAR2,
2217: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2218: x_return_obj OUT NOCOPY HZ_PERSON_BO,
2219: x_person_id OUT NOCOPY NUMBER,

Line 2229: p_init_msg_list => FND_API.G_TRUE,

2225: l_per_obj HZ_PERSON_BO;
2226: BEGIN
2227: l_per_obj := p_person_obj;
2228: do_update_person_bo(
2229: p_init_msg_list => FND_API.G_TRUE,
2230: p_person_obj => l_per_obj,
2231: p_created_by_module => p_created_by_module,
2232: p_obj_source => p_obj_source,
2233: x_return_status => x_return_status,

Line 2244: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2240: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2241: x_return_status => x_return_status,
2242: x_msg_count => l_msg_count,
2243: x_msg_data => l_msg_data);
2244: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2245: x_return_obj := l_per_obj;
2246: END IF;
2247: END update_person_bo;
2248:

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

2250: --
2251: -- DESCRIPTION
2252: -- Create or update a person business object.
2253: PROCEDURE do_save_person_bo(
2254: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2255: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2256: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
2257: p_created_by_module IN VARCHAR2,
2258: p_obj_source IN VARCHAR2 := null,

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

2251: -- DESCRIPTION
2252: -- Create or update a person business object.
2253: PROCEDURE do_save_person_bo(
2254: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2255: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2256: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
2257: p_created_by_module IN VARCHAR2,
2258: p_obj_source IN VARCHAR2 := null,
2259: x_return_status OUT NOCOPY VARCHAR2,

Line 2273: x_return_status := FND_API.G_RET_STS_SUCCESS;

2269: l_create_update_flag VARCHAR2(1);
2270: l_debug_prefix VARCHAR2(30);
2271: BEGIN
2272: -- initialize API return status to success.
2273: x_return_status := FND_API.G_RET_STS_SUCCESS;
2274:
2275: -- Initialize message list if p_init_msg_list is set to TRUE.
2276: IF FND_API.to_Boolean(p_init_msg_list) THEN
2277: FND_MSG_PUB.initialize;

Line 2276: IF FND_API.to_Boolean(p_init_msg_list) THEN

2272: -- initialize API return status to success.
2273: x_return_status := FND_API.G_RET_STS_SUCCESS;
2274:
2275: -- Initialize message list if p_init_msg_list is set to TRUE.
2276: IF FND_API.to_Boolean(p_init_msg_list) THEN
2277: FND_MSG_PUB.initialize;
2278: END IF;
2279:
2280: -- Debug info.

Line 2307: RAISE FND_API.G_EXC_ERROR;

2303: FND_MSG_PUB.ADD;
2304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2305: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:
2310: IF(l_create_update_flag = 'C') THEN
2311: do_create_person_bo(

Line 2312: p_init_msg_list => fnd_api.g_false,

2308: END IF;
2309:
2310: IF(l_create_update_flag = 'C') THEN
2311: do_create_person_bo(
2312: p_init_msg_list => fnd_api.g_false,
2313: p_validate_bo_flag => p_validate_bo_flag,
2314: p_person_obj => p_person_obj,
2315: p_created_by_module => p_created_by_module,
2316: p_obj_source => p_obj_source,

Line 2326: p_init_msg_list => fnd_api.g_false,

2322: x_person_osr => x_person_osr
2323: );
2324: ELSIF(l_create_update_flag = 'U') THEN
2325: do_update_person_bo(
2326: p_init_msg_list => fnd_api.g_false,
2327: p_person_obj => p_person_obj,
2328: p_created_by_module => p_created_by_module,
2329: p_obj_source => p_obj_source,
2330: x_return_status => x_return_status,

Line 2338: RAISE FND_API.G_EXC_ERROR;

2334: x_person_os => x_person_os,
2335: x_person_osr => x_person_osr
2336: );
2337: ELSE
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340:
2341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2342: RAISE FND_API.G_EXC_ERROR;

Line 2341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2337: ELSE
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340:
2341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344:
2345: -- Debug info.

Line 2342: RAISE FND_API.G_EXC_ERROR;

2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340:
2341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344:
2345: -- Debug info.
2346: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2358: WHEN fnd_api.g_exc_error THEN

2354: p_prefix=>l_debug_prefix,
2355: p_msg_level=>fnd_log.level_procedure);
2356: END IF;
2357: EXCEPTION
2358: WHEN fnd_api.g_exc_error THEN
2359: x_return_status := fnd_api.g_ret_sts_error;
2360:
2361: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2362: p_count => x_msg_count,

Line 2359: x_return_status := fnd_api.g_ret_sts_error;

2355: p_msg_level=>fnd_log.level_procedure);
2356: END IF;
2357: EXCEPTION
2358: WHEN fnd_api.g_exc_error THEN
2359: x_return_status := fnd_api.g_ret_sts_error;
2360:
2361: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2362: p_count => x_msg_count,
2363: p_data => x_msg_data);

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

2357: EXCEPTION
2358: WHEN fnd_api.g_exc_error THEN
2359: x_return_status := fnd_api.g_ret_sts_error;
2360:
2361: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2362: p_count => x_msg_count,
2363: p_data => x_msg_data);
2364:
2365: -- Debug info.

Line 2378: WHEN fnd_api.g_exc_unexpected_error THEN

2374: p_prefix=>l_debug_prefix,
2375: p_msg_level=>fnd_log.level_procedure);
2376: END IF;
2377:
2378: WHEN fnd_api.g_exc_unexpected_error THEN
2379: x_return_status := fnd_api.g_ret_sts_unexp_error;
2380:
2381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2382: p_count => x_msg_count,

Line 2379: x_return_status := fnd_api.g_ret_sts_unexp_error;

2375: p_msg_level=>fnd_log.level_procedure);
2376: END IF;
2377:
2378: WHEN fnd_api.g_exc_unexpected_error THEN
2379: x_return_status := fnd_api.g_ret_sts_unexp_error;
2380:
2381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2382: p_count => x_msg_count,
2383: p_data => x_msg_data);

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

2377:
2378: WHEN fnd_api.g_exc_unexpected_error THEN
2379: x_return_status := fnd_api.g_ret_sts_unexp_error;
2380:
2381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2382: p_count => x_msg_count,
2383: p_data => x_msg_data);
2384:
2385: -- Debug info.

Line 2398: x_return_status := fnd_api.g_ret_sts_unexp_error;

2394: p_prefix=>l_debug_prefix,
2395: p_msg_level=>fnd_log.level_procedure);
2396: END IF;
2397: WHEN OTHERS THEN
2398: x_return_status := fnd_api.g_ret_sts_unexp_error;
2399:
2400: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR' ,SQLERRM);
2402: fnd_msg_pub.add;

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

2400: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR' ,SQLERRM);
2402: fnd_msg_pub.add;
2403:
2404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2405: p_count => x_msg_count,
2406: p_data => x_msg_data);
2407:
2408: -- Debug info.

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

2419: END IF;
2420: END do_save_person_bo;
2421:
2422: PROCEDURE save_person_bo(
2423: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2424: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2425: p_person_obj IN HZ_PERSON_BO,
2426: p_created_by_module IN VARCHAR2,
2427: x_return_status OUT NOCOPY VARCHAR2,

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

2420: END do_save_person_bo;
2421:
2422: PROCEDURE save_person_bo(
2423: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2424: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2425: p_person_obj IN HZ_PERSON_BO,
2426: p_created_by_module IN VARCHAR2,
2427: x_return_status OUT NOCOPY VARCHAR2,
2428: x_msg_count OUT NOCOPY NUMBER,

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

2449: );
2450: END save_person_bo;
2451:
2452: PROCEDURE save_person_bo(
2453: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2454: p_person_obj IN HZ_PERSON_BO,
2455: p_created_by_module IN VARCHAR2,
2456: p_obj_source IN VARCHAR2 := NULL,
2457: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

2453: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2454: p_person_obj IN HZ_PERSON_BO,
2455: p_created_by_module IN VARCHAR2,
2456: p_obj_source IN VARCHAR2 := NULL,
2457: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2458: x_return_status OUT NOCOPY VARCHAR2,
2459: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2460: x_return_obj OUT NOCOPY HZ_PERSON_BO,
2461: x_person_id OUT NOCOPY NUMBER,

Line 2471: p_init_msg_list => FND_API.G_TRUE,

2467: l_per_obj HZ_PERSON_BO;
2468: BEGIN
2469: l_per_obj := p_person_obj;
2470: do_save_person_bo(
2471: p_init_msg_list => FND_API.G_TRUE,
2472: p_validate_bo_flag => p_validate_bo_flag,
2473: p_person_obj => l_per_obj,
2474: p_created_by_module => p_created_by_module,
2475: p_obj_source => p_obj_source,

Line 2487: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2483: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2484: x_return_status => x_return_status,
2485: x_msg_count => l_msg_count,
2486: x_msg_data => l_msg_data);
2487: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2488: x_return_obj := l_per_obj;
2489: END IF;
2490: END save_person_bo;
2491:

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

2506: -- p_interest_obj Person interest object.
2507: -- p_party_id Party ID.
2508: -- OUT:
2509: -- x_return_status Return status after the call. The status can
2510: -- be fnd_api.g_ret_sts_success (success),
2511: -- fnd_api.g_ret_sts_error (error),
2512: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2513: -- x_msg_count Number of messages in message stack.
2514: -- x_msg_data Message text if x_msg_count is 1.

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

2507: -- p_party_id Party ID.
2508: -- OUT:
2509: -- x_return_status Return status after the call. The status can
2510: -- be fnd_api.g_ret_sts_success (success),
2511: -- fnd_api.g_ret_sts_error (error),
2512: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2513: -- x_msg_count Number of messages in message stack.
2514: -- x_msg_data Message text if x_msg_count is 1.
2515: --

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

2508: -- OUT:
2509: -- x_return_status Return status after the call. The status can
2510: -- be fnd_api.g_ret_sts_success (success),
2511: -- fnd_api.g_ret_sts_error (error),
2512: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2513: -- x_msg_count Number of messages in message stack.
2514: -- x_msg_data Message text if x_msg_count is 1.
2515: --
2516: -- NOTES

Line 2547: x_return_status := FND_API.G_RET_STS_SUCCESS;

2543: -- Standard start of API savepoint
2544: SAVEPOINT create_person_info_pub;
2545:
2546: -- initialize API return status to success.
2547: x_return_status := FND_API.G_RET_STS_SUCCESS;
2548:
2549: -- Debug info.
2550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2551: hz_utility_v2pub.debug(p_message=>'create_person_info(+)',

Line 2575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2571: x_msg_count => x_msg_count,
2572: x_msg_data => x_msg_data
2573: );
2574:
2575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2577: hz_utility_v2pub.debug(p_message=>'Create Person Language - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2578: p_prefix=>l_debug_prefix,
2579: p_msg_level=>fnd_log.level_procedure);

Line 2584: RAISE FND_API.G_EXC_ERROR;

2580: END IF;
2581: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2582: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586:
2587: -- assign person language_use_reference_id
2588: p_language_obj(i).language_use_reference_id := l_dummy_id;

Line 2611: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2607: x_msg_count => x_msg_count,
2608: x_msg_data => x_msg_data
2609: );
2610:
2611: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2613: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2614: p_prefix=>l_debug_prefix,
2615: p_msg_level=>fnd_log.level_procedure);

Line 2620: RAISE FND_API.G_EXC_ERROR;

2616: END IF;
2617: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2618: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:
2623: -- assign education_id
2624: p_education_obj(i).education_id := l_dummy_id;

Line 2647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2643: x_msg_count => x_msg_count,
2644: x_msg_data => x_msg_data
2645: );
2646:
2647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2649: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2650: p_prefix=>l_debug_prefix,
2651: p_msg_level=>fnd_log.level_procedure);

Line 2656: RAISE FND_API.G_EXC_ERROR;

2652: END IF;
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2654: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;
2658:
2659: -- assign citizenship_id
2660: p_citizenship_obj(i).citizenship_id := l_dummy_id;

Line 2683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2679: x_msg_count => x_msg_count,
2680: x_msg_data => x_msg_data
2681: );
2682:
2683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2685: hz_utility_v2pub.debug(p_message=>'Create Employment History - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2686: p_prefix=>l_debug_prefix,
2687: p_msg_level=>fnd_log.level_procedure);

Line 2692: RAISE FND_API.G_EXC_ERROR;

2688: END IF;
2689: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2690: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2691: FND_MSG_PUB.ADD;
2692: RAISE FND_API.G_EXC_ERROR;
2693: ELSE
2694:
2695: -- assign employment_history_id
2696: p_employ_hist_obj(i).employment_history_id := l_dummy_id;

Line 2718: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2714: x_msg_count => x_msg_count,
2715: x_msg_data => x_msg_data
2716: );
2717:
2718: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2720: hz_utility_v2pub.debug(p_message=>'Create Work Class - Error occurred at hz_person_bo_pub.create_person_info, employ_hist_id: '||l_dummy_id,
2721: p_prefix=>l_debug_prefix,
2722: p_msg_level=>fnd_log.level_procedure);

Line 2727: RAISE FND_API.G_EXC_ERROR;

2723: END IF;
2724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2725: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2726: FND_MSG_PUB.ADD;
2727: RAISE FND_API.G_EXC_ERROR;
2728: END IF;
2729:
2730: -- assign work_class_id
2731: p_employ_hist_obj(i).work_class_objs(j).work_class_id := l_dummy_id;

Line 2757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2753: x_msg_count => x_msg_count,
2754: x_msg_data => x_msg_data
2755: );
2756:
2757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'Create Person Interest - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);

Line 2766: RAISE FND_API.G_EXC_ERROR;

2762: END IF;
2763: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2764: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;
2768:
2769: -- assign person_interest_id
2770: p_interest_obj(i).person_interest_id := l_dummy_id;

Line 2787: WHEN fnd_api.g_exc_error THEN

2783: p_prefix=>l_debug_prefix,
2784: p_msg_level=>fnd_log.level_procedure);
2785: END IF;
2786: EXCEPTION
2787: WHEN fnd_api.g_exc_error THEN
2788: ROLLBACK TO create_person_info_pub;
2789: x_return_status := fnd_api.g_ret_sts_error;
2790:
2791: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2789: x_return_status := fnd_api.g_ret_sts_error;

2785: END IF;
2786: EXCEPTION
2787: WHEN fnd_api.g_exc_error THEN
2788: ROLLBACK TO create_person_info_pub;
2789: x_return_status := fnd_api.g_ret_sts_error;
2790:
2791: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2792: p_count => x_msg_count,
2793: p_data => x_msg_data);

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

2787: WHEN fnd_api.g_exc_error THEN
2788: ROLLBACK TO create_person_info_pub;
2789: x_return_status := fnd_api.g_ret_sts_error;
2790:
2791: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2792: p_count => x_msg_count,
2793: p_data => x_msg_data);
2794:
2795: -- Debug info.

Line 2807: WHEN fnd_api.g_exc_unexpected_error THEN

2803: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2804: p_prefix=>l_debug_prefix,
2805: p_msg_level=>fnd_log.level_procedure);
2806: END IF;
2807: WHEN fnd_api.g_exc_unexpected_error THEN
2808: ROLLBACK TO create_person_info_pub;
2809: x_return_status := fnd_api.g_ret_sts_unexp_error;
2810:
2811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2809: x_return_status := fnd_api.g_ret_sts_unexp_error;

2805: p_msg_level=>fnd_log.level_procedure);
2806: END IF;
2807: WHEN fnd_api.g_exc_unexpected_error THEN
2808: ROLLBACK TO create_person_info_pub;
2809: x_return_status := fnd_api.g_ret_sts_unexp_error;
2810:
2811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2812: p_count => x_msg_count,
2813: p_data => x_msg_data);

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

2807: WHEN fnd_api.g_exc_unexpected_error THEN
2808: ROLLBACK TO create_person_info_pub;
2809: x_return_status := fnd_api.g_ret_sts_unexp_error;
2810:
2811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2812: p_count => x_msg_count,
2813: p_data => x_msg_data);
2814:
2815: -- Debug info.

Line 2830: x_return_status := fnd_api.g_ret_sts_unexp_error;

2826: END IF;
2827:
2828: WHEN OTHERS THEN
2829: ROLLBACK TO create_person_info_pub;
2830: x_return_status := fnd_api.g_ret_sts_unexp_error;
2831:
2832: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2833: fnd_message.set_token('ERROR' ,SQLERRM);
2834: fnd_msg_pub.add;

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

2832: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2833: fnd_message.set_token('ERROR' ,SQLERRM);
2834: fnd_msg_pub.add;
2835:
2836: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2837: p_count => x_msg_count,
2838: p_data => x_msg_data);
2839:
2840: -- Debug info.

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

2868: -- p_interest_obj Person interest object.
2869: -- p_party_id Party ID.
2870: -- OUT:
2871: -- x_return_status Return status after the call. The status can
2872: -- be fnd_api.g_ret_sts_success (success),
2873: -- fnd_api.g_ret_sts_error (error),
2874: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2875: -- x_msg_count Number of messages in message stack.
2876: -- x_msg_data Message text if x_msg_count is 1.

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

2869: -- p_party_id Party ID.
2870: -- OUT:
2871: -- x_return_status Return status after the call. The status can
2872: -- be fnd_api.g_ret_sts_success (success),
2873: -- fnd_api.g_ret_sts_error (error),
2874: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2875: -- x_msg_count Number of messages in message stack.
2876: -- x_msg_data Message text if x_msg_count is 1.
2877: --

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

2870: -- OUT:
2871: -- x_return_status Return status after the call. The status can
2872: -- be fnd_api.g_ret_sts_success (success),
2873: -- fnd_api.g_ret_sts_error (error),
2874: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2875: -- x_msg_count Number of messages in message stack.
2876: -- x_msg_data Message text if x_msg_count is 1.
2877: --
2878: -- NOTES

Line 2910: x_return_status := FND_API.G_RET_STS_SUCCESS;

2906: -- Standard start of API savepoint
2907: SAVEPOINT save_person_info_pub;
2908:
2909: -- initialize API return status to success.
2910: x_return_status := FND_API.G_RET_STS_SUCCESS;
2911:
2912: -- Debug info.
2913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2914: hz_utility_v2pub.debug(p_message=>'save_person_info(+)',

Line 2948: RAISE FND_API.G_EXC_ERROR;

2944: FND_MSG_PUB.ADD;
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2946: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2947: FND_MSG_PUB.ADD;
2948: RAISE FND_API.G_EXC_ERROR;
2949: END IF;
2950:
2951: IF(l_ovn IS NULL) THEN
2952: HZ_PERSON_INFO_V2PUB.create_person_language(

Line 2976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2972:
2973: -- assign person language_use_reference_id
2974: p_language_obj(i).language_use_reference_id := l_person_lang_rec.language_use_reference_id;
2975: END IF;
2976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2978: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2979: p_prefix=>l_debug_prefix,
2980: p_msg_level=>fnd_log.level_procedure);

Line 2985: RAISE FND_API.G_EXC_ERROR;

2981: END IF;
2982: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2983: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2984: FND_MSG_PUB.ADD;
2985: RAISE FND_API.G_EXC_ERROR;
2986: END IF;
2987: END LOOP;
2988: END IF;
2989:

Line 3021: RAISE FND_API.G_EXC_ERROR;

3017: FND_MSG_PUB.ADD;
3018: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3019: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_ERROR;
3022: END IF;
3023:
3024: IF(l_ovn IS NULL) THEN
3025: HZ_PERSON_INFO_V2PUB.create_education(

Line 3049: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3045:
3046: -- assign education_id
3047: p_education_obj(i).education_id := l_education_rec.education_id;
3048: END IF;
3049: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3050: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3051: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
3052: p_prefix=>l_debug_prefix,
3053: p_msg_level=>fnd_log.level_procedure);

Line 3058: RAISE FND_API.G_EXC_ERROR;

3054: END IF;
3055: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3056: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
3057: FND_MSG_PUB.ADD;
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;
3060: END LOOP;
3061: END IF;
3062:

Line 3092: RAISE FND_API.G_EXC_ERROR;

3088: FND_MSG_PUB.ADD;
3089: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3090: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
3091: FND_MSG_PUB.ADD;
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3094:
3095: IF(l_ovn IS NULL) THEN
3096: HZ_PERSON_INFO_V2PUB.create_citizenship(

Line 3120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3116:
3117: -- assign citizenship_id
3118: p_citizenship_obj(i).citizenship_id := l_citizenship_rec.citizenship_id;
3119: END IF;
3120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
3123: p_prefix=>l_debug_prefix,
3124: p_msg_level=>fnd_log.level_procedure);

Line 3129: RAISE FND_API.G_EXC_ERROR;

3125: END IF;
3126: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3127: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
3128: FND_MSG_PUB.ADD;
3129: RAISE FND_API.G_EXC_ERROR;
3130: END IF;
3131: END LOOP;
3132: END IF;
3133:

Line 3165: RAISE FND_API.G_EXC_ERROR;

3161: FND_MSG_PUB.ADD;
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
3163: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_ERROR;
3166: END IF;
3167:
3168: IF(l_ovn IS NULL) THEN
3169: HZ_PERSON_INFO_V2PUB.create_employment_history(

Line 3194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3190:
3191: -- assign employment_history_id
3192: p_employ_hist_obj(i).employment_history_id := l_dummy_id;
3193: END IF;
3194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3196: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
3197: p_prefix=>l_debug_prefix,
3198: p_msg_level=>fnd_log.level_procedure);

Line 3203: RAISE FND_API.G_EXC_ERROR;

3199: END IF;
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
3201: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: ELSE
3205: ---------------------------
3206: -- Create/Update work class
3207: ---------------------------

Line 3234: RAISE FND_API.G_EXC_ERROR;

3230: FND_MSG_PUB.ADD;
3231: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3232: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
3233: FND_MSG_PUB.ADD;
3234: RAISE FND_API.G_EXC_ERROR;
3235: END IF;
3236:
3237: IF(l_ovn IS NULL) THEN
3238: HZ_PERSON_INFO_V2PUB.create_work_class(

Line 3262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3258:
3259: -- assign work_class_id
3260: p_employ_hist_obj(i).work_class_objs(j).work_class_id := l_work_class_rec.work_class_id;
3261: END IF;
3262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3264: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.save_person_info, employ_hist_id: '||l_dummy_id||' '||' ovn:'||l_ovn,
3265: p_prefix=>l_debug_prefix,
3266: p_msg_level=>fnd_log.level_procedure);

Line 3271: RAISE FND_API.G_EXC_ERROR;

3267: END IF;
3268: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3269: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
3270: FND_MSG_PUB.ADD;
3271: RAISE FND_API.G_EXC_ERROR;
3272: END IF;
3273: END LOOP;
3274: END IF;
3275: END IF;

Line 3310: RAISE FND_API.G_EXC_ERROR;

3306: FND_MSG_PUB.ADD;
3307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:
3313: IF(l_ovn IS NULL) THEN
3314: HZ_PERSON_INFO_V2PUB.create_person_interest(

Line 3338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3334:
3335: -- assign person_interest_id
3336: p_interest_obj(i).person_interest_id := l_interest_rec.person_interest_id;
3337: END IF;
3338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3339: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3340: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
3341: p_prefix=>l_debug_prefix,
3342: p_msg_level=>fnd_log.level_procedure);

Line 3347: RAISE FND_API.G_EXC_ERROR;

3343: END IF;
3344: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3345: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
3346: FND_MSG_PUB.ADD;
3347: RAISE FND_API.G_EXC_ERROR;
3348: END IF;
3349: END LOOP;
3350: END IF;
3351:

Line 3365: WHEN fnd_api.g_exc_error THEN

3361: p_prefix=>l_debug_prefix,
3362: p_msg_level=>fnd_log.level_procedure);
3363: END IF;
3364: EXCEPTION
3365: WHEN fnd_api.g_exc_error THEN
3366: ROLLBACK TO save_person_info_pub;
3367: x_return_status := fnd_api.g_ret_sts_error;
3368:
3369: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 3367: x_return_status := fnd_api.g_ret_sts_error;

3363: END IF;
3364: EXCEPTION
3365: WHEN fnd_api.g_exc_error THEN
3366: ROLLBACK TO save_person_info_pub;
3367: x_return_status := fnd_api.g_ret_sts_error;
3368:
3369: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3370: p_count => x_msg_count,
3371: p_data => x_msg_data);

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

3365: WHEN fnd_api.g_exc_error THEN
3366: ROLLBACK TO save_person_info_pub;
3367: x_return_status := fnd_api.g_ret_sts_error;
3368:
3369: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3370: p_count => x_msg_count,
3371: p_data => x_msg_data);
3372:
3373: -- Debug info.

Line 3385: WHEN fnd_api.g_exc_unexpected_error THEN

3381: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
3382: p_prefix=>l_debug_prefix,
3383: p_msg_level=>fnd_log.level_procedure);
3384: END IF;
3385: WHEN fnd_api.g_exc_unexpected_error THEN
3386: ROLLBACK TO save_person_info_pub;
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:
3389: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 3387: x_return_status := fnd_api.g_ret_sts_unexp_error;

3383: p_msg_level=>fnd_log.level_procedure);
3384: END IF;
3385: WHEN fnd_api.g_exc_unexpected_error THEN
3386: ROLLBACK TO save_person_info_pub;
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:
3389: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3390: p_count => x_msg_count,
3391: p_data => x_msg_data);

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

3385: WHEN fnd_api.g_exc_unexpected_error THEN
3386: ROLLBACK TO save_person_info_pub;
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:
3389: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3390: p_count => x_msg_count,
3391: p_data => x_msg_data);
3392:
3393: -- Debug info.

Line 3408: x_return_status := fnd_api.g_ret_sts_unexp_error;

3404: END IF;
3405:
3406: WHEN OTHERS THEN
3407: ROLLBACK TO save_person_info_pub;
3408: x_return_status := fnd_api.g_ret_sts_unexp_error;
3409:
3410: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3411: fnd_message.set_token('ERROR' ,SQLERRM);
3412: fnd_msg_pub.add;

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

3410: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3411: fnd_message.set_token('ERROR' ,SQLERRM);
3412: fnd_msg_pub.add;
3413:
3414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3415: p_count => x_msg_count,
3416: p_data => x_msg_data);
3417:
3418: -- Debug info.

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

3439: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3440: --
3441: -- ARGUMENTS
3442: -- IN:
3443: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
3444: -- p_person_id Person ID.
3445: -- p_person_os Person orig system.
3446: -- p_person_osr Person orig system reference.
3447: -- OUT:

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

3446: -- p_person_osr Person orig system reference.
3447: -- OUT:
3448: -- x_person_obj Logical person record.
3449: -- x_return_status Return status after the call. The status can
3450: -- be fnd_api.g_ret_sts_success (success),
3451: -- fnd_api.g_ret_sts_error (error),
3452: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3453: -- x_msg_count Number of messages in message stack.
3454: -- x_msg_data Message text if x_msg_count is 1.

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

3447: -- OUT:
3448: -- x_person_obj Logical person record.
3449: -- x_return_status Return status after the call. The status can
3450: -- be fnd_api.g_ret_sts_success (success),
3451: -- fnd_api.g_ret_sts_error (error),
3452: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3453: -- x_msg_count Number of messages in message stack.
3454: -- x_msg_data Message text if x_msg_count is 1.
3455: --

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

3448: -- x_person_obj Logical person record.
3449: -- x_return_status Return status after the call. The status can
3450: -- be fnd_api.g_ret_sts_success (success),
3451: -- fnd_api.g_ret_sts_error (error),
3452: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3453: -- x_msg_count Number of messages in message stack.
3454: -- x_msg_data Message text if x_msg_count is 1.
3455: --
3456: -- NOTES

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

3498: Financial Profile N Y HZ_FINANCIAL_PROFILE
3499: */
3500:
3501: PROCEDURE get_person_bo (
3502: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3503: p_person_id IN NUMBER,
3504: p_person_os IN VARCHAR2,
3505: p_person_osr IN VARCHAR2,
3506: x_person_obj OUT NOCOPY HZ_PERSON_BO,

Line 3519: x_return_status := FND_API.G_RET_STS_SUCCESS;

3515: l_person_osr varchar2(255);
3516: BEGIN
3517:
3518: -- initialize API return status to success.
3519: x_return_status := FND_API.G_RET_STS_SUCCESS;
3520:
3521: -- Initialize message list if p_init_msg_list is set to TRUE
3522: IF FND_API.to_Boolean(p_init_msg_list) THEN
3523: FND_MSG_PUB.initialize;

Line 3522: IF FND_API.to_Boolean(p_init_msg_list) THEN

3518: -- initialize API return status to success.
3519: x_return_status := FND_API.G_RET_STS_SUCCESS;
3520:
3521: -- Initialize message list if p_init_msg_list is set to TRUE
3522: IF FND_API.to_Boolean(p_init_msg_list) THEN
3523: FND_MSG_PUB.initialize;
3524: END IF;
3525:
3526:

Line 3550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3546: x_return_status => x_return_status,
3547: x_msg_count => x_msg_count,
3548: x_msg_data => x_msg_data);
3549:
3550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3551: RAISE fnd_api.g_exc_error;
3552: END IF;
3553:
3554: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(

Line 3551: RAISE fnd_api.g_exc_error;

3547: x_msg_count => x_msg_count,
3548: x_msg_data => x_msg_data);
3549:
3550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3551: RAISE fnd_api.g_exc_error;
3552: END IF;
3553:
3554: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
3555: p_init_msg_list => fnd_api.g_false,

Line 3555: p_init_msg_list => fnd_api.g_false,

3551: RAISE fnd_api.g_exc_error;
3552: END IF;
3553:
3554: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
3555: p_init_msg_list => fnd_api.g_false,
3556: p_person_id => l_person_id,
3557: p_action_type => NULL,
3558: x_person_obj => x_person_obj,
3559: x_return_status => x_return_status,

Line 3563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3559: x_return_status => x_return_status,
3560: x_msg_count => x_msg_count,
3561: x_msg_data => x_msg_data);
3562:
3563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3564: RAISE FND_API.G_EXC_ERROR;
3565: END IF;
3566:
3567:

Line 3564: RAISE FND_API.G_EXC_ERROR;

3560: x_msg_count => x_msg_count,
3561: x_msg_data => x_msg_data);
3562:
3563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3564: RAISE FND_API.G_EXC_ERROR;
3565: END IF;
3566:
3567:
3568: -- Debug info.

Line 3586: WHEN fnd_api.g_exc_error THEN

3582:
3583:
3584: EXCEPTION
3585:
3586: WHEN fnd_api.g_exc_error THEN
3587: x_return_status := fnd_api.g_ret_sts_error;
3588:
3589: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3590: p_count => x_msg_count,

Line 3587: x_return_status := fnd_api.g_ret_sts_error;

3583:
3584: EXCEPTION
3585:
3586: WHEN fnd_api.g_exc_error THEN
3587: x_return_status := fnd_api.g_ret_sts_error;
3588:
3589: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3590: p_count => x_msg_count,
3591: p_data => x_msg_data);

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

3585:
3586: WHEN fnd_api.g_exc_error THEN
3587: x_return_status := fnd_api.g_ret_sts_error;
3588:
3589: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3590: p_count => x_msg_count,
3591: p_data => x_msg_data);
3592:
3593: -- Debug info.

Line 3605: WHEN fnd_api.g_exc_unexpected_error THEN

3601: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3602: p_prefix=>l_debug_prefix,
3603: p_msg_level=>fnd_log.level_procedure);
3604: END IF;
3605: WHEN fnd_api.g_exc_unexpected_error THEN
3606: x_return_status := fnd_api.g_ret_sts_unexp_error;
3607:
3608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3609: p_count => x_msg_count,

Line 3606: x_return_status := fnd_api.g_ret_sts_unexp_error;

3602: p_prefix=>l_debug_prefix,
3603: p_msg_level=>fnd_log.level_procedure);
3604: END IF;
3605: WHEN fnd_api.g_exc_unexpected_error THEN
3606: x_return_status := fnd_api.g_ret_sts_unexp_error;
3607:
3608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data);

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

3604: END IF;
3605: WHEN fnd_api.g_exc_unexpected_error THEN
3606: x_return_status := fnd_api.g_ret_sts_unexp_error;
3607:
3608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data);
3611:
3612: -- Debug info.

Line 3625: x_return_status := fnd_api.g_ret_sts_unexp_error;

3621: p_prefix=>l_debug_prefix,
3622: p_msg_level=>fnd_log.level_procedure);
3623: END IF;
3624: WHEN OTHERS THEN
3625: x_return_status := fnd_api.g_ret_sts_unexp_error;
3626:
3627: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3628: fnd_message.set_token('ERROR' ,SQLERRM);
3629: fnd_msg_pub.add;

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

3627: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3628: fnd_message.set_token('ERROR' ,SQLERRM);
3629: fnd_msg_pub.add;
3630:
3631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3632: p_count => x_msg_count,
3633: p_data => x_msg_data);
3634:
3635: -- Debug info.

Line 3662: p_init_msg_list => FND_API.G_TRUE,

3658: l_msg_count NUMBER;
3659: l_msg_data VARCHAR2(2000);
3660: BEGIN
3661: get_person_bo(
3662: p_init_msg_list => FND_API.G_TRUE,
3663: p_person_id => p_person_id,
3664: p_person_os => p_person_os,
3665: p_person_osr => p_person_osr,
3666: x_person_obj => x_person_obj,

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

3689: -- ARGUMENTS
3690: -- IN:
3691: -- p_init_msg_list Initialize message stack if it is set to
3692: -- p_event_id BES Event identifier.
3693: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3694: -- OUT:
3695: -- x_person_obj One or more created logical person.
3696: -- x_return_status Return status after the call. The status can
3697: -- be fnd_api.g_ret_sts_success (success),

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

3693: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3694: -- OUT:
3695: -- x_person_obj One or more created logical person.
3696: -- x_return_status Return status after the call. The status can
3697: -- be fnd_api.g_ret_sts_success (success),
3698: -- fnd_api.g_ret_sts_error (error),
3699: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3700: -- x_msg_count Number of messages in message stack.
3701: -- x_msg_data Message text if x_msg_count is 1.

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

3694: -- OUT:
3695: -- x_person_obj One or more created logical person.
3696: -- x_return_status Return status after the call. The status can
3697: -- be fnd_api.g_ret_sts_success (success),
3698: -- fnd_api.g_ret_sts_error (error),
3699: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3700: -- x_msg_count Number of messages in message stack.
3701: -- x_msg_data Message text if x_msg_count is 1.
3702: --

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

3695: -- x_person_obj One or more created logical person.
3696: -- x_return_status Return status after the call. The status can
3697: -- be fnd_api.g_ret_sts_success (success),
3698: -- fnd_api.g_ret_sts_error (error),
3699: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3700: -- x_msg_count Number of messages in message stack.
3701: -- x_msg_data Message text if x_msg_count is 1.
3702: --
3703: -- NOTES

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

3723: */
3724:
3725:
3726: PROCEDURE get_persons_created(
3727: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3728: p_event_id IN NUMBER,
3729: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3730: x_return_status OUT NOCOPY VARCHAR2,
3731: x_msg_count OUT NOCOPY NUMBER,

Line 3738: x_return_status := FND_API.G_RET_STS_SUCCESS;

3734: l_debug_prefix VARCHAR2(30) := '';
3735: begin
3736:
3737: -- initialize API return status to success.
3738: x_return_status := FND_API.G_RET_STS_SUCCESS;
3739:
3740: -- Initialize message list if p_init_msg_list is set to TRUE
3741: IF FND_API.to_Boolean(p_init_msg_list) THEN
3742: FND_MSG_PUB.initialize;

Line 3741: IF FND_API.to_Boolean(p_init_msg_list) THEN

3737: -- initialize API return status to success.
3738: x_return_status := FND_API.G_RET_STS_SUCCESS;
3739:
3740: -- Initialize message list if p_init_msg_list is set to TRUE
3741: IF FND_API.to_Boolean(p_init_msg_list) THEN
3742: FND_MSG_PUB.initialize;
3743: END IF;
3744:
3745:

Line 3760: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3756: p_event_type => 'C',
3757: p_bo_code => 'PERSON',
3758: x_return_status => x_return_status);
3759:
3760: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3761: RAISE FND_API.G_EXC_ERROR;
3762: END IF;
3763:
3764: HZ_EXTRACT_PERSON_BO_PVT.get_persons_created(

Line 3761: RAISE FND_API.G_EXC_ERROR;

3757: p_bo_code => 'PERSON',
3758: x_return_status => x_return_status);
3759:
3760: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3761: RAISE FND_API.G_EXC_ERROR;
3762: END IF;
3763:
3764: HZ_EXTRACT_PERSON_BO_PVT.get_persons_created(
3765: p_init_msg_list => fnd_api.g_false,

Line 3765: p_init_msg_list => fnd_api.g_false,

3761: RAISE FND_API.G_EXC_ERROR;
3762: END IF;
3763:
3764: HZ_EXTRACT_PERSON_BO_PVT.get_persons_created(
3765: p_init_msg_list => fnd_api.g_false,
3766: p_event_id => p_event_id,
3767: x_person_objs => x_person_objs,
3768: x_return_status => x_return_status,
3769: x_msg_count => x_msg_count,

Line 3772: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3768: x_return_status => x_return_status,
3769: x_msg_count => x_msg_count,
3770: x_msg_data => x_msg_data);
3771:
3772: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3773: RAISE FND_API.G_EXC_ERROR;
3774: END IF;
3775:
3776:

Line 3773: RAISE FND_API.G_EXC_ERROR;

3769: x_msg_count => x_msg_count,
3770: x_msg_data => x_msg_data);
3771:
3772: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3773: RAISE FND_API.G_EXC_ERROR;
3774: END IF;
3775:
3776:
3777:

Line 3796: WHEN fnd_api.g_exc_error THEN

3792:
3793:
3794: EXCEPTION
3795:
3796: WHEN fnd_api.g_exc_error THEN
3797: x_return_status := fnd_api.g_ret_sts_error;
3798:
3799: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3800: p_count => x_msg_count,

Line 3797: x_return_status := fnd_api.g_ret_sts_error;

3793:
3794: EXCEPTION
3795:
3796: WHEN fnd_api.g_exc_error THEN
3797: x_return_status := fnd_api.g_ret_sts_error;
3798:
3799: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3800: p_count => x_msg_count,
3801: p_data => x_msg_data);

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

3795:
3796: WHEN fnd_api.g_exc_error THEN
3797: x_return_status := fnd_api.g_ret_sts_error;
3798:
3799: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3800: p_count => x_msg_count,
3801: p_data => x_msg_data);
3802:
3803: -- Debug info.

Line 3815: WHEN fnd_api.g_exc_unexpected_error THEN

3811: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3812: p_prefix=>l_debug_prefix,
3813: p_msg_level=>fnd_log.level_procedure);
3814: END IF;
3815: WHEN fnd_api.g_exc_unexpected_error THEN
3816: x_return_status := fnd_api.g_ret_sts_unexp_error;
3817:
3818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3819: p_count => x_msg_count,

Line 3816: x_return_status := fnd_api.g_ret_sts_unexp_error;

3812: p_prefix=>l_debug_prefix,
3813: p_msg_level=>fnd_log.level_procedure);
3814: END IF;
3815: WHEN fnd_api.g_exc_unexpected_error THEN
3816: x_return_status := fnd_api.g_ret_sts_unexp_error;
3817:
3818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3819: p_count => x_msg_count,
3820: p_data => x_msg_data);

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

3814: END IF;
3815: WHEN fnd_api.g_exc_unexpected_error THEN
3816: x_return_status := fnd_api.g_ret_sts_unexp_error;
3817:
3818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3819: p_count => x_msg_count,
3820: p_data => x_msg_data);
3821:
3822: -- Debug info.

Line 3835: x_return_status := fnd_api.g_ret_sts_unexp_error;

3831: p_prefix=>l_debug_prefix,
3832: p_msg_level=>fnd_log.level_procedure);
3833: END IF;
3834: WHEN OTHERS THEN
3835: x_return_status := fnd_api.g_ret_sts_unexp_error;
3836:
3837: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3838: fnd_message.set_token('ERROR' ,SQLERRM);
3839: fnd_msg_pub.add;

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

3837: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3838: fnd_message.set_token('ERROR' ,SQLERRM);
3839: fnd_msg_pub.add;
3840:
3841: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3842: p_count => x_msg_count,
3843: p_data => x_msg_data);
3844:
3845: -- Debug info.

Line 3870: p_init_msg_list => FND_API.G_TRUE,

3866: l_msg_count NUMBER;
3867: l_msg_data VARCHAR2(2000);
3868: BEGIN
3869: get_persons_created(
3870: p_init_msg_list => FND_API.G_TRUE,
3871: p_event_id => p_event_id,
3872: x_person_objs => x_person_objs,
3873: x_return_status => x_return_status,
3874: x_msg_count => l_msg_count,

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

3895: -- ARGUMENTS
3896: -- IN:
3897: -- p_init_msg_list Initialize message stack if it is set to
3898: -- p_event_id BES Event identifier.
3899: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3900: -- OUT:
3901: -- x_person_objs One or more created logical person.
3902: -- x_return_status Return status after the call. The status can
3903: -- be fnd_api.g_ret_sts_success (success),

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

3899: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3900: -- OUT:
3901: -- x_person_objs One or more created logical person.
3902: -- x_return_status Return status after the call. The status can
3903: -- be fnd_api.g_ret_sts_success (success),
3904: -- fnd_api.g_ret_sts_error (error),
3905: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3906: -- x_msg_count Number of messages in message stack.
3907: -- x_msg_data Message text if x_msg_count is 1.

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

3900: -- OUT:
3901: -- x_person_objs One or more created logical person.
3902: -- x_return_status Return status after the call. The status can
3903: -- be fnd_api.g_ret_sts_success (success),
3904: -- fnd_api.g_ret_sts_error (error),
3905: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3906: -- x_msg_count Number of messages in message stack.
3907: -- x_msg_data Message text if x_msg_count is 1.
3908: --

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

3901: -- x_person_objs One or more created logical person.
3902: -- x_return_status Return status after the call. The status can
3903: -- be fnd_api.g_ret_sts_success (success),
3904: -- fnd_api.g_ret_sts_error (error),
3905: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3906: -- x_msg_count Number of messages in message stack.
3907: -- x_msg_data Message text if x_msg_count is 1.
3908: --
3909: -- NOTES

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

3925: returns them to the caller.
3926: */
3927:
3928: PROCEDURE get_persons_updated(
3929: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3930: p_event_id IN NUMBER,
3931: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3932: x_return_status OUT NOCOPY VARCHAR2,
3933: x_msg_count OUT NOCOPY NUMBER,

Line 3941: x_return_status := FND_API.G_RET_STS_SUCCESS;

3937: l_debug_prefix VARCHAR2(30) := '';
3938: begin
3939:
3940: -- initialize API return status to success.
3941: x_return_status := FND_API.G_RET_STS_SUCCESS;
3942:
3943: -- Initialize message list if p_init_msg_list is set to TRUE
3944: IF FND_API.to_Boolean(p_init_msg_list) THEN
3945: FND_MSG_PUB.initialize;

Line 3944: IF FND_API.to_Boolean(p_init_msg_list) THEN

3940: -- initialize API return status to success.
3941: x_return_status := FND_API.G_RET_STS_SUCCESS;
3942:
3943: -- Initialize message list if p_init_msg_list is set to TRUE
3944: IF FND_API.to_Boolean(p_init_msg_list) THEN
3945: FND_MSG_PUB.initialize;
3946: END IF;
3947:
3948:

Line 3962: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3958: p_event_type => 'U',
3959: p_bo_code => 'PERSON',
3960: x_return_status => x_return_status);
3961:
3962: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;
3965:
3966: HZ_EXTRACT_PERSON_BO_PVT.get_persons_updated(

Line 3963: RAISE FND_API.G_EXC_ERROR;

3959: p_bo_code => 'PERSON',
3960: x_return_status => x_return_status);
3961:
3962: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;
3965:
3966: HZ_EXTRACT_PERSON_BO_PVT.get_persons_updated(
3967: p_init_msg_list => fnd_api.g_false,

Line 3967: p_init_msg_list => fnd_api.g_false,

3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;
3965:
3966: HZ_EXTRACT_PERSON_BO_PVT.get_persons_updated(
3967: p_init_msg_list => fnd_api.g_false,
3968: p_event_id => p_event_id,
3969: x_person_objs => x_person_objs,
3970: x_return_status => x_return_status,
3971: x_msg_count => x_msg_count,

Line 3974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3970: x_return_status => x_return_status,
3971: x_msg_count => x_msg_count,
3972: x_msg_data => x_msg_data);
3973:
3974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3975: RAISE FND_API.G_EXC_ERROR;
3976: END IF;
3977:
3978:

Line 3975: RAISE FND_API.G_EXC_ERROR;

3971: x_msg_count => x_msg_count,
3972: x_msg_data => x_msg_data);
3973:
3974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3975: RAISE FND_API.G_EXC_ERROR;
3976: END IF;
3977:
3978:
3979:

Line 3998: WHEN fnd_api.g_exc_error THEN

3994:
3995:
3996: EXCEPTION
3997:
3998: WHEN fnd_api.g_exc_error THEN
3999: x_return_status := fnd_api.g_ret_sts_error;
4000:
4001: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4002: p_count => x_msg_count,

Line 3999: x_return_status := fnd_api.g_ret_sts_error;

3995:
3996: EXCEPTION
3997:
3998: WHEN fnd_api.g_exc_error THEN
3999: x_return_status := fnd_api.g_ret_sts_error;
4000:
4001: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4002: p_count => x_msg_count,
4003: p_data => x_msg_data);

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

3997:
3998: WHEN fnd_api.g_exc_error THEN
3999: x_return_status := fnd_api.g_ret_sts_error;
4000:
4001: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4002: p_count => x_msg_count,
4003: p_data => x_msg_data);
4004:
4005: -- Debug info.

Line 4017: WHEN fnd_api.g_exc_unexpected_error THEN

4013: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
4014: p_prefix=>l_debug_prefix,
4015: p_msg_level=>fnd_log.level_procedure);
4016: END IF;
4017: WHEN fnd_api.g_exc_unexpected_error THEN
4018: x_return_status := fnd_api.g_ret_sts_unexp_error;
4019:
4020: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4021: p_count => x_msg_count,

Line 4018: x_return_status := fnd_api.g_ret_sts_unexp_error;

4014: p_prefix=>l_debug_prefix,
4015: p_msg_level=>fnd_log.level_procedure);
4016: END IF;
4017: WHEN fnd_api.g_exc_unexpected_error THEN
4018: x_return_status := fnd_api.g_ret_sts_unexp_error;
4019:
4020: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4021: p_count => x_msg_count,
4022: p_data => x_msg_data);

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

4016: END IF;
4017: WHEN fnd_api.g_exc_unexpected_error THEN
4018: x_return_status := fnd_api.g_ret_sts_unexp_error;
4019:
4020: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4021: p_count => x_msg_count,
4022: p_data => x_msg_data);
4023:
4024: -- Debug info.

Line 4037: x_return_status := fnd_api.g_ret_sts_unexp_error;

4033: p_prefix=>l_debug_prefix,
4034: p_msg_level=>fnd_log.level_procedure);
4035: END IF;
4036: WHEN OTHERS THEN
4037: x_return_status := fnd_api.g_ret_sts_unexp_error;
4038:
4039: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4040: fnd_message.set_token('ERROR' ,SQLERRM);
4041: fnd_msg_pub.add;

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

4039: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4040: fnd_message.set_token('ERROR' ,SQLERRM);
4041: fnd_msg_pub.add;
4042:
4043: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4044: p_count => x_msg_count,
4045: p_data => x_msg_data);
4046:
4047: -- Debug info.

Line 4072: p_init_msg_list => FND_API.G_TRUE,

4068: l_msg_count NUMBER;
4069: l_msg_data VARCHAR2(2000);
4070: BEGIN
4071: get_persons_updated(
4072: p_init_msg_list => FND_API.G_TRUE,
4073: p_event_id => p_event_id,
4074: x_person_objs => x_person_objs,
4075: x_return_status => x_return_status,
4076: x_msg_count => l_msg_count,

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

4097: -- IN:
4098: -- p_init_msg_list Initialize message stack if it is set to
4099: -- p_event_id BES Event identifier.
4100: -- p_person_id Person identifier.
4101: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
4102: -- OUT:
4103: -- x_person_objs One or more created logical person.
4104: -- x_return_status Return status after the call. The status can
4105: -- be fnd_api.g_ret_sts_success (success),

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

4101: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
4102: -- OUT:
4103: -- x_person_objs One or more created logical person.
4104: -- x_return_status Return status after the call. The status can
4105: -- be fnd_api.g_ret_sts_success (success),
4106: -- fnd_api.g_ret_sts_error (error),
4107: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
4108: -- x_msg_count Number of messages in message stack.
4109: -- x_msg_data Message text if x_msg_count is 1.

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

4102: -- OUT:
4103: -- x_person_objs One or more created logical person.
4104: -- x_return_status Return status after the call. The status can
4105: -- be fnd_api.g_ret_sts_success (success),
4106: -- fnd_api.g_ret_sts_error (error),
4107: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
4108: -- x_msg_count Number of messages in message stack.
4109: -- x_msg_data Message text if x_msg_count is 1.
4110: --

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

4103: -- x_person_objs One or more created logical person.
4104: -- x_return_status Return status after the call. The status can
4105: -- be fnd_api.g_ret_sts_success (success),
4106: -- fnd_api.g_ret_sts_error (error),
4107: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
4108: -- x_msg_count Number of messages in message stack.
4109: -- x_msg_data Message text if x_msg_count is 1.
4110: --
4111: -- NOTES

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

4119:
4120: -- Get only one person object based on p_person_id and event_id
4121:
4122: PROCEDURE get_person_updated(
4123: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
4124: p_event_id IN NUMBER,
4125: p_person_id IN NUMBER,
4126: x_person_obj OUT NOCOPY HZ_PERSON_BO,
4127: x_return_status OUT NOCOPY VARCHAR2,

Line 4135: x_return_status := FND_API.G_RET_STS_SUCCESS;

4131: l_debug_prefix VARCHAR2(30) := '';
4132: begin
4133:
4134: -- initialize API return status to success.
4135: x_return_status := FND_API.G_RET_STS_SUCCESS;
4136:
4137: -- Initialize message list if p_init_msg_list is set to TRUE
4138: IF FND_API.to_Boolean(p_init_msg_list) THEN
4139: FND_MSG_PUB.initialize;

Line 4138: IF FND_API.to_Boolean(p_init_msg_list) THEN

4134: -- initialize API return status to success.
4135: x_return_status := FND_API.G_RET_STS_SUCCESS;
4136:
4137: -- Initialize message list if p_init_msg_list is set to TRUE
4138: IF FND_API.to_Boolean(p_init_msg_list) THEN
4139: FND_MSG_PUB.initialize;
4140: END IF;
4141:
4142:

Line 4156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4152: p_event_type => 'U',
4153: p_bo_code => 'PERSON',
4154: x_return_status => x_return_status);
4155:
4156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4157: RAISE FND_API.G_EXC_ERROR;
4158: END IF;
4159:
4160:

Line 4157: RAISE FND_API.G_EXC_ERROR;

4153: p_bo_code => 'PERSON',
4154: x_return_status => x_return_status);
4155:
4156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4157: RAISE FND_API.G_EXC_ERROR;
4158: END IF;
4159:
4160:
4161: HZ_EXTRACT_PERSON_BO_PVT.get_person_updated(

Line 4162: p_init_msg_list => fnd_api.g_false,

4158: END IF;
4159:
4160:
4161: HZ_EXTRACT_PERSON_BO_PVT.get_person_updated(
4162: p_init_msg_list => fnd_api.g_false,
4163: p_event_id => p_event_id,
4164: p_person_id => p_person_id,
4165: x_person_obj => x_person_obj,
4166: x_return_status => x_return_status,

Line 4170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4166: x_return_status => x_return_status,
4167: x_msg_count => x_msg_count,
4168: x_msg_data => x_msg_data);
4169:
4170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4171: RAISE FND_API.G_EXC_ERROR;
4172: END IF;
4173:
4174:

Line 4171: RAISE FND_API.G_EXC_ERROR;

4167: x_msg_count => x_msg_count,
4168: x_msg_data => x_msg_data);
4169:
4170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4171: RAISE FND_API.G_EXC_ERROR;
4172: END IF;
4173:
4174:
4175:

Line 4194: WHEN fnd_api.g_exc_error THEN

4190:
4191:
4192: EXCEPTION
4193:
4194: WHEN fnd_api.g_exc_error THEN
4195: x_return_status := fnd_api.g_ret_sts_error;
4196:
4197: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4198: p_count => x_msg_count,

Line 4195: x_return_status := fnd_api.g_ret_sts_error;

4191:
4192: EXCEPTION
4193:
4194: WHEN fnd_api.g_exc_error THEN
4195: x_return_status := fnd_api.g_ret_sts_error;
4196:
4197: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4198: p_count => x_msg_count,
4199: p_data => x_msg_data);

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

4193:
4194: WHEN fnd_api.g_exc_error THEN
4195: x_return_status := fnd_api.g_ret_sts_error;
4196:
4197: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4198: p_count => x_msg_count,
4199: p_data => x_msg_data);
4200:
4201: -- Debug info.

Line 4213: WHEN fnd_api.g_exc_unexpected_error THEN

4209: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
4210: p_prefix=>l_debug_prefix,
4211: p_msg_level=>fnd_log.level_procedure);
4212: END IF;
4213: WHEN fnd_api.g_exc_unexpected_error THEN
4214: x_return_status := fnd_api.g_ret_sts_unexp_error;
4215:
4216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4217: p_count => x_msg_count,

Line 4214: x_return_status := fnd_api.g_ret_sts_unexp_error;

4210: p_prefix=>l_debug_prefix,
4211: p_msg_level=>fnd_log.level_procedure);
4212: END IF;
4213: WHEN fnd_api.g_exc_unexpected_error THEN
4214: x_return_status := fnd_api.g_ret_sts_unexp_error;
4215:
4216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4217: p_count => x_msg_count,
4218: p_data => x_msg_data);

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

4212: END IF;
4213: WHEN fnd_api.g_exc_unexpected_error THEN
4214: x_return_status := fnd_api.g_ret_sts_unexp_error;
4215:
4216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4217: p_count => x_msg_count,
4218: p_data => x_msg_data);
4219:
4220: -- Debug info.

Line 4233: x_return_status := fnd_api.g_ret_sts_unexp_error;

4229: p_prefix=>l_debug_prefix,
4230: p_msg_level=>fnd_log.level_procedure);
4231: END IF;
4232: WHEN OTHERS THEN
4233: x_return_status := fnd_api.g_ret_sts_unexp_error;
4234:
4235: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4236: fnd_message.set_token('ERROR' ,SQLERRM);
4237: fnd_msg_pub.add;

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

4235: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4236: fnd_message.set_token('ERROR' ,SQLERRM);
4237: fnd_msg_pub.add;
4238:
4239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4240: p_count => x_msg_count,
4241: p_data => x_msg_data);
4242:
4243: -- Debug info.

Line 4269: p_init_msg_list => FND_API.G_TRUE,

4265: l_msg_count NUMBER;
4266: l_msg_data VARCHAR2(2000);
4267: BEGIN
4268: get_person_updated(
4269: p_init_msg_list => FND_API.G_TRUE,
4270: p_event_id => p_event_id,
4271: p_person_id => p_person_id,
4272: x_person_obj => x_person_obj,
4273: x_return_status => x_return_status,

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

4281: END get_person_updated;
4282:
4283: -- get TCA identifiers for create event
4284: PROCEDURE get_ids_persons_created (
4285: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
4286: p_event_id IN NUMBER,
4287: x_person_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
4288: x_return_status OUT NOCOPY VARCHAR2,
4289: x_msg_count OUT NOCOPY NUMBER,

Line 4297: x_return_status := FND_API.G_RET_STS_SUCCESS;

4293: l_debug_prefix VARCHAR2(30) := '';
4294:
4295: begin
4296: -- initialize API return status to success.
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298:
4299: -- Initialize message list if p_init_msg_list is set to TRUE
4300: IF FND_API.to_Boolean(p_init_msg_list) THEN
4301: FND_MSG_PUB.initialize;

Line 4300: IF FND_API.to_Boolean(p_init_msg_list) THEN

4296: -- initialize API return status to success.
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298:
4299: -- Initialize message list if p_init_msg_list is set to TRUE
4300: IF FND_API.to_Boolean(p_init_msg_list) THEN
4301: FND_MSG_PUB.initialize;
4302: END IF;
4303:
4304:

Line 4319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4315: p_event_type => 'C',
4316: p_bo_code => 'PERSON',
4317: x_return_status => x_return_status);
4318:
4319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4320: RAISE FND_API.G_EXC_ERROR;
4321: END IF;
4322:
4323: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 4320: RAISE FND_API.G_EXC_ERROR;

4316: p_bo_code => 'PERSON',
4317: x_return_status => x_return_status);
4318:
4319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4320: RAISE FND_API.G_EXC_ERROR;
4321: END IF;
4322:
4323: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
4324: p_init_msg_list => fnd_api.g_false,

Line 4324: p_init_msg_list => fnd_api.g_false,

4320: RAISE FND_API.G_EXC_ERROR;
4321: END IF;
4322:
4323: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
4324: p_init_msg_list => fnd_api.g_false,
4325: p_event_id => p_event_id,
4326: x_obj_root_ids => x_person_ids,
4327: x_return_status => x_return_status,
4328: x_msg_count => x_msg_count,

Line 4331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4327: x_return_status => x_return_status,
4328: x_msg_count => x_msg_count,
4329: x_msg_data => x_msg_data);
4330:
4331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4332: RAISE FND_API.G_EXC_ERROR;
4333: END IF;
4334:
4335:

Line 4332: RAISE FND_API.G_EXC_ERROR;

4328: x_msg_count => x_msg_count,
4329: x_msg_data => x_msg_data);
4330:
4331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4332: RAISE FND_API.G_EXC_ERROR;
4333: END IF;
4334:
4335:
4336: -- Debug info.

Line 4354: WHEN fnd_api.g_exc_error THEN

4350:
4351:
4352: EXCEPTION
4353:
4354: WHEN fnd_api.g_exc_error THEN
4355: x_return_status := fnd_api.g_ret_sts_error;
4356:
4357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4358: p_count => x_msg_count,

Line 4355: x_return_status := fnd_api.g_ret_sts_error;

4351:
4352: EXCEPTION
4353:
4354: WHEN fnd_api.g_exc_error THEN
4355: x_return_status := fnd_api.g_ret_sts_error;
4356:
4357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4358: p_count => x_msg_count,
4359: p_data => x_msg_data);

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

4353:
4354: WHEN fnd_api.g_exc_error THEN
4355: x_return_status := fnd_api.g_ret_sts_error;
4356:
4357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4358: p_count => x_msg_count,
4359: p_data => x_msg_data);
4360:
4361: -- Debug info.

Line 4373: WHEN fnd_api.g_exc_unexpected_error THEN

4369: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
4370: p_prefix=>l_debug_prefix,
4371: p_msg_level=>fnd_log.level_procedure);
4372: END IF;
4373: WHEN fnd_api.g_exc_unexpected_error THEN
4374: x_return_status := fnd_api.g_ret_sts_unexp_error;
4375:
4376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4377: p_count => x_msg_count,

Line 4374: x_return_status := fnd_api.g_ret_sts_unexp_error;

4370: p_prefix=>l_debug_prefix,
4371: p_msg_level=>fnd_log.level_procedure);
4372: END IF;
4373: WHEN fnd_api.g_exc_unexpected_error THEN
4374: x_return_status := fnd_api.g_ret_sts_unexp_error;
4375:
4376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4377: p_count => x_msg_count,
4378: p_data => x_msg_data);

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

4372: END IF;
4373: WHEN fnd_api.g_exc_unexpected_error THEN
4374: x_return_status := fnd_api.g_ret_sts_unexp_error;
4375:
4376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4377: p_count => x_msg_count,
4378: p_data => x_msg_data);
4379:
4380: -- Debug info.

Line 4393: x_return_status := fnd_api.g_ret_sts_unexp_error;

4389: p_prefix=>l_debug_prefix,
4390: p_msg_level=>fnd_log.level_procedure);
4391: END IF;
4392: WHEN OTHERS THEN
4393: x_return_status := fnd_api.g_ret_sts_unexp_error;
4394:
4395: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4396: fnd_message.set_token('ERROR' ,SQLERRM);
4397: fnd_msg_pub.add;

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

4395: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4396: fnd_message.set_token('ERROR' ,SQLERRM);
4397: fnd_msg_pub.add;
4398:
4399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4400: p_count => x_msg_count,
4401: p_data => x_msg_data);
4402:
4403: -- Debug info.

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

4417:
4418:
4419: -- get TCA identifiers for update event
4420: PROCEDURE get_ids_persons_updated (
4421: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
4422: p_event_id IN NUMBER,
4423: x_person_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
4424: x_return_status OUT NOCOPY VARCHAR2,
4425: x_msg_count OUT NOCOPY NUMBER,

Line 4432: x_return_status := FND_API.G_RET_STS_SUCCESS;

4428: l_debug_prefix VARCHAR2(30) := '';
4429:
4430: begin
4431: -- initialize API return status to success.
4432: x_return_status := FND_API.G_RET_STS_SUCCESS;
4433:
4434: -- Initialize message list if p_init_msg_list is set to TRUE
4435: IF FND_API.to_Boolean(p_init_msg_list) THEN
4436: FND_MSG_PUB.initialize;

Line 4435: IF FND_API.to_Boolean(p_init_msg_list) THEN

4431: -- initialize API return status to success.
4432: x_return_status := FND_API.G_RET_STS_SUCCESS;
4433:
4434: -- Initialize message list if p_init_msg_list is set to TRUE
4435: IF FND_API.to_Boolean(p_init_msg_list) THEN
4436: FND_MSG_PUB.initialize;
4437: END IF;
4438:
4439:

Line 4453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4449: p_event_type => 'U',
4450: p_bo_code => 'PERSON',
4451: x_return_status => x_return_status);
4452:
4453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4454: RAISE FND_API.G_EXC_ERROR;
4455: END IF;
4456:
4457: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 4454: RAISE FND_API.G_EXC_ERROR;

4450: p_bo_code => 'PERSON',
4451: x_return_status => x_return_status);
4452:
4453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4454: RAISE FND_API.G_EXC_ERROR;
4455: END IF;
4456:
4457: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
4458: p_init_msg_list => fnd_api.g_false,

Line 4458: p_init_msg_list => fnd_api.g_false,

4454: RAISE FND_API.G_EXC_ERROR;
4455: END IF;
4456:
4457: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
4458: p_init_msg_list => fnd_api.g_false,
4459: p_event_id => p_event_id,
4460: x_obj_root_ids => x_person_ids,
4461: x_return_status => x_return_status,
4462: x_msg_count => x_msg_count,

Line 4465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4461: x_return_status => x_return_status,
4462: x_msg_count => x_msg_count,
4463: x_msg_data => x_msg_data);
4464:
4465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4466: RAISE FND_API.G_EXC_ERROR;
4467: END IF;
4468:
4469:

Line 4466: RAISE FND_API.G_EXC_ERROR;

4462: x_msg_count => x_msg_count,
4463: x_msg_data => x_msg_data);
4464:
4465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4466: RAISE FND_API.G_EXC_ERROR;
4467: END IF;
4468:
4469:
4470: -- Debug info.

Line 4488: WHEN fnd_api.g_exc_error THEN

4484:
4485:
4486: EXCEPTION
4487:
4488: WHEN fnd_api.g_exc_error THEN
4489: x_return_status := fnd_api.g_ret_sts_error;
4490:
4491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4492: p_count => x_msg_count,

Line 4489: x_return_status := fnd_api.g_ret_sts_error;

4485:
4486: EXCEPTION
4487:
4488: WHEN fnd_api.g_exc_error THEN
4489: x_return_status := fnd_api.g_ret_sts_error;
4490:
4491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4492: p_count => x_msg_count,
4493: p_data => x_msg_data);

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

4487:
4488: WHEN fnd_api.g_exc_error THEN
4489: x_return_status := fnd_api.g_ret_sts_error;
4490:
4491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4492: p_count => x_msg_count,
4493: p_data => x_msg_data);
4494:
4495: -- Debug info.

Line 4507: WHEN fnd_api.g_exc_unexpected_error THEN

4503: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4504: p_prefix=>l_debug_prefix,
4505: p_msg_level=>fnd_log.level_procedure);
4506: END IF;
4507: WHEN fnd_api.g_exc_unexpected_error THEN
4508: x_return_status := fnd_api.g_ret_sts_unexp_error;
4509:
4510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4511: p_count => x_msg_count,

Line 4508: x_return_status := fnd_api.g_ret_sts_unexp_error;

4504: p_prefix=>l_debug_prefix,
4505: p_msg_level=>fnd_log.level_procedure);
4506: END IF;
4507: WHEN fnd_api.g_exc_unexpected_error THEN
4508: x_return_status := fnd_api.g_ret_sts_unexp_error;
4509:
4510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4511: p_count => x_msg_count,
4512: p_data => x_msg_data);

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

4506: END IF;
4507: WHEN fnd_api.g_exc_unexpected_error THEN
4508: x_return_status := fnd_api.g_ret_sts_unexp_error;
4509:
4510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4511: p_count => x_msg_count,
4512: p_data => x_msg_data);
4513:
4514: -- Debug info.

Line 4527: x_return_status := fnd_api.g_ret_sts_unexp_error;

4523: p_prefix=>l_debug_prefix,
4524: p_msg_level=>fnd_log.level_procedure);
4525: END IF;
4526: WHEN OTHERS THEN
4527: x_return_status := fnd_api.g_ret_sts_unexp_error;
4528:
4529: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4530: fnd_message.set_token('ERROR' ,SQLERRM);
4531: fnd_msg_pub.add;

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

4529: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4530: fnd_message.set_token('ERROR' ,SQLERRM);
4531: fnd_msg_pub.add;
4532:
4533: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4534: p_count => x_msg_count,
4535: p_data => x_msg_data);
4536:
4537: -- Debug info.