DBA Data[Home] [Help]

APPS.GMS_BUDGET_UTILS dependencies on GMS_BUDGET_PUB

Line 1360: -- The following IF statement is added for Bug:2362968 (GMS_BUDGET_PUB.ADD_BUDGET_LINE ACCEPTING INVALID DATES)

1356: -- Standard begin of API savepoint
1357:
1358: SAVEPOINT get_valid_period_dates_pvt;
1359:
1360: -- The following IF statement is added for Bug:2362968 (GMS_BUDGET_PUB.ADD_BUDGET_LINE ACCEPTING INVALID DATES)
1361:
1362: IF p_budget_start_date_in > p_budget_end_date_in THEN
1363: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- Error occured while validating the dates';
1364: gms_error_pkg.gms_message(x_err_name => 'GMS_SU_INVALID_DATES',

Line 1383: OR p_period_name_in = GMS_BUDGET_PUB.G_PA_MISS_CHAR

1379: -- dbms_output.put_line('Time phased code: '||p_time_phased_type_code);
1380: -- dbms_output.put_line('Period name : '||p_period_name_in);
1381:
1382: IF p_period_name_in IS NULL
1383: OR p_period_name_in = GMS_BUDGET_PUB.G_PA_MISS_CHAR
1384: THEN
1385:
1386: IF p_budget_start_date_in IS NULL
1387: OR p_budget_start_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE

Line 1387: OR p_budget_start_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE

1383: OR p_period_name_in = GMS_BUDGET_PUB.G_PA_MISS_CHAR
1384: THEN
1385:
1386: IF p_budget_start_date_in IS NULL
1387: OR p_budget_start_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE
1388: OR p_budget_end_date_in IS NULL
1389: OR p_budget_end_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE
1390: THEN
1391: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- error occurred while calculating dates for Time phase = PA/GL';

Line 1389: OR p_budget_end_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE

1385:
1386: IF p_budget_start_date_in IS NULL
1387: OR p_budget_start_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE
1388: OR p_budget_end_date_in IS NULL
1389: OR p_budget_end_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE
1390: THEN
1391: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- error occurred while calculating dates for Time phase = PA/GL';
1392: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_MISSING',
1393: x_err_code => x_err_code,

Line 1462: IF p_budget_start_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE

1458: THEN
1459:
1460: --validation of incoming dates
1461:
1462: IF p_budget_start_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE
1463: OR p_budget_start_date_in IS NULL
1464: THEN
1465: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- Error occurred while calculating dates for Time phase = R';
1466: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_MISSING' ,-- 'GMS_START_DATE_IS_MISSING', Bug 2587078

Line 1473: IF p_budget_end_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE

1469:
1470: APP_EXCEPTION.RAISE_EXCEPTION;
1471: END IF;
1472:
1473: IF p_budget_end_date_in = GMS_BUDGET_PUB.G_PA_MISS_DATE
1474: OR p_budget_end_date_in IS NULL
1475: THEN
1476: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- Error occurred while calculating dates for Time phase = R';
1477: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_MISSING', -- 'GMS_END_DATE_IS_MISSING', Bug 2587078

Line 1633: -- Commented out NOCOPY the Exception section as a part of Bug:2362968 (GMS_BUDGET_PUB.ADD_BUDGET_LINE ACCEPTING INVALID DATES)

1629:
1630: END IF; --time phased type code
1631:
1632: /**
1633: -- Commented out NOCOPY the Exception section as a part of Bug:2362968 (GMS_BUDGET_PUB.ADD_BUDGET_LINE ACCEPTING INVALID DATES)
1634: -- since there is no necessity to rollback anything here and also commenting this out NOCOPY will cause the actual error message
1635: -- to show up during any error condition.
1636:
1637: EXCEPTION

Line 1723: AND ( p_quantity <> GMS_BUDGET_PUB.G_PA_MISS_NUM

1719:
1720: IF p_budget_amount_code = 'C' --COST BUDGET
1721: THEN
1722: IF l_cost_quantity_flag = 'N'
1723: AND ( p_quantity <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1724: AND p_quantity IS NOT NULL )
1725: THEN
1726: gms_error_pkg.gms_message( x_err_name => 'GMS_COST_QTY_NOT_ALLOWED',
1727: x_err_code => x_err_code,

Line 1732: AND ( p_raw_cost <> GMS_BUDGET_PUB.G_PA_MISS_NUM

1728: x_err_buff => x_err_stage);
1729:
1730: APP_EXCEPTION.RAISE_EXCEPTION;
1731: ELSIF l_raw_cost_flag = 'N'
1732: AND ( p_raw_cost <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1733: AND p_raw_cost IS NOT NULL )
1734: THEN
1735: gms_error_pkg.gms_message( x_err_name => 'GMS_RAW_COST_NOT_ALLOWED',
1736: x_err_code => x_err_code,

Line 1742: AND ( p_burdened_cost <> GMS_BUDGET_PUB.G_PA_MISS_NUM

1738:
1739: APP_EXCEPTION.RAISE_EXCEPTION;
1740:
1741: ELSIF l_burdened_cost_flag = 'N'
1742: AND ( p_burdened_cost <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1743: AND p_burdened_cost IS NOT NULL )
1744: THEN
1745: gms_error_pkg.gms_message( x_err_name => 'GMS_BURD_COST_NOT_ALLOWED',
1746: x_err_code => x_err_code,