DBA Data[Home] [Help]

APPS.IGW_GENERATE_PERIODS dependencies on FND_API

Line 302: RAISE FND_API.G_EXC_ERROR;

298: if l_value is not null then
299: fnd_message.set_name('IGW', 'IGW_CANNOT_GENERATE_PERIODS');
300: fnd_msg_pub.add;
301: l_return_status := 'E';
302: RAISE FND_API.G_EXC_ERROR;
303: end if;
304: exception
305: when no_data_found then null;
306: end;

Line 331: raise FND_API.G_EXC_ERROR;

327: ,l_return_status
328: ,l_msg_data);
329:
330: if l_return_status <> 'S' then
331: raise FND_API.G_EXC_ERROR;
332: end if;
333:
334: if rec_budget_details.personnel_attached_flag = 'N' then
335: BEGIN

Line 352: raise FND_API.G_EXC_ERROR;

348: ,l_rate_type_id_inf
349: ,l_return_status
350: ,l_msg_data);
351: if l_return_status <> 'S' then
352: raise FND_API.G_EXC_ERROR;
353: end if;
354: end if;
355: l_input_amount := rec_budget_details.line_item_cost;
356: l_budget_period_id := rec_budget_details.budget_period_id;

Line 377: RAISE FND_API.G_EXC_ERROR;

373: l_msg_data := 'IGW_PERIOD_NOT_CONSECUTIVE';
374: l_return_status := 'E';
375: fnd_message.set_name('IGW', 'IGW_PERIOD_NOT_CONSECUTIVE');
376: fnd_msg_pub.add;
377: RAISE FND_API.G_EXC_ERROR;
378: end;
379:
380:
381: if i = (l_no_of_periods - 1) then

Line 394: RAISE FND_API.G_EXC_ERROR;

390: l_msg_data := 'IGW_PERIOD_NOT_CONSECUTIVE';
391: l_return_status := 'E';
392: fnd_message.set_name('IGW', 'IGW_PERIOD_NOT_CONSECUTIVE');
393: fnd_msg_pub.add;
394: RAISE FND_API.G_EXC_ERROR;
395: end;
396: end if;
397:
398:

Line 416: raise FND_API.G_EXC_ERROR;

412: ,l_msg_data
413: ,l_msg_count);
414:
415: if l_return_status <> 'S' then
416: raise FND_API.G_EXC_ERROR;
417: end if;
418: else
419: l_base_amount := rec_budget_details.line_item_cost;
420: end if;

Line 446: raise FND_API.G_EXC_ERROR;

442: ,l_msg_data
443: ,l_msg_count);
444:
445: if l_return_status <> 'S' then
446: raise FND_API.G_EXC_ERROR;
447: end if;
448: end if;
449:
450: /* if oh_setup_rates is not applied then don't calculate oh */

Line 473: raise FND_API.G_EXC_ERROR;

469: ,l_return_status
470: ,l_msg_data
471: ,l_msg_count);
472: if l_return_status <> 'S' then
473: raise FND_API.G_EXC_ERROR;
474: end if;
475: end if;
476: end if;
477:

Line 540: raise FND_API.G_EXC_ERROR;

536: ,l_return_status
537: , l_msg_data);
538:
539: if l_return_status <> 'S' then
540: raise FND_API.G_EXC_ERROR;
541: end if;
542:
543: select max(end_date), max(start_date)
544: into l_max_budget_end_date, l_max_budget_start_date

Line 583: RAISE FND_API.G_EXC_ERROR;

579: l_msg_data := 'IGW_PERIOD_NOT_CONSECUTIVE';
580: l_return_status := 'E';
581: fnd_message.set_name('IGW', 'IGW_PERIOD_NOT_CONSECUTIVE');
582: fnd_msg_pub.add;
583: RAISE FND_API.G_EXC_ERROR;
584: end;
585:
586: if i = (l_no_of_periods - 1) then
587: l_budget_end_date := l_max_budget_end_date;

Line 752: raise FND_API.G_EXC_ERROR;

748: ,l_return_status
749: ,l_msg_data
750: ,l_msg_count);
751: if l_return_status <> 'S' then
752: raise FND_API.G_EXC_ERROR;
753: end if;
754: l_inflated_salary := rec_budget_personnel.percent_charged/100 * l_inflated_salary;
755: l_inflated_salary_ov := rec_budget_personnel.percent_charged/100 * l_inflated_salary_ov;
756:

Line 805: raise FND_API.G_EXC_ERROR;

801: ,l_return_status
802: ,l_msg_data
803: ,l_msg_count);
804: if l_return_status <> 'S' then
805: raise FND_API.G_EXC_ERROR;
806: end if;
807: end if;
808:
809: /* No need to calculate eb and oh if setup rates flags are equal to N */

Line 832: raise FND_API.G_EXC_ERROR;

828: ,l_return_status
829: ,l_msg_data
830: ,l_msg_count);
831: if l_return_status <> 'S' then
832: raise FND_API.G_EXC_ERROR;
833: end if;
834: end if;
835:
836: if l_apply_rate_flag_oh = 'N' then

Line 1063: RAISE FND_API.G_EXC_ERROR;

1059: l_return_status := 'S';
1060: fnd_message.set_name('IGW', 'IGW_BUDGET_PERIOD_NOT_EQUAL');
1061: fnd_msg_pub.add;
1062: --raised the error volutarily to get the message count
1063: RAISE FND_API.G_EXC_ERROR;
1064: end if;
1065:
1066: EXCEPTION
1067: when FND_API.G_EXC_ERROR then

Line 1067: when FND_API.G_EXC_ERROR then

1063: RAISE FND_API.G_EXC_ERROR;
1064: end if;
1065:
1066: EXCEPTION
1067: when FND_API.G_EXC_ERROR then
1068: x_return_status := l_return_status;
1069: x_msg_data := l_msg_data;
1070: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1071: p_data => x_msg_data);

Line 1212: raise FND_API.G_EXC_ERROR;

1208: ,l_return_status
1209: ,l_msg_data);
1210:
1211: if l_return_status <> 'S' then
1212: raise FND_API.G_EXC_ERROR;
1213: end if;
1214:
1215:
1216: if rec_budget_details.personnel_attached_flag = 'N' then

Line 1227: raise FND_API.G_EXC_ERROR;

1223: ,l_rate_type_id_inf
1224: ,l_return_status
1225: ,l_msg_data);
1226: if l_return_status <> 'S' then
1227: raise FND_API.G_EXC_ERROR;
1228: end if;
1229: end if;
1230: BEGIN
1231: select apply_rate_flag

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: l_msg_data := 'IGW_PERIOD_NOT_CONSECUTIVE';
1273: l_return_status := 'E';
1274: fnd_message.set_name('IGW', 'IGW_PERIOD_NOT_CONSECUTIVE');
1275: fnd_msg_pub.add;
1276: RAISE FND_API.G_EXC_ERROR;
1277: end;
1278:
1279:
1280:

Line 1298: raise FND_API.G_EXC_ERROR;

1294: ,l_msg_data
1295: ,l_msg_count);
1296:
1297: if l_return_status <> 'S' then
1298: raise FND_API.G_EXC_ERROR;
1299: end if;
1300: else
1301: l_base_amount := rec_budget_details.line_item_cost;
1302: end if;

Line 1322: raise FND_API.G_EXC_ERROR;

1318: ,l_msg_data
1319: ,l_msg_count);
1320:
1321: if l_return_status <> 'S' then
1322: raise FND_API.G_EXC_ERROR;
1323: end if;
1324:
1325: if l_apply_rate_flag_oh = 'N' then
1326: l_oh_value_ov := 0;

Line 1345: raise FND_API.G_EXC_ERROR;

1341: ,l_return_status
1342: ,l_msg_data
1343: ,l_msg_count);
1344: if l_return_status <> 'S' then
1345: raise FND_API.G_EXC_ERROR;
1346: end if;
1347: end if;
1348:
1349: create_budget_detail (

Line 1410: raise FND_API.G_EXC_ERROR;

1406: ,'E'
1407: ,l_rate_class_id_eb,l_rate_type_id_eb,l_return_status, l_msg_data);
1408:
1409: if l_return_status <> 'S' then
1410: raise FND_API.G_EXC_ERROR;
1411: end if;
1412: l_input_amount := rec_budget_details.line_item_cost;
1413:
1414: select max(end_date), max(start_date)

Line 1485: RAISE FND_API.G_EXC_ERROR;

1481: l_msg_data := 'IGW_PERIOD_NOT_CONSECUTIVE';
1482: l_return_status := 'E';
1483: fnd_message.set_name('IGW', 'IGW_PERIOD_NOT_CONSECUTIVE');
1484: fnd_msg_pub.add;
1485: RAISE FND_API.G_EXC_ERROR;
1486: end;
1487:
1488:
1489: create_budget_detail (

Line 1652: raise FND_API.G_EXC_ERROR;

1648: ,l_return_status
1649: ,l_msg_data
1650: ,l_msg_count);
1651: if l_return_status <> 'S' then
1652: raise FND_API.G_EXC_ERROR;
1653: end if;
1654: l_inflated_salary := rec_budget_personnel.percent_charged/100 * l_inflated_salary;
1655:
1656: if l_apply_rate_flag_oh = 'N' then

Line 1690: raise FND_API.G_EXC_ERROR;

1686: ,l_return_status
1687: ,l_msg_data
1688: ,l_msg_count);
1689: if l_return_status <> 'S' then
1690: raise FND_API.G_EXC_ERROR;
1691: end if;
1692:
1693: insert into igw_budget_personnel_details (
1694: budget_personnel_detail_id

Line 1916: RAISE FND_API.G_EXC_ERROR;

1912: l_return_status := 'S';
1913: fnd_message.set_name('IGW', 'IGW_BUDGET_PERIOD_NOT_EQUAL');
1914: fnd_msg_pub.add;
1915: --raised the error volutarily to get the message count
1916: RAISE FND_API.G_EXC_ERROR;
1917: end if;
1918:
1919: EXCEPTION
1920: when FND_API.G_EXC_ERROR then

Line 1920: when FND_API.G_EXC_ERROR then

1916: RAISE FND_API.G_EXC_ERROR;
1917: end if;
1918:
1919: EXCEPTION
1920: when FND_API.G_EXC_ERROR then
1921: x_return_status := l_return_status;
1922: x_msg_data := l_msg_data;
1923: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1924: p_data => x_msg_data);

Line 2005: when FND_API.G_EXC_ERROR then

2001: end if;
2002: x_return_status := 'S';
2003:
2004: EXCEPTION
2005: when FND_API.G_EXC_ERROR then
2006: x_return_status := l_return_status;
2007: x_msg_data := l_msg_data;
2008: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2009: p_data => x_msg_data);

Line 2099: Raise FND_API.G_EXC_ERROR;

2095:
2096: if l_personnel_attached_flag = 'Y' then
2097: fnd_message.set_name('IGW', 'IGW_NO_PERSONNEL_SYNC');
2098: fnd_msg_pub.add;
2099: Raise FND_API.G_EXC_ERROR;
2100: end if;
2101:
2102: begin
2103: select activity_type_code

Line 2160: (p_encoded => FND_API.G_TRUE ,

2156:
2157: If x_msg_count > 0 THEN
2158: If x_msg_count = 1 THEN
2159: fnd_msg_pub.get
2160: (p_encoded => FND_API.G_TRUE ,
2161: p_msg_index => 1,
2162: p_data => x_msg_data,
2163: p_msg_index_out => l_msg_index_out );
2164:

Line 2166: RAISE FND_API.G_EXC_ERROR;

2162: p_data => x_msg_data,
2163: p_msg_index_out => l_msg_index_out );
2164:
2165: End if;
2166: RAISE FND_API.G_EXC_ERROR;
2167: End if;
2168:
2169:
2170: update igw_budget_details

Line 2192: when FND_API.G_EXC_ERROR then

2188:
2189:
2190:
2191: Exception
2192: when FND_API.G_EXC_ERROR then
2193: --x_return_status := l_return_status;
2194: --x_msg_data := l_msg_data;
2195: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2196: p_data => x_msg_data);

Line 2248: when FND_API.G_EXC_ERROR then

2244: ,x_msg_data
2245: ,x_msg_count );
2246: end if;
2247: Exception
2248: when FND_API.G_EXC_ERROR then
2249: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2250: p_data => x_msg_data);
2251: when others then
2252: x_return_status := 'U';