[Home] [Help]
105: AND (p_party_query_rec.instance_id = FND_API.G_MISS_NUM)
106: AND (p_party_query_rec.party_id = FND_API.G_MISS_NUM)
107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
108:
109: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
151: -- contruct from the history if the p_time_stamp
152: -- is < than sysdate
153: csi_party_relationships_pvt.Construct_pty_from_hist(x_party_header_tbl, p_time_stamp);
154: ELSE
155: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159: END IF;
454: --
455: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
456: --
457: IF l_internal_party_id IS NULL THEN
458: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
459: FND_MSG_PUB.ADD;
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462: -- Check if the table is not empty and then loop
478: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
479: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
480: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
481: ) THEN
482: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
483: FND_MSG_PUB.Add;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
493: END IF;
494:
495: -- Raise an exception if external parties don't have an owner account
496: IF NOT l_party_has_correct_acct THEN
497: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
494:
495: -- Raise an exception if external parties don't have an owner account
496: IF NOT l_party_has_correct_acct THEN
497: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502:
562: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
563: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
564: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
565: ) THEN
566: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570:
946: --
947: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
948: --
949: IF l_internal_party_id IS NULL THEN
950: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
951: FND_MSG_PUB.ADD;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: -- Check if the table is not empty
985: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
986: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
987: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
988: ) THEN
989: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
990: FND_MSG_PUB.Add;
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
1011: END IF; -- End of Transfer of Ownership check
1012:
1013: -- Raise an exception if external parties don't have an owner account
1014: IF NOT l_party_has_correct_acct THEN
1015: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
1016: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1012:
1013: -- Raise an exception if external parties don't have an owner account
1014: IF NOT l_party_has_correct_acct THEN
1015: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
1016: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1544: x_msg_data => x_msg_data
1545: );
1546: --
1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
1549: FND_MSG_PUB.Add;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;
1552: END IF;
2179: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2180: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2182:
2183: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2184: FND_MSG_PUB.ADD;
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2222: IF p_time_stamp <= sysdate THEN
2223: -- Contruct from the history if p_time_stamp is less than sysdate
2224: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2225: ELSE
2226: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
2227: FND_MSG_PUB.ADD;
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230: END IF;
2682: x_msg_data => x_msg_data
2683: );
2684: --
2685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2686: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
2687: FND_MSG_PUB.Add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690: --