157: ,l_return_status
158: ,l_msg_data);
159:
160: if l_return_status <> 'S' then
161: raise FND_API.G_EXC_ERROR;
162: end if;
163:
164:
165: if rec_budget_details.personnel_attached_flag = 'N' then
172: ,l_rate_type_id_inf
173: ,l_return_status
174: ,l_msg_data);
175: if l_return_status <> 'S' then
176: raise FND_API.G_EXC_ERROR;
177: end if;
178: end if;
179: BEGIN
180: select apply_rate_flag
203: ,l_msg_data
204: ,l_msg_count);
205:
206: if l_return_status <> 'S' then
207: raise FND_API.G_EXC_ERROR;
208: end if;
209:
210: if l_apply_rate_flag_oh = 'N' then
211: l_oh_value_ov := 0;
225: ,l_return_status
226: ,l_msg_data
227: ,l_msg_count);
228: if l_return_status <> 'S' then
229: raise FND_API.G_EXC_ERROR;
230: end if;
231: end if;
232:
233:
262: ,'E'
263: ,l_rate_class_id_eb,l_rate_type_id_eb,l_return_status, l_msg_data);
264:
265: if l_return_status <> 'S' then
266: raise FND_API.G_EXC_ERROR;
267: end if;
268: for rec_budget_personnel in c_budget_personnel
269: LOOP
270: BEGIN
328: ,l_return_status
329: ,l_msg_data
330: ,l_msg_count);
331: if l_return_status <> 'S' then
332: raise FND_API.G_EXC_ERROR;
333: end if;
334:
335: l_inflated_salary := rec_budget_personnel.percent_charged/100 * l_inflated_salary;
336: l_inflated_salary_ov := rec_budget_personnel.percent_charged/100 * l_inflated_salary_ov;
368: ,l_return_status
369: ,l_msg_data
370: ,l_msg_count);
371: if l_return_status <> 'S' then
372: raise FND_API.G_EXC_ERROR;
373: end if;
374:
375: IGW_OVERHEAD_CAL.calc_oh_eb (p_proposal_id
376: ,p_version_id
390: ,l_return_status
391: ,l_msg_data
392: ,l_msg_count);
393: if l_return_status <> 'S' then
394: raise FND_API.G_EXC_ERROR;
395: end if;
396:
397:
398: if l_apply_rate_flag_oh = 'N' then
594: and version_id = p_version_id;
595:
596: x_return_status := 'S';
597: EXCEPTION
598: when FND_API.G_EXC_ERROR then
599: x_return_status := l_return_status;
600: x_msg_data := l_msg_data;
601: fnd_msg_pub.count_and_get(p_count => x_msg_count,
602: p_data => x_msg_data);
1145:
1146: end if;
1147: x_return_status := 'S';
1148: EXCEPTION
1149: when FND_API.G_EXC_ERROR then
1150: x_return_status := l_return_status;
1151: x_msg_data := l_msg_data;
1152: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1153: p_data => x_msg_data);
1371: ,l_return_status
1372: ,l_msg_data);
1373:
1374: if l_return_status <> 'S' then
1375: raise FND_API.G_EXC_ERROR;
1376: end if;
1377:
1378:
1379: if rec_budget_details.personnel_attached_flag = 'N' then
1386: ,l_rate_type_id_inf
1387: ,l_return_status
1388: ,l_msg_data);
1389: if l_return_status <> 'S' then
1390: raise FND_API.G_EXC_ERROR;
1391: end if;
1392: end if;
1393: BEGIN
1394: select apply_rate_flag, calculated_cost, calculated_cost_sharing
1419: ,l_msg_data
1420: ,l_msg_count);
1421:
1422: if l_return_status <> 'S' then
1423: raise FND_API.G_EXC_ERROR;
1424: end if;
1425:
1426: if l_apply_rate_flag_oh = 'N' then
1427: l_oh_value_ov := 0;
1443: ,l_return_status
1444: ,l_msg_data
1445: ,l_msg_count);
1446: if l_return_status <> 'S' then
1447: raise FND_API.G_EXC_ERROR;
1448: end if;
1449: end if;
1450: end if;
1451:
1499: ,'E'
1500: ,l_rate_class_id_eb,l_rate_type_id_eb,l_return_status, l_msg_data);
1501:
1502: if l_return_status <> 'S' then
1503: raise FND_API.G_EXC_ERROR;
1504: end if;
1505: for rec_budget_personnel in c_budget_personnel
1506: LOOP
1507: BEGIN
1566: ,l_return_status
1567: ,l_msg_data
1568: ,l_msg_count);
1569: if l_return_status <> 'S' then
1570: raise FND_API.G_EXC_ERROR;
1571: end if;
1572:
1573: l_inflated_salary := rec_budget_personnel.percent_charged/100 * l_inflated_salary;
1574:
1612: ,l_return_status
1613: ,l_msg_data
1614: ,l_msg_count);
1615: if l_return_status <> 'S' then
1616: raise FND_API.G_EXC_ERROR;
1617: end if;
1618:
1619: IGW_OVERHEAD_CAL.calc_oh_eb (p_proposal_id
1620: ,p_version_id
1634: ,l_return_status
1635: ,l_msg_data
1636: ,l_msg_count);
1637: if l_return_status <> 'S' then
1638: raise FND_API.G_EXC_ERROR;
1639: end if;
1640:
1641:
1642: if l_apply_rate_flag_oh = 'N' then
1883: and version_id = p_version_id;
1884:
1885: x_return_status := 'S';
1886: EXCEPTION
1887: when FND_API.G_EXC_ERROR then
1888: x_return_status := l_return_status;
1889: x_msg_data := l_msg_data;
1890: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1891: p_data => x_msg_data);