68: END IF;
69:
70: -- Initialize message list if requested
71: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Initialize API status to success
76: x_return_status := OKL_API.G_RET_STS_SUCCESS;
120:
121: /*** End API body ******************************************************/
122:
123: -- Get message count and if count is 1, get message info
124: FND_MSG_PUB.Count_And_Get
125: (p_count => x_msg_count,
126: p_data => x_msg_data);
127:
128: EXCEPTION
128: EXCEPTION
129: WHEN OKL_API.G_EXCEPTION_ERROR THEN
130: ROLLBACK TO calculate_unit_cost_pvt;
131: x_return_status := OKL_API.G_RET_STS_ERROR;
132: FND_MSG_PUB.Count_And_Get
133: (p_count => x_msg_count,
134: p_data => x_msg_data);
135:
136: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
135:
136: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
137: ROLLBACK TO calculate_unit_cost_pvt;
138: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
139: FND_MSG_PUB.Count_And_Get
140: (p_count => x_msg_count,
141: p_data => x_msg_data);
142:
143: WHEN OTHERS THEN
148: p_token1 => G_SQLCODE_TOKEN,
149: p_token1_value => SQLCODE,
150: p_token2 => G_SQLERRM_TOKEN,
151: p_token2_value => SQLERRM);
152: FND_MSG_PUB.Count_And_Get
153: (p_count => x_msg_count,
154: p_data => x_msg_data);
155: END calculate_unit_cost;
156:
837: END IF;
838:
839: -- Initialize message list if requested
840: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
841: FND_MSG_PUB.initialize;
842: END IF;
843:
844: -- Initialize API status to success
845: x_return_status := OKL_API.G_RET_STS_SUCCESS;
921:
922: /*** End API body ******************************************************/
923:
924: -- Get message count and if count is 1, get message info
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data);
928:
929: EXCEPTION
929: EXCEPTION
930: WHEN OKL_API.G_EXCEPTION_ERROR THEN
931: ROLLBACK TO create_split_asset_comp_pvt;
932: x_return_status := OKL_API.G_RET_STS_ERROR;
933: FND_MSG_PUB.Count_And_Get
934: (p_count => x_msg_count,
935: p_data => x_msg_data);
936:
937: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
936:
937: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
938: ROLLBACK TO create_split_asset_comp_pvt;
939: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
940: FND_MSG_PUB.Count_And_Get
941: (p_count => x_msg_count,
942: p_data => x_msg_data);
943:
944: WHEN OTHERS THEN
949: p_token1 => G_SQLCODE_TOKEN,
950: p_token1_value => SQLCODE,
951: p_token2 => G_SQLERRM_TOKEN,
952: p_token2_value => SQLERRM);
953: FND_MSG_PUB.Count_And_Get
954: (p_count => x_msg_count,
955: p_data => x_msg_data);
956:
957: END create_split_asset_comp;
990: END IF;
991:
992: -- Initialize message list if requested
993: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
994: FND_MSG_PUB.initialize;
995: END IF;
996:
997: -- Initialize API status to success
998: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1057:
1058: /*** End API body ******************************************************/
1059:
1060: -- Get message count and if count is 1, get message info
1061: FND_MSG_PUB.Count_And_Get
1062: (p_count => x_msg_count,
1063: p_data => x_msg_data);
1064:
1065: EXCEPTION
1065: EXCEPTION
1066: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1067: ROLLBACK TO update_split_asset_comp_pvt;
1068: x_return_status := OKL_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get
1070: (p_count => x_msg_count,
1071: p_data => x_msg_data);
1072:
1073: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1072:
1073: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1074: ROLLBACK TO update_split_asset_comp_pvt;
1075: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1076: FND_MSG_PUB.Count_And_Get
1077: (p_count => x_msg_count,
1078: p_data => x_msg_data);
1079:
1080: WHEN OTHERS THEN
1085: p_token1 => G_SQLCODE_TOKEN,
1086: p_token1_value => SQLCODE,
1087: p_token2 => G_SQLERRM_TOKEN,
1088: p_token2_value => SQLERRM);
1089: FND_MSG_PUB.Count_And_Get
1090: (p_count => x_msg_count,
1091: p_data => x_msg_data);
1092:
1093: END update_split_asset_comp;
1120: END IF;
1121:
1122: -- Initialize message list if requested
1123: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1124: FND_MSG_PUB.initialize;
1125: END IF;
1126:
1127: -- Initialize API status to success
1128: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1144:
1145: /*** End API body ******************************************************/
1146:
1147: -- Get message count and if count is 1, get message info
1148: FND_MSG_PUB.Count_And_Get
1149: (p_count => x_msg_count,
1150: p_data => x_msg_data);
1151:
1152: EXCEPTION
1152: EXCEPTION
1153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1154: ROLLBACK TO delete_split_asset_comp_pvt;
1155: x_return_status := OKL_API.G_RET_STS_ERROR;
1156: FND_MSG_PUB.Count_And_Get
1157: (p_count => x_msg_count,
1158: p_data => x_msg_data);
1159:
1160: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1159:
1160: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1161: ROLLBACK TO delete_split_asset_comp_pvt;
1162: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1163: FND_MSG_PUB.Count_And_Get
1164: (p_count => x_msg_count,
1165: p_data => x_msg_data);
1166:
1167: WHEN OTHERS THEN
1172: p_token1 => G_SQLCODE_TOKEN,
1173: p_token1_value => SQLCODE,
1174: p_token2 => G_SQLERRM_TOKEN,
1175: p_token2_value => SQLERRM);
1176: FND_MSG_PUB.Count_And_Get
1177: (p_count => x_msg_count,
1178: p_data => x_msg_data);
1179:
1180: END delete_split_asset_comp;
1333: END IF;
1334:
1335: -- Initialize message list if requested
1336: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1337: FND_MSG_PUB.initialize;
1338: END IF;
1339:
1340: -- Initialize API status to success
1341: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1422: --
1423: /*** End API body ******************************************************/
1424:
1425: -- Get message count and if count is 1, get message info
1426: FND_MSG_PUB.Count_And_Get
1427: (p_count => x_msg_count,
1428: p_data => x_msg_data);
1429:
1430: EXCEPTION
1430: EXCEPTION
1431: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1432: ROLLBACK TO process_split_asset_comp_pvt;
1433: x_return_status := OKL_API.G_RET_STS_ERROR;
1434: FND_MSG_PUB.Count_And_Get
1435: (p_count => x_msg_count,
1436: p_data => x_msg_data);
1437:
1438: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1437:
1438: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1439: ROLLBACK TO process_split_asset_comp_pvt;
1440: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1441: FND_MSG_PUB.Count_And_Get
1442: (p_count => x_msg_count,
1443: p_data => x_msg_data);
1444:
1445: WHEN OTHERS THEN
1450: p_token1 => G_SQLCODE_TOKEN,
1451: p_token1_value => SQLCODE,
1452: p_token2 => G_SQLERRM_TOKEN,
1453: p_token2_value => SQLERRM);
1454: FND_MSG_PUB.Count_And_Get
1455: (p_count => x_msg_count,
1456: p_data => x_msg_data);
1457:
1458: END process_split_asset_comp;