DBA Data[Home] [Help]

APPS.IGW_OVERHEAD_CAL dependencies on FND_API

Line 268: raise FND_API.G_EXC_ERROR;

264: ,l_start_f_end_date
265: ,l_return_status
266: ,l_msg_data);
267: if l_return_status <> 'S' then
268: raise FND_API.G_EXC_ERROR;
269: end if;
270:
271: get_date_details(p_budget_end_date
272: ,l_end_fiscal_year

Line 279: raise FND_API.G_EXC_ERROR;

275: ,l_return_status
276: ,l_msg_data);
277:
278: if l_return_status <> 'S' then
279: raise FND_API.G_EXC_ERROR;
280: end if;
281: l_fiscal_diff := (l_end_fiscal_year - l_start_fiscal_year) +1;
282: l_start_date := p_budget_start_date;
283: l_new_fiscal_year := l_start_fiscal_year;

Line 306: raise FND_API.G_EXC_ERROR;

302: ,l_return_status
303: ,l_msg_data);
304:
305: if l_return_status NOT IN ('S','I') then
306: raise FND_API.G_EXC_ERROR;
307: end if;
308:
309: --dbms_output.put_line('the oh_rate is '||l_oh_rate);
310: --dbms_output.put_line('the l_no_of_days '||l_no_of_days);

Line 339: when FND_API.G_EXC_ERROR then

335:
336: END LOOP;
337: x_return_status := 'S';
338: EXCEPTION
339: when FND_API.G_EXC_ERROR then
340: x_return_status := l_return_status;
341: x_msg_data := l_msg_data;
342: fnd_msg_pub.count_and_get(p_count => x_msg_count,
343: p_data => x_msg_data);

Line 404: raise FND_API.G_EXC_ERROR;

400: ,l_return_status
401: ,l_msg_data);
402:
403: if l_return_status <> 'S' then
404: raise FND_API.G_EXC_ERROR;
405: end if;
406:
407: get_date_details(p_budget_end_date
408: ,l_end_fiscal_year

Line 415: raise FND_API.G_EXC_ERROR;

411: ,l_return_status
412: ,l_msg_data);
413:
414: if l_return_status <> 'S' then
415: raise FND_API.G_EXC_ERROR;
416: end if;
417: l_fiscal_diff := (l_end_fiscal_year - l_start_fiscal_year) +1;
418: --dbms_output.put_line('the fiscal diff is '||l_fiscal_diff);
419: l_start_date := p_budget_start_date;

Line 424: raise FND_API.G_EXC_ERROR;

420: l_new_fiscal_year := l_start_fiscal_year;
421: l_end_date := l_start_f_end_date;
422:
423: if l_return_status <> 'S' then
424: raise FND_API.G_EXC_ERROR;
425: end if;
426:
427: for i IN 1 .. l_fiscal_diff
428: LOOP

Line 449: raise FND_API.G_EXC_ERROR;

445: ,l_msg_data);
446: --dbms_output.put_line('the rate for eb is '||l_rate);
447: --dbms_output.put_line('the rate for eb_ov is '||l_rate_ov);
448: if l_return_status NOT IN ('S','I') then
449: raise FND_API.G_EXC_ERROR;
450: end if;
451:
452: l_eb := nvl(p_base_amount * ((l_end_date - l_start_date)+ 1)/l_no_of_days
453: * nvl(l_rate,0)/100,0);

Line 476: raise FND_API.G_EXC_ERROR;

472: ,l_return_status
473: ,l_msg_data);
474: --dbms_output.put_line('the rate for oh is '||l_rate);
475: if l_return_status NOT IN ('S','I') then
476: raise FND_API.G_EXC_ERROR;
477: end if;
478:
479:
480: l_oh := ((p_base_amount + ((nvl(l_eb,0) * l_no_of_days/((l_end_date - l_start_date)+ 1)))) *

Line 511: when FND_API.G_EXC_ERROR then

507: END LOOP;
508: x_return_status := 'S';
509:
510: EXCEPTION
511: when FND_API.G_EXC_ERROR then
512: x_return_status := l_return_status;
513: x_msg_data := l_msg_data;
514: fnd_msg_pub.count_and_get(p_count => x_msg_count,
515: p_data => x_msg_data);

Line 575: raise FND_API.G_EXC_ERROR;

571: ,l_start_f_end_date
572: ,l_return_status
573: ,l_msg_data);
574: if l_return_status <> 'S' then
575: raise FND_API.G_EXC_ERROR;
576: end if;
577:
578: get_date_details(p_budget_end_date
579: ,l_end_fiscal_year

Line 586: raise FND_API.G_EXC_ERROR;

582: ,l_return_status
583: ,l_msg_data);
584:
585: if l_return_status <> 'S' then
586: raise FND_API.G_EXC_ERROR;
587: end if;
588:
589: /*fiscal diff is calculated to seed how many fiscal years
590: is a period spans into */

Line 617: raise FND_API.G_EXC_ERROR;

613: ,l_rate_start_date
614: ,l_return_status
615: ,l_msg_data);
616: if l_return_status NOT IN ('S','I') then
617: raise FND_API.G_EXC_ERROR;
618: end if;
619: /*
620: --dbms_output.put_line('the inflated_rate is '||l_inflated_rate);
621: --dbms_output.put_line('the l_no_of_days '||l_no_of_days);

Line 648: when FND_API.G_EXC_ERROR then

644: END LOOP;
645: x_inflated_amt := l_base_amount + x_inflated_amt;
646: x_return_status := 'S';
647: EXCEPTION
648: when FND_API.G_EXC_ERROR then
649: x_return_status := l_return_status;
650: x_msg_data := l_msg_data;
651: fnd_msg_pub.count_and_get(p_count => x_msg_count,
652: p_data => x_msg_data);

Line 797: raise FND_API.G_EXC_ERROR;

793: ,l_effect_f_end_date
794: ,l_return_status
795: ,l_msg_data);
796: if l_return_status <> 'S' then
797: raise FND_API.G_EXC_ERROR;
798: end if;
799: get_date_details(p_line_start_date
800: ,l_start_fiscal_year
801: ,l_start_f_start_date

Line 808: raise FND_API.G_EXC_ERROR;

804: ,l_msg_data);
805: --dbms_output.put_line('the l_start_fiscal_year is '||l_start_fiscal_year);
806: --dbms_output.put_line('the l_start_f_end_date is '||l_start_f_end_date);
807: if l_return_status <> 'S' then
808: raise FND_API.G_EXC_ERROR;
809: end if;
810: get_date_details(p_line_end_date
811: ,l_end_fiscal_year
812: ,l_end_f_start_date

Line 819: raise FND_API.G_EXC_ERROR;

815: ,l_msg_data);
816: --dbms_output.put_line('the l_end_fiscal_year is '||l_end_fiscal_year);
817:
818: if l_return_status <> 'S' then
819: raise FND_API.G_EXC_ERROR;
820: end if;
821: l_loop_counter := (l_start_fiscal_year - l_effect_fiscal_year) + 1;
822: --dbms_output.put_line('the loop counter l_loop_counter is '||l_loop_counter);
823: l_new_fiscal_year := l_effect_fiscal_year;

Line 835: raise FND_API.G_EXC_ERROR;

831: --dbms_output.put_line('the l_rate_class_id_inf is '||l_rate_class_id_inf);
832: --dbms_output.put_line('the l_rate_type_id_inf is '||l_rate_type_id_inf);
833:
834: if l_return_status <> 'S' then
835: raise FND_API.G_EXC_ERROR;
836: end if;
837:
838: /*the following code inflates the salary(if any) till the period line
839: start date including the first day of the period start date. */

Line 861: raise FND_API.G_EXC_ERROR;

857: --dbms_output.put_line('the l_rate_start_date for inflation is '||l_rate_start_date);
858: --dbms_output.put_line('the l_inflation_rate is '|| l_inflation_rate);
859: --dbms_output.put_line('the l_inflation_rate_ov is '|| l_inflation_rate_ov);
860: if l_return_status NOT IN ('S','I') then
861: raise FND_API.G_EXC_ERROR;
862: end if;
863: if l_inflation_rate is not null then
864: if i = 1 and l_rate_start_date <= p_effective_date then
865: l_base_amount := l_base_amount;

Line 904: raise FND_API.G_EXC_ERROR;

900: ,l_return_status
901: ,l_msg_data);
902:
903: if l_return_status <> 'S' then
904: raise FND_API.G_EXC_ERROR;
905: end if;
906:
907: calc_sal_between_months(l_end_date
908: ,l_start_date

Line 915: raise FND_API.G_EXC_ERROR;

911: ,l_return_status
912: ,l_msg_data);
913:
914: if l_return_status <> 'S' then
915: raise FND_API.G_EXC_ERROR;
916: end if;
917:
918: x_inflated_salary := l_final_amount;
919: x_inflated_salary_ov := l_final_amount_ov;

Line 940: raise FND_API.G_EXC_ERROR;

936: ,l_return_status
937: ,l_msg_data);
938:
939: if l_return_status <> 'S' then
940: raise FND_API.G_EXC_ERROR;
941: end if;
942:
943: calc_sal_between_months(l_end_date
944: ,l_start_date

Line 950: raise FND_API.G_EXC_ERROR;

946: ,l_final_amount1_ov
947: ,l_return_status
948: ,l_msg_data);
949: if l_return_status <> 'S' then
950: raise FND_API.G_EXC_ERROR;
951: end if;
952:
953: l_start_date := rec_inf_rates.start_date;
954:

Line 1009: raise FND_API.G_EXC_ERROR;

1005: ,l_return_status
1006: ,l_msg_data);
1007:
1008: if l_return_status <> 'S' then
1009: raise FND_API.G_EXC_ERROR;
1010: end if;
1011: --dbms_output.put_line('l_final_amount2 is '||l_final_amount2);
1012:
1013: calc_sal_between_months(l_end_date

Line 1020: raise FND_API.G_EXC_ERROR;

1016: ,l_final_amount2_ov
1017: ,l_return_status
1018: ,l_msg_data);
1019: if l_return_status <> 'S' then
1020: raise FND_API.G_EXC_ERROR;
1021: end if;
1022:
1023: l_final_amount := nvl(l_final_amount,0)+ nvl(l_final_amount2,0);
1024:

Line 1033: when FND_API.G_EXC_ERROR then

1029: x_inflated_salary_ov := l_final_amount_ov;
1030: end if;
1031: x_return_status := 'S';
1032: EXCEPTION
1033: when FND_API.G_EXC_ERROR then
1034: x_return_status := l_return_status;
1035: x_msg_data := l_msg_data;
1036: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1037: p_data => x_msg_data);