49: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
50: x_err_code => x_err_code,
51: x_err_buff => x_err_stage);
52:
53: APP_EXCEPTION.RAISE_EXCEPTION;
54: end if;
55:
56: open c;
57: for i in 1..abs(x_periods)
72: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
73: x_err_code => x_err_code,
74: x_err_buff => x_err_stage);
75:
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: end if;
78:
79: open c1;
80: for i in 1..abs(x_periods)
153: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
154: x_err_code => x_err_code,
155: x_err_buff => x_err_stage);
156:
157: APP_EXCEPTION.RAISE_EXCEPTION;
158: end if;
159:
160: -- the new budget starts later than the source budget.
161: -- identify the period by advancing the index to the appropriate period.
182: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
183: x_err_code => x_err_code,
184: x_err_buff => x_err_stage);
185:
186: APP_EXCEPTION.RAISE_EXCEPTION;
187: end if;
188:
189: -- the new budget starts earlier than the source budget.
190: -- identify the period by moving back the index to the appropriate period.
405: x_err_buff => x_err_stage);
406:
407: fnd_msg_pub.add; --Bug 2587078
408:
409: APP_EXCEPTION.RAISE_EXCEPTION;
410: end if;
411:
412: x_err_stage := 'get draft budget info <' || to_char(x_draft_version_id)
413: || '>';
860: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',
861: x_err_code => x_err_code,
862: x_err_buff => x_err_stage);
863: fnd_msg_pub.add; --Bug 2587078
864: APP_EXCEPTION.RAISE_EXCEPTION;
865:
866: end if;
867:
868: update gms_budget_lines
905: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',
906: x_err_code => x_err_code,
907: x_err_buff => x_err_stage);
908: fnd_msg_pub.add; --Bug 2587078
909: APP_EXCEPTION.RAISE_EXCEPTION;
910:
911: end if;
912:
913: update gms_budget_lines
1073: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_BASE_RES_LIST_EXISTS',
1074: x_err_code => x_err_code,
1075: x_err_buff => x_err_stage);
1076:
1077: APP_EXCEPTION.RAISE_EXCEPTION;
1078:
1079: end if;
1080:
1081: x_baselined_exists := TRUE;
1120: gms_error_pkg.gms_message( x_err_name => 'GMS_DELETE_DRAFT_FAILED',
1121: x_err_code => x_err_code,
1122: x_err_buff => x_err_stage);
1123:
1124: APP_EXCEPTION.RAISE_EXCEPTION;
1125: end if;
1126:
1127: /* Only check at baseline
1128: if (x_baselined_exists = FALSE) then
1228: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_PERIOD_FAIL',
1229: x_err_code => x_err_code,
1230: x_err_buff => x_err_stage);
1231:
1232: APP_EXCEPTION.RAISE_EXCEPTION;
1233: end if;
1234:
1235:
1236:
1249: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_SHIFT_PERIOD_FAIL',
1250: x_err_code => x_err_code,
1251: x_err_buff => x_err_stage);
1252:
1253: APP_EXCEPTION.RAISE_EXCEPTION;
1254: end if;
1255:
1256: end if;
1257:
1372: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_COPY_LINES_FAIL',
1373: x_err_code => x_err_code,
1374: x_err_buff => x_err_stage);
1375:
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377: end if;
1378:
1379: -- Copy attachments for every draft budget copied
1380:
1399: gms_error_pkg.gms_message( x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
1400: x_err_code => x_err_code,
1401: x_err_buff => x_err_stage);
1402:
1403: APP_EXCEPTION.RAISE_EXCEPTION;
1404:
1405: end if;
1406:
1407: x_err_stack := old_stack;
1612: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_PERIOD_FAIL',
1613: x_err_code => x_err_code,
1614: x_err_buff => x_err_stage);
1615:
1616: APP_EXCEPTION.RAISE_EXCEPTION;
1617: end if;
1618:
1619: x_err_stage := 'Shifting line budget period <'|| to_char(x_src_version_id);
1620: shift_periods(budget_line_row.start_date,
1631: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_SHIFT_PERIOD_FAIL',
1632: x_err_code => x_err_code,
1633: x_err_buff => x_err_stage);
1634:
1635: APP_EXCEPTION.RAISE_EXCEPTION;
1636: end if;
1637:
1638: end if;
1639:
2056: EXCEPTION
2057: WHEN NO_DATA_FOUND THEN
2058: fnd_message.set_name ('GMS', 'GMS_BU_ACCUMS_NOT_EXIST');
2059: fnd_message.set_token('RES_LIST',x_resource_list_name);
2060: app_exception.raise_exception;
2061: END;
2062:
2063: BEGIN
2064:
2293: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_TIME_PHASED', -- cannot copy-actual for a non-time phased/date range budgets
2294: x_err_code => x_err_code,
2295: x_err_buff => x_err_stage);
2296:
2297: APP_EXCEPTION.RAISE_EXCEPTION;
2298: end if;
2299:
2300: x_err_stage := 'get uncategorized resource list member id';
2301:
2359: x_current_budget_version_id,
2360: x_start_period_start_date,
2361: x_end_period_end_date
2362: ) THEN
2363: app_exception.raise_exception;
2364: -- end of code added for bug 1831151
2365:
2366: END IF;
2367: x_err_stage := 'delete budget lines <' || to_char(x_version_id)
2404: gms_error_pkg.gms_message( x_err_name => 'GMS_DELETE_BUDGET_LINE_FAIL',
2405: x_err_code => x_err_code,
2406: x_err_buff => x_err_stage);
2407:
2408: APP_EXCEPTION.RAISE_EXCEPTION;
2409: END IF;
2410:
2411: end loop;
2412: -- process every period between the starting period and ending period
2457: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2458: x_err_code => x_err_code,
2459: x_err_buff => x_err_stage);
2460:
2461: APP_EXCEPTION.RAISE_EXCEPTION;
2462: end if;
2463:
2464:
2465: if (nvl(x_burdened_cost,0) <> 0) then
2489: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2490: x_err_code => x_err_code,
2491: x_err_buff => x_err_stage);
2492: x_funding_status := 0;
2493: APP_EXCEPTION.RAISE_EXCEPTION;
2494: end if;
2495: end if;
2496:
2497: else
2542: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2543: x_err_code => x_err_code,
2544: x_err_buff => x_err_stage);
2545:
2546: APP_EXCEPTION.RAISE_EXCEPTION;
2547: end if;
2548:
2549: if( nvl(x_burdened_cost,0) <> 0) then
2550:
2573: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2574: x_err_code => x_err_code,
2575: x_err_buff => x_err_stage);
2576: x_funding_status := 0;
2577: APP_EXCEPTION.RAISE_EXCEPTION;
2578: end if;
2579:
2580: end if;
2581:
2621: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2622: x_err_code => x_err_code,
2623: x_err_buff => x_err_stage);
2624:
2625: APP_EXCEPTION.RAISE_EXCEPTION;
2626: end if;
2627: -- commented for bug 1831151
2628: /* if x_budget_amount_code = 'C' then
2629: x_revenue := null;
2663: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2664: x_err_code => x_err_code,
2665: x_err_buff => x_err_stage);
2666: x_funding_status := 0;
2667: APP_EXCEPTION.RAISE_EXCEPTION;
2668: end if;
2669: end if;
2670:
2671: else
2718: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2719: x_err_code => x_err_code,
2720: x_err_buff => x_err_stage);
2721:
2722: APP_EXCEPTION.RAISE_EXCEPTION;
2723: end if;
2724: if (nvl(x_burdened_cost,0) <> 0) then
2725: gms_budget_pub.add_budget_line(
2726: p_api_version_number => 1.0
2747: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2748: x_err_code => x_err_code,
2749: x_err_buff => x_err_stage);
2750: x_funding_status := 0;
2751: APP_EXCEPTION.RAISE_EXCEPTION;
2752: end if;
2753:
2754: end if;
2755:
2799: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2800: x_err_code => x_err_code,
2801: x_err_buff => x_err_stage);
2802:
2803: APP_EXCEPTION.RAISE_EXCEPTION;
2804: end if;
2805: if (nvl(x_burdened_cost,0) <> 0) then
2806: gms_budget_pub.add_budget_line(
2807: p_api_version_number => 1.0
2827: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2828: x_err_code => x_err_code,
2829: x_err_buff => x_err_stage);
2830: x_funding_status := 0;
2831: APP_EXCEPTION.RAISE_EXCEPTION;
2832: end if;
2833:
2834: end if;
2835:
2882: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2883: x_err_code => x_err_code,
2884: x_err_buff => x_err_stage);
2885:
2886: APP_EXCEPTION.RAISE_EXCEPTION;
2887: end if;
2888: if (nvl(x_burdened_cost,0) <> 0) then
2889:
2890: gms_budget_pub.add_budget_line(
2911: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2912: x_err_code => x_err_code,
2913: x_err_buff => x_err_stage);
2914: x_funding_status := 0;
2915: APP_EXCEPTION.RAISE_EXCEPTION;
2916: end if;
2917:
2918: end if;
2919: