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 703: x_return_status := FND_API.G_RET_STS_SUCCESS;

699: -- Standard start of API savepoint
700: SAVEPOINT do_create_person_bo_pub;
701:
702: -- initialize API return status to success.
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704:
705: -- Initialize message list if p_init_msg_list is set to TRUE.
706: IF FND_API.to_Boolean(p_init_msg_list) THEN
707: FND_MSG_PUB.initialize;

Line 706: IF FND_API.to_Boolean(p_init_msg_list) THEN

702: -- initialize API return status to success.
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704:
705: -- Initialize message list if p_init_msg_list is set to TRUE.
706: IF FND_API.to_Boolean(p_init_msg_list) THEN
707: FND_MSG_PUB.initialize;
708: END IF;
709:
710: -- initialize Global variable

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

722: p_msg_level=>fnd_log.level_procedure);
723: END IF;
724:
725: -- Base on p_validate_bo_flag, check the completeness of business objects
726: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
727: HZ_REGISTRY_VALIDATE_BO_PVT.get_bus_obj_struct(
728: p_bus_object_code => 'PERSON',
729: x_bus_object => l_bus_object
730: );

Line 737: RAISE fnd_api.g_exc_error;

733: p_person_obj => p_person_obj,
734: p_bus_object => l_bus_object
735: );
736: IF NOT(l_valid_obj) THEN
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: -- find out if raise event at the end
741: l_raise_event := HZ_PARTY_BO_PVT.is_raising_create_event(

Line 770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

766: x_return_status => x_return_status,
767: x_msg_count => x_msg_count,
768: x_msg_data => x_msg_data);
769:
770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
771: RAISE FND_API.G_EXC_ERROR;
772: END IF;
773:
774: ---------------------------------

Line 771: RAISE FND_API.G_EXC_ERROR;

767: x_msg_count => x_msg_count,
768: x_msg_data => x_msg_data);
769:
770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
771: RAISE FND_API.G_EXC_ERROR;
772: END IF;
773:
774: ---------------------------------
775: -- Assign person and party record

Line 795: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

791: x_msg_count => x_msg_count,
792: x_msg_data => x_msg_data
793: );
794:
795: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
796: RAISE FND_API.G_EXC_ERROR;
797: END IF;
798:
799: -- assign person party_id

Line 796: RAISE FND_API.G_EXC_ERROR;

792: x_msg_data => x_msg_data
793: );
794:
795: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
796: RAISE FND_API.G_EXC_ERROR;
797: END IF;
798:
799: -- assign person party_id
800: p_person_obj.person_id := x_person_id;

Line 818: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 819: RAISE FND_API.G_EXC_ERROR;

815: x_msg_data => x_msg_data
816: );
817:
818: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821: END IF;
822:
823: ----------------------------

Line 843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 844: RAISE FND_API.G_EXC_ERROR;

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

Line 861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

857: x_msg_count => x_msg_count,
858: x_msg_data => x_msg_data
859: );
860:
861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864: END IF;
865:

Line 862: RAISE FND_API.G_EXC_ERROR;

858: x_msg_data => x_msg_data
859: );
860:
861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864: END IF;
865:
866: ----------------------------

Line 880: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

876: x_msg_count => x_msg_count,
877: x_msg_data => x_msg_data
878: );
879:
880: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
881: RAISE FND_API.G_EXC_ERROR;
882: END IF;
883: END IF;
884:

Line 881: RAISE FND_API.G_EXC_ERROR;

877: x_msg_data => x_msg_data
878: );
879:
880: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
881: RAISE FND_API.G_EXC_ERROR;
882: END IF;
883: END IF;
884:
885: ----------------------------

Line 899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

895: x_msg_count => x_msg_count,
896: x_msg_data => x_msg_data
897: );
898:
899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: END IF;
903:

Line 900: RAISE FND_API.G_EXC_ERROR;

896: x_msg_data => x_msg_data
897: );
898:
899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: END IF;
903:
904: ----------------------------

Line 918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

914: x_msg_count => x_msg_count,
915: x_msg_data => x_msg_data
916: );
917:
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922:

Line 919: RAISE FND_API.G_EXC_ERROR;

915: x_msg_data => x_msg_data
916: );
917:
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922:
923: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 943: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

939: p_parent_osr => x_person_osr,
940: p_parent_obj_type => 'PERSON'
941: );
942:
943: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946: END IF;
947:

Line 944: RAISE FND_API.G_EXC_ERROR;

940: p_parent_obj_type => 'PERSON'
941: );
942:
943: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946: END IF;
947:
948: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

972: x_msg_count => x_msg_count,
973: x_msg_data => x_msg_data
974: );
975:
976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: END IF;
980:

Line 977: RAISE FND_API.G_EXC_ERROR;

973: x_msg_data => x_msg_data
974: );
975:
976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: END IF;
980:
981: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

992: x_msg_count => x_msg_count,
993: x_msg_data => x_msg_data
994: );
995:
996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
999: END IF;
1000:

Line 997: RAISE FND_API.G_EXC_ERROR;

993: x_msg_data => x_msg_data
994: );
995:
996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
999: END IF;
1000:
1001: ----------------------------

Line 1014: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1010: x_msg_count => x_msg_count,
1011: x_msg_data => x_msg_data
1012: );
1013:
1014: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017: END IF;
1018:

Line 1015: RAISE FND_API.G_EXC_ERROR;

1011: x_msg_data => x_msg_data
1012: );
1013:
1014: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017: END IF;
1018:
1019: ----------------------------------

Line 1031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1027: x_return_status => x_return_status,
1028: x_msg_count => x_msg_count,
1029: x_msg_data => x_msg_data
1030: );
1031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: END IF;
1035:

Line 1032: RAISE FND_API.G_EXC_ERROR;

1028: x_msg_count => x_msg_count,
1029: x_msg_data => x_msg_data
1030: );
1031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: END IF;
1035:
1036:

Line 1066: WHEN fnd_api.g_exc_error THEN

1062: p_msg_level=>fnd_log.level_procedure);
1063: END IF;
1064:
1065: EXCEPTION
1066: WHEN fnd_api.g_exc_error THEN
1067: ROLLBACK TO do_create_person_bo_pub;
1068:
1069: -- reset Global variable
1070: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1077: x_return_status := fnd_api.g_ret_sts_error;

1073: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1074: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1075: FND_MSG_PUB.ADD;
1076:
1077: x_return_status := fnd_api.g_ret_sts_error;
1078:
1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1080: p_count => x_msg_count,
1081: p_data => x_msg_data);

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

1075: FND_MSG_PUB.ADD;
1076:
1077: x_return_status := fnd_api.g_ret_sts_error;
1078:
1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1080: p_count => x_msg_count,
1081: p_data => x_msg_data);
1082:
1083: -- Debug info.

Line 1096: WHEN fnd_api.g_exc_unexpected_error THEN

1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
1094: END IF;
1095:
1096: WHEN fnd_api.g_exc_unexpected_error THEN
1097: ROLLBACK TO do_create_person_bo_pub;
1098:
1099: -- reset Global variable
1100: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1107: x_return_status := fnd_api.g_ret_sts_unexp_error;

1103: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1104: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1105: FND_MSG_PUB.ADD;
1106:
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108:
1109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1110: p_count => x_msg_count,
1111: p_data => x_msg_data);

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

1105: FND_MSG_PUB.ADD;
1106:
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108:
1109: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1110: p_count => x_msg_count,
1111: p_data => x_msg_data);
1112:
1113: -- Debug info.

Line 1137: x_return_status := fnd_api.g_ret_sts_unexp_error;

1133: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1134: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1135: FND_MSG_PUB.ADD;
1136:
1137: x_return_status := fnd_api.g_ret_sts_unexp_error;
1138:
1139: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1140: fnd_message.set_token('ERROR' ,SQLERRM);
1141: fnd_msg_pub.add;

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

1139: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1140: fnd_message.set_token('ERROR' ,SQLERRM);
1141: fnd_msg_pub.add;
1142:
1143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data);
1146:
1147: -- Debug info.

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

1158: END IF;
1159: END do_create_person_bo;
1160:
1161: PROCEDURE create_person_bo(
1162: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1163: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1164: p_person_obj IN HZ_PERSON_BO,
1165: p_created_by_module IN VARCHAR2,
1166: x_return_status OUT NOCOPY VARCHAR2,

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

1159: END do_create_person_bo;
1160:
1161: PROCEDURE create_person_bo(
1162: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1163: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1164: p_person_obj IN HZ_PERSON_BO,
1165: p_created_by_module IN VARCHAR2,
1166: x_return_status OUT NOCOPY VARCHAR2,
1167: x_msg_count OUT NOCOPY NUMBER,

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

1188: );
1189: END create_person_bo;
1190:
1191: PROCEDURE create_person_bo(
1192: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1193: p_person_obj IN HZ_PERSON_BO,
1194: p_created_by_module IN VARCHAR2,
1195: p_obj_source IN VARCHAR2 := NULL,
1196: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

1192: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1193: p_person_obj IN HZ_PERSON_BO,
1194: p_created_by_module IN VARCHAR2,
1195: p_obj_source IN VARCHAR2 := NULL,
1196: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1197: x_return_status OUT NOCOPY VARCHAR2,
1198: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1199: x_return_obj OUT NOCOPY HZ_PERSON_BO,
1200: x_person_id OUT NOCOPY NUMBER,

Line 1210: p_init_msg_list => FND_API.G_TRUE,

1206: l_per_obj HZ_PERSON_BO;
1207: BEGIN
1208: l_per_obj := p_person_obj;
1209: do_create_person_bo(
1210: p_init_msg_list => FND_API.G_TRUE,
1211: p_validate_bo_flag => p_validate_bo_flag,
1212: p_person_obj => l_per_obj,
1213: p_created_by_module => p_created_by_module,
1214: p_obj_source => p_obj_source,

Line 1226: IF FND_API.to_Boolean(p_return_obj_flag) THEN

1222: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1223: x_return_status => x_return_status,
1224: x_msg_count => l_msg_count,
1225: x_msg_data => l_msg_data);
1226: IF FND_API.to_Boolean(p_return_obj_flag) THEN
1227: x_return_obj := l_per_obj;
1228: END IF;
1229: END create_person_bo;
1230:

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

1232: --
1233: -- DESCRIPTION
1234: -- Update a person business object.
1235: PROCEDURE do_update_person_bo(
1236: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1237: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
1238: p_created_by_module IN VARCHAR2,
1239: p_obj_source IN VARCHAR2 := NULL,
1240: x_return_status OUT NOCOPY VARCHAR2,

Line 1276: x_return_status := FND_API.G_RET_STS_SUCCESS;

1272: -- Standard start of API savepoint
1273: SAVEPOINT do_update_person_bo_pub;
1274:
1275: -- initialize API return status to success.
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278: -- Initialize message list if p_init_msg_list is set to TRUE.
1279: IF FND_API.to_Boolean(p_init_msg_list) THEN
1280: FND_MSG_PUB.initialize;

Line 1279: IF FND_API.to_Boolean(p_init_msg_list) THEN

1275: -- initialize API return status to success.
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278: -- Initialize message list if p_init_msg_list is set to TRUE.
1279: IF FND_API.to_Boolean(p_init_msg_list) THEN
1280: FND_MSG_PUB.initialize;
1281: END IF;
1282:
1283: -- initialize Global variable

Line 1313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1309: x_return_status => x_return_status,
1310: x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data);
1312:
1313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:
1317: -- must check after calling validate_ssm_id because

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310: x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data);
1312:
1313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:
1317: -- must check after calling validate_ssm_id because
1318: -- if user pass os+osr and no id, validate_ssm_id will

Line 1379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1375: x_msg_count => x_msg_count,
1376: x_msg_data => x_msg_data
1377: );
1378:
1379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: END IF;
1382:
1383: -- assign person party_id

Line 1380: RAISE FND_API.G_EXC_ERROR;

1376: x_msg_data => x_msg_data
1377: );
1378:
1379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1380: RAISE FND_API.G_EXC_ERROR;
1381: END IF;
1382:
1383: -- assign person party_id
1384: p_person_obj.person_id := x_person_id;

Line 1402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1398: x_msg_count => x_msg_count,
1399: x_msg_data => x_msg_data
1400: );
1401:
1402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405: END IF;
1406:

Line 1403: RAISE FND_API.G_EXC_ERROR;

1399: x_msg_data => x_msg_data
1400: );
1401:
1402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405: END IF;
1406:
1407: ------------------

Line 1427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1423: x_msg_count => x_msg_count,
1424: x_msg_data => x_msg_data
1425: );
1426:
1427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: END IF;
1431:

Line 1428: RAISE FND_API.G_EXC_ERROR;

1424: x_msg_data => x_msg_data
1425: );
1426:
1427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: END IF;
1431:
1432: ----------------------------

Line 1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1441: x_msg_count => x_msg_count,
1442: x_msg_data => x_msg_data
1443: );
1444:
1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: END IF;
1448: END IF;
1449:

Line 1446: RAISE FND_API.G_EXC_ERROR;

1442: x_msg_data => x_msg_data
1443: );
1444:
1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: END IF;
1448: END IF;
1449:
1450: ----------------------------

Line 1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1460: x_msg_count => x_msg_count,
1461: x_msg_data => x_msg_data
1462: );
1463:
1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467: END IF;
1468:

Line 1465: RAISE FND_API.G_EXC_ERROR;

1461: x_msg_data => x_msg_data
1462: );
1463:
1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467: END IF;
1468:
1469: ----------------------------

Line 1483: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1479: x_msg_count => x_msg_count,
1480: x_msg_data => x_msg_data
1481: );
1482:
1483: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;
1486: END IF;
1487:

Line 1484: RAISE FND_API.G_EXC_ERROR;

1480: x_msg_data => x_msg_data
1481: );
1482:
1483: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;
1486: END IF;
1487:
1488: ----------------------------

Line 1502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1498: x_msg_count => x_msg_count,
1499: x_msg_data => x_msg_data
1500: );
1501:
1502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505: END IF;
1506:

Line 1503: RAISE FND_API.G_EXC_ERROR;

1499: x_msg_data => x_msg_data
1500: );
1501:
1502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505: END IF;
1506:
1507: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line 1527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1523: p_parent_osr => x_person_osr,
1524: p_parent_obj_type => 'PERSON'
1525: );
1526:
1527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: END IF;
1531:

Line 1528: RAISE FND_API.G_EXC_ERROR;

1524: p_parent_obj_type => 'PERSON'
1525: );
1526:
1527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: END IF;
1531:
1532: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1560: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1556: x_msg_count => x_msg_count,
1557: x_msg_data => x_msg_data
1558: );
1559:
1560: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: END IF;
1564:

Line 1561: RAISE FND_API.G_EXC_ERROR;

1557: x_msg_data => x_msg_data
1558: );
1559:
1560: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: END IF;
1564:
1565: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

Line 1580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1576: x_msg_count => x_msg_count,
1577: x_msg_data => x_msg_data
1578: );
1579:
1580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583: END IF;
1584:

Line 1581: RAISE FND_API.G_EXC_ERROR;

1577: x_msg_data => x_msg_data
1578: );
1579:
1580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583: END IF;
1584:
1585: ---------------------

Line 1598: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1594: x_msg_count => x_msg_count,
1595: x_msg_data => x_msg_data
1596: );
1597:
1598: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601: END IF;
1602:

Line 1599: RAISE FND_API.G_EXC_ERROR;

1595: x_msg_data => x_msg_data
1596: );
1597:
1598: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601: END IF;
1602:
1603: ----------------------------------

Line 1615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1611: x_return_status => x_return_status,
1612: x_msg_count => x_msg_count,
1613: x_msg_data => x_msg_data
1614: );
1615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618: END IF;
1619:

Line 1616: RAISE FND_API.G_EXC_ERROR;

1612: x_msg_count => x_msg_count,
1613: x_msg_data => x_msg_data
1614: );
1615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618: END IF;
1619:
1620:

Line 1659: WHEN fnd_api.g_exc_error THEN

1655: p_prefix=>l_debug_prefix,
1656: p_msg_level=>fnd_log.level_procedure);
1657: END IF;
1658: EXCEPTION
1659: WHEN fnd_api.g_exc_error THEN
1660: ROLLBACK TO do_update_person_bo_pub;
1661:
1662: -- reset Global variable
1663: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1670: x_return_status := fnd_api.g_ret_sts_error;

1666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1667: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1668: FND_MSG_PUB.ADD;
1669:
1670: x_return_status := fnd_api.g_ret_sts_error;
1671:
1672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1673: p_count => x_msg_count,
1674: p_data => x_msg_data);

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

1668: FND_MSG_PUB.ADD;
1669:
1670: x_return_status := fnd_api.g_ret_sts_error;
1671:
1672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1673: p_count => x_msg_count,
1674: p_data => x_msg_data);
1675:
1676: -- Debug info.

Line 1690: WHEN fnd_api.g_exc_unexpected_error THEN

1686: p_msg_level=>fnd_log.level_procedure);
1687: END IF;
1688:
1689:
1690: WHEN fnd_api.g_exc_unexpected_error THEN
1691: ROLLBACK TO do_update_person_bo_pub;
1692:
1693: -- reset Global variable
1694: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 1701: x_return_status := fnd_api.g_ret_sts_unexp_error;

1697: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1698: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1699: FND_MSG_PUB.ADD;
1700:
1701: x_return_status := fnd_api.g_ret_sts_unexp_error;
1702:
1703: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1704: p_count => x_msg_count,
1705: p_data => x_msg_data);

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

1699: FND_MSG_PUB.ADD;
1700:
1701: x_return_status := fnd_api.g_ret_sts_unexp_error;
1702:
1703: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1704: p_count => x_msg_count,
1705: p_data => x_msg_data);
1706:
1707: -- Debug info.

Line 1730: x_return_status := fnd_api.g_ret_sts_unexp_error;

1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1727: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1728: FND_MSG_PUB.ADD;
1729:
1730: x_return_status := fnd_api.g_ret_sts_unexp_error;
1731:
1732: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1733: fnd_message.set_token('ERROR' ,SQLERRM);
1734: fnd_msg_pub.add;

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

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

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

1751: END IF;
1752: END do_update_person_bo;
1753:
1754: PROCEDURE update_person_bo(
1755: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1756: p_person_obj IN HZ_PERSON_BO,
1757: p_created_by_module IN VARCHAR2,
1758: x_return_status OUT NOCOPY VARCHAR2,
1759: x_msg_count OUT NOCOPY NUMBER,

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

1782: PROCEDURE update_person_bo(
1783: p_person_obj IN HZ_PERSON_BO,
1784: p_created_by_module IN VARCHAR2,
1785: p_obj_source IN VARCHAR2 := null,
1786: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1787: x_return_status OUT NOCOPY VARCHAR2,
1788: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1789: x_return_obj OUT NOCOPY HZ_PERSON_BO,
1790: x_person_id OUT NOCOPY NUMBER,

Line 1800: p_init_msg_list => FND_API.G_TRUE,

1796: l_per_obj HZ_PERSON_BO;
1797: BEGIN
1798: l_per_obj := p_person_obj;
1799: do_update_person_bo(
1800: p_init_msg_list => FND_API.G_TRUE,
1801: p_person_obj => l_per_obj,
1802: p_created_by_module => p_created_by_module,
1803: p_obj_source => p_obj_source,
1804: x_return_status => x_return_status,

Line 1815: IF FND_API.to_Boolean(p_return_obj_flag) THEN

1811: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1812: x_return_status => x_return_status,
1813: x_msg_count => l_msg_count,
1814: x_msg_data => l_msg_data);
1815: IF FND_API.to_Boolean(p_return_obj_flag) THEN
1816: x_return_obj := l_per_obj;
1817: END IF;
1818: END update_person_bo;
1819:

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

1821: --
1822: -- DESCRIPTION
1823: -- Create or update a person business object.
1824: PROCEDURE do_save_person_bo(
1825: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1826: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1827: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
1828: p_created_by_module IN VARCHAR2,
1829: p_obj_source IN VARCHAR2 := null,

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

1822: -- DESCRIPTION
1823: -- Create or update a person business object.
1824: PROCEDURE do_save_person_bo(
1825: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1826: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1827: p_person_obj IN OUT NOCOPY HZ_PERSON_BO,
1828: p_created_by_module IN VARCHAR2,
1829: p_obj_source IN VARCHAR2 := null,
1830: x_return_status OUT NOCOPY VARCHAR2,

Line 1844: x_return_status := FND_API.G_RET_STS_SUCCESS;

1840: l_create_update_flag VARCHAR2(1);
1841: l_debug_prefix VARCHAR2(30);
1842: BEGIN
1843: -- initialize API return status to success.
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;
1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF FND_API.to_Boolean(p_init_msg_list) THEN
1848: FND_MSG_PUB.initialize;

Line 1847: IF FND_API.to_Boolean(p_init_msg_list) THEN

1843: -- initialize API return status to success.
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;
1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF FND_API.to_Boolean(p_init_msg_list) THEN
1848: FND_MSG_PUB.initialize;
1849: END IF;
1850:
1851: -- Debug info.

Line 1878: RAISE FND_API.G_EXC_ERROR;

1874: FND_MSG_PUB.ADD;
1875: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1876: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1877: FND_MSG_PUB.ADD;
1878: RAISE FND_API.G_EXC_ERROR;
1879: END IF;
1880:
1881: IF(l_create_update_flag = 'C') THEN
1882: do_create_person_bo(

Line 1883: p_init_msg_list => fnd_api.g_false,

1879: END IF;
1880:
1881: IF(l_create_update_flag = 'C') THEN
1882: do_create_person_bo(
1883: p_init_msg_list => fnd_api.g_false,
1884: p_validate_bo_flag => p_validate_bo_flag,
1885: p_person_obj => p_person_obj,
1886: p_created_by_module => p_created_by_module,
1887: p_obj_source => p_obj_source,

Line 1897: p_init_msg_list => fnd_api.g_false,

1893: x_person_osr => x_person_osr
1894: );
1895: ELSIF(l_create_update_flag = 'U') THEN
1896: do_update_person_bo(
1897: p_init_msg_list => fnd_api.g_false,
1898: p_person_obj => p_person_obj,
1899: p_created_by_module => p_created_by_module,
1900: p_obj_source => p_obj_source,
1901: x_return_status => x_return_status,

Line 1909: RAISE FND_API.G_EXC_ERROR;

1905: x_person_os => x_person_os,
1906: x_person_osr => x_person_osr
1907: );
1908: ELSE
1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1911:
1912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1913: RAISE FND_API.G_EXC_ERROR;

Line 1912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1908: ELSE
1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1911:
1912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915:
1916: -- Debug info.

Line 1913: RAISE FND_API.G_EXC_ERROR;

1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1911:
1912: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915:
1916: -- Debug info.
1917: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1929: WHEN fnd_api.g_exc_error THEN

1925: p_prefix=>l_debug_prefix,
1926: p_msg_level=>fnd_log.level_procedure);
1927: END IF;
1928: EXCEPTION
1929: WHEN fnd_api.g_exc_error THEN
1930: x_return_status := fnd_api.g_ret_sts_error;
1931:
1932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1933: p_count => x_msg_count,

Line 1930: x_return_status := fnd_api.g_ret_sts_error;

1926: p_msg_level=>fnd_log.level_procedure);
1927: END IF;
1928: EXCEPTION
1929: WHEN fnd_api.g_exc_error THEN
1930: x_return_status := fnd_api.g_ret_sts_error;
1931:
1932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1933: p_count => x_msg_count,
1934: p_data => x_msg_data);

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

1928: EXCEPTION
1929: WHEN fnd_api.g_exc_error THEN
1930: x_return_status := fnd_api.g_ret_sts_error;
1931:
1932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1933: p_count => x_msg_count,
1934: p_data => x_msg_data);
1935:
1936: -- Debug info.

Line 1949: WHEN fnd_api.g_exc_unexpected_error THEN

1945: p_prefix=>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_procedure);
1947: END IF;
1948:
1949: WHEN fnd_api.g_exc_unexpected_error THEN
1950: x_return_status := fnd_api.g_ret_sts_unexp_error;
1951:
1952: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1953: p_count => x_msg_count,

Line 1950: x_return_status := fnd_api.g_ret_sts_unexp_error;

1946: p_msg_level=>fnd_log.level_procedure);
1947: END IF;
1948:
1949: WHEN fnd_api.g_exc_unexpected_error THEN
1950: x_return_status := fnd_api.g_ret_sts_unexp_error;
1951:
1952: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);

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

1948:
1949: WHEN fnd_api.g_exc_unexpected_error THEN
1950: x_return_status := fnd_api.g_ret_sts_unexp_error;
1951:
1952: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);
1955:
1956: -- Debug info.

Line 1969: x_return_status := fnd_api.g_ret_sts_unexp_error;

1965: p_prefix=>l_debug_prefix,
1966: p_msg_level=>fnd_log.level_procedure);
1967: END IF;
1968: WHEN OTHERS THEN
1969: x_return_status := fnd_api.g_ret_sts_unexp_error;
1970:
1971: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1972: fnd_message.set_token('ERROR' ,SQLERRM);
1973: fnd_msg_pub.add;

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

1971: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1972: fnd_message.set_token('ERROR' ,SQLERRM);
1973: fnd_msg_pub.add;
1974:
1975: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1976: p_count => x_msg_count,
1977: p_data => x_msg_data);
1978:
1979: -- Debug info.

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

1990: END IF;
1991: END do_save_person_bo;
1992:
1993: PROCEDURE save_person_bo(
1994: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1995: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1996: p_person_obj IN HZ_PERSON_BO,
1997: p_created_by_module IN VARCHAR2,
1998: x_return_status OUT NOCOPY VARCHAR2,

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

1991: END do_save_person_bo;
1992:
1993: PROCEDURE save_person_bo(
1994: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1995: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1996: p_person_obj IN HZ_PERSON_BO,
1997: p_created_by_module IN VARCHAR2,
1998: x_return_status OUT NOCOPY VARCHAR2,
1999: x_msg_count OUT NOCOPY NUMBER,

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

2020: );
2021: END save_person_bo;
2022:
2023: PROCEDURE save_person_bo(
2024: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2025: p_person_obj IN HZ_PERSON_BO,
2026: p_created_by_module IN VARCHAR2,
2027: p_obj_source IN VARCHAR2 := NULL,
2028: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,

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

2024: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2025: p_person_obj IN HZ_PERSON_BO,
2026: p_created_by_module IN VARCHAR2,
2027: p_obj_source IN VARCHAR2 := NULL,
2028: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2029: x_return_status OUT NOCOPY VARCHAR2,
2030: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2031: x_return_obj OUT NOCOPY HZ_PERSON_BO,
2032: x_person_id OUT NOCOPY NUMBER,

Line 2042: p_init_msg_list => FND_API.G_TRUE,

2038: l_per_obj HZ_PERSON_BO;
2039: BEGIN
2040: l_per_obj := p_person_obj;
2041: do_save_person_bo(
2042: p_init_msg_list => FND_API.G_TRUE,
2043: p_validate_bo_flag => p_validate_bo_flag,
2044: p_person_obj => l_per_obj,
2045: p_created_by_module => p_created_by_module,
2046: p_obj_source => p_obj_source,

Line 2058: IF FND_API.to_Boolean(p_return_obj_flag) THEN

2054: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
2055: x_return_status => x_return_status,
2056: x_msg_count => l_msg_count,
2057: x_msg_data => l_msg_data);
2058: IF FND_API.to_Boolean(p_return_obj_flag) THEN
2059: x_return_obj := l_per_obj;
2060: END IF;
2061: END save_person_bo;
2062:

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

2077: -- p_interest_obj Person interest object.
2078: -- p_party_id Party ID.
2079: -- OUT:
2080: -- x_return_status Return status after the call. The status can
2081: -- be fnd_api.g_ret_sts_success (success),
2082: -- fnd_api.g_ret_sts_error (error),
2083: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2084: -- x_msg_count Number of messages in message stack.
2085: -- x_msg_data Message text if x_msg_count is 1.

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

2078: -- p_party_id Party ID.
2079: -- OUT:
2080: -- x_return_status Return status after the call. The status can
2081: -- be fnd_api.g_ret_sts_success (success),
2082: -- fnd_api.g_ret_sts_error (error),
2083: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2084: -- x_msg_count Number of messages in message stack.
2085: -- x_msg_data Message text if x_msg_count is 1.
2086: --

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

2079: -- OUT:
2080: -- x_return_status Return status after the call. The status can
2081: -- be fnd_api.g_ret_sts_success (success),
2082: -- fnd_api.g_ret_sts_error (error),
2083: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2084: -- x_msg_count Number of messages in message stack.
2085: -- x_msg_data Message text if x_msg_count is 1.
2086: --
2087: -- NOTES

Line 2118: x_return_status := FND_API.G_RET_STS_SUCCESS;

2114: -- Standard start of API savepoint
2115: SAVEPOINT create_person_info_pub;
2116:
2117: -- initialize API return status to success.
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119:
2120: -- Debug info.
2121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'create_person_info(+)',

Line 2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2142: x_msg_count => x_msg_count,
2143: x_msg_data => x_msg_data
2144: );
2145:
2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'Create Person Language - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2149: p_prefix=>l_debug_prefix,
2150: p_msg_level=>fnd_log.level_procedure);

Line 2155: RAISE FND_API.G_EXC_ERROR;

2151: END IF;
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2153: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;
2157:
2158: -- assign person language_use_reference_id
2159: p_language_obj(i).language_use_reference_id := l_dummy_id;

Line 2182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2178: x_msg_count => x_msg_count,
2179: x_msg_data => x_msg_data
2180: );
2181:
2182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2184: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2185: p_prefix=>l_debug_prefix,
2186: p_msg_level=>fnd_log.level_procedure);

Line 2191: RAISE FND_API.G_EXC_ERROR;

2187: END IF;
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2190: FND_MSG_PUB.ADD;
2191: RAISE FND_API.G_EXC_ERROR;
2192: END IF;
2193:
2194: -- assign education_id
2195: p_education_obj(i).education_id := l_dummy_id;

Line 2218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2214: x_msg_count => x_msg_count,
2215: x_msg_data => x_msg_data
2216: );
2217:
2218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure);

Line 2227: RAISE FND_API.G_EXC_ERROR;

2223: END IF;
2224: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2225: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2226: FND_MSG_PUB.ADD;
2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;
2229:
2230: -- assign citizenship_id
2231: p_citizenship_obj(i).citizenship_id := l_dummy_id;

Line 2254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2250: x_msg_count => x_msg_count,
2251: x_msg_data => x_msg_data
2252: );
2253:
2254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'Create Employment History - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2257: p_prefix=>l_debug_prefix,
2258: p_msg_level=>fnd_log.level_procedure);

Line 2263: RAISE FND_API.G_EXC_ERROR;

2259: END IF;
2260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2261: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2262: FND_MSG_PUB.ADD;
2263: RAISE FND_API.G_EXC_ERROR;
2264: ELSE
2265:
2266: -- assign employment_history_id
2267: p_employ_hist_obj(i).employment_history_id := l_dummy_id;

Line 2289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2285: x_msg_count => x_msg_count,
2286: x_msg_data => x_msg_data
2287: );
2288:
2289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2291: 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,
2292: p_prefix=>l_debug_prefix,
2293: p_msg_level=>fnd_log.level_procedure);

Line 2298: RAISE FND_API.G_EXC_ERROR;

2294: END IF;
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2296: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2297: FND_MSG_PUB.ADD;
2298: RAISE FND_API.G_EXC_ERROR;
2299: END IF;
2300:
2301: -- assign work_class_id
2302: p_employ_hist_obj(i).work_class_objs(j).work_class_id := l_dummy_id;

Line 2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2324: x_msg_count => x_msg_count,
2325: x_msg_data => x_msg_data
2326: );
2327:
2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2330: hz_utility_v2pub.debug(p_message=>'Create Person Interest - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2331: p_prefix=>l_debug_prefix,
2332: p_msg_level=>fnd_log.level_procedure);

Line 2337: RAISE FND_API.G_EXC_ERROR;

2333: END IF;
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2335: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2336: FND_MSG_PUB.ADD;
2337: RAISE FND_API.G_EXC_ERROR;
2338: END IF;
2339:
2340: -- assign person_interest_id
2341: p_interest_obj(i).person_interest_id := l_dummy_id;

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: ROLLBACK TO create_person_info_pub;
2360: x_return_status := fnd_api.g_ret_sts_error;
2361:
2362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2360: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 2378: WHEN fnd_api.g_exc_unexpected_error THEN

2374: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2375: p_prefix=>l_debug_prefix,
2376: p_msg_level=>fnd_log.level_procedure);
2377: END IF;
2378: WHEN fnd_api.g_exc_unexpected_error THEN
2379: ROLLBACK TO create_person_info_pub;
2380: x_return_status := fnd_api.g_ret_sts_unexp_error;
2381:
2382: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2380: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2401: x_return_status := fnd_api.g_ret_sts_unexp_error;

2397: END IF;
2398:
2399: WHEN OTHERS THEN
2400: ROLLBACK TO create_person_info_pub;
2401: x_return_status := fnd_api.g_ret_sts_unexp_error;
2402:
2403: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2404: fnd_message.set_token('ERROR' ,SQLERRM);
2405: fnd_msg_pub.add;

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

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

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

2439: -- p_interest_obj Person interest object.
2440: -- p_party_id Party ID.
2441: -- OUT:
2442: -- x_return_status Return status after the call. The status can
2443: -- be fnd_api.g_ret_sts_success (success),
2444: -- fnd_api.g_ret_sts_error (error),
2445: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2446: -- x_msg_count Number of messages in message stack.
2447: -- x_msg_data Message text if x_msg_count is 1.

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

2440: -- p_party_id Party ID.
2441: -- OUT:
2442: -- x_return_status Return status after the call. The status can
2443: -- be fnd_api.g_ret_sts_success (success),
2444: -- fnd_api.g_ret_sts_error (error),
2445: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2446: -- x_msg_count Number of messages in message stack.
2447: -- x_msg_data Message text if x_msg_count is 1.
2448: --

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

2441: -- OUT:
2442: -- x_return_status Return status after the call. The status can
2443: -- be fnd_api.g_ret_sts_success (success),
2444: -- fnd_api.g_ret_sts_error (error),
2445: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2446: -- x_msg_count Number of messages in message stack.
2447: -- x_msg_data Message text if x_msg_count is 1.
2448: --
2449: -- NOTES

Line 2481: x_return_status := FND_API.G_RET_STS_SUCCESS;

2477: -- Standard start of API savepoint
2478: SAVEPOINT save_person_info_pub;
2479:
2480: -- initialize API return status to success.
2481: x_return_status := FND_API.G_RET_STS_SUCCESS;
2482:
2483: -- Debug info.
2484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2485: hz_utility_v2pub.debug(p_message=>'save_person_info(+)',

Line 2519: RAISE FND_API.G_EXC_ERROR;

2515: FND_MSG_PUB.ADD;
2516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2517: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2518: FND_MSG_PUB.ADD;
2519: RAISE FND_API.G_EXC_ERROR;
2520: END IF;
2521:
2522: IF(l_ovn IS NULL) THEN
2523: HZ_PERSON_INFO_V2PUB.create_person_language(

Line 2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2543:
2544: -- assign person language_use_reference_id
2545: p_language_obj(i).language_use_reference_id := l_person_lang_rec.language_use_reference_id;
2546: END IF;
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2549: 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,
2550: p_prefix=>l_debug_prefix,
2551: p_msg_level=>fnd_log.level_procedure);

Line 2556: RAISE FND_API.G_EXC_ERROR;

2552: END IF;
2553: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2554: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2555: FND_MSG_PUB.ADD;
2556: RAISE FND_API.G_EXC_ERROR;
2557: END IF;
2558: END LOOP;
2559: END IF;
2560:

Line 2592: RAISE FND_API.G_EXC_ERROR;

2588: FND_MSG_PUB.ADD;
2589: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2590: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2591: FND_MSG_PUB.ADD;
2592: RAISE FND_API.G_EXC_ERROR;
2593: END IF;
2594:
2595: IF(l_ovn IS NULL) THEN
2596: HZ_PERSON_INFO_V2PUB.create_education(

Line 2620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2616:
2617: -- assign education_id
2618: p_education_obj(i).education_id := l_education_rec.education_id;
2619: END IF;
2620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: 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,
2623: p_prefix=>l_debug_prefix,
2624: p_msg_level=>fnd_log.level_procedure);

Line 2629: RAISE FND_API.G_EXC_ERROR;

2625: END IF;
2626: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2627: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2628: FND_MSG_PUB.ADD;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;
2631: END LOOP;
2632: END IF;
2633:

Line 2663: RAISE FND_API.G_EXC_ERROR;

2659: FND_MSG_PUB.ADD;
2660: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2661: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2662: FND_MSG_PUB.ADD;
2663: RAISE FND_API.G_EXC_ERROR;
2664: END IF;
2665:
2666: IF(l_ovn IS NULL) THEN
2667: HZ_PERSON_INFO_V2PUB.create_citizenship(

Line 2691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2687:
2688: -- assign citizenship_id
2689: p_citizenship_obj(i).citizenship_id := l_citizenship_rec.citizenship_id;
2690: END IF;
2691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2693: 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,
2694: p_prefix=>l_debug_prefix,
2695: p_msg_level=>fnd_log.level_procedure);

Line 2700: RAISE FND_API.G_EXC_ERROR;

2696: END IF;
2697: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2698: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2699: FND_MSG_PUB.ADD;
2700: RAISE FND_API.G_EXC_ERROR;
2701: END IF;
2702: END LOOP;
2703: END IF;
2704:

Line 2736: RAISE FND_API.G_EXC_ERROR;

2732: FND_MSG_PUB.ADD;
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2734: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738:
2739: IF(l_ovn IS NULL) THEN
2740: HZ_PERSON_INFO_V2PUB.create_employment_history(

Line 2765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2761:
2762: -- assign employment_history_id
2763: p_employ_hist_obj(i).employment_history_id := l_dummy_id;
2764: END IF;
2765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2767: 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,
2768: p_prefix=>l_debug_prefix,
2769: p_msg_level=>fnd_log.level_procedure);

Line 2774: RAISE FND_API.G_EXC_ERROR;

2770: END IF;
2771: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2772: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2773: FND_MSG_PUB.ADD;
2774: RAISE FND_API.G_EXC_ERROR;
2775: ELSE
2776: ---------------------------
2777: -- Create/Update work class
2778: ---------------------------

Line 2805: RAISE FND_API.G_EXC_ERROR;

2801: FND_MSG_PUB.ADD;
2802: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2803: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2804: FND_MSG_PUB.ADD;
2805: RAISE FND_API.G_EXC_ERROR;
2806: END IF;
2807:
2808: IF(l_ovn IS NULL) THEN
2809: HZ_PERSON_INFO_V2PUB.create_work_class(

Line 2833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2829:
2830: -- assign work_class_id
2831: p_employ_hist_obj(i).work_class_objs(j).work_class_id := l_work_class_rec.work_class_id;
2832: END IF;
2833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2834: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2835: 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,
2836: p_prefix=>l_debug_prefix,
2837: p_msg_level=>fnd_log.level_procedure);

Line 2842: RAISE FND_API.G_EXC_ERROR;

2838: END IF;
2839: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2840: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2841: FND_MSG_PUB.ADD;
2842: RAISE FND_API.G_EXC_ERROR;
2843: END IF;
2844: END LOOP;
2845: END IF;
2846: END IF;

Line 2881: RAISE FND_API.G_EXC_ERROR;

2877: FND_MSG_PUB.ADD;
2878: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2879: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2880: FND_MSG_PUB.ADD;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: IF(l_ovn IS NULL) THEN
2885: HZ_PERSON_INFO_V2PUB.create_person_interest(

Line 2909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2905:
2906: -- assign person_interest_id
2907: p_interest_obj(i).person_interest_id := l_interest_rec.person_interest_id;
2908: END IF;
2909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: 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,
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);

Line 2918: RAISE FND_API.G_EXC_ERROR;

2914: END IF;
2915: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2916: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2917: FND_MSG_PUB.ADD;
2918: RAISE FND_API.G_EXC_ERROR;
2919: END IF;
2920: END LOOP;
2921: END IF;
2922:

Line 2936: WHEN fnd_api.g_exc_error THEN

2932: p_prefix=>l_debug_prefix,
2933: p_msg_level=>fnd_log.level_procedure);
2934: END IF;
2935: EXCEPTION
2936: WHEN fnd_api.g_exc_error THEN
2937: ROLLBACK TO save_person_info_pub;
2938: x_return_status := fnd_api.g_ret_sts_error;
2939:
2940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2938: x_return_status := fnd_api.g_ret_sts_error;

2934: END IF;
2935: EXCEPTION
2936: WHEN fnd_api.g_exc_error THEN
2937: ROLLBACK TO save_person_info_pub;
2938: x_return_status := fnd_api.g_ret_sts_error;
2939:
2940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data);

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

2936: WHEN fnd_api.g_exc_error THEN
2937: ROLLBACK TO save_person_info_pub;
2938: x_return_status := fnd_api.g_ret_sts_error;
2939:
2940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data);
2943:
2944: -- Debug info.

Line 2956: WHEN fnd_api.g_exc_unexpected_error THEN

2952: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2953: p_prefix=>l_debug_prefix,
2954: p_msg_level=>fnd_log.level_procedure);
2955: END IF;
2956: WHEN fnd_api.g_exc_unexpected_error THEN
2957: ROLLBACK TO save_person_info_pub;
2958: x_return_status := fnd_api.g_ret_sts_unexp_error;
2959:
2960: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2958: x_return_status := fnd_api.g_ret_sts_unexp_error;

2954: p_msg_level=>fnd_log.level_procedure);
2955: END IF;
2956: WHEN fnd_api.g_exc_unexpected_error THEN
2957: ROLLBACK TO save_person_info_pub;
2958: x_return_status := fnd_api.g_ret_sts_unexp_error;
2959:
2960: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2961: p_count => x_msg_count,
2962: p_data => x_msg_data);

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

2956: WHEN fnd_api.g_exc_unexpected_error THEN
2957: ROLLBACK TO save_person_info_pub;
2958: x_return_status := fnd_api.g_ret_sts_unexp_error;
2959:
2960: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2961: p_count => x_msg_count,
2962: p_data => x_msg_data);
2963:
2964: -- Debug info.

Line 2979: x_return_status := fnd_api.g_ret_sts_unexp_error;

2975: END IF;
2976:
2977: WHEN OTHERS THEN
2978: ROLLBACK TO save_person_info_pub;
2979: x_return_status := fnd_api.g_ret_sts_unexp_error;
2980:
2981: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2982: fnd_message.set_token('ERROR' ,SQLERRM);
2983: fnd_msg_pub.add;

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

2981: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2982: fnd_message.set_token('ERROR' ,SQLERRM);
2983: fnd_msg_pub.add;
2984:
2985: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2986: p_count => x_msg_count,
2987: p_data => x_msg_data);
2988:
2989: -- Debug info.

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

3010: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3011: --
3012: -- ARGUMENTS
3013: -- IN:
3014: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
3015: -- p_person_id Person ID.
3016: -- p_person_os Person orig system.
3017: -- p_person_osr Person orig system reference.
3018: -- OUT:

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

3017: -- p_person_osr Person orig system reference.
3018: -- OUT:
3019: -- x_person_obj Logical person record.
3020: -- x_return_status Return status after the call. The status can
3021: -- be fnd_api.g_ret_sts_success (success),
3022: -- fnd_api.g_ret_sts_error (error),
3023: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3024: -- x_msg_count Number of messages in message stack.
3025: -- x_msg_data Message text if x_msg_count is 1.

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

3018: -- OUT:
3019: -- x_person_obj Logical person record.
3020: -- x_return_status Return status after the call. The status can
3021: -- be fnd_api.g_ret_sts_success (success),
3022: -- fnd_api.g_ret_sts_error (error),
3023: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3024: -- x_msg_count Number of messages in message stack.
3025: -- x_msg_data Message text if x_msg_count is 1.
3026: --

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

3019: -- x_person_obj Logical person record.
3020: -- x_return_status Return status after the call. The status can
3021: -- be fnd_api.g_ret_sts_success (success),
3022: -- fnd_api.g_ret_sts_error (error),
3023: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3024: -- x_msg_count Number of messages in message stack.
3025: -- x_msg_data Message text if x_msg_count is 1.
3026: --
3027: -- NOTES

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

3069: Financial Profile N Y HZ_FINANCIAL_PROFILE
3070: */
3071:
3072: PROCEDURE get_person_bo (
3073: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3074: p_person_id IN NUMBER,
3075: p_person_os IN VARCHAR2,
3076: p_person_osr IN VARCHAR2,
3077: x_person_obj OUT NOCOPY HZ_PERSON_BO,

Line 3090: x_return_status := FND_API.G_RET_STS_SUCCESS;

3086: l_person_osr varchar2(255);
3087: BEGIN
3088:
3089: -- initialize API return status to success.
3090: x_return_status := FND_API.G_RET_STS_SUCCESS;
3091:
3092: -- Initialize message list if p_init_msg_list is set to TRUE
3093: IF FND_API.to_Boolean(p_init_msg_list) THEN
3094: FND_MSG_PUB.initialize;

Line 3093: IF FND_API.to_Boolean(p_init_msg_list) THEN

3089: -- initialize API return status to success.
3090: x_return_status := FND_API.G_RET_STS_SUCCESS;
3091:
3092: -- Initialize message list if p_init_msg_list is set to TRUE
3093: IF FND_API.to_Boolean(p_init_msg_list) THEN
3094: FND_MSG_PUB.initialize;
3095: END IF;
3096:
3097:

Line 3121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3117: x_return_status => x_return_status,
3118: x_msg_count => x_msg_count,
3119: x_msg_data => x_msg_data);
3120:
3121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3122: RAISE fnd_api.g_exc_error;
3123: END IF;
3124:
3125: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(

Line 3122: RAISE fnd_api.g_exc_error;

3118: x_msg_count => x_msg_count,
3119: x_msg_data => x_msg_data);
3120:
3121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3122: RAISE fnd_api.g_exc_error;
3123: END IF;
3124:
3125: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
3126: p_init_msg_list => fnd_api.g_false,

Line 3126: p_init_msg_list => fnd_api.g_false,

3122: RAISE fnd_api.g_exc_error;
3123: END IF;
3124:
3125: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
3126: p_init_msg_list => fnd_api.g_false,
3127: p_person_id => l_person_id,
3128: p_action_type => NULL,
3129: x_person_obj => x_person_obj,
3130: x_return_status => x_return_status,

Line 3134: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3130: x_return_status => x_return_status,
3131: x_msg_count => x_msg_count,
3132: x_msg_data => x_msg_data);
3133:
3134: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3135: RAISE FND_API.G_EXC_ERROR;
3136: END IF;
3137:
3138:

Line 3135: RAISE FND_API.G_EXC_ERROR;

3131: x_msg_count => x_msg_count,
3132: x_msg_data => x_msg_data);
3133:
3134: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3135: RAISE FND_API.G_EXC_ERROR;
3136: END IF;
3137:
3138:
3139: -- Debug info.

Line 3157: WHEN fnd_api.g_exc_error THEN

3153:
3154:
3155: EXCEPTION
3156:
3157: WHEN fnd_api.g_exc_error THEN
3158: x_return_status := fnd_api.g_ret_sts_error;
3159:
3160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3161: p_count => x_msg_count,

Line 3158: x_return_status := fnd_api.g_ret_sts_error;

3154:
3155: EXCEPTION
3156:
3157: WHEN fnd_api.g_exc_error THEN
3158: x_return_status := fnd_api.g_ret_sts_error;
3159:
3160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3161: p_count => x_msg_count,
3162: p_data => x_msg_data);

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

3156:
3157: WHEN fnd_api.g_exc_error THEN
3158: x_return_status := fnd_api.g_ret_sts_error;
3159:
3160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3161: p_count => x_msg_count,
3162: p_data => x_msg_data);
3163:
3164: -- Debug info.

Line 3176: WHEN fnd_api.g_exc_unexpected_error THEN

3172: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3173: p_prefix=>l_debug_prefix,
3174: p_msg_level=>fnd_log.level_procedure);
3175: END IF;
3176: WHEN fnd_api.g_exc_unexpected_error THEN
3177: x_return_status := fnd_api.g_ret_sts_unexp_error;
3178:
3179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3180: p_count => x_msg_count,

Line 3177: x_return_status := fnd_api.g_ret_sts_unexp_error;

3173: p_prefix=>l_debug_prefix,
3174: p_msg_level=>fnd_log.level_procedure);
3175: END IF;
3176: WHEN fnd_api.g_exc_unexpected_error THEN
3177: x_return_status := fnd_api.g_ret_sts_unexp_error;
3178:
3179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3180: p_count => x_msg_count,
3181: p_data => x_msg_data);

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

3175: END IF;
3176: WHEN fnd_api.g_exc_unexpected_error THEN
3177: x_return_status := fnd_api.g_ret_sts_unexp_error;
3178:
3179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3180: p_count => x_msg_count,
3181: p_data => x_msg_data);
3182:
3183: -- Debug info.

Line 3196: x_return_status := fnd_api.g_ret_sts_unexp_error;

3192: p_prefix=>l_debug_prefix,
3193: p_msg_level=>fnd_log.level_procedure);
3194: END IF;
3195: WHEN OTHERS THEN
3196: x_return_status := fnd_api.g_ret_sts_unexp_error;
3197:
3198: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3199: fnd_message.set_token('ERROR' ,SQLERRM);
3200: fnd_msg_pub.add;

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

3198: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3199: fnd_message.set_token('ERROR' ,SQLERRM);
3200: fnd_msg_pub.add;
3201:
3202: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3203: p_count => x_msg_count,
3204: p_data => x_msg_data);
3205:
3206: -- Debug info.

Line 3233: p_init_msg_list => FND_API.G_TRUE,

3229: l_msg_count NUMBER;
3230: l_msg_data VARCHAR2(2000);
3231: BEGIN
3232: get_person_bo(
3233: p_init_msg_list => FND_API.G_TRUE,
3234: p_person_id => p_person_id,
3235: p_person_os => p_person_os,
3236: p_person_osr => p_person_osr,
3237: x_person_obj => x_person_obj,

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

3260: -- ARGUMENTS
3261: -- IN:
3262: -- p_init_msg_list Initialize message stack if it is set to
3263: -- p_event_id BES Event identifier.
3264: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3265: -- OUT:
3266: -- x_person_obj One or more created logical person.
3267: -- x_return_status Return status after the call. The status can
3268: -- be fnd_api.g_ret_sts_success (success),

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

3264: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3265: -- OUT:
3266: -- x_person_obj One or more created logical person.
3267: -- x_return_status Return status after the call. The status can
3268: -- be fnd_api.g_ret_sts_success (success),
3269: -- fnd_api.g_ret_sts_error (error),
3270: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3271: -- x_msg_count Number of messages in message stack.
3272: -- x_msg_data Message text if x_msg_count is 1.

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

3265: -- OUT:
3266: -- x_person_obj One or more created logical person.
3267: -- x_return_status Return status after the call. The status can
3268: -- be fnd_api.g_ret_sts_success (success),
3269: -- fnd_api.g_ret_sts_error (error),
3270: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3271: -- x_msg_count Number of messages in message stack.
3272: -- x_msg_data Message text if x_msg_count is 1.
3273: --

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

3266: -- x_person_obj One or more created logical person.
3267: -- x_return_status Return status after the call. The status can
3268: -- be fnd_api.g_ret_sts_success (success),
3269: -- fnd_api.g_ret_sts_error (error),
3270: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3271: -- x_msg_count Number of messages in message stack.
3272: -- x_msg_data Message text if x_msg_count is 1.
3273: --
3274: -- NOTES

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

3294: */
3295:
3296:
3297: PROCEDURE get_persons_created(
3298: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3299: p_event_id IN NUMBER,
3300: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3301: x_return_status OUT NOCOPY VARCHAR2,
3302: x_msg_count OUT NOCOPY NUMBER,

Line 3309: x_return_status := FND_API.G_RET_STS_SUCCESS;

3305: l_debug_prefix VARCHAR2(30) := '';
3306: begin
3307:
3308: -- initialize API return status to success.
3309: x_return_status := FND_API.G_RET_STS_SUCCESS;
3310:
3311: -- Initialize message list if p_init_msg_list is set to TRUE
3312: IF FND_API.to_Boolean(p_init_msg_list) THEN
3313: FND_MSG_PUB.initialize;

Line 3312: IF FND_API.to_Boolean(p_init_msg_list) THEN

3308: -- initialize API return status to success.
3309: x_return_status := FND_API.G_RET_STS_SUCCESS;
3310:
3311: -- Initialize message list if p_init_msg_list is set to TRUE
3312: IF FND_API.to_Boolean(p_init_msg_list) THEN
3313: FND_MSG_PUB.initialize;
3314: END IF;
3315:
3316:

Line 3331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3327: p_event_type => 'C',
3328: p_bo_code => 'PERSON',
3329: x_return_status => x_return_status);
3330:
3331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334:
3335: HZ_EXTRACT_PERSON_BO_PVT.get_persons_created(

Line 3332: RAISE FND_API.G_EXC_ERROR;

3328: p_bo_code => 'PERSON',
3329: x_return_status => x_return_status);
3330:
3331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334:
3335: HZ_EXTRACT_PERSON_BO_PVT.get_persons_created(
3336: p_init_msg_list => fnd_api.g_false,

Line 3336: p_init_msg_list => fnd_api.g_false,

3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334:
3335: HZ_EXTRACT_PERSON_BO_PVT.get_persons_created(
3336: p_init_msg_list => fnd_api.g_false,
3337: p_event_id => p_event_id,
3338: x_person_objs => x_person_objs,
3339: x_return_status => x_return_status,
3340: x_msg_count => x_msg_count,

Line 3343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3339: x_return_status => x_return_status,
3340: x_msg_count => x_msg_count,
3341: x_msg_data => x_msg_data);
3342:
3343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;
3346:
3347:

Line 3344: RAISE FND_API.G_EXC_ERROR;

3340: x_msg_count => x_msg_count,
3341: x_msg_data => x_msg_data);
3342:
3343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;
3346:
3347:
3348:

Line 3367: WHEN fnd_api.g_exc_error THEN

3363:
3364:
3365: EXCEPTION
3366:
3367: WHEN fnd_api.g_exc_error THEN
3368: x_return_status := fnd_api.g_ret_sts_error;
3369:
3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3371: p_count => x_msg_count,

Line 3368: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 3386: WHEN fnd_api.g_exc_unexpected_error THEN

3382: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3383: p_prefix=>l_debug_prefix,
3384: p_msg_level=>fnd_log.level_procedure);
3385: END IF;
3386: WHEN fnd_api.g_exc_unexpected_error THEN
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,

Line 3387: x_return_status := fnd_api.g_ret_sts_unexp_error;

3383: p_prefix=>l_debug_prefix,
3384: p_msg_level=>fnd_log.level_procedure);
3385: END IF;
3386: WHEN fnd_api.g_exc_unexpected_error THEN
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: END IF;
3386: WHEN fnd_api.g_exc_unexpected_error THEN
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 3406: x_return_status := fnd_api.g_ret_sts_unexp_error;

3402: p_prefix=>l_debug_prefix,
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3405: WHEN OTHERS THEN
3406: x_return_status := fnd_api.g_ret_sts_unexp_error;
3407:
3408: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3409: fnd_message.set_token('ERROR' ,SQLERRM);
3410: fnd_msg_pub.add;

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

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

Line 3441: p_init_msg_list => FND_API.G_TRUE,

3437: l_msg_count NUMBER;
3438: l_msg_data VARCHAR2(2000);
3439: BEGIN
3440: get_persons_created(
3441: p_init_msg_list => FND_API.G_TRUE,
3442: p_event_id => p_event_id,
3443: x_person_objs => x_person_objs,
3444: x_return_status => x_return_status,
3445: x_msg_count => l_msg_count,

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

3466: -- ARGUMENTS
3467: -- IN:
3468: -- p_init_msg_list Initialize message stack if it is set to
3469: -- p_event_id BES Event identifier.
3470: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3471: -- OUT:
3472: -- x_person_objs One or more created logical person.
3473: -- x_return_status Return status after the call. The status can
3474: -- be fnd_api.g_ret_sts_success (success),

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

3470: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3471: -- OUT:
3472: -- x_person_objs One or more created logical person.
3473: -- x_return_status Return status after the call. The status can
3474: -- be fnd_api.g_ret_sts_success (success),
3475: -- fnd_api.g_ret_sts_error (error),
3476: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3477: -- x_msg_count Number of messages in message stack.
3478: -- x_msg_data Message text if x_msg_count is 1.

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

3471: -- OUT:
3472: -- x_person_objs One or more created logical person.
3473: -- x_return_status Return status after the call. The status can
3474: -- be fnd_api.g_ret_sts_success (success),
3475: -- fnd_api.g_ret_sts_error (error),
3476: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3477: -- x_msg_count Number of messages in message stack.
3478: -- x_msg_data Message text if x_msg_count is 1.
3479: --

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

3472: -- x_person_objs One or more created logical person.
3473: -- x_return_status Return status after the call. The status can
3474: -- be fnd_api.g_ret_sts_success (success),
3475: -- fnd_api.g_ret_sts_error (error),
3476: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3477: -- x_msg_count Number of messages in message stack.
3478: -- x_msg_data Message text if x_msg_count is 1.
3479: --
3480: -- NOTES

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

3496: returns them to the caller.
3497: */
3498:
3499: PROCEDURE get_persons_updated(
3500: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3501: p_event_id IN NUMBER,
3502: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
3503: x_return_status OUT NOCOPY VARCHAR2,
3504: x_msg_count OUT NOCOPY NUMBER,

Line 3512: x_return_status := FND_API.G_RET_STS_SUCCESS;

3508: l_debug_prefix VARCHAR2(30) := '';
3509: begin
3510:
3511: -- initialize API return status to success.
3512: x_return_status := FND_API.G_RET_STS_SUCCESS;
3513:
3514: -- Initialize message list if p_init_msg_list is set to TRUE
3515: IF FND_API.to_Boolean(p_init_msg_list) THEN
3516: FND_MSG_PUB.initialize;

Line 3515: IF FND_API.to_Boolean(p_init_msg_list) THEN

3511: -- initialize API return status to success.
3512: x_return_status := FND_API.G_RET_STS_SUCCESS;
3513:
3514: -- Initialize message list if p_init_msg_list is set to TRUE
3515: IF FND_API.to_Boolean(p_init_msg_list) THEN
3516: FND_MSG_PUB.initialize;
3517: END IF;
3518:
3519:

Line 3533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3529: p_event_type => 'U',
3530: p_bo_code => 'PERSON',
3531: x_return_status => x_return_status);
3532:
3533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3534: RAISE FND_API.G_EXC_ERROR;
3535: END IF;
3536:
3537: HZ_EXTRACT_PERSON_BO_PVT.get_persons_updated(

Line 3534: RAISE FND_API.G_EXC_ERROR;

3530: p_bo_code => 'PERSON',
3531: x_return_status => x_return_status);
3532:
3533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3534: RAISE FND_API.G_EXC_ERROR;
3535: END IF;
3536:
3537: HZ_EXTRACT_PERSON_BO_PVT.get_persons_updated(
3538: p_init_msg_list => fnd_api.g_false,

Line 3538: p_init_msg_list => fnd_api.g_false,

3534: RAISE FND_API.G_EXC_ERROR;
3535: END IF;
3536:
3537: HZ_EXTRACT_PERSON_BO_PVT.get_persons_updated(
3538: p_init_msg_list => fnd_api.g_false,
3539: p_event_id => p_event_id,
3540: x_person_objs => x_person_objs,
3541: x_return_status => x_return_status,
3542: x_msg_count => x_msg_count,

Line 3545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3541: x_return_status => x_return_status,
3542: x_msg_count => x_msg_count,
3543: x_msg_data => x_msg_data);
3544:
3545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:
3549:

Line 3546: RAISE FND_API.G_EXC_ERROR;

3542: x_msg_count => x_msg_count,
3543: x_msg_data => x_msg_data);
3544:
3545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:
3549:
3550:

Line 3569: WHEN fnd_api.g_exc_error THEN

3565:
3566:
3567: EXCEPTION
3568:
3569: WHEN fnd_api.g_exc_error THEN
3570: x_return_status := fnd_api.g_ret_sts_error;
3571:
3572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3573: p_count => x_msg_count,

Line 3570: x_return_status := fnd_api.g_ret_sts_error;

3566:
3567: EXCEPTION
3568:
3569: WHEN fnd_api.g_exc_error THEN
3570: x_return_status := fnd_api.g_ret_sts_error;
3571:
3572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3573: p_count => x_msg_count,
3574: p_data => x_msg_data);

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

3568:
3569: WHEN fnd_api.g_exc_error THEN
3570: x_return_status := fnd_api.g_ret_sts_error;
3571:
3572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3573: p_count => x_msg_count,
3574: p_data => x_msg_data);
3575:
3576: -- Debug info.

Line 3588: WHEN fnd_api.g_exc_unexpected_error THEN

3584: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3585: p_prefix=>l_debug_prefix,
3586: p_msg_level=>fnd_log.level_procedure);
3587: END IF;
3588: WHEN fnd_api.g_exc_unexpected_error THEN
3589: x_return_status := fnd_api.g_ret_sts_unexp_error;
3590:
3591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3592: p_count => x_msg_count,

Line 3589: x_return_status := fnd_api.g_ret_sts_unexp_error;

3585: p_prefix=>l_debug_prefix,
3586: p_msg_level=>fnd_log.level_procedure);
3587: END IF;
3588: WHEN fnd_api.g_exc_unexpected_error THEN
3589: x_return_status := fnd_api.g_ret_sts_unexp_error;
3590:
3591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3592: p_count => x_msg_count,
3593: p_data => x_msg_data);

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

3587: END IF;
3588: WHEN fnd_api.g_exc_unexpected_error THEN
3589: x_return_status := fnd_api.g_ret_sts_unexp_error;
3590:
3591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3592: p_count => x_msg_count,
3593: p_data => x_msg_data);
3594:
3595: -- Debug info.

Line 3608: x_return_status := fnd_api.g_ret_sts_unexp_error;

3604: p_prefix=>l_debug_prefix,
3605: p_msg_level=>fnd_log.level_procedure);
3606: END IF;
3607: WHEN OTHERS THEN
3608: x_return_status := fnd_api.g_ret_sts_unexp_error;
3609:
3610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3611: fnd_message.set_token('ERROR' ,SQLERRM);
3612: fnd_msg_pub.add;

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

3610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3611: fnd_message.set_token('ERROR' ,SQLERRM);
3612: fnd_msg_pub.add;
3613:
3614: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3615: p_count => x_msg_count,
3616: p_data => x_msg_data);
3617:
3618: -- Debug info.

Line 3643: p_init_msg_list => FND_API.G_TRUE,

3639: l_msg_count NUMBER;
3640: l_msg_data VARCHAR2(2000);
3641: BEGIN
3642: get_persons_updated(
3643: p_init_msg_list => FND_API.G_TRUE,
3644: p_event_id => p_event_id,
3645: x_person_objs => x_person_objs,
3646: x_return_status => x_return_status,
3647: x_msg_count => l_msg_count,

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

3668: -- IN:
3669: -- p_init_msg_list Initialize message stack if it is set to
3670: -- p_event_id BES Event identifier.
3671: -- p_person_id Person identifier.
3672: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3673: -- OUT:
3674: -- x_person_objs One or more created logical person.
3675: -- x_return_status Return status after the call. The status can
3676: -- be fnd_api.g_ret_sts_success (success),

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

3672: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
3673: -- OUT:
3674: -- x_person_objs One or more created logical person.
3675: -- x_return_status Return status after the call. The status can
3676: -- be fnd_api.g_ret_sts_success (success),
3677: -- fnd_api.g_ret_sts_error (error),
3678: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3679: -- x_msg_count Number of messages in message stack.
3680: -- x_msg_data Message text if x_msg_count is 1.

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

3673: -- OUT:
3674: -- x_person_objs One or more created logical person.
3675: -- x_return_status Return status after the call. The status can
3676: -- be fnd_api.g_ret_sts_success (success),
3677: -- fnd_api.g_ret_sts_error (error),
3678: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3679: -- x_msg_count Number of messages in message stack.
3680: -- x_msg_data Message text if x_msg_count is 1.
3681: --

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

3674: -- x_person_objs One or more created logical person.
3675: -- x_return_status Return status after the call. The status can
3676: -- be fnd_api.g_ret_sts_success (success),
3677: -- fnd_api.g_ret_sts_error (error),
3678: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3679: -- x_msg_count Number of messages in message stack.
3680: -- x_msg_data Message text if x_msg_count is 1.
3681: --
3682: -- NOTES

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

3690:
3691: -- Get only one person object based on p_person_id and event_id
3692:
3693: PROCEDURE get_person_updated(
3694: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3695: p_event_id IN NUMBER,
3696: p_person_id IN NUMBER,
3697: x_person_obj OUT NOCOPY HZ_PERSON_BO,
3698: x_return_status OUT NOCOPY VARCHAR2,

Line 3706: x_return_status := FND_API.G_RET_STS_SUCCESS;

3702: l_debug_prefix VARCHAR2(30) := '';
3703: begin
3704:
3705: -- initialize API return status to success.
3706: x_return_status := FND_API.G_RET_STS_SUCCESS;
3707:
3708: -- Initialize message list if p_init_msg_list is set to TRUE
3709: IF FND_API.to_Boolean(p_init_msg_list) THEN
3710: FND_MSG_PUB.initialize;

Line 3709: IF FND_API.to_Boolean(p_init_msg_list) THEN

3705: -- initialize API return status to success.
3706: x_return_status := FND_API.G_RET_STS_SUCCESS;
3707:
3708: -- Initialize message list if p_init_msg_list is set to TRUE
3709: IF FND_API.to_Boolean(p_init_msg_list) THEN
3710: FND_MSG_PUB.initialize;
3711: END IF;
3712:
3713:

Line 3727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3723: p_event_type => 'U',
3724: p_bo_code => 'PERSON',
3725: x_return_status => x_return_status);
3726:
3727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3728: RAISE FND_API.G_EXC_ERROR;
3729: END IF;
3730:
3731:

Line 3728: RAISE FND_API.G_EXC_ERROR;

3724: p_bo_code => 'PERSON',
3725: x_return_status => x_return_status);
3726:
3727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3728: RAISE FND_API.G_EXC_ERROR;
3729: END IF;
3730:
3731:
3732: HZ_EXTRACT_PERSON_BO_PVT.get_person_updated(

Line 3733: p_init_msg_list => fnd_api.g_false,

3729: END IF;
3730:
3731:
3732: HZ_EXTRACT_PERSON_BO_PVT.get_person_updated(
3733: p_init_msg_list => fnd_api.g_false,
3734: p_event_id => p_event_id,
3735: p_person_id => p_person_id,
3736: x_person_obj => x_person_obj,
3737: x_return_status => x_return_status,

Line 3741: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3737: x_return_status => x_return_status,
3738: x_msg_count => x_msg_count,
3739: x_msg_data => x_msg_data);
3740:
3741: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3742: RAISE FND_API.G_EXC_ERROR;
3743: END IF;
3744:
3745:

Line 3742: RAISE FND_API.G_EXC_ERROR;

3738: x_msg_count => x_msg_count,
3739: x_msg_data => x_msg_data);
3740:
3741: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3742: RAISE FND_API.G_EXC_ERROR;
3743: END IF;
3744:
3745:
3746:

Line 3765: WHEN fnd_api.g_exc_error THEN

3761:
3762:
3763: EXCEPTION
3764:
3765: WHEN fnd_api.g_exc_error THEN
3766: x_return_status := fnd_api.g_ret_sts_error;
3767:
3768: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3769: p_count => x_msg_count,

Line 3766: x_return_status := fnd_api.g_ret_sts_error;

3762:
3763: EXCEPTION
3764:
3765: WHEN fnd_api.g_exc_error THEN
3766: x_return_status := fnd_api.g_ret_sts_error;
3767:
3768: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3769: p_count => x_msg_count,
3770: p_data => x_msg_data);

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

3764:
3765: WHEN fnd_api.g_exc_error THEN
3766: x_return_status := fnd_api.g_ret_sts_error;
3767:
3768: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3769: p_count => x_msg_count,
3770: p_data => x_msg_data);
3771:
3772: -- Debug info.

Line 3784: WHEN fnd_api.g_exc_unexpected_error THEN

3780: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3781: p_prefix=>l_debug_prefix,
3782: p_msg_level=>fnd_log.level_procedure);
3783: END IF;
3784: WHEN fnd_api.g_exc_unexpected_error THEN
3785: x_return_status := fnd_api.g_ret_sts_unexp_error;
3786:
3787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3788: p_count => x_msg_count,

Line 3785: x_return_status := fnd_api.g_ret_sts_unexp_error;

3781: p_prefix=>l_debug_prefix,
3782: p_msg_level=>fnd_log.level_procedure);
3783: END IF;
3784: WHEN fnd_api.g_exc_unexpected_error THEN
3785: x_return_status := fnd_api.g_ret_sts_unexp_error;
3786:
3787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3788: p_count => x_msg_count,
3789: p_data => x_msg_data);

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

3783: END IF;
3784: WHEN fnd_api.g_exc_unexpected_error THEN
3785: x_return_status := fnd_api.g_ret_sts_unexp_error;
3786:
3787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3788: p_count => x_msg_count,
3789: p_data => x_msg_data);
3790:
3791: -- Debug info.

Line 3804: x_return_status := fnd_api.g_ret_sts_unexp_error;

3800: p_prefix=>l_debug_prefix,
3801: p_msg_level=>fnd_log.level_procedure);
3802: END IF;
3803: WHEN OTHERS THEN
3804: x_return_status := fnd_api.g_ret_sts_unexp_error;
3805:
3806: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3807: fnd_message.set_token('ERROR' ,SQLERRM);
3808: fnd_msg_pub.add;

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

3806: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3807: fnd_message.set_token('ERROR' ,SQLERRM);
3808: fnd_msg_pub.add;
3809:
3810: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3811: p_count => x_msg_count,
3812: p_data => x_msg_data);
3813:
3814: -- Debug info.

Line 3840: p_init_msg_list => FND_API.G_TRUE,

3836: l_msg_count NUMBER;
3837: l_msg_data VARCHAR2(2000);
3838: BEGIN
3839: get_person_updated(
3840: p_init_msg_list => FND_API.G_TRUE,
3841: p_event_id => p_event_id,
3842: p_person_id => p_person_id,
3843: x_person_obj => x_person_obj,
3844: x_return_status => x_return_status,

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

3852: END get_person_updated;
3853:
3854: -- get TCA identifiers for create event
3855: PROCEDURE get_ids_persons_created (
3856: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3857: p_event_id IN NUMBER,
3858: x_person_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
3859: x_return_status OUT NOCOPY VARCHAR2,
3860: x_msg_count OUT NOCOPY NUMBER,

Line 3868: x_return_status := FND_API.G_RET_STS_SUCCESS;

3864: l_debug_prefix VARCHAR2(30) := '';
3865:
3866: begin
3867: -- initialize API return status to success.
3868: x_return_status := FND_API.G_RET_STS_SUCCESS;
3869:
3870: -- Initialize message list if p_init_msg_list is set to TRUE
3871: IF FND_API.to_Boolean(p_init_msg_list) THEN
3872: FND_MSG_PUB.initialize;

Line 3871: IF FND_API.to_Boolean(p_init_msg_list) THEN

3867: -- initialize API return status to success.
3868: x_return_status := FND_API.G_RET_STS_SUCCESS;
3869:
3870: -- Initialize message list if p_init_msg_list is set to TRUE
3871: IF FND_API.to_Boolean(p_init_msg_list) THEN
3872: FND_MSG_PUB.initialize;
3873: END IF;
3874:
3875:

Line 3890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3886: p_event_type => 'C',
3887: p_bo_code => 'PERSON',
3888: x_return_status => x_return_status);
3889:
3890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893:
3894: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 3891: RAISE FND_API.G_EXC_ERROR;

3887: p_bo_code => 'PERSON',
3888: x_return_status => x_return_status);
3889:
3890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893:
3894: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
3895: p_init_msg_list => fnd_api.g_false,

Line 3895: p_init_msg_list => fnd_api.g_false,

3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893:
3894: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
3895: p_init_msg_list => fnd_api.g_false,
3896: p_event_id => p_event_id,
3897: x_obj_root_ids => x_person_ids,
3898: x_return_status => x_return_status,
3899: x_msg_count => x_msg_count,

Line 3902: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3898: x_return_status => x_return_status,
3899: x_msg_count => x_msg_count,
3900: x_msg_data => x_msg_data);
3901:
3902: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;
3905:
3906:

Line 3903: RAISE FND_API.G_EXC_ERROR;

3899: x_msg_count => x_msg_count,
3900: x_msg_data => x_msg_data);
3901:
3902: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;
3905:
3906:
3907: -- Debug info.

Line 3925: WHEN fnd_api.g_exc_error THEN

3921:
3922:
3923: EXCEPTION
3924:
3925: WHEN fnd_api.g_exc_error THEN
3926: x_return_status := fnd_api.g_ret_sts_error;
3927:
3928: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3929: p_count => x_msg_count,

Line 3926: x_return_status := fnd_api.g_ret_sts_error;

3922:
3923: EXCEPTION
3924:
3925: WHEN fnd_api.g_exc_error THEN
3926: x_return_status := fnd_api.g_ret_sts_error;
3927:
3928: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3929: p_count => x_msg_count,
3930: p_data => x_msg_data);

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

3924:
3925: WHEN fnd_api.g_exc_error THEN
3926: x_return_status := fnd_api.g_ret_sts_error;
3927:
3928: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3929: p_count => x_msg_count,
3930: p_data => x_msg_data);
3931:
3932: -- Debug info.

Line 3944: WHEN fnd_api.g_exc_unexpected_error THEN

3940: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3941: p_prefix=>l_debug_prefix,
3942: p_msg_level=>fnd_log.level_procedure);
3943: END IF;
3944: WHEN fnd_api.g_exc_unexpected_error THEN
3945: x_return_status := fnd_api.g_ret_sts_unexp_error;
3946:
3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3948: p_count => x_msg_count,

Line 3945: x_return_status := fnd_api.g_ret_sts_unexp_error;

3941: p_prefix=>l_debug_prefix,
3942: p_msg_level=>fnd_log.level_procedure);
3943: END IF;
3944: WHEN fnd_api.g_exc_unexpected_error THEN
3945: x_return_status := fnd_api.g_ret_sts_unexp_error;
3946:
3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3948: p_count => x_msg_count,
3949: p_data => x_msg_data);

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

3943: END IF;
3944: WHEN fnd_api.g_exc_unexpected_error THEN
3945: x_return_status := fnd_api.g_ret_sts_unexp_error;
3946:
3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3948: p_count => x_msg_count,
3949: p_data => x_msg_data);
3950:
3951: -- Debug info.

Line 3964: x_return_status := fnd_api.g_ret_sts_unexp_error;

3960: p_prefix=>l_debug_prefix,
3961: p_msg_level=>fnd_log.level_procedure);
3962: END IF;
3963: WHEN OTHERS THEN
3964: x_return_status := fnd_api.g_ret_sts_unexp_error;
3965:
3966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3967: fnd_message.set_token('ERROR' ,SQLERRM);
3968: fnd_msg_pub.add;

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

3966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3967: fnd_message.set_token('ERROR' ,SQLERRM);
3968: fnd_msg_pub.add;
3969:
3970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3971: p_count => x_msg_count,
3972: p_data => x_msg_data);
3973:
3974: -- Debug info.

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

3988:
3989:
3990: -- get TCA identifiers for update event
3991: PROCEDURE get_ids_persons_updated (
3992: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3993: p_event_id IN NUMBER,
3994: x_person_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
3995: x_return_status OUT NOCOPY VARCHAR2,
3996: x_msg_count OUT NOCOPY NUMBER,

Line 4003: x_return_status := FND_API.G_RET_STS_SUCCESS;

3999: l_debug_prefix VARCHAR2(30) := '';
4000:
4001: begin
4002: -- initialize API return status to success.
4003: x_return_status := FND_API.G_RET_STS_SUCCESS;
4004:
4005: -- Initialize message list if p_init_msg_list is set to TRUE
4006: IF FND_API.to_Boolean(p_init_msg_list) THEN
4007: FND_MSG_PUB.initialize;

Line 4006: IF FND_API.to_Boolean(p_init_msg_list) THEN

4002: -- initialize API return status to success.
4003: x_return_status := FND_API.G_RET_STS_SUCCESS;
4004:
4005: -- Initialize message list if p_init_msg_list is set to TRUE
4006: IF FND_API.to_Boolean(p_init_msg_list) THEN
4007: FND_MSG_PUB.initialize;
4008: END IF;
4009:
4010:

Line 4024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4020: p_event_type => 'U',
4021: p_bo_code => 'PERSON',
4022: x_return_status => x_return_status);
4023:
4024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4025: RAISE FND_API.G_EXC_ERROR;
4026: END IF;
4027:
4028: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 4025: RAISE FND_API.G_EXC_ERROR;

4021: p_bo_code => 'PERSON',
4022: x_return_status => x_return_status);
4023:
4024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4025: RAISE FND_API.G_EXC_ERROR;
4026: END IF;
4027:
4028: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
4029: p_init_msg_list => fnd_api.g_false,

Line 4029: p_init_msg_list => fnd_api.g_false,

4025: RAISE FND_API.G_EXC_ERROR;
4026: END IF;
4027:
4028: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
4029: p_init_msg_list => fnd_api.g_false,
4030: p_event_id => p_event_id,
4031: x_obj_root_ids => x_person_ids,
4032: x_return_status => x_return_status,
4033: x_msg_count => x_msg_count,

Line 4036: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4032: x_return_status => x_return_status,
4033: x_msg_count => x_msg_count,
4034: x_msg_data => x_msg_data);
4035:
4036: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: END IF;
4039:
4040:

Line 4037: RAISE FND_API.G_EXC_ERROR;

4033: x_msg_count => x_msg_count,
4034: x_msg_data => x_msg_data);
4035:
4036: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: END IF;
4039:
4040:
4041: -- Debug info.

Line 4059: WHEN fnd_api.g_exc_error THEN

4055:
4056:
4057: EXCEPTION
4058:
4059: WHEN fnd_api.g_exc_error THEN
4060: x_return_status := fnd_api.g_ret_sts_error;
4061:
4062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4063: p_count => x_msg_count,

Line 4060: x_return_status := fnd_api.g_ret_sts_error;

4056:
4057: EXCEPTION
4058:
4059: WHEN fnd_api.g_exc_error THEN
4060: x_return_status := fnd_api.g_ret_sts_error;
4061:
4062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4063: p_count => x_msg_count,
4064: p_data => x_msg_data);

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

4058:
4059: WHEN fnd_api.g_exc_error THEN
4060: x_return_status := fnd_api.g_ret_sts_error;
4061:
4062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4063: p_count => x_msg_count,
4064: p_data => x_msg_data);
4065:
4066: -- Debug info.

Line 4078: WHEN fnd_api.g_exc_unexpected_error THEN

4074: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4075: p_prefix=>l_debug_prefix,
4076: p_msg_level=>fnd_log.level_procedure);
4077: END IF;
4078: WHEN fnd_api.g_exc_unexpected_error THEN
4079: x_return_status := fnd_api.g_ret_sts_unexp_error;
4080:
4081: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4082: p_count => x_msg_count,

Line 4079: x_return_status := fnd_api.g_ret_sts_unexp_error;

4075: p_prefix=>l_debug_prefix,
4076: p_msg_level=>fnd_log.level_procedure);
4077: END IF;
4078: WHEN fnd_api.g_exc_unexpected_error THEN
4079: x_return_status := fnd_api.g_ret_sts_unexp_error;
4080:
4081: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4082: p_count => x_msg_count,
4083: p_data => x_msg_data);

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

4077: END IF;
4078: WHEN fnd_api.g_exc_unexpected_error THEN
4079: x_return_status := fnd_api.g_ret_sts_unexp_error;
4080:
4081: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4082: p_count => x_msg_count,
4083: p_data => x_msg_data);
4084:
4085: -- Debug info.

Line 4098: x_return_status := fnd_api.g_ret_sts_unexp_error;

4094: p_prefix=>l_debug_prefix,
4095: p_msg_level=>fnd_log.level_procedure);
4096: END IF;
4097: WHEN OTHERS THEN
4098: x_return_status := fnd_api.g_ret_sts_unexp_error;
4099:
4100: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4101: fnd_message.set_token('ERROR' ,SQLERRM);
4102: fnd_msg_pub.add;

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

4100: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4101: fnd_message.set_token('ERROR' ,SQLERRM);
4102: fnd_msg_pub.add;
4103:
4104: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4105: p_count => x_msg_count,
4106: p_data => x_msg_data);
4107:
4108: -- Debug info.