[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:
953: --
954: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
955: --
956: IF l_internal_party_id IS NULL THEN
957: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
958: FND_MSG_PUB.ADD;
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961: -- Check if the table is not empty
992: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
993: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
994: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
995: ) THEN
996: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
997: FND_MSG_PUB.Add;
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000:
1018: END IF; -- End of Transfer of Ownership check
1019:
1020: -- Raise an exception if external parties don't have an owner account
1021: IF NOT l_party_has_correct_acct THEN
1022: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
1023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
1024: FND_MSG_PUB.ADD;
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1019:
1020: -- Raise an exception if external parties don't have an owner account
1021: IF NOT l_party_has_correct_acct THEN
1022: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
1023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
1024: FND_MSG_PUB.ADD;
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1027:
1577: x_msg_data => x_msg_data
1578: );
1579: --
1580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1581: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
1582: FND_MSG_PUB.Add;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;
1585: END IF;
2228: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2229: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2230: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2231:
2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: END IF;
2236:
2271: IF p_time_stamp <= sysdate THEN
2272: -- Contruct from the history if p_time_stamp is less than sysdate
2273: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2274: ELSE
2275: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
2276: FND_MSG_PUB.ADD;
2277: RAISE FND_API.G_EXC_ERROR;
2278: END IF;
2279: END IF;
2731: x_msg_data => x_msg_data
2732: );
2733: --
2734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2735: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
2736: FND_MSG_PUB.Add;
2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;
2739: --