[Home] [Help]
545: EXCEPTION
546: WHEN fnd_api.g_exc_error THEN
547: ROLLBACK TO create_relationships_pvt;
548: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
549: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
550: FND_MSG_PUB.ADD;
551:
552: x_return_status := fnd_api.g_ret_sts_error;
553:
569: END IF;
570: WHEN fnd_api.g_exc_unexpected_error THEN
571: ROLLBACK TO create_relationships_pvt;
572: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
573: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
574: FND_MSG_PUB.ADD;
575:
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577:
594:
595: WHEN OTHERS THEN
596: ROLLBACK TO create_relationships_pvt;
597: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
598: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
599: FND_MSG_PUB.ADD;
600:
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602:
671: /*
672: CURSOR get_rel_party_ovn(l_subject_id NUMBER, l_object_id NUMBER,
673: l_relationship_type VARCHAR2, l_relationship_code VARCHAR2) IS
674: SELECT p.object_version_number
675: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
676: WHERE rel.subject_id = l_subject_id
677: AND rel.object_id = l_object_id
678: AND rel.relationship_type = l_relationship_type
679: AND rel.relationship_code = l_relationship_code
796: EXCEPTION
797: WHEN fnd_api.g_exc_error THEN
798: ROLLBACK TO save_relationships_pvt;
799: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
800: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
801: FND_MSG_PUB.ADD;
802:
803: x_return_status := fnd_api.g_ret_sts_error;
804:
820: END IF;
821: WHEN fnd_api.g_exc_unexpected_error THEN
822: ROLLBACK TO save_relationships_pvt;
823: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
824: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
825: FND_MSG_PUB.ADD;
826:
827: x_return_status := fnd_api.g_ret_sts_unexp_error;
828:
845:
846: WHEN OTHERS THEN
847: ROLLBACK TO save_relationships_pvt;
848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
849: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
850: FND_MSG_PUB.ADD;
851:
852: x_return_status := fnd_api.g_ret_sts_unexp_error;
853:
974: EXCEPTION
975: WHEN fnd_api.g_exc_error THEN
976: ROLLBACK TO create_relatobj_pvt;
977: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
978: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
979: FND_MSG_PUB.ADD;
980:
981: x_return_status := fnd_api.g_ret_sts_error;
982:
998: END IF;
999: WHEN fnd_api.g_exc_unexpected_error THEN
1000: ROLLBACK TO create_relatobj_pvt;
1001: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1002: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1003: FND_MSG_PUB.ADD;
1004:
1005: x_return_status := fnd_api.g_ret_sts_unexp_error;
1006:
1023:
1024: WHEN OTHERS THEN
1025: ROLLBACK TO create_relatobj_pvt;
1026: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1027: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1028: FND_MSG_PUB.ADD;
1029:
1030: x_return_status := fnd_api.g_ret_sts_unexp_error;
1031:
1072: l_object_id NUMBER;
1073:
1074: CURSOR get_rel_by_id(l_rel_id NUMBER) IS
1075: SELECT relationship_id, nvl(rel.object_version_number,1), nvl(p.object_version_number,1)
1076: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
1077: WHERE rel.relationship_id = l_rel_id
1078: AND rel.party_id = p.party_id
1079: AND rel.status in ('A','I')
1080: AND rownum = 1;
1158: EXCEPTION
1159: WHEN fnd_api.g_exc_error THEN
1160: ROLLBACK TO update_relatobj_pvt;
1161: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1162: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1163: FND_MSG_PUB.ADD;
1164:
1165: x_return_status := fnd_api.g_ret_sts_error;
1166:
1182: END IF;
1183: WHEN fnd_api.g_exc_unexpected_error THEN
1184: ROLLBACK TO update_relatobj_pvt;
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1186: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1187: FND_MSG_PUB.ADD;
1188:
1189: x_return_status := fnd_api.g_ret_sts_unexp_error;
1190:
1207:
1208: WHEN OTHERS THEN
1209: ROLLBACK TO update_relatobj_pvt;
1210: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1211: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1212: FND_MSG_PUB.ADD;
1213:
1214: x_return_status := fnd_api.g_ret_sts_unexp_error;
1215:
1257: l_created_by_module VARCHAR2(30);
1258:
1259: CURSOR get_rel_by_id(l_rel_id NUMBER) IS
1260: SELECT relationship_id, nvl(rel.object_version_number,1), nvl(p.object_version_number,1)
1261: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
1262: WHERE rel.relationship_id = l_rel_id
1263: AND rel.party_id = p.party_id
1264: AND rel.status in ('A','I')
1265: AND rownum = 1;
1368: EXCEPTION
1369: WHEN fnd_api.g_exc_error THEN
1370: ROLLBACK TO save_relatobj_pvt;
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1373: FND_MSG_PUB.ADD;
1374:
1375: x_return_status := fnd_api.g_ret_sts_error;
1376:
1392: END IF;
1393: WHEN fnd_api.g_exc_unexpected_error THEN
1394: ROLLBACK TO save_relatobj_pvt;
1395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1396: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1397: FND_MSG_PUB.ADD;
1398:
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1417:
1418: WHEN OTHERS THEN
1419: ROLLBACK TO save_relatobj_pvt;
1420: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1421: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1422: FND_MSG_PUB.ADD;
1423:
1424: x_return_status := fnd_api.g_ret_sts_unexp_error;
1425:
1554: FROM HZ_ORIG_SYS_REFERENCES OSR
1555: WHERE OSR.OWNER_TABLE_ID = REL.SUBJECT_ID
1556: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
1557: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
1558: FROM HZ_RELATIONSHIPS REL
1559: WHERE RELATIONSHIP_ID = l_relationship_id
1560: AND DIRECTIONAL_FLAG = 'F';
1561:
1562: BEGIN