DBA Data[Home] [Help]

APPS.GMS_BUDGET_UTILS dependencies on GMS_ERROR_PKG

Line 40: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_CORE_NO_VERSION_ID',

36: x_err_stack := old_stack;
37:
38: exception
39: when NO_DATA_FOUND then
40: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_CORE_NO_VERSION_ID',
41: x_err_code => x_err_code,
42: x_err_buff => x_err_stage);
43:
44: when others then

Line 45: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

41: x_err_code => x_err_code,
42: x_err_buff => x_err_stage);
43:
44: when others then
45: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
46: x_token_name1 => 'SQLCODE',
47: x_token_val1 => sqlcode,
48: x_token_name2 => 'SQLERRM',
49: x_token_val2 => sqlerrm,

Line 69: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_UTILS.GET_BASELINED_VERSION_ID ***','C');

65: old_stack varchar2(630);
66: begin
67:
68: IF L_DEBUG = 'Y' THEN
69: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_UTILS.GET_BASELINED_VERSION_ID ***','C');
70: END IF;
71:
72: x_err_code := 0;
73: old_stack := x_err_stack;

Line 90: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_UTILS.GET_BASELINED_VERSION_ID ***','C');

86:
87: x_err_stack := old_stack;
88:
89: IF L_DEBUG = 'Y' THEN
90: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_UTILS.GET_BASELINED_VERSION_ID ***','C');
91: END IF;
92:
93: exception
94: when NO_DATA_FOUND then

Line 96: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_CORE_NO_VERSION_ID',

92:
93: exception
94: when NO_DATA_FOUND then
95: x_err_stage:= 'GMS_BUDGET_UTILS.GET_BASELINED_VERSION_ID- In NO_DATA_FOUND exception';
96: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_CORE_NO_VERSION_ID',
97: x_err_code => x_err_code,
98: x_err_buff => x_err_stage);
99:
100: when others then

Line 102: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

98: x_err_buff => x_err_stage);
99:
100: when others then
101: x_err_stage:= 'GMS_BUDGET_UTILS.GET_BASELINED_VERSION_ID- In others exception';
102: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
103: x_token_name1 => 'SQLCODE',
104: x_token_val1 => sqlcode,
105: x_token_name2 => 'SQLERRM',
106: x_token_val2 => sqlerrm,

Line 144: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_CORE_NO_VERSION_ID',

140: x_err_stack := old_stack;
141:
142: exception
143: when NO_DATA_FOUND then
144: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_CORE_NO_VERSION_ID',
145: x_err_code => x_err_code,
146: x_err_buff => x_err_stage);
147:
148: when others then

Line 149: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

145: x_err_code => x_err_code,
146: x_err_buff => x_err_stage);
147:
148: when others then
149: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
150: x_token_name1 => 'SQLCODE',
151: x_token_val1 => sqlcode,
152: x_token_name2 => 'SQLERRM',
153: x_token_val2 => sqlerrm,

Line 245: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_ENTRY_NOT_ALLOWED',

241: end if;
242:
243: if (x_allow_budget_entry_flag = 'N') then
244:
245: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_ENTRY_NOT_ALLOWED',
246: x_err_code => x_err_code,
247: x_err_buff => x_err_stage);
248:
249: APP_EXCEPTION.RAISE_EXCEPTION;

Line 254: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_NO_DFLT_RESOURCE_LIST',

250:
251: end if;
252:
253: if (x_resource_list_id is null) then
254: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_NO_DFLT_RESOURCE_LIST',
255: x_err_code => x_err_code,
256: x_err_buff => x_err_stage);
257:
258: APP_EXCEPTION.RAISE_EXCEPTION;

Line 276: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

272:
273: exception
274: when others
275: then
276: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
277: x_token_name1 => 'SQLCODE',
278: x_token_val1 => sqlcode,
279: x_token_name2 => 'SQLERRM',
280: x_token_val2 => sqlerrm,

Line 340: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_ENTRY_NOT_ALLOWED',

336:
337: end if;
338:
339: if (x_allow_budget_entry_flag = 'N') then
340: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_ENTRY_NOT_ALLOWED',
341: x_err_code => x_err_code,
342: x_err_buff => x_err_stage);
343:
344: APP_EXCEPTION.RAISE_EXCEPTION;

Line 348: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_DFLT_ENTRY_METHOD',

344: APP_EXCEPTION.RAISE_EXCEPTION;
345: end if;
346:
347: if (x_budget_entry_method_code is null) then
348: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_DFLT_ENTRY_METHOD',
349: x_err_code => x_err_code,
350: x_err_buff => x_err_stage);
351:
352: APP_EXCEPTION.RAISE_EXCEPTION;

Line 366: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

362: x_err_stack := old_stack;
363:
364: exception
365: when others then
366: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
367: x_token_name1 => 'SQLCODE',
368: x_token_val1 => sqlcode,
369: x_token_name2 => 'SQLERRM',
370: x_token_val2 => sqlerrm,

Line 888: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES ***','C');

884:
885: BEGIN
886: -- dbms_output.put_line('GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES - Inside');
887: IF L_DEBUG = 'Y' THEN
888: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES ***','C');
889: gms_error_pkg.gms_debug('GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- p_event : '||p_event,'C');
890: END IF;
891:
892: -- Initialize OUT-parameters for multiple error messaging

Line 889: gms_error_pkg.gms_debug('GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- p_event : '||p_event,'C');

885: BEGIN
886: -- dbms_output.put_line('GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES - Inside');
887: IF L_DEBUG = 'Y' THEN
888: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES ***','C');
889: gms_error_pkg.gms_debug('GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- p_event : '||p_event,'C');
890: END IF;
891:
892: -- Initialize OUT-parameters for multiple error messaging
893:

Line 904: gms_error_pkg.gms_message( x_err_name => 'GMS_ALL_WARN_NO_EMPL_REC',

900: p_err_stack := p_err_stack || '->check_budget_rules';
901:
902: IF( PA_UTILS.GetEmpIdFromUser(p_created_by ) IS NULL) THEN
903: p_err_stage := 'GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- Error occurred while validating employee info';
904: gms_error_pkg.gms_message( x_err_name => 'GMS_ALL_WARN_NO_EMPL_REC',
905: x_err_code => p_err_code,
906: x_err_buff => p_err_stage);
907:
908: APP_EXCEPTION.RAISE_EXCEPTION;

Line 950: gms_error_pkg.gms_message( x_err_name => 'GMS_NO_BUDGET_LINES', -- 'GMS_BU_NO_BUDGET', Bug 2587078

946:
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: p_err_stage := 'GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- In NO_DATA_FOUND exception';
950: gms_error_pkg.gms_message( x_err_name => 'GMS_NO_BUDGET_LINES', -- 'GMS_BU_NO_BUDGET', Bug 2587078
951: x_err_code => p_err_code,
952: x_err_buff => p_err_stage);
953:
954: /* PA_UTILS.Add_Message

Line 966: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

962:
963: WHEN OTHERS
964: THEN
965: p_err_stage := 'GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- In OTHERS exception';
966: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
967: x_token_name1 => 'SQLCODE',
968: x_token_val1 => sqlcode,
969: x_token_name2 => 'SQLERRM',
970: x_token_val2 => sqlerrm,

Line 1025: gms_error_pkg.gms_debug('GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- GMS_CLIENT_EXTN_BUDGET.Verify_Budget_Rules returned failure status','C');

1021:
1022: IF (l_ext_err_msg_count > 0)
1023: THEN
1024: IF L_DEBUG = 'Y' THEN
1025: gms_error_pkg.gms_debug('GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- GMS_CLIENT_EXTN_BUDGET.Verify_Budget_Rules returned failure status','C');
1026: END IF;
1027:
1028: IF (l_ext_warnings_only_flag = 'N') THEN
1029: p_warnings_only_flag := 'N';

Line 1037: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES ***','C');

1033: p_err_msg_count := FND_MSG_PUB.Count_Msg;
1034: p_err_stack := l_old_stack;
1035:
1036: IF L_DEBUG = 'Y' THEN
1037: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES ***','C');
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN OTHERS

Line 1045: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

1041: WHEN OTHERS
1042: THEN
1043:
1044: p_err_stage := 'GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES- In others exception';
1045: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
1046: x_token_name1 => 'SQLCODE',
1047: x_token_val1 => sqlcode,
1048: x_token_name2 => 'SQLERRM',
1049: x_token_val2 => sqlerrm,

Line 1187: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

1183: x_err_stack := old_stack;
1184:
1185: exception
1186: when others then
1187: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
1188: x_token_name1 => 'SQLCODE',
1189: x_token_val1 => sqlcode,
1190: x_token_name2 => 'SQLERRM',
1191: x_token_val2 => sqlerrm,

Line 1353: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES ***','C');

1349: BEGIN
1350: x_err_code := 0;
1351:
1352: IF L_DEBUG = 'Y' THEN
1353: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES ***','C');
1354: END IF;
1355:
1356: -- Standard begin of API savepoint
1357:

Line 1364: gms_error_pkg.gms_message(x_err_name => 'GMS_SU_INVALID_DATES',

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',
1365: x_err_code => x_err_code,
1366: x_err_buff => x_err_stage);
1367:
1368: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1392: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_MISSING',

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,
1394: x_err_buff => x_err_stage);
1395:
1396: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1413: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_INVALID',

1409: IF l_period_name_csr%NOTFOUND
1410: THEN
1411: CLOSE l_period_name_csr;
1412: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- Error occurred while calculating dates for Time phase = PA/GL';
1413: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_INVALID',
1414: x_err_code => x_err_code,
1415: x_err_buff => x_err_stage);
1416:
1417: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1442: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',

1438: IF l_budget_periods_csr%NOTFOUND
1439: THEN
1440: CLOSE l_budget_periods_csr;
1441: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- Error occurred while calculating dates for Time phase = PA/GL';
1442: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',
1443: x_err_code => x_err_code,
1444: x_err_buff => x_err_stage);
1445:
1446: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1466: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_MISSING' ,-- 'GMS_START_DATE_IS_MISSING', Bug 2587078

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
1467: x_err_code => x_err_code,
1468: x_err_buff => x_err_stage);
1469:
1470: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1477: gms_error_pkg.gms_message( x_err_name => 'GMS_BUDGET_DATES_MISSING', -- 'GMS_END_DATE_IS_MISSING', Bug 2587078

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
1478: x_err_code => x_err_code,
1479: x_err_buff => x_err_stage);
1480:
1481: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1510: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE' , --'GMS_PROJ_START_DATE_MISS1', 2587078

1506:
1507: IF l_project_start_date IS NULL
1508: THEN
1509: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- Error occurred while calculating dates for Time phase = N and entry level code ='||p_entry_level_code;
1510: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE' , --'GMS_PROJ_START_DATE_MISS1', 2587078
1511: x_err_code => x_err_code,
1512: x_err_buff => x_err_stage);
1513:
1514: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1521: gms_error_pkg.gms_message( x_err_name => 'GMS_PROJ_END_DATE_MISS1',

1517: /************Commenting the code for Bug 2200867
1518: ELSIF l_project_end_date IS NULL
1519: THEN
1520:
1521: gms_error_pkg.gms_message( x_err_name => 'GMS_PROJ_END_DATE_MISS1',
1522: x_err_code => x_err_code,
1523: x_err_buff => x_err_stage);
1524:
1525: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1558: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE' , -- 'GMS_PROJ_START_DATE_MISS2', 2587078

1554:
1555: IF l_project_start_date IS NULL --implies that project end date is null too
1556: THEN
1557: x_err_stage := 'GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- Error occurred while calculating dates for Time phase = N and entry level code ='||p_entry_level_code;
1558: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE' , -- 'GMS_PROJ_START_DATE_MISS2', 2587078
1559: x_err_code => x_err_code,
1560: x_err_buff => x_err_stage);
1561:
1562: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1584: gms_error_pkg.gms_message( x_err_name => 'GMS_PROJ_END_DATE_MISS2',

1580: p_period_name_out := p_period_name_in;
1581: /*****************Commenting for Bug 2200867
1582: ELSIF l_project_end_date IS NULL
1583: THEN
1584: gms_error_pkg.gms_message( x_err_name => 'GMS_PROJ_END_DATE_MISS2',
1585: x_err_code => x_err_code,
1586: x_err_buff => x_err_stage);
1587:
1588: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1605: gms_error_pkg.gms_message( x_err_name => 'GMS_PROJ_END_DATE_MISS3',

1601:
1602: IF l_project_end_date IS NULL
1603: THEN
1604:
1605: gms_error_pkg.gms_message( x_err_name => 'GMS_PROJ_END_DATE_MISS3',
1606: x_err_code => x_err_code,
1607: x_err_buff => x_err_stage);
1608:
1609: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1641: gms_error_pkg.gms_debug('GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- In OTHERS exception','C');

1637: EXCEPTION
1638: WHEN OTHERS
1639: THEN
1640: IF L_DEBUG = 'Y' THEN
1641: gms_error_pkg.gms_debug('GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES- In OTHERS exception','C');
1642: END IF;
1643:
1644: ROLLBACK TO get_valid_period_dates_pvt;
1645:

Line 1651: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES ***','C');

1647: x_err_stage := 'GMS_GET_PERIOD_DATE_FAIL';
1648: **/
1649:
1650: IF L_DEBUG = 'Y' THEN
1651: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_UTILS.GET_VALID_PERIOD_DATES ***','C');
1652: END IF;
1653:
1654: END get_valid_period_dates;
1655:

Line 1726: gms_error_pkg.gms_message( x_err_name => 'GMS_COST_QTY_NOT_ALLOWED',

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,
1728: x_err_buff => x_err_stage);
1729:
1730: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1735: gms_error_pkg.gms_message( x_err_name => 'GMS_RAW_COST_NOT_ALLOWED',

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,
1737: x_err_buff => x_err_stage);
1738:
1739: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1745: gms_error_pkg.gms_message( x_err_name => 'GMS_BURD_COST_NOT_ALLOWED',

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,
1747: x_err_buff => x_err_stage);
1748:
1749: APP_EXCEPTION.RAISE_EXCEPTION;